{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["START","PROJECT PARAMETERS","PROJECT DETAILS","PROJECT TOTALS"],"not_rendered":{"charts":2,"defined_names":3,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"START","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"ABOUT THIS TEMPLATE"]
[null,"Track Project Parameters, Project Details, and Project Totals in this Event Planning Tracker workbook."]
[null,"Enter information in Project Parameters worksheet to update column charts, and in Project Details worksheet. PivotTable in Project Totals worksheet is automatically updated."]
[null,"Fill in Company Name in Parameters worksheet and it will automatically be updated in other worksheets."]
[null,"Note:  "]
[null,"Additional Instructions have been provided in column A of each worksheet in EVENT PLANNING TRACKER workbook. This text has been intentionally hidden. To remove text, select column A, then select DELETE. To unhide text, select column A, then change the font colour."]
[null,"To learn more about tables in worksheets, press SHIFT and then F10 within a table, select the TABLE option, and then select ALTERNATIVE TEXT."]

{"sheet":"PROJECT PARAMETERS","index":1,"n_rows":19,"n_cols":9,"rows_kept":19,"merged":[[23,1,42,3]]}
[null,"Company Name"]
[null,"Event Management Project Tracker"]
[null,{"$f":"B1&\" Confidential\"","v":"Company Name Confidential"}]
[null,"Shaded cells are calculated for you. You do not need to enter anything into them."]
[null,"PROJECT TYPE","ACCOUNT MANAGER","PROJECT MANAGER","STRATEGY MANAGER","DESIGN SPECIALIST","EVENT STAFF","ADMIN STAFF","Total"]
[null,"Event strategy development",{"v":0.2,"d":"20%"},{"v":0.1,"d":"10%"},{"v":0.6,"d":"60%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0.1,"d":"10%"},{"$f":"SUM(Parameters[[#This Row],[ACCOUNT MANAGER]:[ADMIN STAFF]])","v":{"v":1,"d":"100%"}}]
[null,"Event planning",{"v":0.2,"d":"20%"},{"v":0.5,"d":"50%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0,"d":"0%"},{"v":0.1,"d":"10%"},{"$f":"SUM(Parameters[[#This Row],[ACCOUNT MANAGER]:[ADMIN STAFF]])","v":{"v":0.9999999999999999,"d":"100%"}}]
[null,"Event design",{"v":0.2,"d":"20%"},{"v":0.2,"d":"20%"},{"v":0,"d":"0%"},{"v":0.5,"d":"50%"},{"v":0,"d":"0%"},{"v":0.1,"d":"10%"},{"$f":"SUM(Parameters[[#This Row],[ACCOUNT MANAGER]:[ADMIN STAFF]])","v":{"v":1,"d":"100%"}}]
[null,"Event logistics",{"v":0.2,"d":"20%"},{"v":0.6,"d":"60%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"$f":"SUM(Parameters[[#This Row],[ACCOUNT MANAGER]:[ADMIN STAFF]])","v":{"v":1,"d":"100%"}}]
[null,"Event staffing",{"v":0.2,"d":"20%"},{"v":0.1,"d":"10%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0.6,"d":"60%"},{"v":0.1,"d":"10%"},{"$f":"SUM(Parameters[[#This Row],[ACCOUNT MANAGER]:[ADMIN STAFF]])","v":{"v":1,"d":"100%"}}]
[null,"Event assessment",{"v":0.2,"d":"20%"},{"v":0.2,"d":"20%"},{"v":0.2,"d":"20%"},{"v":0.2,"d":"20%"},{"v":0,"d":"0%"},{"v":0.2,"d":"20%"},{"$f":"SUM(Parameters[[#This Row],[ACCOUNT MANAGER]:[ADMIN STAFF]])","v":{"v":1,"d":"100%"}}]
[null,"Blended rates",{"v":180,"d":"£180"},{"v":120,"d":"£120"},{"v":150,"d":"£150"},{"v":100,"d":"£100"},{"v":80,"d":"£80"},{"v":60,"d":"£60"}]
[]
[{"$nulls":5},"Column chart showing planned versus actual hours is in this cell."]
[null,null,"ACCOUNT MANAGER","PROJECT MANAGER","STRATEGY MANAGER","DESIGN SPECIALIST","EVENT STAFF","ADMIN STAFF"]
[null,"PLANNED COST",{"$f":"SUBTOTAL(109,ProjectDetails[ACCOUNT MANAGER])","v":{"v":54000,"d":"£54,000.00"}},{"$f":"SUBTOTAL(109,ProjectDetails[PROJECT MANAGER])","v":{"v":52200,"d":"£52,200.00"}},{"$f":"SUBTOTAL(109,ProjectDetails[STRATEGY MANAGER])","v":{"v":24000,"d":"£24,000.00"}},{"$f":"SUBTOTAL(109,ProjectDetails[DESIGN SPECIALIST])","v":{"v":29000,"d":"£29,000.00"}},{"$f":"SUBTOTAL(109,ProjectDetails[EVENT STAFF])","v":{"v":13200,"d":"£13,200.00"}},{"$f":"SUBTOTAL(109,ProjectDetails[ADMIN STAFF])","v":{"v":9000,"d":"£9,000.00"}}]
[null,"ACTUAL COST",{"$f":"SUBTOTAL(109,ProjectDetails[[ACCOUNT MANAGER ]])","v":{"v":54360,"d":"£54,360.00"}},{"$f":"SUBTOTAL(109,ProjectDetails[[PROJECT MANAGER ]])","v":{"v":51540,"d":"£51,540.00"}},{"$f":"SUBTOTAL(109,ProjectDetails[[STRATEGY MANAGER ]])","v":{"v":25650,"d":"£25,650.00"}},{"$f":"SUBTOTAL(109,ProjectDetails[[DESIGN SPECIALIST ]])","v":{"v":28900,"d":"£28,900.00"}},{"$f":"SUBTOTAL(109,ProjectDetails[[EVENT STAFF ]])","v":{"v":13400,"d":"£13,400.00"}},{"$f":"SUBTOTAL(109,ProjectDetails[[ADMIN STAFF ]])","v":{"v":9060,"d":"£9,060.00"}}]
[null,"PLANNED HOURS",{"$f":"C16/$C$12","v":{"v":300,"d":"300.00"}},{"$f":"D16/$C$12","v":{"v":290,"d":"290.00"}},{"v":133.33333333333334,"d":"133.33"},{"v":161.11111111111111,"d":"161.11"},{"v":73.33333333333333,"d":"73.33"},{"v":50,"d":"50.00"}]
[null,"ACTUAL HOURS",{"$f":"C17/$C$12","v":{"v":302,"d":"302.00"}},{"$f":"D17/$C$12","v":{"v":286.3333333333333,"d":"286.33"}},{"$f":"E17/$C$12","v":{"v":142.5,"d":"142.50"}},{"$f":"F17/$C$12","v":{"v":160.55555555555554,"d":"160.56"}},{"$f":"G17/$C$12","v":{"v":74.44444444444444,"d":"74.44"}},{"$f":"H17/$C$12","v":{"v":50.333333333333336,"d":"50.33"}}]

{"sheet":"PROJECT DETAILS","index":2,"n_rows":10,"n_cols":23,"rows_kept":10}
[null,{"$f":"'PROJECT PARAMETERS'!B1","v":"Company Name"}]
[null,"Event Management Project Tracker"]
[null,{"$f":"'PROJECT PARAMETERS'!B3","v":"Company Name Confidential"}]
["Enter information in Project Details table starting in cell at right.\nINFO\nTo add a row in table at right, select the bottom-right most cell in the body of the table (not the totals row) and press Tab, or press SHIFT+F10 key where you want the row inserted and select Insert | Table Rows Above/Below.\nMake sure all unused rows are deleted, as the PROJECT TOTALS PivotTable will use all of the tables cells, and otherwise would give erroneous results.","PROJECT NAME","PROJECT TYPE","ESTIMATED START","ESTIMATED FINISH","ACTUAL START","ACTUAL FINISH","ESTIMATED WORK","ACTUAL WORK","ESTIMATED DURATION","ACTUAL DURATION","ACCOUNT MANAGER","PROJECT MANAGER","STRATEGY MANAGER","DESIGN SPECIALIST","EVENT STAFF","ADMIN STAFF","ACCOUNT MANAGER ","PROJECT MANAGER ","STRATEGY MANAGER ","DESIGN SPECIALIST ","EVENT STAFF ","ADMIN STAFF "]
[null,"Project 1","Event strategy development",{"$f":"DATE(YEAR(TODAY()),6,9)","v":"2022-06-09"},{"$f":" DATE(YEAR(TODAY()),8,7)","v":"2022-08-07"},{"$f":"DATE(YEAR(TODAY()),6,29)","v":"2022-06-29"},{"$f":"DATE(YEAR(TODAY()),9,3)","v":"2022-09-03"},200,220,{"$f":"DAYS360(ProjectDetails[[#This Row],[ESTIMATED START]],ProjectDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":58},{"$f":"DAYS360(ProjectDetails[[#This Row],[ACTUAL START]],ProjectDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":64},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[ACCOUNT MANAGER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[ACCOUNT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":7200,"d":"£7,200"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[PROJECT MANAGER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[PROJECT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":2400,"d":"£2,400"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[STRATEGY MANAGER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[STRATEGY MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":18000,"d":"£18,000"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[DESIGN SPECIALIST]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[DESIGN SPECIALIST]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"£0"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[EVENT STAFF]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[EVENT STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"£0"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":1200,"d":"£1,200"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[ACCOUNT MANAGER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[ACCOUNT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL WORK]]","v":{"v":7920,"d":"£7,920"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[PROJECT MANAGER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[PROJECT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL WORK]]","v":{"v":2640,"d":"£2,640"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[STRATEGY MANAGER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[STRATEGY MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL WORK]]","v":{"v":19800,"d":"£19,800"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[DESIGN SPECIALIST]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[DESIGN SPECIALIST]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"£0"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[EVENT STAFF]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[EVENT STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"£0"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL WORK]]","v":{"v":1320,"d":"£1,320"}}]
[null,"Project 2","Event planning",{"$f":"DATE(YEAR(TODAY())+1,6,25)","v":"2023-06-25"},{"$f":"DATE(YEAR(TODAY())+1,7,27)","v":"2023-07-27"},{"$f":"DATE(YEAR(TODAY()),7,15)","v":"2022-07-15"},{"$f":"DATE(YEAR(TODAY())+1,8,25)","v":"2023-08-25"},400,390,{"$f":"DAYS360(ProjectDetails[[#This Row],[ESTIMATED START]],ProjectDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":32},{"$f":"DAYS360(ProjectDetails[[#This Row],[ACTUAL START]],ProjectDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":400},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[ACCOUNT MANAGER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[ACCOUNT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":14400,"d":"£14,400"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[PROJECT MANAGER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[PROJECT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":24000,"d":"£24,000"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[STRATEGY MANAGER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[STRATEGY MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":6000,"d":"£6,000"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[DESIGN SPECIALIST]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[DESIGN SPECIALIST]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":4000,"d":"£4,000"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[EVENT STAFF]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[EVENT STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"£0"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":2400,"d":"£2,400"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[ACCOUNT MANAGER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[ACCOUNT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL WORK]]","v":{"v":14040,"d":"£14,040"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[PROJECT MANAGER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[PROJECT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL WORK]]","v":{"v":23400,"d":"£23,400"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[STRATEGY MANAGER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[STRATEGY MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL WORK]]","v":{"v":5850,"d":"£5,850"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[DESIGN SPECIALIST]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[DESIGN SPECIALIST]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL WORK]]","v":{"v":3900,"d":"£3,900"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[EVENT STAFF]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[EVENT STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"£0"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL WORK]]","v":{"v":2340,"d":"£2,340"}}]
[null,"Project 3","Event design",{"$f":"DATE(YEAR(TODAY())+2,7,12)","v":"2024-07-12"},{"$f":"DATE(YEAR(TODAY())+2,9,19)","v":"2024-09-19"},"2025-08-07","2025-10-10",500,500,{"$f":"DAYS360(ProjectDetails[[#This Row],[ESTIMATED START]],ProjectDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":67},{"$f":"DAYS360(ProjectDetails[[#This Row],[ACTUAL START]],ProjectDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":63},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[ACCOUNT MANAGER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[ACCOUNT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":18000,"d":"£18,000"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[PROJECT MANAGER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[PROJECT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":12000,"d":"£12,000"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[STRATEGY MANAGER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[STRATEGY MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"£0"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[DESIGN SPECIALIST]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[DESIGN SPECIALIST]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":25000,"d":"£25,000"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[EVENT STAFF]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[EVENT STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"£0"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":3000,"d":"£3,000"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[ACCOUNT MANAGER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[ACCOUNT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL WORK]]","v":{"v":18000,"d":"£18,000"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[PROJECT MANAGER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[PROJECT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL WORK]]","v":{"v":12000,"d":"£12,000"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[STRATEGY MANAGER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[STRATEGY MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"£0"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[DESIGN SPECIALIST]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[DESIGN SPECIALIST]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL WORK]]","v":{"v":25000,"d":"£25,000"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[EVENT STAFF]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[EVENT STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"£0"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL WORK]]","v":{"v":3000,"d":"£3,000"}}]
[null,"Project 4","Event logistics",{"$f":"DATE(YEAR(TODAY())+3,7,30)","v":"2025-07-30"},{"$f":"DATE(YEAR(TODAY())+3,9,28)","v":"2025-09-28"},{"$f":"DATE(YEAR(TODAY())+3,9,14)","v":"2025-09-14"},{"$f":"DATE(YEAR(TODAY())+3,11,13)","v":"2025-11-13"},150,145,{"$f":"DAYS360(ProjectDetails[[#This Row],[ESTIMATED START]],ProjectDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":58},{"$f":"DAYS360(ProjectDetails[[#This Row],[ACTUAL START]],ProjectDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":59},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[ACCOUNT MANAGER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[ACCOUNT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":5400,"d":"£5,400"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[PROJECT MANAGER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[PROJECT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":10800,"d":"£10,800"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[STRATEGY MANAGER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[STRATEGY MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"£0"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[DESIGN SPECIALIST]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[DESIGN SPECIALIST]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"£0"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[EVENT STAFF]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[EVENT STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":1200,"d":"£1,200"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":900,"d":"£900"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[ACCOUNT MANAGER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[ACCOUNT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL WORK]]","v":{"v":5220,"d":"£5,220"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[PROJECT MANAGER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[PROJECT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL WORK]]","v":{"v":10440,"d":"£10,440"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[STRATEGY MANAGER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[STRATEGY MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"£0"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[DESIGN SPECIALIST]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[DESIGN SPECIALIST]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"£0"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[EVENT STAFF]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[EVENT STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL WORK]]","v":{"v":1160,"d":"£1,160"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL WORK]]","v":{"v":870,"d":"£870"}}]
[null,"Project 5","Event staffing",{"$f":"DATE(YEAR(TODAY())+4,8,11)","v":"2026-08-11"},{"$f":"DATE(YEAR(TODAY())+4,8,21)","v":"2026-08-21"},{"$f":"DATE(YEAR(TODAY())+4,9,14)","v":"2026-09-14"},{"$f":"DATE(YEAR(TODAY())+4,9,25)","v":"2026-09-25"},250,255,{"$f":"DAYS360(ProjectDetails[[#This Row],[ESTIMATED START]],ProjectDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":10},{"$f":"DAYS360(ProjectDetails[[#This Row],[ACTUAL START]],ProjectDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":11},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[ACCOUNT MANAGER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[ACCOUNT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":9000,"d":"£9,000"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[PROJECT MANAGER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[PROJECT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":3000,"d":"£3,000"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[STRATEGY MANAGER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[STRATEGY MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"£0"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[DESIGN SPECIALIST]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[DESIGN SPECIALIST]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"£0"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[EVENT STAFF]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[EVENT STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":12000,"d":"£12,000"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":1500,"d":"£1,500"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[ACCOUNT MANAGER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[ACCOUNT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL WORK]]","v":{"v":9180,"d":"£9,180"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[PROJECT MANAGER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[PROJECT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL WORK]]","v":{"v":3060,"d":"£3,060"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[STRATEGY MANAGER]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[STRATEGY MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"£0"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[DESIGN SPECIALIST]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[DESIGN SPECIALIST]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"£0"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[EVENT STAFF]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[EVENT STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL WORK]]","v":{"v":12240,"d":"£12,240"}},{"$f":"INDEX(Parameters[],MATCH(ProjectDetails[[#This Row],[PROJECT TYPE]],Parameters[PROJECT TYPE],0),MATCH(ProjectDetails[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$12:$H$12,1,MATCH(ProjectDetails[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL WORK]]","v":{"v":1530,"d":"£1,530"}}]
[null,"TOTAL",{"$nulls":5},{"$f":"SUBTOTAL(109,ProjectDetails[ESTIMATED WORK])","v":1500},{"$f":"SUBTOTAL(109,ProjectDetails[ACTUAL WORK])","v":1510},{"$f":"SUBTOTAL(109,ProjectDetails[ESTIMATED DURATION])","v":225},{"$f":"SUBTOTAL(109,ProjectDetails[ACTUAL DURATION])","v":597}]

{"sheet":"PROJECT TOTALS","index":3,"n_rows":10,"n_cols":14,"rows_kept":10}
[null,{"$f":"'PROJECT PARAMETERS'!B1","v":"Company Name"}]
[null,"Event Management Project Tracker"]
[null,{"$f":"'PROJECT PARAMETERS'!B3","v":"Company Name Confidential"}]
["PivotTable starting in cell at right is automatically updated.\nINFO\nTo refresh PivotTable at right, select it (any cell within the PivotTable), on the PIVOTTABLE TOOLS | ANALYSE ribbon tab select Refresh Or press SHIFT+F10 key in any cell in the PivotTable, and then select Refresh.","PROJECT NAME","ACCOUNT MANAGER ESTIMATE","PROJECT MANAGER ESTIMATE","STRATEGY MANAGER ESTIMATE","DESIGN SPECIALIST ESTIMATE","EVENT STAFF ESTIMATE","ADMIN STAFF ESTIMATE","ACCOUNT MANAGER ACTUAL","PROJECT MANAGER ACTUAL","STRATEGY MANAGER ACTUAL","DESIGN SPECIALIST ACTUAL","EVENT STAFF ACTUAL","ADMIN STAFF ACTUAL"]
[null,"Project 1",{"v":7200,"d":"£7,200.00"},{"v":2400,"d":"£2,400.00"},{"v":18000,"d":"£18,000.00"},{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"},{"v":1200,"d":"£1,200.00"},{"v":7920,"d":"£7,920.00"},{"v":2640,"d":"£2,640.00"},{"v":19800,"d":"£19,800.00"},{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"},{"v":1320,"d":"£1,320.00"}]
[null,"Project 2",{"v":14400,"d":"£14,400.00"},{"v":24000,"d":"£24,000.00"},{"v":6000,"d":"£6,000.00"},{"v":4000,"d":"£4,000.00"},{"v":0,"d":"£0.00"},{"v":2400,"d":"£2,400.00"},{"v":14040,"d":"£14,040.00"},{"v":23400,"d":"£23,400.00"},{"v":5850,"d":"£5,850.00"},{"v":3900,"d":"£3,900.00"},{"v":0,"d":"£0.00"},{"v":2340,"d":"£2,340.00"}]
[null,"Project 3",{"v":18000,"d":"£18,000.00"},{"v":12000,"d":"£12,000.00"},{"v":0,"d":"£0.00"},{"v":25000,"d":"£25,000.00"},{"v":0,"d":"£0.00"},{"v":3000,"d":"£3,000.00"},{"v":18000,"d":"£18,000.00"},{"v":12000,"d":"£12,000.00"},{"v":0,"d":"£0.00"},{"v":25000,"d":"£25,000.00"},{"v":0,"d":"£0.00"},{"v":3000,"d":"£3,000.00"}]
[null,"Project 4",{"v":5400,"d":"£5,400.00"},{"v":10800,"d":"£10,800.00"},{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"},{"v":1200,"d":"£1,200.00"},{"v":900,"d":"£900.00"},{"v":5220,"d":"£5,220.00"},{"v":10440,"d":"£10,440.00"},{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"},{"v":1160,"d":"£1,160.00"},{"v":870,"d":"£870.00"}]
[null,"Project 5",{"v":9000,"d":"£9,000.00"},{"v":3000,"d":"£3,000.00"},{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"},{"v":12000,"d":"£12,000.00"},{"v":1500,"d":"£1,500.00"},{"v":9180,"d":"£9,180.00"},{"v":3060,"d":"£3,060.00"},{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"},{"v":12240,"d":"£12,240.00"},{"v":1530,"d":"£1,530.00"}]
[null,"Grand Total",{"v":54000,"d":"£54,000.00"},{"v":52200,"d":"£52,200.00"},{"v":24000,"d":"£24,000.00"},{"v":29000,"d":"£29,000.00"},{"v":13200,"d":"£13,200.00"},{"v":9000,"d":"£9,000.00"},{"v":54360,"d":"£54,360.00"},{"v":51540,"d":"£51,540.00"},{"v":25650,"d":"£25,650.00"},{"v":28900,"d":"£28,900.00"},{"v":13400,"d":"£13,400.00"},{"v":9060,"d":"£9,060.00"}]