Attachment B Format of Data 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. The required format for the entries in each column/field is indicated in the instructions for each sheet. All entries in Text fields must be in quotation marks (e.g. "AT&T", "Verizon Wireless", "US Cellular"). 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. Data for all of the tables should be submitted on a periodic basis as specified in the instructions in individual tables. "Cost Data" Instructions For each month beginning 01/2015 and extending through 06/2018, separately for the U.S., and Puerto Rico, and for each business segment in each region, please provide the requested cost data. 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. National levels for all cost estimates required. Additionally, provide cost estimates for the lowest subnational level for which each variable is kept. Note: "National" levels for all cost estimates required. Column Variable Name Format Possible Entries/Example Entries Description A date Text - YYYY_MM "2015_01" to "2018_06" The month for which the data is being collected. "Total", "Consumer Postpaid", "Consumer Prepaid", This field represents the business category for the relevant wireless service. The "Total" category B business_category Text "Wholesale Prepaid", "Wholesale Other" represents the total costs over all Company business categories. This field identifies the level for which the Company is reporting for the corresponding business category at "National", "NY CMA", "Midwest", "Northwest", "System C geographic_id Text the end of the month. Note: National levels for all cost estimates required. Additionally, provide cost 1", etc estimates for the lowest subnational level for which each variable is kept. This field identifies the total number of customers at the end of the month for the corresponding business D subs_total Number - Integer 24359, 31025, etc. (-1 if not applicable) category in this geography The total number of lines in the business category activated by the end of the month for the corresponding activations Number - Integer 5462 (-1 if not applicable) E business category in this geography Number - 2 decimal This field identifies total capital expenditures at the end this month for the corresponding business category F capex 1234.56 points in this geography. Number - 2 decimal This field identifies total other operating expenditures at the end of this month for the corresponding G opex 1234.56 points business category in this geography. Number - 2 decimal This field identifies the total cost of service at the end of this month for the corresponding business H service_cost 30.11 points category in this geography. Number - 2 decimal This field identifies the total cost of equipment sales at the end of this month for the corresponding business I equipment_cost 13.12 points category in this geography. Number - 2 decimal This field identifies the total selling, general, and administrative costs at the end of this month for the J admin_cost 5.87 points business category in this geography at the end of the month Number - 2 decimal This field identifies the total cost of depreciation at the end of this month for the corresponding business K depreciation_cost 4.44 points category in this geography. Number - 2 decimal This field identifies the total cost of amortization at the end of this month for the corresponding business L amortization_cost 4.44 points category in this geographyh. Number - 2 decimal This field identifies the total cost of retention credits at the end of this month for the corresponding M retention_costs 4.44 points business category in this geography. "Cost Data" Instructions For each month beginning 01/2015 and extending through 06/2018, separately for the U.S., and Puerto Rico, and for each business segment in each region, please provide the requested cost data. 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. National levels for all cost estimates required. Additionally, provide cost estimates for the lowest subnational level for which each variable is kept. Note: "National" levels for all cost estimates required. Column Variable Name Format Possible Entries/Example Entries Description Number - 2 decimal This field identifies the cost per gross activation for all activations at the end of this month for the N cpga 900.23 points corresponding business category in this geography. Number - 2 decimal This field identifies the portion of the cost per gross activation attributable to advertising or marketing costs O advertising_cpga 900.23 points for all activations at the end of this month for the corresponding business category in this geography. Number - 2 decimal This field identifies the portion of the cost per gross activation attributable to handset or accessory subsidy P handset_cpga 900.23 points costs for all activations at the end of this month for the corresponding business category in this geography. This field identifies the portion of the cost per gross activation attributable to selling, general and Number - 2 decimal Q selling_cpga 900.23 adminstrative costs for all activations at the end of this month for the corresponding business category in points this geography. Number - 2 decimal This field identifies the average cash cost per user (exclusive of CPGA) at the end of this month for the R average_ccpu 23.45 points corresponding business category in this geography. Number - 2 decimal This field identifies the weighted average cost of capital at the end of this month for the corresponding S cost_of_capital 23.45 points business category in this geography. Number - 2 decimal This field identifies the total lease costs for the Company's macro, distributed antenna system, and small T site_lease_costs 23.45 points cell sites at the end of this month for the corresponding business category in this geography. This field identifies the number of the Company's macro, distributed antenna system, and small cell sites at U leased_towers Number - Integer 50033 the end of this month for the corresponding business category in this geography and month. Number - 2 decimal This field identifies the total costs incurred by the Company for roaming at the end of this month for the V roaming_costs 19300.23 points corresponding business category in this geography. Number - 2 decimal This field identifies the average cost per call to the Company's customer service calls centers in this W call_center_cost 1.45 points geography and month. Number - 2 decimal This field identifies the total number of calls to the Company's customer service calls centers in this X call_center_calls 80459 points geography and month. date business_category geographic_id subs_total activations capex opex service_cost equipment_cost admin_cost depreciation_cost amortization_cost Cost Data Template cost_of_capit retention_costs cpga advertising_cpga handset_cpga selling_cpga average_ccpu site_lease_costs leased_towers roaming_costs call_center_cost call_center_calls al "Service Plan Data" Instructions For each month beginning 01/2015 and extending through 06/2018 , please provide by county or county-equivalent the following billing system data. The sheets in the workbook provide a template for how the tables should be designed. 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. The subscriber's billing zip code shall be used when determining the geographic area in which the subscriber resides for customers. If the billing zip code is not known, the NPA-NXX shall be used instead. Column Variable Name Format Possible Entries/Example Entries Description A date Text - YYYY_MM 2015_01 to 2018_06 The month for which the data is being collected. 2010 Five-digit Federal Information Processing Standards (FIPS) code with leading zeroes which uniquely B county_fips Text "01001", "56045" identifies counties and county-equivalents in the United States and Commonwealth of Puero Rico C state_code Text "AL", "WY" State Postal Code D county_name Text "Autauga", "Weston" County name or Legal/Statistical Area Description "Consumer Mobile Postpaid", "Consumer Mobile Prepaid", "Consumer Mobile Broadband-Only", The plan subscriber type. Note: Include individual consumer and small business subscribers but not MVNO, E plan_type Text "Fixed Wireless Service", "Consumer Other" M2M or enterprise customers in any calculations or plan definitions. This field denotes the brand offered for the corresponding device category within each customer category for F brand_category Text "AT&T, "Verizon" the corresponding customer category in this county G plan_name Text "Mobile Share Flex", "Beyond Unlimited" etc. The name or description of the plan as used in the billing system. H plan_years Text 2009_01 - 2015_06 The date range for when this plan was available to new subscribers. "'AX124DKSD87", "BD124DKSD87+DATA50", plan_id Text This field denotes a unique code or name for the plan as identified in the billing system. I "Unlimited Talk and Text", "1" J voice_id Text "Family and Friends 1000" This field denotes a unique code or name for the voice plan as identified in the billing system. K data_id Text "5GB plus Hotspot" This field denotes a unique code or name for the data plan as identified in the billing system. L text_id Text "AGJHD673" This field denotes a unique code or name for the text plan as identified in the billing system. M minutes_any Number 1000 The number of anytime minutes included in the plan. If unlimited code as -99999. If no minutes, code as 0. The number of any other national calling minutes included in the plan other than anytime minutes. If unlimited N minutes_other Number 2500 code as -99999. If no other minutes, code as 0. The number of megabytes the account may use before the data consequence applies. Do not include hotspot data in this field. Code as -3 if there is no data consequence at any usage amount or for plans with no limit O data_amount Number 2000 that reduce speeds during congestion (data consequence = 2). If no data, code as 0. For plans that slow the speed of service when the data cap is reached, record  1 . For plans that charge a fee for additional data when the data cap is reached, record  2 . For plans that reduce speeds during any periods of congestion regardless of data used, record  3 . For any other types of consequences (e.g. a choice of consequence) for reaching the data cap, record  4 . If the plan has multiple thresholds at which a consequence applies, record the consequence of the first data cap (e.g. after surpassing the 10 GB data cap, P data_consequence Text "1", "2", "3", "4" the customer is slowed down, but after using another 5 GB there is an overage; record as  1 ). Whether subscribers of the plan have limited network speeds on the network at all times regardless of Q speed_limited Text "Y" or "N" congestion (e.g. some prepaid plans). R rollover Text "Y" or "N" Whether any usage allowances on the plan can be carried over into the next billing cycle The number of text messages included in the plan (if any). If unlimited code as -99999. If no plan, code as S texts Number 1000 zero. T family_plan Text "Y" or "N" Whether the data, voice minutes or text allowances can be shared across multiple lines on the account. U streaming Text "Y" or "N" Whether the plan includes a streaming service subscription The name or description of the streaming service included. If multiple services code as "Netflix+Unlimited V streaming_name Text "Netflix", "Unlimited Music", "HBO Now", etc. Music" W video_resolution Text "480P" (-1 if not applicable) The maximum video resolution quality for streaming video on the plan. If not applicable code as -1. "Service Plan Data" Instructions For each month beginning 01/2015 and extending through 06/2018 , please provide by county or county-equivalent the following billing system data. The sheets in the workbook provide a template for how the tables should be designed. 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. The subscriber's billing zip code shall be used when determining the geographic area in which the subscriber resides for customers. If the billing zip code is not known, the NPA-NXX shall be used instead. Column Variable Name Format Possible Entries/Example Entries Description X hotspot Text "Y" or "N" Whether the plan allows tethering or for the mobile device to serve as a hotspot for other devices. The number of megabytes of hotspot data included that are distinct from the data allowance recorded in the Y hotspot_amount Number 2500 data amount field. If no limit, code as -99999. If no hotspot data, code as 0. The number of megabytes of international data included in the plan (if any). If unlimited code as -99999. If Z international_data Number 200 none, code as 0. The number of international anytime minutes included in the plan (if any). If unlimited code as -99999. If none, AA international_voice Number 200 code as 0. AB national Text "Y" or "N" Whether the service plan's home calling area is national or regional AC autopay_discount Text "Y" or "N" Whether the service plan includes an autopay discount AD handset_subsidy Text "Y" or "N" Whether the service plan includes a handset subsidy in the monthly recurring access charge for the plan The monthly recurring access charge for the plan. This amount should include all recurring charges for any AE voice, data, texting and other features that compose the plan. Equipment charges whether leased or bundled charge_prime_access Number 49.99 in the plan (e.g. "classic plans") should not be included. The total number of lines that could be added to the account for the monthly recurring acces charge at no AF access_lines Number 2 additional charge. AG add_access Number 21.5 The monthly access charge per additional line above the number of access lines in the previous field AH The per MB overage rate for data in excess of the amount of data listed in the data amount field. Pay-per-use over_data Number 0.1 plans should be coded as zero data included and then have the per-use data charge listed here. The per minute overage rate for voice in excess of the number of minutes listed in the anytime minutes field. AI Pay-per-use plans should be coded as zero anytime minutes and then have the per-minute voice charge listed over_voice Number 0.1 here. The per text overage rate for texts in excess of the number of texts listed in the texts field. Pay-per-use plans AJ over_text Number 0.1 should be coded as zero texts included and then have the per-use text charge listed here. total_subs Number - Integer 24359, 31025, etc. (-1 if not applicable) This field identifies the total number of subscribers (lines) at the end of the month for this plan in the county. AK The number of lines per account on the plan for this plan in the month and county. Note: Each possible AL line_count "1", "2", "3", "4", "5+" service plan and number of lines pair (e.g. "T-Mobile One Unlimited 55+" and "2", "T-Mobile One Unlimited Text 55+" and "3") should be entered on a separate row. The average number of lines per account on the plan for this plan in the month and county. Total subscribers Number - 2 AM avg_lines 2, 5.31 divided by average lines should provide the total number of plan accounts. Note: If the entry for variable decimal points "line_count" equals 1, 2, 3, or 4, then variable "line_count" should equal to variable "avg_lines". This field identifies the total number of deactivations, defined as Company subscribers at the end of the total_deactivate Number - Integer previous month who are no longer Company subscribers at the end of the current month for this plan in the AN 2435, 12102, etc. (-1 if not applicable) county. This does not include subscribers that switched plans within the Company in the month. This field identifies the total number of activations, defined as subscribers to the plan at the end of the month AO total_activate Number - Integer who were not Company subscribers at the beginning of the month, for this plan in the county. This does not 2435, 12102, etc. (-1 if not applicable) include subscribers that switched plans within the Company in the month. The number of subscribers to the plan at the end of the previous month who switched to another plan with the AP total_switch_out Number - Integer 2435, 12102, etc. (-1 if not applicable) Company by the end of the current month in the county The number of subscribers to the plan at the end of the current month who switched from another plan with AQ total_switch_in Number - Integer 2435, 12102, etc. (-1 if not applicable) the Company from the beginning of the previous month. "Service Plan Data" Instructions For each month beginning 01/2015 and extending through 06/2018 , please provide by county or county-equivalent the following billing system data. The sheets in the workbook provide a template for how the tables should be designed. 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. The subscriber's billing zip code shall be used when determining the geographic area in which the subscriber resides for customers. If the billing zip code is not known, the NPA-NXX shall be used instead. Column Variable Name Format Possible Entries/Example Entries Description Number - 2 The average service revenue (excluding equipment revenues from either monthly leases or bundled fees) per service_rev 43.84 AR decimal points account for the plan Number - 2 This field indicates the average nonrecurring revenue per account in the for the plan in the month. This should nonrecurring_rev 13.84 decimal points include revenues from overages, activation fees and other one-payments (but not any equipment revenues) AS Number - 2 The average equipment revenues per account from equipment installment plans or bundled fees for the plan AT equipment_rev 6.84 decimal points in the month and county. Number - 2 The average revenue per account for customers that deactivated service in the month for the plan in the deactive_rev 43.84 AU decimal points county Number - 2 The average revenue per account for customers that activated their service in the month for the plan in the active_rev 43.84 AV decimal points county Number - 2 AW data_share decimal points 0.65 Share of average revenue per account derived from data for this plan in the month and county. Number - 2 AX voice_share decimal points 0.21 Share of average revenue per account derived from voice minutes for this plan in the month and county. Number - 2 AY text_share decimal points 0.11 Share of average revenue per account derived from texting for this plan in the month and county. Share of subscribers whose service (line or advanced device) is subject to any penalty were the subscriber to Number - 2 deactivate service with the Company for this plan in the month and county. This may include a penalty decimal points AZ penalty_share 0.12 resulting from a separate device contract. Number - 2 The average penalty amount for those subscribers that would face a penalty for deactivation for this plan in BA average_penalty decimal points 123.24 the month and county. Number - 2 BB average_mou decimal points 1240 The average minutes of use per account for this plan in the month and county. Number - 2 BC average_texts decimal points 685.00 The average number of text messages per account for this plan in the month and county. Number - 2 BD average_data_mb decimal points 52.65 The average data usage per account in Megabytes for this plan in the month and county. Number - 2 usage_5p BE decimal points 200.00 The 5th percentile of the data usage distribution in Megabytes for this plan in the month and county. Number - 2 usage_25p BF decimal points 1024.00 The 25th percentile of the data usage distribution in Megabytes for this plan in the month and county. Number - 2 The 50th percentile (median) of the data usage distribution in Megabytes for this plan in the month and usage_50p BG decimal points 2450.00 county. Number - 2 usage_75p BH decimal points 4025.00 The 75th percentile of the data usage distribution in Megabytes for this plan in the month and county. Number - 2 usage_90p BI decimal points 90000.00 The 90th percentile of the data usage distribution in Megabytes for this plan in the month and county. date county_fips state_code county_name plan_type brand_category plan_name plan_years plan_id voice_id data_id text_id Service Plan Data Template data_consequenc minutes_any min_other data_amount speed_limited rollover texts family_plan streaming streaming_name video_resolution hotspot e international_ autopay_disc handset_subs charge_prime_acc hotspot_amount international_data national access_lines add_access over_data over_voice over_text total_subs voice ount idy ess line_count avg_lines total_deactivate total_activate total_switch_out total_switch_in service_rev nonrecurring_rev equipment_rev deactive_rev active_rev data_share voice_share text_share penalty_share average_penalty average_mou average_texts average_data_gb usage_5p usage_25p usage_50p usage_75p usage_90p "Customer Data" Instructions For each month beginning 01/2015 and extending through 06/2018, and for each county and county-equivalent, please provide the customer and device category level data for each affiliated brand of the Company. 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. The subscriber's billing zip code shall be used when determining the geographic area in which the subscriber resides If the billing zip code is not known, the NPA-NXX shall be used instead. Note: the "Any Mobile", "Mobile Phone", "Mobile Data Device", "Fixed Wireless Service" and "Other Connected Services" device categories correspond to the "Consumer Postpaid", "Consumer Prepaid", and "Lifeline" customer categories. "Push to Talk (Enterprise)", "IoT Devices/M2M (Enterprise)", and the "Other (Enterprise)" device categories correspond to the "Enterprise", "Employee-Paid Enterprise", and "Other (Enterprise)" customer categories. Note: Enterprise customers restricted to entities with 20 lines or more. Column Variable Name Format Possible Entries/Example Entries Description A date Text - YYYY_MM "2015_01" to "2018_06" The month for which the data is being collected. Five-digit Federal Information Processing Standards (FIPS) code with leading zeroes which uniquely B county_fips Text "01001", "56045" identifies counties and county-equivalent in the United States and Commonwealth of Puero Rico C state_code Text "AL", "WY" State Postal Code D county_name Text "Autauga", "Weston" County name or Legal/Statistical Area Description "Consumer Postpaid", "Consumer Prepaid", E customer_category Text "Lifeline", "Enterprise", "Employee-Paid Enterprise", This field represents the customer category for the relevant wireless service "Other (Enterprise)" This field denotes type of device category for the corresponding customer and brand category in this "Any Mobile Device", "Mobile Phone", "Mobile Data county. Note, the "Any Mobile Device", "Mobile Phone", "Mobile Data Device", "Fixed Wireless Device", "Fixed Wireless Service", "Other Connected Service" and "Other Connected Services" device categories correspond to the "Consumer Postpaid", F device_category Text Services", "Push to Talk (Enterprise)" "IoT "Consumer Prepaid", and "Lifeline" customer categories. "Push to Talk (Enterprise)", "IoT Devices/M2M (Enterprise) , "Other (Enterprise)" Devices/M2M (Enterprise)", and the "Other (Enterprise)" device categories correspond to the "Enterprise", "Employee-Paid Enterprise", and "Other (Enterprise)" customer categories This field denotes the brand offered for the corresponding device category within each customer category in G brand_category Text "AT&T", "Cricket", "Verizon" this county This field identifies the total number of subscribers at the end of the month for the corresponding customer, H subs_total Number - Integer 24359, 31025, etc. (-1 if not applicable) device, and brand category in this county This field identifies the total number of subscribers at the end of the month with voice, data and texing I subs_voice_data_text Number - Integer 24359, 31025, etc. (-1 if not applicable) service for the corresponding customer, device, and brand category in this county This field identifies the total number of subscribers at the end of the month with voice and texting service J subs_voice_text Number - Integer 24359, 31025, etc. (-1 if not applicable) for the corresponding customer, device, and brand category in this county This field identifies the total number of subscribers at the end of the month with voice and data service for K subs_voice_data Number - Integer 24359, 31025, etc. (-1 if not applicable) the corresponding customer, device, and brand category in this county This field identifies the total number of subscribers at the end of the month with voice-only service for the subs_voice_only Number - Integer 24359, 31025, etc. (-1 if not applicable) L corresponding customer, device, and brand category in this county This field identifies the total number of subscribers at the end of the month with data-only service for the subs_data_only Number - Integer 24359, 31025, etc. (-1 if not applicable) M corresponding customer, device, and brand category in this county This field identifies the average number of corresponding device category lines for the account at the end of average_lines Number - Integer 24359, 31025, etc. (-1 if not applicable) N the month for the customer and brand category in this county This field identifies the voice minutes per account for this device category at the end of the month for the O average_mou Number - Integer 2054.55, etc. (-1 if not applicable) corresponding customer and brand category in this county This field identifies the average number of text messages per account for this device category at the end of P average_texts Number - Integer 1265.32, etc. (-1 if not applicable) the month for the corresponding customer and brand category in this county Number - 2 decimal Average amount of data usage per account (in Megabytes) for this device category in this month for the Q average_data 200.34 (-1 if not applicable) points correponding customer and brand category in this county Number - 2 decimal Amount of data usage per user (in Megabytes) for this device category at the 5th percentile in this month R usage_5p 19.99 (-1 if not applicable) points for the correponding customer and brand category in this county Number - 2 decimal Amount of data usage per user (in Megabytes) for this device category at the 25th percentile in this month S usage_25p 19.99 (-1 if not applicable) points for the correponding customer and brand category in this county Number - 2 decimal Amount of data usage per user (in Megabytes) for this device category at the 50th percentile in this month T usage_50p 69.99 (-1 if not applicable) points for the correponding customer and brand category in this county Number - 2 decimal Amount of device-specific data usage per user (in Megabytes) for this device category at the 75th U usage_75p 89.99 (-1 if not applicable) points percentile in this month for the correponding customer and brand category in this county Number - 2 decimal Amount of device-specific data usage per user (in Megabytes) forthis device category at the 90th percentile V usage_90p 1999.99 (-1 if not applicable) points in this month for the correponding customer, device, and brand category in this county Number - 2 decimal This field indicates the average revenue for this device category per account in the corresponding customer W arpa 43.84 points and brand category in the month "Customer Data" Instructions For each month beginning 01/2015 and extending through 06/2018, and for each county and county-equivalent, please provide the customer and device category level data for each affiliated brand of the Company. 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. The subscriber's billing zip code shall be used when determining the geographic area in which the subscriber resides If the billing zip code is not known, the NPA-NXX shall be used instead. Note: the "Any Mobile", "Mobile Phone", "Mobile Data Device", "Fixed Wireless Service" and "Other Connected Services" device categories correspond to the "Consumer Postpaid", "Consumer Prepaid", and "Lifeline" customer categories. "Push to Talk (Enterprise)", "IoT Devices/M2M (Enterprise)", and the "Other (Enterprise)" device categories correspond to the "Enterprise", "Employee-Paid Enterprise", and "Other (Enterprise)" customer categories. Note: Enterprise customers restricted to entities with 20 lines or more. Column Variable Name Format Possible Entries/Example Entries Description This field indicates the average nonrecurring revenue for this device category per account in the Number - 2 decimal corresponding customer and brand category in the month. This should include revenues from overages, X arpa_nonrecurring 43.84 points activation fees and other one-payments (but not from equipment installment plans or bundled equipment charges) This field indicates the average equipment revenue (e.g. equipment installment plans and equipment Number - 2 decimal Y arpa_equipment 31.83 charges associated with "classic" plans that bundle equipment charges into the price) for this device points category per account in the corresponding customer and brand category in the month Number - 2 decimal This field indicates the average revenuefor this device category per account accruing from any other Z arpa_other 11.84 points charges in the corresponding customer and brand category in the month. Number - 2 decimal This field indicates the total promotional credits, including waived activation fees, per account for this AA promotional_credits 12.01 points device category across all customers in the corresponding customer and brand category in the month Number - 2 decimal This field indicates the percentage of customers for this device category in the corresponding customer and AB percent_gsm 16.38 (-1 if not applicable) points brand category in the month with a device that is max GSM capable Number - 2 decimal This field indicates the percentage of customers for this device category in the corresponding customer and AC percent_cdma 16.38 (-1 if not applicable) points brand category in the month with a device that is max CDMA capable Number - 2 decimal This field indicates the percentage of customers for this device category in the corresponding customer and AD percent_evdo 16.38 ( -1 if not applicable) points brand category in the month with a device that is max EVDO capable Number - 2 decimal This field indicates the percentage of customers for this device category in the corresponding customer and AE percent_hspa 16.38 ( -1 if not applicable) points brand category in the month with a device that is max HSPA capable Number - 2 decimal This field indicates the percentage of customers for this device category in the corresponding customer and AF percent_hspaplus 16.38 ( -1 if not applicable) points brand category in the month with a device that is max HSPA+ capable Number - 2 decimal This field indicates the percentage of customers for this device category in the corresponding customer and AG percent_lte 16.38 ( -1 if not applicable) points brand category in the month with a device that is max LTE capable Number - 2 decimal This field indicates the percentage of customers for this device category in the corresponding customer and AH percent_other 1.68 ( -1 if not applicable) points brand category in the month with a device not defined in columns AB through AG This field identifies the total number of activations for this device category at the end of the month for the AI activate_total Number - Integer 2435, 12102, etc. ( -1 if not applicable) corresponding customer and brand category in this county This field identifies the total number of deactivations afor this device category at the end of the month for AJ deactivate_total Number - Integer 2435, 12102, etc. ( -1 if not applicable) the corresponding customer and brand category in this county Number - 2 decimal This field identifies the percentage of customers for this device category who have deactivated service at AK churn 1.85 points the end of the month for the corresponding customer and brand category in this county customer_categor subs_voice_data_ date county_fips state_code county_name device_category brand_category subs_total subs_voice_text subs_voice_data subs_voice_only y text Customer Data Template subs_data_only average_lines average_mou average_texts average_data usage_5p usage_25p usage_50p usage_75p usage_90p arpa arpa_nonrecurring arpa_equipment arpa_other promotional_credits percent_gsm percent_cdma percent_evdo percent_hspa percent_hspaplus percent_lte percent_other activate_total deactivate_total churn "Wholesale Data" Instructions For each month beginning 01/2015 and extending through 06/2018, and for each county and county-equivalent, please provide the followng data on wholesale sales to unaffiliated companies The sheets in the workbook provide a template for how the tables should be designed. 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. The subscriber's billing zip code shall be used when determining the geographic area in which the subscriber resides. If the billing zip code is not known for Consumer Prepaid Customers, the NPA-NXX shall be used instead. Column Variable Name Format Possible Entries/Example Entries Description A date Text - YYYY_MM "2015_01" to "2018_06" The month for which the data is being collected. Five-digit Federal Information Processing Standards (FIPS) code with leading zeroes which uniquely B county_fips Text "01001", "56045" identifies counties and county-equivalent in the United States and Commonwealth of Puero Rico C state_code Text "AL", "WY" State Postal Code D county_name Text "Autauga", "Weston" County name or Legal/Statistical Area Description "MVNO", "IoT Device Sales/M2M", This field denotes type of device category for each customer category for the corresponding brand category E device_category Text "Other Connected Devices" in this county This field denotes the brand offered for the corresponding device category within each customer category for F brand_category Text "Project Fi" the corresponding customer category in this county 24359, 31025, etc. (-1 if not This field identifies the total number of subscribers at the end of the month for the corresponding device and G subs_total Number - Integer applicable) brand category in this county Number - 2 decimal This field identifies the average voice minutes per account at the end of the month for the corresponding average_mou 2054.55, etc. (-1 if not applicable) H points device and brand category in this county Number - 2 decimal This field identifies the average number of text messages per account at the end of the month for the average_texts 1265.32, etc. (-1 if not applicable) I points corresponding device and brand category in this county Number - 2 decimal Average amount of data usage per account (in Megabytes) inclusive of text usage in this month for the J average_data 10003.34 (-1 if not applicable) points corresponding device and brand category in this county Number - 2 decimal Average amount of data usage per account (in Megabytes) exclusive of text usage in this month for the K average_data_notext 10003.34 (-1 if not applicable) points corresponding device and brand category in this county Number - 2 decimal L total_revenue 1048994.54 This field indicates the total revenue billed to the device and brand category in the month points Number - 2 decimal This field indicates the percentage of customers in the corresponding device and brand category in the M percent_gsm 16.38 (-1 if not applicable) points month with a device that is max GSM capable Number - 2 decimal This field indicates the percentage of customers in the corresponding device and brand category in the N percent_cdma 16.38 (-1 if not applicable) points month with a device that is max CDMA capable Number - 2 decimal This field indicates the percentage of customers in the corresponding device and brand category in the O percent_evdo 16.38 (-1 if not applicable) points month with a device that is max EVDO capable Number - 2 decimal This field indicates the percentage of customers in the corresponding device and brand category in the P percent_hspa 16.38 (-1 if not applicable) points month with a device that is max HSPA capable Number - 2 decimal This field indicates the percentage of customers in the corresponding device and brand category in the Q percent_hspaplus 16.38 (-1 if not applicable) points month with a device that is max HSPA+ capable Number - 2 decimal This field indicates the percentage of customers in the corresponding device and brand category in the R percent_lte 16.38 (-1 if not applicable) points month with a device that is max LTE capable Number - 2 decimal This field indicates the percentage of customers in the corresponding device and brand category in the S percent_other 1.68 ( -1 if not applicable) points month with a device not defined in columns M through R This field identifies the total number of activations at the end of the month for the corresponding device and T total_activate Number - Integer 2435, 12102, etc. (-1 if not applicable) brand category in this county This field identifies the total number of deactivations at the end of the month for the corresponding device U total_deactivate Number - Integer 2435, 12102, etc. (-1 if not applicable) and brand category in this county average_data_note date county_fips state_code county_name device_category brand_category subs_total average_mou average_texts average_data xt Wholesale Data Template total_revenue percent_gsm percent_cdma percent_evdo percent_hspa percent_hspaplus percent_lte percent_other total_activate total_deactivate "Porting Data" Instructions For each month beginning 01/2015 and extending through 06/2018, and for each county and county-equivalent, please provide by county or county-equivalent the ports out data. The sheets in the workbook provide a template for how the tables should be designed. 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. The subscriber's billing zip code shall be used when determining the geographic area in which the subscriber resides. If the billing zip code is not known for Consumer Prepaid Customers, the NPA-NXX shall be used instead. Note: Enterprise customers restricted to entities with 20 lines or more. Column Variable Name Format Possible Entries/Example Entries Description A date Text - YYYY_MM "2015_01" to "2018_06" The month for which the data is being collected. Five-digit Federal Information Processing Standards (FIPS) code with leading zeroes which B county_fips Text "01001", "56045" uniquely identifies counties and county-equivalent in the United States and Commonwealth of Puero Rico C state_code Text "AL", "WY" State Postal Code D county_name Text "Autauga", "Weston" County name or Legal/Statistical Area Description E ports_to Text "T-Mobile", "MetroPCS", etc. The name of the competing service provider to which the Company's subscribers ported. F ports_out_total Text 20000 The total number of subscribers who ported from the Company. G postpaid_ports_out Number - Integer 5000 The number of postpaid subscribers who ported from the Company. H prepaid_ports_out Number - Integer 5000 The number of prepaid subscribers who ported from the Company. I wholesale_ports_out Number - Integer 5000 The number of wholesale subscribers who ported from the Company. J enterprise_ports_out Number - Integer 5000 The number of enterprise subscribers who ported from the Company. K ports_from Text "AT&T", "MetroPCS", etc. The name of the competing service provider whose subscribers ported to the Company. L ports_in_total Text 20000 The total number of subscribers who ported in to the Company. M postpaid_ports_in Number - Integer 5000 The number of subscribers who ported in order to become postpaid subscribers of the Company. N prepaid_ports_in Number - Integer 5000 The number of subscribers who ported in order to become prepaid subscribers of the Company. O wholesale_ports_in Number - Integer 5000 The number of subscribers who ported in order to become wholesale subscribers of the Company. P enterprise_ports_in Number - Integer 5000 The number of subscribers who ported in order to become enterprise subscribers of the Company. date county_fips state_code county_name ports_to ports_out_total postpaid_ports_out prepaid_ports_out wholesale_ports_out Porting Data Template enterprise_ports_out ports_from ports_in_total postpaid_ports_in prepaid_ports_in wholesale_ports_in enterprise_ports_in "Device Leases and Sales" Instructions For each month beginning 01/2015 and extending through 06/2018, and for each county and county-equivalent, please provide the following device sales data by device category and sales channel. The sheets in the workbook provide a template for how the tables should be designed. 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. A unique observation in this data is determined by columns A through I. The subscriber's billing zip code shall be used when determining the geographic area in which the subscriber resides. If the billing zip code is not known, the NPA-NXX shall be used instead. Please also provide a TAC database with the characteristics of each handset corresponding to each TAC code. Column Variable Name Format Possible Entries/Example Entries Description A date Text - YYYY_MM 2015_01 to 2018_06 The month for which the data is being collected. Five-digit Federal Information Processing Standards (FIPS) code with leading zeroes which uniquely B county_fips Text "01001", "56045" identifies counties and county-equivalent in the United States and Commonwealth of Puero Rico C state_code Text "AL", "WY" State Postal Code D county_name Text "Autauga", "Weston" County name or Legal/Statistical Area Description "Mobile Phone", "Mobile Data Device", "Other E device_category Text This field denotes type of device category for each sales channel in this county Connected Devices" F sales_channel Text "Website", "Company Owned Store" This field denotes the sales channel used to purchase the device category in this county G sales_type "Sale", "Lease" Whether this data record corresponds to device sales or device leases in the month, county H device_manufacturer Text "Apple", "Samsung" This field identifies the manufacturer of the device I sku Text "6009664", "MK1000" This field identifies the unique model number or SKU for the device J tac Text "01233600" The type allocation code (TAC) for this device K introduction_date Text - YYYY_MM "2012_01" This field identifies the date that the Company first began selling this device This field identifies the total quantity of this device that was sold in this month, sales channel and county L quantity Number - Integer 543 (Note: Do not include returns in the field) M returns Number - Integer 123 This field identifies the number of returns of this device in this month, sales channel and county This field identifies the total revenues for this device in this month, sales channel and county (Note: Do not N revenues Number - Integer 62459 include return revenues in this field) Negative Number - return_revenues -5115.02 This field identifies the total revenues for this device in this month, sales channel and county O 2 decimal points Number - 2 decimal price 115.02 This field identifies the average price paid for this device in this month, sales channel and county P points Number - 2 decimal wholesale_price 234.43 This field identifies the wholesale price the Company paid for this device in this month Q points R promotion Number - Integer 0, 1 An indicator for whether this device was under a promotion in this month, sales channel and county date county_fips state_code county_name device_category sales_channel sales_type device_manufacturer sku Device Sales Data Template tac introduction_date quantity returns revenues return_revenues price wholesale_price promotion