{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Category 1 Internet Access","Recipients of Service","List of Errors","Flag","471C1LineItemsRef","LOVs","Performance"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":15,"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":"Category 1 Internet Access","index":0,"n_rows":4,"n_cols":25,"rows_kept":4,"cut":false,"hidden":false,"merged":[[1,15,1,19],[1,20,1,24]]}
["Category One - Data Transmission and/or Internet Access - Version 21.0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Identify the Monthly Costs",null,null,null,null,"Identify the One-time Costs"]
["Reference Number","Purpose","Function","Type of Connection","Enter Type of Connection, if Other was selected","Bandwidth Download Speed","Bandwidth Download Units","Bandwidth Upload Speed","Bandwidth Upload Units","Burstable bandwidth?","What is the maximum burstable speed?","What is the unit of the burstable speed?","Does this include basic firewall services?","Is this connection directly to a school, library or a NIF?","Is this a connection that supports service to a school, library or NIF?","Monthly Recurring Unit Costs","Monthly Recurring Unit Ineligible Costs","Estimated Monthly Recurring Unit Eligible Costs","Monthly Quantity","Estimated Total Monthly Eligible Recurring Costs","One-time Unit Costs","One-time Unit Ineligible Costs","Estimated One-time Unit Eligible Costs","One-time Quantity","Estimated Total Eligible One-time Costs"]
["For Reference only - Not Imported","Required","Required","Required","Required - if \"Other\" is selected as Function and Type of Connection","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","Required","For Reference only - Not Imported","Required","For Reference only - Not Imported","Required","Required","For Reference only - Not Imported","Required","For Reference only - Not Imported"]

{"sheet":"Recipients of Service","index":1,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3]]}
["Category One - Data Transmission and/or Internet Access - Version 21.0"]
["Recipients of Service"]
["Reference Number","BEN","Name","Number of Lines per BEN"]
["Required - Not Imported","Required","For Reference only - Not Imported","Required if the connection is directly to a school, library or a NIF"]

{"sheet":"List of Errors","index":2,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Category One - Data Transmission and/or Internet Access - Version 21.0"]
["Tab","Column and Row","Error"]

{"sheet":"Flag","index":3,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Validate Button Clicked on ROS tab?","Error-free for list of Errors tab?"]
[0,0]

{"sheet":"471C1LineItemsRef","index":4,"n_rows":41,"n_cols":8,"rows_kept":41,"cut":false,"hidden":true,"merged":[[1,0,18,0],[19,0,30,0],[31,0,34,0],[35,0,37,0],[38,0,40,0]]}
["Function","Type of Connection","Bandwidth Download Speed\n(If System Populated, make the field read-only)","Bandwidth Download Units\n(If System Populated, make the field read-only)","Bandwidth Upload Speed\n(If System Populated, make the field read-only)","Bandwidth Upload Units\n(If System Populated, make the field read-only)","Warning message appears when the user enters values outside this range:","Warning message (Note: User should be able to continue even if speed is out of range. This is not a validation.)"]
["Fiber (Hide if service type =voice)","DS-1",1.544,"Mbps",1.544,"Mbps","N/A"]
[null,"DS-3",44.735999999999997,"Mbps",44.735999999999997,"Mbps","N/A"]
[null,"DS-4",274.17599999999999,"Mbps",274.17599999999999,"Mbps","N/A"]
[null,"Dark Fiber (No Special Construction)","User entered","User selected from dropdown: Mbps or Gbps","Defaults to the value the user enters in Download Speed but is editable","Defaults to the value the user enters in Download Speed but is editable",100000,"\"Speed is out of range for this type of connection\""]
[null,"Dark Fiber IRU (No Special Construction)","User entered","User selected from dropdown: Mbps or Gbps","Defaults to the value the user enters in Download Speed but is editable","Defaults to the value the user enters in Download Speed but is editable",100000,"\"Speed is out of range for this type of connection\""]
[null,"OC-1",51.48,"Mbps",51.48,"Mbps","N/A"]
[null,"OC-3",155.52000000000001,"Mbps",155.52000000000001,"Mbps","N/A"]
[null,"OC-12",622.08000000000004,"Mbps",622.08000000000004,"Mbps","N/A"]
[null,"OC-24",1.244,"Gbps",1.244,"Gbps","N/A"]
[null,"OC-48",2.488,"Gbps",2.488,"Gbps","N/A"]
[null,"OC-192",9.9529999999999994,"Gbps",9.9529999999999994,"Gbps","N/A"]
[null,"OC-256",13.271000000000001,"Gbps",13.271000000000001,"Gbps","N/A"]
[null,"OC-768",39.811999999999998,"Gbps",39.811999999999998,"Gbps","N/A"]
[null,"Switched Multimegabit Data Service","User entered","User selected from dropdown: Mbps or Gbps","Defaults to the value the user enters in Download Speed but is editable","Defaults to the value the user enters in Download Speed but is editable",100000,"\"Speed is out of range for this type of connection\""]
[null,"OC-N (TDM Fiber)","User entered","User selected from dropdown: Mbps or Gbps","Defaults to the value the user enters in Download Speed but is editable","Defaults to the value the user enters in Download Speed but is editable",100000,"\"Speed is out of range for this type of connection\""]
[null,"Digital Subscriber Line (DSL)","User entered","User selected from dropdown: Mbps or Gbps","Defaults to the value the user enters in Download Speed but is editable","Defaults to the value the user enters in Download Units but is editable","N/A"]
[null,"Ethernet","User entered","User selected from dropdown: Mbps or Gbps","Defaults to the value the user enters in Download Speed but is editable","Defaults to the value the user enters in Download Units but is editable",100000,"\"Speed is out of range for this type of connection\""]
[null,"MPLS","User entered","User selected from dropdown: Mbps or Gbps","Defaults to the value the user enters in Download Speed but is editable","Defaults to the value the user enters in Download Units but is editable","N/A"]
["Copper (Hide if service type =voice)","ATM","User entered","User selected from dropdown: Mbps or Gbps","Defaults to the value the user enters in Download Speed but is editable","Defaults to the value the user enters in Download Speed but is editable","N/A"]
[null,"ISDN-BRI",0.128,"Mbps",0.128,"Mbps","N/A"]
[null,"Cable Modem","User entered","User selected from dropdown: Mbps or Gbps","Defaults to the value the user enters in Download Speed but is editable","Defaults to the value the user enters in Download Speed but is editable",300,"\"Speed is out of range for this type of connection\""]
[null,"T-1",1.544,"Mbps",1.544,"Mbps","N/A"]
[null,"T-3",44.735999999999997,"Mbps",44.735999999999997,"Mbps","N/A"]
[null,"T-4",274.17599999999999,"Mbps",274.17599999999999,"Mbps","N/A"]
[null,"T-5",400.3,"Mbps",400.3,"Mbps","N/A"]
[null,"Digital Subscriber Line (DSL)","User entered","User selected from dropdown: Mbps or Gbps","Defaults to the value the user enters in Download Speed but is editable","Defaults to the value the user enters in Download Speed but is editable",75,"\"Speed is out of range for this type of connection\""]
[null,"Ethernet","User entered","User selected from dropdown: Mbps or Gbps","Defaults to the value the user enters in Download Speed but is editable","Defaults to the value the user enters in Download Speed but is editable",100000,"\"Speed is out of range for this type of connection\""]
[null,"Fractional T-1","User entered","User selected from dropdown: Mbps or Gbps","Defaults to the value the user enters in Download Speed but is editable","Defaults to the value the user enters in Download Speed but is editable","N/A"]
[null,"Frame Relay","User entered","User selected from dropdown: Mbps or Gbps","Defaults to the value the user enters in Download Speed but is editable","Defaults to the value the user enters in Download Speed but is editable","N/A"]
[null,"Switched Multimegabit Data Service","User entered","User selected from dropdown: Mbps or Gbps",null,"Defaults to the value the user enters in Download Speed but is editable","N/A"]
["Wireless (Hide if service type =voice)","Microwave","User entered","User selected from dropdown: Mbps or Gbps","Defaults to the value the user enters in Download Speed but is editable","Defaults to the value the user enters in Download Speed but is editable",100000,"\"Speed is out of range for this type of connection\""]
[null,"Satellite Service","User entered","User selected from dropdown: Mbps or Gbps","Defaults to the value the user enters in Download Speed but is editable","Defaults to the value the user enters in Download Speed but is editable","N/A"]
[null,"Data plan for portable device","User entered","User selected from dropdown: Mbps or Gbps","Defaults to the value the user enters in Download Speed but is editable","Defaults to the value the user enters in Download Speed but is editable","N/A"]
[null,"Wireless data service","User entered","User selected from dropdown: Mbps or Gbps","Defaults to the value the user enters in Download Speed but is editable","Defaults to the value the user enters in Download Speed but is editable","N/A"]
["Other (Hide if service type =voice)","Broadband Over Power Lines","User entered","User selected from dropdown: Mbps or Gbps","Defaults to the value the user enters in Download Speed but is editable","Defaults to the value the user enters in Download Speed but is editable","N/A"]
[null,"Radio Loop","User entered","User selected from dropdown: Mbps or Gbps","Defaults to the value the user enters in Download Speed but is editable","Defaults to the value the user enters in Download Speed but is editable","N/A"]
[null,"Other","User entered","User selected from dropdown: Mbps or Gbps","Defaults to the value the user enters in Download Speed but is editable","Defaults to the value the user enters in Download Speed but is editable","N/A"]
["Miscellaneous (Shows for all service types)","Maintenance and Technical Support","N/A","N/A","N/A","N/A","N/A"]
[null,"Installation, Activation and Initial Configuration","N/A","N/A","N/A","N/A","N/A"]
[null,"Taxes and USF Fees","N/A","N/A","N/A","N/A","N/A"]

{"sheet":"LOVs","index":5,"n_rows":30,"n_cols":15,"rows_kept":30,"cut":false,"hidden":true,"merged":[[0,7,3,7]]}
["Purpose","Function","YesNo","SpeedUnit","Warning message","In this application, is this connection(s) used by ",null,"DO NOT touch column \"I\", contains the ref number list and gets regenerated/refreshed automatically",null,null,null,"Error Code","Error Message","Scenario"]
["Internet access service that includes a connection from any applicant site directly to the Internet Service Provider","Fiber","Yes","Mbps","Only choose this Purpose if you are a consortium","All buildings/sites listed",null,null,null,null,null,101,"Please enter a number greater than 0 for the number of lines allocated to this recipient","When a user enters 0 or a non-numerical value in the column \"Number of Lines per BEN\" ","ERR_INVALID_NLP"]
["Data Connection between two or more sites entirely within the applicant’s network","Copper","No","Gbps","Speed is out of range for this type of connection","One building/site listed",null,null,null,null,null,102,"[Reference Number: refNumPH] You have allocated more lines than requested for the FRN line item with this reference number. Please ensure the number of lines per BEN on the Recipients of Service tab match the number of lines requested","When the total \"Number of Lines per BEN\" associated with a Reference Number in Recipients of Service tab is MORE than the \"Monthly Quantity\" for FRN Line Item with the same Reference Number in Category 1 Internet Access tab.","ERR_MORE_NLP"]
["Data connection(s) for an applicant’s hub site to an Internet Service Provider or state/regional network where Internet access service is billed separately","Wireless",null,null,"An entry equal to or greater than 0 is required","Multiple buildings/sites listed",null,null,null,null,null,103,"[Reference Number: refNumPH] You have allocated less lines than requested for the FRN line item with this reference number. Please ensure the number of lines per BEN on the Recipients of Service tab match the number of lines requested","When the total \"Number of Lines per BEN\" associated with a Reference Number in Recipients of Service tab is LESS than the \"Monthly Quantity\" for FRN Line Item with the same Reference Number in Category 1 Internet Access tab.","ERR_LESS_NLP"]
["Internet access service with no circuit (data circuit to ISP state/regional network is billed separately)","Other",null,null,null,null,null,null,null,null,null,104,"Please enter a valid Entity number. An Entity number cannot exceed 10 digits and must be a positive round number","When a user enters a non-numerical value  or a numerical value exceeding 10 digits in the \"BEN\" column.","ERR_INVALID_BEN"]
["Backbone circuit for consortium that provides connectivity between aggregation points or other non-user facilities","Miscellaneous",null,null,null,null,null,null,null,null,null,105,"[BEN: benNumPH, Reference Number: refNumPH] This BEN is listed more than once on the Recipients of Service tab for the FRN line item with this reference number. Please remove duplicate recipients in the Recipients of Service tab for this FRN line item","When a combination of BEN and Reference Number in the Recipients of Service tab is not unique.","ERR_DUPE_BEN_COMBO_ON_ROS"]
[null,null,null,null,null,null,null,null,null,null,null,106,"[Reference Number: refNumPH] The FRN line item with this reference number does not have any associated recipients of service. Please ensure all your recipients are listed for this FRN line item in the Recipients of Service tab","When no BEN is listed as a Recipient of Service for a FRN Line Item in the Category 1 Voice tab.","ERR_REF_NUM_ON_C1_CANNOT_BE_FOUND_IN_ROS"]
[null,null,null,null,null,null,null,null,null,null,null,107,"[Reference Number: refNumPH] This reference number in the Recipients of Service tab does not correspond to an FRN line item of the same reference number. Please add the FRN line item prior to adding the recipients in the Recipients of Service tab","When the reference number in the Recipients of Service tab does not match the reference number in the FRN Line Items tab ","ERR_REF_NUM_ON_ROS_CANNOT_BE_FOUND_IN_C1"]
[null,null,null,null,null,null,null,null,null,null,null,108,"The validation is now complete. Please check the List of Errors tab to review the list of errors that were encountered in the spreadsheet","Pop-up message displayed every time the Validation button is clicked ","MSG_VALIDATION_COMPLETE"]
[null,null,null,null,null,null,null,null,null,null,null,109,"You have not specified a reference number for this row.  Please select a reference number","When reference number on the recipient of service tab is blank, but there is other related information. ","ERR_EMPTY_REF_NUM"]
[null,null,null,null,null,null,null,null,null,null,"need approve",110,"*** [Reference Number: refNumPH] FRN line item is not a connection directly to a school, library or a NIF. Not allowed to enter a value for \"Number of Lines per BEN\"","13f) check if FRN is \"connection directly to a school, library or a NIF\" = 'NO', then not allowed to enter a value","ERR_NLP_NOT_ALLOWED"]
[null,null,null,null,null,null,null,null,null,null,"need approve",111,"*** [Reference Number: refNumPH] This reference number is listed more than once on the Category 1 Internet Access. Please remove duplicate reference numbers so that each FRN line item has a unique reference number",null,"ERR_DUPE_REF_NUM_IN_C1"]
[null,null,null,null,null,null,null,null,null,null,"need approve",112,"*** Invalid Reference Number entered. Please choose from the drop down or enter a valid whole number",null,"ERR_INVALID_REF_NUM_ON_ROS"]
[null,null,null,null,null,null,null,null,null,null,"need approve",113,"*** columns N and O, both cannot be Yes",null,"ERR_N_O_BOTH_CANNOT_BE_YES"]
[null,null,null,null,null,null,null,null,null,null,"need approve",114,"*** Emtpy input, input required",null,"ERR_EMPTY_INPUT"]
[null,null,null,null,null,null,null,null,null,null,"need approve",115,"*** Invalid input entered, Fix it",null,"ERR_INVALID_INPUT"]
[null,null,null,null,null,null,null,null,null,null,null,116]
[null,null,null,null,null,null,null,null,null,null,null,117]
[null,null,null,null,null,null,null,null,null,null,null,118]
[null,null,null,null,null,null,null,null,null,null,null,119]
[null,null,null,null,null,null,null,null,null,null,null,120]
[null,null,null,null,null,null,null,null,null,null,null,121]
[null,null,null,null,null,null,null,null,null,null,null,122]
[null,null,null,null,null,null,null,null,null,null,null,123]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,111,222,333]

{"sheet":"Performance","index":6,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Performance "]
["C1 "]
["#TotalRows",1]
["Start Time",44116.937094907407]
["End Time",44116.937094907407]
["Total Time (sec)",0.01]
[]
["C2"]
["#TotalRows",1]
["Start Time",44116.937094907407]
["End Time",44116.937094907407]
["Total Time (sec)",0.01]