哦,请问可不可以用excel的循环计算呢?我不想用试算法,想用excel自动计算出来,因为电脑计算的结果会更精确一点。
追答
L'(深水) L0 h L kh k th(kh) sh(kh) ch(kh)
351 197.34 20 197.5107 0.636788 0.031839 0.562708 0.680705 1.209694
197.35 197.5029 0.636756 0.031838 0.562686 0.680666 1.209672
197.36 197.4952 0.636723 0.031836 0.562664 0.680627 1.20965
197.37 197.4874 0.636691 0.031835 0.562642 0.680588 1.209628
197.38 197.4797 0.636659 0.031833 0.56262 0.680549 1.209606
197.39 197.472 0.636626 0.031831 0.562598 0.68051 1.209584
197.4 197.4642 0.636594 0.03183 0.562576 0.680471 1.209562
197.41 197.4565 0.636562 0.031828 0.562554 0.680432 1.20954
197.42 197.4488 0.63653 0.031826 0.562532 0.680393 1.209518
197.43 197.441 0.636498 0.031825 0.56251 0.680354 1.209496
197.44 197.4333 0.636465 0.031823 0.562488 0.680315 1.209474
197.45 197.4256 0.636433 0.031822 0.562466 0.680276 1.209452
197.46 197.4178 0.636401 0.03182 0.562444 0.680237 1.209431
197.47 197.4101 0.636369 0.031818 0.562422 0.680198 1.209409
197.48 197.4024 0.636336 0.031817 0.5624 0.680159 1.209387
不知道怎么传附件,就这么看着吧,这个不是说用循环算的,是看你需要的精度,然后像我列的第一行那样编个公式,我的L0是输入的波长,L是计算的波长,输入L0然后往下一拉就可以穷举出来了,你找看哪两个最接近就是那个了……