{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Event Budget Summary","Breakdown 1","Float Spend","Costings 1","Crew Costs","Crew Accommodation","Crew Catering","PDs & Petty Cash","Passes & Radios"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":6,"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":"1904"}

{"sheet":"Event Budget Summary","index":0,"n_rows":137,"n_cols":13,"rows_kept":137,"cut":false,"hidden":false,"merged":[[12,0,12,2],[13,0,13,2],[14,0,14,2],[0,1,0,2],[2,1,2,2],[6,1,6,2],[4,1,4,2],[9,0,9,2],[11,0,11,2],[27,5,27,7],[69,0,78,0],[121,0,130,0],[43,0,52,0],[56,0,65,0],[82,0,91,0],[95,0,104,0],[108,0,117,0],[30,0,39,0],[23,0,23,1],[21,1,22,2],[15,0,15,2],[16,0,16,2],[17,0,17,2],[18,0,18,2]]}
["Project Title","Substance"]
[]
["Show Date","6th November 2016"]
[]
["Project Manager","Martin Atkinson"]
[]
["Client","Hull 2017"]
[]
[]
["EVENT BUDGET",null,null,{"$f":"G17","v":4000}]
[null,null,null,"Predicted","Current Spend",null,"Income","Source"]
["Artist Fees",null,null,{"$f":"D41","v":1775},{"$f":"E41","v":1775},null,4000,"Hull2017 Allocated"]
["Technical Hires",null,null,{"$f":"D54","v":1200},{"$f":"E54","v":1290.9000000000001}]
["Rider",null,null,{"$f":"D67","v":400},{"$f":"E67","v":368.54830000000004}]
["Venue Hires",null,null,{"$f":"D80","v":45},{"$f":"E80","v":37.5}]
["Crew",null,null,{"$f":"D93","v":220},{"$f":"E93","v":300}]
["Accomodation",null,null,{"$f":"D106","v":64},{"$f":"E106","v":64.16},null,{"$f":"SUM(G12:G15)","v":4000}]
["Travel",null,null,{"$f":"D119","v":179},{"$f":"E119","v":149.16}]
["H",null,null,{"$f":"D132","v":0},{"$f":"E132","v":0}]
[]
[null,null,null,{"$f":"SUM(D12:D19)","v":3883},{"$f":"SUM(E12:E19)","v":3985.2682999999997}]
[null,"Spreadsheet Checker",null,{"$f":"SUM((SUM(D30:D40))+(SUM(D43:D53))+(SUM(D56:D66))+(SUM(D69:D79))+(SUM(D82:D92))+(SUM(D95:D105))+(SUM(D108:D118))+(SUM(D121:D131)))","v":3883},{"$f":"SUM((SUM(E30:E40))+(SUM(E43:E53))+(SUM(E56:E66))+(SUM(E69:E79))+(SUM(E82:E92))+(SUM(E95:E105))+(SUM(E108:E118))+(SUM(E121:E131)))","v":3985.2682999999997}]
[null,null,null,{"$f":"IF(D21-D22=0, \"Good\", \"Bad\")","v":"Good"},{"$f":"IF(E21-E22=0, \"Good\", \"Bad\")","v":"Good"}]
["Contribution to Core Costs inc Admin & Insurance",null,0,{"$f":"SUM(D10)*C24","v":0}]
["Total Budget Costs",null,null,{"$f":"SUM(D12:D19)","v":3883}]
["Overall Contingency",null,0,{"$f":"D10*C26","v":0}]
[]
["OVER / UNDER BUDGET",null,null,{"$f":"D10-D21-D26","v":117},{"$f":"D10-E135","v":14.731700000000274},"Will turn red if over budget!"]
[]
["DEPARTMENT","ITEM","SUPPLIER","BUDGET","ACTUAL NET","VAT","GROSS","NOTES","Receipt No","Invoice No","Signoff Date","Paid Date"]
[{"$f":"A12","v":"Artist Fees"},"The Magnetic North",null,1400,1400,0,{"$f":"E31+F31","v":1400}]
[null,"Will Alsop",null,375,375,0,375,null,null,null,null,null,"750 in total but 375 going towards article."]
[null,"Guest 2?",null,null,null,{"$f":"E33*0.2","v":0},0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,{"$f":"SUM(D31:D40)","v":1775},{"$f":"SUM(E31:E40)","v":1775}]
[]
["DEPARTMENT","ITEM","SUPPLIER","BUDGET","ACTUAL NET","VAT","GROSS","NOTES","Receipt No","Invoice No","Signoff Date","Paid Date"]
[{"$f":"A13","v":"Technical Hires"},"Sound Additionals/Mac Hire/Board Upgrade","ITSL",1050,{"$f":"750+540.9","v":1290.9000000000001},{"$f":"E44*0.2","v":258.18},{"$f":"E44+F44","v":1549.0800000000002}]
[null,null,null,null,null,{"$f":"E45*0.2","v":0},{"$f":"E45+F45","v":0}]
[null,"Stage Extension","ITSL",150,null,0,0,"incuded in Sound additionals ITSL"]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,{"$f":"SUM(D44:D53)","v":1200},{"$f":"SUM(E44:E53)","v":1290.9000000000001}]
[]
["DEPARTMENT",null,"SUPPLIER","BUDGET","ACTUAL NET","VAT","GROSS","NOTES","Receipt No","Invoice No","Signoff Date","Paid Date"]
[{"$f":"A14","v":"Rider"},"TMN Rider","various",150,45.17,{"$f":"E57*0.2","v":9.0340000000000007},{"$f":"E57+F57","v":54.204000000000001}]
[null,null,null,null,182.20830000000001,{"$f":"E58*0.2","v":36.441660000000006},{"$f":"E58+F58","v":218.64996000000002}]
[null,"VIP Hospitality",null,250,141.16999999999999,28.233999999999998,169.404]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,{"$f":"SUM(D57:D66)","v":400},{"$f":"SUM(E57:E66)","v":368.54830000000004}]
[]
["DEPARTMENT","ITEM","SUPPLIER","BUDGET","ACTUAL NET","VAT","GROSS","NOTES","Receipt No","Invoice No","Signoff Date","Paid Date"]
[{"$f":"A15","v":"Venue Hires"},"Venue Hire","The Polar Bear",null,null,{"$f":"E70*0.2","v":0},{"$f":"E70+F70","v":0}]
[null,null,null,null,null,{"$f":"E71*0.2","v":0},{"$f":"E71+F71","v":0}]
[null,"Greenroom","Marlborough Arms",45,37.5,7.5,45]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,{"$f":"SUM(D70:D79)","v":45},{"$f":"SUM(E70:E79)","v":37.5}]
[]
["DEPARTMENT","ITEM","SUPPLIER","BUDGET","ACTUAL NET","VAT","GROSS","NOTES","Receipt No","Invoice No","Signoff Date","Paid Date"]
[{"$f":"A16","v":"Crew"},"Tech Included with ITSL",null,null,null,{"$f":"E83*0.2","v":0},{"$f":"E83+F83","v":0}]
[null,null,null,null,null,0,0]
[null,"Security",null,100,180,36,216]
[null,null,null,null,null,0,0]
[null,"DJ",null,120,120,24,120]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,{"$f":"SUM(D83:D92)","v":220},{"$f":"SUM(E83:E92)","v":300}]
[]
["DEPARTMENT","ITEM","SUPPLIER","BUDGET","ACTUAL NET","VAT","GROSS","NOTES","Receipt No","Invoice No","Signoff Date","Paid Date"]
[{"$f":"A17","v":"Accomodation"},"Will Alsop",null,64,64.16,{"$f":"E96*0.2","v":12.832000000000001},{"$f":"F96+E96","v":76.99199999999999}]
[null,null,null,null,null,{"$f":"E97*0.2","v":0},{"$f":"F97+E97","v":0}]
[null,null,null,null,null,0,{"$f":"F98+E98","v":0}]
[null,null,null,null,null,0,{"$f":"F99+E99","v":0}]
[null,null,null,null,null,0,{"$f":"F100+E100","v":0}]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,{"$f":"SUM(D96:D105)","v":64},{"$f":"SUM(E96:E105)","v":64.16}]
[]
["DEPARTMENT","ITEM","SUPPLIER","BUDGET","ACTUAL NET","VAT","GROSS","NOTES","Receipt No","Invoice No","Signoff Date","Paid Date"]
[{"$f":"A18","v":"Travel"},"Will Alsop Travel",null,179,149.16,{"$f":"E109*0.2","v":29.832000000000001},{"$f":"E109+F109","v":178.99199999999999}]
[null,null,null,null,null,{"$f":"E110*0.2","v":0},{"$f":"E110+F110","v":0}]
[null,null,null,null,null,{"$f":"E111*0.2","v":0},0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,{"$f":"SUM(D109:D118)","v":179},{"$f":"SUM(E109:E118)","v":149.16}]
[]
["DEPARTMENT","ITEM","SUPPLIER","BUDGET","ACTUAL NET","VAT","GROSS","NOTES","Receipt No","Invoice No","Signoff Date","Paid Date"]
[{"$f":"A19","v":"H"},null,null,null,null,{"$f":"E122*0.2","v":0},{"$f":"E122*F122","v":0}]
[null,null,null,null,null,{"$f":"E123*0.2","v":0},{"$f":"E123*F123","v":0}]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,{"$f":"SUM(D122:D131)","v":0},{"$f":"SUM(E122:E131)","v":0}]
[]
[]
[null,null,"TOTAL BUDGET COSTS: ",{"$f":"SUM(D41+D54+D67+D80+D93+D106+D119+D132)","v":3883},{"$f":"SUM(E41+E54+E67+E80+E93+E106+E119+E132)","v":3985.2682999999997}]
[]
[null,null,"Over/Under Budget",{"$f":"D28","v":117}]

{"sheet":"Breakdown 1","index":1,"n_rows":133,"n_cols":12,"rows_kept":133,"cut":false,"hidden":false,"merged":[[13,0,13,2],[14,0,14,2],[104,0,113,0],[12,0,12,2],[117,0,126,0],[15,0,15,2],[26,0,35,0],[39,0,48,0],[52,0,61,0],[65,0,74,0],[78,0,87,0],[16,0,16,2],[91,0,100,0],[19,1,20,2],[11,0,11,2],[10,0,10,2],[0,1,0,2],[2,1,2,2],[4,1,4,2],[7,0,7,2],[9,0,9,2]]}
["Show Date",{"$f":"'Event Budget Summary'!B3:C3","v":"6th November 2016"}]
[]
["Project Manager",{"$f":"'Event Budget Summary'!B5:C5","v":"Martin Atkinson"}]
[]
["Client",{"$f":"'Event Budget Summary'!B7:C7","v":"Hull 2017"}]
[]
[]
["BREAKDOWN 1",null,null,null,{"$f":"D8","v":0},null,{"$f":"E8*1.2","v":0}]
[null,null,null,"Predicted",null,null,"Current Spend"]
["A",null,null,{"$f":"D36","v":0},{"$f":"E36","v":0},{"$f":"F36","v":0},{"$f":"G36","v":0}]
["B",null,null,{"$f":"D44","v":0},{"$f":"E44","v":0},{"$f":"F44","v":0},{"$f":"G44","v":0}]
["C",null,null,{"$f":"D49","v":0},{"$f":"E49","v":0},{"$f":"F49","v":0},{"$f":"G49","v":0}]
["D",null,null,{"$f":"D61","v":0},{"$f":"E61","v":0},{"$f":"F61","v":0},{"$f":"G61","v":0}]
["E",null,null,{"$f":"D73","v":0},{"$f":"E73","v":0},{"$f":"F73","v":0},{"$f":"G73","v":0}]
["F",null,null,{"$f":"D83","v":0},{"$f":"E83","v":0},{"$f":"F83","v":0},{"$f":"G83","v":0}]
["G",null,null,{"$f":"D97","v":0},{"$f":"E97","v":0},{"$f":"F97","v":0},{"$f":"G97","v":0}]
["H",null,null,{"$f":"D109","v":0},{"$f":"E109","v":0},{"$f":"F109","v":0},{"$f":"G109","v":0}]
[]
[null,null,null,{"$f":"SUM(D10:D17)","v":0},{"$f":"SUM(E10:E17)","v":0},{"$f":"SUM(F10:F17)","v":0},{"$f":"SUM(G10:G17)","v":0}]
[null,"Spreadsheet Checker",null,{"$f":"SUM(D27:D36)+SUM(D40:D49)+SUM(D53:D62)+SUM(D66:D75)+SUM(D79:D88)+SUM(D92:D101)+SUM(D105:D114)+SUM(D118:D127)","v":0},{"$f":"SUM(E27:E36)+SUM(E40:E49)+SUM(E53:E62)+SUM(E66:E75)+SUM(E79:E88)+SUM(E92:E101)+SUM(E105:E114)+SUM(E118:E127)","v":0},{"$f":"SUM(F27:F36)+SUM(F40:F49)+SUM(F53:F62)+SUM(F66:F75)+SUM(F79:F88)+SUM(F92:F101)+SUM(F105:F114)+SUM(F118:F127)","v":0},{"$f":"SUM(G27:G36)+SUM(G40:G49)+SUM(G53:G62)+SUM(G66:G75)+SUM(G79:G88)+SUM(G92:G101)+SUM(G105:G114)+SUM(G118:G127)","v":0}]
[null,null,null,{"$f":"IF(D19-D20=0, \"Good\", \"Bad\")","v":"Good"},{"$f":"IF(E19-E20=0, \"Good\", \"Bad\")","v":"Good"},{"$f":"IF(F19-F20=0, \"Good\", \"Bad\")","v":"Good"},{"$f":"IF(G19-G20=0, \"Good\", \"Bad\")","v":"Good"}]
["Overall Contingency",null,0,{"$f":"SUM(D8)*C22","v":0}]
[]
["OVER / UNDER BUDGET",null,null,{"$f":"SUM(D8-D19-D22)","v":0},{"$f":"SUM(E8-E19-E22)","v":0},null,{"$f":"SUM(G8-G19-G22)","v":0},"Will turn red if over budget!"]
[]
["DEPARTMENT","ITEM","SUPPLIER","BUDGET","ACTUAL NET","VAT","GROSS","NOTES","Receipt No","Invoice No","Signoff Date","Paid Date"]
[{"$f":"A10","v":"A"},null,null,null,null,{"$f":"E27*0.2","v":0},{"$f":"E27+F27","v":0}]
[null,null,null,null,null,{"$f":"E28*0.2","v":0},{"$f":"E28+F28","v":0}]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,{"$f":"SUM(D27:D36)","v":0},{"$f":"SUM(E27:E36)","v":0}]
[]
["DEPARTMENT","ITEM","SUPPLIER","BUDGET","ACTUAL NET","VAT","GROSS","NOTES","Receipt No","Invoice No","Signoff Date","Paid Date"]
[{"$f":"A11","v":"B"},null,null,null,null,{"$f":"E40*0.2","v":0},{"$f":"E40+F40","v":0}]
[null,null,null,null,null,{"$f":"E41*0.2","v":0},{"$f":"E41+F41","v":0}]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,{"$f":"SUM(D40:D49)","v":0},{"$f":"SUM(E40:E49)","v":0}]
[]
["DEPARTMENT",null,"SUPPLIER","BUDGET","ACTUAL NET","VAT","GROSS","NOTES","Receipt No","Invoice No","Signoff Date","Paid Date"]
[{"$f":"A12","v":"C"},null,null,null,null,{"$f":"E53*0.2","v":0},{"$f":"E53+F53","v":0}]
[null,null,null,null,null,{"$f":"E54*0.2","v":0},{"$f":"E54+F54","v":0}]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,{"$f":"SUM(D53:D62)","v":0},{"$f":"SUM(E53:E62)","v":0}]
[]
["DEPARTMENT","ITEM","SUPPLIER","BUDGET","ACTUAL NET","VAT","GROSS","NOTES","Receipt No","Invoice No","Signoff Date","Paid Date"]
[{"$f":"A13","v":"D"},null,null,null,null,{"$f":"E66*0.2","v":0},{"$f":"E66+F66","v":0}]
[null,null,null,null,null,{"$f":"E67*0.2","v":0},{"$f":"E67+F67","v":0}]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,{"$f":"SUM(D66:D75)","v":0},{"$f":"SUM(E66:E75)","v":0}]
[]
["DEPARTMENT","ITEM","SUPPLIER","BUDGET","ACTUAL NET","VAT","GROSS","NOTES","Receipt No","Invoice No","Signoff Date","Paid Date"]
[{"$f":"A14","v":"E"},null,null,null,null,{"$f":"E79*0.2","v":0},{"$f":"E79+F79","v":0}]
[null,null,null,null,null,0,{"$f":"E80+F80","v":0}]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,{"$f":"SUM(D79:D88)","v":0},{"$f":"SUM(E79:E88)","v":0}]
[]
["DEPARTMENT","ITEM","SUPPLIER","BUDGET","ACTUAL NET","VAT","GROSS","NOTES","Receipt No","Invoice No","Signoff Date","Paid Date"]
[{"$f":"A15","v":"F"},null,null,null,null,{"$f":"E92*0.2","v":0},{"$f":"F92+E92","v":0}]
[null,null,null,null,null,{"$f":"E93*0.2","v":0},{"$f":"F93+E93","v":0}]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,{"$f":"SUM(D92:D101)","v":0},{"$f":"SUM(E92:E101)","v":0}]
[]
["DEPARTMENT","ITEM","SUPPLIER","BUDGET","ACTUAL NET","VAT","GROSS","NOTES","Receipt No","Invoice No","Signoff Date","Paid Date"]
[{"$f":"A16","v":"G"},null,null,null,null,{"$f":"E105*0.2","v":0},{"$f":"E105+F105","v":0}]
[null,null,null,null,null,{"$f":"E106*0.2","v":0},{"$f":"E106+F106","v":0}]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,{"$f":"SUM(D105:D114)","v":0},{"$f":"SUM(E105:E114)","v":0}]
[]
["DEPARTMENT","ITEM","SUPPLIER","BUDGET","ACTUAL NET","VAT","GROSS","NOTES","Receipt No","Invoice No","Signoff Date","Paid Date"]
[{"$f":"A17","v":"H"},null,null,null,null,{"$f":"E118*0.2","v":0},{"$f":"E118*F118","v":0}]
[null,null,null,null,null,{"$f":"E119*0.2","v":0},{"$f":"E119*F119","v":0}]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,{"$f":"SUM(D118:D127)","v":0},{"$f":"SUM(E118:E127)","v":0}]
[]
[]
[null,null,"TOTAL BUDGET COSTS: ",{"$f":"SUM(D37+D50+D63+D76+D89+D102+D115+D128)","v":0},{"$f":"SUM(E37+E50+E63+E76+E89+E102+E115+E128)","v":0}]
[]
[null,null,"Over/Under Budget",{"$f":"D24","v":0}]

{"sheet":"Float Spend","index":2,"n_rows":130,"n_cols":8,"rows_kept":130,"cut":false,"hidden":false,"merged":[[116,0,125,0],[38,0,47,0],[51,0,60,0],[64,0,73,0],[77,0,86,0],[90,0,99,0],[103,0,112,0],[0,1,0,2],[2,1,2,2],[4,1,4,2],[19,1,20,2],[25,0,34,0],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1]]}
["Show Date",{"$f":"'Event Budget Summary'!B3:C3","v":"6th November 2016"}]
[]
["Project Manager",{"$f":"'Event Budget Summary'!B5:C5","v":"Martin Atkinson"}]
[]
["Client",{"$f":"'Event Budget Summary'!B7:C7","v":"Hull 2017"}]
[]
[]
["FLOAT SPEND",null,{"$f":"SUM(C10:C17)","v":0},{"$f":"SUM(D10:D17)","v":0},{"$f":"SUM(E10:E17)","v":0},{"$f":"SUM(F10:F17)","v":0}]
[null,null,"Float In","Spend Net","Spend VAT","Total Spend"]
["Float 1",null,null,{"$f":"D36","v":0},{"$f":"E36","v":0},{"$f":"F36","v":0}]
["Float 2",null,null,{"$f":"D49","v":0},{"$f":"E49","v":0},{"$f":"F49","v":0}]
["Float 3",null,null,{"$f":"D62","v":0},{"$f":"E62","v":0},{"$f":"F62","v":0}]
["Float 4",null,null,{"$f":"D75","v":0},{"$f":"E75","v":0},{"$f":"F75","v":0}]
["Float 5",null,null,{"$f":"D88","v":0},{"$f":"E88","v":0},{"$f":"F88","v":0}]
["Float 6",null,null,{"$f":"D101","v":0},{"$f":"E101","v":0},{"$f":"F101","v":0}]
["Float 7",null,null,{"$f":"D114","v":0},{"$f":"E114","v":0},{"$f":"F114","v":0}]
["Float 8",null,null,{"$f":"D127","v":0},{"$f":"E127","v":0},{"$f":"F127","v":0}]
[]
[null,null,null,{"$f":"SUM(D10:D17)","v":0},{"$f":"SUM(E10:E17)","v":0},{"$f":"SUM(F10:F17)","v":0}]
[null,"Spreadsheet Checker",null,{"$f":"SUM(D26:D35)+SUM(D39:D48)+SUM(D52:D61)+SUM(D65:D74)+SUM(D78:D87)+SUM(D91:D100)+SUM(D104:D113)+SUM(D117:D126)","v":0},{"$f":"SUM(E26:E35)+SUM(E39:E48)+SUM(E52:E61)+SUM(E65:E74)+SUM(E78:E87)+SUM(E91:E100)+SUM(E104:E113)+SUM(E117:E126)","v":0},{"$f":"SUM(F26:F35)+SUM(F39:F48)+SUM(F52:F61)+SUM(F65:F74)+SUM(F78:F87)+SUM(F91:F100)+SUM(F104:F113)+SUM(F117:F126)","v":0}]
[null,null,null,{"$f":"IF(D19-D20=0, \"Good\", \"Bad\")","v":"Good"},{"$f":"IF(E19-E20=0, \"Good\", \"Bad\")","v":"Good"},{"$f":"IF(F19-F20=0, \"Good\", \"Bad\")","v":"Good"}]
[]
["OVER / UNDER BUDGET",null,null,null,null,null,"Will turn red if over budget!"]
[]
["DEPARTMENT","ITEM","SUPPLIER","ACTUAL NET","VAT","GROSS","NOTES","Receipt No"]
[{"$f":"A10","v":"Float 1"},null,null,null,{"$f":"D26*0.2","v":0},{"$f":"D26+E26","v":0}]
[null,null,null,null,{"$f":"D27*0.2","v":0},{"$f":"D27+E27","v":0}]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,{"$f":"SUM(D26:D35)","v":0},{"$f":"SUM(E26:E35)","v":0},{"$f":"SUM(F26:F35)","v":0}]
[]
["DEPARTMENT","ITEM","SUPPLIER","ACTUAL NET","VAT","GROSS","NOTES","Receipt No"]
[{"$f":"A11","v":"Float 2"},null,null,null,{"$f":"D39*0.2","v":0},{"$f":"D39+E39","v":0}]
[null,null,null,null,{"$f":"D40*0.2","v":0},{"$f":"D40+E40","v":0}]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,{"$f":"SUM(D39:D48)","v":0},{"$f":"SUM(E39:E48)","v":0},{"$f":"SUM(F39:F48)","v":0}]
[]
["DEPARTMENT",null,"SUPPLIER","ACTUAL NET","VAT","GROSS","NOTES","Receipt No"]
[{"$f":"A12","v":"Float 3"},null,null,null,{"$f":"D52*0.2","v":0},{"$f":"D52+E52","v":0}]
[null,null,null,null,{"$f":"D53*0.2","v":0},{"$f":"D53+E53","v":0}]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,{"$f":"SUM(D52:D61)","v":0},{"$f":"SUM(E52:E61)","v":0},{"$f":"SUM(F52:F61)","v":0}]
[]
["DEPARTMENT","ITEM","SUPPLIER","ACTUAL NET","VAT","GROSS","NOTES","Receipt No"]
[{"$f":"A13","v":"Float 4"},null,null,null,{"$f":"D65*0.2","v":0},{"$f":"D65+E65","v":0}]
[null,null,null,null,{"$f":"D66*0.2","v":0},{"$f":"D66+E66","v":0}]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,{"$f":"SUM(D65:D74)","v":0},{"$f":"SUM(E65:E74)","v":0},{"$f":"SUM(F65:F74)","v":0}]
[]
["DEPARTMENT","ITEM","SUPPLIER","ACTUAL NET","VAT","GROSS","NOTES","Receipt No"]
[{"$f":"A14","v":"Float 5"},null,null,null,{"$f":"D78*0.2","v":0},{"$f":"D78+E78","v":0}]
[null,null,null,null,0,{"$f":"D79+E79","v":0}]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,{"$f":"SUM(D78:D87)","v":0},{"$f":"SUM(E78:E87)","v":0},{"$f":"SUM(F78:F87)","v":0}]
[]
["DEPARTMENT","ITEM","SUPPLIER","ACTUAL NET","VAT","GROSS","NOTES","Receipt No"]
[{"$f":"A15","v":"Float 6"},null,null,null,{"$f":"D91*0.2","v":0},{"$f":"E91+D91","v":0}]
[null,null,null,null,{"$f":"D92*0.2","v":0},{"$f":"E92+D92","v":0}]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,{"$f":"SUM(D91:D100)","v":0},{"$f":"SUM(E91:E100)","v":0},{"$f":"SUM(F91:F100)","v":0}]
[]
["DEPARTMENT","ITEM","SUPPLIER","ACTUAL NET","VAT","GROSS","NOTES","Receipt No"]
[{"$f":"A16","v":"Float 7"},null,null,null,{"$f":"D104*0.2","v":0},{"$f":"D104+E104","v":0}]
[null,null,null,null,{"$f":"D105*0.2","v":0},{"$f":"D105+E105","v":0}]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,{"$f":"SUM(D104:D113)","v":0},{"$f":"SUM(E104:E113)","v":0},{"$f":"SUM(F104:F113)","v":0}]
[]
["DEPARTMENT","ITEM","SUPPLIER","ACTUAL NET","VAT","GROSS","NOTES","Receipt No"]
[{"$f":"A17","v":"Float 8"},null,null,null,{"$f":"D117*0.2","v":0},{"$f":"D117*E117","v":0}]
[null,null,null,null,{"$f":"D118*0.2","v":0},{"$f":"D118*E118","v":0}]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,{"$f":"SUM(D117:D126)","v":0},{"$f":"SUM(E117:E126)","v":0},{"$f":"SUM(F117:F126)","v":0}]
[]
[]
[null,null,"TOTAL BUDGET COSTS: ",{"$f":"SUM(D36+D49+D62+D75+D88+D101+D114+D127)","v":0}]

{"sheet":"Costings 1","index":3,"n_rows":127,"n_cols":14,"rows_kept":127,"cut":false,"hidden":false,"merged":[[12,0,12,2],[13,0,13,2],[90,0,99,0],[103,0,112,0],[14,0,14,2],[15,0,15,2],[16,0,16,2],[116,0,125,0],[25,0,34,0],[38,0,47,0],[51,0,60,0],[64,0,73,0],[77,0,86,0],[10,0,10,2],[11,0,11,2],[0,1,0,2],[2,1,2,2],[4,1,4,2],[7,0,7,2],[9,0,9,2]]}
["Show Date",{"$f":"'Event Budget Summary'!B3:C3","v":"6th November 2016"}]
[]
["Project Manager",{"$f":"'Event Budget Summary'!B5:C5","v":"Martin Atkinson"}]
[]
["Client",{"$f":"'Event Budget Summary'!B7:C7","v":"Hull 2017"}]
[]
[]
["COSTINGS 1"]
[null,null,null,"Predicted"]
["A",null,null,{"$f":"I36","v":0}]
["B",null,null,{"$f":"I49","v":0}]
["C",null,null,{"$f":"I62","v":0}]
["D",null,null,{"$f":"I75","v":0}]
["E",null,null,{"$f":"I88","v":0}]
["F",null,null,{"$f":"I101","v":0}]
["G",null,null,{"$f":"I114","v":0}]
["H",null,null,{"$f":"I127","v":0}]
[]
[]
["Total Budget Costs",null,null,{"$f":"SUM(D10:D17)","v":0}]
["Overall Contingency",null,0,{"$f":"SUM(D8)*C21","v":0}]
[]
["OVER / UNDER BUDGET",null,null,null,null,null,null,null,null,"Will turn red if over budget!"]
[]
["DEPARTMENT","ITEM","SUPPLIER","UNIT COST","QUANTITY","QUANTITY","TOTAL","VAT","GROSS","NOTES","Receipt No","Invoice No","Signoff Date","Paid Date"]
[{"$f":"A10","v":"A"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"SUM(G26:G35)","v":0},{"$f":"SUM(H26:H35)","v":0},{"$f":"SUM(I26:I35)","v":0}]
[]
["DEPARTMENT","ITEM","SUPPLIER","UNIT COST","QUANTITY","QUANTITY","TOTAL","VAT","GROSS","NOTES","Receipt No","Invoice No","Signoff Date","Paid Date"]
[{"$f":"A11","v":"B"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"SUM(G39:G48)","v":0},{"$f":"SUM(H39:H48)","v":0},{"$f":"SUM(I39:I48)","v":0}]
[]
["DEPARTMENT","ITEM","SUPPLIER","UNIT COST","QUANTITY","QUANTITY","TOTAL"," VAT "," GROSS ","NOTES","Receipt No","Invoice No","Signoff Date","Paid Date"]
[{"$f":"A12","v":"C"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"SUM(G52:G61)","v":0},{"$f":"SUM(H52:H61)","v":0},{"$f":"SUM(I52:I61)","v":0}]
[]
["DEPARTMENT","ITEM","SUPPLIER","UNIT COST","QUANTITY","QUANTITY","TOTAL"," VAT "," GROSS ","NOTES","Receipt No","Invoice No","Signoff Date","Paid Date"]
[{"$f":"A13","v":"D"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"SUM(G65:G74)","v":0},{"$f":"SUM(H65:H74)","v":0},{"$f":"SUM(I65:I74)","v":0}]
[]
["DEPARTMENT","ITEM","SUPPLIER","UNIT COST","QUANTITY","QUANTITY","TOTAL"," VAT "," GROSS ","NOTES","Receipt No","Invoice No","Signoff Date","Paid Date"]
[{"$f":"A14","v":"E"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"SUM(G78:G87)","v":0},{"$f":"SUM(H78:H87)","v":0},{"$f":"SUM(I78:I87)","v":0}]
[]
["DEPARTMENT","ITEM","SUPPLIER","UNIT COST","QUANTITY","QUANTITY","TOTAL"," VAT "," GROSS ","NOTES","Receipt No","Invoice No","Signoff Date","Paid Date"]
[{"$f":"A15","v":"F"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"SUM(G91:G100)","v":0},{"$f":"SUM(H91:H100)","v":0},{"$f":"SUM(I91:I100)","v":0}]
[]
["DEPARTMENT","ITEM","SUPPLIER","UNIT COST","QUANTITY","QUANTITY","TOTAL"," VAT "," GROSS ","NOTES","Receipt No","Invoice No","Signoff Date","Paid Date"]
[{"$f":"A16","v":"G"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"SUM(G104:G113)","v":0},{"$f":"SUM(H104:H113)","v":0},{"$f":"SUM(I104:I113)","v":0}]
[]
["DEPARTMENT","ITEM","SUPPLIER","UNIT COST","QUANTITY","QUANTITY","TOTAL"," VAT "," GROSS ","NOTES","Receipt No","Invoice No","Signoff Date","Paid Date"]
[{"$f":"A17","v":"H"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"SUM(G117:G126)","v":0},{"$f":"SUM(H117:H126)","v":0},{"$f":"SUM(I117:I126)","v":0}]

{"sheet":"Crew Costs","index":4,"n_rows":29,"n_cols":14,"rows_kept":29,"cut":false,"hidden":false,"merged":[[28,4,28,7],[0,1,0,4],[2,1,2,4],[4,1,4,4]]}
["Show Date",{"$f":"'Event Budget Summary'!B3:C3","v":"6th November 2016"}]
[]
["Project Manager",{"$f":"'Event Budget Summary'!B5:C5","v":"Martin Atkinson"}]
[]
["Client",{"$f":"'Event Budget Summary'!B7:C7","v":"Hull 2017"}]
[]
["Name","Role","Half Day","No. of Days","Sub Total","Full Day","No. of Days","Sub Total","Travel Day","No. of Days","Sub Total","PDs","Total Cost","Notes"]
[]
[1,"CREW 1",100,null,{"$f":"D9*C9","v":0},250,null,{"$f":"G9*F9","v":0},70,0,{"$f":"J9*I9","v":0},{"$f":"'PDs & Petty Cash'!B15","v":0},{"$f":"E9+H9+K9+L9","v":0}]
[2,"CREW 2",100,null,0,250,null,{"$f":"G10*F10","v":0},70,0,{"$f":"J10*I10","v":0},{"$f":"'PDs & Petty Cash'!B22","v":0},{"$f":"E10+H10+K10+L10","v":0}]
[3,"CREW 3",100,null,0,250,null,{"$f":"G11*F11","v":0},70,0,{"$f":"J11*I11","v":0},{"$f":"'PDs & Petty Cash'!B17","v":0},0]
[4,"CREW 4",100,null,0,250,null,0,70,0,0,{"$f":"'PDs & Petty Cash'!B24","v":0},0]
[5,"CREW 5",100,null,0,250,null,0,70,0,0,{"$f":"'PDs & Petty Cash'!B19","v":0},0]
[6,"CREW 6",100,null,0,250,null,0,70,0,0,{"$f":"'PDs & Petty Cash'!B26","v":0},0]
[7,"CREW 7",100,null,0,250,null,0,70,0,0,{"$f":"'PDs & Petty Cash'!B21","v":0},0]
[8,"CREW 8",100,null,0,250,null,0,70,0,0,{"$f":"'PDs & Petty Cash'!B28","v":0},0]
[9,"CREW 9",100,null,0,250,null,0,70,0,0,{"$f":"'PDs & Petty Cash'!B23","v":0},0]
[10,"CREW 10",100,null,0,250,null,0,70,0,0,{"$f":"'PDs & Petty Cash'!B30","v":0},0]
[11,"CREW 11",100,null,0,250,null,0,70,0,0,{"$f":"'PDs & Petty Cash'!B25","v":0},0]
[12,"CREW 12",100,null,0,250,null,0,70,0,0,{"$f":"'PDs & Petty Cash'!B32","v":0},0]
[13,"CREW 13",100,null,0,250,null,0,70,0,0,{"$f":"'PDs & Petty Cash'!B27","v":0},0]
[14,"CREW 14",100,null,0,250,null,0,70,0,0,{"$f":"'PDs & Petty Cash'!B34","v":0},0]
[15,"CREW 15",100,null,0,250,null,0,70,0,0,{"$f":"'PDs & Petty Cash'!B29","v":0},0]
[16,"CREW 16",100,null,0,250,null,0,70,0,0,{"$f":"'PDs & Petty Cash'!B36","v":0},0]
[17,"CREW 17",100,null,0,250,null,0,70,0,0,{"$f":"'PDs & Petty Cash'!B31","v":0},0]
[18,"CREW 18",100,null,0,250,null,{"$f":"G26*F26","v":0},70,0,{"$f":"J26*I26","v":0},{"$f":"'PDs & Petty Cash'!B32","v":0},0]
[19,"CREW 19",100,null,0,250,null,{"$f":"G27*F27","v":0},70,0,{"$f":"J27*I27","v":0},{"$f":"'PDs & Petty Cash'!B33","v":0},0]
[null,null,null,{"$f":"SUM(D9:D27)","v":0},null,null,{"$f":"SUM(G9:G27)","v":0},null,null,{"$f":"SUM(J9:J27)","v":0}]
[null,null,null,null,"TOTAL STAFF COST",null,null,null,null,null,null,null,{"$f":"SUM(M9:M28)","v":0}]

{"sheet":"Crew Accommodation","index":5,"n_rows":67,"n_cols":34,"rows_kept":67,"cut":false,"hidden":false,"merged":[[45,3,45,4],[41,16,41,22],[36,3,36,4],[37,3,37,4],[38,3,38,4],[39,3,39,4],[40,3,40,4],[41,3,41,4],[42,3,42,4],[43,3,43,4],[44,3,44,4],[62,3,62,4],[63,3,63,4],[52,3,52,4],[53,3,53,4],[54,3,54,4],[55,3,55,4],[56,3,56,4],[57,3,57,4],[59,3,59,4],[51,3,51,4],[46,3,46,4],[49,16,49,22],[60,3,60,4],[61,3,61,4],[48,3,48,4],[47,3,47,4],[66,3,66,5],[6,33,8,33],[6,0,8,0],[64,3,64,4],[65,3,65,4],[36,9,37,22],[39,9,39,22],[41,9,41,15],[45,9,45,15],[49,9,49,15],[43,9,43,22],[47,9,47,22],[45,16,45,22],[58,3,58,4],[49,3,49,4],[50,3,50,4]]}
["Show Date",{"$f":"'Event Budget Summary'!B3:C3","v":"6th November 2016"}]
[]
["Project Manager",{"$f":"'Event Budget Summary'!B5:C5","v":"Martin Atkinson"}]
[]
["Client",{"$f":"'Event Budget Summary'!B7:C7","v":"Hull 2017"}]
[]
[null,"Notes",null,"Accomodation",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,"Notes"]
[null,null,null,"2017-01-01",{"$f":"D8+1","v":"2017-01-02"},{"$f":"E8+1","v":"2017-01-03"},{"$f":"F8+1","v":"2017-01-04"},{"$f":"G8+1","v":"2017-01-05"},"2017-01-06","2017-01-07","2017-01-08","2017-01-09","2017-01-10","2017-01-11","2017-01-12","2017-01-13","2017-01-14","2017-01-15","2017-01-16","2017-01-17","2017-01-18","2017-01-19","2017-01-20","2017-01-21","2017-01-22","2017-01-23","2017-01-24","2017-01-25","2017-01-26","2017-01-27","2017-01-28","2017-01-29","2017-01-30"]
[null,null,null,"D","D","D","D","D","D","D","D","D","D","D","D","D","D","D","D","D","D","D","D","D","D","D","D","D","D","D","D","D","D"]
["Crew 1"]
["Crew 2"]
["Crew 3"]
["Crew 4"]
["Crew 5"]
["Crew 6"]
["Crew 7"]
["Crew 8"]
["Crew 9"]
["Crew 10"]
["Artist 1"]
["Artist 2"]
["Artist 3"]
["Artist 4"]
["Artist 5"]
["Artist 6"]
["Artist 7"]
["Artist 8"]
["Artist 9"]
["Artist 10"]
["Artist 11"]
["Artist 12"]
["Artist 13"]
["Artist 14"]
["Artist 15"]
["Artist 16"]
[]
[null,{"$f":"D8","v":"2017-01-01"},"Rooms",{"$f":"SUM(D10:D35)","v":0},null,null,null,null,null,"SUMMARY"]
[null,{"$f":"B37+1","v":"2017-01-02"},"Rooms",{"$f":"SUM(E10:E35)","v":0}]
[null,{"$f":"B38+1","v":"2017-01-03"},"Rooms",{"$f":"SUM(F10:F35)","v":0}]
[null,"2017-01-04","Rooms",{"$f":"SUM(G10:G35)","v":0},null,null,null,null,null,"ROOM COST"]
[null,"2017-01-05","Rooms",{"$f":"SUM(H10:H35)","v":0}]
[null,"2017-01-06","Rooms",{"$f":"SUM(I10:I35)","v":0},null,null,null,null,null,"TWIN COST",null,null,null,null,null,null,55]
[null,"2017-01-07","Rooms",{"$f":"SUM(J10:J35)","v":0}]
[null,"2017-01-08","Rooms",{"$f":"SUM(K10:K35)","v":0},null,null,null,null,null,"ROOM QUANTITIES"]
[null,"2017-01-09","Rooms",{"$f":"SUM(L10:L35)","v":0}]
[null,"2017-01-10","Rooms",{"$f":"SUM(M10:M35)","v":0},null,null,null,null,null,"TOTAL ROOMS",null,null,null,null,null,null,{"$f":"D67","v":0}]
[null,"2017-01-11","Rooms",{"$f":"SUM(N10:N35)","v":0}]
[null,"2017-01-12","Rooms",{"$f":"SUM(O10:O35)","v":0},null,null,null,null,null,"TOTAL COSTS"]
[null,"2017-01-13","Rooms",{"$f":"SUM(P10:P35)","v":0}]
[null,"2017-01-14","Rooms",{"$f":"SUM(Q10:Q35)","v":0},null,null,null,null,null,"ROOM COSTS",null,null,null,null,null,null,{"$f":"SUM(Q42*Q46)","v":0}]
[null,"2017-01-15","Rooms",{"$f":"SUM(R10:R35)","v":0}]
[null,"2017-01-16","Rooms",{"$f":"SUM(S10:S35)","v":0}]
[null,"2017-01-17","Rooms",{"$f":"SUM(T10:T35)","v":0}]
[null,"2017-01-18","Rooms",{"$f":"SUM(U10:U35)","v":0}]
[null,"2017-01-19","Rooms",{"$f":"SUM(V10:V35)","v":0}]
[null,"2017-01-20","Rooms",{"$f":"SUM(W10:W35)","v":0}]
[null,"2017-01-21","Rooms",{"$f":"SUM(X10:X35)","v":0}]
[null,"2017-01-22","Rooms",{"$f":"SUM(Y10:Y35)","v":0}]
[null,"2017-01-23","Rooms",{"$f":"SUM(Z10:Z35)","v":0}]
[null,"2017-01-24","Rooms",{"$f":"SUM(AA10:AA35)","v":0}]
[null,"2017-01-25","Rooms",{"$f":"SUM(AB10:AB35)","v":0}]
[null,"2017-01-26","Rooms",{"$f":"SUM(AC10:AC35)","v":0}]
[null,"2017-01-27","Rooms",{"$f":"SUM(AD10:AD35)","v":0}]
[null,"2017-01-28","Rooms",{"$f":"SUM(AE10:AE35)","v":0}]
[null,"2017-01-29","Rooms",{"$f":"SUM(AF10:AF35)","v":0}]
[null,"2017-01-30","Rooms",{"$f":"SUM(AG10:AG35)","v":0}]
[null,null,null,{"$f":"SUM(D37:D66)","v":0}]

{"sheet":"Crew Catering","index":6,"n_rows":85,"n_cols":33,"rows_kept":85,"cut":false,"hidden":false,"merged":[[55,1,57,1],[58,1,60,1],[58,9,58,22],[7,27,7,29],[0,1,0,12],[2,1,2,12],[4,1,4,12],[7,21,7,23],[7,24,7,26],[7,3,7,5],[55,3,55,4],[56,3,56,4],[57,3,57,4],[58,3,58,4],[59,3,59,4],[60,3,60,4],[6,0,8,0],[6,3,6,32],[7,15,7,17],[7,18,7,20],[7,30,7,32],[6,1,8,1],[6,2,8,2],[7,6,7,8],[7,9,7,11],[7,12,7,14],[77,3,77,4],[78,3,78,4],[61,1,63,1],[64,1,66,1],[79,3,79,4],[67,3,67,4],[68,3,68,4],[69,3,69,4],[70,3,70,4],[63,3,63,4],[64,3,64,4],[65,3,65,4],[66,3,66,4],[61,3,61,4],[62,3,62,4],[79,1,81,1],[82,1,84,1],[83,3,83,4],[84,3,84,4],[67,1,69,1],[70,1,72,1],[73,1,75,1],[76,1,78,1],[81,3,81,4],[82,3,82,4],[80,3,80,4],[71,3,71,4],[72,3,72,4],[73,3,73,4],[74,3,74,4],[75,3,75,4],[76,3,76,4],[55,9,56,22],[80,9,80,15],[83,9,83,15],[83,16,83,22],[80,16,80,22],[76,9,76,15],[78,9,78,15],[76,16,76,22],[78,16,78,22],[72,9,72,15],[68,16,68,22],[70,16,70,22],[72,16,72,22],[70,9,70,15],[74,9,74,22],[68,9,68,15],[66,9,66,22],[64,16,64,22],[60,9,60,15],[62,9,62,15],[64,9,64,15],[60,16,60,22],[62,16,62,22]]}
["Show Date",{"$f":"'Event Budget Summary'!B3:C3","v":"6th November 2016"}]
[]
["Project Manager",{"$f":"'Event Budget Summary'!B5:C5","v":"Martin Atkinson"}]
[]
["Client",{"$f":"'Event Budget Summary'!B7:C7","v":"Hull 2017"}]
[]
["Who","Role","Contact Number","Catering"]
[null,null,null,"Day 1",null,null,"Day 2",null,null,"Day 3",null,null,"Day 4",null,null,"Day 5",null,null,"Day 6",null,null,"Day 7",null,null,"Day 8",null,null,"Day 9",null,null,"Day 10"]
[null,null,null,"B","L","D","B","L","D","B","L","D","B","L","D","B","L","D","B","L","D","B","L","D","B","L","D","B","L","D","B","L","D"]
[{"$f":"'Crew Costs'!B9","v":"CREW 1"}]
[{"$f":"'Crew Costs'!B10","v":"CREW 2"}]
[{"$f":"'Crew Costs'!B11","v":"CREW 3"}]
[{"$f":"'Crew Costs'!B12","v":"CREW 4"}]
[{"$f":"'Crew Costs'!B13","v":"CREW 5"}]
[{"$f":"'Crew Costs'!B14","v":"CREW 6"}]
[{"$f":"'Crew Costs'!B15","v":"CREW 7"}]
[{"$f":"'Crew Costs'!B16","v":"CREW 8"}]
[{"$f":"'Crew Costs'!B17","v":"CREW 9"}]
[{"$f":"'Crew Costs'!B18","v":"CREW 10"}]
[{"$f":"'Crew Costs'!B19","v":"CREW 11"}]
[{"$f":"'Crew Costs'!B20","v":"CREW 12"}]
[{"$f":"'Crew Costs'!B21","v":"CREW 13"}]
[{"$f":"'Crew Costs'!B22","v":"CREW 14"}]
[{"$f":"'Crew Costs'!B23","v":"CREW 15"}]
[{"$f":"'Crew Costs'!B24","v":"CREW 16"}]
[{"$f":"'Crew Costs'!B25","v":"CREW 17"}]
[{"$f":"'Crew Costs'!B26","v":"CREW 18"}]
[{"$f":"'Crew Costs'!B27","v":"CREW 19"}]
["CREW 20"]
["Other Crew 1"]
["Other Crew 2"]
["Other Crew 3"]
["Other Crew 4"]
["Other Crew 5"]
["Other Crew 6"]
["Other Crew 7"]
["Other Crew 8"]
["Other Crew 9"]
["Other Crew 10"]
["Other Crew 11"]
["Other Crew 12"]
["Other Crew 13"]
["Other Crew 14"]
["Other Crew 15"]
["Other Crew 16"]
["Other Crew 17"]
["Other Crew 18"]
["Other Crew 19"]
["Other Crew 20"]
["Other Crew 21"]
["Other Crew 22"]
["Other Crew 23"]
["Other Crew 24"]
["Other Crew 25"]
[]
[null,"Day 1","Breakfast",{"$f":"SUM(D10:D54)","v":0},null,null,null,null,null,"SUMMARY"]
[null,null,"Lunch",{"$f":"SUM(E10:E54)","v":0}]
[null,null,"Dinner",{"$f":"SUM(F10:F54)","v":0}]
[null,"Day 2","Breakfast",{"$f":"SUM(G10:G54)","v":0},null,null,null,null,null,"MEAL COST"]
[null,null,"Lunch",{"$f":"SUM(H10:H54)","v":0}]
[null,null,"Dinner",{"$f":"SUM(I10:I54)","v":0},null,null,null,null,null,"BREAKFAST COST",null,null,null,null,null,null,7.5]
[null,"Day 3","Breakfast",{"$f":"SUM(J10:J54)","v":0}]
[null,null,"Lunch",{"$f":"SUM(K10:K54)","v":0},null,null,null,null,null,"LUNCH COST",null,null,null,null,null,null,15]
[null,null,"Dinner",{"$f":"SUM(L10:L54)","v":0}]
[null,"Day 4","Breakfast",{"$f":"SUM(M10:M54)","v":0},null,null,null,null,null,"DINNER COST",null,null,null,null,null,null,22.5]
[null,null,"Lunch",{"$f":"SUM(N10:N54)","v":0}]
[null,null,"Dinner",{"$f":"SUM(O10:O54)","v":0},null,null,null,null,null,"MEAL QUANTITIES"]
[null,"Day 5","Breakfast",{"$f":"SUM(P10:P54)","v":0}]
[null,null,"Lunch",{"$f":"SUM(Q10:Q54)","v":0},null,null,null,null,null,"TOTAL BREAKFAST",null,null,null,null,null,null,{"$f":"SUM(D56+D59+D62+D65+D68+D71+D74+D77+D80+D83)","v":0}]
[null,null,"Dinner",{"$f":"SUM(R10:R54)","v":0}]
[null,"Day 6","Breakfast",{"$f":"SUM(S10:S54)","v":0},null,null,null,null,null,"TOTAL LUNCH",null,null,null,null,null,null,{"$f":"SUM(D57+D60+D63+D66+D69+D72+D75+D78+D81+D84)","v":0}]
[null,null,"Lunch",{"$f":"SUM(T10:T54)","v":0}]
[null,null,"Dinner",{"$f":"SUM(U10:U54)","v":0},null,null,null,null,null,"TOTAL DINNER",null,null,null,null,null,null,{"$f":"SUM(D58+D61+D64+D67+D70+D73+D76+D79+D82+D85)","v":0}]
[null,"Day 7","Breakfast",{"$f":"SUM(V10:V54)","v":0}]
[null,null,"Lunch",{"$f":"SUM(W10:W54)","v":0},null,null,null,null,null,"TOTAL COSTS"]
[null,null,"Dinner",{"$f":"SUM(X10:X54)","v":0}]
[null,"Day 8","Breakfast",{"$f":"SUM(Y10:Y54)","v":0},null,null,null,null,null,"BREAKFAST COST",null,null,null,null,null,null,{"$f":"SUM(Q61*Q69)","v":0}]
[null,null,"Lunch",{"$f":"SUM(Z10:Z54)","v":0}]
[null,null,"Dinner",{"$f":"SUM(AA10:AA54)","v":0},null,null,null,null,null,"LUNCH COST",null,null,null,null,null,null,{"$f":"SUM(Q63*Q71)","v":0}]
[null,"Day 9","Breakfast",{"$f":"SUM(AB10:AB54)","v":0}]
[null,null,"Lunch",{"$f":"SUM(AC10:AC54)","v":0},null,null,null,null,null,"DINNER COST",null,null,null,null,null,null,{"$f":"SUM(Q65*Q73)","v":0}]
[null,null,"Dinner",{"$f":"SUM(AD10:AD54)","v":0}]
[null,"Day 10","Breakfast",{"$f":"SUM(AE10:AE54)","v":0}]
[null,null,"Lunch",{"$f":"SUM(AF10:AF54)","v":0},null,null,null,null,null,"TOTAL MEALS COST",null,null,null,null,null,null,{"$f":"SUM(Q77+Q79+Q81)","v":0}]
[null,null,"Dinner",{"$f":"SUM(AG10:AG54)","v":0}]

{"sheet":"PDs & Petty Cash","index":7,"n_rows":121,"n_cols":5,"rows_kept":121,"cut":false,"hidden":false,"merged":[[97,0,100,0],[103,0,106,0],[109,0,112,0],[37,0,40,0],[55,0,58,0],[85,0,88,0],[91,0,94,0],[67,0,70,0],[73,0,76,0],[79,0,82,0],[1,1,1,4],[3,1,3,4],[5,1,5,4],[61,0,64,0],[49,0,52,0],[43,0,46,0],[9,0,13,0],[16,0,20,0],[23,0,27,0],[30,0,34,0]]}
[]
["Show Date",{"$f":"'Event Budget Summary'!B3:C3","v":"6th November 2016"}]
[]
["Project Manager",{"$f":"'Event Budget Summary'!B5:C5","v":"Martin Atkinson"}]
[]
["Client",{"$f":"'Event Budget Summary'!B7:C7","v":"Hull 2017"}]
[]
[]
["Crew","£","Dates","Date received","Signed"]
[{"$f":"'Crew Costs'!B9","v":"CREW 1"}]
[]
[]
[]
[]
["TOTAL",{"$f":"SUM(B10:B14)","v":0}]
[]
[{"$f":"'Crew Costs'!B10","v":"CREW 2"}]
[]
[]
[]
[]
["TOTAL",{"$f":"SUM(B17:B21)","v":0}]
[]
[{"$f":"'Crew Costs'!B11","v":"CREW 3"}]
[]
[]
[]
[]
["TOTAL",{"$f":"SUM(B24:B28)","v":0}]
[]
[{"$f":"'Crew Costs'!B12","v":"CREW 4"}]
[]
[]
[]
[]
["TOTAL",{"$f":"SUM(B31:B35)","v":0}]
[]
[{"$f":"'Crew Costs'!B13","v":"CREW 5"}]
[]
[]
[]
["TOTAL",{"$f":"SUM(B38:B41)","v":0}]
[]
[{"$f":"'Crew Costs'!B20","v":"CREW 12"}]
[]
[]
[]
["TOTAL",{"$f":"SUM(B44:B47)","v":0}]
[]
[{"$f":"'Crew Costs'!B26","v":"CREW 18"}]
[]
[]
[]
["TOTAL",{"$f":"SUM(B50:B53)","v":0}]
[]
[{"$f":"'Crew Costs'!#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
["TOTAL",{"$f":"SUM(B56:B59)","v":0}]
[]
[{"$f":"'Crew Costs'!#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
["TOTAL",{"$f":"SUM(B62:B65)","v":0}]
[]
[{"$f":"'Crew Costs'!B29","v":0}]
[]
[]
[]
["TOTAL",{"$f":"SUM(B68:B71)","v":0}]
[]
[{"$f":"'Crew Costs'!B35","v":0}]
[]
[]
[]
["TOTAL",{"$f":"SUM(B74:B77)","v":0}]
[]
[{"$f":"'Crew Costs'!B40","v":0}]
[]
[]
[]
["TOTAL",{"$f":"SUM(B80:B83)","v":0}]
[]
[{"$f":"'Crew Costs'!B46","v":0}]
[]
[]
[]
["TOTAL",{"$f":"SUM(B86:B89)","v":0}]
[]
[{"$f":"'Crew Costs'!B51","v":0}]
[]
[]
[]
["TOTAL",{"$f":"SUM(B92:B95)","v":0}]
[]
[{"$f":"'Crew Costs'!B56","v":0}]
[]
[]
[]
["TOTAL",{"$f":"SUM(B98:B101)","v":0}]
[]
[{"$f":"'Crew Costs'!B62","v":0}]
[]
[]
[]
["TOTAL",{"$f":"SUM(B104:B107)","v":0}]
[]
[{"$f":"'Crew Costs'!B67","v":0}]
[]
[]
[]
["TOTAL",{"$f":"SUM(B110:B113)","v":0}]
[]
[]
[]
["PD's",{"$f":"B78+B72+B66+B60+B54+B48+B42+B36+B29+B22+B15","v":0}]
["Petty Cash",0]
[]
["GRAND TOTAL",{"$f":"B119+B118","v":0}]

{"sheet":"Passes & Radios","index":8,"n_rows":65,"n_cols":13,"rows_kept":65,"cut":false,"hidden":false,"merged":[[63,6,63,8],[9,8,10,8],[64,6,64,8],[60,3,60,4],[61,3,61,4],[62,3,62,4],[63,3,63,4],[64,3,64,4],[60,6,60,8],[61,6,61,8],[62,6,62,8],[8,0,10,0],[8,1,10,1],[8,2,10,2],[9,11,10,11],[8,3,8,7],[9,10,10,10],[9,12,10,12],[9,3,9,7],[0,1,0,8],[2,1,2,8],[4,1,4,8],[6,1,6,8],[8,8,8,12],[9,9,10,9]]}
["Project Title",{"$f":"'Event Budget Summary'!B1:C1","v":"Substance"}]
[]
["Show Date",{"$f":"'Event Budget Summary'!B3:C3","v":"6th November 2016"}]
[]
["Project Manager",{"$f":"'Event Budget Summary'!B5:C5","v":"Martin Atkinson"}]
[]
[null,{"$f":"'Event Budget Summary'!B7:C7","v":"Hull 2017"}]
[]
["Name","Role","Contact Number","Passes",null,null,null,null,"Radio's"]
[null,null,null,"Pass Type",null,null,null,null,"Radio","Ear Piece","Noise Cancellation","Fist Mic","Pouch"]
[null,null,null,1,2,3,4,5]
[{"$f":"'Crew Catering'!A10","v":"CREW 1"},{"$f":"'Crew Catering'!B10","v":0},{"$f":"'Crew Catering'!C10","v":0}]
[{"$f":"'Crew Catering'!A11","v":"CREW 2"},{"$f":"'Crew Catering'!B11","v":0},{"$f":"'Crew Catering'!C11","v":0}]
[{"$f":"'Crew Catering'!A12","v":"CREW 3"},{"$f":"'Crew Catering'!B12","v":0},{"$f":"'Crew Catering'!C12","v":0}]
[{"$f":"'Crew Catering'!A13","v":"CREW 4"},{"$f":"'Crew Catering'!B13","v":0},{"$f":"'Crew Catering'!C13","v":0}]
[{"$f":"'Crew Catering'!A14","v":"CREW 5"},{"$f":"'Crew Catering'!B14","v":0},{"$f":"'Crew Catering'!C14","v":0}]
[{"$f":"'Crew Catering'!A15","v":"CREW 6"},{"$f":"'Crew Catering'!B15","v":0},{"$f":"'Crew Catering'!C15","v":0}]
[{"$f":"'Crew Catering'!A16","v":"CREW 7"},{"$f":"'Crew Catering'!B16","v":0},{"$f":"'Crew Catering'!C16","v":0}]
[{"$f":"'Crew Catering'!A17","v":"CREW 8"},{"$f":"'Crew Catering'!B17","v":0},{"$f":"'Crew Catering'!C17","v":0}]
[{"$f":"'Crew Catering'!A18","v":"CREW 9"},{"$f":"'Crew Catering'!B18","v":0},{"$f":"'Crew Catering'!C18","v":0}]
[{"$f":"'Crew Catering'!A19","v":"CREW 10"},{"$f":"'Crew Catering'!B19","v":0},{"$f":"'Crew Catering'!C19","v":0}]
[{"$f":"'Crew Catering'!A20","v":"CREW 11"},{"$f":"'Crew Catering'!B20","v":0},{"$f":"'Crew Catering'!C20","v":0}]
[{"$f":"'Crew Catering'!A21","v":"CREW 12"},{"$f":"'Crew Catering'!B21","v":0},{"$f":"'Crew Catering'!C21","v":0}]
[{"$f":"'Crew Catering'!A22","v":"CREW 13"},{"$f":"'Crew Catering'!B22","v":0},{"$f":"'Crew Catering'!C22","v":0}]
[{"$f":"'Crew Catering'!A23","v":"CREW 14"},{"$f":"'Crew Catering'!B23","v":0},{"$f":"'Crew Catering'!C23","v":0}]
[{"$f":"'Crew Catering'!A24","v":"CREW 15"},{"$f":"'Crew Catering'!B24","v":0},{"$f":"'Crew Catering'!C24","v":0}]
[{"$f":"'Crew Catering'!A25","v":"CREW 16"},{"$f":"'Crew Catering'!B25","v":0},{"$f":"'Crew Catering'!C25","v":0}]
[{"$f":"'Crew Catering'!A26","v":"CREW 17"},{"$f":"'Crew Catering'!B26","v":0},{"$f":"'Crew Catering'!C26","v":0}]
[{"$f":"'Crew Catering'!A27","v":"CREW 18"},{"$f":"'Crew Catering'!B27","v":0},{"$f":"'Crew Catering'!C27","v":0}]
[{"$f":"'Crew Catering'!A28","v":"CREW 19"},{"$f":"'Crew Catering'!B28","v":0},{"$f":"'Crew Catering'!C28","v":0}]
[{"$f":"'Crew Catering'!A29","v":"CREW 20"},{"$f":"'Crew Catering'!B29","v":0},{"$f":"'Crew Catering'!C29","v":0}]
[{"$f":"'Crew Catering'!A30","v":"Other Crew 1"},{"$f":"'Crew Catering'!B30","v":0},{"$f":"'Crew Catering'!C30","v":0}]
[{"$f":"'Crew Catering'!A31","v":"Other Crew 2"},{"$f":"'Crew Catering'!B31","v":0},{"$f":"'Crew Catering'!C31","v":0}]
[{"$f":"'Crew Catering'!A32","v":"Other Crew 3"},{"$f":"'Crew Catering'!B32","v":0},{"$f":"'Crew Catering'!C32","v":0}]
[{"$f":"'Crew Catering'!A33","v":"Other Crew 4"},{"$f":"'Crew Catering'!B33","v":0},{"$f":"'Crew Catering'!C33","v":0}]
[{"$f":"'Crew Catering'!A34","v":"Other Crew 5"},{"$f":"'Crew Catering'!B34","v":0},{"$f":"'Crew Catering'!C34","v":0}]
[{"$f":"'Crew Catering'!A35","v":"Other Crew 6"},{"$f":"'Crew Catering'!B35","v":0},{"$f":"'Crew Catering'!C35","v":0}]
[{"$f":"'Crew Catering'!A36","v":"Other Crew 7"},{"$f":"'Crew Catering'!B36","v":0},{"$f":"'Crew Catering'!C36","v":0}]
[{"$f":"'Crew Catering'!A37","v":"Other Crew 8"},{"$f":"'Crew Catering'!B37","v":0},{"$f":"'Crew Catering'!C37","v":0}]
[{"$f":"'Crew Catering'!A38","v":"Other Crew 9"},{"$f":"'Crew Catering'!B38","v":0},{"$f":"'Crew Catering'!C38","v":0}]
[{"$f":"'Crew Catering'!A39","v":"Other Crew 10"},{"$f":"'Crew Catering'!B39","v":0},{"$f":"'Crew Catering'!C39","v":0}]
[{"$f":"'Crew Catering'!A40","v":"Other Crew 11"},{"$f":"'Crew Catering'!B40","v":0},{"$f":"'Crew Catering'!C40","v":0}]
[{"$f":"'Crew Catering'!A41","v":"Other Crew 12"},{"$f":"'Crew Catering'!B41","v":0},{"$f":"'Crew Catering'!C41","v":0}]
[{"$f":"'Crew Catering'!A42","v":"Other Crew 13"},{"$f":"'Crew Catering'!B42","v":0},{"$f":"'Crew Catering'!C42","v":0}]
[{"$f":"'Crew Catering'!A43","v":"Other Crew 14"},{"$f":"'Crew Catering'!B43","v":0},{"$f":"'Crew Catering'!C43","v":0}]
[{"$f":"'Crew Catering'!A44","v":"Other Crew 15"},{"$f":"'Crew Catering'!B44","v":0},{"$f":"'Crew Catering'!C44","v":0}]
[{"$f":"'Crew Catering'!A45","v":"Other Crew 16"},{"$f":"'Crew Catering'!B45","v":0},{"$f":"'Crew Catering'!C45","v":0}]
[{"$f":"'Crew Catering'!A46","v":"Other Crew 17"},{"$f":"'Crew Catering'!B46","v":0},{"$f":"'Crew Catering'!C46","v":0}]
[{"$f":"'Crew Catering'!A47","v":"Other Crew 18"},{"$f":"'Crew Catering'!B47","v":0},{"$f":"'Crew Catering'!C47","v":0}]
[{"$f":"'Crew Catering'!A48","v":"Other Crew 19"},{"$f":"'Crew Catering'!B48","v":0},{"$f":"'Crew Catering'!C48","v":0}]
[{"$f":"'Crew Catering'!A49","v":"Other Crew 20"},{"$f":"'Crew Catering'!B49","v":0},{"$f":"'Crew Catering'!C49","v":0}]
[{"$f":"'Crew Catering'!A50","v":"Other Crew 21"},{"$f":"'Crew Catering'!B50","v":0},{"$f":"'Crew Catering'!C50","v":0}]
[{"$f":"'Crew Catering'!A51","v":"Other Crew 22"},{"$f":"'Crew Catering'!B51","v":0},{"$f":"'Crew Catering'!C51","v":0}]
[{"$f":"'Crew Catering'!A52","v":"Other Crew 23"},{"$f":"'Crew Catering'!B52","v":0},{"$f":"'Crew Catering'!C52","v":0}]
[{"$f":"'Crew Catering'!A53","v":"Other Crew 24"},{"$f":"'Crew Catering'!B53","v":0},{"$f":"'Crew Catering'!C53","v":0}]
[{"$f":"'Crew Catering'!A54","v":"Other Crew 25"},{"$f":"'Crew Catering'!B54","v":0},{"$f":"'Crew Catering'!C54","v":0}]
[{"$f":"'Crew Catering'!A55","v":0},{"$f":"'Crew Catering'!B55","v":0},{"$f":"'Crew Catering'!C55","v":0}]
[]
["Radio Totals",null,"Pass Totals",null,null,null,"Access Details"]
[]
["Handsets",{"$f":"SUM(I12:I57)","v":0},"Type 1",{"$f":"SUM(D12:D57)","v":0},null,null,"Access"]
["Ear Piece",{"$f":"SUM(J12:J57)","v":0},"Type 2",{"$f":"SUM(E12:E57)","v":0},null,null,"Access"]
["Noise Cancellation",{"$f":"SUM(K12:K57)","v":0},"Type 3",{"$f":"SUM(F12:F57)","v":0},null,null,"Access"]
["Fist/Parrot Mic",{"$f":"SUM(L12:L57)","v":0},"Type 4",{"$f":"SUM(G12:G57)","v":0},null,null,"Access"]
["Leather Pouch",{"$f":"SUM(M12:M57)","v":0},"Type 5",{"$f":"SUM(H12:H57)","v":0},null,null,"Access"]