{"text_format":"2","workbook":"xls","n_sheets":10,"sheets":["System Summary","WBS Summary","Past CR Summary","PM-Sisson","LN-Chan","UN-Pope","UN-Pile","XT-McMahon","April CPR Data","CPR by CAM"],"not_rendered":{"charts":3,"images":0,"macros":0,"external_links":1,"defined_names":7,"comments":0,"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":"System Summary","index":0,"n_rows":30,"n_cols":36,"rows_kept":30,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[1,2,3,4,5,6,7]
["LCLS Major Systems","Unplanned Costs (Actualized)","Apr07 (Baseline) ETC","Revised ETC (Includes CR effects)","Future CR Effects ( 4 - 3 )","Contingency on Future CR Effects","Total CR Impact ( 2 + 5 + 6 )"]
["Project Office (TEC Support)",731.3444000000001,2984.872,8087.933,5103.061,null,null,null,"Linac Coherent Light Source Approved Funding Profile (AYM$)"]
["E-Beam Systems",2601.8680482,33433.257,38988.27,5555.012999999999,null,null,null," ","Costs to Date","FY07","FY08","FY09","FY10","Total"]
["Photon Beam Systems",1535.2974333333336,25775.981,29325.614,3549.6330000000016,null,null,null,"TEC Funding",null,105.9,51.36,10,0,315]
["Conventional Facilities",388.22980000000007,79675.567,80762.519,1086.9520000000048,null,null,null,"Cum TEC Funding",147.74,253.64000000000001,305,315,315]
["Total Impact TEC",5256.739681533333,141869.677,157164.336,15294.659000000005,3364.8249800000012,23916.22366153334,null,"OPC Funding",null,16,15.5,21.5,0,64]
["Project Office (OPC Support)",181.04840000000002,9086.633,13132.555,4045.9220000000005,null,null,null,"Cum OPC Funding",11,27,42.5,64,64]
["E-Beam Systems",0,22502.567,22453.853,-48.71399999999994,null,null,null,"Total Funding",null,121.9,66.86,31.5,0,379]
["Photon Beam Systems",63.333333333333336,9046.13,10233.431,1187.3010000000013,null,null,null,"Cum Total Funding",158.74,280.64,347.5,379,379]
["Conventional Facilities",0,682.657,1076.455,393.7979999999999]
["Total Impact OPC",244.38173333333336,41317.986999999994,46896.293999999994,5578.307000000002,557.8307000000002,6380.519433333336]
[]
["Total Impact TPC",5501.121414866667,183187.664,204060.63,20872.966000000008,3922.6556800000017,30296.743094866673]
[{"$nulls":8},"Linac Coherent Light Source Proposed Funding Profile (AYM$)",{"$nulls":8},"old","FY02","FY03","FY04","FY05","FY06","FY07","FY08","FY09","FY10","Total"]
["Column 2 - Past CR Impacts already in the actual costs.",{"$nulls":7}," ","Costs to Date","FY07","FY08","FY09","FY10","Total",null,null,null,1.5,5.925,9.456,53.674,88.188,121.9,66.86,31.5,0,379.00300000000004]
["Column 3 - Apr07 ETC (Current Baseline)",{"$nulls":7},"TEC Funding",null,101,51.36,31.5,7.4,339]
["Column 4 - Revised ETC due to CR",{"$nulls":7},"Cum TEC Funding",147.74,248.74,300.1,331.6,339,null,null,null,"new","FY02","FY03","FY04","FY05","FY06","FY07","FY08","FY09","FY10","Total"]
["Column 5 - Delta of Column 4 and Column 3 (CR Impacts in the future)",{"$nulls":7},"OPC Funding",null,13,15.5,17,13.5,70,null,null,"TEC",null,5.925,7.456,49.674,84.688,109,66.86,48.5,20.9,393.003]
["Column 6 - Contingency on Column 5 (top down, assume 22% on TEC, 10% on OPC)",{"$nulls":7},"Cum OPC Funding",11,24,39.5,56.5,70,null,null,null,"OPC",1.5,null,2,4,3.5,13,15.5,17,13.5,70]
["Column 7 - Total CR Impact (Past + Future + Contingency on Future)",{"$nulls":7},"Total Funding",null,114,66.86,48.5,20.9,409]
[{"$nulls":8},"Cum Total Funding",158.74,272.74,339.6,388.1,409]
[]
[]
[]
[{"$nulls":27},81.188,null,null,null,"PO","XT-XE","CF","E-Beam","totals"]
[{"$nulls":30},"Labor",5944,4236,1428,2267,13875]
[{"$nulls":30},"Proc Srvc",2224,30,809,-616,2447]
[{"$nulls":30},"M&S",981,471,-756,3855,4551]
[{"$nulls":31},9149,4737,1481,5506,20873]

{"sheet":"WBS Summary","index":1,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["WBS","Past CR Impact","Apr07 ETC","Apr07 ETC + Future CR Impact","Future CR Impact","Contingency for Future CR Impact","Total CR Impact (past + future + contingency)"]
["1.1 - Proj Mgmt",731.3444000000001,2984.872,8087.933,5103.061]
["1.2 - Injector",0,185.207,141.289,-43.918000000000006]
["1.3 - Linac",283.8401482,9729.083,11837.554,2108.4709999999995]
["1.4 - Undulator",2318.0279,12699.695,15202.468,2502.773000000001]
["1.5 - X-ray Transport",1310.2514333333336,11536.789,13047.605,1510.815999999999]
["1.6 - X-ray Endstations",225.046,6915.042,7158.221,243.17899999999918]
["1.9 - Conventional Facilities",388.22980000000007,79675.567,80762.519,1086.9520000000048]
["1.X - Controls",0,18143.422,20926.745,2783.3230000000003]
["Total Impact TEC",5256.739681533334,141869.677,157164.334,15294.657000000003,3364.8245400000005,23916.22122153334]
["2.1 - Proj Mgmt",181.04840000000002,20464.14,19013.392,-1450.7479999999996]
["2.2 - Injector",0,3372.446,3912.144,539.6979999999999]
["2.3 - Linac",0,3161.229,2831.672,-329.5569999999998]
["2.4 - Undulator",0,4671.245,9911.91,5240.665]
["2.5 - X-ray Transport",63.333333333333336,3674.37,1725.749,-1948.6209999999999]
["2.6 - X-ray Endstations",0,4214.985,6983.83,2768.8450000000003]
["2.9 - Conventional Facilities",0,682.657,1076.455,393.7979999999999]
["2.X - Controls",0,1076.913,1441.142,364.22900000000004]
["Total Impact OPC",244.38173333333336,41317.985,46896.29400000001,5578.309000000001,557.8309000000002,6380.521633333335]
[]
["Total Impact TPC",5501.121414866668,183187.662,204060.62800000003,20872.966000000004,3922.6554400000005,30296.742854866672]
[]
[]
[]
[]
[]
[null," "]

{"sheet":"Past CR Summary","index":2,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["System","Orginator","Date","Description","Estimated Cost","Notes"]
["PM","Reich","November - February","Redirection of management staff due to funding uncertainty",881794.7,"Uncertainty with one year CR (~Nov06-Feb07)"]
["PM","Reich","March-June","Preparation for CR Revised Baseline",1437972.8,"Rebaseline exercise and EIR prep"]
["LN","Chan","October-March","Redirection of Mechanical Staff",16916.800000000003,"40% Eric's effort estimating different scenario"]
["LN","Chan","October-March","Scale-back LTU design effort",192107.9482,"Uncertain with one yr CR LTU staff worked at slower pace, based on schedule slip"]
["LN","Chan","March","Procurement delays due to design effort",70715,"15% premium for supports ($471,450; Req. #11295)  to deliver on schedule for 2008 installation"]
["UN","Pile","January - February","Delays due to hold on funding to ANL",1391705,"3-4 months with lack of funding for Undulator System componets"]
["UN","Pope","November - April","Delays in MMF due to hold on funding to ANL",455555]
["XT","McMahon","January - February","Delays due to hold on funding to LLNL",1054354.1666666667,"Procurements delayed, uncertainty about plan"]
["XES","Moeller",null,null,0,"no impact"]
[{"$nulls":4},5501121.414866666]
{"$rows_empty":9}
[null,null,"     "]

{"sheet":"PM-Sisson","index":3,"n_rows":42,"n_cols":7,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,1,0,4],[1,4,20,4],[21,1,21,4],[22,4,41,4]],"flags":["formulas_cached_only"]}
["CR Actualized Impact #1 (Nov15-Feb15)","LCLS management team working through possibility of a one year CR in ~15Nov.  Funding situation understood on Feb 16.  3 month duration"]
[null,"Fraction","Resource Rate","CR Impact","Following the 2006 election, DOE-BES informed LCLS of the strong probability of a year-long Continuing Resolution for FY07 (Planned funding $122M).  Worst case scenario: a full year of FY06 funding (~$85M) followed by the approved funding in FY08 (~$66M).  Restoration would be provided in FY09 and beyond.\n\nProject team evaluated several reduced budget scenarios, possible staffing reductions, cancelling shutdown work and prioritization of procurements over four months.  In late January 2007, LCLS stopped all non-critical procurements to ensure it had sufficient funds to honor its current commitments.  In mid-February, LCLS was informed funding would be reduced by ~$8M from planned FY07 level.  Additional iterations were needed to identify optimum go-forward plan.  "]
[]
["Project Director",0.2,80806,16161.2]
["Deputy Project Director",0.3,80806,24241.8]
["Associate Project Director-Eng",0.15,80806,12120.9]
["Associate Project Director-Civil Const",0.1,80806,8080.6]
["Finance Manager",0.3,44680,13404]
["PMCS Lead",0.4,72122,28848.800000000003]
["PMCS Team",0.25,288490,72122.5]
["E-Beam System Manager",0.3,52772,15831.599999999999]
["Photon Beam System Manager",0.3,52772,15831.599999999999]
["Installation/Integration Manager",0.3,52771,15831.3]
["Linac LOE (charge to Linac)",0.2,7848,1569.6000000000001]
["Undulator LOE-SLAC (charge to Undulator)",0.2,205036,41007.200000000004]
["Undulator LOE-ANL (charge to Undulator)",0.2,713395,142679]
["XTOD LOE-LLNL (charge to XTOD)",0.2,610968,122193.6]
["XE LOE (charge to XE)",0.2,456593,91318.6]
["CF LOE (charge to CF)",0.2,731084,146216.80000000002]
["Physicist LOE (OPC) (charge to OPC)",0.2,571678,114335.6]
["Total for CR Impact #1",null,null,881794.7]
["CR Impacts #2 (Mar01-Jun30)","Rebaseline effort and prep for EIR.  Separate effort related to CR from the semi-annual Lehman status review (part of baseline). Mar1 -Jun30 4month duration."]
[null,"Fraction","Resource Rate","CR Impact","FY07 funding reduced ~$8M from baseline profile.  LCLS project team immediately initiated its System Manager's to award procurements and redeploy resources to execute its new strategy.  Final iteration called for deferring procurements in the XT and XE region until FY09 and a phased CD-4a (photons in the NEH) and CD-4b (photons in the FEH) for project completion. \n\nProject team began preparations on its detailed rebaseline plan, including a revised cost and schedule.  This preparation includes sufficient details to identify the past and future costs of the continuing resolution and funding uncertainties, and to present the revised baseline to an External Independent Review (EIR) reporting to the DOE Office of Engineerinng & Construction Management. "]
[]
["Project Director",0.3,97876,29362.8]
["Deputy Project Director",0.5,97876,48938]
["Associate Project Director-Eng",0.15,97876,14681.4]
["Associate Project Director-Civil Const",0.15,97876,14681.4]
["Finance Manager",0.3,54120,16236]
["PMCS Lead",0.75,82204,61653]
["PMCS Team",0.75,328818,246613.5]
["E-Beam System Manager",0.4,63920,25568]
["Photon Beam System Manager",0.4,63920,25568,null,null," "]
["Installation/Integration Manager",0.4,63920,25568,null,null," "]
["Linac LOE (charge to Linac)",0.3,8436,2530.7999999999997]
["Undulator LOE-SLAC (charge to Undulator)",0.3,220414,66124.2]
["Undulator LOE-ANL (charge to Undulator)",0.3,736525,220957.5]
["XTOD LOE-LLNL (charge to XTOD)",0.3,656790,197037]
["XE LOE (charge to XE)",0.3,445758,133727.4]
["CF LOE (charge to CF)",0.3,806710,242013]
["Physicist LOE (OPC) (charge to OPC)",0.1,667128,66712.8]
["Total",null,null,1437972.8]

{"sheet":"LN-Chan","index":4,"n_rows":31,"n_cols":16,"rows_kept":31,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[{"$nulls":5},"Oct-06","Nov-06","Dec-06","Jan-07","Feb-07","Mar-07",null,null,"CR non-productive","months slip"]
["1.03.01.01.06","LTU System Integration","9242582","Fox,Kay E.","Mechanical Designer",216,202,154,205,186,107.5,1070.5]
[null,null,null,"Franklin,Joseph W.","Mechanical Designer",57,94,{"$nulls":4},151]
[null,null,null,"Montagne,Timothy M.","Engineer-Mechanical",93.6,110.4,83.2,139.2,128,136,690.4]
[null,null,null,"Palrang,Michael T.","Science & Engineering Assoc",62.4,55.9,15.6,null,null,null,133.9]
[null,null,null,"Schafer,Donald William","Science & Engineering Assoc",67.2,135.2,79.2,null,null,null,281.59999999999997,2327.4,0.5,3,1163.7]
["1.03.03.05","LTU Quad","9242609","Franklin,Joseph W.","Mechanical Designer",null,null,null,80,144,84,308]
[null,null,null,"Palrang,Michael T.","Science & Engineering Assoc",null,null,null,14.82,4.26,43.61,62.69]
[null,null,null,"Schafer,Donald William","Science & Engineering Assoc",null,null,14.4,152,152,156.8,475.2,845.89,0.33,2,279.1437]
["1.03.04.05","Linac to Undulator (LTU) Vacuum System","9242619","Franklin,Joseph W.","Mechanical Designer",{"$nulls":5},24,24,24,0.33,2,7.92]
["1.03.05.05","Profile Monitors (5ea)","9242626","Franklin,Joseph W.","Mechanical Designer",null,null,41,21,null,64,126,126,1,6,126]
["1.03.05.07","Bunch Length Monitors (4ea)","9242627","Palrang,Michael T.","Science & Engineering Assoc",null,null,36.2,111.38,94.74,null,242.32,242.32,1,6,242.32]
[{"$nulls":11},0,null,null,null,1819.0837000000001]
[{"$nulls":11},0.5,"productivity"]
[{"$nulls":11},0]
[{"$nulls":11},86,"Rate /hr",null,null,86]
[{"$nulls":11},0,null,null,null,156441.1982]
["1.03.04.05","Linac to Undulator (LTU) Vacuum System","9242619","Design Visionaries Inc",{"$nulls":4},4227.5,31439.25]
[{"$nulls":11},"Past CR Labor cost",null,null,null,192107.9482]
[]
[{"$nulls":5},"Oct-06","Nov-06","Dec-06","Jan-07","Feb-07","Mar-07"]
[null,"Linac Management","9242585","Bong,Eric L.","Engineer-Mechanical",84,76,60,168,null,null,388]
[{"$nulls":11},0.4,"CR"]
[{"$nulls":11},155.20000000000002]
[{"$nulls":11},109,"rate /hr"]
[{"$nulls":11},16916.800000000003]
[null,null,null,"Comments","estimated cost","15% expediting fee"]
[null,"LUT Support stands",null,"Out for quote",417450,70715]
[]
[null,"back up notes and e-mail"]
[null,"V:\\LCLS\\Users\\JQChan\\2007 Continue Resolution"]

{"sheet":"UN-Pope","index":5,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,0,2,8],[7,0,7,8]],"flags":["formulas_cached_only"]}
[]
[" - MMF delays (past and continuing)"]
["  - Based on hardware delivery and quality issues with ANL deliverables causing delays in MMF performance.  Selected durations from Zack's FAC presentation."]
["  - Past ED&I - $300k = 4 months * 5 FTE * $15k/FTE/month"]
["  - Past M&S - $25k = $10k for mu-metal modification + $15k shim fabrication"]
[]
[" - Serial to parallel assembly and installation (now and future)"]
["  - Past ED&I:  Inefficiency in performing value added work - $130.5k = 3 months * 2.9 FTE (Robert (20%), Catherine (20%), Ben (50%), Ed (50%), Nick (50%), Franz (50%), Georg (50%))* $15k/FTE/month"]

{"sheet":"UN-Pile","index":6,"n_rows":60,"n_cols":3,"rows_kept":60,"cut":false,"hidden":false,"merged":[[11,0,11,8],[12,0,12,8],[13,0,13,8],[14,0,14,8],[15,0,15,8],[16,0,16,8],[17,0,17,8],[18,0,18,8],[19,0,19,8],[20,0,20,8],[21,0,21,8],[23,0,23,8],[25,0,25,8],[27,0,27,8],[28,0,28,8],[29,0,29,8],[30,0,30,8],[31,0,31,8],[32,0,32,8],[34,0,34,8],[59,0,59,8],[57,0,57,8],[55,0,55,8],[53,0,53,8],[51,0,51,8],[49,0,49,8],[48,0,48,8],[46,0,46,8],[38,0,38,8],[36,0,36,8],[37,0,37,8],[44,0,44,8],[43,0,43,8],[42,0,42,8],[40,0,40,8]],"flags":["formulas_cached_only"]}
["WBS#","CR Impact Cost"]
["1.4.1",530180,"Undulator System Management & Integration    "]
["1.4.2",null,"Controls                                                    "]
["1.4.3",244545,"Undulator Magnet & Support                                  "]
["1.4.4",450870,"Vacuum System                                               "]
["1.4.5",166110,"Diagnostics                                                 "]
["1.4.6","  ","Undulator System Installation and Alignment                 "]
["Totals           ",1391705]
[]
[null,"The effects of the Continuing Resolution of FY07                May 1, 2007"]
[]
["The FY07 Technical Addendum to ANL MOU states that ANL will receive ~ $15M. "]
["September 06 - Advanced payment of $2M for FY07 undulator assemblies"]
["Oct 07 – ANL uses carry over funds -CR is an issue but Vacuum and Support Mover Systems could do with more R&D and Production Engineering"]
["Stainless Vs Aluminum Vac chamber effort created – (was good strategy to confirm processes before production)             "]
["January 07 - CR Now becomes a major issue"]
["Mid-January -Enough funding left for 6 weeks of effort only. Put all procurements on hold. Planned core team disaster scenario."]
["February 07 - Received additional $2M 2/6/07. We prioritized procurements – zero funded >$50K procurements for vendor responses. We planned to release only low value long lead items but had “commitments” issue."]
["March 07 - Received additional $2M 3/16/07 so we released low value long lead items "]
["March 07 - Received $6m end of March 07 "]
["April 07 – routing funded requisitions for re-approvals    "]
["May 07 - Remaining $3M will be required as soon as Support Mover contract and Vacuum requisitions have been placed. (SM vendor evaluations are in progress at ANL – Vac system component orders are being processed now)"]
[]
["Undulator System Management and Integration"]
[]
["Past inefficiencies due to CR."]
[]
["During the period from October 06 to April 07 the ANL/LCLS management account accrued 7574 hours.  "]
["Due to insufficient funds to procure any large value Undulator items      (funds became available in late March 07), a significant amount of non-production related management, time was spent re-organizing the effort, cost and schedules while waiting."]
["Two examples of re-directed effort due to lack of funds are described below, one describes re-planning technical systems and the other describes a complete effort re-plan."]
["In October 06 an alternate Vacuum System Strategy was deployed. The plan goals were to keep the team together and evaluate the pros and cons of Stainless V’s Aluminum chamber designs. An evaluation plan was specifically created to help mitigate risks and improve quality of manufacture. A decision to go forward with the Stainless design was made in early March 07. Even though the work was worthwhile it was not in the original plan. "]
["In December 06, a financial “disaster scenario” was envisaged for ANL and all hands (management staff) worked on total re-plan of the cost and schedules associated with keeping only six key FTE’s for the rest of the year."]
["The estimate for the cost associated with dealing with CR related effects has been calculated by taking the total management effort hours from October 06 to April 07, creating an average FTE hourly rate of $100/hr and multiplying it by a production inefficiency factor of 70% (the amount of time associated with dealing with CR related issues) "]
[]
["7574 hrs x $100/hr x 0.7 = $530180 "]
[]
["Magnets and supports"]
["Pre CR Undulator procurements unaffected – see CROB vs. ETC PDF schedules. They include the Undulator Assemblies and the Quad magnets."]
["The estimate for the cost associated with dealing with CR related effects on the Support Mover System has been calculated by taking the total Magnets and Supports hours for effort from October 06 to April 07, creating an average FTE hourly rate of $100/hr and multiplying it by a production inefficiency factor of 35% (70% of 50%)."]
[]
["6987 hrs x $100/hr x .35 = $244545 "]
[]
["Vacuum "]
["Due to the CR no large value procurements were issued until late April 07. This includes chamber materials (stainless steel), vacuum chamber support system, the chamber machining contract and bellows procurement. The vacuum system will be six months late."]
["The estimate for the cost associated with dealing with CR related effects on the Vacuum System has been calculated by taking the total Vacuum System hours for effort from October 06 to April 07, creating an average FTE hourly rate of $100/hr and multiplying it by a production inefficiency factor of 70%. "]
[]
["6441hrs X $100 X 0.7 = $450870   "]
[]
["Diagnostics "]
["BFW"]
[]
["The estimate for the cost associated with dealing with CR related effects on the Beam Finder Wire has been calculated by taking the total hours for effort from October 06 to April 07, creating an average FTE hourly rate of $100/hr and multiplying it by a production inefficiency factor of 90% of the amount of time associated with dealing with CR related issues. "]
[]
["829hrs x $100/hrs x 0.9 = $74610"]
[]
["BPM"]
[]
["The estimate for the cost associated with dealing with CR related effects on the Beam Position Monitor has been calculated by taking the total hours for effort from October 06 to April 07, creating an average FTE hourly rate of $100/hr and multiplying it by a production inefficiency factor of 20% of the amount of time associated with dealing with CR related issues.  Current BPM cost and schedule deficiencies are mostly due to the difficulties associated with design and NOT the CR. If we had had money within the project we would have redirected additional effort to help out with technical problems. For this reason an estimate of 20% inefficiency is allocated to CR     "]
[]
["4575hrs x $100 x 0.2 = $91500"]

{"sheet":"XT-McMahon","index":7,"n_rows":106,"n_cols":17,"rows_kept":106,"cut":false,"hidden":false,"merged":[[0,2,0,13],[1,0,1,1]],"flags":["formulas_cached_only"]}
["WBS #","TASK","Personnel Costs (Man-Months)",{"$nulls":11},"Material Budget","TOTAL"]
["ALL ENTRIES BELOW SUMMARIZE THE CURRENT SCHEDULE/COST SLIP FOR EACH AREA DUE TO THE CR ",null,"Phys-M","Phys","EE","ME-M","ME","DES","Tech","Proc","Cntrl / Prog","Safety","Post-Doc","Admin",null,6712583.333333334]
[{"$nulls":15},1054354.1666666667,"THESE COSTS ARE ALREADY INCURRED (ACTUALS)"]
["1.05.02.0X ","Controls",null,null,0.5,null,null,0.5,null,null,0.5,{"$nulls":4},41250,"Delay in progress due to CR/procurement delays; need to hire more design staff to make up schedule"]
[{"$nulls":15},0]
["1.05.04.02.01 (new?)","Fast Valve",{"$nulls":13},0]
[null,"Delay in Final Design",{"$nulls":5},0.5,{"$nulls":7},10416.666666666666,"Eng/Interface resource not avaiilable during to CR "]
[{"$nulls":15},0]
["1.05.04.02.02","Fixed Mask",{"$nulls":13},0]
[null,"Delay in FDR, Procurement",{"$nulls":5},2,{"$nulls":7},41666.666666666664,"2 mo"]
[null,"Cost inc",{"$nulls":12},2000,2000]
[{"$nulls":15},0]
["1.05.04.02.03","Slit",{"$nulls":13},0]
[null,"Delay in FDR, Procurement",{"$nulls":4},2,2,{"$nulls":7},95000,"2 mo"]
[{"$nulls":15},0]
["1.05.04.02.05","Gas & Solid Attenuator",{"$nulls":13},0]
[null,"Delay in FDR, Procurement",null,null,1,null,2,1,{"$nulls":7},104166.66666666667,"2 mo"]
[null,"Cost inc",{"$nulls":12},0,0,"Cost inc due to proce increases - Do prior to May 15, 2207"]
[{"$nulls":15},0]
["1.05.04.02.06","TTF Damage",{"$nulls":13},0]
[null,"No Impact",{"$nulls":13},0]
[{"$nulls":15},0]
["1.05.04.02.07","Low Energy Mirror System",{"$nulls":13},0]
[null,"Delay in SCR ",null,2,null,null,4,2,{"$nulls":7},206666.66666666666,"Staff and LCLS management unavailable (2 mo); Eng transition"]
[{"$nulls":15},0]
["1.05.04.02.07","High Energy Mirror System",{"$nulls":13},0]
[null,"No Impact",{"$nulls":13},0]
[{"$nulls":15},0]
["1.05.05.02.01","Wave Model",{"$nulls":13},0]
[null,"n/a",{"$nulls":13},0]
[{"$nulls":15},0]
["1.05.05.02.02","Monte Carlo Model",{"$nulls":13},0]
[null,"n/a",{"$nulls":13},0]
[{"$nulls":15},0]
["1.05.05.03.01","Direct Imager",{"$nulls":13},0]
[null,"Delay in procurements",null,null,2,{"$nulls":5},1,{"$nulls":4},91666.66666666667]
[{"$nulls":15},0]
["1.05.05.03.02","Indirect Imager",{"$nulls":13},0]
[null,"n/a",{"$nulls":13},0]
[{"$nulls":15},0]
["1.05.05.03.06 (rename)","Gas Detector",{"$nulls":13},0]
[null,"Delays in procurements for prototype,",null,1,1,null,1,1,1,0.25,null,null,null,0.125,null,135104.1666666667,"More effort (premium) required to make same test date"]
[{"$nulls":15},0]
["1.05.05.04.04 (rename)","Low Energy Spectrometer",{"$nulls":13},0]
[null,"Delay in progress to SCR",{"$nulls":5},0.5,{"$nulls":7},10416.666666666666,"PI not available due to CR activities, System sicientist (Jacek, Dmitri, Mike P.)"]
[{"$nulls":15},0]
["1.05.05.04.05","K-Measurement System",{"$nulls":13},0]
[null,"Delay in progress to SCR",null,0,null,null,null,0,{"$nulls":7},0]
[{"$nulls":15},0]
["1.05.05.04.02","Total Energy Measurement",{"$nulls":13},0]
[null,"Delays in procurements for prototype",null,2,2,{"$nulls":7},2,null,null,148333.33333333334,"Delay in laser & lightbox procurements"]
[{"$nulls":15},0]
["1.05.03.01","Vacuum Systems Engineering",{"$nulls":13},0]
[null,"Configuration Drawing Re-direction",{"$nulls":5},2,{"$nulls":7},41666.666666666664,"Not included in Management section, Configuration re-works for CR"]
[{"$nulls":15},0]
[{"$nulls":15},0]
["1.05.03.02","FEE Mech & Vac ",{"$nulls":13},0]
[null,"Delay in progress to SCR",{"$nulls":5},1,{"$nulls":7},20833.333333333332,"Eng Resiource unavailable due to CR, designer idle/inefficient"]
[{"$nulls":15},0]
["1.05.03.03.01 (rename)","NEH Mech & Vac ",{"$nulls":13},0]
[null,"Delay in progress to SCR",{"$nulls":5},1,{"$nulls":7},20833.333333333332,"Eng Resiource unavailable due to CR, designer idle/inefficient"]
[{"$nulls":15},0]
["1.05.03.04","Tunnel",{"$nulls":13},0]
[null,"Tunnel Procurements push to '08 or '09, Procurement delayed -> atypical price  icreases",{"$nulls":12},8000,8000,"15% on $51K (Atypical price escalation); Procurement \\s pushed out "]
[{"$nulls":15},0]
["1.05.03.05.01","FEH Mech & Vac",{"$nulls":13},0]
[null,"Procurement delayed -> atypical price  icreases",{"$nulls":12},13000,13000,"15% on $85K (Atypical price escalation); Procurement \\s pushed out "]
[{"$nulls":15},0]
["1.05.05.03.08 (new)","FEH Imager",{"$nulls":13},0]
[null,"deleted - no impact",{"$nulls":13},0]
[{"$nulls":15},0]
["2.05.05.02","Modelling",{"$nulls":13},0]
[null,"Delays/re-direction in progress on modeling due to CR uncertainties",{"$nulls":8},2,{"$nulls":4},63333.333333333336,"2*2m-m"]
[{"$nulls":15},0]
{"$rows_empty":29}
["Phys-M","Phys","EE","ME-M","ME","DES","Tech","Proc","Cntrl/Prog","Safety","Post-Doc","Admin"]
[432000,350000,360000,380000,320000,250000,250000,280000,380000,220000,180000,170000]
[36000,29166.666666666668,30000,31666.666666666668,26666.666666666668,20833.333333333332,20833.333333333332,23333.333333333332,31666.666666666668,18333.333333333332,15000,14166.666666666666]

{"sheet":"April CPR Data","index":8,"n_rows":61,"n_cols":17,"rows_kept":61,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["April Controls CPR"]
["Cost Performance Report - Work Breakdown Structure"]
["Contractor:",{"$nulls":4},"Contract Type/No:",null,null,"Project Name/No:",null,"Report Period:"]
["Location:",{"$nulls":7},"April 2007 TPC",null,"2007-03-31",null,"2007-04-30"]
["Quantity","Negotiated Cost",null,"Est. Cost Authorized",null,"Tgt. Profit/",null,"Tgt.","Est","Share","Contract","Estimated Contract"]
[null,null,null,"Unpriced Work",null,"Fee %",null,"Price","Price","Ratio","Ceiling",null,"Ceiling"]
[1,0,null,0,null,0,0,0,0,null,0,0]
["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",null,null,"April ETC"]
[-1,-2,-3,-4,-5,-6,-7,-8,-9,-10,-11,-12,-13,-14]
["1.01 LCLS PROJECT MGMT, PLANNING & ADMN (TEC)",114733,72695,150474,-42039,-77779,6327044,6158776,7957478,-168268,-1798701,7515850,11097673,-3581823,null,null,1357074]
["1.02 INJECTOR SYSTEM",0,168678,121249,168678,47430,3601823,3601823,3592489,0,9335,3697499,5454774,-1757275,null,null,95676]
["1.03 LINAC SYSTEM",486006,97501,174719,-388504,-77218,5663052,2691028,2956284,-2972024,-265256,9170600,9586898,-416298,null,null,6479572]
["1.04 UNDULATOR SYSTEM",142592,53878,56876,-88714,-2998,788431,635576,455204,-152855,180371,3660981,998107,2662874,null,null,3025405]
["1.05 X-RAY TRANSPORT & DIAGNOSTICS SYSTEMS",941319,32566,50761,-908753,-18196,1936717,913005,1059567,-1023711,-146562,2073123,2180344,-107221,null,null,1160118]
["1.06 X-RAY END STATION SYSTEMS",633715,2052,45188,-631663,-43136,2149821,222033,251183,-1927788,-29150,6247610,5997670,249941,null,null,6025577]
["2.01 LCLS PROJECT MGMT, PLANNING & ADMN (OPC)",10453,0,0,-10453,0,164281,15653,58045,-148628,-42392,244110,179188,64922,null,null,228457]
["2.02 INJECTOR SYSTEM (OPC)",715,0,0,-715,0,15373,0,0,-15373,0,15373,15373,0,null,null,15373]
["2.03 LINAC SYSTEM (OPC)",1302,0,729,-1302,-729,94437,0,11967,-94437,-11967,94437,106507,-12070,null,null,94437]
["2.04 UNDULATOR SYSTEM (OPC)",0,0,0,0,0,129614,36739,41028,-92875,-4289,129614,135620,-6005,null,null,92875]
["2.06 X-RAY END STATION SYSTEMS (OPC)",0,0,0,0,0,11279,0,0,-11279,0,645771,38665,607106,null,null,645771]
["Gen. and Admin.",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
["Undist. Budget",{"$nulls":10},0,0,0,null,null,0]
["Sub Total",2330836,427370,599996,-1903466,-172627,20881871,14274633,16383244,-6607238,-2108611,33494968,35790819,-2295851,null,null,19220335]
["Management Resrv.",{"$nulls":10},0,0,0,null,null,0]
["Total",2330836,427370,599996,-1903466,-172627,20881871,14274633,16383244,-6607238,-2108611,33494968,35790819,-2295851]
["April Non-Controls CPR"]
["Cost Performance Report - Work Breakdown Structure"]
["Contractor:",{"$nulls":4},"Contract Type/No:",null,null,"Project Name/No:",null,"Report Period:"]
["Location:",{"$nulls":7},"April 2007 TPC",null,"2007-03-31",null,"2007-04-30"]
["Quantity","Negotiated Cost",null,"Est. Cost Authorized",null,"Tgt. Profit/",null,"Tgt.","Est","Share","Contract","Estimated Contract"]
[null,null,null,"Unpriced Work",null,"Fee %",null,"Price","Price","Ratio","Ceiling",null,"Ceiling"]
[1,0,null,0,null,0,0,0,0,null,0,0]
["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"]
[-1,-2,-3,-4,-5,-6,-7,-8,-9,-10,-11,-12,-13,-14]
["1.01 LCLS PROJECT MGMT, PLANNING & ADMN (TEC)",291126,291126,337563,0,-46437,15028432,15028432,15993265,0,-964833,18013304,20685798,-2672494,null,null,2984872]
["1.02 INJECTOR SYSTEM",37766,20417,-407954,-17350,428371,16615821,16574381,20042069,-41440,-3467688,16759588,22234207,-5474619,null,null,185207]
["1.03 LINAC SYSTEM",760820,134773,698283,-626047,-563510,12086073,10211384,13250040,-1874689,-3038657,19940467,21067655,-1127188,null,null,9729083]
["1.04 UNDULATOR SYSTEM",855007,549766,-691000,-305240,1240767,27153574,24698547,26868256,-2455027,-2169709,37398242,40411136,-3012894,null,null,12699695]
["1.05 X-RAY TRANSPORT & DIAGNOSTICS SYSTEMS",1316725,236680,474384,-1080046,-237705,14476442,11266043,12733155,-3210399,-1467112,22802832,26738268,-3935436,null,null,11536789]
["1.06 X-RAY END STATION SYSTEMS",216009,65942,72297,-150068,-6355,2380423,1819868,1587046,-560555,232822,8734910,9511504,-776595,null,null,6915042]
["1.09 CONVENTIONAL FACILITIES",2724801,4428724,5161756,1703923,-733032,51776831,46926590,48033582,-4850240,-1106992,126602157,48440657,78161500,null,null,79675567]
["2.01 LCLS PROJECT MGMT, PLANNING & ADMN (OPC)",468439,441346,472209,-27093,-30863,9833781,9730800,9791693,-102981,-60893,30194940,34158809,-3963869,null,null,20464140]
["2.02 INJECTOR SYSTEM (OPC)",355224,632467,562696,277244,69771,2613632,1945008,2056970,-668624,-111962,5317454,5909938,-592484,null,null,3372446]
["2.03 LINAC SYSTEM (OPC)",90339,0,29662,-90339,-29662,428374,70511,418196,-357863,-347685,3231740,3659911,-428171,null,null,3161229]
["2.04 UNDULATOR SYSTEM (OPC)",216542,181990,0,-34552,181990,2231171,2180921,724739,-50250,1456182,6852166,4364809,2487357,null,null,4671245]
["2.05 X-RAY TRANSPORT & DIAGNOSTICS SYSTEMS (OPC)",55144,55144,50945,0,4198,927063,870120,814549,-56943,55571,4544490,4874796,-330306,null,null,3674370]
["2.06 X-RAY END STATION SYSTEMS (OPC)",169863,124866,720523,-44997,-595657,1629666,1343573,1343573,-286093,0,5558558,6297523,-738966,null,null,4214985]
["2.09 CONVENTIONAL FACILITIES (OPC)",0,0,0,0,0,0,0,0,0,0,682657,0,682657,null,null,682657]
["Gen. and Admin.",0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,0]
["Undist. Budget",{"$nulls":10},0,0,0,null,null,0]
["Sub Total",7557804,7163240,7481363,-394565,-318124,157181282,142666178,153657133,-14515104,-10990955,306633504,248355011,58278493,null,null,163967326]
["Management Resrv.",{"$nulls":10},0,0,0,null,null,0]
["Total",7557804,7163240,7481363,-394565,-318124,157181282,142666178,153657133,-14515104,-10990955,306633504,248355011,58278493,null,null,163967326]

{"sheet":"CPR by CAM","index":9,"n_rows":114,"n_cols":17,"rows_kept":114,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["April CPR (0704TPC) by WBS Level 1 by CAM (subtotal CAM only)"]
["Cost Performance Report - Work Breakdown Structure"]
["Contractor:",{"$nulls":4},"Contract Type/No:",null,null,"Project Name/No:",null,"Report Period:"]
["Location:",{"$nulls":7},"LCLSTPC - April 2007",null,"2007-03-31",null,"2007-04-30"]
["Quantity","Negotiated Cost",null,"Est. Cost Authorized",null,"Tgt. Profit/",null,"Tgt.","Est","Share","Contract","Estimated Contract"]
[null,null,null,"Unpriced Work",null,"Fee %",null,"Price","Price","Ratio","Ceiling",null,"Ceiling"]
[1,0,null,0,null,0,0,0,0,null,0,0]
["PROJECT WBS[1]","Current Period",{"$nulls":4},"Cumulative to Date",{"$nulls":4},"At Completion"]
["CAM",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"]
[-1,-2,-3,-4,-5,-6,-7,-8,-9,-10,-11,-12,-13,-14,null,null,"APRIL ETC"]
["1 LCLS PROJECT - PED & CONSTRUCTION"]
["   1A Wendy Sisson",291126,291126,337563,0,-46437,15028432,15028432,15993265,0,-964833,18013304,20685798,-2672494,null,null,2984872]
["   2A Jose Chan",760820,137352,274058,-623468,-136705,24721719,22851881,29456433,-1869838,-6604552,32627717,38620809,-5993092,null,null,9775836]
["   2G Hamid Shoaee",743331,392752,503317,-350579,-110565,16380349,13087203,14961455,-3293146,-1874252,24044929,27137452,-3092523,null,null,10957726]
["   2H Gunter Haller",1575034,34618,95950,-1540417,-61332,4086538,1135038,1310750,-2951499,-175712,8320733,8178014,142719,null,null,7185695]
["   2L Bill White",47511,34848,16271,-12663,18577,4199152,4101079,3835677,-98073,265402,5634936,6666508,-1031572,null,null,1533857]
["   4A Geoff Pile",674225,375611,-942656,-298614,1318267,22113876,20502711,21247964,-1611165,-745253,29502181,29908307,-406126,null,null,8999470]
["   4B Rod Pope",180782,174155,251656,-6626,-77501,5039698,4195836,5620292,-843862,-1424456,7896061,10502829,-2606768,null,null,3700225]
["   5A Donn McMahon",1316725,236680,474384,-1080046,-237705,14476442,11266043,12733155,-3210399,-1467112,22802832,26738268,-3935436,null,null,11536789]
["   6A Stefan Moeller",206264,48931,72297,-157334,-23366,2161446,1652672,1587046,-508773,65627,7172312,7526049,-353738,null,null,5519640]
["   9A David Saenz",2724801,4428724,5161756,1703923,-733032,51776831,46926590,48033582,-4850240,-1106992,126602157,48440657,78161500,null,null,79675567]
["2 LCLS PROJECT - R&D, SPARES, COMMISSIONING",{"$nulls":15},0]
["   1A Wendy Sisson",282391,262335,275504,-20056,-13168,5021093,4950757,4603487,-70336,347270,21000390,22777969,-1777579,null,null,16049633]
["   2A Jose Chan",26570,0,12433,-26570,-12433,715139,699896,756757,-15243,-56861,1557286,1115916,441370,null,null,857390]
["   2G Hamid Shoaee",12470,0,729,-12470,-729,403706,52392,111039,-351314,-58647,483535,436688,46847,null,null,431143]
["   2H Gunter Haller",0,0,0,0,0,11279,0,0,-11279,0,645771,38665,607106,null,null,645771]
["   2L Bill White",49425,0,19284,-49425,-19284,528538,222105,198554,-306433,23550,733109,748604,-15495,null,null,511004]
["   2S Dave Schultz",555616,811478,757346,255861,54132,6611017,5873561,6700236,-737456,-826675,15453350,19078346,-3624996,null,null,9579789]
["   2T Hal Tompkins",0,0,0,0,0,0,0,0,0,0,1678278,1674437,3841,null,null,1678278]
["   4A Geoff Pile",213243,181166,0,-32078,181166,2190863,2150509,666400,-40354,1484109,5865525,3346992,2518533,null,null,3715016]
["   4B Rod Pope",3299,825,0,-2474,825,40308,30412,58340,-9896,-27927,986641,1017818,-31177,null,null,956229]
["   5A Donn McMahon",55144,55144,50945,0,4198,927063,870120,814549,-56943,55571,4544490,4874796,-330306,null,null,3674370]
["   6A Stefan Moeller",169863,124866,720523,-44997,-595657,1629666,1343573,1343573,-286093,0,3880280,4623087,-742807,null,null,2536707]
["   9A David Saenz",0,0,0,0,0,0,0,0,0,0,682657,0,682657,null,null,682657]
["Gen. and Admin.",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Undist. Budget",{"$nulls":10},0,0,0]
["Sub Total",9888640,7590610,8081360,-2298030,-490750,178063153,156940811,170032553,-21122342,-13091742,340128472,284138006,55990466]
["Management Resrv.",{"$nulls":10},0,0,0]
["Total",9888640,7590610,8081360,-2298030,-490750,178063153,156940811,170032553,-21122342,-13091742,340128472,284138006,55990466]
[]
[]
[]
[]
[]
[]
["CRFN CAP by WBS Level 1 and by CAM (subtotal CAM only)"]
["PROJECT WBS[1]","CAM",null,"FY02","FY03","FY04","FY05","FY06","FY07","FY08","FY09","FY10","FY11","FY12","Cumulative"]
["1 LCLS PROJECT - PED & CONSTRUCTION"]
[null,"1A Wendy Sisson","BCWS",0,0,0,0,0,1475483,3294786,2462168,855496,0,0,8087933,null,8087933]
[null,"2A Jose Chan","BCWS",0,0,0,0,0,6241848,5126222,365959,103525,0,0,11837554,null,11837554]
[null,"2G Hamid Shoaee","BCWS",0,0,0,0,0,8484521,3090548,283482,89696,0,0,11948248,null,11948248]
[null,"2H Gunter Haller","BCWS",0,0,0,0,0,1233570,5287847,1969656,487426,0,0,8978499,null,8978499]
[null,"2L Bill White","BCWS",0,0,0,0,0,393270,1156239,111780,0,0,0,1661290,null,1661290]
[null,"4A Geoff Pile","BCWS",0,0,0,0,0,4762439,6116081,58747,62796,0,0,11000063,null,11000063]
[null,"4B Rod Pope","BCWS",0,0,0,0,0,1771794,2121560,309051,0,0,0,4202405,null,4202405]
[null,"5A Donn McMahon","BCWS",0,0,0,0,0,4944680,5705466,2167037,230421,0,0,13047605,null,13047605]
[null,"6A Stefan Moeller","BCWS",0,0,0,0,0,512899,3039036,1981190,105095,0,0,5638220,null,5638220]
[null,"9A David Saenz","BCWS",0,0,0,0,0,38858380,33683469,8084829,135842,0,0,80762519,null,80762519]
["2 LCLS PROJECT - R&D, SPARES, COMMISSIONING",{"$nulls":15},0]
[null,"1A Wendy Sisson","BCWS",0,0,0,0,0,1782453,3973343,3961860,3414898,0,0,13132555,null,13132555]
[null,"2A Jose Chan","BCWS",0,0,0,0,0,115731,725702,446545,0,0,0,1287978,null,1287978]
[null,"2G Hamid Shoaee","BCWS",0,0,0,0,0,249853,78319,98785,0,0,0,426958,null,426958]
[null,"2H Gunter Haller","BCWS",0,0,0,0,0,244225,769958,0,0,0,0,1014184,null,1014184]
[null,"2L Bill White","BCWS",0,0,0,0,0,502609,7059,0,0,0,0,509668,null,509668]
[null,"2S Dave Schultz","BCWS",0,0,0,0,0,2342127,6583716,1901164,0,0,0,10827007,null,10827007]
[null,"2T Hal Tompkins","BCWS",0,0,0,0,0,0,0,2415893,1973038,0,0,4388931,null,4388931]
[null,"4A Geoff Pile","BCWS",0,0,0,0,0,200736,1901562,7469341,0,0,0,9571639,null,9571639]
[null,"4B Rod Pope","BCWS",0,0,0,0,0,0,0,340271,0,0,0,340271,null,340271]
[null,"5A Donn McMahon","BCWS",0,0,0,0,0,276019,337531,0,1112199,0,0,1725749,null,1725749]
[null,"6A Stefan Moeller","BCWS",0,0,0,0,0,483602,1589636,307842,213818,0,0,2594899,null,2594899]
[null,"9A David Saenz","BCWS",0,0,0,0,0,379872,696583,0,0,0,0,1076455,null,1076455]
["Grand Totals:",{"$nulls":15},0]
[null,null,"BCWS",0,0,0,0,0,75256113,85284663,34735602,8784252,0,0,204060629,null,204060629]
[]
[{"$nulls":16},22453853]
[{"$nulls":16},10233431]
[]
["CRFN CAP by WBS Level 2 (No Controls) for WBS Summary sheet"]
["PROJECT WBS[2]",null,"FY02","FY03","FY04","FY05","FY06","FY07","FY08","FY09","FY10","FY11","FY12","Cumulative"]
["1.01 LCLS PROJECT MGMT, PLANNING & ADMN (TEC)","BCWS",0,0,0,0,0,1475483,3294786,2462168,855496,0,0,8087933]
["1.02 INJECTOR SYSTEM","BCWS",0,0,0,0,0,89607,51682,0,0,0,0,141289]
["1.03 LINAC SYSTEM","BCWS",0,0,0,0,0,6241848,5126222,365959,103525,0,0,11837554]
["1.04 UNDULATOR SYSTEM","BCWS",0,0,0,0,0,6534232,8237641,367799,62796,0,0,15202468]
["1.05 X-RAY TRANSPORT & DIAGNOSTICS SYSTEMS","BCWS",0,0,0,0,0,4944680,5705466,2167037,230421,0,0,13047605]
["1.06 X-RAY END STATION SYSTEMS","BCWS",0,0,0,0,0,816562,4143593,2092971,105095,0,0,7158221]
["1.09 CONVENTIONAL FACILITIES","BCWS",0,0,0,0,0,38858380,33683469,8084829,135842,0,0,80762519]
["2.01 LCLS PROJECT MGMT, PLANNING & ADMN (OPC)","BCWS",0,0,0,0,0,3022268,6713202,5863024,3414898,0,0,19013392]
["2.02 INJECTOR SYSTEM (OPC)","BCWS",0,0,0,0,0,1720653,1744946,446545,0,0,0,3912144]
["2.03 LINAC SYSTEM (OPC)","BCWS",0,0,0,0,0,0,2831672,0,0,0,0,2831672]
["2.04 UNDULATOR SYSTEM (OPC)","BCWS",0,0,0,0,0,200736,1901562,7809612,0,0,0,9911910]
["2.05 X-RAY TRANSPORT & DIAGNOSTICS SYSTEMS (OPC)","BCWS",0,0,0,0,0,276019,337531,0,1112199,0,0,1725749]
["2.06 X-RAY END STATION SYSTEMS (OPC)","BCWS",0,0,0,0,0,483602,1589636,2723735,2186856,0,0,6983830]
["2.09 CONVENTIONAL FACILITIES (OPC)","BCWS",0,0,0,0,0,379872,696583,0,0,0,0,1076455]
["Grand Totals:"]
[null,"BCWS",0,0,0,0,0,65043944,76057990,32383679,8207129,0,0,181692741]
[]
["CRFN CAP by WBS Level 2 (Controls Only) for WBS Summary sheet"]
["PROJECT WBS[2]",null,"FY02","FY03","FY04","FY05","FY06","FY07","FY08","FY09","FY10","FY11","FY12","Cumulative"]
["1.01 LCLS PROJECT MGMT, PLANNING & ADMN (TEC)","BCWS",0,0,0,0,0,721726,376707,275015,89696,0,0,1463145]
["1.02 INJECTOR SYSTEM","BCWS",0,0,0,0,0,92257,3211,0,0,0,0,95468]
["1.03 LINAC SYSTEM","BCWS",0,0,0,0,0,5646691,1493563,0,0,0,0,7140254]
["1.04 UNDULATOR SYSTEM","BCWS",0,0,0,0,0,2023847,1217066,8467,0,0,0,3249380]
["1.05 X-RAY TRANSPORT & DIAGNOSTICS SYSTEMS","BCWS",0,0,0,0,0,148770,1053613,266887,69087,0,0,1538356]
["1.06 X-RAY END STATION SYSTEMS","BCWS",0,0,0,0,0,1084800,4234234,1702769,418339,0,0,7440142]
["2.01 LCLS PROJECT MGMT, PLANNING & ADMN (OPC)","BCWS",0,0,0,0,0,148104,71185,0,0,0,0,219289]
["2.02 INJECTOR SYSTEM (OPC)","BCWS",0,0,0,0,0,13540,1829,0,0,0,0,15370]
["2.03 LINAC SYSTEM (OPC)","BCWS",0,0,0,0,0,88209,5305,0,0,0,0,93514]
["2.04 UNDULATOR SYSTEM (OPC)","BCWS",0,0,0,0,0,0,0,98785,0,0,0,98785]
["2.06 X-RAY END STATION SYSTEMS (OPC)","BCWS",0,0,0,0,0,244225,769958,0,0,0,0,1014184]
["Grand Totals:"]
[null,"BCWS",0,0,0,0,0,10212169,9226673,2351923,577123,0,0,22367887]