Forum Discussion
Architect77
Apr 04, 2023Copper Contributor
Storage required area within a project Period
Hi all, I'm trying to calculate the peak required area for storage when i have the dates of all materials entry and exit dates. Can excel help calculating the peak required area after entering area...
- Apr 08, 2023
Does this do what you want?
Architect77
Apr 08, 2023Copper Contributor
HansVogelaar
Apr 08, 2023MVP
Does this do what you want?
- Architect77Apr 12, 2023Copper ContributorYou made my day, thank you loads 🙂
- HansVogelaarApr 11, 2023MVP
I see what went wrong. Here is an improved version.
- Architect77Apr 11, 2023Copper Contributor
I didn't expect you to fully do it. I'm more than appreciative.
It perfectly does. I tried to update it though with all information and I failed as it gave me negative values.
is it ok, if it includes all the following:
SI # Item Description Quantity Material Arrival to site Completion Period 4 Waterproofing - External & Roof waterproofing & Tile spacers for roof tiles (pavers) 400 20-Dec-22 31-May-23 162 6 Plastering Work - Internal & External 400 15-Dec-22 22-May-23 158 7 Ceiling and Partition Works 800 30-Mar-23 9-Aug-23 132 8 Pigmented Screed + Concrete skirting 400 11-May-23 23-Aug-23 104 10 Epoxy Flooring 20 25-May-23 23-Aug-23 90 11 Terrazzo Flooring 80 25-May-23 23-Aug-23 90 12 Vinyl, Carpet 80 25-Jun-23 18-Sep-23 85 13 Raised Floor 20 25-Jun-23 18-Sep-23 85 14 Painting Work - Internal & External 40 26-Feb-23 10-Oct-23 226 15 Acoustic Wall Panel work 40 6-Aug-23 19-Oct-23 74 16 Movable Foldable Partition 40 17-Jul-23 2-Oct-23 77 18 Toilet Cubicles 40 27-Aug-23 28-Nov-23 93 21 Aluminum and Glazing works 500 8-May-23 27-Dec-23 233 23 Carpentry and Joinery works 400 16-Jul-23 5-Dec-23 142 24 Steel Doors 200 31-Jul-23 12-Dec-23 134 26 Glass Balustrades & Handrails, Glass partitions & shower 20 16-May-23 2-Jan-24 231 27 Stone works (Marble/Granite) + BOH Vanity counters 250 14-Jun-23 18-Dec-23 187 28 Metal works (Handrail, ladder, hatch etc.) 200 30-Jun-23 2-Aug-23 33 31 External Furniture (Fire bowl & pit, shower, Valet stand, Pool cabana, towel station, foot wash) 200 21-Mar-23 11-Apr-23 21 41 Kitchen and Laundry Equipment 1000 17-Jul-23 28-Sep-23 73 42 Loose Furniture 200 2-Aug-23 5-Nov-23 95 63 Porcelain Tiles & Tile adhesive/ Glue 100 21-May-23 28-Aug-23 99 75 Ironmongery (Wooden & Steel Door) 400 26-Jul-23 17-Dec-23 144 82 Sanitary Fittings- Excluded from M/s Osco 100 7-Jun-23 26-Sep-23 111 86 Deductible warning tape 20 13-Jun-23 19-Oct-23 128 87 Lighting Fixtures 200 14-Jun-23 20-Oct-23 128