|
|
| Line 123: |
Line 123: |
|
| |
|
| It may be worth noting that there are often ISK rewards offered by Solitude residents for any H2H wormholes published on the Solitude.Euni mailing list (check the Solitude forum for latest info on this). | | It may be worth noting that there are often ISK rewards offered by Solitude residents for any H2H wormholes published on the Solitude.Euni mailing list (check the Solitude forum for latest info on this). |
|
| |
| =The Spreadsheet=
| |
|
| |
| The new version of the spreadsheet has two main sheets/tabs (plus a tab with a list of pilots).
| |
|
| |
| If you experience problems with the spreadsheet, please post your problem to the [http://forum.eveuniversity.org/viewtopic.php?f=218&t=80131 Forum Thread].
| |
|
| |
| ==Input Sheet==
| |
| This sheet is an optional shortcut way of collecting and entering the data from your scans.
| |
|
| |
| Instructions are included in the sheet - but in short, do the following '''in order''':
| |
| #Select the system from the dropdown.
| |
| #Select your name from the Pilot dropdown. (Add yourself to the Pilots tab, if this is your first time.)
| |
| #Wait for the main area to blank itself, and then cut-and-paste the lines from your Probe Scanner window. (Regular Ctrl-C to Copy as usual.)
| |
| #Add some notes if needed, such as the type of WH.
| |
| #Then set the state to Finished.
| |
| And it will (should!) auto-populate the appropriate row in the main sheet.
| |
|
| |
| ==The Main sheet==
| |
|
| |
| ===Instructions===
| |
| If you use the Input Sheet, you should not need to edit this sheet manually at all.
| |
| However, some people prefer to edit it directly - but if you do so, please use the format described below, and as should be evident in the rest of the sheet.
| |
|
| |
| If you do edit it directly, you should do the following:
| |
| #Put yourself into column E.
| |
| #Put your full name into column F.
| |
| #Delete the contents of the date field in column G. It will auto-fill with the current time.
| |
| #Enter the result of your scans into column I.
| |
| #When you're done with that system, clear column E.
| |
|
| |
| '''NEVER SORT THE SPREADSHEET'''
| |
|
| |
| ===Column/Data format===
| |
| Columns A,B,C & D describe the Constellation / Security Status and System. Never edit these.
| |
|
| |
| Column E : Currently being scanned, if a system is actively being scanned you can see the initials of who is performing the current scan.
| |
|
| |
| Column F & G : shows you the who and what date/time the system was scanned.
| |
|
| |
| Column H : Automatically shows time since last Scan with a colour code Green (0-10hrs unlikely to have changed), Amber (10-24hrs may have changed), Red (24hrs+, definitely changed). Never edit this.
| |
|
| |
| Column I : Scan Results - Only record Cosmic Signatures, with format of the 3 digit ID, and very brief Description. Use // as a separator. <br>
| |
| e.g. A System with 2 Signatures: BQE-245 a K162 Wormhole to "unknown space" & HAP-812 a Gas Site; would be entered as:
| |
| 245-WH K162 C1-C3 // 812-GAS Calabash Nebula
| |
|
| |
|
| =Bookmarking= | | =Bookmarking= |
