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

← Older edit Newer edit →

VisualWikitext

@@ Line 1: / Line 1: @@
+{{Mining Links}}[[image:AMCtest.png|none|400px]]
 ==Overview==
-The AMC Buyback Spreadsheet is based on the [[Scrapyard's_Mining_Op_Worksheet|EVE IVY Mining Op worksheet]] created by Scrapyard Bob.
+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" 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]].
-__TOC__
 ==Latest Version==
@@ Line 24: / Line 24: @@
 ==Instructions==
-[[File:AMC_Buyback_1.jpg|300px|thumb|right|Make a copy]]
+[[File:AMC_Buyback_1.jpg|300px|thumb|right|Make a copy of the spreadsheet]]
-[[File:AMC_Buyback_2.jpg|300px|thumb|right|Name it]]
+[[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_Step5-UpdatePrices.png|300px|thumb|right|Fill and submit step 2a: "Update Prices"]]
@@ Line 36: / Line 36: @@
 [[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.
-Please be aware that you need to have the skill [[Skills:Trade#Contracting|Contracting]] at least skilled up to Level 1 to process a BuyBack.
+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.
+Please be aware that you need to have the skill [[Skills:Trade#Contracting|Contracting]] at least skilled up to Level 1 to process a Buy-Back.
 ----
-=== Preparing the Spreadsheet for fleet ops ===
+=== Using the spreadsheet in a shared can mining operation ===
-While running a mining op the mined ore, participation need to be updates to provide and overview to the fleet members.
+While running a mining op the participation of the fleet members needs to be updated in the sheet to provide an overview to the fleet members.
-====  Before the Op ====
+====  Before the operation ====
 # Go to the [[#Latest Version|current version]]
 # Log into your google account
@@ Line 54: / Line 55: @@
 # Make sure haulers know what station you want the ore delivered and who to contract the ore to after the op.
-==== During the op ====
+==== During the operation ====
 # Keep up with filling in the participation sheet with start and stop times for each participant.
-# If you're able to update the hauled minerals during the operation you can optionally update the data.
+# You must use a station within 5 jump of home and when possible try to use a station of home corporation.
-# You must use a station within 5j of home and when possible try to use a homecorp station.
 # Per AMC policy everyone involved in the op should be 1.00 shared weight no matter their role unless they voluntarily agree to less.
-==== After the op ====
+==== After the operation ====
-# At the end of the op have all ore contracted to the fleet command (or whoever will be submitting the buyback contract)
+# At the end of the operation have all ore contracted to the fleet command (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.
+# On the Inventory tab you need to add the amount of ore you mined during the shared Can to the column "Amt Mined" (column C).
+# Add ISK values ExtraISK tab if you had 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 participation 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.
+==== Submit the Buy-Back ====
+Follow the section [[#Submit the spreadsheet|Submit the spreadsheet]] below.
+==== After Buy-Back is completed ====
+# As soon as the Buy-Back is completed and paid out you need to pay the participated fleet members.
+# Open your spreadsheet again and go to the participation tab.
+# Start to pay out the value mentioned in "Payout (ISK)" column to the fleet members and mark the paid members in the "Paid" column.
+# It is recommended to send out a EVE Mail to the fleet members as soon as you've done all after work including the payout.
 ----
-=== Preparing the Spreadsheet for personal Buy Back ===
+=== Filling the Spreadsheet for personal Buy Back ===
+====  Prepare the spreadsheet ====
+# Go to the [[#Latest Version|current version]]
 # 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.  For Personal use: "PLAYERNAME (DATE)"
+# Name it following this convention.  For Personal use: "PLAYERNAME (DATE)" e.g. Jefferson Spence (27/03/2014)
-# 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.
+==== 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.
+==== Submit the Buy-Back ====
+Follow the section [[#Submit the spreadsheet|Submit the spreadsheet]] below.
 ----
-=== Fill and submit the spreadsheet ===
+=== Submit the spreadsheet ===
+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"
+# 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.
+::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
+# # 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"
-# 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.
-# 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).  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.