Surface Water Systems in North Carolina must fill out the Excel MOR file provided by the state (example file: MORS_NC1234567_WP1_Current.xls). Because the file contains macros/security you cannot simply copy and paste data or use the Link To Microsoft Excel feature to populate the file. Therefore, we create a WIMS Spread Report that contains all the data for each sheet. We then copy this data into the User Data sheet in the Excel File. We update the Excel file with formulas to point at the User Data sheet. Example ='User Data'!B16
![](http://www.opssys.com/instantkb/Attachments/488bc808-abe2-4392-8273-009d.png)
![](http://www.opssys.com/instantkb/Attachments/8b71c554-3187-4fcc-bbc6-ed22.png)
NC_DW_MORS_SUMMARY.ss3 Monthly Operating Reports (MORs) Summary : preview
North Carolina MOR Summary for surface water system use
Author: SPD 08/16/2006
NC_DW_REPORT_OF_PHYSICAL_TESTS_AND_CHEM_ANALYSIS.ss3 REPORT OF PHYSICAL TESTS AND CHEMICAL ANALYSIS : preview
North Carolina DENR report 1940 Physical Tests and Chemical Analysis Report
Author: SPD 08/16/2006
NC_DW_WATER_DBP_TREATMENT_TECHNIQUE.ss3 Report of DBP Treatment Technique Compliance : preview
North Carolina Disinfectant/Disinfection Byproducts Rule - Treatment Technique
Author: SPD 03/08/2006
NC_DW_WATER_DIST_BACTERIOLOGICAL_SUMMARY.ss3 DISTRIBUTION BACTERIOLOGICAL ANALYSIS SUMMARY : preview
North Carolina DENR report 3762
Author: SPD 03/08/2006
NC_DW_WATER_MICROBIOLOGICAL_REPORT.ss3 MICROBIOLOGICAL OPERATIONS REPORT : preview
North Carolina DEHNR Report 3763
Author: SPD 03/08/2006
NC_DW_WATER_USAGE_REPORT.ss3 REPORT OF OPERATION - WATER USAGE REPORT : preview
North Carolina water usage report
Author: SPD 03/08/2006
Click here for instructions on downloading a template.