Spreadsheet: 189995d1351498512-how-to-consolidate-data-with-different-paramenter-test
Sheet: 2011b

 | 1
Project Code | R11001 | R11002 | [NAME] | R11188 | R11189 | R11190 | R11191 | R11192 | R11193 | [NAME] | R11195 | [NAME] | [NAME] | R11198 | R11199 | R11200 | R11201 | R11202 | R11203 | R11204 | R11205 | R11206 | R11207 | R11208 | R11209 | R11210 | R11211 | R11212 | R11213 | R11214 | R11215 | R11216 | R11217 | R11218 | R11219 | R11220 | [NAME] | R11222 | R11223 | R11224 | R11225 | R11226 | R11227 | [NAME] | R11229 | R11230 | R11231 | R12101 | Total
Revenue
Government | 300000 | 429833.7 | 383907 | 11244 | 40748 | 5160 | 15055 | 0 | 60000 | 4195 | 15155 | 9693 | 12797 | 233129 | 14522 | 7465 | 7285 | 7090 | 330018 | 40556 | 24398 | 15593 | 312892 | 7074 | 9520 | 8005 | 6978 | 5583 | 8973 | 78000 | 5530 | 697952 | 43572 | 5220 | 4930 | 5088 | 6130 | 42878 | 12660 | 9760 | 9993 | 4555 | 4150 | 7135 | 9985 | 12340 | 7360 | 0
Private | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Contract | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Revenue Total | 300000 | 429833.7 | 383907 | 11244 | 40748 | 5160 | 15055 | 0 | 60000 | 4195 | 15155 | 9693 | 12797 | 233129 | 14522 | 7465 | 7285 | 7090 | 330018 | 40556 | 24398 | 15593 | 312892 | 7074 | 9520 | 8005 | 6978 | 5583 | 8973 | 78000 | 5530 | 697952 | 43572 | 5220 | 4930 | 5088 | 6130 | 42878 | 12660 | 9760 | 9993 | 4555 | 4150 | 7135 | 9985 | 12340 | 7360 | 0
2 - Cost
Prime Costs
Material Usage | 0 | -14086.33 | -13902.05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -522.6700000000001 | 0 | 0 | 0 | 0 | -12352.92 | 0 | 0 | 0 | -7304.37 | 0 | 0 | 0 | 0 | 0 | 0 | -67013.93000000001 | 0 | -4990.669999999999 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sub-Contractor Fees | -33818 | -115390.5 | -209039 | 0 | -12224.4 | 0 | 0 | 0 | -18000 | 0 | 0 | 0 | 0 | -81360 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -23400 | 0 | -209385 | -13000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Worker Overtime | -459.92 | -4889.59 | -2393.9 | -31.8 | -439.65 | 0 | -49.5 | 0 | -238.74 | -61.2 | -63 | 0 | 0 | -928.2 | -81.60000000000001 | 0 | 0 | 0 | -2290.88 | -3097.82 | -120.16 | -133.5 | 0 | 0 | -133.96 | -37.8 | -18 | -259.58 | -239.48 | -327 | -122.4 | -1497.06 | -434.62 | 0 | 0 | 0 | 0 | -219.76 | -36 | -108 | 0 | 0 | 0 | 0 | 0 | -109.36 | -122.48 | 0
Worker Salary | -741.99 | -7572.8 | -7603.64 | -669.35 | -842.89 | -602.28 | -346.4 | -57.03 | -1806.87 | 0 | -422.58 | -491.21 | -247.18 | -2203.91 | -307.16 | -88.51 | 0 | 0 | -5132.400000000001 | -2055.18 | -520.63 | -139.55 | -134.49 | 0 | -31.1 | -64.1 | -153.2 | 0 | 0 | -1349.94 | -86.14 | -2796.3 | -281.61 | 0 | -71.39 | -65.84 | 0 | 0 | 0 | 0 | 0 | -88.19 | -54.09 | -32.1 | 0 | 0 | 0 | 0
Prime Costs Total | -35019.91 | -141939.22 | -232938.59 | -701.15 | -13506.94 | -602.28 | -395.9 | -57.03 | -20045.61 | -61.2 | -485.58 | -491.21 | -247.18 | -85014.78 | -388.76 | -88.51 | 0 | 0 | -19776.2 | -5153 | -640.79 | -273.05 | -7438.86 | 0 | -165.06 | -101.9 | -171.2 | -259.58 | -239.48 | -92090.87000000001 | -208.54 | -218669.03 | -13716.23 | 0 | -71.39 | -65.84 | 0 | -219.76 | -36 | -108 | 0 | -88.19 | -54.09 | -32.1 | 0 | -109.36 | -122.48 | 0
Direct Costs
Bank Other Charges | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Courier Charges | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Discount Allowed | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Docking Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
e Procurement Fees | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Entertainment | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Freight Charges | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Fuel & Oil Usage | 0 | -6299.030000000001 | -4211.309999999999 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -5387.24 | 0 | 0 | 0 | -708.6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -3543 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -3207.49
Hire Charges | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Inspection | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Loose Tools | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Maint Of Machinery | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -40.83 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Property Rental | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Realized Forex Loss | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Refreshment | 0 | -135 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -16.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sea Trial | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Stationery | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Telephone And Telefax | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Travelling-Accommodation | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Travelling-Fares | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Travelling-Subsist Allowance | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Vehicle Running Exp-Others | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
X-Ray & Radiography | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Direct Costs Total | 0 | -6434.030000000001 | -4211.309999999999 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -40.83 | 0 | 0 | 0 | 0 | -5403.74 | 0 | 0 | 0 | -708.6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -3543 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -3207.49
2 - Cost Total | -35019.91 | -148373.25 | -237149.9 | -701.15 | -13506.94 | -602.28 | -395.9 | -57.03 | -20045.61 | -61.2 | -485.58 | -491.21 | -247.18 | -85055.61 | -388.76 | -88.51 | 0 | 0 | -25179.94 | -5153 | -640.79 | -273.05 | -8147.46 | 0 | -165.06 | -101.9 | -171.2 | -259.58 | -239.48 | -92090.87000000001 | -208.54 | -222212.03 | -13716.23 | 0 | -71.39 | -65.84 | 0 | -219.76 | -36 | -108 | 0 | -88.19 | -54.09 | -32.1 | 0 | -109.36 | -122.48 | -3207.49
Total | 264980.09 | 281460.45 | 146757.1 | 10542.85 | 27241.06 | 4557.72 | 14659.1 | -57.03 | 39954.39 | 4133.8 | 14669.42 | 9201.79 | 12549.82 | 148073.39 | 14133.24 | 7376.49 | 7285 | 7090 | 304838.06 | 35403 | 23757.21 | 15319.95 | 304744.54 | 7074 | 9354.94 | 7903.099999999999 | 6806.8 | 5323.42 | 8733.52 | -14090.87000000001 | 5321.46 | 475739.97 | 29855.77 | 5220 | 4858.61 | 5022.16 | 6130 | 42658.24 | 12624 | 9652 | 9993 | 4466.81 | 4095.91 | 7102.9 | 9985 | 12230.64 | 7237.52 | -3207.49