ࡱ > \ _
! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? @ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ ^ R o o t E n t r y F @J7pHk-] W o r k b o o k Y S u m m a r y I n f o r m a t i o n ( D o c u m e n t S u m m a r y I n f o r m a t i o n 8 , \ p Dan B a = = - [, 8 X@ " 1 A r i a l 1 A r i a l 1 A r i a l 1 A r i a l 1 A r i a l 1 A r i a l 1 A r i a l 1 A r i a l 1 A r i a l 1 A r i a l 1 A r i a l 1 C a l i b r i 1 C a l i b r i 1 A r i a l 1 A r i a l 1 h 8 C a m b r i a 1 , 8 C a l i b r i 1 8 C a l i b r i 1 8 C a l i b r i 1 C a l i b r i 1 C a l i b r i 1 < C a l i b r i 1 > C a l i b r i 1 ? C a l i b r i 1 4 C a l i b r i 1 4 C a l i b r i 1 C a l i b r i 1
C a l i b r i 1 C a l i b r i 1 C a l i b r i 1 C a l i b r i 1 C a l i b r i 1 C a l i b r i 1 h C a l i b r i 1 C a l i b r i 1 C a l i b r i 1 h C a l i b r i 1 h C a l i b r i 1 C a l i b r i 1 A r i a l 1 A r i a l 1 C a l i b r i "$"#,##0_);\("$"#,##0\) ! "$"#,##0_);[Red]\("$"#,##0\) " "$"#,##0.00_);\("$"#,##0.00\) ' " "$"#,##0.00_);[Red]\("$"#,##0.00\) 7 * 2 _("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_) . ) ) _(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_) ? , : _("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_) 6 + 1 _(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) 0.0
0.000 #,##0.0 0.000E+00 0.00000 ff + ) , * P P ` a > @
$ " 8@ @ " < @ " 8 @ " 8 @ @ @ @ @
( ( " 8 @ " 0 @ " 0@ " 4 " 0 " 0 " 4 " 0 " 4 " 4 " 4 " 4 $ " p @ " p " t " t " t " 8 @ ) * 8 @ @ " x@ @ $ @ d @ $@ " 4 " t " 4 (@ | | n ޝ}A }
00\);_(* ef ;_(@_) }A }
00\);_(* ef ;_(@_) }A }
00\);_(* ef ;_(@_) }A }
00\);_(* ef ;_(@_) }A }
00\);_(* ef ;_(@_) }A }
00\);_(* ef ;_(@_) }A }
00\);_(* L ;_(@_) }A }
00\);_(* L ;_(@_) }A }
00\);_(* L ;_(@_) }A }
00\);_(* L ;_(@_) }A }
00\);_(* L ;_(@_) }A }
00\);_(* L ;_(@_) }A }
00\);_(* 23 ;_(@_) }A }
00\);_(* 23 ;_(@_) }A }
00\);_(* 23 ;_(@_) }A }
00\);_(* 23 ;_(@_) }A }
00\);_(* 23 ;_(@_) }A } !
00\);_(* 23 ;_(@_) }A } "
00\);_(* ;_(@_) }A } #
00\);_(* ;_(@_) }A } $
00\);_(* ;_(@_) }A } %
00\);_(* ;_(@_) }A } &
00\);_(* ;_(@_) }A } '
00\);_(* ;_(@_) }A } (
00\);_(* ;_(@_) } } )
} 00\);_(* ;_(@_)
} } *
00\);_(* ;_(@_) ??? ??? ???
??? }- } /
00\);_(* }A } 0
a 00\);_(* ;_(@_) }A } 1
00\);_(* ;_(@_) }A } 2
00\);_(* ? ;_(@_) }A } 3
00\);_(* 23 ;_(@_) }- } 4
00\);_(* } } 5
??v00\);_(* ̙;_(@_)
}A } 6
} 00\);_(* ;_(@_) }A } 7
e 00\);_(* ;_(@_) }x } 8 00\);_(* ;_(
} } 9
???00\);_(* ;_( ??? ???
???
??? }- } ;
00\);_(* }U } <
00\);_(* ;_( }- } =
00\);_(* }( } ] 00\);_(*}( } ^ 00\);_(*}( } _ 00\);_(*}( } ` 00\);_(*}( } a 00\);_(*}( } h 00\);_(*}( } k 00\);_(*
20% - Accent1M
2 0 % - A c c e n t 1 ef %
20% - Accent2M "
2 0 % - A c c e n t 2 ef %
20% - Accent3M &
2 0 % - A c c e n t 3 ef %
20% - Accent4M *
2 0 % - A c c e n t 4 ef %
20% - Accent5M .
2 0 % - A c c e n t 5 ef %
20% - Accent6M 2
2 0 % - A c c e n t 6 ef %
40% - Accent1M
4 0 % - A c c e n t 1 L %
40% - Accent2M #
4 0 % - A c c e n t 2 L湸 %
40% - Accent3M '
4 0 % - A c c e n t 3 L %
40% - Accent4M +
4 0 % - A c c e n t 4 L %
40% - Accent5M /
4 0 % - A c c e n t 5 L %
40% - Accent6M 3
4 0 % - A c c e n t 6 Lմ %
60% - Accent1M
6 0 % - A c c e n t 1 23 %
60% - Accent2M $
6 0 % - A c c e n t 2 23ٗ %
60% - Accent3M (
6 0 % - A c c e n t 3 23֚ %
60% - Accent4M ,
6 0 % - A c c e n t 4 23 %
60% - Accent5M 0
6 0 % - A c c e n t 5 23 % !
60% - Accent6M 4
6 0 % - A c c e n t 6 23 % " Accent1A A c c e n t 1 O % # Accent2A ! A c c e n t 2 PM % $ Accent3A % A c c e n t 3 Y % % Accent4A ) A c c e n t 4 d % & Accent5A - A c c e n t 5 K % ' Accent6A 1 A c c e n t 6 F % ( Bad9 B a d % ) Calculation C a l c u l a t i o n } % *
Check Cell
C h e c k C e l l % ??? ??? ??? ??? + C o m m a ,( C o m m a [ 0 ] -& C u r r e n c y .. C u r r e n c y [ 0 ] / Explanatory TextG 5 E x p l a n a t o r y T e x t % 0 Good; G o o d a % 1 Heading 1G H e a d i n g 1 I}% O 2 Heading 2G H e a d i n g 2 I}% ? 3 Heading 3G H e a d i n g 3 I}% 23 4 Heading 49 H e a d i n g 4 I}%
5 Inputu I n p u t ̙ ??v% 6 Linked CellK L i n k e d C e l l } % 7 NeutralA N e u t r a l e % " N o r m a l 8 Noteb
N o t e 9 Outputw O u t p u t ???% ??? ??? ??? ??? :$ P e r c e n t
; Title1 T i t l e I}%
< TotalM T o t a l % O O = Warning Text? W a r n i n g T e x t % X T a b l e S t y l e M e d i u m 9 P i v o t S t y l e L i g h t 1 6 ` \8 Newtons Law h\ Newtons Law with Logs g /
! 3 A @ @
9 $
Constants: Newton's law of Cooling K
Temp. (C) C ln(e-kt) T0 - Ts T - Ts K (s-1) Average& Predicted temperature at 15 minutes = Relative Error = % Ts T(t) = Ts + (T0 - Ts) e-Kt
Law: Time (mins) C Time (s)
Time (min) min-1 s-1 K = T - Ts T0 - Ts
ln[(T(t) - Ts)/(T0 - Ts)]
$ Calculaion of K from Slope of Graph:
(using average K value)
Transform:
ln[(T(t) - Ts)/(T0 - Ts)] = -Kt
Tpredicted (C) Calculation of K Using Averages ( 2 Calculation of K Using Logarithmic Transformation: ( Relative Error
Average Error' Predicted temperature at 30 minutes = *
4 4 f5 h 5 J7 L c c B
! v9 I I
d MbP?_ * + % & ffffff?' ffffff?( ?) ? " B 333333?333333? l& <3 U } $ }
! h ; ; ;
?
C
A
~
@
A
A B
C B
A
A B
F
G
H
H
H
I O R U@ R R S T P ?R @@ R gffffN@ L D R O@ D D / Y A~? D D A U a1S,?
L L < P @R @ R 33333M@ R O@ Y t
w? # L L A U |` 3?
P @R @
R gfffffM@
R O@
Y ϳ?
U lcy3? ~
P @ R fffffS@ R L@ R O@ Y Vߺ)в? U )!=4?
P @R S@ R LL@ R O@ Y &? U :B4?
P @R 2@
R 33333K@
R O@
Y }E:?
U {"&4? P @R S@ R K@ R O@ Y
? U 5?
P @R .@ R gfffffJ@ R O@ Y [T ? U bf&6? ~
P "@ R YR@ R I@ R O@ Y ? U AF6? P $@R p@ R 33333sI@ R O@ Y % u? U o,5? P &@R @ R 33333H@ R O@ Y <+.? # L L A U Z5? L L < P (@R Q@ R ̌H@ R O@ Y V$? U ;BCa5? ~
P *@ R yQ@ R H@ R O@ Y ?y{? U M5? P ,@R @Q@ R ̌G@ R O@ Y 2U»? U s75? P .@R @ R 333333G@ R O@ Y hX? U v(85? ~
P <@ S R R Y U P =@S R@ ! R gffffB@ D D ! R O@ D D Y C7? U H ꮲ2? P >@S @ ! R B@ D D ! R O@ D D Y e? U 3-B2? Q ?@V @M@ ! W LB@ D D ! W O@ D D Z Am? X ǘ۠2? J K K K K L @ > >
M
N # E S,\4?
% B
A
9Q@
A > W 0 8 & T ( " S
A / D 2qp| ? D D A D d
A c 6 ( (
( n
(
c 4 N C h a r t 1 0 0 ] @ `Ӹ P P PZaajk & hfffff?' hfffff?( ?) ? " @ XX533333?533333? 3 & <3 P H 0 (
h )3 d 2 3
M R R
R R I3~ S S 4 3 Q :
T e m p . ( C ) Q r ; Q ; Q 3 _ M
M M f aaa @ "B ` R R R R ï
R
" ' x S S 4 E S S 4 D $ % 0 3 O &
Q R R 40 S S 4 $ % 3 O &
Q 4 F A 1
3 O F Q 3 * N &
! R R R R 0u, S S 4 3 * I@ N &
! R R 0u, b S S 4 % ` A
3 O
D & ! Q
T i m e ( m i n s ) 2 3 M
N M R R R R e ] S S 4 ' < @
xxxxxxxxxxx
x S S 4 % 3 s
Z 3 O " c & ! Q
$ T e m p e r a t u r e ( C ) 2 3 M
N M R R R R p ] S S 4 ' < 7 #
xxxxxxxxxxxxxxxx
x S S 4 5 2 3 M
M R R n] S S 4 3 d "
4 S S 4 D FQ % S e 3 O + & " Q
2 N e w t o n ' s L a w o f C o o l i n g 2 3 M
N M R R R R t ] S S 4 ' # }.
xxxxxxxxxxxxxxxxxxxxxxx
x S S 4 b
[ S S
4 e e e
C2
> @ b b g g D
H ` p x
d MbP?_ * + % & ffffff?' ffffff?( ?) ?M 6 H P D e s k J e t 8 1 2 C XC
od , , L e t t e r DINU" 4$ %#| $ $ $ $ " d ,,333333?333333? & <3 U } }
}
} } I } H
w ; ; ;
c
?
C A A
C
A
~
@
A
A B
C B
A
A B
F
G
H
H
H
I O R U@ R R S T
P ?R @@ !
R gffffN@
D
D !
R O@
D D /
Y A~?
D
D
A
U a1S,?
L L < P @R @ ! R 33333M@ D D ! R O@ D D Y t
w? # L L A U |` 3?
P @R @ ! R gfffffM@ D D ! R O@ D D Y ϳ? U lcy3?
~
P @
R fffffS@ !
R L@
D
D !
R O@
D D
Y Vߺ)в?
U )!=4?
P @R S@ ! R LL@ D D ! R O@ D D Y &? U :B4?
P @R 2@ ! R 33333K@ D D ! R O@ D D Y }E:? U {"&4?
P @R S@ ! R K@ D D ! R O@ D D Y
? U 5?
P @R .@ ! R gfffffJ@ D D ! R O@ D D Y [T ? U bf&6?
~
P "@ R YR@ ! R I@ D D ! R O@ D D Y ? U AF6?
P $@R p@ ! R 33333sI@ D D ! R O@ D D Y % u? U o,5?
P &@R @ ! R 33333H@ D D ! R O@ D D Y <+.? U Z5?
P (@R Q@ ! R ̌H@ D D ! R O@ D D Y V$? U ;BCa5?
~
P *@ R yQ@ ! R H@ D D ! R O@ D D Y ?y{? U M5?
P ,@R @Q@ ! R ̌G@ D D ! R O@ D D Y 2U»? U s75?
P .@R @ ! R 333333G@ D D ! R O@ D D Y hX? U v(85?
] ^ _ _ ` a P =@S R@ ! R gffffB@ D D ! R O@ D D Y C7? U H ꮲ2?
P >@S @ ! R B@ D D ! R O@ D D Y e? U 3-B2?
Q ?@V @M@ ! W LB@ D D ! W O@ D D Z Am? X ǘ۠2?
J K K K K L @ > >
M
N # E S,\4? 6
%
B @ D 8 & T ( ! " $ w & ; ' ( ; * ; , . / 1 ; 2 3 4 5 6 7 8 9 : ; < = > ?
A # ~
l@
A
! A
" A / " D
:@ G D D A D d
" A
$ ?
& C & B
& A ' C B A ' A
( C ( B
( A ( A
* C
* A
~
* @
* A
, C
. A . A rh?
. A / \ @Zf2? C D. <
/ A
1 F
1 F
1 G
1 d
1 b
1 f ! ~
2 O 2 P D2 < ~
2 R U@ 4 2 Y / D2 D D2 D A D 2 j U@ A . D* D2 D* @D/ < D2 A @ / 2 e 4 D2 D2 A D2 d ~
3 P ? 3 P N@ 4 3 3 E L < ~
3 R @@ 4 3 Y A~? 4 D3 D D2 D A D 3 j DT@ 2 . D* D2 D* @D/ < D3 A @ / 3 g 滜? 3 D3 D3 A D3 d ~
4 P @ 4 P ^@ 5 3 ~
4 R @ 4 4 Y t
w? 5 D4 D D2 D A D 4 j mm8L${T@ 3 . D* D2 D* @D/ < D4 A @ 4 g ,j? 5 4 # 4 E L L A L d ~
5 P @ 5 P f@ 6 3 ~
5 R @ 4 5 Y ϳ? 6 D5 D D2 D A D 5 j WB[6c:T@ 4 . D* D2 D* @D/ < D5 A @ 5 g }zL? 6 4 ~
6 P @ 6 P n@ 7 3 6 R fffffS@ 4 6 Y Vߺ)в? 7 D6 D D2 D A D 6 j
y5S@ 5 . D* D2 D* @D/ < D6 A @ 6 g F ? 7 4 ~
7 P @ 7 P r@ 8 3 ~
7 R S@ 4 7 Y &? 8 D7 D D2 D A D 7 j 1"S@ E . D* D2 D* @D/ < D7 A @ 7 g rz? 8 4 ~
8 P @ 8 P v@ 9 3 ~
8 R 2@ 4 8 Y }E:? 9 D8 D D2 D A D 8 j Z5ę~S@ 7 . D* D2 D* @D/ < D8 A @ 8 g a4Q? 9 4 ~
9 P @ 9 P @z@ : 3 ~
9 R S@ 4 9 Y
? : D9 D D2 D A D 9 j !fsBS@ 8 . D* D2 D* @D/ < D9 A @ 9 g W!|? : 4 ~
: P @ : P ~@ ; 3 ~
: R .@ 4 : Y [T ? ; D: D D2 D A D : j 1S@ 9 . D* D2 D* @D/ < D: A @ : g Z7A? ; 4 ~
; P "@ ; P @ < 3 ; R YR@ 4 ; Y ? < D; D D2 D A D ; j z蟘&R@ : . D* D2 D* @D/ < D; A @ ; g SH @ < 4 ~
< P $@ < P @ = 3 ~
< R p@ 4 < Y % u? = D< D D2 D A D < j TR@ ; . D* D2 D* @D/ < D< A @ < g l7Pd @ = 4 ~
= P &@ = P @ > 3 ~
= R @ 4 = Y <+.? > D= D D2 D A D = j ,$$ZR@ < . D* D2 D* @D/ < D= A @ = g s@ > 4 ~
> P (@ > P @ ? 3 ~
> R Q@ 4 > Y V$? ? D> D D2 D A D > j R0ڒ"R@ = . D* D2 D* @D/ < D> A @ > g #Z@ ? 4 ~
? P *@ ? P `@ @ 3 ? R yQ@ 4 ? Y ?y{? @ D? D D2 D A D ? j yYQ@ > . D* D2 D* @D/ < D? A @ ? g Mr@ @ 4 8 h * O & 0 8 . 1 T @ A B C D E F G ~
@ P ,@ @ P @@ A 3 ~
@ R @Q@ 4 @ Y 2U»? A D@ D D2 D A D @ j %,;Q@ ? . D* D2 D* @D/ < D@ A @ @ g =&WBk@ A 4 ~
A P .@ A P @ C 3 ~
A R @ 4 A Y hX? C DA D D2 D A D A j
mQ@ @ . D* D2 D* @D/ < DA A @ A g "+P l,@ C 4 B ] ] ^ ` k h ~
C P =@ C P 0@ D 3 ~
C S R@ 4 C Y C7? D DC D D2 D A D C j FeAM@ 3 . D* D2 D* @D/ < DC A @ C g .s? D 4 ~
D P >@ D P @ E 3 ~
D S @ 4 D Y e? E DD D D2 D A D D j jTkM@ . D* D2 D* @D/ < DD A @ D g d ? E 4 ~
E Q ?@ E Q @ 2 3 ~
E V @M@ 4 E Z Am? 2 DE D D2 D A D E l 9dGM@ D . D* D2 D* @D/ < DE A @ E i >V7? 3 4
F J L
G m " # G [ (L? 2
%2 E B ; ( 4 @ D (
D n
D
c 4 N C h a r t 1
- ] @ w P P PZaajk & jfffff?' jfffff?( ?) ? " @ XX733333?733333? 3 & <3 P H 0 (
3 ,3 d 2 3
M R R
R R I3~ S S 4 3 Q :
T e m p . ( C ) Q r ; Q ; Q 3 _ M
M M f aaa @ "B ` R R R R ï
R
" ' x S S 4 E S S 4 D $ % 0 3 O &
Q R R 40 S S 4 $ % 3 O &
Q 4 F A | D
3 O +
W 3 * N &
! R R R R 0u, S S 4 3 * I@ N &
! R R 0u, b S S 4 % b
3 O
D & ! Q
T i m e ( m i n s ) 2 3 M
N M R R R R e ] S S 4 ' < @
xxxxxxxxxxx
x S S 4 % < }
Z 3 O " c & ! Q
$ T e m p e r a t u r e ( C ) 2 3 M
N M R R R R p ] S S 4 ' < 7 #
xxxxxxxxxxxxxxxx
x S S 4 5 2 3 M
M R R n] S S 4 3 d "
4 S S 4 D +
W % R 3 O + & " Q
2 N e w t o n ' s L a w o f C o o l i n g 2 3 M
N M R R R R t ] S S 4 ' # }.
xxxxxxxxxxxxxxxxxxxxxxx
x S S 4 b
[ S S
4 e e e
v n
D
c 4 N C h a r t 3 1
E ] @ Z P P PZaajk & ffffff?' ffffff?( ?) ? " 333333?333333? 3 & <3 `
* P H 0 (
, 3 d 2 3
M R R
R R I3~ S S 4 3 Q : 1
6 l n [ ( T ( t ) - T s ) / ( T 0 - T s ) ] Q ; 2 E Q ; 2 E Q 3 _ M
M M N R R R R 28
2
" ' S S 4 E S S 4 3 Q Q Q Q 3 _
M M M M d R R R R 2J S S 4 J K S S 4 D $ % 0 3 O &
Q R R 40 S S 4 $ % 3 O &
Q 4 F A #
3 O 3 F 3 * &
! R R R R 0u, b S S 4 3 * N &
! R R bu, b S S 4 % >
3 O D & ! Q
T i m e ( m i n s ) 2 3 M
N M R R R R e ] S S 4 ' < @
xxxxxxxxxxx
x S S 4 % M
Z 3 O , & * P> ! # ! # ! #
$ ! # $ ! # $ ! Q
8 - l n [ ( T ( t ) - T s ) / ( T 0 - T s ) ] 2 3 M
N M R R R R [ ] S S 4 ' < {ΰ
xxxxxxxxxxxxxxxxxxxxxxxxxx
S S 4 3 d "
4 S S 4 D 3F % P W 3 O 4 ) &
P> " % " % " % &
" % & " % & " " Q
H "l n [ ( T ( t ) - T s ) / ( T 0 - T s ) ] v s . T i m e 2 3 M
N M R R R R ( ] S S 4 '
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
x S S 4 % @
3 O B + &
P
'
Q 2 3 M
N M R R R R ] S S 4 ' < % _̿VS? 40 S S 4 b
[ S S
4 e e e
> * @ b b g g D
Oh +'0 @ H X d |
AdminXP Dan Microsoft Excel @ C @ 4- ՜. +,0 P X |
Robert Morris University Newtons Law Newtons Law with Logs Worksheets
F& Microsoft Office Excel 2003 Worksheet Biff8 Excel.Sheet.8 9q C o m p O b j r