Toggle menu
Toggle preferences menu
Toggle personal menu
Not logged in
Your IP address will be publicly visible if you make any edits.

Archive:AMC Buyback Spreadsheet: Difference between revisions

From EVE University Wiki
Kyrrant (talk | contribs)
Kyrrant (talk | contribs)
Line 96: Line 96:


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:
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".
# 1. Make a copy
# If there is a popup asking "Authorization Required" please select "OK" and go back to the menu item "Buyback" and "Update Prices"
# 2. Copy the contents of the Stuff you wish to contract over to the Paste Inventory tab
# When the spreadsheet shows the message "Finished script" go back to the menu item "Buyback" and select "Prepare BuyBack"
# 3. Change to the Output tab
# To confirm the preparation was done correctly please check "Calculated ISK/unit" in column E row 4 to 11.
# 4. Select "Finalize Buyback" in the Buyback Menu
#:If there is no value please wait 5 to 10 minutes and try to "Update Prices" & "Prepare BuyBack" again.
# 5. Share the Spreadsheet
#:Please do not proceed until this values are not 0
(Click the blue button in the upper right of this form, then click ""get shareable link"".)
# 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"
# 6. There is no 6
# You really expect there to be a six?
# 7. Create a Contract to Bruce Industries for the product
# 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.
# 8. Set the Contract amount in the field "you will receive" to the amount shown in cell G1 of the Inventory Sheet
#:Always make sure that all ore is stacked before setting up the contract.
# 9. In the Description field of the contract paste the buyback link
#: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.
(the field located between ""/d/*****/edit#"" Example below.)
#:Preferred stations are stations from home corporation.
# [[File:AMC_Buyback_6.jpg|500px|thumb|none|Finding the spreadsheet key]]
#:Set the Expiration time to the longest value (4 weeks).
# 10. Set contract for 4 weeks expiration, then click finalize contract.
# 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.
# 11.Wait to get paid.
# 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)
#:[[File:AMC_Buyback_6.jpg|500px|thumb|none|Finding the spreadsheet key]]
# Afterwards you only need to submit the contract ingame. The ISK will be added to your wallet soon after.


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