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)
- Open Settings > Your data and press Download the import template.
- 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.
- Press Import from Excel or CSV… and pick the file.
- Check the preview: what's added, what's updated (matched by name, or tail number) and what's skipped, with why.
- Press Import. Undo works right after.
More in Importing from Excel or CSV.
Then
- Look at Needs attention on the Overview for missing ratings or lapsed courses.
- Add each customer as a mission (Missions and seasons), with the training it needs.
- 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.