Excel Expert

已完成 已发布的 3 年前 货到付款
已完成 货到付款

Purpose:

An upholsterer who refurbishes antiquities ordinarily charges £100 to refurbish a small sofa and £300 for a large sofa but offers some discounts on the total cost as detailed below.

For small sofas, the discounts are:

1 small sofa 0%.

2 small sofas 7.5%.

3 small sofas 10%.

More than three small sofas 12%.

For large sofas, the discounts are:

1 large sofa 15%.

More than 1 large sofa 18%.

Write a program, which upon receiving information from the customer about the number of items they want refurbished, informs them how much it will cost.

The routine must:

• allow the customer to enter the number of each type of sofa they would like refurbished.

• ensure input data are valid, e.g. ensure that numbers are non-negative.

• display appropriate error messages (e.g. through MsgBox).

• calculate and then display the cost (e.g. through MsgBox).

Once you have successfully completed the basic routine as specified above, work on extending its flexibility and range of usage. Extensions could include, but not limited to, the following considerations:

• How can data entry be made simple and straightforward for the user? Is the routine flexible enough to accept data of different formats?

• Can the routine be extended for other purposes such as, for example, as an integral component of a larger application such as one that might be used by a larger workshop with larger numbers of customers?

• And so on.

we need

An Excel file in xlsm format containing your routine.

A single pdf document containing the text of your VBA routine.

Excel VBA Excel

项目ID: #28319777

关于项目

14个方案 远程项目 活跃的3 年前

授予:

(55条评论)
4.9

有14名威客正在参与此工作的竞标,均价€25/小时

AnowarRatul

Hello Sir I am an expert on Excel I am available right now I can do this job please knock me......... Thanks Anowar

€25EUR 在1天里
(201条评论)
6.1
akritisood94

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me.

€30EUR 在1天里
(71条评论)
5.6
zu02

Hello I hope all's well with you. I see you're looking for a developer proficient in Ms Excel/VBA. I'm professional Ms Access/Excel/vba coder. I'm coding in vba since Ms Office 97 released. Please visit (where I'm w 更多

€19 EUR 在7天内
(22条评论)
5.4
rIbrarahmed

hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit myse 更多

€19EUR 在1天里
(22条评论)
4.9
Emmyope93

Hi, Good day. I understand you need a good work done in Excel. I will like to assist you on this project. I have delivered similar projects here on freelancer and can share sample of my work with you. A Little More Ab 更多

€27 EUR 在2天内
(4条评论)
3.2
PoojaGupta002

I can perfectly help you with that. I am a professional Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Google sheets & Excel (including VBA and Macro) to per 更多

€15EUR 在1天里
(1条评论)
1.3
faizanmaqbool695

I can complete your project on time and within your budget. I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations. I can achieve the results that you are askin 更多

€30EUR 在1天里
(0条评论)
0.0
ansermehmood029

Hay Dear, I Understand you are looking for a well experienced excel work for your projects.  I have more than 6 years of experience of Data Entry, Excel sheets Data Management, and account  Management. I have done t 更多

€19 EUR 在7天内
(0条评论)
0.0
robinsammi32

Greetings . I hope you had a very nice day. I am willing to work tirelessly to satisfy you in a twenty four hour period. I am avid at excel and hope that I am your choice for the job. Thank you in advance.

€27 EUR 在7天内
(0条评论)
0.0