{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["spreadsheet","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"defined_names":0,"comments":5,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"spreadsheet","index":0,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":false,"merged":[[32,0,32,7],[4,5,4,6],[4,10,4,11],[1,0,1,12],[2,0,2,12],[3,0,3,7],[3,9,3,12]],"flags":["formulas_cached_only"]}
[]
["LCLS Cost Estimate & Contingency Comparison "]
[]
["LCLS Project",{"$nulls":8},"Review Committee Assessment*"]
[{"$nulls":5},"Contingency Assessment",{"$nulls":4},"Contingency Assessment"]
["WBS Number","WBS Title","Work Accomplished","Work Remaining","Base Cost ($K) including escalation","% on Work Remaining","$K","Total ($K)",null,"Base Cost ($K) including escalation","% on Work Remaining","$K","Total ($K)","Variance ($K)"]
[1.01,"Project Management",18725.833,4095.7299999999996,22821.563,0.0927795533396977,380,23201.563,{"$nulls":4},0,-23201.563]
[1.02,"Injector",20239.3,0,20239.3,0,0,20239.3,{"$nulls":4},0,-20239.3]
[1.03,"Linac",22647.132,5609.907999999999,28257.04,0.1604304384314324,900,29157.04,{"$nulls":4},0,-29157.04]
[1.04,"Undulator",38723.585,6631.542000000001,45355.127,0.2880174776846772,1910,47265.127,{"$nulls":4},0,-47265.127]
[1.05,"X-ray Transport",20067.054,7426.758000000002,27493.812,0.20870479420495452,1550,29043.812,{"$nulls":4},0,-29043.812]
[1.06,"X-ray Endstations",2437.035,6678.252,9115.287,0.28151079054818534,1880,10995.287,{"$nulls":4},0,-10995.287]
[1.09,"Conventional Facilities",108574.583,27313.520000000004,135888.103,0.2826439067538713,7720,143608.103,{"$nulls":4},0,-143608.103]
["1.0X","LCLS Controls",26310.067,15059.002000000004,41369.069,0.2231223556514568,3360,44729.069]
[null,"subtotal",257724.589,72814.71200000001,330539.30100000004,0.2430827440476589,17700,348239.30100000004,null,0,null,0,0,-303510.232]
[null,"Actual Contingency",null,null,21460.698999999964,null," "]
[null,"Total Estimated Cost",null,null,352000,null,null,352000]
[{"$nulls":4}," "," "," "," "]
[2.01,"Project Management ",14076.715,10168.821,24245.536]
[2.02,"Injector",5160.439,641.9699999999993,5802.409]
[2.03,"Linac",876.651,1150.3560000000002,2027.007]
[2.04,"Undulator",3553.049,6414.3679999999995,9967.417]
[2.05,"X-ray Transport",1838.892,2022.3859999999997,3861.278]
[2.06,"X-ray Endstations",1663.055,6425.588,8088.643]
[2.09,"Conventional Facilities",258.535,1606.916,1865.451,null,null," "]
["2.0X","LCLS Controls",637.74,2179.6980000000003,2817.438]
[null,"subtotal",28065.076000000005,30610.103,58675.179]
[null,"Management Reserve",null,null,9324.821000000004,null,null," "]
[null,"Total Other Project Costs",null,null,68000,null," "," "]
[]
[null,"Total Project Cost",null,null,420000]
[]
[]
[]
[]
[{"$nulls":5}," "]
[]
[{"$nulls":7}," "]

{"sheet":"Sheet2","index":1,"n_rows":20,"n_cols":17,"rows_kept":20,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["PROJECT WBS[2]","Current Period",{"$nulls":4},"Cumulative to Date",{"$nulls":4},"At Completion"]
[null,null,null,"Actual",{"$nulls":4},"Actual"]
[null,"Budgeted Cost",null,"Cost","Variance",null,"Budgeted Cost",null,"Cost","Variance",null,null,"Latest"]
[null,"Work","Work","Work",null,null,"Work","Work","Work",null,null,null,"Revised"]
["Item","Scheduled","Performed","Performed","Schedule","Cost","Scheduled","Performed","Performed","Schedule","Cost","Budgeted","Estimate","Variance","Contingency from DCE","Rem Work","%Contingency"]
[]
["   1.01 LCLS PROJECT MGMT, PLANNING & ADMN (TEC)",255686,254235,296956,-1451,-42721,27618142,27616691,27659412,-1451,-42721,32320245,32301891,18355,454916.78925705695,4703554,0.09671767120289401]
["   1.02 INJECTOR SYSTEM",0,0,-3274,0,3274,23857675,23857675,23854401,0,3274,23857675,23854401,3274,null,0]
["   1.03 LINAC SYSTEM",1222796,1080762,1021923,-142034,58839,30273416,30131382,30072543,-142034,58839,39807176,39737069,70107,1723908.0280274258,9675794,0.17816708665226086]
["   1.04 UNDULATOR SYSTEM",2156783,1780011,1842813,-376772,-62802,41357257,40980486,41043288,-376772,-62802,49075076,49067021,8056,2181070.208180308,8094590,0.26944789151523524]
["   1.05 X-RAY TRANSPORT & DIAGNOSTICS SYSTEMS",928732,731701,1008869,-197031,-277168,23117291,22920259,23197427,-197031,-277168,31739918,32026715,-286797,1731471.7206659687,8819659,0.19631957660335492]
["   1.06 X-RAY END STATION SYSTEMS",195911,194826,227973,-1085,-33147,3644598,3643513,3676660,-1085,-33147,17851108,17885865,-34757,3888989.429964663,14207595,0.2737260901626674]
["   1.09 CONVENTIONAL FACILITIES",3137521,3121084,3065363,-16437,55722,108591020,108574583,108518862,-16437,55722,135888103,135828619,59484,7719937.87277488,27313520,0.28264163215780613]
["   2.01 LCLS PROJECT MGMT, PLANNING & ADMN (OPC)",563938,563607,476671,-331,86936,14181764,14181433,14094497,-331,86936,24416834,24075337,341498,null,10235401]
["   2.02 INJECTOR SYSTEM (OPC)",65748,68924,108591,3176,-39668,5160962,5164137,5203805,3176,-39668,5995549,6035212,-39663,null,831412]
["   2.03 LINAC SYSTEM (OPC)",178595,182613,157742,4018,24872,908485,912503,887632,4018,24872,2139614,2114752,24862,null,1227111]
["   2.04 UNDULATOR SYSTEM (OPC)",299106,391588,171672,92482,219916,3531156,3623638,3403722,92482,219916,10268787,10012146,256641,null,6645149]
["   2.05 X-RAY TRANSPORT & DIAGNOSTICS SYSTEMS (OPC)",153474,154907,43303,1433,111604,1837460,1838892,1727289,1433,111604,3861278,3745405,115873,null,2022386]
["   2.06 X-RAY END STATION SYSTEMS (OPC)",85640,374121,351814,288481,22307,1797458,2085939,2063632,288481,22307,10127664,10103767,23898,null,8041725]
["   2.09 Conventional Facility Commissioning",71552,75386,25772,3834,49614,254701,258535,208921,3834,49614,1865451,1812779,52672,null,1606916]

{"sheet":"Sheet3","index":2,"n_rows":41,"n_cols":13,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,0,0,7],[0,8,0,9],[1,0,5,0],[1,1,1,7],[1,8,5,8],[1,9,5,9],[2,1,3,2],[2,3,5,3],[2,4,3,5],[2,6,3,7],[4,6,5,6],[4,7,5,7],[15,0,16,4],[15,5,15,7],[4,1,5,1],[4,2,5,2],[4,4,5,4],[4,5,5,5],[15,9,16,9],[16,5,16,7],[26,0,27,4],[26,5,26,7],[26,9,27,9],[27,5,27,7],[37,2,37,5],[37,7,37,8],[38,2,38,5],[39,0,40,0],[39,2,39,5],[40,2,40,5]],"flags":["formulas_cached_only"]}
["LCLS Cost/Schedule Status Report",{"$nulls":7},"2008-02-29"]
["WBS","Cumulative to Date ($K)",{"$nulls":6},"Budget At Complete ($K)","% Complete"]
[null,"Budgeted Cost",null,"Actual Cost Work Performed","Variance",null,"Performance Indices"]
[]
[null,"Work Scheduled","Work Performed",null,"Schedule","Cost","SPI","CPI"]
[{"$nulls":10},"EAC","EAC_aug","delta"]
["1.1  Project Management",18725.833,18725.833,18752.18,0,-26.34700000000157,1,0.9985949900224933,22821.563,0.8205324499465703,22847.91,19074.597999999998,-3773.3120000000017]
["1.2  Injector",20239.3,20239.3,20236.026,0,3.2739999999976135,1,1.0001617906598854,20239.3,1,20236.026,20226.771,-9.255000000001019]
["1.3  Linac",23001.27,22647.132,22611.822,-354.137999999999,35.31000000000131,0.98460354580421,1.0015615725260885,28257.04,0.8014686605532639,28221.73,26419.992,-1801.7380000000012]
["1.4  Undulator",39000.792,38723.585,39005.957,-277.20700000000215,-282.372000000003,0.9928922725466702,0.992760798049385,45355.127,0.8537862764666054,45637.499,42760.493,-2877.006000000001]
["1.5  X-ray Transport",20273.609,20067.054,20324.09,-206.5550000000003,-257.03600000000006,0.9898116314663068,0.9873531361059708,27493.812,0.7298752897561095,27750.848,25256.817,-2494.0310000000027]
["1.6  X-ray Endstations ",2436.912,2437.035,2463.748,0.1230000000000473,-26.713000000000193,1.0000504737142746,0.9891575761806808,9115.287,0.2673569137208735,9142,8652.302,-489.6980000000003]
["1.9  Conventional Facilities",108591.02,108574.583,108518.862,-16.437000000005355,55.721000000005006,0.9998486338925631,1.0005134683406467,135888.103,0.7989999168654227,137740.425,126875.008,-10865.416999999987]
["1.X  LCLS Controls",26190.665,26310.067,26109.907,119.40199999999822,200.15999999999985,1.0045589525886418,1.0076660556470003,41369.069,0.6359840246827889,41168.909,34636.578,-6532.330999999998]
["1 LCLS Total Base Cost",258459.401,257724.589,258022.592,-734.8120000000085,-298.00300000000107,0.9971569538691301,0.998845050746564,330539.30100000004,0.7797093665421649,332745.34699999995,303902.559,-28842.787999999942]
[" ",{"$nulls":4},"LCLS Total Estimated Cost",null,null,352000]
[{"$nulls":5},"Contingency",null,null,21460.698999999964,null,null,11097.440999999992,11097.440999999992]
["2.1  LCLS Project Mgmt, Planning & Admn (OPC)",14076.715,14076.715,14022.573,0,54.141999999999825,1,1.0038610603061222,24245.536,0.5805899692215507,24191.394,29525.664,5334.27]
["2.2  Injector (OPC)",5138.8,5160.439,5203.805,21.639000000000124,-43.365999999999985,1.0042109052697128,0.9916664825065505,5802.409,0.8893614703823879,5845.775,6784,938.2250000000004]
["2.3  Linac (OPC)",876.651,876.651,851.721,0,24.92999999999995,1,1.0292701483232185,2027.007,0.43248543295607755,2002.0770000000002,3401.529,1399.4519999999998]
["2.4  Undulator (OPC)",3469.623,3553.049,3362.695,83.42599999999993,190.35399999999981,1.0240446872758222,1.056607572200274,9967.417,0.3564663743876674,9777.063,4699.682000000001,-5077.380999999999]
["2.5  X-ray Transport (OPC)",1837.46,1838.892,1727.289,1.4320000000000164,111.60300000000007,1.0007793366930438,1.0646116544480977,3861.278,0.4762392140633231,3749.6749999999997,4876.183,1126.5080000000003]
["2.6  X-ray Endstations (OPC)",1375.395,1663.055,1649.998,287.6600000000001,13.057000000000016,1.2091471904434727,1.0079133429252642,8088.643,0.20560370880504927,8075.585999999999,4869.626,-3205.959999999999]
["2.9  Conventional Facilities (OPC)",254.701,258.535,208.921,3.8340000000000316,49.61400000000003,1.0150529444328842,1.237477323964561,1865.451,0.13859115034380426,1815.837,682.657,-1133.1799999999998]
["2.X  LCLS Controls (OPC)",642.64,637.74,562.496,-4.899999999999977,75.24400000000003,0.9923752022905515,1.1337680623506656,2817.438,0.22635458171572898,2742.1940000000004,1175.4089999999999,-1566.7850000000005]
["2 LCLS Total Other Project Cost",27671.985,28065.076000000005,27589.498,393.09100000000024,475.57799999999975,1.0142053777493738,1.0172376460057375,58675.179,0.4783125757485973,58199.60100000001,56014.75,-2184.8510000000097]
[" ",{"$nulls":4},"LCLS Other Project Cost",null,null,68000]
[{"$nulls":5},"Management Reserve",null,null,9324.821000000004,null,9800.39899999999]
["LCLS Total Project Cost",286131.386,285789.66500000004,285612.09,-341.7210000000083,177.57499999999868,0.998805719970895,1.0006217348852424,420000,0.7342729515099233]
[]
["February 2008 Project Performance","AYK$"]
["Total Project Cost (TPC)",420000]
["% Planned (Cumulative)",0.7351509275811114," "]
["% Complete (Cumulative)",0.7342729515099233," "]
["Total Estimated Cost (TEC)",352000]
["Cost and Commitments to Date",270739.6,{"$nulls":7}," "]
["Estimate at Complete (EAC)",332745.34699999995,null," "]
["Work Remaining",75020.75799999994," ",null,null,null,"AYK$","Contingency Based on EAC"]
["Outstanding Phase-Funded Awards",26378.172,"Outstanding Phase-Funded CF Awards (Includes A/E T3, CM/GC and Trades)",null,null,null,11000.843,1100.0843000000002,0.1]
["Remaining Contingency Based on EAC",19254.65300000005,"Outstanding Phase-Funded Technical Awards",null,null,null,15377.328999999998,768.86645,0.05]
[null,0.3596204821954937,"Remaining Uncommitted Work",null,null,null,48344.58299999995,17385.70225000005,0.3596204821954937]