NBNco accidentally leaks full list of FSAMs to Interwebs

Well, it has been an interesting couple of hours. I’ve been pretty quiet on the NBN front in the last couple of weeks as work has been rather busy, but this deserves a special post.

For those that follow my twitter account @Monsta_AU, you may have noticed a small post earlier tonight.

Massive leak of data from #NBNco today. Gearing up to release it later tonight after cleanup. Comes from public document published by NBNco.

Well, this is the post announcing what I have found.

Today, NBNco published an update to its DCD plan on its website in both PDF and XLS (as ZIP) formats. The DCD plan is a listing of when the Fibre Serving Area Module (FSAM, or each separate area on the NBNco Rollout Map) is completed and the timer starts on the 18 months for the disconnection of the copper phone services in that area. The PDF is fairly boring, but the ZIP file containing an XLS spreadsheet is available from http://www.nbnco.com.au/content/dam/nbnco/documents/rollout-info-irrr-dcd-09-August2013.zip, while due to the data contained within and the fact that I fully expect this data to be pulled offline around 8am Monday, I am mirroring at http://blog.themonsta.id.au/wp-content/uploads/2013/08/rollout-info-irrr-dcd-09-August2013.zip.

Upon noting this data had change via an automated checker, I downloaded the file and opened in Excel to that it contains links to a master data source. Knowing that this means there will be some cached data within the file, I started doing some massaging, and with some help from another source I was able to pull out a heap of data from the original spreadsheet. Data I am sure that management at NBNco will want to make sure is not in the public domain. Well, you guys published it in your own website.

While I have cleaned up the data, and killed a heap of columns that don’t help anybody, there’s some really interesting data in the XLSX. Like how much delay has occurred on a particular FSAM in just 5 months. But bes of all, there is a listing of a large number of FSAMs. There’s 1107 records. NBNco announced a while ago that they have designed the rollout for a million premises around the nation. It’s my educated guess that this spreadsheet is the FSAMs that contain that one million premises. The entire NBN rollout will pass around 11 million homes, so this is about 10% of the entire rollout.

There is some data in here that will upset some people, especially where some dates now being shown have commencement dates in 2018 and 2019. You will have to ask NBNco why that is. I will be sending a complete extraction of the data to various local technology journalists that I respect and trust so they can do the full analysis of the information we have then ask NBNco what is going on.

As an NBN supporter, I have mixed emotions about releasing this just weeks from a federal election that could indeed see the project scuttled by radical conservatives that seem to be driven to implement a pamphlet rather than properly costed policies. If Malcolm and Tony want to use this against the NBN, I will be here posing the inadequacies of their Fraudband policy. However by releasing this I believe the data being available in the tech community will enable debate and keep everybody honest.

FILE: http://blog.themonsta.id.au/wp-content/uploads/2013/08/Full_List_NBNco_Designed_FSAMS_20130801.xlsx (65Kb)

8 comments for “NBNco accidentally leaks full list of FSAMs to Interwebs

  1. Daniel
    August 9, 2013 at 22:27

    Seems some of them are not entirely properly listed ? “Not Published to Access Seeker”.

    • Monsta
      August 9, 2013 at 22:37

      That’s the actual data cached in the spreadsheet. Basically they have not published the locality yet, but from the FSAM name and looking at the 1-year and 3-year coverage on the rollout maps, you can take a guess.

  2. Annie
    August 9, 2013 at 22:57

    Are they roll out commencement dates or copper decommission dates?

    • Monsta
      August 9, 2013 at 23:20

      First date is commencement + 12 months, so initial target for being ready for service.

      The rest are RFS target dates. The copper disconnection dates are in the actual spreadsheet that NBNco posted, this is just the underlying linked data they used to create that spreadsheet.

      • Annie
        August 10, 2013 at 18:00

        Thanks Monsta

  3. Matthew
    August 10, 2013 at 00:33

    I’m trying to make sense of it too. I found 2 FSAMs that would be for my area with dates of September and October 2014 under “Telstra 12 month RFS date” while the dates on the website say “December 2013 to June 2014 construction commences”. They were pushed back 2 months in the last update in march but those new dates are sooner than I would expect in that case.

    • Monsta
      August 10, 2013 at 00:58

      It could mean different things. I believe that the ‘Telstra’ date is the original planned date of construction commencement, plus 12 months which is the time that NBNco believe it should take each FSAM to be delivered after construction commences.

      If the construction start is pushed back, that Telstra date will likely not change until construction actually commences. If the map says construction starts Dec13 and was pushed back a couple of months, then it would have been October(ish) this year that construction was due to commence so it kind of all slots into place.

      • Matthew
        August 10, 2013 at 01:08

        That makes sense. The original date was September 2013 then it was pushed back to December 2013 and has been there since the last site update in march. Hoping it’s not delayed further being so close and at risk due to the election. This is when frustration sets in.

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: