{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["1","Cinter_Cod","ورقة2","2"],"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":"1","index":0,"n_rows":17,"n_cols":20,"rows_kept":17,"cut":false,"hidden":false,"merged":[[16,5,16,11],[11,12,11,18]]}
["Number","Point Name","Latitude","Longtiude","Elevation","Easting","Northing","Elevation Top","Elevation Bead",null,null,"Number","Point Name","Latitude","Longtiude","Elevation","Easting","Northing","Elevation Top","Elevation Bead"]
[1,{"$f":"VLOOKUP($A$2,T[#All],2)","v":"0+000"},{"$f":"VLOOKUP($A$2,T[#All],3)","v":30.041395489999999},{"$f":"VLOOKUP($A$2,T[#All],4)","v":30.708723389999999},{"$f":"VLOOKUP($A$2,T[#All],5)","v":0},{"$f":"VLOOKUP($A$2,T[#All],6)","v":216638.1373},{"$f":"VLOOKUP($A$2,T[#All],7)","v":3401060.0839999998},{"$f":"VLOOKUP($A$2,T[#All],8)","v":41.32},{"$f":"VLOOKUP($A$2,T[#All],9)","v":38.520000000000003},null,null,{"$f":"ROW(L1)","v":1},"0+000",30.041395489999999,30.708723389999999,0,216638.1373,3401060.0839999998,41.32,38.520000000000003]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROW(L2)","v":2},"0+020",30.041340160000001,30.708870910000002,0,216633.2671,3401076.5830000001,41.31,38.51]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROW(L3)","v":3},"0+040",30.041186880000001,30.708993379999999,0,216618.93969999999,3401090.551,41.31,38.51]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROW(L4)","v":4},"0+060",30.041034109999998,30.709116300000002,0,216604.6611,3401104.5690000001,41.3,38.5]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null," و يقوم بتغيير  قيمة الخلية A2 الى الرقم الذي يليه الى ان يصل الى نهاية الجدول "]
[]
[]
[]
[]
[null,null,null,null,null,"المطلوب طريقة لتشغيل الماكرو GO بالضغط على زر go فيقوم بإضافة البيانات من سطر 2 الى صفحة 2"]

{"sheet":"Cinter_Cod","index":1,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["        <Placemark>"]
["            <name>",null,"</name>"]
["            <styleUrl>#pointStyleMap</styleUrl>"]
["            <Style id=\"inline\">"]
["                <IconStyle>"]
["                    <color>ff00ffff</color>"]
["                    <colorMode>normal</colorMode>"]
["                    <Icon>"]
["                        <href>http://maps.google.com/mapfiles/kml/pushpin/ylw-pushpin.png</href>"]
["                    </Icon>"]
["                </IconStyle>"]
["                <LineStyle>"]
["                    <color>ff00ffff</color>"]
["                    <colorMode>normal</colorMode>"]
["                </LineStyle>"]
["                <PolyStyle>"]
["                    <color>ff00ffff</color>"]
["                    <colorMode>normal</colorMode>"]
["                </PolyStyle>"]
["            </Style>"]
["            <ExtendedData>"]
["                <SchemaData schemaUrl=\"#S_Trans_SDDDD\">"]
["                    <SimpleData name=\"",null,"\">",null,"</SimpleData>"]
["                    <SimpleData name=\"",null,"\">",null,"</SimpleData>"]
["                    <SimpleData name=\"",null,"\">",null,"</SimpleData>"]
["                    <SimpleData name=\"",null,"\">",null,"</SimpleData>"]
["                    <SimpleData name=\"",null,"\">",null,"</SimpleData>"]
["                </SchemaData>"]
["            </ExtendedData>"]
["            <Point>"]
["                <coordinates>",null,null,",",null,",",null,"</coordinates>"]
["            </Point>"]
["        </Placemark>"]

{"sheet":"ورقة2","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"2","index":3,"n_rows":34,"n_cols":18,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["عمود1","عمود2","عمود3","عمود4","عمود5","عمود6","عمود7","عمود8",null,"Number","Point Name","Latitude","Longtiude","Elevation","Easting","Northing","Elevation Top","Elevation Bead"]
["        <Placemark>",null,null,null,null,null,null,null,null,{"$f":"'1'!A2","v":1},{"$f":"VLOOKUP($J$2,T[#All],2)","v":"0+000"},{"$f":"VLOOKUP($J$2,T[#All],3)","v":30.041395489999999},{"$f":"VLOOKUP($J$2,T[#All],4)","v":30.708723389999999},{"$f":"VLOOKUP($J$2,T[#All],5)","v":0},{"$f":"VLOOKUP($J$2,T[#All],6)","v":216638.1373},{"$f":"VLOOKUP($J$2,T[#All],7)","v":3401060.0839999998},{"$f":"VLOOKUP($J$2,T[#All],8)","v":41.32},{"$f":"VLOOKUP(J2,T[#All],9)","v":38.520000000000003}]
["            <name>","0+040","</name>"]
["            <styleUrl>#pointStyleMap</styleUrl>"]
["            <Style id=\"inline\">"]
["                <IconStyle>"]
["                    <color>ff00ffff</color>"]
["                    <colorMode>normal</colorMode>"]
["                    <Icon>"]
["                        <href>http://maps.google.com/mapfiles/kml/pushpin/ylw-pushpin.png</href>"]
["                    </Icon>"]
["                </IconStyle>"]
["                <LineStyle>"]
["                    <color>ff00ffff</color>"]
["                    <colorMode>normal</colorMode>"]
["                </LineStyle>"]
["                <PolyStyle>"]
["                    <color>ff00ffff</color>"]
["                    <colorMode>normal</colorMode>"]
["                </PolyStyle>"]
["            </Style>"]
["            <ExtendedData>"]
["                <SchemaData schemaUrl=\"#S_Trans_SDDDD\">"]
["                    <SimpleData name=\"",null,"\">","0+040","</SimpleData>"]
["                    <SimpleData name=\"","Easting","\">",216618.93969999999,"</SimpleData>"]
["                    <SimpleData name=\"","Northing","\">",3401090.551,"</SimpleData>"]
["                    <SimpleData name=\"","Elevation Top","\">",41.31,"</SimpleData>"]
["                    <SimpleData name=\"","Elevation Bead","\">",38.51,"</SimpleData>"]
["                </SchemaData>"]
["            </ExtendedData>"]
["            <Point>"]
["                <coordinates>",null,30.041186880000001,",",30.708993379999999,",",0,"</coordinates>"]
["            </Point>"]
["        </Placemark>"]