{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Recp","Info","Data","Form","Login"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":3,"defined_names":8,"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":"Recp","index":0,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[7,0,7,5],[4,0,4,2],[5,0,5,2],[5,3,5,5],[6,0,6,2],[6,3,6,5]]}
[]
[]
[]
[]
[]
[]
[{"$f":"CONCATENATE(\"Date :- \",TEXT(TODAY(),\"DD-MM-YYYY\"))","v":"Date :- 24-10-2022"}]
["Report all subscriptions"]
["NO","Customer Name","Subtype","End Date"," Status","Amount"]
[{"$f":"TEXT(IF($B10=\"\",\"\",ROW()-10),\"000\")","v":"000"},"eee","kjjj","2022-10-16",150212.52100000001,7421.66]

{"sheet":"Info","index":1,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Subscriptions"]
["NO","Subscription type","Price","Code","T"]
[1,"Trial Sub. (1 day)",0,"\"D\"",2]
[2,"Trial Sub. Premium (1 day)",0,"\"D\"",2]
[3,"1 Month",140,"\"M\"",1]
[4,"3 Months",260,"\"M\"",3]
[5,"6 Months",600,"\"M\"",6]
[6,"6 M. Premium",600,"\"M\"",6]
[7,"One Year",1000,"\"M\"",12]
[8,"One Y.Premium",1500,"\"M\"",12]

{"sheet":"Data","index":2,"n_rows":10,"n_cols":16,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,15,2,15],[1,8,1,9],[1,10,1,13],[1,14,2,14],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,1,7]]}
[]
["م","Contract Date ","Sub. Type","Subscriber Name","Mobil No.","selling price",null,null,"Period",null,"Subscription data",null,null,null,"Sub. Status","days"]
[null,null,null,null,null,"Amount","Up Pay","Balnce","Start Date","End Date","Username","Password","MAC","Other"]
[null,"2022-10-03","1 Month","Name",123456789,100,70,30,"2022-10-03","2022-10-07","Username","Password","11223344ee66","Other",{"$f":"IFERROR(IF(J4=\"\",\"\",(IF(J4>=TODAY(),\"Active\",IF(J4<TODAY(),\"Inactive\",IF(J4=\"\",\" \"))))),\"--\")","v":"Inactive"},{"$f":"IF(AND($I4<>\"\",$J4<>\"\",J4>=I4),DAYS360(TODAY(),$J4),\"\")","v":-17}]
[1,"2022-10-15","1 month","Dahy Algharieb",201143333333,300,300,0,"2022-10-17","2022-10-25","W1011000","S701_0Gty#","11:ee:1t:f9:71:r6","other1","Active",{"$f":"IF(AND($I5<>\"\",$J5<>\"\",J5>=I5),DAYS360(TODAY(),$J5),\"\")","v":1}]
[2,"2022-10-15","Trial Sub. (1 day)","Shaky Rabia",966543030309,0,0,0,"2022-10-13","2022-10-22","Re1211452","E52yYp5@11","11:ee:1t:f9:71:r7","other2",{"$f":"IFERROR(IF(J6=\"\",\"\",(IF(J6>=TODAY(),\"Active\",IF(J6<TODAY(),\"Inactive\",IF(J6=\"\",\" \"))))),\"--\")","v":"Inactive"},{"$f":"IF(AND($I6<>\"\",$J6<>\"\",J6>=I6),DAYS360(TODAY(),$J6),\"\")","v":-2}]
[3,"2022-10-16","Admin","Raagab Jaoesh",1129999333,290,290,0,"2022-10-17","2023-01-16","NHS1542111","44@POff121","11:ee:1t:f9:71:r8","other3",{"$f":"IFERROR(IF(J7=\"\",\"\",(IF(J7>=TODAY(),\"Active\",IF(J7<TODAY(),\"Inactive\",IF(J7=\"\",\" \"))))),\"--\")","v":"Active"},82]
[4,"2022-10-16","1 Month","Hamada Omar",1111111444,100,100,0,"2022-10-16","2022-11-15","HHB1213566","W215Da1*","11:ee:1t:f9:71:r9","other4",{"$f":"IFERROR(IF(J8=\"\",\"\",(IF(J8>=TODAY(),\"Active\",IF(J8<TODAY(),\"Inactive\",IF(J8=\"\",\" \"))))),\"--\")","v":"Active"},21]
[5,"2022-10-16","3 Months","Ahmed Fadila",1055555555,290,290,0,"2022-10-16","2023-01-15","HMm211","Trf781Ghb36","11:ee:1t:f9:71:r10","other5",{"$f":"IFERROR(IF(J9=\"\",\"\",(IF(J9>=TODAY(),\"Active\",IF(J9<TODAY(),\"Inactive\",IF(J9=\"\",\" \"))))),\"--\")","v":"Active"},81]
[6,"2022-10-22","1 Month","Magdy Youins","02 010 101 010 355",140,0,140,"2022-10-22","2022-11-21","tamta0","tttt","11ee11eee11ee","ttt",{"$f":"IFERROR(IF(J10=\"\",\"\",(IF(J10>=TODAY(),\"Active\",IF(J10<TODAY(),\"Inactive\",IF(J10=\"\",\" \"))))),\"--\")","v":"Active"},{"$f":"IF(AND($I10<>\"\",$J10<>\"\",J10>=I10),DAYS360(TODAY(),$J10),\"\")","v":27}]

{"sheet":"Form","index":3,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null," "]

{"sheet":"Login","index":4,"n_rows":181,"n_cols":10,"rows_kept":181,"cut":false,"hidden":false,"merged":[[1,0,1,1],[1,6,1,7]]}
[1,2,3,4,5,6,7,8,9]
["Users report access"]
["Login Name","Date","Time",null,null,null,"Username","Passcode","Remmber me","Acess"]
["zad","2022-10-20","20:08:58","Admin","Current User",null,"Dahy ",1234,null,"Admin"]
["dahy","2022-10-20","20:09:45","Admin","Dahy ",null,"zad",1,null,"User"]
["dahy","2022-10-21","20:20:35","Admin",null,null,"admin",222,null,"User"]
["zad","2022-10-20","20:24:51","Admin","Acess"]
["zad","2022-10-20","23:43:08","Admin","Admin"]
["dahy","2022-10-21","00:13:27","Admin",1234]
["dahy","2022-10-21","00:41:39","Admin"]
["dahy","2022-10-21","00:52:11","Admin"]
["dahy","2022-10-21","00:55:28","Admin"]
["dahy","2022-10-21","00:56:15","Admin"]
["dahy","2022-10-21","01:03:10","Admin"]
["dahy","2022-10-21","01:19:48","Admin"]
["dahy","2022-10-21","01:31:07","Admin"]
["dahy","2022-10-21","01:32:07","Admin"]
["dahy","2022-10-21","01:45:36","Admin"]
["dahy","2022-10-21","01:46:12","Admin"]
["dahy","2022-10-21","19:51:04","Admin"]
["zad","2022-10-21","19:56:11","Admin"]
["dahy","2022-10-21","19:57:30","Admin"]
["dahy","2022-10-21","19:59:12","Admin"]
["dahy","2022-10-21","20:19:59","Admin"]
["dahy","2022-10-21","20:20:40","Admin"]
["dahy","2022-10-21","20:22:20","Admin"]
["dahy","2022-10-21","20:28:56","Admin"]
["dahy","2022-10-21","21:04:36","Admin"]
["dahy","2022-10-21","21:28:57","Admin"]
["zad","2022-10-22","00:02:27","User"]
["zad","2022-10-22","00:03:16","User"]
["zad","2022-10-22","00:03:51","User"]
["dahy","2022-10-22","00:19:40","Admin"]
["dahy","2022-10-22","02:21:29","Admin"]
["zad","2022-10-22","02:56:19","User"]
["zad","2022-10-22","03:00:27","User"]
["zad","2022-10-22","03:01:42","User"]
["zad","2022-10-22","03:03:24","User"]
["dahy","2022-10-22","03:09:04","Admin"]
["zad","2022-10-22","03:30:35","User"]
["dahy","2022-10-22","03:44:04","Admin"]
["zad","2022-10-22","04:52:34","User"]
["zad","2022-10-22","04:52:55","User"]
["dahy","2022-10-22","05:00:46","Admin"]
["dahy","2022-10-22","05:02:05","Admin"]
["dahy","2022-10-22","05:03:33","Admin"]
["zad","2022-10-22","05:08:11","User"]
["dahy","2022-10-22","05:17:52","Admin"]
["dahy","2022-10-22","12:22:38","Admin"]
["dahy","2022-10-22","12:42:16","Admin"]
["dahy","2022-10-22","13:21:22","Admin"]
["dahy","2022-10-22","13:31:19","Admin"]
["dahy","2022-10-22","13:38:50","Admin"]
["dahy","2022-10-22","13:40:03","Admin"]
["dahy","2022-10-22","13:44:43","Admin"]
["dahy","2022-10-22","13:48:52","Admin"]
["dahy","2022-10-22","13:52:09","Admin"]
["dahy","2022-10-22","13:56:43","Admin"]
["dahy","2022-10-22","14:41:26","Admin"]
["dahy","2022-10-22","14:47:04","Admin"]
["dahy","2022-10-22","14:56:43","Admin"]
["zad","2022-10-22","14:58:01","User"]
["zad","2022-10-22","14:58:59","User"]
["zad","2022-10-22","14:59:46","User"]
["zad","2022-10-22","15:01:18","User"]
["zad","2022-10-22","15:02:06","User"]
["dahy","2022-10-22","15:02:28","Admin"]
["zad","2022-10-22","15:04:05","User"]
["zad","2022-10-22","15:04:51","User"]
["dahy","2022-10-22","15:08:15","Admin"]
["dahy","2022-10-22","15:10:36","Admin"]
["dahy","2022-10-22","15:12:11","Admin"]
["dahy","2022-10-22","15:13:10","Admin"]
["zad","2022-10-22","15:13:34","User"]
["zad","2022-10-22","15:14:01","User"]
["zad","2022-10-22","15:14:35","User"]
["zad","2022-10-22","15:15:11","User"]
["zad","2022-10-22","15:19:02","User"]
["dahy","2022-10-22","15:20:09","Admin"]
["dahy","2022-10-22","15:20:34","Admin"]
["dahy","2022-10-22","15:21:32","Admin"]
["dahy","2022-10-22","15:25:07","Admin"]
["dahy","2022-10-22","15:25:35","Admin"]
["dahy","2022-10-22","15:28:28","Admin"]
["dahy","2022-10-22","15:30:01","Admin"]
["zad","2022-10-22","15:32:33","User"]
["dahy","2022-10-22","15:35:13","Admin"]
["dahy","2022-10-22","15:42:05","Admin"]
["dahy","2022-10-22","15:42:53","Admin"]
["dahy","2022-10-22","15:47:34","Admin"]
["dahy","2022-10-22","15:50:17","Admin"]
["dahy","2022-10-22","15:51:03","Admin"]
["dahy","2022-10-22","15:52:25","Admin"]
["dahy","2022-10-22","15:56:21","Admin"]
["dahy","2022-10-22","15:58:01","Admin"]
["dahy","2022-10-22","16:05:21","Admin"]
["dahy","2022-10-22","16:06:16","Admin"]
["dahy","2022-10-22","16:13:48","Admin"]
["dahy","2022-10-22","16:30:30","Admin"]
["dahy","2022-10-22","16:38:53","Admin"]
["dahy","2022-10-22","16:42:31","Admin"]
["dahy","2022-10-22","16:45:20","Admin"]
["dahy","2022-10-22","16:47:45","Admin"]
["dahy","2022-10-22","16:49:00","Admin"]
["dahy","2022-10-22","16:58:32","Admin"]
["dahy","2022-10-22","17:00:42","Admin"]
["dahy","2022-10-22","17:01:52","Admin"]
["dahy","2022-10-22","17:02:53","Admin"]
["dahy","2022-10-22","17:36:38","Admin"]
["dahy","2022-10-22","17:38:05","Admin"]
["dahy","2022-10-22","17:41:36","Admin"]
["adam","2022-10-22","17:43:52","User"]
["dahy","2022-10-22","17:46:03","Admin"]
["dahy","2022-10-22","17:50:28","Admin"]
["dahy","2022-10-22","17:51:30","Admin"]
["dahy","2022-10-22","17:52:25","Admin"]
["dahy","2022-10-22","17:57:27","Admin"]
["dahy","2022-10-22","19:46:15","Admin"]
["dahy","2022-10-22","20:19:51","Admin"]
["dahy","2022-10-22","20:22:37","Admin"]
["dahy","2022-10-22","20:30:36","Admin"]
["dahy","2022-10-22","20:32:15","Admin"]
["dahy","2022-10-22","20:34:23","Admin"]
["dahy","2022-10-22","20:37:33","Admin"]
["dahy","2022-10-22","20:39:03","Admin"]
["dahy","2022-10-22","20:40:11","Admin"]
["dahy","2022-10-22","20:40:58","Admin"]
["dahy","2022-10-22","20:42:59","Admin"]
["dahy","2022-10-22","20:44:58","Admin"]
["dahy","2022-10-22","20:50:23","Admin"]
["dahy","2022-10-22","21:15:50","Admin"]
["dahy","2022-10-22","21:26:11","Admin"]
["dahy","2022-10-22","21:27:03","Admin"]
["dahy","2022-10-22","21:35:29","Admin"]
["dahy","2022-10-22","21:41:56","Admin"]
["dahy","2022-10-22","21:52:29","Admin"]
["dahy","2022-10-22","21:53:51","Admin"]
["dahy","2022-10-22","21:55:41","Admin"]
["dahy","2022-10-22","22:03:33","Admin"]
["dahy","2022-10-22","22:09:50","Admin"]
["dahy","2022-10-22","22:11:33","Admin"]
["dahy","2022-10-22","22:12:30","Admin"]
["dahy","2022-10-22","22:16:00","Admin"]
["dahy","2022-10-22","22:16:56","Admin"]
["dahy","2022-10-22","22:41:11","Admin"]
["dahy","2022-10-22","22:45:13","Admin"]
["dahy","2022-10-22","22:51:41","Admin"]
["dahy","2022-10-22","22:55:05","Admin"]
["dahy","2022-10-22","22:55:33","Admin"]
["dahy","2022-10-22","23:02:25","Admin"]
["dahy","2022-10-22","23:02:45","Admin"]
["dahy","2022-10-22","23:03:43","Admin"]
["dahy","2022-10-22","23:11:32","Admin"]
["dahy","2022-10-22","23:19:52","Admin"]
["zad","2022-10-22","23:26:36","User"]
["dahy","2022-10-23","11:48:55","Admin"]
["dahy","2022-10-23","14:57:27","Admin"]
["dahy","2022-10-23","15:00:48","Admin"]
["dahy","2022-10-23","15:04:32","Admin"]
["dahy1","2022-10-23","15:07:54","Admin"]
["dahy1","2022-10-23","15:09:25","Admin"]
["Dahy ","2022-10-23","15:17:05","Admin"]
["Dahy ","2022-10-23","15:23:28","Admin"]
["Dahy ","2022-10-23","15:25:43","Admin"]
["Dahy ","2022-10-23","15:28:34","Admin"]
["Dahy ","2022-10-23","15:31:11","Admin"]
["Dahy ","2022-10-23","17:21:53","Admin"]
["Dahy ","2022-10-23","17:26:54","Admin"]
["Dahy ","2022-10-23","17:43:00","Admin"]
["Dahy ","2022-10-23","17:51:27","Admin"]
["Dahy ","2022-10-23","18:07:03","Admin"]
["Dahy ","2022-10-23","18:12:30","Admin"]
["Dahy ","2022-10-23","18:14:41","Admin"]
["Dahy ","2022-10-23","18:31:57","Admin"]
["Dahy ","2022-10-23","18:32:57","Admin"]
["Dahy ","2022-10-23","22:55:26","Admin"]
["Dahy ","2022-10-23","22:58:02","Admin"]
["Dahy ","2022-10-23","23:09:21","Admin"]
["Dahy ","2022-10-23","23:17:41","Admin"]
["Dahy ","2022-10-23","23:22:02","Admin"]
["Dahy ","2022-10-24","19:50:22","Admin"]