Thanks for the info fine without the macros.. use Libre and wouldnt try to figure them out anyway. For those this anal is there any mod at all that gives us better waypoints/saves the colors don't even match up, and there seems to be no planet or system note options... anything at all? Flying in the stars and cant even put a note on a save point...
Hello, thank for this nice spreadsheet and your work.
Have I overlooked where to enter the galaxy?
Unfortunately, the macros do not work properly in LibreOffice. When I click on the button "add system" an error message appears, like "Object variable not used". Error message picture
I also have an error message about a missing external file (file:///D:/download/New version of Template with VBA Macro/NoMansSky.xlsx).
Do you have plans to make this worksheet available for Google sheets as well? That would be absolutely fantastic ;)
Luckily I discovered the "lists" and can translate the terms into german.
Hello, Sorry to be so slow responding. I'm sorry you have had problems using the spreadsheet. I'm not familiar with LibreOffice. I don't plan to convert the spreadsheet to Google sheets, I have an irrational distrust of cloud services.
I haven't played No Man's Sky recently or looked at the spreadsheet so my memories are foggy. The next time I open the spreadsheet I'll take a look at the section of the macro you are getting the error in. It's possible adding an additional declaration of some kind could fix that issue. The section where that error has occurred is actually redefining the cells that are part of a named range which is probably used to populate Validation lists in cells.
Most of the Macros are for convenience. Only the ones that make changes to the structure of the worksheets are important and those can be replicated manually by copying an existing section and inserting it at the bottom of the list.
I've added a new version, version 5a. This version has a number of changes, among them are a number of simple VBA Macros to help automate some of the tables and worksheets.
For example, rather than pre-formatting 100s of systems on the Systems worksheet, I've formatted that sheet so it starts with three blank systems. You can add additional system by clicking the "Add New System" button at the top of the sheet. Since the Systems worksheet has so many columns in use (close to 200) I set up macros to hide and unhide specific sections as needed.
This is really useful, thanks. I was looking for something to track what's available in each galactic trade in each space station. Is that buried in there too where I haven't seen it, or does that change too often to not make that useful?
Hello, Yes that information is there, it is off to the far right. There are seven cells with dropdowns with some of the resources that are not at all stations. You can also freely type in those cells. I've found them particularly useful to keep up with which station have di-hydrogen gel and Tritium for sale.
I have a version I'm working with right now that I've put macros in which hides and unhides groups of columns to make navigation easier. Once I've tested it a bit more I'll make it available. It also has a macro to aid in changing the axis settings on the plot.
I'm not particularly satisfied with the Companions portion but not sure how to alter it yet. I'll most likely just remove the columns for critters you can't tame which will leave more area just to type in comments for each planet's critters.
There are also columns off to the right where I have formulas which build a list of planet types vs stellar types with the intention of creating a pivot table or report to show the frequency of each type of environment versus each type of sun. Not sure how useful it would be but might be interesting.
Hi Chem, thanks for the spreadsheet I was contemplating making one myself but never got around tuit. Re the Map co ords ... what are u using for the x and y as the signal booster co ords are way off the mark?
I created that worksheet and plot to help with planetary navigation, etc. I also wanted to see if there was a pattern to certain building locations but I never got enough points on a single planet :). When using the visor look at the righthand side of the screen, you'll see: Local Data Current Time: Current Location: YY.YY, XX.XX
when you are in a vehicle the coordinates are at the bottom left of the display.
The coordinates used are the ones you see when looking through your visor or when you are in a vehicle. The coordinates are also shown while in your ship but are not of much use when "recording" where something it.
The filters are quite helpful for the plot. If you select one planet, all the other points will be hidden and removed from the plot. You can add as many points to the list as you like as long as you insert rows above the bottom of the list.
I want to thank everyone for the feedback and to apologize for some of the silly errors. This was a spreadsheet I'd been using and adapting for myself when it dawned on me that others might find it useful.
First, here is what I intended to do for version 401:
- Remove all references to external files
- Remove VBA code in one of the worksheets
- Set the workbook to a non-macro enabled format
- Added some missing economy types to the validation lists and lookup tables
- Added some missing calculations for the "Secondary Resources of Note" section on the Systems worksheet
I've started working on Version 402. It's 402 and not 4_02 or 4.02 because Nexus won't let me put an underscore in the version and I don't want to use a period in the filename to avoid problems with Windows file extensions). Here's what I've got so far for 402:
Corrected the conditional formatting in the Frigate Fleet table so that only Column B is conditionally formatted based on Frigate grade (pointed out by vita777).
Removed the conditional formatting in the Vendor section on the Systems worksheet (columns DM through EO) and used standard pallete formatting. This was causing some rather large problems with the rows being seen as separate formats. This change should greatly improve load times and lag (thanks to vita777).
Fixed the cells that should have been merged but weren't in the Vendor section of the Systems worksheet (thanks to vita777).
Added the additional climate types that come from the Infested Biome. Some of these names are a bit ambiguous. A number of them in-game are just listed as "Infested". The validation list include six entries for this, the general "Infested" which will return a Planet Category of "<Several>". Once you've visited the planet and can better identify the climate there are "Infested (Frozen), Infested (Toxic), Infested (Barren), Infested (Scorched), Infested (Irradiated) to chose from. Each of these will return the generic Planet Category such as Frozen or Barren. You can also choose to enter a value of your choosing in the Planet Type column (I disabled the validation error) and the Planet Category will show "<Unknown>" if you enter a Planet Type not in the lookup list.
Removed the cells with "Sum:" in them in the Vendor section as they only calculated for the first system. Instead made them headings for "Grade".
Reduced the number of Systems formatted for on the Systems worksheet to 130, this should help with load times and performance. Note: There is a way to add more if you need them and maintain the lists and tables at the same time. You have to be careful. Here are the steps:
Highlight all the rows of one system above the last one
Right-click and Copy
Click on first row of a system above the last one
Right-click and Insert copied cells
Doing this will ensure the named ranges that create the tables for validation and lookups include all of the rows. Please note, if you go past the previous maximum of 500 the validation and lookups won't work with those after 500. I have removed error messages from the cell validation so you can just type system names and such if you wish.
Special Note: There are formulas in the cells in column FV through FZ that are not used. These were me beginning to work on determining statistics for what types of planets were found most in which types of Stellar System. If you wish feel free to delete these columns, it will cause no issues. I haven't deleted them because I may still use them.
I just did the change number 2 mentioned by you above in addition to the one mentioned by me in one of the bug reports (Conditional Formatting, the ~24k predefined format templates) and the file is loading up within 5-6 seconds now instead of the initial 23-24 seconds =)
I'm currently doing some Quality Assurance on the new version before I upload it. I'm moving the 84 systems that are in my old version to the template version.
I just uploaded version 401 of the spreadsheet which takes into account all the issues you folks have pointed out.
Thanks :)
PS. PLEASE be careful if you move data from one version to the other. Copying of cells should be done carefully to avoid any unwanted changes to formulas and such.
Thanks a lot for all the work. Two new bug reports and possible solutions submitted :) Have a nice time of the day
Edit: Third report created, this time an performance hitting issue Edit 2: Added some performance increasing informations to the performance hitting issue report. The improvement is real, worth to take a closer look at the issue in your Excel :)
I love this. I have always wanted a way to do a good 'exploration' challenge, and this provides a fantastic template to structure that around. I've only had the game 9 months or so but have 900 hours in. The whole time I have wanted a good way to record the journey without having to keep using the crappy notebook I've been using. I even developed a Universal Planetary Profile to prefix to planets and systems so I could note some of the things you're tracking.
So, this is awesome. Thanks for the work in doing and thanks even more for sharing it.
Hello, the Spreadsheet is rly great so far, but i ran into a little problem there i am unable to fix without your help:
The provided file is reffering to an external Source, the "NoMansSky.xlsx" which must be containing most if not all defined names. I found a planet hour ago with "Manufacturing" Economy Type, which is not a part of the corresponding dropdown list. The list itself is reffering to "BusinessList" ($LISTS.$K$3:$K$24) and using a LOOKUP in "EconomyTable" ($'Climate Types'.$F$3:$G$26)
Could you maybe fix it or provide the missing NoMansSky.xlsx so ppl could polish your Spreadsheets themselves? :)
Thank for downloading the file. I'm working on an updated version V4_01 which contains the additional economy types as well as adding the calculations in the "Secondary Resource" area for Carbon and Basalt. I've been working around that issue so long myself I completely forgot to add the additional items to the table. The lookup tables are on two worksheets that are hidden The "EconomyTable" is on a Sheet called "Climate Types" The "BusinessList" is on a Sheet called "Lists"
There shouldn't be any references to additional files. I'll check for links and make sure.
There were indeed two unused "Range Names" that referenced an additional Excel file. I have deleted them.
Thanks for your reply and the hint about hidden tables. Seems like i got pretty rusty in excel over the course of the past 7 years and totaly did miss the fact, that 5 tables were hidden there :D
If i find more strange looking or missing things, i will report back here or in the bug section. Having lots of fun using the file right now =)
I did find two unused Range Names that referred to external files. I've deleted those.
If you want to add entries to the tables on the hidden worksheets, be sure to "Insert" rows in the middle of the table so the new rows will be included in the named range. You can highlight the table and sort once you are satisfied.
I hid the sheets because I wanted to reduce the number of tabs at the bottom of the screen :).
I can see a total of 6 NameRanges entries refering to an external source.
REFINING table: PlanetTypeList (reffering to NoMansSky.xlsx'#$'Climate Types'.$A$3:$A$158) PlanetTypeTable (reffering to NoMansSky.xlsx'#$'Climate Types'.$A$3:$B$158) Recipes table: PlanetTypeList (reffering to NoMansSky.xlsx'#$'Climate Types'.$A$3:$A$158) PlanetTypeTable (reffering to NoMansSky.xlsx'#$'Climate Types'.$A$3:$B$158) Global NameRanges: ItemNames (reffering to NoMansSky.xlsx'#$'Sale Total'.$I$4:$I$23) ItemPriceTable (reffering to NoMansSky.xlsx'#$'Sale Total'.$I$4:$J$23)
The last two are unused as far as i can see (most likely the ones you removed), the first two should be made global, number 3 and 4 can be removed then. Should fix the external refferences fully that way.
In the Table "Systems" the Column J (Planet Type) can be made dropdown using that "PlanetTypeList" NameRange, would save a lot of writing for all users then :)
I'm sorry about that. The information I found said it "should" open. I didn't spend a lot of time looking to see if there are specific features that might prevent it from opening. If you are aware of any issues like that let me know and I'll see if I used them.
I downloaded the spreadsheet and opened it with LibreOffice 6.4.7.2 (64-bit). Navigated the entire (massive) document and all tabs with no problems. LibreOffice disabled automatic remote links and macros on loading, as a safety precaution. You can easily allow those items to function. It appears to be fully functional with LibreOffice, which is actually the successor to the older OpenOffice software.
Thank you. Someone else mentioned the remote link, there shouldn't be one so if there is that's an error I'll fix it.
And your LibreOffice is correct, I checked and there was a macro in one of the sheets. I've deleted it from V4_01 which I'll upload in the next couple days. I've saved the new version as a non-macro enabled file.
26 comments
Are you asking about a way to make notes within No Man's Sky?
thank for this nice spreadsheet and your work.
Have I overlooked where to enter the galaxy?
Unfortunately, the macros do not work properly in LibreOffice.
When I click on the button "add system" an error message appears, like "Object variable not used".
Error message picture
I also have an error message about a missing external file (file:///D:/download/New version of Template with VBA Macro/NoMansSky.xlsx).
Do you have plans to make this worksheet available for Google sheets as well? That would be absolutely fantastic ;)
Luckily I discovered the "lists" and can translate the terms into german.
Edit: Found galaxy option in the macro version
Sorry to be so slow responding. I'm sorry you have had problems using the spreadsheet. I'm not familiar with LibreOffice. I don't plan to convert the spreadsheet to Google sheets, I have an irrational distrust of cloud services.
I haven't played No Man's Sky recently or looked at the spreadsheet so my memories are foggy. The next time I open the spreadsheet I'll take a look at the section of the macro you are getting the error in. It's possible adding an additional declaration of some kind could fix that issue. The section where that error has occurred is actually redefining the cells that are part of a named range which is probably used to populate Validation lists in cells.
Most of the Macros are for convenience. Only the ones that make changes to the structure of the worksheets are important and those can be replicated manually by copying an existing section and inserting it at the bottom of the list.
For example, rather than pre-formatting 100s of systems on the Systems worksheet, I've formatted that sheet so it starts with three blank systems. You can add additional system by clicking the "Add New System" button at the top of the sheet. Since the Systems worksheet has so many columns in use (close to 200) I set up macros to hide and unhide specific sections as needed.
Yes that information is there, it is off to the far right. There are seven cells with dropdowns with some of the resources that are not at all stations. You can also freely type in those cells. I've found them particularly useful to keep up with which station have di-hydrogen gel and Tritium for sale.
I have a version I'm working with right now that I've put macros in which hides and unhides groups of columns to make navigation easier. Once I've tested it a bit more I'll make it available. It also has a macro to aid in changing the axis settings on the plot.
I'm not particularly satisfied with the Companions portion but not sure how to alter it yet. I'll most likely just remove the columns for critters you can't tame which will leave more area just to type in comments for each planet's critters.
There are also columns off to the right where I have formulas which build a list of planet types vs stellar types with the intention of creating a pivot table or report to show the frequency of each type of environment versus each type of sun. Not sure how useful it would be but might be interesting.
thanks for the spreadsheet I was contemplating making one myself but never got around tuit.
Re the Map co ords ... what are u using for the x and y as the signal booster co ords are way off the mark?
I created that worksheet and plot to help with planetary navigation, etc. I also wanted to see if there was a pattern to certain building locations but I never got enough points on a single planet :). When using the visor look at the righthand side of the screen, you'll see:
Local Data
Current Time:
Current Location: YY.YY, XX.XX
when you are in a vehicle the coordinates are at the bottom left of the display.
The coordinates used are the ones you see when looking through your visor or when you are in a vehicle. The coordinates are also shown while in your ship but are not of much use when "recording" where something it.
The filters are quite helpful for the plot. If you select one planet, all the other points will be hidden and removed from the plot. You can add as many points to the list as you like as long as you insert rows above the bottom of the list.
I want to thank everyone for the feedback and to apologize for some of the silly errors. This was a spreadsheet I'd been using and adapting for myself when it dawned on me that others might find it useful.
First, here is what I intended to do for version 401:
I've started working on Version 402. It's 402 and not 4_02 or 4.02 because Nexus won't let me put an underscore in the version and I don't want to use a period in the filename to avoid problems with Windows file extensions).
Here's what I've got so far for 402:
Special Note: There are formulas in the cells in column FV through FZ that are not used. These were me beginning to work on determining statistics for what types of planets were found most in which types of Stellar System. If you wish feel free to delete these columns, it will cause no issues. I haven't deleted them because I may still use them.
I just did the change number 2 mentioned by you above in addition to the one mentioned by me in one of the bug reports (Conditional Formatting, the ~24k predefined format templates) and the file is loading up within 5-6 seconds now instead of the initial 23-24 seconds =)
Thanks :)
PS. PLEASE be careful if you move data from one version to the other. Copying of cells should be done carefully to avoid any unwanted changes to formulas and such.
Edit: Third report created, this time an performance hitting issue
Edit 2: Added some performance increasing informations to the performance hitting issue report. The improvement is real, worth to take a closer look at the issue in your Excel :)
So, this is awesome. Thanks for the work in doing and thanks even more for sharing it.
the Spreadsheet is rly great so far, but i ran into a little problem there i am unable to fix without your help:
The provided file is reffering to an external Source, the "NoMansSky.xlsx" which must be containing most if not all defined names. I found a planet hour ago with "Manufacturing" Economy Type, which is not a part of the corresponding dropdown list. The list itself is reffering to "BusinessList" ($LISTS.$K$3:$K$24) and using a LOOKUP in "EconomyTable" ($'Climate Types'.$F$3:$G$26)
Could you maybe fix it or provide the missing NoMansSky.xlsx so ppl could polish your Spreadsheets themselves? :)
Thanks in advance
The "EconomyTable" is on a Sheet called "Climate Types"
The "BusinessList" is on a Sheet called "Lists"
There shouldn't be any references to additional files. I'll check for links and make sure.
There were indeed two unused "Range Names" that referenced an additional Excel file. I have deleted them.
If i find more strange looking or missing things, i will report back here or in the bug section. Having lots of fun using the file right now =)
If you want to add entries to the tables on the hidden worksheets, be sure to "Insert" rows in the middle of the table so the new rows will be included in the named range. You can highlight the table and sort once you are satisfied.
I hid the sheets because I wanted to reduce the number of tabs at the bottom of the screen :).
REFINING table:
PlanetTypeList (reffering to NoMansSky.xlsx'#$'Climate Types'.$A$3:$A$158)
PlanetTypeTable (reffering to NoMansSky.xlsx'#$'Climate Types'.$A$3:$B$158)
Recipes table:
PlanetTypeList (reffering to NoMansSky.xlsx'#$'Climate Types'.$A$3:$A$158)
PlanetTypeTable (reffering to NoMansSky.xlsx'#$'Climate Types'.$A$3:$B$158)
Global NameRanges:
ItemNames (reffering to NoMansSky.xlsx'#$'Sale Total'.$I$4:$I$23)
ItemPriceTable (reffering to NoMansSky.xlsx'#$'Sale Total'.$I$4:$J$23)
The last two are unused as far as i can see (most likely the ones you removed), the first two should be made global, number 3 and 4 can be removed then. Should fix the external refferences fully that way.
In the Table "Systems" the Column J (Planet Type) can be made dropdown using that "PlanetTypeList" NameRange, would save a lot of writing for all users then :)
Some of the excel rust is getting removed :D
Thanks,
Someone else mentioned the remote link, there shouldn't be one so if there is that's an error I'll fix it.
And your LibreOffice is correct, I checked and there was a macro in one of the sheets. I've deleted it from V4_01 which I'll upload in the next couple days. I've saved the new version as a non-macro enabled file.