ABCDEFG
1
2
Maintained by:Hevlikn Ilunar
3
Discord:Hevlikn#4869
4
FIO Public Data Import
5
6
7
This series of sheets facilitates the importing of Dynamic data into Google Sheets (and by extension Excel or other spreadsheet apps).
8
9
10
You do not need to copy this to your own Drive.
11
Copies will require their own instance of the script running.
12
13
Please Use Sheet Index to find most suitable import for you
14
15
16
17
Some historical imports are being deprecated in favour of .../csv/... endpoints
18
19
20
21
22
Script will continue to run for json parsing of sheets without suitable direct import
23
24
25
26
27
Additionally, =importrange() is value-only, meaning you, the user, are isolated from potentially malicous (or in my case, shoddy) code. I will not be liable for any injuries caused by running or viewing the script in your own instance.
28
29
30
31
Links:
32
PrUn Community Tools
https://discord.gg/advAU9mCUk
33
Discord server to discuss FIO, and other meta-game tools, such as this.
34
35
FIOhttps://fio.fnar.net/
36
Web-app, and extension that allow us access to this data; consider installing the extension and contributing to the data gathered.
37
38
39
FIO REST Documentation
https://doc.fnar.net/
40
For detailed information on what data is available.
41
42
Planet Surveyhttps://docs.google.com/spreadsheets/d/1DEdjT23XCx8BmLvc_lihKkYY3qLR-HZxe5KkNqMqWWo/edit?usp=sharing
43
Another Spreadsheet adopted by me; search for planets and their resources.
44
45
Excel User Guide
https://www.excell-en.com/link-google-sheets-to-excel-tutorial
46
Instructions for how to get this data into Excel, via a CSV data file
47
48