{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Sheet 1"],"not_rendered":{"charts":0,"images":4,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"1904"}

{"sheet":"Sheet 1","index":0,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":false,"merged":[[4,0,4,3],[4,5,4,8],[14,0,14,3],[1,1,1,6],[2,1,2,6],[14,5,14,8]]}
[]
[null,"SureShipper "]
[null,"Payback Calculator "]
[]
["Cost of BOPP Tape  (Table #1)",{"$nulls":4},"Cost of Glue  (Table #2)"]
["Length of shipper  ","L1",600,"mm",null,"Typical amount of glue per mtr","g ",{"$f":"0.9/800*1000","v":1.1250000000000002},"gms/mtr."]
["Rate of tape per meter","R ",0.6,"Rs/ mtr.",null,"Number of Minor Flaps","Gr",4,"nos"]
["Total length of Tape (2\" on side)","LBT",{"$f":"2*(C6+100)","v":1400},"mm",null,"Glue Lines per minor flap","Lg",4,"nos."]
["Cost of Tape","VTape",{"$f":"C8*C7/1000","v":0.84},"Rs.",null,"Length of each glue line","Ln",50,"nos."]
[{"$nulls":5},"Total lengthof glue line per Shipper","L2 = Gr x Lg x Ln",{"$f":"H7*H9*H8","v":800},"mm"]
[{"$nulls":5},"Grams of glue required","M = L2 x g",{"$f":"H6*H10/1000","v":0.90000000000000024},"gms."]
[{"$nulls":5},"Cost of Glue per kg","R2",400,"Rs."]
["Saving per shipper","V_Save = V_Tape - V_Glue",{"$f":"C9-H13","v":0.47999999999999987},"Rs.",null,"Cost of Glue per Shipper","VGlue = R2 x M",{"$f":"H12*H11/1000","v":0.3600000000000001},"Rs."]
[]
["Annual Production Data  (Table # 3)",{"$nulls":4},"Payback Calculations (Table #4)"]
["Shippers per minute","SPM",10,null,null,"Investment in machine","I",null,"Rs."]
["Hours per day","H",12,"hrs",null,"Annual Saving","AS",{"$f":"C24","v":933119.99999999977},"Rs,"]
["Operational Efficiency","OE",0.9,"%",null,"Payback",null,{"$f":"H16/H17","v":0},"Years"]
[]
["Shippers per day","N3 = SPM x H x 60 x OE",{"$f":"C16*C17*60*C18","v":6480},"nos."]
["Days per year ","N4",300,"Nos."]
["Shippers per year ","N5 = N3 x N4",{"$f":"C21*C20","v":1944000},"Nos."]
[]
["Saving per year ","AS = N5 x V_Save",{"$f":"C22*C13","v":933119.99999999977},"Rs."]