Loza's Blog

Friday, April 21, 2023

Move Cell Text Into Separate Columns

Highlight the text in the column you want to seperate in my case A2-A4

Then Hold Down ALT and A ,then press E twice, a convert to text box wizard appears, click next

Then next again

Then finish

Add Space Between The Number And Text Excel

Add values in column A1 then in select B1 and add this fomula to the formula bar marked in Red then press enter.

Now while holding left click (marked in green) then drag down to include all cells with updated formulas

You should now see the numbers seperate from the text.

Monday, April 17, 2023

Aquasphere Chlorinator No Display No Output

Fault No Display no output will not power on

Replaced T2amp (slow blow 2Amp and 3.6V V80h Varta Rechargeable Battery With 2 Pin PCB Mount

I found the instructions here : https://www.blpumps.com.au/wp-content/uploads/2020/01/Zodiac-Aquasphere-or-D15-1.pdf

Saturday, February 18, 2023

Microsoft Edge Browser Support For Dahua, Hikvision And More

Using Microsoft Edge in Internet Explorer Mode is the best option as Chrome is not always compatible.

First open Microsoft Edge then type the IP address of the camera in my case 192.168.0.204.

It came back with this error message: http://192.168.0.204/notSupported.asp

You will need to enable Internet explorer mode in Microsoft Edge

Click on the "three dots" in the top right then scroll down till you find "Reload in Internet Explorer mode".

If you get the below dialog box, enable "Open this page in Compatibility view" and "Open this page in Internet Explorer Mode", then click "Manage" Do not click done, Yet.

Here is where you add all the cameras IP addresses click "Add"

As you can see, I have added quite a few cameras. you must include the Http://

If you need to get back to this page to add more cameras you only need to go the "three dots" in the top right, then go to "Settings" then "Default Browser."

Now log into your camera in my case it was http://192.168.0.204 and make sure you don't add the

/notSupported.asp only http://192.168.0.204

Also, don't be tempted to click on the "Open in Microsoft Edge" otherwise you will undo all the work you've done, this message will only come up when you are viewing your cameras anyway.