1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
|
#!/usr/bin/env python3
# -*- coding: utf-8 -*-
import datetime
import openpyxl
# Let's call the excel file "data.xlsx"
filename = 'data.xlsx'
try:
# Try opening the file
wb = openpyxl.load_workbook(filename)
# If it exists, get the active worksheet
sheet = wb.active
except FileNotFoundError:
# If the file didn't exist, create it
wb = openpyxl.Workbook()
sheet = wb.active
# Append some header data
sheet.append(['Timestamp', 'Total price', 'Amount given', 'Tip', 'Trip distance', 'Net tip'])
# Rename the sheet
sheet.title = 'Delivery tracker'
# Save the file
wb.save(filename)
gas_cost = 0.08 #how much it costs to drive 1 mile
wear_tear = 0.1 #estimated 10 cents per mile in tire and engine wear
mpg = 30 # my car gets 30 miles per gallon
delivery_charge = 1.25 # dominos pays the driver $1.25 each delivery
while True:
now = datetime.datetime.now()
print("|||WELCOME TO TIP TRACKER. ALL OF THE DATA SHOWN IS BASED ON 30 MPG AT $2.60/GALLON AND 10ยข OF WEAR'N'TEAR EACH MILE|||")
total_price = float(input('Total Price: ')) #Total price of order
amt_given = float(input('Amount Given: ')) #Total amount of money received from customer
tip = amt_given - total_price #This is your total Gross Tip
print('Tip given = {}'.format(tip)) #This prints your tip and saves the tip as a variable ( I think..lol)
trip_distance = float(input('Miles: ')) # This is your round trip distance in miles
print ("Your net tip is...")
net_tip = tip + delivery_charge -(gas_cost + wear_tear * trip_distance) #This prints your Net Tip after factoring in the delivery charge, gas, and wear n tear
print (net_tip)
timestamp = now.strftime("%Y-%m-%d %H:%M:%S")
print ("Current date and time : ")
print (timestamp)
# Store the data in a new row in the file
sheet.append([timestamp, total_price, amt_given, tip, trip_distance, net_tip])
# Save the document
wb.save(filename)
|
