laggy-erc-with-sim-embeded-into-a-sheet

KQM | Genshin Impact

149 messages

TiBotSat, January 14, 2023 at 12:07 AM

@rarepossum - As an author, it is your responsibility to complete the ticket

Guidelines
- You can rename your ticket with /rename <ticket name> or with the button below
- If this ticket was created by accident or it can be deleted, you can use /delete within the first 5 minutes, otherwise ask a Scholar.
- When you are ready to submit the ticket, compile everything into one message following the format below and pin it. Then type /close or click the button below; the ticket will automatically be moved to be reviewed.
- To add contributors to your ticket you can use /contributor add <user>.
- The ticket will be scrapped if: no activity >1 week or open for >1 month.

Write-up Format

Theory/Finding/Bug: Title of your submission

Evidence: Explanations with calculations and/or YouTube/Imgur proofs

Significance: Conclusion

rarepossumSat, January 14, 2023 at 12:09 AM

I hath created an erc which uses a monte carlo simulation to more accurately determine thresholds to be able to burst 80% of the tiem (or whatever you want)
https://1drv.ms/x/s!Ap7IaLqG1nQsrmust_so0wQ7axAk?e=TeUlI2

montecarloerc.xlsx

Microsoft Excel Workbook

Featuring:
- should be a more accurate erc overall
- percentage funneling
- adding paimon as a teammate, disabling electro resonance but increasing the off field energy mod
- a terrible interface
- some other stuff I can't remember
- noticable lag during inputs because its running 4K iterations

will migrate to google sheets when done

still need to to do a how to use page for this mess

and some tools like raiden refund and that jaz

ALso nothing is a turret anymroe

wrong pingSat, January 14, 2023 at 01:24 AM

Reply to

rarepossum: will migrate to google sheets when done

wrong pingSat, January 14, 2023 at 01:25 AM

4k iterations in google sheets

rarepossumSat, January 14, 2023 at 01:25 AM

Not my problem

it doesnt need solver

so its fine

Reply to

rarepossum: I hath created an erc which uses a monte carlo simulation to more accurately determine thresholds to be able to burst 80% of the tiem (or whatever you want)

litkzhSat, January 14, 2023 at 03:08 AM

can you explain how this is more accurate

it probably is but im failing to understand how monte carlo sims would be necessary for accurate energy sims

Reply to

litkzh: can you explain how this is more accurate

rarepossumSat, January 14, 2023 at 03:09 AM

Its more accurate when you want a conservative guess

so for example with the main erc

its just an average

you set it to safe

it lowers the average

but it does it in a method which isnt particualrly accurate

with some characters being more or less penalised than others

Yae for exmaple is penalised extremely heavily for being a turret, even though she has no variance in particle gen

Similarly turretns in general are pretty in accurate

litkzhSat, January 14, 2023 at 03:11 AM

wait what

rarepossumSat, January 14, 2023 at 03:11 AM

For example guoba is modelled as a turret, so his paticles will get funnelled based on field time

but its 100% possible to funnel guoba

litkzhSat, January 14, 2023 at 03:11 AM

rarepossumSat, January 14, 2023 at 03:11 AM

at least I think hes modelled as a turret

litkzhSat, January 14, 2023 at 03:12 AM

ye he is

rarepossumSat, January 14, 2023 at 03:12 AM

this means taht character may be getting particles when they shouldn't be

or characters aren't getting enough particles

litkzhSat, January 14, 2023 at 03:12 AM

so is no one a turret now

rarepossumSat, January 14, 2023 at 03:13 AM

Yeah, but you can keep them as turrets if you want

with work arounds

but it allows for more accurate, if more hassel

But the main thing is you can determine how much er you would need to burst with 0%, 25% 50% 75% 80% or 100% consistency (assuming fav procs as stated and you hit all your abilities)

litkzhSat, January 14, 2023 at 03:14 AM

interesting

dont fully get it but this is really interesting

rarepossumSat, January 14, 2023 at 03:15 AM

This is replicating the erc's "safe mode"

but without the arbitrary penalities

litkzhSat, January 14, 2023 at 03:16 AM

okay

so just
now noticably accurate in certain areas
more intensive in all areas?

rarepossumSat, January 14, 2023 at 03:17 AM

Yep

Though if you have no turrets

its very simple

also percentage funneling

for when a character funnels to multiple other charactesr

litkzhSat, January 14, 2023 at 03:18 AM

best@feature

so it really is erc++

rarepossumSat, January 14, 2023 at 03:18 AM

but even uglier

litkzhSat, January 14, 2023 at 03:18 AM

are there any features not present?

rarepossumSat, January 14, 2023 at 03:18 AM

Reply to

rarepossum: but even uglier

litkzhSat, January 14, 2023 at 03:18 AM

switch to google sheets

rarepossumSat, January 14, 2023 at 03:19 AM

I'm planning on adding shit like raiden er restoring calc

klee energy refund chance/average

Mr. Pillow | PhD. in IttoSimpingSat, January 14, 2023 at 03:19 AM

this is basically #1002403510555521065 but better isnt it

rarepossumSat, January 14, 2023 at 03:19 AM

Yeah

litkzhSat, January 14, 2023 at 03:19 AM

whats alt erc even

rarepossumSat, January 14, 2023 at 03:19 AM

monte carlo instead of formula

I worked on taht too

litkzhSat, January 14, 2023 at 03:19 AM

wait

rarepossumSat, January 14, 2023 at 03:19 AM

well gave feed back on it

Reply to

litkzh: whats alt erc even

Mr. Pillow | PhD. in IttoSimpingSat, January 14, 2023 at 03:20 AM

it can also do "er needed to burst x% of the time" etc.

litkzhSat, January 14, 2023 at 03:20 AM

what does alt erc do better than erc

Reply to

Mr. Pillow | PhD. in IttoSimping: it can also do "er needed to burst x% of the time" etc.

litkzhSat, January 14, 2023 at 03:20 AM

rarepossumSat, January 14, 2023 at 03:20 AM

It attempts the same thing as this

but with formula

litkzhSat, January 14, 2023 at 03:20 AM

rarepossumSat, January 14, 2023 at 03:20 AM

instead of simualtions

litkzhSat, January 14, 2023 at 03:20 AM

instead of brute force

rarepossumSat, January 14, 2023 at 03:20 AM

conclusion was, you needed a solver for it to work

so it stalled

Mr. Pillow | PhD. in IttoSimpingSat, January 14, 2023 at 03:21 AM

i'm still waiting for a gcsim erc tho

gonna ask kyle about it after he completes the histogram request first

rarepossumSat, January 14, 2023 at 03:21 AM

hes already mentioned it

erc.gcsim.app

today actually

https://discord.com/channels/763583452762734592/851428030094114847/1063612429793243187

Its missing er buffs and doesnt account for fav proc chance though

litkzhSat, January 14, 2023 at 03:26 AM

was there one previously

rarepossumSat, January 14, 2023 at 03:26 AM

cos I need to figure out how to actually do those

litkzhSat, January 14, 2023 at 03:26 AM

in the desktop client

SilentSat, January 14, 2023 at 03:27 AM

This is pretty cool, funneling hasn't been implanted yet in this, right?

Reply to

Silent: This is pretty cool, funneling hasn't been implanted yet in this, right?

rarepossumSat, January 14, 2023 at 03:27 AM

They have

theyre just in drop downs

SilentSat, January 14, 2023 at 03:27 AM

rarepossumSat, January 14, 2023 at 03:27 AM

So you need to expand the groups

cos it gets really long

if you don't collapse them

SilentSat, January 14, 2023 at 03:27 AM

Ooooh I see

rarepossumSat, January 14, 2023 at 03:27 AM

litkzhSat, January 14, 2023 at 03:27 AM

reminding me of gcsim made me understand how this works now

thanks

SilentSat, January 14, 2023 at 03:27 AM

Thank you

rarepossumSat, January 14, 2023 at 03:41 AM

also shit like this

so with this setup, on average raiden needs 168% er

but best case only needs 143

worst case needs 200

Reply to

Mr. Pillow | PhD. in IttoSimping: gonna ask kyle about it after he completes the histogram request first

unleashurgeekSat, January 14, 2023 at 03:55 AM

how considerate of you to not stack requests

Reply to

unleashurgeek: how considerate of you to not stack requests

Mr. Pillow | PhD. in IttoSimpingSat, January 14, 2023 at 03:57 AM

it's cuz the latter depends on the former

unleashurgeekSat, January 14, 2023 at 03:58 AM

maybe

Reply to

rarepossum: Yae for exmaple is penalised extremely heavily for being a turret, even though she has no variance in particle gen

twce_Sat, January 14, 2023 at 08:23 PM

Can't you just like

Poke Zak

And make him fix

rarepossumSat, January 14, 2023 at 08:36 PM

Its a flat penality to all turrets, I think its more than a simple fix

thats needed

All Character data in copies should now update if I update the master copy

al haitham and yaoyao should be good now

@charliex3000

👍1

TiBotThu, January 26, 2023 at 04:30 AM

This channel hasn't been active in the past week!

rarepossumTue, January 31, 2023 at 05:55 AM

I;ve added a how to use page now

TiBotTue, February 7, 2023 at 06:00 AM

This channel hasn't been active in the past week!

rarepossumTue, February 7, 2023 at 06:22 AM

Its done, technically

I just need to port it

https://docs.google.com/spreadsheets/d/1xHEy8rz6tz9fNGTpRDGTWOEwT0jfD5xQQlch-iIDGZQ/edit?usp=sharing

montecarloerc

How to Use

Preface
This is an attempt to create a more accurate Energy Recharge Calculator for Theorycrafting Purposes.
It uses a Monte Carlo simulation to simulate all Particle Drops and uses that to determine how much Energy each Character needs
This does mean though, that it does run slower ...

Ported over to google sheets

charliex3000Wed, February 8, 2023 at 04:32 AM

How... Laggy... Is it in Google sheets?

rarepossumWed, February 8, 2023 at 06:22 AM

I dunno

I was remoting when I did it

But it wasn't that laggy it semed

Its actually pretty smooth

on sheets

rare sheets dub?

Wait no

thats because its not montecarloing at all

Alright thats fixed

Takes ~10s on my pc after a change is made

Sheets is a faster by a bit

on my pc anywya

Anyway I think its done

charliex3000Sat, February 11, 2023 at 03:12 AM

Can you set how many iterations it runs?

rarepossumSat, February 11, 2023 at 03:16 AM

I could implement that yes

Sheets now has an interations option

defaulted to 250

now takes 4-5s on my pc, much faster

I think its done

TiBotMon, February 13, 2023 at 09:13 AM

Ticket closed by @rarepossum. If there are any issues with it - it can be reopened by the owner or staff by using the buttons below or /open.

charliex3000Fri, March 24, 2023 at 09:15 PM

~~update for mika?~~

✅1

TiBotTue, August 22, 2023 at 10:39 AM

Ticket verified by @Shampoo | burger enthusiast

Ticket verified by @🐟

Created transcript!

Transcription has been made and is available on https://tickets.deeznuts.moe/transcripts/laggy-erc-with-sim-embeded-into-a-sheet - Fetched a total of 146 messages!

is_this_maddieTue, August 22, 2023 at 01:25 PM

charliex3000Tue, August 22, 2023 at 02:31 PM

POG

TiBotTue, May 28, 2024 at 11:05 PM

This ticket will shortly be deleted - by @jamberry since yall r confused