Switch To
Product Links
Languages
Themes
Feedback
Sign Up Now
VBA Editor
Coriander Green
Metallic Grey
Coriander Green
Metallic Grey
Loading...
Updating...
Please wait to edit...
Ready for editing
X
Local File
URL
Name of the Document:
Note:-
- Supported file formats: xls, xlsx, sxc, ods, csv and tsv
- Only unprotected files will be imported
CSV files have data in a structured format similar to a database table. Choose the desired import option based on the recommendations provided below:
Import as...
Tabular Data
Recommended for...
- Creating PIVOT Tables and Charts
- Faster loading and performance
- Auto Filters and Freeze Columns
Normal Spreadsheet
Useful for...
- Formatting options
- Formulas & Calculations, and
- Other regular spreadsheet operations
NOTE:
There will be no option inside the document to toggle between these two views.
Spreadsheet Name:
Template Name:
Save As New Document...
Save As New Template...
Mark As New Version...
New Template
From Templates List
Show Text Only
Show Icons Only
Show Icons & Text
I376
by
jksheeks
5135 views
Print
Export
Copy to My Account
Embed in Website/Blog
Tags:
Macro recorded successfully
View Macro
Macros List
|
Unsupported actions
|
Macro Recording in progress
Stop Recording
Cancel
|
Unsupported actions
|
Arial
Arial Black
Book Antiqua
Calibri
Comic Sans MS
Courier New
Garamond
Georgia
Lucida Console
MingLiU
MS Gothic
MS P Gothic
MS Mincho
MS P Mincho
MS Sans Serif
SimHei
Tahoma
Times New Roman
Trebuchet MS
Verdana
8
9
10
11
12
14
16
18
20
24
26
$
Macros
Auto Filter
Freeze Columns
This worksheet is a tabular data. Regular spreadsheet operations like cut/copy/paste, undo/redo, range selection, formulas and formatting are restricted in this mode.
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
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
56
57
58
59
60
61
Edit
|
Publish
|
Revert Publish
|
URL
|
Clone
Lease Purchasing a Truck -- The Economics
Assumption Table
Compensation
Compensateded Miles
135,000
Gross Compensation - Miles
$110,700
Uncompensated Miles as % of Total Miles
20%
Excess Miles Penalty
$1,470
Total Miles
162,000
Net Compensation
$109,230
Compensation Rate / Per Mile
$0.82
Direct Costs
Excess Miles Limit / Yr.
120,000
Excess Miles Penalty / Cents per Mile
$0.0350
Fuel
$41,186
Maintenance Reserve Escrow
$8,100
Fuel Price / Gal.
$1.50
Repairs
$6,272
Average MPG
5.90
Tractor Tires
$2,198
Fuel Price / Mile
$0.2542
Qualcom
$1,374
Fuel
$41,186.44
Road, Fuel, Property, Highway Taxes
$1,864
Loading / Unloading
$1,617
Maintenance Reserve / cents/mile
$0.05
Licenses
$1,753
Maintenance Reserve Escrow
$8,100
Permits
$579
Telephone
$2,057
Weekly Lease Payment
$425.00
Truck Washing
$671
Fines & Tickets
$300
Annual Lease Payment
$22,100.00
Subtotal Direct Costs
$67,971
Insurance
Physical Damage
$2,377
Non-trucking Liability
$831
Cargo
$1,469
Workmens' Comp / OccAcc
$2,015
Subtotal Insurance
$6,692
Indirect Costs
Bookkeeping
$600
Meals
$5,500
Lodging
$685
Medical Insurance
$3,400
Miscelleanous Expenses
$4,700
Subtotal Indirect Costs
$14,885
Annual Lease Payment
$22,100
Net Income
$-2,418
Sheet1
0 Viewing
Export (.xls)
Export (.pdf)
Export (.xls)
Export (.pdf)
Export (.xls)
Export (.pdf)
Processing...
Assign Macro
Change Macro
View Code
Edit Label
More