ABCDEFGHIJKL
1
In this Project you need to prepare a calculator which can be used in such a way that whenever you give certain inputs you will get a
calculated price which can be precisely given to customers for payment or they can summarize their travel expenditure when they are planning.
2
3
4
5
Table 1
6
7
8
Cab typeValidity StartValidity EndPrice per day
9
Swift Dzire01/01/202130/04/20211200
10
Swift Dzire01/05/202131/12/20211300
11
Innova01/01/202130/04/20212100
12
Innova01/05/202131/12/20212200
13
Ertiga01/01/202130/04/20212800
14
Ertiga01/05/202131/12/20213000
15
16
17
18
Input Table
19
20
Car TypeSwift DzireTotal Cab DayCab/day PriceTotal Price for CabFinal cab price
21
Trip Start Date15/1/2021Trip Start Date35228009856001255600
22
Trip End Date25/08/2021Trip End Date903000270000
23
No. of Cabs6Sample 1
24
25
26
27
28
29
30
Questions
31
1. Write scripts in each of the cell in table below such that whenever you push inputs in input table you will
get output like in sample 1 ?
32
33
34
35
Total Cab DayCab/day PriceTotal Price for CabFinal cab priceWrite your script here
36
Trip Start Date10512001260001660800
37
Trip End Date1161300150800
38
39