LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Reformatting data.. Help a LSU grad student!

Here's the break-down:

I'm a grad student at LSU working with deer....

I caught a bunch of deer and put tracking devices on them. I've followed
them around for 1-2 years depending on the deer.

Thus, I have a data file for each deer that list all the dates in which I
located the animal:

Date1
Date2
Date3
.....Date228


In one of my analysis I am estimating the probability of an animal surviving
through the year or season.....
To do this, I am using Program MARK -

Program MARK uses 'encounter histories' to do this...

Thus....my data (from above) must be reformatted into an 'encounter history'
.......

with '10' meaning the animal was alive when i located it.

Thus, the above data set should then look like:

101010.......10

So, is there anyway that I can convert a list of dates (in the format
12312009) into one line of an 'encounter history'???
Can excel string together a '10' for every cell that was being used (had a
date in it)............?

Otherwise, I've got 48 deer with 200+ encounters each....... I'm looking at
manually entering ten-thousand '10''s.

Any ideas??

Any help would be much appreciated...

Thanks -

Justin
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Reformatting data from one spreadsheet to another in the same work JackGombola Excel Discussion (Misc queries) 0 May 15th 08 09:18 PM
Stopping Excel from reformatting data as a date? GW Excel Discussion (Misc queries) 1 May 13th 08 02:03 AM
Reformatting data and consolidating lcotner Excel Worksheet Functions 2 April 17th 08 07:40 PM
Data dissapears when reformatting a chart Nateman Charts and Charting in Excel 1 April 19th 06 10:14 AM
Data Formatting/Reformatting TimR Excel Discussion (Misc queries) 0 December 21st 05 04:14 PM


All times are GMT +1. The time now is 03:22 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"