{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["POS","Items","Sales"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"POS","index":0,"n_rows":10,"n_cols":19,"rows_kept":10,"cut":false,"hidden":false,"merged":[[4,12,4,13],[0,2,0,9],[2,4,2,5],[3,3,3,5],[9,4,9,5],[0,10,0,13],[3,10,3,13],[2,10,2,13],[1,10,1,13],[6,12,6,13],[5,12,5,13]]}
[null,null,"POINT OF SALE",null,null,null,null,null,null,null,"Sales Receipt"]
[null,null,null,null,null,null,null,null,null,null,"سلة تسوق "]
[null,null,null,"Item Name",null,null,null,"Subtotal:",{"$f":"SUMIF(K10:K999,\"<>\",N10:N999)","v":0},null,"المدينة المنورة سوق الدخيل ",null,null,null,null,null,"Subtotal:",{"$f":"I3","v":0}]
["Item Load",false,null,{"$f":"IFERROR(INDEX(Item_Desc,MATCH(E3,Item_Name,0),1),\"\")","v":""},null,null,null,"Tax:",{"$f":"I3*15%","v":0},null,null,null,null,null,null,null,"Tax:",{"$f":"I4","v":0}]
["Item Row",{"$f":"IFERROR(MATCH(E10,Item_ID,0)+2,\"\")","v":""},null,null,null,null,null,"Total:",{"$f":"SUM(I3:I4)","v":0},null,null,"Receipt #:",1007,null,null,null,"Total:",{"$f":"I5","v":0}]
["Rcpt Row",null,null,null,"Price:",null,null,"Pay Type:","Cash",null,null,"Date:",{"$f":"NOW()","v":"2020-08-04T11:25:32.560"},null,null,null,"Paid Amount:",20,100]
["Next Rcpt #",{"$f":"IFERROR(MAX(RecNumb)+1,1000)","v":1000},null,null,null,null,null,"Payment:",null,null,null,"Cashier:","سيف عبدالرحمن",null,null,null,"Change:",{"$f":"I8","v":0}]
[null,null,null,null,"Quantity:",null,null,"Change:",{"$f":"I7-I5","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Item","Qty","Price","Total"]
[null,null,null,"Scan Item:"]

{"sheet":"Items","index":1,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Items"]
["Item ID","Item Name","Item Description","Price","Image"]
[1001,"Apple","Granny Smiths from Yakima, WA",2.99]
[1002,"Banana","Bananas from Ecuador",0.99]
[1003,"Cherry","Bings from Columbia Gorge, OR",5.99]
[1004,"Grapes","Grapes from Coachella Valley, CA",1.95]
[1005,"Orange","Navals from Santa Paula, CA",3.49]
[1006,"Peach","Clings from San Joaquin Valley, CA",1.99]
[1007,"Plum","Plums from El Dorado, CA",3.99]
[1008,"Raspberry","Raspberries from Woodland, WA",4.95]
[1009,"Strawberry","Hand picked from Santa Maria, CA",4.95]
[1010,"Raisins","California Raisins",4.45]

{"sheet":"Sales","index":2,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["Sales History"]
["Rec. #","Date","Cashier","Item","Qty","Price","Total"]