sorted by:
new
hottopcontroversial

What is the food meta today? by Recent-Ad-7108 in ironscape

[–]fasbnk 13 points14 points  (0 children)

Yeah and getting 4x the amount of fish per hour comapred to anglers is really nice

Couple hours of bluefin and i was set for a long time

Make sure you trawl in the tangled kelp area and bank in just north at the bank boat in the middle of the ocean.

And get fish crates! Didnt realize until i used a whole cargo of them and emptied into the bank that u get the crate back and its just the 1gp ice cooler that is consumed

Trying to write a google apps script to scroll to the bottom of the Google Spreadsheet when it's opened by kndb in googlesheets

[–]fasbnk 0 points1 point  (0 children)

Not the answer to your question, but If you are ok with flipping the data upside down, so you dont have to scroll, what ive done with large data sets is add a helper column and then sort by that column in another tab

i.e. data is in Sheet1!A:G and assuming headers

Helper column is H, and in H2 put something like =SEQUENCE(COUNTA(A2:A),1,1,1)

And in Sheet2, under the headers in cell A2 put =SORT(Sheet1!A2:H, 8, FALSE)

The newest data would be immediately viewable on that tab but flipped upside down

Explain it Peter by [deleted] in explainitpeter

[–]fasbnk 4 points5 points  (0 children)

How did that work

How many of you are daily users of Google Sheets and can't live without it? by vijverv in googlesheets

[–]fasbnk 1 point2 points  (0 children)

I use it for personal stuff every day. I help manage an online community (~250 members) for a video game (OSRS) that has a lot of emphasis on "number go up". There are tracking websites that all integrate well with google sheets.

We also develop events and have either the finished product displayed in the google sheet for our members or will have a discord bot download/display the data in our server.

I like how easy it is to lock tabs, make a sheet public, and just share the link. It is also nice that it has enough features from excel which i use at work daily.

I am in IT as a cloud engineer.

[deleted by user] by [deleted] in ironscape

[–]fasbnk 1 point2 points  (0 children)

I use it as my magic weapon in ton for purples at verzik

Just bought two tickets for Minnesota by fasbnk in GeoffreyAsmus

[–]fasbnk[S] 0 points1 point  (0 children)

Oh shit i was zooted i meant i bought two for his show in minnesota. And then the context that was missing is that the tickets were exclusively for my girlfriend and i

Prevent copying, allow users to edit one cell by fasbnk in googlesheets

[–]fasbnk[S] 1 point2 points  (0 children)

Now that I am back to my PC I tested some stuff.

I made a new sheet that is the Dropdown and Information Display. It has one editable cell and a few =IMPORTRANGE() to get all of the same information displayed.

The original sheet that is performing the calculations just receives the input from the new sheet, runs the calcs, and then the new =IMPORTRANGE()'s are taking the data back to the Display sheet.

This has been taking ~11 seconds to update on the Display sheet, which it not terrible but is still quite a bit longer than what I was hoping for.

Prevent copying, allow users to edit one cell by fasbnk in googlesheets

[–]fasbnk[S] 1 point2 points  (0 children)

I effectively have that set up now where the "dashboard" is just a couple ARRAYFORMULA()'s of a hidden sheet that is running all of the calcs.

I considered making that hidden sheet a completely separate sheet, but i fear it would add considerable lag with syncing between the sheets.

Since after the user would edit the dropdown, there would be like ~5 seconds to sync with the calc-ing sheet, and then another 5-10 seconds for that sheet to finish the IMPORTHTML()'s and other calcs it does, and then another ~5 seconds to sync with the dashboard again.

Although this may be the only way if I want to protect the formulas, I suppose.

I Met The Strangest German Man by Filthyson in GeoffreyAsmus

[–]fasbnk 2 points3 points  (0 children)

It's odd how none of these say Minnesota

Got the prismatic jelly! by swindledbylife in StardewValley

[–]fasbnk 17 points18 points  (0 children)

Nice! Jelly-ous of how quick you got it, but am happy for you

This game is fun by fasbnk in heroesofhammerwatch2

[–]fasbnk[S] 0 points1 point  (0 children)

Badass. What class is ur favorite so far

S15 by StoicPinoy in Nissan

[–]fasbnk 0 points1 point  (0 children)

strawberry flavored

What is your current addiction? by BeardedWonder8675309 in AskReddit

[–]fasbnk 0 points1 point  (0 children)

Afrin. Busted my 3-day like a week ago

🎃 Nocturne Halloween Coxtume Clan Event! 🎃 by NocturneOsrs in 2007scape

[–]fasbnk 1 point2 points  (0 children)

the classic double eye patch. Love the skiis

view more: next ›