File_Name: Chocolate Processing Demo.xls Table Name Excel Tabs Rows 27 Cols 2 Table Format 0 Table Note Each table and its associated tab are defined here. Field Notes Select table and use DB Menu|Go to Selected Table Field Types 1 1 Field Formats 0 0 Field Access 0 0 Field Names Tab Name Tab Item 1 Table Outline Excel Tabs 2 Database Structure Indexed Fields 3 Materials Materials Directory 4 Materials Materials-Raw 5 Systems Systems Directory 6 Systems System Types 7 Schedules Schedules Directory 8 Schedules Bean Processing Schedule 9 Schedules Cocoa Powder Schedule 10 Schedules Chocolate Making Schedule 11 Schedules Start Modes 12 Schedules End Modes 13 Schedules Holiday Schedule 14 Equipment Making Times 15 Equipment Making 1 Equipment Failures 16 Scheduled DT Scheduled DT Directory 17 Scheduled DT Scheduled Maintenance 18 Scheduled DT Scheduled DT Cycles 19 Scheduled DT Time Units 20 Shifts Shift Patterns Directory 21 Shifts 5 Days 2 Shifts 22 Shifts 7 Days 3 Shifts 23 Shifts Days 24 Reports Report Types 25 Reports Reports 26 Reports System Report 27 Reports Yes/no Table Name Indexed Fields Rows 18 Cols 6 Table Format 0 Table Note Field Notes 1=optional optional field Field Types 1 1 1 1 2 1 Field Formats 0 0 0 0 0 0 Field Access 0 0 0 0 0 0 Field Names Child Table Child Field Parent Table Parent Field Optional Type 1 Reports Sub-totals Yes/No Name 1 2 Reports Totals Yes/No Name 1 3 Reports Type Report Types Name 1 4 System Report Product Materials-Raw Base 1 5 System Report System Systems Directory Name 1 6 Systems Directory Type System Types Type 1 7 Shift Patterns Directory Start Day Days Day 0 8 Scheduled Maintenance Start Day Days Day 0 9 Scheduled Maintenance Units Time Units Units 0 10 Scheduled Maintenance Cycle Scheduled DT Cycles Cycle 0 11 Bean Processing Schedule System Systems Directory Name 1 12 Bean Processing Schedule Product Materials-Raw Base 1 13 Cocoa Powder Schedule System Systems Directory Name 1 14 Cocoa Powder Schedule Product Materials-Raw Base 1 15 Cocoa Powder Schedule Source Schedule Schedules Directory Name 1 16 Chocolate Making Schedule System Systems Directory Name 1 17 Chocolate Making Schedule Product Materials-Raw Base 1 18 Chocolate Making Schedule Source Schedule Schedules Directory Name 1 Table Name Materials Directory Rows 1 Cols 2 Table Format 0 Table Note Field Notes Field Types 1 1 Field Formats 0 0 Field Access 0 0 Field Names Name Description 1 Materials-Raw Table Name Materials-Raw Rows 3 Cols 1 Table Format 0 Table Note Field Notes Parent Field Field Types 1 Field Formats 0 Field Access 0 Field Names Base 1 Processed Beans 2 Cocoa Powder 3 Chocolate Table Name Systems Directory Rows 3 Cols 3 Table Format 0 Table Note Field Notes Parent Field Index=System Types;Type Field Types 1 1 1 Field Formats 0 0 0 Field Access 0 0 0 Field Names Name Description Type 1 BeanProcessing Making 2 CocoaPowder Making 3 Chocolates Making Table Name System Types Rows 2 Cols 2 Table Format 0 Table Note Field Notes Parent Field Field Types 1 1 Field Formats 0 0 Field Access 0 0 Field Names Type Description 1 Making 2 Packing Table Name Schedules Directory Rows 3 Cols 2 Table Format 0 Table Note Field Notes Parent Field Field Types 1 1 Field Formats 0 0 Field Access 0 0 Field Names Name Description 1 Bean Processing Schedule 2 Cocoa Powder Schedule 3 Chocolate Making Schedule Table Name Bean Processing Schedule Rows 5 Cols 6 Table Format 0 Table Note Field Notes Index=Systems Directory;Name Index=Materials-Raw;Base Field Types 2 1 1 0 0 0 Field Formats 0 0 0 0 0 0 Field Access 0 0 0 0 0 0 Field Names Production Run System Product Start Time End Time Goal 1 1 BeanProcessing Processed Beans 0 540 35000 2 2 BeanProcessing Processed Beans 1440 2880 35000 3 3 BeanProcessing Processed Beans 2880 4320 35000 4 4 BeanProcessing Processed Beans 4320 5760 35000 5 5 BeanProcessing Processed Beans 5760 7200 35000 Table Name Cocoa Powder Schedule Rows 5 Cols 8 Table Format 0 Table Note Field Notes Index=Systems Directory;Name Index=Schedules Directory;Name Index=Materials-Finished;SKU Field Types 2 1 1 2 1 0 0 0 Field Formats 0 0 0 0 0 0 0 0 Field Access 0 0 0 0 0 0 0 0 Field Names Production Run System Source Schedule Source Run Product Start Time End Time Goal 1 1 CocoaPowder Bean Processing Schedule 1 Cocoa Powder 0 1440 15000 2 2 CocoaPowder Bean Processing Schedule 2 Cocoa Powder 1440 2880 10000 3 3 CocoaPowder Bean Processing Schedule 3 Cocoa Powder 2880 4320 5000 4 4 CocoaPowder Bean Processing Schedule 4 Cocoa Powder 4320 5760 75000 5 5 CocoaPowder Bean Processing Schedule 5 Cocoa Powder 5760 7200 12000 Table Name Chocolate Making Schedule Rows 5 Cols 8 Table Format 0 Table Note Field Notes Index=Systems Directory;Name Index=Schedules Directory;Name Index=Materials-Finished;SKU Field Types 2 1 1 2 1 0 0 0 Field Formats 0 0 0 0 0 0 0 0 Field Access 0 0 0 0 0 0 0 0 Field Names Production Run System Source Schedule Source Run Product Start Time End Time Goal 1 1 Chocolates Bean Processing Schedule 1 Chocolate 0 1440 25000 2 2 Chocolates Bean Processing Schedule 2 Chocolate 1440 2880 17000 3 3 Chocolates Bean Processing Schedule 3 Chocolate 2880 4320 8000 4 4 Chocolates Bean Processing Schedule 4 Chocolate 4320 5760 20000 5 5 Chocolates Bean Processing Schedule 5 Chocolate 5760 7200 18000 Table Name Start Modes Rows 3 Cols 2 Table Format 0 Table Note Field Notes Parent Field Field Types 1 1 Field Formats 0 0 Field Access 0 0 Field Names Modes Description 1 Start Time Specified start time. 2 When Ready When setup complete from prior run. 3 Users Start When any user run has started. Table Name End Modes Rows 8 Cols 2 Table Format 0 Table Note Field Notes Parent Field Field Types 1 1 Field Formats 0 0 Field Access 0 0 Field Names Modes Description 1 Next ST End at next start time. 2 End Time Specified end time. 3 Goal Use the specified goal. 4 1st of ET & goal First of end time and goal. 5 1st of ST & goal First of start time of next run and goal. 6 2nd of ET & goal Second of end time and goal. 7 Users Goals met All user goals are met. 8 Source Empty End when source is empty. Table Name Holiday Schedule Rows 12 Cols 2 Table Format 0 Table Note Field Notes Field Types 0 1 Field Formats 0 0 Field Access 0 0 Field Names Date Description 1 36892 New Years Day 2 36906 MLK Day 3 36938 Presidents Day 4 37003 Secretaries Day 5 37036 Memorial Day 6 37052 Shavout Day 7 37076 Independence Day 8 37120 Full Moon! 9 37134 Labor Day 10 37195 Halloween 11 37221 Thanksgiving 12 37250 Christmas Day Table Name Making Times Rows 3 Cols 10 Table Format 0 Table Note Field Notes Index=Product Flavors;Flavor Field Types 1 0 0 0 0 0 0 0 0 0 Field Formats 0 12 12 12 10 10 10 10 10 10 Field Access 0 0 0 0 0 0 0 0 0 0 Field Names Product Separator Roaster Mills Press Breaker Mixer 1 Mixer 2 Refiners Emulsifiers 1 Processed Beans "[Normal;35;1;]" "[Normal;32;1;]" "[Normal;30;1;]" 2 Cocoa Powder "[Normal;35;1;]" "[Normal;37;1;]" "[Normal;48;1;]" 3 Chocolate "[Normal;35;1;]" "[Normal;40;1;]" "[Normal;30;1;]" "[Normal;37;1;]" Table Name Making 1 Equipment Failures Rows 7 Cols 3 Table Format 0 Table Note Field Notes Index=Master Equipment List; Equipment Field Types 1 0 0 Field Formats 0 12 12 Field Access 0 0 0 Field Names Equipment MTBF MTTR 1 Mills "[Exponential;7500;;]" "[Normal;20;1;]" 2 Roaster "[Exponential;7500;;]" "[Normal;20;1;]" 3 Press "[Exponential;7500;;]" "[Normal;20;1;]" 4 Breaker "[Exponential;7500;;]" "[Normal;20;1;]" 5 Mixers "[Exponential;7500;;]" "[Normal;20;1;]" 6 Refiners "[Exponential;7500;;]" "[Normal;20;1;]" 7 Emulsifiers "[Exponential;7500;;]" "[Normal;20;1;]" Table Name Scheduled DT Directory Rows 1 Cols 3 Table Format 0 Table Note Field Notes Field Types 1 1 1 Field Formats 0 0 0 Field Access 0 0 0 Field Names Name Type Description 1 Scheduled Maintenance Table Name Scheduled Maintenance Rows 1 Cols 6 Table Format 0 Table Note Field Notes Index=Days;Day Index=Time Units;Units Index=Scheduled DT Cycles;Cycle Field Types 1 0 0 1 1 1 Field Formats 0 0 0 0 0 0 Field Access 0 0 0 0 0 0 Field Names Start Day Time Duration Units Cycle Description 1 Mon 16 0.5 hours Daily Wash Down Table Name Scheduled DT Cycles Rows 7 Cols 2 Table Format 0 Table Note Field Notes Parent Field Field Types 1 1 Field Formats 0 0 Field Access 0 0 Field Names Cycle Description 1 Once only no cycle 2 Shift (8 hrs) every eight hours 3 Shift (10 hrs) every ten hours 4 Shift (12 hrs) every twelve hours 5 Daily every twenty-four hours 6 Weekly every seven days 7 Bi-Weekly every fourteen days Table Name Time Units Rows 5 Cols 2 Table Format 0 Table Note Field Notes Parent Field Field Types 1 1 Field Formats 0 0 Field Access 0 0 Field Names Units Description 1 seconds 2 minutes 3 hours 4 days 5 weeks Table Name Shift Patterns Directory Rows 2 Cols 4 Table Format 0 Table Note Field Notes Index=Days;Day Field Types 1 1 0 1 Field Formats 0 0 0 0 Field Access 0 0 0 0 Field Names Name Start Day start hour Description 1 5 Days 2 Shifts Mon 8 2 7 Days 3 Shifts Mon 8 Table Name 5 Days 2 Shifts Rows 7 Cols 3 Table Format 0 Table Note Field Notes Field Types 0 0 0 Field Formats 0 0 0 Field Access 0 0 0 Field Names 1 2 3 1 8 8 -8 2 8 8 -8 3 8 8 -8 4 8 8 -8 5 8 8 -8 6 -8 -8 -8 7 -8 -8 -8 Table Name 7 Days 3 Shifts Rows 7 Cols 3 Table Format 0 Table Note Field Notes Field Types 0 0 0 Field Formats 0 0 0 Field Access 0 0 0 Field Names 1 2 3 1 8 8 8 2 8 8 8 3 8 8 8 4 8 8 8 5 8 8 8 6 8 8 8 7 8 8 8 Table Name Days Rows 7 Cols 1 Table Format 0 Table Note Field Notes Parent Field Field Types 1 Field Formats 0 Field Access 0 Field Names Day 1 Mon 2 Tue 3 Wed 4 Thu 5 Fri 6 Sat 7 Sun Table Name Report Types Rows 3 Cols 2 Table Format 0 Table Note Field Notes Parent Field Field Types 1 1 Field Formats 0 0 Field Access 0 0 Field Names Name Description 1 Raw Data In order of Production Run start. 2 Sorted Sorted by field from left to right. 3 Consolidated Table Name Reports Rows 11 Cols 4 Table Format 0 Table Note Field Notes Index=Report Types;Name Index=Yes/No;Name Index=Yes/No;Name Field Types 1 1 1 1 Field Formats 0 0 0 0 Field Access 0 0 0 0 Field Names Name Type Totals Sub-Totals 1 System Report Consolidated yes no 2 2 unused 3 3 unused 4 4 unused 5 5 unused 6 6 unused 7 7 unused 8 8 unused 9 9 unused 10 10 unused 11 11 unused Table Name System Report Rows 1 Cols 6 Table Format 0 Table Note Field Notes Index=System Directory;Name Index=Materials-Finished;SKU Field Types 1 2 1 0 0 0 Field Formats 0 0 0 0 0 0 Field Access 0 0 0 0 0 0 Field Names System Run Product Quantity Start Time End Time 1 Table Name Yes/no Rows 2 Cols 1 Table Format 0 Table Note Field Notes Parent Field Field Types 1 Field Formats 0 Field Access 0 Field Names Name 1 yes 2 no EndofFile