{"text_format":"2","workbook":"xls","n_sheets":6,"sheets":["Instructions","Data Input","Form 219","Minor Constr. Form 219","Optional Special Equip. Summary","Optional Transformer Conv. Cost"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":5,"comments":176,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Instructions","index":0,"n_rows":120,"n_cols":11,"rows_kept":120,"cut":false,"hidden":false,"merged":[[17,1,17,11]],"flags":["formulas_cached_only"]}
[{"$nulls":10},"Version 13, 10/21/02"]
[null,null,null,"INSTRUCTIONS FOR USE OF AUTOMATED FORM 219"]
[]
[null,null,"Effective August 6, 1999, RUS published in the Federal Register a change to 7 CFR 1710."]
[null,null,"This change eliminates the traditional accounting and engineering classification of \"Ordinary "]
[null,null,"Replacement\".  This 219 implements this change by eliminating the \"Original Cost\" column."]
[null,null,"The aforementioned change combines the classifications of \"System Improvements\" and \"Ordinary "]
[null,null,"Replacements\" into a single category which will be referred to as \"Replacement of Plant\""]
[]
[null,null,"Never use the master form for data input.  Save the original form for continued use and always"]
[null,null,"enter data on a copy of the original.  The original can also be saved as a template to avoid "]
[null,null,"accidental use of the master."]
[]
[null,1,"All input for a standard form 219 (no minor construction) should be completed on the Data Input tab."]
[]
[null,2,"All input for a minor construction form 219 should be completed on the Minor Constr. Form 219 tab."]
[]
[null,"Predominant Cost"]
[]
[null,null,"When accounting for retirement or removal costs associated with new construction, the predominant cost"]
[null,null,"method should be used.  For example, if incidental to the construction of a new service, a structure in the"]
[null,null,"existing line had to be changed or removed and the new construction is the costliest part of the "]
[null,null,"project, the project would be classified as new construction.  Conversly, if the costliest part was the removal "]
[null,null,"or replacement, the project would be classified as a system improvement."]
[]
[{"$nulls":4},"Standard Work Order 219 Data Input"]
[]
[null,1,"The Data Input sheet includes one additional column \"Code Cat.\" or Code Category that is not normally "]
[null,null,"found on a normal 219.  This form requires input in this column in order to sort and subtotal your projects "]
[null,null,"by code category.  You may enter work orders in any order that you wish but you must include a Code "]
[null,null,"Category such as 300 or 100, etc.  The form will sort and subtotal your work orders according to the Code"]
[null,null,"Category that you provide for each work order.  For example:  If the first work order is project code 235, "]
[null,null,"you would insert Code Category 200 in column \"A\", Code Cat.  If the next work order was a code 101, you "]
[null,null,"would enter code 100 in column \"A\"; and so on.  "]
[]
[null,2,"Column \"C\", Year - Enter the year as a 4 digit entry; for example 1999 or 2000."]
[]
[null,3,"When you have completed entering all work orders that will be included on the subject Form 219, "]
[null,null,"review each work order to assure that there are no error messages in the \"Loan Funds\" "]
[null,null," box. If a  \"ERROR-reduce CIAC\" message appears, you should reduce Contributions In Aid of "]
[null,null,"Construction to a level that will produce $0.00 Loan Funds.  See Bulletin 1767B-2, paragraph 8.6.7.10.1. "]
[]
[null,4,"When you have completed entering and reviewing all work orders that will be included on the subject"]
[null,null," Form 219, press the Sort button.  This will sort all the work orders by Code Category.  "]
[]
[null,5,"The next step will create the Form 219 according to the data entered and sorted on the Data Input sheet. "]
[null,null,"Press the Create 219 button.  If asked whether you want to replace the contents of destination cells - Press "]
[null,null,"YES.  This action will subtotal the data by Code Category and copy the information to the blank Form 219"]
[null,null,"that is located on the first tab.  This action will also create the Summary By Budget Number that is  "]
[null,null,"located in the bottom left corner of the Form 219.  "]
[null,null,"DO NOT PRESS THE \"CREATE 219\" BUTTON MORE THAN ONCE WITHOUT FIRST PRESSING"]
[null,null,"THE \"CLEAR 219\" BUTTON."]
[]
[null,6,"If you are satisfied that the Form 219 is correct and no changes are required, go to Printing the Form 219"]
[null,null,"section below.  If corrections are needed, go to the Editing the Form 219 section below."]
[]
[{"$nulls":5},"Editing the Form 219"]
[]
[null,1,"It is very important that you follow these directions in order to successfully edit and create a new Form"]
[null,null,"219 with the corrected data."]
[]
[null,2,"DO NOT MAKE ANY CHANGES ON THE FORM 219."]
[]
[null,3,"Go to the Data Input tab and press the Clear Subtotals button.  This action will remove the subtotals that "]
[null,null,"were previous created."]
[]
[null,4,"Now press the Clear Form 219 button.  This action will remove the data from the "]
[null,null,"Form 219 located under the first tab."]
[]
[null,5,"You may now edit existing data or enter additional data.  If you need to enter new work orders, you "]
[null,null,"may enter them at the bottom of the current list of sorted work orders and press the Sort button again."]
[]
[null,6,"Now go back to Steps 2, 3 and 4 under Standard Work Order 219 Data Input above."]
[]
[{"$nulls":5},"Printing the Form 219"]
[]
[null,1,"Your almost Home!!!  You have entered all the work orders that you need or will fit on the Form 219, "]
[null,null,"corrected all the erroneous information that was obviously provided by others and verified the output"]
[null,null,"on the actual Form 219 that is located on the first tab.  You are now ready to print the final Form 219."]
[]
[null,2,"This is the easy part.  First select the Form 219 tab.  Now print this page by selecting the Print Icon or "]
[null,null,"selecting Print Command under the File drop down box.  That's all there is to it."]
[]
[null,3,"Don't forget to save your work."]
[]
[{"$nulls":5},"Creating a Minor Construction Form 219"]
[]
[null,1,"In this case, you will actually enter the information directly on the Minor Construction Form 219."]
[null,null,"It is located above the \"Minor Constr. Form 219\" tab."]
[]
[null,2,"The only difference between this form and any other standard or hard copy of a Form 219 is the fact that"]
[null,null,"an area has been provided below the section for dollar amounts for you to enter the required Description"]
[null,null,"of Construction.  In addition, the form will automatically total amounts entered in columns 4 through 9 into"]
[null,null,"column 10 (do not overwrite the formulas in column 10) and will subtotal all work order totals and create the "]
[null,null,"Summary by Budget Items total in the bottom left corner of the form.  One additional difference is the"]
[null,null,"required Environmental Certification that is provided just above the Borrower Certification."]
[]
[null,3,"Once you have entered all data required, print the form by selecting the Print Icon or the Print Command"]
[null,null,"located under the File drop down box."]
[]
[null,4,"Don’t forget to save your work."]
[]
[{"$nulls":5},"Creating a Special Equipment Summary"]
[{"$nulls":5},"and/or Transformer Conversion Cost Sheet"]
[]
[null,1,"As with the Minor Construction Form 219, this form is created by entering data directly onto the form.  The"]
[null,null,"form is located above the \"Special Equip. Summary\" tab."]
[]
[null,2,"This form works in conjunction with the Transformer Conversion Costs sheet that is located immediately "]
[null,null,"following this form.  Transformer conversion costs, if any, are first entered on the Transformer Conv."]
[null,null,"Cost sheet.  These costs are summarized for you and totals provided at the bottom of the form for your"]
[null,null,"use on the Special Equipment Summary form."]
[]
[null,3,"Data for both forms is entered in the same manner as you would on a standard, hard copy, form (see RUS"]
[null,null,"Bulletin 1767B-2 for details relating to each column."]
[]
[null,4,"To print either form, go to the form to be printed and press the Print Icon or select the Print Command"]
[null,null,"located under the File drop down box."]
[]
[null,5,"Don't forget to save your work."]

{"sheet":"Data Input","index":1,"n_rows":57,"n_cols":12,"rows_kept":57,"cut":false,"hidden":false,"merged":[[7,4,7,6],[10,8,10,10],[10,1,10,2],[10,6,10,7],[11,1,11,2],[11,8,11,9],[10,5,15,5],[2,0,2,2],[3,0,3,2],[4,0,4,2],[5,0,5,2],[6,0,6,2],[12,1,16,1],[12,2,15,2],[7,0,7,3],[10,3,11,4],[6,3,6,4],[0,0,0,11],[8,3,8,4],[9,3,9,4],[9,0,9,2],[1,3,1,4],[8,0,8,2],[3,3,3,4],[1,0,1,2],[4,3,4,4],[5,3,5,4]],"flags":["formulas_cached_only"]}
["DATA INPUT SHEET"]
["Inventory Number"]
["Month Ending"]
["System Designation"]
["Name of Borrower"]
["Manager",{"$nulls":5},"Date"]
["Board Officer",{"$nulls":5},"Date"]
["Inspection Performed By"]
["Firm"]
["License Number"]
[null,"740-C",null,"WORK ORDER",null,"Budget Item No.","GROSS FUNDS REQUIRED",null,"DEDUCTIONS"]
[null,"CODE",{"$nulls":4},"Cost Of","Cost Of","SALVAGE RELATING TO",null,"Contributions","LOAN FUNDS"]
["Code","    Code No.","     Year",null,null,null,"Construction:","Removal:","Improvements","Retirements","in Aid of","SUBJECT"]
["Cat.",null,null,"Construc-","Retire-",null,null,"Improvements","or","Without","Construction","TO ADVANCE"]
[null,null,null,"tion","ment",null,null,"or","Replacements","Replacement","and Previous","BY RUS"]
[{"$nulls":7},"Replacements",null,null,"Advances"]
[null,null,"YYYY",-1,-2,-3,-4,-5,-6,-7,-8,-9]
[{"$nulls":10},"DO NOT OVERWRITE FORMULAS IN COL. 9"]
[]
["cat.","code","Yr.","Constr.","Retire.","Bud.","Cost of Constr","Cost of Remove","Salvage","Retire W/O","CIAC","Loan Funds"]
[{"$nulls":11}," "]
[{"$nulls":11}," "]
[{"$nulls":11}," "]
[{"$nulls":11}," "]
[{"$nulls":11}," "]
[{"$nulls":11}," "]
[{"$nulls":11}," "]
[{"$nulls":11}," "]
[{"$nulls":11}," "]
[{"$nulls":11}," "]
[{"$nulls":11}," "]
[{"$nulls":11}," "]
[{"$nulls":11}," "]
[{"$nulls":11}," "]
[{"$nulls":11}," "]
[{"$nulls":11}," "]
[{"$nulls":11}," "]
[{"$nulls":11}," "]
[{"$nulls":11}," "]
[{"$nulls":11}," "]
[{"$nulls":11}," "]
[{"$nulls":11}," "]
[{"$nulls":11}," "]
[{"$nulls":11}," "]
[{"$nulls":11}," "]
[{"$nulls":11}," "]
[{"$nulls":11}," "]
[{"$nulls":11}," "]
[{"$nulls":11}," "]
[{"$nulls":11}," "]
[{"$nulls":11}," "]
[{"$nulls":11}," "]
[{"$nulls":11}," "]
[{"$nulls":11}," "]
[{"$nulls":11}," "]
[{"$nulls":11}," "]
[{"$nulls":11}," "]

{"sheet":"Form 219","index":2,"n_rows":87,"n_cols":12,"rows_kept":87,"cut":false,"hidden":false,"merged":[[87,1,87,11],[86,1,86,11],[84,4,84,7],[77,4,77,7],[77,8,77,11],[82,4,82,7],[82,8,82,11],[6,7,6,11],[7,7,7,11],[8,7,8,11],[75,4,75,7],[75,8,75,11],[10,8,10,9],[9,8,9,10],[1,7,1,10],[2,7,2,10],[5,7,5,11],[3,9,3,11],[3,7,3,8],[4,9,4,11],[4,7,4,8],[9,1,9,2],[1,1,5,6],[9,5,14,5],[0,1,0,6],[9,3,10,4],[10,1,10,2],[11,1,15,1],[11,2,15,2],[9,6,9,7],[0,7,0,10]],"flags":["formulas_cached_only"]}
[null,"USDA-RUS",{"$nulls":5},"No funds involved may be requisitioned unless a",null,null,null,"FORM APPROVED"]
[null,"INVENTORY OF WORK ORDERS",{"$nulls":5},"  completed application Form 219 has been received",null,null,null,"OMB No. 0572-0015"]
[{"$nulls":7},"      (7 U.S.C. 901 et seq.)",null,null,null,"Exp: mm/dd/yyyy"]
[{"$nulls":7},"1.  INVENTORY NO.",null,"2.  MONTH ENDING"]
[{"$nulls":7}," ",null," "]
[{"$nulls":7},"3.  SYSTEM DESIGNATION"]
[null,"Instructions - Prepare 2 copies of this form.  Forward 1 copy to the",{"$nulls":5}," "]
[null,"Rural Utilities Service, USDA-RD, Washington DC  20250.  Copy 2 is for your records.",{"$nulls":5},"4.  NAME OF BORROWER"]
[null,"For detailed instructions see RUS Bulletin 1767B-2",{"$nulls":5}," "]
[null,"740-C",null,"WORK ORDER",null,"Budget Item No.","GROSS FUNDS REQUIRED",null,"DEDUCTIONS"]
[null,"CODE",{"$nulls":4},"Cost Of","Cost Of","SALVAGE RELATING TO",null,"Contributions","LOAN FUNDS"]
[null,"    Code No.","     Year",null,null,null,"Construction:","Removal:","Improvements","Retirements","in Aid of","SUBJECT"]
[null,null,null,"Construc-","Retire-",null,null,"Improvements","or","Without","Construction","TO ADVANCE"]
[null,null,null,"tion","ment",null,null,"or","Replacements","Replacement","and Previous","BY RUS"]
[{"$nulls":7},"Replacements",null,null,"Advances"]
[null,null,null,-1,-2,-3,-4,-5,-6,-7,-8,-9]
{"$rows_empty":37}
["Grand Total",{"$nulls":10},0]
{"$rows_empty":14}
[null,"SUMMARY BY BUDGET NUMBER",null,null,"BORROWER CERTIFICATION - We certify that the costs of construction shown are the actual costs and are reflected in the general  "]
[null,"Bud.","cat.","Total","accounting records.  We further certify that funds represented by advances requested have been expended in accordance with the "]
[null,"Grand Total",null,0,"purposes of the loan, the provisions of the loan contract and mortgage, and RUS bulletins and the Code of Federal Regulations "]
[{"$nulls":4},"relative to the advance of funds for work order purposes.  We recognize that statements contained herein concern a matter within the "]
[{"$nulls":4},"jurisdiction of an agency of the United States and the making of a false, fictitious or fraudulent statement may render the maker subject "]
[{"$nulls":4},"to prosecution under Title 18, United States Code Section 1001."]
[{"$nulls":4},"DATE",null,null,null,"SIGNATURE (Manager)"]
[{"$nulls":4}," ",null,null,null," "]
[{"$nulls":4},"DATE",null,null,null,"SIGNATURE (Board Approval)"]
[{"$nulls":4}," ",null,null,null," "]
[{"$nulls":4},"ENGINEERING CERTIFICATION - I hereby certify that sufficient inspection has been made of the construction reported by this "]
[{"$nulls":4},"inventory to give me reasonable assurance that the construction complies with applicable specifications and standards and meets "]
[{"$nulls":4},"appropriate code requirements as to strength and safety.  This certification is in accordance with acceptable engineering practice."]
[{"$nulls":4},"INSPECTION PERFORMED BY",null,null,null,"FIRM"]
[{"$nulls":4}," ",null,null,null," "]
[{"$nulls":4},"LICENSE NUMBER",null,null,null,"SIGNATURE OF LICENSED ENGINEER"]
[{"$nulls":4}," "]
[null,"RUS Form 219  (Rev.10-02)",null,null,"version 13, 10/21/02"]
[null,"A federalAccording to the Paperwork Reduction Act of 1995, an agency may not conduct or sponsor, and a person is not required to respond to, nor shall a person be subject to a penalty for failure to comply with a collection of information subject to the requirements of the Paperwork Reduction Act  unless  that collection displays a currently it displays a valid OMB cControl nNumber.The valid OMB cControl nNumber for this information collection is 0572-0015. Public reporting for this  The time required to complete this information collection of information is estimated to be approximately average 1.5 hours per response, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information.\nAll responses to this collection of information are voluntary.  However, in order to obtain or retain a benefit, the information in this form is required (7 U.S.C. 901 et. Seq, as amended). Rural Development has no plans to publish information collected under the provisions of this program.  Send comments regarding this burden estimate or any other aspect of this collection of information, inlcuding suggestions for reducing this burden to:  Information Collection Clearance Officer, Rural Development Innovation Center, Regulations Management Diviison at ICRMTRequest@usda.gov."]

{"sheet":"Minor Constr. Form 219","index":3,"n_rows":86,"n_cols":11,"rows_kept":86,"cut":false,"hidden":false,"merged":[[85,0,85,10],[7,6,7,10],[8,6,8,10],[9,7,9,9],[63,8,63,9],[66,3,66,6],[74,3,74,6],[66,7,66,10],[9,5,9,6],[10,7,10,8],[9,4,14,4],[0,6,0,9],[1,6,1,9],[2,6,2,9],[3,8,3,10],[3,6,3,7],[6,6,6,10],[4,6,4,7],[4,8,4,10],[0,0,0,5],[53,0,53,1],[50,0,50,1],[51,0,51,1],[52,0,52,1],[9,0,9,1],[1,0,5,5],[10,0,10,1],[11,0,15,0],[11,1,15,1],[9,2,10,3],[5,6,5,10],[60,0,61,2],[47,0,47,1],[48,0,48,1],[49,0,49,1],[54,0,54,1],[59,0,59,1],[55,0,55,1],[56,0,56,1],[57,0,57,1],[58,0,58,1],[81,3,81,6],[83,3,83,6],[83,7,83,10],[74,7,74,10],[76,7,76,10],[81,7,81,10],[76,3,76,6]],"flags":["formulas_cached_only"]}
["USDA-RUS",{"$nulls":5},"No funds involved may be requisitioned unless a",null,null,null,"FORM APPROVED"]
["INVENTORY OF WORK ORDERS",{"$nulls":5},"completed application Form 219 has been received",null,null,null,"OMB No. 0572-0015"]
[{"$nulls":6},"      (7 U.S.C. 901 et seq.)",null,null,null,"Exp: mm/dd/yyyy"]
[{"$nulls":6},"1.  INVENTORY NO.",null,"2.  MONTH ENDING"]
[]
[{"$nulls":6},"3.  SYSTEM DESIGNATION"]
["Instructions - Prepare 2 copies of this form.  Forward 1 copy to the"]
["Rural Utilities Service, USDA-RD, Washington DC  20250.  Copy 2 is for your records.",{"$nulls":5},"4.  NAME OF BORROWER"]
["For detailed instructions see RUS Bulletin 1767B-2"]
["740-C",null,"WORK ORDER",null,"Budget Item No.","GROSS FUNDS REQUIRED",null,"DEDUCTIONS"]
["CODE",{"$nulls":4},"Cost Of","Cost Of","SALVAGE RELATING TO",null,"Contributions","LOAN FUNDS"]
["    Code No.","     Year",null,null,null,"Construction:","Removal:","Improvements","Retirements","in Aid of","SUBJECT"]
[null,null,"Construc-","Retire-",null,null,"Improvements","or","Without","Construction","TO ADVANCE"]
[null,null,"tion","ment",null,null,"or","Replacements","Replacement","and Previous","BY RUS"]
[{"$nulls":6},"Replacements",null,null,"Advances"]
[null,null,-1,-2,-3,-4,-5,-6,-7,-8,-9]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
["Subtotal",{"$nulls":4},0,0,0,0,0,0]
["Work OrderNo.",{"$nulls":5},"Description of Construction"]
{"$rows_empty":13}
["SUMMARY BY BUDGET ITEMS",null,null,"ENVIRONMENTAL CERTIFICATION - FOR MINOR PROJECT 219 ONLY"]
[null,null,null,1,null,"We certify that construction reported on the above listed work orders (except certification \"2\" below), is a categorical exclusion "]
["Item ","740-C",null,null,null,"of a type described in 7 CFR 1794.31 (b) which normally does not require preparation of a Borrower's Environmental Report."]
["No.","Code","Amount",2,null,"We certify that construction reported on work orders",{"$nulls":4},"above, is a categorical "]
[{"$nulls":5},"exclusion of a type that normally requires a Borrower's Environmental Report which is attached."]
[1,null,0,"DATE",null,null,null,"SIGNATURE (Manager)"]
[]
[null,null,null,"BORROWER CERTIFICATION - We certify that the costs of construction shown are the actual costs and are reflected in the general  "]
[null,null,null,"accounting records.  We further certify that funds represented by advances requested have been expended in accordance with the "]
[null,null,null,"purposes of the loan, the provisions of the loan contract and mortgage, and RUS bulletins and the Code of Federal Regulations "]
[null,null,null,"relative to the advance of funds for work order purposes.  We recognize that statements contained herein concern a matter within the "]
[null,null,null,"jurisdiction of an agency of the United States and the making of a false, fictitious or fraudulent statement may render the maker subject "]
[null,null,null,"to prosecution under Title 18, United States Code Section 1001."]
[null,null,null,"DATE",null,null,null,"SIGNATURE (Manager)"]
[]
[null,null,null,"DATE",null,null,null,"SIGNATURE (Board Approval)"]
[]
[null,null,null,"ENGINEERING CERTIFICATION - I hereby certify that sufficient inspection has been made of the construction reported by this "]
[null,null,null,"inventory to give me reasonable assurance that the construction complies with applicable specifications and standards and meets "]
[null,null,null,"appropriate code requirements as to strength and safety.  This certification is in accordance with acceptable engineering practice."]
[null,null,null,"INSPECTION PERFORMED BY",null,null,null,"FIRM"]
["Total",null,0]
[null,null,null,"LICENSE NUMBER",null,null,null,"SIGNATURE OF LICENSED ENGINEER"]
[]
["RUS Form 219  (Rev. 10-02)",null,null,"version 13, 10/21/02"]
["A federalAccording to the Paperwork Reduction Act of 1995, an agency may not conduct or sponsor, and a person is not required to respond to, nor shall a person be subject to a penalty for failure to comply with a collection of information subject to the requirements of the Paperwork Reduction Act  unless  that collection displays a currently it displays a valid OMB cControl nNumber.The valid OMB cControl nNumber for this information collection is 0572-0015. Public reporting for this  The time required to complete this information collection of information is estimated to be approximately average 1.5 hours per response, including the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information.\nAll responses to this collection of information are voluntary.  However, in order to obtain or retain a benefit, the information in this form is required (7 U.S.C. 901 et. Seq, as amended). Rural Development has no plans to publish information collected under the provisions of this program.  Send comments regarding this burden estimate or any other aspect of this collection of information, inlcuding suggestions for reducing this burden to:  Information Collection Clearance Officer, Rural Development Innovation Center, Regulations Management Diviison at ICRMTRequest@usda.gov."]

{"sheet":"Optional Special Equip. Summary","index":4,"n_rows":49,"n_cols":14,"rows_kept":49,"cut":false,"hidden":false,"merged":[[46,1,47,9],[46,10,47,13],[18,1,18,6],[28,1,28,6],[39,1,39,6],[41,1,41,13],[40,1,40,10],[5,6,6,6],[2,1,8,1],[2,2,8,2],[0,0,0,13],[5,4,6,4],[5,5,6,5]],"flags":["formulas_cached_only"]}
["Optional form"]
[null,"CODE 600",{"$nulls":4},"SUMMARY OF SPECIAL EQUIPMENT COSTS"]
[null,"Date","Reference",{"$nulls":6},"Transformer",null,null,"Salvage Value"]
[{"$nulls":9},"Conversion",null,null,"of Old"]
[{"$nulls":7},"Invoice","Labor","Costs","Estimated","Loan Funds","Transformers"]
[null,null,null,"Quan-","Size","Manufacturer","Type","Cost and","and","(from Col.10","Cost of","Subject to","(from Col. 6","Total Cost"]
[null,null,null,"ity",null,null,null,"Freight","Other","Trans. Conv. ","Installation","Advance","Trans. Conv. ","Capitalized"]
[{"$nulls":9},"Costs",null,null,"Costs"]
[null,null,null,-1,-2,-3,-4,-5,-6,-7,-8,-9,-10,-11]
[null,"Account 370, Meters - Meter Sockets, Current and Potential Transformers"]
[{"$nulls":11}," ",null," "]
[{"$nulls":11}," ",null," "]
[{"$nulls":11}," ",null," "]
[{"$nulls":11}," ",null," "]
[{"$nulls":11}," ",null," "]
[{"$nulls":11}," ",null," "]
[{"$nulls":11}," ",null," "]
[{"$nulls":11}," ",null," "]
[null,"TOTALS",{"$nulls":5},0,0,null,0,0,null,0]
[null,"Account 368, Line Transformers - Voltage Regulators"]
[{"$nulls":11}," ",null," "]
[{"$nulls":11}," ",null," "]
[{"$nulls":11}," ",null," "]
[{"$nulls":11}," ",null," "]
[{"$nulls":11}," ",null," "]
[{"$nulls":11}," ",null," "]
[{"$nulls":11}," ",null," "]
[{"$nulls":11}," ",null," "]
[null,"TOTALS",{"$nulls":5},0,0,0,0,0,0,0]
[null,"Account 365, Overhead Conductors and Devices - Oil Circuit Reclosers and Sectionalizers"]
[{"$nulls":11}," ",null," "]
[{"$nulls":11}," ",null," "]
[{"$nulls":11}," ",null," "]
[{"$nulls":11}," ",null," "]
[{"$nulls":11}," ",null," "]
[{"$nulls":11}," ",null," "]
[{"$nulls":11}," ",null," "]
[{"$nulls":11}," ",null," "]
[{"$nulls":11}," ",null," "]
[null,"TOTALS",{"$nulls":5},0,0,null,0,0,null,0]
[null,"MONTHLY GRAND TOTAL LOAN FUNDS SUBJECT TO ADVANCE",{"$nulls":9},0]
[null,"BORROWER CERTIFICATION"]
[null,null,"I certify that the costs of construction shown are the actual costs and are reflected in the general accounting records.  We further certify that funds represented"]
[null,null,"by advances requested have been expensed in accordance with the purposes of the loan, the provisions of the loan contract and mortgage, and RUS bulletins"]
[null,null,"and the Code of Federal Regulations relative to the advance of funds for work order purposes."]
[null,"Manager's Signature",{"$nulls":8},"Date"]
[]
[]
[null,"V 13, 10/21/02"]

{"sheet":"Optional Transformer Conv. Cost","index":5,"n_rows":49,"n_cols":15,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,0,0,14],[2,1,8,1],[2,2,8,2],[3,4,3,5],[3,6,3,9]],"flags":["formulas_cached_only"]}
["Optional Form"]
[{"$nulls":6},"TRANSFORMER CONVERSION COSTS"]
[null,"DATE","REFERENCE",{"$nulls":9},"TOTAL","TOTAL COST","CONVERTED"]
[{"$nulls":4},"Size in KVA",null,"Retired Transformers",{"$nulls":5},"CONVERSION","OF CONVERTED","UNIT COST"]
[{"$nulls":7},"ORIGINAL",null,"RETIREMENT","INVOICE COST","OTHER","COST -","TRANSFORMERS","COL. 11 /"]
[null,null,null,"QUANTITY","OLD","NEW","TYPE","INSTALLED","SALVAGE","LOSS - COL.","OF CONVERSION","CONVERSION","COL. 8 +","COL. 6 +","COL. 1"]
[{"$nulls":7},"COST",null,"5 - COL. 6","AND FREIGHT","COSTS","COL. 9","COL. 10"]
[]
[null,null,null,-1,-2,-3,-4,-5,-6,-7,-8,-9,-10,-11,-12]
[{"$nulls":9}," ",null,null," "," "," "]
[{"$nulls":9}," ",null,null," "," "," "]
[{"$nulls":9}," ",null,null," "," "," "]
[{"$nulls":9}," ",null,null," "," "," "]
[{"$nulls":9}," ",null,null," "," "," "]
[{"$nulls":9}," ",null,null," "," "," "]
[{"$nulls":9}," ",null,null," "," "," "]
[{"$nulls":9}," ",null,null," "," "," "]
[{"$nulls":9}," ",null,null," "," "," "]
[{"$nulls":9}," ",null,null," "," "," "]
[{"$nulls":9}," ",null,null," "," "," "]
[{"$nulls":9}," ",null,null," "," "," "]
[{"$nulls":9}," ",null,null," "," "," "]
[{"$nulls":9}," ",null,null," "," "," "]
[{"$nulls":9}," ",null,null," "," "," "]
[{"$nulls":9}," ",null,null," "," "," "]
[{"$nulls":9}," ",null,null," "," "," "]
[{"$nulls":9}," ",null,null," "," "," "]
[{"$nulls":9}," ",null,null," "," "," "]
[{"$nulls":9}," ",null,null," "," "," "]
[{"$nulls":9}," ",null,null," "," "," "]
[{"$nulls":9}," ",null,null," "," "," "]
[{"$nulls":9}," ",null,null," "," "," "]
[{"$nulls":9}," ",null,null," "," "," "]
[{"$nulls":9}," ",null,null," "," "," "]
[{"$nulls":9}," ",null,null," "," "," "]
[{"$nulls":9}," ",null,null," "," "," "]
[{"$nulls":9}," ",null,null," "," "," "]
[{"$nulls":9}," ",null,null," "," "," "]
[{"$nulls":9}," ",null,null," "," "," "]
[{"$nulls":9}," ",null,null," "," "," "]
[{"$nulls":9}," ",null,null," "," "," "]
[null,"CREDIT ACCT. 368, DEBIT ACCT. 106.8",{"$nulls":5},0]
[null,"DEBIT ACCT. 107.3, CREDIT ACCT. 108.8",{"$nulls":6},0]
[null,"DEBIT ACCT. 108.6, CREDIT ACCT. 108.8",{"$nulls":7},0]
[null,"TOTAL INVOICE PRICE, DEBIT ACCT. 107.3",{"$nulls":8},0]
[null,"TOTAL OTHER COST, DEBIT ACCT. 107.3",{"$nulls":9},0]
[null,"TOTAL CONVERSION COST",{"$nulls":10},0]
[null,"GRAND TOTAL",{"$nulls":11},0]
[null,"V 13, 10/21/02"]