{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Cover","Navigator","Style Guide","Model Parameters","Timing","Error Checks","1D Array","2D Array","3D Array","A","1","2","3","B","4D Array"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":74,"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 Limited"}]
[null,null,{"$f":"Model_Name","v":"SP Matrix Manipulation SN0.09.xlsm"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Primary Developer:  Sam Ngo"]
[]
[null,null,"General Cover Notes:"]
[null,null,"Simple matrix manipulation."]
[]
[]
[]
[null,null,"Any queries, please e-mail:",null,null,null,"sam.ngo@sumproduct.com"]
[null,null,"Website:",null,null,null,"www.sumproduct.com"]

{"sheet":"Navigator","index":1,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\",A1),LEN(CELL(\"filename\",A1))-FIND(\"]\",CELL(\"filename\",A1)))),\n\"\",\nRIGHT(CELL(\"filename\"),LEN(CELL(\"filename\"))-FIND(\"]\",CELL(\"filename\"))))","v":"Navigator"}]
[{"$f":"Model_Name","v":"SP Matrix Manipulation SN0.09.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,"Timing"]
[null,null,null,null,null,"Error Checks"]
[null,null,null,null,null,"1D Array"]
[null,null,null,null,null,"2D Array"]
[null,null,null,null,null,"3D Array"]
[null,null,null,null,null,"A"]
[null,null,null,null,null,1]
[null,null,null,null,null,2]
[null,null,null,null,null,3]
[null,null,null,null,null,"B"]
[null,null,null,null,null,"4D Array"]

{"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\"),LEN(CELL(\"filename\"))-FIND(\"]\",CELL(\"filename\"))))","v":"Navigator"}]
[{"$f":"Model_Name","v":"SP Matrix Manipulation SN0.09.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":"Example"},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":"2026-03-10"},null,{"$f":"C68","v":"Date"}]
[]
[null,null,"Date Heading",null,null,null,null,null,{"$f":"TODAY()","v":"2026-03-10"},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":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[[2,0,2,4],[10,6,10,13],[11,6,11,13]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\"),LEN(CELL(\"filename\"))-FIND(\"]\",CELL(\"filename\")))),\n\"\",\nRIGHT(CELL(\"filename\"),LEN(CELL(\"filename\"))-FIND(\"]\",CELL(\"filename\"))))","v":"Navigator"}]
[{"$f":"Model_Name","v":"SP Matrix Manipulation SN0.09.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 Matrix Manipulation SN0.09.xlsm"}]
[null,null,null,null,"Client Name",null,"SumProduct Pty Limited"]
[]
[]
[null,{"$f":"MAX($B$5:$B14)+1","v":2},"General Range Names"]
[]
[null,null,"Technical Assumptions"]
[]
[null,null,null,null,"Days in Year",null,365]
[null,null,null,null,"Months in Month",null,1]
[null,null,null,null,"Months in Quarter",null,3]
[null,null,null,null,"Months in Half Yr",null,6]
[null,null,null,null,"Months in Year",null,12]
[null,null,null,null,"Quarters in Year",null,4]
[]
[null,null,null,null,"Rounding Accuracy",null,5]
[]
[null,null,null,null,"Very Large Number",null,9.9999999999999997E+98]
[null,null,null,null,"Very Small Number",null,1E-8]
[]
[null,null,null,null,"Thousand",null,1000]

{"sheet":"Timing","index":4,"n_rows":21,"n_cols":14,"rows_kept":21,"cut":false,"hidden":false,"merged":[[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\"),LEN(CELL(\"filename\"))-FIND(\"]\",CELL(\"filename\")))),\n\"\",\nRIGHT(CELL(\"filename\"),LEN(CELL(\"filename\"))-FIND(\"]\",CELL(\"filename\"))))","v":"Navigator"}]
[{"$f":"Model_Name","v":"SP Matrix Manipulation SN0.09.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,{"$f":"Overall_Error_Check","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"J$7","v":"2026-03-31"},{"$f":"K$7","v":"2026-06-30"},{"$f":"L$7","v":"2026-09-30"},{"$f":"M$7","v":"2026-12-31"},{"$f":"N$7","v":"2027-03-31"}]
[null,null,"Start Date",null,null,null,null,null,null,{"$f":"IF(J$9=1,Model_Start_Date,I$7+1)","v":"2026-03-10"},{"$f":"IF(K$9=1,Model_Start_Date,J$7+1)","v":"2026-04-01"},{"$f":"IF(L$9=1,Model_Start_Date,K$7+1)","v":"2026-07-01"},{"$f":"IF(M$9=1,Model_Start_Date,L$7+1)","v":"2026-10-01"},{"$f":"IF(N$9=1,Model_Start_Date,M$7+1)","v":"2027-01-01"}]
[null,null,"End Date",null,null,null,null,null,null,{"$f":"EOMONTH(J$6,MOD(Periodicity+Reporting_Month_Factor-MONTH(J$6),Periodicity))","v":"2026-03-31"},{"$f":"EOMONTH(K$6,MOD(Periodicity+Reporting_Month_Factor-MONTH(K$6),Periodicity))","v":"2026-06-30"},{"$f":"EOMONTH(L$6,MOD(Periodicity+Reporting_Month_Factor-MONTH(L$6),Periodicity))","v":"2026-09-30"},{"$f":"EOMONTH(M$6,MOD(Periodicity+Reporting_Month_Factor-MONTH(M$6),Periodicity))","v":"2026-12-31"},{"$f":"EOMONTH(N$6,MOD(Periodicity+Reporting_Month_Factor-MONTH(N$6),Periodicity))","v":"2027-03-31"}]
[null,null,"Number of Days",null,null,null,null,null,null,{"$f":"J7-J6+1","v":22},{"$f":"K7-K6+1","v":91},92,92,90]
[null,null,"Counter",null,null,null,null,null,null,{"$f":"N(I$9)+1","v":1},{"$f":"N(J$9)+1","v":2},3,4,5]
[]
[null,{"$f":"MAX($B$10:$B10)+1","v":1},"Timing Assumptions"]
[]
[null,null,"Data (do not change once modelling has commenced)"]
[]
[null,null,null,"Model Start Date",null,null,null,{"$f":"TODAY()","v":"2026-03-10"}]
[]
[null,null,null,"Number of Months in a Full Period",null,null,null,3]
[]
[null,null,null,"Example Reporting Month",null,null,null,12,{"$f":"\"e.g. \"&TEXT(DATE(YEAR(Model_Start_Date)+IF(Example_Reporting_Month<MONTH(Model_Start_Date),1,0),Example_Reporting_Month+1,1)-1,\"dd-Mmm-yy\")","v":"e.g. 31-Dec-26"}]
[]
[null,null,null,"Reporting Month Factor",null,null,null,{"$f":"MOD(Example_Reporting_Month-1,Periodicity)+1","v":3}]

{"sheet":"Error Checks","index":5,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,0,2,4]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\"),LEN(CELL(\"filename\"))-FIND(\"]\",CELL(\"filename\")))),\n\"\",\nRIGHT(CELL(\"filename\"),LEN(CELL(\"filename\"))-FIND(\"]\",CELL(\"filename\"))))","v":"Navigator"}]
[{"$f":"Model_Name","v":"SP Matrix Manipulation SN0.09.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,"Example"]
[]
[]
[]
[]
[null,null,null,null,{"$f":"C8","v":"Summary of Errors"},null,null,null,{"$f":"MIN(1,SUM(I11:I15))","v":0}]

{"sheet":"1D Array","index":6,"n_rows":78,"n_cols":16,"rows_kept":78,"cut":false,"hidden":false,"merged":[[2,0,2,5]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\"),LEN(CELL(\"filename\"))-FIND(\"]\",CELL(\"filename\")))),\n\"\",\nRIGHT(CELL(\"filename\"),LEN(CELL(\"filename\"))-FIND(\"]\",CELL(\"filename\"))))","v":"Navigator"}]
[{"$f":"Model_Name","v":"SP Matrix Manipulation SN0.09.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},{"$f":"A1","v":"Navigator"}]
[]
[null,null,"Data"]
[]
[null,null,null,null,"Number of Period",null,10]
[]
[null,null,null,null,"Period",null,{"$f":"_xlfn.SEQUENCE(1,Number_of_Periods)","v":1},2,3,4,5,6,7,8,9,10]
[]
[null,null,null,null,"Items"]
[null,null,null,null,null,null,{"$f":"_xlfn.RANDARRAY(1,Number_of_Periods,0,10,TRUE)","v":2},6,6,9,8,6,2,7,10,7]
[]
[null,null,"Cummulative Sum"]
[]
[null,null,null,null,"Helper Matrix",null,{"$f":"(_xlfn.ANCHORARRAY(G12)>=TRANSPOSE(_xlfn.ANCHORARRAY(G12)))*1","v":1},1,1,1,1,1,1,1,1,1]
[null,null,null,null,null,null,0,1,1,1,1,1,1,1,1,1]
[null,null,null,null,null,null,0,0,1,1,1,1,1,1,1,1]
[null,null,null,null,null,null,0,0,0,1,1,1,1,1,1,1]
[null,null,null,null,null,null,0,0,0,0,1,1,1,1,1,1]
[null,null,null,null,null,null,0,0,0,0,0,1,1,1,1,1]
[null,null,null,null,null,null,0,0,0,0,0,0,1,1,1,1]
[null,null,null,null,null,null,0,0,0,0,0,0,0,1,1,1]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,1,1]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,1]
[]
[]
[null,null,null,null,"MMULT SUM",null,{"$f":"MMULT(_xlfn.ANCHORARRAY(G15),_xlfn.ANCHORARRAY(G19))","v":2},8,14,23,31,37,39,46,56,63]
[]
[]
[null,null,null,null,"SUBTOTAL SUM",null,{"$f":"SUBTOTAL(9,OFFSET(_xlfn.ANCHORARRAY(G15),0,0,1,_xlfn.SEQUENCE(,Number_of_Periods)))","v":2},8,14,23,31,37,39,46,56,63]
[]
[]
[null,null,null,null,"Legacy SUM total",null,{"$f":"SUM(OFFSET(_xlfn.ANCHORARRAY(G15),0,0,1,_xlfn.SEQUENCE(,Number_of_Periods)))","v":2},8,14,23,31,37,39,46,56,63]
[]
[]
[null,null,"Cummulative Product"]
[]
[null,null,null,null,"Helper Matrix",null,{"$f":"(_xlfn.ANCHORARRAY(G12)>=TRANSPOSE(_xlfn.ANCHORARRAY(G12)))*1","v":1},1,1,1,1,1,1,1,1,1]
[null,null,null,null,null,null,0,1,1,1,1,1,1,1,1,1]
[null,null,null,null,null,null,0,0,1,1,1,1,1,1,1,1]
[null,null,null,null,null,null,0,0,0,1,1,1,1,1,1,1]
[null,null,null,null,null,null,0,0,0,0,1,1,1,1,1,1]
[null,null,null,null,null,null,0,0,0,0,0,1,1,1,1,1]
[null,null,null,null,null,null,0,0,0,0,0,0,1,1,1,1]
[null,null,null,null,null,null,0,0,0,0,0,0,0,1,1,1]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,1,1]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,1]
[]
[]
[null,null,null,null,"Log Matrix",null,{"$f":"IF(_xlfn.ANCHORARRAY(G15)=0,0,LN(_xlfn.ANCHORARRAY(G15)))","v":0.69314718055994529},1.791759469228055,1.791759469228055,2.1972245773362196,2.0794415416798357,1.791759469228055,0.69314718055994529,1.9459101490553132,2.3025850929940459,1.9459101490553132]
[]
[null,null,null,null,"Cummulative Sum of Log",null,{"$f":"MMULT(_xlfn.ANCHORARRAY(G54),_xlfn.ANCHORARRAY(G42))","v":0.69314718055994529},2.4849066497880004,4.2766661190160553,6.4738906963522744,8.5533322380321106,10.345091707260165,11.038238887820111,12.984149036875424,15.286734129869469,17.232644278924781]
[]
[null,null,null,null,"Power of Exponential",null,{"$f":"EXP(_xlfn.ANCHORARRAY(G56))","v":2},12,72,647.99999999999989,5184,31103.999999999985,62207.999999999978,435455.99999999988,4354559.9999999963,30481919.999999922]
[]
[]
[null,null,"Cummulative Max, Min, Average and Count"]
[]
[null,null,null,null,"Helper Matrix 1",null,{"$f":"ROUNDUP(_xlfn.SEQUENCE(ROWS(_xlfn.ANCHORARRAY(G15)),COLUMNS(_xlfn.ANCHORARRAY(G15)))/COLUMNS(_xlfn.ANCHORARRAY(G15)),0)","v":1},1,1,1,1,1,1,1,1,1]
[]
[]
[null,null,null,null,"Helper Matrix 2",null,{"$f":"MOD(_xlfn.SEQUENCE(ROWS(_xlfn.ANCHORARRAY(G15)),COLUMNS(_xlfn.ANCHORARRAY(G15)))-1,COLUMNS(_xlfn.ANCHORARRAY(G15)))+1","v":1},2,3,4,5,6,7,8,9,10]
[]
[]
[null,null,null,null,"Cummulative Max",null,{"$f":"_xlfn.MAXIFS(_xlfn.ANCHORARRAY(G15),_xlfn.ANCHORARRAY(G66),\"<=\"&_xlfn.ANCHORARRAY(G12))","v":2},6,6,9,9,9,9,9,10,10]
[]
[]
[null,null,null,null,"Cummulative Min",null,{"$f":"_xlfn.MINIFS(_xlfn.ANCHORARRAY(G15),_xlfn.ANCHORARRAY(G66),\"<=\"&_xlfn.ANCHORARRAY(G12))","v":2},2,2,2,2,2,2,2,2,2]
[]
[]
[null,null,null,null,"Cummulative Count",null,{"$f":"COUNTIFS(_xlfn.ANCHORARRAY(G15),_xlfn.ANCHORARRAY(G15),_xlfn.ANCHORARRAY(G66),\"<=\"&_xlfn.ANCHORARRAY(G12))","v":1},1,2,1,1,3,2,1,1,2]
[]
[]
[null,null,null,null,"Cummulative Average",null,{"$f":"AVERAGEIFS(_xlfn.ANCHORARRAY(G15),_xlfn.ANCHORARRAY(G66),\"<=\"&_xlfn.ANCHORARRAY(G12))","v":2},4,4.666666666666667,5.75,6.2,6.166666666666667,5.5714285714285712,5.75,6.2222222222222223,6.3]

{"sheet":"2D Array","index":7,"n_rows":323,"n_cols":19,"rows_kept":323,"cut":false,"hidden":false,"merged":[[2,0,2,5]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\"),LEN(CELL(\"filename\"))-FIND(\"]\",CELL(\"filename\")))),\n\"\",\nRIGHT(CELL(\"filename\"),LEN(CELL(\"filename\"))-FIND(\"]\",CELL(\"filename\"))))","v":"Navigator"}]
[{"$f":"Model_Name","v":"SP Matrix Manipulation SN0.09.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},{"$f":"A1","v":"Navigator"}]
[]
[null,null,"Data"]
[]
[null,null,null,null,"Number of Period",null,10]
[]
[null,null,null,null,"Period",null,{"$f":"_xlfn.SEQUENCE(1,Number_of_Periods)","v":1},2,3,4,5,6,7,8,9,10]
[]
[null,null,null,null,"Items"]
[null,null,null,null,{"$f":"{\"B\";\"B\";\"A\";\"A\";\"C\";\"A\";\"B\";\"B\";\"B\"}","v":"B"},null,{"$f":"{1,9,3,5,3,9,3,3,3,9;9,6,8,3,10,5,10,9,8,3;4,2,2,2,0,1,0,8,4,8;4,2,6,4,4,7,8,3,4,8;10,1,1,7,3,3,9,8,9,7;10,9,3,3,3,8,0,9,1,7;4,9,3,2,7,0,0,7,9,0;9,9,6,9,8,9,10,7,5,2;4,9,7,2,8,0,7,7,3,0}","v":1},9,3,5,3,9,3,3,3,9]
[null,null,null,null,"B",null,9,6,8,3,10,5,10,9,8,3]
[null,null,null,null,"A",null,4,2,2,2,0,1,0,8,4,8]
[null,null,null,null,"A",null,4,2,6,4,4,7,8,3,4,8]
[null,null,null,null,"C",null,10,1,1,7,3,3,9,8,9,7]
[null,null,null,null,"A",null,10,9,3,3,3,8,0,9,1,7]
[null,null,null,null,"B",null,4,9,3,2,7,0,0,7,9,0]
[null,null,null,null,"B",null,9,9,6,9,8,9,10,7,5,2]
[null,null,null,null,"B",null,4,9,7,2,8,0,7,7,3,0]
[]
[]
[null,null,"Row Total"]
[]
[null,null,null,"MMULT Total",null,null,"Limit is 1,048,576  x 16,384 ~ Rows x Columns"]
[]
[null,null,null,null,"Helper Matrix",null,{"$f":"TRANSPOSE(_xlfn.ANCHORARRAY(E15))","v":"B"},"B","A","A","C","A","B","B","B"]
[null,null,null,null,{"$f":"_xlfn.UNIQUE(_xlfn._xlws.SORT(_xlfn.ANCHORARRAY($E$15)))","v":"A"},null,{"$f":"N(_xlfn.ANCHORARRAY(E31)=_xlfn.ANCHORARRAY(G30))","v":0},0,1,1,0,1,0,0,0]
[null,null,null,null,"B",null,1,1,0,0,0,0,1,1,1]
[null,null,null,null,"C",null,0,0,0,0,1,0,0,0,0]
[]
[null,null,null,null,{"$f":"_xlfn.UNIQUE(_xlfn._xlws.SORT(_xlfn.ANCHORARRAY($E$15)))","v":"A"},null,{"$f":"MMULT(_xlfn.ANCHORARRAY(G31),_xlfn.ANCHORARRAY(G15))","v":18},13,11,9,7,16,8,20,9,23]
[null,null,null,null,"B",null,27,42,27,21,36,23,30,33,28,14]
[null,null,null,null,"C",null,10,1,1,7,3,3,9,8,9,7]
[]
[null,null,null,null,"Total",null,{"$f":"MMULT(_xlfn.SEQUENCE(,ROWS(_xlfn.ANCHORARRAY(E35)),1,0),_xlfn.ANCHORARRAY(G35))","v":55},56,39,37,46,42,47,61,46,44]
[]
[]
[null,null,null,"DROP REDUCE SUMIFS LAMBDA Total"]
[]
[null,null,null,null,{"$f":"_xlfn.UNIQUE(_xlfn._xlws.SORT(_xlfn.ANCHORARRAY($E$15)))","v":"A"},null,{"$f":"_xlfn.DROP(_xlfn.REDUCE(0,_xlfn.ANCHORARRAY(G12),_xlfn.LAMBDA(_xlpm.x,_xlpm.y,_xlfn.HSTACK(_xlpm.x,SUMIFS(INDEX(_xlfn.ANCHORARRAY(G15),0,_xlpm.y),_xlfn.ANCHORARRAY(E15),_xlfn.ANCHORARRAY(E44))))),,1)","v":18},13,11,9,7,16,8,20,9,23]
[null,null,null,null,"B",null,27,42,27,21,36,23,30,33,28,14]
[null,null,null,null,"C",null,10,1,1,7,3,3,9,8,9,7]
[]
[null,null,null,null,"Total",null,{"$f":"MMULT(_xlfn.SEQUENCE(,ROWS(_xlfn.ANCHORARRAY(E44)),1,0),_xlfn.ANCHORARRAY(G44))","v":55},56,39,37,46,42,47,61,46,44]
[]
[]
[null,null,null,"MAP LAMBDA Total",null,null,"Provided by Kris"]
[]
[null,null,null,null,{"$f":"_xlfn.UNIQUE(_xlfn._xlws.SORT(_xlfn.ANCHORARRAY($E$15)))","v":"A"},null,{"$f":"_xlfn.MAP(_xlfn._xlws.SORT(_xlfn.UNIQUE(_xlfn.ANCHORARRAY(E15)&\"-\"&_xlfn.ANCHORARRAY(G12))),_xlfn.LAMBDA(_xlpm.x,SUM((_xlfn.ANCHORARRAY(G12)=--_xlfn.TEXTAFTER(_xlpm.x,\"-\"))*(_xlfn.ANCHORARRAY(E15)=_xlfn.TEXTBEFORE(_xlpm.x,\"-\"))*_xlfn.ANCHORARRAY(G15))))","v":18},13,11,9,7,16,8,20,9,23]
[null,null,null,null,"B",null,27,42,27,21,36,23,30,33,28,14]
[null,null,null,null,"C",null,10,1,1,7,3,3,9,8,9,7]
[]
[null,null,null,null,"Total",null,{"$f":"_xlfn.BYCOL(_xlfn.ANCHORARRAY(G53),_xleta.SUM)","v":55},56,39,37,46,42,47,61,46,44]
[]
[]
[null,null,null,"REDUCE BYCOL LAMBDA Total",null,null,"Provided by Kris"]
[]
[null,null,null,null,{"$f":"_xlfn.UNIQUE(_xlfn._xlws.SORT(_xlfn.ANCHORARRAY($E$15)))","v":"A"},null,{"$f":"_xlfn.DROP(_xlfn.REDUCE(0,_xlfn.ANCHORARRAY(E62),_xlfn.LAMBDA(_xlpm.x,_xlpm.y,_xlfn.VSTACK(_xlpm.x,_xlfn.BYCOL(_xlfn.ANCHORARRAY(G15),_xlfn.LAMBDA(_xlpm.col,SUM(_xlpm.col*(_xlfn.ANCHORARRAY(E15)=_xlpm.y))))))),1)","v":18},13,11,9,7,16,8,20,9,23]
[null,null,null,null,"B",null,27,42,27,21,36,23,30,33,28,14]
[null,null,null,null,"C",null,10,1,1,7,3,3,9,8,9,7]
[]
[null,null,null,null,"Total",null,{"$f":"_xlfn.BYCOL(_xlfn.ANCHORARRAY(G62),_xleta.SUM)","v":55},56,39,37,46,42,47,61,46,44]
[]
[]
[null,null,null,"MAKEARRAY LAMBDA Total",null,null,"Limit is 1,048,576  x 16,384 ~ Rows x Columns"]
[]
[null,null,null,null,{"$f":"_xlfn.UNIQUE(_xlfn._xlws.SORT(_xlfn.ANCHORARRAY($E$15)))","v":"A"},null,{"$f":"_xlfn.MAKEARRAY(ROWS(_xlfn.ANCHORARRAY(E71)),Number_of_Periods,_xlfn.LAMBDA(_xlpm.rw,_xlpm.cl,SUM((_xlfn.ANCHORARRAY(E15)=INDEX(_xlfn.ANCHORARRAY(E71),_xlpm.rw))*INDEX(_xlfn.ANCHORARRAY(G15),_xlfn.SEQUENCE(ROWS(_xlfn.ANCHORARRAY(E15))),_xlpm.cl))))","v":18},13,11,9,7,16,8,20,9,23]
[null,null,null,null,"B",null,27,42,27,21,36,23,30,33,28,14]
[null,null,null,null,"C",null,10,1,1,7,3,3,9,8,9,7]
[]
[null,null,null,null,"Total",null,{"$f":"_xlfn.BYCOL(_xlfn.ANCHORARRAY(G53),_xleta.SUM)","v":55},56,39,37,46,42,47,61,46,44]
[]
[]
[null,null,null,"GROUPBY",null,null,"Provided by Kris"]
[]
[null,null,null,null,null,{"$f":"_xlfn.GROUPBY(_xlfn.ANCHORARRAY(E15),_xlfn.ANCHORARRAY(G15),_xleta.SUM,0,0)","v":"A"},18,13,11,9,7,16,8,20,9,23]
[null,null,null,null,null,"B",27,42,27,21,36,23,30,33,28,14]
[null,null,null,null,null,"C",10,1,1,7,3,3,9,8,9,7]
[]
[]
[null,null,null,"SUBTOTAL Total"]
[]
[null,null,null,null,"Sorted Matrix"]
[null,null,null,null,{"$f":"_xlfn._xlws.SORT(_xlfn.ANCHORARRAY(E15))","v":"A"},null,{"$f":"_xlfn.SORTBY(_xlfn.ANCHORARRAY(G15),_xlfn.ANCHORARRAY(E15))","v":4},2,2,2,0,1,0,8,4,8]
[null,null,null,null,"A",null,4,2,6,4,4,7,8,3,4,8]
[null,null,null,null,"A",null,10,9,3,3,3,8,0,9,1,7]
[null,null,null,null,"B",null,1,9,3,5,3,9,3,3,3,9]
[null,null,null,null,"B",null,9,6,8,3,10,5,10,9,8,3]
[null,null,null,null,"B",null,4,9,3,2,7,0,0,7,9,0]
[null,null,null,null,"B",null,9,9,6,9,8,9,10,7,5,2]
[null,null,null,null,"B",null,4,9,7,2,8,0,7,7,3,0]
[null,null,null,null,"C",null,10,1,1,7,3,3,9,8,9,7]
[]
[]
[null,null,null,null,{"$f":"CHAR(_xlfn.SEQUENCE(3,,65))","v":"A"},null,{"$f":"SUBTOTAL(9,OFFSET(_xlfn.ANCHORARRAY(G88),MATCH(_xlfn.ANCHORARRAY(E99),_xlfn.ANCHORARRAY(E88),0)-1,_xlfn.SEQUENCE(,Number_of_Periods,0),COUNTIF(_xlfn.ANCHORARRAY(E88),_xlfn.ANCHORARRAY(E99)),1))","v":18},13,11,9,7,16,8,20,9,23]
[null,null,null,null,"B",null,27,42,27,21,36,23,30,33,28,14]
[null,null,null,null,"C",null,10,1,1,7,3,3,9,8,9,7]
[]
[]
[null,null,null,null,"Helper Explain Calc"]
[]
[null,null,null,null,null,null,{"$f":"_xlfn.SEQUENCE(,Number_of_Periods,0)","v":0},1,2,3,4,5,6,7,8,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Start Position","Height"]
[null,null,null,null,{"$f":"CHAR(_xlfn.SEQUENCE(3,,65))","v":"A"},null,{"$f":"OFFSET(_xlfn.ANCHORARRAY(G88),{0;3;8},_xlfn.ANCHORARRAY(G106),{3;5;1},1)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,{"$f":"{0;3;8}","v":0},{"$f":"{3;5;1}","v":3}]
[null,null,null,null,"B",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,3,5]
[null,null,null,null,"C",null,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,8,1]
[]
[null,null,null,null,"A",null,{"$f":"OFFSET($G$88,$R$108,G106,$S$108,1)","v":4},{"$f":"OFFSET($G$88,$R$108,H106,$S$108,1)","v":2},{"$f":"OFFSET($G$88,$R$108,I106,$S$108,1)","v":2},{"$f":"OFFSET($G$88,$R$108,J106,$S$108,1)","v":2},{"$f":"OFFSET($G$88,$R$108,K106,$S$108,1)","v":0},{"$f":"OFFSET($G$88,$R$108,L106,$S$108,1)","v":1},{"$f":"OFFSET($G$88,$R$108,M106,$S$108,1)","v":0},{"$f":"OFFSET($G$88,$R$108,N106,$S$108,1)","v":8},{"$f":"OFFSET($G$88,$R$108,O106,$S$108,1)","v":4},{"$f":"OFFSET($G$88,$R$108,P106,$S$108,1)","v":8}]
[null,null,null,null,null,null,4,2,6,4,4,7,8,3,4,8]
[null,null,null,null,null,null,10,9,3,3,3,8,0,9,1,7]
[]
[]
[null,null,null,null,null,null,"This setup allow to create range within a cell."]
[null,null,null,null,null,null,{"$f":"\"Each #VALUE on row \"&ROW(G108)&\" trying to display value of row \"&ROW(G112)&\" to row \"&ROW(G112)+ROWS(_xlfn.ANCHORARRAY(G112))&\" within 1 cell\"","v":"Each #VALUE on row 108 trying to display value of row 112 to row 115 within 1 cell"}]
[null,null,null,null,null,null,"This is the reason why we need to sort the categories set up first before proceed with SUBTOTAL OFFSET"]
[null,null,null,null,null,null,"SUBTOTAL then loop through each cell then sum the value within 1 cell."]
[]
[]
[null,null,null,"SUMIF Total",null,null,"Provided by Oscar"]
[]
[null,null,null,null,{"$f":"CHAR(_xlfn.SEQUENCE(3,,65))","v":"A"},null,{"$f":"SUMIF(_xlfn.ANCHORARRAY(E15),_xlfn.ANCHORARRAY(E35),OFFSET(F15,,_xlfn.ANCHORARRAY(G12)))","v":18},13,11,9,7,16,8,20,9,23]
[null,null,null,null,"B",null,27,42,27,21,36,23,30,33,28,14]
[null,null,null,null,"C",null,10,1,1,7,3,3,9,8,9,7]
[]
[]
[null,null,null,"SUMIFS Total",null,null,"Provided by Oscar"]
[]
[null,null,null,null,{"$f":"CHAR(_xlfn.SEQUENCE(3,,65))","v":"A"},null,{"$f":"SUMIFS(OFFSET(_xlfn.ANCHORARRAY(E15),,1+_xlfn.ANCHORARRAY(G12)),_xlfn.ANCHORARRAY(E15),_xlfn.ANCHORARRAY(E132))","v":18},13,11,9,7,16,8,20,9,23]
[null,null,null,null,"B",null,27,42,27,21,36,23,30,33,28,14]
[null,null,null,null,"C",null,10,1,1,7,3,3,9,8,9,7]
[]
[]
[null,null,null,"Legacy SUM Total"]
[]
[null,null,null,null,"Helper Matrix"]
[null,null,null,null,{"$f":"_xlfn._xlws.SORT(_xlfn.ANCHORARRAY(E15))","v":"A"},null,{"$f":"_xlfn.SORTBY(_xlfn.ANCHORARRAY(G15),_xlfn.ANCHORARRAY(E15))","v":4},2,2,2,0,1,0,8,4,8]
[null,null,null,null,"A",null,4,2,6,4,4,7,8,3,4,8]
[null,null,null,null,"A",null,10,9,3,3,3,8,0,9,1,7]
[null,null,null,null,"B",null,1,9,3,5,3,9,3,3,3,9]
[null,null,null,null,"B",null,9,6,8,3,10,5,10,9,8,3]
[null,null,null,null,"B",null,4,9,3,2,7,0,0,7,9,0]
[null,null,null,null,"B",null,9,9,6,9,8,9,10,7,5,2]
[null,null,null,null,"B",null,4,9,7,2,8,0,7,7,3,0]
[null,null,null,null,"C",null,10,1,1,7,3,3,9,8,9,7]
[]
[]
[null,null,null,null,{"$f":"CHAR(_xlfn.SEQUENCE(3,,65))","v":"A"},null,{"$f":"SUM(OFFSET(_xlfn.ANCHORARRAY(G140),MATCH(_xlfn.ANCHORARRAY(E151),_xlfn.ANCHORARRAY(E140),0)-1,,COUNTIF(_xlfn.ANCHORARRAY(E140),_xlfn.ANCHORARRAY(E151)),_xlfn.SEQUENCE(,Number_of_Periods)))","v":18},31,42,51,58,74,82,102,111,134]
[null,null,null,null,"B",null,27,69,96,117,153,176,206,239,267,281]
[null,null,null,null,"C",null,10,11,12,19,22,25,34,42,51,58]
[]
[]
[null,null,"Cummulative Sum"]
[]
[null,null,null,"MMULT SUM"]
[]
[null,null,null,null,"Helper Matrix",null,{"$f":"(_xlfn.ANCHORARRAY(G12)>=TRANSPOSE(_xlfn.ANCHORARRAY(G12)))*1","v":1},1,1,1,1,1,1,1,1,1]
[null,null,null,null,null,null,0,1,1,1,1,1,1,1,1,1]
[null,null,null,null,null,null,0,0,1,1,1,1,1,1,1,1]
[null,null,null,null,null,null,0,0,0,1,1,1,1,1,1,1]
[null,null,null,null,null,null,0,0,0,0,1,1,1,1,1,1]
[null,null,null,null,null,null,0,0,0,0,0,1,1,1,1,1]
[null,null,null,null,null,null,0,0,0,0,0,0,1,1,1,1]
[null,null,null,null,null,null,0,0,0,0,0,0,0,1,1,1]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,1,1]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,1]
[]
[]
[]
[null,null,null,null,{"$f":"_xlfn.ANCHORARRAY(E15)","v":"B"},null,{"$f":"MMULT(_xlfn.ANCHORARRAY(G15),_xlfn.ANCHORARRAY(G160))","v":1},10,13,18,21,30,33,36,39,48]
[null,null,null,null,"B",null,9,15,23,26,36,41,51,60,68,71]
[null,null,null,null,"A",null,4,6,8,10,10,11,11,19,23,31]
[null,null,null,null,"A",null,4,6,12,16,20,27,35,38,42,50]
[null,null,null,null,"C",null,10,11,12,19,22,25,34,42,51,58]
[null,null,null,null,"A",null,10,19,22,25,28,36,36,45,46,53]
[null,null,null,null,"B",null,4,13,16,18,25,25,25,32,41,41]
[null,null,null,null,"B",null,9,18,24,33,41,50,60,67,72,74]
[null,null,null,null,"B",null,4,13,20,22,30,30,37,44,47,47]
[]
[]
[null,null,null,"SUBTOTAL SUM"]
[]
[null,null,null,null,null,null,{"$f":"SUBTOTAL(9,OFFSET(_xlfn.ANCHORARRAY(G15),_xlfn.SEQUENCE(ROWS(_xlfn.ANCHORARRAY(G15)),,0),0,1,_xlfn.SEQUENCE(,Number_of_Periods)))","v":1},10,13,18,21,30,33,36,39,48]
[null,null,null,null,null,null,9,15,23,26,36,41,51,60,68,71]
[null,null,null,null,null,null,4,6,8,10,10,11,11,19,23,31]
[null,null,null,null,null,null,4,6,12,16,20,27,35,38,42,50]
[null,null,null,null,null,null,10,11,12,19,22,25,34,42,51,58]
[null,null,null,null,null,null,10,19,22,25,28,36,36,45,46,53]
[null,null,null,null,null,null,4,13,16,18,25,25,25,32,41,41]
[null,null,null,null,null,null,9,18,24,33,41,50,60,67,72,74]
[null,null,null,null,null,null,4,13,20,22,30,30,37,44,47,47]
[]
[null,null,null,"Legacy SUM total"]
[]
[null,null,null,null,null,null,{"$f":"SUM(OFFSET(_xlfn.ANCHORARRAY(G15),_xlfn.SEQUENCE(ROWS(_xlfn.ANCHORARRAY(G15)),,0),0,1,_xlfn.SEQUENCE(,Number_of_Periods)))","v":1},10,13,18,21,30,33,36,39,48]
[null,null,null,null,null,null,9,15,23,26,36,41,51,60,68,71]
[null,null,null,null,null,null,4,6,8,10,10,11,11,19,23,31]
[null,null,null,null,null,null,4,6,12,16,20,27,35,38,42,50]
[null,null,null,null,null,null,10,11,12,19,22,25,34,42,51,58]
[null,null,null,null,null,null,10,19,22,25,28,36,36,45,46,53]
[null,null,null,null,null,null,4,13,16,18,25,25,25,32,41,41]
[null,null,null,null,null,null,9,18,24,33,41,50,60,67,72,74]
[null,null,null,null,null,null,4,13,20,22,30,30,37,44,47,47]
[]
[]
[null,null,"Cummulative Product",null,null,null,"Doesn't work with 0 inside the array"]
[]
[null,null,null,null,"Helper Matrix",null,{"$f":"(_xlfn.ANCHORARRAY(G12)>=TRANSPOSE(_xlfn.ANCHORARRAY(G12)))*1","v":1},1,1,1,1,1,1,1,1,1]
[null,null,null,null,null,null,0,1,1,1,1,1,1,1,1,1]
[null,null,null,null,null,null,0,0,1,1,1,1,1,1,1,1]
[null,null,null,null,null,null,0,0,0,1,1,1,1,1,1,1]
[null,null,null,null,null,null,0,0,0,0,1,1,1,1,1,1]
[null,null,null,null,null,null,0,0,0,0,0,1,1,1,1,1]
[null,null,null,null,null,null,0,0,0,0,0,0,1,1,1,1]
[null,null,null,null,null,null,0,0,0,0,0,0,0,1,1,1]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,1,1]
[null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,1]
[]
[null,null,null,null,"Log Matrix"]
[]
[null,null,null,null,{"$f":"_xlfn.ANCHORARRAY(E173)","v":"B"},null,{"$f":"IF(_xlfn.ANCHORARRAY(G15)=0,0,LN(_xlfn.ANCHORARRAY(G15)))","v":0},2.1972245773362196,1.0986122886681098,1.6094379124341003,1.0986122886681098,2.1972245773362196,1.0986122886681098,1.0986122886681098,1.0986122886681098,2.1972245773362196]
[null,null,null,null,"B",null,2.1972245773362196,1.791759469228055,2.0794415416798357,1.0986122886681098,2.3025850929940459,1.6094379124341003,2.3025850929940459,2.1972245773362196,2.0794415416798357,1.0986122886681098]
[null,null,null,null,"A",null,1.3862943611198906,0.69314718055994529,0.69314718055994529,0.69314718055994529,0,0,0,2.0794415416798357,1.3862943611198906,2.0794415416798357]
[null,null,null,null,"A",null,1.3862943611198906,0.69314718055994529,1.791759469228055,1.3862943611198906,1.3862943611198906,1.9459101490553132,2.0794415416798357,1.0986122886681098,1.3862943611198906,2.0794415416798357]
[null,null,null,null,"C",null,2.3025850929940459,0,0,1.9459101490553132,1.0986122886681098,1.0986122886681098,2.1972245773362196,2.0794415416798357,2.1972245773362196,1.9459101490553132]
[null,null,null,null,"A",null,2.3025850929940459,2.1972245773362196,1.0986122886681098,1.0986122886681098,1.0986122886681098,2.0794415416798357,0,2.1972245773362196,0,1.9459101490553132]
[null,null,null,null,"B",null,1.3862943611198906,2.1972245773362196,1.0986122886681098,0.69314718055994529,1.9459101490553132,0,0,1.9459101490553132,2.1972245773362196,0]
[null,null,null,null,"B",null,2.1972245773362196,2.1972245773362196,1.791759469228055,2.1972245773362196,2.0794415416798357,2.1972245773362196,2.3025850929940459,1.9459101490553132,1.6094379124341003,0.69314718055994529]
[null,null,null,null,"B",null,1.3862943611198906,2.1972245773362196,1.9459101490553132,0.69314718055994529,2.0794415416798357,0,1.9459101490553132,1.9459101490553132,1.0986122886681098,0]
[]
[null,null,null,null,"Cummulative Sum of Log"]
[]
[null,null,null,null,{"$f":"_xlfn.ANCHORARRAY(E173)","v":"B"},null,{"$f":"MMULT(_xlfn.ANCHORARRAY(G224),_xlfn.ANCHORARRAY(G211))","v":0},2.1972245773362196,3.2958368660043291,4.9052747784384296,6.0038870671065396,8.2011116444427596,9.2997239331108688,10.398336221778978,11.496948510447087,13.694173087783307]
[null,null,null,null,"B",null,2.1972245773362196,3.9889840465642745,6.0684255882441107,7.1670378769122207,9.4696229699062666,11.079060882340366,13.381645975334411,15.578870552670631,17.658312094350467,18.756924383018578]
[null,null,null,null,"A",null,1.3862943611198906,2.0794415416798357,2.7725887222397811,3.4657359027997265,3.4657359027997265,3.4657359027997265,3.4657359027997265,5.5451774444795623,6.9314718055994531,9.0109133472792884]
[null,null,null,null,"A",null,1.3862943611198906,2.0794415416798357,3.8712010109078907,5.2574953720277815,6.6437897331476723,8.5896998822029857,10.669141423882822,11.767753712550931,13.154048073670822,15.233489615350658]
[null,null,null,null,"C",null,2.3025850929940459,2.3025850929940459,2.3025850929940459,4.2484952420493594,5.3471075307174694,6.4457198193855794,8.6429443967217985,10.722385938401635,12.919610515737855,14.865520664793168]
[null,null,null,null,"A",null,2.3025850929940459,4.499809670330265,5.598421958998375,6.697034247666485,7.795646536334595,9.8750880780144303,9.8750880780144303,12.07231265535065,12.07231265535065,14.018222804405964]
[null,null,null,null,"B",null,1.3862943611198906,3.5835189384561099,4.6821312271242199,5.3752784076841653,7.3211885567394788,7.3211885567394788,7.3211885567394788,9.2670987057947922,11.464323283131012,11.464323283131012]
[null,null,null,null,"B",null,2.1972245773362196,4.3944491546724391,6.1862086239004945,8.3834332012367145,10.462874742916551,12.660099320252771,14.962684413246816,16.908594562302127,18.518032474736227,19.211179655296171]
[null,null,null,null,"B",null,1.3862943611198906,3.5835189384561099,5.5294290875114234,6.2225762680713688,8.3020178097512041,8.3020178097512041,10.247927958806518,12.193838107861831,13.29245039652994,13.29245039652994]
[]
[null,null,null,null,"Power of Exponential"]
[]
[null,null,null,null,{"$f":"_xlfn.ANCHORARRAY(E173)","v":"B"},null,{"$f":"EXP(_xlfn.ANCHORARRAY(G236))","v":1},9.0000000000000018,27,135.00000000000003,405.00000000000023,3645.0000000000041,10935.000000000005,32805,98414.999999999942,885735]
[null,null,null,null,"B",null,9.0000000000000018,54.000000000000007,432.00000000000017,1296.0000000000009,12960.000000000013,64800.000000000015,647999.99999999965,5832000.0000000009,46656000.000000015,139968000.00000021]
[null,null,null,null,"A",null,4,7.9999999999999982,15.999999999999998,32,32,32,32,255.99999999999994,1024,8191.9999999999945]
[null,null,null,null,"A",null,4,7.9999999999999982,47.999999999999986,192,768.00000000000011,5376.0000000000018,43008.000000000022,129024,516096.00000000006,4128768.0000000019]
[null,null,null,null,"C",null,10.000000000000002,10.000000000000002,10.000000000000002,70.000000000000028,210.00000000000014,630.00000000000057,5670.0000000000045,45360.000000000044,408240.00000000064,2857680.0000000051]
[null,null,null,null,"A",null,10.000000000000002,90,270.00000000000006,810.00000000000045,2430.0000000000023,19440.000000000004,19440.000000000004,174960.00000000015,174960.00000000015,1224720.0000000012]
[null,null,null,null,"B",null,4,36,108.00000000000003,216.00000000000006,1512.0000000000007,1512.0000000000007,1512.0000000000007,10584.000000000007,95256.000000000116,95256.000000000116]
[null,null,null,null,"B",null,9.0000000000000018,81.000000000000028,486.0000000000004,4374.0000000000064,34992.000000000058,314928.0000000007,3149280.0000000051,22044960,110224799.99999991,220449599.99999946]
[null,null,null,null,"B",null,4,36,252.00000000000003,504.00000000000006,4031.9999999999982,4031.9999999999982,28223.999999999989,197567.99999999997,592703.99999999953,592703.99999999953]
[]
[]
[null,null,"Cummulative Max, Min and Count"]
[]
[null,null,null,null,"Helper Matrix 1"]
[]
[null,null,null,null,{"$f":"_xlfn.ANCHORARRAY(E15)","v":"B"},null,{"$f":"ROUNDUP(_xlfn.SEQUENCE(ROWS(_xlfn.ANCHORARRAY(G15)),COLUMNS(_xlfn.ANCHORARRAY(G15)))/COLUMNS(_xlfn.ANCHORARRAY(G15)),0)","v":1},1,1,1,1,1,1,1,1,1]
[null,null,null,null,"B",null,2,2,2,2,2,2,2,2,2,2]
[null,null,null,null,"A",null,3,3,3,3,3,3,3,3,3,3]
[null,null,null,null,"A",null,4,4,4,4,4,4,4,4,4,4]
[null,null,null,null,"C",null,5,5,5,5,5,5,5,5,5,5]
[null,null,null,null,"A",null,6,6,6,6,6,6,6,6,6,6]
[null,null,null,null,"B",null,7,7,7,7,7,7,7,7,7,7]
[null,null,null,null,"B",null,8,8,8,8,8,8,8,8,8,8]
[null,null,null,null,"B",null,9,9,9,9,9,9,9,9,9,9]
[]
[]
[null,null,null,null,"Helper Matrix 2"]
[]
[null,null,null,null,{"$f":"_xlfn.ANCHORARRAY(E15)","v":"B"},null,{"$f":"MOD(_xlfn.SEQUENCE(ROWS(_xlfn.ANCHORARRAY(G15)),COLUMNS(_xlfn.ANCHORARRAY(G15)))-1,COLUMNS(_xlfn.ANCHORARRAY(G15)))+1","v":1},2,3,4,5,6,7,8,9,10]
[null,null,null,null,"B",null,1,2,3,4,5,6,7,8,9,10]
[null,null,null,null,"A",null,1,2,3,4,5,6,7,8,9,10]
[null,null,null,null,"A",null,1,2,3,4,5,6,7,8,9,10]
[null,null,null,null,"C",null,1,2,3,4,5,6,7,8,9,10]
[null,null,null,null,"A",null,1,2,3,4,5,6,7,8,9,10]
[null,null,null,null,"B",null,1,2,3,4,5,6,7,8,9,10]
[null,null,null,null,"B",null,1,2,3,4,5,6,7,8,9,10]
[null,null,null,null,"B",null,1,2,3,4,5,6,7,8,9,10]
[]
[]
[null,null,null,"Cummulative Max"]
[]
[null,null,null,null,{"$f":"_xlfn.ANCHORARRAY(E15)","v":"B"},null,{"$f":"_xlfn.MAXIFS(_xlfn.ANCHORARRAY(G15),_xlfn.ANCHORARRAY(G263),_xlfn.SEQUENCE(COUNTA(_xlfn.ANCHORARRAY(E289))),_xlfn.ANCHORARRAY(G276),\"<=\"&_xlfn.ANCHORARRAY(G12))","v":1},9,9,9,9,9,9,9,9,9]
[null,null,null,null,"B",null,9,9,9,9,10,10,10,10,10,10]
[null,null,null,null,"A",null,4,4,4,4,4,4,4,8,8,8]
[null,null,null,null,"A",null,4,4,6,6,6,7,8,8,8,8]
[null,null,null,null,"C",null,10,10,10,10,10,10,10,10,10,10]
[null,null,null,null,"A",null,10,10,10,10,10,10,10,10,10,10]
[null,null,null,null,"B",null,4,9,9,9,9,9,9,9,9,9]
[null,null,null,null,"B",null,9,9,9,9,9,9,10,10,10,10]
[null,null,null,null,"B",null,4,9,9,9,9,9,9,9,9,9]
[]
[]
[null,null,null,"Cummulative Min"]
[]
[null,null,null,null,{"$f":"_xlfn.ANCHORARRAY(E15)","v":"B"},null,{"$f":"_xlfn.MINIFS(_xlfn.ANCHORARRAY(G15),_xlfn.ANCHORARRAY(G263),_xlfn.SEQUENCE(COUNTA(_xlfn.ANCHORARRAY(E289))),_xlfn.ANCHORARRAY(G276),\"<=\"&_xlfn.ANCHORARRAY(G12))","v":1},1,1,1,1,1,1,1,1,1]
[null,null,null,null,"B",null,9,6,6,3,3,3,3,3,3,3]
[null,null,null,null,"A",null,4,2,2,2,0,0,0,0,0,0]
[null,null,null,null,"A",null,4,2,2,2,2,2,2,2,2,2]
[null,null,null,null,"C",null,10,1,1,1,1,1,1,1,1,1]
[null,null,null,null,"A",null,10,9,3,3,3,3,0,0,0,0]
[null,null,null,null,"B",null,4,4,3,2,2,0,0,0,0,0]
[null,null,null,null,"B",null,9,9,6,6,6,6,6,6,5,2]
[null,null,null,null,"B",null,4,4,4,2,2,0,0,0,0,0]
[]
[]
[null,null,null,"Cummulative Count"]
[]
[null,null,null,null,{"$f":"_xlfn.ANCHORARRAY(E15)","v":"B"},null,{"$f":"COUNTIFS(_xlfn.ANCHORARRAY(G15),_xlfn.ANCHORARRAY(G15),_xlfn.ANCHORARRAY(G263),_xlfn.SEQUENCE(COUNTA(_xlfn.ANCHORARRAY(E289))),_xlfn.ANCHORARRAY(G276),\"<=\"&_xlfn.ANCHORARRAY(G12))","v":1},1,1,1,2,2,3,4,5,3]
[null,null,null,null,"B",null,1,1,1,1,1,1,2,2,2,2]
[null,null,null,null,"A",null,1,1,2,3,1,1,2,1,2,2]
[null,null,null,null,"A",null,1,1,1,2,3,1,1,1,4,2]
[null,null,null,null,"C",null,1,1,2,1,1,2,1,1,2,2]
[null,null,null,null,"A",null,1,1,1,2,3,1,1,2,1,1]
[null,null,null,null,"B",null,1,1,1,1,1,1,2,2,2,3]
[null,null,null,null,"B",null,1,2,1,3,1,4,1,1,1,1]
[null,null,null,null,"B",null,1,1,1,1,1,1,2,3,1,2]

{"sheet":"3D Array","index":8,"n_rows":135,"n_cols":14,"rows_kept":135,"cut":false,"hidden":false,"merged":[[2,0,2,5]]}
[{"$f":"IF(ISERROR(RIGHT(CELL(\"filename\"),LEN(CELL(\"filename\"))-FIND(\"]\",CELL(\"filename\")))),\n\"\",\nRIGHT(CELL(\"filename\"),LEN(CELL(\"filename\"))-FIND(\"]\",CELL(\"filename\"))))","v":"Navigator"}]
[{"$f":"Model_Name","v":"SP Matrix Manipulation SN0.09.xlsm"}]
["Navigator"]
[null,"Error Checks:",null,null,null,null,{"$f":"Overall_Error_Check","v":0}]
[]
[null,{"$f":"MAX($B$5:$B5)+1","v":1},{"$f":"A1","v":"Navigator"}]
[]
[null,null,"List of Functions Support 3D"]
[]
[null,null,null,null,"AND","The logical AND for any number of arguments."]
[null,null,null,null,"AVEDEV","The average deviation for a list of numbers."]
[null,null,null,null,"AVERAGE","The arithmetic mean of a list or array of numbers."]
[null,null,null,null,"AVERAGEA","The arithmetic mean of a list or array of numbers, including text and logical values."]
[null,null,null,null,"COUNT","The number of cells with a numeric value in a list or cell range."]
[null,null,null,null,"COUNTA","The number of non blank cells in a list or cell range."]
[null,null,null,null,"DEVSQ","The sum of squares of deviations of data points from their sample mean."]
[null,null,null,null,"LARGE","The Kth largest value in an array of numbers."]
[null,null,null,null,"MAX","The largest value in a list or array of numbers."]
[null,null,null,null,"MAXA","The largest value in a list or array of numbers, including text and logical values."]
[null,null,null,null,"MEDIAN","The median of the numbers in a list or cell range."]
[null,null,null,null,"MIN","The smallest number in a list or range."]
[null,null,null,null,"MINA","The smallest number in a list or range, including text and logical values"]
[null,null,null,null,"OR","The logical OR for any number of arguments."]
[null,null,null,null,"PERCENTILE","The Kth percentile of values in a range."]
[null,null,null,null,"PRODUCT","The product of all the numbers in a list or cell range."]
[null,null,null,null,"QUARTILE","The quartile of a data set."]
[null,null,null,null,"RANK","The rank of a value in a range (in descending order)."]
[null,null,null,null,"SKEW","The number representing the skewness of a distribution."]
[null,null,null,null,"SMALL","The Kth smallest value in an array of numbers."]
[null,null,null,null,"STDEV","The standard deviation based on a sample."]
[null,null,null,null,"STDEVA","The standard deviation based on a sample, including text and logical values."]
[null,null,null,null,"STDEVP","The standard deviation based on an entire population."]
[null,null,null,null,"STDEVPA","The standard deviation based on an entire population, including text and logical values."]
[null,null,null,null,"SUM","The total value of the numbers in a list or cell range."]
[null,null,null,null,"SUMSQ","The sum of the squares of all the values in a list or cell range."]
[null,null,null,null,"TRIM","The text string with all spaces removed from the beginning and end."]
[null,null,null,null,"VAR","The compound variance based upon the numerical values in the range."]
[null,null,null,null,"VARA","The compound variance based upon the numerical values in the range."]
[null,null,null,null,"VARP","The variance based on an entire population."]
[null,null,null,null,"VARPA","The variance based on an entire population, including text and logical values."]
[]
[]
[null,null,"SUM"]
[null,null,null,null,"Scalar Result"]
[null,null,null,null,{"$f":"SUM(A:B!B1)","v":3},{"$f":"SUM(A:B!C1)","v":27},{"$f":"SUM(A:B!D1)","v":9},{"$f":"SUM(A:B!E1)","v":15},{"$f":"SUM(A:B!F1)","v":9},{"$f":"SUM(A:B!G1)","v":27},{"$f":"SUM(A:B!H1)","v":9},{"$f":"SUM(A:B!I1)","v":9},{"$f":"SUM(A:B!J1)","v":9},{"$f":"SUM(A:B!K1)","v":27}]
[null,null,null,null,{"$f":"SUM(A:B!B2)","v":27},{"$f":"SUM(A:B!C2)","v":18},{"$f":"SUM(A:B!D2)","v":24},{"$f":"SUM(A:B!E2)","v":9},{"$f":"SUM(A:B!F2)","v":30},{"$f":"SUM(A:B!G2)","v":15},{"$f":"SUM(A:B!H2)","v":30},{"$f":"SUM(A:B!I2)","v":27},{"$f":"SUM(A:B!J2)","v":24},{"$f":"SUM(A:B!K2)","v":9}]
[null,null,null,null,{"$f":"SUM(A:B!B3)","v":12},{"$f":"SUM(A:B!C3)","v":6},{"$f":"SUM(A:B!D3)","v":6},{"$f":"SUM(A:B!E3)","v":6},{"$f":"SUM(A:B!F3)","v":0},{"$f":"SUM(A:B!G3)","v":3},{"$f":"SUM(A:B!H3)","v":0},{"$f":"SUM(A:B!I3)","v":24},{"$f":"SUM(A:B!J3)","v":12},{"$f":"SUM(A:B!K3)","v":24}]
[null,null,null,null,{"$f":"SUM(A:B!B4)","v":12},{"$f":"SUM(A:B!C4)","v":6},{"$f":"SUM(A:B!D4)","v":18},{"$f":"SUM(A:B!E4)","v":12},{"$f":"SUM(A:B!F4)","v":12},{"$f":"SUM(A:B!G4)","v":21},{"$f":"SUM(A:B!H4)","v":24},{"$f":"SUM(A:B!I4)","v":9},{"$f":"SUM(A:B!J4)","v":12},{"$f":"SUM(A:B!K4)","v":24}]
[null,null,null,null,{"$f":"SUM(A:B!B5)","v":30},{"$f":"SUM(A:B!C5)","v":3},{"$f":"SUM(A:B!D5)","v":3},{"$f":"SUM(A:B!E5)","v":21},{"$f":"SUM(A:B!F5)","v":9},{"$f":"SUM(A:B!G5)","v":9},{"$f":"SUM(A:B!H5)","v":27},{"$f":"SUM(A:B!I5)","v":24},{"$f":"SUM(A:B!J5)","v":27},{"$f":"SUM(A:B!K5)","v":21}]
[null,null,null,null,{"$f":"SUM(A:B!B6)","v":30},{"$f":"SUM(A:B!C6)","v":27},{"$f":"SUM(A:B!D6)","v":9},{"$f":"SUM(A:B!E6)","v":9},{"$f":"SUM(A:B!F6)","v":9},{"$f":"SUM(A:B!G6)","v":24},{"$f":"SUM(A:B!H6)","v":0},{"$f":"SUM(A:B!I6)","v":27},{"$f":"SUM(A:B!J6)","v":3},{"$f":"SUM(A:B!K6)","v":21}]
[null,null,null,null,{"$f":"SUM(A:B!B7)","v":12},{"$f":"SUM(A:B!C7)","v":27},{"$f":"SUM(A:B!D7)","v":9},{"$f":"SUM(A:B!E7)","v":6},{"$f":"SUM(A:B!F7)","v":21},{"$f":"SUM(A:B!G7)","v":0},{"$f":"SUM(A:B!H7)","v":0},{"$f":"SUM(A:B!I7)","v":21},{"$f":"SUM(A:B!J7)","v":27},{"$f":"SUM(A:B!K7)","v":0}]
[null,null,null,null,{"$f":"SUM(A:B!B8)","v":27},{"$f":"SUM(A:B!C8)","v":27},{"$f":"SUM(A:B!D8)","v":18},{"$f":"SUM(A:B!E8)","v":27},{"$f":"SUM(A:B!F8)","v":24},{"$f":"SUM(A:B!G8)","v":27},{"$f":"SUM(A:B!H8)","v":30},{"$f":"SUM(A:B!I8)","v":21},{"$f":"SUM(A:B!J8)","v":15},{"$f":"SUM(A:B!K8)","v":6}]
[null,null,null,null,{"$f":"SUM(A:B!B9)","v":12},{"$f":"SUM(A:B!C9)","v":27},{"$f":"SUM(A:B!D9)","v":21},{"$f":"SUM(A:B!E9)","v":6},{"$f":"SUM(A:B!F9)","v":24},{"$f":"SUM(A:B!G9)","v":0},{"$f":"SUM(A:B!H9)","v":21},{"$f":"SUM(A:B!I9)","v":21},{"$f":"SUM(A:B!J9)","v":9},{"$f":"SUM(A:B!K9)","v":0}]
[]
[]
[null,null,"HSTACK"]
[null,null,null,null,"Scalar Result but with 2D Potential"]
[null,null,null,null,{"$f":"SUM(_xlfn.HSTACK(A:B!B1))","v":3},{"$f":"SUM(_xlfn.HSTACK(A:B!C1))","v":27},{"$f":"SUM(_xlfn.HSTACK(A:B!D1))","v":9},{"$f":"SUM(_xlfn.HSTACK(A:B!E1))","v":15},{"$f":"SUM(_xlfn.HSTACK(A:B!F1))","v":9},{"$f":"SUM(_xlfn.HSTACK(A:B!G1))","v":27},{"$f":"SUM(_xlfn.HSTACK(A:B!H1))","v":9},{"$f":"SUM(_xlfn.HSTACK(A:B!I1))","v":9},{"$f":"SUM(_xlfn.HSTACK(A:B!J1))","v":9},{"$f":"SUM(_xlfn.HSTACK(A:B!K1))","v":27}]
[null,null,null,null,{"$f":"SUM(_xlfn.HSTACK(A:B!B2))","v":27},{"$f":"SUM(_xlfn.HSTACK(A:B!C2))","v":18},{"$f":"SUM(_xlfn.HSTACK(A:B!D2))","v":24},{"$f":"SUM(_xlfn.HSTACK(A:B!E2))","v":9},{"$f":"SUM(_xlfn.HSTACK(A:B!F2))","v":30},{"$f":"SUM(_xlfn.HSTACK(A:B!G2))","v":15},{"$f":"SUM(_xlfn.HSTACK(A:B!H2))","v":30},{"$f":"SUM(_xlfn.HSTACK(A:B!I2))","v":27},{"$f":"SUM(_xlfn.HSTACK(A:B!J2))","v":24},{"$f":"SUM(_xlfn.HSTACK(A:B!K2))","v":9}]
[null,null,null,null,{"$f":"SUM(_xlfn.HSTACK(A:B!B3))","v":12},{"$f":"SUM(_xlfn.HSTACK(A:B!C3))","v":6},{"$f":"SUM(_xlfn.HSTACK(A:B!D3))","v":6},{"$f":"SUM(_xlfn.HSTACK(A:B!E3))","v":6},{"$f":"SUM(_xlfn.HSTACK(A:B!F3))","v":0},{"$f":"SUM(_xlfn.HSTACK(A:B!G3))","v":3},{"$f":"SUM(_xlfn.HSTACK(A:B!H3))","v":0},{"$f":"SUM(_xlfn.HSTACK(A:B!I3))","v":24},{"$f":"SUM(_xlfn.HSTACK(A:B!J3))","v":12},{"$f":"SUM(_xlfn.HSTACK(A:B!K3))","v":24}]
[null,null,null,null,{"$f":"SUM(_xlfn.HSTACK(A:B!B4))","v":12},{"$f":"SUM(_xlfn.HSTACK(A:B!C4))","v":6},{"$f":"SUM(_xlfn.HSTACK(A:B!D4))","v":18},{"$f":"SUM(_xlfn.HSTACK(A:B!E4))","v":12},{"$f":"SUM(_xlfn.HSTACK(A:B!F4))","v":12},{"$f":"SUM(_xlfn.HSTACK(A:B!G4))","v":21},{"$f":"SUM(_xlfn.HSTACK(A:B!H4))","v":24},{"$f":"SUM(_xlfn.HSTACK(A:B!I4))","v":9},{"$f":"SUM(_xlfn.HSTACK(A:B!J4))","v":12},{"$f":"SUM(_xlfn.HSTACK(A:B!K4))","v":24}]
[null,null,null,null,{"$f":"SUM(_xlfn.HSTACK(A:B!B5))","v":30},{"$f":"SUM(_xlfn.HSTACK(A:B!C5))","v":3},{"$f":"SUM(_xlfn.HSTACK(A:B!D5))","v":3},{"$f":"SUM(_xlfn.HSTACK(A:B!E5))","v":21},{"$f":"SUM(_xlfn.HSTACK(A:B!F5))","v":9},{"$f":"SUM(_xlfn.HSTACK(A:B!G5))","v":9},{"$f":"SUM(_xlfn.HSTACK(A:B!H5))","v":27},{"$f":"SUM(_xlfn.HSTACK(A:B!I5))","v":24},{"$f":"SUM(_xlfn.HSTACK(A:B!J5))","v":27},{"$f":"SUM(_xlfn.HSTACK(A:B!K5))","v":21}]
[null,null,null,null,{"$f":"SUM(_xlfn.HSTACK(A:B!B6))","v":30},{"$f":"SUM(_xlfn.HSTACK(A:B!C6))","v":27},{"$f":"SUM(_xlfn.HSTACK(A:B!D6))","v":9},{"$f":"SUM(_xlfn.HSTACK(A:B!E6))","v":9},{"$f":"SUM(_xlfn.HSTACK(A:B!F6))","v":9},{"$f":"SUM(_xlfn.HSTACK(A:B!G6))","v":24},{"$f":"SUM(_xlfn.HSTACK(A:B!H6))","v":0},{"$f":"SUM(_xlfn.HSTACK(A:B!I6))","v":27},{"$f":"SUM(_xlfn.HSTACK(A:B!J6))","v":3},{"$f":"SUM(_xlfn.HSTACK(A:B!K6))","v":21}]
[null,null,null,null,{"$f":"SUM(_xlfn.HSTACK(A:B!B7))","v":12},{"$f":"SUM(_xlfn.HSTACK(A:B!C7))","v":27},{"$f":"SUM(_xlfn.HSTACK(A:B!D7))","v":9},{"$f":"SUM(_xlfn.HSTACK(A:B!E7))","v":6},{"$f":"SUM(_xlfn.HSTACK(A:B!F7))","v":21},{"$f":"SUM(_xlfn.HSTACK(A:B!G7))","v":0},{"$f":"SUM(_xlfn.HSTACK(A:B!H7))","v":0},{"$f":"SUM(_xlfn.HSTACK(A:B!I7))","v":21},{"$f":"SUM(_xlfn.HSTACK(A:B!J7))","v":27},{"$f":"SUM(_xlfn.HSTACK(A:B!K7))","v":0}]
[null,null,null,null,{"$f":"SUM(_xlfn.HSTACK(A:B!B8))","v":27},{"$f":"SUM(_xlfn.HSTACK(A:B!C8))","v":27},{"$f":"SUM(_xlfn.HSTACK(A:B!D8))","v":18},{"$f":"SUM(_xlfn.HSTACK(A:B!E8))","v":27},{"$f":"SUM(_xlfn.HSTACK(A:B!F8))","v":24},{"$f":"SUM(_xlfn.HSTACK(A:B!G8))","v":27},{"$f":"SUM(_xlfn.HSTACK(A:B!H8))","v":30},{"$f":"SUM(_xlfn.HSTACK(A:B!I8))","v":21},{"$f":"SUM(_xlfn.HSTACK(A:B!J8))","v":15},{"$f":"SUM(_xlfn.HSTACK(A:B!K8))","v":6}]
[null,null,null,null,{"$f":"SUM(_xlfn.HSTACK(A:B!B9))","v":12},{"$f":"SUM(_xlfn.HSTACK(A:B!C9))","v":27},{"$f":"SUM(_xlfn.HSTACK(A:B!D9))","v":21},{"$f":"SUM(_xlfn.HSTACK(A:B!E9))","v":6},{"$f":"SUM(_xlfn.HSTACK(A:B!F9))","v":24},{"$f":"SUM(_xlfn.HSTACK(A:B!G9))","v":0},{"$f":"SUM(_xlfn.HSTACK(A:B!H9))","v":21},{"$f":"SUM(_xlfn.HSTACK(A:B!I9))","v":21},{"$f":"SUM(_xlfn.HSTACK(A:B!J9))","v":9},{"$f":"SUM(_xlfn.HSTACK(A:B!K9))","v":0}]
[]
[]
[null,null,"VSTACK"]
[null,null,null,null,"Scalar Result but with 2D Potential"]
[null,null,null,null,{"$f":"SUM(_xlfn.VSTACK(A:B!B1))","v":3},{"$f":"SUM(_xlfn.VSTACK(A:B!C1))","v":27},{"$f":"SUM(_xlfn.VSTACK(A:B!D1))","v":9},{"$f":"SUM(_xlfn.VSTACK(A:B!E1))","v":15},{"$f":"SUM(_xlfn.VSTACK(A:B!F1))","v":9},{"$f":"SUM(_xlfn.VSTACK(A:B!G1))","v":27},{"$f":"SUM(_xlfn.VSTACK(A:B!H1))","v":9},{"$f":"SUM(_xlfn.VSTACK(A:B!I1))","v":9},{"$f":"SUM(_xlfn.VSTACK(A:B!J1))","v":9},{"$f":"SUM(_xlfn.VSTACK(A:B!K1))","v":27}]
[null,null,null,null,{"$f":"SUM(_xlfn.VSTACK(A:B!B2))","v":27},{"$f":"SUM(_xlfn.VSTACK(A:B!C2))","v":18},{"$f":"SUM(_xlfn.VSTACK(A:B!D2))","v":24},{"$f":"SUM(_xlfn.VSTACK(A:B!E2))","v":9},{"$f":"SUM(_xlfn.VSTACK(A:B!F2))","v":30},{"$f":"SUM(_xlfn.VSTACK(A:B!G2))","v":15},{"$f":"SUM(_xlfn.VSTACK(A:B!H2))","v":30},{"$f":"SUM(_xlfn.VSTACK(A:B!I2))","v":27},{"$f":"SUM(_xlfn.VSTACK(A:B!J2))","v":24},{"$f":"SUM(_xlfn.VSTACK(A:B!K2))","v":9}]
[null,null,null,null,{"$f":"SUM(_xlfn.VSTACK(A:B!B3))","v":12},{"$f":"SUM(_xlfn.VSTACK(A:B!C3))","v":6},{"$f":"SUM(_xlfn.VSTACK(A:B!D3))","v":6},{"$f":"SUM(_xlfn.VSTACK(A:B!E3))","v":6},{"$f":"SUM(_xlfn.VSTACK(A:B!F3))","v":0},{"$f":"SUM(_xlfn.VSTACK(A:B!G3))","v":3},{"$f":"SUM(_xlfn.VSTACK(A:B!H3))","v":0},{"$f":"SUM(_xlfn.VSTACK(A:B!I3))","v":24},{"$f":"SUM(_xlfn.VSTACK(A:B!J3))","v":12},{"$f":"SUM(_xlfn.VSTACK(A:B!K3))","v":24}]
[null,null,null,null,{"$f":"SUM(_xlfn.VSTACK(A:B!B4))","v":12},{"$f":"SUM(_xlfn.VSTACK(A:B!C4))","v":6},{"$f":"SUM(_xlfn.VSTACK(A:B!D4))","v":18},{"$f":"SUM(_xlfn.VSTACK(A:B!E4))","v":12},{"$f":"SUM(_xlfn.VSTACK(A:B!F4))","v":12},{"$f":"SUM(_xlfn.VSTACK(A:B!G4))","v":21},{"$f":"SUM(_xlfn.VSTACK(A:B!H4))","v":24},{"$f":"SUM(_xlfn.VSTACK(A:B!I4))","v":9},{"$f":"SUM(_xlfn.VSTACK(A:B!J4))","v":12},{"$f":"SUM(_xlfn.VSTACK(A:B!K4))","v":24}]
[null,null,null,null,{"$f":"SUM(_xlfn.VSTACK(A:B!B5))","v":30},{"$f":"SUM(_xlfn.VSTACK(A:B!C5))","v":3},{"$f":"SUM(_xlfn.VSTACK(A:B!D5))","v":3},{"$f":"SUM(_xlfn.VSTACK(A:B!E5))","v":21},{"$f":"SUM(_xlfn.VSTACK(A:B!F5))","v":9},{"$f":"SUM(_xlfn.VSTACK(A:B!G5))","v":9},{"$f":"SUM(_xlfn.VSTACK(A:B!H5))","v":27},{"$f":"SUM(_xlfn.VSTACK(A:B!I5))","v":24},{"$f":"SUM(_xlfn.VSTACK(A:B!J5))","v":27},{"$f":"SUM(_xlfn.VSTACK(A:B!K5))","v":21}]
[null,null,null,null,{"$f":"SUM(_xlfn.VSTACK(A:B!B6))","v":30},{"$f":"SUM(_xlfn.VSTACK(A:B!C6))","v":27},{"$f":"SUM(_xlfn.VSTACK(A:B!D6))","v":9},{"$f":"SUM(_xlfn.VSTACK(A:B!E6))","v":9},{"$f":"SUM(_xlfn.VSTACK(A:B!F6))","v":9},{"$f":"SUM(_xlfn.VSTACK(A:B!G6))","v":24},{"$f":"SUM(_xlfn.VSTACK(A:B!H6))","v":0},{"$f":"SUM(_xlfn.VSTACK(A:B!I6))","v":27},{"$f":"SUM(_xlfn.VSTACK(A:B!J6))","v":3},{"$f":"SUM(_xlfn.VSTACK(A:B!K6))","v":21}]
[null,null,null,null,{"$f":"SUM(_xlfn.VSTACK(A:B!B7))","v":12},{"$f":"SUM(_xlfn.VSTACK(A:B!C7))","v":27},{"$f":"SUM(_xlfn.VSTACK(A:B!D7))","v":9},{"$f":"SUM(_xlfn.VSTACK(A:B!E7))","v":6},{"$f":"SUM(_xlfn.VSTACK(A:B!F7))","v":21},{"$f":"SUM(_xlfn.VSTACK(A:B!G7))","v":0},{"$f":"SUM(_xlfn.VSTACK(A:B!H7))","v":0},{"$f":"SUM(_xlfn.VSTACK(A:B!I7))","v":21},{"$f":"SUM(_xlfn.VSTACK(A:B!J7))","v":27},{"$f":"SUM(_xlfn.VSTACK(A:B!K7))","v":0}]
[null,null,null,null,{"$f":"SUM(_xlfn.VSTACK(A:B!B8))","v":27},{"$f":"SUM(_xlfn.VSTACK(A:B!C8))","v":27},{"$f":"SUM(_xlfn.VSTACK(A:B!D8))","v":18},{"$f":"SUM(_xlfn.VSTACK(A:B!E8))","v":27},{"$f":"SUM(_xlfn.VSTACK(A:B!F8))","v":24},{"$f":"SUM(_xlfn.VSTACK(A:B!G8))","v":27},{"$f":"SUM(_xlfn.VSTACK(A:B!H8))","v":30},{"$f":"SUM(_xlfn.VSTACK(A:B!I8))","v":21},{"$f":"SUM(_xlfn.VSTACK(A:B!J8))","v":15},{"$f":"SUM(_xlfn.VSTACK(A:B!K8))","v":6}]
[null,null,null,null,{"$f":"SUM(_xlfn.VSTACK(A:B!B9))","v":12},{"$f":"SUM(_xlfn.VSTACK(A:B!C9))","v":27},{"$f":"SUM(_xlfn.VSTACK(A:B!D9))","v":21},{"$f":"SUM(_xlfn.VSTACK(A:B!E9))","v":6},{"$f":"SUM(_xlfn.VSTACK(A:B!F9))","v":24},{"$f":"SUM(_xlfn.VSTACK(A:B!G9))","v":0},{"$f":"SUM(_xlfn.VSTACK(A:B!H9))","v":21},{"$f":"SUM(_xlfn.VSTACK(A:B!I9))","v":21},{"$f":"SUM(_xlfn.VSTACK(A:B!J9))","v":9},{"$f":"SUM(_xlfn.VSTACK(A:B!K9))","v":0}]
[]
[]
[null,null,"TEXTJOIN"]
[null,null,null,null,"Scalar Result but with 2D Potential"]
[null,null,null,null,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,A:B!B1)","v":"0,1,1,1,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!C1)","v":"0,9,9,9,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!D1)","v":"0,3,3,3,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!E1)","v":"0,5,5,5,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!F1)","v":"0,3,3,3,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!G1)","v":"0,9,9,9,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!H1)","v":"0,3,3,3,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!I1)","v":"0,3,3,3,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!J1)","v":"0,3,3,3,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!K1)","v":"0,9,9,9,0"}]
[null,null,null,null,{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!B2)","v":"0,9,9,9,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!C2)","v":"0,6,6,6,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!D2)","v":"0,8,8,8,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!E2)","v":"0,3,3,3,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!F2)","v":"0,10,10,10,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!G2)","v":"0,5,5,5,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!H2)","v":"0,10,10,10,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!I2)","v":"0,9,9,9,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!J2)","v":"0,8,8,8,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!K2)","v":"0,3,3,3,0"}]
[null,null,null,null,{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!B3)","v":"0,4,4,4,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!C3)","v":"0,2,2,2,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!D3)","v":"0,2,2,2,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!E3)","v":"0,2,2,2,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!F3)","v":"0,0,0,0,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!G3)","v":"0,1,1,1,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!H3)","v":"0,0,0,0,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!I3)","v":"0,8,8,8,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!J3)","v":"0,4,4,4,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!K3)","v":"0,8,8,8,0"}]
[null,null,null,null,{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!B4)","v":"0,4,4,4,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!C4)","v":"0,2,2,2,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!D4)","v":"0,6,6,6,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!E4)","v":"0,4,4,4,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!F4)","v":"0,4,4,4,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!G4)","v":"0,7,7,7,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!H4)","v":"0,8,8,8,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!I4)","v":"0,3,3,3,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!J4)","v":"0,4,4,4,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!K4)","v":"0,8,8,8,0"}]
[null,null,null,null,{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!B5)","v":"0,10,10,10,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!C5)","v":"0,1,1,1,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!D5)","v":"0,1,1,1,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!E5)","v":"0,7,7,7,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!F5)","v":"0,3,3,3,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!G5)","v":"0,3,3,3,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!H5)","v":"0,9,9,9,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!I5)","v":"0,8,8,8,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!J5)","v":"0,9,9,9,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!K5)","v":"0,7,7,7,0"}]
[null,null,null,null,{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!B6)","v":"0,10,10,10,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!C6)","v":"0,9,9,9,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!D6)","v":"0,3,3,3,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!E6)","v":"0,3,3,3,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!F6)","v":"0,3,3,3,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!G6)","v":"0,8,8,8,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!H6)","v":"0,0,0,0,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!I6)","v":"0,9,9,9,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!J6)","v":"0,1,1,1,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!K6)","v":"0,7,7,7,0"}]
[null,null,null,null,{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!B7)","v":"0,4,4,4,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!C7)","v":"0,9,9,9,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!D7)","v":"0,3,3,3,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!E7)","v":"0,2,2,2,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!F7)","v":"0,7,7,7,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!G7)","v":"0,0,0,0,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!H7)","v":"0,0,0,0,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!I7)","v":"0,7,7,7,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!J7)","v":"0,9,9,9,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!K7)","v":"0,0,0,0,0"}]
[null,null,null,null,{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!B8)","v":"0,9,9,9,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!C8)","v":"0,9,9,9,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!D8)","v":"0,6,6,6,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!E8)","v":"0,9,9,9,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!F8)","v":"0,8,8,8,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!G8)","v":"0,9,9,9,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!H8)","v":"0,10,10,10,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!I8)","v":"0,7,7,7,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!J8)","v":"0,5,5,5,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!K8)","v":"0,2,2,2,0"}]
[null,null,null,null,{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!B9)","v":"0,4,4,4,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!C9)","v":"0,9,9,9,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!D9)","v":"0,7,7,7,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!E9)","v":"0,2,2,2,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!F9)","v":"0,8,8,8,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!G9)","v":"0,0,0,0,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!H9)","v":"0,7,7,7,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!I9)","v":"0,7,7,7,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!J9)","v":"0,3,3,3,0"},{"$f":"_xlfn.TEXTJOIN(\",\",,A:B!K9)","v":"0,0,0,0,0"}]
[]
[]
[null,null,"SUMIFS INDIRECT"]
[]
[null,null,null,"Sheet Name"]
[]
[null,null,null,null,1]
[null,null,null,null,2]
[null,null,null,null,3]
[]
[null,null,null,"SUM SUMIFS INDIRECT"]
[null,null,null,null,"Scalar Result"]
[null,null,null,"A",{"$f":"SUM(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D105))","v":55},{"$f":"SUM(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D105))","v":70},{"$f":"SUM(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D105))","v":45},{"$f":"SUM(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D105))","v":36},{"$f":"SUM(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D105))","v":52},{"$f":"SUM(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D105))","v":47},{"$f":"SUM(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D105))","v":43},{"$f":"SUM(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D105))","v":70},{"$f":"SUM(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D105))","v":48},{"$f":"SUM(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D105))","v":49}]
[null,null,null,"B",{"$f":"SUM(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D106))","v":62},{"$f":"SUM(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D106))","v":27},{"$f":"SUM(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D106))","v":27},{"$f":"SUM(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D106))","v":39},{"$f":"SUM(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D106))","v":27},{"$f":"SUM(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D106))","v":46},{"$f":"SUM(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D106))","v":51},{"$f":"SUM(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D106))","v":51},{"$f":"SUM(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D106))","v":41},{"$f":"SUM(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D106))","v":59}]
[null,null,null,"C",{"$f":"SUM(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D107))","v":48},{"$f":"SUM(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D107))","v":71},{"$f":"SUM(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D107))","v":45},{"$f":"SUM(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D107))","v":36},{"$f":"SUM(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D107))","v":59},{"$f":"SUM(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D107))","v":33},{"$f":"SUM(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D107))","v":47},{"$f":"SUM(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D107))","v":62},{"$f":"SUM(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D107))","v":49},{"$f":"SUM(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D107))","v":24}]
[]
[]
[null,null,null,"SUMPRODUCT SUMIFS INDIRECT"]
[null,null,null,null,"Scalar Result"]
[null,null,null,"A",{"$f":"SUMPRODUCT(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D112))","v":55},{"$f":"SUMPRODUCT(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D112))","v":70},{"$f":"SUMPRODUCT(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D112))","v":45},{"$f":"SUMPRODUCT(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D112))","v":36},{"$f":"SUMPRODUCT(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D112))","v":52},{"$f":"SUMPRODUCT(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D112))","v":47},{"$f":"SUMPRODUCT(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D112))","v":43},{"$f":"SUMPRODUCT(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D112))","v":70},{"$f":"SUMPRODUCT(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D112))","v":48},{"$f":"SUMPRODUCT(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D112))","v":49}]
[null,null,null,"B",{"$f":"SUMPRODUCT(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D113))","v":62},{"$f":"SUMPRODUCT(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D113))","v":27},{"$f":"SUMPRODUCT(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D113))","v":27},{"$f":"SUMPRODUCT(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D113))","v":39},{"$f":"SUMPRODUCT(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D113))","v":27},{"$f":"SUMPRODUCT(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D113))","v":46},{"$f":"SUMPRODUCT(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D113))","v":51},{"$f":"SUMPRODUCT(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D113))","v":51},{"$f":"SUMPRODUCT(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D113))","v":41},{"$f":"SUMPRODUCT(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D113))","v":59}]
[null,null,null,"C",{"$f":"SUMPRODUCT(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D114))","v":48},{"$f":"SUMPRODUCT(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D114))","v":71},{"$f":"SUMPRODUCT(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D114))","v":45},{"$f":"SUMPRODUCT(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D114))","v":36},{"$f":"SUMPRODUCT(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D114))","v":59},{"$f":"SUMPRODUCT(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D114))","v":33},{"$f":"SUMPRODUCT(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D114))","v":47},{"$f":"SUMPRODUCT(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D114))","v":62},{"$f":"SUMPRODUCT(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D114))","v":49},{"$f":"SUMPRODUCT(SUMIFS(INDIRECT(LS_Sheet_Name&\"!C[-3]\",FALSE),INDIRECT(LS_Sheet_Name&\"!C1\",FALSE),$D114))","v":24}]
[]
[]
[null,null,null,"REDUCE SUMIFS INDIRECT"]
[null,null,null,null,"1D Result"]
[null,null,null,"A",{"$f":"_xlfn.REDUCE(0,LS_Sheet_Name,_xlfn.LAMBDA(_xlpm.x,_xlpm.y,_xlpm.x+SUMIFS(INDIRECT(_xlpm.y&\"!C[-3]\",FALSE),INDIRECT(_xlpm.y&\"!C1\",FALSE),$D119:$D121)))","v":55},{"$f":"_xlfn.REDUCE(0,LS_Sheet_Name,_xlfn.LAMBDA(_xlpm.x,_xlpm.y,_xlpm.x+SUMIFS(INDIRECT(_xlpm.y&\"!C[-3]\",FALSE),INDIRECT(_xlpm.y&\"!C1\",FALSE),$D119:$D121)))","v":70},{"$f":"_xlfn.REDUCE(0,LS_Sheet_Name,_xlfn.LAMBDA(_xlpm.x,_xlpm.y,_xlpm.x+SUMIFS(INDIRECT(_xlpm.y&\"!C[-3]\",FALSE),INDIRECT(_xlpm.y&\"!C1\",FALSE),$D119:$D121)))","v":45},{"$f":"_xlfn.REDUCE(0,LS_Sheet_Name,_xlfn.LAMBDA(_xlpm.x,_xlpm.y,_xlpm.x+SUMIFS(INDIRECT(_xlpm.y&\"!C[-3]\",FALSE),INDIRECT(_xlpm.y&\"!C1\",FALSE),$D119:$D121)))","v":36},{"$f":"_xlfn.REDUCE(0,LS_Sheet_Name,_xlfn.LAMBDA(_xlpm.x,_xlpm.y,_xlpm.x+SUMIFS(INDIRECT(_xlpm.y&\"!C[-3]\",FALSE),INDIRECT(_xlpm.y&\"!C1\",FALSE),$D119:$D121)))","v":52},{"$f":"_xlfn.REDUCE(0,LS_Sheet_Name,_xlfn.LAMBDA(_xlpm.x,_xlpm.y,_xlpm.x+SUMIFS(INDIRECT(_xlpm.y&\"!C[-3]\",FALSE),INDIRECT(_xlpm.y&\"!C1\",FALSE),$D119:$D121)))","v":47},{"$f":"_xlfn.REDUCE(0,LS_Sheet_Name,_xlfn.LAMBDA(_xlpm.x,_xlpm.y,_xlpm.x+SUMIFS(INDIRECT(_xlpm.y&\"!C[-3]\",FALSE),INDIRECT(_xlpm.y&\"!C1\",FALSE),$D119:$D121)))","v":43},{"$f":"_xlfn.REDUCE(0,LS_Sheet_Name,_xlfn.LAMBDA(_xlpm.x,_xlpm.y,_xlpm.x+SUMIFS(INDIRECT(_xlpm.y&\"!C[-3]\",FALSE),INDIRECT(_xlpm.y&\"!C1\",FALSE),$D119:$D121)))","v":70},{"$f":"_xlfn.REDUCE(0,LS_Sheet_Name,_xlfn.LAMBDA(_xlpm.x,_xlpm.y,_xlpm.x+SUMIFS(INDIRECT(_xlpm.y&\"!C[-3]\",FALSE),INDIRECT(_xlpm.y&\"!C1\",FALSE),$D119:$D121)))","v":48},{"$f":"_xlfn.REDUCE(0,LS_Sheet_Name,_xlfn.LAMBDA(_xlpm.x,_xlpm.y,_xlpm.x+SUMIFS(INDIRECT(_xlpm.y&\"!C[-3]\",FALSE),INDIRECT(_xlpm.y&\"!C1\",FALSE),$D119:$D121)))","v":49}]
[null,null,null,"B",62,27,27,39,27,46,51,51,41,59]
[null,null,null,"C",48,71,45,36,59,33,47,62,49,24]
[]
[]
[null,null,"VSTACK"]
[null,null,null,null,"1D Result but no Expand Potential"]
[null,null,null,"A",{"$f":"_xlfn.LET(_xlpm.data,_xlfn.VSTACK(A:B!$B$1:$K$9),\n_xlpm.criteria,_xlfn.VSTACK(A:B!$A$1:$A$9),\n_xlfn.BYCOL(_xlpm.data,_xlfn.LAMBDA(_xlpm.a,SUM(_xlpm.a*(_xlpm.criteria=D126)))))","v":55},70,45,36,52,47,43,70,48,49]
[null,null,null,"B",{"$f":"_xlfn.LET(_xlpm.data,_xlfn.VSTACK(A:B!$B$1:$K$9),\n_xlpm.criteria,_xlfn.VSTACK(A:B!$A$1:$A$9),\n_xlfn.BYCOL(_xlpm.data,_xlfn.LAMBDA(_xlpm.a,SUM(_xlpm.a*(_xlpm.criteria=D127)))))","v":62},27,27,39,27,46,51,51,41,59]
[null,null,null,"C",{"$f":"_xlfn.LET(_xlpm.data,_xlfn.VSTACK(A:B!$B$1:$K$9),\n_xlpm.criteria,_xlfn.VSTACK(A:B!$A$1:$A$9),\n_xlfn.BYCOL(_xlpm.data,_xlfn.LAMBDA(_xlpm.a,SUM(_xlpm.a*(_xlpm.criteria=D128)))))","v":48},71,45,36,59,33,47,62,49,24]
[]
[]
[null,null,"MMULT"]
[null,null,null,null,"2D Result but no Expand Potential"]
[null,null,null,"A",{"$f":"_xlfn.LET(_xlpm.data,_xlfn.VSTACK(A:B!$B$1:$K$9),\n _xlpm.criteria,_xlfn.VSTACK(A:B!$A$1:$A$9),\nMMULT((TRANSPOSE(_xlpm.criteria)=(D133:D135))*1,_xlpm.data))","v":55},70,45,36,52,47,43,70,48,49]
[null,null,null,"B",62,27,27,39,27,46,51,51,41,59]
[null,null,null,"C",48,71,45,36,59,33,47,62,49,24]

{"sheet":"A","index":9,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"_xlfn.ANCHORARRAY('2D Array'!$G$15)*0","v":0},0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
["Navigator",0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]

{"sheet":"1","index":10,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[{"$f":"{\"A\";\"A\";\"A\";\"B\";\"B\";\"B\";\"C\";\"C\";\"C\"}","v":"A"},{"$f":"_xlfn.ANCHORARRAY('2D Array'!$G$15)","v":1},9,3,5,3,9,3,3,3,9]
["A",9,6,8,3,10,5,10,9,8,3]
["A",4,2,2,2,0,1,0,8,4,8]
["B",4,2,6,4,4,7,8,3,4,8]
["B",10,1,1,7,3,3,9,8,9,7]
["B",10,9,3,3,3,8,0,9,1,7]
["C",4,9,3,2,7,0,0,7,9,0]
["C",9,9,6,9,8,9,10,7,5,2]
["C",4,9,7,2,8,0,7,7,3,0]

{"sheet":"2","index":11,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[{"$f":"{\"A\";\"A\";\"A\";\"B\";\"B\";\"B\";\"C\";\"C\";\"C\"}","v":"A"},{"$f":"_xlfn.ANCHORARRAY('2D Array'!$G$15)","v":1},9,3,5,3,9,3,3,3,9]
["A",9,6,8,3,10,5,10,9,8,3]
["A",4,2,2,2,0,1,0,8,4,8]
["B",4,2,6,4,4,7,8,3,4,8]
["B",10,1,1,7,3,3,9,8,9,7]
["B",10,9,3,3,3,8,0,9,1,7]
["C",4,9,3,2,7,0,0,7,9,0]
["C",9,9,6,9,8,9,10,7,5,2]
["C",4,9,7,2,8,0,7,7,3,0]

{"sheet":"3","index":12,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[{"$f":"{\"C\";\"C\";\"C\";\"B\";\"B\";\"A\";\"A\";\"A\";\"A\"}","v":"C"},{"$f":"_xlfn.ANCHORARRAY('2D Array'!$G$15)","v":1},9,3,5,3,9,3,3,3,9]
["C",9,6,8,3,10,5,10,9,8,3]
["C",4,2,2,2,0,1,0,8,4,8]
["B",4,2,6,4,4,7,8,3,4,8]
["B",10,1,1,7,3,3,9,8,9,7]
["A",10,9,3,3,3,8,0,9,1,7]
["A",4,9,3,2,7,0,0,7,9,0]
["A",9,9,6,9,8,9,10,7,5,2]
["A",4,9,7,2,8,0,7,7,3,0]

{"sheet":"B","index":13,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"_xlfn.ANCHORARRAY('2D Array'!$G$15)*0","v":0},0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
["Navigator",0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]
[null,0,0,0,0,0,0,0,0,0,0]

{"sheet":"4D Array","index":14,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Initial Idea: INDIRECT + SUMIFS"]
["CHOOSE + SUMIFS"]
["Navigator"]