Spreadsheet Design Question

[Mark O'Brien]

Does anyone know of any resources that they can direct me towards for information on "good" spreadsheet design. i.e. spreadsheets without VBA and with discernable logic to the network of dependent cells. I'm also looking for concepts for spreadsheet validation as part of a spreadsheet design.

For right now, this is just an intellectual exercise, but I'm looking to develop my basic spreadsheet skills.

God, I hope this makes sense and that it doesn't sound too pretentious.

Thanks

 

[XL-Dennis]

Mark,

A good starting point for design questions is, at least for me ,

http://www.mang.canterbury.ac.nz/people/jfraffen/spreadsheets/

and on his commercial site thera are some links too:
http://spreadsheetstyle.com/links/links.htm

Looking forward to see the result of this intellectual work :wink:

Kind regards,
Dennis

 

[Mark O'Brien]

Excellent. I'm just reading the first part of the first link you provided and this seems to be exactly what I'm looking for. (For starters )

The links in the commercial page will also be interesting reading. (they even link to here. - 1 star for content? Pah! The content's what you make it here.)

Thanks

 

[Brian from Maui]

Mark,

Might be too basic for you, but...

http://www.geekgirls.com/spreadsheet02.htm

http://www.efocus.com.au/SSDesign.htm

http://www.siu.edu/~agem318/agem318/other/excel1/

 

[Mark O'Brien]

On 2002-08-26 11:11, Brian from Maui wrote:
Mark,

Might be too basic for you, but...

Don't overestimate my powers.

(less then 1% of my solutions here contain non-VBA answers)

 

[Ekim]

Mark,

In reference to the previous post regarding http://spreadsheetstyle.com/links/links.htm,
go to the section headed "Style: how you should write a spreadsheet".

One of the links in this section is to a publication by PriceWaterhouseCoopers (PWC)
"Spreadsheet Modeling Best Practice", a 100 page PDF file (894KB) or 664KB zipped. The links to this publication seemed to be broken (similarly, links to the publication from other Excel sites are not working). A search on PWC's site was fruitless. However, I have a copy that I could email to you (worth reading).

Regards,

Mike

 

[Mark O'Brien]

Thanks Mike, I've PM'd my email address to you.

 

[Ricardo]

Mike
Check PM
Bye

 

[Ekim]

Further to my previous post. The following is also worth reading:

"What We Know About Spreadsheet Errors."

http://panko.cba.hawaii.edu/ssr/Mypapers/whatknow.htm


Regards,

Mike