Buyback: Difference between revisions

Line 1:

~~{{eunispecific}}~~

= HQ Buyback Service =

The Buyback program is simply a way to sell your loot easily without the hassle of having to haul it to a trade hub yourself. You can use this program if you want to liquify your own assets from missions, salvaging, exploration, PI (or any other way of acquiring stuff you can think of), instead of having to haul it all to market and sell it yourself.

== Current Mining Buyback Spreadsheet ==

Current Version April 2022 (v6)

[https://drive.google.com/open?id=1uG86UeJF8I2c2-gxZ_RhTXkzs9z-67bLnLpJpE5FcHA Buyback Spreadsheet]

== Mining Buyback Spreadsheet Instructions==

=== Filling the spreadsheet for personal Buyback ===

==== Prepare the spreadsheet ====

# Go to the [[#Current Mining Buyback Spreadsheet|current version]]. (Note: This link will only take you to the "Latest Version" section on the page.)

# Log into your Google account.

# Open the file menu and select "Make a Copy".

# Name it following this convention. For Personal use: "Your Name (DATE)" - e.g. Jefferson Spence (2014/11/18)

==== Work on the spreadsheet ====

# Make sure the ore/ice/gas that you'd like to submit is stacked.

# On the '''Paste Inventory''' tab, select cell A4, and copy and paste these from your in-game inventory. The "Icons" view in your inventory will not work for this. You need to use the "Details" or "List" view. ("Icon" is the only view that works if you have a NON-US settings in your local. Since "Details" and "List" only seem to work for them who has US as local)

'''IMPORTANT:''' Make sure to have default column settings and number of columns (7).

==== Submit the Buyback ====

:Follow the section [[#Submit the spreadsheet|Submit the spreadsheet]] below.

----

=== Using the spreadsheet in a shared can mining operation ===

== ~~Slays~~ - ~~Moon Ore~~ ==

While running a mining op the participation of the fleet members needs to be tracked in the sheet.

==== Before the operation ====

# Go to the [[#Latest Version|current version]]. (Note: This link will only take you to the "Latest Version" section on the page.)

# Log into your Google account.

# Open the file menu and select "Make a Copy".

# Name it following this convention. For Shared Can use: "SHARED CAN - FC-Name (DATE)" - e.g. SHARED CAN - Jefferson Spence (2014/11/18)

# 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 to, and who to contract the ore to after the op.

==== During the operation ====

# Keep up with filling in the participation sheet with the start and stop times for each participant.

# Per Uni policy everyone involved in the op should be 1.00 shared weight no matter their role unless they voluntarily agree to less.

==== After the operation ====

# At the end of the operation have all ore contracted to the Fleet Commander (or whoever will be submitting the buyback contract).

# Make sure all the ore/ice/gas mined during the Shared Can is stacked.

# On the '''Paste Inventory''' tab, select cell A4, and copy and paste these from the in-game inventory. The "Icons" view in your inventory will not work for this. You need to use the "Details" or "List" view.

# Add any additional raw ISK to the '''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 make sure to thank all those who participated in the op.

==== Submit the Buyback ====

:Follow the section [[#Submit the spreadsheet|Submit the spreadsheet]] below.

==== After the Buyback is completed ====

# As soon as the Buyback is completed and paid out, you need to pay the fleet members.

# Open your spreadsheet again and go to the '''Participation''' tab.

# Start to transfer the values in the "Payout (ISK)" column to the fleet members, and mark them accordingly in the "Paid?" column.

# It is recommended to send out an EVE Mail to the fleet members as soon as you've done all the after work, including the payout.

----

=== Submit the spreadsheet ===

Before you submit the Buyback you'll need to fix the current market prices into the spreadsheet, so that they won't be updated anymore. This is done in the second step below:

# Change to the '''Inventory''' tab.

# Select "Finalize Buyback" in the Buyback Menu. (Because this step uses a script, Google docs security settings may ask you to authorize the script to run. Click the “Advanced” link on the pop up to enable the option to run the script, if this occurs).

#: [[File:AMC_Buyback_123.jpg|200px|thumb|none|Finalize Buyback]]

# Ensure the Buyback script has finalized prices. On the Inventory tab, the cells in Column F will contain a formula “=Market!Fx” if the Finalize Buyback script has not successfully run (as seen in the formula bar at the top when selecting a cell in column F) - run the script again. If the script has successfully completed, the formula bar will show a numeric value rather than a formula.

#: [[File:AMC Buyback 42.jpg|1000px|thumb|none|Ensure the Buyback script has finalized prices]]

# Share the spreadsheet (i.e. click the '''Share''' button in the upper right corner of the spreadsheet, then click "Change to anyone with the link", make sure the google doc isn't set to "restricted". Then click done).

# Create a contract to '''Ivy League Buyback''' with the applicable ore, ice and gas.

# There is no 6.

# Set the contract amount in the field "you will receive" to the amount shown in cell G1 of the '''Inventory''' sheet.

# Paste the spreadsheet key in the '''Description''' field of the contract:

#: (The field located between ""/d/*****/edit#"". See the image below.)

#: [[File:AMC_Buyback_6.jpg|500px|thumb|none|Finding the spreadsheet key]]

# Set the contract for 4 weeks expiration, then click finalize the contract.

# Wait to get paid.

==Reasons for your contract to be declined==

~~Supported station:~~ Slays - ~~Dairek~~'~~s Chateau~~

* The prices were updated and no longer match between the contract and the spreadsheet.

* The value and/or quantities do not match between the contract and the spreadsheet.

* The contract was submitted outside of Stacmon/Slays Or PC9-AY and T22-QI without the approval of a Supply Officer.

* The contract was not submitted from an NPC station or one of the '''Ivy League''' structures.

* The submission did not come via a Google Docs spreadsheet.

* The buyback contains minerals (Spreadsheet does not support minerals).

* The buyback contains Triglavian Ore (Spreadsheet currently does not support triglavian ores).

~~For Moon Ores, please use [[AMC Buyback Spreadsheet]]~~

== Slays - Moon Ore ==

Supported station: Slays - Dairek's Chateau

== Stacmon - Ice/Ore/Gas ==

Supported station: Stacmon - Furirams Furnace

~~For Moon Ores, please use [[AMC Buyback Spreadsheet]]~~

== Stacmon - General Buyback ==

@@ Line 1: / Line 1: @@
-{{eunispecific}}
 = HQ Buyback Service =
 The Buyback program is simply a way to sell your loot easily without the hassle of having to haul it to a trade hub yourself. You can use this program if you want to liquify your own assets from missions, salvaging, exploration, PI (or any other way of acquiring stuff you can think of), instead of having to haul it all to market and sell it yourself.
+== Current Mining Buyback Spreadsheet ==
+Current Version April 2022 (v6)
+[https://drive.google.com/open?id=1uG86UeJF8I2c2-gxZ_RhTXkzs9z-67bLnLpJpE5FcHA Buyback Spreadsheet]
+== Mining Buyback Spreadsheet Instructions==
+=== Filling the spreadsheet for personal Buyback ===
+====  Prepare the spreadsheet ====
+# Go to the [[#Current Mining Buyback Spreadsheet|current version]]. (Note: This link will only take you to the "Latest Version" section on the page.)
+# Log into your Google account.
+# Open the file menu and select "Make a Copy".
+# Name it following this convention.  For Personal use: "Your Name (DATE)" - e.g. Jefferson Spence (2014/11/18)
+==== Work on the spreadsheet ====
+# Make sure the ore/ice/gas that you'd like to submit is stacked.
+# On the '''Paste Inventory''' tab, select cell A4, and copy and paste these from your in-game inventory.<br />The "Icons" view in your inventory will not work for this. You need to use the "Details" or "List" view. ("Icon" is the only view that works if you have a NON-US settings in your local. Since "Details" and "List" only seem to work for them who has US as local)
+<font color="red">'''IMPORTANT:''' Make sure to have default column settings and number of columns (7).</font>
+==== Submit the Buyback ====
+:Follow the section [[#Submit the spreadsheet|Submit the spreadsheet]] below.
+----
+=== Using the spreadsheet in a shared can mining operation ===
-== Slays - Moon Ore ==
+While running a mining op the participation of the fleet members needs to be tracked in the sheet.
+====  Before the operation ====
+# Go to the [[#Latest Version|current version]]. (Note: This link will only take you to the "Latest Version" section on the page.)
+# Log into your Google account.
+# Open the file menu and select "Make a Copy".
+# Name it following this convention.  For Shared Can use: "SHARED CAN - FC-Name (DATE)" - e.g. SHARED CAN - Jefferson Spence (2014/11/18)
+# 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 to, and who to contract the ore to after the op.
+==== During the operation ====
+# Keep up with filling in the participation sheet with the start and stop times for each participant.
+# Per Uni policy everyone involved in the op should be 1.00 shared weight no matter their role unless they voluntarily agree to less.
+==== After the operation ====
+# At the end of the operation have all ore contracted to the Fleet Commander (or whoever will be submitting the buyback contract).
+# Make sure all the ore/ice/gas mined during the Shared Can is stacked.
+# On the '''Paste Inventory''' tab, select cell A4, and copy and paste these from the in-game inventory.<br />The "Icons" view in your inventory will not work for this. You need to use the "Details" or "List" view.
+# Add any additional raw ISK to the '''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 make sure to thank all those who participated in the op.
+==== Submit the Buyback ====
+:Follow the section [[#Submit the spreadsheet|Submit the spreadsheet]] below.
+==== After the Buyback is completed ====
+# As soon as the Buyback is completed and paid out, you need to pay the fleet members.
+# Open your spreadsheet again and go to the '''Participation''' tab.
+# Start to transfer the values in the "Payout (ISK)" column to the fleet members, and mark them accordingly in the "Paid?" column.
+# It is recommended to send out an EVE Mail to the fleet members as soon as you've done all the after work, including the payout.
+----
+=== Submit the spreadsheet ===
+Before you submit the Buyback you'll need to fix the current market prices into the spreadsheet, so that they won't be updated anymore. This is done in the second step below:
+# Change to the '''Inventory''' tab.
+# Select "Finalize Buyback" in the Buyback Menu. (Because this step uses a script, Google docs security settings may ask you to authorize the script to run.  Click the “Advanced” link on the pop up to enable the option to run the script, if this occurs).
+#: [[File:AMC_Buyback_123.jpg|200px|thumb|none|Finalize Buyback]]
+# Ensure the Buyback script has finalized prices.  On the Inventory tab, the cells in Column F will contain a formula “=Market!Fx” if the Finalize Buyback script has not successfully run (as seen in the formula bar at the top when selecting a cell in column F) - run the script again.  If the script has successfully completed, the formula bar will show a numeric value rather than a formula.
+#: [[File:AMC Buyback 42.jpg|1000px|thumb|none|Ensure the Buyback script has finalized prices]]
+# Share the spreadsheet (i.e. click the '''Share''' button in the upper right corner of the spreadsheet, then click "Change to anyone with the link", make sure the google doc isn't set to "restricted". Then click done).
+# Create a contract to <font color="white">'''Ivy League Buyback'''</font> with the applicable ore, ice and gas.
+# There is no 6.
+# Set the contract amount in the field "you will receive" to the amount shown in cell G1 of the '''Inventory''' sheet.
+# Paste the spreadsheet key in the '''Description''' field of the contract:
+#: (The field located between ""/d/*****/edit#"". See the image below.)
+#: [[File:AMC_Buyback_6.jpg|500px|thumb|none|Finding the spreadsheet key]]
+# Set the contract for 4 weeks expiration, then click finalize the contract.
+# Wait to get paid.
+==Reasons for your contract to be declined==
-Supported station: Slays - Dairek's Chateau
+* The prices were updated and no longer match between the contract and the spreadsheet.
+* The value and/or quantities do not match between the contract and the spreadsheet.
+* The contract was submitted outside of Stacmon/Slays Or PC9-AY and T22-QI without the approval of a Supply Officer.
+* The contract was not submitted from an NPC station or one of the <font color="white">'''Ivy League'''</font> structures.
+* The submission did not come via a Google Docs spreadsheet.
+* The buyback contains minerals (Spreadsheet does not support minerals).
+* The buyback contains Triglavian Ore (Spreadsheet currently does not support triglavian ores).
-For Moon Ores, please use [[AMC Buyback Spreadsheet]]
+== Slays - Moon Ore ==
+Supported station: Slays - Dairek's Chateau
 == Stacmon - Ice/Ore/Gas ==
 Supported station: Stacmon - Furirams Furnace
-For Moon Ores, please use [[AMC Buyback Spreadsheet]]
 == Stacmon - General Buyback ==