Difference between revisions of "Archive:AMC Buyback Spreadsheet"

From EVE University Wiki
Jump to: navigation, search
(Created page with "==AMC Buyback Spreadsheet==")
 
Line 1: Line 1:
==AMC Buyback Spreadsheet==
+
==Overview==
 +
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.
 +
 
 +
===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]
 +
 
 +
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.
 +
 
 +
===Instructions===
 +
This will later be filled with complete instructions, including screenshots to walk you through.
 +
====Fleet Ops====
 +
 
 +
====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
 +
** 3. Right click in cell G4 and go down to Paste Special, then select paste values only
 +
'''IMPORTANT:''' Any contracts where the formula has been pasted, and not values will not be until rectified.

Revision as of 18:50, 13 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 recommend using google docs where possible though, as downloading and uploading can cause errors.

Instructions

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

Fleet Ops

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
    • 3. Right click in cell G4 and go down to Paste Special, then select paste values only

IMPORTANT: Any contracts where the formula has been pasted, and not values will not be until rectified.