Difference between revisions of "User:Jefferson spence"

From EVE University Wiki
Jump to: navigation, search
(Redirected page to User:Jefferson Spence)
 
(3 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]].
 
 
 
__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]
 
 
 
===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.<br />
 
'''We will not accept any submissions that have not come via a Google Docs spreadsheet.'''<br />
 
Please do not download the spreadsheet if you intend to submit a buyback as your contract will be rejected immediately. <br />
 
 
 
==Instructions==
 
[[File:AMC_Buyback_1.jpg|300px|thumb|right|Step 2: Make a copy]]
 
[[File:AMC_Buyback_2.jpg|300px|thumb|right|Step 3: Name it correctly]]
 
[[File:AMC_Buyback_Step4.PNG|300px|thumb|right|Step 4: Insert ore and/or minerals]]
 
[[File:AMC_Buyback_Step5-UpdatePrices.png|300px|thumb|right|Step 5a: "Update Prices"]]
 
[[File:AMC_Buyback_Step5-Authroize.PNG|300px|thumb|right|Step 5b: "Authorize Script"]]
 
[[File:AMC_Buyback_Step5-Final.png|300px|thumb|right|Step 5c: Check prices]]
 
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
 
#:a) 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".
 
#:b) If you get a warning to authorize the script, please go ahead and authorize it to allow it to update the prices.
 
#:c) 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 were updated and no longer match on contract and spreadsheet.
 
* Value and/ore 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:
 
 
 
* 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]]
 

Latest revision as of 21:22, 26 October 2014