Formula to get the range of certain Category

N

nazarene

New Member
Joined
Jun 25, 2015
Messages
43
Office Version
  1. 365
Platform
  1. Windows
Dear Sir,
Can you please help me to make a formula in excel with the following category?
in the table below , I want to get the height type for each item. example. Type "Independents (IN)" the height is 2.03, so the height type should be 6, because 0 to 6 the height type is 6, etc. , another example Type "Suspended Floors (SF)" the height is 6.01 so the height type is 8. can you do it to all the category"?
thanks in advance. I also put the screen shots, because i cannot -arrange as it is, as I cannot see also the attachment for excel files

ITEM NO. Type Height DESCRIPTION
type
IST-01 Stair Towers (ST) 6 0-6 Installation of Stair Towers (IST) from ground up to 6.00 m
IST-02 Stair Towers (ST) 8 6.0-8 Installation of Stair Towers (IST) from 6.01 m up to 8.00 m
IST-03 Stair Towers (ST) 10 8.01-10 Installation of Stair Towers (IST) from 8.01 m up to 10.00 m
IST-04 Stair Towers (ST) 12 10.01-12 Installation of Stair Towers (IST) from 10.01 m up to 12.00 m
IST-05 Stair Towers (ST) 14 12.01-14 Installation of Stair Towers (IST) from 12.01 m up to 14.00 m
IST-06 Stair Towers (ST) 16 14.01-16 Installation of Stair Towers (IST) from 14.01 m up to 16.00 m
IST-07 Stair Towers (ST) 18 16.01-18 Installation of Stair Towers (IST) from 16.01 m up to 18.00 m
IST-08 Stair Towers (ST) 20 18.01-20 Installation of Stair Towers (IST) from 18.01 m up to 20.00 m
IST-09 Stair Towers (ST) 22 20.01-22 Installation of Stair Towers (IST) from 20.01 m up to 22.00 m
IST-10 Stair Towers (ST) 24 22.01-24 Installation of Stair Towers (IST) from 22.01 m up to 24.00 m
IST-11 Stair Towers (ST) 26 24.01-26 Installation of Stair Towers (IST) from 24.01 m up to 26.00 m
IST-12 Stair Towers (ST) 28 26.01-28 Installation of Stair Towers (IST) from 26.01 m up to 28.00 m
IST-13 Stair Towers (ST) 30 28.01-30 Installation of Stair Towers (IST) from 28.01 m up to 30.00 m
IST-14 Stair Towers (ST) 32 30.01-32 Installation of Stair Towers (IST) from 30.01 m up to 32.00 m
IST-15 Stair Towers (ST) 34 32.01-34 Installation of Stair Towers (IST) from 32.01 m up to 34.00 m
IST-16 Stair Towers (ST) 36 34.01-36 Installation of Stair Towers (IST) from 34.01 m up to 36.00 m
IST-17 Stair Towers (ST) 38 36.01-38 Installation of Stair Towers (IST) from 36.01 m up to 38.00 m
IST-18 Stair Towers (ST) 40 38.01-40 Installation of Stair Towers (IST) from 38.01 m up to 40.00 m
IST-19 Stair Towers (ST) 42 40.01-42 Installation of Stair Towers (IST) from 40.01 m up to 42.00 m
IST-20 Stair Towers (ST) 44 42.01-44 Installation of Stair Towers (IST) from 42.01 m up to 44.00 m
IST-21 Stair Towers (ST) 46 44.01-46 Installation of Stair Towers (IST) from 44.01 m up to 46.00 m
IST-22 Stair Towers (ST) 48 46.01-48 Installation of Stair Towers (IST) from 46.01 m up to 48.00 m
IST-23 Stair Towers (ST) 50 48.01-50 Installation of Stair Towers (IST) from 48.01 m up to 50.00 m
IST-24 Stair Towers (ST) 51 50.01-Above Installation of Stair Towers (IST) above 50 m

IWG-01 Walkways (WG) 8 6.01-8 Installation of Walkways (IWG) , by means of scaffolds built from 6.01 m up to 8.00 m
IWG-02 Walkways (WG) 10 8.01-10 Installation of Walkways (IWG) , by means of scaffolds built from 8.01 m up to 10.00 m
IWG-03 Walkways (WG) 12 10.01-12 Installation of Walkways (IWG) , by means of scaffolds built from 10.01 m up to 12.00 m
IWG-04 Walkways (WG) 14 12.01-14 Installation of Walkways (IWG) , by means of scaffolds built from 12.01 m up to 14.00 m
IWG-05 Walkways (WG) 16 14.01-16 Installation of Walkways (IWG) , by means of scaffolds built from 14.01 m up to 16.00 m
IWG-06 Walkways (WG) 18 16.01-18 Installation of Walkways (IWG) , by means of scaffolds built from 16.01 m up to 18.00 m
IWG-07 Walkways (WG) 20 18.01-20 Installation of Walkways (IWG) , by means of scaffolds built from 18.01 m up to 20.00 m
IWG-08 Walkways (WG) 22 20.01-22 Installation of Walkways (IWG) , by means of scaffolds built from 20.01 m up to 22.00 m
IWG-09 Walkways (WG) 24 22.01-24 Installation of Walkways (IWG) , by means of scaffolds built from 22.01 m up to 24.00 m
IWG-10 Walkways (WG) 26 24.01-26 Installation of Walkways (IWG) , by means of scaffolds built from 24.01 m up to 26.00 m
IWG-11 Walkways (WG) 28 26.01-28 Installation of Walkways (IWG) , by means of scaffolds built from 26.01 m up to 28.00 m
IWG-12 Walkways (WG) 30 28.01-30 Installation of Walkways (IWG) , by means of scaffolds built from 28.01 m up to 30.00 m
IWG-13 Walkways (WG) 32 30.01-32 Installation of Walkways (IWG) , by means of scaffolds built from 30.01 m up to 32.00 m
IWG-14 Walkways (WG) 34 32.01-34 Installation of Walkways (IWG) , by means of scaffolds built from 32.01 m up to 34.00 m
IWG-15 Walkways (WG) 36 34.01-36 Installation of Walkways (IWG) , by means of scaffolds built from 34.01 m up to 36.00 m
IWG-16 Walkways (WG) 38 36.01-38 Installation of Walkways (IWG) , by means of scaffolds built from 36.01 m up to 38.00 m
IWG-17 Walkways (WG) 40 38.01-40 Installation of Walkways (IWG) , by means of scaffolds built from 38.01 m up to 40.00 m
IWG-18 Walkways (WG) 42 40.01-42 Installation of Walkways (IWG) , by means of scaffolds built from 40.01 m up to 42.00 m
IWG-19 Walkways (WG) 44 42.01-44 Installation of Walkways (IWG) , by means of scaffolds built from 42.01 m up to 44.00 m
IWG-20 Walkways (WG) 46 44.01-46 Installation of Walkways (IWG) , by means of scaffolds built from 44.01 m up to 46.00 m
IWG-21 Walkways (WG) 48 46.01-48 Installation of Walkways (IWG) , by means of scaffolds built from 46.01 m up to 48.00 m
IWG-22 Walkways (WG) 50 48.01-50 Installation of Walkways (IWG) , by means of scaffolds built from 48.01 m up to 50.00 m
IWG-23 Walkways (WG) 51 50.01-Above Installation of Walkways (IWG) , by means of scaffolds built above 50 m

ISF-01 Suspended Floors (SF) 8 6.01-8 Installation of Suspended Floors (ISF) from from 6.01 m up to 8.00 m
ISF-02 Suspended Floors (SF) 10 8.01-10 Installation of Suspended Floors (ISF) from from 8.01 m up to 10.00 m
ISF-03 Suspended Floors (SF) 12 10.01-12 Installation of Suspended Floors (ISF) from from 10.01 m up to 12.00 m
ISF-04 Suspended Floors (SF) 14 12.01-14 Installation of Suspended Floors (ISF) from from 12.01 m up to 14.00 m
ISF-05 Suspended Floors (SF) 16 14.01-16 Installation of Suspended Floors (ISF) from from 14.01 m up to 16.00 m
ISF-06 Suspended Floors (SF) 18 16.01-18 Installation of Suspended Floors (ISF) from from 16.01 m up to 18.00 m
ISF-07 Suspended Floors (SF) 20 18.01-20 Installation of Suspended Floors (ISF) from from 18.01 m up to 20.00 m
ISF-08 Suspended Floors (SF) 22 20.01-22 Installation of Suspended Floors (ISF) from from 20.01 m up to 22.00 m
ISF-09 Suspended Floors (SF) 24 22.01-24 Installation of Suspended Floors (ISF) from from 22.01 m up to 24.00 m
ISF-10 Suspended Floors (SF) 26 24.01-26 Installation of Suspended Floors (ISF) from from 24.01 m up to 26.00 m
ISF-11 Suspended Floors (SF) 28 26.01-28 Installation of Suspended Floors (ISF) from from 26.01 m up to 28.00 m
ISF-12 Suspended Floors (SF) 30 28.01-30 Installation of Suspended Floors (ISF) from from 28.01 m up to 30.00 m
ISF-13 Suspended Floors (SF) 32 30.01-32 Installation of Suspended Floors (ISF) from from 30.01 m up to 32.00 m
ISF-14 Suspended Floors (SF) 34 32.01-34 Installation of Suspended Floors (ISF) from from 32.01 m up to 34.00 m
ISF-15 Suspended Floors (SF) 36 34.01-36 Installation of Suspended Floors (ISF) from from 34.01 m up to 36.00 m
ISF-16 Suspended Floors (SF) 38 36.01-38 Installation of Suspended Floors (ISF) from from 36.01 m up to 38.00 m
ISF-17 Suspended Floors (SF) 40 38.01-40 Installation of Suspended Floors (ISF) from from 38.01 m up to 40.00 m
ISF-18 Suspended Floors (SF) 42 40.01-42 Installation of Suspended Floors (ISF) from from 40.01 m up to 42.00 m
ISF-19 Suspended Floors (SF) 44 42.01-44 Installation of Suspended Floors (ISF) from from 42.01 m up to 44.00 m
ISF-20 Suspended Floors (SF) 46 44.01-46 Installation of Suspended Floors (ISF) from from 44.01 m up to 46.00 m
ISF-21 Suspended Floors (SF) 48 46.01-48 Installation of Suspended Floors (ISF) from from 46.01 m up to 48.00 m
ISF-22 Suspended Floors (SF) 50 48.01-50 Installation of Suspended Floors (ISF) from from 48.01 m up to 50.00 m
ISF-23 Suspended Floors (SF) 51 50.01-Above Installation of Suspended Floors (ISF) above 50 m

ITS-01 Tower Structures (TS) 6 0-6 Installation of Tower Structures (ITS) from ground up to 6.00 m
ITS-02 Tower Structures (TS) 8 6.0-8 Installation of Tower Structures (ITS) from 6.01 m up to 8.00 m
ITS-03 Tower Structures (TS) 10 8.01-10 Installation of Tower Structures (ITS) from 8.01 m up to 10.00 m
ITS-04 Tower Structures (TS) 12 10.01-12 Installation of Tower Structures (ITS) from 10.01 m up to 12.00 m
ITS-05 Tower Structures (TS) 14 12.01-14 Installation of Tower Structures (ITS) from 12.01 m up to 14.00 m
ITS-06 Tower Structures (TS) 16 14.01-16 Installation of Tower Structures (ITS) from 14.01 m up to 16.00 m
ITS-07 Tower Structures (TS) 18 16.01-18 Installation of Tower Structures (ITS) from 16.01 m up to 18.00 m
ITS-08 Tower Structures (TS) 20 18.01-20 Installation of Tower Structures (ITS) from 18.01 m up to 20.00 m
ITS-09 Tower Structures (TS) 22 20.01-22 Installation of Tower Structures (ITS) from 20.01 m up to 22.00 m
ITS-10 Tower Structures (TS) 24 22.01-24 Installation of Tower Structures (ITS) from 22.01 m up to 24.00 m
ITS-11 Tower Structures (TS) 26 24.01-26 Installation of Tower Structures (ITS) from 24.01 m up to 26.00 m
ITS-12 Tower Structures (TS) 28 26.01-28 Installation of Tower Structures (ITS) from 26.01 m up to 28.00 m
ITS-13 Tower Structures (TS) 30 28.01-30 Installation of Tower Structures (ITS) from 28.01 m up to 30.00 m
ITS-14 Tower Structures (TS) 32 30.01-32 Installation of Tower Structures (ITS) from 30.01 m up to 32.00 m
ITS-15 Tower Structures (TS) 34 32.01-34 Installation of Tower Structures (ITS) from 32.01 m up to 34.00 m
ITS-16 Tower Structures (TS) 36 34.01-36 Installation of Tower Structures (ITS) from 34.01 m up to 36.00 m
ITS-17 Tower Structures (TS) 38 36.01-38 Installation of Tower Structures (ITS) from 36.01 m up to 38.00 m
ITS-18 Tower Structures (TS) 40 38.01-40 Installation of Tower Structures (ITS) from 38.01 m up to 40.00 m
ITS-19 Tower Structures (TS) 42 40.01-42 Installation of Tower Structures (ITS) from 40.01 m up to 42.00 m
ITS-20 Tower Structures (TS) 44 42.01-44 Installation of Tower Structures (ITS) from 42.01 m up to 44.00 m
ITS-21 Tower Structures (TS) 46 44.01-46 Installation of Tower Structures (ITS) from 44.01 m up to 46.00 m
ITS-22 Tower Structures (TS) 48 46.01-48 Installation of Tower Structures (ITS) from 46.01 m up to 48.00 m
ITS-23 Tower Structures (TS) 50 48.01-50 Installation of Tower Structures (ITS) from 48.01 m up to 50.00 m
ITS-24 Tower Structures (TS) 51 50.01-Above Installation of Tower Structures (ITS) above 50 m

IBC-01 Birdcages (IBC) 6 0-6.0 Installation of Birdcages (IBC) from ground up to 6.00 m
IBC-02 Birdcages (IBC) 8 6.01-8 Installation of Birdcages (IBC) from 6.01 m up to 8.00 m
IBC-03 Birdcages (IBC) 10 8.01-10 Installation of Birdcages (IBC) from 8.01 m up to 10.00 m
IBC-04 Birdcages (IBC) 12 10.01-12 Installation of Birdcages (IBC) from 10.01 m up to 12.00 m
IBC-05 Birdcages (IBC) 14 12.01-14 Installation of Birdcages (IBC) from 12.01 m up to 14.00 m
IBC-06 Birdcages (IBC) 16 14.01-16 Installation of Birdcages (IBC) from 14.01 m up to 16.00 m
IBC-07 Birdcages (IBC) 18 16.01-18 Installation of Birdcages (IBC) from 16.01 m up to 18.00 m
IBC-08 Birdcages (IBC) 20 18.01-20 Installation of Birdcages (IBC) from 18.01 m up to 20.00 m
IBC-09 Birdcages (IBC) 22 20.01-22 Installation of Birdcages (IBC) from 20.01 m up to 22.00 m
IBC-10 Birdcages (IBC) 24 22.01-24 Installation of Birdcages (IBC) from 22.01 m up to 24.00 m
IBC-11 Birdcages (IBC) 26 24.01-26 Installation of Birdcages (IBC) from 24.01 m up to 26.00 m
IBC-12 Birdcages (IBC) 28 26.01-28 Installation of Birdcages (IBC) from 26.01 m up to 28.00 m
IBC-13 Birdcages (IBC) 30 28.01-30 Installation of Birdcages (IBC) from 28.01 m up to 30.00 m
IBC-14 Birdcages (IBC) 32 30.01-32 Installation of Birdcages (IBC) from 30.01 m up to 32.00 m
IBC-15 Birdcages (IBC) 34 32.01-34 Installation of Birdcages (IBC) from 32.01 m up to 34.00 m
IBC-16 Birdcages (IBC) 36 34.01-36 Installation of Birdcages (IBC) from 34.01 m up to 36.00 m
IBC-17 Birdcages (IBC) 38 36.01-38 Installation of Birdcages (IBC) from 36.01 m up to 38.00 m
IBC-18 Birdcages (IBC) 40 38.01-40 Installation of Birdcages (IBC) from 38.01 m up to 40.00 m
IBC-19 Birdcages (IBC) 42 40.01-42 Installation of Birdcages (IBC) from 40.01 m up to 42.00 m
IBC-20 Birdcages (IBC) 44 42.01-44 Installation of Birdcages (IBC) from 42.01 m up to 44.00 m
IBC-21 Birdcages (IBC) 46 44.01-46 Installation of Birdcages (IBC) from 44.01 m up to 46.00 m
IBC-22 Birdcages (IBC) 48 46.01-48 Installation of Birdcages (IBC) from 46.01 m up to 48.00 m
IBC-23 Birdcages (IBC) 50 48.01-50 Installation of Birdcages (IBC) from 48.01 m up to 50.00 m
IBC-24 Birdcages (IBC) 51 50.01-Above Installation of Birdcages (IBC) above 50 m

IHBC-01 Hanging Birdcages (IHBC) 2 0-2 Installation of Hanging Birdcages (IHBC) from structure down to 2.00 m
IHBC-02 Hanging Birdcages (IHBC) 4 2.01-4 Installation of Hanging Birdcages (IHBC) from structure down from to 2.01 m to 4.00 m
IHBC-03 Hanging Birdcages (IHBC) 6 4.01-6 Installation of Hanging Birdcages (IHBC) from structure down from to 4.01 m to 6.00 m

IIN-01 Independents (IN) 6 0 - 6.0 Installation of Independents (IIN) from ground up to 6.00 m
IIN-02 Independents (IN) 8 6.01-8 Installation of Independents (IIN) from 6.01 m up to 8.00 m
IIN-03 Independents (IN) 10 8.01-10 Installation of Independents (IIN) from 8.01 m up to 10.00 m
IIN-04 Independents (IN) 12 10.01-12 Installation of Independents (IIN) from 10.01 m up to 12.00 m
IIN-05 Independents (IN) 14 12.01-14 Installation of Independents (IIN) from 12.01 m up to 14.00 m
IIN-06 Independents (IN) 16 14.01-16 Installation of Independents (IIN) from 14.01 m up to 16.00 m
IIN-07 Independents (IN) 18 16.01-18 Installation of Independents (IIN) from 16.01 m up to 18.00 m
IIN-08 Independents (IN) 20 18.01-20 Installation of Independents (IIN) from 18.01 m up to 20.00 m
IIN-09 Independents (IN) 22 20.01-22 Installation of Independents (IIN) from 20.01 m up to 22.00 m
IIN-10 Independents (IN) 24 22.01-24 Installation of Independents (IIN) from 22.01 m up to 24.00 m
IIN-11 Independents (IN) 26 24.01-26 Installation of Independents (IIN) from 24.01 m up to 26.00 m
IIN-12 Independents (IN) 28 26.01-28 Installation of Independents (IIN) from 26.01 m up to 28.00 m
IIN-13 Independents (IN) 30 28.01-30 Installation of Independents (IIN) from 28.01 m up to 30.00 m
IIN-14 Independents (IN) 32 30.01-32 Installation of Independents (IIN) from 30.01 m up to 32.00 m
IIN-15 Independents (IN) 34 32.01-34 Installation of Independents (IIN) from 32.01 m up to 34.00 m
IIN-16 Independents (IN) 36 34.01-36 Installation of Independents (IIN) from 34.01 m up to 36.00 m
IIN-17 Independents (IN) 38 36.01-38 Installation of Independents (IIN) from 36.01 m up to 38.00 m
IIN-18 Independents (IN) 40 38.01-40 Installation of Independents (IIN) from 38.01 m up to 40.00 m
IIN-19 Independents (IN) 42 40.01-42 Installation of Independents (IIN) from 40.01 m up to 42.00 m
IIN-20 Independents (IN) 44 42.01-44 Installation of Independents (IIN) from 42.01 m up to 44.00 m
IIN-21 Independents (IN) 46 44.01-46 Installation of Independents (IIN) from 44.01 m up to 46.00 m
IIN-22 Independents (IN) 48 46.01-48 Installation of Independents (IIN) from 46.01 m up to 48.00 m
IIN-23 Independents (IN) 50 48.01-50 Installation of Independents (IIN) from 48.01 m up to 50.00 m
IIN-24 Independents (IN) 51 50.01-Above Installation of Independents (IIN) above 50 m
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Sort by date Sort by votes
This is pretty clunky and very specific for your question. For the ranges with above, it will scan to 99999.
Let me know if works.
Book1
AB
1Product NameStair Towers (ST)
2Height52
3Type:51
4
5
6
7IST-01 Stair Towers (ST) 6 0-6 Installation of Stair Towers (IST) from ground up to 6.00 m
8IST-02 Stair Towers (ST) 8 6.0-8 Installation of Stair Towers (IST) from 6.01 m up to 8.00 m
9IST-03 Stair Towers (ST) 10 8.01-10 Installation of Stair Towers (IST) from 8.01 m up to 10.00 m
10IST-04 Stair Towers (ST) 12 10.01-12 Installation of Stair Towers (IST) from 10.01 m up to 12.00 m
11IST-05 Stair Towers (ST) 14 12.01-14 Installation of Stair Towers (IST) from 12.01 m up to 14.00 m
12IST-06 Stair Towers (ST) 16 14.01-16 Installation of Stair Towers (IST) from 14.01 m up to 16.00 m
13IST-07 Stair Towers (ST) 18 16.01-18 Installation of Stair Towers (IST) from 16.01 m up to 18.00 m
14IST-08 Stair Towers (ST) 20 18.01-20 Installation of Stair Towers (IST) from 18.01 m up to 20.00 m
15IST-09 Stair Towers (ST) 22 20.01-22 Installation of Stair Towers (IST) from 20.01 m up to 22.00 m
16IST-10 Stair Towers (ST) 24 22.01-24 Installation of Stair Towers (IST) from 22.01 m up to 24.00 m
17IST-11 Stair Towers (ST) 26 24.01-26 Installation of Stair Towers (IST) from 24.01 m up to 26.00 m
18IST-12 Stair Towers (ST) 28 26.01-28 Installation of Stair Towers (IST) from 26.01 m up to 28.00 m
19IST-13 Stair Towers (ST) 30 28.01-30 Installation of Stair Towers (IST) from 28.01 m up to 30.00 m
20IST-14 Stair Towers (ST) 32 30.01-32 Installation of Stair Towers (IST) from 30.01 m up to 32.00 m
21IST-15 Stair Towers (ST) 34 32.01-34 Installation of Stair Towers (IST) from 32.01 m up to 34.00 m
22IST-16 Stair Towers (ST) 36 34.01-36 Installation of Stair Towers (IST) from 34.01 m up to 36.00 m
23IST-17 Stair Towers (ST) 38 36.01-38 Installation of Stair Towers (IST) from 36.01 m up to 38.00 m
24IST-18 Stair Towers (ST) 40 38.01-40 Installation of Stair Towers (IST) from 38.01 m up to 40.00 m
25IST-19 Stair Towers (ST) 42 40.01-42 Installation of Stair Towers (IST) from 40.01 m up to 42.00 m
26IST-20 Stair Towers (ST) 44 42.01-44 Installation of Stair Towers (IST) from 42.01 m up to 44.00 m
27IST-21 Stair Towers (ST) 46 44.01-46 Installation of Stair Towers (IST) from 44.01 m up to 46.00 m
28IST-22 Stair Towers (ST) 48 46.01-48 Installation of Stair Towers (IST) from 46.01 m up to 48.00 m
29IST-23 Stair Towers (ST) 50 48.01-50 Installation of Stair Towers (IST) from 48.01 m up to 50.00 m
30IST-24 Stair Towers (ST) 51 50.01-Above Installation of Stair Towers (IST) above 50 m
31
32IWG-01 Walkways (WG) 8 6.01-8 Installation of Walkways (IWG) , by means of scaffolds built from 6.01 m up to 8.00 m
33IWG-02 Walkways (WG) 10 8.01-10 Installation of Walkways (IWG) , by means of scaffolds built from 8.01 m up to 10.00 m
34IWG-03 Walkways (WG) 12 10.01-12 Installation of Walkways (IWG) , by means of scaffolds built from 10.01 m up to 12.00 m
35IWG-04 Walkways (WG) 14 12.01-14 Installation of Walkways (IWG) , by means of scaffolds built from 12.01 m up to 14.00 m
36IWG-05 Walkways (WG) 16 14.01-16 Installation of Walkways (IWG) , by means of scaffolds built from 14.01 m up to 16.00 m
37IWG-06 Walkways (WG) 18 16.01-18 Installation of Walkways (IWG) , by means of scaffolds built from 16.01 m up to 18.00 m
38IWG-07 Walkways (WG) 20 18.01-20 Installation of Walkways (IWG) , by means of scaffolds built from 18.01 m up to 20.00 m
39IWG-08 Walkways (WG) 22 20.01-22 Installation of Walkways (IWG) , by means of scaffolds built from 20.01 m up to 22.00 m
40IWG-09 Walkways (WG) 24 22.01-24 Installation of Walkways (IWG) , by means of scaffolds built from 22.01 m up to 24.00 m
41IWG-10 Walkways (WG) 26 24.01-26 Installation of Walkways (IWG) , by means of scaffolds built from 24.01 m up to 26.00 m
42IWG-11 Walkways (WG) 28 26.01-28 Installation of Walkways (IWG) , by means of scaffolds built from 26.01 m up to 28.00 m
43IWG-12 Walkways (WG) 30 28.01-30 Installation of Walkways (IWG) , by means of scaffolds built from 28.01 m up to 30.00 m
44IWG-13 Walkways (WG) 32 30.01-32 Installation of Walkways (IWG) , by means of scaffolds built from 30.01 m up to 32.00 m
45IWG-14 Walkways (WG) 34 32.01-34 Installation of Walkways (IWG) , by means of scaffolds built from 32.01 m up to 34.00 m
46IWG-15 Walkways (WG) 36 34.01-36 Installation of Walkways (IWG) , by means of scaffolds built from 34.01 m up to 36.00 m
47IWG-16 Walkways (WG) 38 36.01-38 Installation of Walkways (IWG) , by means of scaffolds built from 36.01 m up to 38.00 m
48IWG-17 Walkways (WG) 40 38.01-40 Installation of Walkways (IWG) , by means of scaffolds built from 38.01 m up to 40.00 m
49IWG-18 Walkways (WG) 42 40.01-42 Installation of Walkways (IWG) , by means of scaffolds built from 40.01 m up to 42.00 m
50IWG-19 Walkways (WG) 44 42.01-44 Installation of Walkways (IWG) , by means of scaffolds built from 42.01 m up to 44.00 m
51IWG-20 Walkways (WG) 46 44.01-46 Installation of Walkways (IWG) , by means of scaffolds built from 44.01 m up to 46.00 m
52IWG-21 Walkways (WG) 48 46.01-48 Installation of Walkways (IWG) , by means of scaffolds built from 46.01 m up to 48.00 m
53IWG-22 Walkways (WG) 50 48.01-50 Installation of Walkways (IWG) , by means of scaffolds built from 48.01 m up to 50.00 m
54IWG-23 Walkways (WG) 51 50.01-Above Installation of Walkways (IWG) , by means of scaffolds built above 50 m
55
56ISF-01 Suspended Floors (SF) 8 6.01-8 Installation of Suspended Floors (ISF) from from 6.01 m up to 8.00 m
57ISF-02 Suspended Floors (SF) 10 8.01-10 Installation of Suspended Floors (ISF) from from 8.01 m up to 10.00 m
58ISF-03 Suspended Floors (SF) 12 10.01-12 Installation of Suspended Floors (ISF) from from 10.01 m up to 12.00 m
59ISF-04 Suspended Floors (SF) 14 12.01-14 Installation of Suspended Floors (ISF) from from 12.01 m up to 14.00 m
60ISF-05 Suspended Floors (SF) 16 14.01-16 Installation of Suspended Floors (ISF) from from 14.01 m up to 16.00 m
61ISF-06 Suspended Floors (SF) 18 16.01-18 Installation of Suspended Floors (ISF) from from 16.01 m up to 18.00 m
62ISF-07 Suspended Floors (SF) 20 18.01-20 Installation of Suspended Floors (ISF) from from 18.01 m up to 20.00 m
63ISF-08 Suspended Floors (SF) 22 20.01-22 Installation of Suspended Floors (ISF) from from 20.01 m up to 22.00 m
64ISF-09 Suspended Floors (SF) 24 22.01-24 Installation of Suspended Floors (ISF) from from 22.01 m up to 24.00 m
65ISF-10 Suspended Floors (SF) 26 24.01-26 Installation of Suspended Floors (ISF) from from 24.01 m up to 26.00 m
66ISF-11 Suspended Floors (SF) 28 26.01-28 Installation of Suspended Floors (ISF) from from 26.01 m up to 28.00 m
67ISF-12 Suspended Floors (SF) 30 28.01-30 Installation of Suspended Floors (ISF) from from 28.01 m up to 30.00 m
68ISF-13 Suspended Floors (SF) 32 30.01-32 Installation of Suspended Floors (ISF) from from 30.01 m up to 32.00 m
69ISF-14 Suspended Floors (SF) 34 32.01-34 Installation of Suspended Floors (ISF) from from 32.01 m up to 34.00 m
70ISF-15 Suspended Floors (SF) 36 34.01-36 Installation of Suspended Floors (ISF) from from 34.01 m up to 36.00 m
71ISF-16 Suspended Floors (SF) 38 36.01-38 Installation of Suspended Floors (ISF) from from 36.01 m up to 38.00 m
72ISF-17 Suspended Floors (SF) 40 38.01-40 Installation of Suspended Floors (ISF) from from 38.01 m up to 40.00 m
73ISF-18 Suspended Floors (SF) 42 40.01-42 Installation of Suspended Floors (ISF) from from 40.01 m up to 42.00 m
74ISF-19 Suspended Floors (SF) 44 42.01-44 Installation of Suspended Floors (ISF) from from 42.01 m up to 44.00 m
75ISF-20 Suspended Floors (SF) 46 44.01-46 Installation of Suspended Floors (ISF) from from 44.01 m up to 46.00 m
76ISF-21 Suspended Floors (SF) 48 46.01-48 Installation of Suspended Floors (ISF) from from 46.01 m up to 48.00 m
77ISF-22 Suspended Floors (SF) 50 48.01-50 Installation of Suspended Floors (ISF) from from 48.01 m up to 50.00 m
78ISF-23 Suspended Floors (SF) 51 50.01-Above Installation of Suspended Floors (ISF) above 50 m
79
80ITS-01 Tower Structures (TS) 6 0-6 Installation of Tower Structures (ITS) from ground up to 6.00 m
81ITS-02 Tower Structures (TS) 8 6.0-8 Installation of Tower Structures (ITS) from 6.01 m up to 8.00 m
82ITS-03 Tower Structures (TS) 10 8.01-10 Installation of Tower Structures (ITS) from 8.01 m up to 10.00 m
83ITS-04 Tower Structures (TS) 12 10.01-12 Installation of Tower Structures (ITS) from 10.01 m up to 12.00 m
84ITS-05 Tower Structures (TS) 14 12.01-14 Installation of Tower Structures (ITS) from 12.01 m up to 14.00 m
85ITS-06 Tower Structures (TS) 16 14.01-16 Installation of Tower Structures (ITS) from 14.01 m up to 16.00 m
86ITS-07 Tower Structures (TS) 18 16.01-18 Installation of Tower Structures (ITS) from 16.01 m up to 18.00 m
87ITS-08 Tower Structures (TS) 20 18.01-20 Installation of Tower Structures (ITS) from 18.01 m up to 20.00 m
88ITS-09 Tower Structures (TS) 22 20.01-22 Installation of Tower Structures (ITS) from 20.01 m up to 22.00 m
89ITS-10 Tower Structures (TS) 24 22.01-24 Installation of Tower Structures (ITS) from 22.01 m up to 24.00 m
90ITS-11 Tower Structures (TS) 26 24.01-26 Installation of Tower Structures (ITS) from 24.01 m up to 26.00 m
91ITS-12 Tower Structures (TS) 28 26.01-28 Installation of Tower Structures (ITS) from 26.01 m up to 28.00 m
92ITS-13 Tower Structures (TS) 30 28.01-30 Installation of Tower Structures (ITS) from 28.01 m up to 30.00 m
93ITS-14 Tower Structures (TS) 32 30.01-32 Installation of Tower Structures (ITS) from 30.01 m up to 32.00 m
94ITS-15 Tower Structures (TS) 34 32.01-34 Installation of Tower Structures (ITS) from 32.01 m up to 34.00 m
95ITS-16 Tower Structures (TS) 36 34.01-36 Installation of Tower Structures (ITS) from 34.01 m up to 36.00 m
96ITS-17 Tower Structures (TS) 38 36.01-38 Installation of Tower Structures (ITS) from 36.01 m up to 38.00 m
97ITS-18 Tower Structures (TS) 40 38.01-40 Installation of Tower Structures (ITS) from 38.01 m up to 40.00 m
98ITS-19 Tower Structures (TS) 42 40.01-42 Installation of Tower Structures (ITS) from 40.01 m up to 42.00 m
99ITS-20 Tower Structures (TS) 44 42.01-44 Installation of Tower Structures (ITS) from 42.01 m up to 44.00 m
100ITS-21 Tower Structures (TS) 46 44.01-46 Installation of Tower Structures (ITS) from 44.01 m up to 46.00 m
101ITS-22 Tower Structures (TS) 48 46.01-48 Installation of Tower Structures (ITS) from 46.01 m up to 48.00 m
102ITS-23 Tower Structures (TS) 50 48.01-50 Installation of Tower Structures (ITS) from 48.01 m up to 50.00 m
103ITS-24 Tower Structures (TS) 51 50.01-Above Installation of Tower Structures (ITS) above 50 m
104
105IBC-01 Birdcages (IBC) 6 0-6.0 Installation of Birdcages (IBC) from ground up to 6.00 m
106IBC-02 Birdcages (IBC) 8 6.01-8 Installation of Birdcages (IBC) from 6.01 m up to 8.00 m
107IBC-03 Birdcages (IBC) 10 8.01-10 Installation of Birdcages (IBC) from 8.01 m up to 10.00 m
108IBC-04 Birdcages (IBC) 12 10.01-12 Installation of Birdcages (IBC) from 10.01 m up to 12.00 m
109IBC-05 Birdcages (IBC) 14 12.01-14 Installation of Birdcages (IBC) from 12.01 m up to 14.00 m
110IBC-06 Birdcages (IBC) 16 14.01-16 Installation of Birdcages (IBC) from 14.01 m up to 16.00 m
111IBC-07 Birdcages (IBC) 18 16.01-18 Installation of Birdcages (IBC) from 16.01 m up to 18.00 m
112IBC-08 Birdcages (IBC) 20 18.01-20 Installation of Birdcages (IBC) from 18.01 m up to 20.00 m
113IBC-09 Birdcages (IBC) 22 20.01-22 Installation of Birdcages (IBC) from 20.01 m up to 22.00 m
114IBC-10 Birdcages (IBC) 24 22.01-24 Installation of Birdcages (IBC) from 22.01 m up to 24.00 m
115IBC-11 Birdcages (IBC) 26 24.01-26 Installation of Birdcages (IBC) from 24.01 m up to 26.00 m
116IBC-12 Birdcages (IBC) 28 26.01-28 Installation of Birdcages (IBC) from 26.01 m up to 28.00 m
117IBC-13 Birdcages (IBC) 30 28.01-30 Installation of Birdcages (IBC) from 28.01 m up to 30.00 m
118IBC-14 Birdcages (IBC) 32 30.01-32 Installation of Birdcages (IBC) from 30.01 m up to 32.00 m
119IBC-15 Birdcages (IBC) 34 32.01-34 Installation of Birdcages (IBC) from 32.01 m up to 34.00 m
120IBC-16 Birdcages (IBC) 36 34.01-36 Installation of Birdcages (IBC) from 34.01 m up to 36.00 m
121IBC-17 Birdcages (IBC) 38 36.01-38 Installation of Birdcages (IBC) from 36.01 m up to 38.00 m
122IBC-18 Birdcages (IBC) 40 38.01-40 Installation of Birdcages (IBC) from 38.01 m up to 40.00 m
123IBC-19 Birdcages (IBC) 42 40.01-42 Installation of Birdcages (IBC) from 40.01 m up to 42.00 m
124IBC-20 Birdcages (IBC) 44 42.01-44 Installation of Birdcages (IBC) from 42.01 m up to 44.00 m
125IBC-21 Birdcages (IBC) 46 44.01-46 Installation of Birdcages (IBC) from 44.01 m up to 46.00 m
126IBC-22 Birdcages (IBC) 48 46.01-48 Installation of Birdcages (IBC) from 46.01 m up to 48.00 m
127IBC-23 Birdcages (IBC) 50 48.01-50 Installation of Birdcages (IBC) from 48.01 m up to 50.00 m
128IBC-24 Birdcages (IBC) 51 50.01-Above Installation of Birdcages (IBC) above 50 m
129
130IHBC-01 Hanging Birdcages (IHBC) 2 0-2 Installation of Hanging Birdcages (IHBC) from structure down to 2.00 m
131IHBC-02 Hanging Birdcages (IHBC) 4 2.01-4 Installation of Hanging Birdcages (IHBC) from structure down from to 2.01 m to 4.00 m
132IHBC-03 Hanging Birdcages (IHBC) 6 4.01-6 Installation of Hanging Birdcages (IHBC) from structure down from to 4.01 m to 6.00 m
133
134IIN-01 Independents (IN) 6 0 - 6.0 Installation of Independents (IIN) from ground up to 6.00 m
135IIN-02 Independents (IN) 8 6.01-8 Installation of Independents (IIN) from 6.01 m up to 8.00 m
136IIN-03 Independents (IN) 10 8.01-10 Installation of Independents (IIN) from 8.01 m up to 10.00 m
137IIN-04 Independents (IN) 12 10.01-12 Installation of Independents (IIN) from 10.01 m up to 12.00 m
138IIN-05 Independents (IN) 14 12.01-14 Installation of Independents (IIN) from 12.01 m up to 14.00 m
139IIN-06 Independents (IN) 16 14.01-16 Installation of Independents (IIN) from 14.01 m up to 16.00 m
140IIN-07 Independents (IN) 18 16.01-18 Installation of Independents (IIN) from 16.01 m up to 18.00 m
141IIN-08 Independents (IN) 20 18.01-20 Installation of Independents (IIN) from 18.01 m up to 20.00 m
142IIN-09 Independents (IN) 22 20.01-22 Installation of Independents (IIN) from 20.01 m up to 22.00 m
143IIN-10 Independents (IN) 24 22.01-24 Installation of Independents (IIN) from 22.01 m up to 24.00 m
144IIN-11 Independents (IN) 26 24.01-26 Installation of Independents (IIN) from 24.01 m up to 26.00 m
145IIN-12 Independents (IN) 28 26.01-28 Installation of Independents (IIN) from 26.01 m up to 28.00 m
146IIN-13 Independents (IN) 30 28.01-30 Installation of Independents (IIN) from 28.01 m up to 30.00 m
147IIN-14 Independents (IN) 32 30.01-32 Installation of Independents (IIN) from 30.01 m up to 32.00 m
148IIN-15 Independents (IN) 34 32.01-34 Installation of Independents (IIN) from 32.01 m up to 34.00 m
149IIN-16 Independents (IN) 36 34.01-36 Installation of Independents (IIN) from 34.01 m up to 36.00 m
150IIN-17 Independents (IN) 38 36.01-38 Installation of Independents (IIN) from 36.01 m up to 38.00 m
151IIN-18 Independents (IN) 40 38.01-40 Installation of Independents (IIN) from 38.01 m up to 40.00 m
152IIN-19 Independents (IN) 42 40.01-42 Installation of Independents (IIN) from 40.01 m up to 42.00 m
153IIN-20 Independents (IN) 44 42.01-44 Installation of Independents (IIN) from 42.01 m up to 44.00 m
154IIN-21 Independents (IN) 46 44.01-46 Installation of Independents (IIN) from 44.01 m up to 46.00 m
155IIN-22 Independents (IN) 48 46.01-48 Installation of Independents (IIN) from 46.01 m up to 48.00 m
156IIN-23 Independents (IN) 50 48.01-50 Installation of Independents (IIN) from 48.01 m up to 50.00 m
157IIN-24 Independents (IN) 51 50.01-Above Installation of Independents (IIN) above 50 m
Sheet1
Cell Formulas
RangeFormula
B3B3=LET(ProdName,B1,Height,B2,String1,FILTER(A7:A157,A7:A157<>"",""),Products,TEXTBEFORE(String1,") ")&")", ProductNames,TEXTAFTER(Products," "),Rest1,SUBSTITUTE(String1,Products,""), Htypes,TRIM(TEXTBEFORE(Rest1," ",2)), Rest2,SUBSTITUTE(Rest1," "&Htypes&" ",""), LowLimits,1*TEXTBEFORE(Rest2,"-"), UpLimits,IFERROR(1*TEXTAFTER(TEXTBEFORE(Rest2," "),"-"),99999), Htype,FILTER(Htypes,(LowLimits<=Height)*(UpLimits>=Height)*(ProdName=ProductNames),""),Htype)
 
Upvote 0
Good Morning sir,
Thank you sir to your prompt replied, sorry maybe my explanation is not clear.
ITEM NO. Type Job Height Type DESCRIPTION ITEM NO.
ST Stair Towers (ST) ST
IST-01 Stair Towers (ST) Install 6 Installation of Stair Towers (IST) from ground up to 6.00 m IST-01
IST-02 Stair Towers (ST) Install 8 Installation of Stair Towers (IST) from 6.01 m up to 8.00 m IST-02
IST-03 Stair Towers (ST) Install 10 Installation of Stair Towers (IST) from 8.01 m up to 10.00 m IST-03
IST-04 Stair Towers (ST) Install 12 Installation of Stair Towers (IST) from 10.01 m up to 12.00 m IST-04
IST-05 Stair Towers (ST) Install 14 Installation of Stair Towers (IST) from 12.01 m up to 14.00 m IST-05
IST-06 Stair Towers (ST) Install 16 Installation of Stair Towers (IST) from 14.01 m up to 16.00 m IST-06
IST-07 Stair Towers (ST) Install 18 Installation of Stair Towers (IST) from 16.01 m up to 18.00 m IST-07
IST-08 Stair Towers (ST) Install 20 Installation of Stair Towers (IST) from 18.01 m up to 20.00 m IST-08
IST-09 Stair Towers (ST) Install 22 Installation of Stair Towers (IST) from 20.01 m up to 22.00 m IST-09
IST-10 Stair Towers (ST) Install 24 Installation of Stair Towers (IST) from 22.01 m up to 24.00 m IST-10
IST-11 Stair Towers (ST) Install 26 Installation of Stair Towers (IST) from 24.01 m up to 26.00 m IST-11
IST-12 Stair Towers (ST) Install 28 Installation of Stair Towers (IST) from 26.01 m up to 28.00 m IST-12
IST-13 Stair Towers (ST) Install 30 Installation of Stair Towers (IST) from 28.01 m up to 30.00 m IST-13
IST-14 Stair Towers (ST) Install 32 Installation of Stair Towers (IST) from 30.01 m up to 32.00 m IST-14
IST-15 Stair Towers (ST) Install 34 Installation of Stair Towers (IST) from 32.01 m up to 34.00 m IST-15
IST-16 Stair Towers (ST) Install 36 Installation of Stair Towers (IST) from 34.01 m up to 36.00 m IST-16
IST-17 Stair Towers (ST) Install 38 Installation of Stair Towers (IST) from 36.01 m up to 38.00 m IST-17
IST-18 Stair Towers (ST) Install 40 Installation of Stair Towers (IST) from 38.01 m up to 40.00 m IST-18
IST-19 Stair Towers (ST) Install 42 Installation of Stair Towers (IST) from 40.01 m up to 42.00 m IST-19
IST-20 Stair Towers (ST) Install 44 Installation of Stair Towers (IST) from 42.01 m up to 44.00 m IST-20
IST-21 Stair Towers (ST) Install 46 Installation of Stair Towers (IST) from 44.01 m up to 46.00 m IST-21
IST-22 Stair Towers (ST) Install 48 Installation of Stair Towers (IST) from 46.01 m up to 48.00 m IST-22
IST-23 Stair Towers (ST) Install 50 Installation of Stair Towers (IST) from 48.01 m up to 50.00 m IST-23
IST-24 Stair Towers (ST) Install 51 Installation of Stair Towers (IST) above 50 m IST-24

STDR-01 Stair Towers (ST) Rental 60 Installed Stair Tower Daily Rental fee (STDR) for duration till 60 days STDR-01
STDR-02 Stair Towers (ST) Rental 120 Installed Stair Tower Daily Rental fee (STDR) for duration from 61 till 120 days STDR-02
STDR-03 Stair Towers (ST) Rental 121 Installed Stair Tower Daily Rental fee (STDR) for duration above 120 days STDR-03

DST-01 Stair Towers (ST) Dismantle 6 Dismantling of Stair Towers (DST) from ground up to 6.00 m DST-01
DST-02 Stair Towers (ST) Dismantle 8 Dismantling of Stair Towers (DST) from 6.01 m up to 8.00 m DST-02
DST-03 Stair Towers (ST) Dismantle 10 Dismantling of Stair Towers (DST) from 8.01 m up to 10.00 m DST-03
DST-04 Stair Towers (ST) Dismantle 12 Dismantling of Stair Towers (DST) from 10.01 m up to 12.00 m DST-04
DST-05 Stair Towers (ST) Dismantle 14 Dismantling of Stair Towers (DST) from 12.01 m up to 14.00 m DST-05
DST-06 Stair Towers (ST) Dismantle 16 Dismantling of Stair Towers (DST) from 14.01 m up to 16.00 m DST-06
DST-07 Stair Towers (ST) Dismantle 18 Dismantling of Stair Towers (DST) from 16.01 m up to 18.00 m DST-07
DST-08 Stair Towers (ST) Dismantle 20 Dismantling of Stair Towers (DST) from 18.01 m up to 20.00 m DST-08
DST-09 Stair Towers (ST) Dismantle 22 Dismantling of Stair Towers (DST) from 20.01 m up to 22.00 m DST-09
DST-10 Stair Towers (ST) Dismantle 24 Dismantling of Stair Towers (DST) from 22.01 m up to 24.00 m DST-10
DST-11 Stair Towers (ST) Dismantle 26 Dismantling of Stair Towers (DST) from 24.01 m up to 26.00 m DST-11
DST-12 Stair Towers (ST) Dismantle 28 Dismantling of Stair Towers (DST) from 26.01 m up to 28.00 m DST-12
DST-13 Stair Towers (ST) Dismantle 30 Dismantling of Stair Towers (DST) from 28.01 m up to 30.00 m DST-13
DST-14 Stair Towers (ST) Dismantle 32 Dismantling of Stair Towers (DST) from 30.01 m up to 32.00 m DST-14
DST-15 Stair Towers (ST) Dismantle 34 Dismantling of Stair Towers (DST) from 32.01 m up to 34.00 m DST-15
DST-16 Stair Towers (ST) Dismantle 36 Dismantling of Stair Towers (DST) from 34.01 m up to 36.00 m DST-16
DST-17 Stair Towers (ST) Dismantle 38 Dismantling of Stair Towers (DST) from 36.01 m up to 38.00 m DST-17
DST-18 Stair Towers (ST) Dismantle 40 Dismantling of Stair Towers (DST) from 38.01 m up to 40.00 m DST-18
DST-19 Stair Towers (ST) Dismantle 42 Dismantling of Stair Towers (DST) from 40.01 m up to 42.00 m DST-19
DST-20 Stair Towers (ST) Dismantle 44 Dismantling of Stair Towers (DST) from 42.01 m up to 44.00 m DST-20
DST-21 Stair Towers (ST) Dismantle 46 Dismantling of Stair Towers (DST) from 44.01 m up to 46.00 m DST-21
DST-22 Stair Towers (ST) Dismantle 48 Dismantling of Stair Towers (DST) from 46.01 m up to 48.00 m DST-22
DST-23 Stair Towers (ST) Dismantle 50 Dismantling of Stair Towers (DST) from 48.01 m up to 50.00 m DST-23
DST-24 Stair Towers (ST) Dismantle 51 Dismantling of Stair Towers (DST) above 50 m DST-24
WG Walkways (WG) WG
IWG-01 Walkways (WG) Install 8 Installation of Walkways (IWG) , by means of scaffolds built from 6.01 m up to 8.00 m IWG-01
IWG-02 Walkways (WG) Install 10 Installation of Walkways (IWG) , by means of scaffolds built from 8.01 m up to 10.00 m IWG-02
IWG-03 Walkways (WG) Install 12 Installation of Walkways (IWG) , by means of scaffolds built from 10.01 m up to 12.00 m IWG-03
IWG-04 Walkways (WG) Install 14 Installation of Walkways (IWG) , by means of scaffolds built from 12.01 m up to 14.00 m IWG-04
IWG-05 Walkways (WG) Install 16 Installation of Walkways (IWG) , by means of scaffolds built from 14.01 m up to 16.00 m IWG-05
IWG-06 Walkways (WG) Install 18 Installation of Walkways (IWG) , by means of scaffolds built from 16.01 m up to 18.00 m IWG-06
IWG-07 Walkways (WG) Install 20 Installation of Walkways (IWG) , by means of scaffolds built from 18.01 m up to 20.00 m IWG-07
IWG-08 Walkways (WG) Install 22 Installation of Walkways (IWG) , by means of scaffolds built from 20.01 m up to 22.00 m IWG-08
IWG-09 Walkways (WG) Install 24 Installation of Walkways (IWG) , by means of scaffolds built from 22.01 m up to 24.00 m IWG-09
IWG-10 Walkways (WG) Install 26 Installation of Walkways (IWG) , by means of scaffolds built from 24.01 m up to 26.00 m IWG-10
IWG-11 Walkways (WG) Install 28 Installation of Walkways (IWG) , by means of scaffolds built from 26.01 m up to 28.00 m IWG-11
IWG-12 Walkways (WG) Install 30 Installation of Walkways (IWG) , by means of scaffolds built from 28.01 m up to 30.00 m IWG-12
IWG-13 Walkways (WG) Install 32 Installation of Walkways (IWG) , by means of scaffolds built from 30.01 m up to 32.00 m IWG-13
IWG-14 Walkways (WG) Install 34 Installation of Walkways (IWG) , by means of scaffolds built from 32.01 m up to 34.00 m IWG-14
IWG-15 Walkways (WG) Install 36 Installation of Walkways (IWG) , by means of scaffolds built from 34.01 m up to 36.00 m IWG-15
IWG-16 Walkways (WG) Install 38 Installation of Walkways (IWG) , by means of scaffolds built from 36.01 m up to 38.00 m IWG-16
IWG-17 Walkways (WG) Install 40 Installation of Walkways (IWG) , by means of scaffolds built from 38.01 m up to 40.00 m IWG-17
IWG-18 Walkways (WG) Install 42 Installation of Walkways (IWG) , by means of scaffolds built from 40.01 m up to 42.00 m IWG-18
IWG-19 Walkways (WG) Install 44 Installation of Walkways (IWG) , by means of scaffolds built from 42.01 m up to 44.00 m IWG-19
IWG-20 Walkways (WG) Install 46 Installation of Walkways (IWG) , by means of scaffolds built from 44.01 m up to 46.00 m IWG-20
IWG-21 Walkways (WG) Install 48 Installation of Walkways (IWG) , by means of scaffolds built from 46.01 m up to 48.00 m IWG-21
IWG-22 Walkways (WG) Install 50 Installation of Walkways (IWG) , by means of scaffolds built from 48.01 m up to 50.00 m IWG-22
IWG-23 Walkways (WG) Install 51 Installation of Walkways (IWG) , by means of scaffolds built above 50 m IWG-23
IWDR-01 Walkways (WG) Rental 60 Installed Walkways Daily Rental fee (IWDR) for duration till 60 days IWDR-01
IWDR-02 Walkways (WG) Rental 120 Installed Walkways Daily Rental fee (IWDR) for duration from 61 till 120 days IWDR-02
IWDR-03 Walkways (WG) Rental 121 Installed Walkways Daily Rental fee (IWDR) for duration above 120 days IWDR-03
DWG-01 Walkways (WG) Dismantle 8 Dismantling of Walkways (DWG) from from 6.01 m up to 8.00 m DWG-01
DWG-02 Walkways (WG) Dismantle 10 Dismantling of Walkways (DWG) from from 8.01 m up to 10.00 m DWG-02
DWG-03 Walkways (WG) Dismantle 12 Dismantling of Walkways (DWG) from from 10.01 m up to 12.00 m DWG-03
DWG-04 Walkways (WG) Dismantle 14 Dismantling of Walkways (DWG) from from 12.01 m up to 14.00 m DWG-04
DWG-05 Walkways (WG) Dismantle 16 Dismantling of Walkways (DWG) from from 14.01 m up to 16.00 m DWG-05
DWG-06 Walkways (WG) Dismantle 18 Dismantling of Walkways (DWG) from from 16.01 m up to 18.00 m DWG-06
DWG-07 Walkways (WG) Dismantle 20 Dismantling of Walkways (DWG) from from 18.01 m up to 20.00 m DWG-07
DWG-08 Walkways (WG) Dismantle 22 Dismantling of Walkways (DWG) from from 20.01 m up to 22.00 m DWG-08
DWG-09 Walkways (WG) Dismantle 24 Dismantling of Walkways (DWG) from from 22.01 m up to 24.00 m DWG-09
DWG-10 Walkways (WG) Dismantle 26 Dismantling of Walkways (DWG) from from 24.01 m up to 26.00 m DWG-10
DWG-11 Walkways (WG) Dismantle 28 Dismantling of Walkways (DWG) from from 26.01 m up to 28.00 m DWG-11
DWG-12 Walkways (WG) Dismantle 30 Dismantling of Walkways (DWG) from from 28.01 m up to 30.00 m DWG-12
DWG-13 Walkways (WG) Dismantle 32 Dismantling of Walkways (DWG) from from 30.01 m up to 32.00 m DWG-13
DWG-14 Walkways (WG) Dismantle 34 Dismantling of Walkways (DWG) from from 32.01 m up to 34.00 m DWG-14
DWG-15 Walkways (WG) Dismantle 36 Dismantling of Walkways (DWG) from from 34.01 m up to 36.00 m DWG-15
DWG-16 Walkways (WG) Dismantle 38 Dismantling of Walkways (DWG) from from 36.01 m up to 38.00 m DWG-16
DWG-17 Walkways (WG) Dismantle 40 Dismantling of Walkways (DWG) from from 38.01 m up to 40.00 m DWG-17
DWG-18 Walkways (WG) Dismantle 42 Dismantling of Walkways (DWG) from from 40.01 m up to 42.00 m DWG-18
DWG-19 Walkways (WG) Dismantle 44 Dismantling of Walkways (DWG) from from 42.01 m up to 44.00 m DWG-19
DWG-20 Walkways (WG) Dismantle 46 Dismantling of Walkways (DWG) from from 44.01 m up to 46.00 m DWG-20
DWG-21 Walkways (WG) Dismantle 48 Dismantling of Walkways (DWG) from from 46.01 m up to 48.00 m DWG-21
DWG-22 Walkways (WG) Dismantle 50 Dismantling of Walkways (DWG) from from 48.01 m up to 50.00 m DWG-22
DWG-23 Walkways (WG) Dismantle 51 Dismantling of Walkways (DWG) above 50 m DWG-23
SF Suspended Floors (SF) SF
ISF-01 Suspended Floors (SF) Install 8 Installation of Suspended Floors (ISF) from from 6.01 m up to 8.00 m ISF-01
ISF-02 Suspended Floors (SF) Install 10 Installation of Suspended Floors (ISF) from from 8.01 m up to 10.00 m ISF-02
ISF-03 Suspended Floors (SF) Install 12 Installation of Suspended Floors (ISF) from from 10.01 m up to 12.00 m ISF-03
ISF-04 Suspended Floors (SF) Install 14 Installation of Suspended Floors (ISF) from from 12.01 m up to 14.00 m ISF-04
ISF-05 Suspended Floors (SF) Install 16 Installation of Suspended Floors (ISF) from from 14.01 m up to 16.00 m ISF-05
ISF-06 Suspended Floors (SF) Install 18 Installation of Suspended Floors (ISF) from from 16.01 m up to 18.00 m ISF-06
ISF-07 Suspended Floors (SF) Install 20 Installation of Suspended Floors (ISF) from from 18.01 m up to 20.00 m ISF-07
ISF-08 Suspended Floors (SF) Install 22 Installation of Suspended Floors (ISF) from from 20.01 m up to 22.00 m ISF-08
ISF-09 Suspended Floors (SF) Install 24 Installation of Suspended Floors (ISF) from from 22.01 m up to 24.00 m ISF-09
ISF-10 Suspended Floors (SF) Install 26 Installation of Suspended Floors (ISF) from from 24.01 m up to 26.00 m ISF-10
ISF-11 Suspended Floors (SF) Install 28 Installation of Suspended Floors (ISF) from from 26.01 m up to 28.00 m ISF-11
ISF-12 Suspended Floors (SF) Install 30 Installation of Suspended Floors (ISF) from from 28.01 m up to 30.00 m ISF-12
ISF-13 Suspended Floors (SF) Install 32 Installation of Suspended Floors (ISF) from from 30.01 m up to 32.00 m ISF-13
ISF-14 Suspended Floors (SF) Install 34 Installation of Suspended Floors (ISF) from from 32.01 m up to 34.00 m ISF-14
ISF-15 Suspended Floors (SF) Install 36 Installation of Suspended Floors (ISF) from from 34.01 m up to 36.00 m ISF-15
ISF-16 Suspended Floors (SF) Install 38 Installation of Suspended Floors (ISF) from from 36.01 m up to 38.00 m ISF-16
ISF-17 Suspended Floors (SF) Install 40 Installation of Suspended Floors (ISF) from from 38.01 m up to 40.00 m ISF-17
ISF-18 Suspended Floors (SF) Install 42 Installation of Suspended Floors (ISF) from from 40.01 m up to 42.00 m ISF-18
ISF-19 Suspended Floors (SF) Install 44 Installation of Suspended Floors (ISF) from from 42.01 m up to 44.00 m ISF-19
ISF-20 Suspended Floors (SF) Install 46 Installation of Suspended Floors (ISF) from from 44.01 m up to 46.00 m ISF-20
ISF-21 Suspended Floors (SF) Install 48 Installation of Suspended Floors (ISF) from from 46.01 m up to 48.00 m ISF-21
ISF-22 Suspended Floors (SF) Install 50 Installation of Suspended Floors (ISF) from from 48.01 m up to 50.00 m ISF-22
ISF-23 Suspended Floors (SF) Install 51 Installation of Suspended Floors (ISF) above 50 m ISF-23
SFDR-01 Suspended Floors (SF) Rental 60 Installed Suspended Floors Daily Rental fee (SFDR) for duration till 60 days SFDR-01
SFDR-02 Suspended Floors (SF) Rental 120 Installed Suspended Floors Daily Rental fee (SFDR) for duration from 61 till 120 days SFDR-02
SFDR-03 Suspended Floors (SF) Rental 121 Installed Suspended Floors Daily Rental fee (SFDR) for duration above 120 days SFDR-03
DSF-01 Suspended Floors (SF) Dismantle 8 Dismantling of Suspended Floors (DSF) from 6.01 m up to 8.00 m DSF-01
DSF-02 Suspended Floors (SF) Dismantle 10 Dismantling of Suspended Floors (DSF) from 8.01 m up to 10.00 m DSF-02
DSF-03 Suspended Floors (SF) Dismantle 12 Dismantling of Suspended Floors (DSF) from 10.01 m up to 12.00 m DSF-03
DSF-04 Suspended Floors (SF) Dismantle 14 Dismantling of Suspended Floors (DSF) from 12.01 m up to 14.00 m DSF-04
DSF-05 Suspended Floors (SF) Dismantle 16 Dismantling of Suspended Floors (DSF) from 14.01 m up to 16.00 m DSF-05
DSF-06 Suspended Floors (SF) Dismantle 18 Dismantling of Suspended Floors (DSF) from 16.01 m up to 18.00 m DSF-06
DSF-07 Suspended Floors (SF) Dismantle 20 Dismantling of Suspended Floors (DSF) from 18.01 m up to 20.00 m DSF-07
DSF-08 Suspended Floors (SF) Dismantle 22 Dismantling of Suspended Floors (DSF) from 20.01 m up to 22.00 m DSF-08
DSF-09 Suspended Floors (SF) Dismantle 24 Dismantling of Suspended Floors (DSF) from 22.01 m up to 24.00 m DSF-09
DSF-10 Suspended Floors (SF) Dismantle 26 Dismantling of Suspended Floors (DSF) from 24.01 m up to 26.00 m DSF-10
DSF-11 Suspended Floors (SF) Dismantle 28 Dismantling of Suspended Floors (DSF) from 26.01 m up to 28.00 m DSF-11
DSF-12 Suspended Floors (SF) Dismantle 30 Dismantling of Suspended Floors (DSF) from 28.01 m up to 30.00 m DSF-12
DSF-13 Suspended Floors (SF) Dismantle 32 Dismantling of Suspended Floors (DSF) from 30.01 m up to 32.00 m DSF-13
DSF-14 Suspended Floors (SF) Dismantle 34 Dismantling of Suspended Floors (DSF) from 32.01 m up to 34.00 m DSF-14
DSF-15 Suspended Floors (SF) Dismantle 36 Dismantling of Suspended Floors (DSF) from 34.01 m up to 36.00 m DSF-15
DSF-16 Suspended Floors (SF) Dismantle 38 Dismantling of Suspended Floors (DSF) from 36.01 m up to 38.00 m DSF-16
DSF-17 Suspended Floors (SF) Dismantle 40 Dismantling of Suspended Floors (DSF) from 38.01 m up to 40.00 m DSF-17
DSF-18 Suspended Floors (SF) Dismantle 42 Dismantling of Suspended Floors (DSF) from 40.01 m up to 42.00 m DSF-18
DSF-19 Suspended Floors (SF) Dismantle 44 Dismantling of Suspended Floors (DSF) from 42.01 m up to 44.00 m DSF-19
DSF-20 Suspended Floors (SF) Dismantle 46 Dismantling of Suspended Floors (DSF) from 44.01 m up to 46.00 m DSF-20
DSF-21 Suspended Floors (SF) Dismantle 48 Dismantling of Suspended Floors (DSF) from 46.01 m up to 48.00 m DSF-21
DSF-22 Suspended Floors (SF) Dismantle 50 Dismantling of Suspended Floors (DSF) from 48.01 m up to 50.00 m DSF-22
DSF-23 Suspended Floors (SF) Dismantle 51 Dismantling of Suspended Floors (DSF) above 50 m DSF-23
EM Encapsulation Material (EM) EM
IEM-01 Encapsulation Material (EM) Install Installation of Encapsulation Material (IEM) (option, if necessary) IEM-01
EMR - 01 Encapsulation Material (EM) Rental 60 Installed Encapsulation Material (EMR) Rental Fee (option, if necessary) for duration till 60 days EMR - 01
EMR - 02 Encapsulation Material (EM) Rental 120 Installed Encapsulation Material (EMR) Rental Fee (option, if necessary) for duration from 61 till 120 days EMR - 02
EMR - 03 Encapsulation Material (EM) Rental 121 Installed Encapsulation Material (EMR) Rental Fee (option, if necessary) for duration above 120 days EMR - 03
DEM-01 Encapsulation Material (EM) Dismantle Dismantling of Encapsulation Material (DEM) (option, if necessary) DEM-01
RS Roof Structures (RS) RS
IRS-01 Roof Structures (RS) Install Installation of Roof Structures (IRS) (option, if necessary) IRS-01
RSDR-01 Roof Structures (RS) Rental 60 Installed Roof Structures Daily Rental fee (RSDR) (option, if necessary) for duration till 60 days RSDR-01
RSDR-02 Roof Structures (RS) Rental 120 Installed Roof Structures Daily Rental fee (RSDR) (option, if necessary) for duration from 61 till 120 days RSDR-02
RSDR-03 Roof Structures (RS) Rental 121 Installed Roof Structures Daily Rental fee (RSDR) (option, if necessary) for duration above 120 days RSDR-03
DRS-01 Roof Structures (RS) Dismantle Dismantling of Roof Structures (DRS) (option, if necessary) DRS-01
TS Tower Structures (TS) TS
ITS-01 Tower Structures (TS) Install 6 Installation of Tower Structures (ITS) from ground up to 6.00 m ITS-01
ITS-02 Tower Structures (TS) Install 8 Installation of Tower Structures (ITS) from 6.01 m up to 8.00 m ITS-02
ITS-03 Tower Structures (TS) Install 10 Installation of Tower Structures (ITS) from 8.01 m up to 10.00 m ITS-03
ITS-04 Tower Structures (TS) Install 12 Installation of Tower Structures (ITS) from 10.01 m up to 12.00 m ITS-04
ITS-05 Tower Structures (TS) Install 14 Installation of Tower Structures (ITS) from 12.01 m up to 14.00 m ITS-05
ITS-06 Tower Structures (TS) Install 16 Installation of Tower Structures (ITS) from 14.01 m up to 16.00 m ITS-06
ITS-07 Tower Structures (TS) Install 18 Installation of Tower Structures (ITS) from 16.01 m up to 18.00 m ITS-07
ITS-08 Tower Structures (TS) Install 20 Installation of Tower Structures (ITS) from 18.01 m up to 20.00 m ITS-08
ITS-09 Tower Structures (TS) Install 22 Installation of Tower Structures (ITS) from 20.01 m up to 22.00 m ITS-09
ITS-10 Tower Structures (TS) Install 24 Installation of Tower Structures (ITS) from 22.01 m up to 24.00 m ITS-10
ITS-11 Tower Structures (TS) Install 26 Installation of Tower Structures (ITS) from 24.01 m up to 26.00 m ITS-11
ITS-12 Tower Structures (TS) Install 28 Installation of Tower Structures (ITS) from 26.01 m up to 28.00 m ITS-12
ITS-13 Tower Structures (TS) Install 30 Installation of Tower Structures (ITS) from 28.01 m up to 30.00 m ITS-13
ITS-14 Tower Structures (TS) Install 32 Installation of Tower Structures (ITS) from 30.01 m up to 32.00 m ITS-14
ITS-15 Tower Structures (TS) Install 34 Installation of Tower Structures (ITS) from 32.01 m up to 34.00 m ITS-15
ITS-16 Tower Structures (TS) Install 36 Installation of Tower Structures (ITS) from 34.01 m up to 36.00 m ITS-16
ITS-17 Tower Structures (TS) Install 38 Installation of Tower Structures (ITS) from 36.01 m up to 38.00 m ITS-17
ITS-18 Tower Structures (TS) Install 40 Installation of Tower Structures (ITS) from 38.01 m up to 40.00 m ITS-18
ITS-19 Tower Structures (TS) Install 42 Installation of Tower Structures (ITS) from 40.01 m up to 42.00 m ITS-19
ITS-20 Tower Structures (TS) Install 44 Installation of Tower Structures (ITS) from 42.01 m up to 44.00 m ITS-20
ITS-21 Tower Structures (TS) Install 46 Installation of Tower Structures (ITS) from 44.01 m up to 46.00 m ITS-21
ITS-22 Tower Structures (TS) Install 48 Installation of Tower Structures (ITS) from 46.01 m up to 48.00 m ITS-22
ITS-23 Tower Structures (TS) Install 50 Installation of Tower Structures (ITS) from 48.01 m up to 50.00 m ITS-23
ITS-24 Tower Structures (TS) Install 51 Installation of Tower Structures (ITS) above 50 m ITS-24
TSDR-01 Tower Structures (TS) Rental 60 Installed Tower Structures Daily Rental fee (TSDR) (option, if necessary) for duration till 60 days TSDR-01
TSDR-02 Tower Structures (TS) Rental 120 Installed Tower Structures Daily Rental fee (TSDR) (option, if necessary) for duration from 61 till 120 days TSDR-02
TSDR-03 Tower Structures (TS) Rental 121 Installed Tower Structures Daily Rental fee (TSDR) (option, if necessary) for duration above 120 days TSDR-03
DTS-01 Tower Structures (TS) Dismantle 6 Dismantling of Tower Structures (DTS) from ground up to 6.00 m DTS-01
DTS-02 Tower Structures (TS) Dismantle 8 Dismantling of Tower Structures (DTS) from 6.01 m up to 8.00 m DTS-02
DTS-03 Tower Structures (TS) Dismantle 10 Dismantling of Tower Structures (DTS) from 8.01 m up to 10.00 m DTS-03
DTS-04 Tower Structures (TS) Dismantle 12 Dismantling of Tower Structures (DTS) from 10.01 m up to 12.00 m DTS-04
DTS-05 Tower Structures (TS) Dismantle 14 Dismantling of Tower Structures (DTS) from 12.01 m up to 14.00 m DTS-05
DTS-06 Tower Structures (TS) Dismantle 16 Dismantling of Tower Structures (DTS) from 14.01 m up to 16.00 m DTS-06
DTS-07 Tower Structures (TS) Dismantle 18 Dismantling of Tower Structures (DTS) from 16.01 m up to 18.00 m DTS-07
DTS-08 Tower Structures (TS) Dismantle 20 Dismantling of Tower Structures (DTS) from 18.01 m up to 20.00 m DTS-08
DTS-09 Tower Structures (TS) Dismantle 22 Dismantling of Tower Structures (DTS) from 20.01 m up to 22.00 m DTS-09
DTS-10 Tower Structures (TS) Dismantle 24 Dismantling of Tower Structures (DTS) from 22.01 m up to 24.00 m DTS-10
DTS-11 Tower Structures (TS) Dismantle 26 Dismantling of Tower Structures (DTS) from 24.01 m up to 26.00 m DTS-11
DTS-12 Tower Structures (TS) Dismantle 28 Dismantling of Tower Structures (DTS) from 26.01 m up to 28.00 m DTS-12
DTS-13 Tower Structures (TS) Dismantle 30 Dismantling of Tower Structures (DTS) from 28.01 m up to 30.00 m DTS-13
DTS-14 Tower Structures (TS) Dismantle 32 Dismantling of Tower Structures (DTS) from 30.01 m up to 32.00 m DTS-14
DTS-15 Tower Structures (TS) Dismantle 34 Dismantling of Tower Structures (DTS) from 32.01 m up to 34.00 m DTS-15
DTS-16 Tower Structures (TS) Dismantle 36 Dismantling of Tower Structures (DTS) from 34.01 m up to 36.00 m DTS-16
DTS-17 Tower Structures (TS) Dismantle 38 Dismantling of Tower Structures (DTS) from 36.01 m up to 38.00 m DTS-17
DTS-18 Tower Structures (TS) Dismantle 40 Dismantling of Tower Structures (DTS) from 38.01 m up to 40.00 m DTS-18
DTS-19 Tower Structures (TS) Dismantle 42 Dismantling of Tower Structures (DTS) from 40.01 m up to 42.00 m DTS-19
DTS-20 Tower Structures (TS) Dismantle 44 Dismantling of Tower Structures (DTS) from 42.01 m up to 44.00 m DTS-20
DTS-21 Tower Structures (TS) Dismantle 46 Dismantling of Tower Structures (DTS) from 44.01 m up to 46.00 m DTS-21
DTS-22 Tower Structures (TS) Dismantle 48 Dismantling of Tower Structures (DTS) from 46.01 m up to 48.00 m DTS-22
DTS-23 Tower Structures (TS) Dismantle 50 Dismantling of Tower Structures (DTS) from 48.01 m up to 50.00 m DTS-23
DTS-24 Tower Structures (TS) Dismantle 51 Dismantling of Tower Structures (DTS) above 50 m DTS-24
BC Birdcages (IBC) BC
IBC-01 Birdcages (IBC) Install 6 Installation of Birdcages (IBC) from ground up to 6.00 m IBC-01
IBC-02 Birdcages (IBC) Install 8 Installation of Birdcages (IBC) from 6.01 m up to 8.00 m IBC-02
IBC-03 Birdcages (IBC) Install 10 Installation of Birdcages (IBC) from 8.01 m up to 10.00 m IBC-03
IBC-04 Birdcages (IBC) Install 12 Installation of Birdcages (IBC) from 10.01 m up to 12.00 m IBC-04
IBC-05 Birdcages (IBC) Install 14 Installation of Birdcages (IBC) from 12.01 m up to 14.00 m IBC-05
IBC-06 Birdcages (IBC) Install 16 Installation of Birdcages (IBC) from 14.01 m up to 16.00 m IBC-06
IBC-07 Birdcages (IBC) Install 18 Installation of Birdcages (IBC) from 16.01 m up to 18.00 m IBC-07
IBC-08 Birdcages (IBC) Install 20 Installation of Birdcages (IBC) from 18.01 m up to 20.00 m IBC-08
IBC-09 Birdcages (IBC) Install 22 Installation of Birdcages (IBC) from 20.01 m up to 22.00 m IBC-09
IBC-10 Birdcages (IBC) Install 24 Installation of Birdcages (IBC) from 22.01 m up to 24.00 m IBC-10
IBC-11 Birdcages (IBC) Install 26 Installation of Birdcages (IBC) from 24.01 m up to 26.00 m IBC-11
IBC-12 Birdcages (IBC) Install 28 Installation of Birdcages (IBC) from 26.01 m up to 28.00 m IBC-12
IBC-13 Birdcages (IBC) Install 30 Installation of Birdcages (IBC) from 28.01 m up to 30.00 m IBC-13
IBC-14 Birdcages (IBC) Install 32 Installation of Birdcages (IBC) from 30.01 m up to 32.00 m IBC-14
IBC-15 Birdcages (IBC) Install 34 Installation of Birdcages (IBC) from 32.01 m up to 34.00 m IBC-15
IBC-16 Birdcages (IBC) Install 36 Installation of Birdcages (IBC) from 34.01 m up to 36.00 m IBC-16
IBC-17 Birdcages (IBC) Install 38 Installation of Birdcages (IBC) from 36.01 m up to 38.00 m IBC-17
IBC-18 Birdcages (IBC) Install 40 Installation of Birdcages (IBC) from 38.01 m up to 40.00 m IBC-18
IBC-19 Birdcages (IBC) Install 42 Installation of Birdcages (IBC) from 40.01 m up to 42.00 m IBC-19
IBC-20 Birdcages (IBC) Install 44 Installation of Birdcages (IBC) from 42.01 m up to 44.00 m IBC-20
IBC-21 Birdcages (IBC) Install 46 Installation of Birdcages (IBC) from 44.01 m up to 46.00 m IBC-21
IBC-22 Birdcages (IBC) Install 48 Installation of Birdcages (IBC) from 46.01 m up to 48.00 m IBC-22
IBC-23 Birdcages (IBC) Install 50 Installation of Birdcages (IBC) from 48.01 m up to 50.00 m IBC-23
IBC-24 Birdcages (IBC) Install 51 Installation of Birdcages (IBC) above 50 m IBC-24
BCDR-01 Birdcages (IBC) Rental 60 Installed Birdcages Daily Rental (BCDR) for duration till 60 days BCDR-01
BCDR-02 Birdcages (IBC) Rental 120 Installed Birdcages Daily Rental (BCDR) for duration from 61 till 120 days BCDR-02
BCDR-03 Birdcages (IBC) Rental 121 Installed Birdcages Daily Rental (BCDR) for duration above 120 days BCDR-03
DBC-01 Birdcages (IBC) Dismantle 6 Dismantling of Birdcages (DBC) from ground up to 6.00 m DBC-01
DBC-02 Birdcages (IBC) Dismantle 8 Dismantling of Birdcages (DBC) from 6.01 m up to 8.00 m DBC-02
DBC-03 Birdcages (IBC) Dismantle 10 Dismantling of Birdcages (DBC) from 8.01 m up to 10.00 m DBC-03
DBC-04 Birdcages (IBC) Dismantle 12 Dismantling of Birdcages (DBC) from 10.01 m up to 12.00 m DBC-04
DBC-05 Birdcages (IBC) Dismantle 14 Dismantling of Birdcages (DBC) from 12.01 m up to 14.00 m DBC-05
DBC-06 Birdcages (IBC) Dismantle 16 Dismantling of Birdcages (DBC) from 14.01 m up to 16.00 m DBC-06
DBC-07 Birdcages (IBC) Dismantle 18 Dismantling of Birdcages (DBC) from 16.01 m up to 18.00 m DBC-07
DBC-08 Birdcages (IBC) Dismantle 20 Dismantling of Birdcages (DBC) from 18.01 m up to 20.00 m DBC-08
DBC-09 Birdcages (IBC) Dismantle 22 Dismantling of Birdcages (DBC) from 20.01 m up to 22.00 m DBC-09
DBC-10 Birdcages (IBC) Dismantle 24 Dismantling of Birdcages (DBC) from 22.01 m up to 24.00 m DBC-10
DBC-11 Birdcages (IBC) Dismantle 26 Dismantling of Birdcages (DBC) from 24.01 m up to 26.00 m DBC-11
DBC-12 Birdcages (IBC) Dismantle 28 Dismantling of Birdcages (DBC) from 26.01 m up to 28.00 m DBC-12
DBC-13 Birdcages (IBC) Dismantle 30 Dismantling of Birdcages (DBC) from 28.01 m up to 30.00 m DBC-13
DBC-14 Birdcages (IBC) Dismantle 32 Dismantling of Birdcages (DBC) from 30.01 m up to 32.00 m DBC-14
DBC-15 Birdcages (IBC) Dismantle 34 Dismantling of Birdcages (DBC) from 32.01 m up to 34.00 m DBC-15
DBC-16 Birdcages (IBC) Dismantle 36 Dismantling of Birdcages (DBC) from 34.01 m up to 36.00 m DBC-16
DBC-17 Birdcages (IBC) Dismantle 38 Dismantling of Birdcages (DBC) from 36.01 m up to 38.00 m DBC-17
DBC-18 Birdcages (IBC) Dismantle 40 Dismantling of Birdcages (DBC) from 38.01 m up to 40.00 m DBC-18
DBC-19 Birdcages (IBC) Dismantle 42 Dismantling of Birdcages (DBC) from 40.01 m up to 42.00 m DBC-19
DBC-20 Birdcages (IBC) Dismantle 44 Dismantling of Birdcages (DBC) from 42.01 m up to 44.00 m DBC-20
DBC-21 Birdcages (IBC) Dismantle 46 Dismantling of Birdcages (DBC) from 44.01 m up to 46.00 m DBC-21
DBC-22 Birdcages (IBC) Dismantle 48 Dismantling of Birdcages (DBC) from 46.01 m up to 48.00 m DBC-22
DBC-23 Birdcages (IBC) Dismantle 50 Dismantling of Birdcages (DBC) from 48.01 m up to 50.00 m DBC-23
DBC-24 Birdcages (IBC) Dismantle 51 Dismantling of Birdcages (DBC) above 50 m DBC-24
HB Hanging Birdcages (IHBC) HB
IHBC-01 Hanging Birdcages (IHBC) Install 2 Installation of Hanging Birdcages (IHBC) from structure down to 2.00 m IHBC-01
IHBC-02 Hanging Birdcages (IHBC) Install 4 Installation of Hanging Birdcages (IHBC) from structure down from to 2.01 m to 4.00 m IHBC-02
IHBC-03 Hanging Birdcages (IHBC) Install 6 Installation of Hanging Birdcages (IHBC) from structure down from to 4.01 m to 6.00 m IHBC-03
HBCDR-01 Hanging Birdcages (IHBC) Rental 60 Installed Hanging Birdcages Daily Rental (HBCDR) for duration till 60 days HBCDR-01
HBCDR-02 Hanging Birdcages (IHBC) Rental 120 Installed Hanging Birdcages Daily Rental (HBCDR) for duration from 61 till 120 days HBCDR-02
HBCDR-03 Hanging Birdcages (IHBC) Rental 121 Installed Hanging Birdcages Daily Rental (HBCDR) for duration above 120 days HBCDR-03
DHBC-01 Hanging Birdcages (IHBC) Dismantle 2 Dismantling of Hanging Birdcages (DHBC) from structure down to 2.00 m DHBC-01
DHBC-02 Hanging Birdcages (IHBC) Dismantle 6 Dismantling of Hanging Birdcages (DHBC) from structure down from to 2.01 m to 4.00 m DHBC-02
DHBC-03 Hanging Birdcages (IHBC) Dismantle 6 Dismantling of Hanging Birdcages (DHBC) from structure down from to 4.01 m to 6.00 m DHBC-03
IN Indipendents (IN) IN
IIN-01 Independents (IN) Install 6 Installation of Independents (IIN) from ground up to 6.00 m IIN-01
IIN-02 Independents (IN) Install 8 Installation of Independents (IIN) from 6.01 m up to 8.00 m IIN-02
IIN-03 Independents (IN) Install 10 Installation of Independents (IIN) from 8.01 m up to 10.00 m IIN-03
IIN-04 Independents (IN) Install 12 Installation of Independents (IIN) from 10.01 m up to 12.00 m IIN-04
IIN-05 Independents (IN) Install 14 Installation of Independents (IIN) from 12.01 m up to 14.00 m IIN-05
IIN-06 Independents (IN) Install 16 Installation of Independents (IIN) from 14.01 m up to 16.00 m IIN-06
IIN-07 Independents (IN) Install 18 Installation of Independents (IIN) from 16.01 m up to 18.00 m IIN-07
IIN-08 Independents (IN) Install 20 Installation of Independents (IIN) from 18.01 m up to 20.00 m IIN-08
IIN-09 Independents (IN) Install 22 Installation of Independents (IIN) from 20.01 m up to 22.00 m IIN-09
IIN-10 Independents (IN) Install 24 Installation of Independents (IIN) from 22.01 m up to 24.00 m IIN-10
IIN-11 Independents (IN) Install 26 Installation of Independents (IIN) from 24.01 m up to 26.00 m IIN-11
IIN-12 Independents (IN) Install 28 Installation of Independents (IIN) from 26.01 m up to 28.00 m IIN-12
IIN-13 Independents (IN) Install 30 Installation of Independents (IIN) from 28.01 m up to 30.00 m IIN-13
IIN-14 Independents (IN) Install 32 Installation of Independents (IIN) from 30.01 m up to 32.00 m IIN-14
IIN-15 Independents (IN) Install 34 Installation of Independents (IIN) from 32.01 m up to 34.00 m IIN-15
IIN-16 Independents (IN) Install 36 Installation of Independents (IIN) from 34.01 m up to 36.00 m IIN-16
IIN-17 Independents (IN) Install 38 Installation of Independents (IIN) from 36.01 m up to 38.00 m IIN-17
IIN-18 Independents (IN) Install 40 Installation of Independents (IIN) from 38.01 m up to 40.00 m IIN-18
IIN-19 Independents (IN) Install 42 Installation of Independents (IIN) from 40.01 m up to 42.00 m IIN-19
IIN-20 Independents (IN) Install 44 Installation of Independents (IIN) from 42.01 m up to 44.00 m IIN-20
IIN-21 Independents (IN) Install 46 Installation of Independents (IIN) from 44.01 m up to 46.00 m IIN-21
IIN-22 Independents (IN) Install 48 Installation of Independents (IIN) from 46.01 m up to 48.00 m IIN-22
IIN-23 Independents (IN) Install 50 Installation of Independents (IIN) from 48.01 m up to 50.00 m IIN-23
IIN-24 Independents (IN) Install 51 Installation of Independents (IIN) above 50 m IIN-24
INDR-01 Independents (IN) Rental 60 Installed Independents Daily Rental (INDR) for duration till 60 days INDR-01
INDR-02 Independents (IN) Rental 120 Installed Independents Daily Rental (INDR) for duration from 61 till 120 days INDR-02
INDR-03 Independents (IN) Rental 121 Installed Independents Daily Rental (INDR) for duration above 120 days INDR-03
DIN-01 Independents (IN) Dismantle 6 Dismantling of Independents (DIN) from ground up to 6.00 m DIN-01
DIN-02 Independents (IN) Dismantle 8 Dismantling of Independents (DIN) from 6.01 m up to 8.00 m DIN-02
DIN-03 Independents (IN) Dismantle 10 Dismantling of Independents (DIN) from 8.01 m up to 10.00 m DIN-03
DIN-04 Independents (IN) Dismantle 12 Dismantling of Independents (DIN) from 10.01 m up to 12.00 m DIN-04
DIN-05 Independents (IN) Dismantle 14 Dismantling of Independents (DIN) from 12.01 m up to 14.00 m DIN-05
DIN-06 Independents (IN) Dismantle 16 Dismantling of Independents (DIN) from 14.01 m up to 16.00 m DIN-06
DIN-07 Independents (IN) Dismantle 18 Dismantling of Independents (DIN) from 16.01 m up to 18.00 m DIN-07
DIN-08 Independents (IN) Dismantle 20 Dismantling of Independents (DIN) from 18.01 m up to 20.00 m DIN-08
DIN-09 Independents (IN) Dismantle 22 Dismantling of Independents (DIN) from 20.01 m up to 22.00 m DIN-09
DIN-10 Independents (IN) Dismantle 24 Dismantling of Independents (DIN) from 22.01 m up to 24.00 m DIN-10
DIN-11 Independents (IN) Dismantle 26 Dismantling of Independents (DIN) from 24.01 m up to 26.00 m DIN-11
DIN-12 Independents (IN) Dismantle 28 Dismantling of Independents (DIN) from 26.01 m up to 28.00 m DIN-12
DIN-13 Independents (IN) Dismantle 30 Dismantling of Independents (DIN) from 28.01 m up to 30.00 m DIN-13
DIN-14 Independents (IN) Dismantle 32 Dismantling of Independents (DIN) from 30.01 m up to 32.00 m DIN-14
DIN-15 Independents (IN) Dismantle 34 Dismantling of Independents (DIN) from 32.01 m up to 34.00 m DIN-15
DIN-16 Independents (IN) Dismantle 36 Dismantling of Independents (DIN) from 34.01 m up to 36.00 m DIN-16
DIN-17 Independents (IN) Dismantle 38 Dismantling of Independents (DIN) from 36.01 m up to 38.00 m DIN-17
DIN-18 Independents (IN) Dismantle 40 Dismantling of Independents (DIN) from 38.01 m up to 40.00 m DIN-18
DIN-19 Independents (IN) Dismantle 42 Dismantling of Independents (DIN) from 40.01 m up to 42.00 m DIN-19
DIN-20 Independents (IN) Dismantle 44 Dismantling of Independents (DIN) from 42.01 m up to 44.00 m DIN-20
DIN-21 Independents (IN) Dismantle 46 Dismantling of Independents (DIN) from 44.01 m up to 46.00 m DIN-21
DIN-22 Independents (IN) Dismantle 48 Dismantling of Independents (DIN) from 46.01 m up to 48.00 m DIN-22
DIN-23 Independents (IN) Dismantle 50 Dismantling of Independents (DIN) from 48.01 m up to 50.00 m DIN-23
DIN-24 Independents (IN) Dismantle 51 Dismantling of Independents (DIN) above 50 m DIN-24
HI Hanging Indipendents (HI) HI
IHIN-01 Hanging Indipendents (HI) Install Installation of Hanging Independents (IHIN) from structure down to 2.00 m IHIN-01
IHIN-02 Hanging Indipendents (HI) Install Installation of Hanging Independents (IHIN) from structure down from 2.01 m to 4.00 m IHIN-02
IHIN-03 Hanging Indipendents (HI) Install Installation of Hanging Independents (IHIN) from structure down from 4.01 m to 6.00 m IHIN-03
HINDR-01 Hanging Indipendents (HI) Rental 60 Installed Hanging Independents Daily Rental (HINDR) for duration till 60 days HINDR-01
HINDR-02 Hanging Indipendents (HI) Rental 120 Installed Hanging Independents Daily Rental (HINDR) for duration from 61 till 120 days HINDR-02
HINDR-03 Hanging Indipendents (HI) Rental 121 Installed Hanging Independents Daily Rental (HINDR) for duration above 120 days HINDR-03
DHIN-01 Hanging Indipendents (HI) Dismantle Dismantling of Hanging Independents (DHIN) from structure down to 2.00 m DHIN-01
DHIN-02 Hanging Indipendents (HI) Dismantle Dismantling of Hanging Independents (DHIN) from structure down from 2.01 m to 4.00 m DHIN-02
DHIN-03 Hanging Indipendents (HI) Dismantle Dismantling of Hanging Independents (DHIN) from structure down from 4.01 m to 6.00 m DHIN-03
HT Hanging Tower (HT) HT
IHTS-01 Hanging Tower (HT) Install Installation of Hanging Tower Structure (IHTS) drop from structure down to 2.00 m IHTS-01
IHTS-02 Hanging Tower (HT) Install Installation of Hanging Tower Structure (IHTS) drop from structure down from 2.01 m to 4.00 m IHTS-02
IHTS-03 Hanging Tower (HT) Install Installation of Hanging Tower Structure (IHTS) drop from structure down from 4.01 m to 6.00 m IHTS-03
HTSDR-01 Hanging Tower (HT) Rental 60 Installed Hanging Tower Structure Daily Rental fee (HTSDR) for duration till 60 days HTSDR-01
HTSDR-02 Hanging Tower (HT) Rental 130 Installed Hanging Tower Structure Daily Rental fee (HTSDR) for duration from 61 till 120 days HTSDR-02
HTSDR-03 Hanging Tower (HT) Rental 121 Installed Hanging Tower Structure Daily Rental fee (HTSDR) for duration above 120 days HTSDR-03
DHTS-01 Hanging Tower (HT) Dismantle Dismantling of Hanging Tower Structure (IHTS) drop from structure down to 2.00 m DHTS-01
DHTS-02 Hanging Tower (HT) Dismantle Dismantling of Hanging Tower Structure (IHTS) drop from structure down from 2.01 m to 4.00 m DHTS-02
DHTS-03 Hanging Tower (HT) Dismantle Dismantling of Hanging Tower Structure (IHTS) drop from structure down from 4.01 m to 6.00 m DHTS-03
CP Cantilever Platforms (ICP) CP
ICP-01 Cantilever Platforms (ICP) Install Installation of Cantilever Platforms (ICP) ICP-01
" CSDR-01" Cantilever Platforms (ICP) Rental 60 Installed Cantilever Platforms Daily Rental (CPDR) for duration till 60 days " CSDR-01"
" CSDR-02" Cantilever Platforms (ICP) Rental 120 Installed Cantilever Platforms Daily Rental (CPDR) for duration from 61 till 120 days " CSDR-02"
" CSDR-03" Cantilever Platforms (ICP) Rental 121 Installed Cantilever Platforms Daily Rental (CPDR) for duration above 120 days " CSDR-03"
DCS-01 Cantilever Platforms (ICP) Dismantle Dismantling of Cantilever Platforms (DCP) DCS-01
 
Upvote 0
Please give me an example (not the entire data set), of the Retreival Criteria and an expected output.
Are you asking to see the entire row, do you just want the entire string returned or do you want it parsed out?
 
Upvote 0
Are each of those items in 1 cell or is it multiple columns? If so, can you at the very least copy and paste it from Excel so we can see how the columns break?
 
Upvote 0
Dear Sir,
Actually sir in excel it is like that, each item in one column in excel, although I cannot insert the excel worksheet in here.
Example below, the given height is 2.01 and the result will be 6, because 2.01 is in the height range of 0-6 in which the height type is 6, so the result is 6
and also there are category starts to 2 and also start to 6.


Item Type Height Type Height Range Description Given height Result
ST-01 Stair Towers (ST) 6 0-6 Installation of Stair Towers (IST) from ground up to 6.00 m 2.01 6
 
Upvote 0
So, this is all in A2?
ST-01 Stair Towers (ST) 6 0-6 Installation of Stair Towers (IST) from ground up to 6.00 m 2.01 6

You have what looks like column headers, but they don't line up to anything?
 
Upvote 0
Scott Huish said:
Are each of those items in 1 cell or is it multiple columns? If so, can you at the very least copy and paste it from Excel so we can see how the columns break?
Click to expand...


it is in multiple column sir, not in one cell, because I dont know how to put exactly in this page
 
Upvote 0
Scott Huish said:
So, this is all in A2?
ST-01 Stair Towers (ST) 6 0-6 Installation of Stair Towers (IST) from ground up to 6.00 m 2.01 6

You have what looks like column headers, but they don't line up to anything?
Click to expand...

Yes sir, it is in each column, because I dont know how to paste it in here the way it is exactly in my excel sheets Example

Each Items are in one column the header is the item no. and IST-01 is belongs to that item, Type is the header and Stair Towers (ST) is under of that, etc.

Item No.
IST-01

Type
Stair Towers (ST)

Height Type
6

Height range
0-6

DESCRIPTION
Installation of Stair Towers (IST) from ground up to 6.00 m
 
Upvote 0
Ac
Scott Huish said:
Are each of those items in 1 cell or is it multiple columns? If so, can you at the very least copy and paste it from Excel so we can see how the columns break?
Click to expand...

actually sir, i copied this in excel format, but when I paste it in here it becomes like that, no column and appears it come altogether in one line, but in my excel file it is in each column each category, I dont know how to copy my excel file here with the same format.
 
Upvote 0
You must log in or register to reply here.

Forum statistics

Threads
1,224,755
Messages
6,180,751
Members
452,996
Latest member
nelsonsix66

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top