{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Project Parameters","Actuals","Actual Totals","Monthly Billings","Billing Timeline","Account Billing","Skill Type Billing"],"not_rendered":{"charts":6,"defined_names":3},"unopened":[{"sheet":"Billing Timeline","index":4,"reason":"not_a_worksheet"},{"sheet":"Account Billing","index":5,"reason":"not_a_worksheet"},{"sheet":"Skill Type Billing","index":6,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900"}

{"sheet":"Project Parameters","index":0,"n_rows":13,"n_cols":9,"rows_kept":13}
[null,"[Company Name]  "]
[null,{"$f":" Actuals!B2","v":"Project Analysis for Business Consulting Firms"}]
[null,"Company Confidential"]
[null,"Dark gray cells will be calculated for you. You do not need to enter anything into them."]
[null,"Project type","Account manager","Project manager","Business analyst","Process specialist","Finance specialist","Administration staff","Total"]
[null,"Business continuity planning",{"v":0.1,"d":"10%"},{"v":0.2,"d":"20%"},{"v":0.4,"d":"40%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"$f":"SUM(C6:H6)","v":{"v":1,"d":"100%"}}]
[null,"Business process re-engineering",{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.5,"d":"50%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":1,"d":"100%"}]
[null,"Cost reduction",{"v":0.1,"d":"10%"},{"v":0.2,"d":"20%"},{"v":0.1,"d":"10%"},{"v":0.2,"d":"20%"},{"v":0.3,"d":"30%"},{"v":0.1,"d":"10%"},{"v":1.0000000000000002,"d":"100%"}]
[null,"Process improvement",{"v":0.1,"d":"10%"},{"v":0.2,"d":"20%"},{"v":0.1,"d":"10%"},{"v":0.4,"d":"40%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":1,"d":"100%"}]
[null,"Sarbanes-Oxley",{"v":0.1,"d":"10%"},{"v":0.2,"d":"20%"},{"v":0.2,"d":"20%"},{"v":0.2,"d":"20%"},{"v":0.2,"d":"20%"},{"v":0.1,"d":"10%"},{"v":0.9999999999999999,"d":"100%"}]
[null,"Strategic planning",{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.5,"d":"50%"},{"v":0,"d":"0%"},{"v":0.2,"d":"20%"},{"v":0.1,"d":"10%"},{"v":0.9999999999999999,"d":"100%"}]
[]
[null,"Blended rates",{"v":250,"d":"€ 250.00"},{"v":225,"d":"€ 225.00"},{"v":200,"d":"€ 200.00"},{"v":175,"d":"€ 175.00"},{"v":150,"d":"€ 150.00"},{"v":50,"d":"€ 50.00"}]

{"sheet":"Actuals","index":1,"n_rows":30,"n_cols":7,"rows_kept":30}
[null,"[Company Name]  "]
[null,"Project Analysis for Business Consulting Firms"]
[null,"Company Confidential"]
[]
[null,"Dark gray cells will be calculated for you. You do not need to enter anything into them."]
[null,"Project name","Project type","Actual start","Actual finish","Actual work in hours","Duration in days"]
[null,"A. Datum Corporation","Business continuity planning","2004-01-04","2004-03-04",200,{"$f":"DAYS360(D7,E7,FALSE)","v":60}]
[null,"Adventure Works","Business process re-engineering","2004-01-20","2004-02-21",400,{"$f":"DAYS360(D8,E8,FALSE)","v":31}]
[null,"Alpine Ski House","Cost reduction","2004-02-06","2004-04-16",500,70]
[null,"Baldwin Museum of Science","Process improvement","2004-02-24","2004-04-25",150,61]
[null,"Blue Yonder Airlines","Cost reduction","2004-03-08","2004-03-18",250,10]
[null,"City Power & Light","Sarbanes-Oxley","2004-03-19","2004-04-29",300,40]
[null,"Coho Vineyard","Strategic planning","2004-04-10","2004-04-20",500,10]
[null,"Coho Winery","Cost reduction","2004-04-18","2004-05-12",750,24]
[null,"Coho Vineyard & Winery","Sarbanes-Oxley","2004-05-12","2004-06-22",450,40]
[null,"Contoso, Ltd.","Cost reduction","2004-05-23","2004-07-21",250,58]
[null,"Contoso Pharmaceuticals","Business process re-engineering","2004-06-14","2004-08-12",200,58]
[null,"Consolidated Messenger","Process improvement","2004-06-30","2004-08-30",180,60]
[null,"Fabrikam, Inc.","Cost reduction","2004-01-16","2004-08-15",250,209]
[null,"Fourth Coffee","Sarbanes-Oxley","2004-07-17","2004-09-01",240,44]
[null,"Graphic Design Institute","Sarbanes-Oxley","2004-07-25","2004-09-30",320,65]
[null,"Humongous Insurance","Cost reduction","2004-08-01","2004-10-01",550,60]
[null,"Litware, Inc.","Strategic planning","2004-08-20","2004-10-02",350,42]
[null,"Lucerne Publishing","Business continuity planning","2004-09-02","2004-11-12",200,70]
[null,"Margie's Travel","Cost reduction","2004-09-12","2004-11-25",220,73]
[null,"Northwind Traders","Process improvement","2004-10-12","2004-12-20",600,68]
[null,"Proseware, Inc.","Sarbanes-Oxley","2004-10-24","2004-12-14",525,50]
[null,"School of Fine Art","Cost reduction","2004-11-04","2004-11-24",180,20]
[]
[null,"Total",{"$nulls":3},{"$f":"SUM(F7:F28)","v":{"v":7565,"d":"7,565"}}]

{"sheet":"Actual Totals","index":2,"n_rows":29,"n_cols":10,"rows_kept":29}
[null,"[Company Name]  "]
[null,{"$f":" Actuals!B2","v":"Project Analysis for Business Consulting Firms"}]
[null,"Company Confidential"]
[]
[null,"Project name",{"$f":"'Project Parameters'!C5","v":"Account manager"},{"$f":"'Project Parameters'!D5","v":"Project manager"},{"$f":"'Project Parameters'!E5","v":"Business analyst"},{"$f":"'Project Parameters'!F5","v":"Process specialist"},{"$f":"'Project Parameters'!G5","v":"Finance specialist"},{"$f":"'Project Parameters'!H5","v":"Administration staff"},"Month of completion","Total\nbillings"]
[null,"A. Datum Corporation",{"$f":" IF( Actuals!$C7 = 'Project Parameters'!$B$6, 'Project Parameters'!C$6 * 'Project Parameters'!C$13 * Actuals!$F7, IF(Actuals!$C7 = 'Project Parameters'!$B$7, 'Project Parameters'!C$7 * 'Project Parameters'!C$13 * Actuals!$F7, IF(Actuals!$C7 = 'Project Parameters'!$B$8, 'Project Parameters'!C$8 * 'Project Parameters'!C$13 * Actuals!$F7, IF(Actuals!$C7 = 'Project Parameters'!$B$9, 'Project Parameters'!C$9 * 'Project Parameters'!C$13 * Actuals!$F7, IF(Actuals!$C7 = 'Project Parameters'!$B$10, 'Project Parameters'!C$10 * 'Project Parameters'!C$13 * Actuals!$F7, IF(Actuals!$C7 = 'Project Parameters'!$B$11, 'Project Parameters'!C$11 * 'Project Parameters'!C$13 * Actuals!$F7,error))))))","v":{"v":5000,"d":"€ 5,000.00"}},{"$f":" IF( Actuals!$C7 = 'Project Parameters'!$B$6, 'Project Parameters'!D$6 * 'Project Parameters'!D$13 * Actuals!$F7, IF(Actuals!$C7 = 'Project Parameters'!$B$7, 'Project Parameters'!D$7 * 'Project Parameters'!D$13 * Actuals!$F7, IF(Actuals!$C7 = 'Project Parameters'!$B$8, 'Project Parameters'!D$8 * 'Project Parameters'!D$13 * Actuals!$F7, IF(Actuals!$C7 = 'Project Parameters'!$B$9, 'Project Parameters'!D$9 * 'Project Parameters'!D$13 * Actuals!$F7, IF(Actuals!$C7 = 'Project Parameters'!$B$10, 'Project Parameters'!D$10 * 'Project Parameters'!D$13 * Actuals!$F7, IF(Actuals!$C7 = 'Project Parameters'!$B$11, 'Project Parameters'!D$11 * 'Project Parameters'!D$13 * Actuals!$F7,error))))))","v":{"v":9000,"d":"€ 9,000.00"}},{"$f":" IF( Actuals!$C7 = 'Project Parameters'!$B$6, 'Project Parameters'!E$6 * 'Project Parameters'!E$13 * Actuals!$F7, IF(Actuals!$C7 = 'Project Parameters'!$B$7, 'Project Parameters'!E$7 * 'Project Parameters'!E$13 * Actuals!$F7, IF(Actuals!$C7 = 'Project Parameters'!$B$8, 'Project Parameters'!E$8 * 'Project Parameters'!E$13 * Actuals!$F7, IF(Actuals!$C7 = 'Project Parameters'!$B$9, 'Project Parameters'!E$9 * 'Project Parameters'!E$13 * Actuals!$F7, IF(Actuals!$C7 = 'Project Parameters'!$B$10, 'Project Parameters'!E$10 * 'Project Parameters'!E$13 * Actuals!$F7, IF(Actuals!$C7 = 'Project Parameters'!$B$11, 'Project Parameters'!E$11 * 'Project Parameters'!E$13 * Actuals!$F7,error))))))","v":{"v":16000,"d":"€ 16,000.00"}},{"$f":" IF( Actuals!$C7 = 'Project Parameters'!$B$6, 'Project Parameters'!F$6 * 'Project Parameters'!F$13 * Actuals!$F7, IF(Actuals!$C7 = 'Project Parameters'!$B$7, 'Project Parameters'!F$7 * 'Project Parameters'!F$13 * Actuals!$F7, IF(Actuals!$C7 = 'Project Parameters'!$B$8, 'Project Parameters'!F$8 * 'Project Parameters'!F$13 * Actuals!$F7, IF(Actuals!$C7 = 'Project Parameters'!$B$9, 'Project Parameters'!F$9 * 'Project Parameters'!F$13 * Actuals!$F7, IF(Actuals!$C7 = 'Project Parameters'!$B$10, 'Project Parameters'!F$10 * 'Project Parameters'!F$13 * Actuals!$F7, IF(Actuals!$C7 = 'Project Parameters'!$B$11, 'Project Parameters'!F$11 * 'Project Parameters'!F$13 * Actuals!$F7,error))))))","v":{"v":3500,"d":"€ 3,500.00"}},{"$f":" IF( Actuals!$C7 = 'Project Parameters'!$B$6, 'Project Parameters'!G$6 * 'Project Parameters'!G$13 * Actuals!$F7, IF(Actuals!$C7 = 'Project Parameters'!$B$7, 'Project Parameters'!G$7 * 'Project Parameters'!G$13 * Actuals!$F7, IF(Actuals!$C7 = 'Project Parameters'!$B$8, 'Project Parameters'!G$8 * 'Project Parameters'!G$13 * Actuals!$F7, IF(Actuals!$C7 = 'Project Parameters'!$B$9, 'Project Parameters'!G$9 * 'Project Parameters'!G$13 * Actuals!$F7, IF(Actuals!$C7 = 'Project Parameters'!$B$10, 'Project Parameters'!G$10 * 'Project Parameters'!G$13 * Actuals!$F7, IF(Actuals!$C7 = 'Project Parameters'!$B$11, 'Project Parameters'!G$11 * 'Project Parameters'!G$13 * Actuals!$F7,error))))))","v":{"v":3000,"d":"€ 3,000.00"}},{"$f":" IF( Actuals!$C7 = 'Project Parameters'!$B$6, 'Project Parameters'!H$6 * 'Project Parameters'!H$13 * Actuals!$F7, IF(Actuals!$C7 = 'Project Parameters'!$B$7, 'Project Parameters'!H$7 * 'Project Parameters'!H$13 * Actuals!$F7, IF(Actuals!$C7 = 'Project Parameters'!$B$8, 'Project Parameters'!H$8 * 'Project Parameters'!H$13 * Actuals!$F7, IF(Actuals!$C7 = 'Project Parameters'!$B$9, 'Project Parameters'!H$9 * 'Project Parameters'!H$13 * Actuals!$F7, IF(Actuals!$C7 = 'Project Parameters'!$B$10, 'Project Parameters'!H$10 * 'Project Parameters'!H$13 * Actuals!$F7, IF(Actuals!$C7 = 'Project Parameters'!$B$11, 'Project Parameters'!H$11 * 'Project Parameters'!H$13 * Actuals!$F7,error))))))","v":{"v":1000,"d":"€ 1,000.00"}},{"$f":"MONTH(Actuals!E7)","v":3},{"$f":"SUM(C6:H6)","v":{"v":37500,"d":"€ 37,500.00"}}]
[null,"Adventure Works",{"$f":" IF( Actuals!$C8 = 'Project Parameters'!$B$6, 'Project Parameters'!C$6 * 'Project Parameters'!C$13 * Actuals!$F8, IF(Actuals!$C8 = 'Project Parameters'!$B$7, 'Project Parameters'!C$7 * 'Project Parameters'!C$13 * Actuals!$F8, IF(Actuals!$C8 = 'Project Parameters'!$B$8, 'Project Parameters'!C$8 * 'Project Parameters'!C$13 * Actuals!$F8, IF(Actuals!$C8 = 'Project Parameters'!$B$9, 'Project Parameters'!C$9 * 'Project Parameters'!C$13 * Actuals!$F8, IF(Actuals!$C8 = 'Project Parameters'!$B$10, 'Project Parameters'!C$10 * 'Project Parameters'!C$13 * Actuals!$F8, IF(Actuals!$C8 = 'Project Parameters'!$B$11, 'Project Parameters'!C$11 * 'Project Parameters'!C$13 * Actuals!$F8,error))))))","v":{"v":10000,"d":"€ 10,000.00"}},{"$f":" IF( Actuals!$C8 = 'Project Parameters'!$B$6, 'Project Parameters'!D$6 * 'Project Parameters'!D$13 * Actuals!$F8, IF(Actuals!$C8 = 'Project Parameters'!$B$7, 'Project Parameters'!D$7 * 'Project Parameters'!D$13 * Actuals!$F8, IF(Actuals!$C8 = 'Project Parameters'!$B$8, 'Project Parameters'!D$8 * 'Project Parameters'!D$13 * Actuals!$F8, IF(Actuals!$C8 = 'Project Parameters'!$B$9, 'Project Parameters'!D$9 * 'Project Parameters'!D$13 * Actuals!$F8, IF(Actuals!$C8 = 'Project Parameters'!$B$10, 'Project Parameters'!D$10 * 'Project Parameters'!D$13 * Actuals!$F8, IF(Actuals!$C8 = 'Project Parameters'!$B$11, 'Project Parameters'!D$11 * 'Project Parameters'!D$13 * Actuals!$F8,error))))))","v":{"v":9000,"d":"€ 9,000.00"}},{"$f":" IF( Actuals!$C8 = 'Project Parameters'!$B$6, 'Project Parameters'!E$6 * 'Project Parameters'!E$13 * Actuals!$F8, IF(Actuals!$C8 = 'Project Parameters'!$B$7, 'Project Parameters'!E$7 * 'Project Parameters'!E$13 * Actuals!$F8, IF(Actuals!$C8 = 'Project Parameters'!$B$8, 'Project Parameters'!E$8 * 'Project Parameters'!E$13 * Actuals!$F8, IF(Actuals!$C8 = 'Project Parameters'!$B$9, 'Project Parameters'!E$9 * 'Project Parameters'!E$13 * Actuals!$F8, IF(Actuals!$C8 = 'Project Parameters'!$B$10, 'Project Parameters'!E$10 * 'Project Parameters'!E$13 * Actuals!$F8, IF(Actuals!$C8 = 'Project Parameters'!$B$11, 'Project Parameters'!E$11 * 'Project Parameters'!E$13 * Actuals!$F8,error))))))","v":{"v":8000,"d":"€ 8,000.00"}},{"$f":" IF( Actuals!$C8 = 'Project Parameters'!$B$6, 'Project Parameters'!F$6 * 'Project Parameters'!F$13 * Actuals!$F8, IF(Actuals!$C8 = 'Project Parameters'!$B$7, 'Project Parameters'!F$7 * 'Project Parameters'!F$13 * Actuals!$F8, IF(Actuals!$C8 = 'Project Parameters'!$B$8, 'Project Parameters'!F$8 * 'Project Parameters'!F$13 * Actuals!$F8, IF(Actuals!$C8 = 'Project Parameters'!$B$9, 'Project Parameters'!F$9 * 'Project Parameters'!F$13 * Actuals!$F8, IF(Actuals!$C8 = 'Project Parameters'!$B$10, 'Project Parameters'!F$10 * 'Project Parameters'!F$13 * Actuals!$F8, IF(Actuals!$C8 = 'Project Parameters'!$B$11, 'Project Parameters'!F$11 * 'Project Parameters'!F$13 * Actuals!$F8,error))))))","v":{"v":35000,"d":"€ 35,000.00"}},{"$f":" IF( Actuals!$C8 = 'Project Parameters'!$B$6, 'Project Parameters'!G$6 * 'Project Parameters'!G$13 * Actuals!$F8, IF(Actuals!$C8 = 'Project Parameters'!$B$7, 'Project Parameters'!G$7 * 'Project Parameters'!G$13 * Actuals!$F8, IF(Actuals!$C8 = 'Project Parameters'!$B$8, 'Project Parameters'!G$8 * 'Project Parameters'!G$13 * Actuals!$F8, IF(Actuals!$C8 = 'Project Parameters'!$B$9, 'Project Parameters'!G$9 * 'Project Parameters'!G$13 * Actuals!$F8, IF(Actuals!$C8 = 'Project Parameters'!$B$10, 'Project Parameters'!G$10 * 'Project Parameters'!G$13 * Actuals!$F8, IF(Actuals!$C8 = 'Project Parameters'!$B$11, 'Project Parameters'!G$11 * 'Project Parameters'!G$13 * Actuals!$F8,error))))))","v":{"v":6000,"d":"€ 6,000.00"}},{"$f":" IF( Actuals!$C8 = 'Project Parameters'!$B$6, 'Project Parameters'!H$6 * 'Project Parameters'!H$13 * Actuals!$F8, IF(Actuals!$C8 = 'Project Parameters'!$B$7, 'Project Parameters'!H$7 * 'Project Parameters'!H$13 * Actuals!$F8, IF(Actuals!$C8 = 'Project Parameters'!$B$8, 'Project Parameters'!H$8 * 'Project Parameters'!H$13 * Actuals!$F8, IF(Actuals!$C8 = 'Project Parameters'!$B$9, 'Project Parameters'!H$9 * 'Project Parameters'!H$13 * Actuals!$F8, IF(Actuals!$C8 = 'Project Parameters'!$B$10, 'Project Parameters'!H$10 * 'Project Parameters'!H$13 * Actuals!$F8, IF(Actuals!$C8 = 'Project Parameters'!$B$11, 'Project Parameters'!H$11 * 'Project Parameters'!H$13 * Actuals!$F8,error))))))","v":{"v":2000,"d":"€ 2,000.00"}},{"$f":"MONTH(Actuals!E8)","v":2},{"v":70000,"d":"€ 70,000.00"}]
[null,"Alpine Ski House",{"$f":" IF( Actuals!$C9 = 'Project Parameters'!$B$6, 'Project Parameters'!C$6 * 'Project Parameters'!C$13 * Actuals!$F9, IF(Actuals!$C9 = 'Project Parameters'!$B$7, 'Project Parameters'!C$7 * 'Project Parameters'!C$13 * Actuals!$F9, IF(Actuals!$C9 = 'Project Parameters'!$B$8, 'Project Parameters'!C$8 * 'Project Parameters'!C$13 * Actuals!$F9, IF(Actuals!$C9 = 'Project Parameters'!$B$9, 'Project Parameters'!C$9 * 'Project Parameters'!C$13 * Actuals!$F9, IF(Actuals!$C9 = 'Project Parameters'!$B$10, 'Project Parameters'!C$10 * 'Project Parameters'!C$13 * Actuals!$F9, IF(Actuals!$C9 = 'Project Parameters'!$B$11, 'Project Parameters'!C$11 * 'Project Parameters'!C$13 * Actuals!$F9,error))))))","v":{"v":12500,"d":"€ 12,500.00"}},{"$f":" IF( Actuals!$C9 = 'Project Parameters'!$B$6, 'Project Parameters'!D$6 * 'Project Parameters'!D$13 * Actuals!$F9, IF(Actuals!$C9 = 'Project Parameters'!$B$7, 'Project Parameters'!D$7 * 'Project Parameters'!D$13 * Actuals!$F9, IF(Actuals!$C9 = 'Project Parameters'!$B$8, 'Project Parameters'!D$8 * 'Project Parameters'!D$13 * Actuals!$F9, IF(Actuals!$C9 = 'Project Parameters'!$B$9, 'Project Parameters'!D$9 * 'Project Parameters'!D$13 * Actuals!$F9, IF(Actuals!$C9 = 'Project Parameters'!$B$10, 'Project Parameters'!D$10 * 'Project Parameters'!D$13 * Actuals!$F9, IF(Actuals!$C9 = 'Project Parameters'!$B$11, 'Project Parameters'!D$11 * 'Project Parameters'!D$13 * Actuals!$F9,error))))))","v":{"v":22500,"d":"€ 22,500.00"}},{"$f":" IF( Actuals!$C9 = 'Project Parameters'!$B$6, 'Project Parameters'!E$6 * 'Project Parameters'!E$13 * Actuals!$F9, IF(Actuals!$C9 = 'Project Parameters'!$B$7, 'Project Parameters'!E$7 * 'Project Parameters'!E$13 * Actuals!$F9, IF(Actuals!$C9 = 'Project Parameters'!$B$8, 'Project Parameters'!E$8 * 'Project Parameters'!E$13 * Actuals!$F9, IF(Actuals!$C9 = 'Project Parameters'!$B$9, 'Project Parameters'!E$9 * 'Project Parameters'!E$13 * Actuals!$F9, IF(Actuals!$C9 = 'Project Parameters'!$B$10, 'Project Parameters'!E$10 * 'Project Parameters'!E$13 * Actuals!$F9, IF(Actuals!$C9 = 'Project Parameters'!$B$11, 'Project Parameters'!E$11 * 'Project Parameters'!E$13 * Actuals!$F9,error))))))","v":{"v":10000,"d":"€ 10,000.00"}},{"$f":" IF( Actuals!$C9 = 'Project Parameters'!$B$6, 'Project Parameters'!F$6 * 'Project Parameters'!F$13 * Actuals!$F9, IF(Actuals!$C9 = 'Project Parameters'!$B$7, 'Project Parameters'!F$7 * 'Project Parameters'!F$13 * Actuals!$F9, IF(Actuals!$C9 = 'Project Parameters'!$B$8, 'Project Parameters'!F$8 * 'Project Parameters'!F$13 * Actuals!$F9, IF(Actuals!$C9 = 'Project Parameters'!$B$9, 'Project Parameters'!F$9 * 'Project Parameters'!F$13 * Actuals!$F9, IF(Actuals!$C9 = 'Project Parameters'!$B$10, 'Project Parameters'!F$10 * 'Project Parameters'!F$13 * Actuals!$F9, IF(Actuals!$C9 = 'Project Parameters'!$B$11, 'Project Parameters'!F$11 * 'Project Parameters'!F$13 * Actuals!$F9,error))))))","v":{"v":17500,"d":"€ 17,500.00"}},{"$f":" IF( Actuals!$C9 = 'Project Parameters'!$B$6, 'Project Parameters'!G$6 * 'Project Parameters'!G$13 * Actuals!$F9, IF(Actuals!$C9 = 'Project Parameters'!$B$7, 'Project Parameters'!G$7 * 'Project Parameters'!G$13 * Actuals!$F9, IF(Actuals!$C9 = 'Project Parameters'!$B$8, 'Project Parameters'!G$8 * 'Project Parameters'!G$13 * Actuals!$F9, IF(Actuals!$C9 = 'Project Parameters'!$B$9, 'Project Parameters'!G$9 * 'Project Parameters'!G$13 * Actuals!$F9, IF(Actuals!$C9 = 'Project Parameters'!$B$10, 'Project Parameters'!G$10 * 'Project Parameters'!G$13 * Actuals!$F9, IF(Actuals!$C9 = 'Project Parameters'!$B$11, 'Project Parameters'!G$11 * 'Project Parameters'!G$13 * Actuals!$F9,error))))))","v":{"v":22500,"d":"€ 22,500.00"}},{"$f":" IF( Actuals!$C9 = 'Project Parameters'!$B$6, 'Project Parameters'!H$6 * 'Project Parameters'!H$13 * Actuals!$F9, IF(Actuals!$C9 = 'Project Parameters'!$B$7, 'Project Parameters'!H$7 * 'Project Parameters'!H$13 * Actuals!$F9, IF(Actuals!$C9 = 'Project Parameters'!$B$8, 'Project Parameters'!H$8 * 'Project Parameters'!H$13 * Actuals!$F9, IF(Actuals!$C9 = 'Project Parameters'!$B$9, 'Project Parameters'!H$9 * 'Project Parameters'!H$13 * Actuals!$F9, IF(Actuals!$C9 = 'Project Parameters'!$B$10, 'Project Parameters'!H$10 * 'Project Parameters'!H$13 * Actuals!$F9, IF(Actuals!$C9 = 'Project Parameters'!$B$11, 'Project Parameters'!H$11 * 'Project Parameters'!H$13 * Actuals!$F9,error))))))","v":{"v":2500,"d":"€ 2,500.00"}},{"$f":"MONTH(Actuals!E9)","v":4},{"v":87500,"d":"€ 87,500.00"}]
[null,"Baldwin Museum of Science",{"$f":" IF( Actuals!$C10 = 'Project Parameters'!$B$6, 'Project Parameters'!C$6 * 'Project Parameters'!C$13 * Actuals!$F10, IF(Actuals!$C10 = 'Project Parameters'!$B$7, 'Project Parameters'!C$7 * 'Project Parameters'!C$13 * Actuals!$F10, IF(Actuals!$C10 = 'Project Parameters'!$B$8, 'Project Parameters'!C$8 * 'Project Parameters'!C$13 * Actuals!$F10, IF(Actuals!$C10 = 'Project Parameters'!$B$9, 'Project Parameters'!C$9 * 'Project Parameters'!C$13 * Actuals!$F10, IF(Actuals!$C10 = 'Project Parameters'!$B$10, 'Project Parameters'!C$10 * 'Project Parameters'!C$13 * Actuals!$F10, IF(Actuals!$C10 = 'Project Parameters'!$B$11, 'Project Parameters'!C$11 * 'Project Parameters'!C$13 * Actuals!$F10,error))))))","v":{"v":3750,"d":"€ 3,750.00"}},{"$f":" IF( Actuals!$C10 = 'Project Parameters'!$B$6, 'Project Parameters'!D$6 * 'Project Parameters'!D$13 * Actuals!$F10, IF(Actuals!$C10 = 'Project Parameters'!$B$7, 'Project Parameters'!D$7 * 'Project Parameters'!D$13 * Actuals!$F10, IF(Actuals!$C10 = 'Project Parameters'!$B$8, 'Project Parameters'!D$8 * 'Project Parameters'!D$13 * Actuals!$F10, IF(Actuals!$C10 = 'Project Parameters'!$B$9, 'Project Parameters'!D$9 * 'Project Parameters'!D$13 * Actuals!$F10, IF(Actuals!$C10 = 'Project Parameters'!$B$10, 'Project Parameters'!D$10 * 'Project Parameters'!D$13 * Actuals!$F10, IF(Actuals!$C10 = 'Project Parameters'!$B$11, 'Project Parameters'!D$11 * 'Project Parameters'!D$13 * Actuals!$F10,error))))))","v":{"v":6750,"d":"€ 6,750.00"}},{"$f":" IF( Actuals!$C10 = 'Project Parameters'!$B$6, 'Project Parameters'!E$6 * 'Project Parameters'!E$13 * Actuals!$F10, IF(Actuals!$C10 = 'Project Parameters'!$B$7, 'Project Parameters'!E$7 * 'Project Parameters'!E$13 * Actuals!$F10, IF(Actuals!$C10 = 'Project Parameters'!$B$8, 'Project Parameters'!E$8 * 'Project Parameters'!E$13 * Actuals!$F10, IF(Actuals!$C10 = 'Project Parameters'!$B$9, 'Project Parameters'!E$9 * 'Project Parameters'!E$13 * Actuals!$F10, IF(Actuals!$C10 = 'Project Parameters'!$B$10, 'Project Parameters'!E$10 * 'Project Parameters'!E$13 * Actuals!$F10, IF(Actuals!$C10 = 'Project Parameters'!$B$11, 'Project Parameters'!E$11 * 'Project Parameters'!E$13 * Actuals!$F10,error))))))","v":{"v":3000,"d":"€ 3,000.00"}},{"$f":" IF( Actuals!$C10 = 'Project Parameters'!$B$6, 'Project Parameters'!F$6 * 'Project Parameters'!F$13 * Actuals!$F10, IF(Actuals!$C10 = 'Project Parameters'!$B$7, 'Project Parameters'!F$7 * 'Project Parameters'!F$13 * Actuals!$F10, IF(Actuals!$C10 = 'Project Parameters'!$B$8, 'Project Parameters'!F$8 * 'Project Parameters'!F$13 * Actuals!$F10, IF(Actuals!$C10 = 'Project Parameters'!$B$9, 'Project Parameters'!F$9 * 'Project Parameters'!F$13 * Actuals!$F10, IF(Actuals!$C10 = 'Project Parameters'!$B$10, 'Project Parameters'!F$10 * 'Project Parameters'!F$13 * Actuals!$F10, IF(Actuals!$C10 = 'Project Parameters'!$B$11, 'Project Parameters'!F$11 * 'Project Parameters'!F$13 * Actuals!$F10,error))))))","v":{"v":10500,"d":"€ 10,500.00"}},{"$f":" IF( Actuals!$C10 = 'Project Parameters'!$B$6, 'Project Parameters'!G$6 * 'Project Parameters'!G$13 * Actuals!$F10, IF(Actuals!$C10 = 'Project Parameters'!$B$7, 'Project Parameters'!G$7 * 'Project Parameters'!G$13 * Actuals!$F10, IF(Actuals!$C10 = 'Project Parameters'!$B$8, 'Project Parameters'!G$8 * 'Project Parameters'!G$13 * Actuals!$F10, IF(Actuals!$C10 = 'Project Parameters'!$B$9, 'Project Parameters'!G$9 * 'Project Parameters'!G$13 * Actuals!$F10, IF(Actuals!$C10 = 'Project Parameters'!$B$10, 'Project Parameters'!G$10 * 'Project Parameters'!G$13 * Actuals!$F10, IF(Actuals!$C10 = 'Project Parameters'!$B$11, 'Project Parameters'!G$11 * 'Project Parameters'!G$13 * Actuals!$F10,error))))))","v":{"v":2250,"d":"€ 2,250.00"}},{"$f":" IF( Actuals!$C10 = 'Project Parameters'!$B$6, 'Project Parameters'!H$6 * 'Project Parameters'!H$13 * Actuals!$F10, IF(Actuals!$C10 = 'Project Parameters'!$B$7, 'Project Parameters'!H$7 * 'Project Parameters'!H$13 * Actuals!$F10, IF(Actuals!$C10 = 'Project Parameters'!$B$8, 'Project Parameters'!H$8 * 'Project Parameters'!H$13 * Actuals!$F10, IF(Actuals!$C10 = 'Project Parameters'!$B$9, 'Project Parameters'!H$9 * 'Project Parameters'!H$13 * Actuals!$F10, IF(Actuals!$C10 = 'Project Parameters'!$B$10, 'Project Parameters'!H$10 * 'Project Parameters'!H$13 * Actuals!$F10, IF(Actuals!$C10 = 'Project Parameters'!$B$11, 'Project Parameters'!H$11 * 'Project Parameters'!H$13 * Actuals!$F10,error))))))","v":{"v":750,"d":"€ 750.00"}},{"$f":"MONTH(Actuals!E10)","v":4},{"v":27000,"d":"€ 27,000.00"}]
[null,"Blue Yonder Airlines",{"$f":" IF( Actuals!$C11 = 'Project Parameters'!$B$6, 'Project Parameters'!C$6 * 'Project Parameters'!C$13 * Actuals!$F11, IF(Actuals!$C11 = 'Project Parameters'!$B$7, 'Project Parameters'!C$7 * 'Project Parameters'!C$13 * Actuals!$F11, IF(Actuals!$C11 = 'Project Parameters'!$B$8, 'Project Parameters'!C$8 * 'Project Parameters'!C$13 * Actuals!$F11, IF(Actuals!$C11 = 'Project Parameters'!$B$9, 'Project Parameters'!C$9 * 'Project Parameters'!C$13 * Actuals!$F11, IF(Actuals!$C11 = 'Project Parameters'!$B$10, 'Project Parameters'!C$10 * 'Project Parameters'!C$13 * Actuals!$F11, IF(Actuals!$C11 = 'Project Parameters'!$B$11, 'Project Parameters'!C$11 * 'Project Parameters'!C$13 * Actuals!$F11,error))))))","v":{"v":6250,"d":"€ 6,250.00"}},{"$f":" IF( Actuals!$C11 = 'Project Parameters'!$B$6, 'Project Parameters'!D$6 * 'Project Parameters'!D$13 * Actuals!$F11, IF(Actuals!$C11 = 'Project Parameters'!$B$7, 'Project Parameters'!D$7 * 'Project Parameters'!D$13 * Actuals!$F11, IF(Actuals!$C11 = 'Project Parameters'!$B$8, 'Project Parameters'!D$8 * 'Project Parameters'!D$13 * Actuals!$F11, IF(Actuals!$C11 = 'Project Parameters'!$B$9, 'Project Parameters'!D$9 * 'Project Parameters'!D$13 * Actuals!$F11, IF(Actuals!$C11 = 'Project Parameters'!$B$10, 'Project Parameters'!D$10 * 'Project Parameters'!D$13 * Actuals!$F11, IF(Actuals!$C11 = 'Project Parameters'!$B$11, 'Project Parameters'!D$11 * 'Project Parameters'!D$13 * Actuals!$F11,error))))))","v":{"v":11250,"d":"€ 11,250.00"}},{"$f":" IF( Actuals!$C11 = 'Project Parameters'!$B$6, 'Project Parameters'!E$6 * 'Project Parameters'!E$13 * Actuals!$F11, IF(Actuals!$C11 = 'Project Parameters'!$B$7, 'Project Parameters'!E$7 * 'Project Parameters'!E$13 * Actuals!$F11, IF(Actuals!$C11 = 'Project Parameters'!$B$8, 'Project Parameters'!E$8 * 'Project Parameters'!E$13 * Actuals!$F11, IF(Actuals!$C11 = 'Project Parameters'!$B$9, 'Project Parameters'!E$9 * 'Project Parameters'!E$13 * Actuals!$F11, IF(Actuals!$C11 = 'Project Parameters'!$B$10, 'Project Parameters'!E$10 * 'Project Parameters'!E$13 * Actuals!$F11, IF(Actuals!$C11 = 'Project Parameters'!$B$11, 'Project Parameters'!E$11 * 'Project Parameters'!E$13 * Actuals!$F11,error))))))","v":{"v":5000,"d":"€ 5,000.00"}},{"$f":" IF( Actuals!$C11 = 'Project Parameters'!$B$6, 'Project Parameters'!F$6 * 'Project Parameters'!F$13 * Actuals!$F11, IF(Actuals!$C11 = 'Project Parameters'!$B$7, 'Project Parameters'!F$7 * 'Project Parameters'!F$13 * Actuals!$F11, IF(Actuals!$C11 = 'Project Parameters'!$B$8, 'Project Parameters'!F$8 * 'Project Parameters'!F$13 * Actuals!$F11, IF(Actuals!$C11 = 'Project Parameters'!$B$9, 'Project Parameters'!F$9 * 'Project Parameters'!F$13 * Actuals!$F11, IF(Actuals!$C11 = 'Project Parameters'!$B$10, 'Project Parameters'!F$10 * 'Project Parameters'!F$13 * Actuals!$F11, IF(Actuals!$C11 = 'Project Parameters'!$B$11, 'Project Parameters'!F$11 * 'Project Parameters'!F$13 * Actuals!$F11,error))))))","v":{"v":8750,"d":"€ 8,750.00"}},{"$f":" IF( Actuals!$C11 = 'Project Parameters'!$B$6, 'Project Parameters'!G$6 * 'Project Parameters'!G$13 * Actuals!$F11, IF(Actuals!$C11 = 'Project Parameters'!$B$7, 'Project Parameters'!G$7 * 'Project Parameters'!G$13 * Actuals!$F11, IF(Actuals!$C11 = 'Project Parameters'!$B$8, 'Project Parameters'!G$8 * 'Project Parameters'!G$13 * Actuals!$F11, IF(Actuals!$C11 = 'Project Parameters'!$B$9, 'Project Parameters'!G$9 * 'Project Parameters'!G$13 * Actuals!$F11, IF(Actuals!$C11 = 'Project Parameters'!$B$10, 'Project Parameters'!G$10 * 'Project Parameters'!G$13 * Actuals!$F11, IF(Actuals!$C11 = 'Project Parameters'!$B$11, 'Project Parameters'!G$11 * 'Project Parameters'!G$13 * Actuals!$F11,error))))))","v":{"v":11250,"d":"€ 11,250.00"}},{"$f":" IF( Actuals!$C11 = 'Project Parameters'!$B$6, 'Project Parameters'!H$6 * 'Project Parameters'!H$13 * Actuals!$F11, IF(Actuals!$C11 = 'Project Parameters'!$B$7, 'Project Parameters'!H$7 * 'Project Parameters'!H$13 * Actuals!$F11, IF(Actuals!$C11 = 'Project Parameters'!$B$8, 'Project Parameters'!H$8 * 'Project Parameters'!H$13 * Actuals!$F11, IF(Actuals!$C11 = 'Project Parameters'!$B$9, 'Project Parameters'!H$9 * 'Project Parameters'!H$13 * Actuals!$F11, IF(Actuals!$C11 = 'Project Parameters'!$B$10, 'Project Parameters'!H$10 * 'Project Parameters'!H$13 * Actuals!$F11, IF(Actuals!$C11 = 'Project Parameters'!$B$11, 'Project Parameters'!H$11 * 'Project Parameters'!H$13 * Actuals!$F11,error))))))","v":{"v":1250,"d":"€ 1,250.00"}},{"$f":"MONTH(Actuals!E11)","v":3},{"v":43750,"d":"€ 43,750.00"}]
[null,"City Power & Light",{"$f":" IF( Actuals!$C12 = 'Project Parameters'!$B$6, 'Project Parameters'!C$6 * 'Project Parameters'!C$13 * Actuals!$F12, IF(Actuals!$C12 = 'Project Parameters'!$B$7, 'Project Parameters'!C$7 * 'Project Parameters'!C$13 * Actuals!$F12, IF(Actuals!$C12 = 'Project Parameters'!$B$8, 'Project Parameters'!C$8 * 'Project Parameters'!C$13 * Actuals!$F12, IF(Actuals!$C12 = 'Project Parameters'!$B$9, 'Project Parameters'!C$9 * 'Project Parameters'!C$13 * Actuals!$F12, IF(Actuals!$C12 = 'Project Parameters'!$B$10, 'Project Parameters'!C$10 * 'Project Parameters'!C$13 * Actuals!$F12, IF(Actuals!$C12 = 'Project Parameters'!$B$11, 'Project Parameters'!C$11 * 'Project Parameters'!C$13 * Actuals!$F12,error))))))","v":{"v":7500,"d":"€ 7,500.00"}},{"$f":" IF( Actuals!$C12 = 'Project Parameters'!$B$6, 'Project Parameters'!D$6 * 'Project Parameters'!D$13 * Actuals!$F12, IF(Actuals!$C12 = 'Project Parameters'!$B$7, 'Project Parameters'!D$7 * 'Project Parameters'!D$13 * Actuals!$F12, IF(Actuals!$C12 = 'Project Parameters'!$B$8, 'Project Parameters'!D$8 * 'Project Parameters'!D$13 * Actuals!$F12, IF(Actuals!$C12 = 'Project Parameters'!$B$9, 'Project Parameters'!D$9 * 'Project Parameters'!D$13 * Actuals!$F12, IF(Actuals!$C12 = 'Project Parameters'!$B$10, 'Project Parameters'!D$10 * 'Project Parameters'!D$13 * Actuals!$F12, IF(Actuals!$C12 = 'Project Parameters'!$B$11, 'Project Parameters'!D$11 * 'Project Parameters'!D$13 * Actuals!$F12,error))))))","v":{"v":13500,"d":"€ 13,500.00"}},{"$f":" IF( Actuals!$C12 = 'Project Parameters'!$B$6, 'Project Parameters'!E$6 * 'Project Parameters'!E$13 * Actuals!$F12, IF(Actuals!$C12 = 'Project Parameters'!$B$7, 'Project Parameters'!E$7 * 'Project Parameters'!E$13 * Actuals!$F12, IF(Actuals!$C12 = 'Project Parameters'!$B$8, 'Project Parameters'!E$8 * 'Project Parameters'!E$13 * Actuals!$F12, IF(Actuals!$C12 = 'Project Parameters'!$B$9, 'Project Parameters'!E$9 * 'Project Parameters'!E$13 * Actuals!$F12, IF(Actuals!$C12 = 'Project Parameters'!$B$10, 'Project Parameters'!E$10 * 'Project Parameters'!E$13 * Actuals!$F12, IF(Actuals!$C12 = 'Project Parameters'!$B$11, 'Project Parameters'!E$11 * 'Project Parameters'!E$13 * Actuals!$F12,error))))))","v":{"v":12000,"d":"€ 12,000.00"}},{"$f":" IF( Actuals!$C12 = 'Project Parameters'!$B$6, 'Project Parameters'!F$6 * 'Project Parameters'!F$13 * Actuals!$F12, IF(Actuals!$C12 = 'Project Parameters'!$B$7, 'Project Parameters'!F$7 * 'Project Parameters'!F$13 * Actuals!$F12, IF(Actuals!$C12 = 'Project Parameters'!$B$8, 'Project Parameters'!F$8 * 'Project Parameters'!F$13 * Actuals!$F12, IF(Actuals!$C12 = 'Project Parameters'!$B$9, 'Project Parameters'!F$9 * 'Project Parameters'!F$13 * Actuals!$F12, IF(Actuals!$C12 = 'Project Parameters'!$B$10, 'Project Parameters'!F$10 * 'Project Parameters'!F$13 * Actuals!$F12, IF(Actuals!$C12 = 'Project Parameters'!$B$11, 'Project Parameters'!F$11 * 'Project Parameters'!F$13 * Actuals!$F12,error))))))","v":{"v":10500,"d":"€ 10,500.00"}},{"$f":" IF( Actuals!$C12 = 'Project Parameters'!$B$6, 'Project Parameters'!G$6 * 'Project Parameters'!G$13 * Actuals!$F12, IF(Actuals!$C12 = 'Project Parameters'!$B$7, 'Project Parameters'!G$7 * 'Project Parameters'!G$13 * Actuals!$F12, IF(Actuals!$C12 = 'Project Parameters'!$B$8, 'Project Parameters'!G$8 * 'Project Parameters'!G$13 * Actuals!$F12, IF(Actuals!$C12 = 'Project Parameters'!$B$9, 'Project Parameters'!G$9 * 'Project Parameters'!G$13 * Actuals!$F12, IF(Actuals!$C12 = 'Project Parameters'!$B$10, 'Project Parameters'!G$10 * 'Project Parameters'!G$13 * Actuals!$F12, IF(Actuals!$C12 = 'Project Parameters'!$B$11, 'Project Parameters'!G$11 * 'Project Parameters'!G$13 * Actuals!$F12,error))))))","v":{"v":9000,"d":"€ 9,000.00"}},{"$f":" IF( Actuals!$C12 = 'Project Parameters'!$B$6, 'Project Parameters'!H$6 * 'Project Parameters'!H$13 * Actuals!$F12, IF(Actuals!$C12 = 'Project Parameters'!$B$7, 'Project Parameters'!H$7 * 'Project Parameters'!H$13 * Actuals!$F12, IF(Actuals!$C12 = 'Project Parameters'!$B$8, 'Project Parameters'!H$8 * 'Project Parameters'!H$13 * Actuals!$F12, IF(Actuals!$C12 = 'Project Parameters'!$B$9, 'Project Parameters'!H$9 * 'Project Parameters'!H$13 * Actuals!$F12, IF(Actuals!$C12 = 'Project Parameters'!$B$10, 'Project Parameters'!H$10 * 'Project Parameters'!H$13 * Actuals!$F12, IF(Actuals!$C12 = 'Project Parameters'!$B$11, 'Project Parameters'!H$11 * 'Project Parameters'!H$13 * Actuals!$F12,error))))))","v":{"v":1500,"d":"€ 1,500.00"}},{"$f":"MONTH(Actuals!E12)","v":4},{"v":54000,"d":"€ 54,000.00"}]
[null,"Coho Vineyard",{"$f":" IF( Actuals!$C13 = 'Project Parameters'!$B$6, 'Project Parameters'!C$6 * 'Project Parameters'!C$13 * Actuals!$F13, IF(Actuals!$C13 = 'Project Parameters'!$B$7, 'Project Parameters'!C$7 * 'Project Parameters'!C$13 * Actuals!$F13, IF(Actuals!$C13 = 'Project Parameters'!$B$8, 'Project Parameters'!C$8 * 'Project Parameters'!C$13 * Actuals!$F13, IF(Actuals!$C13 = 'Project Parameters'!$B$9, 'Project Parameters'!C$9 * 'Project Parameters'!C$13 * Actuals!$F13, IF(Actuals!$C13 = 'Project Parameters'!$B$10, 'Project Parameters'!C$10 * 'Project Parameters'!C$13 * Actuals!$F13, IF(Actuals!$C13 = 'Project Parameters'!$B$11, 'Project Parameters'!C$11 * 'Project Parameters'!C$13 * Actuals!$F13,error))))))","v":{"v":12500,"d":"€ 12,500.00"}},{"$f":" IF( Actuals!$C13 = 'Project Parameters'!$B$6, 'Project Parameters'!D$6 * 'Project Parameters'!D$13 * Actuals!$F13, IF(Actuals!$C13 = 'Project Parameters'!$B$7, 'Project Parameters'!D$7 * 'Project Parameters'!D$13 * Actuals!$F13, IF(Actuals!$C13 = 'Project Parameters'!$B$8, 'Project Parameters'!D$8 * 'Project Parameters'!D$13 * Actuals!$F13, IF(Actuals!$C13 = 'Project Parameters'!$B$9, 'Project Parameters'!D$9 * 'Project Parameters'!D$13 * Actuals!$F13, IF(Actuals!$C13 = 'Project Parameters'!$B$10, 'Project Parameters'!D$10 * 'Project Parameters'!D$13 * Actuals!$F13, IF(Actuals!$C13 = 'Project Parameters'!$B$11, 'Project Parameters'!D$11 * 'Project Parameters'!D$13 * Actuals!$F13,error))))))","v":{"v":11250,"d":"€ 11,250.00"}},{"$f":" IF( Actuals!$C13 = 'Project Parameters'!$B$6, 'Project Parameters'!E$6 * 'Project Parameters'!E$13 * Actuals!$F13, IF(Actuals!$C13 = 'Project Parameters'!$B$7, 'Project Parameters'!E$7 * 'Project Parameters'!E$13 * Actuals!$F13, IF(Actuals!$C13 = 'Project Parameters'!$B$8, 'Project Parameters'!E$8 * 'Project Parameters'!E$13 * Actuals!$F13, IF(Actuals!$C13 = 'Project Parameters'!$B$9, 'Project Parameters'!E$9 * 'Project Parameters'!E$13 * Actuals!$F13, IF(Actuals!$C13 = 'Project Parameters'!$B$10, 'Project Parameters'!E$10 * 'Project Parameters'!E$13 * Actuals!$F13, IF(Actuals!$C13 = 'Project Parameters'!$B$11, 'Project Parameters'!E$11 * 'Project Parameters'!E$13 * Actuals!$F13,error))))))","v":{"v":50000,"d":"€ 50,000.00"}},{"$f":" IF( Actuals!$C13 = 'Project Parameters'!$B$6, 'Project Parameters'!F$6 * 'Project Parameters'!F$13 * Actuals!$F13, IF(Actuals!$C13 = 'Project Parameters'!$B$7, 'Project Parameters'!F$7 * 'Project Parameters'!F$13 * Actuals!$F13, IF(Actuals!$C13 = 'Project Parameters'!$B$8, 'Project Parameters'!F$8 * 'Project Parameters'!F$13 * Actuals!$F13, IF(Actuals!$C13 = 'Project Parameters'!$B$9, 'Project Parameters'!F$9 * 'Project Parameters'!F$13 * Actuals!$F13, IF(Actuals!$C13 = 'Project Parameters'!$B$10, 'Project Parameters'!F$10 * 'Project Parameters'!F$13 * Actuals!$F13, IF(Actuals!$C13 = 'Project Parameters'!$B$11, 'Project Parameters'!F$11 * 'Project Parameters'!F$13 * Actuals!$F13,error))))))","v":0},{"$f":" IF( Actuals!$C13 = 'Project Parameters'!$B$6, 'Project Parameters'!G$6 * 'Project Parameters'!G$13 * Actuals!$F13, IF(Actuals!$C13 = 'Project Parameters'!$B$7, 'Project Parameters'!G$7 * 'Project Parameters'!G$13 * Actuals!$F13, IF(Actuals!$C13 = 'Project Parameters'!$B$8, 'Project Parameters'!G$8 * 'Project Parameters'!G$13 * Actuals!$F13, IF(Actuals!$C13 = 'Project Parameters'!$B$9, 'Project Parameters'!G$9 * 'Project Parameters'!G$13 * Actuals!$F13, IF(Actuals!$C13 = 'Project Parameters'!$B$10, 'Project Parameters'!G$10 * 'Project Parameters'!G$13 * Actuals!$F13, IF(Actuals!$C13 = 'Project Parameters'!$B$11, 'Project Parameters'!G$11 * 'Project Parameters'!G$13 * Actuals!$F13,error))))))","v":{"v":15000,"d":"€ 15,000.00"}},{"$f":" IF( Actuals!$C13 = 'Project Parameters'!$B$6, 'Project Parameters'!H$6 * 'Project Parameters'!H$13 * Actuals!$F13, IF(Actuals!$C13 = 'Project Parameters'!$B$7, 'Project Parameters'!H$7 * 'Project Parameters'!H$13 * Actuals!$F13, IF(Actuals!$C13 = 'Project Parameters'!$B$8, 'Project Parameters'!H$8 * 'Project Parameters'!H$13 * Actuals!$F13, IF(Actuals!$C13 = 'Project Parameters'!$B$9, 'Project Parameters'!H$9 * 'Project Parameters'!H$13 * Actuals!$F13, IF(Actuals!$C13 = 'Project Parameters'!$B$10, 'Project Parameters'!H$10 * 'Project Parameters'!H$13 * Actuals!$F13, IF(Actuals!$C13 = 'Project Parameters'!$B$11, 'Project Parameters'!H$11 * 'Project Parameters'!H$13 * Actuals!$F13,error))))))","v":{"v":2500,"d":"€ 2,500.00"}},{"$f":"MONTH(Actuals!E13)","v":4},{"v":91250,"d":"€ 91,250.00"}]
[null,"Coho Winery",{"$f":" IF( Actuals!$C14 = 'Project Parameters'!$B$6, 'Project Parameters'!C$6 * 'Project Parameters'!C$13 * Actuals!$F14, IF(Actuals!$C14 = 'Project Parameters'!$B$7, 'Project Parameters'!C$7 * 'Project Parameters'!C$13 * Actuals!$F14, IF(Actuals!$C14 = 'Project Parameters'!$B$8, 'Project Parameters'!C$8 * 'Project Parameters'!C$13 * Actuals!$F14, IF(Actuals!$C14 = 'Project Parameters'!$B$9, 'Project Parameters'!C$9 * 'Project Parameters'!C$13 * Actuals!$F14, IF(Actuals!$C14 = 'Project Parameters'!$B$10, 'Project Parameters'!C$10 * 'Project Parameters'!C$13 * Actuals!$F14, IF(Actuals!$C14 = 'Project Parameters'!$B$11, 'Project Parameters'!C$11 * 'Project Parameters'!C$13 * Actuals!$F14,error))))))","v":{"v":18750,"d":"€ 18,750.00"}},{"$f":" IF( Actuals!$C14 = 'Project Parameters'!$B$6, 'Project Parameters'!D$6 * 'Project Parameters'!D$13 * Actuals!$F14, IF(Actuals!$C14 = 'Project Parameters'!$B$7, 'Project Parameters'!D$7 * 'Project Parameters'!D$13 * Actuals!$F14, IF(Actuals!$C14 = 'Project Parameters'!$B$8, 'Project Parameters'!D$8 * 'Project Parameters'!D$13 * Actuals!$F14, IF(Actuals!$C14 = 'Project Parameters'!$B$9, 'Project Parameters'!D$9 * 'Project Parameters'!D$13 * Actuals!$F14, IF(Actuals!$C14 = 'Project Parameters'!$B$10, 'Project Parameters'!D$10 * 'Project Parameters'!D$13 * Actuals!$F14, IF(Actuals!$C14 = 'Project Parameters'!$B$11, 'Project Parameters'!D$11 * 'Project Parameters'!D$13 * Actuals!$F14,error))))))","v":{"v":33750,"d":"€ 33,750.00"}},{"$f":" IF( Actuals!$C14 = 'Project Parameters'!$B$6, 'Project Parameters'!E$6 * 'Project Parameters'!E$13 * Actuals!$F14, IF(Actuals!$C14 = 'Project Parameters'!$B$7, 'Project Parameters'!E$7 * 'Project Parameters'!E$13 * Actuals!$F14, IF(Actuals!$C14 = 'Project Parameters'!$B$8, 'Project Parameters'!E$8 * 'Project Parameters'!E$13 * Actuals!$F14, IF(Actuals!$C14 = 'Project Parameters'!$B$9, 'Project Parameters'!E$9 * 'Project Parameters'!E$13 * Actuals!$F14, IF(Actuals!$C14 = 'Project Parameters'!$B$10, 'Project Parameters'!E$10 * 'Project Parameters'!E$13 * Actuals!$F14, IF(Actuals!$C14 = 'Project Parameters'!$B$11, 'Project Parameters'!E$11 * 'Project Parameters'!E$13 * Actuals!$F14,error))))))","v":{"v":15000,"d":"€ 15,000.00"}},{"$f":" IF( Actuals!$C14 = 'Project Parameters'!$B$6, 'Project Parameters'!F$6 * 'Project Parameters'!F$13 * Actuals!$F14, IF(Actuals!$C14 = 'Project Parameters'!$B$7, 'Project Parameters'!F$7 * 'Project Parameters'!F$13 * Actuals!$F14, IF(Actuals!$C14 = 'Project Parameters'!$B$8, 'Project Parameters'!F$8 * 'Project Parameters'!F$13 * Actuals!$F14, IF(Actuals!$C14 = 'Project Parameters'!$B$9, 'Project Parameters'!F$9 * 'Project Parameters'!F$13 * Actuals!$F14, IF(Actuals!$C14 = 'Project Parameters'!$B$10, 'Project Parameters'!F$10 * 'Project Parameters'!F$13 * Actuals!$F14, IF(Actuals!$C14 = 'Project Parameters'!$B$11, 'Project Parameters'!F$11 * 'Project Parameters'!F$13 * Actuals!$F14,error))))))","v":{"v":26250,"d":"€ 26,250.00"}},{"$f":" IF( Actuals!$C14 = 'Project Parameters'!$B$6, 'Project Parameters'!G$6 * 'Project Parameters'!G$13 * Actuals!$F14, IF(Actuals!$C14 = 'Project Parameters'!$B$7, 'Project Parameters'!G$7 * 'Project Parameters'!G$13 * Actuals!$F14, IF(Actuals!$C14 = 'Project Parameters'!$B$8, 'Project Parameters'!G$8 * 'Project Parameters'!G$13 * Actuals!$F14, IF(Actuals!$C14 = 'Project Parameters'!$B$9, 'Project Parameters'!G$9 * 'Project Parameters'!G$13 * Actuals!$F14, IF(Actuals!$C14 = 'Project Parameters'!$B$10, 'Project Parameters'!G$10 * 'Project Parameters'!G$13 * Actuals!$F14, IF(Actuals!$C14 = 'Project Parameters'!$B$11, 'Project Parameters'!G$11 * 'Project Parameters'!G$13 * Actuals!$F14,error))))))","v":{"v":33750,"d":"€ 33,750.00"}},{"$f":" IF( Actuals!$C14 = 'Project Parameters'!$B$6, 'Project Parameters'!H$6 * 'Project Parameters'!H$13 * Actuals!$F14, IF(Actuals!$C14 = 'Project Parameters'!$B$7, 'Project Parameters'!H$7 * 'Project Parameters'!H$13 * Actuals!$F14, IF(Actuals!$C14 = 'Project Parameters'!$B$8, 'Project Parameters'!H$8 * 'Project Parameters'!H$13 * Actuals!$F14, IF(Actuals!$C14 = 'Project Parameters'!$B$9, 'Project Parameters'!H$9 * 'Project Parameters'!H$13 * Actuals!$F14, IF(Actuals!$C14 = 'Project Parameters'!$B$10, 'Project Parameters'!H$10 * 'Project Parameters'!H$13 * Actuals!$F14, IF(Actuals!$C14 = 'Project Parameters'!$B$11, 'Project Parameters'!H$11 * 'Project Parameters'!H$13 * Actuals!$F14,error))))))","v":{"v":3750,"d":"€ 3,750.00"}},{"$f":"MONTH(Actuals!E14)","v":5},{"v":131250,"d":"€ 131,250.00"}]
[null,"Coho Vineyard & Winery",{"$f":" IF( Actuals!$C15 = 'Project Parameters'!$B$6, 'Project Parameters'!C$6 * 'Project Parameters'!C$13 * Actuals!$F15, IF(Actuals!$C15 = 'Project Parameters'!$B$7, 'Project Parameters'!C$7 * 'Project Parameters'!C$13 * Actuals!$F15, IF(Actuals!$C15 = 'Project Parameters'!$B$8, 'Project Parameters'!C$8 * 'Project Parameters'!C$13 * Actuals!$F15, IF(Actuals!$C15 = 'Project Parameters'!$B$9, 'Project Parameters'!C$9 * 'Project Parameters'!C$13 * Actuals!$F15, IF(Actuals!$C15 = 'Project Parameters'!$B$10, 'Project Parameters'!C$10 * 'Project Parameters'!C$13 * Actuals!$F15, IF(Actuals!$C15 = 'Project Parameters'!$B$11, 'Project Parameters'!C$11 * 'Project Parameters'!C$13 * Actuals!$F15,error))))))","v":{"v":11250,"d":"€ 11,250.00"}},{"$f":" IF( Actuals!$C15 = 'Project Parameters'!$B$6, 'Project Parameters'!D$6 * 'Project Parameters'!D$13 * Actuals!$F15, IF(Actuals!$C15 = 'Project Parameters'!$B$7, 'Project Parameters'!D$7 * 'Project Parameters'!D$13 * Actuals!$F15, IF(Actuals!$C15 = 'Project Parameters'!$B$8, 'Project Parameters'!D$8 * 'Project Parameters'!D$13 * Actuals!$F15, IF(Actuals!$C15 = 'Project Parameters'!$B$9, 'Project Parameters'!D$9 * 'Project Parameters'!D$13 * Actuals!$F15, IF(Actuals!$C15 = 'Project Parameters'!$B$10, 'Project Parameters'!D$10 * 'Project Parameters'!D$13 * Actuals!$F15, IF(Actuals!$C15 = 'Project Parameters'!$B$11, 'Project Parameters'!D$11 * 'Project Parameters'!D$13 * Actuals!$F15,error))))))","v":{"v":20250,"d":"€ 20,250.00"}},{"$f":" IF( Actuals!$C15 = 'Project Parameters'!$B$6, 'Project Parameters'!E$6 * 'Project Parameters'!E$13 * Actuals!$F15, IF(Actuals!$C15 = 'Project Parameters'!$B$7, 'Project Parameters'!E$7 * 'Project Parameters'!E$13 * Actuals!$F15, IF(Actuals!$C15 = 'Project Parameters'!$B$8, 'Project Parameters'!E$8 * 'Project Parameters'!E$13 * Actuals!$F15, IF(Actuals!$C15 = 'Project Parameters'!$B$9, 'Project Parameters'!E$9 * 'Project Parameters'!E$13 * Actuals!$F15, IF(Actuals!$C15 = 'Project Parameters'!$B$10, 'Project Parameters'!E$10 * 'Project Parameters'!E$13 * Actuals!$F15, IF(Actuals!$C15 = 'Project Parameters'!$B$11, 'Project Parameters'!E$11 * 'Project Parameters'!E$13 * Actuals!$F15,error))))))","v":{"v":18000,"d":"€ 18,000.00"}},{"$f":" IF( Actuals!$C15 = 'Project Parameters'!$B$6, 'Project Parameters'!F$6 * 'Project Parameters'!F$13 * Actuals!$F15, IF(Actuals!$C15 = 'Project Parameters'!$B$7, 'Project Parameters'!F$7 * 'Project Parameters'!F$13 * Actuals!$F15, IF(Actuals!$C15 = 'Project Parameters'!$B$8, 'Project Parameters'!F$8 * 'Project Parameters'!F$13 * Actuals!$F15, IF(Actuals!$C15 = 'Project Parameters'!$B$9, 'Project Parameters'!F$9 * 'Project Parameters'!F$13 * Actuals!$F15, IF(Actuals!$C15 = 'Project Parameters'!$B$10, 'Project Parameters'!F$10 * 'Project Parameters'!F$13 * Actuals!$F15, IF(Actuals!$C15 = 'Project Parameters'!$B$11, 'Project Parameters'!F$11 * 'Project Parameters'!F$13 * Actuals!$F15,error))))))","v":{"v":15750,"d":"€ 15,750.00"}},{"$f":" IF( Actuals!$C15 = 'Project Parameters'!$B$6, 'Project Parameters'!G$6 * 'Project Parameters'!G$13 * Actuals!$F15, IF(Actuals!$C15 = 'Project Parameters'!$B$7, 'Project Parameters'!G$7 * 'Project Parameters'!G$13 * Actuals!$F15, IF(Actuals!$C15 = 'Project Parameters'!$B$8, 'Project Parameters'!G$8 * 'Project Parameters'!G$13 * Actuals!$F15, IF(Actuals!$C15 = 'Project Parameters'!$B$9, 'Project Parameters'!G$9 * 'Project Parameters'!G$13 * Actuals!$F15, IF(Actuals!$C15 = 'Project Parameters'!$B$10, 'Project Parameters'!G$10 * 'Project Parameters'!G$13 * Actuals!$F15, IF(Actuals!$C15 = 'Project Parameters'!$B$11, 'Project Parameters'!G$11 * 'Project Parameters'!G$13 * Actuals!$F15,error))))))","v":{"v":13500,"d":"€ 13,500.00"}},{"$f":" IF( Actuals!$C15 = 'Project Parameters'!$B$6, 'Project Parameters'!H$6 * 'Project Parameters'!H$13 * Actuals!$F15, IF(Actuals!$C15 = 'Project Parameters'!$B$7, 'Project Parameters'!H$7 * 'Project Parameters'!H$13 * Actuals!$F15, IF(Actuals!$C15 = 'Project Parameters'!$B$8, 'Project Parameters'!H$8 * 'Project Parameters'!H$13 * Actuals!$F15, IF(Actuals!$C15 = 'Project Parameters'!$B$9, 'Project Parameters'!H$9 * 'Project Parameters'!H$13 * Actuals!$F15, IF(Actuals!$C15 = 'Project Parameters'!$B$10, 'Project Parameters'!H$10 * 'Project Parameters'!H$13 * Actuals!$F15, IF(Actuals!$C15 = 'Project Parameters'!$B$11, 'Project Parameters'!H$11 * 'Project Parameters'!H$13 * Actuals!$F15,error))))))","v":{"v":2250,"d":"€ 2,250.00"}},{"$f":"MONTH(Actuals!E15)","v":6},{"v":81000,"d":"€ 81,000.00"}]
[null,"Contoso, Ltd.",{"$f":" IF( Actuals!$C16 = 'Project Parameters'!$B$6, 'Project Parameters'!C$6 * 'Project Parameters'!C$13 * Actuals!$F16, IF(Actuals!$C16 = 'Project Parameters'!$B$7, 'Project Parameters'!C$7 * 'Project Parameters'!C$13 * Actuals!$F16, IF(Actuals!$C16 = 'Project Parameters'!$B$8, 'Project Parameters'!C$8 * 'Project Parameters'!C$13 * Actuals!$F16, IF(Actuals!$C16 = 'Project Parameters'!$B$9, 'Project Parameters'!C$9 * 'Project Parameters'!C$13 * Actuals!$F16, IF(Actuals!$C16 = 'Project Parameters'!$B$10, 'Project Parameters'!C$10 * 'Project Parameters'!C$13 * Actuals!$F16, IF(Actuals!$C16 = 'Project Parameters'!$B$11, 'Project Parameters'!C$11 * 'Project Parameters'!C$13 * Actuals!$F16,error))))))","v":{"v":6250,"d":"€ 6,250.00"}},{"$f":" IF( Actuals!$C16 = 'Project Parameters'!$B$6, 'Project Parameters'!D$6 * 'Project Parameters'!D$13 * Actuals!$F16, IF(Actuals!$C16 = 'Project Parameters'!$B$7, 'Project Parameters'!D$7 * 'Project Parameters'!D$13 * Actuals!$F16, IF(Actuals!$C16 = 'Project Parameters'!$B$8, 'Project Parameters'!D$8 * 'Project Parameters'!D$13 * Actuals!$F16, IF(Actuals!$C16 = 'Project Parameters'!$B$9, 'Project Parameters'!D$9 * 'Project Parameters'!D$13 * Actuals!$F16, IF(Actuals!$C16 = 'Project Parameters'!$B$10, 'Project Parameters'!D$10 * 'Project Parameters'!D$13 * Actuals!$F16, IF(Actuals!$C16 = 'Project Parameters'!$B$11, 'Project Parameters'!D$11 * 'Project Parameters'!D$13 * Actuals!$F16,error))))))","v":{"v":11250,"d":"€ 11,250.00"}},{"$f":" IF( Actuals!$C16 = 'Project Parameters'!$B$6, 'Project Parameters'!E$6 * 'Project Parameters'!E$13 * Actuals!$F16, IF(Actuals!$C16 = 'Project Parameters'!$B$7, 'Project Parameters'!E$7 * 'Project Parameters'!E$13 * Actuals!$F16, IF(Actuals!$C16 = 'Project Parameters'!$B$8, 'Project Parameters'!E$8 * 'Project Parameters'!E$13 * Actuals!$F16, IF(Actuals!$C16 = 'Project Parameters'!$B$9, 'Project Parameters'!E$9 * 'Project Parameters'!E$13 * Actuals!$F16, IF(Actuals!$C16 = 'Project Parameters'!$B$10, 'Project Parameters'!E$10 * 'Project Parameters'!E$13 * Actuals!$F16, IF(Actuals!$C16 = 'Project Parameters'!$B$11, 'Project Parameters'!E$11 * 'Project Parameters'!E$13 * Actuals!$F16,error))))))","v":{"v":5000,"d":"€ 5,000.00"}},{"$f":" IF( Actuals!$C16 = 'Project Parameters'!$B$6, 'Project Parameters'!F$6 * 'Project Parameters'!F$13 * Actuals!$F16, IF(Actuals!$C16 = 'Project Parameters'!$B$7, 'Project Parameters'!F$7 * 'Project Parameters'!F$13 * Actuals!$F16, IF(Actuals!$C16 = 'Project Parameters'!$B$8, 'Project Parameters'!F$8 * 'Project Parameters'!F$13 * Actuals!$F16, IF(Actuals!$C16 = 'Project Parameters'!$B$9, 'Project Parameters'!F$9 * 'Project Parameters'!F$13 * Actuals!$F16, IF(Actuals!$C16 = 'Project Parameters'!$B$10, 'Project Parameters'!F$10 * 'Project Parameters'!F$13 * Actuals!$F16, IF(Actuals!$C16 = 'Project Parameters'!$B$11, 'Project Parameters'!F$11 * 'Project Parameters'!F$13 * Actuals!$F16,error))))))","v":{"v":8750,"d":"€ 8,750.00"}},{"$f":" IF( Actuals!$C16 = 'Project Parameters'!$B$6, 'Project Parameters'!G$6 * 'Project Parameters'!G$13 * Actuals!$F16, IF(Actuals!$C16 = 'Project Parameters'!$B$7, 'Project Parameters'!G$7 * 'Project Parameters'!G$13 * Actuals!$F16, IF(Actuals!$C16 = 'Project Parameters'!$B$8, 'Project Parameters'!G$8 * 'Project Parameters'!G$13 * Actuals!$F16, IF(Actuals!$C16 = 'Project Parameters'!$B$9, 'Project Parameters'!G$9 * 'Project Parameters'!G$13 * Actuals!$F16, IF(Actuals!$C16 = 'Project Parameters'!$B$10, 'Project Parameters'!G$10 * 'Project Parameters'!G$13 * Actuals!$F16, IF(Actuals!$C16 = 'Project Parameters'!$B$11, 'Project Parameters'!G$11 * 'Project Parameters'!G$13 * Actuals!$F16,error))))))","v":{"v":11250,"d":"€ 11,250.00"}},{"$f":" IF( Actuals!$C16 = 'Project Parameters'!$B$6, 'Project Parameters'!H$6 * 'Project Parameters'!H$13 * Actuals!$F16, IF(Actuals!$C16 = 'Project Parameters'!$B$7, 'Project Parameters'!H$7 * 'Project Parameters'!H$13 * Actuals!$F16, IF(Actuals!$C16 = 'Project Parameters'!$B$8, 'Project Parameters'!H$8 * 'Project Parameters'!H$13 * Actuals!$F16, IF(Actuals!$C16 = 'Project Parameters'!$B$9, 'Project Parameters'!H$9 * 'Project Parameters'!H$13 * Actuals!$F16, IF(Actuals!$C16 = 'Project Parameters'!$B$10, 'Project Parameters'!H$10 * 'Project Parameters'!H$13 * Actuals!$F16, IF(Actuals!$C16 = 'Project Parameters'!$B$11, 'Project Parameters'!H$11 * 'Project Parameters'!H$13 * Actuals!$F16,error))))))","v":{"v":1250,"d":"€ 1,250.00"}},{"$f":"MONTH(Actuals!E16)","v":7},{"v":43750,"d":"€ 43,750.00"}]
[null,"Contoso Pharmaceuticals",{"$f":" IF( Actuals!$C17 = 'Project Parameters'!$B$6, 'Project Parameters'!C$6 * 'Project Parameters'!C$13 * Actuals!$F17, IF(Actuals!$C17 = 'Project Parameters'!$B$7, 'Project Parameters'!C$7 * 'Project Parameters'!C$13 * Actuals!$F17, IF(Actuals!$C17 = 'Project Parameters'!$B$8, 'Project Parameters'!C$8 * 'Project Parameters'!C$13 * Actuals!$F17, IF(Actuals!$C17 = 'Project Parameters'!$B$9, 'Project Parameters'!C$9 * 'Project Parameters'!C$13 * Actuals!$F17, IF(Actuals!$C17 = 'Project Parameters'!$B$10, 'Project Parameters'!C$10 * 'Project Parameters'!C$13 * Actuals!$F17, IF(Actuals!$C17 = 'Project Parameters'!$B$11, 'Project Parameters'!C$11 * 'Project Parameters'!C$13 * Actuals!$F17,error))))))","v":{"v":5000,"d":"€ 5,000.00"}},{"$f":" IF( Actuals!$C17 = 'Project Parameters'!$B$6, 'Project Parameters'!D$6 * 'Project Parameters'!D$13 * Actuals!$F17, IF(Actuals!$C17 = 'Project Parameters'!$B$7, 'Project Parameters'!D$7 * 'Project Parameters'!D$13 * Actuals!$F17, IF(Actuals!$C17 = 'Project Parameters'!$B$8, 'Project Parameters'!D$8 * 'Project Parameters'!D$13 * Actuals!$F17, IF(Actuals!$C17 = 'Project Parameters'!$B$9, 'Project Parameters'!D$9 * 'Project Parameters'!D$13 * Actuals!$F17, IF(Actuals!$C17 = 'Project Parameters'!$B$10, 'Project Parameters'!D$10 * 'Project Parameters'!D$13 * Actuals!$F17, IF(Actuals!$C17 = 'Project Parameters'!$B$11, 'Project Parameters'!D$11 * 'Project Parameters'!D$13 * Actuals!$F17,error))))))","v":{"v":4500,"d":"€ 4,500.00"}},{"$f":" IF( Actuals!$C17 = 'Project Parameters'!$B$6, 'Project Parameters'!E$6 * 'Project Parameters'!E$13 * Actuals!$F17, IF(Actuals!$C17 = 'Project Parameters'!$B$7, 'Project Parameters'!E$7 * 'Project Parameters'!E$13 * Actuals!$F17, IF(Actuals!$C17 = 'Project Parameters'!$B$8, 'Project Parameters'!E$8 * 'Project Parameters'!E$13 * Actuals!$F17, IF(Actuals!$C17 = 'Project Parameters'!$B$9, 'Project Parameters'!E$9 * 'Project Parameters'!E$13 * Actuals!$F17, IF(Actuals!$C17 = 'Project Parameters'!$B$10, 'Project Parameters'!E$10 * 'Project Parameters'!E$13 * Actuals!$F17, IF(Actuals!$C17 = 'Project Parameters'!$B$11, 'Project Parameters'!E$11 * 'Project Parameters'!E$13 * Actuals!$F17,error))))))","v":{"v":4000,"d":"€ 4,000.00"}},{"$f":" IF( Actuals!$C17 = 'Project Parameters'!$B$6, 'Project Parameters'!F$6 * 'Project Parameters'!F$13 * Actuals!$F17, IF(Actuals!$C17 = 'Project Parameters'!$B$7, 'Project Parameters'!F$7 * 'Project Parameters'!F$13 * Actuals!$F17, IF(Actuals!$C17 = 'Project Parameters'!$B$8, 'Project Parameters'!F$8 * 'Project Parameters'!F$13 * Actuals!$F17, IF(Actuals!$C17 = 'Project Parameters'!$B$9, 'Project Parameters'!F$9 * 'Project Parameters'!F$13 * Actuals!$F17, IF(Actuals!$C17 = 'Project Parameters'!$B$10, 'Project Parameters'!F$10 * 'Project Parameters'!F$13 * Actuals!$F17, IF(Actuals!$C17 = 'Project Parameters'!$B$11, 'Project Parameters'!F$11 * 'Project Parameters'!F$13 * Actuals!$F17,error))))))","v":{"v":17500,"d":"€ 17,500.00"}},{"$f":" IF( Actuals!$C17 = 'Project Parameters'!$B$6, 'Project Parameters'!G$6 * 'Project Parameters'!G$13 * Actuals!$F17, IF(Actuals!$C17 = 'Project Parameters'!$B$7, 'Project Parameters'!G$7 * 'Project Parameters'!G$13 * Actuals!$F17, IF(Actuals!$C17 = 'Project Parameters'!$B$8, 'Project Parameters'!G$8 * 'Project Parameters'!G$13 * Actuals!$F17, IF(Actuals!$C17 = 'Project Parameters'!$B$9, 'Project Parameters'!G$9 * 'Project Parameters'!G$13 * Actuals!$F17, IF(Actuals!$C17 = 'Project Parameters'!$B$10, 'Project Parameters'!G$10 * 'Project Parameters'!G$13 * Actuals!$F17, IF(Actuals!$C17 = 'Project Parameters'!$B$11, 'Project Parameters'!G$11 * 'Project Parameters'!G$13 * Actuals!$F17,error))))))","v":{"v":3000,"d":"€ 3,000.00"}},{"$f":" IF( Actuals!$C17 = 'Project Parameters'!$B$6, 'Project Parameters'!H$6 * 'Project Parameters'!H$13 * Actuals!$F17, IF(Actuals!$C17 = 'Project Parameters'!$B$7, 'Project Parameters'!H$7 * 'Project Parameters'!H$13 * Actuals!$F17, IF(Actuals!$C17 = 'Project Parameters'!$B$8, 'Project Parameters'!H$8 * 'Project Parameters'!H$13 * Actuals!$F17, IF(Actuals!$C17 = 'Project Parameters'!$B$9, 'Project Parameters'!H$9 * 'Project Parameters'!H$13 * Actuals!$F17, IF(Actuals!$C17 = 'Project Parameters'!$B$10, 'Project Parameters'!H$10 * 'Project Parameters'!H$13 * Actuals!$F17, IF(Actuals!$C17 = 'Project Parameters'!$B$11, 'Project Parameters'!H$11 * 'Project Parameters'!H$13 * Actuals!$F17,error))))))","v":{"v":1000,"d":"€ 1,000.00"}},{"$f":"MONTH(Actuals!E17)","v":8},{"v":35000,"d":"€ 35,000.00"}]
[null,"Consolidated Messenger",{"$f":" IF( Actuals!$C18 = 'Project Parameters'!$B$6, 'Project Parameters'!C$6 * 'Project Parameters'!C$13 * Actuals!$F18, IF(Actuals!$C18 = 'Project Parameters'!$B$7, 'Project Parameters'!C$7 * 'Project Parameters'!C$13 * Actuals!$F18, IF(Actuals!$C18 = 'Project Parameters'!$B$8, 'Project Parameters'!C$8 * 'Project Parameters'!C$13 * Actuals!$F18, IF(Actuals!$C18 = 'Project Parameters'!$B$9, 'Project Parameters'!C$9 * 'Project Parameters'!C$13 * Actuals!$F18, IF(Actuals!$C18 = 'Project Parameters'!$B$10, 'Project Parameters'!C$10 * 'Project Parameters'!C$13 * Actuals!$F18, IF(Actuals!$C18 = 'Project Parameters'!$B$11, 'Project Parameters'!C$11 * 'Project Parameters'!C$13 * Actuals!$F18,error))))))","v":{"v":4500,"d":"€ 4,500.00"}},{"$f":" IF( Actuals!$C18 = 'Project Parameters'!$B$6, 'Project Parameters'!D$6 * 'Project Parameters'!D$13 * Actuals!$F18, IF(Actuals!$C18 = 'Project Parameters'!$B$7, 'Project Parameters'!D$7 * 'Project Parameters'!D$13 * Actuals!$F18, IF(Actuals!$C18 = 'Project Parameters'!$B$8, 'Project Parameters'!D$8 * 'Project Parameters'!D$13 * Actuals!$F18, IF(Actuals!$C18 = 'Project Parameters'!$B$9, 'Project Parameters'!D$9 * 'Project Parameters'!D$13 * Actuals!$F18, IF(Actuals!$C18 = 'Project Parameters'!$B$10, 'Project Parameters'!D$10 * 'Project Parameters'!D$13 * Actuals!$F18, IF(Actuals!$C18 = 'Project Parameters'!$B$11, 'Project Parameters'!D$11 * 'Project Parameters'!D$13 * Actuals!$F18,error))))))","v":{"v":8100,"d":"€ 8,100.00"}},{"$f":" IF( Actuals!$C18 = 'Project Parameters'!$B$6, 'Project Parameters'!E$6 * 'Project Parameters'!E$13 * Actuals!$F18, IF(Actuals!$C18 = 'Project Parameters'!$B$7, 'Project Parameters'!E$7 * 'Project Parameters'!E$13 * Actuals!$F18, IF(Actuals!$C18 = 'Project Parameters'!$B$8, 'Project Parameters'!E$8 * 'Project Parameters'!E$13 * Actuals!$F18, IF(Actuals!$C18 = 'Project Parameters'!$B$9, 'Project Parameters'!E$9 * 'Project Parameters'!E$13 * Actuals!$F18, IF(Actuals!$C18 = 'Project Parameters'!$B$10, 'Project Parameters'!E$10 * 'Project Parameters'!E$13 * Actuals!$F18, IF(Actuals!$C18 = 'Project Parameters'!$B$11, 'Project Parameters'!E$11 * 'Project Parameters'!E$13 * Actuals!$F18,error))))))","v":{"v":3600,"d":"€ 3,600.00"}},{"$f":" IF( Actuals!$C18 = 'Project Parameters'!$B$6, 'Project Parameters'!F$6 * 'Project Parameters'!F$13 * Actuals!$F18, IF(Actuals!$C18 = 'Project Parameters'!$B$7, 'Project Parameters'!F$7 * 'Project Parameters'!F$13 * Actuals!$F18, IF(Actuals!$C18 = 'Project Parameters'!$B$8, 'Project Parameters'!F$8 * 'Project Parameters'!F$13 * Actuals!$F18, IF(Actuals!$C18 = 'Project Parameters'!$B$9, 'Project Parameters'!F$9 * 'Project Parameters'!F$13 * Actuals!$F18, IF(Actuals!$C18 = 'Project Parameters'!$B$10, 'Project Parameters'!F$10 * 'Project Parameters'!F$13 * Actuals!$F18, IF(Actuals!$C18 = 'Project Parameters'!$B$11, 'Project Parameters'!F$11 * 'Project Parameters'!F$13 * Actuals!$F18,error))))))","v":{"v":12600,"d":"€ 12,600.00"}},{"$f":" IF( Actuals!$C18 = 'Project Parameters'!$B$6, 'Project Parameters'!G$6 * 'Project Parameters'!G$13 * Actuals!$F18, IF(Actuals!$C18 = 'Project Parameters'!$B$7, 'Project Parameters'!G$7 * 'Project Parameters'!G$13 * Actuals!$F18, IF(Actuals!$C18 = 'Project Parameters'!$B$8, 'Project Parameters'!G$8 * 'Project Parameters'!G$13 * Actuals!$F18, IF(Actuals!$C18 = 'Project Parameters'!$B$9, 'Project Parameters'!G$9 * 'Project Parameters'!G$13 * Actuals!$F18, IF(Actuals!$C18 = 'Project Parameters'!$B$10, 'Project Parameters'!G$10 * 'Project Parameters'!G$13 * Actuals!$F18, IF(Actuals!$C18 = 'Project Parameters'!$B$11, 'Project Parameters'!G$11 * 'Project Parameters'!G$13 * Actuals!$F18,error))))))","v":{"v":2700,"d":"€ 2,700.00"}},{"$f":" IF( Actuals!$C18 = 'Project Parameters'!$B$6, 'Project Parameters'!H$6 * 'Project Parameters'!H$13 * Actuals!$F18, IF(Actuals!$C18 = 'Project Parameters'!$B$7, 'Project Parameters'!H$7 * 'Project Parameters'!H$13 * Actuals!$F18, IF(Actuals!$C18 = 'Project Parameters'!$B$8, 'Project Parameters'!H$8 * 'Project Parameters'!H$13 * Actuals!$F18, IF(Actuals!$C18 = 'Project Parameters'!$B$9, 'Project Parameters'!H$9 * 'Project Parameters'!H$13 * Actuals!$F18, IF(Actuals!$C18 = 'Project Parameters'!$B$10, 'Project Parameters'!H$10 * 'Project Parameters'!H$13 * Actuals!$F18, IF(Actuals!$C18 = 'Project Parameters'!$B$11, 'Project Parameters'!H$11 * 'Project Parameters'!H$13 * Actuals!$F18,error))))))","v":{"v":900,"d":"€ 900.00"}},{"$f":"MONTH(Actuals!E18)","v":8},{"v":32400,"d":"€ 32,400.00"}]
[null,"Fabrikam, Inc.",{"$f":" IF( Actuals!$C19 = 'Project Parameters'!$B$6, 'Project Parameters'!C$6 * 'Project Parameters'!C$13 * Actuals!$F19, IF(Actuals!$C19 = 'Project Parameters'!$B$7, 'Project Parameters'!C$7 * 'Project Parameters'!C$13 * Actuals!$F19, IF(Actuals!$C19 = 'Project Parameters'!$B$8, 'Project Parameters'!C$8 * 'Project Parameters'!C$13 * Actuals!$F19, IF(Actuals!$C19 = 'Project Parameters'!$B$9, 'Project Parameters'!C$9 * 'Project Parameters'!C$13 * Actuals!$F19, IF(Actuals!$C19 = 'Project Parameters'!$B$10, 'Project Parameters'!C$10 * 'Project Parameters'!C$13 * Actuals!$F19, IF(Actuals!$C19 = 'Project Parameters'!$B$11, 'Project Parameters'!C$11 * 'Project Parameters'!C$13 * Actuals!$F19,error))))))","v":{"v":6250,"d":"€ 6,250.00"}},{"$f":" IF( Actuals!$C19 = 'Project Parameters'!$B$6, 'Project Parameters'!D$6 * 'Project Parameters'!D$13 * Actuals!$F19, IF(Actuals!$C19 = 'Project Parameters'!$B$7, 'Project Parameters'!D$7 * 'Project Parameters'!D$13 * Actuals!$F19, IF(Actuals!$C19 = 'Project Parameters'!$B$8, 'Project Parameters'!D$8 * 'Project Parameters'!D$13 * Actuals!$F19, IF(Actuals!$C19 = 'Project Parameters'!$B$9, 'Project Parameters'!D$9 * 'Project Parameters'!D$13 * Actuals!$F19, IF(Actuals!$C19 = 'Project Parameters'!$B$10, 'Project Parameters'!D$10 * 'Project Parameters'!D$13 * Actuals!$F19, IF(Actuals!$C19 = 'Project Parameters'!$B$11, 'Project Parameters'!D$11 * 'Project Parameters'!D$13 * Actuals!$F19,error))))))","v":{"v":11250,"d":"€ 11,250.00"}},{"$f":" IF( Actuals!$C19 = 'Project Parameters'!$B$6, 'Project Parameters'!E$6 * 'Project Parameters'!E$13 * Actuals!$F19, IF(Actuals!$C19 = 'Project Parameters'!$B$7, 'Project Parameters'!E$7 * 'Project Parameters'!E$13 * Actuals!$F19, IF(Actuals!$C19 = 'Project Parameters'!$B$8, 'Project Parameters'!E$8 * 'Project Parameters'!E$13 * Actuals!$F19, IF(Actuals!$C19 = 'Project Parameters'!$B$9, 'Project Parameters'!E$9 * 'Project Parameters'!E$13 * Actuals!$F19, IF(Actuals!$C19 = 'Project Parameters'!$B$10, 'Project Parameters'!E$10 * 'Project Parameters'!E$13 * Actuals!$F19, IF(Actuals!$C19 = 'Project Parameters'!$B$11, 'Project Parameters'!E$11 * 'Project Parameters'!E$13 * Actuals!$F19,error))))))","v":{"v":5000,"d":"€ 5,000.00"}},{"$f":" IF( Actuals!$C19 = 'Project Parameters'!$B$6, 'Project Parameters'!F$6 * 'Project Parameters'!F$13 * Actuals!$F19, IF(Actuals!$C19 = 'Project Parameters'!$B$7, 'Project Parameters'!F$7 * 'Project Parameters'!F$13 * Actuals!$F19, IF(Actuals!$C19 = 'Project Parameters'!$B$8, 'Project Parameters'!F$8 * 'Project Parameters'!F$13 * Actuals!$F19, IF(Actuals!$C19 = 'Project Parameters'!$B$9, 'Project Parameters'!F$9 * 'Project Parameters'!F$13 * Actuals!$F19, IF(Actuals!$C19 = 'Project Parameters'!$B$10, 'Project Parameters'!F$10 * 'Project Parameters'!F$13 * Actuals!$F19, IF(Actuals!$C19 = 'Project Parameters'!$B$11, 'Project Parameters'!F$11 * 'Project Parameters'!F$13 * Actuals!$F19,error))))))","v":{"v":8750,"d":"€ 8,750.00"}},{"$f":" IF( Actuals!$C19 = 'Project Parameters'!$B$6, 'Project Parameters'!G$6 * 'Project Parameters'!G$13 * Actuals!$F19, IF(Actuals!$C19 = 'Project Parameters'!$B$7, 'Project Parameters'!G$7 * 'Project Parameters'!G$13 * Actuals!$F19, IF(Actuals!$C19 = 'Project Parameters'!$B$8, 'Project Parameters'!G$8 * 'Project Parameters'!G$13 * Actuals!$F19, IF(Actuals!$C19 = 'Project Parameters'!$B$9, 'Project Parameters'!G$9 * 'Project Parameters'!G$13 * Actuals!$F19, IF(Actuals!$C19 = 'Project Parameters'!$B$10, 'Project Parameters'!G$10 * 'Project Parameters'!G$13 * Actuals!$F19, IF(Actuals!$C19 = 'Project Parameters'!$B$11, 'Project Parameters'!G$11 * 'Project Parameters'!G$13 * Actuals!$F19,error))))))","v":{"v":11250,"d":"€ 11,250.00"}},{"$f":" IF( Actuals!$C19 = 'Project Parameters'!$B$6, 'Project Parameters'!H$6 * 'Project Parameters'!H$13 * Actuals!$F19, IF(Actuals!$C19 = 'Project Parameters'!$B$7, 'Project Parameters'!H$7 * 'Project Parameters'!H$13 * Actuals!$F19, IF(Actuals!$C19 = 'Project Parameters'!$B$8, 'Project Parameters'!H$8 * 'Project Parameters'!H$13 * Actuals!$F19, IF(Actuals!$C19 = 'Project Parameters'!$B$9, 'Project Parameters'!H$9 * 'Project Parameters'!H$13 * Actuals!$F19, IF(Actuals!$C19 = 'Project Parameters'!$B$10, 'Project Parameters'!H$10 * 'Project Parameters'!H$13 * Actuals!$F19, IF(Actuals!$C19 = 'Project Parameters'!$B$11, 'Project Parameters'!H$11 * 'Project Parameters'!H$13 * Actuals!$F19,error))))))","v":{"v":1250,"d":"€ 1,250.00"}},{"$f":"MONTH(Actuals!E19)","v":8},{"v":43750,"d":"€ 43,750.00"}]
[null,"Fourth Coffee",{"$f":" IF( Actuals!$C20 = 'Project Parameters'!$B$6, 'Project Parameters'!C$6 * 'Project Parameters'!C$13 * Actuals!$F20, IF(Actuals!$C20 = 'Project Parameters'!$B$7, 'Project Parameters'!C$7 * 'Project Parameters'!C$13 * Actuals!$F20, IF(Actuals!$C20 = 'Project Parameters'!$B$8, 'Project Parameters'!C$8 * 'Project Parameters'!C$13 * Actuals!$F20, IF(Actuals!$C20 = 'Project Parameters'!$B$9, 'Project Parameters'!C$9 * 'Project Parameters'!C$13 * Actuals!$F20, IF(Actuals!$C20 = 'Project Parameters'!$B$10, 'Project Parameters'!C$10 * 'Project Parameters'!C$13 * Actuals!$F20, IF(Actuals!$C20 = 'Project Parameters'!$B$11, 'Project Parameters'!C$11 * 'Project Parameters'!C$13 * Actuals!$F20,error))))))","v":{"v":6000,"d":"€ 6,000.00"}},{"$f":" IF( Actuals!$C20 = 'Project Parameters'!$B$6, 'Project Parameters'!D$6 * 'Project Parameters'!D$13 * Actuals!$F20, IF(Actuals!$C20 = 'Project Parameters'!$B$7, 'Project Parameters'!D$7 * 'Project Parameters'!D$13 * Actuals!$F20, IF(Actuals!$C20 = 'Project Parameters'!$B$8, 'Project Parameters'!D$8 * 'Project Parameters'!D$13 * Actuals!$F20, IF(Actuals!$C20 = 'Project Parameters'!$B$9, 'Project Parameters'!D$9 * 'Project Parameters'!D$13 * Actuals!$F20, IF(Actuals!$C20 = 'Project Parameters'!$B$10, 'Project Parameters'!D$10 * 'Project Parameters'!D$13 * Actuals!$F20, IF(Actuals!$C20 = 'Project Parameters'!$B$11, 'Project Parameters'!D$11 * 'Project Parameters'!D$13 * Actuals!$F20,error))))))","v":{"v":10800,"d":"€ 10,800.00"}},{"$f":" IF( Actuals!$C20 = 'Project Parameters'!$B$6, 'Project Parameters'!E$6 * 'Project Parameters'!E$13 * Actuals!$F20, IF(Actuals!$C20 = 'Project Parameters'!$B$7, 'Project Parameters'!E$7 * 'Project Parameters'!E$13 * Actuals!$F20, IF(Actuals!$C20 = 'Project Parameters'!$B$8, 'Project Parameters'!E$8 * 'Project Parameters'!E$13 * Actuals!$F20, IF(Actuals!$C20 = 'Project Parameters'!$B$9, 'Project Parameters'!E$9 * 'Project Parameters'!E$13 * Actuals!$F20, IF(Actuals!$C20 = 'Project Parameters'!$B$10, 'Project Parameters'!E$10 * 'Project Parameters'!E$13 * Actuals!$F20, IF(Actuals!$C20 = 'Project Parameters'!$B$11, 'Project Parameters'!E$11 * 'Project Parameters'!E$13 * Actuals!$F20,error))))))","v":{"v":9600,"d":"€ 9,600.00"}},{"$f":" IF( Actuals!$C20 = 'Project Parameters'!$B$6, 'Project Parameters'!F$6 * 'Project Parameters'!F$13 * Actuals!$F20, IF(Actuals!$C20 = 'Project Parameters'!$B$7, 'Project Parameters'!F$7 * 'Project Parameters'!F$13 * Actuals!$F20, IF(Actuals!$C20 = 'Project Parameters'!$B$8, 'Project Parameters'!F$8 * 'Project Parameters'!F$13 * Actuals!$F20, IF(Actuals!$C20 = 'Project Parameters'!$B$9, 'Project Parameters'!F$9 * 'Project Parameters'!F$13 * Actuals!$F20, IF(Actuals!$C20 = 'Project Parameters'!$B$10, 'Project Parameters'!F$10 * 'Project Parameters'!F$13 * Actuals!$F20, IF(Actuals!$C20 = 'Project Parameters'!$B$11, 'Project Parameters'!F$11 * 'Project Parameters'!F$13 * Actuals!$F20,error))))))","v":{"v":8400,"d":"€ 8,400.00"}},{"$f":" IF( Actuals!$C20 = 'Project Parameters'!$B$6, 'Project Parameters'!G$6 * 'Project Parameters'!G$13 * Actuals!$F20, IF(Actuals!$C20 = 'Project Parameters'!$B$7, 'Project Parameters'!G$7 * 'Project Parameters'!G$13 * Actuals!$F20, IF(Actuals!$C20 = 'Project Parameters'!$B$8, 'Project Parameters'!G$8 * 'Project Parameters'!G$13 * Actuals!$F20, IF(Actuals!$C20 = 'Project Parameters'!$B$9, 'Project Parameters'!G$9 * 'Project Parameters'!G$13 * Actuals!$F20, IF(Actuals!$C20 = 'Project Parameters'!$B$10, 'Project Parameters'!G$10 * 'Project Parameters'!G$13 * Actuals!$F20, IF(Actuals!$C20 = 'Project Parameters'!$B$11, 'Project Parameters'!G$11 * 'Project Parameters'!G$13 * Actuals!$F20,error))))))","v":{"v":7200,"d":"€ 7,200.00"}},{"$f":" IF( Actuals!$C20 = 'Project Parameters'!$B$6, 'Project Parameters'!H$6 * 'Project Parameters'!H$13 * Actuals!$F20, IF(Actuals!$C20 = 'Project Parameters'!$B$7, 'Project Parameters'!H$7 * 'Project Parameters'!H$13 * Actuals!$F20, IF(Actuals!$C20 = 'Project Parameters'!$B$8, 'Project Parameters'!H$8 * 'Project Parameters'!H$13 * Actuals!$F20, IF(Actuals!$C20 = 'Project Parameters'!$B$9, 'Project Parameters'!H$9 * 'Project Parameters'!H$13 * Actuals!$F20, IF(Actuals!$C20 = 'Project Parameters'!$B$10, 'Project Parameters'!H$10 * 'Project Parameters'!H$13 * Actuals!$F20, IF(Actuals!$C20 = 'Project Parameters'!$B$11, 'Project Parameters'!H$11 * 'Project Parameters'!H$13 * Actuals!$F20,error))))))","v":{"v":1200,"d":"€ 1,200.00"}},{"$f":"MONTH(Actuals!E20)","v":9},{"v":43200,"d":"€ 43,200.00"}]
[null,"Graphic Design Institute",{"$f":" IF( Actuals!$C21 = 'Project Parameters'!$B$6, 'Project Parameters'!C$6 * 'Project Parameters'!C$13 * Actuals!$F21, IF(Actuals!$C21 = 'Project Parameters'!$B$7, 'Project Parameters'!C$7 * 'Project Parameters'!C$13 * Actuals!$F21, IF(Actuals!$C21 = 'Project Parameters'!$B$8, 'Project Parameters'!C$8 * 'Project Parameters'!C$13 * Actuals!$F21, IF(Actuals!$C21 = 'Project Parameters'!$B$9, 'Project Parameters'!C$9 * 'Project Parameters'!C$13 * Actuals!$F21, IF(Actuals!$C21 = 'Project Parameters'!$B$10, 'Project Parameters'!C$10 * 'Project Parameters'!C$13 * Actuals!$F21, IF(Actuals!$C21 = 'Project Parameters'!$B$11, 'Project Parameters'!C$11 * 'Project Parameters'!C$13 * Actuals!$F21,error))))))","v":{"v":8000,"d":"€ 8,000.00"}},{"$f":" IF( Actuals!$C21 = 'Project Parameters'!$B$6, 'Project Parameters'!D$6 * 'Project Parameters'!D$13 * Actuals!$F21, IF(Actuals!$C21 = 'Project Parameters'!$B$7, 'Project Parameters'!D$7 * 'Project Parameters'!D$13 * Actuals!$F21, IF(Actuals!$C21 = 'Project Parameters'!$B$8, 'Project Parameters'!D$8 * 'Project Parameters'!D$13 * Actuals!$F21, IF(Actuals!$C21 = 'Project Parameters'!$B$9, 'Project Parameters'!D$9 * 'Project Parameters'!D$13 * Actuals!$F21, IF(Actuals!$C21 = 'Project Parameters'!$B$10, 'Project Parameters'!D$10 * 'Project Parameters'!D$13 * Actuals!$F21, IF(Actuals!$C21 = 'Project Parameters'!$B$11, 'Project Parameters'!D$11 * 'Project Parameters'!D$13 * Actuals!$F21,error))))))","v":{"v":14400,"d":"€ 14,400.00"}},{"$f":" IF( Actuals!$C21 = 'Project Parameters'!$B$6, 'Project Parameters'!E$6 * 'Project Parameters'!E$13 * Actuals!$F21, IF(Actuals!$C21 = 'Project Parameters'!$B$7, 'Project Parameters'!E$7 * 'Project Parameters'!E$13 * Actuals!$F21, IF(Actuals!$C21 = 'Project Parameters'!$B$8, 'Project Parameters'!E$8 * 'Project Parameters'!E$13 * Actuals!$F21, IF(Actuals!$C21 = 'Project Parameters'!$B$9, 'Project Parameters'!E$9 * 'Project Parameters'!E$13 * Actuals!$F21, IF(Actuals!$C21 = 'Project Parameters'!$B$10, 'Project Parameters'!E$10 * 'Project Parameters'!E$13 * Actuals!$F21, IF(Actuals!$C21 = 'Project Parameters'!$B$11, 'Project Parameters'!E$11 * 'Project Parameters'!E$13 * Actuals!$F21,error))))))","v":{"v":12800,"d":"€ 12,800.00"}},{"$f":" IF( Actuals!$C21 = 'Project Parameters'!$B$6, 'Project Parameters'!F$6 * 'Project Parameters'!F$13 * Actuals!$F21, IF(Actuals!$C21 = 'Project Parameters'!$B$7, 'Project Parameters'!F$7 * 'Project Parameters'!F$13 * Actuals!$F21, IF(Actuals!$C21 = 'Project Parameters'!$B$8, 'Project Parameters'!F$8 * 'Project Parameters'!F$13 * Actuals!$F21, IF(Actuals!$C21 = 'Project Parameters'!$B$9, 'Project Parameters'!F$9 * 'Project Parameters'!F$13 * Actuals!$F21, IF(Actuals!$C21 = 'Project Parameters'!$B$10, 'Project Parameters'!F$10 * 'Project Parameters'!F$13 * Actuals!$F21, IF(Actuals!$C21 = 'Project Parameters'!$B$11, 'Project Parameters'!F$11 * 'Project Parameters'!F$13 * Actuals!$F21,error))))))","v":{"v":11200,"d":"€ 11,200.00"}},{"$f":" IF( Actuals!$C21 = 'Project Parameters'!$B$6, 'Project Parameters'!G$6 * 'Project Parameters'!G$13 * Actuals!$F21, IF(Actuals!$C21 = 'Project Parameters'!$B$7, 'Project Parameters'!G$7 * 'Project Parameters'!G$13 * Actuals!$F21, IF(Actuals!$C21 = 'Project Parameters'!$B$8, 'Project Parameters'!G$8 * 'Project Parameters'!G$13 * Actuals!$F21, IF(Actuals!$C21 = 'Project Parameters'!$B$9, 'Project Parameters'!G$9 * 'Project Parameters'!G$13 * Actuals!$F21, IF(Actuals!$C21 = 'Project Parameters'!$B$10, 'Project Parameters'!G$10 * 'Project Parameters'!G$13 * Actuals!$F21, IF(Actuals!$C21 = 'Project Parameters'!$B$11, 'Project Parameters'!G$11 * 'Project Parameters'!G$13 * Actuals!$F21,error))))))","v":{"v":9600,"d":"€ 9,600.00"}},{"$f":" IF( Actuals!$C21 = 'Project Parameters'!$B$6, 'Project Parameters'!H$6 * 'Project Parameters'!H$13 * Actuals!$F21, IF(Actuals!$C21 = 'Project Parameters'!$B$7, 'Project Parameters'!H$7 * 'Project Parameters'!H$13 * Actuals!$F21, IF(Actuals!$C21 = 'Project Parameters'!$B$8, 'Project Parameters'!H$8 * 'Project Parameters'!H$13 * Actuals!$F21, IF(Actuals!$C21 = 'Project Parameters'!$B$9, 'Project Parameters'!H$9 * 'Project Parameters'!H$13 * Actuals!$F21, IF(Actuals!$C21 = 'Project Parameters'!$B$10, 'Project Parameters'!H$10 * 'Project Parameters'!H$13 * Actuals!$F21, IF(Actuals!$C21 = 'Project Parameters'!$B$11, 'Project Parameters'!H$11 * 'Project Parameters'!H$13 * Actuals!$F21,error))))))","v":{"v":1600,"d":"€ 1,600.00"}},{"$f":"MONTH(Actuals!E21)","v":9},{"v":57600,"d":"€ 57,600.00"}]
[null,"Humongous Insurance",{"$f":" IF( Actuals!$C22 = 'Project Parameters'!$B$6, 'Project Parameters'!C$6 * 'Project Parameters'!C$13 * Actuals!$F22, IF(Actuals!$C22 = 'Project Parameters'!$B$7, 'Project Parameters'!C$7 * 'Project Parameters'!C$13 * Actuals!$F22, IF(Actuals!$C22 = 'Project Parameters'!$B$8, 'Project Parameters'!C$8 * 'Project Parameters'!C$13 * Actuals!$F22, IF(Actuals!$C22 = 'Project Parameters'!$B$9, 'Project Parameters'!C$9 * 'Project Parameters'!C$13 * Actuals!$F22, IF(Actuals!$C22 = 'Project Parameters'!$B$10, 'Project Parameters'!C$10 * 'Project Parameters'!C$13 * Actuals!$F22, IF(Actuals!$C22 = 'Project Parameters'!$B$11, 'Project Parameters'!C$11 * 'Project Parameters'!C$13 * Actuals!$F22,error))))))","v":{"v":13750,"d":"€ 13,750.00"}},{"$f":" IF( Actuals!$C22 = 'Project Parameters'!$B$6, 'Project Parameters'!D$6 * 'Project Parameters'!D$13 * Actuals!$F22, IF(Actuals!$C22 = 'Project Parameters'!$B$7, 'Project Parameters'!D$7 * 'Project Parameters'!D$13 * Actuals!$F22, IF(Actuals!$C22 = 'Project Parameters'!$B$8, 'Project Parameters'!D$8 * 'Project Parameters'!D$13 * Actuals!$F22, IF(Actuals!$C22 = 'Project Parameters'!$B$9, 'Project Parameters'!D$9 * 'Project Parameters'!D$13 * Actuals!$F22, IF(Actuals!$C22 = 'Project Parameters'!$B$10, 'Project Parameters'!D$10 * 'Project Parameters'!D$13 * Actuals!$F22, IF(Actuals!$C22 = 'Project Parameters'!$B$11, 'Project Parameters'!D$11 * 'Project Parameters'!D$13 * Actuals!$F22,error))))))","v":{"v":24750,"d":"€ 24,750.00"}},{"$f":" IF( Actuals!$C22 = 'Project Parameters'!$B$6, 'Project Parameters'!E$6 * 'Project Parameters'!E$13 * Actuals!$F22, IF(Actuals!$C22 = 'Project Parameters'!$B$7, 'Project Parameters'!E$7 * 'Project Parameters'!E$13 * Actuals!$F22, IF(Actuals!$C22 = 'Project Parameters'!$B$8, 'Project Parameters'!E$8 * 'Project Parameters'!E$13 * Actuals!$F22, IF(Actuals!$C22 = 'Project Parameters'!$B$9, 'Project Parameters'!E$9 * 'Project Parameters'!E$13 * Actuals!$F22, IF(Actuals!$C22 = 'Project Parameters'!$B$10, 'Project Parameters'!E$10 * 'Project Parameters'!E$13 * Actuals!$F22, IF(Actuals!$C22 = 'Project Parameters'!$B$11, 'Project Parameters'!E$11 * 'Project Parameters'!E$13 * Actuals!$F22,error))))))","v":{"v":11000,"d":"€ 11,000.00"}},{"$f":" IF( Actuals!$C22 = 'Project Parameters'!$B$6, 'Project Parameters'!F$6 * 'Project Parameters'!F$13 * Actuals!$F22, IF(Actuals!$C22 = 'Project Parameters'!$B$7, 'Project Parameters'!F$7 * 'Project Parameters'!F$13 * Actuals!$F22, IF(Actuals!$C22 = 'Project Parameters'!$B$8, 'Project Parameters'!F$8 * 'Project Parameters'!F$13 * Actuals!$F22, IF(Actuals!$C22 = 'Project Parameters'!$B$9, 'Project Parameters'!F$9 * 'Project Parameters'!F$13 * Actuals!$F22, IF(Actuals!$C22 = 'Project Parameters'!$B$10, 'Project Parameters'!F$10 * 'Project Parameters'!F$13 * Actuals!$F22, IF(Actuals!$C22 = 'Project Parameters'!$B$11, 'Project Parameters'!F$11 * 'Project Parameters'!F$13 * Actuals!$F22,error))))))","v":{"v":19250,"d":"€ 19,250.00"}},{"$f":" IF( Actuals!$C22 = 'Project Parameters'!$B$6, 'Project Parameters'!G$6 * 'Project Parameters'!G$13 * Actuals!$F22, IF(Actuals!$C22 = 'Project Parameters'!$B$7, 'Project Parameters'!G$7 * 'Project Parameters'!G$13 * Actuals!$F22, IF(Actuals!$C22 = 'Project Parameters'!$B$8, 'Project Parameters'!G$8 * 'Project Parameters'!G$13 * Actuals!$F22, IF(Actuals!$C22 = 'Project Parameters'!$B$9, 'Project Parameters'!G$9 * 'Project Parameters'!G$13 * Actuals!$F22, IF(Actuals!$C22 = 'Project Parameters'!$B$10, 'Project Parameters'!G$10 * 'Project Parameters'!G$13 * Actuals!$F22, IF(Actuals!$C22 = 'Project Parameters'!$B$11, 'Project Parameters'!G$11 * 'Project Parameters'!G$13 * Actuals!$F22,error))))))","v":{"v":24750,"d":"€ 24,750.00"}},{"$f":" IF( Actuals!$C22 = 'Project Parameters'!$B$6, 'Project Parameters'!H$6 * 'Project Parameters'!H$13 * Actuals!$F22, IF(Actuals!$C22 = 'Project Parameters'!$B$7, 'Project Parameters'!H$7 * 'Project Parameters'!H$13 * Actuals!$F22, IF(Actuals!$C22 = 'Project Parameters'!$B$8, 'Project Parameters'!H$8 * 'Project Parameters'!H$13 * Actuals!$F22, IF(Actuals!$C22 = 'Project Parameters'!$B$9, 'Project Parameters'!H$9 * 'Project Parameters'!H$13 * Actuals!$F22, IF(Actuals!$C22 = 'Project Parameters'!$B$10, 'Project Parameters'!H$10 * 'Project Parameters'!H$13 * Actuals!$F22, IF(Actuals!$C22 = 'Project Parameters'!$B$11, 'Project Parameters'!H$11 * 'Project Parameters'!H$13 * Actuals!$F22,error))))))","v":{"v":2750,"d":"€ 2,750.00"}},{"$f":"MONTH(Actuals!E22)","v":10},{"v":96250,"d":"€ 96,250.00"}]
[null,"Litware, Inc.",{"$f":" IF( Actuals!$C23 = 'Project Parameters'!$B$6, 'Project Parameters'!C$6 * 'Project Parameters'!C$13 * Actuals!$F23, IF(Actuals!$C23 = 'Project Parameters'!$B$7, 'Project Parameters'!C$7 * 'Project Parameters'!C$13 * Actuals!$F23, IF(Actuals!$C23 = 'Project Parameters'!$B$8, 'Project Parameters'!C$8 * 'Project Parameters'!C$13 * Actuals!$F23, IF(Actuals!$C23 = 'Project Parameters'!$B$9, 'Project Parameters'!C$9 * 'Project Parameters'!C$13 * Actuals!$F23, IF(Actuals!$C23 = 'Project Parameters'!$B$10, 'Project Parameters'!C$10 * 'Project Parameters'!C$13 * Actuals!$F23, IF(Actuals!$C23 = 'Project Parameters'!$B$11, 'Project Parameters'!C$11 * 'Project Parameters'!C$13 * Actuals!$F23,error))))))","v":{"v":8750,"d":"€ 8,750.00"}},{"$f":" IF( Actuals!$C23 = 'Project Parameters'!$B$6, 'Project Parameters'!D$6 * 'Project Parameters'!D$13 * Actuals!$F23, IF(Actuals!$C23 = 'Project Parameters'!$B$7, 'Project Parameters'!D$7 * 'Project Parameters'!D$13 * Actuals!$F23, IF(Actuals!$C23 = 'Project Parameters'!$B$8, 'Project Parameters'!D$8 * 'Project Parameters'!D$13 * Actuals!$F23, IF(Actuals!$C23 = 'Project Parameters'!$B$9, 'Project Parameters'!D$9 * 'Project Parameters'!D$13 * Actuals!$F23, IF(Actuals!$C23 = 'Project Parameters'!$B$10, 'Project Parameters'!D$10 * 'Project Parameters'!D$13 * Actuals!$F23, IF(Actuals!$C23 = 'Project Parameters'!$B$11, 'Project Parameters'!D$11 * 'Project Parameters'!D$13 * Actuals!$F23,error))))))","v":{"v":7875,"d":"€ 7,875.00"}},{"$f":" IF( Actuals!$C23 = 'Project Parameters'!$B$6, 'Project Parameters'!E$6 * 'Project Parameters'!E$13 * Actuals!$F23, IF(Actuals!$C23 = 'Project Parameters'!$B$7, 'Project Parameters'!E$7 * 'Project Parameters'!E$13 * Actuals!$F23, IF(Actuals!$C23 = 'Project Parameters'!$B$8, 'Project Parameters'!E$8 * 'Project Parameters'!E$13 * Actuals!$F23, IF(Actuals!$C23 = 'Project Parameters'!$B$9, 'Project Parameters'!E$9 * 'Project Parameters'!E$13 * Actuals!$F23, IF(Actuals!$C23 = 'Project Parameters'!$B$10, 'Project Parameters'!E$10 * 'Project Parameters'!E$13 * Actuals!$F23, IF(Actuals!$C23 = 'Project Parameters'!$B$11, 'Project Parameters'!E$11 * 'Project Parameters'!E$13 * Actuals!$F23,error))))))","v":{"v":35000,"d":"€ 35,000.00"}},{"$f":" IF( Actuals!$C23 = 'Project Parameters'!$B$6, 'Project Parameters'!F$6 * 'Project Parameters'!F$13 * Actuals!$F23, IF(Actuals!$C23 = 'Project Parameters'!$B$7, 'Project Parameters'!F$7 * 'Project Parameters'!F$13 * Actuals!$F23, IF(Actuals!$C23 = 'Project Parameters'!$B$8, 'Project Parameters'!F$8 * 'Project Parameters'!F$13 * Actuals!$F23, IF(Actuals!$C23 = 'Project Parameters'!$B$9, 'Project Parameters'!F$9 * 'Project Parameters'!F$13 * Actuals!$F23, IF(Actuals!$C23 = 'Project Parameters'!$B$10, 'Project Parameters'!F$10 * 'Project Parameters'!F$13 * Actuals!$F23, IF(Actuals!$C23 = 'Project Parameters'!$B$11, 'Project Parameters'!F$11 * 'Project Parameters'!F$13 * Actuals!$F23,error))))))","v":0},{"$f":" IF( Actuals!$C23 = 'Project Parameters'!$B$6, 'Project Parameters'!G$6 * 'Project Parameters'!G$13 * Actuals!$F23, IF(Actuals!$C23 = 'Project Parameters'!$B$7, 'Project Parameters'!G$7 * 'Project Parameters'!G$13 * Actuals!$F23, IF(Actuals!$C23 = 'Project Parameters'!$B$8, 'Project Parameters'!G$8 * 'Project Parameters'!G$13 * Actuals!$F23, IF(Actuals!$C23 = 'Project Parameters'!$B$9, 'Project Parameters'!G$9 * 'Project Parameters'!G$13 * Actuals!$F23, IF(Actuals!$C23 = 'Project Parameters'!$B$10, 'Project Parameters'!G$10 * 'Project Parameters'!G$13 * Actuals!$F23, IF(Actuals!$C23 = 'Project Parameters'!$B$11, 'Project Parameters'!G$11 * 'Project Parameters'!G$13 * Actuals!$F23,error))))))","v":{"v":10500,"d":"€ 10,500.00"}},{"$f":" IF( Actuals!$C23 = 'Project Parameters'!$B$6, 'Project Parameters'!H$6 * 'Project Parameters'!H$13 * Actuals!$F23, IF(Actuals!$C23 = 'Project Parameters'!$B$7, 'Project Parameters'!H$7 * 'Project Parameters'!H$13 * Actuals!$F23, IF(Actuals!$C23 = 'Project Parameters'!$B$8, 'Project Parameters'!H$8 * 'Project Parameters'!H$13 * Actuals!$F23, IF(Actuals!$C23 = 'Project Parameters'!$B$9, 'Project Parameters'!H$9 * 'Project Parameters'!H$13 * Actuals!$F23, IF(Actuals!$C23 = 'Project Parameters'!$B$10, 'Project Parameters'!H$10 * 'Project Parameters'!H$13 * Actuals!$F23, IF(Actuals!$C23 = 'Project Parameters'!$B$11, 'Project Parameters'!H$11 * 'Project Parameters'!H$13 * Actuals!$F23,error))))))","v":{"v":1750,"d":"€ 1,750.00"}},{"$f":"MONTH(Actuals!E23)","v":10},{"v":63875,"d":"€ 63,875.00"}]
[null,"Lucerne Publishing",{"$f":" IF( Actuals!$C24 = 'Project Parameters'!$B$6, 'Project Parameters'!C$6 * 'Project Parameters'!C$13 * Actuals!$F24, IF(Actuals!$C24 = 'Project Parameters'!$B$7, 'Project Parameters'!C$7 * 'Project Parameters'!C$13 * Actuals!$F24, IF(Actuals!$C24 = 'Project Parameters'!$B$8, 'Project Parameters'!C$8 * 'Project Parameters'!C$13 * Actuals!$F24, IF(Actuals!$C24 = 'Project Parameters'!$B$9, 'Project Parameters'!C$9 * 'Project Parameters'!C$13 * Actuals!$F24, IF(Actuals!$C24 = 'Project Parameters'!$B$10, 'Project Parameters'!C$10 * 'Project Parameters'!C$13 * Actuals!$F24, IF(Actuals!$C24 = 'Project Parameters'!$B$11, 'Project Parameters'!C$11 * 'Project Parameters'!C$13 * Actuals!$F24,error))))))","v":{"v":5000,"d":"€ 5,000.00"}},{"$f":" IF( Actuals!$C24 = 'Project Parameters'!$B$6, 'Project Parameters'!D$6 * 'Project Parameters'!D$13 * Actuals!$F24, IF(Actuals!$C24 = 'Project Parameters'!$B$7, 'Project Parameters'!D$7 * 'Project Parameters'!D$13 * Actuals!$F24, IF(Actuals!$C24 = 'Project Parameters'!$B$8, 'Project Parameters'!D$8 * 'Project Parameters'!D$13 * Actuals!$F24, IF(Actuals!$C24 = 'Project Parameters'!$B$9, 'Project Parameters'!D$9 * 'Project Parameters'!D$13 * Actuals!$F24, IF(Actuals!$C24 = 'Project Parameters'!$B$10, 'Project Parameters'!D$10 * 'Project Parameters'!D$13 * Actuals!$F24, IF(Actuals!$C24 = 'Project Parameters'!$B$11, 'Project Parameters'!D$11 * 'Project Parameters'!D$13 * Actuals!$F24,error))))))","v":{"v":9000,"d":"€ 9,000.00"}},{"$f":" IF( Actuals!$C24 = 'Project Parameters'!$B$6, 'Project Parameters'!E$6 * 'Project Parameters'!E$13 * Actuals!$F24, IF(Actuals!$C24 = 'Project Parameters'!$B$7, 'Project Parameters'!E$7 * 'Project Parameters'!E$13 * Actuals!$F24, IF(Actuals!$C24 = 'Project Parameters'!$B$8, 'Project Parameters'!E$8 * 'Project Parameters'!E$13 * Actuals!$F24, IF(Actuals!$C24 = 'Project Parameters'!$B$9, 'Project Parameters'!E$9 * 'Project Parameters'!E$13 * Actuals!$F24, IF(Actuals!$C24 = 'Project Parameters'!$B$10, 'Project Parameters'!E$10 * 'Project Parameters'!E$13 * Actuals!$F24, IF(Actuals!$C24 = 'Project Parameters'!$B$11, 'Project Parameters'!E$11 * 'Project Parameters'!E$13 * Actuals!$F24,error))))))","v":{"v":16000,"d":"€ 16,000.00"}},{"$f":" IF( Actuals!$C24 = 'Project Parameters'!$B$6, 'Project Parameters'!F$6 * 'Project Parameters'!F$13 * Actuals!$F24, IF(Actuals!$C24 = 'Project Parameters'!$B$7, 'Project Parameters'!F$7 * 'Project Parameters'!F$13 * Actuals!$F24, IF(Actuals!$C24 = 'Project Parameters'!$B$8, 'Project Parameters'!F$8 * 'Project Parameters'!F$13 * Actuals!$F24, IF(Actuals!$C24 = 'Project Parameters'!$B$9, 'Project Parameters'!F$9 * 'Project Parameters'!F$13 * Actuals!$F24, IF(Actuals!$C24 = 'Project Parameters'!$B$10, 'Project Parameters'!F$10 * 'Project Parameters'!F$13 * Actuals!$F24, IF(Actuals!$C24 = 'Project Parameters'!$B$11, 'Project Parameters'!F$11 * 'Project Parameters'!F$13 * Actuals!$F24,error))))))","v":{"v":3500,"d":"€ 3,500.00"}},{"$f":" IF( Actuals!$C24 = 'Project Parameters'!$B$6, 'Project Parameters'!G$6 * 'Project Parameters'!G$13 * Actuals!$F24, IF(Actuals!$C24 = 'Project Parameters'!$B$7, 'Project Parameters'!G$7 * 'Project Parameters'!G$13 * Actuals!$F24, IF(Actuals!$C24 = 'Project Parameters'!$B$8, 'Project Parameters'!G$8 * 'Project Parameters'!G$13 * Actuals!$F24, IF(Actuals!$C24 = 'Project Parameters'!$B$9, 'Project Parameters'!G$9 * 'Project Parameters'!G$13 * Actuals!$F24, IF(Actuals!$C24 = 'Project Parameters'!$B$10, 'Project Parameters'!G$10 * 'Project Parameters'!G$13 * Actuals!$F24, IF(Actuals!$C24 = 'Project Parameters'!$B$11, 'Project Parameters'!G$11 * 'Project Parameters'!G$13 * Actuals!$F24,error))))))","v":{"v":3000,"d":"€ 3,000.00"}},{"$f":" IF( Actuals!$C24 = 'Project Parameters'!$B$6, 'Project Parameters'!H$6 * 'Project Parameters'!H$13 * Actuals!$F24, IF(Actuals!$C24 = 'Project Parameters'!$B$7, 'Project Parameters'!H$7 * 'Project Parameters'!H$13 * Actuals!$F24, IF(Actuals!$C24 = 'Project Parameters'!$B$8, 'Project Parameters'!H$8 * 'Project Parameters'!H$13 * Actuals!$F24, IF(Actuals!$C24 = 'Project Parameters'!$B$9, 'Project Parameters'!H$9 * 'Project Parameters'!H$13 * Actuals!$F24, IF(Actuals!$C24 = 'Project Parameters'!$B$10, 'Project Parameters'!H$10 * 'Project Parameters'!H$13 * Actuals!$F24, IF(Actuals!$C24 = 'Project Parameters'!$B$11, 'Project Parameters'!H$11 * 'Project Parameters'!H$13 * Actuals!$F24,error))))))","v":{"v":1000,"d":"€ 1,000.00"}},{"$f":"MONTH(Actuals!E24)","v":11},{"v":37500,"d":"€ 37,500.00"}]
[null,"Margie's Travel",{"$f":" IF( Actuals!$C25 = 'Project Parameters'!$B$6, 'Project Parameters'!C$6 * 'Project Parameters'!C$13 * Actuals!$F25, IF(Actuals!$C25 = 'Project Parameters'!$B$7, 'Project Parameters'!C$7 * 'Project Parameters'!C$13 * Actuals!$F25, IF(Actuals!$C25 = 'Project Parameters'!$B$8, 'Project Parameters'!C$8 * 'Project Parameters'!C$13 * Actuals!$F25, IF(Actuals!$C25 = 'Project Parameters'!$B$9, 'Project Parameters'!C$9 * 'Project Parameters'!C$13 * Actuals!$F25, IF(Actuals!$C25 = 'Project Parameters'!$B$10, 'Project Parameters'!C$10 * 'Project Parameters'!C$13 * Actuals!$F25, IF(Actuals!$C25 = 'Project Parameters'!$B$11, 'Project Parameters'!C$11 * 'Project Parameters'!C$13 * Actuals!$F25,error))))))","v":{"v":5500,"d":"€ 5,500.00"}},{"$f":" IF( Actuals!$C25 = 'Project Parameters'!$B$6, 'Project Parameters'!D$6 * 'Project Parameters'!D$13 * Actuals!$F25, IF(Actuals!$C25 = 'Project Parameters'!$B$7, 'Project Parameters'!D$7 * 'Project Parameters'!D$13 * Actuals!$F25, IF(Actuals!$C25 = 'Project Parameters'!$B$8, 'Project Parameters'!D$8 * 'Project Parameters'!D$13 * Actuals!$F25, IF(Actuals!$C25 = 'Project Parameters'!$B$9, 'Project Parameters'!D$9 * 'Project Parameters'!D$13 * Actuals!$F25, IF(Actuals!$C25 = 'Project Parameters'!$B$10, 'Project Parameters'!D$10 * 'Project Parameters'!D$13 * Actuals!$F25, IF(Actuals!$C25 = 'Project Parameters'!$B$11, 'Project Parameters'!D$11 * 'Project Parameters'!D$13 * Actuals!$F25,error))))))","v":{"v":9900,"d":"€ 9,900.00"}},{"$f":" IF( Actuals!$C25 = 'Project Parameters'!$B$6, 'Project Parameters'!E$6 * 'Project Parameters'!E$13 * Actuals!$F25, IF(Actuals!$C25 = 'Project Parameters'!$B$7, 'Project Parameters'!E$7 * 'Project Parameters'!E$13 * Actuals!$F25, IF(Actuals!$C25 = 'Project Parameters'!$B$8, 'Project Parameters'!E$8 * 'Project Parameters'!E$13 * Actuals!$F25, IF(Actuals!$C25 = 'Project Parameters'!$B$9, 'Project Parameters'!E$9 * 'Project Parameters'!E$13 * Actuals!$F25, IF(Actuals!$C25 = 'Project Parameters'!$B$10, 'Project Parameters'!E$10 * 'Project Parameters'!E$13 * Actuals!$F25, IF(Actuals!$C25 = 'Project Parameters'!$B$11, 'Project Parameters'!E$11 * 'Project Parameters'!E$13 * Actuals!$F25,error))))))","v":{"v":4400,"d":"€ 4,400.00"}},{"$f":" IF( Actuals!$C25 = 'Project Parameters'!$B$6, 'Project Parameters'!F$6 * 'Project Parameters'!F$13 * Actuals!$F25, IF(Actuals!$C25 = 'Project Parameters'!$B$7, 'Project Parameters'!F$7 * 'Project Parameters'!F$13 * Actuals!$F25, IF(Actuals!$C25 = 'Project Parameters'!$B$8, 'Project Parameters'!F$8 * 'Project Parameters'!F$13 * Actuals!$F25, IF(Actuals!$C25 = 'Project Parameters'!$B$9, 'Project Parameters'!F$9 * 'Project Parameters'!F$13 * Actuals!$F25, IF(Actuals!$C25 = 'Project Parameters'!$B$10, 'Project Parameters'!F$10 * 'Project Parameters'!F$13 * Actuals!$F25, IF(Actuals!$C25 = 'Project Parameters'!$B$11, 'Project Parameters'!F$11 * 'Project Parameters'!F$13 * Actuals!$F25,error))))))","v":{"v":7700,"d":"€ 7,700.00"}},{"$f":" IF( Actuals!$C25 = 'Project Parameters'!$B$6, 'Project Parameters'!G$6 * 'Project Parameters'!G$13 * Actuals!$F25, IF(Actuals!$C25 = 'Project Parameters'!$B$7, 'Project Parameters'!G$7 * 'Project Parameters'!G$13 * Actuals!$F25, IF(Actuals!$C25 = 'Project Parameters'!$B$8, 'Project Parameters'!G$8 * 'Project Parameters'!G$13 * Actuals!$F25, IF(Actuals!$C25 = 'Project Parameters'!$B$9, 'Project Parameters'!G$9 * 'Project Parameters'!G$13 * Actuals!$F25, IF(Actuals!$C25 = 'Project Parameters'!$B$10, 'Project Parameters'!G$10 * 'Project Parameters'!G$13 * Actuals!$F25, IF(Actuals!$C25 = 'Project Parameters'!$B$11, 'Project Parameters'!G$11 * 'Project Parameters'!G$13 * Actuals!$F25,error))))))","v":{"v":9900,"d":"€ 9,900.00"}},{"$f":" IF( Actuals!$C25 = 'Project Parameters'!$B$6, 'Project Parameters'!H$6 * 'Project Parameters'!H$13 * Actuals!$F25, IF(Actuals!$C25 = 'Project Parameters'!$B$7, 'Project Parameters'!H$7 * 'Project Parameters'!H$13 * Actuals!$F25, IF(Actuals!$C25 = 'Project Parameters'!$B$8, 'Project Parameters'!H$8 * 'Project Parameters'!H$13 * Actuals!$F25, IF(Actuals!$C25 = 'Project Parameters'!$B$9, 'Project Parameters'!H$9 * 'Project Parameters'!H$13 * Actuals!$F25, IF(Actuals!$C25 = 'Project Parameters'!$B$10, 'Project Parameters'!H$10 * 'Project Parameters'!H$13 * Actuals!$F25, IF(Actuals!$C25 = 'Project Parameters'!$B$11, 'Project Parameters'!H$11 * 'Project Parameters'!H$13 * Actuals!$F25,error))))))","v":{"v":1100,"d":"€ 1,100.00"}},{"$f":"MONTH(Actuals!E25)","v":11},{"v":38500,"d":"€ 38,500.00"}]
[null,"Northwind Traders",{"$f":" IF( Actuals!$C26 = 'Project Parameters'!$B$6, 'Project Parameters'!C$6 * 'Project Parameters'!C$13 * Actuals!$F26, IF(Actuals!$C26 = 'Project Parameters'!$B$7, 'Project Parameters'!C$7 * 'Project Parameters'!C$13 * Actuals!$F26, IF(Actuals!$C26 = 'Project Parameters'!$B$8, 'Project Parameters'!C$8 * 'Project Parameters'!C$13 * Actuals!$F26, IF(Actuals!$C26 = 'Project Parameters'!$B$9, 'Project Parameters'!C$9 * 'Project Parameters'!C$13 * Actuals!$F26, IF(Actuals!$C26 = 'Project Parameters'!$B$10, 'Project Parameters'!C$10 * 'Project Parameters'!C$13 * Actuals!$F26, IF(Actuals!$C26 = 'Project Parameters'!$B$11, 'Project Parameters'!C$11 * 'Project Parameters'!C$13 * Actuals!$F26,error))))))","v":{"v":15000,"d":"€ 15,000.00"}},{"$f":" IF( Actuals!$C26 = 'Project Parameters'!$B$6, 'Project Parameters'!D$6 * 'Project Parameters'!D$13 * Actuals!$F26, IF(Actuals!$C26 = 'Project Parameters'!$B$7, 'Project Parameters'!D$7 * 'Project Parameters'!D$13 * Actuals!$F26, IF(Actuals!$C26 = 'Project Parameters'!$B$8, 'Project Parameters'!D$8 * 'Project Parameters'!D$13 * Actuals!$F26, IF(Actuals!$C26 = 'Project Parameters'!$B$9, 'Project Parameters'!D$9 * 'Project Parameters'!D$13 * Actuals!$F26, IF(Actuals!$C26 = 'Project Parameters'!$B$10, 'Project Parameters'!D$10 * 'Project Parameters'!D$13 * Actuals!$F26, IF(Actuals!$C26 = 'Project Parameters'!$B$11, 'Project Parameters'!D$11 * 'Project Parameters'!D$13 * Actuals!$F26,error))))))","v":{"v":27000,"d":"€ 27,000.00"}},{"$f":" IF( Actuals!$C26 = 'Project Parameters'!$B$6, 'Project Parameters'!E$6 * 'Project Parameters'!E$13 * Actuals!$F26, IF(Actuals!$C26 = 'Project Parameters'!$B$7, 'Project Parameters'!E$7 * 'Project Parameters'!E$13 * Actuals!$F26, IF(Actuals!$C26 = 'Project Parameters'!$B$8, 'Project Parameters'!E$8 * 'Project Parameters'!E$13 * Actuals!$F26, IF(Actuals!$C26 = 'Project Parameters'!$B$9, 'Project Parameters'!E$9 * 'Project Parameters'!E$13 * Actuals!$F26, IF(Actuals!$C26 = 'Project Parameters'!$B$10, 'Project Parameters'!E$10 * 'Project Parameters'!E$13 * Actuals!$F26, IF(Actuals!$C26 = 'Project Parameters'!$B$11, 'Project Parameters'!E$11 * 'Project Parameters'!E$13 * Actuals!$F26,error))))))","v":{"v":12000,"d":"€ 12,000.00"}},{"$f":" IF( Actuals!$C26 = 'Project Parameters'!$B$6, 'Project Parameters'!F$6 * 'Project Parameters'!F$13 * Actuals!$F26, IF(Actuals!$C26 = 'Project Parameters'!$B$7, 'Project Parameters'!F$7 * 'Project Parameters'!F$13 * Actuals!$F26, IF(Actuals!$C26 = 'Project Parameters'!$B$8, 'Project Parameters'!F$8 * 'Project Parameters'!F$13 * Actuals!$F26, IF(Actuals!$C26 = 'Project Parameters'!$B$9, 'Project Parameters'!F$9 * 'Project Parameters'!F$13 * Actuals!$F26, IF(Actuals!$C26 = 'Project Parameters'!$B$10, 'Project Parameters'!F$10 * 'Project Parameters'!F$13 * Actuals!$F26, IF(Actuals!$C26 = 'Project Parameters'!$B$11, 'Project Parameters'!F$11 * 'Project Parameters'!F$13 * Actuals!$F26,error))))))","v":{"v":42000,"d":"€ 42,000.00"}},{"$f":" IF( Actuals!$C26 = 'Project Parameters'!$B$6, 'Project Parameters'!G$6 * 'Project Parameters'!G$13 * Actuals!$F26, IF(Actuals!$C26 = 'Project Parameters'!$B$7, 'Project Parameters'!G$7 * 'Project Parameters'!G$13 * Actuals!$F26, IF(Actuals!$C26 = 'Project Parameters'!$B$8, 'Project Parameters'!G$8 * 'Project Parameters'!G$13 * Actuals!$F26, IF(Actuals!$C26 = 'Project Parameters'!$B$9, 'Project Parameters'!G$9 * 'Project Parameters'!G$13 * Actuals!$F26, IF(Actuals!$C26 = 'Project Parameters'!$B$10, 'Project Parameters'!G$10 * 'Project Parameters'!G$13 * Actuals!$F26, IF(Actuals!$C26 = 'Project Parameters'!$B$11, 'Project Parameters'!G$11 * 'Project Parameters'!G$13 * Actuals!$F26,error))))))","v":{"v":9000,"d":"€ 9,000.00"}},{"$f":" IF( Actuals!$C26 = 'Project Parameters'!$B$6, 'Project Parameters'!H$6 * 'Project Parameters'!H$13 * Actuals!$F26, IF(Actuals!$C26 = 'Project Parameters'!$B$7, 'Project Parameters'!H$7 * 'Project Parameters'!H$13 * Actuals!$F26, IF(Actuals!$C26 = 'Project Parameters'!$B$8, 'Project Parameters'!H$8 * 'Project Parameters'!H$13 * Actuals!$F26, IF(Actuals!$C26 = 'Project Parameters'!$B$9, 'Project Parameters'!H$9 * 'Project Parameters'!H$13 * Actuals!$F26, IF(Actuals!$C26 = 'Project Parameters'!$B$10, 'Project Parameters'!H$10 * 'Project Parameters'!H$13 * Actuals!$F26, IF(Actuals!$C26 = 'Project Parameters'!$B$11, 'Project Parameters'!H$11 * 'Project Parameters'!H$13 * Actuals!$F26,error))))))","v":{"v":3000,"d":"€ 3,000.00"}},{"$f":"MONTH(Actuals!E26)","v":12},{"v":108000,"d":"€ 108,000.00"}]
[null,"Proseware, Inc.",{"$f":" IF( Actuals!$C27 = 'Project Parameters'!$B$6, 'Project Parameters'!C$6 * 'Project Parameters'!C$13 * Actuals!$F27, IF(Actuals!$C27 = 'Project Parameters'!$B$7, 'Project Parameters'!C$7 * 'Project Parameters'!C$13 * Actuals!$F27, IF(Actuals!$C27 = 'Project Parameters'!$B$8, 'Project Parameters'!C$8 * 'Project Parameters'!C$13 * Actuals!$F27, IF(Actuals!$C27 = 'Project Parameters'!$B$9, 'Project Parameters'!C$9 * 'Project Parameters'!C$13 * Actuals!$F27, IF(Actuals!$C27 = 'Project Parameters'!$B$10, 'Project Parameters'!C$10 * 'Project Parameters'!C$13 * Actuals!$F27, IF(Actuals!$C27 = 'Project Parameters'!$B$11, 'Project Parameters'!C$11 * 'Project Parameters'!C$13 * Actuals!$F27,error))))))","v":{"v":13125,"d":"€ 13,125.00"}},{"$f":" IF( Actuals!$C27 = 'Project Parameters'!$B$6, 'Project Parameters'!D$6 * 'Project Parameters'!D$13 * Actuals!$F27, IF(Actuals!$C27 = 'Project Parameters'!$B$7, 'Project Parameters'!D$7 * 'Project Parameters'!D$13 * Actuals!$F27, IF(Actuals!$C27 = 'Project Parameters'!$B$8, 'Project Parameters'!D$8 * 'Project Parameters'!D$13 * Actuals!$F27, IF(Actuals!$C27 = 'Project Parameters'!$B$9, 'Project Parameters'!D$9 * 'Project Parameters'!D$13 * Actuals!$F27, IF(Actuals!$C27 = 'Project Parameters'!$B$10, 'Project Parameters'!D$10 * 'Project Parameters'!D$13 * Actuals!$F27, IF(Actuals!$C27 = 'Project Parameters'!$B$11, 'Project Parameters'!D$11 * 'Project Parameters'!D$13 * Actuals!$F27,error))))))","v":{"v":23625,"d":"€ 23,625.00"}},{"$f":" IF( Actuals!$C27 = 'Project Parameters'!$B$6, 'Project Parameters'!E$6 * 'Project Parameters'!E$13 * Actuals!$F27, IF(Actuals!$C27 = 'Project Parameters'!$B$7, 'Project Parameters'!E$7 * 'Project Parameters'!E$13 * Actuals!$F27, IF(Actuals!$C27 = 'Project Parameters'!$B$8, 'Project Parameters'!E$8 * 'Project Parameters'!E$13 * Actuals!$F27, IF(Actuals!$C27 = 'Project Parameters'!$B$9, 'Project Parameters'!E$9 * 'Project Parameters'!E$13 * Actuals!$F27, IF(Actuals!$C27 = 'Project Parameters'!$B$10, 'Project Parameters'!E$10 * 'Project Parameters'!E$13 * Actuals!$F27, IF(Actuals!$C27 = 'Project Parameters'!$B$11, 'Project Parameters'!E$11 * 'Project Parameters'!E$13 * Actuals!$F27,error))))))","v":{"v":21000,"d":"€ 21,000.00"}},{"$f":" IF( Actuals!$C27 = 'Project Parameters'!$B$6, 'Project Parameters'!F$6 * 'Project Parameters'!F$13 * Actuals!$F27, IF(Actuals!$C27 = 'Project Parameters'!$B$7, 'Project Parameters'!F$7 * 'Project Parameters'!F$13 * Actuals!$F27, IF(Actuals!$C27 = 'Project Parameters'!$B$8, 'Project Parameters'!F$8 * 'Project Parameters'!F$13 * Actuals!$F27, IF(Actuals!$C27 = 'Project Parameters'!$B$9, 'Project Parameters'!F$9 * 'Project Parameters'!F$13 * Actuals!$F27, IF(Actuals!$C27 = 'Project Parameters'!$B$10, 'Project Parameters'!F$10 * 'Project Parameters'!F$13 * Actuals!$F27, IF(Actuals!$C27 = 'Project Parameters'!$B$11, 'Project Parameters'!F$11 * 'Project Parameters'!F$13 * Actuals!$F27,error))))))","v":{"v":18375,"d":"€ 18,375.00"}},{"$f":" IF( Actuals!$C27 = 'Project Parameters'!$B$6, 'Project Parameters'!G$6 * 'Project Parameters'!G$13 * Actuals!$F27, IF(Actuals!$C27 = 'Project Parameters'!$B$7, 'Project Parameters'!G$7 * 'Project Parameters'!G$13 * Actuals!$F27, IF(Actuals!$C27 = 'Project Parameters'!$B$8, 'Project Parameters'!G$8 * 'Project Parameters'!G$13 * Actuals!$F27, IF(Actuals!$C27 = 'Project Parameters'!$B$9, 'Project Parameters'!G$9 * 'Project Parameters'!G$13 * Actuals!$F27, IF(Actuals!$C27 = 'Project Parameters'!$B$10, 'Project Parameters'!G$10 * 'Project Parameters'!G$13 * Actuals!$F27, IF(Actuals!$C27 = 'Project Parameters'!$B$11, 'Project Parameters'!G$11 * 'Project Parameters'!G$13 * Actuals!$F27,error))))))","v":{"v":15750,"d":"€ 15,750.00"}},{"$f":" IF( Actuals!$C27 = 'Project Parameters'!$B$6, 'Project Parameters'!H$6 * 'Project Parameters'!H$13 * Actuals!$F27, IF(Actuals!$C27 = 'Project Parameters'!$B$7, 'Project Parameters'!H$7 * 'Project Parameters'!H$13 * Actuals!$F27, IF(Actuals!$C27 = 'Project Parameters'!$B$8, 'Project Parameters'!H$8 * 'Project Parameters'!H$13 * Actuals!$F27, IF(Actuals!$C27 = 'Project Parameters'!$B$9, 'Project Parameters'!H$9 * 'Project Parameters'!H$13 * Actuals!$F27, IF(Actuals!$C27 = 'Project Parameters'!$B$10, 'Project Parameters'!H$10 * 'Project Parameters'!H$13 * Actuals!$F27, IF(Actuals!$C27 = 'Project Parameters'!$B$11, 'Project Parameters'!H$11 * 'Project Parameters'!H$13 * Actuals!$F27,error))))))","v":{"v":2625,"d":"€ 2,625.00"}},{"$f":"MONTH(Actuals!E27)","v":12},{"v":94500,"d":"€ 94,500.00"}]
[null,"School of Fine Art",{"$f":" IF( Actuals!$C28 = 'Project Parameters'!$B$6, 'Project Parameters'!C$6 * 'Project Parameters'!C$13 * Actuals!$F28, IF(Actuals!$C28 = 'Project Parameters'!$B$7, 'Project Parameters'!C$7 * 'Project Parameters'!C$13 * Actuals!$F28, IF(Actuals!$C28 = 'Project Parameters'!$B$8, 'Project Parameters'!C$8 * 'Project Parameters'!C$13 * Actuals!$F28, IF(Actuals!$C28 = 'Project Parameters'!$B$9, 'Project Parameters'!C$9 * 'Project Parameters'!C$13 * Actuals!$F28, IF(Actuals!$C28 = 'Project Parameters'!$B$10, 'Project Parameters'!C$10 * 'Project Parameters'!C$13 * Actuals!$F28, IF(Actuals!$C28 = 'Project Parameters'!$B$11, 'Project Parameters'!C$11 * 'Project Parameters'!C$13 * Actuals!$F28,error))))))","v":{"v":4500,"d":"€ 4,500.00"}},{"$f":" IF( Actuals!$C28 = 'Project Parameters'!$B$6, 'Project Parameters'!D$6 * 'Project Parameters'!D$13 * Actuals!$F28, IF(Actuals!$C28 = 'Project Parameters'!$B$7, 'Project Parameters'!D$7 * 'Project Parameters'!D$13 * Actuals!$F28, IF(Actuals!$C28 = 'Project Parameters'!$B$8, 'Project Parameters'!D$8 * 'Project Parameters'!D$13 * Actuals!$F28, IF(Actuals!$C28 = 'Project Parameters'!$B$9, 'Project Parameters'!D$9 * 'Project Parameters'!D$13 * Actuals!$F28, IF(Actuals!$C28 = 'Project Parameters'!$B$10, 'Project Parameters'!D$10 * 'Project Parameters'!D$13 * Actuals!$F28, IF(Actuals!$C28 = 'Project Parameters'!$B$11, 'Project Parameters'!D$11 * 'Project Parameters'!D$13 * Actuals!$F28,error))))))","v":{"v":8100,"d":"€ 8,100.00"}},{"$f":" IF( Actuals!$C28 = 'Project Parameters'!$B$6, 'Project Parameters'!E$6 * 'Project Parameters'!E$13 * Actuals!$F28, IF(Actuals!$C28 = 'Project Parameters'!$B$7, 'Project Parameters'!E$7 * 'Project Parameters'!E$13 * Actuals!$F28, IF(Actuals!$C28 = 'Project Parameters'!$B$8, 'Project Parameters'!E$8 * 'Project Parameters'!E$13 * Actuals!$F28, IF(Actuals!$C28 = 'Project Parameters'!$B$9, 'Project Parameters'!E$9 * 'Project Parameters'!E$13 * Actuals!$F28, IF(Actuals!$C28 = 'Project Parameters'!$B$10, 'Project Parameters'!E$10 * 'Project Parameters'!E$13 * Actuals!$F28, IF(Actuals!$C28 = 'Project Parameters'!$B$11, 'Project Parameters'!E$11 * 'Project Parameters'!E$13 * Actuals!$F28,error))))))","v":{"v":3600,"d":"€ 3,600.00"}},{"$f":" IF( Actuals!$C28 = 'Project Parameters'!$B$6, 'Project Parameters'!F$6 * 'Project Parameters'!F$13 * Actuals!$F28, IF(Actuals!$C28 = 'Project Parameters'!$B$7, 'Project Parameters'!F$7 * 'Project Parameters'!F$13 * Actuals!$F28, IF(Actuals!$C28 = 'Project Parameters'!$B$8, 'Project Parameters'!F$8 * 'Project Parameters'!F$13 * Actuals!$F28, IF(Actuals!$C28 = 'Project Parameters'!$B$9, 'Project Parameters'!F$9 * 'Project Parameters'!F$13 * Actuals!$F28, IF(Actuals!$C28 = 'Project Parameters'!$B$10, 'Project Parameters'!F$10 * 'Project Parameters'!F$13 * Actuals!$F28, IF(Actuals!$C28 = 'Project Parameters'!$B$11, 'Project Parameters'!F$11 * 'Project Parameters'!F$13 * Actuals!$F28,error))))))","v":{"v":6300,"d":"€ 6,300.00"}},{"$f":" IF( Actuals!$C28 = 'Project Parameters'!$B$6, 'Project Parameters'!G$6 * 'Project Parameters'!G$13 * Actuals!$F28, IF(Actuals!$C28 = 'Project Parameters'!$B$7, 'Project Parameters'!G$7 * 'Project Parameters'!G$13 * Actuals!$F28, IF(Actuals!$C28 = 'Project Parameters'!$B$8, 'Project Parameters'!G$8 * 'Project Parameters'!G$13 * Actuals!$F28, IF(Actuals!$C28 = 'Project Parameters'!$B$9, 'Project Parameters'!G$9 * 'Project Parameters'!G$13 * Actuals!$F28, IF(Actuals!$C28 = 'Project Parameters'!$B$10, 'Project Parameters'!G$10 * 'Project Parameters'!G$13 * Actuals!$F28, IF(Actuals!$C28 = 'Project Parameters'!$B$11, 'Project Parameters'!G$11 * 'Project Parameters'!G$13 * Actuals!$F28,error))))))","v":{"v":8100,"d":"€ 8,100.00"}},{"$f":" IF( Actuals!$C28 = 'Project Parameters'!$B$6, 'Project Parameters'!H$6 * 'Project Parameters'!H$13 * Actuals!$F28, IF(Actuals!$C28 = 'Project Parameters'!$B$7, 'Project Parameters'!H$7 * 'Project Parameters'!H$13 * Actuals!$F28, IF(Actuals!$C28 = 'Project Parameters'!$B$8, 'Project Parameters'!H$8 * 'Project Parameters'!H$13 * Actuals!$F28, IF(Actuals!$C28 = 'Project Parameters'!$B$9, 'Project Parameters'!H$9 * 'Project Parameters'!H$13 * Actuals!$F28, IF(Actuals!$C28 = 'Project Parameters'!$B$10, 'Project Parameters'!H$10 * 'Project Parameters'!H$13 * Actuals!$F28, IF(Actuals!$C28 = 'Project Parameters'!$B$11, 'Project Parameters'!H$11 * 'Project Parameters'!H$13 * Actuals!$F28,error))))))","v":{"v":900,"d":"€ 900.00"}},{"$f":"MONTH(Actuals!E28)","v":11},{"v":31500,"d":"€ 31,500.00"}]
[null,"Total Billings",{"$f":"SUM(C6:C27)","v":{"v":189125,"d":"€ 189,125.00"}},{"v":307800,"d":"€ 307,800.00"},{"v":280000,"d":"€ 280,000.00"},{"v":292075,"d":"€ 292,075.00"},{"v":242250,"d":"€ 242,250.00"},{"v":37825,"d":"€ 37,825.00"},null,{"v":1349075,"d":"€ 1,349,075.00"}]
[null,"Total Hours",{"$f":"C28 / 'Project Parameters'!C13","v":{"v":756.5,"d":"757"}},{"$f":"D28 / 'Project Parameters'!D13","v":{"v":1368,"d":"1,368"}},{"$f":"E28 / 'Project Parameters'!E13","v":{"v":1400,"d":"1,400"}},{"$f":"F28 / 'Project Parameters'!F13","v":{"v":1669,"d":"1,669"}},{"$f":"G28 / 'Project Parameters'!G13","v":{"v":1615,"d":"1,615"}},{"$f":"H28 / 'Project Parameters'!H13","v":{"v":756.5,"d":"757"}},null,{"$f":"SUM(C29:H29)","v":{"v":7565,"d":"7,565"}}]

{"sheet":"Monthly Billings","index":3,"n_rows":29,"n_cols":16,"rows_kept":29}
[null,"[Company Name]  "]
[null,{"$f":" Actuals!B2","v":"Project Analysis for Business Consulting Firms"}]
[null,"Company Confidential"]
[]
[null,"Project name","Month of completion","Total\nbillings","January totals","February totals","March totals","April\ntotals","May\ntotals","June\ntotals","July totals","August totals","September totals","October totals","November totals","December totals"]
[null,"A. Datum Corporation",{"$f":"MONTH(Actuals!E7)","v":3},{"$f":"'Actual Totals'!J6","v":{"v":37500,"d":"€ 37,500.00"}},{"$f":"IF($C6 = 1, $D6, 0)","v":0},{"$f":"IF($C6 = 2, $D6, 0)","v":0},{"$f":"IF($C6 = 3, $D6, 0)","v":{"v":37500,"d":"€ 37,500.00"}},{"$f":"IF($C6 = 4, $D6, 0)","v":0},{"$f":"IF($C6 = 5, $D6, 0)","v":0},{"$f":"IF($C6 = 6, $D6, 0)","v":0},{"$f":"IF($C6 = 7, $D6, 0)","v":0},{"$f":"IF($C6 = 8, $D6, 0)","v":0},{"$f":"IF($C6 = 9, $D6, 0)","v":0},{"$f":"IF($C6 = 10, $D6, 0)","v":0},{"$f":"IF($C6 = 11, $D6, 0)","v":0},{"$f":"IF($C6 = 12, $D6, 0)","v":0}]
[null,"Adventure Works",{"$f":"MONTH(Actuals!E8)","v":2},{"$f":"'Actual Totals'!J7","v":{"v":70000,"d":"€ 70,000.00"}},{"$f":"IF($C7 = 1, $D7, 0)","v":0},{"$f":"IF($C7 = 2, $D7, 0)","v":{"v":70000,"d":"€ 70,000.00"}},{"$f":"IF($C7 = 3, $D7, 0)","v":0},{"$f":"IF($C7 = 4, $D7, 0)","v":0},{"$f":"IF($C7 = 5, $D7, 0)","v":0},{"$f":"IF($C7 = 6, $D7, 0)","v":0},{"$f":"IF($C7 = 7, $D7, 0)","v":0},{"$f":"IF($C7 = 8, $D7, 0)","v":0},{"$f":"IF($C7 = 9, $D7, 0)","v":0},{"$f":"IF($C7 = 10, $D7, 0)","v":0},{"$f":"IF($C7 = 11, $D7, 0)","v":0},{"$f":"IF($C7 = 12, $D7, 0)","v":0}]
[null,"Alpine Ski House",{"$f":"MONTH(Actuals!E9)","v":4},{"$f":"'Actual Totals'!J8","v":{"v":87500,"d":"€ 87,500.00"}},0,0,0,{"v":87500,"d":"€ 87,500.00"},0,0,0,0,0,0,0,0]
[null,"Baldwin Museum of Science",{"$f":"MONTH(Actuals!E10)","v":4},{"$f":"'Actual Totals'!J9","v":{"v":27000,"d":"€ 27,000.00"}},0,0,0,{"v":27000,"d":"€ 27,000.00"},0,0,0,0,0,0,0,0]
[null,"Blue Yonder Airlines",{"$f":"MONTH(Actuals!E11)","v":3},{"$f":"'Actual Totals'!J10","v":{"v":43750,"d":"€ 43,750.00"}},0,0,{"v":43750,"d":"€ 43,750.00"},0,0,0,0,0,0,0,0,0]
[null,"City Power & Light",{"$f":"MONTH(Actuals!E12)","v":4},{"$f":"'Actual Totals'!J11","v":{"v":54000,"d":"€ 54,000.00"}},0,0,0,{"v":54000,"d":"€ 54,000.00"},0,0,0,0,0,0,0,0]
[null,"Coho Vineyard",{"$f":"MONTH(Actuals!E13)","v":4},{"$f":"'Actual Totals'!J12","v":{"v":91250,"d":"€ 91,250.00"}},0,0,0,{"v":91250,"d":"€ 91,250.00"},0,0,0,0,0,0,0,0]
[null,"Coho Winery",{"$f":"MONTH(Actuals!E14)","v":5},{"$f":"'Actual Totals'!J13","v":{"v":131250,"d":"€ 131,250.00"}},0,0,0,0,{"v":131250,"d":"€ 131,250.00"},0,0,0,0,0,0,0]
[null,"Coho Vineyard & Winery",{"$f":"MONTH(Actuals!E15)","v":6},{"$f":"'Actual Totals'!J14","v":{"v":81000,"d":"€ 81,000.00"}},0,0,0,0,0,{"v":81000,"d":"€ 81,000.00"},0,0,0,0,0,0]
[null,"Contoso, Ltd.",{"$f":"MONTH(Actuals!E16)","v":7},{"$f":"'Actual Totals'!J15","v":{"v":43750,"d":"€ 43,750.00"}},0,0,0,0,0,0,{"v":43750,"d":"€ 43,750.00"},0,0,0,0,0]
[null,"Contoso Pharmaceuticals",{"$f":"MONTH(Actuals!E17)","v":8},{"$f":"'Actual Totals'!J16","v":{"v":35000,"d":"€ 35,000.00"}},0,0,0,0,0,0,0,{"v":35000,"d":"€ 35,000.00"},0,0,0,0]
[null,"Consolidated Messenger",{"$f":"MONTH(Actuals!E18)","v":8},{"$f":"'Actual Totals'!J17","v":{"v":32400,"d":"€ 32,400.00"}},0,0,0,0,0,0,0,{"v":32400,"d":"€ 32,400.00"},0,0,0,0]
[null,"Fabrikam, Inc.",{"$f":"MONTH(Actuals!E19)","v":8},{"$f":"'Actual Totals'!J18","v":{"v":43750,"d":"€ 43,750.00"}},0,0,0,0,0,0,0,{"v":43750,"d":"€ 43,750.00"},0,0,0,0]
[null,"Fourth Coffee",{"$f":"MONTH(Actuals!E20)","v":9},{"$f":"'Actual Totals'!J19","v":{"v":43200,"d":"€ 43,200.00"}},0,0,0,0,0,0,0,0,{"v":43200,"d":"€ 43,200.00"},0,0,0]
[null,"Graphic Design Institute",{"$f":"MONTH(Actuals!E21)","v":9},{"$f":"'Actual Totals'!J20","v":{"v":57600,"d":"€ 57,600.00"}},0,0,0,0,0,0,0,0,{"v":57600,"d":"€ 57,600.00"},0,0,0]
[null,"Humongous Insurance",{"$f":"MONTH(Actuals!E22)","v":10},{"$f":"'Actual Totals'!J21","v":{"v":96250,"d":"€ 96,250.00"}},0,0,0,0,0,0,0,0,0,{"v":96250,"d":"€ 96,250.00"},0,0]
[null,"Litware, Inc.",{"$f":"MONTH(Actuals!E23)","v":10},{"$f":"'Actual Totals'!J22","v":{"v":63875,"d":"€ 63,875.00"}},0,0,0,0,0,0,0,0,0,{"v":63875,"d":"€ 63,875.00"},0,0]
[null,"Lucerne Publishing",{"$f":"MONTH(Actuals!E24)","v":11},{"$f":"'Actual Totals'!J23","v":{"v":37500,"d":"€ 37,500.00"}},0,0,0,0,0,0,0,0,0,0,{"v":37500,"d":"€ 37,500.00"},0]
[null,"Margie's Travel",{"$f":"MONTH(Actuals!E25)","v":11},{"$f":"'Actual Totals'!J24","v":{"v":38500,"d":"€ 38,500.00"}},0,0,0,0,0,0,0,0,0,0,{"v":38500,"d":"€ 38,500.00"},0]
[null,"Northwind Traders",{"$f":"MONTH(Actuals!E26)","v":12},{"$f":"'Actual Totals'!J25","v":{"v":108000,"d":"€ 108,000.00"}},0,0,0,0,0,0,0,0,0,0,0,{"v":108000,"d":"€ 108,000.00"}]
[null,"Proseware, Inc.",{"$f":"MONTH(Actuals!E27)","v":12},{"$f":"'Actual Totals'!J26","v":{"v":94500,"d":"€ 94,500.00"}},0,0,0,0,0,0,0,0,0,0,0,{"v":94500,"d":"€ 94,500.00"}]
[null,"School of Fine Art",{"$f":"MONTH(Actuals!E28)","v":11},{"$f":"'Actual Totals'!J27","v":{"v":31500,"d":"€ 31,500.00"}},0,0,0,0,0,0,0,0,0,0,{"v":31500,"d":"€ 31,500.00"},0]
[null,"Monthly Totals",null,{"$f":"SUM(D6:D27)","v":{"v":1349075,"d":"€ 1,349,075.00"}},{"$f":"SUM(E6:E27)","v":0},{"v":70000,"d":"€ 70,000.00"},{"v":81250,"d":"€ 81,250.00"},{"v":259750,"d":"€ 259,750.00"},{"v":131250,"d":"€ 131,250.00"},{"v":81000,"d":"€ 81,000.00"},{"v":43750,"d":"€ 43,750.00"},{"v":111150,"d":"€ 111,150.00"},{"v":100800,"d":"€ 100,800.00"},{"v":160125,"d":"€ 160,125.00"},{"v":107500,"d":"€ 107,500.00"},{"v":202500,"d":"€ 202,500.00"}]
[null,"Accumulative Totals",null,null,{"$f":"E28","v":0},{"$f":"E29+F28","v":{"v":70000,"d":"€ 70,000.00"}},{"v":151250,"d":"€ 151,250.00"},{"v":411000,"d":"€ 411,000.00"},{"v":542250,"d":"€ 542,250.00"},{"v":623250,"d":"€ 623,250.00"},{"v":667000,"d":"€ 667,000.00"},{"v":778150,"d":"€ 778,150.00"},{"v":878950,"d":"€ 878,950.00"},{"v":1039075,"d":"€ 1,039,075.00"},{"v":1146575,"d":"€ 1,146,575.00"},{"v":1349075,"d":"€ 1,349,075.00"}]