Browse Prior Art Database

Software Project Sizing/Scheduling Method

IP.com Disclosure Number: IPCOM000110378D
Original Publication Date: 1992-Nov-01
Included in the Prior Art Database: 2005-Mar-25
Document File: 2 page(s) / 72K

Publishing Venue

IBM

Related People

Best-Wiss, LS: AUTHOR [+2]

Abstract

Disclosed is a method that, when used with a spread sheet program such as Lotus 1-2.3*, will automatically calculate software project sizings and schedules.

This text was extracted from an ASCII text file.
This is the abbreviated version, containing approximately 68% of the total text.

Software Project Sizing/Scheduling Method

       Disclosed is a method that, when used with a spread sheet
program such as Lotus 1-2.3*, will automatically calculate software
project sizings and schedules.

      In this methodology each row of the spread sheet will contain
information for a unique piece of work.  The first columns are used
to store information about the piece of work in that row.  The cells
in these columns are called information cells.  A cell is the
intersection of a row and a column.

      Latter columns represent work items.  These columns have
formulas associated with them and will contain time estimates for
completing one of the work items for the piece of work in that row.
Time estimates are created by applying the formulas to the
information cells.  Formulas are created based on work/project
history.  Constants used in the formulas can be made into information
cells for ease in use and modification.

      The final columns in the spread sheet calculate the time needed
to complete a work task.  A single work task may encompass several
work items.

      The unique feature of this method is that the sizing/schedule
logic is summarized in mathematical formulas.  The formulas, based on
key decisions made during the creation of the spread sheet, are
reusable.  When combined in the right sequence, the formulas describe
the work characteristics of a work item.  Human error is greatly
reduced because all calculations are co...