Spreadsheet: 356930d1415249262-formula-calculate-area-and-perimeter-for-multiple-columns-formula
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Alternative formula is required in DD & DE |  |  |  |  |  |  | Manually Done  Up to Column DC | Manually Done  Up to Column K need to be done for column DC
s no | description | type of flooring | D-1 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | D-2 |  | AREA | Perimeter
 |  |  | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | L | W | length X [NAME] | length x 2+Width x 2
1 | staircase (st1),(st2),(st3) | f09 | 260 | 540 |  |  | 260 | 540 | 260 | 540
2 | corridor | f23 | 6400 | 200
3 | lift lobby | f23 | 870 | 400
4 | f.h.c | f06 | 90 | 70 |  |  | 90 | 70
5 | elec.room | f06 | 390 | 300
6 | telephone room | f06 | 200 | 300
7 | w.m. | f06
8 | garbage chute room | f06 | 100 | 152 | 280 | 150
9 | flat entry /lobby | f23 |  | 200
10 | living / dining | f23 | 405 | 710 | 160 | 120 | 405 | 710 | 160 | 120 | 720 | 395 | 350 | 140 | 720 | 395 | 350 | 140 | 710 | 408 | 340 | 140 | 450 | 420 | 340 | 350 | 720 | 408 | 345 | 140 | 717 | 440 | 330 | 180 | 370 | 845 | 270 | 110 | 400 | 710 | 140 | 330 | 410 | 710 | 140 | 330 | 400 | 725 | 140 | 330 | 405 | 705 | 140 | 320 | 405 | 705 | 140 | 320 | 400 | 710 | 140 | 330 | 405 | 760 | 330 | 140 | 405 | 760 | 330 | 140 | 340 | 665 | 510 | 435 | 675 | 410 | 330 | 140 | 710 | 410 | 200 | 310 | 400 | 750 | 120 | 150 | 230 | 500 | 410 | 720 | 140 | 330 | 415 | 720 | 140 | 330 | 395 | 750 | 110 | 150 | 220 | 500 | 410 | 710 | 140 | 330
11 | bed room / master bed room | f02 | 390 | 430 | 190 | 120 | 390 | 430 | 190 | 120 | 430 | 385 | 190 | 120 | 430 | 385 | 190 | 120 | 410 | 400 | 250 | 120 | 440 | 400 | 120 | 200 | 420 | 400 | 210 | 190 | 390 | 385 | 210 | 190 | 370 | 390 | 120 | 190 | 400 | 440 | 120 | 400 | 395 | 410 | 120 | 250 | 385 | 410 | 110 | 250 | 395 | 410 | 120 | 190 | 400 | 390 | 120 | 250 | 395 | 390 | 120 | 250 | 395 | 390 | 120 | 250 | 390 | 425 | 120 | 250 | 390 | 400 | 270 | 130 | 420 | 400 | 250 | 130 | 450 | 400 | 130 | 190 | 410 | 410 | 110 | 180 | 400 | 420 | 120 | 250 | 400 | 420 | 120 | 250 | 405 | 410 | 110 | 180 | 395 | 410 | 120 | 250 | 400 | 420 | 120 | 250
12 | kitchen /pantry | f03 | 330 | 310 | 270 | 440 | 320 | 310 | 320 | 250 | 320 | 250 | 320 | 250 | 320 | 250 | 320 | 250 | 320 | 250 | 320 | 250 | 320 | 250 | 255 | 355 | 250 | 320 | 250 | 320 | 250 | 320 | 250 | 320 | 250 | 320 | 330 | 270 | 320 | 250 | 300 | 330 | 280 | 330 | 250 | 320 | 250 | 310 | 280 | 330 | 260 | 320
13 | W.C | F04 | 150 | 180 | 160 | 180 | 150 | 180 | 160 | 180 | 210 | 160 | 160 | 220 | 210 | 160 | 170 | 125 | 160 | 180 | 120 | 180 | 160 | 150 | 160 | 150 | 160 | 150 | 180 | 150 | 180 | 150 | 180 | 150 | 160 | 160 | 120 | 250 | 150 | 240 | 180 | 140 | 180 | 150 | 180 | 150 | 180 | 150 | 180 | 150 | 160 | 150
14 | bath | f04 | 180 | 260 | 270 | 180 | 180 | 260 | 200 | 200 | 180 | 270 | 200 | 195 | 180 | 270 | 270 | 180 | 180 | 270 | 260 | 180 | 280 | 180 | 270 | 180 | 270 | 180 | 155 | 270 | 180 | 260 | 250 | 190 | 235 | 180 | 270 | 180 | 270 | 180 | 235 | 180 | 270 | 180 | 270 | 180 | 270 | 180 | 270 | 180 | 270 | 180
15 | balcony | f23 | 180 | 810 | 100 | 385 | 395 | 165 | 200 | 400 | 280 | 380 | 600 | 175 | 280 | 380 | 180 | 460 | 200 | 380 | 410 | 180 | 395 | 180 | 395 | 180 | 380 | 200 | 378 | 200 | 378 | 200 | 385 | 200 | 360 | 410 | 150 | 385 | 230 | 405 | 820 | 255 | 380 | 200 | 370 | 200 | 830 | 200 | 380 | 180
16 | accessible shaft | f16
17 | utilities | f06 | 915 | 300
18 | passage | f23
19