Nice people thread part 3- Nice as pie

tomterm8

Nope... no idea of how to do that excel thingie... I'm a really basic user as far as Excel is concerned. I've never really had to use it. I could have done it ten years ago, but they move every thing about in every version.

I think closing down libraries is one of the dumbest moves possible. It is really beyond stupid. If you're on benefits, how the heck do you do CV's and go on jobsite if you don't have a computer available? How do you learn new skills without being able to get books from a library... closing libraries is madness... you are guaranteeing people will stay on benefits for longer.

LydiaJ

Thanks everyone. At least that reassures me I'm not missing something obvious. I've designed a work-around, and it's doing what I want it to do, but only by creating irritating extra columns that are twice as long as everything else, so every time I enter new data I have to scroll to some totally different part of the sheet to drag a couple of cells down a couple of rows. Never mind. It'll do.

lostinrates

PasturesNew wrote: »

I don't want to be remote, I was looking at Dorset, then I signed up for these evening classes so have to hang around for them to finish.... leaving me 2 months, so not long enough to move out now, then again, or I'd be stuck in a 6 month AST.

Also, Dorset was coming up pricier than here by £100/month or so.

I need to be able to get back/down where I am fairly quickly for the next 5-10 years, but I want to be close to a main railway line and the seaside and shops and jobs and learning.

And I can't share for lots of reasons, not least of which is that I am an all night prowler, often to be found outside at 3am. And I have to have things "just so". And I can't settle at all, nor sleep, when anybody else is about whatsoever.

Does it have to be the sea? I'm confident, very confident you'd find something in my area for cheaper....perhaps with lake, river or canal view? Near enough the A303 for a trip west....employment oppertunities (with commute, to bath, bristol, swindon, salisbury plus the smaller towns....)

GDB2222

misskool wrote: »

Please don't quote this, i will have to remove it....

Hi Miskool. Spreadsheets is what I do a lot of, and the example info you gave can be dealt with trivially easily in Excel.

What you do is create a master spreadsheet that collates the information you need from the other spreadsheets. You use a function called vlookup.

Syntax
VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)


lookup_value -- this would be the patient id

table_array -- this would be the whole area occupied by data on the target spreadsheet. The best way to do that is to have the target spreadsheet open and point to the area you want.

col_index_num -- this would be the column number within that area that contains the particular data itemI'm not sure how clear that is, but please ask.

GDB2222

Or are you having to update data in the 4 different spreadsheets? Perhaps you could explain a bit more about what you are doing?

GDB2222

LydiaJ wrote: »

No, I want a real x-axis with spacing according to irregular dates, so that 3/2/11 is much closer to 1/2/11 than to 1/3/11.

Make two columns of data that look like this:

01/08/2011 20000
20/08/2011 22000
08/09/2011 24000
27/09/2011 26000
02/10/2011 28000
04/12/2011 30000
23/06/2012 32000
Highlight that data, click on the chart wizard, click 'line' in the chart type box and click the finish button. Job done.

LydiaJ

GDB2222 wrote: »

Make two columns of data that look like this:

01/08/2011 20000
20/08/2011 22000
08/09/2011 24000
27/09/2011 26000
02/10/2011 28000
04/12/2011 30000
23/06/2012 32000
Highlight that data, click on the chart wizard, click 'line' in the chart type box and click the finish button. Job done.

Thanks, GDB, but that makes sloping lines. I want flat ones and vertical steps on the dates where the changes occur.

I've now realised that probably the easiest way to do it is to incorporate these numbers into a larger spreadsheet with lots more data, and stuff happening almost every day. The money balance I want to graph will then have lots and lots of points to plot where it's the same, and then the steps will be nearly vertical, which is good enough.

misskool

GDB2222 wrote: »

Or are you having to update data in the 4 different spreadsheets? Perhaps you could explain a bit more about what you are doing?

There are 4 spreadsheets currently.
Spreadsheet 1 is patient recruitment, with all their details.
Spreadsheet 2 is frozen samples, with a patient number with the number of different samples in different boxes. I'm collating what has been sent now. Each patient has multiple samples at multiple timepoints with different numbers of each kind of sample, hence why they aren't in spreadsheet 1.
Spreadsheet 3 is histo samples, stored in a series of slides/block boxes. Again, each patient may have samples at different timepoints.
Spreadsheet 4 is an anoymiser number for the govt, we can't keep the id in the same space as any identifying information.

Does that make sense?

PasturesNew

lostinrates wrote: »

Does it have to be the sea? I'm confident, very confident you'd find something in my area for cheaper....perhaps with lake, river or canal view? Near enough the A303 for a trip west....employment oppertunities (with commute, to bath, bristol, swindon, salisbury plus the smaller towns....)

Seaside, walkable, essential for the master plan.

GDB2222

misskool wrote: »

There are 4 spreadsheets currently.
Spreadsheet 1 is patient recruitment, with all their details.
Spreadsheet 2 is frozen samples, with a patient number with the number of different samples in different boxes. I'm collating what has been sent now. Each patient has multiple samples at multiple timepoints with different numbers of each kind of sample, hence why they aren't in spreadsheet 1.
Spreadsheet 3 is histo samples, stored in a series of slides/block boxes. Again, each patient may have samples at different timepoints.
Spreadsheet 4 is an anoymiser number for the govt, we can't keep the id in the same space as any identifying information.

Does that make sense?

You are describing the data, not what you need to do to it. Are you trying to update it, or extract information from the four spreadsheets? Are you doing this for one patient at a time or in bulk?