|
|
(3 intermediate revisions by one other user not shown) |
Line 1: |
Line 1: |
− | == Overview ==
| |
− | This is a try to have a buyback program for '''ORE''' in the NSC pocket.<br />
| |
− | The credit for the spreadsheet and all the instructions goes to [[Amarr Mining Campus|AMC]].<br />
| |
− | Spreadsheet is based on the AMC buyback spreadsheet with some changes in tax and ofcourse refine value.<br />
| |
− | '''This will begin with a 2 week trail period'''<br />
| |
− | After the trail i will reevaluate the result and see if i can continue this program
| |
− | Maximum for a contract will be set at 500,000,000 isk
| |
− | == Latest version ==
| |
− | Current Version 2016-03-NSC-ORE<br />
| |
− | Updated Mars 2016<br />
| |
− | The latest version is available at:<br />
| |
− | [https://docs.google.com/spreadsheets/d/1pkN_tbrPnJQ4_8YE3oiGKaZ9pqfYE4IYKMyEo08mEsk/edit?usp=sharing NSC Buyback ORE]<br />
| |
| | | |
− | '''<big>Notes</big>'''<br />
| + | == Who Am I == |
− | I will not accept any submissions that have not come via a Google Docs spreadsheet.<br />
| + | Hi and welcome to my page<br /> |
− | == Instructions ==
| + | I am Mike your friendly builder of ships and other modules<br /> |
− | === Filling the Spreadsheet for personal Buy Back ===
| + | <br /> |
| + | Got experience from AMC with mining ICE and ORE in high sec after 6 month in AMC i wanted a new challange that had something to do with mining and production.<br /> |
| + | So i moved some of my assets to NSC for some Nullsec mining and i havent left yet. |
| | | |
− | ==== Prepare the spreadsheet ====
| + | Bora has appointed me Manufacuring Officer<br /> |
− | # Go to the [[#Latest Version|current version]]
| + | This means i make T1 hulls for the SRP program so if you get a ship from the SRP in the next few weeks it is a '''Tide production''' |
− | # Log into your google account and go to the current version.
| |
− | # Open the file menu and select "Make a Copy"
| |
− | # Name it following this convention. For Personal use: "PLAYERNAME (DATE)" e.g. Mike Eventide (03/03/2016)
| |
− | ==== 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 ====
| + | If you have any questions about Industry let it be Mining/PI/Production/Research dont hesitate to ask |
− | Follow the section [[#Submit the spreadsheet|Submit the spreadsheet]] below.
| |
− | === 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"
| |
− | # When the spreadsheet shows the message "Finished script" go back to the menu item "Buyback" and select "Prepare BuyBack"
| |
− | # To confirm the preparation 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" & "Prepare BuyBack" 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"
| |
− | # When all above is done you need to issue the 'Private' 'Item Exchange' contract to '''Mike Eventide''' at a station that is applicable for Buy-Back service.
| |
− | #:Always make sure that all ore is stacked before setting up the contract.
| |
− | #:Preferred stations are stations within NSC pocket
| |
− | #:Set the Expiration time to the longest value (2 weeks).
| |
− | # 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 .../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 and go on to the [https://docs.google.com/forms/d/1ZZKIfqSCdhiXdc3_yT0JDEH9fKNZ9wpVsYg9LbPfuwI/viewform NSC Buyback Submisson] Form and add the required information to finish your Buy-Back
| |
− | # Submit and relax, the ISK will be added to your wallet soon.
| |