manualshive.com logo in svg

SSI CS8900, Руководство пользователя, Страница: 56 / 60

Поделиться
Скачать
SSI CS8900 Скачать руководство пользователя страница 56

 

55 

 

 

Exporting to Excel Format

 

Exporting the profile data to excel gives the operator versatility and efficiency when an adjustable 
numerical printout is needed

.  

 

 

 
 
 

Export to Comma Delimited File

 

The Comma Delimited file shows the track number, segment number, start and end stationing and 
the ride number selected in the Analysis Parameters.  
 

Figure 64: Exporting the data into Microsoft Excel format 

Содержание CS8900

Страница 1: ...0 885 1482 Fax 530 885 0593 Email info smoothroad com Sales Administration P O Box 790 Larkspur CA 94977 Tel 415 383 0570 Fax 415 358 4340 Email info smoothroad com Electronics Software 307 Plymate La...

Страница 2: ...use 7 Profile Collection 7 Interval Collection 7 Sidewalk Profiler Hardware 7 Calibration Procedures 4 Height Calibration 4 Distance Calibration 8 Closed Loop Calibration 10 Collection 18 Connecting D...

Страница 3: ...e 30 Running Grade Cutoff 30 Maximum Cross Slope 31 Cross Slope Cutoff 31 Slope Range Interval 31 Minimum Length 31 Level Changes 31 Cracks 31 Minimum Length 31 Exclude Interval Types 31 Minimum Lengt...

Страница 4: ...ch Tracks 43 Ignore Pauses 43 Exporting to PPF Format 44 Station Extraction 44 Filter Settings High low pass length 44 Include Run up Run out Data 45 Export Raw Data 45 Exporting to PRO Format 46 Expo...

Страница 5: ...CALIBRATION 24 FIGURE 21 CALIBRATION WINDOW WITH SYSTEM AT END OF TRACK 24 FIGURE 22 CALIBRATION WINDOW INDICATING OPERATOR TO TURN THE SYSTEM AROUND 24 FIGURE 23 CALIBRATION WINDOW INDICATING END OF...

Страница 6: ...ORTING IN PPF FORMAT 45 FIGURE 59 THE EXPORT WINDOW WHEN PRO FORMAT IS SELECTED 46 FIGURE 60 AN ENLARGED VIEW OF THE ENTIRE PRO EXPORT WINDOW 47 FIGURE 61 THE DETAILS TAB CONTAINS INFORMATION ABOUT TH...

Страница 7: ...he road felt by the user The value of IRI is filtered through the quarter car simulation but the equation for IRI is essentially IRI Defects Localized Roughness Defects on the surface sometimes referr...

Страница 8: ...report or specifically viewed to determine its profile ride number IRI PRI etc Profile Collection When a data collection begins the profiler will collect the profile of the sidewalk Once the profile c...

Страница 9: ...it due to charging The LED will become green when charging is complete In some cases the charger may need to be plugged into to 120v AC before connecting to the profiler Adjusting the Right Wheel The...

Страница 10: ...ler needs to be placed on a level surface Mark the locations of the fixed left side wheels on the ground and begin the calibration process Figure 1 The calibration menu which appears after the Calibra...

Страница 11: ...on on the initial Calibration Menu Figure 3 The first window of the height calibration instructing the operator to place the walking profiler on level ground and set the brake Figure 4 Brake set and p...

Страница 12: ...profiler must be turned around 180 degrees and have its left side wheels swap positions Each wheel should be over the exact spot the other wheel was over in phase one When the walking profiler is in...

Страница 13: ...12 Press Next in the current calibration window Figure 8 Window after a successful calibration Figure 7 Positioning for the second phase of the calibration...

Страница 14: ...to complete a successful calibration Set the length of the calibration track The units can be changed by clicking on the feet ft symbol and choosing the appropriate units After the length of the track...

Страница 15: ...last calibration If the estimated distance does not match the Calibrated to distance it could be that the system has never been calibrated the last calibration was an improper or the system had a hard...

Страница 16: ...over a crack or change level from slab to slab during calibration When calibrating a new device the height and distance calibrations must be performed prior to either closed loop calibration The dist...

Страница 17: ...First window of the Profile Slope Calibration The initial negative distance indicates the length between the laser and back wheel Proceed to push system to end of track Figure 14 Calibration window w...

Страница 18: ...push system back to initial starting point The main wheels should go over the same line The distance traveled will be reversed Stop when the onscreen Current Distance shows 0 00 feet Figure 15 Calibra...

Страница 19: ...18 Figure 16 Calibration window indicating end of return close loop run Press Next Figure 17 Calibration window calculating results...

Страница 20: ...19 Cross Slope Calibration Figure 18 Window indicating completion of Profile Slope Calibration Figure 19 Closed Loop Calibration window with Cross Slope selected...

Страница 21: ...20 First window of the Cross Slope Calibration The initial negative distance indicates the length between the laser and back wheel Proceed to push system to end of track Figure 21 Calibration window...

Страница 22: ...un meaning the system goes over same surface Align the outside wheel over the same track the main wheels went over Figure 22 Calibration window indicating operator to turn the system around and align...

Страница 23: ...e OUTSIDE wheels should go over the calibration line The distance traveled will be reversed Stop when the onscreen Current Distance shows 0 00 feet Figure 23 Calibration window indicating end of retur...

Страница 24: ...filer is turned on properly connected to the operator computer and Profiler V3 is running the software should indicate hardware found If hardware is not found and these requirements are fulfilled chec...

Страница 25: ...filer The odometer is only as accurate as the currently saved distance calibration File Name Hardware Connected Speedomete r Status GPS Collect Icon Odometer Short cut Bar Hide Bar Figure 26 The odome...

Страница 26: ...r early stages of troubleshooting The diagnostic window is color and number coded to determine problems When no problems are encountered the diagnostic will have all zeros and green icons If SSI Custo...

Страница 27: ...number of satellites and the NMEA String of the data used to calculate position Collect Collection Information The collection information can be accessed by selecting the Collect icon in the Collect...

Страница 28: ...testing is occurring Section Notes Section notes is the information related to the starting point and the project such as landmarks and the visible condition of the pavement Weather Conditions The wea...

Страница 29: ...suggested starting point to keep consistent data collection lengths File Name In the bottom left corner is the location of the file name If the current file is unsaved then the name of the file will b...

Страница 30: ...29 Figure 32 A collection without events selected Figure 33 A collection with a point event at 0 14 3 feet...

Страница 31: ...rval At this time the status bar will turn yellow and will display the stationing of where the interval was started To end the interval select End Interval Segment events can be added and edited after...

Страница 32: ...l automatically switch to Interval mode Pressing any key that is tied to an Interval event while in Interval mode will switch the collection back to normal but will not insert the event same as clicki...

Страница 33: ...ter is useful Key Press Notes Key Press Notes are the user inputted notes that can be entered for each event The notes are entered through the keyboard hence their name key press notes These notes wil...

Страница 34: ...w or Ctrl N on the keyboard When a new file is opened the lower left corner of Profiler V3 will display New File Mapping The mapping feature can be used to navigate to defects in the profile based on...

Страница 35: ...34 Figure 37 A bump is selected about to be navigated to Figure 36 The drop down menu for mapping shown Run being navigated along...

Страница 36: ...nning grade is the maximum value that the running grade cannot exceed If this value is exceeded the sidewalk report will list the sections of non conforming sidewalk sections by GPS and stationing Run...

Страница 37: ...alks will have a reporting distance of 24 inches based off of a wheelchair Level Changes Level changes are classified as either 1 1 or 1 2 rise run and can be up or down Typical parameters for 1 1 and...

Страница 38: ...lk Report The sidewalk report shows the results of the running grades and bump heights of the sidewalk The settings for the sidewalk profiler can be found in the Settings window under the Sidewalk tab...

Страница 39: ...38 Figure 41 The collection data included in a sidewalk report Figure 40 The top of a sidewalk report...

Страница 40: ...d the information pertaining to the sidewalks profile in tabular form Information about the calibration profile number stationing defect locations section location and section notes will be displayed...

Страница 41: ...enever a change is made by deselecting a track or checking a new track select the refresh icon to have it appear in the trace If the refresh icon is not selected the trace will not update and the chan...

Страница 42: ...locations with excess IRI The rendering mode options allow the operator to choose speed or high resolution traces Profile Continuous IRI The drop down menu allows the user to select two options of Pro...

Страница 43: ...42 Figure 46 The drop down menu options of Profile and Continuous IRI are shown above Figure 47 The Continuous IRI Plot options window...

Страница 44: ...osen through the plot options To change the plot to a Profile trace select the Plot Options Icon and change the drop down menu settings to Profile This setting is chosen through the plot options To ch...

Страница 45: ...de of the Profiler V3 window and in File Export Exporting to Sidewalk Format The operator can export to sidewalk format which formats the file to GIS compatible file types The file types can be chosen...

Страница 46: ...vigate through Windows Explorer to the desired folder Once the folder destination is reached and selected left click on OK at the bottom of the window to save the folder location Figure 51 The export...

Страница 47: ...46 Figure 53 Selecting a location to save the exported file Figure 54 The export type drop down menu...

Страница 48: ...the exported file will finish These values can be adjusted by typing values into the box or by using the arrow keys to the right of the box Filter Settings High low pass length The exported data file...

Страница 49: ...udes Track 1 2 and the center trace For the Profilograph files the tracks are matched based on the settings entered prior to profiling The label of the track number and stationing cannot be changed af...

Страница 50: ...keys to the right of the box Filter Settings High low pass length The exported data file can have an additional filter applied while being processed into the chosen format To not filter the data leave...

Страница 51: ...chosen file Match Tracks Selecting Match Tracks exports all of the tracks associated with the lane file For the three laser systems this includes Track 1 2 and the center trace For the Profilograph fi...

Страница 52: ...ength when exporting files to PRO format A High Pass Filter removes all of the data trends below the filter length The default length of the High Pass Filter is 200 feet In order to export the data wi...

Страница 53: ...ent anomalies use the option of ignoring the pauses Details The details section of PRO exporting is the job specific information saved with the file such as District Number County Number Reference Mar...

Страница 54: ...ed on the stationing set within the profiling data To use this feature select the check box near Specify Station Numbers When the box is selected the operator will be able to adjust the stationing num...

Страница 55: ...Filter The High Pass Filter will remove any trend in the data less that the chosen length The length can be selected by typing the value in the box or by using the arrows to adjust the input Low Pass...

Страница 56: ...and efficiency when an adjustable numerical printout is needed Export to Comma Delimited File The Comma Delimited file shows the track number segment number start and end stationing and the ride numb...

Страница 57: ...SSI Excel Template select Export to Template Figure 65 An example of exporting the data into Excel Figure 66 The types of excel formats are listed in the template drop down menu Types of excel formats...

Страница 58: ...bout the file in spreadsheet form IRI Template The IRI Template gives information on the IRI statistics along with the defect locations and heights PRI Template The PRI Template lists the PRI for each...

Страница 59: ...Earth The export to Google Earth feature allows operators with Google Earth installed on their computers to view the test data in the real environment The view of the Google Earth feature shows the p...

Страница 60: ...profiler powered on If problem persists close the program and shut the power off to the profiler Wait five seconds then turn the power to the profiler on Then open the SSI Profiler program If the iss...

Отзывы:

Нет отзывов