manualshive.com logo in svg

SSI CS8900, Manual, Page: 56 / 60

Share
Download
SSI CS8900 Manual Download Page 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 

Summary of Contents for CS8900

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 19: ...18 Figure 16 Calibration window indicating end of return close loop run Press Next Figure 17 Calibration window calculating results...

Page 20: ...19 Cross Slope Calibration Figure 18 Window indicating completion of Profile Slope Calibration Figure 19 Closed Loop Calibration window with Cross Slope selected...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 30: ...29 Figure 32 A collection without events selected Figure 33 A collection with a point event at 0 14 3 feet...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 39: ...38 Figure 41 The collection data included in a sidewalk report Figure 40 The top of a sidewalk report...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 47: ...46 Figure 53 Selecting a location to save the exported file Figure 54 The export type drop down menu...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Page 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...

Reviews:

No comments