{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Appendix B","Appendix C","Assumptions"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"defined_names":71,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Appendix B","index":0,"n_rows":69,"n_cols":9,"rows_kept":69,"cut":false,"hidden":false,"merged":[[0,1,0,4],[0,5,0,8],[24,1,24,4],[24,5,24,8],[10,1,10,4],[10,5,10,8]],"flags":["formulas_cached_only"]}
["APPENDIX B","Estimated Burden to the Public in Hours",null,null,null,"Estimated \"In-House\" Costs in Dollars to the Public  "]
[null,"1st Year","2nd Year","3rd Year","Average","1st Year","2nd Year","3rd Year","Average"]
["(A) Collection of Routing Information"]
["Cost to providers for development, testing, and deployment of systems to automatically obtain, retain, and provision routing information from registered users. [NewProviders x Hours/Provider x Software Cost/Hour amortized over three years]",0,0,0,0,0,0,0,0]
["Annual cost to providers for maintenance of systems to automatically obtain, retain, and provision routing information from registered users.  [Providers x Hours/Provider x Software Cost/Hour]",2500,2500,2500,2500,65000,65000,65000,65000]
["Cost to providers for configuring consumer premises equipment for automatic provisioning of routing information. [Number of registrations each year x Configuration attempts needing follow-up x Hours/User x Service costs/Hour]",5500,5500,5500,5500,58000,58000,58000,58000]
["Cost to users for configuring consumer premises equipment for automatic provisioning of routing information. [Number of registrations each year x (User hours + (Configuration attempts needing follow-up x Follow-up hours/user) x User costs/Hour]",9600,9600,9600,9600,83000,83000,83000,83000]
["Routing Information (Proposed Revised Requirement) Cost to providers for development, testing, and deployment of systems to remove any toll free number that has not been transferred to a subscription with a toll free service provider and for which the user is the subscriber of record, and to ensure that the toll free number of a user that is associated with a geographically appropriate NANP number will be associated with the same URI as that geographically appropriate NANP telephone number.  [Providers x Hours/Provider x Software Cost/Hour amortized over three years]",9800,9800,9800,9800,394334,394334,394334,394334]
["Subtotal",27400,27400,27400,27400,600334,600334,600334,600334]
["(B) Provisioning of Routing Information"]
["Costs to providers and users of provisioning routing information included in (A) above","(hours included in (A) above)",null,null,null,"(costs included in (A) above)"]
["(C) Collection of Registered Location"]
["Cost to providers for development, testing, and deployment of a webpage to collect registration information, including FAQs, etc., and to develop a separate tracking system for mail-in registration. [NewProviders x Hours/Provider x Software cost/Hour amortized over three years]",100,100,100,100,3068,3068,3068,3068]
["Annual cost to providers for maintenance of systems associated with registration services.  [Providers x Hours/Provider x Software cost/Hour]",3000,3000,3000,3000,154100,154100,154100,154100]
["Cost to providers for registration. [Number of registrations each year x Telephone Registrations x Hours/User x Service Cost/Hour]",2750,2750,2750,2750,56893,56893,56893,56893]
["Cost to users for registration. [Number of registrations each year x ((Online registrations x User hours) + (Telephone registrations x Hours/user)) x User Cost/Hour]",9790,9790,9790,9790,145000,145000,145000,145000]
["Cost to providers for Registered Location updates. (Number of users x Number of updates x Telephone updates x Hours/User x Service Cost/Hour)",660,660,660,660,19199.4,19199.4,19199.4,19199.4]
["Cost to users for Registered Location updates. (Number of users x Number of updates x ((Online updates x User hours) + (Telephone updates x Hours/User)) x User Cost/Hour)",4600,4600,4600,4600,80086,80086,80086,80086]
["Subtotal",20800,20800,20800,20800,455278,455278,455278,455278]
["(D) Provisioning of Registered Location and other information to ALI databases"]
["Cost to providers to develop, test, and deploy automated system for provisioning information to ALI databases. [NewProviders x Hours/Provider x Software cost/Hour amortized over three years]",400,400,400,400,14500,14500,14500,14500]
["Annual cost to providers to maintain automated system for provisioning information to ALI databases. [Providers x Hours/Provider x Software cost/Hour]",3760,3760,3760,3760,293880,293880,293880,293880]
["Subtotal",4160,4160,4160,4160,308380,308380,308380,308380]
["(E) User Advisory"]
["Costs to providers and users of posting and reading advisory included in (C) above (First Numbering Order)","(hours included in (C) above)",null,null,null,"(costs included in (C) above)"]
["(Second Numbering Order)"]
["Costs to providers to revise user advisory posted on website and included in promotional materials.  [Providers x Hours/Provider x Attorney Cost/Hour amortized over three years]",200,200,200,200,4091.3333333333335,4091.3333333333335,4091.3333333333335,4091.3333333333335]
["Costs to users to read revised advisory posted on website and included in promotional materials.  [New users x Hours/user x User Cost/Hour]",1780,1780,1780,1780,30989.8,30989.8,30989.8,30989.8]
["User Advisory (Proposed Revised Requirement)"]
["Costs to providers to revise user advisory posted on website and included in promotional materials to include the additional information regarding toll free issues.  [Providers x Hours/Provider x Attorney Cost/Hour amortized over three years]",100,100,100,100,2046,2046,2046,2046]
["Subtotal",2080,2080,2080,2080,37127,37127,37127,37127]
["(F) Record of Affirmative Acknowledgement"," ",null,null,null," "]
["Costs to providers of overseeing electronic storage of affirmative acknowledgement for users registered online.  [Providers x Cost/Provider x Software cost/Hour]",96,96,96,96,3499,3499,3499,3499]
["Subtotal",96,96,96,96,3499,3499,3499,3499]
["(G) Ascertaining Registration Status"]
["Costs to providers to collect and verify dial-around user's registration status.  [Users x Percentage of users that dial-around x Average number of dial-around calls per user x Hours to verify x Service Cost/Hour]",14560,14560,14560,14560,404010,404010,404010,404010]
["Costs to dial-around users to verify registration status.  [Users x Percentage of users that dial-around x Average number of dial-around calls per user x Hours to verify x User Cost/Hour]",14560,14560,14560,14560,234009,234009,234009,234009]
["Subtotal",29120,29120,29120,29120,638019,638019,638019,638019]
["(H) Verifying Registration Information"]
["Costs to providers to process online verifications.  [Registrations x Percent verifications online x Hours to process x Service Cost/Hour]",2448,2448,2448,2448,42620,42620,42620,42620]
["Costs to users to submit online verifications.  [Registrations x Percent verifications online x Hours to submit x User Cost/Hour]",2448,2448,2448,2448,42619.68,42620,42620,42619.89333333333]
["Costs to providers to process mail-in verifications.  [Registrations x Percent verifications mailed in x Hours to process x Service Cost/Hour]",6100,6100,6100,6100,177449,177449,177449,177449]
["Costs to users to submit mail-in verifications.  [Registrations x Percent verifications mailed in x Hours to submit x User Cost/Hour]",1390,1390,1390,1390,7300,7300,7300,7300]
["Subtotal",12385.530864197533,12386,12386,12385.843621399179,269989,269989,269989,269989]
["(I) Pass-Through Petitions"]
["Costs to providers to file petitions with Commission to pass costs through to consumers.  [Providers x Frequency of Petitions x Hours to File Petition/Provider x Attorney Cost/Hour]",256,256,256,256,7855,7855,7855,7855]
["Subtotal",256,256,256,256,7855,7855,7855,7855]
["(J) CPE Information Exchange"]
["Costs to providers to develop software to share information with new default providers regarding existing CPE.  [Providers x Hours/Provider x Software Cost/Hour amortized over three years]",1200,1200,1200,1200,24548,24548,24548,24548]
["Costs to providers to exchange CPE information when user changes default providers.  [Users x Percent of users changing providers x Providers per Change x Hours/Provider x Service Cost/Hour]",1723,1723,1723,1723,50122.07,50122.07,50122.07,50122.07]
["Subtotal",2923,2923,2923,2923,74670.07,74670.07,74670.07,74670.07]
["Cumulative Total",99221,99221,99221,99221,2395151,2395151,2395151,2395151]
[{"$nulls":8}," "]
["Annual Responses"]
["Routing information collections",1480000]
["Provisions of routing information to the TRS Numbering Directory",1480000]
["Registered location collections",250000]
["Provisions to the ALI databases",250000]
["Advisories",160000]
["Affirmative acknowledgements",160000]
["Revised advisories",160000]
["Numbering Directory queries to determine registration status",3262500]
["Registration verifications",160000]
["Petitions seeking pass-through of numbering costs",24]
["Information exchanges after default provider switch",121600]
["Numbering Directory transactions for toll free subscriptions and matches with URI associated with geographically appopriate NANP number",850]
["User advisories addressing toll free issues",32]
["Total Number of Annual Responses Over the Next Three Years",7485006]
["Total Number of Annual Responses ",2495002]

{"sheet":"Appendix C","index":1,"n_rows":55,"n_cols":5,"rows_kept":55,"cut":false,"hidden":false,"merged":[[0,1,0,4],[8,1,8,4],[22,1,22,4],[24,1,24,4],[48,1,48,4],[46,1,46,4],[35,1,35,4],[37,1,37,4],[39,1,39,4],[30,1,30,4]],"flags":["formulas_cached_only"]}
["APPENDIX C","Estimated Burden to the Public                         in Dollars"]
[null,2009,2010,2011,"Average"]
["(A) Collection of Routing Information"]
["Annual cost to providers for additional server space, memory, communications, and backup/recovery service associated with routing information systems. [Providers x Costs/Provider]",31200,31200,31200,31200]
["Subtotal, Capital and Startup Cost",0,0,0,0]
["Subtotal, Operation, Maintenance, and Services Cost",31200,31200,31200,31200]
["Subtotal",31200,31200,31200,31200]
["(B) Provisioning of Routing Information"]
["Costs to providers and users of provisioning routing information included in (A) above","(costs included in (A) above)"]
["(C) Collection of Registered Location"]
["Annual cost to providers for additional server space, memory, communications, and backup/recovery service associated with registration systems. [Providers x Costs/Provider]",31200,31200,31200,31200]
["Subtotal, Capital and Startup Cost",0,0,0,0]
["Subtotal, Operation, Maintenance, and Services Cost",31200,31200,31200,31200]
["Subtotal",31200,31200,31200,31200]
["(D) Provisioning of Registered Location and other information to ALI databases"]
["Cost to providers of gateway routers. [Number of routers x Costs/Router / Router amortization]",2100000,2100000,2100000,2100000]
["Costs to providers for dedicated lines between gateway routers and specialized routers.  [Number of connections x Costs/Connection]",1940000,1940000,1940000,1940000]
["Costs to providers for access to Wireline E911 Network and related services.  [Number of users x Costs/User]",132500,147500,155000,145000]
["Subtotal, Capital and Startup Cost",2100000,2100000,2100000,2100000]
["Subtotal, Operation, Maintenance, and Services Cost",2072500,2087500,2095000,2085000]
["Subtotal",4172500,4187500,4195000,4185000]
["(E) User Advisory"]
["Costs to providers and users of posting and reading advisory included in (C) above","(costs included in (C) above)"]
["(F) Record of Affirmative Acknowledgement"]
["Costs to providers and users of obtaining affirmative acknowledgement included in (C) above","(costs included in (C) above)"]
["Costs to providers of storing paper records of affirmative acknowledgement for users registered over the telephone.  [Cumulative number of registrations x Telephone registrations / Paper record per cubic foot * Cost per cubic foot]",671,853.5999999999999,1016.4000000000001,847]
["Subtotal, Capital and Startup Cost",0,0,0,0]
["Subtotal, Operation, Maintenance, and Services Cost",671,853.5999999999999,1016.4000000000001,847]
["Subtotal",671,853.5999999999999,1016.4000000000001,847]
["(G) Interstate TRS Fund Submission"]
["Costs to providers to collect and submit costs of complying with the numbering and emergency handling requirements of the Order.","(no exterior costs)"]
["Capital and Startup Cost for First Numbering Order",2100000,2100000,2100000,2100000]
["Operation, Maintenance, and Services Cost for First Numbering Order",2135571,2150753.6,2158416.4,2148247]
["Total for First Numbering Order",4235571,4250753.6,4258416.4,4248247]
["(E) User Advisory (Revised)"]
["Costs to providers of revising user advisory.","(no exterior costs)"]
["(H) Message Notifying Callers of New Number"]
["Costs to providers of creating message to notify callers of new number.","(no exterior costs)"]
["(I) Ascertaining Registration Status"]
["Costs to providers of ascertaining registration status of dial-around users.","(no exterior costs)"]
["(J) Verifying Registration Information"]
["Cost to providers of storing paper records of mail-in verifications. [Cumulative number of registrations x Percent verifications mailed in / Paper record per cubic foot * Cost per cubic foot]",2684,3414.3999999999996,4065.6000000000004,3388]
["Subtotal, Capital and Startup Cost",0,0,0,0]
["Subtotal, Operation, Maintenance, and Services Cost",2684,3414.3999999999996,4065.6000000000004,3388]
["Subtotal",2684,3414.3999999999996,4065.6000000000004,3388]
["(K) Pass-Through Petitions"]
["Costs to providers of petitioning Commission to pass-through certain costs to consumers.","(no exterior costs)"]
["(L) CPE Information Exchange"]
["Costs to providers of exchanging CPE information with former and new default providers.","(no exterior costs)"]
["Capital and Startup Cost for Second Numbering Order",0,0,0,0]
["Operation, Maintenance, and Services Cost for Second Numbering Order",2684,3414.3999999999996,4065.6000000000004,3388]
["Total for Second Numbering Order",2684,3414.3999999999996,4065.6000000000004,3388]
["Cumulative Capital and Startup Cost",2100000,2100000,2100000,2100000]
["Cumulative Operation, Maintenance, and Services Cost",2138255,2154168,2162482,2151635]
["Cumulative Total",4238255,4254168,4262482,4251635]

{"sheet":"Assumptions","index":2,"n_rows":62,"n_cols":2,"rows_kept":62,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Providers",12]
["NewProviders",2]
["Users2008",200000]
["Users2009",265000]
["Users2010",295000]
["Users2011",310000]
["UsersChange",0.2]
["Registrations2009",305000]
["Registrations2010",83000]
["Registrations2011",74000]
["UsersUpdate",0.4]
["HourlySoftware",61.37]
["HourlyService",29.09]
["HourlyUser",17.41]
["MaintainRouting",2600]
["MaintainRegister",2600]
["HoursDevelopRouting",800]
["HoursMaintainRouting",250]
["HoursDevelopRegister",300]
["HoursMaintainRegister",250]
["HoursDevelopProvisioning",1600]
["HoursMaintainProvisioning",400]
["HoursModifyAdvisory",40]
["HoursStorage",12]
["HoursCPEFix",300]
["HoursCostCollection",8]
["HoursCostPassthrough",16]
["HoursNewNumber",0.1]
["HoursDialAround",0.008]
["HoursOnlineVerify",0.017]
["HoursMailinVerify",0.3]
["HoursCPEExchange",0.017]
["ConfigureUser",0.2]
["ConfigureFollowup",0.3]
["ConfigureProvider",0.3]
["RegisterUser",0.15]
["RegisterContact",0.1]
["RegisterProvider",0.25]
["UpdateUser",0.05]
["UpdateContact",0.1]
["UpdateProvider",0.08]
["UserAdvisory",0.05]
["UserOnlineVerify",0.017]
["UserMailinVerify",0.15]
["UsersProxy",0.9]
["UsersDialAround",0.75]
["UsersOnlineVerifyPercent",0.6]
["CostCollectionFrequency",12]
["PassthroughFrequency",4]
["AverageDialArounds",15]
["Gateways",75]
["GatewayPrice",140000]
["GatewayAmortization",5]
["ConnectSameCity",75]
["ConnectNewCity",125]
["PriceSameCity",4200]
["PriceNewCity",13000]
["ALI2009",0.5]
["ALI2010",0.5]
["ALI2011",0.5]
["PaperStorage",500]
["PaperCost",11]