This Research & Development spreadsheet is designed to help players see the requirements for R&D projects. The goal is to be able to see quickly what components or materials a specific project will require.
Link: http://bit.ly/STORnD
This is a Google Spreadsheet, so you will need to make your own copy to use it.
Enjoy!
Latest ChangesV2.4
- Added the Pilot Officer Training items.
- Added the consumable items.
- Added the new Hyper-Capacitor Shield Array.
- Split Fed and KDF R&D doffs into separate sheets.
- The doff lists now show where each is found, and if they are bound on pickup.
- Added list of Fixed Upgrade Mods. This is an "in progress" thing.
- Streamlined the way quantity material requirements are calculated.
A full list of changes is available in the spreadsheet.
We are also opening packs on Tribble, and recording the results to see the drop rates:
http://bit.ly/STORnDPacks
You can see the [Mod] results for large quantities of crafted Mk II items (some upgrades too) at:
http://bit.ly/STORnDMods
Comments
Can you add a list of where the VR's are obtainable from?
Borg Space - Trellium K
Borg Ground -
Undine Space - Argonite Gas
Undine Ground - Dentarium
Once we have a complete list, those are going in.
STO Resources: <Ship Comparison - All Tiers + Small Craft + Hangar Pets> <Damage Resistance>
<R&D + Upgrade Costs> <Duty Officer Finder> <Suliban Doff Reqs> <Fleet Costs> <Rep Costs>
<Keybind Tour the Galaxy> <Fleet / Armada Management> <Currency Exchange> <Other STO Links>
Borg Space - Trellium K
Voth Space - Trellium K (Working As Intended)
Borg Ground - Plekton
Undine Space - Argonite Gas
Undine Ground - Dentarium
There is currently NO mission that drops Crayon. The only source available is C-Store, as the Voth Space missions, which allegedly should drop it, don't.
I think that is far beyond the scope of this spreadsheet. Our goal is just to list the materials required for all the available projects. Listing every potential outcome for every variation of every project would take a very long time, not to mention stats like those on engines or shields will vary depending on the ship. Someone someday might attempt it, but not me!
STO Resources: <Ship Comparison - All Tiers + Small Craft + Hangar Pets> <Damage Resistance>
<R&D + Upgrade Costs> <Duty Officer Finder> <Suliban Doff Reqs> <Fleet Costs> <Rep Costs>
<Keybind Tour the Galaxy> <Fleet / Armada Management> <Currency Exchange> <Other STO Links>
Highly appreciated!
Any plans to add the C-store R&D box results to your lockbox statistics spreadsheets?
STO Resources: <Ship Comparison - All Tiers + Small Craft + Hangar Pets> <Damage Resistance>
<R&D + Upgrade Costs> <Duty Officer Finder> <Suliban Doff Reqs> <Fleet Costs> <Rep Costs>
<Keybind Tour the Galaxy> <Fleet / Armada Management> <Currency Exchange> <Other STO Links>
Fixed that for you.
Craylon Gas - Unknown location (C-store possible)
Radiogenic Particle - Crystalline Catastrophe Elite
These are the other unknown VR materials, with no idea of their drop locations.
Praetor of the -RTS- Romulan Tal Shiar fleet!
just did it for confirmation
#LegalizeAwoo
A normie goes "Oh, what's this?"
An otaku goes "UwU, what's this?"
A furry goes "OwO, what's this?"
A werewolf goes "Awoo, what's this?"
"It's nothing personal, I just don't feel like I've gotten to know a person until I've sniffed their crotch."
"We said 'no' to Mr. Curiosity. We're not home. Curiosity is not welcome, it is not to be invited in. Curiosity...is bad. It gets you in trouble, it gets you killed, and more importantly...it makes you poor!"
so why put working as intended, if the Voth missions are meant to be dropping it?
#LegalizeAwoo
A normie goes "Oh, what's this?"
An otaku goes "UwU, what's this?"
A furry goes "OwO, what's this?"
A werewolf goes "Awoo, what's this?"
"It's nothing personal, I just don't feel like I've gotten to know a person until I've sniffed their crotch."
"We said 'no' to Mr. Curiosity. We're not home. Curiosity is not welcome, it is not to be invited in. Curiosity...is bad. It gets you in trouble, it gets you killed, and more importantly...it makes you poor!"
Radiogenic particles drop in crystalline catastrophe elite.
STO Resources: <Ship Comparison - All Tiers + Small Craft + Hangar Pets> <Damage Resistance>
<R&D + Upgrade Costs> <Duty Officer Finder> <Suliban Doff Reqs> <Fleet Costs> <Rep Costs>
<Keybind Tour the Galaxy> <Fleet / Armada Management> <Currency Exchange> <Other STO Links>
TY both, been running the heck out of CCE, and have never gotten one, so I just assumed it was one of the other types.
Praetor of the -RTS- Romulan Tal Shiar fleet!
STO Resources: <Ship Comparison - All Tiers + Small Craft + Hangar Pets> <Damage Resistance>
<R&D + Upgrade Costs> <Duty Officer Finder> <Suliban Doff Reqs> <Fleet Costs> <Rep Costs>
<Keybind Tour the Galaxy> <Fleet / Armada Management> <Currency Exchange> <Other STO Links>
Argonite Gas - Undine Space Elite Queues
Craylon Gas - Rh'lhho Stn., Mine Trap, Nukara Grnd. Elite
Dentarium - Undine Ground Elite Queues
Plekton - Borg Ground Elite Queues
Radiogenic Particle - Crystalline Catastrophe Elite
Trellium-K - Borg and Voth Space Elite Queues
STO Resources: <Ship Comparison - All Tiers + Small Craft + Hangar Pets> <Damage Resistance>
<R&D + Upgrade Costs> <Duty Officer Finder> <Suliban Doff Reqs> <Fleet Costs> <Rep Costs>
<Keybind Tour the Galaxy> <Fleet / Armada Management> <Currency Exchange> <Other STO Links>
I'm usually pretty good at crafting in games, it doesn't take much to figure it out anyway.. but this game's got me... I meet all the reqs, have a candidate and everything... all the materials... just no +skill cap items, which as I've read are optional to boost success rate... Yet the start button is grey... When I go to the main menu after, it just reads 'You have a duty officer equipped' and it's in red... Doesn't make sense because I have the corresponding officer equipped? How'd I break my R&D?
Again I'm sorry to post in this but it's the closest I could find. Thanks so much!
Newbie out~
didnt notice this thread before, but kudos for taking the time to do this
EDIT: I hope for your wallets sake those C-store packs were done on tribble
STO Resources: <Ship Comparison - All Tiers + Small Craft + Hangar Pets> <Damage Resistance>
<R&D + Upgrade Costs> <Duty Officer Finder> <Suliban Doff Reqs> <Fleet Costs> <Rep Costs>
<Keybind Tour the Galaxy> <Fleet / Armada Management> <Currency Exchange> <Other STO Links>
Absolutely! I cannot justify the cost of obtaining and opening that many packs on Holodeck.
STO Resources: <Ship Comparison - All Tiers + Small Craft + Hangar Pets> <Damage Resistance>
<R&D + Upgrade Costs> <Duty Officer Finder> <Suliban Doff Reqs> <Fleet Costs> <Rep Costs>
<Keybind Tour the Galaxy> <Fleet / Armada Management> <Currency Exchange> <Other STO Links>
STO Resources: <Ship Comparison - All Tiers + Small Craft + Hangar Pets> <Damage Resistance>
<R&D + Upgrade Costs> <Duty Officer Finder> <Suliban Doff Reqs> <Fleet Costs> <Rep Costs>
<Keybind Tour the Galaxy> <Fleet / Armada Management> <Currency Exchange> <Other STO Links>
Joined January 2009
Now to come up with my next spreadsheet idea, perhaps a collaborative list of all the good spreadsheets and great sources of game info that so many other people have created. Or maybe I will wait until I get around to completing a KDF T5 fleet shipyard on Tribble so I can finish filling in T5-U info on my ship spreadsheet.
STO Resources: <Ship Comparison - All Tiers + Small Craft + Hangar Pets> <Damage Resistance>
<R&D + Upgrade Costs> <Duty Officer Finder> <Suliban Doff Reqs> <Fleet Costs> <Rep Costs>
<Keybind Tour the Galaxy> <Fleet / Armada Management> <Currency Exchange> <Other STO Links>
Savik - Vulcan Fed Temporal Sci
Dahar Masters Fleet: Alphal'Fa - Alien KDF Engineer Qun'pau - Rom/KDF Engineer D'nesh - Orion KDF Scientist Ghen'khan - Liberated KDF Tac
Welcome to StarBug Online - to boldly Bug where no bug has been before!
STO player since November 2013
Thanks!
STO Resources: <Ship Comparison - All Tiers + Small Craft + Hangar Pets> <Damage Resistance>
<R&D + Upgrade Costs> <Duty Officer Finder> <Suliban Doff Reqs> <Fleet Costs> <Rep Costs>
<Keybind Tour the Galaxy> <Fleet / Armada Management> <Currency Exchange> <Other STO Links>
Manually updating the Links tab on several spreadsheets is starting to become a pain.. I could get behind that, and then use the "=importrange" function to import the entire collaborative spreadsheet into the Links tabs of the various other spreadsheets so that updates only need to be made to one sheet.. hmm.. but on second thought the "=importrange" function doesn't properly import formatting so all of the other sheets would still need manual updates when new data is added.. hmm..
I threw this together.. still trying to figure out a good layout and formatting scheme:
https://docs.google.com/spreadsheets/d/1fRPCj__FiAtLJZMQyasObOwkSv-vOcWhNKMcQwBEVIE/edit?usp=sharing
Joined January 2009