Spreadsheet: 856399d1705655235-arranging-client-highest-to-lowest-sample-with-pivot-table
Sheet: New PT Summary

Department Super Department | Real Estate and Projects
 | [NAME]
 | 2020 |  |  | 2021 |  |  | 2022 |  |  | 2023 |  |  | 2024 |  |  | Total Sum Fee Billing | Total Sum Total Cost | Total Avg Profit %
[NAME] | [NAME] | Sum Total Cost | [NAME] % | [NAME] | Sum Total Cost | [NAME] % | [NAME] | Sum Total Cost | [NAME] % | [NAME] | Sum Total Cost | [NAME] % | [NAME] | Sum Total Cost | [NAME] %
Client 15 |  |  |  | 5000 | 2201.0307 | 0.5597938600000001 |  |  |  | 6000 | 355.2156 | 0.9407973999999999 |  |  |  | 11000 | 2556.2463 | 0.75029563
Client 18 | 1072613.86 | 877881.5806999999 | 0.1916288217431728 | 1340372.57 | 833796.4996 | 0.3950228001707466 | 1055324.92 | 751369.2705 | 0.2880209153973167 | 674888.23 | 415699.4021 | 0.3840470355506565 | 323306.448 | 198737.5 | 0.3852968228750153 | 4466506.028 | 3077484.2529 | 0.3130355155071941
Client 2 | 1769186.4 | 974767.1372999998 | 0.4100690266823852 | 1725594.51 | 1043298.592 | 0.2980678882907525 | 1548911.05 | 865415.9837000001 | 0.4015867418060212 | 1490814.65 | 1026887.3727 | 0.3561030766907872 | 980586.2 | 692793.9310999999 | 0.1161959437327809 | 7515092.810000001 | 4603163.0168 | 0.317864043666106
Client 21 | 10238 | 7941.5631 | 0.3473969478330658 | 98993.5 | 43939.834 | 0.4989167727150666 | 61666 | 36321.50930000001 | -3.201521963817724 | 141640.6 | 99316.9997 | 0.526551233996497 | 272468.05 | 139513.4063 | 0.3218537539143589 | 585006.1499999999 | 327033.3124000001 | 0.0119650417532602
Client 22 | 5500 | 8147.1389 | -0.7292786071428571 | 0 | 947.0622 | 0.90529378 | 19450 | 8568.6844 | 0.5594506735218508 | 5700 | 3764.0445 | 0.3396413157894737 | 35341.5 | 16756.2 | 0.5249656619796332 | 65991.5 | 38183.13 | 0.2876317073731096
Client 23 | 94000 | 26303.2294 | 0.4237105611235955 | 70500 | 85149.0496 | -0.07710263828075957 | 130663.25 | 59539.3192 | 0.488745393460272 | 113779 | 55385.25260000001 | 0.6091231960904134 | 0 | 3643.3 |  | 408942.25 | 230020.1508 | 0.3420973582596696
Client 24 | 98248.62 | 46362.9304 | 0.4063731921182672 | 274000 | 69677.4934 | 0.7457025788321168 | 291090.75 | 226560.2812 | 0.221685046959237 | 239634.96 | 280242.2193 | -0.1694546542791586 | 9000 | 7678.5 | 0.1468333333333333 | 911974.33 | 630521.4243000001 | 0.2929187815136772
Client 28 |  |  |  | 12925 | 20050.6604 | -0.469337160541586 | 126143 | 132509.6216 | -0.07476210598462851 | 278001.5 | 160922.3076 | 0.4957471265367671 | 131108.5 | 69936.89809999999 | 0.5071170356000291 | 548178 | 383419.4877000001 | 0.1981238502518214
Client 29 | 4716.8 | 3147.0135 | 0.591847947761194 | 5159 | 3334.2963 | 0.3536932932738903 |  |  |  |  |  |  |  |  |  | 9875.8 | 6481.3098 | 0.4727706205175422
Client 3 | 15000 | 1896.0048 | 0.87359968 |  |  |  |  |  |  |  |  |  |  |  |  | 15000 | 1896.0048 | 0.87359968
Client 30 |  |  |  |  |  |  |  |  |  |  |  |  | 91030.8764 | 30077.7 | 0.6695879068729205 | 91030.8764 | 30077.7 | 0.6695879068729205
Client 31 | 11500 | 7293.4539 | 0.3657866173913043 | 6000 | 2594.4026 | 0.5675995666666667 |  |  |  | 3000 | 2058.027 | 0.313991 | 6000 | 2387.8 | 0.6020333333333333 | 26500 | 14333.6835 | 0.4623526293478261
Client 32 | 0 | 1087.9269 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1087.9269
Client 35 |  |  |  |  |  |  |  |  |  |  |  |  | 2000 | 4135 | -1.0675 | 2000 | 4135 | -1.0675
Client 36 | 1008211.96 | 550969.1336999999 | 0.3640515414017962 | 569086.05 | 274593.9064 | 0.5455286712523179 | 426797.78 | 203693.6303 | 0.5230627806316417 | 253580.24 | 140307.538 | 0.4777356416347439 | 268068.15 | 135672.3 | 0.5419552041851237 | 2525744.18 | 1305236.5084 | 0.4903854864462327
Client 38 | 109011.7 | 111751.0218 | -0.01811935140906893 | 104750 | 15575.0201 | 0.8513124572792363 | 93000 | 121903.7717 | -0.6227072968791677 | 174750 | 85622.818 | 0.5902396583225465 | 25500 | 7144.5 | 0.7198235294117648 | 507011.7 | 341997.1316 | 0.2125830511669557
Client 39 |  |  |  |  |  |  |  |  |  | 14798.5 | 4206.5011 | 0.7157481433929115 |  |  |  | 14798.5 | 4206.5011 | 0.7157481433929115
Client 4 |  |  |  | 17750 | 13487.5847 | 0.1779976554471545 | 64302.998 | 34837.702 | 0.4894481885293935 | 7000 | 760.7031 | 0.9541182428571429 | 0 | 195.3 |  | 89052.99799999999 | 49281.28980000001 | 0.4668437582670036
Client 40 |  |  |  |  |  |  | 4440 | 999.2681 | 0.7749396171171171 | 153641 | 23446.4325 | 0.8473946895685397 | 183872.1 | 156873.2 | 0.3151976357136614 | 341953.1 | 181318.9006 | 0.5631823945282449
Client 41 |  |  |  |  |  |  |  |  |  |  |  |  | 30000 | 1167 | 0.9611 | 30000 | 1167 | 0.9611
Client 45 |  |  |  |  |  |  |  |  |  | 20700 | 7879.1602 | 0.6193642415458938 |  |  |  | 20700 | 7879.1602 | 0.6193642415458938
Client 49 |  |  |  | 49562.54 | 27153.9928 | 0.4521266908435282 | 134338.24 | 100408.4416 | 0.2525699190342229 | 86716.26 | 82944.2718 | 0.04349804984670695 | 32400 | 33950 | -0.0478395061728395 | 303017.04 | 244456.7062 | 0.1750887883879046
Client 50 | 0 | 2817.3404 |  | 5819 | 2647.175999999999 | 0.2178569685512975 | 675 | 2953.3353 | 0.3015758518518519 | 0 | 2639.5438 |  |  |  |  | 6494 | 11057.3955 | 0.2597164102015747
Client 52 |  |  |  | 49562.54 | 27153.9928 | 0.4521266908435282 | 134338.24 | 100408.4416 | 0.2525699190342229 | 86716.26 | 82944.2718 | 0.04349804984670695 | 32400 | 33950 | -0.0478395061728395 | 303017.04 | 244456.7062 | 0.1750887883879046
Client 55 |  |  |  |  |  |  |  |  |  | 28500 | 17301.0832 | 0.3929444491228071 | 21517 | 7075.6 | 0.6711623367569828 | 50017 | 24376.6832 | 0.532053392939895
Client 57 | 0 | 2746.046 |  | 0 | 619.5574 |  |  |  |  |  |  |  |  |  |  | 0 | 3365.6034
Client 58 | 3500 | 8104.5729 | -1.315592257142857 |  |  |  |  |  |  |  |  |  |  |  |  | 3500 | 8104.5729 | -1.315592257142857
Client 65 | 7500 | 2697.7723 | 0.6402970266666668 | 3750 | 2889.3082 | 0.2295178133333333 |  |  |  |  |  |  |  |  |  | 11250 | 5587.0805 | 0.43490742
Client 67 | 35800 | 35347.78 | -0.05438714103535354 | 5000 | 4979.2006 | 0.004159879999999999 |  |  |  |  |  |  |  |  |  | 40800 | 40326.9806 | -0.03487146735690236
Client 68 |  |  |  |  |  |  |  |  |  |  |  |  | 31063.5 | 20843.9 | 0.3289906159962657 | 31063.5 | 20843.9 | 0.3289906159962657
Client 7 | 113026.94 | 65345.712 | 0.5546509020457641 | 39750 | 29072.3385 | 0.2686204150943396 | 204703.5 | 63620.19749999999 | 0.8181282826183573 | 80250 | 36653.6973 | 0.5460511364485982 | 13500 | 6581.2 | 0.5125037037037037 | 451230.44 | 201273.1453 | 0.5757817142962681
Client 8 | 291260 | 214721.6191 | 0.6356754959949847 | 252874 | 178862.6592 | -0.408422885251234 | 314037.5 | 251806.511 | 0.004550842624471599 | 390075 | 266642.6106 | 0.5227753377415134 | 156450 | 70864.15370000001 | 0.4082634031551234 | 1404696.5 | 982897.5536000002 | 0.2168879564203911
Client 9 | 26536.779 | -14554.762 | 12.94484919721251 |  |  |  |  |  |  |  |  |  | 424623.53 | 545137.5 | 0.3476298238984822 | 451160.309 | 530582.738 | 5.386517573224092
Total Geral | 4675851.058999999 | 2934774.215100001 | 0.815520866048144 | 4636448.71 | 2682023.657500001 | 0.2795396558545648 | 4609882.227999999 | 2960915.969000001 | 0.2052409620392442 | 4250186.199999999 | 2795979.472500001 | 0.4570041658036443 | 3070235.854400001 | 2185114.8892 | 0.3133369843838004 | 21242604.0514 | 13558808.2033 | 0.4189023928908611