{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["INSTRUCTIONS","TRILOGIE","DATA"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"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":"INSTRUCTIONS","index":0,"n_rows":47,"n_cols":9,"rows_kept":47,"cut":false,"hidden":false,"merged":[[23,16,26,20]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Trilogie Bid Automation Template"]
[null,null,"Use the following steps to download and prepare a Trilogie bid for use in the ProVisions website."]
[null,null,"Note: make sure macros are enabled in order to use this template."]
[]
[null,null,1,"Enter your Trilogie information:"]
[]
[null,null,null,null,null,null,"LOGON:"]
[null,null,null,null,null,null,"USERNAME:"]
[null,null,null,null,null,null,"PASSWORD:","Char&chu1"]
[]
[]
[null,null,2,"Enter your bid informaton:"]
[null,null,null,null,null,null,"BID / ORDER #:",null,"* include the \"B\" before any bid number"]
[]
[]
[null,null,3,"Click the DOWNLOAD button:"]
[]
[null,null,null,null,"Clicking the DOWNLOAD button will perform the following steps automatically:"]
[null,null,null,null,"-","open a new session of wIntegrate"]
[null,null,null,null,"-","log you in to the system based upon the information you provided above"]
[null,null,null,null,"-","run the PVIS report to download the bid # you entered above"]
[null,null,null,null,"-","save the .xls file in your C:\\Download folder"]
[null,null,null,null,null,"(if you do not have a C:\\Download folder, it will create the folder automatically)"]
[null,null,null,null,"-","log you out of the wIntegrate session that was created"]
[]
[]
[null,null,4,"Click each of the following buttons:"]
[]
[null,null,null,null,null,null,null,"imports .xls file"]
[]
[null,null,null,null,null,null,null,"steps through bid cleaning process"]
[]
[null,null,null,null,null,null,null,"creates the necessary .txt file"]
[]
[null,null,null,null,null,null,null,"clears out existing information"]
[]
[]
[null,null,5,"Access the ProVisions website and continue as normal:",null,null,null,null,"ProVisions Login"]
[null,null,null,null,null,null,null,null,"ProVisions Login"]

{"sheet":"TRILOGIE","index":1,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["LOGON:",{"$f":"INSTRUCTIONS!H15","v":"COL"}]
["USERNAME:",{"$f":"INSTRUCTIONS!H16","v":"AAM5700"},null,null,"PVIS"]
["PASSWORD:",{"$f":"INSTRUCTIONS!H17","v":"Char&chu1"},null,"11. BRANCH CUSTOM MENU","BCM"]
["BID #:",{"$f":"INSTRUCTIONS!$H$21","v":"B015551"},null,"REPORT","PVIS"]
[null,null,null,"This will generate a text file to load into ProVisions Portfolio from a Bid.  Is this what you want to do? (Y/N) :","Y"]
[null,null,null,"Enter the PC Path and filename to download to :",{"$f":"\"C:\\DOWNLOAD\\\"&$B$4&\".XLS\"","v":"C:\\DOWNLOAD\\B015551.XLS"}]
[null,null,null,"Enter the Bid Number :",{"$f":"$B$4","v":"B015551"}]

{"sheet":"DATA","index":2,"n_rows":1,"n_cols":9,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
[null,"ITEM","VENDOR","DESCRIPTION","NET.PRICE","UM","MPID","CUST.CD","ORD.QTY"]