Assignment task: Process automation
Allen and Briony want to improve the consistency of how they pay for and price books. They'd like to standardize on three standard price offers, and have designed the following process to determine how to allocate them, including the option of rejecting the book altogether. The staff have already agreed on how to determine whether a book is terrible, poor, or good. Using Excel, create a spreadsheet page that automates the above process, allowing a member of the team to enter whether the book is hardcover, its publication year, and its condition, and receive a price to offer. Ensure that you include enough text and formatting to make your spreadsheet usable by a member of the Literature Life team, or by a University lecturer. Your spreadsheet should be configured such that the Low, Medium and High prices can be varied easily. Describe how you automated the process