{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["قاعدة بيانات","مقدمة","يناير","فبراير","مارس","ابريل","مايو","يونية","يولية","فواتير يولية","تقرير7","اجمالى الشهور","اجمالى كميات"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":19,"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":"قاعدة بيانات","index":0,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,"شهر مايو","شهر يونية","شهر يولية ","شهر اغسطس","شهر سبتمبر","العميل","المواد"]
[null,null,null,"2020-05-01","2020-06-01","2020-07-01","2020-08-01","2020-09-01","مصنع العسيرى","خرسانة 3/4"]
[null,null,null,"2020-05-02","2020-06-02","2020-07-02","2020-08-02","2020-09-02","نقدى","خرسانة 3/8"]
[null,null,null,"2020-05-03","2020-06-03","2020-07-03","2020-08-03","2020-09-03","ظافر","تراب ناعم"]
[null,null,null,"2020-05-04","2020-06-04","2020-07-04","2020-08-04","2020-09-04","مؤسسة عبد الله راشد الاسمري","بودرة"]
[null,null,null,"2020-05-05","2020-06-05","2020-07-05","2020-08-05","2020-09-05","عثمان"]
[null,null,null,"2020-05-06","2020-06-06","2020-07-06","2020-08-06","2020-09-06","محمد نعيم "]
[null,null,null,"2020-05-07","2020-06-07","2020-07-07","2020-08-07","2020-09-07","محمد نزير"]
[null,null,null,"2020-05-08","2020-06-08","2020-07-08","2020-08-08","2020-09-08","عابد الله"]
[null,null,null,"2020-05-09","2020-06-09","2020-07-09","2020-08-09","2020-09-09","محمد اشرف عبد الغاني"]
[null,null,null,"2020-05-10","2020-06-10","2020-07-10","2020-08-10","2020-09-10","محمد اكرم محمد شريف"]
[null,null,null,"2020-05-11","2020-06-11","2020-07-11","2020-08-11","2020-09-11","مؤسسة بن دروم "]
[null,null,null,"2020-05-12","2020-06-12","2020-07-12","2020-08-12","2020-09-12"]
[null,null,null,"2020-05-13","2020-06-13","2020-07-13","2020-08-13","2020-09-13"]
[null,null,null,"2020-05-14","2020-06-14","2020-07-14","2020-08-14","2020-09-14"]
[null,null,null,"2020-05-15","2020-06-15","2020-07-15","2020-08-15","2020-09-15"]
[null,null,null,"2020-05-16","2020-06-16","2020-07-16","2020-08-16","2020-09-16"]
[null,null,null,"2020-05-17","2020-06-17","2020-07-17","2020-08-17","2020-09-17"]
[null,null,null,"2020-05-18","2020-06-18","2020-07-18","2020-08-18","2020-09-18"]
[null,null,null,"2020-05-19","2020-06-19","2020-07-19","2020-08-19","2020-09-19"]
[null,null,null,"2020-05-20","2020-06-20","2020-07-20","2020-08-20","2020-09-20"]
[null,null,null,"2020-05-21","2020-06-21","2020-07-21","2020-08-21","2020-09-21"]
[null,null,null,"2020-05-22","2020-06-22","2020-07-22","2020-08-22","2020-09-22"]
[null,null,null,"2020-05-23","2020-06-23","2020-07-23","2020-08-23","2020-09-23"]
[null,null,null,"2020-05-24","2020-06-24","2020-07-24","2020-08-24","2020-09-24"]
[null,null,null,"2020-05-25","2020-06-25","2020-07-25","2020-08-25","2020-09-25"]
[null,null,null,"2020-05-26","2020-06-26","2020-07-26","2020-08-26","2020-09-26"]
[null,null,null,"2020-05-27","2020-06-27","2020-07-27","2020-08-27","2020-09-27"]
[null,null,null,"2020-05-28","2020-06-28","2020-07-28","2020-08-28","2020-09-28"]
[null,null,null,"2020-05-29","2020-06-29","2020-07-29","2020-08-29","2020-09-29"]
[null,null,null,"2020-05-30","2020-06-30","2020-07-30","2020-08-30","2020-09-30"]
[null,null,null,"2020-05-31",null,"2020-07-31","2020-08-31"]

{"sheet":"مقدمة","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"يناير","index":2,"n_rows":320,"n_cols":25,"rows_kept":320,"cut":false,"hidden":false,"merged":[[14,19,14,21],[0,0,0,7],[1,9,1,17],[1,19,1,21],[1,22,1,24],[3,23,12,23]]}
["تقرير مبيعات كسارة يناير 2020"]
["S.N","DATE","NUMBER","العميل","نوع المواد","QUANTITY","PRICE","AMOUNT",null,"بيان بقيمة الخرسانة المحملة علي شركة القلابات عن شهر ديسمبر 2019م ",null,null,null,null,null,null,null,null,null,"اجمالى المبييعات",null,null,{"$f":"H292","v":51030}]
["A-1","2020-01-01",8253,"نقدي","خرسانة 3/4",8,{"$f":"IFERROR(H3/F3,\"-\")","v":25},200,null,"الإجمالي ","واسيم  - شركة القلابات","حسين  - شركة القلابات","نعيم - شركة القلابات","اكرام - شركة القلابات","ناصر - شركة القلابات","العمري - شركة القلابات","مقصود - شركة القلابات","نزير - شركة القلابات",null,"مسلسل","التاريخ","رقم المستند","ايداع","الرصيد المتبقى","ملاحظات"]
["A-2","2020-01-01",8254,"واسيم  - شركة القلابات","خرسانة 3/4",16,25,400,null,{"$f":"SUM(K4:R4)","v":12195},{"$f":"SUMIF(D3:D290,K3:R3,H3:H290)","v":900},{"$f":"SUMIF(D3:D290,K3:R3,H3:H290)","v":0},{"$f":"SUMIF(D3:D290,K3:R3,H3:H290)","v":2810},{"$f":"SUMIF(D3:D290,K3:R3,H3:H290)","v":1320},{"$f":"SUMIF(D3:D290,K3:R3,H3:H290)","v":4210},{"$f":"SUMIF(D3:D290,K3:R3,H3:H290)","v":0},{"$f":"SUMIF(D3:D290,K3:R3,H3:H290)","v":50},{"$f":"SUMIF(D3:D290,K3:R3,H3:H290)","v":2905},null,null,"2020-01-07",null,5000,{"$f":"W2-W15","v":880},"ايداع في حساب الشركة "]
["A-3","2020-01-01",8255,"نقدي","خرسانة 3/4",8,25,200,null,null,null,null,null,null,null,null,null,null,null,null,"2020-01-09",null,5000]
["A-4","2020-01-01",8256,"نقدي","خرسانة 3/4",16,24.375,390,null,null,null,null,null,null,null,null,null,null,null,null,"2020-01-14",null,4000]
["A-5","2020-01-01",8257,"نقدي","خرسانة 3/4",8,25,200,null,null,null,null,null,null,null,null,null,null,null,null,"2020-01-16",null,5500]
["A-6","2020-01-01",8258,"نقدي","خرسانة 3/4",8,25,200,null,null,null,null,null,null,null,null,null,null,null,null,"2020-01-20",null,3000]
["A-7","2020-01-02",8259,"نقدي","خرسانة 3/4",16,25,400,null,null,null,null,null,null,null,null,null,null,null,null,"2020-01-21",null,3000]
["A-8","2020-01-02",8260,"نقدي","خرسانة 3/4",16,25,400,null,null,null,null,null,null,null,null,null,null,null,null,"26/1/2020",null,7863]
["A-9","2020-01-02",8261,"واسيم  - شركة القلابات","خرسانة 3/4",16,25,400,null,null,null,null,null,null,null,null,null,null,null,null,"23/1/2020",null,7127]
["A-10","2020-01-02",8262,"نقدي","خرسانة 3/4",16,25,400,null,null,null,null,null,null,null,null,null,null,null,null,"29/1/2020",null,4645]
["A-11","2020-01-02",8263,"نقدي","خرسانة 3/4",16,25,400,null,null,null,null,null,null,null,null,null,null,null,null,"30/1/2019",null,1875]
["A-12","2020-01-02",8264,"نقدي","خرسانة 3/8",16,24.375,390,null,null,null,null,null,null,null,null,null,null,null,null,"30/1/2020",null,3140]
["A-13","2020-01-02",8265,"نقدي","تراب ناعم",48,3.125,150,null,null,null,null,null,null,null,null,null,null,null,"اجمالى الايداعات",null,null,{"$f":"SUM(W4:W14)","v":50150}]
["A-14","2020-01-02",8266,"نقدي","خرسانة 3/4",16,25,400]
["A-15","2020-01-02",8267,"نقدي","خرسانة 3/4",16,24.375,390]
["A-16","2020-01-02",8268,"نقدي","خرسانة 3/4",16,25,400]
["A-17","2020-01-04",8269,"نقدي","خرسانة 3/4",16,24.375,390]
["A-18","2020-01-04",8270,"نقدي","خرسانة 3/4",16,24.375,390]
["A-19","2020-01-04",8271,"نقدي","خرسانة 3/4",16,24.375,390]
["A-20","2020-01-04",8272,"نقدي","خرسانة 3/4",16,24.375,390]
["A-21","2020-01-04",8273,"ظافر النماص","خرسانة 3/4",16,25,400]
["A-22","2020-01-04",8274,"نقدي","خرسانة 3/4",16,25,400]
["A-23","2020-01-04",8275,"نقدي","خرسانة 3/8",16,25,400]
["A-24","2020-01-04",8276,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-25","2020-01-04",8277,"ظافر النماص","خرسانة 3/4",16,25,400]
["A-26","2020-01-04",8278,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-27","2020-01-04",8279,"نقدي","خرسانة 3/4",16,25,400]
["A-28","2020-01-04",8280,"نقدي","خرسانة 3/4",16,25,400]
["A-29","2020-01-04",8281,"نزير - شركة القلابات","خرسانة 3/4",16,25,400]
["A-30","2020-01-04",8282,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-31","2020-01-04",8283,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-32","2020-01-05",8284,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-33","2020-01-05",8285,"نقدي","خرسانة 3/4",8,25,200]
["A-34","2020-01-05",8286,"نقدي","خرسانة 3/8",16,24.375,390]
["A-35","2020-01-05",8287,"نقدي","خرسانة 3/8",16,24.375,390]
["A-36","2020-01-05",8288,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-37","2020-01-05",8289,"ظافر النماص","خرسانة 3/4",16,25,400]
["A-38","2020-01-05",8290,"نقدي","خرسانة 3/4",16,25,400]
["A-39","2020-01-05",8291,"نقدي","خرسانة 3/4",8,25,200]
["A-40","2020-01-05",8292,"نقدي","خرسانة 3/4",8,25,200]
["A-41","2020-01-05",8293,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-42","2020-01-05",8294,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-43","2020-01-05",8295,"نقدي","خرسانة 3/4",8,25,200]
["A-44","2020-01-05",8296,"ناصر - شركة القلابات","خرسانة 3/4",16,25,400]
["A-45","2020-01-05",8297,"ناصر - شركة القلابات","خرسانة 3/4",16,25,400]
["A-46","2020-01-05",8298,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-47","2020-01-05",8299,"نقدي","خرسانة 3/4",16,25,400]
["A-48","2020-01-05",8300,"نقدي","خرسانة 3/8",16,24.375,390]
["A-49","2020-01-06",8301,"نقدي","خرسانة 3/4",8,25,200]
["A-50","2020-01-06",8302,"نقدي","خرسانة 3/4",8,25,200]
["A-51","2020-01-06",8303,"نقدي","خرسانة 3/4",8,25,200]
["A-52","2020-01-06",8304,"ظافر النماص","خرسانة 3/4",16,25,400]
["A-53","2020-01-06",8305,"نقدي","خرسانة 3/4",16,24.375,390]
["A-54","2020-01-06",8306,"نقدي","خرسانة 3/4",16,24.375,390]
["A-55","2020-01-06",8307,"نقدي","خرسانة 3/4",8,25,200]
["A-56","2020-01-06",8308,"نزير - شركة القلابات","خرسانة 3/4",16,25,400]
["A-57","2020-01-07",8309,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-58","2020-01-07",8310,"نقدي","خرسانة 3/4",8,25,200]
["A-59","2020-01-07",8311,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-60","2020-01-07",8312,"نعيم - شركة القلابات","تراب ناعم",16,3.125,50]
["A-61","2020-01-07",8313,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-62","2020-01-07",8314,"نقدي","خرسانة 3/4",8,25,200]
["A-63","2020-01-07",8315,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-64","2020-01-07",8316,"نقدي","خرسانة 3/4",16,24.375,390]
["A-65","2020-01-07",8317,"نقدي","خرسانة 3/4",16,{"$f":"IFERROR(H67/F67,\"-\")","v":24.375},390]
["A-66","2020-01-07",8318,"ناصر - شركة القلابات","خرسانة 3/4",16,25,400]
["A-67","2020-01-07",8319,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-68","2020-01-07",8320,"نقدي","خرسانة 3/4",16,25,400]
["A-69","2020-01-07",8321,"نقدي","خرسانة 3/4",16,25,400]
["A-70","2020-01-07",8322,"نعيم - شركة القلابات","خرسانة 3/4",16,25,400]
["A-71","2020-01-08",8323,"نقدي","خرسانة 3/4",8,25,200]
["A-72","2020-01-08",8324,"ناصر - شركة القلابات","خرسانة 3/4",16,25,400]
["A-73","2020-01-08",8325,"نقدي","خرسانة 3/4",16,25,400]
["A-74","2020-01-08",8326,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-75","2020-01-08",8327,"نقدي","تراب ناعم",16,3.125,50]
["A-76","2020-01-08",8328,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-77","2020-01-08",8329,"ظافر النماص","خرسانة 3/4",16,25,400]
["A-78","2020-01-08",8330,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-79","2020-01-08",8331,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-80","2020-01-08",8332,"راشد الاسمري - ايجار معدات","خرسانة 3/8",16,25,400]
["A-81","2020-01-08",8333,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-82","2020-01-08",8334,"نقدي","خرسانة 3/8",8,25,200]
["A-83","2020-01-08",8335,"نقدي","خرسانة 3/8",16,24.375,390]
["A-84","2020-01-08",8336,"نقدي","خرسانة 3/8",8,25,200]
["A-85","2020-01-08",8337,"نقدي","خرسانة 3/8",8,25,200]
["A-86","2020-01-08",8338,"عالم الاعمار - عميل نقدي","خرسانة 3/8",16,25,400]
["A-87","2020-01-09",8339,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-88","2020-01-09",8340,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-89","2020-01-09",8341,"نقدي","خرسانة 3/4",8,25,200]
["A-90","2020-01-09",8342,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-91","2020-01-09",8343,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-92","2020-01-09",8344,"نقدي","خرسانة 3/4",8,25,200]
["A-93","2020-01-09",8345,"واسيم  - شركة القلابات","تراب ناعم",16,3.125,50]
["A-94","2020-01-09",8346,"عالم الاعمار - عميل نقدي","خرسانة 3/4",16,25,400]
["A-95","2020-01-09",8347,"عالم الاعمار - عميل نقدي","خرسانة 3/4",16,25,400]
["A-96","2020-01-09",8348,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-97","2020-01-09",8349,"نزير - شركة القلابات","خرسانة 3/4",16,25,400]
["A-98","2020-01-09",8350,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-99","2020-01-09",8351,"نقدي","خرسانة 3/4",8,25,200]
["A-100","2020-01-11",8352,"نقدي","خرسانة 3/4",8,25,200]
["A-101","2020-01-11",8353,"ناصر - شركة القلابات","خرسانة 3/4",16,25,400]
["A-102","2020-01-11",8354,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-103","2020-01-11",8355,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-104","2020-01-11",8356,"نزير - شركة القلابات","تراب ناعم",8,3.125,25]
["A-105","2020-01-11",8357,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-106","2020-01-11",8358,"نقدي","خرسانة 3/8",24,25,600]
["A-107","2020-01-11",8359,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-108","2020-01-11",8360,"نقدي","خرسانة 3/8",24,25,600]
["A-109","2020-01-11",8361,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-110","2020-01-11",8362,"نقدي","خرسانة 3/8",8,25,200]
["A-99","2020-01-12",8363,"نقدي","خرسانة 3/4",8,25,200]
["A-100","2020-01-12",8364,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-101","2020-01-12",8365,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-102","2020-01-12",8366,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-103","2020-01-12",8367,"نقدي","خرسانة 3/8",16,24.375,390]
["A-104","2020-01-12",8368,"نزير - شركة القلابات","خرسانة 3/4",16,25,400]
["A-105","2020-01-12",8369,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-106","2020-01-12",8370,"نقدي","خرسانة 3/4",16,25,400]
["A-107","2020-01-12",8371,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-108","2020-01-12",8372,"نقدي","خرسانة 3/8",16,24.375,390]
["A-109","2020-01-13",8373,"نقدي","خرسانة 3/4",16,25,400]
["A-110","2020-01-13",8374,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-111","2020-01-13",8375,"نقدي","خرسانة 3/4",16,25,400]
["A-112","2020-01-13",8376,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-113","2020-01-13",8377,"نقدي","خرسانة 3/8",24,25,600]
["A-114","2020-01-13",8378,"نقدي","خرسانة 3/4",16,25,400]
["A-115","2020-01-13",8379,"نقدي","خرسانة 3/4",16,25,400]
["A-116","2020-01-13",8380,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-117","2020-01-13",8381,"نقدي","خرسانة 3/4",16,{"$f":"IFERROR(H131/F131,\"-\")","v":25},400]
["A-118","2020-01-13",8382,"نقدي","خرسانة 3/8",16,24.375,390]
["A-119","2020-01-13",8383,"نقدي","خرسانة 3/8",16,24.375,390]
["A-120","2020-01-13",8384,"نقدي","خرسانة 3/8",24,25,600]
["A-121","2020-01-13",8385,"نقدي","خرسانة 3/4",16,25,400]
["A-122","2020-01-13",8386,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-123","2020-01-13",8387,"نقدي","خرسانة 3/4",16,25,400]
["A-124","2020-01-13",8388,"نقدي","خرسانة 3/4",16,24.375,390]
["A-125","2020-01-13",8389,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-126","2020-01-13",8390,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-127","2020-01-14",8391,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-128","2020-01-14",8392,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-129","2020-01-14",8393,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-130","2020-01-14",8394,"نقدي","خرسانة 3/4",16,24.375,390]
["A-131","2020-01-14",8395,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-132","2020-01-14",8396,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-133","2020-01-14",8397,"نقدي","خرسانة 3/4",4,25,100]
["A-134","2020-01-14",8398,"نقدي","خرسانة 3/4",16,25,400]
["A-135","2020-01-15",8399,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-136","2020-01-15",8400,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-137","2020-01-15",8401,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-138","2020-01-15",8402,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-139","2020-01-15",8403,"نقدي","خرسانة 3/4",8,25,200]
["A-140","2020-01-15",8404,"نقدي","خرسانة 3/4",8,25,200]
["A-141","2020-01-15",8405,"نقدي","خرسانة 3/8",16,24.375,390]
["A-142","2020-01-15",8406,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-143","2020-01-16",8407,"نقدي","خرسانة 3/4",16,25,400]
["A-144","2020-01-16",8408,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-145","2020-01-16",8409,"نقدي","خرسانة 3/8",8,25,200]
["A-146","2020-01-16",8410,"نقدي","خرسانة 3/8",8,25,200]
["A-147","2020-01-16",8411,"ناصر - شركة القلابات","تراب ناعم",24,3.3333333333333335,80]
["A-148","2020-01-16",8412,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-149","2020-01-16",8413,"نقدي","تراب ناعم",16,3.125,50]
["A-150","2020-01-16",8414,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-151","2020-01-16",8415,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-152","2020-01-16",8416,"نقدي","خرسانة 3/8",16,24.375,390]
["A-153","2020-01-16",8417,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-154","2020-01-16",8418,"نزير - شركة القلابات","خرسانة 3/4",16,25,400]
["A-155","2020-01-16",8419,"نقدي","خرسانة 3/8",16,24.375,390]
["A-156","2020-01-16",8420,"ناصر - شركة القلابات","تراب ناعم",24,3.3333333333333335,80]
["A-157","2020-01-16",8421,"نقدي","خرسانة 3/4",8,25,200]
["A-158","18/1/2020",8422,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-159","18/1/2020",8423,"واسيم  - شركة القلابات","تراب ناعم",16,3.125,50]
["A-160","18/1/2020",8424,"ناصر - شركة القلابات","تراب ناعم",48,3.3333333333333335,160]
["A-161","18/1/2020",8425,"نقدي","خرسانة 3/4",8,25,200]
["A-162","18/1/2020",8426,"نعيم - شركة القلابات","خرسانة 3/4",8,25,200]
["A-163","18/1/2020",8427,"نقدي","خرسانة 3/8",16,24.375,390]
["A-164","18/1/2020",8428,"نقدي","خرسانة 3/8",16,24.375,390]
["A-165","18/1/2020",8429,"مقصود - شركة القلابات","تراب ناعم",16,3.125,50]
["A-166","19/1/2020",8430,"نقدي","خرسانة 3/4",16,24.375,390]
["A-167","19/1/2020",8431,"نقدي","خرسانة 3/4",16,24.375,390]
["A-168","19/1/2020",8432,"نقدي","خرسانة 3/4",16,24.375,390]
["A-169","19/1/2020",8433,"نقدي","خرسانة 3/4",16,24.375,390]
["A-170","19/1/2020",8434,"نقدي","خرسانة 3/4",16,24.375,390]
["A-171","19/1/2020",8435,"نقدي","خرسانة 3/4",16,24.375,390]
["A-172","19/1/2020",8436,"نقدي","خرسانة 3/4",16,25,400]
["A-173","19/1/2020",8437,"ناصر - شركة القلابات","خرسانة 3/4",24,25,600]
["A-174","19/1/2020",8438,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-175","19/1/2020",8439,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-176","19/1/2020",8440,"نقدي","خرسانة 3/4",16,24.375,390]
["A-177","19/1/2020",8441,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-178","19/1/2020",8442,"نقدي","خرسانة 3/4",16,25,400]
["A-179","19/1/2020",8443,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-180","20/1/2020",8444,"نعيم - شركة القلابات","خرسانة 3/8",16,25,400]
["A-181","20/1/2020",8445,"نقدي","خرسانة 3/4",8,{"$f":"IFERROR(H195/F195,\"-\")","v":25},200]
["A-182","20/1/2020",8446,"نقدي","خرسانة 3/4",16,24.375,390]
["A-183","21/1/2020",8447,"نقدي","خرسانة 3/4",16,24.375,390]
["A-184","21/1/2020",8448,"نقدي","خرسانة 3/8",16,24.375,390]
["A-185","21/1/2020",8449,"نقدي","خرسانة 3/4",8,25,200]
["A-186","21/1/2020",8450,"نقدي","خرسانة 3/4",16,24.375,390]
["A-187","21/1/2020",8451,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-188","21/1/2020",8452,"نقدي","خرسانة 3/4",16,24.375,390]
["A-189","21/1/2020",8453,"نقدي","خرسانة 3/8",16,24.375,390]
["A-190","21/1/2020",8454,"نقدي","خرسانة 3/4",8,25,200]
["A-191","21/1/2020",8455,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-192","22/1/2020",8456,"نقدي","خرسانة 3/8",16,24.375,390]
["A-193","22/1/2020",8457,"نقدي","خرسانة 3/4",16,24.375,390]
["A-194","22/1/2020",8458,"نقدي","خرسانة 3/8",16,24.375,390]
["A-195","22/1/2020",8459,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-196","22/1/2020",8460,"ناصر - شركة القلابات","خرسانة 3/4",24,25,600]
["A-197","22/1/2020",8461,"نقدي","تراب ناعم",16,3.125,50]
["A-198","22/1/2020",8462,"اكرام - شركة القلابات","خرسانة 3/4",16,25,400]
["A-199","22/1/2020",8463,"نقدي","خرسانة 3/4",16,24.375,390]
["A-200","22/1/2020",8464,"نقدي","خرسانة 3/8",16,24.375,390]
["A-201","22/1/2020",8465,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-202","23/1/2019",8466,"نقدي","خرسانة 3/8",16,24.375,390]
["A-203","23/1/2019",8467,"نقدي","خرسانة 3/8",16,24.375,390]
["A-204","23/1/2019",8468,"نقدي","خرسانة 3/4",16,24.375,390]
["A-205","23/1/2019",8469,"نقدي","خرسانة 3/4",16,24.375,390]
["A-206","23/1/2019",8470,"نقدي","خرسانة 3/4",16,24.375,390]
["A-207","23/1/2019",8471,"نقدي","خرسانة 3/4",8,25,200]
["A-208","23/1/2019",8472,"نقدي","خرسانة 3/8",16,24.375,390]
["A-209","23/1/2019",8473,"نقدي","خرسانة 3/8",16,24.375,390]
["A-210","23/1/2019",8474,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-211","23/1/2019",8475,"نقدي","خرسانة 3/4",8,25,200]
["A-212","25/1/2020",8476,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-213","25/1/2020",8477,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-214","25/1/2020",8478,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-215","25/1/2020",8479,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-216","25/1/2020",8480,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-217","25/1/2020",8481,"نقدي","خرسانة 3/8",16,27.5,440]
["A-218","25/1/2020",8482,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-219","25/1/2020",8483,"نقدي","خرسانة 3/4",8,30,240]
["A-220","25/1/2020",8484,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-221","25/1/2020",8485,"نقدي","خرسانة 3/4",8,30,240]
["A-222","25/1/2020",8486,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-223","25/1/2020",8487,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-224","25/1/2020",8488,"نقدي","خرسانة 3/4",16,27.5,440]
["A-225","25/1/2020",8489,"نزير - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-226","25/1/2020",8490,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-227","25/1/2020",8491,"نقدي","خرسانة 3/4",8,30,240]
["A-228","26/1/2020",8492,"نزير - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-229","26/1/2020",8493,"نقدي","خرسانة 3/4",16,27.5,440]
["A-230","26/1/2020",8494,"ناصر - شركة القلابات","خرسانة 3/4",26,26.53846153846154,690]
["A-231","27/1/2020",8495,"راشد الاسمري - ايجار معدات","خرسانة 3/4",16,27.5,440]
["A-232","27/1/2020",8496,"نقدي","خرسانة 3/4",16,27.5,440]
["A-233","27/1/2020",8497,"نقدي","خرسانة 3/4",16,27.5,440]
["A-234","27/1/2020",8498,"نقدي","خرسانة 3/4",8,30,240]
["A-235","27/1/2020",8499,"نقدي","خرسانة 3/8",8,30,240]
["A-236","27/1/2020",8500,"نقدي","خرسانة 3/4",16,27.5,440]
["A-237","27/1/2020",8501,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-238","27/1/2020",8502,"راشد الاسمري - ايجار معدات","خرسانة 3/4",16,27.5,440]
["A-239","27/1/2020",8503,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-240","27/1/2020",8504,"اكرام - شركة القلابات","خرسانة 3/4",8,30,240]
["A-241","27/1/2020",8505,"نقدي","تراب ناعم",16,0,0]
["A-242","28/1/2020",8506,"راشد الاسمري - ايجار معدات","خرسانة 3/4",16,27.5,440]
["A-243","28/1/2020",8507,"نقدي","خرسانة 3/4",16,27.5,440]
["A-244","28/1/2020",8508,"نقدي","خرسانة 3/4",16,27.5,440]
["A-245","28/1/2020",8509,"مصنع العسيري","خرسانة 3/4",24,{"$f":"IFERROR(H259/F259,\"-\")","v":22.916666666666668},550]
["A-246","28/1/2020",8510,"راشد الاسمري - ايجار معدات","خرسانة 3/4",16,27.5,440]
["A-247","28/1/2020",8511,"نقدي","خرسانة 3/4",8,30,240]
["A-248","28/1/2020",8512,"نقدي","خرسانة 3/4",16,27.5,440]
["A-249","28/1/2020",8513,"نقدي","خرسانة 3/4",16,27.5,440]
["A-250","28/1/2020",8514,"نقدي","خرسانة 3/4",8,30,240]
["A-251","28/1/2020",8515,"نقدي","خرسانة 3/4",16,27.5,440]
["A-252","29/1/2020",8516,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-253","29/1/2020",8517,"نقدي","تراب ناعم",64,1.5625,100]
["A-254","29/1/2020",8518,"نقدي","خرسانة 3/4",16,27.5,440]
["A-255","29/1/2020",8519,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-256","29/1/2020",8520,"نقدي","خرسانة 3/8",16,27.5,440]
["A-257","29/1/2020",8521,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-258","29/1/2020",8522,"نقدي","خرسانة 3/8",24,26.666666666666668,640]
["A-259","29/1/2020",8523,"اكرام - شركة القلابات","خرسانة 3/4",8,30,240]
["A-260","29/1/2020",8524,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-261","29/1/2020",8525,"نعيم - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-262","29/1/2020",8526,"نعيم - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-263","29/1/2020",8527,"نعيم - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-264","29/1/2020",8528,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-265","29/1/2020",8529,"نقدي","خرسانة 3/4",16,27.5,440]
["A-266","29/1/2020",8530,"نقدي","خرسانة 3/8",24,26.666666666666668,640]
["A-267","29/1/2020",8531,"نقدي","خرسانة 3/8",16,27.5,440]
["A-268","29/1/2020",8532,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-269","30/1/2020",8533,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-270","30/1/2020",8534,"نعيم - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-271","30/1/2020",8535,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-272","30/1/2020",8536,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-273","30/1/2020",8537,"اكرام - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-274","30/1/2020",8538,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-275","30/1/2020",8539,"نقدي","خرسانة 3/4",16,27.5,440]
["A-276","30/1/2020",8540,"نقدي","خرسانة 3/4",16,27.5,440]
[null,"TOTAL",null,null,null,{"$f":"SUBTOTAL(109,F3:F290)","v":5142},null,{"$f":"SUBTOTAL(109,H3:H290)","v":117535}]
[null,null,null,"نقدي",null,{"$f":"SUMIF($D$3:$D$290,D292,$F$3:$F$290)","v":2180},{"$f":"IFERROR(H292/F292,\"-\")","v":23.408256880733944},{"$f":"SUMIF($D$3:$D$290,D292,$H$3:$H$290)","v":51030}]
[null,null,null,"راشد الاسمري - ايجار معدات",null,{"$f":"SUMIF($D$3:$D$290,D293,$F$3:$F$290)","v":80},27,{"$f":"SUMIF($D$3:$D$290,D293,$H$3:$H$290)","v":2160}]
[null,null,null,"حسين  - شركة القلابات",null,0,"-",0]
[null,null,null,"واسيم  - شركة القلابات",null,64,14.0625,900]
[null,null,null,"العمري - شركة القلابات",null,0,"-",0]
[null,null,null,"مقصود - شركة القلابات",null,16,3.125,50]
[null,null,null,"نعيم - شركة القلابات",null,120,23.416666666666668,2810]
[null,null,null,"مصنع العسيري",null,2136,22.916666666666668,48950,{"$f":"H299+1550-53350","v":-2850}]
[null,null,null,"نزير - شركة القلابات",null,120,24.208333333333332,2905]
[null,null,null,"ظافر النماص",null,80,25,2000]
[null,null,null,"اكرام - شركة القلابات",null,48,27.5,1320]
[null,null,null,"عالم الاعمار - عميل نقدي",null,48,25,1200]
[null,null,null,"ناصر - شركة القلابات",null,250,16.84,4210]
["TOTAL",null,null,null,null,{"$f":"SUM(F292:F304)","v":5142},null,{"$f":"SUM(H292:H304)","v":117535}]
[]
[]
[]
[]
[]
[null,null,null,null,null,"الإيرادات","المبيعات"]
[null,null,null,null,null,{"$f":"G312/1.05","v":111938.09523809524},{"$f":"H291","v":117535}]
[]
[]
[null,null,null,null,"نوع المواد","QUANTITY","PRICE","AMOUNT","الإيرادات","VAT"]
[null,null,null,null,"خرسانة 3/4",{"$f":"SUMIF($E$3:$E$290,E316,$F$3:$F$290)","v":2534},{"$f":"IFERROR(H316/F316,\"-\")","v":24.972375690607734},{"$f":"SUMIF($E$3:$E$290,E316,$H$3:$H$290)","v":63280},{"$f":"H316/1.05","v":60266.666666666664},{"$f":"I316*0.05","v":3013.3333333333335}]
[null,null,null,null,"خرسانة 3/8",{"$f":"SUMIF($E$3:$E$290,E317,$F$3:$F$290)","v":2264},{"$f":"IFERROR(H317/F317,\"-\")","v":23.546819787985864},{"$f":"SUMIF($E$3:$E$290,E317,$H$3:$H$290)","v":53310},{"$f":"H317/1.05","v":50771.428571428572},{"$f":"I317*0.05","v":2538.5714285714289}]
[null,null,null,null,"تراب ناعم",{"$f":"SUMIF($E$3:$E$290,E318,$F$3:$F$290)","v":344},{"$f":"IFERROR(H318/F318,\"-\")","v":2.7470930232558142},{"$f":"SUMIF($E$3:$E$290,E318,$H$3:$H$290)","v":945},{"$f":"H318/1.05","v":900},{"$f":"I318*0.05","v":45}]
[null,null,null,null,"بودرة",{"$f":"SUMIF($E$3:$E$290,E319,$F$3:$F$290)","v":0},{"$f":"IFERROR(H319/F319,\"-\")","v":"-"},{"$f":"SUMIF($E$3:$E$290,E319,$H$3:$H$290)","v":0},{"$f":"H319/1.05","v":0},{"$f":"I319*0.05","v":0}]
[null,null,null,null,"اجمالى",{"$f":"SUM(F316:F319)","v":5142},null,{"$f":"SUM(H316:H319)","v":117535},{"$f":"SUM(I316:I319)","v":111938.09523809524},{"$f":"SUM(J316:J319)","v":5596.9047619047624}]

{"sheet":"فبراير","index":3,"n_rows":257,"n_cols":25,"rows_kept":257,"cut":false,"hidden":false,"merged":[[13,19,13,21],[0,0,0,7],[1,9,1,17],[1,19,1,21],[1,22,1,24],[3,23,11,23]]}
["تقرير مبيعات كسارة فبراير 2020"]
["S.N","DATE","NUMBER","العميل","نوع المواد","QUANTITY","PRICE","AMOUNT",null,"بيان بقيمة الخرسانة المحملة علي شركة القلابات عن شهر ديسمبر 2019م ",null,null,null,null,null,null,null,null,null,"اجمالى المبييعات",null,null,{"$f":"H227","v":41430}]
["A-1","2020-01-02",8541,"مصنع العسيري","خرسانة 3/4",24,{"$f":"IFERROR(H3/F3,\"-\")","v":22.916666666666668},550,null,"الإجمالي ","واسيم  - شركة القلابات","حسين  - شركة القلابات","نعيم - شركة القلابات","اكرام - شركة القلابات","ناصر - شركة القلابات","العمري - شركة القلابات","مقصود - شركة القلابات","نزير - شركة القلابات",null,"مسلسل","التاريخ","رقم المستند","ايداع","الرصيد المتبقى","ملاحظات"]
["A-2","2020-01-02",8542,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550,null,{"$f":"SUM(K4:R4)","v":11980},{"$f":"SUMIF(D3:D225,K3:R3,H3:H225)","v":490},{"$f":"SUMIF(D3:D225,K3:R3,H3:H225)","v":0},{"$f":"SUMIF(D3:D225,K3:R3,H3:H225)","v":3080},{"$f":"SUMIF(D3:D225,K3:R3,H3:H225)","v":2640},{"$f":"SUMIF(D3:D225,K3:R3,H3:H225)","v":2200},{"$f":"SUMIF(D3:D225,K3:R3,H3:H225)","v":0},{"$f":"SUMIF(D3:D225,K3:R3,H3:H225)","v":0},{"$f":"SUMIF(D3:D225,K3:R3,H3:H225)","v":3570},null,null,"2020-06-02",null,4425,{"$f":"W2-W14","v":26850},"ايداع في حساب الشركة "]
["A-3","2020-01-02",8543,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550,null,null,null,null,null,null,null,null,null,null,null,null,"13/02/2020",null,3520,null,"ايداع في حساب الشركة "]
["A-4","2020-01-02",8544,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550,null,null,null,null,null,null,null,null,null,null,null,null,"16/02/2020",null,2000,null,"ايداع في حساب الشركة "]
["A-5","2020-01-02",8545,"نقدي","خرسانة 3/4",16,27.5,440,null,null,null,null,null,null,null,null,null,null,null,null,"16/02/2020",null,2005,null,"ايداع في حساب الشركة "]
["A-6","2020-01-02",8546,"اكرام - شركة القلابات","خرسانة 3/4",16,27.5,440,null,null,null,null,null,null,null,null,null,null,null,null,"23/02/2020",null,2630,null,"ايداع في حساب الشركة "]
["A-7","2020-01-02",8547,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["A-8","2020-01-02",8548,"نعيم - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-10","2020-02-02",8550,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-11","2020-02-02",8551,"نقدي","خرسانة 3/8",16,27.5,440]
["A-12","2020-02-02",8552,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-13","2020-02-02",8553,"نقدي","خرسانة 3/8",24,27.083333333333332,650,null,null,null,null,null,null,null,null,null,null,null,"اجمالى الايداعات",null,null,{"$f":"SUM(W4:W13)","v":14580}]
["A-14","2020-02-02",8554,"نقدي","خرسانة 3/8",16,27.5,440]
["A-15","2020-02-02",8555,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-16","2020-02-02",8556,"نقدي","خرسانة 3/4",16,27.5,440]
["A-17","2020-02-02",8557,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-18","2020-02-03",8558,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-19","2020-02-03",8559,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-20","2020-02-03",8560,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-21","2020-02-03",8561,"نقدي","خرسانة 3/4",14,27.857142857142858,390]
["A-22","2020-02-03",8562,"نقدي","خرسانة 3/8",16,27.5,440]
["A-23","2020-02-03",8563,"اكرام - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-24","2020-02-03",8564,"نقدي","خرسانة 3/4",24,16.25,390]
["A-25","2020-02-03",8565,"نقدي","خرسانة 3/4",8,30,240]
["A-26","2020-02-03",8566,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-27","2020-02-04",8567,"نزير - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-28","2020-02-04",8568,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-29","2020-02-04",8569,"نقدي","خرسانة 3/4",16,27.5,440]
["A-30","2020-02-04",8570,"نقدي","خرسانة 3/8",16,27.5,440]
["A-31","2020-02-04",8571,"نقدي","خرسانة 3/4",16,27.5,440]
["A-32","2020-02-04",8572,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-33","2020-02-04",8573,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-34","2020-02-04",8574,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-35","2020-02-04",8575,"نقدي","خرسانة 3/4",16,27.5,440]
["A-36","2020-02-04",8576,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-37","2020-02-04",8577,"نقدي","خرسانة 3/4",16,27.5,440]
["A-38","2020-02-05",8578,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-39","2020-02-05",8579,"نقدي","خرسانة 3/4",24,22.916666666666668,550]
["A-40","2020-02-05",8580,"نقدي","خرسانة 3/4",16,27.5,440]
["A-41","2020-02-05",8581,"نقدي","خرسانة 3/4",16,27.5,440]
["A-42","2020-02-05",8582,"نقدي","خرسانة 3/8",16,27.5,440]
["A-43","2020-02-05",8583,"نقدي","خرسانة 3/4",24,22.916666666666668,550]
["A-44","2020-02-06",8584,"نقدي","خرسانة 3/4",24,22.916666666666668,550]
["A-45","2020-02-06",8585,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-46","2020-02-06",8586,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-47","2020-02-06",8587,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-48","2020-02-06",8588,"نقدي","خرسانة 3/4",8,30,240]
["A-49","2020-02-06",8589,"نقدي","خرسانة 3/4",16,27.5,440]
["A-50","2020-02-06",8590,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-51","2020-02-06",8591,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-52","2020-02-06",8592,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-53","2020-02-06",8593,"نقدي","خرسانة 3/4",8,30,240]
["A-54","2020-02-06",8594,"نقدي","خرسانة 3/8",16,27.5,440]
["A-55","2020-02-06",8595,"نقدي","خرسانة 3/4",16,27.5,440]
["A-56","2020-02-06",8596,"نقدي","خرسانة 3/4",16,27.5,440]
["A-57","2020-02-08",8597,"نقدي","خرسانة 3/4",8,30,240]
["A-58","2020-02-08",8598,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-59","2020-02-08",8599,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-60","2020-02-08",8600,"نقدي","خرسانة 3/4",16,27.5,440]
["A-61","2020-02-08",8601,"نقدي","خرسانة 3/4",8,30,240]
["A-62","2020-02-08",8602,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-63","2020-02-08",8603,"نعيم - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-64","2020-02-08",8604,"نقدي","خرسانة 3/4",24,26.666666666666668,640]
["A-65","2020-02-08",8605,"نقدي","خرسانة 3/4",16,{"$f":"IFERROR(H66/F66,\"-\")","v":27.5},440]
["A-66","2020-02-08",8606,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-67","2020-02-08",8607,"نقدي","خرسانة 3/8",16,27.5,440]
["A-68","2020-02-09",8608,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-69","2020-02-09",8609,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-70","2020-02-09",8610,"نقدي","خرسانة 3/8",16,27.5,440]
["A-71","2020-02-09",8611,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-72","2020-02-09",8612,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-73","2020-02-09",8613,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-74","2020-02-09",8614,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-75","2020-02-09",8615,"نقدي","خرسانة 3/4",16,27.5,440]
["A-76","2020-02-10",8616,"نقدي","خرسانة 3/8",8,30,240]
["A-77","2020-02-10",8617,"نقدي","خرسانة 3/4",8,30,240]
["A-78","2020-02-11",8618,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-79","2020-02-11",8619,"نقدي","خرسانة 3/8",16,27.5,440]
["A-80","2020-02-11",8620,"نقدي","خرسانة 3/8",16,27.5,440]
["A-81","2020-02-11",8621,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-82","2020-02-11",8622,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-83","2020-02-11",8623,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-84","2020-02-11",8624,"نقدي","خرسانة 3/4",16,27.5,440]
["A-85","2020-02-11",8625,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-86","2020-02-11",8626,"نقدي","خرسانة 3/4",16,27.5,440]
["A-87","2020-02-12",8627,"نقدي","خرسانة 3/4",16,27.5,440]
["A-88","2020-02-12",8628,"راشد الاسمري - ايجار معدات","خرسانة 3/4",16,27.5,440]
["A-89","2020-02-12",8629,"نقدي","خرسانة 3/4",16,27.5,440]
["A-90","2020-02-12",8630,"نقدي","خرسانة 3/4",16,27.5,440]
["A-91","2020-02-12",8631,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-92","2020-02-12",8632,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-93","2020-02-12",8633,"نقدي","خرسانة 3/8",16,27.5,440]
["A-94","2020-02-12",8634,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-95","2020-02-13",8635,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-96","2020-02-13",8636,"نقدي","خرسانة 3/4",16,27.5,440]
["A-97","2020-02-13",8637,"نقدي","خرسانة 3/4",16,27.5,440]
["A-98","2020-02-13",8638,"نقدي","خرسانة 3/4",16,27.5,440]
["A-99","2020-02-13",8639,"نقدي","خرسانة 3/4",16,27.5,440]
["A-100","2020-02-13",8640,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-101","2020-02-13",8641,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-102","2020-02-13",8642,"ظافر النماص","خرسانة 3/4",16,27.5,440]
["A-103","2020-02-13",8643,"نقدي","خرسانة 3/4",16,27.5,440]
["A-104","2020-02-13",8644,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-105","2020-02-13",8645,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-106","2020-02-13",8646,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-107","2020-02-15",8647,"نقدي","خرسانة 3/4",16,27.5,440]
["A-108","2020-02-15",8648,"نقدي","خرسانة 3/4",16,27.5,440]
["A-109","2020-02-15",8649,"نعيم - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-110","2020-02-15",8650,"نقدي","خرسانة 3/4",8,30,240]
["A-99","2020-02-15",8651,"نقدي","خرسانة 3/8",16,27.5,440]
["A-100","2020-02-15",8652,"نقدي","خرسانة 3/8",16,27.5,440]
["A-101","2020-02-15",8653,"نقدي","خرسانة 3/8",16,27.5,440]
["A-102","2020-02-15",8654,"واسيم  - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-103","2020-02-15",8655,"راشد الاسمري - ايجار معدات","خرسانة 3/4",16,27.5,440]
["A-104","16/2/2020",8656,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-105","16/2/2020",8657,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-106","16/2/2020",8658,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-107","16/2/2020",8659,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-108","16/2/2020",8660,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-109","16/2/2020",8661,"نقدي","خرسانة 3/4",16,27.5,440]
["A-110","16/2/2020",8662,"نقدي","خرسانة 3/4",16,27.5,440]
["A-111","16/2/2020",8663,"نقدي","خرسانة 3/4",16,27.5,440]
["A-112","16/2/2020",8664,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-113","17/2/2020",8665,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-114","17/2/2020",8666,"نزير - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-115","17/2/2020",8667,"نعيم - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-116","18/2/2020",8668,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-117","18/2/2020",8669,"مصنع العسيري","خرسانة 3/4",24,{"$f":"IFERROR(H130/F130,\"-\")","v":22.916666666666668},550]
["A-118","18/2/2020",8670,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-119","18/2/2020",8671,"نقدي","خرسانة 3/4",16,27.5,440]
["A-120","18/2/2020",8672,"نقدي","خرسانة 3/8",16,27.5,440]
["A-121","18/2/2020",8673,"نقدي","خرسانة 3/4",16,27.5,440]
["A-122","18/2/2020",8674,"نقدي","خرسانة 3/8",16,27.5,440]
["A-123","18/2/2020",8675,"ناصر - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-124","19/2/2020",8676,"ناصر - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-125","19/2/2020",8677,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-126","19/2/2020",8678,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-127","19/2/2020",8679,"نقدي","خرسانة 3/8",24,26.666666666666668,640]
["A-128","19/2/2020",8680,"اكرام - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-129","19/2/2020",8681,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-130","19/2/2020",8682,"نقدي","خرسانة 3/4",16,27.5,440]
["A-131","19/2/2020",8683,"نعيم - شركة القلابات","خرسانة 3/8",16,27.5,440]
["A-132","19/2/2020",8684,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-133","19/2/2020",8685,"واسيم  - شركة القلابات","تراب ناعم",16,3.125,50]
["A-134","19/2/2020",8686,"نقدي","خرسانة 3/4",16,27.5,440]
["A-135","19/2/2020",8687,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-136","20/2/2020",8688,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-137","20/2/2020",8689,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-138","20/2/2020",8690,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-139","20/2/2020",8691,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-140","20/2/2020",8692,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-141","20/2/2020",8693,"راشد الاسمري - ايجار معدات","خرسانة 3/4",16,27.5,440]
["A-143","20/2/2020",8695,"نزير - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-144","20/2/2020",8696,"نقدي","خرسانة 3/4",16,27.5,440]
["A-145","21/2/2020",8697,"نقدي","خرسانة 3/8",16,27.5,440]
["A-146","22/2/2020",8698,"نعيم - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-147","22/2/2020",8699,"نقدي","خرسانة 3/4",8,30,240]
["A-148","22/2/2020",8700,"نقدي","تراب ناعم",32,3.125,100]
["A-149","22/2/2020",8701,"نقدي","خرسانة 3/4",16,27.5,440]
["A-150","22/2/2020",8702,"نقدي","خرسانة 3/4",8,30,240]
["A-151","22/2/2020",8703,"نعيم - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-152","22/2/2020",8704,"نقدي","خرسانة 3/4",24,26.666666666666668,640]
["A-153","22/2/2020",8705,"نزير - شركة القلابات","تراب ناعم",16,3.125,50]
["A-154","22/2/2020",8706,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-155","22/2/2020",8707,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-156","22/2/2020",8708,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-157","22/2/2020",8709,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-158","22/2/2020",8710,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-159","22/2/2020",8711,"نقدي","خرسانة 3/4",8,30,240]
["A-160","23/2/2020",8712,"نزير - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-161","23/2/2020",8713,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-162","23/2/2020",8714,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-163","23/2/2020",8715,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-164","23/2/2020",8716,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-165","23/2/2020",8717,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-166","23/2/2020",8718,"نزير - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-167","23/2/2020",8719,"نقدي","خرسانة 3/4",16,28.75,460]
["A-168","23/2/2020",8720,"نقدي","خرسانة 3/4",16,28.75,460]
["A-169","23/2/2020",8721,"ناصر - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-170","24/2/2020",8722,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-171","24/2/2020",8723,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-172","24/2/2020",8724,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-173","24/2/2020",8725,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-174","24/2/2020",8726,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-175","24/2/2020",8727,"نقدي","خرسانة 3/4",8,30,240]
["A-176","24/2/2020",8728,"نقدي","خرسانة 3/4",24,29.166666666666668,700]
["A-177","24/2/2020",8729,"نزير - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-178","24/2/2020",8730,"اكرام - شركة القلابات","خرسانة 3/8",16,27.5,440]
["A-179","24/2/2020",8731,"اكرام - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-180","25/2/2020",8732,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-181","25/2/2020",8733,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-182","25/2/2020",8734,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-183","25/2/2020",8735,"ناصر - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-184","25/2/2020",8736,"نزير - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-185","26/2/20200",8737,"ناصر - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-186","26/2/20200",8738,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-187","26/2/20200",8739,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-188","26/2/20200",8740,"نقدي","خرسانة 3/8",16,27.5,440]
["A-189","26/2/20200",8741,"نقدي","خرسانة 3/8",16,27.5,440]
["A-190","26/2/20200",8742,"نقدي","خرسانة 3/4",16,27.5,440]
["A-191","26/2/20200",8743,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-192","26/2/20200",8744,"نقدي","خرسانة 3/4",16,27.5,440]
["A-193","26/2/20200",8745,"نقدي","خرسانة 3/4",16,27.5,440]
["A-194","26/2/20200",8746,"اكرام - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-195","27/2/2020",8747,"نقدي","خرسانة 3/4",24,24.583333333333332,590]
["A-196","27/2/2020",8748,"نقدي","خرسانة 3/4",16,27.5,440]
["A-197","27/2/2020",8749,"نقدي","خرسانة 3/4",16,27.5,440]
["A-198","27/2/2020",8750,"نقدي","خرسانة 3/4",16,27.5,440]
["A-199","27/2/2020",8751,"نقدي","خرسانة 3/4",16,27.5,440]
["A-200","27/2/2020",8752,"نقدي","خرسانة 3/8",16,27.5,440]
["A-201","27/2/2020",8753,"نقدي","خرسانة 3/8",16,27.5,440]
["A-202","27/2/2020",8754,"نقدي","خرسانة 3/8",16,27.5,440]
["A-203","27/2/2020",8755,"نقدي","خرسانة 3/8",16,27.5,440]
["A-204","27/2/2020",8756,"نقدي","خرسانة 3/4",16,27.5,440]
["A-205","27/2/2020",8757,"نقدي","خرسانة 3/4",16,27.5,440]
["A-206","29/2/2020",8758,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-207","29/2/2020",8759,"نقدي","خرسانة 3/4",16,27.5,440]
["A-208","29/2/2020",8760,"نقدي","خرسانة 3/4",16,27.5,440]
["A-209","29/2/2020",8761,"نقدي","خرسانة 3/8",16,27.5,440]
["A-210","29/2/2020",8762,"نقدي","خرسانة 3/8",16,27.5,440]
["A-211","29/2/2020",8763,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-212","29/2/2020",8764,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-213","29/2/2020",8765,"نزير - شركة القلابات","خرسانة 3/4",16,27.5,440]
[null,"TOTAL",null,null,null,{"$f":"SUBTOTAL(109,F3:F225)","v":4310},null,{"$f":"SUBTOTAL(109,H3:H225)","v":106320}]
[null,null,null,"نقدي",null,{"$f":"SUMIF($D$3:$D$225,D227,$F$3:$F$225)","v":1550},{"$f":"IFERROR(H227/F227,\"-\")","v":26.729032258064517},{"$f":"SUMIF($D$3:$D$225,D227,$H$3:$H$225)","v":41430}]
[null,null,null,"راشد الاسمري - ايجار معدات",null,48,27.5,1320]
[null,null,null,"حسين  - شركة القلابات",null,0,"-",0]
[null,null,null,"واسيم  - شركة القلابات",null,32,15.3125,490]
[null,null,null,"العمري - شركة القلابات",null,0,"-",0]
[null,null,null,"مقصود - شركة القلابات",null,0,"-",0]
[null,null,null,"نعيم - شركة القلابات",null,112,27.5,3080]
[null,null,null,"مصنع العسيري",null,2232,22.916666666666668,51150,{"$f":"H234-2850-24100-13750","v":10450}]
[null,null,null,"نزير - شركة القلابات",null,144,24.791666666666668,3570]
[null,null,null,"ظافر النماص",null,16,27.5,440]
[null,null,null,"اكرام - شركة القلابات",null,96,27.5,2640]
[null,null,null,"فهد الشهري",null,0,"-",0]
[null,null,null,"عالم الاعمار - عميل نقدي",null,0,"-",0,null,{"$f":"H226-H241","v":0}]
[null,null,null,"ناصر - شركة القلابات",null,80,27.5,2200]
["TOTAL",null,null,null,null,{"$f":"SUM(F227:F240)","v":4310},null,{"$f":"SUM(H227:H240)","v":106320}]
[]
[]
[]
[]
[]
[null,null,null,null,"القيمة المضافة","الإيرادات","المبيعات"]
[null,null,null,null,{"$f":"G248-F248","v":5062.8571428571449},{"$f":"G248/1.05","v":101257.14285714286},{"$f":"H226","v":106320}]
[]
[]
[]
[null,null,null,null,"نوع المواد","QUANTITY","PRICE","AMOUNT","الإيرادات","VAT"]
[null,null,null,null,"خرسانة 3/4",{"$f":"SUMIF($E$3:$E$226,E253,$F$3:$F$226)","v":2894},{"$f":"IFERROR(H253/F253,\"-\")","v":25.19350380096752},{"$f":"SUMIF($E$3:$E$226,E253,$H$3:$H$226)","v":72910},{"$f":"H253/1.05","v":69438.095238095237},{"$f":"I253*0.05","v":3471.9047619047619}]
[null,null,null,null,"خرسانة 3/8",{"$f":"SUMIF($E$3:$E$226,E254,$F$3:$F$226)","v":1352},{"$f":"IFERROR(H254/F254,\"-\")","v":24.56360946745562},{"$f":"SUMIF($E$3:$E$226,E254,$H$3:$H$226)","v":33210},{"$f":"H254/1.05","v":31628.571428571428},{"$f":"I254*0.05","v":1581.4285714285716}]
[null,null,null,null,"تراب ناعم",{"$f":"SUMIF($E$3:$E$226,E255,$F$3:$F$226)","v":64},{"$f":"IFERROR(H255/F255,\"-\")","v":3.125},{"$f":"SUMIF($E$3:$E$226,E255,$H$3:$H$226)","v":200},{"$f":"H255/1.05","v":190.47619047619048},{"$f":"I255*0.05","v":9.5238095238095237}]
[]
[null,null,null,null,"اجمالى",{"$f":"SUM(F253:F255)","v":4310},null,{"$f":"SUM(H253:H255)","v":106320},{"$f":"SUM(I253:I255)","v":101257.14285714284},{"$f":"SUM(J253:J255)","v":5062.8571428571431}]

{"sheet":"مارس","index":4,"n_rows":267,"n_cols":25,"rows_kept":267,"cut":false,"hidden":false,"merged":[[14,19,14,21],[0,0,0,7],[1,9,1,17],[1,19,1,21],[1,22,1,24],[3,23,12,23]]}
["تقرير مبيعات كسارة مارس 2020"]
["S.N","DATE","NUMBER","العميل","نوع المواد","QUANTITY","PRICE","AMOUNT",null,"بيان بقيمة الخرسانة المحملة علي شركة القلابات عن شهر ديسمبر 2019م ",null,null,null,null,null,null,null,null,null,"اجمالى المبييعات",null,null,{"$f":"H245","v":26610}]
["A-1","2020-01-03",8766,"مصنع العسيري","خرسانة 3/4",24,{"$f":"IFERROR(H3/F3,\"-\")","v":22.916666666666668},550,null,"الإجمالي ","واسيم  - شركة القلابات","حسين  - شركة القلابات","نعيم - شركة القلابات","اكرام - شركة القلابات","ناصر - شركة القلابات","العمري - شركة القلابات","مقصود - شركة القلابات","نزير - شركة القلابات",null,"مسلسل","التاريخ","رقم المستند","ايداع","الرصيد المتبقى","ملاحظات"]
["A-2","2020-01-03",8767,"نعيم - شركة القلابات","خرسانة 3/4",16,27.5,440,null,{"$f":"SUM(K4:R4)","v":21450},{"$f":"SUMIF(D3:D243,K3:R3,H3:H243)","v":1320},{"$f":"SUMIF(D3:D243,K3:R3,H3:H243)","v":3670},{"$f":"SUMIF(D3:D243,K3:R3,H3:H243)","v":4610},{"$f":"SUMIF(D3:D243,K3:R3,H3:H243)","v":5390},{"$f":"SUMIF(D3:D243,K3:R3,H3:H243)","v":3720},{"$f":"SUMIF(D3:D243,K3:R3,H3:H243)","v":0},{"$f":"SUMIF(D3:D243,K3:R3,H3:H243)","v":0},{"$f":"SUMIF(D3:D243,K3:R3,H3:H243)","v":2740},null,null,"2020-06-02",null,4425,{"$f":"W2-W15","v":12030},"ايداع في حساب الشركة "]
["A-3","2020-01-03",8768,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550,null,null,null,null,null,null,null,null,null,null,null,null,"13/02/2020",null,3520,null,"ايداع في حساب الشركة "]
["A-4","2020-01-03",8769,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550,null,null,null,null,null,null,null,null,null,null,null,null,"16/02/2020",null,2000,null,"ايداع في حساب الشركة "]
["A-5","2020-01-03",8770,"نعيم - شركة القلابات","تراب ناعم",32,3.125,100,null,null,null,null,null,null,null,null,null,null,null,null,"16/02/2020",null,2005,null,"ايداع في حساب الشركة "]
["A-6","2020-01-03",8771,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550,null,null,null,null,null,null,null,null,null,null,null,null,"23/02/2020",null,2630,null,"ايداع في حساب الشركة "]
["A-7","2020-02-03",8772,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["A-8","2020-02-03",8773,"نعيم - شركة القلابات","تراب ناعم",16,3.125,50]
["A-9","2020-02-03",8774,"واسيم  - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-10","2020-02-03",8775,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-11","2020-02-03",8776,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-12","2020-02-03",8777,"نقدي","خرسانة 3/8",16,27.5,440]
["A-13","2020-02-03",8778,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550,null,null,null,null,null,null,null,null,null,null,null,"اجمالى الايداعات",null,null,{"$f":"SUM(W4:W14)","v":14580}]
["A-14","2020-02-03",8779,"نقدي","خرسانة 3/4",16,27.5,440]
["A-15","2020-02-03",8780,"نقدي","خرسانة 3/8",16,27.5,440]
["A-16","2020-02-03",8781,"نقدي","خرسانة 3/8",16,27.5,440]
["A-17","2020-03-04",8782,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-18","2020-04-03",8783,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-19","2020-04-03",8784,"نقدي","خرسانة 3/4",16,27.5,440]
["A-20","2020-05-03",8785,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-21",null,8786,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-22","2020-05-03",8787,"ناصر - شركة القلابات","تراب ناعم",32,3.125,100]
["A-23","2020-05-03",8788,"ظافر النماص","خرسانة 3/4",16,27.5,440]
["A-24","2020-05-03",8789,"نقدي","خرسانة 3/4",16,27.5,440]
["A-25","2020-05-03",8790,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-26","2020-05-03",8791,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-27","2020-05-03",8792,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-28","2020-05-03",8793,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-29","2020-05-03",8794,"نعيم - شركة القلابات","خرسانة 3/4",440,1,440]
["A-30","2020-05-03",8795,"حسين  - شركة القلابات","تراب ناعم",32,3.125,100]
["A-31","2020-06-03",8796,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-32","2020-06-03",8797,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-33","2020-06-03",8798,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-34","2020-06-03",8799,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-35","2020-06-03",8800,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-36","2020-06-03",8801,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-37","2020-06-03",8802,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-38","2020-06-03",8803,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-39","2020-07-03",8804,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-40","2020-07-03",8805,"نقدي","خرسانة 3/4",16,27.5,440]
["A-41","2020-07-03",8806,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-42","2020-07-03",8807,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-43","2020-07-03",8808,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-44","2020-08-03",8809,"نقدي","خرسانة 3/4",16,27.5,440]
["A-45","2020-09-03",8810,"نقدي","خرسانة 3/4",16,27.5,440]
["A-46","2020-09-03",8811,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-47","2020-09-03",8812,"نزير - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-48","2020-09-03",8813,"اكرام - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-49","2020-09-03",8814,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-50","2020-09-03",8815,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-51","2020-09-03",8816,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-52","2020-09-03",8817,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-53","2020-09-03",8818,"نعيم - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-54","2020-09-03",8819,"نقدي","خرسانة 3/4",16,27.5,440]
["A-55","2020-09-03",8820,"نقدي","خرسانة 3/4",16,27.5,440]
["A-56","2020-09-03",8821,"نعيم - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-57","2020-10-03",8822,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-58","2020-10-03",8823,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-59","2020-10-03",8824,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-60","2020-10-03",8825,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-61","2020-10-03",8826,"نقدي","خرسانة 3/4",16,27.5,440]
["A-62","2020-10-03",8827,"نعيم - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-63","2020-10-03",8828,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-64","2020-10-03",8829,"نقدي","خرسانة 3/4",16,25,400]
["A-65","2020-11-03",8830,"نقدي","خرسانة 3/4",16,{"$f":"IFERROR(H67/F67,\"-\")","v":27.5},440]
["A-66","2020-11-03",8831,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-67","2020-11-03",8832,"نقدي","خرسانة 3/4",16,27.5,440]
["A-68","2020-11-03",8833,"مؤسسة بن دروم","خرسانة 3/4",8,32.5,260]
["A-69","2020-11-03",8834,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-70","2020-11-03",8835,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-71","2020-11-03",8836,"نقدي","خرسانة 3/4",16,27.5,440]
["A-72","2020-11-03",8837,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-73","2020-11-03",8838,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-74","2020-11-03",8839,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-75","2020-12-03",8840,"نقدي","خرسانة 3/4",16,27.5,440]
["A-76","2020-12-03",8841,"مؤسسة بن دروم","خرسانة 3/4",16,29.375,470]
["A-77","2020-12-03",8842,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-78","2020-12-03",8843,"حسين  - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-79","2020-12-03",8844,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-80","2020-12-03",8845,"نعيم - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-81","2020-12-03",8846,"نقدي","خرسانة 3/4",16,27.5,440]
["A-82","2020-12-03",8847,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-83","2020-12-03",8848,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-84","2020-12-03",8849,"حسين  - شركة القلابات","تراب ناعم",16,3.125,50]
["A-85","2020-12-03",8850,"نعيم - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-86","14/3/2020",8851,"نقدي","خرسانة 3/4",16,27.5,440]
["A-87","14/3/2020",8852,"ناصر - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-88","14/3/2020",8853,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-89","14/3/2020",8854,"اكرام - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-90","14/3/2020",8855,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-91","14/3/2020",8856,"ناصر - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-92","14/3/2020",8857,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-93","14/3/2020",8858,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-94","14/3/2020",8859,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-95","14/3/2020",8860,"اكرام - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-96","14/3/2020",8861,"ناصر - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-97","14/3/2020",8862,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-98","14/3/2020",8863,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-99","14/3/2020",8864,"اكرام - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-100","15/3/2020",8865,"ناصر - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-101","15/3/2020",8866,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-102","15/3/2020",8867,"نقدي","خرسانة 3/4",16,27.5,440]
["A-103","15/3/2020",8868,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-104","15/3/2020",8869,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-105","15/3/2020",8870,"نزير - شركة القلابات","تراب ناعم",32,3.125,100]
["A-106","15/3/2020",8871,"راشد الاسمري - ايجار معدات","خرسانة 3/4",16,27.5,440]
["A-107","15/3/2020",8872,"حسين  - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-108","15/3/2020",8873,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-109","15/3/2020",8874,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-110","15/3/2020",8875,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-99","15/3/2020",8876,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-100","16/3/2020",8877,"نقدي","خرسانة 3/4",16,27.5,440]
["A-101","16/3/2020",8878,"نقدي","خرسانة 3/4",16,27.5,440]
["A-102","16/3/2020",8879,"اكرام - شركة القلابات","خرسانة 3/8",16,27.5,440]
["A-103","16/3/2020",8880,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-104","16/3/2020",8881,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-105","16/3/2020",8882,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-106","16/3/2020",8883,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-107","16/3/2020",8884,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-108","16/3/2020",8885,"نعيم - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-109","16/3/2020",8886,"حسين  - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-110","16/3/2020",8887,"نقدي","خرسانة 3/4",16,27.5,440]
["A-111","16/3/2020",8888,"واسيم  - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-112","17/3/2020",8889,"ناصر - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-113","17/3/2020",8890,"ناصر - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-114","18/3/2020",8891,"نزير - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-115","18/3/2020",8892,"نقدي","خرسانة 3/4",24,26.666666666666668,640]
["A-116","18/3/2020",8893,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-117","18/3/2020",8894,"مصنع العسيري","خرسانة 3/4",24,{"$f":"IFERROR(H131/F131,\"-\")","v":22.916666666666668},550]
["A-118","18/3/2020",8895,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-119","18/3/2020",8896,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-120","18/3/2020",8897,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-121","18/3/2020",8898,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-122","18/3/2020",8899,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-123","18/3/2020",8900,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-124","18/3/2020",8901,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-125","19/3/2020",8902,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-126","19/3/2020",8903,"نقدي","خرسانة 3/4",24,26.666666666666668,640]
["A-127","19/3/2020",8904,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-128","19/3/2020",8905,"نقدي","خرسانة 3/4",16,27.5,440]
["A-129","19/3/2020",8906,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-130","19/3/2020",8907,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-131","19/3/2020",8908,"اكرام - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-133","19/3/2020",8910,"نقدي","خرسانة 3/4",16,27.5,440]
["A-134","19/3/2020",8911,"مؤسسة بن دروم","خرسانة 3/8",8,32.5,260]
["A-135","19/3/2020",8912,"نقدي","خرسانة 3/4",24,26.666666666666668,640]
["A-136","19/3/2020",8913,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-137","19/3/2020",8914,"نقدي","خرسانة 3/4",16,27.5,440]
["A-138","19/3/2020",8915,"ناصر - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-139","21/3/2020",8916,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-140","21/3/2020",8917,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-141","21/3/2020",8918,"اكرام - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-142","21/3/2020",8919,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-143","21/3/2020",8920,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-144","21/3/2020",8921,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-145","22/3/2020",8922,"نزير - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-146","22/3/2020",8923,"نقدي","تراب ناعم",16,3.125,50]
["A-147","22/3/2020",8924,"ناصر - شركة القلابات","تراب ناعم",16,3.125,50]
["A-148","22/3/2020",8925,"ناصر - شركة القلابات","تراب ناعم",16,3.125,50]
["A-149","22/3/2020",8926,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-150","22/3/2020",8927,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-151","22/3/2020",8928,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-152","22/3/2020",8929,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-153","22/3/2020",8930,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-154","23/3/2020",8931,"نقدي","خرسانة 3/4",24,25,600]
["A-155","23/3/2020",8932,"نقدي","خرسانة 3/4",24,25,600]
["A-156","23/3/2020",8933,"حسين  - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-157","23/3/2020",8934,"حسين  - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-158","23/3/2020",8935,"راشد الاسمري - ايجار معدات","خرسانة 3/8",16,27.5,440]
["A-159","23/3/2020",8936,"نقدي","خرسانة 3/4",24,26.666666666666668,640]
["A-160","23/3/2020",8937,"مؤسسة بن دروم","خرسانة 3/4",16,29.375,470]
["A-161","23/3/2020",8938,"اكرام - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-162","24/3/2020",8939,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-163","24/3/2020",8940,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-164","24/3/2020",8941,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-165","24/3/2020",8942,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-166","24/3/2020",8943,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-167","24/3/2020",8944,"اكرام - شركة القلابات","خرسانة 3/4",16,34.375,550]
["A-168","24/3/2020",8945,"نقدي","خرسانة 3/4",16,27.5,440]
["A-169","24/3/2020",8946,"نقدي","خرسانة 3/4",16,27.5,440]
["A-170","24/3/2020",8947,"نقدي","خرسانة 3/4",16,27.5,440]
["A-171","24/3/2020",8948,"حسين  - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-172","25/3/2020",8949,"نقدي","خرسانة 3/4",14,28.571428571428573,400]
["A-173","25/3/2020",8950,"نقدي","خرسانة 3/8",8,36.25,290]
["A-174","25/3/2020",8951,"نقدي","خرسانة 3/8",16,27.5,440]
["A-175","25/3/2020",8952,"نقدي","خرسانة 3/4",24,26.666666666666668,640]
["A-176","25/3/2020",8953,"نزير - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-177","25/3/2020",8954,"نقدي","تراب ناعم",32,3.125,100]
["A-178","25/3/2020",8955,"نقدي","خرسانة 3/4",16,27.5,440]
["A-179","26/3/2020",8956,"نقدي","تراب ناعم",16,3.125,50]
["A-180","26/3/2020",8957,"ناصر - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-181","26/3/2020",8958,"نقدي","خرسانة 3/4",16,27.5,440]
["A-182","26/3/2020",8959,"نقدي","تراب ناعم",16,3.125,50]
["A-183","26/3/2020",8960,"نقدي","خرسانة 3/4",24,26.666666666666668,640]
["A-184","26/3/2020",8961,"نقدي","خرسانة 3/4",16,27.5,440]
["A-185","26/3/2020",8962,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-186","26/3/2020",8963,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-187","26/3/2020",8964,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-188","28/3/2020",8965,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-189","28/3/2020",8966,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-190","28/3/2020",8967,"نزير - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-191","28/3/2020",8968,"نزير - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-192","28/3/2020",8969,"نعيم - شركة القلابات","تراب ناعم",80,3.125,250]
["A-193","28/3/2020",8970,"نقدي","خرسانة 3/4",16,27.5,440]
["A-194","28/3/2020",8971,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-195","28/3/2020",8972,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-196","28/3/2020",8973,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-197","28/3/2020",8974,"حسين  - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-198","28/3/2020",8975,"واسيم  - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-199","29/3/2020",8976,"نقدي","خرسانة 3/4",16,27.5,440]
["A-200","29/3/2020",8977,"اكرام - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-201","29/3/2020",8978,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-202","29/3/2020",8979,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-203","29/3/2020",8980,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-204","29/3/2020",8981,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-205","29/3/2020",8982,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-206","29/3/2020",8983,"نعيم - شركة القلابات","تراب ناعم",80,3.125,250]
["A-207","29/3/2020",8984,"اكرام - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-208","29/3/2020",8985,"نقدي","خرسانة 3/4",16,27.5,440]
["A-209","29/3/2020",8986,"راشد الاسمري - ايجار معدات","خرسانة 3/8",8,36.25,290]
["A-210","29/3/2020",8987,"نقدي","خرسانة 3/4",16,27.5,440]
["A-211","30/3/2020",8988,"نعيم - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-212","30/3/2020",8989,"نقدي","خرسانة 3/4",16,27.5,440]
["A-213","30/3/2020",8990,"اكرام - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-214","30/3/2020",8991,"نقدي","خرسانة 3/4",16,27.5,440]
["A-215","30/3/2020",8992,"نقدي","خرسانة 3/4",16,27.5,440]
["A-216","30/3/2020",8993,"نقدي","خرسانة 3/4",16,27.5,440]
["A-217","30/3/2020",8994,"نقدي","خرسانة 3/4",16,27.5,440]
["A-218","30/3/2020",8995,"نقدي","خرسانة 3/8",16,27.5,440]
["A-219","30/3/2020",8996,"نقدي","خرسانة 3/8",8,36.25,290]
["A-220","30/3/2020",8997,"راشد الاسمري - ايجار معدات","خرسانة 3/4",16,27.5,440]
["A-221","31/3/2020",8998,"نقدي","خرسانة 3/4",16,27.5,440]
["A-222","31/3/2020",8999,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-223","31/3/2020",9000,"نقدي","خرسانة 3/4",8,36.25,290]
["A-224","31/3/2020",9001,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-225","31/3/2020",9002,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-226","31/3/2020",9003,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-227","31/3/2020",9004,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-228","31/3/2020",9005,"نقدي","خرسانة 3/4",16,27.5,440]
["A-229","31/3/2020",9006,"نقدي","خرسانة 3/4",8,36.25,290]
["A-230","31/3/2020",9007,"حسين  - شركة القلابات","خرسانة 3/4",16,27.5,440]
[null,"TOTAL",null,null,null,{"$f":"SUBTOTAL(109,F3:F243)","v":5406},null,{"$f":"SUBTOTAL(109,H3:H243)","v":114270}]
[null,null,null,"نقدي",null,{"$f":"SUMIF($D$3:$D$243,D245,$F$3:$F$243)","v":1038},{"$f":"IFERROR(H245/F245,\"-\")","v":25.635838150289018},{"$f":"SUMIF($D$3:$D$243,D245,$H$3:$H$243)","v":26610}]
[null,null,null,"راشد الاسمري - ايجار معدات",null,56,28.75,1610]
[null,null,null,"حسين  - شركة القلابات",null,176,20.852272727272727,3670]
[null,null,null,"واسيم  - شركة القلابات",null,48,27.5,1320]
[null,null,null,"مؤسسة بن دروم",null,48,30.416666666666668,1460]
[null,null,null,"نعيم - شركة القلابات",null,776,5.9407216494845363,4610]
[null,null,null,"مصنع العسيري",null,2736,22.916666666666668,62700,{"$f":"H251-15400-11450-13200-10000-10000-9900","v":-7250}]
[null,null,null,"نزير - شركة القلابات",null,128,21.40625,2740]
[null,null,null,"ظافر النماص",null,16,27.5,440]
[null,null,null,"اكرام - شركة القلابات",null,192,28.072916666666668,5390]
[null,null,null,"ناصر - شركة القلابات",null,192,19.375,3720]
["TOTAL",null,null,null,null,{"$f":"SUM(F245:F255)","v":5406},null,{"$f":"SUM(H245:H255)","v":114270}]
[null,null,null,null,"القيمة المضافة","الإيرادات","المبيعات"]
[null,null,null,null,{"$f":"G258-F258","v":5441.4285714285797},{"$f":"G258/1.05","v":108828.57142857142},{"$f":"H244","v":114270}]
[]
[]
[]
[null,null,null,null,"نوع المواد","QUANTITY","PRICE","AMOUNT","الإيرادات","VAT"]
[null,null,null,null,"خرسانة 3/4",{"$f":"SUMIF($E$3:$E$243,E263,$F$3:$F$243)","v":3702},{"$f":"IFERROR(H263/F263,\"-\")","v":22.382495948136143},{"$f":"SUMIF($E$3:$E$243,E263,$H$3:$H$243)","v":82860},{"$f":"H263/1.05","v":78914.28571428571},{"$f":"I263*0.05","v":3945.7142857142858}]
[null,null,null,null,"خرسانة 3/8",{"$f":"SUMIF($E$3:$E$243,E264,$F$3:$F$243)","v":1272},{"$f":"IFERROR(H264/F264,\"-\")","v":23.632075471698112},{"$f":"SUMIF($E$3:$E$243,E264,$H$3:$H$243)","v":30060},{"$f":"H264/1.05","v":28628.571428571428},{"$f":"I264*0.05","v":1431.4285714285716}]
[null,null,null,null,"تراب ناعم",{"$f":"SUMIF($E$3:$E$243,E265,$F$3:$F$243)","v":432},{"$f":"IFERROR(H265/F265,\"-\")","v":3.125},{"$f":"SUMIF($E$3:$E$243,E265,$H$3:$H$243)","v":1350},{"$f":"H265/1.05","v":1285.7142857142856},{"$f":"I265*0.05","v":64.285714285714278}]
[]
[null,null,null,null,"اجمالى",{"$f":"SUM(F263:F265)","v":5406},null,{"$f":"SUM(H263:H265)","v":114270},{"$f":"SUM(I263:I265)","v":108828.57142857142},{"$f":"SUM(J263:J265)","v":5441.4285714285716}]

{"sheet":"ابريل","index":5,"n_rows":254,"n_cols":25,"rows_kept":254,"cut":false,"hidden":false,"merged":[[14,19,14,21],[0,0,0,7],[1,9,1,17],[1,19,1,21],[1,22,1,24],[3,23,12,23]]}
["تقرير مبيعات كسارة ابريل 2020"]
["S.N","DATE","NUMBER","العميل","نوع المواد","QUANTITY","PRICE","AMOUNT",null,"بيان بقيمة الخرسانة المحملة علي شركة القلابات عن شهر ديسمبر 2019م ",null,null,null,null,null,null,null,null,null,"اجمالى المبييعات",null,null,{"$f":"H228","v":22620}]
["A-1","2020-01-04",9008,"ناصر - شركة القلابات","خرسانة 3/4",16,{"$f":"IFERROR(H3/F3,\"-\")","v":27.5},440,null,"الإجمالي ","واسيم  - شركة القلابات","حسين  - شركة القلابات","نعيم - شركة القلابات","اكرام - شركة القلابات","ناصر - شركة القلابات","محمد اشرف - شركة القلابات","عثمان - شركة القلابات","نزير - شركة القلابات",null,"مسلسل","التاريخ","رقم المستند","ايداع","الرصيد المتبقى","ملاحظات"]
["A-2","2020-01-04",9009,"اكرام - شركة القلابات","خرسانة 3/4",16,27.5,440,null,{"$f":"SUM(K4:R4)","v":19310},{"$f":"SUMIF(D3:D226,K3:R3,H3:H226)","v":5030},{"$f":"SUMIF(D3:D226,K3:R3,H3:H226)","v":350},{"$f":"SUMIF(D3:D226,K3:R3,H3:H226)","v":2900},{"$f":"SUMIF(D3:D226,K3:R3,H3:H226)","v":880},{"$f":"SUMIF(D3:D226,K3:R3,H3:H226)","v":2640},{"$f":"SUMIF(D3:D226,K3:R3,H3:H226)","v":1670},{"$f":"SUMIF(D3:D226,K3:R3,H3:H226)","v":3580},{"$f":"SUMIF(D3:D226,K3:R3,H3:H226)","v":2260},null,null,"2020-06-02",null,4425,{"$f":"W2-W15","v":8040},"ايداع في حساب الشركة "]
["A-3","2020-01-04",9010,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550,null,null,null,null,null,null,null,null,null,null,null,null,"13/02/2020",null,3520,null,"ايداع في حساب الشركة "]
["A-4","2020-01-04",9011,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550,null,null,null,null,null,null,null,null,null,null,null,null,"16/02/2020",null,2000,null,"ايداع في حساب الشركة "]
["A-5","2020-01-04",9012,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550,null,null,null,null,null,null,null,null,null,null,null,null,"16/02/2020",null,2005,null,"ايداع في حساب الشركة "]
["A-6","2020-01-04",9013,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550,null,null,null,null,null,null,null,null,null,null,null,null,"23/02/2020",null,2630,null,"ايداع في حساب الشركة "]
["A-7","2020-01-04",9014,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["A-8","2020-01-04",9015,"نقدي","تراب ناعم",16,3.125,50]
["A-9","2020-02-04",9016,"نقدي","تراب ناعم",80,3.125,250]
["A-10","2020-02-04",9017,"واسيم  - شركة القلابات","تراب ناعم",16,3.125,50]
["A-11","2020-02-04",9018,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-12","2020-02-04",9019,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-13","2020-02-04",9020,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550,null,null,null,null,null,null,null,null,null,null,null,"اجمالى الايداعات",null,null,{"$f":"SUM(W4:W14)","v":14580}]
["A-14","2020-02-04",9021,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-15","2020-02-04",9022,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-16","2020-02-04",9023,"نقدي","خرسانة 3/4",16,27.5,440]
["A-17","2020-02-04",9024,"واسيم  - شركة القلابات","تراب ناعم",16,3.125,50]
["A-18","2020-04-04",9025,"حسين  - شركة القلابات","تراب ناعم",32,3.125,100]
["A-19","2020-04-04",9026,"نعيم - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-20","2020-04-04",9027,"واسيم  - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-21","2020-04-04",9028,"نقدي","تراب ناعم",16,3.125,50]
["A-22","2020-04-04",9029,"حسين  - شركة القلابات","تراب ناعم",48,3.125,150]
["A-23","2020-04-04",9030,"واسيم  - شركة القلابات","تراب ناعم",16,3.125,50]
["A-24","2020-04-04",9031,"نقدي","تراب ناعم",16,3.125,50]
["A-25","2020-04-04",9032,"واسيم  - شركة القلابات","تراب ناعم",16,3.125,50]
["A-26","2020-04-04",9033,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-27","2020-04-04",9034,"نقدي","تراب ناعم",16,3.125,50]
["A-28","2020-04-04",9035,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-29","2020-04-04",9036,"نقدي","تراب ناعم",16,3.125,50]
["A-30","2020-04-04",9037,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-31","2020-04-04",9038,"واسيم  - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-32","2020-04-04",9039,"نقدي","تراب ناعم",16,3.125,50]
["A-33","2020-04-04",9040,"واسيم  - شركة القلابات","تراب ناعم",16,3.125,50]
["A-34","2020-05-04",9041,"حسين  - شركة القلابات","تراب ناعم",32,3.125,100]
["A-35","2020-05-04",9042,"نقدي","خرسانة 3/4",24,26.666666666666668,640]
["A-36","2020-05-04",9043,"راشد الاسمري - ايجار معدات","خرسانة 3/4",16,27.5,440]
["A-37","2020-05-04",9044,"راشد الاسمري - ايجار معدات","خرسانة 3/4",8,36.25,290]
["A-38","2020-05-04",9045,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-39","2020-05-04",9046,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-40","2020-05-04",9047,"اكرام - شركة القلابات","خرسانة 3/4",16,27.5,440]
["A-41","2020-06-04",9048,"نقدي","خرسانة 3/8",8,36.25,290]
["A-42","2020-06-04",9049,"نقدي","خرسانة 3/8",24,26.666666666666668,640]
["A-43","2020-06-04",9050,"نقدي","خرسانة 3/8",16,27.5,440]
["A-44","2020-06-04",9051,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-45","2020-06-04",9052,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-46","2020-06-04",9053,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-47","2020-06-04",9054,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-48","2020-06-04",9055,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-49","2020-06-04",9056,"نعيم - شركة القلابات","تراب ناعم",8,31.25,250]
["A-50","2020-06-04",9057,"راشد الاسمري - ايجار معدات","خرسانة 3/8",16,27.5,440]
["A-51","2020-06-04",9058,"نزير - شركة القلابات","تراب ناعم",16,3.125,50]
["A-52","2020-07-04",9059,"عثمان - شركة القلابات","خرسانة 3/8",16,27.5,440]
["A-53","2020-07-04",9060,"ظافر النماص","خرسانة 3/4",16,27.5,440]
["A-54","2020-07-04",9061,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-55","2020-07-04",9062,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-56","2020-07-04",9063,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-57","2020-07-04",9064,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-58","2020-07-04",9065,"مصنع العسيري","خرسانة 3/8",24,22.916666666666668,550]
["A-59","2020-08-04",9066,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-60","2020-08-04",9067,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-61","2020-08-04",9068,"مصنع العسيري","خرسانة 3/4",24,22.916666666666668,550]
["A-62","2020-08-05",9069,"ملغية","ملغية",0,"-",0]
["A-63","2020-08-06",9070,"ملغية","ملغية",0,"-",0]
["A-64","2020-08-04",9071,"عثمان - شركة القلابات","خرسانة 3/8",16,27.5,440]
["A-65","2020-09-04",9072,"مصنع العسيري","خرسانة 3/8",24,{"$f":"IFERROR(H67/F67,\"-\")","v":29.166666666666668},700]
["A-66","2020-09-04",9073,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-67","2020-09-04",9074,"عثمان - شركة القلابات","خرسانة 3/4",null,"-",540]
["A-68","2020-09-04",9075,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-69","2020-09-04",9076,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-70","2020-11-04",9077,"نقليات سلطان مردح","خرسانة 3/4",16,33.75,540]
["A-71","2020-11-04",9078,"نقدي","تراب ناعم",16,3.125,50]
["A-72","2020-11-04",9079,"نقدي","خرسانة 3/4",16,33.75,540]
["A-73","2020-11-04",9080,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-74","2020-11-04",9081,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-75","2020-11-04",9082,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-76","2020-11-04",9083,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-77","2020-11-04",9084,"نقليات سلطان مردح","خرسانة 3/4",16,33.75,540]
["A-78","2020-11-04",9085,"مخرطة إسحاق","خرسانة 3/4",24,35.416666666666664,850]
["A-79","2020-11-04",9086,"مؤسسة بن دروم","خرسانة 3/4",8,43.75,350]
["A-80","2020-12-04",9087,"مخرطة إسحاق","خرسانة 3/4",24,35.416666666666664,850]
["A-81","2020-12-04",9088,"واسيم  - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-82","2020-12-04",9089,"نعيم - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-83","2020-12-04",9090,"نقدي","خرسانة 3/4",8,36.25,290]
["A-84","2020-12-04",9091,"نعيم - شركة القلابات","تراب ناعم",16,3.125,50]
["A-85","2020-12-04",9092,"نقدي","خرسانة 3/4",16,33.75,540]
["A-86","2020-12-04",9093,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-87","2020-12-04",9094,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-88","2020-12-04",9095,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-89","2020-12-04",9096,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-90","2020-12-04",9097,"محمد اشرف - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-91","2020-12-04",9098,"نعيم - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-92","2020-12-04",9099,"نقدي","تراب ناعم",16,3.125,50]
["A-93","2020-12-04",9100,"نقدي","خرسانة 3/4",16,33.75,540]
["A-94","13/4/2020",9101,"نقدي","خرسانة 3/4",16,33.75,540]
["A-95","13/4/2020",9102,"نقدي","خرسانة 3/4",16,33.75,540]
["A-96","13/4/2020",9103,"ملغية","ملغية",0,"-",0]
["A-97","13/4/2020",9104,"واسيم  - شركة القلابات","تراب ناعم",16,3.125,50]
["A-98","13/4/2020",9105,"محمد اشرف - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-99","13/4/2020",9106,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-100","13/4/2020",9107,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-101","13/4/2020",9108,"واسيم  - شركة القلابات","تراب ناعم",80,3.125,250]
["A-102","13/4/2020",9109,"مخرطة إسحاق","خرسانة 3/4",24,35.416666666666664,850]
["A-103","13/4/2020",9110,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-104","13/4/2020",9111,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-105","13/4/2020",9112,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-106","13/4/2020",9113,"نقدي","تراب ناعم",32,3.125,100]
["A-107","14/4/2020",9114,"نقدي","خرسانة 3/4",16,33.75,540]
["A-108","14/4/2020",9115,"نقدي","خرسانة 3/4",16,33.75,540]
["A-109","14/4/2020",9116,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-110","14/4/2020",9117,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-99","14/4/2020",9118,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-100","14/4/2020",9119,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-101","14/4/2020",9120,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-102","15/4/2020",9121,"ناصر - شركة القلابات","خرسانة 3/4",24,35.416666666666664,850]
["A-103","15/4/2020",9122,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-104","15/4/2020",9123,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-105","15/4/2020",9124,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-106","15/4/2020",9125,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-107","15/4/2020",9126,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-108","16/4/2020",9127,"نقدي","خرسانة 3/4",16,33.75,540]
["A-109","16/4/2020",9128,"ناصر - شركة القلابات","خرسانة 3/4",26,31.923076923076923,830]
["A-110","16/4/2020",9129,"نقدي","خرسانة 3/4",16,33.75,540]
["A-111","16/4/2020",9130,"نقدي","خرسانة 3/4",16,33.75,540]
["A-112","16/4/2020",9131,"نقدي","خرسانة 3/8",16,33.75,540]
["A-113","16/4/2020",9132,"نقدي","خرسانة 3/4",16,33.75,540]
["A-114","16/4/2020",9133,"نقدي","خرسانة 3/4",16,33.75,540]
["A-115","16/4/2020",9134,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-116","16/4/2020",9135,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-117","16/4/2020",9136,"واسيم  - شركة القلابات","تراب ناعم",80,{"$f":"IFERROR(H131/F131,\"-\")","v":3.125},250]
["A-118","16/4/2020",9137,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-119","16/4/2020",9138,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-120","18/4/2020",9139,"مخرطة إسحاق","خرسانة 3/4",24,35.416666666666664,850]
["A-121","18/4/2020",9140,"مخرطة إسحاق","خرسانة 3/4",24,35.416666666666664,850]
["A-122","18/4/2020",9141,"نزير - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-123","18/4/2020",9142,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-124","18/4/2020",9143,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-125","18/4/2020",9144,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-126","18/4/2020",9145,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-127","18/4/2020",9146,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-128","18/4/2020",9147,"نزير - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-129","18/4/2020",9148,"نزير - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-130","19/4/2020",9149,"محمد اشرف - شركة القلابات","تراب ناعم",16,3.125,50]
["A-131","19/4/2020",9150,"نزير - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-132","19/4/2020",9151,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-133","19/4/2020",9152,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-134","19/4/2020",9153,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-135","19/4/2020",9154,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-136","19/4/2020",9155,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-137","19/4/2020",9156,"نزير - شركة القلابات","تراب ناعم",16,3.125,50]
["A-138","19/4/2020",9157,"محمد اشرف - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-139","19/4/2020",9158,"نقدي","خرسانة 3/4",16,33.75,540]
["A-140","19/4/2020",9159,"نقدي","خرسانة 3/4",16,33.75,540]
["A-141","20/4/2020",9160,"نقدي","خرسانة 3/8",24,36.25,870]
["A-142","20/4/2020",9161,"نقدي","خرسانة 3/8",24,36.25,870]
["A-143","21/4/2020",9162,"واسيم  - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-144","21/4/2020",9163,"نقدي","خرسانة 3/4",16,33.75,540]
["A-145","21/4/2020",9164,"نقدي","خرسانة 3/4",16,33.75,540]
["A-146","21/4/2020",9165,"نقدي","خرسانة 3/4",16,33.75,540]
["A-147","21/4/2020",9166,"واسيم  - شركة القلابات","خرسانة 3/4",24,34.583333333333336,830]
["A-148","21/4/2020",9167,"واسيم  - شركة القلابات","خرسانة 3/4",16,28.125,450]
["A-149","21/4/2020",9168,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-150","21/4/2020",9169,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-151","21/4/2020",9170,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-152","21/4/2020",9171,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-153","21/4/2020",9172,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-154","21/4/2020",9173,"نقدي","تراب ناعم",16,3.125,50]
["A-155","22/04/2020",9174,"نعيم - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-156","  ",9175,"واسيم  - شركة القلابات","خرسانة 3/4",16,28.125,450]
["A-157","22/04/2020",9176,"نقدي","خرسانة 3/8",24,32.5,780]
["A-158","22/04/2020",9177,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-159","22/04/2020",9178,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-160","22/04/2020",9179,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-161","22/04/2020",9180,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-162","22/04/2020",9181,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-163","23/4/2020",9182,"نقدي","خرسانة 3/4",16,33.75,540]
["A-164","23/4/2020",9183,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-165","23/4/2020",9184,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-166","23/4/2020",9185,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-167","23/4/2020",9186,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-168","23/4/2020",9187,"ناصر - شركة القلابات","خرسانة 3/4",18,28.888888888888889,520]
["A-169","23/4/2020",9187,"نقدي","خرسانة 3/4",8,38.75,310]
["A-170","25/4/2020",9188,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-171","25/4/2020",9189,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-172","25/4/2020",9190,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-173","25/4/2020",9191,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-174","25/4/2020",9192,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-175","25/4/2020",9193,"عثمان - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-176","25/4/2020",9194,"نقدي","تراب ناعم",16,3.125,50]
["A-177","25/4/2020",9195,"راشد الاسمري - ايجار معدات","خرسانة 3/4",16,33.75,540]
["A-178","25/4/2020",9196,"واسيم  - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-179","26/4/2020",9197,"نقدي","خرسانة 3/4",16,33.75,540]
["A-180","26/4/2020",9198,"نقدي","خرسانة 3/4",16,33.75,540]
["A-181","26/4/2020",9199,"نقدي","خرسانة 3/4",16,33.75,540]
["A-182","26/4/2020",9200,"نقدي","خرسانة 3/4",16,33.75,540]
["A-183","26/4/2020",9201,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-184","26/4/2020",9202,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-185","26/4/2020",9203,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-186","27/4/2020",9204,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-187","27/4/2020",9205,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-188","27/4/2020",9206,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-189","27/4/2020",9207,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-190","28/4/2020",9208,"نقدي","خرسانة 3/4",16,33.75,540]
["A-191","28/4/2020",9209,"نقدي","خرسانة 3/4",16,33.75,540]
["A-192","28/4/2020",9210,"عثمان - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-193","28/4/2020",9211,"نقدي","خرسانة 3/4",16,33.75,540]
["A-194","28/4/2020",9212,"نعيم - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-195","28/4/2020",9213,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-196","28/4/2020",9214,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-197","28/4/2020",9215,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-198","28/4/2020",9216,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-199","28/4/2020",9217,"نقدي","خرسانة 3/4",16,33.75,540]
["A-200","28/4/2020",9218,"عثمان - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-201","29/4/2020",9219,"نقدي","خرسانة 3/4",16,33.75,540]
["A-202","29/4/2020",9220,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-203","29/4/2020",9221,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-204","29/4/2020",9222,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-205","29/4/2020",9223,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-206","30/4/2020",9224,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-207","30/4/2020",9225,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-208","30/4/2020",9226,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-209","30/4/2020",9227,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-210","30/4/2020",9228,"عثمان - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-211","30/4/2020",9229,"نقدي","خرسانة 3/4",16,33.75,540]
["A-212","30/4/2020",9230,"نقدي","خرسانة 3/4",16,33.75,540]
[null,"TOTAL",null,null,null,{"$f":"SUBTOTAL(109,F3:F226)","v":4708},null,{"$f":"SUBTOTAL(109,H3:H226)","v":120460}]
[null,null,null,"نقدي",null,{"$f":"SUMIF($D$3:$D$226,D228,$F$3:$F$226)","v":928},{"$f":"IFERROR(H228/F228,\"-\")","v":24.375},{"$f":"SUMIF($D$3:$D$226,D228,$H$3:$H$226)","v":22620}]
[null,null,null,"راشد الاسمري - ايجار معدات",null,56,30.535714285714285,1710]
[null,null,null,"حسين  - شركة القلابات",null,112,3.125,350]
[null,null,null,"واسيم  - شركة القلابات",null,392,12.831632653061224,5030]
[null,null,null,"مؤسسة بن دروم",null,8,43.75,350]
[null,null,null,"عثمان - شركة القلابات",null,96,37.291666666666664,3580]
[null,null,null,"نعيم - شركة القلابات",null,104,27.884615384615383,2900]
[null,null,null,"مصنع العسيري",null,2568,27.531152647975077,70700,{"$f":"H235-8250-7250","v":55200}]
[null,null,null,"نزير - شركة القلابات",null,96,23.541666666666668,2260]
[null,null,null,"ظافر النماص",null,16,27.5,440]
[null,null,null,"اكرام - شركة القلابات",null,32,27.5,880]
[null,null,null,"نقليات سلطان مردح",null,32,33.75,1080]
[null,null,null,"مخرطة إسحاق",null,120,35.416666666666664,4250]
[null,null,null,"محمد اشرف - شركة القلابات",null,64,26.09375,1670]
[null,null,null,"ناصر - شركة القلابات",null,84,31.428571428571427,2640]
["TOTAL",null,null,null,null,{"$f":"SUM(F228:F242)","v":4708},{"$f":"SUBTOTAL(109,G3:G242)","v":6266.4924022119103},{"$f":"SUM(H228:H242)","v":120460}]
[null,null,null,null,"القيمة المضافة","الإيرادات","المبيعات"]
[null,null,null,null,{"$f":"G245-F245","v":5736.190476190488},{"$f":"G245/1.05","v":114723.80952380951},{"$f":"H227","v":120460}]
[]
[]
[]
[null,null,null,null,"نوع المواد","QUANTITY","PRICE","AMOUNT","الإيرادات","VAT"]
[null,null,null,null,"خرسانة 3/4",{"$f":"SUMIF($E$3:$E$243,E250,$F$3:$F$243)","v":2588},{"$f":"IFERROR(H250/F250,\"-\")","v":30.278207109737249},{"$f":"SUMIF($E$3:$E$243,E250,$H$3:$H$243)","v":78360},{"$f":"H250/1.05","v":74628.57142857142},{"$f":"I250*0.05","v":3731.4285714285711}]
[null,null,null,null,"خرسانة 3/8",{"$f":"SUMIF($E$3:$E$243,E251,$F$3:$F$243)","v":1408},{"$f":"IFERROR(H251/F251,\"-\")","v":28.160511363636363},{"$f":"SUMIF($E$3:$E$243,E251,$H$3:$H$243)","v":39650},{"$f":"H251/1.05","v":37761.904761904763},{"$f":"I251*0.05","v":1888.0952380952383}]
[null,null,null,null,"تراب ناعم",{"$f":"SUMIF($E$3:$E$243,E252,$F$3:$F$243)","v":712},{"$f":"IFERROR(H252/F252,\"-\")","v":3.441011235955056},{"$f":"SUMIF($E$3:$E$243,E252,$H$3:$H$243)","v":2450},{"$f":"H252/1.05","v":2333.333333333333},{"$f":"I252*0.05","v":116.66666666666666}]
[]
[null,null,null,null,"اجمالى",{"$f":"SUM(F250:F252)","v":4708},null,{"$f":"SUM(H250:H252)","v":120460},{"$f":"SUM(I250:I252)","v":114723.80952380951},{"$f":"SUM(J250:J252)","v":5736.1904761904761}]

{"sheet":"مايو","index":6,"n_rows":170,"n_cols":25,"rows_kept":170,"cut":false,"hidden":false,"merged":[[14,19,14,21],[0,0,0,7],[1,9,1,17],[1,19,1,21],[1,22,1,24],[3,23,12,23]]}
["تقرير مبيعات كسارة مايو 2020"]
["S.N","DATE","NUMBER","العميل","نوع المواد","QUANTITY","PRICE","AMOUNT",null,"بيان بقيمة الخرسانة المحملة علي شركة القلابات عن شهر ديسمبر 2019م ",null,null,null,null,null,null,null,null,null,"اجمالى المبييعات",null,null,{"$f":"H149","v":16550}]
["A-1","2020-02-05",9231,"نعيم - شركة القلابات","خرسانة 3/4",16,{"$f":"IFERROR(H3/F3,\"-\")","v":33.75},540,null,"الإجمالي ","واسيم  - شركة القلابات","محمد اشرف - شركة القلابات","نعيم - شركة القلابات","اكرام - شركة القلابات","ناصر - شركة القلابات","العمري - شركة القلابات","عثمان - شركة القلابات","نزير - شركة القلابات",null,"مسلسل","التاريخ","رقم المستند","ايداع","الرصيد المتبقى","ملاحظات"]
["A-2","2020-02-05",9232,"نقدي","خرسانة 3/4",16,33.75,540,null,{"$f":"SUM(K4:R4)","v":14410},{"$f":"SUMIF(D3:D147,K3:R3,H3:H147)","v":3100},{"$f":"SUMIF(D3:D147,K3:R3,H3:H147)","v":2750},{"$f":"SUMIF(D3:D147,K3:R3,H3:H147)","v":5260},{"$f":"SUMIF(D3:D147,K3:R3,H3:H147)","v":0},{"$f":"SUMIF(D3:D147,K3:R3,H3:H147)","v":0},{"$f":"SUMIF(D3:D147,K3:R3,H3:H147)","v":0},{"$f":"SUMIF(D3:D147,K3:R3,H3:H147)","v":2700},{"$f":"SUMIF(D3:D147,K3:R3,H3:H147)","v":600},null,null,"2020-06-02",null,4425,{"$f":"W2-W15","v":1970},"ايداع في حساب الشركة "]
["A-3","2020-02-05",9233,"نقدي","خرسانة 3/4",16,33.75,540,null,null,null,null,null,null,null,null,null,null,null,null,"13/02/2020",null,3520,null,"ايداع في حساب الشركة "]
["A-4","2020-02-05",9234,"نقدي","خرسانة 3/4",16,33.75,540,null,null,null,null,null,null,null,null,null,null,null,null,"16/02/2020",null,2000,null,"ايداع في حساب الشركة "]
["A-5","2020-02-05",9235,"عثمان - شركة القلابات","خرسانة 3/4",16,33.75,540,null,null,null,null,null,null,null,null,null,null,null,null,"16/02/2020",null,2005,null,"ايداع في حساب الشركة "]
["A-6","2020-02-05",9236,"واسيم  - شركة القلابات","تراب ناعم",16,3.125,50,null,null,null,null,null,null,null,null,null,null,null,null,"23/02/2020",null,2630,null,"ايداع في حساب الشركة "]
["A-7","2020-03-05",9237,"نقدي","خرسانة 3/4",16,33.75,540,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["A-8","2020-03-05",9238,"عثمان - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-9","2020-03-05",9239,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-10","2020-03-05",9240,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-11","2020-03-05",9241,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-12","2020-03-05",9242,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-13","2020-03-05",9243,"راشد الاسمري - ايجار معدات","خرسانة 3/8",8,43.75,350,null,null,null,null,null,null,null,null,null,null,null,"اجمالى الايداعات",null,null,{"$f":"SUM(W4:W14)","v":14580}]
["A-14","2020-03-05",9244,"نقدي","خرسانة 3/4",16,33.75,540]
["A-15","2020-04-05",9245,"نقدي","تراب ناعم",16,3.125,50]
["A-16","2020-04-05",9246,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-17","2020-04-05",9247,"نقدي","خرسانة 3/4",16,34.375,550]
["A-18","2020-04-05",9248,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-19","2020-04-05",9249,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-20","2020-04-05",9250,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-21","2020-04-05",9251,"عثمان - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-22","2020-05-05",9252,"محمد اشرف - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-23","2020-05-05",9253,"نقدي","خرسانة 3/4",16,33.75,540]
["A-24","2020-05-05",9254,"نقدي","خرسانة 3/4",16,33.75,540]
["A-25","2020-05-05",9255,"نقدي","خرسانة 3/4",16,33.75,540]
["A-26","2020-05-05",9256,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-27","2020-05-05",9257,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-28","2020-05-05",9258,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-29","2020-06-05",9259,"محمد اشرف - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-30","2020-06-05",9260,"نقدي","خرسانة 3/4",16,33.75,540]
["A-31","2020-06-05",9261,"نقدي","تراب ناعم",16,3.125,50]
["A-32","2020-06-05",9262,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-33","2020-06-05",9263,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-34","2020-06-05",9264,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-35","2020-06-05",9265,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-36","2020-07-05",9266,"واسيم  - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-37","2020-07-05",9267,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-38","2020-07-05",9268,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-39","2020-07-05",9269,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-40","2020-07-05",9270,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-41","2020-07-05",9271,"عثمان - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-42","2020-09-05",9272,"عثمان - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-43","2020-10-05",9273,"نقدي","تراب ناعم",32,3.125,100]
["A-44","2020-10-05",9274,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-45","2020-10-05",9275,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-46","2020-10-05",9276,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-47","2020-10-05",9277,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-48","2020-10-05",9278,"نقدي","تراب ناعم",32,3.125,100]
["A-49","2020-11-05",9279,"نقدي","تراب ناعم",16,3.125,50]
["A-50","2020-11-05",9280,"نقدي","خرسانة 3/4",16,33.75,540]
["A-51","2020-11-05",9281,"نقدي","تراب ناعم",16,6.25,100]
["A-52","2020-11-05",9282,"نقدي","خرسانة 3/4",16,33.75,540]
["A-53","2020-11-05",9283,"نقدي","خرسانة 3/4",16,33.75,540]
["A-54","2020-11-05",9284,"نقدي","خرسانة 3/4",16,33.75,540]
["A-55","2020-11-05",9285,"نقدي","خرسانة 3/4",16,33.75,540]
["A-56","2020-11-05",9286,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-57","2020-11-05",9287,"واسيم  - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-58","2020-12-05",9288,"محمد اشرف - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-59","2020-12-05",9289,"نزير - شركة القلابات","تراب ناعم",16,3.125,50]
["A-60","2020-12-05",9290,"نعيم - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-61","2020-12-05",9291,"محمد اشرف - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-62","2020-12-05",9292,"نزير - شركة القلابات","تراب ناعم",32,3.125,100]
["A-63","2020-12-05",9293,"نعيم - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-64","2020-12-05",9294,"نعيم - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-65","2020-05-13",9295,"نزير - شركة القلابات","تراب ناعم",48,{"$f":"IFERROR(H67/F67,\"-\")","v":3.125},150]
["A-66","2020-05-13",9296,"واسيم  - شركة القلابات","تراب ناعم",16,3.125,50]
["A-67","2020-05-13",9297,"نقدي","خرسانة 3/4",14,35.714285714285715,500]
["A-68","2020-05-13",9298,"نعيم - شركة القلابات","تراب ناعم",32,3.125,100]
["A-69","2020-05-13",9299,"عابد الله - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-70","2020-04-14",9300,"ظافر النماص","بودرة",16,28.125,450]
["A-71","2020-04-14",9301,"نقدي","تراب ناعم",32,3.125,100]
["A-72","2020-04-14",9302,"نعيم - شركة القلابات","تراب ناعم",48,3.125,150]
["A-73","2020-04-14",9303,"محمد اشرف - شركة القلابات","تراب ناعم",16,3.125,50]
["A-74","2020-04-14",9304,"محمد اشرف - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-75","2020-04-14",9305,"نزير - شركة القلابات","تراب ناعم",48,3.125,150]
["A-76","2020-04-14",9306,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-77","2020-04-14",9307,"ظافر النماص","بودرة",16,28.125,450]
["A-78","2020-04-14",9308,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-79","2020-05-16",9309,"نعيم - شركة القلابات","تراب ناعم",48,3.125,150]
["A-80","2020-05-16",9310,"نزير - شركة القلابات","تراب ناعم",48,3.125,150]
["A-81","2020-05-16",9311,"نقدي","خرسانة 3/4",16,33.75,540]
["A-82","2020-05-16",9312,"نقدي","خرسانة 3/4",16,33.75,540]
["A-83","2020-05-16",9313,"ظافر النماص","بودرة",16,28.125,450]
["A-84","2020-05-16",9314,"واسيم  - شركة القلابات","تراب ناعم",80,3.125,250]
["A-85","2020-05-16",9315,"ظافر النماص","بودرة",16,28.125,450]
["A-86","2020-05-16",9316,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-87","2020-05-16",9317,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-88","2020-05-16",9318,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-89","2020-05-16",9319,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-90","2020-05-16",9320,"راشد الاسمري - ايجار معدات","خرسانة 3/4",16,33.75,540]
["A-91","2020/15/17",9321,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-92","2020/15/17",9322,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-93","2020-05-18",9323,"نقدي","خرسانة 3/4",16,33.75,540]
["A-94","2020-05-18",9324,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-95","2020-05-18",9325,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-96","2020-05-18",9326,"نقدي","خرسانة 3/4",16,33.75,540]
["A-97","2020-05-18",9327,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-98","2020-05-19",9328,"نقدي","خرسانة 3/4",16,33.75,540]
["A-99","2020-05-19",9329,"نقدي","تراب ناعم",80,3.125,250]
["A-100","2020-05-19",9330,"واسيم  - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-101","2020-05-19",9331,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-102","2020-05-19",9332,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-103","2020-05-19",9333,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-104","2020-05-19",9334,"نقدي","تراب ناعم",16,3.125,50]
["A-105","2020-05-19",9335,"ملغية","خرسانة 3/8",0,"-",0,24]
["A-106","2020-05-19",9336,"واسيم  - شركة القلابات","خرسانة 3/8",16,33.75,540]
["A-107","2020-05-20",9337,"نقدي","تراب ناعم",32,3.125,100]
["A-108","2020-05-20",9338,"نعيم - شركة القلابات","خرسانة 3/8",16,33.75,540]
["A-109","2020-05-20",9339,"سعيد جذينان","خرسانة 3/4",24,25,600]
["A-110","2020-05-20",9340,"سعيد جذينان","خرسانة 3/4",24,25,600]
["A-99","2020-05-20",9341,"سعيد جذينان","خرسانة 3/4",24,25,600]
["A-100","2020-05-20",9342,"سعيد جذينان","خرسانة 3/4",24,25,600]
["A-101","2020-05-20",9343,"سعيد جذينان","خرسانة 3/4",24,25,600]
["A-102","2020-05-20",9344,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-103","2020-05-20",9345,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-104","2020-05-20",9346,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-105","2020-05-20",9347,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-106","2020-05-20",9348,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-107","2020-05-20",9349,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-108","2020-05-20",9350,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-109","2020-05-20",9351,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-110","2020-05-20",9352,"نقدي","تراب ناعم",16,3.125,50]
["A-111","2020-05-20",9353,"نقدي","خرسانة 3/4",16,33.75,540]
["A-112","2020-05-21",9354,"نعيم - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-113","2020-05-21",9355,"نعيم - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-114","2020-05-21",9356,"نقدي","تراب ناعم",16,3.125,50]
["A-115","2020-05-28",9357,"نقدي","خرسانة 3/4",16,33.75,540]
["A-116","2020-05-28",9358,"واسيم  - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-117","2020-05-28",9359,"واسيم  - شركة القلابات","تراب ناعم",16,{"$f":"IFERROR(H131/F131,\"-\")","v":3.125},50]
["A-118","2020-05-28",9360,"نعيم - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-119","2020-05-30",9361,"نعيم - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-120","2020-05-30",9362,"نقدي","تراب ناعم",16,3.125,50]
["A-121","2020-05-30",9363,"نقدي","خرسانة 3/8",8,43.75,350]
["A-122","2020-05-30",9364,"نقدي","خرسانة 3/8",16,31.25,500]
["A-123","2020-05-30",9365,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-124","2020-05-30",9366,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-125","2020-05-31",9367,"ظافر النماص","خرسانة 3/4",16,28.125,450]
["A-126","2020-05-31",9368,"نقدي","خرسانة 3/4",16,33.75,540]
["A-127","2020-05-31",9369,"نقدي","خرسانة 3/4",16,33.75,540]
["A-128","2020-05-31",9370,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-129","2020-05-31",9371,"نقدي","خرسانة 3/4",16,33.75,540]
["A-130","2020-05-31",9372,"نقدي","خرسانة 3/4",16,33.75,540]
["A-131","2020-05-31",9373,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-132","2020-05-31",9374,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-133","2020-05-31",9375,"نقدي","تراب ناعم",16,3.125,50]
[null,"TOTAL",null,null,null,{"$f":"SUBTOTAL(109,F3:F147)","v":3118},null,{"$f":"SUBTOTAL(109,H3:H147)","v":73340}]
[null,null,null,"نقدي",null,{"$f":"SUMIF($D$3:$D$147,D149,$F$3:$F$147)","v":806},{"$f":"IFERROR(H149/F149,\"-\")","v":20.533498759305211},{"$f":"SUMIF($D$3:$D$147,D149,$H$3:$H$147)","v":16550}]
[null,null,null,"راشد الاسمري - ايجار معدات",null,24,37.083333333333336,890]
[null,null,null,"واسيم  - شركة القلابات",null,208,14.903846153846153,3100]
[null,null,null,"عثمان - شركة القلابات",null,80,33.75,2700]
[null,null,null,"نعيم - شركة القلابات",null,272,19.338235294117649,5260]
[null,null,null,"مصنع العسيري",null,1224,29.166666666666668,35700]
[null,null,null,"نزير - شركة القلابات",null,192,3.125,600]
[null,null,null,"عابد الله - شركة القلابات",null,16,33.75,540]
[null,null,null,"ظافر النماص",null,80,28.125,2250]
[null,null,null,"محمد اشرف - شركة القلابات",null,96,28.645833333333332,2750]
[null,null,null,"سعيد جذينان",null,120,25,3000]
["TOTAL",null,null,null,null,{"$f":"SUM(F149:F159)","v":3118},{"$f":"SUBTOTAL(109,G3:G158)","v":3999.1356992548849},{"$f":"SUM(H149:H159)","v":73340}]
[null,null,null,null,"القيمة المضافة","الإيرادات","المبيعات"]
[null,null,null,null,{"$f":"G162-F162","v":3492.3809523809614},{"$f":"G162/1.05","v":69847.619047619039},{"$f":"H148","v":73340}]
[]
[]
[null,null,null,null,"نوع المواد","QUANTITY","PRICE","AMOUNT","الإيرادات","VAT"]
[null,null,null,null,"خرسانة 3/4",{"$f":"SUMIF($E$3:$E$159,E166,$F$3:$F$159)","v":1262},{"$f":"IFERROR(H166/F166,\"-\")","v":31.743264659270999},{"$f":"SUMIF($E$3:$E$159,E166,$H$3:$H$159)","v":40060},{"$f":"H166/1.05","v":38152.380952380954},{"$f":"I166*0.05","v":1907.6190476190477}]
[null,null,null,null,"خرسانة 3/8",{"$f":"SUMIF($E$3:$E$159,E167,$F$3:$F$159)","v":976},{"$f":"IFERROR(H167/F167,\"-\")","v":29.590163934426229},{"$f":"SUMIF($E$3:$E$159,E167,$H$3:$H$159)","v":28880},{"$f":"H167/1.05","v":27504.761904761905},{"$f":"I167*0.05","v":1375.2380952380954}]
[null,null,null,null,"تراب ناعم",{"$f":"SUMIF($E$3:$E$159,E168,$F$3:$F$159)","v":816},{"$f":"IFERROR(H168/F168,\"-\")","v":3.1862745098039214},{"$f":"SUMIF($E$3:$E$159,E168,$H$3:$H$159)","v":2600},{"$f":"H168/1.05","v":2476.1904761904761},{"$f":"I168*0.05","v":123.80952380952381}]
[null,null,null,null,"بودرة",{"$f":"SUMIF($E$3:$E$159,E169,$F$3:$F$159)","v":64},{"$f":"IFERROR(H169/F169,\"-\")","v":28.125},{"$f":"SUMIF($E$3:$E$159,E169,$H$3:$H$159)","v":1800},{"$f":"H169/1.05","v":1714.2857142857142},{"$f":"I169*0.05","v":85.714285714285722}]
[null,null,null,null,"اجمالى",{"$f":"SUM(F166:F169)","v":3118},null,{"$f":"SUM(H166:H169)","v":73340},{"$f":"SUM(I166:I169)","v":69847.619047619039},{"$f":"SUM(J166:J169)","v":3492.3809523809527}]

{"sheet":"يونية","index":7,"n_rows":254,"n_cols":25,"rows_kept":254,"cut":false,"hidden":false,"merged":[[14,19,14,21],[0,0,0,7],[1,9,1,17],[1,19,1,21],[1,22,1,24],[3,23,12,23]]}
["تقرير مبيعات كسارة يونية 2020"]
["S.N","DATE","NUMBER","العميل","نوع المواد","QUANTITY","PRICE","AMOUNT",null,"بيان بقيمة الخرسانة المحملة علي شركة القلابات عن شهر ديسمبر 2019م ",null,null,null,null,null,null,null,null,null,"اجمالى المبييعات",null,null,{"$f":"H234","v":48130}]
["A-1","2020-06-01",9376,"مصنع العسيري","خرسانة 3/8",24,{"$f":"IFERROR(H3/F3,\"-\")","v":29.166666666666668},700,null,"الإجمالي ","واسيم  - شركة القلابات","محمد اشرف - شركة القلابات","نعيم - شركة القلابات","اكرام - شركة القلابات","ناصر - شركة القلابات","العمري - شركة القلابات","عثمان - شركة القلابات","نزير - شركة القلابات",null,"مسلسل","التاريخ","رقم المستند","ايداع","الرصيد المتبقى","ملاحظات"]
["A-2","2020-06-01",9377,"نقدي","خرسانة 3/4",16,33.75,540,null,{"$f":"SUM(K4:R4)","v":9070},{"$f":"SUMIF(D3:D232,K3:R3,H3:H232)","v":150},{"$f":"SUMIF(D3:D232,K3:R3,H3:H232)","v":1580},{"$f":"SUMIF(D3:D232,K3:R3,H3:H232)","v":3000},{"$f":"SUMIF(D3:D232,K3:R3,H3:H232)","v":0},{"$f":"SUMIF(D3:D232,K3:R3,H3:H232)","v":0},{"$f":"SUMIF(D3:D232,K3:R3,H3:H232)","v":0},{"$f":"SUMIF(D3:D232,K3:R3,H3:H232)","v":1620},{"$f":"SUMIF(D3:D232,K3:R3,H3:H232)","v":2720},null,null,"2020-06-02",null,4425,{"$f":"W2-W15","v":33550},"ايداع في حساب الشركة "]
["A-3","2020-06-01",9378,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700,null,null,null,null,null,null,null,null,null,null,null,null,"13/02/2020",null,3520,null,"ايداع في حساب الشركة "]
["A-4","2020-06-01",9379,"عابد الله - شركة القلابات","خرسانة 3/8",16,33.75,540,null,null,null,null,null,null,null,null,null,null,null,null,"16/02/2020",null,2000,null,"ايداع في حساب الشركة "]
["A-5","2020-06-02",9380,"عابد الله - شركة القلابات","تراب ناعم",32,3.125,100,null,null,null,null,null,null,null,null,null,null,null,null,"16/02/2020",null,2005,null,"ايداع في حساب الشركة "]
["A-6","2020-06-02",9381,"هزار- شركة القلابات","تراب ناعم",16,3.125,50,null,null,null,null,null,null,null,null,null,null,null,null,"23/02/2020",null,2630,null,"ايداع في حساب الشركة "]
["A-7","2020-06-02",9382,"نقدي","خرسانة 3/4",16,33.75,540,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["A-8","2020-06-02",9383,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-9","2020-06-02",9384,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-10","2020-06-02",9385,"محمد اشرف - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-11","2020-06-02",9386,"محمد اشرف - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-12","2020-06-02",9387,"عابد الله - شركة القلابات","تراب ناعم",16,3.125,50]
["A-13","2020-06-02",9388,"واسيم  - شركة القلابات","تراب ناعم",32,3.125,100,null,null,null,null,null,null,null,null,null,null,null,"اجمالى الايداعات",null,null,{"$f":"SUM(W4:W14)","v":14580}]
["A-14","2020-06-02",9389,"عابد الله - شركة القلابات","تراب ناعم",16,3.125,50]
["A-15","2020-06-02",9390,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-16","2020-06-02",9391,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-17","2020-06-02",9392,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-18","2020-06-02",9393,"عابد الله - شركة القلابات","تراب ناعم",16,3.125,50]
["A-19","2020-06-03",9394,"نقدي","خرسانة 3/4",16,33.75,540]
["A-20","2020-06-03",9395,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-21","2020-06-03",9396,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-22","2020-06-03",9397,"نقدي","خرسانة 3/4",16,33.75,540]
["A-23","2020-06-03",9398,"نقدي","خرسانة 3/4",16,33.75,540]
["A-24","2020-06-03",9399,"نقدي","خرسانة 3/4",16,33.75,540]
["A-25","2020-06-03",9400,"نقدي","خرسانة 3/4",14,35.714285714285715,500]
["A-26","2020-06-03",9401,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-27","2020-06-03",9402,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-28","2020-06-03",9403,"نقدي","خرسانة 3/8",16,33.75,540]
["A-29","2020-06-03",9404,"نقدي","خرسانة 3/4",14,35.714285714285715,500]
["A-30","2020-06-04",9405,"نقدي","خرسانة 3/4",16,33.75,540]
["A-31","2020-06-04",9406,"نعيم - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-32","2020-06-04",9407,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-33","2020-06-04",9408,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-34","2020-06-04",9409,"نقدي","خرسانة 3/4",14,35.714285714285715,500]
["A-35","2020-06-04",9410,"نقدي","خرسانة 3/4",16,33.75,540]
["A-36","2020-06-04",9411,"نقدي","خرسانة 3/4",14,35.714285714285715,500]
["A-37","2020-06-04",9412,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-38","2020-06-04",9413,"نقدي","خرسانة 3/8",16,33.75,540]
["A-39","2020-06-04",9414,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-40","2020-06-06",9415,"نقدي","خرسانة 3/4",16,33.75,540]
["A-41","2020-06-06",9416,"نعيم - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-42","2020-06-06",9417,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-43","2020-06-06",9418,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-44","2020-06-06",9419,"نقدي","خرسانة 3/4",16,33.75,540]
["A-45","2020-06-06",9420,"نقدي","خرسانة 3/8",16,33.75,540]
["A-46","2020-06-06",9421,"راشد الاسمري - ايجار معدات","خرسانة 3/4",8,43.75,350]
["A-47","2020-06-06",9422,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-48","2020-06-06",9423,"نقدي","خرسانة 3/4",14,35.714285714285715,500]
["A-49","2020-06-06",9424,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-50","2020-06-06",9425,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-51","2020-06-06",9426,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-52","2020-06-06",9427,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-53","2020-06-06",9428,"نزير - شركة القلابات","تراب ناعم",16,3.125,50]
["A-54","2020-06-07",9429,"نقدي","خرسانة 3/4",16,33.75,540]
["A-55","2020-06-07",9430,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-56","2020-06-07",9431,"نقدي","خرسانة 3/4",16,34.375,550]
["A-57","2020-06-07",9432,"نقدي","خرسانة 3/8",16,33.75,540]
["A-58","2020-06-07",9433,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-59","2020-06-07",9434,"نقدي","خرسانة 3/4",16,33.75,540]
["A-60","2020-06-07",9435,"عابد الله - شركة القلابات","خرسانة 3/8",16,33.75,540]
["A-61","2020-06-08",9436,"نقدي","خرسانة 3/4",16,33.75,540]
["A-62","2020-06-08",9437,"عابد الله - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-63","2020-06-08",9438,"نعيم - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-64","2020-06-08",9439,"نقدي","خرسانة 3/8",16,33.75,540]
["A-65","2020-06-08",9440,"نقدي","خرسانة 3/8",16,{"$f":"IFERROR(H67/F67,\"-\")","v":33.75},540]
["A-66","2020-06-08",9441,"نزير - شركة القلابات","خرسانة 3/8",16,33.75,540]
["A-67","2020-06-08",9442,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-68","2020-06-08",9443,"نعيم - شركة القلابات","تراب ناعم",16,3.125,50]
["A-69","2020-06-08",9444,"نقدي","خرسانة 3/4",16,33.75,540]
["A-70","2020-06-08",9445,"واسيم  - شركة القلابات","تراب ناعم",16,3.125,50]
["A-71","2020-06-08",9446,"نقدي","خرسانة 3/4",8,42.5,340]
["A-72","2020-06-09",9447,"نقدي","خرسانة 3/4",16,33.75,540]
["A-73","2020-06-09",9448,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-74","2020-06-09",9449,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-75","2020-06-09",9450,"نزير - شركة القلابات","خرسانة 3/8",16,33.75,540]
["A-76","2020-06-09",9451,"نقدي","خرسانة 3/4",16,33.75,540]
["A-77","2020-06-09",9452,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-78","2020-06-09",9453,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-79","2020-06-09",9454,"نقدي","خرسانة 3/4",8,42.5,340]
["A-80","2020-06-09",9455,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-81","2020-06-09",9456,"هزار- شركة القلابات","تراب ناعم",16,3.125,50]
["A-82","2020-06-09",9457,"هزار- شركة القلابات","تراب ناعم",16,3.125,50]
["A-83","2020-06-09",9458,"نقدي","خرسانة 3/4",16,33.75,540]
["A-84","2020-06-09",9459,"نزير - شركة القلابات","خرسانة 3/8",16,33.75,540]
["A-85","2020-06-09",9460,"نقدي","خرسانة 3/4",16,33.75,540]
["A-86","2020-06-10",9461,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-87","2020-06-10",9462,"نقدي","خرسانة 3/4",16,33.75,540]
["A-88","2020-06-10",9463,"عثمان - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-89","2020-06-10",9464,"نقدي","خرسانة 3/4",16,34.375,550]
["A-90","2020-06-10",9465,"عابد الله - شركة القلابات","خرسانة 3/8",16,33.75,540]
["A-91","2020-06-10",9466,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-92","2020-06-10",9467,"نقدي","خرسانة 3/4",16,33.75,540]
["A-93","2020-06-10",9468,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-94","2020-06-10",9469,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-95","2020-06-10",9470,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-96","2020-06-10",9471,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-97","2020-06-11",9472,"نقدي","خرسانة 3/4",16,33.75,540]
["A-98","2020-06-11",9473,"نعيم - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-99","2020-06-11",9474,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-100","2020-06-11",9475,"نعيم - شركة القلابات","تراب ناعم",16,3.125,50]
["A-101","2020-06-11",9476,"نقدي","خرسانة 3/4",16,33.75,540]
["A-102","2020-06-11",9477,"نقدي","تراب ناعم",16,3.125,50]
["A-103","2020-06-11",9478,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-104","2020-06-11",9479,"نقدي","خرسانة 3/4",14,35.714285714285715,500]
["A-105","2020-06-13",9480,"نقدي","تراب ناعم",16,3.125,50]
["A-106","2020-06-13",9481,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-107","2020-06-13",9482,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-108","2020-06-13",9483,"نقدي","خرسانة 3/4",16,33.75,540]
["A-109","2020-06-13",9484,"نعيم - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-110","2020-06-13",9485,"هزار- شركة القلابات","تراب ناعم",16,3.125,50]
["A-99","2020-06-14",9486,"نقدي","تراب ناعم",16,3.125,50]
["A-100","2020-06-14",9487,"نقدي","تراب ناعم",16,3.125,50]
["A-101","2020-06-15",9488,"نزير - شركة القلابات","تراب ناعم",16,3.125,50]
["A-102","2020-06-15",9489,"نزير - شركة القلابات","تراب ناعم",16,3.125,50]
["A-103","2020-06-15",9490,"نزير - شركة القلابات","تراب ناعم",16,3.125,50]
["A-104","2020-06-15",9491,"نزير - شركة القلابات","تراب ناعم",16,3.125,50]
["A-105","2020-06-15",9492,"نزير - شركة القلابات","تراب ناعم",16,3.125,50]
["A-106","2020-06-16",9493,"نزير - شركة القلابات","تراب ناعم",16,3.125,50]
["A-107","2020-06-16",9494,"نزير - شركة القلابات","تراب ناعم",16,3.125,50]
["A-108","2020-06-17",9495,"محمد اشرف - شركة القلابات","تراب ناعم",16,3.125,50]
["A-109","2020-06-17",9496,"محمد اشرف - شركة القلابات","تراب ناعم",16,3.125,50]
["A-110","2020-06-17",9497,"محمد اشرف - شركة القلابات","تراب ناعم",16,3.125,50]
["A-111","2020-06-17",9498,"نزير - شركة القلابات","تراب ناعم",16,3.125,50]
["A-112","2020-06-17",9499,"نزير - شركة القلابات","تراب ناعم",16,3.125,50]
["A-113","2020-06-17",9500,"محمد اشرف - شركة القلابات","تراب ناعم",16,3.125,50]
["A-114","2020-06-18",9501,"نزير - شركة القلابات","تراب ناعم",16,3.125,50]
["A-115","2020-06-18",9502,"نزير - شركة القلابات","تراب ناعم",16,3.125,50]
["A-116","2020-06-18",9503,"نزير - شركة القلابات","تراب ناعم",16,3.125,50]
["A-117","2020-06-18",9504,"نزير - شركة القلابات","تراب ناعم",16,{"$f":"IFERROR(H131/F131,\"-\")","v":3.125},50]
["A-118","2020-06-18",9505,"نزير - شركة القلابات","تراب ناعم",16,3.125,50]
["A-119","2020-06-20",9506,"نقدي","خرسانة 3/4",16,33.75,540]
["A-120","2020-06-20",9507,"نعيم - شركة القلابات","تراب ناعم",16,3.125,50]
["A-121","2020-06-20",9508,"نزير - شركة القلابات","تراب ناعم",16,3.125,50]
["A-122","2020-06-20",9509,"نزير - شركة القلابات","تراب ناعم",16,3.125,50]
["A-123","2020-06-20",9510,"نزير - شركة القلابات","تراب ناعم",16,3.125,50]
["A-124","2020-06-21",9511,"نقدي","خرسانة 3/4",16,33.75,540]
["A-125","2020-06-21",9512,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-126","2020-06-21",9513,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-127","2020-06-21",9514,"نزير - شركة القلابات","تراب ناعم",16,3.125,50]
["A-128","2020-06-21",9515,"نزير - شركة القلابات","تراب ناعم",16,3.125,50]
["A-129","2020-06-21",9516,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-130","2020-06-21",9517,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-131","2020-06-21",9518,"نزير - شركة القلابات","تراب ناعم",16,3.125,50]
["A-132","2020-06-21",9519,"محمد اشرف - شركة القلابات","تراب ناعم",16,3.125,50]
["A-133","2020-06-21",9520,"نقدي","خرسانة 3/4",16,34.375,550]
["A-134","2020-06-21",9521,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-135","2020-06-21",9522,"نقدي","خرسانة 3/4",16,33.75,540]
["A-136","2020-06-22",9523,"نقدي","خرسانة 3/4",16,33.75,540]
["A-137","2020-06-22",9524,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-138","2020-06-22",9525,"نقدي","خرسانة 3/4",16,33.75,540]
["A-139","2020-06-22",9526,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-140","2020-06-22",9527,"نقدي","خرسانة 3/8",24,32.5,780]
["A-141","2020-06-22",9528,"نقدي","خرسانة 3/8",24,32.5,780]
["A-142","2020-06-22",9529,"نعيم - شركة القلابات","تراب ناعم",16,3.125,50]
["A-143","2020-06-22",9530,"نقدي","خرسانة 3/4",16,33.75,540]
["A-144","2020-06-22",9531,"محمد اشرف - شركة القلابات","تراب ناعم",16,3.125,50]
["A-145","2020-06-22",9532,"نقدي","خرسانة 3/4",16,33.75,540]
["A-146","2020-06-22",9533,"نعيم - شركة القلابات","تراب ناعم",16,3.125,50]
["A-147","2020-06-22",9534,"نعيم - شركة القلابات","تراب ناعم",16,3.125,50]
["A-148","2020-06-22",9535,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-149","2020-06-22",9536,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-150","2020-06-22",9537,"محمد اشرف - شركة القلابات","تراب ناعم",16,3.125,50]
["A-151","2020-06-22",9538,"محمد اشرف - شركة القلابات","تراب ناعم",16,3.125,50]
["A-152","2020-06-22",9539,"محمد اشرف - شركة القلابات","تراب ناعم",16,3.125,50]
["A-153","2020-06-22",9540,"نقدي","خرسانة 3/4",16,33.75,540]
["A-154","2020-06-22",9541,"نقدي","تراب ناعم",16,3.125,50]
["A-155","2020-06-22",9542,"محمد اشرف - شركة القلابات","تراب ناعم",16,3.125,50]
["A-156","2020-06-22",9543,"نقدي","خرسانة 3/4",14,35.714285714285715,500]
["A-157","2020-06-23",9544,"نقدي","خرسانة 3/4",16,33.75,540]
["A-158","2020-06-23",9545,"نقدي","خرسانة 3/4",16,33.75,540]
["A-159","2020-06-23",9546,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-160","2020-06-23",9547,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-161","2020-06-23",9548,"نقدي","خرسانة 3/4",16,33.75,540]
["A-162","2020-06-23",9549,"نقدي","تراب ناعم",16,3.125,50]
["A-163","2020-06-23",9550,"نزير - شركة القلابات","تراب ناعم",16,3.125,50]
["A-164","2020-06-23",9551,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-165","2020-06-23",9552,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-166","2020-06-23",9553,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-167","2020-06-24",9554,"نقدي","تراب ناعم",16,3.125,50]
["A-168","2020-06-24",9555,"نقدي","تراب ناعم",16,3.125,50]
["A-169","2020-06-25",9556,"نقدي","تراب ناعم",16,3.125,50]
["A-170","2020-06-27",9557,"نقدي","خرسانة 3/4",16,33.75,540]
["A-171","2020-06-27",9558,"نقدي","خرسانة 3/4",16,3.125,50]
["A-172","2020-06-27",9559,"نقدي","تراب ناعم",16,33.75,540]
["A-173","2020-06-27",9560,"نقدي","خرسانة 3/4",16,33.75,540]
["A-174","2020-06-27",9561,"نقدي","خرسانة 3/4",24,29.166666666666668,700]
["A-175","2020-06-27",9562,"نقدي","خرسانة 3/4",16,33.75,540]
["A-176","2020-06-27",9563,"نقدي","خرسانة 3/4",16,31.25,500]
["A-177","2020-06-27",9564,"نقدي","خرسانة 3/4",16,33.75,540]
["A-178","2020-06-27",9565,"نقدي","خرسانة 3/4",24,22.5,540]
["A-179","2020-06-27",9566,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-180","2020-06-27",9567,"مصنع العسيري","خرسانة 3/8",24,{"$f":"IFERROR(H194/F194,\"-\")","v":29.166666666666668},700]
["A-181","2020-06-28",9568,"نقدي","خرسانة 3/4",16,{"$f":"IFERROR(H195/F195,\"-\")","v":33.75},540]
["A-182","2020-06-28",9569,"نقدي","خرسانة 3/4",16,33.75,540]
["A-183","2020-06-28",9570,"نقدي","خرسانة 3/4",14,35.714285714285715,500]
["A-184","2020-06-28",9571,"نقدي","خرسانة 3/4",16,33.75,540]
["A-185","2020-06-28",9572,"نقدي","خرسانة 3/4",16,33.75,540]
["A-186","2020-06-28",9573,"نقدي","خرسانة 3/8",16,33.75,540]
["A-187","2020-06-28",9574,"نقدي","خرسانة 3/4",16,33.75,540]
["A-188","2020-06-28",9575,"نقدي","خرسانة 3/4",16,33.75,540]
["A-189","2020-06-28",9576,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-190","2020-06-28",9577,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-191","2020-06-28",9578,"عثمان - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-192","2020-06-29",9579,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-193","2020-06-29",9580,"نقدي","خرسانة 3/4",16,33.75,540]
["A-194","2020-06-29",9581,"نقدي","خرسانة 3/4",16,33.75,540]
["A-195","2020-06-29",9582,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-196","2020-06-29",9583,"نقدي","خرسانة 3/4",14,35.714285714285715,500]
["A-197","2020-06-29",9584,"نقدي","خرسانة 3/8",8,43.75,350]
["A-198","2020-06-29",9585,"مصنع العسيري","خرسانة 3/4",24,29.166666666666668,700]
["A-199","2020-06-29",9586,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-200","2020-06-29",9587,"نقدي","خرسانة 3/4",16,33.75,540]
["A-201","2020-06-29",9588,"نقدي","تراب ناعم",16,3.125,50]
["A-202","2020-06-29",9589,"مصنع العسيري","خرسانة 3/8",24,29.166666666666668,700]
["A-203","2020-06-30",9590,"نقدي","خرسانة 3/4",16,33.75,540]
["A-204","2020-06-30",9591,"نقدي","خرسانة 3/4",24,32.5,780]
["A-205","2020-06-30",9592,"نقدي","خرسانة 3/4",16,33.75,540]
["A-206","2020-06-30",9593,"نقدي","خرسانة 3/4",16,33.75,540]
["A-207","2020-06-30",9594,"نقدي","خرسانة 3/4",16,3.125,50]
["A-208","2020-06-30",9595,"نقدي","خرسانة 3/4",16,3.125,50]
["A-209","2020-06-30",9596,"نقدي","خرسانة 3/4",16,33.75,540]
["A-210","2020-06-30",9597,"نقدي","خرسانة 3/4",16,33.75,540]
["A-211","2020-06-30",9598,"نقدي","خرسانة 3/4",16,33.75,540]
["A-212","2020-06-30",9599,"نقدي","خرسانة 3/4",16,33.75,540]
["A-213","2020-06-30",9600,"نقدي","خرسانة 3/4",16,33.75,540]
["A-214","2020-06-30",9601,"نقدي","خرسانة 3/4",16,33.75,540]
["A-215","2020-06-30",9602,"نقدي","خرسانة 3/4",8,42.5,340]
["A-216","2020-06-30",9603,"عثمان - شركة القلابات","خرسانة 3/4",16,33.75,540]
["A-217","2020-06-30",9604,"نقدي","خرسانة 3/4",24,32.5,780]
["A-218","2020-06-30",9605,"نقدي","خرسانة 3/4",16,33.75,540]
[null,"TOTAL",null,null,null,{"$f":"SUBTOTAL(109,F3:F232)","v":4206},24.788397527341893,{"$f":"SUBTOTAL(109,H3:H232)","v":104260}]
[null,null,null,"نقدي",null,{"$f":"SUMIF($D$3:$D$232,D234,$F$3:$F$232)","v":1614},29.820322180916975,{"$f":"SUMIF($D$3:$D$232,D234,$H$3:$H$232)","v":48130}]
[null,null,null,"راشد الاسمري - ايجار معدات",null,8,43.75,350]
[null,null,null,"واسيم  - شركة القلابات",null,48,3.125,150]
[null,null,null,"عثمان - شركة القلابات",null,48,33.75,1620]
[null,null,null,"نعيم - شركة القلابات",null,176,17.045454545454547,3000]
[null,null,null,"مصنع العسيري",null,1512,29.166666666666668,44100]
[null,null,null,"نزير - شركة القلابات",null,400,6.8,2720]
[null,null,null,"عابد الله - شركة القلابات",null,144,16.736111111111111,2410]
[null,null,null,"هزار- شركة القلابات",null,64,3.125,200]
[null,null,null,"محمد اشرف - شركة القلابات",null,192,8.2291666666666661,1580]
["TOTAL",null,null,null,null,{"$f":"SUM(F234:F243)","v":4206},{"$f":"SUBTOTAL(109,G3:G243)","v":5864.4313567933959},{"$f":"SUM(H234:H243)","v":104260}]
[null,null,null,null,"القيمة المضافة","الإيرادات","المبيعات"]
[null,null,null,null,{"$f":"G246-F246","v":4964.7619047619082},{"$f":"G246/1.05","v":99295.238095238092},{"$f":"H233","v":104260}]
[]
[]
[null,null,null,null,"نوع المواد","QUANTITY","PRICE","AMOUNT","الإيرادات","VAT"]
[null,null,null,null,"خرسانة 3/4",{"$f":"SUMIF($E$3:$E$232,E250,$F$3:$F$232)","v":1982},{"$f":"IFERROR(H250/F250,\"-\")","v":31.831483350151363},{"$f":"SUMIF($E$3:$E$232,E250,$H$3:$H$232)","v":63090},{"$f":"H250/1.05","v":60085.714285714283},{"$f":"I250*0.05","v":3004.2857142857142}]
[null,null,null,null,"خرسانة 3/8",{"$f":"SUMIF($E$3:$E$232,E251,$F$3:$F$232)","v":1248},{"$f":"IFERROR(H251/F251,\"-\")","v":30.152243589743591},{"$f":"SUMIF($E$3:$E$232,E251,$H$3:$H$232)","v":37630},{"$f":"H251/1.05","v":35838.095238095237},{"$f":"I251*0.05","v":1791.9047619047619}]
[null,null,null,null,"تراب ناعم",{"$f":"SUMIF($E$3:$E$232,E252,$F$3:$F$232)","v":976},{"$f":"IFERROR(H252/F252,\"-\")","v":3.627049180327869},{"$f":"SUMIF($E$3:$E$232,E252,$H$3:$H$232)","v":3540},{"$f":"H252/1.05","v":3371.4285714285711},{"$f":"I252*0.05","v":168.57142857142856}]
[null,null,null,null,"بودرة",{"$f":"SUMIF($E$3:$E$232,E253,$F$3:$F$232)","v":0},{"$f":"IFERROR(H253/F253,\"-\")","v":"-"},{"$f":"SUMIF($E$3:$E$232,E253,$H$3:$H$232)","v":0},{"$f":"H253/1.05","v":0},{"$f":"I253*0.05","v":0}]
[null,null,null,null,"اجمالى",{"$f":"SUM(F250:F253)","v":4206},null,{"$f":"SUM(H250:H253)","v":104260},{"$f":"SUM(I250:I253)","v":99295.238095238092},{"$f":"SUM(J250:J253)","v":4964.7619047619046}]

{"sheet":"يولية","index":8,"n_rows":39,"n_cols":8,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["بيان مبيعات الكسارة عن شهر يوليو 2020"]
["م","التاريخ","رقم الايصال","العميل","نوع المواد","الكمية","السعر","الاجمالى"]
[1,"2020-07-01",9606,"نقدى","تراب ناعم",16,{"$f":"IFERROR(H3/F3,\"-\")","v":3.125},50]
[2,"2020-07-01",9607,"مصنع العسيرى","خرسانة 3/4",24,{"$f":"IFERROR(H4/F4,\"-\")","v":33.541666666666664},805]
[3,"2020-07-01",9608,"مصنع العسيرى","خرسانة 3/8",24,{"$f":"IFERROR(H5/F5,\"-\")","v":33.541666666666664},805]
[4,"2020-07-01",9609,"مصنع العسيرى","خرسانة 3/8",24,{"$f":"IFERROR(H6/F6,\"-\")","v":33.541666666666664},805]
[5,"2020-07-01",9610,"نقدى","خرسانة 3/4",16,{"$f":"IFERROR(H7/F7,\"-\")","v":38.8125},621]
[6,"2020-07-01",9611,"نقدى","خرسانة 3/4",16,{"$f":"IFERROR(H8/F8,\"-\")","v":38.8125},621]
[7,"2020-07-01",9612,"مصنع العسيرى","خرسانة 3/4",24,33.541666666666664,805]
[8,"2020-07-01",9613,"نقدى","خرسانة 3/4",16,38.8125,621]
[9,"2020-07-01",9614,"مصنع العسيرى","خرسانة 3/4",24,33.541666666666664,805]
[10,"2020-07-01",9615,"محمد نعيم ","تراب ناعم",16,4.3125,69]
[11,"2020-07-01",9616,"محمد نعيم ","تراب ناعم",16,4.3125,69]
[12,"2020-07-02",9617,"نقدى","خرسانة 3/4",16,38.8125,621]
[13,"2020-07-02",9618,"نقدى","خرسانة 3/4",16,38.8125,621]
[14,"2020-07-02",9619,"نقدى","خرسانة 3/4",16,38.8125,621]
[15,"2020-07-02",9620,"مصنع العسيرى","خرسانة 3/4",24,33.541666666666664,805]
[16,"2020-07-02",9621,"مصنع العسيرى","خرسانة 3/4",24,33.541666666666664,805]
[17,"2020-07-02",9622,"مصنع العسيرى","خرسانة 3/4",24,33.541666666666664,805]
[18,"2020-07-02",9623,"نقدى","خرسانة 3/4",16,38.8125,621]
[19,"2020-07-02",9624,"نقدى","خرسانة 3/4",16,38.8125,621]
[20,"2020-07-02",9625,"مصنع العسيرى","خرسانة 3/8",24,33.541666666666664,805]
[21,"2020-07-02",9626,"مصنع العسيرى","خرسانة 3/8",24,33.541666666666664,805]
[22,"2020-07-02",9627,"نقدى","خرسانة 3/4",16,38.8125,621]
[23,"2020-07-02",9628,"نقدى","خرسانة 3/4",8,48.875,391]
[24,"2020-07-02",9629,"مؤسسة بن دروم ","تراب ناعم",16,4.3125,69]
[25,"2020-07-02",9630,"مؤسسة بن دروم ","تراب ناعم",16,4.3125,69]
[26,"2020-07-02",9631,"مؤسسة بن دروم ","تراب ناعم",16,4.3125,69]
[27,"2020-07-02",9632,"مؤسسة بن دروم ","تراب ناعم",16,4.3125,69]
[28,"2020-07-04",9633,"نقدى","خرسانة 3/4",16,38.8125,621]
[29,"2020-07-04",9634,"مصنع العسيرى","خرسانة 3/8",24,33.541666666666664,805]
[30,"2020-07-04",9635,"مصنع العسيرى","خرسانة 3/8",24,33.541666666666664,805]
[31,"2020-07-04",9636,"نقدى","خرسانة 3/4",16,38.8125,621]
[32,"2020-07-04",9637,"نقدى","خرسانة 3/4",16,38.8125,621]
[33,"2020-07-04",9638,"نقدى","خرسانة 3/4",16,38.8125,621]
[34,"2020-07-04",9639,"مصنع العسيرى","خرسانة 3/8",24,33.541666666666664,805]
[35,"2020-07-04",9640,"مصنع العسيرى","خرسانة 3/8",24,33.541666666666664,805]
[36,"2020-07-04",9641,"مصنع العسيرى","خرسانة 3/8",24,33.541666666666664,805]
[37,"2020-07-04",9642,"نقدى","خرسانة 3/4",16,38.8125,621]

{"sheet":"فواتير يولية","index":9,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[[7,2,7,3],[19,0,19,4],[6,0,6,1],[4,0,4,3],[22,7,22,8],[16,5,16,7],[17,5,17,7],[18,5,18,7],[9,1,9,4],[10,1,10,4],[11,1,11,4],[12,1,12,4],[13,1,13,4],[14,5,14,7],[15,5,15,7],[5,3,5,5],[6,5,6,8],[7,5,7,8],[6,2,6,3]]}
[]
[]
[]
[]
["الرقم الضريبي : 310199231200003"]
[null,null,null,"Tax Invoice# ",null,null,9607]
["2020-07-01",null,"التاريخ",null,null,"رقم تليفون العميل : 0172826555"]
[null,"مصنع العسيرى","العميل",null,null,"رقم السيارة :7228"]
[]
["م","البيان",null,null,null,"الكمية","الوحدة","السعر","الإجمالي"]
[1,"خرسانة 3/4",null,null,null,{"$f":"SUMIFS(يولية!F3:F253,يولية!B3:B253,A7,يولية!D3:D253,B8,يولية!E3:E253,B11,يولية!C3:C253,G6)","v":24},"م مكعب",{"$f":"IFERROR(I11/F11,\"-\")","v":29.166666666666668},{"$f":"SUMIFS(يولية!H3:H253,يولية!B3:B253,A7,يولية!D3:D253,B8,يولية!E3:E253,B11,يولية!C3:C253,G6)/1.15","v":700}]
[2,null,null,null,null,{"$f":"SUMIFS(يولية!F3:F253,يولية!B3:B253,A7,يولية!D3:D253,B8,يولية!E3:E253,B11,يولية!C3:C253,G7)","v":0},"م مكعب",{"$f":"IFERROR(I12/F12,\"-\")","v":"-"},{"$f":"SUMIFS(يولية!H3:H253,يولية!B3:B253,A7,يولية!D3:D253,B8,يولية!E3:E253,B12,يولية!C3:C253,G6)","v":0}]
[3]
[]
[null,null,null,null,null,"Subtotal",null,null,{"$f":"SUM(I11:I14)","v":700}]
[null,null,null,null,null,"VAT 15 %",null,null,0.15]
[null,null,null,null,null,"VAT Value",null,null,{"$f":"I15*I16","v":105}]
[null,null,null,null,null,"Total Amount Including VAT",null,null,{"$f":"I15+I17","v":805}]
[null,null,null,null,null,"Less Total Deductin",null,null,0]
["فقط مبلغ وقدره أربعة الف وخمسة وعشرون ريال لاغير",null,null,null,null,"Invoice Total ( Net Amount )",null,null,{"$f":"I18-I19","v":805}]
[]
[]
[null,"البائع",null,null,null,null,null,"المحاسب"]

{"sheet":"تقرير7","index":10,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,9,1,10],[6,9,6,10],[7,9,7,10],[8,9,8,10]]}
[]
[null,"التاريخ",null,null,null,null,"اجمالى نقدى",{"$f":"SUMIF(D4:D70,\"نقدى\",H4:H70)","v":3105}]
[null,"2020-07-04",null,null,null,null,"اجمالى الاجل",{"$f":"SUM(H4:H70)-H2","v":4025}]
["م","التاريخ","رقم الايصال","العميل","نوع المواد","الكمية","السعر","الاجمالى"]
[28,"2020-07-04",9633,"نقدى","خرسانة 3/4",16,38.8125,621]
[29,"2020-07-04",9634,"مصنع العسيرى","خرسانة 3/8",24,33.541666666666664,805]
[30,"2020-07-04",9635,"مصنع العسيرى","خرسانة 3/8",24,33.541666666666664,805,3105,"عهدة طه العوض "]
[31,"2020-07-04",9636,"نقدى","خرسانة 3/4",16,38.8125,621,0,"ايداعات"]
[32,"2020-07-04",9637,"نقدى","خرسانة 3/4",16,38.8125,621,{"$f":"I7+I8","v":3105},"الإجمالي "]
[33,"2020-07-04",9638,"نقدى","خرسانة 3/4",16,38.8125,621]
[34,"2020-07-04",9639,"مصنع العسيرى","خرسانة 3/8",24,33.541666666666664,805]
[35,"2020-07-04",9640,"مصنع العسيرى","خرسانة 3/8",24,33.541666666666664,805]
[36,"2020-07-04",9641,"مصنع العسيرى","خرسانة 3/8",24,33.541666666666664,805]
[37,"2020-07-04",9642,"نقدى","خرسانة 3/4",16,38.8125,621]

{"sheet":"اجمالى الشهور","index":11,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,7]]}
["اجمالى الشهور 2020"]
["S.N","MOUNTH","QUINTITY","PRICE","AMOUNT","Column1","Column2","Column3"]
["A-1","january",{"$f":"يناير!F305","v":5142},{"$f":"IFERROR(E3/C3,\"-\")","v":22.857837417347337},{"$f":"يناير!H305","v":117535}]
["A-2","february",{"$f":"فبراير!F241","v":4310},24.668213457076565,{"$f":"فبراير!H241","v":106320}]
["A-3","march",{"$f":"مارس!F256","v":5406},21.137624861265262,{"$f":"مارس!H256","v":114270}]
["A-4","april",{"$f":"ابريل!F243","v":4708},25.586236193712828,{"$f":"ابريل!H243","v":120460}]
["A-5","may",{"$f":"مايو!F160","v":3118},23.52148813341886,{"$f":"مايو!H160","v":73340}]
["A-6","june",{"$f":"يونية!F244","v":4206},24.788397527341893,{"$f":"يونية!H244","v":104260}]
["A-7","july",null,"-"]
["A-8","august",null,"-"]
["A-9","september",null,"-"]
["A-10","october",null,"-"]
["A-11","november",null,"-"]
["A-12","december",null,"-"]
["TOTAL",null,{"$f":"SUBTOTAL(109,C3:C14)","v":26890},23.658795091111937,{"$f":"SUBTOTAL(109,E3:E14)","v":636185}]

{"sheet":"اجمالى كميات","index":12,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,9]]}
["اجمالى كميات 2020"]
["S.N","نوع المواد","QUANTITY","PRICE","AMOUNT","الإيرادات","VAT","Column1","Column2","Column3"]
["A-1","خرسانة 3/4",{"$f":"يناير!F316+فبراير!F253+مارس!F263+ابريل!F250+مايو!F166+يونية!F250","v":14962},{"$f":"IFERROR(E3/C3,\"-\")","v":26.771821948937308},{"$f":"يناير!H316+فبراير!H253+مارس!H263+ابريل!H250+مايو!H166+يونية!H250","v":400560},{"$f":"يناير!I316+فبراير!I253+مارس!I263+ابريل!I250+مايو!I166+يونية!I250","v":381485.71428571426},{"$f":"يناير!J316+فبراير!J253+مارس!J263+ابريل!J250+مايو!J166+يونية!J250","v":19074.285714285714}]
["A-2","خرسانة 3/8",{"$f":"يناير!F317+فبراير!F254+مارس!F264+ابريل!F251+مايو!F167+يونية!F251","v":8520},{"$f":"IFERROR(E4/C4,\"-\")","v":26.143192488262912},{"$f":"يناير!H317+فبراير!H254+مارس!H264+ابريل!H251+مايو!H167+يونية!H251","v":222740},{"$f":"يناير!I317+فبراير!I254+مارس!I264+ابريل!I251+مايو!I167+يونية!I251","v":212133.33333333331},{"$f":"يناير!J317+فبراير!J254+مارس!J264+ابريل!J251+مايو!J167+يونية!J251","v":10606.666666666666}]
["A-3","تراب ناعم",{"$f":"يناير!F318+فبراير!F255+مارس!F265+ابريل!F252+مايو!F168+يونية!F252","v":3344},3.3148923444976077,{"$f":"يناير!H318+فبراير!H255+مارس!H265+ابريل!H252+مايو!H168+يونية!H252","v":11085},{"$f":"يناير!I318+فبراير!I255+مارس!I265+ابريل!I252+مايو!I168+يونية!I252","v":10557.142857142857},{"$f":"يناير!J318+فبراير!J255+مارس!J265+ابريل!J252+مايو!J168+يونية!J252","v":527.85714285714289}]
["A-4","بودرة",{"$f":"يناير!F319+فبراير!F256+مارس!F266+ابريل!F253+مايو!F169+يونية!F253","v":64},28.125,{"$f":"يناير!H319+فبراير!H256+مارس!H266+ابريل!H253+مايو!H169+يونية!H253","v":1800},{"$f":"يناير!I319+فبراير!I256+مارس!I266+ابريل!I253+مايو!I169+يونية!I253","v":1714.2857142857142},{"$f":"يناير!J319+فبراير!J256+مارس!J266+ابريل!J253+مايو!J169+يونية!J253","v":85.714285714285722}]
["A-5",null,null,"-"]
["A-6",null,null,"-"]
["A-7",null,null,"-"]
["A-8",null,null,"-"]
["TOTAL",null,{"$f":"SUBTOTAL(109,C3:C10)","v":26890},null,{"$f":"SUBTOTAL(109,E3:E10)","v":636185},{"$f":"SUBTOTAL(109,F3:F10)","v":605890.4761904761},{"$f":"SUM(G3:G10)","v":30294.523809523809}]