File_Name: Waste Processing Demo.xls Table Name Excel Tabs Rows 45 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 Waste 5 Materials UnTreated Waste 6 Materials Treated Waste 7 Systems Systems Directory 8 Schedules Schedules Directory 9 Schedules Schedule 10 Schedules New Schedule 11 Schedules Start Modes 12 Schedules End Modes 13 Schedules Holiday Schedule 14 Schedules Time Schedule 15 Equipment Retrieval Rates 16 Equipment Existing Equipment Rates 17 Equipment PTF - Drum Rates 18 Equipment PTF - Box Rates 19 Equipment AMTWF - Incineration Rates 20 Equipment AMTWF - Vitrification Rates 21 Equipment AMTWF - Super Compactor Rates 22 Equipment AMTWF - Repackaging Rates 23 Equipment ANL-W New Generation Rates 24 Equipment ER New Generation Rates 25 Equipment Loading Rates 26 Equipment Master Equipment List 27 Equipment Retrieval Equipment Failures 28 Equipment Existing Equipment Failures 29 Equipment AMTWF Equipment Failures 30 Equipment Loading Equipment Failures 31 Scheduled DT Scheduled DT Directory 32 Scheduled DT Scheduled Maintenance 33 Scheduled DT Scheduled DT Cycles 34 Scheduled DT Time Units 35 Shifts Shift Patterns Directory 36 Shifts 5 Days 1 Shifts 37 Shifts 5 Days 2 Shifts 38 Shifts 7 Days 3 Shifts 39 Shifts Days 40 Reports Report Types 41 Reports Reports 42 Reports Existing Report 43 Reports AMTWF Report 44 Reports Loading Report 45 Reports Yes/no Table Name Indexed Fields Rows 17 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 Shift Patterns Directory Start Day Days Day 0 5 Scheduled Maintenance Start Day Days Day 1 6 Scheduled Maintenance Units Time Units Units 1 7 Scheduled Maintenance Cycle Scheduled DT Cycles Cycle 1 8 Schedule System Systems Directory Name 1 9 Existing Rates Equipment Master Equipment List Equipment 1 10 Existing Equipment Failures Equipment Master Equipment List Equipment 1 11 AMTWF Equipment Failures Equipment Master Equipment List Equipment 1 12 Loading Equipment Failures Equipment Master Equipment List Equipment 1 13 Schedule Product Waste Type 1 14 UnTreated Waste Type Waste Type 1 15 Treated Waste Type Waste Type 1 16 New Schedule Product Waste Type 1 17 New Schedule System Systems 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 Waste Table Name Waste Rows 3 Cols 2 Table Format 0 Table Note Field Notes Parent Field Field Types 1 1 Field Formats 0 10 Field Access 0 0 Field Names Type Description 1 Drum 2 Box 3 SWB Table Name UnTreated Waste Rows 3 Cols 2 Table Format 0 Table Note Field Notes Field Types 1 1 Field Formats 0 10 Field Access 0 0 Field Names Type Description 1 Drum 2 Box 3 SWB Table Name Treated Waste Rows 2 Cols 2 Table Format 0 Table Note Field Notes Field Types 1 1 Field Formats 0 10 Field Access 0 0 Field Names Type Description 1 Drum 2 SWB Table Name Systems Directory Rows 6 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 Existing 2 AMTWF 3 Retrieval 4 Loading 5 ANL-W New Generation 6 ER New Generation Table Name Schedules Directory 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 Name Description 1 Schedule 2 New Schedule Table Name Schedule Rows 6 Cols 6 Table Format 0 Table Note Field Notes Index=Systems Directory;Name 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 Existing Drum 0 3153600 22680 2 2 ANL-W New Generation Drum 438000 19359600 3 3 Loading Drum 832200 19359600 4 4 AMTWF Drum 3153600 9986400 5 5 Retrieval Drum 3591600 7270800 6 6 ER New Generation Drum 4117200 11957400 Table Name New Schedule Rows 6 Cols 6 Table Format 0 Table Note Field Notes Index=Systems Directory;Name Field Types 2 1 1 0 0 0 Field Formats 0 0 0 61 61 0 Field Access 0 0 0 0 0 0 Field Names Production Run System Product Start Date End Date Goal 1 1 Existing Drum 35431 37621 22680 2 2 ANL-W New Generation Drum 35704 48852 3 3 Loading Drum 35916 48852 4 4 AMTWF Drum 37622 42369 5 5 Retrieval Drum 37895 40482 6 6 ER New Generation Drum 38261 43738 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 61 0 Field Access 0 0 Field Names Date Description 1 35796 New Years Day 2 35810 MLK Day 3 35842 Presidents Day 4 35907 Secretaries Day 5 35940 Memorial Day 6 35956 Shavout Day 7 35980 Independence Day 8 36024 Full Moon! 9 36038 Labor Day 10 36099 Halloween 11 36125 Thanksgiving 12 36154 Christmas Day Table Name Time Schedule Rows 25 Cols 2 Table Format 0 Table Note Field Notes Field Types 0 0 Field Formats 61 0 Field Access 0 0 Field Names Date Model Time 1 35431 0 2 35796 525600 3 36161 1051200 4 36526 1576800 5 36892 2102400 6 37257 2628000 7 37622 3153600 8 37987 3679200 9 38353 4204800 10 38718 4730400 11 39083 5256000 12 39448 5781600 13 39814 6307200 14 40179 6832800 15 40544 7358400 16 40909 7884000 17 41275 8409600 18 41640 8935200 19 42005 9460800 20 42370 9986400 21 42736 10512000 22 43101 11037600 23 43466 11563200 24 43831 12088800 25 44197 12614400 Table Name Retrieval Rates Rows 2 Cols 5 Table Format 0 Table Note Field Notes rate in terms of minutes rate in terms of hours rate in terms of days rate in terms of years Field Types 1 0 0 0 0 Field Formats 10 16 16 14 0 Field Access 0 0 0 0 0 Field Names Type Rate per Minute Rate per Hour Rate per Day Rate per Year 1 Drum 0.028538813 1.712328767 41.09589041 15000 2 Box 0.011605784 0.696347032 16.71232877 6100 Table Name Existing Equipment Rates Rows 3 Cols 5 Table Format 0 Table Note Field Notes rate in terms of minutes rate in terms of hours rate in terms of days rate in terms of years Field Types 1 0 0 0 0 Field Formats 10 16 16 14 0 Field Access 0 0 0 0 0 Field Names Equipment Rate per Minute Rate per Hour Rate per Day Rate per Year 1 RTR & NDA 0.008038432 0.482305936 11.57534247 4225 2 DVF 0.019025875 1.141552511 27.39726027 10000 3 ANL-W 0.000237823 0.014269406 0.342465753 125 Table Name PTF - Drum Rates Rows 4 Cols 5 Table Format 0 Table Note Field Notes rate in terms of minutes rate in terms of hours rate in terms of days rate in terms of years Field Types 1 0 0 0 0 Field Formats 10 16 16 14 10 Field Access 0 0 0 0 0 Field Names Year Rate per Minute Rate per Hour Rate per Day Rate per Year 1 2003 0.006173896 0.37043379 8.890410959 3245 2 2004-2008 0.020597412 1.235844749 29.66027397 10826 3 2009 0.006173896 0.37043379 8.890410959 3245 4 2010-2015 0.020597412 1.235844749 29.66027397 10826 Table Name PTF - Box Rates Rows 4 Cols 5 Table Format 0 Table Note Field Notes rate in terms of minutes rate in terms of hours rate in terms of days rate in terms of years Field Types 1 0 0 0 0 Field Formats 10 16 16 14 10 Field Access 0 0 0 0 0 Field Names Year Rate per Minute Rate per Hour Rate per Day Rate per Year 1 2003 0.007534247 0.452054795 10.84931507 3960 2 2004-2008 0.023972603 1.438356164 34.52054795 12600 3 2009 0.007534247 0.452054795 10.84931507 3960 4 2010-2015 0.023972603 1.438356164 34.52054795 12600 Table Name AMTWF - Incineration Rates Rows 4 Cols 5 Table Format 0 Table Note Field Notes rate in terms of minutes rate in terms of hours rate in terms of days rate in terms of years Field Types 1 0 0 0 0 Field Formats 10 16 16 14 10 Field Access 0 0 0 0 0 Field Names Year Rate per Minute Rate per Hour Rate per Day Rate per Year 1 2003 0.004195205 0.251712329 6.04109589 2205 2 2004-2008 0.014069635 0.844178082 20.26027397 7395 3 2009 0.004195205 0.251712329 6.04109589 2205 4 2010-2015 0.014069635 0.844178082 20.26027397 7395 Table Name AMTWF - Vitrification Rates Rows 4 Cols 5 Table Format 0 Table Note Field Notes rate in terms of minutes rate in terms of hours rate in terms of days rate in terms of years Field Types 1 0 0 0 0 Field Formats 10 16 16 14 10 Field Access 0 0 0 0 0 Field Names Year Rate per Minute Rate per Hour Rate per Day Rate per Year 1 2003 0.006381279 0.382876712 9.189041096 3354 2 2004-2008 0.021348935 1.280936073 30.74246575 11221 3 2009 0.006381279 0.382876712 9.189041096 3354 4 2010-2015 0.021348935 1.280936073 30.74246575 11221 Table Name AMTWF - Super Compactor Rates Rows 4 Cols 5 Table Format 0 Table Note Field Notes rate in terms of minutes rate in terms of hours rate in terms of days rate in terms of years Field Types 1 0 0 0 0 Field Formats 10 16 16 14 10 Field Access 0 0 0 0 0 Field Names Year Rate per Minute Rate per Hour Rate per Day Rate per Year 1 2003 0.004492009 0.269520548 6.468493151 2361 2 2004-2008 0.015034247 0.902054795 21.64931507 7902 3 2009 0.004492009 0.269520548 6.468493151 2361 4 2010-2015 0.015034247 0.902054795 21.64931507 7902 Table Name AMTWF - Repackaging Rates Rows 4 Cols 5 Table Format 0 Table Note Field Notes rate in terms of minutes rate in terms of hours rate in terms of days rate in terms of years Field Types 1 0 0 0 0 Field Formats 10 16 16 14 10 Field Access 0 0 0 0 0 Field Names Year Rate per Minute Rate per Hour Rate per Day Rate per Year 1 2003 0.000749619 0.044977169 1.079452055 394 2 2004-2008 0.002505708 0.150342466 3.608219178 1317 3 2009 0.000749619 0.044977169 1.079452055 394 4 2010-2015 0.002505708 0.150342466 3.608219178 1317 Table Name ANL-W New Generation Rates Rows 1 Cols 5 Table Format 0 Table Note Field Notes rate in terms of minutes rate in terms of hours rate in terms of days rate in terms of years Field Types 1 0 0 0 0 Field Formats 10 16 16 14 10 Field Access 0 0 0 0 0 Field Names Equipment Rate per Minute Rate per Hour Rate per Day Rate per Year 1 ANL-W NG 1.90259e-05 0.001141553 0.02739726 10 Table Name ER New Generation Rates Rows 10 Cols 5 Table Format 0 Table Note Field Notes rate in terms of minutes rate in terms of hours rate in terms of days rate in terms of years Field Types 1 0 0 0 0 Field Formats 61 16 16 14 10 Field Access 0 0 0 0 0 Field Names Year Rate per Minute Rate per Hour Rate per Day Rate per Year 1 10/04-9/05 0.007975647 0.478538813 11.48493151 4192 2 10/05-9/06 0.001124429 0.067465753 1.619178082 591 3 10/06-9/07 0.015338661 0.920319635 22.08767123 8062 4 10/07-9/08 0.015340563 0.92043379 22.09041096 8063 5 10/08-9/09 0.010253044 0.615182648 14.76438356 5389 6 10/09-9/11 0.006402207 0.38413242 9.219178082 3365 7 10/11-9/13 0.00640411 0.384246575 9.221917808 3366 8 10/13-9/14 0.022245053 1.334703196 32.03287671 11692 9 10/14-9/15 0.012522831 0.751369863 18.03287671 6582 10 10/18-9/19 0.026187215 1.571232877 37.70958904 13764 Table Name Loading Rates Rows 1 Cols 5 Table Format 0 Table Note Field Notes rate in terms of minutes rate in terms of hours rate in terms of days rate in terms of years Field Types 1 0 0 0 0 Field Formats 10 16 16 14 10 Field Access 0 0 0 0 0 Field Names Equipment Rate per Minute Rate per Hour Rate per Day Rate per Year 1 TLF 0.000209285 0.012557078 0.301369863 110 Table Name Master Equipment List Rows 10 Cols 2 Table Format 0 Table Note Field Notes Parent Field Field Types 1 1 Field Formats 10 10 Field Access 0 0 Field Names Equipment Description 1 RTR & NDA 2 DVF 3 ANL-W 4 PTF - Drum 5 PTF - Box 6 Incineration 7 Vitrification 8 Super Compactor 9 Repackaging 10 Loading Table Name Retrieval Equipment Failures Rows 1 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 Retrieval "[exponential,262800,,,,]" "[normal,10800,1,,,]" Table Name Existing Equipment Failures Rows 3 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 RTR & NDA "[exponential,262800,,,,]" "[normal,10800,1,,,]" 2 DVF "[exponential,262800,,,,]" "[normal,10800,1,,,]" 3 ANL-W "[exponential,262800,,,,]" "[normal,10800,1,,,]" Table Name AMTWF Equipment Failures Rows 6 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 PTF - Drum "[exponential,262800,,,,]" "[normal,10800,1,,,]" 2 PTF - Box "[exponential,262800,,,,]" "[normal,10800,1,,,]" 3 Incineration "[exponential,262800,,,,]" "[normal,10800,1,,,]" 4 Vitrification "[exponential,262800,,,,]" "[normal,10800,1,,,]" 5 Super Compactor "[exponential,262800,,,,]" "[normal,10800,1,,,]" 6 Repackaging "[exponential,262800,,,,]" "[normal,10800,1,,,]" Table Name Loading Equipment Failures Rows 1 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 Loading "[exponential,262800,,,,]" "[normal,10800,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 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 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 3 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 1 Shifts Mon 1 2 5 Days 2 Shifts Mon 1 3 7 Days 3 Shifts Mon 1 Table Name 5 Days 1 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 -16 0 2 8 -16 0 3 8 -16 0 4 8 -16 0 5 8 -16 0 6 -24 0 0 7 -24 0 0 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 -24 0 0 7 -24 0 0 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 Existing Report Sorted yes no 2 AMTWF Report Sorted yes no 3 Loading Report Sorted yes no 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 Existing Report Rows 1 Cols 6 Table Format 0 Table Note Field Notes Index=System Directory;Name 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 Run System Product Quantity Start Time End Time 1 Table Name AMTWF Report Rows 1 Cols 6 Table Format 0 Table Note Field Notes Index=System Directory;Name 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 Run System SKU Quantity Start Time End Time 1 Table Name Loading Report Rows 1 Cols 6 Table Format 0 Table Note Field Notes Index=System Directory;Name 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 Run System SKU 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