?? This file is for cost and length parameter definition of all Wienerberger Families such as Lintels and Beams ??


LINTELS
ID DATA: 
ID=1 - Porotherm 7
ID=2 - Porotherm 11,5
ID=3 - Porotherm 14,5

SINGLE

LENGTH
IF(Lintel ID=1, (IF(Length<751,1000,IF(Length<1001, 1250, IF(Length<1251,1500, IF(Length<1501,1750, IF(Length<1601, 2000, IF(Length<1851, 2250, IF(Length<2001, 2500, IF(Length<2001, 2500, IF(Length<2251, 2750, IF(Length<2501, 3000, IF(Length<2751, 3250,3500)))))))))))),(if(Length < 501, 750, if(Length < 751, 1000, if(Length < 1001, 1250, if(Length < 1251, 1500, if(Length < 1501, 1750, if(Length < 1751, 2000, if(Length < 2001, 2250, if(Length < 2251, 2500, if(Length < 2501, 2750,3000))))))))))) 


COST

IF(Lintel ID=1, (IF(Beam Length=1000,214, IF(Beam Length=1250, 288, IF(Beam Length=1500,345, IF(Beam Length=1750,446, IF(Beam Length=2000,581, IF(Beam Length=2250,664, IF(Beam Length=2500,843, IF(Beam Length=2750,902, IF(Beam Length=3000,958, IF(Beam Length=3250,1024,1108))))))))))), IF(Lintel ID=2, (if(Beam Length = 750 , 91, if(Beam Length = 1000 , 123, if(Beam Length = 1250 , 153, if(Beam Length = 1500 , 187, if(Beam Length = 1750 , 228, if(Beam Length = 2000 , 257, if(Beam Length = 2250 , 292, if(Beam Length = 2500 , 332, if(Beam Length = 2750 , 371, 403)))))))))),(if(Beam Length = 750 , 100, if(Beam Length = 1000 , 133, if(Beam Length = 1250 , 168, if(Beam Length = 1500 , 202, if(Beam Length = 1750 , 240, if(Beam Length = 2000 , 275, if(Beam Length = 2250 , 311, if(Beam Length = 2500 , 355, if(Beam Length = 2750 , 394, 431))))))))))))

MULTI 
COST
Number of Lintels*"Cost of Single"


MULTI ISO
COST
(if(Length = 1000 mm, 214, if(Length = 1250 mm, 288, if(Length = 1500 mm, 345, if(Length = 1750 mm, 446, if(Length = 2000 mm, 581, if(Length = 2250 mm, 664, if(Length = 2500 mm, 843, if(Length = 2750 mm, 902, if(Length = 3000 mm, 958, if(Length = 3250 mm, 1024, 1108))))))))))) + (Number of Parts * (if(Lintel ID = 1, (if(Beam Length = 1000 mm, 214, if(Beam Length = 1250 mm, 288, if(Beam Length = 1500 mm, 345, if(Beam Length = 1750 mm, 446, if(Beam Length = 2000 mm, 581, if(Beam Length = 2250 mm, 664, if(Beam Length = 2500 mm, 843, if(Beam Length = 2750 mm, 902, if(Beam Length = 3000 mm, 958, if(Beam Length = 3250 mm, 1024, 1108))))))))))), if(Lintel ID = 2, (if(Beam Length = 750 mm, 91, if(Beam Length = 1000 mm, 123, if(Beam Length = 1250 mm, 153, if(Beam Length = 1500 mm, 187, if(Beam Length = 1750 mm, 228, if(Beam Length = 2000 mm, 257, if(Beam Length = 2250 mm, 292, if(Beam Length = 2500 mm, 332, if(Beam Length = 2750 mm, 371, 403)))))))))), (if(Beam Length = 750 mm, 100, if(Beam Length = 1000 mm, 133, if(Beam Length = 1250 mm, 168, if(Beam Length = 1500 mm, 202, if(Beam Length = 1750 mm, 240, if(Beam Length = 2000 mm, 275, if(Beam Length = 2250 mm, 311, if(Beam Length = 2500 mm, 355, if(Beam Length = 2750 mm, 394, 431))))))))))))))


------------------------------------------------------------------------------------------------------------------------------------------------------------------------


SLAB

POT

Length
IF(Length<1501,1750,IF(Length<1751, 2000, IF(Length<2001,2250, IF(Length<2251,2500, IF(Length<2501, 2750, IF(Length<2751, 3000, IF(Length<3001, 3250, IF(Length<3251, 3500, IF(Length<3501, 3750, IF(Length<3751, 4000, IF(Length<4001, 4250,IF(Length<4251, 4500,IF(Length<4501, 4750,IF(Length<4751, 5000,IF(Length<5001, 5250,IF(Length<5251, 5500,IF(Length<5501, 5750,IF(Length<5751, 6000,IF(Length<6001, 6250,IF(Length<6251, 6500,IF(Length<6501, 6750,IF(Length<6751, 7000,IF(Length<7001, 7250,IF(Length<7251, 7500,IF(Length<7501, 7750, 8000)))))))))))))))))))))))))

COST
IF(Beam Length=1750,374,IF(Beam Length=2000, 429, IF(Beam Length=2250,483, IF(Beam Length=2500,535, IF(Beam Length=2750, 587, IF(Beam Length=3000, 721, IF(Beam Length=3250, 781, IF(Beam Length=3500, 838, IF(Beam Length=3750,899, IF(Beam Length=4000, 1062, IF(Beam Length=4250, 1128,IF(Beam Length=4500, 1231,IF(Beam Length=4750, 1324,IF(Beam Length=5000, 1429,IF(Beam Length=5250, 1546,IF(Beam Length=5500, 1619,IF(Beam Length=5750, 1693,IF(Beam Length=6000,1887,IF(Beam Length=6250, 1966,IF(Beam Length=6500, 2241,IF(Beam Length=6750, 2399,IF(Beam Length=7000, 2613,IF(Beam Length=7250, 2705,IF(Beam Length=7500, 2848,IF(Beam Length=7750, 3082, 3180)))))))))))))))))))))))))

ID DATA
IF(Beam Length=1750,"POT 175/902",IF(Beam Length=2000, "POT 200/902", IF(Beam Length=2250,"POT 225/902", IF(Beam Length=2500,"POT 250/902", IF(Beam Length=2750, "POT 275/902", IF(Beam Length=3000, "POT 300/902", IF(Beam Length=3250,"POT 325/902", IF(Beam Length=3500, "POT 350/902", IF(Beam Length=3750, "POT 375/902", IF(Beam Length=4000, "POT 400/902", IF(Beam Length=4250, "POT 425/902",IF(Beam Length=4500, "POT 450/902",IF(Beam Length=4750, "POT 475/902",IF(Beam Length=5000, "POT 500/902",IF(Beam Length=5250, "POT 525/902",IF(Beam Length=5500, "POT 550/902",IF(Beam Length=5750, "POT 575/902",IF(Beam Length=6000, "POT 600/902",IF(Beam Length=6250, "POT 625/902",IF(Beam Length=6500,"POT 650/902",IF(Beam Length=6750, "POT 675/902",IF(Beam Length=7000, "POT 700/902",IF(Beam Length=7250, "POT 725/902",IF(Beam Length=7500, "POT 750/902",IF(Beam Length=7750, "POT 775/902", "POT 800/902")))))))))))))))))))))))))




MIAKO
Length = DTTO POT

COST
if(MIAKO ID = 1, (MIAKO Count * 41.3), if(MIAKO ID = 2, (MIAKO Count * 51.9), if(MIAKO ID = 3, (MIAKO Count * 62.9), if(MIAKO ID = 4, (MIAKO Count * 40.8), if(MIAKO ID = 5, (MIAKO Count * 54.2), if(MIAKO ID = 6, (MIAKO Count * 67.8), if(MIAKO ID = 7, (MIAKO Count * 82.5), 42.9)))))))


PTH
POT Length
DTTO POT

COST
POT
POT B Count*(IF(Beam Length=1750,374,IF(Beam Length=2000, 429, IF(Beam Length=2250,483, IF(Beam Length=2500,535, IF(Beam Length=2750, 587, IF(Beam Length=3000, 721, IF(Beam Length=3250,781, IF(Beam Length=3500, 838, IF(Beam Length=3750, 899, IF(Beam Length=4000, 1062, IF(Beam Length=4250, 1128,IF(Beam Length=4500, 1231,IF(Beam Length=4750, 	1324,IF(Beam Length=5000, 1429,IF(Beam Length=5250, 1546,IF(Beam Length=5500, 1619,IF(Beam Length=5750, 1693,IF(Beam Length=6000, 1887,IF(Beam Length=6250, 1966,IF(Beam Length=6500,2241,IF(Beam Length=6750, 2399,IF(Beam Length=7000, 2613,IF(Beam Length=7250, 2705,IF(Beam Length=7500,2848,IF(Beam Length=7750, 3082,3180))))))))))))))))))))))))))

MIAKO
MIAKO B Count * (if(MIAKO ID = 1, (MIAKO Count * 41.3), if(MIAKO ID = 2, (MIAKO Count * 51.9), if(MIAKO ID = 3, (MIAKO Count * 62.9), if(MIAKO ID = 4, (MIAKO Count * 40.8), if(MIAKO ID = 5, (MIAKO Count * 54.2), if(MIAKO ID = 6, (MIAKO Count * 67.8), if(MIAKO ID = 7, (MIAKO Count * 82.5), 42.9))))))))

ID DATA
POT TYPE
if(Slab Width < 1501 , "POT 175/902" , if(Slab Width < 1751 , "POT 200/902" , if(Slab Width < 2001 , "POT 225/902" , if(Slab Width < 2251 , "POT 250/902" , if(Slab Width < 2501 , "POT 275/902" , if(Slab Width < 2751 , "POT 300/902" , if(Slab Width < 3001 , "POT 325/902" , if(Slab Width < 3251 , "POT 350/902" , if(Slab Width < 3501 , "POT 375/902" , if(Slab Width < 3751 , "POT 400/902" , if(Slab Width < 4001 , "POT 425/902" , if(Slab Width < 4251 , "POT 450/902" , if(Slab Width < 4501 , "POT 475/902" , if(Slab Width < 4751 , "POT 500/902" , if(Slab Width < 5001 , "POT 525/902" , if(Slab Width < 5251 , "POT 550/902" , if(Slab Width < 5501 , "POT 575/902" , if(Slab Width < 5751 , "POT 600/902" , if(Slab Width < 6001 , "POT 625/902" , if(Slab Width < 6251 , "POT 650/902" , if(Slab Width < 6501 , "POT 675/902" , if(Slab Width < 6751 , "POT 700/902" , if(Slab Width < 7001 , "POT 725/902" , if(Slab Width < 7251 , "POT 750/902" , if(Slab Width < 7501 , "POT 775/902" , "POT 800/902" )))))))))))))))))))))))))

MIAKO TYPE
if(MIAKO ID = 1, "MIAKO 15/50" , if(MIAKO ID = 2, "MIAKO 19/50", if(MIAKO ID = 3, "MIAKO 23/50", if(MIAKO ID = 4, "MIAKO 8/50", if(MIAKO ID = 5, "MIAKO 15/62,5", if(MIAKO ID = 6, "MIAKO 19/62,5", if(MIAKO ID = 7, "MIAKO 23/62,5", "MIAKO 8/62,5")))))))

---------- Rudolf Vyhnalek, Autodesk, 2009 ----------