C/Ku/IF Frequency Calculator/Converter

[melgarga]

I've threated to do this for a while now. Anyone else tired of grabbing the calculator, punching in the stuff to find IF and image freqs and scribbling it down on a piece of paper? I sat down last night and plugged it all into an xls file. I think my feed hunting, rx programming and 4D manipulating is going to be a bit easier from now on.
Hope it helps out some others as well.

 

[Smith P.]

Now if you could add Ku LOF=11250 and make it work on my standalone calculator ...

 

[melgarga]

Sure. Different LOFs are not a problem. I didnt think about 10600 or 11250 since I dont have a universal at all, and havent had a use for a circular LNB in years.
On a stand alone calculator, try one of the old HP programmables, or any of the TI-8X series, maybe even a palm pilot or equivalant.
If your talking a $3.99 one from Walgreens, then I thinking probably not.....lol

 

[Smith P.]

Actually, not from Walgreens, but those what came free last few years.

 

[Mr Tony]

very neat. Thanks for posting

 

[melgarga]

The TI-8X series are definately not in the low budget catagory. I've got an 83 and a 86. Both are way smarter than I am. I have to study the manual before I even attempt anything beyond basic math. Too much of a headache.....lol
BTW, did you ever find a C band feed to get your DSR back up and running?

 

[Smith P.]

Not yet, didn't get my guts for buying BSC621 to slap it to vacant 1m offset dish and try pick 133W for the poor DSR-922.

 

[melgarga]

Thanks Ice. It was born of a thought one evening while juggling 4D generic calculations. Ultimately I can see integrating all the generic map info into the thing somehow and make to whole feed hunting process a bit more streamlined.

Smith, I know you meant 133W (G1) but you might want to edit for posterity's sake before it's carved in granite....lol
Good luck on getting it on a 1m dish. I think it might be kind of touchy to say the least. If you pull that off there will be many 4D users that would be happy to know that.

 

[zamar23]

melgagra

Useful calculators! Can you make it more universal, so that a SINGLE XLS calculator can be used for any frequency by selecting or entering that freq value in its dedicated visible field without duplicating such fields?

 

[Babadem]

Excellent Job melgarga! :up

 

[SpiffWilkie]

melgagra

Useful calculators! Can you make it more universal, so that a SINGLE XLS calculator can be used for any frequency by selecting or entering that freq value in its dedicated visible field without duplicating such fields?

Hope you don't mind, melgarga. I just made the LOF selectable and protected the sheet to prevent deleting the formulas. It's not password protected so anyone can unlock it and tweak as they see fit.
View attachment C-Ku-IF calculator_v2.xls

 

[Babadem]

Hope you don't mind, melgarga. I just made the LOF selectable and protected the sheet to prevent deleting the formulas. It's not password protected so anyone can unlock it and tweak as they see fit.
View attachment 45432

Very well condensed! Forgive my ignorance. Could you demonstrate an example of how to use/apply this Calculator to locate frequencies? I have tried using it, but seem confused about it.

 

[melgarga]

Hope you don't mind, melgarga. I just made the LOF selectable and protected the sheet to prevent deleting the formulas. It's not password protected so anyone can unlock it and tweak as they see fit.
View attachment 45432

Nary a problem guy. They really needed significant cleaning up and consolidating. It was just a down and dirty solution to a repetitive calculator and pen and pad task. (The joys of DCII feedhunting....lol) No spit and polish, just an "alpha release" , that is public domain to be altered as anyone sees fit. The other two LO's were actually an after thought.....
I had thought about overlaying the generic maps/info vs IF and downlink freq on a per sat basis but that was turning into work quick.
I didnt think about protecting the cells before I posted it. I dont even have and admin password on my comp.....lol