Jeff, is it weird to not see fighting, I'm halfway through my first tape (the new .cnf file works great!!) but am seeing no fighting, these pigs have been in this pen together for about 11 weeks now so their social order is stable so there should be no fighting, right??
Let me know, I'm being very watchful around the feeder and the waterer but to no avail. They only seem to nibble on each other a lot. I've attached my spreadsheet that I have set up for recording fights, is it alright? Will it be easy to use the data on the spreadsheet the way it is set up, please make any changes to it if it will make it easier to analyze. Thanks, Lisa
I'm glad that we figured out what was going on. I attached fights2.xls just a little bit of house keeping. I made the column headings one word as SAS likes things that way. I also added a formula to get a fight total for you. Try to drag it down to extend the column - you can do it.
Keep looking for fights, did you have many in the first section? The social order is established but you are looking for a change in this order brought about by the removal of the animals from the pen. This would occur in the part 3, the Y files so to speak. Are you working on the Z files right now?
Hey Jeff, attached is one of the files for fights, it is for pens 38/40 day 1 of time period 1 (5/11/99. I could only input pigs involved separated by an asterick since if I did a backslash it automatically put a date in there! Is there a better way to do this so SAS can read it fine? Let me know if there are any changes to the format you want and then I will finish inputing the data from other tapes onto a spreadsheet - you must think my brain is already on break to forget to send these to you!!
Oh yeah - NCW means No Clear Winner. Lisa 38.40-5.11.99.xls
You could use the system I show in Fightkey.xls which is attached or keep doing what you are doing, we will need to work with the data before attempting SAS. There should also be column with the date information. Do you have all the fight information already or do you need to review the tapes again?
Jeff: Oh I have all the data for fights hand written, just need to finish putting them in a spreadsheet for you. I am so glad to be done watching tapes, although I have to admit, I enjoyed that more than lab work!
So if I understand your key correctly, could I just put 24 when pigs 2 and 4 are fighting instead of 2*4?? Lisa
How do you like this spreadsheet - this is all the fight data for pens 34/36. I included who PIG 1 is, etc. at bottom. If there is ever an asterisk beside a winner (especially for NCW) that means I have a note for that fight like for instance, 1*6 and NCW but my note is that 1 ate but there were no signs of submission physically between the pigs. Almost like they grew tired of fighting although they hadn't resolved the dominance issue, they both seem to simultaneously ignore each other. I will continue entering the data the same way unless you tell me otherwise.
Oh, do you know any Excel trick so that I don't have to keep going to main keyboard to type in the : between the start time and finish time numbers, because otherwise I am using the number key pad on the right of my keyboard, it would be a time and finger saver if there was a trick. Thanks, Lisa
>So if I understand your key correctly, could I just put 24 when pigs 2 and 4 are fighting instead of 2*4??
>I will continue entering the data the same
> way unless you tell me otherwise.
I moved the other data to the side, it will be nice to have all the pens on one sheet.
> Oh, do you know any Excel trick so that I don't have to keep going to main
> keyboard to type in the : between the start time and finish time numbers,
> because otherwise I am using the number key pad on the right of my keyboard,
> it would be a time and finger saver if there was a trick.
You might try dragging down a time, like you are doing for the fight time, or format the entire column to time style maybe. Isn't Excel fun.? Jeff