Advertisement
overloop

notes on bash formula compilation for excel

Apr 6th, 2013
159
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 0.52 KB | None | 0 0
  1. #!/bin/bash
  2. # 2d two points interpolation
  3. echo 'interp($xi;$x1;$x2;$y1;$y2)' | sed -e 's%interp(\([^;]\+\);\([^;]\+\);\([^;]\+\);\([^;]\+\);\([^;]\+\))%И(\1>\2;\1<=\3)*((\1-\2)/(\3-\2)*(\5-\4)+\4)%g'
  4. echo 'interp(A1;3;4;20;30)' | sed -e 's%interp(\([^;]\+\);\([^;]\+\);\([^;]\+\);\([^;]\+\);\([^;]\+\))%И(\1>\2;\1<=\3)*((\1-\2)/(\3-\2)*(\5-\4)+\4)%g'
  5. echo 'interp(A1;0;1;20;30)+interp(A1;1;2;30;70)' | sed -e 's%interp(\([^;]\+\);\([^;]\+\);\([^;]\+\);\([^;]\+\);\([^;]\+\))%И(\1>\2;\1<=\3)*((\1-\2)/(\3-\2)*(\5-\4)+\4)%g'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement