Eve Online Mining Op Spreadsheet 2015-11a

	A	B
1	EVE Mining Op (Ore)	Version 2015-11a
2	See also:	http://wiki.eveuniversity.org/Scrapyard%27s_Mining_Op_Worksheet
3	Enter your name:	D'raga/True Descendants of Dragonis

4	Entry fields are color-coded according to the type of data that should be entered
5	Green	Text entry fields (such as names, yes/no flags, etc)
6	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.
7	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.
8
9	General Notes
10	Google Docs:	If you have gotten here via a Google Docs link, you can save a copy for your own personal use either by "File, Download As, Excel/OpenOffice" or 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.
11	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.
12	Update your values:	The sheet comes with rough mineral/ore prices entered on the "Inventory" sheet - update these to reflect your local values. You should also look at the "Refining" sheet and make sure that it reflects your current situation. The mineral values are important, the values for individual ores are less important.
13	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.
14	Track your ore/ice:	The "Inventory" sheet is where you track how much product has been harvested by the fleet.
15
16	Inventory - tracks the amount of materials mined or refined
17	Item Name	Minerals or primary name of the ore type
18	Sub-Type	Name of the ore-variant
19	Suggest Action	If the market price for the raw material is N% higher then the refined value (based on the "fudge factor" percentage on the refining sheet), this column will read "Sell" instead of "Refine". The vast majority of the time, you will "Refine" ore instead of selling it as raw ore.
20	Action Taken	Enter "Sell" or "Refine" (usually "Refine").
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	Market Price	Price per unit of the mineral or raw ore. These values are used to estimate total revenue for the operation as well as calculating whether it is better to sell or refine raw ore. Make sure you update these values!
24	Refine Value	Calculated price per unit if the ore is refined, used in the sell/refine decision. Values here are based off of the mineral market values entered at the top of the sheet. Refine value will take into account the refining skills, station attributes, and taxes paid as entered on the "Refining" sheet.
25	Estimated Value	Estimated value based on the amount mined column.
26	Mineral Payout (units) / Ore Payout (units)	This is a set of totals from the "Participation" tab which shows how many units of each item you are going to give to the participants (instead of selling the results for ISK). This number should be used as a set-aside before you start refining or selling. All of the minerals may be set aside, but only the four storyline ores are supported in this sheet.
27	Not Sold Inventory	Number of units not sold; which will be distributed as-is to participants. This value should equal the amount shown in the "Mineral Payout" column.
28	Actual Sell Value	Enter the actual value (ISK) as you sell the minerals or raw ore here. If you have to sell to multiple buy orders, enter values as "=value1+value2+value3". The actual value is what is used to determine the mining op payout as it reflects reality. If you need to, you can enter estimated values if the members have decided to base payouts on expected income from a sell order. You should enter the net value (total gross sale price, minus broker fees and taxes paid).
29	Not Sold Value	Calculated value estimate based on the unsold inventory column and either the market value or refine value of the raw ore (depending on the Action Taken column).
30	Not Sold Vol (m3)	Calculated volume (m3) of the unsold minerals/ore.
31
32	Participation - notes and help
33	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.
34	Name	Name of character participating in the operation
35	Comment	Comment field (usually records the ship and role, but can be anything). This is a good place to explain why a person has a larger/smaller then usual share weight.
36	Share Weight	Normally 1.00, but allows you to give different people different shares. An example of this would be 0.5 for frigates, 1.0 for cruisers, 1.5 for haulers, 2.0 for mining barges and 2.5 for hulk pilots. 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.
37	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.
38	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.
39	Pay With	The default is "ISK" meaning that the person wants to simply be paid in ISK at the end of the operation. You could also enter things like "ORE" or "MIN" to remind yourself that the person wants to be paid in minerals or ore.
40	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.
41	Weight Time	Calculated as HoursWorked * Weight. The weighted time is what will be used to divide the op's income among all participants.
42	Estimated 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.
43	Sold + Unsold + Extra (ISK)	Calculated as the total value of all sold goods plus the total value of unsold material plus the total income/loss from any extras. It is then weighted across the participants based on the weighted time. Do not use this column as the final payout.
44	Mineral Payout Value (ISK)	For participants who have requested a mineral payout, this column will calculate the value of the raw minerals given to each participant. Values are based off the market value from the "Inventory" sheet, so double-check that you have entered correct prices.
45	Ore Payout Value (ISK)	For participants who have requested to be paid in storyline ore, this column will calculate the value of the ore given to each participant. Values are based off the values from the "Inventory" sheet, so double-check that you have entered correct prices. Storyline ore is priced as the maximum of either the market value per unit or the refine value per unit (whichever is higher).
46	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.
47	Participant ISK Payout	The "show me the money" column. At the end of the operation, this is the column that you should use to distribute ISK to the participants. It takes into account the amount distributed to the person as raw ore/minerals and deducts it from their share.
48	Mineral Payout (units)	For each participant that wants to be paid in minerals, enter the amount of minerals that they will receive at the end of the operation. These minerals will then be valued in the "Mineral Payout" column for that participant.
49	Storyline Ore Payout (units)	For each participant that wants to be paid in storyline ores, enter the amount of ore that they will receive at the end of the operation. These quantities will then be valued in the "Ore Payout" column for that participant.
50	Time Clock Calculations	Calculated fields used to total up the time served based on the entries in the "Time Clock" columns
51	Duration Calc	Calculated fields used to calculate durations.
52
53	ExtraISK - used to add/remove raw ISK in the operation total
54	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.
55	Expense	ISK to remove from the payout total. An example would be the fee paid to a freighter pilot to move the ore or minerals to a refining location or market hub after the operation. Make sure that fleet members understand why extra expenses were paid out.
56	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.
57
58	Refining - Enter standings, skills, and fudge factors here
59	Standings	Enter the corporate standings of the person doing the refine. The person must have a personal or corp standing (whichever is higher) of at least 6.67 with the corporation at the station in order to pay zero tax during the refine process.
60	Tax Rate	Calculated from the standings value. Will be zero percent if the refiner has at least 6.67 standing with the station. Taxes are paid out of the results of the refining process.
61	Station Equipment	Not all stations are 50% yield, some are between 24% and 32%. Enter the station refinery percentage here.
62	Skills: Refining	Enter the skill level (1..5) for Refining and Refinery Efficiency of the person doing the refine. Note that you must have at least Refining V in order to train Refinery Efficiency.
63	Skills: Ore Processing	Enter the skill level (1..5) for the person doing the refine for each ore type.
64	Fudge factor	Enter the percentage above the refine price before the suggestion for refine/sell for a particular ore type will flip from "Refine" to "Sell". A value of 3% means that the raw ore must sell for at least 3% more then the refined value per unit in order for the sheet to suggest "Sell".
65
66	Source
67	Written by:	Scrapyard Bob <IVY>
68	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.
69		(\_(\
70		(=' :')
71		(,(')(')
72	Version History:	2010-04a - An early beta version that got most things right but is missing a few options and needs a lot of polishing.
73		2010-04b - Updated a lot of column headers, fixed formats, updated the help page to reflect reality.
74		2010-04c - Shrunk the font size to 9pt, looked at 8pt which is too small.
75		2010-04d - Fix some formats/lines that got duplicated during a copy/paste
76		2010-05a - Update refine values for Hedbergite, Hermorphite, Jaspet and Spodumain to reflect changes in May 2010 expansion.
77		2010-06a - Fix Spodumain values for Pyerite (now 410 instead of 140)
78		2011-06a - Updating the help topic page, add link to UniWiki page which explains the entire process of running a mining op. Updated mineral/ore prices (as they were a year old).
79		2011-11a - Setting up to automatically pull some price data.
80		2013-06a - Updated for EVE Online: Odyssey 1.0.1
81		2015-11a- Updated the Refining Equation for Current Itteration
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100