Bopper Posted September 13, 2020 Share Posted September 13, 2020 (edited) I've been working on something recently. (Skip ahead to 0:58 if parsing of data bores you). EDIT: I will keep this top post updated with the newest version of the EXCEL file generated, which will typically be the attachment in my latest comment. CoH_Homecoming_of_Data_Page5_20200928.xlsx Edited September 28, 2020 by Bopper Updated with correct Snipe numbers 7 5 PPM Information Guide Survivability Tool Interface DoT Procs Guide Time Manipulation Guide Bopper Builds +HP/+Regen Proc Cheat Sheet Super Pack Drop Percentages Recharge Guide Base Empowerment: Temp Powers Bopper's Tools & Formulas Mids' Reborn Link to comment Share on other sites More sharing options...
summers Posted September 13, 2020 Share Posted September 13, 2020 Very!! Link to comment Share on other sites More sharing options...
Xeres Posted September 13, 2020 Share Posted September 13, 2020 Yep! Link to comment Share on other sites More sharing options...
FoulVileTerror Posted September 13, 2020 Share Posted September 13, 2020 Who -wouldn't- be interested in that? GIMME! (please, thank you, and if you're willing to share) Link to comment Share on other sites More sharing options...
Omega-202 Posted September 13, 2020 Share Posted September 13, 2020 Yes please and thank you. Link to comment Share on other sites More sharing options...
Bill Z Bubba Posted September 13, 2020 Share Posted September 13, 2020 Are you calculating in Arcanatime or is that coming in with the data? Also, HELL YES PLS. Link to comment Share on other sites More sharing options...
Ukase Posted September 13, 2020 Share Posted September 13, 2020 I can't say - I went to full screen and I guess I need new glasses. I have no idea what was on the spreadsheet. 4 Link to comment Share on other sites More sharing options...
Lines Posted September 13, 2020 Share Posted September 13, 2020 3 minutes ago, Ukase said: I can't say - I went to full screen and I guess I need new glasses. I have no idea what was on the spreadsheet. E V E R Y T H I N G Link to comment Share on other sites More sharing options...
Bopper Posted September 13, 2020 Author Share Posted September 13, 2020 28 minutes ago, Bill Z Bubba said: Are you calculating in Arcanatime or is that coming in with the data? Also, HELL YES PLS. I am calculating Arcanatime and DPA 25 minutes ago, Ukase said: I can't say - I went to full screen and I guess I need new glasses. I have no idea what was on the spreadsheet. 2 PPM Information Guide Survivability Tool Interface DoT Procs Guide Time Manipulation Guide Bopper Builds +HP/+Regen Proc Cheat Sheet Super Pack Drop Percentages Recharge Guide Base Empowerment: Temp Powers Bopper's Tools & Formulas Mids' Reborn Link to comment Share on other sites More sharing options...
AboveTheChemist Posted September 13, 2020 Share Posted September 13, 2020 I like it! Popmenus > Badge List | Optimal Paths | Conversion Possibilities | Emotes Wiki Pages > Costume Color Schemes | Set Bonus Comparison Tables Maps > Vidiotmaps | Optimal Paths | Halloween GM Maps | Winter Gift Maps | Offline Map Viewer Sounds > Banshee Sonic Attack Datasets > Recipe Salvage Components | Badge Name & Settitle ID | Exploration Badge & History Plaque Coordinates Link to comment Share on other sites More sharing options...
FoulVileTerror Posted September 13, 2020 Share Posted September 13, 2020 I counter with: https://www.youtube.com/watch?v=ir-y6-L6Vlk Link to comment Share on other sites More sharing options...
LiquidBandage Posted September 13, 2020 Share Posted September 13, 2020 1 hour ago, Bopper said: I am calculating Arcanatime and DPA Could you please explain a couple things for me? What is 'Arcanatime'? Does 'TimeHit' mean "time until hit" for things like firing off sound effects (aka back loaded cast time)? Regardless of the answer, I am interested to see this. Many times I am curious to know arc for cones, cast times etc and can't find out until I jump in feet first. Link to comment Share on other sites More sharing options...
Bill Z Bubba Posted September 13, 2020 Share Posted September 13, 2020 4 minutes ago, LiquidBandage said: What is 'Arcanatime'? https://archive.paragonwiki.com/wiki/ArcanaTime Link to comment Share on other sites More sharing options...
Bopper Posted September 13, 2020 Author Share Posted September 13, 2020 16 minutes ago, LiquidBandage said: Could you please explain a couple things for me? What is 'Arcanatime'? Does 'TimeHit' mean "time until hit" for things like firing off sound effects (aka back loaded cast time)? Regardless of the answer, I am interested to see this. Many times I am curious to know arc for cones, cast times etc and can't find out until I jump in feet first. Time Hit is the animation time until a hit effect occurs. This could be useful for things like the scrapper ATO proc which gives a 3.25s window when it hits. I suspect some of that window gets eaten up by the power you're casting, so this could be useful info to have. For example, Whirling Axe has a 2.67s cast time, but the hit happens at 1.2s. So I suspect (haven't tested to confirm, so take this with a grain of salt) that ~1.5s of the 3.25s window would be wasted. And if I'm wrong and that info proves to be useless, I can pull it out of my tool. 1 PPM Information Guide Survivability Tool Interface DoT Procs Guide Time Manipulation Guide Bopper Builds +HP/+Regen Proc Cheat Sheet Super Pack Drop Percentages Recharge Guide Base Empowerment: Temp Powers Bopper's Tools & Formulas Mids' Reborn Link to comment Share on other sites More sharing options...
Bopper Posted September 13, 2020 Author Share Posted September 13, 2020 For those interested in playing around with it. Here is a link of a Google Sheets version. Attached is the original Excel version. Please provide feedback of things liked/disliked/missing/etc. CoH_Homecoming_of_Data.xlsx 1 3 PPM Information Guide Survivability Tool Interface DoT Procs Guide Time Manipulation Guide Bopper Builds +HP/+Regen Proc Cheat Sheet Super Pack Drop Percentages Recharge Guide Base Empowerment: Temp Powers Bopper's Tools & Formulas Mids' Reborn Link to comment Share on other sites More sharing options...
FoulVileTerror Posted September 14, 2020 Share Posted September 14, 2020 Thanks @Bopper. This is pretty awesome! Although, am I reading it wrong, or does it not contain any of the information such as Buff/Debuff/Control/Special Effects? Link to comment Share on other sites More sharing options...
Bopper Posted September 14, 2020 Author Share Posted September 14, 2020 3 minutes ago, FoulVileTerror said: Thanks @Bopper. This is pretty awesome! Although, am I reading it wrong, or does it not contain any of the information such as Buff/Debuff/Control/Special Effects? You're not reading it wrong. This is just a summary sheet similar to how City of Data used to do it (it also didn't show debuffs/buffs). For example To add other effects will take some extra coding (and columns). But I am thinking about adding a hyperlink that would allow someone to jump directly to the RubyRed API url that contains that data. We'll see. Thats what I'm looking for with feedback...ideas. 1 PPM Information Guide Survivability Tool Interface DoT Procs Guide Time Manipulation Guide Bopper Builds +HP/+Regen Proc Cheat Sheet Super Pack Drop Percentages Recharge Guide Base Empowerment: Temp Powers Bopper's Tools & Formulas Mids' Reborn Link to comment Share on other sites More sharing options...
FoulVileTerror Posted September 14, 2020 Share Posted September 14, 2020 Very good to know, thank you. Even still, this is top form! I do wonder why it takes so long to parse and load, though, considering it's only just over 700kb. For some reason it took about a minute and half to load, while spreadsheets I have which are 700MB take a split second. Link to comment Share on other sites More sharing options...
Bopper Posted September 14, 2020 Author Share Posted September 14, 2020 2 minutes ago, FoulVileTerror said: do wonder why it takes so long to parse and load, though, considering it's only just over 700kb. For some reason it took about a minute and half to load, while spreadsheets I have which are 700MB take a split second That is weird, I dont get a delay with loading. Is it the excel file or Google sheet? PPM Information Guide Survivability Tool Interface DoT Procs Guide Time Manipulation Guide Bopper Builds +HP/+Regen Proc Cheat Sheet Super Pack Drop Percentages Recharge Guide Base Empowerment: Temp Powers Bopper's Tools & Formulas Mids' Reborn Link to comment Share on other sites More sharing options...
FoulVileTerror Posted September 14, 2020 Share Posted September 14, 2020 Excel file. Opening it in Apache OpenOffice 4.1.6. Opening XLSX files normally doesn't cause this kind of slowdown. I just tested with a few other XLSX files, and all of them opened within 1 second. I saved your spreadsheet file in to the native ODS format for OpenOffice, and shaved almost half the file size, but it still takes over 15 seconds to open for some reason. I'll try rebooting my whole system later, and see if that changes anything. Link to comment Share on other sites More sharing options...
Bopper Posted September 14, 2020 Author Share Posted September 14, 2020 That is odd, keep me informed. I have nothing weird embedded. It's just text, some formatting (background color, alignment, basic stuff), and i have a filter bar set up on the top row and the first row and column are freezepane. If you continue to have issues, PM me and I can make tweaks to any of those formatting options and we'll figure out what your program doesn't like. 1 PPM Information Guide Survivability Tool Interface DoT Procs Guide Time Manipulation Guide Bopper Builds +HP/+Regen Proc Cheat Sheet Super Pack Drop Percentages Recharge Guide Base Empowerment: Temp Powers Bopper's Tools & Formulas Mids' Reborn Link to comment Share on other sites More sharing options...
Sir Myshkin Posted September 14, 2020 Share Posted September 14, 2020 I'd be inclined to blame the load time on OpenOffice, I have 4.1.2 installed on my machine still and the load time for the file was nearly a full minute, but I notice longer load times for pretty much any heavy-data grid-formatted Excel file; even one that is only a few tabs but has a significant amount of numeric values and calcs occurring still takes ~10-15/s and it's not that complicated. I have an unformatted copy of the powers data pull (sans hard stat numerics) and it's 29,053 rows and six columns, and even just being half of the total data and pure text it still takes several seconds to load it (~5-6). Speaking specifically of the Apache version of OpenOffice, it's still running 32 bit standard and, best I can quickly tell is the program is hanging on loading the data set efficiently as it hangs in the Windows conversion process for a bit before it eventually loads. I opened the file in Excel and it loads instantly. For as long as I was a user of OpenOffice (even before the development split), it just really can't match Excel for raw power, function, and load/execute speed. Checking it myself I'd lean pretty heavily that the load issue is simply just the data volume crushing OpenOffice. Side thought on the Spreadsheet: With the bar locked at the top, it'd be kind of nice/convenient to have a drop down that filtered out or selected just Primary, or Secondary, or Pools (etc) from one click to make sorting by group a bit more efficient than guessing in the current boxes. Very nice work Bopper. 1 Pylon Test Run Submission Proc Monsters (Controller Edition) Proc Monsters (Defender Edition) Pylon Test Run Results Proc Monsters (Tanker Edition) "Mad King Special" "Ceterum autem censeo Iram esse delendam" Mad King Special - Force Edition (NEW!) Link to comment Share on other sites More sharing options...
Gulbasaur Posted September 14, 2020 Share Posted September 14, 2020 On 9/13/2020 at 8:18 AM, Bopper said: (Skip ahead to 0:58 if parsing of data bores you) I mean, I'm sure such people exist... in theory, at least... Doctor Fortune Soulwright Mother Blight Brightwarden Storm Lantern King Solar Corona Borealis Blood Fortunado Dark/Dark Corruptor Rad/Rad Brute Gravity/Time Controller Storm/Water Defender Peacebringer Dark/Dark Tanker The Good Missions Guide: A Heroic Levelling Journey through Story Arcs Blueside Guide Easy IO Cheat Sheet The Mean Missions Guide: A Villainous Levelling Journey through Story Arcs Redside Guide Fortunatas are the Bestunatas Link to comment Share on other sites More sharing options...
roleki Posted September 14, 2020 Share Posted September 14, 2020 (edited) 10 hours ago, Bopper said: To add other effects will take some extra coding (and columns). But I am thinking about adding a hyperlink that would allow someone to jump directly to the RubyRed API url that contains that data. We'll see. Thats what I'm looking for with feedback...ideas. I can't afford to pay handsomely, but, I would pay looking-goodly for any resource that fleshed-out and updated Red Tomax's Power Quantification pages, ESPECIALLY if that resource split open the pseudopets and made them reveal their secrets. It's been 15+ years, I need to know what "Summon Sticky Arrow" actually DOES! ETA: Of course, if you didn't lift another finger on this project of yours, it's still an awesome effort and much appreciated! Edited September 14, 2020 by roleki Well, which is it, young feller? You want I should freeze or get down on the ground? If'n I freeze, I can't rightly drop. And if'n I drop I'll be in motion. Link to comment Share on other sites More sharing options...
Bill Z Bubba Posted September 14, 2020 Share Posted September 14, 2020 (edited) 13 hours ago, Bopper said: That is weird, I dont get a delay with loading. Is it the excel file or Google sheet? 4 seconds to load with excel 2013. Edit: By the dark gods I don't have time for this! But it's an awesome problem to suddenly have. Thanks, Bopper. Edited September 14, 2020 by Bill Z Bubba Link to comment Share on other sites More sharing options...
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