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.
An Excel file in xlsm format containing your routine.
A single pdf document containing the text of your VBA routine.
Bu iş için 14 freelancer ortalamada €25 teklif veriyor
Hello Sir I am an expert on Excel I am available right now I can do this job please knock me......... Thanks Anowar
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.
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 Daha Fazla
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 Daha Fazla
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 Daha Fazla
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.