{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Cover","Navigator","Style Guide","Model Parameters","MAX","MIN","LARGE","SMALL","Error Checks"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":16,"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 MAX MIN LARGE and SMALL.xlsm"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Primary Developer:  Liam Bastick"]
[]
[null,null,"General Cover Notes:"]
[null,null,"Considering MAX, MIN, LARGE and SMALL."]
[]
[]
[]
[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":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Navigator"]
[{"$f":"Model_Name","v":"SP MAX MIN LARGE and SMALL.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,"MAX"]
[null,null,null,null,null,"MIN"]
[null,null,null,null,null,"LARGE"]
[null,null,null,null,null,"SMALL"]
[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":[[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],[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],[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],[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],[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],[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]]}
[{"$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 MAX MIN LARGE and SMALL.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 MAX MIN LARGE and SMALL.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 MAX MIN LARGE and SMALL.xlsm"}]
[null,null,null,null,"Client Name",null,"SumProduct Pty Ltd"]

{"sheet":"MAX","index":4,"n_rows":75,"n_cols":11,"rows_kept":75,"cut":false,"hidden":false,"merged":[[51,7,51,9],[54,7,54,9],[57,7,57,9],[0,6,0,7],[2,0,2,4],[33,5,33,6],[48,7,48,9]]}
[{"$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":"MAX"}]
[{"$f":"Model_Name","v":"SP MAX MIN LARGE and SMALL.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"Basic Example"]
[]
[null,null,"Example"]
[]
[null,null,null,"Dataset"]
[]
[null,null,null,null,null,"Values",null,"MAX"]
[null,null,null,null,null,{"$f":"RANDBETWEEN(10,500)","v":497},null,{"$f":"MAX(F13:F27)","v":497},"=MAX(F13:F27)"]
[null,null,null,null,null,{"$f":"RANDBETWEEN(10,500)","v":29}]
[null,null,null,null,null,180]
[null,null,null,null,null,115]
[null,null,null,null,null,318]
[null,null,null,null,null,85]
[null,null,null,null,null,474]
[null,null,null,null,null,292]
[null,null,null,null,null,436]
[null,null,null,null,null,56]
[null,null,null,null,null,301]
[null,null,null,null,null,400]
[null,null,null,null,null,255]
[null,null,null,null,null,157]
[null,null,null,null,null,293]
[]
[]
[null,{"$f":"MAX($B$5:$B29)+1","v":2},"Common Mistakes"]
[]
[null,null,"Examples"]
[]
[null,null,null,null,null,{"$f":"F12","v":"Values"},null,{"$f":"H12","v":"MAX"}]
[null,null,null,null,null,{"$f":"-RANDBETWEEN(10,500)","v":-390},null,{"$f":"MAX(F35:G35)","v":-390},"Doesn't treat blanks as zeros"]
[null,null,null,null,null,{"$f":"-RANDBETWEEN(10,500)","v":-194},null,{"$f":"MAX(F36,)","v":0},"=MAX(F36,) - does treat blanks in formula as zeros"]
[null,null,null,null,null,{"$f":"-RANDBETWEEN(10,500)","v":-247},null,{"$f":"MAX(F37,\"\")","v":{"$error":"#VALUE!"}},"=MAX(F37,\"\") - empty strings are treated as text; MAX cannot evaluate text strings"]
[]
[]
[null,{"$f":"MAX($B$5:$B39)+1","v":3},"Extended Examples"]
[]
[null,null,"Example"]
[]
[null,null,null,"Dataset"]
[]
[null,null,null,null,null,{"$f":"F12","v":"Values"},null,null,{"$f":"H12","v":"MAX"}]
[null,null,null,null,null,{"$f":"RANDBETWEEN(10,500)","v":260},null,null,{"$f":"MAX(F47:F61)","v":493},null,"=MAX(F47:F61)"]
[null,null,null,null,null,{"$f":"-RANDBETWEEN(10,500)","v":-213}]
[null,null,null,null,null,{"$f":"RANDBETWEEN(10,500)","v":340},null,"Max Positive Number"]
[null,null,null,null,null,{"$f":"-RANDBETWEEN(10,500)","v":-432},null,null,{"$f":"MAX(IF(F47:F61>0,F47:F61))","v":493},null,"{=MAX(IF(F47:F61>0,F47:F61))}"]
[null,null,null,null,null,{"$f":"RANDBETWEEN(10,500)","v":493}]
[null,null,null,null,null,{"$f":"-RANDBETWEEN(10,500)","v":-41},null,"Max Negative Number"]
[null,null,null,null,null,{"$f":"RANDBETWEEN(10,500)","v":178},null,null,{"$f":"MAX(IF(F47:F61<0,F47:F61))","v":-23},null,"{=MAX(IF(F47:F61<0,F47:F61))}"]
[null,null,null,null,null,{"$f":"-RANDBETWEEN(10,500)","v":-57}]
[null,null,null,null,null,{"$f":"RANDBETWEEN(10,500)","v":222},null,"Max Even Number"]
[null,null,null,null,null,{"$f":"-RANDBETWEEN(10,500)","v":-38},null,null,{"$f":"MAX(IF(MOD(F47:F61,2)=0,F47:F61))","v":340},null,"{=MAX(IF(MOD(F47:F61,2)=0,F47:F61))}"]
[null,null,null,null,null,{"$f":"RANDBETWEEN(10,500)","v":481}]
[null,null,null,null,null,{"$f":"-RANDBETWEEN(10,500)","v":-57},null,"Max Odd Number"]
[null,null,null,null,null,{"$f":"RANDBETWEEN(10,500)","v":48},null,null,{"$f":"MAX(IF(MOD(F47:F61,2)=1,F47:F61))","v":493},null,"{=MAX(IF(MOD(F47:F61,2)=1,F47:F61))}"]
[null,null,null,null,null,{"$f":"-RANDBETWEEN(10,500)","v":-23}]
[null,null,null,null,null,{"$f":"RANDBETWEEN(10,500)","v":277}]
[]
[]
[null,{"$f":"MAX($B$5:$B63)+1","v":4},"Maximum Dividend"]
[]
[null,null,"Example"]
[]
[null,null,null,"Financial Results"]
[]
[null,null,null,null,null,"Retained Earnings",null,null,-100]
[null,null,null,null,null,"NPAT",null,null,40]
[]
[null,null,null,null,null,"Cash Available",null,null,30]
[]
[null,null,null,null,null,"Maximum Dividend",null,null,{"$f":"MAX(MIN(MAX(I70+I71,I71),I73),)","v":30},null,"=MAX(MIN(MAX(I70+I71,I71),I73),)"]

{"sheet":"MIN","index":5,"n_rows":75,"n_cols":11,"rows_kept":75,"cut":false,"hidden":false,"merged":[[57,7,57,9],[0,6,0,7],[2,0,2,4],[33,5,33,6],[48,7,48,9],[51,7,51,9],[54,7,54,9]]}
[{"$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":"MIN"}]
[{"$f":"Model_Name","v":"SP MAX MIN LARGE and SMALL.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"Basic Example"]
[]
[null,null,"Example"]
[]
[null,null,null,"Dataset"]
[]
[null,null,null,null,null,"Values",null,"MIN"]
[null,null,null,null,null,{"$f":"RANDBETWEEN(10,500)","v":277},null,{"$f":"MIN(F13:F27)","v":15},"=MIN(F13:F27)"]
[null,null,null,null,null,{"$f":"RANDBETWEEN(10,500)","v":171}]
[null,null,null,null,null,487]
[null,null,null,null,null,195]
[null,null,null,null,null,453]
[null,null,null,null,null,423]
[null,null,null,null,null,296]
[null,null,null,null,null,257]
[null,null,null,null,null,126]
[null,null,null,null,null,15]
[null,null,null,null,null,459]
[null,null,null,null,null,381]
[null,null,null,null,null,311]
[null,null,null,null,null,193]
[null,null,null,null,null,472]
[]
[]
[null,{"$f":"MAX($B$5:$B29)+1","v":2},"Common Mistakes"]
[]
[null,null,"Examples"]
[]
[null,null,null,null,null,{"$f":"F12","v":"Values"},null,{"$f":"H12","v":"MIN"}]
[null,null,null,null,null,{"$f":"-RANDBETWEEN(10,500)","v":-395},null,{"$f":"MIN(F35:G35)","v":-395},"Doesn't treat blanks as zeros"]
[null,null,null,null,null,{"$f":"-RANDBETWEEN(10,500)","v":-189},null,{"$f":"MIN(F36,)","v":-189},"=MIN(F36,) - does treat blanks in formula as zeros"]
[null,null,null,null,null,{"$f":"-RANDBETWEEN(10,500)","v":-429},null,{"$f":"MIN(F37,\"\")","v":{"$error":"#VALUE!"}},"=MIN(F37,\"\") - empty strings are treated as text; MAX cannot evaluate text strings"]
[]
[]
[null,{"$f":"MAX($B$5:$B39)+1","v":3},"Extended Examples"]
[]
[null,null,"Example"]
[]
[null,null,null,"Dataset"]
[]
[null,null,null,null,null,{"$f":"F12","v":"Values"},null,null,{"$f":"H12","v":"MIN"}]
[null,null,null,null,null,{"$f":"RANDBETWEEN(10,500)","v":64},null,null,{"$f":"MIN(F47:F61)","v":-479},null,"=MIN(F47:F61)"]
[null,null,null,null,null,{"$f":"-RANDBETWEEN(10,500)","v":-479}]
[null,null,null,null,null,{"$f":"RANDBETWEEN(10,500)","v":88},null,"Min Positive Number"]
[null,null,null,null,null,{"$f":"-RANDBETWEEN(10,500)","v":-10},null,null,{"$f":"MIN(IF(F47:F61>0,F47:F61))","v":22},null,"{=MIN(IF(F47:F61>0,F47:F61))}"]
[null,null,null,null,null,{"$f":"RANDBETWEEN(10,500)","v":261}]
[null,null,null,null,null,{"$f":"-RANDBETWEEN(10,500)","v":-105},null,"Min Negative Number"]
[null,null,null,null,null,{"$f":"RANDBETWEEN(10,500)","v":269},null,null,{"$f":"MIN(IF(F47:F61<0,F47:F61))","v":-479},null,"{=MIN(IF(F47:F61<0,F47:F61))}"]
[null,null,null,null,null,{"$f":"-RANDBETWEEN(10,500)","v":-94}]
[null,null,null,null,null,{"$f":"RANDBETWEEN(10,500)","v":490},null,"Min Even Number"]
[null,null,null,null,null,{"$f":"-RANDBETWEEN(10,500)","v":-332},null,null,{"$f":"MIN(IF(MOD(F47:F61,2)=0,F47:F61))","v":-332},null,"{=MIN(IF(MOD(F47:F61,2)=0,F47:F61))}"]
[null,null,null,null,null,{"$f":"RANDBETWEEN(10,500)","v":450}]
[null,null,null,null,null,{"$f":"-RANDBETWEEN(10,500)","v":-28},null,"Min Odd Number"]
[null,null,null,null,null,{"$f":"RANDBETWEEN(10,500)","v":346},null,null,{"$f":"MIN(IF(MOD(F47:F61,2)=1,F47:F61))","v":-479},null,"{=MIN(IF(MOD(F47:F61,2)=1,F47:F61))}"]
[null,null,null,null,null,{"$f":"-RANDBETWEEN(10,500)","v":-294}]
[null,null,null,null,null,{"$f":"RANDBETWEEN(10,500)","v":22}]
[]
[]
[null,{"$f":"MAX($B$5:$B63)+1","v":4},"Maximum Dividend"]
[]
[null,null,"Example"]
[]
[null,null,null,"Financial Results"]
[]
[null,null,null,null,null,"Retained Earnings",null,null,-100]
[null,null,null,null,null,"NPAT",null,null,40]
[]
[null,null,null,null,null,"Cash Available",null,null,30]
[]
[null,null,null,null,null,"Maximum Dividend",null,null,{"$f":"MAX(MIN(MAX(I70+I71,I71),I73),)","v":30},null,"=MAX(MIN(MAX(I70+I71,I71),I73),)"]

{"sheet":"LARGE","index":6,"n_rows":85,"n_cols":11,"rows_kept":85,"cut":false,"hidden":false,"merged":[[0,6,0,7],[2,0,2,4],[33,5,33,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":"LARGE"}]
[{"$f":"Model_Name","v":"SP MAX MIN LARGE and SMALL.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"Basic Example"]
[]
[null,null,"Example"]
[]
[null,null,null,"Dataset"]
[]
[null,null,null,null,null,"Values",null,"Largest"]
[null,null,null,null,null,{"$f":"RANDBETWEEN(10,500)","v":180},null,{"$f":"LARGE(F13:F27,1)","v":381},"=LARGE(F13:F27,1)"]
[null,null,null,null,null,{"$f":"RANDBETWEEN(10,500)","v":131}]
[null,null,null,null,null,89,null,"2nd Largest"]
[null,null,null,null,null,295,null,{"$f":"LARGE(F13:F27,2)","v":350},"=LARGE(F13:F27,2)"]
[null,null,null,null,null,85]
[null,null,null,null,null,260,null,"3rd Largest"]
[null,null,null,null,null,208,null,{"$f":"LARGE(F13:F27,3)","v":295},"=LARGE(F13:F27,3)"]
[null,null,null,null,null,381]
[null,null,null,null,null,174]
[null,null,null,null,null,135]
[null,null,null,null,null,286]
[null,null,null,null,null,148]
[null,null,null,null,null,63]
[null,null,null,null,null,350]
[null,null,null,null,null,290]
[]
[]
[null,{"$f":"MAX($B$5:$B29)+1","v":2},"Common Mistakes"]
[]
[null,null,"Examples"]
[]
[null,null,null,null,null,{"$f":"F12","v":"Values"},null,{"$f":"H12","v":"Largest"}]
[null,null,null,null,null,{"$f":"RANDBETWEEN(10,500)","v":262},null,{"$f":"LARGE(F35:G35,2)","v":{"$error":"#NUM!"}},"=LARGE(F35:G35,2) - doesn't consider blanks in a range"]
[null,null,null,null,null,{"$f":"-RANDBETWEEN(10,500)","v":-51},null,{"$f":"LARGE(F36,2)","v":{"$error":"#NUM!"}},"=LARGE(F36:G36,2) - value of n is larger than the number of items in the range"]
[null,null,null,null,null,{"$f":"-RANDBETWEEN(10,500)","v":-322},null,{"$f":"LARGE(F37,0.4)","v":{"$error":"#NUM!"}},"=LARGE(F37:G37,0.4) - value of n must be a positive integer less than or equal to number of non-blank items in the range"]
[]
[]
[null,{"$f":"MAX($B$5:$B39)+1","v":3},"Ranking Example"]
[]
[null,null,"Example"]
[]
[null,null,null,"Dataset"]
[]
[null,null,null,null,null,{"$f":"F12","v":"Values"},null,"Descending"]
[null,null,null,null,null,{"$f":"RANDBETWEEN(10,500)","v":307},null,{"$f":"LARGE($F$47:$F$61,ROWS($G$47:$G47))","v":445},"=LARGE($F$47:$F$61,ROWS($G$47:$G47))"]
[null,null,null,null,null,{"$f":"RANDBETWEEN(10,500)","v":344},null,{"$f":"LARGE($F$47:$F$61,ROWS($G$47:$G48))","v":344}]
[null,null,null,null,null,322,null,{"$f":"LARGE($F$47:$F$61,ROWS($G$47:$G49))","v":322}]
[null,null,null,null,null,282,null,{"$f":"LARGE($F$47:$F$61,ROWS($G$47:$G50))","v":307}]
[null,null,null,null,null,291,null,{"$f":"LARGE($F$47:$F$61,ROWS($G$47:$G51))","v":291}]
[null,null,null,null,null,35,null,{"$f":"LARGE($F$47:$F$61,ROWS($G$47:$G52))","v":282}]
[null,null,null,null,null,72,null,{"$f":"LARGE($F$47:$F$61,ROWS($G$47:$G53))","v":242}]
[null,null,null,null,null,32,null,{"$f":"LARGE($F$47:$F$61,ROWS($G$47:$G54))","v":219}]
[null,null,null,null,null,445,null,{"$f":"LARGE($F$47:$F$61,ROWS($G$47:$G55))","v":161}]
[null,null,null,null,null,113,null,{"$f":"LARGE($F$47:$F$61,ROWS($G$47:$G56))","v":113}]
[null,null,null,null,null,90,null,{"$f":"LARGE($F$47:$F$61,ROWS($G$47:$G57))","v":90}]
[null,null,null,null,null,219,null,{"$f":"LARGE($F$47:$F$61,ROWS($G$47:$G58))","v":72}]
[null,null,null,null,null,60,null,{"$f":"LARGE($F$47:$F$61,ROWS($G$47:$G59))","v":60}]
[null,null,null,null,null,161,null,{"$f":"LARGE($F$47:$F$61,ROWS($G$47:$G60))","v":35}]
[null,null,null,null,null,242,null,{"$f":"LARGE($F$47:$F$61,ROWS($G$47:$G61))","v":32}]
[]
[]
[null,{"$f":"MAX($B$5:$B63)+1","v":4},"Two Alternatives to Summing Top Three"]
[]
[null,null,"Example"]
[]
[null,null,null,"Dataset"]
[]
[null,null,null,null,null,{"$f":"F12","v":"Values"},null,"Top 3",null,"Sum - Alt 1"]
[null,null,null,null,{"$f":"RANK(F71,$F$71:$F$85)+COUNTIF($F$70:$F70,F71)","v":11},{"$f":"RANDBETWEEN(10,500)","v":166},null,1,null,{"$f":"SUM(LARGE(F71:F85,H71:H73))","v":1345},"{=SUM(LARGE(F71:F85,H71:H73))}"]
[null,null,null,null,{"$f":"RANK(F72,$F$71:$F$85)+COUNTIF($F$70:$F71,F72)","v":5},{"$f":"RANDBETWEEN(10,500)","v":324},null,2]
[null,null,null,null,{"$f":"RANK(F73,$F$71:$F$85)+COUNTIF($F$70:$F72,F73)","v":3},377,null,3,null,"Sum - Alt 2"]
[null,null,null,null,{"$f":"RANK(F74,$F$71:$F$85)+COUNTIF($F$70:$F73,F74)","v":15},86,null,null,null,{"$f":"SUM(LARGE(F71:F85,{1,2,3}))","v":1345},"=SUM(LARGE(F71:F85,{1,2,3}))"]
[null,null,null,null,{"$f":"RANK(F75,$F$71:$F$85)+COUNTIF($F$70:$F74,F75)","v":9},198]
[null,null,null,null,{"$f":"RANK(F76,$F$71:$F$85)+COUNTIF($F$70:$F75,F76)","v":1},496]
[null,null,null,null,{"$f":"RANK(F77,$F$71:$F$85)+COUNTIF($F$70:$F76,F77)","v":13},129]
[null,null,null,null,{"$f":"RANK(F78,$F$71:$F$85)+COUNTIF($F$70:$F77,F78)","v":10},197]
[null,null,null,null,{"$f":"RANK(F79,$F$71:$F$85)+COUNTIF($F$70:$F78,F79)","v":8},258]
[null,null,null,null,{"$f":"RANK(F80,$F$71:$F$85)+COUNTIF($F$70:$F79,F80)","v":7},306]
[null,null,null,null,{"$f":"RANK(F81,$F$71:$F$85)+COUNTIF($F$70:$F80,F81)","v":4},363]
[null,null,null,null,{"$f":"RANK(F82,$F$71:$F$85)+COUNTIF($F$70:$F81,F82)","v":2},472]
[null,null,null,null,{"$f":"RANK(F83,$F$71:$F$85)+COUNTIF($F$70:$F82,F83)","v":6},322]
[null,null,null,null,{"$f":"RANK(F84,$F$71:$F$85)+COUNTIF($F$70:$F83,F84)","v":14},102]
[null,null,null,null,{"$f":"RANK(F85,$F$71:$F$85)+COUNTIF($F$70:$F84,F85)","v":12},158]

{"sheet":"SMALL","index":7,"n_rows":85,"n_cols":11,"rows_kept":85,"cut":false,"hidden":false,"merged":[[0,6,0,7],[2,0,2,4],[33,5,33,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":"SMALL"}]
[{"$f":"Model_Name","v":"SP MAX MIN LARGE and SMALL.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},"Basic Example"]
[]
[null,null,"Example"]
[]
[null,null,null,"Dataset"]
[]
[null,null,null,null,null,"Values",null,"Smallest"]
[null,null,null,null,null,{"$f":"RANDBETWEEN(10,500)","v":436},null,{"$f":"SMALL(F13:F27,1)","v":26},"=SMALL(F13:F27,1)"]
[null,null,null,null,null,{"$f":"RANDBETWEEN(10,500)","v":294}]
[null,null,null,null,null,150,null,"2nd Smallest"]
[null,null,null,null,null,346,null,{"$f":"SMALL(F13:F27,2)","v":150},"=SMALL(F13:F27,2)"]
[null,null,null,null,null,397]
[null,null,null,null,null,445,null,"3rd Smallest"]
[null,null,null,null,null,320,null,{"$f":"SMALL(F13:F27,3)","v":161},"=SMALL(F13:F27,3)"]
[null,null,null,null,null,244]
[null,null,null,null,null,353]
[null,null,null,null,null,161]
[null,null,null,null,null,343]
[null,null,null,null,null,26]
[null,null,null,null,null,402]
[null,null,null,null,null,216]
[null,null,null,null,null,305]
[]
[]
[null,{"$f":"MAX($B$5:$B29)+1","v":2},"Common Mistakes"]
[]
[null,null,"Examples"]
[]
[null,null,null,null,null,{"$f":"F12","v":"Values"},null,"Smallest"]
[null,null,null,null,null,{"$f":"RANDBETWEEN(10,500)","v":469},null,{"$f":"SMALL(F35:G35,2)","v":{"$error":"#NUM!"}},"=SMALL(F35:G35,2) - doesn't consider blanks in a range"]
[null,null,null,null,null,{"$f":"-RANDBETWEEN(10,500)","v":-178},null,{"$f":"SMALL(F36,2)","v":{"$error":"#NUM!"}},"=SMALL(F36:G36,2) - value of n is larger than the number of items in the range"]
[null,null,null,null,null,{"$f":"-RANDBETWEEN(10,500)","v":-228},null,{"$f":"SMALL(F37,0.4)","v":{"$error":"#NUM!"}},"=SMALL(F37:G37,0.4) - value of n must be a positive integer less than or equal to number of non-blank items in the range"]
[]
[]
[null,{"$f":"MAX($B$5:$B39)+1","v":3},"Ranking Example"]
[]
[null,null,"Example"]
[]
[null,null,null,"Dataset"]
[]
[null,null,null,null,null,{"$f":"F12","v":"Values"},null,"Ascending"]
[null,null,null,null,null,{"$f":"RANDBETWEEN(10,500)","v":160},null,{"$f":"SMALL($F$47:$F$61,ROWS($G$47:$G47))","v":42},"=SMALL($F$47:$F$61,ROWS($G$47:$G47))"]
[null,null,null,null,null,{"$f":"RANDBETWEEN(10,500)","v":126},null,{"$f":"SMALL($F$47:$F$61,ROWS($G$47:$G48))","v":61}]
[null,null,null,null,null,313,null,{"$f":"SMALL($F$47:$F$61,ROWS($G$47:$G49))","v":97}]
[null,null,null,null,null,224,null,{"$f":"SMALL($F$47:$F$61,ROWS($G$47:$G50))","v":108}]
[null,null,null,null,null,489,null,{"$f":"SMALL($F$47:$F$61,ROWS($G$47:$G51))","v":126}]
[null,null,null,null,null,42,null,{"$f":"SMALL($F$47:$F$61,ROWS($G$47:$G52))","v":160}]
[null,null,null,null,null,97,null,{"$f":"SMALL($F$47:$F$61,ROWS($G$47:$G53))","v":224}]
[null,null,null,null,null,108,null,{"$f":"SMALL($F$47:$F$61,ROWS($G$47:$G54))","v":313}]
[null,null,null,null,null,402,null,{"$f":"SMALL($F$47:$F$61,ROWS($G$47:$G55))","v":344}]
[null,null,null,null,null,405,null,{"$f":"SMALL($F$47:$F$61,ROWS($G$47:$G56))","v":363}]
[null,null,null,null,null,440,null,{"$f":"SMALL($F$47:$F$61,ROWS($G$47:$G57))","v":402}]
[null,null,null,null,null,344,null,{"$f":"SMALL($F$47:$F$61,ROWS($G$47:$G58))","v":405}]
[null,null,null,null,null,363,null,{"$f":"SMALL($F$47:$F$61,ROWS($G$47:$G59))","v":424}]
[null,null,null,null,null,424,null,{"$f":"SMALL($F$47:$F$61,ROWS($G$47:$G60))","v":440}]
[null,null,null,null,null,61,null,{"$f":"SMALL($F$47:$F$61,ROWS($G$47:$G61))","v":489}]
[]
[]
[null,{"$f":"MAX($B$5:$B63)+1","v":4},"Two Alternatives to Summing Bottom Three"]
[]
[null,null,"Example"]
[]
[null,null,null,"Dataset"]
[]
[null,null,null,null,null,{"$f":"F12","v":"Values"},null,"Top 3",null,"Sum - Alt 1"]
[null,null,null,null,{"$f":"RANK(F71,$F$71:$F$85,1)-COUNTIF($F$70:$F70,F71)","v":13},{"$f":"RANDBETWEEN(10,500)","v":417},null,1,null,{"$f":"SUM(SMALL(F71:F85,H71:H73))","v":327},"{=SUM(SMALL(F71:F85,H71:H73))}"]
[null,null,null,null,{"$f":"RANK(F72,$F$71:$F$85,1)-COUNTIF($F$70:$F71,F72)","v":7},{"$f":"RANDBETWEEN(10,500)","v":231},null,2]
[null,null,null,null,{"$f":"RANK(F73,$F$71:$F$85,1)-COUNTIF($F$70:$F72,F73)","v":11},386,null,3,null,"Sum - Alt 2"]
[null,null,null,null,{"$f":"RANK(F74,$F$71:$F$85,1)-COUNTIF($F$70:$F73,F74)","v":1},92,null,null,null,{"$f":"SUM(SMALL(F71:F85,{1,2,3}))","v":327},"=SUM(SMALL(F71:F85,{1,2,3}))"]
[null,null,null,null,{"$f":"RANK(F75,$F$71:$F$85,1)-COUNTIF($F$70:$F74,F75)","v":15},436]
[null,null,null,null,{"$f":"RANK(F76,$F$71:$F$85,1)-COUNTIF($F$70:$F75,F76)","v":10},380]
[null,null,null,null,{"$f":"RANK(F77,$F$71:$F$85,1)-COUNTIF($F$70:$F76,F77)","v":4},148]
[null,null,null,null,{"$f":"RANK(F78,$F$71:$F$85,1)-COUNTIF($F$70:$F77,F78)","v":5},149]
[null,null,null,null,{"$f":"RANK(F79,$F$71:$F$85,1)-COUNTIF($F$70:$F78,F79)","v":2},97]
[null,null,null,null,{"$f":"RANK(F80,$F$71:$F$85,1)-COUNTIF($F$70:$F79,F80)","v":14},427]
[null,null,null,null,{"$f":"RANK(F81,$F$71:$F$85,1)-COUNTIF($F$70:$F80,F81)","v":3},138]
[null,null,null,null,{"$f":"RANK(F82,$F$71:$F$85,1)-COUNTIF($F$70:$F81,F82)","v":8},267]
[null,null,null,null,{"$f":"RANK(F83,$F$71:$F$85,1)-COUNTIF($F$70:$F82,F83)","v":9},326]
[null,null,null,null,{"$f":"RANK(F84,$F$71:$F$85,1)-COUNTIF($F$70:$F83,F84)","v":12},415]
[null,null,null,null,{"$f":"RANK(F85,$F$71:$F$85,1)-COUNTIF($F$70:$F84,F85)","v":6},192]

{"sheet":"Error Checks","index":8,"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 MAX MIN LARGE and SMALL.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}]