Is there a mining calculator for efficiency ghs-watts = joules and sols to watts = joules ?

I have been building a database for antminer z9 and Canaan A851's trying to tune and find most energy efficient settings but have been questioning myself on wether my math is correct.

  So  I have heard older asics have been used to keep a steady load on bigger diesel generator setups in different parts of the world. One example was a mine in alaska and a friend. That worked in Africa at an airfield to repair airplanes. They had expensive generators and very efficient air conditioners. But at peak times had to run  aircompressor ,drain pumps ect .. and at night alot of lights. They would use the load of the asics to prevent burning out the gennys. But the mindset was different the mtx ran them for load and did not take care of them, like for example rain getting sucked in they were just plugged in and run inefficiently, they did have network cables on them.  Btw the way the whole conversation started was he was showing pics they had a meal kitchen place setup and low and behold there was what looked like the case of an s9 stripped out on end with a teapot on top.

At present, there can only be solo in the mine pool. It is not recommended to dig small computing power.
Where are you getting that from?

Sorry about that I accidently deleted my pre post while editing.
 The straight through cable does work well. I was using the wrong card option on the laptop. switched pi dhcp and its good there. Only problem I have now is there is no cgminer tabs. Only the openwrt I have used the latest download from canaan only mistake i think i could have made was setting up the pi so i can ssh and then hooking it up to the miner. Kinda weird it's not there though. Additionally, there is not an avalon gui that pops up I had just assumed the latest firmware did not have it.

I guess I have to load the mm into it trying to figure out how.

UPDATE-- Got it I reloaded the sd card and booted it with it hooked up to the miner, I have the avalon gui now. Hashing now. Still hashing but it  flipped over to opnwrt gui. I will ll work on it.

 

So all the links I have found so far to download the firmware is either dead or reverts back to the cannan site where its not listed. Is there an alternate place to download the firmware and software.?........

I think I found it to whoever this may help in the future. This looks like its for all the downloads. If someone knows where to pin this for someone else that would be great. Nothing came up for a search for me on the forum.

https://download.canaan-creative.com/

Thank you so much for the help. The 851 is on its way. I am going to be using it in the shop to keep it above freezing temp this winter to. I already had a 3b+ good to know it won't work and get frustrated. The auc 3 converter runs around 30$ from US does that sound right? There are many on ebay from china but I get tired of expecting it to be here in 2 weeks and it takes 3 months or never shows. Any way again thank you for the help on my endeavor.

Hello I can pick up some Avalon A851 's for 50$ a piece is that an ok deal?
 I realize I have to get  a pi ,auc3 converter and some cables , my main question was on the software I saw there is avalon 8 out there I am just wondering how low you can turn down the frequency on these to run them on low power or with just one board instead of all boards. If so how low can you turn them down? does the software even allow it? What is the best software to use? If you have 2 miners on 1 pi can you set each one on a different pool? Is there software where you could you plug the auc 3 straight into a motherboard and skip using the pi and converter ? In  your opinion would it be better to just stick with the s9s . I have heard these were solid but there is such little info about them.
 I would be using these to solo mine sha256 coins currently am running 2 s9s 3.5th @ 270 w.