VIEWS: 0 PAGES: 27 POSTED ON: 4/28/2013
1) Log into CG Central 2) Click on ‘My Readiness’ 2) Click on CG Analytics Click on ) 3) Then CGBI Cubes click on & Reports CGBI Cubes & Reports Click and select ‘Measure Type’ 4) Scroll down until you see the “Training” column. Then click on ‘Aviation Proficiency’ cube 5) Right click on the ‘All Departments’ icon 6) Left click on ‘Replace Rows’ 7) You now begin ‘drilling down’ to locate your unit. Left click on ‘United States Coast Guard’ 8) This example is for Humboldt Bay—Pacific Area 9) D11 10) Sec/AirSta Humboldt Bay 11) Left click and hold on ‘All Employees’ folder and drag it over the top of ‘CG AIRSTA ….’ 12) Click on ‘Active’, followed by: ‘Regular’ until you reach the next slide 13) Click on either ‘Enlisted’ or ‘Officer’ 14) To convert the ranks to people, place the mouse arrow exactly between the ‘Measures’ block and the rank block (highlighted in gray here). Right Click when the block changes color and then Left Click on ‘Expand’ You now have 2 columns, 1 with names and the other with numbers. To delete the ranks, as before, move the cursor between the ‘Measures’ block and the rank block (highlighted in gray here). Right click when the block changes color and left click on ‘delete’. To hide the total flight hours Right Click over the ‘Flight Hours Career’ block and then Left Click on ‘Hide Selection’. This can be done to any column. 2 3 15) To create a shortcut to get to this point for further log-ins, first To create a shortcut to get to this point for further left click on the paper icon, then left click on ‘prepare bookmark’. log-ins, first left click on the paper icon, then left click on ‘prepare bookmark’. After a few seconds After a few seconds a new web address will appear. Add this web a new web address will appear. Add this web address to your ‘Favorites’. On subsequent log-ins, after you address to your ‘Favorites’. On subsequent log- ins, select this favorite and it will immediately 2 complete step 5, select this favorite and it will immediately take you take you here. here. 1 1 To export these values to another format, click on the symbol that looks like a paper and then click on your selection 1 2 This is an example of the output from choosing ‘export CSV’. This data can then be manipulated in an Excel spreadsheet if desired. Then ‘Paste’ the data into a spreadsheet To change when the blocks turn red, yellow or green highlight the range of cells you want to change and select ‘Conditional Formatting’ under the ‘Format’ menu This page will come up. Set your limits and even change the colors if you like by clicking on the different fields. You can have 2 different tabs, one for pilots and the other for aircrew. This is the aircrew page. Eventually over time you could set up your data to graph and determine trends over a period of time using Excel. To edit within CGBI on when the blocks turn colors, click on the colored square, then click on ‘edit’ for each category and change as necessary. After you’ve made the changes, create another ‘bookmark’ and save it in your favorites and it will save your edits for future log-ins. • Call if you have any questions. I can provide an example of one of the Excel spreadsheets. You can post the ‘bookmark’ on your flight schedule ‘notes’ page so everyone can have daily access to this CGBI site. • 707-839-6112 LCDR Clint Schlegel Thanks to PO Allsworth for finding this ‘gem’ and helping me develop this process.
Pages to are hidden for
"Slide 1 - U.S. Coast Guard"Please download to view full document