{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["0% 5years ","6% 6years","10% 7years","15% 8years","Price List","المطلوب فى الشيت"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"0% 5years ","index":0,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[25,1,28,1],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,1,32,1],[29,2,29,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[17,1,20,1],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,1,24,1],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[10,2,10,3],[13,1,16,1],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[8,2,8,3],[0,2,1,4],[0,5,1,5],[2,3,2,4],[3,2,3,3],[7,2,7,3]]}
[null,null,"Payment Sheet",null,null,"5 Years"]
[]
[null,null,"Unit Number"]
[null,null,"Price                    ","B8",2000000]
[null,null,"Payment",0.15,{"$f":"D5*E4","v":300000}]
[null,null,"Discount",0.15,0]
[null,null,"Parking",null,100000]
[null,null,"Club House",null,80000]
[null,null,"Final Price",null,{"$f":"E4-E6+E7+E8","v":2180000}]
[null,null,"Maintenance",0.08,{"$f":"(E4-E6)*D10","v":160000},"2022-06-30"]
[null,null,"Contracting Date:",null,{"$f":"TODAY()","v":"2020-07-13"}]
[]
[null,"Year","Checks Details",null,"Check Dates M/Y","Amount EGP"]
[null,1,"Check 1",null,{"$f":"EDATE(E11,0)","v":"2020-07-13"},{"$f":"($E$4-$E$5-$E$6+$E$7+$E$8)/20","v":94000}]
[null,null,"Check 2",null,{"$f":"EDATE(E14,3)","v":"2020-10-13"},{"$f":"($E$4-$E$5-$E$6+$E$7+$E$8)/20","v":94000}]
[null,null,"Check 3",null,"2021-01-13",94000]
[null,null,"Check 4",null,"2021-04-13",94000]
[null,2,"Check 5",null,"2021-07-13",94000]
[null,null,"Check 6",null,"2021-10-13",94000]
[null,null,"Check 7",null,"2022-01-13",94000]
[null,null,"Check 8",null,"2022-04-13",94000]
[null,3,"Check 9",null,"2022-07-13",94000]
[null,null,"Check 10",null,"2022-10-13",94000]
[null,null,"Check 11",null,"2023-01-13",94000]
[null,null,"Check 12",null,"2023-04-13",94000]
[null,4,"Check 13",null,"2023-07-13",94000]
[null,null,"Check 14",null,"2023-10-13",94000]
[null,null,"Check 15",null,"2024-01-13",94000]
[null,null,"Check 16",null,"2024-04-13",94000]
[null,5,"Check 17",null,"2024-07-13",94000]
[null,null,"Check 18",null,"2024-10-13",94000]
[null,null,"Check 19",null,"2025-01-13",94000]
[null,null,"Check 20",null,"2025-04-13",94000,{"$f":"SUM(F14:F33)","v":1880000}]
[]
[null,null,null,null,null,"Date",{"$f":"TODAY()","v":"2020-07-13"}]

{"sheet":"6% 6years","index":1,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[[35,2,35,3],[36,2,36,3],[33,1,36,1],[29,1,32,1],[30,2,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[29,2,29,3],[17,1,20,1],[21,1,24,1],[22,2,22,3],[23,2,23,3],[24,2,24,3],[18,2,18,3],[21,2,21,3],[20,2,20,3],[19,2,19,3],[17,2,17,3],[25,1,28,1],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[0,5,1,5],[2,3,2,4],[3,2,3,3],[16,2,16,3],[6,2,6,3],[7,2,7,3],[13,1,16,1],[8,2,8,3],[0,2,1,4],[13,2,13,3],[14,2,14,3],[15,2,15,3]]}
[null,null,"Payment Sheet",null,null,"6 Years"]
[]
[null,null,"Unit Number"]
[null,null,"Price  ",null,2000000]
[null,null,"Down Payment",{"$f":"E5/E4","v":0.1},200000]
[null,null,"Annual",0.06,0,"2020-11-11"]
[null,null,"Parking",null,0,"Free"]
[null,null,"Club House",null,0,"Free"]
[null,null,"Final Price",null,{"$f":"E4+E7+E8","v":2000000}]
[null,null,"Maintenance",0.08,{"$f":"E4*D10","v":160000},"2022-06-30"]
[null,null,"Contracting Date:",null,{"$f":"TODAY()","v":"2020-07-13"}]
[]
[null,"Year","Checks Details",null,"Check Dates M/Y","Amount EGP"]
[null,1,"Check 1",null,{"$f":"EDATE(E11,3)","v":"2020-10-13"},{"$f":"((E$4-E$5-E$6+E$7+E$8)/24)","v":75000}]
[null,null,"Check 2",null,{"$f":"EDATE(E14,3)","v":"2021-01-13"},75000]
[null,null,"Check 3",null,"2021-04-13",75000]
[null,null,"Check 4",null,"2021-07-13",75000]
[null,2,"Check 5",null,"2021-10-13",75000]
[null,null,"Check 6",null,"2022-01-13",75000]
[null,null,"Check 7",null,"2022-04-13",75000]
[null,null,"Check 8",null,"2022-07-13",75000]
[null,3,"Check 9",null,"2022-10-13",75000]
[null,null,"Check 10",null,"2023-01-13",75000]
[null,null,"Check 11",null,"2023-04-13",75000]
[null,null,"Check 12",null,"2023-07-13",75000]
[null,4,"Check 13",null,"2023-10-13",75000]
[null,null,"Check 14",null,"2024-01-13",75000]
[null,null,"Check 15",null,"2024-04-13",75000]
[null,null,"Check 16",null,"2024-07-13",75000]
[null,5,"Check 17",null,"2024-10-13",75000]
[null,null,"Check 18",null,"2025-01-13",75000]
[null,null,"Check 19",null,"2025-04-13",75000]
[null,null,"Check 20",null,"2025-07-13",75000]
[null,6,"Check 21",null,{"$f":"EDATE(E33,3)","v":"2025-10-13"},75000]
[null,null,"Check 22",null,{"$f":"EDATE(E34,3)","v":"2026-01-13"},75000]
[null,null,"Check 23",null,{"$f":"EDATE(E35,3)","v":"2026-04-13"},75000]
[null,null,"Check 24",null,{"$f":"EDATE(E36,3)","v":"2026-07-13"},75000,{"$f":"SUM(F14:F37)","v":1800000}]
[]
[null,null,null,null,null,"Date",{"$f":"TODAY()","v":"2020-07-13"}]

{"sheet":"10% 7years","index":2,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":false,"merged":[[41,2,41,3],[22,1,25,1],[18,1,21,1],[14,1,17,1],[26,1,29,1],[30,1,33,1],[34,1,37,1],[38,1,41,1],[36,2,36,3],[37,2,37,3],[38,2,38,3],[39,2,39,3],[40,2,40,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[35,2,35,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[8,2,8,3],[21,2,21,3],[9,2,9,3],[19,2,19,3],[20,2,20,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[0,5,1,5],[2,3,2,4],[0,2,1,4],[7,2,7,3],[3,2,3,3]]}
[null,null,"Payment Sheet",null,null,"7 Years"]
[]
[null,null,"Unit Number"]
[null,null,"Price  ",null,2000000]
[null,null,"Down Payment",0.1,{"$f":"E4*D5","v":200000}]
[null,null,"Annual",0.05,{"$f":"E4*D6","v":100000},"2020-12-01"]
[null,null,"Annual",0.05,{"$f":"E4*D7","v":100000},"2021-12-01"]
[null,null,"Parking",null,80000]
[null,null,"Club House",null,80000]
[null,null,"Final Price",null,{"$f":"E4+E8+E9","v":2160000}]
[null,null,"Maintenance",0.08,{"$f":"E4*D11","v":160000},"2022-06-30"]
[null,null,"Contracting Date:",null,{"$f":"TODAY()","v":"2020-07-13"}]
[]
[null,"Year","Checks Details",null,"Check Dates M/Y","Amount EGP"]
[null,1,"Check 1",null,{"$f":"EDATE(E12,3)","v":"2020-10-13"},{"$f":"((E$4-E$5-E$6-E$7+E$8+E$9)/28)","v":62857.142857142855}]
[null,null,"Check 2",null,{"$f":"EDATE(E15,3)","v":"2021-01-13"},{"$f":"((E$4-E$5-E$6-E$7+E$8+E$9)/28)","v":62857.142857142855}]
[null,null,"Check 3",null,"2021-04-13",62857.142857142855]
[null,null,"Check 4",null,"2021-07-13",62857.142857142855]
[null,2,"Check 5",null,"2021-10-13",62857.142857142855]
[null,null,"Check 6",null,"2022-01-13",62857.142857142855]
[null,null,"Check 7",null,"2022-04-13",62857.142857142855]
[null,null,"Check 8",null,"2022-07-13",62857.142857142855]
[null,3,"Check 9",null,"2022-10-13",62857.142857142855]
[null,null,"Check 10",null,"2023-01-13",62857.142857142855]
[null,null,"Check 11",null,"2023-04-13",62857.142857142855]
[null,null,"Check 12",null,"2023-07-13",62857.142857142855]
[null,4,"Check 13",null,"2023-10-13",62857.142857142855]
[null,null,"Check 14",null,"2024-01-13",62857.142857142855]
[null,null,"Check 15",null,"2024-04-13",62857.142857142855]
[null,null,"Check 16",null,"2024-07-13",62857.142857142855]
[null,5,"Check 17",null,"2024-10-13",62857.142857142855]
[null,null,"Check 18",null,"2025-01-13",62857.142857142855]
[null,null,"Check 19",null,"2025-04-13",62857.142857142855]
[null,null,"Check 20",null,"2025-07-13",62857.142857142855]
[null,6,"Check 21",null,{"$f":"EDATE(E34,3)","v":"2025-10-13"},62857.142857142855]
[null,null,"Check 22",null,"2026-01-13",62857.142857142855]
[null,null,"Check 23",null,"2026-04-13",62857.142857142855]
[null,null,"Check 24",null,"2026-07-13",62857.142857142855]
[null,7,"Check 25",null,"2026-10-13",62857.142857142855]
[null,null,"Check 26",null,"2027-01-13",62857.142857142855]
[null,null,"Check 27",null,"2027-04-13",62857.142857142855]
[null,null,"Check 28",null,"2027-07-13",62857.142857142855,{"$f":"SUM(F15:F42)","v":1760000.0000000009}]
[]
[null,null,null,null,null,"Date",{"$f":"TODAY()","v":"2020-07-13"}]

{"sheet":"15% 8years","index":3,"n_rows":47,"n_cols":7,"rows_kept":47,"cut":false,"hidden":false,"merged":[[46,2,46,3],[39,1,42,1],[43,1,46,1],[10,2,10,3],[41,2,41,3],[42,2,42,3],[43,2,43,3],[44,2,44,3],[45,2,45,3],[39,2,39,3],[40,2,40,3],[25,2,25,3],[15,1,18,1],[26,2,26,3],[27,2,27,3],[28,2,28,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[24,2,24,3],[22,2,22,3],[23,2,23,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[0,5,1,5],[2,3,2,4],[8,2,8,3],[15,2,15,3],[0,2,1,4],[3,2,3,3],[9,2,9,3],[19,1,22,1],[23,1,26,1],[27,1,30,1],[31,1,34,1],[35,1,38,1],[34,2,34,3],[35,2,35,3],[36,2,36,3],[37,2,37,3],[38,2,38,3],[29,2,29,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3]]}
[null,null,"Payment Sheet",null,null,"8 Years"]
[]
[null,null,"Unit Number"]
[null,null,"Price  ",null,2000000]
[null,null,"Down Payment",0.15,150000]
[null,null,"Annual",0.05,200000,"2022-03-22"]
[null,null,"Annual",0.05,0]
[null,null,"Annual",0.05,0]
[null,null,"Parking",null,80000]
[null,null,"Club House",null,0,"FREE"]
[null,null,"Final Price",null,{"$f":"E4+E9+E10","v":2080000}]
[null,null,"Maintenance",0.08,{"$f":"E4*D12","v":160000},"2022-06-30"]
[null,null,"Contracting Date:",null,{"$f":"TODAY()","v":"2020-07-13"}]
[]
[null,"Year","Checks Details",null,"Check Dates M/Y","Amount EGP"]
[null,1,"Check 1",null,{"$f":"EDATE(E13,3)","v":"2020-10-13"},{"$f":"((E$4-E$5-E$6-E$7-E$8+E$9+E$10)/30)","v":57666.666666666664}]
[null,null,"Check 2",null,{"$f":"EDATE(E16,3)","v":"2021-01-13"},{"$f":"((E$4-E$5-E$6-E$7-E$8+E$9+E$10)/30)","v":57666.666666666664}]
[null,null,"Check 3",null,"2021-04-13",57666.666666666664]
[null,null,"Check 4",null,"2021-07-13",57666.666666666664]
[null,2,"Check 5",null,"2021-10-13",57666.666666666664]
[null,null,"Check 6",null,"2022-01-13",57666.666666666664]
[null,null,"Check 7",null,"2022-04-13",57666.666666666664]
[null,null,"Check 8",null,"2022-07-13",57666.666666666664]
[null,3,"Check 9",null,"2022-10-13",57666.666666666664]
[null,null,"Check 10",null,"2023-01-13",57666.666666666664]
[null,null,"Check 11",null,"2023-04-13",57666.666666666664]
[null,null,"Check 12",null,"2023-07-13",57666.666666666664]
[null,4,"Check 13",null,"2023-10-13",57666.666666666664]
[null,null,"Check 14",null,"2024-01-13",57666.666666666664]
[null,null,"Check 15",null,"2024-04-13",57666.666666666664]
[null,null,"Check 16",null,"2024-07-13",57666.666666666664]
[null,5,"Check 17",null,{"$f":"EDATE(E31,3)","v":"2024-10-13"},57666.666666666664]
[null,null,"Check 18",null,"2025-01-13",57666.666666666664]
[null,null,"Check 19",null,"2025-04-13",57666.666666666664]
[null,null,"Check 20",null,"2025-07-13",57666.666666666664]
[null,6,"Check 21",null,"2025-10-13",57666.666666666664]
[null,null,"Check 22",null,"2026-01-13",57666.666666666664]
[null,null,"Check 23",null,"2026-04-13",57666.666666666664]
[null,null,"Check 24",null,"2026-07-13",57666.666666666664]
[null,7,"Check 25",null,"2026-10-13",57666.666666666664]
[null,null,"Check 26",null,"2027-01-13",57666.666666666664]
[null,null,"Check 27",null,"2027-04-13",57666.666666666664]
[null,null,"Check 28",null,"2027-07-13",57666.666666666664]
[null,8,"Check 29",null,"2027-10-13",57666.666666666664]
[null,null,"Check 30",null,"2028-01-13",57666.666666666664]
[null,null,"Check 31",null,"2028-04-13",57666.666666666664]
[null,null,"Check 32",null,"2028-07-13",57666.666666666664,{"$f":"SUM(F16:F47)","v":1845333.3333333342}]

{"sheet":"Price List","index":4,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Unit Number","Price","Unit Area"]
["A",1000000,"100M"]
["B",2000000,"150M"]
["C",3000000,"200M"]
["D",4000000,"190M"]
["E",5000000,"170M"]
["F",6000000,"290M"]
["G",7000000,"300M"]

{"sheet":"المطلوب فى الشيت","index":5,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[[2,3,28,25]]}
[]
[]
[null,null,null,"فى الشيت المرفق قائمة اسعار  ( قيمة الوحده - السعر- المساحة ) ويوجد عدد 4 طرق لتقسيط قيمة الوحدة ونسبة مقدم السداد لكل طريقة      \nتم عميل عدد 2 يوزر فورم الاولى  شاشة بداية / والثانية شاشة الادخالات        \nالمطلوب *\n1- تفعيل شاشة اليوزر فورم الاولى والثانية \n2- فى رقم الوحدة و قيمة والوحده والمساحة   يتم ادراجها تلقائيا  فى الليست بوكس  بطريقة تلقائية بمجرد كتابة  رقم الوحده \n3- يتم احتساب القيمة تلقائيا فى مربع الاقساط تلقائيا كل قسط وتاريخ القسط و المبلغ بناء على الخيار   ( طريقة السداد وطريقة الاقساط ) كما هو فى  شيت الاكسل المرفق للاربع طرق\n4- يتم احتساب الصيانة تلقائيا بنسبة % وليكن 8% \nولكم جزيل الشكر والاحترام والعرفان "]