Difference between revisions of "Archive:AMC Buyback Spreadsheet"
m (→ORE) |
(Removing reference to IGB) |
||
Line 35: | Line 35: | ||
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.<br /> | 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.<br /> | ||
'''We will not accept any submissions that have not come via a Google Docs spreadsheet.'''<br /> | '''We will not accept any submissions that have not come via a Google Docs spreadsheet.'''<br /> | ||
− | |||
==Instructions== | ==Instructions== |
Revision as of 16:38, 22 January 2017
Overview
The AMC Buyback Spreadsheet is based on the EVE IVY Mining Op worksheet created by Scrapyard Bob.
It's used to request a personal ore and/or mineral "Buy-Back" within the AMC Buy-Back Service and from an FC while running a mining op.
The AMC Buyback has a recommended minimum of 25,000,000 ISK and a maximum of 1,000,000,000 ISK per personal Buyback contract.
Latest Version
ORE
Current Version 2016-06-AMC-ORE
Updated June 2016
The latest version is available at:
ICE
Current Version 2014-12-AMC-ICE
Updated December 2014
The latest version is available at:
AMC Buyback Crius ICE
GAS
Current Version 2015-03-AMC-GAS
Updated March 2015
The latest version is available at:
AMC Buyback Tiamat GAS
NOTES
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
You'll find a brief instruction how to maintain this spreadsheet during a mining op and how you can put in a personal Buyback to the Buyback service of AMC.
It's recommended to have the skill Contracting skilled up to Level 1 to process more than one contract at the same time.
While running a mining op the participation of the fleet members needs to be updated in the sheet to provide an overview to the fleet members.
Before the operation
- Go to the current version
- Log into your google account
- Open the file menu and select "Make a Copy" (see image to right)
- Name it following this convention. For Shared Can use: "SHARED CAN - FC-Name (DATE)" e.g. SHARED CAN - Jefferson Spence (27/03/2014)
- 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"
- Make sure haulers know what station you want the ore delivered and who to contract the ore to after the op.
During the operation
- Keep up with filling in the participation sheet with start and stop times for each participant.
- You must use a station within 5 jump of home and when possible try to use a station of home corporation.
- Per AMC policy everyone involved in the op should be 1.00 shared weight no matter their role unless they voluntarily agree to less.
After the operation
- At the end of the operation have all ore contracted to the fleet command (or whoever will be submitting the buyback contract)
- On the Inventory or Paste Inventory tab you need to add the amount of ore you mined during the shared Can.
- On the Inventory tab add amounts of ore to to the column "Amt Mined" (column C).
- On the Paste Inventory tab you need to stack your ores and copy and paste to cell A4.
- The "Icons" view in your inventory will not work for this. You need to use the "Details" or "List" view.
- Add ISK values ExtraISK tab if you had sold any salvage or modules from rats, received a cash donation, or had to pay an external freighter such as Red Frog Freight.
- Double check that all the participation information is correct and be sure to thank all those who participated in the op.
Submit the Buy-Back
Follow the section Submit the spreadsheet below.
After Buy-Back is completed
- As soon as the Buy-Back is completed and paid out you need to pay the participated fleet members.
- Open your spreadsheet again and go to the participation tab.
- Start to pay out the value mentioned in "Payout (ISK)" column to the fleet members and mark the paid members in the "Paid" column.
- It is recommended to send out a EVE Mail to the fleet members as soon as you've done all after work including the payout.
Filling the Spreadsheet for personal Buy Back
Step-By-Step Image based Guide
Prepare the spreadsheet
- Go to the current version
- Log into your google account and go to the current version.
- Open the file menu and select "Make a Copy" (see image to right)
- Name it following this convention. For Personal use: "PLAYERNAME (DATE)" e.g. Jefferson Spence (27/03/2014)
Work on the spreadsheet
- You can ether use the Inventory or Paste Inventory tabs.
- On the Inventory tab you need to add the ore and mineral numbers to "Amt Mined" (column C) you'd like to add to the Buy-Back.
- On the Paste Inventory tab you need to stack your ores and copy and paste to cell A4 what you'd like to add to the Buy-Back.
- The "Icons" view in your inventory will not work for this. You need to use the "Details" or "List" view.
- Be sure to select the Inventory tab before continuing.
Submit the Buy-Back
Follow the section Submit the spreadsheet below.
Submit the spreadsheet
Before you can submit the Buy-Back finally you need to add the current prices for the Buy-Back to the spread sheet. This is done with the following steps:
- In the menu bar of the spread sheet you see an menu item called "Buyback" - Select it and then click "Update Prices".
- If there is a popup asking "Authorization Required" please select "OK" and go back to the menu item "Buyback" and "Update Prices"
- When the spreadsheet shows the message "Finished script" go back to the menu item "Buyback" and select "Prepare BuyBack"
- To confirm the preparation was done correctly please check "Calculated ISK/unit" in column E row 4 to 11.
- If there is no value please wait 5 to 10 minutes and try to "Update Prices" & "Prepare BuyBack" again.
- Please do not proceed until this values are not 0
- 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"
- You really expect there to be a six?
- When all above is done you need to issue the 'Private' 'Item Exchange' contract to Bruce Industries at a station that is applicable for Buy-Back service.
- Always make sure that all ore is stacked before setting up the contract.
- If you need to issue the contract outside of the 5 jump range please contact an AMC officer before you issue the contract for approval.
- Preferred stations are stations from home corporation.
- Set the Expiration time to the longest value (2 weeks).
- Within the contract creation you need to select the ore and/or mineral you added to the spreadsheet before and add it to the contract.
- When you go on to the next windows you need to add the total value from the field G1 in the spreadsheet to the "I will receive" box.
- The description box on the same windows within the contract creation needs to be filled with the spreadsheet key (the part of the URL between .../d/ and /edit see image for finding the key)
- Afterwards you only need to submit the contract ingame and go on to the AMC Buyback Submission Form and add the required information to finish your Buy-Back
- 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, the ISK will be added to your wallet soon.
Reasons for your contract to be declined
- Prices were updated and no longer match on contract and spreadsheet.
- Value and/or quantity does not match on contract and spreadsheet.
- Contract Station is more then 5 jumps away from the Homestation without AMC Officer approval.
- Submission did not come via a Google Docs spreadsheet
AMC Buyback Best Practices
The best practices keep the Buyback volunteers happy and keep your payback waiting time to a minimum:
- The AMC Buy-Back has a recommended minimum of 25.000.000 ISK and a maximum of 1.000.000.000 ISK per personal Buy-Back contract.
- Make sure that when you submit your buyback form that a link to your buyback spread sheet is included
- Only one personal contract per person, per system, per day.
- If refining yourself, do not add the extra unrefined ore to the contract, minerals only please
- Do not create a contract for ore/minerals inside of a container
|