Amarr Mining Camp: Difference between revisions

Line 29:

Amarr Mning Camp Buy-back Program

If you are a Fleet Commander (FC) that has run an operation but don't want to haul or contract the minerals to be hauled to market then you can take advantage of the AMC buy-back program~~, here's how it works:~~

If you are a Fleet Commander (FC) that has run an operation but don't want to haul or contract the minerals to be hauled to market then you can take advantage of the AMC buy-back program. 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 (columns A-H), the ore amounts and prices in the Inventory tab the spreadsheet will automatically calculate the total weighting of the hours worked for each participants (column K) and how much you owe them.

Fleet Commander contracts the ore to Bruce Industries (Item Exchange - Private contract) with the cost of the contract based on the prices in this thread [http://forum.eveuniversity.org/viewtopic.php?f=45&t=52275&sid=c413a1601115540fd4062aec82d6edf4] of the refined value of the ores being sold and 10,000 ISK to give to the corp for subsequent contracts. One of the characters in Bruce Industries will accept the contract thereby paying the Fleet Commander, the FC then pays the miners. ~~The Fleet Commander's role stops at this point; the AMC organizers will have it refined, hauled, and sold.~~

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 (columns A-H), the ore amounts and prices in the Inventory tab the spreadsheet will automatically calculate the total weighting of the hours worked for each participants (column K) and how much you owe them~~. Here's how you go about figuring out how much to pay your miners and charge Bruce Industries~~.

Spreadsheet Mechanics:

*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 this thread [http://forum.eveuniversity.org/viewtopic.php?f=45&t=52275&sid=c413a1601115540fd4062aec82d6edf4] 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.

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

@@ Line 29: / Line 29: @@
 Amarr Mning Camp Buy-back Program
-If you are a Fleet Commander (FC) that has run an operation but don't want to haul or contract the minerals to be hauled to market then you can take advantage of the AMC buy-back program, here's how it works:
+If you are a Fleet Commander (FC) that has run an operation but don't want to haul or contract the minerals to be hauled to market then you can take advantage of the AMC buy-back program. 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 (columns A-H), the ore amounts and prices in the Inventory tab the spreadsheet will automatically calculate the total weighting of the hours worked for each participants (column K) and how much you owe them.
-Fleet Commander contracts the ore to Bruce Industries (Item Exchange - Private contract) with the cost of the contract based on the prices in this thread [http://forum.eveuniversity.org/viewtopic.php?f=45&t=52275&sid=c413a1601115540fd4062aec82d6edf4] of the refined value of the ores being sold and 10,000 ISK to give to the corp for subsequent contracts. One of the characters in Bruce Industries will accept the contract thereby paying the Fleet Commander, the FC then pays the miners. The Fleet Commander's role stops at this point; the AMC organizers will have it refined, hauled, and sold.
-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 (columns A-H), the ore amounts and prices in the Inventory tab the spreadsheet will automatically calculate the total weighting of the hours worked for each participants (column K) and how much you owe them. Here's how you go about figuring out how much to pay your miners and charge Bruce Industries.
 Spreadsheet Mechanics:
 *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 this thread [http://forum.eveuniversity.org/viewtopic.php?f=45&t=52275&sid=c413a1601115540fd4062aec82d6edf4] 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.
 *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.