Friday, April 21, 2023

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.



Tuesday, January 3, 2023

Browse Dictionary A-Z

https://www.dictionary.com/list/0




How Long Does Gas Last On My Barbecue

The lifespan of the gas in your barbecue depends on several factors, including the size of the gas tank, how often you use the barbecue, and how well the gas tank is sealed. In general, a standard 20-pound propane tank will last for around 18-20 hours when used on a medium setting on a gas grill. However, if you use the barbecue frequently, the gas will likely run out more quickly.

There are a few things you can do to extend the lifespan of the gas in your barbecue:

Make sure the gas tank is properly sealed: If the gas tank has any leaks, the gas will escape more quickly.

Use the barbecue at a lower setting: The higher the heat, the more gas your barbecue will use.

Close the lid: When you're cooking on a gas grill, try to keep the lid closed as much as possible. This will help to retain heat and reduce the amount of gas used.

Keep the barbecue clean: A dirty barbecue can use more gas, as it has to work harder to maintain the desired temperature.

Store the gas tank properly: When you're not using the barbecue, make sure to store the gas tank in a cool, dry place. This will help to prevent leaks and extend the lifespan of the gas.