{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["UPS","Zions CC","UPS Invoices","UPS Report","Zions Current","Zions Archive"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"UPS","index":0,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["website","https://www.ups.com/one-to-one/login?returnto=https%3a//www.apps.ups.com/ebilling/sso.do%3floc%3den_US&reasonCode=-1"]
["username"]
["password"]
["Folder","C:\\Users\\Administrator\\Desktop\\UPS Invoice"]

{"sheet":"Zions CC","index":1,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Website","https://www.zionsbank.com/"]
["Company ID"]
["Login ID"]
["password"]
["Folder","C:\\Users\\Administrator\\Desktop\\Zions Invoice"]

{"sheet":"UPS Invoices","index":2,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Old Invoices","New Invoices","Entered?"]
["460873"]
["460864"]
["651274"]
["991039","129074"]
["310306"]
["426423","816552"]
["942631"]
["436178"]
["051112"]
["753181"]
["051122"]
["051132"]
[808081]
[51142]

{"sheet":"UPS Report","index":3,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Invoice #",51142]
["Invoice Date","2012-04-07"]
["Due Date","2012-04-16"]
["Invoice Amt",{"$f":"SUM(B7:B86)","v":191.32}]
[]
["Entered?","Invoice Amt","Ref 1","Ref 2","Ref 3","Sender Name","Reciever Name","Company Name","Receiver Street","Receiver City","Receiver State","Receiver Zip","Tracking"]
[null,32.17,21372,400770402876218,183348,"PARAMOUNT APPAREL",null,"PRODIGY PROMOS","123 W 130TH S","LINDON","UT",84042,"1Z76661R0373"]
[null,14.96,21614,null,null,null,null,null,null,null,null,null,"1Z4F90510341","1Z4F90510341"]
[null,43.5,21672,"Box 1 of 4",null,"THERMOPRO INC",null,"Oregon Athletic Clubs",null,"Portland","OR",97239,"1Z9R96180342","1Z9R96180342"]
[null,62.96,21713,null,null,null,"PO 412054 11TSGIVEAW","Kicker","3100 North Husband St.","STILLWATER","OK",74075,"1Z4F90510342","1Z4F90510341","1Z4F90510342","1Z4F90510341"]
[null,27.48,21714,1031087000,null,"HIT PROMOTIONAL",null,"CHICKEN RANCH CASINO","16929 CHICK",null,null,null,"1Z69R6E00300"]
[null,10.25,21719,"Spaur-Rachel/Prodigy Promos",null,"Spaur - Rachel","Receiver","TGA of West DFW","7633 Cedarhill Road","WATAUGA","TX",76148,"1Z4F90510399"]
[]
["The invoice continued, but for confidentiality reasons I just displayed a few lines with changed information"]

{"sheet":"Zions Current","index":4,"n_rows":106,"n_cols":7,"rows_kept":106,"cut":false,"hidden":false,"merged":[]}
[null,null,"Total Amount",{"$f":"SUM(D5:D106)","v":13836.699999999997}]
[null,null,"Vouched Amount",{"$f":"SUMIF(E5:E106, \"x\", D5:D106)","v":32586.699999999997}]
[]
["Date","Ref #","Transaction Detail","Amount","Vouched","Invoice","Notes"]
["2012-04-07","2476501FJ5V4","Sample Company #1",1426]
["2012-04-07","2443565FJ5V4","Sample Company #2",282]
["2012-04-06","2469216FH00V","Sample Company #3",1348]
["2012-04-06","2449215FHRP1","Sample Company #4",461]
["2012-04-06","2444500FJHF3","Sample Company #5",800]
["2012-04-06","2405523FJ60T","Sample Company #6",245]
["2012-04-05","2469216FG00F","Sample Company #7",178]
["2012-04-05","2449215FGRP0","Sample Company #8",80]
["2012-04-05","2469216FG00Q","Sample Company #9",1117]
["2012-04-04","2407105FG4K9","Sample Company #10",1165]
["2012-04-04","2475542FG3TZ","Sample Company #11",1002]
["2012-04-04","2427539FFS66","Sample Company #12",1132]
["2012-04-04","2427539FFS66","Payment",-29600]
["2012-04-04","7423168FF0D1","Sample Company #14",369]
["2012-04-04","2401339FF07L","Sample Company #15",1245]
["2012-04-04","2464373FFWGN","Sample Company #16",303,"x","x"]
["2012-04-04","2444500FE2XH","Sample Company #17",570,"x","x"]
["2012-04-04","7427074FD8YV","Sample Company #18",82,"x","x"]
["2012-04-04","2422443FF30V","Sample Company #19",1023,"x","x"]
["2012-04-02",null,"Sample Company #20",1367,"x","x","bottle sample"]
["2012-04-02",null,"Sample Company #21",490,"x","x","customer gift"]
["2012-04-02",null,"Sample Company #22",1470,"x","x"]
["2012-03-30",null,"Sample Company #23",1397,"x","x","software refund"]
["2012-03-30",null,"Sample Company #24",489,"x","x",410]
["2012-03-30",null,"Sample Company #25",448,"x","x",410]
["2012-03-29",null,"Sample Company #26",328,"x","x"]
["2012-03-29",null,"Sample Company #27",848,"x","x",21636]
["2012-03-29","2461043F903R","Sample Company #28",528,"x","x","insurance"]
["2012-03-29","2444500FAHF2","Sample Company #29",488,"x","x",21413]
["2012-03-29","2423168F90D1","Sample Company #30",269,"x","x",21724]
["2012-03-28","2469216F800A","Sample Company #31",796,"x","x",21756]
["2012-03-28","2461043F803T","Sample Company #32",424,"x","x","insurance"]
["2012-03-28","2444500F9HF1","Sample Company #33",306,"x","x",21617]
["2012-03-28","2401339F9079","Payment",-13500,"x","x",21647]
["2012-03-28","2480166F8WGN","Sample Company #35",901,"x","x",21749]
["2012-03-27","2469216F7006","Sample Company #36",1474,"x","x","customer gifts"]
["2012-03-26","2450601F6WGN","Sample Company #37",1006,"x","x","advertising"]
["2012-03-26","2450601F6WGN","Sample Company #38",687,"x","x","advertising"]
["2012-03-23","2444500F4HF0","Sample Company #39",96,"x","x",21526]
["2012-03-23","2401339F306Z","Sample Company #40",1473,"x","x",21506]
["2012-03-23","2443565F38AT","Sample Company #41",1063,"x","x",21695]
["2012-03-23","2407105F34KA","Sample Company #42",1086,"x","x","meals & entertainment"]
["2012-03-21","2475542F2M8L","Sample Company #43",1415,"x","x","email"]
["2012-03-21","2469216F100A","Sample Company #44",385,"x","x",21668]
["2012-03-20","2449398F160W","Sample Company #45",733,"x","x","meals & entertainment"]
["2012-03-20","2469216F0007","Sample Company #46",305,"x","x","customer gifts"]
["2012-03-19","2415813F02AM","Sample Company #47",492,"x","x","21649, 21657"]
["2012-03-19","7476900F0BJN","Sample Company #48",146,"x","x"]
["2012-03-19","2469216EZ001","Sample Company #49",157,"x","x","software"]
["2012-03-19","2463923EZS66","Sample Company #50",1410,"x","x",21557]
["2012-03-17","2469216EX00E","Sample Company #51",744,"x","x","furniture and equipment"]
["2012-03-16","2405523EX5ZV","Sample Company #52",963,"x","x",21590]
["2012-03-16","2449398EW5SG","Sample Company #53",1054,"x","x",21632]
["2012-03-16","2475542EXM8J","Sample Company #54",349,"x","x",21604]
["2012-03-16","2475542EW7W5","Sample Company #55",765,"x","x",21323]
["2012-03-16","2469216EW002","Sample Company #56",1282,"x","x","printer"]
["2012-03-15","2425477EWDE8","Sample Company #57",898,"x","x","sp cost"]
["2012-03-15","2470780EWWGS","Sample Company #58",1031,"x","x","office maintenance"]
["2012-03-15","2423168EV0D1","Sample Company #59",42,"x","x",21514]
["2012-03-14","2475542EV3TR","Sample Company #60",306,"x","x",21561]
["2012-03-14","7471705EVGWV","Sample Company #61",1075,"x","x","travel"]
["2012-03-14","2455930EVBLH","Sample Company #62",148,"x","x",21608]
["2012-03-14","2415813EV261","Sample Company #63",688,"x","x",21598]
["2012-03-14","2407105EVWPB","Sample Company #64",282,"x","x","trade show"]
["2012-03-14","2407105EVWPB","Sample Company #65",1162,"x","x"]
["2012-03-14","2401339EV06G","Sample Company #66",498,"x","x","dues"]
["2012-03-14","2480166ESLQ2","Sample Company #67",332,"x","x","web hosting"]
["2012-03-13","2475542ES4QQ","Sample Company #68",554,"x","x","email"]
["2012-03-13","2469216ET007","Payment",-13600,"x","x","web hosting"]
["2012-03-13","2405523ET61A","Sample Company #70",1482,"x","x",21342]
["2012-03-12","7454706ET216","Sample Company #71",1388,"x","x","travel"]
["2012-03-12","2427539ERS66","Sample Company #72",911,"x","x",21554]
["2012-03-12","2427539ERS66","Sample Company #73",1172,"x","x",21554]
["2012-03-12","2423168ER0D1","Sample Company #74",759,"x","x",21535]
["2012-03-12","2407105ETWPB","Sample Company #75",544,"x","x"]
["2012-03-10","7454706ET216","Sample Company #76",1205,"x","x","travel"]
["2012-03-10","7454706ET216","Sample Company #77",1463,"x","x","travel"]
["2012-03-09","2469216EM009","Sample Company #78",734,"x","x","customer gifts"]
["2012-03-08","2443565EL5V4","Sample Company #79",341,"x","x",400]
["2012-03-08","2443106EM8AH","Sample Company #80",210,"x","x","meals & entertainment"]
["2012-03-07","2461043EK03T","Sample Company #81",1248,"x","x","insurance"]
["2012-03-07","2439900EK8JT","Sample Company #82",297,"x","x","customer gifts"]
["2012-03-07","2427074EK8YV","Sample Company #83",1337,"x","x",21466]
["2012-03-07","2425477EKDG7","Sample Company #84",1312,"x","x",21452]
["2012-03-07","2480165ELWGN","Payment",-7500,"x","x",21333]
["2012-03-07","2423168EK0D1","Sample Company #86",1048,"x","x",21490]
["2012-03-07","2415813EL1ZG","Sample Company #87",599,"x","x",21404]
["2012-03-06","2476900EJEKL","Sample Company #88",1412,"x","x","bank fee"]
["2012-03-06","2455930EJBLH","Sample Company #89",762,"x","x",21461]
["2012-03-06","2425477EJDE8","Sample Company #90",200,"x","x","sp cost"]
["2012-03-06","2415813EK1YJ","Sample Company #91",409,"x","x"]
["2012-03-06","2476579EJLDR","Sample Company #92",801,"x","x",21436]
["2012-03-06","2450601EHWGR","Sample Company #93",416,"x","x",21459]
["2012-03-03",null,"Sample Company #94",1001,"x","x","travel"]
["2012-03-03",null,"Sample Company #95",655,"x","x","travel"]
["2012-03-03",null,"Payment",-11300,"x"]
["2012-03-02",null,"Sample Company #97",44,"x"]
["2012-03-02",null,"Sample Company #98",151,"x"]
["2012-03-01",null,"Sample Company #99",983,"x"]
["2012-03-01",null,"Sample Company #100",444,"x"]
["2012-03-01",null,"Sample Company #101",601,"x"]
["2012-02-01","2012-02-01","Monthly Summary",17929.699999999997,"x"]

{"sheet":"Zions Archive","index":5,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Date","Ref #","Transaction Detail","Amount","Vouched","Invoice","Notes"]
["2012-02-29",null,"Sample Company #102",458.94,"x"]
["2012-02-29",null,"Sample Company #103",-7000,"x"]
["2012-02-28",null,"Sample Company #104",62,"x"]
["2012-02-28",null,"Sample Company #105",1545,"x"]
["2012-02-28",null,"Sample Company #106",219.99,"x"]
["2012-02-28",null,"Sample Company #107",3976,"x"]
["2012-02-28",null,"Sample Company #108",1425,"x"]
["2012-02-27",null,"Sample Company #109",316.12,"x"]
["2012-02-24",null,"Sample Company #110",315.25,"x"]
["2012-02-23",null,"Sample Company #111",180,"x"]
["2012-02-22",null,"Sample Company #112",1.6,"x"]
["2012-02-21",null,"Sample Company #113",2154.2199999999998,"x"]
["2012-02-20",null,"Sample Company #114",156.74,"x"]
["2012-02-18",null,"Sample Company #115",90.74,"x"]
["2012-02-15",null,"Sample Company #116",3.2,"x"]
["2012-02-15",null,"Sample Company #117",127.87,"x"]
["2012-02-10",null,"Sample Company #118",26.44,"x"]
["2012-02-09",null,"Sample Company #119",237.92,"x"]
["2012-02-09",null,"Sample Company #120",514.83000000000004,"x"]
["2012-02-08",null,"Sample Company #121",96.52,"x"]
["2012-02-06",null,"Sample Company #122",91.32,"x"]
["2012-02-04",null,"Sample Company #123",1440.82,"x"]
["2012-02-04",null,"Sample Company #124",750,"x"]
["2012-02-03",null,"Sample Company #125",2,"x"]
["2012-02-03",null,"Sample Company #126",10737.18,"x"]