METHOD AND APPARATUS FOR TABULAR PROCESS CONTROL

• US 20060253205A1
• Filed: 05/09/2005
• Published: 11/09/2006
• Est. Priority Date: 05/09/2005
• Status: Abandoned Application

• Current Assignee: Michael Gardiner
• Original Assignee: Michael Gardiner
• Inventors: Gardiner, Michael
• Application Number:
  US10/908,369
• Publication Number:
  US 20060253205A1
• Time in Patent Office: Days
• US Class Current: 700/19
• CPC Class Codes: G05B 15/02 electric
• CPC Class Codes: G06F 40/40 Processing or translation of natural language natural language analysis G06F40/20; semantic analysis G06F40/30

Abstract

The invention discloses methods and apparatus based on tabular concepts which greatly simplify the configuration, maintenance and run-time operations of a broad range of electronic equipment control systems, including, but not limited to: (a) industrial controls, (b) supervisory control and data acquisition, such as heating, ventilation and air conditioning, and (c) home automation, including systems or stand-alone equipment, such as video recording devices. The tabular concepts of the invention are applied in three primary stages, namely (i) data input or configuration, including automated data population, (ii) generic operating rule application to tables of rules data variables, and (iii) English (or other) language translations of the current rule sets, for ease of verification. By each of these methods alone and through combination of all of these methods, the current invention makes the configuration and operation of automated equipment easily accessible to persons who do not have technical skills in either process control, automation, or software programming. Development of software for automatic control of equipment is also greatly simplified by these inventions.

Claims

1. An automated control system, comprising:

an electronic device having a microcontroller, and having set-up and run-time software and a plurality of table data blocks;

at least one of an input device and an output device each coupled to said electronic device;

wherein said set-up and run-time software configures said table data blocks including an input/output point block, an HMI data block, and a rules variable block and wherein said set-up and run-time software and said table data blocks define an operating rule which specifies what is to be done in response to one of a reading of said input device and a status of said system.

2. A system according to claim 1, wherein said set-up software configures input/output points, input /output point data values, and input/output point names to correspond to said input and output devices.

3. A system according to claim 2, wherein said rules variable block contains one or more records, and each record uniquely defines said operating rule, and wherein a variable type includes one of a boolean logic operator, comparison operator and a special logic operator.

4. A system according to claim 3, wherein said special logic operator includes:

(a) a deadband operator, which allows a logical state to be maintained at input values other than an input value which triggered the state initially,

(b) a delay operator, which allows a logical state to be applied at a later time than the time at which the logical state was first triggered,

(c) proportional integral derivative (PID) control,

(d) fail on/off in the form of a state triggered by a failure,

(e) scan time in the form of frequency of device polling,

(f) flags in the form of true or false settings,

(g) boundary filters in the form of limitations on data changes,

(h) smoothing filters in the form of smoothing groups of data,

(i) scaling in the form of fitting a range to a different scale,

(j) variables in the form of storage locations,

(k) over-ride control in the form of differing control at different ranges,

(l) cascade control in the form of use of an output as an input to an operating rule,

(m) ratio control in the form of maintaining fixed ratios among variables, when one of said variables changes value,

(n) feedback control in the form of monitoring of an output and varying inputs to reach a desired output value,

(o) feed-forward control in the form of variation of inputs to reach a desired output state,

(p) virtual input/output points in the form of system states or values not associated with a physical device,

(q) schedules in the form of one of time and date based controls.

5. A system according to claim 3, wherein said set-up software reads a selected record of said rules variable block and data in said record is used to populate a generic rule, thereby defining a unique rule for said record, based upon one of a variable type and a location within the record.

6. A system according to claim 5, wherein said set-up software reads said record from said rules variable block and provides one of an English language translation and a non-English language translation for said unique rule, by applying corresponding grammar and syntax rules and using a selected combination of pre-defined text strings, said input/output point names and said input/output point data values.

7. A system according to claim 6, wherein said language translation represents a sentence that is grammatically correct and has correct syntax for a chosen language and wherein said sentence includes at least one condition, express or implied.

8. A system according to claim 7, wherein said sentence is modified, while maintaining an implicit message that is unambiguous, and modifications are selected from the group consisting of:

(a) omission of a word,

(b) replacement of a word by an abbreviation,

(c) reordering of words in said sentence, and

(d) reordering of said word abbreviations in said sentence.

20. A system according to claim 19, wherein said special logic operator includes:

(a) a deadband operator, which allows a logical state to be maintained at input values other than an input value which triggered the state initially,

(b) a delay operator, which allows a logical state to be applied at a later time than the time at which the logical state was first triggered,

(c) proportional integral derivative (PID) control,

(d) fail on/off in the form of a state triggered by a failure,

(e) scan time in the form of frequency of device polling,

(f) flags in the form of true or false settings,

(g) boundary filters in the form of limitations on data changes,

(h) smoothing filters in the form of smoothing groups of data,

(i) scaling in the form of fitting a range to a different scale,

(j) variables in the form of storage locations,

(k) over-ride control in the form of differing control at different ranges,

(l) cascade control in the form of use of an output as an input to an operating rule,

(m) ratio control in the form of maintaining fixed ratios among variables, when one of said variables changes value,

(n) feedback control in the form of monitoring of an output and varying inputs to reach a desired output value,

(o) feed-forward control in the form of variation of inputs to reach a desired output state,

(p) virtual input/output points in the form of system states or values not associated with a physical device,

(q) schedules in the form of one of time and date based controls.

9. An automated control system, comprising:

(a) a host computer having set-up software, a minimum of one data table coupled to said set-up software and configured thereby, and a run-time application coupled to said data table;

(b) a communications module coupled to said host computer and said set-up software and said run-time application;

(c) at least one of an input device, coupled to said communications module;

wherein said set-up software configures a plurality of table data blocks including an input/output point block and a storage data block, said table data blocks being configured by entering input point names and storage parameters and wherein said host computer and said run-time application enable monitoring and storage of data values of said input devices.

10. An automated control system, comprising:

(a) a host computer having set-up software, a minimum of one data table coupled to said set-up software and configured thereby, and a run-time application coupled to said data table;

(b) a communications module coupled to said host computer and said set-up software and said run-time application;

(c) at least one of an output device, coupled to said communications module;

wherein said set-up software configures a plurality of table data blocks including an input/output point block and a rules variable block, said table data blocks being configured by entering output point names and timing rules variables and wherein said host computer and said run-time application enable time based operations to control output states of said output device(s).

11. An automated control system, comprising:

(a) a host computer having set-up software, a minimum of one data table coupled to said set-up software and configured thereby, and a run-time application coupled to said data table;

(b) a communications module coupled to said host computer and said set-up software and said run-time application;

(c) at least one of an input device and an output device, coupled to said communications module;

wherein said set-up software configures a plurality of table data blocks including an input/output point block and an HMI data block, said table data blocks being configured by entering output point names and HMI data parameters and wherein said host computer and said run-time application enable run-time monitoring of input and output values of said input and output device(s).

12. An automated control system, comprising:

(a) a host computer having set-up software, a minimum of one data table coupled to said set-up software and configured thereby, and a run-time application coupled to said data table;

(b) at least one of an input and an output device, coupled to an external input/output controller;

wherein said set-up software configures a plurality of table data blocks including an input/output point block and an HMI data block, said table data blocks being configured by entering input point names and HMI parameters and wherein said host computer and said run-time application are couplable to said external input/output controller, thereby enabling monitoring and control of said input and output device(s).

13. An automated control system, comprising:

(a) a host computer having set-up software, a minimum of one data table coupled to said set-up software and configured thereby, and a run-time application coupled to said data table;

(b) a communications module coupled to said run-time application and to at least one input/output module, said communications module operative to provide connectivity between said run-time application and said input/output module;

(c) at least one of an input and an output device coupled to said input/output modules, said input and output device(s) corresponding to input/output points in said system;

wherein said set-up and run-time software configures a plurality of table data blocks including an input/output point block, an HMI data block, and a rules variable block, said table data blocks being configured by entering input and output point names, and data values associated with said input and output point names, to uniquely control said corresponding output devices in response to readings of said corresponding input devices.

14. A system according to claim 13, wherein making a change in an entry in one of said table data blocks, upon one of manual and automated refresh or reload, results in the same change being made in selected fields in all other table data blocks.

15. A system according to claim 13, including displaying entry parameters for each entry, thereby creating data entry constraints associated with said entry.

16. A system according to claim 15, wherein said data entry constraints are imposed by a plurality of data entry means selected from the group consisting of:

(a) forms with entry fields, said entry fields including blocks of text,

(b) tables with entry fields, said entry fields being rows and columns,

(c) drop down menus with pre-defined data,

(d) drop down menus with implementation specific data,

(e) radio buttons, check boxes, data selection by group,

(f) a pointing device, selected from the group consisting of a touchscreen, pen, mouse, trackball, joystick, cursor keypad, special keypad, and an optical location sensing device,

(g) drag and drop actions,

(h) slider bars,

(i) dials,

(j) gauges, and

(k) knobs.

17. A system according to claim 16, wherein making a change in an entry in one of said table data blocks, upon one of manual and automated refresh or reload, makes the same change in selected fields in all other table data blocks.

18. A system according to claim 13, wherein said rules variable block is structured to correspond directly to the implementation of a generic operating rule, and wherein said generic operating rule specifies action to be taken in response to a reading of said input devices.

19. A system according to claim 18, wherein said rules variable block contains records of variables, each record of which is imported to uniquely define an operating rule, and wherein a variable type includes one of a boolean logic operator, a comparison operator and a special logic operator.

21. A system according to claim 19, wherein one of said set-up software and said run-time application reads through said rules variable block, imports variables from a selected record and then populates a generic operating rule, thereby defining a unique rule for a current record, based upon one of a variable type and a location within the record.

22. A system according to claim 21, wherein said run-time software applies processing on a cycle by cycle basis and within each cycle records in said rules variable data block are read sequentially and said unique rule(s) are applied according to current input values of the associated respective records and in response to said current input values create new output values for said records in a current processing cycle.

23. A system according to claim 22, wherein said set-up software reads selected records of said rules variable data block, and provides one of an English and a non-English language translation for said unique rules associated with the selected records, by applying corresponding grammar and syntax rules and using a selected combination of textual data including pre-defined text strings, said input/output point names and said input/output point data values.

24. A system according to claim 23, wherein said language translation represents a sentence that is grammatically correct and has correct syntax for a chosen language and wherein said sentence includes at least one condition, express or implied.

25. A system according to claim 24, wherein said sentence is modified, while maintaining an implicit message that is unambiguous, and modifications are selected from the group consisting of:

(a) omission of a word,

(b) replacement of a word by an abbreviation,

(c) reordering of words in said sentence and

(d) reordering of said word abbreviations in said sentence.

26. A system according to claim 13, wherein said rules variable block is structured to correspond directly to implementation of a plurality of generic operating rules, wherein said plurality of generic operating rules specify action to be taken in response to a reading of said input devices.

27. A system according to claim 26, wherein said set-up software reads selected records of said rules variable data block, and provides one of an English and a non-English language translation for unique rules associated with the selected records, by applying corresponding grammar and syntax rules and using a selected combination of textual data including pre-defined text strings, said input/output point names and said input/output point data values and wherein said language translation is one of appropriate nestings and appropriate concatenations of said grammar and syntax rules and said textual data.

28. A system according to claim 27, wherein said language translations represent a sentence that is grammatically correct and has correct syntax for a chosen language and wherein said sentence includes at least one condition, express or implied.

29. A system according to claim 28, wherein said sentence is modified, while maintaining an implicit message that is unambiguous, and modifications are selected from the group consisting of:

(a) omission of a word,

(b) replacement of a word by an abbreviation,

(c) reordering of words in said sentence and

(d) reordering of said word abbreviations in said sentence.

30. An automated control system, comprising:

(e) a host computer having set-up software, a minimum of one data table coupled to said set-up software and configured thereby, and a run-time application coupled to said data table;

(f) a communications module coupled to said run-time application and to at least one input/output module, said communications module operative to provide connectivity between said run-time application and said input/output module;

(g) at least one of an input and an output device coupled to said input/output modules, said input and output device(s) corresponding to input/output points in said system;

wherein said set-up and run-time software configures a plurality of table data blocks including an input/output point block, an HMI data block, and a rules variable block, said table data blocks being configured by entering input and output point names, and data values associated with said input and output point names, to uniquely control said corresponding output devices in response to readings of said corresponding input devices and

wherein said run-time application is separated into a plurality of run-time software components including an input/output server coupled to said communications module and coupled to an internet communications link, and wherein said set-up software configures a plurality of tables dedicated to said table data blocks, and also configures a plurality of additional tables, each additional table selected from the group consisting of;

(a) a table of allowed input/output module types,

(b) a table of input/output modules available in one instance of the system implementation,

(c) an image data table,

(d) a table of pre-defined text strings,

(e) an alarm data table,

(f) an alarm action data table,

(g) a scheduling table,

(h) an historical data table,

(i) a reporting data table,

(j) an alarm log data table,

(k) an HMI backdrop table,

(l) a map definition table, and

(m) a map co-ordinate table.

31. A system according to claim 30, wherein making a change in an entry in one of said tables, upon one of manual and automated refresh or reload, results in the same change being made in selected fields in all other tables.

32. A system according to claim 30, wherein for each input point and associated output point there are predetermined parameters displayed for specification and data entry is constrained to conform to required conditions through association with said input points and said output points.

33. A system according to claim 30, wherein making a change in an entry in one of said tables, upon one of manual and automated refresh or reload, makes the same change in selected fields in all other tables.

34. A method of automated control of equipment, comprising:

(a) providing an electronic device having a microcontroller, and having set-up and run-time software and a plurality of table data blocks;

(b) providing at least one of at least one of an input device and an output device each coupled to said electronic device;

(c) configuring said table data blocks including an input/output point block, an HMI data block, and a rules variable block, said table data blocks being programmable by defining an operating rule which specifies an action in response to one of a reading of said input device and a status of said input/output devices.

35. A method according to claim 34, wherein said configuring step includes configuring input/output points, input/output point data values, and input/output point names to correspond to said input and output device(s).

36. A method according to claim 35, including populating said rules variable block with one or more records of data variables, each record uniquely defining said operating rule, and wherein said variable types includes one of a of boolean logic operator, comparison operator and a special logic operator.

37. A method according to claim 36, wherein said special logic operator includes:

(a) a deadband operator, which allows a logical state to be maintained at input values other than an input value which triggered the state initially,

(b) a delay operator, which allows a logical state to be applied at a later time than the time at which the logical state was first triggered,

(c) proportional integral derivative (PID) control,

(d) fail on/off in the form of a state triggered by a failure,

(e) scan time in the form of frequency of device polling,

(f) flags in the form of true or false settings,

(g) boundary filters in the form of limitations on data changes,

(h) smoothing filters in the form of smoothing groups of data,

(i) scaling in the form of fitting a range to a different scale,

(j) variables in the form of storage locations,

(k) over-ride control in the form of differing control at different ranges,

(l) cascade control in the form of use of an output as an input to an operating rule,

(m) ratio control in the form of maintaining fixed ratios among variables, when one of said variables changes value,

(n) feedback control in the form of monitoring of an output and varying inputs to r each a desired output value,

(o) feed-forward control in the form of variation of inputs to reach a desired output state,

(p) virtual input/output points in the form of system states or values not associated with a physical device,

(q) schedules in the form of one of time and date based controls.

38. A method according to claim 36, including reading a selected record of said rules variable block and populating a generic rule with data from said record, thereby defining a unique rule for said record, based upon one of a variable type and a location within the record.

39. A method according to claim 38, including reading said record from said rules variable block and providing one of an English language translation and a non-English language translation for said unique rule, by applying corresponding grammar and syntax rules and using a selected combination of pre-defined text strings, said input/output point names and said input/output point data values.

40. A method according to claim 39, wherein said language translation represents a sentence that is grammatically correct and has correct syntax for a chosen language and

wherein said sentence includes at least one condition, express or implied.

41. A method according to claim 40, wherein said sentence is modified, while maintaining an implicit message that is unambiguous, and modifications are selected from the group consisting of:

(a) omission of a word,

(b) replacement of a word by an abbreviation,

(c) reordering of words in said sentence and

(d) reordering of said word abbreviations in said sentence.

42. A method of automated control of equipment, comprising:

(a) providing a host computer having set-up software, a minimum of one data table coupled to said set-up software and configured thereby, and a run-time application coupled to said data table;

(b) providing a communications module coupled to said host computer and said set-up software and said run-time application;

(c) providing at least one of an input device, coupled to said communications module;

(d) configuring a plurality of table data blocks including an input/output point block and a storage data block, said table data blocks being configured by entering input point names and storage parameters; and

(e) enabling monitoring of data values of said input devices.

43. A method of automated control of equipment, comprising:

(a) providing a host computer having set-up software, a minimum of one data table coupled to said set-up software and configured thereby, and a run-time application coupled to said data table;

(b) providing a communications module coupled to said host computer and said set-up software and said run-time application;

(c) providing at least one of an output device, coupled to said communications module;

(d) configuring a plurality of table data blocks including an input/output point block and a rules variable block, said table data blocks being configured by entering output point names and timing rules variables; and

(e) enabling time based operations to control output states of said output device(s).

44. A method of automated control of equipment, comprising:

(a) providing a host computer having set-up software, a minimum of one data table coupled to said set-up software and configured thereby, and a run-time application coupled to said data table;

(b) providing a communications module coupled to said host computer and said set-up software and said run-time software;

(c) providing at least one of an input device and an output device, coupled to said communications module;

(d) configuring a plurality of table data blocks including an input/output point block and an HMI data block, said table data blocks being configured by entering input/output point names and HMI parameters;

(e) enabling monitoring of said input device(s) and said output device(s).

45. A method of automated control of equipment, comprising:

(a) providing having a host computer having set-up software, a minimum of one data table coupled to said set-up software and configured thereby, and a run-time application coupled to said data table and said run-time application being couplable to an external input/output controller;

(b) providing having at least one of an input and an output device, couplable to said external input/output controller;

(c) configuring a plurality of table data blocks including an input/output point block and an HMI data block, said table data blocks being configured by entering input/output point names and HMI parameters; and

(d) enabling monitoring and control of said input and output device(s).

46. A method of automated control of equipment, comprising:

(a) providing a host computer having set-up software, a minimum of one data table coupled to said set-up software and configured thereby, and a run-time application coupled to said data table;

(b) providing a communications module coupled to said run-time application and to at least one input/output module, said communications module operative to provide connectivity between said run-time application and said input/output module;

(c) providing at least one of an input and an output device coupled to said input/output modules, said input and output devices corresponding to input/output points in said system; and

(d) configuring a plurality of table data blocks including an input/output point block, an HMI data block, and a rules variable block, said table data blocks being configured by entering input and output point names, and data values associated with said input and output point names, to uniquely control said corresponding output devices based on readings of corresponding ones of said input devices.

47. A method according to claim 46, wherein changing an entry in one of said table data blocks, upon one of manual and automated refresh or reload, makes the same change in selected fields in all other table data blocks.

48. A method according to claim 47, including displaying entry parameters for specification for each entry, thereby creating data entry constraints associated with said entry.

49. A method according to claim 48, wherein said data entry constraints are imposed by a plurality of data entry means selected from the group consisting of:

(a) forms with entry fields, said entry fields including blocks of text,

(b) tables with entry fields, said entry fields being rows and columns,

(c) drop down menus with pre-defined data,

(d) drop down menus with implementation specific data,

(e) radio buttons, check boxes, data selection by group,

(f) a pointing device, selected from the group consisting of a touchscreen, pen, mouse, trackball, joystick, cursor keypad, special keypad, or a camera location sensing device,

(g) drag and drop actions

(h) slider bars,

(i) dials,

(j) gauges, and

(k) knobs.

50. A method according to claim 49, wherein changing an entry in one of said tables, upon one of manual and automated refresh or reload, makes the same change in selected fields in all other tables.

51. A method according to claim 46, configuring said rules variable block within a structure that corresponds directly to the implementation of a generic operating rule, and wherein said generic operating rule specifies actions to be taken in response to a reading of said input devices.

52. A method according to claim 51, including populating said rules variable block with one or more records of data variables, and each of said records uniquely defines an operating rule, and wherein a variable type includes one of a boolean logic operator, a comparison operator and a special logic operator.

53. A method according to claim 52, wherein said special logic operator includes:

(a) a deadband operator, which allows a logical state to be maintained at input values other than an input value which triggered the state initially,

(b) a delay operator, which allows a logical state to be applied at a later time than the time at which the logical state was first triggered,

(c) proportional integral derivative (PID) control,

(d) fail on/off in the form of a state triggered by a failure,

(e) scan time in the form of frequency of device polling,

(f) flags in the form of true or false settings,

(g) boundary filters in the form of limitations on data changes,

(h) smoothing filters in the form of smoothing groups of data,

(i) scaling in the form of fitting a range to a different scale,

(j) variables in the form of storage locations,

(k) over-ride control in the form of differing control at different ranges,

(l) cascade control in the form of use of an output as an input to an operating rule,

(m) ratio control in the form of maintaining fixed ratios among variables, when one of said variables changes value,

(n) feedback control in the form of monitoring of an output and varying inputs to reach a desired output value,

(o) feed-forward control in the form of variation of inputs to reach a desired output state,

(p) virtual input/output points in the form of system states or values not associated with a physical device,

(q) schedules in the form of one of time and date based controls.

54. A method according to claim 46, including reading through said rules variable block, importing variables from a selected record and then populating a generic operating rule, thereby defining a unique rule for said record, based upon one of a variable type and a location within said record.

55. A method according to claim 54, including processing on a cycle by cycle basis and wherein within each cycle the records in said rules variable data block are read sequentially and said unique rule(s) are applied according to current input values of the associated respective records and in response to said current input values create new output values for said records in a current processing cycle.

56. A method according to claim 55, including reading selected records of said rules variable data block and providing one of an English and a non-English language translation for said unique rules associated with the selected records, by applying corresponding grammar and syntax rules and using an appropriate combination of textual data including pre-defined text strings, said input/output point names and said input/output point data values.

57. A method according to claim 56, wherein said language translations represent a sentence that is grammatically correct and has correct syntax for a chosen language and wherein said sentence includes at least one condition, express or implied.

58. A method according to claim 57, wherein said sentence is modified, while maintaining an implicit message that is unambiguous, and modifications are selected from the group consisting of:

(a) omission of a word,

(b) replacement of a word by an abbreviation,

(c) reordering of words in said sentence and

(d) reordering of said word abbreviations in said sentence.

59. A method according to claim 46, wherein said rules variable block is structured to correspond directly to implementation of a plurality of generic operating rules, wherein said plurality of generic operating rules specify action to be taken in response to a reading of said input devices.

60. A method according to claim 59, wherein said set-up software reads selected records of said rules variable data block, and provides one of an English and a non-English language translation for unique rules associated with the selected records, by applying corresponding grammar and syntax rules and using a selected combination of textual data including pre-defined text strings, said input/output point names and said input/output point data values and wherein said language translation is one of appropriate nestings and appropriate concatenations of said grammar and syntax rules and said textual data.

61. A method according to claim 60, wherein said language translations represent a sentence that is grammatically correct and has correct syntax for a chosen language and wherein said sentence includes at least one condition, express or implied.

62. A method according to claim 61, wherein said sentence is modified, while maintaining an implicit message that is unambiguous, and modifications are selected from the group consisting of:

(a) omission of a word,

(b) replacement of a word by an abbreviation,

(c) reordering of words in said sentence and

(d) reordering of said word abbreviations in said sentence.

63. A method of automated control of equipment, comprising:

(a) providing a host computer having set-up software, a minimum of one data table coupled to said set-up software and configured thereby, and a run-time application coupled to said data table;

(b) providing a communications module coupled to said run-time application and to at least one input/output module, said communications module operative to provide connectivity between said run-time application and said input/output module;

(c) providing at least one of an input and an output device coupled to said input/output modules, said input and output devices corresponding to input/output points in said system;

(d) configuring a plurality of table data blocks including an input/output point block, an HMI data block, and a rules variable block, said table data blocks being

(e) configured by entering input and output point names, and data values associated with said input and output point names, to uniquely control said corresponding output devices based on readings of corresponding ones of said input devices;

(f) configuring a plurality of run-time software components including an input/output server coupled to said communications module and coupled to an internet communications link; and

(g) configuring a plurality of tables dedicated to said table data blocks, and also configuring a plurality of additional tables, each additional table selected from the group consisting of;

(i) a table of allowed input/output module types,

(ii) a table of input/output modules available in one instance of the system implementation,

(iii) an image data table,

(iv) a table of pre-defined text strings,

(v) an alarm data table,

(vi) an alarm action data table,

(vii) a scheduling table,

(viii) an historical data table,

(ix) a reporting data table,

(x) an alarm log data table,

(xi) an HMI backdrop table,

(xii) a map definition table, and

(xiii) a map co-ordinate table.

64. A method according to claim 63, wherein changing an entry in one of said tables, upon one of manual and automated refresh or reload, makes the same change in selected fields in all other tables.

65. A method according to claim 63, including displaying entry parameters for each entry creating data entry constraints associated with said each entry.

66. A method according to claim 63, wherein making a change in an entry in one of said tables, upon one of manual and automated refresh or reload, makes the same change in selected fields in all other tables.