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

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 [[Mining Op|running a mining op]].  

[[File:AMC_Buyback_1.jpg|300px|thumb|right|Preparing step 2: Make a copy]]

[[File:AMC_Buyback_2.jpg|300px|thumb|right|Preparing step 3: Name it correctly]]

[[File:AMC_Buyback_Step4.PNG|300px|thumb|right|Fill and submit step 1: Insert ore and/or minerals]]

[[File:AMC_Buyback_Step5-UpdatePrices.png|300px|thumb|right|Fill and submit step 2a: "Update Prices"]]

[[File:AMC_Buyback_Step5-Authroize.PNG|300px|thumb|right|Fill and submit step 2b: "Authorize Script"]]

[[File:AMC_Buyback_Step5-Final.png|300px|thumb|right|Fill and submit step 2c: Check prices]]

[[File:AMC_Buyback_ContractCreateContract.png|300px|thumb|right|Fill and submit step 4: Create the Contract]]

[[File:AMC_Buyback_ContractConfigureContract.png|300px|thumb|right|Fill and submit step 4: Configure Contract]]

[[File:AMC_Buyback_ContractSelectItems.png|300px|thumb|right|Fill and submit step 4: Select Items]]

[[File:AMC_Buyback_ContractSelectOptions.png|300px|thumb|right|Fill and submit step 5-7: Select Options]]

[[File:AMC_Buyback_ContractReviewContract.png|300px|thumb|right|Fill and submit step 7: Review Contract]]

[[File:AMC_Buyback_BuyBackForm.png|300px|thumb|right|Fill and submit step 8: Send BuyBack form]]

This will later be filled with complete instructions, including screenshots to walk you through.  

====Fleet Ops====

Have the spreadsheet setup and ready to go before the op.

* Before the Op

# Log into your google account and go to the current version.

# Name it following this convention.  For Shared Can use: "SHARED CAN - PLAYERNAME (DATE)"

* During the op

# Keep up with filling in the participation sheet with start and stop times for each participant. Make sure haulers know what station you want the ore delivered and who to contract the ore to after the op.  You must use a station within 5j of home and when possible try to use a homecorp station.

* After the op

# At the end of the op have all ore contracted to you (or whoever will be submitting the buyback contract)

# 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.

# Double check that all the partcitipation information is correct and be sure to thank all those who participated in the op.

# Next when you are ready go on to the section below for submitting the buyback contract.

====Personal Spreadsheet====

# Name it following this convention.  For Personal use: "PLAYERNAME (DATE)"

# Once you mined until your hearts content then get all the ore into a station within 5jumps of home (preferably a homecorp station) and follow the directions below to submit your buyback.

=== Fill and submit the spreadsheet ===

# 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.

# 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.

# 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.

# 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)

# 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.

# Leave the other boxes empty and click next to review your contract before submitting it.

# 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.

* Value and/ore quantity does not match on contract and spreadsheet.

* Only 1 contract per person, per system, per day.