{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet1","Pick List "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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"}

{"sheet":"Sheet1","index":0,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[12,1,18,8],[0,0,0,10],[4,4,4,5],[2,4,2,5],[2,6,2,7],[4,6,4,7],[3,6,3,7],[2,2,2,3]]}
["Corrective Action Plan (CAP)"]
[]
[null,"Site Name: ",null,null,"FIMS Administrator:  ",null,null,null,"Date CAP Opened:"]
[]
[null,null,null,null,null,null,null,null,"Date CAP Closed:"]
[]
[]
[null,"Scorecard ","Data Element ","Rating","Subject Matter Expert and Contact Information ","Validation Date","Planned Date to Mitigate ","Actual Date  Mitigated ","Explain Data Issue","Explain Corrective Action","Cause of Issue"]
["EXAMPLE ","Owned ",null,"Red","Will Smith, will.smith@hq.doe.gov   555-555-5555","2020-04-06","2020-10-21","2020-12-12","EXAMPLE:   Site did not conduct the Annual Utilization Survey for 10 assets ","EXAMPLE:  Site will review why these 10 assets did not have a Utilization Survey.  Site will update process after findings to ensure the utilization survey is conducted on all assets ","EXAMPLE: Discovered the zone manager for these 10 assets did not turn in his paperwork to the SME "]
[]
[]
[]
[null,"Instructions:  \n1.  Fill in the Site Name, FIMS Administrator, and Date CAP Opened at the top of this form.\n2.  Click the Click to Add Line button to insert a row.  Select the Scorecard, Data Element and Rating for the data element that has data problems from the picklists.\n3.  Enter the Subject Matter Expert, Validation Date, Planned Date to Mitigate, Explain Data Issue, and Explain Corrective Action.   \n4.  Send to your Site/Field Office, Headquarters Program Office and Adam Pugh, MA-50 (adam.pugh@hq.doe.gov) within 15 days of the completion of your Validation.\n5.  Once mitigated, complete Date CAP Closed, Actual Date Mitigated and Cause of Issue.  Resend completed CAP to contacts listed in #4 above.\n6.  Only one CAP should exists per Site/HQ Program Office (HQ PO).  If an open CAPS exists, please add to it.  Do not create multiple CAPS per Site/HQ PO or fiscal year."]

{"sheet":"Pick List ","index":1,"n_rows":46,"n_cols":13,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
[]
["List of All FIMS data elements that are Validated in FY2022",null,"list of Scorecard Types ","Date Element Color"]
["Actual Sales Price (Archived data)",null,"Owned ","Red",null,"Disposition Data Elements",null,"Land Data Elements",null,"Leased Data Elements",null,"Owned Data Elements","Bridge"]
["Adjustment Cost",null,"Leased ","Yellow",null,"Actual Sales Price",null,"Annual Rent - Lease",null,"Annual Actual Maintenance",null,"Adjustment Cost","Bridge  - Load Rating Date"]
["Annual Actual Maintenance",null,"Land ",null,null,"Disposition Date",null,"Estimated Disposition Year",null,"Annual Rent - Lease",null,"Annual Actual Maintenance","Bridge - No of Lanes on Structure"]
["Annual Rent - Lease",null,"Disposition ",null,null,"Disposition Method",null,"Excess Date",null,"Annual Required Maintenance",null,"Annual Required Maintenance","Bridge  - Posted Load Rating/Restrictions"]
["Annual Required Maintenance",null,"Bridge",null,null,"Excess Date",null,"Excess Indicator",null,"Asset % Utilized",null,"Asset % Utilized","Bridge  - Routine Inspection Date"]
["Asset % Utilized",null,null,null,null,"Excess Indicator",null,"Expiration Date - Lease",null,"Estimated Disposition Year",null,"Capitalized - Adjustment","Bridge  - Routine Inspection Frequency"]
["Beneficial Occupancy Year",null,null,null,null,"Net Proceeds",null,"GSA Notification - Accepted",null,"Expiration Date - Lease",null,"Deferred Maintenance ","Bridge  - Scour Critical Plan of Action"]
["Capitalized - Adjustment",null,null,null,null,null,null,"GSA Notification – Submitted",null,"Functionality Assessment Date",null,"Estimated Disposition Year","Bridge  - Scour Evaluation"]
["Deferred Maintenance ",null,null,null,null,null,null,"Historic Designation",null,"Inspection Date",null,"Excess Date","Bridge  - Seismic Vulnerability Evaluation"]
["Disposition Date (Archived data)",null,null,null,null,null,null,"Lease Start Date",null,"Lease Start Date",null,"Excess Indicator","Bridge  - Size"]
["Disposition Method (Archived data)",null,null,null,null,null,null,"Outgrant Indicator",null,"Modernization Cost",null,"Functionality Assessment Date","Bridge  - Special Inspection Frequency"]
["Estimated Disposition Year",null,null,null,null,null,null,"Ownership",null,"Outgrant Indicator",null,"GSA Notification - Accepted","Bridge  - Special Inspection Date"]
["Excess Date (Current and Archived Data)",null,null,null,null,null,null,"Property Type",null,"Overall Asset Condition",null,"GSA Notification – Submitted","Bridge  - Status"]
["Excess Indicator (Current and Archived Data)",null,null,null,null,null,null,"Size",null,"Ownership",null,"Historic Designation","Bridge  - Traffic Volume Date"]
["Expiration Date - Lease",null,null,null,null,null,null,"Status",null,"Property Type",null,"Inspection Date","Bridge  - Underwater Inspection Frequency"]
["Functionality Assessment Date",null,null,null,null,null,null,"Usage Code",null,"Repair Needs",null,"Location - City ","Bridge  - Underwater Inspection Date"]
["GSA Notification - Accepted",null,null,null,null,null,null,null,null,"Replacement Plant Value ",null,"Location - State ","Bridge  - Usage Code"]
["GSA Notification – Submitted",null,null,null,null,null,null,null,null,"Size",null,"Location - Zip Code ","Bridge  - Year Built"]
["Historic Designation",null,null,null,null,null,null,null,null,"Space Type Usable SF - Office",null,"Main Location "]
["Inspection Date",null,null,null,null,null,null,null,null,"Status",null,"Modernization Cost"]
["Lease Start Date",null,null,null,null,null,null,null,null,"Sustainability",null,"No of Floors"]
["Location - City ",null,null,null,null,null,null,null,null,"Sustainability - System Used",null,"Operating Cost (Site Level)"]
["Location - State ",null,null,null,null,null,null,null,null,"Sustainability - Date Certified",null,"Outgrant Indicator"]
["Location - Zip Code ",null,null,null,null,null,null,null,null,"Total No of Contractor Employees",null,"Overall Asset Condition"]
["Main Location ",null,null,null,null,null,null,null,null,"Total No of Federal Employees",null,"Ownership"]
["Modernization Cost",null,null,null,null,null,null,null,null,"Usage Code",null,"Property Type"]
["Net Proceeds (Archived data)",null,null,null,null,null,null,null,null,null,null,"Repair Needs"]
["No of Floors",null,null,null,null,null,null,null,null,null,null,"Replacement Plant Value "]
["Operating Cost (Site Level)",null,null,null,null,null,null,null,null,null,null,"Size"]
["Outgrant Indicator",null,null,null,null,null,null,null,null,null,null,"Space Type Usable SF - Office"]
["Overall Asset Condition",null,null,null,null,null,null,null,null,null,null,"Status"]
["Ownership",null,null,null,null,null,null,null,null,null,null,"Sustainability"]
["Property Type",null,null,null,null,null,null,null,null,null,null,"Sustainability - System Used"]
["Repair Needs",null,null,null,null,null,null,null,null,null,null,"Sustainability - Date Certified"]
["Replacement Plant Value ",null,null,null,null,null,null,null,null,null,null,"Total No of Contractor Employees"]
["Size",null,null,null,null,null,null,null,null,null,null,"Total No of Federal Employees"]
["Space Type Usable SF - Office",null,null,null,null,null,null,null,null,null,null,"Usage Code"]
["Status",null,null,null,null,null,null,null,null,null,null,"Walkthroughs - Existing Asset Check "]
["Sustainability",null,null,null,null,null,null,null,null,null,null,"Year Built"]
["Total No of Contractor Employees"]
["Total No of Federal Employees"]
["Usage Code"]
["Walkthroughs - Existing Asset Check "]
["Year Built"]