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

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

《方案容积率强排测算模板.xls》由会员分享，可在线阅读，更多相关《方案容积率强排测算模板.xls（56页珍藏版）》请在冰点文库上搜索。

最佳容积率测算模板（此计算模板仅能计算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.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土地增值（扣土地费用）9376.4111414.2514123.95-5000.0012土地增值（不扣土地费用）14376.4116414.2519123.950.00计算增幅（：

1%，：

5%，:

10%）1注注意意：

如如果果是是四四种种业业态态，选选择择增增幅幅为为11的的情情况况，会会超超出出了了EXCELEXCEL最最大大行行的的限限制制。

系系统统自自动动以以增增幅幅为为22计计算算。

序号比例综合容积率业态1业态2业态3业态4最优方案009642.688可能方案1009641.828009821.8140010001.8029261.83029441.816029621.802029801.788049061.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.7560128621.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.7480187661.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.6820227801.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.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.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.7803638261.76603640241.75203642221.73803644201.72403646181.7103648161.69603826361.82403828341.8103830321.79603832301.78203834281.76803836261.75403838241.7403840221.72603842201.71203844181.69804022381.82604024361.81204026341.79804028321.78404030301.7704032281.75604034261.74204036241.72804038221.71404218401.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.80604812401.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.792229421.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.7582108441.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.79221668141.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.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.80422844261.7922846241.77622848221.76222850201.74822852181.73422854161.7222856141.70622858121.69223036321.8223038301.80623040281.79223042261.77823044241.76423046221.7523048201.73623050181.72223052161.70823054141.69423232341.82223234321.80823236301.79423238281.7823240261.76623242241.75223244221.73823246201.72423248181.7123428361.82423430341.8123432321.79623434301.78223436281.76823438261.75423440241.7423442221.72623444201.71223624381.82623626361.81223628341.79823630321.78423632301.7723634281.75623636261.74223638241.72823820401.82823822381.81423824361.823826341.78623828321.77223830301.75823832281.74423834261.7324016421.8324018401.81624020381.80224022361.78824024341.77424026321.7624028301.74624214421.81824216401.80424218381.7924220361.77624222341.76224224321.74824410441.8224412421.80624414401.79224416381.77824418361.76424420341.752466461.8222468441.80824610421.79424612401.7824614381.7662482481.8242484461.812486441.7962488421.78224810401.7682500481.8122502461.7982504441.7842520461.7864086101.822408881.808409061.794409241.78409421.766409601.7524282121.8244284101.81428681.796428861.782429041.768429221.754429401.744478141.8264480121.8124482101.798448481.784448661.77448841.756449021.742449201.7284674161.8284676141.8144678121.84680101.786468281.772468461.758468641.744468821.73469001.7164870181.834872161.8164874141.8024876121.7884878101.774488081.76488261.746488441.732488621.718488801.70441068181.81841070161.80441072141.7941074121.77641076101.7624107881.7484108061.7344108241.724108421.7064108601.69241264201.8241266181.80641268161.79241270141.77841272121.76441274101.754127681.7364127861.7224128041.7084128221.6944128401.6841460221.82241462201.80841464181.79441466161.7841468141.76641470121.75241472101.7384147481.7244147661.714147841.6964148021.6824148201.66841656241.82441658221.8141660201.79641662181.78241664161.76841666141.75441668121.7441670101.7264167281.7124167461.6984167641.6844167821.6741852261.82641854241.81241856221.79841858201.78441860181.7741862161.75641864141.74241866121.72841868101.7144187081.74187261.68642048281.82842050261.81442052241.842054221.78642056201.77242058181.75842060161.74442062141.7342064121.71642066101.7024206881.68842244301.8342246281.81642248261.80242250241.78842252221.77442254201.7642256181.74642258161.73242260141.71842262121.70442442301.81842444281.80442446261.7942448241.77642450221.76242452201.74842454181.73442456161.7242458141.70642638321.8242640301.80642642281.79242644261.77842646241.76442648221.7542650201.73642652181.72242654161.70842834341.82242836321.80842838301.79442840281.7842842261.76642844241.75242846221.73842848201.72443030361.82443032341.8143034321.79643036301.78243038281.76843040261.75443042241.7443044221.72643226381.82643228361.81243230341.79843232321.78443234301.7743236281.75643238261.74243422401.82843424381.81443426361.843428341.78643430321.77243432301.75843434281.74443618421.8343620401.81643622381.80243624361.78843626341.77443628321.7643630301.74643816421.81843818401.80443820381.7943822361.77643824341.76244012441.8244014421.80644016401.79244018381.77844020361.7644428461.82244210441.80844212421.79444214401.784444481.8244446461.814448441.79644410421.7824460501.8264462481.8124464461.7984480481.86080141.8266082121.8126084101.798608681.784608861.77609041.756609221.742609401.7286276161.8286278141.8146280121.86282101.786628481.772628661.758628841.744629021.73629201.7166472181.836474161.8166476141.8026478121.7886480101.774648281.76648461.746648641.732648821.718649001.7046670181.8186672161.8046674141.796676121.7766678101.762668081.748668261.734668441.72668621.706668801.6926866201.826868181.8066870161.7926872141.7786874121.7646876101.75687881.736688061.722688241.708688421.694688601.6861062221.82261064201.80861066181.79461068161.7861070141.76661072121.75261074101.7386107681.7246107861.716108041.6966108221.68261258241.82461260221.8161262201.79661264181.78261266161.76861268141.75461270121.7461272101.7266127481.7126127661.6986127841.68461454261.82661456241.81261458221.79861460201.78461462181.7761464161.75661466141.74261468121.72861470101.7146147281.761650281.82861652261.81461654241.861656221.78661658201.77261660181.75861662161.74461664141.7361666121.71661668101.70261846301.8361848281.81661850261.80261852241.78861854221.77461856201.7661858181.74661860161.73261862141.71861864121.70462044301.81862046281.80462048261.7962050241.77662052221.76262054201.74862056181.73462058161.7262240321.8262242301.80662244281.79262246261.77862248241.76462250221.7562252201.73662254181.72262436341.82262438321.80862440301.79462442281.7862444261.76662446241.75262448221.73862632361.82462634341.8162636321.79662638301.78262640281.76862642261.75462644241.7462828381.82662830361.81262832341.79862834321.78462836301.7762838281.75663024401.82863026381.81463028361.863030341.78663032321.77263034301.75863220421.8363222401.81663224381.80263226361.78863228341.77463230321.7663418421.81863420401.80463422381.7963424361.77663614441.8263616421.80663618401.79263620381.77863810461.82263812441.80863814421.7946406481.8246408461.8164010441.79