{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":12,"n_cols":7,"rows_kept":12,"merged":[[0,0,1,6],[4,0,4,6],[5,0,5,6],[8,0,8,6],[9,0,9,6],[12,0,13,6],[14,0,17,6],[18,0,18,6]]}
["含量差比价算法"]
[]
["待定规格品含量","代表规格品含量","X值","对数","K值","代表规格品价格","待定规格品价格"]
[2,1,{"$f":"A4/B4","v":2},{"$f":"LOG(C4,2)","v":1},{"$f":"POWER(1.7,D4)","v":1.7},10,{"$f":"MMULT(F4,E4)","v":17}]
["用法：输入待定规格品含量数值、代表品规格数值以及代表规格品价格这三个数值，单击“待定规格品价格”下的单元格即可算出待定规格品价格。（以下同）"]
["装量差比价关系算法"]
["待定规格品装量","代表品装量","X值","对数","K值","代表规格品价格","待定规格品价格"]
[20,10,{"$f":"A8/B8","v":2},{"$f":"LOG(C8,2)","v":1},{"$f":"POWER(1.9,D8)","v":1.9},10,{"$f":"MMULT(F8,E8)","v":19}]
[]
["包装数量差比价关系算法"]
["待定规格品包装数量","代表品包装数量","X值","对数","K值","代表规格品价格","待定规格品价格"]
[20,10,{"$f":"A12/B12","v":2},{"$f":"LOG(C12,2)","v":1},{"$f":"POWER(1.95,D12)","v":1.95},10,{"$f":"MMULT(F12,E12)","v":19.5}]

{"sheet":"Sheet2","index":1,"n_rows":15,"n_cols":8,"rows_kept":15,"merged":[[1,1,2,7],[3,0,4,0],[11,1,11,7],[12,0,13,0]]}
[null,"以波立维为例：已知75mg波立维价格91.7，需要差比波立维25mg价"]
[null,"含量差比价算法"]
[]
["公式","待定规格品含量","代表规格品含量","X值","对数","K值","代表规格品价格","待定规格品价格"]
[null,25,75,{"$f":"B5/C5","v":0.333333333333333},{"$f":"LOG(D5,2)","v":-1.58496250072116},{"$f":"POWER(1.7,E5)","v":0.431267867437033},91.7,{"$f":"MMULT(G5,F5)","v":39.5472634439759}]
["解释","25mg","75mg","X值=25/75","对数=log（x值，2）","k值=power（1.7，对数）","75mg价格","差比后25mg价格"]
[]
[]
[]
[]
[null,"以安博诺为例：已知7粒安博诺25.7，需要差比安博诺28粒价"]
[null,"包装数量差比价关系算法"]
["公式","待定规格品包装数量","代表品包装数量","X值","对数","K值","代表规格品价格","待定规格品价格"]
[null,28,7,{"$f":"B14/C14","v":4},{"$f":"LOG(D14,2)","v":2},{"$f":"POWER(1.95,E14)","v":3.8025},25.7,{"$f":"MMULT(G14,F14)","v":97.72425}]
["解释","28粒数量","7粒数量","X值=28/7","对数=log（x值，2）","k值=power（1.95，对数）","7粒价格","差比后28粒价格"]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}