Spreadsheet: 136650d1326758851-formulae-to-copy-horizontally-vertical-values-from-another-sheet-book1
Sheet: Source Data

CLIN 10                                             Invoice Number | 010038 | 010039 | 010040 | 010041 | 010042 | 010043 |  |  |  |  |  |  |  |  |  | Cumulative to
Date | 2011-10-14 00:00:00 | 2011-10-28 00:00:00 | 2011-11-11 00:00:00 | 2011-11-22 00:00:00 | 2011-12-09 00:00:00 | 2011-12-15 00:00:00 |  |  |  |  |  |  |  |  |  | 2011-12-30 00:00:00
Material Costs | 12771.82 | 112897.54 | 135702.91 | 33819.53999999999 | 197939.6936363637 | 61766.49000000001 |  |  |  |  |  |  |  |  |  | 5044116.605454545
Services Costs | 0 | 0 | 1880 | 412.73 | 3685 | 0 |  |  |  |  |  |  |  |  |  | 191366.15
ODC Costs | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  | 2857.55
Sub Total | 12771.82 | 112897.54 | 137582.91 | 34232.27 | 201624.6936363637 | 61766.49000000001 |  |  |  |  |  |  |  |  |  | 5238340.305454547
Fee @ 6.00%-6.00% | 766.3091999999999 | 6773.852400000001 | 8254.9746 | 2053.9362 | 12097.48161818182 | 3705.9894 |  |  |  |  |  |  |  |  |  | 314300.4183272727
Sales Price | 13538.1292 | 119671.3924 | 145837.8846 | 36286.20619999999 | 213722.1752545455 | 65472.4794 |  |  |  |  |  |  |  |  |  | 5552640.723781819
CLIN 2                                               Invoice Number | 38964 | 38965 | 38966 | 38967 | 38968 | 38969 | 38970 | 38971 | 38972 | 38973 | 38974 | 38975 | 38976 | 38977 |  | Cumulative to
Date | 2011-10-14 00:00:00 | 2011-10-14 00:00:00 | 2011-10-28 00:00:00 | 2011-10-28 00:00:00 | 2011-11-11 00:00:00 | 2011-11-11 00:00:00 | 2011-11-22 00:00:00 | 2011-11-22 00:00:00 | 2011-11-24 00:00:00 | 2011-12-09 00:00:00 | 2011-12-09 00:00:00 | 2011-12-15 00:00:00 | 2011-12-15 00:00:00 | 2011-12-30 00:00:00 |  | 2011-12-30 00:00:00
Labour Costs | 526673.7297499998 | 0 | 517966.1435 | 0 | 559894.4817500009 | 0 | 480444.0840000001 | 0 | 66931.63649999994 | 559103.2090000001 | 0 | 226956.1049999998 | 0 | 403477.52 |  | 117976148.3214544
Material Costs | 0 | 184209.7799999996 | 0 | 75797.66000000006 | 0 | 136833.4400000002 | 0 | 107011.5800000001 | 0 | 0 | 364825.8400000003 | 0 | 63376.18999999999 | 0 |  | 29838811.19012754
Services Costs | 0 | 356422.6645454546 | 0 | 277353.5745454545 | 0 | 212628.57 | 0 | 173416.21 | 0 | 0 | 305928.47 | 0 | 196012.7972727272 | 0 |  | 31229679.88489645
ODC Costs | 0 | 0 | 2407.1 | 0 | 623.38 | 0 | 1151.51 | 0 | 50350.31999999985 | 1178.46 | 0 | 278.2600000000002 | 0 | 0 |  | 1656142.643369926
Fringe @ 95.36% | 502236.0686895998 | 0 | 493932.5144416 | 0 | 533915.3777968008 | 0 | 458151.4785024001 | 0 | 24249.18487577441 | 533160.8201024001 | 0 | 216425.3417279998 | 0 | 384756.163072 |  | 49403538.17724083
Overhead @ 2.06% on Labour Related Effort | 21195.54184785575 | 0 | 20845.11235359696 | 0 | 22532.48310666411 | 0 | 19335.06858754945 | 0 | 70580.31888687039 | 22500.63899950945 | 0 | 9133.657802596792 | 0 | 16237.6138712832 |  | 3518292.083106305
O/Head rate changed for period end 021107 from 1.26%
Overhead - Employee Benefits | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 547432.46
G&A  @ 10.19% on Labour Related Effort | 104845.9084609952 | 0 | 103112.473244249 | 0 | 111459.2246878191 | 0 | 95642.88781899458 | 0 | 9291.325698191406 | 111301.7045655346 | 0 | 45180.56942158316 | 0 | 80321.0123050368 |  | 16877960.2897357
Sub Total | 1154951.248748451 | 540632.4445454541 | 1138263.343539446 | 353151.2345454546 | 1228424.947341285 | 349462.0100000002 | 1054725.028908944 | 280427.79 | 221402.785960836 | 1227244.832667444 | 670754.3100000003 | 497973.9339521796 | 259388.9872727272 | 884792.30924832 |  | 251048005.0594575
Fee @ 7.55 - 6.64% - 6.25% - 7.48% - 7.56%-7.43% - 7.50% -7.60%- 7.69%-7.73%-7.77%-7.76%-7.74%-7.64%-7.65% | 88353.77052925646 | 41358.38200772724 | 87077.1457807676 | 27016.06944272728 | 93974.5084716083 | 26733.84376500002 | 80686.46471153424 | 21452.725935 | 16937.31312600395 | 93884.22969905949 | 51312.70471500002 | 38095.00594734174 | 19843.25752636364 | 67686.61165749647 |  | 19163293.80754005
Sales Price | 1243305.019277707 | 581990.8265531814 | 1225340.489320213 | 380167.3039881819 | 1322399.455812893 | 376195.8537650002 | 1135411.493620479 | 301880.515935 | 238340.0990868399 | 1321129.062366504 | 722067.0147150003 | 536068.9398995213 | 279232.2447990909 | 952478.9209058164 |  | 270211298.8669977