Some Spreadsheet Poka-Yoke

Computer Science – Human-Computer Interaction

Scientific paper

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

12 Pages, 8 Colour Figures

Scientific paper

Whilst not all spreadsheet defects are structural in nature, poor layout choices can compromise spreadsheet quality. These defects may be avoided at the development stage by some simple mistake prevention and detection devices. Poka-Yoke (Japanese for Mistake Proofing), which owes its genesis to the Toyota Production System (the standard for manufacturing excellence throughout the world) offers some principles that may be applied to reducing spreadsheet defects. In this paper we examine spreadsheet structure and how it can lead to defects and illustrate some basic spreadsheet Poka-Yokes to reduce them. These include guidelines on how to arrange areas of cells so that whole rows and columns can be inserted anywhere without causing errors, and rules for when to use relative and absolute references with respect to what type of area is being referred to.

No associations

LandOfFree

Say what you really think

Search LandOfFree.com for scientists and scientific papers. Rate them and share your experience with other people.

Rating

Some Spreadsheet Poka-Yoke does not yet have a rating. At this time, there are no reviews or comments for this scientific paper.

If you have personal experience with Some Spreadsheet Poka-Yoke, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Some Spreadsheet Poka-Yoke will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFWR-SCP-O-706533

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.