Skip to content

Commit 8728387

Browse files
maxfb87maxfb87
committed
Add simple examples for ifc5d import from csv
1 parent 584d37d commit 8728387

8 files changed

Lines changed: 72 additions & 1 deletion

‎src/ifc5d/Ex1 - BoQ without query.csv‎

Lines changed: 10 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,10 @@
1+
Index,Identification,Name,Unit,Value,Quantity
2+
1,E.01,Walls,m3,,
3+
2,E.01.01,Ground floor walls,m3,100,42
4+
2,E.01.02,First floor walls,m3,200,35
5+
1,A.02,Paintings,m2,,
6+
2,A.03,Paintings with water,m2,,
7+
3,B.05,White paintings,m2,25,45
8+
3,B.06,Colored paintings,m2,32,33
9+
2,C-01,Paintings with machine,m2,17,133
10+
2,C-02,Decorated paintings,m2,40,8

‎src/ifc5d/Ex2 - SoR.csv‎

Lines changed: 7 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,7 @@
1+
Index,Identification,Name,Unit,Value,Quantity
2+
1,A,Group A,,,
3+
2,A.02,Paintings,m2,20,1
4+
2,A.03,Paintings with water,m2,23,1
5+
1,C,Group C,,,
6+
2,C-01,Paintings with machine,m2,32,1
7+
2,C-02,Decorated paintings,m2,40,2

‎src/ifc5d/Ex3 - BoQ with query.csv‎

Lines changed: 10 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,10 @@
1+
Index,Identification,Name,Unit,Value,Quantity,Query,Property
2+
1,E.01,Walls,m3,,,,
3+
2,E.01.01,Ground floor walls,m3,100,,"IfcWall, location=""Ground Floor""",GrossVolume
4+
2,E.01.02,First floor walls,m3,200,,"IfcWall, location=""First Floor""",GrossVolume
5+
1,A.02,Paintings,m2,,,,
6+
2,A.03,Paintings with water,m2,,,,
7+
3,B.05,White paintings,m2,25,45,,
8+
3,B.06,Colored paintings,m2,32,33,,
9+
2,C-01,Paintings with machine,m2,17,133,,
10+
2,C-02,Decorated paintings,m2,40,8,,

‎src/ifc5d/Ex4 - BoQ with description.csv‎

Lines changed: 10 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,10 @@
1+
Index,Identification,Name,Unit,Value,Quantity,Description
2+
1,E.01,Walls,m3,,,
3+
2,E.01.01,Ground floor walls,m3,100,42,"Semi-solid blocks of plain-faced common brick, with an apparent density (excluding holes) of 800 kg/m³; minor drilling 45%; apparent thermal conductivity 0.21 W/mK; characteristic mechanical strength parallel to the holes greater than or equal to 10 N/mm2, perpendicular to the holes greater than or equal to 2N/mm2"
4+
2,E.01.02,First floor walls,m3,200,35,"Semi-solid blocks of plain-faced common brick, with an apparent density (excluding holes) of 800 kg/m³; minor drilling 45%; apparent thermal conductivity 0.21 W/mK; characteristic mechanical strength parallel to the holes greater than or equal to 10 N/mm2, perpendicular to the holes greater than or equal to 2N/mm2"
5+
1,A.02,Painting,m2,,,"Painting with washable water-based wall paint for indoor/outdoor. The price includes and compensates the costs for the supply of paint, any scaffolding up to a maximum height of 4 m from the support surface, the costs for the protection of furniture, fixed systems or the protection of floors, the cleaning of the surfaces to be treated through the use of rags or net purposes in order to remove residues that can be easily removed. The cost of occasional and partial grouting of surfaces, in order to eliminate any small scratches, including sanding of the grouted parts, is also to be considered included and compensated. For 2 coats with brush or roller."
6+
2,A.03,Washable painting,m2,,,"Supply and installation of washable tempera paint for interiors and exteriors. The price includes and compensates for the costs of supplying the paint, any scaffolding up to a maximum height of 4 meters from the support surface, the costs of protecting furnishings, fixed installations, or floors, and cleaning the surfaces to be treated using rags or clean brushes to remove easily removable residues. On previously prepared plaster. Apply two coats with a brush or roller. (Tempera colors from the color chart)."
7+
3,B.05,White paintings,m2,25,45,
8+
3,B.06,Colored paintings,m2,32,33,
9+
2,C-01,External painting,m2,17,133,"Painting with plastic coating. The price includes and compensates for the costs of supplying the paint, any scaffolding up to a maximum height of 4 meters from the support surface, the costs of protecting furnishings, fixed systems, or floors, and cleaning the surfaces to be treated using rags or clean brushes to remove easily removable residues. On already prepared plaster. For 2 coats (interior textured finish)."
10+
2,C-02,Decorated paintings,m2,40,8,

‎src/ifc5d/Ex5 - SoR_with_description.csv‎

Lines changed: 7 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,7 @@
1+
Index,Identification,Name,Unit,Value,Quantity,Description
2+
1,A,Group A,,,,
3+
2,A.02,Paintings,m2,20,1,Paint made by the best painter in the world
4+
2,A.03,Paintings with water,m2,23,1,
5+
1,C,Group C,,,,
6+
2,C-01,Paintings with machine,m2,32,1,Best painting in the world painted with the best painted machine accordingly with ISO9001
7+
2,C-02,Decorated paintings,m2,40,2,

‎src/ifc5d/Ex6 - BoQ with categories.csv‎

Lines changed: 10 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,10 @@
1+
Index,Identification,Name,Unit,Material,Labor,Quantity
2+
1,E.01,Walls,m3,,,
3+
2,E.01.01,Ground floor walls,m3,55,45,42
4+
2,E.01.02,First floor walls,m3,120,80,35
5+
1,A.02,Painting,m2,,,
6+
2,A.03,Washable painting,m2,,,
7+
3,B.05,White paintings,m2,,,45
8+
3,B.06,Colored paintings,m2,,,33
9+
2,C-01,External painting,m2,,,133
10+
2,C-02,Decorated paintings,m2,,,8

‎src/ifc5d/Ex7 - BoQ with Rates.csv‎

Lines changed: 10 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,10 @@
1+
Index,Identification,Name,Unit,Value,Quantity,RateSchedule,RateID
2+
1,E.01,Walls,m3,,,,
3+
2,E.01.01,Ground floor walls,m3,100,42,,
4+
2,E.01.02,First floor walls,m3,200,35,,
5+
1,A.02,Paintings,m2,,,,
6+
2,A.03,Paintings with water,m2,,,,
7+
3,B.05,White paintings,m2,,45,Ex2 - SoR,A.03
8+
3,B.06,Colored paintings,m2,32,33,,
9+
2,C-01,Paintings with machine,m2,17,133,,
10+
2,C-02,Decorated paintings,m2,40,8,,

‎src/ifc5d/README.md‎

Lines changed: 8 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -32,6 +32,13 @@ csv2ifc.execute()
3232
```
3333

3434
See example files as a CSV file format reference:
35+
- Ex1 - BoQ without query.csv (a simple Bill of Quantities)
36+
- Ex2 - SoR.csv (a simple Schedule of Rates)
37+
- Ex3 - BoQ with query.csv (a simple BoQ with the query function)
38+
- Ex4 - BoQ with description.csv (a simple BoQ with description column)
39+
- Ex5 - SoR_with_description.csv (a simple SoR with description column)
40+
- Ex6 - BoQ with categories.csv (a simple BoQ with categories columns)
41+
- Ex7 - BoQ with Rates.csv (a simple BoQ that connect to an existing SoR. It needs an already loaded SoR.)
3542
- `sample_cost_schedule_house_FR.csv` / `.ods`
3643
- `schedule.csv`, `rates.csv` (schedule of rates example)
3744

@@ -124,4 +131,4 @@ path = "directory/cost_schedule"
124131
writer = Ifc5DOdsWriter(file=file, output=path)
125132
writer.write()
126133
127-
```
134+
```

0 commit comments

Comments
 (0)