The Accidental Smallholder Forum

Livestock => Pigs => Topic started by: P6te on January 23, 2013, 10:37:37 am

Title: All in 1 Pig Calculator - Now available to download from TAS
Post by: P6te on January 23, 2013, 10:37:37 am
I have produced a spreadsheet in excel that calculates the following:

1. Forward Projected Farrowing date calculation
2. Reverse Farrowing date calculation
3. Cost calculator

In all cases you input your own master data and the remainder is calculated for you.

1. Forward projected Farrowing date calculation

Input conception date, the age at which you will wean the piglets, the age you anticipate they will be to achieve pork weight and it calculates:

1. Projected farrowing date
2. Projected weaning date
3. Projected Pork weight date

2. Reverse Farrowing date calculation

Input the data at which you want the piglets to reach Pork weight, the projected age to reach pork weight, and the age at which you will wean the piglets and it calculates:

1. Required conception date
2. Anticipated farrowing date
3. Required weaning date

3. Cost calculator

Input the date you wish the calculation to be based on, the age of the piglets at that date, the age you anticipate they will be to achieve pork weight, the number of pigs, the unit you purchase feed in (20kg, 25kg, tonne), the cost for the unit and the amount of food you feed (per day / month of life) and it calculates:

1. Projected Pork weight date
2. The cost to achieve that weight
(it also shows the cost of feed / lb and the corresponding feed / day in Kgs)

See the screen shots below .... if anyone would like a copy please PM me with your email address and I'll send it to you.

No guarantees given but it all appears to be working correctly.  If you find any error or can think of anything else worth adding just let me know.

Pete

Screen shot of Forward projected Farrowing date calculation
(http://i1140.photobucket.com/albums/n578/P6te/Forwardfarrowingscreenshot_zpseff7d890.jpg)

Screen shot of Reverse Farrowing date calculation
(http://i1140.photobucket.com/albums/n578/P6te/ReverseFarrowingscreenshot_zpse15c028b.jpg)

Screen shot of Cost Calculator
(http://i1140.photobucket.com/albums/n578/P6te/Projectedcostscreenshot_zpsf13b8688.jpg)



Title: Re: Farrowing Date and Feed Cost Calculator - and more ...
Post by: Fowgill Farm on January 23, 2013, 11:05:09 am
Woooooooooooooooooooow..........you have way too much time on your hands! ;D
mandy :pig:
ps they're very good and useful. :thumbsup:
pps have you told the pigs about this :roflanim:
Title: Re: Farrowing Date and Feed Cost Calculator - and more ...
Post by: P6te on January 23, 2013, 11:27:53 am
pps have you told the pigs about this :roflanim:

They have bought into the farrowing bit but I've kept quiet about the Pork Weight aspect!!  :roflanim:
Title: Re: Farrowing Date and Feed Cost Calculator - and more ...
Post by: P6te on January 23, 2013, 03:50:53 pm
 I’ve added some additional information as shown below.
 
The new section ‘Total costs incurred’ works in conjunction with ‘Projected Cost Calculator based on current date / age.’
 
The number of pigs and the cost of feed is used in the new ‘Total Costs incurred section’.
 
I’ll email an updated version to all those who have received it already… once any more feedback has been received and actioned by me.
 
As before, if you would like a copy please PM quoting your email address.
 
Pete
 
(http://i1140.photobucket.com/albums/n578/P6te/TotalCosts-additionalinformation_zpscc9ceaed.jpg)

 
Title: Re: Farrowing Date, Feed Cost Calculator and more ...
Post by: Tamsaddle on January 24, 2013, 08:26:09 am
Very good idea, although I have one of my own already.    Mine makes my piglets "pay" for their mum as well, so that all of her feed and other costs from the previous weaning time to current weaning time are added up and divided by number of surviving piglets/weaners and added to each pig's costs.   Makes for expensive pigs, but that way I feel I have really covered the true costs of producing my own pigs from scratch.    Hope you get some takers, seems like others on here are not enthralled by the arithmetic of pig keeping!    Tamsaddle
Title: Re: Farrowing Date, Feed Cost Calculator and more ...
Post by: P6te on January 24, 2013, 09:07:01 am
Thank you for the comments Tamsaddle

Because I asked people to PM me if they would like a copy the 'interest' isn't reflected in this thread.  So far I have sent out 9 copies and made a few enhancements along the way.

I will look to incorporate your comments too ... all feedback most welcome and if anyone else would like a copy just ask (and don't forget to include your email address!)

Pete
Title: Re: Farrowing Date, Feed Cost Calculator and more ...
Post by: ppd on January 24, 2013, 09:42:04 am
 :wave: I asked for one and love the fact that thanks to petes hard work I have a much better idea of the costs involed in producing pork.
 Only done it for friends and family so far but have others showing interest, so this will be a godsend :thumbsup:
The last two weaners that I had, I did keep a record of costs, but just in a notebook, so this will make my life much simpler and because I have other pigs I can work out the costs for the weaners.
Also a good point Tamsaddle to include the sows feed in the total costs of the weaners :thumbsup: (not that I need that bit yet - but will do in the future)
And sorry Pete, it did look like people were not interested, so thought I would say that I think it's a great idea and well done for sharing it with us :trophy: :thumbsup: :trophy: :thumbsup:
Pailine
Title: Re: Farrowing Date, Feed Cost Calculator and more ...
Post by: Mrs Snoodles on January 24, 2013, 07:14:21 pm
I too was a notebook girl.  vast sums but excel is the way fwd!  Thanks Pete :)
Title: Farrowing, Feed Cost and now Cost of weaner calculator included ....
Post by: P6te on January 24, 2013, 11:12:47 pm
Hi,

I've done an update to the spreadsheet .... it now includes a new sheet that calculates the cost of weaners taking into account the cost of keeping a boar(s), using AI, and keeping sow(s). Please see the screen shot below.

I have emailed a copy to all those who replied previously .... any more takers just PM or email me.

Note.  This works best with Excel 2010 or later, I have a version that should be compatible with earlier versions although some issues have been experienced with very early versions of Excel

Pete

(http://i1140.photobucket.com/albums/n578/P6te/CostofWeanerscalculations_zps72773b36.jpg)
Title: Re: Farrowing, Feed Cost and now Cost of weaner calculator included ....
Post by: Tamsaddle on January 25, 2013, 07:54:20 am
Wow very impressed.   Will PM you to get a copy - thanks, Tamsaddle
Title: Re: Farrowing, Feed Cost and now Cost of weaner calculator included ....
Post by: Hassle on January 27, 2013, 01:46:01 pm
P6te

thank you very much that looks really good  :excited:
Title: Re: Farrowing, Feed Cost and now Cost of weaner calculator included ....
Post by: P6te on January 27, 2013, 07:00:27 pm
Thank you to everyone for comments and suggestions ... I am working on various enhancements and as soon as ready I'll email it to everyone who has previously requested a copy (I've lost count of the number now but have all email address to hand when needed!)

I am looking to build a 'model' the takes into account the total costs in a meaningful way and also looking to incorporate the value of a sow / boar at the end of their 'working life'.

Below is a screen shot of where I have got to so far (on the sheet in question) ... but note that this is VERY much work in progress so some aspects may appear a bit disjointed / incomplete ... you'll see where I'm heading so if you would like to have an input just PM or email me.

As before, if you haven't already requested a copy and would like one just PM / email me.

(http://i1140.photobucket.com/albums/n578/P6te/Version6preview_zpse9058906.jpg)

Title: Re: Farrowing, Feed Cost and now Cost of weaner calculator included ....
Post by: P6te on January 29, 2013, 08:23:41 am
All,

The latest version is now available ... I have emailed it to eveyone who contacted me (if you've not received a copy please let me know) ... and as before any new takers just PM me.  Below are the revised screen shots.

Pig Rearing Cost Calculator
(http://i1140.photobucket.com/albums/n578/P6te/Pig%20Calculator%20Spreadsheet/PigRearingCostCalculator_zpsbfc39a55.jpg)

Breeding Cost Calculator
(http://i1140.photobucket.com/albums/n578/P6te/Pig%20Calculator%20Spreadsheet/BreedingCostCalculator-2_zps9e7bb219.jpg)

Pig Rearing Date Calculator
(http://i1140.photobucket.com/albums/n578/P6te/Pig%20Calculator%20Spreadsheet/PigRearingDates_zps448670bb.jpg)


Title: Re: Vn 6 - Farrowing, Feed Cost and now Cost of weaner calculator included
Post by: the great composto on January 29, 2013, 08:57:12 am
 :thumbsup: thanks p6te - more impressed now
Title: Re: Vn 6 - Farrowing, Feed Cost and now Cost of weaner calculator included
Post by: domfoy on January 29, 2013, 01:38:32 pm
Hi, thanks for your hard work. Please may I have a copy?


domfoy@yahoo.com


Cheers
Title: Re: Vn 6 - Farrowing, Feed Cost and now Cost of weaner calculator included
Post by: SMarshall on January 30, 2013, 06:27:29 pm
Hi Pete

Thanks for this, looking forward to testing it out!

Cheers
Steph
Title: Re: Vn 6 - Farrowing, Feed Cost and now Cost of weaner calculator included
Post by: Polished Arrow on February 03, 2013, 10:29:10 pm
PM on its way  :sunshine:
Thank you for your generosity!
Title: Re: Vn 6 - Farrowing, Feed Cost and now Cost of weaner calculator included
Post by: P6te on February 04, 2013, 08:44:16 am
Hi Debs,

I've emailed a copy to you .... please let me have any feedback and I'll use that to enhance and improve it further.

Pete
Title: Re: All in one calculator, Feeding, Breeding, Rearing and date calculator
Post by: jellybean on February 16, 2013, 02:01:59 am
Hey Pete, can it be converted to Dollars and Cents for those that live in other countries  I live in Oz and would love a copy of this........ would make running the piggery so much easier.
Title: Re: All in one calculator, Feeding, Breeding, Rearing and date calculator
Post by: P6te on February 27, 2013, 01:09:37 pm
All,

Since the screenshots above were posted I have done considerably more work to the calculator.  I have also been working with Dan  (http://www.accidentalsmallholder.net/forum/index.php?action=profile;u=1)to make this available as a download and he has now completed the necessary work.

The download site is located in, Livestock, Pigs Guides and Articles, Pig Costs, All in 1 Pig Calculator …. shortcut located here (http://www.accidentalsmallholder.net/livestock/pigs/pig-calculator/).

The version that is available for download has a number of enhancements a well as a user guide that are not present in the earlier versions.  Dan (and others) believed that considering the amount of work that has gone into the calculator it would be reasonable to look for some return and therefore it has been put on as ‘donationware’.

I am working on a number of enhancements that will be released in due course.  In the meantime I hope it is proving useful and if you have anyone has suggestions for improvement please let me know and I'll do my best to incorporate them.

Pete
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: OldTimes on March 18, 2013, 07:36:11 pm
We are about to have our first lot of weaners delivered in two weeks and, taking on a third to keep for friends, this spreadsheet looks to be a great financial tool.

This must have taken an amount of time to produce however, we fully appreciate your hard efforts to make our first time pig keeping a success.

We need every tip and hint we can get. Thank you.
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: Alastair on April 08, 2013, 01:52:11 pm
Spreadsheet sounded great, should prove we are running at a loss :(

Downloaded it but when I try to open the zip it reports as an invalid zip file. Am I doing something wrong?
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: P6te on April 08, 2013, 02:27:05 pm
Hi Alastair,

I've just downloaded it again myself to check and it appears fine.

Click Download now -> Select 'Save File' -> Open the folder containing the download -> Double click on 'pig-calculator.zip' and it should open the zipped file.  From there I recommend dragging and dropping the files into a suitable directory and then open them as any other Excel file from that point.

If you still have trouble PM me with you email address and I'll mail the unzipped files to you.

Pete
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: kezzybaggage on April 08, 2013, 10:21:58 pm
Hello am very interested in your pig calculator but for some reason my pc won't open zipped files! Can I get it any other way please? many thanks Lorna
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: P6te on April 09, 2013, 07:47:50 am
Hi Lorna,

I've PM'd you.

Pete
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: Andrew246 on May 08, 2013, 08:24:29 pm
Hi I'd love to see the pig calculator, but I cant seem to download and then unzip? Am I doing anything wrong?

If you could email an unzipped copy I'd be very grateful...Andrew
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: P6te on May 08, 2013, 09:39:28 pm
Hi Andrew,

I've sent you a pm.

Pete
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: P6te on May 18, 2013, 08:27:30 pm
All,

Just to clarify, the download is available from:

Livestock -> Pigs -> Pig costs / All in 1 Pig Calculator which takes you to:

http://www.accidentalsmallholder.net/livestock/pigs/pig-calculator/ (http://www.accidentalsmallholder.net/livestock/pigs/pig-calculator/)

Pete
Title: Re: Farrowing Date and Feed Cost Calculator - and more ...
Post by: Hoefakker on May 21, 2013, 08:14:53 am
I’ve added some additional information as shown below.
 
The new section ‘Total costs incurred’ works in conjunction with ‘Projected Cost Calculator based on current date / age.’
 
The number of pigs and the cost of feed is used in the new ‘Total Costs incurred section’.
 
I’ll email an updated version to all those who have received it already… once any more feedback has been received and actioned by me.
 
As before, if you would like a copy please PM quoting your email address.
 
Pete
 
(http://i1140.photobucket.com/albums/n578/P6te/TotalCosts-additionalinformation_zpscc9ceaed.jpg)
Title: Re: Farrowing Date and Feed Cost Calculator - and more ...
Post by: Hoefakker on May 21, 2013, 08:30:29 am
Hi Pete,

I have tried to downl the calculator from the site bud it keeps saying that it is incomplete when unpacking so could u email me ure calculators on pigs I'm trying to help some poor people in the Philipines to bread pigs.
the email ddinkey@hotmail.com
thnx in advance

D.Hoefakker
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: Ferrisbp on June 21, 2013, 10:49:46 am
Pete,

Would it be possible to send me a copy of the spreadsheet? I have downloaded from the website but am unable to open the Zip file.

Thanks

Ben
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: zarzar on September 17, 2013, 09:04:22 pm
 :wave: This looks awesome could you send me a copy to zaraglenfield@yahoo.co.uk please.
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: Johanstr on November 16, 2013, 09:10:52 am
Please, may I have a copy of the calculator?
Regards
johanstr@axxess.co.za
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: littlebowhay on January 09, 2014, 09:19:55 pm
please send us copy of calculator

mandj@littlebowhay.co.uk

thanks
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: P6te on January 09, 2014, 09:46:41 pm
Hi Littlebowhay,

Just to clarify, the download is available from:

Livestock -> Pigs -> Pig costs / All in 1 Pig Calculator which takes you to:

http://www.accidentalsmallholder.net/livestock/pigs/pig-calculator/ (http://www.accidentalsmallholder.net/livestock/pigs/pig-calculator/)

If you have any problem then please PM me.

Pete
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: sandy oaks farm on March 18, 2014, 05:19:55 am
e-mail the all in 1 pig calculator download.

thanks,
jack
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: cwmfarm123 on March 21, 2014, 08:00:51 pm
 Hi can youemail me a excel copy please, I cant seem to download one from the site.

Cwmfarm@hotmail.co.uk

Thanks ruth
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: P6te on March 23, 2014, 07:44:22 pm
Hi can youemail me a excel copy please, I cant seem to download one from the site.

Cwmfarm@hotmail.co.uk

Thanks ruth

Hi Ruth,

I have emailed you.

Pete
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: stevenb42 on April 14, 2014, 11:32:27 am
 ???
This pig calculator looks like a great idea but I can't get it downloaded.
I've tried from the main pages and from links shown on replies but still
no luck.
Can you send me a working link or tell me what I am doing wrong please?
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: P6te on April 14, 2014, 12:18:21 pm
Hi Stevenb42

I'm afraid a few people have reported this to me and I'm not sure why it affects some but not others. If you pm me with your email address I'll sent a copy to you tonight.

Pete
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: stevenb42 on April 14, 2014, 04:56:27 pm
If you could email it over to steven@lazyboy.co.uk that would be ideal
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: Nethermoor Pigs on April 29, 2014, 06:25:38 am
Can you send me a copy? titus.brown@atomlogistics.co
Thanks.
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: clowe123 on August 02, 2014, 06:53:07 pm
hi please can you send me a copy of this spreadsheet you have made.

many thanks
Charles

thehunter6931@icloud.com
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: tattycat on March 03, 2015, 08:11:17 pm
Hiya . me too please
fionawaugh@live.co.uk
Thank you.   :innocent:
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: P6te on March 03, 2015, 09:12:38 pm
All,
Just to reiterate, version 1 of the spreadsheet is available to download from TAS here:
http://www.accidentalsmallholder.net/livestock/pigs/pig-calculator/ (http://www.accidentalsmallholder.net/livestock/pigs/pig-calculator/)
In the event you have a problem then please contact me.
Pete
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: carfarmer on March 23, 2015, 09:16:16 pm
Thanks for the calculator, i had started one myself, so youv'e saved me a lot of time.

My business plan has some propper figures now and it actually look positive!  :fc:
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: tattycat on April 13, 2015, 09:33:23 pm
Yay!! Think the phone's letting  me  do it!! No thanks to the cat though...keeps butting the phone....been at the catnip!! :thinking:
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: Mickturtle on July 08, 2015, 02:54:08 pm
Could you send it to me please
Mick.turtle@sky.uk
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: tgad2007 on December 09, 2015, 11:38:09 am
Hi, what you have done is fantastic and will hopefully save me loads of time.  Is there a way of making more values available on the 'Enter feed quantity by age section as I plan to be cutting back feed on my Berkshires to prevent too much fat being layed down.  The only options on that bit from 5months onwards are 4 or 5lbs, is it possible that i can add the option of 3 and 2 lbs.

Kind Regards
tom
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: P6te on December 09, 2015, 09:30:11 pm
Hi, what you have done is fantastic and will hopefully save me loads of time.  Is there a way of making more values available on the 'Enter feed quantity by age section as I plan to be cutting back feed on my Berkshires to prevent too much fat being layed down.  The only options on that bit from 5months onwards are 4 or 5lbs, is it possible that i can add the option of 3 and 2 lbs.

Kind Regards
tom

Hi Tom,

Thank you for your comments.  As you know the All in one Pig Calculator is available for download with a voluntary donation of £5. Whenever anyone makes the donation I endeavor to send them the latest version which is not available to download.  The latest version has a lot more functionality and I have just extended the range of values available on the "Feed Settings" tab to include those you suggested.

Many thanks

Pete
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: tgad2007 on December 10, 2015, 08:27:57 am
Lovely job. Donation on its way, do I then download it again or will you email it to me?
tgad2007@yahoo.co.uk
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: P6te on December 10, 2015, 09:10:09 am
Thanks Thomas,
I'll email the latest to you this evening.
Pete
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: P6te on August 09, 2016, 08:27:51 am
A few people have asked so just to clarify, whilst the download from TAS is fully functional and the donation 'optional', when a donation is made I email# the latest version to you which contains a lot more functionality.

# The email address associated with your paypal account.

Thanks

Pete
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: dbuddsf on September 03, 2016, 08:13:40 am
Hi Can you send us a copy of the excel spreadsheet. It looks really helpful. thanks
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: Siveheart on April 05, 2017, 08:12:41 pm
I'd like a copy please. My email is teresaamcampbell@yahoo.com Thanks so much for providing this!
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: donato on July 17, 2018, 05:37:23 pm
can you please have also a copy? filonlinebiz@gmail.com. Thank you very much
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: Dan on July 17, 2018, 08:16:11 pm
can you please have also a copy? filonlinebiz@gmail.com. Thank you very much

You can download it here: https://www.accidentalsmallholder.net/livestock/pigs/pig-calculator/ (https://www.accidentalsmallholder.net/livestock/pigs/pig-calculator/)
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: fourshirefarms on July 14, 2020, 07:40:12 pm
 can i  ask  what  your calculator  deems as pork weight  can this be  altered at all
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: P6te on July 14, 2020, 08:02:55 pm
I can’t remember if it can be on the one that is downloaded from TAS but when the donation has been made and I send the latest version to you it certainly can be changed as you wish.
Hope this helps.
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: fourshirefarms on July 14, 2020, 09:25:14 pm
i have  made a donation  can  you email me the  other version  please
fourshirefarms@gmail.com
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: P6te on July 14, 2020, 10:18:00 pm
Hi Kristian,
The latest version has just been emailed to you.
Pete
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: Twinnzpigs on July 18, 2020, 05:35:42 pm
Hi,

would it be possible to get a copy, foursome reason it won't let me pm you so, edtwinn@icloud.com

thanks! hopefully you still have it  :)
Title: Re: All in 1 Pig Calculator - Now available to download from TAS
Post by: nosoko on September 27, 2020, 11:00:03 am
Hi P6te,

Would you be so kind and send me a copy of calculator , nosoko2@gmail.com

Thanks in advance