{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Summary","Bank Deposits","433-A","433-B","Personal Expenses","Assets","Other"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":2,"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":"Summary","index":0,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,0,20,0],[19,2,20,2],[19,1,20,1],[19,3,20,3],[0,0,0,1],[0,2,0,3]]}
["PERSONAL",null,"BUSINESS"]
["Income:",{"$f":"IF(ISERROR(AVERAGE(B3:B7)),\"\",AVERAGE(B3:B7))","v":""},"Income",{"$f":"IF(ISERROR(AVERAGE(D3:D8)),\"\",AVERAGE(D3:D8))","v":""}]
["433-A",null,"433-B"]
["Bank statements",null,"433-A SE"]
["Tax Returns",null,"Bank Statements"]
["Paycheck stubs",null,"P&L's"]
["Other",null,"Tax Returns"]
["Other",null,"Other"]
[null,null,"Other"]
[]
["Expenses:",{"$f":"IF(ISERROR(AVERAGE(B12:B15)),\"\",AVERAGE(B12:B15))","v":""},"Expenses",{"$f":"IF(ISERROR(AVERAGE(D12:D16)),\"\",AVERAGE(D12:D16))","v":""}]
["433-A",null,"433-B"]
["List of  Expenses",null,"433-A SE"]
["Tax Returns",null,"P&L"]
["Other",null,"Tax Returns"]
["Other",null,"Other"]
["Other",null,"Other"]
[]
[]
["Ability to Pay",{"$f":"IF(ISERROR(B2-B11),\"\",B2-B11)","v":""},"Ability to Pay",{"$f":"IF(ISERROR(D2-D11),\"\",D2-D11)","v":""}]

{"sheet":"Bank Deposits","index":1,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,1,0,2],[0,4,0,5],[1,1,1,2],[1,4,1,5]]}
[null,"Business  Average",null,null,"Personal Average"]
[null,{"$f":"IF(AND(ISERROR(B4),ISERROR(C4)),\"\",SUM(B4:C4))","v":0},null,null,{"$f":"IF(AND(ISERROR(E4),ISERROR(F4)),\"\",SUM(E4:F4))","v":0}]
[null,{"$f":"\"Average \"&B5","v":"Average Account"},{"$f":"\"Average \"&C5","v":"Average Account"},null,{"$f":"\"Average \"&E5","v":"Average Account"},{"$f":"\"Average \"&F5","v":"Average Account"}]
[null,{"$f":"IF(ISERROR(AVERAGE(B6:B23)),\"\",AVERAGE(B6:B23))","v":""},{"$f":"IF(ISERROR(AVERAGE(C6:C23)),\"\",AVERAGE(C6:C23))","v":""},null,{"$f":"IF(ISERROR(AVERAGE(E6:E23)),\"\",AVERAGE(E6:E23))","v":""},{"$f":"IF(ISERROR(AVERAGE(F6:F23)),\"\",AVERAGE(F6:F23))","v":""}]
["Period","Account","Account","Period","Account","Account"]

{"sheet":"433-A","index":2,"n_rows":34,"n_cols":21,"rows_kept":34,"cut":false,"hidden":false,"merged":[[2,17,2,18],[2,19,2,20],[0,17,1,18],[0,19,1,20],[33,5,33,6],[33,7,33,8],[0,11,0,14],[0,5,0,7],[1,1,14,1],[1,2,1,4],[1,5,1,7],[7,2,7,4],[16,1,32,1],[16,2,16,3],[16,5,16,6]]}
["AAAAAAAABABF",null,null,null,null,"433-A / S.E.",null,null,null,null,null,"VARIATIONS",null,null,null,null,null,{"$f":"SUM(S5:S32)","v":0},null,{"$f":"SUM(U5:U32)","v":0}]
[null,"Self Employment","Total Monthly Business Income ",null,null,"Total Monthly Business Expenses",null,null,null,null,null,"Ttl Income",{"$f":"$E$13","v":0},{"$f":"$E$13","v":0},0]
[null,null,67,"Gross Receipts ",null,77,"Materials Purchased",null,null,null,{"$f":"\"Claims income from self-employment of \" & TEXT(E13,\"$* #,##0.00\") & \" with expenses of \" & TEXT(H14,\"$* #,##0.00\") & \" giving \" & TEXT(H15,\"$* #,##0.00\") & \" to taxpayer as business income\" & \".\"","v":"Claims income from self-employment of $0.00 with expenses of $0.00 giving $0.00 to taxpayer as business income."},{"$f":"G3","v":"Materials Purchased"},{"$f":"$H3","v":0},{"$f":"$H3","v":0},0,null,null,"Self-Employment (Other)",null,"Personal (Other)"]
[null,null,68,"Gross Rental Income ",null,78,"Inventory Purchased",null,null,null,null,{"$f":"G4","v":"Inventory Purchased"},{"$f":"$H4","v":0},0,0,null,null,"Item","Amount","Item","Amount"]
[null,null,69,"Interest ",null,79,"Gross Wages & Salaries",null,null,null,null,"Gross Wages & Salaries",0,0,0]
[null,null,70,"Dividends ",null,80,"Rent",null,null,null,null,"Rent",0,0,0]
[null,null,71,"Cash Receipts not included in lines 67-70",null,81,"Supplies",null,null,null,null,"Supplies",0,0,0]
[null,null,"Other Income (Specify below) ",null,null,82,"Utilities/Telephone ",null,null,null,null,"Utilities/Telephone ",0,0,0]
[null,null,72,null,null,83,"Vehicle Gasoline/Oil",null,null,null,null,"Vehicle Gasoline/Oil",0,0,0]
[null,null,73,null,null,84,"Repairs & Maintenance",null,null,null,null,"Repairs & Maintenance",0,0,0]
[null,null,74,null,null,85,"Insurance",null,null,null,null,"Insurance",0,0,0]
[null,null,75,null,null,86,"Current Taxes",null,null,null,null,"Current Taxes",0,0,0]
[null,null,76,"Total Income",{"$f":"SUM(E3:E12)","v":0},87,"Other Expenses, (incl. install. pmts)",null,null,null,null,"Other Expenses, (incl. install. pmts)",0,0,0]
[null,null,null,null,null,88,"Total Expenses ",{"$f":"SUM(H3:H13)","v":0},2000,null,null,"Total Expenses ",{"$f":"SUM(M3:M13)","v":0},{"$f":"SUM(N3:N13)","v":0},0]
[null,null,null,null,null,89,"Net Business Income",{"$f":"E13-H14","v":0},null,null,null,"Net Business Income",{"$f":"M2-M14","v":0},{"$f":"N2-N14","v":0},0]
[]
[null,"433-A","Source ",null,"Gross Monthly ","Expense Items ",null,"Claimed","Allowable ",null,null,"Total Income",{"$f":"$E$33","v":0},{"$f":"$E$33","v":0},0]
[null,null,20,"Wages (Taxpayer)",null,35,"Food, Clothing, and Misc.",null,{"$f":"IF(H18=\"\",\"\",H18)","v":""},null,{"$f":"\"Total claimed personal income is \" & TEXT(E33,\"$* #,##0.00\") & \".\"","v":"Total claimed personal income is $0.00."},{"$f":"G18","v":"Food, Clothing, and Misc."},{"$f":"$I18","v":""},{"$f":"$I18","v":""},""]
[null,null,21,"Wages (Spouse)",null,36,"Housing and Utilities",null,"",null,{"$f":"\"Claimed expenses total \" & TEXT(H32,\"$* #,##0.00\") & \".\"","v":"Claimed expenses total $0.00."},{"$f":"G19","v":"Housing and Utilities"},{"$f":"$I19","v":""},"",""]
[null,null,22,"Interest - Dividends ",null,37,"Vehicle Ownership Costs",null,"",null,{"$f":"\"Allowable expenses total \" & TEXT(I32,\"$* #,##0.00\") & \".\"","v":"Allowable expenses total $0.00."},"Vehicle Ownership Costs","","",""]
[null,null,23,"Net Business Income ",{"$f":"H15","v":0},38,"Vehicle Operating Costs",null,"",null,{"$f":"\"This gives taxpayer an ability to pay \" & TEXT(H34,\"$* #,##0.00\") & \" based on 433-A info alone.\"","v":"This gives taxpayer an ability to pay $0.00 based on 433-A info alone."},"Vehicle Operating Costs","","",""]
[null,null,24,"Net Rental Income",null,39,"Public Transportation",null,"",null,null,"Public Transportation","","",""]
[null,null,25,"Distributions",null,40,"Health Insurance ",null,"",null,null,"Health Insurance ","","",""]
[null,null,26,"Pension (Taxpayer)",null,41,"Out of Pocket Health Care Costs",null,"",null,null,"Out of Pocket Health Care Costs","","",""]
[null,null,27,"Pension (Spouse)",null,42,"Court Ordered Payments ",null,"",null,null,"Court Ordered Payments ","","",""]
[null,null,28,"Social Security (Taxpayer) ",null,43,"Child/Dependent Care ",null,"",null,null,"Child/Dependent Care ","","",""]
[null,null,29,"Social Security (Spouse) ",null,44,"Life insurance ",null,"",null,null,"Life insurance ","","",""]
[null,null,30,"Child Support ",null,45,"Current Year Taxes(Income/FICA)",null,"",null,null,"Current Year Taxes(Income/FICA)","","",""]
[null,null,31,"Alimony ",null,46,"Secured Debts (Attach List)",null,"",null,null,"Secured Debts (Attach List)","","",""]
[null,null," ","Other (Specifiy below)",null,47,"Delinquent State or Local Taxes",null,"",null,null,"Delinquent State or Local Taxes","","",""]
[null,null,32,null,null,48,"Other Expenses (Attach List)",null,"",null,null,"Other Expenses (Attach List)","","",""]
[null,null,33,null,null,49,"Total Living Expenses",{"$f":"SUM(H17:H31)","v":0},{"$f":"IF(H32=\"\",\"\",SUM(I18:I31))","v":0},null,null,"Total Living Expenses",{"$f":"SUM(M18:M31)","v":0},0,0]
[null,null,34,"Total Income (add lines 20-31) ",{"$f":"SUM(E18:E32)","v":0},50,"Net Difference",{"$f":"E33-H32","v":0},{"$f":"E33-I32","v":0},null,null,"Ability to Pay",{"$f":"M17-M32","v":0},0,0]
[null,null,null,null,null,"Ability To Pay",null,{"$f":"E33-I32","v":0}]

{"sheet":"433-B","index":3,"n_rows":32,"n_cols":13,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,9,0,12],[17,9,17,12],[1,1,1,3],[1,4,1,6],[8,1,8,3],[14,1,15,1],[14,2,15,2],[14,3,15,3]]}
[null,null,null,null,null,null,null,null,null,"VARIATIONS"]
[null,"Total Monthly Business Income ",null,null,"Total Monthly Business Expenses ",null,null,null,null,"Total Income"]
[null,null,"Source ","Gross Monthly ",null,"Expense Items ","Actual Monthly ","Adjusted Monthly",null,"Materials Purchased"]
[null,25,"Gross Receipts from Sales/Services ",null,36,"Materials Purchased",null,{"$f":"IF(G4=\"\",\"\",G4)","v":""},{"$f":"\"Taxpayer claims income of \" & TEXT(D15,\"$* #,##0.00\") & \" and expenses of \" & TEXT(G16,\"$* #,##0.00\") & \".  Of those expenses \" & TEXT(H16,\"$* #,##0.00\") & \" are allowable.\"","v":"Taxpayer claims income of $0.00 and expenses of $0.00.  Of those expenses $0.00 are allowable."},"Inventory Purchased"]
[null,26,"Gross Rental Income ",null,37,"Inventory Purchased",null,"",{"$f":"\"This gives an ability to pay of \" & TEXT(H15,\"$* #,##0.00\") & \".\"","v":"This gives an ability to pay of $0.00."},"Gross Wages & Salaries "]
[null,27,"Interest Income ",null,38,"Gross Wages & Salaries ",null,"",null,"Rent "]
[null,28,"Dividends ",null,39,"Rent ",null,"",null,"Supplies"]
[null,29,"Cash ",null,40,"Supplies",null,"",null,"Utilities/Telephone"]
[null,"Other Income (Specify below) ",null,null,41,"Utilities/Telephone",null,"",null,"Vehicle Gasoline/Oil "]
[null,30,null,null,42,"Vehicle Gasoline/Oil ",null,"",null,"Repairs & Maintenance "]
[null,31,null,null,43,"Repairs & Maintenance ",null,"",null,"Insurance "]
[null,32,null,null,44,"Insurance ",null,"",null,"Current Taxes"]
[null,33,null,null,45,"Current Taxes",null,"",null,"Other Expenses",{"$f":"SUM(K19:K32)","v":0},{"$f":"SUM(L19:L32)","v":0},0]
[null,34,null,null,46,"Other Expenses (Specify below) ",{"$f":"SUM(G19:G32)","v":0},{"$f":"SUM(H19:H32)","v":0},null,"Total Expenses",{"$f":"SUM(K3:K13)","v":0},{"$f":"SUM(L3:L13)","v":0},0]
[null,35,"Total Income (Add lines 25 through 34) ",{"$f":"SUM(D4:D8,D10:D14)","v":0},47,"IRS Use Only Allowable Installment Payments ",{"$f":"D15-G16","v":0},{"$f":"D15-H16","v":0},null,"Ability to Pay",{"$f":"K2-K14","v":0},{"$f":"L2-L14","v":0},0]
[null,null,null,null,48,"Total Expenses (Add lines 36 through 47) ",{"$f":"SUM(G4:G14)","v":0},{"$f":"SUM(H4:H14)","v":0}]
[]
[null,null,null,null,null,"46   List other expenses below","Actual Monthly","Adjusted Monthly",null,"46   List other expenses below"]
[null,null,null,null,null,null,null,{"$f":"IF(G19=\"\",\"\",G19)","v":""},null,null,{"$f":"IF(J19=\"\",\"\",J19)","v":""},{"$f":"IF(J19=\"\",\"\",J19)","v":""},{"$f":"IF(J19=\"\",\"\",J19)","v":""}]
[null,null,null,null,null,null,null,"",null,null,{"$f":"IF(J20=\"\",\"\",J20)","v":""},{"$f":"IF(J20=\"\",\"\",J20)","v":""},{"$f":"IF(J20=\"\",\"\",J20)","v":""}]
[null,null,null,null,null,null,null,"",null,null,"","",""]
[null,null,null,null,null,null,null,"",null,null,"","",""]
[null,null,null,null,null,null,null,"",null,null,"","",""]
[null,null,null,null,null,null,null,"",null,null,"","",""]
[null,null,null,null,null,null,null,"",null,null,"","",""]
[null,null,null,null,null,null,null,"",null,null,"","",""]
[null,null,null,null,null,null,null,"",null,null,"","",""]
[null,null,null,null,null,null,null,"",null,null,"","",""]
[null,null,null,null,null,null,null,"",null,null,"","",""]
[null,null,null,null,null,null,null,"",null,null,"","",""]
[null,null,null,null,null,null,null,"",null,null,"","",""]
[null,null,null,null,null,null,null,"",null,null,"","",""]

{"sheet":"Personal Expenses","index":4,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Item","Amount","Category",null,null,null,null,null,null,null,"Food, Clothing, and Misc.",{"$f":"SUMIF(C:C,K1,B:B)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Housing and Utilities",0]
[null,null,null,null,null,null,null,null,null,null,"Vehicle Ownership Costs",0]
[null,null,null,null,null,null,null,null,null,null,"Vehicle Operating Costs",0]
[null,null,null,null,null,null,null,null,null,null,"Public Transportation",0]
[null,null,null,null,null,null,null,null,null,null,"Health Insurance ",0]
[null,null,null,null,null,null,null,null,null,null,"Out of Pocket Health Care Costs",0]
[null,null,null,null,null,null,null,null,null,null,"Court Ordered Payments ",0]
[null,null,null,null,null,null,null,null,null,null,"Child/Dependent Care ",0]
[null,null,null,null,null,null,null,null,null,null,"Life insurance ",0]
[null,null,null,null,null,null,null,null,null,null,"Current Year Taxes(Income/FICA)",0]
[null,null,null,null,null,null,null,null,null,null,"Secured Debts",0]
[null,null,null,null,null,null,null,null,null,null,"Delinquent State or Local Taxes",0]
[null,null,null,null,null,null,null,null,null,null,"Other Expenses ",0]

{"sheet":"Assets","index":5,"n_rows":3,"n_cols":8,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Total Assets:",{"$f":"SUM(Assets!$B$2:$B$3)","v":0},{"$f":"SUM(Assets!$C$2:$C$3)","v":0},{"$f":"SUM(Assets!$D$2:$D$3)","v":0},null,{"$f":"SUM(Assets!$F$2:$F$3)","v":0},{"$f":"SUM(Assets!$G$2:$G$3)","v":0}]
["Asset","FMV","Loan Balance","Equity","Use Forced Sale Value?","Forced Sale Value","Net Proceeds if Seized","Disposition"]
[null,null,null,{"$f":"IF(Assets!$B$3:$B$3-Assets!$C$3:$C$3<0,\"None\",Assets!$B$3:$B$3-Assets!$C$3:$C$3)","v":0},"Y",{"$f":"IF(Assets!$B$3:$B$3-Assets!$C$3:$C$3<0,\"None\",IF(Assets!$E3=\"Y\",Assets!$B$3:$B$3*0.6,Assets!$B$3:$B$3-Assets!$C$3:$C$3))","v":0},{"$f":"IF(Assets!$B$3:$B$3-Assets!$C$3:$C$3<0,\"None\",IF(Assets!$F$3:$F$3-Assets!$C$3:$C$3<0,\"None\",Assets!$F$3:$F$3-Assets!$C$3:$C$3))","v":0}]

{"sheet":"Other","index":6,"n_rows":24,"n_cols":26,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,21,0,23],[0,0,0,2],[0,7,0,9],[0,14,0,16]]}
["Item",null,null,null,null,null,null,"Item",null,null,null,null,null,null,"Item",null,null,null,null,null,null,"Item"]
[null,"Used Period",null,"Used Amount","Is value a #?",null,null,null,"Used Period",null,"Used Amount","Is value a #?",null,null,null,"Used Period",null,"Used Amount","Is value a #?",null,null,null,"Used Period",null,"Used Amount","Is value a #?"]
["Period1",{"$f":"IF(LEFT(A3,6)=\"Period\",TRUE,FALSE)","v":true},"Amount1",{"$f":"IF(LEFT(C3,6)=\"Amount\",TRUE,FALSE)","v":true},{"$f":"IF(ISNUMBER(C3),TRUE,FALSE)","v":false},null,null,"Period1",{"$f":"IF(LEFT(H3,6)=\"Period\",TRUE,FALSE)","v":true},"Amount1",{"$f":"IF(LEFT(J3,6)=\"Amount\",TRUE,FALSE)","v":true},{"$f":"IF(ISNUMBER(J3),TRUE,FALSE)","v":false},null,null,"Period1",{"$f":"IF(LEFT(O3,6)=\"Period\",TRUE,FALSE)","v":true},"Amount1",{"$f":"IF(LEFT(Q3,6)=\"Amount\",TRUE,FALSE)","v":true},{"$f":"IF(ISNUMBER(Q3),TRUE,FALSE)","v":false},null,null,"Period1",{"$f":"IF(LEFT(V3,6)=\"Period\",TRUE,FALSE)","v":true},"Amount1",{"$f":"IF(LEFT(X3,6)=\"Amount\",TRUE,FALSE)","v":true},{"$f":"IF(ISNUMBER(X3),TRUE,FALSE)","v":false}]
["Period2",{"$f":"IF(LEFT(A4,6)=\"Period\",TRUE,FALSE)","v":true},"Amount2",{"$f":"IF(LEFT(C4,6)=\"Amount\",TRUE,FALSE)","v":true},{"$f":"IF(ISNUMBER(C4),TRUE,FALSE)","v":false},null,null,"Period2",{"$f":"IF(LEFT(H4,6)=\"Period\",TRUE,FALSE)","v":true},"Amount2",{"$f":"IF(LEFT(J4,6)=\"Amount\",TRUE,FALSE)","v":true},{"$f":"IF(ISNUMBER(J4),TRUE,FALSE)","v":false},null,null,"Period2",{"$f":"IF(LEFT(O4,6)=\"Period\",TRUE,FALSE)","v":true},"Amount2",{"$f":"IF(LEFT(Q4,6)=\"Amount\",TRUE,FALSE)","v":true},{"$f":"IF(ISNUMBER(Q4),TRUE,FALSE)","v":false},null,null,"Period2",{"$f":"IF(LEFT(V4,6)=\"Period\",TRUE,FALSE)","v":true},"Amount2",{"$f":"IF(LEFT(X4,6)=\"Amount\",TRUE,FALSE)","v":true},{"$f":"IF(ISNUMBER(X4),TRUE,FALSE)","v":false}]
["Period3",{"$f":"IF(LEFT(A5,6)=\"Period\",TRUE,FALSE)","v":true},"Amount3",true,{"$f":"IF(ISNUMBER(C5),TRUE,FALSE)","v":false},null,null,"Period3",{"$f":"IF(LEFT(H5,6)=\"Period\",TRUE,FALSE)","v":true},"Amount3",true,{"$f":"IF(ISNUMBER(J5),TRUE,FALSE)","v":false},null,null,"Period3",{"$f":"IF(LEFT(O5,6)=\"Period\",TRUE,FALSE)","v":true},"Amount3",true,{"$f":"IF(ISNUMBER(Q5),TRUE,FALSE)","v":false},null,null,"Period3",{"$f":"IF(LEFT(V5,6)=\"Period\",TRUE,FALSE)","v":true},"Amount3",true,{"$f":"IF(ISNUMBER(X5),TRUE,FALSE)","v":false}]
["Period4",{"$f":"IF(LEFT(A6,6)=\"Period\",TRUE,FALSE)","v":true},"Amount4",true,{"$f":"IF(ISNUMBER(C6),TRUE,FALSE)","v":false},null,null,"Period4",{"$f":"IF(LEFT(H6,6)=\"Period\",TRUE,FALSE)","v":true},"Amount4",true,{"$f":"IF(ISNUMBER(J6),TRUE,FALSE)","v":false},null,null,"Period4",{"$f":"IF(LEFT(O6,6)=\"Period\",TRUE,FALSE)","v":true},"Amount4",true,{"$f":"IF(ISNUMBER(Q6),TRUE,FALSE)","v":false},null,null,"Period4",{"$f":"IF(LEFT(V6,6)=\"Period\",TRUE,FALSE)","v":true},"Amount4",true,{"$f":"IF(ISNUMBER(X6),TRUE,FALSE)","v":false}]
["Period5",{"$f":"IF(LEFT(A7,6)=\"Period\",TRUE,FALSE)","v":true},"Amount5",true,{"$f":"IF(ISNUMBER(C7),TRUE,FALSE)","v":false},null,null,"Period5",{"$f":"IF(LEFT(H7,6)=\"Period\",TRUE,FALSE)","v":true},"Amount5",true,{"$f":"IF(ISNUMBER(J7),TRUE,FALSE)","v":false},null,null,"Period5",{"$f":"IF(LEFT(O7,6)=\"Period\",TRUE,FALSE)","v":true},"Amount5",true,{"$f":"IF(ISNUMBER(Q7),TRUE,FALSE)","v":false},null,null,"Period5",{"$f":"IF(LEFT(V7,6)=\"Period\",TRUE,FALSE)","v":true},"Amount5",true,{"$f":"IF(ISNUMBER(X7),TRUE,FALSE)","v":false}]
["Period6",{"$f":"IF(LEFT(A8,6)=\"Period\",TRUE,FALSE)","v":true},"Amount6",true,{"$f":"IF(ISNUMBER(C8),TRUE,FALSE)","v":false},null,null,"Period6",{"$f":"IF(LEFT(H8,6)=\"Period\",TRUE,FALSE)","v":true},"Amount6",true,{"$f":"IF(ISNUMBER(J8),TRUE,FALSE)","v":false},null,null,"Period6",{"$f":"IF(LEFT(O8,6)=\"Period\",TRUE,FALSE)","v":true},"Amount6",true,{"$f":"IF(ISNUMBER(Q8),TRUE,FALSE)","v":false},null,null,"Period6",{"$f":"IF(LEFT(V8,6)=\"Period\",TRUE,FALSE)","v":true},"Amount6",true,{"$f":"IF(ISNUMBER(X8),TRUE,FALSE)","v":false}]
["Period7",{"$f":"IF(LEFT(A9,6)=\"Period\",TRUE,FALSE)","v":true},"Amount7",true,{"$f":"IF(ISNUMBER(C9),TRUE,FALSE)","v":false},null,null,"Period7",{"$f":"IF(LEFT(H9,6)=\"Period\",TRUE,FALSE)","v":true},"Amount7",true,{"$f":"IF(ISNUMBER(J9),TRUE,FALSE)","v":false},null,null,"Period7",{"$f":"IF(LEFT(O9,6)=\"Period\",TRUE,FALSE)","v":true},"Amount7",true,{"$f":"IF(ISNUMBER(Q9),TRUE,FALSE)","v":false},null,null,"Period7",{"$f":"IF(LEFT(V9,6)=\"Period\",TRUE,FALSE)","v":true},"Amount7",true,{"$f":"IF(ISNUMBER(X9),TRUE,FALSE)","v":false}]
["Period8",{"$f":"IF(LEFT(A10,6)=\"Period\",TRUE,FALSE)","v":true},"Amount8",true,{"$f":"IF(ISNUMBER(C10),TRUE,FALSE)","v":false},null,null,"Period8",{"$f":"IF(LEFT(H10,6)=\"Period\",TRUE,FALSE)","v":true},"Amount8",true,{"$f":"IF(ISNUMBER(J10),TRUE,FALSE)","v":false},null,null,"Period8",{"$f":"IF(LEFT(O10,6)=\"Period\",TRUE,FALSE)","v":true},"Amount8",true,{"$f":"IF(ISNUMBER(Q10),TRUE,FALSE)","v":false},null,null,"Period8",{"$f":"IF(LEFT(V10,6)=\"Period\",TRUE,FALSE)","v":true},"Amount8",true,{"$f":"IF(ISNUMBER(X10),TRUE,FALSE)","v":false}]
["Period9",{"$f":"IF(LEFT(A11,6)=\"Period\",TRUE,FALSE)","v":true},"Amount9",true,{"$f":"IF(ISNUMBER(C11),TRUE,FALSE)","v":false},null,null,"Period9",{"$f":"IF(LEFT(H11,6)=\"Period\",TRUE,FALSE)","v":true},"Amount9",true,{"$f":"IF(ISNUMBER(J11),TRUE,FALSE)","v":false},null,null,"Period9",{"$f":"IF(LEFT(O11,6)=\"Period\",TRUE,FALSE)","v":true},"Amount9",true,{"$f":"IF(ISNUMBER(Q11),TRUE,FALSE)","v":false},null,null,"Period9",{"$f":"IF(LEFT(V11,6)=\"Period\",TRUE,FALSE)","v":true},"Amount9",true,{"$f":"IF(ISNUMBER(X11),TRUE,FALSE)","v":false}]
["Period10",{"$f":"IF(LEFT(A12,6)=\"Period\",TRUE,FALSE)","v":true},"Amount10",true,{"$f":"IF(ISNUMBER(C12),TRUE,FALSE)","v":false},null,null,"Period10",{"$f":"IF(LEFT(H12,6)=\"Period\",TRUE,FALSE)","v":true},"Amount10",true,{"$f":"IF(ISNUMBER(J12),TRUE,FALSE)","v":false},null,null,"Period10",{"$f":"IF(LEFT(O12,6)=\"Period\",TRUE,FALSE)","v":true},"Amount10",true,{"$f":"IF(ISNUMBER(Q12),TRUE,FALSE)","v":false},null,null,"Period10",{"$f":"IF(LEFT(V12,6)=\"Period\",TRUE,FALSE)","v":true},"Amount10",true,{"$f":"IF(ISNUMBER(X12),TRUE,FALSE)","v":false}]
["Period11",{"$f":"IF(LEFT(A13,6)=\"Period\",TRUE,FALSE)","v":true},"Amount11",true,{"$f":"IF(ISNUMBER(C13),TRUE,FALSE)","v":false},null,null,"Period11",{"$f":"IF(LEFT(H13,6)=\"Period\",TRUE,FALSE)","v":true},"Amount11",true,{"$f":"IF(ISNUMBER(J13),TRUE,FALSE)","v":false},null,null,"Period11",{"$f":"IF(LEFT(O13,6)=\"Period\",TRUE,FALSE)","v":true},"Amount11",true,{"$f":"IF(ISNUMBER(Q13),TRUE,FALSE)","v":false},null,null,"Period11",{"$f":"IF(LEFT(V13,6)=\"Period\",TRUE,FALSE)","v":true},"Amount11",true,{"$f":"IF(ISNUMBER(X13),TRUE,FALSE)","v":false}]
["Period12",{"$f":"IF(LEFT(A14,6)=\"Period\",TRUE,FALSE)","v":true},"Amount12",true,{"$f":"IF(ISNUMBER(C14),TRUE,FALSE)","v":false},null,null,"Period12",{"$f":"IF(LEFT(H14,6)=\"Period\",TRUE,FALSE)","v":true},"Amount12",true,{"$f":"IF(ISNUMBER(J14),TRUE,FALSE)","v":false},null,null,"Period12",{"$f":"IF(LEFT(O14,6)=\"Period\",TRUE,FALSE)","v":true},"Amount12",true,{"$f":"IF(ISNUMBER(Q14),TRUE,FALSE)","v":false},null,null,"Period12",{"$f":"IF(LEFT(V14,6)=\"Period\",TRUE,FALSE)","v":true},"Amount12",true,{"$f":"IF(ISNUMBER(X14),TRUE,FALSE)","v":false}]
["Period13",{"$f":"IF(LEFT(A15,6)=\"Period\",TRUE,FALSE)","v":true},"Amount13",true,{"$f":"IF(ISNUMBER(C15),TRUE,FALSE)","v":false},null,null,"Period13",{"$f":"IF(LEFT(H15,6)=\"Period\",TRUE,FALSE)","v":true},"Amount13",true,{"$f":"IF(ISNUMBER(J15),TRUE,FALSE)","v":false},null,null,"Period13",{"$f":"IF(LEFT(O15,6)=\"Period\",TRUE,FALSE)","v":true},"Amount13",true,{"$f":"IF(ISNUMBER(Q15),TRUE,FALSE)","v":false},null,null,"Period13",{"$f":"IF(LEFT(V15,6)=\"Period\",TRUE,FALSE)","v":true},"Amount13",true,{"$f":"IF(ISNUMBER(X15),TRUE,FALSE)","v":false}]
["Period14",{"$f":"IF(LEFT(A16,6)=\"Period\",TRUE,FALSE)","v":true},"Amount14",true,{"$f":"IF(ISNUMBER(C16),TRUE,FALSE)","v":false},null,null,"Period14",{"$f":"IF(LEFT(H16,6)=\"Period\",TRUE,FALSE)","v":true},"Amount14",true,{"$f":"IF(ISNUMBER(J16),TRUE,FALSE)","v":false},null,null,"Period14",{"$f":"IF(LEFT(O16,6)=\"Period\",TRUE,FALSE)","v":true},"Amount14",true,{"$f":"IF(ISNUMBER(Q16),TRUE,FALSE)","v":false},null,null,"Period14",{"$f":"IF(LEFT(V16,6)=\"Period\",TRUE,FALSE)","v":true},"Amount14",true,{"$f":"IF(ISNUMBER(X16),TRUE,FALSE)","v":false}]
["Period15",{"$f":"IF(LEFT(A17,6)=\"Period\",TRUE,FALSE)","v":true},"Amount15",true,{"$f":"IF(ISNUMBER(C17),TRUE,FALSE)","v":false},null,null,"Period15",{"$f":"IF(LEFT(H17,6)=\"Period\",TRUE,FALSE)","v":true},"Amount15",true,{"$f":"IF(ISNUMBER(J17),TRUE,FALSE)","v":false},null,null,"Period15",{"$f":"IF(LEFT(O17,6)=\"Period\",TRUE,FALSE)","v":true},"Amount15",true,{"$f":"IF(ISNUMBER(Q17),TRUE,FALSE)","v":false},null,null,"Period15",{"$f":"IF(LEFT(V17,6)=\"Period\",TRUE,FALSE)","v":true},"Amount15",true,{"$f":"IF(ISNUMBER(X17),TRUE,FALSE)","v":false}]
["Period16",{"$f":"IF(LEFT(A18,6)=\"Period\",TRUE,FALSE)","v":true},"Amount16",true,{"$f":"IF(ISNUMBER(C18),TRUE,FALSE)","v":false},null,null,"Period16",{"$f":"IF(LEFT(H18,6)=\"Period\",TRUE,FALSE)","v":true},"Amount16",true,{"$f":"IF(ISNUMBER(J18),TRUE,FALSE)","v":false},null,null,"Period16",{"$f":"IF(LEFT(O18,6)=\"Period\",TRUE,FALSE)","v":true},"Amount16",true,{"$f":"IF(ISNUMBER(Q18),TRUE,FALSE)","v":false},null,null,"Period16",{"$f":"IF(LEFT(V18,6)=\"Period\",TRUE,FALSE)","v":true},"Amount16",true,{"$f":"IF(ISNUMBER(X18),TRUE,FALSE)","v":false}]
["Period17",{"$f":"IF(LEFT(A19,6)=\"Period\",TRUE,FALSE)","v":true},"Amount17",true,{"$f":"IF(ISNUMBER(C19),TRUE,FALSE)","v":false},null,null,"Period17",{"$f":"IF(LEFT(H19,6)=\"Period\",TRUE,FALSE)","v":true},"Amount17",true,{"$f":"IF(ISNUMBER(J19),TRUE,FALSE)","v":false},null,null,"Period17",{"$f":"IF(LEFT(O19,6)=\"Period\",TRUE,FALSE)","v":true},"Amount17",true,{"$f":"IF(ISNUMBER(Q19),TRUE,FALSE)","v":false},null,null,"Period17",{"$f":"IF(LEFT(V19,6)=\"Period\",TRUE,FALSE)","v":true},"Amount17",true,{"$f":"IF(ISNUMBER(X19),TRUE,FALSE)","v":false}]
["Period18",{"$f":"IF(LEFT(A20,6)=\"Period\",TRUE,FALSE)","v":true},"Amount18",true,{"$f":"IF(ISNUMBER(C20),TRUE,FALSE)","v":false},null,null,"Period18",{"$f":"IF(LEFT(H20,6)=\"Period\",TRUE,FALSE)","v":true},"Amount18",true,{"$f":"IF(ISNUMBER(J20),TRUE,FALSE)","v":false},null,null,"Period18",{"$f":"IF(LEFT(O20,6)=\"Period\",TRUE,FALSE)","v":true},"Amount18",true,{"$f":"IF(ISNUMBER(Q20),TRUE,FALSE)","v":false},null,null,"Period18",{"$f":"IF(LEFT(V20,6)=\"Period\",TRUE,FALSE)","v":true},"Amount18",true,{"$f":"IF(ISNUMBER(X20),TRUE,FALSE)","v":false}]
["Period19",{"$f":"IF(LEFT(A21,6)=\"Period\",TRUE,FALSE)","v":true},"Amount19",true,{"$f":"IF(ISNUMBER(C21),TRUE,FALSE)","v":false},null,null,"Period19",{"$f":"IF(LEFT(H21,6)=\"Period\",TRUE,FALSE)","v":true},"Amount19",true,{"$f":"IF(ISNUMBER(J21),TRUE,FALSE)","v":false},null,null,"Period19",{"$f":"IF(LEFT(O21,6)=\"Period\",TRUE,FALSE)","v":true},"Amount19",true,{"$f":"IF(ISNUMBER(Q21),TRUE,FALSE)","v":false},null,null,"Period19",{"$f":"IF(LEFT(V21,6)=\"Period\",TRUE,FALSE)","v":true},"Amount19",true,{"$f":"IF(ISNUMBER(X21),TRUE,FALSE)","v":false}]
["Period20",{"$f":"IF(LEFT(A22,6)=\"Period\",TRUE,FALSE)","v":true},"Amount20",true,{"$f":"IF(ISNUMBER(C22),TRUE,FALSE)","v":false},null,null,"Period20",{"$f":"IF(LEFT(H22,6)=\"Period\",TRUE,FALSE)","v":true},"Amount20",true,{"$f":"IF(ISNUMBER(J22),TRUE,FALSE)","v":false},null,null,"Period20",{"$f":"IF(LEFT(O22,6)=\"Period\",TRUE,FALSE)","v":true},"Amount20",true,{"$f":"IF(ISNUMBER(Q22),TRUE,FALSE)","v":false},null,null,"Period20",{"$f":"IF(LEFT(V22,6)=\"Period\",TRUE,FALSE)","v":true},"Amount20",true,{"$f":"IF(ISNUMBER(X22),TRUE,FALSE)","v":false}]
[{"$f":"\"TOTAL: \"&A1","v":"TOTAL: Item"},null,{"$f":"SUM(C3:C22)","v":0},null,null,null,null,{"$f":"\"TOTAL: \"&H1","v":"TOTAL: Item"},null,{"$f":"SUM(J3:J22)","v":0},null,null,null,null,{"$f":"\"TOTAL: \"&O1","v":"TOTAL: Item"},null,{"$f":"SUM(Q3:Q22)","v":0},null,null,null,null,{"$f":"\"TOTAL: \"&V1","v":"TOTAL: Item"},null,{"$f":"SUM(X3:X22)","v":0}]
[{"$f":"\"AVERAGE: \"&A1","v":"AVERAGE: Item"},null,{"$f":"IFERROR(SUMIF(E3:E22,TRUE,C3:C22)/COUNTIF(E3:E22,TRUE),\"\")","v":""},null,null,null,null,{"$f":"\"AVERAGE: \"&H1","v":"AVERAGE: Item"},null,{"$f":"IFERROR(SUMIF(L3:L22,TRUE,J3:J22)/COUNTIF(L3:L22,TRUE),\"\")","v":""},null,null,null,null,{"$f":"\"AVERAGE: \"&O1","v":"AVERAGE: Item"},null,{"$f":"IFERROR(SUMIF(S3:S22,TRUE,Q3:Q22)/COUNTIF(S3:S22,TRUE),\"\")","v":""},null,null,null,null,{"$f":"\"AVERAGE: \"&V1","v":"AVERAGE: Item"},null,{"$f":"IFERROR(SUMIF(Z3:Z22,TRUE,X3:X22)/COUNTIF(Z3:Z22,TRUE),\"\")","v":""}]