{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["THT ROI Calculator"],"not_rendered":{"charts":0,"images":0,"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":"1900"}

{"sheet":"THT ROI Calculator","index":0,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2]]}
["THT Auto Insertion ROI Calculator"]
["Enter your factory data in the yellow cells"]
[]
["YOUR FACTORY INPUTS"]
["Parameter","Your Value","Unit"]
["Number of manual insertion stations per shift",6,"stations"]
["Number of shifts per day",2,"shifts"]
["Monthly cost per operator (fully loaded, RMB)",7000,"RMB"]
["Average THT components per PCBA",42,"components"]
["Current AOI defect rate for THT defects (%)",3.8,"%"]
["Minutes per rework cycle",15,"min"]
["Boards produced per day",2000,"boards/day"]
["Machine price (S4000 or S-3010B, estimated)",180000,"RMB"]
["MACHINE REFERENCE DATA"]
["Machine Model","CPH (Components Per Hour)","Application"]
["S4000 Axial Insertion Machine","20,000","Axial resistors, diodes, jumpers"]
["S-3010B Radial Insertion Machine","22,000(th)/13,000(sustained)","Radial capacitors, LEDs, transistors"]
["CALCULATED RESULTS (auto-computed)","300 - 600","All THT component types"]
["Metric","Manual Current","Auto Insertion Projected"]
["Annual direct labor cost (RMB)",{"$f":"B6*B7*B8*12","v":null},{"$f":"2*B7*B8*12","v":null}]
["Daily rework boards (boards/day)",{"$f":"B12*B10/100","v":null},{"$f":"B12*0.4/100","v":null}]
["Daily rework labor (hours)",{"$f":"B12*(B10/100)*B11/60","v":null},{"$f":"B12*(0.4/100)*B11/60","v":null}]
["Effective CPH (all stations)",{"$f":"B6*450","v":null},{"$f":"20000","v":null}]
["Annual rework cost estimate (RMB)",{"$f":"B12*B10/100*B11/60*B8/160","v":null},{"$f":"B12*0.4/100*B11/60*B8/160","v":null}]
["Estimated ROI period (months)","-",{"$f":"B13/(B6*B7*B8*12-2*B7*B8*12)*12","v":null}]
["Instructions: Replace the yellow cells (B6-B13) with your actual factory data."]
["For a personalized ROI calculation, contact Jason Wu: jasonwu@smthelp.com | +86 13602562576"]