Bionic_Flea Posted October 6 Posted October 6 On 10/4/2024 at 2:44 PM, Frozen Burn said: My Excel Workbook may make people's head explode. 2 1
RikOz Posted October 8 Posted October 8 I just have individual spreadsheets for the ATs I play, to keep track of which PS combos I've already used and avoid duplicates. Here's my brute sheet: I have spreadsheets for blasters, brutes, scrappers, sentinels and stalkers, the ATs I play most often. Some of them need a bit of updating to take into account some new PSs and some PS proliferation 1
Apogee Posted October 8 Posted October 8 18 minutes ago, RikOz said: I just have individual spreadsheets for the ATs I play, to keep track of which PS combos I've already used and avoid duplicates. Here's my brute sheet: I have spreadsheets for blasters, brutes, scrappers, sentinels and stalkers, the ATs I play most often. Some of them need a bit of updating to take into account some new PSs and some PS proliferation Dude, you need to start a Savage/Bio!
RikOz Posted October 8 Posted October 8 2 hours ago, Apogee said: Dude, you need to start a Savage/Bio! Oh, I will, eventually. I'm currently at 140 alts, and I've slowed down a bit on rolling new ones while I focus on getting the existing ones to 50, and getting my existing 50s incarnated out :)
Icono04 Posted October 9 Posted October 9 My main spreadsheet is very similar to the one in @lobster's second post in this thread. So similar that I won't even bother posting a screenie of it here. The columns are in a different order, and I use a few more columns to track things things like reward merits, Empyreans etc,, but that is minor details. There are also a bunch of subsheets for various details and calculations, but the main sheet is what I use 98% of the time. One thing that makes me curious: Looking at all the spreadsheets that people have generously shared in this thread, I notice that none of you use the Filter function in the headings line. I do, and I use it A LOT. It helps me search for subsets of characters, e.g. if I want to see only scrappers, or only villains, or only chars that don't have the TFC accolade, or whatever it might be. Who else uses the Filter tool in their spreadsheet? 1
Hedgefund Posted October 9 Posted October 9 (edited) I use filters, you can see the ones I was using at the moment I took the screen snippet (4th post in this thread). Without querying I personally wouldn't even see the value of having a spreadsheet at all. Edited October 9 by Hedgefund 1
Maelwys Posted October 10 Posted October 10 10 hours ago, Hedgefund said: Without querying I personally wouldn't even see the value of having a spreadsheet at all. Over the years I've definitely used Spreadsheets far more often for "pretty looking data manipulation" than for maintaining sortable lists of things. There are a lot of use cases for a crayola-inspired splash screen which can perform a large number of recalculations based on you changing one of more input values; and Spreadsheets can accomplish that without you having to resort to breaking out a full compiler + spending half a day just writing the initial frontend (assuming that you even know how to code in the first place). Spreadsheets are also portable and tweakable in realtime in exactly the same way that source code isn't. They're not a patch on a proper relational database mind you (although I've seen them used for that too; and almost always badly) but I'd still prefer a well-built spreadsheet to anything created in the sticky lukewarm mess that is Microsoft Access 🤮
RikOz Posted October 10 Posted October 10 I just made a new one, that is possibly rather pointless, and mostly to satisfy my own curiosity. I used to occasionally run Ephram Sha's repeatable missions and choose the "Huge Inspiration" reward, and I started to notice that I received "Furious Rage" (damage) more often than anything else, with "Back in the Fight" (endurance) seemingly the next most common. And some seemed scarce as hen's teeth. It occurred to me that the different inspirations might be weighted differently in the RNG algorithm, but my sample size was too small for my observation to mean anything. So I started seriously farming. I mean, not non-stop farming; I just made a point of having my characters who happen to be running DA content do a round of four repeatable missions each time I logged them in, and keep track of which inspirations they were awarded. I kept track in a plain text file, but decided to stick the numbers into a spreadsheet ... because a pie chart would be fun. I'm currently up to 1,404 Huge inspirations collected and recorded (small margin of error, since I'm surely forgotten to record a few here and there). 1,404 is still small in the grand RNG scheme of things, but it partly confirmed my suspicions, and definitely shows a trend in how things are weighted. The damage insp is definitely out in front, but endurance is in third place, slightly behind health. I'm rather appalled that Liberate is the most rare, behind Ultimate. 1 1
mistagoat Posted October 14 Author Posted October 14 (edited) On 10/10/2024 at 7:35 PM, RikOz said: I just made a new one, that is possibly rather pointless, and mostly to satisfy my own curiosity. I used to occasionally run Ephram Sha's repeatable missions and choose the "Huge Inspiration" reward, and I started to notice that I received "Furious Rage" (damage) more often than anything else, with "Back in the Fight" (endurance) seemingly the next most common. And some seemed scarce as hen's teeth. It occurred to me that the different inspirations might be weighted differently in the RNG algorithm, but my sample size was too small for my observation to mean anything. So I started seriously farming. I mean, not non-stop farming; I just made a point of having my characters who happen to be running DA content do a round of four repeatable missions each time I logged them in, and keep track of which inspirations they were awarded. I kept track in a plain text file, but decided to stick the numbers into a spreadsheet ... because a pie chart would be fun. I'm currently up to 1,404 Huge inspirations collected and recorded (small margin of error, since I'm surely forgotten to record a few here and there). 1,404 is still small in the grand RNG scheme of things, but it partly confirmed my suspicions, and definitely shows a trend in how things are weighted. The damage insp is definitely out in front, but endurance is in third place, slightly behind health. I'm rather appalled that Liberate is the most rare, behind Ultimate. That's some top shelf data! I love the commitment and the pie chart was indeed, fun! Edited October 14 by mistagoat 1 SCRAPPER: Sir Kit Breaker-Elec/Shield *DumDum Pounder-WM/Shield *Snoglobe-Claws/Ice *Ice Flow Joe-Axe/Ice *TANK: Gamma Goon-Rad/Rad *Bernjamin Tanklin-fire/claws *Skullgrin Von Killjoy-Invul/SS *Frozen Snowshoo-Ice/Ice Quarry Goon-Stone/SS *BRUTE: Megahertz Donut-EM/Shield *Ohm Ahgerd Stone/Elec *Shadow Goon-Dark/Dark *Devilaint Le'Z-Rad/Fire *STALKER: Double OHM 7-EM/EA *Sir Kit Interupt-Elec/Shield *TROLLER: Chilly Lilly-Ice/Rad *Chlorophyllis Vance-Plant/Storm *Mechamoo-Elec/Cold *Johnny Burnsalot-Fire/Kin *Countess Gone-Ill/Dark *Lady Gone-Dark/Dark *Calpernia Tomik-Ill/Rad *Porkchop Scallywag-Fire/Nat *Gone Daddy-Plant/Dark *Merrie Melody-Symp/Dark *Toot Sweet-Fire/Dark *Lord Gone-Grav/Dark *Misty Burnsalot-Fire/Storm *Maddie Burnsalot-Fire/Rad *DOM: Scorched Eartha-Earth/Fire *Gazebo Malarkey-Dark/Psi *Clawsin Bloom-Plant/Savage *Diatomaceous Earl-Plant/Thorn *Permafrostasha-Plant/Ice *Corn Cob Earth/Earth *MM: Stupid Robot-Bot/Elec *Dark Leader-Demons/Dark *Silas Greenback-Thugs/Time *FENDER: *Dr. Gone-Dark/Dark *BAG3L-FF/Sonic *BLASTER: PinPointress-Arch/TA *Shimmy Burnsalot-Fire/TA *Lil Beefy-Ice/Fire *H0TT-fire/fire *CORRUPTOR: Shady Burnsalot-Fire/Dark *Kinetic Koala-Ice/Kin *Atmospheric Hazel-Water/Storm *Hami Dum-Seismic/Nature *MiHami Heat-Fire/Nature *SOA *Big Gravy-Crabbermind *Sentinel: NP Seymour-Elec/Regen
mistagoat Posted October 14 Author Posted October 14 Over the weekend I added a page to track my beloved Rad Tanks! SCRAPPER: Sir Kit Breaker-Elec/Shield *DumDum Pounder-WM/Shield *Snoglobe-Claws/Ice *Ice Flow Joe-Axe/Ice *TANK: Gamma Goon-Rad/Rad *Bernjamin Tanklin-fire/claws *Skullgrin Von Killjoy-Invul/SS *Frozen Snowshoo-Ice/Ice Quarry Goon-Stone/SS *BRUTE: Megahertz Donut-EM/Shield *Ohm Ahgerd Stone/Elec *Shadow Goon-Dark/Dark *Devilaint Le'Z-Rad/Fire *STALKER: Double OHM 7-EM/EA *Sir Kit Interupt-Elec/Shield *TROLLER: Chilly Lilly-Ice/Rad *Chlorophyllis Vance-Plant/Storm *Mechamoo-Elec/Cold *Johnny Burnsalot-Fire/Kin *Countess Gone-Ill/Dark *Lady Gone-Dark/Dark *Calpernia Tomik-Ill/Rad *Porkchop Scallywag-Fire/Nat *Gone Daddy-Plant/Dark *Merrie Melody-Symp/Dark *Toot Sweet-Fire/Dark *Lord Gone-Grav/Dark *Misty Burnsalot-Fire/Storm *Maddie Burnsalot-Fire/Rad *DOM: Scorched Eartha-Earth/Fire *Gazebo Malarkey-Dark/Psi *Clawsin Bloom-Plant/Savage *Diatomaceous Earl-Plant/Thorn *Permafrostasha-Plant/Ice *Corn Cob Earth/Earth *MM: Stupid Robot-Bot/Elec *Dark Leader-Demons/Dark *Silas Greenback-Thugs/Time *FENDER: *Dr. Gone-Dark/Dark *BAG3L-FF/Sonic *BLASTER: PinPointress-Arch/TA *Shimmy Burnsalot-Fire/TA *Lil Beefy-Ice/Fire *H0TT-fire/fire *CORRUPTOR: Shady Burnsalot-Fire/Dark *Kinetic Koala-Ice/Kin *Atmospheric Hazel-Water/Storm *Hami Dum-Seismic/Nature *MiHami Heat-Fire/Nature *SOA *Big Gravy-Crabbermind *Sentinel: NP Seymour-Elec/Regen
shortguy on indom Posted October 17 Posted October 17 MINE ARE MOSTLY NOT FOR HUMAN CONSUMPTION DUE TO THE MATH. THIS ONE IS JUST FOR REFERENCE. WHEN I'M PUTTING SPREADSHEET TOGETHER, HELPS ME LEARN. 1 PvP Capture the Flag! Bring some fun into it....
Yomo Kimyata Posted October 18 Posted October 18 I won't share my spreadsheets since I am embarrassed by their appearance. However, my scrapper breakdown by primary/secondary to figure out where to put the Critical Strike proc is bueno. 1 Who run Bartertown?
tidge Posted October 18 Posted October 18 On 10/10/2024 at 11:35 PM, RikOz said: The damage insp is definitely out in front, but endurance is in third place, slightly behind health. I'm rather appalled that Liberate is the most rare, behind Ultimate. Definitely looks like something approaching an 8:3:1 weighting. (or if you prefer 2/2/2/2 : 1/1/1 : 0.5/0.5) I like that this data appears to show a couple of things that I strongly suspect about the pseudo-RNG: The pseudo-RNG populates the result space flatly between the end-points of its result space. (A true random number generator wouldn't have such even-looking results) The pseudo-RNG very likely has a slight, but observable bias at the end-points of its result space. The second point is confounded because I don't actually know what the probability endpoints are. This is, is the range inclusive of 0 <-> 1, or does one/both of those endpoints actually "close but not exactly 0 or 1". From this one study, I would lay odds that Liberates are a result at one end of the probability space and that Furious Rages are at the other. This is a relatively small sample size so there isn't a lot of power to back it up, but I think the confidence in that result is pretty high. I can think of a couple reasons why this would happen: The probability space isn't inclusive of one end, but is inclusive of the opposite end. There is a subtle theoretical under-pinning of the RNG relating to scale-invariance (I propose this partially because of a scale-invariate priors treat zero, but IIRC there are other subtle factors with prior choices that manifest at endpoints) 1 1
UltraAlt Posted October 21 Posted October 21 On 10/2/2024 at 2:35 PM, mistagoat said: I look forward to seeing what you've done! This is the spreadsheet that I made for Homecoming. The images are reposts from a while back. The spreadsheet that I had before the Sunset was in created in Open. never take off the mask 1 If someone posts a reply quoting me and I don't reply, they may be on ignore. (It seems I'm involved with so much at this point that I may not be able to easily retrieve access to all the notifications) Some players know that I have them on ignore and are likely to make posts knowing that is the case. But the fact that I have them on ignore won't stop some of them from bullying and harassing people, because some of them love to do it. There is a group that have banded together to target forum posters they don't like. They think that this behavior is acceptable. Ignore (in the forums) and /ignore (in-game) are tools to improve your gaming experience. Don't feel bad about using them.
shortguy on indom Posted November 6 Posted November 6 MORE NUMBERS. 1 PvP Capture the Flag! Bring some fun into it....
Logansan Posted November 6 Posted November 6 Excel spreadsheets are like side quests.... I have one badge workbook for each server with the following sheets - iTrials, Specials, Events, Task-Strike Forces, Trials, Day Jobs. Each column been a individual character. I also have a MS Word document to record what Incarnate powers each character has, that is currently at 207 pages. I should also make a spreadsheet for character names, AT and power sets. I currently record this information in text document and I've been too lazy to improve it. Each time I want to create a new character I copy and paste the list into excel as data to work out which combination I haven't try yet. And each time I do create a new character I always think "I should save this workbook", but for some reason I never do. 1
Seldom Posted November 6 Posted November 6 (edited) My updated post-ToT Alt tracker spreadsheet! (Names redacted) AT Primary Secondary Level Fully Incarnated Finished build Page # Alignment Dominator Mind Control Psionic Assault 50 ✓ ✓ 1 Rogue Dominator Fire Control Fiery Assault 50 ✓ ✓ 1 Vigilante Dominator Plant Control Martial Assault 50 ✓ ✓ 1 Vigilante Dominator Gravity Control Dark Assault 50 ✓ ✓ 1 Rogue Dominator Illusion Control Earth Assault 50 ✓ ✓ 1 Vigilante Dominator Ice Control Savage Assault 47 X X 1 Vigilante Dominator Symphony Control Sonic Assault 50 ✓ ✓ 1 Vigilante Dominator Arsenal Control Psionic Assault 29 X X 1 Hero Dominator Earth Control Electric assault 25 X X 1 Hero Controller Illusion Control Time Manipulation 50 ✓ ✓ 2 Vigilante Controller Electric Control Kinetics 50 ✓ ✓ 2 Vigilante Controller Fire Control Radiation Emission 50 ✓ ✓ 2 Villain Controller Darkness Control Empathy 50 ✓ ✓ 2 Vigilante Controller Symphony Control Electrical Affinity 50 X X 2 Villain Tanker Bio Armor Radiation Melee 50 ✓ ✓ 3 Hero Tanker Ice Armor Staff Fighting 50 ✓ ✓ 3 Hero Tanker Radiation Armor Street Justice 50 ✓ ✓ 3 Rogue Tanker Willpower War Mace 50 ✓ ✓ 3 Hero Tanker Super reflexes Super Strength 32 X X 3 Hero Tanker Invulnerability Stone Melee 25 X X 3 Vigilante Corruptor Radiation Blast Radiation Emission 50 ✓ ✓ 4 Hero Corruptor Sonic Attack Poison 50 ✓ ✓ 4 Villain Corruptor Pain Domination Assault Rifle 50 ✓ ✓ 4 Vigilante Corruptor Radiation Blast Electrical Affinity 35 X X 4 Rogue Corruptor Energy Blast Trick arrow 25 X X 4 Villain Corruptor Seismic Blast Trick arrow 25 X X 4 Vigilante Corruptor Psychic Blast Sonic Resonance 25 X X 4 Hero Corruptor Fire Blast Marine Affinity 29 X X 4 Vigilante Brute Electrical Melee Regeneration 50 ✓ ✓ 5 Vigilante Brute Broadsward Dark Armor 50 ✓ ✓ 5 Vigilante Brute Titan Weapons Energy Aura 50 ✓ ✓ 5 Villain Brute Psychic Melee Shield Defense 38 X X 5 Vigilante Brute Spines Stone Armor 32 X X 5 Hero Defender Force Field Electrical Blast 50 ✓ ✓ 6 Villain Defender Traps Sonic Attack 50 ✓ ✓ 6 Hero Defender Nature Affinity Ice Blast 50 ✓ ✓ 6 Hero Defender Dark Miasma Psychic Blast 50 ✓ ✓ 6 Hero Defender Poison Water Blast 40 ✓ ✓ 6 Hero Defender Thermal Radiation Beam Rifle 28 X X 6 Rogue Blaster Dual Pistols Devices 50 ✓ ✓ 7 Hero Blaster Psychic Blast Plant Manipulation 50 ✓ ✓ 7 Vigilante Blaster Archery Energy Manipulation 50 ✓ ✓ 7 Hero Blaster Sonic Attack Sonic Manipulation 40 X X 7 Villain Blaster Archery Tactical Arrow 36 X X 7 Rogue Blaster Water Blast Temporal Manipulation 25 X X 7 Vigilante Blaster Seismic Blast Fire Manipulation 30 X X 7 Vigilante Arachnos soldier/Bane Bane Spider Soldier Bane Spider Training 50 ✓ ✓ 8 Villain Arachnos soldier/Crab Crab Spider Soldier Crab Spider Training 50 ✓ ✓ 8 Vigilante Arachnos widow/Fortunata Fortunata Training Fortunata Teamwork 50 ✓ ✓ 8 Rogue Warshade Umbral Blast Umbral Aura 50 ✓ ✓ 8 Hero Peacebringer Luminous Blast Luminous Aura 50 ✓ ✓ 8 Hero Arachnos widow/Night widow Night Widow Training Widow Teamwork 27 X X 8 Rogue Arachnos soldier/Crab Crab Spider Soldier Crab Spider Training 28 X X 8 Vigilante Sentinel Fire Blast Radiation Armor 50 ✓ ✓ 9 Hero Sentinel Storm Blast Electrical Armor 50 ✓ ✓ 9 Vigilante Sentinel Dark Blast Dark Armor 50 ✓ ✓ 9 Villain Sentinel Water Blast Bio Armor 37 X X 9 Hero Scrapper Energy Melee Darl Armor 50 ✓ ✓ 10 Vigilante Scrapper Fire Melee Electrical Armor 50 X ✓ 10 Rogue Scrapper Ice Melee Stone Armor 29 X X 10 Vigilante Scrapper Battle Axe Shield defense 26 X X 10 Hero Scrapper Street Justice Radiation Armor 25 X X 10 Vigilante Scrapper electrical melee Super reflexes 30 X X 10 Hero Mastermind Demon Summoning Cold Domination 50 ✓ ✓ 11 Hero Mastermind Necromancy Nature Affinity 50 ✓ ✓ 11 Villain Mastermind Robotics Dark Miasma 50 ✓ ✓ 11 Rogue Mastermind Beast Mastery Sonic Resonance 50 X X 11 Vigilante Mastermind Thugs Time Manipulation 38 X X 11 Villain Mastermind Beast Mastery Kinetics 28 X X 11 Villain Stalker Dual Blades Ninjitsu 50 ✓ ✓ 12 Hero Stalker Savage Melee Fire Armor 50 ✓ ✓ 12 Rogue Stalker Martial Arts Super Reflexes 26 X X 12 Vigilante Stalker Energy melee Invulnerability 25 X X 12 Vigilante Stalker Dark Melee Bio Armor 25 X X 12 Rogue Edited November 6 by Seldom 1
Monsoon Posted November 12 Posted November 12 (edited) This is what I've got on the primary tab of my spreadsheet. It started out just as tracking accolade completion progress, and kinda grew from there. (Deleted old screen shot, replacing with one that omits character names) The character's name (not included for an attempt at privacy), then their AT, Primary, Secondary, and Sex (I'm one of those guys who likes to play female characters purely for the visuals, and it amuses me to see what percentage are female). The date they were created, the date they hit 50 (if applicable) and how many days in between. Their level and veteran level, then if they've got a proper IO build slotted (with sets and such, not just common IO's or SO's), Then come the Accolades; TFC, Atlas Medallion, FP Reserve, and Portal Jockey. Followed by their Market Crash completion status and Patron Pool unlock status. Then the three WST's (rotates based on math done in another tab of the document) and whether they're high enough to run them and if they've already run it that week. Then their Incarnate powers, either a percentage to show how far they've come in the unlock or a T# to indicate which tier is slotted. And finally a list of the various fast travel powers and how much inf I need to send to the character so they can grab them all. Edited November 12 by Monsoon 1
shortguy on indom Posted November 13 Posted November 13 NOW THAT THERE IS A DEWEY DECIMAL SYSTEM. 1 PvP Capture the Flag! Bring some fun into it....
Tacheyon Posted November 13 Posted November 13 Wow! I love making spreadsheets...at work. For me i can usually remember what combos I have made and enjoyed. Anything else well I just log into that character if I want. I have a "rule" (although more like guideline 😁) if I have to start making spreadsheets or doing "work" to keep track of stuff, the game is no longer relaxing and I leave it, not that i could really leave COH/COV. But you understand what I am getting at. Although these are amazing pieces of art in their own right. That's really what I wanted to say. 1
WanderingAries Posted November 13 Posted November 13 HOLY SHEET PEOPLE!!! I'd never get to play (when I actually played) had I gone nearly this far. 😛 That's why I liked CoH Faces back then. Shame we don't have something like that now (that I'm aware of). 1 OG Server: Pinnacle <||> Current Primary Server: Torchbearer || Also found on the others if desired <||> Generally Inactive Installing CoX: Windows || MacOS || MacOS for M1 <||> Migrating Data from an Older Installation Clubs: Mid's Hero Designer || PC Builders || HC Wiki || Jerk Hackers Old Forums <||> Titan Network <||> Heroica! (by @Shenanigunner)
mistagoat Posted November 13 Author Posted November 13 22 hours ago, Monsoon said: Then the three WST's (rotates based on math done in another tab of the document) and whether they're high enough to run them and if they've already run it that week. That is very clever! Nice! I love that your "time to 50" ranges from 3 days to over 1800 days! Gives me hope for that blaster I made 2 Halloween events ago that I got to 25 and haven't touched since lol SCRAPPER: Sir Kit Breaker-Elec/Shield *DumDum Pounder-WM/Shield *Snoglobe-Claws/Ice *Ice Flow Joe-Axe/Ice *TANK: Gamma Goon-Rad/Rad *Bernjamin Tanklin-fire/claws *Skullgrin Von Killjoy-Invul/SS *Frozen Snowshoo-Ice/Ice Quarry Goon-Stone/SS *BRUTE: Megahertz Donut-EM/Shield *Ohm Ahgerd Stone/Elec *Shadow Goon-Dark/Dark *Devilaint Le'Z-Rad/Fire *STALKER: Double OHM 7-EM/EA *Sir Kit Interupt-Elec/Shield *TROLLER: Chilly Lilly-Ice/Rad *Chlorophyllis Vance-Plant/Storm *Mechamoo-Elec/Cold *Johnny Burnsalot-Fire/Kin *Countess Gone-Ill/Dark *Lady Gone-Dark/Dark *Calpernia Tomik-Ill/Rad *Porkchop Scallywag-Fire/Nat *Gone Daddy-Plant/Dark *Merrie Melody-Symp/Dark *Toot Sweet-Fire/Dark *Lord Gone-Grav/Dark *Misty Burnsalot-Fire/Storm *Maddie Burnsalot-Fire/Rad *DOM: Scorched Eartha-Earth/Fire *Gazebo Malarkey-Dark/Psi *Clawsin Bloom-Plant/Savage *Diatomaceous Earl-Plant/Thorn *Permafrostasha-Plant/Ice *Corn Cob Earth/Earth *MM: Stupid Robot-Bot/Elec *Dark Leader-Demons/Dark *Silas Greenback-Thugs/Time *FENDER: *Dr. Gone-Dark/Dark *BAG3L-FF/Sonic *BLASTER: PinPointress-Arch/TA *Shimmy Burnsalot-Fire/TA *Lil Beefy-Ice/Fire *H0TT-fire/fire *CORRUPTOR: Shady Burnsalot-Fire/Dark *Kinetic Koala-Ice/Kin *Atmospheric Hazel-Water/Storm *Hami Dum-Seismic/Nature *MiHami Heat-Fire/Nature *SOA *Big Gravy-Crabbermind *Sentinel: NP Seymour-Elec/Regen
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now