| A | B | |
|---|---|---|
1 | Version 2015-07-ORE-REFINE | |
2 | See also: | http://wiki.eveuniversity.org/AMC_Buyback_Spreadsheet |
3 | See also: | http://wiki.eveuniversity.org/Scrapyard%27s_Mining_Op_Worksheet |
4 | Buyback Usage | |
5 | Update Prices | To update prices for use with the buyback, open the buyback menu found above at the right hand end of the menu bar. Select "Update Prices" and it a script will be run. Please be patient as this can take a while to run. It will automatically change to the Inventory sheet and then copy the prices for you. |
6 | Entry fields are color-coded according to the type of data that should be entered | |
7 | Green | Text entry fields (such as names, yes/no flags, etc) |
8 | Yellow | Numeric entry fields (1.00, 500, 28.75, etc). On fields where values should be in a specific range, there are formatting rules that will change the cell color if the entry is above/below what it should be. |
9 | Blue | Time entry fields (expected in format hh:mm, i.e. 14:25), it is best to use the EVE in-game time in 24-hour format. |
10 | ||
11 | General Notes | |
12 | Google Docs: | If you have gotten here via a Google Docs link, you can save a copy for your own personal use by saving a copy to your own Google Docs working area. Before starting an op, save this out to a new name and use that for the op. |
13 | General flow: | 90% of the worksheets are based on a left-right ordering, so you will slowly fill them out left-right during the operation. Look for fields with yellow / green / blue backgrounds for values that need to be entered/updated. |
14 | Update your values: | The sheet comes with mineral prices entered on the "Inventory" sheet - update these before submitting to the buyback. The mineral values are important, the values for individual ores are calculated off of the mineral prices at perfect refine.. |
15 | Track your fleet: | The "Participation" sheet is where you will track who is mining / hauling / guarding your fleet. This is also where you will get payout details. |
16 | Track your ore/ice: | The "Inventory" sheet is where you track how much product has been harvested by the fleet. |
17 | ||
18 | Inventory - tracks the amount of materials mined or refined | |
19 | Item Name | Minerals or primary name of the ore type |
20 | Sub-Type | Name of the ore-variant |
21 | Amount Mined | Number of units mined, this column should be filled out during the mining operation to keep track of progress. The amount of materials mined can be used as the estimated total value. |
22 | Mined Vol (m3) | Estimated volume (m3) based on the amount mined. This value should approximately match the volume in the station container. |
23 | Estimated Value | Estimated value based on the amount mined column. |
24 | ||
25 | Participation - notes and help | |
26 | Estimated End Time | This value in the top row can be used as an estimate of when the op will end. Any time card entries with a start time but no finish time will use the estimated end time as their finish time. You should set this to the actual end time of the operation when it is known. |
27 | Name | Name of character participating in the operation |
28 | Ship | Used to record what ship a pilot is flying for tracking ship progression. |
29 | Comment | Comment field. This is a good place to explain why a person has a larger/smaller then usual share weight. |
30 | Share Weight | Normally 1.00, but allows you to give different people different shares. Share weights should be left at 1.00 unless all members are aware of the different weights and agree to those weightings. You *must* get everyone to acknowledge weighted shares in fleet chat if it is an IVY shared-can op. |
31 | Time Clock (In/Out) | Allows you to clock a person in/out as they start/stop active participation in the fleet. There are currently two pairs of clock times available for people who need to leave and then come back later. If you need to clock a person in/out more then twice then you'll have to add them to the participation list again on additional rows. |
32 | Time Clock (Dock) | This is time that the person spent not participating, such as docked up at a station for 10-15 minutes where you don't want to clock them in/out of the fleet again. Time spent docked will be removed from the total participation time before shares are calculated. Works in addition to or instead of a second (or additional) clock times in the in/out columns. |
33 | Hours Worked | Calculated time spent for this participant (in hours). This number should match the wall clock time spent mining / hauling / guarding. Based off of the time clock columns. |
34 | Weight Time | Calculated as HoursWorked * Weight. The weighted time is what will be used to divide the op's income among all participants. |
35 | Payout (ISK) | This column attempts to estimate what each person's share of the op will be. It is based on the refine values of the product along with market values for the minerals plus any extra ISK. Do not use this column as the final payout. |
36 | Paid? | Use this to keep track of which people have been paid. There are no rules about what needs to be entered in this column. I suggest leaving it blank and then putting a "Y" in once you have paid the participant. |
37 | Time Clock Calculations | Calculated fields used to total up the time served based on the entries in the "Time Clock" columns |
38 | Duration Calc | Calculated fields used to calculate durations. |
39 | ||
40 | ExtraISK - used to add/remove raw ISK in the operation total | |
41 | Income | Amount of ISK to add to the payout total. Examples would be the selling of loot or salvage, estimated value of faction modules that drop from rats, or any other extra income to be distributed to the participants. |
42 | Expense | ISK to remove from the payout total. Make sure that fleet members understand why extra expenses were paid out. |
43 | Comment / Notes | Comment field, used to record the source of the extra ISK added to the total payout value. For example, "sold salvage", "bonus ISK", "modules sold from wrecks", "paid freighter pilot 250k per jump for 10 jumps", etc. |
44 | ||
45 | Source | |
46 | Converted by: | AMC |
47 | Written by: | Scrapyard Bob <IVY> |
48 | With help from: | Gennevie, Jen Loo, R0bowing, Aine Mindwolf, Callin Vandylx, Halada's Mining Guide, E-Uni, the EVE Dev Wiki, and others from EVE University. |
49 | (\_(\ | |
50 | (=' :') | |
51 | (,(')(') | |
52 | Previous Versions: | Cartilige Deninard, Rose Chanlin |
53 | Version History: | |
54 | ||
55 | 2015-03-AMC-ORE-REFINE - Initical Ore Reprocessing Sheet | |
56 | 2015-04-AMC-ORE-REFINE - Updates to reprocessing in Aegis Update | |
57 | 2015-07-AMC-ORE-REFINE - Some fixes to the reprocessing calculation | |