Archive:Mining operations worksheet
Overview
The EVE IVY Mining Op worksheet is what I (Scrapyard Bob) use when running a mining op. It lets me keep track of members, clock people in/out, track the ore as it gets hauled to the station, and do payouts in storyline ore or in refined minerals instead of ISK.
Latest Version
The latest version of my personal mining op worksheet is available at: EVE IVY Mining Op Worksheet (blank) at Google Docs
As with all Google Doc Spreadsheets, you can either copy it to your own personal Google Doc area or download it as a Microsoft Excel (XLS) file or in an OpenOffice.org spreadsheet file.
Basic Tips
Working with spreadsheets is an art, but a few basic tips are:
- Never move cells
- Never copy/paste random cells to other locations
- Don't insert or delete rows/columns
- If you need to clear an entry cell, highlight it and use the [Delete] key
- Make backups
All of my worksheets follow a color scheme of background colors indicating where you can enter data and what type of data gets entered in that location. Those colors are as follows:
- Green - Text entry fields (such as names, yes/no flags, etc)
- Yellow - Numeric entry fields (1.00, 500, 28.75, etc).
- Blue - Time entry fields (expected in format hh:mm, i.e. 14:25)
Sheets
- Help - This sheet will explain the other sheets. Lots of helpful information here such as what belongs in a particular column.
- Inventory - Used to track the progress of the mining op as ore is hauled to the station. Can also be used to track raw minerals looted from rats as well as the final refine amounts.
- Participation - This is where you track members and payouts.
- ExtraISK - Use this to add/remove ISK from the total. Such as payouts to freighter pilots (usually done at a rate of a few hundred thousand ISK per jump) or ISK received by selling off salvage or looted modules.
- Refining - Whoever is refining the ore should update this sheet to reflect their skill levels.
