{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["商铺基本数据","一期4#、5#","1#2#底商价格","20#底商价格","21#底商价格","22#底商价格","三期商铺"],"not_rendered":{"images":6,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"商铺基本数据","index":0,"n_rows":76,"n_cols":19,"rows_kept":76,"hidden":true,"merged":[[0,1,0,9],[2,0,8,0],[8,13,13,13],[9,0,21,0],[18,13,23,13],[22,0,39,0],[27,13,32,13],[40,0,63,0],[64,0,75,0]]}
[null,"澜庭悦府三期底商"]
["楼栋号","房号（施工）","建筑面积（㎡）","套内面积（㎡）","公摊面积（㎡）","开间（m）","进深（m）","开间进深比","所在位置","备注"]
["1#","1-5",47.82,46.46,{"$f":"C3-D3","v":1.36},3.52,13.2,{"$f":"F3/G3","v":{"v":0.266666666666667,"d":"0.27"}},"西",{"$nulls":4},"位置加分项"]
[null,"1-6",124.55,121,{"$f":"C4-D4","v":3.55},6.9,18.4,{"$f":"F4/G4*100%","v":{"v":0.375,"d":"0.38"}},"西","拐角较多，不方正",{"$nulls":3},"小区侧门旁",200,100,50]
[null,"1-7",56.58,54.97,1.61,4.1,15.6,{"v":0.262820512820513,"d":"0.26"},"西","拐角多，不方正，且呈细长形",{"$nulls":3},"阳湖路与湖西路交叉口",500,400,300,200,100]
[null,"1-8",43.05,41.82,1.23,5.1,8.2,{"v":0.621951219512195,"d":"0.62"},"西",{"$nulls":4},"小区北入口两侧",500,300,100,0]
[null,"1-9",65.9,64.02,1.88000000000001,4.85,13.2,{"v":0.367424242424242,"d":"0.37"},"西",{"$nulls":4},"小区会所出入口",500,400,300,200]
[null,"1-10",63.86,62.04,1.82,4.7,13.2,{"v":0.356060606060606,"d":"0.36"},"西"]
[null,"1-11",63.86,62.04,1.82,4.7,13.2,{"v":0.356060606060606,"d":"0.36"},"西","小区侧门",{"$nulls":3},"面积调差","20以下",300]
["2#","1-5",140.46,136.83,3.63,6.6,16.5,{"v":0.4,"d":"0.40"},"西","异形，边角拐角较多，整体为两个方正图形相叠加",{"$nulls":4},"20-40",400]
[null,"1-6",54.97,53.55,1.42,6.3,8.5,{"v":0.741176470588235,"d":"0.74"},"西","小区会所出入口",{"$nulls":4},"40-70",300]
[null,"1-7",68.81,67.03,1.78,8.8,8.5,{"v":1.03529411764706,"d":"1.04"},"西","小区会所旁拐角处，展示面大位置好",{"$nulls":4},"70-100",0]
[null,"1-8",103.88,101.2,2.67999999999999,5.4,18.4,{"v":0.293478260869565,"d":"0.29"},"西","拐角多，不方正，且呈细长形",{"$nulls":4},"100-150",-300]
[null,"1-9",56.43,54.97,1.46,4.1,15.6,{"v":0.262820512820513,"d":"0.26"},"西",{"$nulls":5},"150以上",-400]
[null,"1-10",42.93,41.82,1.11,5.1,8.2,{"v":0.621951219512195,"d":"0.62"},"西"]
[null,"1-11",63.77,62.44,1.33000000000001,4.73,13.2,{"v":0.358333333333333,"d":"0.36"},"西"]
[null,"1-12",63.37,62.04,1.33,4.7,13.2,{"v":0.356060606060606,"d":"0.36"},"西"]
[null,"1-13",63.37,62.04,1.33,4.7,13.2,{"v":0.356060606060606,"d":"0.36"},"西"]
[null,"1-14",63.37,62.04,1.33,4.7,13.2,{"v":0.356060606060606,"d":"0.36"},"西",{"$nulls":4},"进深比调差","≥2",500]
[null,"1-15",63.37,62.04,1.33,4.7,13.2,{"v":0.356060606060606,"d":"0.36"},"西",{"$nulls":5},"2＜b≤1.5",400]
[null,"1-16",63.37,62.04,1.33,4.7,13.2,{"v":0.356060606060606,"d":"0.36"},"西",{"$nulls":5},"1.5＜b≤1",300]
[null,"1-17",59.32,58.08,1.24,4.7,13.2,{"v":0.356060606060606,"d":"0.36"},"西",{"$nulls":5},"1＜b≤0.5",100]
["20#（阳湖路161-195号商业）","1-1",168.67,164.79,3.88,6.7,16.6,{"v":0.403614457831325,"d":"0.40"},"北","内部空间大，内部开间13.6",{"$nulls":4},"0.5＜b≤0.25",0]
[null,"1-2",7.68,7.5,0.18,3.75,2,{"v":1.875,"d":"1.88"},"北","进风井旁",{"$nulls":4},"＜0.25",-300]
[null,"1-3",52.44,51.23,1.21,10.9,4.7,{"v":2.31914893617021,"d":"2.32"},"北"]
[null,"1-4",21.65,21.15,0.5,4.5,4.7,{"v":0.957446808510638,"d":"0.96"},"北"]
[null,"1-5",109.2,106.69,2.51,3.2,16.6,{"v":0.192771084337349,"d":"0.19"},"北","内部空间大，内部开间10.1"]
[null,"1-6",33.68,32.9,0.780000000000001,3.5,9.4,{"v":0.372340425531915,"d":"0.37"},"北",{"$nulls":4},"面积数","20以下",3]
[null,"1-7",73.37,71.68,1.69,2.8,16.6,{"v":0.168674698795181,"d":"0.17"},"北","内部空间大，内部开间6.3",{"$nulls":4},"20-40",10]
[null,"1-8",70.93,69.3,1.63000000000001,2.8,15.9,{"v":0.176100628930818,"d":"0.18"},"北","内部小空间风井",{"$nulls":4},"40-70",31]
[null,"1-9",33.68,32.9,0.780000000000001,3.5,9.4,{"v":0.372340425531915,"d":"0.37"},"北",{"$nulls":5},"70-100",19]
[null,"1-10",109.2,106.69,2.51,3.2,16.6,{"v":0.192771084337349,"d":"0.19"},"北","内部空间大，内部开间10.1",{"$nulls":4},"100-150",9]
[null,"1-11",21.65,21.15,0.5,4.5,4.7,{"v":0.957446808510638,"d":"0.96"},"北","靠近转角",{"$nulls":4},"150以上",2]
[null,"1-12",52.44,51.23,1.21,10.9,4.7,{"v":2.31914893617021,"d":"2.32"},"北","靠近转角"]
[null,"1-13",7.68,7.5,0.18,3.75,2,{"v":1.875,"d":"1.88"},"北","靠近转角"]
[null,"1-14",276.76,270.39,6.37,14.5,18.81,{"v":0.770866560340245,"d":"0.77"},"西北","湖东路与阳湖路转角商铺位置佳"]
[null,"1-15",60.4,59.01,1.39,4.2,14.05,{"v":0.298932384341637,"d":"0.30"},"西","靠近转角"]
[null,"1-16",60.8,59.01,1.79,4.2,14.05,{"v":0.298932384341637,"d":"0.30"},"西","靠近转角"]
[null,"1-17",60.8,59.01,1.79,4.2,14.05,{"v":0.298932384341637,"d":"0.30"},"西","靠近转角"]
[null,"1-18",60.8,59.01,1.79,4.2,14.05,{"v":0.298932384341637,"d":"0.30"},"西"]
["21#","1-1",107.3,105.11,2.19,6.8,16.6,{"v":0.409638554216867,"d":"0.41"},"北","小区北入口旁，位置佳"]
[null,"1-2",70.32,68.89,1.42999999999999,4.15,16.6,0.25,"北"]
[null,"1-3",30.79,30.16,0.629999999999999,4.3,9.4,{"v":0.457446808510638,"d":"0.46"},"北"]
[null,"1-4",85.68,83.93,1.75,5.75,16.6,{"v":0.346385542168675,"d":"0.35"},"北"]
[null,"1-5",64.39,63.08,1.31,3.8,16.6,{"v":0.228915662650602,"d":"0.23"},"北"]
[null,"1-6",64.39,63.08,1.31,3.8,16.6,{"v":0.228915662650602,"d":"0.23"},"北"]
[null,"1-7",70.32,68.89,1.42999999999999,4.15,16.6,0.25,"北"]
[null,"1-8",30.79,30.16,0.629999999999999,4.3,9.4,{"v":0.457446808510638,"d":"0.46"},"北"]
[null,"1-9",85.68,83.93,1.75,5.75,16.6,{"v":0.346385542168675,"d":"0.35"},"北"]
[null,"1-10",64.39,63.08,1.31,3.8,16.6,{"v":0.228915662650602,"d":"0.23"},"北"]
[null,"1-11",64.39,63.08,1.31,3.8,16.6,{"v":0.228915662650602,"d":"0.23"},"北"]
[null,"1-12",70.32,68.89,1.42999999999999,4.15,16.6,0.25,"北"]
[null,"1-13",30.79,30.16,0.629999999999999,4.3,9.4,{"v":0.457446808510638,"d":"0.46"},"北"]
[null,"1-14",85.68,83.93,1.75,5.75,16.6,{"v":0.346385542168675,"d":"0.35"},"北"]
[null,"1-15",64.39,63.08,1.31,3.8,16.6,{"v":0.228915662650602,"d":"0.23"},"北"]
[null,"1-16",67.53,66.4,1.13,4,16.6,{"v":0.240963855421687,"d":"0.24"},"北"]
[null,"1-17",72.59,71.38,1.21000000000001,4.3,16.6,{"v":0.259036144578313,"d":"0.26"},"北"]
[null,"1-18",72.59,71.38,1.21000000000001,4.3,16.6,{"v":0.259036144578313,"d":"0.26"},"北"]
[null,"1-19",72.59,71.38,1.21000000000001,4.3,16.6,{"v":0.259036144578313,"d":"0.26"},"北"]
[null,"1-20",72.59,71.38,1.21000000000001,4.3,16.6,{"v":0.259036144578313,"d":"0.26"},"北"]
[null,"1-21",72.59,71.38,1.21000000000001,4.3,16.6,{"v":0.259036144578313,"d":"0.26"},"北"]
[null,"1-22",72.59,71.38,1.21000000000001,4.3,16.6,{"v":0.259036144578313,"d":"0.26"},"北"]
[null,"1-23",72.59,71.38,1.21000000000001,4.3,16.6,{"v":0.259036144578313,"d":"0.26"},"北"]
[null,"1-24",118.17,116.2,1.97,7,16.6,{"v":0.421686746987952,"d":"0.42"},"北"]
["22#","1-1",94.41,92.05,2.36,5,14.7,{"v":0.340136054421769,"d":"0.34"},"北","内部开间8.5"]
[null,"1-2",135.76,132.37,3.38999999999999,6.75,14.7,{"v":0.459183673469388,"d":"0.46"},"北"]
[null,"1-3",23.63,23.03,0.599999999999998,4.9,4.7,{"v":1.04255319148936,"d":"1.04"},"北"]
[null,"1-4",25.55,24.91,{"$f":"C68-D68","v":0.640000000000001},5.3,4.7,{"$f":"F68/G68*100%","v":{"v":1.12765957446809,"d":"1.13"}},"北"]
[null,"1-5",20.57,20.06,0.510000000000002,5.2,4.7,{"v":1.1063829787234,"d":"1.11"},"北"]
[null,"1-6",7.69,7.5,0.19,3.75,2,{"v":1.875,"d":"1.88"},"北","东旁边风井，南靠楼梯"]
[null,"1-7",135.76,132.37,3.38999999999999,6.7,14.7,{"v":0.45578231292517,"d":"0.46"},"北"]
[null,"1-8",61.24,59.71,1.53,2.8,14.7,{"v":0.19047619047619,"d":"0.19"},"北","内部开间6.3"]
[null,"1-9",54.48,52.92,1.56,3.6,14.7,{"v":0.244897959183673,"d":"0.24"},"北"]
[null,"1-10",83.29,80.9,2.39,6.2,14.7,{"v":0.421768707482993,"d":"0.42"},"北","有两侧风井，拐角较多不方正"]
[null,"1-11",74.13,72,2.13,6.2,14.7,{"v":0.421768707482993,"d":"0.42"},"北"]
[null,"1-12",83.09,80.71,2.38000000000001,6,14.7,{"v":0.408163265306122,"d":"0.41"},"北","多边形，小区北入口旁展示面好"]

{"sheet":"一期4#、5#","index":1,"n_rows":21,"n_cols":15,"rows_kept":21,"hidden":true,"merged":[[0,0,0,13]]}
["澜庭悦府一期商铺价格表"]
[null,"A座商-1","A座商-2","A座商-3","A座商-4","A座商-5","A座商-6"]
["房号","5-1-1","5-1-2","5-1-3","5-1-4","5-1-5","5-1-6"]
["一层面积",101.05,98.68,90.23,85.47,78.23,100.96]
["二层面积",101.05,98.68,90.23,85.47,78.23,106.56]
["总面积",202.1,197.36,180.46,170.94,156.46,207.52]
["单价",9300,9869,9702,9055,9055,9624]
["总价",1879570,1947667,1750823,1547896,1416776,1997089]
[]
[]
[]
[null,"B座商-1","B座商-2","B座商-3","B座商-4","B座商-5","B座商-6","B座商-7","B座商-8","B座商-9","B座商-10","B座商-11","B座商-12","B座商-13"]
["房号","4-1-1","4-1-2","4-1-3","4-1-4","4-1-5","4-1-6","4-1-7","4-1-8","4-1-9","4-1-10","4-1-11","4-1-12","4-1-13"]
["一层面积",45.08,45.08,45.08,45.08,45.08,45.08,45.08,91.02,79.37,103.56,51.92,54.58,36.98]
["二层面积",45.08,45.08,45.08,45.08,45.08,45.08,45.08,91.02,79.37,103.56,51.92,49.67,36.98]
["总面积",90.16,90.16,90.16,90.16,90.16,90.16,90.16,182.04,158.74,207.12,103.84,104.25,73.96]
["单价",9702,9702,9702,9702,9869,9869,10035,9545,9545,11015,9702,10682,10525]
["总价",874732,874732,874732,874732,889753,889753,904773,1737609,1515205,2281468,1007456,1113705,778443]
[{"$nulls":14},"  "]
[]
[{"$nulls":10},"  "]

{"sheet":"1#2#底商价格","index":2,"n_rows":25,"n_cols":6,"rows_kept":25,"hidden":true,"merged":[[0,0,0,8],[2,0,8,0],[9,0,21,0]]}
["1#、2#底商价格"]
["楼栋号","房号","门牌号","建筑面积（㎡）","单价","总价"]
["1#","1-5","湖东南路3376号",47.82,12269,586704]
[null,"1-6","湖东南路3378号",124.55,11169,1391099]
[null,"1-7","湖东南路3380号",56.58,11569,654574]
[null,"1-8","湖东南路3382号",43.05,11169,480825]
[null,"1-9","湖东南路3384号",65.9,12219,805232]
[null,"1-10","湖东南路3386号",63.86,12269,783498]
[null,"1-11","湖东南路3388号",63.86,12369,789884]
["2#","1-5","湖东南路3350号",140.46,11519,1617959]
[null,"1-6","湖东南路3352号",54.97,12869,707409]
[null,"1-7","湖东南路3354号",68.81,13369,919921]
[null,"1-8","湖东南路3356号",103.88,11169,1160236]
[null,"1-9","湖东南路3358号",56.43,11649,657353]
[null,"1-10","湖东南路3360号",42.93,11169,479485]
[null,"1-11","湖东南路3362号",63.77,12369,788771]
[null,"1-12","湖东南路3364号",63.37,12369,783824]
[null,"1-13","湖东南路3366号",63.37,12369,783824]
[null,"1-14","湖东南路3368号",63.37,12369,783824]
[null,"1-15","湖东南路3370号",63.37,12369,783824]
[null,"1-16","湖东南路3372号",63.37,12369,783824]
[null,"1-17","湖东南路3374号",59.32,12369,733729]
[]
[]
[null,{"$f":"MIN(F3:F22)","v":479485}]

{"sheet":"20#底商价格","index":3,"n_rows":20,"n_cols":6,"rows_kept":20,"hidden":true,"merged":[[0,0,0,8],[2,0,19,0]]}
["20#底商价格"]
["楼栋号","房号","门牌号","面积（㎡）","单价","总价"]
["20#","1-1","阳湖路161号",168.67,12421,2095050]
[null,"1-2","阳湖路163号",7.68,21161,162516]
[null,"1-3","阳湖路165号",52.44,14501,760432]
[null,"1-4","阳湖路167号",21.65,16361,354216]
[null,"1-5","阳湖路169号",109.2,11861,1295221]
[null,"1-6","阳湖路171号",33.68,12761,429790]
[null,"1-7","阳湖路173号",73.37,12161,892253]
[null,"1-8","阳湖路175号",70.93,12161,862580]
[null,"1-9","阳湖路177号",33.68,12761,429790]
[null,"1-10","阳湖路179号",109.2,11871,1296313]
[null,"1-11","阳湖路181号",21.65,17161,371536]
[null,"1-12","阳湖路183号",52.44,14661,768823]
[null,"1-13","阳湖路185号",7.68,21561,165588]
[null,"1-14","阳湖路187号",276.76,13061,3614762]
[null,"1-15","阳湖路189号",60.4,13311,803984]
[null,"1-16","阳湖路191号",60.8,13111,797149]
[null,"1-17","阳湖路193号",60.8,12961,788029]
[null,"1-18","阳湖路195号",60.8,12761,775869]

{"sheet":"21#底商价格","index":4,"n_rows":26,"n_cols":6,"rows_kept":26,"hidden":true,"merged":[[0,0,0,8],[2,0,25,0]]}
["21#底商价格"]
["楼栋号","房号","门牌号","面积（㎡）","单价","总价"]
["21#","1-1","阳湖路113号",107.3,13210,1417433]
[null,"1-2","阳湖路115号",70.32,13300,935256]
[null,"1-3","阳湖路117号",30.79,13810,425210]
[null,"1-4","阳湖路119号",85.68,12970,1111270]
[null,"1-5","阳湖路121号",64.39,12810,824836]
[null,"1-6","阳湖路123号",64.39,12800,824192]
[null,"1-7","阳湖路125号",70.32,12910,907831]
[null,"1-8","阳湖路127号",30.79,13710,422131]
[null,"1-9","阳湖路129号",85.68,12940,1108699]
[null,"1-10","阳湖路131号",64.39,12790,823548]
[null,"1-11","阳湖路133号",64.39,12780,822904]
[null,"1-12","阳湖路135号",70.32,12940,909941]
[null,"1-13","阳湖路137号",30.79,12910,397499]
[null,"1-14","阳湖路139号",85.68,12920,1106986]
[null,"1-15","阳湖路141号",64.39,12510,805519]
[null,"1-16","阳湖路143号",67.53,12310,831294]
[null,"1-17","阳湖路145号",72.59,12140,881243]
[null,"1-18","阳湖路147号",72.59,12130,880517]
[null,"1-19","阳湖路149号",72.59,12120,879791]
[null,"1-20","阳湖路151号",72.59,12110,879065]
[null,"1-21","阳湖路153号",72.59,12100,878339]
[null,"1-22","阳湖路155号",72.59,12090,877613]
[null,"1-23","阳湖路157号",72.59,12070,876161]
[null,"1-24","阳湖路159号",118.17,11710,1383771]

{"sheet":"22#底商价格","index":5,"n_rows":14,"n_cols":6,"rows_kept":14,"hidden":true,"merged":[[0,0,0,8],[2,0,13,0]]}
["22#底商价格"]
["楼栋号","房号","门牌号","面积（㎡）","单价","总价"]
["22#","1-1","阳湖路89号",94.41,11896,1123101]
[null,"1-2","阳湖路91号",135.76,11596,1574273]
[null,"1-3","阳湖路93号",23.63,13296,314184]
[null,"1-4","阳湖路95号",25.55,13196,337158]
[null,"1-5","阳湖路97号",20.57,13096,269385]
[null,"1-6","阳湖路99号",7.69,18096,139158]
[null,"1-7","阳湖路101号",135.76,11896,1615001]
[null,"1-8","阳湖路103号",61.24,12596,771379]
[null,"1-9","阳湖路105号",54.48,12796,697126]
[null,"1-10","阳湖路107号",83.29,12096,1007476]
[null,"1-11","阳湖路109号",74.13,13496,1000458]
[null,"1-12","阳湖路111号",83.09,13796,1146310]

{"sheet":"三期商铺","index":6,"n_rows":7,"n_cols":6,"rows_kept":7,"merged":[[0,0,0,5],[6,0,6,3]]}
["三期商铺"]
["序号","楼栋号","房号","门牌号","建筑面积（㎡）","备注"]
[1,"1#","1-7","湖东南路3380号",56.58]
[2,"2#","1-14","湖东南路3368号",63.37]
[3,"20#","1-7","阳湖路173号",73.37]
[4,"21#","1-18","阳湖路147号",72.59]
["合计",{"$nulls":3},{"$f":"SUM(E3:E6)","v":265.91}]