{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Preparation","RunSequence","CropIt","About","PlotData"],"not_rendered":{"charts":2,"images":0,"macros":1,"external_links":0,"defined_names":49,"comments":1,"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":"Preparation","index":0,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
["Joint Preparation"]
["Reference","WPS Example 1"]
["Single or Double Sided","Single"]
["Cap Height",3,"mm"]
["Left Bevel (Top)",30,"°",{"$f":"RADIANS(B5)","v":0.52359877559829882},"radians"]
["Right Bevel (Top)",30,"°",{"$f":"RADIANS(B6)","v":0.52359877559829882},"radians"]
["Left Bevel (Bottom)",35,"°",{"$f":"RADIANS(B7)","v":0.6108652381980153},"radians"]
["Right Bevel (Bottom)",15,"°",0.26179938779914941,"radians"]
["Thickness (Left)",30,"mm"]
["Thickness (Right)",30,"mm"]
["Ratio Side1:Side 2",1,"to",1,{"$f":"B11/(B11+D11)","v":0.5}]
["Root Gap",4,"mm"]
["Root Face",2,"mm"]

{"sheet":"RunSequence","index":1,"n_rows":46,"n_cols":19,"rows_kept":46,"cut":false,"hidden":false,"merged":[[1,3,1,17],[24,3,24,17]]}
["Side 1 (Top)",null,null,null,null,null,null,null,null,null,"Run Sequence",null,null,null,null,null,null,null,"Adjust"]
["Layer","Beads","Slots","Pass Numbers"]
[{"$f":"IF(B3>0,1,\"\")","v":1},{"$f":"COUNTA(D3:R3)-COUNTIF(D3:R3,\"~*\")","v":1},{"$f":"COUNTA(D3:R3)","v":1},1]
[{"$f":"IF(B4>0,A3+1,\"\")","v":2},{"$f":"COUNTA(D4:R4)-COUNTIF(D4:R4,\"~*\")","v":1},{"$f":"COUNTA(D4:R4)","v":1},2]
[{"$f":"IF(B5>0,A4+1,\"\")","v":3},2,2,3,4]
["",0,0]
["",0,0]
["",0,0]
["",0,0]
["",0,0]
["",0,0]
["",0,0]
["",0,0]
["",0,0]
["",0,0]
["",0,0]
["",0,0]
["",0,0]
[{"$f":"IF(B19>0,A18+1,\"\")","v":""},0,0]
["",0,0]
["",0,0]
["",0,0]
[{"$f":"MAX(COUNT(A3:A22),D23)","v":6},{"$f":"SUM(B3:B22)","v":4},{"$f":"SUM(C3:C22)","v":4},6,"Layers Minimum"]
["Side 2 (Bottom)",null,null,null,null,null,null,null,null,null,"Run Sequence",null,null,null,null,null,null,null,"Adjust"]
["Layer","Beads"]
[{"$f":"IF(B26>0,1,\"\")","v":""},{"$f":"COUNTA(D26:R26)-COUNTIF(D26:R26,\"~*\")","v":0},{"$f":"COUNTA(D26:R26)","v":0}]
[{"$f":"IF(B27>0,A26+1,\"\")","v":""},{"$f":"COUNTA(D27:R27)-COUNTIF(D27:R27,\"~*\")","v":0},{"$f":"COUNTA(D27:R27)","v":0}]
[{"$f":"IF(B28>0,A27+1,\"\")","v":""},0,0]
["",0,0]
["",0,0]
["",0,0]
["",0,0]
["",0,0]
["",0,0]
["",0,0]
["",0,0]
[{"$f":"IF(B37>0,A36+1,\"\")","v":""},0,0]
["",0,0]
["",0,0]
["",0,0]
["",0,0]
["",0,0]
["",0,0]
["",0,0]
["",0,0]
[{"$f":"IF(SorD=\"Double\",MAX(COUNT(A26:A45),D46),0)","v":0},{"$f":"SUM(B26:B45)","v":0},{"$f":"SUM(C26:C45)","v":0},2,"Layers Minimum"]

{"sheet":"CropIt","index":2,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[[2,1,25,11]]}
["Image","C:\\Users\\Kevin.Millican\\Desktop\\untitled.emf"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["CropLeft",0,null,null,"Adjustment",10]
["CropRight",0]
["CropTop",0]
["CropBottom",0]

{"sheet":"About","index":3,"n_rows":28,"n_cols":2,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Original Spreadsheet and VBA macros ©2013 :  Kevin Millican"]
["This spreadsheet and the macros contained therein is provided under the GNU General Public License, version 3 (GPL-3.0)"]
["It may be freely distributed and modified for both private and commercial use, provided the original author's work is acknowledged."]
["For more details, see: ","http://opensource.org/licenses/GPL-3.0"]
[]
["Usage:"]
["Use the Preparation sheet to set the initial weld geometry."]
["Run numbers can be input on the RunSequence sheet, ordered by weld layer."]
["To input stripper layers, and show them in the correct locations, use an asterisk (*) character"]
["Macros need to be enabled to show individual passes."]
["Without macros, only the weld preparation and layers are displayed; ensure Workbook is saved while on the Preparation sheet if it is to be used this way."]
["(otherwise existing passes will still be shown)"]
[]
["Additional Information:"]
["Run sequence chart can be copied and pasted as a windows metafile to allow full scaling."]
["Resulting image can be cropped using Office tools or in a standard drawing package."]
[]
["Change Log:"]
["Rev 0 - 10/10/2013","Initial release"]
["Rev 1 - 10/10/2013","Fixed division by zero error on 0° bevels"]
["Rev 2 - 15/10/2013","Improved scaling. Removed axes display as no longer required. Added About page and Change log."]
["Rev 3 - 16/10/2013","Enabled use of characters \".\",\"°\",\"R\",\"H\",\"P\",\"F\",\"C\", & \"S\""]
["Rev 4 - 18/10/2013","Enabled use of characters \"=\" & \"G\". Improved character positioning. Added weld prep variables to sketch."]
["Rev 5 - 19/10/2013","Rewrote routine to calculate font size. Added \",\" character for EU decimals (treated the same as \".\")."]
["Rev 6 - 18/12/2013","Added external caps. Added save as EMF."]
["Rev 7 - 18/08/2014","Added facility to crop images within the spreadsheet."]
["Rev 8 - 19/08/2014","Added facility to flip Left-to-Right order of passes"]
["Rev 9 - 31/01/2019","Added minimum layers cell - improves appearance when filling out first few layers."]

{"sheet":"PlotData","index":4,"n_rows":163,"n_cols":7,"rows_kept":163,"cut":false,"hidden":false,"merged":[]}
["x","y","Comment"]
[0,0,"Centre of Root",null,null,"Side 1 Layers (excl. Cap)",{"$f":"LayersS1-IF(Cap_Height>0,1,0)","v":5}]
[null,null,null,null,null,"Side 2 Layers (excl. Cap)",{"$f":"LayersS2-IF(Cap_Height>0,1,0)","v":-1}]
[{"$f":"A2-Root_Gap/2","v":-2},0,"Left of root centre"]
[{"$f":"A4","v":-2},{"$f":"IF(SorD=\"Single\",B4+Root_Face,B4+Root_Face/2)","v":2},"Top of root face","Gradient",null,"Height of Left Top",{"$f":"B7","v":30}]
[{"$f":"A5-(B6-B5)*TAN(Bevel1)","v":-18.165807537309519},{"$f":"IF(SorD=\"Single\",Thickness,(Thickness-B4)*ratio)","v":30},"Top of left bevel",{"$f":"(B6-B5)/IF(A6=A5,0.01,(A6-A5))","v":-1.7320508075688776},null,"Left Top Layer Height",{"$f":"G5/MAX(L1S,1)","v":6}]
[{"$f":"MIN(A6,A23)-10","v":-28.165807537309519},{"$f":"B6","v":30},"Top Left of Plate Side 1"]
[{"$f":"A7","v":-28.165807537309519},{"$f":"B6-Thickness","v":0},"Bottom Left of Plate Side 1",null,null,"Height of Left Bottom",{"$f":"ABS(B8)","v":0}]
[null,null,null,null,null,"Left Bottom Layer Height",{"$f":"G8/MAX(L2S,1)","v":0}]
[{"$f":"A4","v":-2},{"$f":"B4","v":0},"Left of root face"]
[{"$f":"A10","v":-2},{"$f":"IF(SorD=\"Single\",B4,B4-Root_Face/2)","v":0},"Bottom of root face","Gradient",null,"Height of Right Top",{"$f":"B18","v":30}]
[{"$f":"A11-(B11-B12)*TAN(Bevel3)","v":-2},{"$f":"B8","v":0},"Bottom of left bevel",{"$f":"(B12-B11)/IF(A12=A11,0.01,(A12-A11))","v":0},null,"Right Top Layer Height",{"$f":"G11/MAX(L1S,1)","v":6}]
[{"$f":"A8","v":-28.165807537309519},{"$f":"B8","v":0},"Bottom Left of Plate Side 1"]
[null,null,null,null,null,"Height of Right Bottom",{"$f":"ABS(B19)","v":0}]
[{"$f":"A2+Root_Gap/2","v":2},0,"Right of root centre",null,null,"Right Bottom Layer Height",{"$f":"G14/MAX(L2S,1)","v":0}]
[{"$f":"A15","v":2},{"$f":"IF(SorD=\"Single\",B15+Root_Face,B15+Root_Face/2)","v":2},"Top of root face","Gradient"]
[{"$f":"A16+(B17-B16)*TAN(Bevel2)","v":18.165807537309519},{"$f":"IF(SorD=\"Single\",Thickness2,(Thickness2-B4)*ratio)","v":30},"Top of right bevel",{"$f":"(B17-B16)/IF(A17=A16,0.01,(A17-A16))","v":1.7320508075688776},null,"Calculate Layer Height for Fonts"]
[{"$f":"MAX(A17,A23)+10","v":28.165807537309519},{"$f":"B17","v":30},"Top Right of Plate Side 2",null,null,null,{"$f":"IF(G6>0,G6,1000)","v":6}]
[{"$f":"A18","v":28.165807537309519},{"$f":"B18-Thickness2","v":0},"BottomRight of Plate Side 2",null,null,null,{"$f":"IF(G9>0,G9,1000)","v":1000}]
[null,null,null,null,null,null,{"$f":"IF(G12>0,G12,1000)","v":6}]
[{"$f":"A15","v":2},{"$f":"B15","v":0},"Right of root face",null,null,null,{"$f":"IF(G15>0,G15,1000)","v":1000}]
[{"$f":"A21","v":2},{"$f":"IF(SorD=\"Single\",B15,B15-Root_Face/2)","v":0},"Bottom of root face","Gradient",null,"Calculated Font Height",{"$f":"MIN(G18:G21)","v":6}]
[{"$f":"A22+(B22-B23)*TAN(Bevel4)","v":2},{"$f":"B19","v":0},"Bottom of right bevel",{"$f":"(B23-B22)/IF(A23=A22,0.01,(A23-A22))","v":0},null,"Minimum Plate Thickness",{"$f":"MIN(Thickness,Thickness2)","v":30}]
[{"$f":"A19","v":28.165807537309519},{"$f":"B23","v":0},"Bottom Left of Plate Side 1",null,null,"Maximum Font Height",{"$f":"G23/6","v":5}]
[]
[{"$f":"MAX(-A8,A19,-B8,B7,-B19,B18)+1","v":31},{"$f":"A26","v":31},null,null,null,"Default Font Height",{"$f":"MIN(G22,G24,IF(Cap_Height>0,Cap_Height,1000))","v":3}]
[{"$f":"-A26","v":-31},{"$f":"-B26","v":-31}]
[]
[]
[null,null,"Start of run data"]
[{"$f":"A4","v":-2},{"$f":"B4","v":0},"Bottom left of first pass"]
[{"$f":"A15","v":2},{"$f":"B15","v":0},"Bottom right of first pass"]
[]
[{"$f":"A6","v":-18.165807537309519},{"$f":"B6","v":30},"Top of left bevel"]
[{"$f":"A17","v":18.165807537309519},{"$f":"B17","v":30},"Top of right bevel"]
[]
[{"$f":"A12","v":-2},{"$f":"B12","v":0},"Bottom of left bevel"]
[{"$f":"A23","v":2},{"$f":"B23","v":0},"Bottom of right bevel"]
[null,null,{"$f":"(ROW()-ROW(C$36))/3","v":1}]
[{"$f":"IF(L1S>=C39,(IF(B40>B$5,A$6-(L1S-C39)/L1S*B$6/Gradient1,A$5)),0)","v":-4.3094010767585029},{"$f":"IF(L1S>=C39,C39*B$34/L1S,0)","v":6},{"$f":"CONCATENATE(\"Layer \",C39,\" - left\")","v":"Layer 1 - left"}]
[{"$f":"IF(L1S>=C39,(IF(B41>B$16,A$17-(L1S-C39)/L1S*B$17/Gradient3,A$16)),0)","v":4.3094010767585029},{"$f":"IF(L1S>=C39,C39*B$35/L1S,0)","v":6},{"$f":"CONCATENATE(\"Layer \",C39,\" - right\")","v":"Layer 1 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$36))/3","v":2}]
[{"$f":"IF(L1S>=C42,(IF(B43>B$5,A$6-(L1S-C42)/L1S*B$6/Gradient1,A$5)),0)","v":-7.7735026918962564},{"$f":"IF(L1S>=C42,C42*B$34/L1S,0)","v":12},{"$f":"CONCATENATE(\"Layer \",C42,\" - left\")","v":"Layer 2 - left"}]
[{"$f":"IF(L1S>=C42,(IF(B44>B$16,A$17-(L1S-C42)/L1S*B$17/Gradient3,A$16)),0)","v":7.7735026918962564},{"$f":"IF(L1S>=C42,C42*B$35/L1S,0)","v":12},{"$f":"CONCATENATE(\"Layer \",C42,\" - right\")","v":"Layer 2 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$36))/3","v":3}]
[{"$f":"IF(L1S>=C45,(IF(B46>B$5,A$6-(L1S-C45)/L1S*B$6/Gradient1,A$5)),0)","v":-11.237604307034012},{"$f":"IF(L1S>=C45,C45*B$34/L1S,0)","v":18},{"$f":"CONCATENATE(\"Layer \",C45,\" - left\")","v":"Layer 3 - left"}]
[{"$f":"IF(L1S>=C45,(IF(B47>B$16,A$17-(L1S-C45)/L1S*B$17/Gradient3,A$16)),0)","v":11.237604307034012},{"$f":"IF(L1S>=C45,C45*B$35/L1S,0)","v":18},{"$f":"CONCATENATE(\"Layer \",C45,\" - right\")","v":"Layer 3 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$36))/3","v":4}]
[{"$f":"IF(L1S>=C48,(IF(B49>B$5,A$6-(L1S-C48)/L1S*B$6/Gradient1,A$5)),0)","v":-14.701705922171765},{"$f":"IF(L1S>=C48,C48*B$34/L1S,0)","v":24},{"$f":"CONCATENATE(\"Layer \",C48,\" - left\")","v":"Layer 4 - left"}]
[{"$f":"IF(L1S>=C48,(IF(B50>B$16,A$17-(L1S-C48)/L1S*B$17/Gradient3,A$16)),0)","v":14.701705922171765},{"$f":"IF(L1S>=C48,C48*B$35/L1S,0)","v":24},{"$f":"CONCATENATE(\"Layer \",C48,\" - right\")","v":"Layer 4 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$36))/3","v":5}]
[{"$f":"IF(L1S>=C51,(IF(B52>B$5,A$6-(L1S-C51)/L1S*B$6/Gradient1,A$5)),0)","v":-18.165807537309519},{"$f":"IF(L1S>=C51,C51*B$34/L1S,0)","v":30},{"$f":"CONCATENATE(\"Layer \",C51,\" - left\")","v":"Layer 5 - left"}]
[{"$f":"IF(L1S>=C51,(IF(B53>B$16,A$17-(L1S-C51)/L1S*B$17/Gradient3,A$16)),0)","v":18.165807537309519},{"$f":"IF(L1S>=C51,C51*B$35/L1S,0)","v":30},{"$f":"CONCATENATE(\"Layer \",C51,\" - right\")","v":"Layer 5 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$36))/3","v":6}]
[{"$f":"IF(L1S>=C54,(IF(B55>B$5,A$6-(L1S-C54)/L1S*B$6/Gradient1,A$5)),0)","v":0},{"$f":"IF(L1S>=C54,C54*B$34/L1S,0)","v":0},{"$f":"CONCATENATE(\"Layer \",C54,\" - left\")","v":"Layer 6 - left"}]
[{"$f":"IF(L1S>=C54,(IF(B56>B$16,A$17-(L1S-C54)/L1S*B$17/Gradient3,A$16)),0)","v":0},{"$f":"IF(L1S>=C54,C54*B$35/L1S,0)","v":0},{"$f":"CONCATENATE(\"Layer \",C54,\" - right\")","v":"Layer 6 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$36))/3","v":7}]
[{"$f":"IF(L1S>=C57,(IF(B58>B$5,A$6-(L1S-C57)/L1S*B$6/Gradient1,A$5)),0)","v":0},{"$f":"IF(L1S>=C57,C57*B$34/L1S,0)","v":0},{"$f":"CONCATENATE(\"Layer \",C57,\" - left\")","v":"Layer 7 - left"}]
[{"$f":"IF(L1S>=C57,(IF(B59>B$16,A$17-(L1S-C57)/L1S*B$17/Gradient3,A$16)),0)","v":0},{"$f":"IF(L1S>=C57,C57*B$35/L1S,0)","v":0},{"$f":"CONCATENATE(\"Layer \",C57,\" - right\")","v":"Layer 7 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$36))/3","v":8}]
[{"$f":"IF(L1S>=C60,(IF(B61>B$5,A$6-(L1S-C60)/L1S*B$6/Gradient1,A$5)),0)","v":0},{"$f":"IF(L1S>=C60,C60*B$34/L1S,0)","v":0},{"$f":"CONCATENATE(\"Layer \",C60,\" - left\")","v":"Layer 8 - left"}]
[{"$f":"IF(L1S>=C60,(IF(B62>B$16,A$17-(L1S-C60)/L1S*B$17/Gradient3,A$16)),0)","v":0},{"$f":"IF(L1S>=C60,C60*B$35/L1S,0)","v":0},{"$f":"CONCATENATE(\"Layer \",C60,\" - right\")","v":"Layer 8 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$36))/3","v":9}]
[{"$f":"IF(L1S>=C63,(IF(B64>B$5,A$6-(L1S-C63)/L1S*B$6/Gradient1,A$5)),0)","v":0},{"$f":"IF(L1S>=C63,C63*B$34/L1S,0)","v":0},{"$f":"CONCATENATE(\"Layer \",C63,\" - left\")","v":"Layer 9 - left"}]
[{"$f":"IF(L1S>=C63,(IF(B65>B$16,A$17-(L1S-C63)/L1S*B$17/Gradient3,A$16)),0)","v":0},{"$f":"IF(L1S>=C63,C63*B$35/L1S,0)","v":0},{"$f":"CONCATENATE(\"Layer \",C63,\" - right\")","v":"Layer 9 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$36))/3","v":10}]
[{"$f":"IF(L1S>=C66,(IF(B67>B$5,A$6-(L1S-C66)/L1S*B$6/Gradient1,A$5)),0)","v":0},{"$f":"IF(L1S>=C66,C66*B$34/L1S,0)","v":0},{"$f":"CONCATENATE(\"Layer \",C66,\" - left\")","v":"Layer 10 - left"}]
[{"$f":"IF(L1S>=C66,(IF(B68>B$16,A$17-(L1S-C66)/L1S*B$17/Gradient3,A$16)),0)","v":0},{"$f":"IF(L1S>=C66,C66*B$35/L1S,0)","v":0},{"$f":"CONCATENATE(\"Layer \",C66,\" - right\")","v":"Layer 10 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$36))/3","v":11}]
[{"$f":"IF(L1S>=C69,(IF(B70>B$5,A$6-(L1S-C69)/L1S*B$6/Gradient1,A$5)),0)","v":0},{"$f":"IF(L1S>=C69,C69*B$34/L1S,0)","v":0},{"$f":"CONCATENATE(\"Layer \",C69,\" - left\")","v":"Layer 11 - left"}]
[{"$f":"IF(L1S>=C69,(IF(B71>B$16,A$17-(L1S-C69)/L1S*B$17/Gradient3,A$16)),0)","v":0},{"$f":"IF(L1S>=C69,C69*B$35/L1S,0)","v":0},{"$f":"CONCATENATE(\"Layer \",C69,\" - right\")","v":"Layer 11 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$36))/3","v":12}]
[{"$f":"IF(L1S>=C72,(IF(B73>B$5,A$6-(L1S-C72)/L1S*B$6/Gradient1,A$5)),0)","v":0},{"$f":"IF(L1S>=C72,C72*B$34/L1S,0)","v":0},{"$f":"CONCATENATE(\"Layer \",C72,\" - left\")","v":"Layer 12 - left"}]
[{"$f":"IF(L1S>=C72,(IF(B74>B$16,A$17-(L1S-C72)/L1S*B$17/Gradient3,A$16)),0)","v":0},{"$f":"IF(L1S>=C72,C72*B$35/L1S,0)","v":0},{"$f":"CONCATENATE(\"Layer \",C72,\" - right\")","v":"Layer 12 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$36))/3","v":13}]
[{"$f":"IF(L1S>=C75,(IF(B76>B$5,A$6-(L1S-C75)/L1S*B$6/Gradient1,A$5)),0)","v":0},{"$f":"IF(L1S>=C75,C75*B$34/L1S,0)","v":0},{"$f":"CONCATENATE(\"Layer \",C75,\" - left\")","v":"Layer 13 - left"}]
[{"$f":"IF(L1S>=C75,(IF(B77>B$16,A$17-(L1S-C75)/L1S*B$17/Gradient3,A$16)),0)","v":0},{"$f":"IF(L1S>=C75,C75*B$35/L1S,0)","v":0},{"$f":"CONCATENATE(\"Layer \",C75,\" - right\")","v":"Layer 13 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$36))/3","v":14}]
[{"$f":"IF(L1S>=C78,(IF(B79>B$5,A$6-(L1S-C78)/L1S*B$6/Gradient1,A$5)),0)","v":0},{"$f":"IF(L1S>=C78,C78*B$34/L1S,0)","v":0},{"$f":"CONCATENATE(\"Layer \",C78,\" - left\")","v":"Layer 14 - left"}]
[{"$f":"IF(L1S>=C78,(IF(B80>B$16,A$17-(L1S-C78)/L1S*B$17/Gradient3,A$16)),0)","v":0},{"$f":"IF(L1S>=C78,C78*B$35/L1S,0)","v":0},{"$f":"CONCATENATE(\"Layer \",C78,\" - right\")","v":"Layer 14 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$36))/3","v":15}]
[{"$f":"IF(L1S>=C81,(IF(B82>B$5,A$6-(L1S-C81)/L1S*B$6/Gradient1,A$5)),0)","v":0},{"$f":"IF(L1S>=C81,C81*B$34/L1S,0)","v":0},{"$f":"CONCATENATE(\"Layer \",C81,\" - left\")","v":"Layer 15 - left"}]
[{"$f":"IF(L1S>=C81,(IF(B83>B$16,A$17-(L1S-C81)/L1S*B$17/Gradient3,A$16)),0)","v":0},{"$f":"IF(L1S>=C81,C81*B$35/L1S,0)","v":0},{"$f":"CONCATENATE(\"Layer \",C81,\" - right\")","v":"Layer 15 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$36))/3","v":16}]
[{"$f":"IF(L1S>=C84,(IF(B85>B$5,A$6-(L1S-C84)/L1S*B$6/Gradient1,A$5)),0)","v":0},{"$f":"IF(L1S>=C84,C84*B$34/L1S,0)","v":0},{"$f":"CONCATENATE(\"Layer \",C84,\" - left\")","v":"Layer 16 - left"}]
[{"$f":"IF(L1S>=C84,(IF(B86>B$16,A$17-(L1S-C84)/L1S*B$17/Gradient3,A$16)),0)","v":0},{"$f":"IF(L1S>=C84,C84*B$35/L1S,0)","v":0},{"$f":"CONCATENATE(\"Layer \",C84,\" - right\")","v":"Layer 16 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$36))/3","v":17}]
[{"$f":"IF(L1S>=C87,(IF(B88>B$5,A$6-(L1S-C87)/L1S*B$6/Gradient1,A$5)),0)","v":0},{"$f":"IF(L1S>=C87,C87*B$34/L1S,0)","v":0},{"$f":"CONCATENATE(\"Layer \",C87,\" - left\")","v":"Layer 17 - left"}]
[{"$f":"IF(L1S>=C87,(IF(B89>B$16,A$17-(L1S-C87)/L1S*B$17/Gradient3,A$16)),0)","v":0},{"$f":"IF(L1S>=C87,C87*B$35/L1S,0)","v":0},{"$f":"CONCATENATE(\"Layer \",C87,\" - right\")","v":"Layer 17 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$36))/3","v":18}]
[{"$f":"IF(L1S>=C90,(IF(B91>B$5,A$6-(L1S-C90)/L1S*B$6/Gradient1,A$5)),0)","v":0},{"$f":"IF(L1S>=C90,C90*B$34/L1S,0)","v":0},{"$f":"CONCATENATE(\"Layer \",C90,\" - left\")","v":"Layer 18 - left"}]
[{"$f":"IF(L1S>=C90,(IF(B92>B$16,A$17-(L1S-C90)/L1S*B$17/Gradient3,A$16)),0)","v":0},{"$f":"IF(L1S>=C90,C90*B$35/L1S,0)","v":0},{"$f":"CONCATENATE(\"Layer \",C90,\" - right\")","v":"Layer 18 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$36))/3","v":19}]
[{"$f":"IF(L1S>=C93,(IF(B94>B$5,A$6-(L1S-C93)/L1S*B$6/Gradient1,A$5)),0)","v":0},{"$f":"IF(L1S>=C93,C93*B$34/L1S,0)","v":0},{"$f":"CONCATENATE(\"Layer \",C93,\" - left\")","v":"Layer 19 - left"}]
[{"$f":"IF(L1S>=C93,(IF(B95>B$16,A$17-(L1S-C93)/L1S*B$17/Gradient3,A$16)),0)","v":0},{"$f":"IF(L1S>=C93,C93*B$35/L1S,0)","v":0},{"$f":"CONCATENATE(\"Layer \",C93,\" - right\")","v":"Layer 19 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$36))/3","v":20}]
[{"$f":"IF(L1S>=C96,(IF(B97>B$5,A$6-(L1S-C96)/L1S*B$6/Gradient1,A$5)),0)","v":0},{"$f":"IF(L1S>=C96,C96*B$34/L1S,0)","v":0},{"$f":"CONCATENATE(\"Layer \",C96,\" - left\")","v":"Layer 20 - left"}]
[{"$f":"IF(L1S>=C96,(IF(B98>B$16,A$17-(L1S-C96)/L1S*B$17/Gradient3,A$16)),0)","v":0},{"$f":"IF(L1S>=C96,C96*B$35/L1S,0)","v":0},{"$f":"CONCATENATE(\"Layer \",C96,\" - right\")","v":"Layer 20 - right"}]
[]
[0,null,"Side 2"]
[]
[null,null,{"$f":"(ROW()-ROW(C$99))/3","v":1}]
[{"$f":"IF(L2S>=C102,(IF(B103<B$11,A$12-(L2S-C102)/L2S*B$12/Gradient2,A$11)),0)","v":0},{"$f":"IF(L2S>=C102,C102*B$37/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C102,\" - left\")","v":"S2 Layer 1 - left"}]
[{"$f":"IF(L2S>=C102,(IF(B104<B$22,A$23-(L2S-C102)/L2S*B$23/Gradient4,A$22)),0)","v":0},{"$f":"IF(L2S>=C102,C102*B$38/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C102,\" - right\")","v":"S2 Layer 1 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$99))/3","v":2}]
[{"$f":"IF(L2S>=C105,(IF(B106<B$11,A$12-(L2S-C105)/L2S*B$12/Gradient2,A$11)),0)","v":0},{"$f":"IF(L2S>=C105,C105*B$37/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C105,\" - left\")","v":"S2 Layer 2 - left"}]
[{"$f":"IF(L2S>=C105,(IF(B107<B$22,A$23-(L2S-C105)/L2S*B$23/Gradient4,A$22)),0)","v":0},{"$f":"IF(L2S>=C105,C105*B$38/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C105,\" - right\")","v":"S2 Layer 2 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$99))/3","v":3}]
[{"$f":"IF(L2S>=C108,(IF(B109<B$11,A$12-(L2S-C108)/L2S*B$12/Gradient2,A$11)),0)","v":0},{"$f":"IF(L2S>=C108,C108*B$37/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C108,\" - left\")","v":"S2 Layer 3 - left"}]
[{"$f":"IF(L2S>=C108,(IF(B110<B$22,A$23-(L2S-C108)/L2S*B$23/Gradient4,A$22)),0)","v":0},{"$f":"IF(L2S>=C108,C108*B$38/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C108,\" - right\")","v":"S2 Layer 3 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$99))/3","v":4}]
[{"$f":"IF(L2S>=C111,(IF(B112<B$11,A$12-(L2S-C111)/L2S*B$12/Gradient2,A$11)),0)","v":0},{"$f":"IF(L2S>=C111,C111*B$37/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C111,\" - left\")","v":"S2 Layer 4 - left"}]
[{"$f":"IF(L2S>=C111,(IF(B113<B$22,A$23-(L2S-C111)/L2S*B$23/Gradient4,A$22)),0)","v":0},{"$f":"IF(L2S>=C111,C111*B$38/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C111,\" - right\")","v":"S2 Layer 4 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$99))/3","v":5}]
[{"$f":"IF(L2S>=C114,(IF(B115<B$11,A$12-(L2S-C114)/L2S*B$12/Gradient2,A$11)),0)","v":0},{"$f":"IF(L2S>=C114,C114*B$37/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C114,\" - left\")","v":"S2 Layer 5 - left"}]
[{"$f":"IF(L2S>=C114,(IF(B116<B$22,A$23-(L2S-C114)/L2S*B$23/Gradient4,A$22)),0)","v":0},{"$f":"IF(L2S>=C114,C114*B$38/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C114,\" - right\")","v":"S2 Layer 5 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$99))/3","v":6}]
[{"$f":"IF(L2S>=C117,(IF(B118<B$11,A$12-(L2S-C117)/L2S*B$12/Gradient2,A$11)),0)","v":0},{"$f":"IF(L2S>=C117,C117*B$37/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C117,\" - left\")","v":"S2 Layer 6 - left"}]
[{"$f":"IF(L2S>=C117,(IF(B119<B$22,A$23-(L2S-C117)/L2S*B$23/Gradient4,A$22)),0)","v":0},{"$f":"IF(L2S>=C117,C117*B$38/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C117,\" - right\")","v":"S2 Layer 6 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$99))/3","v":7}]
[{"$f":"IF(L2S>=C120,(IF(B121<B$11,A$12-(L2S-C120)/L2S*B$12/Gradient2,A$11)),0)","v":0},{"$f":"IF(L2S>=C120,C120*B$37/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C120,\" - left\")","v":"S2 Layer 7 - left"}]
[{"$f":"IF(L2S>=C120,(IF(B122<B$22,A$23-(L2S-C120)/L2S*B$23/Gradient4,A$22)),0)","v":0},{"$f":"IF(L2S>=C120,C120*B$38/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C120,\" - right\")","v":"S2 Layer 7 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$99))/3","v":8}]
[{"$f":"IF(L2S>=C123,(IF(B124<B$11,A$12-(L2S-C123)/L2S*B$12/Gradient2,A$11)),0)","v":0},{"$f":"IF(L2S>=C123,C123*B$37/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C123,\" - left\")","v":"S2 Layer 8 - left"}]
[{"$f":"IF(L2S>=C123,(IF(B125<B$22,A$23-(L2S-C123)/L2S*B$23/Gradient4,A$22)),0)","v":0},{"$f":"IF(L2S>=C123,C123*B$38/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C123,\" - right\")","v":"S2 Layer 8 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$99))/3","v":9}]
[{"$f":"IF(L2S>=C126,(IF(B127<B$11,A$12-(L2S-C126)/L2S*B$12/Gradient2,A$11)),0)","v":0},{"$f":"IF(L2S>=C126,C126*B$37/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C126,\" - left\")","v":"S2 Layer 9 - left"}]
[{"$f":"IF(L2S>=C126,(IF(B128<B$22,A$23-(L2S-C126)/L2S*B$23/Gradient4,A$22)),0)","v":0},{"$f":"IF(L2S>=C126,C126*B$38/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C126,\" - right\")","v":"S2 Layer 9 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$99))/3","v":10}]
[{"$f":"IF(L2S>=C129,(IF(B130<B$11,A$12-(L2S-C129)/L2S*B$12/Gradient2,A$11)),0)","v":0},{"$f":"IF(L2S>=C129,C129*B$37/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C129,\" - left\")","v":"S2 Layer 10 - left"}]
[{"$f":"IF(L2S>=C129,(IF(B131<B$22,A$23-(L2S-C129)/L2S*B$23/Gradient4,A$22)),0)","v":0},{"$f":"IF(L2S>=C129,C129*B$38/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C129,\" - right\")","v":"S2 Layer 10 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$99))/3","v":11}]
[{"$f":"IF(L2S>=C132,(IF(B133<B$11,A$12-(L2S-C132)/L2S*B$12/Gradient2,A$11)),0)","v":0},{"$f":"IF(L2S>=C132,C132*B$37/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C132,\" - left\")","v":"S2 Layer 11 - left"}]
[{"$f":"IF(L2S>=C132,(IF(B134<B$22,A$23-(L2S-C132)/L2S*B$23/Gradient4,A$22)),0)","v":0},{"$f":"IF(L2S>=C132,C132*B$38/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C132,\" - right\")","v":"S2 Layer 11 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$99))/3","v":12}]
[{"$f":"IF(L2S>=C135,(IF(B136<B$11,A$12-(L2S-C135)/L2S*B$12/Gradient2,A$11)),0)","v":0},{"$f":"IF(L2S>=C135,C135*B$37/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C135,\" - left\")","v":"S2 Layer 12 - left"}]
[{"$f":"IF(L2S>=C135,(IF(B137<B$22,A$23-(L2S-C135)/L2S*B$23/Gradient4,A$22)),0)","v":0},{"$f":"IF(L2S>=C135,C135*B$38/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C135,\" - right\")","v":"S2 Layer 12 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$99))/3","v":13}]
[{"$f":"IF(L2S>=C138,(IF(B139<B$11,A$12-(L2S-C138)/L2S*B$12/Gradient2,A$11)),0)","v":0},{"$f":"IF(L2S>=C138,C138*B$37/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C138,\" - left\")","v":"S2 Layer 13 - left"}]
[{"$f":"IF(L2S>=C138,(IF(B140<B$22,A$23-(L2S-C138)/L2S*B$23/Gradient4,A$22)),0)","v":0},{"$f":"IF(L2S>=C138,C138*B$38/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C138,\" - right\")","v":"S2 Layer 13 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$99))/3","v":14}]
[{"$f":"IF(L2S>=C141,(IF(B142<B$11,A$12-(L2S-C141)/L2S*B$12/Gradient2,A$11)),0)","v":0},{"$f":"IF(L2S>=C141,C141*B$37/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C141,\" - left\")","v":"S2 Layer 14 - left"}]
[{"$f":"IF(L2S>=C141,(IF(B143<B$22,A$23-(L2S-C141)/L2S*B$23/Gradient4,A$22)),0)","v":0},{"$f":"IF(L2S>=C141,C141*B$38/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C141,\" - right\")","v":"S2 Layer 14 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$99))/3","v":15}]
[{"$f":"IF(L2S>=C144,(IF(B145<B$11,A$12-(L2S-C144)/L2S*B$12/Gradient2,A$11)),0)","v":0},{"$f":"IF(L2S>=C144,C144*B$37/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C144,\" - left\")","v":"S2 Layer 15 - left"}]
[{"$f":"IF(L2S>=C144,(IF(B146<B$22,A$23-(L2S-C144)/L2S*B$23/Gradient4,A$22)),0)","v":0},{"$f":"IF(L2S>=C144,C144*B$38/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C144,\" - right\")","v":"S2 Layer 15 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$99))/3","v":16}]
[{"$f":"IF(L2S>=C147,(IF(B148<B$11,A$12-(L2S-C147)/L2S*B$12/Gradient2,A$11)),0)","v":0},{"$f":"IF(L2S>=C147,C147*B$37/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C147,\" - left\")","v":"S2 Layer 16 - left"}]
[{"$f":"IF(L2S>=C147,(IF(B149<B$22,A$23-(L2S-C147)/L2S*B$23/Gradient4,A$22)),0)","v":0},{"$f":"IF(L2S>=C147,C147*B$38/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C147,\" - right\")","v":"S2 Layer 16 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$99))/3","v":17}]
[{"$f":"IF(L2S>=C150,(IF(B151<B$11,A$12-(L2S-C150)/L2S*B$12/Gradient2,A$11)),0)","v":0},{"$f":"IF(L2S>=C150,C150*B$37/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C150,\" - left\")","v":"S2 Layer 17 - left"}]
[{"$f":"IF(L2S>=C150,(IF(B152<B$22,A$23-(L2S-C150)/L2S*B$23/Gradient4,A$22)),0)","v":0},{"$f":"IF(L2S>=C150,C150*B$38/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C150,\" - right\")","v":"S2 Layer 17 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$99))/3","v":18}]
[{"$f":"IF(L2S>=C153,(IF(B154<B$11,A$12-(L2S-C153)/L2S*B$12/Gradient2,A$11)),0)","v":0},{"$f":"IF(L2S>=C153,C153*B$37/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C153,\" - left\")","v":"S2 Layer 18 - left"}]
[{"$f":"IF(L2S>=C153,(IF(B155<B$22,A$23-(L2S-C153)/L2S*B$23/Gradient4,A$22)),0)","v":0},{"$f":"IF(L2S>=C153,C153*B$38/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C153,\" - right\")","v":"S2 Layer 18 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$99))/3","v":19}]
[{"$f":"IF(L2S>=C156,(IF(B157<B$11,A$12-(L2S-C156)/L2S*B$12/Gradient2,A$11)),0)","v":0},{"$f":"IF(L2S>=C156,C156*B$37/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C156,\" - left\")","v":"S2 Layer 19 - left"}]
[{"$f":"IF(L2S>=C156,(IF(B158<B$22,A$23-(L2S-C156)/L2S*B$23/Gradient4,A$22)),0)","v":0},{"$f":"IF(L2S>=C156,C156*B$38/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C156,\" - right\")","v":"S2 Layer 19 - right"}]
[null,null,{"$f":"(ROW()-ROW(C$99))/3","v":20}]
[{"$f":"IF(L2S>=C159,(IF(B160<B$11,A$12-(L2S-C159)/L2S*B$12/Gradient2,A$11)),0)","v":0},{"$f":"IF(L2S>=C159,C159*B$37/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C159,\" - left\")","v":"S2 Layer 20 - left"}]
[{"$f":"IF(L2S>=C159,(IF(B161<B$22,A$23-(L2S-C159)/L2S*B$23/Gradient4,A$22)),0)","v":0},{"$f":"IF(L2S>=C159,C159*B$38/L2S,0)","v":0},{"$f":"CONCATENATE(\"S2 Layer \",C159,\" - right\")","v":"S2 Layer 20 - right"}]
[]
[null,null,"Start of Pass Data"]