{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["data","template"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"data","index":0,"n_rows":6,"n_cols":4,"rows_kept":6}
["name","AAA","BBB","DDD"]
["age",20,42,24]
["wage",6000,10000,10000]
["tax",{"v":0.1,"d":"10%"},{"v":0.15,"d":"15%"},{"v":0.1,"d":"10%"}]
["department","depart1","depart2","depart3"]
["enter_month",5,1,12]

{"sheet":"template","index":1,"n_rows":23,"n_cols":9,"rows_kept":23}
["姓名:","{name}",{"$nulls":5},"部门：","{department}"]
["年龄：","{age}"]
[]
[]
["工资：","{wage}"]
["所得税：","{=R[-1]C*{tax}}"]
["净额：",{"$f":"B5-B6","v":{"$error":"#VALUE!"}}]
["是否达标：","{=IF({wage}>7000,true,false)}"]
[]
[]
[1,"{=IF({enter_month}<=RC[-1],{wage},0)}"]
[2,"{=IF({enter_month}<=RC[-1],{wage},0)}"]
[3,"{=IF({enter_month}<=RC[-1],{wage},0)}"]
[4,"{=IF({enter_month}<=RC[-1],{wage},0)}"]
[5,"{=IF({enter_month}<=RC[-1],{wage},0)}"]
[6,"{=IF({enter_month}<=RC[-1],{wage},0)}"]
[7,"{=IF({enter_month}<=RC[-1],{wage},0)}"]
[8,"{=IF({enter_month}<=RC[-1],{wage},0)}"]
[9,"{=IF({enter_month}<=RC[-1],{wage},0)}"]
[10,"{=IF({enter_month}<=RC[-1],{wage},0)}"]
[11,"{=IF({enter_month}<=RC[-1],{wage},0)}"]
[12,"{=IF({enter_month}<=RC[-1],{wage},0)}"]
["总额",{"$f":"SUM(B11:B22)","v":{"v":0,"d":"0.00 €"}}]