Formatting Instructions - Availability Subs and ARPU Format of Data The required format for the entries in each column/field is indicated in the instructions for each sheet. Data for all of the tables should be submitted on a periodic basis as specified in the instructions in individual tables. All data should be submitted in a .csv (comma-delimited) format. The sheets in the workbook provide a template for how the tables should be designed. Column entries in bold red indicate that the party should enter only one of the possible entries listed for that column. No other entries should be entered. Availability, Subs, and ARPU "Availability, Subscription and ARPU data by delivery technology" For each month beginning January 2012 through June 2014, provide the availability, subscription and ARPU data listed below. Column Variable Name Format Possible Entries/ Example Entries Description A date Text - YYYY_MM 2012_01 to 2014_06 The date for which the data is being collected B tech Integer 1, 2, 3, 4, 5, 6 Technology code of the service (see Tech Table for the 6 technology types) C residential Integer 1, 0 Location type - enter 1 if the location is residential and 0 if other (non-residential) location D locs Integer 605 Number of Customer locations where the Company offers service E subs_MVPD Integer 158 Number of subscribers to MVPD Service only as of the end of the month F subs_IA Integer 210 Number of subscribers to Internet Access Service only as of the end of the month G subs_Tel Integer 28 Number of subscribers to Telephony Service only as of the end of the month H subs_MVPD_IA Integer 322 Number of subscribers to MVPD Service and Internet access services only as of the end of the month I subs_MVPD_Tel Integer 56 Number of subscribers to MVPD Service and Telephony Service only as of the end of the month J subs_IA_Tel Integer 98 Number of subscribers to Internet Access Service and Telephony Service only as of the end of the month K subs_MVPD_IA_Tel Integer 111 Number of subscribers to MVPD Service, Internet Access Service and Telephony Service as of the end of the month L adds_MVPD Integer 14 Number of subscribers beginning MVPD Service during the month M adds_IA Integer 21 Number of subscribers beginning Internet Access Service during the month N adds_Tel Integer 3 Number of subscribers beginning Telephony Service during the month O drops_MVPD Integer 16 Number of subscribers ending MVPD Service during the month P drops_IA Integer 18 Number of subscribers ending Internet Access Service during the month Q drops_Tel Integer 5 Number of subscribers ending Telephony Service during the month R arpu_MVPD Float 76.52 Average revenue per subscriber to MVPD Service only as of the end of the month S arpu_IA Float 67.35 Average revenue per subscriber to Internet Access Service only as of the end of the month T arpu_Tel Float 28.11 Average revenue per subscriber to Telephony Service only as of the end of the month U arup_MVPD_IA Float 125.39 Average revenue per subscriber to MVPD Service and Internet Access Service only as of the end of the month V arpu_MVPD_Tel Float 114.85 Average revenue per subscriber to MVPD Service and Telephony Service only as of the end of the month W arpu_IA_Tel Float 99.47 Average revenue per subscriber to Internet Access Service and Telephony Service only as of the end of the month X arpu_MVPD_IA_Tel Float 149.82 Average revenue per subscriber to MVPD Service, Internet Access Service and Telephony Service as of the end of the month Notes: A, B, C: Any variation in Date, Technology, or Location Type necessitates the creation of a new, unique record. B, D: If any individual location can be served using multiple technologies, please record the location only under the observation with the largest technology code. (For example, if a location can be served with both IPDSL and FTTP, include the location under the observation for technology code 6.) Template Availability Subs and ARPU date tech residential locs subs_ MVPD subs_ IA subs_ Tel subs_ MVPD_ IA subs_ MVPD_ Tel subs_IA_ Tel subs_MVPD _IA_Tel adds_MVPD adds_IA adds_ Tel drops_ MVPD drops_ IA drops_ Tel arpu_ MVPD arpu_I A arpu_ Tel arup_M VPD_IA arpu_ MVPD _Tel arpu_IA _Tel arpu_MVPD_ IA_Tel 2013_01 6 1 605 158 210 28 322 56 98 111 14 21 3 16 18 5 76.52 67.35 28.11 125.39 114.9 99.47 149.82 Tech Table Availability Subs and ARPU Technology Codes for Availability, Subscribers and ARPU Technology Code Description 1 Copper with no xDSL capability 2 xDSL 3 IPDSL 4 FTTN without capability to provide MVPD Service 5 FTTN with capability to provide MVPD Service 6 FTTP