多功能综合楼《裙楼式》房屋公摊面积的计算过程表格文件下载.xls
《多功能综合楼《裙楼式》房屋公摊面积的计算过程表格文件下载.xls》由会员分享,可在线阅读,更多相关《多功能综合楼《裙楼式》房屋公摊面积的计算过程表格文件下载.xls(24页珍藏版)》请在冰点文库上搜索。
编号楼层名称套内面积共用面积用颜色划分确定:
分摊范围、分摊层次与分摊级别合计茶房办公宾馆A幢住宅专用梯间B幢住宅专用梯间通过裙楼的上人屋面梯外墙1/2小计专用梯专用梯专用梯1裙楼1-4层1层商业房2608.8018.0018.0018.0018.0054.0021.36147.362756.1622层茶楼房2608.8018.0018.0018.0018.0054.0021.36147.362756.1633层办公房2626.8018.0018.0018.0054.0021.36129.362756.1644层宾馆2644.8018.0018.0054.0021.36111.362756.165A、B两幢5-10层5层住宅1800.0054.0054.0031.52139.521939.5266层住宅1800.0054.0054.0031.52139.521939.5277层住宅1800.0054.0054.0031.52139.521939.5288层住宅1800.0054.0054.0031.52139.521939.5299层住宅1800.0054.0054.0031.52139.521939.521010层住宅1800.0054.0054.0031.52139.521939.5211上人屋面梯59.5259.5219.84138.88138.88合计21289.2036.0054.0072.00455.52599.5219.84274.561511.4422800.64(表表二二):
表表格格法法分分摊摊计计算算表表(本本例例是是利利用用“函函数数公公式式”自自动动计计算算公公摊摊面面积积)编号楼层名称套内面积共用面积分摊1级区内2级区间(裙楼)3级区间(裙楼)4级(裙楼)5级(住宅AB幢)本功能自摊参与套内1.2.区间参与套内1.2.3.区间参与套内1.2.3.4区间参与套内5-10区间1裙楼1-4层1层商业房2608.800.002608.808.972617.7711.932629.7034.6022层茶楼房2608.8018.002626.809.032635.8312.012647.8434.8433层办公房2626.8018.002644.8012.052656.8534.9644层宾馆2644.8018.002662.8035.045塔楼A幢住宅5-10层1单元1200.00108.001308.0021.6165-10层2单元1800.00108.001908.0031.5275-10层3单元2400.00108.002508.0041.438塔楼B幢住宅5-10层1单元1200.00108.001308.0021.6195-10层2单元1800.00108.001908.0031.52105-10层3单元2400.00108.002508.0041.43合计21289.20702.005235.6018.007898.4036.0010597.20139.4411448.00189.12(表表三三):
公公式式法法分分摊摊计计算算表表(本本例例是是利利用用“宏宏”自自动动生生成成一一个个“多多级级公公摊摊公公式式”)”)裙楼1-4层编号楼层功能名称套内面积公式表达式:
Ki=(1+Ei/Fi)(1+En/Fn)(1+E/F)-11裙楼1-4层1层商业房2608.80K=(1+18.00/5235.60)*(1+36.00/7898.40)*(1+139.44/10597.20)*(1+72.00/16555.20)*(1+216.00/16601.89)*(1+138.88/22661.76)-122层茶楼房2608.80K=(1+18.00/2608.80)*(1+18.00/5235.60)*(1+36.00/7898.40)*(1+139.44/10597.20)*(1+72.00/16555.20)*(1+216.00/16601.89)*(1+138.88/22661.76)-133层办公房2626.80K=(1+18.00/2626.80)*(1+36.00/7898.40)*(1+139.44/10597.20)*(1+72.00/16555.20)*(1+216.00/16601.89)*(1+138.88/22661.76)-144层宾馆2644.80K=(1+18.00/2644.80)*(1+139.44/10597.20)*(1+72.00/16555.20)*(1+216.00/16601.89)*(1+138.88/22661.76)-15塔楼A幢住宅5-10层1单元1200.00K=(1+108.00/1200.00)*(1+189.12/11448.00)*(1+72.00/16555.20)*(1+138.88/22661.76)-165-10层2单元1800.00K=(1+108.00/1800.00)*(1+189.12/11448.00)*(1+72.00/16555.20)*(1+138.88/22661.76)-175-10层3单元2400.00K=(1+108.00/2400.00)*(1+189.12/11448.00)*(1+72.00/16555.20)*(1+138.88/22661.76)-18塔楼B幢住宅5-10层1单元1200.00K=(1+108.00/1200.00)*(1+189.12/11448.00)*(1+216.00/16601.89)*(1+138.88/22661.76)-195-10层2单元1800.00K=(1+108.00/1800.00)*(1+189.12/11448.00)*(1+216.00/16601.89)*(1+138.88/22661.76)-1105-10层3单元2400.00K=(1+108.00/2400.00)*(1+189.12/11448.00)*(1+216.00/16601.89)*(1+138.88/22661.76)-1合计21289.20因本公式“层次清楚、清晰透明”,方便大家复核验证,所以笔者推荐使用“多级(全能)公式”。
通通过过以以上上计计算算验验证证,无无论论是是表表格格法法和和公公式式法法计计算算,其其计计算算结结果果基基本本一一致致,因因此此笔笔者者推推荐荐使使用用。
图图示示:
裙裙楼楼剖剖立立面面共共用用部部位位公公摊摊示示意意图图上面计算依据为,四川省房测细则中的5条规定:
1、一栋由裙楼相连的、有多个塔楼的房屋,裙楼、各塔楼应划分为不同功能区。
2、单一功能房屋存在多个单元时,按单元划分功能区。
3、层共有建筑面积:
当各层的共有建筑不同时,应区分各层的共有建筑面积,由各层分别进行分摊。
例如各层的卫生间、公共走道等各不相同时,按层各自分别进行分摊。
4、共有的屋顶楼梯间列为整栋的共有建筑面积。
5、室内专用梯(楼梯、电梯),其通过“不使用”建筑的梯间共有面积,列为“不使用”和“使用”两部分建筑的区间共有面积;
通过“使用”建筑的梯间共有面积为“使用”部分建筑的区内共有面积。
备注一、各功能的专用梯,从颜色中完全可以直观区分出:
“通过层”与“使用层”,即:
“通过层”面积由上下结构层共摊;
“使用层”则由本结构层自摊。
二、外墙1/2面积,由于上下结构层的明显差异,所以分别由上下结构层共摊。
三、毫无疑问,作为上人的屋面梯,具有屋面维修与消防功能作用,所以纳入幢摊。
合计公摊系数6级区间(裙+A幢)7级区间(裙+B幢)8级全幢参与套内裙+A幢区间参与套内裙+B幢区间参与套内全幢分摊2664.3011.592675.8934.812710.7016.612727.320.0454302682.6911.672694.3535.062729.4116.732746.130.0526432691.8111.712703.5235.172738.7016.782755.480.0489872697.8411.732709.5735.252744.8216.822761.650.0441791329.615.781335.398.181343.570.1196451939.528.441947.9611.941959.890.0888292549.4311.092560.5215.692576.210.0734211329.6117.301346.918.251355.160.1293011939.5225.231964.7512.041976.800.0982192549.4333.172582.6015.832598.430.08267916555.2072.0016601.89216.0022661.76138.8822800.64公摊系数公摊面积合计0.045430118.522727.320.052643137.332746.130.048987128.682755.480.044179116.852761.650.119645143.571343.570.088829159.891959.890.073421176.212576.210.129301155.161355.160.098219176.801976.800.082679198.432598.431511.4422800.64公式表达式:
Ki=(1+Ei/Fi)(1+En/Fn)(1+E/F)-1K=(1+18.00/5235.60)*(1+36.00/7898.40)*(1+139.44/10597.20)*(1+72.00/16555.20)*(1+216.00/16601.89)*(1+138.88/22661.76)-1K=(1+18.00/2608.80)*(1+18.00/5235.60)*(1+36.00/7898.40)*(1+139.44/10597.20)*(1+72.00/16555.20)*(1+216.00/16601.89)*(1+138.88/22661.76)-1K=(1+18.00/2626.80)*(1+36.00/7898.40)*(1+139.44/10597.20)*(1+72.00/16555.20)*(1+216.00/16601.89)*(1+138.88/22661.76)-1K=(1+18.00/2644.80)*(1+139.44/10597.20)*(1+72.00/16555.20)*(1+216.00/16601.89)*(1+138.88/22661.76)-1K=(1+108.00/1200.00)*(1+189.12/11448.00)*(1+72.00/16555.20)*(1+138.88/22661.76)-1K=(1+108.00/1800.00)*(1+189.12/11448.00)*(1+72.00/16555.20)*(1+138.88/22661.76)-1K=(1+108.00/2400.00)*(1+189.12/11448.00)*(1+72.00/16555.20)*(1+138.88/22661.76)-1K=(1+108.00/1200.00)*(1+189.12/11448.00)*(1+216.00/16601.89)*(1+138.88/22661.76)-1K=(1+108.00/1800.00)*(1+189.12/11448.00)*(1+216.00/16601.89)*(1+138.88/22661.76)-1K=(1+108.00/2400.00)*(1+189.12/11448.00)*(1+216.00/16601.89)*(1+138.88/22661.76)-1因本公式“层次清楚、清晰透明”,方便大家复核验证,所以笔者推荐使用“多级(全能)公式”。
原原始始数数据据分分项项尺尺寸寸输输入入表表带带颜颜色色的的数数据据,用用户户均均可可以以修修改改,但但切切记记不不用用的的数数据据一一定定设设“0”“0”编号楼层名称套内面积共用面积用颜色划分确定:
分摊范围、分摊层次与分摊级别合计茶房办公宾馆A幢住宅专用梯间B幢住宅专用梯间通过裙楼的上人屋面梯外墙1/2小计专用梯专用梯专用梯1裙楼1-3层1层商业房2608.8018.0018.0018.0018.0054.0021.36147.362756.1622层茶楼房2608.8018.0018.0018.0018.0054.0021.36147.362756.1633层办公房2626.8018.0018.0018.0054.0021.36129.362756.1644层宾馆2644.8018.0018.0054.0021.36111.362756.165A幢住宅5-10层A1单元1200.00108.0094.56418.565818.566A2单元1800.00108.007A3单元2400.00108.008B幢住宅5-10层B1单元1200.00108.0094.56418.565818.569B2单元1800.00108.0010B3单元2400.00108.0011上人屋面梯59.5259.5219.84138.88138.88合计21289.2036.0054.0072.00455.52599.5219.84274.561511.4422800.64(表表二二):
表表格格法法分分摊摊计计算算表表(本本例例是是利利用用“函函数数公公式式”自自动动计计算算公公摊摊面面积积)编号楼层功能区套内面积共用面积分摊合计公摊系数1级区内自摊2-7级区间共摊8级全楼共摊2级3级4级5级6级7级1裙楼1-3层1层商业房2608.808.9711.9334.6011.5934.8116.612727.320.04543022层茶楼房2608.8018.009.0312.0134.8411.6735.0616.732746.130.05264333层办公房2626.8018.0012.0534.9611.7135.1716.782755.480.04898744层宾馆2644.8018.0035.0411.7335.2516.822761.650.0441795A幢住宅5-10层A1单元1200.00108.0021.615.788.181343.570.1196456A2单元1800.00108.0031.528.4411.941959.890.0888297A3单元2400.00108.0041.4311.0915.692576.210.0734218B幢住宅5-10层B1单元1200.00108.0021.6117.308.251355.160.1293019B2单元1800.00108.0031.5225.2312.041976.800.09821910B3单元2400.00108.0041.4333.1715.832598.430.082679合计21289.20702.0018.0036.00139.44189.1272.00216.00138.8822800.64(表表三三):
公公式式法法分分摊摊计计算算表表(本本例例是是利利用用“宏宏”自自动动生生成成一一个个“一一级级公公摊摊公公式式”)”)编号楼层功能区套内面积公式表达式:
Ki=(1+E/F)-1公摊系数公摊面积合计1裙楼1-3层1层商业房2608.80K=(1+118.52/2608.80)-10.045430118.522727.3222层茶楼房2608.80K=(1+137.33/2608.80)-10.052643137.332746.1333层办公房2626.80K=(1+128.68/2626.80)-10.048987128.682755.4844层宾馆2644.80K=(1+116.85/2644.80)-10.044179116.852761.655A幢住宅5-10层A1单元1200.00K=(1+143.57/1200.00)-10.119645143.571343.576A2单元1800.00K=(1+159.89/1800.00)-10.088829159.891959.897A3单元2400.00K=(1+176.21/2400.00)-10.073421176.212576.218B幢住宅5-10层B1单元1200.00K=(1+155.16/1200.00)-10.129301155.161355.169B2单元1800.00K=(1+176.80/1800.00)-10.098219176.801976.8010B3单元2400.00K=(1+198.43/2400.00)-10.082679198.432598.43合计21289.20本“一级公式”常出现在房测软件与房测培训教材中,实属误区。
1511.4422800.64(表表三三):
公公式式法法分分摊摊计计算算表表(本本例例是是利利用用“宏宏”自自动动生生成成一一个个“二二级级公公摊摊公公式式”)”)编号楼层功能区套内面积公式表达式:
Ki=(1+E1/F1)(1+E2/F2)-1公摊系数公摊面积合计1裙楼1-3层1层商业房2608.80K=(1+101.90/2608.80)*(1+138.88/22661.76)-10.045430118.522727.3222层茶楼房2608.80K=(1+120.61/2608.80)*(1+138.88/22661.76)-10.052643137.332746.1333层办公房2626.80K=(1+111.90/2626.80)*(1+138.88/22661.76)-10.048987128.682755.4844层宾馆2644.80K=(1+100.02/2644.80)*(1+138.88/22661.76)-10.044179116.852761.655A幢住宅5-10层A1单元1200.00K=(1+135.39/1200.00)*(1+138.88/22661.76)-10.119645143.571343.576A2单元1800.00K=(1+147.96/1800.00)*(1+138.88/22661.76)-10.088829159.891959.897A3单元2400.00K=(1+160.52/2400.00)*(1+138.88/22661.76)-10.073421176.212576.218B幢住宅5-10层B1单元1200.00K=(1+146.91/1200.00)*(1+138.88/22661.76)-10.129301155.161355.169B2单元1800.00K=(1+164.75/1800.00)*(1+138.88/22661.76)-10.098219176.801976.8010B3单元2400.00K=(1+182.60/2400.00)*(1+138.88/22661.76)-10.082679198.432598.43合计21289.20本“二级公式”虽然比上述“一级公式”清晰透明一点,但仍不可取。
公公式式法法分分摊摊计计算算表表(本本例例是是利利用用“宏宏”自自动动生生成成一一个个“三三级级公公摊摊公公式式”)”)编号楼层功能区套内面积公式表达式:
Ki=(1+E1/F1)(1+E2/F2)-2公摊系数公摊面积合计1裙楼1-3层1层商业房2608.80K=(1+/2608.80)*(1+100/2560.04)*(1+138.88/22661.76)-10.045430118.522727.3222层茶楼房2608.80K=(1+18.00/2608.80)*(1+100/2560.04)*(1+138.88/22661.76)-10.052643137.332746.1333层办公房2626.80K=(1+18.00/2626.80)*(1+100/2816.75)*(1+138.88/22661.76)-10.048987128.682755.4844层宾馆2644.80K=(1+18.00/2644.80)*(1+100/3246.37)*(1+138.88/22661.76)-10.044179116.852761.655A幢住宅5-10层A1单元1200.00K=(1+108.00/1200.00)*(1+100/4775.36)*(1+138.88/22661.76)-10.119645143.571343.576A2单元1800.00K=(1+108.00/1800.00)*(1+100/4775.36)*(1+138.88/22661.76)-10.088829159.891959.897A3单元2400.00K=(1+108.00/2400.00)*(1+100/4775.36)*(1+138.88/22661.76)-10.073421176.212576.218B幢住宅5-10层B1单元1200.00K=(1+108.00/1200.00)*(1+100/3361.86)*(1+138.88/22661.76)-10.129301155.161355.169B2单元1800.00K=(1+108.00/1800.00)*(1+100/3361.86)*(1+138.88/22661.76)-10.098219176.801976.8010B3单元2400.00K=(1+108.00/2400.00)*(1+100/3361.86)*(1+138.88/22661.76)-10.082679198.432598.43合计21289.20本“三级公式”虽然比上述“二级公式”清晰透明一点,但仍不可取。
1511.4422800.64以以上上三三种种公公式式,虽虽然然最最终终计计算算结结果果正正确确,但但公公式式中中却却隐隐含含了了许许多多信信息息,因因此此不不宜宜采采用用。
裙楼1-3层上面计算依据为:
四川省房测细则中的5条规定: