方案容积率强排测算模板.xls

1、最佳容积率测算模板（此计算模板仅能计算4变量。受参数影响，结果不一定准确，但指明了方向，优化方案还需经过建筑总平面规划才能确定）下一行表格中的数据全部为待求部分的数值，如果有固定比例的部分，应根据情况先计算出下表。业态最高容积率2业态占地面积181731.16业态建筑面积业态数量4序号项目名称取值业态1业态2业态3业态41用地比例(基本方案）12%70%13%0%2参考容积率1.502.002.800.00基本方案综合容积率1.94基本方案建筑面积353285.383售价13000.0012000.0011000.0010000.004建造费用1800.002160.002520.002760

2、.004.1 建安费1500.001800.002100.002300.004.2 红线内市政费150.00180.00210.00230.004.3 小区配套费150.00180.00210.00230.005不可预见费75.0090.00105.00115.006专业人士费90.00108.00126.00138.007管理费用58.9570.7482.5390.398财务费用（建设期2年）286.78344.13401.49439.739销售费用1105.001020.00935.00850.0010土地取得价格5000.005000.005000.005000.0011土地增值（扣土地

3、费用）9376.4111414.2514123.95-5000.0012土地增值（不扣土地费用）14376.4116414.2519123.950.00计算增幅（：1%，：5%，:10%）1注注意意：如如果果是是四四种种业业态态，选选择择增增幅幅为为1 1的的情情况况，会会超超出出了了EXCELEXCEL最最大大行行的的限限制制。系系统统自自动动以以增增幅幅为为2 2计计算算。序号比例综合容积率业态1业态2业态3业态4最优方案009642.688可能方案1009641.828009821.8140010001.8029261.83029441.816029621.802029801.78804

4、9061.818049241.804049421.79049601.776068681.82068861.806069041.792069221.778069401.7640882101.822088481.808088661.794088841.78089021.766089201.75201078121.82401080101.81计算最优方案0108281.7960108461.7820108641.7680108821.7540109001.7401274141.82601276121.81201278101.7980128081.7840128261.770128441.756012

5、8621.7420128801.72801470161.82801472141.81401474121.801476101.7860147881.7720148061.7580148241.7440148421.730148601.71601666181.8301668161.81601670141.80201672121.78801674101.7740167681.760167861.7460168041.7320168221.7180168401.70401864181.81801866161.80401868141.7901870121.77601872101.7620187481.7

6、480187661.7340187841.720188021.7060188201.69202060201.8202062181.80602064161.79202066141.77802068121.76402070101.750207281.7360207461.7220207641.7080207821.6940208001.6802256221.82202258201.80802260181.79402262161.7802264141.76602266121.75202268101.7380227081.7240227261.710227441.6960227621.68202278

7、01.66802452241.82402454221.8102456201.79602458181.78202460161.76802462141.75402464121.7402466101.7260246881.7120247061.6980247241.6840247421.670247601.65602648261.82602650241.81202652221.79802654201.78402656181.7702658161.75602660141.74202662121.72802664101.7140266681.70266861.6860267041.6720267221.

8、65802844281.82802846261.81402848241.802850221.78602852201.77202854181.75802856161.74402858141.7302860121.71602862101.7020286481.6880286661.6740286841.6603040301.8303042281.81603044261.80203046241.78803048221.77403050201.7603052181.74603054161.73203056141.71803058121.70403060101.690306281.67603238301

9、.81803240281.80403242261.7903244241.77603246221.76203248201.74803250181.73403252161.7203254141.70603256121.69203258101.67803434321.8203436301.80603438281.79203440261.77803442241.76403444221.7503446201.73603448181.72203450161.70803452141.69403454121.6803630341.82203632321.80803634301.79403636281.7803

10、638261.76603640241.75203642221.73803644201.72403646181.7103648161.69603826361.82403828341.8103830321.79603832301.78203834281.76803836261.75403838241.7403840221.72603842201.71203844181.69804022381.82604024361.81204026341.79804028321.78404030301.7704032281.75604034261.74204036241.72804038221.714042184

11、01.82804220381.81404222361.804224341.78604226321.77204228301.75804230281.74404232261.7304234241.71604414421.8304416401.81604418381.80204420361.78804422341.77404424321.7604426301.74604428281.73204612421.81804614401.80404616381.7904618361.77604620341.76204622321.74804624301.7340488441.8204810421.80604

12、812401.79204814381.77804816361.76404818341.7504820321.7360504461.8220506441.8080508421.79405010401.7805012381.76605014361.7520520481.8240522461.810524441.7960526421.7820528401.76805210381.7540540461.7980542441.7840544421.770560441.772209261.818209441.804209621.79209801.776228881.82229061.806229241.7

13、92229421.778229601.7642484101.822248681.808248861.794249041.78249221.766249401.7522680121.8242682101.81268481.796268661.782268841.768269021.754269201.742876141.8262878121.8122880101.798288281.784288461.77288641.756288821.742289001.72821072161.82821074141.81421076121.821078101.7862108081.7722108261.7

14、582108441.7442108621.732108801.71621268181.8321270161.81621272141.80221274121.78821276101.7742127881.762128061.7462128241.7322128421.7182128601.70421466181.81821468161.80421470141.7921472121.77621474101.7622147681.7482147861.7342148041.722148221.7062148401.69221662201.8221664181.80621666161.79221668

15、141.77821670121.76421672101.752167481.7362167661.7222167841.7082168021.6942168201.6821858221.82221860201.80821862181.79421864161.7821866141.76621868121.75221870101.7382187281.7242187461.712187641.6962187821.6822188001.66822054241.82422056221.8122058201.79622060181.78222062161.76822064141.75422066121

16、.7422068101.7262207081.7122207261.6982207441.6842207621.672207801.65622250261.82622252241.81222254221.79822256201.78422258181.7722260161.75622262141.74222264121.72822266101.7142226881.72227061.6862227241.67222446281.82822448261.81422450241.822452221.78622454201.77222456181.75822458161.74422460141.7322462121.71622464101.7022246681.6882246861.67422642301.8322644281.81622646261.80222648241.78822650221.77422652201.7622654181.74622656161.73222658141.71822660121.70422662101.6922840301.81822842281.8042