Meet the Other Phone. Only the apps you allow.

Meet the Other Phone.
Only the apps you allow.

Buy now

Please or to access all these features

Chat

Join the discussion and chat with other Mumsnetters about everyday life, relationships and parenting.

Excel question

22 replies

chomalungma · 05/10/2020 17:18

A friend of mine is dealing with lots of data. Maybe 1000s of records. Possibly going up to millions.

I want to be able to analyse it and import and export it to other users.

Should I use columns or rows?
Should I use Excel.

OP posts:
MarmiteCrumpet25 · 05/10/2020 17:19

Only if you are NhS test, track and trace!

PastMyBestBeforeDate · 05/10/2020 17:19

Definitely Excel. A database would only confuse the issue.

thirstyformore · 05/10/2020 17:21

Excel is perfect! Preferably an older version.

chomalungma · 05/10/2020 17:24

@thirstyformore

Excel is perfect! Preferably an older version.
With the paperclip Grin
OP posts:
ASchuylerSister · 05/10/2020 17:26

Make sure you’re using dial up and I wouldn’t bother to password protect it either.

PersonManWomanCameraTV · 05/10/2020 17:26

Just let your friend (Matt Hancock) know that if he leaves it open on his machine it makes all the other ones 'read only' until he remembers to close it down. But otherwise it's a foolproof plan.

thatsyourbusiness · 05/10/2020 17:27

I’ve heard Microsoft Paint is good for storing life or death information on if that’s any help

Smallsteps88 · 05/10/2020 17:32

just write it on the back of a fag packet. Safe as houses Grin

pastabest · 05/10/2020 17:33

A local authority I worked for had a ridiculous excel spreadsheet they paid several million for. It broke as soon as real people with real data had to start using it across several sites.

The staff in the ground were incredulous anyone ever gave it the green light.

So no, completely inappropriate.

On a completely unrelated subject, anyone know how the NHS track and trace data was being stored? Do the opposite of that.

chomalungma · 05/10/2020 18:30

In completely unrelated Excel news....

The BBC has confirmed the missing Covid-19 test data was caused by the ill-thought-out use of Microsoft's Excel software. Furthermore, Public Health England (PHE) was to blame, rather than a third-party contractor.

The issue was caused by the way the agency brought together logs produced by the commercial firms paid to carry out swab tests for the virus.

They filed their results in the form of text-based lists, without issue.

PHE had set up an automatic process to pull this data together into Excel templates so that it could then be uploaded to a central system and made available to the NHS Test and Trace team as well as other government computer dashboards.

The problem is that the PHE developers picked an old file format to do this - known as XLS.

As a consequence, each template could handle only about 65,000 rows of data rather than the one million-plus rows that Excel is actually capable of.

And since each test result created several rows of data, in practice it meant that each template was limited to about 1,400 cases. When that total was reached, further cases were simply left off.

Until last week, there were not enough test results being generated by private labs for this to have been a problem - PHE is confident that test results were not previously missed because of this issue.

And in its defence, the agency would note that it caught most of the cases within a day or two of the records slipping through its net.

To handle the problem, PHE is now breaking down the data into smaller batches to create a larger number of Excel templates in order to make sure none hit their cap.

OP posts:
coldgraybrix · 05/10/2020 18:34

Whoops. It would be funny if it wasn't so serious.

HelpIHaveNothingToWear · 05/10/2020 18:34

@MarmiteCrumpet25😂😂😂😂😂😂😂😂😂😂

beela · 05/10/2020 18:38

I once knew a data analyst who used a calculator to add up their excel columns and then typed the answer into their spreadsheet.

I imagine they are working for phe now.

StCharlotte · 05/10/2020 18:45

They should have hired me. I used to manage a massive company's pension records on Excel (1000s of staff). It was a work of art.

I'm back to working with Word predominantly which works for my job now. I miss Excel.

PastMyBestBeforeDate · 05/10/2020 19:44

xls? Um why would you do that? Are they dealing with companies using Office 2000?

InTheLongGrass · 06/10/2020 07:44

It didnt take long for the memes to arrive, but k think you were all there first!

Excel question
chomalungma · 06/10/2020 07:53

@PastMyBestBeforeDate

xls? Um why would you do that? Are they dealing with companies using Office 2000?
Apparently they are looking at upgrading the system - if only there was a simple way of updating from Excel 2000 to Excel 2016.

To get more rows.

Then looking at upgrading to a database

OP posts:
ExerciseBeaver · 06/10/2020 08:00

Oh my god the paperclip!

mumwon · 06/10/2020 08:25

(vague understanding of this - v vague!)
Is this possibly caused by NHS not having enough money to update software? Or because the choice of software was decided at Executive/financial level by people who don't really comprehend the quality & usability of software choice & again comparative cost? Or because the users didn't understand what would happen when they did this?

Ghostlyglow · 06/10/2020 08:35

You should use Lotus 123

chomalungma · 06/10/2020 08:40

I wonder how many places still use older versions of Office. Still if they were worried about money then they could have used Open Office.

OP posts:
PastMyBestBeforeDate · 06/10/2020 08:58

mumwon no it's not the NHS at all. It's PHE and they've had money thrown at the track and trace development.

chomalungma I have a copy of Access 97 around here somewhere I could let them have if they want to go crazy.

New posts on this thread. Refresh page
Swipe left for the next trending thread