Difference between revisions of "Archive:AMC Buyback Spreadsheet"

From EVE University Wiki
Jump to: navigation, search
m (minor cleanup / numbering of bullet list)
Line 1: Line 1:
 
{{Stub}}
 
{{Stub}}
 
==Overview==
 
==Overview==
[[File:AMC_Buyback_1.jpg|300px|thumb|right|Step 2]][[File:AMC_Buyback_2.jpg|300px|thumb|right|Step 3]][[File:AMC_Buyback_3.jpg|300px|thumb|right|Step 4]][[File:AMC_Buyback_4.jpg|300px|thumb|right|Step 5]][[File:AMC_Buyback_5.jpg|300px|thumb|right|Step 5]]
+
[[File:AMC_Buyback_1.jpg|300px|thumb|right|Step 2]][[File:AMC_Buyback_2.jpg|300px|thumb|right|Step 3]][[File:AMC_Buyback_3.jpg|300px|thumb|right|Step 4]][[File:AMC_Buyback_4.jpg|300px|thumb|right|Step 5a]][[File:AMC_Buyback_5.jpg|300px|thumb|right|Step 5b]]
  
 
The AMC Buyback Spreadsheet is based off of the [[Scrapyard's_Mining_Op_Worksheet|EVE IVY Mining Op worksheet]] created by Scrapyard Bob and is used when [[Running a Mining Op|running a mining op]]. It is used when the FC intends to sell the ore from a fleet, or their own personal supply of ore to the AMC Buyback Program.
 
The AMC Buyback Spreadsheet is based off of the [[Scrapyard's_Mining_Op_Worksheet|EVE IVY Mining Op worksheet]] created by Scrapyard Bob and is used when [[Running a Mining Op|running a mining op]]. It is used when the FC intends to sell the ore from a fleet, or their own personal supply of ore to the AMC Buyback Program.
Line 13: Line 13:
 
==Instructions==
 
==Instructions==
 
This will later be filled with complete instructions, including screenshots to walk you through.  
 
This will later be filled with complete instructions, including screenshots to walk you through.  
 +
 
====Fleet Ops====
 
====Fleet Ops====
** 1. For fleet Ops fill in the participation sheet during the op.
+
# For fleet Ops fill in the participation sheet during the op.
** 2. Now follow the personal instructions below, returning to these instructions when prompted.
+
# Now follow the personal instructions below, returning to these instructions when prompted.
** 3. Fill in the ExtraISK tab if you have sold any salvage or modules from rats, received a cash donation, or had to pay an external freighter such as Red Frog Freight.
+
# Fill in the ExtraISK tab if you have sold any salvage or modules from rats, received a cash donation, or had to pay an external freighter such as Red Frog Freight.
 +
 
 
====Personal====
 
====Personal====
** 1. Log into your google account and go to [https://docs.google.com/spreadsheet/ccc?key=0Aq62IUa6kN4adDNvRW5tQWpfYUdkaVRabXF2V2tVcWc&usp=sharing AMC Mining Op (blank) at Google Docs]
+
# Log into your google account and go to [https://docs.google.com/spreadsheet/ccc?key=0Aq62IUa6kN4adDNvRW5tQWpfYUdkaVRabXF2V2tVcWc&usp=sharing AMC Mining Op (blank) at Google Docs]
** 2. Open the file menu and select "Make a Copy" (see image to right.)
+
# Open the file menu and select "Make a Copy" (see image to right.)
** 3. Name it following this convention PLAYER NAME (DATE)
+
# Name it following this convention PLAYER NAME (DATE)
** 4. On the inventory page, fill in the appropriate values in column E for ore and/or minerals, do not worry about prices until later.
+
# On the inventory page, fill in the appropriate values in column E for ore and/or minerals, do not worry about prices until later.
** 5. When ready to issue the contract to the AMC Buyback open the "Buyback" menu found at the top of the page (from any page) and select "Update Prices"
+
# When ready to issue the contract to the AMC Buyback open the "Buyback" menu found at the top of the page (from any page) and select "Update Prices" NOTE: DO NOT press update prices after you have issued the contract as it may change values and lead to your contract being rejected.
** 6. You really expect there to be a six?
+
# You really expect there to be a six?
** NOTE: DO NOT press update prices after you have issued the contract as it may change values and lead to your contract being rejected.
+
# Go to the top right of the spreadsheet and click on the "Share" button to open sharing settings. Change it from private to "Anyone with the link can view"
** 7. Go to the top right of the spreadsheet and click on the "Share" button to open sharing settings. Change it from private to "Anyone with the link can view"
+
# Issue the contract in game, remember it should be an 'Item Exchange' set to 'Private' and issued to Bruce Industries at a station within the AMC area (within about 5j is acceptable).
** 8. Issue the contract in game, remember it should be an 'Item Exchange' set to 'Private' and issued to Bruce Industries at a station within the AMC area (within about 5j is acceptable).
+
# Next, once you select the ore for the contract, copy the total value of your haul from the spreadsheet into the "I will receive" box (note: leave the other boxes empty) and click next to review your contract before submitting it.
** 9. Next, once you select the ore for the contract, copy the total value of your haul from the spreadsheet into the "I will receive" box (note: leave the other boxes empty) and click next to review your contract before submitting it.
+
# Go to the [https://docs.google.com/forms/d/13Mw5Dz5HevxW4n4e8rnzQvwtcFIVwFzskTbyC5CR4EY/viewform AMC Buyback Submission Form] and fill in the appropriate boxes. This is a private form so feel free to type the location, just remember to check who is looking over your shoulder.
** 10. Go to the [https://docs.google.com/forms/d/13Mw5Dz5HevxW4n4e8rnzQvwtcFIVwFzskTbyC5CR4EY/viewform AMC Buyback Submission Form] and fill in the appropriate boxes. This is a private form so feel free to type the location, just remember to check who is looking over your shoulder.
+
# Hit submit and sit back, your ISK will be with you soon.
** 11. Hit submit and sit back, your ISK will be with you soon.
 
  
 
==Reasons for your contract to be declined==
 
==Reasons for your contract to be declined==
  
 +
* NOTE: DO NOT press update prices after you have issued the contract as it may change values and lead to your contract being rejected.
 +
* Too many jumps away from AMC home area
 +
* Incorrect total value or quantity.
 +
* Submission did not come via a Google Docs spreadsheet
  
 
[[Category:AMC]]
 
[[Category:AMC]]

Revision as of 22:47, 27 May 2013

This article is a stub. You can help the UniWiki by expanding it.

Overview

Step 2
Step 3

The AMC Buyback Spreadsheet is based off of the EVE IVY Mining Op worksheet created by Scrapyard Bob and is used when running a mining op. It is used when the FC intends to sell the ore from a fleet, or their own personal supply of ore to the AMC Buyback Program.

Latest Version

The latest version is available at:
AMC Mining Op (blank) at Google Docs

As with all Google Doc Spreadsheets, you can either copy it to your own personal Google Doc area or download it as a Microsoft Excel (XLS) file or in an OpenOffice.org spreadsheet file. We will not accept any submissions that have not come via a Google Docs spreadsheet.

Instructions

This will later be filled with complete instructions, including screenshots to walk you through.

Fleet Ops

  1. For fleet Ops fill in the participation sheet during the op.
  2. Now follow the personal instructions below, returning to these instructions when prompted.
  3. Fill in the ExtraISK tab if you have sold any salvage or modules from rats, received a cash donation, or had to pay an external freighter such as Red Frog Freight.

Personal

  1. Log into your google account and go to AMC Mining Op (blank) at Google Docs
  2. Open the file menu and select "Make a Copy" (see image to right.)
  3. Name it following this convention PLAYER NAME (DATE)
  4. On the inventory page, fill in the appropriate values in column E for ore and/or minerals, do not worry about prices until later.
  5. When ready to issue the contract to the AMC Buyback open the "Buyback" menu found at the top of the page (from any page) and select "Update Prices" NOTE: DO NOT press update prices after you have issued the contract as it may change values and lead to your contract being rejected.
  6. You really expect there to be a six?
  7. Go to the top right of the spreadsheet and click on the "Share" button to open sharing settings. Change it from private to "Anyone with the link can view"
  8. Issue the contract in game, remember it should be an 'Item Exchange' set to 'Private' and issued to Bruce Industries at a station within the AMC area (within about 5j is acceptable).
  9. Next, once you select the ore for the contract, copy the total value of your haul from the spreadsheet into the "I will receive" box (note: leave the other boxes empty) and click next to review your contract before submitting it.
  10. Go to the AMC Buyback Submission Form and fill in the appropriate boxes. This is a private form so feel free to type the location, just remember to check who is looking over your shoulder.
  11. Hit submit and sit back, your ISK will be with you soon.

Reasons for your contract to be declined

  • NOTE: DO NOT press update prices after you have issued the contract as it may change values and lead to your contract being rejected.
  • Too many jumps away from AMC home area
  • Incorrect total value or quantity.
  • Submission did not come via a Google Docs spreadsheet