{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Introduction","Checklist","Schools","Libraries","Telemedicine","Lifeline","Change History","Documentation"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":5,"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":"Introduction","index":0,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[[4,1,4,2],[7,1,7,2]]}
[]
[null,"GVNW/OUSF Monthly Payment Request Worksheet"]
[null,null,"Version 1.7.1 - 11/18/21"]
[]
[null,"Service Provider ID:"]
[null,null,null,"Use this format: OK00#### (OK plus a 6 digit number, usually starting with two zeroes)"]
[]
[null,"Service Provider Name:"]
[]
[]
[null,"Instructions:"]
[null,null,"Enter data in all required columns - marked with (*)."]
[null,null,"If columns do not apply, leave the cells blank.  Do not enter \"N/A\" or other filler text."]
[null,null,"If a tab does not apply, leave it blank."]
[null,null,"After data has been entered, click the green button to check for errors.  -->"]
[null,null,"(This can be done as many times as necessary.)"]
[null,null,"Formulas on calculated columns will be added by the Check Data Now process."]
[null,null,"Cells with missing or invalid data will be highlighted RED."]
[]
[null,"Notes:"]
[null,null,"This workbook is protected to promote data consistency and accuracy."]
[null,null,"Adding, removing or formatting columns on any worksheet is not allowed."]
[null,null,"Adding or removing worksheets (tabs) is not allowed.",null,null,null," "]
[null,null,"Please contact OUSF@vantagepnt.com to report issues with this template."]

{"sheet":"Checklist","index":1,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[25,1,25,6],[26,1,26,6],[19,1,19,2],[16,1,16,2]]}
[]
[null,"Monthly MPR Checklist"]
[]
[null,"Please initial each item below as it is completed, and add your name and the date at the bottom before submitting."]
[null,"If an item does not apply to this submission (e.g., if this is your first MPR submission), enter \"N/A.\"  Do not leave blank."]
[]
[null,null,null,null,"Initials:"]
[null,"1.","I have updated my current payment request information based on corrections made by the OUSF Administrator to last month's payment request."]
[null,"2.","I have reviewed all PUD Remarks and emails to ensure any items from last month have been addressed, or will be addressed through this MPR."]
[null,"3.","I have input my updated data into a blank template of the most recent OUSF Monthly Payment Request (MPR) Worksheet."]
[null,"4.","I have updated service dates for all recurring circuits to ensure that I do not duplicate a row from the previous month's report."]
[null,"5.","I affirm that no changes to invoice amounts or bandwidths have occurred for the requested circuit funding, other than changes that have been processed and approved through an Application or Change Request."]
[null,"6.","I have verified that all data for new or changed circuits agrees with the approved Change Request Worksheet and/or the GVNW Worksheet provided by PUD Staff."]
[null,"7.","I have run the \"Check Data\" function from the Introduction tab, and have corrected as necessary the errors it identified."]
[]
[]
[null,"Submission Prepared By:"]
[]
[]
[null,"Date Completed:"]
[]
[]
[null,null,null,"By initialing each item and entering your name and date above, you certify that the information contained in this submission is true and accurate to the best of your knowledge."]
[]
[]
[null,"Send this completed file to the Oklahoma Corporation Commission and GVNW by clicking the following link (or copy-pasting into a new email):"]
[null,"OUSF@occ.ok.gov; nicole.stephens@vantagepnt.com"]

{"sheet":"Schools","index":2,"n_rows":1,"n_cols":19,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Original / Revised*","Cause Number*\n(9 digits, no hyphen)","Beneficiary/Circuit Name\n(For reference only; use any name that will help you identify the circuit)","Circuit ID*","Circuit Disconnect Date","Type of Service*\n(Internet, WAN, or Non-Recurring)","Actual Monthly Invoice Amount*","OUSF Determined Monthly Invoice Amount*","E-rate Year\n(calculated)","E-rate Discount %*","Monthly Net of\nE-rate (calculated)","Invoice Date*","Beginning Service Date Included*","Ending Service Date Included*","Amount Sought*","PUD Adjustments","PUD Approved Amount","Remarks","PUD Remarks"]

{"sheet":"Libraries","index":3,"n_rows":1,"n_cols":19,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Original / Revised*","Cause Number*\n(9 digits, no hyphen)","Beneficiary/Circuit Name\n(For reference only; use any name that will help you identify the circuit)","Circuit ID*","Circuit Disconnect Date","Type of Service*\n(Internet, WAN, or Non-Recurring)","Actual Monthly Invoice Amount*","OUSF Determined Monthly Invoice Amount*","E-rate Year\n(calculated)","E-rate Discount %*","Monthly Net of\nE-rate (calculated)","Invoice Date*","Beginning Service Date Included*","Ending Service Date Included*","Amount Sought*","PUD Adjustments","PUD Approved Amount","Remarks","PUD Remarks"]

{"sheet":"Telemedicine","index":4,"n_rows":1,"n_cols":21,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Original / Revised*","Cause Number*\n(9 digits, no hyphen)","Funding Approved or Updated After Passage of HB 2616?*\n(Y/N)","Beneficiary/Circuit Name\n(For reference only; use any name that will help you identify the circuit)","Circuit ID*","Circuit Disconnect Date","Type of Service*\n(Internet, WAN, or Non-Recurring)","Actual Monthly Invoice Amount*","OUSF Determined Monthly Invoice Amount*","USAC RHC Year\n(calculated)","USAC RHC Funding Amount","USAC RHC Funding %","Monthly Net of USAC RHC Funding\n(calculated)","Invoice Date*","Beginning Service Date Included*","Ending Service Date Included*","Amount Sought*","PUD Adjustments","PUD Approved Amount","Remarks","PUD Remarks"]

{"sheet":"Lifeline","index":5,"n_rows":1,"n_cols":13,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Original / Revised*","Cause Number*\n(9 digits, no hyphen)","Beginning Enrollment Date Included*","Ending Enrollment Date Included*","Beginning Customer Count*","Customers Added*","Customers Removed*","Ending Customer Count (calculated)","Lifeline Credit Amount (calculated)","Total Lifeline Funding Due (calculated)","PUD Approved Amount","Remarks","PUD Remarks"]

{"sheet":"Change History","index":6,"n_rows":82,"n_cols":3,"rows_kept":82,"cut":false,"hidden":true,"merged":[]}
["Version","Date","Changes"]
["1.6.1","2019-06-01","Intro Tab - changed wording to clarify how to run Check Data macro"]
[null,null,"Telemedicine Tab - Check Data macro now rounds RHC Funding Amount to nearest penny"]
[null,null,"All Tabs - Check Data macro no longer prefills standard formula for PUD Adjustments, PUD Approved Amount"]
[null,null,"Changed from .xls to .xlsm file format by default (will also have .xls version as backup if needed by individual carriers)"]
[1.6,"2017-08-01","Intro Tab - Moved \"Dated Submitted\" to Checklist Tab"]
[null,null,"Checklist Tab - New tab, includes Excel version of PDF checklist; added \"Submission Prepared By\"; moved \"Date Submitted\" and email link from Intro Tab"]
[null,null,"Schools Tab - Deleted multiple columns which were not being uploaded, validated, or used to complete rest of worksheet; added VBA code to calculate E-rate year, round $ amounts and E-rate % as necessary"]
[null,null,"Libraries Tab - Deleted multiple columns which were not being uploaded, validated, or used to complete rest of worksheet; added VBA code to calculate E-rate year, round $ amounts and E-rate % as necessary"]
[null,null,"Telemedicine Tab - Deleted multiple columns; added new column for Pre-or-Post HB 2616 and USAC RHC %; added VBA code to calculate USAC RHC year, round $ amounts USAC RHC % as necessary"]
[null,null,"Toll-Free Tab removed"]
[null,null,"Lifeline Tab - Deleted hidden columns, Order Number, and Amount Sought (calculated Lifeline Funding Due will serve as Amount Sought)"]
[null,null,"All tabs -  Updated header names, removed Data Validation instructions (incorporated into parentheticals in header where possible)"]
["1.5.10","2016-05-05","Schools tab - Remove error checking for column X, change made by Chuck B"]
[null,null,"Libraries tab - Hide column AL, change made by Chuck B"]
[null,null,"Column Heading changes made by OCC staff"]
["1.5.10","2016-01-13","Intro tab changes for additional instructions & email contacts"]
[null,null,"Schools tab - Hide columns (F,G,H,I,N,T,W,Y,Z,AA,AC,AD that were all required before, so had to remark out vba code accordingly).  Also change formula for Column AI - Net Erate Calc."]
[null,null,"Libraries tab - Hide columns (I,O,R,S,T,U,W,X that were all required before, so had to remark out vba code accordingly).  Also change formula for Column AC - Net Erate Calc."]
[null,null,"Telemedicine tab - Hide columns (H & R that were all required before, so had to remark out vba code accordingly). "]
[null,null,"Toll-Free tab - Hide columns (H that was required before, so had to remark out vba code accordingly).  Also change formula for Column Q - Net Erate Calc."]
[null,null,"Lifeline tab - Hide columns (D that was required before, so had to remark out vba code accordingly). "]
["1.5.9","09/102015","Changes to Intro tab for new email addresses & contacts"]
["1.5.8","2015-06-04","Changed code to leave cell background formatting in header rows to allow for customized color coding; also ran spell check and fixed typos"]
["1.5.7","2015-06-03","Added rounding (2 decimal places) to Amount Sought column on all tabs"]
["1.5.6","2015-05-29","Changed E-Rate fields to allow years back to 1999 instead of 2010"]
["1.5.5","2015-05-21","Removed required condition on Lifeline col M "]
["1.5.4","2015-05-20","Add Amount Requested column (M) to Lifeline, change Amount Sought column (L) name but not formula or function"]
[null,null,"Update code to reflect additional column and check for non blank numeric value"]
["1.5.3","2015-05-11","Increased number of blank rows to be deleted from 5 to 15"]
[null,null,"Added code to remove leading and trailing spaces on all worksheets"]
[null,null,"Skip the data check on rows where the Amount Sought is zero (or blank)"]
["1.5.2","2015-05-04","Added code to unlock all rows on all worksheets - deal with issue of cells being locked via copy and paste"]
["1.5.1","2015-05-04","Fixed code on Introduction page"]
[null,null,"Updated formatting in bandwidth columns to show zero decimal places"]
[null,null,"Fixed issue with locked cells after data entry"]
[1.5,"2015-04-29","Reset the row height in code to prevent tall rows (this was only showing up on Chuck’s computer using Excel 2010)"]
[null,null,"Enter zero if Amount Sought is blank"]
[null,null,"Unlock formula columns and add all formulas using code so that users can copy and paste the entire list – formulas will be added only after clicking the “Check Data Now” button on the Introduction tab"]
[null,null,"All dates are validated to be between 1990 and next year"]
[null,null,"Service start dates must be earlier than service end dates on all tabs"]
[null,null,"E-Rate year and RHC Year must be between 2010 and next year"]
[null,null,"Trim all data before checking to catch spaces as invalid data"]
[null,null,"Check and fix the Service Provider ID on the Introduction tab"]
[null,null,"Check for Service Provider Name and Date Submitted on the Introduction tab"]
[1.4,"2015-04-20","Removed all conditional formatting and added VBA code to perform all data checks"]
[null,null,"Added code to convert all E-Rate columns to percents if data entered is not a percent - Change 80 to .8 (or 8%)"]
[null,null,"Added additional validation on dates"]
[null,null,"Added code to insert formulas - unprotected formula columns to allow copy and paste"]
[null,null,"Changed column headings to match database per Chuck and Nicole"]
[1.3,"2015-04-10","Add formula to Monthly Net of E-Rate columns on Schools (Col AI) and Libraries (Col AC)"]
[null,null,"Add formula to Monthly Net of Applicabale RHC on Telemedicine (Col W)"]
[1.2,"2015-03-10","Correct formatting rules on all E-Rate columns - allow 0 and .9 as valid options"]
[null,null,"Update formatting rules to ignore leading and trailing spaces on columns that require certain values (Original/Revised, Leased/Owned, etc)"]
[null,null,"On Telemedicine tab, remove service types (Col M) specific to certain carriers - remove Metro, Frame Relay and ATM; only allow Internet, Point to Point and WAN"]
[null,null,"On Telemedicine tab, change Healthcare Provider Number (Col E) to be not required"]
[1.1000000000000001,"2015-02-17","Update conditional formatting to make additional columns required"]
[null,null,"Change verbiage on some column headings per OCC request"]
[1,"2015-02-04","Initital standardized version (changes listed here are compared to previous unprotected version)"]
[null,null,"·         Added Service Provider ID to new Introduction tab"]
[null,null,"·         Moved Date Submitted and Service Provider Name to new Introduction tab and removed both from all tabs"]
[null,null,"·         Added Beginning Service Date Included and Ending Service Date Included to all tabs"]
[null,null,"·         Removed Invoice Start Date and Invoice End Date from all tabs"]
[null,null,"·         Added Invoice Date to all tabs"]
[null,null,"·         Split Bandwidth into two fields - Numerical Value and Measurement - on Schools and Libraries, and similarly split both Actual Billed Bandwidth and OUSF Approved Bandwidth on Telemedicine"]
[null,null,"·         Added Dedicated/Shared to Schools, Libraries and Telemedicine"]
[null,null,"·         Added Usage Amount to Toll-Free"]
[null,null,"·         Added formulas to Ending Customer Count, Lifeline Credit Amount and Amount Sought on the Lifeline tab"]
[null,null,"·         Updated some column names and order for consistency, brevity, accuracy"]
[null,null,"·         Set base formatting for all columns (some number and date formats may change slightly upon copy and paste, but this is okay)"]
[null,null,"·         Added conditional formatting rules - cells turn red if data violates rules"]
[null,null,"o    Required fields are marked with (*) and will turn red if missing on lines where the Amount Sought is an amount greater than zero"]
[null,null,"o    Columns that require certain values have those values listed in parentheses or the column names are the two possible options separated by a slash and will turn red if data entered is not one of the possible options - case insensitive"]
[null,null,"o    Date and numeric columns will turn red if non-numeric text or invalid dates are present"]
[null,null,"o    E-Rate columns on Schools, Libraries, Telemedicine and Toll-Free tabs will turn red unless the data is a number greater than 0 and less than or equal to .9"]
[null,null,"o    E-Rate Year columns on Schools, Libraries, Telemedicine tabs and RHC Year on Toll-Free tabs will turn red unless the data is a number between and including 2000 and the year after the current year"]
[null,null,"·         All user tabs are protected using a password"]
[null,null,"o    Users can insert and delete rows"]
[null,null,"o    Users cannot insert or delete columns "]
[null,null,"o    Users cannot change most formatting (some date and number format changes cannot be restricted, especially if data is copied from elsewhere and pasted to Excel)"]
[null,null,"·         Developer documentation tabs are hidden from users"]
[null,null,"·         The workbook structure is protected using a password"]

{"sheet":"Documentation","index":7,"n_rows":82,"n_cols":7,"rows_kept":82,"cut":false,"hidden":true,"merged":[[0,0,0,2],[1,0,1,2],[2,0,2,2]]}
["DEVELOPER DOCUMENTATION",null,null,"NOTES:"]
["Updated for Version 1.6 by John Givens (PUD)",null,null,null,"All data is checked using VBA code according to the rules listed here."]
[null,null,null,null,"The workbook and all worksheets are protected with the same password."]
[]
[]
["Worksheet","Col","Field Name","Required","Numeric","Data Entry Restrictions","Formatting"]
["Introduction",null,"Named Range: ServiceProviderID","Y",null,"OK######","General"]
["Introduction",null,"Named Range: ServiceProviderName","Y",null,null,"General"]
["Checklist",null,"Named Range: SubmissionPreparedBy","Y",null,null,"General"]
["Checklist",null,"Named Range: DateSubmitted","Y","Y","code checks for valid date","mm/dd/yyyy"]
["Schools","A",{"$f":"INDIRECT(A11 & \"!\" & B11 & \"1\")","v":"Original / Revised*"},{"$f":"IF(ISNUMBER((SEARCH(\"~*\",C11))), \"Y\", \"N\")","v":"Y"},null,"original, revised","General"]
["Schools","B",{"$f":"INDIRECT(A12 & \"!\" & B12 & \"1\")","v":"Cause Number*\n(9 digits, no hyphen)"},"Y","Y","parsed in code","General"]
["Schools","C","Beneficiary/Circuit Name\n(For reference only; use any name that will help you identify the circuit)","N",null,null,"General"]
["Schools","D","Circuit ID*","Y",null,null,"General"]
["Schools","E","Circuit Disconnect Date","N","Y","code checks for valid date (or blank)","mm/dd/yyyy"]
["Schools","F","Type of Service*\n(Internet, WAN, or Non-Recurring)","Y",null,"internet, wan, non-recurring","General"]
["Schools","G","Actual Monthly Invoice Amount*","Y","Y",null,"Accounting (no currency symbol)"]
["Schools","H","OUSF Determined Monthly Invoice Amount*","Y","Y",null,"Accounting (no currency symbol)"]
["Schools","I","E-rate Year\n(calculated)","N","Y","calculated","General"]
["Schools","J","E-rate Discount %*","Y","Y","percent (underlying value is still number between 0 and 1)","Percent"]
["Schools","K","Monthly Net of\nE-rate (calculated)","N","Y","calculated","Accounting (no currency symbol)"]
["Schools","L","Invoice Date*","Y","Y","code checks for valid date","mm/dd/yyyy"]
["Schools","M","Beginning Service Date Included*","Y","Y","code checks for valid date","mm/dd/yyyy"]
["Schools","N","Ending Service Date Included*","Y","Y","code checks for valid date","mm/dd/yyyy"]
["Schools","O","Amount Sought*","Y","Y","not equal to zero (zero Amount Sought rows not processed)","Accounting (no currency symbol)"]
["Schools","P","PUD Adjustments","N","Y","hidden-PUD use only","Accounting (no currency symbol)"]
["Schools","Q","PUD Approved Amount","N","Y","hidden-PUD use only","Accounting (no currency symbol)"]
["Schools","R","Remarks","N",null,null,"General"]
["Schools","S",{"$f":"INDIRECT(A29 & \"!\" & B29 & \"1\")","v":"PUD Remarks"},{"$f":"IF(ISNUMBER((SEARCH(\"~*\",C29))), \"Y\", \"N\")","v":"N"},null,"hidden-PUD use only","General"]
["Libraries","A",{"$f":"INDIRECT(A30 & \"!\" & B30 & \"1\")","v":"Original / Revised*"},"Y",null,"original, revised","General"]
["Libraries","B",{"$f":"INDIRECT(A31 & \"!\" & B31 & \"1\")","v":"Cause Number*\n(9 digits, no hyphen)"},"Y","Y","parsed in code","General"]
["Libraries","C","Beneficiary/Circuit Name\n(For reference only; use any name that will help you identify the circuit)","N",null,null,"General"]
["Libraries","D","Circuit ID*","Y",null,null,"General"]
["Libraries","E","Circuit Disconnect Date","N","Y","code checks for valid date (or blank)","mm/dd/yyyy"]
["Libraries","F","Type of Service*\n(Internet, WAN, or Non-Recurring)","Y",null,"internet, wan, non-recurring","General"]
["Libraries","G","Actual Monthly Invoice Amount*","Y","Y",null,"Accounting (no currency symbol)"]
["Libraries","H","OUSF Determined Monthly Invoice Amount*","Y","Y",null,"Accounting (no currency symbol)"]
["Libraries","I","E-rate Year\n(calculated)","N","Y","calculated","General"]
["Libraries","J","E-rate Discount %*","Y","Y","percent (underlying value is still number between 0 and 1)","Percent"]
["Libraries","K","Monthly Net of\nE-rate (calculated)","N","Y","calculated","Accounting (no currency symbol)"]
["Libraries","L","Invoice Date*","Y","Y","code checks for valid date","mm/dd/yyyy"]
["Libraries","M","Beginning Service Date Included*","Y","Y","code checks for valid date","mm/dd/yyyy"]
["Libraries","N","Ending Service Date Included*","Y","Y","code checks for valid date","mm/dd/yyyy"]
["Libraries","O","Amount Sought*","Y","Y","not equal to zero (zero Amount Sought rows not processed)","Accounting (no currency symbol)"]
["Libraries","P","PUD Adjustments","N","Y","hidden-PUD use only","Accounting (no currency symbol)"]
["Libraries","Q","PUD Approved Amount","N","Y","hidden-PUD use only","Accounting (no currency symbol)"]
["Libraries","R","Remarks","N",null,null,"General"]
["Libraries","S","PUD Remarks",{"$f":"IF(ISNUMBER((SEARCH(\"~*\",C48))), \"Y\", \"N\")","v":"N"},null,"hidden-PUD use only","General"]
["Telemedicine","A",{"$f":"INDIRECT(A49 & \"!\" & B49 & \"1\")","v":"Original / Revised*"},"Y",null,"original/revised","General"]
["Telemedicine","B","Cause Number*\n(9 digits, no hyphen)","Y","Y","parsed in code","General"]
["Telemedicine","C","Funding Approved or Updated After Passage of HB 2616?*\n(Y/N)","Y",null,"y, n","General"]
["Telemedicine","D","Beneficiary/Circuit Name\n(For reference only; use any name that will help you identify the circuit)","N",null,null,"General"]
["Telemedicine","E","Circuit ID*","Y",null,null,"General"]
["Telemedicine","F","Circuit Disconnect Date","N","Y","code checks for valid date (or blank)","mm/dd/yyyy"]
["Telemedicine","G","Type of Service*\n(Internet, WAN, or Non-Recurring)","Y",null,"internet, wan, non-recurring","General"]
["Telemedicine","H","Actual Monthly Invoice Amount*","Y","Y",null,"Accounting (no currency symbol)"]
["Telemedicine","I","OUSF Determined Monthly Invoice Amount*",{"$f":"IF(ISNUMBER((SEARCH(\"~*\",C57))), \"Y\", \"N\")","v":"Y"},"Y",null,"Accounting (no currency symbol)"]
["Telemedicine","J","USAC RHC Year\n(calculated)","N","Y","calculated","General"]
["Telemedicine","K","USAC RHC Funding Amount","N","Y",null,"Accounting (no currency symbol)"]
["Telemedicine","L","USAC RHC Funding %","N","Y","percent (underlying value is still number between 0 and 1)","Percent"]
["Telemedicine","M","Monthly Net of USAC RHC Funding\n(calculated)","N","Y","calculated","Accounting (no currency symbol)"]
["Telemedicine","N","Invoice Date*","Y","Y","code checks for valid date","mm/dd/yyyy"]
["Telemedicine","O","Beginning Service Date Included*","Y","Y","code checks for valid date","mm/dd/yyyy"]
["Telemedicine","P","Ending Service Date Included*","Y","Y","code checks for valid date","mm/dd/yyyy"]
["Telemedicine","Q","Amount Sought*","Y","Y","not equal to zero (zero Amount Sought rows not processed)","Accounting (no currency symbol)"]
["Telemedicine","R","PUD Adjustments","N","Y","hidden-PUD use only","Accounting (no currency symbol)"]
["Telemedicine","S","PUD Approved Amount","N","Y","hidden-PUD use only","Accounting (no currency symbol)"]
["Telemedicine","T","Remarks","N",null,null,"General"]
["Telemedicine","U","PUD Remarks","N",null,"hidden-PUD use only","General"]
["Lifeline","A","Original / Revised*","Y",null,"original, revised","General"]
["Lifeline","B","Cause Number*\n(9 digits, no hyphen)","Y","Y","parsed in code","General"]
["Lifeline","C","Beginning Enrollment Date Included*","Y","Y","code checks for valid date","mm/dd/yyyy"]
["Lifeline","D","Ending Enrollment Date Included*","Y","Y","code checks for valid date","mm/dd/yyyy"]
["Lifeline","E","Beginning Customer Count*","Y","Y",null,"General"]
["Lifeline","F","Customers Added*","Y","Y",null,"General"]
["Lifeline","G","Customers Removed*","Y","Y",null,"General"]
["Lifeline","H","Ending Customer Count (calculated)","N","Y","calculated","General"]
["Lifeline","I","Lifeline Credit Amount (calculated)","N","Y","calculated","Accounting (no currency symbol)"]
["Lifeline","J","Total Lifeline Funding Due (calculated)","N","Y","calculated","Accounting (no currency symbol)"]
["Lifeline","K","PUD Approved Amount","N","Y","hidden-PUD use only","Accounting (no currency symbol)"]
["Lifeline","L","Remarks","N",null,null,"General"]
["Lifeline","M","PUD Remarks","N",null,"hidden-PUD use only","General"]