{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Suggested SLT Timeline","Suggested QA Reports"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Suggested SLT Timeline","index":0,"n_rows":64,"n_cols":2,"rows_kept":64}
["Point"]
["Date","Activity"]
["3/1/2018 - 11/1/2018","Run EIS Facility Configuration reports and compare to your local system to insure IDs still match and to identify new facilities, units, processes, release points that need to be created in EIS.  "]
["3/1/2018 - 11/1/2018","Develop facility inventory submission to update EIS with changes to status, new facilities, units, processes and release points."]
["3/1/2018 - 11/1/2018","If using staging tables; run embedded queries to check for widows and orphans prior to conversion"]
["3/1/2018 - 11/1/2018","Submit facility inventory data to the EIS QA Environment.  Check Potential Duplicates section of feedback report and resolve any real duplicates as opposed to actual new facilities that need to be added.  Revise or add facility IDs in EIS as needed to allow EIS to recognize the correct facility when you submit to Production."]
["3/1/2018 - 11/1/2018","Check number of facility, unit, process and release point records received on the Statistics tab of feedback report against number of records submitted."]
["3/1/2018 - 11/1/2018","Resolve all critical errors in facility feedback report"]
["3/1/2018 - 11/1/2018","Submit facility inventory data to the EIS Production Environment.  Note that you only need to submit data for items that have changed between your system and EIS.  Existing facilities and units and release points do not need to have locations, unit types, release parameters, etc reported to EIS each year if they are already in EIS and acceptable.  In particular, if your system does not contain information on unit type or other data fields in EIS, do not include those fields in your submittal with \"unclassified/miscellaneous\" for existing facilities.  "]
["3/1/2018 - 11/1/2018","Check Potential Duplicates section of EIS and resolve any issues by contacting EIAG to add or merge facilities."]
["6/1/2018 - 12/31/2018","Download landing/takeoff data for review from 2017 website, available 6/30/2018"]
["2018-06-15","Download expected pollutants list from SharePoint"]
["6/1/2018 - 12/31/2018","Develop emissions (point) inventory for submission to EIS"]
["6/1/2018 - 12/31/2018","Submit point inventory to the EIS QA Environment"]
["6/1/2018 - 12/31/2018","Check number of reporting period and emission records received on the Statistics tab of the feedback report against the number of records submitted."]
["6/1/2018 - 12/31/2018","Resolve all critical errors in point feedback report"]
["6/1/2018 - 12/31/2018","Review emission range warnings for possible outliers or incorrect entry"]
["7/1/2018 - 12/31/2018","Submit data to the EIS Production Environment"]
["10/1/2018 - 12/1/2018","Run suggested QA reports in the Suggested QA spreadsheet"]
["10/1/2018 - 12/1/2018","Review expected pollutants list against data submitted."]
["10/1/2018 - 12/1/2018","Run completion report to verify everything has been submitted and check feedback reports and run summary EIS reports to insure everything has been loaded into EIS as expected"]
["12/1/2018 - 1/15/2019","Address any last minute adjustments, facility window closes 1/8/2019"]
["Nonpoint"]
["Date","Activity"]
["2018-06-15","Download expected pollutants list from SharePoint"]
["6/1/2018 - 12/1/2018","Submit data to the EIS QA Environment"]
["6/1/2018 - 10/1/2018","Check that activity data for all agricultural fires has been completed"]
["6/1/2018 - 12/1/2018","Check number of emisison process, reporting period and emission records received on the Statistics tab of feedback report against the number of records submitted.  The statistics should equal"]
["6/1/2018 - 12/1/2018","Resolve all critical errors in feedback report"]
["6/1/2018 - 12/1/2018","Review emission range warnings for possible outliers or incorrect entry"]
["6/15/2018 - 1/15/2019","EIS submittal window open for all nonpoint sources. CMV and rail emission submittals due 1/15/2019."]
["2019-03-31","Extended emissions submittal deadline for all non-CMV and non-rail sources"]
["7/1/2019 - 3/31/2019","Submit, if not accepting EPA inputs/emissions, to SharePoint any non-Cat 3 nonpoint inputs to EPA using provided templates"]
["6/15/2018 - 7/15/2018","Review and submit comments on Cat 2a EPA tools"]
["9/1/2018 - 3/31/2019","Download Nonpoint Survey from the 2017 Website; determine which sectors will be submitted to EIS and which sectors you will accept EPA estimates/inputs."]
["2018-09-30","Download commercial marine vessel shapefile fractions from 2017 website (line rail will be at county, not shape level for 2017NEI)"]
["10/1/2018 - 1/1/2019","Run suggested QA reports listed in the Suggested QA spreadsheet"]
["10/1/2018 - 1/1/2019","Run completion report to verify everything has been submitted"]
["11/15/2018 - 12/15/2018","Review and submit comments on Cat 2b EPA tools"]
["2019-01-15","Nonpoint survey due date for all non-Category 3 (Category 1 and 2 and any non-EPA-generated) sources to EPA"]
["2019-01-15","SLT submittal date for CMV and rail estimates"]
["2/28/2019 - 4/30/2019","Review and submit comments on Cat 3 EPA tools"]
["2019-03-31","Due date for all emissions except for Category 3 sources"]
["2019-03-31","Nonpoint survey due date for Category 3 sources to EPA"]
["2019-03-31","Due date for submitting emissions for all non-CMV and non-rail sources"]
["2019-05-31","Due date for submitting inputs for Category 3 emissions to SharePoint -if not accepting EPA inputs/emissions"]
["Mobile"]
["Date","Activity"]
["6/1/2018 - 12/1/2018","Download onroad and nonroad inputs and instructions from the EIS Gateway"]
["6/1/2018 - 12/1/2018","Adjust inputs (e.g., VMT, inspection maintenance, etc)"]
["6/1/2018 - 12/1/2018","Package submission according to instructions posted on 2017 website"]
["6/1/2018 - 12/1/2018","Run QA Tool posted on 2017 website"]
["6/1/2018 - 12/1/2018","Submit to EIS QA Production"]
["6/1/2018 - 12/1/2018","Resolve all critical errors in feedback report"]
["6/15/2018 - 12/1/2018","Submit to EIS Production Environment"]
["12/1/2018 - 1/15/2019","Address any last minute adjustments"]
["Events"]
["Date","Activity"]
["3/1/2018 - 6/15/2018","Join Fires workgroup if interested, attend calls to understand EPA methods and provide comments on process via questionaire"]
["6/10/2018 - 9/1/2018","Work on questionaire and template sent by EPA"]
["2018-09-01","Due date for draft activity data and questionaire"]
["2018-09-01","Download Smartfire preliminary results from 2017 website"]
["9/30/2018 - 12/15/2018","Provide comments on draft data"]
["3/1/2019 - 5/1/2019","Final SmartFire 2 results review"]

{"sheet":"Suggested QA Reports","index":1,"n_rows":11,"n_cols":6,"rows_kept":11}
["Note: EIS reports now utilize current loaded data for all reports.  It is no longer necessary to wait for an overnight batch refresh of summary emissions tables"]
["Point"]
["Type","Report Type","Dataset","Pollutants","Geographic Region","Checks"]
["Type","Report Type","Dataset","Pollutants","Geographic Region","Checks"]
["Emission Summary - By Geography","State or County Level","Your Agency Dataset","All Active Pollutants","Your state, county or Tribe","Check that state/pollutant combinaton totals equal the state/pollutant combinations that you intended to submit to EIS.  This will assure that a) all of your emissions data successfully made it into the xml file, and b) all of the xml data was accepted by EIS.   If there are significant differences, run a facility or unit or process level EIS report and compare to your system's sums to identify where the differences are coming from."]
["Comparison - Facility","Facility Level","Your current Agency Dataset; 2014 Agency Dataset; 2014 v2 NEI","All Active Pollutants","Your state, county or Tribe","Compare your 2017 submitted and accepted emissions  to either your 2014 submission or to the 2014 NEI.  Look for large differences which might indicate reporting errors. Check that all pollutants reported in 2014 have been reported in 2017.  "]
["Emission Summary - By Facility","Facility Level","Your Agency Dataset","All Active Pollutants","Your state, county or Tribe","Sort for Top 25 facilities for each pollutant reported.  Do they make sense?"]
["Nonpoint"]
["Type","Report Type","Dataset","Pollutants","Geographic Region","Checks"]
["Emission Summary - By Geography","SLT by Sector","Your Agency Dataset","All Active","Your state, county or Tribe","Check that the state (county or Tribe)/sector/pollutant in EIS are the same as the file you submitted.  If there are differences, run the same report at the SCC level until you can highlight where the differences are coming from."]
["Comparison","Sector","Your current Agency Dataset; 2014 Agency Dataset","All Active","Your state, county or Tribe","Compare your 2017 submission to your 2014 submission.  Check that all pollutants and sectors reported in 2014 have been reported in 2017.  If there ae differences, run the same report at the SCC level to determine the location of the erroneous or missing data."]