{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Report","Instructions"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":1},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Report","index":0,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[2,0,2,5]]}
["Survey Research Center"]
["SRO Financial Group"]
["Non PO and PO Voucher"]
["Date Refreshed 11/28/2012 10:41"]
["Version: 1.4"]
[]
[]
[]
[]
[]
[]
[]
["Expended Amount",null,null,null,"FISCAL_YEAR","ACCTG_PERIOD_END_DT"]
[]
["PROJECT_GRANT","VOUCHER_TYPE_DESCRSHORT","ACCOUNT","ACCOUNT_DESCR"]

{"sheet":"Instructions","index":1,"n_rows":182,"n_cols":1,"rows_kept":182,"cut":false,"hidden":false,"merged":[]}
["SRO Financial Group M-Pathways Excel Report Help"]
[]
[]
["Instructions to run a report"]
["Press the Enter New Parameter button to activate the parameter entry form.  "]
["Select a parameter type and then enter your parameter values in the text boxes on the form."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Press the Run Query button."]
["Enter your Oracle password and wait for the results."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Look in the bottom left hand corner of the Excel workbook.   You will see the report connecting to the database."]
[]
[]
[]
[]
[]
[]
[]
[]
["Then the report will start pulling data."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["If there is data to return then you will get a \"Report Complete\" message.  If there is no data based on the parameters that you entered then you will get the \"No records returned, double check your parameters\" message."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Refreshing a report"]
["To refresh the report press the Refresh Report button."]
["Or right click somewhere on the pivot table and then select the \"Refresh Data\" option."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Setting your computer to always open an Excel file in Excel"]
["To configure Internet Explorer to open Excel files in the Excel Office program, use the following steps: "]
["1. Open \"My Computer\" from your \"Desktop\""]
["2. On the \"Tools\" menu (or the \"View\" menu), click \"Folder Options\" (or click \"Options\"). "]
["3. Click the \"File Types\" tab. "]
["4. In the \"Registered file types\" list, click \"XLS    Microsoft Excel Worksheet\", and then click \"Advanced\" (or click \"Edit\"). "]
["5. In the \"Edit File Type\" dialog box, click to clear the \"Browse in same window\" check box (or click to clear the \"Open Web documents in place\" check box).  "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Pivot Table Help"]
["Documentation"]
["For Help on how to use Pivot tables go the the SRO Financial Services web site"]
["Click on the Cost Reporting System (CRS) link"]
["Click on the CRS Version 3.0 User Manual in the Documentation section"]
["Go to the \"Pivot Tables\" section on page 7 "]
[]
["Videos"]
["For training videos on how to use pivot tables go to the SRO Financial Services web site"]
["Click on \"Training Videos\" "]
["Click on any of the video files to run them, you'll need speakers and the latest version of Macromedia Flash Player."]