Spreadsheet: 466801d1466448770-report-formula-query-profitability-may-2016
Sheet: Sheet1

Project | Fees | Time Spent | Overservicing % | Profitability % CH
201260280 - Ogilvy & MEC Sea Containers | 956534.94 | 1244205 | 1.300741821307646 | 0.5751320908361173
201260353-1 - WPP Madrid - RIOS 2-7 | 565243.89 | 588753.75 | 1.041592417743781 | 0.6610038544600633
201260317 - WPP Germany - Hamburg Project | 374946.66 | 120974 | 0.3226432261058146 | 0.8917267325437703
201260155 - [NAME] | 276478.56 | 438185.11 | 1.58487916748409 | 0.4421107372665714
201260372 - EDF Energy - Project Murray | 225703.27 | 355773 | 1.576286422434199 | 0.4581474162957409
201260438 - The Farm - Newman St | 218009.8 | 176499.5 | 0.8095943393370392 | 0.7075810353479522
201260416 - Sky Leeds Dock | 173960 | 244400.75 | 1.404924982754656 | 0.5377874223959531
201260356 - WPP - RECS Consultancy | 172747.8 | 52506.25 | 0.303947430879004 | 0.9139126518543218
201260353 - WPP Madrid Strategy 0-1 | 169293.33 | 191573.75 | 1.131608374647719 | 0.65089292058937
201260399 - Structure Tone - Sea Containers Fit out | 154141.78 | 371142.5 | 2.407799494724921 | 0.1968271029437964
201260448 - EDF Project Interchange | 129061 | 236110.5 | 1.829448865265262 | 0.3722232122794648
201260431 - WPP - 2016 Business As Usual | 128000 | 64735 | 0.5057421875 | 0.8307734375
201260450 - Palantir - HQ Relocation | 115000 | 121730 | 1.058521739130435 | 0.6377478260869566
201260352 - Maxus - 2014 | 108706.41 | 175977.5 | 1.618832780882011 | 0.4268047302822344
201260389 - Mentor Graphics - Katowice | 89379 | 126375.25 | 1.413925530605623 | 0.5850736750243346
201260474 - Teach First | 73260 | 73160 | 0.9986349986349986 | 0.6878787878787879
201260466 - WPP Lisbon - Workplace Consultancy | 71682.59 | 102349.5 | 1.427815317498991 | 0.5423602858099853
201260437 - Millward Brown - Warwick | 59980 | 78379.92 | 1.306767589196399 | 0.5837540846948983
201260376 - WPP - Re-Think Design | 57705.07 | 18041.25 | 0.3126458385718967 | 0.8943463719912306
201260443 - Paragon - MoJ Taylor House | 48295 | 69707.5 | 1.443368878765918 | 0.5501190599440936
201260415 - Sky - Osterley | 45590 | 64180 | 1.407764860715069 | 0.5685457337135337
201260477 - Turner & Townsend – One New Change | 45565 | 94872.5 | 2.082135410951388 | 0.3647317019642269
201260476 - JWT - London Green Light | 34460 | 52030 | 1.509866511897852 | 0.5115496227510157
201260468 - AKQA SJS - Relocation | 30658.77 | 34585 | 1.128062215150836 | 0.6660661859559271
201260417 - Group M Red Lion Square | 30345 | 42866.25 | 1.412629757785467 | 0.5475860932608337
201260473 - Mentor Graphics - Newbury | 30286 | 28000 | 0.9245195800039622 | 0.7295450042924123
201260463 - Wates - Space Planning | 24000 | 50797.5 | 2.1165625 | 0.342875
201260469 - Jones Lang LaSalle - Emerson / Park Street | 20585 | 11662.5 | 0.5665533155210104 | 0.8286616468302161
201260478 - EDF Energy - Project Blue Lab | 16750 | 29395 | 1.754925373134328 | 0.4308059701492538
201260464 - Wunderman Phantasia - Concept Design | 9840 | 9730 | 0.9888211382113821 | 0.6680894308943089
201260420 - Mentor Graphics - Leesman | 9622 | 19895 | 2.067657451673249 | 0.2951569320307628
201260501 - BT Faraday Building | 9500 | 19165 | 2.017368421052632 | 0.3808421052631579
201260467 - AKQA - CEO Office | 9340 | 6145 | 0.6579229122055674 | 0.8070663811563169
201260442 - Rio Architects - Project Spark | 9120 | 18505 | 2.02905701754386 | 0.3677631578947368
201260434 - Safra Real Estate - Retail | 8375 | 11220 | 1.339701492537313 | 0.5997611940298507
201260456 - LFEPA - Post Occupancy Review | 8215.01 | 6457.5 | 0.7860611246973528 | 0.7323192546326784
201260307 - Bisley Be Sales - BDG Commission | 6181 |  | 0 | 1
201260472 - LFEPA - Shower Block Refurbishment | 5594 | 11445 | 2.045942080800858 | 0.3510904540579192
201260000 - Scotland Residual Work | 3310 | 480 | 0.1450151057401813 | 0.9528700906344411
201260479 - MEC Global - CAD Work | 1950 | 0 | 0 | 1
201260446 - Rio Architects - ALUK Showroom | 330 | 1100 | 3.333333333333333 | -0.06666666666666667
201260445 - Mentor Graphics - Hampton | 0 | 7202.5 | 1 | #[NAME]!
201260038 - New Business and Non-Project Expenses |  | 6382.5 | 1 | #[NAME]!
201260500 - WPP Mindshare Space Utilisation |  | 7630 | 1 | #[NAME]!
201260502 - HeathWallace - Hong Kong |  | 335 | 1 | #[NAME]!
201260503 - WPP Westbourne Terrace Feasibility |  | 8865 | 1 | #[NAME]!
201260504 - WPP Westbourne Terrace Shared Spaces |  | 6720 | 1 | #[NAME]!
201260505 - Geometry Westbourne Terrace |  | 29615 | 1 | #[NAME]!
201260506 - Maxus Alphabeta 2016 |  | 4950 | 1 | #[NAME]!
201260510 - Hearst Live |  | 1520 | 1 | #[NAME]!
201260511 - Wates Leatherhead |  | 7440 | 1 | #[NAME]!
201260512 - Wates Euston |  | 2320 | 1 | #[NAME]!
201260513 - JLL - Mentor Graphics, Rivergate House, Newbury |  | 320 | 1 | #[NAME]!
201260514 - Rightster, Neal Street |  | 440 | 1 | #[NAME]!
Overhead |  | 199741.25 | 1 | #[NAME]!
Q00363 - WPP Amsterdam RECS - Strategy |  | 1120 | 1 | #[NAME]!
Q00413 - [NAME], Warwick Refurbishment |  | 4020 | 1 | #[NAME]!
Q00423 - Ogilvy Dublin |  | 1280 | 1 | #[NAME]!