software

I am designing a spreadsheet that will be used to monitor incidents
involving youngsters and when contact has been made with their parents /
guardians in relation to incidents. I am having difficulty in organising my
info though, as I don't want the user to scroll along across the spreadsheet
and so want the info to appear on screen without having to scroll. Having
said that, there is loads of info and so, I am wondering the best way to go
about it. I will need the following details:-

- Surname
- Foreame
- Date of Birth
- Telephone
- Address
- Telephone
- School
- Incident date
- Incident location
- Incident details
- Was contact made with regards to incident? (for this, a dropdown menu
listing quot;telephone, letter, visitquot;

Likewise, I want the spreadsheet to autoformat should the same Surname AND
Forename appear twice in the list.

Any suggestions? I played about with the idea of using comments in the
cells, however as it will be used by multiusers, would possibly need to make
the spreadsheet more user-friendly.

Now, having played about with the above, there is just far too many columns
to fit on screen at any one time.

quot;Jumbo's Chippyquot; gt; wrote in message
...
gt;I am designing a spreadsheet that will be used to monitor incidents
gt;involving youngsters and when contact has been made with their parents /
gt;guardians in relation to incidents. I am having difficulty in organising my
gt;info though, as I don't want the user to scroll along across the
gt;spreadsheet and so want the info to appear on screen without having to
gt;scroll. Having said that, there is loads of info and so, I am wondering the
gt;best way to go about it. I will need the following details:-
gt;
gt; - Surname
gt; - Foreame
gt; - Date of Birth
gt; - Telephone
gt; - Address
gt; - Telephone
gt; - School
gt; - Incident date
gt; - Incident location
gt; - Incident details
gt; - Was contact made with regards to incident? (for this, a dropdown menu
gt; listing quot;telephone, letter, visitquot;
gt;
gt; Likewise, I want the spreadsheet to autoformat should the same Surname AND
gt; Forename appear twice in the list.
gt;
gt; Any suggestions? I played about with the idea of using comments in the
gt; cells, however as it will be used by multiusers, would possibly need to
gt; make the spreadsheet more user-friendly.
gt;
gt; Now, having played about with the above, there is just far too many
gt; columns to fit on screen at any one time.
gt;
gt;

You are about to use the wrong software for this project. I love Excel, but
a database like Access is really the way to go. Shall I elaborate on the
reasons?
I also believe that Access is the most suitable software for this project,
however my works IT dept don't support Access and it is not installed on our
IT systems at work so it's a no goquot;Doug Kanterquot; gt; wrote in message
...
gt;
gt; quot;Jumbo's Chippyquot; gt; wrote in message
gt; ...
gt;gt;I am designing a spreadsheet that will be used to monitor incidents
gt;gt;involving youngsters and when contact has been made with their parents /
gt;gt;guardians in relation to incidents. I am having difficulty in organising
gt;gt;my info though, as I don't want the user to scroll along across the
gt;gt;spreadsheet and so want the info to appear on screen without having to
gt;gt;scroll. Having said that, there is loads of info and so, I am wondering
gt;gt;the best way to go about it. I will need the following details:-
gt;gt;
gt;gt; - Surname
gt;gt; - Foreame
gt;gt; - Date of Birth
gt;gt; - Telephone
gt;gt; - Address
gt;gt; - Telephone
gt;gt; - School
gt;gt; - Incident date
gt;gt; - Incident location
gt;gt; - Incident details
gt;gt; - Was contact made with regards to incident? (for this, a dropdown menu
gt;gt; listing quot;telephone, letter, visitquot;
gt;gt;
gt;gt; Likewise, I want the spreadsheet to autoformat should the same Surname
gt;gt; AND Forename appear twice in the list.
gt;gt;
gt;gt; Any suggestions? I played about with the idea of using comments in the
gt;gt; cells, however as it will be used by multiusers, would possibly need to
gt;gt; make the spreadsheet more user-friendly.
gt;gt;
gt;gt; Now, having played about with the above, there is just far too many
gt;gt; columns to fit on screen at any one time.
gt;gt;
gt;gt;
gt;
gt; You are about to use the wrong software for this project. I love Excel,
gt; but a database like Access is really the way to go. Shall I elaborate on
gt; the reasons?
gt;
Questions:

1) What database products *do* they support? I believe it's possible to use
Excel as the quot;front endquot; for certain databases. Sort of like a quot;viewerquot; for
more elaborate data stored elsewhere.

2) By quot;do not supportquot;, do you mean they won't assist you if you run into
problems? Or....???

3) quot;not installedquot; isn't a reason. It can be installed.

4) Could this project be critical to the operation of your enterprise? If
so, you might want to explain to someone that if done with a spreadsheet, it
will become such a burden that people will quickly stop using it. I can
explain further, but answer to the first two questions, above, would help.quot;Jumbo's Chippyquot; gt; wrote in message
...
gt;I also believe that Access is the most suitable software for this project,
gt;however my works IT dept don't support Access and it is not installed on
gt;our IT systems at work so it's a no go
gt;
gt;
gt; quot;Doug Kanterquot; gt; wrote in message
gt; ...
gt;gt;
gt;gt; quot;Jumbo's Chippyquot; gt; wrote in message
gt;gt; ...
gt;gt;gt;I am designing a spreadsheet that will be used to monitor incidents
gt;gt;gt;involving youngsters and when contact has been made with their parents /
gt;gt;gt;guardians in relation to incidents. I am having difficulty in organising
gt;gt;gt;my info though, as I don't want the user to scroll along across the
gt;gt;gt;spreadsheet and so want the info to appear on screen without having to
gt;gt;gt;scroll. Having said that, there is loads of info and so, I am wondering
gt;gt;gt;the best way to go about it. I will need the following details:-
gt;gt;gt;
gt;gt;gt; - Surname
gt;gt;gt; - Foreame
gt;gt;gt; - Date of Birth
gt;gt;gt; - Telephone
gt;gt;gt; - Address
gt;gt;gt; - Telephone
gt;gt;gt; - School
gt;gt;gt; - Incident date
gt;gt;gt; - Incident location
gt;gt;gt; - Incident details
gt;gt;gt; - Was contact made with regards to incident? (for this, a dropdown menu
gt;gt;gt; listing quot;telephone, letter, visitquot;
gt;gt;gt;
gt;gt;gt; Likewise, I want the spreadsheet to autoformat should the same Surname
gt;gt;gt; AND Forename appear twice in the list.
gt;gt;gt;
gt;gt;gt; Any suggestions? I played about with the idea of using comments in the
gt;gt;gt; cells, however as it will be used by multiusers, would possibly need to
gt;gt;gt; make the spreadsheet more user-friendly.
gt;gt;gt;
gt;gt;gt; Now, having played about with the above, there is just far too many
gt;gt;gt; columns to fit on screen at any one time.
gt;gt;gt;
gt;gt;gt;
gt;gt;
gt;gt; You are about to use the wrong software for this project. I love Excel,
gt;gt; but a database like Access is really the way to go. Shall I elaborate on
gt;gt; the reasons?
gt;gt;
gt;
gt;
By the way, I'm not trying to give you a hard time. I'm attempting to give
you the benefit of 15 years' worth of data management experience, so you and
your organisation don't march yourselves off a cliff. I've seen this happen
too many times, in situations just like yours.
Doug,

I am actually a police officer and so, my police force won't pay for the
licence costs etc... Likewise, in the United Kingdom, there is a hell of a
lot of red-tape in relation to the use of databases in police forces and the
info that they contain. So, I am trying to sneak around this and hopefully
use a spreadsheet

quot;Doug Kanterquot; gt; wrote in message
...
gt; By the way, I'm not trying to give you a hard time. I'm attempting to give
gt; you the benefit of 15 years' worth of data management experience, so you
gt; and your organisation don't march yourselves off a cliff. I've seen this
gt; happen too many times, in situations just like yours.
gt;
Ossifer....err....officer:
I understand the license costs. The bit about databases is probably an
overgeneralization, in a legal sense. Whether you stored names in Excel,
Word or Access, the same privacy issues would apply. I doubt that a court of
law would care about the specific software.quot;Jumbo's Chippyquot; gt; wrote in message
...
gt; Doug,
gt;
gt; I am actually a police officer and so, my police force won't pay for the
gt; licence costs etc... Likewise, in the United Kingdom, there is a hell of a
gt; lot of red-tape in relation to the use of databases in police forces and
gt; the info that they contain. So, I am trying to sneak around this and
gt; hopefully use a spreadsheet
gt;
gt; quot;Doug Kanterquot; gt; wrote in message
gt; ...
gt;gt; By the way, I'm not trying to give you a hard time. I'm attempting to
gt;gt; give you the benefit of 15 years' worth of data management experience, so
gt;gt; you and your organisation don't march yourselves off a cliff. I've seen
gt;gt; this happen too many times, in situations just like yours.
gt;gt;
gt;
gt;
quot;Jumbo's Chippyquot; gt; wrote in message
...
gt;I am designing a spreadsheet that will be used to monitor incidents
gt;involving youngsters and when contact has been made with their parents /
gt;guardians in relation to incidents. I am having difficulty in organising my
gt;info though, as I don't want the user to scroll along across the
gt;spreadsheet and so want the info to appear on screen without having to
gt;scroll. Having said that, there is loads of info and so, I am wondering the
gt;best way to go about it. I will need the following details:-
gt;
gt; - Surname
gt; - Foreame
gt; - Date of Birth
gt; - Telephone
gt; - Address
gt; - Telephone
gt; - School
gt; - Incident date
gt; - Incident location
gt; - Incident details
gt; - Was contact made with regards to incident? (for this, a dropdown menu
gt; listing quot;telephone, letter, visitquot;
gt;
gt; Likewise, I want the spreadsheet to autoformat should the same Surname AND
gt; Forename appear twice in the list.

I understand the issue, but I don't understand what you mean by quot;autoformatquot;
if their are duplicates. What do you visualize happening?

This is a situation which database software handles with grace. (Sorry -
couldn't help saying it again!)
gt; Any suggestions? I played about with the idea of using comments in the
gt; cells, however as it will be used by multiusers, would possibly need to
gt; make the spreadsheet more user-friendly.

What's so UNfriendly about comments?gt; Now, having played about with the above, there is just far too many
gt; columns to fit on screen at any one time.

In Excel, click on Help. After it loads, click on the Answer Wizard tab. In
the search box, type the words quot;window splitquot; without the quotation marks,
then click Search. On the right, you should see these results:
View different parts of a worksheet at the same time
What do you want to do?
View two parts of a sheet at the same time

Keep row and column labels visible as you scroll

The first choice may partially solve your problem, although with the amount
of data you're trying to store, nothing will help completely. What you could
do is design more than one type of split window, program them into macros,
and attach the macros to buttons at the top of the sheet. Then, users could
just click the buttons to see different views of the data. And, with a sheet
you already have, try clicking View, Zoom, and playing with the numbers to
bring more cells into the screen area.