Joint Multiplayer Database (Google Docs)

Since this might not be that interesting for most people, I'll give a quick tl;dr:

---

OP's building a Google Docs-based database with all the character, power, weapon, enemy, etc. information for MEAMP that can be used for creating calculators, charts and whatever else people come up with. 

---

Back in the prime days of ME3MP and BSN, a couple people (myself included) built calculators for specific purposes (damage-optimization, builds, survivability, enemy stats etc.). I think most of them were based on Google Docs while some were web-based. Mine was part of the latter category which is also the reason why it's no longer available (thanks, server f*ckup).

The problem was that most of these had their own database behind them, so a lot of time was wasted inputting data that someone else already had and pretty much neither of them contained all the data. For this reason I planned on creating a database that contains all the relevant data once the next Mass Effect MP comes around. I think I even made a post about that on the old BSN but that was a couple years ago. 

Now with Andromeda at the doorstep, I started building said database. Since there's no actual information available on Andromeda MP right now, I'm using the ME3 content to gauge what fields and categories it probably needs. Once the beta hits, I'll be able to adjust it to the actual content. 

It will definitely contain the following:

• Characters
• Weapons
• Passive Abilities/Stat Changes (think Fitness evolutions and the like)
• Active Abilities
• Gear
• Attachments
• Consumeables
• Enemies

I'm also thinking about including maps with spawns, wave data and other stuff (whatever that might be).

As a framework I use Google Docs (Sheets) to be independent from rented servers and because most calculators/tools (if there will be any that is) will likely be using Google Docs as well. Also, Sheets allows a data export as JSON, so even if someone wants to use the database for a web-based service, they could do that. 

The preliminary database layout is pretty much done and I'm now checking against ME3 if I could represent all relevant information from that game. That should be a pretty accurate estimation of what's still missing.

Once the db contains actual information on Andromeda, I'll post a link to the it so it can be used by anyone who's interested (btw. IMPORTRANGE allows importing data into a Sheet frome external sources). I will also use this post for updates/changelogs etc. once the time comes.

Until then feel free to share your own ideas on what the database should contain because I'm sure there are things I didn't think of.