{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Cover","Home","Company Info","Main menu","Form U1","Form U2","Form U3","Form U4","Form F-1a","Form F-1b","Form F-2a","Form F-2b","Form F-3a","Form F-3b","Rural Certification","Instructions"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":28,"comments":2,"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":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[[18,0,19,14],[21,0,25,14],[8,0,13,14],[15,0,17,14]]}
[" ",null,null,null,null,null,null,null,null,"OMB Approved No. ",null,"3060-0895"]
[null,null,null,null,null,null,null,null,null,{"$f":"'Main menu'!A3","v":"Est. Burden Per Response: 44.4 hrs"}]
[null,null,null,null,null,null,null,null,null,"Edition Date: June 2016"]
[]
["FCC Form 502"]
["North American Numbering Plan Numbering Resource Utilization/Forecast (NRUF) Report"]
[]
[]
["Notice:  The ten digit North American Numbering Plan currently being used by the United States and 19 other countries is being depleted.  Management of this resource requires uniform reporting of utilization and forecast data.  Under the Communications Act Of 1934 as amended by The Telecommunications Act of 1996 the FCC was given “exclusive jurisdiction over those portions of the North American Numbering Plan that pertain to the United States.”  Pursuant to that authority the Commission conducted a rulemaking that among other things addressed regular reporting on numbering use by United States carriers.  In its Report and Order in CC Docket No. 99-200, In the Matter of Numbering Resource Optimization (rel. Mar. 31, 2000) the Commission found that mandatory data collection is necessary to efficiently monitor and manage numbering use.  Your response is mandatory."]
[]
[]
[]
[]
[]
[]
["The information will be used by the FCC, state regulatory commissions, and the North American Numbering Plan Administrator (NANPA) to monitor numbering resources utilization by all carriers using the resource and to project the dates of area code and North American Numbering Plan exhaust."]
[]
[]
["An agency may not conduct or sponsor and a person is not required to respond to a collection of information unless it displays a currently valid control number.  The control number assigned to this collection is 3060-0895."]
[]
[]
["Public reporting burden for this collection of information is estimated to average 44.4 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.  Send comments regarding this burden estimate or any other aspect of this collection of information via email to PRA@fcc.gov, including suggestions for reducing the burden to the Federal Communications Commission, Performance Evaluation and Records Management, Washington, D.C.  20554 (3060-0895).  Do not send data responses to this address.  "]

{"sheet":"Home","index":1,"n_rows":23,"n_cols":45,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,0,27,13],[4,0,5,13],[0,37,0,38],[2,1,2,10],[7,0,8,13],[0,4,0,10],[0,14,0,18],[3,14,4,18],[1,14,2,18]]}
[" ",null," ",null,"GENERAL INSTRUCTIONS",null,null,null,null,null,null,null,null,null,{"$f":"'Main menu'!A2","v":"OMB Approved No: 3060-0895"},null,null,null,null,null,null,null,null,null,null,null,null,null,"NPA-NXX","X",0,0,0,0,0,{"$f":"IF(1000-(AE1+AF1+AG1+AH1+AI1)>-1, 1000-(AE1+AF1+AG1+AH1+AI1),\"Error\")","v":1000}," ","Utilization   =",null,{"$f":"IF(AF1=1000,\"Intermed\",(IF((AK1=\"X\")*AND(AJ1>899),\"Donated\",(AE1/(1000-AF1)))))","v":0},{"$f":"(IF((AK1=\"X\")*AND(AJ1<900),\"Error, Exceeds 10% Contamination \",(IF(AF1>0,\"Insert Intermediate Assignee Name Here\",IF((AK1)=\"X\",\"Donated to Pool\",\"  \")))))","v":"  "},null,null,null," "]
[null,null,null," "," "," ",null,null,null,null,null,null,null,null,{"$f":"'Main menu'!A3","v":"Est. Burden Per Response: 44.4 hrs"}]
[null,"Users that are familiar with these forms may proceed directly to the \"Main Menu\""]
[null,null,null,null,null," ",null,null,null,null,null,null,null,null,{"$f":"'Main menu'!A4","v":"Edition Date: June 2016"}]
["This report contains twelve forms for collecting utilization and forecast data from carriers.  "]
[]
[]
["All carriers should file at least three forms:  (1) one company information form; (2) one utilization data form; and (3) one forecast data form.  Many carriers will need to file more than one utilization or forecast form.  For example, carriers that receive numbers from both the Numbering Administrator and another carrier must file separate Primary and Intermediate carrier forms."]
[]
[]
["Which forms should be filed is determined by whether the carrier is:"]
[]
["1) a Primary or Intermediate Carrier;"]
[]
["2) a Rural or Non-Rural Carrier;"]
[]
["3) a Pooling or Non-Pooling Carrier;"]
[]
["4) in a Pooling or Non-Pooling Area;"]
[]
["5) reporting Initial or Growth Codes."]
[]
["To proceed, click on the \"Company Information\" button below and fill in the requested information.  Instructions for filling in company information are on the form.  Once this information is filled in, it is automatically transferred to any other form selected by the user.  After this form is complete, click on the \"Main Menu\" button which appears at the end of the \"Company Information\" form to proceed with the remaining forms.        "]

{"sheet":"Company Info","index":2,"n_rows":26,"n_cols":44,"rows_kept":26,"cut":false,"hidden":false,"merged":[[19,0,20,14],[25,0,26,14],[0,0,0,14],[5,0,5,14],[18,0,18,1],[18,2,18,5],[12,8,16,13]]}
["  COMPANY INFORMATION"]
[null,null,null,null,null,null,null,{"$f":"'Main menu'!A1&\", \"&'Main menu'!A2&\", \"&'Main menu'!A3&\", \"&'Main menu'!A4","v":"FCC Form 502 , OMB Approved No: 3060-0895, Est. Burden Per Response: 44.4 hrs, Edition Date: June 2016"}]
[]
["Please enter your company information below. "]
[]
["Parent OCN refers to the OCN of the reporting carrier's parent company located within the applicable state.  If the reporting carrier has more than one parent company in a particular state (e.g., if the  reporting carrier is a subsidiary of company A, which in turn is a subsidiary of company B, so that both companies A and B could be deemed the reporting carrier's \"parent\"), the reporting carrier should report the OCN of the highest parent company (in this example, the appropriate parent would be Company B)."]
[]
["Parent Company Name",null,null,"<Parent Company Name>",null,null,null,null,null,"Parent Company OCN ","<PC OCN>",null,null,null,null,null,null,null,null,null,null,13,1,"CAP or CLEC"]
["Service Provider Name",null,null,"<Service Provider Name>",null,null,null,null,null,"Service Provider OCN ","<SP OCN>",null,null,null,null,null,null,null,null,null,null,null,2,"Incumbent Local Exchange Carrier (ILEC)"]
["Company Address",null,null,"<Company Address>",null,null,null,null,null,"Service Provider FRN ","<SP FRN>",null,null,null,null,null,null,null,null,null,null,null,3,"Interconnected VoIP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["Address 2",null,null,"<Address 2>",null,null,null,null,null,"SP Service Type ",{"$f":"VLOOKUP(V8,W8:X20,2)","v":"<SP Service Type>"},null,null,null,null,null,null,null,null,null,null,null,4,"Interexchange Carrier (IXC)"]
["City",null,null,"<City>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Other Local (Shared-Tenant, Private Carriers)"]
["State",null,null,"<State>",null,null,null,null,"All Changes to Parent Company Name, Service Provider Name, Address, Contact Information, OCN(s), FRN and Service Type must be made on this page.",null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Local Reseller"]
["Zip",null,null,"<Zip>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Other Mobile Service Provider"]
["Contact Name",null,null,"<Contact Name>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Paging and Messaging"]
["Contact Tel #",null,null,"<Contact Tel#>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Satellite Service Providers"]
["Fax #:",null,null,"<Fax #>",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"SMR Dispatch "]
["E-mail",null,null,"<E-mail>",null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Wireless Data Service Provider "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"Wireless Telephony (Cellular, PCS, SMR)"]
["If you are a Rural Telephone Company as defined in the Communications Act, 47 U.S.C. § 153(37), click on the \"Rural Certification Form\" button below.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"<SP Service Type>"]
[]
[]
[]
[]
[]
["To proceed, click on the \"Main Menu\" button below which will take you to detailed instructions, the utilization forms and the forecast forms.  Press \"Gen Instructions\" to return to the previous page."]

{"sheet":"Main menu","index":3,"n_rows":10,"n_cols":44,"rows_kept":10,"cut":false,"hidden":false,"merged":[[8,1,8,3],[7,36,7,37],[2,36,2,37],[6,36,6,37],[8,5,8,11],[8,36,8,37]]}
["FCC Form 502 "]
["OMB Approved No: 3060-0895"]
["Est. Burden Per Response: 44.4 hrs",null,null,null,null,null,"MAIN MENU",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NPA-NXX","X",0,0,0,0,0,{"$f":"IF(1000-(AD3+AE3+AF3+AG3+AH3)>-1, 1000-(AD3+AE3+AF3+AG3+AH3),\"Error\")","v":1000}," ","Utilization   =",null,{"$f":"IF(AE3=1000,\"Intermed\",(IF((AJ3=\"X\")*AND(AI3>899),\"Donated\",(AD3/(1000-AE3)))))","v":0},{"$f":"(IF((AJ3=\"X\")*AND(AI3<900),\"Error, Exceeds 10% Contamination \",(IF(AE3>0,\"Insert Intermediate Assignee Name Here\",IF((AJ3)=\"X\",\"Donated to Pool\",\"  \")))))","v":"  "},null,null,null," "]
["Edition Date: June 2016",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,true,null,null,null,null,null,null,null," ",null,null,null,null," ",null," "]
[null,null,null,null,null,null,">>>Please Read Detailed Instructions Before Completing Forms<<<",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NPA-NXX",0,0,0,0,0,0,{"$f":"IF(1000-(AD7+AE7+AF7+AG7+AH7)>-1, 1000-(AD7+AE7+AF7+AG7+AH7),\"Error\")","v":1000}," ","Utilization   =",null,{"$f":"IF(AE7=1000,\"Intermed\",(IF((AJ7=\"X\")*AND(AI7>899),\"Donated\",(AD7/(1000-AE7)))))","v":0},{"$f":"(IF((AJ7=\"X\")*AND(AI7<900),\"Error, Exceeds 10% Contamination \",(IF(AE7>0,\"Insert Intermediate Assignee Name Here\",IF((AJ7)=\"X\",\"Donated to Pool\",\"  \")))))","v":"  "}]
[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":"#REF!","v":{"$error":"#REF!"}},4,0,0,0,0,0,{"$f":"IF(1000-(AD8+AE8+AF8+AG8+AH8)>-1, 1000-(AD8+AE8+AF8+AG8+AH8),\"Error\")","v":1000}," ","Utilization   =",null,{"$f":"IF(AE8=1000,\"Intermed\",(IF((AJ8=\"X\")*AND(AI8>899),\"Donated\",(AD8/(1000-AE8)))))","v":0},{"$f":"(IF((AJ8=\"X\")*AND(AI8<900),\"Error, Exceeds 10% Contamination \",(IF(AE8>0,\"Insert Intermediate Assignee Name Here\",IF((AJ8)=\"X\",\"Donated to Pool\",\"  \")))))","v":"  "}]
[null,"Utilization Forms",null,null,null,"Forecast Forms",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":" AB8","v":{"$error":"#REF!"}},5,0,0,0,0,0,{"$f":"IF(1000-(AD9+AE9+AF9+AG9+AH9)>-1, 1000-(AD9+AE9+AF9+AG9+AH9),\"Error\")","v":1000}," ","Utilization   =",null,{"$f":"IF(AE9=1000,\"Intermed\",(IF((AJ9=\"X\")*AND(AI9>899),\"Donated\",(AD9/(1000-AE9)))))","v":0},{"$f":"(IF((AJ9=\"X\")*AND(AI9<900),\"Error, Exceeds 10% Contamination \",(IF(AE9>0,\"Insert Intermediate Assignee Name Here\",IF((AJ9)=\"X\",\"Donated to Pool\",\"  \")))))","v":"  "}]
[null,null,null,null,null,null,"Initial",null,null,null,"Growth",null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,"Lookup",0]

{"sheet":"Form U1","index":4,"n_rows":21,"n_cols":179,"rows_kept":21,"cut":false,"hidden":false,"merged":[[11,8,15,12]]}
[null,null,null,null,null,null,null,null,"Form U1 - UTILIZATION REPORTING FORM (FOR NON-RURAL PRIMARY CARRIERS)",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,"Bad Parent Company, Bad Service Provider Name, Bad Company Address, Bad Parent Company, Bad Service Provider Name, Bad Company Address, Bad Parent Company, Bad Service Provider Name, Bad Company Address"]
[null,null,null,null,null,null,null,null,">>> Please See The Instructions Before Completing This Form <<<"]
[null,null,null,"Check this box if the data on this form replaces the data on a previously submitted form."]
[]
[]
[]
["Parent Company Name",null,null,{"$f":"IF('Company Info'!D8=\"\",\"\",'Company Info'!D8)","v":"<Parent Company Name>"},null,null,null,null,"Parent Company OCN ",null,{"$f":"IF('Company Info'!K8=\"\",\"\",'Company Info'!K8)","v":"<PC OCN>"}]
["Service Provider Name",null,null,{"$f":"IF('Company Info'!D9=\"\",\"\",'Company Info'!D9)","v":"<Service Provider Name>"},null,null,null,null,"Service Provider OCN ",null,{"$f":"IF('Company Info'!K9=\"\",\"\",'Company Info'!K9)","v":"<SP OCN>"}]
["Company Address",null,null,{"$f":"IF('Company Info'!D10=\"\",\"\",'Company Info'!D10)","v":"<Company Address>"},null,null,null,null,"Service Provider FRN ",null,{"$f":"IF('Company Info'!K10=\"\",\"\",'Company Info'!K10)","v":"<SP FRN>"}]
["Address 2",null,null,{"$f":"IF('Company Info'!D11=\"\",\"\",'Company Info'!D11)","v":"<Address 2>"},null,null,null,null,"SP Service Type ",null,{"$f":"IF('Company Info'!K11=\"\",\"\",'Company Info'!K11)","v":"<SP Service Type>"}]
["City",null,null,{"$f":"IF('Company Info'!D12=\"\",\"\",'Company Info'!D12)","v":"<City>"}]
["State",null,null,{"$f":"IF('Company Info'!D13=\"\",\"\",'Company Info'!D13)","v":"<State>"},null,null,null,null,"All Changes to Parent Company Name, Service Provider Name, Address, Contact Information, OCN(s), FRN and Service Type must be made on the Company Info page."]
["Zip",null,null,{"$f":"IF('Company Info'!D14=\"\",\"\",'Company Info'!D14)","v":"<Zip>"}]
["Contact Name",null,null,{"$f":"IF('Company Info'!D15=\"\",\"\",'Company Info'!D15)","v":"<Contact Name>"}]
["Contact Tel #",null,null,{"$f":"IF('Company Info'!D16=\"\",\"\",'Company Info'!D16)","v":"<Contact Tel#>"}]
["Fax #:",null,null,{"$f":"IF('Company Info'!D17=\"\",\"\",'Company Info'!D17)","v":"<Fax #>"}]
["E-mail",null,null,{"$f":"IF('Company Info'!D18=\"\",\"\",'Company Info'!D18)","v":"<E-mail>"}]
[]
[null,null,null,null,null,null,null,null,"Numbering Resource Utilization For Each 1K Block"]
["NPA-NXX","X","Rate Center Abbreviation","Assigned","Inter-mediate","Reserved","Aging","Admin","Donated to Pool?"," Notes/ Assignee","Available","Utilization","Errors/Messages",null,null,null," "]
["NPA-NXX","X","<Rate Center Abbr>",0,0,0,0,0,null,null,{"$f":"IF(D21+E21+F21+G21+H21>1000,\"Error\",1000-(D21+E21+F21+G21+H21))","v":1000},{"$f":"IF(E21=1000,\"Intermed\",(IF(AND(I21=\"X\",K21>899),\"Donated\",(D21/(1000-E21)))))","v":0}]

{"sheet":"Form U2","index":5,"n_rows":21,"n_cols":17,"rows_kept":21,"cut":false,"hidden":false,"merged":[[11,8,15,12]]}
[null,null,null,null,null,null,null,null,"Form U2 - UTILIZATION REPORTING FORM (FOR RURAL PRIMARY CARRIERS)"]
[null,null,null,null,null,null,null,null,">>> Please See The Instructions Before Completing This Form <<<"]
[null,null,null,"Check this box if the data on this form replaces the data on a previously submitted form."]
[]
[]
[]
["Parent Company Name",null,null,{"$f":"IF('Company Info'!D8=\"\",\"\",'Company Info'!D8)","v":"<Parent Company Name>"},null,null,null,null,"Parent Company OCN ",null,{"$f":"IF('Company Info'!K8=\"\",\"\",'Company Info'!K8)","v":"<PC OCN>"}]
["Service Provider Name",null,null,{"$f":"IF('Company Info'!D9=\"\",\"\",'Company Info'!D9)","v":"<Service Provider Name>"},null,null,null,null,"Service Provider OCN ",null,{"$f":"IF('Company Info'!K9=\"\",\"\",'Company Info'!K9)","v":"<SP OCN>"}]
["Company Address",null,null,{"$f":"IF('Company Info'!D10=\"\",\"\",'Company Info'!D10)","v":"<Company Address>"},null,null,null,null,"Service Provider FRN ",null,{"$f":"IF('Company Info'!K10=\"\",\"\",'Company Info'!K10)","v":"<SP FRN>"}]
["Address 2",null,null,{"$f":"IF('Company Info'!D11=\"\",\"\",'Company Info'!D11)","v":"<Address 2>"},null,null,null,null,"SP Service Type ",null,{"$f":"IF('Company Info'!K11=\"\",\"\",'Company Info'!K11)","v":"<SP Service Type>"}]
["City",null,null,{"$f":"IF('Company Info'!D12=\"\",\"\",'Company Info'!D12)","v":"<City>"}]
["State",null,null,{"$f":"IF('Company Info'!D13=\"\",\"\",'Company Info'!D13)","v":"<State>"},null,null,null,null,"All Changes to Parent Company Name, Service Provider Name, Address, Contact Information, OCN(s), FRN and Service Type must be made on the Company Info page."]
["Zip",null,null,{"$f":"IF('Company Info'!D14=\"\",\"\",'Company Info'!D14)","v":"<Zip>"}]
["Contact Name",null,null,{"$f":"IF('Company Info'!D15=\"\",\"\",'Company Info'!D15)","v":"<Contact Name>"}]
["Contact Tel #",null,null,{"$f":"IF('Company Info'!D16=\"\",\"\",'Company Info'!D16)","v":"<Contact Tel#>"}]
["Fax #:",null,null,{"$f":"IF('Company Info'!D17=\"\",\"\",'Company Info'!D17)","v":"<Fax #>"}]
["E-mail",null,null,{"$f":"IF('Company Info'!D18=\"\",\"\",'Company Info'!D18)","v":"<E-mail>"}]
[]
[null,null,null,null,null,null,null,null,"Numbering Resource Utilization For Each NXX"]
["NPA-NXX","Rate Center Abbreviation","State Abbr.","Assigned","Inter-mediate","Reserved","Aging","Admin",null," Notes/ Assignee","Available","Utilization","Errors/Messages",null,null,null," "]
["NPA-NXX","<Rate Center Abbr>","<St>",0,0,0,0,0,null,null,{"$f":"IF(D21+E21+F21+G21+H21>10000,\"Error\",10000-(D21+E21+F21+G21+H21))","v":10000},{"$f":"IF(E21=10000,\"Intermed\",(IF(AND(I21=\"X\",K21>8999),\"Donated\",(D21/(10000-E21)))))","v":0}]

{"sheet":"Form U3","index":6,"n_rows":21,"n_cols":17,"rows_kept":21,"cut":false,"hidden":false,"merged":[[11,8,15,12]]}
[null,null,null,null,null,null,null,null,"Form U3 - UTILIZATION REPORTING FORM (FOR NON-RURAL INTERMEDIATE CARRIERS)"]
[null,null,null,null,null,null,null,null,">>> Please See The Instructions Before Completing This Form <<<"]
[null,null,null,"Check this box if the data on this form replaces the data on a previously submitted form."]
[]
[]
[]
["Parent Company Name",null,null,{"$f":"IF('Company Info'!D8=\"\",\"\",'Company Info'!D8)","v":"<Parent Company Name>"},null,null,null,null,"Parent Company OCN ",null,{"$f":"IF('Company Info'!K8=\"\",\"\",'Company Info'!K8)","v":"<PC OCN>"}]
["Service Provider Name",null,null,{"$f":"IF('Company Info'!D9=\"\",\"\",'Company Info'!D9)","v":"<Service Provider Name>"},null,null,null,null,"Service Provider OCN ",null,{"$f":"IF('Company Info'!K9=\"\",\"\",'Company Info'!K9)","v":"<SP OCN>"}]
["Company Address",null,null,{"$f":"IF('Company Info'!D10=\"\",\"\",'Company Info'!D10)","v":"<Company Address>"},null,null,null,null,"Service Provider FRN ",null,{"$f":"IF('Company Info'!K10=\"\",\"\",'Company Info'!K10)","v":"<SP FRN>"}]
["Address 2",null,null,{"$f":"IF('Company Info'!D11=\"\",\"\",'Company Info'!D11)","v":"<Address 2>"},null,null,null,null,"SP Service Type ",null,{"$f":"IF('Company Info'!K11=\"\",\"\",'Company Info'!K11)","v":"<SP Service Type>"}]
["City",null,null,{"$f":"IF('Company Info'!D12=\"\",\"\",'Company Info'!D12)","v":"<City>"}]
["State",null,null,{"$f":"IF('Company Info'!D13=\"\",\"\",'Company Info'!D13)","v":"<State>"},null,null,null,null,"All Changes to Parent Company Name, Service Provider Name, Address, Contact Information, OCN(s), FRN and Service Type must be made on the Company Info page."]
["Zip",null,null,{"$f":"IF('Company Info'!D14=\"\",\"\",'Company Info'!D14)","v":"<Zip>"}]
["Contact Name",null,null,{"$f":"IF('Company Info'!D15=\"\",\"\",'Company Info'!D15)","v":"<Contact Name>"}]
["Contact Tel #",null,null,{"$f":"IF('Company Info'!D16=\"\",\"\",'Company Info'!D16)","v":"<Contact Tel#>"}]
["Fax #:",null,null,{"$f":"IF('Company Info'!D17=\"\",\"\",'Company Info'!D17)","v":"<Fax #>"}]
["E-mail",null,null,{"$f":"IF('Company Info'!D18=\"\",\"\",'Company Info'!D18)","v":"<E-mail>"}]
[]
[null,null,null,null,null,null,null,null,"Numbering Resource Utilization For Each 1K Block"]
["NPA-NXX","X","Rate Center Abbreviation","Assigned","Inter-mediate","Reserved","Aging","Admin","Numbers Received"," Notes/ Assignee","Available","Utilization","Errors/Messages",null,null,null," "]
["NPA-NXX","X","<Rate Center Abbr>",0,0,0,0,0,0,null,{"$f":"IF(D21+E21+F21+G21+H21>I21,\"Error\", I21-(D21+E21+F21+G21+H21))","v":0},{"$f":"IF(I21=0,0,IF(I21=E21,0,(D21/(I21-E21))))","v":0}]

{"sheet":"Form U4","index":7,"n_rows":21,"n_cols":17,"rows_kept":21,"cut":false,"hidden":false,"merged":[[11,8,15,12]]}
[null,null,null,null,null,null,null,null,"Form U4 - UTILIZATION REPORTING FORM (FOR RURAL INTERMEDIATE CARRIERS)"]
[null,null,null,null,null,null,null,null,">>> Please See The Instructions Before Completing This Form <<<"]
[null,null,null,"Check this box if the data on this form replaces the data on a previously submitted form."]
[]
[]
[]
["Parent Company Name",null,null,{"$f":"IF('Company Info'!D8=\"\",\"\",'Company Info'!D8)","v":"<Parent Company Name>"},null,null,null,null,"Parent Company OCN ",null,{"$f":"IF('Company Info'!K8=\"\",\"\",'Company Info'!K8)","v":"<PC OCN>"}]
["Service Provider Name",null,null,{"$f":"IF('Company Info'!D9=\"\",\"\",'Company Info'!D9)","v":"<Service Provider Name>"},null,null,null,null,"Service Provider OCN ",null,{"$f":"IF('Company Info'!K9=\"\",\"\",'Company Info'!K9)","v":"<SP OCN>"}]
["Company Address",null,null,{"$f":"IF('Company Info'!D10=\"\",\"\",'Company Info'!D10)","v":"<Company Address>"},null,null,null,null,"Service Provider FRN ",null,{"$f":"IF('Company Info'!K10=\"\",\"\",'Company Info'!K10)","v":"<SP FRN>"}]
["Address 2",null,null,{"$f":"IF('Company Info'!D11=\"\",\"\",'Company Info'!D11)","v":"<Address 2>"},null,null,null,null,"SP Service Type ",null,{"$f":"IF('Company Info'!K11=\"\",\"\",'Company Info'!K11)","v":"<SP Service Type>"}]
["City",null,null,{"$f":"IF('Company Info'!D12=\"\",\"\",'Company Info'!D12)","v":"<City>"}]
["State",null,null,{"$f":"IF('Company Info'!D13=\"\",\"\",'Company Info'!D13)","v":"<State>"},null,null,null,null,"All Changes to Parent Company Name, Service Provider Name, Address, Contact Information, OCN(s), FRN and Service Type must be made on the Company Info page."]
["Zip",null,null,{"$f":"IF('Company Info'!D14=\"\",\"\",'Company Info'!D14)","v":"<Zip>"}]
["Contact Name",null,null,{"$f":"IF('Company Info'!D15=\"\",\"\",'Company Info'!D15)","v":"<Contact Name>"}]
["Contact Tel #",null,null,{"$f":"IF('Company Info'!D16=\"\",\"\",'Company Info'!D16)","v":"<Contact Tel#>"}]
["Fax #:",null,null,{"$f":"IF('Company Info'!D17=\"\",\"\",'Company Info'!D17)","v":"<Fax #>"}]
["E-mail",null,null,{"$f":"IF('Company Info'!D18=\"\",\"\",'Company Info'!D18)","v":"<E-mail>"}]
[]
[null,null,null,null,null,null,null,null,"Numbering Resource Utilization For Each NXX"]
["NPA-NXX","Rate Center Abbreviation","State Abbr.","Assigned","Inter-mediate","Reserved","Aging","Admin","Numbers Received"," Notes/ Assignee","Available","Utilization","Errors/Messages",null,null,null," "]
["NPA-NXX","<Rate Center Abbr>","<St>",0,0,0,0,0,0,null,{"$f":"IF(D21+E21+F21+G21+H21>I21,\"Error\", I21-(D21+E21+F21+G21+H21))","v":0},{"$f":"IF(I21=0,0,IF(I21=E21,0,(D21/(I21-E21))))","v":0}]

{"sheet":"Form F-1a","index":8,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[[12,6,16,9]]}
[null,null,null,null,null,"Form F-1a -   FORECAST REPORTING FORM (FOR POOLING CARRIERS)"]
[null,null,null,null,null,"(INITIAL THOUSAND BLOCKS)"]
[null,null,null,null,null,">>> Please See The Instructions Before Completing This Form <<<"]
[null,"Check this box if the data on this form replaces the data on a previously submitted form."]
[]
[]
[]
["Parent Company Name",null,{"$f":"IF('Company Info'!D8=\"\",\"\",'Company Info'!D8)","v":"<Parent Company Name>"},null,null,null,"Parent Company OCN ",null,null,{"$f":"IF('Company Info'!K8=\"\",\"\",'Company Info'!K8)","v":"<PC OCN>"}]
["Service Provider Name",null,{"$f":"IF('Company Info'!D9=\"\",\"\",'Company Info'!D9)","v":"<Service Provider Name>"},null,null,null,"Service Provider OCN ",null,null,{"$f":"IF('Company Info'!K9=\"\",\"\",'Company Info'!K9)","v":"<SP OCN>"}]
["Company Address",null,{"$f":"IF('Company Info'!D10=\"\",\"\",'Company Info'!D10)","v":"<Company Address>"},null,null,null,"Service Provider FRN ",null,null,{"$f":"IF('Company Info'!K10=\"\",\"\",'Company Info'!K10)","v":"<SP FRN>"}]
["Address 2",null,{"$f":"IF('Company Info'!D11=\"\",\"\",'Company Info'!D11)","v":"<Address 2>"},null,null,null,"SP Service Type ",null,null,{"$f":"IF('Company Info'!K11=\"\",\"\",'Company Info'!K11)","v":"<SP Service Type>"}]
["City",null,{"$f":"IF('Company Info'!D12=\"\",\"\",'Company Info'!D12)","v":"<City>"}]
["State",null,{"$f":"IF('Company Info'!D13=\"\",\"\",'Company Info'!D13)","v":"<State>"},null,null,null,"All Changes to Parent Company Name, Service Provider Name, Address, Contact Information, OCN(s), FRN and Service Type must be made on the Company Info page."]
["Zip",null,{"$f":"IF('Company Info'!D14=\"\",\"\",'Company Info'!D14)","v":"<Zip>"}]
["Contact Name",null,{"$f":"IF('Company Info'!D15=\"\",\"\",'Company Info'!D15)","v":"<Contact Name>"}]
["Contact Tel #",null,{"$f":"IF('Company Info'!D16=\"\",\"\",'Company Info'!D16)","v":"<Contact Tel#>"}]
["Fax #:",null,{"$f":"IF('Company Info'!D17=\"\",\"\",'Company Info'!D17)","v":"<Fax #>"}]
["E-mail",null,{"$f":"IF('Company Info'!D18=\"\",\"\",'Company Info'!D18)","v":"<E-mail>"}]
[]
[null,null,null,null,null,"Pooling Area Forecast In 1K Blocks Per Rate Center, Per Year (Initial 1K Blocks)"]
["NPA","Rate Center Abbreviation","State Abbr.","Year 1","Year 2","Year 3","Year 4","Year 5","Total 1K Blocks","Errors/Messages",null," "]
["<NPA>","<Rate Center Abbr>","<St>",0,0,0,0,0,{"$f":"IF(SUM(D22:H22)>1,\"Error\",SUM(D22:H22))","v":0}]

{"sheet":"Form F-1b","index":9,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[[12,6,16,9]]}
[null,null,null,null,null,"Form F-1b -   FORECAST REPORTING FORM (FOR POOLING CARRIERS)"]
[null,null,null,null,null,"(GROWTH THOUSAND BLOCKS)"]
[null,null,null,null,null,">>> Please See The Instructions Before Completing This Form <<<"]
[null,"Check this box if the data on this form replaces the data on a previously submitted form."]
[]
[]
[]
["Parent Company Name",null,{"$f":"IF('Company Info'!D8=\"\",\"\",'Company Info'!D8)","v":"<Parent Company Name>"},null,null,null,"Parent Company OCN ",null,null,{"$f":"IF('Company Info'!K8=\"\",\"\",'Company Info'!K8)","v":"<PC OCN>"}]
["Service Provider Name",null,{"$f":"IF('Company Info'!D9=\"\",\"\",'Company Info'!D9)","v":"<Service Provider Name>"},null,null,null,"Service Provider OCN ",null,null,{"$f":"IF('Company Info'!K9=\"\",\"\",'Company Info'!K9)","v":"<SP OCN>"}]
["Company Address",null,{"$f":"IF('Company Info'!D10=\"\",\"\",'Company Info'!D10)","v":"<Company Address>"},null,null,null,"Service Provider FRN ",null,null,{"$f":"IF('Company Info'!K10=\"\",\"\",'Company Info'!K10)","v":"<SP FRN>"}]
["Address 2",null,{"$f":"IF('Company Info'!D11=\"\",\"\",'Company Info'!D11)","v":"<Address 2>"},null,null,null,"SP Service Type ",null,null,{"$f":"IF('Company Info'!K11=\"\",\"\",'Company Info'!K11)","v":"<SP Service Type>"}]
["City",null,{"$f":"IF('Company Info'!D12=\"\",\"\",'Company Info'!D12)","v":"<City>"}]
["State",null,{"$f":"IF('Company Info'!D13=\"\",\"\",'Company Info'!D13)","v":"<State>"},null,null,null,"All Changes to Parent Company Name, Service Provider Name, Address, Contact Information, OCN(s), FRN and Service Type must be made on the Company Info page."]
["Zip",null,{"$f":"IF('Company Info'!D14=\"\",\"\",'Company Info'!D14)","v":"<Zip>"}]
["Contact Name",null,{"$f":"IF('Company Info'!D15=\"\",\"\",'Company Info'!D15)","v":"<Contact Name>"}]
["Contact Tel #",null,{"$f":"IF('Company Info'!D16=\"\",\"\",'Company Info'!D16)","v":"<Contact Tel#>"}]
["Fax #:",null,{"$f":"IF('Company Info'!D17=\"\",\"\",'Company Info'!D17)","v":"<Fax #>"}]
["E-mail",null,{"$f":"IF('Company Info'!D18=\"\",\"\",'Company Info'!D18)","v":"<E-mail>"}]
[]
[null,null,null,null,null,"Pooling Area Forecast In 1K Blocks Per Rate Center, Per Year (Growth 1K Blocks)"]
["NPA","Rate Center Abbreviation","State Abbr.","Year 1","Year 2","Year 3","Year 4","Year 5","Total 1K Blocks","Errors/Messages",null," "]
["<NPA>","<Rate Center Abbr>","<St>",0,0,0,0,0,{"$f":"IF(SUM(D22:H22)>600,\"Error\",SUM(D22:H22))","v":0}]

{"sheet":"Form F-2a","index":10,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[[12,6,16,9]]}
[null,null,null,null,null,"Form F-2a -   FORECAST REPORTING FORM (FOR NON-POOLING CARRIERS IN POOLING AREAS)"]
[null,null,null,null,null,"(INITIAL CODES)"]
[null,null,null,null,null,">>> Please See The Instructions Before Completing This Form <<<"]
[null,"Check this box if the data on this form replaces the data on a previously submitted form."]
[]
[]
[]
["Parent Company Name",null,{"$f":"IF('Company Info'!D8=\"\",\"\",'Company Info'!D8)","v":"<Parent Company Name>"},null,null,null,"Parent Company OCN ",null,null,{"$f":"IF('Company Info'!K8=\"\",\"\",'Company Info'!K8)","v":"<PC OCN>"}]
["Service Provider Name",null,{"$f":"IF('Company Info'!D9=\"\",\"\",'Company Info'!D9)","v":"<Service Provider Name>"},null,null,null,"Service Provider OCN ",null,null,{"$f":"IF('Company Info'!K9=\"\",\"\",'Company Info'!K9)","v":"<SP OCN>"}]
["Company Address",null,{"$f":"IF('Company Info'!D10=\"\",\"\",'Company Info'!D10)","v":"<Company Address>"},null,null,null,"Service Provider FRN ",null,null,{"$f":"IF('Company Info'!K10=\"\",\"\",'Company Info'!K10)","v":"<SP FRN>"}]
["Address 2",null,{"$f":"IF('Company Info'!D11=\"\",\"\",'Company Info'!D11)","v":"<Address 2>"},null,null,null,"SP Service Type ",null,null,{"$f":"IF('Company Info'!K11=\"\",\"\",'Company Info'!K11)","v":"<SP Service Type>"}]
["City",null,{"$f":"IF('Company Info'!D12=\"\",\"\",'Company Info'!D12)","v":"<City>"}]
["State",null,{"$f":"IF('Company Info'!D13=\"\",\"\",'Company Info'!D13)","v":"<State>"},null,null,null,"All Changes to Parent Company Name, Service Provider Name, Address, Contact Information, OCN(s), FRN and Service Type must be made on the Company Info page."]
["Zip",null,{"$f":"IF('Company Info'!D14=\"\",\"\",'Company Info'!D14)","v":"<Zip>"}]
["Contact Name",null,{"$f":"IF('Company Info'!D15=\"\",\"\",'Company Info'!D15)","v":"<Contact Name>"}]
["Contact Tel #",null,{"$f":"IF('Company Info'!D16=\"\",\"\",'Company Info'!D16)","v":"<Contact Tel#>"}]
["Fax #:",null,{"$f":"IF('Company Info'!D17=\"\",\"\",'Company Info'!D17)","v":"<Fax #>"}]
["E-mail",null,{"$f":"IF('Company Info'!D18=\"\",\"\",'Company Info'!D18)","v":"<E-mail>"}]
[]
[null,null,null,null,null," Forecast Reported In NXX(s) Per Rate Center, Per Year (Initial Codes)"]
["NPA","Rate Center Abbreviation","State Abbr.","Year 1","Year 2","Year 3","Year 4","Year 5","Total NXX(s)","Errors/Messages",null," "]
["<NPA>","<Rate Center Abbr>","<St>",0,0,0,0,0,{"$f":"IF(SUM(D22:H22)>1,\"Error\",SUM(D22:H22))","v":0}]

{"sheet":"Form F-2b","index":11,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[[12,6,16,9]]}
[null,null,null,null,null,"Form F-2b -   FORECAST REPORTING FORM (FOR NON-POOLING CARRIERS IN POOLING AREAS)"]
[null,null,null,null,null,"(GROWTH CODES)"]
[null,null,null,null,null,">>> Please See The Instructions Before Completing This Form <<<"]
[null,"Check this box if the data on this form replaces the data on a previously submitted form."]
[]
[]
[]
["Parent Company Name",null,{"$f":"IF('Company Info'!D8=\"\",\"\",'Company Info'!D8)","v":"<Parent Company Name>"},null,null,null,"Parent Company OCN ",null,null,{"$f":"IF('Company Info'!K8=\"\",\"\",'Company Info'!K8)","v":"<PC OCN>"}]
["Service Provider Name",null,{"$f":"IF('Company Info'!D9=\"\",\"\",'Company Info'!D9)","v":"<Service Provider Name>"},null,null,null,"Service Provider OCN ",null,null,{"$f":"IF('Company Info'!K9=\"\",\"\",'Company Info'!K9)","v":"<SP OCN>"}]
["Company Address",null,{"$f":"IF('Company Info'!D10=\"\",\"\",'Company Info'!D10)","v":"<Company Address>"},null,null,null,"Service Provider FRN ",null,null,{"$f":"IF('Company Info'!K10=\"\",\"\",'Company Info'!K10)","v":"<SP FRN>"}]
["Address 2",null,{"$f":"IF('Company Info'!D11=\"\",\"\",'Company Info'!D11)","v":"<Address 2>"},null,null,null,"SP Service Type ",null,null,{"$f":"IF('Company Info'!K11=\"\",\"\",'Company Info'!K11)","v":"<SP Service Type>"}]
["City",null,{"$f":"IF('Company Info'!D12=\"\",\"\",'Company Info'!D12)","v":"<City>"}]
["State",null,{"$f":"IF('Company Info'!D13=\"\",\"\",'Company Info'!D13)","v":"<State>"},null,null,null,"All Changes to Parent Company Name, Service Provider Name, Address, Contact Information, OCN(s), FRN and Service Type must be made on the Company Info page."]
["Zip",null,{"$f":"IF('Company Info'!D14=\"\",\"\",'Company Info'!D14)","v":"<Zip>"}]
["Contact Name",null,{"$f":"IF('Company Info'!D15=\"\",\"\",'Company Info'!D15)","v":"<Contact Name>"}]
["Contact Tel #",null,{"$f":"IF('Company Info'!D16=\"\",\"\",'Company Info'!D16)","v":"<Contact Tel#>"}]
["Fax #:",null,{"$f":"IF('Company Info'!D17=\"\",\"\",'Company Info'!D17)","v":"<Fax #>"}]
["E-mail",null,{"$f":"IF('Company Info'!D18=\"\",\"\",'Company Info'!D18)","v":"<E-mail>"}]
[]
[null,null,null,null,null," Forecast Reported In NXX(s) Per Rate Center, Per Year (Growth Codes)"]
["NPA","Rate Center Abbreviation","State Abbr.","Year 1","Year 2","Year 3","Year 4","Year 5","Total NXX(s)","Errors/Messages",null," "]
["<NPA>","<Rate Center Abbr>","<St>",0,0,0,0,0,{"$f":"IF(SUM(D22:H22)>300,\"Error\",SUM(D22:H22))","v":0}]

{"sheet":"Form F-3a","index":12,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[[12,6,16,9]]}
[null,null,null,null,null,"Form F-3a -   FORECAST REPORTING FORM (FOR CARRIERS IN NON-POOLING AREAS)"]
[null,null,null,null,null,"(INITIAL CODES)"]
[null,null,null,null,null,">>> Please See The Instructions Before Completing This Form <<<"]
[null,"Check this box if the data on this form replaces the data on a previously submitted form."]
[]
[]
[]
["Parent Company Name",null,{"$f":"IF('Company Info'!D8=\"\",\"\",'Company Info'!D8)","v":"<Parent Company Name>"},null,null,null,"Parent Company OCN ",null,null,{"$f":"IF('Company Info'!K8=\"\",\"\",'Company Info'!K8)","v":"<PC OCN>"}]
["Service Provider Name",null,{"$f":"IF('Company Info'!D9=\"\",\"\",'Company Info'!D9)","v":"<Service Provider Name>"},null,null,null,"Service Provider OCN ",null,null,{"$f":"IF('Company Info'!K9=\"\",\"\",'Company Info'!K9)","v":"<SP OCN>"}]
["Company Address",null,{"$f":"IF('Company Info'!D10=\"\",\"\",'Company Info'!D10)","v":"<Company Address>"},null,null,null,"Service Provider FRN ",null,null,{"$f":"IF('Company Info'!K10=\"\",\"\",'Company Info'!K10)","v":"<SP FRN>"}]
["Address 2",null,{"$f":"IF('Company Info'!D11=\"\",\"\",'Company Info'!D11)","v":"<Address 2>"},null,null,null,"SP Service Type ",null,null,{"$f":"IF('Company Info'!K11=\"\",\"\",'Company Info'!K11)","v":"<SP Service Type>"}]
["City",null,{"$f":"IF('Company Info'!D12=\"\",\"\",'Company Info'!D12)","v":"<City>"}]
["State",null,{"$f":"IF('Company Info'!D13=\"\",\"\",'Company Info'!D13)","v":"<State>"},null,null,null,"All Changes to Parent Company Name, Service Provider Name, Address, Contact Information, OCN(s), FRN and Service Type must be made on the Company Info page."]
["Zip",null,{"$f":"IF('Company Info'!D14=\"\",\"\",'Company Info'!D14)","v":"<Zip>"}]
["Contact Name",null,{"$f":"IF('Company Info'!D15=\"\",\"\",'Company Info'!D15)","v":"<Contact Name>"}]
["Contact Tel #",null,{"$f":"IF('Company Info'!D16=\"\",\"\",'Company Info'!D16)","v":"<Contact Tel#>"}]
["Fax #:",null,{"$f":"IF('Company Info'!D17=\"\",\"\",'Company Info'!D17)","v":"<Fax #>"}]
["E-mail",null,{"$f":"IF('Company Info'!D18=\"\",\"\",'Company Info'!D18)","v":"<E-mail>"}]
[]
[null,null,null,null,null," Forecast Reported In NXX(s) Per NPA, Per Year (Initial Codes)"]
[null,"NPA","State Abbr.","Year 1","Year 2","Year 3","Year 4","Year 5","Total NXX(s)","Errors/Messages",null," "]
[null,"<NPA>","<St>",0,0,0,0,0,{"$f":"IF(SUM(D22:H22)>200,\"Error\",SUM(D22:H22))","v":0}]

{"sheet":"Form F-3b","index":13,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[[12,6,16,9]]}
[null,null,null,null,null,"Form F-3b -   FORECAST REPORTING FORM (FOR CARRIERS IN NON-POOLING AREAS)"]
[null,null,null,null,null,"(GROWTH CODES)"]
[null,null,null,null,null,">>> Please See The Instructions Before Completing This Form <<<"]
[null,"Check this box if the data on this form replaces the data on a previously submitted form."]
[]
[]
[]
["Parent Company Name",null,{"$f":"IF('Company Info'!D8=\"\",\"\",'Company Info'!D8)","v":"<Parent Company Name>"},null,null,null,"Parent Company OCN ",null,null,{"$f":"IF('Company Info'!K8=\"\",\"\",'Company Info'!K8)","v":"<PC OCN>"}]
["Service Provider Name",null,{"$f":"IF('Company Info'!D9=\"\",\"\",'Company Info'!D9)","v":"<Service Provider Name>"},null,null,null,"Service Provider OCN ",null,null,{"$f":"IF('Company Info'!K9=\"\",\"\",'Company Info'!K9)","v":"<SP OCN>"}]
["Company Address",null,{"$f":"IF('Company Info'!D10=\"\",\"\",'Company Info'!D10)","v":"<Company Address>"},null,null,null,"Service Provider FRN ",null,null,{"$f":"IF('Company Info'!K10=\"\",\"\",'Company Info'!K10)","v":"<SP FRN>"}]
["Address 2",null,{"$f":"IF('Company Info'!D11=\"\",\"\",'Company Info'!D11)","v":"<Address 2>"},null,null,null,"SP Service Type ",null,null,{"$f":"IF('Company Info'!K11=\"\",\"\",'Company Info'!K11)","v":"<SP Service Type>"}]
["City",null,{"$f":"IF('Company Info'!D12=\"\",\"\",'Company Info'!D12)","v":"<City>"}]
["State",null,{"$f":"IF('Company Info'!D13=\"\",\"\",'Company Info'!D13)","v":"<State>"},null,null,null,"All Changes to Parent Company Name, Service Provider Name, Address, Contact Information, OCN(s), FRN and Service Type must be made on the Company Info page."]
["Zip",null,{"$f":"IF('Company Info'!D14=\"\",\"\",'Company Info'!D14)","v":"<Zip>"}]
["Contact Name",null,{"$f":"IF('Company Info'!D15=\"\",\"\",'Company Info'!D15)","v":"<Contact Name>"}]
["Contact Tel #",null,{"$f":"IF('Company Info'!D16=\"\",\"\",'Company Info'!D16)","v":"<Contact Tel#>"}]
["Fax #:",null,{"$f":"IF('Company Info'!D17=\"\",\"\",'Company Info'!D17)","v":"<Fax #>"}]
["E-mail",null,{"$f":"IF('Company Info'!D18=\"\",\"\",'Company Info'!D18)","v":"<E-mail>"}]
[]
[null,null,null,null,null," Forecast Reported In NXX(s) Per NPA, Per Year (Growth Codes)"]
[null,"NPA","State Abbr.","Year 1","Year 2","Year 3","Year 4","Year 5","Total NXX(s)","Errors/Messages",null," "]
[null,"<NPA>","<St>",0,0,0,0,0,{"$f":"IF(SUM(D22:H22)>600,\"Error\",SUM(D22:H22))","v":0}]

{"sheet":"Rural Certification","index":14,"n_rows":26,"n_cols":24,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"RURAL CERTIFICATION FORM"]
[null,null,null,null,null,">>> Please See The Instructions Before Completing This Form <<<"]
[]
[null,null,null,null,null,"This form must be completed by an officer of the reporting company",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[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," "]
["I,"," <Officer Name>,",null,null,null," certify that ",{"$f":" 'Company Info'!D9","v":"<Service Provider Name>"},null,null,null,"operating as a "]
[{"$f":" 'Company Info'!K11","v":"<SP Service Type>"},null,null,"is a \"Rural telephone company\" as defined in the Communications Act, 47 U.S.C. § 153(37)."]
["OCN  =",{"$f":" 'Company Info'!K9","v":"<SP OCN>"}]
[null,null,null," "]
[null,null,null," "]
["Electronic Signature",null,"Type <Officer Name>"]
["Telephone Number",null,"Type <Officer Number>"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null," "]

{"sheet":"Instructions","index":15,"n_rows":277,"n_cols":14,"rows_kept":277,"cut":false,"hidden":false,"merged":[[153,0,160,15],[276,0,285,15],[169,0,170,15],[248,0,250,15],[253,0,256,15],[258,0,261,15],[217,0,221,15],[223,0,225,15],[264,0,273,15],[205,0,209,15],[232,0,236,15],[1,3,1,14],[7,2,7,13],[73,0,79,15],[162,0,167,15],[245,0,245,15],[118,0,130,15],[132,0,141,15],[82,0,88,15],[145,0,151,15],[213,0,215,15],[211,0,211,2],[173,0,175,15],[178,0,189,15],[106,0,116,15],[91,0,97,15],[100,0,104,15],[64,0,68,15],[48,0,52,15],[56,0,59,15],[60,0,62,15],[9,0,14,15],[54,0,54,2],[17,0,30,15]]}
[]
[" "," "," ","           INSTRUCTIONS FOR UTILIZATION AND  FORECAST FORMS"]
[]
[null,null," "]
[]
[null,null,null,null,null,null,null,null,null,null," ",null,null," "]
[]
[" ",null,"                      >>>Please Read Thoroughly Before Completing Forms<<<"]
["When to File:"]
["Reporting carriers shall file utililization and forecast reports semi-annually on or before February 1 for the preceding 6 month reporting period ending on December 31, and on or before August 1 for the preceding 6 month reporting period ending on June 30.  Reporting is mandatory.  "]
[]
[]
[]
[]
[]
[]
["Company Information:"]
["Reporting carriers must provide information about their company by filling in the gray boxes on the Company Information worksheet.  The following fields are required: Parent Company Name, Service Provider Name, Company Address, City, State, Zip, Contact Name, Contact Tel#, Email, Parent Company OCN, SP OCN, SP FRN, and SP Service Type.  If any of these fields are not provided, the Form 502 will be rejected.  The SP OCN is the 4 character code assigned by NECA for the reporting carrier.  Carriers that have multiple OCNs must submit a separate Form 502 for each OCN that they hold numbering resources under.  The SP FRN is the 10 digit FCC Registration Number assigned to the carrier by the Federal Communications Commission (FCC) and is the same number used by entities on FCC Form 499-A."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PART 1 - UTILIZATION INSTRUCTIONS"]
[]
["Choose the appropriate utilization form from the \"Main Menu\" page by clicking on the appropriate button:"]
[]
["U1","Non-Rural Primary Carriers "]
[null,"All carriers report at 1000 block level per Rate Center"]
[]
["U2","Rural Primary Carriers"]
[null,"All carriers report at NPA-NXX code level per Rate Center. "]
[]
["U3","Non-Rural Intermediate Carriers"]
[null,"All carriers report at 1000 block level per Rate Center"]
[]
["U4","Rural Intermediate Carriers"]
[null,"All carriers report at NPA-NXX code level per Rate Center. "]
[]
["Rural carriers are required to complete either the U2 or U4 utilization reports at the NXX level and the appropriate forecast forms.   Please note an exception exists if the rural carrier is reporting on NPA-NXXs that are pooled.  The rural carrier must report on the status of pooled NPA-NXX codes on the U1 or U3 utilization reports because the U2 and U4 forms do not accomodate reporting at the block (NPA-NXX-X) level.  "]
[]
[]
[]
[]
[]
["Carrier Types:"]
[]
["Primary Carrier is defined as a carrier that receives numbers directly from the Numbering or Pooling Administrator.  Forms U1 and U2 are used by these carriers to report number utilization.  "]
[]
[]
[]
["Intermediate Carrier is defined as a carrier that receives numbers from another carrier.  Forms U3 and U4 are used by these carriers to report number utilization.  "]
[]
[]
[]
["Rural Carrier is defined in the Communications Act, 47 U.S.C.§153(37) . Rural carriers must, in addition to completing the appropriate utilization and forecast forms, complete a Rural Status Certification Form (available from the \"Main Menu\"). "]
[]
[]
[]
[]
[]
["Utilization Data:"]
[]
["NPA-NXX"]
["Rural carriers completing forms U2 or U4 report utilization at the NXX level.  For each NXX in which your company has numbering resources, enter the NPA-NXX and the quantity of Assigned, Intermediate, Reserved, Aging and Administrative numbers.  Enter one line for each NXX below the Headers.  Do not leave any blank lines between your entries."]
[]
[]
[]
[]
[]
[]
[]
["NPA-NXX-X"]
["Non rural carriers completing Forms U1 or U3 report utilization at the 1000 block level.  For each NPA-NXX-X in which your company has numbering resources, enter the NPA-NXX-X and the quantity of Assigned, Intermediate, Reserved, Aging and Administrative numbers.   Enter one line for each 1000 block below the Headers.  Do not leave any blank lines between your entries."]
[]
[]
[]
[]
[]
[]
[]
["LERG Rate Center Name and State"]
["Both Rural and Non-Rural Carriers must also enter the name of each Rate Center in which your company has numbering resources as it appears in the LERG Table 8 under RC ABBREV.  Rural Carriers must also enter the 2 character abbreviation of the state in which the Rate Center/NPA is located for which you are reporting."]
[]
[]
[]
[]
[]
[]
[]
["Usage Categories"]
["Each utilization form requires that numbers be reported in five categories as defined in FCC Order 00-104.  A sixth category, \"Available,\" is automatically calculated and no entry is required.  The \"Available\" calculation is created when you click on the \"Check the Data Before Submitting\" button."]
[]
[]
[]
[]
[]
["Assigned:  Enter the quantity of Telephone Numbers (TNs) that are classified as \"Assigned\" for each identified NPA-NXX or NPA-NXX-X.  Assigned numbers are defined as \"numbers working in the Public Switched Telephone Network under an agreement such as a contract or tariff at the request of specific end users or customers for their use, or numbers not yet working but having a customer service order pending.  Numbers that are not yet working and have a service order pending for more than five days shall not be classified as assigned numbers.\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[" "]
["Intermediate:  Enter the quantity of TNs that are classified as \"Intermediate\" for each identified NPA-NXX or NPA-NXX-X.  Intermediate numbers are defined as \"numbers that are made available for use by another telecommunications carrier or non-carrier entity for the purpose of providing telecommunications service to an end user or customer.\"  An exception to this requirement is numbers ported for the purpose of transferring an established customer's service to another service provider, in which case the numbers are classified as \"Assigned\" by the porting carrier and not counted by the receiving carrier.    "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["For intermediate numbers provided by carriers to non-carrier entities, the providing carrier must report utilization for these numbers.  Numbers assigned to end users by a non-carrier entity should be reported by the providing carrier as \"Assigned.\"  Any remaining numbers held by a non-carrier entity that are not assigned to end users shall be reported by the providing carrier as \"Intermediate.\"  The sum of numbers reported by the carrier for the non-carrier entity in these two categories should always equal the total of numbers held by the non-carrier entity.  "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[" "]
[]
["Reserved:  Enter the quantity of TNs that are classified as \"Reserved\" for each identified NPA-NXX or NPA-NXX-X.  Reserved numbers are defined as \"numbers that are held by service providers at the request of specific end users or customers for their future use\".  Numbers held for specific end users or customers for more than 180 days shall not be classified as reserved numbers."]
[]
[]
[]
[]
[]
[]
[]
["Aging:  Enter the quantity of TNs that are classified as \"Aging\" for each identified NPA-NXX or NPA-NXX-X.  Aging numbers are defined as \"disconnected numbers that are not available for assignment to another end user or customer for a specified period of time.\"  Numbers previously assigned to residential customers may be aged for no more than 90 days.  Numbers previously assigned to business customers may be aged for no more than 365 days."]
[]
[]
[]
[]
[]
[]
[]
[]
["Administrative:  Enter the quantity of TNs that are classified as \"Administrative\" for each identified NPA-NXX or NPA-NXX-X.  Administrative numbers are defined as \"numbers used by telecommunications carriers to perform internal administrative or operational functions necessary to maintain reasonable quality of service standards.\""]
[]
[]
[]
[]
[]
[]
["Donated to Pool:  Enter an \"X\" if the NPA-NXX-X block has been donated to a pool. "]
[]
["Quantities of Numbers Received:  Enter the total quantity of numbers received."]
[]
["Notes/Assignee:  Intermediate carriers - enter the name of the carrier from which you received numbers. Primary carriers - enter the name of the entity to which you gave numbers."]
[]
[]
[]
["Completion"]
["Confirm that  the data requested above has been provided for all of the numbering resources which are allocated to your company then click on the \"Check the Data Before Submitting\" button.  Formulas that automatically calculate the Available and Utilization values will be added to each row where data has been entered.  Also, the data entered will be checked for format and to see that it is within valid ranges.  Error/Check messages will be added on the right end of each row that should be checked and corrected before submitting the form to NANPA. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PART 2 - FORECAST INSTRUCTIONS"]
[]
["Choose the appropriate forecast form from the \"Main Menu\" page by clicking on the appropriate button:"]
[]
["F1a","Pooling Carriers - Initial "]
["F1b","Pooling Carriers - Growth "]
[]
["F2a","Non-Pooling Carriers in Pooling Areas - Initial "]
["F2b","Non-Pooling Carriers in Pooling Areas - Growth"]
[]
["F3a","Carriers in Non-Pooling Areas - Initial"]
["F3b","Carriers in Non-Pooling Areas - Growth"]
[]
[]
["Carriers that pool in some but not all areas in which they have numbering resources, or that have numbering resources in both pooling and non-pooling areas, need to complete more than one pair of forms to account for all of their numbering resources."]
[]
[]
[]
[]
[]
["Carrier Types:"]
[]
["Pooling Carrier is defined as a carrier that donates to and receives numbers from a number pool.  Forms F1a and F1b are used by these carriers to forecast number requirements."]
[]
[]
[]
["Non Pooling Carrier in Pooling Areas is defined as a carrier that provides service in areas where there is number pooling, but does not donate to or receive numbers from the number pool.  Forms F2a and F2b are used by these carriers to forecast number requirements."]
[]
[]
[]
[]
[]
["Carrier in Non-pooling area is defined as a carrier that provides service in areas where there is no number pooling.  Forms F3a and F3b are used by these carriers to forecast number requirements."]
[]
[]
[]
[]
[]
["Forecast Data:"]
[]
["Initial versus Growth"]
["Initial numbering resources are the first numbering resources received by a carrier in a particular area.   Growth numbering resources are additional numbering resources received by a carrier already established in a particular area."]
[]
[]
[]
[]
[]
["NPA"]
["Enter the NPA for which you are providng forecast data."]
[]
["LERG Rate Center Name"]
["Enter the name of each Rate Center name as it appears in the LERG Table 8 under RC ABBREV."]
[]
["State"]
["Enter the 2 character abbreviation of the State in which the NPA or Rate Center is located for which you are providing forecast data."]
[]
["Pooling Carriers"]
["Enter the number of Initial and Growth 1000 blocks that your company will require for each applicable Rate Center for the next five years."]
[]
[]
[]
["Non-Pooling Carriers in Pooling Areas"]
["Enter the number of Initial and Growth NXX codes that your company will require for each applicable Rate Center for the next five years. "]
[]
[]
[]
["Carriers in Non-Pooling Areas"]
["Enter the number of Initial and Growth NXX codes that your company will require for each applicable NPA for the next five years."]
[]
[]
[]
[]
["Completion"]
["Confirm that the data requested above has been provided for all applicable states, NPAs and Rate Centers then click on the \"Check the Data Before Submitting\" button.  A formula that automatically calculates the Total NXXs or 1K Blocks will be added to each row where data has been entered.  Also, the data entered will be checked for format and to see that it is within valid ranges.  Error/Check messages will be added on the right end of each row that should be checked and corrected before submitting the form to NANPA. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Submit Forms"]
["Save this workbook to a file in Excel™ format (e.g., cocus.xlsm or cocus.xlsx), attach the file to an email and send it to nruf@nanpa.com.  If you are submitting the information via fax or EFT (Electronic File Transfer), please visit the NANPA website at www.nanpa.com for additional information.  For additional questions or instructions contact NANPA at 1-866-623-2282."]