Archive:AMC Buyback Spreadsheet: Difference between revisions

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

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