1

DIVCA 2011 Video Franchise Holder Webinar

Video Franchising and Broadband Deployment Team

February 25, 2011

2

Agenda

Welcome! Data to Submit to CPUC on or before April 1, 2011 Other Reports due to CPUC on or before April 1, 2011 Broadband Subscriber data Broadband Availability Data (same process as last

Year) Third Collection of Broadband Availability Data for

NTIA’s SBDD (Mapping) Program Video template for video annual report data Annual Fee for Fiscal Year 2010-2011 Website for Video Franchise & Broadband Deployment

Team Questions / Other Issues

3

Data to Submit to CPUC by April 1, 2011

Broadband Subscriber DataCalifornia portion of Form 477 Data

Same data due to the FCC by March 1, 2011 used for reporting broadband subscribers by census tract, speed tiers and technologies

Broadband Availability dataWe are assuming that you have already submitted

the Broadband Availability Data by census tract Video Subscriber Data by census tract Video Availability Data by census tract

4

Other Reports due on or before April 1, 2010

Annual Employment Report Workplace Diversity Report Collective Bargaining Free Services Provided to Community

Centers Annual Fee Due by April 30, 2011

Fee statements are in the process of being sent out. You should receive yours soon.

5

Broadband Data

Broadband Subscriber DataUse the FCC’s 477 format that you use to submit

data to the FCCDetails in next few slidesNew process if you manually enter information

into FCC website. Broadband Availability Data

This year, broadband availability data is being collected via the State Broadband Data and Development (mapping) Program.

6

Broadband Subscriber Data Details

If you manually enter information into the FCC’s 477 website, you can submit that data via either:Excel Spreadsheet Comma delimited text file.

In the past, we only accepted comma delimited text files.

If you send your 477 data to The FCC in a comma delimited text file, you can send it to us the same way.

7

Operational Issues We had Last YearThat we’d like your Help Solving (1 of 2)

Census tract numbers According to the FCC’s directions for submitting 477 data,

census tract numbers are defined as: A number up to 4 digits Followed by a decimal Followed by a number up to 2 digits.

For each census tract number you provide data about, please be sure to include a decimal point and to the right of the decimal either two numbers or two zeros.

Excel Spreadsheets - Video data Please do NOT submit cells with formulas.

Formulas do not upload into our Oracle database. In each cell that contains numbers created by formulas, please type

in an actual number (or use an Excel function to convert the number created by a formula into an actual number).

8

Operational Issues We had Last YearThat we’d like your Help Solving (2 of 2)

Percent Residential Connections If you have no residential connections in a census

tract, please enter zero. Technology Code “Other”

Sixth place in comma delimited text file. Please include commas with no data between them if

you are meaning to leave that empty.

9

Positions for data in FCC 477 Comma Delimited Text File Format (1 of 2)

10

BB Subscribers Use FCC 477 FormatTemplate Details: Comma Delimited Text File Format

OR Spreadsheet if you enter it manually

11

Positions for data in FCC 477 Comma Delimited Text File Format (2 of 2)

12

Codes for FCC 477 FormatTechnology Used to Deploy Broadband

13

Codes for FCC 477 Format Upload & Download Rates

14

Broadband Availability Data Reporting Process Same as Last Year

Like last year, broadband availability data is being collected via the State Broadband Data and Development (mapping) Program.

To make life easier for you… Your organization will again NOT be required to report Broadband Availability data under DIVCA, if it has fully and properly submitted “third round” broadband availability data to the CPUC for the NTIA’s State Data and Development Program.

If your organization did not do that, please submit broadband availability data per the “third round” CPUC broadband mapping data request now.

15

DIVCA Video Excel Template for Annual Report

Video related data only in Excel Spreadsheet Broadband data is handled separately, as we

just discussed. As a result, last year the column for

broadband availability data was removed. It remains removed.

16

DIVCA (Video Template) Important Excel Worksheets (Tabs) in Excel Workbook

State Franchise Enter data for video service provided under state

franchise ONE franchise per State Franchise tab Most of you have just one state franchise

Local Franchises Enter data for video service provided under all local

franchises Telephone Service Area

Enter data for video service provided in the telephone service area.

17

18

DIVCA Video Excel Template (1 of 2)

Parent Company Name Franchise Number Application Number Consultant Name

Parent Company Name

FranchiseNumber

ApplicationNumber Consultant Name

       

U.S. Census Bureau Census Tract Aggregate Flag Aggregate Crossover Flag

Summed Households of Census Block Nodes contained Within Alternate

Geospatial Area

Census Tract Number

AggregateFlag

AggregateCrossover Flag

Summed HouseholdsCensus Block Node

19

Revised DIVCA Annual Report Video Excel Template (2 of 2)

Total Numberof Households

Number of LowIncome Households

Number of Households Offered Video

Service by Holder

Number of Low Income Households Offered

Video Service by Holder

Number of Households Subscribing to Video Service Offered by

Holder

Total # House- holds

# Low Income Households

# Households to Which Video

is Offered

# Low Income Households

to Which Video is Offered

# Households that Subscribe to Video

20

FCC Instructions Website

http://www.fcc.gov/Forms/Form477/477inst.pdf

http://www.fcc.gov/Forms/Form477/477screen-shots.pdf

21

User Fees for Fiscal Year 2009-2010

Resolution T-17305 User Fee based on households in holders’ video service

territories, rather than according to revenues, through Fiscal Year 2012-2013.

Rate set at from $0.0417 per household for FY 2010-2011, down from $0.0434 per household for FY 2009-2010

User Fee due on April 30, 2011 for franchises issued before Resolution (2/24/11). For franchises issued after 2/24/11, user fee due

within 60 days after franchise is issued.

22

User Fee Statements / Invoices

Statements are in the process of being prepared.

Please make checks payable to:"CPUC-VSP"

Please fill out and attach a copy of the fee statement to the check and mail to:

Attn: Carmelita Reyes Fiscal Office, Room 3000 California Public Utilities Commission 505 Van Ness Avenue San Francisco, CA 94102

23

Website for Video Franchise & Broadband Deployment Team

Shown on next several slides.

24

From here there are two easy ways to access the Video Franchise main page: 1. Click the For Service Providers tab, then click the Video Franchising link. OR …

25

How to access the Video Franchising website: Go to www.cpuc.ca.gov and click on the Communications tab.

26

2. Scroll down the page until you see the Service Provider Programs and Information subheading, then click the Video Franchising link.

27

Video Franchising Main Page: Scroll down the page for various information pertaining to Video Franchising. Clicking on any of the four top links will put you to the bottom half

of the page for quick access to Applications, Franchises, and Reporting information.

28

Bottom half of main page: From here you can navigate to the desired document or page (i.e. Franchises Issued in 2007).

29

Return to the Video Franchise main page by using the browser back button or clicking the Back to Video Franchise Main Page link.

30

New Franchise Holders beginning April 2008

You need to be on the service list to receive mailings on DIVCA matters

Email processoffice@cpuc.ca.gov, provide name, contact information, and request to be added to the service list for R 06-10-005

31

Questions / Other IssuesThanks for Tuning Into This Webinar!

Michael Morris, Program and Project Supervisor mmo@cpuc.ca.gov

Michael Pierce, Sr. Analyst mbp@cpuc.ca.gov (415) 703-2618