{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Sum","Multiplication","Division","Converting Currency","Computing Payment","Calculating with Tax"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sum","index":0,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"FormulaR1C1 Absolute Reference to Sum up"]
[]
[null,"Input1","Input2","Input3","Total"]
[null,10,20,30,{"$f":"$B$5+$C$5+$D$5","v":60}]
[null,">>R5C2",">>R5C3",">>R5C4",">>Sum "]

{"sheet":"Multiplication","index":1,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"FormulaR1C1 Absolute Reference to Multiply"]
[]
[null,"Input1",10,">>R4C3"]
[null,"Input2",20,">>R5C3"]
[null,"Input3",30,">>R6C3"]
[null,"Product",{"$f":"$C$4*$C$5*$C$6","v":6000},">>Multiplication"]

{"sheet":"Division","index":2,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"FormulaR1C1 Absolute Reference to Divide"]
[]
[null,"Input1","Input2","Quotient"]
[null,20,10,{"$f":"$B$5/$C$5","v":2}]
[null,">>R5C2",">>R5C3",">>Output of Division"]

{"sheet":"Converting Currency","index":3,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,3,10,4],[1,1,1,3]]}
[]
[null,"Converting One Currency to Another Currency"]
[]
[null,"Expenditure Sector","Cost in Euro (€)","Cost in USD ($)"]
[null,"Accomodation",10000,{"$f":"$C$5*$C$11","v":10900}]
[null,"Transportation",5000,{"$f":"$C$6*$C$11","v":5450}]
[null,"Food",3000,{"$f":"$C$7*$C$11","v":3270.0000000000005}]
[null,"Shopping",2000,{"$f":"$C$8*$C$11","v":2180}]
[null,"Entertainment",1000,{"$f":"$C$9*$C$11","v":1090}]
[]
[null,"Exchange Rate (€ to $)",1.0900000000000001,"<< R11C3: Absolute Reference"]

{"sheet":"Computing Payment","index":4,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,3,10,4],[1,1,1,4]]}
[]
[null,"Computing Payment Using FormulaR1C1 Absolute Reference"]
[]
[null,"Employee","Working Hours","Payment"]
[null,"Smith",10,{"$f":"$C$5*$C$11","v":152}]
[null,"Liz",5,{"$f":"$C$6*$C$11","v":76}]
[null,"James",8,{"$f":"$C$7*$C$11","v":121.6}]
[null,"Robert",7,{"$f":"$C$8*$C$11","v":106.39999999999999}]
[null,"Maria",9,{"$f":"$C$9*$C$11","v":136.79999999999998}]
[]
[null,"Hourly Wage Rate",15.2,"<< R11C3: Absolute Reference"]

{"sheet":"Calculating with Tax","index":5,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,4,10,5],[1,1,1,5]]}
[]
[null,"Calculating Amount with a Tax Rate"]
[]
[null,"Items","States","Sales","Sales Tax"]
[null,"AC","Ohio",3000,{"$f":"$D$5*$D$11","v":240}]
[null,"TV","Utah",1000,{"$f":"$D$6*$D$11","v":80}]
[null,"Monitor","Nevada",1500,{"$f":"$D$7*$D$11","v":120}]
[null,"Fan","Ohio",350,{"$f":"$D$8*$D$11","v":28}]
[null,"TV","Ohio",1500,{"$f":"$D$9*$D$11","v":120}]
[]
[null,null,"Tax Rate",0.08,"<< R11C4: Absolute Reference"]