{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["CABR Template"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":1,"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":"CABR Template","index":0,"n_rows":158,"n_cols":14,"rows_kept":158,"cut":false,"hidden":false,"merged":[[12,2,12,4],[3,1,3,6],[4,1,4,6],[5,1,5,6],[10,2,10,4],[11,2,11,4],[158,1,158,6],[13,2,13,4],[16,3,16,4],[17,3,17,4],[147,1,148,6],[155,1,155,6],[18,3,18,4]],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"U.S. Department of Energy"]
[null," Report of Contractor Expenditures for Employee Supplemental Compensation"]
[null," Compensation & Benefits Profile Report for Calendar Year 2014"]
[]
[null,"                                      Status: Date Submitted ",null,"(DD/MM/YY)"]
[null,"                                     Status: Date Approved",null,"(DD/MM/YY)"]
[null,"Enter or select data in cells with yellow background.",{"$nulls":7},"Enter the Field Office","Enter the Facility (Site)","Enter the Contractor ","Enter the Contract Number","Yes or No"]
[null,"Field Office",{"$nulls":7},"CH - Chicago Operations Office","AMEX - Ames Lab","ASE - Alliance for Sustainable Energy, LLC","AC02-06H11357  ","Yes"]
[null,"Facility (Site)",{"$nulls":7},"CRL - Carlsbad Field Office","ANLEAST - Argonne National Lab - East","ATL - Advanced Technologies & Laboratories","AC02-76SF00515  ","No"]
[null,"Contractor",{"$nulls":7},"EMCBC - EMCBC (Cincinnati, Ohio)","BAPL - NR Bettis Atomic Power Lab - NRFLO","B&W Pantex - B&W Technical Services Pantex, LLC","AC02-98CH10886  ",""]
[null,"Contract Number:",{"$nulls":7},"GFO - Golden Field Office","BNL - Brookhaven National Lab","B&W-Y12 - B&W Technical Services Y-12","AC03-76SF00098  ",""]
[{"$nulls":9},"ID - Idaho Operations Office","ETTP - East Tennessee Tech Park (fmr K-25, ORGDP)","BATTELLE-EA - Battelle Energy Alliance, LLC","AC04-00AL66620  ",""]
[null,"PART ONE - EMPLOYMENT PER CONTRACT - IF FULL YEAR ENTER 52 WEEKS OTHERWISE ENTER NUMBER OF WEEKS BELOW",{"$nulls":7},"NNSA","FERMI - Fermi National Acceleration Lab","BATTELLE-PNL - Battelle Memorial Institute","AC04-01AC66444  ",""]
[null,"Number of Employees","No.  of Employees","Enter Number of Weeks or 52 below",{"$nulls":5},"NRLFO - Naval Reactors Laboratory FO","HAN-ORP - Hanford Site (ORP)","BMPC - Bechtel Marine Propulsion Corporation","AC04-01AL66850  ",""]
[null,"Exempt:",{"$nulls":7},"NV - Nevada Site Office","HANSITE - Hanford Site (RL)","BNL - Brookhaven Science Associates","AC04-94AL85000  ",""]
[null,"Bargaining Unit:",null,"    If Contract Less than a Year Enter Start Date and/or End Date Below",{"$nulls":5},"OAK - Oakland Operations Office","INL - Idaho National Lab","BWCS - Babcock & Wilcox Conversion Services","AC05-00OR22690  ",""]
[null,"Nonexempt Nonbargaining Unit:",null,"Start Date:",{"$nulls":5},"OR - Oak Ridge Office","JNL - Jefferson National Laboratory","CH2MHIL - CH2M Hill Hanford Group","AC05-00OR22725  ",""]
[null,"Total Employees (Not Retired)",0,"Finish Date:",{"$nulls":5},"ORP - Office of River Protection (Richland)","KAPL-NR - Knolls Atomic Power Lab - NRLFO","CH2M-WG - CH2M - Washington Group, LLC","AC05-00OR22750  ",""]
[{"$nulls":9},"PPPO -Portsmouth Paducah Proj Office","KCPlant - Kansas City Plant","CHPRC - CH2M Hill Plateau Remediation Company","AC05-00OR22800  ",""]
[null,"Retirees:",0,{"$nulls":6},"RL - Richland Operations Office","LANL - Los Alamos National Lab","CHW-WV - CHBW West Valley","AC05-06OR23177  ",""]
[{"$nulls":9},"SPRO - Strategic Petroleum Reserve Office","LBNL - Lawrence Berkley Nat'l Lab","CNS - Consolidated Nuclear Security, LLC","AC05-76RL01830  ",""]
[null,"PART TWO - GROSS PAY",{"$nulls":7},"SR - Savannah River Operations Office","LLNL - Lawrence Livermore National Lab","DPOC - DM Petroleum Operations Co","AC06-05RL14655  ",""]
[null,"Types of Expenditure","Total"," Bargaining","Total Nonbarg","Exempt","Non Exempt",null,null,null,"NEV - Nevada Field Office","FBP - Fluor-B&W Portsmouth","AC06-08RL14788  ",""]
[null,"Gross Payroll",0,0,0,0,0,null,null,null,"Nevada National Security Site","FERMI - Fermi Research Alliance","AC06-99RL14047  ",""]
[null," Annual Base Pay",0,0,0,0,0,null,null,null,"NREL - National Renewable Energy Lab","HONEYWELL - Honeywell FM&T LLC","AC07-05ID14516  ",""]
[null,"  Straight-Time Pay Worked:",0,null,0,{"$nulls":5},"NRF-NR - Naval Reactors Facility - NRLFO (Idaho)","ISU - Iowa State University","AC07-05ID14517  ",""]
[null,"  Paid-Time off:",0,0,0,0,0,null,null,null,"ORCMPLX - Oak Ridge Complex-Wide","ITG - Idaho Treatment Group (AMWTP)","AC27-05RV14548  ",""]
[null,"    Vacation Pay",0,null,0,{"$nulls":5},"ORISE - Oak Ridge Inst for Science & Education","JSA - Jefferson Science Assoc. LLC","AC27-08RV14800  ",""]
[null,"    Vacation Pay in Lieu:",0,null,0,{"$nulls":5},"ORNL- Oak Ridge National Lab","LANS - Los Alamos National Security LLC","AC30-10CC40021  ",""]
[null,"    Holiday Pay:",0,null,0,{"$nulls":5},"PADUCAH - Paducah Site","LATA-KY - LATA Environmental Services of KY","AC52-06NA14390  ",""]
[null,"    Holiday Pay in Lieu:",0,null,0,{"$nulls":5},"PANTEX - Pantex Plant","LLNS - Lawrence Livermore National Security, LLC","AC52-06NA25946  ",""]
[null,"    Sick Leave Pay:",0,null,0,{"$nulls":5},"PNNL - Pacific Northwest National Lab-OR","LM-SNL - Lockheed Martin - Sandia Corp","DC-AC-96-03PO92207",""]
[null,"    Personal Leave Bank:",0,null,0,{"$nulls":5},"PORTS - Portsmouth","MSA - Mission Support Alliance","DE-AC02-07CH11358  ",""]
[null,"    Personal Leave Pay:",0,null,0,{"$nulls":5},"PPPL - Princeton Plasma Physics Lab","NSPS - National Security Protective Services","DE-AC02-07CH11359  ",""]
[null,"    Parental Leave:",0,null,0,{"$nulls":5},"SLAC-OR - SLAC National Accelerator Laboratory","NSTec - National Security Technologies","DE-AC02-09CH11466  ",""]
[null,"    Supplemental Pay:",0,null,0,{"$nulls":5},"SNL - Sandia National Labs","NWP - Nuclear Waste Partnership","DE-AC05-00OR22800  ",""]
[null,"    Other Paid Leave Pay:",0,null,0,{"$nulls":5},"SPRO - Strategic Petroleum Reserves","ORAU-OR - Oak Ridge Associated Universities Inc","DE-AC06-09RL14728  ",""]
[null,"   Overtime Pay:",0,0,0,0,0,null,null,null,"SRPLANT - Savannah River Plant","PRINCETON - Princeton University","DE-AC09-08SR22470  ",""]
[null,"    Straight Time Portion:",0,null,0,0,{"$nulls":4},"WIPPC - Waste Isolation Pilot Plant - Carlsbad","Sandia Corp. - Lockheed Martin - Sandia Corp","DE-AC09--0SR22505  ",""]
[null,"    Premium Portion:",0,null,0,0,{"$nulls":4},"WVAL - EM - West Valley Demonstration","SRNS LLC - Savannah River Nuclear Solutions LLC","DE-AC30-10CC40017  ",""]
[null,"Types of Expenditure","Total"," Bargaining","Total Nonbarg","Exempt","Non Exempt",null,null,null,"Y-12 - Y-12 Plant","SRR - Savannah River Remediation","DE-AC30-10CC40020  "]
[null,"   Severance Pay:",0,0,0,0,0,null,null,null,"Not Listed?  Please enter to the right","SST - Swift & Staley Team - PPPO","DE-AC30-10CC60025  ",""]
[null,"   Other Pay:",0,0,0,0,0,{"$nulls":4},"SU-SLAC - Stanford University","DE-AC30-11CC40015  ",""]
[null,"    Shift Differential:",0,null,0,{"$nulls":6},"UCHICAGO-ARGN - Univ Chicago Argonne, LLC","DE-AC36-08GO28308  ",""]
[null,"    Lump Sum Payment:",0,null,0,{"$nulls":6},"UC-LBNL - University of California","DE-AC52-06NA25396  ",""]
[null,"    Performance Incentive Compensation:",0,null,0,{"$nulls":6},"UCOR - URS/CH2M Oak Ridge LLC","DE-AC52-07NA27344  ",""]
[null,"    Cash Award:",0,null,0,{"$nulls":6},"UT-BATTELLE - Univ of Tennessee - Battelle","DE-AC96-03PO92207  ",""]
[null,"    Non Performance-Based Bonuses:",0,null,0,{"$nulls":6},"WA TRUC - Washington TRU Solutions - Carlsbad","DE-CI0000004  ",""]
[null,"    Facility Closing Retention Bonus:",0,null,0,{"$nulls":6},"WACKENHUT - Wackenhut Services Inc","DE-EM 0001467  ",""]
[null,"    Voluntary Separation Bonus:",0,null,0,{"$nulls":6},"WACK-NV - Wackenhut Nevada Services","DE-EM0001529  ",""]
[null,"    Relocation/Housing Allowance-Direct:",0,null,0,{"$nulls":6},"WACK-SR - Wackenhut Services Inc.","DE-NA0000622",""]
[null,"    Relocation/Housing Allowance-Other:",0,null,0,{"$nulls":6},"WCH- Washington Closure Company, LLC","DE-NA0001942",""]
[null,"    Remote/Isolation Pay:",0,null,0,{"$nulls":6},"WEMS - Wastren Energ-X Mission Support","DE-NR0000031  ",""]
[null,"    Hazard Duty Pay:",0,null,0,{"$nulls":6},"WRPS - Washington River Protection Solutions","DE-SC-0004645  ",""]
[null,"    Expatriate Allowance:",0,null,0,{"$nulls":6},"Not Listed?  Please enter to the right","DE-SC0007895",""]
[null,"    Education Allowance-Pay:",0,null,0,{"$nulls":7},"DE-SC-0007895",""]
[null,"    Other Overtime Payment:",0,null,0,{"$nulls":7},"Not Listed?  Please enter to the right"]
[null,"    Geographic Differential Pay:",0,null,0]
[null,"    Dependent Care:",0,null,0]
[null,"    Miscellaneous (MISC). Compensation:",0,null,0]
[]
[null,"PART TWO - LEGAL REQUIRED","Total"," Bargaining"]
[null,"Legally Required Insurance:",0,0]
[null,"   Social Security:"]
[null,"   Other Retirement Insurance:"]
[null,"   Unemployment:",0,0]
[null,"     Unemployment - Federal:"]
[null,"     Unemployment - State:"]
[null,"   Occupational Injury & Illness:",0,0]
[null,"    Workers' Compensation:"]
[null,"    Benefits Under EEOICPA - Subtitle D:"]
[null,"    Other Legacy Benefits / Health Studies: "]
[null,"    Other Legally Required Insurance:"]
[]
[null,"PART TWO LIFE/DEATH","Total"," Bargaining"]
[null,"Life/Death Benefits:",0,0]
[null,"   Life Insurance:"]
[null,"  Death Benefits:"]
[]
[null,"PART TWO - MEDICAL","Total"," Bargaining"]
[null,"Medical/Medically Related:",0,0]
[null,"   Insured Active Medical - Including Prescription Drugs:"]
[null,"   Self-Insured Active Medical - Including Prescription Drugs:"]
[null,"   Dental Active:"]
[null,"   Vision Active:"]
[null,"   Misc. Medical Active:"]
[null,"   Insured Retiree Medical - Including Prescription Drugs:"]
[null,"   Self-Insured Retiree Medical - Including Prescripton Drugs:"]
[null,"   Dental-Retiree:"]
[null,"   Vision Retiree:"]
[null,"   Misc. Medical-Retiree:"]
[null,"   Short-Term Disability:"]
[null,"   Long-Term Disability:"]
[null,"   Displaced Worker:"]
[null,"PART TWO - RETIREMENT","Total"," Bargaining"]
[null,"Retirement:",0,0]
[null,"    Defined Contribution, Employer Contribution:"]
[null,"    Defined Benefit, Employer Contribution:"]
[null,"    Disbursements:"]
[null,"    Expenses:"]
[null,"PART TWO - OTHER","Total"," Bargaining"]
[null,"Other:",0,0]
[null,"    Vacation/Holiday Funds:"]
[null,"    Dependent Care:"]
[null,"    Employee Assistance Program:"]
[null,"    Misc. Benefits:"]
[]
[]
[null,"PART THREE - PAID HOURS","Total"," Bargaining","Total Nonbarg","Exempt","Non Exempt"]
[null,"Paid Hours",0,0,0,0,0]
[null,"  Straight Hours",0,null,0]
[null,"  Overtime Hours",0,null,0]
[null,"  Premium Hours",0,null,0]
[null,"  Vacation Hours",0,null,0]
[null,"  Holiday Hours",0,null,0]
[null,"  Sick Leave Hours",0,null,0]
[null,"  Personal Leave Bank Hours",0,null,0]
[null,"  Personal Leave Hours",0,null,0]
[null,"  Other Paid Leave Hours",0,null,0]
[null,"  Average Hours per Week",41.25]
[]
[]
[null,"PART FOUR - HEALTH CARE PLANS"]
[null,"1. Indicate whether the employer (contractor) provides a flexible benefits program by entering a Yes or No"]
[]
[]
[null,"2. Provide the number of medical plans by category (If a type of medical plan is not provided, enter \"0.\"  This field must not be blank:"]
[null," Group Indemnity Health Insurance"]
[null," Health Maintenance Organization (HMO)"]
[null," Preferred Provider Organization ( PPO)"]
[null," Point of Service Plan (POS)"]
[null," Consumer Driven Health Plan (CDHP)"]
[null," Other"]
[]
[]
[null,"3. Provide the percentage of contribution the employees required to contribute to any medical plan(s) provided by employer (contractor)."]
[null,"Use an average percentage if contributions vary among multiple plans.  Include both bargaining and nonbargaining in your average."]
[null,"  Percent Active Single"]
[null,"  Percent Active Family"]
[]
[null,"4. Provide the percentage the retirees are required to contribute to any medical Plan(s) provided by the Employer (contractor).  "]
[null,"Use an average percentage of contributions vary among multiple plans."]
[null,"  Percent Under 65 Retiree"]
[null,"  Percent 65 & Older Retiree"]
[null,"5. Provide the number of retirees who are enrolled in a Retiree Medical Plan (exclude spouse and/or dependents)."]
[]
[null,"  Retirees in Medical Plan Under 65:"]
[null,"  Retirees in Medical Plans 65 and older"]
[]
[null,"PART FIVE -"]
[null,"Comments:"]
[null,"Misc. Benefits include Health Care Spending Account, Match, FMLA Salary Continuance & FMLA Illness. "]
[]
[]
[null,"Methodology:  Place Methodology Here;"]