{"text_format":"2","workbook":"xls","n_sheets":4,"sheets":["OMB","WBS","EVA","PMT Narratives"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":11,"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":"OMB","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"WBS","index":1,"n_rows":57,"n_cols":11,"rows_kept":57,"cut":false,"hidden":false,"merged":[[7,10,7,11],[0,0,0,8],[1,0,1,8],[2,10,2,11],[5,10,5,11]],"flags":["formulas_cached_only"]}
["Environmental Public Health Tracking's goal is to improve environmental health surveillance nationally and locally to better identify and mitigate health effects resulting from environmental exposures. "]
[" A successful Tracking program will provide tools, informations, and strategies that may help to decrease the chronic disease burden resulting from environmental exposures"]
["TASK - Activities to be Implemented","BAC (planned)","Planned Start date","Planned End Date","Total Months","BCWS","ACWP","% PL. COMP","% ACT COMP","BCWP","Program Name:"]
[]
[]
[{"$nulls":4},0,0,null,null,null,0,"CDC NEPHT Program"]
[{"$nulls":4},0,0,null,null,null,0]
[{"$nulls":4},0,0,null,null,null,0,"OPDIV: CDC/NCEH; EHHE"]
[{"$nulls":4},0,0,null,null,null,0]
[{"$nulls":4},0,0,null,null,null,0,"2008-12-15"]
[]
[{"$nulls":4},0,0,null,null,null,0]
[{"$nulls":4},0,0,null,null,null,0]
[{"$nulls":4},0,0,null,null,null,0]
[{"$nulls":4},0,0,null,null,null,0]
[{"$nulls":4},0,0,null,null,null,0]
[{"$nulls":4},0,0,null,null,null,0]
[{"$nulls":4},0,0,null,null,null,0]
[{"$nulls":4},0,0,null,null,null,0]
[{"$nulls":4},0,0,null,null,null,0]
[{"$nulls":9},0]
[{"$nulls":4},0,0,null,null,null,0]
[{"$nulls":4},0,0,null,null,null,0]
[{"$nulls":4},0,0,null,null,null,0]
[{"$nulls":4},0,0,null,null,null,0]
["    Total ",0,null,null,null,0,0,null,null,0]
[null,"BAC",null,null,null,"BCWS","ACWP",null,null,"BCWP"]
[]
[]
[null,"Response "]
{"$rows_empty":17}
["Legend:"]
["Budget At Completion (BAC)"]
["Budgeted Cost of Work Scheduled (BCWS)"]
["Budgeted Cost of Work Performed (BCWP)"]
["Actual Cost of Work Performed (ACWP)"]
["Cost Variation (CV)"]
["Schedule Variation (SV)"]
["Earned Value Analysis (EVA)"]
["Work Breakdown Structure (WBS)"]
["Program Management Tool (PMT)"]

{"sheet":"EVA","index":2,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"The Following Cells Are Formula-Driven Based On Your Work Packages Entered Above"]
[null,"Budget At Completion (BAC)",null,null,null,0]
[null,"Budgeted Cost of Work Scheduled (BCWS)",null,null,null,0]
[null,"Budgeted Cost of Work Performed (BCWP)",null,null,null,0]
[null,"Actual Cost of Work Performed (ACWP)",null,null,null,0]
[null,"COST VARIANCE"]
[null,"Cost Variance in $",null,null,null,0,"   Cost Variance = BCWP - ACWP (negative value = over budget)"]
[null,"Cost Variance %",null,null,null,{"$error":"#DIV/0!"},"   Cost Variance Percentage = (CV / BCWP)"]
[null,"CPI-Cost Performance Index (On 1-to-100 Scale)",null,null,null,{"$error":"#DIV/0!"},"   Cost Performance Index = BCWP / ACWP"]
[null,"SCHEDULE VARIANCE"]
[null,"Schedule Variance in $",null,null,null,0,"   Schedule Variance=BCWP - BCWS (negative value = behind schedule) "]
[null,"Schedule Variance % ",null,null,null,{"$error":"#DIV/0!"},"   Schedule Variance Percentage = (SV / BCWS)"]
[null,"SPI-Schedule Performance Index (On 1-to-100 Scale)",null,null,null,{"$error":"#DIV/0!"},"   Schedule Performance Index = BCWP / BCWS"]
[null,"FORECAST FOR FUTURE PERFORMANCE"]
[null,"Best Case Estimate (EAC1)"]
[null,"Estimate At Completion - Best Case (EAC1)",null,null,null,{"$error":"#DIV/0!"},"   EAC1 = ACWP + (BAC - BCWP) / CPI"]
[null,"Variance At Completion - Best Case (VAC1)",null,null,null,{"$error":"#DIV/0!"},"   VAC1 = BAC - EAC1"]
[null,"Variance At Completion % - Best Case (VAC1%)",null,null,null,{"$error":"#DIV/0!"},"   VAC1 % = (VAC1/BAC)"]
[null,"Worst Case Estimate (EAC2)"]
[null,"Estimate At Completion - Worst Case (EAC2)",null,null,null,{"$error":"#DIV/0!"},"   EAC2 = ACWP + (BAC - BCWP) / (CPI * SPI)"]
[null,"Variance At Completion - Worst Case (VAC2)",null,null,null,{"$error":"#DIV/0!"},"   VAC2 = BAC - EAC2"]
[null,"Variance At Completion % - Worst Case (VAC2%)",null,null,null,{"$error":"#DIV/0!"},"   VAC2 % = (VAC2/BAC)"]
[null,"End-of-Project Estimates"]
[null,"Expected Funds to Completion",null,null,null,{"$error":"#DIV/0!"},"   ((EAC1+EAC2)/2)-ACWP (Avg of high & low EAC minus ACWP)"]
[null,"Expected Completion Month/Year",null,null,null,"07/312009"]

{"sheet":"PMT Narratives","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}