Spreadsheet to keep track of character drop locations & stats
Hello!
Recently reached Lvl 60 and love this game.
I'm really big on spreadsheets and made one using Google Drive to keep track of my characters' progress, and all the different drop locations, as well as several columns for stats in case you wanted to get THAT detailed.
Shared here for anyone else that likes spreadsheets, and planning out their characters' progression / unlocks: https://docs.google.com/spreadsheets/d/1q6gciOw_gQx-1z3l9-PCzx0seunsRCj5XTJw9NCTTtU/edit?usp=sharing
(Just copy the spreadsheet to your own Google Drive to use it, since the above link is View Only)
How to Sort Google Drive Spreadsheets:
For anyone that doesn't use Google Sheets, here is a quick way to sort the data in any way you want:
1. Select the "Name" cell in the upper left corner of all the data by clicking on it.
2. While holding ctrl + shift, tap "right arrow" + "down arrow". This should select the entire table.
3. Go to Data -> Sort range... at the top.
4. Select "Data has header row". This will display the name of each column at the top.
5. Sort by any number of columns that you want (the names of each column should be fairly self-explanatory).
My Favorite Ways to Sort:
1. Sort activated characters as they do in-game: Activated? A->Z, Level Z -> A, Shards (Promote) Z -> A, Name A -> Z
2. Sort by drop location: Drop A->Z, Name A->Z
3. Sort by Side, and then by Main Stat, Unit Type (to find for instance all the Str Tanks, or all the Int Healers): Activated A->Z, Side A->Z, Main Stat A->Z, Unit Type A->Z
How I Organized the Spreadsheet:
1. Character Stats (Simple): First is simple stuff like Name, whether you've activated the character, gear / power level, Light vs Dark side, the character's "Main" stat (which stat provides that character's physical dmg), as well as some tags and shard tracking stats.
I like having these things be sortable because sometimes I want to find all the Jedi in the game and where to find them, or track which of my characters are closest to promotion / activation.
2. Drop Locations: Next I tabulated where each character's shard drops, and color-coded each character using the list below, with the assumption that characters were easiest to unlock/promote from shipments, then Squad Cantina / Hard battles, then data card drops (for F2P players anyway).
1a. Squad Cantina Shipments = orange, 1b. Squad Arena Shipments = silver, 1c. Galactic War Shipments = neon green, 2a. Squad Cantina Battles = magenta, 2b. Hard Battles = yellow, 3. Data Cards = purple
The colors above were chosen based on the currency or energy type used for each drop location type. The characters highlighted in purple for instance I would consider the most rare because the only location they can drop is from data cards (even if you do unlock them, they are that much harder to promote).
3. Character Stats (Detailed): This section might be more helpful for those characters that are already at max lvl (60 for now), since it would be rather tedious to update these stats each day for each of your activated characters (even though I've done it a few times just because I'm crazy...). The purpose for this section was to help with finding the character with the most crit, or the most health, or just the highest physical dmg, etc. I know there is a feature sort of like this in-game, but it's very limited in its options.
4. Current Objectives: Just a little reminder for myself what I want to purchase from each shipment location, or what I want to spend my energy on.
5. "Other" Tab: Some other things about the game that I tabulated for my own information. You can delete it or keep it for yourself. I was curious for instance how many of each unit type there was, and for which main stat, and for which side.
If you have any comments or trouble using the spreadsheet please let me know! It's just something that I personally found useful while playing, and was hoping it could help someone else.
Recently reached Lvl 60 and love this game.
I'm really big on spreadsheets and made one using Google Drive to keep track of my characters' progress, and all the different drop locations, as well as several columns for stats in case you wanted to get THAT detailed.
Shared here for anyone else that likes spreadsheets, and planning out their characters' progression / unlocks: https://docs.google.com/spreadsheets/d/1q6gciOw_gQx-1z3l9-PCzx0seunsRCj5XTJw9NCTTtU/edit?usp=sharing
(Just copy the spreadsheet to your own Google Drive to use it, since the above link is View Only)
How to Sort Google Drive Spreadsheets:
For anyone that doesn't use Google Sheets, here is a quick way to sort the data in any way you want:
1. Select the "Name" cell in the upper left corner of all the data by clicking on it.
2. While holding ctrl + shift, tap "right arrow" + "down arrow". This should select the entire table.
3. Go to Data -> Sort range... at the top.
4. Select "Data has header row". This will display the name of each column at the top.
5. Sort by any number of columns that you want (the names of each column should be fairly self-explanatory).
My Favorite Ways to Sort:
1. Sort activated characters as they do in-game: Activated? A->Z, Level Z -> A, Shards (Promote) Z -> A, Name A -> Z
2. Sort by drop location: Drop A->Z, Name A->Z
3. Sort by Side, and then by Main Stat, Unit Type (to find for instance all the Str Tanks, or all the Int Healers): Activated A->Z, Side A->Z, Main Stat A->Z, Unit Type A->Z
How I Organized the Spreadsheet:
1. Character Stats (Simple): First is simple stuff like Name, whether you've activated the character, gear / power level, Light vs Dark side, the character's "Main" stat (which stat provides that character's physical dmg), as well as some tags and shard tracking stats.
I like having these things be sortable because sometimes I want to find all the Jedi in the game and where to find them, or track which of my characters are closest to promotion / activation.
2. Drop Locations: Next I tabulated where each character's shard drops, and color-coded each character using the list below, with the assumption that characters were easiest to unlock/promote from shipments, then Squad Cantina / Hard battles, then data card drops (for F2P players anyway).
1a. Squad Cantina Shipments = orange, 1b. Squad Arena Shipments = silver, 1c. Galactic War Shipments = neon green, 2a. Squad Cantina Battles = magenta, 2b. Hard Battles = yellow, 3. Data Cards = purple
The colors above were chosen based on the currency or energy type used for each drop location type. The characters highlighted in purple for instance I would consider the most rare because the only location they can drop is from data cards (even if you do unlock them, they are that much harder to promote).
3. Character Stats (Detailed): This section might be more helpful for those characters that are already at max lvl (60 for now), since it would be rather tedious to update these stats each day for each of your activated characters (even though I've done it a few times just because I'm crazy...). The purpose for this section was to help with finding the character with the most crit, or the most health, or just the highest physical dmg, etc. I know there is a feature sort of like this in-game, but it's very limited in its options.
4. Current Objectives: Just a little reminder for myself what I want to purchase from each shipment location, or what I want to spend my energy on.
5. "Other" Tab: Some other things about the game that I tabulated for my own information. You can delete it or keep it for yourself. I was curious for instance how many of each unit type there was, and for which main stat, and for which side.
If you have any comments or trouble using the spreadsheet please let me know! It's just something that I personally found useful while playing, and was hoping it could help someone else.
