test content
Logo
What is the Arc Client?
Install Arc
STO: Ship Planning Assistant
yamashiro1
Member Posts: 15 Arc User
Hello community.
I originally put this in the Fed shipyard section of the forum but someone suggested that I post it here.
I have a little creation I made up that I want to share with you. I played STO back in the early days in beta and then after it went live. I hit max level and quit after a couple of months. Now 2-3 years later I have returned to find a lot of new stuff in the game and there is a lot to look at especially around managing your ship. So with that in mind and because I found myself in a place where I had a lot of free time but not much ability to actually play (or do anything else) I decided to make up a tool to help me manage my ship(s).
Presenting the: "Star Trek Online Ship Planning Assistant" (intro version)
What it is:
This tool is designed to help you manage your ship and bridge officer assignments as well as help you compare equipment amongst all the space item sets out there. This tool is designed for end game and thus only the highest end game items are included and the tier 5 end game ships.
How it works:
Basically it is a database of in game ships, bridge officer abilities and space item set details. The parts that the user is to fill in are coloured light grey. The rest is automated.
1) You can download it from the links at the bottom or here:
https://drive.google.com/folderview?id=0B5Y4PweG9K0ObmpQLXRPdG5ZUE0&usp=sharing
2) First of all you need to select your faction and then your ship which is found in Section 1. Once this is complete the stats for the ship you selected will appear in the spread sheet. This can help you look at the different ships and their stats as well as serve as the basis for the rest of the planning tool.
3) Once you have selected your ship you then need to input in your bridge officer details which are found in Section 2. This will be a bit of a manual process but there are drop down menus to help you fill in the details.
4) Once this is done then you are able to setup and change your bridge crews. This is done in section 3. There are three bridge crew option sets that allow you to compare different setups against each other or just record down what each setup is for so that you can easily refer back to the settings in the spread sheet and change them in game. This hopefully makes bridge officer management easier.
5) The last section of the planner helps you compare 2 space sets side by side to see that differences. I built this to help me understand the sets in more detail and to be able to compare them.
Future Plans:
Depending on how much time I have I plan to add more to this tool later and improve on it. I plan on looking at DOFFs next and seeing if I can add them in as well. Later I would like to get into the details around weapon and gear setups but that will take time given the vast number of options out there. For now the tool should help with basics at least. Enjoy and feel free to provide any feedback.
Disclaimers:
1) all data from sourced from the Wiki and it was the best that was available.
2) while I have checked this application as much as I can there are bound to be bugs and errors so let me know if you find any.
Enjoy,
Mirei Narumia
https://drive.google.com/folderview?id=0B5Y4PweG9K0ObmpQLXRPdG5ZUE0&usp=sharing
I originally put this in the Fed shipyard section of the forum but someone suggested that I post it here.
I have a little creation I made up that I want to share with you. I played STO back in the early days in beta and then after it went live. I hit max level and quit after a couple of months. Now 2-3 years later I have returned to find a lot of new stuff in the game and there is a lot to look at especially around managing your ship. So with that in mind and because I found myself in a place where I had a lot of free time but not much ability to actually play (or do anything else) I decided to make up a tool to help me manage my ship(s).
Presenting the: "Star Trek Online Ship Planning Assistant" (intro version)
What it is:
This tool is designed to help you manage your ship and bridge officer assignments as well as help you compare equipment amongst all the space item sets out there. This tool is designed for end game and thus only the highest end game items are included and the tier 5 end game ships.
How it works:
Basically it is a database of in game ships, bridge officer abilities and space item set details. The parts that the user is to fill in are coloured light grey. The rest is automated.
1) You can download it from the links at the bottom or here:
https://drive.google.com/folderview?id=0B5Y4PweG9K0ObmpQLXRPdG5ZUE0&usp=sharing
2) First of all you need to select your faction and then your ship which is found in Section 1. Once this is complete the stats for the ship you selected will appear in the spread sheet. This can help you look at the different ships and their stats as well as serve as the basis for the rest of the planning tool.
3) Once you have selected your ship you then need to input in your bridge officer details which are found in Section 2. This will be a bit of a manual process but there are drop down menus to help you fill in the details.
4) Once this is done then you are able to setup and change your bridge crews. This is done in section 3. There are three bridge crew option sets that allow you to compare different setups against each other or just record down what each setup is for so that you can easily refer back to the settings in the spread sheet and change them in game. This hopefully makes bridge officer management easier.
5) The last section of the planner helps you compare 2 space sets side by side to see that differences. I built this to help me understand the sets in more detail and to be able to compare them.
Future Plans:
Depending on how much time I have I plan to add more to this tool later and improve on it. I plan on looking at DOFFs next and seeing if I can add them in as well. Later I would like to get into the details around weapon and gear setups but that will take time given the vast number of options out there. For now the tool should help with basics at least. Enjoy and feel free to provide any feedback.
Disclaimers:
1) all data from sourced from the Wiki and it was the best that was available.
2) while I have checked this application as much as I can there are bound to be bugs and errors so let me know if you find any.
Enjoy,
Mirei Narumia
https://drive.google.com/folderview?id=0B5Y4PweG9K0ObmpQLXRPdG5ZUE0&usp=sharing
Post edited by yamashiro1 on
0
Comments
Try this:
https://drive.google.com/folderview?id=0B5Y4PweG9K0ObmpQLXRPdG5ZUE0&usp=sharing
I have also updated the main post as well.
just checked excel vlookup has no data so all cells are N/A and faction is the only dropdown selector.
Any feedback?
I hope you are enjoying it.
Anyway the devs said they're planning on introducing them in the near future.
I have amended and fixed up the Ship Planning Assistant over the last few days with the following enhancements:
1) tier 5 cross faction ship data has been added in
2) duty officer data and types have been added in allowing for you to plan your ship out better.
You can find it here alongside the original so feel free to download it:
https://drive.google.com/folderview?id=0B5Y4PweG9K0ObmpQLXRPdG5ZUE0&usp=sharing
Have fun.
Skill Effects Table from Amicus might be useful in such an endeavour.
Good work so far!
Taskforce 47 Falkenwacht (Federation) / Greifenreiter (KDF)
(at) deianirrah
Free Gear and where to get it
I was able to choose the faction and a ship, but everything below shows N/A and not sure what would be next step.
Btw, I'm using open office 3.4.1
http://www.youtube.com/watch?v=2C4p9-1Jrjs
Visit my youtube channel http://www.youtube.com/user/Akurie369?feature=watch
Captain Bi Shonen's official Thread! http://sto-forum.perfectworld.com/showthread.php?p=22866531#post22866531
1. It is best to download from Google docs and use it your PC. That is the best way.
2. If you are seeing #N/A after entering in and selecting the bridge and duty officers try to press F9 it will refresh the sheet and calculate everything.
3. Entertainer is there under the "civilian" officer type. Gravimetric scientist is missing though and I will have to add it. Thanks for letting me know.
I was trying to find the threads this guy started today using the search tool. Turns out they've all been DELETED! Rightly so, but the forum search showed that be'd posted in this thread, which I missed completely. I've been recording this kind of stuff by hand recently so that I can tweak while setups while I can't play, so the title caught my eye.
Very nice!!!!
Is it in the plans to be able to enter multiple equipment sets (Dyson Set & Protonic Arsenal for example) or mix-and-match set pieces (MACO Deflector & Engine with Solanae Shield & Warp Core with Protonic Arsenal for example)? A "Summary" field that compiles all the modifiers would be handy, too.
In the meantime, this is great! Thank you for all thd hard work you've put into this!!
And thanks fo heartsinatlantis for leading me here... I guess...
downloaded it and opened it and with excel 2010 professional.
and still n/a
and refreshed it and it doesn't changed.
thanks