Reptile & Amphibian Forums

Welcome to kingsnake.com's message board system. Here you may share and discuss information with others about your favorite reptile and amphibian related topics such as care and feeding, caging requirements, permits and licenses, and more. Launched in 1997, the kingsnake.com message board system is one of the oldest and largest systems on the internet.

Click for ZooMed
Click for 65% off Shipping with Reptiles 2 You

Keeping records in Excel

paulnola Dec 02, 2006 10:29 PM

Does anyone here use Microsoft Excel or some other program to keep records such as feedings, sheddings, vet visits, etc. for their snakes? Has anyone made any templates or charts? Years ago I used a columned log book, but it would be easier to keep records on my pc.

Replies (4)

Beaker30 Dec 03, 2006 07:47 AM

I currently use Excel. I keep records for feedings, sheds and length (every 3 mos) in 3 columns. At the top I have the snakes name, hatch date and what I paid for it. I have a separate worksheet for each snake and I just rename each tab with a species indicator. No templates or anythng special. But it works well for me.
-----
0.1 Amelanistic Corn
0.1 Aberrant California King
1.0 Pueblan Milk
0.1 Blair's Gray Banded King
0.1 Blonde Trans Pecos Rat
1.1 Silver Trans Pecos Rat
1.0 Variable King
0.1 Chihuahua Mtn. King
0.1 Kunasir Island Rat
0.1 Baird's Rat
0.1 White Oak Gray Rat

dniles Dec 03, 2006 08:22 AM

I have a template I created in excel that I use to track sheds, weight, feedings, breedings, etc. It also has space to document the source, sex, date acquired, etc.

I actually print the sheets and complete them manually and keep them in a binder (I'm old school) but the could be completed electronically as well.

Email me if you're interested in seeing a copy.

dnsreptiles@yahoo.com

Dave

DNS Reptiles

chrish Dec 03, 2006 09:53 PM

I use excel, but because I have 30 snakes, I setup a page with the snakes in the first column and each day of the month in the following columns. I print it out to keep in the snake room, but enter the data in the computer at the end of the month. I have abbreviations for all the events (SH - shed,RW - rat weanling,PK - pinkie, etc.) and I record the mass of the food item. At the beginning of each month I weigh each snake and enter it in a separate spreadsheet. My feeding spreadsheet looks up that data and puts it in the appropriate column.

I use a separate worksheet for each month and a separate file for each year. I have been doing it this way for years.

-----
Chris Harrison
San Antonio, Texas

paulnola Dec 03, 2006 10:00 PM

Chris,
Could I try a copy of this? It looks very well organized.
Thanks

Site Tools