Boomer Nerd

channel image
subscribers

How do you keep your data safe from being clobbered in windows reinstalls. The answer lies in creating a separate data partition when you have just one hard drive to use.

For more information on hard disk structure watch the following videos.

https://www.youtube.com/watch?v=wI0upu9eVcw

https://www.youtube.com/watch?v=gd5vKobmZ3Q

A whole church denomination is closing down worship in all congregations for the next six weeks in Australia

In this video we update data, add Spain as a significantly infected country and add some comparative graphs by which we compare the top four countries outside China with Australia.

We also note that the spread of the infection is beginning to accelerate again. And the percentage of infected is compared in each country.

In this video the spreadsheet is rearranged given that every time the CSV data is updated the number of rows change. So we are now modifying the spreadsheet so that we're not having to do so much in the way of changes everytime we import data.

We also take a closer look at deaths and recovered numbers.

In this video we update the data on the spreadsheet, look at the trends, make a couple of forecasts, Analyse deaths and kick out the mixer cord a third of the way in resulting in complete silence for the rest of the video.

It is hoped that the graphs you see will still be informative.

Note to self. - Keep an eye on OBS and make sure that the recording is still fully functioning.

We begin by starting a new version of the spreadsheet and involve ourselves in a few tricks to make the sheet more efficient.

We then begin recreating some of the graphs and data seen in the source and then extend to individual countries for comparison.

The global infection graph without China is a beautiful thing to look at from a strictly mathematical point of view.

This is where you can go to get the source data to recreate the graphs seen in this video and make some queries of your own if you're interested in auditing the findings of this video.

In this video there are increases calculated and projections made one week in advance

The next video is going to focus on Active infections and the rate of increase of active infections.

https://gisanddata.maps.arcgis.com/apps/opsdashboard/index.html#/bda7594740fd40299423467b48e9ecf6

Tonight we find a nifty little function "SUMIF" that takes a lot of work out of keeping the spreadsheet up to date with incoming data.

We also analyse what is happening to the world when China is removed from the data. The results are enlightening to say the least.

This has raised the question for the next video as to what to expect when China is removed from a number of other graphs.

Many flops, flips and flumbles occur as the data formats change each day by the source. Discoveries have also been made along the way and strategies developed for the bodgey way in which the data is put together.

Interestingly enough discoveries have been made regarding the data and conclusions are drawn which are somewhat at variance to the prevailing narrative.

#LibreOffice,#DataTypes,#DataFormats,#Importing,#CSV,#Surprise,#NewFindings,#Sorting,#CoronaVirus,#COVID19,#COVID-19

In this video we analyse infection rates, recovery rates and updating the data in the spreadsheet.

Of course the updated data has more rows so we have to adjust the spreadsheet to account for these extra rows.

We also have to edit the graphs to include the updated data.

https://gisanddata.maps.arcgis.com/apps/opsdashboard/index.html#/bda7594740fd40299423467b48e9ecf6

In this video we get on to showing a few more tricks such as locking cells in functions and creating simple graphs analysing data in countries of interest.

The original data display gives a great graphic showing how the Corona Virus infection is spreading out over the world.

https://gisanddata.maps.arcgis.com/apps/opsdashboard/index.html#/bda7594740fd40299423467b48e9ecf6

Unfortunately it is unable to drill down effectively into the details to be able to answer the questions that one might have regarding individual and death/recovery rates.

We download the raw data and begin to analyze the implications of the details which we will come to eventually.

In this video we go to a higher level of date conversion from US to Australian formats as LibreOffice doesn't seem to have the smarts to figure it out.

The original data display gives a great graphic showing how the Corona Virus infection is spreading out over the world.

https://gisanddata.maps.arcgis.com/apps/opsdashboard/index.html#/bda7594740fd40299423467b48e9ecf6

Unfortunately it is unable to drill down effectively into the details to be able to answer the questions that one might have regarding individual and death/recovery rates.

We download the raw data and begin to analyze the implications of the details which we will come to eventually.

This particular video is being constantly removed from you-tube for some reason...Astute Dr Elizabeth Celi UNRAVELS Truth about Female violence on Male victims.Something the feminists don't want the people to know about.

SHOW MORE

Created 6 years ago.

12 videos

Category Science & Technology

#Computers #beginners #users #powerusers #superusers Run by a boomer but hopes to help people of all ages change thinking and increase confidence around computers and other devices at all skill levels.

Follow a boomer as he runs through the flips, flops, and flumbles of dealing with the hurdles of operating IT machinery.