{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["No table and UDF","With table","With table & UDF"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"No table and UDF","index":0,"n_rows":5,"n_cols":5,"rows_kept":5}
["Surname","Lastname","Yearly sales","Salary","Bonus"]
["Mike","Peterson",{"v":325000,"d":"USD 325,000.00"},{"v":120000,"d":"USD 120,000.00"},{"$f":"IF(SUM(C2/D2)<=1,0,IF(SUM(C2/D2)>=3,SUM((C2-D2)*0.03),IF(AND(SUM(C2/D2)>1,SUM(C2/D2)<3)=TRUE,SUM((C2-D2)*0.02),1)))","v":{"v":4100,"d":"USD 4,100.00"}}]
["Josh","Anderson",{"v":98700,"d":"USD 98,700.00"},{"v":100000,"d":"USD 100,000.00"},{"v":0,"d":"USD 0.00"}]
["Morgan","Deigleish",{"v":245600,"d":"USD 245,600.00"},{"v":80000,"d":"USD 80,000.00"},{"$f":"IF(SUM(C4/D4)<=1,0,IF(SUM(C4/D4)>=3,SUM((C4-D4)*0.03),IF(AND(SUM(C4/D4)>1,SUM(C4/D4)<3)=TRUE,SUM((C4-D4)*0.02),1)))","v":{"v":4968,"d":"USD 4,968.00"}}]
["Jasper","Teege",{"v":112000,"d":"USD 112,000.00"},{"v":60000,"d":"USD 60,000.00"},{"$f":"IF(SUM(C5/D5)<=1,0,IF(SUM(C5/D5)>=3,SUM((C5-D5)*0.03),IF(AND(SUM(C5/D5)>1,SUM(C5/D5)<3)=TRUE,SUM((C5-D5)*0.02),1)))","v":{"v":1040,"d":"USD 1,040.00"}}]

{"sheet":"With table","index":1,"n_rows":5,"n_cols":5,"rows_kept":5}
["Surname","Lastname","Yearly sales","Salary","Bonus"]
["Mike","Peterson",{"v":325000,"d":"USD 325,000.00"},{"v":120000,"d":"USD 120,000.00"},{"$f":"IF(SUM(Bonus[[#This Row],[Yearly sales]]/Bonus[[#This Row],[Salary]])<=1,0,IF(SUM(Bonus[[#This Row],[Yearly sales]]/Bonus[[#This Row],[Salary]])>=3,SUM((Bonus[[#This Row],[Yearly sales]]-Bonus[[#This Row],[Salary]])*0.03),IF(AND(SUM(Bonus[[#This Row],[Yearly sales]]/Bonus[[#This Row],[Salary]])>1,SUM(Bonus[[#This Row],[Yearly sales]]/Bonus[[#This Row],[Salary]])<3)=TRUE,SUM((Bonus[[#This Row],[Yearly sales]]-Bonus[[#This Row],[Salary]])*0.02),1)))","v":{"v":4100,"d":"USD 4,100.00"}}]
["Josh","Anderson",{"v":98700,"d":"USD 98,700.00"},{"v":100000,"d":"USD 100,000.00"},{"$f":"IF(SUM(Bonus[[#This Row],[Yearly sales]]/Bonus[[#This Row],[Salary]])<=1,0,IF(SUM(Bonus[[#This Row],[Yearly sales]]/Bonus[[#This Row],[Salary]])>=3,SUM((Bonus[[#This Row],[Yearly sales]]-Bonus[[#This Row],[Salary]])*0.03),IF(AND(SUM(Bonus[[#This Row],[Yearly sales]]/Bonus[[#This Row],[Salary]])>1,SUM(Bonus[[#This Row],[Yearly sales]]/Bonus[[#This Row],[Salary]])<3)=TRUE,SUM((Bonus[[#This Row],[Yearly sales]]-Bonus[[#This Row],[Salary]])*0.02),1)))","v":{"v":0,"d":"USD 0.00"}}]
["Morgan","Deigleish",{"v":245600,"d":"USD 245,600.00"},{"v":80000,"d":"USD 80,000.00"},{"$f":"IF(SUM(Bonus[[#This Row],[Yearly sales]]/Bonus[[#This Row],[Salary]])<=1,0,IF(SUM(Bonus[[#This Row],[Yearly sales]]/Bonus[[#This Row],[Salary]])>=3,SUM((Bonus[[#This Row],[Yearly sales]]-Bonus[[#This Row],[Salary]])*0.03),IF(AND(SUM(Bonus[[#This Row],[Yearly sales]]/Bonus[[#This Row],[Salary]])>1,SUM(Bonus[[#This Row],[Yearly sales]]/Bonus[[#This Row],[Salary]])<3)=TRUE,SUM((Bonus[[#This Row],[Yearly sales]]-Bonus[[#This Row],[Salary]])*0.02),1)))","v":{"v":4968,"d":"USD 4,968.00"}}]
["Jasper","Teege",{"v":112000,"d":"USD 112,000.00"},{"v":60000,"d":"USD 60,000.00"},{"$f":"IF(SUM(Bonus[[#This Row],[Yearly sales]]/Bonus[[#This Row],[Salary]])<=1,0,IF(SUM(Bonus[[#This Row],[Yearly sales]]/Bonus[[#This Row],[Salary]])>=3,SUM((Bonus[[#This Row],[Yearly sales]]-Bonus[[#This Row],[Salary]])*0.03),IF(AND(SUM(Bonus[[#This Row],[Yearly sales]]/Bonus[[#This Row],[Salary]])>1,SUM(Bonus[[#This Row],[Yearly sales]]/Bonus[[#This Row],[Salary]])<3)=TRUE,SUM((Bonus[[#This Row],[Yearly sales]]-Bonus[[#This Row],[Salary]])*0.02),1)))","v":{"v":1040,"d":"USD 1,040.00"}}]

{"sheet":"With table & UDF","index":2,"n_rows":5,"n_cols":5,"rows_kept":5}
["Surname","Lastname","Yearly sales","Salary","Bonus"]
["Mike","Peterson",{"v":325000,"d":"USD 325,000.00"},{"v":120000,"d":"USD 120,000.00"},{"$f":"calculate_salary_to_sale_ratio_and_return_bonus(Bonus8[[#This Row],[Yearly sales]],Bonus8[[#This Row],[Salary]])","v":{"v":4100,"d":"USD 4,100.00"}}]
["Josh","Anderson",{"v":98700,"d":"USD 98,700.00"},{"v":100000,"d":"USD 100,000.00"},{"$f":"calculate_salary_to_sale_ratio_and_return_bonus(Bonus8[[#This Row],[Yearly sales]],Bonus8[[#This Row],[Salary]])","v":{"v":0,"d":"USD 0.00"}}]
["Morgan","Deigleish",{"v":245600,"d":"USD 245,600.00"},{"v":80000,"d":"USD 80,000.00"},{"$f":"calculate_salary_to_sale_ratio_and_return_bonus(Bonus8[[#This Row],[Yearly sales]],Bonus8[[#This Row],[Salary]])","v":{"v":4968,"d":"USD 4,968.00"}}]
["Jasper","Teege",{"v":112000,"d":"USD 112,000.00"},{"v":60000,"d":"USD 60,000.00"},{"$f":"calculate_salary_to_sale_ratio_and_return_bonus(Bonus8[[#This Row],[Yearly sales]],Bonus8[[#This Row],[Salary]])","v":{"v":1040,"d":"USD 1,040.00"}}]