Backyard Aquaponics
http://byap.backyardmagazines.com/forum/

design tables and other spreadsheets for AP
http://byap.backyardmagazines.com/forum/viewtopic.php?f=1&t=4150		 Page 1 of 1
Author:  hygicell [ Sep 17th, '08, 20:40 ]
Post subject:  design tables and other spreadsheets for AP
"WARNING ! don't download this spreadsheet unless you have checked further in this thread if there isn't a newer version
and regularly come back to look for updates."

here is a spreadsheet to calculate:
- filter media volume versus feed rate
if we know the relative surface of different size gravel or other media we can add them to it
- relative fish density
fish density versus recirculation rate
- pump efficiency
- filter surface to Koi pond volume ratio
- controlling O2 concentration
not finished, only equations, so if someone feels tempted...

Attachment:
hygicell filter biomedia and other calculators.zip [10.71 KiB]
Downloaded 286 times


feel free to use it, but do so at your own responsibility :geek:

Frank
Author:  Outbackozzie [ Sep 17th, '08, 20:45 ]
Post subject:  Re: design tables and other spreadsheets for AP
Wow! That does my head in at 9pm lol - I'll try it again later :lol:
Author:  Xzorby [ Sep 17th, '08, 21:16 ]
Post subject:  Re: design tables and other spreadsheets for AP
Calculators! Yay!

Here's my spreadsheet (V2 - it's still a work in progress) viewtopic.php?p=128111#p128111.

Input:
- Growbed, sump and FT size (sump is currently added to FT size)
- Pump output at head

Optional input (you can leave these at the standard values):
- Fish feeding rate
- Protein content of fish food
- Feed conversion rate

There is also an input box for other nutrient sources than fish food (ie peeponics and fertilisers).

The sheet then calculates:
- How much you can feed per day
- How many kg of fish your system can handle

It also tells you if your FT or pump is too small.


Please leave a comment in the thread if you use my sheet, so I can see how accurate it is!
Author:  Hex [ Sep 18th, '08, 01:21 ]
Post subject:  Re: design tables and other spreadsheets for AP
Nice calculator.
It might be useful to add some of the more common types of media to the list, 10mm gravel is around 315 m2/m3. Its considerably cheaper than kaldness k1 too :wink:
Author:  hygicell [ Sep 18th, '08, 02:09 ]
Post subject:  Re: design tables and other spreadsheets for AP
Quote:
considerably cheaper than kaldness k1 too :wink:

and if you see the volume of Kaldnes needed compared to simple beads ...

Ooops, just found two little errors:

here is the corrected spreadsheet V2:
Attachment:
hygicell filter biomedia and other calculators V2.zip [10.84 KiB]
Downloaded 260 times


sorry

frank
Author:  hygicell [ Sep 18th, '08, 02:20 ]
Post subject:  Re: design tables and other spreadsheets for AP
May I suggest to use a uniform legend for these spreadsheets?

(not necessarily mine)

this is mine:

legend (suggested as standard for other calculators)
color - instruction
variables:
bold blue to play around with, only tick in numbers, the units are added automatically
calculation results
bold orange - don't mess with these !!!
data provided by suppliers or found in papers
bold black - some might have to be checked
data provided by suppliers or found in papers
bold green - should be checked
important remarks
bold red

greetings

Frank
Author:  hygicell [ Sep 28th, '08, 10:46 ]
Post subject:  Re: design tables and other spreadsheets for AP
V3 can be downloaded:
Attachment:
hygicell filter biomedia and other calculators V3.zip [35.19 KiB]
Downloaded 276 times


have fun

Frank
Author:  hygicell [ Sep 28th, '08, 22:12 ]
Post subject:  Re: design tables and other spreadsheets for AP
V4 includes a calculation of biofilter volume needed when using 10 mm gravel:
Attachment:
hygicell filter biomedia and other calculators V4.zip [36.02 KiB]
Downloaded 306 times

anyone knowing of other media specific surface, please tell me, I will include it

but please stay cautious with this spreadsheet: it is founded on information I found on the net
a lot of this info is contradictory

so some assumptions based on them might be wrong

still:
have fun

frank
Author:  Outbackozzie [ Sep 30th, '08, 19:00 ]
Post subject:  Re: design tables and other spreadsheets for AP
I'll download it and have a look when i get home next weekend Frank - I am very interested to see what it comes up with for my system :cheers:
Page 1 of 1 All times are UTC + 8 hours
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/