{"text_format":"1","workbook":"xlsx","n_sheets":62,"sheets":["WELCOME","Travel Data","First Quarter","Manager List","BLANK (4)","ENTER EDIT (7)","KEYBOARD","FORMATTING  (17)","DATES (4)","INTRO FORMULAS (11)","RANGE NAMES (5)","1ST QTR","2ND QTR","3RD QTR","4th QTR","ANNUAL SUMMARY (16)","FUNCTIONS (15)","IF FUNCTION (16)","ORIENTATION (18)","CONDITIONAL FORMATTING (6)","DATA BARS (6)","TABLE (8)","LINK PP (33)","TEXT 2 COLUMNS WORDS","TEXT 2 COLUMNS (12)","TEXT (14)","CONCATENATE (14)","DUPLICATES","SUBTOTALS (15)","PIVOT TABLES (16)","Grades","Store 1","Store 2","Store 3","CELL PROTECTION (21)","SHEET PROTECT (21)","VALIDATION (22)","IF FUNCTION (23)","VLOOKUP (24)","PRINT MACRO (27)","PRODUCTS MACRO (30)","PRODUCTS MACRO (31)","PRODUCTS MACRO (32)","PRODUCTS MACRO (33)","PASTE SPECIAL (4)","CONSOLIDATED (18)","STORE 1 (18)","STORE 2 (18)","STORE 3 (18)","LOAN PMT (23)","GOAL SEEK RETIRE (28)","SOLVER ROB","SOLVER (28)","SOLVER WIERD","Pesky Penny Problem","Screwed Up Phone Numbers","MATCH CLEAN INDEX","SUMIFS","TRUCK STOP","VLOOKUP MATCH","INDEX MATCH ","MAIL MERGE"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":6,"defined_names":325,"comments":2,"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":"WELCOME","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Travel Data","index":1,"n_rows":296,"n_cols":10,"rows_kept":296,"cut":false,"hidden":false,"merged":[]}
["Passenger Name","Type","Vendor","Depart","Return","Daily Rate","Total Fare","Itinerary","Invoice #","rand"]
["Adams/Donna","Dom. Air","Delta Air Lines","2000-05-15","2000-05-20",113.87,600,"ATLPHXATL","110125S",{"$f":"RAND()","v":0.5164871265383687}]
["Adams/Donna","TRANS FEE","ARC","2000-05-15",null,10,670,"ARC","110125S",0.706820726265313]
["Adams/Jim","Dom. Air","Delta Air Lines","2000-05-15","2000-05-20",113.87,10,"ATLPHXATL","110124S",0.51347574363391757]
["Adams/Jim","TRANS FEE","ARC","2000-01-27",null,10,10,"ARC","109555S",0.244510098085155]
["Adams/Jim","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110124S",0.54356791027318363]
["Atkins/Ron","Dom. Air","Northwest Airlines","2000-02-23","2000-02-24",522,400,"OKCMEMTPAMEMOKC","110175S",0.45198316258377869]
["Atkins/Ron","Car","Hertz","2000-02-23","2000-02-24",82,82,"TPA","110175S",0.64959852808917384]
["Atkins/Ron","TRANS FEE","ARC","2000-02-23",null,10,10,"ARC","110175S",0.2986358806444861]
["Carrey/Barry","Dom. Air","Delta Air Lines","2000-05-12","2000-05-19",78.849999999999994,552,"MGMATLDAYATLPHXATLMGM","110802S",0.82269549857055335]
["Carrey/Barry","TRANS FEE","ARC","2000-05-12",null,10,10,"ARC","110802S",0.32326511746014452]
["Carrey/Pam","Dom. Air","Delta Air Lines","2000-05-12","2000-05-19",78.849999999999994,552,"MGMATLDAYATLPHXATLMGM","110803S",0.49140572017237605]
["Carrey/Pam","TRANS FEE","ARC","2000-05-12",null,10,10,"ARC","110803S",0.90493511943921356]
["Chile/Juan","Dom. Air","America West Airlines","2000-05-11","2000-05-18",53.21,372.5,"FLLLASPHXFLL","110583S",0.49568726097635907]
["Chile/Juan","TRANS FEE","ARC","2000-05-11",null,10,10,"ARC","110583S",0.23519559844472071]
["Conelly/Doug","Hotel","Raintree Plaza Hotel","2000-04-17","2000-04-20",152,456,"DEN","111088S",0.59320671801047731]
["Conelly/Doug","Dom. Air","Delta Air Lines","2000-03-06","2000-03-06",253,253,"TPAATLPHL","110447S",0.75661598923407003]
["Conelly/Doug","Dom. Air","Continental Airlines","2000-03-08","2000-03-08",166.5,166.5,"MDTCLETPA","110449S",0.85369411618570235]
["Conelly/Doug","Dom. Air","USAir","2000-03-07","2000-03-07",148.5,148.5,"PHLMDT","110448S",0.88200924433563532]
["Conelly/Doug","Car","Alamo","2000-04-17","2000-04-20",48.39,145.16999999999999,"DEN","111088S",0.87498129125660973]
["Conelly/Doug","Car","Alamo","2000-03-07","2000-03-08",88,88,"MDT","110448S",3.849678040194382E-2]
["Conelly/Doug","Hotel","RADISSON","2000-03-07","2000-03-08",79,79,"MDT","110448S",0.2923262024690727]
["Conelly/Doug","Hotel","COURTYARD BY MARRIOTT","2000-03-06","2000-03-07",75,75,"PHL","110447S",0.46171763347402961]
["Conelly/Doug","Car","Alamo","2000-03-06","2000-03-07",51,51,"PHL","110447S",0.59785946791919142]
["Conelly/Doug","TRANS FEE","ARC","2000-04-17",null,10,10,"ARC","111088S",7.4713367604733794E-2]
["Conelly/Doug","TRANS FEE","ARC","2000-03-06",null,10,10,"ARC","110447S",0.420133455915085]
["Couto/Terry","Hotel","Holiday Inn Express","2000-01-31","2000-02-14",109,1526,"CLW","109640S",8.0626423205729658E-3]
["Couto/Terry","Dom. Air","Delta Air Lines","2000-04-30","2000-05-02",282,564,"TPAATLORDATLTPA","111269S",0.906668777498988]
["Couto/Terry","Dom. Air","Southwest Airlines","2000-03-23",null,194,194,"TPAMSYTPA","110766S",8.4205607596981813E-2]
["Couto/Terry","Car","Hertz","2000-02-04","2000-02-07",38.39,115.17,"EWR","109756S",0.76634160066424295]
["Couto/Terry","TRANS FEE","ARC","2000-04-30",null,10,10,"ARC","111269S",0.28533259798333033]
["Couto/Terry","TRANS FEE","ARC","2000-03-23",null,10,10,"ARC","110766S",0.64860769681793873]
["Cox/Becky","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",105.92,423.68,"MGMATLPHXATLTPA","110349S",0.89425346808106332]
["Cox/Becky","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110349S",0.89501574173214127]
["Cox/Becky","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",0,0,"MGMATLPHXATLMGM","110794S",0.3611097405221716]
["Cox/William G","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",105.92,423.68,"MGMATLPHXATLTPA","110348S",0.87170896599421188]
["Cox/William G","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110348S",0.95363154242018544]
["Cox/William G","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",0,0,"MGMATLPHXATLMGM","110793S",0.89080982984019408]
["Coyle/Marcus","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",142.34,569.36,"ATLPHXATL","110742S",0.71858576999618962]
["Coyle/Marcus","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110742S",0.6159673642705108]
["Coyle/Mary","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",142.34,569.36,"ATLPHXATL","110743S",0.94202562334930373]
["Coyle/Mary","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110743S",0.57936382046846036]
["Dain/Phyllis","Dom. Air","United Airlines","2000-04-10","2000-04-14",119.75,479,"ARCATWORDTPAORDATW","110939S",0.93296003603808608]
["Dain/Phyllis","TRANS FEE","ARC","2000-04-10",null,10,10,"ARC","110939S",0.42474289860015668]
["Deitz/Michele","Dom. Air","Delta Air Lines","2000-02-15","2000-02-16",300,300,"STLATLTPAATLSTL","109811S",0.85419078213869326]
["Deitz/Michele","TRANS FEE","ARC","2000-02-15",null,10,10,"ARC","109811S",0.12616598683093627]
["Douglas/Jay","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",142.34,569.36,"ATLPHXATL","110372S",0.48096425790687292]
["Douglas/Jay","Dom. Air","Delta Air Lines","2000-01-27","2000-01-28",175.5,175.5,"ATLDTWATL","109285S",0.65019563976090211]
["Douglas/Jay","TRANS FEE","ARC","2000-01-27",null,10,10,"ARC","109285S",0.41868019778229859]
["Douglas/Jay","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110372S",0.95330196561287062]
["Douglas/Steve","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",142.34,569.36,"ATLPHXATL","110373S",0.71269686790766507]
["Douglas/Steve","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110373S",0.31706069040118035]
["Drake/Deborah","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",50.5,202,"TPADFWPHXATLTPA","109890S",0.24947680191295374]
["Drake/Deborah","Dom. Air","ARC","2000-05-15","2000-05-19",2.5,10,"TPADFWPHXATLTPA","109890S",0.81185236611989753]
["Dulla/Katie","Dom. Air","America West Airlines","2000-05-16","2000-05-19",123.06,369.19,"ORDPHXORD","110957S",0.25112681638707379]
["Dulla/Katie","TRANS FEE","ARC","2000-05-16",null,10,10,"ARC","110957S",0.16167845666054081]
["Dulla/Michael","Dom. Air","America West Airlines","2000-05-16","2000-05-19",123.06,369.19,"ORDPHXORD","110956S",0.46461671775326696]
["Dulla/Michael","TRANS FEE","ARC","2000-05-16",null,10,10,"ARC","110956S",0.48643953768297354]
["Dunaway/Mary","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",145.09,580.36,"PNSATLPHXATLPNS","110229S",5.5595942785136021E-2]
["Dunaway/Mary","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110229S",0.88956893312589114]
["Dunaway/Roger","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",145.09,580.36,"PNSATLPHXATLPNS","110228S",0.82187310003666936]
["Dunaway/Roger","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110228S",0.89705987074842675]
["Glass/Helen","Dom. Air","United Airlines","2000-02-15","2000-02-16",377,377,"IADTPAIAD","109817S",0.74182895150175898]
["Glass/Helen","TRANS FEE","ARC","2000-02-15",null,10,10,"ARC","109817S",0.16222147570652845]
["Griffin/Linda","Dom. Air","America West Airlines","2000-05-11","2000-05-18",53.21,372.5,"FLLLASPHXFLL","110584S",0.47420146864631618]
["Griffin/Linda","TRANS FEE","ARC","2000-05-11",null,10,10,"ARC","110584S",{"$f":"RAND()","v":0.86260294255429271}]
["Hargett/Judy","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",142.34,569.36,"ATLPHXATL","110374S",0.48784007149587039]
["Hargett/Judy","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110374S",0.28309465326614858]
["Hawks/Tammy","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",142.34,569.36,"ATLPHXATL","110375S",0.32971727000959739]
["Hawks/Tammy","Dom. Air","Delta Air Lines","2000-01-27","2000-01-28",175.5,175.5,"ATLDTWATL","109286S",0.84789673530935472]
["Hawks/Tammy","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110375S",0.91812568290135921]
["Hawks/Tammy","TRANS FEE","ARC","2000-01-27",null,10,10,"ARC","109286S",0.48252930281609763]
["Hill/Joseph","Dom. Air","Delta Air Lines","2000-03-15","2000-03-20",85,425,"TPADFWRNODFWTPA","110435S",0.45792901575601686]
["Hill/Joseph","TRANS FEE","ARC","2000-03-15",null,10,10,"ARC","110435S",0.41771577337425836]
["Hill/Vicki","Dom. Air","Continental Airlines","2000-02-13","2000-02-18",129.5,647.5,"TPAIAHDFWIAHTPA","109835S",0.31092735343777922]
["Hill/Vicki","Dom. Air","Trans World Airlines","2000-03-27","2000-03-31",101,404,"TPASTLMCISTLTPA","110782S",0.50922553054671071]
["Hill/Vicki","Dom. Air","Delta Air Lines","2000-03-15","2000-03-23",40,320,"TPADFWRNODFWTPA","110434S",0.27654001177732557]
["Hill/Vicki","Car","Hertz","2000-02-27","2000-03-03",53,265,"DFW","110019S",0.12093383940138214]
["Hill/Vicki","Car","Hertz","2000-02-27","2000-03-03",53,265,"DFW","110018S",0.37635404735418898]
["Hill/Vicki","Car","Hertz","2000-02-13","2000-02-18",53,265,"DFW","109835S",1.4454092813740993E-2]
["Hill/Vicki","Car","Alamo","2000-03-27","2000-03-31",42.23,168.92,"MCI","110782S",0.70173730361935127]
["Hill/Vicki","Dom. Air","Continental Airlines","2000-02-27","2000-03-03",15,75,"TPAIAHDFWIAHTPA","110019S",0.16665880369791453]
["Hill/Vicki","Hotel","FAIRFIELD INN","2000-03-30","2000-03-31",64,64,"MCI","110782S",0.9388215510889254]
["Hill/Vicki","TRANS FEE","ARC","2000-02-27",null,10,10,"ARC","110018S",0.92607117419798446]
["Hill/Vicki","TRANS FEE","ARC","2000-02-13",null,10,10,"ARC","109835S",0.66947493420962978]
["Hill/Vicki","TRANS FEE","ARC","2000-03-15",null,10,10,"ARC","110434S",0.1474368787362792]
["Hill/Vicki","TRANS FEE","ARC","2000-03-27",null,10,10,"ARC","110782S",0.15169417695873466]
["Hill/Vickki","Dom. Air","Continental Airlines","2000-02-27","2000-03-03",0,0,"DFW","110019S",0.78906307314412083]
["Hopson/Marie","Dom. Air","Delta Air Lines","2000-02-15","2000-02-16",749,749,"DENATLTPAATLDEN","109814S",0.5709947603661879]
["Hopson/Marie","TRANS FEE","ARC","2000-02-15",null,10,10,"ARC","109814S",0.81678738861258315]
["Hosek/Sybil","Dom. Air","America West Airlines","2000-05-15","2000-05-21",50.69,304.18,"ORDPHXORD","110188S",0.26978104107218104]
["Hosek/Sybil","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110188S",8.1657034709211374E-2]
["Jernigan/Debbie","TRANS FEE","ARC","2000-01-27",null,10,10,"ARC","109556S",0.3260793511651261]
["Jernigan/Deborah","Dom. Air","Delta Air Lines","2000-05-15","2000-05-20",113.87,569.36,"ATLPHXATL","110134S",0.77863163341122987]
["Jernigan/Deborah","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110134S"]
["Jernigan/Tyrus","Dom. Air","Delta Air Lines","2000-05-15","2000-05-20",113.87,569.36,"ATLPHXATL","110135S"]
["Jernigan/Tyrus","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110135S"]
["Jiles.randall","Dom. Air","Southwest Airlines","2000-03-02",null,388,388,null,"110559S"]
["Jiles/Frances","Dom. Air","USAir","2000-04-14","2000-04-16",158.5,317,"PVDPHLJAXPHLPVD","110581S"]
["Jiles/Frances","Dom. Air","Southwest Airlines","2000-02-11",null,238.5,238.5,"PVDTPAPVD","109723S"]
["Jiles/Frances","TRANS FEE","ARC","2000-02-11",null,10,10,"ARC","109723S"]
["Jiles/Frances","TRANS FEE","ARC","2000-03-08",null,10,10,"ARC","110214S"]
["Jiles/Frances","TRANS FEE","ARC","2000-04-14",null,10,10,"ARC","110581S"]
["Jiles/Helvey","Dom. Air","Southwest Airlines","2000-03-03",null,393,393,"TPASTLTPA","110491S"]
["Jiles/Helvey","Car","Hertz","2000-03-03","2000-03-12",34.119999999999997,307.13,"STL","110491S"]
["Jiles/Helvey","TRANS FEE","ARC","2000-03-03",null,10,10,"ARC","110491S"]
["Jiles/Paul","Dom. Air","Delta Air Lines","2000-03-17","2000-03-19",195.25,390.5,"MSYATLCHSATLMSY","110393S"]
["Jiles/Paul","TRANS FEE","ARC","2000-03-17",null,10,10,"ARC","110393S"]
["Jiles/Randall","Hotel","Marriott Lincolnshire","2000-04-06","2000-04-09",218,654,"MSY","110185S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-05-15","2000-05-18",183.01,549.04,"PVDATLPHXCVGPVD","110478S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-01-26","2000-01-28",236,472,"TPACVGDTWATLTPA","109246S"]
["Jiles/Randall","Dom. Air","United Airlines","2000-04-30","2000-05-09",52.22,470,"PVDORDTPAIADPVD","111140S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-02-24","2000-02-27",126.33,379,"TPAATLDCAPVDATLTPA","110179S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-03-31","2000-04-02",181.5,363,"TPAATLPVDATLTPA","110165S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-03-10","2000-03-12",180,360,"TPAPVDATLTPA","110168S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-03-17","2000-03-19",180,360,"TPAPVDATLTPA","110167S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-03-24","2000-03-26",180,360,"TPAPVDATLTPA","110166S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-05-12","2000-05-22",36,360,"TPAPVDATLTPA","110470S"]
["Jiles/Randall","Dom. Air","Northwest Airlines","2000-01-28","2000-02-02",66.2,331,"DTWTPADTW","109678S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-03-02","2000-03-07",56.8,284,"TPACVGPVDDCAATLTPA","110176S"]
["Jiles/Randall","Dom. Air","USAir","2000-03-06","2000-03-06",272.5,272.5,"PVDDCA","110178S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-03-03","2000-03-05",130.5,261,"TPAPVDATLTPA","109090S"]
["Jiles/Randall","Dom. Air","Southwest Airlines","2000-04-06",null,194,194,"TPAMSYTPA","110185S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-01-29","2000-01-31",96,192,"TPAATLTPA","109245S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-04-21","2000-04-23",88,176,"TPAPVDATLTPA","110192S"]
["Jiles/Randall","Dom. Air","United Airlines","2000-06-28","2000-06-30",86.5,173,"TPAIADTPA","111093S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-05-05","2000-05-07",59,118,"TPAPVDATLTPA","111102S"]
["Jiles/Randall","Car","Hertz","2000-04-06","2000-04-09",35.090000000000003,105.27,"MSY","110185S"]
["Jiles/Randall","Dom. Air","USAir","2000-02-25","2000-02-25",104.5,104.5,"BWIPVD","110177S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-04-28","2000-04-30",43,86,"TPAATLPVDATLTPA","110196S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-01-27","2000-01-28",75,75,"TPAATLDTWATLTPA","109606S"]
["Jiles/Randall","Car","Hertz","2000-01-27","2000-01-28",63,63,"DTW","109606S"]
["Jiles/Randall","TRANS FEE","ARC","2000-01-26",null,10,10,"ARC","109246S"]
["Jiles/Randall","TRANS FEE","ARC","2000-01-27",null,10,10,"ARC","109619S"]
["Jiles/Randall","TRANS FEE","ARC","2000-01-28",null,10,10,"ARC","109678S"]
["Jiles/Randall","TRANS FEE","ARC","2000-01-29",null,10,10,"ARC","109245S"]
["Jiles/Randall","TRANS FEE","ARC","2000-02-24",null,10,10,"ARC","110179S"]
["Jiles/Randall","TRANS FEE","ARC","2000-03-02",null,10,10,"ARC","110176S"]
["Jiles/Randall","TRANS FEE","ARC","2000-03-02",null,10,10,"ARC","110559S"]
["Jiles/Randall","TRANS FEE","ARC","2000-03-03",null,10,10,"ARC","109090S"]
["Jiles/Randall","TRANS FEE","ARC","2000-03-10",null,10,10,"ARC","110168S"]
["Jiles/Randall","TRANS FEE","ARC","2000-03-17",null,10,10,"ARC","110167S"]
["Jiles/Randall","TRANS FEE","ARC","2000-03-24",null,10,10,"ARC","110166S"]
["Jiles/Randall","TRANS FEE","ARC","2000-03-31",null,10,10,"ARC","110165S"]
["Jiles/Randall","TRANS FEE","ARC","2000-04-06",null,10,10,"ARC","110185S"]
["Jiles/RANDALL","Dom. Air","ARC","2000-04-21","2000-04-23",5,10,"TPAPVDATLTPA","110192S"]
["Jiles/Randall","TRANS FEE","ARC","2000-04-28",null,10,10,"ARC","110187S"]
["Jiles/Randall","TRANS FEE","ARC","2000-04-30",null,10,10,"ARC","111140S"]
["Jiles/Randall","TRANS FEE","ARC","2000-05-05",null,10,10,"ARC","111100S"]
["Jiles/Randall","TRANS FEE","ARC","2000-05-12",null,10,10,"ARC","110470S"]
["Jiles/Randall","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110478S"]
["Jiles/Randall","TRANS FEE","ARC","2000-06-28",null,10,10,"ARC","111093S"]
["Jiles/Randall","Car","Hertz","2000-01-27","2000-01-28",0,0,"DTW","109619S"]
["Jiles/Randall","Dom. Air","USAir","2000-03-06","2000-03-06",-272.5,-272.5,"PVDDCA","110178R"]
["Jiles/Tyler","Dom. Air","Delta Air Lines","2000-02-18","2000-02-22",171.75,687,"PVDCVGTPAMCOPVD","110006S"]
["Jiles/Tyler","Dom. Air","USAir","2000-04-14","2000-04-16",158.5,317,"PVDPHLJAXPHLPVD","110582S"]
["Jiles/Tyler","TRANS FEE","ARC","2000-02-11",null,10,10,"ARC","109723S"]
["Jiles/Tyler","TRANS FEE","ARC","2000-02-18",null,10,10,"ARC","110006S"]
["Jiles/Tyler","TRANS FEE","ARC","2000-03-08",null,10,10,"ARC","110215S"]
["Jiles/Tyler","TRANS FEE","ARC","2000-04-14",null,10,10,"ARC","110582S"]
["JilesTyler","Dom. Air","Southwest Airlines","2000-02-11",null,238.5,238.5,"PVDTPAPVD","109723S"]
["Kaufman/Jeff","Dom. Air","America West Airlines","2000-05-13","2000-05-19",56.33,338,"FLLLASPHXFLL","110597S"]
["Kaufman/Jeff","TRANS FEE","ARC","2000-05-13",null,10,10,"ARC","110597S"]
["Kaufman/Tracy","Dom. Air","America West Airlines","2000-05-13","2000-05-19",56.33,338,"FLLLASPHXFLL","110598S"]
["Kaufman/Tracy","TRANS FEE","ARC","2000-05-13",null,10,10,"ARC","110598S"]
["Komar/Gary","Dom. Air","America West Airlines","2000-05-15","2000-05-21",50.69,304.18,"ORDPHXORD","110189S"]
["Komar/Gary","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110189S"]
["Lawson/Robert","Dom. Air","Delta Air Lines","2000-02-25","2000-02-28",360.66,1082,"DAYCVGTPACVGDAY","110324S"]
["Lawson/Robert","TRANS FEE","ARC","2000-02-25",null,10,10,"ARC","110324S"]
["Lipman/Rick","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",242.97,971.88,"RSWATLPHXATLRSW","110519S"]
["Lipman/Rick","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110519S"]
["Lostroh/Barry","Dom. Air","America West Airlines","2000-05-15","2000-05-19",79.430000000000007,317.72000000000003,"DENPHXDEN","110088S"]
["Lostroh/Barry","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110088S"]
["Lostroh/Joshua","Dom. Air","America West Airlines","2000-05-15","2000-05-19",79.430000000000007,317.72000000000003,"DENPHXDEN","110089S"]
["Lostroh/Joshua","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110089S"]
["Manning/Connie","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",109.5,438,"TPAATLPHXATLTPA","110152S"]
["Manning/Connie","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110152S"]
["Maxwell/Lauren","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",242.97,971.88,"RSWATLPHXATLRSW","110520S"]
["Maxwell/Lauren","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110520S"]
["Mcnulty/Margaret","Dom. Air","American Airlines","2000-05-10","2000-05-19",34.880000000000003,314,"ORDPHXORD","110121S"]
["Mcnulty/Margaret","TRANS FEE","ARC","2000-05-10",null,10,10,"ARC","110121S"]
["Mcnulty/Tom","Dom. Air","American Airlines","2000-05-10","2000-05-19",34.880000000000003,314,"ORDPHXORD","110120S"]
["Mcnulty/Tom","TRANS FEE","ARC","2000-05-10",null,10,10,"ARC","110120S"]
["Munch/Rick","Dom. Air","Delta Air Lines","2000-05-16","2000-05-19",182.01,546.04,"IADPHXATLIAD","110775S"]
["Munch/Rick","TRANS FEE","ARC","2000-05-16",null,10,10,"ARC","110775S"]
["Munch/William","Dom. Air","Delta Air Lines","2000-05-16","2000-05-19",182.01,546.04,"IADPHXATLIAD","110776S"]
["Munch/William","TRANS FEE","ARC","2000-05-16",null,10,10,"ARC","110776S"]
["Murphy/Niki","Dom. Air","Delta Air Lines","2000-02-03","2000-02-06",81.66,245,"TPAATLTPA","109637S"]
["Murphy/Niki","Car","Hertz","2000-02-03","2000-02-06",38.94,116.82,"ATL","109637S"]
["Murphy/Niki","TRANS FEE","ARC","2000-02-03",null,10,10,"ARC","109637S"]
["Newberry/Dayla","Dom. Air","America West Airlines","2000-05-15","2000-05-19",79.430000000000007,317.72000000000003,"DENPHXDEN","110221S"]
["Newberry/Dayla","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110221S"]
["Newberry/Tye","Dom. Air","America West Airlines","2000-05-15","2000-05-19",79.430000000000007,317.72000000000003,"DENPHXDEN","110220S"]
["Newberry/Tye","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110220S"]
["Newell/Patricia","Dom. Air","America West Airlines","2000-05-14","2000-05-20",52.95,317.72000000000003,"DENPHXDEN","110190S"]
["Newell/Patricia","Dom. Air","United Airlines","2000-01-27","2000-01-30",99.66,299,"DENDTWDEN","109343S"]
["Newell/Patricia","Car","Budget","2000-01-27","2000-01-30",24.99,74.97,"DTW","109483S"]
["Newell/Patricia","TRANS FEE","ARC","2000-01-27",null,10,10,"ARC","109343S"]
["Newell/Patricia","TRANS FEE","ARC","2000-05-14",null,10,10,"ARC","110190S"]
["Newell/Steve","Dom. Air","America West Airlines","2000-05-14","2000-05-20",52.95,317.72000000000003,"DENPHXDEN","110191S"]
["Newell/Steve","TRANS FEE","ARC","2000-05-14",null,10,10,"ARC","110191S"]
["Newell/Steven","Dom. Air","United Airlines","2000-01-27","2000-01-30",99.66,299,"DENDTWDEN","109342S"]
["Newell/Steven","TRANS FEE","ARC","2000-01-27",null,10,10,"ARC","109342S"]
["Pettinger/Sandra","Dom. Air","America West Airlines","2000-05-15","2000-05-19",79.430000000000007,317.72000000000003,"DENPHXDEN","110087S"]
["Pettinger/Sandra","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110087S"]
["Richardson/Charles","Dom. Air","America West Airlines","2000-05-16","2000-05-21",55.83,279.19,"TPAPHXTPA","110263S"]
["Richardson/Charles","TRANS FEE","ARC","2000-05-16",null,10,10,"ARC","110263S"]
["Richardson/Margretta","Dom. Air","America West Airlines","2000-05-16","2000-05-21",55.83,279.19,"TPAPHXTPA","110262S"]
["Richardson/Margretta","TRANS FEE","ARC","2000-05-16",null,10,10,"ARC","110262S"]
["Roberts/Desmond","Hotel","XX","2000-02-25","2000-02-28",94,282,"MIA","110193S"]
["Roberts/Desmond","Car","Alamo","2000-02-23","2000-03-01",26.74,187.19,"PIE","110193S"]
["Roberts/Desmond","Hotel","Howard Johnson","2000-02-28","2000-02-29",62.9,62.9,"DAB","110193S"]
["Ruttenburg/Margaret","Dom. Air","Delta Air Lines","2000-02-15","2000-02-16",417,417,"ORDATLTPAATLORD","109816S"]
["Ruttenburg/Margaret","TRANS FEE","ARC","2000-02-15",null,10,10,"ARC","109816S"]
["Sanders/Gene","Dom. Air","America West Airlines","2000-05-15","2000-05-19",119.66,478.64,"MIAPHXMIA","109994S"]
["Sanders/Gene","Dom. Air","American Airlines","2000-01-20","2000-01-20",135.5,135.5,"TPAMIA","109074S"]
["Sanders/Gene","Car","Hertz","2000-01-17","2000-01-20",45,135,"TPA","109073S"]
["Sanders/Gene","Dom. Air","USAir","2000-01-17","2000-01-17",109.5,109.5,"MIATPA","109073S"]
["Sanders/Gene","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","109994S"]
["Sanders/Genevieve","Dom. Air","America West Airlines","2000-05-15","2000-05-19",119.66,478.64,"MIAPHXMIA","109995S"]
["Sanders/Genevieve","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","109995S"]
["Slone/Laurie","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",100.75,403,"TPADFWPHXATLTPA","110934S"]
["Slone/Laurie","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110934S"]
["Slone/Tim","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",100.75,403,"TPADFWPHXATLTPA","110933S"]
["Slone/Tim","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110933S"]
["Smith/T Donald","Dom. Air","ARC","2000-01-27","2000-01-31",2.5,10,"TPAATLDTWATLTPA","109611S"]
["Smith/T Sam","Hotel","Marriott Lincolnshire","2000-02-28","2000-03-29",179,5370,"SNA","110461S"]
["Smith/T Sam","Dom. Air","Delta Air Lines","2000-02-28","2000-03-02",530,1590,"TPADFWSNADENATLTPA","110388S"]
["Smith/T Sam","Dom. Air","Delta Air Lines","2000-01-12","2000-01-13",1405,1405,"TPAATLSNADFWTPA","109173S"]
["Smith/T Sam","Dom. Air","United Airlines","2000-02-29","2000-02-29",754.5,754.5,"SNADEN","110461S"]
["Smith/T Sam","Dom. Air","Delta Air Lines","2000-01-27","2000-01-31",127.25,509,"TPAATLDTWATLTPA","109611S"]
["Smith/T Sam","Dom. Air","Delta Air Lines","2000-01-26","2000-01-31",90,450,"TPACVGDTWATLTPA","109247S"]
["Smith/T Sam","Dom. Air","United Airlines","2000-07-09","2000-07-11",209.25,418.5,"TPAORDTPA","111059S"]
["Smith/T Sam","Hotel","Marriott Lincolnshire","2000-02-28","2000-03-01",159,318,"SNA","110388S"]
["Smith/T Sam","Dom. Air","Delta Air Lines","2000-04-06","2000-04-09",104,312,"TPAATLTPA","111081S"]
["Smith/T Sam","Dom. Air","Delta Air Lines","2000-01-29","2000-01-29",294,294,"TPAATL","109718S"]
["Smith/T Sam","Hotel","Ritz Carlton","2000-04-06","2000-04-07",220,220,"ATL","111081S"]
["Smith/T Sam","Dom. Air","Delta Air Lines","2000-05-21","2000-05-23",94.5,189,"TPAATLTPA","110445S"]
["Smith/T Sam","Dom. Air","United Airlines","2000-06-28","2000-06-30",83.5,167,"TPAIADTPA","110692S"]
["Smith/T Sam","Car","Hertz","2000-07-09","2000-07-11",63,126,"ORD","111058S"]
["Smith/T Sam","Car","Hertz","2000-04-06","2000-04-09",41.39,124.17,"ATL","111081S"]
["Smith/T Sam","Car","Hertz","2000-01-28","2000-01-31",38.99,116.98,"ATL","109609S"]
["Smith/T Sam","Hotel","HILTON HOTELS","2000-02-29","2000-03-01",109,109,"DEN","110461S"]
["Smith/T Sam","Car","Hertz","2000-02-29","2000-03-01",64,64,"DEN","110461S"]
["Smith/T Sam","Car","Hertz","2000-03-01","2000-03-01",64,64,"DEN","110388S"]
["Smith/T Sam","Car","Hertz","2000-02-28","2000-03-01",26.54,53.09,"SNA","110388S"]
["Smith/T Sam","Car","Hertz","2000-02-28","2000-02-29",53.09,53.09,"SNA","110461S"]
["Smith/T Sam","TRANS FEE","ARC","2000-01-12",null,10,10,"ARC","109173S"]
["Smith/T Sam","TRANS FEE","ARC","2000-01-26",null,10,10,"ARC","109247S"]
["Smith/T Sam","TRANS FEE","ARC","2000-01-27",null,10,10,"ARC","109609S"]
["Smith/T Sam","TRANS FEE","ARC","2000-02-28",null,10,10,"ARC","110388S"]
["Smith/T Sam","TRANS FEE","ARC","2000-04-06",null,10,10,"ARC","111081S"]
["Smith/T Sam","TRANS FEE","ARC","2000-05-21",null,10,10,"ARC","110445S"]
["Smith/T Sam","TRANS FEE","ARC","2000-06-28",null,10,10,"ARC","110692S"]
["Smith/T Sam","TRANS FEE","ARC","2000-07-09",null,10,10,"ARC","111058S"]
["Smith/T Sam","Dom. Air","United Airlines",null,null,0,0,null,"110461A"]
["Smith/T Sam","Dom. Air","Delta Air Lines","2000-01-27","2000-01-31",-117.5,-470,"TPAATLDTWATLTPA","109292R"]
["Smith/T Sam","Dom. Air","Delta Air Lines","2000-01-12","2000-01-13",-1405,-1405,"TPAATLSNADFWTPA","109173R"]
["Smith/Timothy D","Dom. Air","Continental Airlines","2000-02-10","2000-02-10",97.5,97.5,"TLHTPA","109644S"]
["Smith/Timothy D","TRANS FEE","ARC","2000-02-10",null,10,10,"ARC","109644S"]
["SPEER/STEPHEN","Dom. Air","AirTran Airways, Inc.","2000-02-24",null,403,403,"ATLTPAATL","110184S"]
["Speer/Stephen","Car","Hertz","2000-02-24","2000-02-24",41,41,"TPA","110184S"]
["Speer/Stephen","TRANS FEE","ARC","2000-02-24",null,10,10,"ARC","110184S"]
["Stubbs/Sally","Dom. Air","USAir","2000-02-16","2000-02-16",417.5,417.5,"TPADCA","109986S"]
["Stubbs/Sally","Dom. Air","Continental Airlines","2000-02-17","2000-02-17",415.5,415.5,"DCACLETPA","109987S"]
["Stubbs/Sally","Hotel","XX","2000-02-16","2000-02-17",129,129,"WAS","109986S"]
["Stubbs/Sally","TRANS FEE","ARC","2000-02-16",null,10,10,"ARC","109986S"]
["Towner/Tonya","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",109.5,438,"TPAATLPHXATLTPA","110153S"]
["Towner/Tonya","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110153S"]
["Van Essen/Delwyn","Dom. Air","United Airlines","2000-01-27","2000-01-30",99.66,299,"DENDTWDEN","109340S"]
["Van Essen/Delwyn","Car","Dollar","2000-01-27","2000-01-30",19.989999999999998,59.97,"DTW","109340S"]
["Van Essen/Delwyn","TRANS FEE","ARC","2000-01-27",null,10,10,"ARC","109340S"]
["Van Essen/Dianne","Dom. Air","United Airlines","2000-01-27","2000-01-30",99.66,299,"DENDTWDEN","109341S"]
["Van Essen/Dianne","TRANS FEE","ARC","2000-01-27",null,10,10,"ARC","109341S"]
["Vanessen/Del","Dom. Air","America West Airlines","2000-05-15","2000-05-19",79.430000000000007,317.72000000000003,"DENPHXDEN","110169S"]
["Vanessen/Del","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110169S"]
["Vanessen/Diane","Dom. Air","America West Airlines","2000-05-15","2000-05-19",79.430000000000007,317.72000000000003,"DENPHXDEN","110170S"]
["Vanessen/Diane","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110170S"]
["Weatherby/Charles","Dom. Air","Delta Air Lines","2000-03-20","2000-03-22",391.85,783.7,"TPADFWSJDDFWTPA","110426S"]
["Weatherby/Charles","Dom. Air","Continental Airlines","2000-05-12","2000-05-14",138,276,"TPAIAHOMAIAHTPA","110141S"]
["Weatherby/Charles","TRANS FEE","ARC","2000-03-20",null,10,10,"ARC","110426S"]
["Weatherby/Charles","TRANS FEE","ARC","2000-05-12",null,10,10,"ARC","110141S"]
["Weatherby/Jamie","Dom. Air","America West Airlines","2000-05-14","2000-05-25",37.36,411,"OMAPHXTPA","110094S"]
["Weatherby/Jamie","TRANS FEE","ARC","2000-05-14",null,10,10,"ARC","110094S"]
["Weatherby/Nancy","Dom. Air","Delta Air Lines","2000-03-20","2000-03-22",391.85,783.7,"TPADFWSJDDFWTPA","110429S"]
["Weatherby/Nancy","Dom. Air","America West Airlines","2000-05-14","2000-05-25",37.36,411,"OMAPHXTPA","110151S"]
["Weatherby/Nancy","Dom. Air","Delta Air Lines","2000-01-26","2000-01-28",165.5,331,"TPACVGDTWATLTPA","109493S"]
["Weatherby/Nancy","Dom. Air","Northwest Airlines","2000-01-28","2000-02-02",66.2,331,"DTWTPADTW","109679S"]
["Weatherby/Nancy","Hotel","HYATT REGENCY","2000-03-23","2000-03-25",125,250,"MCO","110325S"]
["Weatherby/Nancy","Dom. Air","Continental Airlines","2000-05-12","2000-05-12",211.5,211.5,"TPAIAHOMA","110150S"]
["Weatherby/Nancy","TRANS FEE","ARC","2000-01-26",null,10,10,"ARC","109493S"]
["Weatherby/Nancy","TRANS FEE","ARC","2000-01-28",null,10,10,"ARC","109679S"]
["Weatherby/Nancy","TRANS FEE","ARC","2000-03-20",null,10,10,"ARC","110429S"]
["Weatherby/Nancy","TRANS FEE","ARC","2000-05-12",null,10,10,"ARC","110150S"]
["Williams/Samantha","Dom. Air","Delta Air Lines","2000-01-10","2000-01-11",280,280,"ATLTPAATL","109203S"]
["Williams/Samantha","TRANS FEE","ARC","2000-01-10",null,10,10,"ARC","109203S"]

{"sheet":"First Quarter","index":2,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"First Quarter Sales"]
[null,null,"January","February","March","Total Sales"]
[null,"New Mexico",1345,2345,4567,{"$f":"SUM(C5:E5)","v":8257}]
[null,"Washington",3333,3456,6443,{"$f":"SUM(C6:E6)","v":13232}]
[null,"Oregon",2356,7665,9999,{"$f":"SUM(C7:E7)","v":20020}]
[null,"Colorado",4000,4444,5555,{"$f":"SUM(C8:E8)","v":13999}]

{"sheet":"Manager List","index":3,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["First Name","Last Name","Hire Date","SS #","Department","Position","Annual Salary","Perf Rating","Mgmt Level"]
["elizabeth","ridenhauer","1997-04-29",459306733,"Corporate Manager","Vice President",65000,5,1]
["elizabeth","ridenhauer","1997-04-29",459306733,"Corporate Manager","Vice President",65000,5,1]
["alice","wortman","1998-04-03",707942310,"Corporate Manager","Marketing Manager",85000,4,2]
["tyrone","anderson","1995-12-02",146902472,"Corporate Staff","Division Manager",42000,3,3]
["stuart","klein","1999-05-28",345005582,"Corporate Staff","Accounting Staff",55000,4,2]
["catherine","forest","2000-06-14",368370245,"Corporate Manager","Director of Advertising",46000,3,2]
["mechell","clese","1995-05-09",456080278,"Corporate Staff","Copy Writer",58000,3,4]
["kate","jones","2000-07-25",481349363,"Corporate Staff","Accounting Staff",45000,2,3]
["ellen","spinnaker","1993-04-07",570286844,"Corporate Staff","Circulation Manager",70000,4,3]
["will","mullen","1999-06-08",611048942,"Corporate Staff","Division Manager",53500,4,3]
["brad","turner","1997-09-17",345035237,"Management Staff","Accounting Staff",65000,3,3]
["mark","macdowell","2000-05-06",820015532,"Management Staff","Web Manager",55000,2,3]
["william","martin","1952-07-01",469440032,"Retail","Product Manager",55500,2,3]
["jim","kirney","1995-10-28",618035383,"Retail","Product Manager",47500,3,3]
["michelle","campbell","1998-05-05",681302482,"Management Staff","Accounting Staff",42000,3,2]
["ty ","simmons","1999-05-14",679694534,"Retail","Product Manager",57500,3,3]
["dennis","denton","1987-07-04",692241314,"Section Manager","Director of Training",45000,4,3]
["michael","gapner","1961-08-20",706670481,"Management Staff","Payroll Manager",48000,3,3]
["eileen","wilson","1995-07-29",682110774,"Retail","Product Manager",48000,4,3]
["george","fernandez","1997-03-30",781041004,"Corporate Manager","Office Manager",48000,5,2]
["james","bruce","2000-05-29",248944357,"Section Manager","Dir. Of Shipping",55000,1,3]
["marcia","smith","1995-01-14",931026545,"Corporate Manager","General Sales Manager",42000,2,2]

{"sheet":"BLANK (4)","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"ENTER EDIT (7)","index":5,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"This is text"]
[null,772]
[null,38540]
[null,"2005-07-07"]
[]
[null,"1900-01-01"]
[]
[null,"Januayr"]

{"sheet":"KEYBOARD","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"FORMATTING  (17)","index":7,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"First Quarter Sales"]
[null,null,"January","February","March","Total","Comments"]
[null,"Oregon",34566,2345,5000,{"$f":"SUM(C5:E5)","v":41911}]
[null,"California",3333,4000,7000,{"$f":"SUM(C6:E6)","v":14333}]
[null,"Washington",2356,7665,9999,{"$f":"SUM(C7:E7)","v":20020}]
[null,"Texas",3333,4444,5555,{"$f":"SUM(C8:E8)","v":13332}]

{"sheet":"DATES (4)","index":8,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[null,"Static","Dynamic"]
["Current Date"]
[]
["Current Time"]

{"sheet":"INTRO FORMULAS (11)","index":9,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"January","February","Total"]
[null,"Product A",12,6]
[null,"Product B",9,14]
[null,"Product C",18,2]
[]
[null,"Note:"]
[null,"Product A"]
[null,"Price"]
[null,"Revenue"]
[]
[]
[]
[null,null,"+"]
[null,null,"-"]
[null,null,"*"]
[null,null,"/"]

{"sheet":"RANGE NAMES (5)","index":10,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Tax Rate",8.2500000000000004E-2]
[]
["Price","Shipping","Total"]
[12,2]
[15,3]
[18,4]
[25,5]

{"sheet":"1ST QTR","index":11,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"First Quarter Sales"]
[null,null,"January","February","March","Total Sales"]
[null,"Arizona",1345,2345,4567,{"$f":"SUM(C5:E5)","v":8257}]
[null,"Texas",3333,3456,6443,{"$f":"SUM(C6:E6)","v":13232}]
[null,"Oregon",2356,7665,9999,{"$f":"SUM(C7:E7)","v":20020}]
[null,"Colorado",4000,4444,5555,{"$f":"SUM(C8:E8)","v":13999}]

{"sheet":"2ND QTR","index":12,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Second Quarter Sales"]
[null,null,"April","May","June","Total Sales"]
[null,"Arizona",2690,4690,9134,{"$f":"SUM(C5:E5)","v":16514}]
[null,"Texas",5774,16912,12886,{"$f":"SUM(C6:E6)","v":35572}]
[null,"Oregon",4712,5330,19998,{"$f":"SUM(C7:E7)","v":30040}]
[null,"Colorado",3421,5402,6324,{"$f":"SUM(C8:E8)","v":15147}]

{"sheet":"3RD QTR","index":13,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Third Quarter Sales"]
[null,null,"July","August","September","Total Sales"]
[null,"Arizona",6347,542,6733,{"$f":"SUM(C5:E5)","v":13622}]
[null,"Texas",2736,8763,5741,{"$f":"SUM(C6:E6)","v":17240}]
[null,"Oregon",453,6426,67353,{"$f":"SUM(C7:E7)","v":74232}]
[null,"Colorado",5321,6742,8964,{"$f":"SUM(C8:E8)","v":21027}]

{"sheet":"4th QTR","index":14,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Fourth Quarter Sales"]
[null,null,"October","November","December","Total Sales"]
[null,"Arizona",546,7642,32256,{"$f":"SUM(C5:E5)","v":40444}]
[null,"Texas",7542,653,8624,{"$f":"SUM(C6:E6)","v":16819}]
[null,"Oregon",2356,6422,9635,{"$f":"SUM(C7:E7)","v":18413}]
[null,"Colorado",12345,5732,8532,{"$f":"SUM(C8:E8)","v":26609}]

{"sheet":"ANNUAL SUMMARY (16)","index":15,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,1,2,7]]}
[]
[]
[null,"Year End Summary"]
[null,null,"1st QTR","2nd QTR","3rd QTR","4th QTR","Total","Total Check"]
[null,"Arizona"]
[null,"Texas"]
[null,"Oregon"]
[null,"Colorado"]

{"sheet":"FUNCTIONS (15)","index":16,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3]]}
["Company","FName","LName","Title","QTR 1","QTR 2","QTR 3","QTR 4","Yearly\n Total"]
["JJ Pharma","Jaime","Swindell","Engineer",3200,4391,4549,4707,{"$f":"SUM(E2:H2)","v":16847}]
["HI Labs","Mani","Brannon","Manager",3452,5674,7698,9722,26546]
["Jet Propulsion","Vicki","Foust","VP Sales",5467,3245,4532,5819,19063]
["Sesame Athletic","Ontario","Palisi","Exec. Director",4568,3444,2198,2756,12966]
["Kellogstar","Manitoba","Poe","Sales Rep",9830,4829,3202,2003,19864]
["Tables Inc.","Alberta","Russo","HR Director",1256,2356,4555,5603,13770]
["WallyWorld","British Columbia","Thomas","Buyer",2343,6432,2523,3059,14357]
["Fabric USA","Scott","Schnelker","Designer",7897,3245,5093,1469,{"$f":"SUM(E9:H9)","v":17704}]
[]
[null,null,"Total Revenue:"]
[null,null,"Average Revenue:"]
[null,null,"Largest Amount:"]
[null,null,"Smallest Amount:"]

{"sheet":"IF FUNCTION (16)","index":17,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,1,2,6]]}
[]
[]
[null,"First Quarter Sales"]
[null,null,"January","February","March","Total Sales","Bonus"]
[null,"Oregon",4523,6789,8567,{"$f":"SUM(C5:E5)","v":19879}]
[null,"Texas",3333,3456,6443,{"$f":"SUM(C6:E6)","v":13232}]
[null,"New Mexico",2356,3452,9999,{"$f":"SUM(C7:E7)","v":15807}]
[null,"Colorado",4000,4444,5555,{"$f":"SUM(C8:E8)","v":13999}]

{"sheet":"ORIENTATION (18)","index":18,"n_rows":3,"n_cols":6,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[null,"January","February","March","April","May"]
[null,1,2,1,4,5]

{"sheet":"CONDITIONAL FORMATTING (6)","index":19,"n_rows":296,"n_cols":10,"rows_kept":296,"cut":false,"hidden":false,"merged":[]}
["Passenger Name","Type","Vendor","Depart","Return","Daily Rate","Total Fare","Itinerary","Invoice #","rand"]
["Adams/Donna","Dom. Air","Delta Air Lines","2000-05-15","2000-05-20",113.87,600,"ATLPHXATL","110125S",{"$f":"RAND()","v":0.84173805399480883}]
["Adams/Donna","TRANS FEE","ARC","2000-05-15",null,10,670,"ARC","110125S",0.712765066348089]
["Adams/Jim","Dom. Air","Delta Air Lines","2000-05-15","2000-05-20",113.87,10,"ATLPHXATL","110124S",0.18675510507624227]
["Adams/Jim","TRANS FEE","ARC","2000-01-27",null,10,10,"ARC","109555S",0.27284933632785169]
["Adams/Jim","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110124S",3.2968384418375907E-2]
["Atkins/Ron","Dom. Air","Northwest Airlines","2000-02-23","2000-02-24",522,400,"OKCMEMTPAMEMOKC","110175S",0.68838567712037912]
["Atkins/Ron","Car","Hertz","2000-02-23","2000-02-24",82,82,"TPA","110175S",6.6111984577393978E-2]
["Atkins/Ron","TRANS FEE","ARC","2000-02-23",null,10,10,"ARC","110175S",0.12299819824291003]
["Carrey/Barry","Dom. Air","Delta Air Lines","2000-05-12","2000-05-19",78.849999999999994,552,"MGMATLDAYATLPHXATLMGM","110802S",5.3822759655087205E-2]
["Carrey/Barry","TRANS FEE","ARC","2000-05-12",null,10,10,"ARC","110802S",8.3100563457946808E-2]
["Carrey/Pam","Dom. Air","Delta Air Lines","2000-05-12","2000-05-19",78.849999999999994,552,"MGMATLDAYATLPHXATLMGM","110803S",0.11058783493066371]
["Carrey/Pam","TRANS FEE","ARC","2000-05-12",null,10,10,"ARC","110803S",0.2719161142452049]
["Chile/Juan","Dom. Air","America West Airlines","2000-05-11","2000-05-18",53.21,372.5,"FLLLASPHXFLL","110583S",0.21233769399028646]
["Chile/Juan","TRANS FEE","ARC","2000-05-11",null,10,10,"ARC","110583S",4.7736675282159746E-2]
["Conelly/Doug","Hotel","Raintree Plaza Hotel","2000-04-17","2000-04-20",152,456,"DEN","111088S",0.15797196161994531]
["Conelly/Doug","Dom. Air","Delta Air Lines","2000-03-06","2000-03-06",253,253,"TPAATLPHL","110447S",0.41710814720681855]
["Conelly/Doug","Dom. Air","Continental Airlines","2000-03-08","2000-03-08",166.5,166.5,"MDTCLETPA","110449S",0.93973076001108291]
["Conelly/Doug","Dom. Air","USAir","2000-03-07","2000-03-07",148.5,148.5,"PHLMDT","110448S",0.27339083127981534]
["Conelly/Doug","Car","Alamo","2000-04-17","2000-04-20",48.39,145.16999999999999,"DEN","111088S",0.93966253996123383]
["Conelly/Doug","Car","Alamo","2000-03-07","2000-03-08",88,88,"MDT","110448S",0.94088062523202087]
["Conelly/Doug","Hotel","RADISSON","2000-03-07","2000-03-08",79,79,"MDT","110448S",2.7283328929729178E-2]
["Conelly/Doug","Hotel","COURTYARD BY MARRIOTT","2000-03-06","2000-03-07",75,75,"PHL","110447S",0.70440932376847298]
["Conelly/Doug","Car","Alamo","2000-03-06","2000-03-07",51,51,"PHL","110447S",0.8795990800478799]
["Conelly/Doug","TRANS FEE","ARC","2000-04-17",null,10,10,"ARC","111088S",0.1252340885235661]
["Conelly/Doug","TRANS FEE","ARC","2000-03-06",null,10,10,"ARC","110447S",0.25182309505779554]
["Couto/Terry","Hotel","Holiday Inn Express","2000-01-31","2000-02-14",109,1526,"CLW","109640S",0.49363843719069445]
["Couto/Terry","Dom. Air","Delta Air Lines","2000-04-30","2000-05-02",282,564,"TPAATLORDATLTPA","111269S",0.25551579061528362]
["Couto/Terry","Dom. Air","Southwest Airlines","2000-03-23",null,194,194,"TPAMSYTPA","110766S",0.24573144466423191]
["Couto/Terry","Car","Hertz","2000-02-04","2000-02-07",38.39,115.17,"EWR","109756S",2.4016447994309464E-3]
["Couto/Terry","TRANS FEE","ARC","2000-04-30",null,10,10,"ARC","111269S",0.34458131548264714]
["Couto/Terry","TRANS FEE","ARC","2000-03-23",null,10,10,"ARC","110766S",7.603974390010404E-2]
["Cox/Becky","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",105.92,423.68,"MGMATLPHXATLTPA","110349S",0.37336634589002049]
["Cox/Becky","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110349S",0.71745361197392676]
["Cox/Becky","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",0,0,"MGMATLPHXATLMGM","110794S",0.30143415984773869]
["Cox/William G","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",105.92,423.68,"MGMATLPHXATLTPA","110348S",0.86867161822375216]
["Cox/William G","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110348S",9.4472061191293366E-2]
["Cox/William G","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",0,0,"MGMATLPHXATLMGM","110793S",0.67347462103595257]
["Coyle/Marcus","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",142.34,569.36,"ATLPHXATL","110742S",0.38970784078640008]
["Coyle/Marcus","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110742S",0.53294314730736581]
["Coyle/Mary","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",142.34,569.36,"ATLPHXATL","110743S",0.92217502363939452]
["Coyle/Mary","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110743S",0.15330161431316003]
["Dain/Phyllis","Dom. Air","United Airlines","2000-04-10","2000-04-14",119.75,479,"ARCATWORDTPAORDATW","110939S",0.70541913756317665]
["Dain/Phyllis","TRANS FEE","ARC","2000-04-10",null,10,10,"ARC","110939S",0.3014608185906178]
["Deitz/Michele","Dom. Air","Delta Air Lines","2000-02-15","2000-02-16",300,300,"STLATLTPAATLSTL","109811S",0.6638466496594625]
["Deitz/Michele","TRANS FEE","ARC","2000-02-15",null,10,10,"ARC","109811S",0.39337504508595378]
["Douglas/Jay","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",142.34,569.36,"ATLPHXATL","110372S",0.31489315563367326]
["Douglas/Jay","Dom. Air","Delta Air Lines","2000-01-27","2000-01-28",175.5,175.5,"ATLDTWATL","109285S",0.16256808753566454]
["Douglas/Jay","TRANS FEE","ARC","2000-01-27",null,10,10,"ARC","109285S",0.24060916877709748]
["Douglas/Jay","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110372S",0.93989038482968079]
["Douglas/Steve","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",142.34,569.36,"ATLPHXATL","110373S",0.70963115698566726]
["Douglas/Steve","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110373S",0.70238939546611279]
["Drake/Deborah","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",50.5,202,"TPADFWPHXATLTPA","109890S",0.70918263898816147]
["Drake/Deborah","Dom. Air","ARC","2000-05-15","2000-05-19",2.5,10,"TPADFWPHXATLTPA","109890S",0.75242694111390496]
["Dulla/Katie","Dom. Air","America West Airlines","2000-05-16","2000-05-19",123.06,369.19,"ORDPHXORD","110957S",0.80002071888937742]
["Dulla/Katie","TRANS FEE","ARC","2000-05-16",null,10,10,"ARC","110957S",0.2610941747428307]
["Dulla/Michael","Dom. Air","America West Airlines","2000-05-16","2000-05-19",123.06,369.19,"ORDPHXORD","110956S",8.9792105737350858E-2]
["Dulla/Michael","TRANS FEE","ARC","2000-05-16",null,10,10,"ARC","110956S",0.59673758581016012]
["Dunaway/Mary","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",145.09,580.36,"PNSATLPHXATLPNS","110229S",0.70204865050968013]
["Dunaway/Mary","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110229S",0.5789733230560743]
["Dunaway/Roger","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",145.09,580.36,"PNSATLPHXATLPNS","110228S",0.61364375527547199]
["Dunaway/Roger","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110228S",0.36965857806321101]
["Glass/Helen","Dom. Air","United Airlines","2000-02-15","2000-02-16",377,377,"IADTPAIAD","109817S",0.49750908845551201]
["Glass/Helen","TRANS FEE","ARC","2000-02-15",null,10,10,"ARC","109817S",0.2563827595701077]
["Griffin/Linda","Dom. Air","America West Airlines","2000-05-11","2000-05-18",53.21,372.5,"FLLLASPHXFLL","110584S",1.7412723414346187E-3]
["Griffin/Linda","TRANS FEE","ARC","2000-05-11",null,10,10,"ARC","110584S",{"$f":"RAND()","v":0.78038965711729835}]
["Hargett/Judy","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",142.34,569.36,"ATLPHXATL","110374S",0.51671025006777616]
["Hargett/Judy","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110374S",0.63781731850122558]
["Hawks/Tammy","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",142.34,569.36,"ATLPHXATL","110375S",0.71828213869813751]
["Hawks/Tammy","Dom. Air","Delta Air Lines","2000-01-27","2000-01-28",175.5,175.5,"ATLDTWATL","109286S",0.29497385463364423]
["Hawks/Tammy","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110375S",0.1513177631903313]
["Hawks/Tammy","TRANS FEE","ARC","2000-01-27",null,10,10,"ARC","109286S",0.80152296394108535]
["Hill/Joseph","Dom. Air","Delta Air Lines","2000-03-15","2000-03-20",85,425,"TPADFWRNODFWTPA","110435S",0.50536254910482914]
["Hill/Joseph","TRANS FEE","ARC","2000-03-15",null,10,10,"ARC","110435S",0.53865286776713894]
["Hill/Vicki","Dom. Air","Continental Airlines","2000-02-13","2000-02-18",129.5,647.5,"TPAIAHDFWIAHTPA","109835S",0.25953278074705999]
["Hill/Vicki","Dom. Air","Trans World Airlines","2000-03-27","2000-03-31",101,404,"TPASTLMCISTLTPA","110782S",0.36949733781578875]
["Hill/Vicki","Dom. Air","Delta Air Lines","2000-03-15","2000-03-23",40,320,"TPADFWRNODFWTPA","110434S",0.18427932211748954]
["Hill/Vicki","Car","Hertz","2000-02-27","2000-03-03",53,265,"DFW","110019S",0.15454751628433683]
["Hill/Vicki","Car","Hertz","2000-02-27","2000-03-03",53,265,"DFW","110018S",0.70236958624216528]
["Hill/Vicki","Car","Hertz","2000-02-13","2000-02-18",53,265,"DFW","109835S",0.7565278977436678]
["Hill/Vicki","Car","Alamo","2000-03-27","2000-03-31",42.23,168.92,"MCI","110782S",0.13405751925158582]
["Hill/Vicki","Dom. Air","Continental Airlines","2000-02-27","2000-03-03",15,75,"TPAIAHDFWIAHTPA","110019S",0.10629411449466908]
["Hill/Vicki","Hotel","FAIRFIELD INN","2000-03-30","2000-03-31",64,64,"MCI","110782S",0.10864097383858684]
["Hill/Vicki","TRANS FEE","ARC","2000-02-27",null,10,10,"ARC","110018S",0.15512836812934605]
["Hill/Vicki","TRANS FEE","ARC","2000-02-13",null,10,10,"ARC","109835S",4.028781579028029E-2]
["Hill/Vicki","TRANS FEE","ARC","2000-03-15",null,10,10,"ARC","110434S",0.10212680071116054]
["Hill/Vicki","TRANS FEE","ARC","2000-03-27",null,10,10,"ARC","110782S",0.97605426800216144]
["Hill/Vickki","Dom. Air","Continental Airlines","2000-02-27","2000-03-03",0,0,"DFW","110019S",2.1030474492222617E-2]
["Hopson/Marie","Dom. Air","Delta Air Lines","2000-02-15","2000-02-16",749,749,"DENATLTPAATLDEN","109814S",6.4739848324592009E-3]
["Hopson/Marie","TRANS FEE","ARC","2000-02-15",null,10,10,"ARC","109814S",0.71174420020861884]
["Hosek/Sybil","Dom. Air","America West Airlines","2000-05-15","2000-05-21",50.69,304.18,"ORDPHXORD","110188S",0.49370446615560382]
["Hosek/Sybil","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110188S",0.1558830677662032]
["Jernigan/Debbie","TRANS FEE","ARC","2000-01-27",null,10,10,"ARC","109556S",0.80699814400262659]
["Jernigan/Deborah","Dom. Air","Delta Air Lines","2000-05-15","2000-05-20",113.87,569.36,"ATLPHXATL","110134S",0.27107649734419148]
["Jernigan/Deborah","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110134S"]
["Jernigan/Tyrus","Dom. Air","Delta Air Lines","2000-05-15","2000-05-20",113.87,569.36,"ATLPHXATL","110135S"]
["Jernigan/Tyrus","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110135S"]
["Jiles.randall","Dom. Air","Southwest Airlines","2000-03-02",null,388,388,null,"110559S"]
["Jiles/Frances","Dom. Air","USAir","2000-04-14","2000-04-16",158.5,317,"PVDPHLJAXPHLPVD","110581S"]
["Jiles/Frances","Dom. Air","Southwest Airlines","2000-02-11",null,238.5,238.5,"PVDTPAPVD","109723S"]
["Jiles/Frances","TRANS FEE","ARC","2000-02-11",null,10,10,"ARC","109723S"]
["Jiles/Frances","TRANS FEE","ARC","2000-03-08",null,10,10,"ARC","110214S"]
["Jiles/Frances","TRANS FEE","ARC","2000-04-14",null,10,10,"ARC","110581S"]
["Jiles/Helvey","Dom. Air","Southwest Airlines","2000-03-03",null,393,393,"TPASTLTPA","110491S"]
["Jiles/Helvey","Car","Hertz","2000-03-03","2000-03-12",34.119999999999997,307.13,"STL","110491S"]
["Jiles/Helvey","TRANS FEE","ARC","2000-03-03",null,10,10,"ARC","110491S"]
["Jiles/Paul","Dom. Air","Delta Air Lines","2000-03-17","2000-03-19",195.25,390.5,"MSYATLCHSATLMSY","110393S"]
["Jiles/Paul","TRANS FEE","ARC","2000-03-17",null,10,10,"ARC","110393S"]
["Jiles/Randall","Hotel","Marriott Lincolnshire","2000-04-06","2000-04-09",218,654,"MSY","110185S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-05-15","2000-05-18",183.01,549.04,"PVDATLPHXCVGPVD","110478S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-01-26","2000-01-28",236,472,"TPACVGDTWATLTPA","109246S"]
["Jiles/Randall","Dom. Air","United Airlines","2000-04-30","2000-05-09",52.22,470,"PVDORDTPAIADPVD","111140S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-02-24","2000-02-27",126.33,379,"TPAATLDCAPVDATLTPA","110179S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-03-31","2000-04-02",181.5,363,"TPAATLPVDATLTPA","110165S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-03-10","2000-03-12",180,360,"TPAPVDATLTPA","110168S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-03-17","2000-03-19",180,360,"TPAPVDATLTPA","110167S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-03-24","2000-03-26",180,360,"TPAPVDATLTPA","110166S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-05-12","2000-05-22",36,360,"TPAPVDATLTPA","110470S"]
["Jiles/Randall","Dom. Air","Northwest Airlines","2000-01-28","2000-02-02",66.2,331,"DTWTPADTW","109678S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-03-02","2000-03-07",56.8,284,"TPACVGPVDDCAATLTPA","110176S"]
["Jiles/Randall","Dom. Air","USAir","2000-03-06","2000-03-06",272.5,272.5,"PVDDCA","110178S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-03-03","2000-03-05",130.5,261,"TPAPVDATLTPA","109090S"]
["Jiles/Randall","Dom. Air","Southwest Airlines","2000-04-06",null,194,194,"TPAMSYTPA","110185S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-01-29","2000-01-31",96,192,"TPAATLTPA","109245S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-04-21","2000-04-23",88,176,"TPAPVDATLTPA","110192S"]
["Jiles/Randall","Dom. Air","United Airlines","2000-06-28","2000-06-30",86.5,173,"TPAIADTPA","111093S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-05-05","2000-05-07",59,118,"TPAPVDATLTPA","111102S"]
["Jiles/Randall","Car","Hertz","2000-04-06","2000-04-09",35.090000000000003,105.27,"MSY","110185S"]
["Jiles/Randall","Dom. Air","USAir","2000-02-25","2000-02-25",104.5,104.5,"BWIPVD","110177S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-04-28","2000-04-30",43,86,"TPAATLPVDATLTPA","110196S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-01-27","2000-01-28",75,75,"TPAATLDTWATLTPA","109606S"]
["Jiles/Randall","Car","Hertz","2000-01-27","2000-01-28",63,63,"DTW","109606S"]
["Jiles/Randall","TRANS FEE","ARC","2000-01-26",null,10,10,"ARC","109246S"]
["Jiles/Randall","TRANS FEE","ARC","2000-01-27",null,10,10,"ARC","109619S"]
["Jiles/Randall","TRANS FEE","ARC","2000-01-28",null,10,10,"ARC","109678S"]
["Jiles/Randall","TRANS FEE","ARC","2000-01-29",null,10,10,"ARC","109245S"]
["Jiles/Randall","TRANS FEE","ARC","2000-02-24",null,10,10,"ARC","110179S"]
["Jiles/Randall","TRANS FEE","ARC","2000-03-02",null,10,10,"ARC","110176S"]
["Jiles/Randall","TRANS FEE","ARC","2000-03-02",null,10,10,"ARC","110559S"]
["Jiles/Randall","TRANS FEE","ARC","2000-03-03",null,10,10,"ARC","109090S"]
["Jiles/Randall","TRANS FEE","ARC","2000-03-10",null,10,10,"ARC","110168S"]
["Jiles/Randall","TRANS FEE","ARC","2000-03-17",null,10,10,"ARC","110167S"]
["Jiles/Randall","TRANS FEE","ARC","2000-03-24",null,10,10,"ARC","110166S"]
["Jiles/Randall","TRANS FEE","ARC","2000-03-31",null,10,10,"ARC","110165S"]
["Jiles/Randall","TRANS FEE","ARC","2000-04-06",null,10,10,"ARC","110185S"]
["Jiles/RANDALL","Dom. Air","ARC","2000-04-21","2000-04-23",5,10,"TPAPVDATLTPA","110192S"]
["Jiles/Randall","TRANS FEE","ARC","2000-04-28",null,10,10,"ARC","110187S"]
["Jiles/Randall","TRANS FEE","ARC","2000-04-30",null,10,10,"ARC","111140S"]
["Jiles/Randall","TRANS FEE","ARC","2000-05-05",null,10,10,"ARC","111100S"]
["Jiles/Randall","TRANS FEE","ARC","2000-05-12",null,10,10,"ARC","110470S"]
["Jiles/Randall","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110478S"]
["Jiles/Randall","TRANS FEE","ARC","2000-06-28",null,10,10,"ARC","111093S"]
["Jiles/Randall","Car","Hertz","2000-01-27","2000-01-28",0,0,"DTW","109619S"]
["Jiles/Randall","Dom. Air","USAir","2000-03-06","2000-03-06",-272.5,-272.5,"PVDDCA","110178R"]
["Jiles/Tyler","Dom. Air","Delta Air Lines","2000-02-18","2000-02-22",171.75,687,"PVDCVGTPAMCOPVD","110006S"]
["Jiles/Tyler","Dom. Air","USAir","2000-04-14","2000-04-16",158.5,317,"PVDPHLJAXPHLPVD","110582S"]
["Jiles/Tyler","TRANS FEE","ARC","2000-02-11",null,10,10,"ARC","109723S"]
["Jiles/Tyler","TRANS FEE","ARC","2000-02-18",null,10,10,"ARC","110006S"]
["Jiles/Tyler","TRANS FEE","ARC","2000-03-08",null,10,10,"ARC","110215S"]
["Jiles/Tyler","TRANS FEE","ARC","2000-04-14",null,10,10,"ARC","110582S"]
["JilesTyler","Dom. Air","Southwest Airlines","2000-02-11",null,238.5,238.5,"PVDTPAPVD","109723S"]
["Kaufman/Jeff","Dom. Air","America West Airlines","2000-05-13","2000-05-19",56.33,338,"FLLLASPHXFLL","110597S"]
["Kaufman/Jeff","TRANS FEE","ARC","2000-05-13",null,10,10,"ARC","110597S"]
["Kaufman/Tracy","Dom. Air","America West Airlines","2000-05-13","2000-05-19",56.33,338,"FLLLASPHXFLL","110598S"]
["Kaufman/Tracy","TRANS FEE","ARC","2000-05-13",null,10,10,"ARC","110598S"]
["Komar/Gary","Dom. Air","America West Airlines","2000-05-15","2000-05-21",50.69,304.18,"ORDPHXORD","110189S"]
["Komar/Gary","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110189S"]
["Lawson/Robert","Dom. Air","Delta Air Lines","2000-02-25","2000-02-28",360.66,1082,"DAYCVGTPACVGDAY","110324S"]
["Lawson/Robert","TRANS FEE","ARC","2000-02-25",null,10,10,"ARC","110324S"]
["Lipman/Rick","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",242.97,971.88,"RSWATLPHXATLRSW","110519S"]
["Lipman/Rick","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110519S"]
["Lostroh/Barry","Dom. Air","America West Airlines","2000-05-15","2000-05-19",79.430000000000007,317.72000000000003,"DENPHXDEN","110088S"]
["Lostroh/Barry","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110088S"]
["Lostroh/Joshua","Dom. Air","America West Airlines","2000-05-15","2000-05-19",79.430000000000007,317.72000000000003,"DENPHXDEN","110089S"]
["Lostroh/Joshua","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110089S"]
["Manning/Connie","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",109.5,438,"TPAATLPHXATLTPA","110152S"]
["Manning/Connie","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110152S"]
["Maxwell/Lauren","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",242.97,971.88,"RSWATLPHXATLRSW","110520S"]
["Maxwell/Lauren","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110520S"]
["Mcnulty/Margaret","Dom. Air","American Airlines","2000-05-10","2000-05-19",34.880000000000003,314,"ORDPHXORD","110121S"]
["Mcnulty/Margaret","TRANS FEE","ARC","2000-05-10",null,10,10,"ARC","110121S"]
["Mcnulty/Tom","Dom. Air","American Airlines","2000-05-10","2000-05-19",34.880000000000003,314,"ORDPHXORD","110120S"]
["Mcnulty/Tom","TRANS FEE","ARC","2000-05-10",null,10,10,"ARC","110120S"]
["Munch/Rick","Dom. Air","Delta Air Lines","2000-05-16","2000-05-19",182.01,546.04,"IADPHXATLIAD","110775S"]
["Munch/Rick","TRANS FEE","ARC","2000-05-16",null,10,10,"ARC","110775S"]
["Munch/William","Dom. Air","Delta Air Lines","2000-05-16","2000-05-19",182.01,546.04,"IADPHXATLIAD","110776S"]
["Munch/William","TRANS FEE","ARC","2000-05-16",null,10,10,"ARC","110776S"]
["Murphy/Niki","Dom. Air","Delta Air Lines","2000-02-03","2000-02-06",81.66,245,"TPAATLTPA","109637S"]
["Murphy/Niki","Car","Hertz","2000-02-03","2000-02-06",38.94,116.82,"ATL","109637S"]
["Murphy/Niki","TRANS FEE","ARC","2000-02-03",null,10,10,"ARC","109637S"]
["Newberry/Dayla","Dom. Air","America West Airlines","2000-05-15","2000-05-19",79.430000000000007,317.72000000000003,"DENPHXDEN","110221S"]
["Newberry/Dayla","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110221S"]
["Newberry/Tye","Dom. Air","America West Airlines","2000-05-15","2000-05-19",79.430000000000007,317.72000000000003,"DENPHXDEN","110220S"]
["Newberry/Tye","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110220S"]
["Newell/Patricia","Dom. Air","America West Airlines","2000-05-14","2000-05-20",52.95,317.72000000000003,"DENPHXDEN","110190S"]
["Newell/Patricia","Dom. Air","United Airlines","2000-01-27","2000-01-30",99.66,299,"DENDTWDEN","109343S"]
["Newell/Patricia","Car","Budget","2000-01-27","2000-01-30",24.99,74.97,"DTW","109483S"]
["Newell/Patricia","TRANS FEE","ARC","2000-01-27",null,10,10,"ARC","109343S"]
["Newell/Patricia","TRANS FEE","ARC","2000-05-14",null,10,10,"ARC","110190S"]
["Newell/Steve","Dom. Air","America West Airlines","2000-05-14","2000-05-20",52.95,317.72000000000003,"DENPHXDEN","110191S"]
["Newell/Steve","TRANS FEE","ARC","2000-05-14",null,10,10,"ARC","110191S"]
["Newell/Steven","Dom. Air","United Airlines","2000-01-27","2000-01-30",99.66,299,"DENDTWDEN","109342S"]
["Newell/Steven","TRANS FEE","ARC","2000-01-27",null,10,10,"ARC","109342S"]
["Pettinger/Sandra","Dom. Air","America West Airlines","2000-05-15","2000-05-19",79.430000000000007,317.72000000000003,"DENPHXDEN","110087S"]
["Pettinger/Sandra","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110087S"]
["Richardson/Charles","Dom. Air","America West Airlines","2000-05-16","2000-05-21",55.83,279.19,"TPAPHXTPA","110263S"]
["Richardson/Charles","TRANS FEE","ARC","2000-05-16",null,10,10,"ARC","110263S"]
["Richardson/Margretta","Dom. Air","America West Airlines","2000-05-16","2000-05-21",55.83,279.19,"TPAPHXTPA","110262S"]
["Richardson/Margretta","TRANS FEE","ARC","2000-05-16",null,10,10,"ARC","110262S"]
["Roberts/Desmond","Hotel","XX","2000-02-25","2000-02-28",94,282,"MIA","110193S"]
["Roberts/Desmond","Car","Alamo","2000-02-23","2000-03-01",26.74,187.19,"PIE","110193S"]
["Roberts/Desmond","Hotel","Howard Johnson","2000-02-28","2000-02-29",62.9,62.9,"DAB","110193S"]
["Ruttenburg/Margaret","Dom. Air","Delta Air Lines","2000-02-15","2000-02-16",417,417,"ORDATLTPAATLORD","109816S"]
["Ruttenburg/Margaret","TRANS FEE","ARC","2000-02-15",null,10,10,"ARC","109816S"]
["Sanders/Gene","Dom. Air","America West Airlines","2000-05-15","2000-05-19",119.66,478.64,"MIAPHXMIA","109994S"]
["Sanders/Gene","Dom. Air","American Airlines","2000-01-20","2000-01-20",135.5,135.5,"TPAMIA","109074S"]
["Sanders/Gene","Car","Hertz","2000-01-17","2000-01-20",45,135,"TPA","109073S"]
["Sanders/Gene","Dom. Air","USAir","2000-01-17","2000-01-17",109.5,109.5,"MIATPA","109073S"]
["Sanders/Gene","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","109994S"]
["Sanders/Genevieve","Dom. Air","America West Airlines","2000-05-15","2000-05-19",119.66,478.64,"MIAPHXMIA","109995S"]
["Sanders/Genevieve","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","109995S"]
["Slone/Laurie","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",100.75,403,"TPADFWPHXATLTPA","110934S"]
["Slone/Laurie","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110934S"]
["Slone/Tim","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",100.75,403,"TPADFWPHXATLTPA","110933S"]
["Slone/Tim","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110933S"]
["Smith/T Donald","Dom. Air","ARC","2000-01-27","2000-01-31",2.5,10,"TPAATLDTWATLTPA","109611S"]
["Smith/T Sam","Hotel","Marriott Lincolnshire","2000-02-28","2000-03-29",179,5370,"SNA","110461S"]
["Smith/T Sam","Dom. Air","Delta Air Lines","2000-02-28","2000-03-02",530,1590,"TPADFWSNADENATLTPA","110388S"]
["Smith/T Sam","Dom. Air","Delta Air Lines","2000-01-12","2000-01-13",1405,1405,"TPAATLSNADFWTPA","109173S"]
["Smith/T Sam","Dom. Air","United Airlines","2000-02-29","2000-02-29",754.5,754.5,"SNADEN","110461S"]
["Smith/T Sam","Dom. Air","Delta Air Lines","2000-01-27","2000-01-31",127.25,509,"TPAATLDTWATLTPA","109611S"]
["Smith/T Sam","Dom. Air","Delta Air Lines","2000-01-26","2000-01-31",90,450,"TPACVGDTWATLTPA","109247S"]
["Smith/T Sam","Dom. Air","United Airlines","2000-07-09","2000-07-11",209.25,418.5,"TPAORDTPA","111059S"]
["Smith/T Sam","Hotel","Marriott Lincolnshire","2000-02-28","2000-03-01",159,318,"SNA","110388S"]
["Smith/T Sam","Dom. Air","Delta Air Lines","2000-04-06","2000-04-09",104,312,"TPAATLTPA","111081S"]
["Smith/T Sam","Dom. Air","Delta Air Lines","2000-01-29","2000-01-29",294,294,"TPAATL","109718S"]
["Smith/T Sam","Hotel","Ritz Carlton","2000-04-06","2000-04-07",220,220,"ATL","111081S"]
["Smith/T Sam","Dom. Air","Delta Air Lines","2000-05-21","2000-05-23",94.5,189,"TPAATLTPA","110445S"]
["Smith/T Sam","Dom. Air","United Airlines","2000-06-28","2000-06-30",83.5,167,"TPAIADTPA","110692S"]
["Smith/T Sam","Car","Hertz","2000-07-09","2000-07-11",63,126,"ORD","111058S"]
["Smith/T Sam","Car","Hertz","2000-04-06","2000-04-09",41.39,124.17,"ATL","111081S"]
["Smith/T Sam","Car","Hertz","2000-01-28","2000-01-31",38.99,116.98,"ATL","109609S"]
["Smith/T Sam","Hotel","HILTON HOTELS","2000-02-29","2000-03-01",109,109,"DEN","110461S"]
["Smith/T Sam","Car","Hertz","2000-02-29","2000-03-01",64,64,"DEN","110461S"]
["Smith/T Sam","Car","Hertz","2000-03-01","2000-03-01",64,64,"DEN","110388S"]
["Smith/T Sam","Car","Hertz","2000-02-28","2000-03-01",26.54,53.09,"SNA","110388S"]
["Smith/T Sam","Car","Hertz","2000-02-28","2000-02-29",53.09,53.09,"SNA","110461S"]
["Smith/T Sam","TRANS FEE","ARC","2000-01-12",null,10,10,"ARC","109173S"]
["Smith/T Sam","TRANS FEE","ARC","2000-01-26",null,10,10,"ARC","109247S"]
["Smith/T Sam","TRANS FEE","ARC","2000-01-27",null,10,10,"ARC","109609S"]
["Smith/T Sam","TRANS FEE","ARC","2000-02-28",null,10,10,"ARC","110388S"]
["Smith/T Sam","TRANS FEE","ARC","2000-04-06",null,10,10,"ARC","111081S"]
["Smith/T Sam","TRANS FEE","ARC","2000-05-21",null,10,10,"ARC","110445S"]
["Smith/T Sam","TRANS FEE","ARC","2000-06-28",null,10,10,"ARC","110692S"]
["Smith/T Sam","TRANS FEE","ARC","2000-07-09",null,10,10,"ARC","111058S"]
["Smith/T Sam","Dom. Air","United Airlines",null,null,0,0,null,"110461A"]
["Smith/T Sam","Dom. Air","Delta Air Lines","2000-01-27","2000-01-31",-117.5,-470,"TPAATLDTWATLTPA","109292R"]
["Smith/T Sam","Dom. Air","Delta Air Lines","2000-01-12","2000-01-13",-1405,-1405,"TPAATLSNADFWTPA","109173R"]
["Smith/Timothy D","Dom. Air","Continental Airlines","2000-02-10","2000-02-10",97.5,97.5,"TLHTPA","109644S"]
["Smith/Timothy D","TRANS FEE","ARC","2000-02-10",null,10,10,"ARC","109644S"]
["SPEER/STEPHEN","Dom. Air","AirTran Airways, Inc.","2000-02-24",null,403,403,"ATLTPAATL","110184S"]
["Speer/Stephen","Car","Hertz","2000-02-24","2000-02-24",41,41,"TPA","110184S"]
["Speer/Stephen","TRANS FEE","ARC","2000-02-24",null,10,10,"ARC","110184S"]
["Stubbs/Sally","Dom. Air","USAir","2000-02-16","2000-02-16",417.5,417.5,"TPADCA","109986S"]
["Stubbs/Sally","Dom. Air","Continental Airlines","2000-02-17","2000-02-17",415.5,415.5,"DCACLETPA","109987S"]
["Stubbs/Sally","Hotel","XX","2000-02-16","2000-02-17",129,129,"WAS","109986S"]
["Stubbs/Sally","TRANS FEE","ARC","2000-02-16",null,10,10,"ARC","109986S"]
["Towner/Tonya","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",109.5,438,"TPAATLPHXATLTPA","110153S"]
["Towner/Tonya","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110153S"]
["Van Essen/Delwyn","Dom. Air","United Airlines","2000-01-27","2000-01-30",99.66,299,"DENDTWDEN","109340S"]
["Van Essen/Delwyn","Car","Dollar","2000-01-27","2000-01-30",19.989999999999998,59.97,"DTW","109340S"]
["Van Essen/Delwyn","TRANS FEE","ARC","2000-01-27",null,10,10,"ARC","109340S"]
["Van Essen/Dianne","Dom. Air","United Airlines","2000-01-27","2000-01-30",99.66,299,"DENDTWDEN","109341S"]
["Van Essen/Dianne","TRANS FEE","ARC","2000-01-27",null,10,10,"ARC","109341S"]
["Vanessen/Del","Dom. Air","America West Airlines","2000-05-15","2000-05-19",79.430000000000007,317.72000000000003,"DENPHXDEN","110169S"]
["Vanessen/Del","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110169S"]
["Vanessen/Diane","Dom. Air","America West Airlines","2000-05-15","2000-05-19",79.430000000000007,317.72000000000003,"DENPHXDEN","110170S"]
["Vanessen/Diane","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110170S"]
["Weatherby/Charles","Dom. Air","Delta Air Lines","2000-03-20","2000-03-22",391.85,783.7,"TPADFWSJDDFWTPA","110426S"]
["Weatherby/Charles","Dom. Air","Continental Airlines","2000-05-12","2000-05-14",138,276,"TPAIAHOMAIAHTPA","110141S"]
["Weatherby/Charles","TRANS FEE","ARC","2000-03-20",null,10,10,"ARC","110426S"]
["Weatherby/Charles","TRANS FEE","ARC","2000-05-12",null,10,10,"ARC","110141S"]
["Weatherby/Jamie","Dom. Air","America West Airlines","2000-05-14","2000-05-25",37.36,411,"OMAPHXTPA","110094S"]
["Weatherby/Jamie","TRANS FEE","ARC","2000-05-14",null,10,10,"ARC","110094S"]
["Weatherby/Nancy","Dom. Air","Delta Air Lines","2000-03-20","2000-03-22",391.85,783.7,"TPADFWSJDDFWTPA","110429S"]
["Weatherby/Nancy","Dom. Air","America West Airlines","2000-05-14","2000-05-25",37.36,411,"OMAPHXTPA","110151S"]
["Weatherby/Nancy","Dom. Air","Delta Air Lines","2000-01-26","2000-01-28",165.5,331,"TPACVGDTWATLTPA","109493S"]
["Weatherby/Nancy","Dom. Air","Northwest Airlines","2000-01-28","2000-02-02",66.2,331,"DTWTPADTW","109679S"]
["Weatherby/Nancy","Hotel","HYATT REGENCY","2000-03-23","2000-03-25",125,250,"MCO","110325S"]
["Weatherby/Nancy","Dom. Air","Continental Airlines","2000-05-12","2000-05-12",211.5,211.5,"TPAIAHOMA","110150S"]
["Weatherby/Nancy","TRANS FEE","ARC","2000-01-26",null,10,10,"ARC","109493S"]
["Weatherby/Nancy","TRANS FEE","ARC","2000-01-28",null,10,10,"ARC","109679S"]
["Weatherby/Nancy","TRANS FEE","ARC","2000-03-20",null,10,10,"ARC","110429S"]
["Weatherby/Nancy","TRANS FEE","ARC","2000-05-12",null,10,10,"ARC","110150S"]
["Williams/Samantha","Dom. Air","Delta Air Lines","2000-01-10","2000-01-11",280,280,"ATLTPAATL","109203S"]
["Williams/Samantha","TRANS FEE","ARC","2000-01-10",null,10,10,"ARC","109203S"]

{"sheet":"DATA BARS (6)","index":20,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"First Quarter Sales"]
[null,null,"January","February","March","Total Sales"]
[null,"New Mexico",1345,2345,4567,{"$f":"SUM(C5:E5)","v":8257}]
[null,"Washington",3333,3456,6443,{"$f":"SUM(C6:E6)","v":13232}]
[null,"Oregon",2356,7665,9999,{"$f":"SUM(C7:E7)","v":20020}]
[null,"Colorado",4000,4444,5555,{"$f":"SUM(C8:E8)","v":13999}]

{"sheet":"TABLE (8)","index":21,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["First Name","Last Name","Hire Date","SS #","Department","Position","Annual Salary","Perf Rating","Mgmt Level"]
["elizabeth","ridenhauer","1997-04-29",459306733,"Corporate Manager","Vice President",65000,5,1]
["elizabeth","ridenhauer","1997-04-29",459306733,"Corporate Manager","Vice President",65000,5,1]
["alice","wortman","1998-04-03",707942310,"Corporate Manager","Marketing Manager",85000,4,2]
["tyrone","anderson","1995-12-02",146902472,"Corporate Staff","Division Manager",42000,3,3]
["stuart","klein","1999-05-28",345005582,"Corporate Staff","Accounting Staff",55000,4,2]
["catherine","forest","2000-06-14",368370245,"Corporate Manager","Director of Advertising",46000,3,2]
["mechell","clese","1995-05-09",456080278,"Corporate Staff","Copy Writer",58000,3,4]
["kate","jones","2000-07-25",481349363,"Corporate Staff","Accounting Staff",45000,2,3]
["ellen","spinnaker","1993-04-07",570286844,"Corporate Staff","Circulation Manager",70000,4,3]
["will","mullen","1999-06-08",611048942,"Corporate Staff","Division Manager",53500,4,3]
["brad","turner","1997-09-17",345035237,"Management Staff","Accounting Staff",65000,3,3]
["mark","macdowell","2000-05-06",820015532,"Management Staff","Web Manager",55000,2,3]
["william","martin","1952-07-01",469440032,"Retail","Product Manager",55500,2,3]
["jim","kirney","1995-10-28",618035383,"Retail","Product Manager",47500,3,3]
["michelle","campbell","1998-05-05",681302482,"Management Staff","Accounting Staff",42000,3,2]
["ty ","simmons","1999-05-14",679694534,"Retail","Product Manager",57500,3,3]
["dennis","denton","1987-07-04",692241314,"Section Manager","Director of Training",45000,4,3]
["michael","gapner","1961-08-20",706670481,"Management Staff","Payroll Manager",48000,3,3]
["eileen","wilson","1995-07-29",682110774,"Retail","Product Manager",48000,4,3]
["george","fernandez","1997-03-30",781041004,"Corporate Manager","Office Manager",48000,5,2]
["james","bruce","2000-05-29",248944357,"Section Manager","Dir. Of Shipping",55000,1,3]
["marcia","smith","1995-01-14",931026545,"Corporate Manager","General Sales Manager",42000,2,2]

{"sheet":"LINK PP (33)","index":22,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"First Quarter Sales"]
[null,null,"January","February","March","Total Sales"]
[null,"New Mexico",1345,2345,4567,{"$f":"SUM(C5:E5)","v":8257}]
[null,"Oregon",3333,3456,6443,{"$f":"SUM(C6:E6)","v":13232}]
[null,"Washington",2356,7665,9999,{"$f":"SUM(C7:E7)","v":20020}]
[null,"Colorado",4000,4444,5555,{"$f":"SUM(C8:E8)","v":13999}]

{"sheet":"TEXT 2 COLUMNS WORDS","index":23,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["First Name","Last Name","Hire Date","SS #","Department","Position","Annual Salary","Perf Rating","Mgmt Level"]
["elizabeth,ridenhauer,35549,459306733,Corporate Manager,Vice President,65000,5,1"]
["alice,wortman,35888,707942310,Corporate Manager,Marketing Manager,85000,4,2"]
["tyrone,anderson,35035,146902472,Corporate Staff,Division Manager,42000,3,3"]
["stuart,klein,36308,345005582,Corporate Staff,Accounting Staff,55000,4,2"]
["catherine,forest,36691,368370245,Corporate Manager,Director of Advertising,46000,3,2"]
["mechell,clese,34828,456080278,Corporate Staff,Copy Writer,58000,3,4"]
["kate,jones,36732,481349363,Corporate Staff,Accounting Staff,45000,2,3"]
["ellen,spinnaker,34066,570286844,Corporate Staff,Circulation Manager,70000,4,3"]
["will,mullen,36319,611048942,Corporate Staff,Division Manager,53500,4,3"]
["brad,turner,35690,345035237,Management Staff,Accounting Staff,65000,3,3"]
["mark,macdowell,36652,820015532,Management Staff,Web Manager,55000,2,3"]
["william,martin,19176,469440032,Retail,Product Manager,55500,2,3"]
["jim,kirney,35000,618035383,Retail,Product Manager,47500,3,3"]
["michelle,campbell,35920,681302482,Management Staff,Accounting Staff,42000,3,2"]
["ty ,simmons,36294,679694534,Retail,Product Manager,57500,3,3"]
["dennis,denton,31962,692241314,Section Manager,Director of Training,45000,4,3"]
["michael,gapner,22513,706670481,Management Staff,Payroll Manager,48000,3,3"]
["eileen,wilson,34909,682110774,Retail,Product Manager,48000,4,3"]
["george,fernandez,35519,781041004,Corporate Manager,Office Manager,48000,5,2"]
["james,bruce,36675,248944357,Section Manager,Dir. Of Shipping,55000,1,3"]
["marcia,smith,34713,931026545,Corporate Manager,General Sales Manager,42000,2,2"]

{"sheet":"TEXT 2 COLUMNS (12)","index":24,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Employee"]
["anderson,tyrone",null,null,123456789]
["bruce,james",null,null,987654321]
["klein,stuart",null,null,654123789]
["turner,brad"]
["forest,catherine"]
["clese,mechell"]
["ridenhauer,elizabeth"]
["martin,william"]
["jones,kate"]
["spinnaker,ellen"]
["mullen,will"]
["kirney,jim"]
["simmons,ty "]
["campbell,michelle"]
["wilson,eileen"]
["denton,dennis"]
["gapner,michael"]
["wortman,alice"]
["fernandez,george"]
["macdowell,mark"]
["smith,marcia"]

{"sheet":"TEXT (14)","index":25,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["First Name","Last Name","Hire Date","SS #","Department","Position","Annual Salary","Perf Rating","Mgmt Level"]
["tyrone","anderson","1995-12-02",146902472,"Corporate Staff","Division Manager",42000,3,3]
["james","bruce","2000-05-29",248944357,"Section Manager","Dir. Of Shipping",55000,1,3]
["stuart","klein","1999-05-28",345005582,"Corporate Staff","Accounting Staff",55000,4,2]
["brad","turner","1997-09-17",345035237,"Management Staff","Accounting Staff",65000,3,3]
["catherine","forest","2000-06-14",368370245,"Corporate Manager","Director of Advertising",46000,3,2]
["mechell","clese","1995-05-09",456080278,"Corporate Staff","Copy Writer",58000,3,4]
["elizabeth","ridenhauer","1997-04-29",459306733,"Corporate Manager","Vice President",65000,5,1]
["william","martin","1952-07-01",469440032,"Retail","Product Manager",55500,2,3]
["kate","jones","2000-07-25",481349363,"Corporate Staff","Accounting Staff",45000,2,3]
["ellen","spinnaker","1993-04-07",570286844,"Corporate Staff","Circulation Manager",70000,4,3]
["will","mullen","1999-06-08",611048942,"Corporate Staff","Division Manager",53500,4,3]
["jim","kirney","1995-10-28",618035383,"Retail","Product Manager",47500,3,3]
["ty ","simmons","1999-05-14",679694534,"Retail","Product Manager",57500,3,3]
["michelle","campbell","1998-05-05",681302482,"Management Staff","Accounting Staff",42000,3,2]
["eileen","wilson","1995-07-29",682110774,"Retail","Product Manager",48000,4,3]
["dennis","denton","1987-07-04",692241314,"Section Manager","Director of Training",45000,4,3]
["michael","gapner","1961-08-20",706670481,"Management Staff","Payroll Manager",48000,3,3]
["alice","wortman","1998-04-03",707942310,"Corporate Manager","Marketing Manager",85000,4,2]
["george","fernandez","1997-03-30",781041004,"Corporate Manager","Office Manager",48000,5,2]
["mark","macdowell","2000-05-06",820015532,"Management Staff","Web Manager",55000,2,3]
["marcia","smith","1995-01-14",931026545,"Corporate Manager","General Sales Manager",42000,2,2]

{"sheet":"CONCATENATE (14)","index":26,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Batch #","Prefix","Date","Sequence"]
[null,"00683","11302010","001"]
[null,"00683","11302010","002"]
[null,"00683","11302010","003"]
[null,"00683","11302010","004"]
[null,"00683","11302010","005"]
[null,"00683","11302010","006"]
[null,"00683","11302010","007"]
[null,"00683","11302010","008"]
[null,"00683","11302010","009"]
[null,"00683","11302010","010"]
[null,"00683","11302010","011"]
[null,"00683","11302010","012"]
[null,"00683","11302010","013"]

{"sheet":"DUPLICATES","index":27,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["First Name","Last Name","Hire Date","SS #","Department","Position","Annual Salary","Perf Rating","Mgmt Level"]
["catherine","forest","2000-06-14",368370245,"Corporate Manager","Director of Advertising",46000,3,2]
["catherine","forest","2000-06-14",368370245,"Corporate Manager","Director of Advertising",46000,3,2]
["elizabeth","ridenhauer","1997-04-29",459306733,"Corporate Manager","Vice President",65000,5,1]
["marty","feldmand","1987-07-08",692241318,"Corporate Manager","Product Manager",47500,4,3]
["alice","wortman","1998-04-03",707942310,"Corporate Manager","Marketing Manager",85000,4,2]
["george","fernandez","1997-03-30",781041004,"Corporate Manager","Office Manager",48000,5,2]
["marcia","smith","1995-01-14",931026545,"Corporate Manager","General Sales Manager",42000,2,2]
["tyrone","anderson","1995-12-02",146902472,"Corporate Staff","Division Manager",42000,3,3]
["stuart","klein","1999-05-28",345005582,"Corporate Staff","Accounting Staff",55000,4,2]
["mechell","clese","1995-05-09",456080278,"Corporate Staff","Copy Writer",58000,3,4]
["kate","jones","2000-07-25",481349363,"Corporate Staff","Accounting Staff",45000,2,3]
["ellen","spinnaker","1993-04-07",570286844,"Corporate Staff","Circulation Manager",70000,4,3]
["will","mullen","1999-06-08",611048942,"Corporate Staff","Division Manager",53500,4,3]
["milly","Johnson","1987-07-05",692241315,"Corporate Staff","Product Manager",65000,4,3]
["Jack","phillips","1987-07-06",692241316,"Corporate Staff","Product Manager",70000,4,3]
["rob","hambleton","1987-07-07",692241317,"Corporate Staff","Product Manager",53500,4,3]
["brad","turner","1997-09-17",345035237,"Management Staff","Accounting Staff",65000,3,3]
["michelle","campbell","1998-05-05",681302482,"Management Staff","Accounting Staff",42000,3,2]
["michael","gapner","1961-08-20",706670481,"Management Staff","Payroll Manager",48000,3,3]
["mark","macdowell","2000-05-06",820015532,"Management Staff","Web Manager",55000,2,3]
["william","martin","1952-07-01",469440032,"Retail","Product Manager",55500,2,3]
["jim","kirney","1995-10-28",618035383,"Retail","Product Manager",47500,3,3]
["ty ","simmons","1999-05-14",679694534,"Retail","Product Manager",57500,3,3]
["eileen","wilson","1995-07-29",682110774,"Retail","Product Manager",48000,4,3]
["james","bruce","2000-05-29",248944357,"Section Manager","Dir. Of Shipping",55000,1,3]
["dennis","denton","1987-07-04",692241314,"Section Manager","Director of Training",45000,4,3]

{"sheet":"SUBTOTALS (15)","index":28,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["First Name","Last Name","Hire Date","SS #","Department","Position","Annual Salary","Perf Rating","Mgmt Level"]
["catherine","forest","2000-06-14",368370245,"Corporate Manager","Director of Advertising",46000,3,2]
["elizabeth","ridenhauer","1997-04-29",459306733,"Corporate Manager","Vice President",65000,5,1]
["marty","feldmand","1987-07-08",692241318,"Corporate Manager","Product Manager",47500,4,3]
["alice","wortman","1998-04-03",707942310,"Corporate Manager","Marketing Manager",85000,4,2]
["george","fernandez","1997-03-30",781041004,"Corporate Manager","Office Manager",48000,5,2]
["marcia","smith","1995-01-14",931026545,"Corporate Manager","General Sales Manager",42000,2,2]
["tyrone","anderson","1995-12-02",146902472,"Corporate Staff","Division Manager",42000,3,3]
["stuart","klein","1999-05-28",345005582,"Corporate Staff","Accounting Staff",55000,4,2]
["mechell","clese","1995-05-09",456080278,"Corporate Staff","Copy Writer",58000,3,4]
["kate","jones","2000-07-25",481349363,"Corporate Staff","Accounting Staff",45000,2,3]
["ellen","spinnaker","1993-04-07",570286844,"Corporate Staff","Circulation Manager",70000,4,3]
["will","mullen","1999-06-08",611048942,"Corporate Staff","Division Manager",53500,4,3]
["milly","Johnson","1987-07-05",692241315,"Corporate Staff","Product Manager",65000,4,3]
["Jack","phillips","1987-07-06",692241316,"Corporate Staff","Product Manager",70000,4,3]
["rob","hambleton","1987-07-07",692241317,"Corporate Staff","Product Manager",53500,4,3]
["brad","turner","1997-09-17",345035237,"Management Staff","Accounting Staff",65000,3,3]
["michelle","campbell","1998-05-05",681302482,"Management Staff","Accounting Staff",42000,3,2]
["michael","gapner","1961-08-20",706670481,"Management Staff","Payroll Manager",48000,3,3]
["mark","macdowell","2000-05-06",820015532,"Management Staff","Web Manager",55000,2,3]
["william","martin","1952-07-01",469440032,"Retail","Product Manager",55500,2,3]
["jim","kirney","1995-10-28",618035383,"Retail","Product Manager",47500,3,3]
["ty ","simmons","1999-05-14",679694534,"Retail","Product Manager",57500,3,3]
["eileen","wilson","1995-07-29",682110774,"Retail","Product Manager",48000,4,3]
["james","bruce","2000-05-29",248944357,"Section Manager","Dir. Of Shipping",55000,1,3]
["dennis","denton","1987-07-04",692241314,"Section Manager","Director of Training",45000,4,3]

{"sheet":"PIVOT TABLES (16)","index":29,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["First Name","Last Name","Hire Date","SS #","Department","Position","Annual Salary","Perf Rating","Mgmt Level"]
["tyrone","anderson","1995-12-02",146902472,"Corporate Staff","Division Manager",65000,3,3]
["james","bruce","2000-05-29",248944357,"Section Manager","Dir. Of Shipping",85000,1,3]
["stuart","klein","1999-05-28",345005582,"Corporate Staff","Accounting Staff",42000,4,2]
["brad","turner","1997-09-17",345035237,"Management Staff","Accounting Staff",55000,3,3]
["catherine","forest","2000-06-14",368370245,"Corporate Manager","Director of Advertising",46000,3,2]
["mechell","clese","1995-05-09",456080278,"Corporate Staff","Copy Writer",58000,3,4]
["elizabeth","ridenhauer","1997-04-29",459306733,"Corporate Manager","Vice President",45000,5,1]
["william","martin","1952-07-01",469440032,"Retail","Product Manager",70000,2,3]
["kate","jones","2000-07-25",481349363,"Corporate Staff","Accounting Staff",53500,2,3]
["ellen","spinnaker","1993-04-07",570286844,"Corporate Staff","Circulation Manager",65000,4,3]
["will","mullen","1999-06-08",611048942,"Corporate Staff","Division Manager",55000,4,3]
["jim","kirney","1995-10-28",618035383,"Retail","Product Manager",55500,3,3]
["ty ","simmons","1999-05-14",679694534,"Retail","Product Manager",47500,3,3]
["michelle","campbell","1998-05-05",681302482,"Management Staff","Accounting Staff",42000,3,2]
["eileen","wilson","1995-07-29",682110774,"Retail","Product Manager",57500,4,3]
["dennis","denton","1987-07-04",692241314,"Section Manager","Director of Training",45000,4,3]
["milly","Johnson","1987-07-05",692241315,"Corporate Staff","Product Manager",48000,4,3]
["Jack","phillips","1987-07-06",692241316,"Corporate Staff","Product Manager",48000,4,3]
["rob","hambleton","1987-07-07",692241317,"Corporate Staff","Product Manager",48000,4,3]
["marty","feldmand","1987-07-08",692241318,"Corporate Manager","Product Manager",55000,4,3]
["michael","gapner","1961-08-20",706670481,"Management Staff","Payroll Manager",42000,3,3]
["alice","wortman","1998-04-03",707942310,"Corporate Manager","Marketing Manager",85000,4,2]
["george","fernandez","1997-03-30",781041004,"Corporate Manager","Office Manager",48000,5,2]
["mark","macdowell","2000-05-06",820015532,"Management Staff","Web Manager",55000,2,3]
["marcia","smith","1995-01-14",931026545,"Corporate Manager","General Sales Manager",42000,2,2]
[]
[]
[]
[]
[]
[]
[]
["rob","hambleton","1998-04-03","123-45-678","Training","Trainer",50000,1,2]
["mary","hambleton","1995-07-29","123-45-679","Training","Marketing",75000,1,1]
["brett","favre","1961-08-20","123-45-680","Training","Motivational Speaker",250000,2,3]

{"sheet":"Grades","index":30,"n_rows":61,"n_cols":4,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["Student","Subject","Quarter","Grade"]
["Blake Campbell","Spelling",1,89]
["Hunter Johnson","Spelling",1,79]
["Mara Johnson","Spelling",1,96]
["Emile Sanchez","Spelling",1,87]
["Jeremy Smith","Spelling",1,92]
["Blake Campbell","Spelling",2,91]
["Hunter Johnson","Spelling",2,82]
["Mara Johnson","Spelling",2,94]
["Emile Sanchez","Spelling",2,84]
["Jeremy Smith","Spelling",2,94]
["Blake Campbell","Spelling",3,84]
["Hunter Johnson","Spelling",3,75]
["Mara Johnson","Spelling",3,92]
["Emile Sanchez","Spelling",3,83]
["Jeremy Smith","Spelling",3,96]
["Blake Campbell","Spelling",4]
["Hunter Johnson","Spelling",4]
["Mara Johnson","Spelling",4]
["Emile Sanchez","Spelling",4]
["Jeremy Smith","Spelling",4]
["Blake Campbell","Reading",1,93]
["Hunter Johnson","Reading",1,91]
["Mara Johnson","Reading",1,78]
["Emile Sanchez","Reading",1,85]
["Jeremy Smith","Reading",1,90]
["Blake Campbell","Reading",2,94]
["Hunter Johnson","Reading",2,89]
["Mara Johnson","Reading",2,82]
["Emile Sanchez","Reading",2,90]
["Jeremy Smith","Reading",2,92]
["Blake Campbell","Reading",3,89]
["Hunter Johnson","Reading",3,97]
["Mara Johnson","Reading",3,88]
["Emile Sanchez","Reading",3,81]
["Jeremy Smith","Reading",3,86]
["Blake Campbell","Reading",4]
["Hunter Johnson","Reading",4]
["Mara Johnson","Reading",4]
["Emile Sanchez","Reading",4]
["Jeremy Smith","Reading",4]
["Blake Campbell","Vocabulary",1,88]
["Hunter Johnson","Vocabulary",1,90]
["Mara Johnson","Vocabulary",1,97]
["Emile Sanchez","Vocabulary",1,79]
["Jeremy Smith","Vocabulary",1,88]
["Blake Campbell","Vocabulary",2,90]
["Hunter Johnson","Vocabulary",2,89]
["Mara Johnson","Vocabulary",2,94]
["Emile Sanchez","Vocabulary",2,82]
["Jeremy Smith","Vocabulary",2,88]
["Blake Campbell","Vocabulary",3,92]
["Hunter Johnson","Vocabulary",3,93]
["Mara Johnson","Vocabulary",3,72]
["Emile Sanchez","Vocabulary",3,85]
["Jeremy Smith","Vocabulary",3,85]
["Blake Campbell","Vocabulary",4]
["Hunter Johnson","Vocabulary",4]
["Mara Johnson","Vocabulary",4]
["Emile Sanchez","Vocabulary",4]
["Jeremy Smith","Vocabulary",4]

{"sheet":"Store 1","index":31,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Store One"]
["Product ID","January","February","March"]
["ALP-701",1861.26,1876,1676.34]
["ALP-702",1398.96,1354.74,1776.84]
["ALP-704",1656.24,1541,1353.4]
["ALP-708",1522.24,1551.72,1947.02]
["ALP-715",1737.98,1428.44,1890.74]
["ALP-790",1444.52,1977.84,1416.38]
["ALP-802",1910.84,1764.78,1827.76]
["ALP-803",1737.98,1392.26,1538.32]
["ALP-811",1573.16,1523.58,1665.62]
["ALP-823",1871.98,1566.46,1511.52]
["ALP-836",1811.68,1488.74,1967.12]

{"sheet":"Store 2","index":32,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Store Two"]
["Product ID","January","February","March"]
["ALP-701",1990.04,1947.32,2139.56]
["ALP-703",2114.64,2356.7199999999998,2200.08]
["ALP-704",2157.36,1783.56,1812.04]
["ALP-709",2087.94,1986.48,1975.8]
["ALP-712",2310.44,2168.04,2611.2600000000002]
["ALP-715",2166.2600000000002,2395.88,1790.68]
["ALP-803",2287.3000000000002,1876.12,2310.44]
["ALP-811",2121.7600000000002,2506.2399999999998,1797.8]

{"sheet":"Store 3","index":33,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Store Three"]
["Product ID","January","February","March"]
["ALP-702",1825.55,1806.7,2031.45]
["ALP-703",2106.85,2143.1,1886.45]
["ALP-704",1858.9,1819.75,1831.35]
["ALP-705",1506.55,1770.45,1883.55]
["ALP-803",1924.15,1815.4,2098.15]
["ALP-811",1766.1,1764.65,1483.35]
["ALP-814",1706.65,1484.8,1465.95]
["ALP-823",1954.6,2148.9,1753.05]
["ALP-835",2067.6999999999998,1487.7,1557.3]
["ALP-836",1747.25,1576.15,2159.0500000000002]

{"sheet":"CELL PROTECTION (21)","index":34,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"First Quarter Sales"]
[null,null,"January","February","March","Total Sales"]
[null,"New Mexico",1000,2000,4000,{"$f":"SUM(C5:E5)","v":7000}]
[null,"Oregon",4000,3456,6443,{"$f":"SUM(C6:E6)","v":13899}]
[null,"Washington",2356,7665,9999,{"$f":"SUM(C7:E7)","v":20020}]
[null,"Colorado",4000,4444,5555,{"$f":"SUM(C8:E8)","v":13999}]

{"sheet":"SHEET PROTECT (21)","index":35,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["First Name","Last Name","Hire Date","SS #","Department","Position","Annual Salary","Perf Rating","Mgmt Level"]
["tyrone","anderson","1995-12-02",146902472,"Corporate Staff","Division Manager",42000,3,3]
["james","bruce","2000-05-29",248944357,"Section Manager","Dir. Of Shipping",55000,1,3]
["stuart","klein","1999-05-28",345005582,"Corporate Staff","Accounting Staff",55000,4,2]
["brad","turner","1997-09-17",345035237,"Management Staff","Accounting Staff",65000,3,3]
["catherine","forest","2000-06-14",368370245,"Corporate Manager","Director of Advertising",46000,3,2]
["mechell","clese","1995-05-09",456080278,"Corporate Staff","Copy Writer",58000,3,4]
["elizabeth","ridenhauer","1997-04-29",459306733,"Corporate Manager","Vice President",65000,5,1]
["william","martin","1952-07-01",469440032,"Retail","Product Manager",55500,2,3]
["kate","jones","2000-07-25",481349363,"Corporate Staff","Accounting Staff",45000,2,3]
["ellen","spinnaker","1993-04-07",570286844,"Corporate Staff","Circulation Manager",70000,4,3]
["will","mullen","1999-06-08",611048942,"Corporate Staff","Division Manager",53500,4,3]
["jim","kirney","1995-10-28",618035383,"Retail","Product Manager",47500,3,3]
["ty ","simmons","1999-05-14",679694534,"Retail","Product Manager",57500,3,3]
["michelle","campbell","1998-05-05",681302482,"Management Staff","Accounting Staff",42000,3,2]
["eileen","wilson","1995-07-29",682110774,"Retail","Product Manager",48000,4,3]
["dennis","denton","1987-07-04",692241314,"Section Manager","Director of Training",45000,4,3]
["milly","Johnson","1987-07-05",692241315,"Corporate Staff","Product Manager",65000,4,3]
["Jack","phillips","1987-07-06",692241316,"Corporate Staff","Product Manager",70000,4,3]
["rob","hambleton","1987-07-07",692241317,"Corporate Staff","Product Manager",53500,4,3]
["marty","feldmand","1987-07-08",692241318,"Corporate Manager","Product Manager",47500,4,3]
["michael","gapner","1961-08-20",706670481,"Management Staff","Payroll Manager",48000,3,3]
["alice","wortman","1998-04-03",707942310,"Corporate Manager","Marketing Manager",85000,4,2]
["george","fernandez","1997-03-30",781041004,"Corporate Manager","Office Manager",48000,5,2]
["mark","macdowell","2000-05-06",820015532,"Management Staff","Web Manager",55000,2,3]
["marcia","smith","1995-01-14",931026545,"Corporate Manager","General Sales Manager",42000,2,2]

{"sheet":"VALIDATION (22)","index":36,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Time Sheet"]
["Name","Time In","Time Out","Hours Worked",null,"07:00:00","12:00:00"]
["Bill Stevenson","06:46:00","16:43:00",null,null,"07:15:00","12:15:00"]
["Carol Miller","06:49:00","17:15:00",null,null,"07:30:00","12:30:00"]
["Randy Howard",null,"15:23:00",null,null,"07:45:00","12:45:00"]
["Amy Moore","06:45:00",null,null,null,"08:00:00","13:00:00"]
["Steve Richards",null,null,null,null,"08:15:00","13:15:00"]
["Jim Stewart",null,null,null,null,"08:30:00","13:30:00"]
["Julie Reynolds",null,null,null,null,"08:45:00","13:45:00"]
[null,null,null,null,null,"09:00:00","14:00:00"]
[null,null,null,null,null,"09:15:00","14:15:00"]
[null,null,null,null,null,"09:30:00","14:30:00"]
[null,null,null,null,null,"09:45:00","14:45:00"]
[null,null,null,null,null,"10:00:00","15:00:00"]
[null,null,null,null,null,"10:15:00","15:15:00"]
[null,null,null,null,null,"10:30:00","15:30:00"]
[null,null,null,null,null,"10:45:00","15:45:00"]
[null,null,null,null,null,"11:00:00","16:00:00"]
[null,null,null,null,null,"11:15:00","16:15:00"]
[null,null,null,null,null,"11:30:00","16:30:00"]
[null,null,null,null,null,"11:45:00","16:45:00"]
[null,null,null,null,null,"12:00:00","17:00:00"]

{"sheet":"IF FUNCTION (23)","index":37,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["Advertising Accounts Receivable"]
["Current Date:"]
["Invoice\nNumber","Invoice\nDate","Customer\nName","Amount","Invoice\nDue Date","Invoice Age","No. of Days\nOverdue"]
[92334,{"$f":"TODAY()-47","v":"2017-01-11"},"Village Reader",334]
[92356,{"$f":"TODAY()-12","v":"2017-02-15"},"WHAT",152.99]
[92362,{"$f":"TODAY()-56","v":"2017-01-02"},"Advertising Concepts",468.33]
[92379,{"$f":"TODAY()-29","v":"2017-01-29"},"NYNEX",334]
[92393,{"$f":"TODAY()-54","v":"2017-01-04"},"Advertising Concepts",50]
[92407,{"$f":"TODAY()-15","v":"2017-02-12"},"Young Upstart",1500]
[92421,{"$f":"TODAY()-89","v":"2016-11-30"},"Mass Appeal, Inc.",55]
[]
[]
[]
[]
[]
["Greater Than",">"]
["Less Than","<"]
["Greater Than or Equal To",">="]
["Less Than or Equal To","<="]
["Not Equal To","<>"]
["Is Blank","\"\""]
[]
[]
[]
[]
[]
[]
["Invoice Statistics"]
["Age of oldest invoice (in days)"]
["Largest dollar amount"]
["Smallest dollar amount"]
["Age of newest invoice (in days)"]
["Number of invoices"]

{"sheet":"VLOOKUP (24)","index":38,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[9,0,9,1]]}
[]
["Commission Rate",0.1]
[]
["Salesperson","Sales","Quota","Commission","Bonus","Total"]
["Jim Bruce",6598,3000]
["Mark Sanders",6059,4000]
["Carmen Foster",4895,5000]
[]
[]
["Bonus Table"]
["Quota Level","Bonus"]
[2000,25]
[3000,50]
[4000,75]
[5000,100]
[6000,125]

{"sheet":"PRINT MACRO (27)","index":39,"n_rows":8,"n_cols":6,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"First Quarter Sales"]
[null,null,"January","February","March","Total Sales"]
[null,"California",1345,2345,3456,{"$f":"SUM(C5:E5)","v":7146}]
[null,"Oregon",4000,3456,6443,{"$f":"SUM(C6:E6)","v":13899}]
[null,"Washington",2356,7665,9999,{"$f":"SUM(C7:E7)","v":20020}]
[null,"Indiana",4000,4444,5555,{"$f":"SUM(C8:E8)","v":13999}]

{"sheet":"PRODUCTS MACRO (30)","index":40,"n_rows":77,"n_cols":7,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
[1,"Chai","10 boxes x 20 bags",18,39,0,false]
[2,"Chang","24 - 12 oz bottles",19,17,40,false]
[3,"Aniseed Syrup","12 - 550 ml bottles",10,13,70,false]
[4,"Chef Anton's Cajun Seasoning","48 - 6 oz jars",22,53,0,false]
[5,"Chef Anton's Gumbo Mix","36 boxes",21.35,0,0,true]
[6,"Grandma's Boysenberry Spread","12 - 8 oz jars",25,120,0,false]
[7,"Uncle Bob's Organic Dried Pears","12 - 1 lb pkgs.",30,15,0,false]
[8,"Northwoods Cranberry Sauce","12 - 12 oz jars",40,6,0,false]
[9,"Mishi Kobe Niku","18 - 500 g pkgs.",97,29,0,true]
[10,"Ikura","12 - 200 ml jars",31,31,0,false]
[11,"Queso Cabrales","1 kg pkg.",21,22,30,false]
[12,"Queso Manchego La Pastora","10 - 500 g pkgs.",38,86,0,false]
[13,"Konbu","2 kg box",6,24,0,false]
[14,"Tofu","40 - 100 g pkgs.",23.25,35,0,false]
[15,"Genen Shouyu","24 - 250 ml bottles",15.5,39,0,false]
[16,"Pavlova","32 - 500 g boxes",17.45,29,0,false]
[17,"Alice Mutton","20 - 1 kg tins",39,0,0,true]
[18,"Carnarvon Tigers","16 kg pkg.",62.5,42,0,false]
[19,"Teatime Chocolate Biscuits","10 boxes x 12 pieces",9.1999999999999993,25,0,false]
[20,"Sir Rodney's Marmalade","30 gift boxes",81,40,0,false]
[21,"Sir Rodney's Scones","24 pkgs. x 4 pieces",10,3,40,false]
[22,"Gustaf's Knäckebröd","24 - 500 g pkgs.",21,104,0,false]
[23,"Tunnbröd","12 - 250 g pkgs.",9,61,0,false]
[24,"Guaraná Fantástica","12 - 355 ml cans",4.5,20,0,true]
[25,"NuNuCa Nuß-Nougat-Creme","20 - 450 g glasses",14,76,0,false]
[26,"Gumbär Gummibärchen","100 - 250 g bags",31.23,15,0,false]
[27,"Schoggi Schokolade","100 - 100 g pieces",43.9,49,0,false]
[28,"Rössle Sauerkraut","25 - 825 g cans",45.6,26,0,true]
[29,"Thüringer Rostbratwurst","50 bags x 30 sausgs.",123.79,0,0,true]
[30,"Nord-Ost Matjeshering","10 - 200 g glasses",25.89,10,0,false]
[31,"Gorgonzola Telino","12 - 100 g pkgs",12.5,0,70,false]
[32,"Mascarpone Fabioli","24 - 200 g pkgs.",32,9,40,false]
[33,"Geitost","500 g",2.5,112,0,false]
[34,"Sasquatch Ale","24 - 12 oz bottles",14,111,0,false]
[35,"Steeleye Stout","24 - 12 oz bottles",18,20,0,false]
[36,"Inlagd Sill","24 - 250 g  jars",19,112,0,false]
[37,"Gravad lax","12 - 500 g pkgs.",26,11,50,false]
[38,"Côte de Blaye","12 - 75 cl bottles",263.5,17,0,false]
[39,"Chartreuse verte","750 cc per bottle",18,69,0,false]
[40,"Boston Crab Meat","24 - 4 oz tins",18.399999999999999,123,0,false]
[41,"Jack's New England Clam Chowder","12 - 12 oz cans",9.65,85,0,false]
[42,"Singaporean Hokkien Fried Mee","32 - 1 kg pkgs.",14,26,0,true]
[43,"Ipoh Coffee","16 - 500 g tins",46,17,10,false]
[44,"Gula Malacca","20 - 2 kg bags",19.45,27,0,false]
[45,"Røgede sild","1k pkg.",9.5,5,70,false]
[46,"Spegesild","4 - 450 g glasses",12,95,0,false]
[47,"Zaanse koeken","10 - 4 oz boxes",9.5,36,0,false]
[48,"Chocolade","10 pkgs.",12.75,15,70,false]
[49,"Maxilaku","24 - 50 g pkgs.",20,10,60,false]
[50,"Valkoinen suklaa","12 - 100 g bars",16.25,65,0,false]
[51,"Manjimup Dried Apples","50 - 300 g pkgs.",53,20,0,false]
[52,"Filo Mix","16 - 2 kg boxes",7,38,0,false]
[53,"Perth Pasties","48 pieces",32.799999999999997,0,0,true]
[54,"Tourtière","16 pies",7.45,21,0,false]
[55,"Pâté chinois","24 boxes x 2 pies",24,115,0,false]
[56,"Gnocchi di nonna Alice","24 - 250 g pkgs.",38,21,10,false]
[57,"Ravioli Angelo","24 - 250 g pkgs.",19.5,36,0,false]
[58,"Escargots de Bourgogne","24 pieces",13.25,62,0,false]
[59,"Raclette Courdavault","5 kg pkg.",55,79,0,false]
[60,"Camembert Pierrot","15 - 300 g rounds",34,19,0,false]
[61,"Sirop d'érable","24 - 500 ml bottles",28.5,113,0,false]
[62,"Tarte au sucre","48 pies",49.3,17,0,false]
[63,"Vegie-spread","15 - 625 g jars",43.9,24,0,false]
[64,"Wimmers gute Semmelknödel","20 bags x 4 pieces",33.25,22,80,false]
[65,"Louisiana Fiery Hot Pepper Sauce","32 - 8 oz bottles",21.05,76,0,false]
[66,"Louisiana Hot Spiced Okra","24 - 8 oz jars",17,4,100,false]
[67,"Laughing Lumberjack Lager","24 - 12 oz bottles",14,52,0,false]
[68,"Scottish Longbreads","10 boxes x 8 pieces",12.5,6,10,false]
[69,"Gudbrandsdalsost","10 kg pkg.",36,26,0,false]
[70,"Outback Lager","24 - 355 ml bottles",15,15,10,false]
[71,"Fløtemysost","10 - 500 g pkgs.",21.5,26,0,false]
[72,"Mozzarella di Giovanni","24 - 200 g pkgs.",34.799999999999997,14,0,false]
[73,"Röd Kaviar","24 - 150 g jars",15,101,0,false]
[74,"Longlife Tofu","5 kg pkg.",10,4,20,false]
[75,"Rhönbräu Klosterbier","24 - 0.5 l bottles",7.75,125,0,false]
[76,"Lakkalikööri","500 ml",18,57,0,false]
[77,"Original Frankfurter grüne Soße","12 boxes",13,32,0,false]

{"sheet":"PRODUCTS MACRO (31)","index":41,"n_rows":77,"n_cols":7,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
[1,"Chai","10 boxes x 20 bags",18,39,0,false]
[2,"Chang","24 - 12 oz bottles",19,17,40,false]
[3,"Aniseed Syrup","12 - 550 ml bottles",10,13,70,false]
[4,"Chef Anton's Cajun Seasoning","48 - 6 oz jars",22,53,0,false]
[5,"Chef Anton's Gumbo Mix","36 boxes",21.35,0,0,true]
[6,"Grandma's Boysenberry Spread","12 - 8 oz jars",25,120,0,false]
[7,"Uncle Bob's Organic Dried Pears","12 - 1 lb pkgs.",30,15,0,false]
[8,"Northwoods Cranberry Sauce","12 - 12 oz jars",40,6,0,false]
[9,"Mishi Kobe Niku","18 - 500 g pkgs.",97,29,0,true]
[10,"Ikura","12 - 200 ml jars",31,31,0,false]
[11,"Queso Cabrales","1 kg pkg.",21,22,30,false]
[12,"Queso Manchego La Pastora","10 - 500 g pkgs.",38,86,0,false]
[13,"Konbu","2 kg box",6,24,0,false]
[14,"Tofu","40 - 100 g pkgs.",23.25,35,0,false]
[15,"Genen Shouyu","24 - 250 ml bottles",15.5,39,0,false]
[16,"Pavlova","32 - 500 g boxes",17.45,29,0,false]
[17,"Alice Mutton","20 - 1 kg tins",39,0,0,true]
[18,"Carnarvon Tigers","16 kg pkg.",62.5,42,0,false]
[19,"Teatime Chocolate Biscuits","10 boxes x 12 pieces",9.1999999999999993,25,0,false]
[20,"Sir Rodney's Marmalade","30 gift boxes",81,40,0,false]
[21,"Sir Rodney's Scones","24 pkgs. x 4 pieces",10,3,40,false]
[22,"Gustaf's Knäckebröd","24 - 500 g pkgs.",21,104,0,false]
[23,"Tunnbröd","12 - 250 g pkgs.",9,61,0,false]
[24,"Guaraná Fantástica","12 - 355 ml cans",4.5,20,0,true]
[25,"NuNuCa Nuß-Nougat-Creme","20 - 450 g glasses",14,76,0,false]
[26,"Gumbär Gummibärchen","100 - 250 g bags",31.23,15,0,false]
[27,"Schoggi Schokolade","100 - 100 g pieces",43.9,49,0,false]
[28,"Rössle Sauerkraut","25 - 825 g cans",45.6,26,0,true]
[29,"Thüringer Rostbratwurst","50 bags x 30 sausgs.",123.79,0,0,true]
[30,"Nord-Ost Matjeshering","10 - 200 g glasses",25.89,10,0,false]
[31,"Gorgonzola Telino","12 - 100 g pkgs",12.5,0,70,false]
[32,"Mascarpone Fabioli","24 - 200 g pkgs.",32,9,40,false]
[33,"Geitost","500 g",2.5,112,0,false]
[34,"Sasquatch Ale","24 - 12 oz bottles",14,111,0,false]
[35,"Steeleye Stout","24 - 12 oz bottles",18,20,0,false]
[36,"Inlagd Sill","24 - 250 g  jars",19,112,0,false]
[37,"Gravad lax","12 - 500 g pkgs.",26,11,50,false]
[38,"Côte de Blaye","12 - 75 cl bottles",263.5,17,0,false]
[39,"Chartreuse verte","750 cc per bottle",18,69,0,false]
[40,"Boston Crab Meat","24 - 4 oz tins",18.399999999999999,123,0,false]
[41,"Jack's New England Clam Chowder","12 - 12 oz cans",9.65,85,0,false]
[42,"Singaporean Hokkien Fried Mee","32 - 1 kg pkgs.",14,26,0,true]
[43,"Ipoh Coffee","16 - 500 g tins",46,17,10,false]
[44,"Gula Malacca","20 - 2 kg bags",19.45,27,0,false]
[45,"Røgede sild","1k pkg.",9.5,5,70,false]
[46,"Spegesild","4 - 450 g glasses",12,95,0,false]
[47,"Zaanse koeken","10 - 4 oz boxes",9.5,36,0,false]
[48,"Chocolade","10 pkgs.",12.75,15,70,false]
[49,"Maxilaku","24 - 50 g pkgs.",20,10,60,false]
[50,"Valkoinen suklaa","12 - 100 g bars",16.25,65,0,false]
[51,"Manjimup Dried Apples","50 - 300 g pkgs.",53,20,0,false]
[52,"Filo Mix","16 - 2 kg boxes",7,38,0,false]
[53,"Perth Pasties","48 pieces",32.799999999999997,0,0,true]
[54,"Tourtière","16 pies",7.45,21,0,false]
[55,"Pâté chinois","24 boxes x 2 pies",24,115,0,false]
[56,"Gnocchi di nonna Alice","24 - 250 g pkgs.",38,21,10,false]
[57,"Ravioli Angelo","24 - 250 g pkgs.",19.5,36,0,false]
[58,"Escargots de Bourgogne","24 pieces",13.25,62,0,false]
[59,"Raclette Courdavault","5 kg pkg.",55,79,0,false]
[60,"Camembert Pierrot","15 - 300 g rounds",34,19,0,false]
[61,"Sirop d'érable","24 - 500 ml bottles",28.5,113,0,false]
[62,"Tarte au sucre","48 pies",49.3,17,0,false]
[63,"Vegie-spread","15 - 625 g jars",43.9,24,0,false]
[64,"Wimmers gute Semmelknödel","20 bags x 4 pieces",33.25,22,80,false]
[65,"Louisiana Fiery Hot Pepper Sauce","32 - 8 oz bottles",21.05,76,0,false]
[66,"Louisiana Hot Spiced Okra","24 - 8 oz jars",17,4,100,false]
[67,"Laughing Lumberjack Lager","24 - 12 oz bottles",14,52,0,false]
[68,"Scottish Longbreads","10 boxes x 8 pieces",12.5,6,10,false]
[69,"Gudbrandsdalsost","10 kg pkg.",36,26,0,false]
[70,"Outback Lager","24 - 355 ml bottles",15,15,10,false]
[71,"Fløtemysost","10 - 500 g pkgs.",21.5,26,0,false]
[72,"Mozzarella di Giovanni","24 - 200 g pkgs.",34.799999999999997,14,0,false]
[73,"Röd Kaviar","24 - 150 g jars",15,101,0,false]
[74,"Longlife Tofu","5 kg pkg.",10,4,20,false]
[75,"Rhönbräu Klosterbier","24 - 0.5 l bottles",7.75,125,0,false]
[76,"Lakkalikööri","500 ml",18,57,0,false]
[77,"Original Frankfurter grüne Soße","12 boxes",13,32,0,false]

{"sheet":"PRODUCTS MACRO (32)","index":42,"n_rows":77,"n_cols":7,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
[1,"Chai","10 boxes x 20 bags",18,39,0,false]
[2,"Chang","24 - 12 oz bottles",19,17,40,false]
[3,"Aniseed Syrup","12 - 550 ml bottles",10,13,70,false]
[4,"Chef Anton's Cajun Seasoning","48 - 6 oz jars",22,53,0,false]
[5,"Chef Anton's Gumbo Mix","36 boxes",21.35,0,0,true]
[6,"Grandma's Boysenberry Spread","12 - 8 oz jars",25,120,0,false]
[7,"Uncle Bob's Organic Dried Pears","12 - 1 lb pkgs.",30,15,0,false]
[8,"Northwoods Cranberry Sauce","12 - 12 oz jars",40,6,0,false]
[9,"Mishi Kobe Niku","18 - 500 g pkgs.",97,29,0,true]
[10,"Ikura","12 - 200 ml jars",31,31,0,false]
[11,"Queso Cabrales","1 kg pkg.",21,22,30,false]
[12,"Queso Manchego La Pastora","10 - 500 g pkgs.",38,86,0,false]
[13,"Konbu","2 kg box",6,24,0,false]
[14,"Tofu","40 - 100 g pkgs.",23.25,35,0,false]
[15,"Genen Shouyu","24 - 250 ml bottles",15.5,39,0,false]
[16,"Pavlova","32 - 500 g boxes",17.45,29,0,false]
[17,"Alice Mutton","20 - 1 kg tins",39,0,0,true]
[18,"Carnarvon Tigers","16 kg pkg.",62.5,42,0,false]
[19,"Teatime Chocolate Biscuits","10 boxes x 12 pieces",9.1999999999999993,25,0,false]
[20,"Sir Rodney's Marmalade","30 gift boxes",81,40,0,false]
[21,"Sir Rodney's Scones","24 pkgs. x 4 pieces",10,3,40,false]
[22,"Gustaf's Knäckebröd","24 - 500 g pkgs.",21,104,0,false]
[23,"Tunnbröd","12 - 250 g pkgs.",9,61,0,false]
[24,"Guaraná Fantástica","12 - 355 ml cans",4.5,20,0,true]
[25,"NuNuCa Nuß-Nougat-Creme","20 - 450 g glasses",14,76,0,false]
[26,"Gumbär Gummibärchen","100 - 250 g bags",31.23,15,0,false]
[27,"Schoggi Schokolade","100 - 100 g pieces",43.9,49,0,false]
[28,"Rössle Sauerkraut","25 - 825 g cans",45.6,26,0,true]
[29,"Thüringer Rostbratwurst","50 bags x 30 sausgs.",123.79,0,0,true]
[30,"Nord-Ost Matjeshering","10 - 200 g glasses",25.89,10,0,false]
[31,"Gorgonzola Telino","12 - 100 g pkgs",12.5,0,70,false]
[32,"Mascarpone Fabioli","24 - 200 g pkgs.",32,9,40,false]
[33,"Geitost","500 g",2.5,112,0,false]
[34,"Sasquatch Ale","24 - 12 oz bottles",14,111,0,false]
[35,"Steeleye Stout","24 - 12 oz bottles",18,20,0,false]
[36,"Inlagd Sill","24 - 250 g  jars",19,112,0,false]
[37,"Gravad lax","12 - 500 g pkgs.",26,11,50,false]
[38,"Côte de Blaye","12 - 75 cl bottles",263.5,17,0,false]
[39,"Chartreuse verte","750 cc per bottle",18,69,0,false]
[40,"Boston Crab Meat","24 - 4 oz tins",18.399999999999999,123,0,false]
[41,"Jack's New England Clam Chowder","12 - 12 oz cans",9.65,85,0,false]
[42,"Singaporean Hokkien Fried Mee","32 - 1 kg pkgs.",14,26,0,true]
[43,"Ipoh Coffee","16 - 500 g tins",46,17,10,false]
[44,"Gula Malacca","20 - 2 kg bags",19.45,27,0,false]
[45,"Røgede sild","1k pkg.",9.5,5,70,false]
[46,"Spegesild","4 - 450 g glasses",12,95,0,false]
[47,"Zaanse koeken","10 - 4 oz boxes",9.5,36,0,false]
[48,"Chocolade","10 pkgs.",12.75,15,70,false]
[49,"Maxilaku","24 - 50 g pkgs.",20,10,60,false]
[50,"Valkoinen suklaa","12 - 100 g bars",16.25,65,0,false]
[51,"Manjimup Dried Apples","50 - 300 g pkgs.",53,20,0,false]
[52,"Filo Mix","16 - 2 kg boxes",7,38,0,false]
[53,"Perth Pasties","48 pieces",32.799999999999997,0,0,true]
[54,"Tourtière","16 pies",7.45,21,0,false]
[55,"Pâté chinois","24 boxes x 2 pies",24,115,0,false]
[56,"Gnocchi di nonna Alice","24 - 250 g pkgs.",38,21,10,false]
[57,"Ravioli Angelo","24 - 250 g pkgs.",19.5,36,0,false]
[58,"Escargots de Bourgogne","24 pieces",13.25,62,0,false]
[59,"Raclette Courdavault","5 kg pkg.",55,79,0,false]
[60,"Camembert Pierrot","15 - 300 g rounds",34,19,0,false]
[61,"Sirop d'érable","24 - 500 ml bottles",28.5,113,0,false]
[62,"Tarte au sucre","48 pies",49.3,17,0,false]
[63,"Vegie-spread","15 - 625 g jars",43.9,24,0,false]
[64,"Wimmers gute Semmelknödel","20 bags x 4 pieces",33.25,22,80,false]
[65,"Louisiana Fiery Hot Pepper Sauce","32 - 8 oz bottles",21.05,76,0,false]
[66,"Louisiana Hot Spiced Okra","24 - 8 oz jars",17,4,100,false]
[67,"Laughing Lumberjack Lager","24 - 12 oz bottles",14,52,0,false]
[68,"Scottish Longbreads","10 boxes x 8 pieces",12.5,6,10,false]
[69,"Gudbrandsdalsost","10 kg pkg.",36,26,0,false]
[70,"Outback Lager","24 - 355 ml bottles",15,15,10,false]
[71,"Fløtemysost","10 - 500 g pkgs.",21.5,26,0,false]
[72,"Mozzarella di Giovanni","24 - 200 g pkgs.",34.799999999999997,14,0,false]
[73,"Röd Kaviar","24 - 150 g jars",15,101,0,false]
[74,"Longlife Tofu","5 kg pkg.",10,4,20,false]
[75,"Rhönbräu Klosterbier","24 - 0.5 l bottles",7.75,125,0,false]
[76,"Lakkalikööri","500 ml",18,57,0,false]
[77,"Original Frankfurter grüne Soße","12 boxes",13,32,0,false]

{"sheet":"PRODUCTS MACRO (33)","index":43,"n_rows":77,"n_cols":7,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
[1,"Chai","10 boxes x 20 bags",18,39,0,false]
[2,"Chang","24 - 12 oz bottles",19,17,40,false]
[3,"Aniseed Syrup","12 - 550 ml bottles",10,13,70,false]
[4,"Chef Anton's Cajun Seasoning","48 - 6 oz jars",22,53,0,false]
[5,"Chef Anton's Gumbo Mix","36 boxes",21.35,0,0,true]
[6,"Grandma's Boysenberry Spread","12 - 8 oz jars",25,120,0,false]
[7,"Uncle Bob's Organic Dried Pears","12 - 1 lb pkgs.",30,15,0,false]
[8,"Northwoods Cranberry Sauce","12 - 12 oz jars",40,6,0,false]
[9,"Mishi Kobe Niku","18 - 500 g pkgs.",97,29,0,true]
[10,"Ikura","12 - 200 ml jars",31,31,0,false]
[11,"Queso Cabrales","1 kg pkg.",21,22,30,false]
[12,"Queso Manchego La Pastora","10 - 500 g pkgs.",38,86,0,false]
[13,"Konbu","2 kg box",6,24,0,false]
[14,"Tofu","40 - 100 g pkgs.",23.25,35,0,false]
[15,"Genen Shouyu","24 - 250 ml bottles",15.5,39,0,false]
[16,"Pavlova","32 - 500 g boxes",17.45,29,0,false]
[17,"Alice Mutton","20 - 1 kg tins",39,0,0,true]
[18,"Carnarvon Tigers","16 kg pkg.",62.5,42,0,false]
[19,"Teatime Chocolate Biscuits","10 boxes x 12 pieces",9.1999999999999993,25,0,false]
[20,"Sir Rodney's Marmalade","30 gift boxes",81,40,0,false]
[21,"Sir Rodney's Scones","24 pkgs. x 4 pieces",10,3,40,false]
[22,"Gustaf's Knäckebröd","24 - 500 g pkgs.",21,104,0,false]
[23,"Tunnbröd","12 - 250 g pkgs.",9,61,0,false]
[24,"Guaraná Fantástica","12 - 355 ml cans",4.5,20,0,true]
[25,"NuNuCa Nuß-Nougat-Creme","20 - 450 g glasses",14,76,0,false]
[26,"Gumbär Gummibärchen","100 - 250 g bags",31.23,15,0,false]
[27,"Schoggi Schokolade","100 - 100 g pieces",43.9,49,0,false]
[28,"Rössle Sauerkraut","25 - 825 g cans",45.6,26,0,true]
[29,"Thüringer Rostbratwurst","50 bags x 30 sausgs.",123.79,0,0,true]
[30,"Nord-Ost Matjeshering","10 - 200 g glasses",25.89,10,0,false]
[31,"Gorgonzola Telino","12 - 100 g pkgs",12.5,0,70,false]
[32,"Mascarpone Fabioli","24 - 200 g pkgs.",32,9,40,false]
[33,"Geitost","500 g",2.5,112,0,false]
[34,"Sasquatch Ale","24 - 12 oz bottles",14,111,0,false]
[35,"Steeleye Stout","24 - 12 oz bottles",18,20,0,false]
[36,"Inlagd Sill","24 - 250 g  jars",19,112,0,false]
[37,"Gravad lax","12 - 500 g pkgs.",26,11,50,false]
[38,"Côte de Blaye","12 - 75 cl bottles",263.5,17,0,false]
[39,"Chartreuse verte","750 cc per bottle",18,69,0,false]
[40,"Boston Crab Meat","24 - 4 oz tins",18.399999999999999,123,0,false]
[41,"Jack's New England Clam Chowder","12 - 12 oz cans",9.65,85,0,false]
[42,"Singaporean Hokkien Fried Mee","32 - 1 kg pkgs.",14,26,0,true]
[43,"Ipoh Coffee","16 - 500 g tins",46,17,10,false]
[44,"Gula Malacca","20 - 2 kg bags",19.45,27,0,false]
[45,"Røgede sild","1k pkg.",9.5,5,70,false]
[46,"Spegesild","4 - 450 g glasses",12,95,0,false]
[47,"Zaanse koeken","10 - 4 oz boxes",9.5,36,0,false]
[48,"Chocolade","10 pkgs.",12.75,15,70,false]
[49,"Maxilaku","24 - 50 g pkgs.",20,10,60,false]
[50,"Valkoinen suklaa","12 - 100 g bars",16.25,65,0,false]
[51,"Manjimup Dried Apples","50 - 300 g pkgs.",53,20,0,false]
[52,"Filo Mix","16 - 2 kg boxes",7,38,0,false]
[53,"Perth Pasties","48 pieces",32.799999999999997,0,0,true]
[54,"Tourtière","16 pies",7.45,21,0,false]
[55,"Pâté chinois","24 boxes x 2 pies",24,115,0,false]
[56,"Gnocchi di nonna Alice","24 - 250 g pkgs.",38,21,10,false]
[57,"Ravioli Angelo","24 - 250 g pkgs.",19.5,36,0,false]
[58,"Escargots de Bourgogne","24 pieces",13.25,62,0,false]
[59,"Raclette Courdavault","5 kg pkg.",55,79,0,false]
[60,"Camembert Pierrot","15 - 300 g rounds",34,19,0,false]
[61,"Sirop d'érable","24 - 500 ml bottles",28.5,113,0,false]
[62,"Tarte au sucre","48 pies",49.3,17,0,false]
[63,"Vegie-spread","15 - 625 g jars",43.9,24,0,false]
[64,"Wimmers gute Semmelknödel","20 bags x 4 pieces",33.25,22,80,false]
[65,"Louisiana Fiery Hot Pepper Sauce","32 - 8 oz bottles",21.05,76,0,false]
[66,"Louisiana Hot Spiced Okra","24 - 8 oz jars",17,4,100,false]
[67,"Laughing Lumberjack Lager","24 - 12 oz bottles",14,52,0,false]
[68,"Scottish Longbreads","10 boxes x 8 pieces",12.5,6,10,false]
[69,"Gudbrandsdalsost","10 kg pkg.",36,26,0,false]
[70,"Outback Lager","24 - 355 ml bottles",15,15,10,false]
[71,"Fløtemysost","10 - 500 g pkgs.",21.5,26,0,false]
[72,"Mozzarella di Giovanni","24 - 200 g pkgs.",34.799999999999997,14,0,false]
[73,"Röd Kaviar","24 - 150 g jars",15,101,0,false]
[74,"Longlife Tofu","5 kg pkg.",10,4,20,false]
[75,"Rhönbräu Klosterbier","24 - 0.5 l bottles",7.75,125,0,false]
[76,"Lakkalikööri","500 ml",18,57,0,false]
[77,"Original Frankfurter grüne Soße","12 boxes",13,32,0,false]

{"sheet":"PASTE SPECIAL (4)","index":44,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["First Name","Last Name","Hire Date","SS #","Department","Position","Current Salary","Raise","Perf Rating","Mgmt Level"]
["tyrone","anderson","1995-12-02",146902472,"Corporate Staff","Division Manager",51051.262500000004,1.05,3,3]
["james","bruce","2000-05-29",248944357,"Section Manager","Dir. Of Shipping",66852.84375,null,1,3]
["stuart","klein","1999-05-28",345005582,"Corporate Staff","Accounting Staff",66852.84375,null,4,2]
["brad","turner","1997-09-17",345035237,"Management Staff","Accounting Staff",79007.90625,null,3,3]
["catherine","forest","2000-06-14",368370245,"Corporate Manager","Director of Advertising",55913.287500000006,null,3,2]
["mechell","clese","1995-05-09",456080278,"Corporate Staff","Copy Writer",70499.362500000003,null,3,4]
["elizabeth","ridenhauer","1997-04-29",459306733,"Corporate Manager","Vice President",79007.90625,null,5,1]
["william","martin","1952-07-01",469440032,"Retail","Product Manager",67460.596875000003,null,2,3]
["kate","jones","2000-07-25",481349363,"Corporate Staff","Accounting Staff",54697.78125,null,2,3]
["ellen","spinnaker","1993-04-07",570286844,"Corporate Staff","Circulation Manager",85085.4375,null,4,3]
["will","mullen","1999-06-08",611048942,"Corporate Staff","Division Manager",65029.584374999999,null,4,3]
["jim","kirney","1995-10-28",618035383,"Retail","Product Manager",57736.546875,null,3,3]
["ty ","simmons","1999-05-14",679694534,"Retail","Product Manager",69891.609375,null,3,3]
["michelle","campbell","1998-05-05",681302482,"Management Staff","Accounting Staff",51051.262500000004,null,3,2]
["eileen","wilson","1995-07-29",682110774,"Retail","Product Manager",58344.3,null,4,3]
["dennis","denton","1987-07-04",692241314,"Section Manager","Director of Training",54697.78125,null,4,3]
["michael","gapner","1961-08-20",706670481,"Management Staff","Payroll Manager",58344.3,null,3,3]
["alice","wortman","1998-04-03",707942310,"Corporate Manager","Marketing Manager",103318.03125,null,4,2]
["george","fernandez","1997-03-30",781041004,"Corporate Manager","Office Manager",58344.3,null,5,2]
["mark","macdowell","2000-05-06",820015532,"Management Staff","Web Manager",66852.84375,null,2,3]
["marcia","smith","1995-01-14",931026545,"Corporate Manager","General Sales Manager",51051.262500000004,null,2,2]

{"sheet":"CONSOLIDATED (18)","index":45,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Consolidated"]

{"sheet":"STORE 1 (18)","index":46,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Store One"]
["Product ID","January","February","March"]
["ALP-701",1861.26,1876,1676.34]
["ALP-702",1398.96,1354.74,1776.84]
["ALP-704",1656.24,1541,1353.4]
["ALP-708",1522.24,1551.72,1947.02]
["ALP-715",1737.98,1428.44,1890.74]
["ALP-790",1444.52,1977.84,1416.38]
["ALP-802",1910.84,1764.78,1827.76]
["ALP-803",1737.98,1392.26,1538.32]
["ALP-811",1573.16,1523.58,1665.62]
["ALP-823",1871.98,1566.46,1511.52]
["ALP-836",1811.68,1488.74,1967.12]

{"sheet":"STORE 2 (18)","index":47,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Store Two"]
["Product ID","January","February","March"]
["ALP-701",1990.04,1947.32,2139.56]
["ALP-703",2114.64,2356.7199999999998,2200.08]
["ALP-704",2157.36,1783.56,1812.04]
["ALP-709",2087.94,1986.48,1975.8]
["ALP-712",2310.44,2168.04,2611.2600000000002]
["ALP-715",2166.2600000000002,2395.88,1790.68]
["ALP-803",2287.3000000000002,1876.12,2310.44]
["ALP-811",2121.7600000000002,2506.2399999999998,1797.8]

{"sheet":"STORE 3 (18)","index":48,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Store Three"]
["Product ID","January","February","March"]
["ALP-702",1825.55,1806.7,2031.45]
["ALP-703",2106.85,2143.1,1886.45]
["ALP-704",1858.9,1819.75,1831.35]
["ALP-705",1506.55,1770.45,1883.55]
["ALP-803",1924.15,1815.4,2098.15]
["ALP-811",1766.1,1764.65,1483.35]
["ALP-814",1706.65,1484.8,1465.95]
["ALP-823",1954.6,2148.9,1753.05]
["ALP-835",2067.6999999999998,1487.7,1557.3]
["ALP-836",1747.25,1576.15,2159.0500000000002]

{"sheet":"LOAN PMT (23)","index":49,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Loan Payment "]
[]
[null,null,null,null,24,36,48,60,72,84]
["Loan Amount",12000,null,0.02]
["Annual Interest Rate",0.05,null,2.5000000000000001E-2]
["Term in months",48,null,0.03]
[null,null,null,3.5000000000000003E-2]
[null,null,null,0.04]
["Monthly Payment:",{"$f":"PMT(Annual_Interest_Rate/12,Term_in_months,-Loan_Amount)","v":276.35152284775825},null,4.4999999999999998E-2]
["Total Payments:",{"$f":"Monthly_Payment*Term_in_months","v":13264.873096692396},null,0.05]
["Total Interest:",{"$f":"Total_Payments-Loan_Amount","v":1264.8730966923958},null,5.5E-2]
[null,null,null,0.06]

{"sheet":"GOAL SEEK RETIRE (28)","index":50,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[3,1,3,2]]}
[]
[]
[]
[null,"Retirement Planning"]
[null,"Monthly Investment",350]
[null,"Interest Rate",0.06]
[null,"Number of Years",15]
[]
[null,"Future Value",{"$f":"FV(C6/12,(C7*12),-C5,,1)","v":102295.48210408671}]

{"sheet":"SOLVER ROB","index":51,"n_rows":6,"n_cols":18,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,7,0,9],[0,10,0,12]]}
[null,null,null,null,null,null,null,"Time per unit",null,null,"Machine Hours"]
[null,null,null,"Price","Cost","Margin","Hours Per","M1","M2","M3","M1","M2","M3","QTY","Revenue","COGS","Margin","Hours"]
[null,null,"Product A",10,4,{"$f":"D3-E3","v":6},0.5,0.1,0.2,0.5,{"$f":"H3*N3","v":431.90000000000003},{"$f":"N3*I3","v":863.80000000000007},{"$f":"N3*J3","v":2159.5},4319,{"$f":"N3*D3","v":43190},{"$f":"N3*E3","v":17276},{"$f":"O3-P3","v":25914},{"$f":"N3*G3","v":2159.5}]
[null,null,"Product B",6,2,{"$f":"D4-E4","v":4},0.25,0.3,0.5,0.1,{"$f":"H4*N4","v":8448.6},{"$f":"N4*I4","v":14081},{"$f":"N4*J4","v":2816.2000000000003},28162,{"$f":"N4*D4","v":168972},{"$f":"N4*E4","v":56324},{"$f":"O4-P4","v":112648},{"$f":"N4*G4","v":7040.5}]
[null,null,"Product C",2000,1000,1000,100,1.5,2,2.1,12,16,16.8,8,16000,8000,8000,800]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K3:K5)","v":8892.5},{"$f":"SUM(L3:L5)","v":14960.8},4992.5000000000009,null,null,null,{"$f":"SUM(Q3:Q5)","v":146562},{"$f":"SUM(R3:R5)","v":10000}]

{"sheet":"SOLVER (28)","index":52,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Annual Interest Rate",0.1]
["Term in months",48]
[]
[null,"Van","Sedan","Compact"]
["Price",24000,21000,16000]
["Passengers",9,6,4]
["Quantity to Purchase",2,2,2]
[]
["Loan Amount",{"$f":"B7*B5","v":48000},{"$f":"C7*C5","v":42000},{"$f":"D7*D5","v":32000}]
["Monthly Payment",{"$f":"PMT($B$1/12,$B$2,-B9)","v":1217.4040048678651},{"$f":"PMT($B$1/12,$B$2,-C9)","v":1065.2285042593819},{"$f":"PMT($B$1/12,$B$2,-D9)","v":811.60266991191008}]
["Total Passengers",{"$f":"B7*B6","v":18},{"$f":"C7*C6","v":12},{"$f":"D7*D6","v":8}]
[]
["TOTAL LOAN AMOUNTS",{"$f":"B9+C9+D9","v":122000}]
["TOTAL MONTHLY PAYMENTS",{"$f":"B10+C10+D10","v":3094.2351790391572}]
["TOTAL PASSENGERS",{"$f":"B11+C11+D11","v":38}]
[]
[]
["Max Monthly Payments",3700]
["Goal Passengers",44]

{"sheet":"SOLVER WIERD","index":53,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Units","Price","Value"]
[null,10,10.19,{"$f":"C3*B3","v":101.89999999999999}]
[null,82.989010989010993,4.55,{"$f":"C4*B4","v":377.6}]
[null,null,null,{"$f":"SUM(D3:D4)","v":479.5}]

{"sheet":"Pesky Penny Problem","index":54,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,"Full Tuition","Student %","Student Charge","Round Function","Combined"]
[null,3869.97,0.89065399999999995,{"$f":"C2*B2","v":3446.8042603799995},{"$f":"ROUND(D2,2)","v":3446.8},{"$f":"ROUND(B2*C2,2)","v":3446.8}]
[null,4000,0.39776499999999998,{"$f":"C3*B3","v":1591.06},{"$f":"ROUND(D3,2)","v":1591.06},{"$f":"ROUND(B3*C3,2)","v":1591.06}]
[null,5000,0.43,2150,2150,2150]
[null,2345,0.98769870000000004,2316.1534515000003,2316.15,2316.15]
[null,6789,0.12,814.68,814.68,814.68]
[null,1232,0.56000000000000005,689.92000000000007,689.92,689.92]
[null,8976,0.45,4039.2000000000003,4039.2,4039.2]
[]
["Total",{"$f":"SUM(B2:B8)","v":32211.97},null,{"$f":"SUM(D2:D8)","v":15047.817711880001},{"$f":"SUM(E2:E8)","v":15047.810000000001},{"$f":"SUM(F2:F8)","v":15047.810000000001}]

{"sheet":"Screwed Up Phone Numbers","index":55,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["First Name","Last Name","Phone Number"]
["elizabeth","ridenhauer","541-333-6789"]
["alice","wortman","(541)-444-6791"]
["tyrone","anderson","541 999-9878"]
["stuart","klein","(541) 222-1212"]
["catherine","forest","541-333-6790"]
["mechell","clese","(541)-444-6792"]
["kate","jones","542 999-9878"]
["ellen","spinnaker","(541) 222-1213"]
["will","mullen","541-333-6791"]
["brad","turner","(541)-444-6793"]
["mark","macdowell","543 999-9878"]
["william","martin","(541) 222-1214"]
["jim","kirney","541-333-6792"]
["michelle","campbell","(541)-444-6794"]
["ty ","simmons","544 999-9878"]
["dennis","denton","(541) 222-1215"]
["michael","gapner","541-333-6793"]
["eileen","wilson","(541)-444-6795"]
["george","fernandez","545 999-9878"]
["james","bruce","(541) 222-1216"]
["marcia","smith","541-333-6794"]

{"sheet":"MATCH CLEAN INDEX","index":56,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["First Name","First Name"]
["elizabeth","elizabeth",{"$f":"MATCH(B2,First_Name,0)","v":1},{"$f":"CLEAN(B2)","v":"elizabeth"},"elizabeth    elizabeth",{"$f":"TRIM(E2)","v":"elizabeth elizabeth"},{"$f":"clean","v":{"$error":"#NAME?"}},{"$f":"INDEX(First_Name,3,1)","v":"alice"}]
["elizabeth","catherine",6,null,"elizabeth    catherine",{"$f":"TRIM(E3)","v":"elizabeth catherine"}]
["alice","mechell",7,null,"alice    mechell","alice mechell"]
["tyrone","kate",8,null,"tyrone    kate","tyrone kate"]
["stuart","ellen",9,null,"stuart    ellen","stuart ellen"]
["catherine","will",10,null,"catherine    will","catherine will"]
["mechell","brad",11,null,"mechell    brad","mechell brad"]
["kate","mark",12,null,"kate    mark","kate mark"]
["ellen","william",13,null,"ellen    william","ellen william"]
["will","jim",14,null,"will    jim","will jim"]
["brad","michelle",15,null,"brad    michelle","brad michelle"]
["mark","ty ",16,null,"mark    ty ","mark ty"]
["william","dennis",17,null,"william    dennis","william dennis"]
["jim","michael",18,null,"jim    michael","jim michael"]
["michelle","eileen",19,null,"michelle    eileen","michelle eileen"]
["ty ","george",20,null,"ty     george","ty george"]
["dennis","james",21,null,"dennis    james","dennis james"]
["michael","marcia",22,null,"michael    marcia","michael marcia"]
["eileen",null,{"$error":"#N/A"},null,"eileen    ","eileen"]
["george",null,{"$error":"#N/A"},null,"george    ","george"]
["james",null,{"$error":"#N/A"},null,"james    ","james"]
["marcia",null,{"$error":"#N/A"},null,"marcia    ","marcia"]

{"sheet":"SUMIFS","index":57,"n_rows":296,"n_cols":13,"rows_kept":296,"cut":false,"hidden":false,"merged":[]}
["Passenger Name","Type","Vendor","Depart","Return","Daily Rate","Total Fare","Itinerary","Invoice #","rand","Passenger","Vendor","Travel Amount"]
["Adams/Donna","Dom. Air","Delta Air Lines","2000-05-15","2000-05-20",113.87,569.36,"ATLPHXATL","110125S",{"$f":"RAND()","v":0.54848771087645942},"Conelly/Doug","Delta Air Lines",{"$f":"SUMIFS(Total_Fare,Passenger_Name,K2,Vendor,L2)","v":253}]
["Adams/Donna","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110125S",0.42454132368849007]
["Adams/Jim","Dom. Air","Delta Air Lines","2000-05-15","2000-05-20",113.87,569.36,"ATLPHXATL","110124S",0.97180323054013817]
["Adams/Jim","TRANS FEE","ARC","2000-01-27",null,10,10,"ARC","109555S",0.15301536905868529]
["Adams/Jim","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110124S",0.31204876874669729]
["Atkins/Ron","Dom. Air","Northwest Airlines","2000-02-23","2000-02-24",522,522,"OKCMEMTPAMEMOKC","110175S",0.92108848986205449]
["Atkins/Ron","Car","Hertz","2000-02-23","2000-02-24",82,82,"TPA","110175S",0.66888611584021096]
["Atkins/Ron","TRANS FEE","ARC","2000-02-23",null,10,10,"ARC","110175S",0.65254068682166833]
["Carrey/Barry","Dom. Air","Delta Air Lines","2000-05-12","2000-05-19",78.849999999999994,552,"MGMATLDAYATLPHXATLMGM","110802S",0.52642141954384969]
["Carrey/Barry","TRANS FEE","ARC","2000-05-12",null,10,10,"ARC","110802S",0.95952519242569589]
["Carrey/Pam","Dom. Air","Delta Air Lines","2000-05-12","2000-05-19",78.849999999999994,552,"MGMATLDAYATLPHXATLMGM","110803S",0.24801961264986983]
["Carrey/Pam","TRANS FEE","ARC","2000-05-12",null,10,10,"ARC","110803S",1.0595081017765184E-2]
["Chile/Juan","Dom. Air","America West Airlines","2000-05-11","2000-05-18",53.21,372.5,"FLLLASPHXFLL","110583S",0.86787948678159821]
["Chile/Juan","TRANS FEE","ARC","2000-05-11",null,10,10,"ARC","110583S",0.41921267259328054]
["Conelly/Doug","Hotel","Raintree Plaza Hotel","2000-04-17","2000-04-20",152,456,"DEN","111088S",0.18612117890902502]
["Conelly/Doug","Dom. Air","Delta Air Lines","2000-03-06","2000-03-06",253,253,"TPAATLPHL","110447S",0.52761428651223385]
["Conelly/Doug","Dom. Air","Continental Airlines","2000-03-08","2000-03-08",166.5,166.5,"MDTCLETPA","110449S",0.77628680731309996]
["Conelly/Doug","Dom. Air","USAir","2000-03-07","2000-03-07",148.5,148.5,"PHLMDT","110448S",0.63176619559358338]
["Conelly/Doug","Car","Alamo","2000-04-17","2000-04-20",48.39,145.16999999999999,"DEN","111088S",0.5869695058373755]
["Conelly/Doug","Car","Alamo","2000-03-07","2000-03-08",88,88,"MDT","110448S",0.44528558181668521]
["Conelly/Doug","Hotel","RADISSON","2000-03-07","2000-03-08",79,79,"MDT","110448S",0.92888970887071032]
["Conelly/Doug","Hotel","COURTYARD BY MARRIOTT","2000-03-06","2000-03-07",75,75,"PHL","110447S",0.41797727865640932]
["Conelly/Doug","Car","Alamo","2000-03-06","2000-03-07",51,51,"PHL","110447S",0.25975007905647796]
["Conelly/Doug","TRANS FEE","ARC","2000-04-17",null,10,10,"ARC","111088S",0.92710172766659127]
["Conelly/Doug","TRANS FEE","ARC","2000-03-06",null,10,10,"ARC","110447S",0.40713391773250229]
["Couto/Terry","Hotel","Holiday Inn Express","2000-01-31","2000-02-14",109,1526,"CLW","109640S",6.8239554591353779E-2]
["Couto/Terry","Dom. Air","Delta Air Lines","2000-04-30","2000-05-02",282,564,"TPAATLORDATLTPA","111269S",0.98725730491493058]
["Couto/Terry","Dom. Air","Southwest Airlines","2000-03-23",null,194,194,"TPAMSYTPA","110766S",0.7353928386229992]
["Couto/Terry","Car","Hertz","2000-02-04","2000-02-07",38.39,115.17,"EWR","109756S",3.8960414521542752E-3]
["Couto/Terry","TRANS FEE","ARC","2000-04-30",null,10,10,"ARC","111269S",0.30123806784074303]
["Couto/Terry","TRANS FEE","ARC","2000-03-23",null,10,10,"ARC","110766S",0.3234900062674152]
["Cox/Becky","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",105.92,423.68,"MGMATLPHXATLTPA","110349S",0.10364941209429812]
["Cox/Becky","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110349S",0.12256863014804886]
["Cox/Becky","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",0,0,"MGMATLPHXATLMGM","110794S",0.98879662107115673]
["Cox/William G","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",105.92,423.68,"MGMATLPHXATLTPA","110348S",0.89560610964141563]
["Cox/William G","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110348S",0.2623177237994051]
["Cox/William G","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",0,0,"MGMATLPHXATLMGM","110793S",0.50995518473047652]
["Coyle/Marcus","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",142.34,569.36,"ATLPHXATL","110742S",0.51878596084407913]
["Coyle/Marcus","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110742S",0.6024581157441562]
["Coyle/Mary","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",142.34,569.36,"ATLPHXATL","110743S",0.42765980658990854]
["Coyle/Mary","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110743S",0.3420518217299966]
["Dain/Phyllis","Dom. Air","United Airlines","2000-04-10","2000-04-14",119.75,479,"ATWORDTPAORDATW","110939S",0.82314614142414078]
["Dain/Phyllis","TRANS FEE","ARC","2000-04-10",null,10,10,"ARC","110939S",0.42691599004456005]
["Deitz/Michele","Dom. Air","Delta Air Lines","2000-02-15","2000-02-16",300,300,"STLATLTPAATLSTL","109811S",0.75910782373083918]
["Deitz/Michele","TRANS FEE","ARC","2000-02-15",null,10,10,"ARC","109811S",4.6108058571545207E-2]
["Douglas/Jay","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",142.34,569.36,"ATLPHXATL","110372S",4.5303116692229417E-2]
["Douglas/Jay","Dom. Air","Delta Air Lines","2000-01-27","2000-01-28",175.5,175.5,"ATLDTWATL","109285S",0.66189046221928771]
["Douglas/Jay","TRANS FEE","ARC","2000-01-27",null,10,10,"ARC","109285S",0.48549756300610347]
["Douglas/Jay","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110372S",0.31006153891822597]
["Douglas/Steve","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",142.34,569.36,"ATLPHXATL","110373S",0.2017798498102491]
["Douglas/Steve","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110373S",0.6869346355452457]
["Drake/Deborah","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",50.5,202,"TPADFWPHXATLTPA","109890S",0.21421732801423599]
["Drake/Deborah","Dom. Air","ARC","2000-05-15","2000-05-19",2.5,10,"TPADFWPHXATLTPA","109890S",0.76607879565473092]
["Dulla/Katie","Dom. Air","America West Airlines","2000-05-16","2000-05-19",123.06,369.19,"ORDPHXORD","110957S",9.3101437412017485E-2]
["Dulla/Katie","TRANS FEE","ARC","2000-05-16",null,10,10,"ARC","110957S",0.67834620264958356]
["Dulla/Michael","Dom. Air","America West Airlines","2000-05-16","2000-05-19",123.06,369.19,"ORDPHXORD","110956S",0.17775255709077564]
["Dulla/Michael","TRANS FEE","ARC","2000-05-16",null,10,10,"ARC","110956S",2.3906264593593574E-2]
["Dunaway/Mary","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",145.09,580.36,"PNSATLPHXATLPNS","110229S",0.86432207468089695]
["Dunaway/Mary","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110229S",0.53986377201535041]
["Dunaway/Roger","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",145.09,580.36,"PNSATLPHXATLPNS","110228S",0.39427643105758825]
["Dunaway/Roger","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110228S",0.90178372671427987]
["Glass/Helen","Dom. Air","United Airlines","2000-02-15","2000-02-16",377,377,"IADTPAIAD","109817S",0.90532627134683474]
["Glass/Helen","TRANS FEE","ARC","2000-02-15",null,10,10,"ARC","109817S",0.22614794570517793]
["Griffin/Linda","Dom. Air","America West Airlines","2000-05-11","2000-05-18",53.21,372.5,"FLLLASPHXFLL","110584S",0.83921007755685517]
["Griffin/Linda","TRANS FEE","ARC","2000-05-11",null,10,10,"ARC","110584S",{"$f":"RAND()","v":0.87426742469845475}]
["Hargett/Judy","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",142.34,569.36,"ATLPHXATL","110374S",0.97465287325763816]
["Hargett/Judy","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110374S",4.0331551029866408E-2]
["Hawks/Tammy","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",142.34,569.36,"ATLPHXATL","110375S",0.96348668669851689]
["Hawks/Tammy","Dom. Air","Delta Air Lines","2000-01-27","2000-01-28",175.5,175.5,"ATLDTWATL","109286S",0.34255960957689502]
["Hawks/Tammy","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110375S",0.35004740537010648]
["Hawks/Tammy","TRANS FEE","ARC","2000-01-27",null,10,10,"ARC","109286S",0.7180871396776709]
["Hill/Joseph","Dom. Air","Delta Air Lines","2000-03-15","2000-03-20",85,425,"TPADFWRNODFWTPA","110435S",0.41301224081696353]
["Hill/Joseph","TRANS FEE","ARC","2000-03-15",null,10,10,"ARC","110435S",0.48053374245559433]
["Hill/Vicki","Dom. Air","Continental Airlines","2000-02-13","2000-02-18",129.5,647.5,"TPAIAHDFWIAHTPA","109835S",0.32416990430611292]
["Hill/Vicki","Dom. Air","Trans World Airlines","2000-03-27","2000-03-31",101,404,"TPASTLMCISTLTPA","110782S",0.46880573437904582]
["Hill/Vicki","Dom. Air","Delta Air Lines","2000-03-15","2000-03-23",40,320,"TPADFWRNODFWTPA","110434S",0.36527770481369237]
["Hill/Vicki","Car","Hertz","2000-02-27","2000-03-03",53,265,"DFW","110019S",0.69490870262275806]
["Hill/Vicki","Car","Hertz","2000-02-27","2000-03-03",53,265,"DFW","110018S",0.31799236832660183]
["Hill/Vicki","Car","Hertz","2000-02-13","2000-02-18",53,265,"DFW","109835S",0.86579193178067038]
["Hill/Vicki","Car","Alamo","2000-03-27","2000-03-31",42.23,168.92,"MCI","110782S",0.62031049556233919]
["Hill/Vicki","Dom. Air","Continental Airlines","2000-02-27","2000-03-03",15,75,"TPAIAHDFWIAHTPA","110019S",0.25316025075349324]
["Hill/Vicki","Hotel","FAIRFIELD INN","2000-03-30","2000-03-31",64,64,"MCI","110782S",7.06736782797035E-2]
["Hill/Vicki","TRANS FEE","ARC","2000-02-27",null,10,10,"ARC","110018S",0.56668013636227033]
["Hill/Vicki","TRANS FEE","ARC","2000-02-13",null,10,10,"ARC","109835S",0.86502413849121329]
["Hill/Vicki","TRANS FEE","ARC","2000-03-15",null,10,10,"ARC","110434S",0.38118082058867853]
["Hill/Vicki","TRANS FEE","ARC","2000-03-27",null,10,10,"ARC","110782S",0.622742934927634]
["Hill/Vickki","Dom. Air","Continental Airlines","2000-02-27","2000-03-03",0,0,"DFW","110019S",0.84102207606132928]
["Hopson/Marie","Dom. Air","Delta Air Lines","2000-02-15","2000-02-16",749,749,"DENATLTPAATLDEN","109814S",0.3459533965067394]
["Hopson/Marie","TRANS FEE","ARC","2000-02-15",null,10,10,"ARC","109814S",0.44490033557643938]
["Hosek/Sybil","Dom. Air","America West Airlines","2000-05-15","2000-05-21",50.69,304.18,"ORDPHXORD","110188S",0.94647443679444443]
["Hosek/Sybil","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110188S",0.80434512616174969]
["Jernigan/Debbie","TRANS FEE","ARC","2000-01-27",null,10,10,"ARC","109556S",0.2595078904474527]
["Jernigan/Deborah","Dom. Air","Delta Air Lines","2000-05-15","2000-05-20",113.87,569.36,"ATLPHXATL","110134S",0.25950753253259728]
["Jernigan/Deborah","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110134S"]
["Jernigan/Tyrus","Dom. Air","Delta Air Lines","2000-05-15","2000-05-20",113.87,569.36,"ATLPHXATL","110135S"]
["Jernigan/Tyrus","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110135S"]
["Jiles.randall","Dom. Air","Southwest Airlines","2000-03-02",null,388,388,null,"110559S"]
["Jiles/Frances","Dom. Air","USAir","2000-04-14","2000-04-16",158.5,317,"PVDPHLJAXPHLPVD","110581S"]
["Jiles/Frances","Dom. Air","Southwest Airlines","2000-02-11",null,238.5,238.5,"PVDTPAPVD","109723S"]
["Jiles/Frances","TRANS FEE","ARC","2000-02-11",null,10,10,"ARC","109723S"]
["Jiles/Frances","TRANS FEE","ARC","2000-03-08",null,10,10,"ARC","110214S"]
["Jiles/Frances","TRANS FEE","ARC","2000-04-14",null,10,10,"ARC","110581S"]
["Jiles/Helvey","Dom. Air","Southwest Airlines","2000-03-03",null,393,393,"TPASTLTPA","110491S"]
["Jiles/Helvey","Car","Hertz","2000-03-03","2000-03-12",34.119999999999997,307.13,"STL","110491S"]
["Jiles/Helvey","TRANS FEE","ARC","2000-03-03",null,10,10,"ARC","110491S"]
["Jiles/Paul","Dom. Air","Delta Air Lines","2000-03-17","2000-03-19",195.25,390.5,"MSYATLCHSATLMSY","110393S"]
["Jiles/Paul","TRANS FEE","ARC","2000-03-17",null,10,10,"ARC","110393S"]
["Jiles/Randall","Hotel","Marriott Lincolnshire","2000-04-06","2000-04-09",218,654,"MSY","110185S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-05-15","2000-05-18",183.01,549.04,"PVDATLPHXCVGPVD","110478S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-01-26","2000-01-28",236,472,"TPACVGDTWATLTPA","109246S"]
["Jiles/Randall","Dom. Air","United Airlines","2000-04-30","2000-05-09",52.22,470,"PVDORDTPAIADPVD","111140S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-02-24","2000-02-27",126.33,379,"TPAATLDCAPVDATLTPA","110179S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-03-31","2000-04-02",181.5,363,"TPAATLPVDATLTPA","110165S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-03-10","2000-03-12",180,360,"TPAPVDATLTPA","110168S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-03-17","2000-03-19",180,360,"TPAPVDATLTPA","110167S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-03-24","2000-03-26",180,360,"TPAPVDATLTPA","110166S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-05-12","2000-05-22",36,360,"TPAPVDATLTPA","110470S"]
["Jiles/Randall","Dom. Air","Northwest Airlines","2000-01-28","2000-02-02",66.2,331,"DTWTPADTW","109678S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-03-02","2000-03-07",56.8,284,"TPACVGPVDDCAATLTPA","110176S"]
["Jiles/Randall","Dom. Air","USAir","2000-03-06","2000-03-06",272.5,272.5,"PVDDCA","110178S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-03-03","2000-03-05",130.5,261,"TPAPVDATLTPA","109090S"]
["Jiles/Randall","Dom. Air","Southwest Airlines","2000-04-06",null,194,194,"TPAMSYTPA","110185S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-01-29","2000-01-31",96,192,"TPAATLTPA","109245S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-04-21","2000-04-23",88,176,"TPAPVDATLTPA","110192S"]
["Jiles/Randall","Dom. Air","United Airlines","2000-06-28","2000-06-30",86.5,173,"TPAIADTPA","111093S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-05-05","2000-05-07",59,118,"TPAPVDATLTPA","111102S"]
["Jiles/Randall","Car","Hertz","2000-04-06","2000-04-09",35.090000000000003,105.27,"MSY","110185S"]
["Jiles/Randall","Dom. Air","USAir","2000-02-25","2000-02-25",104.5,104.5,"BWIPVD","110177S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-04-28","2000-04-30",43,86,"TPAATLPVDATLTPA","110196S"]
["Jiles/Randall","Dom. Air","Delta Air Lines","2000-01-27","2000-01-28",75,75,"TPAATLDTWATLTPA","109606S"]
["Jiles/Randall","Car","Hertz","2000-01-27","2000-01-28",63,63,"DTW","109606S"]
["Jiles/Randall","TRANS FEE","ARC","2000-01-26",null,10,10,"ARC","109246S"]
["Jiles/Randall","TRANS FEE","ARC","2000-01-27",null,10,10,"ARC","109619S"]
["Jiles/Randall","TRANS FEE","ARC","2000-01-28",null,10,10,"ARC","109678S"]
["Jiles/Randall","TRANS FEE","ARC","2000-01-29",null,10,10,"ARC","109245S"]
["Jiles/Randall","TRANS FEE","ARC","2000-02-24",null,10,10,"ARC","110179S"]
["Jiles/Randall","TRANS FEE","ARC","2000-03-02",null,10,10,"ARC","110176S"]
["Jiles/Randall","TRANS FEE","ARC","2000-03-02",null,10,10,"ARC","110559S"]
["Jiles/Randall","TRANS FEE","ARC","2000-03-03",null,10,10,"ARC","109090S"]
["Jiles/Randall","TRANS FEE","ARC","2000-03-10",null,10,10,"ARC","110168S"]
["Jiles/Randall","TRANS FEE","ARC","2000-03-17",null,10,10,"ARC","110167S"]
["Jiles/Randall","TRANS FEE","ARC","2000-03-24",null,10,10,"ARC","110166S"]
["Jiles/Randall","TRANS FEE","ARC","2000-03-31",null,10,10,"ARC","110165S"]
["Jiles/Randall","TRANS FEE","ARC","2000-04-06",null,10,10,"ARC","110185S"]
["Jiles/RANDALL","Dom. Air","ARC","2000-04-21","2000-04-23",5,10,"TPAPVDATLTPA","110192S"]
["Jiles/Randall","TRANS FEE","ARC","2000-04-28",null,10,10,"ARC","110187S"]
["Jiles/Randall","TRANS FEE","ARC","2000-04-30",null,10,10,"ARC","111140S"]
["Jiles/Randall","TRANS FEE","ARC","2000-05-05",null,10,10,"ARC","111100S"]
["Jiles/Randall","TRANS FEE","ARC","2000-05-12",null,10,10,"ARC","110470S"]
["Jiles/Randall","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110478S"]
["Jiles/Randall","TRANS FEE","ARC","2000-06-28",null,10,10,"ARC","111093S"]
["Jiles/Randall","Car","Hertz","2000-01-27","2000-01-28",0,0,"DTW","109619S"]
["Jiles/Randall","Dom. Air","USAir","2000-03-06","2000-03-06",-272.5,-272.5,"PVDDCA","110178R"]
["Jiles/Tyler","Dom. Air","Delta Air Lines","2000-02-18","2000-02-22",171.75,687,"PVDCVGTPAMCOPVD","110006S"]
["Jiles/Tyler","Dom. Air","USAir","2000-04-14","2000-04-16",158.5,317,"PVDPHLJAXPHLPVD","110582S"]
["Jiles/Tyler","TRANS FEE","ARC","2000-02-11",null,10,10,"ARC","109723S"]
["Jiles/Tyler","TRANS FEE","ARC","2000-02-18",null,10,10,"ARC","110006S"]
["Jiles/Tyler","TRANS FEE","ARC","2000-03-08",null,10,10,"ARC","110215S"]
["Jiles/Tyler","TRANS FEE","ARC","2000-04-14",null,10,10,"ARC","110582S"]
["JilesTyler","Dom. Air","Southwest Airlines","2000-02-11",null,238.5,238.5,"PVDTPAPVD","109723S"]
["Kaufman/Jeff","Dom. Air","America West Airlines","2000-05-13","2000-05-19",56.33,338,"FLLLASPHXFLL","110597S"]
["Kaufman/Jeff","TRANS FEE","ARC","2000-05-13",null,10,10,"ARC","110597S"]
["Kaufman/Tracy","Dom. Air","America West Airlines","2000-05-13","2000-05-19",56.33,338,"FLLLASPHXFLL","110598S"]
["Kaufman/Tracy","TRANS FEE","ARC","2000-05-13",null,10,10,"ARC","110598S"]
["Komar/Gary","Dom. Air","America West Airlines","2000-05-15","2000-05-21",50.69,304.18,"ORDPHXORD","110189S"]
["Komar/Gary","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110189S"]
["Lawson/Robert","Dom. Air","Delta Air Lines","2000-02-25","2000-02-28",360.66,1082,"DAYCVGTPACVGDAY","110324S"]
["Lawson/Robert","TRANS FEE","ARC","2000-02-25",null,10,10,"ARC","110324S"]
["Lipman/Rick","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",242.97,971.88,"RSWATLPHXATLRSW","110519S"]
["Lipman/Rick","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110519S"]
["Lostroh/Barry","Dom. Air","America West Airlines","2000-05-15","2000-05-19",79.430000000000007,317.72000000000003,"DENPHXDEN","110088S"]
["Lostroh/Barry","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110088S"]
["Lostroh/Joshua","Dom. Air","America West Airlines","2000-05-15","2000-05-19",79.430000000000007,317.72000000000003,"DENPHXDEN","110089S"]
["Lostroh/Joshua","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110089S"]
["Manning/Connie","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",109.5,438,"TPAATLPHXATLTPA","110152S"]
["Manning/Connie","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110152S"]
["Maxwell/Lauren","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",242.97,971.88,"RSWATLPHXATLRSW","110520S"]
["Maxwell/Lauren","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110520S"]
["Mcnulty/Margaret","Dom. Air","American Airlines","2000-05-10","2000-05-19",34.880000000000003,314,"ORDPHXORD","110121S"]
["Mcnulty/Margaret","TRANS FEE","ARC","2000-05-10",null,10,10,"ARC","110121S"]
["Mcnulty/Tom","Dom. Air","American Airlines","2000-05-10","2000-05-19",34.880000000000003,314,"ORDPHXORD","110120S"]
["Mcnulty/Tom","TRANS FEE","ARC","2000-05-10",null,10,10,"ARC","110120S"]
["Munch/Rick","Dom. Air","Delta Air Lines","2000-05-16","2000-05-19",182.01,546.04,"IADPHXATLIAD","110775S"]
["Munch/Rick","TRANS FEE","ARC","2000-05-16",null,10,10,"ARC","110775S"]
["Munch/William","Dom. Air","Delta Air Lines","2000-05-16","2000-05-19",182.01,546.04,"IADPHXATLIAD","110776S"]
["Munch/William","TRANS FEE","ARC","2000-05-16",null,10,10,"ARC","110776S"]
["Murphy/Niki","Dom. Air","Delta Air Lines","2000-02-03","2000-02-06",81.66,245,"TPAATLTPA","109637S"]
["Murphy/Niki","Car","Hertz","2000-02-03","2000-02-06",38.94,116.82,"ATL","109637S"]
["Murphy/Niki","TRANS FEE","ARC","2000-02-03",null,10,10,"ARC","109637S"]
["Newberry/Dayla","Dom. Air","America West Airlines","2000-05-15","2000-05-19",79.430000000000007,317.72000000000003,"DENPHXDEN","110221S"]
["Newberry/Dayla","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110221S"]
["Newberry/Tye","Dom. Air","America West Airlines","2000-05-15","2000-05-19",79.430000000000007,317.72000000000003,"DENPHXDEN","110220S"]
["Newberry/Tye","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110220S"]
["Newell/Patricia","Dom. Air","America West Airlines","2000-05-14","2000-05-20",52.95,317.72000000000003,"DENPHXDEN","110190S"]
["Newell/Patricia","Dom. Air","United Airlines","2000-01-27","2000-01-30",99.66,299,"DENDTWDEN","109343S"]
["Newell/Patricia","Car","Budget","2000-01-27","2000-01-30",24.99,74.97,"DTW","109483S"]
["Newell/Patricia","TRANS FEE","ARC","2000-01-27",null,10,10,"ARC","109343S"]
["Newell/Patricia","TRANS FEE","ARC","2000-05-14",null,10,10,"ARC","110190S"]
["Newell/Steve","Dom. Air","America West Airlines","2000-05-14","2000-05-20",52.95,317.72000000000003,"DENPHXDEN","110191S"]
["Newell/Steve","TRANS FEE","ARC","2000-05-14",null,10,10,"ARC","110191S"]
["Newell/Steven","Dom. Air","United Airlines","2000-01-27","2000-01-30",99.66,299,"DENDTWDEN","109342S"]
["Newell/Steven","TRANS FEE","ARC","2000-01-27",null,10,10,"ARC","109342S"]
["Pettinger/Sandra","Dom. Air","America West Airlines","2000-05-15","2000-05-19",79.430000000000007,317.72000000000003,"DENPHXDEN","110087S"]
["Pettinger/Sandra","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110087S"]
["Richardson/Charles","Dom. Air","America West Airlines","2000-05-16","2000-05-21",55.83,279.19,"TPAPHXTPA","110263S"]
["Richardson/Charles","TRANS FEE","ARC","2000-05-16",null,10,10,"ARC","110263S"]
["Richardson/Margretta","Dom. Air","America West Airlines","2000-05-16","2000-05-21",55.83,279.19,"TPAPHXTPA","110262S"]
["Richardson/Margretta","TRANS FEE","ARC","2000-05-16",null,10,10,"ARC","110262S"]
["Roberts/Desmond","Hotel","XX","2000-02-25","2000-02-28",94,282,"MIA","110193S"]
["Roberts/Desmond","Car","Alamo","2000-02-23","2000-03-01",26.74,187.19,"PIE","110193S"]
["Roberts/Desmond","Hotel","Howard Johnson","2000-02-28","2000-02-29",62.9,62.9,"DAB","110193S"]
["Ruttenburg/Margaret","Dom. Air","Delta Air Lines","2000-02-15","2000-02-16",417,417,"ORDATLTPAATLORD","109816S"]
["Ruttenburg/Margaret","TRANS FEE","ARC","2000-02-15",null,10,10,"ARC","109816S"]
["Sanders/Gene","Dom. Air","America West Airlines","2000-05-15","2000-05-19",119.66,478.64,"MIAPHXMIA","109994S"]
["Sanders/Gene","Dom. Air","American Airlines","2000-01-20","2000-01-20",135.5,135.5,"TPAMIA","109074S"]
["Sanders/Gene","Car","Hertz","2000-01-17","2000-01-20",45,135,"TPA","109073S"]
["Sanders/Gene","Dom. Air","USAir","2000-01-17","2000-01-17",109.5,109.5,"MIATPA","109073S"]
["Sanders/Gene","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","109994S"]
["Sanders/Genevieve","Dom. Air","America West Airlines","2000-05-15","2000-05-19",119.66,478.64,"MIAPHXMIA","109995S"]
["Sanders/Genevieve","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","109995S"]
["Slone/Laurie","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",100.75,403,"TPADFWPHXATLTPA","110934S"]
["Slone/Laurie","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110934S"]
["Slone/Tim","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",100.75,403,"TPADFWPHXATLTPA","110933S"]
["Slone/Tim","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110933S"]
["Smith/T Donald","Dom. Air","ARC","2000-01-27","2000-01-31",2.5,10,"TPAATLDTWATLTPA","109611S"]
["Smith/T Sam","Hotel","Marriott Lincolnshire","2000-02-28","2000-03-29",179,5370,"SNA","110461S"]
["Smith/T Sam","Dom. Air","Delta Air Lines","2000-02-28","2000-03-02",530,1590,"TPADFWSNADENATLTPA","110388S"]
["Smith/T Sam","Dom. Air","Delta Air Lines","2000-01-12","2000-01-13",1405,1405,"TPAATLSNADFWTPA","109173S"]
["Smith/T Sam","Dom. Air","United Airlines","2000-02-29","2000-02-29",754.5,754.5,"SNADEN","110461S"]
["Smith/T Sam","Dom. Air","Delta Air Lines","2000-01-27","2000-01-31",127.25,509,"TPAATLDTWATLTPA","109611S"]
["Smith/T Sam","Dom. Air","Delta Air Lines","2000-01-26","2000-01-31",90,450,"TPACVGDTWATLTPA","109247S"]
["Smith/T Sam","Dom. Air","United Airlines","2000-07-09","2000-07-11",209.25,418.5,"TPAORDTPA","111059S"]
["Smith/T Sam","Hotel","Marriott Lincolnshire","2000-02-28","2000-03-01",159,318,"SNA","110388S"]
["Smith/T Sam","Dom. Air","Delta Air Lines","2000-04-06","2000-04-09",104,312,"TPAATLTPA","111081S"]
["Smith/T Sam","Dom. Air","Delta Air Lines","2000-01-29","2000-01-29",294,294,"TPAATL","109718S"]
["Smith/T Sam","Hotel","Ritz Carlton","2000-04-06","2000-04-07",220,220,"ATL","111081S"]
["Smith/T Sam","Dom. Air","Delta Air Lines","2000-05-21","2000-05-23",94.5,189,"TPAATLTPA","110445S"]
["Smith/T Sam","Dom. Air","United Airlines","2000-06-28","2000-06-30",83.5,167,"TPAIADTPA","110692S"]
["Smith/T Sam","Car","Hertz","2000-07-09","2000-07-11",63,126,"ORD","111058S"]
["Smith/T Sam","Car","Hertz","2000-04-06","2000-04-09",41.39,124.17,"ATL","111081S"]
["Smith/T Sam","Car","Hertz","2000-01-28","2000-01-31",38.99,116.98,"ATL","109609S"]
["Smith/T Sam","Hotel","HILTON HOTELS","2000-02-29","2000-03-01",109,109,"DEN","110461S"]
["Smith/T Sam","Car","Hertz","2000-02-29","2000-03-01",64,64,"DEN","110461S"]
["Smith/T Sam","Car","Hertz","2000-03-01","2000-03-01",64,64,"DEN","110388S"]
["Smith/T Sam","Car","Hertz","2000-02-28","2000-03-01",26.54,53.09,"SNA","110388S"]
["Smith/T Sam","Car","Hertz","2000-02-28","2000-02-29",53.09,53.09,"SNA","110461S"]
["Smith/T Sam","TRANS FEE","ARC","2000-01-12",null,10,10,"ARC","109173S"]
["Smith/T Sam","TRANS FEE","ARC","2000-01-26",null,10,10,"ARC","109247S"]
["Smith/T Sam","TRANS FEE","ARC","2000-01-27",null,10,10,"ARC","109609S"]
["Smith/T Sam","TRANS FEE","ARC","2000-02-28",null,10,10,"ARC","110388S"]
["Smith/T Sam","TRANS FEE","ARC","2000-04-06",null,10,10,"ARC","111081S"]
["Smith/T Sam","TRANS FEE","ARC","2000-05-21",null,10,10,"ARC","110445S"]
["Smith/T Sam","TRANS FEE","ARC","2000-06-28",null,10,10,"ARC","110692S"]
["Smith/T Sam","TRANS FEE","ARC","2000-07-09",null,10,10,"ARC","111058S"]
["Smith/T Sam","Dom. Air","United Airlines",null,null,0,0,null,"110461A"]
["Smith/T Sam","Dom. Air","Delta Air Lines","2000-01-27","2000-01-31",-117.5,-470,"TPAATLDTWATLTPA","109292R"]
["Smith/T Sam","Dom. Air","Delta Air Lines","2000-01-12","2000-01-13",-1405,-1405,"TPAATLSNADFWTPA","109173R"]
["Smith/Timothy D","Dom. Air","Continental Airlines","2000-02-10","2000-02-10",97.5,97.5,"TLHTPA","109644S"]
["Smith/Timothy D","TRANS FEE","ARC","2000-02-10",null,10,10,"ARC","109644S"]
["SPEER/STEPHEN","Dom. Air","AirTran Airways, Inc.","2000-02-24",null,403,403,"ATLTPAATL","110184S"]
["Speer/Stephen","Car","Hertz","2000-02-24","2000-02-24",41,41,"TPA","110184S"]
["Speer/Stephen","TRANS FEE","ARC","2000-02-24",null,10,10,"ARC","110184S"]
["Stubbs/Sally","Dom. Air","USAir","2000-02-16","2000-02-16",417.5,417.5,"TPADCA","109986S"]
["Stubbs/Sally","Dom. Air","Continental Airlines","2000-02-17","2000-02-17",415.5,415.5,"DCACLETPA","109987S"]
["Stubbs/Sally","Hotel","XX","2000-02-16","2000-02-17",129,129,"WAS","109986S"]
["Stubbs/Sally","TRANS FEE","ARC","2000-02-16",null,10,10,"ARC","109986S"]
["Towner/Tonya","Dom. Air","Delta Air Lines","2000-05-15","2000-05-19",109.5,438,"TPAATLPHXATLTPA","110153S"]
["Towner/Tonya","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110153S"]
["Van Essen/Delwyn","Dom. Air","United Airlines","2000-01-27","2000-01-30",99.66,299,"DENDTWDEN","109340S"]
["Van Essen/Delwyn","Car","Dollar","2000-01-27","2000-01-30",19.989999999999998,59.97,"DTW","109340S"]
["Van Essen/Delwyn","TRANS FEE","ARC","2000-01-27",null,10,10,"ARC","109340S"]
["Van Essen/Dianne","Dom. Air","United Airlines","2000-01-27","2000-01-30",99.66,299,"DENDTWDEN","109341S"]
["Van Essen/Dianne","TRANS FEE","ARC","2000-01-27",null,10,10,"ARC","109341S"]
["Vanessen/Del","Dom. Air","America West Airlines","2000-05-15","2000-05-19",79.430000000000007,317.72000000000003,"DENPHXDEN","110169S"]
["Vanessen/Del","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110169S"]
["Vanessen/Diane","Dom. Air","America West Airlines","2000-05-15","2000-05-19",79.430000000000007,317.72000000000003,"DENPHXDEN","110170S"]
["Vanessen/Diane","TRANS FEE","ARC","2000-05-15",null,10,10,"ARC","110170S"]
["Weatherby/Charles","Dom. Air","Delta Air Lines","2000-03-20","2000-03-22",391.85,783.7,"TPADFWSJDDFWTPA","110426S"]
["Weatherby/Charles","Dom. Air","Continental Airlines","2000-05-12","2000-05-14",138,276,"TPAIAHOMAIAHTPA","110141S"]
["Weatherby/Charles","TRANS FEE","ARC","2000-03-20",null,10,10,"ARC","110426S"]
["Weatherby/Charles","TRANS FEE","ARC","2000-05-12",null,10,10,"ARC","110141S"]
["Weatherby/Jamie","Dom. Air","America West Airlines","2000-05-14","2000-05-25",37.36,411,"OMAPHXTPA","110094S"]
["Weatherby/Jamie","TRANS FEE","ARC","2000-05-14",null,10,10,"ARC","110094S"]
["Weatherby/Nancy","Dom. Air","Delta Air Lines","2000-03-20","2000-03-22",391.85,783.7,"TPADFWSJDDFWTPA","110429S"]
["Weatherby/Nancy","Dom. Air","America West Airlines","2000-05-14","2000-05-25",37.36,411,"OMAPHXTPA","110151S"]
["Weatherby/Nancy","Dom. Air","Delta Air Lines","2000-01-26","2000-01-28",165.5,331,"TPACVGDTWATLTPA","109493S"]
["Weatherby/Nancy","Dom. Air","Northwest Airlines","2000-01-28","2000-02-02",66.2,331,"DTWTPADTW","109679S"]
["Weatherby/Nancy","Hotel","HYATT REGENCY","2000-03-23","2000-03-25",125,250,"MCO","110325S"]
["Weatherby/Nancy","Dom. Air","Continental Airlines","2000-05-12","2000-05-12",211.5,211.5,"TPAIAHOMA","110150S"]
["Weatherby/Nancy","TRANS FEE","ARC","2000-01-26",null,10,10,"ARC","109493S"]
["Weatherby/Nancy","TRANS FEE","ARC","2000-01-28",null,10,10,"ARC","109679S"]
["Weatherby/Nancy","TRANS FEE","ARC","2000-03-20",null,10,10,"ARC","110429S"]
["Weatherby/Nancy","TRANS FEE","ARC","2000-05-12",null,10,10,"ARC","110150S"]
["Williams/Samantha","Dom. Air","Delta Air Lines","2000-01-10","2000-01-11",280,280,"ATLTPAATL","109203S"]
["Williams/Samantha","TRANS FEE","ARC","2000-01-10",null,10,10,"ARC","109203S"]

{"sheet":"TRUCK STOP","index":58,"n_rows":7,"n_cols":14,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,2,0,11]]}
[null,null,"Time of day"]
[null,null,8,9,10,11,12,1,2,3,4,5,null,"Stopped"]
[null,"Truck 1","A","B","C","D","A","B","C","D","A","A",null,{"$f":"IF(D3<>C3,0,1)+IF(E3<>D3,0,1)+IF(F3<>E3,0,1)+IF(G3<>F3,0,1)+IF(H3<>G3,0,1)+IF(I3<>H3,0,1)+IF(J3<>I3,0,1)+IF(K3<>J3,0,1)+IF(L3<>K3,0,1)","v":1}]
[null,"Truck 2","A","A","A","A","A","C","D","D","B","A",null,{"$f":"IF(D4<>C4,0,1)+IF(E4<>D4,0,1)+IF(F4<>E4,0,1)+IF(G4<>F4,0,1)+IF(H4<>G4,0,1)+IF(I4<>H4,0,1)+IF(J4<>I4,0,1)+IF(K4<>J4,0,1)+IF(L4<>K4,0,1)","v":5}]
[null,"Truck 3","A","A","A","A","A","A","A","A","A","A",null,9]
[null,"Truck 4","A","B","C","B","A","B","C","D","E","A",null,0]
[null,"Truck 5","A","B","C","A","A","A","A","A","A","A",null,6]

{"sheet":"VLOOKUP MATCH","index":59,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Store One"]
["Product ID","January","February","March",null,"Product ID","ALP-715"]
["ALP-701",1861.26,1876,1676.34,null,"Month","January"]
["ALP-702",1398.96,1354.74,1776.84,null,"Sales",{"$f":"VLOOKUP(G2,store1sales,MATCH(G3,store1months,0),0)","v":1737.98}]
["ALP-704",1656.24,1541,1353.4]
["ALP-708",1522.24,1551.72,1947.02]
["ALP-715",1737.98,1428.44,1890.74]
["ALP-790",1444.52,1977.84,1416.38]
["ALP-802",1910.84,1764.78,1827.76]
["ALP-803",1737.98,1392.26,1538.32]
["ALP-811",1573.16,1523.58,1665.62]
["ALP-823",1871.98,1566.46,1511.52]
["ALP-836",1811.68,1488.74,1967.12]

{"sheet":"INDEX MATCH ","index":60,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["First Name","Last Name","Hire Date","SS #","Department","Position","Annual Salary","Perf Rating","Mgmt Level",null,"SS #","First Name","Last Name","Annual Salary"]
["elizabeth","ridenhauer","1997-04-29",459306733,"Corporate Manager","Vice President",65000,5,1,null,611048942,{"$f":"PROPER(INDEX(matchdata,MATCH($K$2,socialsec,0),1))","v":"Will"},{"$f":"PROPER(INDEX(matchdata,MATCH($K2,socialsec,0),2))","v":"Mullen"},{"$f":"INDEX(matchdata,MATCH($K2,socialsec,0),7)","v":53500}]
["elizabeth","ridenhauer","1997-04-29",459306733,"Corporate Manager","Vice President",65000,5,1,null,{"$f":"MATCH($K$2,socialsec,0)","v":10}]
["alice","wortman","1998-04-03",707942310,"Corporate Manager","Marketing Manager",85000,4,2]
["tyrone","anderson","1995-12-02",146902472,"Corporate Staff","Division Manager",42000,3,3]
["stuart","klein","1999-05-28",345005582,"Corporate Staff","Accounting Staff",55000,4,2]
["catherine","forest","2000-06-14",368370245,"Corporate Manager","Director of Advertising",46000,3,2]
["mechell","clese","1995-05-09",456080278,"Corporate Staff","Copy Writer",58000,3,4]
["kate","jones","2000-07-25",481349363,"Corporate Staff","Accounting Staff",45000,2,3]
["ellen","spinnaker","1993-04-07",570286844,"Corporate Staff","Circulation Manager",70000,4,3]
["will","mullen","1999-06-08",611048942,"Corporate Staff","Division Manager",53500,4,3]
["brad","turner","1997-09-17",345035237,"Management Staff","Accounting Staff",65000,3,3]
["mark","macdowell","2000-05-06",820015532,"Management Staff","Web Manager",55000,2,3]
["william","martin","1952-07-01",469440032,"Retail","Product Manager",55500,2,3]
["jim","kirney","1995-10-28",618035383,"Retail","Product Manager",47500,3,3]
["michelle","campbell","1998-05-05",681302482,"Management Staff","Accounting Staff",42000,3,2]
["ty ","simmons","1999-05-14",679694534,"Retail","Product Manager",57500,3,3]
["dennis","denton","1987-07-04",692241314,"Section Manager","Director of Training",45000,4,3]
["michael","gapner","1961-08-20",706670481,"Management Staff","Payroll Manager",48000,3,3]
["eileen","wilson","1995-07-29",682110774,"Retail","Product Manager",48000,4,3]
["george","fernandez","1997-03-30",781041004,"Corporate Manager","Office Manager",48000,5,2]
["james","bruce","2000-05-29",248944357,"Section Manager","Dir. Of Shipping",55000,1,3]
["marcia","smith","1995-01-14",931026545,"Corporate Manager","General Sales Manager",42000,2,2]

{"sheet":"MAIL MERGE","index":61,"n_rows":50,"n_cols":20,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["Company Name","First Name","Last Name","Address","Street Address","City","State","Country","Postal Code","Annual Sales","DOLLAR","LEN","Merge",4,5,6,7,8,9,10]
["Pure Shade","Phil","Birthisel",{"$f":"(E2&\", \"&F2&\", \"&G2)","v":"115 Exbourne Avenue, Sydney, NSW"},"115 Exbourne Avenue","Sydney","NSW","AU",2112,10001,{"$f":"DOLLAR(J2,0)","v":"$10,001"},{"$f":"HLOOKUP(LEN(sales),digits,ROW())","v":"$10,001"},"$10,001",{"$f":"CONCATENATE(\"$\",LEFT(sales,1),\",\",RIGHT(sales,3))","v":"$1,001"},{"$f":"CONCATENATE(\"$\",LEFT(sales,2),\",\",RIGHT(sales,3))","v":"$10,001"},{"$f":"CONCATENATE(\"$\",LEFT(sales,3),\",\",RIGHT(sales,3))","v":"$100,001"},{"$f":"CONCATENATE(\"$\",LEFT(sales,1),\",\",MID(sales,2,3),\",\",RIGHT(sales,3))","v":"$1,000,001"},{"$f":"CONCATENATE(\"$\",LEFT(sales,2),\",\",MID(sales,2,3),\",\",RIGHT(sales,3))","v":"$10,000,001"},{"$f":"CONCATENATE(\"$\",LEFT(sales,3),\",\",MID(sales,2,3),\",\",RIGHT(sales,3))","v":"$100,000,001"},{"$f":"CONCATENATE(\"$\",LEFT(sales,1),\",\",MID(sales,2,3),\",\",MID(sales,5,3),\",\",RIGHT(sales,3))","v":"$1,000,1,001"}]
["Ding Now","Micky","Denig","382293 Spillway Drive, Scranton, PA","382293 Spillway Drive","Scranton","PA","USA",18466,30001,{"$f":"DOLLAR(J3,0)","v":"$30,001"},"$30,001","$30,001","$3,001","$30,001","$300,001","$3,000,001","$30,000,001","$300,000,001","$3,000,1,001"]
["Wait A Minute","Rob","Melick","9033 10th Street, Philadelphia, PA","9033 10th Street","Philadelphia","PA","USA",19128,555000,"$555,000","$555,000","$555,000","$5,000","$55,000","$555,000","$5,550,000","$55,550,000","$555,550,000","$5,550,00,000"]
["Fly's Now","Glynn","Lavendar","1705 Peach Tree Circle, Melbourne, VIC","1705 Peach Tree Circle","Melbourne","VIC","AU",3150,555000,"$555,000","$555,000","$555,000","$5,000","$55,000","$555,000","$5,550,000","$55,550,000","$555,550,000","$5,550,00,000"]
["Penninsula","Julie","Wesolek","4587 Erebe Place, Palo Alto, CA","4587 Erebe Place","Palo Alto","CA","USA",94070,555000,"$555,000","$555,000","$555,000","$5,000","$55,000","$555,000","$5,550,000","$55,550,000","$555,550,000","$5,550,00,000"]
["WHOISDMPY","Steve","Schmoyer","P. O. Box 147, Phoenix, AZ","P. O. Box 147","Phoenix","AZ","USA",85001,555000,"$555,000","$555,000","$555,000","$5,000","$55,000","$555,000","$5,550,000","$55,550,000","$555,550,000","$5,550,00,000"]
["Rooter","Bob","Straus","P. O. Box 1715, Allentown, PA","P. O. Box 1715","Allentown","PA","USA",18103,555000,"$555,000","$555,000","$555,000","$5,000","$55,000","$555,000","$5,550,000","$55,550,000","$555,550,000","$5,550,00,000"]
["Dagwood Sandwiches","Freida","Shisslak","5800 Sly Fox Place, Allentown, PA","5800 Sly Fox Place","Allentown","PA","USA",18103,555000,"$555,000","$555,000","$555,000","$5,000","$55,000","$555,000","$5,550,000","$55,550,000","$555,550,000","$5,550,00,000"]
["AREUFIT","Jane","O'Brien","67 Bouleva Road, Manasass, VA","67 Bouleva Road","Manasass","VA","USA",22112,555000,"$555,000","$555,000","$555,000","$5,000","$55,000","$555,000","$5,550,000","$55,550,000","$555,550,000","$5,550,00,000"]
["The Bone","Joe","Stinner","5417 21st Street, Allentown, PA","5417 21st Street","Allentown","PA","USA",18103,555000,"$555,000","$555,000","$555,000","$5,000","$55,000","$555,000","$5,550,000","$55,550,000","$555,550,000","$5,550,00,000"]
["CarMan, South","Rob","Stineberg","8371 Carpet Road, Woodbridge, VA","8371 Carpet Road","Woodbridge","VA","USA",22194,555000,"$555,000","$555,000","$555,000","$5,000","$55,000","$555,000","$5,550,000","$55,550,000","$555,550,000","$5,550,00,000"]
["Whoppy Looks","Kim","Tenant","3901 Valley Avenue, Detroit, MI","3901 Valley Avenue","Detroit","MI","USA",48219,555000,"$555,000","$555,000","$555,000","$5,000","$55,000","$555,000","$5,550,000","$55,550,000","$555,550,000","$5,550,00,000"]
["L.B.Stop","Karen","Lewis","4232 William Flynn Highway, Allentown, PA","4232 William Flynn Highway","Allentown","PA","USA",18103,3400000,"$3,400,000","$3,400,000","$3,400,000","$3,000","$34,000","$340,000","$3,400,000","$34,400,000","$340,400,000","$3,400,000,000"]
["ASAP","Patrick","Murray","1806 Rudolph Lane, Washington, DC","1806 Rudolph Lane","Washington","DC","USA",20001,3400000,"$3,400,000","$3,400,000","$3,400,000","$3,000","$34,000","$340,000","$3,400,000","$34,400,000","$340,400,000","$3,400,000,000"]
["Little House","Vera","Chandler","27 Blackburn Court, Washington, DC","27 Blackburn Court","Washington","DC","USA",20001,3400000,"$3,400,000","$3,400,000","$3,400,000","$3,000","$34,000","$340,000","$3,400,000","$34,400,000","$340,400,000","$3,400,000,000"]
["Hot Dogs For All","James","Zickafoose","12501 King Street, Allentown, PA","12501 King Street","Allentown","PA","USA",18103,3400000,"$3,400,000","$3,400,000","$3,400,000","$3,000","$34,000","$340,000","$3,400,000","$34,400,000","$340,400,000","$3,400,000,000"]
["Ipkack Today","Gary","Smith","2 Pine Drive, Reading, PA","2 Pine Drive","Reading","PA","USA",19608,3400000,"$3,400,000","$3,400,000","$3,400,000","$3,000","$34,000","$340,000","$3,400,000","$34,400,000","$340,400,000","$3,400,000,000"]
["Macro","Marc","Warren","101 Main Street, Newark, NJ","101 Main Street","Newark","NJ","USA",7101,3400000,"$3,400,000","$3,400,000","$3,400,000","$3,000","$34,000","$340,000","$3,400,000","$34,400,000","$340,400,000","$3,400,000,000"]
["The Law","Charles","Geschickter","Box 2838, Fairfax, VA","Box 2838","Fairfax","VA","USA",20151,3400000,"$3,400,000","$3,400,000","$3,400,000","$3,000","$34,000","$340,000","$3,400,000","$34,400,000","$340,400,000","$3,400,000,000"]
["WebStreet","John","Henderson","1301 New Jersey Avenue, Louisville, KY","1301 New Jersey Avenue","Louisville","KY","USA",40201,3400000,"$3,400,000","$3,400,000","$3,400,000","$3,000","$34,000","$340,000","$3,400,000","$34,400,000","$340,400,000","$3,400,000,000"]
["Jiggle One","Harold","Schappell","3610 Hamilton Street, Reading, PA","3610 Hamilton Street","Reading","PA","USA",19608,10000000,"$10,000,000","$10,000,000","$10,000,000","$1,000","$10,000","$100,000","$1,000,000","$10,000,000","$100,000,000","$1,000,000,000"]
["My WABIYWAB","Jerry","Barber","105 Duane Street, Frederick, MD","105 Duane Street","Frederick","MD","USA",21701,10000000,"$10,000,000","$10,000,000","$10,000,000","$1,000","$10,000","$100,000","$1,000,000","$10,000,000","$100,000,000","$1,000,000,000"]
["Coach Jim, LLC","James","Haines","425 South 15th Street, Allentown, PA","425 South 15th Street","Allentown","PA","USA",18103,10000000,"$10,000,000","$10,000,000","$10,000,000","$1,000","$10,000","$100,000","$1,000,000","$10,000,000","$100,000,000","$1,000,000,000"]
["LBS","Rod","Urand","2426 Vintage Circle, Annapolis, MD","2426 Vintage Circle","Annapolis","MD","USA",21041,10000000,"$10,000,000","$10,000,000","$10,000,000","$1,000","$10,000","$100,000","$1,000,000","$10,000,000","$100,000,000","$1,000,000,000"]
["Town Juice","Clem","West","319 East Street, Allentown, PA","319 East Street","Allentown","PA","USA",18103,10000000,"$10,000,000","$10,000,000","$10,000,000","$1,000","$10,000","$100,000","$1,000,000","$10,000,000","$100,000,000","$1,000,000,000"]
["TexSpeak","Michael","Goforth","1413 NW 63 Road, Dallas, TX","1413 NW 63 Road","Dallas","TX","USA",75010,10000000,"$10,000,000","$10,000,000","$10,000,000","$1,000","$10,000","$100,000","$1,000,000","$10,000,000","$100,000,000","$1,000,000,000"]
["Doug Fresh Inc.","Doug","Busey","908 South Armour Street, Dallas, TX","908 South Armour Street","Dallas","TX","USA",75010,10000000,"$10,000,000","$10,000,000","$10,000,000","$1,000","$10,000","$100,000","$1,000,000","$10,000,000","$100,000,000","$1,000,000,000"]
["YourCoach, LLC","Jackie","Sapp","19231 Sherman Way, #45, Los Angeles, CA","19231 Sherman Way, #45","Los Angeles","CA","USA",91766,10000000,"$10,000,000","$10,000,000","$10,000,000","$1,000","$10,000","$100,000","$1,000,000","$10,000,000","$100,000,000","$1,000,000,000"]
["BuyQick","Brett","Hayes","343 Village Walk Drive, Richmond, VA","343 Village Walk Drive","Richmond","VA","USA",23173,10000000,"$10,000,000","$10,000,000","$10,000,000","$1,000","$10,000","$100,000","$1,000,000","$10,000,000","$100,000,000","$1,000,000,000"]
["Ever Thrifty","Nancy","Strimple","6040 Token Forest Drive, Annapolis, MD","6040 Token Forest Drive","Annapolis","MD","USA",21041,10000000,"$10,000,000","$10,000,000","$10,000,000","$1,000","$10,000","$100,000","$1,000,000","$10,000,000","$100,000,000","$1,000,000,000"]
["Mechanic Man","Joe","Ford","6823 Old Waterloo Road, Denver, CO","6823 Old Waterloo Road","Denver","CO","USA",80002,10000000,"$10,000,000","$10,000,000","$10,000,000","$1,000","$10,000","$100,000","$1,000,000","$10,000,000","$100,000,000","$1,000,000,000"]
["Pool time","Judi","Wagner","Box 420B, Road, Tampa, FL","Box 420B, Road","Tampa","FL","USA",34684,230000000,"$230,000,000","$230,300,000","$230,300,000","$2,000","$23,000","$230,000","$2,300,000","$23,300,000","$230,300,000","$2,300,000,000"]
["End of Chat","Robb","Wilmot","P. O. Box 5355, Annapolis, MD","P. O. Box 5355","Annapolis","MD","USA",21041,230000000,"$230,000,000","$230,300,000","$230,300,000","$2,000","$23,000","$230,000","$2,300,000","$23,300,000","$230,300,000","$2,300,000,000"]
["Cookie Company","Sophie","Altvater","450 North Grove Street, Stroudsburg, PA","450 North Grove Street","Stroudsburg","PA","USA",18301,230000000,"$230,000,000","$230,300,000","$230,300,000","$2,000","$23,000","$230,000","$2,300,000","$23,300,000","$230,300,000","$2,300,000,000"]
["Amazing Grace","Amy","Reinert","3150 West Street, Allentown, PA","3150 West Street","Allentown","PA","USA",18103,230000000,"$230,000,000","$230,300,000","$230,300,000","$2,000","$23,000","$230,000","$2,300,000","$23,300,000","$230,300,000","$2,300,000,000"]
["Little Italy Restaurant","Celeste","Egidio","467 Kenny Drive, Stroudsburg, PA","467 Kenny Drive","Stroudsburg","PA","USA",18301,230000000,"$230,000,000","$230,300,000","$230,300,000","$2,000","$23,000","$230,000","$2,300,000","$23,300,000","$230,300,000","$2,300,000,000"]
["Wiener, Inc.","Chris","Jenkins","4050 Dillingersville Road, Columbia, MD","4050 Dillingersville Road","Columbia","MD","USA",21044,230000000,"$230,000,000","$230,300,000","$230,300,000","$2,000","$23,000","$230,000","$2,300,000","$23,300,000","$230,300,000","$2,300,000,000"]
["Little Marty LLC","Marty","Burke","1030 South 7th Street, Baltimore, MD","1030 South 7th Street","Baltimore","MD","USA",21206,230000000,"$230,000,000","$230,300,000","$230,300,000","$2,000","$23,000","$230,000","$2,300,000","$23,300,000","$230,300,000","$2,300,000,000"]
["TrumpStreet","Dan","Rogers","425 South 15th Street, Baltimore, MD","425 South 15th Street","Baltimore","MD","USA",21206,230000000,"$230,000,000","$230,300,000","$230,300,000","$2,000","$23,000","$230,000","$2,300,000","$23,300,000","$230,300,000","$2,300,000,000"]
["Shrink Time, Inc.","Harold","Pascal","819 Wynonah Drive, Stroudsburg, PA","819 Wynonah Drive","Stroudsburg","PA","USA",18301,230000000,"$230,000,000","$230,300,000","$230,300,000","$2,000","$23,000","$230,000","$2,300,000","$23,300,000","$230,300,000","$2,300,000,000"]
["The Kitchen Lady","Wilma","Bentley","3932 Blacksmith Road, Washington, DC","3932 Blacksmith Road","Washington","DC","USA",20001,230000000,"$230,000,000","$230,300,000","$230,300,000","$2,000","$23,000","$230,000","$2,300,000","$23,300,000","$230,300,000","$2,300,000,000"]
["BigGuys","Dan","Benish","1426 Prince Street, Atlanta, GA","1426 Prince Street","Atlanta","GA","USA",30247,230000000,"$230,000,000","$230,300,000","$230,300,000","$2,000","$23,000","$230,000","$2,300,000","$23,300,000","$230,300,000","$2,300,000,000"]
["Club Run","Catherine","Matthews","634 Buckingham Lane, Melbourne, VIC","634 Buckingham Lane","Melbourne","VIC","AU",3150,230000000,"$230,000,000","$230,300,000","$230,300,000","$2,000","$23,000","$230,000","$2,300,000","$23,300,000","$230,300,000","$2,300,000,000"]
["My Inside Hammer","Becky","Purdin","5866-H Po Street, Annapolis, MD","5866-H Po Street","Annapolis","MD","USA",21041,230000000,"$230,000,000","$230,300,000","$230,300,000","$2,000","$23,000","$230,000","$2,300,000","$23,300,000","$230,300,000","$2,300,000,000"]
["Shipping Plus","Arthur","Henry","6941 Weest Street, Newark, NJ","6941 Weest Street","Newark","NJ","USA",7101,230000000,"$230,000,000","$230,300,000","$230,300,000","$2,000","$23,000","$230,000","$2,300,000","$23,300,000","$230,300,000","$2,300,000,000"]
["Wild Wild Wild Inc.","Lindee","Brauer","2645 Nazareth Road, Denver, CO","2645 Nazareth Road","Denver","CO","USA",80002,230000000,"$230,000,000","$230,300,000","$230,300,000","$2,000","$23,000","$230,000","$2,300,000","$23,300,000","$230,300,000","$2,300,000,000"]
[null,null,null,null,null,null,null,null,null,2300000000,"$2,300,000,000","$2,300,000,000","$230,300,001","$2,000","$23,000","$230,000","$2,300,000","$23,300,000","$230,300,000","$2,300,000,000"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"LEN(J48)","v":10}]