Skip to content

Moving in from a spreadsheet ​

Your crew, aircraft and training records are in spreadsheets today. You end up with them in Zom's MRP in a few minutes, ready for missions.

On the computer (once) ​

  1. Open Settings > Your data and press Download the import template.
  2. Copy your lists into its People, Aircraft, Courses and Training sheets, keeping the headings. Any of them can be left empty. Hover a heading for what goes in it; the Read me sheet has examples.
  3. Press Import from Excel or CSV… and pick the file.
  4. Check the preview: what's added, what's updated (matched by name, or tail number) and what's skipped, with why.
  5. Press Import. Undo works right after.

More in Importing from Excel or CSV.

Then ​

  1. Look at Needs attention on the Overview for missing ratings or lapsed courses.
  2. Add each customer as a mission (Missions and seasons), with the training it needs.
  3. Crew each season with Fill the schedule (Filling the schedule).

Good to know ​

  • Importing again updates what's there instead of adding twice, so you can fix the sheet and import it again.
  • A CSV file holds one list; the template holds all four.
  • Missions and seasons aren't imported. They're quick to add, and Copy to next season does next year.