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

{"sheet":"PROJECT PARAMETERS","index":0,"n_rows":20,"n_cols":9,"rows_kept":20,"merged":[[1,6,1,8],[3,6,3,8]]}
[]
[null,"ROBOTINE MANUFACTURING",{"$nulls":4},{"$f":"B2 & \":\" & CHAR(10) & \"CONFIDENTIAL\"","v":"ROBOTINE MANUFACTURING:\nCONFIDENTIAL"}]
[null," Event management project tracker"]
[{"$nulls":6},"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"}]
[]
[]
[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":"C17/$C$13","v":{"v":300,"d":"300.00"}},{"$f":"D17/$C$13","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":"C18/$C$13","v":{"v":302,"d":"302.00"}},{"$f":"D18/$C$13","v":{"v":286.3333333333333,"d":"286.33"}},{"$f":"E18/$C$13","v":{"v":142.5,"d":"142.50"}},{"$f":"F18/$C$13","v":{"v":160.55555555555554,"d":"160.56"}},{"$f":"G18/$C$13","v":{"v":74.44444444444444,"d":"74.44"}},{"$f":"H18/$C$13","v":{"v":50.333333333333336,"d":"50.33"}}]

{"sheet":"PROJECT DETAILS","index":1,"n_rows":11,"n_cols":26,"rows_kept":11,"merged":[[1,10,1,28],[4,25,10,27]]}
[]
[null,{"$f":"'PROJECT PARAMETERS'!B2","v":"ROBOTINE MANUFACTURING"},{"$nulls":8},{"$f":"'PROJECT PARAMETERS'!G2","v":"ROBOTINE MANUFACTURING:\nCONFIDENTIAL"}]
[null," Event management project tracker"]
[]
[null,"PROJECT NAME","PROJECT TYPE","ESTIMATED START","ESTIMATED FINISH","ACTUAL\nSTART","ACTUAL FINISH","ESTIMATED WORK","ACTUAL\nWORK","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,null,"INFO\n\nTo add a row, select the bottom-right most cell in the body of the table (not the totals row) and press Tab, or right-click where you want the row inserted and select Insert | Table Rows Above/Below.\n\nBe sure all unused rows are deleted, as the PROJECT TOTALS PivotTable will use all of the tables cells, and otherwise would give erroneous results."]
[null,"Project 1","Event strategy development",{"$f":"DATE(YEAR(TODAY()),6,9)","v":"2023-06-09"},{"$f":" DATE(YEAR(TODAY()),8,7)","v":"2023-08-07"},{"$f":"DATE(YEAR(TODAY()),6,29)","v":"2023-06-29"},{"$f":"DATE(YEAR(TODAY()),9,3)","v":"2023-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\nSTART]],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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[ACCOUNT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":"1919-09-17"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[PROJECT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":"1906-07-27"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[STRATEGY MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":"1949-04-12"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[DESIGN SPECIALIST]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":"00:00:00"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[EVENT STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":"00:00:00"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":"1903-04-14"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[ACCOUNT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL\nWORK]]","v":"1921-09-06"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[PROJECT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL\nWORK]]","v":"1907-03-24"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[STRATEGY MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL\nWORK]]","v":"1954-03-17"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[DESIGN SPECIALIST]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL\nWORK]]","v":"00:00:00"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[EVENT STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL\nWORK]]","v":"00:00:00"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL\nWORK]]","v":"1903-08-12"}]
[null,"Project 2","Event planning",{"$f":"DATE(YEAR(TODAY())+1,6,25)","v":"2024-06-25"},{"$f":"DATE(YEAR(TODAY())+1,7,27)","v":"2024-07-27"},{"$f":"DATE(YEAR(TODAY()),7,15)","v":"2023-07-15"},{"$f":"DATE(YEAR(TODAY())+1,8,25)","v":"2024-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\nSTART]],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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[ACCOUNT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":"1939-06-04"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[PROJECT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":"1965-09-15"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[STRATEGY MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":"1916-06-04"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[DESIGN SPECIALIST]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":"1910-12-13"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[EVENT STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":"00:00:00"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":"1906-07-27"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[ACCOUNT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL\nWORK]]","v":"1938-06-09"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[PROJECT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL\nWORK]]","v":"1964-01-24"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[STRATEGY MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL\nWORK]]","v":"1916-01-06"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[DESIGN SPECIALIST]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL\nWORK]]","v":"1910-09-04"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[EVENT STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL\nWORK]]","v":"00:00:00"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL\nWORK]]","v":"1906-05-28"}]
[null,"Project 3","Event design",{"$f":"DATE(YEAR(TODAY())+2,7,12)","v":"2025-07-12"},{"$f":"DATE(YEAR(TODAY())+2,9,19)","v":"2025-09-19"},{"$f":"DATE(YEAR(TODAY())+2,8,7)","v":"2025-08-07"},{"$f":"DATE(YEAR(TODAY())+2,10,25)","v":"2025-10-25"},500,500,{"$f":"DAYS360(ProjectDetails[[#This Row],[ESTIMATED START]],ProjectDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":67},{"$f":"DAYS360(ProjectDetails[[#This Row],[ACTUAL\nSTART]],ProjectDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":78},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[ACCOUNT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":"1949-04-12"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[PROJECT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":"1932-11-07"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[STRATEGY MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":"00:00:00"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[DESIGN SPECIALIST]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":"1968-06-11"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[EVENT STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":"00:00:00"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":"1908-03-18"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[ACCOUNT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL\nWORK]]","v":"1949-04-12"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[PROJECT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL\nWORK]]","v":"1932-11-07"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[STRATEGY MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL\nWORK]]","v":"00:00:00"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[DESIGN SPECIALIST]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL\nWORK]]","v":"1968-06-11"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[EVENT STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL\nWORK]]","v":"00:00:00"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL\nWORK]]","v":"1908-03-18"}]
[null,"Project 4","Event logistics",{"$f":"DATE(YEAR(TODAY())+3,7,30)","v":"2026-07-30"},{"$f":"DATE(YEAR(TODAY())+3,9,28)","v":"2026-09-28"},{"$f":"DATE(YEAR(TODAY())+3,9,14)","v":"2026-09-14"},{"$f":"DATE(YEAR(TODAY())+3,11,13)","v":"2026-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\nSTART]],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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[ACCOUNT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":"1914-10-13"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[PROJECT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":"1929-07-26"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[STRATEGY MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":"00:00:00"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[DESIGN SPECIALIST]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":"00:00:00"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[EVENT STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":"1903-04-14"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":"1902-06-18"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[ACCOUNT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL\nWORK]]","v":"1914-04-16"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[PROJECT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL\nWORK]]","v":"1928-07-31"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[STRATEGY MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL\nWORK]]","v":"00:00:00"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[DESIGN SPECIALIST]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL\nWORK]]","v":"00:00:00"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[EVENT STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL\nWORK]]","v":"1903-03-05"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL\nWORK]]","v":"1902-05-19"}]
[null,"Project 5","Event staffing",{"$f":"DATE(YEAR(TODAY())+4,8,11)","v":"2027-08-11"},{"$f":"DATE(YEAR(TODAY())+4,8,21)","v":"2027-08-21"},{"$f":"DATE(YEAR(TODAY())+4,9,14)","v":"2027-09-14"},{"$f":"DATE(YEAR(TODAY())+4,9,25)","v":"2027-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\nSTART]],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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[ACCOUNT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":"1924-08-21"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[PROJECT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":"1908-03-18"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[STRATEGY MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":"00:00:00"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[DESIGN SPECIALIST]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":"00:00:00"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[EVENT STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":"1932-11-07"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ESTIMATED WORK]]","v":"1904-02-08"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[ACCOUNT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL\nWORK]]","v":"1925-02-17"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[PROJECT MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL\nWORK]]","v":"1908-05-17"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[STRATEGY MANAGER]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL\nWORK]]","v":"00:00:00"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[DESIGN SPECIALIST]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL\nWORK]]","v":"00:00:00"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[EVENT STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL\nWORK]]","v":"1933-07-05"},{"$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$13:$H$13,1,MATCH(ProjectDetails[[#Headers],[ADMIN STAFF]],Parameters[#Headers],0))*ProjectDetails[[#This Row],[ACTUAL\nWORK]]","v":"1904-03-09"}]
[null,"TOTAL",{"$nulls":5},{"$f":"SUBTOTAL(109,ProjectDetails[ESTIMATED WORK])","v":1500},{"$f":"SUBTOTAL(109,ProjectDetails[ACTUAL\nWORK])","v":1510},{"$f":"SUBTOTAL(109,ProjectDetails[ESTIMATED DURATION])","v":225},{"$f":"SUBTOTAL(109,ProjectDetails[ACTUAL DURATION])","v":612}]

{"sheet":"PROJECT TOTALS","index":2,"n_rows":11,"n_cols":17,"rows_kept":11,"merged":[[1,13,1,19],[4,16,10,18]]}
[]
[null,{"$f":"'PROJECT PARAMETERS'!B2","v":"ROBOTINE MANUFACTURING"},{"$nulls":11},{"$f":"'PROJECT PARAMETERS'!G2","v":"ROBOTINE MANUFACTURING:\nCONFIDENTIAL"}]
[null," Event Management Project Tracker"]
[]
[null,"PROJECT NAME","ACCOUNT MANAGER ESTIMATE","PROJECT MANAGER ESTIMATE","STRATEGY MANAGER ESTIMATE","DESIGN SPECIALIST ESTIMATE","EVENT STAFF\nESTIMATE","ADMIN STAFF\nESTIMATE","ACCOUNT MANAGER \nACTUAL","PROJECT MANAGER\nACTUAL","STRATEGY MANAGER\nACTUAL","DESIGN SPECIALIST ACTUAL","EVENT STAFF\nACTUAL","ADMIN STAFF\nACTUAL",null,null,"INFO\n\nThis PivotTable will not refresh automatically.  To refresh it, go to Data Tab in the ribbon and click Refresh All."]
[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"}]