Ange1 Posted July 15, 2008 Share Posted July 15, 2008 Now I'm on egg 3 and my thoughts turn to a spreadsheet! I've heard wonderful things about all your exell spreadsheets, but I don't know where to start! Do you do it month by month basis, or over the year? Do you have your girls listed accross the top and egg weights underneath, though I'm still not sure how you will know who's laid what egg, (see my other post) What do you put in yours and what do you use for? Work out average weight of a girls egg? To see how long you've had them and predict when they're due a moult? To see egg production patterns? To see how much your eggs are costing you against the cost of the cube?! Any tips would be good. Sorry to be a nuisance! Quote Link to comment Share on other sites More sharing options...
Ange1 Posted July 15, 2008 Author Share Posted July 15, 2008 Just wanted to say thanks for whoever removed the duplicate post! Not sure how that happend! Sorry! Quote Link to comment Share on other sites More sharing options...
Cinnamon Posted July 15, 2008 Share Posted July 15, 2008 No problem - I moved this one over to Eggs as well Sorry I can't help with the spreadsheets question though! Quote Link to comment Share on other sites More sharing options...
Grovefarm Posted July 15, 2008 Share Posted July 15, 2008 dont know quite how you would like to arrange your spread sheet but to work out the average of a range of cells you would type: AVERAGE(a1:a7) replace a1 and a7 with your start and end cell ranges. Quote Link to comment Share on other sites More sharing options...
Ange1 Posted July 15, 2008 Author Share Posted July 15, 2008 Ooh Deatils, thanks Dale! I've an IT minded boyfriend who has offered to set up a spreadsheet for me; he just needs to know what I want to include?! He's like Quote Link to comment Share on other sites More sharing options...
Egg Lou Posted July 15, 2008 Share Posted July 15, 2008 Hi I keep mine fairly simple.. column for each date, each girl and total.. under the girls I put the weight then total laid for each day in total (of course) .. Then an excel sum at the end of each month to automatically give running total each month which then adds up also giving automatic update for year to date on another part of sheet...and so on... oh this does not sound simple now Quote Link to comment Share on other sites More sharing options...
Ain't Nobody Here Posted July 15, 2008 Share Posted July 15, 2008 Here's mine . Easier than describing it (hope you can see it OK). I can always email you a copy if you want. Quote Link to comment Share on other sites More sharing options...
Egg Lou Posted July 15, 2008 Share Posted July 15, 2008 Now that looks simpler than explaining.. why didn't I think of just posting pic Mine is pretty much the same as yours ANH! Quote Link to comment Share on other sites More sharing options...
Ange1 Posted July 16, 2008 Author Share Posted July 16, 2008 Oooh I like it, I like it ANH! Yes please I've pmd you my email address! Quote Link to comment Share on other sites More sharing options...
Ange1 Posted July 16, 2008 Author Share Posted July 16, 2008 Dianne was kind and offered to email hers too! So I'll have a couple to compare and contrast, thanks for everyone's help! Quote Link to comment Share on other sites More sharing options...
Gamebird Posted July 16, 2008 Share Posted July 16, 2008 Mine's the same. Hubby set mine up for me. I could have done it myself but he's much quicker! Quote Link to comment Share on other sites More sharing options...
