|
|
| 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 freindly 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 ====
| |
| − | *You can ether use the Inventory or Paste Inventory tabs.
| |
| − | :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.
| |
| − | :On the Paste Inventory tab you need to stack your ores and copy and paste to cell A4 what you'd like to add to the Buy-Back.
| |
| − | :The "Icons" view in your inventory will not work for this. You need to use the "Details" or "List" view.
| |
| | | | |
| − | ==== 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.
| |
