Archive:AMC Buyback Spreadsheet: Difference between revisions

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.

@@ Line 4: / Line 4: @@
 ===Latest Version===
 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===
 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, 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.