{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Overall Budget","Budget by Month","Budget by Project Task"],"read":"whole","date_system":"1900"}

{"sheet":"Overall Budget","index":0,"n_rows":27,"n_cols":3,"rows_kept":27,"merged":[[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,0,3,2],[5,0,10,0],[11,0,11,1],[13,0,24,0],[25,0,25,1],[26,0,27,1],[26,2,27,2]]}
["Company Name"]
["Project"]
["Date"]
["Project Manager"]
["Income and Funding","income or funding source","Amount"]
[null,"Income Source 1",{"v":5000,"d":"$5,000"}]
[null,"Income Source 2",{"v":15000,"d":"$15,000"}]
[null,"Income Source 3",{"v":20000,"d":"$20,000"}]
[null,"Funding Source 1",{"v":3000,"d":"$3,000"}]
[null,"Funding Source 2",{"v":2000,"d":"$2,000"}]
[null,"Funding Source 3",{"v":5000,"d":"$5,000"}]
["Total Funding for Project",null,{"$f":"SUM(C6:C11)","v":{"v":50000,"d":"$50,000"}}]
["Expense","type of expense","cost"]
[null,"Labor",{"v":21000,"d":"$21,000"}]
[null,"Labor Benefits",{"v":7000,"d":"$7,000"}]
[null,"Equipment",{"v":8000,"d":"$8,000"}]
[null,"Training",{"v":1000,"d":"$1,000"}]
[null,"Consulting",{"v":1000,"d":"$1,000"}]
[null,"Software",{"v":3000,"d":"$3,000"}]
[null,"Overhead",{"v":1000,"d":"$1,000"}]
[null,"Materials and Supplies",{"v":6000,"d":"$6,000"}]
[null,"Travel",{"v":500,"d":"$500"}]
[null,"Marketing",{"v":1500,"d":"$1,500"}]
[null,"Misc."]
[null,"Misc."]
["Total Project Expense",null,{"$f":"SUM(C14:C24)","v":{"v":50000,"d":"$50,000"}}]
["Total Project Budget",null,{"v":50000,"d":"$50,000"}]

{"sheet":"Budget by Month","index":1,"n_rows":32,"n_cols":27,"rows_kept":32,"merged":[[0,0,0,26],[1,0,1,26],[2,0,2,26],[3,0,3,26],[4,0,4,2],[4,3,4,4],[4,5,4,6],[4,7,4,8],[4,9,4,10],[4,11,4,12],[4,13,4,14],[4,15,4,16],[4,17,4,18],[4,19,4,20],[4,21,4,22],[4,23,4,24],[4,25,4,26],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,2],[15,0,15,2],[16,0,16,2],[16,3,16,4],[16,5,16,6],[16,7,16,8],[16,9,16,10],[16,11,16,12],[16,13,16,14],[16,15,16,16],[16,17,16,18],[16,19,16,20],[16,21,16,22],[16,23,16,24],[16,25,16,26],[17,0,17,2],[17,3,17,4],[17,5,17,6],[17,7,17,8],[17,9,17,10],[17,11,17,12],[17,13,17,14],[17,15,17,16],[17,17,17,18],[17,19,17,20],[17,21,17,22],[17,23,17,24],[17,25,17,26],[18,0,18,2],[18,3,18,4],[18,5,18,6],[18,7,18,8],[18,9,18,10],[18,11,18,12],[18,13,18,14],[18,15,18,16],[18,17,18,18],[18,19,18,20],[18,21,18,22],[18,23,18,24],[18,25,18,26],[19,0,19,2],[19,3,19,4],[19,5,19,6],[19,7,19,8],[19,9,19,10],[19,11,19,12],[19,13,19,14],[19,15,19,16],[19,17,19,18],[19,19,19,20],[19,21,19,22],[19,23,19,24],[19,25,19,26],[20,0,20,2],[20,3,20,4],[20,5,20,6],[20,7,20,8],[20,9,20,10],[20,11,20,12],[20,13,20,14],[20,15,20,16],[20,17,20,18],[20,19,20,20],[20,21,20,22],[20,23,20,24],[20,25,20,26],[21,0,21,2],[21,3,21,4],[21,5,21,6],[21,7,21,8],[21,9,21,10],[21,11,21,12],[21,13,21,14],[21,15,21,16],[21,17,21,18],[21,19,21,20],[21,21,21,22],[21,23,21,24],[21,25,21,26],[22,0,22,2],[22,3,22,4],[22,5,22,6],[22,7,22,8],[22,9,22,10],[22,11,22,12],[22,13,22,14],[22,15,22,16],[22,17,22,18],[22,19,22,20],[22,21,22,22],[22,23,22,24],[22,25,22,26],[23,0,23,2],[23,3,23,4],[23,5,23,6],[23,7,23,8],[23,9,23,10],[23,11,23,12],[23,13,23,14],[23,15,23,16],[23,17,23,18],[23,19,23,20],[23,21,23,22],[23,23,23,24],[23,25,23,26],[24,0,24,2],[24,3,24,4],[24,5,24,6],[24,7,24,8],[24,9,24,10],[24,11,24,12],[24,13,24,14],[24,15,24,16],[24,17,24,18],[24,19,24,20],[24,21,24,22],[24,23,24,24],[24,25,24,26],[25,0,25,2],[25,3,25,4],[25,5,25,6],[25,7,25,8],[25,9,25,10],[25,11,25,12],[25,13,25,14],[25,15,25,16],[25,17,25,18],[25,19,25,20],[25,21,25,22],[25,23,25,24],[25,25,25,26],[26,0,26,2],[26,3,26,4],[26,5,26,6],[26,7,26,8],[26,9,26,10],[26,11,26,12],[26,13,26,14],[26,15,26,16],[26,17,26,18],[26,19,26,20],[26,21,26,22],[26,23,26,24],[26,25,26,26],[27,0,27,2],[27,3,27,4],[27,5,27,6],[27,7,27,8],[27,9,27,10],[27,11,27,12],[27,13,27,14],[27,15,27,16],[27,17,27,18],[27,19,27,20],[27,21,27,22],[27,23,27,24],[27,25,27,26],[28,0,28,2],[28,3,28,4],[28,5,28,6],[28,7,28,8],[28,9,28,10],[28,11,28,12],[28,13,28,14],[28,15,28,16],[28,17,28,18],[28,19,28,20],[28,21,28,22],[28,23,28,24],[28,25,28,26],[29,0,29,2],[29,3,29,4],[29,5,29,6],[29,7,29,8],[29,9,29,10],[29,11,29,12],[29,13,29,14],[29,15,29,16],[29,17,29,18],[29,19,29,20],[29,21,29,22],[29,23,29,24],[29,25,29,26],[30,0,30,2],[30,3,30,4],[30,5,30,6],[30,7,30,8],[30,9,30,10],[30,11,30,12],[30,13,30,14],[30,15,30,16],[30,17,30,18],[30,19,30,20],[30,21,30,22],[30,23,30,24],[30,25,30,26],[31,0,31,2],[31,3,31,4],[31,5,31,6],[31,7,31,8],[31,9,31,10],[31,11,31,12],[31,13,31,14],[31,15,31,16],[31,17,31,18],[31,19,31,20],[31,21,31,22],[31,23,31,24],[31,25,31,26]]}
["Company Name"]
["Project"]
["Date        Project Manager"]
["Budget Costs by Month"]
[{"$nulls":3},"Month 1",null,"Month 2",null,"Month 3",null,"Month 4",null,"Month 5",null,"Month 6",null,"Month 7",null,"Month 8",null,"Month 9",null,"Month 10",null,"Month 11",null,"Month 12"]
["Labor",null,"Day Rate","# Days","Cost","# Days","Cost","# Days","Cost","# Days","Cost","# Days","Cost","# Days","Cost","# Days","Cost","# Days","Cost","# Days","Cost","# Days","Cost","# Days","Cost","# Days","Cost"]
["person 1",{"$nulls":3},{"$f":"PRODUCT(C7,D7)","v":0},null,{"$f":"PRODUCT(C7,F7)","v":0},null,{"$f":"PRODUCT(C7,H7)","v":0},null,{"$f":"PRODUCT(C7,J7)","v":0},null,{"$f":"PRODUCT(C7,L7)","v":0},null,{"$f":"PRODUCT(C7, N7)","v":0},null,{"$f":"PRODUCT(C7, P7)","v":0},null,{"$f":"PRODUCT(C7, R7)","v":0},null,{"$f":"PRODUCT(C7, T7)","v":0},null,{"$f":"PRODUCT(C7,V7)","v":0},null,{"$f":"PRODUCT(C7,X7)","v":0},null,{"$f":"PRODUCT(C7,Z7)","v":0}]
["person 2",{"$nulls":3},{"$f":"PRODUCT(C8,D8)","v":0},null,{"$f":"PRODUCT(C8,F8)","v":0},null,{"$f":"PRODUCT(C8,H8)","v":0},null,{"$f":"PRODUCT(C8,J8)","v":0},null,{"$f":"PRODUCT(C8,L8)","v":0},null,{"$f":"PRODUCT(C8, N8)","v":0},null,{"$f":"PRODUCT(C8, P8)","v":0},null,{"$f":"PRODUCT(C8, R8)","v":0},null,{"$f":"PRODUCT(C8, T8)","v":0},null,{"$f":"PRODUCT(C8,V8)","v":0},null,{"$f":"PRODUCT(C8,X8)","v":0},null,{"$f":"PRODUCT(C8,Z8)","v":0}]
["person 3",{"$nulls":3},{"$f":"PRODUCT(C9,D9)","v":0},null,{"$f":"PRODUCT(C9,F9)","v":0},null,{"$f":"PRODUCT(C9,H9)","v":0},null,0,null,0,null,{"$f":"PRODUCT(C9, N9)","v":0},null,0,null,0,null,0,null,0,null,0,null,0]
["person 4",{"$nulls":3},{"$f":"PRODUCT(C10,D10)","v":0},null,{"$f":"PRODUCT(C10,F10)","v":0},null,{"$f":"PRODUCT(C10,H10)","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["person 5",{"$nulls":3},{"$f":"PRODUCT(C11,D11)","v":0},null,{"$f":"PRODUCT(C11,F11)","v":0},null,{"$f":"PRODUCT(C11,H11)","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["person 6",{"$nulls":3},{"$f":"PRODUCT(C12,D12)","v":0},null,{"$f":"PRODUCT(C12,F12)","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["other",{"$nulls":3},{"$f":"PRODUCT(C13,D13)","v":0},null,{"$f":"PRODUCT(C13,F13)","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["other",{"$nulls":3},{"$f":"PRODUCT(C14,D14)","v":0},null,{"$f":"PRODUCT(C14,F14)","v":0},null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0]
["labor benefits"]
["Labor Totals",null,null,{"$f":"SUM(D7:D14)","v":0},{"$f":"SUM(E7:E15)","v":0},{"$f":"SUM(F7:F14)","v":0},{"$f":"SUM(G7:G15)","v":0},{"$f":"SUM(H7:H14)","v":0},{"$f":"SUM(I7:I15)","v":0},{"$f":"SUM(J7:J14)","v":0},{"$f":"SUM(K7:K15)","v":0},{"$f":"SUM(L7:L14)","v":0},{"$f":"SUM(M7:M15)","v":0},{"$f":"SUM(N7:N14)","v":0},{"$f":"SUM(O7:O15)","v":0},{"$f":"SUM(P7:P14)","v":0},{"$f":"SUM(Q7:Q15)","v":0},{"$f":"SUM(R7:R14)","v":0},{"$f":"SUM(S7:S15)","v":0},{"$f":"SUM(T7:T14)","v":0},{"$f":"SUM(U7:U15)","v":0},{"$f":"SUM(V7:V14)","v":0},{"$f":"SUM(W7:W15)","v":0},{"$f":"SUM(X7:X14)","v":0},{"$f":"SUM(Y7:Y15)","v":0},{"$f":"SUM(Z7:Z14)","v":0},{"$f":"SUM(AA7:AA15)","v":0}]
["equipment and Materials"]
["material 1"]
["material 2"]
["material 3"]
["equipment and Materials Totals",null,null,{"$f":"SUM(E18:E20)","v":0},null,{"$f":"SUM(G18:G20)","v":0},null,{"$f":"SUM(I18:I20)","v":0},null,{"$f":"SUM(K18:K20)","v":0},null,{"$f":"SUM(M18:M20)","v":0},null,{"$f":"SUM(O18:O20)","v":0},null,{"$f":"SUM(Q18:Q20)","v":0},null,{"$f":"SUM(S18:S20)","v":0},null,{"$f":"SUM(U18:U20)","v":0},null,{"$f":"SUM(W18:W20)","v":0},null,{"$f":"SUM(Y18:Y20)","v":0},null,{"$f":"SUM(AA18:AA20)","v":0}]
["training"]
["consulting"]
["software"]
["overhead"]
["travel"]
["marketing"]
["misc."]
["misc."]
[]
["Totals",null,null,{"$f":"SUM(E16,E21:E30)","v":0},null,{"$f":"SUM(G16,G21:G30)","v":0},null,{"$f":"SUM(I16,I21:I30)","v":0},null,{"$f":"SUM(K16,K21:K30)","v":0},null,{"$f":"SUM(M16,M21:M30)","v":0},null,{"$f":"SUM(O16,O21:O30)","v":0},null,{"$f":"SUM(Q16,Q21:Q30)","v":0},null,{"$f":"SUM(S16,S21:S30)","v":0},null,{"$f":"SUM(U16,U21:U30)","v":0},null,{"$f":"SUM(W16,W21:W30)","v":0},null,{"$f":"SUM(Y16,Y21:Y30)","v":0},null,{"$f":"SUM(AA16,AA21:AA30)","v":0}]
["Running Total",null,null,{"$f":"D31","v":0},null,{"$f":"SUM(D32,F31)","v":0},null,{"$f":"SUM(F32,H31)","v":0},null,{"$f":"SUM(H32,J31)","v":0},null,{"$f":"SUM(J32,L31)","v":0},null,{"$f":"SUM(L32,N31)","v":0},null,{"$f":"SUM(N32,P31)","v":0},null,{"$f":"SUM(P32,R31)","v":0},null,{"$f":"SUM(R32,T31)","v":0},null,{"$f":"SUM(T32,V31)","v":0},null,{"$f":"SUM(V32,X31)","v":0},null,{"$f":"SUM(X32,Z31)","v":0}]

{"sheet":"Budget by Project Task","index":2,"n_rows":47,"n_cols":10,"rows_kept":47,"merged":[[0,0,0,8],[1,0,1,8],[2,0,2,8],[3,0,3,8],[5,0,5,8],[13,0,13,8],[21,0,21,8],[28,0,28,8],[35,0,35,8],[44,0,44,1],[45,0,45,1],[46,0,46,1]]}
["Company Name",{"$nulls":8},"*Alternatively could be broken down by project cycle phase, team, WBS number, etc."]
["Project Name"]
["Date Project Manager"]
["Budget by Project Task"]
["Task","Task Description","Labor hours","Labor Cost","Equip/Mat. Cost","Space Cost","Travel Cost","Misc. Cost","Task Total Cost"]
["Milestone 1*"]
["Task 1.1",{"$nulls":7},{"$f":"SUM(D7:H7)","v":0}]
["Task 1.2",{"$nulls":7},{"$f":"SUM(D8:H8)","v":0}]
["Task 1.3",{"$nulls":7},{"$f":"SUM(D9:H9)","v":0}]
["Task 1.4",{"$nulls":7},0]
["Task 1.5",{"$nulls":7},0]
["Task 1.6",{"$nulls":7},0]
["Subtotal Milestone 1",null,{"$f":"SUM(C7:C12)","v":0},{"$f":"SUM(D7:D12)","v":0},{"$f":"SUM(E7:E12)","v":0},{"$f":"SUM(F7:F12)","v":0},{"$f":"SUM(G7:G12)","v":0},{"$f":"SUM(H7:H12)","v":0},0]
["Milestone 2"]
["Task 2.1",{"$nulls":7},{"$f":"SUM(D15:H15)","v":0}]
["Task 2.2",{"$nulls":7},{"$f":"SUM(D16:H16)","v":0}]
["Task 2.3",{"$nulls":7},0]
["Task 2.4",{"$nulls":7},0]
["Task 2.5",{"$nulls":7},0]
["Task 2.6",{"$nulls":7},0]
["Subtotal Milestone 2",null,{"$f":"SUM(C15:C20)","v":0},{"$f":"SUM(D15:D20)","v":0},{"$f":"SUM(E15:E20)","v":0},{"$f":"SUM(F15:F20)","v":0},{"$f":"SUM(G15:G20)","v":0},{"$f":"SUM(H15:H20)","v":0},0]
["Milestone 3"]
["Task 3.1",{"$nulls":7},{"$f":"SUM(D23:H23)","v":0}]
["Task 3.2",{"$nulls":7},0]
["Task 3.3",{"$nulls":7},0]
["Task 3.4",{"$nulls":7},0]
["Task 3.5",{"$nulls":7},0]
["Subtotal Milestone 3",null,{"$f":"SUM(C23:C27)","v":0},{"$f":"SUM(D23:D27)","v":0},{"$f":"SUM(E23:E27)","v":0},{"$f":"SUM(F23:F27)","v":0},{"$f":"SUM(G23:G27)","v":0},{"$f":"SUM(H23:H27)","v":0},0]
["Milestone 4"]
["Task 4.1",{"$nulls":7},{"$f":"SUM(D30:H30)","v":0}]
["Task 4.2",{"$nulls":7},0]
["Task 4.3",{"$nulls":7},0]
["Task 4.4",{"$nulls":7},0]
["Task 4.5",{"$nulls":7},0]
["Subtotal Milestone 4",null,{"$f":"SUM(C30:C34)","v":0},{"$f":"SUM(D30:D34)","v":0},{"$f":"SUM(E30:E34)","v":0},0,0,0,0]
["Milestone 5"]
["Task 5.1",{"$nulls":7},{"$f":"SUM(D37:H37)","v":0}]
["Task 5.2",{"$nulls":7},0]
["task 5.3",{"$nulls":7},0]
["task 5.4",{"$nulls":7},0]
["tasl 5.5",{"$nulls":7},0]
["Subtotal Milestone 5",null,{"$f":"SUM(C37:C41)","v":0},0,0,0,0,0,0]
["Other Cost 1",{"$nulls":7},0]
["Other Cost 2",{"$nulls":7},0]
["Subtotals",null,{"$f":"SUM(C13,C21,C28,C35,C42,C43,C44)","v":0},{"$f":"SUM(D13,D21,D28,D35,D42,D43,D44)","v":0},0,0,0,0,0]
["Risk Cushion",{"$nulls":7},0]
["Total",null,{"$f":"SUM(C45,C46)","v":0},{"$f":"SUM(D45,D46)","v":0},0,0,0,0,0]