THE VOG FILES
  • Home
  • Hot Topics
    • Policy Gone Rogue
    • Defence Number Crunch
    • Manus Island The Morrison Story
    • Taxing Times
    • The Billboard Project
    • Pensions The Challenge Ahead
    • Building Better Regions Fund Analysis
  • Spreadsheet Sleuth
  • About
    • In The News
  • Gallery
  • Why Labor
    • Social Justice Issue That Just Don't Go Away
    • 2019 Federal Labor Election Loss
  • Spreadsheet Sleuth
    • Got A Tip?
  • Poet's Corner
  • Rorts Central
  • Blog
  • The VOG Files Member Application
    • Member Assistance
  • Members Area
    • They All Do It or Do They
    • Are we being gamed? >
      • Investment Games
      • Tax Games
      • The Analysis
      • Further Analysis
    • Embargo Page
    • Retirement Income
    • Pensions
    • Superannuation
    • Debt Cart
    • Manufacturing Thoughts.
    • Scilly Isles Visitor
    • Murray River News
    • Joe and Vince Storage Facility >
      • FIRB
  • Home
  • Hot Topics
    • Policy Gone Rogue
    • Defence Number Crunch
    • Manus Island The Morrison Story
    • Taxing Times
    • The Billboard Project
    • Pensions The Challenge Ahead
    • Building Better Regions Fund Analysis
  • Spreadsheet Sleuth
  • About
    • In The News
  • Gallery
  • Why Labor
    • Social Justice Issue That Just Don't Go Away
    • 2019 Federal Labor Election Loss
  • Spreadsheet Sleuth
    • Got A Tip?
  • Poet's Corner
  • Rorts Central
  • Blog
  • The VOG Files Member Application
    • Member Assistance
  • Members Area
    • They All Do It or Do They
    • Are we being gamed? >
      • Investment Games
      • Tax Games
      • The Analysis
      • Further Analysis
    • Embargo Page
    • Retirement Income
    • Pensions
    • Superannuation
    • Debt Cart
    • Manufacturing Thoughts.
    • Scilly Isles Visitor
    • Murray River News
    • Joe and Vince Storage Facility >
      • FIRB
Search by typing & pressing enter

YOUR CART

Spreadsheet Sleuth.

Welcome to the Spreadsheet Sleuth and document page.

Where possible I have written a methodology document which explains how I approached doing the analysis of the data in the spreadsheets.

It's not always possible to just do an analysis and many times assumptions are required. Where I have used them I have also documented them in the spreadsheet.

Here are a list of files under various headings.

Sports Rorts and other Grants Rorts.

2013 to 2019.
2018 a value of $15,377,056,651.68 in 24,447 grants
2019 a value of
$15,698,594,979.40 in 24003 grants
(Note Grants connect Government web portal commenced on 1 Jan 2018. Before that each grants stream was reported by the department administering that stream)

2013 to 2019.
Here is a Summary of all the grants programs I have analysed since 2013
When reading this section please note that in the 2019 Election The ALP had 68 seats, with the Coalition 77 seats. made up of 44 liberals, 23 LNP and 10 Nationals. the remainder are Independents and one Green.

The 2018-19 Move It AUS – Community Sport Infrastructure program value. $100,272,870.
684 Grants with 62% value going to Coalition seats and 32% to Labor.

2013 to 2019 Community Development Grants (CDG) $1,125,652,603.
70.74% going to Coalition seats and 25.06% going to Labor seats.

2013 to 2019 3 regional grants schemes worth $714,563,851
72.95% going to Coalition seats and 21.66% going to Labor.
This round of Analysis dealt with a total value worth $1,940,489,324. (1.9 billion over 6 years)
Timeline of Sports rorts by Vince O'grady June 2020
All Grants Submission To Australian Parliament by vince o'grady
Picture
Picture
Picture
Click here to view a word Document of all the grants awarded in the 2018 and 2019 years.
Click Here for for the explanation of why I did the Analysis and Method of doing so
Click here for The Sports grants spreadsheet. $100 Million.
Click here for Community Development programs 2013 to 2019. $1.1 Billion.
Click here for Regional Grants programs analysed between 2013 to 2019 $ 714.5 million

2020
Following the above analyses of these programs I was also asked to do further work to see what had transpired with these and other programs in 2020
Click here for the summary of all grants for all Government Departments for the year 2020. A total value of $15,719,459,198.66 in 44073 grants
Click here for the Summary of Community Development Grants (CDG) for the year 2020. $392,350,096
Click here for the Summary of Building Better regions Fund (BBRF) for the year 2020 $158,451,325
Click here for the Summary of the Drought Communities program for the year 2020 $188,500,000
Click here for the summary of Local Roads and community infrastructure Program for the year 2020 $499,119,729
Picture
Picture
Lastly and this is most important is the charge "they all do it".
Well do they?
They answer to that is No they don't.

Before 2008 they were no commonwealth grants guidelines and it was open slather. The Commonwealth grants guideline were brought in by the Labor party after the 2008 Election.
The only grant stream which operated under the same guidelines was the RDAF Fund. (Rural Development Australia fund between 2010 and 2014.
If you want to see that analysis it is appended below.

Picture
Picture
Rural Development Australia fund (RDAF) under Labor (spreadsheet)

2021

Picture
Commuter Car Park Fund Spreadsheet
Female Facilities & Water Safety Grants Spreadsheet
Picture
Building Better Regions Fund (Infrastructure Projects Stream) Round 5 2021
Picture

Conclusions and Summary

Now that you have a fair idea of the scope of the Grants analysis I have completed, I thought it prudent to add some conclusions to the analysis. To me these conclusions point to a systematic use of the Grants system to Pork Barrel votes.
However the decision is really up to the reader to make that conclusion and that is why I have placed all of the working summary files at your disposal to see what grants have been awarded to each electorate.
​​The Powerpoint presentation below is that discussion. Firstly it summarises each of the Grant programs which I have analysed above. Then it looks at the Lawfulness of the Sports Infrastructure Program.
Powerpoint Summary of all grants analysed with proposed Coalition strategy
The (civil) unlawful nature of these programs is set out by two submissions to the Senate Select Committee on Sports administration, which are available here They are Submissions 14 and 16. Submission 14 is written by Professor Anne Twomey, from Sydney University Law school, whilst Submission 16 is jointly written by  Professor Cheryl Saunders AO and Professor Michael Crommelin AO from the Law School of Melbourne University.

Luckily I have these eminent professors to do most of the legal work for me in their submissions before the Senate Select Committee on Sports Administration.

The last part of the 
powerpoint actually uses a timeline of events I have compiled from the evidence given before the Senate Select Committee on Sport Administration.

This timeline brings into light evidence which highlights that their might also have been the Criminal Offence of forgery of a Commonwealth document. because the Document was signed by the Minister on 4th April 2019, but was subsequently amended by 11 additions and subtractions and submitted under the original 4th April 2019 authorisation, on 11th April 2019.
Timeline of the movement of Sports grants with changes after final signature.
Lastly the powerpoint shows what I think the coalition strategy was leading up to the 2019 election and how the distribution of funds was shared unfairly to labor seats whilst advantaging Liberal, LNP and National party seats.

If we were talking about Scones with Jam and cream, the Liberal seats were the Jam, The LNP seats were double Jam, the National Seats were the cream and the Double cream was doled out to the Independent seats so that their confidence and supply was assured.
Picture
Privacy Policy
Member Area Application
Member Assistance
Got A Tip?
Picture
Site powered by Rebel Web Solutions