{"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":21,"n_cols":9,"rows_kept":21}
[]
[null,"[Company Name]"]
[null,"Event Management Project Tracker"]
[null,"Company 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(tblParameters[[#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(tblParameters[[#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(tblParameters[[#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(tblParameters[[#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(tblParameters[[#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(tblParameters[[#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,tblDetails[ACCOUNT MANAGER])","v":{"v":272340,"d":"$272,340.00"}},{"$f":"SUBTOTAL(109,tblDetails[PROJECT MANAGER])","v":{"v":319320,"d":"$319,320.00"}},{"$f":"SUBTOTAL(109,tblDetails[STRATEGY MANAGER])","v":{"v":123450,"d":"$123,450.00"}},{"$f":"SUBTOTAL(109,tblDetails[DESIGN SPECIALIST])","v":{"v":106000,"d":"$106,000.00"}},{"$f":"SUBTOTAL(109,tblDetails[EVENT STAFF])","v":{"v":49320,"d":"$49,320.00"}},{"$f":"SUBTOTAL(109,tblDetails[ADMIN STAFF])","v":{"v":53490,"d":"$53,490.00"}}]
[null,"ACTUAL COST",{"$f":"SUBTOTAL(109,tblDetails[[ACCOUNT MANAGER ]])","v":{"v":273960,"d":"$273,960.00"}},{"$f":"SUBTOTAL(109,tblDetails[[PROJECT MANAGER ]])","v":{"v":324540,"d":"$324,540.00"}},{"$f":"SUBTOTAL(109,tblDetails[[STRATEGY MANAGER ]])","v":{"v":126150,"d":"$126,150.00"}},{"$f":"SUBTOTAL(109,tblDetails[[DESIGN SPECIALIST ]])","v":{"v":104950,"d":"$104,950.00"}},{"$f":"SUBTOTAL(109,tblDetails[[EVENT STAFF ]])","v":{"v":48160,"d":"$48,160.00"}},{"$f":"SUBTOTAL(109,tblDetails[[ADMIN STAFF ]])","v":{"v":53460,"d":"$53,460.00"}}]
[null,"PLANNED HOURS",{"$f":"C18/$C$14","v":{"v":1513,"d":"1,513.00"}},{"$f":"D18/$C$14","v":{"v":1774,"d":"1,774.00"}},{"v":685.8333333333334,"d":"685.83"},{"v":588.8888888888889,"d":"588.89"},{"v":274,"d":"274.00"},{"v":297.1666666666667,"d":"297.17"}]
[null,"ACTUAL HOURS",{"$f":"C19/$C$14","v":{"v":1522,"d":"1,522.00"}},{"$f":"D19/$C$14","v":{"v":1803,"d":"1,803.00"}},{"$f":"E19/$C$14","v":{"v":700.8333333333334,"d":"700.83"}},{"$f":"F19/$C$14","v":{"v":583.0555555555555,"d":"583.06"}},{"$f":"G19/$C$14","v":{"v":267.55555555555554,"d":"267.56"}},{"$f":"H19/$C$14","v":{"v":297,"d":"297.00"}}]

{"sheet":"PROJECT DETAILS","index":1,"n_rows":29,"n_cols":23,"rows_kept":29,"merged":[[4,11,4,16],[4,17,4,22]]}
[]
[null,{"$f":"'PROJECT PARAMETERS'!B2","v":"[Company Name]"}]
[null,"Event Management Project Tracker"]
[null,"Company Confidential"]
[{"$nulls":11},"PLANNING",{"$nulls":5},"ACTUALS"]
[null,"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,"A. Datum Corporation","Event strategy development","2013-06-09","2013-08-07","2013-06-29","2013-09-03",200,220,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":58},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":64},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":7200,"d":"$7,200"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":2400,"d":"$2,400"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":18000,"d":"$18,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":1200,"d":"$1,200"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":7920,"d":"$7,920"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":2640,"d":"$2,640"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":19800,"d":"$19,800"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":1320,"d":"$1,320"}}]
[null,"Adventure Works","Event planning","2013-06-25","2013-07-27","2013-07-15","2013-08-25",400,390,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":32},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":40},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":14400,"d":"$14,400"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":24000,"d":"$24,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":6000,"d":"$6,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":4000,"d":"$4,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":2400,"d":"$2,400"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":14040,"d":"$14,040"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":23400,"d":"$23,400"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":5850,"d":"$5,850"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":3900,"d":"$3,900"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":2340,"d":"$2,340"}}]
[null,"Alpine Ski House","Event design","2013-07-12","2013-09-19","2013-08-07","2013-10-10",500,500,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":67},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":63},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":18000,"d":"$18,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":12000,"d":"$12,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":25000,"d":"$25,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":3000,"d":"$3,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":18000,"d":"$18,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":12000,"d":"$12,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":25000,"d":"$25,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":3000,"d":"$3,000"}}]
[null,"Baldwin Museum of Science","Event logistics","2013-07-30","2013-09-28","2013-09-14","2013-11-13",150,145,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":58},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":59},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":5400,"d":"$5,400"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":10800,"d":"$10,800"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":1200,"d":"$1,200"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":900,"d":"$900"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":5220,"d":"$5,220"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":10440,"d":"$10,440"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":1160,"d":"$1,160"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":870,"d":"$870"}}]
[null,"Blue Yonder Airlines","Event staffing","2013-08-11","2013-08-21","2013-09-14","2013-09-25",250,255,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":10},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":11},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":9000,"d":"$9,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":3000,"d":"$3,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":12000,"d":"$12,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":1500,"d":"$1,500"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":9180,"d":"$9,180"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":3060,"d":"$3,060"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":12240,"d":"$12,240"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":1530,"d":"$1,530"}}]
[null,"City Power & Light","Event assessment","2013-08-22","2013-10-02","2013-09-28","2013-10-27",300,310,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":40},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":29},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":10800,"d":"$10,800"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":7200,"d":"$7,200"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":9000,"d":"$9,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":6000,"d":"$6,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":3600,"d":"$3,600"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":11160,"d":"$11,160"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":7440,"d":"$7,440"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":9300,"d":"$9,300"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":6200,"d":"$6,200"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":3720,"d":"$3,720"}}]
[null,"Coho Vineyard","Event planning","2013-09-13","2013-09-23","2013-10-26","2013-10-13",500,510,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":10},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":-13},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":18000,"d":"$18,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":30000,"d":"$30,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":7500,"d":"$7,500"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":5000,"d":"$5,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":3000,"d":"$3,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":18360,"d":"$18,360"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":30600,"d":"$30,600"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":7650,"d":"$7,650"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":5100,"d":"$5,100"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":3060,"d":"$3,060"}}]
[null,"Coho Winery","Event logistics","2013-09-21","2013-10-15","2013-10-23","2013-11-18",750,790,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":24},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":25},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":27000,"d":"$27,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":54000,"d":"$54,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":6000,"d":"$6,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":4500,"d":"$4,500"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":28440,"d":"$28,440"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":56880,"d":"$56,880"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":6320,"d":"$6,320"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":4740,"d":"$4,740"}}]
[null,"Coho Vineyard & Winery","Event assessment","2013-10-15","2013-11-25","2013-11-30","2014-01-10",450,430,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":40},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":40},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":16200,"d":"$16,200"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":10800,"d":"$10,800"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":13500,"d":"$13,500"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":9000,"d":"$9,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":5400,"d":"$5,400"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":15480,"d":"$15,480"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":10320,"d":"$10,320"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":12900,"d":"$12,900"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":8600,"d":"$8,600"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":5160,"d":"$5,160"}}]
[null,"Contoso, Ltd.","Event staffing","2013-10-26","2013-12-24","2013-11-26","2014-01-19",250,235,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":58},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":53},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":9000,"d":"$9,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":3000,"d":"$3,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":12000,"d":"$12,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":1500,"d":"$1,500"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":8460,"d":"$8,460"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":2820,"d":"$2,820"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":11280,"d":"$11,280"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":1410,"d":"$1,410"}}]
[null,"Contoso Pharmaceuticals","Event planning","2013-11-17","2014-01-15","2013-12-28","2014-02-26",200,235,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":58},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":58},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":7200,"d":"$7,200"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":12000,"d":"$12,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":3000,"d":"$3,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":2000,"d":"$2,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":1200,"d":"$1,200"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":8460,"d":"$8,460"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":14100,"d":"$14,100"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":3525,"d":"$3,525"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":2350,"d":"$2,350"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":1410,"d":"$1,410"}}]
[null,"Consolidated Messenger","Event strategy development","2013-12-03","2014-02-02","2014-01-14","2014-03-02",180,190,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":59},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":48},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":6480,"d":"$6,480"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":2160,"d":"$2,160"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":16200,"d":"$16,200"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":1080,"d":"$1,080"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":6840,"d":"$6,840"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":2280,"d":"$2,280"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":17100,"d":"$17,100"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":1140,"d":"$1,140"}}]
[null,"Fabrikam, Inc.","Event staffing","2013-06-21","2014-01-18","2013-08-05","2014-03-04",250,230,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":207},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":209},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":9000,"d":"$9,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":3000,"d":"$3,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":12000,"d":"$12,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":1500,"d":"$1,500"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":8280,"d":"$8,280"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":2760,"d":"$2,760"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":11040,"d":"$11,040"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":1380,"d":"$1,380"}}]
[null,"Fourth Coffee","Event logistics","2013-12-20","2014-02-04","2014-01-27","2014-03-25",240,225,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":44},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":58},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":8640,"d":"$8,640"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":17280,"d":"$17,280"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":1920,"d":"$1,920"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":1440,"d":"$1,440"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":8100,"d":"$8,100"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":16200,"d":"$16,200"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":1800,"d":"$1,800"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":1350,"d":"$1,350"}}]
[null,"Graphic Design Institute","Event design","2013-12-28","2014-03-05","2014-01-17","2014-04-10",320,305,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":67},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":83},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":11520,"d":"$11,520"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":7680,"d":"$7,680"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":16000,"d":"$16,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":1920,"d":"$1,920"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":10980,"d":"$10,980"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":7320,"d":"$7,320"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":15250,"d":"$15,250"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":1830,"d":"$1,830"}}]
[null,"Humongous Insurance","Event planning","2014-01-04","2014-03-06","2014-02-03","2014-04-06",550,565,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":62},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":63},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":19800,"d":"$19,800"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":33000,"d":"$33,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":8250,"d":"$8,250"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":5500,"d":"$5,500"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":3300,"d":"$3,300"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":20340,"d":"$20,340"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":33900,"d":"$33,900"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":8475,"d":"$8,475"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":5650,"d":"$5,650"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":3390,"d":"$3,390"}}]
[null,"Litware, Inc.","Event design","2014-01-23","2014-03-07","2014-03-07","2014-04-08",350,350,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":44},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":31},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":12600,"d":"$12,600"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":8400,"d":"$8,400"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":17500,"d":"$17,500"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":2100,"d":"$2,100"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":12600,"d":"$12,600"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":8400,"d":"$8,400"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":17500,"d":"$17,500"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":2100,"d":"$2,100"}}]
[null,"Lucerne Publishing","Event strategy development","2014-02-05","2014-04-17","2014-03-07","2014-06-03",200,205,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":72},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":86},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":7200,"d":"$7,200"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":2400,"d":"$2,400"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":18000,"d":"$18,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":1200,"d":"$1,200"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":7380,"d":"$7,380"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":2460,"d":"$2,460"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":18450,"d":"$18,450"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":1230,"d":"$1,230"}}]
[null,"Margie's Travel","Event planning","2014-02-15","2014-04-30","2014-03-26","2014-06-09",220,230,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":75},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":73},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":7920,"d":"$7,920"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":13200,"d":"$13,200"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":3300,"d":"$3,300"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":2200,"d":"$2,200"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":1320,"d":"$1,320"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":8280,"d":"$8,280"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":13800,"d":"$13,800"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":3450,"d":"$3,450"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":2300,"d":"$2,300"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":1380,"d":"$1,380"}}]
[null,"Northwind Traders","Event assessment","2014-03-17","2014-05-25","2014-04-29","2014-07-01",600,560,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":68},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":62},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":21600,"d":"$21,600"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":14400,"d":"$14,400"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":18000,"d":"$18,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":12000,"d":"$12,000"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":7200,"d":"$7,200"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":20160,"d":"$20,160"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":13440,"d":"$13,440"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":16800,"d":"$16,800"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":11200,"d":"$11,200"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":6720,"d":"$6,720"}}]
[null,"Proseware, Inc.","Event logistics","2014-03-29","2014-05-19","2014-05-18","2014-06-19",525,540,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":50},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":31},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":18900,"d":"$18,900"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":37800,"d":"$37,800"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":4200,"d":"$4,200"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":3150,"d":"$3,150"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":19440,"d":"$19,440"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":38880,"d":"$38,880"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":4320,"d":"$4,320"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":3240,"d":"$3,240"}}]
[null,"School of Fine Art","Event planning","2014-04-09","2014-04-29","2014-05-02","2014-06-04",180,190,{"$f":"DAYS360(tblDetails[[#This Row],[ESTIMATED START]],tblDetails[[#This Row],[ESTIMATED FINISH]],FALSE)","v":20},{"$f":"DAYS360(tblDetails[[#This Row],[ACTUAL START]],tblDetails[[#This Row],[ACTUAL FINISH]],FALSE)","v":32},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":6480,"d":"$6,480"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":10800,"d":"$10,800"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":2700,"d":"$2,700"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":1800,"d":"$1,800"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ESTIMATED WORK]]","v":{"v":1080,"d":"$1,080"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ACCOUNT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":6840,"d":"$6,840"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[PROJECT MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":11400,"d":"$11,400"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[STRATEGY MANAGER]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":2850,"d":"$2,850"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[DESIGN SPECIALIST]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":1900,"d":"$1,900"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[EVENT STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":0,"d":"$0"}},{"$f":"INDEX(tblParameters[],MATCH(tblDetails[[#This Row],[PROJECT TYPE]],tblParameters[PROJECT TYPE],0),MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*INDEX('PROJECT PARAMETERS'!$B$14:$H$14,1,MATCH(tblDetails[[#Headers],[ADMIN STAFF]],tblParameters[#Headers],0))*tblDetails[[#This Row],[ACTUAL WORK]]","v":{"v":1140,"d":"$1,140"}}]
[null,"TOTAL",{"$nulls":5},{"$f":"SUBTOTAL(109,tblDetails[ESTIMATED WORK])","v":7565},{"$f":"SUBTOTAL(109,tblDetails[ACTUAL WORK])","v":7610},{"$f":"SUBTOTAL(109,tblDetails[ESTIMATED DURATION])","v":1223},{"$f":"SUBTOTAL(109,tblDetails[ACTUAL DURATION])","v":1205}]

{"sheet":"PROJECT TOTALS","index":2,"n_rows":29,"n_cols":14,"rows_kept":29}
[]
[null,{"$f":"'PROJECT PARAMETERS'!B2","v":"[Company Name]"}]
[null,"Event Management Project Tracker"]
[null,"Company Confidential"]
[]
[null,"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,"A. Datum Corporation",{"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,"Adventure Works",{"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,"Alpine Ski House",{"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,"Baldwin Museum of Science",{"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,"Blue Yonder Airlines",{"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,"City Power & Light",{"v":10800,"d":"$10,800.00"},{"v":7200,"d":"$7,200.00"},{"v":9000,"d":"$9,000.00"},{"v":6000,"d":"$6,000.00"},{"v":0,"d":"$0.00"},{"v":3600,"d":"$3,600.00"},{"v":11160,"d":"$11,160.00"},{"v":7440,"d":"$7,440.00"},{"v":9300,"d":"$9,300.00"},{"v":6200,"d":"$6,200.00"},{"v":0,"d":"$0.00"},{"v":3720,"d":"$3,720.00"}]
[null,"Coho Vineyard",{"v":18000,"d":"$18,000.00"},{"v":30000,"d":"$30,000.00"},{"v":7500,"d":"$7,500.00"},{"v":5000,"d":"$5,000.00"},{"v":0,"d":"$0.00"},{"v":3000,"d":"$3,000.00"},{"v":18360,"d":"$18,360.00"},{"v":30600,"d":"$30,600.00"},{"v":7650,"d":"$7,650.00"},{"v":5100,"d":"$5,100.00"},{"v":0,"d":"$0.00"},{"v":3060,"d":"$3,060.00"}]
[null,"Coho Vineyard & Winery",{"v":16200,"d":"$16,200.00"},{"v":10800,"d":"$10,800.00"},{"v":13500,"d":"$13,500.00"},{"v":9000,"d":"$9,000.00"},{"v":0,"d":"$0.00"},{"v":5400,"d":"$5,400.00"},{"v":15480,"d":"$15,480.00"},{"v":10320,"d":"$10,320.00"},{"v":12900,"d":"$12,900.00"},{"v":8600,"d":"$8,600.00"},{"v":0,"d":"$0.00"},{"v":5160,"d":"$5,160.00"}]
[null,"Coho Winery",{"v":27000,"d":"$27,000.00"},{"v":54000,"d":"$54,000.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":6000,"d":"$6,000.00"},{"v":4500,"d":"$4,500.00"},{"v":28440,"d":"$28,440.00"},{"v":56880,"d":"$56,880.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":6320,"d":"$6,320.00"},{"v":4740,"d":"$4,740.00"}]
[null,"Consolidated Messenger",{"v":6480,"d":"$6,480.00"},{"v":2160,"d":"$2,160.00"},{"v":16200,"d":"$16,200.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":1080,"d":"$1,080.00"},{"v":6840,"d":"$6,840.00"},{"v":2280,"d":"$2,280.00"},{"v":17100,"d":"$17,100.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":1140,"d":"$1,140.00"}]
[null,"Contoso Pharmaceuticals",{"v":7200,"d":"$7,200.00"},{"v":12000,"d":"$12,000.00"},{"v":3000,"d":"$3,000.00"},{"v":2000,"d":"$2,000.00"},{"v":0,"d":"$0.00"},{"v":1200,"d":"$1,200.00"},{"v":8460,"d":"$8,460.00"},{"v":14100,"d":"$14,100.00"},{"v":3525,"d":"$3,525.00"},{"v":2350,"d":"$2,350.00"},{"v":0,"d":"$0.00"},{"v":1410,"d":"$1,410.00"}]
[null,"Contoso, Ltd.",{"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":8460,"d":"$8,460.00"},{"v":2820,"d":"$2,820.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":11280,"d":"$11,280.00"},{"v":1410,"d":"$1,410.00"}]
[null,"Fabrikam, Inc.",{"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":8280,"d":"$8,280.00"},{"v":2760,"d":"$2,760.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":11040,"d":"$11,040.00"},{"v":1380,"d":"$1,380.00"}]
[null,"Fourth Coffee",{"v":8640,"d":"$8,640.00"},{"v":17280,"d":"$17,280.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":1920,"d":"$1,920.00"},{"v":1440,"d":"$1,440.00"},{"v":8100,"d":"$8,100.00"},{"v":16200,"d":"$16,200.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":1800,"d":"$1,800.00"},{"v":1350,"d":"$1,350.00"}]
[null,"Graphic Design Institute",{"v":11520,"d":"$11,520.00"},{"v":7680,"d":"$7,680.00"},{"v":0,"d":"$0.00"},{"v":16000,"d":"$16,000.00"},{"v":0,"d":"$0.00"},{"v":1920,"d":"$1,920.00"},{"v":10980,"d":"$10,980.00"},{"v":7320,"d":"$7,320.00"},{"v":0,"d":"$0.00"},{"v":15250,"d":"$15,250.00"},{"v":0,"d":"$0.00"},{"v":1830,"d":"$1,830.00"}]
[null,"Humongous Insurance",{"v":19800,"d":"$19,800.00"},{"v":33000,"d":"$33,000.00"},{"v":8250,"d":"$8,250.00"},{"v":5500,"d":"$5,500.00"},{"v":0,"d":"$0.00"},{"v":3300,"d":"$3,300.00"},{"v":20340,"d":"$20,340.00"},{"v":33900,"d":"$33,900.00"},{"v":8475,"d":"$8,475.00"},{"v":5650,"d":"$5,650.00"},{"v":0,"d":"$0.00"},{"v":3390,"d":"$3,390.00"}]
[null,"Litware, Inc.",{"v":12600,"d":"$12,600.00"},{"v":8400,"d":"$8,400.00"},{"v":0,"d":"$0.00"},{"v":17500,"d":"$17,500.00"},{"v":0,"d":"$0.00"},{"v":2100,"d":"$2,100.00"},{"v":12600,"d":"$12,600.00"},{"v":8400,"d":"$8,400.00"},{"v":0,"d":"$0.00"},{"v":17500,"d":"$17,500.00"},{"v":0,"d":"$0.00"},{"v":2100,"d":"$2,100.00"}]
[null,"Lucerne Publishing",{"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":7380,"d":"$7,380.00"},{"v":2460,"d":"$2,460.00"},{"v":18450,"d":"$18,450.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":1230,"d":"$1,230.00"}]
[null,"Margie's Travel",{"v":7920,"d":"$7,920.00"},{"v":13200,"d":"$13,200.00"},{"v":3300,"d":"$3,300.00"},{"v":2200,"d":"$2,200.00"},{"v":0,"d":"$0.00"},{"v":1320,"d":"$1,320.00"},{"v":8280,"d":"$8,280.00"},{"v":13800,"d":"$13,800.00"},{"v":3450,"d":"$3,450.00"},{"v":2300,"d":"$2,300.00"},{"v":0,"d":"$0.00"},{"v":1380,"d":"$1,380.00"}]
[null,"Northwind Traders",{"v":21600,"d":"$21,600.00"},{"v":14400,"d":"$14,400.00"},{"v":18000,"d":"$18,000.00"},{"v":12000,"d":"$12,000.00"},{"v":0,"d":"$0.00"},{"v":7200,"d":"$7,200.00"},{"v":20160,"d":"$20,160.00"},{"v":13440,"d":"$13,440.00"},{"v":16800,"d":"$16,800.00"},{"v":11200,"d":"$11,200.00"},{"v":0,"d":"$0.00"},{"v":6720,"d":"$6,720.00"}]
[null,"Proseware, Inc.",{"v":18900,"d":"$18,900.00"},{"v":37800,"d":"$37,800.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":4200,"d":"$4,200.00"},{"v":3150,"d":"$3,150.00"},{"v":19440,"d":"$19,440.00"},{"v":38880,"d":"$38,880.00"},{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},{"v":4320,"d":"$4,320.00"},{"v":3240,"d":"$3,240.00"}]
[null,"School of Fine Art",{"v":6480,"d":"$6,480.00"},{"v":10800,"d":"$10,800.00"},{"v":2700,"d":"$2,700.00"},{"v":1800,"d":"$1,800.00"},{"v":0,"d":"$0.00"},{"v":1080,"d":"$1,080.00"},{"v":6840,"d":"$6,840.00"},{"v":11400,"d":"$11,400.00"},{"v":2850,"d":"$2,850.00"},{"v":1900,"d":"$1,900.00"},{"v":0,"d":"$0.00"},{"v":1140,"d":"$1,140.00"}]
[null,"Grand Total",{"v":272340,"d":"$272,340.00"},{"v":319320,"d":"$319,320.00"},{"v":123450,"d":"$123,450.00"},{"v":106000,"d":"$106,000.00"},{"v":49320,"d":"$49,320.00"},{"v":53490,"d":"$53,490.00"},{"v":273960,"d":"$273,960.00"},{"v":324540,"d":"$324,540.00"},{"v":126150,"d":"$126,150.00"},{"v":104950,"d":"$104,950.00"},{"v":48160,"d":"$48,160.00"},{"v":53460,"d":"$53,460.00"}]