Archive:Mining operations worksheet: Difference between revisions

Line 79:

===Choose Payout Types===

The "Pay With" column is merely a comment field used to remind you (as the fleet commander) what sort of payout people have requested. Most people want ISK, some might want ore (ORE), others might want minerals (MIN). For people that want minerals or storyline ores, you will need to enter quantities in the right side of the "Participation" sheet (Mineral Payout and Storyline Ore Payout columns). Make sure that you set this ore/minerals aside before refining/selling.

I suggest using a screenshot or posting the # of storyline units being set aside into fleet chat to keep track of this in addition to entering it on the worksheet.

===Refine and Haul===

After setting aside the storyline ore payouts, give the rest of the ore to your refiner. Hopefully someone with [[Refining|zero tax and perfect refines]]. The amount of minerals that you get from refining should match the totals near "Total Mineral Quantities from Refining Process" on the "Inventory" worksheet (hidden in the upper-right portion).

Now set aside the minerals being used as mineral payouts.

Now set aside the minerals being used as mineral payouts. Again, report this in fleet chat or capture a screenshot for auditing purposes.

The rest of the minerals should be hauled to market. For the moment, mineral ~~payouts~~ and not yet sold units should be entered in the "Not Sold Inventory" column.

The rest of the minerals should be hauled to market and sold. For the moment, both mineral payout units and not yet sold units should be entered in the "Not Sold Inventory" column.

===Update the Amount===

As you sell off minerals, subtract the units from the "Not Sold Inventory" and add the ISK amounts in the "Actual Sold Value (ISK)" column.

As you sell off minerals, subtract the units from the "Not Sold Inventory" and add the ISK amounts in the "Actual Sold Value (ISK)" column. Repeat this process until you have sold off all of the minerals that were not set aside for mineral payouts.

===Distribute Shares===

Once all minerals have been sold, you can distribute shares for the operation. There is an easy way and a hard way to distribute shares, I will teach you the easy way that eliminates errors. The key things to remember are:

* Always copy/paste names from the spreadsheet to the EVE client

* Always copy/paste amounts from the spreadsheet to the EVE client

Start by distributing storyline ore and mineral payouts. You can do this either via trade in stations, or by creating an "item exchange" contract. Never type names or amounts, always copy/paste from the appropriate cell in the mining op spreadsheet. Mineral/Ore payout totals are on the "Participation" sheet. As you pay people, enter "o" or "m" in the "Paid?" column to keep track of who you have paid.

Then repeat the process for the ISK payouts. Copy the person's name into the clipboard, open up People & Places and search for "Character (exact)". Paste the member's name into the search box. When the name shows up, right-click and "Show Info" to double-check the member, then right-click and use "Give Money". For the amount, go to the "Participation" sheet and copy the amount from the "Participation ISK Payout" column. Paste this value into the amount field and enter "(systemname) mining op" in the comment field.

@@ Line 79: / Line 79: @@
 ===Choose Payout Types===
 The "Pay With" column is merely a comment field used to remind you (as the fleet commander) what sort of payout people have requested.  Most people want ISK, some might want ore (ORE), others might want minerals (MIN).  For people that want minerals or storyline ores, you will need to enter quantities in the right side of the "Participation" sheet (Mineral Payout and Storyline Ore Payout columns).  Make sure that you set this ore/minerals aside before refining/selling.
+I suggest using a screenshot or posting the # of storyline units being set aside into fleet chat to keep track of this in addition to entering it on the worksheet.
 ===Refine and Haul===
 After setting aside the storyline ore payouts, give the rest of the ore to your refiner.  Hopefully someone with [[Refining|zero tax and perfect refines]].  The amount of minerals that you get from refining should match the totals near "Total Mineral Quantities from Refining Process" on the "Inventory" worksheet (hidden in the upper-right portion).
-Now set aside the minerals being used as mineral payouts.
+Now set aside the minerals being used as mineral payouts.  Again, report this in fleet chat or capture a screenshot for auditing purposes.
-The rest of the minerals should be hauled to market.  For the moment, mineral payouts and not yet sold units should be entered in the "Not Sold Inventory" column.
+The rest of the minerals should be hauled to market and sold.  For the moment, both mineral payout units and not yet sold units should be entered in the "Not Sold Inventory" column.
 ===Update the Amount===
-As you sell off minerals, subtract the units from the "Not Sold Inventory" and add the ISK amounts in the "Actual Sold Value (ISK)" column.
+As you sell off minerals, subtract the units from the "Not Sold Inventory" and add the ISK amounts in the "Actual Sold Value (ISK)" column.  Repeat this process until you have sold off all of the minerals that were not set aside for mineral payouts.
 ===Distribute Shares===
+Once all minerals have been sold, you can distribute shares for the operation.  There is an easy way and a hard way to distribute shares, I will teach you the easy way that eliminates errors.  The key things to remember are:
+* Always copy/paste names from the spreadsheet to the EVE client
+* Always copy/paste amounts from the spreadsheet to the EVE client
+Start by distributing storyline ore and mineral payouts.  You can do this either via trade in stations, or by creating an "item exchange" contract.  Never type names or amounts, always copy/paste from the appropriate cell in the mining op spreadsheet.  Mineral/Ore payout totals are on the "Participation" sheet.  As you pay people, enter "o" or "m" in the "Paid?" column to keep track of who you have paid.
+Then repeat the process for the ISK payouts.  Copy the person's name into the clipboard, open up People & Places and search for "Character (exact)".  Paste the member's name into the search box.  When the name shows up, right-click and "Show Info" to double-check the member, then right-click and use "Give Money".  For the amount, go to the "Participation" sheet and copy the amount from the "Participation ISK Payout" column.  Paste this value into the amount field and enter "(systemname) mining op" in the comment field.