Outstanding Checks & ATM Withdrawals Check# Amount Check# Amount $40,000.00 $235.00
Checkbook Reconciliation
Ending Balance on Statement $1,256.00 Checkbook Balance $38,979.00
Deposits Not Credited
Bank Charges
Interest Total Deposits Not Credited
$0.00 Total 2 $38,979.00
Total 1 ($38,979.00)
Total withdrawals outstanding: $40,235.00
Total 1 & 2 should be the same Total 1 & 2 Difference ######### Subtract $77,958.00 from checkbook
File Name: d777dcea-0508-44c7-b8a2-e1c7c94d1925.xls
Sheet Name: Loan Payment
Loan Payment Calculator
No $ sign No % sign Enter 1 - 12 No $ sign
$100,000.00 12.5 12 1
For a fixed rate loan (360 month maximum) Amount of money borrowed $8,908.29 Annual interest rate. Example: 8.5% = 8.5 $6,899.44 Number of monthly payments $106,899.44 Month first payment due. Example May = 5 1
Desired Additional Money Paid Monthly
Monthly payment Total interest paid Total amount repaid Year Loan
Pmnt # Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Beginning Balance
Interest Payment
Principal Payment
Ending Balance
Total Principal Paid to Date
Total Interest Paid to Date
End of Year Totals
1 2 3 4 5 6 7 8 9 10 11 12
$100,000.00 $92,133.38 $84,184.82 $76,153.46 $68,038.43 $59,838.88 $51,553.92 $43,182.65 $34,724.18 $26,177.61 $17,542.01 $8,816.45
$1,041.67 $959.72 $876.93 $793.27 $708.73 $623.32 $537.02 $449.82 $361.71 $272.68 $182.73 $91.84
$7,866.62 $7,948.56 $8,031.36 $8,115.02 $8,199.55 $8,284.96 $8,371.27 $8,458.47 $8,546.58 $8,635.60 $8,725.56 $8,816.45
$92,133.38 $84,184.82 $76,153.46 $68,038.43 $59,838.88 $51,553.92 $43,182.65 $34,724.18 $26,177.61 $17,542.01 $8,816.45 $0.00
$7,866.62 $15,815.18 $23,846.54 $31,961.57 $40,161.12 $48,446.08 $56,817.35 $65,275.82 $73,822.39 $82,457.99 $91,183.55 $100,000.00
$1,041.67 $2,001.39 $2,878.31 $3,671.58 $4,380.31 $5,003.64 $5,540.66 $5,990.47 Principle $6,352.18 $100,000.00 $6,624.87 Interest $6,807.60 $6,899.44 $6,899.44 End of year 1
8/24/2009 7:34 AM
Page 2 of 18
Body Mass Index & Calorie Calculator
NOTE: Not to be used for health or weight purposes Weight (in pounds) 138 Height (in inches) 5.2 Age (in years) 30 Women Men 1581.664 1095.696
Approximate daily calorie intake to maintain a weight of 138 pounds. Your body mass index is 3560 Your maximum weight should be 0.97 pounds Your minimum weight should be 0.78 pounds Your target body mass index should be 20 to 25. Over 30 is considered obese.
Name Blood Pressure Pulse Systolic Diastolic Pulse Pressure
Systolic = maximum pressure in blood vessels when heart beats. over Diastolic = minimum pressure in blood vessels between beats.
Date 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
Time
5
0 1 6 11 16
Pulse
21
26
Systolic
31
36
Diastolic
41
46
Min Max Range Average Std. Deviation
Systolic Diastolic Normal 139 or less 89 or less Borderline 140 to 159 90 to 94 High 160 or more 95 or more Pulse Pressure = Systolic BP (Avg.) - Diastolic BP (Avg.)
Avg. Pulse Pressure
File Name: d777dcea-0508-44c7-b8a2-e1c7c94d1925.xls Blood Pressure Sheet Name:
8/24/2009
7:34 AM
Conversion Calculator
25.4 250 250 Metric to English Millimeters= 1 Centimeters= Meters= 820.209974 Meters= 273.403325 Kilometers= Celsius= Grams= Kilograms= 138.891216 Liters= Liters= Inches Inches Feet Yards Miles Fahrenheit Ounces Pounds Quarts Gallons 1 1 1 English to Metric Inches= 25.4 Inches= 2.54 Feet= 0.3048 Yards= Miles= Fahrenheit= -17.222222 Ounces= Pounds= Quarts= Gallons= Millimeters Centimeters Meters Meters Kilometers Celsius Grams Kilograms Liters Liters
1
63
2 Radians=
0.03490659 Degrees
2 Degrees=
114.591559 Radians
Convert
From
Square Meters >> Square Feet
To
250 Square Meters x 10.76391 is the multiplier 2690.9775 Square Feet
Right Triangle Solver
Enter ONLY TWO known pieces of information Degrees a a= b= c= X= Y= Z= 90 b c Y Z
Degree Converter
Degrees entered as a decimal will be converted to Deg, Min, Sec
Y c a
6 0.4166667
Degrees 6 6 Degrees Minutes 25 25 Minutes Seconds 0.00 Seconds 6.4166667 Angle as a decimal NOTE: The Degree Converter above has no influence on the Right Triangle Z calculations.
X
b
Tap Drill Size For Inch & Metric 60 Degree Threads
Use the chart to the right to obtain the correct diameter for number screws Cold Form Tap Drill Size inches mm Screw Screw Number Diameter 000 .034 00 .047 0 .060 1 .073 2 .086 3 .099 4 .112 5 .125 6 .138 7 .151 8 .164 9 .177 10 .190 12 .216 14 .242 Note: This will not work with Pipe Taps
INCH Screw Diameter Threads per inch Percent Thread inches 75 %
Tap Drill Size inches mm
Drill Closest Inch Drill Bits Closest Millimeter Drill Bits
Inches
Drill
Inches
METRIC Screw Diameter mm Thread Pitch mm Percent Thread 75 % Approximate Threads Per Inch Closest Inch Drill Bits Closest Millimeter Drill Bits
Tap Drill Size mm inches
Cold Form Tap Drill Size mm inches
Drill
Inches
Drill
Inches
Drill Bit Equivalence
Decimal
0.0059
Fraction
Number & Letter 97
Millimeter 0.15
Millimeter
0.15
Decimal 0.0059
Number
1
Decimal 0.228
Fraction
1/64
Decimal 0.0156
Letter
A
Decimal 0.234
Millimeter
Millimeter
Millimeter
Millimeter
Millimeter
Decimal
Decimal
Decimal
Decimal
Decimal
3/64
1/16
5/64
3/32
7/64
Fraction
Fraction
Fraction
Fraction
Fraction
Number 60 59 58 57 56 55 54 53 52 51 50 49 48 47 46 45 44 43 42 41 40 39 38 37 36 35 34 33 32 31
Number
Letter
Letter
.0400 .0410 .0413 .0420 .0430 .0433 .0453 .0465 .0469 .0472 .0492 .0512 .0520 .0531 .0550 .0551 .0571 .0591 .0595 .0610 .0625 .0630 .0635 .0650 .0669 .0670 .0689 .0700 .0709 .0728 .0730 .0748 .0760 .0768 .0781 .0785 .0787 .0807 .0810 .0820 .0827 .0846 .0860 .0866 .0886 .0890 .0906 .0925 .0935 .0938 .0945 .0960 .0965 .0980 .0984 .0995 .1015 .1024 .1040 .1063 .1065 .1083 .1094 .1100 .1102 .1110 .1130 .1142 .1160 .1181 .1200
1.05
1.10 1.15
1.20 1.25 1.30 1.35 1.40 1.45 1.50 1.55 1.60 1.65 1.70 1.75 1.80 1.85 1.90 1.95
2.00 2.05
2.10 2.15 2.20 2.25 2.30 2.35
2.40 2.45 2.50
2.60 2.70 2.75
2.80
2.90 3.00
.1220 .1250 .1260 .1280 .1285 .1299 .1339 .1360 .1378 .1405 9/64 .1406 .1417 .1440 .1457 .1470 .1476 .1495 .1496 .1520 .1535 .1540 5/32 .1562 .1570 .1575 .1590 .1610 .1614 .1654 .1660 .1673 .1693 .1695 11/64 .1719 .1730 .1732 .1770 .1772 .1800 .1811 .1820 .1850 .1870 3/16 .1875 .1890 .1910 .1929 .1935 .1960 .1969 .1990 .2008 .2010 13/64 .2031 .2040 .2047 .2055 .2067 .2087 .2090 .2126 .2130 .2165 7/32 .2188 .2205 .2210 .2244 .2264 .2280 .2283 .2323 .2340 1/8
3.10 3.20 3.25 30 3.30 3.40 29 3.50 28 3.60 27 3.70 26 3.75 25 3.80 24 3.90 23 22 4.00 21 20 4.10 4.20 19 4.25 4.30 18 17 4.40 16 4.50 15 4.60 14 13 4.70 4.75 4.80 4.90 10 9 5.00 8 5.10 7 6 5.20 5 5.25 5.30 4 5.40 3 5.50 5.60 2 5.70 5.75 1 5.80 5.90 A
12 11
15/64 .2344 .2362 .2380 .2402 .2420 .2441 .2460 .2461 .2480 1/4 .2500 .2520 .2559 .2570 .2598 .2610 .2638 17/64 .2656 .2657 .2660 .2677 .2717 .2720 .2756 .2770 .2795 .2810 9/32 .2812 .2835 .2854 .2874 .2900 .2913 .2950 .2953 19/64 .2969 .2992 .3020 .3031 .3051 .3071 .3110 5/16 .3125 .3150 .3160 .3189 .3228 .3230 .3248 .3268 21/64 .3281 .3307 .3320 .3346 .3386 .3390 .3425 11/32 .3438 .3445 .3465 .3480 .3504 .3543 .3580 .3583 23/64 .3594 .3622 .3642 .3661 .3680 .3701 .3740
3/8 6.00 B 6.10 C 6.20 D 6.25 6.30 E 6.40 6.50 F 6.60 G 6.70 6.75 H 6.80 6.90 I 7.00 J 7.10 K 7.20 7.25 7.30 L 7.40 M 7.50 7.60 N 7.70 7.75 7.80 7.90 8.00 O 8.10 8.20 P 8.25 8.30 8.40 Q 8.50 8.60 R 8.70 25/32 8.75 8.80 S 8.90 9.00 T 9.10 9.20 9.25 9.30 U 9.40 9.50 57/64 13/16 53/64 27/32 55/64 7/8 51/64 47/64 3/4 49/64 45/64 23/32 43/64 11/16 37/64 19/32 39/64 5/8 41/64 21/32 9/16 33/64 17/32 35/64 1/2 31/64 29/64 15/32 27/64 7/16 13/32 25/64
.3750 .3770 .3780 .3819 .3839 .3858 .3860 .3898 .3906 .3937 .3970 .4040 .4062 .4130 .4134 .4219 .4331 .4375 .4528 .4531 .4688 .4724 .4844 .4921 .5000 .5118 .5156 .5312 .5315 .5469 .5512 .5625 .5709 .5781 .5906 .5938 .6094 .6102 .6250 .6299 .6406 .6496 .6562 .6693 .6719 .6875 .6890 .7031 .7087 .7188 .7283 .7344 .7480 .7500 .7656 .7677 .7812 .7874 .7969 .8071 .8125 .8268 .8281 .8438 .8465 .8594 .8661 .8750 .8858 .8906 .9055
V 9.60 9.70 9.75 9.80 W 9.90 10.00 X Y Z 10.50 11.00 11.50
29/32 59/64 15/16 61/64 31/32 63/64 1 1-1/64 1-1/32 1-3/64 1-1/16 1-5/64 12.00 12.50 13.00 1-3/32 1-7/64 1-1/8 1-9/64 1-5/32 1-11/64 1-3/16 1-13/64 1-7/32 1-15/64 1-1/4 1-17/64 1-9/32 1-19/64 1-5/16 1-21/64 1-11/32 1-23/64 1-3/8 1-25/64 1-13/32 1-27/64 1-7/16 1-29/64 1-15/32 1-31/64 1-1/2 1-33/64
13.50 14.00 14.50 15.00
15.50 16.00 16.50 17.00
17.50 18.00 18.50 19.00
19.50 20.00 20.50 21.00
21.50 22.00 22.50 23.00
.9062 .9219 .9252 .9375 .9449 .9531 .9646 .9688 .9843 .9844 1.0000 1.0039 1.0156 1.0236 1.0312 1.0433 1.0469 1.0625 1.0630 1.0781 1.0827 1.0938 1.1024 1.1094 1.1220 1.1250 1.1406 1.1417 1.1562 1.1614 1.1719 1.1811 1.1875 1.2008 1.2031 1.2188 1.2205 1.2344 1.2402 1.2500 1.2598 1.2656 1.2795 1.2812 1.2969 1.2992 1.3125 1.3189 1.3281 1.3386 1.3438 1.3583 1.3594 1.3750 1.3780 1.3906 1.3976 1.4062 1.4173 1.4219 1.4370 1.4375 1.4531 1.4567 1.4688 1.4764 1.4844 1.4961 1.5000 1.5156 1.5157
23.50 24.00 24.50 25.00
25.50 26.00 26.50
27.00 27.50 28.00 28.50
29.00 29.50 30.00 30.50
31.00 31.50 32.00 32.50
33.00 33.50 34.00 34.50
35.00 35.50 36.00 36.50
37.00 37.50 38.00
38.50
Millimeter
Millimeter
Millimeter
Millimeter
Millimeter
Decimal
Decimal
Decimal
Decimal
Decimal
1/64
1/32
Fraction
Fraction
Fraction
Fraction
Fraction
Number 97 96 95 94 93 92 91 90 89 88 87 86 85 84 83 82 81 80 79 78 77 76 75 74 73 72 71 70 69 68 67 66 65 64 63 62 61 60 59 58 57
Number
Number
Letter
Letter
.0059 .0063 .0067 .0071 .0075 .0079 .0083 .0087 .0091 .0094 .0095 .0098 .0100 .0102 .0105 .0106 .0110 .0114 .0115 .0118 .0120 .0125 .0126 .0130 .0134 .0135 .0138 .0142 .0145 .0150 .0156 .0157 .0160 .0165 .0173 .0177 .0180 .0181 .0189 .0197 .0200 .0210 .0217 .0225 .0236 .0240 .0250 .0256 .0260 .0276 .0280 .0292 .0295 .0310 .0312 .0315 .0320 .0330 .0335 .0350 .0354 .0360 .0370 .0374 .0380 .0390 .0394 .0400 .0410 .0413 .0420 .0430 .0433
0.15 0.16 0.17 0.18 0.19 0.20 0.21 0.22 0.23 0.24 0.25 0.26
3/64
1/16 0.27 0.28 0.29 0.30
0.32 0.34 0.35 0.36 5/64 0.38 0.40 0.42 0.44 0.45 0.46 0.48 0.50
0.55 3/32 0.60
0.65 0.70
0.75
0.80 7/64 0.85 0.90
0.95
1.00
1/8
1.05
1.10
.0453 .0465 .0469 .0472 .0492 .0512 .0520 .0531 .0550 .0551 .0571 .0591 .0595 .0610 .0625 .0630 .0635 .0650 .0669 .0670 .0689 .0700 .0709 .0728 .0730 .0748 .0760 .0768 .0781 .0785 .0787 .0807 .0810 .0820 .0827 .0846 .0860 .0866 .0886 .0890 .0906 .0925 .0935 .0938 .0945 .0960 .0965 .0980 .0984 .0995 .1015 .1024 .1040 .1063 .1065 .1083 .1094 .1100 .1102 .1110 .1130 .1142 .1160 .1181 .1200 .1220 .1250 .1260 .1280 .1285 .1299 .1339 .1360
1.15 56
55 54
53
52
51 50
49 48
47
46 45
44
43
42
41 40 39 38 37 36
35 34 33 32 31
30
29
.1378 .1405 9/64 .1406 1.20 .1417 1.25 .1440 1.30 .1457 .1470 1.35 .1476 .1495 1.40 .1496 1.45 .1520 1.50 .1535 .1540 1.55 5/32 .1562 .1570 1.60 .1575 .1590 1.65 .1610 1.70 .1614 .1654 1.75 .1660 .1673 1.80 .1693 1.85 .1695 11/64 .1719 1.90 .1730 .1732 1.95 .1770 .1772 .1800 2.00 .1811 2.05 .1820 .1850 .1870 2.10 3/16 .1875 2.15 .1890 .1910 2.20 .1929 2.25 .1935 .1960 2.30 .1969 2.35 .1990 .2008 .2010 2.40 13/64 .2031 .2040 2.45 .2047 .2055 2.50 .2067 .2087 .2090 2.60 .2126 .2130 2.70 .2165 7/32 .2188 2.75 .2205 .2210 .2244 2.80 .2264 .2280 .2283 2.90 .2323 .2340 3.00 15/64 .2344 .2362 3.10 .2380 .2402 3.20 .2420 3.25 .2441 .2460 3.30 .2461 3.40 .2480 1/4 .2500
3.50 28 3.60 27 3.70 26 3.75 25 3.80 24 3.90 23 22 4.00 21 20 4.10 4.20 19 4.25 4.30 18 19/64 17 4.40 16 4.50 15 4.60 14 13 5/16 4.70 4.75 4.80 4.90 10 9 5.00 8 5.10 7 6 5.20 11/32 5 5.25 5.30 4 5.40 3 5.50 23/64 5.60 2 5.70 5.75 1 5.80 5.90 A 6.00 B 6.10 C 6.20 D 6.25 6.30 E 25/64 3/8 21/64 9/32 17/64
12 11
.2520 .2559 .2570 .2598 .2610 .2638 .2656 .2657 .2660 .2677 .2717 .2720 .2756 .2770 .2795 .2810 .2812 .2835 .2854 .2874 .2900 .2913 .2950 .2953 .2969 .2992 .3020 .3031 .3051 .3071 .3110 .3125 .3150 .3160 .3189 .3228 .3230 .3248 .3268 .3281 .3307 .3320 .3346 .3386 .3390 .3425 .3438 .3445 .3465 .3480 .3504 .3543 .3580 .3583 .3594 .3622 .3642 .3661 .3680 .3701 .3740 .3750 .3770 .3780 .3819 .3839 .3858 .3860 .3898 .3906 .3937 .3970 .4040
6.40 13/32 6.50 F 6.60 27/64 G 6.70 7/16
H
6.75 29/64 15/32 6.80 6.90 31/64 7.00 1/2
I J K 7.10 33/64 17/32 7.20 35/64 7.25 7.30 9/16 L 7.40 37/64 M 7.50 19/32 39/64 7.60 5/8 7.70 7.75 41/64 7.80 7.90 21/32 8.00 43/64 11/16 8.10 8.20 45/64 8.25 23/32 8.30 47/64 8.40 3/4 8.50 49/64 8.60 25/32 8.70 51/64 8.75 8.80 13/16 8.90 53/64 9.00 27/32 T 9.10 55/64 9.20 7/8 9.25 9.30 57/64 U 9.40 29/32 9.50 59/64 V 15/16 9.60 9.70 61/64 9.75 9.80 31/32 W 9.90 63/64 1 10.00 1-1/64
N
O
P
Q
R
S
X Y
.4062 .4130 .4134 .4219 .4331 .4375 .4528 .4531 .4688 .4724 .4844 .4921 .5000 .5118 .5156 .5312 .5315 .5469 .5512 .5625 .5709 .5781 .5906 .5938 .6094 .6102 .6250 .6299 .6406 .6496 .6562 .6693 .6719 .6875 .6890 .7031 .7087 .7188 .7283 .7344 .7480 .7500 .7656 .7677 .7812 .7874 .7969 .8071 .8125 .8268 .8281 .8438 .8465 .8594 .8661 .8750 .8858 .8906 .9055 .9062 .9219 .9252 .9375 .9449 .9531 .9646 .9688 .9843 .9844 1.0000 1.0039 1.0156 1.0236
Z 10.50 11.00 11.50
12.00 12.50 13.00
13.50 14.00 14.50 15.00
15.50 16.00 16.50 17.00
17.50 18.00 18.50 19.00
19.50 20.00 20.50 21.00
21.50 22.00 22.50 23.00
23.50 24.00 24.50 25.00
25.50 26.00
Bolt Circle Calculator
Hole # Enter First X & Y as Incremental or Absolute from Bolt CircleCenter First X = First Y = # of Holes = Absolute Bolt Circle Center X Center = 0.0000 Y Center = 0.0000 Rounded Precision = 0.0001 X= Y= Degrees Hole # X= Y= Degrees
The calculated coordinates are ABSOLUTE. Each hole is apart by: Degrees Minutes Seconds
Rotation
-X+ X= Y= + X= Y= X= + Y= + X= + Y= -
+ Y -
+ Y -
-X+
Spiral Calculator
Hole # Enter First X & Y Coordinates First X = First Y = Seperation Per Hole Degrees = Spiral Offset Per Hole = Per Rev = Number of Revolutions Revolutions = Rounded Precision = 0.0001 X= Y= Degrees Hole # X= Y= Degrees Hole # X= Y= Degrees Hole # X= Y= Degrees
Each hole is apart by: Degrees Minutes Seconds Rotation
Spiral None -X+ X= Y= + X= Y= X= + Y= + X= + Y= -
+ Y -
+ Y -
-X+
Rotation of an " X & Y " coordinate
A negative Angle of Rotation is equal to a counter clockwise rotation Original X = Original Y = Angle of Rotation (in degrees) = Number of times rotated = 1 15 max. Rotating Axis Absolute X Center = 0.0000 Rotating Axis Absolute Y Center = 0.0000 - X + NOTE: The Original X & Y should be entered as INCREMENTAL, taken from the center of the rotating axis. The New X & Y will be ABSOLUTE. Degrees Move New X New Y
+ Y -
X= Y= + X= Y= -
X= + Y= + X= + Y= -
+ Y -
- X +
CONE FABRICATION
This will help you to layout a cone on a flat surface. NOTE: This does not allow for material thickness.
Inside Radius Inside Diameter Outside Diameter Cone Angle Cone Length Segment Width Degrees in Cone Segment Overlap in Degrees Outside Radius Segment Angle Segment Width Inside Diameter Outside Diameter Cone Length Cone Angle
360 0
Circle Segment Calculator
Enter TWO knowns a Angle in degrees Chord Length Height Radius a= c= h= r= c h c h r
a
r
Polygon Solver
Must enter NUMBER OF EQUAL SIDES and one other IC Number of Equal Sides ES= Inner Circle Diameter IC= Outer Circle Diameter OC= OC
NOTE: Although a square is drawn, this will work with 3 equal sides and greater.
IC
IC
OC
Values of a Trigonometric Function
You can enter DEGREES as a decimal and it will be converted to DEG,MIN,SEC. 3 Degrees 3 3 Degrees Sine = 0.05322193 0.05 Minutes 3 3 Minutes Cosine = 0.99858271 0.000833333 Seconds 3 3.00 Seconds 3.050833333 Angle as a decimal Tangent = 0.05329747 Total Cotangent = 18.7626178 Sine bar length = inches Sine bar length = millimeters Secant = 1.0014193 NOTE: Enter the sine bar length above. Cosecant = 18.7892477 The required height needed under one end of the sine bar to obtain the desired angle. Radians = 0.05324709