{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Data","Calendar","Instructions"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Data","index":0,"n_rows":180,"n_cols":5,"rows_kept":180,"cut":false,"hidden":false,"merged":[]}
["Title","2018 DTF Information Requests","Date","Item","Comment"]
["Start Date","2018-01-01"]
["End Date","2019-06-30","GG - 2017-18 Mid-Year Financial Report"]
["TRIM",null,"2018-01-15","MYFR - GG - Dec YTD trial balance due"]
["Date background",null,"2018-01-22","MYFR - GG - Actuals variance commentary on Dec YTD due"]
["Shade Sat./Sun.?","Yes","2018-01-22","MYFR - GG - 2017-18 supplementary information due"]
["Blank date rows",3,"2018-01-22","MYFR - GG - SAU inter-entity dissection and reco statements due"]
[null,null,"2018-01-22","MYFR - GG - Accumulated Funds, Equity Investment and Contributed Capital recos due"]
["Highlight rules","MYFR|2016-17 Mid-Year Financial Report"]
[null,"RR|Regulation Reform","PNFC - 2017-18 Mid-Year Financial Report"]
[null,"Bud|2017-18 Budget","2018-01-15","MYFR - PNFC/PFC - Dec YTD trial balance due"]
[null,"AFR|2016-17 Annual Financial Report","2018-01-22","MYFR - PNFC/PFC - Actual variance commentary on Dec YTD due"]
[null,"OPR|Output Performance Reporting","2018-01-22","MYFR - PNFC/PFC - 2017-18 supplementary information due"]
[null,"EOYP|2016-17 End of Year Processes","2018-01-22","MYFR - PNFC/PFC - Accumulated Funds and Contributed Capital recos due"]
[null,"DF|Financial Reporting of Discretionary Funds","2018-02-09","MYFR - PNFC/PFC - Final data with actuarial results due (TAC/VWA/VMIA)"]
[null,"LTC|Long Term Commitments database"]
[null,"BU|2017-18 Budget Update","RR - Regulation Reform"]
[null,"MYFR|2017-18 Mid-Year Financial Report","2018-02-19","RR - December 2017 regulatory reform update report due"]
[null,"Bud|2018-19 Budget","2018-06-18","RR - May/June 2018 regulatory reform update report due"]
[null,"Oth|Other"]
[null,"MP|Major Projects and Asset Reporting","GG - 2018-19 Budget"]
[null,"*printers","2018-01-12","Bud - GG - Information pack provided to depts re Cwealth grants revenue and expenditure estimates"]
[null,"*holiday","2018-02-05","Bud - GG - Commonwealth grants revenue and expenditure estimates tracking due"]
[null,null,"2018-02-05","Bud - GG - Non policy output and asset adjustments to forward estimates finalised"]
[null,null,"2018-01-22","Bud - GG - Output and Asset (including reprioritisations) submissions lodged"]
[null,null,"2018-01-15","Bud - GG - Depts provide 2017-18 expected outcomes to DTF (BP3)"]
[null,null,"2018-02-02","Bud - GG - Ministerial approved departmental performance statement provided to DTF (BP3)"]
[null,null,"2018-03-06","Bud - GG - Minister for Finance to write to Portfolio Ministers (BP3)"]
[null,null,"2018-03-23","Bud - GG - Dept provide updated draft performance statement to DTF indicating any changes (BP3)"]
[null,null,"TBC","Bud - GG - DTF will advise on the date of final sign off confirming all BP3 statements are correct (BP3)"]
[null,null,"TBC","Bud - GG - Updated departmental performance information to reflect the 2017-18 approved budget initiatives due (BP3)"]
[null,null,"2018-03-26","Bud - GG - Updated project data on existing and completed projects due (BP4)"]
[null,null,"2018-04-09","Bud - GG - Information on new projects due (BP4)"]
[null,null,"2018-04-13","Bud - GG - Final sign off confirming all BP4 data is correct (BP4)"]
[null,null,"2018-03-22","Bud - GG - CA/CL info due (BP5)"]
[null,null,"2018-03-22","Bud - GG - controlled entity listing to be sent to DTF (BP5)"]
[null,null,"2018-03-23","Bud - GG - Tax expenditures and concessions data due to DTF Revenue Forecasting team (BP5)"]
[null,null,"2018-04-12","Bud - GG - CA/CL info to be updated if any changes since 22 March (BP5)"]
[null,null,"2018-05-11","Bud - GG - Information pack provided to depts re Post Cwealth Budget revenue and expenditure estimates"]
[null,null,"2018-05-18","Bud - GG - Post Cwealth Budget revenue and expenditure estimates due"]
[null,null,"2018-06-04","Bud - GG - Commonwealth related non policy adjustments finalised"]
[]
[null,null,"PNFC - 2018-19  Budget"]
[null,null,"2018-02-09","Bud - PNFC/PFC - Distribution tables due (Dividend/ITE/FAL)"]
[null,null,"2018-02-14","Bud - PNFC/PFC - Forward estimates trial balance due"]
[null,null,"2018-02-21","Bud - PNFC/PFC - Variance commentary on forward estimates trial balance due"]
[null,null,"2018-03-26","Bud - PNFC/PFC - Updated project data on existing and completed projects due (BP4)"]
[null,null,"2018-04-09","Bud - PNFC/PFC - Information on new projects due (BP4)"]
[null,null,"2018-04-13","Bud - PNFC/PFC - Final sign off confirming all BP4 data is correct (BP4)"]
[]
[null,null,"GG - 2017-18 Annual Financial Report"]
[null,null,"2018-05-23","AFR - GG - Forecast 30 June 2018 result due"]
[null,null,"2018-05-31","AFR - GG - Contentious accounting treatment issues due"]
[null,null,"2018-05-31","AFR - GG - Confirm with your DTF Relationship Manager that the shell accounts have been provided to VAGO (material entities only)"]
[null,null,"2018-06-15","AFR - GG - Updated CFO forecasts incorporating May actuals due"]
[null,null,"2018-07-13","AFR - GG - June YTD trial balance due"]
[null,null,"2018-07-20","AFR - GG - Actuals variance commentary on June YTD trial balance due"]
[null,null,"2018-07-20","AFR - GG - CFO forecast to actual results variance analysis due"]
[null,null,"2018-07-20","AFR - GG - Revenue certification submissions due"]
[null,null,"2018-07-23","AFR - GG - Draft accounts due (material entities only)"]
[null,null,"2018-08-02","AFR - GG - Revised June YTD trial balance due"]
[null,null,"2018-08-09","AFR - GG - All supplementary info due"]
[null,null,"2018-08-13","AFR - GG - SAU inter-entity dissection and reco statements due (public account entities only)"]
[null,null,"2018-08-13","AFR - GG - Split of Net Approp Agreements by State and Cwealth for output and capital due"]
[null,null,"2018-08-09","AFR - GG - Commitments and contingencies note published in depts annual report due"]
[null,null,"2018-08-09","AFR - GG - Supplementary Accumulated Funds, Equity Investment and Contributed Capital recos due"]
[null,null,"2018-08-09","AFR - GG - Revised actuals variance commentary on June YTD trial balance due"]
[null,null,"2018-08-17","AFR - GG - Audit opinions signed by VAGO (material entities only)"]
[null,null,"2018-08-31","AFR - GG - CFO certification and QA checklist due"]
[]
[null,null,"PNFC - 2017-18 Annual Financial Report"]
[null,null,"2018-05-30","AFR - PNFC/PFC - Confirm with your DTF Relationship Manager that the shell accounts have been provided to VAGO (material entities only)"]
[null,null,"2018-07-20","AFR - PNFC/PFC - Confirm with your DTF Relationship Manager that the draft accounts have been provided to VAGO (material entities only)"]
[null,null,"2018-08-01","AFR - PNFC/PFC - June YTD trial balance due"]
[null,null,"2018-08-08","AFR - PNFC/PFC - Actuals variance commentary on June YTD trial balance due"]
[null,null,"2018-08-09","AFR - PNFC/PFC - All supplementary info due"]
[null,null,"2018-08-09","AFR - PNFC/PFC - Commitments and contingencies notes due"]
[null,null,"2018-08-13","AFR - PNFC/PFC - Final data with actuarial results due (TAC/VWA/VMIA)"]
[null,null,"2018-08-13","AFR - PNFC/PFC - Accumulated Funds and Contributed Capital recos due"]
[null,null,"2017-08-17","AFR - PNFC/PFC - Audit opinions signed by VAGO (material entities only)"]
[null,null,"2018-08-31","AFR - PNFC/PFC - CFO certification and QA checklist due"]
[]
[null,null,"Output Performance Reporting"]
[null,null,"2018-01-15","OPR - Dec 2017 YTD output performance info for 6mths ending 31 Dec 2017"]
[null,null,"2018-01-16","OPR - Provisional invoice of your revenue claim for the 6mths ending 31 Dec 2017"]
[null,null,"2018-07-27","OPR - June 2018 YTD output performance info for full year ending 30 June 2018"]
[null,null,"2018-08-03","OPR - Invoice of your revenue claim for full year ending 30 June 2018"]
[]
[null,null,"2017-18 End of Year Processes"]
[null,null,"2018-05-30","EOYP - Ministers to finalise written requests for authorisation to access prior year approp"]
[null,null,"2018-06-12","EOYP - Ministers to finalise all other written dept funding requests"]
[null,null,"2018-08-03","EOYP - 2017-18 final carryover requirements to be submitted"]
[null,null,"2018-08-03","EOYP - Confirmation of depts actual required TA and s35 advances"]
[null,null,"2018-08-24","EOYP - 2017-18 approved final approp carryover into 2018-19 communicated"]
[]
[null,null,"Financial Reporting of Discretionary Funds"]
[null,null,"2018-02-09","DF - Report containing data and commentary for each Discretionary Fund as at 31 Dec 2017 due"]
[null,null,"2018-05-11","DF - Report containing data and commentary for each Discretionary Fund as at 31 Mar 2018 due"]
[null,null,"2018-08-10","DF - Report containing data and commentary for each Discretionary Fund as at 30 Jun 2018 due"]
[null,null,"2018-11-09","DF - Report containing data and commentary for each Discretionary Fund as at 30 Sep 2018 due"]
[null,null,"2019-02-15","DF - Report containing data and commentary for each Discretionary Fund as at 31 Dec 2018 due"]
[null,null,"2019-03-10","DF - Report containing data and commentary for each Discretionary Fund as at 31 Mar 2019 due"]
[]
[null,null,"Long Term Commitments Database"]
[null,null,"2018-12-14","LTC - Report containing data and commentary on long term commitments due"]
[]
[null,null,"GG - 2018-19 Budget Update"]
[null,null,"tbc","BU - GG - Non policy adjustments to the forward estimates to be finalised"]
[null,null,"tbc","BU - GG - CA/CL info due"]
[null,null,"tbc","BU - GG - 2023-24 rollover journals due"]
[]
[null,null,"PNFC - 2018-19 Budget Update / Pre-election Budget Update"]
[null,null,"xx/xx/2018","BU - PNFC/PFC - Distribution tables due (Dividend/ITE/FAL)"]
[null,null,"xx/xx/2018","BU - PNFC/PFC - Forward estimates trial balance due"]
[null,null,"xx/xx/2018","BU - PNFC/PFC - Variance commentary on forward estimates trial balance due"]
[]
[null,null,"Major Projects and Asset Reporting"]
[null,null,"2018-01-11","MP - Internal reports, data and commentary for HVHR and selected projects as at 31 Dec 2017 due"]
[null,null,"2018-01-22","MP - Data and commentary on all projects and info on NISC and procurement info as at 31 Dec 2017 due"]
[null,null,"2018-04-11","MP - Internal reports, data and commentary for HVHR and selected projects as at 31 Mar 2018 due"]
[null,null,"2018-04-23","MP - Data and commentary on all projects and info on NISC and procurement info as at 31 Mar 2018 due"]
[null,null,"2018-07-10","MP - Internal reports, data and commentary for HVHR and selected projects as at 30 Jun 2018 due"]
[null,null,"2018-07-20","MP - Data and commentary on all projects and info on NISC and procurement info as at 30 Jun 2018 due"]
[null,null,"2018-10-09","MP - Internal reports, data and commentary for HVHR and selected projects as at 30 Sep 2018 due"]
[null,null,"2018-10-19","MP - Data and commentary on all projects and info on NISC and procurement info as at 30 Sep 2018 due"]
[]
[null,null,"GG - 2018-19 Mid-Year Financial Report"]
[null,null,"2019-01-14","MYFR - GG - Dec YTD trial balance due"]
[null,null,"2019-01-21","MYFR - GG - Actuals variance commentary on Dec YTD due"]
[null,null,"2019-01-21","MYFR - GG - 2018-19 supplementary information due"]
[null,null,"2019-01-21","MYFR - GG - SAU inter-entity dissection and reco statements due"]
[null,null,"2019-01-22","MYFR - GG - Accumulated Funds, Equity Investment and Contributed Capital recos due"]
[]
[null,null,"PNFC - 2017-18 Mid-Year Financial Report"]
[null,null,"2018-01-11","MYFR - PNFC/PFC - Dec YTD trial balance due"]
[null,null,"2018-01-15","MYFR - PNFC/PFC - Actual variance commentary on Dec YTD due"]
[null,null,"2018-01-16","MYFR - PNFC/PFC - 2017-18 supplementary information due"]
[null,null,"2018-01-19","MYFR - PNFC/PFC - Accumulated Funds and Contributed Capital recos due"]
[null,null,"2018-02-09","MYFR - PNFC/PFC - Final data with actuarial results due (TAC/VWA/VMIA)"]
[]
[null,null,"GG - 2019-20 Budget"]
[null,null,"2019-01-21","Bud - GG - Output and Asset submissions lodged"]
[]
[null,null,"PNFC - 2019-20 Budget"]
[null,null,"2019-02-08","Bud - PNFC/PFC - Distribution tables due (Dividend/ITE/FAL)"]
[null,null,"2019-02-13","Bud - PNFC/PFC - Forward estimates trial balance due"]
[null,null,"2019-02-20","Bud - PNFC/PFC - Variance commentary on forward estimates trial balance due"]
[]
[null,null,"Other dates"]
[null,null,"2017-07-28","Oth - Coordinating Ministers to lodge dept 2017-21 Corporate Plans with Cabinet Office"]
[null,null,"2017-08-29","Oth - Coordinating Ministers to lodge dept 2017-21 Strategic Plans with Cabinet Office"]
[null,null,"2017-10-02","Oth - Data on expenditure against National Partnership agreements due this month"]
[null,null,"2017-09-01","Oth - Commonwealth Grants Commission data required for the 2018 update (September/October 2017)"]
[null,null,"2017-01-01","New Year's Day holiday"]
[null,null,"2017-01-02","New Year's Day holiday - additional"]
[null,null,"2017-01-26","Australia Day holiday"]
[null,null,"2017-03-13","Labour Day holiday"]
[null,null,"2017-04-14","Good Friday holiday"]
[null,null,"2017-04-15","Easter Saturday holiday"]
[null,null,"2017-04-16","Easter Sunday holiday"]
[null,null,"2017-04-17","Easter Monday holiday"]
[null,null,"2017-04-25","Anzac Day holiday"]
[null,null,"2017-06-12","Queen's Birthday holiday"]
[null,null,"2017-11-07","Melbourne Cup holiday"]
[null,null,"2017-12-25","Christmas Day holiday"]
[null,null,"2017-12-26","Boxing Day holiday"]
[null,null,"2018-01-01","New Year's Day holiday"]
[null,null,"2018-01-26","Australia Day holiday"]
[null,null,"2018-03-12","Labour Day holiday"]
[null,null,"2018-03-30","Good Friday holiday"]
[null,null,"2018-03-31","Easter Saturday holiday"]
[null,null,"2018-04-01","Easter Sunday holiday"]
[null,null,"2018-04-02","Easter Monday holiday"]
[null,null,"2018-04-25","Anzac Day holiday"]
[null,null,"2018-06-11","Queen's Birthday holiday"]
[null,null,"2018-09-28","Grand Final Friday holiday"]
[null,null,"2018-11-06","Melbourne Cup holiday"]
[null,null,"2018-12-25","Christmas Day holiday"]
[null,null,"2018-12-26","Boxing Day holiday"]
[null,null,"2019-01-01","New Year's Day "]

{"sheet":"Calendar","index":1,"n_rows":397,"n_cols":9,"rows_kept":397,"cut":false,"hidden":false,"merged":[[134,1,152,1],[153,1,182,1],[331,1,347,1],[348,1,367,1],[368,1,383,1],[384,1,399,1],[6,1,43,1],[44,1,65,1],[66,1,87,1],[88,1,111,1],[112,1,133,1],[183,1,211,1],[229,1,250,1],[251,1,267,1],[268,1,290,1],[291,1,311,1],[212,1,228,1],[312,1,330,1]]}
[]
[null,null,"2016-17 Mid-Year Financial Report","Regulation Reform","2017-18 Budget","2016-17 Annual Financial Report","Output Performance Reporting"]
[null,null,"2016-17 End of Year Processes","Financial Reporting of Discretionary Funds","Long Term Commitments database","2017-18 Budget Update","2017-18 Mid-Year Financial Report"]
[null,null,"2018-19 Budget","Other","Major Projects and Asset Reporting"]
[]
[null,null,"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"]
[null,"2018-01-01",1,2,3,4,5,6,7]
[null,null,"New Year's Day holiday"]
[]
[]
[]
[null,null,8,9,10,11,12,13,14]
[null,null,null,null,null,"MP - Internal reports, data and commentary for HVHR and selected projects as at 31 Dec 2017 due","Bud - GG - Information pack provided to depts re Cwealth grants revenue and expenditure estimates"]
[null,null,null,null,null,"MYFR - PNFC/PFC - Dec YTD trial balance due"]
[]
[]
[]
[null,null,15,16,17,18,19,20,21]
[null,null,"MYFR - GG - Dec YTD trial balance due","OPR - Provisional invoice of your revenue claim for the 6mths ending 31 Dec 2017",null,null,"MYFR - PNFC/PFC - Accumulated Funds and Contributed Capital recos due"]
[null,null,"MYFR - PNFC/PFC - Dec YTD trial balance due","MYFR - PNFC/PFC - 2017-18 supplementary information due"]
[null,null,"Bud - GG - Depts provide 2017-18 expected outcomes to DTF (BP3)"]
[null,null,"OPR - Dec 2017 YTD output performance info for 6mths ending 31 Dec 2017"]
[null,null,"MYFR - PNFC/PFC - Actual variance commentary on Dec YTD due"]
[]
[]
[]
[null,null,22,23,24,25,26,27,28]
[null,null,"MYFR - GG - Actuals variance commentary on Dec YTD due",null,null,null,"Australia Day holiday"]
[null,null,"MYFR - GG - 2017-18 supplementary information due"]
[null,null,"MYFR - GG - SAU inter-entity dissection and reco statements due"]
[null,null,"MYFR - GG - Accumulated Funds, Equity Investment and Contributed Capital recos due"]
[null,null,"MYFR - PNFC/PFC - Actual variance commentary on Dec YTD due"]
[null,null,"MYFR - PNFC/PFC - 2017-18 supplementary information due"]
[null,null,"MYFR - PNFC/PFC - Accumulated Funds and Contributed Capital recos due"]
[null,null,"Bud - GG - Output and Asset (including reprioritisations) submissions lodged"]
[null,null,"MP - Data and commentary on all projects and info on NISC and procurement info as at 31 Dec 2017 due"]
[]
[]
[]
[null,null,29,30,31,1,2,3,4]
[null,null,null,null,null,null,"Bud - GG - Ministerial approved departmental performance statement provided to DTF (BP3)"]
[]
[]
[]
[null,"2018-02-05",5,6,7,8,9,10,11]
[null,null,"Bud - GG - Commonwealth grants revenue and expenditure estimates tracking due",null,null,null,"MYFR - PNFC/PFC - Final data with actuarial results due (TAC/VWA/VMIA)"]
[null,null,"Bud - GG - Non policy output and asset adjustments to forward estimates finalised",null,null,null,"Bud - PNFC/PFC - Distribution tables due (Dividend/ITE/FAL)"]
[null,null,null,null,null,null,"DF - Report containing data and commentary for each Discretionary Fund as at 31 Dec 2017 due"]
[null,null,null,null,null,null,"MYFR - PNFC/PFC - Final data with actuarial results due (TAC/VWA/VMIA)"]
[]
[]
[]
[null,null,12,13,14,15,16,17,18]
[null,null,null,null,"Bud - PNFC/PFC - Forward estimates trial balance due"]
[]
[]
[]
[null,null,19,20,21,22,23,24,25]
[null,null,"RR - December 2017 regulatory reform update report due",null,"Bud - PNFC/PFC - Variance commentary on forward estimates trial balance due"]
[]
[]
[]
[null,null,26,27,28,1,2,3,4]
[]
[]
[]
[null,"2018-03-05",5,6,7,8,9,10,11]
[null,null,null,"Bud - GG - Minister for Finance to write to Portfolio Ministers (BP3)"]
[]
[]
[]
[null,null,12,13,14,15,16,17,18]
[null,null,"Labour Day holiday"]
[]
[]
[]
[null,null,19,20,21,22,23,24,25]
[null,null,null,null,null,"Bud - GG - CA/CL info due (BP5)","Bud - GG - Dept provide updated draft performance statement to DTF indicating any changes (BP3)"]
[null,null,null,null,null,"Bud - GG - controlled entity listing to be sent to DTF (BP5)","Bud - GG - Tax expenditures and concessions data due to DTF Revenue Forecasting team (BP5)"]
[]
[]
[]
[null,null,26,27,28,29,30,31,1]
[null,null,"Bud - GG - Updated project data on existing and completed projects due (BP4)",null,null,null,"Good Friday holiday","Easter Saturday holiday","Easter Sunday holiday"]
[null,null,"Bud - PNFC/PFC - Updated project data on existing and completed projects due (BP4)"]
[]
[]
[]
[null,"2018-04-02",2,3,4,5,6,7,8]
[null,null,"Easter Monday holiday"]
[]
[]
[]
[null,null,9,10,11,12,13,14,15]
[null,null,"Bud - GG - Information on new projects due (BP4)",null,"MP - Internal reports, data and commentary for HVHR and selected projects as at 31 Mar 2018 due","Bud - GG - CA/CL info to be updated if any changes since 22 March (BP5)","Bud - GG - Final sign off confirming all BP4 data is correct (BP4)"]
[null,null,"Bud - PNFC/PFC - Information on new projects due (BP4)",null,null,null,"Bud - PNFC/PFC - Final sign off confirming all BP4 data is correct (BP4)"]
[]
[]
[]
[null,null,16,17,18,19,20,21,22]
[]
[]
[]
[null,null,23,24,25,26,27,28,29]
[null,null,"MP - Data and commentary on all projects and info on NISC and procurement info as at 31 Mar 2018 due",null,"Anzac Day holiday"]
[]
[]
[]
[null,null,30,1,2,3,4,5,6]
[]
[]
[]
[null,"2018-05-07",7,8,9,10,11,12,13]
[null,null,null,null,null,null,"Bud - GG - Information pack provided to depts re Post Cwealth Budget revenue and expenditure estimates"]
[null,null,null,null,null,null,"DF - Report containing data and commentary for each Discretionary Fund as at 31 Mar 2018 due"]
[]
[]
[]
[null,null,14,15,16,17,18,19,20]
[null,null,null,null,null,null,"Bud - GG - Post Cwealth Budget revenue and expenditure estimates due"]
[]
[]
[]
[null,null,21,22,23,24,25,26,27]
[null,null,null,null,"AFR - GG - Forecast 30 June 2018 result due"]
[]
[]
[]
[null,null,28,29,30,31,1,2,3]
[null,null,null,null,"AFR - PNFC/PFC - Confirm with your DTF Relationship Manager that the shell accounts have been provided to VAGO (material entities only)","AFR - GG - Contentious accounting treatment issues due"]
[null,null,null,null,"EOYP - Ministers to finalise written requests for authorisation to access prior year approp","AFR - GG - Confirm with your DTF Relationship Manager that the shell accounts have been provided to VAGO (material entities only)"]
[]
[]
[]
[null,"2018-06-04",4,5,6,7,8,9,10]
[null,null,"Bud - GG - Commonwealth related non policy adjustments finalised"]
[]
[]
[]
[null,null,11,12,13,14,15,16,17]
[null,null,"Queen's Birthday holiday","EOYP - Ministers to finalise all other written dept funding requests",null,null,"AFR - GG - Updated CFO forecasts incorporating May actuals due"]
[]
[]
[]
[null,null,18,19,20,21,22,23,24]
[null,null,"RR - May/June 2018 regulatory reform update report due"]
[]
[]
[]
[null,null,25,26,27,28,29,30,1]
[]
[]
[]
[null,"2018-07-02",2,3,4,5,6,7,8]
[]
[]
[]
[null,null,9,10,11,12,13,14,15]
[null,null,null,"MP - Internal reports, data and commentary for HVHR and selected projects as at 30 Jun 2018 due",null,null,"AFR - GG - June YTD trial balance due"]
[]
[]
[]
[null,null,16,17,18,19,20,21,22]
[null,null,null,null,null,null,"AFR - GG - Actuals variance commentary on June YTD trial balance due"]
[null,null,null,null,null,null,"AFR - GG - CFO forecast to actual results variance analysis due"]
[null,null,null,null,null,null,"AFR - GG - Revenue certification submissions due"]
[null,null,null,null,null,null,"AFR - PNFC/PFC - Confirm with your DTF Relationship Manager that the draft accounts have been provided to VAGO (material entities only)"]
[null,null,null,null,null,null,"MP - Data and commentary on all projects and info on NISC and procurement info as at 30 Jun 2018 due"]
[]
[]
[]
[null,null,23,24,25,26,27,28,29]
[null,null,"AFR - GG - Draft accounts due (material entities only)",null,null,null,"OPR - June 2018 YTD output performance info for full year ending 30 June 2018"]
[]
[]
[]
[null,null,30,31,1,2,3,4,5]
[null,null,null,null,"AFR - PNFC/PFC - June YTD trial balance due","AFR - GG - Revised June YTD trial balance due","OPR - Invoice of your revenue claim for full year ending 30 June 2018"]
[null,null,null,null,null,null,"EOYP - 2017-18 final carryover requirements to be submitted"]
[null,null,null,null,null,null,"EOYP - Confirmation of depts actual required TA and s35 advances"]
[]
[]
[]
[null,"2018-08-06",6,7,8,9,10,11,12]
[null,null,null,null,"AFR - PNFC/PFC - Actuals variance commentary on June YTD trial balance due","AFR - GG - All supplementary info due","DF - Report containing data and commentary for each Discretionary Fund as at 30 Jun 2018 due"]
[null,null,null,null,null,"AFR - GG - Commitments and contingencies note published in depts annual report due"]
[null,null,null,null,null,"AFR - GG - Supplementary Accumulated Funds, Equity Investment and Contributed Capital recos due"]
[null,null,null,null,null,"AFR - GG - Revised actuals variance commentary on June YTD trial balance due"]
[null,null,null,null,null,"AFR - PNFC/PFC - All supplementary info due"]
[null,null,null,null,null,"AFR - PNFC/PFC - Commitments and contingencies notes due"]
[]
[]
[]
[null,null,13,14,15,16,17,18,19]
[null,null,"AFR - GG - SAU inter-entity dissection and reco statements due (public account entities only)",null,null,null,"AFR - GG - Audit opinions signed by VAGO (material entities only)"]
[null,null,"AFR - GG - Split of Net Approp Agreements by State and Cwealth for output and capital due"]
[null,null,"AFR - PNFC/PFC - Final data with actuarial results due (TAC/VWA/VMIA)"]
[null,null,"AFR - PNFC/PFC - Accumulated Funds and Contributed Capital recos due"]
[]
[]
[]
[null,null,20,21,22,23,24,25,26]
[null,null,null,null,null,null,"EOYP - 2017-18 approved final approp carryover into 2018-19 communicated"]
[]
[]
[]
[null,null,27,28,29,30,31,1,2]
[null,null,null,null,null,null,"AFR - GG - CFO certification and QA checklist due"]
[null,null,null,null,null,null,"AFR - PNFC/PFC - CFO certification and QA checklist due"]
[]
[]
[]
[null,"2018-09-03",3,4,5,6,7,8,9]
[]
[]
[]
[null,null,10,11,12,13,14,15,16]
[]
[]
[]
[null,null,17,18,19,20,21,22,23]
[]
[]
[]
[null,null,24,25,26,27,28,29,30]
[null,null,null,null,null,null,"Grand Final Friday holiday"]
[]
[]
[]
[null,"2018-10-01",1,2,3,4,5,6,7]
[]
[]
[]
[null,null,8,9,10,11,12,13,14]
[null,null,null,"MP - Internal reports, data and commentary for HVHR and selected projects as at 30 Sep 2018 due"]
[]
[]
[]
[null,null,15,16,17,18,19,20,21]
[null,null,null,null,null,null,"MP - Data and commentary on all projects and info on NISC and procurement info as at 30 Sep 2018 due"]
[]
[]
[]
[null,null,22,23,24,25,26,27,28]
[]
[]
[]
[null,null,29,30,31,1,2,3,4]
[]
[]
[]
[null,"2018-11-05",5,6,7,8,9,10,11]
[null,null,null,"Melbourne Cup holiday",null,null,"DF - Report containing data and commentary for each Discretionary Fund as at 30 Sep 2018 due"]
[]
[]
[]
[null,null,12,13,14,15,16,17,18]
[]
[]
[]
[null,null,19,20,21,22,23,24,25]
[]
[]
[]
[null,null,26,27,28,29,30,1,2]
[]
[]
[]
[null,"2018-12-03",3,4,5,6,7,8,9]
[]
[]
[]
[null,null,10,11,12,13,14,15,16]
[null,null,null,null,null,null,"LTC - Report containing data and commentary on long term commitments due"]
[]
[]
[]
[null,null,17,18,19,20,21,22,23]
[]
[]
[]
[null,null,24,25,26,27,28,29,30]
[null,null,null,"Christmas Day holiday","Boxing Day holiday"]
[]
[]
[]
[null,null,31,1,2,3,4,5,6]
[null,null,null,"New Year's Day "]
[]
[]
[]
[null,"2019-01-07",7,8,9,10,11,12,13]
[]
[]
[]
[null,null,14,15,16,17,18,19,20]
[null,null,"MYFR - GG - Dec YTD trial balance due"]
[]
[]
[]
[null,null,21,22,23,24,25,26,27]
[null,null,"MYFR - GG - Actuals variance commentary on Dec YTD due","MYFR - GG - Accumulated Funds, Equity Investment and Contributed Capital recos due"]
[null,null,"MYFR - GG - 2018-19 supplementary information due"]
[null,null,"MYFR - GG - SAU inter-entity dissection and reco statements due"]
[null,null,"Bud - GG - Output and Asset submissions lodged"]
[]
[]
[]
[null,null,28,29,30,31,1,2,3]
[]
[]
[]
[null,"2019-02-04",4,5,6,7,8,9,10]
[null,null,null,null,null,null,"Bud - PNFC/PFC - Distribution tables due (Dividend/ITE/FAL)"]
[]
[]
[]
[null,null,11,12,13,14,15,16,17]
[null,null,null,null,"Bud - PNFC/PFC - Forward estimates trial balance due",null,"DF - Report containing data and commentary for each Discretionary Fund as at 31 Dec 2018 due"]
[]
[]
[]
[null,null,18,19,20,21,22,23,24]
[null,null,null,null,"Bud - PNFC/PFC - Variance commentary on forward estimates trial balance due"]
[]
[]
[]
[null,null,25,26,27,28,1,2,3]
[]
[]
[]
[null,"2019-03-04",4,5,6,7,8,9,10]
[null,null,null,null,null,null,null,null,"DF - Report containing data and commentary for each Discretionary Fund as at 31 Mar 2019 due"]
[]
[]
[]
[null,null,11,12,13,14,15,16,17]
[]
[]
[]
[null,null,18,19,20,21,22,23,24]
[]
[]
[]
[null,null,25,26,27,28,29,30,31]
[]
[]
[]
[null,"2019-04-01",1,2,3,4,5,6,7]
[]
[]
[]
[null,null,8,9,10,11,12,13,14]
[]
[]
[]
[null,null,15,16,17,18,19,20,21]
[]
[]
[]
[null,null,22,23,24,25,26,27,28]
[]
[]
[]
[null,null,29,30,1,2,3,4,5]
[]
[]
[]
[null,"2019-05-06",6,7,8,9,10,11,12]
[]
[]
[]
[null,null,13,14,15,16,17,18,19]
[]
[]
[]
[null,null,20,21,22,23,24,25,26]
[]
[]
[]
[null,null,27,28,29,30,31,1,2]
[]
[]
[]
[null,"2019-06-03",3,4,5,6,7,8,9]
[]
[]
[]
[null,null,10,11,12,13,14,15,16]
[]
[]
[]
[null,null,17,18,19,20,21,22,23]
[]
[]
[]
[null,null,24,25,26,27,28,29,30]

{"sheet":"Instructions","index":2,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[[29,1,29,5],[0,1,0,5],[1,1,1,5],[14,1,14,5],[19,1,19,5],[20,1,20,5],[21,1,21,5],[22,1,22,5],[23,1,23,5],[24,1,24,5],[26,1,26,5],[27,1,27,5],[44,1,44,5],[3,1,3,5],[41,1,41,5],[16,1,16,5],[36,1,36,5],[37,1,37,5],[39,1,39,5],[40,1,40,5],[42,1,42,5],[43,1,43,5],[30,1,30,5],[31,1,31,5],[32,1,32,5],[33,1,33,5],[34,1,34,5],[35,1,35,5]]}
["Purpose:","This template allows you to enter a list of dates and automatically create a calendar suitable for printing.",null,null,null,null,"Example:","Shown are settings and dates for  an example publications schedule."]
[null,"Enter details and dates in the Data worksheet and use the Calendar tab commands to create a calendar."]
[]
["Ribbon tab:","The template adds a new Calendar tab in the Excel Ribbon:"]
[]
[null,null,"All Dates","Create a calendar using all dates."]
[null,null,"Filtered Dates","Create a calendar using only dates "]
[null,null,null,"from selected groups."]
[null,null,"Sort [date|text]","Sorts date items by either date or"]
[null,null,null,"description. Dates in groups are sorted"]
[null,null,null,"separately."]
[null,null,"Clear","Deletes all entered dates. Only use this"]
[null,null,null,"when starting a new calendar."]
[]
["Calendar Details:","The details in Column B on the Data worksheet determine the appearance of the calendar. \nEach option is described below:"]
[]
["Title","A title to include above the calendar when it is printed."]
["Start Date","The first date to include in the calendar."]
["End Date","The last date to include in the calendar."]
[null,"Note that the calendar will always begin on a Monday and end on a Sunday."]
["TRIM","If entered, a TRIM reference number will be included in the footer when printed."]
["Date background","Background colour of the days and month titles. Edit the fill colour of the cell to change it."]
["Shade Sat./Sun.?","If \"yes\", weekends are shown in the same colour as the Date background cell.",null,null,null,null,"Click All Dates to create the following calendar, including all date items. It will replace any existing calendar."]
["Blank date rows","Number of empty rows to add at the bottom of each date entry. "]
[null,"This might be useful if you want extra room to write notes on a printed copy, or leave at 0 to print the shortest calendar possible."]
["Highlight rules","This applies automatic colour coding. "]
[null,"Date items matching the rules are formatted to match the cell containing the rule."]
[null,"Supported formatting includes cell background colour, cell text colour, bold and italic."]
[]
[null,"There are three types supported, all shown in the sample data. "]
[null,"1. Enter any text to match items that begin with the same text. This allows creating codes or abbreviations which \n    could represent publications, team members etc."]
[null,"    In the example, date items beginning with \"AFR\" are pink, those beginning with \"AR\" are green, those beginning \n    with \"Eco.St.\" are blue."]
[null,"    Optionally include a vertical bar character (| - usually above the Enter key) with a description to appear in the \n    colour \"key\" above the calendar."]
[null,"2. Rules beginning with * will match if the text appears anywhere in the description."]
[null,"    For the example, dates for sending publications to the printers are shown in red and public holidays are grey."]
[null,"3. Rules beginning with # should include a date range separated by a hyphen. All dates within this range will be \n    highlighted on the calendar regardless of what they contain."]
[null,"    For the example, the caretaker government period prior to the election is shaded grey.",null,null,null,null,"Click Filtered Dates to display the following screen. This lets you create a calendar using only dates from selected groups:"]
[null,"    Optionally include a vertical bar character with a description to appear in the colour \"key\" above the calendar."]
[]
["Date items:","Enter the date for each item followed by a description. If you have set up highlighting rules as described above, use the same prefixes or terms for the highlighting to be applied. For the example, entries related to the Annual Report"]
[null,"are prefixed with AR, the Annual Financial Report with AFR and so on."]
[null,"A comment may also be added next to each date item. This won't appear on the calendar."]
[null,"If headings are included to group related dates together the Filtered Dates ribbon button creates a calendar that includes only dates from selected groups. A heading is just a description in the Date column, as in the example."]
[null,"A single date may have multiple items, but each item should appear on a separate row for formatting to work correctly. i.e. Don't enter a carriage return in a single cell to start a new item description for the same date."]
[null,"You may also apply ad hoc formatting to a date entry that doesn't match a rule by formatting the item description directly."]