{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["North","South West","East","West","Checks","Loans","Cash Waterfall","Apples Frequency","Comma Format Macro"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":8,"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":"North","index":0,"n_rows":21,"n_cols":14,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"North"]
[null,null,"Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12"]
[null,"Revenue"]
[null,"Product A",1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000]
[null,"Product B",1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100,1100]
[null,"Product C",1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200,1200]
[null,"Total revenue",{"$f":"SUM(C5:C7)","v":3300},{"$f":"SUM(D5:D7)","v":3300},3300,3300,3300,3300,3300,3300,3300,3300,3300,3300]
[]
[null,"Cost of Sales"]
[null,"Purchases",-400,-400,-400,-400,-400,-400,-400,-400,-400,-400,-400,-400]
[null,"Postage",-200,-200,-200,-200,-200,-200,-200,-200,-200,-200,-200,-200]
[null,"Total cost of sales",{"$f":"SUM(C11:C12)","v":-600},{"$f":"SUM(D11:D12)","v":-600},-600,-600,-600,-600,-600,-600,-600,-600,-600,-600]
[]
[null,"Gross Margin",{"$f":"C8+C13","v":2700},{"$f":"D8+D13","v":2700},2700,2700,2700,2700,2700,2700,2700,2700,2700,2700]
[]
[null,"Gm%",{"$f":"C15/C8","v":0.81818181818181823},{"$f":"D15/D8","v":0.81818181818181823},0.81818181818181823,0.81818181818181823,0.81818181818181823,0.81818181818181823,0.81818181818181823,0.81818181818181823,0.81818181818181823,0.81818181818181823,0.81818181818181823,0.81818181818181823]
[]
[null,"Overheads",-900,-900,-900,-900,-900,-900,-900,-900,-900,-900,-900,-900]
[]
[null,"Net profit",{"$f":"SUM(C15:C20)","v":1800.818181818182},1800.818181818182,1800.818181818182,1800.818181818182,1800.818181818182,1800.818181818182,1800.818181818182,1800.818181818182,1800.818181818182,1800.818181818182,1800.818181818182,1800.818181818182]

{"sheet":"South West","index":1,"n_rows":21,"n_cols":14,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"South"]
[null,null,"Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12"]
[null,"Revenue"]
[null,"Product A",2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000,2000]
[null,"Product B",2200,2200,2200,2200,2200,2200,2200,2200,2200,2200,2200,2200]
[null,"Product C",2400,2400,2400,2400,2400,2400,2400,2400,2400,2400,2400,2400]
[null,"Total revenue",{"$f":"SUM(C5:C7)","v":6600},{"$f":"SUM(D5:D7)","v":6600},6600,6600,6600,6600,6600,6600,6600,6600,6600,6600]
[]
[null,"Cost of Sales"]
[null,"Purchases",-200,-200,-200,-200,-200,-200,-200,-200,-200,-200,-200,-200]
[null,"Postage",-400,-400,-400,-400,-400,-400,-400,-400,-400,-400,-400,-400]
[null,"Total cost of sales",{"$f":"SUM(C11:C12)","v":-600},{"$f":"SUM(D11:D12)","v":-600},-600,-600,-600,-600,-600,-600,-600,-600,-600,-600]
[]
[null,"Gross Margin",{"$f":"C8+C13","v":6000},{"$f":"D8+D13","v":6000},6000,6000,6000,6000,6000,6000,6000,6000,6000,6000]
[]
[null,"GM%",{"$f":"C15/C8","v":0.90909090909090906},{"$f":"D15/D8","v":0.90909090909090906},0.90909090909090906,0.90909090909090906,0.90909090909090906,0.90909090909090906,0.90909090909090906,0.90909090909090906,0.90909090909090906,0.90909090909090906,0.90909090909090906,0.90909090909090906]
[]
[null,"Overheads",-1800,-1800,-1800,-1800,-1800,-1800,-1800,-1800,-1800,-1800,-1800,-1800]
[]
[null,"Net profit",{"$f":"SUM(C15:C20)","v":4200.909090909091},{"$f":"SUM(D15:D20)","v":4200.909090909091},4200.909090909091,4200.909090909091,4200.909090909091,4200.909090909091,4200.909090909091,4200.909090909091,4200.909090909091,4200.909090909091,4200.909090909091,4200.909090909091]

{"sheet":"East","index":2,"n_rows":21,"n_cols":14,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"East"]
[null,null,"Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12"]
[null,"Revenue"]
[null,"Product A",500,500,500,500,500,500,500,500,500,500,500,500]
[null,"Product B",550,550,550,550,550,550,550,550,550,550,550,550]
[null,"Product C",600,600,600,600,600,600,600,600,600,600,600,600]
[null,"Total revenue",{"$f":"SUM(C5:C7)","v":1650},{"$f":"SUM(D5:D7)","v":1650},1650,1650,1650,1650,1650,1650,1650,1650,1650,1650]
[]
[null,"Cost of Sales"]
[null,"Purchases",-250,-250,-250,-250,-250,-250,-250,-250,-250,-250,-250,-250]
[null,"Postage",-100,-100,-100,-100,-100,-100,-100,-100,-100,-100,-100,-100]
[null,"Total cost of sales",{"$f":"SUM(C11:C12)","v":-350},{"$f":"SUM(D11:D12)","v":-350},-350,-350,-350,-350,-350,-350,-350,-350,-350,-350]
[]
[null,"Gross Margin",{"$f":"C8+C13","v":1300},{"$f":"D8+D13","v":1300},1300,1300,1300,1300,1300,1300,1300,1300,1300,1300]
[]
[null,"Gm%",{"$f":"C15/C8","v":0.78787878787878785},{"$f":"D15/D8","v":0.78787878787878785},0.78787878787878785,0.78787878787878785,0.78787878787878785,0.78787878787878785,0.78787878787878785,0.78787878787878785,0.78787878787878785,0.78787878787878785,0.78787878787878785,0.78787878787878785]
[]
[null,"Overheads",-450,-450,-450,-450,-450,-450,-450,-450,-450,-450,-450,-450]
[]
[null,"Net profit",{"$f":"SUM(C15:C20)","v":850.78787878787875},{"$f":"SUM(D15:D20)","v":850.78787878787875},850.78787878787875,850.78787878787875,850.78787878787875,850.78787878787875,850.78787878787875,850.78787878787875,850.78787878787875,850.78787878787875,850.78787878787875,850.78787878787875]

{"sheet":"West","index":3,"n_rows":21,"n_cols":14,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"West"]
[null,null,"Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12"]
[null,"Revenue"]
[null,"Product A",400,400,400,400,400,400,400,400,400,400,400,400]
[null,"Product B",440,440,440,440,440,440,440,440,440,440,440,440]
[null,"Product C",480,480,480,480,480,480,480,480,480,480,480,480]
[null,"Total revenue",{"$f":"SUM(C5:C7)","v":1320},{"$f":"SUM(D5:D7)","v":1320},1320,1320,1320,1320,1320,1320,1320,1320,1320,1320]
[]
[null,"Cost of Sales"]
[null,"Purchases",-400,-400,-400,-400,-400,-400,-400,-400,-400,-400,-400,-400]
[null,"Postage",-80,-80,-80,-80,-80,-80,-80,-80,-80,-80,-80,-80]
[null,"Total cost of sales",{"$f":"SUM(C11:C12)","v":-480},{"$f":"SUM(D11:D12)","v":-480},-480,-480,-480,-480,-480,-480,-480,-480,-480,-480]
[]
[null,"Gross Margin",{"$f":"C8+C13","v":840},{"$f":"D8+D13","v":840},840,840,840,840,840,840,840,840,840,840]
[]
[null,"Gm%",{"$f":"C15/C8","v":0.63636363636363635},{"$f":"D15/D8","v":0.63636363636363635},0.63636363636363635,0.63636363636363635,0.63636363636363635,0.63636363636363635,0.63636363636363635,0.63636363636363635,0.63636363636363635,0.63636363636363635,0.63636363636363635,0.63636363636363635]
[]
[null,"Overheads",-360,-360,-360,-360,-360,-360,-360,-360,-360,-360,-360,-360]
[]
[null,"Net profit",{"$f":"SUM(C15:C20)","v":480.63636363636363},{"$f":"SUM(D15:D20)","v":480.63636363636363},480.63636363636363,480.63636363636363,480.63636363636363,480.63636363636363,480.63636363636363,480.63636363636363,480.63636363636363,480.63636363636363,480.63636363636363,480.63636363636363]

{"sheet":"Checks","index":4,"n_rows":43,"n_cols":18,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[{"$f":"AND(A2:A28)","v":{"$error":"#VALUE!"}},"= Master Check",null,"B",null,null,null,null,"C",null,null,null,null,null,"How to get list of sheet names dynamically (implimented in cells D3:G3 on this sheet)"]
[null,null,"Sheet position",1,2,3,4]
[null,null,"Sheet name",{"$f":"INDEX(_xlfn.TEXTAFTER(Names_Sheets,\"]\"),D2)","v":{"$error":"#NAME?"}},{"$f":"INDEX(_xlfn.TEXTAFTER(Names_Sheets,\"]\"),E2)","v":{"$error":"#NAME?"}},{"$f":"INDEX(_xlfn.TEXTAFTER(Names_Sheets,\"]\"),F2)","v":{"$error":"#NAME?"}},{"$f":"INDEX(_xlfn.TEXTAFTER(Names_Sheets,\"]\"),G2)","v":{"$error":"#NAME?"}},null,{"$f":"D3","v":{"$error":"#VALUE!"}},{"$f":"E3","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,"Step 1: Generate a list of all worksheet names by creating a defined name - ex. in Excel 2007, go to Formulas > Name Manager "]
[{"$f":"AND(D4=E4:G4)","v":{"$error":"#VALUE!"}},null,{"$f":"_xlfn.SEQUENCE(25,1,1,1)","v":1},{"$f":"INDIRECT(\"'\"&D$3&\"'!\"&$D$1&$C4)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&E$3&\"'!\"&$D$1&$C4)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&F$3&\"'!\"&$D$1&$C4)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&G$3&\"'!\"&$D$1&$C4)","v":{"$error":"#VALUE!"}},null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&I$3&\"'!\"&$I$1&$C4)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&J$3&\"'!\"&$I$1&$C4)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&K$3&\"'!\"&$I$1&$C4)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&L$3&\"'!\"&$I$1&$C4)),\"\")","v":{"$error":"#VALUE!"}},null,null,"Name: Names_Sheets "]
[null,null,2,{"$f":"INDIRECT(\"'\"&D$3&\"'!\"&$D$1&$C5)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&E$3&\"'!\"&$D$1&$C5)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&F$3&\"'!\"&$D$1&$C5)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&G$3&\"'!\"&$D$1&$C5)","v":{"$error":"#VALUE!"}},null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&I$3&\"'!\"&$I$1&$C5)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&J$3&\"'!\"&$I$1&$C5)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&K$3&\"'!\"&$I$1&$C5)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&L$3&\"'!\"&$I$1&$C5)),\"\")","v":{"$error":"#VALUE!"}},null,null,"Refer To: =GET.WORKBOOK(1)&T(NOW())"]
[{"$f":"AND(D6=E6:G6,I6=J6:L6)","v":{"$error":"#VALUE!"}},null,3,{"$f":"INDIRECT(\"'\"&D$3&\"'!\"&$D$1&$C6)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&E$3&\"'!\"&$D$1&$C6)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&F$3&\"'!\"&$D$1&$C6)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&G$3&\"'!\"&$D$1&$C6)","v":{"$error":"#VALUE!"}},null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&I$3&\"'!\"&$I$1&$C6)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&J$3&\"'!\"&$I$1&$C6)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&K$3&\"'!\"&$I$1&$C6)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&L$3&\"'!\"&$I$1&$C6)),\"\")","v":{"$error":"#VALUE!"}},null,null,"This generates the following array:"]
[{"$f":"AND(D7=E7:G7,I7=J7:L7)","v":{"$error":"#VALUE!"}},null,4,{"$f":"INDIRECT(\"'\"&D$3&\"'!\"&$D$1&$C7)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&E$3&\"'!\"&$D$1&$C7)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&F$3&\"'!\"&$D$1&$C7)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&G$3&\"'!\"&$D$1&$C7)","v":{"$error":"#VALUE!"}},null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&I$3&\"'!\"&$I$1&$C7)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&J$3&\"'!\"&$I$1&$C7)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&K$3&\"'!\"&$I$1&$C7)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&L$3&\"'!\"&$I$1&$C7)),\"\")","v":{"$error":"#VALUE!"}},null,null,{"$f":"Names_Sheets","v":{"$error":"#NAME?"}}]
[{"$f":"AND(D8=E8:G8,I8=J8:L8)","v":{"$error":"#VALUE!"}},null,5,{"$f":"INDIRECT(\"'\"&D$3&\"'!\"&$D$1&$C8)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&E$3&\"'!\"&$D$1&$C8)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&F$3&\"'!\"&$D$1&$C8)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&G$3&\"'!\"&$D$1&$C8)","v":{"$error":"#VALUE!"}},null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&I$3&\"'!\"&$I$1&$C8)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&J$3&\"'!\"&$I$1&$C8)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&K$3&\"'!\"&$I$1&$C8)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&L$3&\"'!\"&$I$1&$C8)),\"\")","v":{"$error":"#VALUE!"}}]
[{"$f":"AND(D9=E9:G9,I9=J9:L9)","v":{"$error":"#VALUE!"}},null,6,{"$f":"INDIRECT(\"'\"&D$3&\"'!\"&$D$1&$C9)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&E$3&\"'!\"&$D$1&$C9)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&F$3&\"'!\"&$D$1&$C9)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&G$3&\"'!\"&$D$1&$C9)","v":{"$error":"#VALUE!"}},null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&I$3&\"'!\"&$I$1&$C9)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&J$3&\"'!\"&$I$1&$C9)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&K$3&\"'!\"&$I$1&$C9)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&L$3&\"'!\"&$I$1&$C9)),\"\")","v":{"$error":"#VALUE!"}},null,null,"GET NAMES AS DEMONSTRATED"]
[{"$f":"AND(D10=E10:G10,I10=J10:L10)","v":{"$error":"#VALUE!"}},null,7,{"$f":"INDIRECT(\"'\"&D$3&\"'!\"&$D$1&$C10)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&E$3&\"'!\"&$D$1&$C10)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&F$3&\"'!\"&$D$1&$C10)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&G$3&\"'!\"&$D$1&$C10)","v":{"$error":"#VALUE!"}},null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&I$3&\"'!\"&$I$1&$C10)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&J$3&\"'!\"&$I$1&$C10)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&K$3&\"'!\"&$I$1&$C10)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&L$3&\"'!\"&$I$1&$C10)),\"\")","v":{"$error":"#VALUE!"}},null,null,"Step 2: After creating the defined name as above, enter this formula in cell A1 & copy down till you encounter a blank:"]
[{"$f":"AND(D11=E11:G11,I11=J11:L11)","v":{"$error":"#VALUE!"}},null,8,{"$f":"INDIRECT(\"'\"&D$3&\"'!\"&$D$1&$C11)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&E$3&\"'!\"&$D$1&$C11)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&F$3&\"'!\"&$D$1&$C11)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&G$3&\"'!\"&$D$1&$C11)","v":{"$error":"#VALUE!"}},null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&I$3&\"'!\"&$I$1&$C11)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&J$3&\"'!\"&$I$1&$C11)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&K$3&\"'!\"&$I$1&$C11)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&L$3&\"'!\"&$I$1&$C11)),\"\")","v":{"$error":"#VALUE!"}},null,null,"=IFERROR(INDEX(MID(Names_Sheets,FIND(\"]\",Names_Sheets)+1,255),ROWS(A$1:A1)),\"\")"]
[{"$f":"AND(D12=E12:G12,I12=J12:L12)","v":{"$error":"#VALUE!"}},null,9,{"$f":"INDIRECT(\"'\"&D$3&\"'!\"&$D$1&$C12)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&E$3&\"'!\"&$D$1&$C12)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&F$3&\"'!\"&$D$1&$C12)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&G$3&\"'!\"&$D$1&$C12)","v":{"$error":"#VALUE!"}},null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&I$3&\"'!\"&$I$1&$C12)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&J$3&\"'!\"&$I$1&$C12)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&K$3&\"'!\"&$I$1&$C12)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&L$3&\"'!\"&$I$1&$C12)),\"\")","v":{"$error":"#VALUE!"}}]
[{"$f":"AND(D13=E13:G13,I13=J13:L13)","v":{"$error":"#VALUE!"}},null,10,{"$f":"INDIRECT(\"'\"&D$3&\"'!\"&$D$1&$C13)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&E$3&\"'!\"&$D$1&$C13)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&F$3&\"'!\"&$D$1&$C13)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&G$3&\"'!\"&$D$1&$C13)","v":{"$error":"#VALUE!"}},null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&I$3&\"'!\"&$I$1&$C13)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&J$3&\"'!\"&$I$1&$C13)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&K$3&\"'!\"&$I$1&$C13)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&L$3&\"'!\"&$I$1&$C13)),\"\")","v":{"$error":"#VALUE!"}},null,null,"ALTERNATIVE 1"]
[{"$f":"AND(D14=E14:G14,I14=J14:L14)","v":{"$error":"#VALUE!"}},null,11,{"$f":"INDIRECT(\"'\"&D$3&\"'!\"&$D$1&$C14)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&E$3&\"'!\"&$D$1&$C14)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&F$3&\"'!\"&$D$1&$C14)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&G$3&\"'!\"&$D$1&$C14)","v":{"$error":"#VALUE!"}},null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&I$3&\"'!\"&$I$1&$C14)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&J$3&\"'!\"&$I$1&$C14)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&K$3&\"'!\"&$I$1&$C14)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&L$3&\"'!\"&$I$1&$C14)),\"\")","v":{"$error":"#VALUE!"}},null,null,"Step 2: If you just want a list of the sheets you can use this simpler formula:"]
[{"$f":"AND(D15=E15:G15,I15=J15:L15)","v":{"$error":"#VALUE!"}},null,12,{"$f":"INDIRECT(\"'\"&D$3&\"'!\"&$D$1&$C15)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&E$3&\"'!\"&$D$1&$C15)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&F$3&\"'!\"&$D$1&$C15)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&G$3&\"'!\"&$D$1&$C15)","v":{"$error":"#VALUE!"}},null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&I$3&\"'!\"&$I$1&$C15)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&J$3&\"'!\"&$I$1&$C15)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&K$3&\"'!\"&$I$1&$C15)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&L$3&\"'!\"&$I$1&$C15)),\"\")","v":{"$error":"#VALUE!"}},null,null,"=TEXTAFTER(Names_Sheets,\"]\")"]
[{"$f":"AND(D16=E16:G16,I16=J16:L16)","v":{"$error":"#VALUE!"}},null,13,{"$f":"INDIRECT(\"'\"&D$3&\"'!\"&$D$1&$C16)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&E$3&\"'!\"&$D$1&$C16)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&F$3&\"'!\"&$D$1&$C16)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&G$3&\"'!\"&$D$1&$C16)","v":{"$error":"#VALUE!"}},null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&I$3&\"'!\"&$I$1&$C16)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&J$3&\"'!\"&$I$1&$C16)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&K$3&\"'!\"&$I$1&$C16)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&L$3&\"'!\"&$I$1&$C16)),\"\")","v":{"$error":"#VALUE!"}},null,null,{"$f":"_xlfn.TEXTAFTER(Names_Sheets,\"]\")","v":{"$error":"#NAME?"}}]
[{"$f":"AND(D17=E17:G17,I17=J17:L17)","v":{"$error":"#VALUE!"}},null,14,{"$f":"INDIRECT(\"'\"&D$3&\"'!\"&$D$1&$C17)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&E$3&\"'!\"&$D$1&$C17)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&F$3&\"'!\"&$D$1&$C17)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&G$3&\"'!\"&$D$1&$C17)","v":{"$error":"#VALUE!"}},null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&I$3&\"'!\"&$I$1&$C17)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&J$3&\"'!\"&$I$1&$C17)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&K$3&\"'!\"&$I$1&$C17)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&L$3&\"'!\"&$I$1&$C17)),\"\")","v":{"$error":"#VALUE!"}}]
[{"$f":"AND(D18=E18:G18,I18=J18:L18)","v":{"$error":"#VALUE!"}},null,15,{"$f":"INDIRECT(\"'\"&D$3&\"'!\"&$D$1&$C18)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&E$3&\"'!\"&$D$1&$C18)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&F$3&\"'!\"&$D$1&$C18)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&G$3&\"'!\"&$D$1&$C18)","v":{"$error":"#VALUE!"}},null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&I$3&\"'!\"&$I$1&$C18)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&J$3&\"'!\"&$I$1&$C18)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&K$3&\"'!\"&$I$1&$C18)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&L$3&\"'!\"&$I$1&$C18)),\"\")","v":{"$error":"#VALUE!"}},null,null,"ALTERNATIVE 2"]
[{"$f":"AND(D19=E19:G19,I19=J19:L19)","v":{"$error":"#VALUE!"}},null,16,{"$f":"INDIRECT(\"'\"&D$3&\"'!\"&$D$1&$C19)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&E$3&\"'!\"&$D$1&$C19)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&F$3&\"'!\"&$D$1&$C19)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&G$3&\"'!\"&$D$1&$C19)","v":{"$error":"#VALUE!"}},null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&I$3&\"'!\"&$I$1&$C19)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&J$3&\"'!\"&$I$1&$C19)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&K$3&\"'!\"&$I$1&$C19)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&L$3&\"'!\"&$I$1&$C19)),\"\")","v":{"$error":"#VALUE!"}},null,null,"Step 2: If you just want specific sheets you can use this:"]
[{"$f":"AND(D20=E20:G20,I20=J20:L20)","v":{"$error":"#VALUE!"}},null,17,{"$f":"INDIRECT(\"'\"&D$3&\"'!\"&$D$1&$C20)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&E$3&\"'!\"&$D$1&$C20)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&F$3&\"'!\"&$D$1&$C20)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&G$3&\"'!\"&$D$1&$C20)","v":{"$error":"#VALUE!"}},null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&I$3&\"'!\"&$I$1&$C20)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&J$3&\"'!\"&$I$1&$C20)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&K$3&\"'!\"&$I$1&$C20)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&L$3&\"'!\"&$I$1&$C20)),\"\")","v":{"$error":"#VALUE!"}},null,null,"=INDEX(TEXTAFTER(Names_Sheets,\"]\"),O18)"]
[{"$f":"AND(D21=E21:G21,I21=J21:L21)","v":{"$error":"#VALUE!"}},null,18,{"$f":"INDIRECT(\"'\"&D$3&\"'!\"&$D$1&$C21)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&E$3&\"'!\"&$D$1&$C21)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&F$3&\"'!\"&$D$1&$C21)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&G$3&\"'!\"&$D$1&$C21)","v":{"$error":"#VALUE!"}},null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&I$3&\"'!\"&$I$1&$C21)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&J$3&\"'!\"&$I$1&$C21)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&K$3&\"'!\"&$I$1&$C21)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&L$3&\"'!\"&$I$1&$C21)),\"\")","v":{"$error":"#VALUE!"}},null,null,1,2,3,4]
[{"$f":"AND(D22=E22:G22,I22=J22:L22)","v":{"$error":"#VALUE!"}},null,19,{"$f":"INDIRECT(\"'\"&D$3&\"'!\"&$D$1&$C22)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&E$3&\"'!\"&$D$1&$C22)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&F$3&\"'!\"&$D$1&$C22)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&G$3&\"'!\"&$D$1&$C22)","v":{"$error":"#VALUE!"}},null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&I$3&\"'!\"&$I$1&$C22)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&J$3&\"'!\"&$I$1&$C22)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&K$3&\"'!\"&$I$1&$C22)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&L$3&\"'!\"&$I$1&$C22)),\"\")","v":{"$error":"#VALUE!"}},null,null,{"$f":"INDEX(_xlfn.TEXTAFTER(Names_Sheets,\"]\"),O21)","v":{"$error":"#NAME?"}},{"$f":"INDEX(_xlfn.TEXTAFTER(Names_Sheets,\"]\"),P21)","v":{"$error":"#NAME?"}},{"$f":"INDEX(_xlfn.TEXTAFTER(Names_Sheets,\"]\"),Q21)","v":{"$error":"#NAME?"}},{"$f":"INDEX(_xlfn.TEXTAFTER(Names_Sheets,\"]\"),R21)","v":{"$error":"#NAME?"}}]
[{"$f":"AND(D23=E23:G23,I23=J23:L23)","v":{"$error":"#VALUE!"}},null,20,{"$f":"INDIRECT(\"'\"&D$3&\"'!\"&$D$1&$C23)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&E$3&\"'!\"&$D$1&$C23)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&F$3&\"'!\"&$D$1&$C23)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&G$3&\"'!\"&$D$1&$C23)","v":{"$error":"#VALUE!"}},null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&I$3&\"'!\"&$I$1&$C23)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&J$3&\"'!\"&$I$1&$C23)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&K$3&\"'!\"&$I$1&$C23)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&L$3&\"'!\"&$I$1&$C23)),\"\")","v":{"$error":"#VALUE!"}},null,null,"(This is the implimentation I have used in cells D3:G3)"]
[{"$f":"AND(D24=E24:G24,I24=J24:L24)","v":{"$error":"#VALUE!"}},null,21,{"$f":"INDIRECT(\"'\"&D$3&\"'!\"&$D$1&$C24)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&E$3&\"'!\"&$D$1&$C24)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&F$3&\"'!\"&$D$1&$C24)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&G$3&\"'!\"&$D$1&$C24)","v":{"$error":"#VALUE!"}},null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&I$3&\"'!\"&$I$1&$C24)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&J$3&\"'!\"&$I$1&$C24)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&K$3&\"'!\"&$I$1&$C24)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&L$3&\"'!\"&$I$1&$C24)),\"\")","v":{"$error":"#VALUE!"}}]
[{"$f":"AND(D25=E25:G25,I25=J25:L25)","v":{"$error":"#VALUE!"}},null,22,{"$f":"INDIRECT(\"'\"&D$3&\"'!\"&$D$1&$C25)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&E$3&\"'!\"&$D$1&$C25)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&F$3&\"'!\"&$D$1&$C25)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&G$3&\"'!\"&$D$1&$C25)","v":{"$error":"#VALUE!"}},null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&I$3&\"'!\"&$I$1&$C25)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&J$3&\"'!\"&$I$1&$C25)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&K$3&\"'!\"&$I$1&$C25)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&L$3&\"'!\"&$I$1&$C25)),\"\")","v":{"$error":"#VALUE!"}}]
[{"$f":"AND(D26=E26:G26,I26=J26:L26)","v":{"$error":"#VALUE!"}},null,23,{"$f":"INDIRECT(\"'\"&D$3&\"'!\"&$D$1&$C26)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&E$3&\"'!\"&$D$1&$C26)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&F$3&\"'!\"&$D$1&$C26)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&G$3&\"'!\"&$D$1&$C26)","v":{"$error":"#VALUE!"}},null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&I$3&\"'!\"&$I$1&$C26)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&J$3&\"'!\"&$I$1&$C26)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&K$3&\"'!\"&$I$1&$C26)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&L$3&\"'!\"&$I$1&$C26)),\"\")","v":{"$error":"#VALUE!"}}]
[{"$f":"AND(D27=E27:G27,I27=J27:L27)","v":{"$error":"#VALUE!"}},null,24,{"$f":"INDIRECT(\"'\"&D$3&\"'!\"&$D$1&$C27)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&E$3&\"'!\"&$D$1&$C27)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&F$3&\"'!\"&$D$1&$C27)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&G$3&\"'!\"&$D$1&$C27)","v":{"$error":"#VALUE!"}},null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&I$3&\"'!\"&$I$1&$C27)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&J$3&\"'!\"&$I$1&$C27)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&K$3&\"'!\"&$I$1&$C27)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&L$3&\"'!\"&$I$1&$C27)),\"\")","v":{"$error":"#VALUE!"}}]
[{"$f":"AND(D28=E28:G28,I28=J28:L28)","v":{"$error":"#VALUE!"}},null,25,{"$f":"INDIRECT(\"'\"&D$3&\"'!\"&$D$1&$C28)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&E$3&\"'!\"&$D$1&$C28)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&F$3&\"'!\"&$D$1&$C28)","v":{"$error":"#VALUE!"}},{"$f":"INDIRECT(\"'\"&G$3&\"'!\"&$D$1&$C28)","v":{"$error":"#VALUE!"}},null,{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&I$3&\"'!\"&$I$1&$C28)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&J$3&\"'!\"&$I$1&$C28)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&K$3&\"'!\"&$I$1&$C28)),\"\")","v":{"$error":"#VALUE!"}},{"$f":"_xlfn.IFNA(_xlfn.FORMULATEXT(INDIRECT(\"'\"&L$3&\"'!\"&$I$1&$C28)),\"\")","v":{"$error":"#VALUE!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"IFERROR(INDEX(MID(Names_Sheets,FIND(\"]\",Names_Sheets)+1,255),ROWS(A$1:A12)),\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX(MID(Names_Sheets,FIND(\"]\",Names_Sheets)+1,255),ROWS(A$1:A13)),\"\")","v":""}]
[null,null,null,{"$f":"IFERROR(INDEX(MID(Names_Sheets,FIND(\"]\",Names_Sheets)+1,255),ROWS(A$1:A14)),\"\")","v":""}]

{"sheet":"Loans","index":5,"n_rows":10,"n_cols":30,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,2,17]]}
["\"Is there a way i can input my bills over a period and get a summary of what is due each month? For example if I had a loan for 2 years - can I make some type of graph / table which could show me what I need to pay in each of the current months? A bit simple with just one loan but I'd like to do for a number of loans, different amounts and payment dates and end dates.\""]
[]
[]
[]
[null,"Loan","Start","Months","Monthly",null,"2024-01-01","2024-02-01","2024-03-01","2024-04-01","2024-05-01","2024-06-01","2024-07-01","2024-08-01","2024-09-01","2024-10-01","2024-11-01","2024-12-01","2025-01-01","2025-02-01","2025-03-01","2025-04-01","2025-05-01","2025-06-01","2025-07-01","2025-08-01","2025-09-01","2025-10-01","2025-11-01","2025-12-01"]
[null,"A","2024-02-01",12,100,null,{"$f":"IF(AND(G$5>=$C6,G$5<=EOMONTH($C6,$D6-1)),$E6,0)","v":0},{"$f":"IF(AND(H$5>=$C6,H$5<=EOMONTH($C6,$D6-1)),$E6,0)","v":100},100,100,100,100,100,100,100,100,100,100,100,0,0,0,0,0,0,0,0,0,0,0]
[null,"B","2024-04-01",6,200,null,{"$f":"IF(AND(G$5>=$C7,G$5<=EOMONTH($C7,$D7-1)),$E7,0)","v":0},0,0,200,200,200,200,200,200,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"C","2024-06-01",18,300,null,0,0,0,0,0,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,300,0]
[]
[null,null,null,null,null,"Total",{"$f":"SUM(G6:G9)","v":0},{"$f":"SUM(H6:H9)","v":100},100,300,300,600,600,600,600,400,400,400,400,300,300,300,300,300,300,300,300,300,300,0]

{"sheet":"Cash Waterfall","index":6,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Opening M1",10000]
["Debtor receipts",5000]
["Creditor payments",-2000]
["Loan repayment",-100]
["Wages",-500]
["Closing M1",{"$f":"SUM(B1:B5)","v":12400}]
["Debtor receipts",4000]
["Creditor payments",-3500]
["Loan repayment",-100]
["Wages",-450]
["Closing M2",{"$f":"SUM(B6:B10)","v":12350}]

{"sheet":"Apples Frequency","index":7,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Apples",null,{"$f":"_xlfn.UNIQUE(A1:A20)","v":"Apples"},{"$f":"COUNTIFS(A1:A20,_xlfn.ANCHORARRAY(C1))","v":9}]
["Apples",null,"Pears",4]
["Apples",null,"Grapes",1]
["Apples",null,"Strawberry",1]
["Apples",null,"Bannanas",5]
["Pears"]
["Grapes"]
["Strawberry"]
["Pears"]
["Bannanas"]
["Bannanas"]
["Bannanas"]
["Apples"]
["Apples"]
["Apples"]
["Pears"]
["Pears"]
["Bannanas"]
["Bannanas"]
["Apples"]

{"sheet":"Comma Format Macro","index":8,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Sub comma_fmt()"]
["'"]
["' comma_fmt Macro"]
["'"]
[]
["'"]
["    Selection.NumberFormat = \"#,##0 ;(#,##0);- \""]
["    "]
["End Sub"]
[]
["Note, this macro is also within Module1 of this workbook. Press ALT+F11 to access VBA window."]