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)
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.

2021

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.
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.
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.