{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Budget","Backup"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Budget","index":0,"n_rows":106,"n_cols":56,"rows_kept":106,"cut":false,"hidden":false,"merged":[[7,9,7,10],[1,14,1,15],[1,3,1,7],[4,10,4,11],[3,10,3,11],[6,9,6,10]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 - Most Important",2,3,4,"5 - Least Important",1,2,3,4,5,null,null,null,null,null,null,null,null,null,"Accommodation","Affiliation Fees","Competitions","Conferences","Consumables","Copyright Materials","Equipment","Equipment & Repair","Ground Hire","Hospitality","Instructors","Insurance","Printing Costs","Publicity","Referees","Travel Expenditure"]
["Core",null,null,"GREEN = EDIT; YELLOW = EDIT IF NEEDED",null,null,null,null,null,null,"Annual Budgeting 2",null,null,"Club Name:","Ferret fanciers"]
["Not Core"]
["Welfare",null,null,null,null,"SGI","Income","Expenditure","Deficit / Surplus","No. Members","Recommended Membership",null,"Grant Requested"]
["Exec",null,null,null,null,3000,{"$f":"SUMIF($D$10:$D$2140,\"Total\",$O$10:$O$2140)","v":50},{"$f":"SUMIF($D$10:$D$2140,\"Total\",$M$10:$M$2140)","v":200},{"$f":"G5-H5","v":-150},30,{"$f":"IF(I5<0,ABS(I5/J5),0)","v":5},null,{"$f":"SUMIF($D$9:$D$2133,\"Total\",$P$9:$P$2119)","v":195}]
[]
[null,null,null,null,null,null,null,null,null,"Desired Membership Cost",null,"Net Position"]
[null,null,null,null,null,null,null,null,null,2,null,{"$f":"(G5-H5)+(J8*J5)","v":-90}]
[null,null,"General Lines"]
["Accommodation",null,null,"Properties","Priority","Description","Occurrences","Attendance","Status","Category","Cost","Quantity","Total Cost","Income/pp","Total Income","Grant Requested","Fund Level","MG1","MG2","Eligible Grant","Estimated Grant"]
["Affiliation Fees",null,null,null,null,"Affiliation to GB Ferret",null,null,null,null,100,null,{"$f":"K11*L11*G11","v":0},null,{"$f":"N11*H11*G11","v":0},100,null,null,null,{"$f":"IF(R11=\"y\",IF(S11=\"Y\",P11,0),IF(S11=\"N\",0,IF(R11=\"N\",0,P11)))","v":100},{"$f":"IF(Budget!$Q11=1,Budget!$T11,IF(Budget!$Q11=2,Budget!$T11*0.8,IF(Budget!$Q11=3,Budget!$T11*0.6,IF(Budget!$Q11=4,Budget!$T11*0.4,IF(Budget!$Q11=5,Budget!$T11*0.2,0)))))","v":0}]
["Competitions",null,null,null,null,"Sponsorship from JPSworgan",1,1,null,null,null,null,{"$f":"K12*L12*G12","v":0},50,{"$f":"N12*H12*G12","v":50},null,null,null,null,{"$f":"IF(R12=\"y\",IF(S12=\"Y\",P12,0),IF(S12=\"N\",0,IF(R12=\"N\",0,P12)))","v":0},{"$f":"IF(Budget!$Q12=1,Budget!$T12,IF(Budget!$Q12=2,Budget!$T12*0.8,IF(Budget!$Q12=3,Budget!$T12*0.6,IF(Budget!$Q12=4,Budget!$T12*0.4,IF(Budget!$Q12=5,Budget!$T12*0.2,0)))))","v":0}]
["Conferences",null,null,null,null,null,null,null,null,null,null,null,{"$f":"K13*L13*G13","v":0},null,{"$f":"N13*H13*G13","v":0},null,null,null,null,{"$f":"IF(R13=\"y\",IF(S13=\"Y\",P13,0),IF(S13=\"N\",0,IF(R13=\"N\",0,P13)))","v":0},{"$f":"IF(Budget!$Q13=1,Budget!$T13,IF(Budget!$Q13=2,Budget!$T13*0.8,IF(Budget!$Q13=3,Budget!$T13*0.6,IF(Budget!$Q13=4,Budget!$T13*0.4,IF(Budget!$Q13=5,Budget!$T13*0.2,0)))))","v":0}]
["Conferences",null,null,null,null,null,null,null,null,null,null,null,{"$f":"K14*L14*G14","v":0},null,{"$f":"N14*H14*G14","v":0},null,null,null,null,{"$f":"IF(R14=\"y\",IF(S14=\"Y\",P14,0),IF(S14=\"N\",0,IF(R14=\"N\",0,P14)))","v":0},{"$f":"IF(Budget!$Q14=1,Budget!$T14,IF(Budget!$Q14=2,Budget!$T14*0.8,IF(Budget!$Q14=3,Budget!$T14*0.6,IF(Budget!$Q14=4,Budget!$T14*0.4,IF(Budget!$Q14=5,Budget!$T14*0.2,0)))))","v":0}]
["Copyright Materials",null,null,"Total",null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,Table3[Total Cost])","v":0},null,{"$f":"SUBTOTAL(109,Table3[Total Income])","v":50},{"$f":"SUBTOTAL(109,Table3[Grant Requested])","v":100},null,null,null,{"$f":"SUBTOTAL(109,Table3[Eligible Grant])","v":100},{"$f":"SUBTOTAL(109,Table3[Estimated Grant])","v":0}]
["Equipment"]
["Equipment & Repair",null,"Activity Budgets"]
["Ground Hire",null,null,"Properties","Priority","Activity","Occurences","Attendance","Description","Category","Cost","Quantity","Total Cost","Income/pp","Total Income","Grant Requested","Fund Level","MG1","MG2","Eligible Grant","Given guess"]
["Hospitality",null,null,null,null,"Ferret Racing",2,25,"Arena Hire","Ground Hire",100,1,{"$f":"K19*L19*Table3182630345[[#This Row],[Occurences]]","v":200},null,{"$f":"Table3182630345[[#This Row],[Income/pp]]*Table3182630345[[#This Row],[Occurences]]*Table3182630345[[#This Row],[Attendance]]","v":0},75,null,null,null,{"$f":"IF(R19=\"y\",IF(S19=\"Y\",P19,0),IF(S19=\"N\",0,IF(R19=\"N\",0,P19)))","v":75},{"$f":"IF(Table3182630345[[#This Row],[Fund Level]]=1,Table3182630345[[#This Row],[Eligible Grant]],IF(Table3182630345[[#This Row],[Fund Level]]=2,Table3182630345[[#This Row],[Eligible Grant]]*0.8,IF(Table3182630345[[#This Row],[Fund Level]]=3,Table3182630345[[#This Row],[Eligible Grant]]*0.6,IF(Table3182630345[[#This Row],[Fund Level]]=4,Table3182630345[[#This Row],[Eligible Grant]]*0.4,IF(Table3182630345[[#This Row],[Fund Level]]=5,Table3182630345[[#This Row],[Eligible Grant]]*0.2,0)))))","v":0}]
["Instructors",null,null,null,null,null,{"$f":"G19","v":2},{"$f":"H19","v":25},"Ferret Vet ","Insurance",null,null,{"$f":"K20*L20*Table3182630345[[#This Row],[Occurences]]","v":0},null,{"$f":"Table3182630345[[#This Row],[Income/pp]]*Table3182630345[[#This Row],[Occurences]]*Table3182630345[[#This Row],[Attendance]]","v":0},null,null,null,null,0,{"$f":"IF(Table3182630345[[#This Row],[Fund Level]]=1,Table3182630345[[#This Row],[Eligible Grant]],IF(Table3182630345[[#This Row],[Fund Level]]=2,Table3182630345[[#This Row],[Eligible Grant]]*0.8,IF(Table3182630345[[#This Row],[Fund Level]]=3,Table3182630345[[#This Row],[Eligible Grant]]*0.6,IF(Table3182630345[[#This Row],[Fund Level]]=4,Table3182630345[[#This Row],[Eligible Grant]]*0.4,IF(Table3182630345[[#This Row],[Fund Level]]=5,Table3182630345[[#This Row],[Eligible Grant]]*0.2,0)))))","v":0}]
["Insurance",null,null,"Status",null,null,{"$f":"G19","v":2},{"$f":"H19","v":25},"Referee",null,null,2,{"$f":"K21*L21*Table3182630345[[#This Row],[Occurences]]","v":0},null,{"$f":"Table3182630345[[#This Row],[Income/pp]]*Table3182630345[[#This Row],[Occurences]]*Table3182630345[[#This Row],[Attendance]]","v":0},null,null,null,null,0,{"$f":"IF(Table3182630345[[#This Row],[Fund Level]]=1,Table3182630345[[#This Row],[Eligible Grant]],IF(Table3182630345[[#This Row],[Fund Level]]=2,Table3182630345[[#This Row],[Eligible Grant]]*0.8,IF(Table3182630345[[#This Row],[Fund Level]]=3,Table3182630345[[#This Row],[Eligible Grant]]*0.6,IF(Table3182630345[[#This Row],[Fund Level]]=4,Table3182630345[[#This Row],[Eligible Grant]]*0.4,IF(Table3182630345[[#This Row],[Fund Level]]=5,Table3182630345[[#This Row],[Eligible Grant]]*0.2,0)))))","v":0}]
["Printing Costs",null,null,"Core",null,null,{"$f":"G19","v":2},{"$f":"H19","v":25},"Promotional materials (50p per poster)","Publicity",0.5,null,{"$f":"K22*L22*Table3182630345[[#This Row],[Occurences]]","v":0},null,{"$f":"Table3182630345[[#This Row],[Income/pp]]*Table3182630345[[#This Row],[Occurences]]*Table3182630345[[#This Row],[Attendance]]","v":0},null,null,null,null,0,{"$f":"IF(Table3182630345[[#This Row],[Fund Level]]=1,Table3182630345[[#This Row],[Eligible Grant]],IF(Table3182630345[[#This Row],[Fund Level]]=2,Table3182630345[[#This Row],[Eligible Grant]]*0.8,IF(Table3182630345[[#This Row],[Fund Level]]=3,Table3182630345[[#This Row],[Eligible Grant]]*0.6,IF(Table3182630345[[#This Row],[Fund Level]]=4,Table3182630345[[#This Row],[Eligible Grant]]*0.4,IF(Table3182630345[[#This Row],[Fund Level]]=5,Table3182630345[[#This Row],[Eligible Grant]]*0.2,0)))))","v":0}]
["Publicity",null,null,null,null,null,{"$f":"G19","v":2},{"$f":"H19","v":25},"Minibus to get there",null,null,null,{"$f":"K23*L23*Table3182630345[[#This Row],[Occurences]]","v":0},null,{"$f":"Table3182630345[[#This Row],[Income/pp]]*Table3182630345[[#This Row],[Occurences]]*Table3182630345[[#This Row],[Attendance]]","v":0},20,null,null,null,20,{"$f":"IF(Table3182630345[[#This Row],[Fund Level]]=1,Table3182630345[[#This Row],[Eligible Grant]],IF(Table3182630345[[#This Row],[Fund Level]]=2,Table3182630345[[#This Row],[Eligible Grant]]*0.8,IF(Table3182630345[[#This Row],[Fund Level]]=3,Table3182630345[[#This Row],[Eligible Grant]]*0.6,IF(Table3182630345[[#This Row],[Fund Level]]=4,Table3182630345[[#This Row],[Eligible Grant]]*0.4,IF(Table3182630345[[#This Row],[Fund Level]]=5,Table3182630345[[#This Row],[Eligible Grant]]*0.2,0)))))","v":0}]
["Publicity",null,null,null,null,null,{"$f":"G20","v":2},{"$f":"H20","v":25},"Fuel for minibus",null,null,null,{"$f":"K24*L24*Table3182630345[[#This Row],[Occurences]]","v":0},null,{"$f":"Table3182630345[[#This Row],[Income/pp]]*Table3182630345[[#This Row],[Occurences]]*Table3182630345[[#This Row],[Attendance]]","v":0},null,null,null,null,0,{"$f":"IF(Table3182630345[[#This Row],[Fund Level]]=1,Table3182630345[[#This Row],[Eligible Grant]],IF(Table3182630345[[#This Row],[Fund Level]]=2,Table3182630345[[#This Row],[Eligible Grant]]*0.8,IF(Table3182630345[[#This Row],[Fund Level]]=3,Table3182630345[[#This Row],[Eligible Grant]]*0.6,IF(Table3182630345[[#This Row],[Fund Level]]=4,Table3182630345[[#This Row],[Eligible Grant]]*0.4,IF(Table3182630345[[#This Row],[Fund Level]]=5,Table3182630345[[#This Row],[Eligible Grant]]*0.2,0)))))","v":0}]
["Publicity",null,null,null,null,null,{"$f":"G21","v":2},12,"Early bird tickets",null,null,null,{"$f":"K25*L25*Table3182630345[[#This Row],[Occurences]]","v":0},null,{"$f":"Table3182630345[[#This Row],[Income/pp]]*Table3182630345[[#This Row],[Occurences]]*Table3182630345[[#This Row],[Attendance]]","v":0},null,null,null,null,0,{"$f":"IF(Table3182630345[[#This Row],[Fund Level]]=1,Table3182630345[[#This Row],[Eligible Grant]],IF(Table3182630345[[#This Row],[Fund Level]]=2,Table3182630345[[#This Row],[Eligible Grant]]*0.8,IF(Table3182630345[[#This Row],[Fund Level]]=3,Table3182630345[[#This Row],[Eligible Grant]]*0.6,IF(Table3182630345[[#This Row],[Fund Level]]=4,Table3182630345[[#This Row],[Eligible Grant]]*0.4,IF(Table3182630345[[#This Row],[Fund Level]]=5,Table3182630345[[#This Row],[Eligible Grant]]*0.2,0)))))","v":0}]
["Publicity",null,null,null,null,null,{"$f":"G22","v":2},null,"Normal tickets",null,null,null,{"$f":"K26*L26*Table3182630345[[#This Row],[Occurences]]","v":0},null,{"$f":"Table3182630345[[#This Row],[Income/pp]]*Table3182630345[[#This Row],[Occurences]]*Table3182630345[[#This Row],[Attendance]]","v":0},null,null,null,null,0,{"$f":"IF(Table3182630345[[#This Row],[Fund Level]]=1,Table3182630345[[#This Row],[Eligible Grant]],IF(Table3182630345[[#This Row],[Fund Level]]=2,Table3182630345[[#This Row],[Eligible Grant]]*0.8,IF(Table3182630345[[#This Row],[Fund Level]]=3,Table3182630345[[#This Row],[Eligible Grant]]*0.6,IF(Table3182630345[[#This Row],[Fund Level]]=4,Table3182630345[[#This Row],[Eligible Grant]]*0.4,IF(Table3182630345[[#This Row],[Fund Level]]=5,Table3182630345[[#This Row],[Eligible Grant]]*0.2,0)))))","v":0}]
["Publicity",null,null,"Total",null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,Table3182630345[Total Cost])","v":200},null,{"$f":"SUBTOTAL(109,Table3182630345[Total Income])","v":0},{"$f":"SUBTOTAL(109,Table3182630345[Grant Requested])","v":95},null,null,null,{"$f":"SUBTOTAL(109,Table3182630345[Eligible Grant])","v":95},{"$f":"SUBTOTAL(109,Table3182630345[Given guess])","v":0}]
["Publicity"]
["Publicity"]
["Referees"]
["Travel Expenditure"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]

{"sheet":"Backup","index":1,"n_rows":29,"n_cols":40,"rows_kept":29,"cut":false,"hidden":false,"merged":[[83,117,87,117],[83,131,87,131],[83,132,87,132],[1,3,1,7],[3,10,3,11],[4,10,4,11],[6,9,6,10],[7,9,7,10],[83,85,87,85],[83,99,87,99],[83,100,87,100],[83,101,87,101],[83,115,87,115],[83,116,87,116],[83,67,87,67],[83,68,87,68],[83,69,87,69],[83,83,87,83],[83,84,87,84],[83,149,87,149],[83,163,87,163],[83,164,87,164],[83,165,87,165],[83,179,87,179],[83,180,87,180],[83,133,87,133],[83,147,87,147],[83,148,87,148],[83,213,87,213],[83,227,87,227],[83,228,87,228],[83,229,87,229],[83,243,87,243],[83,244,87,244],[83,181,87,181],[83,195,87,195],[83,196,87,196],[83,197,87,197],[83,211,87,211],[83,212,87,212],[83,277,87,277],[83,291,87,291],[83,292,87,292],[83,293,87,293],[83,307,87,307],[83,308,87,308],[83,245,87,245],[83,259,87,259],[83,260,87,260],[83,261,87,261],[83,275,87,275],[83,276,87,276],[83,341,87,341],[83,355,87,355],[83,356,87,356],[83,357,87,357],[83,371,87,371],[83,372,87,372],[83,309,87,309],[83,323,87,323],[83,324,87,324],[83,325,87,325],[83,339,87,339],[83,340,87,340],[83,405,87,405],[83,419,87,419],[83,420,87,420],[83,421,87,421],[83,435,87,435],[83,436,87,436],[83,373,87,373],[83,387,87,387],[83,388,87,388],[83,389,87,389],[83,403,87,403],[83,404,87,404],[83,469,87,469],[83,483,87,483],[83,484,87,484],[83,485,87,485],[83,499,87,499],[83,500,87,500],[83,437,87,437],[83,451,87,451],[83,452,87,452],[83,453,87,453],[83,467,87,467],[83,468,87,468],[83,533,87,533],[83,547,87,547],[83,548,87,548],[83,549,87,549],[83,563,87,563],[83,564,87,564],[83,501,87,501],[83,515,87,515],[83,516,87,516],[83,517,87,517],[83,531,87,531],[83,532,87,532],[83,597,87,597],[83,611,87,611],[83,612,87,612],[83,613,87,613],[83,627,87,627],[83,628,87,628],[83,565,87,565],[83,579,87,579],[83,580,87,580],[83,581,87,581],[83,595,87,595],[83,596,87,596],[83,661,87,661],[83,675,87,675],[83,676,87,676],[83,677,87,677],[83,691,87,691],[83,692,87,692],[83,629,87,629],[83,643,87,643],[83,644,87,644],[83,645,87,645],[83,659,87,659],[83,660,87,660],[83,725,87,725],[83,739,87,739],[83,740,87,740],[83,741,87,741],[83,755,87,755],[83,756,87,756],[83,693,87,693],[83,707,87,707],[83,708,87,708],[83,709,87,709],[83,723,87,723],[83,724,87,724],[83,789,87,789],[83,803,87,803],[83,804,87,804],[83,805,87,805],[83,819,87,819],[83,820,87,820],[83,757,87,757],[83,771,87,771],[83,772,87,772],[83,773,87,773],[83,787,87,787],[83,788,87,788],[83,853,87,853],[83,867,87,867],[83,868,87,868],[83,869,87,869],[83,883,87,883],[83,884,87,884],[83,821,87,821],[83,835,87,835],[83,836,87,836],[83,837,87,837],[83,851,87,851],[83,852,87,852],[83,917,87,917],[83,931,87,931],[83,932,87,932],[83,933,87,933],[83,947,87,947],[83,948,87,948],[83,885,87,885],[83,899,87,899],[83,900,87,900],[83,901,87,901],[83,915,87,915],[83,916,87,916],[83,981,87,981],[83,995,87,995],[83,996,87,996],[83,997,87,997],[83,1011,87,1011],[83,1012,87,1012],[83,949,87,949],[83,963,87,963],[83,964,87,964],[83,965,87,965],[83,979,87,979],[83,980,87,980],[83,1045,87,1045],[83,1059,87,1059],[83,1060,87,1060],[83,1061,87,1061],[83,1075,87,1075],[83,1076,87,1076],[83,1013,87,1013],[83,1027,87,1027],[83,1028,87,1028],[83,1029,87,1029],[83,1043,87,1043],[83,1044,87,1044],[83,1109,87,1109],[83,1123,87,1123],[83,1124,87,1124],[83,1125,87,1125],[83,1139,87,1139],[83,1140,87,1140],[83,1077,87,1077],[83,1091,87,1091],[83,1092,87,1092],[83,1093,87,1093],[83,1107,87,1107],[83,1108,87,1108],[83,1173,87,1173],[83,1187,87,1187],[83,1188,87,1188],[83,1189,87,1189],[83,1203,87,1203],[83,1204,87,1204],[83,1141,87,1141],[83,1155,87,1155],[83,1156,87,1156],[83,1157,87,1157],[83,1171,87,1171],[83,1172,87,1172],[83,1237,87,1237],[83,1251,87,1251],[83,1252,87,1252],[83,1253,87,1253],[83,1267,87,1267],[83,1268,87,1268],[83,1205,87,1205],[83,1219,87,1219],[83,1220,87,1220],[83,1221,87,1221],[83,1235,87,1235],[83,1236,87,1236],[83,1301,87,1301],[83,1315,87,1315],[83,1316,87,1316],[83,1317,87,1317],[83,1331,87,1331],[83,1332,87,1332],[83,1269,87,1269],[83,1283,87,1283],[83,1284,87,1284],[83,1285,87,1285],[83,1299,87,1299],[83,1300,87,1300],[83,1365,87,1365],[83,1379,87,1379],[83,1380,87,1380],[83,1381,87,1381],[83,1395,87,1395],[83,1396,87,1396],[83,1333,87,1333],[83,1347,87,1347],[83,1348,87,1348],[83,1349,87,1349],[83,1363,87,1363],[83,1364,87,1364],[83,1429,87,1429],[83,1443,87,1443],[83,1444,87,1444],[83,1445,87,1445],[83,1459,87,1459],[83,1460,87,1460],[83,1397,87,1397],[83,1411,87,1411],[83,1412,87,1412],[83,1413,87,1413],[83,1427,87,1427],[83,1428,87,1428],[83,1493,87,1493],[83,1507,87,1507],[83,1508,87,1508],[83,1509,87,1509],[83,1523,87,1523],[83,1524,87,1524],[83,1461,87,1461],[83,1475,87,1475],[83,1476,87,1476],[83,1477,87,1477],[83,1491,87,1491],[83,1492,87,1492],[83,1557,87,1557],[83,1571,87,1571],[83,1572,87,1572],[83,1573,87,1573],[83,1587,87,1587],[83,1588,87,1588],[83,1525,87,1525],[83,1539,87,1539],[83,1540,87,1540],[83,1541,87,1541],[83,1555,87,1555],[83,1556,87,1556],[83,1621,87,1621],[83,1635,87,1635],[83,1636,87,1636],[83,1637,87,1637],[83,1651,87,1651],[83,1652,87,1652],[83,1589,87,1589],[83,1603,87,1603],[83,1604,87,1604],[83,1605,87,1605],[83,1619,87,1619],[83,1620,87,1620],[83,1685,87,1685],[83,1699,87,1699],[83,1700,87,1700],[83,1701,87,1701],[83,1715,87,1715],[83,1716,87,1716],[83,1653,87,1653],[83,1667,87,1667],[83,1668,87,1668],[83,1669,87,1669],[83,1683,87,1683],[83,1684,87,1684],[83,1749,87,1749],[83,1763,87,1763],[83,1764,87,1764],[83,1765,87,1765],[83,1779,87,1779],[83,1780,87,1780],[83,1717,87,1717],[83,1731,87,1731],[83,1732,87,1732],[83,1733,87,1733],[83,1747,87,1747],[83,1748,87,1748],[83,1813,87,1813],[83,1827,87,1827],[83,1828,87,1828],[83,1829,87,1829],[83,1843,87,1843],[83,1844,87,1844],[83,1781,87,1781],[83,1795,87,1795],[83,1796,87,1796],[83,1797,87,1797],[83,1811,87,1811],[83,1812,87,1812],[83,1877,87,1877],[83,1891,87,1891],[83,1892,87,1892],[83,1893,87,1893],[83,1907,87,1907],[83,1908,87,1908],[83,1845,87,1845],[83,1859,87,1859],[83,1860,87,1860],[83,1861,87,1861],[83,1875,87,1875],[83,1876,87,1876],[83,1941,87,1941],[83,1955,87,1955],[83,1956,87,1956],[83,1957,87,1957],[83,1971,87,1971],[83,1972,87,1972],[83,1909,87,1909],[83,1923,87,1923],[83,1924,87,1924],[83,1925,87,1925],[83,1939,87,1939],[83,1940,87,1940],[83,2005,87,2005],[83,2019,87,2019],[83,2020,87,2020],[83,2021,87,2021],[83,2035,87,2035],[83,2036,87,2036],[83,1973,87,1973],[83,1987,87,1987],[83,1988,87,1988],[83,1989,87,1989],[83,2003,87,2003],[83,2004,87,2004],[83,2069,87,2069],[83,2083,87,2083],[83,2084,87,2084],[83,2085,87,2085],[83,2099,87,2099],[83,2100,87,2100],[83,2037,87,2037],[83,2051,87,2051],[83,2052,87,2052],[83,2053,87,2053],[83,2067,87,2067],[83,2068,87,2068],[83,2133,87,2133],[83,2147,87,2147],[83,2148,87,2148],[83,2149,87,2149],[83,2163,87,2163],[83,2164,87,2164],[83,2101,87,2101],[83,2115,87,2115],[83,2116,87,2116],[83,2117,87,2117],[83,2131,87,2131],[83,2132,87,2132],[83,2197,87,2197],[83,2211,87,2211],[83,2212,87,2212],[83,2213,87,2213],[83,2227,87,2227],[83,2228,87,2228],[83,2165,87,2165],[83,2179,87,2179],[83,2180,87,2180],[83,2181,87,2181],[83,2195,87,2195],[83,2196,87,2196],[83,2261,87,2261],[83,2275,87,2275],[83,2276,87,2276],[83,2277,87,2277],[83,2291,87,2291],[83,2292,87,2292],[83,2229,87,2229],[83,2243,87,2243],[83,2244,87,2244],[83,2245,87,2245],[83,2259,87,2259],[83,2260,87,2260],[83,2325,87,2325],[83,2339,87,2339],[83,2340,87,2340],[83,2341,87,2341],[83,2355,87,2355],[83,2356,87,2356],[83,2293,87,2293],[83,2307,87,2307],[83,2308,87,2308],[83,2309,87,2309],[83,2323,87,2323],[83,2324,87,2324],[83,2389,87,2389],[83,2403,87,2403],[83,2404,87,2404],[83,2405,87,2405],[83,2419,87,2419],[83,2420,87,2420],[83,2357,87,2357],[83,2371,87,2371],[83,2372,87,2372],[83,2373,87,2373],[83,2387,87,2387],[83,2388,87,2388],[83,2453,87,2453],[83,2467,87,2467],[83,2468,87,2468],[83,2469,87,2469],[83,2483,87,2483],[83,2484,87,2484],[83,2421,87,2421],[83,2435,87,2435],[83,2436,87,2436],[83,2437,87,2437],[83,2451,87,2451],[83,2452,87,2452],[83,2517,87,2517],[83,2531,87,2531],[83,2532,87,2532],[83,2533,87,2533],[83,2547,87,2547],[83,2548,87,2548],[83,2485,87,2485],[83,2499,87,2499],[83,2500,87,2500],[83,2501,87,2501],[83,2515,87,2515],[83,2516,87,2516],[83,2581,87,2581],[83,2595,87,2595],[83,2596,87,2596],[83,2597,87,2597],[83,2611,87,2611],[83,2612,87,2612],[83,2549,87,2549],[83,2563,87,2563],[83,2564,87,2564],[83,2565,87,2565],[83,2579,87,2579],[83,2580,87,2580],[83,2645,87,2645],[83,2659,87,2659],[83,2660,87,2660],[83,2661,87,2661],[83,2675,87,2675],[83,2676,87,2676],[83,2613,87,2613],[83,2627,87,2627],[83,2628,87,2628],[83,2629,87,2629],[83,2643,87,2643],[83,2644,87,2644],[83,2709,87,2709],[83,2723,87,2723],[83,2724,87,2724],[83,2725,87,2725],[83,2739,87,2739],[83,2740,87,2740],[83,2677,87,2677],[83,2691,87,2691],[83,2692,87,2692],[83,2693,87,2693],[83,2707,87,2707],[83,2708,87,2708],[83,2773,87,2773],[83,2787,87,2787],[83,2788,87,2788],[83,2789,87,2789],[83,2803,87,2803],[83,2804,87,2804],[83,2741,87,2741],[83,2755,87,2755],[83,2756,87,2756],[83,2757,87,2757],[83,2771,87,2771],[83,2772,87,2772],[83,2837,87,2837],[83,2851,87,2851],[83,2852,87,2852],[83,2853,87,2853],[83,2867,87,2867],[83,2868,87,2868],[83,2805,87,2805],[83,2819,87,2819],[83,2820,87,2820],[83,2821,87,2821],[83,2835,87,2835],[83,2836,87,2836],[83,2901,87,2901],[83,2915,87,2915],[83,2916,87,2916],[83,2917,87,2917],[83,2931,87,2931],[83,2932,87,2932],[83,2869,87,2869],[83,2883,87,2883],[83,2884,87,2884],[83,2885,87,2885],[83,2899,87,2899],[83,2900,87,2900],[83,2965,87,2965],[83,2979,87,2979],[83,2980,87,2980],[83,2981,87,2981],[83,2995,87,2995],[83,2996,87,2996],[83,2933,87,2933],[83,2947,87,2947],[83,2948,87,2948],[83,2949,87,2949],[83,2963,87,2963],[83,2964,87,2964],[83,3029,87,3029],[83,3043,87,3043],[83,3044,87,3044],[83,3045,87,3045],[83,3059,87,3059],[83,3060,87,3060],[83,2997,87,2997],[83,3011,87,3011],[83,3012,87,3012],[83,3013,87,3013],[83,3027,87,3027],[83,3028,87,3028],[83,3093,87,3093],[83,3107,87,3107],[83,3108,87,3108],[83,3109,87,3109],[83,3123,87,3123],[83,3124,87,3124],[83,3061,87,3061],[83,3075,87,3075],[83,3076,87,3076],[83,3077,87,3077],[83,3091,87,3091],[83,3092,87,3092],[83,3157,87,3157],[83,3171,87,3171],[83,3172,87,3172],[83,3173,87,3173],[83,3187,87,3187],[83,3188,87,3188],[83,3125,87,3125],[83,3139,87,3139],[83,3140,87,3140],[83,3141,87,3141],[83,3155,87,3155],[83,3156,87,3156],[83,3221,87,3221],[83,3235,87,3235],[83,3236,87,3236],[83,3237,87,3237],[83,3251,87,3251],[83,3252,87,3252],[83,3189,87,3189],[83,3203,87,3203],[83,3204,87,3204],[83,3205,87,3205],[83,3219,87,3219],[83,3220,87,3220],[83,3285,87,3285],[83,3299,87,3299],[83,3300,87,3300],[83,3301,87,3301],[83,3315,87,3315],[83,3316,87,3316],[83,3253,87,3253],[83,3267,87,3267],[83,3268,87,3268],[83,3269,87,3269],[83,3283,87,3283],[83,3284,87,3284],[83,3349,87,3349],[83,3363,87,3363],[83,3364,87,3364],[83,3365,87,3365],[83,3379,87,3379],[83,3380,87,3380],[83,3317,87,3317],[83,3331,87,3331],[83,3332,87,3332],[83,3333,87,3333],[83,3347,87,3347],[83,3348,87,3348],[83,3413,87,3413],[83,3427,87,3427],[83,3428,87,3428],[83,3429,87,3429],[83,3443,87,3443],[83,3444,87,3444],[83,3381,87,3381],[83,3395,87,3395],[83,3396,87,3396],[83,3397,87,3397],[83,3411,87,3411],[83,3412,87,3412],[83,3477,87,3477],[83,3491,87,3491],[83,3492,87,3492],[83,3493,87,3493],[83,3507,87,3507],[83,3508,87,3508],[83,3445,87,3445],[83,3459,87,3459],[83,3460,87,3460],[83,3461,87,3461],[83,3475,87,3475],[83,3476,87,3476],[83,3541,87,3541],[83,3555,87,3555],[83,3556,87,3556],[83,3557,87,3557],[83,3571,87,3571],[83,3572,87,3572],[83,3509,87,3509],[83,3523,87,3523],[83,3524,87,3524],[83,3525,87,3525],[83,3539,87,3539],[83,3540,87,3540],[83,3605,87,3605],[83,3619,87,3619],[83,3620,87,3620],[83,3621,87,3621],[83,3635,87,3635],[83,3636,87,3636],[83,3573,87,3573],[83,3587,87,3587],[83,3588,87,3588],[83,3589,87,3589],[83,3603,87,3603],[83,3604,87,3604],[83,3669,87,3669],[83,3683,87,3683],[83,3684,87,3684],[83,3685,87,3685],[83,3699,87,3699],[83,3700,87,3700],[83,3637,87,3637],[83,3651,87,3651],[83,3652,87,3652],[83,3653,87,3653],[83,3667,87,3667],[83,3668,87,3668],[83,3733,87,3733],[83,3747,87,3747],[83,3748,87,3748],[83,3749,87,3749],[83,3763,87,3763],[83,3764,87,3764],[83,3701,87,3701],[83,3715,87,3715],[83,3716,87,3716],[83,3717,87,3717],[83,3731,87,3731],[83,3732,87,3732],[83,3797,87,3797],[83,3811,87,3811],[83,3812,87,3812],[83,3813,87,3813],[83,3827,87,3827],[83,3828,87,3828],[83,3765,87,3765],[83,3779,87,3779],[83,3780,87,3780],[83,3781,87,3781],[83,3795,87,3795],[83,3796,87,3796],[83,3861,87,3861],[83,3875,87,3875],[83,3876,87,3876],[83,3877,87,3877],[83,3891,87,3891],[83,3892,87,3892],[83,3829,87,3829],[83,3843,87,3843],[83,3844,87,3844],[83,3845,87,3845],[83,3859,87,3859],[83,3860,87,3860],[83,3925,87,3925],[83,3939,87,3939],[83,3940,87,3940],[83,3941,87,3941],[83,3955,87,3955],[83,3956,87,3956],[83,3893,87,3893],[83,3907,87,3907],[83,3908,87,3908],[83,3909,87,3909],[83,3923,87,3923],[83,3924,87,3924],[83,3989,87,3989],[83,4003,87,4003],[83,4004,87,4004],[83,4005,87,4005],[83,4019,87,4019],[83,4020,87,4020],[83,3957,87,3957],[83,3971,87,3971],[83,3972,87,3972],[83,3973,87,3973],[83,3987,87,3987],[83,3988,87,3988],[83,4053,87,4053],[83,4067,87,4067],[83,4068,87,4068],[83,4069,87,4069],[83,4021,87,4021],[83,4035,87,4035],[83,4036,87,4036],[83,4037,87,4037],[83,4051,87,4051],[83,4052,87,4052]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Properties","Priority","Activity","Occurences","Attendance","Description","Category","Cost","Quantity","Total Cost","Income/pp","Total Income","Grant Requested","Fund Level","MG1","MG2","Eligible Grant","Given guess"]
["Core",null,null,"GREEN = EDIT; YELLOW = EDIT IF NEEDED",null,null,null,null,null,null,"Annual Budgeting 2",null,null,null,null,null,null,null,null,null,null,"1 - Most Important",null,null,null,null,null,null,null,null,null,{"$f":"AD2*AE2*Table318263034[[#This Row],[Occurences]]","v":0},null,{"$f":"Table318263034[[#This Row],[Income/pp]]*Table318263034[[#This Row],[Occurences]]*Table318263034[[#This Row],[Attendance]]","v":0},null,null,null,null,{"$f":"IF(AK2=\"y\",IF(AL2=\"Y\",AI2,0),IF(AL2=\"N\",0,IF(AK2=\"N\",0,AI2)))","v":0},{"$f":"IF(Table318263034[[#This Row],[Fund Level]]=1,Table318263034[[#This Row],[Eligible Grant]],IF(Table318263034[[#This Row],[Fund Level]]=2,Table318263034[[#This Row],[Eligible Grant]]*0.8,IF(Table318263034[[#This Row],[Fund Level]]=3,Table318263034[[#This Row],[Eligible Grant]]*0.6,IF(Table318263034[[#This Row],[Fund Level]]=4,Table318263034[[#This Row],[Eligible Grant]]*0.4,IF(Table318263034[[#This Row],[Fund Level]]=5,Table318263034[[#This Row],[Eligible Grant]]*0.2,0)))))","v":0}]
["Not Core",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,{"$f":"Z2","v":0},{"$f":"AA2","v":0},null,null,null,null,{"$f":"AD3*AE3*Table318263034[[#This Row],[Occurences]]","v":0},null,{"$f":"Table318263034[[#This Row],[Income/pp]]*Table318263034[[#This Row],[Occurences]]*Table318263034[[#This Row],[Attendance]]","v":0},null,null,null,null,{"$f":"IF(AK3=\"y\",IF(AL3=\"Y\",AI3,0),IF(AL3=\"N\",0,IF(AK3=\"N\",0,AI3)))","v":0},{"$f":"IF(Table318263034[[#This Row],[Fund Level]]=1,Table318263034[[#This Row],[Eligible Grant]],IF(Table318263034[[#This Row],[Fund Level]]=2,Table318263034[[#This Row],[Eligible Grant]]*0.8,IF(Table318263034[[#This Row],[Fund Level]]=3,Table318263034[[#This Row],[Eligible Grant]]*0.6,IF(Table318263034[[#This Row],[Fund Level]]=4,Table318263034[[#This Row],[Eligible Grant]]*0.4,IF(Table318263034[[#This Row],[Fund Level]]=5,Table318263034[[#This Row],[Eligible Grant]]*0.2,0)))))","v":0}]
["Welfare",null,null,null,null,"SGI","Income","Expenditure","Deficit / Surplus","No. Members","Recommended Membership",null,"Grant Request","Eligible Grant","Given Grant","Surplus",null,null,null,null,null,3,"Status",null,null,{"$f":"Z2","v":0},{"$f":"AA2","v":0},null,null,null,null,{"$f":"AD4*AE4*Table318263034[[#This Row],[Occurences]]","v":0},null,{"$f":"Table318263034[[#This Row],[Income/pp]]*Table318263034[[#This Row],[Occurences]]*Table318263034[[#This Row],[Attendance]]","v":0},null,null,null,null,{"$f":"IF(AK4=\"y\",IF(AL4=\"Y\",AI4,0),IF(AL4=\"N\",0,IF(AK4=\"N\",0,AI4)))","v":0},{"$f":"IF(Table318263034[[#This Row],[Fund Level]]=1,Table318263034[[#This Row],[Eligible Grant]],IF(Table318263034[[#This Row],[Fund Level]]=2,Table318263034[[#This Row],[Eligible Grant]]*0.8,IF(Table318263034[[#This Row],[Fund Level]]=3,Table318263034[[#This Row],[Eligible Grant]]*0.6,IF(Table318263034[[#This Row],[Fund Level]]=4,Table318263034[[#This Row],[Eligible Grant]]*0.4,IF(Table318263034[[#This Row],[Fund Level]]=5,Table318263034[[#This Row],[Eligible Grant]]*0.2,0)))))","v":0}]
["Exec",null,null,null,null,null,{"$f":"SUMIF($D$10:$D$2109,\"Total\",$O$10:$O$2109)","v":0},{"$f":"SUMIF($D$10:$D$2109,\"Total\",$M$10:$M$2109)","v":0},{"$f":"G5-H5","v":0},null,{"$f":"IF(I5<0,ABS(I5/J5),0)","v":0},null,{"$f":"SUMIF($D$10:$D$2109,\"Total\",$P$10:$P$2109)","v":0},{"$f":"SUMIF($D$9:$D$2109,\"Total\",$S$9:$S$2095)","v":0},null,null,null,null,null,null,null,4,"Core",null,null,{"$f":"Z2","v":0},{"$f":"AA2","v":0},null,null,null,null,{"$f":"AD5*AE5*Table318263034[[#This Row],[Occurences]]","v":0},null,{"$f":"Table318263034[[#This Row],[Income/pp]]*Table318263034[[#This Row],[Occurences]]*Table318263034[[#This Row],[Attendance]]","v":0},null,null,null,null,{"$f":"IF(AK5=\"y\",IF(AL5=\"Y\",AI5,0),IF(AL5=\"N\",0,IF(AK5=\"N\",0,AI5)))","v":0},{"$f":"IF(Table318263034[[#This Row],[Fund Level]]=1,Table318263034[[#This Row],[Eligible Grant]],IF(Table318263034[[#This Row],[Fund Level]]=2,Table318263034[[#This Row],[Eligible Grant]]*0.8,IF(Table318263034[[#This Row],[Fund Level]]=3,Table318263034[[#This Row],[Eligible Grant]]*0.6,IF(Table318263034[[#This Row],[Fund Level]]=4,Table318263034[[#This Row],[Eligible Grant]]*0.4,IF(Table318263034[[#This Row],[Fund Level]]=5,Table318263034[[#This Row],[Eligible Grant]]*0.2,0)))))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5 - Least Important",null,null,null,{"$f":"Z2","v":0},{"$f":"AA2","v":0},null,null,null,null,{"$f":"AD6*AE6*Table318263034[[#This Row],[Occurences]]","v":0},null,{"$f":"Table318263034[[#This Row],[Income/pp]]*Table318263034[[#This Row],[Occurences]]*Table318263034[[#This Row],[Attendance]]","v":0},null,null,null,null,{"$f":"IF(AK6=\"y\",IF(AL6=\"Y\",AI6,0),IF(AL6=\"N\",0,IF(AK6=\"N\",0,AI6)))","v":0},{"$f":"IF(Table318263034[[#This Row],[Fund Level]]=1,Table318263034[[#This Row],[Eligible Grant]],IF(Table318263034[[#This Row],[Fund Level]]=2,Table318263034[[#This Row],[Eligible Grant]]*0.8,IF(Table318263034[[#This Row],[Fund Level]]=3,Table318263034[[#This Row],[Eligible Grant]]*0.6,IF(Table318263034[[#This Row],[Fund Level]]=4,Table318263034[[#This Row],[Eligible Grant]]*0.4,IF(Table318263034[[#This Row],[Fund Level]]=5,Table318263034[[#This Row],[Eligible Grant]]*0.2,0)))))","v":0}]
[null,null,null,null,null,null,null,null,null,"Desired Membership Cost",null,"Net Position",null,null,null,null,null,null,null,null,null,1,"Total",null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,Table318263034[Total Cost])","v":0},null,{"$f":"SUBTOTAL(109,Table318263034[Total Income])","v":0},{"$f":"SUBTOTAL(109,Table318263034[Grant Requested])","v":0},null,null,null,{"$f":"SUBTOTAL(109,Table318263034[Eligible Grant])","v":0},{"$f":"SUBTOTAL(109,Table318263034[Given guess])","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"(G5-H5)+(J8*J5)","v":0},null,null,null,null,null,null,null,null,null,2]
[null,null,"General Lines",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
["Accommodation",null,null,"Properties","Status","Activity","Occurrences","Attendance","Description","Category","Cost","Quantity","Total Cost","Income/pp","Total Income","Grant Requested","MG1","MG2","Eligible Grant",null,null,4]
["Affiliation Fees",null,null,null,null,null,null,null,null,null,null,null,{"$f":"K11*L11*G11","v":0},null,{"$f":"N11*H11*G11","v":0},null,"y","y",{"$f":"IF(Q11=\"y\",IF(R11=\"Y\",P11,0),IF(R11=\"N\",0,IF(Q11=\"N\",0,P11)))","v":0},null,null,5,null,null,null,"Overall income","Overall expenditure",null,"Deficit / Surplus","Membership","Membership cost","Grant Request","Eligible Grant","Given Grant","Surplus"]
["Competitions",null,null,null,null,null,null,null,null,null,null,null,{"$f":"K12*L12*G12","v":0},null,{"$f":"N12*H12*G12","v":0},null,"n","y",{"$f":"IF(Q12=\"y\",IF(R12=\"Y\",P12,0),IF(R12=\"N\",0,IF(Q12=\"N\",0,P12)))","v":0},null,null,null,null,null,null,{"$f":"SUMIF(Budget!$D$10:'Budget'!$D$2140,\"Total\",Budget!$O$10:'Budget'!$N$2140)","v":0},{"$f":"SUMIF(Budget!$D$10:'Budget'!$D$2140,\"Total\",Budget!$M$10:'Budget'!$L$2140)","v":0},null,{"$f":"Z12-AA12","v":0},{"$f":"Budget!J5","v":30},{"$f":"ABS(AC12/AD12)","v":0},{"$f":"SUMIF(Budget!$D$10:'Budget'!$D$2140,\"Total\",Budget!$P$10:'Budget'!$O$2140)","v":50},{"$f":"SUMIF(Budget!$D$159:'Budget'!$D$2140,\"Total\",Budget!$R$145:'Budget'!$R$2126)","v":0}]
["Conferences",null,null,null,null,null,null,null,null,null,null,null,{"$f":"K13*L13*G13","v":0},null,{"$f":"N13*H13*G13","v":0},null,"n","n",0]
["Conferences",null,null,null,null,null,null,null,null,null,null,null,{"$f":"K14*L14*G14","v":0},null,{"$f":"N14*H14*G14","v":0},null,"n","n",0]
["Consumables",null,null,"Total",null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,Table1219[Total Cost])","v":0},null,{"$f":"SUBTOTAL(109,Table1219[Total Income])","v":0},{"$f":"SUBTOTAL(109,Table1219[Grant Requested])","v":0},null,null,{"$f":"SUBTOTAL(109,Table1219[Eligible Grant])","v":0}]
["Copyright Materials"]
["Equipment"]
["Equipment & Repair",null,"Activity Budgets"]
["Ground Hire",null,null,"Properties","Status","Activity","Occurences","Attendance","Description","Category","Cost","Quantity","Total Cost","Income/pp","Total Income","Grant Requested","MG1","MG2","Eligible Grant"]
["Hospitality",null,null,null,null,null,null,null,null,null,null,null,{"$f":"K20*L20*Table3181520[[#This Row],[Occurences]]","v":0},null,{"$f":"Table3181520[[#This Row],[Income/pp]]*Table3181520[[#This Row],[Occurences]]*Table3181520[[#This Row],[Attendance]]","v":0},null,null,null,{"$f":"IF(Q20=\"y\",IF(R20=\"Y\",P20,0),IF(R20=\"N\",0,IF(Q20=\"N\",0,P20)))","v":0}]
["Instructors",null,null,null,null,null,{"$f":"G20","v":0},{"$f":"H20","v":0},null,null,null,null,{"$f":"K21*L21*Table3181520[[#This Row],[Occurences]]","v":0},null,{"$f":"Table3181520[[#This Row],[Income/pp]]*Table3181520[[#This Row],[Occurences]]*Table3181520[[#This Row],[Attendance]]","v":0},null,null,null,{"$f":"IF(Q21=\"y\",IF(R21=\"Y\",P21,0),IF(R21=\"N\",0,IF(Q21=\"N\",0,P21)))","v":0}]
["Insurance",null,null,"PRIORITY BELOW",null,null,{"$f":"G20","v":0},{"$f":"H20","v":0},null,null,null,null,{"$f":"K22*L22*Table3181520[[#This Row],[Occurences]]","v":0},null,{"$f":"Table3181520[[#This Row],[Income/pp]]*Table3181520[[#This Row],[Occurences]]*Table3181520[[#This Row],[Attendance]]","v":0},null,null,null,{"$f":"IF(Q22=\"y\",IF(R22=\"Y\",P22,0),IF(R22=\"N\",0,IF(Q22=\"N\",0,P22)))","v":0}]
["Printing Costs",null,null,1,null,null,{"$f":"G20","v":0},{"$f":"H20","v":0},null,null,null,null,{"$f":"K23*L23*Table3181520[[#This Row],[Occurences]]","v":0},null,{"$f":"Table3181520[[#This Row],[Income/pp]]*Table3181520[[#This Row],[Occurences]]*Table3181520[[#This Row],[Attendance]]","v":0},null,null,null,{"$f":"IF(Q23=\"y\",IF(R23=\"Y\",P23,0),IF(R23=\"N\",0,IF(Q23=\"N\",0,P23)))","v":0}]
["Publicity",null,null,null,null,null,{"$f":"G20","v":0},{"$f":"H20","v":0},null,null,null,null,{"$f":"K24*L24*Table3181520[[#This Row],[Occurences]]","v":0},null,{"$f":"Table3181520[[#This Row],[Income/pp]]*Table3181520[[#This Row],[Occurences]]*Table3181520[[#This Row],[Attendance]]","v":0},null,null,null,{"$f":"IF(Q24=\"y\",IF(R24=\"Y\",P24,0),IF(R24=\"N\",0,IF(Q24=\"N\",0,P24)))","v":0}]
["Publicity",null,null,"Total",null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,Table3181520[Total Cost])","v":0},null,{"$f":"SUBTOTAL(109,Table3181520[Total Income])","v":0},{"$f":"SUBTOTAL(109,Table3181520[Grant Requested])","v":0},null,null,{"$f":"SUBTOTAL(109,Table3181520[Eligible Grant])","v":0}]
["Publicity"]
["Publicity"]
["Referees"]
["Travel Expenditure"]