Toggle search
Toggle menu
4.5K
7.6K
15.6K
232K
EVE University Wiki
Toggle preferences menu
Toggle personal menu
Not logged in
Your IP address will be publicly visible if you make any edits.

User:Jefferson Spence/Sandbox/AMCBuyback: Difference between revisions

From EVE University Wiki
More actions
← Older edit
VisualWikitext
mNo edit summary
Djavin novienta (talk | contribs)
13,761 edits
Removed category from User space.
 
(15 intermediate revisions by 2 users not shown)
Line 1: Line 1:
{{Mining Links}}[[image:AMCtest.png|none|400px]]
[[image:AMCtest.png|none|400px]]
[[image:Spacer.gif|50px]]
{{tocright}}


==Overview==
==Overview==
The AMC Buyback Spreadsheet is based on the [[Scrapyard's_Mining_Op_Worksheet|EVE IVY Mining Op worksheet]] created by Scrapyard Bob.<br>
The AMC Buyback Spreadsheet is based on the [[Scrapyard's_Mining_Op_Worksheet|EVE IVY Mining Op worksheet]] created by Scrapyard Bob.<br>
It's used to request a personal ore and/or mineral "Buy-Back" within the [[Amarr_Mining_Campus#AMC Buy-Back|AMC Buy-Back Service]] and from FC while [[Mining Op|running a mining op]].  
It's used to request a personal ore and/or mineral "Buy-Back" within the [[Amarr_Mining_Campus#AMC Buy-Back|AMC Buy-Back Service]] and from FC while [[Mining Op|running a mining op]].  
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.


==Latest Version==
==Latest Version==
Line 26: Line 30:
[[File:AMC_Buyback_1.jpg|300px|thumb|right|Make a copy of the spreadsheet]]
[[File:AMC_Buyback_1.jpg|300px|thumb|right|Make a copy of the spreadsheet]]
[[File:AMC_Buyback_2.jpg|300px|thumb|right|Name depending on Buy-Back usage]]
[[File:AMC_Buyback_2.jpg|300px|thumb|right|Name depending on Buy-Back usage]]
[[File:AMC_Buyback_Step4.PNG|300px|thumb|right|Fill and submit step 1: Insert ore and/or minerals]]
[[File:AMC_Buyback_Step4.PNG|300px|thumb|right|Fill amount of ore and/or mineral to column C]]
[[File:AMC_Buyback_Step5-UpdatePrices.png|300px|thumb|right|Fill and submit step 2a: "Update Prices"]]
[[File:AMC_Buyback_Step5-UpdatePrices.png|300px|thumb|right|Select "Update Prices"]]
[[File:AMC_Buyback_Step5-Authroize.PNG|300px|thumb|right|Fill and submit step 2b: "Authorize Script"]]
[[File:AMC_Buyback_Step5-Authroize.PNG|300px|thumb|right|Authroize the Buy-Back script to update the prices]]
[[File:AMC_Buyback_Step5-Final.png|300px|thumb|right|Fill and submit step 2c: Check prices]]
[[File:AMC_Buyback_Step5-Final.png|300px|thumb|right|Check prices after clicking "Update Prices"]]
[[File:AMC_Buyback_Contract_CreateContract.png|300px|thumb|right|Fill and submit step 4: Create the Contract]]
[[File:AMC_Buyback_Contract_CreateContract.png|300px|thumb|right|Create Buy-Back contract]]
[[File:AMC_Buyback_ContractCreateContract.png|300px|thumb|right|Fill and submit step 4: Configure Contract]]
[[File:AMC_Buyback_ContractCreateContract.png|300px|thumb|right|Select contract type and owner]]
[[File:AMC_Buyback_ContractSelectItems.png|300px|thumb|right|Fill and submit step 4: Select Items]]
[[File:AMC_Buyback_ContractSelectItems.png|300px|thumb|right|Select all items to add to the contract]]
[[File:AMC_Buyback_ContractSelectOptions.png|300px|thumb|right|Fill and submit step 5-7: Select Options]]
[[File:AMC_Buyback_ContractSelectOptions.png|300px|thumb|right|Add Buy-Back value and spreadsheet key]]
[[File:AMC_Buyback_ContractReviewContract.png|300px|thumb|right|Fill and submit step 7: Review Contract]]
[[File:AMC_Buyback_ContractReviewContract.png|300px|thumb|right|Review the contract]]
[[File:AMC_Buyback_BuyBackForm.png|300px|thumb|right|Fill and submit step 8: Send BuyBack form]]
[[File:AMC_Buyback_BuyBackForm.png|300px|thumb|right|Submit the AMC buy-Back form]]


You'll find a brief instruction how to maintain this spreadsheet during a mining op and how you can put in a personal Buy-Back to the Buy-Back service of AMC.
You'll find a brief instruction how to maintain this spreadsheet during a mining op and how you can put in a personal Buy-Back to the Buy-Back service of AMC.
Line 54: Line 58:
# 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"
# Make sure haulers know what station you want the ore delivered and who to contract the ore to after the op.   
# Make sure haulers know what station you want the ore delivered and who to contract the ore to after the op.   
==== Creating the fleet ====
While creating the fleet to run the mining operation you should enter a Message of the Day (MOTD) to the mining op to provide all necessary information for a new joining member.
This includes but is not limited to:
* Location
* Belt
* Spreadsheet link
Here is an example for a MOTD you can use for our mining ops:
<nowiki>
Welcome to today's AMC shared can op.
Location: [current system link]
Current Location: [current belt link]
Spreadsheet: [spreadsheet url here]
 
<b>Important:</b>
Make sure you're on the spreadsheet correctly and logged into mumble, AMC channel.
When you start mining, put into fleet chat:
  LASERS ON HH:MM
When you stop mining:
    LASERS OFF HH:MM
 
Naming your cans:
  FLEET HH:MM (in use)
  PULL HH:MM (moving on)
  FULL HH:MM (filled)
<b>NOTE: Leave the <u>original</u> (creation) time in the name.</b>
 
Please to not mine an asteroid that someone else already mining.
PLEASE Stack your Ore! - This makes live easier for the hauler.
</nowiki>


==== During the operation ====
==== During the operation ====
Line 86: Line 124:


==== Work on the spreadsheet ====  
==== Work on the spreadsheet ====  
# 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 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.


==== Submit the Buy-Back ====
==== Submit the Buy-Back ====
Line 98: Line 136:
# If there is a popup asking "Authorization Required" please select "OK" and go back to the menu item "Buyback" and "Update Prices"
# If there is a popup asking "Authorization Required" please select "OK" and go back to the menu item "Buyback" and "Update Prices"
# To confirm the update was done correctly please check "Calculated ISK/unit" in column E row 4 to 11.
# To confirm the update 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" again.
#:If there is no value please wait 5 to 10 minutes and try to "Update Prices" again.
::Please do not proceed until this values are not 0
#: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"
# 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"
 
# 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.
 
#: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.
# 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).  When possible try to have the ore in a homecorp station.
#:Preferred stations are stations from home corporation.
# 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. Make sure you only use the Field G1 on the inventory tab.
# You really expect there to be a six?
# You really expect there to be a six?
# In the description block at the bottom enter the spreadsheet key (the part of the URL between ...key= and &USP... or ...key and #gid... see image for finding the key)
# 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 ...key= and &USP... or ...key and #gid... see image for finding the key)
#:[[File:AMC_Buyback_6.jpg|500px|thumb|none|Finding the spreadsheet key]]
#:[[File:AMC_Buyback_6.jpg|500px|thumb|none|Finding the spreadsheet key]]
# 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.
# Afterwards you only need to submit the contract ingame and go on to the [https://docs.google.com/forms/d/13Mw5Dz5HevxW4n4e8rnzQvwtcFIVwFzskTbyC5CR4EY/viewform AMC Buyback Submission Form] and add the required information to finish your Buy-Back
# Leave the other boxes empty and click next to review your contract before submitting it.
#: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.  If this was a shared can then it will be up to you to pay each participant individually once the isk from the contract is delivered to you.  Be sure to update the Paid column of the spreadsheet to keep track of who was paid.
# Hit submit and sit back, the ISK will be added to your wallet soon.


==Reasons for your contract to be declined==
==Reasons for your contract to be declined==


* Prices were updated and no longer match on contract and spreadsheet.
* Prices were updated and no longer match on contract and spreadsheet.
* Value and/ore quantity does not 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.
* Contract Station is more then 5 jumps away from the Homestation without AMC Officer approval.
* Submission did not come via a Google Docs spreadsheet
* Submission did not come via a Google Docs spreadsheet
Line 122: Line 161:
The best practices keep the Buyback volunteers happy and keep your payback waiting time to a minimum:
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
* 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 system, per day.
* 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
* 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
* Do not create a contract for ore/minerals inside of a container
Retrieved from "https://wiki.eveuniversity.org/User:Jefferson_Spence/Sandbox/AMCBuyback"