{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Sheet2","test","بيانات","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"Sheet2","index":0,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["م","الاسم","رقم التأمين","التاريخ","الإجمالي"]
[1,null,"05301",null,26]
[2,null,"03380",null,16]
[3,null,"02239",null,34.75]
[4,null,"03720",null,5.5]
[5,null,"01934",null,4.5]
[6,null,"01932",null,47]
[7,null,"05193",null,120.75]
[8,null,"05192",null,100]
[9,null,"03852",null,28.5]
[10,null,"04142",null,11]
[11,null,"02867",null,18.5]
[12,null,"02247",null,6]
[13,null,"02212",null,7.5]
[14,null,"00821",null,26]

{"sheet":"test","index":1,"n_rows":54,"n_cols":7,"rows_kept":54,"cut":false,"hidden":false,"merged":[[9,6,13,14]]}
["م","الاسم","رقم التأمين","التاريخ","الإجمالي",null,7]
[{"$f":"IF(OR(B2=\"المجموع\",B2=\"المدور\",B2=\"\"),\"\",MAX($A$1:A1)+1)","v":1},"Name1","05301",null,26]
[{"$f":"IF(OR(B3=\"المجموع\",B3=\"المدور\",B3=\"\"),\"\",MAX($A$1:A2)+1)","v":2},"Name2","03380",null,16]
[{"$f":"IF(OR(B4=\"المجموع\",B4=\"المدور\",B4=\"\"),\"\",MAX($A$1:A3)+1)","v":3},"Name3","02239",null,34.75]
[{"$f":"IF(OR(B5=\"المجموع\",B5=\"المدور\",B5=\"\"),\"\",MAX($A$1:A4)+1)","v":4},"Name4","03720",null,5.5]
[{"$f":"IF(OR(B6=\"المجموع\",B6=\"المدور\",B6=\"\"),\"\",MAX($A$1:A5)+1)","v":5},"Name5","01934",null,4.5]
[{"$f":"IF(OR(B7=\"المجموع\",B7=\"المدور\",B7=\"\"),\"\",MAX($A$1:A6)+1)","v":6},"Name6","01932",null,47]
[{"$f":"IF(OR(B8=\"المجموع\",B8=\"المدور\",B8=\"\"),\"\",MAX($A$1:A7)+1)","v":7},"Name7","05193",null,120.75]
[null,"sum",null,null,254.5]
[{"$f":"IF(OR(B10=\"المجموع\",B10=\"المدور\",B10=\"\"),\"\",MAX($A$1:A8)+1)","v":8},"Name8","05192",null,100,null,"المطلوب فضلا وليس امرا اضافه صف في بداية كل صفحة يحتوي على مجموع الصفحة السابقة  وكلمه المدور لكي يقوم الكود باضافة مجموع الصفحة السابقة الى الصفحة التالية وهكذا\n كما هو موضح بشيت البيانات"]
[{"$f":"IF(OR(B11=\"المجموع\",B11=\"المدور\",B11=\"\"),\"\",MAX($A$1:A10)+1)","v":9},"Name9","03852",null,28.5]
[{"$f":"IF(OR(B12=\"المجموع\",B12=\"المدور\",B12=\"\"),\"\",MAX($A$1:A11)+1)","v":10},"Name10","04142",null,11]
[{"$f":"IF(OR(B13=\"المجموع\",B13=\"المدور\",B13=\"\"),\"\",MAX($A$1:A12)+1)","v":11},"Name11","02867",null,18.5]
[{"$f":"IF(OR(B14=\"المجموع\",B14=\"المدور\",B14=\"\"),\"\",MAX($A$1:A13)+1)","v":12},"Name12","02247",null,6]
[{"$f":"IF(OR(B15=\"المجموع\",B15=\"المدور\",B15=\"\"),\"\",MAX($A$1:A14)+1)","v":13},"Name13","02212",null,7.5]
[{"$f":"IF(OR(B16=\"المجموع\",B16=\"المدور\",B16=\"\"),\"\",MAX($A$1:A15)+1)","v":14},"Name14","00821",null,26]
[null,"sum",null,null,197.5]
[{"$f":"IF(OR(B18=\"المجموع\",B18=\"المدور\",B18=\"\"),\"\",MAX($A$1:A16)+1)","v":15},"Name15","02098",null,30]
[{"$f":"IF(OR(B19=\"المجموع\",B19=\"المدور\",B19=\"\"),\"\",MAX($A$1:A18)+1)","v":16},"Name16","00355",null,8.5]
[{"$f":"IF(OR(B20=\"المجموع\",B20=\"المدور\",B20=\"\"),\"\",MAX($A$1:A19)+1)","v":17},"Name17","00348",null,23]
[{"$f":"IF(OR(B21=\"المجموع\",B21=\"المدور\",B21=\"\"),\"\",MAX($A$1:A20)+1)","v":18},"Name18","01941",null,2]
[{"$f":"IF(OR(B22=\"المجموع\",B22=\"المدور\",B22=\"\"),\"\",MAX($A$1:A21)+1)","v":19},"Name19","01943",null,3.5]
[{"$f":"IF(OR(B23=\"المجموع\",B23=\"المدور\",B23=\"\"),\"\",MAX($A$1:A22)+1)","v":20},"Name20","00102",null,40]
[{"$f":"IF(OR(B24=\"المجموع\",B24=\"المدور\",B24=\"\"),\"\",MAX($A$1:A23)+1)","v":21},"Name21","03750",null,16]
[null,"sum",null,null,123]
[{"$f":"IF(OR(B26=\"المجموع\",B26=\"المدور\",B26=\"\"),\"\",MAX($A$1:A24)+1)","v":22},"Name22","00038",null,3.75]
[{"$f":"IF(OR(B27=\"المجموع\",B27=\"المدور\",B27=\"\"),\"\",MAX($A$1:A26)+1)","v":23},"Name23","04034",null,53]
[{"$f":"IF(OR(B28=\"المجموع\",B28=\"المدور\",B28=\"\"),\"\",MAX($A$1:A27)+1)","v":24},"Name24","02475",null,4]
[{"$f":"IF(OR(B29=\"المجموع\",B29=\"المدور\",B29=\"\"),\"\",MAX($A$1:A28)+1)","v":25},"Name25","00455",null,25]
[{"$f":"IF(OR(B30=\"المجموع\",B30=\"المدور\",B30=\"\"),\"\",MAX($A$1:A29)+1)","v":26},"Name26","01927",null,19]
[{"$f":"IF(OR(B31=\"المجموع\",B31=\"المدور\",B31=\"\"),\"\",MAX($A$1:A30)+1)","v":27},"Name27","02902",null,25]
[{"$f":"IF(OR(B32=\"المجموع\",B32=\"المدور\",B32=\"\"),\"\",MAX($A$1:A31)+1)","v":28},"Name28","03269",null,27]
[null,"sum",null,null,156.75]
[{"$f":"IF(OR(B34=\"المجموع\",B34=\"المدور\",B34=\"\"),\"\",MAX($A$1:A32)+1)","v":29},"Name29","03267",null,32.5]
[{"$f":"IF(OR(B35=\"المجموع\",B35=\"المدور\",B35=\"\"),\"\",MAX($A$1:A34)+1)","v":30},"Name30","02955",null,30]
[{"$f":"IF(OR(B36=\"المجموع\",B36=\"المدور\",B36=\"\"),\"\",MAX($A$1:A35)+1)","v":31},"Name31","03306",null,15]
[{"$f":"IF(OR(B37=\"المجموع\",B37=\"المدور\",B37=\"\"),\"\",MAX($A$1:A36)+1)","v":32},"Name32","01116",null,25]
[{"$f":"IF(OR(B38=\"المجموع\",B38=\"المدور\",B38=\"\"),\"\",MAX($A$1:A37)+1)","v":33},"Name33","01558",null,6.5]
[{"$f":"IF(OR(B39=\"المجموع\",B39=\"المدور\",B39=\"\"),\"\",MAX($A$1:A38)+1)","v":34},"Name34","01557",null,19.5]
[{"$f":"IF(OR(B40=\"المجموع\",B40=\"المدور\",B40=\"\"),\"\",MAX($A$1:A39)+1)","v":35},"Name35","05127",null,14]
[null,"sum",null,null,142.5]
[{"$f":"IF(OR(B42=\"المجموع\",B42=\"المدور\",B42=\"\"),\"\",MAX($A$1:A40)+1)","v":36},"Name36","01183",null,16.5]
[{"$f":"IF(OR(B43=\"المجموع\",B43=\"المدور\",B43=\"\"),\"\",MAX($A$1:A42)+1)","v":37},"Name37","01184",null,49]
[{"$f":"IF(OR(B44=\"المجموع\",B44=\"المدور\",B44=\"\"),\"\",MAX($A$1:A43)+1)","v":38},"Name38","01449",null,9.5]
[{"$f":"IF(OR(B45=\"المجموع\",B45=\"المدور\",B45=\"\"),\"\",MAX($A$1:A44)+1)","v":39},"Name39","05603",null,60]
[{"$f":"IF(OR(B46=\"المجموع\",B46=\"المدور\",B46=\"\"),\"\",MAX($A$1:A45)+1)","v":40},"Name40","01558",null,6.5]
[{"$f":"IF(OR(B47=\"المجموع\",B47=\"المدور\",B47=\"\"),\"\",MAX($A$1:A46)+1)","v":41},"Name41","01557",null,19.5]
[{"$f":"IF(OR(B48=\"المجموع\",B48=\"المدور\",B48=\"\"),\"\",MAX($A$1:A47)+1)","v":42},"Name42","05127",null,14]
[null,"sum",null,null,175]
[{"$f":"IF(OR(B50=\"المجموع\",B50=\"المدور\",B50=\"\"),\"\",MAX($A$1:A48)+1)","v":43},"Name43","01183",null,16.5]
[{"$f":"IF(OR(B51=\"المجموع\",B51=\"المدور\",B51=\"\"),\"\",MAX($A$1:A50)+1)","v":44},"Name44","01184",null,49]
[{"$f":"IF(OR(B52=\"المجموع\",B52=\"المدور\",B52=\"\"),\"\",MAX($A$1:A51)+1)","v":45},"Name45","01449",null,9.5]
[{"$f":"IF(OR(B53=\"المجموع\",B53=\"المدور\",B53=\"\"),\"\",MAX($A$1:A52)+1)","v":46},"Name46","05603",null,60]
[null,"sum",null,null,135]

{"sheet":"بيانات","index":2,"n_rows":56,"n_cols":7,"rows_kept":56,"cut":false,"hidden":false,"merged":[[8,6,12,14]]}
["م","الاسم","رقم التأمين","التاريخ","الإجمالي",null,7]
[{"$f":"IF(OR(B2=\"المجموع\",B2=\"المدور\",B2=\"\"),\"\",MAX($A$1:A1)+1)","v":1},"Name1","05301",null,1]
[{"$f":"IF(OR(B3=\"المجموع\",B3=\"المدور\",B3=\"\"),\"\",MAX($A$1:A2)+1)","v":2},"Name2","03380",null,2.25]
[{"$f":"IF(OR(B4=\"المجموع\",B4=\"المدور\",B4=\"\"),\"\",MAX($A$1:A3)+1)","v":3},"Name3","02239",null,3]
[{"$f":"IF(OR(B5=\"المجموع\",B5=\"المدور\",B5=\"\"),\"\",MAX($A$1:A4)+1)","v":4},"Name4","03720",null,4.25]
[{"$f":"IF(OR(B6=\"المجموع\",B6=\"المدور\",B6=\"\"),\"\",MAX($A$1:A5)+1)","v":5},"Name5","01934",null,5]
[{"$f":"IF(OR(B7=\"المجموع\",B7=\"المدور\",B7=\"\"),\"\",MAX($A$1:A6)+1)","v":6},"Name6","01932",null,6.25]
[{"$f":"IF(OR(B8=\"المجموع\",B8=\"المدور\",B8=\"\"),\"\",MAX($A$1:A7)+1)","v":7},"Name7","05193",null,7]
[null,"المجموع",null,null,{"$f":"SUM(E2:E8)","v":28.75},null,"اضافة حقل المدور في بداية كل صفحة لكي يقوم الكود باضافة مجموع الصفحة السابقة الى الصفحة التاليه وهكذا"]
[null,"المدور",null,null,{"$f":"E9","v":28.75}]
[{"$f":"IF(OR(B11=\"المجموع\",B11=\"المدور\",B11=\"\"),\"\",MAX($A$1:A8)+1)","v":8},"Name8","05192",null,1]
[{"$f":"IF(OR(B12=\"المجموع\",B12=\"المدور\",B12=\"\"),\"\",MAX($A$1:A11)+1)","v":9},"Name9","03852",null,2]
[{"$f":"IF(OR(B13=\"المجموع\",B13=\"المدور\",B13=\"\"),\"\",MAX($A$1:A12)+1)","v":10},"Name10","04142",null,3]
[{"$f":"IF(OR(B14=\"المجموع\",B14=\"المدور\",B14=\"\"),\"\",MAX($A$1:A13)+1)","v":11},"Name11","02867",null,4]
[{"$f":"IF(OR(B15=\"المجموع\",B15=\"المدور\",B15=\"\"),\"\",MAX($A$1:A14)+1)","v":12},"Name12","02247",null,5]
[null,"المجموع",null,null,{"$f":"SUM(E10:E15)","v":43.75}]
[null,"المدور",null,null,{"$f":"E16","v":43.75}]
[{"$f":"IF(OR(B18=\"المجموع\",B18=\"المدور\",B18=\"\"),\"\",MAX($A$1:A15)+1)","v":13},"Name13","02212",null,7.5]
[{"$f":"IF(OR(B19=\"المجموع\",B19=\"المدور\",B19=\"\"),\"\",MAX($A$1:A18)+1)","v":14},"Name14","00821",null,26]
[{"$f":"IF(OR(B20=\"المجموع\",B20=\"المدور\",B20=\"\"),\"\",MAX($A$1:A19)+1)","v":15},"Name15","02098",null,30]
[{"$f":"IF(OR(B21=\"المجموع\",B21=\"المدور\",B21=\"\"),\"\",MAX($A$1:A20)+1)","v":16},"Name16","00355",null,8.5]
[{"$f":"IF(OR(B22=\"المجموع\",B22=\"المدور\",B22=\"\"),\"\",MAX($A$1:A21)+1)","v":17},"Name17","00348",null,23]
[{"$f":"IF(OR(B23=\"المجموع\",B23=\"المدور\",B23=\"\"),\"\",MAX($A$1:A22)+1)","v":18},"Name18","01941",null,2]
[{"$f":"IF(OR(B24=\"المجموع\",B24=\"المدور\",B24=\"\"),\"\",MAX($A$1:A23)+1)","v":19},"Name19","01943",null,3.5]
[null,"المجموع",null,null,{"$f":"SUM(E17:E24)","v":144.25}]
[null,"المدور",null,null,{"$f":"E25","v":144.25}]
[{"$f":"IF(OR(B27=\"المجموع\",B27=\"المدور\",B27=\"\"),\"\",MAX($A$1:A26)+1)","v":20},"Name21","03750",null,16]
[{"$f":"IF(OR(B28=\"المجموع\",B28=\"المدور\",B28=\"\"),\"\",MAX($A$1:A27)+1)","v":21},"Name22","00038",null,3.75]
[{"$f":"IF(OR(B29=\"المجموع\",B29=\"المدور\",B29=\"\"),\"\",MAX($A$1:A28)+1)","v":22},"Name23","04034",null,53]
[{"$f":"IF(OR(B30=\"المجموع\",B30=\"المدور\",B30=\"\"),\"\",MAX($A$1:A29)+1)","v":23},"Name24","02475",null,4]
[{"$f":"IF(OR(B31=\"المجموع\",B31=\"المدور\",B31=\"\"),\"\",MAX($A$1:A30)+1)","v":24},"Name25","00455",null,25]
[{"$f":"IF(OR(B32=\"المجموع\",B32=\"المدور\",B32=\"\"),\"\",MAX($A$1:A31)+1)","v":25},"Name26","01927",null,19]
[null,"المجموع",null,null,{"$f":"SUM(E26:E32)","v":265}]
[null,"المدور",null,null,{"$f":"E33","v":265}]
[{"$f":"IF(OR(B35=\"المجموع\",B35=\"المدور\",B35=\"\"),\"\",MAX($A$1:A34)+1)","v":26},"Name28","03269",null,27]
[{"$f":"IF(OR(B36=\"المجموع\",B36=\"المدور\",B36=\"\"),\"\",MAX($A$1:A35)+1)","v":27},"Name29","03267",null,32.5]
[{"$f":"IF(OR(B37=\"المجموع\",B37=\"المدور\",B37=\"\"),\"\",MAX($A$1:A36)+1)","v":28},"Name30","02955",null,30]
[{"$f":"IF(OR(B38=\"المجموع\",B38=\"المدور\",B38=\"\"),\"\",MAX($A$1:A37)+1)","v":29},"Name31","03306",null,15]
[{"$f":"IF(OR(B39=\"المجموع\",B39=\"المدور\",B39=\"\"),\"\",MAX($A$1:A38)+1)","v":30},"Name32","01116",null,25]
[{"$f":"IF(OR(B40=\"المجموع\",B40=\"المدور\",B40=\"\"),\"\",MAX($A$1:A39)+1)","v":31},"Name33","01558",null,6.5]
[null,"المجموع",null,null,{"$f":"SUM(E34:E40)","v":401}]
[null,"المدور",null,null,{"$f":"E41","v":401}]
[{"$f":"IF(OR(B43=\"المجموع\",B43=\"المدور\",B43=\"\"),\"\",MAX($A$1:A42)+1)","v":32},"Name35","05127",null,14]
[{"$f":"IF(OR(B44=\"المجموع\",B44=\"المدور\",B44=\"\"),\"\",MAX($A$1:A43)+1)","v":33},"Name36","01183",null,16.5]
[{"$f":"IF(OR(B45=\"المجموع\",B45=\"المدور\",B45=\"\"),\"\",MAX($A$1:A44)+1)","v":34},"Name37","01184",null,49]
[{"$f":"IF(OR(B46=\"المجموع\",B46=\"المدور\",B46=\"\"),\"\",MAX($A$1:A45)+1)","v":35},"Name38","01449",null,9.5]
[{"$f":"IF(OR(B47=\"المجموع\",B47=\"المدور\",B47=\"\"),\"\",MAX($A$1:A46)+1)","v":36},"Name39","05603",null,60]
[{"$f":"IF(OR(B48=\"المجموع\",B48=\"المدور\",B48=\"\"),\"\",MAX($A$1:A47)+1)","v":37},"Name40","01558",null,6.5]
[null,"المجموع",null,null,{"$f":"SUM(E42:E48)","v":556.5}]
[null,"المدور",null,null,{"$f":"E49","v":556.5}]
[{"$f":"IF(OR(B51=\"المجموع\",B51=\"المدور\",B51=\"\"),\"\",MAX($A$1:A50)+1)","v":38},"Name42","05127",null,14]
[{"$f":"IF(OR(B52=\"المجموع\",B52=\"المدور\",B52=\"\"),\"\",MAX($A$1:A51)+1)","v":39},"Name43","01183",null,16.5]
[{"$f":"IF(OR(B53=\"المجموع\",B53=\"المدور\",B53=\"\"),\"\",MAX($A$1:A52)+1)","v":40},"Name44","01184",null,49.25]
[{"$f":"IF(OR(B54=\"المجموع\",B54=\"المدور\",B54=\"\"),\"\",MAX($A$1:A53)+1)","v":41},"Name45","01449",null,9.5]
[{"$f":"IF(OR(B55=\"المجموع\",B55=\"المدور\",B55=\"\"),\"\",MAX($A$1:A54)+1)","v":42},"Name46","05603",null,60]
[null,"المجموع الكلي",null,null,{"$f":"SUM(E50:E55)","v":705.75}]

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