{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Report Macro"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"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 Macro","index":0,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Equipment Asset Visibility Report Creator"]
["What this file does:\n      1) Creates an easily searchable and sortable database of all property on the PHR, separated into a sheet of equipment with serial numbers and a sheet for equipment without serial numbers.\n      2) Compares two of these database report files to generate a report of all differences between the two reports (e.g. what equipment was added, removed, or modified in some way)"]
["How to use this file:"]
["1) Create an \"AssetVis\" report in PBUSE/GCSS-A for each UIC that you want in your report"]
["2) Click the first button on the right to create the report. Follow the directions given by the program. You can select as many UICs as you want to include in the report - the program will ask you if you want to add another once it is complete."]
["3) Save this file as a different filename"]
[]
["For comparing reports"]
["4) Repeats steps 1-3 for another set of AssetVis reports (use the same UICs so that the report comparison makes sense)"]
["5) Open one of the two report files and click the second button on the right. Follow the directions to name the reports and select the second report."]
["6) That's it! Your comparison report is created! Now you can sort and filter that report to see the differences between the two compared reports. \"Status Change\" means that the serial number is still on the PHR, but something changed (SHR, LIN, SubLIN, NSN, Nomenclature, etc). \"Only on "]