Amarr Mining Camp: Difference between revisions

Line 37:

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 ore amount, in units, that your fleet mined in column E.

2. Use the prices in the thread above to fill in the values of the ores (column H).

*2. Use the prices in the thread above to fill in the values of the ores (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 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.

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 pay" part of the contract, put 10,000 ISK while the "I will receive" part is the total value listed in Column L Row 1. Make sure you email Seranti Olerie and/or Vger Starseed to make sure they know that the contract was submitted.

*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 pay" part of the contract, put 10,000 ISK while the "I will receive" part is the total value listed in Column L Row 1. Make sure you email Seranti Olerie and/or Vger Starseed to make sure they know that the contract was submitted.

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. 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!).

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).

*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. 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.

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. 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.

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. 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.

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 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.

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. 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.

=== Free T1 Modules & Mining Cruisers/Barges ===

@@ Line 37: / Line 37: @@
 Spreadsheet Mechanics:
-. 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 ore amount, in units, that your fleet mined in column E.
-. Use the prices in the thread above to fill in the values of the ores (column H).
+*2. Use the prices in the thread above to fill in the values of the ores (column H).
-. 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 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.
-. 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 pay" part of the contract, put 10,000 ISK while the "I will receive" part is the total value listed in Column L Row 1. Make sure you email Seranti Olerie and/or Vger Starseed to make sure they know that the contract was submitted.
+*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 pay" part of the contract, put 10,000 ISK while the "I will receive" part is the total value listed in Column L Row 1. Make sure you email Seranti Olerie and/or Vger Starseed to make sure they know that the contract was submitted.
-. 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. 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!).
-. There is no six, check your eyes again, they may have glazed over already (make sure to massage and stretch with deep, dramatic breaths).
+*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).
-. 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. 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.
-. 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. 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.
-. 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. 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.
-. 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 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.
-. 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. 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.
 === Free T1 Modules & Mining Cruisers/Barges ===