Freelance projects

Freelance projects

Calculation of pallet spaces and creation of a warehouse layout in Excel with occupancy calculation

Drawings & Diagrams, Project Management — incorrectly specified categories?

22 USD

Client's review of cooperation with Mihaylo Levko

Calculation of pallet spaces and creation of a warehouse layout in Excel with occupancy calculation

22 USD

Everything is clear, understandable, satisfied with the result.

4.9

Vladislav Kirillov

Reciprocal Feedback

11 August 2025

Freelancer's review of cooperation with Vladislav Kirillov

Calculation of pallet spaces and creation of a warehouse layout in Excel with occupancy calculation

22 USD

The client was constantly in touch, promptly provided all the necessary information, and actively participated in the process, which helped to implement the project effectively. I recommend for collaboration!

5.0

Mihaylo Levko

Reciprocal Feedback

11 August 2025

Project translated automatically. Log in or register, to view the original

Project Title

Calculation of pallet spaces and creation of warehouse layout in Excel with occupancy calculation

Task Description

It is necessary to create a detailed warehouse layout in Excel considering:
- actual dimensions of the zone according to the BTI plan (photo provided);
- logic of passages and placement of pallets;
- placement by brands (Beer / PПБ, Drinks / НН);
- density norms (filling coefficient by formula);
- automatic calculation of vacant / occupied pallet spaces for each zone.

The layout should include:
- a zone with a colored grid (as in the example);
- names of zones and brands;
- label of the number of pallet spaces in each zone;
- a bottom table for calculation: 'total PM / occupied / vacant / % occupancy'.

Result Format

- Excel file (.xlsx)
- Visual layout
- Summary table below the layout
- If necessary — a separate sheet with calculations/logic

Provided to the Contractor

- Photos of the BTI plan of the 1st and 2nd floors
- Excel grid with an example
- Preliminary calculation of PM by zones
- Filling coefficient
- Names of zones and brands
- Sample layout from the previous warehouse

- additional/clarifying information will be provided additionally

- possible interaction/partnership on a regular basis

Requirements

- Experience in creating layouts or visual schemes in Excel
- Ability to work with formulas
- Preferably: experience in logistics or understanding of warehouses
- Ability to strictly follow instructions and the example

Budget

Agreed — depending on experience and speed

Deadline

1–2 days

Applications5

XLSX

Планограмма ПФ.xlsx

32KB

Proposals 2 Rejected 1 Discussions 3

Dariia Zelinska

43 0

Budget: 8000 UAH Deadline: 1 day

Good day! I have been working in Excel for over 10 years, I have experience in creating similar planograms, calculations using formulas, conditional formatting, etc. I guarantee maximum efficiency - I can complete the work as quickly as possible, even within 1 day. Write to me privately, I will be happy to cooperate.

Mihaylo Levko

Winning proposal

5 0

Budget: 1000 UAH Deadline: 3 days

Good evening!
I haven't worked with logistics or warehousing before, but I am proficient in Excel and ready to implement the planogram in collaboration and communication — taking into account aisles, pallet sizes, zones, occupancy, etc.
I focus on quality because the result and my rating are important to me.
I am ready to start after agreeing on the details.

Dmitry P.

21 0

Budget: 20000 UAH Deadline: 2 days

Good morning, ready to perform the calculation of pallet spaces and create a warehouse layout in Excel with occupancy calculation. Feel free to contact me

Current freelance projects in the category Drawings & Diagrams

Technical assignment for the design of electrical supply for a residential building

Engineering 2 proposals 5 August

Not specified
Site layout plan scheme

Infographics 9 proposals 5 August

Not specified
3D model in ArchiCAD and facade design.

Architectural Design 10 proposals 3 August

156 USD
Manufacturing project

Interior Design 6 proposals 2 August

Not specified
Development of container manufacturing technology.

Object Design 11 proposals 30 July

224 USD

Vladislav Kirillov
Dnepr, Ukraine

Projects 3
Rating 5.0
Rating 282

Vladislav Kirillov

Mihaylo Levko

Dariia Zelinska

Mihaylo Levko

Proposals are currently absent

Dmitry P.

Current freelance projects in the category Drawings & Diagrams

Technical assignment for the design of electrical supply for a residential building

Site layout plan scheme

3D model in ArchiCAD and facade design.

Manufacturing project

Development of container manufacturing technology.