|
|
| (8 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| ==Overview==
| | #REDIRECT [[User:Jefferson Spence]] |
| The AMC Buyback Spreadsheet is based on the [[Scrapyard's_Mining_Op_Worksheet|EVE IVY Mining Op worksheet]] created by Scrapyard Bob.
| |
| It's used to request a personal ore and/or mineral "Buy-Back" and from FC while [[Running a Mining Op|running a mining op]].
| |
| [[File:AMC_Buyback_1.jpg|300px|thumb|right|Make a copy]]
| |
| [[File:AMC_Buyback_2.jpg|300px|thumb|right|Name it correctly]]
| |
| [[File:AMC_Buyback_Step4.PNG|300px|thumb|right|Insert ore and/or minerals]]
| |
| [[File:AMC_Buyback_Step5-UpdatePrices.png|300px|thumb|right|"Update Prices"]]
| |
| [[File:AMC_Buyback_Step5-Authroize.PNG|300px|thumb|right|"Authorize Script"]]
| |
| [[File:AMC_Buyback_Step5-Final.png|300px|thumb|right|Check prices]]
| |
| | |
| __TOC__
| |
| ==Latest Version==
| |
| ===ORE===
| |
| =====Current Version 2013-02-AMC=====
| |
| Updated Sep08 2013<br>
| |
| The latest version is available at:<br>
| |
| [https://docs.google.com/spreadsheet/ccc?key=0Ao3i07DncK1hdEJUQUlQNWRFc3lQaWFrcktLaFo2a2c&usp=sharing AMC BUYBACK ORE (blank) at Google Docs]
| |
| | |
| ===ICE===
| |
| =====Current Version 2013-02-AMC-ICE=====
| |
| Updated Jun28 2013<br>
| |
| The latest version is available at:<br>
| |
| [https://docs.google.com/spreadsheet/ccc?key=0Aq62IUa6kN4adEZsWXFWaTR6RkZYc2tad2F2RWdoSUE&usp=sharing AMC BUYBACK ICE (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. Please do not download the spreadsheet if you intend to submit a buyback as your contract will be rejected immediately.
| |
| | |
| ==Instructions==
| |
| This will later be filled with complete instructions, including screenshots to walk you through.
| |
| | |
| ====Fleet Ops====
| |
| While running a mining op the mined ore, participation and ExtraISK values should be updates to provide and overview to the fleet members.
| |
| # For fleet Ops fill in the participation sheet during the op.
| |
| # Now follow the personal instructions below, returning to these instructions when prompted.
| |
| # Fill in the ExtraISK tab if you have sold any salvage or modules from rats, received a cash donation, or had to pay an external freighter such as Red Frog Freight.
| |
| | |
| ====Personal====
| |
| # 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 PLAYER NAME (DATE)
| |
| | |
| # On the inventory page, fill in the appropriate values in column C for ore and/or minerals, do not worry about prices until later.
| |
| # Update Buyback prices
| |
| ## 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".
| |
| ##If you get a warning to authorize the script, please go ahead and authorize it to allow it to update the prices.
| |
| ##After authorizing the script click "Update Prices" again.
| |
| ##:(If any prices in E4 through E11 show up as 0 (zero) wait for 5 to 10 minutes and try the Update Prices again. Do NOT submit the contract if any of these are zero)
| |
| ##: NOTE: DO NOT press update prices after you have issued the contract as it may change values and lead to your contract being rejected.
| |
| # You really expect there to be a six?
| |
| # 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"
| |
| # Issue the contract in game, remember it should be an 'Item Exchange' set to 'Private' and issued to '''Bruce Industries''' at a station within the AMC area (within 5 jumps is acceptable, beyond that contact an AMC Officer for approval).
| |
| # In the description enter the spreadsheet key (the part of the URL between ...key= and &USP... or ...key and #gid... see image for finding the key)
| |
| #:[[File:AMC_Buyback_6.jpg|400px|thumb|none|Finding the spreadsheet key]]
| |
| # Next, once you select the ore for the contract, copy the total value of your haul from the spreadsheet into the "I will receive" box (note: leave the other boxes empty) and click next to review your contract before submitting it.
| |
| # Go to the [https://docs.google.com/forms/d/13Mw5Dz5HevxW4n4e8rnzQvwtcFIVwFzskTbyC5CR4EY/viewform AMC Buyback Submission Form] and fill in the appropriate boxes. 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, your ISK will be with you soon.
| |
| | |
| ==Reasons for your contract to be declined==
| |
| | |
| * Prices was updated after the contract has been issued and no longer matching on contract and spreadsheet.
| |
| * Value and/ore quantity does not match between 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:
| |
| | |
| * Make sure that when you submit your buyback form that a link to your buyback spread sheet is included
| |
| * Only 1 contract per person, 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
| |
| | |
| [[Category:AMC]] | |
