A site that will help you determine what & how much you can stock
- Thread starter yhbae
- Start date
This situation is kinda funny,
My spreadsheets started as an entirely formula-driven calculation but is slowly becoming more akin to a database-driven calculation. Yhbae's calculations, on the other hand, seem to be more database-driven (from what I understand), but, if he decides to account for some of those plant requests he received, may incorporate more formulas. Kinda ironic that we started on either side of the spectrum and are slowly moving toward each other's approaches. Maybe we will meet in the middle, lol?
MOA
My spreadsheets started as an entirely formula-driven calculation but is slowly becoming more akin to a database-driven calculation. Yhbae's calculations, on the other hand, seem to be more database-driven (from what I understand), but, if he decides to account for some of those plant requests he received, may incorporate more formulas. Kinda ironic that we started on either side of the spectrum and are slowly moving toward each other's approaches. Maybe we will meet in the middle, lol?
MOA
Haha that would be funny... 
Yes, my app is more focused on individuality of species and equipment so I guess it could be called DB-driven. I'm not sure how you approached this but I couldn't figure out a way to address every single issues using formulas alone no matter how much I tried fine tuning them.
Yes, my app is more focused on individuality of species and equipment so I guess it could be called DB-driven. I'm not sure how you approached this but I couldn't figure out a way to address every single issues using formulas alone no matter how much I tried fine tuning them.Same Here,
Formulas alone don't get you very far. Instead, I use formulas for some things and specific data points for others--not much of a way around it. No less, I have been surprised with how far the formulas have gotten me. Most of the filtration is determined by fairly exacting formulas, the fish biomass approximations are part data reference and part formula, many of the stocking "rules" are partially based on various functions, and the manual input fields are almost entirely formulaic. No less, suitability of inter-species relationships has to be done on a case-by-case basis. Also, most of the species independent biological factors are determined individually (though they are all based on one "family" function.
In short, I use formulas whenever I can since it cuts down on input time (for me), but some things are just too specific, lol.
MOA
Formulas alone don't get you very far. Instead, I use formulas for some things and specific data points for others--not much of a way around it. No less, I have been surprised with how far the formulas have gotten me. Most of the filtration is determined by fairly exacting formulas, the fish biomass approximations are part data reference and part formula, many of the stocking "rules" are partially based on various functions, and the manual input fields are almost entirely formulaic. No less, suitability of inter-species relationships has to be done on a case-by-case basis. Also, most of the species independent biological factors are determined individually (though they are all based on one "family" function.
In short, I use formulas whenever I can since it cuts down on input time (for me), but some things are just too specific, lol.
MOA
What's new for 2010 01 14 build:
- Added Threadfin RainbowFish
- Added Teacup Stingray as an alias to Motoro Stingray.
- Added Wolf Fish (Hoplias malabaricus).
- Added Sturgeon Catfish (Platystomatichthys sturio).
- Added European/European Wels Catfish (Silurus glanis).
- Added Frogmouth Catfish (Chaca chaca).
- Added Widebar/Siamese Tiger Datnoid (Datnioides pulcher).
- Added Finescale Tigerfish (Datnioides microlepis).
- Added Siamese Tigerfish (Datnioides polota).
- Added New Guinea Tigerfish (Datnioides campbelli).
- Added Featherfin Rainbowfish as an alias to Threadfin RainbowFish (Iriatherina werneri).
- Added Tigrinus Catfish/Dourada Zebra (Brachyplatystoma tigrinum).
- Added Loricaria cataphracta L062.
- Added Loricaria lentiginosa.
- Added Loricaria lundbergi.
- Added Loricaria parnahybae.
- Added Loricaria prolixa.
- Added Loricaria pumila.
- Added Marbled Whiptail (Loricaria simillima).
- Added Loricaria spinulifera.
- Added Loricaria sp. Rio Atabapo.
- Added Ruby/Black Ruby Barb (Puntius nigrofasciatus).
- Added Ornate/Flase Rosy/Bentos Tetra (Hyphessobrycon bentosi).
- Increased bioload for Clown Loach. Also increased minimum number to 5.
- Mouth size of Emerald/Cholocate Cichlid has been reduced to 2 inches.
- All hatchets, African Butterfly Fish and Bettas are marked as jumpers - appropriate notes will be displayed.
- Bioload for Chocolate Cichlid has been lowered.
- Temperature requirement for Puntius semifasciolatus has been expanded/raised slightly.
- Size of Yoyo Loach has been increased to 6 inches. Also added a note that it can reach up to 10 inches on rare occasions.
- Skunk Loach has been marked as a fin nipper.
- Size of Odessa Barb has been reduced to 2 inches. Tank requirement has also been reduced to 24x12.
- Changed the message when stocking level exceeds 160% to something a bit more prominent.
- Black Pacu has been adjusted to 30 inches.
- Red Bellied Pacu has been adjusted to 30 inches.
- Minimum number for Black and Red Bellied Pacu have been brought down to 1 but added a note saying they still prefer to be in groups when they are juveniles.
- Bioloads for Black and Red Bellied Pacu have been increased.
- Adjusted pH for Oscar to 6.4 - 7.5.
- Adjusted pH for Jewel Cichlid to 6.4 - 7.5.
- Adjusted pH for Common Pleco to 6 - 7.5.
- Increased water change requirement for Common Pleco.
- Increased bioload of Jewel Cichlid slightly.
- New feature: Now it is possible to combine species that will shoal together. As a starter, Zebra Danio and similar (or same) species have been combined. It will no longer produce warnings if combined number exceeds minimum number.
- Stripped Loach and other aliases of this species have been combined for minimum shoaling species calculation.
- Same modifications have been made for Banana Loach, madagascar Rainbowfish, Mosquito Rasbora, Polkadotted Loach, Marbled hatchet, Bronze Cory, Dainty Cory, Dwarf Cory, Green Chromide, Gardneri Killfish, Hatchet, Black Skirt Tetra, Flame Tetra, Rosy Tetra, Threadfin RainbowFish, American Flagfish, Striped Glass Catfish, Red Zebra, Dwarf Rainbowfish, Dojo Loach, Holden Pencilfish, Black Kuhli, Pitbull Pleco, Leopardfish, Ballon Molly, Molly, Pristella Tetra, Bumble Bee Cichlid, Denisoni Barb, Checkered Barb, Synodontis Eupterus, Domini Syno and Swift Rasbora.
- Removed the possibility of Molly and Platy cross breeding.
- African Leaf Fish has been marked more peaceful.
- African Dwarf Frogs and African Clawed Frogs are marked incompatible due to ACFs being chytrid carriers.
- Added notes for African Dwarf Frog.
- Added notes for African Claw Frog.
- Total number of species in DB has been increased to 601.
To access the application, please click on AqAdvisor site.
Now that the application can handle minimum shoaling number for similar (but not necessarily the same scientific names) species, please forward any similar species that will actually shoal together. There are probably quite a few different corydoras species that will shoal in this manner.
No plants support yet.
- Added Threadfin RainbowFish
- Added Teacup Stingray as an alias to Motoro Stingray.
- Added Wolf Fish (Hoplias malabaricus).
- Added Sturgeon Catfish (Platystomatichthys sturio).
- Added European/European Wels Catfish (Silurus glanis).
- Added Frogmouth Catfish (Chaca chaca).
- Added Widebar/Siamese Tiger Datnoid (Datnioides pulcher).
- Added Finescale Tigerfish (Datnioides microlepis).
- Added Siamese Tigerfish (Datnioides polota).
- Added New Guinea Tigerfish (Datnioides campbelli).
- Added Featherfin Rainbowfish as an alias to Threadfin RainbowFish (Iriatherina werneri).
- Added Tigrinus Catfish/Dourada Zebra (Brachyplatystoma tigrinum).
- Added Loricaria cataphracta L062.
- Added Loricaria lentiginosa.
- Added Loricaria lundbergi.
- Added Loricaria parnahybae.
- Added Loricaria prolixa.
- Added Loricaria pumila.
- Added Marbled Whiptail (Loricaria simillima).
- Added Loricaria spinulifera.
- Added Loricaria sp. Rio Atabapo.
- Added Ruby/Black Ruby Barb (Puntius nigrofasciatus).
- Added Ornate/Flase Rosy/Bentos Tetra (Hyphessobrycon bentosi).
- Increased bioload for Clown Loach. Also increased minimum number to 5.
- Mouth size of Emerald/Cholocate Cichlid has been reduced to 2 inches.
- All hatchets, African Butterfly Fish and Bettas are marked as jumpers - appropriate notes will be displayed.
- Bioload for Chocolate Cichlid has been lowered.
- Temperature requirement for Puntius semifasciolatus has been expanded/raised slightly.
- Size of Yoyo Loach has been increased to 6 inches. Also added a note that it can reach up to 10 inches on rare occasions.
- Skunk Loach has been marked as a fin nipper.
- Size of Odessa Barb has been reduced to 2 inches. Tank requirement has also been reduced to 24x12.
- Changed the message when stocking level exceeds 160% to something a bit more prominent.
- Black Pacu has been adjusted to 30 inches.
- Red Bellied Pacu has been adjusted to 30 inches.
- Minimum number for Black and Red Bellied Pacu have been brought down to 1 but added a note saying they still prefer to be in groups when they are juveniles.
- Bioloads for Black and Red Bellied Pacu have been increased.
- Adjusted pH for Oscar to 6.4 - 7.5.
- Adjusted pH for Jewel Cichlid to 6.4 - 7.5.
- Adjusted pH for Common Pleco to 6 - 7.5.
- Increased water change requirement for Common Pleco.
- Increased bioload of Jewel Cichlid slightly.
- New feature: Now it is possible to combine species that will shoal together. As a starter, Zebra Danio and similar (or same) species have been combined. It will no longer produce warnings if combined number exceeds minimum number.
- Stripped Loach and other aliases of this species have been combined for minimum shoaling species calculation.
- Same modifications have been made for Banana Loach, madagascar Rainbowfish, Mosquito Rasbora, Polkadotted Loach, Marbled hatchet, Bronze Cory, Dainty Cory, Dwarf Cory, Green Chromide, Gardneri Killfish, Hatchet, Black Skirt Tetra, Flame Tetra, Rosy Tetra, Threadfin RainbowFish, American Flagfish, Striped Glass Catfish, Red Zebra, Dwarf Rainbowfish, Dojo Loach, Holden Pencilfish, Black Kuhli, Pitbull Pleco, Leopardfish, Ballon Molly, Molly, Pristella Tetra, Bumble Bee Cichlid, Denisoni Barb, Checkered Barb, Synodontis Eupterus, Domini Syno and Swift Rasbora.
- Removed the possibility of Molly and Platy cross breeding.
- African Leaf Fish has been marked more peaceful.
- African Dwarf Frogs and African Clawed Frogs are marked incompatible due to ACFs being chytrid carriers.
- Added notes for African Dwarf Frog.
- Added notes for African Claw Frog.
- Total number of species in DB has been increased to 601.
To access the application, please click on AqAdvisor site.
Now that the application can handle minimum shoaling number for similar (but not necessarily the same scientific names) species, please forward any similar species that will actually shoal together. There are probably quite a few different corydoras species that will shoal in this manner.
No plants support yet.
What's new for 2010 01 17 build:
- Added Red Empress (Protomelas Taeniolatus).
- Marked Neon and Cardinal Tetras as common shoalers.
- Marked Black Kuhli and regular Kuhli as common shoalers.
- Marked South American Puffer as a shoaling species with minimum number of 3.
- Added a note (mostly tips) for South American Puffer.
- Increase the size of Synodontis eupterus to 8.7 inches and changed scientific name to Synodontis euptera. Removed from African Drift Lake compatible group and minimum number has been set to 1. pH has been adjusted to 5.6 - 7.5.
- Peppered Cory and Panda Cory are marked as common schoolers.
- Added more notes for African Dwarf Frog.
- Added more notes for African Calw Frog.
- Increased bioload for African Dwarf Frog.
- Increased bioload for African Claw Frog.
- African Claw Frog has been marked to recommend species only tank.
- Updated Polkadotted Loach to Polka Dot Loach.
- Added Pakistani Loach as an alias for Botia almorhae.
- Updated scientific name of Tiger Loach to Syncrossus hymenophysa.
- Updated scientific name of Skunk Botia to Yasuhikotakia morleti.
- Updated scientific name of Longfin Zebra Danio to Danio rerio.
- Updated common name of Melanotaenia fluviatilis to ray River Rainbowfish.
- Added Lake Kutubu Rainbowfish as an alias to Turquoise Rainbowfish.
- Updated scientific name of Eastern Rainbowfish to Melanotaenia splendida.
- Added Tetra Whisper 3i filter.
- Added Jungle Junior/Senior Dirt Magnet series filters.
- Added Zoomed 501 Turtle Filter.
- Added Tom Aquatics Rapids Mini Canister C-80.
- Total number of filters in DB has been increased to 219.
- Total number of species in DB has been increased to 628.
To access the application, please click on AqAdvisor site.
Requestor: I could not find Lustar Hydro Sponge H0 specification on the net. Please let me know if you can find a site that either sells or lists this filter.
- Added Red Empress (Protomelas Taeniolatus).
- Marked Neon and Cardinal Tetras as common shoalers.
- Marked Black Kuhli and regular Kuhli as common shoalers.
- Marked South American Puffer as a shoaling species with minimum number of 3.
- Added a note (mostly tips) for South American Puffer.
- Increase the size of Synodontis eupterus to 8.7 inches and changed scientific name to Synodontis euptera. Removed from African Drift Lake compatible group and minimum number has been set to 1. pH has been adjusted to 5.6 - 7.5.
- Peppered Cory and Panda Cory are marked as common schoolers.
- Added more notes for African Dwarf Frog.
- Added more notes for African Calw Frog.
- Increased bioload for African Dwarf Frog.
- Increased bioload for African Claw Frog.
- African Claw Frog has been marked to recommend species only tank.
- Updated Polkadotted Loach to Polka Dot Loach.
- Added Pakistani Loach as an alias for Botia almorhae.
- Updated scientific name of Tiger Loach to Syncrossus hymenophysa.
- Updated scientific name of Skunk Botia to Yasuhikotakia morleti.
- Updated scientific name of Longfin Zebra Danio to Danio rerio.
- Updated common name of Melanotaenia fluviatilis to ray River Rainbowfish.
- Added Lake Kutubu Rainbowfish as an alias to Turquoise Rainbowfish.
- Updated scientific name of Eastern Rainbowfish to Melanotaenia splendida.
- Added Tetra Whisper 3i filter.
- Added Jungle Junior/Senior Dirt Magnet series filters.
- Added Zoomed 501 Turtle Filter.
- Added Tom Aquatics Rapids Mini Canister C-80.
- Total number of filters in DB has been increased to 219.
- Total number of species in DB has been increased to 628.
To access the application, please click on AqAdvisor site.
Requestor: I could not find Lustar Hydro Sponge H0 specification on the net. Please let me know if you can find a site that either sells or lists this filter.
