{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["VLOOKUP","HLOOKUP","INDEX"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"VLOOKUP","index":0,"n_rows":22,"n_cols":10,"rows_kept":22,"merged":[[0,0,0,9],[2,1,2,4],[2,6,2,9]]}
["Dunder Mifflin"]
[]
[null,"Outstanding Orders",{"$nulls":4},"Receipt"]
[]
[null,"Client","Order Quantity","Customer Loyalty","Order Date",null,"Client:",null,null,"Order ID:"]
[null,"Landscapers R Us",10,20,"2017-01-15",null,"Bloomington Tutors",null,null,"0000001"]
[null,"Teeth, Teeth, Teeth Dentistry",12,52,"2016-12-30"]
[null,"Schrute Farms",4,12,"2017-01-20",null,"Order Date:"]
[null,"Beauty Supply",6,33,"2017-02-14"]
[null,"Good Guy Hardware",8,110,"2017-02-02"]
[null,"Indiana University",100,340,"2017-01-09"]
[null,"Bloomington Tutors",20,506,"2017-01-30",null,"Products:"]
[null,"Kelley School of Business",40,418,"2017-01-10",null,"Paper Type:","Package Size:","Price:","Quantity:"]
[{"$nulls":6},"Premier","500 Sheets",{"v":18,"d":"$18.00"}]
[]
[]
[]
[{"$nulls":6},"Order Total:"]
[{"$nulls":6},"Subtotal:",{"$f":"I14*J14","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":6},"Tax:",{"$f":"H19*0.07","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":6},"Discount:",{"v":0.3,"d":"30.00%"}]
[{"$nulls":6},"Order Total:",{"$f":"H19-(H19*H21)+H20","v":{"v":0,"d":"$0.00"}}]

{"sheet":"HLOOKUP","index":1,"n_rows":22,"n_cols":14,"rows_kept":22,"merged":[[0,0,0,13],[2,2,2,7],[2,10,2,13],[4,1,6,1]]}
["Dunder Mifflin"]
[]
[null,null,"Customer Loyalty",{"$nulls":7},"Receipt"]
[]
[null,"Customer Loyalty",0,11,31,51,100,200,500,null,"Client:",null,null,"Order ID:"]
[null,null,"-","-","-","-","-","-","+",null,"Bloomington Tutors",null,null,"0000001"]
[null,null,10,30,50,100,200,500]
[null,"Discount",{"v":0,"d":"0.00%"},{"v":0.05,"d":"5.00%"},{"v":0.1,"d":"10.00%"},{"v":0.15,"d":"15.00%"},{"v":0.2,"d":"20.00%"},{"v":0.25,"d":"25.00%"},{"v":0.3,"d":"30.00%"},null,"Order Date:"]
[{"$nulls":10},"2017-01-30"]
[]
[]
[{"$nulls":10},"Products:"]
[{"$nulls":10},"Paper Type:","Package Size:","Price:","Quantity:"]
[{"$nulls":10},"Premier","500 Sheets",{"v":18,"d":"$18.00"},20]
[]
[]
[]
[{"$nulls":10},"Order Total:"]
[{"$nulls":10},"Subtotal:",{"$f":"M14*N14","v":{"v":360,"d":"$360.00"}}]
[{"$nulls":10},"Tax:",{"$f":"L19*0.07","v":{"v":25.200000000000003,"d":"$25.20"}}]
[{"$nulls":10},"Discount:"]
[{"$nulls":10},"Order Total:",{"$f":"L19-(L19*L21)+L20","v":{"v":385.2,"d":"$385.20"}}]

{"sheet":"INDEX","index":2,"n_rows":22,"n_cols":12,"rows_kept":22,"merged":[[0,0,0,11],[2,1,2,6],[2,8,2,11],[4,1,4,6],[5,1,15,1]]}
["Dunder Mifflin"]
[]
[null,"Prices",{"$nulls":6},"Receipt"]
[]
[null,"Type of Paper",{"$nulls":6},"Client:",null,null,"Order ID:"]
[null,"Package Size",null,"Normal","Glossy","Cardstock","Premier",null,"Bloomington Tutors",null,null,"0000001"]
[null,null,"100 Sheets",{"v":5,"d":"$5.00"},{"v":6.5,"d":"$6.50"},{"v":8,"d":"$8.00"},{"v":10,"d":"$10.00"}]
[null,null,"200 Sheets",{"v":7,"d":"$7.00"},{"v":8.5,"d":"$8.50"},{"v":10,"d":"$10.00"},{"v":12,"d":"$12.00"},null,"Order Date:"]
[null,null,"300 Sheets",{"v":8.5,"d":"$8.50"},{"v":10.5,"d":"$10.50"},{"v":12,"d":"$12.00"},{"v":14,"d":"$14.00"},null,"2017-01-30"]
[null,null,"400 Sheets",{"v":10,"d":"$10.00"},{"v":12,"d":"$12.00"},{"v":13.5,"d":"$13.50"},{"v":16,"d":"$16.00"}]
[null,null,"500 Sheets",{"v":11.5,"d":"$11.50"},{"v":13.5,"d":"$13.50"},{"v":15,"d":"$15.00"},{"v":18,"d":"$18.00"}]
[null,null,"600 Sheets",{"v":13,"d":"$13.00"},{"v":15,"d":"$15.00"},{"v":16.5,"d":"$16.50"},{"v":20,"d":"$20.00"},null,"Products:"]
[null,null,"700 Sheets",{"v":14.5,"d":"$14.50"},{"v":16.5,"d":"$16.50"},{"v":18,"d":"$18.00"},{"v":22,"d":"$22.00"},null,"Paper Type:","Package Size:","Price:","Quantity:"]
[null,null,"800 Sheets",{"v":16,"d":"$16.00"},{"v":18,"d":"$18.00"},{"v":19.5,"d":"$19.50"},{"v":24,"d":"$24.00"},null,"Premier","500 Sheets",null,20]
[null,null,"900 Sheets",{"v":17,"d":"$17.00"},{"v":19,"d":"$19.00"},{"v":20.5,"d":"$20.50"},{"v":26,"d":"$26.00"}]
[null,null,"1000 Sheets",{"v":17.5,"d":"$17.50"},{"v":19.5,"d":"$19.50"},{"v":21,"d":"$21.00"},{"v":28,"d":"$28.00"}]
[]
[{"$nulls":8},"Order Total:"]
[{"$nulls":8},"Subtotal:",{"$f":"K14*L14","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":8},"Tax:",{"$f":"J19*0.07","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":8},"Discount:",{"v":0.3,"d":"30.00%"}]
[{"$nulls":8},"Order Total:",{"$f":"J19-(J19*J21)+J20","v":{"v":0,"d":"$0.00"}}]