Thread: Design

Hello,

I have been working through serveral lessons within a workbook course but
the problem that I am having is when I want to setup my own spreadsheet
outside of the workbook I have problems with doing that. What type of
approach should I take with designing a spreadsheet.

Kelly

I think that would depend on what it would be used for , Inventory,
calculating values such as Cpk, Ppk, Stdev.... Sales report... they all have
their own needs as to how you would design your spreadsheet, so that it suits
the best of your needs.

"Jessica@aol.com" wrote:

> Hello,
>
> I have been working through serveral lessons within a workbook course but
> the problem that I am having is when I want to setup my own spreadsheet
> outside of the workbook I have problems with doing that. What type of
> approach should I take with designing a spreadsheet.
>
> Kelly
>

Ok, so what I want to do is create a spreadsheet that would allow me to keep
track of response for individuals. What approach should I start out with?

Kelly
--


"ufo_pilot" wrote:

> I think that would depend on what it would be used for , Inventory,
> calculating values such as Cpk, Ppk, Stdev.... Sales report... they all have
> their own needs as to how you would design your spreadsheet, so that it suits
> the best of your needs.
>
> "Jessica@aol.com" wrote:
>
> > Hello,
> >
> > I have been working through serveral lessons within a workbook course but
> > the problem that I am having is when I want to setup my own spreadsheet
> > outside of the workbook I have problems with doing that. What type of
> > approach should I take with designing a spreadsheet.
> >
> > Kelly
> >

This may be off course, but, if you are planning to record personal
information you *may* need to register. If you're in the UK, that will be
the Information Commissioner. You'll find more information at
www.informationsommissioner.gov.uk.

Regards.

Bill Ridgeway
Computer Solutions

"Jessica@aol.com" <Jessicaaolcom@discussions.microsoft.com> wrote in message
news:7E4C2C00-B706-4669-BBF1-E57FFC053E0C@microsoft.com...
> Ok, so what I want to do is create a spreadsheet that would allow me to
> keep
> track of response for individuals. What approach should I start out with?
>
> Kelly
> --
>
>
> "ufo_pilot" wrote:
>
>> I think that would depend on what it would be used for , Inventory,
>> calculating values such as Cpk, Ppk, Stdev.... Sales report... they all
>> have
>> their own needs as to how you would design your spreadsheet, so that it
>> suits
>> the best of your needs.
>>
>> "Jessica@aol.com" wrote:
>>
>> > Hello,
>> >
>> > I have been working through serveral lessons within a workbook course
>> > but
>> > the problem that I am having is when I want to setup my own spreadsheet
>> > outside of the workbook I have problems with doing that. What type of
>> > approach should I take with designing a spreadsheet.
>> >
>> > Kelly
>> >

Search in Google for Spreadsheet Design, and you'll find lots of
resources. For example, this pdf file has some good tips:

Spreadsheet Design & Auditing Tips

http://faculty.fuqua.duke.edu/~peckl...tTips20001.pdf

Jessica@aol.com wrote:
> Hello,
>
> I have been working through serveral lessons within a workbook course but
> the problem that I am having is when I want to setup my own spreadsheet
> outside of the workbook I have problems with doing that. What type of
> approach should I take with designing a spreadsheet.
>
> Kelly
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Something that helps me is to start off with pencil and paper and think
about how I would map that data with only a couple of individuals/table
entries. This gives me the rudimentary concept that I can replicate in a
blank worksheet and then expand to the larger matrix. Does that make sense?
Somehow, I can "see" the matrix more easily with just a couple of items.
---------------------------

"Jessica@aol.com" <Jessicaaolcom@discussions.microsoft.com> wrote in message
news:7E4C2C00-B706-4669-BBF1-E57FFC053E0C@microsoft.com...
> Ok, so what I want to do is create a spreadsheet that would allow me to
> keep
> track of response for individuals. What approach should I start out with?
>
> Kelly
> --
>
>
> "ufo_pilot" wrote:
>
>> I think that would depend on what it would be used for , Inventory,
>> calculating values such as Cpk, Ppk, Stdev.... Sales report... they all
>> have
>> their own needs as to how you would design your spreadsheet, so that it
>> suits
>> the best of your needs.
>>
>> "Jessica@aol.com" wrote:
>>
>> > Hello,
>> >
>> > I have been working through serveral lessons within a workbook course
>> > but
>> > the problem that I am having is when I want to setup my own spreadsheet
>> > outside of the workbook I have problems with doing that. What type of
>> > approach should I take with designing a spreadsheet.
>> >
>> > Kelly
>> >

Search in Google for Spreadsheet Design, and you'll find lots of
resources. For example, this pdf file has some good tips:

Spreadsheet Design & Auditing Tips

http://faculty.fuqua.duke.edu/~peckl...tTips20001.pdf

Jessica@aol.com wrote:
> Hello,
>
> I have been working through serveral lessons within a workbook course but
> the problem that I am having is when I want to setup my own spreadsheet
> outside of the workbook I have problems with doing that. What type of
> approach should I take with designing a spreadsheet.
>
> Kelly
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Something that helps me is to start off with pencil and paper and think
about how I would map that data with only a couple of individuals/table
entries. This gives me the rudimentary concept that I can replicate in a
blank worksheet and then expand to the larger matrix. Does that make sense?
Somehow, I can "see" the matrix more easily with just a couple of items.
---------------------------

"Jessica@aol.com" <Jessicaaolcom@discussions.microsoft.com> wrote in message
news:7E4C2C00-B706-4669-BBF1-E57FFC053E0C@microsoft.com...
> Ok, so what I want to do is create a spreadsheet that would allow me to
> keep
> track of response for individuals. What approach should I start out with?
>
> Kelly
> --
>
>
> "ufo_pilot" wrote:
>
>> I think that would depend on what it would be used for , Inventory,
>> calculating values such as Cpk, Ppk, Stdev.... Sales report... they all
>> have
>> their own needs as to how you would design your spreadsheet, so that it
>> suits
>> the best of your needs.
>>
>> "Jessica@aol.com" wrote:
>>
>> > Hello,
>> >
>> > I have been working through serveral lessons within a workbook course
>> > but
>> > the problem that I am having is when I want to setup my own spreadsheet
>> > outside of the workbook I have problems with doing that. What type of
>> > approach should I take with designing a spreadsheet.
>> >
>> > Kelly
>> >