{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Assumptions","Forecast (Table Refs)","Forecast (Range Refs)","Jan 2021","Feb 2021","Mar 2021","Apr 2021","May 2021","GL Mapping","Table Mapping","Calendar"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3416,"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":"Assumptions","index":0,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,2],[4,2,4,3]]}
["Model by Carl Seidman"]
["SeidmanFinancial.com"]
["carl@seidmanfinancial.com"]
[]
[null,"Company Name","ABC Company"]
[]
[]
[null,null,"Months","Years"]
[null,"Start","Jan",2021]
[]
[null,null,"Tax Rate",0.35]

{"sheet":"Forecast (Table Refs)","index":1,"n_rows":29,"n_cols":21,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Model by Carl Seidman",null,null,null,null,1,{"$f":"F1+1","v":2},{"$f":"G1+1","v":3},4,5,6,7,8,9,10,11,{"$f":"P1+1","v":12},null,{"$f":"MAX(F1:OFFSET($S1,,-1))&\"-\"","v":"12-"},null,"2021-01-31"]
["carl@seidmanfinancial.com",null,null,null,null,{"$f":"TRANSPOSE(CalendarActive)","v":"Jan"},"Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec",null,"Month",null,"2021-12-31"]
[null,null,"GL","GL",null,2021,{"$f":"IF(F2=\"Dec\",F3+1,F3)","v":2021},2021,2021,2021,2021,2021,2021,2021,2021,2021,2021,null,2021]
[null,null,"Start Range","End Range",null,{"$f":"EOMONTH(DATE(F3,INDEX(CalendarArray,VLOOKUP(F2,CalendarArray,2,FALSE),2),1),0)","v":"2021-01-31"},"2021-02-28","2021-03-31","2021-04-30","2021-05-31","2021-06-30","2021-07-31","2021-08-31","2021-09-30","2021-10-31","2021-11-30","2021-12-31",null,"Total"]
[]
[null,"Revenues",{"$f":"INDEX('GL Mapping'!$B:$E,MATCH('Forecast (Table Refs)'!$B6,'GL Mapping'!$B:$B,0),3)","v":4010},{"$f":"INDEX('GL Mapping'!$B:$E,MATCH('Forecast (Table Refs)'!$B6,'GL Mapping'!$B:$B,0),4)","v":4030},null,{"$f":"SUMIFS(INDIRECT(F$27&F$29),INDIRECT(F$27&F$28),\">=\"&$C6,INDIRECT(F$27&F$28),\"<=\"&$D6)","v":43069},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(INDEX($F6:$Q6,1,MATCH($U$1,$F$4:$Q$4,0)):INDEX($F6:$Q6,1,MATCH($U$2,$F$4:$Q$4,0)))","v":43069}]
[null,"COGS",{"$f":"INDEX('GL Mapping'!$B:$E,MATCH('Forecast (Table Refs)'!$B7,'GL Mapping'!$B:$B,0),3)","v":5010},{"$f":"INDEX('GL Mapping'!$B:$E,MATCH('Forecast (Table Refs)'!$B7,'GL Mapping'!$B:$B,0),4)","v":5030},null,-29286.920000000002,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(INDEX($F7:$Q7,1,MATCH($U$1,$F$4:$Q$4,0)):INDEX($F7:$Q7,1,MATCH($U$2,$F$4:$Q$4,0)))","v":-29286.920000000002}]
[null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "," ",null," "]
[null,"Gross Profit",null,null,null,{"$f":"F6+F7","v":13782.079999999998},0,{"$f":"H6+H7","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"S6+S7","v":13782.079999999998}]
[null,"Salaries and Benefits",{"$f":"INDEX('GL Mapping'!$B:$E,MATCH('Forecast (Table Refs)'!$B10,'GL Mapping'!$B:$B,0),3)","v":6100},{"$f":"INDEX('GL Mapping'!$B:$E,MATCH('Forecast (Table Refs)'!$B10,'GL Mapping'!$B:$B,0),4)","v":6120},null,{"$f":"SUMIFS(INDIRECT(F$27&F$29),INDIRECT(F$27&F$28),\">=\"&$C10,INDIRECT(F$27&F$28),\"<=\"&$D10)","v":-4785},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(INDEX($F10:$Q10,1,MATCH($U$1,$F$4:$Q$4,0)):INDEX($F10:$Q10,1,MATCH($U$2,$F$4:$Q$4,0)))","v":-4785}]
[null,"Marketing Expenses",{"$f":"INDEX('GL Mapping'!$B:$E,MATCH('Forecast (Table Refs)'!$B11,'GL Mapping'!$B:$B,0),3)","v":6200},{"$f":"INDEX('GL Mapping'!$B:$E,MATCH('Forecast (Table Refs)'!$B11,'GL Mapping'!$B:$B,0),4)","v":6220},null,-2619,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(INDEX($F11:$Q11,1,MATCH($U$1,$F$4:$Q$4,0)):INDEX($F11:$Q11,1,MATCH($U$2,$F$4:$Q$4,0)))","v":-2619}]
[null,"General & Administration",{"$f":"INDEX('GL Mapping'!$B:$E,MATCH('Forecast (Table Refs)'!$B12,'GL Mapping'!$B:$B,0),3)","v":6300},{"$f":"INDEX('GL Mapping'!$B:$E,MATCH('Forecast (Table Refs)'!$B12,'GL Mapping'!$B:$B,0),4)","v":6320},null,-1193,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(INDEX($F12:$Q12,1,MATCH($U$1,$F$4:$Q$4,0)):INDEX($F12:$Q12,1,MATCH($U$2,$F$4:$Q$4,0)))","v":-1193}]
[null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "," ",null," "]
[null,"EBITDA",null,null,null,{"$f":"F9+SUM(F10:F13)","v":5185.0799999999981},{"$f":"G9+SUM(G10:G13)","v":0},{"$f":"H9+SUM(H10:H13)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"S9+SUM(S10:S13)","v":5185.0799999999981}]
[null,"Depreciation",{"$f":"INDEX('GL Mapping'!$B:$E,MATCH('Forecast (Table Refs)'!$B15,'GL Mapping'!$B:$B,0),3)","v":6400},{"$f":"INDEX('GL Mapping'!$B:$E,MATCH('Forecast (Table Refs)'!$B15,'GL Mapping'!$B:$B,0),4)","v":6400},null,{"$f":"SUMIFS(INDIRECT(F$27&F$29),INDIRECT(F$27&F$28),\">=\"&$C15,INDIRECT(F$27&F$28),\"<=\"&$D15)","v":-800},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(INDEX($F15:$Q15,1,MATCH($U$1,$F$4:$Q$4,0)):INDEX($F15:$Q15,1,MATCH($U$2,$F$4:$Q$4,0)))","v":-800}]
[null,"Amortization",0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(INDEX($F16:$Q16,1,MATCH($U$1,$F$4:$Q$4,0)):INDEX($F16:$Q16,1,MATCH($U$2,$F$4:$Q$4,0)))","v":0}]
[null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "," ",null," "]
[null,"EBIT",null,null,null,{"$f":"SUM(F14:F17)","v":4385.0799999999981},{"$f":"SUM(G14:G17)","v":0},0,{"$f":"SUM(I14:I17)","v":0},0,{"$f":"SUM(K14:K17)","v":0},0,0,0,0,0,0,null,{"$f":"SUM(S14:S17)","v":4385.0799999999981}]
[null,"Non-Operating Inc/(Exp)",{"$f":"INDEX('GL Mapping'!$B:$E,MATCH('Forecast (Table Refs)'!$B19,'GL Mapping'!$B:$B,0),3)","v":7000},{"$f":"INDEX('GL Mapping'!$B:$E,MATCH('Forecast (Table Refs)'!$B19,'GL Mapping'!$B:$B,0),4)","v":7000},null,{"$f":"SUMIFS(INDIRECT(F$27&F$29),INDIRECT(F$27&F$28),\">=\"&$C19,INDIRECT(F$27&F$28),\"<=\"&$D19)","v":50},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(INDEX($F19:$Q19,1,MATCH($U$1,$F$4:$Q$4,0)):INDEX($F19:$Q19,1,MATCH($U$2,$F$4:$Q$4,0)))","v":50}]
[null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "," ",null," "]
[null,"Pre-Tax Income",null,null,null,{"$f":"SUM(F18:F20)","v":4435.0799999999981},{"$f":"SUM(G18:G20)","v":0},0,{"$f":"SUM(I18:I20)","v":0},0,{"$f":"SUM(K18:K20)","v":0},0,0,0,0,0,0,null,{"$f":"SUM(S18:S20)","v":4435.0799999999981}]
[null,"Taxes",0,0,null,{"$f":"-(Assumptions!$D11*F21)","v":-1552.2779999999993},{"$f":"-(Assumptions!$D11*G21)","v":0},{"$f":"-(Assumptions!$D11*H21)","v":0},{"$f":"-(Assumptions!$D11*I21)","v":0},{"$f":"-(Assumptions!$D11*J21)","v":0},{"$f":"-(Assumptions!$D11*K21)","v":0},{"$f":"-(Assumptions!$D11*L21)","v":0},{"$f":"-(Assumptions!$D11*M21)","v":0},{"$f":"-(Assumptions!$D11*N21)","v":0},{"$f":"-(Assumptions!$D11*O21)","v":0},{"$f":"-(Assumptions!$D11*P21)","v":0},{"$f":"-(Assumptions!$D11*Q21)","v":0},null,{"$f":"-(Assumptions!$D11*S21)","v":-1552.2779999999993}]
[null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "," ",null," "]
[null,"Net Income",null,null,null,{"$f":"SUM(F21:F23)","v":2882.8019999999988},{"$f":"SUM(G21:G23)","v":0},{"$f":"SUM(H21:H23)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(S21:S23)","v":2882.8019999999988}]
[null,null,null,null,null,{"$f":"IFERROR(F24/F6,\"\")","v":6.6934500452761822E-2},{"$f":"IFERROR(G24/G6,\"\")","v":""},"","",{"$f":"IFERROR(J24/J6,\"\")","v":""},"","","","","","",{"$f":"IFERROR(Q24/Q6,\"\")","v":""},null,{"$f":"S24/S6","v":6.6934500452761822E-2}]
[]
[null,"Table Reference",null,null,null,{"$f":"F2&\"_\"&F3&\"_GL\"","v":"Jan_2021_GL"},{"$f":"G2&\"_\"&G3&\"_GL\"","v":"Feb_2021_GL"},{"$f":"H2&\"_\"&H3&\"_GL\"","v":"Mar_2021_GL"},{"$f":"I2&\"_\"&I3&\"_GL\"","v":"Apr_2021_GL"},{"$f":"J2&\"_\"&J3&\"_GL\"","v":"May_2021_GL"}]
[null,"Lookup Criteria",null,null,null,"[GL Acct]","[GL Acct]","[GL Acct]","[GL Acct]","[GL Acct]"]
[null,"Lookup Total",null,null,null,"[Total]","[Total]","[Total]","[Total]","[Total]"]

{"sheet":"Forecast (Range Refs)","index":2,"n_rows":32,"n_cols":21,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Model by Carl Seidman",null,null,null,null,1,{"$f":"F1+1","v":2},{"$f":"G1+1","v":3},4,5,6,7,8,9,10,11,{"$f":"P1+1","v":12},null,{"$f":"MAX(F1:OFFSET($S1,,-1))&\"-\"","v":"12-"},null,"2021-01-31"]
["carl@seidmanfinancial.com",null,null,null,null,{"$f":"TRANSPOSE(CalendarActive)","v":"Jan"},"Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec",null,"Month",null,"2021-12-31"]
[null,null,"GL","GL",null,2021,{"$f":"IF(F2=\"Dec\",F3+1,F3)","v":2021},2021,2021,2021,2021,2021,2021,2021,2021,2021,2021,null,2021]
[null,null,"Start Range","End Range",null,{"$f":"EOMONTH(DATE(F3,INDEX(CalendarArray,VLOOKUP(F2,CalendarArray,2,FALSE),2),1),0)","v":"2021-01-31"},"2021-02-28","2021-03-31","2021-04-30","2021-05-31","2021-06-30","2021-07-31","2021-08-31","2021-09-30","2021-10-31","2021-11-30","2021-12-31",null,"Total"]
[]
[null,"Revenues",{"$f":"INDEX('GL Mapping'!$B:$E,MATCH('Forecast (Range Refs)'!$B6,'GL Mapping'!$B:$B,0),3)","v":4010},{"$f":"INDEX('GL Mapping'!$B:$E,MATCH('Forecast (Range Refs)'!$B6,'GL Mapping'!$B:$B,0),4)","v":4030},null,{"$f":"SUMIFS(INDIRECT(F$30),INDIRECT(F$32),\">=\"&$C6,INDIRECT(F$32),\"<=\"&$D6)","v":43069},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(INDEX($F6:$Q6,1,MATCH($U$1,$F$4:$Q$4,0)):INDEX($F6:$Q6,1,MATCH($U$2,$F$4:$Q$4,0)))","v":43069}]
[null,"COGS",{"$f":"INDEX('GL Mapping'!$B:$E,MATCH('Forecast (Range Refs)'!$B7,'GL Mapping'!$B:$B,0),3)","v":5010},{"$f":"INDEX('GL Mapping'!$B:$E,MATCH('Forecast (Range Refs)'!$B7,'GL Mapping'!$B:$B,0),4)","v":5030},null,{"$f":"SUMIFS(INDIRECT(F$30),INDIRECT(F$32),\">=\"&$C7,INDIRECT(F$32),\"<=\"&$D7)","v":-29286.920000000002},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(INDEX($F7:$Q7,1,MATCH($U$1,$F$4:$Q$4,0)):INDEX($F7:$Q7,1,MATCH($U$2,$F$4:$Q$4,0)))","v":-29286.920000000002}]
[null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "," ",null," "]
[null,"Gross Profit",null,null,null,{"$f":"F6+F7","v":13782.079999999998},0,{"$f":"H6+H7","v":0},{"$f":"I6+I7","v":0},{"$f":"J6+J7","v":0},{"$f":"K6+K7","v":0},0,0,0,0,0,0,null,{"$f":"S6+S7","v":13782.079999999998}]
[null,"Salaries and Benefits",{"$f":"INDEX('GL Mapping'!$B:$E,MATCH('Forecast (Range Refs)'!$B10,'GL Mapping'!$B:$B,0),3)","v":6100},{"$f":"INDEX('GL Mapping'!$B:$E,MATCH('Forecast (Range Refs)'!$B10,'GL Mapping'!$B:$B,0),4)","v":6120},null,{"$f":"SUMIFS(INDIRECT(F$30),INDIRECT(F$32),\">=\"&$C10,INDIRECT(F$32),\"<=\"&$D10)","v":-4785},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(INDEX($F10:$Q10,1,MATCH($U$1,$F$4:$Q$4,0)):INDEX($F10:$Q10,1,MATCH($U$2,$F$4:$Q$4,0)))","v":-4785}]
[null,"Marketing Expenses",{"$f":"INDEX('GL Mapping'!$B:$E,MATCH('Forecast (Range Refs)'!$B11,'GL Mapping'!$B:$B,0),3)","v":6200},{"$f":"INDEX('GL Mapping'!$B:$E,MATCH('Forecast (Range Refs)'!$B11,'GL Mapping'!$B:$B,0),4)","v":6220},null,{"$f":"SUMIFS(INDIRECT(F$30),INDIRECT(F$32),\">=\"&$C11,INDIRECT(F$32),\"<=\"&$D11)","v":-2619},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(INDEX($F11:$Q11,1,MATCH($U$1,$F$4:$Q$4,0)):INDEX($F11:$Q11,1,MATCH($U$2,$F$4:$Q$4,0)))","v":-2619}]
[null,"General & Administration",{"$f":"INDEX('GL Mapping'!$B:$E,MATCH('Forecast (Range Refs)'!$B12,'GL Mapping'!$B:$B,0),3)","v":6300},{"$f":"INDEX('GL Mapping'!$B:$E,MATCH('Forecast (Range Refs)'!$B12,'GL Mapping'!$B:$B,0),4)","v":6320},null,{"$f":"SUMIFS(INDIRECT(F$30),INDIRECT(F$32),\">=\"&$C12,INDIRECT(F$32),\"<=\"&$D12)","v":-1193},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(INDEX($F12:$Q12,1,MATCH($U$1,$F$4:$Q$4,0)):INDEX($F12:$Q12,1,MATCH($U$2,$F$4:$Q$4,0)))","v":-1193}]
[null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "," ",null," "]
[null,"EBITDA",null,null,null,{"$f":"F9+SUM(F10:F13)","v":5185.0799999999981},0,{"$f":"H9+SUM(H10:H13)","v":0},{"$f":"I9+SUM(I10:I13)","v":0},{"$f":"J9+SUM(J10:J13)","v":0},{"$f":"K9+SUM(K10:K13)","v":0},0,0,0,0,0,0,null,{"$f":"S9+SUM(S10:S13)","v":5185.0799999999981}]
[null,"Depreciation",{"$f":"INDEX('GL Mapping'!$B:$E,MATCH('Forecast (Range Refs)'!$B15,'GL Mapping'!$B:$B,0),3)","v":6400},{"$f":"INDEX('GL Mapping'!$B:$E,MATCH('Forecast (Range Refs)'!$B15,'GL Mapping'!$B:$B,0),4)","v":6400},null,{"$f":"SUMIFS(INDIRECT(F$30),INDIRECT(F$32),\">=\"&$C15,INDIRECT(F$32),\"<=\"&$D15)","v":-800},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(INDEX($F15:$Q15,1,MATCH($U$1,$F$4:$Q$4,0)):INDEX($F15:$Q15,1,MATCH($U$2,$F$4:$Q$4,0)))","v":-800}]
[null,"Amortization",0,0,null,{"$f":"SUMIFS(INDIRECT(F$30),INDIRECT(F$32),\">=\"&$C16,INDIRECT(F$32),\"<=\"&$D16)","v":0},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(INDEX($F16:$Q16,1,MATCH($U$1,$F$4:$Q$4,0)):INDEX($F16:$Q16,1,MATCH($U$2,$F$4:$Q$4,0)))","v":0}]
[null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "," ",null," "]
[null,"EBIT",null,null,null,{"$f":"SUM(F14:F17)","v":4385.0799999999981},0,{"$f":"SUM(H14:H17)","v":0},{"$f":"SUM(I14:I17)","v":0},{"$f":"SUM(J14:J17)","v":0},{"$f":"SUM(K14:K17)","v":0},0,0,0,0,0,0,null,{"$f":"SUM(S14:S17)","v":4385.0799999999981}]
[null,"Non-Operating Inc/(Exp)",{"$f":"INDEX('GL Mapping'!$B:$E,MATCH('Forecast (Range Refs)'!$B19,'GL Mapping'!$B:$B,0),3)","v":7000},{"$f":"INDEX('GL Mapping'!$B:$E,MATCH('Forecast (Range Refs)'!$B19,'GL Mapping'!$B:$B,0),4)","v":7000},null,{"$f":"SUMIFS(INDIRECT(F$30),INDIRECT(F$32),\">=\"&$C19,INDIRECT(F$32),\"<=\"&$D19)","v":50},0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(INDEX($F19:$Q19,1,MATCH($U$1,$F$4:$Q$4,0)):INDEX($F19:$Q19,1,MATCH($U$2,$F$4:$Q$4,0)))","v":50}]
[null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "," ",null," "]
[null,"Pre-Tax Income",null,null,null,{"$f":"SUM(F18:F20)","v":4435.0799999999981},0,{"$f":"SUM(H18:H20)","v":0},{"$f":"SUM(I18:I20)","v":0},{"$f":"SUM(J18:J20)","v":0},{"$f":"SUM(K18:K20)","v":0},0,0,0,0,0,0,null,{"$f":"SUM(S18:S20)","v":4435.0799999999981}]
[null,"Taxes",0,0,null,{"$f":"-(Assumptions!$D11*F21)","v":-1552.2779999999993},{"$f":"-(Assumptions!$D11*G21)","v":0},{"$f":"-(Assumptions!$D11*H21)","v":0},{"$f":"-(Assumptions!$D11*I21)","v":0},{"$f":"-(Assumptions!$D11*J21)","v":0},{"$f":"-(Assumptions!$D11*K21)","v":0},{"$f":"-(Assumptions!$D11*L21)","v":0},{"$f":"-(Assumptions!$D11*M21)","v":0},{"$f":"-(Assumptions!$D11*N21)","v":0},{"$f":"-(Assumptions!$D11*O21)","v":0},{"$f":"-(Assumptions!$D11*P21)","v":0},{"$f":"-(Assumptions!$D11*Q21)","v":0},null,{"$f":"-(Assumptions!$D11*S21)","v":-1552.2779999999993}]
[null,null,null,null,null," "," "," "," "," "," "," "," "," "," "," "," ",null," "]
[null,"Net Income",null,null,null,{"$f":"SUM(F21:F23)","v":2882.8019999999988},0,{"$f":"SUM(H21:H23)","v":0},{"$f":"SUM(I21:I23)","v":0},{"$f":"SUM(J21:J23)","v":0},{"$f":"SUM(K21:K23)","v":0},0,0,0,0,0,0,null,{"$f":"SUM(S21:S23)","v":2882.8019999999988}]
[null,null,null,null,null,{"$f":"IFERROR(F24/F6,\"\")","v":6.6934500452761822E-2},"",{"$f":"IFERROR(H24/H6,\"\")","v":""},{"$f":"IFERROR(I24/I6,\"\")","v":""},{"$f":"IFERROR(J24/J6,\"\")","v":""},{"$f":"IFERROR(K24/K6,\"\")","v":""},"","","","","",{"$f":"IFERROR(Q24/Q6,\"\")","v":""},null,{"$f":"S24/S6","v":6.6934500452761822E-2}]
[]
[null,"Table Reference",null,null,null,{"$f":"F2&\" \"&F3","v":"Jan 2021"}]
[null,"Worksheet Reference",null,null,null,{"$f":"\"'\"&F27&\"'!\"","v":"'Jan 2021'!"}]
[null,"Total",null,null,null,{"$f":"_xlfn.XMATCH($B29,INDIRECT(F28&\"$1:$1\"),,)","v":5}]
[null,"Total Column Location",null,null,null,{"$f":"F28&_xlfn.XLOOKUP(F29,'Table Mapping'!$1:$1,'Table Mapping'!$2:$2)&\":\"&_xlfn.XLOOKUP(F29,'Table Mapping'!$1:$1,'Table Mapping'!$2:$2)","v":"'Jan 2021'!E:E"}]
[null,"GL Acct",null,null,null,{"$f":"_xlfn.XMATCH($B31,INDIRECT(F28&\"$1:$1\"),,)","v":4}]
[null,"GL Acct Column Location",null,null,null,{"$f":"F28&_xlfn.XLOOKUP(F31,'Table Mapping'!$1:$1,'Table Mapping'!$2:$2)&\":\"&_xlfn.XLOOKUP(F31,'Table Mapping'!$1:$1,'Table Mapping'!$2:$2)","v":"'Jan 2021'!D:D"}]

{"sheet":"Jan 2021","index":3,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"Account Detail","Account","GL Acct","Total"]
[null,"Sales Channel A","Revenues",4010,6875]
[null,"Sales Channel B","Revenues",4020,2609]
[null,"Sales Channel C","Revenues",4030,33585]
[null,"COGS Channel A","COGS",5010,{"$f":"-E2*0.68","v":-4675}]
[null,"COGS Channel B","COGS",5020,{"$f":"-E3*0.68","v":-1774.1200000000001}]
[null,"COGS Channel C","COGS",5030,{"$f":"-E4*0.68","v":-22837.800000000003}]
[null,"Salaries","Salaries and Benefits",6100,-2980]
[null,"Benefits","Salaries and Benefits",6110,-1005]
[null,"Bonuses","Salaries and Benefits",6120,-800]
[null,"eCommerce","Marketing Expenses",6200,-1029]
[null,"Web","Marketing Expenses",6210,-940]
[null,"Advertising","Marketing Expenses",6220,-650]
[null,"Travel","General & Administration",6300,-398]
[null,"Insurance","General & Administration",6310,-195]
[null,"Motor","General & Administration",6320,-600]
[null,"Depreciation","Depreciation",6400,-800]
[null,"Non-Operating Inc/(Exp)","Non-Operating Inc/(Exp)",7000,50]

{"sheet":"Feb 2021","index":4,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"Account Detail","Account","GL Acct","Total"]
[null,"Sales Channel A","Revenues",4010,7356.25]
[null,"Sales Channel B","Revenues",4020,2817.7200000000003]
[null,"Sales Channel C","Revenues",4030,35591.800000000003]
[null,"COGS Channel A","COGS",5010,-4815.25]
[null,"COGS Channel B","COGS",5020,-1862.8260000000002]
[null,"COGS Channel C","COGS",5030,-28113.580000000005]
[null,"Salaries","Salaries and Benefits",6100,-3188.6000000000004]
[null,"Benefits","Salaries and Benefits",6110,-1035.1500000000001]
[null,"Bonuses","Salaries and Benefits",6120,-840]
[null,"eCommerce","Marketing Expenses",6200,-1121.6100000000001]
[null,"Web","Marketing Expenses",6210,-958.80000000000007]
[null,"Advertising","Marketing Expenses",6220,-715.00000000000011]
[null,"Travel","General & Administration",6300,-425.86]
[null,"Insurance","General & Administration",6310,-195]
[null,"Motor","General & Administration",6320,-624]
[null,"Depreciation","Depreciation",6400,-800]
[null,"Non-Operating Inc/(Exp)","Non-Operating Inc/(Exp)",7000,54.500000000000007]

{"sheet":"Mar 2021","index":5,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"Account Detail","Account","GL Acct","Total"]
[null,"Sales Channel A","Revenues",4010,5589.3608319700861]
[null,"Sales Channel B","Revenues",4020,2121.111623361448]
[null,"Sales Channel C","Revenues",4030,27556.527544668501]
[null,"COGS Channel A","COGS",5010,-2190.9324608553397]
[null,"COGS Channel B","COGS",5020,-831.43895132677551]
[null,"COGS Channel C","COGS",5030,-11977.628587817884]
[null,"Salaries","Salaries and Benefits",6100,-2615.6739811912225]
[null,"Benefits","Salaries and Benefits",6110,-882.13166144200636]
[null,"Bonuses","Salaries and Benefits",6120,-702.19435736677121]
[null,"eCommerce","Marketing Expenses",6200,-942.95532646048105]
[null,"Web","Marketing Expenses",6210,-861.39747995418099]
[null,"Advertising","Marketing Expenses",6220,-595.64719358533785]
[null,"Travel","General & Administration",6300,-467.05783738474435]
[null,"Insurance","General & Administration",6310,-228.83487007544008]
[null,"Motor","General & Administration",6320,-704.1072925398156]
[null,"Depreciation","Depreciation",6400,-800]
[null,"Non-Operating Inc/(Exp)","Non-Operating Inc/(Exp)",7000,150]

{"sheet":"Apr 2021","index":6,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"Account Detail","Account","GL Acct","Total"]
[null,"Sales Channel A","Revenues",4010,6370.9770507127823]
[null,"Sales Channel A","Revenues",4010,2417.7278727723128]
[null,"Sales Channel A","Revenues",4010,31410.032356514945]
[null,"COGS Channel B","COGS",5020,-2497.3124561813502]
[null,"COGS Channel B","COGS",5020,-947.7073742803118]
[null,"COGS Channel B","COGS",5020,-13652.580169538336]
[null,"Salaries","Salaries and Benefits",6100,-2981.4498307210029]
[null,"Benefits","Salaries and Benefits",6110,-1005.4889529780565]
[null,"Bonuses","Salaries and Benefits",6120,-800.38921630094046]
[null,"eCommerce","Marketing Expenses",6200,-1074.8181993127146]
[null,"Web","Marketing Expenses",6210,-981.85530355097364]
[null,"Advertising","Marketing Expenses",6220,-678.94249713631143]
[null,"Travel","General & Administration",6300,-532.37120536462703]
[null,"Insurance","General & Administration",6310,-260.83513830678959]
[null,"Motor","General & Administration",6320,-802.56965632858339]
[null,"Depreciation","Depreciation",6400,-911.87199999999996]
[null,"Non-Operating Inc/(Exp)","Non-Operating Inc/(Exp)",7000,170.976]

{"sheet":"May 2021","index":7,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"Account Detail","Account","GL Acct","Total"]
[null,"Sales Channel A","Revenues",4010,7157.2183728946893]
[null,"Sales Channel A","Revenues",4010,2716.0993068919634]
[null,"Sales Channel A","Revenues",4010,35286.339738127601]
[null,"COGS Channel B","COGS",5020,-2805.5054118018224]
[null,"COGS Channel B","COGS",5020,-1064.663799184139]
[null,"COGS Channel B","COGS",5020,-15337.443040374037]
[null,"Salaries","Salaries and Benefits",6100,-3349.3901071128075]
[null,"Benefits","Salaries and Benefits",6110,-1129.5761938417356]
[null,"Bonuses","Salaries and Benefits",6120,-899.16512942625707]
[null,"eCommerce","Marketing Expenses",6200,-1207.4613520671669]
[null,"Web","Marketing Expenses",6210,-1103.0259192839037]
[null,"Advertising","Marketing Expenses",6220,-762.73068886652914]
[null,"Travel","General & Administration",6300,-598.07105596299482]
[null,"Insurance","General & Administration",6310,-293.02476359995978]
[null,"Motor","General & Administration",6320,-901.61465723064543]
[null,"Depreciation","Depreciation",6400,-1024.4059867392]
[null,"Non-Operating Inc/(Exp)","Non-Operating Inc/(Exp)",7000,192.07612251360001]

{"sheet":"GL Mapping","index":8,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,3,0,4]]}
[null,"Account",null,"GL Acct"]
[null,"Revenues",null,{"$f":"MIN(D3:D5)","v":4010},{"$f":"MAX(D3:D6)","v":4030}]
[null,"Sales Channel A",null,4010]
[null,"Sales Channel B",null,4020]
[null,"Sales Channel C",null,4030]
[]
[null,"COGS",null,{"$f":"MIN(D8:D10)","v":5010},{"$f":"MAX(D8:D11)","v":5030}]
[null,"COGS Channel A",null,5010]
[null,"COGS Channel B",null,5020]
[null,"COGS Channel C",null,5030]
[]
[null,"Salaries and Benefits",null,{"$f":"MIN(D13:D15)","v":6100},{"$f":"MAX(D13:D16)","v":6120}]
[null,"Salaries",null,6100]
[null,"Benefits",null,6110]
[null,"Bonuses",null,6120]
[]
[null,"Marketing Expenses",null,{"$f":"MIN(D18:D20)","v":6200},{"$f":"MAX(D18:D21)","v":6220}]
[null,"eCommerce",null,6200]
[null,"Web",null,6210]
[null,"Advertising",null,6220]
[]
[null,"General & Administration",null,{"$f":"MIN(D23:D25)","v":6300},{"$f":"MAX(D23:D26)","v":6320}]
[null,"Travel",null,6300]
[null,"Insurance",null,6310]
[null,"Motor",null,6320]
[]
[null,"Depreciation",null,{"$f":"MIN(D28:D28)","v":6400},{"$f":"MAX(D28:D29)","v":6400}]
[null,"Depreciation",null,6400]
[]
[null,"Non-Operating Inc/(Exp)",null,{"$f":"MIN(D31:D31)","v":7000},{"$f":"MAX(D31:D32)","v":7000}]
[null,"Non-Operating Inc/(Exp)",null,7000]

{"sheet":"Table Mapping","index":9,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[{"$f":"{1,2,3,4,5,6,7;\"A\",\"B\",\"C\",\"D\",\"E\",\"F\",\"G\"}","v":1},2,3,4,5,6,7]
["A","B","C","D","E","F","G"]

{"sheet":"Calendar","index":10,"n_rows":13,"n_cols":15,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,null,1,{"$f":"C1+1","v":2},3,4,5,6,7,8,9,10,11,12,"Active"]
[null,1,"Jan","Feb","Mar","Apr","May","June","Jul","Aug","Sep","Oct","Nov","Dec",{"$f":"(OFFSET(INDEX(Calendar!$C$2:$N$13,1,MATCH(Assumptions!$C$9,$C$2:$N$2,0)),,,12))","v":"Jan"}]
[null,2,"Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb"]
[null,3,"Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar"]
[null,4,"Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar","Apr"]
[null,5,"May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May"]
[null,6,"Jun","Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun"]
[null,7,"Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun","Jul"]
[null,8,"Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug"]
[null,9,"Sep","Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep"]
[null,10,"Oct","Nov","Dec","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct"]
[null,11,"Nov","Dec","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov"]
[null,12,"Dec","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]