Would something like this be of interest to anyone?

[Bopper]

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

[summers]

Very!!

[Xeres]

Yep!

[FoulVileTerror]

Who -wouldn't- be interested in that?

GIMME!   (please, thank you, and if you're willing to share)

[Omega-202]

Yes please and thank you.  

[Bill Z Bubba]

Are you calculating in Arcanatime or is that coming in with the data? Also, HELL YES PLS.

[Ukase]

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. 

[Lines]

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

[Bopper]

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. 

[AboveTheChemist]

I like it!

[FoulVileTerror]

I counter with:  https://www.youtube.com/watch?v=ir-y6-L6Vlk

[LiquidBandage]

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.

[Bill Z Bubba]

4 minutes ago, LiquidBandage said:

What is 'Arcanatime'?

https://archive.paragonwiki.com/wiki/ArcanaTime

[Bopper]

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.

[Bopper]

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

[FoulVileTerror]

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?

[Bopper]

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.

[FoulVileTerror]

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.

[Bopper]

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?

[FoulVileTerror]

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.

[Bopper]

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.

[Sir Myshkin]

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.

[Gulbasaur]

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...

[roleki]

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

[Bill Z Bubba]

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