Calculation needed for trading currency pairs on FOREX

[Johncobb]

I am going to trade 2 currency pairs: USD/CHF and CHF/JPY.
I need to calculate how many lots of the second currency I need to balance my trade.
USD/CHF is trading at: 0.97910 and CHF/JPY is trading at: 79.870
If I take USD/CHF as one lot then how many lots I will need of the second currency pair to make close to even balance.
Currencies move (fluctuate) in a certain range over period of time. To make my strategy complete I need to enter trading range. They have different trading ranges.
USD/CHF is trading in a range: 0.95770 – 0.99830
CHF/JPY is trading in a range: 78.150 – 83.800
The trading range has to be added to the calculations to work out how many lots of the second currency I need for trading to make a balanced trade in possibly close to equal lots on both currency pairs.
Is it possible to make these calculations in Excel?
I hope that I have explained it clearly. If you need more clarifications please ask.
Waiting for your help.
John.

[Ace_XL]

Aren't you looking for a cross-currency rate? Perhaps the attached would help

[Johncobb]

No, I am not looking for a cross-currency rate.
Thanks anyway Ace_XL

[Ace_XL]

Does the above help resolving your query? Would be good to know if it does.

[Johncobb]

Do you mean the fx.xls file? No, I am sorry but it did not help to resolve my query.
Best regards,
John