Spreadsheet: 166340d1341557331-lookup-query-lookup-query
Sheet: Sheet1

 | Period | Data
 | Jan |  |  | Feb |  |  | March |  |  | April |  |  | May |  |  | June |  |  | Total Sum of  Netinv.sls | Total Sum of Net cst tf | Total Margin-
[NAME] | Sum of  Netinv.sls | Sum of Net cst tf | [NAME] | Sum of  Netinv.sls | Sum of Net cst tf | [NAME] | Sum of  Netinv.sls | Sum of Net cst tf | [NAME] | Sum of  Netinv.sls | Sum of Net cst tf | [NAME] | Sum of  Netinv.sls | Sum of Net cst tf | [NAME] | Sum of  Netinv.sls | Sum of Net cst tf | [NAME]
PROF72006 | 236.25 | 48.75 | 187.5 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 236.25 | 48.75 | 187.5
S1 | 19612.99 | 364.58 | 19248.41 | 19080.95 | 468.4 | 18612.55 | 16064.95 | 219.33 | 15845.62 | 18682.91 | 468.4 | 18214.51 | 13240.95 | 234.2 | 13006.75 | 20463.95 | 234.2 | 20229.75 | 107146.7 | 1989.11 | 105157.59
S10 | 22361.43 | 0 | 22361.43 | 6261 | 609.66 | 5651.34 | 6261 | -92.5 | 6353.5 | 21233.43 | -535.98 | 21769.41 | 6261 | 8819.62 | -2558.62 | 6261 | 4750.55 | 1510.45 | 68638.86 | 13551.35 | 55087.51
S11 | 0 | 0 | 0 |  |  | 0 | 1749.99 | 0 | 1749.99 |  |  | 0 |  |  | 0 | 1575 | 0 | 1575 | 3324.99 | 0 | 3324.99
S12 |  |  | 0 | -364 | -10.48 | -353.52 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | -364 | -10.48 | -353.52
S13 |  |  | 0 |  |  | 0 | -320 | 0 | -320 |  |  | 0 |  |  | 0 |  |  | 0 | -320 | 0 | -320
S15 | 10472 | 468.4 | 10003.6 |  |  | 0 | 17457.92 | 234.2 | 17223.72 | 5650.08 | 468.4 | 5181.68 | 9467.39 | 234.2 | 9233.19 | 10437.86 | 468.4 | 9969.46 | 53485.25 | 1873.6 | 51611.65
S19 | 16905.45 | 0 | 16905.45 |  |  | 0 |  |  | 0 | 16905.45 | 0 | 16905.45 | 0 | 0 | 0 |  |  | 0 | 33810.9 | 0 | 33810.9
S2 | 4750 | 0 | 4750 | 10098.87 | 0 | 10098.87 | -364 | -13.42 | -350.58 |  |  | 0 |  |  | 0 | 1365 | 0 | 1365 | 15849.87 | -13.42 | 15863.29
S3 | 33529.5 | 1873.6 | 31655.9 | 25013.5 | 468.4 | 24545.1 | 25963.5 | 468.4 | 25495.1 | 11713.5 | 468.4 | 11245.1 | 22963.5 | 468.4 | 22495.1 | 21702.5 | 148.01 | 21554.49 | 140886 | 3895.21 | 136990.79
[NAME] |  |  | 0 | 12124.5 | 0 | 12124.5 |  |  | 0 |  |  | 0 | 12124.5 | 0 | 12124.5 |  |  | 0 | 24249 | 0 | 24249
S5 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 | 0 | 234.2 | -234.2 | 0 | 234.2 | -234.2
S6 | 0 | 0 | 0 |  |  | 0 |  |  | 0 | 12704.71 | 0 | 12704.71 | 0 | 0 | 0 | 4571.08 | 0 | 4571.08 | 17275.79 | 0 | 17275.79
S7 | 20280 | 0 | 20280 | 41002 | 1873.6 | 39128.4 | 22311 | 1777.14 | 20533.86 | 27952 | 1171 | 26781 | 44234 | 2107.8 | 42126.2 | 23772 | 1873.6 | 21898.4 | 179551 | 8803.14 | 170747.86
S8 | 23930 | 1171 | 22759 | 27766 | 1405.2 | 26360.8 | 14150 | 0 | 14150 | 23930 | 1171 | 22759 | 31602 | 1639.4 | 29962.6 | 35438 | 1873.6 | 33564.4 | 156816 | 7260.2 | 149555.8
S9 |  |  | 0 | 12124.5 | 0 | 12124.5 |  |  | 0 |  |  | 0 | 12124.5 | 0 | 12124.5 | 9048 | 702.6 | 8345.4 | 33297 | 702.6 | 32594.4
SNZ01 | 40248.59 | 608.92 | 39639.67 | 38048.59 | 1217.84 | 36830.75 | 75472.59 | 1217.84 | 74254.75 | 55692.59 | 2435.68 | 53256.91 | 22000 | 0 | 22000 | 39259.18 | 1826.76 | 37432.42 | 270721.54 | 7307.04 | 263414.5
SNZ02 |  |  | 0 | 15444 | 1217.84 | 14226.16 | 19305 | 1522.3 | 17782.7 | 19305 | 1522.3 | 17782.7 | 15444 | 1217.84 | 14226.16 |  |  | 0 | 69498 | 5480.28 | 64017.72
TM72001 | 67305.94 | 10440.04 | 56865.9 | 190206.4 | 22462.98 | 167743.42 | 189614.08 | 18402.24 | 171211.84 | 112711.25 | 12468.07 | 100243.18 | 189534.39 | 22874.11 | 166660.28 | 150837.68 | 15710.12 | 135127.56 | 900209.74 | 102357.56 | 797852.180000001
TM72002 | 75208 | 10613.73 | 64594.27 | 163441 | 17105.11 | 146335.89 | 188722.4 | 18104.2 | 170618.2 | 158374.48 | 24795.06 | 133579.42 | 202275 | 18733.02 | 183541.98 | 156206.6 | 16831.48 | 139375.12 | 944227.48 | 106182.6 | 838044.880000001
TM72003 | 214391.6 | 26953.87 | 187437.73 | 249623.44 | 32024.95 | 217598.49 | 312304.95 | 42713.04 | 269591.91 | 231164.86 | 34350.63999999993 | 196814.22 | 308763.82 | 37462.14999999989 | 271301.67 | 305524.92 | 38368.09999999993 | 267156.82 | 1621773.59 | 211872.75 | 1409900.84
TM72004 | 79066 | 8892.670000000011 | 70173.33 | 117339 | 12402.77 | 104936.23 | 183511.86 | 25346.25 | 158165.61 | 83904 | 9452.19 | 74451.81 | 110391 | 4597.78000000001 | 105793.22 | 180376 | 20349.07 | 160026.93 | 754587.86 | 81040.73 | 673547.1300000008
TM72005 | 21948.72 | 4812.58 | 17136.14 | 49212.88 | 5763.3 | 43449.58 | 22745.42 | 3555.98 | 19189.44 | 40088.54 | 6038.71 | 34049.83 | 43994.68 | 5810 | 38184.68 | 18757.16 | 2696.75 | 16060.41 | 196747.4 | 28677.32 | 168070.08
TM72006 | 125052.62 | 15499.11 | 109553.51 | 174077.6 | 24105.88 | 149971.72 | 185776.96 | 21012.18 | 164764.78 | 188052.76 | 19803.36 | 168249.4 | 209565 | 22515.58999999994 | 187049.41 | 169984.8 | 20750.84 | 149233.96 | 1052509.74 | 123686.96 | 928822.7800000011
TM72007 | 64411.57 | 11906.89 | 52504.68 | 131591.84 | 27131.42 | 104460.42 | 84004.78 | 13705.3 | 70299.48 | 74401.24 | 15633.68 | 58767.56 | 96266.04 | 27070.95 | 69195.09 | 129260.46 | 36964.82 | 92295.64 | 579935.93 | 132413.06 | 447522.87
TM72008 | 124569.62 | 10515.38 | 114054.24 | 65116.86 | 9302.19 | 55814.67 | 78243.08 | 10901.73 | 67341.35 | 65969.68 | 11525.82 | 54443.86 | 78808.48 | 10843.02 | 67965.46 | 71018.36 | 9890.260000000006 | 61128.1 | 483726.08 | 62978.4 | 420747.68
TM72009 | 82464.98 | 10450.44 | 72014.54 | 116030.34 | 14667.71 | 101362.63 | 118165.47 | 16218.72 | 101946.75 | 106403.3 | 16411.61 | 89991.69 | 124298.53 | 14981.59 | 109316.94 | 140096.54 | 18202.28 | 121894.26 | 687459.16 | 90932.35 | 596526.8100000005
TM72010 | 60964.98 | 7573.370000000005 | 53391.61 | 113731.08 | 13520.75 | 100210.33 | 99981 | 12959.67 | 87021.33 | 64359 | 8670.19 | 55688.81 | 101638 | 13174.98 | 88463.02 | 123514 | 16739.51 | 106774.49 | 564188.06 | 72638.47 | 491549.5900000006
TM72011 | 107131 | 9718.32000000001 | 97412.68 | 198828 | 18903.93999999994 | 179924.06 | 153188 | 15546.44 | 137641.56 | 165809 | 14827.96 | 150981.04 | 194139 | 17800.24 | 176338.76 | 186537.5 | 17505.05 | 169032.45 | 1005632.5 | 94301.9499999999 | 911330.5500000009
TM73001 | 146612.53 | 64650.94999999994 | 81961.58 | 162655.56 | 26699.12 | 135956.44 | 203946.08 | 35086.76 | 168859.32 | 330220.97 | 66507.58 | 263713.39 | 198194.57 | 33287.93 | 164906.64 | 242012.07 | 37951.77 | 204060.3 | 1283641.78 | 264184.11 | 1019457.67
TM73002 | 77720.75 | 16355.16 | 61365.59 | 100164.66 | 20953.94 | 79210.71999999994 | 140416.91 | 27703.01000000005 | 112713.9 | 176199.49 | 35765.07000000007 | 140434.42 | 211664.29 | 62405.93999999978 | 149258.35 | 134201.77 | 23412.74 | 110789.03 | 840367.87 | 186595.86 | 653772.0099999991
(blank) | 300094.21 | 66035.33000000009 | 234058.88 | 478515.71 | 111334.04 | 367181.67 | 389316.17 | 107160.49 | 282155.68 | 413523.46 | 97180.44000000013 | 316343.02 | 508688.16 | 103689.85 | 404998.3099999994 | 255218.16 | 54326.55000000005 | 200891.61 | 2345355.87 | 539726.7000000005 | 1805629.170000019
Grand Total | 1739268.73 | 278953.09 | 1460315.640000008 | 2517134.28 | 363628.56 | 2153505.719999993 | 2547989.11 | 373749.3 | 2174239.81 | 2424951.7 | 380599.58 | 2044352.12 | 2767682.8 | 409968.61 | 2357714.19 | 2437439.59 | 341811.26 | 2095628.33 | 14434466.21 | 2148710.4 | 12285755.81000002
 | To pick up monthly Margin from above based on Names and to populate below
ACTUAL MARGIN CALCULATION
 | Jan | Feb | Mar | Apr | May | Jun
TM72001
TM72004
TM72006
TM72007
TM72009
TM72010