{"text_format":"1","workbook":"xlsx","n_sheets":41,"sheets":["Cover","General Instructions","Detailed Instructions","Page 1","Page 2","Page 3","Page 4","Page 4a","Page 5","Page 5a","Page 6","Page 7","Page 8","Page 9","Page 10","Page 11","Page W-1","Page W-1a","Page W-2","Page W-2a","Page W-3","Page W-3a","Page W-4","Page W-5","Page W-5a","Page W-6","Page W-7 (Part 1)","Page W-7 (Part 2)","Page W-8","Page W-9","Page S-1","Page S-1a","Page S-2","Page S-2a","Page S-3","Page S-3a","Page S-4","Page S-4a","Page S-5","Page S-6","Verification Page"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":116,"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":"Cover","index":0,"n_rows":78,"n_cols":4,"rows_kept":78,"cut":false,"hidden":false,"merged":[[28,3,28,4],[27,3,27,4],[8,0,8,5],[10,0,10,5],[12,0,12,2],[15,0,15,4],[23,0,23,2],[24,2,25,5],[6,0,6,5],[7,0,7,5],[0,0,0,5],[1,0,2,5],[3,0,3,5],[4,0,4,5]]}
[]
["Company Full Certificated Name (Do not abbreviate and include any Commission approved AKA/DBA/Fictitious Name, if applicable.)"]
[]
[]
["WATER and/or SEWER ANNUAL REPORT"]
[]
["SMALL COMPANY"]
["(Fewer than 8,000 customers)"]
["TO THE"]
[]
["MISSOURI PUBLIC SERVICE COMMISSION"]
[]
["January 1 - December 31,",null,null,2012]
[]
[]
["Please select how the company is certificated with the Commission under the Company Name as shown above (check all that apply):"]
[null,"x","Water Service Provider "]
[]
[null,"x","Sewer Service Provider"]
[" "]
["Please choose one of the following filing options: "]
[]
[null,"x","Public Submission (NOT Highly Confidential)"]
[]
[null,null,"Non-Public Submission (Highly Confidential / Filed Under Seal)\nFor this filing to be considered Highly Confidential, additional \nsubmission of materials is required pursuant to Commission \nrule 4 CSR 240-3.335 and/or 4 CSR 240-3.640, Section 392.210, RSMo., and/or Section 393.140, RSMo."]
[]
[]
[]
["Excel Revised  12/12/2012",null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Public"]
[null,null,null,"Highly Confidential"]

{"sheet":"General Instructions","index":1,"n_rows":73,"n_cols":2,"rows_kept":73,"cut":false,"hidden":false,"merged":[[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[0,0,0,1],[2,0,2,1],[3,0,3,1],[4,0,4,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[9,0,9,1],[10,0,10,1],[12,0,12,1],[13,0,13,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[40,0,40,1],[41,0,41,1],[42,0,42,1],[43,0,43,1],[32,0,32,1],[33,0,33,1],[36,0,36,1],[39,0,39,1],[49,0,49,1],[50,0,50,1],[51,0,51,1],[52,0,52,1],[44,0,44,1],[45,0,45,1],[46,0,46,1],[48,0,48,1],[47,0,47,1],[52,68,52,78],[52,79,52,89],[52,2,52,12],[52,13,52,23],[52,24,52,34],[52,35,52,45],[52,222,52,232],[52,233,52,243],[52,244,52,246],[53,0,53,1],[52,178,52,188],[52,189,52,199],[52,200,52,210],[52,211,52,221],[52,90,52,100],[52,101,52,111],[54,0,54,1],[55,0,55,1],[52,156,52,166],[52,167,52,177],[52,112,52,122],[52,123,52,133],[52,134,52,144],[52,145,52,155],[52,46,52,56],[52,57,52,67],[59,2,59,3],[59,4,59,5],[59,6,59,7],[59,8,59,9],[56,0,56,1],[57,0,57,1],[58,0,58,1],[59,0,59,1],[59,18,59,19],[59,20,59,21],[59,22,59,23],[59,24,59,25],[59,10,59,11],[59,12,59,13],[59,14,59,15],[59,16,59,17],[59,34,59,35],[59,36,59,37],[59,38,59,39],[59,40,59,41],[59,26,59,27],[59,28,59,29],[59,30,59,31],[59,32,59,33],[59,50,59,51],[59,52,59,53],[59,54,59,55],[59,56,59,57],[59,42,59,43],[59,44,59,45],[59,46,59,47],[59,48,59,49],[59,66,59,67],[59,68,59,69],[59,70,59,71],[59,72,59,73],[59,58,59,59],[59,60,59,61],[59,62,59,63],[59,64,59,65],[59,82,59,83],[59,84,59,85],[59,86,59,87],[59,88,59,89],[59,74,59,75],[59,76,59,77],[59,78,59,79],[59,80,59,81],[59,98,59,99],[59,100,59,101],[59,102,59,103],[59,104,59,105],[59,90,59,91],[59,92,59,93],[59,94,59,95],[59,96,59,97],[59,114,59,115],[59,116,59,117],[59,118,59,119],[59,120,59,121],[59,106,59,107],[59,108,59,109],[59,110,59,111],[59,112,59,113],[59,130,59,131],[59,132,59,133],[59,134,59,135],[59,136,59,137],[59,122,59,123],[59,124,59,125],[59,126,59,127],[59,128,59,129],[59,146,59,147],[59,148,59,149],[59,150,59,151],[59,152,59,153],[59,138,59,139],[59,140,59,141],[59,142,59,143],[59,144,59,145],[59,162,59,163],[59,164,59,165],[59,166,59,167],[59,168,59,169],[59,154,59,155],[59,156,59,157],[59,158,59,159],[59,160,59,161],[59,178,59,179],[59,180,59,181],[59,182,59,183],[59,184,59,185],[59,170,59,171],[59,172,59,173],[59,174,59,175],[59,176,59,177],[59,194,59,195],[59,196,59,197],[59,198,59,199],[59,200,59,201],[59,186,59,187],[59,188,59,189],[59,190,59,191],[59,192,59,193],[59,210,59,211],[59,212,59,213],[59,214,59,215],[59,216,59,217],[59,202,59,203],[59,204,59,205],[59,206,59,207],[59,208,59,209],[59,218,59,219],[59,220,59,221],[59,242,59,243],[59,244,59,245],[59,222,59,223],[59,224,59,225],[59,226,59,227],[59,228,59,229],[59,230,59,231],[59,232,59,233],[59,254,59,255],[60,0,60,1],[59,234,59,235],[59,236,59,237],[59,238,59,239],[59,240,59,241],[59,246,59,247],[59,248,59,249],[59,250,59,251],[59,252,59,253],[62,6,62,7],[62,8,62,9],[62,10,62,11],[62,12,62,13],[61,0,61,1],[62,0,62,1],[62,2,62,3],[62,4,62,5],[62,22,62,23],[62,24,62,25],[62,26,62,27],[62,28,62,29],[62,14,62,15],[62,16,62,17],[62,18,62,19],[62,20,62,21],[62,38,62,39],[62,40,62,41],[62,42,62,43],[62,44,62,45],[62,30,62,31],[62,32,62,33],[62,34,62,35],[62,36,62,37],[62,54,62,55],[62,56,62,57],[62,58,62,59],[62,60,62,61],[62,46,62,47],[62,48,62,49],[62,50,62,51],[62,52,62,53],[62,70,62,71],[62,72,62,73],[62,74,62,75],[62,76,62,77],[62,62,62,63],[62,64,62,65],[62,66,62,67],[62,68,62,69],[62,86,62,87],[62,88,62,89],[62,90,62,91],[62,92,62,93],[62,78,62,79],[62,80,62,81],[62,82,62,83],[62,84,62,85],[62,102,62,103],[62,104,62,105],[62,106,62,107],[62,108,62,109],[62,94,62,95],[62,96,62,97],[62,98,62,99],[62,100,62,101],[62,118,62,119],[62,120,62,121],[62,122,62,123],[62,124,62,125],[62,110,62,111],[62,112,62,113],[62,114,62,115],[62,116,62,117],[62,134,62,135],[62,136,62,137],[62,138,62,139],[62,140,62,141],[62,126,62,127],[62,128,62,129],[62,130,62,131],[62,132,62,133],[62,150,62,151],[62,152,62,153],[62,154,62,155],[62,156,62,157],[62,142,62,143],[62,144,62,145],[62,146,62,147],[62,148,62,149],[62,166,62,167],[62,168,62,169],[62,170,62,171],[62,172,62,173],[62,158,62,159],[62,160,62,161],[62,162,62,163],[62,164,62,165],[62,182,62,183],[62,184,62,185],[62,186,62,187],[62,188,62,189],[62,174,62,175],[62,176,62,177],[62,178,62,179],[62,180,62,181],[62,198,62,199],[62,200,62,201],[62,202,62,203],[62,204,62,205],[62,190,62,191],[62,192,62,193],[62,194,62,195],[62,196,62,197],[62,214,62,215],[62,216,62,217],[62,218,62,219],[62,220,62,221],[62,206,62,207],[62,208,62,209],[62,210,62,211],[62,212,62,213],[62,250,62,251],[62,252,62,253],[62,254,62,255],[63,0,63,1],[62,242,62,243],[62,244,62,245],[62,222,62,223],[62,224,62,225],[62,246,62,247],[62,248,62,249],[64,0,64,1],[65,0,65,1],[62,238,62,239],[62,240,62,241],[62,226,62,227],[62,228,62,229],[62,230,62,231],[62,232,62,233],[62,234,62,235],[62,236,62,237],[78,0,78,1],[66,0,66,1],[67,0,67,1],[68,0,68,1],[69,0,69,1],[71,0,71,1],[72,0,72,1]]}
["Missouri Public Service Commission Annual Report Instructions"]
[]
["General Form Information"]
["This report is due to the Missouri Public Service Commission on or before April 15th and is required to be filed on a calendar year basis pursuant to the Commission rules (4 CSR 240-3.335 and/or\n4 CSR 240-3.640).  Failure to file this report by the deadline of April 15, 2013, could result in penalties up to $100 for every day the report is late pursuant to Section 392.210, RSMo."]
["•   If the document has been prepared by a third-party preparer, it is the responsibility of the\n    company personnel attesting to the accuracy of the document to review the document before \n    submission to the Missouri Public Service Commission."]
["•   After the annual report is complete, save the file to your computer.  You may submit it\n    electronically through the Commission's Electronic Filing and Information System (EFIS), as a   \n    non-case related submission (see Electronic Filing Instructions on Instructions Pages 4 - 5 \n    for details) or print the form, keep a copy for your records, and prepare for mailing."]
["•   You shall use the form provided by the Commission.   You may use one of the three versions \n     provided:  1) the Adobe Fillable document, 2) the Excel version, or 3) the Adobe document \n     that shall be printed and completed by hand. "]
["•   The Excel form is \"read only\". You must save or copy the file to your computer's hard drive to \n     input information into the annual report form."]
["•   If additional space is needed for entering information on a page, please insert a worksheet or\n    page and copy the formats or lines into the new sheet to accommodate the necessary\n    information.  "]
["•   If you are submitting an annual report extension request, it must be on company letterhead or\n    on the form provided and signed by an officer of the company.  A contact email address is also\n    required for approval or rejection of the request. "]
["Questions about the annual report form or its contents may be submitted to: Mark Oligschlaeger at \n(573) 751-7443 or by e-mail at mark.oligschlaeger@psc.mo.gov.  "]
[]
["Treatment of Highly Confidential Information (Submission Under Seal)."]
["Utilities may request classification of selected portions of their annual report as non-public \n(highly confidential / filed under seal) pursuant to the Commission rules at 4 CSR 240-3.335 and/or \n4 CSR 240-3.640. \n         \nPlease note that all information classified as non-public will still remain subject to potential disclosure as provided under the Missouri open records act (Chapter 610 RSMo) and Section 386.480, RSMo."]
["In order to include Highly Confidential information in the annual report, the submitter must: "]
["Provide two versions of the annual report;\n    1) a Public version with the Highly Confidential information redacted (removed), and\n    2) a fully completed version to be kept as Highly Confidential with restricted access.\n\nBelow are the procedures outlining the requirements for each type of submission: "]
["(A) Public version"]
["1. Cover – Check the “Public Submission” box and denote “Public” in the lower right corner.\n2. Completion – All pages should be completed excluding the non-public information.\n3. Page Designation – Each page that has had Highly Confidential information removed must\n    have the “Public” designation in the lower right corner.\n4. Format – where Highly Confidential information has been removed, two (2) asterisks shall\n    be placed before and after the information, e.g. **highly confidential information removed**.   \n    The field must be left blank to insure the information remains on the same line and page \n    as in the Highly Confidential version."]
["(Treatment of Highly Confidential Information [Submission Under Seal] continued on the next page.)"]
["-Instructions Page I-"]
["Treatment of Highly Confidential Information (Submission Under Seal)  -  continued"]
["(B) Highly Confidential version"]
["1. Cover – Check the “Non-Public Submission” box and denote “Highly Confidential” in the lower\n    right corner. \n2. Completion – All pages should be completed including the Highly Confidential information\n3. Page Designation – Each page that contains Highly Confidential information must have a\n    “Highly Confidential” designation in the lower right corner.\n4. Format – Highly Confidential information shall be designated by two (2) asterisks before and\n    after the information, e.g. **your highly confidential information here**. "]
["(C) Additional documents required with both submissions: "]
["1. A cover letter stating the utility is designating some or all of the information in its annual\n    report as confidential and requesting non-public treatment under seal. The name, phone\n    number and e-mail address (if available) of the person responsible for addressing\n    questions regarding the confidential portions of the annual report must be included.\n2. A notarized affidavit that clearly identifies the specific types of information to be kept\n    under seal. Justification of why the specific information should be a closed record and a\n    statement attesting that none of the information is available to the public in any format."]
["Detailed Form Information"]
["Page","Definitions and/or Instructions"]
["Cover","Company Name:  This shall reflect the certificated name of the company that the Commission approved in a case; when this field is filled in, it will automatically populate\nthe company name at the top of each of the following sheets.\nThe company name listed on the cover shall include any Commission approved fictitious name or d/b/a name (ABC Company d/b/a XYC LLC).\nYear:  When the reporting period year is entered, it will automatically populate at the top of all subsequent pages. \n\n"]
[null,"First check box (certification/registration type):  \nCheck the box if the company listed on the Company Name line has been approved as competitively classified by the Commission.  \n\nSecond set of check boxes (security level/filing options):  \nCheck the first box (Public Submission) if this is the public version of the annual report.  \n\nCheck the bottom box (Non-Public Submission) only if the annual report contains proprietary or highly confidential information in the report.  The annual report submission will be considered deficient unless this submission is accompanied by the required documentation.  Please see Treatment of Highly Confidential Information in the above section for details.         \n"]
["Verification Page"]
[null,"The verification page must be completed in full, including notary seals, if or where applicable. \n\nThis page must accompany all versions of this report including any original or revised,  highly confidential, proprietary and public versions. "]
[null,"The State Of and County Of fields shall be filled  with the location where the notary operates and where this document was notarized. \nLegal Name of Affiant: Any representative of the company authorized to attest to the accuracy of the annual report. \nOfficial Title of the Affiant: Title of the representative named on the line just above this one. \n\n"]
["(Verification Page instructions continued on the next page. )"]
["-Instructions Page II-"]
["Detailed Form Information (continued)"]
["Page","Definitions and/or Instructions"]
["Verification Page (continued) "]
[null,"Exact Legal Title or Name of the Respondent: Company Name as certificated/registered with the Commission, as listed on the cover and the top of the verification sheet. \n\nSignature of Affiant: Signature of authorized company representative named above on the verification page.   \n\nThe remaining fields are for completion by the notary including the date, month and year of the notarization, the notary's commission expiration date, notary signature,  and placement of the notary stamps or seals, where applicable. "]
[null,"When submitting the annual report form electronically, complete the verification page in full.  Electronic signatures are acceptable pursuant to Sections 432.200 through \n432.295 RSMo.  \n\nThe original document shall be notarized and kept for your records.  On the electronic version, type the electronic signatures ( /s/ John Doe)  and dates that are reflected on the original document."]
["Options for Submitting the Annual Report to the Missouri Public Service Commission "]
["The annual report may be submitted to the Missouri Public Service Commission by either of the following methods:  "]
["1. Electronically through the Electronic Filing and Information System (EFIS).\nThis system accepts submissions 24 hours a day and saves on postage/shipping expenses.  \nPlease see Instructions Page 4 - 5 for detailed instructions to use this system.  If you have questions while using EFIS, staff is available Monday - Friday from 8:00 a.m. - 5:00 p.m. \n(excluding State holidays) to assist you at (573) 751-7496. \nNOTE:  E-mails and faxes are NOT acceptable methods of filing the annual report electronically."]
["OR"]
["2. Mail to the following address: \nMissouri Public Service Commission \nAttention: Data Center \n     \nFor package delivery: \n200 Madison Street, Suite 100 \nJefferson City, MO 65101 \n\nFor U.S. Mail: \nP.O. Box 360 \nJefferson City, MO 65102-0360 "]
["-Instructions Page III-"]
["Electronic Filing of Annual Report Information"]
["If you submit your information electronically, please DO NOT send in a paper copy."]
["In order to file in the Electronic Filing and Information System (EFIS):"]
["• You must have a user ID and password,\n• The company you are filing on behalf of must be registered in EFIS.\n   (All certificated companies are already registered in EFIS.  Please do not create a company\n   registration), \n• The person making the filing must be registered as a contact for the company/firm they are\n   making the filing on behalf of, and\n• You need to have the information you want to submit saved electronically."]
["If you are unsure if you have a user ID, if your company is registered, or if you are registered as a contact for the company, please contact the Data Center at  datacenter-psc@psc.mo.gov or \n(573) 751-7496 before completing new registration information.\n"]
["To access EFIS, go to the PSC website at http://www.psc.mo.gov.  Click the ‘EFIS / Case Filings’ link from the menu on the left-hand side.  Scroll down to the ‘Main Menu Section of EFIS’ and click on the ‘EFIS’ link. This will take you to the EFIS Welcome Screen."]
["• Click the orange ‘Logon’ button on the left-hand side.\n• Enter your User ID and Password.\n  NOTE: Passwords are case sensitive."]
["Submission of Annual Report "]
["• Click on the ‘Filing/Submission’ menu option.\n• Click on the ‘Non-Case Related Submission’ link."]
["Complete the Non-Case Related Submission screen with the following information: "]
["• Type of Utility – Select the utility type as which the company is certificated/registered.\n   Separate submissions are required if a company has multiple certifications/registrations\n   (Example:  Water and Sewer; or CLEC and IXC).\n• Company – Select certificated company name. \n  Choose d/b/a name, if applicable.  This name should match the name at the top of the \n  annual report's cover page.\n• Type of Submission – Select ‘Annual Report (Mo PSC)’.\n• Total Missouri Jurisdictional Revenue – Enter the amount from the annual report form found\n  on Page 1, Item No. 18 (Water) or Item No. 21 (Sewer).\n• Report for Calendar Year - Type in 2012.\n• Applicable Case No. – Leave blank.\n• Date Filed – Will already be filled in.\n• Click on the ‘Continue’ button.\n  This will take you to the Filing/Submission Attachment screen.\n• Click on ‘Browse’ – Select the file that contains the completed annual report.\n• Choose the security level for your document:  Public, Highly Confidential, or Proprietary.\n• Click the ‘Attach’ button.\n  On screen instructions are provided for attaching more than one document.  \n  Confirm that the correct document is attached before proceeding.  \n• Click the ‘Done with Attach’ button.\n  This will return you to the original submission screen.\n• Scroll down and click on the ‘Submit’ button."]
["This will complete your submission and assign a non-case related tracking number (BMAR-2013-xxxx).  Please retain this number for your records. \n"]
["-Instructions Page IV-"]
["Electronic Filing of Annual Report Information (continued)"]
["Submission of Additional Information"]
["If you are asked to provide additional information or need to file amended information, file it as a \n‘Non-Case Related Supplemental Submission’ using the tracking number from your original annual report submission."]
["Instructions for this type of submission can be found by clicking on the blue ‘Help’ button on the left-hand side of any EFIS screen.  Scroll down to ‘Filing / Submission – Non-case Related’.  Then choose 'Make a subsequent filing to a non-case related submission'."]
["Request for Extension\n(30 days or Less)"]
["If you will not be able to file your annual report by the April 15th deadline, you must request an extension on or before April 15th."]
["All annual report extension requests must be on company letterhead and signed by an officer of the company or on the form provided on the PSC website (www.psc.mo.gov/forms) and signed electronically by a company representative.  A contact e-mail address is required for approval or rejection of the request"]
["Follow the instructions for filing an annual report with these modifications."]
["• Type of Submission - Select Annual Report (MO PSC) Extension Request.\n• Comments - Type in 2012 Annual Report Extension Request.\n• Under “Browse”, attach your documentation for requesting an extension."]
["Once your submission is complete, you will be assigned a non-case related tracking number (BARE-2013-xxxx).  Please retain this number for your records. "]
["Additional instructions can be found under the blue ‘Help’ button in EFIS on how to:"]
["• Access EFIS.\n• Log on to EFIS. \n• Obtain a user ID and password.\n• Reset my password. \n• File an annual report, statement of revenue, or other non-case related submission. \n• Make a subsequent filing to a non-case related submission. "]
[]
[]
["-Instructions Page V-"]

{"sheet":"Detailed Instructions","index":2,"n_rows":102,"n_cols":1,"rows_kept":102,"cut":false,"hidden":false,"merged":[[50,0,51,0]]}
["DETAILED FORM INSTRUCTIONS"]
[]
["     This form should be used by companies that have fewer than 8,000 customers.  "]
["     In examining the report form you will note there are various references requiring water information and sewer information on the same page."]
[]
["     If you have water operations only, you should complete all information for water utilities.  Any requested information for sewer data should be clearly marked by you as Not Applicable (e.g., N.A.)."]
[]
["     If you have sewer operations only, you should complete all information requested for sewer utilities.  Any requested information for water data should be clearly marked by you as Not Applicable (e.g., N.A.). "]
[]
["     If you are a joint utility in that you have both water and sewer operations, you shall fill out all parts of all pages completely to the best of your ability and belief utilizing the available information.  You will note that all pages on Lines 1 and 2 require the year of the report and the company name.  This must be completed on all pages."]
[" "]
["   If this document has been prepared by a third-party preparer, it is the responsibility of the company personnel attesting to the accuracy of document to review the document before submission to the Missouri Public Service Commission."]
[]
["INSTRUCTIONS for PAGE 1"]
["     On Line 2, provide the full company name as it appears on your certificate of convenience and necessity."]
["     On Lines 3, provide the company street address.  On Line 4, provide the mailing address if different than Line 3. "]
["     On Line 5, provide the company phone number and the e-mail address of the regulatory contact.  If an e-mail address is not available please designate with \"n/a\"."]
["     On Lines 6 through 15, provide names, addresses, phone numbers and e-mail addresses of any persons who can be contacted concerning information contained in this report."]
["     On Lines 13 through 17, provide names, addresses, phone numbers and e-mail addresses of any persons who can be contacted concerning plant operations."]
["      On Lines 16 through 21, please enter the Company Revenues indicated.  If using the Excel version, the Missouri Jurisdictional Revenues will automatically fill from pages W-2 and S-2.  "]
[]
[" INSTRUCTIONS for PAGE 2"]
["     On Line 2, provide the full company name as it appears on your certificate of convenience and necessity."]
["     On Lines 3 through 7, provide for each class and/or series of common and/or preferred stock the total number of shares authorized by charter, the par or stated value per share and the total number of shares issued."]
["     On Lines 8 through 15, provide the names, addresses and number of votes resulting from stock ownership as of December 31.  If any such holder held the stock in trust, state the nature of the trust and the beneficial owner. "]
["     On Line 16, provide total number of votes held by the names provided in lines 8 through 15."]
["     On Line 17,  provide the total number of votes of all securities with voting rights."]
["     On Lines 18 - 23, provide the title and names of the officers of the company at the end of the reporting year."]
["      On Line 21 and 22, check all boxes for which the company is current.  "]
["      On Line 23, provide the case number and effective date of the last approved rate request case with the Commission. "]
["      On Lines 27 and 28, check all boxes for which the company has filed and is current on the appropriate paperwork and payments. "]
["      On Line 29, provide the most recent rate increase request case number and effective date of approval. "]
["-Instructions Page VI-"]
["INSTRUCTIONS for PAGE 3"]
["     On Line 2, provide the full company name as it appears on your certificate of convenience and necessity."]
["     Describe all transactions occurring during the year that will have a major effect on operations.  "]
["These transactions may be rate changes, the replacement of major equipment or any other abnormal cash expenditure amounting to $250 or more.  Please note that if the expenditure is of a normal and recurring nature (i.e., monthly electric bills), it should not be classified as an abnormal item."]
[]
["INSTRUCTIONS for PAGE 4"]
["     The dollar amount for Lines 3, 4, 6, 10, 11 and 13 should be brought forward from the appropriate page and line as indicated."]
["     Construction Work in Progress:  Shall include the total amount of work for utility plant in process of construction but not ready for service at the end of the year. "]
["     Plant Held for Future Use:  Shall include the original cost of property owned and held for future use under a definite plan for use."]
["     Plant Acquisition Adjustment:  Shall include the purchase price of any plant purchased less the original cost, estimated if not known, less any depreciation reserve."]
[]
["INSTRUCTIONS for PAGE 5"]
["     The dollar amount for Lines 11, 12, 16 and 17 should be brought forward from the appropriate page and line as indicated."]
["     Customer Deposits:  Shall include all deposits with the utility by customers as security for payment of bills."]
["     Advances for Construction:  Shall include advances by any applicant for construction that is to be refunded either in part or completely."]
["     Contributions in Aid of Construction (CIAC):  Shall include any donation or contribution in cash or services, or property from any company, individual, agency or others for construction purposes.  CIAC shall include connection fees for new service. All supporting entries shall be kept so that the utility can furnish information regarding the purpose of each donation, and the amount of the donation.  (NOTE:  There shall not be any advances for construction that are to be repaid in part or completely included in this account except if not returned by the time specified in the utilities tariff.)"]
[]
["NOTE:  TOTAL ASSETS FROM PAGE 4 MUST BALANCE WITH TOTAL EQUITY AND LIABILITIES \nFROM PAGE 5"]
[]
[]
["INSTRUCTIONS for PAGE 6"]
["     On Page 6, provide information for all customer sales determined to be uncollectible.  You should identify the customer, the methods used to attempt collection, the amount and why it is uncollectible (i.e., customer filed bankruptcy, left town, etc.).  This uncollectible amount is an expense to be recorded on the Income Statement (Page W-1 and/ or S-1)."]
[]
["INSTRUCTIONS for PAGE 7"]
["     On Page 7, provide information regarding payroll.  Provide names, titles and salaries of all officers and employees.  Provide total compensation paid to each during the year including bonuses and other allowances. Identify the total compensation as chargeable to water expense, sewer expense or construction.  Also, identify any employee who did not receive any compensation during the year."]
[]
["INSTRUCTIONS for PAGE 8"]
["     On Page 8, provide information regarding professional services the utility company received.  Report all information concerning rate, management, construction, engineering, research, financial, valuation, legal, accounting, purchasing, advertising, labor relations, public relations, or other similar professional services rendered the respondent under written or verbal arrangements, for which total payments during the year to any corporation, partnership, individual (other than for services as an employee), or organization of any kind whatsoever."]
["-Instructions Page VII-"]
["INSTRUCTIONS for PAGE 9"]
["     On Page 9, provide information regarding contributions in aid of construction and the amortization of contributions in aid of construction.  This account shall include donations or contributions in cash, services, or property for construction purposes, including connection fees for new service.  The records supporting the entries to this account shall be so kept that the utility can furnish information as to the purpose of each donation, the conditions, if any, upon which it was made, the amount of each donation, and the amount applicable to each utility department.  The credits (deductions) to this account shall not be transferred to any other account without the approval of the Commission."]
["   Lines 3 and 4 require input from last year's annual report page 9."]
["   Line 4 is the recording of new contributions for this year. "]
["   Line 11 depends on the method your company uses for CIAC amortization.  If your company uses the \"distributed\" method as described below, no retirement entries for CIAC should appear in line 11, (leave them blank)."]
["     For retirement purposes, Contributions in Aid of Construction (CIAC) are amortized at the same rate as the depreciation rates set for the plant equipment.  There are two methods as follows: "]
["     1. Attached Method: This method is the keeping of continuous property records such that the contributions are kept “attached” to the original equipment contributed. CIAC is amortized and retired at the same depreciation rate and retirement dates as the equipment which it is “attached” to.   For this method complete the table with Line 25 through Line 27.  "]
["    2. Distributed Method: Most small companies use this method. This method results in no CIAC retirement entries on line 11. The “distributed” method is to treat each contribution as a dollar amount that is equally distributed to all plant in service.  Under this method, the annual CIAC amortization is a portion of the total plant depreciation expense.  The ratio used to calculate this portion is the end of year CIAC balance divided by the end of year total plant in service. The CIAC amortization is simply the total plant depreciation expense multiplied by the ratio of CIAC to Total Plant.  The annual amortization is added to the sum of all prior accumulated amortization until the total equals the original amount of all contributions. At this point the process is stopped and both the total CIAC and the accumulated amortization are reset to zero.  For this method, complete the table containing Line 18 through Line 24. "]
[]
["INSTRUCTIONS for PAGE 10"]
["     On Page 10, provide all required information concerning interest expense, notes payable, bonds, bank loans and other financial debts that existed during the year.  For each debt on which interest was paid during the year provide the name and address of the lender, the date of maturity, the loan balance, the interest rate on the loan, and the amount of interest paid.  The amount of interest paid should be assigned to water utility expense and/or sewer utility expense based upon which utility was responsible for the loan."]
[]
["INSTRUCTIONS for PAGE 11"]
["     On Page 11, provide descriptions, quantities and dollar costs of materials and supplies in inventory.  These items may be pipe, wire, gasoline, diesel, etc.  You should identify the cost and assign the cost to either water or sewer."]
[]
["INSTRUCTIONS for PAGES W-1, W-2, W-3 and/or S-1, S-2, S-3"]
["     On Pages W-1, W-2, W-3 and/or S-1, S-2, S-3, provide information regarding all billed revenues, expenses, customer numbers and gallon sales."]
[]
["INSTRUCTIONS for PAGE W-4"]
["     On Page W-4, provide information regarding quantities of water from each source of supply that entered the system.  On Line 21, provide data regarding the maximum and minimum quantities of water supplied in any one day.  On Line 22, provide the range of pressures that exist at the highest point of the system.  On Lines 23 thru 26, provide information regarding any sale of water for resale.  "]
["-Instructions Page VIII-"]
["INSTRUCTIONS for PAGES W-5, W-6 and/or S-4, S-5"]
["     On Pages W-5, W-6 and/or S-4, S-5, provide information regarding water and/or sewer utility plant-in-service, depreciation expense and depreciation reserve.  The account numbers shown in column (b) are defined in the Uniform System Of Accounts (USOA). The definitions describe what type of plant equipment is included in each account number.   For each company, a USOA CLASS, a set of account numbers, and a set of depreciation rates are assigned by the PSC.  These assignments for use by your company should be specified in a Depreciation Rate Schedule included as part of your company's last certificate or rate case final order.  If you do not have this schedule, call the PSC and ask to speak to someone in the Engineering and Management Services Department"]
["      Columns (c), (d), (e) and (f) require original installed cost of plant and equipment placed in service.  If a replacement of plant occurs, such as a pump change-out or trading in a truck, then column (d) should show the full installed cost of the new item.  In retirement column (e), record the original installed cost (from Plant Property Records), of the item which was replaced (removed).   These entries should be supported by books and records, which identify the property and its location.   The Balance at End of Year, column (f) equals columns (c) plus (d) minus (e). "]
["       Depreciation expense column (h) is computed using the Balance at End of Year column (f), --- or mid-year or mid-month convention used by your company.  Record in column (g) the depreciation rate used, (from you company's PSC Depreciation Rate Schedule).  Column (i) is the carry forward of depreciation reserve from last years annual report.  Book Cost of Plant Retired column (j) should be the same as Retirements During the Year column (e).  Column (k) should reflect cost incurred to remove the plant which was retired.  Column (l) should reflect any money received from the sale or trade-in of the equipment removed or replaced.                           Reserve balance at End of Year column (n) equals (h) plus (i) minus (j) minus (k) plus (l) plus (m).                             "]
["                             ***SAVE A COPY FOR NEXT YEARS BEGINNING BALANCES****"]
[]
["INSTRUCTIONS for PAGE W-7"]
["     On Page W-7, provide historical and statistical information regarding water pumps and wells."]
[]
["INSTRUCTIONS for PAGE W-8"]
["     On Page W-8, provide historical and statistical information regarding water meters, meter settings and storage facilities."]
[]
["INSTRUCTIONS for PAGE W-9"]
["     On Page W-9, provide historical information regarding the feet of water mains and number of service lines by size and type."]
[]
["INSTRUCTIONS for PAGE S-6"]
["On Page S-6, provide historical and statistical information regarding sewer treatment facilities, lift stations and feet of collecting sewers by size and type."]
[]
["'-Instructions Page IX-"]

{"sheet":"Page 1","index":3,"n_rows":81,"n_cols":11,"rows_kept":81,"cut":false,"hidden":false,"merged":[[19,1,19,3],[19,5,19,9],[37,1,37,3],[9,2,9,5],[15,1,15,3],[26,5,26,9],[33,1,33,3],[52,6,52,9],[37,5,37,9],[38,5,38,9],[11,1,11,3],[11,5,11,9],[18,5,18,6],[0,1,0,8],[1,2,1,9],[3,2,3,9],[5,2,5,9],[38,1,38,3],[29,1,29,3],[29,5,29,9],[9,7,9,9],[25,1,25,3],[25,5,25,9],[27,5,27,9],[7,2,7,9],[28,5,28,9],[14,1,14,3],[16,1,16,3],[16,5,16,9],[20,1,20,3],[22,5,22,9],[12,5,12,9],[13,1,13,3],[36,1,36,3],[36,5,36,9],[24,1,24,3],[24,5,24,9],[33,5,33,9],[31,7,31,8],[26,1,26,3],[35,1,35,3],[27,1,27,3],[28,1,28,3],[35,5,35,9],[31,5,31,6],[10,1,10,9],[30,1,30,3],[30,5,30,9],[34,1,34,3],[34,5,34,9],[32,5,32,6],[32,7,32,8],[17,7,17,8],[17,5,17,6],[15,5,15,9],[12,1,12,3],[22,1,22,3],[14,5,14,9],[20,5,20,9],[21,1,21,3],[21,5,21,9],[13,5,13,9],[18,7,18,8]]}
[1,"For the calendar year of January 1 - December 31,",null,null,null,null,null,null,null,{"$f":"IF(Cover!D13>0, Cover!D13, \"\")","v":2012}]
[2,"Company Name:",{"$f":"IF(Cover!A1>0, Cover!A1, \"\")","v":""}]
[]
[null,"Parent Company Name: ","Southtown Utilties Company, Inc."]
[null,"(if applicable)"]
[3,"Company Street Address:","4746 S. 131st Rd"]
[]
[4,"Company Mailing Address: ","PO Box 178, Bolivar, MO 65613"]
[]
[5,"Company Phone Number:","417-326-4424",null,null,null,"Company E-mail Address: ","rondar@windstream.net"]
[null,"Name, address, phone number and e-mail of person(s) to contact concerning information contained in this report:"]
[6,"Ronda Riden",null,null,null,"Richard Fink"]
[null,"Name",null,null,null,"Name"]
[{"$f":"SUM(A12+1)","v":7},"PO Box 178",null,null,null,"PO Box 178"]
[null,"Mailing Address",null,null,null,"Mailing Address"]
["7a","4746 S. 131st Rd",null,null,null,"4746 S. 131st Rd"]
[null,"Street Address",null,null,null,"Street Address"]
[8,"Bolivar","MO",65613,null,"Bolivar",null,"MO ",null,65613]
[null,"City","State","Zip",null,"City",null,"State",null,"Zip"]
[9,"417-326-4424",null,null,null,"417-326-4424"]
[null,"Telephone Number",null,null,null,"Telephone Number"]
[10,"rondar@windstream.net",null,null,null,"none"]
[null,"E-mail Address",null,null,null,"E-mail Address"]
[]
[null,"Please list the name, address, phone number and e-mail address of the primary licensed operator to contact concerning water plant operations:",null,null,null,"Please list the name, address, phone number and e-mail address of the primary licensed operator to contact concerning sewer plant operations:"]
[11,"Larry D. Jenkins",null,null,null,"Larry D. Jenkins"]
[null,"Name",null,null,null,"Name"]
[12,"PO Box 178",null,null,null,"PO Box 178"]
[null,"Mailing Address",null,null,null,"Mailing Address"]
["12a"]
[null,"Street Address",null,null,null,"Street Address"]
[13,"Bolivar","MO",65613,null,"Bolivar",null,"MO ",null,65613]
[null,"City","State","Zip",null,"City",null,"State",null,"Zip"]
[14,"417-326-4424",null,null,null,"417-326-4424"]
[null,"Telephone Number",null,null,null,"Telephone Number"]
[15]
[null,"E-mail Address",null,null,null,"E-mail Address"]
[16,"CN4432",null,null,null,"CN4432"]
[null,"Operator License Number ",null,null,null,"Operator License Number "]
[" ","Please provide the total company and gross intrastate operating revenues (i.e. Missouri Jurisdictional) Revenues"]
[null,"for the Calendar Year:",{"$f":"IF(Cover!D13>0, Cover!D13, \"\")","v":2012}]
[null,"Water Revenues",null,null,null,"**","MO Jurisdictional","**","**","Total Company","**"]
[{"$f":"A38+1","v":17},"Operating Revenues from Tariffed Services",null,null,null,null,{"$f":"'Page W-2'!G15+'Page W-2'!G23","v":38567.25},null,null,38567.25]
[{"$f":"A43+1","v":18},"Other Revenues",null,null,null,null,{"$f":"SUM('Page W-2'!G31)","v":4850},null,null,4850]
[{"$f":"A44+1","v":19},"TOTAL REVENUES (Page W-2,  line 24)",null,null,null,null,{"$f":"SUM(G43:G44)","v":43417.25},null,null,{"$f":"SUM(J43:J44)","v":43417.25}]
[null,"Total MO Jurisdictional Revenue (line 19 above) should match Statement of Revenue (MoPSC Assessment)."]
[]
[null,"Sewer Revenues",null,null,null,"**","MO Jurisdictional","**","**","Total Company","**"]
[{"$f":"A45+1","v":20},"Operating Revenues from Tariffed Services",null,null,null,null,{"$f":"SUM('Page S-2'!G20+'Page S-2'!G15)","v":38024.29},null,null,38024.29]
[{"$f":"A49+1","v":21},"Other Revenues",null,null,null,null,{"$f":"SUM('Page S-2'!G28)","v":12751},null,null,12751]
[{"$f":"A50+1","v":22},"TOTAL REVENUES (Page S-2,  line 21)",null,null,null,null,{"$f":"SUM(G49:G50)","v":50775.29},null,null,{"$f":"SUM(J49:J50)","v":50775.29}]
[null,"Total MO Jurisdictional Revenue (line 22 above) should match Statement of Revenue (MoPSC Assessment)."]
[null,"Indicates a link to another worksheet within workbook"]
[null,"Indicates formula cell(s)",null,null,null,null,null,null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Public"]
[null,null,null,null,null,null,null,null,null,"Highly Confidential"]

{"sheet":"Page 2","index":4,"n_rows":76,"n_cols":8,"rows_kept":76,"cut":false,"hidden":false,"merged":[[2,1,2,7],[3,1,3,7],[4,1,4,3],[12,1,12,7],[5,1,5,3],[5,4,5,5],[6,1,6,3],[6,4,6,5],[4,4,4,5],[9,4,9,5],[10,1,10,7],[11,1,11,7],[7,1,7,3],[7,4,7,5],[8,1,8,3],[8,4,8,5],[1,3,1,7],[28,5,28,7],[29,5,29,7],[21,1,21,6],[22,1,22,6],[18,1,18,6],[19,1,19,6],[20,1,20,6],[13,1,13,7],[9,1,9,3],[26,1,26,7],[31,5,31,7],[32,5,32,7],[33,5,33,7],[27,5,27,7],[31,1,31,3],[32,1,32,3],[33,1,33,3],[48,6,48,7],[14,1,14,6],[27,1,27,3],[28,1,28,3],[29,1,29,3],[30,1,30,3],[15,1,15,6],[16,1,16,6],[17,1,17,6],[30,5,30,7]]}
[1,null,null,null,null,null,"For the calendar year of January 1 - December 31,",{"$f":"IF(Cover!D13>0, Cover!D13, \"\")","v":2012}]
[2,null,"Company Name:",{"$f":"IF(Cover!A1>0, Cover!A1, \"\")","v":""}]
[]
[null,"CAPITAL STOCK (COMMON AND DEFERRED)"]
[null,"Class and Series of Stock\n(a)",null,null,"Number of Shares Authorized\n (b)",null,"Par or Stated Value Per Share\n (c)","Number of \nShares Issued \n(d)"]
[3,"Common",null,null,500,null,1,500]
[4]
[5]
[6]
[7]
[]
[null,"SECURITY HOLDERS AND VOTING POWERS"]
[null,"Report below the NAMES and ADDRESS of the ten stockholders who, at the end of the year, had the greatest voting powers in the respondent.  AND STATE THE NUMBER OF VOTES each would have had a right to cast on that date.  If any such holder held in trust, give the nature of the trust and the beneficial owner.  Show also total votes of ALL securities with voting powers."]
[]
[null,"Names and Addresses\n(a)",null,null,null,null,null,"Number of Votes \n(b)"]
[8,"Richard Fink, PO Box 406, Bolivar, MO 65613",null,null,null,null,null,1]
[9,"Earl Spiegel, PO Box 178, Bolivar, MO 65613",null,null,null,null,null,1]
[10]
[11]
[12]
[13]
[14]
[15]
[16,"Total Number of Votes Held by Above",null,null,null,null,null,{"$f":"IF(SUM(H16:H23)>0, SUM(H16:H23), \"\")","v":2}]
[17,"Total Number of Votes of all Securities with Voting Powers"]
[]
[null,"Identify the principal or general officers of the company at the end of the year.  Please include an additional sheet, if enough space is not provided on this page, to completely provide the requested information."]
[null,"Title of General Officer",null,null,null,"Name of Person Holding Office"]
[18,"President",null,null,null,"Richard Fink"]
[19,"Vice-President",null,null,null,"Earl Spiegel"]
[20,"Sec/Tres",null,null,null,"Ronda Riden"]
[21]
[22]
[23]
[]
[null,"Please check all of the following for which the company has filed / is current: "]
[27,"x","Secretary of State Requirements",null,"x","Federal Tax Return"]
[]
[28,"x","Department of Natural Resources Permits",null,"x","State Tax Return"]
[]
[29,"DNR Permit Number: ",null,"MO0121924","(If you hold more than one permit, please attach list.)"]
[30,"Original DNR Permit Date: ",null,"2003-03-13"]
[31,"DNR Permit Expiration Date: ",null,"2013-03-12"]
[]
[null,"Please list your most recent rate increase request Case No(s). and effective date(s). "]
[32,"Water Case No.: ",null,"none",null,"Effective Date:","none"]
[33,"Sewer Case No.: ",null,"none",null,"Effective Date:","none"]
[]
[]
[null,null,"Indicates formula cell(s)",null,null,null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Public"]
[null,null,null,null,"Highly Confidential"]

{"sheet":"Page 3","index":5,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,1,0,2],[1,1,2,1],[1,2,2,3],[4,1,4,3],[3,1,3,3],[13,1,13,3],[14,1,14,3],[5,1,5,3],[6,1,6,3],[7,1,7,3],[8,1,8,3],[28,1,28,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[26,1,26,3],[9,1,9,3],[10,1,10,3],[12,1,12,3],[15,1,15,3],[11,1,11,3],[29,1,29,3],[30,1,30,3],[16,1,16,3],[17,1,17,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[27,1,27,3],[25,1,25,3],[21,1,21,3]]}
[1,"For the calendar year of January 1 - December 31,",null,{"$f":"IF(Cover!D13>0, Cover!D13, \"\")","v":2012}]
[null,"Company Name:",{"$f":"IF(Cover!A1>0, Cover!A1, \"\")","v":""}]
[2]
[null,"Describe MAJOR transactions occurring during the year which will have a major effect on operations, such as rate changes,  replacement of equipment and other abnormal cash expenditures of $250 or more."]
[3,"2005 Chevrolet Pickup for operator to use during service of system,  $9,250.00  12/4/12"]
[4,"Cotor Inc. Generator, 3 phase for WWTP, $3,100, 11/27/12"]
[5,"Paved driveway/parking are at WWTP, $1,069.75 12/19/12"]
[6,"Installed Blower - Reactor Tank Odor Control, $900.46, 1-9-2012"]
[7,"Replaced Check Valve #1 Booster Pump Well #2,  $66.15, 6-11-2012"]
[8,"Control Panel S. 130th Rd Lift Station, $990.29, 12-17-2012"]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[27]
[28]
[29]
[30]

{"sheet":"Page 4","index":6,"n_rows":48,"n_cols":7,"rows_kept":48,"cut":false,"hidden":false,"merged":[[28,3,28,5],[26,1,26,3],[6,0,6,6],[7,1,7,5],[10,2,10,3],[17,2,17,3],[27,1,27,6],[11,1,11,3],[18,1,18,3],[5,1,5,5],[8,1,8,3],[1,1,1,5],[2,2,2,5],[3,1,3,5],[4,1,4,5]]}
[1,null,null,null,"For the calendar year of January 1 - December 31,",{"$f":"IF(Cover!D13>0, Cover!D13, \"\")","v":2012}]
[]
[2,"Company Name:",{"$f":"IF(Cover!A1>0, Cover!A1, \"\")","v":""}]
[]
[null,"NOTE: Please do not type over formulas.  Totals will calculate automatically in this spreadsheet."]
[]
["BALANCE SHEET\nWATER AND SEWER OPERATIONS\nASSETS"]
[]
[null,"Account Description\n(a)",null,null,"**","Amount\n(b)","**"]
[3,"Water Plant In Service (From Pg. W-5)",null,null,null,{"$f":"'Page W-5'!I59","v":581017.50000000012}]
[4,"    LESS:","Water Depreciation Reserve (From Pg. W-6)",null,null,{"$f":"'Page W-6'!K59","v":141222.65}]
[5,"Net Water Plant in Service (i.e., Water Plant In Service MINUS Water Depreciation Reserve)",null,null,null,{"$f":"SUM(F10-F11)","v":439794.85000000009}]
[6,"Water Materials and Supplies (From Pg. 11)",null,null,null,{"$f":"'Page 11'!E30","v":44733.270000000004}]
[7,"Water Construction Work in Progress",null,null,null,0]
[8,"Water Plant Held for Future Use (List explanation on Page 4a)"]
[9,"Water Plant Acquisition Adjustment"]
[10,"Sewer Plant in Service (From Pg. S-4)",null,null,null,{"$f":"'Page S-4'!I48","v":432692.96}]
[11,"    LESS:","Sewer Depreciation Reserve (From Pg. S-5)",null,null,{"$f":"'Page S-5'!K49","v":48270.609999999993}]
[12,"Net Sewer Plant in Service (i.e., Sewer Plant in Service MINUS Sewer Depreciation Reserve)",null,null,null,{"$f":"SUM(F17-F18)","v":384422.35000000003}]
[13,"Sewer Materials and Supplies (From Pg. 11)",null,null,null,{"$f":"'Page 11'!G30","v":2836.47}]
[14,"Sewer Construction Work in Progress",null,null,null,0]
[15,"Sewer Plant Held for Future Use (List explanation on Page 4a)"]
[16,"Sewer Plant Acquisition Adjustment"]
[17,"Other Plant (List explanation on Page 4a)"]
[18,"Cash"]
[19,"Other Assets (Accounts Receivable, etc.)  (List explanation on Page 4a)"]
[20,"Total Assets*",null,null,null,{"$f":"SUM(F12:F16)+SUM(F19:F26)","v":871786.94000000018}]
["*","Total Assets should balance with Total Equity and Liabilities on Page 5 (see instructions).  Difference between \nEquity & Liabilities and Assets (from Pg 5). "]
[null,"Indicates a link to another worksheet within workbook"]
[null,"Indicates formula cell(s)",null,null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Public"]
[null,null,null,"Highly Confidential"]

{"sheet":"Page 4a","index":7,"n_rows":61,"n_cols":6,"rows_kept":61,"cut":false,"hidden":false,"merged":[[36,1,36,3],[37,1,37,3],[38,1,38,3],[41,3,41,4],[39,1,39,3],[34,1,34,3],[35,1,35,3],[29,1,29,3],[30,1,30,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[28,1,28,3],[21,1,21,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[12,1,12,3],[20,1,20,3],[19,1,19,3],[18,1,18,3],[1,2,1,4],[3,0,3,4],[16,1,16,3],[17,1,17,3],[10,1,10,3],[11,1,11,3]]}
[1,null,null,"For the calendar year of January 1 - December 31,",{"$f":"IF(Cover!D13>0, Cover!D13,\"\")","v":2012}]
[2,"Company Name:",{"$f":"IF(Cover!A1>0, Cover!A1, \"\")","v":""}]
[]
["DETAILED EXPLANATION OF ITEMS"]
[]
[3,"Page 4, Line 8","Water Plant Held for Future Use ",{"$f":"'Page 4'!F15","v":0}]
["**","Description",null,null,"Amount","**"]
[null,null,null,null,0]
[]
[]
[]
[]
[null,"Total (should match amount on Page 4, Line 8)",null,null,{"$f":"SUM(E8:E12)","v":0}]
[]
[4,"Page 4, Line 15","Sewer Plant Held for Future Use ",{"$f":"'Page 4'!F22","v":0}]
["**","Description",null,null,"Amount","**"]
[null,null,null,null,0]
[]
[]
[]
[]
[null,"Total (should match amount on Page 4, Line 15)",null,null,{"$f":"SUM(E17:E21)","v":0}]
[]
[5,"Page 4, Line 17","Other Plant ",{"$f":"'Page 4'!F24","v":0}]
["**","Description",null,null,"Amount","**"]
[null,null,null,null,0]
[]
[]
[]
[]
[null,"Total (should match amount on Page 4, Line 17)",null,null,{"$f":"SUM(E26:E30)","v":0}]
[]
[5,"Page 4, Line 19","Other Assets ",{"$f":"'Page 4'!F26","v":0}]
["**","Description",null,null,"Amount","**"]
[null,null,null,null,0]
[]
[]
[]
[]
[null,"Total (should match amount on Page 4, Line 19)",null,null,{"$f":"SUM(E35:E39)","v":0}]
[]
[null,"Indicates a link to another worksheet within workbook"]
[null,"Indicates formula cell(s)",null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Public"]
[null,null,null,"Highly Confidential"]

{"sheet":"Page 5","index":8,"n_rows":62,"n_cols":6,"rows_kept":62,"cut":false,"hidden":false,"merged":[[29,3,29,4],[28,1,28,5],[7,1,7,2],[1,2,1,4],[2,1,2,4],[3,1,3,4],[4,1,4,4],[5,0,5,5],[6,1,6,4]]}
[1,null,null,"For the calendar year of January 1 - December 31,",{"$f":"IF(Cover!D13>0, Cover!D13, \"\")","v":2012}]
[2,"Company Name:",{"$f":"IF(Cover!A1>0, Cover!A1, \"\")","v":""}]
[]
[null,"NOTE: Please do not type over formulas.  Totals will calculate automatically in this spreadsheet."]
[]
["BALANCE SHEET\nWATER AND SEWER OPERATIONS\nEQUITY AND LIABILITIES"]
[]
[null,"Account Description\n(a)",null,"**","Amount\n(b)","**"]
[3,"Capital Stock"]
[4,"Retained Earnings",null,null,-183500.91]
[5,"Long-Term Debt to Affiliates (owners, other owner controlled companies, etc.)",null,null,100000]
[6,"Short-Term Debt to Affiliates (owners, other owner controlled companies, etc.)",null,null,53256.98]
[7,"Long-Term Debt (banks, etc.)"]
[8,"Short-Term Debt (banks, etc.)"]
[9,"Water Customer Deposits",null,null,0]
[10,"Water Advances for Construction"]
[11,"Water CIAC (From Pg. 9)",null,null,{"$f":"'Page 9'!D21","v":483827.28}]
[12,"    LESS:","Water Amortization of CIAC (From Pg. 9)",null,{"$f":"'Page 9'!D34","v":17673.753143865029}]
[13,"Net Water CIAC (i.e., Water CIAC MINUS Water Amortization of CIAC)",null,null,{"$f":"E17-E18","v":466153.52685613499}]
[14,"Sewer Customer Deposits"]
[15,"Sewer Advances for Construction"]
[16,"Sewer CIAC (From Pg. 9)",null,null,{"$f":"'Page 9'!E21","v":449416.37}]
[17,"    LESS:",null,null,{"$f":"'Page 9'!E34","v":13539.026044129305}]
[18,"Net Sewer CIAC (i.e., Sewer CIAC Minus Sewer Amortization of CIAC)",null,null,{"$f":"E22-E23","v":435877.34395587072}]
[19,"Deferred Taxes - ITC"]
[20,"Deferred Taxes - Other  (List explanation on Page 5a)"]
[21,"Other Liabilities (Accounts Payable, etc.)  (List explanation on Page 5a)"]
[22,"          Total Equity and Liabilities*",null,null,{"$f":"SUM(E9:E16,E19,E20:E21,E24,E25:E27)","v":871786.94081200566}]
[null,"* Total Equity and Liabilities should balance with Total  Assets on Page 4 (see instructions).  \n    Difference between Equity & Liabilities and Assets (from Pg 4)."]
[null,"Indicates a link to another worksheet within workbook"]
[null,"Indicates formula cell(s)",null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Public"]
[null,null,null,null,"Highly Confidential"]

{"sheet":"Page 5a","index":9,"n_rows":61,"n_cols":6,"rows_kept":61,"cut":false,"hidden":false,"merged":[[41,3,41,4],[29,1,29,3],[30,1,30,3],[34,1,34,3],[35,1,35,3],[36,1,36,3],[37,1,37,3],[25,1,25,3],[26,1,26,3],[38,1,38,3],[39,1,39,3],[27,1,27,3],[28,1,28,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[11,1,11,3],[12,1,12,3],[16,1,16,3],[17,1,17,3],[9,1,9,3],[10,1,10,3],[1,2,1,4],[3,0,3,4],[7,1,7,3],[8,1,8,3]]}
[1,null,null,"For the calendar year of January 1 - December 31,",{"$f":"IF(Cover!D13>0, Cover!D13,\"\")","v":2012}]
[2,"Company Name:",{"$f":"IF(Cover!A1>0, Cover!A1, \"\")","v":""}]
[]
["DETAILED EXPLANATION OF ITEMS"]
[]
[3,"Page 5, Line 20","Deferred Taxes - Other ",{"$f":"'Page 5'!E26","v":0}]
["**","Description",null,null,"Amount","**"]
[null,"none",null,null,0]
[]
[]
[]
[]
[null,"Total (should match amount on Page 5, Line 20)",null,null,{"$f":"SUM(E8:E12)","v":0}]
[]
[4,"Page 5, Line 21","Other Liabilities (Accounts Payable, etc.) ",{"$f":"'Page 5'!E27","v":0}]
["**","Description",null,null,"Amount","**"]
[null,"none",null,null,0]
[]
[]
[]
[]
[null,"Total (should match amount on Page 5, Line 21)",null,null,{"$f":"SUM(E17:E21)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Indicates a link to another worksheet within workbook"]
[null,"Indicates formula cell(s)",null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Public"]
[null,null,null,"Highly Confidential"]

{"sheet":"Page 6","index":10,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[2,1,2,5],[1,2,1,5],[37,1,37,5],[38,4,38,5],[39,4,39,5],[3,1,3,6],[4,1,4,5],[5,4,5,5],[5,1,6,1],[5,2,6,2]]}
[1,null,null,null,"For the calendar year of January 1 - December 31,",{"$f":"IF(Cover!D13>0, Cover!D13, \"\")","v":2012}]
[2,"Company Name:",{"$f":"IF(Cover!A1>0, Cover!A1, \" \")","v":" "}]
[]
[null,"SCHEDULE OF UNCOLLECTIBLE ACCOUNTS"]
[]
[null,"Account\n No.\n (a)","Describe customer account and\nmethods used to attempt collection.  Also, state why account is deemed uncollectible (bankruptcy, etc.)\n(b)",null,"Amount Written Off"]
[null,null,null,"**","Water\nUtility\n (c)","Sewer\nUtility\n (d)","**"]
[3,"None","None",null,0,0]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31,null,"Total ",null,{"$f":"SUM(E8:E35)","v":0},{"$f":"SUM(F8:F35)","v":0}]
[null,null,null,null,"(Total to Pg. W-1)","(Total to Pg. S-1)"]
[]
[]
[null,"Indicates formula cell(s)",null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Public"]
[null,null,null,null,"Highly Confidential"]

{"sheet":"Page 7","index":11,"n_rows":43,"n_cols":9,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,1,0,5],[1,1,1,5],[1,7,4,7],[1,8,22,8],[2,1,2,5],[3,1,3,5],[4,2,4,5],[4,1,5,1],[23,0,25,0],[26,4,26,5],[23,8,25,8],[24,1,24,5],[25,1,25,3],[25,4,25,5],[5,7,25,7]]}
[null,"PAYROLL INFORMATION",null,null,null,null,null,2,1]
[null,null,null,null,null,null,null,"  Company Name:","For the calendar year of January 1 - December 31,"]
[null,"INSTRUCTIONS:  Please provide names, titles and salaries for all officers and employees.  Show total compensation paid to each during the year.  Include all amounts including bonuses and other allowances.  Enter \"0\" or none where applicable.  Provide explanations where necessary.  Use additional sheets if necessary."]
[null," "]
[null,"Name and Title\n(a)","Payroll Charged To:"]
[null,null,"Total Utility\nCompensation \n(b)","Water\nExpense\n(c)","Sewer\nExpense\n(d)","Capitalized\nPayroll\n(e)",null,{"$f":"IF(Cover!A1>0, Cover!A1, \"\")","v":""}]
[3,"Richard Fink, President",0,0,0,0]
[4,"Earl Spiegel, Vice-President",0,0,0,0]
[5,"Ronda Riden, Sec/Tres",0,0,0,0]
[6,"Larry D. Jenkins",13821,6910.5,6910.5]
[7,"Bill Crouch",13602.37,6801.19,6801.18]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19,"Total",{"$f":"SUM(C7:C22)","v":27423.370000000003},{"$f":"SUM(D7:D22)","v":13711.689999999999},{"$f":"SUM(E7:E22)","v":13711.68},{"$f":"SUM(F7:F22)","v":0}]
["Page 7",null,null,"(Total to Page W-1)","(Total to Page S-1)",null,null,null,{"$f":"IF(Cover!D13>0, Cover!D13, \"\")","v":2012}]
[]
[]
[null,"Indicates formula cell(s)",null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Public"]
[null,null,null,null,"Highly Confidential"]

{"sheet":"Page 8","index":12,"n_rows":44,"n_cols":9,"rows_kept":44,"cut":false,"hidden":false,"merged":[[26,4,26,5],[5,7,26,7],[5,2,5,3],[5,4,5,5],[4,1,6,1],[24,0,26,0],[0,1,0,5],[1,7,4,7],[27,4,27,5],[1,8,23,8],[2,1,2,5],[4,2,4,5],[24,8,26,8],[25,1,25,5]]}
[null,"PAYMENTS FOR SERVICES RENDERED BY OTHER THAN EMPLOYEES",null,null,null,null,null,2,1]
[null,null,null,null,null,null,null,"  Company Name:","For the calendar year of January 1 - December 31,"]
[null,"INSTRUCTIONS:  Report below all information concerning rate, management, construction, engineering, research, financial, valuation, legal, accounting, purchasing, advertising, labor relations, public relations, or other similar professional services rendered the respondent under written or verbal arrangements, for which total payments during the year to any corporation, partnership, individual (other than for services as an employee) or organization of any kind whatsoever.  Use additional sheets if necessary."]
[]
[null,"Name of Recipient and Description of Service\n(a)","Amount of Payments:"]
[null,null,"Water",null,"Sewer",null,null,{"$f":"IF(Cover!A1>0, Cover!A1, \"\")","v":""}]
[null,null,"Expensed\n(b)","Capitalized\n(c)","Expensed\n(d)","Capitalized\n(e)"]
[3,"George Williams, CPA",212.5,null,212.5]
[4,"Douglas, Haun & Heidmann (attorney)",105.5,null,105.5]
[5,"MoDNR (Sewer Plant Permit Fee)",0,null,3000]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19,"Total",{"$f":"SUM(C8:C23)","v":318},{"$f":"SUM(D8:D23)","v":0},{"$f":"SUM(E8:E23)","v":3318},{"$f":"SUM(F8:F23)","v":0}]
["Page 8",null,"(Total to Page W-1)",null,"(Total to Page S-1)",null,null,null,{"$f":"IF(Cover!D13>0, Cover!D13, \"\")","v":2012}]
[]
[]
[null,"Indicates formula cell(s)",null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Public"]
[null,null,null,null,"Highly Confidential"]

{"sheet":"Page 9","index":13,"n_rows":61,"n_cols":5,"rows_kept":61,"cut":false,"hidden":false,"merged":[[2,1,2,4],[3,1,3,4],[4,1,4,4],[1,2,1,4],[13,1,13,2],[5,1,5,4],[6,1,6,2],[34,1,34,2],[24,1,24,4],[19,1,19,2],[22,1,22,4],[23,1,23,4],[35,1,35,4],[28,1,28,2],[29,1,29,2],[25,1,25,4],[26,1,26,2],[27,1,27,2],[36,1,36,4],[37,1,37,2],[38,1,38,2],[41,1,41,2],[43,3,43,4],[44,3,44,4],[39,1,39,2],[40,1,40,2]]}
[1,null,null,"For the calendar year of January 1 - December 31,",{"$f":"IF(Cover!D13>0, Cover!D13,\"\")","v":2012}]
[2,"Company Name:",{"$f":"IF(Cover!A1>0, Cover!A1, \"\")","v":""}]
[]
[null,"CONTRIBUTIONS IN AID OF CONSTRUCTION"]
[null,"INSTRUCTIONS:  This account shall include donations or contributions in cash, services, or property for construction purposes.  \nThe records supporting the entries to this account shall be so kept that the utility can furnish information as to the purpose of each donation, the conditions, if any, upon which it was made, the amount of each donation, and the amount applicable to each utility department.  The credits (deductions) to this account shall not be transferred to any other account without the approval of the Commission."]
[]
[null,"(a)",null,"Water\n(b)","Sewer\n(c)"]
[3,"Balance at Beginning of Year",null,483827.28,449416.37]
[4,"PLUS:  ","Additions During the Year (Please provide a detailed explanation.)"]
[5," "]
[6]
[7]
[8]
[10,"Total Additions",null,{"$f":"SUM(D9:D13)","v":0},{"$f":"SUM(E9:E13)","v":0}]
[11,"LESS: "," Deductions During the Year (Please provide a detailed explanation.)"]
[12,null,"None"]
[13]
[14,"Retire and cap off service connection, but no connection fee money returned  = no entry here"]
[15]
[16,"Total Deductions",null,{"$f":"SUM(D15:E19)","v":0},{"$f":"SUM(E15:F19)","v":0}]
[17,"Balance at End of Year",null,{"$f":"D8+D14-D20","v":483827.28},{"$f":"E8+E14-E20","v":449416.37}]
[null,null,null,"(Total to Pg. 5)","(Total to Pg. 5)"]
[]
[null,"AMORTIZATION OF CONTRIBUTIONS IN AID OF CONSTRUCTION"]
[null,"(Please identify as Account Number 271A)"]
[null,"Distribution Method"]
[null,"(a)",null,"Water\n(b)","Sewer\n(c)"]
[18,"Balance at First of Year (Total of Amortization not Total of CIAC line 3)"]
[19,"Total Contributions in Aid at End of Year (see above)",null,{"$f":"D21","v":483827.28},{"$f":"E21","v":449416.37}]
[20,"Total Plant in Service at End of Year (From Page W-5 or S-4)",null,{"$f":"'Page W-5'!I59","v":581017.50000000012},{"$f":"'Page S-4'!I48","v":432692.96}]
[21,"Percentage Contributions to Plant",null,{"$f":"IF(D30=0, \"0.00%\", D29/D30)","v":0.83272410899843796},{"$f":"IF(E30=0, \"0.00%\",E29/E30)","v":1.0386496004002468}]
[22,"Total Depreciation Expense (From Page W-6 or S-5)",null,{"$f":"'Page W-6'!E59","v":21224.02},{"$f":"'Page S-5'!E49","v":13035.22}]
[23,"Total Amortization of Contributions",null,{"$f":"D31*D32","v":17673.753143865029},{"$f":"E31*E32","v":13539.026044129305}]
[24,"Balance at End of Year",null,{"$f":"D28+D33","v":17673.753143865029},{"$f":"E28+E33","v":13539.026044129305}]
[null,null,null,"(Total to Pg. 5)","(Total to Pg. 5)"]
[null,"OR"]
[null,"Attached Method"]
[null,"(a)",null,"Water\n(b)","Sewer\n(c)"]
[25,"Balance at First of Year (Total of Amortization not Total of CIAC line 3)"]
[26,"Total Amortization of Contributions",null,0,0]
[27,"Balance at End of Year",null,{"$f":"SUM(D39:E40)","v":0},{"$f":"SUM(E39:F40)","v":0}]
[null,null,null,"(Total to Pg. 5)","(Total to Pg. 5)"]
[]
[null,"Indicates a link to another worksheet within workbook"]
[null,"Indicates formula cell(s)",null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Public"]
[null,null,null,"Highly Confidential"]

{"sheet":"Page 10","index":14,"n_rows":47,"n_cols":14,"rows_kept":47,"cut":false,"hidden":false,"merged":[[29,8,29,10],[30,8,30,10],[10,13,22,13],[4,12,24,12],[3,8,4,8],[1,12,3,12],[23,13,26,13],[0,1,0,10],[1,1,1,10],[2,1,2,10],[3,9,3,10],[3,1,4,1],[3,7,4,7],[26,0,27,0],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,3,4,3],[3,2,4,2],[27,1,27,9],[26,1,26,9]]}
[null,"INTEREST EXPENSE, NOTES PAYABLE, BONDS, BANK LOANS AND OTHER DEBTS",null,null,null,null,null,null,null,null,null,null,2,1]
[null,null,null,null,null,null,null,null,null,null,null,null,"  Company Name:"]
[null,"INSTRUCTIONS:  Please report information for each separate item of debt.  Show principal amount to which each interest rate applies.  Include all items on which interest was paid during the year.  Use additional sheets if necessary."]
[null,"Description of Obligation \n(Include Name and Address of Each Lender)\n (a)","Origination\n Date\n(b)","Frequency of Payments\n(Semi-Monthly, \nMonthly, Quarterly, \nAnnually, etc.)\n(c)","Date of\nMaturity\n(d)","Loan\nAmount\n(e)","Interest\nRate\n(f)","Is Interest Rate Fixed or Variable?\n(g)","Paid\n(h)","Interest Charged To:"]
[null,null,null,null,null,null,null,null,null,"Water\nUtility\n(i)","Sewer\nUtility\n(j)",null,{"$f":"IF(Cover!A1>0, Cover!A1, \"\")","v":""}]
[3,"Sewer Plant Phas 3 Addition","2008-02-01","Semi-Annual","2013-02-01",100000,0.06,"fixed"]
[4]
[5]
[6]
[7]
[8,null,null,null,null,null,null,null,null,null,null,null,null,"For the calendar year of January 1 - December 31,"]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21,"Total",null,null,null,{"$f":"SUM(F6:F23)","v":100000},null,null,{"$f":"SUM(I6:I23)","v":0},{"$f":"SUM(J6:J23)","v":0},{"$f":"SUM(K6:K23)","v":0},null,null,{"$f":"IF(Cover!D13>0,Cover!D13, \"\")","v":2012}]
[null,null,null,null,null,null,null,null,null,"(Total to\n Pg. W-1)","(Total to\n Pg. S-1)"]
["Page 10"]
["Page 10","22.   If the answer to column (g) is variable, please explain the method used for the interest rate calculation below with corresponding line number from above. "]
[]
[]
[null,"Indicates formula cell(s)"]
[null,null,null,null,null,null,null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Public"]
[null,null,null,null,null,null,null,null,"Highly Confidential"]

{"sheet":"Page 11","index":15,"n_rows":50,"n_cols":7,"rows_kept":50,"cut":false,"hidden":false,"merged":[[16,1,16,2],[2,1,2,6],[3,1,3,6],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[1,2,1,6],[7,1,7,2],[8,1,8,2],[9,1,9,2],[4,1,4,6],[5,3,5,4],[5,1,6,2],[5,5,5,6],[21,1,21,2],[22,1,22,2],[28,1,28,2],[14,1,14,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[23,1,23,2],[15,1,15,2],[32,4,32,6],[33,4,33,6],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[30,1,30,2],[31,1,31,6]]}
[1,null,null,null,null,"For the calendar year of January 1 - December 31,",{"$f":"IF(Cover!D13>0, Cover!D13,\"\")","v":2012}]
[2,"Company Name:",{"$f":"IF(Cover!A1>0, Cover!A1, \"\")","v":""}]
[]
[null,"SCHEDULE OF MATERIALS AND SUPPLIES AVAILABLE AT THE END OF THE YEAR"]
[]
[null,"Description of Items\n(Pipe, Meters, Fittings, Valves, Gas, etc.)\n(a)",null,"Water",null,"Sewer"]
[null,null,null,"Quantity\n(b)","Amount\n(c)","Quantity\n(d)","Amount\n(e)"]
[3,"8\" Class 200",null,"346'",2224.7800000000002]
[4,"6\" Class 200",null,"40'",155.78]
[5,"Brass Fittings",null,487,19971.87]
[6,"1\" Tubing",null,"180'",77.400000000000006]
[7,"3/4\" Tubing",null,"100'",39]
[8,"1\" Copper",null,"8'",49.98]
[9,"3/4\" Copper",null,"120'",1076]
[10,"PVC Sch 80 Fittings",null,153,687.43]
[11,"Water Meters",null,6,404.88]
[12,"Meter Pits and Lids",null,9,538.21]
[13,"4\" MJ Fittings",null,101,3755.84]
[14,"6\" MJ Fittings",null,98,4495.9399999999996]
[15,"8\" MJ Fittings",null,93,11256.16]
[16,"8\" SDR 35",null,null,null,"312'",1503.84]
[17,"PVC Fittings",null,null,null,273,1228.5]
[18,"Primer",null,null,null,5,65.45]
[19,"Glue",null,null,null,4,38.68]
[20]
[21]
[22]
[23]
[24]
[25,"Total",null,{"$f":"SUM(D8:D29)","v":947},{"$f":"SUM(E8:E29)","v":44733.270000000004},{"$f":"SUM(F8:F29)","v":282},{"$f":"SUM(G8:G29)","v":2836.47}]
[null,null,null,null,"(Total to Pg. 4)",null,"(Total to Pg. 4)"]
[]
[]
[null,"Indicates formula cell(s)",null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Public"]
[null,null,null,null,"Highly Confidential"]

{"sheet":"Page W-1","index":16,"n_rows":48,"n_cols":5,"rows_kept":48,"cut":false,"hidden":false,"merged":[[30,3,30,4],[29,1,29,4],[1,1,1,4],[3,1,3,4],[4,1,4,4],[5,1,5,4],[6,1,6,3],[2,2,2,4],[28,1,28,3]]}
[1,null,null,"For the calendar year of January 1 - December 31,",{"$f":"IF(Cover!D13>0, Cover!D13, \"\")","v":2012}]
[]
[2,"Company Name:",{"$f":"IF(Cover!A1>0, Cover!A1, \"\")","v":""}]
[]
[null,"WATER OPERATING REVENUES, EXPENSES AND STATISTICS"]
[]
[null,"(a)",null,null,"Amount\n(b)"]
[3,"Total Operating Revenues (From Page W-2)",null,null,{"$f":"'Page W-2'!G32","v":43417.25}]
[null,"Operating Expenses"]
[4,"Salaries & Wages (From Page 7)",null,null,{"$f":"SUM('Page 7'!D23)","v":13711.689999999999}]
[5,"Employee Pensions and Benefits",null,null,0]
[6,"Purchased Water",null,null,0]
[7,"Plant Operations Expenses (From Page W-3)",null,null,{"$f":"'Page W-3'!E17","v":8028.5700000000006}]
[8,"Billing Expenses",null,null,673.86]
[9,"Supplies and Expenses"]
[10,"Transportation Expenses",null,null,2853.51]
[11,"Rent Expense (List explanation on Page W-1a)",null,null,0]
[12,"Insurance Expense",null,null,2478.61]
[13,"Outside Services Employed (i.e.., Legal, Accounting, etc.) (From Page 8)",null,null,{"$f":"'Page 8'!C24","v":318}]
[14,"Regulatory Commission Expenses",null,null,837.69]
[15,"Uncollectible Expenses (From Page 6)",null,null,{"$f":"'Page 6'!E36","v":0}]
[16,"Depreciation Expense (From Page W-6)",null,null,{"$f":"'Page W-6'!E59","v":21224.02}]
[17,"Amortization of Contributions in Aid of Construction (Page 9)  ",null,null,{"$f":"-('Page 9'!D33+'Page 9'!D40)","v":-17673.753143865029}]
[18,"Amortization Expense"]
[19,"Tax Expenses (From Page W-3)",null,null,{"$f":"'Page W-3'!E27","v":274.18}]
[20,"Interest Expense (From Page 10)",null,null,{"$f":"'Page 10'!J24","v":0}]
[21,"Other Expenses (List explanation on Page W-1a)",null,null,374.87]
[22,"Total Operating Expenses",null,null,{"$f":"SUM(E10:E27)","v":33101.246856134967}]
[23,"Net Income (Loss) \n(A negative number indicated by ( ) represents a loss.)",null,null,{"$f":"SUM(E8-E28)","v":10316.003143865033}]
[]
[null,"Indicates a link to another worksheet within workbook"]
[null,"Indicates formula cell(s)",null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Public"]
[null,null,null,"Highly Confidential"]

{"sheet":"Page W-1a","index":17,"n_rows":61,"n_cols":6,"rows_kept":61,"cut":false,"hidden":false,"merged":[[41,3,41,4],[29,1,29,3],[30,1,30,3],[34,1,34,3],[35,1,35,3],[36,1,36,3],[37,1,37,3],[25,1,25,3],[26,1,26,3],[38,1,38,3],[39,1,39,3],[27,1,27,3],[28,1,28,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[11,1,11,3],[12,1,12,3],[16,1,16,3],[17,1,17,3],[9,1,9,3],[10,1,10,3],[1,2,1,4],[3,0,3,4],[7,1,7,3],[8,1,8,3]]}
[1,null,null,"For the calendar year of January 1 - December 31,",{"$f":"IF(Cover!D13>0, Cover!D13,\"\")","v":2012}]
[2,"Company Name:",{"$f":"IF(Cover!A1>0, Cover!A1, \"\")","v":""}]
[]
["DETAILED EXPLANATION OF ITEMS"]
[]
[3,"Page W-1, Line 11","Rent Expense ",{"$f":"'Page W-1'!E17","v":0}]
["**","Description",null,null,"Amount","**"]
[]
[]
[]
[]
[]
[null,"Total (should match amount on Page W-1, Line 11)",null,null,{"$f":"SUM(E8:E12)","v":0}]
[]
[4,"Page W-1, Line 21","Other Expenses ",{"$f":"'Page W-1'!E27","v":374.87}]
["**","Description",null,null,"Amount","**"]
[null,"Cell phone for operator",null,null,193.63]
[null,"Wal-mart - misc toilet items/paper towels",null,null,68.37]
[null,"C&C Farm Supply (batteries, rubber gloves, safety glasses, hoses)",null,null,44.9]
[null,"Cintas Fire Extinguisher renewals",null,null,67.97]
[]
[null,"Total (should match amount on Page W-1, Line 21)",null,null,{"$f":"SUM(E17:E21)","v":374.87}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Indicates a link to another worksheet within workbook"]
[null,"Indicates formula cell(s)",null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Public"]
[null,null,null,"Highly Confidential"]

{"sheet":"Page W-2","index":18,"n_rows":64,"n_cols":7,"rows_kept":64,"cut":false,"hidden":false,"merged":[[1,2,1,6],[5,5,6,5],[5,1,6,2],[5,6,6,6],[5,3,5,4],[2,1,2,6],[3,1,3,6],[4,1,4,6],[34,5,34,6],[35,5,35,6],[31,1,31,5],[7,1,7,2],[8,1,8,2],[32,1,32,5],[33,1,33,4]]}
[1,null,null,null,null,"For the calendar year of January 1 - December 31,",{"$f":"IF(Cover!D13>0,Cover!D13, \"\")","v":2012}]
[2,"Company Name:",{"$f":"IF(Cover!A1>0, Cover!A1, \"\")","v":""}]
[]
[null,"WATER OPERATING REVENUES, EXPENSES AND STATISTICS (Continued)"]
[null,"(Please indicate if metered amounts are in cubic feet measurements.)"]
[null,"(a)",null,"No. of\nCustomers",null,"Gallons\nSold\n000's\nOmitted\n(d)","Revenue\nAmount\n(e)"]
[null,null,null,"Beginning\nof Year\n(b)","End\nof Year\n(c)"]
[null,"Unmetered Sales of Water"]
[3,"Residential - Single Family",null,0,0,null,0]
[4,"Residential - Apartments",null,0,0,null,0]
[5,"Residential - Mobile Homes",null,0,0,null,0]
[6,"Commercial",null,0,0,null,0]
[7,"Other Sales to Public Authorities",null,0,0,null,0]
[8,"Other (List explanation on page W-2a)",null,0,0,null,0]
[9,"Total Unmetered Sales",null,{"$f":"SUM(D8:D14)","v":0},{"$f":"SUM(E8:E14)","v":0},null,{"$f":"SUM(G8:G14)","v":0}]
[null,"Metered Sales of Water"]
[10,"5/8\" Meter",null,101,113,null,21297.52]
[11,"3/4\" Meter",null,2,4,null,0]
[12,"1\" Meter",null,2,2,null,913.01]
[13,"1 1/2\" Meter",null,3,3,null,1166.83]
[14,"2\" Meter",null,null,null,null,5898.17]
[15,"Other (List explanation on page W-2a)",null,null,null,null,9291.7199999999993]
[16,"Total Metered Sales",null,{"$f":"SUM(D17:D22)","v":108},{"$f":"SUM(E17:E22)","v":122},{"$f":"SUM(F17:F22)","v":0},{"$f":"SUM(G16:G22)","v":38567.25}]
[null,"Other Operating Revenues"]
[17,"Late Payment Fees",null,null,null,null,0]
[18,"Inspection Fees",null,null,null,null,1250]
[19,"Reconnect Fees",null,null,null,null,0]
[20,"Rent Income",null,null,null,null,0]
[21,"Income from Merchandising, Jobbing & Contract Work (List explanation on page W-2a)",null,null,null,null,3600]
[22,"Other Revenue (List explanation on page W-2a)"]
[23,"Total Other Operating Revenues ",null,null,null,null,{"$f":"SUM(G25:G30)","v":4850}]
[24,"Total Operating Revenues *",null,null,null,null,{"$f":"SUM(G15+G23+G31)","v":43417.25}]
[null,null,null,null,null,null,"(Total to Pg. W-1)"]
["*","Total Operating Revenues should match Statement of Revenue (MOPSC Assessment)."]
[null,"Indicates a link to another worksheet within workbook"]
[null,"Indicates formula cell(s)",null,null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Public"]
[null,null,null,null,null,"Highly Confidential"]

{"sheet":"Page W-2a","index":19,"n_rows":61,"n_cols":6,"rows_kept":61,"cut":false,"hidden":false,"merged":[[41,3,41,4],[29,1,29,3],[30,1,30,3],[34,1,34,3],[35,1,35,3],[36,1,36,3],[37,1,37,3],[25,1,25,3],[26,1,26,3],[38,1,38,3],[39,1,39,3],[27,1,27,3],[28,1,28,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[11,1,11,3],[12,1,12,3],[16,1,16,3],[17,1,17,3],[9,1,9,3],[10,1,10,3],[1,2,1,4],[3,0,3,4],[7,1,7,3],[8,1,8,3]]}
[1,null,null,"For the calendar year of January 1 - December 31,",{"$f":"IF(Cover!D13>0, Cover!D13,\"\")","v":2012}]
[2,"Company Name:",{"$f":"IF(Cover!A1>0, Cover!A1, \"\")","v":""}]
[]
["DETAILED EXPLANATION OF ITEMS"]
[]
[3,"Page W-2, Line 8","Other ",{"$f":"'Page W-2'!G14","v":0}]
["**","Description",null,null,"Amount","**"]
[null,"Not Applicable"]
[]
[]
[]
[]
[null,"Total (should match amount on Page W-2, Line 8)",null,null,{"$f":"SUM(E8:E12)","v":0}]
[]
[4,"Page W-2, Line 15","Other ",{"$f":"'Page W-2'!G22","v":9291.7199999999993}]
["**","Description",null,null,"Amount","**"]
[null,"Fire Hydrant Charges to Homeowners Association, per tariffs",null,null,9291.7199999999993]
[]
[]
[]
[]
[null,"Total (should match amount on Page W-2, Line 15)",null,null,{"$f":"SUM(E17:E21)","v":9291.7199999999993}]
[]
[5,"Page W-2, Line 21","Income (Merchandising, Jobbing, & Contract Work) ",{"$f":"'Page W-2'!G29","v":3600}]
["**","Description",null,null,"Amount","**"]
[null,"Contracted with Silo Ridge Country Club as their water/sewer operator.",null,null,3600]
[]
[]
[]
[]
[null,"Total (should match amount on Page W-2, Line 21)",null,null,{"$f":"SUM(E26:E30)","v":3600}]
[]
[5,"Page W-2, Line 22","Other Revenue ",{"$f":"'Page W-2'!G30","v":0}]
["**","Description",null,null,"Amount","**"]
[null,null,null,null,0]
[]
[]
[]
[]
[null,"Total (should match amount on Page W-2, Line 22)",null,null,{"$f":"SUM(E35:E39)","v":0}]
[]
[null,"Indicates a link to another worksheet within workbook"]
[null,"Indicates formula cell(s)",null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Public"]
[null,null,null,"Highly Confidential"]

{"sheet":"Page W-3","index":20,"n_rows":60,"n_cols":5,"rows_kept":60,"cut":false,"hidden":false,"merged":[[4,1,4,4],[3,1,3,4],[27,1,27,3],[29,3,29,4],[1,2,1,4],[17,1,17,3],[18,1,18,3],[19,1,19,3],[6,1,6,3],[5,1,5,3],[2,1,2,4]]}
[1,null,null,"For the calendar year of January 1 - December 31,",{"$f":"IF(Cover!D13>0, Cover!D13, \"\")","v":2012}]
[2,"Company Name:  ",{"$f":"IF(Cover!A1>0, Cover!A1, \" \")","v":" "}]
[]
[null,"WATER OPERATING REVENUES, EXPENSES AND STATISTICS (Continued)"]
[]
[null,"(a)",null,null,"Amount\n (b)"]
[null,"Plant Operations Expenses"]
[3,"Repairs of Water Plant - Pump Repair",null,null,0]
[4,"Repairs of Water Plant - Well Repair",null,null,0]
[5,"Repairs of Water Plant - Water Line Repair",null,null,0]
[6,"Repairs of Water Plant - Equipment Repair",null,null,190.64]
[7,"Repairs of Water Plant - Other  (List explanation on Page W-3a)"]
[8,"Fuel or Power Purchases for Pumping (i.e., Electric Bills, etc.)",null,null,7535.58]
[9,"Chemicals",null,null,0]
[10,"Water Testing Expenses",null,null,200]
[11,"Other Plant Operations Expenses (List explanation on Page W-3a)",null,null,102.35]
[12,"Total Plant Operations Expenses",null,null,{"$f":"SUM(E8:E16)","v":8028.5700000000006}]
[null,null,null,null,"(Total to Page W-1)"]
[null,"Tax Expenses"]
[13,"Tax Expense - Property Taxes",null,null,274.18]
[14,"Tax Expense - Payroll Taxes",null,null,0]
[15,"Tax Expense - Franchise Taxes",null,null,0]
[16,"Tax Expense - Other Taxes (List explanation on Page W-3a)",null,null,0]
[17,"Tax Expense - Federal Income Taxes",null,null,0]
[18,"Tax Expense - State Income Taxes",null,null,0]
[19,"Tax Expense - Investment Tax Credits",null,null,0]
[20,"Total Tax Expenses",null,null,{"$f":"SUM(E20:E26)","v":274.18}]
[null,null,null,null,"(Total to Page W-1)"]
[null,"Indicates a link to another worksheet within workbook"]
[null,"Indicates formula cell(s)"]
[null,null,null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Public"]
[null,null,null,"Highly Confidential"]

{"sheet":"Page W-3a","index":21,"n_rows":61,"n_cols":6,"rows_kept":61,"cut":false,"hidden":false,"merged":[[41,3,41,4],[29,1,29,3],[30,1,30,3],[34,1,34,3],[35,1,35,3],[36,1,36,3],[37,1,37,3],[25,1,25,3],[26,1,26,3],[38,1,38,3],[39,1,39,3],[27,1,27,3],[28,1,28,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[11,1,11,3],[12,1,12,3],[16,1,16,3],[17,1,17,3],[9,1,9,3],[10,1,10,3],[1,2,1,4],[3,0,3,4],[7,1,7,3],[8,1,8,3]]}
[1,null,null,"For the calendar year of January 1 - December 31,",{"$f":"IF(Cover!D13>0, Cover!D13,\"\")","v":2012}]
[2,"Company Name:",{"$f":"IF(Cover!A1>0, Cover!A1, \"\")","v":""}]
[]
["DETAILED EXPLANATION OF ITEMS"]
[]
[3,"Page W-3, Line 7","Repairs of Water Plant - Other ",{"$f":"'Page W-3'!E12","v":0}]
["**","Description",null,null,"Amount","**"]
[]
[]
[]
[]
[]
[null,"Total (should match amount on Page W-3, Line 7)",null,null,{"$f":"SUM(E8:E12)","v":0}]
[]
[4,"Page W-3, Line 11","Other Plant Operation Expenses ",{"$f":"'Page W-3'!E16","v":102.35}]
["**","Description",null,null,"Amount","**"]
[null,"Ash Grove Aggreates - rock for driveway",null,null,102.35]
[]
[]
[]
[]
[null,"Total (should match amount on Page W-3, Line 11)",null,null,{"$f":"SUM(E17:E21)","v":102.35}]
[]
[5,"Page W-3, Line 16","Tax Expense - Other Taxes ",{"$f":"'Page W-3'!E23","v":0}]
["**","Description",null,null,"Amount","**"]
[]
[]
[]
[]
[]
[null,"Total (should match amount on Page W-3, Line 16)",null,null,{"$f":"SUM(E26:E30)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Indicates a link to another worksheet within workbook"]
[null,"Indicates formula cell(s)",null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Public"]
[null,null,null,"Highly Confidential"]

{"sheet":"Page W-4","index":22,"n_rows":68,"n_cols":11,"rows_kept":68,"cut":false,"hidden":false,"merged":[[0,2,0,7],[1,2,1,7],[1,9,5,9],[1,10,34,10],[3,2,9,2],[3,3,3,6],[3,7,9,7],[4,3,4,6],[5,3,5,6],[6,3,6,6],[7,3,7,6],[7,9,37,9],[8,3,8,6],[10,2,10,7],[25,2,25,7],[27,2,27,7],[29,2,29,7],[30,2,30,7],[31,3,31,5],[28,4,28,7],[34,0,38,0],[32,3,32,5],[33,3,33,5],[35,10,37,10],[37,6,37,7],[38,6,38,7],[34,3,34,5],[35,3,35,5]]}
[null,null,"PUMPING AND PURCHASED WATER STATISTICS",null,null,null,null,null,null,2,1]
[null,null,"(Omit 000's in reporting number of gallons or cubic feet of water.  Use additional sheets if necessary.)",null,null,null,null,null,null,"  Company Name:","For the calendar year of January 1 - December 31,"]
[]
[null,null,"Gallons Pumped Into System","Source of Supply\n(Please describe source below.)",null,null,null,"Total of all\nMethods\n(a+b+c+d=e)\n(e)"]
[null,3]
[null,4]
[null,5]
[null,6,null,null,null,null,null,null,null,{"$f":"IF(Cover!A1>0, Cover!A1, \"\")","v":""}]
[null,7,null,"Well #1                   Well #2"]
[null,null,null,"(a)","(b)","(c)","(d)"]
[]
[null,8,"Jan",54,143,null,null,{"$f":"SUM(D12:G12)","v":197}]
[null,9,"Feb",90,140,null,null,{"$f":"SUM(D13:G13)","v":230}]
[null,10,"Mar",282,1295,null,null,1577]
[null,11,"April",632,1096,null,null,1728]
[null,12,"May",613,1038,null,null,1651]
[null,13,"June",403,1754,null,null,2157]
[null,14,"July",466,2003,null,null,2469]
[null,15,"Aug",688,1243,null,null,1931]
[null,16,"Sept",996,782,null,null,1778]
[null,17,"Oct",1114,586,null,null,1700]
[null,18,"Nov",918,829,null,null,1747]
[null,19,"Dec",694,948,null,null,1642]
[null,20,"Total for Year",{"$f":"SUM(D12:D23)","v":6950},{"$f":"SUM(E12:E23)","v":11857},{"$f":"SUM(F12:F23)","v":0},{"$f":"SUM(G12:G23)","v":0},{"$f":"SUM(H12:H23)","v":18807}]
[]
[]
[null,21,"Maximum Quantity Supplied to the System in Any One Day:",79646,null,"Minimum:  ",6355]
[]
[null,22,"Range of Pressure in the Mains as Measured at the Highest Point on System:",null,"49.7 to 52.3"]
[]
[null,null,"If Water is Sold to Other Utilities for Resale, List Names, Addresses, Phone Numbers and Quantities Below:"]
[null,null,"Name of Reseller","Address",null,null,"Phone Number","Quantity"]
[null,23,"None","n/a",null,null,"n/a","n/a"]
[null,24]
["Page W-4",25]
[null,26,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!D13>0, Cover!D13, \"\")","v":2012}]
[]
[null,null,"Indicates a link to another worksheet within workbook"]
[null,null,"Indicates formula cell(s)",null,null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Public"]
[null,null,null,null,null,null,null,"Highly Confidential"]

{"sheet":"Page W-5","index":23,"n_rows":100,"n_cols":9,"rows_kept":100,"cut":false,"hidden":false,"merged":[[6,1,6,2],[6,3,6,4],[1,2,1,8],[2,1,2,8],[3,1,3,8],[4,3,4,4],[4,1,4,2],[5,1,5,2],[5,3,5,4],[9,1,9,2],[9,3,9,4],[10,1,10,2],[10,3,10,4],[7,1,7,2],[7,3,7,4],[8,1,8,2],[8,3,8,4],[13,1,13,2],[13,3,13,4],[14,1,14,2],[14,3,14,4],[11,1,11,2],[11,3,11,4],[12,1,12,2],[12,3,12,4],[17,1,17,2],[17,3,17,4],[18,1,18,2],[18,3,18,4],[15,1,15,2],[15,3,15,4],[16,1,16,2],[16,3,16,4],[21,1,21,2],[21,3,21,4],[22,1,22,2],[22,3,22,4],[19,1,19,2],[19,3,19,4],[20,1,20,2],[20,3,20,4],[25,1,25,2],[25,3,25,4],[26,1,26,2],[26,3,26,4],[23,1,23,2],[23,3,23,4],[24,1,24,2],[24,3,24,4],[29,1,29,2],[29,3,29,4],[30,1,30,2],[30,3,30,4],[27,1,27,2],[27,3,27,4],[28,1,28,2],[28,3,28,4],[33,1,33,2],[33,3,33,4],[34,1,34,2],[34,3,34,4],[31,1,31,2],[31,3,31,4],[32,1,32,2],[32,3,32,4],[37,1,37,2],[37,3,37,4],[38,1,38,2],[38,3,38,4],[35,1,35,2],[35,3,35,4],[36,1,36,2],[36,3,36,4],[41,1,41,2],[41,3,41,4],[42,1,42,2],[42,3,42,4],[39,1,39,2],[39,3,39,4],[40,1,40,2],[40,3,40,4],[60,7,60,8],[59,1,59,2],[43,1,43,2],[43,3,43,4],[44,1,44,2],[45,1,45,2],[50,1,50,2],[60,0,61,6]]}
[1,null,null,null,null,null,null,"For the calendar year of January 1 - December 31,",{"$f":"IF(Cover!D13>0, Cover!D13, \"\")","v":2012}]
[2,"Company Name:",{"$f":"IF(Cover!A1>0, Cover!A1, \"\")","v":""}]
[]
[null,"WATER UTILITY PLANT IN SERVICE"]
[null,"Account Description\n(a)",null,"Acct.\nNo. \n(b)",null,"Balance at\nBeginning of Year\n(c)","Additions During\nthe Year\n(d)","Retirements\nDuring the Year\n(e)","Balance at End\nof Year (c+d-e)\n(f)"]
[null,"Intangible Plant",null,"Class B, C or D"]
[3,"Organization",null,301,null,null,null,null,{"$f":"F7+G7-H7","v":0}]
[4,"Franchise and Consents",null,302,null,null,null,null,{"$f":"F8+G8-H8","v":0}]
[5,"Miscellaneous Intangible Plant",null,303,null,null,null,null,{"$f":"F9+G9-H9","v":0}]
[null,"Source of Supply Plant"]
[6,"Land and Land Rights",null,310,null,18750,null,null,{"$f":"F11+G11-H11","v":18750}]
[7,"Structures and Improvements",null,311,null,15570.81,null,null,15570.81]
[8,"Collecting and Impounding Reservoirs",null,312,null,null,null,null,0]
[9,"Lake, River, and Other Intakes",null,313,null,null,null,null,0]
[10,"Wells and Springs",null,314,null,22087,null,null,22087]
[11,"Infiltration Galleries and Tunnels",null,315,null,null,null,null,0]
[12,"Supply Mains",null,316,null,null,null,null,0]
[13,"Other Water Source Plant (List explanation on Page W-5a)  ",null,317,null,null,null,null,0]
[null,"Pumping Plant"]
[14,"Land and Land Rights",null,320,null,null,null,null,0]
[15,"Structures and Improvements",null,321,null,null,null,null,0]
[16,"Boiler Plant Equipment",null,322,null,null,null,null,0]
[17,"Other Power Production Equipment\n (List explanation on Page W-5a)  ",null,323,null,null,null,null,0]
[18,"Submersible Electric Pumping",null,325.10000000000002,null,69079.3,null,null,69079.3]
[19,"High Service or Booster Pumps",null,325.2,null,null,null,null,0]
[20,"Diesel Pumping Equipment",null,326,null,null,null,null,0]
[21,"Hydraulic Pumping Equipment",null,327,null,null,null,null,0]
[22,"Other Pumping Equipment (List explanation on Page W-5a)  ",null,328,null,null,null,null,0]
[null,"Water Treatment Plant"]
[23,"Land and Land Rights",null,330,null,null,null,null,0]
[24,"Structures and Improvements",null,331,null,null,null,null,0]
[25,"Water Treatment Equipment",null,332,null,null,null,null,0]
[null,"Transmission and Distribution Plant"]
[26,"Land and Land Rights",null,340,null,null,null,null,0]
[27,"Structures and Improvements",null,341,null,null,null,null,0]
[28,"Distribution Reservoirs and Standpipes",null,342,null,27515.87,null,null,27515.87]
[29,"Transmission and Distribution Mains",null,343,null,335893.84,null,null,335893.84]
[30,"Fire Mains",null,344,null,null,null,null,0]
[31,"Services",null,345,null,13557.78,null,null,13557.78]
[32,"Meters",null,346,null,1220.29,null,null,1220.29]
[33,"Meter Installations",null,347,null,null,null,null,0]
[34,"Hydrants",null,348,null,30740,null,null,30740]
[35,"Other Transmission and Distribution Plant",null,349,null,null,null,null,0]
[null,"   General Plant"]
[null,"Note: USOA CLASS  B and C are the same  ",null,"B &C  ","D"]
[36,"Land and Land Rights                                                     ",null,389,370,null,null,null,{"$f":"F46+G46-H46","v":0}]
[37,"Structures and Improvements                                    ",null,390,371,null,null,null,0]
[38,"Office Furniture and Equipment                                  ",null,391,372,250,null,null,250]
[39,"Office Computer and Electronic Equipment   ",null,391.1,372.1,null,null,null,0]
[40,"Transportation Equipment                                           ",null,392,373,18750,null,null,18750]
[41,"Other General Equipment",null,"none  ",379,null,null,null,0]
[42,"Stores Equipment                                                             ",null,393,"none  ",null,null,null,0]
[43,"Tools, Shop and Garage Equipment                         ",null,394,"none  ",1017.61,null,null,1017.61]
[44,"Laboratory Equipment                                                    ",null,395,"none  ",null,null,null,0]
[45,"Power-operated Equipment                                         ",null,396,"none  ",26585,null,null,26585]
[46,"Communication Equipment                                         ",null,397,"none  ",null,null,null,0]
[47,"Miscellaneous Equipment                                           ",null,398,"none  ",null,null,null,0]
[48,"Other Tangible Property (List explanation on Page W-5a)                                            ",null,399,"none  ",null,null,null,0]
[49,"Total Water Utility Plant In Service",null,null,null,{"$f":"SUM(F7:F58)","v":581017.50000000012},{"$f":"SUM(G7:G58)","v":0},{"$f":"SUM(H7:H58)","v":0},{"$f":"SUM(I7:I58)","v":581017.50000000012}]
[null,null,null,null,null,null,null,null,"(Total to Pages 4 & 9)"]
["NOTE:  All entries should be supported by records that identify the property being added or retired, its location, and its original cost in as much detail as reasonably possible.  If adjustments are included in Columns \"d\" and/or \"e\", use additional sheets."]
[null,null,null,null,null,null,null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Public"]
[null,null,null,null,null,null,null,null,"Highly Confidential"]

{"sheet":"Page W-5a","index":24,"n_rows":61,"n_cols":6,"rows_kept":61,"cut":false,"hidden":false,"merged":[[41,3,41,4],[29,1,29,3],[30,1,30,3],[34,1,34,3],[35,1,35,3],[36,1,36,3],[37,1,37,3],[25,1,25,3],[26,1,26,3],[38,1,38,3],[39,1,39,3],[27,1,27,3],[28,1,28,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[11,1,11,3],[12,1,12,3],[16,1,16,3],[17,1,17,3],[9,1,9,3],[10,1,10,3],[1,2,1,4],[3,0,3,4],[7,1,7,3],[8,1,8,3]]}
[1,null,null,"For the calendar year of January 1 - December 31,",{"$f":"IF(Cover!D13>0, Cover!D13,\"\")","v":2012}]
[2,"Company Name:",{"$f":"IF(Cover!A1>0, Cover!A1, \"\")","v":""}]
[]
["DETAILED EXPLANATION OF ITEMS"]
[]
[{"$f":"A2+1&\".\"","v":"3."},"Page W-5, Line 13","Other Water Source Plant ",{"$f":"'Page W-5'!I18","v":0}]
["**","Description",null,null,"Amount","**"]
[]
[]
[]
[]
[]
[null,"Total (should match amount on Page W-5, Line 13)",null,null,{"$f":"SUM(E8:E12)","v":0}]
[]
[{"$f":"A6+1&\".\"","v":"4."},"Page W-5, Line 17","Other Power Production Equipment ",{"$f":"'Page W-5'!I23","v":0}]
["**","Description",null,null,"Amount","**"]
[]
[]
[]
[]
[]
[null,"Total (should match amount on Page W-5, Line 17)",null,null,{"$f":"SUM(E17:E21)","v":0}]
[]
[{"$f":"A15+1&\".\"","v":"5."},"Page W-5, Line 22","Other Pumping Equipment ",{"$f":"'Page W-5'!I28","v":0}]
["**","Description",null,null,"Amount","**"]
[]
[]
[]
[]
[]
[null,"Total (should match amount on Page W-5, Line 22)",null,null,{"$f":"SUM(E26:E30)","v":0}]
[]
[{"$f":"A24+1&\".\"","v":"6."},"Page W-5, Line 48","Other Tangible Property ",{"$f":"'Page W-5'!I58","v":0}]
["**","Description",null,null,"Amount","**"]
[]
[]
[]
[]
[]
[null,"Total (should match amount on Page W-5, Line 48)",null,null,{"$f":"SUM(E35:E39)","v":0}]
[]
[null,"Indicates a link to another worksheet within workbook"]
[null,"Indicates formula cell(s)",null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Public"]
[null,null,null,"Highly Confidential"]

{"sheet":"Page W-6","index":25,"n_rows":81,"n_cols":11,"rows_kept":81,"cut":false,"hidden":false,"merged":[[64,8,64,10],[4,6,4,8],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[4,1,5,2],[4,3,5,3],[4,4,5,4],[0,2,0,9],[1,4,1,10],[2,3,2,10],[3,1,3,10],[4,9,5,9],[4,10,5,10],[4,5,5,5],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[43,1,43,2],[63,8,63,10],[44,1,44,2],[60,1,60,10],[61,1,61,10],[62,1,62,10],[63,1,63,7]]}
[1,null,"For the calendar year of January 1 - December 31,",null,null,null,null,null,null,null,{"$f":"IF(Cover!D13>0, Cover!D13, \"\")","v":2012}]
[2,null,null,"Company Name:",{"$f":"IF(Cover!A1>0, Cover!A1, \"\")","v":""}]
[]
[null,"DEPRECIATION RESERVE - WATER UTILITY PLANT"]
[null,"Acct.\nNo. \n(b)",null,"Annual\nDepreciation\nRate %***\n(g)","Depreciation\nExpense\n(f*g)\n(h)","Reserve\nBalance at\nBeginning \nof Year\n(i)\n","Retirement of Property",null,null,"Other Charges**\n(m)","Reserve Balance\nat END\nof Year\n(h+i-j-k+l+m)\n(n)"]
[null,null,null,null,null,null,"Book Cost\nof Plant\nRetired\n(j)","Cost of\nRemoval*\n(k)","Salvage Credit*\n(l)"]
[null,{"$f":"'Page W-5'!$D$6","v":"Class B, C or D"}]
[3,{"$f":"'Page W-5'!D7","v":301},null,null,null,null,{"$f":"'Page W-5'!H7","v":0},null,null,null,{"$f":"SUM(E8+F8-G8-H8+I8+J8)","v":0}]
[4,{"$f":"'Page W-5'!D8","v":302},null,null,null,null,{"$f":"'Page W-5'!H8","v":0},null,null,null,{"$f":"SUM(E9+F9-G9-H9+I9+J9)","v":0}]
[5,{"$f":"'Page W-5'!D9","v":303},null,null,null,null,{"$f":"'Page W-5'!H9","v":0},null,null,null,0]
[]
[6,{"$f":"'Page W-5'!D11","v":310},null,null,null,null,{"$f":"'Page W-5'!H11","v":0},null,null,null,0]
[7,{"$f":"'Page W-5'!D12","v":311},null,2.5000000000000001E-2,389.27,2352.7399999999998,{"$f":"'Page W-5'!H12","v":0},null,null,null,2742.0099999999998]
[8,{"$f":"'Page W-5'!D13","v":312},null,null,null,null,{"$f":"'Page W-5'!H13","v":0},null,null,null,0]
[9,{"$f":"'Page W-5'!D14","v":313},null,null,null,null,{"$f":"'Page W-5'!H14","v":0},null,null,null,0]
[10,{"$f":"'Page W-5'!D15","v":314},null,0.02,441.74,2669.8,{"$f":"'Page W-5'!H15","v":0},null,null,null,3111.54]
[11,{"$f":"'Page W-5'!D16","v":315},null,null,null,null,{"$f":"'Page W-5'!H16","v":0},null,null,null,0]
[12,{"$f":"'Page W-5'!D17","v":316},null,null,null,null,{"$f":"'Page W-5'!H17","v":0},null,null,null,0]
[13,{"$f":"'Page W-5'!D18","v":317},null,null,null,null,{"$f":"'Page W-5'!H18","v":0},null,null,null,0]
[]
[14,{"$f":"'Page W-5'!D20","v":320},null,null,null,null,{"$f":"'Page W-5'!H20","v":0},null,null,null,0]
[15,{"$f":"'Page W-5'!D21","v":321},null,null,null,null,{"$f":"'Page W-5'!H21","v":0},null,null,null,0]
[16,{"$f":"'Page W-5'!D22","v":322},null,null,null,null,{"$f":"'Page W-5'!H22","v":0},null,null,null,0]
[17,{"$f":"'Page W-5'!D23","v":323},null,null,null,null,{"$f":"'Page W-5'!H23","v":0},null,null,null,0]
[18,{"$f":"'Page W-5'!D24","v":325.10000000000002},null,null,null,null,{"$f":"'Page W-5'!H24","v":0},null,null,null,0]
[19,{"$f":"'Page W-5'!D25","v":325.2},null,0.1,6907.93,41840.46,{"$f":"'Page W-5'!H25","v":0},null,null,null,48748.39]
[20,{"$f":"'Page W-5'!D26","v":326},null,null,null,null,{"$f":"'Page W-5'!H26","v":0},null,null,null,0]
[21,{"$f":"'Page W-5'!D27","v":327},null,null,null,null,{"$f":"'Page W-5'!H27","v":0},null,null,null,0]
[22,{"$f":"'Page W-5'!D28","v":328},null,null,null,null,{"$f":"'Page W-5'!H28","v":0},null,null,null,0]
[]
[23,{"$f":"'Page W-5'!D30","v":330},null,null,null,null,{"$f":"'Page W-5'!H30","v":0},null,null,null,0]
[24,{"$f":"'Page W-5'!D31","v":331},null,null,null,null,{"$f":"'Page W-5'!H31","v":0},null,null,null,0]
[25,{"$f":"'Page W-5'!D32","v":332},null,null,null,null,{"$f":"'Page W-5'!H32","v":0},null,null,null,0]
[]
[26,{"$f":"'Page W-5'!D34","v":340},null,null,null,null,{"$f":"'Page W-5'!H34","v":0},null,null,null,0]
[27,{"$f":"'Page W-5'!D35","v":341},null,null,null,null,{"$f":"'Page W-5'!H35","v":0},null,null,null,0]
[28,{"$f":"'Page W-5'!D36","v":342},null,0.02,550.32000000000005,3326.08,{"$f":"'Page W-5'!H36","v":0},null,null,null,3876.4]
[29,{"$f":"'Page W-5'!D37","v":343},null,2.5000000000000001E-2,8397.35,42897.47,{"$f":"'Page W-5'!H37","v":0},null,null,null,51294.82]
[30,{"$f":"'Page W-5'!D38","v":344},null,null,null,null,{"$f":"'Page W-5'!H38","v":0},null,null,null,0]
[31,{"$f":"'Page W-5'!D39","v":345},null,2.5000000000000001E-2,338.95,1864.86,{"$f":"'Page W-5'!H39","v":0},null,null,null,2203.81]
[32,{"$f":"'Page W-5'!D40","v":346},null,0.1,122.03,510.06,{"$f":"'Page W-5'!H40","v":0},null,null,null,632.09]
[33,{"$f":"'Page W-5'!D41","v":347},null,null,null,null,{"$f":"'Page W-5'!H41","v":0},null,null,null,0]
[34,{"$f":"'Page W-5'!D42","v":348},null,0.02,74.7,448.2,{"$f":"'Page W-5'!H42","v":0},null,null,null,522.9]
[35,{"$f":"'Page W-5'!D43","v":349},null,null,null,null,{"$f":"'Page W-5'!H43","v":0},null,null,null,0]
[]
[null,{"$f":"'Page W-5'!D45","v":"B &C  "},{"$f":"'Page W-5'!E45","v":"D"}]
[36,{"$f":"'Page W-5'!D46","v":389},{"$f":"'Page W-5'!E46","v":370},null,null,null,{"$f":"'Page W-5'!H46","v":0},null,null,null,0]
[37,{"$f":"'Page W-5'!D47","v":390},{"$f":"'Page W-5'!E47","v":371},null,null,null,{"$f":"'Page W-5'!H47","v":0},null,null,null,0]
[38,{"$f":"'Page W-5'!D48","v":391},{"$f":"'Page W-5'!E48","v":372},0.05,12,60.34,{"$f":"'Page W-5'!H48","v":0},null,null,null,72.34]
[39,{"$f":"'Page W-5'!D49","v":391.1},{"$f":"'Page W-5'!E49","v":372.1},null,null,null,{"$f":"'Page W-5'!H49","v":0},null,null,null,0]
[40,{"$f":"'Page W-5'!D50","v":392},{"$f":"'Page W-5'!E50","v":373},0.125,2343.75,14072.9,{"$f":"'Page W-5'!H50","v":0},null,null,null,16416.650000000001]
[41,{"$f":"'Page W-5'!D51","v":"none  "},{"$f":"'Page W-5'!E51","v":379},null,null,null,{"$f":"'Page W-5'!H51","v":0},null,null,null,0]
[42,{"$f":"'Page W-5'!D52","v":393},{"$f":"'Page W-5'!E52","v":"none  "},null,null,null,{"$f":"'Page W-5'!H52","v":0},null,null,null,0]
[43,{"$f":"'Page W-5'!D53","v":394},{"$f":"'Page W-5'!E53","v":"none  "},0.05,50.88,307.04000000000002,{"$f":"'Page W-5'!H53","v":0},null,null,null,357.92]
[44,{"$f":"'Page W-5'!D54","v":395},{"$f":"'Page W-5'!E54","v":"none  "},null,null,null,{"$f":"'Page W-5'!H54","v":0},null,null,null,0]
[45,{"$f":"'Page W-5'!D55","v":396},{"$f":"'Page W-5'!E55","v":"none  "},6.7000000000000004E-2,1595.1,9648.68,{"$f":"'Page W-5'!H55","v":0},null,null,null,11243.78]
[46,{"$f":"'Page W-5'!D56","v":397},{"$f":"'Page W-5'!E56","v":"none  "},null,null,null,{"$f":"'Page W-5'!H56","v":0},null,null,null,0]
[47,{"$f":"'Page W-5'!D57","v":398},{"$f":"'Page W-5'!E57","v":"none  "},null,null,null,{"$f":"'Page W-5'!H57","v":0},null,null,null,0]
[48,null,null,"Total",{"$f":"SUM(E7:E58)","v":21224.02},119998.62999999998,0,0,0,0,141222.65]
[null,null,null,null,"(Total to Pg. 9 & Pg. W-1)",null,null,null,null,null,"(Total to Pg. 4)"]
[null,"NOTE:  Amounts included in Column \"j\" should be the same as in Column \"e\" on the preceding page.  Also, Annual Depreciation Expense is equal to Column \"f\" from preceding page multiplied by Column \"g\" found on this page."]
["*","All entries included in Columns \"k\" and \"l\" should be supported by records that identify the property retired and the cost of removal or salvage is as much detail as reasonably possible."]
["**","Report the details for these entries.  Use additional sheets if necessary."]
["***","Annual Depreciation Expense must be calculated separately.  This total should be calculated based\nupon actual in-service and retirement date(s) of new equipment and retirements during the period."]
[null,"Indicates a link to another worksheet within workbook",null,null,null,null,null,null,"(To be used when filing under seal.)"]
[null,"Indicates formula cell(s)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Public"]
[null,null,null,null,null,null,null,null,"Highly Confidential"]

{"sheet":"Page W-7 (Part 1)","index":26,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,2,1,5],[14,0,17,0],[16,4,16,5],[2,1,2,5],[14,1,14,5]]}
[1,null,null,null,"For the calendar year of January 1 - December 31,",{"$f":"IF(Cover!D13>0, Cover!D13, \"\")","v":2012}]
[2,"Company Name:",{"$f":"IF(Cover!A1>0, Cover!A1, \"\")","v":""}]
[null,"PUMPS"]
[null,"Manufacturer and Type\n (i.e., High Service, Well, Standby, etc.)","Capacity","Date\n Installed","Date of Last \nMotor \nReplacement","Date of Last \nPump \nReplacement"]
[3,"Well #1"]
[4,"Aremotor","80 GPM/235","2004-04-01","2005-12-01"]
[5,"Aremotor, Grundfoe-Submersible"," 370 GPM/23","2005-12-01"]
[6,"Well #2"]
[7,"Aremotor, Grundfoe-Submersible","370 GPM/23","2004-09-01"]
[8,"Well 1 & 2"]
[9,"Goulds Pump, ITT Industries","230 GPM/65","Well #1 12/1/2005"]
[10,"Two 3 Unit Booster Pumps","680 GPM/65","Well #2  4/1/2004"]
[11]
[12]
["Page W-7a"]
[]
[]
[null,null,null,null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Public"]
[null,null,null,null,"Highly Confidential"]

{"sheet":"Page W-7 (Part 2)","index":27,"n_rows":46,"n_cols":9,"rows_kept":46,"cut":false,"hidden":false,"merged":[[16,0,18,0],[2,8,14,8],[1,2,1,5],[2,1,2,5],[17,4,17,5]]}
[1,null,null,null,"For the calendar year of January 1 - December 31,",{"$f":"IF(Cover!D13>0, Cover!D13, \"\")","v":2012}]
[2,"Company Name:",{"$f":"IF(Cover!A1>0, Cover!A1, \"\")","v":""}]
[null,"WELLS"]
[13,null,"Number:","Number:","Number:","Number:"]
[]
[]
[14,"Description (i.e., Deep, Artisian, Spring, etc.)","Deep","Deep"]
[15,"Year Constructed","2004-06-22",2004]
[16,"Type of Construction","Drilled","Drilled"]
[17,"Type of Casing","Steel","Steel"]
[18,"Depth and Diameter of Well","610' x 8\"","900'x6\""]
[19,"Yield of Well in Gallons per day",".053 MGD",".053 MGD"]
[20,"Chemicals (i.e., Provide Type, Cost and \nQuantities of Each):","NA","NA"]
[21,"     Type -"]
[22,"     Cost -"]
[23,"     Quantity -",null,null,null,null,null,null,{"$f":"IF(Cover!D13>0, Cover!D13, \"\")","v":2012}]
["Page W-7 (Part 1"]
[]
[null,null,null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Public"]
[null,null,null,null,"Highly Confidential"]

{"sheet":"Page W-8","index":28,"n_rows":44,"n_cols":256,"rows_kept":44,"cut":false,"hidden":false,"merged":[[17,2,17,5],[18,2,18,5],[2,10,23,10],[0,2,0,8],[19,0,23,0],[19,2,19,5],[20,2,20,5],[21,2,21,5],[1,11,20,11],[15,2,15,8],[16,2,16,5],[21,11,23,11],[23,7,23,8]]}
[null,null,"METERS AND METER SETTINGS",null,null,null,null,null,null,null,2,1]
[null,null,"Customer Class\n(a)","Meter Size\n(b)","Total at\nBeginning of Year\n(c)","Total No. of\nAdditions\n(d)","Total No. Removed\nor Disconnected \n(e)","Total at\nEnd of Year\n(f)","Total No. Owned\nby Customers at \nEnd of Year\n(g)",null,"  Company Name:","For the calendar year of January 1 - December 31,"]
[null,3,"Residential:","5/8\"",69,16,null,85,null,null,{"$f":"IF(Cover!A1>0, Cover!A1, \"\")","v":""}]
[null,4,null,"2\"",1,null,null,1]
[null,5,"Commercial","5/8\"",32,null,null,32]
[null,6,null,"1\"",2,2,null,4]
[null,7,"Other Customers:","1 1/2\"",2,null,null,2]
[null,8,null,"2\"",2,null,null,2]
[null,9]
[null,10,"Total in Use by Customers",null,{"$f":"SUM(E3:E9)","v":108},{"$f":"SUM(F3:F9)","v":18},{"$f":"SUM(G3:G9)","v":0},{"$f":"SUM(H3:H9)","v":126},{"$f":"SUM(I3:I9)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(IV3:IV9)","v":0}]
[null,11,"Not in Use (i.e., Inventory)",null,36,5,null,23]
[null,12]
[null,13]
[null,14,"Total Meters",null,{"$f":"SUM(E10:E13)","v":144},{"$f":"SUM(F10:F13)","v":23},{"$f":"SUM(G10:G13)","v":0},{"$f":"SUM(H10:H13)","v":149},{"$f":"I10","v":0}]
[]
[null,null,"STORAGE FACILITIES"]
[null,null,"Type of Storage\n(i.e., Pneumatic, Ground, Standpipes, Elevated Tanks, etc.)\n(a)",null,null,null,"Construction\nMaterial\n(b)","Last Date Painted\nif Applicable\n(indicate interior or exterior)\n(c)","Capacity\n(d)"]
[null,15,"Well #1 - Elevated Tank",null,null,null,"Steel",null,"21,000 gal"]
[null,16,"Well #2 - Elevated Tank",null,null,null,"Steel",null,"21,000 gal"]
["Page W-8",17]
[null,18]
[null,19,null,null,null,null,null,null,null,null,null,{"$f":"IF(Cover!D13>0, Cover!D13, \"\")","v":2012}]
[]
[]
[null,null,"Indicates formula cell(s)",null,null,null,null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Public"]
[null,null,null,null,null,null,null,"Highly Confidential"]

{"sheet":"Page W-9","index":29,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":false,"merged":[[28,0,31,0],[17,2,18,2],[32,6,32,7],[0,9,1,9],[17,7,18,7],[0,2,0,7],[29,10,31,10],[16,10,28,10],[30,2,30,7],[31,6,31,7],[16,2,16,7],[17,3,17,6],[2,9,31,9]]}
[null,null,"MAINS (measurement in feet)",null,null,null,null,null,null,"  2 Company Name:",1]
[null,null,"Kind of Pipe\n(i.e., cast iron, galvanized, iron, plastic, etc.)\n(a)","Diameter of\nPipe \n(b)","Total at\nBeginning of Year \n(c)","Total Additions\nDuring the Year\n(d)","Total Removed\nor Abandoned \nDuring the Year\n(e)","Total at\nEnd of Year\n(f)"]
[null,3,"Plastic","8\"",14985,"-",0,{"$f":"SUM(E3+F3-G3)","v":{"$error":"#VALUE!"}},null,{"$f":"IF(Cover!A1>0, Cover!A1, \"\")","v":""}]
[null,4,"Plastic","6\"",3219,"-",0,{"$f":"SUM(E4+F4-G4)","v":{"$error":"#VALUE!"}}]
[null,5,null,null,null,null,null,0]
[null,6,null,null,null,null,null,0]
[null,7,null,null,null,null,null,0]
[null,8,null,null,null,null,null,0]
[null,9,null,null,null,null,null,0]
[null,10,null,null,null,null,null,0]
[null,11,null,null,null,null,null,0]
[null,12,null,null,null,null,null,0]
[null,13,null,null,null,null,null,0]
[null,14,null,null,null,null,null,0]
[null,15,null,null,null,null,null,0]
[null,16,"Total Mains",null,{"$f":"SUM(E3:E15)","v":18204},{"$f":"SUM(F3:F15)","v":0},{"$f":"SUM(G3:G15)","v":0},{"$f":"SUM(H3:H15)","v":{"$error":"#VALUE!"}}]
[null,null,"SERVICES AVAILABLE FOR USE (from Main to Property Line)",null,null,null,null,null,null,null,"For the calendar year of January 1 - December 31,"]
[null,null,"Size and Description by Type of Material \n(i.e., iron, copper, plastic, etc.)\n(a)","Owned by Utility",null,null,null,"Total No. Owned\nby Customers\nat End of Year\n(f)"]
[null,null,null,"Total No. at\nBeginning of Year\n(b)","Total No.\nof Additions\n(c)","Total No. Retired\nor Abandoned\n(d)","Total No. at\nEnd of Year\n(e)"]
[null,null,"In Use:"]
[null,15,"3/4 Tubing",77,null,null,{"$f":"SUM(D21+E21-F21)","v":77}]
[null,{"$f":"B21+1","v":16},"3/4 PVC",23,null,null,{"$f":"SUM(D22+E22-F22)","v":23}]
[null,17,"1 PVC",6,null,null,6]
[null,18,"2\" PVC",2,null,null,2]
[null,null,"For Future Use:"]
[null,{"$f":"B24+1","v":19},"3/4 Tubing",92,null,null,92]
[null,20,"3/4 PVC",2,null,null,2]
[null,21,"1\" PVC",37,null,null,37]
["Page W-9",22,"2\" PVC",2,null,null,2]
[null,23,"Total of All Services",{"$f":"SUM(D20:D29)","v":241},{"$f":"SUM(E20:E29)","v":0},{"$f":"SUM(F20:F29)","v":0},{"$f":"SUM(G20:G29)","v":241},{"$f":"SUM(H20:H29)","v":0},null,null,{"$f":"IF(Cover!D13>0, Cover!D13, \"\")","v":2012}]
[]
[]
[null,"Indicates formula cell(s)",null,null,null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Public"]
[null,null,null,null,null,null,"Highly Confidential"]

{"sheet":"Page S-1","index":30,"n_rows":80,"n_cols":4,"rows_kept":80,"cut":false,"hidden":false,"merged":[[26,1,26,2],[1,2,1,3],[2,1,2,3],[3,1,3,3],[4,1,4,2]]}
[1,null,"For the calendar year of January 1 - December 31,",{"$f":"IF(Cover!D13>0, Cover!D13, \"\")","v":2012}]
[2,"Company Name:",{"$f":"IF(Cover!A1>0, Cover!A1, \"\")","v":""}]
[]
[null,"SEWER OPERATING REVENUES, EXPENSES AND STATISTICS"]
[null,"(a)",null,"Amount\n(b)"]
[3,"Total Operating Revenues (From Page S-2)",null,{"$f":"'Page S-2'!G29","v":50775.29}]
[null,"Operating Expenses"]
[4,"Salaries & Wages (From Page 7)",null,{"$f":"'Page 7'!E23","v":13711.68}]
[5,"Employee Pensions and Benefits",null,0]
[6,"Purchased Water",null,0]
[7,"Plant Operations Expenses (From Page S-3)",null,{"$f":"'Page S-3'!E18","v":20884.18}]
[8,"Billing Expenses",null,420.66]
[9,"Supplies and Expenses",null,259.11]
[10,"Transportation Expenses",null,2791.68]
[11,"Rent Expense (List explanation on Page S-1a)",null,0]
[12,"Insurance Expense",null,2478.5100000000002]
[13,"Outside Services Employed (i.e., Legal, Accounting, etc.) (From Page 8)",null,{"$f":"'Page 8'!E24","v":3318}]
[14,"Regulatory Commission Expenses",null,3662.37]
[15,"Uncollectible Expenses (From Page 6)",null,{"$f":"'Page 6'!F36","v":0}]
[16,"Depreciation Expense (From Page S-5)",null,{"$f":"'Page S-5'!E49","v":13035.22}]
[17,"Amortization of Contributions in Aid of Construction (Page 9)",null,{"$f":"-('Page 9'!E33+'Page 9'!E40)","v":-13539.026044129305}]
[18,"Amortization Expense"]
[19,"Tax Expenses (From Page S-3)",null,{"$f":"'Page S-3'!E28","v":203.1}]
[20,"Interest Expense (From Page 10)",null,{"$f":"'Page 10'!K24","v":0}]
[21,"Other Expenses (List explanation on Page S-1a)"]
[22,"Total Operating Expenses",null,{"$f":"SUM(D8:D25)","v":47225.483955870703}]
[23,"Net Income\n(Loss: This number should be negative as it is an offset to depreciation expense)",null,{"$f":"SUM(D6-D26)","v":3549.8060441292982}]
[]
[null,"Indicates a link to another worksheet within workbook"]
[null,"Indicates formula cell(s)",null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Public"]
[null,null,null,"Highly Confidential"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Public"]
[null,null,null,"Highly Confidential"]

{"sheet":"Page S-1a","index":31,"n_rows":61,"n_cols":6,"rows_kept":61,"cut":false,"hidden":false,"merged":[[41,3,41,4],[29,1,29,3],[30,1,30,3],[34,1,34,3],[35,1,35,3],[36,1,36,3],[37,1,37,3],[25,1,25,3],[26,1,26,3],[38,1,38,3],[39,1,39,3],[27,1,27,3],[28,1,28,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[11,1,11,3],[12,1,12,3],[16,1,16,3],[17,1,17,3],[9,1,9,3],[10,1,10,3],[1,2,1,4],[3,0,3,4],[7,1,7,3],[8,1,8,3]]}
[1,null,null,"For the calendar year of January 1 - December 31,",{"$f":"IF(Cover!D13>0, Cover!D13,\"\")","v":2012}]
[2,"Company Name:",{"$f":"IF(Cover!A1>0, Cover!A1, \"\")","v":""}]
[]
["DETAILED EXPLANATION OF ITEMS"]
[]
[3,"Page S-1, Line 11","Rent Expense",{"$f":"'Page S-1'!D15","v":0}]
["**","Description",null,null,"Amount","**"]
[]
[]
[]
[]
[]
[null,"Total (should match amount on Page S-1, Line 11)",null,null,{"$f":"SUM(E8:E12)","v":0}]
[]
[4,"Page S-1, Line 21","Other Expenses ",{"$f":"'Page S-1'!D25","v":0}]
["**","Description",null,null,"Amount","**"]
[null,"Cell phone fees for operator",null,null,193.61]
[null,"Shop supplies (gloves, fire extinguishers, trash bags, garden hoses)",null,null,237.82]
[null,"Office supplies",null,null,259.11]
[null,"Employee Bonuses",null,null,375]
[null,"Bank fees/check orders",null,null,35]
[null,"Total (should match amount on Page S-1, Line 21)",null,null,{"$f":"SUM(E17:E21)","v":1100.54}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Indicates a link to another worksheet within workbook"]
[null,"Indicates formula cell(s)",null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Public"]
[null,null,null,"Highly Confidential"]

{"sheet":"Page S-2","index":32,"n_rows":52,"n_cols":7,"rows_kept":52,"cut":false,"hidden":false,"merged":[[31,5,31,6],[30,1,30,4],[4,1,4,6],[5,3,5,4],[5,5,6,5],[15,1,15,2],[21,1,21,2],[1,2,1,6],[2,1,2,6],[3,1,3,6],[20,1,20,2],[8,1,8,2],[7,1,7,2],[5,6,6,6],[5,1,6,2]]}
[1,null,null,null,null,"For the calendar year of January 1 - December 31,",{"$f":"IF(Cover!D13>0, Cover!D13, \"\")","v":2012}]
[2,"Company Name:",{"$f":"IF(Cover!A1>0, Cover!A1, \"\")","v":""}]
[]
[null,"SEWER OPERATING REVENUES, EXPENSES AND STATISTICS (Continued)"]
[null,"(Please indicate if metered amounts are in cubic feet measurements.)"]
[null,"(a)",null,"No. of Customers",null,"Gallons Sold\n000's\nOmitted \n(d)","Revenue\nAmount \n(e)"]
[null,null,null,"Beginning\nof Year\n(b)","End of Year\n(c)"]
[null,"Flat Rate Sales"]
[3,"Residential - Single Family",null,69,81,"XXXX",26862.37]
[4,"Residential - Apartments",null,1,1,"XXXX",973.3]
[5,"Residential - Mobile Homes",null,null,null,"XXXX",0]
[6,"Commercial",null,null,null,"XXXX",0]
[7,"Other Sales to Public Authorities",null,null,null,"XXXX",0]
[8,"Other  (List explanation on Page S-2a)",null,null,null,"XXXX",0]
[9,"Total Unmetered Sales",null,{"$f":"SUM(D9:D14)","v":70},{"$f":"SUM(E9:E14)","v":82},"XXXX",{"$f":"SUM(G9:G14)","v":27835.67}]
[null,"Metered Sales Based onWater Usage"]
[10,"Commercial",null,38,38,null,10188.620000000001]
[11,"Other Sales to Public Authorities",null,null,null,null,0]
[12,"Other  (List explanation on Page S-2a)",null,null,null,null,0]
[13,"Total Metered Sales",null,{"$f":"SUM(D17:D19)","v":38},{"$f":"SUM(E17:E19)","v":38},{"$f":"SUM(F17:F19)","v":0},{"$f":"SUM(G17:G19)","v":10188.620000000001}]
[null,"Other Operating Revenues"]
[14,"Late Payment Fees",null,null,null,null,0]
[15,"Inspection Fees",null,null,null,null,2000]
[16,"Reconnect Fees",null,null,null,null,0]
[17,"Rent Income",null,null,null,null,0]
[18,"Income from Merchandising, Jobbing & Contract Work (List explanation on Page S-2a)",null,null,null,null,3600]
[19,"Other Revenue  (List explanation on Page S-2a)",null,null,null,null,7151]
[20,"Total Other Operating Revenues",null,null,null,null,{"$f":"SUM(G22:G27)","v":12751}]
[21,"Total Operating Revenues *",null,null,null,null,{"$f":"SUM(G15+G20+G28)","v":50775.29}]
[null,null,null,null,null,null,"(Total to Pg. S-1)"]
["*","Total Operating Revenues should match Statement of Revenue (MOPSC Assessment)."]
[null,"Indicates a link to another worksheet within workbook"]
[null,"Indicates formula cell(s)",null,null,null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Public"]
[null,null,null,null,null,"Highly Confidential"]

{"sheet":"Page S-2a","index":33,"n_rows":61,"n_cols":6,"rows_kept":61,"cut":false,"hidden":false,"merged":[[1,2,1,4],[3,0,3,4],[7,1,7,3],[8,1,8,3],[16,1,16,3],[17,1,17,3],[18,1,18,3],[19,1,19,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3],[27,1,27,3],[28,1,28,3],[38,1,38,3],[39,1,39,3],[20,1,20,3],[21,1,21,3],[25,1,25,3],[26,1,26,3],[41,3,41,4],[29,1,29,3],[30,1,30,3],[34,1,34,3],[35,1,35,3],[36,1,36,3],[37,1,37,3]]}
[1,null,null,"For the calendar year of January 1 - December 31,",{"$f":"IF(Cover!D13>0, Cover!D13,\"\")","v":2012}]
[2,"Company Name:",{"$f":"IF(Cover!A1>0, Cover!A1, \"\")","v":""}]
[]
["DETAILED EXPLANATION OF ITEMS"]
[]
[3,"Page S-2, Line 8","Other ",{"$f":"'Page S-2'!G14","v":0}]
["**","Description",null,null,"Amount","**"]
[]
[]
[]
[]
[]
[null,"Total (should match amount on Page S-2, Line 8)",null,null,{"$f":"SUM(E8:E12)","v":0}]
[]
[4,"Page S-2, Line 12","Other ",{"$f":"'Page S-2'!G19","v":0}]
["**","Description",null,null,"Amount","**"]
[]
[]
[]
[]
[]
[null,"Total (should match amount on Page S-2, Line 12)",null,null,{"$f":"SUM(E17:E21)","v":0}]
[]
[5,"Page S-2, Line 18","Income (Merchandising, Jobbing, & Contract Work )",{"$f":"'Page S-2'!G26","v":3600}]
["**","Description",null,null,"Amount","**"]
[null,"Contracted with Silo Ridge Country Cub as their water/sewer operator",null,null,3600]
[]
[]
[]
[]
[null,"Total (should match amount on Page S-2, Line 18)",null,null,{"$f":"SUM(E26:E30)","v":3600}]
[]
[5,"Page S-2, Line 19","Other Revenue ",{"$f":"'Page S-2'!G27","v":7151}]
["**","Description",null,null,"Amount","**"]
[null,"Sewer pre-treat fee for restaurant on system, per tariffs",null,null,6351]
[null,"20 loans black water from RV lagoon for treatment",null,null,800]
[]
[]
[]
[null,"Total (should match amount on Page S-2, Line 19)",null,null,{"$f":"SUM(E35:E39)","v":7151}]
[]
[null,"Indicates a link to another worksheet within workbook"]
[null,"Indicates formula cell(s)",null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Public"]
[null,null,null,"Highly Confidential"]

{"sheet":"Page S-3","index":34,"n_rows":70,"n_cols":5,"rows_kept":70,"cut":false,"hidden":false,"merged":[[28,1,28,3],[29,1,29,4],[30,3,30,4],[1,2,1,4],[4,1,4,3],[5,1,5,3],[2,1,2,4],[3,1,3,4]]}
[1,null,null,"For the calendar year of January 1 - December 31,",{"$f":"IF(Cover!D13>0, Cover!D13, \"\")","v":2012}]
[2,"Company Name:",{"$f":"IF(Cover!A1>0, Cover!A1, \" \")","v":" "}]
[]
[null,"SEWER OPERATING REVENUES, EXPENSES AND STATISTICS (Continued)"]
[null,"(a)",null,null,"Amount\n(b)"]
[null,"Plant Operations Expenses"]
[3,"Contracted Maintenance Expenses"]
[4,"Repairs of Sewer Plant - Pump Repair"]
[5,"Repairs of Sewer Plant - Treatment Repair",null,null,2254.23]
[6,"Repairs of Sewer Plant - Collecting Sewers and Manhole Repair"]
[7,"Repairs of Sewer Plant - Equipment Repair"]
[8,"Repairs of Sewer Plant - Other (List explanation on Page S-3a)"]
[9,"Utility Bills",null,null,9948.65]
[10,"Chemicals",null,null,0]
[11,"Sludge Hauling Expenses",null,null,1195]
[12,"Effluent Testing Expenses",null,null,2266.3000000000002]
[13,"Other Plant Operations Expenses (List explanation on Page S-3a)",null,null,5220]
[14,"Total Plant Operations Expenses",null,null,{"$f":"SUM(E7:E17)","v":20884.18}]
[null,null,null,null,"(Total to Page S-1)"]
[null,"Tax Expenses"]
[{"$f":"A18+1","v":15},"Tax Expense - Property Taxes",null,null,203.1]
[{"$f":"A21+1","v":16},"Tax Expense - Payroll Taxes",null,null,0]
[{"$f":"A22+1","v":17},"Tax Expense - Franchise Taxes",null,null,0]
[18,"Tax Expense - Other Taxes (List explanation on Page S-3a)",null,null,0]
[19,"Tax Expense - Federal Income Taxes",null,null,0]
[20,"Tax Expense - State Income Taxes",null,null,0]
[21,"Tax Expense - Investment Tax Credits",null,null,0]
[22,"Total Tax Expenses",null,null,{"$f":"SUM(E21:E27)","v":203.1}]
[null,null,null,null,"(Total to Page S-1)"]
[]
[]
[null,"Indicates formula cell(s)",null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Public"]
[null,null,null,"Highly Confidential"]

{"sheet":"Page S-3a","index":35,"n_rows":61,"n_cols":6,"rows_kept":61,"cut":false,"hidden":false,"merged":[[1,2,1,4],[3,0,3,4],[7,1,7,3],[8,1,8,3],[16,1,16,3],[17,1,17,3],[18,1,18,3],[19,1,19,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3],[27,1,27,3],[28,1,28,3],[38,1,38,3],[39,1,39,3],[20,1,20,3],[21,1,21,3],[25,1,25,3],[26,1,26,3],[41,3,41,4],[29,1,29,3],[30,1,30,3],[34,1,34,3],[35,1,35,3],[36,1,36,3],[37,1,37,3]]}
[1,null,null,"For the calendar year of January 1 - December 31,",{"$f":"IF(Cover!D13>0, Cover!D13,\"\")","v":2012}]
[2,"Company Name:",{"$f":"IF(Cover!A1>0, Cover!A1, \"\")","v":""}]
[]
["DETAILED EXPLANATION OF ITEMS"]
[]
["3.","Page S-3, Line 8","Repairs of Sewer Plant - Other ",{"$f":"'Page S-3'!E12","v":0}]
["**","Description",null,null,"Amount","**"]
[]
[]
[]
[]
[]
[null,"Total (should match amount on Page S-3, Line 8)",null,null,{"$f":"SUM(E8:E12)","v":0}]
[]
["4.","Page S-3, Line 13","Other Plant Operations Expenses ",{"$f":"'Page S-3'!E17","v":5220}]
["**","Description",null,null,"Amount","**"]
[null,"Greers Pumping - Quarterly Pumping of Grease & Ammonia Tanks (at restaurant lift station)",null,null,5220]
[]
[]
[]
[]
[null,"Total (should match amount on Page S-3, Line 13)",null,null,{"$f":"SUM(E17:E21)","v":5220}]
[]
["5.","Page S-3, Line 18","Tax Expense - Other Taxes ",{"$f":"'Page S-3'!E24","v":0}]
["**","Description",null,null,"Amount","**"]
[]
[]
[]
[]
[]
[null,"Total (should match amount on Page S-3, Line 18)",null,null,{"$f":"SUM(E26:E30)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Indicates a link to another worksheet within workbook"]
[null,"Indicates formula cell(s)",null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Public"]
[null,null,null,"Highly Confidential"]

{"sheet":"Page S-4","index":36,"n_rows":74,"n_cols":9,"rows_kept":74,"cut":false,"hidden":false,"merged":[[4,5,5,5],[6,1,6,2],[7,1,7,2],[4,6,5,6],[4,7,5,7],[1,2,1,8],[2,1,2,8],[3,1,3,8],[4,3,4,4],[4,8,5,8],[4,1,5,2],[17,1,17,2],[14,1,14,2],[15,1,15,2],[12,1,12,2],[13,1,13,2],[8,1,8,2],[9,1,9,2],[27,1,27,2],[24,1,24,2],[25,1,25,2],[10,1,10,2],[11,1,11,2],[20,1,20,2],[21,1,21,2],[18,1,18,2],[19,1,19,2],[16,1,16,2],[22,1,22,2],[23,1,23,2],[34,1,34,2],[35,1,35,2],[32,1,32,2],[33,1,33,2],[30,1,30,2],[28,1,28,2],[29,1,29,2],[26,1,26,2],[36,1,36,2],[37,1,37,2],[50,1,50,8],[51,1,51,8],[49,1,49,8],[40,1,40,2],[41,1,41,2],[38,1,38,2],[39,1,39,2],[53,7,53,8],[48,1,48,2],[45,1,45,2],[42,1,42,2],[43,1,43,2],[46,1,46,2],[47,1,47,2],[44,1,44,2]]}
[1,null,null,null,null,null,null,"For the calendar year of January 1 - December 31,",{"$f":"IF(Cover!D13>0, Cover!D13, \"\")","v":2012}]
[{"$f":"A1+1","v":2},"Company Name:",{"$f":"IF(Cover!A1>0, Cover!A1, \"\")","v":""}]
[]
[null,"SEWER UTILITY PLANT IN SERVICE"]
[null,"Account Description\n(a)",null,"Acct.\nNo. \n(b)",null,"Balance at\nBeginning of Year\n(c)","Additions During\nthe Year\n(d)","Retirements\nDuring the Year\n(e)","Balance at\nEnd of Year \n(c+d-e)\n(f)"]
[null,null,null,"CLASS\nB","CLASS\nC & D"]
[null,"Intangible Plant"]
[{"$f":"A2+1","v":3},"Organization",null,301,301,null,null,null,{"$f":"SUM(F8+G8-H8)","v":0}]
[{"$f":"A8+1","v":4},"Franchise and Consents",null,302,302,null,null,null,{"$f":"SUM(F9+G9-H9)","v":0}]
[{"$f":"A9+1","v":5},"Miscellaneous Intangible Plant",null,303,303,null,null,null,0]
[null,"Land and Structures"]
[{"$f":"A10+1","v":6},"Land and Land Rights",null,"none",310,8153.3,null,null,8153.3]
[{"$f":"A12+1","v":7},"Structures and Improvements",null,"none",311,9247.58,null,null,9247.58]
[null,"Collection Plant"]
[{"$f":"A13+1","v":8},"Land and Land Rights",null,350,"none",null,null,null,0]
[{"$f":"A15+1","v":9},"Structures and Improvements",null,351,"none",null,null,null,0]
[10,"Collection Sewer - Force",null,352.1,352.1,25278.240000000002,null,null,25278.240000000002]
[11,"Collection Sewer - Gravity",null,352.2,352.2,134903.09,null,null,134903.09]
[12,"Other Collection Plant Facilities (List explanation on Page S-4a)",null,353,353,null,null,null,0]
[13,"Services to Customers",null,354,354,20276.759999999998,null,null,20276.759999999998]
[14,"Flow Measuring Devices",null,355,355,3437.32,null,null,3437.32]
[null,"Pumping Plant"]
[{"$f":"A21+1","v":15},"Land and Land Rights",null,360,"none",null,null,null,0]
[{"$f":"A23+1","v":16},"Structures and Improvements",null,361,"none",null,null,null,0]
[{"$f":"A24+1","v":17},"Receiving Wells and Pump Pits",null,362,362,29048.61,null,null,29048.61]
[{"$f":"A25+1","v":18},"Pumping Equipment",null,363,363,14920.89,null,null,14920.89]
[null,"Treatment and Disposal"]
[{"$f":"A26+1","v":19},"Land and Land Rights",null,370,"none",null,null,null,0]
[{"$f":"A28+1","v":20},"Structures and Improvements",null,371,"none",null,null,null,0]
[{"$f":"A29+1","v":21},"Oxidation Lagoon",null,"none",372,null,null,null,0]
[22,"Treatment and Disposal Equipment",null,372,373,47618.94,null,null,47618.94]
[23,"Sewer Collection (Septic) Tanks",null,372.1,373.1,null,null,null,0]
[24,"Plant Sewer",null,373,374,125103.87,null,null,125103.87]
[25,"Outfall Sewer Lines",null,374,375,null,null,null,0]
[26,"Other Treatment and Disposal Plant Equipment \n(List explanation on Page S-4a)",null,375,376,8719.36,null,null,8719.36]
[null,"General Plant"]
[{"$f":"A35+1","v":27},"Land and Land Rights",null,389,"none",null,null,null,0]
[{"$f":"A37+1","v":28},"Structures and Improvements",null,390,"none",null,null,null,0]
[{"$f":"A38+1","v":29},"Office Furniture and Equipment",null,391,391,160,null,null,160]
[30,"Computer and Electronic Office Equipment",null,391.1,391.1,null,null,null,0]
[31,"Transportation Equipment",null,392,392,1200,4625,null,5825]
[32,"Other General Equipment (List explanation on Page S-4a)",null,"none",393,null,null,null,0]
[33,"Stores Equipment",null,393,"None",null,null,null,0]
[34,"Tools Shop and Garage Equipment",null,394,"None",null,null,null,0]
[35,"Laboratory Equipment",null,395,"None",null,null,null,0]
[36,"Power Operated Equipment",null,396,"None",null,null,null,0]
[37,"Communications Equipment",null,397,"None",null,null,null,0]
[{"$f":"A47+1","v":38},"                    Total Sewer Utility Plant In Service",null,null,null,{"$f":"SUM(F8:F47)","v":428067.96},{"$f":"SUM(G8:G47)","v":4625},{"$f":"SUM(H8:H47)","v":0},432692.96]
[null,null,null,null,null,null,null,null,"(Total to Pages 4 & 9)"]
[null,"NOTE:  All entries should be supported by records that identify the property being added or retired, its location, and its original cost in as much detail as reasonably possible.  If adjustments are included in Columns \"d\" and/or \"e\", please explain below.  Use additional sheets if necessary."]
[]
[39,"Explanation:\n"]
[]
[null,"Indicates a link to another worksheet within workbook"]
[null,"Indicates formula cell(s)",null,null,null,null,null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Public"]
[null,null,null,null,null,null,null,"Highly Confidential"]

{"sheet":"Page S-4a","index":37,"n_rows":61,"n_cols":6,"rows_kept":61,"cut":false,"hidden":false,"merged":[[41,3,41,4],[29,1,29,3],[30,1,30,3],[34,1,34,3],[35,1,35,3],[36,1,36,3],[37,1,37,3],[25,1,25,3],[26,1,26,3],[38,1,38,3],[39,1,39,3],[27,1,27,3],[28,1,28,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[11,1,11,3],[12,1,12,3],[16,1,16,3],[17,1,17,3],[9,1,9,3],[10,1,10,3],[1,2,1,4],[3,0,3,4],[7,1,7,3],[8,1,8,3]]}
[1,null,null,"For the calendar year of January 1 - December 31,",{"$f":"IF(Cover!D13>0, Cover!D13,\"\")","v":2012}]
[2,"Company Name:",{"$f":"IF(Cover!A1>0, Cover!A1, \"\")","v":""}]
[]
["DETAILED EXPLANATION OF ITEMS"]
[]
["3.","Page S-4, Line 12","Other Collection Plant Facilities ",{"$f":"'Page S-4'!I19","v":0}]
["**","Description",null,null,"Amount","**"]
[]
[]
[]
[]
[]
[null,"Total (should match amount on Page S-4, Line 12)",null,null,{"$f":"SUM(E8:E12)","v":0}]
[]
["4.","Page S-4, Line 26","Other Treatment & Disposal Plant Equipment ",{"$f":"'Page S-4'!I35","v":8719.36}]
["**","Description",null,null,"Amount","**"]
[]
[]
[]
[]
[]
[null,"Total (should match amount on Page S-4, Line 26)",null,null,{"$f":"SUM(E17:E21)","v":0}]
[]
["5.","Page S-4, Line 32","Other General Equipment ",{"$f":"'Page S-4'!I42","v":0}]
["**","Description",null,null,"Amount","**"]
[]
[]
[]
[]
[]
[null,"Total (should match amount on Page S-4, Line 32)",null,null,{"$f":"SUM(E26:E30)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Indicates a link to another worksheet within workbook"]
[null,"Indicates formula cell(s)",null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Public"]
[null,null,null,"Highly Confidential"]

{"sheet":"Page S-5","index":38,"n_rows":72,"n_cols":11,"rows_kept":72,"cut":false,"hidden":false,"merged":[[4,1,5,2],[4,5,6,5],[5,6,6,6],[5,7,6,7],[5,8,6,8],[4,9,6,9],[4,10,6,10],[51,9,51,10],[1,4,1,10],[2,3,2,10],[3,1,3,10],[4,6,4,8],[4,3,6,3],[4,4,6,4]]}
[1,null,null,null,null,null,null,null,null,"For the calendar year of January 1 - December 31,",{"$f":"IF(Cover!D13>0, Cover!D13, \"\")","v":2012}]
[{"$f":"A1+1","v":2},null,null,"Company Name:",{"$f":"IF(Cover!A1>0, Cover!A1, \"\")","v":""}]
[]
[null,"DEPRECIATION RESERVE - SEWER UTILITY PLANT"]
[null,"Acct.\nNo. \n(b)",null,"Annual\nDepreciation\nRate % \n(g)","\nAnnual \nDepreciation \nExpense \n(f*g) \n   (h)***","Reserve\nBalance \nat Beginning \nof Year\n(i)","Retirement of Property",null,null,"Other\nCharges\n  (m)**","Reserve\nBalance\nat End of Year\n(h+i-j-k+l+m)\n(n)"]
[null,null,null,null,null,null,"Book Cost\nof Plant\nRetired\n(j)","Cost of \nRemoval\n(k)*","Salvage\nCredit \n (l)*"]
[null,"CLASS\nB","CLASS\nC & D "]
[]
[3,{"$f":"'Page S-4'!D8","v":301},{"$f":"'Page S-4'!E8","v":301},null,null,null,{"$f":"'Page S-4'!H8","v":0},null,null,null,{"$f":"SUM(E9+F9-(G9+H9-I9)+J9)","v":0}]
[{"$f":"A9+1","v":4},{"$f":"'Page S-4'!D9","v":302},{"$f":"'Page S-4'!E9","v":302},null,null,null,{"$f":"'Page S-4'!H9","v":0},null,null,null,{"$f":"SUM(E10+F10-(G10+H10-I10)+J10)","v":0}]
[{"$f":"A10+1","v":5},{"$f":"'Page S-4'!D10","v":303},{"$f":"'Page S-4'!E10","v":303},null,null,null,{"$f":"'Page S-4'!H10","v":0},null,null,null,0]
[]
[{"$f":"A11+1","v":6},{"$f":"'Page S-4'!D12","v":"none"},{"$f":"'Page S-4'!E12","v":310},2.5000000000000001E-2,231.19,693.57,{"$f":"'Page S-4'!H12","v":0},null,null,null,924.76]
[{"$f":"A13+1","v":7},{"$f":"'Page S-4'!D13","v":"none"},{"$f":"'Page S-4'!E13","v":311},null,null,null,{"$f":"'Page S-4'!H13","v":0},null,null,null,0]
[]
[{"$f":"A14+1","v":8},{"$f":"'Page S-4'!D15","v":350},{"$f":"'Page S-4'!E15","v":"none"},null,null,null,{"$f":"'Page S-4'!H15","v":0},null,null,null,0]
[{"$f":"A16+1","v":9},{"$f":"'Page S-4'!D16","v":351},{"$f":"'Page S-4'!E16","v":"none"},null,null,null,{"$f":"'Page S-4'!H16","v":0},null,null,null,0]
[10,{"$f":"'Page S-4'!D17","v":352.1},{"$f":"'Page S-4'!E17","v":352.1},0.02,505.57,1516.71,{"$f":"'Page S-4'!H17","v":0},null,null,null,2022.28]
[11,{"$f":"'Page S-4'!D18","v":352.2},{"$f":"'Page S-4'!E18","v":352.2},0.02,2698.07,7275.94,{"$f":"'Page S-4'!H18","v":0},null,null,null,9974.01]
[12,{"$f":"'Page S-4'!D19","v":353},{"$f":"'Page S-4'!E19","v":353},null,null,null,{"$f":"'Page S-4'!H19","v":0},null,null,null,0]
[13,{"$f":"'Page S-4'!D20","v":354},{"$f":"'Page S-4'!E20","v":354},3.3000000000000002E-2,669.14,2007.42,{"$f":"'Page S-4'!H20","v":0},null,null,null,2676.56]
[14,{"$f":"'Page S-4'!D21","v":355},{"$f":"'Page S-4'!E21","v":355},3.3000000000000002E-2,113.44,340.32,{"$f":"'Page S-4'!H21","v":0},null,null,null,453.76]
[]
[{"$f":"A22+1","v":15},{"$f":"'Page S-4'!D23","v":360},{"$f":"'Page S-4'!E23","v":"none"},null,null,null,{"$f":"'Page S-4'!H23","v":0},null,null,null,0]
[{"$f":"A24+1","v":16},{"$f":"'Page S-4'!D24","v":361},{"$f":"'Page S-4'!E24","v":"none"},null,null,null,{"$f":"'Page S-4'!H24","v":0},null,null,null,0]
[{"$f":"A25+1","v":17},{"$f":"'Page S-4'!D25","v":362},{"$f":"'Page S-4'!E25","v":362},null,null,null,{"$f":"'Page S-4'!H25","v":0},null,null,null,0]
[{"$f":"A26+1","v":18},{"$f":"'Page S-4'!D26","v":363},{"$f":"'Page S-4'!E26","v":363},0.04,1161.95,3485.85,{"$f":"'Page S-4'!H26","v":0},null,null,null,4647.8]
[null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"A27+1","v":19},{"$f":"'Page S-4'!D28","v":370},{"$f":"'Page S-4'!E28","v":"none"},0.1,1492.09,4476.2700000000004,{"$f":"'Page S-4'!H28","v":0},null,null,null,5968.3600000000006]
[{"$f":"A29+1","v":20},{"$f":"'Page S-4'!D29","v":371},{"$f":"'Page S-4'!E29","v":"none"},null,null,null,{"$f":"'Page S-4'!H29","v":0},null,null,null,0]
[{"$f":"A30+1","v":21},{"$f":"'Page S-4'!D30","v":"none"},{"$f":"'Page S-4'!E30","v":372},null,null,null,{"$f":"'Page S-4'!H30","v":0},null,null,null,0]
[22,{"$f":"'Page S-4'!D31","v":372},{"$f":"'Page S-4'!E31","v":373},null,null,null,{"$f":"'Page S-4'!H31","v":0},null,null,null,0]
[23,{"$f":"'Page S-4'!D32","v":372.1},{"$f":"'Page S-4'!E32","v":373.1},null,null,null,{"$f":"'Page S-4'!H32","v":0},null,null,null,0]
[24,{"$f":"'Page S-4'!D33","v":373},{"$f":"'Page S-4'!E33","v":374},0.05,2380.9499999999998,5983.3,{"$f":"'Page S-4'!H33","v":0},null,null,null,8364.25]
[25,{"$f":"'Page S-4'!D34","v":374},{"$f":"'Page S-4'!E34","v":375},null,null,null,{"$f":"'Page S-4'!H34","v":0},null,null,null,0]
[26,{"$f":"'Page S-4'!D35","v":375},{"$f":"'Page S-4'!E35","v":376},2.5000000000000001E-2,3127.6,8124.1,{"$f":"'Page S-4'!H35","v":0},null,null,null,11251.7]
[]
[{"$f":"A36+1","v":27},{"$f":"'Page S-4'!D37","v":389},{"$f":"'Page S-4'!E37","v":"none"},null,null,null,{"$f":"'Page S-4'!H37","v":0},null,null,null,0]
[{"$f":"A38+1","v":28},{"$f":"'Page S-4'!D38","v":390},{"$f":"'Page S-4'!E38","v":"none"},null,null,null,{"$f":"'Page S-4'!H38","v":0},null,null,null,0]
[{"$f":"A39+1","v":29},{"$f":"'Page S-4'!D39","v":391},{"$f":"'Page S-4'!E39","v":391},0.05,435.97,1307.9100000000001,{"$f":"'Page S-4'!H39","v":0},null,null,null,1743.88]
[30,{"$f":"'Page S-4'!D40","v":391.1},{"$f":"'Page S-4'!E40","v":391.1},null,null,null,{"$f":"'Page S-4'!H40","v":0},null,null,null,0]
[31,{"$f":"'Page S-4'!D41","v":392},{"$f":"'Page S-4'!E41","v":392},0.05,219.25,24,{"$f":"'Page S-4'!H41","v":0},null,null,null,243.25]
[32,{"$f":"'Page S-4'!D42","v":"none"},{"$f":"'Page S-4'!E42","v":393},null,null,null,{"$f":"'Page S-4'!H42","v":0},null,null,null,0]
[33,{"$f":"'Page S-4'!D43","v":393},{"$f":"'Page S-4'!E43","v":"None"},null,null,null,{"$f":"'Page S-4'!H43","v":0},null,null,null,0]
[34,{"$f":"'Page S-4'!D44","v":394},{"$f":"'Page S-4'!E44","v":"None"},null,null,null,{"$f":"'Page S-4'!H44","v":0},null,null,null,0]
[35,{"$f":"'Page S-4'!D45","v":395},{"$f":"'Page S-4'!E45","v":"None"},null,null,null,{"$f":"'Page S-4'!H45","v":0},null,null,null,0]
[36,{"$f":"'Page S-4'!D46","v":396},{"$f":"'Page S-4'!E46","v":"None"},null,null,null,{"$f":"'Page S-4'!H46","v":0},null,null,null,0]
[37,{"$f":"'Page S-4'!D47","v":397},{"$f":"'Page S-4'!E47","v":"None"},null,null,null,{"$f":"'Page S-4'!H47","v":0},null,null,null,0]
[{"$f":"A48+1","v":38},null,null,"Total",{"$f":"SUM(E9:E48)","v":13035.22},35235.390000000007,0,0,0,0,48270.609999999993]
[null,null,null,null,"(Total to Pg 9 & Pg S-1)",null,null,null,null,null,"(Total to Pg. 4)"]
[]
[null,"Indicates a link to another worksheet within workbook"]
[null,"Indicates formula cell(s)",null,null,null,null,null,null,null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Public"]
[null,null,null,null,null,null,null,null,null,"Highly Confidential"]

{"sheet":"Page S-6","index":39,"n_rows":65,"n_cols":11,"rows_kept":65,"cut":false,"hidden":false,"merged":[[15,1,15,13],[22,1,22,9],[1,2,1,9],[28,1,28,9],[19,1,19,9],[16,1,16,9],[5,1,5,9],[3,1,3,9],[6,1,6,13],[13,5,13,9],[11,5,11,9],[40,1,40,2],[31,1,31,3],[40,3,40,6],[18,1,18,13],[2,1,2,13],[36,5,36,6],[4,1,4,13],[31,5,31,6],[34,2,34,3],[33,1,33,3],[42,1,42,2],[27,1,27,9],[33,5,33,6],[25,1,25,9],[44,7,44,9],[32,2,32,3],[36,1,36,3],[35,5,35,6],[42,3,42,6],[39,3,39,6],[21,1,21,13],[41,3,41,6],[39,1,39,2],[38,1,38,9],[24,1,24,13],[30,1,30,9],[35,1,35,3],[32,5,32,6],[34,5,34,6],[41,1,41,2]]}
[1,null,null,null,null,null,null,null,"For the calendar year of January 1 - December 31,",{"$f":"IF(Cover!D13>0, Cover!D13, \"\")","v":2012}]
[2,"Company Name:",{"$f":"IF(Cover!A1>0, Cover!A1, \"\")","v":""}]
[]
[null,"GENERAL INFORMATION"]
[3,"Treatment Facilities - Please describe process."]
[null,"Aerobic Submerged attached growth BioFilter, anerobic tanks and sand filter with UV Disinfection."]
[]
[4,"Was your treatment plant: ",null,"x","constructed in place ","OR",null,"purchased as a package unit?"]
[]
[5,"Were your lift stations:",null,"x","constructed in place ","OR",null,"purchased as a package unit?"]
[]
[6,"What is the designated capacity of your treatment facilities?",null,null,null,51000]
[]
[7,"What percent of designed capacity is currently being utilized?",null,null,null,0.32]
[]
[{"$f":"A14+1","v":8},"Please describe the treatment process for liquid waste."]
[null,"Pumped through sand filter and exposed to UV Treatment before entering receiving stream."]
[]
[{"$f":"A16+1","v":9},"Please describe the treatment process for waste solids."]
[null,"Waste Solids collected in anerobic tanks and removed by contract hauler."]
[]
[{"$f":"A19+1","v":10},"Where is the point of discharge for liquid waste?"]
[null,"Liquid waste enters unnamed tributary to Piper Creek e'ly center of WWTF."]
[]
[{"$f":"A22+1","v":11},"What is the ultimate disposal of waste solids and how obtained?"]
[null,"Solid wastes transferred to permitted treatment facility by permitted contract hauler."]
[]
[{"$f":"A25+1","v":12},"List any equipment failures occurring during the year.  Please state when failure occurred and briefly describe the failure and corrective measures taken."]
[]
[]
[null,"COLLECTING SEWERS (measurement in feet)"]
[null,"Kind of Pipe\n(i.e. Cast Iron, VCP, PVC, etc.)\n(a)",null,null,"Diameter\nof Pipe\n(b)","Total No. at\nBeginning of Year\n(c ) ",null,"Total No. of\nAdditions During the Year\n(d)","Total No. Removed or Abandoned During the Year\n(e)","Total No. at\nEnd of Year\n(f)"]
[{"$f":"A28+1","v":13},"Force:"]
[{"$f":"A33+1","v":14},"PVC",null,null,"4\"",8076,null,null,null,8076]
[{"$f":"A34+1","v":15},"Gravity:"]
[{"$f":"A35+1","v":16},"PVC",null,null,"8\"",10762,null,null,null,10762]
[{"$f":"A36+1","v":17}]
[]
[null,"LIFT STATIONS"]
[null,"Pumps:  Name, Size, Type",null,"Location ",null,null,null,"H.P.","GPM","TDH"]
[{"$f":"A37+1","v":18},null,null,"Same"]
[{"$f":"A41+1","v":19}]
[{"$f":"A42+1","v":20}]
[]
[]
[null,null,null,null,null,null,null,null,null,"(To be used when filing under seal.)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Public"]
[null,null,null,null,null,null,null,null,null,null,"Highly Confidential"]

{"sheet":"Verification Page","index":40,"n_rows":35,"n_cols":16,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,1,0,13],[1,2,1,4],[1,5,1,15],[2,7,2,14],[12,2,12,3],[12,4,12,8],[13,4,13,9],[13,11,13,13],[5,3,5,13],[7,2,7,14],[8,3,8,13],[10,4,10,8],[18,4,18,13],[19,4,19,13],[20,4,20,13],[22,2,22,13],[14,4,14,9],[15,4,15,13],[16,4,16,13],[17,4,17,13],[33,2,33,7],[31,7,31,13],[32,8,32,12],[34,0,34,15],[23,4,23,5],[23,9,23,11],[24,4,24,5],[24,9,24,11],[30,3,30,5],[30,6,30,11],[25,7,25,13],[26,7,26,13],[29,4,29,5],[29,8,29,9]]}
[]
[null,null,"Annual Report of",null,null,{"$f":"IF(Cover!A1>0, Cover!A1, \"\")","v":""}]
[null,null,null,null,null,null,null,"for the calendar year of January 1 - December 31,",null,null,null,null,null,null,null,{"$f":"IF(Cover!D13>0, Cover!D13, \"\")","v":2012}]
[]
[]
[null,null,null,"VERIFICATION"]
[]
[null,null,"The foregoing report must be verified by the oath of the President, Treasurer, General Manager or Receiver of the company. The oath required may be taken before any person authorized to administer an oath (Notary Public) by the laws of the State in which the same is taken."]
[null,null,null,"OATH"]
[]
[null,null,"State Of",null,"Missouri",null,null,null,null,"}"]
[null,null,null,null,null,null,null,null,null,"}","ss:"]
[null,null,"County Of",null,"Polk",null,null,null,null,"}"]
[null,null,null,null,"Ronda Riden",null,null,null,null,null,null,"makes oath and says that"]
[null,null,null,null,"Name of Affiant (Company Official/Representative)"]
[null,null,"s/he is",null,"Secretary/Treasurer"]
[null,null,null,null,"Official Title of the Affiant (Company Official/Representative)"]
[null,null,"of",null,"Southtown Utilities Company, Inc."]
[null,null,null,null,"Exact Legal Title or Name of the Respondent (Certificated Company Name)"]
[null,null,"and is located at",null,"4642 S. 131st Rd, Bolivar, MO 65613",null,null,null,null,null,null,null,null,null,", "]
[null,null,null,null,"Address and Telephone Number of the Affiant (Company Official/Representative)"]
[]
[null,null,"that s/he has examined the foregoing report; that to the best of his or her knowledge, information, and belief, all statements of fact contained in the said report are true and the said report is a correct statement of the business and affairs of the above-named respondent."]
[null,null,null,"from","January 1",null,", ",{"$f":"IF(Cover!D13>0, Cover!D13, \"\")","v":2012},", to and including","December 31",null,null,", ",{"$f":"IF(Cover!D13>0, Cover!D13, \"\")","v":2012}]
[null,null,null,null,"Month/Day",null,null,"Year",null,"Month/Day",null,null,null,"Year"]
[null,null,null,null,null,null,null,"/s/   Ronda Riden "]
[null,null,null,null,null,null,null,"Signature of Affiant (Company Official/Representative)"]
[]
[null,null,null,"         Subscribed and sworn to before me, a Notary Public, in and for the State  and County above named, "]
[null,null,null,"this     ",25,null,null,"day of","March",null,", ",2013,"."]
[null,null,null,"        My Commission expires",null,null,"2016-04-18",null,null,null,null,null,","]
[null,null,null,null,null,null,null,"/s/     Brenda Pearson "]
[null,null,null,null,null,null,null,null,"Signature of Notary Public"]
[null,null,"Missouri Revised Statutes § 392.210 or §393.140"]
["(See Instructions Pages II and III for more information to complete this page. )"]