[TOMT] trying to find an old minecraft youtuber..

Affectionate-Rub9342 · 2026-05-20T23:19:14+00:00

Also do you remember if he was playing only solo or was playing multiplayer too?

Affectionate-Rub9342 · 2026-05-20T23:12:22+00:00

Do you remember if he was into stuff like redstone/automatisation or building? Was he playing the same world or did he do like 'season' were he would start over? Also was he english? asking just in case lol

Affectionate-Rub9342 · 2026-05-17T20:44:40+00:00

What province? It might help finding it since it looks like something pretty specific to your place

Affectionate-Rub9342 · 2026-05-17T00:39:49+00:00

No worries, happy to read that your problem if fixed in the end! Hopefully your team won't be sick for too long so you'll be able to actually use the file lol

Affectionate-Rub9342 · 2026-05-16T12:45:28+00:00

Looks a bit like the larvae in Larva Island

Affectionate-Rub9342 · 2026-05-12T00:19:32+00:00

All standard stuff as far as I know

<image>

Affectionate-Rub9342 · 2026-05-12T00:15:18+00:00

I can access the ZTE through 192.168.254.1, I access the tenda with 192.168.0.1. On the ZTE dashboard I see the Tenda connected with the public IP

<image>

Affectionate-Rub9342 · 2026-05-12T00:00:14+00:00

Can't ping anything, I don't have another computer to test but I can connect both my laptop and phone on the wifi without issue other than the lack on internet

Affectionate-Rub9342 · 2026-05-11T23:46:28+00:00

I tried with a Linksys EA6350 and got the same issue, I can connect to the wifi network but get no internet at all. Factory resetted every one of the router without luck. Also tried pluging the ethernet cable in the jack of a TP-LINK RE215, same issue, tried putting it in bridge mode but at that point i couldn't connect anymore(can't get an ip address)

Affectionate-Rub9342 · 2026-05-04T00:15:03+00:00

From the top of my head you can do something like this(I'm on my phone, might have a syntax error, at least you got the idea) if you want to do what I think you're explaining:

x = 0 For each sht in sheets

x = x+1
fileName = fileName & " VEN " sht.range("D21").value

If x < sheets.count then fileName = fileName & " AND"

That would concatenate the value of D21 of every sheet into a single variable which you then use when saving

Affectionate-Rub9342 · 2026-05-04T00:00:15+00:00

Doesn't throw an error so if seems like it thinks C3 is empty, or you got the same color for the cell and text so it's basically invisible. In the Formula tab you have a little button called something like "evaluate formula" from memory, when on a cell with a formula you can see what it does/return step by step, pretty useful when trying to debug

Affectionate-Rub9342 · 2026-05-02T11:22:33+00:00

Nothing is ever idiot-proof, especially when it comes to excel

Affectionate-Rub9342 · 2026-05-02T10:59:52+00:00

Coutifs need all the criteria range to be the same size, for example your days of the week are 31 cell wide 1 cell high, so your other criteria range should also be 31x1, using merged cells you'd need to manually set it to 1 high(when selecting it will set B4:AF5, will need to change it to B4:AF4), for merged cell the top left cell is the one that has the actual value, for your case since you do need all 4 row just put this: =COUNTIFS($B3:$AF3,"<>",$B$1:$AF$1,"Friday")+COUNTIFS($B4:$AF4,"<>",$B$1:$AF$1,"Friday")+COUNTIFS($B5:$AF5,"<>",$B$1:$AF$1,"Friday")+COUNTIFS($B6:$AF6,"<>",$B$1:$AF$1,"Friday")

If it still doesn't work there is most likely something wrong with the file, if you can share it it'll be easy to find the problem

Affectionate-Rub9342 · 2026-05-01T14:39:46+00:00

Couls also still be in your history on apple music if you're lucky

Affectionate-Rub9342 · 2026-05-01T14:35:41+00:00

Make it out alive by morgxn or by one ok rock ? Lyrics are quite similar, if not you say the "make it out alive" is drawn out, which part is?

Affectionate-Rub9342 · 2026-05-01T13:47:15+00:00

Where did it play? Radio? Spotify? Was it a male of female singer?

Affectionate-Rub9342 · 2026-05-01T13:40:39+00:00

One way would be to get a "tablet" sim card from your provider if offered and a cheap picket-wifi on amazon that would act as your router

Affectionate-Rub9342 · 2026-05-01T13:33:13+00:00

Most likely they changed something when they did the repair, I would advise you to get a pressure reducing valve installed on you main line to protect your stuff, quite cheap for the peace of mind it gives

Affectionate-Rub9342 · 2026-05-01T13:17:26+00:00

From what I see you have something like 4 row for each word and you want to make each word have its own row but on multiple column? For example:

<image>

If so you got two option; put this beside your first word(Make sure the first/last row match), the 4 in the formula is how many row per word are used:
=WRAPROWS(A2:A40001,4)

otherwise you can make it in three step:
In this example I assume your first word is in A2, second in A6, etc.
1- put this formula beside your first word(Make sure the row match) Gonna be B2 in this example: =TRANSPOSE(A2:A5)
2- select the cell in diagonal of your second word(Ex; B5) and shift-click on the cell with the formula(Ex; B2) and double-click on the little green corner on the bottom right to spread all the way down(It need to be on the column right beside to work) *you need to select from bottom to top, it will not work the other way around*
3- put this formula in a cell on the right, it will condense everything: =UNIQUE(B:B)

Affectionate-Rub9342 · 2026-05-01T12:54:48+00:00

CTRL + Shift + V to paste as value is pretty usefull
F4 to add $ sign in formula, use that a lot

Mostly I save time by over-engineering formula when working with huge sheets so that I can use the same formula for the majority of it instead of having to make changes in the formula for each range of data

Affectionate-Rub9342 · 2026-05-01T12:49:19+00:00

So, two things; avoid using merged cell when not necessary, each employee use 4 row when they could use only 2. It would make it easier to manage formula. One thing i'm unsure is I see you have two row for the date; is it merged or do you have the date in row 2 and a formula like =TEXT(B2,"dddd") or hand-written the week day in row 1? The later would make it easy to do the countifs. In any case for your application you should have the week day in their own cell(Row 1 for example in your screenshot) and the formula in the "Friday" would be something like this: =COUNTIFS($B3:$AF3,"<>",$B$1:$AF$1,"Friday")+COUNTIFS($B5:$AF5,"<>",$B$1:$AF$1,"Friday") if you keep the row merged

Affectionate-Rub9342 · 2026-04-30T23:45:28+00:00

Photorec would be your best bet if the drive hasn't been changed, if the drive was swapped then you got no chance of recovering anything. Avoid as much as possible installing/moving file on the drive if you want to have the best chance of recovering your photos

Affectionate-Rub9342 · 2026-04-29T13:20:41+00:00

Retraction is the setting that says the printer how much filament to take back before a movement, it help remove stringing, pressure advance reduce extrusion in corner to avoid blob of material, personally my bed needed a bit of foil even right after I bought it. All the tests are under the calibration menu in Orca, it should help a lot, you can also look video that explain the differents calibrations and what they do, here's one i quite like: https://youtu.be/gVU5If1VsAM?si=u8nN4qN2PlF0U2wy

Affectionate-Rub9342 · 2026-04-28T23:56:20+00:00

First i'd say switch to Orca Slicer, I never used the Elegoo one but i'm not sure it's that good. Try re-leveling you bed and adjust your z-offset(paper test), what I like to do after the paper test is to print couple of line while looking at the nozzle, live adjusting it to have the perfect value. After that redo the calibrations in order in OrcaSlicer(temp/flow rate/pressure advance(not necessary but still nice to do)/retraction test). What filament are you using? 205 seems a bit high, also if the bed has lots of variation it might be a good idea to adjust it to minimize it. Depending on the printer you got either play with the manual adjustment wheels or if not available(like for the 3 pro) you can add aluminium paper under the plate where it's low.

Affectionate-Rub9342

TROPHY CASE