File_Name: Vegetable Plant Demo.xls Table Name Excel Tabs Rows 33 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 Base Products 5 Materials Finished Products 6 Materials Package Sizes 7 Systems Systems Directory 8 Systems System Types 9 Schedules Simulation Setup 10 Schedules Schedules Directory 11 Schedules Making Schedule 12 Schedules Packing Schedule 13 Schedules Start Modes 14 Schedules End Modes 15 Schedules System Status 16 Schedules Simulation Time Units 17 Equipment Packing Equipment Failures 18 Equipment Making Rates 19 Equipment Making Equipment Failures 20 Equipment Dicing Failures 21 Changeovers Changeovers Directory 22 Changeovers Changeovers: Product 23 Changeovers Changeovers: Package Size 24 Surge Surge Storage 25 Surge Surge Feed 26 Surge Surge Distribution 27 Surge Surge Changeovers 28 Surge Surge Changeover Multiplier 29 Surge Surge Restrictions 30 Shifts Shift Patterns Directory 31 Shifts 5 Days 3 Shifts 32 Shifts 7 Days 3 Shifts 33 Shifts Days Table Name Indexed Fields Rows 20 Cols 5 Table Format 0 Table Note Field Notes 1=optional Field Types 1 1 1 1 2 Field Formats 0 0 0 0 0 Field Access 0 0 0 0 0 Field Names Child Table Child Field Parent Table Parent Field Optional 1 Finished Products Size Package Sizes Size 2 Finished Products Base Product Base Products Base Product 3 Packing Schedule System Systems Directory Name 4 Packing Schedule Product Finished Products Finished Product 5 Changeovers: Product From Base Products Base Product 6 Changeovers: Package Size From Package Sizes Size 7 Making Schedule System Systems Directory Name 8 Making Schedule Product Base Products Base Product 9 Making Rates Product Base Products Base Product 10 Shift Patterns Directory Start Day Days Day 11 Packing Schedule Source Schedule Schedules Directory Name 12 Surge Storage Initial Material Base Products Base Product 13 Surge Feed Name Surge Storage Name 14 Surge Distribution from Surge Tank Surge Storage Name 15 Surge Changeovers From Base Products Base Product 16 Surge Changeover Multiplier Name Surge Storage Name 17 Surge Restrictions Name Surge Storage Name 18 Packing Schedule Status System Status Status 1 19 Making Schedule Status System Status Status 1 20 Simulation Setup Time Units Simulation Time Units Model Time Unit Table Name Materials Directory Rows 2 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 Base Products Raw Vegetables 2 Finished Products Canned Vegetables Table Name Base Products Rows 4 Cols 2 Table Format 0 Table Note Field Notes Parent Field Field Types 1 0 Field Formats 10 12 Field Access 0 0 Field Names Base Product Material Loss 1 Green Beans 0.02 2 Peas 0.01 3 Carrots 0.03 4 Corn 0.07 Table Name Finished Products Rows 16 Cols 3 Table Format 0 Table Note Field Notes Parent Field Index=Package Sizes;Size Index=Base Products;Base Product Field Types 1 1 1 Field Formats 0 0 10 Field Access 0 0 0 Field Names Finished Product Size Base Product 1 SKU 1 Small Green Beans 2 SKU 2 Medium Green Beans 3 SKU 3 Large Green Beans 4 SKU 4 X-Large Green Beans 5 SKU 5 Small Peas 6 SKU 6 Medium Peas 7 SKU 7 Large Peas 8 SKU 8 X-Large Peas 9 SKU 9 Small Carrots 10 SKU 10 Medium Carrots 11 SKU 11 Large Carrots 12 SKU 12 X-Large Carrots 13 SKU 13 Small Corn 14 SKU 14 Medium Corn 15 SKU 15 Large Corn 16 SKU 16 X-Large Corn Table Name Package Sizes Rows 4 Cols 5 Table Format 0 Table Note Field Notes Parent Field Packages/min Field Types 1 0 0 2 2 Field Formats 0 10 10 0 0 Field Access 0 0 0 0 0 Field Names Size Filler Rate Case Packer Rate Weight (oz) Cans per Case 1 Small 100 100 8 24 2 Medium 80 100 16 16 3 Large 60 100 24 12 4 X-Large 30 100 48 6 Table Name Systems Directory Rows 7 Cols 2 Table Format 0 Table Note Field Notes Parent Field Index=System Types;Type Field Types 1 1 Field Formats 0 0 Field Access 0 0 Field Names Name Type 1 Making 1 Making 2 Making 2 Making 3 Packing 1 Packing 4 Packing 2 Packing 5 Packing 3 Packing 6 Packing 4 Packing 7 Packing 5 Packing Table Name System Types Rows 2 Cols 1 Table Format 0 Table Note Field Notes Parent Field Field Types 1 Field Formats 0 Field Access 0 Field Names Type 1 Making 2 Packing Table Name Simulation Setup Rows 1 Cols 5 Table Format 0 Table Note Field Notes Field Types 0 0 2 1 2 Field Formats 71 71 0 0 0 Field Access 0 0 0 0 0 Field Names Model Start Date Model End Date Number of Runs Time Units Random Seed 1 36893 36910.36111 1 Minutes 0 Table Name Schedules Directory 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 Making Schedule 2 Packing Schedule Table Name Making Schedule Rows 4 Cols 10 Table Format 0 Table Note Field Notes Index=Systems Directory;Name Base Products, Base Product Field Types 2 1 1 0 0 0 1 0 0 0 Field Formats 0 0 0 71 71 0 0 71 71 10 Field Access 0 0 0 0 0 0 0 0 0 0 Field Names Production Run System Product Start Date End Date Goal Status Actual Start Date Actual End Date Actual Production 1 1 Making 1 Green Beans 36893 36894 150000 2 2 Making 2 Peas 36893 36894 150000 3 3 Making 1 Carrots 36894 36895 150000 4 4 Making 2 Corn 36894 36895 150000 Table Name Packing Schedule Rows 16 Cols 12 Table Format 0 Table Note Field Notes Index=Systems Directory;Name Index=Finished Products, Finished Product Index=Schedules Directory;Name Field Types 2 1 1 0 0 0 1 2 1 0 0 0 Field Formats 0 0 0 71 71 0 0 0 0 71 71 10 Field Access 0 0 0 0 0 0 0 0 0 0 0 0 Field Names Production Run System Product Start Date End Date Goal Source Schedule Source Run Status Actual Start Date Actual End Date Actual Production 1 1 Packing 1 SKU 1 36893.04167 36893.54167 1500 Making Schedule 1 2 2 Packing 2 SKU 5 36893.04167 36893.54167 1500 Making Schedule 2 3 3 Packing 3 SKU 2 36893.04167 36893.54167 1000 Making Schedule 1 4 4 Packing 4 SKU 3 36893.04167 36893.54167 1000 Making Schedule 1 5 5 Packing 5 SKU 8 36893.04167 36893.54167 1000 Making Schedule 2 6 6 Packing 3 SKU 6 36893.54167 36894.04167 1000 Making Schedule 2 7 7 Packing 4 SKU 7 36893.54167 36894.04167 1000 Making Schedule 2 8 8 Packing 5 SKU 4 36893.54167 36894.04167 1000 Making Schedule 1 9 9 Packing 1 SKU 9 36894.04167 36894.54167 1500 Making Schedule 3 10 10 Packing 2 SKU 13 36894.04167 36894.54167 1500 Making Schedule 4 11 11 Packing 3 SKU 10 36894.04167 36894.54167 1000 Making Schedule 3 12 12 Packing 4 SKU 11 36894.04167 36894.54167 1000 Making Schedule 3 13 13 Packing 5 SKU 16 36894.04167 36894.54167 1000 Making Schedule 4 14 14 Packing 3 SKU 14 36894.54167 36895 1000 Making Schedule 4 15 15 Packing 4 SKU 15 36894.54167 36895 1000 Making Schedule 4 16 16 Packing 5 SKU 12 36894.54167 36895 1000 Making Schedule 3 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 System Status Rows 4 Cols 1 Table Format 0 Table Note Field Notes Field Types 1 Field Formats 71 Field Access 0 Field Names Status 1 Ready 2 Running 3 Emptying 4 Empty Table Name Packing Equipment Failures Rows 2 Cols 3 Table Format 0 Table Note Field Notes Index=Master Equipment List; Equipment Field Types 1 0 0 Field Formats 10 12 12 Field Access 0 0 0 Field Names Equipment TBF TTR 1 Filler "[exponential,10080,,,,]" "[normal,10,1,,,]" 2 Case Packer "[exponential,10080,,,,]" "[normal,10,1,,,]" Table Name Making Rates Rows 4 Cols 5 Table Format 0 Table Note Field Notes Index=Base Product; Base Product Field Types 1 0 0 0 0 Field Formats 10 10 10 10 10 Field Access 0 0 0 0 0 Field Names Product Washing (lbs/min) Dicing (lbs/min) Seasoning (lbs/min) Cooking (lbs/min) 1 Green Beans 480 400 400 375 2 Peas 560 640 400 200 3 Carrots 520 520 400 350 4 Corn 400 320 400 325 Table Name Making Equipment Failures Rows 4 Cols 3 Table Format 0 Table Note Field Notes Field Types 1 0 0 Field Formats 10 12 12 Field Access 0 0 0 Field Names Equipment TBF TTR 1 Washing "[exponential,10080,,,,]" "[normal,10,1,,,]" 2 Dicing "[exponential,10080,,,,]" "[normal,10,1,,,]" 3 Seasoning "[exponential,10080,,,,]" "[normal,10,1,,,]" 4 Cooking "[exponential,10080,,,,]" "[normal,10,1,,,]" Table Name Dicing Failures Rows 2 Cols 4 Table Format 0 Table Note Field Notes Field Types 1 0 0 2 Field Formats 10 12 12 0 Field Access 0 0 0 0 Field Names Equipment TBF TTR Machine Set 1 Dicing 1 "[exponential,10000,,,,]" "[normal,10,1,,,]" 1 2 Dicing 2 "[exponential,10500,,,,]" "[normal,10,1,,,]" 2 Table Name Changeovers Directory Rows 2 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 Table Attribute Lookup Table Attribute Lookup Field 1 Changeovers: Product Finished Products Base Product 2 Changeovers: Package Size Finished Products Size Table Name Changeovers: Product Rows 4 Cols 5 Table Format 0 Table Note Field Notes Index=Product Flavors;Flavor Field Types 1 0 0 0 0 Field Formats 10 12 12 12 12 Field Access 0 0 0 0 0 Field Names From Green Beans Peas Carrots Corn 1 Green Beans 0 10 10 10 2 Peas 10 0 10 10 3 Carrots 10 10 0 10 4 Corn 10 10 10 0 Table Name Changeovers: Package Size Rows 4 Cols 5 Table Format 0 Table Note Field Notes Index=Package Sizes;Size Field Types 1 0 0 0 0 Field Formats 10 12 12 12 12 Field Access 0 0 0 0 0 Field Names From to Small to Medium to Large to X-Large 1 Small 0 10 10 10 2 Medium 10 0 10 10 3 Large 10 10 0 10 4 X-Large 10 10 10 0 Table Name Surge Storage Rows 8 Cols 4 Table Format 0 Table Note Field Notes kg Field Types 1 0 0 1 Field Formats 0 0 0 10 Field Access 0 0 0 0 Field Names Name Capacity Start-up Initial Material 1 Bin 1 7500 1000 Green Beans 2 Bin 2 7500 1000 Peas 3 Bin 3 7500 1000 Carrots 4 Bin 4 7500 1000 Corn 5 Bin 5 7500 1000 Green Beans 6 Bin 6 7500 1000 Peas 7 Bin 7 7500 1000 Carrots 8 Bin 8 7500 1000 Corn Table Name Surge Feed Rows 8 Cols 3 Table Format 0 Table Note Field Notes rate or 0=not allowed rate or 0=not allowed Field Types 1 0 0 Field Formats 0 0 0 Field Access 0 0 0 Field Names Name from Making 1 from Making 2 1 Bin 1 500 500 2 Bin 2 500 500 3 Bin 3 500 500 4 Bin 4 500 500 5 Bin 5 500 500 6 Bin 6 500 500 7 Bin 7 500 500 8 Bin 8 500 500 Table Name Surge Distribution Rows 8 Cols 6 Table Format 0 Table Note Field Notes rate or 0=not allowed rate or 0=not allowed rate or 0=not allowed rate or 0=not allowed rate or 0=not allowed Field Types 1 0 0 0 0 0 Field Formats 0 0 0 0 0 0 Field Access 0 0 0 0 0 0 Field Names from Surge Tank to Packing 1 to Packing 2 to Packing 3 to Packing 4 to Packing 5 1 Bin 1 100 100 100 100 100 2 Bin 2 100 100 100 100 100 3 Bin 3 100 100 100 100 100 4 Bin 4 100 100 100 100 100 5 Bin 5 100 100 100 100 100 6 Bin 6 100 100 100 100 100 7 Bin 7 100 100 100 100 100 8 Bin 8 100 100 100 100 100 Table Name Surge Changeovers Rows 4 Cols 5 Table Format 0 Table Note Field Notes Field Types 1 0 0 0 0 Field Formats 10 0 0 0 0 Field Access 0 0 0 0 0 Field Names From to Green Beans to Peas to Carrots to Corn 1 Green Beans 0 60 60 60 2 Peas 60 0 60 60 3 Carrots 60 60 0 60 4 Corn 60 60 60 0 Table Name Surge Changeover Multiplier Rows 8 Cols 2 Table Format 0 Table Note Field Notes Field Types 1 0 Field Formats 0 0 Field Access 0 0 Field Names Name Multiplier 1 Bin 1 "[Normal;1;0.1;]" 2 Bin 2 "[Normal;1;0.1;]" 3 Bin 3 "[Normal;1;0.1;]" 4 Bin 4 "[Normal;1;0.1;]" 5 Bin 5 "[Normal;1;0.1;]" 6 Bin 6 "[Normal;1;0.1;]" 7 Bin 7 "[Normal;1;0.15;]" 8 Bin 8 "[Normal;1;0.15;]" Table Name Surge Restrictions Rows 8 Cols 5 Table Format 0 Table Note Field Notes 1=allowed 0=not allowed 1=allowed 0=not allowed 1=allowed 0=not allowed 1=allowed 0=not allowed Field Types 1 2 2 2 2 Field Formats 0 0 0 0 0 Field Access 0 0 0 0 0 Field Names Name to Green Beans to Peas to Carrots to Corn 1 Bin 1 1 1 1 1 2 Bin 2 1 1 1 1 3 Bin 3 1 1 1 1 4 Bin 4 1 1 1 1 5 Bin 5 1 1 1 1 6 Bin 6 1 1 1 1 7 Bin 7 1 1 1 1 8 Bin 8 1 1 1 1 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 3 Shifts Mon 1 2 7 Days 3 Shifts Mon 1 Table Name 5 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 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 Simulation Time Units Rows 4 Cols 1 Table Format 0 Table Note Field Notes Field Types 1 Field Formats 71 Field Access 0 Field Names Model Time Unit 1 Minutes 2 Hours 3 Days 4 Weeks EndofFile