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

{"sheet":"Source","index":0,"n_rows":602,"n_cols":11,"rows_kept":602,"cut":false,"hidden":false,"merged":[[0,0,1,6]]}
["سجل كهرباء المخيم المجاني"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"Target!J1","v":1}]
["كود المشترك","الاسم الثلاثي","القراءة السابقة","القراءة الحالية ","كمية الاستهلاك ","سعر  الكيلو ","المبلغ المستحق ","فاقد الشبكة","تاريخ الدفع"]
[1,"عبدالقادر سعدي ",0,50,{"$f":"D4-C4","v":50},1.1000000000000001,{"$f":"F4*E4","v":55.000000000000007},"Yes","2020-12-14"]
[2,"حسام سعدي ",0,20,20,1.1000000000000001,{"$f":"IF(OR(E5=\"\",F5=\"\"),\"\",PRODUCT(E5,F5))","v":22},"Yes","2020-10-11"]
[3,null,null,null,null,null,null,"",""]
[4,"بشير السعدي ",0,30,30,1.1000000000000001,33,"No","2020-10-31"]
[5,"إبراهيم العنزة ",0,44,44,1.1000000000000001,48.400000000000006,"Yes","2020-10-11"]
[6,"احمد غسان سعيد",0,55,55,1.1000000000000001,60.500000000000007,"No","2020-12-07"]
[7,"أنس عليطو ",0,25,25,1.1000000000000001,27.500000000000004,"Yes","2020-10-27"]
[8,"اسعد سعدي ",0,21,21,1.1000000000000001,23.1,"Yes","2020-08-08"]
[9,"زكريا جرات ",0,33,33,1.1000000000000001,36.300000000000004,"No","2020-07-28"]
[10,"حكمت شقره",0,30,30,1.1000000000000001,33,"Yes","2020-11-05"]
[11,null,0,null,null,null,null,"",""]
[12,null,0,null,null,null,null,"",""]
[13,"سليمان رشيد",0,40,40,1.1000000000000001,44,"No","2020-12-15"]
[14,null,0,null,null,null,null,"",""]
[15,null,0,null,null,null,null,"",""]
[16,null,0,null,null,null,null,"",""]
[17,null,0,null,null,null,null,"",""]
[18,null,0,null,null,null,null,"",""]
[19,null,0,null,null,null,null,"",""]
[20,null,0,null,null,null,null,"",""]
[21,null,0,null,null,null,null,"",""]
[22,null,0,null,null,null,null,"",""]
[23,null,0,null,null,null,null,"",""]
[24,null,0,null,null,null,null,"",""]
[25,null,null,null,null,null,null,"",""]
[26,null,null,null,null,null,null,"",""]
[27,null,null,null,null,null,null,"",""]
[28,null,null,null,null,null,null,"",""]
[29,null,null,null,null,null,null,"",""]
[30,null,null,null,null,null,null,"",""]
[31,null,null,null,null,null,null,"",""]
[32,null,null,null,null,null,null,"",""]
[33,null,null,null,null,null,null,"",""]
[34,null,null,null,null,null,null,"",""]
[35,null,null,null,null,null,null,"",""]
[36,null,null,null,null,null,null,"",""]
[37,null,null,null,null,null,null,"",""]
[38,null,null,null,null,null,null,"",""]
[39,null,null,null,null,null,null,"",""]
[40,null,null,null,null,null,null,"",""]
[41,null,null,null,null,null,null,"",""]
[42,null,null,null,null,null,null,"",""]
[43,null,null,null,null,null,null,"",""]
[44,null,null,null,null,null,null,"",""]
[45,null,null,null,null,null,null,"",""]
[46,null,null,null,null,null,null,"",""]
[47,null,null,null,null,null,null,"",""]
[48,null,null,null,null,null,null,"",""]
[49,null,null,null,null,null,null,"",""]
[50,null,null,null,null,null,null,"",""]
[51,null,null,null,null,null,null,"",""]
[52,null,null,null,null,null,null,"",""]
[53,null,null,null,null,null,null,"",""]
[54,null,null,null,null,null,null,"",""]
[55,null,null,null,null,null,null,"",""]
[56,null,null,null,null,null,null,"",""]
[57,null,null,null,null,null,null,"",""]
[58,null,null,null,null,null,null,"",""]
[59,null,null,null,null,null,null,"",""]
[60,null,null,null,null,null,null,"",""]
[61,null,null,null,null,null,null,"",""]
[62,null,null,null,null,null,null,"",""]
[63,null,null,null,null,null,null,"",""]
[64,null,null,null,null,null,null,"",""]
[65,null,null,null,null,null,null,"",""]
[66,null,null,null,null,null,null,"",""]
[67,null,null,null,null,null,null,"",""]
[68,null,null,null,null,null,null,"",""]
[69,null,null,null,null,null,null,"",""]
[70,null,null,null,null,null,null,"",""]
[71,null,null,null,null,null,null,"",""]
[72,null,null,null,null,null,null,"",""]
[73,null,null,null,null,null,null,"",""]
[74,null,null,null,null,null,null,"",""]
[75,null,null,null,null,null,null,"",""]
[76,null,null,null,null,null,null,"",""]
[77,null,null,null,null,null,null,"",""]
[78,null,null,null,null,null,null,"",""]
[79,null,null,null,null,null,null,"",""]
[80,null,null,null,null,null,null,"",""]
[81,null,null,null,null,null,null,"",""]
[82,null,null,null,null,null,null,"",""]
[83,null,null,null,null,null,null,"",""]
[84,null,null,null,null,null,null,"",""]
[85,null,null,null,null,null,null,"",""]
[86,null,null,null,null,null,null,"",""]
[87,null,null,null,null,null,null,"",""]
[88,null,null,null,null,null,null,"",""]
[89,null,null,null,null,null,null,"",""]
[90,null,null,null,null,null,null,"",""]
[91,null,null,null,null,null,null,"",""]
[92,null,null,null,null,null,null,"",""]
[93,null,null,null,null,null,null,"",""]
[94,null,null,null,null,null,null,"",""]
[95,null,null,null,null,null,null,"",""]
[96,null,null,null,null,null,null,"",""]
[97,null,null,null,null,null,null,"",""]
[98,null,null,null,null,null,null,"",""]
[99,null,null,null,null,null,null,"",""]
[100,null,null,null,null,null,null,"",""]
[101,null,null,null,null,null,null,"",""]
[102,null,null,null,null,null,null,"",""]
[103,null,null,null,null,null,null,"",""]
[104,null,null,null,null,null,null,"",""]
[105,null,null,null,null,null,null,"",""]
[106,null,null,null,null,null,null,"",""]
[107,null,null,null,null,null,null,null,""]
[108,null,null,null,null,null,null,null,""]
[109,null,null,null,null,null,null,null,""]
[110,null,null,null,null,null,null,null,""]
[111,null,null,null,null,null,null,null,""]
[112,null,null,null,null,null,null,null,""]
[113,null,null,null,null,null,null,null,""]
[114,null,null,null,null,null,null,null,""]
[115,null,null,null,null,null,null,null,""]
[116,null,null,null,null,null,null,null,""]
[117,null,null,null,null,null,null,null,""]
[118,null,null,null,null,null,null,null,""]
[119,null,null,null,null,null,null,null,""]
[120,null,null,null,null,null,null,null,""]
[121,null,null,null,null,null,null,null,""]
[122,null,null,null,null,null,null,null,""]
[123,null,null,null,null,null,null,null,""]
[124,null,null,null,null,null,null,null,""]
[125,null,null,null,null,null,null,null,""]
[126,null,null,null,null,null,null,null,""]
[127,null,null,null,null,null,null,null,""]
[128,null,null,null,null,null,null,null,""]
[129,null,null,null,null,null,null,null,""]
[130,null,null,null,null,null,null,null,""]
[131,null,null,null,null,null,null,null,""]
[132,null,null,null,null,null,null,null,""]
[133,null,null,null,null,null,null,null,""]
[134,null,null,null,null,null,null,null,""]
[135,null,null,null,null,null,null,null,""]
[136,null,null,null,null,null,null,null,""]
[137,null,null,null,null,null,null,null,""]
[138,null,null,null,null,null,null,null,""]
[139,null,null,null,null,null,null,null,""]
[140,null,null,null,null,null,null,null,""]
[141,null,null,null,null,null,null,null,""]
[142,null,null,null,null,null,null,null,""]
[143,null,null,null,null,null,null,null,""]
[144,null,null,null,null,null,null,null,""]
[145,null,null,null,null,null,null,null,""]
[146,null,null,null,null,null,null,null,""]
[147,null,null,null,null,null,null,null,""]
[148,null,null,null,null,null,null,null,""]
[149,null,null,null,null,null,null,null,""]
[150,null,null,null,null,null,null,null,""]
[151,null,null,null,null,null,null,null,""]
[152,null,null,null,null,null,null,null,""]
[153,null,null,null,null,null,null,null,""]
[154,null,null,null,null,null,null,null,""]
[155,null,null,null,null,null,null,null,""]
[156,null,null,null,null,null,null,null,""]
[157,null,null,null,null,null,null,null,""]
[158,null,null,null,null,null,null,null,""]
[159,null,null,null,null,null,null,null,""]
[160,null,null,null,null,null,null,null,""]
[161,null,null,null,null,null,null,null,""]
[162,null,null,null,null,null,null,null,""]
[163,null,null,null,null,null,null,null,""]
[164,null,null,null,null,null,null,null,""]
[165,null,null,null,null,null,null,null,""]
[166,null,null,null,null,null,null,null,""]
[167,null,null,null,null,null,null,null,""]
[168,null,null,null,null,null,null,null,""]
[169,null,null,null,null,null,null,null,""]
[170,null,null,null,null,null,null,null,""]
[171,null,null,null,null,null,null,null,""]
[172,null,null,null,null,null,null,null,""]
[173,null,null,null,null,null,null,null,""]
[174,null,null,null,null,null,null,null,""]
[175,null,null,null,null,null,null,null,""]
[176,null,null,null,null,null,null,null,""]
[177,null,null,null,null,null,null,null,""]
[178,null,null,null,null,null,null,null,""]
[179,null,null,null,null,null,null,null,""]
[180,null,null,null,null,null,null,null,""]
[181,null,null,null,null,null,null,null,""]
[182,null,null,null,null,null,null,null,""]
[183,null,null,null,null,null,null,null,""]
[184,null,null,null,null,null,null,null,""]
[185,null,null,null,null,null,null,null,""]
[186,null,null,null,null,null,null,null,""]
[187,null,null,null,null,null,null,null,""]
[188,null,null,null,null,null,null,null,""]
[189,null,null,null,null,null,null,null,""]
[190,null,null,null,null,null,null,null,""]
[191,null,null,null,null,null,null,null,""]
[192,null,null,null,null,null,null,null,""]
[193,null,null,null,null,null,null,null,""]
[194,null,null,null,null,null,null,null,""]
[195,null,null,null,null,null,null,null,""]
[196,null,null,null,null,null,null,null,""]
[197,null,null,null,null,null,null,null,""]
[198,null,null,null,null,null,null,null,""]
[199,null,null,null,null,null,null,null,""]
[200,null,null,null,null,null,null,null,""]
[201,null,null,null,null,null,null,null,""]
[202,null,null,null,null,null,null,null,""]
[203,null,null,null,null,null,null,null,""]
[204,null,null,null,null,null,null,null,""]
[205,null,null,null,null,null,null,null,""]
[206,null,null,null,null,null,null,null,""]
[207,null,null,null,null,null,null,null,""]
[208,null,null,null,null,null,null,null,""]
[209,null,null,null,null,null,null,null,""]
[210,null,null,null,null,null,null,null,""]
[211,null,null,null,null,null,null,null,""]
[212,null,null,null,null,null,null,null,""]
[213,null,null,null,null,null,null,null,""]
[214,null,null,null,null,null,null,null,""]
[215,null,null,null,null,null,null,null,""]
[216,null,null,null,null,null,null,null,""]
[217,null,null,null,null,null,null,null,""]
[218,null,null,null,null,null,null,null,""]
[219,null,null,null,null,null,null,null,""]
[220,null,null,null,null,null,null,null,""]
[221,null,null,null,null,null,null,null,""]
[222,null,null,null,null,null,null,null,""]
[223,null,null,null,null,null,null,null,""]
[224,null,null,null,null,null,null,null,""]
[225,null,null,null,null,null,null,null,""]
[226,null,null,null,null,null,null,null,""]
[227,null,null,null,null,null,null,null,""]
[228,null,null,null,null,null,null,null,""]
[229,null,null,null,null,null,null,null,""]
[230,null,null,null,null,null,null,null,""]
[231,null,null,null,null,null,null,null,""]
[232,null,null,null,null,null,null,null,""]
[233,null,null,null,null,null,null,null,""]
[234,null,null,null,null,null,null,null,""]
[235,null,null,null,null,null,null,null,""]
[236,null,null,null,null,null,null,null,""]
[237,null,null,null,null,null,null,null,""]
[238,null,null,null,null,null,null,null,""]
[239,null,null,null,null,null,null,null,""]
[240,null,null,null,null,null,null,null,""]
[241,null,null,null,null,null,null,null,""]
[242,null,null,null,null,null,null,null,""]
[243,null,null,null,null,null,null,null,""]
[244,null,null,null,null,null,null,null,""]
[245,null,null,null,null,null,null,null,""]
[246,null,null,null,null,null,null,null,""]
[247,null,null,null,null,null,null,null,""]
[248,null,null,null,null,null,null,null,""]
[249,null,null,null,null,null,null,null,""]
[250,null,null,null,null,null,null,null,""]
[251,null,null,null,null,null,null,null,""]
[252,null,null,null,null,null,null,null,""]
[253,null,null,null,null,null,null,null,""]
[254,null,null,null,null,null,null,null,""]
[255,null,null,null,null,null,null,null,""]
[256,null,null,null,null,null,null,null,""]
[257,null,null,null,null,null,null,null,""]
[258,null,null,null,null,null,null,null,""]
[259,null,null,null,null,null,null,null,""]
[260,null,null,null,null,null,null,null,""]
[261,null,null,null,null,null,null,null,""]
[262,null,null,null,null,null,null,null,""]
[263]
[264]
[265]
[266]
[267]
[268]
[269]
[270]
[271]
[272]
[273]
[274]
[275]
[276]
[277]
[278]
[279]
[280]
[281]
[282]
[283]
[284]
[285]
[286]
[287]
[288]
[289]
[290]
[291]
[292]
[293]
[294]
[295]
[296]
[297]
[298]
[299]
[300]
[301]
[302]
[303]
[304]
[305]
[306]
[307]
[308]
[309]
[310]
[311]
[312]
[313]
[314]
[315]
[316]
[317]
[318]
[319]
[320]
[321]
[322]
[323]
[324]
[325]
[326]
[327]
[328]
[329]
[330]
[331]
[332]
[333]
[334]
[335]
[336]
[337]
[338]
[339]
[340]
[341]
[342]
[343]
[344]
[345]
[346]
[347]
[348]
[349]
[350]
[351]
[352]
[353]
[354]
[355]
[356]
[357]
[358]
[359]
[360]
[361]
[362]
[363]
[364]
[365]
[366]
[367]
[368]
[369]
[370]
[371]
[372]
[373]
[374]
[375]
[376]
[377]
[378]
[379]
[380]
[381]
[382]
[383]
[384]
[385]
[386]
[387]
[388]
[389]
[390]
[391]
[392]
[393]
[394]
[395]
[396]
[397]
[398]
[399]
[400]
[401]
[402]
[403]
[404]
[405]
[406]
[407]
[408]
[409]
[410]
[411]
[412]
[413]
[414]
[415]
[416]
[417]
[418]
[419]
[420]
[421]
[422]
[423]
[424]
[425]
[426]
[427]
[428]
[429]
[430]
[431]
[432]
[433]
[434]
[435]
[436]
[437]
[438]
[439]
[440]
[441]
[442]
[443]
[444]
[445]
[446]
[447]
[448]
[449]
[450]
[451]
[452]
[453]
[454]
[455]
[456]
[457]
[458]
[459]
[460]
[461]
[462]
[463]
[464]
[465]
[466]
[467]
[468]
[469]
[470]
[471]
[472]
[473]
[474]
[475]
[476]
[477]
[478]
[479]
[480]
[481]
[482]
[483]
[484]
[485]
[486]
[487]
[488]
[489]
[490]
[491]
[492]
[493]
[494]
[495]
[496]
[497]
[498]
[499]
[500]
[501]
[502]
[503]
[504]
[505]
[506]
[507]
[508]
[509]
[510]
[511]
[512]
[513]
[514]
[515]
[516]
[517]
[518]
[519]
[520]
[521]
[522]
[523]
[524]
[525]
[526]
[527]
[528]
[529]
[530]
[531]
[532]
[533]
[534]
[535]
[536]
[537]
[538]
[539]
[540]
[541]
[542]
[543]
[544]
[545]
[546]
[547]
[548]
[549]
[550]
[551]
[552]
[553]
[554]
[555]
[556]
[557]
[558]
[559]
[560]
[561]
[562]
[563]
[564]
[565]
[566]
[567]
[568]
[569]
[570]
[571]
[572]
[573]
[574]
[575]
[576]
[577]
[578]
[579]
[580]
[581]
[582]
[583]
[584]
[585]
[586]
[587]
[588]
[589]
[590]
[591]
[592]
[593]
[594]
[595]
[596]
[597]
[598]
[599]

{"sheet":"Target","index":1,"n_rows":35,"n_cols":11,"rows_kept":35,"cut":false,"hidden":false,"merged":[[6,7,7,10]]}
[null," 21/11/2020",null,null," 21/11/2020",null,null,null,null,1,"Start"]
["رقم المشترك",1,null,"رقم المشترك",2]
["الاسم الثلاثي ","عبدالقادر سعدي ",null,"الاسم الثلاثي ","حسام سعدي "]
["القراءة السابقة",0,null,"القراءة السابقة",0]
["القراءة الحالية",50,null,"القراءة الحالية",20]
["كمية الاستهلاك",50,null,"كمية الاستهلاك",20]
["سعر الكيلو",1.1000000000000001,null,"سعر الكيلو",1.1000000000000001,null,null,"طباعه "]
["المبلغ المستحق ",55.000000000000007,null,"المبلغ المستحق ",22]
[]
[null," 21/11/2020",null,null," 21/11/2020"]
["رقم المشترك",3,null,"رقم المشترك",4]
["الاسم الثلاثي ",null,null,"الاسم الثلاثي ","بشير السعدي "]
["القراءة السابقة",null,null,"القراءة السابقة",0]
["القراءة الحالية",null,null,"القراءة الحالية",30]
["كمية الاستهلاك",null,null,"كمية الاستهلاك",30]
["سعر الكيلو",null,null,"سعر الكيلو",1.1000000000000001]
["المبلغ المستحق ",null,null,"المبلغ المستحق ",33]
[]
[null," 21/11/2020",null,null," 21/11/2020"]
["رقم المشترك ",5,null,"رقم المشترك",6]
["الاسم الثلاثي ","إبراهيم العنزة ",null,"الاسم الثلاثي ","احمد غسان سعيد"]
["القراءة السابقة",0,null,"القراءة السابقة",0]
["القراءة الحالية",44,null,"القراءة الحالية",55]
["كمية الاستهلاك",44,null,"كمية الاستهلاك",55]
["سعر الكيلو",1.1000000000000001,null,"سعر الكيلو",1.1000000000000001]
["المبلغ المستحق ",48.400000000000006,null,"المبلغ المستحق ",60.500000000000007]
[]
[null," 21/11/2020",null,null," 21/11/2020"]
["رقم المشترك",7,null,"رقم المشترك",8]
["الاسم الثلاثي ","أنس عليطو ",null,"الاسم الثلاثي ","اسعد سعدي "]
["القراءة السابقة",0,null,"القراءة السابقة",0]
["القراءة الحالية",25,null,"القراءة الحالية",21]
["كمية الاستهلاك",25,null,"كمية الاستهلاك",21]
["سعر الكيلو",1.1000000000000001,null,"سعر الكيلو",1.1000000000000001]
["المبلغ المستحق ",27.500000000000004,null,"المبلغ المستحق ",23.1]

{"sheet":"By_one","index":2,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[4,3,4,4],[12,7,13,10]]}
[]
[]
[]
[]
[null,null,null,"مخيم الشهداء ",null,null,null,1,"Start"]
[null,null,null,"رقم المشترك",2]
[null,null,null,"الاسم الثلاثي ","حسام سعدي "]
[null,null,null,"القراءة السابقة",0]
[null,null,null,"القراءة الحالية",20]
[null,null,null,"كمية الاستهلاك",20]
[null,null,null,"سعر الكيلو",1.1000000000000001]
[null,null,null,"المبلغ المستحق ",22]
[null,null,null,"فاقد الشبكة ","Yes",null,null,"طباعه "]
[null,null,null,"تاريخ الدفع ","2020-10-11"]