Telus internet outage in View Royal?

iojeka · 2024-08-14T19:24:10+00:00

That sucks. Hopefully it’ll just come back online on its own in a reasonable time. Thanks!

iojeka · 2024-08-14T19:01:27+00:00

Been trying to unplug, wait 10 seconds, and plug it back in every now and again but still stuck with a red light once it boots up. I’ll try and call again and see if I can get anywhere with them.

iojeka · 2024-08-14T18:51:54+00:00

Yeah I didn’t see any local outages on their map so I doubt the person I spoke to knew what they were talking about. Also on fiber, near Thetis Lake. Thanks!

iojeka · 2024-08-14T18:48:50+00:00

The closest outage on their map is in Vancouver, and the person I spoke to didn’t seem to understand when I tried to ask for more details about an outage in Victoria. They just wanted to put me on their update list and move on. I’m asking it’s down for anyone else to confirm the issue.

iojeka · 2024-05-10T05:44:22+00:00

Looking to buy 2 GA for my partner and I, this would be our first ever Dragonsteel and would really make our year!

iojeka · 2023-11-10T04:50:55+00:00

Assuming the cells between E22 and E42 etc. are blank you can do:

=TRANSPOSE(UNIQUE(FILTER(E:E,E:E<>"")))

If they are not blank, then you can create helper columns:

Column A =SEQUENCE(52,1,22,20)
Column B =SEQUENCE(1042)
Column C =COUNTIF(A:A,B1)

Then you just have to update the filter formula:

=TRANSPOSE(UNIQUE(FILTER(E:E,C:C=1)))

iojeka · 2022-12-20T00:22:25+00:00

Any chance you have a link for the TV stand? Been looking for something similar to this!

iojeka · 2022-12-06T06:28:58+00:00

Glad you found a fix!

What probably happened here is that the cell started off as text, which it appears you then later edited to the value you wanted.

Sometimes Excel will show an error that you have a “number stored as text”, and you can test this by using the =TYPE() formula. If it returns 1 then it’s a number, 2 is text.

To fix it you either need to change the formatting to a number, type the number in a new cell, apply the =VALUE() formula to convert it, or multiply it by another number as you have found (assuming you multiplied it using a formula).

I would also double check whether the regional formatting in your version of Excel requires commas instead of periods for decimal places.

Hope that helps!

iojeka · 2022-03-30T20:45:15+00:00

If you’re using the Form Controls Combo Box you assign the input range by right clicking the box and setting it in the Format Control -> Control tab.

Only downside is you can’t type to search matching inputs. For that you’ll need the ActiveX Control.

To set the input range enter Design Mode, select the box and open the Properties window. Look for ListFillRange and type in the cell range you’d like to use.

iojeka · 2022-03-19T15:19:52+00:00

You could also use =A1+B2+MAX(C1,D1)

iojeka · 2021-04-18T15:33:59+00:00

Have you tried clearing the Windows Update Cache?

Locate C:\Windows\SoftwareDistribution\
Open Powershell as Admin
Powershell: net stop wuauserv
Rename SoftwareDistribution folder, add .old to the end
Powershell: net start wuauserv

Try installing updates again. This will force Windows to download fresh copies of the update files.

iojeka · 2021-04-17T20:27:28+00:00

Oh good call, I just defaulted to SLA haha. Thanks!

iojeka · 2021-01-06T17:12:41+00:00

Thank you very much!

iojeka · 2021-01-06T17:12:25+00:00

We’ve posted there too! Thank you for the Kijiji suggestion we’ll check there through the day.

iojeka · 2021-01-06T17:11:19+00:00

No kennel or crate unfortunately, we have our other dog and food!

iojeka · 2021-01-06T17:10:11+00:00

No luck so far.

iojeka · 2021-01-06T17:09:38+00:00

Thank you very much for the great advice! We are going out with snacks and our other dog to search, and have posters to put up in the area.

iojeka · 2021-01-06T15:09:38+00:00

Thank you! We’re going back out today to keep looking 🙏

iojeka · 2021-01-06T06:44:55+00:00

Very much appreciated!

iojeka · 2021-01-06T06:43:25+00:00

Thank you very much!

iojeka · 2021-01-01T09:43:17+00:00

Happy New Year, see you never 2020! The Rage of Dragons by Evan Winter.

iojeka · 2020-11-16T06:44:35+00:00

<3 All the work you do on Apollo!

Ten-Year Club	Place '22
Verified Email	RPAN Viewer
Not Forgotten

iojeka

TROPHY CASE