{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Budget","Lists","Cost Item Table example"],"not_rendered":{"images":1,"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Budget","index":0,"n_rows":54,"n_cols":6,"rows_kept":54,"merged":[[46,1,46,5],[47,1,47,5],[48,1,48,5],[49,1,49,5],[50,1,50,5],[51,1,51,5],[52,1,52,5],[53,1,53,5]]}
["Organisation Name"]
["Budget for: April 202X - March 202X"]
[]
[null,"Year 1","Year 2","Year 3",null,"Total over 3 years"]
["Income"]
["Foundation North (this application)",{"v":100000,"d":"$100,000"},{"v":100000,"d":"$100,000"},{"v":100000,"d":"$100,000"},null,{"$f":"B6+C6+D6","v":{"v":300000,"d":"$300,000"}}]
["Lottery Community (unconfirmed)",{"v":70000,"d":"$70,000"},{"v":70000,"d":"$70,000"},{"v":70000,"d":"$70,000"},null,{"$f":"B7+C7+D7","v":{"v":210000,"d":"$210,000"}}]
["XZY Foundation (unconfirmed)",{"v":40000,"d":"$40,000"},{"v":40000,"d":"$40,000"},{"v":40000,"d":"$40,000"},null,{"$f":"B8+C8+D8","v":{"v":120000,"d":"$120,000"}}]
["COGS (confirmed)",{"v":5000,"d":"$5,000"},{"v":5000,"d":"$5,000"},{"v":5000,"d":"$5,000"},null,{"$f":"B9+C9+D9","v":{"v":15000,"d":"$15,000"}}]
["Other gaming Charity (confirmed)",{"v":15000,"d":"$15,000"},0,0,null,{"v":15000,"d":"$15,000"}]
["Donations (estimated)",{"v":20000,"d":"$20,000"},{"v":21000,"d":"$21,000"},{"v":22000,"d":"$22,000"},null,{"$f":"B11+C11+D11","v":{"v":63000,"d":"$63,000"}}]
["Gala fundraiser (estimated) *1",{"v":30000,"d":"$30,000"},null,{"v":40000,"d":"$40,000"},null,{"$f":"B12+C12+D12","v":{"v":70000,"d":"$70,000"}}]
[{"$nulls":5},{"$f":"B13+C13+D13","v":0}]
["Total Income",{"$f":"SUM(B6:B13)","v":{"v":280000,"d":"$280,000"}},{"v":236000,"d":"$236,000"},{"$f":"SUM(D6:D13)","v":{"v":277000,"d":"$277,000"}},null,{"$f":"SUM(F6:F13)","v":{"v":793000,"d":"$793,000"}}]
[]
["Operating costs",{"$nulls":4},"Column1"]
["Management salary",{"v":75000,"d":"$75,000"},{"v":77500,"d":"$77,500"},{"v":80000,"d":"$80,000"},null,{"$f":"B17+C17+D17","v":{"v":232500,"d":"$232,500"}}]
["Administration salary",{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},null,{"$f":"B18+C18+D18","v":{"v":150000,"d":"$150,000"}}]
["Office rent",{"v":25000,"d":"$25,000"},{"v":25000,"d":"$25,000"},{"v":25000,"d":"$25,000"},null,{"$f":"B19+C19+D19","v":{"v":75000,"d":"$75,000"}}]
["Cleaning",{"v":5000,"d":"$5,000"},{"v":5000,"d":"$5,000"},{"v":5000,"d":"$5,000"},null,{"$f":"B20+C20+D20","v":{"v":15000,"d":"$15,000"}}]
["Utilities (power, internet, insurance)",{"v":4000,"d":"$4,000"},{"v":4250,"d":"$4,250"},{"v":4500,"d":"$4,500"},null,{"$f":"B21+C21+D21","v":{"v":12750,"d":"$12,750"}}]
[{"$nulls":5},{"$f":"B22+C22+D22","v":0}]
[{"$f":"\"Total \"&A16","v":"Total Operating costs"},{"$f":"SUM(B17:B22)","v":{"v":159000,"d":"$159,000"}},{"$f":"SUM(C17:C22)","v":{"v":161750,"d":"$161,750"}},{"$f":"SUM(D17:D22)","v":{"v":164500,"d":"$164,500"}},null,{"$f":"SUM(F17:F22)","v":{"v":485250,"d":"$485,250"}}]
[]
["Programme costs",{"$nulls":4},"Column1"]
["Programme Facilitator salary",{"v":35000,"d":"$35,000"},{"v":37500,"d":"$37,500"},{"v":40000,"d":"$40,000"},null,{"$f":"B26+C26+D26","v":{"v":112500,"d":"$112,500"}}]
["Van Lease (see quote attached)",{"v":8000,"d":"$8,000"},{"v":8000,"d":"$8,000"},{"v":8000,"d":"$8,000"},null,{"$f":"B27+C27+D27","v":{"v":24000,"d":"$24,000"}}]
["Travel costs (insurance, petrol, car maintenance etc)",{"v":3000,"d":"$3,000"},{"v":3000,"d":"$3,000"},{"v":3000,"d":"$3,000"},null,{"$f":"B28+C28+D28","v":{"v":9000,"d":"$9,000"}}]
["Programme costs - kai, volunteer koha, etc",{"v":2500,"d":"$2,500"},{"v":3000,"d":"$3,000"},{"v":3500,"d":"$3,500"},null,{"$f":"B29+C29+D29","v":{"v":9000,"d":"$9,000"}}]
[{"$nulls":5},{"$f":"B30+C30+D30","v":0}]
[{"$f":"\"Total \"&A25","v":"Total Programme costs"},{"$f":"SUM(B26:B30)","v":{"v":48500,"d":"$48,500"}},{"$f":"SUM(C26:C30)","v":{"v":51500,"d":"$51,500"}},{"$f":"SUM(D26:D30)","v":{"v":54500,"d":"$54,500"}},null,{"$f":"SUM(F26:F30)","v":{"v":154500,"d":"$154,500"}}]
[]
["Capacity and capability costs",{"$nulls":4},"Column1"]
["Strategy Wānanga",{"v":20000,"d":"$20,000"},0,{"v":20000,"d":"$20,000"},null,{"$f":"B34+C34+D34","v":{"v":40000,"d":"$40,000"}}]
["Professional Development",{"v":10000,"d":"$10,000"},{"v":10000,"d":"$10,000"},{"v":10000,"d":"$10,000"},null,{"$f":"B35+C35+D35","v":{"v":30000,"d":"$30,000"}}]
["Social Enterprise Research",{"v":20000,"d":"$20,000"},{"v":20000,"d":"$20,000"},{"v":10000,"d":"$10,000"},null,{"$f":"B36+C36+D36","v":{"v":50000,"d":"$50,000"}}]
["Social Enterprise Seeding",0,null,{"v":20000,"d":"$20,000"},null,{"$f":"B37+C37+D37","v":{"v":20000,"d":"$20,000"}}]
["New website",{"v":20000,"d":"$20,000"},0,0,null,{"$f":"B38+C38+D38","v":{"v":20000,"d":"$20,000"}}]
[{"$nulls":5},{"$f":"B39+C39+D39","v":0}]
[{"$f":"\"Total \"&A33","v":"Total Capacity and capability costs"},{"$f":"SUM(B34:B39)","v":{"v":70000,"d":"$70,000"}},{"$f":"SUM(C34:C39)","v":{"v":30000,"d":"$30,000"}},{"$f":"SUM(D34:D39)","v":{"v":60000,"d":"$60,000"}},null,{"$f":"SUM(F34:F39)","v":{"v":160000,"d":"$160,000"}}]
[]
[]
["Total Expenses",{"$f":"B40+B31+B23","v":{"v":277500,"d":"$277,500"}},{"$f":"C40+C31+C23","v":{"v":243250,"d":"$243,250"}},{"v":279000,"d":"$279,000"},null,{"$f":"F40+F31+F23","v":{"v":799750,"d":"$799,750"}}]
[]
["Net profit (loss)",{"$f":"B14-B43","v":{"v":2500,"d":"$2,500"}},{"$f":"C14-C43","v":{"v":-7250,"d":"$(7,250)"}},{"$f":"D14-D43","v":{"v":-2000,"d":"$(2,000)"}},null,{"$f":"F14-F43","v":{"v":-6750,"d":"$(6,750)"}}]
[]
["Notes (*)","Description"]
[1,"The Gala is only held every second year. Run to fund our strategy wānanga and special projects in those years"]
[2]
[3]
[4]
[5]
[6]
[7]

{"sheet":"Lists","index":1,"n_rows":6,"n_cols":1,"rows_kept":6}
[]
["Operating costs"]
["Programme costs"]
["Project costs"]
["Equipment"]
["Capacity and capability costs"]

{"sheet":"Cost Item Table example","index":2,"n_rows":34,"n_cols":8,"rows_kept":34,"merged":[[1,7,2,7],[7,7,8,7],[15,7,16,7],[19,7,20,7],[23,7,24,7]]}
[]
[null,"Cost Items",{"$nulls":5},"Click the green plus to add a new Cost Item line below"]
[]
[{"$nulls":4},"Edit"]
[null,"Cost Item","Desciption of Item","Total Cost","Foundation North Requested"]
[null,"Operating Costs","Year 1",{"$f":"Budget!B23","v":{"v":159000,"d":"$159,000"}},"Enter how much you are requesting towards this..."]
[]
[{"$nulls":4},"Edit",null,null,"Click the blue edit link to change the Cost Item line"]
[null,"Cost Item","Desciption of Item","Total Cost","Foundation North Requested"]
[null,"Operating Costs","Year 2",{"$f":"Budget!C23","v":{"v":161750,"d":"$161,750"}},"Enter how much you are requesting towards this..."]
[]
[{"$nulls":4},"Edit"]
[null,"Cost Item","Desciption of Item","Total Cost","Foundation North Requested"]
[null,"Operating Costs","Year 3",{"$f":"Budget!D23","v":{"v":164500,"d":"$164,500"}},"Enter how much you are requesting towards this..."]
[]
[{"$nulls":4},"Edit"]
[null,"Cost Item","Desciption of Item","Total Cost","Foundation North Requested"]
[null,"Programme Costs","Year 1",{"$f":"Budget!B31","v":{"v":48500,"d":"$48,500"}},"Enter how much you are requesting towards this..."]
[]
[{"$nulls":4},"Edit"]
[null,"Cost Item","Desciption of Item","Total Cost","Foundation North Requested"]
[null,"Programme Costs","Year 2",{"$f":"Budget!C31","v":{"v":51500,"d":"$51,500"}},"Enter how much you are requesting towards this..."]
[]
[{"$nulls":4},"Edit"]
[null,"Cost Item","Desciption of Item","Total Cost","Foundation North Requested"]
[null,"Programme Costs","Year 3",{"$f":"Budget!D31","v":{"v":54500,"d":"$54,500"}},"Enter how much you are requesting towards this..."]
[]
[{"$nulls":4},"Edit"]
[null,"Cost Item","Desciption of Item","Total Cost","Foundation North Requested"]
[null,"Capacity and Capability","New website in Year 1",{"$f":"Budget!B38","v":{"v":20000,"d":"$20,000"}},"Enter how much you are requesting towards this..."]
[]
[]
[]
[null,"This is the type of expense - select from the Drop Down options in the funding hub.","Enter the Year this line relates too - you must have a line for each year you are requesting a cost for. (Its OK to request a mixture of one year and multi-year items)","This is the total of the type of expense from your budget. (These values have been copied from your budget in the first tab!)","Tell us how much you are requesting from Foundation North towards each expense type."]