Record keeping suggestions

[moorej7]

I am working on writing a record-keeping software. I have some good ideas, but I'd like to hear of some others that I haven't thought of yet. I have the biggest part of the database design completed, but I want to finalize the design before I start coding.

I am already tracking info on each

snake: dob, sex, clutch_id (clutch it was born from), death_date, aquire_date, aquired_from, sell_date, sold_to, all genetics info (complicated! includes color, phase, and pattern morphs), and a description.

clutch: date, size, number_of_viable_eggs, number_of_viable_offspring.

breeding: clutch (resulting from this breeding), date, male, female, copulation_occured(yes or no)

feeding: date, item_size, number_offered, number_eaten, regurgitated (yes/no)

measurement: date, weight, length

Thanks in advance for any input/suggestions/questions.

Jerod

 

[bmm]

Honestly, this is just me here most likely, I always like the most simple "snake trackers"

I make simple documents in word which have the snakes type, age and place aquired from at the top....and in colums feeding dates, food item, was it accepted and one for notes.

But yours sounds pretty good so far!!!! Good luck with that.

bmm

 

[Susan]

You may want to add a spot to put shed dates.

 

[Drizzt80]

Even though I too just use simple spreadsheets designed to my personal needs, I'd throw in shed dates, food type - frozen/thawed or live etc., and supplements given -vitamins, acidophillus, etc.

Just off the top of my head.
D80

 

[Chip]

I love your idea.

Will the program total numbers (mice per week/month/year, sheds per year, etc) or be a sheet to record data? I use (on paper) an F or an L, to designate frozen/live and have size abbreviations, like pk, fz, cr, hp, sm, or M (for pink, fuzzy, crawler, hopper, small mouse, mouse) and similar terms for rats. My friend Clay Davenport (arbreptiles.com) uses a program that tells food intake and such for yearly or monthly totals, which would be interesting to look back on.

What I'd really find useful is an adhesive pad to stick on the outside of each cage that would have number and weight of food items, etc. I can't tell you how many times I've tried to figure out when there's an uneaten mouse moved to another cage "My note says I put in two, but was it just one? eek: "

 

[h0mersimps0n]

This is what I use...


HERE it's an excel sheet I put together quickly when my collection got bigger and younger.

I'm probably going to spruce it up but it definitely is sufficient and serves it's purpose.

Let me know what you think/hope it helps

P.S.

"Maggie" is my '99 Ball python
"BIMMER" and "HIDIE" are my adult '01 corns
"ATHENA" is my growing-like-a-weed female anery showing zig-zag
"MORPHEUS" is my male Anery

and yes, I've gotten the rest of those UNNAMED 03's in the past few months and haven't gotten names- I know, I know, I'm bad.

HERE ARE THE PICS

 

[Chip]

Doh! Why you little...

Homer,
No luck opening the program, though I am very interested in seeing it. Windows evidently needs to know what program created it.

 

[h0mersimps0n]

lol, DOH!

hey, it's not a program, it's just an excel sheet (*.xls file)

Just download it to your desktop and open it in MS EXCEL. Unfortunately you need MS office (or STAR OFFICE) to open it. You can open without downloading you just have to point the file to EXCEL program...

good luck, hope you like