{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Cover","Navigator","Style Guide","Model Parameters","Datasheet","Sorting Text","Dynamic Sorting","Error Checks"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":13,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[16,2,16,9],[17,2,17,9],[20,6,20,8],[21,6,21,8]]}
[]
[]
["Navigator"]
[]
[null,null,{"$f":"Client_Name","v":"SumProduct Pty Ltd"}]
[null,null,{"$f":"Model_Name","v":"SP Sorting Examples.xlsm"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Primary Developer:  Liam Bastick"]
[]
[null,null,"General Cover Notes:"]
[null,null,"Various sorting examples."]
[]
[]
[]
[null,null,"Any queries, please e-mail:",null,null,null,"liam.bastick@sumproduct.com"]
[null,null,"Website:",null,null,null,"www.sumproduct.com"]

{"sheet":"Navigator","index":1,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Navigator"]
[{"$f":"Model_Name","v":"SP Sorting Examples.xlsm"}]
["Navigator"]
[null,null,null,null,"Error Checks:",null,{"$f":"Overall_Error_Check","v":0}]
[]
[]
[null,1,"Table of Contents"]
[]
[null,null,null,null,null,"Cover"]
[null,null,null,null,null,"Style Guide"]
[null,null,null,null,null,"Model Parameters"]
[null,null,null,null,null,"Datasheet"]
[null,null,null,null,null,"Sorting Text"]
[null,null,null,null,null,"Dynamic Sorting"]
[null,null,null,null,null,"Error Checks"]

{"sheet":"Style Guide","index":2,"n_rows":74,"n_cols":11,"rows_kept":74,"cut":false,"hidden":false,"merged":[[80,2,80,6],[74,2,74,6],[75,2,75,6],[76,2,76,6],[77,2,77,6],[78,2,78,6],[79,2,79,6],[73,2,73,6],[62,2,62,6],[63,2,63,6],[64,2,64,6],[65,2,65,6],[66,2,66,6],[67,2,67,6],[68,2,68,6],[69,2,69,6],[70,2,70,6],[71,2,71,6],[72,2,72,6],[61,2,61,6],[47,2,47,6],[48,2,48,6],[49,2,49,6],[50,2,50,6],[51,2,51,6],[52,2,52,6],[53,2,53,6],[54,2,54,6],[57,2,57,6],[59,2,59,6],[60,2,60,6],[46,2,46,6],[35,2,35,6],[36,2,36,6],[37,2,37,6],[38,2,38,6],[39,2,39,6],[40,2,40,6],[41,2,41,6],[42,2,42,6],[43,2,43,6],[44,2,44,6],[45,2,45,6],[34,2,34,6],[17,2,17,6],[18,2,18,6],[19,2,19,6],[24,2,24,6],[25,2,25,6],[26,2,26,6],[27,2,27,6],[28,2,28,6],[29,2,29,6],[30,2,30,6],[31,2,31,6],[16,2,16,6],[2,0,2,4],[7,2,7,6],[8,2,8,6],[9,2,9,6],[10,2,10,6],[11,2,11,6],[12,2,12,6],[13,2,13,6],[14,2,14,6],[15,2,15,6]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Style Guide"}]
[{"$f":"Model_Name","v":"SP Sorting Examples.xlsm"}]
["Navigator"]
[null,null,null,null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"Formatting of Headers / Dividers"]
[]
[null,null,"Description",null,null,null,null,null,"Display",null,"Style Name"]
[]
[null,null,"Sheet Title",null,null,null,null,null,{"$f":"C10","v":"Sheet Title"},null,"Sheet Title"]
[null,null,"Model Name",null,null,null,null,null,{"$f":"C11","v":"Model Name"},null,"Model Name"]
[]
[null,null,"Header 1",null,null,null,null,null,{"$f":"C13","v":"Header 1"},null,"Header 1"]
[null,null,"Header 2",null,null,null,null,null,{"$f":"C14","v":"Header 2"},null,"Header 2"]
[null,null,"Header 3",null,null,null,null,null,{"$f":"C15","v":"Header 3"},null,"Header 3"]
[null,null,"Header 4",null,null,null,null,null,{"$f":"C16","v":"Header 4"},null,"Header 4"]
[]
[null,null,"Notes",null,null,null,null,null,{"$f":"C18","v":"Notes"},null,"Notes"]
[]
[null,null,"Table Heading",null,null,null,null,null,{"$f":"C20","v":"Table Heading"},null,"Table Heading"]
[]
[]
[null,{"$f":"MAX($B$5:$B22)+1","v":2},"Individual Cell Styles"]
[]
[null,null,"Description",null,null,null,null,null,"Display",null,"Style Name"]
[]
[null,null,"Assumption",null,null,null,null,null,"Assumption",null,{"$f":"C27","v":"Assumption"}]
[]
[null,null,"Constraint",null,null,null,null,null,{"$f":"C29","v":"Constraint"},null,{"$f":"C29","v":"Constraint"}]
[]
[null,null,"Empty",null,null,null,null,null,null,null,{"$f":"C31","v":"Empty"}]
[]
[null,null,"Error Check",null,null,null,null,null,0,null,{"$f":"C33","v":"Error Check"}]
[]
[null,null,"Hyperlink",null,null,null,null,null,"Hyperlink",null,{"$f":"C35","v":"Hyperlink"}]
[]
[null,null,"Internal Reference",null,null,null,null,null,{"$f":"'Error Checks'!E12","v":"None"},null,{"$f":"C37","v":"Internal Reference"}]
[]
[null,null,"Line Calculation",null,null,null,null,null,77,null,"Line Calc"]
[]
[null,null,"Line Total",null,null,null,null,null,{"$f":"I39","v":77},null,{"$f":"C41","v":"Line Total"}]
[]
[null,null,"Parameter",null,null,null,null,null,365,null,{"$f":"C43","v":"Parameter"}]
[]
[null,null,"Range Name Description",null,null,null,null,null,"Not_Named",null,{"$f":"C45","v":"Range Name Description"}]
[]
[null,null,"Row Reference",null,null,null,null,null,{"$f":"ROW(C47)","v":47},null,"Row Ref"]
[]
[null,null,"Row Summary",null,null,null,null,null,{"$f":"I41","v":77},null,{"$f":"C49","v":"Row Summary"}]
[]
[null,null,"Units",null,null,null,null,null,"A$",null,{"$f":"C51","v":"Units"}]
[]
[null,null,"WIP",null,null,null,null,null,null,null,{"$f":"C53","v":"WIP"}]
[]
[]
[null,{"$f":"MAX($B$5:$B55)+1","v":3},"Numerical Styles"]
[]
[null,null,"Description",null,null,null,null,null,"Display",null,"Style Name"]
[]
[null,null,"Comma",null,null,null,null,null,123456.789,null,{"$f":"C60","v":"Comma"}]
[]
[null,null,"Comma [0]",null,null,null,null,null,-123456.789,null,"Comma [0]"]
[]
[null,null,"Currency",null,null,null,null,null,123456.789,null,"Currency"]
[]
[null,null,"Currency [0]",null,null,null,null,null,123456.789,null,"Currency [0]"]
[]
[null,null,"Date",null,null,null,null,null,{"$f":"TODAY()","v":"2016-12-24"},null,{"$f":"C68","v":"Date"}]
[]
[null,null,"Date Heading",null,null,null,null,null,{"$f":"TODAY()","v":"2016-12-24"},null,{"$f":"C70","v":"Date Heading"}]
[]
[null,null,"Numbers 0",null,null,null,null,null,-123456.789,null,{"$f":"C72","v":"Numbers 0"}]
[]
[null,null,"Percent",null,null,null,null,null,0.5,null,{"$f":"C74","v":"Percent"}]

{"sheet":"Model Parameters","index":3,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,9,0,10],[2,0,2,4],[10,6,10,13],[11,6,11,13]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Model Parameters"}]
[{"$f":"Model_Name","v":"SP Sorting Examples.xlsm"}]
["Navigator"]
[null,null,null,null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"General"]
[]
[null,null,"Key Inputs"]
[]
[null,null,null,null,"General"]
[null,null,null,null,"Model Name",null,{"$f":"IF(ISERROR(OR(FIND(\"[\",CELL(\"filename\",A1)),FIND(\"]\",CELL(\"filename\",A1)))),\"\",MID(CELL(\"filename\",A1),FIND(\"[\",CELL(\"filename\",A1))+1,FIND(\"]\",CELL(\"filename\",A1))-FIND(\"[\",CELL(\"filename\",A1))-1))","v":"SP Sorting Examples.xlsm"}]
[null,null,null,null,"Client Name",null,"SumProduct Pty Ltd"]

{"sheet":"Datasheet","index":4,"n_rows":47,"n_cols":11,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,6,0,7],[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Datasheet"}]
[{"$f":"Model_Name","v":"SP Sorting Examples.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"Data For Sorting"]
[]
[null,null,"Example"]
[]
[null,null,null,"Dataset"]
[]
[null,null,null,null,null,null,"Date","Store","Item","Amount Invoiced","Amount Paid"]
[null,null,null,null,null,null,"2017-04-01","North","TV",1366.22,1121.77]
[null,null,null,null,null,null,"2017-04-01","East","Stereo",891.8,891.8]
[null,null,null,null,null,null,"2017-04-01","North","Computer",309.48,161.58000000000001]
[null,null,null,null,null,null,"2017-04-01","North","MP3 Player",1107.5899999999999,1107.5899999999999]
[null,null,null,null,null,null,"2017-04-01","West","MP3 Player",99.99,99.99]
[null,null,null,null,null,null,"2017-04-01","West","MP3 Player",157.44,146.1]
[null,null,null,null,null,null,"2017-04-01","East","Stereo",999.83,697.13]
[null,null,null,null,null,null,"2017-04-01","North","Stereo",1335.1,1335.1]
[null,null,null,null,null,null,"2017-04-02","East","MP3 Player",294.3,294.3]
[null,null,null,null,null,null,"2017-04-02","East","TV",838.35,827.92]
[null,null,null,null,null,null,"2017-04-02","North","TV",1305.23,936.77]
[null,null,null,null,null,null,"2017-04-02","South","Computer",1070.24,462.13]
[null,null,null,null,null,null,"2017-04-02","South","TV",657.9,657.9]
[null,null,null,null,null,null,"2017-04-02","East","Computer",1024.1600000000001,480.83]
[null,null,null,null,null,null,"2017-04-02","South","TV",548.33000000000004,548.33000000000004]
[null,null,null,null,null,null,"2017-04-02","North","TV",1226.6500000000001,1226.6500000000001]
[null,null,null,null,null,null,"2017-04-02","East","TV",274.57,274.57]
[null,null,null,null,null,null,"2017-04-02","North","Computer",866.04,866.04]
[null,null,null,null,null,null,"2017-04-02","North","TV",1109.92,431.74]
[null,null,null,null,null,null,"2017-04-02","South","Computer",1377.55,413.48]
[null,null,null,null,null,null,"2017-04-03","East","Computer",425.85,425.85]
[null,null,null,null,null,null,"2017-04-03","North","TV",145.30000000000001,145.30000000000001]
[null,null,null,null,null,null,"2017-04-03","North","Stereo",374.55,338.96]
[null,null,null,null,null,null,"2017-04-03","East","MP3 Player",1072.8699999999999,982.4]
[null,null,null,null,null,null,"2017-04-03","West","Computer",1499.99,1350]
[null,null,null,null,null,null,"2017-04-03","West","Computer",1099,1099]
[null,null,null,null,null,null,"2017-04-03","West","TV",2471.5500000000002,2130]
[null,null,null,null,null,null,"2017-04-03","East","TV",660.22,660.22]
[null,null,null,null,null,null,"2017-04-03","South","MP3 Player",533.59,533.59]
[null,null,null,null,null,null,"2017-04-03","North","TV",1439.53,620.87]
[null,null,null,null,null,null,"2017-04-03","North","Computer",1104.6300000000001,958.27]
[null,null,null,null,null,null,"2017-04-03","East","MP3 Player",1286.1099999999999,1286.1099999999999]
[null,null,null,null,null,null,"2017-04-04","East","TV",78.48,1.61]
[null,null,null,null,null,null,"2017-04-04","North","Computer",510.96,456.09]
[null,null,null,null,null,null,"2017-04-04","South","TV",798.8,798.8]

{"sheet":"Sorting Text","index":5,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,6,0,7],[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Sorting Text"}]
[{"$f":"Model_Name","v":"SP Sorting Examples.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"Issue Highlighted"]
[]
[null,null,"Example"]
[]
[null,null,null,"Dataset"]
[]
[null,null,null,null,null,null,"Data","RANK","SMALL","COUNTIF"]
[null,null,null,null,null,null,"Red",{"$f":"RANK($G13,$G$13:$G$19)","v":{"$error":"#VALUE!"}},{"$f":"SMALL($G$13:$G$19,ROWS($G$13:$G13))","v":{"$error":"#NUM!"}},{"$f":"COUNTIF($G$13:$G$19,\"<\"&$G13)+1","v":5},null,{"$f":"H12","v":"RANK"},"=RANK($G13,$G$13:$G$19)"]
[null,null,null,null,null,null,"Orange",{"$f":"RANK($G14,$G$13:$G$19)","v":{"$error":"#VALUE!"}},{"$f":"SMALL($G$13:$G$19,ROWS($G$13:$G14))","v":{"$error":"#NUM!"}},{"$f":"COUNTIF($G$13:$G$19,\"<\"&$G14)+1","v":4},null,{"$f":"I12","v":"SMALL"},"=SMALL($G$13:$G$19,ROWS($G$13:$G13))"]
[null,null,null,null,null,null,"Yellow",{"$error":"#VALUE!"},{"$f":"SMALL($G$13:$G$19,ROWS($G$13:$G15))","v":{"$error":"#NUM!"}},7,null,{"$f":"J12","v":"COUNTIF"},"=COUNTIF($G$13:$G$19,\"<\"&$G13)+1"]
[null,null,null,null,null,null,"Green",{"$error":"#VALUE!"},{"$f":"SMALL($G$13:$G$19,ROWS($G$13:$G16))","v":{"$error":"#NUM!"}},2]
[null,null,null,null,null,null,"Blue",{"$error":"#VALUE!"},{"$f":"SMALL($G$13:$G$19,ROWS($G$13:$G17))","v":{"$error":"#NUM!"}},1]
[null,null,null,null,null,null,"Indigo",{"$error":"#VALUE!"},{"$f":"SMALL($G$13:$G$19,ROWS($G$13:$G18))","v":{"$error":"#NUM!"}},3]
[null,null,null,null,null,null,"Violent",{"$error":"#VALUE!"},{"$f":"SMALL($G$13:$G$19,ROWS($G$13:$G19))","v":{"$error":"#NUM!"}},6]
[]
[]
[null,{"$f":"MAX($B$5:$B21)+1","v":2},"Alphabeticised"]
[]
[null,null,"Example"]
[]
[null,null,null,"Dataset"]
[]
[null,null,null,null,null,null,{"$f":"G12","v":"Data"}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX($G$13:$G$19,MATCH(SMALL($J$13:$J$19,ROWS($F$29:$F29)),$J$13:$J$19,0)),\"\")","v":"Blue"},null,"=IFERROR(INDEX($G$13:$G$19,MATCH(SMALL($J$13:$J$19,ROWS($F$28:$F28)),$J$13:$J$19,0)),\"\")"]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX($G$13:$G$19,MATCH(SMALL($J$13:$J$19,ROWS($F$29:$F30)),$J$13:$J$19,0)),\"\")","v":"Green"}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX($G$13:$G$19,MATCH(SMALL($J$13:$J$19,ROWS($F$29:$F31)),$J$13:$J$19,0)),\"\")","v":"Indigo"}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX($G$13:$G$19,MATCH(SMALL($J$13:$J$19,ROWS($F$29:$F32)),$J$13:$J$19,0)),\"\")","v":"Orange"}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX($G$13:$G$19,MATCH(SMALL($J$13:$J$19,ROWS($F$29:$F33)),$J$13:$J$19,0)),\"\")","v":"Red"}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX($G$13:$G$19,MATCH(SMALL($J$13:$J$19,ROWS($F$29:$F34)),$J$13:$J$19,0)),\"\")","v":"Violent"}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX($G$13:$G$19,MATCH(SMALL($J$13:$J$19,ROWS($F$29:$F35)),$J$13:$J$19,0)),\"\")","v":"Yellow"}]
[null,null,null,null,null,null,{"$f":"IFERROR(INDEX($G$13:$G$19,MATCH(SMALL($J$13:$J$19,ROWS($F$29:$F36)),$J$13:$J$19,0)),\"\")","v":""}]

{"sheet":"Dynamic Sorting","index":6,"n_rows":46,"n_cols":9,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,6,0,7],[2,0,2,4],[26,7,36,16]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Dynamic Sorting"}]
[{"$f":"Model_Name","v":"SP Sorting Examples.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"Data For Sorting"]
[]
[null,null,"Example"]
[]
[null,null,null,"Dataset"]
[]
[null,null,null,null,null,"IF","SUMIF","INDEX","MIN"]
[null,null,null,null,null,null,"MATCH","VLOOKUP","LOOKUP"]
[null,null,null,null,null,"MAX","OFFSET","SUM","IF"]
[null,null,null,null,null,"HLOOKUP","INDEX",null,"EDATE"]
[null,null,null,null,null,"SUMIFS",null,"EOMONTH","SUMPRODUCT"]
[]
[]
[null,{"$f":"MAX($B$5:$B18)+1","v":2},"Sorted Results (No Blanks or Duplicates)"]
[]
[null,null,"Example"]
[]
[null,null,null,"Sorted Data"]
[]
[null,null,null,null,null,"Results"]
[]
[null,null,null,null,null,{"$f":"IFERROR(INDEX(Range,SMALL(IF(SMALL(IF(COUNTIF($F$26:$F26,Range)+ISBLANK(Range)=0,COUNTIF(Range,\"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),MATCH(MIN(IF(COUNTIF($F$26:$F26,Range)+ISBLANK(Range)>0,\"\",COUNTIF(Range,\"<\"&Range)+1)),INDEX(IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),SMALL(IF(SMALL(IF(COUNTIF($F$26:$F26, Range)+ISBLANK(Range)=0,COUNTIF(Range, \"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),,1),0),1),\"\")","v":"EDATE"},null,"{=IFERROR(INDEX(Range,SMALL(IF(SMALL(IF(COUNTIF($F$26:$F26,Range)+ISBLANK(Range)=0,COUNTIF(Range,\"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),MATCH(MIN(IF(COUNTIF($F$26:$F26,Range)+ISBLANK(Range)>0,\"\",COUNTIF(Range,\"<\"&Range)+1)),INDEX(IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),SMALL(IF(SMALL(IF(COUNTIF($F$26:$F26, Range)+ISBLANK(Range)=0,COUNTIF(Range, \"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),,1),0),1),\"\")}"]
[null,null,null,null,null,{"$f":"IFERROR(INDEX(Range,SMALL(IF(SMALL(IF(COUNTIF($F$26:$F27,Range)+ISBLANK(Range)=0,COUNTIF(Range,\"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),MATCH(MIN(IF(COUNTIF($F$26:$F27,Range)+ISBLANK(Range)>0,\"\",COUNTIF(Range,\"<\"&Range)+1)),INDEX(IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),SMALL(IF(SMALL(IF(COUNTIF($F$26:$F27, Range)+ISBLANK(Range)=0,COUNTIF(Range, \"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),,1),0),1),\"\")","v":"EOMONTH"}]
[null,null,null,null,null,{"$f":"IFERROR(INDEX(Range,SMALL(IF(SMALL(IF(COUNTIF($F$26:$F28,Range)+ISBLANK(Range)=0,COUNTIF(Range,\"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),MATCH(MIN(IF(COUNTIF($F$26:$F28,Range)+ISBLANK(Range)>0,\"\",COUNTIF(Range,\"<\"&Range)+1)),INDEX(IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),SMALL(IF(SMALL(IF(COUNTIF($F$26:$F28, Range)+ISBLANK(Range)=0,COUNTIF(Range, \"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),,1),0),1),\"\")","v":"HLOOKUP"}]
[null,null,null,null,null,{"$f":"IFERROR(INDEX(Range,SMALL(IF(SMALL(IF(COUNTIF($F$26:$F29,Range)+ISBLANK(Range)=0,COUNTIF(Range,\"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),MATCH(MIN(IF(COUNTIF($F$26:$F29,Range)+ISBLANK(Range)>0,\"\",COUNTIF(Range,\"<\"&Range)+1)),INDEX(IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),SMALL(IF(SMALL(IF(COUNTIF($F$26:$F29, Range)+ISBLANK(Range)=0,COUNTIF(Range, \"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),,1),0),1),\"\")","v":"IF"}]
[null,null,null,null,null,{"$f":"IFERROR(INDEX(Range,SMALL(IF(SMALL(IF(COUNTIF($F$26:$F30,Range)+ISBLANK(Range)=0,COUNTIF(Range,\"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),MATCH(MIN(IF(COUNTIF($F$26:$F30,Range)+ISBLANK(Range)>0,\"\",COUNTIF(Range,\"<\"&Range)+1)),INDEX(IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),SMALL(IF(SMALL(IF(COUNTIF($F$26:$F30, Range)+ISBLANK(Range)=0,COUNTIF(Range, \"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),,1),0),1),\"\")","v":"INDEX"}]
[null,null,null,null,null,{"$f":"IFERROR(INDEX(Range,SMALL(IF(SMALL(IF(COUNTIF($F$26:$F31,Range)+ISBLANK(Range)=0,COUNTIF(Range,\"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),MATCH(MIN(IF(COUNTIF($F$26:$F31,Range)+ISBLANK(Range)>0,\"\",COUNTIF(Range,\"<\"&Range)+1)),INDEX(IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),SMALL(IF(SMALL(IF(COUNTIF($F$26:$F31, Range)+ISBLANK(Range)=0,COUNTIF(Range, \"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),,1),0),1),\"\")","v":"LOOKUP"}]
[null,null,null,null,null,{"$f":"IFERROR(INDEX(Range,SMALL(IF(SMALL(IF(COUNTIF($F$26:$F32,Range)+ISBLANK(Range)=0,COUNTIF(Range,\"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),MATCH(MIN(IF(COUNTIF($F$26:$F32,Range)+ISBLANK(Range)>0,\"\",COUNTIF(Range,\"<\"&Range)+1)),INDEX(IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),SMALL(IF(SMALL(IF(COUNTIF($F$26:$F32, Range)+ISBLANK(Range)=0,COUNTIF(Range, \"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),,1),0),1),\"\")","v":"MATCH"}]
[null,null,null,null,null,{"$f":"IFERROR(INDEX(Range,SMALL(IF(SMALL(IF(COUNTIF($F$26:$F33,Range)+ISBLANK(Range)=0,COUNTIF(Range,\"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),MATCH(MIN(IF(COUNTIF($F$26:$F33,Range)+ISBLANK(Range)>0,\"\",COUNTIF(Range,\"<\"&Range)+1)),INDEX(IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),SMALL(IF(SMALL(IF(COUNTIF($F$26:$F33, Range)+ISBLANK(Range)=0,COUNTIF(Range, \"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),,1),0),1),\"\")","v":"MAX"}]
[null,null,null,null,null,{"$f":"IFERROR(INDEX(Range,SMALL(IF(SMALL(IF(COUNTIF($F$26:$F34,Range)+ISBLANK(Range)=0,COUNTIF(Range,\"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),MATCH(MIN(IF(COUNTIF($F$26:$F34,Range)+ISBLANK(Range)>0,\"\",COUNTIF(Range,\"<\"&Range)+1)),INDEX(IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),SMALL(IF(SMALL(IF(COUNTIF($F$26:$F34, Range)+ISBLANK(Range)=0,COUNTIF(Range, \"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),,1),0),1),\"\")","v":"MIN"}]
[null,null,null,null,null,{"$f":"IFERROR(INDEX(Range,SMALL(IF(SMALL(IF(COUNTIF($F$26:$F35,Range)+ISBLANK(Range)=0,COUNTIF(Range,\"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),MATCH(MIN(IF(COUNTIF($F$26:$F35,Range)+ISBLANK(Range)>0,\"\",COUNTIF(Range,\"<\"&Range)+1)),INDEX(IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),SMALL(IF(SMALL(IF(COUNTIF($F$26:$F35, Range)+ISBLANK(Range)=0,COUNTIF(Range, \"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),,1),0),1),\"\")","v":"OFFSET"}]
[null,null,null,null,null,{"$f":"IFERROR(INDEX(Range,SMALL(IF(SMALL(IF(COUNTIF($F$26:$F36,Range)+ISBLANK(Range)=0,COUNTIF(Range,\"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),MATCH(MIN(IF(COUNTIF($F$26:$F36,Range)+ISBLANK(Range)>0,\"\",COUNTIF(Range,\"<\"&Range)+1)),INDEX(IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),SMALL(IF(SMALL(IF(COUNTIF($F$26:$F36, Range)+ISBLANK(Range)=0,COUNTIF(Range, \"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),,1),0),1),\"\")","v":"SUM"}]
[null,null,null,null,null,{"$f":"IFERROR(INDEX(Range,SMALL(IF(SMALL(IF(COUNTIF($F$26:$F37,Range)+ISBLANK(Range)=0,COUNTIF(Range,\"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),MATCH(MIN(IF(COUNTIF($F$26:$F37,Range)+ISBLANK(Range)>0,\"\",COUNTIF(Range,\"<\"&Range)+1)),INDEX(IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),SMALL(IF(SMALL(IF(COUNTIF($F$26:$F37, Range)+ISBLANK(Range)=0,COUNTIF(Range, \"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),,1),0),1),\"\")","v":"SUMIF"}]
[null,null,null,null,null,{"$f":"IFERROR(INDEX(Range,SMALL(IF(SMALL(IF(COUNTIF($F$26:$F38,Range)+ISBLANK(Range)=0,COUNTIF(Range,\"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),MATCH(MIN(IF(COUNTIF($F$26:$F38,Range)+ISBLANK(Range)>0,\"\",COUNTIF(Range,\"<\"&Range)+1)),INDEX(IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),SMALL(IF(SMALL(IF(COUNTIF($F$26:$F38, Range)+ISBLANK(Range)=0,COUNTIF(Range, \"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),,1),0),1),\"\")","v":"SUMIFS"}]
[null,null,null,null,null,{"$f":"IFERROR(INDEX(Range,SMALL(IF(SMALL(IF(COUNTIF($F$26:$F39,Range)+ISBLANK(Range)=0,COUNTIF(Range,\"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),MATCH(MIN(IF(COUNTIF($F$26:$F39,Range)+ISBLANK(Range)>0,\"\",COUNTIF(Range,\"<\"&Range)+1)),INDEX(IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),SMALL(IF(SMALL(IF(COUNTIF($F$26:$F39, Range)+ISBLANK(Range)=0,COUNTIF(Range, \"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),,1),0),1),\"\")","v":"SUMPRODUCT"}]
[null,null,null,null,null,{"$f":"IFERROR(INDEX(Range,SMALL(IF(SMALL(IF(COUNTIF($F$26:$F40,Range)+ISBLANK(Range)=0,COUNTIF(Range,\"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),MATCH(MIN(IF(COUNTIF($F$26:$F40,Range)+ISBLANK(Range)>0,\"\",COUNTIF(Range,\"<\"&Range)+1)),INDEX(IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),SMALL(IF(SMALL(IF(COUNTIF($F$26:$F40, Range)+ISBLANK(Range)=0,COUNTIF(Range, \"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),,1),0),1),\"\")","v":"VLOOKUP"}]
[null,null,null,null,null,{"$f":"IFERROR(INDEX(Range,SMALL(IF(SMALL(IF(COUNTIF($F$26:$F41,Range)+ISBLANK(Range)=0,COUNTIF(Range,\"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),MATCH(MIN(IF(COUNTIF($F$26:$F41,Range)+ISBLANK(Range)>0,\"\",COUNTIF(Range,\"<\"&Range)+1)),INDEX(IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),SMALL(IF(SMALL(IF(COUNTIF($F$26:$F41, Range)+ISBLANK(Range)=0,COUNTIF(Range, \"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),,1),0),1),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(INDEX(Range,SMALL(IF(SMALL(IF(COUNTIF($F$26:$F42,Range)+ISBLANK(Range)=0,COUNTIF(Range,\"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),MATCH(MIN(IF(COUNTIF($F$26:$F42,Range)+ISBLANK(Range)>0,\"\",COUNTIF(Range,\"<\"&Range)+1)),INDEX(IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),SMALL(IF(SMALL(IF(COUNTIF($F$26:$F42, Range)+ISBLANK(Range)=0,COUNTIF(Range, \"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),,1),0),1),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(INDEX(Range,SMALL(IF(SMALL(IF(COUNTIF($F$26:$F43,Range)+ISBLANK(Range)=0,COUNTIF(Range,\"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),MATCH(MIN(IF(COUNTIF($F$26:$F43,Range)+ISBLANK(Range)>0,\"\",COUNTIF(Range,\"<\"&Range)+1)),INDEX(IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),SMALL(IF(SMALL(IF(COUNTIF($F$26:$F43, Range)+ISBLANK(Range)=0,COUNTIF(Range, \"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),,1),0),1),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(INDEX(Range,SMALL(IF(SMALL(IF(COUNTIF($F$26:$F44,Range)+ISBLANK(Range)=0,COUNTIF(Range,\"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),MATCH(MIN(IF(COUNTIF($F$26:$F44,Range)+ISBLANK(Range)>0,\"\",COUNTIF(Range,\"<\"&Range)+1)),INDEX(IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),SMALL(IF(SMALL(IF(COUNTIF($F$26:$F44, Range)+ISBLANK(Range)=0,COUNTIF(Range, \"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),,1),0),1),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IFERROR(INDEX(Range,SMALL(IF(SMALL(IF(COUNTIF($F$26:$F45,Range)+ISBLANK(Range)=0,COUNTIF(Range,\"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),MATCH(MIN(IF(COUNTIF($F$26:$F45,Range)+ISBLANK(Range)>0,\"\",COUNTIF(Range,\"<\"&Range)+1)),INDEX(IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),SMALL(IF(SMALL(IF(COUNTIF($F$26:$F45, Range)+ISBLANK(Range)=0,COUNTIF(Range, \"<\"&Range)+1,\"\"),1)=IF(ISBLANK(Range),\"\",COUNTIF(Range,\"<\"&Range)+1),ROW(Range)-MIN(ROW(Range))+1),1),,1),0),1),\"\")","v":""}]

{"sheet":"Error Checks","index":7,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,8,0,9],[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1))))","v":"Error Checks"}]
[{"$f":"Model_Name","v":"SP Sorting Examples.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"Error Checks"]
[]
[null,null,"Summary of Errors"]
[]
[null,null,null,"Assumptions"]
[]
[null,null,null,null,"None"]
[]
[]
[]
[]
[null,null,null,null,{"$f":"C8","v":"Summary of Errors"},null,null,null,{"$f":"MIN(1,SUM(I11:I15))","v":0}]