the assignment is to be in the excel sheet along with the findings for each task.please refer the...

Question

the assignment is to be in the excel sheet along with the findings for each task.please refer the attached file for complete understanding

CRICOS Provider No. 00103D Page 1 of 5 ITECH1100 Understanding the Digital Revolution Assignment 1 - Book Resurrection Overview For this individual assignment, you will use skills acquired through practical laboratory exercises to automate a business process, and to visualize the impact of the automation. You should use Microsoft Excel (or equivalent open-source software) for this assessment task. Important: This assignment specification is generated just for you. Do not distribute this specification. Timelines and Expectations Percentage value of task: 20% Due: Sunday, Week 6, 16:00 (See Course Description for date) Learning Outcomes Assessed The following course learning outcomes are assessed by completing this assessment: A1. Prepare a basic solution to a business problem; A2. Select appropriate IT solutions for business functions; A3. Apply business information software for data visualization and analysis purposes. S1. Write basic programming logic; S3. Interpret and construct representations of business data flow and processes; K8. Outline the basic principles of programming. Assessment Details Book Resurrection is a small second-hand book shop, run by a team of three staff members: Angus, Boris, and Connor. For this assignment, you will complete the following set of tasks using Excel, and build an ePortfolio page to describe your work. Task 0 - Setting up Create an ePortfolio page for your assignment. You will submit this page to Moodle as per the lab tasks. You may call it whatever you like, for example ITECH1100 Assignment 1 - 30348034. Hours of operation Most of the time, each team member works separate shifts: Angus works 9:00 AM to 12:30 PM, Monday, Tuesday and Wednesday; Boris works 9:00 AM to 12:30 PM, Thursday, Friday and Saturday; and Connor works 12:30 PM to 5:30 PM, Monday to Friday. The shop runs from 9:00 AM to 5:30 PM each day, except Saturday when it closes at 12:30. It is closed entirely on Sundays. CRICOS Provider No. 00103D Page 2 of 5 Costs Angus and Boris are the semi-retired co-owners of the bookshop, and do not take a salary. Connor, however, is a part-time employee, with total employment costs of $22 per hour. Connor is also entitled to four weeks of paid annual leave, during which a casual replacement is required at a cost of $33 per hour. Fixed costs such as rent and insurance are $2900 per year, and utilities costs are $140 per month. Task 1 - Costs of operating the business Using Excel, create a spreadsheet called operating_costs.xlsx that calculates the projected annual outgoing costs of running Book Resurrection. Your spreadsheet should be configured such that the working hours, hourly rates, and fixed and utility costs can be varied easily. Document your findings in your ePortfolio page (approximately 100 words). Obtaining Books Throughout the day, customers come to Book Resurrection to buy books, and occasionally to sell them. When people bring in books to sell to Book Resurrection, the staff member on duty will review the books and make an offer for each one individually. Currently, the process for determining how much the book shop will pay for a book is entirely subjective. Staff members offer an amount per book based on the quality of the book, and how popular they think it is, and how they are feeling at the time. The sale amount is always simply double the amount paid and is set at the same time - if Book Resurrection pays $3.00 for a book, they will put it on sale with a marked price of $6.00. (Book Resurrection does not deal in rare or antique books) For several months, staff have been keeping track of the date and time, quality, publication year and amount paid for each book in a spreadsheet. This spreadsheet is available for download on Moodle. Task 2 - Sales team offers Using Excel, process the history of purchases spreadsheet and use appropriate charts to visualize: How the prices paid differed for each staff member; and How the prices paid have changed over time Describe your findings in your ePortfolio (approximately 250 words), and attach the Excel file to your page. Process automation Angus and Boris 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. CRICOS Provider No. 00103D Page 3 of 5 The staff have already agreed on how to determine whether a book is terrible, poor, or good. Bo ok p ur ch as e Cu st om er Book offered Done Evaluate offer Bo ok s ho p Assess quality Reject Terrible Assess publication date Offer low price Poor Good Older than 15 years Offer medium price Check is hardcover 15 years or newer Paperback Offer high price Hardcover Task 3 - Automation 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 Book Resurrection 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 (approx 150 words), and attach your Excel file to your ePortfolio. Task 4 - Price setting Using Excel and the historical data you have available, determine sets of prices which meet the objectives of the following scenarios: Scenario one: Total offer prices are approximately the same as for the historical data Scenario two: Assuming all books purchased are sold, allow all staff to draw the same wage as Connor. CRICOS Provider No. 00103D Page 4 of 5 Describe the strategy you used to find appropriate prices for each scenario (approximately 150 words). Ensure that the Low price is less than the Medium price, and both are less than the High price. Bonus challenge task (optional!) Disclaimer: This task is 100% optional, and you can receive full marks without attempting or completing it. It is intended to be a challenge if you are interested in such things, and the marks available do not reflect the significant research and effort required to implement it correctly. Tutors will not provide significant assistance for this challenge task. Optional task 5 Reimplement Task 1 and Task 3 using either Python or HTML+JavaScript. Write a brief overview of how to run your solution, and attach a zip file containing your code to your ePortfolio page. There are no partial marks awarded for this bonus task - you must complete all features to attain the bonus marks. It is possible to attain full marks for this assignment without completing this challenge task. Further details Assignment support This assignment is supported by the first 6 lectures and labs. Work on the assignment should be spread over several weeks after the relevant lab has been mastered. Submission All files should be submitted to Moodle by the due date and time. Check with your tutor as to whether a hard copy is required in addition to the electronic submission. Marking Criteria/Rubric Refer to the attached marking guide. Feedback Feedback will be supplied through Moodle. Authoritative marks will be published through fdlMarks Plagiarism Plagiarism is the presentation of the expressed thought or work of another person as though it is one's own without properly acknowledging that person. You must not allow other students to copy your work and must take care to safeguard against this happening. More information about the plagiarism policy and procedure for the university can be found at http://federation.edu.au/students/learning-and-study/online-help-with/plagiarism. http://federation.edu.au/students/learning-and-study/online-help-with/plagiarism CRICOS Provider No. 00103D Page 5 of 5 Marking Guide: Assignment 1 Feature Criteria Maximum Obtained Operating costs Appropriate projection calculation 2 Configurable hours, rates, fixed annual and monthly costs 2 Description of findings 1 Uses hand-calculated values (-1) Sales team offers Visualization of prices offered per staff member 2 Visualization of change in prices over time 2 Description of findings 1 Automation Spreadsheet accurately models the BPMN process 4 Description of automation 1 Unclear instructions (-1) Price setting Appropriate Low, Medium and High prices for scenario 1 2 Appropriate Low, Medium and High prices for scenario 2 2 Description of strategy 1 Bonus optional challenge task Faithful reimplementation of tasks 1 and 3 using Python or HTML+JavaScript (+2) Total: 20

unifolks_636605104402137336_117444_1.pdf unifolks_636605104402137336_117444_2.xlsx

Abr Writing · Accepted Answer

Book Resurrection.html
  
    
In [1]:
    
hourlyPay = [0, 0, 22, 33]
workingHours = [3.5, 3.5, 5, 5]
annualWorkingDays = [156, 156, 240, 20]
temp = [a*b for a,b in zip(hourlyPay, workingHours)]
totalSalary = sum([a*b for a,b in zip(temp, annualWorkingDays)])
rentInsurance = 2900
utilities = 140
total = rentInsurance + utilities*12 + totalSalary
print('Annual Operational Cost: $' + str(total))
Annual Operational Cost: $34280.0
In [2]:
    
def standardPrice(quality, date, cover):
    low = 3
    medium = 6
    high = 12
    if quality.lower() == "t":
        return 0
    elif quality.lower() == "p":
        return low
    else:
        if date.lower() == "o":
            return low
        else:
            if cover.lower() == "p":
                return medium
            else:
                return high
def promptUser():
    print('T = Terrible, P = Poor, G = Good')
    while True:
        qual = input('Enter Quality: ')
        if qual.lower() == "t":
            break
        elif qual.lower() == "p":
            break
        elif qual.lower() == "g":
            break
        else:
            print('Please enter a valid input')
    print('O = Older than 15 years, N = 15 years or newer')
    while True:
        dt = input('Enter Publication Date: ')
        if dt.lower() == "o":
            break
        elif dt.lower() == "n":
            break
        else:
            print('Please enter a valid input')
    print('H = Hardcover, P = Paperback')
    while True:
        cvr = input('Enter Type: ')
        if cvr.lower() == "h":
            break
        elif cvr.lower() == "p":
            break
        else:
            print('Please enter a valid input')
            
    print('Price: $' + str(standardPrice(qual, dt, cvr)))
In [3]:
    
promptUser()
T = Terrible, P = Poor, G = Good
Enter Quality: T
O = Older than 15 years, N = 15 years or newer
Enter Publication Date: O
H = Hardcover, P = Paperback
Enter Type: H
Price: $0
In [4]:
    
promptUser()
T = Terrible, P = Poor, G = Good
Enter Quality: G
O = Older than 15 years, N = 15 years or newer
Enter Publication Date: N
H = Hardcover, P = Paperback
Enter Type: P
Price: $6

29933.xlsx
histData
		Price						Condition		Publication Date		Hardcover				Total
		Low		3				Good		Older than 15 years		Hardcover				Offer ($)		1212.9
		Medium		6				Poor		15 years or newer		Paperback				Standard Price ($)		1350
		High		12				Terrible
		Date		Time		Condition		Published		Type		Offer ($)		Publication Date		Standard Price ($)						Date		(All)
		June 29, 2017		15:26		Good		1985		Paperback		5.5		Older than 15 years		3
		June 29, 2017		16:58		Good		1982		Paperback		5		Older than 15 years		3						Average of Offer ($)		Column Labels
		June 29, 2017		17:02		Terrible		2011		Paperback		0.2		15 years or newer		0						Row Labels		Hardcover		Paperback		Grand Total
		June 30, 2017		12:34		Good		1953		Hardcover		7		Older than 15 years		3						Good		7.38375		4.4209876543		5.8931677019
		June 30, 2017		13:41		Poor		1993		Hardcover		2		Older than 15 years		3						Poor		2.1090909091		1.2235849057		1.4833333333
		June 30, 2017		16:04		Poor		1999		Hardcover		2		Older than 15 years		3						Terrible		1		0.2416666667		0.2461538462
		July 1, 2017		9:08		Good		2011		Paperback		2.5		15 years or newer		6						Grand Total		5.476		1.4884507042		2.526875
		July 1, 2017		11:26		Good		1987		Hardcover		6.5		Older than 15 years		3
		July 1, 2017		11:47		Poor		1982		Paperback		0.8		Older than 15 years		3
		July 1, 2017		11:54		Poor		1987		Paperback		0.6		Older than 15 years		3
		July 1, 2017		12:01		Terrible		1989		Paperback		0.2		Older than 15 years		0
		July 1, 2017		12:27		Poor		1997		Paperback		0.6		Older than 15 years		3
		July 3, 2017		10:53		Good		2010		Paperback		2		15 years or newer		6
		July 3, 2017		11:18		Good		2005		Paperback		1.5		15 years or newer		6
		July 3, 2017		12:08		Good		2005		Paperback		3.5		15 years or newer		6
		July 3, 2017		16:20		Good		2009		Hardcover		6		15 years or newer		12
		July 3, 2017		16:21		Good		1977		Paperback		4		Older than 15 years		3
		July 3, 2017		17:01		Poor		1975		Paperback		1		Older than 15 years		3
		July 4, 2017		10:08		Poor		2005		Hardcover		2		15 years or newer		3
		July 4, 2017		11:33		Good		1975		Paperback		1.6		Older than 15 years		3
		July 4, 2017		12:10		Terrible		1977		Paperback		0.2		Older than 15 years		0
		July 4, 2017		16:11		Poor		1975		Paperback		1		Older than 15 years		3
		July 4, 2017		16:27		Poor		2005		Paperback		1.5		15 years or newer		3
		July 4, 2017		16:53		Good		2012		Paperback		5		15 years or newer		6
		July 4, 2017		16:57		Good		2010		Paperback		5.5		15 years or newer		6
		July 5, 2017		9:28		Good		2010		Paperback		4.8		15 years or newer		6
		July 5, 2017		11:28		Good		2013		Hardcover		6		15 years or newer		12
		July 5, 2017		11:51		Poor		1996		Paperback		1		Older than 15 years		3
		July 5, 2017		12:12		Good		2009		Paperback		5.5		15 years or newer		6
		July 5, 2017		12:14		Good		2014		Paperback		3		15 years or newer		6
		July 5, 2017		13:54		Good		2010		Hardcover		7		15 years or newer		12
		July 5, 2017		15:26		Good		2001		Paperback		5.5		Older than 15 years		3
		July 5, 2017		15:29		Poor		1997		Paperback		1		Older than 15 years		3
		July 5, 2017		15:32		Poor		1975		Paperback		1.5		Older than 15 years		3
		July 5, 2017		16:40		Good		1999		Hardcover		6		Older than 15 years		3
		July 6, 2017		9:18		Good		2007		Hardcover		8.5		15 years or newer		12
		July 6, 2017		9:20		Terrible		1961		Paperback		0.2		Older than 15 years		0
		July 6, 2017		12:26		Terrible		1993		Paperback		0.2		Older than 15 years		0
		July 6, 2017		12:37		Poor		2012		Paperback		1.5		15 years or newer		3
		July 6, 2017		12:38		Terrible		1975		Paperback		0.2		Older than 15 years		0
		July 6, 2017		12:53		Poor		2013		Paperback		1.5		15 years or newer		3
		July 6, 2017		13:47		Good		1997		Hardcover		6.5		Older than 15 years		3
		July 6, 2017		15:29		Poor		1993		Paperback		1.5		Older than 15 years		3
		July 6, 2017		15:30		Poor		2011		Hardcover		2		15 years or newer		3
		July 6, 2017		16:39		Good		1961		Paperback		5.5		Older than 15 years		3
		July 6, 2017		16:55		Good		1989		Hardcover		6.5		Older than 15 years		3
		July 7, 2017		11:35		Terrible		1968		Paperback		0.2		Older than 15 years		0
		July 7, 2017		12:34		Good		1997		Hardcover		8		Older than 15 years		3
		July 7, 2017		12:59		Terrible		2008		Paperback		0.2		15 years or newer		0
		July 7, 2017		13:21		Good		1997		Hardcover		8.5		Older than 15 years		3
		July 7, 2017		14:11		Good		2002		Hardcover		7.5		Older than 15 years		3
		July 7, 2017		14:49		Terrible		1975		Paperback		0.2		Older than 15 years		0
		July 7, 2017		15:33		Terrible		1982		Paperback		0.2		Older than 15 years		0
		July 7, 2017		15:49		Poor		2005		Hardcover		2.5		15 years or newer		3
		July 7, 2017		17:11		Poor		1969		Hardcover		2		Older than 15 years		3
		July 7, 2017		17:17		Good		1987		Hardcover		7		Older than 15 years		3
		July 7, 2017		17:18		Good		2005		Hardcover		8.5		15 years or newer		12
		July 8, 2017		10:01		Poor		2002		Paperback		0.8		Older than 15 years		3
		July 8, 2017		11:00		Terrible		1989		Paperback		0.2		Older than 15 years		0
		July 8, 2017		11:06		Poor		1989		Paperback		1.4		Older than 15 years		3
		July 8, 2017		11:33		Poor		1961		Paperback		1.2		Older than 15 years		3
		July 8, 2017		11:51		Good		2008		Hardcover		11.5		15 years or newer		12
		July 8, 2017		12:26		Terrible		2009		Paperback		0.2		15 years or newer		0
		July 10, 2017		14:06		Poor		1968		Paperback		1		Older than 15 years		3
		July 10, 2017		15:04		Poor		1996		Paperback		1.5		Older than 15 years		3
		July 10, 2017		15:35		Good		2010		Paperback		5.5		15 years or newer		6
		July 11, 2017		15:04		Terrible		2013		Paperback		0.2		15 years or newer		0
		July 11, 2017		15:28		Terrible		2001		Paperback		0.2		Older than 15 years		0
		July 11, 2017		17:20		Good		1996		Paperback		4.5		Older than 15 years		3
		July 12, 2017		13:50		Poor		2009		Paperback		1.5		15 years or newer		3
		July 12, 2017		17:16		Poor		1993		Paperback		1.5		Older than 15 years		3
		July 12, 2017		17:27		Good		1993		Paperback		5.5		Older than 15 years		3
		July 13, 2017		10:57		Good		1993		Paperback		3.5		Older than 15 years		3
		July 13, 2017		11:38		Terrible		1989		Paperback		0.2		Older than 15 years		0
		July 13, 2017		12:21		Good		1953		Paperback		4.5		Older than 15 years		3
		July 13, 2017		13:26		Good		2012		Paperback		5.5		15 years or newer		6
		July 13, 2017		13:37		Terrible		2013		Paperback		0.2		15 years or newer		0
		July 13, 2017		15:00		Terrible		2011		Paperback		0.2		15 years or newer		0
		July 13, 2017		15:25		Good		1969		Paperback		5.5		Older than 15 years		3
		July 13, 2017		16:01		Poor		1993		Paperback		1.5		Older than 15 years		3
		July 14, 2017		9:25		Poor		1961		Paperback		0.6		Older than 15 years		3
		July 14, 2017		12:12		Good		1997		Hardcover		6.5		Older than 15 years		3
		July 15, 2017		9:59		Good		2015		Hardcover		12.5		15 years or newer		12
		July 15, 2017		11:28		Terrible		2005		Paperback		0.2		15 years or newer		0
		July 17, 2017		12:30		Terrible		1987		Paperback		0.2		Older than 15 years		0
		July 17, 2017		14:42		Terrible		1993		Paperback		0.2		Older than 15 years		0
		July 17, 2017		15:48		Poor		2013		Paperback		1.5		15 years or newer		3
		July 17, 2017		17:21		Terrible		1977		Paperback		0.2		Older than 15 years		0
		July 18, 2017		9:22		Terrible		1953		Paperback		0.5		Older than 15 years		0
		July 18, 2017		9:53		Good		1992		Hardcover		6		Older than 15 years		3
		July 18, 2017		10:36		Poor		1997		Paperback		1.2		Older than 15 years		3
		July 18, 2017		11:28		Terrible		2003		Paperback		0.5		15 years or newer		0
		July 18, 2017		11:29		Terrible		1993		Paperback		0.5		Older than 15 years		0
		July 18, 2017		16:53		Good		1993		Paperback		5.5		Older than 15 years		3
		July 18, 2017		17:11		Terrible		2003		Paperback		0.2		15 years or newer		0
		July 19, 2017		10:51		Terrible		2012		Paperback		0.2		15 years or newer		0
		July 19, 2017		14:03		Good		1997		Paperback		5		Older than 15 years		3
		July 19, 2017		14:47		Good		2013		Hardcover		6.5		15 years or newer		12
		July 19, 2017		16:42		Terrible		2015		Paperback		0.2		15 years or newer		0
		July 20, 2017		10:01		Poor		2014		Paperback		1.2		15 years or newer		3
		July 20, 2017		10:36		Good		2010		Hardcover		10.5		15 years or newer		12
		July 20, 2017		11:08		Good		1993		Paperback		3		Older than 15 years		3
		July 20, 2017		11:19		Terrible		1997		Paperback		0.2		Older than 15 years		0
		July 20, 2017		14:23		Terrible		2010		Paperback		0.2		15 years or newer		0
		July 20, 2017		15:32		Terrible		1999		Paperback		0.2		Older than 15 years		0
		July 20, 2017		15:43		Good		1968		Paperback		5		Older than 15 years		3
		July 20, 2017		16:49		Poor		2010		Paperback		1.5		15 years or newer		3
		July 20, 2017		16:50		Terrible		2005		Paperback		0.2		15 years or newer		0
		July 20, 2017		16:59		Terrible		2005		Paperback		0.2		15 years or newer		0
		July 21, 2017		9:42		Poor		2007		Paperback		1.2		15 years or newer		3
		July 21, 2017		12:15		Good		1987		Paperback		4.5		Older than 15 years		3
		July 22, 2017		10:49		Good		1975		Hardcover		6.5		Older than 15 years		3
		July 22, 2017		11:54		Good		1989		Paperback		5.5		Older than 15 years		3
		July 24, 2017		10:47		Good		2007		Paperback		4.2		15 years or newer		6
		July 24, 2017		10:52		Poor		2001		Hardcover		2.4		Older than 15 years		3
		July 24, 2017		12:05		Poor		1996		Paperback		1		Older than 15 years		3
		July 24, 2017		14:49		Good		2012		Hardcover		6.5		15 years or newer		12
		July 25, 2017		10:13		Good		1996		Paperback		5		Older than 15 years		3
		July 25, 2017		12:26		Good		2011		Paperback		4.5		15 years or newer		6
		July 25, 2017		13:12		Good		1996		Paperback		5		Older than 15 years		3
		July 25, 2017		16:50		Good		2016		Paperback		5.5		15 years or newer		6
		July 25, 2017		17:13		Poor		2002		Paperback		1		Older than 15 years		3
		July 26, 2017		9:30		Good		2010		Hardcover		6		15 years or newer		12
		July 26, 2017		9:38		Good		2009		Hardcover		6.5		15 years or newer		12
		July 26, 2017		10:10		Poor		1999		Paperback		1.5		Older than 15 years		3
		July 26, 2017		13:21		Terrible		1989		Paperback		0.2		Older than 15 years		0
		July 26, 2017		13:46		Terrible		2009		Paperback		0.2		15 years or newer		0
		July 26, 2017		14:11		Terrible		2009		Paperback		0.2		15 years or newer		0
		July 26, 2017		14:37		Good		2015		Hardcover		6		15 years or newer		12
		July 26, 2017		15:41		Poor		1996		Paperback		1.5		Older than 15 years		3
		July 26, 2017		16:29		Poor		1997		Paperback		1.5		Older than 15 years		3
		July 27, 2017		9:21		Poor		2013		Paperback		1.2		15 years or newer		3
		July 27, 2017		9:57		Poor		2015		Paperback		0.4		15 years or newer		3
		July 27, 2017		10:54		Good		2014		Paperback		5.5		15 years or newer		6
		July 27, 2017		13:22		Terrible		1961		Paperback		0.2		Older than 15 years		0
		July 27, 2017		14:06		Terrible		2008		Paperback		0.2		15 years or newer		0
		July 27, 2017		14:22		Terrible		2001		Paperback		0.2		Older than 15 years		0
		July 27, 2017		14:38		Poor		2007		Hardcover		2		15 years or newer		3
		July 27, 2017		14:53		Poor		2002		Paperback		1.5		Older than 15 years		3
		July 27, 2017		15:33		Terrible		2009		Paperback		0.2		15 years or newer		0
		July 28, 2017		9:56		Poor		1992		Paperback		1.2		Older than 15 years		3
		July 28, 2017		13:04		Poor		1953		Hardcover		2		Older than 15 years		3
		July 28, 2017		14:35		Poor		2001		Hardcover		2.5		Older than 15 years		3
		July 28, 2017		15:44		Terrible		2014		Paperback		0.2		15 years or newer		0
		July 28, 2017		16:09		Poor		2014		Hardcover		2.5		15 years or newer		3
		July 29, 2017		9:18		Good		2015		Paperback		5.5		15 years or newer		6
		July 29, 2017		9:27		Poor		1996		Paperback		1.2		Older than 15 years		3
		July 29, 2017		9:29		Terrible		2016		Paperback		0.4		15 years or newer		0
		July 31, 2017		9:06		Terrible		1981		Paperback		0.5		Older than 15 years		0
		July 31, 2017		9:29		Poor		2001		Hardcover		1.6		Older than 15 years		3
		July 31, 2017		9:46		Terrible		1987		Paperback		0.5		Older than 15 years		0
		July 31, 2017		10:19		Terrible		1975		Paperback		0		Older than 15 years		0
		July 31, 2017		10:41		Good		2013		Paperback		3.5		15 years or newer		6
		July 31, 2017		10:43		Good		2009		Paperback		2.2		15 years or newer		6
		July 31, 2017		10:52		Terrible		2002		Paperback		0		Older than 15 years		0
		July 31, 2017		11:27		Good		2009		Paperback		4.8		15 years or newer		6
		July 31, 2017		11:38		Good		1969		Paperback		2		Older than 15 years		3
		July 31, 2017		12:31		Poor		2008		Paperback		1.5		15 years or newer		3
		July 31, 2017		12:39		Good		2013		Paperback		5		15 years or newer		6
		July 31, 2017		14:30		Terrible		2007		Paperback		0.2		15 years or newer		0
		August 1, 2017		9:25		Good		1982		Paperback		3		Older than 15 years		3
		August 1, 2017		9:45		Poor		2010		Paperback		1		15 years or newer		3
		August 1, 2017		9:45		Good		2013		Paperback		4.8		15 years or newer		6
		August 1, 2017		9:56		Poor		1993		Paperback		1.5		Older than 15 years		3
		August 1, 2017		11:22		Poor		1999		Paperback		1.2		Older than 15 years		3
		August 1, 2017		11:48		Terrible		1993		Paperback		0.5		Older than 15 years		0
		August 1, 2017		13:40		Good		2015		Hardcover		7		15 years or newer		12
		August 1, 2017		14:37		Poor		1985		Paperback		1.5		Older than 15 years		3
		August 1, 2017		14:55		Good		1975		Paperback		5.5		Older than 15 years		3
		August 1, 2017		16:18		Terrible		2010		Paperback		0.2		15 years or newer		0
		August 1, 2017		16:19		Poor		2002		Paperback		1.5		Older than 15 years		3
		August 2, 2017		9:00		Poor		2001		Hardcover		3.2		Older than 15 years		3
		August 2, 2017		9:45		Poor		1993		Paperback		1		Older than 15 years		3
		August 2, 2017		10:01		Good		2005		Hardcover		7		15 years or newer		12
		August 2, 2017		10:36		Terrible		1999		Paperback		0.5		Older than 15 years		0
		August 2, 2017		11:20		Terrible		1999		Paperback		0.6		Older than 15 years		0
		August 2, 2017		11:50		Terrible		2011		Paperback		0.5		15 years or newer		0
		August 2, 2017		13:32		Poor		1975		Paperback		1		Older than 15 years		3
		August 2, 2017		13:44		Poor		2005		Paperback		1.5		15 years or newer		3
		August 2, 2017		15:10		Terrible		2008		Paperback		0.2		15 years or newer		0
		August 2, 2017		16:55		Good		1987		Paperback		5.5		Older than 15 years		3
		August 2, 2017		17:27		Poor		1999		Paperback		1.5		Older than 15 years		3
		August 3, 2017		9:07		Poor		1987		Paperback		1		Older than 15 years		3
		August 3, 2017		11:25		Good		1981		Hardcover		6		Older than 15 years		3
		August 3, 2017		12:25		Terrible		1987		Paperback		0.2		Older than 15 years		0
		August 3, 2017		12:53		Poor		1989		Paperback		1.5		Older than 15 years		3
		August 3, 2017		13:09		Poor		2003		Hardcover		2		15 years or newer		3
		August 3, 2017		14:45		Poor		2005		Paperback		1.5		15 years or newer		3
		August 3, 2017		16:29		Good		1987		Hardcover		6.5		Older than 15 years		3
		August 3, 2017		17:26		Terrible		1997		Paperback		0.2		Older than 15 years		0
		August 4, 2017		9:54		Terrible		2013		Paperback		0.2		15 years or newer		0
		August 4, 2017		10:01		Terrible		1961		Paperback		0.2		Older than 15 years		0
		August 4, 2017		10:18		Terrible		2015		Paperback		0.2		15 years or newer		0
		August 4, 2017		10:28		Poor		2011		Hardcover		1.6		15 years or newer		3
		August 4, 2017		11:08		Poor		2005		Paperback		1.4		15 years or newer		3
		August 4, 2017		11:16		Terrible		2005		Paperback		0.2		15 years or newer		0
		August 4, 2017		11:45		Good		2002		Hardcover		7.5		Older than 15 years		3
		August 4, 2017		11:53		Poor		2009		Paperback		1.4		15 years or newer		3
		August 4, 2017		12:48		Terrible		1993		Paperback		0.2		Older than 15 years		0
		August 4, 2017		12:57		Terrible		2009		Paperback		0.2		15 years or newer		0
		August 4, 2017		13:34		Terrible		1993		Paperback		0.2		Older than 15 years		0
		August 4, 2017		13:38		Terrible		2005		Paperback		0.2		15 years or newer		0
		August 4, 2017		13:58		Poor		2001		Hardcover		2.5		Older than 15 years		3
		August 4, 2017		17:16		Good		2005		Hardcover		10		15 years or newer		12
		August 5, 2017		9:44		Poor		2003		Paperback		1.2		15 years or newer		3
		August 5, 2017		11:42		Poor		1968		Paperback		0.6		Older than 15 years		3
		August 5, 2017		12:22		Good		2013		Hardcover		11		15 years or newer		12
		August 7, 2017		9:34		Poor		1996		Hardcover		2.2		Older than 15 years		3
		August 7, 2017		9:47		Good		1975		Paperback		4		Older than 15 years		3
		August 7, 2017		10:13		Terrible		1992		Paperback		0.5		Older than 15 years		0
		August 7, 2017		12:09		Terrible		2005		Paperback		0.4		15 years or newer		0
		August 7, 2017		14:06		Good		1985		Paperback		4.5		Older than 15 years		3
		August 7, 2017		15:11		Poor		1997		Paperback		1.5		Older than 15 years		3
		August 7, 2017		15:38		Poor		1999		Paperback		1.5		Older than 15 years		3
		August 8, 2017		11:40		Terrible		1999		Paperback		0.6		Older than 15 years		0
		August 8, 2017		14:54		Good		1993		Paperback		5		Older than 15 years		3
		August 8, 2017		15:46		Good		1977		Paperback		5		Older than 15 years		3
		August 8, 2017		15:51		Terrible		2011		Paperback		0.2		15 years or newer		0
		August 8, 2017		16:53		Good		1982		Paperback		4.5		Older than 15 years		3
		August 9, 2017		10:57		Terrible		1961		Paperback		0		Older than 15 years		0
		August 9, 2017		13:09		Good		2009		Paperback		5.5		15 years or newer		6
		August 9, 2017		14:21		Good		2013		Hardcover		7.5		15 years or newer		12
		August 9, 2017		14:59		Good		1996		Paperback		5		Older than 15 years		3
		August 9, 2017		15:22		Poor		1977		Paperback		1		Older than 15 years		3
		August 10, 2017		9:45		Terrible		2014		Paperback		0.2		15 years or newer		0
		August 10, 2017		11:40		Terrible		2005		Paperback		0.2		15 years or newer		0
		August 10, 2017		11:53		Terrible		2011		Paperback		0.2		15 years or newer		0
		August 10, 2017		13:46		Terrible		1993		Paperback		0.2		Older than 15 years		0
		August 10, 2017		14:45		Terrible		2013		Paperback		0.2		15 years or newer		0
		August 10, 2017		15:29		Good		2011		Hardcover		6		15 years or newer		12
		August 10, 2017		15:43		Good		1975		Hardcover		7		Older than 15 years		3
		August 10, 2017		16:29		Terrible		2013		Paperback		0.2		15 years or newer		0
		August 11, 2017		9:09		Terrible		1982		Paperback		0.2		Older than 15 years		0
		August 11, 2017		10:45		Terrible		1977		Paperback		0.2		Older than 15 years		0
		August 11, 2017		11:28		Poor		2013		Paperback		1.2		15 years or newer		3
		August 11, 2017		13:48		Good		2005		Hardcover		10		15 years or newer		12
		August 11, 2017		14:14		Terrible		2002		Paperback		0.2		Older than 15 years		0
		August 11, 2017		17:00		Poor		2014		Hardcover		2		15 years or newer		3
		August 12, 2017		9:19		Poor		2003		Paperback		0.6		15 years or newer		3
		August 12, 2017		10:35		Good		2007		Hardcover		9.5		15 years or newer		12
		August 12, 2017		11:18		Good		2010		Paperback		3		15 years or newer		6
		August 14, 2017		9:28		Poor		1993		Paperback		0.5		Older than 15 years		3
		August 14, 2017		10:05		Good		2002		Hardcover		6		Older than 15 years		3
		August 14, 2017		10:51		Terrible		1981		Paperback		0.5		Older than 15 years		0
		August 14, 2017		11:35		Poor		2005		Hardcover		1.6		15 years or newer		3
		August 14, 2017		12:09		Poor		2013		Hardcover		2.2		15 years or newer		3
		August 14, 2017		12:56		Poor		2003		Paperback		1.5		15 years or newer		3
		August 14, 2017		14:03		Poor		1993		Paperback		1.5		Older than 15 years		3
		August 14, 2017		14:53		Good		1975		Paperback		4.5		Older than 15 years		3
		August 14, 2017		16:03		Terrible		2009		Paperback		0.2		15 years or newer		0
		August 14, 2017		16:18		Poor		1989		Paperback		1.5		Older than 15 years		3
		August 15, 2017		9:07		Terrible		1993		Paperback		0.2		Older than 15 years		0
		August 15, 2017		9:50		Good		2015		Paperback		5.2		15 years or newer		6
		August 15, 2017		10:30		Terrible		2001		Paperback		0.5		Older than 15 years		0
		August 15, 2017		11:54		Poor		2002		Paperback		1.5		Older than 15 years		3
		August 15, 2017		12:01		Poor		1993		Paperback		0.5		Older than 15 years		3
		August 15, 2017		12:09		Terrible		2002		Paperback		0		Older than 15 years		0
		August 15, 2017		12:09		Poor		2014		Hardcover		2.5		15 years or newer		3
		August 15, 2017		12:35		Terrible		1985		Paperback		0.2		Older than 15 years		0
		August 15, 2017		12:57		Terrible		1975		Paperback		0.2		Older than 15 years		0
		August 15, 2017		13:58		Poor		1989		Paperback		1		Older than 15 years		3
		August 15, 2017		14:23		Poor		2001		Paperback		1.5		Older than 15 years		3
		August 15, 2017		16:39		Good		1969		Hardcover		6		Older than 15 years		3
		August 15, 2017		16:54		Good		2012		Paperback		5		15 years or newer		6
		August 15, 2017		17:10		Terrible		1969		Paperback		0.2		Older than 15 years		0
		August 16, 2017		11:56		Poor		2002		Hardcover		2		Older than 15 years		3
		August 16, 2017		16:31		Good		2016		Paperback		5.5		15 years or newer		6
		August 16, 2017		16:48		Terrible		1996		Paperback		0.2		Older than 15 years		0
		August 17, 2017		10:21		Good		1999		Paperback		2		Older than 15 years		3
		August 17, 2017		11:07		Terrible		2011		Paperback		0.2		15 years or newer		0
		August 17, 2017		11:25		Poor		1985		Paperback		0.8		Older than 15 years		3
		August 17, 2017		11:46		Terrible		2014		Paperback		0.2		15 years or newer		0
		August 17, 2017		14:02		Terrible		2009		Paperback		0.2		15 years or newer		0
		August 17, 2017		14:14		Poor		2001		Hardcover		2		Older than 15 years		3
		August 17, 2017		16:26		Terrible		2013		Paperback		0.2		15 years or newer		0
		August 17, 2017		17:26		Poor		2011		Hardcover		2		15 years or newer		3
		August 18, 2017		10:13		Good		1993		Paperback		3		Older than 15 years		3
		August 18, 2017		11:30		Poor		2001		Paperback		0.4		Older than 15 years		3
		August 18, 2017		14:52		Terrible		2011		Paperback		0.2		15 years or newer		0
		August 18, 2017		15:04		Terrible		2011		Paperback		0.2		15 years or newer		0
		August 18, 2017		15:12		Poor		2014		Hardcover		2		15 years or newer		3
		August 18, 2017		17:22		Poor		2012		Hardcover		2.5		15 years or newer		3
		August 18, 2017		17:25		Poor		2011		Hardcover		2.5		15 years or newer		3
		August 19, 2017		9:00		Poor		1961		Paperback		1.2		Older than 15 years		3
		August 19, 2017		9:17		Terrible		1989		Paperback		0.2		Older than 15 years		0
		August 19, 2017		9:19		Good		2001		Hardcover		8		Older than 15 years		3
		August 19, 2017		9:37		Terrible		2009		Paperback		0.2		15 years or newer		0
		August 19, 2017		10:04		Terrible		2007		Paperback		0.2		15 years or newer		0
		August 19, 2017		10:51		Poor		2013		Hardcover		1.8		15 years or newer		3
		August 19, 2017		11:06		Terrible		1996		Paperback		0.2		Older than 15 years		0
		August 19, 2017		11:29		Poor		1985		Paperback		1		Older than 15 years		3
		August 19, 2017		11:49		Good		2002		Hardcover		9		Older than 15 years		3
		August 21, 2017		10:47		Poor		1968		Paperback		1.2		Older than 15 years		3
		August 21, 2017		12:21		Good		1987		Paperback		4.2		Older than 15 years		3
		August 21, 2017		15:08		Terrible		2005		Paperback		0.2		15 years or newer		0
		August 21, 2017		15:17		Terrible		2005		Paperback		0.2		15 years or newer		0
		August 21, 2017		15:37		Terrible		1969		Paperback		0.2		Older than 15 years		0
		August 21, 2017		15:39		Terrible		2009		Paperback		0.2		15 years or newer		0
		August 21, 2017		15:41		Poor		2002		Paperback		1.5		Older than 15 years		3
		August 21, 2017		16:09		Good		1987		Paperback		5		Older than 15 years		3
		August 21, 2017		17:25		Good		2013		Hardcover		6		15 years or newer		12
		August 22, 2017		9:16		Terrible		2003		Paperback		0.5		15 years or newer		0
		August 22, 2017		9:25		Terrible		2013		Paperback		0.6		15 years or newer		0
		August 22, 2017		13:22		Poor		1981		Paperback		1.5		Older than 15 years		3
		August 22, 2017		13:31		Good		2001		Hardcover		6		Older than 15 years		3
		August 22, 2017		13:57		Good		2001		Hardcover		7		Older than 15 years		3
		August 22, 2017		14:13		Good		2009		Paperback		5.5		15 years or newer		6
		August 22, 2017		14:20		Terrible		2009		Paperback		0.2		15 years or newer		0
		August 22, 2017		14:34		Poor		2003		Paperback		1.5		15 years or newer		3
		August 22, 2017		15:04		Terrible		2013		Paperback		0.2		15 years or newer		0
		August 22, 2017		17:24		Good		1985		Paperback		5		Older than 15 years		3
		August 23, 2017		9:10		Good		1977		Paperback		3		Older than 15 years		3
		August 23, 2017		9:34		Terrible		1961		Paperback		0		Older than 15 years		0
		August 23, 2017		9:55		Poor		2001		Hardcover		2		Older than 15 years		3
		August 23, 2017		13:08		Poor		2009		Hardcover		2		15 years or newer		3
		August 23, 2017		14:42		Good		1996		Paperback		5.5		Older than 15 years		3
		August 23, 2017		15:20		Good		2014		Paperback		5.5		15 years or newer		6
		August 23, 2017		16:28		Good		1975		Hardcover		6		Older than 15 years		3
		August 23, 2017		16:40		Poor		2005		Paperback		1.5		15 years or newer		3
		August 23, 2017		16:45		Terrible		2012		Paperback		0.2		15 years or newer		0
		August 23, 2017		16:54		Good		1977		Paperback		5.5		Older than 15 years		3
		August 24, 2017		9:16		Poor		1996		Paperback		0.2		Older than 15 years		3
		August 25, 2017		13:51		Terrible		2011		Paperback		0.2		15 years or newer		0
		August 25, 2017		14:12		Terrible		2009		Paperback		0.5		15 years or newer		0
		August 25, 2017		15:16		Good		1975		Hardcover		9		Older than 15 years		3
		August 26, 2017		9:38		Good		1997		Paperback		5.5		Older than 15 years		3
		August 26, 2017		9:51		Terrible		1987		Paperback		0.2		Older than 15 years		0
		August 26, 2017		10:45		Terrible		1975		Paperback		0.2		Older than 15 years		0
		August 28, 2017		10:02		Good		2010		Hardcover		6.2		15 years or newer		12
		August 28, 2017		10:34		Terrible		2015		Paperback		0.4		15 years or newer		0
		August 28, 2017		10:35		Good		1999		Paperback		4		Older than 15 years		3
		August 28, 2017		11:24		Poor		1993		Paperback		1		Older than 15 years		3
		August 28, 2017		13:28		Poor		2001		Paperback		1.5		Older than 15 years		3
		August 28, 2017		13:35		Poor		2007		Paperback		1.5		15 years or newer		3
		August 28, 2017		13:45		Poor		1961		Paperback		1.5		Older than 15 years		3
		August 28, 2017		15:56		Good		1987		Paperback		5		Older than 15 years		3
		August 28, 2017		16:55		Terrible		1975		Paperback		0.2		Older than 15 years		0
		August 28, 2017		17:07		Terrible		2007		Paperback		0.2		15 years or newer		0
		August 29, 2017		9:26		Terrible		2002		Paperback		0.5		Older than 15 years		0
		August 29, 2017		9:45		Poor		2002		Hardcover		1.6		Older than 15 years		3
		August 29, 2017		11:38		Terrible		2011		Paperback		0.5		15 years or newer		0
		August 29, 2017		13:52		Good		1999		Paperback		5		Older than 15 years		3
		August 30, 2017		12:35		Poor		1975		Paperback		1.5		Older than 15 years		3
		August 30, 2017		12:46		Good		2012		Hardcover		7.5		15 years or newer		12
		August 30, 2017		16:00		Poor		1996		Paperback		1.5		Older than 15 years		3
		August 30, 2017		16:30		Terrible		1953		Paperback		0.2		Older than 15 years		0
		August 31, 2017		9:48		Terrible		2015		Paperback		0.2		15 years or newer		0
		August 31, 2017		11:04		Terrible		1982		Paperback		0.2		Older than 15 years		0
		August 31, 2017		11:38		Poor		1999		Paperback		0.4		Older than 15 years		3
		August 31, 2017		12:51		Terrible		2009		Paperback		0.2		15 years or newer		0
		August 31, 2017		12:54		Poor		1968		Paperback		1.5		Older than 15 years		3
		August 31, 2017		15:19		Terrible		1999		Paperback		0.2		Older than 15 years		0
		August 31, 2017		15:59		Good		2003		Hardcover		7		15 years or newer		12
		August 31, 2017		17:10		Terrible		2011		Paperback		0.2		15 years or newer		0
		September 1, 2017		11:12		Poor		2005		Paperback		0.8		15 years or newer		3
		September 1, 2017		11:21		Terrible		2011		Paperback		0.2		15 years or newer		0
		September 1, 2017		15:26		Good		1993		Hardcover		9		Older than 15 years		3
		September 1, 2017		17:07		Poor		1987		Hardcover		2.5		Older than 15 years		3
		September 2, 2017		9:12		Terrible		1992		Paperback		0.2		Older than 15 years		0
		September 2, 2017		9:45		Poor		1982		Paperback		1		Older than 15 years		3
		September 2, 2017		11:18		Terrible		2002		Paperback		0.2		Older than 15 years		0
		September 4, 2017		9:12		Poor		2012		Hardcover		1.8		15 years or newer		3
		September 4, 2017		11:19		Poor		2015		Hardcover		2		15 years or newer		3
		September 4, 2017		14:23		Poor		1977		Paperback		1		Older than 15 years		3
		September 4, 2017		14:28		Good		2001		Hardcover		6		Older than 15 years		3
		September 4, 2017		15:53		Terrible		1999		Paperback		0.2		Older than 15 years		0
		September 4, 2017		16:47		Good		2005		Hardcover		7		15 years or newer		12
		September 4, 2017		16:57		Poor		1997		Paperback		1.5		Older than 15 years		3
		September 5, 2017		10:50		Terrible		1961		Paperback		0.5		Older than 15 years		0
		September 5, 2017		11:41		Poor		1977		Paperback		1		Older than 15 years		3
		September 5, 2017		14:58		Good		1961		Paperback		5.5		Older than 15 years		3
		September 5, 2017		15:51		Terrible		2002		Paperback		0.2		Older than 15 years		0
		September 5, 2017		15:57		Terrible		2013		Paperback		0.2		15 years or newer		0
		September 5, 2017		16:15		Terrible		1993		Paperback		0.2		Older than 15 years		0
		September 5, 2017		17:17		Poor		1961		Paperback		1.5		Older than 15 years		3
		September 6, 2017		11:32		Good		2007		Hardcover		7.5		15 years or newer		12
		September 6, 2017		12:37		Terrible		2009		Paperback		0.2		15 years or newer		0
		September 6, 2017		14:04		Good		1975		Hardcover		6.5		Older than 15 years		3
		September 6, 2017		14:33		Terrible		2011		Paperback		0.2		15 years or newer		0
		September 6, 2017		14:59		Good		1969		Hardcover		6.5		Older than 15 years		3
		September 6, 2017		16:47		Poor		1989		Paperback		1.5		Older than 15 years		3
		September 7, 2017		9:17		Poor		2011		Hardcover		1.6		15 years or newer		3
		September 7, 2017		9:29		Poor		1982		Paperback		0.8		Older than 15 years		3
		September 7, 2017		10:07		Poor		1999		Paperback		1.4		Older than 15 years		3
		September 7, 2017		11:38		Good		1975		Hardcover		7		Older than 15 years		3
		September 7, 2017		12:25		Good		2009		Paperback		3		15 years or newer		6
		September 7, 2017		14:01		Good		1961		Hardcover		6.5		Older than 15 years		3
		September 7, 2017		15:06		Poor		1953		Hardcover		2		Older than 15 years		3
		September 7, 2017		16:19		Good		1999		Hardcover		7		Older than 15 years		3
		September 8, 2017		10:29		Good		2014		Hardcover		12.5		15 years or newer		12
		September 8, 2017		13:11		Terrible		1989		Paperback		0.2		Older than 15 years		0
		September 8, 2017		13:43		Terrible		2009		Paperback		0.2		15 years or newer		0
		September 8, 2017		14:11		Terrible		2014		Paperback		0.2		15 years or newer		0
		September 9, 2017		9:14		Good		1987		Hardcover		6.5		Older than 15 years		3
		September 9, 2017		9:59		Poor		2013		Paperback		1.4		15 years or newer		3
		September 9, 2017		10:18		Terrible		1999		Paperback		0.2		Older than 15 years		0
		September 9, 2017		10:27		Poor		2007		Paperback		1.4		15 years or newer		3
		September 9, 2017		10:32		Good		2001		Paperback		4.5		Older than 15 years		3
		September 9, 2017		10:53		Good		1982		Hardcover		8.5		Older than 15 years		3
		September 9, 2017		11:27		Good		2011		Hardcover		8		15 years or newer		12
		September 9, 2017		12:04		Terrible		1992		Paperback		0.2		Older than 15 years		0
		September 9, 2017		12:18		Good		2001		Hardcover		7.5		Older than 15 years		3
		September 11, 2017		9:57		Good		2012		Hardcover		6		15 years or newer		12
		September 11, 2017		15:13		Poor		2003		Paperback		1.5		15 years or newer		3
		September 12, 2017		11:10		Good		1985		Paperback		2.8		Older than 15 years		3
		September 12, 2017		12:16		Terrible		1985		Paperback		0.4		Older than 15 years		0
		September 12, 2017		12:40		Good		2009		Hardcover		7		15 years or newer		12
		September 12, 2017		12:43		Terrible		1982		Paperback		0.2		Older than 15 years		0
		September 12, 2017		13:29		Good		1992		Hardcover		6		Older than 15 years		3
		September 12, 2017		15:11		Poor		2007		Hardcover		2		15 years or newer		3
		September 12, 2017		15:12		Terrible		2016		Paperback		0.2		15 years or newer		0
		September 12, 2017		15:30		Terrible		2005		Paperback		0.2		15 years or newer		0
		September 12, 2017		16:05		Poor		1993		Paperback		1.5		Older than 15 years		3
		September 12, 2017		16:14		Poor		1953		Paperback		1		Older than 15 years		3
		September 13, 2017		9:49		Good		2014		Paperback		2		15 years or newer		6
		September 13, 2017		13:37		Terrible		1987		Paperback		0.2		Older than 15 years		0
		September 13, 2017		13:52		Terrible		2003		Paperback		0.2		15 years or newer		0
		September 13, 2017		14:47		Poor		2010		Paperback		1.5		15 years or newer		3
		September 13, 2017		15:41		Terrible		2013		Paperback		0.2		15 years or newer		0
		September 13, 2017		16:02		Poor		1961		Paperback		1.5		Older than 15 years		3
		September 13, 2017		16:23		Good		2001		Paperback		5.5		Older than 15 years		3
		September 14, 2017		10:01		Poor		1993		Paperback		0.8		Older than 15 years		3
		September 14, 2017		12:12		Good		1987		Hardcover		7		Older than 15 years		3
		September 14, 2017		13:23		Terrible		1997		Paperback		0.2		Older than 15 years		0
		September 14, 2017		15:23		Poor		1961		Paperback		1.5		Older than 15 years		3
		September 14, 2017		15:23		Good		2015		Hardcover		8.5		15 years or newer		12
		September 14, 2017		15:54		Terrible		2005		Paperback		0.2		15 years or newer		0
		September 14, 2017		15:56		Good		1997		Hardcover		7		Older than 15 years		3
		September 14, 2017		16:04		Terrible		2005		Paperback		0.2		15 years or newer		0
		September 14, 2017		16:45		Good		1987		Hardcover		7		Older than 15 years		3
		September 14, 2017		17:23		Good		1977		Paperback		5.5		Older than 15 years		3
		September 15, 2017		9:02		Terrible		1985		Paperback		0.2		Older than 15 years		0
		September 15, 2017		9:05		Good		2002		Hardcover		7.5		Older than 15 years		3
		September 15, 2017		9:24		Good		1999		Hardcover		7.5		Older than 15 years		3
		September 15, 2017		11:02		Poor		2012		Hardcover		2		15 years or newer		3
		September 15, 2017		12:21		Terrible		2011		Paperback		0.2		15 years or newer		0
		September 15, 2017		15:04		Terrible		2009		Paperback		0.5		15 years or newer		0
		September 15, 2017		15:06		Poor		1975		Hardcover		2.5		Older than 15 years		3
		September 15, 2017		15:17		Terrible		2016		Paperback		0.2		15 years or newer		0
		September 15, 2017		15:35		Terrible		2005		Paperback		0.5		15 years or newer		0
		September 15, 2017		15:56		Terrible		1977		Paperback		0.2		Older than 15 years		0
		September 15, 2017		17:12		Good		1977		Hardcover		7.5		Older than 15 years		3
		September 16, 2017		9:26		Terrible		2013		Paperback		0.2		15 years or newer		0
		September 16, 2017		9:28		Poor		1999		Hardcover		1.6		Older than 15 years		3
		September 16, 2017		9:49		Good		1989		Paperback		1.6		Older than 15 years		3
		September 16, 2017		10:24		Poor		1953		Paperback		1.2		Older than 15 years		3
		September 16, 2017		10:54		Good		2013		Paperback		3		15 years or newer		6
		September 18, 2017		9:55		Poor		2009		Hardcover		2.6		15 years or newer		3
		September 18, 2017		12:56		Good		1982		Paperback		5		Older than 15 years		3
		September 18, 2017		13:02		Terrible		2007		Paperback		0.2		15 years or newer		0
		September 18, 2017		13:57		Terrible		2009		Paperback		0.2		15 years or newer		0
		September 18, 2017		14:51		Terrible		1999		Paperback		0.2		Older than 15 years		0
		September 18, 2017		16:17		Good		1993		Hardcover		6.5		Older than 15 years		3
		September 19, 2017		9:19		Terrible		2009		Hardcover		1		15 years or newer		0
		September 19, 2017		10:29		Terrible		1989		Paperback		0.5		Older than 15 years		0
		September 19, 2017		11:32		Terrible		1961		Paperback		0.2		Older than 15 years		0
		September 19, 2017		13:38		Good		2011		Hardcover		6		15 years or newer		12
		September 20, 2017		9:20		Good		2002		Paperback		4.4		Older than 15 years		3
		September 20, 2017		10:52		Poor		2014		Hardcover		2		15 years or newer		3
		September 20, 2017		12:31		Good		2015		Hardcover		7		15 years or newer		12
		September 20, 2017		13:18		Terrible		1969		Paperback		0.2		Older than 15 years		0
		September 20, 2017		13:30		Terrible		1989		Paperback		0.2		Older than 15 years		0
		September 20, 2017		14:23		Terrible		1985		Paperback		0.2		Older than 15 years		0
		September 20, 2017		14:47		Terrible		1981		Paperback		0.2		Older than 15 years		0
		September 20, 2017		15:27		Poor		1993		Paperback		1.5		Older than 15 years		3
		September 21, 2017		12:30		Terrible		2014		Paperback		0.2		15 years or newer		0
		September 21, 2017		13:17		Poor		2013		Hardcover		2		15 years or newer		3
		September 21, 2017		13:28		Poor		1982		Paperback		1.5		Older than 15 years		3
		September 21, 2017		14:06		Good		1985		Hardcover		6.5		Older than 15 years		3
		September 21, 2017		15:02		Good		2009		Hardcover		8		15 years or newer		12
		September 21, 2017		15:02		Good		2010		Hardcover		7		15 years or newer		12
		September 21, 2017		15:20		Terrible		2007		Paperback		0.2		15 years or newer		0
		September 21, 2017		16:55		Poor		1985		Paperback		1.5		Older than 15 years		3
		September 22, 2017		9:37		Terrible		2009		Paperback		0.2		15 years or newer		0
		September 22, 2017		10:35		Terrible		2013		Paperback		0.2		15 years or newer		0
		September 22, 2017		11:31		Terrible		2016		Paperback		0.2		15 years or newer		0
		September 22, 2017		12:58		Poor		2001		Hardcover		2.5		Older than 15 years		3
		September 22, 2017		14:25		Terrible		2009		Paperback		0.5		15 years or newer		0
		September 22, 2017		16:13		Good		1993		Hardcover		9.5		Older than 15 years		3
		September 23, 2017		9:57		Terrible		2011		Paperback		0.2		15 years or newer		0
Hardcover	Good	Poor	Terrible	7.3837500000000009	2.1090909090909085	1	Paperback	Good	Poor	Terrible	4.4209876543209878	1.2235849056603778	0.24166666666666689	
Offer ($)	42915	42915	42915	42916	42916	42916	42917	42917	42917	42917	42917	42917	42919	42919	42919	42919	42919	42919	42920	42920	42920	42920	42920	42920	42920	42921	42921	42921	42921	42921	42921	42921	42921	42921	42921	42922	42922	42922	42922	42922	42922	42922	42922	42922	42922	42922	42923	42923	42923	42923	42923	42923	42923	42923	42923	42923	42923	42924	42924	42924	42924	42924	42924	42926	42926	42926	42927	42927	42927	42928	42928	42928	42929	42929	42929	42929	42929	42929	42929	42929	42930	42930	42931	42931	42933	42933	42933	42933	42934	42934	42934	42934	42934	42934	42934	42935	42935	42935	42935	42936	42936	42936	42936	42936	42936	42936	42936	42936	42936	42937	42937	42938	42938	42940	42940	42940	42940	42941	42941	42941	42941	42941	42942	42942	42942	42942	42942	42942	42942	42942	42942	42943	42943	42943	42943	42943	42943	42943	42943	42943	42944	42944	42944	42944	42944	42945	42945	42945	42947	42947	42947	42947	42947	42947	42947	42947	42947	42947	42947	42947	42948	42948	42948	42948	42948	42948	42948	42948	42948	42948	42948	42949	42949	42949	42949	42949	42949	42949	42949	42949	42949	42949	42950	42950	42950	42950	42950	42950	42950	42950	42951	42951	42951	42951	42951	42951	42951	42951	42951	42951	42951	42951	42951	42951	42952	42952	42952	42954	42954	42954	42954	42954	42954	42954	42955	42955	42955	42955	42955	42956	42956	42956	42956	42956	42957	42957	42957	42957	42957	42957	42957	42957	42958	42958	42958	42958	42958	42958	42959	42959	42959	42961	42961	42961	42961	42961	42961	42961	42961	42961	42961	42962	42962	42962	42962	42962	42962	42962	42962	42962	42962	42962	42962	42962	42962	42963	42963	42963	42964	42964	42964	42964	42964	42964	42964	42964	42965	42965	42965	42965	42965	42965	42965	42966	42966	42966	42966	42966	42966	42966	42966	42966	42968	42968	42968	42968	42968	42968	42968	42968	42968	42969	42969	42969	42969	42969	42969	42969	42969	42969	42969	42970	42970	42970	42970	42970	42970	42970	42970	42970	42970	42971	42972	42972	42972	42973	42973	42973	42975	42975	42975	42975	42975	42975	42975	42975	42975	42975	42976	42976	42976	42976	42977	42977	42977	42977	42978	42978	42978	42978	42978	42978	42978	42978	42979	42979	42979	42979	42980	42980	42980	42982	42982	42982	42982	42982	42982	42982	42983	42983	42983	42983	42983	42983	42983	42984	42984	42984	42984	42984	42984	42985	42985	42985	42985	42985	42985	42985	42985	42986	42986	42986	42986	42987	42987	42987	42987	42987	42987	42987	42987	42987	42989	42989	42990	42990	42990	42990	42990	42990	42990	42990	42990	42990	42991	42991	42991	42991	42991	42991	42991	42992	42992	42992	42992	42992	42992	42992	42992	42992	42992	42993	42993	42993	42993	42993	42993	42993	42993	42993	42993	42993	42994	42994	42994	42994	42994	42996	42996	42996	42996	42996	42996	42997	42997	42997	42997	42998	42998	42998	42998	42998	42998	42998	42998	42999	42999	42999	42999	42999	42999	42999	42999	43000	43000	43000	43000	43000	43000	43001	5.5	5	0.2	7	2	2	2.5	6.5	0.8	0.6	0.2	0.6	2	1.5	3.5	6	4	1	2	1.6	0.2	1	1.5	5	5.5	4.8	6	1	5.5	3	7	5.5	1	1.5	6	8.5	0.2	0.2	1.5	0.2	1.5	6.5	1.5	2	5.5	6.5	0.2	8	0.2	8.5	7.5	0.2	0.2	2.5	2	7	8.5	0.8	0.2	1.4	1.2	11.5	0.2	1	1.5	5.5	0.2	0.2	4.5	1.5	1.5	5.5	3.5	0.2	4.5	5.5	0.2	0.2	5.5	1.5	0.6	6.5	12.5	0.2	0.2	0.2	1.5	0.2	0.5	6	1.2	0.5	0.5	5.5	0.2	0.2	5	6.5	0.2	1.2	10.5	3	0.2	0.2	0.2	5	1.5	0.2	0.2	1.2	4.5	6.5	5.5	4.2	2.4	1	6.5	5	4.5	5	5.5	1	6	6.5	1.5	0.2	0.2	0.2	6	1.5	1.5	1.2	0.4	5.5	0.2	0.2	0.2	2	1.5	0.2	1.2	2	2.5	0.2	2.5	5.5	1.2	0.4	0.5	1.6	0.5	0	3.5	2.2000000000000002	0	4.8	2	1.5	5	0.2	3	1	4.8	1.5	1.2	0.5	7	1.5	5.5	0.2	1.5	3.2	1	7	0.5	0.6	0.5	1	1.5	0.2	5.5	1.5	1	6	0.2	1.5	2	1.5	6.5	0.2	0.2	0.2	0.2	1.6	1.4	0.2	7.5	1.4	0.2	0.2	0.2	0.2	2.5	10	1.2	0.6	11	2.2000000000000002	4	0.5	0.4	4.5	1.5	1.5	0.6	5	5	0.2	4.5	0	5.5	7.5	5	1	0.2	0.2	0.2	0.2	0.2	6	7	0.2	0.2	0.2	1.2	10	0.2	2	0.6	9.5	3	0.5	6	0.5	1.6	2.2000000000000002	1.5	1.5	4.5	0.2	1.5	0.2	5.2	0.5	1.5	0.5	0	2.5	0.2	0.2	1	1.5	6	5	0.2	2	5.5	0.2	2	0.2	0.8	0.2	0.2	2	0.2	2	3	0.4	0.2	0.2	2	2.5	2.5	1.2	0.2	8	0.2	0.2	1.8	0.2	1	9	1.2	4.2	0.2	0.2	0.2	0.2	1.5	5	6	0.5	0.6	1.5	6	7	5.5	0.2	1.5	0.2	5	3	0	2	2	5.5	5.5	6	1.5	0.2	5.5	0.2	0.2	0.5	9	5.5	0.2	0.2	6.2	0.4	4	1	1.5	1.5	1.5	5	0.2	0.2	0.5	1.6	0.5	5	1.5	7.5	1.5	0.2	0.2	0.2	0.4	0.2	1.5	0.2	7	0.2	0.8	0.2	9	2.5	0.2	1	0.2	1.8	2	1	6	0.2	7	1.5	0.5	1	5.5	0.2	0.2	0.2	1.5	7.5	0.2	6.5	0.2	6.5	1.5	1.6	0.8	1.4	7	3	6.5	2	7	12.5	0.2	0.2	0.2	6.5	1.4	0.2	1.4	4.5	8.5	8	0.2	7.5	6	1.5	2.8	0.4	7	0.2	6	2	0.2	0.2	1.5	1	2	0.2	0.2	1.5	0.2	1.5	5.5	0.8	7	0.2	1.5	8.5	0.2	7	0.2	7	5.5	0.2	7.5	7.5	2	0.2	0.5	2.5	0.2	0.5	0.2	7.5	0.2	1.6	1.6	1.2	3	2.6	5	0.2	0.2	0.2	6.5	1	0.5	0.2	6	4.4000000000000004	2	7	0.2	0.2	0.2	0.2	1.5	0.2	2	1.5	6.5	8	7	0.2	1.5	0.2	0.2	0.2	2.5	0.5	9.5	0.2	
Book Resurrection.docx
Costs
Angus and Boris are the semi-retired co-owners of the bookshop, and do not take a salary.
Connor, however, is a part-time employee, with total employment costs of $22 per hour. Connor is also entitled to four weeks of paid annual leave, during which a casual replacement is required at a cost of $33 per hour.
Fixed costs such as rent and insurance are $2900 per year, and utilities costs are $140 per month.
Task 1 - Costs of operating the business
Using Excel, create a spreadsheet called operating_costs.xlsx that calculates the projected annual outgoing costs of running Book Resurrection.
Your spreadsheet should be configured such that the working hours, hourly rates, and fixed and utility costs can be varied easily.
Document your findings in your ePortfolio page (approximately 100 words).
Solution:
		
		Hourly Rates
		Working Hours
		Weeks
		Angus 
		0
		3.5
		52
		Boris
		0
		3.5
		52
		Connor
		22
		5
		48
		Connor Replacement
		33
		5
		4
		Rent and Insurance
		2900
		Utilities
		140
		
		
		Total 
		34280
The spreadsheet operating_costs.xlsx was made in such a way that one can easily edit working hours, hourly rates, and fixed and utility costs and the total annual cost will change on itself. For now, Angus and Boris are forking for free for 3 hours a day for all 52 weeks. But Connor asks for $22 per hour. He works for 5 hours a day for 48 weeks in a year. The total operational costs, also including the one-time rent and insurance and 12 times utilities cost, is equal to $34, 280.
Obtaining Books
Throughout the day, customers come to Book Resurrection to buy books, and occasionally to sell them. When people bring in books to sell to Book Resurrection, the staff member on duty will review the books and make an offer for each one individually. Currently, the process for determining how much the book shop will pay for a book is entirely subjective. Staff members offer an amount per book based on the quality of the book, and how popular they think it is, and how they are feeling at the time. The sale amount is always simply double the amount paid and is set at the same time - if Book Resurrection pays $3.00 for a book, they will put it on sale with a marked price of $6.00.
(Book Resurrection does not deal in rare or antique books)
For several months, staff have been keeping track of the date and time, quality, publication year and amount paid for each book in a spreadsheet. This spreadsheet is available for download on Moodle.
Task 2 - Sales team offers
Using Excel, process the history of purchases spreadsheet and use appropriate charts to visualize:
How the prices paid differed for each staff member; and
How the prices paid have changed over time
Describe your findings in your ePortfolio (approximately 250 words), and attach the Excel file to your page.
Solution:
Figure: Total prices offered for different books based on their condition 
The above figure tells the total prices that were offered to books based on their condition and type (Hardcover, paperback). 
Figure: Average prices offered for different books based on their condition
The above figure tells the average prices that were offered to books based on their condition and type (Hardcover, paperback). We can see that prices offered to good condition books are more than poor condition books which is even higher than terrible condition books. We can also observe that the hardcover books were paid more prices than paperback books.
Figure: Price paid over time
In the figure above we can see that the prices that were offered to different books over time. There is a large variation in the price offered and we cannot see any trend that can tell that there was either decrease or increase in price over time. 
Process automation
Angus and Boris 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.
Task 3 - Automation
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 Book Resurrection 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 (approx 150 words), and attach your Excel file to your ePortfolio.
Solution:
		Condition
		Publication Date
		Hardcover
		Good
		Older than 15 years
		Hardcover
		Poor
		15 years or newer
		Paperback
		Terrible
		
		
		Price
		Low
		3
		Medium
		6
		High
		12
The spreadsheet was made that give full freedom to change the prices (low, medium, high). For now, the low price is set to $3, medium price to $6 and high price to $12. The standard price was calculated using the flow chart decided by the staff and by using IF and AND statements in EXCEL.
Task 4 - Price setting
Using Excel and the historical data you have available, determine sets of prices which meet the objectives of the following scenarios:
Scenario one: Total offer prices are approximately the same as for the historical data
Solution:
		Price
		Low
		3
		Medium
		6
		High
		12
		Total
		Offer ($)
		1212.9
		Standard Price ($)
		1350
Scenario two: Assuming all books purchased are sold, allow all staff to draw the same wage as Connor.
Solution:
		
		Hourly Rates
		Working Hours
		Weeks
		Angus 
		22
		3.5
		52
		Boris
		22
		3.5
		52
		Connor
		22
		5
		48
		Connor Replacement
		33
		5
		4
		Rent and Insurance
		2900
		Utilities
		140
		
		
		Total 
		58304
Optional task 5
Re-implement Task 1 and Task 3 using either Python or HTML + JavaScript.
Write a brief overview of how to run your solution, and attach a zip file containing your code to your ePortfolio page.
Solution:
Please check the iPython (.ipynb) file and HTML file for code and execution of code.
Hardcover	Good	Poor	Terrible	590.70000000000005	92.799999999999969	1	Paperback	Good	Poor	Terrible	358.1	129.70000000000005	40.600000000000037	
Hardcover	Good	Poor	Terrible	7.3837500000000009	2.1090909090909085	1	Paperback	Good	Poor	Terrible	4.4209876543209878	1.2235849056603778	0.24166666666666689	
Offer ($)	42915	42915	42915	42916	42916	42916	42917	42917	42917	42917	42917	42917	42919	42919	42919	42919	42919	42919	42920	42920	42920	42920	42920	42920	42920	42921	42921	42921	42921	42921	42921	42921	42921	42921	42921	42922	42922	42922	42922	42922	42922	42922	42922	42922	42922	42922	42923	42923	42923	42923	42923	42923	42923	42923	42923	42923	42923	42924	42924	42924	42924	42924	42924	42926	42926	42926	42927	42927	42927	42928	42928	42928	42929	42929	42929	42929	42929	42929	42929	42929	42930	42930	42931	42931	42933	42933	42933	42933	42934	42934	42934	42934	42934	42934	42934	42935	42935	42935	42935	42936	42936	42936	42936	42936	42936	42936	42936	42936	42936	42937	42937	42938	42938	42940	42940	42940	42940	42941	42941	42941	42941	42941	42942	42942	42942	42942	42942	42942	42942	42942	42942	42943	42943	42943	42943	42943	42943	42943	42943	42943	42944	42944	42944	42944	42944	42945	42945	42945	42947	42947	42947	42947	42947	42947	42947	42947	42947	42947	42947	42947	42948	42948	42948	42948	42948	42948	42948	42948	42948	42948	42948	42949	42949	42949	42949	42949	42949	42949	42949	42949	42949	42949	42950	42950	42950	42950	42950	42950	42950	42950	42951	42951	42951	42951	42951	42951	42951	42951	42951	42951	42951	42951	42951	42951	42952	42952	42952	42954	42954	42954	42954	42954	42954	42954	42955	42955	42955	42955	42955	42956	42956	42956	42956	42956	42957	42957	42957	42957	42957	42957	42957	42957	42958	42958	42958	42958	42958	42958	42959	42959	42959	42961	42961	42961	42961	42961	42961	42961	42961	42961	42961	42962	42962	42962	42962	42962	42962	42962	42962	42962	42962	42962	42962	42962	42962	42963	42963	42963	42964	42964	42964	42964	42964	42964	42964	42964	42965	42965	42965	42965	42965	42965	42965	42966	42966	42966	42966	42966	42966	42966	42966	42966	42968	42968	42968	42968	42968	42968	42968	42968	42968	42969	42969	42969	42969	42969	42969	42969	42969	42969	42969	42970	42970	42970	42970	42970	42970	42970	42970	42970	42970	42971	42972	42972	42972	42973	42973	42973	42975	42975	42975	42975	42975	42975	42975	42975	42975	42975	42976	42976	42976	42976	42977	42977	42977	42977	42978	42978	42978	42978	42978	42978	42978	42978	42979	42979	42979	42979	42980	42980	42980	42982	42982	42982	42982	42982	42982	42982	42983	42983	42983	42983	42983	42983	42983	42984	42984	42984	42984	42984	42984	42985	42985	42985	42985	42985	42985	42985	42985	42986	42986	42986	42986	42987	42987	42987	42987	42987	42987	42987	42987	42987	42989	42989	42990	42990	42990	42990	42990	42990	42990	42990	42990	42990	42991	42991	42991	42991	42991	42991	42991	42992	42992	42992	42992	42992	42992	42992	42992	42992	42992	42993	42993	42993	42993	42993	42993	42993	42993	42993	42993	42993	42994	42994	42994	42994	42994	42996	42996	42996	42996	42996	42996	42997	42997	42997	42997	42998	42998	42998	42998	42998	42998	42998	42998	42999	42999	42999	42999	42999	42999	42999	42999	43000	43000	43000	43000	43000	43000	43001	5.5	5	0.2	7	2	2	2.5	6.5	0.8	0.6	0.2	0.6	2	1.5	3.5	6	4	1	2	1.6	0.2	1	1.5	5	5.5	4.8	6	1	5.5	3	7	5.5	1	1.5	6	8.5	0.2	0.2	1.5	0.2	1.5	6.5	1.5	2	5.5	6.5	0.2	8	0.2	8.5	7.5	0.2	0.2	2.5	2	7	8.5	0.8	0.2	1.4	1.2	11.5	0.2	1	1.5	5.5	0.2	0.2	4.5	1.5	1.5	5.5	3.5	0.2	4.5	5.5	0.2	0.2	5.5	1.5	0.6	6.5	12.5	0.2	0.2	0.2	1.5	0.2	0.5	6	1.2	0.5	0.5	5.5	0.2	0.2	5	6.5	0.2	1.2	10.5	3	0.2	0.2	0.2	5	1.5	0.2	0.2	1.2	4.5	6.5	5.5	4.2	2.4	1	6.5	5	4.5	5	5.5	1	6	6.5	1.5	0.2	0.2	0.2	6	1.5	1.5	1.2	0.4	5.5	0.2	0.2	0.2	2	1.5	0.2	1.2	2	2.5	0.2	2.5	5.5	1.2	0.4	0.5	1.6	0.5	0	3.5	2.2000000000000002	0	4.8	2	1.5	5	0.2	3	1	4.8	1.5	1.2	0.5	7	1.5	5.5	0.2	1.5	3.2	1	7	0.5	0.6	0.5	1	1.5	0.2	5.5	1.5	1	6	0.2	1.5	2	1.5	6.5	0.2	0.2	0.2	0.2	1.6	1.4	0.2	7.5	1.4	0.2	0.2	0.2	0.2	2.5	10	1.2	0.6	11	2.2000000000000002	4	0.5	0.4	4.5	1.5	1.5	0.6	5	5	0.2	4.5	0	5.5	7.5	5	1	0.2	0.2	0.2	0.2	0.2	6	7	0.2	0.2	0.2	1.2	10	0.2	2	0.6	9.5	3	0.5	6	0.5	1.6	2.2000000000000002	1.5	1.5	4.5	0.2	1.5	0.2	5.2	0.5	1.5	0.5	0	2.5	0.2	0.2	1	1.5	6	5	0.2	2	5.5	0.2	2	0.2	0.8	0.2	0.2	2	0.2	2	3	0.4	0.2	0.2	2	2.5	2.5	1.2	0.2	8	0.2	0.2	1.8	0.2	1	9	1.2	4.2	0.2	0.2	0.2	0.2	1.5	5	6	0.5	0.6	1.5	6	7	5.5	0.2	1.5	0.2	5	3	0	2	2	5.5	5.5	6	1.5	0.2	5.5	0.2	0.2	0.5	9	5.5	0.2	0.2	6.2	0.4	4	1	1.5	1.5	1.5	5	0.2	0.2	0.5	1.6	0.5	5	1.5	7.5	1.5	0.2	0.2	0.2	0.4	0.2	1.5	0.2	7	0.2	0.8	0.2	9	2.5	0.2	1	0.2	1.8	2	1	6	0.2	7	1.5	0.5	1	5.5	0.2	0.2	0.2	1.5	7.5	0.2	6.5	0.2	6.5	1.5	1.6	0.8	1.4	7	3	6.5	2	7	12.5	0.2	0.2	0.2	6.5	1.4	0.2	1.4	4.5	8.5	8	0.2	7.5	6	1.5	2.8	0.4	7	0.2	6	2	0.2	0.2	1.5	1	2	0.2	0.2	1.5	0.2	1.5	5.5	0.8	7	0.2	1.5	8.5	0.2	7	0.2	7	5.5	0.2	7.5	7.5	2	0.2	0.5	2.5	0.2	0.5	0.2	7.5	0.2	1.6	1.6	1.2	3	2.6	5	0.2	0.2	0.2	6.5	1	0.5	0.2	6	4.4000000000000004	2	7	0.2	0.2	0.2	0.2	1.5	0.2	2	1.5	6.5	8	7	0.2	1.5	0.2	0.2	0.2	2.5	0.5	9.5	0.2	
Book Resurrection.ipynb
{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Annual Operational Cost: $34280.0
"
     ]
    }
   ],
   "source": [
    "hourlyPay = [0, 0, 22, 33]
",
    "workingHours = [3.5, 3.5, 5, 5]
",
    "annualWorkingDays = [156, 156, 240, 20]
",
    "
",
    "temp = [a*b for a,b in zip(hourlyPay, workingHours)]
",
    "totalSalary = sum([a*b for a,b in zip(temp, annualWorkingDays)])
",
    "
",
    "rentInsurance = 2900
",
    "utilities = 140
",
    "
",
    "total = rentInsurance + utilities*12 + totalSalary
",
    "print('Annual Operational Cost: $' + str(total))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "def standardPrice(quality, date, cover):
",
    "    low = 3
",
    "    medium = 6
",
    "    high = 12
",
    "    if quality.lower() == "t":
",
    "        return 0
",
    "    elif quality.lower() == "p":
",
    "        return low
",
    "    else:
",
    "        if date.lower() == "o":
",
    "            return low
",
    "        else:
",
    "            if cover.lower() == "p":
",
    "                return medium
",
    "            else:
",
    "                return high
",
    "
",
    "def promptUser():
",
    "    print('T = Terrible, P = Poor, G = Good')
",
    "    while True:
",
    "        qual = input('Enter Quality: ')
",
    "        if qual.lower() == "t":
",
    "            break
",
    "        elif qual.lower() == "p":
",
    "            break
",
    "        elif qual.lower() == "g":
",
    "            break
",
    "        else:
",
    "            print('Please enter a valid input')
",
    "
",
    "    print('O = Older than 15 years, N = 15 years or newer')
",
    "    while True:
",
    "        dt = input('Enter Publication Date: ')
",
    "        if dt.lower() == "o":
",
    "            break
",
    "        elif dt.lower() == "n":
",
    "            break
",
    "        else:
",
    "            print('Please enter a valid input')
",
    "
",
    "    print('H = Hardcover, P = Paperback')
",
    "    while True:
",
    "        cvr = input('Enter Type: ')
",
    "        if cvr.lower() == "h":
",
    "            break
",
    "        elif cvr.lower() == "p":
",
    "            break
",
    "        else:
",
    "            print('Please enter a valid input')
",
    "            
",
    "    print('Price: $' + str(standardPrice(qual, dt, cvr)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "T = Terrible, P = Poor, G = Good
",
      "Enter Quality: T
",
      "O = Older than 15 years, N = 15 years or newer
",
      "Enter Publication Date: O
",
      "H = Hardcover, P = Paperback
",
      "Enter Type: H
",
      "Price: $0
"
     ]
    }
   ],
   "source": [
    "promptUser()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "T = Terrible, P = Poor, G = Good
",
      "Enter Quality: G
",
      "O = Older than 15 years, N = 15 years or newer
",
      "Enter Publication Date: N
",
      "H = Hardcover, P = Paperback
",
      "Enter Type: P
",
      "Price: $6
"
     ]
    }
   ],
   "source": [
    "promptUser()"
   ]
  }
 ],
 "metadata": {
  "anaconda-cloud": {},
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
operating_costs.xlsx
Operation
				Hourly Rates		Working Hours		Weeks
		Angus 		22		3.5		52
		Boris		22		3.5		52
		Connor		22		5		48
		Connor Replacement		33		5		4
		Rent and Insurance		2900
		Utilities		140
		Total 		58304

CRICOS Provider No. 00103D Page 1 of 5 ITECH1100 Understanding the Digital Revolution Assignment 1 - Book Resurrection Overview For this individual assignment, you will use skills acquired through...

Answer To: CRICOS Provider No. 00103D Page 1 of 5 ITECH1100 Understanding the Digital Revolution Assignment 1 -...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment