ࡱ > ? >
! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = [ i A B C L E F G H I J K @ M N O P Q R S T U V W Y Z \ h ] ^ _ ` a b c d e f g j n k l m o R F X & W o r k b o o k v _ V B A _ P R O J E C T _ C U R " H V B A "7 \ p Adam Schneider B a = ThisWorkbook = P C-8 @ " 1 i Geneva1 i Geneva1 i Geneva1 i Geneva1 i Geneva1 i Helv1 i Helv1 i Helv1 i Courier1 i Helv1 i Times1 i Times1 i Helv1 i Helv1 H i Helv "$"#,##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.00 0;0; 0;0 000
0" dreams" 00% .00
\+.00;\-.00;0 * % [<0.01]"** ".000;[<0.05]"* ".000;.000 \+.0;\-.0;0
\+0.0;\-0.0;0 0;\-0;
\.00 + ) , * .
"
" " 8 ) 8 * * < * < * 8 ! 8 ) 8 * < * < * < * < + < + < * 8 * < * < * < * < * 8
Headings Macro headings Macros Normal_h profile Normal_Percents Sub-headings Totals 8 d q: F ` ` i ̜ ̙ 3f 3 33 3 f3 ff ff 33 3ff 3 33 f3 3f 33 BBB \ ` data 5 h profile u Module1
CompareSeries CRLF
) data_categories; '
data_h_female; % data_h_male;
data_width [ edited_file
edited_row " original_number " original_series ; " !
serif_font Times zoom_percent d Z R 3 @ @
% % Baseline Series 1 Series 2
Characters Male/Female Percent Familiarity Percent Friends Percent Family Percent Dead & Imaginary Percent Animal Percent Social Interaction Percents Aggression/Friendliness Percent Befriender Percent Aggressor Percent Physical Aggression Percent Social Interaction Ratios A/C Index F/C Index S/C Index Settings Indoor Setting Percent Familiar Setting Percent Self-Concept Percents Self-Negativity Percent Bodily Misfortunes Percent Negative Emotions Percent Dreamer-Involved Success Percent Torso/Anatomy Percent Dreams with at Least One:
Aggression Friendliness Sexuality
Misfortune Good Fortune Success Failure Striving "
] p, X
y
Mp 6p @ _ ̨ p̨ "̨ . se t i c aN n f
MpPJ sT v I 6p n jX sT
" l$ #JJL pJ sŲ sT l$ v H kp+^ 0 sUH@J sT vPip k5 p+^ ` o m _ p e r c e n t i e s @ ȏP \
d` z 2p^ 5
KnMjX
ȏP
d z 2{nؿ5 \D"D0ip tpܿO KnpN H ZH pn1 jXL5
N Z ` ȏPp&p5 uR ip K
p uRR N p&pH H ȏP
4njXip NX̨ IJHn
Kn
"7 # ; y0 2
d MbP?_ * + % &C&F & ?' ?M z ,, ` #) ,, `, -^ & ' " d ? ? U
} } } / } ! } / } + } , } ( } ) } ! }
! # @ * @ @ @ @ @h @ *
@
@ @ @ @
* @ @ T@D * @ @ * @ @ @
@ @
* @ @ ̛@" @" P@PG
W + l A h:
@ Ao @ @ D @ @ vs. @ @ D @ h:
Series 1 vs. Baseline W , m A h:
@ Ao @ @ D @ @ vs. @ @ D @ h:
Series 2 vs. Baseline W + 0n A p:
@ Ao @ @ D @ @ vs. @ @ D @ p:
Series 1 vs. Baseline W , n A p:
@ Ao @ @ D @ @ vs. @ @ D @ p:
Series 2 vs. Baseline 8 ! N " N:
@ Ao @ @ D @ N:
Baseline 8
! R; " N:
@ Ao @ @ D @ N:
Series 1 8 ! o " N:
@ Ao @ @ D @ N:
Series 2
" # $ % $ & ' ( )
C + - D Ac D Ac C , - D Ac D Ac (
C 9 L L L L L A A A& ) C 9 L L L L L A A A&
+ 7 - L Ac L Ac , ( )
+ , ( )
+ , ( )
+ , ( ) "
+ 7 - L Ac L Ac , 7 - L Ac L Ac ( )
"
# $ % $ & ' ( )
+ , ( C 9 L L L L L A A A& )
+
,
(
)
+
, (
)
+ , ( )
"
# $ % $ & ' ( )
- . - + " % L L A ? ,
- . - + ,
- . - + ,
" # $ % $ & ' ( )
C + - D Ac D Ac C , - D Ac D Ac O ( 9 D D D
D D
A A A& O ) 9 D D D D D A A A&
C + - D Ac D Ac C , - D Ac D Ac O ( 9 D D D
D D
A A A& O ) 9 D D D D D A A A&
" # $ % $ & ' ( )
+ 7
- L Ac L Ac , ( C
9 L L L L L A A A& )
+ , ( )
+ , ( )
+ , ( )
+ , ( )
" # $ % $ & ' ( )
+ 7 " - L Ac L Ac , ( C " 9 L L L L L A A A& ) C " 9 L L L L L A A A&
+ , ( )
+ , ( )
+ , ( )
! + , ( ) D v l( x ( ( \ \ ( RR( ( c @ ! @* " @
" + , ( ! )
! # ! ! + ! , ! ! ( " ! )
" $ " " + ! " , " " ( " ) !
( Z B (
z
s 8 @ T e x t 6 ' ] @
. < / Note: These ratios do not use the h statistic.<
. lu
F ? t h e b u t t o n $ B ] , г 9
$ < Compare series< M Rge> @ @ Sheet1
"7 M
com.apple.print.PageFormat.PMHorizontalRescom.apple.print.ticket.creatorcom.apple.printingmanagercom.apple.print.ticket.itemArraycom.apple.print.PageFormat.PMHorizontalRes600com.apple.print.ticket.clientcom.apple.printingmanagercom.apple.print.ticket.modDate2005-11-03T02:11:26Zcom.apple.print.ticket.stateFlag0com.apple.print.PageFormat.PMOrientationcom.apple.print.ticket.creatorcom.apple.printingmanagercom.apple.print.ticket.itemArraycom.apple.print.PageFormat.PMOrientation1com.apple.print.ticket.clientcom.apple.printingmanagercom.apple.print.ticket.modDate2005-11-03T02:11:26Zcom.apple.print.ticket.stateFlag0com.apple.print.PageFormat.PMScalingcom.apple.print.ticket.creatorcom.apple.printingmanagercom.apple.print.ticket.itemArraycom.apple.print.PageFormat.PMScaling1com.apple.print.ticket.clientcom.apple.printingmanagercom.apple.print.ticket.modDate2005-11-03T02:11:26Zcom.apple.print.ticket.stateFlag0com.apple.print.PageFormat.PMVerticalRescom.apple.print.ticket.creatorcom.apple.printingmanagercom.apple.print.ticket.itemArraycom.apple.print.PageFormat.PMVerticalRes600com.apple.print.ticket.clientcom.apple.printingmanagercom.apple.print.ticket.modDate2005-11-03T02:11:26Zcom.apple.print.ticket.stateFlag0com.apple.print.PageFormat.PMVerticalScalingcom.apple.print.ticket.creatorcom.apple.printingmanagercom.apple.print.ticket.itemArraycom.apple.print.PageFormat.PMVerticalScaling1com.apple.print.ticket.clientcom.apple.printingmanagercom.apple.print.ticket.modDate2005-11-03T02:11:26Zcom.apple.print.ticket.stateFlag0com.apple.print.subTicket.paper_info_ticketcom.apple.print.PageFormat.PMAdjustedPageRectcom.apple.print.ticket.creatorcom.apple.printingmanagercom.apple.print.ticket.itemArraycom.apple.print.PageFormat.PMAdjustedPageRect0.00.06411.02362204724524800com.apple.print.ticket.clientcom.apple.printingmanagercom.apple.print.ticket.modDate2005-11-03T02:11:26Zcom.apple.print.ticket.stateFlag0com.apple.print.PageFormat.PMAdjustedPaperRectcom.apple.print.ticket.creatorcom.apple.printingmanagercom.apple.print.ticket.itemArraycom.apple.print.PageFormat.PMAdjustedPaperRect-70.866141732283481-151.181102362204746529.13385826771724948.818897637796com.apple.print.ticket.clientcom.apple.printingmanagercom.apple.print.ticket.modDate2005-11-03T02:11:26Zcom.apple.print.ticket.stateFlag0com.apple.print.PaperInfo.PMPaperNamecom.apple.print.ticket.creatorjp.co.canon.bj.print.canon261.pmcom.apple.print.ticket.itemArraycom.apple.print.PaperInfo.PMPaperNamena-lettercom.apple.print.ticket.clientjp.co.canon.bj.print.canon261.pmcom.apple.print.ticket.modDate2005-02-15T19:05:27Zcom.apple.print.ticket.stateFlag1com.apple.print.PaperInfo.PMUnadjustedPageRectcom.apple.print.ticket.creatorjp.co.canon.bj.print.canon261.pmcom.apple.print.ticket.itemArraycom.apple.print.PaperInfo.PMUnadjustedPageRect0.00.0769.32283464566933576com.apple.print.ticket.clientjp.co.canon.bj.print.canon261.pmcom.apple.print.ticket.modDate2005-02-15T19:05:27Zcom.apple.print.ticket.stateFlag1com.apple.print.PaperInfo.PMUnadjustedPaperRectcom.apple.print.ticket.creatorjp.co.canon.bj.print.canon261.pmcom.apple.print.ticket.itemArraycom.apple.print.PaperInfo.PMUnadjustedPaperRect-8.5039370078740166-18.141732283464567783.49606299212599593.85826771653547com.apple.print.ticket.clientjp.co.canon.bj.print.canon261.pmcom.apple.print.ticket.modDate2005-02-15T19:05:27Zcom.apple.print.ticket.stateFlag1com.apple.print.ticket.APIVersion00.20com.apple.print.ticket.privateLockcom.apple.print.ticket.typecom.apple.print.PaperInfoTicketcom.apple.print.ticket.APIVersion00.20com.apple.print.ticket.privateLockcom.apple.print.ticket.typecom.apple.print.PageFormatTicket
M z XX iUg( H H ( d h " d ? ? 3 @@3 d ! ! 3 Q :
Series 1Q ; " Q ; " Q 3 _ P P PWZZ ! @ ĿYP h `>@ X `Y ,Y !. p8Y_p e@ HZ0 H _grbbr+x`$$H+̖8Z HZ T `>@ [
; 2X 2 ^ ![? _0]P? _@]` typ1~[ ~[ ? ^ tA \ A ttyp1 e@^ t\ ] \ \ \ '̿\@$" ( `>@
N
N-\p
U \p^ L 2 4 2\] a@
@] T u 2$P
@] I u f P]@]`u
-@ qhS A '̿]`uА (0] fP
]п^0 d @ 2]^L 2X e fp ufp=0`@ D0 ^ typ1~^ ~ 0 0 0 " e I ^ ^ptyp1 /
ژA ? e A
I@ ^п_
I@ _0 H^ L H_k`
I@
_0_
? _0 ? ^ A
I@
P^ __
I@ =P_ =xI@ e+U\ 4
I@
P^ _
a﴿a@ a@ h 4 NX` 4NXȷb+U\@ @ @ I Q S P G J M F p `` |NX`` O<` K K K s`*` p ` $` h
4 hI` !+@ `k
Chart1
"7 &A
Page &P " P d ? ? >
P
M o d u l e 1 D . _ _ S R P _ 2 _ _ S R P _ 3 T h i s W o r k b o o k
"
! " # $ % & ' ( * + , - . / 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 [ \ ] ^ _ ` a b c d e f g h i j l m n o p q r t u v w x y z { | } ~ 8 $ (0 8 8 6 N@8 6 $: @BJ ` <@B> D B <@B@ B 8 C 8 6 ` 6 6 $: @BJ <@B> ` D B <@B@ t h 8 1 0 0 8 6 5 . t 6 6 $: @BJ q <@B> D B <@B@ 8 (F A1 $, @BJ !MsgBox (n - 2 & " columns added") H 6 data!R1C2:R35C2 L $2 !4@BJ D H < H $ H use this template: =SERIES(data!R1C_,data!R3C2:R35C2,data!R3C_:R35C_,_) =SERIES(data!R1C H ,data!R3C2:R35C2,data!R3C $ H :R35C $ H , H ) H $2 %4 (Nstrk H sclr )MsgBox (n - 2 & " series added to chart") hh CHAR(13) T CHAR(10) V Z X \ data $ %P @BR h a -Excel spreadsheets (*.xls; *.xlt),*.xls;*.xlt '^ h ` ` False ^ d 4Locate the spreadsheet containing the BASELINE data. f %b '` @ ` ` False F file Ah g Z P $ j Z $ l 8 $ 8 $j 8 $j False ^ d 7Locate the spreadsheet containing the data for series # 8 . f %b 8 +j 8 $j 8 $j False F file Ah gK 8 $j ` +l 8 $ a@ 8 $j 8 $j 8 +l 8 , ` p r n@B t ! '` v ` $n ! v ! Percents F Percents ` $n % @B* g v 9Select the column that contains the baseline percentages. z n %& .x x !|@B> data ~ % %: @B (F >Select the column that contains the N's for t x \ ! ! EM (
6 < < < Ck *\Rffff*84311ce69 ` @
p rr rrrr j h l will T includ h` `
@ _B.Di H:H rr rrrr d i $ H p " ( 0 8 @ H P . ` T ( @ X p " , P ` p
,
8 H `
x
8
X h
( ,
( 8 N P
P 0 ` L . 6 @ H R h 0 ( , @ j p <
( 8 X ( p
>
( Z
8
*
^
H > X
J ( H j p >
(
@
P
p
>
j x 0
b 0 D @
N ( . x v
( 0 X H x " j x " x ! Mac* ' a H ' h 8 P ( Times New Roman data $ ! !" ( h h $ EHow many series will be compared (NOT including the baseline series)? $& '$ $ $( '$P? $ rt:L data $ @B* _B.D K:K $, @B. _ F H:H $, @B. d i F:F $, @B. P B D:D $, @B. /Doc Series 1 $ (0Fa A1 $, @BJ Falls_ MsgBox ("1 column deleted") J $2 %4 @B. 1 0 0 &MsgBox ("1 series deleted from chart")0 $
b
JNH $ '68 data $ @B* I` 8 6 $: @BJ <@B> 0 ` D B <@B@ 8 8 6 Series 8 he baseline data. z n %& . !|@B> $ data ~ % %: @B (F $l ` $n @B B a data ~ % @B* h +What do you want to call the baseline data? z n %& 'nt data ~ % % (0 ="N for " & $ % $ data ~ % % (N , vs. C1 data $ %, !f ~ %2 ! (f ` ' 8 $ 8 $l 8 $j p r n@B t ! '@ aP $n @B* h8 v $n ! v ! Percents F Percents $n % @B* g 0 v - 0 0