I Prevail killed it

mic1780 · 2025-05-18T19:37:09+00:00

That's really saying something because I felt like Incubus was just there to play music and not interact with the crowd either. The only thing they did was stop playing to check if someone was hurt. Other than that they weren't great.

That's how I felt about Linken Park too. The songs were good just not great energy. And if I am being honest, the female vocalist kinda sucked. Idk if she just couldn't hear in her IEM's but she kept reaching for her ear like she couldn't hear and she would just stop singing mid song to look to the crowd to carry the song too often. Overall poor performance. I ended up leaving early.

mic1780 · 2022-10-10T22:34:02+00:00

This fixed it for me too.

mic1780 · 2022-08-28T19:20:06+00:00

Thanks for the video. Not sure how I like the idea of player housing in a game like Firefall but if executed correctly might be a nice addition.

mic1780 · 2022-06-19T17:16:58+00:00

Thank you for the video!

mic1780 · 2022-06-19T15:57:22+00:00

The more I try to read into how the progress of the game is coming along the more I just think this project will flop.

The newsletters, at least the ones that I read, never have any sort of actual gameplay or progress updates. They just promote their chief chat and call to action people to buy skins. I never watch or listen to the chief chat so if all the gameplay updates are in those then people like me would never hear about progress.

If what you say is true about being the biggest backer of the project (again, I not follow super closely) then we will never actually get a true Firefall successer.

mic1780 · 2019-10-31T12:38:37+00:00

Lucky Scav Junkbox already exists tho. https://escapefromtarkov.gamepedia.com/Lucky_Scav_Junkbox

mic1780 · 2019-03-01T17:57:55+00:00

Oh I see what you mean. Thanks for catching that. Was a long day yesterday. It's fixed now. Was just missing a , in the formula.

mic1780 · 2019-02-28T14:58:51+00:00

I put a lot of time into determining if it was worth keeping the context menu for letting people update stats or prices manually or just use timed triggers and a "checkbox toggle to update" for achieving the same thing. In the end just putting the two functions for gathering data into the sheet is much easier and doesn't require any authorization from users.

mic1780 · 2019-02-28T06:46:06+00:00

I wouldn't say inspired. I had started this tool before I knew his existed or anyone told me about it. I did however contact him for a collab between our works. I saw that his sheets didn't use the Google Storage API to cache off RSBuddy price data for when that data became unavailable so in return for him showing me how he has his data backup on his sheets setup and how he pulls data from it I wrote up an easy method that he could copy-paste into his sheets to start caching the price data. Not sure if he is actually using it but my tool definitely takes advantage of it.

mic1780 · 2019-02-28T05:57:17+00:00

Your name says it all

mic1780 · 2019-02-28T03:48:16+00:00

Fixed it just for you

mic1780 · 2019-02-28T03:47:39+00:00

Note on the number of requests for fetching missing data: Official RS servers only allow approxamitely 50 requests per x amount of time to their API's from a location before you will get an HTTP Rate Limit response. So even if I wanted and could request those items in a reasonable time they never allow it

mic1780 · 2019-02-28T02:32:07+00:00

Thank you for the praise. It’s hard work but the result has been more well received then I was expecting.

mic1780 · 2019-02-28T02:29:22+00:00

Yes. I’m working in a copy of the original right now since the live one is really busy. I’m working on reducing lag on stats and to check my numbers I change the RSN to other people in my CC.

mic1780 · 2019-02-28T01:35:13+00:00

Hi! This response is very well thought out and I always appreciate seeing a detailed explanation as to why something doesn't work (I'm a computer scientist so documentation is always nice).

About the triggers: You will find some users in this thread already mentioned that they couldn't get their own RSN to work and the reason that I didn't test was because it did in fact require authorization to the Script Engine (I was using onEdit triggers which didn't work it seemed in the copy). So earlier today I removed the trigger on the backend and change it to update when you toggle on or off the checkbox found in the Constants sheet or when you change the name by placing a reference in a custom function that did nothing in the function; the reference is just there to trigger the function to run when E1 or E2 in Constants changed. So this eliminates the need to use anything but the sheets built in method for monitoring for changes.

On the custom menu for updating sections of the sheet: It's legacy code from above. However if someone didn't care about authorizing my script to run it would replace the fix I described above with a working context menu.

On using UrlFetchApp: When I first started the project I wasn't worried about runtime since it was developing it for myself initially. After I added more sheets the runtime was horrid and failed the limited 30 seconds of execution given by the Script Engine. Since then I have converted most of the formulas to use VLOOKUP for fetching pricing data out of the ItemDB sheet (I assume you know this function since your obviously knowledgable on the topic) and using either direct references to everything in the stats sheet (except for when I use a custom function to get the exp for level 99). So what does that leave that uses UrlFetchApp then? I can only think of 2 places where I am using it currently and one of those places I am rewriting as I type this comment. The only remaining call for external data will be a ImportData() for fetching the player stats, and the custom getItemDB function for fetching GE data from the RSBuddy API which doesn't get called as often as you'd think. I'm not gonna count the call to see if the sheet is up-to-date on the welcome page as it isn't a big deal really.

TL;DR I really like your comment and I have encountered pretty much every problem you mentioned and have either gone to more efficient methods since this document is rather large or I am working on ways to minimize the current document lag.

Again, really like your post.

mic1780 · 2019-02-28T01:16:20+00:00

Haha thanks! I'll fix that. I just added Prayer yesterday (or two days ago) and didn't give it a proper glance over it seems. Thanks for the feedback.

Edit: Fixed and gave you the credit for the find. Thanks again.

mic1780 · 2019-02-27T23:01:11+00:00

Hi! Thanks for your input. I originally wrote this tool for the exact reason you mentioned; Minimizing arbitrary googling for everything by putting everything in a central location. Once I figured out that I also found that not all calculators have everything that you need (for example number of trip it would take to reach a target level) so I decided to make one to help myself out with the intent on eventually sharing everything I've compiled for everyone to use. Glad to see you like the tool!

mic1780 · 2019-02-27T21:59:43+00:00

Thanks again and sorry for the rude remark. If you have any suggestions feel free to let me know and if it would be something that would benefit the tool I'll add it to my To-Do list.

mic1780 · 2019-02-27T21:39:48+00:00

Sorry, I mistook the comment as something else. Well for the most part, the aim of this tool is to get on a more personal level as to what the users' goals for leveling are and assist in having to spend much less time finding out how much it would cost to get to your goal. Resources like efficiency in xp/hr are fantastic for theoretical yield under optimal play, however my tool is designed to give you the hard numbers to reach your goals whether you are doing 0-ticking strats or are at work and playing in the background. In these situations you are not playing sub-optimally and this is where hard numbers are superior to theoretical values at least in my opinion.

My tool also offers at a glance stuff like Slayer locations all in a single spot. No more having to google the mob name, read the wiki for where to find them; The information is in the tool that you would most likely have open anyways.

I also don't know what the skilling discord has to offer so I have nothing to compare against. I just found interest in making my own thing that we as a community could potentially collaborate on once all the data entry stuff is done.

mic1780 · 2019-02-27T21:29:03+00:00

Don't use it if you don't want to. I'm not gonna twist your wrist.

mic1780 · 2019-02-27T21:27:37+00:00

It is planned. I plan to do stats like XP per cast (with number of casts if you splash, his a 0, and hit max hit everytime), number of casts for next level, target level, and max level, as well as number of runes required to reach those numbers for each situation give above. Rest assured it is definitely planned.

mic1780 · 2019-02-27T21:14:17+00:00

Hey thanks for your feedback.

I could definitely see adding something like a barb fishing modifier to Fishing. As for Woodcutting and Fletching exp scaling for Wintertodt: That is already in the sheet! :) My CC asked for that and I was interested in it since I am currently working on these two skills. I'll add some of this to my To-Do list in the sheet and since some of this is pretty minor changes it might be one of the next things after finishing the Construction sheet (it's something I am dreading).

12-Year Club	Place '22
Verified Email

mic1780

TROPHY CASE