{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Raw Data","Unique Data","Final Data","Filter"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"Raw Data","index":0,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Group ID #","Quote","Carrier","State","Criteria Carrier","Cheapest Carrier","Difference"]
[1,232.03440000000001,"YRC","CA","Reddaway",{"$f":"cheapCarrier()","v":"Saia"},{"$f":"difference()","v":9.1260000000000048}]
[1,206.5986,"Reddaway","CA","Reddaway",{"$f":"cheapCarrier()","v":"Saia"},{"$f":"difference()","v":9.1260000000000048}]
[1,212.08590000000001,"XPO","CA","Reddaway","Saia",9.1260000000000048]
[1,197.4726,"Saia","CA","Reddaway","Saia",9.1260000000000048]
[2,232.03440000000001,"YRC","CA","Reddaway","Saia",9.1260000000000048]
[2,206.5986,"Reddaway","CA","Reddaway","Saia",9.1260000000000048]
[2,212.24969999999999,"XPO","CA","Reddaway","Saia",9.1260000000000048]
[2,197.4726,"Saia","CA","Reddaway","Saia",9.1260000000000048]
[3,291.83839999999998,"YRC","KY","YRC"]
[3,372.84799999999996,"Reddaway","KY","YRC"]
[3,295.93760000000003,"XPO","KY","YRC"]
[3,314.89920000000001,"Saia","KY","YRC"]
[4,291.83839999999998,"YRC","KY","YRC"]
[4,372.84799999999996,"Reddaway","KY","YRC"]
[5,291.83839999999998,"YRC","KY","YRC"]
[5,372.84799999999996,"Reddaway","KY","YRC"]

{"sheet":"Unique Data","index":1,"n_rows":3,"n_cols":7,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Group ID #","Quote","Carrier","State","Criteria Carrier","Cheapest Carrier","Difference"]
[1,232.03440000000001,"YRC","CA","Reddaway","Saia",9.1260000000000048]
[2,232.03440000000001,"YRC","CA","Reddaway","Saia",9.1260000000000048]

{"sheet":"Final Data","index":2,"n_rows":51,"n_cols":4,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["State","Pass/Fail","Cheapest Carrier","Criteria Carrier"]
["AK","No Data","No Data","YRC"]
["AL","No Data","No Data","YRC"]
["AR","No Data","No Data","YRC"]
["AZ","No Data","No Data","Reddaway"]
["CA","Fail","Saia","Reddaway"]
["CO","No Data","No Data","Saia"]
["CT","No Data","No Data","XPO"]
["DE","No Data","No Data","XPO"]
["FL","No Data","No Data","YRC"]
["GA","No Data","No Data","YRC"]
["HI","No Data","No Data","YRC"]
["IA","No Data","No Data","YRC"]
["ID","No Data","No Data","Reddaway"]
["IL","No Data","No Data","YRC"]
["IN","No Data","No Data","YRC"]
["KS","No Data","No Data","Saia"]
["KY","No Data","No Data","YRC"]
["LA","No Data","No Data","XPO"]
["MA","No Data","No Data","YRC"]
["MD","No Data","No Data","YRC"]
["ME","No Data","No Data","YRC"]
["MI","No Data","No Data","YRC"]
["MN","No Data","No Data","XPO"]
["MO","No Data","No Data","Saia"]
["MS","No Data","No Data","YRC"]
["MT","No Data","No Data","Reddaway"]
["NC","No Data","No Data","YRC"]
["ND","No Data","No Data","XPO"]
["NE","No Data","No Data","Saia"]
["NH","No Data","No Data","YRC"]
["NJ","No Data","No Data","YRC"]
["NM","No Data","No Data","XPO"]
["NV","No Data","No Data","Saia"]
["NY","No Data","No Data","XPO"]
["OH","No Data","No Data","YRC"]
["OK","No Data","No Data","XPO"]
["OR","No Data","No Data","Reddaway"]
["PA","No Data","No Data","YRC"]
["RI","No Data","No Data","XPO"]
["SC","No Data","No Data","YRC"]
["SD","No Data","No Data","XPO"]
["TN","No Data","No Data","YRC"]
["TX","No Data","No Data","XPO"]
["UT","No Data","No Data","SST"]
["VA","No Data","No Data","XPO"]
["VT","No Data","No Data","YRC"]
["WA","No Data","No Data","Saia"]
["WI","No Data","No Data","YRC"]
["WV","No Data","No Data","YRC"]
["WY","No Data","No Data","XPO"]

{"sheet":"Filter","index":3,"n_rows":8,"n_cols":25,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Group ID #","Quote","Carrier","State","Criteria Carrier","Cheapest Carrier","Difference"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WY"]
["Group ID #","Quote","Carrier","State","Criteria Carrier","Cheapest Carrier","Difference",null,null,"Pass/Fail","Cheapest","Carrier","Count"]
[null,null,null,null,null,null,null,null,null,"No Data","No Data",{"$f":"E4","v":0},"XPO",{"$f":"COUNTIF(F:F,M4)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"YRC",{"$f":"COUNTIF(F:F,M5)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Reddaway",{"$f":"COUNTIF(F:F,M6)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"OD",{"$f":"COUNTIF(F:F,M7)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Saia",{"$f":"COUNTIF(F:F,M8)","v":0}]