Amarr Mining Camp: Difference between revisions

Line 122:

'''FOR MINERS''': Miners that are selling their own stash of ore or minerals only need to create a [http://wiki.eveuniversity.org/Scrapyard%27s_Mining_Op_Worksheet spreadsheet] per instructions below for contract processing and payment.

'''FOR COMMANDERS''': After your fleet is over and you've input all of the names, ship type/roles, hours in/out, the share weights in the participation tab, and the ore amounts and prices in the Inventory tab - the [http://wiki.eveuniversity.org/Scrapyard%27s_Mining_Op_Worksheet spreadsheet] will automatically calculate the total weighting of the hours worked for each participant and how much you owe them. Once you have followed the instructions below, please post the link to the Google Docs spreadsheet in the [http://forum.eveuniversity.org/viewtopic.php?f=45&t=52718 Amarr Mining Camp Fleet Spreadsheet List] forum thread.

'''FOR COMMANDERS''': After your fleet is over and you've input all of the names, ship type/roles, hours in/out, the share weights in the participation tab, and the ore amounts and prices in the Inventory tab - the [http://wiki.eveuniversity.org/Scrapyard%27s_Mining_Op_Worksheet spreadsheet] will automatically calculate the total weighting of the hours worked for each participant and how much you owe them. Once you have followed the instructions below, please post the link to the Google Docs spreadsheet in the [http://forum.eveuniversity.org/viewtopic.php?f=45&t=52718 Amarr Mining Camp Fleet Spreadsheet List] forum thread, this is required or else your contract will not be accepted.

'''Spreadsheet Mechanics:'''

*1. Go to the Inventory tab, put the ~~ore~~ amount, in units, that your fleet mined in column E.

*1. Go to the Inventory tab, put the mineral amount, in units, that your fleet mined in column E.

*2. Use the prices in this ~~thread~~ [https://docs.google.com/spreadsheet/ccc?key=0AtiohZ91OMbTdFN2cGVuNFl5MU1sYXdVWUstMWpWUHc#gid=0_AMC BUYBACK] ~~above~~ to fill in the values of the ~~ores~~ (column H).

*2. Use the prices in this spreadsheet [https://docs.google.com/spreadsheet/ccc?key=0AtiohZ91OMbTdFN2cGVuNFl5MU1sYXdVWUstMWpWUHc#gid=0_AMC BUYBACK] to fill in the values of the minerals (column H).

*3. You now have estimated values in ISK in column I for your ~~ores~~, copy those values then paste them into column L. Just make sure it is ONLY the values you pasting, not the formulas. You can do this by right click the cell you want to paste into --> Paste Special --> Paste Values Only of the inventory tab.

*3. You now have estimated values in ISK in column I for your minerals, copy those values then paste them into column L. Just make sure it is ONLY the values you pasting, not the formulas. You can do this by right click the cell you want to paste into --> Paste Special --> Paste Values Only of the inventory tab.

*4. In the inventory tab, Column L Row 1 (at the very top), you'll see the total ISK value of your ore; make a contract with all the ~~ore~~, assign it to Bruce Industries and in the "I will receive" part put the total value listed in Column L Row 1. Please put a link to the spreadsheet in the "Description (optional)" box. You will need to use a URL shortener as there is a limit of 50 characters, we recommend using goo.gl as you should have a google account already. The organizers have decided it is no longer necessary to email Cartilige Deninard and Vger Starseed.

*4. In the inventory tab, Column L Row 1 (at the very top), you'll see the total ISK value of your ore; make a contract with all the minerals, assign it as private to Bruce Industries and in the "I will receive" part put the total value listed in Column L Row 1. Please put a link to the spreadsheet in the "Description (optional)" box. You will need to use a URL shortener as there is a limit of 50 characters, we recommend using goo.gl as you should have a google account already. The organizers have decided it is no longer necessary to email Cartilige Deninard and Vger Starseed.

*5. ~~Bruce Industries will accept~~ the ~~contract and send you a lot~~ of ~~ISK~~ (~~at this time~~, ~~I'd like~~ to ~~say strippers~~ and ~~coke = bad investment for all that ISK, so don't do it!)~~.

*5. Go to the spreadhseet submission thread [http://forum.eveuniversity.org/viewtopic.php?f=233&t=52718] found in the Amarr Mining Camp section of the uni forum. (Alumni, OOC characters and solo miners should send an evemail to Vger Starseed and Cartilige Deninard with a link to the spreadsheet.

*6. There is no six, check your eyes again, they may have glazed over already (make sure to massage and stretch with deep, dramatic breaths).

*7. You have two options for the modules that were salvaged, you can sell them at AMC or reprocess them yourself, don't worry you don't lose much, then place the amount of minerals you gained from them in the Inventory tab Column E Rows 4-11. If you sell the modules then you will put the amount in the Extra ISK tab, see next step.

*7. Bruce Industries will accept the contract and send you a lot of ISK (at this time, I'd like to say strippers and coke = bad investment for all that ISK, so don't do it!).

*8. Go to the Extra ISK tab and put in column A and B any income or expenses you had from rat loot/salvage, freighting, the contract, etc.

*8. You have two options for the modules that were salvaged, you can sell them at AMC or reprocess them yourself, don't worry you don't lose much, then place the amount of minerals you gained from them in the Inventory tab Column E Rows 4-11. If you sell the modules then you will put the amount in the Extra ISK tab, see next step.

*9. In the Participation tab, you will see Column M is now filled in with totals that you are to pay your fleet. These totals include the ISK you charged Bruce Industries, items you sold and expenses paid from the Extra ISK tab, and any minerals you have sold or will sell on your own.

*9. Go to the Extra ISK tab and put in column A and B any income or expenses you had from rat loot/salvage, freighting, the contract, etc.

*10. In column P of the Participation tab, type in "y" or n" for yes and no if you have paid out the fleet members. You'd put 'n' for no if you have a character name misspelled or something similar.

*10. In the Participation tab, you will see Column M is now filled in with totals that you are to pay your fleet. These totals include the ISK you charged Bruce Industries, items you sold and expenses paid from the Extra ISK tab, and any minerals you have sold or will sell on your own.

*11. Once you're done, post the spreadsheet of the fleet in this thread [http://forum.eveuniversity.org/viewtopic.php?f=45&t=52718&sid=c413a1601115540fd4062aec82d6edf4] for historical record, T2 Module Lottery purposes, and so the organizer's eyes don't bleed as we desperately look for all the spreadsheets.

*11. In column P of the Participation tab, type in "y" or n" for yes and no if you have paid out the fleet members. You'd put 'n' for no if you have a character name misspelled or something similar.

==== Free T1 Modules/Ships ====

@@ Line 122: / Line 122: @@
 '''FOR MINERS''': Miners that are selling their own stash of ore or minerals only need to create a [http://wiki.eveuniversity.org/Scrapyard%27s_Mining_Op_Worksheet spreadsheet] per instructions below for contract processing and payment.
-'''FOR COMMANDERS''': After your fleet is over and you've input all of the names, ship type/roles, hours in/out, the share weights in the participation tab, and the ore amounts and prices in the Inventory tab -  the [http://wiki.eveuniversity.org/Scrapyard%27s_Mining_Op_Worksheet spreadsheet] will automatically calculate the total weighting of the hours worked for each participant and how much you owe them. Once you have followed the instructions below, please post the link to the Google Docs spreadsheet in the [http://forum.eveuniversity.org/viewtopic.php?f=45&t=52718 Amarr Mining Camp Fleet Spreadsheet List] forum thread.
+'''FOR COMMANDERS''': After your fleet is over and you've input all of the names, ship type/roles, hours in/out, the share weights in the participation tab, and the ore amounts and prices in the Inventory tab -  the [http://wiki.eveuniversity.org/Scrapyard%27s_Mining_Op_Worksheet spreadsheet] will automatically calculate the total weighting of the hours worked for each participant and how much you owe them. Once you have followed the instructions below, please post the link to the Google Docs spreadsheet in the [http://forum.eveuniversity.org/viewtopic.php?f=45&t=52718 Amarr Mining Camp Fleet Spreadsheet List] forum thread, this is required or else your contract will not be accepted.
 '''Spreadsheet Mechanics:'''
-*1. Go to the Inventory tab, put the ore amount, in units, that your fleet mined in column E.
+*1. Go to the Inventory tab, put the mineral amount, in units, that your fleet mined in column E.
-*2. Use the prices in this thread [https://docs.google.com/spreadsheet/ccc?key=0AtiohZ91OMbTdFN2cGVuNFl5MU1sYXdVWUstMWpWUHc#gid=0_AMC BUYBACK] above to fill in the values of the ores (column H).
+*2. Use the prices in this spreadsheet [https://docs.google.com/spreadsheet/ccc?key=0AtiohZ91OMbTdFN2cGVuNFl5MU1sYXdVWUstMWpWUHc#gid=0_AMC BUYBACK] to fill in the values of the minerals (column H).
-*3. You now have estimated values in ISK in column I for your ores, copy those values then paste them into column L. Just make sure it is ONLY the values you pasting, not the formulas. You can do this by right click the cell you want to paste into --> Paste Special --> Paste Values Only of the inventory tab.
+*3. You now have estimated values in ISK in column I for your minerals, copy those values then paste them into column L. Just make sure it is ONLY the values you pasting, not the formulas. You can do this by right click the cell you want to paste into --> Paste Special --> Paste Values Only of the inventory tab.
-*4. In the inventory tab, Column L Row 1 (at the very top), you'll see the total ISK value of your ore; make a contract with all the ore, assign it to Bruce Industries and in the "I will receive" part put the total value listed in Column L Row 1. Please put a link to the spreadsheet in the "Description (optional)" box. You will need to use a URL shortener as there is a limit of 50 characters, we recommend using goo.gl as you should have a google account already. The organizers have decided it is no longer necessary to email Cartilige Deninard and Vger Starseed.
+*4. In the inventory tab, Column L Row 1 (at the very top), you'll see the total ISK value of your ore; make a contract with all the minerals, assign it as private to Bruce Industries and in the "I will receive" part put the total value listed in Column L Row 1. Please put a link to the spreadsheet in the "Description (optional)" box. You will need to use a URL shortener as there is a limit of 50 characters, we recommend using goo.gl as you should have a google account already. The organizers have decided it is no longer necessary to email Cartilige Deninard and Vger Starseed.
-*5. Bruce Industries will accept the contract and send you a lot of ISK (at this time, I'd like to say strippers and coke = bad investment for all that ISK, so don't do it!).
+*5. Go to the spreadhseet submission thread [http://forum.eveuniversity.org/viewtopic.php?f=233&t=52718] found in the Amarr Mining Camp section of the uni forum. (Alumni, OOC characters and solo miners should send an evemail to Vger Starseed and Cartilige Deninard with a link to the spreadsheet.
 *6. There is no six, check your eyes again, they may have glazed over already (make sure to massage and stretch with deep, dramatic breaths).
-*7. You have two options for the modules that were salvaged, you can sell them at AMC or reprocess them yourself, don't worry you don't lose much, then place the amount of minerals you gained from them in the Inventory tab Column E Rows 4-11. If you sell the modules then you will put the amount in the Extra ISK tab, see next step.
+*7. Bruce Industries will accept the contract and send you a lot of ISK (at this time, I'd like to say strippers and coke = bad investment for all that ISK, so don't do it!).
-*8. Go to the Extra ISK tab and put in column A and B any income or expenses you had from rat loot/salvage, freighting, the contract, etc.
+*8. You have two options for the modules that were salvaged, you can sell them at AMC or reprocess them yourself, don't worry you don't lose much, then place the amount of minerals you gained from them in the Inventory tab Column E Rows 4-11. If you sell the modules then you will put the amount in the Extra ISK tab, see next step.
-*9. In the Participation tab, you will see Column M is now filled in with totals that you are to pay your fleet. These totals include the ISK you charged Bruce Industries, items you sold and expenses paid from the Extra ISK tab, and any minerals you have sold or will sell on your own.
+*9. Go to the Extra ISK tab and put in column A and B any income or expenses you had from rat loot/salvage, freighting, the contract, etc.
-*10. In column P of the Participation tab, type in "y" or n" for yes and no if you have paid out the fleet members. You'd put 'n' for no if you have a character name misspelled or something similar.
+*10. In the Participation tab, you will see Column M is now filled in with totals that you are to pay your fleet. These totals include the ISK you charged Bruce Industries, items you sold and expenses paid from the Extra ISK tab, and any minerals you have sold or will sell on your own.
-*11. Once you're done, post the spreadsheet of the fleet in this thread [http://forum.eveuniversity.org/viewtopic.php?f=45&t=52718&sid=c413a1601115540fd4062aec82d6edf4] for historical record, T2 Module Lottery purposes, and so the organizer's eyes don't bleed as we desperately look for all the spreadsheets.
+*11. In column P of the Participation tab, type in "y" or n" for yes and no if you have paid out the fleet members. You'd put 'n' for no if you have a character name misspelled or something similar.
 ==== Free T1 Modules/Ships ====