Model User's Guide - AINA Publications Server
Contents
1. Status Source Category Year of Use Project Description Project Location Sponsor NORTH OF 60 ENGINEERING LTD Is the quarry permit number The person or company that is gues the permits This would generally be the person responsible for the payment of royalties and meeting the conditions of the permit This represents the date the record was first entered or last updated It is entered by the user This is the status of the specific project The user should enter one of the following depending on the stage of development e Estimate e Active e Inactive e Closed The gravel source number ID within the block A descriptive category for the sponsor NORTH OF 60 ENGINEERING LTD recommends that a limited number of categories be used Possible examples are e Public e Private e Defence The year that the material was used Initially this would be an estimate but would change to reflect actual year of use A brief description of the project The location of the project Latitude and longitudes are recommended The name of the individual company or municipality that is sponsoring the project Granular Usage Database 11 Granular Resources Forecast Model User s Guide Contractor Low Estimate Likely Estimate High Estimate Estimate Default Estimated Class Requested Amount Requested Class Actual Amount Actual Class 3 3 Data Management The per2. in Windows Explorer or by using the File Open command in Microsoft Access 3 The Main Menu will appear NORTH OF 60 ENGINEERING LTD Getting Started 6 Granular Resources Forecast Model User s Guide Figure 2 Main Menu 2 5 Program Structure The Granular Resource Forecast Model is a database of historical current and future granular requirements The application has been divided into two major components The first half of the application is devoted to adding and maintaining information within the database The details of the database will be discussed in the next section of the User s Guide The second half of the application is devoted to analyzing the information within the database both from historical and future perspectives You can for example compare actual granular usage to historical forecasts or usage by area source or quality The analysis section also allows with limitations users to define their own criteria to study the data The specifics on data analysis and the various reports that are available are presented in Section 4 of the User s Guide NORTH OF 60 ENGINEERING LTD Getting Started 7 Granular Resources Forecast Model User s Guide 3 Granular Usage Database 3 1 Introduction This section of the User s Guide focuses on the Granular Usage Database its makeup and procedures to maintain it As a user you access the database by clicking on the Quarry Permits button on
3. pointer until the tip of the pointer rests on what you want to point to on the screen For example Point to the button Add or Update Data Click means to press and immediately release the mouse button without moving the mouse For example Click on the button named Add or Update Data Double click means to click the mouse button twice in rapid succession For example Double click on the Microsoft Excel icon to start Microsoft Excel Keyboard e Key names match the names shown on most keyboards and appear in small capital letters For example the Shift key appears as SHIFT 1 5 Technical Support NORTH OF 60 ENGINEERING LTD offers a variety of support options to help get the most from the Granular Resource Forecast Model These services include NORTH OF 60 ENGINEERING LTD Introduction 3 Granular Resources Forecast Model User s Guide Custom modifications to the model Customized training e Technical support If you encounter a problem or have a question about the application first look in the printed documentation If you cannot find the answer phone or fax NORTH OF 60 ENGINEERING LTD from 8 a m to 5 p m Mountain Time Monday through Friday NORTH OF 60 ENGINEERING LTD support services are subject to prices terms and conditions in place at the time the service is required When you call you should be at your computer with the Granular Resource Forecast Model running Be p
4. record to edit 3 Edit each field you want to change Press TAB to move between fields To cancel changes of a record press the ESC key on the keyboard To Return to the Main Menu 1 Choose the Close button when you are finished working in the data form 2 Alternatively choose the X button in the top right corner of the dialog box Special Controls Some fields on the Quarry Permits Form have special controls that help select and manage the data entering in the field These fields have a small button beside them that will open a dialog box to edit lists such as sources company names and addresses block areas or latitude and longitude DMS entry View Database To view the granular usage database in tabular form choose the Unhide command from the Window menu Select the database window and choose OK Editing the tables directly requires advanced skill in Microsoft Access and Relational Database Design Backup Database To backup the database copy the GRANULAR MDB file to a floppy disk CD or alternate folder Compacting the Database As records are modified and deleted the database increases in size Periodically compacting the database is required to keep the database file small Choose the Compact amp Repair Database command from the Tools menu in Microsoft Access NORTH OF 60 ENGINEERING LTD Granular Usage Database 14 Granular Resources Forecast Model User s Guide 3 4 Importing LIMS Data L
5. 22
6. D and licensed to the Department of indian and Northern Affairs and the Inuvialuit Land Administration pursuant to the general conditions set out in document 1632 99 0450 Users of this model may not make any use of Software that is not expressly provided for in the general conditions NORTH OF 60 ENGINEERING LTD shall for a period of 90 days from the date of delivery replace any diskette on which the Software is supplied which is defective in material or workmanship under normal use NORTH OF 60 ENGINEERING LTD does not make any representations regarding the use or the results of use of the Software or Documentation in terms of correctness or otherwise The entire risk as to the results and performance of the model is assumed by the user NORTH OF 60 ENGINEERING LTD specifically disclaims all other warranties expressed or implied including but not limited to any implied term condition representation or warranty of merchantability _ or fitness for a particular purpose that the model will meet your requirements that the operation of the model will be uninterrupted or error free or that our maintenance will remedy any error deficiency or other bug encountered Information in this Model is subject to change without notice and does not represent a commitment on the part of NORTH OF 60 ENGINEERING LTD NORTH OF 60 ENGINEERING LTD Appendix A 21 Granular Resources Forecast Model User s Guide Appendix B Granular Mater
7. Database e 12 Granular Resources Forecast Model User s Guide done by clicking on the buttons with arrows and bars Creating a new record can be done by clicking on the button with an arrow and an asterisk The record number can also be entered in the text box to navigate directly to a specific record of 396 iin T o pie Figure 5 Record Navigation Buttons Adding Updating or Deleting Records To Add a Record 1 Display the Quarry Permits Form 2 Choose the New Button 3 Enter data in the new record s fields Press TAB to move between fields l 4 Repeat steps 1 and 2 to add as many records as you want To Delete a Record Note Deleted records cannot be restored To delete a record 1 Display the Quarry Permits Form 2 Display the record you want to delete 3 Choose the Quick List button Make sure the record you want to delete is selected 4 Push the DELETE key on the keyboard To Find a Record 1 Display the Quarry Permits Form 2 Select the field that you want to search 3 Choose the Find command from the edit menu or the toolbar 4 Enter the criteria in the dialog box and choose Find Next NORTH OF 60 ENGINEERING LTD Granular Usage Database e 13 Granular Resources Forecast Model User s Guide It may be easier to search the permits by sorting the quick list to display the permits in a specific order MEL To Edit Records 1 Display the Quarry Permits Form 2 Locate the
8. IMS is an alternate database that contains granular resource information that can be imported into the model This is an advanced feature that requires knowledge of Microsoft Access table linking A procedure for importing LIMS using the LIMSSAMPLEDATA XLS worksheet follows 1 2 3 7 Choose Import LIMS Data from the main menu Choose Link External Table from the dialog box that appears A file open dialog box appears Select the file that contains the LIMS data and click on the Link button You may need to change the file type to Microsoft Excel if the data is in a spreadsheet For this example look for the LIMSSAMPLEDATA XLS workbook in the GRANMANUAL folder The Microsoft Access Link Suieadsheet Wizard appears Select the worksheet or named range that contains the data and choose Next If asked to use the first row as column headings select the option and choose Next f asked to enter a table name use the default name given and choose Finish The LIMS data should be linked to the application When back to the LIMS Import dialog box choose Next to add the LIMS data to the database or Cancel to return to the main menu It is extremely important that the LIMS data be formatted in a table like the data in LIMSSAMPLEDATA XLS Particular attention should be made to the field names in the sample file NORTH OF 60 ENGINEERING LTD Granular Usage Database e 15 Granular Resources Forecast Model User s Guide 4 An
9. N A North of 60 Engineering Ltd Granular Resources Forecast Model User s Guide For Indian and Northern Affairs Canada and the Inuvialuit Land Administration James C McDougall P Eng C William Tetz NORTH OF 60 ENGINEERING L TD 1400 800 5 AvE SW CALGARY ALBERTA T2P 3T6 February 2002 num A S 762 Granular Resources Forecast Model User s Guide For Indian and Northern Affairs Canada and the Inuvialuit Land Administration James C McDougall P Eng C William Tetz NORTH OF 60 ENGINEERING LTD February 2002 Granular Resources Forecast Model User s Guide Table of Contents Table of Gontents n enin acie ris i eee Pra e cir E ro geek tare Ea aaa a ea dot ge a a goa i 1 Introduction 1 1 1 Baekgrourid ideo terrore ra eta ne ast tacese 1 1 2 Forecast Model OVOrVIGW iio especie PO e e Pale Tos oap eeeda kost ma ava ka sS E Vin 2 1 3 Forecast Model Documentation esses eene eae 2 Ee Isi EEUU 3 1 5 Technical SUppOrt odii re rris irte egere er eec e ERE SUE ds needs 3 2 Getting Started 5 2 1 System Requirements 5 2 2 Installing the Forecast Model esent 5 2 3 File Structure of Model 5 n ener ethic HE ce ANA aede 6 2 4 Starting the Program NEM i haute A ens a NONEM 6 2 5 Program Structure sued etna o Ra Re a lang igs Mawr ee ened taser Aen oaa ods 7 3 Granular Usage Database 8 3T I
10. alyzing Granular Usage 4 1 Introduction This section of the User s Guide describes the various options available to the user to analyze data within the database It also covers the available reporting options 4 2 Demand Analysis Actual vs Forecast Selecting the Forecast Chart button on the menu produces a graph showing the historical granular usage The graph shown in Figure 6 plots estimated requirements requested amounts and actual usage Over time this plot will tell wheter Aes eetnaiee are eee or bud i m m EE Repon pina EL AASA PPPPOPERPEEEEP OP Pere ut Regaad ue Acted Figure 6 Granular Resource Usage Graph NORTH OF 60 ENGINEERING LTD Analyzing Granular Usage e 16 Granular Resources Forecast Model User s Guide Usage by Area Selecting the Quantities by Block button on the menu produces a cross tabulation of the database showing the granular usage by area Figure 7 is an example view of resource usage by area For those unfamiliar with cross tabulations or pivot tables as they are referred to in Excel they are a subset of the database representing various categories within the database In this case the pivot table is summarizing the usage by year into the various areas The table shows the years along the side row and areas across the top column The need and usage of this terminology will become more evident E j Ei ote rosatt tiet Warksheet in Main Moan Ha Permit Quantity Sum
11. as three fields name address phone number Each set of information is called a record For example this entry in a phone book constitutes a record Doe John 13 Elm Street 555 4321 NORTH OF 60 ENGINEERING LTD Granular Usage Database 9 Granular Resources Forecast Model User s Guide DATA DESCRIPTION Permit Holder Company responsible for permits Date Modified Date the record was modified Status Estimate Active Closed Inactive Source Code Identification End user classification e g Private Government Military Municipal n Category Estimate Default Value Estimate Classification Actual Class Actual classification Low Estimate Low estimate of requirements Table 2 Granular Resource Data Base There are two basic arrangements for tracking data The telephone book is a tabular database The information is arranged in a table of columns and rows Another way to look at the information within the database is through forms much like a card file or Rolodex The NORTH OF 60 ENGINEERING LTD Granular Usage Database 10 Granular Resources Forecast Model User s Guide Granular Resource Forecast Model uses forms and tables to record and view granular usage The granular usage database contains many fi fields of information for each record These fields are summarized in Table 2 and discussed in detail below Quarry Permit Permit Holder Date Modified
12. business use _ For complete details please read the license agreement in Appendix A To install the Granular Resource Forecast Model 1 The model and the database are contained in a single Microsoft Access database file The file can be copied to any folder on the system using Windows Explorer NORTH OF 60 ENGINEERING LTD Getting Started 5 Granular Resources Forecast Model User s Guide 2 To use the help feature of the model the help files must be copied to a folder called GRANMANUAL This folder must be located in the same folder as the model 2 3 File Structure of Model The Granular Resource Forecast Model has been developed as an application within Microsoft Access so it requires Access to operate The installation procedure outlined in the previous section copied one file and one folder onto your hard drive Their names and function within the application are summarized in Table 1 File Folder Name gue on Description GRANULAR MDB Application and Database File GRANMANUAL Folder containing all the help files Table 1 Granular Resource Forecast Model Files 2 4 Starting the Program To run the Granular Resource Forecast Model application 1 Close any unnecessary applications that may be operating on your computer to maximize memory and system resources This is done by selecting Exit from the File menu of the applications 2 Open the GRANULAR MDB file by double clicking on the file icon
13. cts 13 Analyzing Granular Usage 16 Background 1 Backup Database 14 Contractor 12 Conventions 3 Data Management 12 15 Data Management Menu 8 Database Fields 9 Date of Record 11 Delete a Record 13 Documentation 2 Edit Records 14 Estimated Class 12 File Structure 6 Find a Record 13 NORTH OF 60 ENGINEERING LTD Form 13 14 Getting Started 5 Granular Resource Data Base 10 Granular resources 1 Granular Usage Database 8 gravel 1 High Estimate 12 Historical Demand 16 Installation 5 Introduction 1 Keyboard 3 Low Estimate 12 Main Menu 7 Mean Estimate 12 model framework 2 Model Overview 2 Mouse 3 Permit Holder 11 Program Structure 7 Project Description 11 Project Location 11 Project objective 2 Quarry Permit 11 Quick List 9 Record Navigation 12 Requested Amount 12 Requested Class 12 Source 11 Sponsor 12 Sponsor Category 11 Starting the Program 6 Status 11 index e 19 Granular Resources Forecast Model User s Guide System Requirements 5 Table of Contents i Technical support 4 Technical Support 3 Training 4 Usage by Area 17 Usage by Source and Quality 17 User Defined Analysis 18 View Database 14 Year of Use 11 NORTH OF 60 ENGINEERING LTD Index 20 Granular Resources Forecast Model User s Guide Appendix A Program License The Granular Resource Forecast Model is copyrighted by NORTH OF 60 ENGINEERING LT
14. ial Types MATERIAL DESCRIPTION Excellent quality material consisting of clean well graded structurally sound sand and gravel suitable for use as high quality e g runway or roof surfacing materials or as asphalt or concrete aggregate with a minimum of processing Good quality material generally consisting of well graded sands and gravels with limited quantities of silt This material will provide good quality base and surface coarse aggregates or structure supporting fill Production of concrete aggregates may be possible with extensive processing except where deleterious _materials are present Fair quality material consisting generally of poorly graded sands and gravels with or without substantial silt content This material will provide fair quality general fill for roads flexible foundation pads or staging areas Poor quality material consisting of silty poorly graded fine grained sand with minor gravel May also contain weak particles and deleterious materials and are considered suitable only for marginal general non structural fills Bedrock of fair to good quality felsenmeer or talus Potentially excellent sources of construction material ranging from general fill to concrete aggregate or building stone if quarried and processed Also includes erosion control materials such as rip rap or armour stone NORTH OF 60 ENGINEERING LTD Appendix D
15. mary by Block Select Dari Sel Est mele x Loe AKLAVIK INUVIK PAULATUK SACHS 400 700 3 A 9 000 1 409 543 07 900 14 83 501 312 Figure 7 Granular Resource Usage by Area Usage by Source and Quality Selecting the Quantities by Material Class button on the menu produces a cross tabulation of the database showing the historical granular usage by source and class of material In this pivot table the sources are listed by page each page is one source and the class of material along the top column NORTH OF 60 ENGINEERING LTD Analyzing Granular Usage e 17 Granular Resources Forecast Model User s Guide User Defined Analysis The pivot tables can be modified to filter the data The modifications are not permanent and will be reset the next time the application is opened Proficient knowledge of Microsoft Excel pivot tables is recommended when modifying the pivot table reports Report All Records Selecting the All Records button on the menu produces a report with table listing each permit and estimate that is entered into the database The table shows each field that is available for each record and is formatted to print on tabloid sized paper NORTH OF 60 ENGINEERING LTD Analyzing Granular Usage e 18 Granular Resources Forecast Model User s Guide Index Actual Amount 12 Actual Class 12 Actual vs Forecast 16 Add a Record 13 Add or Update Data 8 Adding Updating or Deleting Proje
16. ntfOduClibh oido ener gro abiur oen esi rase dto e D d Rod 8 3 2 Database Fields Aie wstilon a Point DER adr er rer esha EE 9 3 3 Data Management rn cene EO C rer eerte ede aa aiaiai 12 3 4 Importing LIMS Datta cccccssrstecetssnnsbessseesesnsecssnnecssenseeeesssseeeseseeeesessaesenies 14 4 Analyzing Granular Usage 14 4 1 Introduction abehataiavee 14 4 2 Demand Analysis o ooo Deep det rte p d vehe d eri Raa HE 14 Index 14 Appendix A Program License 14 Appendix B Granular Material Types 14 NORTH OF 60 ENGINEERING LTD Contents Granular Resources Forecast Model User s Guide Granular Resources Forecast Model User s Guide 1 Introduction 4 1 Background Granular resources are an important construction material in the North Historically granular material has been used in the construction of roadways airfield runways embankments to support buildings and other physical structures and in the construction of drilling pads and temporary offshore exploration structures in the shallow waters of the Beaufort Sea Granular resources gravel in the Mackenzie Delta region of the Northwest Territories are limited Much work has been done during the past quarter century to quantify the volumes and quality of the various eskers long narrow ridge of coarse gravel deposited by a stream flowing in a decaying glacial ice sheet located in the
17. region Historically management of granular resources was the responsibility of the Department of Indian and Northern Affairs Canada As part of the Inuvialuit Land settlement in 1984 however much of the granular resources in the Mackenzie Delta region are now owned by the Inuvialuit Thus management of the resource is now divided between the Department and the Inuvialuit Land Administration One of the key variables in managing the resource is the ability to forecast potential demands on an ongoing basis The Granular Resources Forecast Model provides for an efficient tool for archiving and analyzing these demands NORTH OF 60 ENGINEERING LTD Introduction e 1 Granular Resources Forecast Model User s Guide 1 2 Forecast Model Overview The primary objective of the project was to develop a Microsoft Access version of the model that will allow DIAND and the Inuvialuit Land Administration to forecast granular resource PARERE in the Western Arctic Region The broad framework for the model is shown in Figure 1 As identified above the model can focus on the past present and future It draws this information from one central data base that will contain information pertinent to granular resource usage The intent in following this approach was to provide a tool that would help the various groups forecast granular resource usage and help in the management of current granular usage Figure 1 Model Overview 1 3 Forecas
18. repared to give the following information e The version of Microsoft Access you are using e The type of hardware and operating environment you are using e The exact wording of any messages that appeared on your Screen e A description of what happened and what you were doing when the problem occurred NORTH OF 60 ENGINEERING LTD can be reached by phone fax or email Phone 403 263 2121 Fax 403 263 2122 Email support north60 com aoaaa a RN RET n RR aa NORTH OF 60 ENGINEERING LTD Introduction e 4 Granular Resources Forecast Model User s Guide 2 Getting Started 2 1 System Requirements The Granular Resource Forecast Model has been developed under Microsoft Access running on the Windows operating system To use the model you need the following minimum hardware e A Windows 98 ME 2000 XP machine with Microsoft Access 2000 2002 and Microsoft Excel 2000 2002 installed e Memory RAM requirements for Microsoft Access should be sufficient to operate the model e Disk space depends on the size of the database however database size is typically 1 or 2 megabytes A Microsoft Windows compatible printer is optional 2 2 Installing the Forecast Model The following instructions describe how to install the Granular Resource Forecast Model on your computer Although the model is not copy protected Indian and Northern Affairs Canada and the Inuvialuit Land Administration may make copies only for
19. son or company actually undertaking the quarry operations In many cases this would be the same as the permit holder A low side estimate of the amount of material to be required expressed in cubic meters A likely estimate of the amount of material to be required expressed in cubic meters A high side estimate of the amount of material to be required expressed in cubic meters Value to use in creating reports The value is calculated based on a triangular distribution defined by the low likely high estimates as described above e Mean Most Likely e Random random value each time e P50 50 probability An estimate of the required class of material 1 5 The specific classes are defined in Appendix B of the User s Guide The amount of material requested at the time of quarry permit application The class of material requested at the time of quarry permit application The actual amount of material used Generally speaking this would be based on trip tickets or an actual survey of the quarry site at the end of the project The actual class of the material used Record Navigation Buttons The record navigation buttons are used to scroll through the records on a form Figure 5 shows the typical record navigation buttons in Microsoft Access Navigating to the next or previous record is done by clicking on the arrow buttons Navigating to the first or last record is NORTH OF 60 ENGINEERING LTD Granular Usage
20. t Model Documentation The Granular Resource Forecast Model User s Guide describes the program and its underlying basis It provides basic instructions procedures and tips on how to use the tool in an effective and accurate manner The user s guide is intended for people of all experience levels The information is organized into six sections This introduction gives an overview of the contents and conventions Section 2 defines the system requirements and provides instructions to install and use the Granular Resource Forecast Model It also gives an overview of the menu structure Section 3 defines the Data Management portion of the program and Section 4 the analysis half of the program NORTH OF 60 ENGINEERING LTD Introduction e 2 Granular Resources Forecast Model User s Guide It is important to understand the terms and notation conventions in this user s guide before using the Granular Resource Forecast Model 1 4 Conventions General The word choose is used to select a menu button e Bold type in the text and procedures indicates words or characters that are typed or buttons that are selected e Bulleted e lists such as this one provide information not procedural steps e A numbered list 1 2 3 indicates a procedure with two or more sequential steps Mouse e The documentation assumes that you have configured the left mouse button as the primary mouse button Point means to position the mouse
21. the Main Menu Figure 2 The program will then present the form shown below Figure 3 Quarry Permits Form NORTH OF 60 ENGINEERING LTD Granular Usage Database 8 Granular Resources Forecast Model User s Guide Information is entered to describe the Permit in terms of when the granular material will be used an estimate of the quantity and type of material needed for the project the location of the source and the project and actual permit values requested and used f a small square button appears next to an input the button leads to more detailed information about that input such as a wizard for entering latitude and longitude coordinates or a dialog box to edit the list of permit holders etc Of particular use is the Quick List button which brings up a table listing all the permits and estimates and allows the user to quickly find permits already entered in the system Figure 4 Quarry Permit List Double clicking on a row will open that permit in the quarry permits form Right clicking on a field name will bring up a context menu that includes various sorting options to reformat the list 3 2 Database Fields For those unfamiliar with database terminology a database or table as it is often referred to is a container for data about a particular subject in this case granular resource usage There are two basic elements in a database Each category of information is called a field Thus a telephone book h
Download Pdf Manuals
Related Search