Difference between revisions of "User:Jefferson spence"
From EVE University Wiki
| Line 26: | Line 26: | ||
[[File:AMC_Buyback_2.jpg|300px|thumb|right|Step 3: Name it correctly]] | [[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_Step4.PNG|300px|thumb|right|Step 4: Insert ore and/or minerals]] | ||
| − | [[File:AMC_Buyback_Step5-UpdatePrices.png|300px|thumb|right|Step | + | [[File:AMC_Buyback_Step5-UpdatePrices.png|300px|thumb|right|Step 5a: "Update Prices"]] |
| − | [[File:AMC_Buyback_Step5-Authroize.PNG|300px|thumb|right|Step | + | [[File:AMC_Buyback_Step5-Authroize.PNG|300px|thumb|right|Step 5b: "Authorize Script"]] |
| − | [[File:AMC_Buyback_Step5-Final.png|300px|thumb|right|Step | + | [[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. | This will later be filled with complete instructions, including screenshots to walk you through. | ||
| Line 41: | Line 41: | ||
# Open the file menu and select "Make a Copy" (see image to right) | # Open the file menu and select "Make a Copy" (see image to right) | ||
# Name it following this convention PLAYER NAME (DATE) | # 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. | # 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 | # 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? | # 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" | # 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" | ||
Revision as of 20:14, 12 September 2013
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" and from FC while running a mining op.
Latest Version
ORE
Current Version 2013-02-AMC
Updated Sep08 2013
The latest version is available at:
AMC BUYBACK ORE (blank) at Google Docs
ICE
Current Version 2013-02-AMC-ICE
Updated Jun28 2013
The latest version is available at:
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.
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
- 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)
- 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 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
