Page 1 of 3 Attachment C.1 Data Formatting 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. Data for all of the tables should be submitted on a periodic basis as specified in the instructions in individual tables. Formatting Instructions Column A B C D E F G H I J K L M N O P Q Total number of subscribers to the Company's bundled MVPD and Telephone service (no Internet Access Service) in this zip code at the end of the month Total number of subscribers to the Company's bundled Internet Access and Telephone services (no MVPD Service) in this zip code at the end of the month Number of subscribers to the Company's bundled MVPD, Internet Access and Telephone services in this zip code at the end of the month Total number of subscribers to the Company's Telephone Service in this zip code at the end of the month Total number of subscribers to the Company's standalone MVPD Service in this zip code at the end of the month Total number of subscribers to the Company's standalone Internet Access Service in this zip code at the end of the month Total number of subscribers to the Company's standalone Telephone Service in this zip code at the end of the month Total number of subscribers to the Company's bundled MVPD and Internet Access services (no Telephone Service) in this zip code at the end of the month Description The month and year for which the data is being collected Five-digit zip code (with leading zeros). (Use code 00000 for the Company as a whole) Total number of subscribers in this zip code to any Company Cable Services at the end of the month Total number of subscribers to the Company's MVPD Service in this zip code at the end of the month Possible Entries / Example standalone_video_subs Integer 45 date Text - YYYY_MM 2012_06 to 2015_08 Variable Name Format Text 20427zip total_subs Integer 227 Integer 45 internet_subs Integer 21 video_subs internet_tier1_subs Integer 35 internet_phone_subs Integer 151 18 internet_tier3_subs Integer 151 internet_tier2_subs Integer 21 standalone_phone_subs Total number of subscribers to the Company's Internet Access Service in this zip code at the end of the month phone_subs Integer 24 Integer 24 "Subs Data" Table The required format for the entries in each column/field is indicated in the instructions for each sheet. Column entries in bold red indicate that the Company should enter only one of the possible entries listed for that column. No other entries should be entered. internet_tier0_subs Integer 10 video_internet_subs Integer 45 tripleplay_subs Integer 277 standalone_internet_subs Integer video_phone_subs Integer 18 For each month beginning June 2012 and extending through August 2015, please provide the data by zip code requested in the table below. Total number of subscribers in this zip code to the Company's Internet Access Service at advertised speeds strictly less than 3 Mbps downstream at the end of the month Total number of subscribers in this zip code to the Company's Internet Access Service at advertised speeds of greater than or equal to 3 Mbps downstream but strictly less than 10 Mbps downstream at the end of the month Total number of subscribers in this zip code to the Company's Internet Access Service at advertised speeds of greater than or equal to 10 Mbps downstream but strictly less than 25 Mbps downstream at the end of the month Total number of subscribers in this zip code to the Company 's Internet Access Service at advertised speeds of greater than or equal to 25 Mbps downstream but strictly less than 50 Mbps downstream at the end of the month Page 2 of 3 Column R S T "Subs Data" Table internet_tier5_subs Integer 10 internet_tier4_subs Integer 5 Total number of subscribers in this zip code to the Company 's Internet Access Service at advertised speeds of greater than or equal to 50 Mbps downstream but strictly less than 75 Mbps downstream at the end of the month Total number of subscribers in this zip code to the Company 's Internet Access Service at advertised speeds of greater than or equal to 75 Mbps downstream but strictly less than 100 Mbps downstream at the end of the month Total number of subscribers in this zip code to the Company 's Internet Access Service at advertised speeds of greater than or equal to 100 Mbps downstream at the end of the month Description For each month beginning June 2012 and extending through August 2015, please provide the data by zip code requested in the table below. Variable Name Format Possible Entries / internet_tier6_subs Integer 0 Page 3 of 3 date zip total_subs video_subs internet_subs phone_subs standalone_video_subs standalone_internet_subs standalone_phone_subs video_internet_subs video_phone_subs internet_phone_subs tripleplay_subs internet_tier0_subs internet_tier1_subs internet_tier2_subs internet_tier3_subs internet_tier4_subs internet_tier5_subs internet_tier6_subs 2012 20427 227 45 21 24 45 21 24 45 18 151 277 10 35 18 151 5 10 0 Subs Data Template Notes: Columns A through B define unique records in this data. Attachment C.1: Template for "Subs Data" Table For each month beginning June 2012 and extending through August 2015, please provide data by zip code requested in the table below.