{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["الكتب","تعريفات","الكتب حسب التصنيف"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,"الكود","المجالات","المجالات الفرعية","الكتب","كود الكتاب ","رقم الدولاب "," رقم الصف "]
[{"$f":"IF('الكتب حسب التصنيف'!$D$5=الكتب!$C$2:$C$14,COUNTIFS($B$2:B2,B2,$C$2:C2,C2),\"\")","v":""},1,{"$f":"VLOOKUP(B2,تعريفات!$A$3:$B$10,2,0)","v":"الدعوي"},"اعدادي ","هذة الدعوة .. ما طبيعتها ","1-2ع",8,75]
[{"$f":"IF('الكتب حسب التصنيف'!$D$5=الكتب!$C$2:$C$14,COUNTIFS($B$2:B3,B3,$C$2:C3,C3),\"\")","v":""},1,{"$f":"VLOOKUP(B3,تعريفات!$A$3:$B$10,2,0)","v":"الدعوي"},"اعدادي ","روحانية الداعية ","2-2ع",8,75]
[{"$f":"IF('الكتب حسب التصنيف'!$D$5=الكتب!$C$2:$C$14,COUNTIFS($B$2:B4,B4,$C$2:C4,C4),\"\")","v":""},1,{"$f":"VLOOKUP(B4,تعريفات!$A$3:$B$10,2,0)","v":"الدعوي"},"اعدادي "," أخلاقية الداعية ","3-2ع",8,75]
[{"$f":"IF('الكتب حسب التصنيف'!$D$5=الكتب!$C$2:$C$14,COUNTIFS($B$2:B5,B5,$C$2:C5,C5),\"\")","v":""},2,{"$f":"VLOOKUP(B5,تعريفات!$A$3:$B$10,2,0)","v":"اللغة والتواصل"},"اعدادي","حديث الصمت ","15-8ع",20,39]
[{"$f":"IF('الكتب حسب التصنيف'!$D$5=الكتب!$C$2:$C$14,COUNTIFS($B$2:B6,B6,$C$2:C6,C6),\"\")","v":""},2,{"$f":"VLOOKUP(B6,تعريفات!$A$3:$B$10,2,0)","v":"اللغة والتواصل"},"اعدادي","قشرة البيضة","16-8ع",20,39]
[{"$f":"IF('الكتب حسب التصنيف'!$D$5=الكتب!$C$2:$C$14,COUNTIFS($B$2:B7,B7,$C$2:C7,C7),\"\")","v":""},2,{"$f":"VLOOKUP(B7,تعريفات!$A$3:$B$10,2,0)","v":"اللغة والتواصل"},"اعدادي","صدى الضلعان","17-8ع",20,39]
[{"$f":"IF('الكتب حسب التصنيف'!$D$5=الكتب!$C$2:$C$14,COUNTIFS($B$2:B8,B8,$C$2:C8,C8),\"\")","v":""},2,{"$f":"VLOOKUP(B8,تعريفات!$A$3:$B$10,2,0)","v":"اللغة والتواصل"},"اعدادي","أحلام مؤجلة ","18-8ع",20,39]
[{"$f":"IF('الكتب حسب التصنيف'!$D$5=الكتب!$C$2:$C$14,COUNTIFS($B$2:B9,B9,$C$2:C9,C9),\"\")","v":""},3,{"$f":"VLOOKUP(B9,تعريفات!$A$3:$B$10,2,0)","v":"التربوي والتعليمي"},"ثانوي ","موسوعة الثقافة والمعلومات ج 3 ","113-4ث",7,64]
[{"$f":"IF('الكتب حسب التصنيف'!$D$5=الكتب!$C$2:$C$14,COUNTIFS($B$2:B10,B10,$C$2:C10,C10),\"\")","v":""},3,{"$f":"VLOOKUP(B10,تعريفات!$A$3:$B$10,2,0)","v":"التربوي والتعليمي"},"ثانوي ","اختبر ثقافتك الإسلامية في 1000 سؤال وجواب ","114-4ث",7,64]
[{"$f":"IF('الكتب حسب التصنيف'!$D$5=الكتب!$C$2:$C$14,COUNTIFS($B$2:B11,B11,$C$2:C11,C11),\"\")","v":""},3,{"$f":"VLOOKUP(B11,تعريفات!$A$3:$B$10,2,0)","v":"التربوي والتعليمي"},"ثانوي ","تذكرة السامع والمتكلم في أدب العالم والمتعلم ","115-4ث",7,64]
[{"$f":"IF('الكتب حسب التصنيف'!$D$5=الكتب!$C$2:$C$14,COUNTIFS($B$2:B12,B12,$C$2:C12,C12),\"\")","v":""},3,{"$f":"VLOOKUP(B12,تعريفات!$A$3:$B$10,2,0)","v":"التربوي والتعليمي"},"ثانوي ","قوة الصبر ","101-6ث",6,53]
[{"$f":"IF('الكتب حسب التصنيف'!$D$5=الكتب!$C$2:$C$14,COUNTIFS($B$2:B13,B13,$C$2:C13,C13),\"\")","v":1},4,{"$f":"VLOOKUP(B13,تعريفات!$A$3:$B$10,2,0)","v":"النفسي وإدارة الذات"},"ثانوي ","القراءة الذكية ","102-6ث",6,53]
[{"$f":"IF('الكتب حسب التصنيف'!$D$5=الكتب!$C$2:$C$14,COUNTIFS($B$2:B14,B14,$C$2:C14,C14),\"\")","v":2},4,{"$f":"VLOOKUP(B14,تعريفات!$A$3:$B$10,2,0)","v":"النفسي وإدارة الذات"},"ثانوي ","كن فعالاً","103-6ث",6,53]

{"sheet":"تعريفات","index":1,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
["الكود","المجال"]
[1,"الدعوي"]
[2,"اللغة والتواصل"]
[3,"التربوي والتعليمي"]
[4,"النفسي وإدارة الذات"]

{"sheet":"الكتب حسب التصنيف","index":2,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,"الكود",4]
[null,null,"المجال",{"$f":"VLOOKUP(D4,تعريفات!$A$3:$B$7,2,0)","v":"النفسي وإدارة الذات"}]
[]
["م","المجالات الفرعية","الكتب","كود الكتاب ","رقم الدولاب "," رقم الصف "]
[{"$f":"IF(B8=\"\",\"\",SUBTOTAL(3,$B$8:B8))","v":1},{"$f":"IFERROR(VLOOKUP(ROW()-7,الكتب!$A$2:$H$14,4,0),\"\")","v":"ثانوي "},{"$f":"IFERROR(VLOOKUP(ROW()-7,الكتب!$A$2:$H$14,5,0),\"\")","v":"القراءة الذكية "},{"$f":"IFERROR(VLOOKUP(ROW()-7,الكتب!$A$2:$H$14,6,0),\"\")","v":"102-6ث"},{"$f":"IFERROR(VLOOKUP(ROW()-7,الكتب!$A$2:$H$14,7,0),\"\")","v":6},{"$f":"IFERROR(VLOOKUP(ROW()-7,الكتب!$A$2:$H$14,8,0),\"\")","v":53}]
[{"$f":"IF(B9=\"\",\"\",SUBTOTAL(3,$B$8:B9))","v":2},{"$f":"IFERROR(VLOOKUP(ROW()-7,الكتب!$A$2:$H$14,4,0),\"\")","v":"ثانوي "},{"$f":"IFERROR(VLOOKUP(ROW()-7,الكتب!$A$2:$H$14,5,0),\"\")","v":"كن فعالاً"},{"$f":"IFERROR(VLOOKUP(ROW()-7,الكتب!$A$2:$H$14,6,0),\"\")","v":"103-6ث"},{"$f":"IFERROR(VLOOKUP(ROW()-7,الكتب!$A$2:$H$14,7,0),\"\")","v":6},{"$f":"IFERROR(VLOOKUP(ROW()-7,الكتب!$A$2:$H$14,8,0),\"\")","v":53}]
[{"$f":"IF(B10=\"\",\"\",SUBTOTAL(3,$B$8:B10))","v":""},{"$f":"IFERROR(VLOOKUP(ROW()-7,الكتب!$A$2:$H$14,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(ROW()-7,الكتب!$A$2:$H$14,5,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(ROW()-7,الكتب!$A$2:$H$14,6,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(ROW()-7,الكتب!$A$2:$H$14,7,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(ROW()-7,الكتب!$A$2:$H$14,8,0),\"\")","v":""}]
[{"$f":"IF(B11=\"\",\"\",SUBTOTAL(3,$B$8:B11))","v":""},{"$f":"IFERROR(VLOOKUP(ROW()-7,الكتب!$A$2:$H$14,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(ROW()-7,الكتب!$A$2:$H$14,5,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(ROW()-7,الكتب!$A$2:$H$14,6,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(ROW()-7,الكتب!$A$2:$H$14,7,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(ROW()-7,الكتب!$A$2:$H$14,8,0),\"\")","v":""}]
[{"$f":"IF(B12=\"\",\"\",SUBTOTAL(3,$B$8:B12))","v":""},{"$f":"IFERROR(VLOOKUP(ROW()-7,الكتب!$A$2:$H$14,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(ROW()-7,الكتب!$A$2:$H$14,5,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(ROW()-7,الكتب!$A$2:$H$14,6,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(ROW()-7,الكتب!$A$2:$H$14,7,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(ROW()-7,الكتب!$A$2:$H$14,8,0),\"\")","v":""}]
[{"$f":"IF(B13=\"\",\"\",SUBTOTAL(3,$B$8:B13))","v":""},{"$f":"IFERROR(VLOOKUP(ROW()-7,الكتب!$A$2:$H$14,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(ROW()-7,الكتب!$A$2:$H$14,5,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(ROW()-7,الكتب!$A$2:$H$14,6,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(ROW()-7,الكتب!$A$2:$H$14,7,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(ROW()-7,الكتب!$A$2:$H$14,8,0),\"\")","v":""}]
[{"$f":"IF(B14=\"\",\"\",SUBTOTAL(3,$B$8:B14))","v":""},{"$f":"IFERROR(VLOOKUP(ROW()-7,الكتب!$A$2:$H$14,4,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(ROW()-7,الكتب!$A$2:$H$14,5,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(ROW()-7,الكتب!$A$2:$H$14,6,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(ROW()-7,الكتب!$A$2:$H$14,7,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(ROW()-7,الكتب!$A$2:$H$14,8,0),\"\")","v":""}]