Home

User Manual - GEOSYSTEM Software

Contents

1. Current path to GDM Proiects CAPROGRA TAGEOSYSA r To Copy Client Information and Distribution List from Existing Project Select Here Project Number Client Company Select Project 2003 FC 0003 Mr Thomas Whitaker Highland School District ps Always copy client information from this project Copy distribution list too r To Copy Misc Report Data and Specifications from Existing Project Select Here Project Number Client Company ssi 003 24 Harold Jenkins Advanced Professional Eng Always copy misc report data and test standards from this project Options Project View C Company View Figure 22 Adding a New Project 1 Creating a new blank project Enter the new project number in the textbox at the top of the dialog Begin using the new project by clicking OK to return to the QC Concrete main screen and select the project from the project listbox 2 Importing a GEOSYSTEM Data Manager project Select from the list of existing GDM projects the project to be added to QC Concrete The list of projects are those found in the folder named as the Current path to GDM Projects To change the location where GDM projects are found click on the Browse button Then select the drive or network location to use and the folder to use In both cases you have several options which can save you time by filling in some of the Project Data e Using another project
2. r Break List Input T able r Results for specimen 123 1 2 4 Cast cylinder L b jura Diameter N N A Area 1231225 isi 6 00 EN END 276 1231 433 1234 4 4 Type of 1231455 L N Fracture N Strength 1231 54 123155 EN c KEMM r Properties for specimen 123 1 2 4 Cast cylinder PROJECT NUMBER 531003 24 Prior breaks Age Strength Average 28 day strength SET NUMBER 1 1 7 2685 DATE SAMPLED 2 28 2003 2 7 3465 Age 28 3 28 Date broken 3 28 2003 4 28 Required Strength 4000 5 28 Slump 5 5 B Pass Fail results for 91003 24 1 Passed Failed V NotApplicable Acceptable under ACI 318 override required strength specification Figure 31 Entering Break List Data Enter the peak loads in succession If dimensions have not previously been entered default values will be filled in for them and the strength calculated The type of fracture also has a default value Set these default values by clicking on the Set Default Values button Other data which can be entered are the Fracture Type and for beams the break notes If a strength is calculated that is less than the required strength less than a younger specimen from the same set or a 7 day break is less than a prescribed percentage of the 28 day design strength a message alarm will appear Set the percentage of the 28 day strength that triggers the alarm by clicking o
3. Fort Collins Zoo Primat Figure 65 Heading of Project Report PROJECT2 PRP 68 QC Concrete Reference Manual cement products Reporte oix yg oh a l Project list Project Client Company Number Mr Crawford O Neil Lofton Development 2003 FC 0001 Permimen Architecturmermedy Space Center i003 FC 0002 Figure 66 Heading of Project Report PROJECT3 PRP Eix yd w b Qi Client list 104403 Client Address Address Advanced Professional Eng 2362 West Drake Suite 10 Fort Collins CO 0526 Advanced Professional Eng 363 West Drake Suite 10 MORE ADDRESS AND MORE AN Figure 67 Heading of Project Report PROJECT4 PRP fv eee Products Report i qa 1A a i Cliert list 101403 Qient Number Address Addess dvanced Professiona DOD AAA NAG West Drake Suite 10 Fort Collins CO 0526 amp dvanced Professiona DOD AKA NN63 West Drake Suite 10 MORE ADDRESS AND MORE Figure 68 Heading of Project Report PROJECTS PRP 6 6 Printing Addresses QC Concrete can print envelopes or labels for all or part of the distribution list for a single report or envelopes for a set of reports Printing envelopes for a set of reports is a recent addition to the program as was not integrated with the old single report envelope and label printing routine discussed here For information about printing envelopes for a set of reports refer to Section 6 1 5 for additional information To print labels or envelopes for
4. i i i 4 HHE t M H Pap Vez Pap etd Figure 49 Format BRKLISTS includes Project Figure 50 Format BRKLIST6 includes Required Strength di Oam Ul For af apri nm a FCR No Cnmmbunw On Qr Jon du on Fridag March 2h SOE EIL oe wwe ef er Lis mar a Figure 51 Format BRKLIST7 shows Job No and Figure 52 Format BRKLISTS shows a Comment Report No For more information see Section 3 4 61 Printing Reports 6 3 Testing Summaries Testing Summary Reports print information about every specimen that meets the selection criteria Select Reports Testing Summaries to print a report summarizing test results A wide variety of selection criteria are available to control which specimens are printed A form for choosing selection criteria is displayed when this option is selected An example of this form is shown in the following figure Summary Report Settings Category of Test Selection Criteria Date Criteria Date Criteria Starting 1 01 2006 Ending 01 31 2006 Project Mix and Test Type Criteria Lab Test Criteria DatePlaced C Date Broken Field Test Criteria Sorting Criteria re Project Report Number then Specimen Number C Specimen Number Sort Specimen Numerically Test Selection Criteria Summary Test Type All Date placed starting date is 01 01 2006 Date placed end
5. Mix Number Design Strength 1 Design Age 1 Design Strength 2 Design Age 2 co Design Strength 3 Design Age 3 c Primary Design Age co co n2 c ow rm B J n3 e e e e ce ce ce ce t ce a a a E raj P D o lt kul Supplier Supplier 2 z Mix Tools Update Tests and Breaks Print Current Mix Print Mixes for Selected Projects Add New Pick Format Select Projects Figure 33 Mix Information Form What should be done with the Mix Database Any frequently referenced mixes should have their specifications entered here Only the Mix Number Design Strength 1 Design Age 1 and the Principle Design Age are required by the basic report forms provided with the program However you should include any other information relevant to your custom report format QC Concrete Mix management options are discussed in the following sections Note Users with custom forms may have the titles of the mix database fields customized to correlate better with the custom form In these title need to be customized contact VES to have it done 47 Managing Mix Information 5 1 Mix Tools Update Tests and Breaks When a change is made to a mix that is used by more than one test the user should always click on UpdateTests and Breaks to scan the entire database for instances of this particular mix and update the dependent information This is critical if the change involves a required strength
6. When this is selected the selection section of the data entry screen looks like the following example PROJECT NUMBER PLACEMENT DATE TEST NUMBER TEST TYPE FOR THIS REPORT 2003 Fc 0005 Joryoz 2003 1 Cast cylinder si Figure 74 Test Selection Panel When Dates Are Used 9 10 Report Data and Standards Titles Report data are those bits of information on reports like the supervisor s name which don t change from report to report Standards likewise are the references to ASTM or AASHTO procedures which are usually included on reports These don t change from report to report for a given test type either They may however on occasion need to be changed to provide for flexibility on custom reports There are 16 of these items for Report Data and 16 for Standards The titles for these items on the left in the Figure 75 below can be changed See Sections 6 1 7 and 6 1 8 for information about how to use Report Data and Specifications Please note that changes to these titles do not appear on the printed report form Only changes to the data entered beside the titles are seen on the report form The field titles on report templates are factory configured and can be customized by GEOSYSTEM upon request on a fee basis Contact us if you are interested in custom forms with different titles for Report Data items 9 10 1 Selecting the Report Data Titles to be Used With a Test Type Changes are made to the Report Data Titles on the Rep
7. Specifications generally don t change from report to report but they can easily be changed prior to printing any particular report The program keeps a set of default standards specific to that project To change a value select Reports Misc Project Data Test Standards for this Project the program will display the Test Standards form 57 Printing Reports Standards for Cast cylinder for 2003 FC 0002 e Field Test Conditions and Results MASHTO T 23 ab Test Results center point AASHTO T 177 Y B 3 Sampling Fresh Concrete amp ASHTO T 141 sa a a ee aT RSTO Te JEEEEEEEEEEEEEEN 3 3 Standard v 10 Standard n z u k z i z lo Lows Figure 43 Setting a Project s Standards Select from values previously entered or enter a new value Some tips when working with Test Standards are New values entered become the default value for that Project and Test Type e To edit a value select it then make the changes When finished hit Enter and you will be prompted to press Y to replace the original data with the edited version or to press N to add the changes as a new value To abandon all changes click on Cancel e To remove an item in one of the Report Data lists select the entry to be deleted then press F5 It will be blanked out not deleted to preserve the position of the other entries To delete typing that hasn t yet been added to a
8. Automatically increment 10 Average Test Strength 12 Averaging strengths 42 B Backing up the Database 80 Beams 20 Blue color title 11 Break list of all specimens 23 Break data table 38 Break list 23 58 Break list report format 23 Break Table 19 Break Table Notes 20 Breaks adding 38 By counter 10 By project 10 Calculation component 21 Calculation result 21 Calculations 41 Checkbox group 18 Checkboxes 18 Colors 24 Concrete Performance Report 77 Confirm replace 74 Confirmation Prompts 13 Index 108 Copying Client Project Data 32 Copying Report Data and Standards 33 Correction factors 41 CPR 77 Creating a Project Template 33 Creating PDF files 51 D Daily Test Report for Concrete 91 Data entry prompts 17 Data entry screen settings 26 Data logging equipment 103 Database location 81 Database Maintenance 80 Date fields 37 Date formats 25 Dates in Test Selection 82 Dates prior to Jan 1 2000 25 Default checkbox 18 Default Fracture Type 13 42 Design Age field 38 Disable data entry for calculated fields 26 Distribution list 22 69 Distribution List Options 22 Dropdown list 42 DTR 91 DTR2CQC PRG 91 DTRC 91 Duplicate specimen warning 12 During data entry copy dates to blank date fields 26 E E mail 71 Entering Break Data 39 42 Entering Break Data from a Break List 42 Entering Project Data 34 Envelopes 53 69 Equation for cal
9. More Placement Placement Method Supplier More Supplier Contractor Truck Number Ticket Number Load Number Plant Number Time Batched Time Sampled Time in Mixer Mix Number Design Age Design Strength Material Time Placed Sampled By Nominal Size Number of Specimens Batch Size Water Added Admixtures Admixtures Slump Air Content Concrete Temp Ambient Temp Field Cure High Field Cure Low Unit Weight Yield Curing Method Field Cure Days Weather Remarks Remarks Remarks Remarks Average 28 Day Strength Check Box 0 Check Box 1 Check Box 2 Check Box 3 Check Box 4 Check Box 5 Check Box 6 Check Box 7 Check Box 8 Check Box 9 Figure 26 Field Data Items as Defined for Cast Cylinders Note These items can be renamed so they may be different than those displayed when running the program Note To display only the Field Data select Tools View Break Data or click the o button The Break Data will disappear This makes it easier to see all the fields being used 35 Data Entry 4 4 1 Selecting Tests How tests are selected depends on whether dates are used in test identification see Section 3 2 1 If dates are used first select the date from the Placement Date list Then select the test in the Report Number list 1 Select the Placement Date if used Click on the down arrow in the Placement Date combo box and click on the Placement Date needed Or you can type in the Placement Date there and i
10. Visible All break data fields needed for the report or calculations should be visible Insert default fracture type Check this box for the column that should receive the default fracture type The value of the default fracture type is set elsewhere see paragraph 3 2 13 for additional information 20 QC Concrete Reference Manual Dropdown list One of the break table columns can have a dropdown list Check this box for the column that should display it Setting and changing the contents of the dropdown list are described above Minimum column width When automatic column widths are enabled setting this to some amount prevents the column from being set narrower than that amount When automatic column widths are not enabled this is unavailable Calculation result If the field contains the result of a calculation it is selected using this list box Calculation component If the field contains a component used in a calculation it is selected using this list box e Numeric format Pick from the list of numeric formats to use when the data entered for the column is displayed or more importantly when calculated results are displayed Equation for calculation If the field contains the result of a calculation the equation used is shown here Cannot be edited for reference only e Title lines 1 4 The column titles displayed during input If less than 4 title lines are enabled it is because of the setting for Number
11. You can save time by selecting repetitively entered data from a local submenu Right click twice ona data entry field and a submenu will appear That will bring up a list of 4 choices Date and 3 user 37 Data Entry defined categories Click on the category you want and 10 user defined selections will appear Select the item or items needed each one selected will be added to the existing data If you select highlight the existing data first then QuickData will replace it instead of appending to it To set up QuickData fields go to Reports gt Misc Project Data gt Report Data for this Project The last 3 Report Data lists are used to store the QuickData choices For more information about setting up QuickData lists see Section 6 1 7 e Checkbox fields Information which is best conveyed as Yes or No can be entered and displayed as Checkboxes Examples of this type of information are Were the specimens field or lab cured and Was a hi lo thermometer used in the cure box Clicking on the box beside the prompt puts a checkbox in it or removes it Checkboxes can be defined in groups where only one can be true at a time When a Checkbox in a group is checked all others in that group become unchecked For more information about setting up Checkboxes see Section 3 3 5 Design Age field The age entered as the design age will be the age of specimen used for the average test result calculation Pick mixes from mix database When enter
12. r Distribution List Options __________ Setup Distribution List Map Print a report for each name on the distribution list Put distribution list addresses on reports Figure 10 Report Setup Tab in Program Options 2 Click on one of the test types in the listbox on the left 3 Click on the dropdown arrow on the combo box and pick the custom template for that test type from the templates listed 4 Repeat for all the test types that have custom templates Since the length of specimen numbers varies from company to company there is an option to change the justification of the specimen numbers on reports This is the only user configurable report option If your specimen numbers are too far to the right on reports selecting centered or left justification can make them look better 3 3 2 Setup for PDF File Creation Each QC Concrete project can be designated to print to the printer or print to a PDF disc file Reports printed to PDF files can be e mailed as e mail attachments and viewed by the recipient by using the Adobe Acrobat Reader To set up a project to print its reports to PDF files go to Tools Options Report Setup and in the PDF Setup frame click on the Setup Now button Scroll through the projects and click on the project desired The currently 15 User Preferences selected PDF folder for that project if any is shown If the folder cannot be found a message THIS PATH DOES NOT EXIST is displayed Inval
13. s client project data When starting a new project you can have the program copy the data from an existing project The fields copied are 32 QC Concrete Reference Manual CLIENT usually client s name CCOMP usually the client s company name CADDR CADDR2 CADDR3 CADDR4 usually the client s address PROJECT PROJECT2 PROJECT3 PROJECT4 usually the project name PROJ_NUM the project number CONT_NUM usually the contract number CONTRACTOR usually the project contractor s name FIELD_ENG usually the field engineer e Todo so click on the Select Project button A list of existing projects will be displayed similar to the following example Select a Project 2003 FC 0001 Mr Crawford O Neil Lofton Development 2003 FC 0002 Pennimen Architecture Kennedy Space Center 2003 FC 0003 Mr Thomas Whitaker Highland School District 2003 FC 0004 Ms Jen Franciola Patterson Tool and Die 2003 FC 0005 Mr Jackson Schwartz City of Sipes Creek 2003 FC 0006 Geenwald Construction Ten Mile Medical Center 2003 FC 0007 Ms Teresa Knight Knight amp Dayton 2003 FC 0008 Ms Kelly Dayton Knight and Dayton 2nna En nnna K aliaba D au baron Chandler Accnciatas Cancel Figure 23 Selecting a Project to Repeat Project Data From e Always use this project If all of your work is done for the same client check the box labeled Always copy client information from this project e Copy distribution list too Additionally if the distri
14. 1 Installation Note If you are updating to Version 2 from Version follow the directions in Appendix C Before installing consider how many users the program will have who the main user will be and how your computer system is maintained Install it according to one of the following sets of directions depending on which one fits your situation the best 1 1 1 Network Server with Users at Workstations One of the most common computer configurations is to have a server with users at individual workstations In this case it is recommended that the software be installed only on the server Users may then start the program from any workstation that has permission to access QC Concrete Some of the program s preference settings will apply only to that workstation some will be universal to all users Follow the installation instructions in Section 1 1 4 and install on your server for this type of configuration 1 1 2 Peer to peer Network with Users at Workstations Another common computer configuration is to have a group of computers interconnected with no designated server and with users at individual workstations In this case it is recommended that the software be installed only on the computer where it will primarily be used as it will run the fastest on the computer it is installed on Users may then start the program from any workstation that has permission to access QC Concrete Some of the program s preference settings will apply only to that w
15. Suggest the most likely value for first specimen number on a new report 10 Summary report formats 66 T Test and Specimen Number Options 9 Test standards 57 Test types 13 37 Test Types Handled 6 Testing summary reports 62 Testing Summary Reports 110 Selection Criteria 62 Tests Adding 35 Editing 35 U Unique specimen numbers 12 Updating from Version 1 99 VPI 91 Warning Colors 39 V W QC Concrete Reference Manual 111
16. This operation may be slow so only use it if calculated values are dependent on the changed value Adding New Mixes Enter a new Mix ID in the Mix Number field or click on Add New in the Mix Tools frame Deleting Mixes Select the mix to delete then click on Delete Renaming Mixes Select the mix to rename then click on Rename and enter the new name This will find all the reports with the old mix number and change them to the new mix numb er as well 5 2 Mix Reports Print Current Mix Reports listing the information for a particular mix can be printed in two formats Examples of these are shown below Osiris LIESS ETE an oe Grut Figure 34 Format MIX1 Figure 35 Format MIX2 Select the format to be used by clicking the Pick Format Select Reports button Select the template using the dropdown list at the top of the form See Figure 37 Print Mixes for Selected Projects Reports listing the mixes used on a specific project projects can be printed The report will use as many pages as needed to include all of the mixes An example is shown below 48 QC Concrete Reference Manual moacr wore Peron PRESET MUR GER rone PORCI Tass dubiis Zee Pebnans Babine 3 ROE o POO EGET eRe erm H mtt AMT tuues wo eae OTe MIC COMPORGNTS t MCI NPER Wm DER ES amar TER e p D sen MET COMMU ETE ili COMPORPST s Figure 36 Example Report of a Project s Mixes
17. To print a report or reports select Reports Print Test Reports All Reports meeting the Report Selection criteria will be printed If a test has more breaks than the report template was designed for it will print a second report or more until all that report s breaks are printed Reports for projects that have the PDF file storage location set will not print at the printer Instead an Adobe Acrobat format PDF file will be created and saved at the location chosen for that project See Section 3 32 for additional information about setting up PDF storage folders for projects The file names are created using the Project Number Report Number and current date As an example the PDF file name 2003 FC 0005 1 10 01 03 PDF is from project 2003 FC 0005 report number 1 printed on 10 1 03 Note Each of the test types uses a specific report format Information about changing the report formats is in Section 3 3 1 6 1 5 Printing Envelopes Following Test Reports One of the methods for printing envelopes is to print an envelope for each report each project or all reports and entries on the distribution list To enable this method check the box on the report selection screen to Include option to print envelopes following reports See Section 6 1 3 After the reports are printed the following form will appear Envelope Printing loj xl Prepare printer to print 18 envelopes Click OK to start Postpone to save address list for later printing
18. To select which projects to report click on the Pick Format Select Reports button Then select projects from the project list An example of the form used to select projects is shown below fe MixRepor Setup ST m Name of template to be used for mix reports MIX1 MRP MIX1 MRF mix report si r Select projects for Project Mix Report All Projects Selected projects 2003 FC 0001 2003 FC 0002 2003 FC 0010 sl Type project number or scroll to locate Press Double Click to remove Enter or Double Click to select Figure 37 Selecting Mix Report Templates and Projects for Project Mix Report 49 Managing Mix Information Se ee ee ss SSS SEE 50 QC Concrete Reference Manual Section 6 Printing Reports There are 5 categories of reports which QC Concrete prints These are 1 Test Reports The main type of report for submittal to clients 2 Break Lists List all specimens scheduled to be broken on a specific day 3 Testing Summaries Reports which summarize all breaks which meet certain criteria 4 Mix Reports The specifications for a specific mix or all mixes on a project projects 5 Project Reports Lists all active projects and pertinent information 6 Addresses Not really a report but a printing option covered in this section This chapter explains selecting previewing printing and creating PDF files for these reports 6 1 Test Reports Test reports are the main report printed by the progr
19. Von Gunten Engineering Software Inc VES Inc liable for any harm damages claims losses or expenses arising out of any act or occurrence related in any way to the use of the program 3 The program is warranted to fully perform the tasks described in the program documentation All results of the operation of the program are subject to the further engineering judgment prudence and study of the user 4 If the program does not perform as described VES Inc will replace the program with one that does at no charge during the first year after licensing In no event will VES Inc be liable for any monetary compensation to the licensee Software usage is implicit agreement to these terms 5 One year of free consultation and updates is included with the program In subsequent years updates will be available for a fee at the user s option initial publication 9 2 2003 revised 10 6 2003 revised 8 23 2004 revised 11 29 2004 revised 1 11 2005 revised 8 31 2006 revised 9 25 2006 revised 10 16 2006 revised 1 23 2007 QUALITY CONTROL CONCRETE Ver 2 TABLE OF CONTENTS SECTION 1 QUICK START GUIDE 1 1 INSTALLATION 2 e tte A e SR EE Ede be bs te e wise pvc ae e UH Cok ete ee ur ede ee lea PE P ede 1 1 1 1 Network Server with Users at Workstations 1 1 2 Peer to peer Network with Users at Workstations 1 1 3 Standalone Workstation 1 1 4 Installation Steps rroen C e ERETRIA EEKE OE anette ax e 1 2 RUNNING QC C
20. Windows XP you should re boot when suggested by the installer 1 2 Running QC CONCRETE and First Time Setup If during installation you chose to have a shortcut placed on your desktop double click on it to start the program Using the start menu choose Start Programs GEOSYSTEM QC Concrete or other Program Group that you may have chosen to run the program When the opening screen appears you can begin to get acquainted with the software The first time you run the program choose Help gt Contents and peruse the topics just to let you know what help is available These quick start directions are very brief you will find the program s help system valuable in answering questions If you don t find what you want under a help topic check the table of contents and index of the manual to locate additional details It is useful to get set some preferences set so select Tools Options then 1 Both of the Automatically increment options should be unchecked just to simplify things at the start 2 If your company identifies tests with numbers only select the option to sort numerically If they are alphanumeric turning this off will cause the sort to be alphabetical 3 Choose the Report Setup tab and you ll see the 13 test types handled by QC Concrete If you have custom report formats they should already be selected If they are not select them to replace the corresponding BASIC report formats They are all numbered to make it easy R
21. a single report select Reports gt Print Addresses to display the address selection screen see the figure below 69 Printing Reports Print Addresses Distribution List IV Cage Construction Iv Jungle Jazz Architects IV Newt Holdings lV Major Mix ml kul ag al IV City of Fort Collins Select All Clear Al Address of Selected Recipient Harold Jenkins Advanced Professional Eng 363 West Drake Suite 10 Fort Collins CO 80526 PrintLabels Print Envelopes Figure 69 Envelope and Label Printing of Addresses Check the recipients which should be included or Select All If there is no data for the recipient you will not be able to check it Click on the radio button for either Print Labels or Print Envelopes Some notes about these two options follows e Printing envelopes The only envelope printing technique currently supported is landscape printing on a laser printer e Printing labels The only label printing technique currently supported is on 30 labels per sheet size laser printer labels The program will print all the addresses selected and then start over continuing until 30 addresses have been printed If you are printing 10 6 5 3 2 or 1 addresses an even number of sets will be printed on one sheet of labels Otherwise the last set printed will be incomplete 6 7 Printer Setup The Printer Settings window is opened by selecting Reports Printer Settings It displa
22. all Test Types not just specific Test Types Settings which are Test Type specific are in the Report Setup section Select Tools Options and click on the Screen Layout tab to access these options 3 6 1 Data Entry Screen Settings Disable automatic sizing of break table columns QC Concrete will adjust the widths of the break table columns automatically It may be preferable to set them to fixed widths that don t change To do so check this box Disable data entry for calculated fields To have the cursor automatically skip over fields in the Break Data Table which have automatically calculated results check this option During data entry copy dates to blank date fields On the data entry screen there are typically 3 dates to be entered the Date Submitted Date Sampled and sometimes the Date Placed To expedite data entry these three can be set to automatically be filled in Check this box to do so 26 QC Concrete Reference Manual Recalculate break table strengths upon display The program recalculates a break strength anytime data used to calculate the strength changes But if the rounding method for strength is changed such as nearest 5 to nearest 10 having this option selected will update all strengths for a report as soon as the report is displayed e Sort break table by specimen number The break table displays the specimens in the same order that they were entered in To change it to show them in alphabetic order cl
23. an advisory message Ordinarily you will just else on your network click OK and join the other user If there is no one else using the program and you get this Click OK to join the other user message then you should list all users and correct errors Click Cancel to Exit if you do not wish to join a multi in the user list after the program starts using user session Administrator Tools Note You can list all users and correct errors in the user list after the program starts using Administrator Tools QC Concrete can t find data folder name because the A mapped network drive letter may have been drive is not ready Click OK to switch to program folder disconnected name or Cancel to Quit and reconnect the drive for data folder name QC Concrete can t find data folder name It may have The database was not found where it had been the last been deleted Click OK to switch to program folder time QC Concrete was run Return the database to its name or Cancel to Quit and re establish the existence of previous location then allow the program to move it to a data folder name new location QC Concrete can t find database name Click OK to The database was either moved deleted or corrupted If browse for a database location or Cancel to Quit and you know it was moved click OK and browse to the new troubleshoot alleged database location location If there has been no change to the best of your knowledge click Cancel and na
24. and traditions associated with cement products testing It also accommo dates some preferences which individual users may have These settings are identified on the various options tabs by the term Local These settings are effective only on the workstation they are set at This section is intended to assist you in setting up the program to most nearly fit your reporting needs and personal interface preferences To set program preferences you select Tools Options 3 2 Options on the General Tab The options form has 5 tabs each with options for a particular aspect of the program Its general appearance is as shown below options Beneral Report Setup Break Lists Setup Colors Dates and Fonts Screen Layout Test and Specimen Number Options Automatically increment test numbers Vv Automatically increment specimen numbers mi Suggest most likely value for first specimen number on a new report By project By counter T The test number selection box can be sorted numerically Check this box to do so Vv Give reports New Test status if a specimen load is added or changed lm Calculate the average test strength Iv If specimen number is not unique in the entire database Warm Prevent D If specimen number is not unique in the report Wam Prevent Use checkboxes 0 1 2 and 3 for reporting required strength compliance mi Warn if a report has no specimens Li Check this box to turn off
25. and the fields did not match up well archive the project to a junk database see Section 7 2 for how to do this adjust the field map then import again Option to Add Sample Date When importing data from a DTRC database the old GEOSYSTEM Concrete program there is usually nothing to transfer into the Sample Date field This is because the DTRC database Sample Date is inserted as the QC Concrete Placement Date unless there is an actual DTRC Placement Date field Most DTRC databases do not have a Placement Date field You may wish to have the DTRC database Sample Date inserted as the QC Concrete Sample Date as well If this option is NOT selected QC Concrete will import the DTRC Sample Date only as the QC Concrete Placement Date and will leave the QC Concrete Sample Date empty Select this option in most cases When wouldn t you want this selected Only if you have a lot of DTRC tests which were sampled after they were placed like cored or sawed specimens For these the DTRC Sample Date is not the same as the QC Concrete Sample Date and to have the DTRC Sample Date automatically inserted would give you incorrect values for Sample Date for those tests When the maps look OK select Start Conversion If the Start Conversion button is not available no project has been selected Note The import process will change QC Concrete to the Test Numbers Start Over Every Day mode of operation It does this because that is how most DTRC users were
26. blank date encountered Use the required date format Windows is unable to read drive drive letter Make sure the drive door is closed and the disk is formatted and free of errors Your printer driver cannot provide required information Update your Windows printer driver The best fix is to get current drivers from the company s web site or from your dealer 10 2 Minimizing Downtime Every effort has been made to make this software as reliable as possible however errors will occur To minimize downtime always call when an error occurs We frequently update this software usually based on information we get from our customers Also back up your database daily in the unlikely event of a catastrophic failure your database is the only thing that cannot be restored by us It is an even better idea to back up the entire QC Concrete program folder so if any updates revisions have been added that are not on your original program CD they can be restored Talk to your office computer experts about establishing backup procedures They are the best precaution against significant downtime and if implemented and automated correctly will not take any of your time Refer to section 9 5 for more information about how and what to back up 89 Troubleshooting SS mm QC Concrete Reference Manual Appendix A Importing Tests from the GEOSYSTEM Daily Test Report for Concrete program QC Concrete can import data from ol
27. but rarely changes Sample Date The date the sample was taken is the Sample Data Related terms are Placement Date Cast Date and Submitted Date Selecting Report The process of choosing some Project Number and Test Number and it some cases the Placement Date to uniquely identify a particular test is Selecting a Report Shortcut Keys Keystrokes which take the place of longer menu selections are Shortcut Keys Special Characters and Symbols Special Characters and Symbols are for characters like fractions 14 and the degree symbol Standard Formats Any of the report formats which are supplied to all licensees of the software are Standard Formats Submitted Date The Submitted Date is the date sample was delivered to the laboratory by others Related terms are Placement Date Cast Date and Sample Date Test Standards The ASTM AASHTO ACI or UBC codes pertaining to a particular test are Test Standards Testing Summary Reports Reports with a few major results from a collection of tests summarized in a table are Testing Summary Reports 98 C 1 QC Concrete Reference Manual Appendix C Upgrading to Ver 2 from Ver 1 Installation Updating from version 1 to version 2 is done using the master version 2 CD To do so follow these steps Update to the most current release of version 1 of QC Concrete To do so go to WWNW GEOSYSTEMSOFTWARE COM and click on the Program Updates Concrete Break link Follow the directions there Then run QC C
28. for some reason If you need to back up your database click Cancel Refer to Section 9 8 for information about backing up your database No If you would like to work with the demo database and the new program before using your main database select No Your main database must not be in the program folder to have this option work Move it to a different location before clicking No Yes To proceed with the database update click Yes C 2 2 Version 1 to Version 2 Database Update If you selected Yes in the previous step the program will display the message 100 QC Concrete Reference Manual 4 database update is required by the new version of CQC CP which you just received When the update is complete restart CQC CP Figure 77 Message that a Database Update is Required You can cancel the database update at this point as you could at and for the reasons described in the previous step When you click OK to proceed the database and your screen layout forms which are closely tied to the database structure will be updated The update progress is displayed on a screen like the following Current database version New database version Modifying database tables 100 The database modifications are complete COC CP must be restarted for the changes to take effect Click OK to Exit then restart COC CP Figure 78 Database Update Progress Display When both progress bars have reached 100 click on OK and then resta
29. for which they are appropriate There is also a set of templates which converts data entered in US units to Metric units on the reports These are the USMET templates 14 QC Concrete Reference Manual 3 3 1 Selecting a Template to be Used with a Test Type Why would you need to change the template being used You won t unless you receive some custom forms If you do copy them to the program folder if you don t know where it is click on Help gt About QC Concrete The path to the program folder is listed there After copying do the following 1 Select Tools gt Options and click on the Report Setup tab The form will look like the following example General Break Lists Setup Colors Dates and Fonts Screen Layout Pick Report Template Report template to be used with Cast cylinder test types 1 pem 1 3 C78 BASICO CRP basic 5x12 report format 2 Beam ctr C 293 3 Mortar cube C 109 Specimen number justification for reports Default 4 Grout prism C 1019 5 Cored cylinder 6 Sawed beam C 78 r Data entry settings to be used with Cast cylinder test types 7 Sawed beam C 293 RepotDataTiles 8 Grout cube C 942 Fagor Dc Ter 3 Mortar cylinder C 780 10 Grout cylinder C 38 A l 11 Masonry block prism C 1314 sl V Uncheck for logo resizing compatible with older custom templates r Report Printing Sequence PDF Setup According to project number then report number X
30. form If the list includes names of users who are not actually active then they somehow closed their last session with the program without having their name removed from the list That probably indicates a program crash occurred and you should notify us about it Note To remove a user s name from the list when they should not be on it right click on the name and select Delete 79 Administrator Tools 9 2 Database Statistics The QC Concrete database is a group of 4 databases called Tables The 4 tables are listed on the Administrator Tools form To determine the number of records in each table the program must open each table then move to the last record which may take a few moments depending on the size of the database Click on Count Records to run the record count 9 3 Last Specimen Number Used When the option to have QC Concrete suggest the next specimen number based on the specimen number counter is used the last specimen number is displayed here It can also be changed here Click on Edit to initially set or change the value of the last specimen number used See section 3 2 3 for more information about options for QC Concrete automatic specimen numbering 9 4 Importing from DTRC QC Concrete can import data from old DOS Version GEOSYSTEM Daily Test Report for Concrete DTRC databases The import process involves 2 procedures one with DTRC the other with QC Concrete These procedures are described in Appendix A 9 5 D
31. fracture types It will automatically be entered as soon as a strength is calculated by the program To disable this feature go to Tools Options and find the selection on the General tab To force the fracture type to be blank enter a blank space Picking a Fracture Type from a List If you know how a cylinder fractured but forget which letter is which right click on the fracture type field to display a sub menu that lists the fracture types Click on one of the fracture types listed to have it inserted for you 4 5 12 Using Drop Down Data Lists in the Break Table Certain custom report forms are set up to use one of the break table fields for an extensive note such as B The 7 day result projects that the specified strength will likely be met at 28 days according to a typical strength age relationship 7 days To save the time of typing such a note repeatedly they can be stored in a dropdown list see Section 3 3 6 1 for more details This option is used primarily with custom forms 4 5 13 Entering Break Data from a Break List There is an easy way to enter break results that have been recorded on a break list printed by QC Concrete Select the option Edit gt Enter Breaks from a Break List click the Enter Break List Breaks button or press Ctrl B Any of these actions will bring up the data entry screen illustrated in Figure 31 42 QC Concrete Reference Manual Enter Results From Break List for 3 28 2003 P
32. is created for a project that does not have a PDF Storage Folder set for it yet you must use a save dialog to pick a destination location for the PDF If you would like the program can offer to make the chosen folder the PDF folder If you will never use that option you can choose to disable it 16 QC Concrete Reference Manual 3 3 4 Changing the Data Entry Prompts Active Fields The main set of data entry prompts is configurable Rarely will you need to make any changes here but since each of the program s test types needs a particular set of data entry prompts and since these prompts may be different for users of customized report forms they may be changed The form used to change data entry prompts is shown in the following figure Report Name and Type CHECKSU CARP Cest cylinder Note To charge the appearance al repeats contact Von Gunien Engneenng INACTIVE FIELDS ACTIVE FIELDS 3 I ur Field Eng jProjeci Ling Z s Copy to 7 Omni Copy to sider 7 jeddess 1 Copy ta sddrecs 7 Adctess 2 Copy tn sd dress gt Atenhon Copy ta ed dress 7 Date Samolect Day to Sample Local Copy tn address B ISarph Location 2 Copy to address B Ssrpkd By Copy to sider Concrete Supplier Copy ta address 8 Truck Na Copy to Ticket No Copy to address 9 zj IMa Deagn Maria xj Selected Inactive Field Details Selected Active Fed Details Tik Conrac Hunter Tite Froject Database Field Hare CONT NUM Database Fil
33. list just select the typing and press Del Note The titles of these data fields can be changed so they may not look like this example To change the titles refer to Section 9 10 2 6 2 Break Lists Click on the Break List button m or select Reports Break List to print a list of specimens due to be broken on a specific day All the specimens scheduled for testing that day will be printed on a list There are several user options to define what it means for a specimen to be scheduled The following sections discuss procedures related to Break Lists 58 QC Concrete Reference Manual 6 2 1 Defining a Scheduled Specimen A scheduled specimen may be defined as e All unbroken specimens up to and including the break date Unbroken and prematurely broken specimens for the exact break date e Only unbroken specimens for the exact break date Select your preference using Tools gt Options then select the Other Reports tab More information is in Section 3 4 6 2 2 Picking a Date for the Break List Pick a day from the choices offered before printing The form for picking dates for the break list looks like Figure 44 Break List Setup Generate Break List For C Yesterday 08 07 2003 X Today 0870872003 C Tomorrow 08 09 2003 C 2Days hence 08 10 2003 C Other Date 08 11 2003 C Other Date 4 days from now 08 12 2003 Figure 44 Selecting the Date for the Break List The list will be shown as a screen preview automatica
34. not any of the Break Data Click on the little compression testing machine to turn off the Break Data table display eas Click on it again to show the Break Data again Another way to do the same thing is to select Tools gt View gt Break Data to show or hide the Break Data section e Likewise when entering Break Data it may be preferred to simply view the Break Data table and not any of the Field Data Click on the little drum mixer truck to turn off the Field Data display Click on it again to again show the Field data Another way to do the same thing is to select Tools gt View gt Field Data to show or hide the Field Test Data section e The portion of the screen covered by the Field Test Data and the Break Data can be adjusted Click on the tool buttons 3 to change the sizes 4 2 Editing Existing Tests To edit a test that has already been entered select the test by picking the Project and Test Number and optionally the Test Date Either enter the data in the appropriate selection box it will seek to the closest match or use the dropdown arrow to display all Projects Tests and Test Dates The selection section will appear like one of the following TEST NUMBER TEST TYPE FOR THIS REPORT NUMBER 1 Cast cylinder PROJECT NUMBER PLACEMENT DATE TEST NUMBER TEST TYPE FOR THIS REPORT feoozFcoos MM 01 02 2003 1 Cast cylinder Figure 20 Selecting Tests When Using Dates For more information about
35. or Cancel to skip printing v Pauseevery 5 envelopes IV Print only one envelope per project IV Print envelopes for distribution list Figure 39 Envelope Printing Options Form The program is set up for printing on standard 92 x 414 envelopes run through the left side of a laser printer but can be modified for other sizes just let GEOSYSTEM Software know what you need There are several checkbox options when printing envelope sets Pause every XX envelopes When selected the program will pause each time a certain number of envelopes have been printed Any number between 1 and 20 can be chosen using the More and Less buttons Otherwise all envelopes will be printed at once Print only one envelope per project If all reports for a given project name on distribution list can be stuffed into a single envelope select this to reduce the number of envelopes used Print envelopes for distribution list For projects with a distribution list you can have envelopes printed for them as well Note You should not select this if you printed reports for the distribution list only if you did not See Section 6 1 3 for information about printing reports for the distribution 53 Printing Reports list Another option is to Postpone printing envelopes until later Choosing that option causes the program to save the current list of addresses in a text file for later recall and printing The file has the name _EnvList2_MM DD YY
36. red Option now available to display failing breaks in red Described in Section 3 3 6 1 e Break table colors The break table can now be set up to display alternating rows in different colors Described in Section 3 6 1 e Duplicate dimensions from previous specimen in break table The break table can now be set up to duplicate the dimensions entered for the previous specimen Described in Section 3 3 6 1 e Order of break table columns The columns in the break table can now be rearranged One handy use for this is to make them appear in the same order as they do on the final report Described in Section 3 3 6 2 e Individual user preferences Individual users on a network installation can pick colors fonts and several other preferences without affecting all users Described in Section 3 1 e New toolbar button for New Projects Clicking on the New Project lets you bypass the file menu navigation e Link to website Clicking on the GEOSYSTEM logo takes you directly to our website e Pick mixes from mix database When entering data at the Mix Number field double click on the data entry field for Mix Number or click on the mix tool button and select a mix That mix is automatically entered in the Mix Number field e Scroll through data from previous tests while entering field data The data you just entered for a different report is now at your fingertips when entering new reports Press Ctrl and Ctrl when entering any field data to s
37. report setup There are several miscellaneous settings which affect all test types not just selected test types Settings which are not specific to a particular test type are in the Data Entry Screen Layout section see Section 3 7 The basic report templates have basic names being BASICO CRP BASICI2 CRP They correspond to the test types as follows TEST TYPE DESCRIPTION Cast cylinder ASTM C39 Beam third point loading ASTM C 78 Beam center point loading ASTM C 293 Mortar cube Grout specimen ASTM C 1019 Cored cylinder Grout cube ASTM C 942 Mortar cylinder ASTM C 780 Grout cylinder ASTM C 39 Masonry block prism ASTM C 1314 Sawed beam ASTM C 293 2 Sawed beam ASTM C 78 Masonry block ASTM C 140 Soil cement cylinder ASTM D 4832 Table 1 Test Type Descriptions 1 2 3 4 5 7 10 11 12 3 Some users have commissioned a set of custom templates to be created by GEOSYSTEM Software In these cases the template names are the abbreviated company name plus a number representing the test type Example ACME4 CRP would be the 3x3 mortar cube format for ACME Engineering In addition to the BASIC report templates there is a set of templates which include extra space at the top of the form so it can be printed on company letterhead These are the LH UL report templates The LH stands for Letter Head and the UL stands for Units Labels These particular forms also add units to each test result
38. results and reply Yes to the option to print a copy Click on close to end the data import session Forney Skip to 17 Admet amp AMTD Observe now that some specimens in test 03001 have results On the printed summary of the merge the first record lists a date mismatch error Look at specimen 03001 6 or 03001F The age was incorrectly entered in the database but the results were merged anyway Select report number 03003 106 15 16 17 18 19 20 21 22 QC Concrete Reference Manual Notice that specimen 03003 4 or 03001D has a load but no other data On the import log record 5 was not imported because there was already a load entered This is an example of what the program does if a specimen already has a load Finally note on the printed summary of the merge that record 15 was not merged because there was no specimen 03008 7 or 03008G in the database Skip to last step Forney Take a look at project Examplel and report 1 the 28 day results are now entered On the printed summary of the merge note that record 15 was not merged because there was no specimen 62673 in the database This illustrates an error where the specimen number is entered wrong at the break machine There is a specimen 62973 in report number 6 and that is what should have been entered at the break machine Look now at record 18 on the printed summary of the merge That record lists a date mismatch error Look at report 9 the
39. results of tests on cement products such as concrete mortar and grout A wide variety of specimen types are handled by the software including cylinders cubes beams and sawed specimens Version 2 is an overhaul of the original version with many enhancements The sections which follow describe the many features of the software 2 1 Program Features QC Concrete was designed to be an efficient time saving tool for the materials testing industry Here are some of its noteworthy features 2 1 1 Reporting Capabilities Original program features e Print all reports for a day week or month with a single click e Print lists of all specimens needing to be broken e Print summaries of all breaks for a project e Print envelopes or labels for all copies on a distribution list e Individual report templates for each different test type handled by the program e Preview reports before printing e Custom report formats can be ordered from GEOSYSTEM Software New Ver 2 features e PDF file reports Now QC Concrete can create PDF format files without the addition of Adobe Acrobat Described in Section 3 3 2 e Multiple page test reports If you have more than the allowable number of specimens in a test 10 for cylinders 6 for beams and cubes and 4 for masonry the program will now print on as many report pages as needed to include all of the reports Described in Sections 6 1 3 and 6 1 5 e Pick a standard note for each specimen Rep
40. shortcut keys Ctrl F If there is more than one specimen with that number you can find the next one by selecting Edit Find Again or by using the shortcut key F3 Note To display only the Break Data select Tools View Field Data or click on the toolbar button mi The field data will disappear pp 4 5 1 Selecting Breaks To edit the data for a particular specimen click on the cell that contains the data If it is a result like Break Date or Strength you may be prevented from changing the data If that occurs you must change the data from which 38 QC Concrete Reference Manual the result is calculated This behavior is optional and is changed by selecting Tools Options clicking on the Screen Layout Tab and selecting or deselecting the option to Disable data entry in calculated fields 4 5 2 Adding Breaks To add a specimen click on or move to the blank row below the specimens already entered marked with the star in the row selector box Then enter the new specimen s data Biesk DateiPesk Losd Dinge Requed Shengh Pacet ot Requiied inea Fiachre ZEA T8000 EOD 222 2008 136 a EOD mm 17x E EOD 4000 1055 s B 4005 nues WI pues Figure 29 Break Data Table Note QC Concrete has an option to increment specimen numb ers automatically If you would like each new specimen to be numbered one 1 greater than the previous select Tools Options then click on the Automatically increment specimen
41. specimen was broken a day late but the results were merged anyway Next look at record 22 where the log notes that the load field already contained data In the Examplel project notice that report 11 has a load of 111111 On the import log the record 22 load of 162915 was not imported This is an example of what the program does f a specimen already has a load The technician would need to figure out what to do with the 162915 hopefully with some success In this case the 111111 was inadvertently entered by another technician and needs to be manually replaced with 162915 Finally notice that record 35 says that specimen 700010 was not in the database This is an example of what the program does if a specimen is not found Again it will take some detective work In this case the project and report had not been entered yet To repeat the tutorial exit the program and copy the database from the DATutorial Pristine folder to the DATutorial folder That will restore the original ready for D A import demo database 107 Index 1 Column 27 2 Column 27 Active Data Entry Fields 17 Adding Projects 32 Add Ins 81 Addresses 69 Admet 103 Administrator tools 79 Adobe Acrobat 71 Advanced Machine Technology 103 Always replace 74 Always show this form before printing 52 Archived projects 73 Arranging the screen 27 Arranging the Screen 28 Automatic sizing of break table columns 26 Automatic specimen numbering 80
42. than can be displayed due to the column being too narrow point the mouse cursor at the cell and wait it will be completely displayed in a pop up 4 5 4 Warning Colors A specimen row may be displayed in red or yellow to indicate a warning Red indicates the specimen strength is below the required strength Yellow indicates the actual break date does not match the scheduled break date used primarily with custom forms Warning colors are optional select whether or not warning colors will be displayed as described in Section 3 3 6 1 39 Data Entry 4 5 5 Deleting Specimens To delete a specimen left click on the row selector to select the row Selected rows are displayed in a different color Then press the Delete key on the keyboard Only one row at a time can be deleted 4 5 6 Resizing Rows and Columns Resize the row height by pointing to the row divider line between row selector buttons see illustration below When the cursor becomes the resize cursor click and move the mouse up and down to resize Resize the column width by pointing to the row divider line between row selector buttons see illustration below ROW SELECTORS tem ja COLUMN DIVIDERS Peak 10 9 99 127006 6 00 28 27 PATS SN Figure 30 Terminology for the Break Table When the cursor becomes the resize cursor drag the column dividers left and right to resize Note You cannot resize columns unless the automatic column width features of the sof
43. using dates in the test selection process see Section 3 2 1 Note The Test Type is also selected in this top area of the main program screen although it has nothing to do with the report selection process It just made it easier to design the software to have it up there 4 3 Projects Selecting Adding and Entering Data Projects can be added 2 ways 1 Creating a new blank project 2 Picking an existing GEOSYSTEM for Windows project 30 QC Concrete Reference Manual After starting a new QC Concrete project add the first test to that project and enter the Project Data Any information which is constant over the life of the project is considered to be Project Data Items which are Project Data are Project Number Contract Number Client Name Company Address Project Contractor Field Engineer and 10 Entries for a distribution list each including Name Company and 3 lines of Address Note Project data items may have different prompts than these e g Name may be prompted as Attn etc As you enter additional tests for that project the project data will be the same Any changes made to the project data for any test will be carried over to all tests previously entered This is because there is only one copy of the project data saved 3 4 3 1 Importing Client Data from an external database This feature is available only with the Client Import Add in additional charge This Add in is custom designed to i
44. 1 1 00 01234 1 1 00 01234 1 1 00 01234 1 1 00 01234 1 1 00 01234 1 1 00 01234 1 1 00 01234 1 1 00 01234 1 1 00 56789 1 1 00 01234 1 2 00 56789 1 1 00 56789 1 1 00 01234 1 2 00 56789 1 1 00 01234 1 2 00 01234 1 3 00 01234 1 2 00 01234 1 2 00 56789 1 1 00 01234 1 2 00 01234 1 3 00 56789 1 1 00 01234 1 3 00 Nr aA UR UTE Ne NR ON hm AAANKRWN Example 1 Three Ways Labs Identify Cement Products Tests The first two methods are treated alike by QC Concrete while the third method gets its own data entry procedures The following sections explain how to make QC Concrete fit each of these report selection methods To set the program up for the methods where all test numbers are unique or where they run sequentially each project start to finish select Tools gt Administrator Tools Beside Use Placement Date in report selection so report numbers can start over daily select the option No When this is selected the selection section of the data entry screen looks like the following example PROJECT NUMBER TEST NUMBER TEST TYPE FOR THIS REPORT NUMBER ETT n sj cce os Figure 73 Test Selection Panel When Dates Are Not Used 82 QC Concrete Reference Manual 9 9 1 Tests Numbering Starts Over Each Day To set the program up for the method where test numbers start over each day select Tools gt Administrator Tools Beside Use Placement Date in report selection so report numbers can start over daily select the option Yes
45. B to a backup location Refer to Section 9 7 for more information about where to find CQC CP MDB A better procedure is to include the entire QC Concrete program folder in your backups This is the best way to prevent significant downtime Ask your office computer expert for assistance with setting up efficient automatic backups 80 QC Concrete Reference Manual 96 List of Add ins Installed If the Break Importer or Client Importer options have been installed they will be checked 9 7 Database Location In rare circumstances an alternative location for the database may be preferred If needed access it using Tools gt Administrator Tools The current path new path and ways to navigate to the new folder are provided as show in the following figure Current Path Hub croot ConcreteD ata New Path i SH ub crootConcreteD ata Select a Drive sl Select a Network Location MH ub croot ConcreteD atas Select a New Folder CP SHubcroot Figure 72 Selecting a Path to the QC Concrete Database To select the new folder first select either a drive or a network location e Select the drive to use Network drives must be mapped to a drive letter to show up or Select the network location then Select the folder to use After selecting a new location the program will automatically terminate when you exit the Administrator Tools form When QC Concrete is next started it will reference the new
46. COMP DORESS 6280 FRANKLIN BOULEVARD CADOA TIVZIP SACRAMENTO CA 35824 CADORZ ROJECT CAMPBELL SOUP TRAILER DROP L PROJECT R9J NUM 2951 62 PROJ NUM CONTRACTOR E Mont TRC detekoss do ror diferente between dale sarspied endoene placed CODCP does asd seeds totic jn te daaag To how tto OTAC semplo dela be aded as fo COC O7 campo AID plsreemovtoenes cl ck ho boc Problems will look very obvious like CLIENT and PROJECT on the same line To change a map first delete the existing map then add the correct map Deleting and adding maps are done by QC Concrete Reference Manual To Delete Helds from the Map Scroll the map window so the fields to be re mapped are displayed Highlight it by clicking on it then click on the button Delete Fields From Map and the correlation between the two fields will be dropped To Add Fields to the Map Under the heading QC Concrete Fields find the QC Concrete field name to map it will not have a corresponding DTRC field to the left of it Click on it to highlight it Under the heading DTRC Fields Sample Data there is a dropdown listbox Drop the list down click on the down arrow then find the DTRC field to be added to the map It should be designated not it use Click on it Click on the button Add Fields To Map and the two selected fields will be added as mapped to one another Maps all goofed up Click on Cancel to abort any changes Note If you have already imported a project
47. EPORTS A toe EHE ETE Pe eb rep tertie tere de e ta bert PU vU dede e re ven HER ROS 48 SECTION 6 PRINTING REPORTS sssnsnnenensnssnononenznonononennoneneseneonenenensenenenessoneneneseonenenensenenenesessenenesesenenesessenenesee L 6 1 TEST REPORTS eot He I PEE ERE ER re EE e HG to ete Te e TR DRE eS 6 1 1 Selecting Test Reports seen 6 1 2 Other Report Printing Options 6 1 3 PDF Report Printing Options esie e a RO RE RSV e eR ein 52 6 1 4 Printing Test Reports essere 6 1 5 Printing Envelopes Following Test Reports 6 1 6 Previewing the Current Repot t 6 1 7 Report Data La E REC e RR MER RR HR GE ROI 6 1 8 Test Standards i4 e RO CUR ERREUR ARREST ER 6 2 BREAK LISTS uino RE IE RU CR ERE NR D RENI NEN T SENE DN e UIN 6 2 1 Defining a Scheduled Specimen ert ER P E RR EIE EG RS AE UR REN REIR 6 2 2 Picking a Date for the Break List 6 3 TESTING SUMMARIES eren 6 3 1 Testing Summaries Date Criteria 6 3 2 Testing Summaries Project Mix and Test Type Criteria 6 3 3 Testing Summaries Lab Test Criteria sc ree d A che a 6 3 4 Testing Summaries Field Test Criteria 6 3 5 Sorting Criteria eese 6 3 6 Test Selection Criteria Summary 6 3 7 Current Report Form t seed RH FR nas ededaah tas MINER TI CERERI RR DEED SESS 6 3 8 Testing Summaries Export Text Files e art e RR e E ER ERR eee erras 6 3 9 Testing Summaries Print and Preview 6 4 MIX REPOR
48. GEOSVSTEM QC Concrete Ver 2 QUALITV CONTROL FOR CONCRETE Database Management Software for Concrete and Other Cement Products USER S GUIDE Concrete Compressive Strength Report Poudre Wi o Engnocs 2007 All Rights Reserved Von Gunten Engineering Software Inc 363 West Drake Road Suite 10 Fort Collins CO 80526 WWW GEOSYSTEMSOFTWARE COM Support GEOSYSTEMSOFTWARE COM Information in this document is subject to change without notice and does not represent a commitment on the part of Von Gunten Engineering Software Inc The software described in this document is furnished under a license agreement and the software may be used or copied only in accordance with the terms of that agreement The licensee may make copies of the software for backup purposes only No part of this manual may be reproduced in any form for purposes other than the licensee s personal use without the written consent of Von Gunten Engineering Software Inc Von Gunten Engineering Software Inc 2007 All rights reserved Published in the United States of America GEOSYSTEM is a registered trademark of VES Inc Windows is a registered trademark of Microsoft Corporation Terms of License Agreement 1 The Licensee agrees not to sell give away or otherwise distribute the program or the program documentation Each copy of the program is licensed only for use at a single address 2 The Licensee agrees not to hold
49. IT TII 4 4 JJEVLIKI 38 AWLA A CoE JIBALAWI TERETE emp inv Figure 62 Format SUMMARYS includes dimensions and field test results Figure 61 Format SUMMARY4 includes the placement date A description is shown for each Summary Report Format see Figure 53 Long descriptions will not be completely shown to display more click on the description and use the arrow keys to shift it left and right There are now 15 summary reports and more are being added all the time For examples of all new summary reports visit GEOSYSTEMSoftware com 6 3 8 Testing Summaries Export Text File An optional feature is to create a tab delimited text file suitable for spreadsheet import To do this check the Export text file checkbox When exporting there is no printer output only a file created with a name SummaryReport followed by the range of dates summarized and FFW TXT To import the file into a spreadsheet or other database follow the directions for that software for importing tab delimited text files 6 3 9 Testing Summaries Print and Preview To print the Testing Summary click on the Print button To preview before printing click on the Preview button The Preview form has the appearance illustrated in Section 6 3 7 When the Testing Summaries Preview is displayed the following options are available Print Prints the displayed test summary on the currently selected printer e Make PDF Creates a PDF file for the testing sum
50. Importing an existing client from an external database The third method of adding new projects involves importing client data from and external database Licensees of the Client Importer Add in have QC Concrete 33 Data Entry set up to retrieve client information from an external database Clicking on the Data Source button brings up the Select Import Source for Client Data form shown in the next figure Select Import Source for Client Data cM C Use the main COC CP database Use extemal database CADocuments and Settings Mike My Documents My Data Sources Client Databases Database format Access m Table if applicable Table1 External database field map EXTERNAL FIELDS SAMPLE DATA caddress3 cClient Bob Bacon cCompany Bacon Eng cAddress1 al dress2 a2 ag CQC CP FIELDS cappRa PROJECT2 PROJECTS PROJECT4 PROJ_NUM CONT NUM CONTRACTOR FIELD ENG Add Fields to Map Remove Fields From Map Figure 24 Client Import Add in Instructions for using the options on this form are in the appendix supplied to customers who have licensed the Client Import Add in 4 3 3 Entering Project Data Project Data and Field Test Data are entered in the same area of the main screen The data is simply typed in the blanks beside each prompt Because each report includes both Project Data and Field Data they are mixed together on the same screen The major difference is that Project Data is the same
51. ONCRETE AND FIRST TIME SETUP cccccssssssssescescesseseesecsecsecssesceseeseeseesasssceseseseseeseeseeseseeaseascascaseneees 1 3 TO ACCESS GEOSYSTEM DATA MANAGER PROJECTS 1 4 TO ADD NEW REPORTS 1 5 TO ADD NEW BREAKS 4er e ee tr e o e ed Pee ed anes ete e esae 1 6 TO PRINT OR PREVIEW TEST REPORTS 1 7 TO PRINT A BREAK LIST 2 1 PROGRAM BEATURES 51 uci rr rH IRR rri ERE a anna 2 1 1 Reporting Capabilities 2 1 2 Test Types Handled 2 1 3 Data Management Features iie ei aei nebst o eret spes dh sek aged abate ases en hog 2 1 4 User nterface Features iie TE eter LANES 2 1 5 Other New Ver 2 Features 2 2 FUTURE ADDITIONS SECTION 3 USER PREFERENCES 3 1 NO INDUSTRY STANDARD FOR STRENGTH TEST REPORTS 3 2 OPTIONS ON THE GENERAT TAB arsine apie n see HH Gt eU e e P at bre RE rea de E 3 2 1 A Note About Terminology esee estet tette entente tenete tette eie araia i ienr ente tete tite roaie rar 3 2 2 Automatically Incrementing Test and Specimen Numbers 3 2 3 Suggest most likely value for first specimen number on a new report 3 2 4 Sorting the Test Numbers 3 2 5 New TESE STA U PE 3 2 6 Average Test Strength sete a a 3 2 7 Warn or prevent if specimen number is not unique in the entire database 3 2 8 Warn or prevent if specimen number is not unique in the report 3 2 9 Reportin
52. RENTRER ERU RE REE N ewes 4 5 BREAKS SELECTING ADDING AND ENTERING DATA eese nennen nennen nennen rne ens enses ens tn sinet 4 5 1 Selecting Breaks ees sere edes 4 5 2 Adding Breaks 4 5 3 Entering Break Data 4 5 4 Warning GColotsia cios oie RI en DORUM TOR Una OG UE aks 4 5 5 Deleting Specimens iii i oe ERE a TENERE ERU ERR RE Ce e UM EAE Eat 4 5 6 Resizing Rows and Colummns 4 5 7 Cut Copy and Paste in the Break Table 4 5 8 Moving Around the Break Table and Other Editing Keys 4 5 9 Break Table Cal itlationz ii te et pe E nte e e e ede pe eh Lanes BS LO AvVeraging SITengtliss ccu ae ERE UR ERE THERE A EA UNE RE E E ese EE reed 42 4 5 11 Default Fracture Type and Fracture Type Menu 4 5 12 Using Drop Down Data Lists in the Break Table 4 5 13 Entering Break Data from a Break List sss 4 6 SHORTCUT KEYS c ec PH RR a a SR TER S E ERR ER RE ER HANE ER ESAE 4 7 SPECIAL CHARACTERS AND SYMDBOLS 4 eterno teen ie e e e ir de ei erm eee td 4 8 CHANGING THE PROJECT NUMBER REPORT NUMBER OR DATE sese ener tnnt entren tnter nen 4 9 REPORT DATA erect e A a aha ERIE IE SECTION 5 MANAGING MIX INFORMATION ssensnsnnenononsononenennonenenonsnnenensosnonenensenenenesessoneneseseenenenensenenenee6 47 5 1 MIX KOTO E c n 48 5 2 MUPXRB
53. REPORT OF CONCRETE CYLINDER TEST Licensee Company Name Pe port Date P ppctNimber Report Number Ppkct J Cleat Address Ath FIELD TEST CONDITIONS AND RESULTS AASHTO T 23 Dat Placed Time Samped Locatba ofSampk 7 Supple Track Number Tkket Number Mi Number De sky Strength Tme batted 7 Time Placed Bath St SMP 5 5 washer sg Arcontert Coirce t Temp Amb it Tem p Water aded Techikla LABORATORY TEST RESULTS ASTM C39 Test Perceatot Type of Species Dat Age Lox Dimetr Aea Stegt Dese Frac Remarks TYPES OF FRACTURE All Coe Owe 4 Coe Sear Coumnar Sat Stew Copks b Pe ported by REPORT TEMPLATE C A GDM YVB COC CP32 BASICO CRP Figure 41 Report Preview When the preview screen is displayed you can e Print Prints the displayed report on the currently selected printer e Make PDF Creates a PDF file for the testing summary viewable using Adobe Acrobat The file will be saved in the default PDF storage folder if one is designated otherwise it will prompt for a location and the folder selected will become the default See Section 3 3 2 for additional information e Show previous next pages M 4 2 4 gt If the report continues on subsequent pages you may preview the subsequent pages prior pages using the bl and KI buttons on this control e Showfirst last pages H4 2 4 W If the report consists of more than a few pages vou mav go to the last first page u
54. TINGS FOR SCREEN COLORS DATE FORMATS AND FONTS 3 5 1 Setting Colors Local eese 3 5 2 Setting Date Formats Global c E Re eet On deseen e re TE 3 5 3 Setting Data Entry Fonts LOCAL eden o RR ba FUISSE EROR RD REUS ege 3 6 SCREEN LAYOUT SETTINGS eene 3 6 1 Data Entry Screen Settings 3 6 2 Selection Titles o renes 3 7 CHANGING THE DATA ENTRY SCREEN LAYOUT 3 7 1 Arranging into Column as aeter RE RES ERR aa dE HR Ren 3 7 2 Arranging Anto 2 Column S araa EE A A E E E A RH 3 7 3 Arranging To Use All Available Space eese esee A O NEE EE NNE EESE i ia 27 3 7 4 Arranging the Screen sss 3 7 5 Screen Arrangement Tips 3 7 6 Title fOr the SCL ON E SECTION 4 DATA ENTR Xi kein 29 4 1 THE DATA ENTRY SCREEN recreo cire tet D OP CGU GAP d lave DOUG UE TEE NN a EVE EFE EEUU CR 4 2 EDITING EXISTING TESTS 4 3 PROJECTS SELECTING ADDING AND ENTERING DATA 4 3 1 Selecting PEOIJeCU eee ERE DUE NH RERO a a 4 3 2 Adding Projects and Selecting a Project Template 4 3 3 Entering Project Data su seien eos rt C qa d RR ER ehe bae d E Ea 4 4 TESTS SELECTING AND ADDING 4 4 1 Selecting TEStsS 4 4 2 LUPA NI C 4 4 3 Entering Field Data s eas RECO b RESET U BET So 4 4 4 Gut Copy and Paste Field Data iis ee e ea ree te
55. TS csccsssssssssssessssscsscssessessesseceecsecssesaesaseaesaesaceaseaeeseseseeesseseessesees 6 5 PROJECT REPORTS ettet a 6 6 PRINTING ADDRESSES eiie ce t Ge e tox lnk nere aee eet Un tie Gis ee a o re o ECCE RU e ETE E REL OE 6 7 PRINTER SEEDUP uen URBI nene A E un 6 7 1 E mailing Reports usas ue ee ie te ege e bete t ER OH ee diee 6 7 2 FAXING Reports with Modem oe te En HR P et eR eee OR ee SECTION 7 WHAT TO DO WITH OLD PROJECTS eee eeeeeeee tenen eee etnsnsnetn sn sn esta sn so ese sense sensn sn sensns 73 7 1 INACTIVE PROJECTS i EE E e aa ta b UU E 73 7 2 ARCHIVING AND RETRIEVING PROJECTS cscsscsssssessesscesceseessessessssssessessessensceecescesseaesaecaescaecaessacsassesseseeeaseasensseeseeensenseeas 7A 7 3 MERGING BRANCH DATABASES rii nett eee ti ial Per ne e et ee t Ge bas ae e o o t ee OU TU Dee EEA ENANA Eis 7A SECTION 8 EXPORTING RESULTS FOR STATISTICAL ANALYSIS ssrenssssnnennonsnnensononsensossssensossneess 71 8 1 CPR BXPORT CRITERIA oen e een E en EB ped TI 8 2 CPR EXPORT FILE NAMES ie etie ete de ees E Ie or b e a ot e ea 78 SECTION 9 ADMINISTRATOR TOOLS AND MULTI USER CAPABILITY 9 1 MULTFUSER STATU 55e tirer ERRARE EET RSEN A TESSEV URGERE IEEE ERR UE RE Ue 9 2 DATABASE STATISTICS eet ite e ete i erre tete 9 3 LAST SPECIMEN NUMBER USED 9 4 IMPORTING FROM DDT RC 4e ertt re E Ce CENE ERE RE e e en 9 5 DATABASE MAINTENANCE ie e re PU e teo bev eoe t ak er irte te etait ete
56. _HH MM txt where the date and time are included in the file name The file is saved in the program folder Recall the file for printing using the menu option Reports Print Addresses Print Saved Set of Addresses The same form will be displayed that is shown in Figure 39 Envelope Printing Options Form but with the following additional options Select address list to print CEnvList2 11 2204 15 18 TXT EnvList2_11 26 04 11 01 TXT Delete Selected List Delete list after printing Figure 40 Envelope Printing Options Form When Printing Saved Addresses Select the list to print from those listed then click on OK the envelopes will be printed You can keep the number of files in the list to a minimum by selecting the option to Delete list after printing Another way to eliminate unneeded address files is to select the file then click on the Delete button Note Also see Section6 6 for additional information about printing envelopes and labels for a single report Note Envelopes are printed on the left side of the printer not centered 6 1 6 Previewing the Current Report To preview and print the current report click on the preview button B or select Reports Preview Current Test Report Just the currently displayed report will be previewed The user can choose to print the displayed report directly from the preview screen The preview looks like the following example 54 QC Concrete Reference Manual x wt p a l
57. am They show project and field data and the strength results for each specimen broken Envelopes may be printed following the reports 6 1 1 Selecting Test Reports Click on Reports Report Selection to display the form that allows selection of which test reports to print At the top of the form is the current selection method and the number of reports that meet the requirements of that selection method This form is shown in the following figure AS rure urgrirheci ra ports wtiba prirtad Fond 4 ino tn mee cv nn Aen isobriman Cates Use brank dotes Law plecurmm ni catus ba serpu dato Carrerity selected repa ary Ropon tro angle dere ND Reports tor caw petri TAWE wd paa Ana C V Wiunperried sme tengt MS res rmt bend Unit nis a nurmicar NEONI Y One mersu specimen age lel On reports vit opacmww eon doy Dihs Masa Menina Dortena Port arepertion wach norme onthe dadnbetanin fis erede bet not ohare fec deiot set Include ooi on to prin wires in ps following re porti Esperiwed tw VADE AM srera U ple hora PDF ior ec POF asy crecie POPs kar pr aroy Hasdco pev nay prim wt des gnatior no POPE eter EBDA Es FP maps dian ar lida hing LIS Figure 38 Appearance of Form for Choosing Report Selection Method The selection criteria are 51 Printing Reports Use break placement or sample dates While breaks dates are the most practical criteria for selecting reports to pr
58. ange Report Data Titles again and click on Paste Titles e Abandon Closes the form and discards all changes made since the form was opened QuickData Titles The last 3 Report Data items 14 15 and 16 may be used for QuickData If using QuickData enter titles appropriate for the category of data being saved in the list 9 10 2 Selecting the Standards Titles to be Used With a Test Type The standards data form when displayed for changing standards titles looks like the one used for Report Data shown in Figure 75 When might you expect to need to change a Report Data Title Probably only for custom forms which are created for you In that event select a test of the test type of interest Next select Tools gt Administrator Tools then click on the command button labeled Change Standards Titles Editing the titles is done by clicking on the title to be changed then editing Some other functions of this form are QC Concrete Reference Manual Copy Titles Paste Titles Each Test Type has its assigned report and likewise its own set of General Report Data To copy all of the titles from one Test Type to another click on Copy Titles then OK then exit Administrator Tools and then select the Test Type which is the destination for the set of titles Go to Tools gt Administrator Tools again and click on the command button labeled Change Standards Titles again and click on Paste Titles Abandon Closes the form and discards all changes ma
59. atabase Maintenance In the database maintenance frame there are 2 functions one for assistance in technical support and the other for disabling the automatic backup feature They are explained here Examining the entire database the Edit button This may be used as an aid during tech support calls You will receive special instructions from GEOSYSTEM Software when this is needed It is password protected so inadvertent access and the risk of data loss is prevented Create a backup of the database each time the program starts To have the program make a copy of the database each time it starts check this box It can be useful if the database gets damaged while in use and has saved the day on a number of occasions over the first few years that the program was in use This option is offered as a safety net for users who like to take every precaution with their databases If you are one of those use it however it also slows down the loading of the program When the backup is created it is not simply copied The database goes through and inspection and improvement process which removes unnecessary extra space and corrects any file format problems which are found Recommendation Activate this option once a week for one day This will keep your database in top condition for maximum efficiency and minimum size Other Backup Recommendations Please back up your database frequently every day if possible To do so copy the file CQC CP MD
60. atory Supervisor 4 1982 Forest Range Dr t Note 4 t Note 5 4 eport Note 6 C XD m NM X tm 4 09 Jw D n T 16 Report Note 16 Figure 42 Setting a Project s Report Data Select from values previously entered or enter a new value Some tips when working with Report Data are New values entered become the default value for that Project and Test Type To edit a value select it then make the changes When finished hit Enter and you will be prompted to press Y to replace the original data with the edited version or to press N to add the changes as a new value To abandon all changes click on Cancel To remove an item in one of the Report Data lists select the entry to be deleted then press F5 It will be blanked out not deleted to preserve the position of the other entries To delete typing that hasn t yet been added to a list just select the typing and press Del Note The titles of these data fields can be changed so they may not look like this example To change the titles refer to Section 0 6 1 8 Test Standards Standards such as ASTM AASHTO UBC or ACI test methods or specifications are usually referenced on reports as well and generally don t change often either Information about which standards are referenced is called Test Standards The Test Standards selected for a given Test Type on a particular project will remain set for all tests in the project unless changed by the user
61. available when Actual Break Date is used to highlight specimens in yellow if the actual break date is different than the scheduled break date Enable the yellow highlight using the break table setup form Described in Section 3 3 6 Update inactive status This new utility will scan reports and specimens to ensure all records are correctly designated active or inactive based on the status of their project Described in Section 7 1 Can determine pass fail based on ages other than 28 day Reports with a 7 56 or other age at which the strength is required to meet specifications can now have their average strengths calculated Described in Section 4 4 3 Find out you ve entered a project number wrong and have already entered several reports No problem now New Change Project Number feature Described in Section 9 8 QC Concrete Reference Manual 2 1 4 User Interface Features Original program features e Arrange data entry fields to suit individual preferences Use built in calculations for specimen results or calculate yourself Set font color and date formats to suit Find any specimen without entering its project or report numbers Enter results in the order they are listed on a daily break sheet Logical data Yes or No can be entered in checkboxes Toolbar buttons for frequently performed tasks Generous set of configuration options for a wide variety of reporting customs New Ver 2 features e Failing tests shown in
62. aximum of 5 checkbox groups Rarely will you need to make any changes here but if instructed to do so you may need these directions To change the checkbox settings select Tools Options and click on the Report Setup tab Click on one of the Test Types in the list on the left Click on the Data Entry Settings combo box and select Checkbox Grouping Click on the command button labeled Edit Selected Item Editing is done as follo ws Creating a Checkbox Group In the one of the checkbox columns click on all the checkboxes to be added to the group To remove a checkbox from a group click on it again Note that a checkbox cannot be added to more than one group Selecting a Default Checkbox In the one of the checkbox columns RIGHT click on the checkbox that should initially be checked for a new test It will be designated as the default by a blue circle around it e Selecting OK or Cancel Changes Selecting OK will save the changes selecting Cancel will return the checkbox groupings to the way they were before opening this form 18 QC Concrete Reference Manual 3 3 6 Changing the Break Table Arrangement The appearance and function of the break table where the break test results are entered also depends on the test type Rarely will you need to make any changes here but since the layout and prompts may be different for users of customized report forms they may be changed The form for these changes has the following appeara
63. bution list for the new project is the same or similar to the reference project time can be saved by copying it as well Check the box by Copy distribution list too to do so The distribution list includes the data fields CC1 usually the client s company name CCA11 CCA21 CCA31 CCA41 usually the client address PROJ NUM the project number There are 10 sets of these 5 fields which comprise the entire distribution list These will always be copied as well if the Always copy client information fromthis project box is checked e Using another project s Report Data and Test Standards Creating a Project Template Another time saver is to copy an existing project s miscellaneous project data both the report data and the test standards See Section 6 1 7 and section 6 1 8 for additional information about Report Data and Test Standards To do so click on the Select Project button A list of existing projects will be displayed as shown in Figure 23 To always copy that existing project s miscellaneous project data check the box for Always copy the report data and the test standards from this project e Project View Company View Either all existing clients or all existing projects may be listed when choosing the source for a new project s client information or misc report data Choosing the Project View displays all projects including multiple projects belonging to the same clients The Company View displays only unique companies e
64. by the one being retrieved check the first option Confirm replace 2 If it is known in advance that all existing reports are to be replaced before retrieving the project check the option Always replace at the bottom of the form 3 Finally if duplicate projects are never to be replaced from an archived database select Never replace This option is useful when 2 main databases need to be merged Note that the Mixdata Table is never included in the merge mixes which exist in the archived database are ignored 7 3 Merging Branch Databases In cases where a company s home office needs to keep a branch office s tests with theirs QC Concrete allows you to merge one database into another After receiving the database to be merged save it in a location accessible to QC Concrete Then select the menu option Edit gt Project Status Then click on Merge Branch Database Navigate to the QC Concrete database to be imported and select it QC Concrete merges the entire branch office database all projects reports specimens and mixes 7A QC Concrete Reference Manual In order to use feature your method of identifying a report s specimens must require unique specimen numbers Needed because if a branch office changes the specimen information on some report there is no ambiguity about which specimen in the home office database needs updating Because of this the QC Concrete program option to require unique specimen numbers in reports must b
65. culation 21 Expert 13 Export text file test summary 66 Export text file 52 F Fax 71 Features 5 Field data and break data 35 Field maps 94 Font options 26 Font subset 26 Forney 103 Fracture Type Menu 42 G General Options 9 GEOSYSTEM Data Manager 3 I Identifying tests 82 Import data 91 Importing a GEOSYSTEM Data Manager project 32 Importing break data 103 Inactive project 73 Include option to print envelopes following reports 52 J Justification of the specimen numbers on reports 15 L Labels 69 Last specimen number used 80 73 LD4 Drilling Log Program 3 Length of a field 17 Limit to Project Number 52 Local Settings 9 Location of database 81 Logo Sizing Checkbox 21 M Merging Branch Databases 74 Mix information 47 Mix Number 38 Mix Reports 48 Mix Tools 48 Network Server 1 Never replace 74 New Features 7 New Features with Version 2 5 New Project 32 New Test Status 11 Number of Records 80 O Omit reports with specimens 52 Omit reserve specimens 52 Omit Reserves 24 Other Report Printing Options 52 P PDF 71 PDF Report Printing Options 52 Peer to peer Network 1 Percent of screen for start of second column 27 109 QC Concrete Reference Manual Pick Report Template 15 Placement date 44 Preferences Options 9 Prevent duplicate specimen numbers 12 Preview 54 Previewing 51 Principle design age 47 Pri
66. d DOS Version GEOSYSTEM Daily Test Report for Concrete DTRC databases The import process involves 2 procedures one with DTRC the other with QC Concrete These procedures are described in the following sections A 1 1 Preparing the DTRC Database A program named DTR2CQC PRG is included with QC Concrete to help prepare DTRC for import Copy it from the QC Concrete folder to the DTRC folder Note If the folder the program is in is unknown search for it with Windows Explorer using the Search or Find facility Or locate it using DOS by going to an MS DOS prompt Usually with Win 95 98 2000 you navigate Start Programs MS DOS Prompt then enter CD C then enter DIR VPLEXE S then wait while the computer searches for VPI the database program for DTR When it finds it you will see something similar to but not exactly like LL Jo ODIR VPI EXE Volume in drive E is 458 9MB Volume Serial Nuwber is O000 P000 Directory of MCORCRETENDTRC 05 30 1992 Q4 38a The part that says Directory of CACONCRETBDTRC is the DTRC folder Open an MS DOS prompt see note above for help with the MS DOS prompt Change to the folder the program is in by entering the DOS command CD CxX path to program For example CD CACONCRETBDTRC The same path to the DTRC folder used in step 1 Enter the command VPI The program VPI will start and give you a 1 gt prompt At the 1 prompt type the command DO DTR2CQC The VPI program look
67. d T 22 Sawed concrete beam flexural strength in third point loading ASTM C 42 and C 78 and AASHTO T 24 and T 97 Sawed concrete beam flexural strength in center point loading ASTM C 42 and C 293 and AASHTO T 24 and T177 Grout cubes ASTM C 942 and C 109 no AASHTO Mortar cylinders ASTM C 780 and C 39 no AASHTO Grout cylinders ASTM C 39 no AASHTO Masonry block prism ASTM C 1314 no AASHTO Masonry block ASTM C 140 no AASHTO Soil cement cylinders ASTM D 4832 no AASHTO Data Management Features Original program features Tests can be referenced by project number report number and date or just project number and report number Access your data locally on another PC on the network or on a network server Program can be run by more than one user at a time additional users are notified that they are not alone when they start it up 4 relational databases used for data management efficiency Set projects to inactive status or archive them entirely when done New Ver 2 features Import client data for new projects New projects can now automatically retrieve the client data from the QC Concrete database or by using an optional module external databases Described in Section 4 3 2 Break tables have new fields To increase the flexibility of QC Concrete for custom reports the break table has new fields available for Actual Age Actual Break Date Curing Location Days of Field Cure and Days of Lab Cure A user option is
68. database location Note If you selected a folder that does not have a copy of the database in it it will be moved to that folder Otherwise it will simply reference the new location If you have more than one QC Concrete database it may be confusing so have multiple databases only if there is good reason 81 Administrator Tools 9 8 Renaming Projects In the event that a project has been given the wrong project number and tests have been entered this option is available to correct the problem Enter a new unique name here and the program will change all database references to the old project number to the new project number 9 9 Report Selection Mode How tests are selected depends on your company s convention for identifying tests Typically this is done one of three ways 1 All tests are uniquely numbered there is no duplication even between different projects 2 Tests are numbered sequentially from the start to the finish of the project so all report numbers in a project are unique 3 Report numbers start over at one every day so the placement date becomes essential to uniquely identify a test The following examples illustrate 8 tests identified each of the 3 ways All Test Numbers Unique Tests Numbered Sequentially Test Numbering Starts Over Start to Finish for Each Project Each Day PROJECT DATE TEST PROJECT DATE TEST PROJECT DATE TEST NUMBER PLACED NUMBER NUMBER PLACED NUMBER NUMBER PLACED NUMBER 01234
69. databases are a rare customization it is unlikely that one will be found 9 Select Exit then start VPI again At the 1 gt prompt enter the command USE CQCPROJ then the command MODIFY then press END At that point the screen should look something like yinesday October 29 2900 W Info 4 50 Modify COCPROJ DBF Tune Width Ber N Type Width Der eoeeoenmnmaemeoaeoen u UP DOWN COLUMERS ROHS EHLT Previous Pgl p Left K Insert N Update Erd N Musbers Next Pulln Right L Delete ri Wochange mi L Yess this file as Tyee 8 1 2 or 3 2 10 Press 3 and the conversion process is complete Your DTRC database is now ready to import into QC Concrete A 2 Import the DTRC Database into QC Concrete 1 Decide about importing the Sample Date as the Sample Date Yes this is a little confusing so read up in Section 3 2 12 about e Option to Add Sample Date 2 Select Tools gt Administrator Tools DTRC Import and clickon the Import button The following screen will be displayed 93 Importing Tests From DTRC Seep on irom Coty Feet Ropar Prope st Dotobars CACONCRETE COCPRO ADEF prer J Tas Duiatura CACONCRETEVCOCPRO R DOF ma hi Databases EE 3 Sate tt 5 Preps ct hemm feres me deters ONVE UN DTRE n COCCF Database Field Mase Chag PvunDesoew FuuOeeOcmkee Brow Deatew Nm Debe ww 3 Select the DTRC Project Database always CQCPROJ if you followed the d
70. de 9 6 LIST OFADD INS INSTALLED neret rri eere esi a tes ceo code eU Ete P REN ER CEN US 9 7 DATABASE LOCATION iii iii etika e eer ee ett 9 8 RENAMING PROJECTS ccscesssssescessessessesecsecaecssesaesaecsessecaeesesseseseeseeseeseesensenss 9 9 REPORT SELECTION MODE eere 9 9 1 Tests Numbering Starts Over Each Day 9 10 REPORT DATA AND STANDARDS TITLES ccccssssssssesscsscescssesscssessessesseeseesessesscesesessessessessssscascascsaesaesaecaesaecaesaesaesensensense 9 10 1 Selecting the Report Data Titles to be Used With a Test Type essere 9 10 2 Selecting the Standards Titles to be Used With a Test Type essent iii SECTION 10 TROUBLESHOOTING e eeeeeeee estes tenen anna toten enata totos ta tassa ennt tensa enano ananas to tones saos enun 87 10 1 CBRROR MESS AGES ot nr lerra E Rr ERREUR Meier Miet drei 10 2 MINIMIZING DOWNTIME APPENDIX A IMPORTING TESTS FROM THE GEOS YSTEM DAILY TEST REP ORT FOR CONCRETE PRO GRA d esce e seen 91 APPENDIX B GLOSSARY s i 97 APPENDIX C UPGRADING FROM VERSION 1 TO VERSION 2 ssnsnsnnenenensonenononsznenenenesnsnonenesnonenenesssec 99 APPENDIX D IMPORTING BREAK MACHINE DATA ssnsssosenenzzsnnonenneononenensenenenenennenenesesnononeneesosenesenssec 103 INDEX qe 108 QC Concrete Reference Manual Section 1 Quick Start Guide 1
71. de since the form was opened 85 Administrator Tools jp 2 eS ___seseEe_____________________________________________z__ 86 QC Concrete Reference Manual Section 10 Troubleshooting 10 1 Error messages These are some of the program s error messages There are actually many more that may occur of the generic form Error error number error description in procedure name Just call about those The table below is sorted alphabetically the ones that start with a file s name will be among the first 11 or so Contact tech support file name The disk on which this file resides cannot be accessed insert the appropriate disk file name Bad File Name Specified Contact tech support file name Device unavailable error when attempting to Contact tech support access the above file file name I O error attempting to access the above file Contact tech support file name The above file was not found Contact tech support file name The disk on which this file is being saved is Free up some disc space FULL Use File Manager or DOS to delete unused files from the disk then switch back to this task and select Retry Select Cancel ONLY if you cannot recover any disk space the above file cannot be found file name This file is damaged Contact tech support file name This file or the disk on which it resides is in Contact tech support use or write protected file name Too many files are open Close a
72. doing it To change it back see Section 3 2 1 It also may change the date formats Since you MUST use 4 digit years if any tests are entered for dates prior to 2000 and most DTRC databases go way back some to the 80 s the program is likely to make changes The conversion import process involves some intense code execution so it may take a while 95 Importing Tests From DTRC SSS ed QC Concrete Reference Manual Appendix B Glossary Active Projects When a project is completed is can be removed from the list of projects in the Project Number list Projects which have not been removed are Active Projects Archiving Projects The process of removing projects from the database and placing them in a different database is Archiving Break Lists A list of specimens scheduled for break testing on a particular day is a Break List Cast Date The Case Date is the sample was fabricated and is the same as the Placement Date Related terms are Placement Date Sample Date and Submitted Date Checkboxes Field Test Data that is most appropriately represented by a box which can show a checkmark or be blank Client Import The process of getting client data from an outside source such as an Oracle or proprietary database CPR Statistical Analysis GEOSYSTEM Software has a program for the statistical analysis of concrete Concrete Performance Report or CPR which uses ACI 214 and other standards to produce statistical tables graphs and calculate requi
73. e current date Date Placed This is the date format for the Placement Date Date Sampled Submitted This is the date format for Sampled and Submitted Date Broken This is the date format for the Break Table Convert MMDDYY input to a date checkbox 25 User Preferences Check this box if you want to enter MMDDYY ex 020501 as a date and have it converted to the MM DD YY ex 2 5 01 date format 3 5 3 Setting Data Entry Fonts Local Select Tools Options and click on the Colors Dates and Fonts tab to access font options When choosing fonts the list is a subset of all the fonts available on your system Set the subset up using the Font Subset button Fonts chosen are a local user option affecting only the machine on which the fonts are selected e Titles This is the font for Field Data Titles Data Fields This is the font for user entered Field Data Break Table Heading This is the font used for the headings on the Break table Break Table Data This is the font used for the data entered in the Break Table Set Font Subset If you want to you may use this option to limit the fonts available to only those of interest when picking data entry font preferences Click on Set Font Subset then double click on available fonts to add them double click on subset fonts to remove them from the subset 3 6 Screen Layout Settings Miscellaneous data entry screen settings are discussed in this section These settings affect
74. e selected See Section 0 for more information about requiring unique specimen numbers in reports 75 What To Do With Old Projects a rs 76 QC Concrete Reference Manual Section 8 Exporting Results for Statistical Analysis GEOSYSTEM Software has a product called Concrete Performance Report CPR It is a DOS based program which performs statistical analysis on concrete test results and prints reports and charts Eventually CPR will be converted to the Windows platform and tightly integrated with QC Concrete Until then users who have CPR and need to perform a statistical analysis on data stored in QC Concrete can use this facility to extract the needed data from QC Concrete and save it in a format which can be used by CPR Select Tools gt Export to CPR to access this facility The export form has the following appearance Ewon e cer sumteyrie xl STATISTICAL ANALVSIS CPR EXPORT SETTINGS Date Criteria Starting Date I 1100 Ending Dete Project Mix and Test Type Criteria 10 3700 Date Paced C Dote Broken Project none Mo 5000 D tl Test Type Cast cinder Other Criteria a rone d Inone z 4 KI f Beodel File Nema c SsTATS OcT2000 Speomenstobeexpored one snd two 2B dey three 28 daw Existing CPA ProectFile ta copy idani C STATS STANDARD Erowee Test Selection Criteria Summary Test Type Cast cylinder Date placed starting date is 03 01 72000 Date
75. ee previous values entered Described in Section 4 4 3 2 1 5 Other New Ver 2 Features e Version 2 is faster QC Concrete is now a 32 bit program That means that it makes more efficient use of your computer s memory and calculating power The previous version of the program was a 16 bit program e No more drive letter mapping Network paths like Server Concrete are now supported Described in Section 9 7 e Database operations are more efficient A newer version of the underlying database engine is used called Jet 3 0 In addition to being newer it is 32 bit instead of 16 bit see the first item for a discussion of these terms e Import break data from break machine data file QC Concrete can now automatically merge break data from a digital load display data acquisition file This feature is only available with an optional module Contact GEOSYSTEM for more information 2 2 Future Additions Several additional features will become a part of the program in the near future e Invoice list export Introduction e Statistical analysis companion software e Client report repository Let us know about any other additional features which would be beneficial QC Concrete Reference Manual Section 3 User Preferences This chapter discusses configuring QC Concrete s options 3 1 No Industry Standard for Strength Test Reports A lot of options have been built into QC Concrete to satisfy the multitude of reporting requirements
76. efer to Section 3 3 1 for additional information about selecting report formats 4 Choose the Break List Setup tab and you ll see the name of the Break List format If you have a custom report format you should select it 5 Read the 3 break list options on that tab choose the test selection option that best fits Choose Help for additional information 6 Setup the report data and specifications data for each form you will be using for more information see Section 6 1 7 QC Concrete Reference Manual 1 3 To Access GEOSYSTEM Data Manager Projects All projects in GDM are accessible Choose Edit gt New Project and click on Browse to identify the Path to Existing GDM projects References to GDM are synonymous with LD4 the GEOSYSTEM Drilling Log Program which also hosts the lab modules Note The GEOSYSTEM for Windows Data Manager GDM or the GEOSYSTEM for Windows Drilling Log program LD4 does NOT need to be running for QC Concrete to run Also note that for simplicity all references to the GEOSYSTEM Data Manager in this manual will be simply GDM regardless of whether GDM or LD4 are being used 1 4 To Add New Reports Select Edit New Report and type in a new test number If using dates enter a sample date as well More information is in Section 4 3 2 1 5 To Add New Breaks Click on the first blank specimen number cell on the break data table Type in a new specimen number and press enter Follow with the rest of the app
77. en numbers in QC Concrete Admet No Job ID Tabbed is for Admet files where the header looks like this when you open the LOG file in Notepad P 02 04 02 LOG Notepad Eile Edit Format View Help Spec Spec firea Pk Load Pk Stress Length Corr Date Time User IDit Type sqin LB psi in Fact Type 2 1 82 8 24 04 181184 16493 CYL 28 274 124488 4466 12 For this format all of the SPEC ID s must be unique in the entire QC Concrete Break Table so begin numbering specimens with 000001 and continue through 999999 or higher if the Admet system allows more digits This format is always has the LOG extension and is saved without using Excel AMT D16 is for Advanced Machine Technology files where the header looks like this when you open the file in Notepad B AMTD16 Data Notepad B Eile Edit Format View Help DATE TIHE SP ID firea Pk Load Pk Stress sq in Lb psi 11 85 96 11 65 96 11 65 96 88 27 85 88 29 59 88 32 32 4268 4261 4212 28 274 28 274 28 274 105370 3727 1851780 3728 107250 3793 For this format all of the SP ID s must be unique in the entire QC Concrete Break Table so begin numbering specimens with 000001 and continue through 999999 or higher if the AMT D16 system allows more digits TestMark Wincom no Job ID is for TestMark Wincom files This format is essentially the same as for Admet no Job ID so see above for desc
78. er interpreted as a number on each report will govern the order of printing According to report number According to project number specimen number Using this sort the first specimen number is used and interpreted alphabetically 3 3 9 Distribution List Options The user may choose to have multiple copies of a report printed one for each entry in the distribution list To select this option To get to this option select Tools Options and click on the Test Reports tab then check the checkbox labeled Print a report for each name on the distribution list Additionally the program can be set to insert the name and address from the distribution list into the report being printed for it To get to this option select Tools Options and click on the Test Reports tab then check the checkbox labeled Put distribution list addresses on reports When this option is selected the program knows where to print the distribution list information by referencing a field map that associates a distribution list field with a field on the report This map is defined using Tools Options the Test Reports tab and then the Setup Distribution List Map button The form looks like the example shown in Figure 15 Distribution List Field Map lt x m Select Distribution List Fields to Replace Company Fields CLIENT ccoMP ccc CADDR cca z CADDR2 ccaz CADDR3 cca3 CADDR4 ocad Figure 15 Distribution List Field Map The tit
79. etup Initial setup requires the selection of a few preferences Select Tools gt Import External Data then on the form that follows select Setup e Import File Format From the list of file formats select the one you are using Admet No job ID is for Admet files where the header looks like this when you open the CSV file in Excel 103 Index SPEC SPEC TIME IDs TYPE 8 01 10 03001E 0 AREA sqin 28 24 LENGTH PEAK in Lb 125001 PEAK psi CORR FACT 5182 1 BREAK TYPE DATE 1 3 17 2003 12 For this format all of the SPEC ID s must be unique in the entire QC Concrete Break Table so begin numbering specimens with 000001 and continue through 999999 or higher if the Admet system allows more digits This format is always saved as a comma separated value file Admet With Job ID is for Admet files where the header looks like this when you open the CSV file in Excel SPEC IDs SPEC TYPE 3001 0 AREA sqin 28 24 LENGTH PEAK in Lb 125001 PEAK psi CORR BREAK AGE JOB FACT TYPE days JIDE 5182 1 0 56 DATE TIME 1 3 17 2003 8 01 10 12 For this format all of the SPEC ID s are combined with the JOB ID to form a the unique specimen number in the QC Concrete break table So the first specimen number shown in the example would be specimen number 3001 5 in QC Concrete Be sure to remember the decimal point between the SPEC ID and JOB ID when entering the specim
80. f actual date is not the scheduled date Check this box to have breaks falling below the specified strength be shown in red and breaks broken on a day other than the day scheduled in yellow Duplicate dimensions from the previous specimen Check this box to have the dimensions diameter area sides etc be duplicated from the previous specimen 19 User Preferences e List of standard break notes Certain custom report forms are set up to use one of the break table fields for an extensive note such as B The 7 day result projects that the specified strength will likely be met at 28 days according to a typical strength age relationship 7 days To save the time of typing such a note repeatedly they can be entered here for use with the custom form Add new notes by entering them in the dropdown box and then clicking on the Add button To delete an entry select it from the list and press F6 function key F6 To restore an accidentally deleted note click in the box and press Ctrl V to paste the deleted entry back in e Number of characters displayed To limit the number of characters displayed for a standard break note Some notes can be very long and displaying the entire note can be difficult to view Click RESET to restore the default calculations for There are standard properties calculations for each Test Type Clicking on the RESET text replaces the current properties with the default properties Note Refer to Sectio
81. f specimen number is not unique in the entire database War v Prevent M Figure 8 Duplicate Specimen Options in entire database Note Requiring unique specimen numbers in the database is not compatible with the option to suggest the next specimen number based on a project It can only be used by counter or with no specimen number generation at all See section 3 2 3 for more information 3 2 8 Warn or prevent if specimen number is not unique in the report With some specimen numbering conventions all specimen in a given set of specimens aka report have the same ID number To allow this Warn and Prevent must NOT be selected For other numbering schemes and if you will ever need to archive retrieve or merge a branch database these must be selected Figure 9 Duplicate Specimen Options in report 3 2 9 Reporting Compliance with Strength Specifications Some custom report formats will report whether or not the average test strength meets the specified strength Users with this sort of custom report should have this option enabled Check to insure hat is by selecting Tools Options and on the General tab check where it says Use checkboxes 0 1 2 and 3 for reporting required strength compliance Users with this feature on their custom reports may also see checkboxes on their data entry screens labeled something similar to 12 QC Concrete Reference Manual O Meets specified strength checkbox 0 O Did not meet s
82. for all reports on a given project and only needs to be entered once Note Changing the Project Data for any report changes it for all reports The Project Data entry screen appears as shown in Figure 25 44 Tests Selecting and Adding Concrete Test Report 2000 123 1 2 Cast cylinder Attn Harold Jenkins Client Advanced Professional Eng Address 363 West Drake Suite 10 Address Fort Collins CO 80526 Figure 25 Entering Project Data QC Concrete Reference Manual A Test is a particular sampling of a cement product and the casting of its specimens Companies refer to a test in various ways and even in this manual the program itself and the help system various terms may be used So consider Report Set and Test Report to be synonymous terms The test s Project Number Report Number and optionally Placement Date are used to uniquely identify the test and retrieve it The data gathered in the Test is referred to in this program as Field Data and Break Data discussed in the next section Tests are selected by picking the Placement Date if dates are being used and the Report Number Any information which is specific to a particular test is considered to be Field Data In the QC Concrete program 58 items of Field Data may be entered For a typical cast cylinder these are Date Sampled Date Placed Date Submitted Location of Sample More Location More Location Placement Description More Placement
83. g Compliance with Strength Specifications 3 2 10 Warn If Report Has No Specimen ccccccscsscscscssscssssssssesecssssesecesscesesesececeseceseseseensseceecacecscececeeeenseseeeeeseeeeeeneneenees 3 2 11 Tips Warnings and Confirmation Prompts Local 3 2 12 Enabling the Program in Use message Local 3 2 13 Default Fracture Type sss 3 3 OPTIONS ON THE REPORT SETUP TAB 3 3 1 Selecting a Template to be Used with a Test Type 3 3 2 Setup for PDE File Crean i i eee EUH RET Ee e est 3 3 3 PDF Storage Folder for Project and Default Folder Setup 3 3 4 Changing the Data Entry Prompts Active Fields eese ettet tenete tette eee 3 3 5 Changing the Checkbox Arrangement ss 3 3 6 Changing the Break Table Arrangement 3 3 6 1 General Break Table OptlOlis 22 ctr t e e e n b e eia e aree Pies e pete dete ete 3 3 6 2 Properties for Break Table Field 3 3 7 LO BO Sizing Cheekbone ee hong tegi red utile e ii gera ee REPRE IHRER 3 3 8 Report Printing Sequence su aen tga og e e RE RE REV EG ie a aes ee eee Shas 3 3 9 Distribution List Options 3 4 SETTINGS FOR BREAK LISTS ses sessessenzenzenzenzenzenannanannanznnznaznaznannanta 3 4 1 Name of Template to be Used for Break Lists 3 4 2 Specimens to be Included s RS UR SE SMS NOE MENDES SERO I a 3 4 3 Specimen Sort Order for the Report eee e t PERMET I ee ern e D P ERU Then 3 4 4 OMIt RESCTVES PEE 3 5 SET
84. i Nans PROJECT Typs ol Field Pire Tre Type of Feld Proc Test Longh al Fed 50 Langh cl Fick 50 hax Langjh 5 Figure 11 Setting Active Fields If the need arises select Tools gt Options and click on the Report Setup tab Click on one of the test types in the listbox on the left Click on the Data Entry Settings combo box and select Field Data Prompts Active Fields Click on the command button labeled Edit Selected Item Editing is done as follows To make an inactive field active Click on the inactive field then click on the blue right pointing arrow To make an active field inactive Click on the active field then click on the blue left pointing arrow e To change the title of a field Both active and inactive fields can have their titles changed To do so click on the active inactive field then click on the title textbox and make the changes To change the allowed data entry length of a field To change the allowed length click on the desired active field then enter a maximum length in the Length of Field text box It can be any number up the maximum length Set Default Fields Each test type has a factory default set of active and inactive fields If things are really out of whack choose Set Default Fields to use the best arrangement of active fields for that test type Other information the form Other information on the form includes Database Field Name The internal name used to refer to the database fie
85. ick this option Note that Data Entry Screen settings below the dark line are local meaning they only affect the machine they were set on Percent of screen for start of second column Local When the screen layout is set for 2 columns the second column can start at a position determined by the user There is a minimum position of 4000 twips which is 55 at VGA resolution 33 at SVGA resolution and 26 at XGA resolution e Use 2 colors for rows of the break table To make it easier to keep track of which specimen is which you can have alternating rows be different colors The color used is the system color assigned to 3 D control button faces so you don t have a whole lot of choice 3 6 2 Selection Titles Terminology applied to the selection fields varies among laboratories The title to be displayed for the Project selection Report selection Test Type and Date selection list boxes can be set by the user here The width of normal of each title can also be set You can adjust the width of the 3 report selection combo boxes and the Test Type selection box Set the values for of normal to 100 to use the factory default widths Set the widths to greater or less than 10046 for sizes that fit your terminology better The setting for widths is a local setting it does not affect all users of QC Concrete 3 7 Changing the Data Entry Screen Layout You may wish to re arrange the positions of the data entry prompts This section de
86. id paths are treated as though they were blank and reports are sent to the printer Unless set up this way to produce PDF files all new projects will be sent to the printer An explanation of these setup options follows e To select create a PDF storage folder click on the Browse for new path button e To set the PDF storage folder to the default location click on Set to default path e To set the default path in the Default Path frame click on Browse for new path This is also set changed when you pick a folder on the print preview form NOTE PDF files created by QC Concrete are editable by the recipient To make them read only using the RC4 security method from RSA Corp you will need to use Adobe Acrobat not included with QC Concrete PDF file names are created using the Project Number Report Number and current date or placement date see below for how to set which date As an example the PDF file name 2003 FC 0005_1_10 01 03 PDF is from project 2003 FC 0005 report number 1 printed on 10 1 03 Summary Reports Project Reports Mix Reports and Break Lists also may be created as PDF files if desired To do so click on the PDF button on the preview The file will be saved as ProjectReport_Date_Time PDF and etc For the reports the folder designated as the default storage location is always used 3 3 3 PDF Storage Folder for Project and Default Folder Setup To select the PDF folder and default PDF folder go to Tools Options Report Set
87. identification numbers before importing D 4 Importing a Break Data File To import a break data file select Tools Import External Data In the Data Import Source frame click on Select and navigate to the folder where the data acquisition D A file is Then select from the list of files the one you are importing Clicking then click on Import and Merge Data starts the import process If errors are encountered during the import and merge a red error message will be displayed The error will also be listed in the table of merge results D 5 Tutorial Use one of the supplementary demo data files e Admetl csv example comma delimited e Admet2 csv example comma delimited with ID field at the end AMTD16Test example Advanced Machine Technology ForneyTest example Forney 105 Index 10 11 12 13 14 They are supplied with the program for this tutorial Prepare the data acquisition demo by running the setup program DATutorialEXE which is in your QC Concrete program folder When you run it you will be asked for the folder to install to select the same QC Concrete program folder i e CAPROGRAM FILES GEOSYS or ZACONCRETBREPORTS whatever the case may be Run QC Concrete select Tools Adminstrator Tools and click Browse for a new database location Locate the folder DATutorial in the QC Concrete program folder and double click on it to select it as the new database location Click OK then OK then OK a
88. ing data at the Mix Number field double click on the data entry field for Mix Number or click on the mix tool button and select a mix That mix is automatically entered in the Mix Number field At the same time the Supplier Design Strength and Primary Design Age will be imported from the Mix Table to the Field Data Table More information about the mix database is in Section 5 Scrolling through data from previous tests To save time any particular Field Data field can be quickly filled with data for that field from a previous test When the data entry cursor is on any of the Field Data fields press Ctrl or Ctrl to scroll backwards and forewords through the data 4 4 4 Cut Copy and Paste Field Data When editing Field Data any information entered can be cut copied and pasted between data entry fields To do so highlight either with the mouse or shift arrow keys then use Ctrl C to Copy Ctrl X to Cut and Ctrl V to paste 4 5 Breaks Selecting Adding and Entering Data Results of laboratory break tests on specimens are entered in a table at the bottom of the main data entry screen Each specimen gets a row in the table To access Break Data for a specimen first select the test to which the specimen belongs by setting the selection boxes to the test s Project Number Placement Date if used and Test Number If the Specimen Number has already been entered you may go directly to it by choosing Edit Find a Specimen or by using the
89. ing date is 01 31 2006 All ages of specimens Current Report Format SUMMARY23 SRP Export text file SUMMARY 23 SRP landscape small font PROJECT REPORT SLUMP YIELD AREA STRENGTH SPEC Figure 53 Test Selection Criteria for Testing Summaries Selection criteria options are explained in the following sections 6 3 1 Testing Summaries Date Criteria If starting and ending dates are entered as criteria the summary will only print specimens tested within that time frame The dates can represent either the date placed or the date broken depending on which option is selected The date selection form is shown in the upper right hand corner of Figure 53 6 3 2 Testing Summaries Project Mix and Test Type Criteria In the Category of Selection Criteria box click on Project Mix and Test Type Criteria Use these to limit the Summary Report to specific Projects Mixes and or Test Types The selection form is the same as Figure 53 but the upper right hand corner changes to 62 QC Concrete Reference Manual Project Mix and Test Type Criteria Project none Mix none Y Test Type Cast cylinder Y Figure 54 Selecting Project Mix and Test Type Criteria for Testing Summaries Select from the lists of Projects Mixes and Test Types the limiting criteria Note Test Type defaults to Cast Cylinder but can be set to none meaning all Test Types qualify 6 3 3 Testing Summaries Lab Test Criteria Summary
90. int the program allows selection using placement and sampling dates Currently selected report only The program only prints the currently displayed report Reports for a single date The program prints all reports which contain specimens with on the date specified Change the date by entering a different date or clicking on the forward or backward arrows Reset changes the date to the current date Reports for dates between first date and second date The program prints all reports which contain specimens with dates in the range of dates specified Change the dates by entering a different date or clicking on the forward or backward arrows Reset changes the date to the current date All unprinte d new reports XX new reports found The program prints all new reports and then marks them as printed They are only a new report once adding break data does not make thema new report again Limit to project number The program only prints reports for the project specified Omit reserve specimens age age Check and enter the age of the specimens to ignore when picking reports by Break Date Enter 0 to exclude any specimen with HOLD or SPARE or other text description entered for the age Omit reports with specimens older or younger than Check the box select older or younger and enter the maximum age if omitting reports containing older specimens or minimum age if omitting reports containing younger specimens Other Report Printing Opt
91. ion Test Selection Criteria Summary As selection criteria are added they are summarized in this area Its purpose is simply to provide an easy confirmation that the criteria chosen were the ones desired 8 2 CPR Export File Names Exported File Name and Path Name You must export the data to a file in the CPR program folder Any standard 8 character name can be used QC Concrete will add the file s name to the CPR file name index and create the PDT project data file and TDT test data file Note It is often convenient when routinely doing statistical analysis on the same mix or project to export to the same filename each time You will need to confirm that it is OK to overwrite the previous file Existing CPR Project File to Copy If a CPR file exists which contains all the project and mix information that you would like to report in the new statistics report enter or browse to the existing CPR project file When would you want to use an existing CPR project file Many large construction projects require the periodic statistical analysis of concrete Using the CPR project file created the first time statistics are done will save time 78 QC Concrete Reference Manual Section 9 Administrator Tools and Multi User Capability The Administrator Tools are use for a number of infrequently performed tasks 1 Status and maintenance of the program s multiuser capability 2 Checking database statistics such as number of reports
92. ions Print a report for each name on the distribution list This allows the user to override the default setting for printing not printing a report for each name on the distribution list It does not change the default setting See Section 3 3 9 for more information Include option to print envelopes following reports Select this option to have the program print envelopes after printing the reports See Section 6 1 5 for more information Always show this form before printing Check this box to always see the selection criteria before printing Export text file optional feature Check this to export the selected reports to a tab delimited text database instead of printing to a printer This is an optional feature not included with the standard program Update After changing the selection criteria press Update to determine the number of tests selected PDF Report Printing Options Normal PDF s Adobe Acrobat Portable Document Format files will be created for all reports whose projects are designated for PDF s Reports for projects not designated as using PDF s will be sent to the printer 52 QC Concrete Reference Manual PDF only PDF s Adobe Acrobat Portable Document Format files will be created for all reports whose projects are designated for PDF s All other reports will be ignored not printed Hardcopy only Ignores PDF designation on projects and sends all reports to the printer 6 1 4 Printing Test Reports
93. ir positions You can also change the title at the top of the section just right click on it and enter the new title Select Tools gt Layout gt Arrange Field Data Section again to turn off the arranging mode 3 7 5 Screen Arrangement Tips Drag and drop To drag and drop point to a prompt When it turns red hold the left mouse button down and move to a new location on the screen A little gray box attached to the mouse pointer indicates the prompt is being carried Drop it on top of another prompt and it will assume a position immediately following it If the destination is more than a few fields away you may need to drag it drop it scroll the screen and drag and drop again Selecting which fields are active Refer to Section 3 3 2 Selecting Active Fields Shortcut to the Layout menu Point to any Field Data prompt and right click the mouse Grouping Checkboxes Checkboxes can be grouped so that only one box in the group can be checked at a time Information which is best conveyed as Yes or No can be entered and displayed as Checkboxes Examples of this type of information are Were the specimens field or lab cured and Was a hi lo thermometer used in the cure box Refer to section 3 3 5 Changing the Checkbox Arrangement for additional information 3 7 6 Title for the Screen At the top of the Field Data screen there is a title describing the input screen for that type of test To change it select Tools Layout Arrange Fie
94. irections above and Test aka Sample or Specimen Database You should have written down the name when performing the steps in A l If yours is a custom DTRC you may have a mix database too if so enter the name now as well You should use the name recorded when performing the steps in A 1 4 After the DTRC Project Database has been selected the projects in it will be listed click on the project to be imported Shift click to select a range control click to select multiple individual projects To select all projects click on the first one then scroll down to the last one and shift click on it 5 QC Concrete has a larger and somewhat different database structure than DTRC This requires mapping a correspondence between DTRC data fields and QC Concrete data fields This would not be a big problem except for the large number of custom programs with custom structures If you have a custom program you should check and adjust the fields before importing Check the field maps for all 3 databases 4 if DTR2CQC reported a mix database Checking the field maps means looking for any obvious mistakes Check each map by clicking on the database name then clicking on Show Field Map Le the Project field map will look something like Map COC C and D TC Data Fields Conn rion Gusty Corvin Dents tener Hane E MAVGOMINBICOD CPAGOD CP MDB OTRO Qnem t Name prac FIELDS SAMPLE DATA coc cP FIELDS mene bd cuter CAMPBELL SOUP COMPANY C
95. k NEED mun Lapis anyones abei ea VNTMO musa sasies yrs Dtr vite mM SUPT NOE idee MERE Mlse t Ib al b 3i pn amaes manem ET EORR RECOTTI amaer sanem mua f Il bel det qnangpees Iti Vaky Mise t EILE PME arat yee mue Barsat mrw asas VrIMO maaie P bri R b mrm 1 1 ENE Militie ETENE ETET diu piter Tiled bet 5d i l t 5 diaper aa NONEM LU AORERE BR yvy o Ade fM whem Mise PILL Pine ms Fee tors Figure 58 Format SUMMARYTI includes Diameter Figure 59 Format SUMMARY includes Report and Area Number and Field Data ioraa ratate nenat S RE E Licenses Crowa More wee Bk deed memoga AID HET P Pa Ai Fami snes noae peine D desi a Bin Wasje aa intent Tat TAI FD 00 a wwr eres WV boot m043 Fo 00 Af WALI pow aed Bada ote ere Ibert WM verre amaa wisa missha JIFTA wearer misss aArsereudges WER TON LEE dibdrard 8 Wanaona muros arracwa wien ja Cul LI srl draws ACH dab mua mires ees wrur dab sere 2 tries wiwi dab ww aa ee eo ah cua mies apaa WOO JEW Gwwdnzli ere ere WW bii 4 dte Gew ardere cw wipe a fi reo Figure 60 Format SUMMARY3 landscape orientation including Field Data and Dimensions 65 Printing Reports fe bwa A mure otni Terp Turpe D S wee ET Ear Lutim I 1 piwem m qo im Lib ULU LA Late tert rUe 4s UE jk UVR eC ox oP eri xii c pec Ett ENS A her vr TEE CERETTO POETI Iet v t tet irven DEDER
96. ld Type of Field The type of data handled by each database field Report Name The name of the report currently used by the Test Type 17 User Preferences Test Type The Test Type for which the active fields are being edited 3 3 5 Changing the Checkbox Arrangement None of the standard reports include checkboxes however many custom reports do Rarely will the user need to make changes here These instructions are included for the possibility that for certain custom forms the user may need to make minor changes to the checkbox arrangement The form for working with checkboxes has the following appearance check Ben Crewe for Peer CHEEASECR NOTE A group of check bowers ofows only one to be checked ste ime Pthereis e delmult checkbox pet then twill be checked suometicaly when al other boes are unchecked Dak Bos Maree Grove Hurta 1 2 3 4 Pinasa Nehhod Purp G r r r a CE Placaersant Nahot Burkat Cins r r ec Qaresi Placersert Nahot Track Chote Pissarment Melt Wheeler Buggy E 7 r r c Placansant Hafod Othar ka 1 f c Saied Fint Banioled Hise Sarmisi Ent Unde Engkth Unis 8 Figure 12 Configuring Checkboxes Checkboxes have only 2 values checked and unchecked Additionally there may be groups where if one is checked the others should not be Such mutual exclusivity is of value on reports where there are fields such as Field cure box heated O Yes LI No There are 10 checkboxes available for data entry and a m
97. ld Data Section or right click on any prompt and select it from the local menu Right click on the title and enter the new one in the input box 28 QC Concrete Reference Manual Section 4 Data Entry When using QC Concrete you will spend most of your time starting projects adding tests to these projects adding break results to these tests All of these tasks are described in this chapter 41 The Data Entry Screen When QC Concrete starts the opening screen displays three sections It will appear similar to the following example DK CEMENT PRODUCTS zz 2 20 2000 2710 vrai Advanced Professional Eng Fort Colins CO 80526 363 act Drake Suite 10 Fort Collins Zao Primete Habisi 1 103 BBM BIA MEAM BNOC 5 MIDDLE SECTION 2000 FOR ENTERING Harvey HELD DATA E first cage broke setting used another Figure 18 Main Data Entry Screen The top section is the Test Selection section which has the data that uniquely identifies the test and the type of test The middle section is the Field Data section which has information about the project placement location and conditions mix and tests performed in the field The bottom section the Break Data section has information about the individual specimens broken and the strength results Some easy changes may be made to how this screen displays this data 29 Data Entry When entering Field Data it may be preferred to simply view the Field Data and
98. lds are shown on each line of the report There are 5 project report templates included with the program To print a project report select Reports gt Project Report The form displayed lets you pick which project report template to use which column to sort on and whether or not to include inactive projects 67 Printing Reports Plies Project report template Pelee PROJECTS PAP vz Include Inactive Projects PROJECT 4 PRP C Yes No PROJECTS PRP b Template Properties Column Contents Sort Key 1 CCOMP c 2 CONT NUM C 3 C amp DDR C 4 CADDR2 C Ges ee Figure 63 Project Report Options Whichever database field is in the first column will be included in the report without duplicates While there won t be duplicate project numbers or at least there shouldn t be there will be duplicate clients For instance if the Client Company CCOMP is in the first column that company will only appear once on the list even if there are several projects in the database for that client Examples of the 5 standard reports follows i d Cement Products Report A wa 1 b Q l Project list Project Number 2003 FC 0001 10A403 Client Mr Crawford O Neil 2003 FC 0002 Permimen Architecture Figure 64 Heading of Project Report PROJECT1 PRP cement Products Report qd i Q l Projedt list 104403 Project Client Number Project Geermald Construction 2003 FC 0006 Harold Jenkins 2003 FC 0010
99. les in the left hand column are the fields printed on most reports The selectable fields on the right are the distribution list fields which the program will then substitute for the report fields when the distribution list copies are printed Ordinarily this will be set at the factory and not need changing 22 QC Concrete Reference Manual 3 4 Settings for Break Lists Break Lists are reports listing specimens to be broken on a specific day Break List reports have some setup options that should be set to your preferences Select Tools Options and click on the Break Lists Setup tab The tab will have the following appearance Options Geveral Repxt Sep Break Lint Setup Colors Dates snd Fonts Screen Lapcot Name of template to be used for beeak hats BRK LISTI BAP poliai bresat lit repat wl Specimens to be included Specamen Sort Order tar the Hepoit AL urbroken sgecrmen upto and irclo ng fne break dale Nene Unbroken and pornzlusalju biaken spacer for the exact break date C Alphebelc sot 7 Dnb unbroken specimerz for ths enact break date f S MEREIS Fae Project Repat Spec inen rico speamen rembe sat do no use d Unit Reserves your specimen numbere contain nonnurmernc character Es x he B e Omit reserve specimeee age hola Pinject Date Report Na sort Pigect Report rumetc Fisports orb Specinen numeric specimens orb Figure 16 Options Screen Break List Setup Tab Select the appropriate set
100. lly before printing There is no option to override this preview When the preview is displayed click on the Print button to print the Break List Click on Close to close the preview without printing Refer to Section 6 1 5 for more information about previewing Note If you need a break list for more than 2 days ahead or 1 day behind use one of the last 2 options There you can enter any date or the number of days plus or minus or from the current date There are numerous standard break list report formats Many of these are minor variations of others which were added to meet the needs of a specific customer Select the format desired using Tools Options Other Reports Samples of some of these reports are shown here 59 Printing Reports Leareta Compares ie ries nt kor VE 140 mere re ng UE E Cran ME IO OF OR E iji i H H E DE Figure 46 Format BRKLIST2 landscape orientation Figure 45 Format BRKLISTI basic Vismmaen C onpory Maree Lisemaee C ompany Nure tO Pk ae caer ers Pedo uem mil uem La m s db om een mid Od Ded Gp ens beets gown ml em 14 mobs db om oen Figure 48 Format BRKLIST4 shows Prior Breaks Figure 47 Format BRKLIST3 shows Prior Breaks and Specimen Type QC Concrete Reference Manual Voie CONE Ni A V SCA DE Apri WE MCG C4 8 MN t MUR ACC Ay NC
101. m do this select the appropriate option as shown below Figure 6 Option to Give Edited Reports New Report Status On the top of the report data entry screen is some information about the report If it is black and includes the word Printed then the report s status is printed The following illustration shows a report with printed status Concrete Test Report 591003 24 1 Cast cylinder Printed Figure 7 Title on Report with Printed Status Similarly if it is unprinted the title says Unprinted and is colored blue 11 User Preferences 3 2 6 Average Test Strength The program can automatically find the average test strength for you To enable this option select Tools gt Options and on the General tab click where it says calculate the average test strength When this is activated the average strength for each of the specimens having a strength at the design age It is inserted in the field Average28 whenever the strengths for the design age specimens are recalculated 3 2 7 Warn or prevent if specimen number is not unique in the entire database With some specimen numbering conventions each specimen has a unique ID number To alert the user when a previously used specimen number is entered check this option The duplicate specimen warning occurs in a message box but does not prevent the user from entering the duplicate To prevent the entry of duplicate specimen numbers check the box labeled Prevent I
102. mary viewable using Adobe Acrobat The file will be saved in the default PDF storage folder if one is designated otherwise it will prompt for a location See Section 3 3 2 for additional information QC Concrete Reference Manual e Show previous next pages M 4 2 4 Ar If the report continues on subsequent pages you may preview the subsequent pages prior pages using the and buttons on this control e Show first last pages M4 2 4 gt If the report consists of more than a few pages you may go to the last first page using the and buttons on this control e Zoom in out Q l Whole Page Page Width Two Pages Thumbnail 150 100 75 50 25 Change the magnification of the report by clicking on the magnifying glass or drop down the list of view magnification options When zoomed the area viewable can be adjusted by holding the left mouse button down and dragging the little hand the direction you want the report to move Double click on the report for the next larger zoom setting 6 4 Mix Reports Mix Reports list the information for a particular mix or the information for all mixes used on a project or set of projects See Section 5 2 for additional information 6 5 Project Reports Project reports are simple lists of the contents of the QC Concrete project database That databas e contains the information specific to each project such as Client Company Distribution List etc Up to 4 project database fie
103. mport data from another ODBC database which you may have already available as part of you business record keeping process For additional information about this option call GEOSYSTEM Software The following sections explain in detail selecting projects adding projects and entering project data Selecting Projects Existing projects are selected using the Project Number drop down box as illustrated below PROJECT NUMBER 2003 FC 001 D X 2003 FC 0001 2003 FC 0002 2003 FC 0003 Attn Harold Jenkins 2003 FC 0004 2003 FC 0005 Client Advanced Prof 2003 FC 0006 2003 FC 0007 Address Fort Collins CO 80525 Figure 21 Selecting Projects Click on the dropdown arrow and either select a project from the list of projects or begin typing the project number the program will search for it one character at a time Whenever the Project Number is changed the lists of Test Numbers and Sample Dates if used are updated for the new project 31 Data Entry 4 3 2 Adding Projects and Selecting a Project Template To start a new project click on the fn icon in the toolbar or select Edit gt New Project Projects can be added 3 ways as discussed at the beginning of this section More information on each of these is given in this section The New Project form has the following appearance New Project Enter a new project number or select from existing projects v New project 2003 FC 0027 Existing Data Manager projects
104. n 3 6 1 for instructions about how to set the sort order for the specimen table 3 3 6 2 Properties for Break Table Field Chances are there will never be a need for a user to re configure the Break Data Table titles column widths numeric formats or calculations In certain cases users with custom reports may need to do so If the need arises select Tools gt Options and click on the Report Setup tab Click on one of the Test Types in the listbox on the left Click on the Data Entry Settings combo box and select Break Table Layout Click on the command button labeled Edit Selected Item and you are ready to configure the break table for that test type Select the column you need to change by clicking on the database field name in the list on the left The database field names are fairly meaningful except Dim1 Dim2 and Dim3 Diml is the diameter for cylinders and Dim1 and Dim2 are sides of cubes For beams Diml is the width Dim2 is the depth Dim3 is the span and area is the distance to the support when the fracture is out of the middle third of the beam See the illustration below for help with these dimensions width b Jal sp I b depth d Figure 14 Beam Dimensions Note The names of the fields in the break table may or may not indicate their use e g the field Area may be used for distance outside of center third in the case of beams After selecting a field make changes to the properties for that field as follows
105. n Set Default Values Some custom reports include the Pass Fail test result This is automatically determined by the program by comparing the average strength with the required strength Occasionally a test may fail but reporting that it failed may not be desired In that event the Not Applicable checkbox may be checked to override the program s determination Other custom reports allow overriding a failing test under ACI 318 criteria 4 6 Shortcut Keys To assist with certain frequently performed tasks the program has some shortcuts and local menus Find a Specimen Press Ctrl F The Ctrl key and the F key at the same time Find Again Press F3 Function Key F3 Enter Break List Data Press Ctrl B The Ctrl key and the B key at the same time Layout Point to a label or the break data table and right click The layout menu pops up 43 Data Entry Cut Copy and Paste Highlight either with the mouse or shift arrow keys any Field Data or Break Data Then point to the highlighted data and right click A menu pops up that will let you Cut Copy or Paste e Insert a Date Point to a date field like date sampled or placed if you are entering the data the same day it was sampled or placed and right click Right click a second time and get the option to insert a long medium or short date e Insert a Fracture Type Point to a fracture type field and right click Click on a fracture type to have it entered QuickData QC C
106. nce Break Table Setup for Template BASICU CRP E General Brenk Table Options for BASICO CAP Cast cylinder Number of insa lere beck isle e 11 2 RED Dkabie sl stonsic cskusimn Tuin pow red E bed specified rimrjh ard yellow il sctud dele amp not the scheduled date Duckoshe dnevniorw Iram te previous specimen List of standard breat motes which wal bes avs sbie in the column with the Diopdomn fon M EL gj EA Number of characters p dsplayet Cick RESE F to ore Gye defauk calodabone for Cast ceder Properties for Break Table Field SpecNumber 15 Selected Field I Visible Inset delak iachwe ypo 7 Disedoninict P Min column widh Ckudenwak ee Calcsdalion component Nore l Numeric Format test Equation for Calculation No Ea aie mn m Agape fl THeaz hna ActBieskDale 8 sl Tifelne 3 I Nowe selected ja field up Tile Ine 4 Figure 13 Configuring the Break Table 3 3 6 1 General Break Table Options These are settings for the entire table Number of lines for the break table title Set for 1 to 4 depending on the complexity of the column titles If set for less than 4 some lines of the title in the properties frame are disabled Disable all automatic calculations Check this box to prevent the program from calculating break dates stress area etc from the measured data entered for a given specimen Turn row red if below specified strength and yellow i
107. nce Manual If you are using dates as part of the report selection enter the new Date Then enter the new Test Number Click on OK to add the test if the Report Number and Date if used match an existing test it will not be added as a new test Note QC Concrete has an option to increment test numbers automatically If you would like each new test to be numbered one 1 greater than the previous select Tools gt Options then click on the Automatically increment test numbers checkbox Likewise if you do not want these suggested test numbers turn the option off You can save some time if the new test has similar field data to the most recent test for that project Check the box labeled Repeat data from this project s most recent test All of the Field Data except Checkboxes is copied from the most recent test 4 4 3 Entering Field Data A test s Field Data occupies the same screen area as the test s Project Data It is entered in the same way by typing the data and pressing Enter or Tab to move to the next field There are several special Field Data items the Test Type Placement Date Mix Number and checkboxes e Test Type Although the Test Type is part of the Field Data for a test it is selected differently using a list in the test selection area It is handy there because being a list it is not easy to include it on the main data entry screen and because the Test Type controls the way the data entry screen appears CQC FD support
108. nd the program will shutdown Admet amp AMTD Restart QC Concrete and select Report Number 03001 There should be 12 specimens and no load diameter area strength etc Forney Restart QC Concrete and select Project Examplel and Report Number 1 There should be 4 specimens and load and strength only for the 7 day breaks Now for the import click on Tools gt Import external data The Import External Data form will be shown Click on Setup and select an Import File Format for the tutorial Admet amp AMTD Pick Admet No Job ID Admet With Job ID or AMT D16 for the Advanced Machine Technology D16 then click Close Forney Pick Forney then click enter Click on Select and select the drive or network location where the QC Concrete program folder is then navigate to and open the DATutorial folder then click OK Admet amp AMTD Select the file Admetl csv Admet2 csv or AMTD16Test depending on whether you are importing a Admet No Job ID Admet With Job ID or AMT D16 type of break file note that there is no data import example for the Admet tabbed file format Forney Select the file ForneyTest csv Click on Import and Merge Data after records are merged there should be a message that there were errors during the merge Scroll the Merge Results table to the right to show the status of each imported record You will notice most are Merged but some list an error message Click on Save merge
109. not necessarily recognize or sort specimens like 15A 15B 15C possibly giving the C specimen before the others etc Project Report Specimen numeric Lists specimens by Project Number Report Number then Specimen Number numerically Project Date Report Number sort Lists specimens by Project Number Placement Date Report Number Project Date Report No numeric Reports only Specimen numeric Specimens only Lists specimens by Project Number Placement Date numerically the Report Number and numerically the Specimen Number 3 4 4 Omit Reserves Check this box to omit reserve specimens on the break list Reserve specimens are those designated to be held for future testing only if needed They are identified by their age entry which can be a specific number such as 100 or some text such as Reserve or HOLD 3 5 Settings for Screen Colors Date Formats and Fonts QC Concrete allows choosing certain screen colors formats for dates and data entry fonts Instructions for each of these are in the following sections 3 5 1 Setting Colors Local Select Tools Options and click on the Colors Dates and Fonts tab to access color options The colors chosen are a local user option affecting only the machine on which the colors are selected Options available are Click on Color Panel to Select In the Set Colors panel find the background that you want to set the color for and click on the color
110. nt a report for each name on the distribution list 52 Printer Setup 70 Printing 51 Printing Test Reports 53 Program in Use message 13 Program in Use Warning 79 Project data 31 Project number 44 Project Reports 67 Project Template 33 Properties for Break Table Field 20 Q QuickData 37 R Renaming Projects 82 Report data 45 56 Report data title 84 Report Data Titles 83 Report format 13 23 Report number 44 Report Printing Sequence 21 Report selection criteria 51 Report Setup Tab 13 Report with No Specimens 13 Reporting Capabilities 5 Reporting Compliance with Strength Specifications 12 Resizing rows and columns 40 Resizing tool buttons 30 Retrieving a project 74 Running the program after a program crash 13 S Selecting Projects 31 Selecting report templates 15 Selecting Test Reports 51 Selecting tests 36 Selecting Tests 30 Selection fields 27 Setup Distribution List Map 22 Shortcut keys 43 Shortcut to the layout menu 28 Show or hide the break data section 30 Show or hide the field test data section 30 Sorting test numbers 11 Special characters and symbols 44 Specimen numbers unique in report 12 Specimen Sort Order 23 Specimen sorting 23 Index Specimens in the database that were scheduled but skipped 23 Specimens inadvertently tested early 23 Specimens to be Included 23 Standards title 84 Standards Titles 84 Statistical analysis 77
111. numbers checkbox Likewise if you do not want these suggested specimen numbers turn the option off To make it easier to follow a particular row of data you can set an option to use a different color for alternating rows See Section 3 6 1 for additional information 4 5 3 Entering Break Data Some general considerations about entering break data are e To edit the data for a particular specimen click on the cell that contains the data Click again to set the edit point or press F2 to enter edit mode As data is entered for a specimen pre defined calculations can occur These include break date area strength modulus of rupture and percent of required strength e Whether or not the cursor skips over calculation results is also a user option as discussed in Section 3 6 1 e Any number of specimens can be entered however the report format being used to print them will probably be limited to 6 8 or 10 specimens If more specimens are entered than there is room for on the report additional reports will print e The layout and calculations of the Break Data Table depends on the test type and if needed can be configured by the user Section 3 3 6 has additional information about configuring the Break Table e For C 78 Beams third point if the fracture occurs outside of the center third enter the average distance from the nearest support to fracture in the column Distance to Support Outside of Center e If there is more data in a field
112. ny other Reduce the program load on your PC tasks currently running then switch back to this task and select Retry Select Cancel ONLY if you still cannot continue A database field field name required by this report is Ok to continue on through but call tech support for a missing Continue anyway replacement report template BrkLayout error in txtInput_LostFocus call tech support Could not begin printing if you are printing over a The program could not print try other applications to see network make sure the printer you have selected is if they can print or make a different printer your default available printer CourierNew and Arial are required to print standard Ok to continue on through Two fonts which are typically reports Refer to FAQ s for suggestions Continue on every PC are not on your PC Have your PC specialist anyway install them 87 Troubleshooting QC Concrete appears to be currently in use by someone You cannot start QC Concrete if another user is creating a else on your network This user is performing some task new report Start the program again momentarily as the which requires exclusive use of QC Concrete Click OK to other user will probably be done within a few seconds Exit Note If you believe this message to be in error you can click Cancel and correct errors in the user list after the program starts using Administrator Tools QC Concrete appears to be currently in use by someone This is just
113. o import each specimen These are displayed in the table called Merge Results The term Merge refers to the process of reading data from one file and correctly placing it in the database or merging it into the database You can save these merge results to a file on your computer or even print them out by clicking on Save Merge Results If you save them the file they are saved to may either start fresh each time or be cumulative appending the latest download to the previous download results See below for information about this setup option The merge results will state the result of the merge attempt for each record The following are descriptions of these results Merged Data imported without problem Break date mismatch database showed 3 31 03 merged anyway The break date found in the QC Concrete database for the specimen being merged did not match the date in the merge file Load field contains data not merged The specimen found in the QC Concrete database contained a maximum load already The user will need to determine if the existing load or the import file load is correct Itis likely in this case that the specimen ID in the import file is incorrect e Specimen 0107577C not in database not merged The specimen listed in the the import file was not found in the QC Concrete database It is likely in this case as well that the specimen ID in either the import file or QC Concrete database is incorrect D 2 Initial S
114. of lines for the break table title also on this form Position The order of the fields may be changed Select the field to be moved and click on the up down arrows to move Note about calculating the area for masonry block prisms The factory default settings for Masonry Block Prisms do not include a calculation for the area per C 1314 If desired add this calculation in by selecting Area and changing its calculation component from Masonry Prism Net Area to None Then change the calculation result from None to Area Check that Diml is set at the Width for Masonry Prism and Dim3 is set as the Length for Masonry Prism Since this includes the area of the hollow it is only valid if the unit is grouted 3 3 7 Logo Sizing Checkbox Also on the Report Setup tab is a checkbox called v Uncheck for lago resizing compatible with older custom templates This is in the program so that older custom forms with logos can be used with versions of QC Concrete newer than 1 6 0 It is not ordinarily needed 3 3 8 Report Printing Sequence Report Printing Sequence Select how to order reports when a batch of reports is printed According to project number then report number 21 User Preferences According to first specimen number on report alphabetic The first specimen number using alphabetic interpretation on each report will govern the order of printing According to first specimen number on report numeric The first specimen numb
115. of tests in the database and improves overall performance while reducing database file size Also for convenient record keeping you may wish to archive the project to the GEOSYSTEM for Windows project folder PROJECT GEO Tests in archived projects are no longer available for statistical analysis however Archived files may be retrieved reincorporating them into the master database e Archiving a Project Any inactive project may be archived saving all the tests in that project to a separate database file and removing them from the main database file To archive a project click on it in the Inactive Project left list then click on the Archive Project button Select a location and filename for the archived project and the project will be archived Be sure to select a standard short 8 character filename with the MDB extension Long filenames will be rejected by the program Retrieving a Project Any archived project may be retrieved inserting all the tests in that project to the main database file The archived file is left alone so the project is essentially in two databases After changes or additions are made to the project that was retrieved it can be re archived to the same database file During project retrieval a report being retrieved may be found to already exist in the database QC Concrete will do one of 3 things when a duplicate is found 1 To have prompts for a confirmation that the existing report should be replaced
116. oncrete at least once after updating to insure that the update was successful and any database changes have been incorporated Make a backup copy of the entire QC Concrete program folder and if the database is located elsewhere back it up as well In the event of a failed update you will need the backup to be able to revert to the previous version For example one way to do this is 1 Double click on the My Computer Icon on the desktop 2 Navigate to the QC Concrete program folder by opening the folders in its path in sequence 3 Right click on the QC Concrete folder icon and select Copy 4 Navigate to C 5 Right click and select New then New Folder 6 Right click on the new folder named New Folder 7 Click on Paste 8 If the database is not in the program folder follow a similar procedure to back it up as well If you are unsure about these directions or how to copy a folder to make a backup have your office computer expert do it for you Insert the new Version 2 CD in the computer where Version 1 is installed If the setup program does not autostart navigate to and run SETUP on the CD The simplest way to do this is starting at the Windows Desktop select Start Run Enter D SETUP select OK D is typical if your CD ROM drive is a different letter use it Read the setup dialogs and do what they say When you get to the Choose Destination Location dialog it will suggest C Program Files GEOSYS If that is n
117. oncrete has a feature called QuickData for lack of a better term that allows frequently used phrases to be saved and quickly inserted when needed If you find yourself frequently entering the same phrases over and over use this feature to save time Right click on the data field twice to bring up the QuickData menu The choices are Dates and any user configured QuickData you have entered The data will be appended to any data already existing in the current data entry field If you select highlight the existing data first then QuickData will replace it instead of appending to it See sections 4 4 3 4 9 and 6 1 7 for more information Scrolling through data from previous tests To save time any particular Field Data field can be quickly filled with data for that field from a previous test When the data entry cursor is on any of the Field Data fields press Ctrl or Ctrl to scroll backwards and forewords through the data 4 7 Special Characters and Symbols The key codes for special characters varies They can be determined by using the Character Map program which is part of Windows It is usually accessed from the Start Menu with Programs gt Accessories gt Character Map Once you have found the special character you want you can copy it from Character Map and paste it in QC Concrete Special characters which are used frequently can be directly entered using the key code Alt Key Code Example In MS San Serif the degree symbol is
118. or Tools Refer to Section 9 8 for more information 49 Report Data Reports often include data which rarely changes like the name and title of the supervisor who reviews and signs the reports This information does not need to be entered every time it is kept in the Report Data database for re use every time a report for a particular test type is printed Details about entering and using Report Data are in Section 6 1 7 Report data also includes QuickData in the last 3 lists For more information on using QuickData see Section 4 4 3 and Section 4 6 45 Data Entry e QC Concrete Reference Manual Section 5 Managing Mix Information QC Concrete keeps a database of mix information Some custom reports use much more mix information than the standard reports do and the Mix Database is where this information is maintained Concrete Performance Report CPR reports also provide more mix information so export facilities use the mix information Also when the Mix ID entered in the Field Data Section the Design Strength for that Mix the Principle Design Age and Supplier are added to the Field Data Up to 3 design ages and strengths can be entered When break results are entered the Percent of Design is calculated based on these ages and strengths To access the mix database click on the mix database button or select Tools View Mix Data The data entry screen for the database looks like Mix Proportions and Specifications
119. or projects 3 Viewing or changing the last specimen number automatically provided by the program 4 Importing data from DTRC when updating from the old Daily Test Report for Concrete program 5 Examining and maintaining the entire database password protected 6 Displaying a list the add ins licensed 7 Changing the location of the database 8 Renaming a project 9 Setting the report selection mode Each of these tasks is described in more detail in the following sections 9 1 Multi User Status Multiple users may access the QC Concrete database a the same time All users have the same rights and identical fields may be edited simultaneously When two users have been editing the same field the last one out wins Tabbing past fields which have been changed by another user causes the screen dis play to refresh and the new data be displayed So it is recommended that if you have more than one user changing test data they should stay in different reports In a multi user environment it may be helpful to know if other users have the database open A message can appear at startup to notify the user of that case To enable the message select Tools Options and on the General tab click where it says Enable Program in Use warning at startup Note that when enabled the message may also be triggered by running the program after a program crash When other users are active their identity is included in the list at the top of the Administrator Tools
120. orkstation some will be universal to all users Follow the installation instructions in Section 1 1 4 and install on the primary user s computer 1 1 3 Standalone Workstation QC Concrete is most easily used on a standalone computer In this case simply llow the installation instructions in Section 1 1 4 and install on the selected computer 1 1 4 Installation Steps 1 Insert the CD in the appropriate computer If the setup program does not autostart navigate to and run SETUP on the CD The simplest way to do this is starting at the Windows Desktop select Start Run Enter D SETUP select OK D is typical if your CD ROM drive is a different letter use it 2 Read the setup dialogs and do what they say When you get to the Choose Destination Location dialog it will suggest C Program Files GEOSYS If that is not your GEOSYSTEM for Windows folder choose Browse and navigate to the correct folder If you do not have GEOSYSTEM for Windows installed any new folder you choose will work Quick Start Guide 3 When you get to the Select Program Manager Group dialog it will suggest GEOSYSTEM This is where your QC Concrete shortcut will be in your Start Menu Select another program group if you would prefer 4 While it is installing please take a moment to complete the License Agreement and return it or a copy of it to us 5 When you get to the Installation Complete dialog click Finish and you are done installing Unless you are running
121. ort Data form when displayed specifically for changing the titles This form displayed for changing its titles looks like 83 Administrator Tools Report data title editor for BASICO CRP test type Cast cy a 1 Reviewed By ji 4 4 eviewed By Title gt my UD cee a mente ETE e etd o d e 41141114 4 ddress D 4 eport Note 4 eport Note 5 port Note 6 eport Note 7 D 4 eport Note 8 eport Note 9 eport Note 10 11 Report Note 11 12 Report Note 12 v 13 Report Note 13 Y 14 Report Note 14 15 Report Note 15 16 Report Note 16 4 Figure 75 Configuring Report Data Titles When might you expect to need to change a Report Data Title Probably only for custom forms which are created for you In that event select a test of the test type of interest Next select Tools gt Administrator Tools then click on the command button labeled Change Report Data Titles Editing the titles is done by clicking on the title to be changed then editing Some other functions of this form are Copy Titles Paste Titles Each Test Type has its assigned report and likewise its own set of General Report Data To copy all of the titles from one Test Type to another click on Copy Titles then OK then exit Administrator Tools and then select the Test Type which is the destination for the set of titles Go to Tools gt Administrator Tools again and click on the command button labeled Ch
122. ort notes about each specimen may be selected from a user defined list of notes These notes then can be printed on custom reports not standard reports though Described in Section 4 5 12 e Print reports about mixes in the mix database You can now have a printed copy of the data entered for a particular mix Described in Section 5 2 e Print reports about all mixes in a project You can now have a printed copy of the data entered for all mixes in a particular project Described in Section 5 2 e Print reports listing all projects You can now have a printed copy listing the projects in your database Described in Section 6 5 e Print reports listing all clients You can now have a printed copy listing the unique clients in your database Described in Section 6 5 e Printing option for all new reports You may now choose to print all new reports which have not yet been printed Described in Section 6 1 1 e Custom reports may include color Color logos and color text can now be incorporated into custom report templates Introduction 2 1 2 2 1 3 Test Types Handled Concrete cylinders ASTM C 31 and C 39 AASHTO T 23 and T 22 Concrete beam flexural strength in third point loading ASTM C 78 and AASHTO T 97 Concrete beam flexural strength in center point loading ASTM C 293 and AASHTO T 177 2x2 Mortar cubes ASTM C 109 and AASHTO T 106 Grout specimens ASTM C 1019 Cored concrete cylinders ASTM C 42 and C 39 and AASHTO T 24 an
123. ot your GEOSYSTEM for Windows folder choose Browse and navigate to the correct folder If you do not have GEOSYSTEM for Windows installed any new folder you choose will work When you get to the Select Program Manager Group dialog it will suggest GEOSYSTEM This is where your QC Concrete shortcut will be in your Start Menu Select another program group if you would prefer While it is installing please take a moment to complete the License Agreement and return it or a copy of it to us If you completed a license agreement for version 1 you do not need to do so If a license agreement was enclosed with the Version 2 CD then we probably do not have a license on file and would appreciate it if you would send it When you get to the Installation Complete dialog click Finish and you are done installing Unless you are running Windows XP you should re boot when suggested by the installer 99 Upgrading to Version 2 from Version 1 C 2 Running QC Concrete for the First Time after Updating You have a choice the first time it is run You can immediately begin using this new version or you can work with the Demo database for awhile We recommend you immediately begin using the new version but offer you the choice So the first time the new program is run you will be given the option to update the database or use the demo One thing must be done in advance if you wish to use the demo database and your main database is in the program folder you mu
124. panel next to it The color panel is the colored rectangle as shown in the illustration below 24 3 5 2 QC Concrete Reference Manual Set Colors Local Click on the colors below to change Report Selection Background Field Data Background Break Result Background Data Entry Background System Color Schemes Figure 17 Selecting Input Screen Colors System Color Schemes Std sets the background color to the Windows Active Border color Alt sets the background color to the Windows Button Face color Cancel This will abandon all changes made to colors since the Options menu was selected Setting Date Formats Global Select Tools Options and click on the Colors Dates and Fonts tab to access date options These settings affect all users of the program Date Formats there are several preset date formats to choose from Contact VES Inc if you need a format that is not shown Any of these formats may be used if you are working strictly with dates from Jan 1 2000 forward If dates prior to Jan 1 2000 are also going to be used you MUST use one of the two four digit year formats Additionally you MUST set the short date format for windows to one which uses a 4 digit year For help making this change to Windows refer to Windows Help under the topic of Regional Settings Date Formats or something similar Date Today The current date is used on some reports This sets the format used to print th
125. pecified strength checkbox 1 O No strength requirement specified checkbox 2 O Override program determination of specification compliance checkbox 3 The program will automatically fill in checkboxes 1 2 and 3 however the user may override the values determined by the program by checking checkbox 3 3 2 10 Warn If Report Has No Specimens Some users may wish to be alerted if they have a report with no specimens Check this option to have an alert occur when quitting changing reports changing projects adding a new report or adding a new project 3 2 11 Tips Warnings and Confirmation Prompts Local There are some new user features in the program intended to assist in learning the operation of the program These are A tip form is displayed when arranging data entry fields Display a message before allowing changes in the number of columns the data entry screen has Display a confirmation prompt before deleting a specimen from the break table Date fields are checked for valid dates Selecting layout styles waits for confirmation Attempting to enter more data than allowed causes a message to be displayed Entering more breaks than the value entered for Number of Specimens Entering a break on a day other than the scheduled break date pops up a message To disable these features select Tools Options and on the General tab click where it says Check this box to turn off new user features This setting of this preference only affects
126. placed ending data i 10 31 2000 Mix is 3000 D Surp gresar then 4 end less Then B Figure 71 Exporting Results for Statistical Analysis Details about how to export to a CPR file are in the following sections 8 1 CPR Export Criteria In order to selectively export test results for statistical analysis QC Concrete allows selection based on several criteria These include Date Criteria If starting and ending dates are entered the export file will only contain specimens tested within that time frame The dates can represent either the date placed or the date broken depending on which option is selected TI Exporting Results for Statistical Analysis e Project Mix and Test Type Criteria Use these to limit the statistical analysis to specific Projects Mixes and or Test Types e Field Test Criteria CPR export files can also be limited to specimens with specific values of field test results I e certain ranges of slump or specific technicians performing the field test The limiting values for each of these criteria are entered right below them Toggle between less than and less than or equal to by clicking on the symbol Toggle greater than and greater than or equal to the same way e Ages to be Exported CPR has 2 analysis modes three 28 day specimens or one 7 and two 28 day specimens per test If you are only using 2 28 day specimens per test you should select the one 7 day and two 28 day opt
127. ports pS I 72 QC Concrete Reference Manual Section 7 What To Do With Old Projects QC Concrete allows the user to designate a project as inactive and further to archive that inactive project to a separate database An inactive project is still in the QC Concrete database the file name QC Concrete MDB and it will still be a source of data for statistical exports but none of its tests are visible or accessible in normal program use An archived project is completely removed from the QC Concrete database in a database file of its own Archived projects may be returned to the QC Concrete main database if needed Access these options using Edit Project Status The form used to manage Inactive Projects looks like the following figure Project Status INACTIVE PROJECTS ACTIVE PROJECTS Selected Inactive Project Details Selected Active Project Details as Projet Numba 91009 24 Project Nunber 2I04 FC 0004 Priect Fatt Coins Zoo Prime Project Habia 1 Dent Herold Jenkins sme Cieri Archive Inecirem Projci l abs Archived Prods Maigs Branch Delebars l If dupinstes ue band while retieving of neiging Crimes C Anys replace C Never replace Figure 70 Inactivating and Archiving Old Projects 7 1 Inactive Projects With this status the project remains in the database but does not appear in lists of projects Data from inactive projects may be optionally included in data files expo
128. red average strengths QC Concrete can export results to this program Custom Formats Many licensees of the DTRC and QC Concrete programs have non standard features in their programs typically Custom Formats for their reports Data Import Importing break data from a digital data acquisition system Field Data Table The portion of the data entry screen between the test selection lists and the specimen table is the Field data Table Field or Data Field The area on the screen where data is entered is a Data Field GDM The GEOSYSTEM Data Manager is abbreviated GDM GEOSYSTEM Data Manager The software used by GEOSYSTEM for Windows laboratory programs to manage project and test data is the GEOSYSTEM Data Manager usually referred to as GDM Inactive Projects When a project is completed is can be removed from the list of projects in the Project Number list Projects which have been removed are Inactive Projects LD4 The GEOSYSTEM for Windows Drilling Log program an alternative to GDM is LD4 PDF File Report saved in the Adobe PDF Portable Document Format file format Can be viewed as the original report using Adobe Acrobat Reader Placement Date The Placement Date is the cement product was fabricated Related terms are Sample Date Cast Date and Submitted Date 97 Glossary Previewing The process of displaying on the screen a report that can also be printed Report Data This is a peculiar term we are using to describe data that is on reports
129. reports can also be limited to specimens with specific values of lab test results such as Strength Percent of Required or even which technicians performed the break test The limiting values for each of these criteria are entered right beside them See figure below Lab Test Criteria 1 Strength 3000 2 none aii Sa 3 none I C Include All Ages Include Only Specific Ages or HOLD 5 Er Mi MI M Figure 55 Selecting Lab Test Result Criteria for Testing Summaries Toggle between less than and less than or equal to by clicking on the symbol Toggle greater than and greater than or equal to the same way Also available is limiting the report to specimens of a certain age Up to 5 discreet ages can be specified Hold cylinders can be included by typing in the designation such as HOLD or SPARE 6 3 4 Testing Summaries Field Test Criteria Summary reports can also be limited to specimens with specific values of field test results such as certain ranges of Slump Air Content Temperature or specific Technicians performing the field test The limiting values for each of these criteria are entered right beside them See the figure below 63 Printing Reports Field Test Criteria 1 Stump e lt 2 none lt 3 none I K Figure 56 Selecting Field Test Result Criteria for Testing Summaries Toggle between less than and less than or equal to by clicking on
130. ription 104 QC Concrete Reference Manual TestMark Wincom with Job ID is for TestMark Wincom files This format is essentially the same as for Admet with Job ID so see above for description Forney is for Forney files where the header looks like this when you open the CSV file in Excel Microsoft Excel ForneyTest csv Ed File Edit View Insert Format Tools Data Window Help L x DEHRA SAY iBbBM V E Arial v10 BLU Ez 7 A1 f Test Results B C D m F G Test ld Date Time Pk Load Units 62660 12 6 2006 8 29 34 78380 Lb 62661 12 6 2006 8 32 07 81760 Lb 62666 12 6 2006 8 34 48 76355 Lb 62667 12 6 2006 8 37 12 72360 Lb AAA aninimmnm n r arrr ri IN Dom amp w N e Single step through the import process Checking this box causes the program to wait for you to press Next after each record is imported Save Merge results appends Checking this box causes the program to add current merge results to an existing merge results log file If this is not checked clicking on Save Merge results will overwrite the existing results file The merge results file is saved in the same folder as the data import source file It is named MergeResults txt and can be viewed using Notepad or any text document editor D 3 Before Importing a Break Data File All specimens that will be imported must already exist in a report in QC Concrete Create new reports as needed to enter all of the specimen s
131. ropriate information 1 6 To Print or Preview Test Reports Test Reports are the main type of report for submittal to clients Click on Reports Report Selection to display the form that allows selection of which Test Reports to print At the top of the form are the current selection method and the number of reports that meet the requirements of that selection method Close that form and select Reports Print Test Report and the reports selected will print To preview and print only the current report click on the selected under Tools Options Report Setup 1 7 To Print a Break List A Break List is a list of all specimens scheduled to be broken on a specific day Click on the Break List button tal or select Reports Break List to print it Select the date for the break list if different than the current date Report formats are selected under Tools Options Break Lists Setup Note The GEOSYSTEM for Windows Data Manager GDM or the GEOSYSTEM for Windows Drilling Log program LD4 does NOT need to be running for QC Concrete to run Also note that for simplicity all references to the GEOSYSTEM Data Manager in this manual will be simply GDM regardless of whether GDM or LD4 are being used Quick Start Guide ES ET QC Concrete Reference Manual Section 2 Introduction The GEOSYSTEM for Windows Quality Control for Concrete program QC Concrete is for the management of cement product testing data It accepts stores and reports
132. rt the program The program and database are now completely updated and ready to continue using To familiarize yourself with the new features of the software please read Section 2 1 of this manual 101 Upgrading to Version 2 from Version 1 jA 102 QC Concrete Reference Manual Appendix D Importing Break Machine Data D 1 Load Machine Data Import Some break machines are equipped with data logging equipment which can record break results To be able to import those results into QC Concrete contact GEOSYSTEM about whether the program s optional data import add in supports your data acquisition system Currently the only file formats which can be imported are from Admet 3 file formats Advanced Machine Technology D 16 and Forney data acquisition systems When you have installed the data import add in and are ready to import break results you should first enter new reports for each of the field tests which the specimens belong to It is necessary that the specimen identifications be entered exactly as they will be entered on the the break machine I e a specimen may be tagged as 0107577C On the break machine keypad and in the report the specimen ID must be exactly 0107577C You should also enter the specimen age and any known dimensions If specimen numbers are not entered in the database before the import is done the break data will not be imported During the import process QC Concrete will keep a log of the results of its attempt t
133. rted for statistical analysis by CPR the GEOSYSTEM Concrete Performance Report program When would you want to make a project inactive After a project is finished and there is no longer any need to recall it all it is doing is adding to the length of the Project Number selection list However some of the test data may be useful for statistical analysis so it should be made inactive but not archived To make projects Inactive or Active do the following e Giving Inactive Status to a Project To make a project INACTIVE click on it to highlight it in the Active right list then click on the arrow toward the left Giving Active Status to a Project 73 What To Do With Old Projects To make a project ACTIVE click on it to highlight it in the Inactive left list then click on the arrow toward the right Updating Inactive Status of Projects Early version of QC Concrete did not mark reports and specimens inactive As more features were added to the program it was necessary to begin tagging individual tests and individual specimens as inactive as well as projects The Update button was added to perform an audit of the database and insure that all records belonging to an inactive project were also marked as inactive 7 2 Archiving and Retrieving Projects Older projects which are no longer of interest may be completely eliminated from the database by Archiving them Why would you want to archive a test Archiving reduces the number
134. s 8 types of cement products tests 1 Cast Cylinders 8 Sawed Center Point Beams 2 Third Point Beams 9 Grout Cubes 3 Center Point Beams 10 Mortar Cylinders 4 Mortar Cubes 11 Grout Cylinders 5 Grout Prisms 12 Masonry Block Prism 6 Cored Cylinders 13 Masonry Block 7 Sawed Third Point Beams Select the Test Type right after any new test is created so the correct data entry screen is displayed Note The Test Type although displayed along with the Report Selection Keys is not a Report Selection Key When the Test Type is selected the Field Test Data screen will use the appearance you have selected for that Test Type Date fields The contents of the Placement Date field cannot be changed if the Placement Date is being used as a Report Key Field See Section 3 2 1 for additional information There are 3 date fields in the Field Test Data section If they have information in them they should be valid dates in order for them to be used by the program The Placement Date sometimes called Cast Date is very important it is the date the specimen was cast and the age of the specimen begins at 0 with this day The Sample Date is also very important and it is just that the date the sample was taken or cut or cored The Date Submitted is for specimens brought to the lab by a third party Note You can insert the current date by double right clicking on any date field and selecting date then pick the format you want QuickData
135. s something like 91 Importing Tests From DTRC i gt prgent means means UE a command Mumber shown is current work area Useful SE Fa filename EDIT BROWSE aoe LIST DISPLAW SS Ran aer bo progremnawe Exit to DOS QUIT Help HELP or Alt Ddd DTR2COC 6 Press enter when it starts it should look like this Select PROCEED TO CREATE CQCPROJ DBF 7 The program will display the current DTRC Project Database name Make a note of the specimen database name then convert your current database by pressing 1 8 The program creates a new database based on the current database then displays the steps required to modify the duplicate database CQCPROJ DBF so it can be read by QC Concrete QC Concrete Reference Manual ERAM TO CREATE OTR PROJECT On VITH COC CP INPORTABLE FORMAT To complete the process eun VPE and enter the command COCPHOS Then enter the command Press the End key then press 2 Then enter the command Run UQC CP and import t database OQUPADY DGF and et cur database 8 Mote DIRC appears to hove MIX database MIHZZZ DSF kie Either print the directions at this time or write down the Sample Database aka Specimen Database name for future reference If you have a network printer and are not currently capturing LPT1 you may have problems printing this in which case write it down if you have not already done so If it reports a mix database make a note of its name too Mix
136. scribes how to arrange 1 or 2 columns of prompts and how to drag and drop the data entry prompts and fields in the Project and Field Data portion of the screen 3 7 1 Arranging into 1 Column Select Tools Layout Field Data One Column Data input prompts will appear in a single column down the screen 3 7 2 Arranging into 2 Columns Select Tools Layout Field Data Two Columns Where there is enough room data input prompts will appear side by side The second column will start at the position selected in Tools Options Screen Layout 3 7 3 Arranging To Use All Available Space Select Tools Layout Field Data No Columns Data prompts can be positioned using all available space 27 User Preferences 3 7 4 Arranging the Screen Whether you are using the One Column Two Columns or No Columns the order of the prompts can be changed Select Tools gt Layout gt Arrange Field Data Section or right click on any prompt and select from the local menu Data entry will be prohibited and data entry prompts will turn red when pointed to meaning it can be dragged to a new location Drag any data entry prompt over any other data entry prompt and drop it The new location for the dragged and dropped prompt will be the next one following the one it was dropped on To move a prompt to the first position drag it to the first prompt and drop it it will become the second prompt Then drag and drop the first prompt onto the second prompt to swap the
137. sing the ILI and M buttons on this control e Zoom in out 55 Printing Reports Q Whole Page Page Width Two Pages Thumbnail 150 10095 75 50 25 Change the magnification of the report by clicking on the magnifying glass or drop down the list of view magnification options When zoomed the area viewable can be adjusted by holding the left mouse button down and dragging the little hand the direction you want the report to move Note If you get the error message Nothing to do it is probably because there are no reports which meet the selection criteria 6 1 7 Report Data Reports especially custom reports generally include information not specific to the test i e the name of the reviewing person their title etc This is information which generally doesn t change from report to report and is referred to as Report Data The Report Data selected for a given Test Type on a particular project will remain set for all tests in the project unless changed by the user To change a value select Reports gt Misc Project Data gt Report Data for this Project Up to 16 Report Data items are displayed The last 3 14 15 and 16 are also used for QuickData data entry of Field Data see section 4 4 3for more information The data is on a form like in the following figure 56 QC Concrete Reference Manual Report data for Cast cylinder for 2003 FC 0002 B 1 Reviewed By Mack Holloway eviewed By Title Concrete Labor
138. st move the main database somewhere else Do that before you begin using the program if you wish to use the demo database before converting your main database to the new Version 2 format Then you can move the main database back once you are ready to make the switch Once again be sure you have made a backup copy of the database you are using CQC CP MDB Start the program as you normally did with the previous version Using the start menu choose Start Programs GEOSYSTEM QC Concrete or other Program Group that you may have chosen to run the program C 2 1 Database Choices The following warning screen will appear UPDATE TO VERSION Z IN PROGRESS EJ 2 You are in the process of updating to CQC CP Version 2 If you have not backed up your COC CP database you should Click Cancel to exit and back up database before converting If you have backed up your COC CP database you can Click Yes to convert the current database for use with new COQC CP If you would like to work with the demo COC CP database first you may Click No to run the new COC CP with the demo database for the time being If your COC CP MDB database file is in the program folder move it to different location before proceeding with this option No Cancel Figure 76 First program message after update to Ver 2 Cancel It is important to back up your database before converting it to Ver 2 you made need to revert back to it if the update fails
139. t will seek the correct date Whenever the Placement Date is changed the list of Test Numbers changes to list tests for the new date 2 Select the Report Number Click on the down arrow in the Report Number combo box and click on the Report Number needed Or you can type in the Test Number there 4 4 2 Adding New Tests Click on the New Test button on the toolbar Oo or click on Edit gt New Report New Report Project Number Report Number 2003 FC 0001 2003 FC 0002 2003 FC 0003 2003 FC 0004 This report number is one greater 2003 FC 0005 than the current largest number for 2003 FC 0006 the project selected 2003 FC 0007 2003 FC 0008 2003 FC 0009 2003 FC 0010 First select the Project Number for the new report Then enter the Report Number of the new report Repeat data from this project s Figure 27 Adding New Reports Project Number Date Report Number 2003 FC 0001 iid GENE 2003 FC 0002 2003 FC 0003 2003 FC 0004 This report number is one greater 2003 FC 0005 than the current largest number for 2003 FC 0006 the project selected 2003 FC 0007 2003 FC 0008 2003 FC 0009 0 First select the Project Number for the new report Then enter the Date for the new report Then enter the Report Number of the new report Repeat data from this project s OK Cancel Be Neo Figure 28 Adding New Reports With the Option to Start Test Numbering Daily 36 QC Concrete Refere
140. temp database name and This indicates the program was unable to perform routine create main database name Error error description maintenance on the database You will need to copy the Report this problem to VES Inc at 970 223 8788 backup Programfolder CQCPTMP MDB as Datafolder CQC CP MDB See Section 9 5 for more information No Bold or Italic for Font font ID error number error The report template being used is damaged description No Font font ID error number error description The report template being used is damaged No Font in Collection font ID error number error The report template being used is damaged iem Size size selected for Font font ID error number error description ot a valid QC Concrete database When selecting a database to archive from the file must be aie E The calculations for this test type are not set up correctly The break table settings for that test type are no longer for KEY calculation key name correct Refer to section 3 3 6 1 for information about how to reset the calculations The date date entered for date filed name wasn t clear Use the required date format to the program Enter dates in a format like 2 22 02 for February 22 2002 etc for best results The folder new folder name does not exist changing to When selecting the new location for the database the program folder name the program folder location was not accessible by the program Unexpected
141. the appropriate option as shown below Automatically increment test numbers Automatically increment specimen numbers Suggest most likely value for first specimen number on a new report Figure 2 Auto Increment and First Specimen Number Options 3 2 3 Suggest most likely value for first specimen number on a new report You can have QC Concrete suggest the most likely value for first specimen number on a new report It can do it in one of 2 ways by looking through the current project for the highest alpha numerical specimen number or by referencing an alpha numerical counter The choice is made by selecting either By project or By counter on the Options gt General tab as shown in the illustration below Automatically increment test numbers Iv Automatically increment specimen numbers LI Suggest most likely value for first specimen number on a new report By project J By counter T Figure 3 Suggest the most likely value for first specimen number on a new report Since the by counter option generates new specimen numbers based on a counter you must be able to adjust the counter position See Section 9 3 for information about adjusting the counter It also has the advantage of suggesting the next specimen number anytime a specimen is added not just on new reports Le if you have an existing report with specimens 45 46 and 47 and 2 more unassigned specimens are brought in from a field cure location and
142. the counter is at 76 the 2 new specimens will be added to the report as 77 and 78 preserving the uniqueness of specimens throughout the database 10 QC Concrete Reference Manual 3 2 4 Sorting the Test Numbers The report number selection box is used for choosing the number of the test to be retrieved It is in the center in the illustration below PROJECT NUMBER TEST NUMBER TEST TYPE FOR THIS REPORT NUMBER 1 Cast cylinder hd Figure 4 Project Number and Test Number Selection Lists If appropriate for your system of numbering tests i e they are primarily numeric and not alphanumeric the list of tests in this selection box and be sorted To activate numeric sorting select Tools gt Options and on the General tab click on or off the appropriate option as shown below suggest MOST IKEM value ror nrsc SPECIMEN NUMDET on a new report By project 1 By counter The test number selection box can be sorted numerically Check this box to do so NA Give reports New Test status if a specimen load is added or chanaed Figure 5 Option to Sort the Test Number List Numerically If this is not checked test numbers will be sorted alphabetically 10 is before 2 when sorted alphabetically 3 2 5 New Test Status One very useful printing option is the ability to print all new reports Some users may wish to have their tests reports be given new test status anytime a load is entered or changed To have the progra
143. the new user features Local iv Enable Program in use warming at startup Local iv Default Fracture Type Automatically supply a default value for cylinder fracture types Figure 1 Options Screen General Tab Descriptions of these options are given in the paragraphs which follow User Preferences 3 2 1 A Note About Terminology In the industry there are many different terms used for compressive strength tests The Project is usually identified by a Project Number This is also commonly called a Job Number or Contract Number Likewise tests on a project may be referred to by Test Number Report Number Set Number Lab Number Cylinder Set Number and etc For purposes of this manual a specific project on which testing is being conducted will be identified by a Project Number and the set of cast or cut specimens will be called a test and referred to by a Report Number and optionally its Date of Placement 3 2 2 Automatically Incrementing Test and Specimen Numbers When a new test or specimen is added the user must enter its number As a shortcut the program can look up the last test for the project or the last specimen for the test and simply add 1 to its number creating the new number Additionally for new tests the program can suggest a first specimen number if specimens are uniquely numbers throughout a project To activate any of these timesavers select Tools Options and on the General Tab click on or off
144. the symbol Toggle greater than and greater than or equal to the same way 6 3 5 Sorting Criteria Summary reports primarily print lists of specimens The list can be sorted by Project Number Report Number and Specimen Number or just by Specimen Number 6 3 6 Test Selection Criteria Summary As selection criteria are added they are summarized in this area Its purpose is simply to provide an easy confirmation that the criteria chosen were the ones desired See figure below Test Selection Criteria Summary Test Type Cast cylinder Date broken starting date is 03 29 1999 Date broken ending date is 03 30 2001 Specimens aged 3 7 28 Cluran era star than E and lass than fno lirih Figure 57 Summary of Selection Criteria for Testing Summaries 6 3 7 Current Report Format Select the report format desired Various predefined summary formats are supplied with the program They each include different details about the specimen The following figures show some of the available formats a more complete set which numbered 30 as of 2006 can be found on the GEOSYSTEM website at http www geosystemsoftware com products cp summary htm QC Concrete Reference Manual gt eae Raport Cement Predects fepart rims Lowrie NAE L Varie Mute wines TAWH ME nm vium ama yyer Litrel tel meia indere VNE Lasiet yayawa Jti d t r vite Laihia Gy amate sanem GETEST Lit el b 8 twiter THAIS NENT MD Midd LALD L L E dI A l
145. the workstation it is set on 3 2 12 Enabling the Program in Use message Local In a multi user environment it may be helpful to know if other users have the database open message can appear at startup to notify the user of that case To enable the message select Tools Options and on the General tab click where it says Enable Program in Use warning at startup Note that when enabled the message may also be triggered by running the program after a program crash This setting of this preference only affects the workstation it is set on 3 2 13 Default Fracture Type During break data entry for cylinders the fracture type is entered Since the most common type of fracture is conical you may wish to have A inserted automatically Likewise any other value could automatically be inserted by entering it here Leave it blank to disable use of default values for fracture type This is the same default value used during by the Break List Data Entry form If it is changed there it is also changed here 3 8 Options on the Report Setup Tab Strength tests on beams mortar cubes cylinders etc each have their own particular reporting requirements So each of the 13 different test types supported by QC Concrete has a specific report format associated with it There 13 User Preferences are also variations among testing labs in how a report for each test type should look As a result there are a number of considerations which go into test
146. tings as follows 3 4 1 Name of Template to be Used for Break Lists Select from the dropdown combobox the name of the report format to be used The description of each format is included with the name Examples of some of these reports are shown in Section 6 2 2 3 4 2 Specimens to be Included e All unbroken specimens up to and including the break date Select this option for a complete break list of all specimens which may need testing This is recommended because using this option you will always know if a specimen was missed Unbroken and prematurely broken specimens for the exact break date Select this option for a break list of all specimens which need testing and all specimens inadvertently tested early Only unbroken specimens for the exact break date This is not a very comprehensive option but if you have a lot of specimens in the database that were scheduled but skipped intentionally it will weed them out 3 4 3 Specimen Sort Order for the Report None Select this option for no break list specimen sorting They will print in the sequence that they 23 User Preferences exist in the database e Alphabetic sort Alphabetic sorts are good for specimen IDs which use letters or numbers and letters in combination It will however put 15A before 2A because that is the correct alpha sort order Numeric sort Numeric specimen sorting will ignore all letters It will place 2A before 15A but will
147. tion Factor For values between those specified the correction factor is found by linear interpolation Also calculated is the Percent of Design or Percent of Required In order to have these calculated you must have entered a Design Strength and Design Age If those are present all specimens with the same age as the Design Age have a Percent of Design calculated using the specimen s strength as rounded and displayed divided by the design strength Other age specimens may have their Percent of Design calculated as well Simply enter their required strengths into the break table To save time enter the Mix ID used be in the Mix Table and enter an age and design 41 Data Entry strength for the age of the specimen All other specimens with the same Mix ID will also have this new design age and strength applied to them See Figure 33 for an example of the Mix Table with 3 sets of design age and design strength 4 5 10 Averaging Strengths Select the rows with the strengths to be averaged by clicking on the row selector while holding down the control key Right click while pointing to the break table You will get a message giving you the average Click OK and the average will be inserted in the Average28 field The automatic determination of the average strength is preferable to using this manual method 4 5 11 Default Fracture Type and Fracture Type Menu Using a Default Fracture Type The program can supply a default value for cylinder
148. tware are disabled To disable them select Tools gt Options and click on the Screen Layout tab Check the appropriate box to disable the automatic width features Also if the rows are not high enough the cursor may not display properly If the cursor vanishes resize the rows larger 4 5 7 Cut Copy and Paste in the Break Table Any information entered in the Break Table can be cut copied and pasted between specimens To do so highlight either with the mouse or shift arrow keys then use Ctrl C to Copy Ctrl X to Cut and Ctrl V to Paste 4 5 8 Moving Around the Break Table and Other Editing Keys The following table lists the keys to use to move around the Break Table QC Concrete Reference Manual Table 2 Keys Used to Move Around the Break Table 4 5 9 Break Table Calculations Break date area and strength are some examples of data that are calculated by the program The formulas used are shown on the break table configuration form See section 3 3 6 for additional information Cored cylinders and masonry block prisms both require the application of corrections factors to the calculated strength These correction factors are related to the length diameter or height width ratio and are determined using the following tables Length Diameter Ratio Correction Factor Applied to Strength ss 88 Table 3 Cored Cylinder Correction Factor Correction Factor Applied to Strength 0 86 Table 4 Masonry Block Prism Correc
149. up and in the PDF Setup frame click on the Setup Now button Under Path to project PDF Storage Folder the current location where the project s PDF files are stored is shown Under Default Path the default path is shown To change either of these locations click on the appropriate Browse for new path button At the following screen you can do the following to choose these new folder locations e Select the drive to use Network drives must be mapped to a drive letter to show up or e Select the folder to use e Create a new folder in the selected folder NOTE If you selected a mapped drive be sure to have that drive mapped and available the next time QC Concrete is run Otherwise you will need to quit establish the connection then restart There is nothing elegant about the way QC Concrete handles files Use a mapped network drive only if you are comfortable and experienced with drive mapping There are 2 other PDF file user options what date to use in the PDF file name and whether or not to prompt for making chosen PDF folder during a print preview the permanent PDF folder for a project e Date to Use When Building PDF Names you can choose to use either the Current Date or the Date Placed in the PDF file name Filenames are of the form S91003 2400 1 02 28 03 PDF where S91003 2400 is the project number 1 is the report number and 02 28 03 is the date either current or date placed Set PDF Storage Folder at Preview When a PDF file
150. usually directly entered using Alt 0176 48 Changing the Project Number Report Number or Date Certain information for each test is used to uniquely identify the test These are the Project Number and Report Number If the selection method requiring dates is employed then the Placement Date is also used to uniquely identify a test The need may arise to change one of these values for a test and since there are no formal data entry fields for Project Number Report Number or Placement Date they must be changed using Edit Change a Report s Project Report Number or Date This form is shown in Figure 32 QC Concrete Reference Manual Change Data in a Report ID Field PROJECT NUMBER r DATE gt REPORT NUMBER Current Current Current 53100324 not applicable fi Select new Select or enter new Enter new st 003 24 net applicable fi 2003 FC 0001 2003 FC 0002 2003 FC 0010 Figure 32 Changing a Test s Project Number Report Number or Placement Date Some tips for changing these values are Project Number Select from available Project Numbers Date Select from available Dates or enter a new date if not using Dates this option will not be available Report Number Enter the new report number for the existing report OK and Cancel OK saves the changes Cancel abandons the changes Note To assign a different project number to an entire project select Tools Administrat
151. vigate to the database folder to determine if CQC CP MDB is still there If it is and simply can t be read e mail it to Support GEOSYSTEMSoftware com to check it out If it can t be found or can t be fixed see if the backup database CQCPTMP MDB is in the program folder If it is you can revert back to it by copying it to the designated database location and renaming it CQC CP MDB You will lose all work performed with the program since the last time it was started with the Backup database option turned on Error archiving Error number Error description Note Occurs when the program is archiving call tech support that long filenames are not supported See help for more information Error finding projects in folder name The GEOSYSTEM Data Manager project folder selected is not the correct one Error importing data for type of import Data not in call tech support or send the client database which caused expected format first line first line of data read the error Expected example of what was expected Error error number error description Try changing to Sometimes the printer object is not refreshed without a a different default printer and then changing it back change in the printer device Change to a different printer then change back 88 QC Concrete Reference Manual Extension must be MDB When selecting a database to archive to the file must have the extension MDB Failed to CompactDatabase
152. ys the printer selection dropdown list as well as some information about the printer which can be derived from the printing subsystem The printer selected in this way becomes the system printer for all programs using that particular PC Be sure to change it back if the selected printer is only a temporary selection 70 QC Concrete Reference Manual 6 7 1 E mailing Reports QC Concrete does not offer a direct Email option however there are 2 common techniques which work e Print to File Selecting the print to file option allows you to create a data file which can be e mailed and then copied to a printer of the same make and model The recipient should use the DOS command COPY B FILENAME PRN PRN to complete the printing If you have questions about this contact your office computer expert for help please do not call GEOSYSTEM Software e Create PDF files You can print reports to Adobe Acrobat PDF format files which can then be e mailed Most computers have Adobe Acrobat Reader however if your recipient does not they will need to obtain it The Acrobat Reader program is widely distributed free of charge by Adobe available at their website For more information about creating PDF files with QC Concrete refer to Section 6 1 3 6 7 2 Faxing Reports with Modem If your computer has a fax software installed select the fax printer device as the printer to be used Then use the fax software as directed in its instructions 71 Printing Re

Download Pdf Manuals

Related Search

Related Contents

MANUAL DEL USUARIO  Manuel de montage - at-hena  Acer Aspire TC-705  Laerdal Suction Unit User Manual  CPX2/CPX6  Nikon P300 Camcorder User Manual  FSG 85 B1 - Lidl Service Website  Double-Ridged Waveguide Horn  

Copyright © All rights reserved. Failed to retrieve file