Create an excel workbook with Excel macros and calculations as described

Đã hoàn thành Đã đăng vào 6 năm trước Thanh toán khi bàn giao
Đã hoàn thành Thanh toán khi bàn giao

Summary

We need the services of someone to create a macro/automation that takes inputs from various tables in a sheet and fills in various calculation sheets from templates then summarises outputs of each calculation sheet into a summary sheet.

Process of use

1) Fill in data input sheet with sound power levels and room criteria

2) Use macro button which generates all calculation sheets and output sheet

3) User will fill in specific details on each template sheet based on job specific data (not to be automated)

4) Once initial calculation sheets and output sheet is generated they need to reference back to input sheet so that user can change names or data which auto update generated sheets. If new rows are added to input sheet the existing sheets should not regenerate and only news one will be created.

Further Information

There are 4 potential calculation sheets:

Supply – atmosphere (SU-AT)

Extract – atmosphere (EX-AT)

Supply – Jobside (SU-JS)

Extract – Jobside (EX-JS)

 

The calculations are for noise in ductwork. The inputs, provided in the input sheet will be:

Sound power levels (an array of 8 values)

Reverberation time – in jobside calculations (array of 8 values)

Room noise criteria – NR level – integer between 10-50 that fills in an array of 8 values through a lookup table

Room volume

The last three parameters should be set through drop down boxes which reference the inputs sheet so these may be changed later on.

The output of each calculation sheet is an array of 8 values – insertion loss required which should be copied into a summary sheet in the same format as the input sound power levels table.

 

We would also like the sheets to be dynamically named based on the calculation in the three name format:

AHU# – SU/EX – AT/JS    e.g. AHU2-SU-JS

We will be updating the calculations several times over a period of years so there should also be another macro that can update the calculation sheet based on edits to the input tables. We are open to suggestions as to the best way to do this.

Excel Visual Basic

ID dự án: #14103057

Về dự án

9 đề xuất Dự án từ xa 6 năm trước đang mở

Được trao cho:

zu02

Hi I hope all's well with you. I see you'r looking for a developer proficient in Ms Access/Excel/VB. Really all my projects here I've developed for Ms Access/Excel/VB projects. I'll do your current Excel proje Thêm

£150 GBP trong 3 ngày
(32 Đánh Giá)
5.7

9 freelancer chào giá trung bình£164 cho công việc này

mantislin

Hi sir, This is kimi and I am scraping expert, I have did too many scraping projects, please check my profile page then you will know. https://www.freelancer.com/u/mantislin.html Can you tell me Thêm

£172 GBP trong 5 ngày
(163 Nhận xét)
7.1
khushh07

Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India

£250 GBP trong 5 ngày
(251 Nhận xét)
7.0
ponnarasiBabu

I am an excel expert. Read the project specs. Looks like this project is feasible. Just want to understand and make sure some of the requirements ..so kindly open PM to discuss work and budget..I am based in california Thêm

£200 GBP trong 5 ngày
(113 Nhận xét)
6.5
sonarkaushik

I have over 8 years of experiences – refer my online work portfolio at www.freelancer.com/u/Logytics.html Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 Thêm

£194 GBP trong 2 ngày
(45 Nhận xét)
5.5
ksinghrajeev

A proposal has not yet been provided

£150 GBP trong 7 ngày
(14 Nhận xét)
4.1
sohailhost

I can achieve this for you. I am systems administrator with over 11 years of experience managing server infrastructures and data-center operations across multiple platforms (mostly Microsoft, partially Linux) mostly i Thêm

£100 GBP trong 2 ngày
(6 Nhận xét)
3.1
SilentStarMagic

Hi, I am a serious developer who aims to provide high quality services. If you contact me, we can discuss more things detail and will be achieved with each other's purpose. Good luck for your business…

£150 GBP trong 2 ngày
(0 Nhận xét)
0.0