Difference between revisions of "Archive:AMC Buyback Spreadsheet"

From EVE University Wiki
Jump to: navigation, search
Line 4: Line 4:
 
===Latest Version===
 
===Latest Version===
 
The latest version is available at:<br>
 
The latest version is available at:<br>
[https://docs.google.com/spreadsheet/ccc?key=0Aq62IUa6kN4adE85eW9qenhCcmJ4UzFtXzVZY1ZCQ3c#gid=2 AMC Mining Op (blank) at Google Docs]
+
[https://docs.google.com/spreadsheet/ccc?key=0Aq62IUa6kN4adDNvRW5tQWpfYUdkaVRabXF2V2tVcWc&usp=sharing 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 recommend using google docs where possible though, as downloading and uploading can cause errors.
+
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===
 
===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 particiaption sheet during the op and then follow the personal instructions below.
 
====Personal====
 
====Personal====
 
** 1. On the inventory page, fill in the appropriate values in column E, do not worry about prices until later.
 
** 1. On the inventory page, fill in the appropriate values in column E, do not worry about prices until later.
** 2. When ready to issue the contract to the AMC Buyback, select cells H4 to H11, right click and select copy
+
** 2. 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"
** 3. Right click in cell G4 and go down to Paste Special, then select paste values only
+
** NOTE: DO NOT press update prices after you have issued the contract as it may change values and lead to your contract being rejected.
'''IMPORTANT:''' Any contracts where the formula has been pasted, and not values will not be until rectified.
 

Revision as of 12:24, 26 February 2013

Overview

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 particiaption sheet during the op and then follow the personal instructions below.

Personal

    • 1. On the inventory page, fill in the appropriate values in column E, do not worry about prices until later.
    • 2. 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.