FIFO Roster Planner Spreadsheet Australia | 12 Month Swing Calendar 14/14 8/6 15/13 2/1 | Days Home vs Away | AUD
See your whole FIFO year at a glance. Choose your roster from the dropdown, enter the first day of any swing, and the planner builds a colour-coded 12-month calendar with away days, home days and travel days marked — plus a count of days home vs away for every month.
WHAT'S INSIDE
- Settings: roster dropdown — 8/6, 14/14, 15/13, 2/1 (14 on/7 off), 9/5, 21/7, 4/3, 7/7, or Custom (any days on/off). Edit or add patterns.
- Calendar: 12 months (Mon–Sun weeks) from your start month. Teal = away, green = home, ochre = travel day (first and last day of each swing; can be switched off).
- Summary: days away, home and travel per month, % home, stacked chart, and the next 26 swing dates (fly in, last day on, home from, back on).
- Daily List: every day for 12 months with cycle day, status and a Notes column.
WHAT YOU GET
- 1 × .xlsx spreadsheet file (instant digital download — nothing is posted)
- Instructions tab inside the file
- Example data in yellow cells so you can see how it works; select and delete to clear
COMPATIBILITY
Works in Microsoft Excel 2016 or later and Microsoft 365 (Windows/Mac), and Google Sheets (upload to Drive and open with Sheets; set File > Settings > Locale to Australia for dd/mm/yyyy dates). Also opens in LibreOffice Calc. No macros, add-ins or sign-ups. Best on a computer or tablet. Amounts in AUD. Compatibility is based on formula checks and LibreOffice testing; chart colours and some conditional formatting can look slightly different.
HOW TO USE
1. Download the `.xlsx` from your Payhip library / purchase email after checkout.
2. Open it in Excel, or upload it to Google Drive and open with Google Sheets.
3. Open the Instructions tab first. Yellow cells are example data — select and delete them, then add your own.
PLEASE NOTE
Digital download: you get the file straight after purchase, so we can't accept returns once it's been delivered. If the file won't open or a formula is broken, message us and we'll help or replace it. This doesn't reduce your rights under Australian Consumer Law. For personal use — please don't resell or share the file.
Colours on screen may vary slightly. Listing images show the actual file with example data.
DISCLAIMER
Note: it shows the repeating pattern only — it doesn't know about roster changes, R&R swaps or shutdowns, and it doesn't include flight times. Your employer's roster is always the source of truth.