{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Home","Data","Blank page","BlankPage","WelcomePage","DevFrame"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":170,"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":"Home","index":0,"n_rows":47,"n_cols":8,"rows_kept":47,"cut":false,"hidden":false,"merged":[[33,4,33,5],[34,4,34,5],[5,4,5,5],[30,4,30,5]]}
["DevFrame settings",null,"H",null,null,null,null,"HL"]
["HiddenStatus","VISIBLE",null,null,null,"ENGINEXCEL"]
["ProtectSheet",true,null,null,null,"Email: alessandro@enginexcel.com"]
["HeadingsVisibility",false,null,null,null,"Website: www.enginexcel.com"]
["GridlineVisibility",false]
[null,null,null,null,"ZOOM AND SCROLL CHART"]
["Protection settings"]
["DrawingObjects",true,null,null,"Introduction"]
["Contents",true,null,null,"This spreadsheet allows to zoom and scroll scattered plot charts."]
["Scenarios",true]
["UserInterfaceOnly",true,null,null,"Features"]
["AllowFormattingCells",false,null,null,"- Works with all Excel scattered plots"]
[null,null,null,null,"      - Possible to add multiple scattered plots"]
["AllowFormattingColumns",false,null,null,"- Chart zoom"]
["AllowFormattingRows",false,null,null,"      - Allows selection of which axis to zoom"]
["AllowInsertingColumns",false,null,null,"      - Allows to define the speed of the zoom"]
["AllowInsertingRows",false,null,null,"- Chart scroll"]
["AllowInsertingHyperlinks",false,null,null,"      - Allows to scroll up/down/left/right"]
["AllowDeletingColumns",false,null,null,"      - Allows to define the speed of the scroll"]
["AllowDeletingRows",false,null,null,"- Reset view button"]
["AllowSorting",false,null,null,"- Excel Add-in available"]
["AllowFiltering",false]
["AllowUsingPivotTables",false,null,null,"Instructions"]
["EnableSelection",false,null,null,"Operation","How to"]
[null,null,null,null,"How to activate the zoom/move tool","- Click on the chart area (the white area around the chart)\n- Click on the button \"Zoom and scroll chart\""]
["Other settings",null,null,null,"How to move the chart","- Activate the zoom/move tool\n- Define the movement speed (use the scroll bar or type a number between 1 and 99 - the higher the number the higher the movement speed)\n- Click on one of the movement buttons (Up/down/left/right)"]
["MarkProtectedCellsStatus",false,null,null,"How to zoom the chart","- Activate the zoom/move tool\n- Define the zoom speed (use the scroll bar or type a number between 1 and 99 - the higher the number the higher the zoom speed)\n- Click on one of the zoom buttons (In/out)"]
["RowColumnDimensionStatus",false,null,null,"How to restore the original zoom and position of the chart","- Activate the zoom/move tool\n- Click on \"Reset view\""]
[]
[null,null,null,null,"Terms of use"]
[null,null,null,null,"This spreadsheet is free for personal and commercial use, but it may not be altered or sold without the written permission of the author."]
[]
[null,null,null,null,"Disclaimer"]
[null,null,null,null,"This spreadsheet may be freely distributed, provided that no charge above the cost of distribution is levied, and that the terms of use and disclaimer are always attached to it.\nThis spreadsheet is provided as is without any guarantees or warranty.\n"]
[null,null,null,null,"Although the author has attempted to find and correct any bugs in the spreadsheet, the author is not responsible for any damage or losses of any kind caused by the use or misuse of the spreadsheet.\nThe author is under no obligation to provide support, service, corrections, or upgrades to the spreadsheet.\nFor more information, please send an email to the author (see contacts below)."]
[]
[null,null,null,null,"Version history"]
[null,null,null,null,"1.0   -   01/09/2017","First release"]
[null,null,"H",null,"1.1   -   08/09/2017","Minor bug fix"]
[null,null,"H",null,"1.2   -   09/04/2018","Welcome page added"]
[null,null,"H",null,"1.3   -   21/04/2018","Added internet connection verification"]
[null,null,null,null,"1.4   -   28/05/2018","Added Excel 365 compatibility\nAdded Windows 10 x64 compatibility"]
[]
[null,null,null,null,"Copyright"]
[null,null,null,null,"EnginExcel, All rights reserved"]
[]
[null,null,"HL"]

{"sheet":"Data","index":1,"n_rows":212,"n_cols":162,"rows_kept":212,"cut":false,"hidden":false,"merged":[]}
["DevFrame settings",null,"H",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HL"]
["HiddenStatus","VISIBLE"]
["ProtectSheet",false]
["HeadingsVisibility",false]
["GridlineVisibility",false]
[null,null,null,null,"Chart name:","Title"]
["Protection settings",null,null,null,"X axis name:","X axis"]
["DrawingObjects",true,null,null,"Y axis name:","Y axis"]
["Contents",true]
["Scenarios",true,null,null,"Data name:","Series 1",null,"Data name:","Series 2"]
["UserInterfaceOnly",false,null,null,"x","y",null,"x","y"]
["AllowFormattingCells",false,null,null,0,{"$f":"E12^1.3+25 * SIN(DEGREES(E12))","v":0},null,0,{"$f":"H12^1.2+10 * SIN(DEGREES(H12))","v":0}]
["AllowFormattingColumns",false,null,null,0.9,{"$f":"E13^1.3+25 * SIN(DEGREES(E13))","v":24.965754940958721},null,1,{"$f":"H13^1.2+10 * SIN(DEGREES(H13))","v":7.7952261835137939}]
["AllowFormattingRows",false,null,null,1.8,15.003821168771967,null,2,12.268094040595022]
["AllowInsertingColumns",false,null,null,2.7,-13.596017688947295,null,3,11.572061730570018]
["AllowInsertingRows",false,null,null,3.6,-16.765779333523795,null,4,6.803508896532855]
["AllowInsertingHyperlinks",false,null,null,4.5,12.531791168642258,null,5,1.3021260772105512]
["AllowDeletingColumns",false,null,null,5.4,33.925125883061021,null,6,-1.1514908580724352]
["AllowDeletingRows",false,null,null,6.3,18.801253242445789,null,7,1.6392974547427581]
["AllowSorting",false,null,null,7.2,-7.7583604134932376,null,8,9.1104860758831645]
["AllowFiltering",false,null,null,8.1,-3.7728412984122173,null,9,18.233426226715885]
["AllowUsingPivotTables",false,null,null,9,28.065678558079981,null,10,25.124916488035772]
["EnableSelection",false,null,null,9.9,44.330097968945758,null,11,27.113257585065995]
[null,null,null,null,10.8,24.531415607704723,null,12,24.159457358340003]
["Other settings",null,null,null,11.7,1.156928856645802,null,13,18.876376320386239]
["MarkProtectedCellsStatus",false,null,null,12.6,12.025591941627681,null,14,15.135521356436282]
["RowColumnDimensionStatus",false,null,null,13.5,44.825863101490192,null,15,16.003572805900156]
[null,null,null,null,14.4,55.16493684363715,null,16,22.107794004618547]
[null,null,null,null,15.3,31.662063917424035,null,17,31.301022814574125]
[null,null,null,null,16.2,12.633790494332743,null,18,39.804677397654956]
["TableStart",null,null,null,17.100000000000001,29.904009987789763,null,19,44.220889467721108]
["TableStartRow",{"$f":"ROW(TableStart)","v":7},null,null,18,62.135055828403196,null,20,43.341906026830081]
["TableStartColumn",{"$f":"COLUMN(TableStart)","v":5},null,null,18.899999999999999,66.114531308187367,null,21,38.79289678069555]
[null,null,null,null,19.8,40.119201580927893,null,22,34.165740790844701]
[null,null,null,null,20.7,26.439851153478706,null,23,33.105209194253142]
[null,null,null,null,21.6,49.364662139595275,null,24,37.367011171609107]
[null,null,null,null,22.5,79.561541021644913,null,25,45.882159540882881]
[null,null,null,null,23.4,77.088716065869889,null,26,55.326055857658432]
[null,null,null,null,24.3,49.963355549936288,null,27,61.889145176366348]
[null,null,null,null,25.2,42.403859620435142,null,28,63.305925936465087]
[null,null,null,null,26.1,69.987180930370229,null,29,60.06147743692194]
[null,null,null,null,27,96.80571015512362,null,30,55.132796589303197]
[null,null,null,null,27.9,88.120593986265149,null,31,52.402729664812313]
[null,null,null,null,28.8,61.301270499982984,null,32,54.591381534297689]
[null,null,null,null,29.7,60.35407836869868,null,33,61.806920441266406]
[null,null,null,null,30.6,91.390883561114705,null,34,71.487750164378582]
[null,null,null,null,31.5,113.66576829269044,null,35,79.766852846957519]
[null,null,null,null,32.4,99.323472346434883,null,36,83.531528546186252]
[null,null,null,null,33.299999999999997,74.245169041796174,null,37,82.081326168213934]
[null,null,null,null,34.200000000000003,80.095805421643973,null,38,77.501000332710106]
[null,null,null,null,35.1,113.22633917243981,null,39,73.549822762431745]
[null,null,null,null,36,130.0239132253428,null,40,73.658901280991657]
[null,null,null,null,36.9,110.8645322841741,null,41,79.103315777654927]
[null,null,null,null,37.799999999999997,88.888783824846939,null,42,88.322757146712974]
[null,null,null,null,38.700000000000003,101.40422157886346,null,43,97.752558192198109]
[null,null,null,null,39.6,135.17738490825923,null,44,103.7224335003816]
[null,null,null,null,40.5,145.83859394524222,null,45,104.41148648638375]
[null,null,null,null,41.4,122.94455482758613,null,46,100.81806884325063]
[null,null,null,null,42.3,105.29173193177793,null,47,96.227856794796409]
[null,null,null,null,43.2,124.02513626800382,null,48,94.463494796526817]
[null,null,null,null,44.1,156.96713471149167,null,49,97.848205264469129]
[null,null,null,null,45,161.13797779559783,null,50,105.96813062193006]
[null,null,null,null,45.9,135.78032428439312,null,51,115.8926965493647]
[null,null,null,null,46.8,123.46933748713505,null,52,123.73561073741602]
[null,null,null,null,47.7,147.68052022486836,null,53,126.72496714858443]
[null,null,null,null,48.6,178.3650826640278,null,54,124.67972994404587]
[null,null,null,null,49.5,176.01271937701125,null,55,120.10608738527921]
[null,null,null,null,50.4,149.5886551250853,null,56,116.86234871365464]
[null,null,null,null,51.3,143.38675387629391,null,57,118.10358112686217]
[null,null,null,null,52.2,172.07713729001182,null,58,124.6008598646083]
[null,null,null,null,53.1,199.19372302968006,null,59,134.33045143685183]
[null,null,null,null,54,190.60730403789577,null,60,143.55176822880739]
[null,null,null,null,54.9,164.57187160233508,null,61,148.79987778501268]
[null,null,null,null,55.8,164.9568402108317,null,62,148.7311751419054]
[null,null,null,null,56.7,196.91712547753417,null,63,144.83904529014856]
[null,null,null,null,57.6,219.33371842754536,null,64,140.65828880928123]
[null,null,null,null,58.5,{"$f":"E77^1.3+25 * SIN(DEGREES(E77))","v":205.10980901591037},null,65,{"$f":"H77^1.2+10 * SIN(DEGREES(H77))","v":139.8821058029996}]
[null,null,null,null,59.4,180.90492973705625,null,66,144.3947035474385]
[null,null,null,null,60.3,188.04143652810515,null,67,153.26753974824209]
[null,null,null,null,61.2,221.90960481816293,null,68,163.25389340305802]
[null,null,null,null,62.1,238.72699731944701,null,69,170.51830981474987]
[null,null,null,null,63,219.74024557031456,null,70,172.67966010246582]
[null,null,null,null,63.9,198.72450502988443,null,71,170.07949597725229]
[null,null,null,null,64.8,212.4557048434057,null,72,165.60005870181487]
[null,null,null,null,65.7,246.78250444685187,null,73,163.12888715033711]
[null,null,null,null,66.599999999999994,257.37740750564421,null,74,165.4879142075273]
[null,null,null,null,67.5,234.73784271655194,null,75,172.9302029283472]
[null,null,null,null,68.400000000000006,218.12038827172248,null,76,183.0050973565501]
[null,null,null,null,69.3,237.9751563582046,null,77,191.86362088969585]
[null,null,null,null,70.2,271.29388132894985,null,78,196.30874834286755]
[null,null,null,null,71.099999999999994,275.3487514917029,null,79,195.49839043699217]
[null,null,null,null,72,250.34775687143619,null,80,191.39392636474685]
[null,null,null,null,72.900000000000006,239.12948522539344,null,81,187.71535519109969]
[null,null,null,null,73.8,264.34491370014194,null,82,187.95964737893141]
[null,null,null,null,74.7,295.24208038451678,null,83,193.53790248436124]
[null,null,null,null,75.599999999999994,292.76020392323932,null,84,203.02363210439421]
[null,null,null,null,76.5,266.8077626156275,null,85,212.91260086900405]
[null,null,null,null,77.400000000000006,261.73262905222282,null,86,219.48946508152733]
[null,null,null,null,78.3,291.29068442463466,null,87,220.8068675958001]
[null,null,null,null,79.2,318.47417411315405,null,88,217.72274310754801]
[null,null,null,null,80.099999999999994,309.77926736621379,null,89,213.44327076469074]
[null,null,null,null,81,284.33550753497991,null,90,211.81493905171453]
[null,null,null,null,81.900000000000006,285.85430279534143,null,91,215.27552439134632]
[null,null,null,null,82.8,318.5308616618492,null,92,223.55547846105702]
[null,null,null,null,83.7,340.89222364712731,null,93,233.8214833416732]
[null,null,null,null,84.6,326.61256070599995,null,94,242.18570396021451]
[null,null,null,null,85.5,303.11690417252589,null,95,245.77677279215783]
[null,null,null,null,86.4,311.36524441007055,null,96,244.26931213574221]
[null,null,null,null,87.3,345.78912798280135,null,97,240.05723137053778]
[null,null,null,null,88.2,362.45702215659196,null,98,236.97848531445302]
[null,null,null,null,89.1,343.49485185785051,null,99,238.27060326063764]
[null,null,null,null,90,323.29618871359344,null,100,244.84605972216303]
[null,null,null,null,90.9,338.08777811188025,null,101,254.80618115116474]
[null,null,null,null,91.8,372.80692417564262,null,102,264.45252607772545]
[null,null,null,null,92.7,383.18911259343287,null,103,270.25698567593315]
[null,null,null,null,93.6,360.67684002071138,null,104,270.74115013407379]
[null,null,null,null,94.5,344.96810337328589,null,105,267.26381948531775]
[null,null,null,null,95.4,365.80359133931427,null,106,263.29715904717983]
[null,null,null,null,96.3,399.35515809038355,null,107,262.57708485664369]
[null,null,null,null,97.2,403.16701010395383,null,108,267.11315190572611]
[null,null,null,null,98.1,378.41225924418393,null,109,276.1180595602122]
[null,null,null,null,99,368.17256234081066,null,110,286.42701685512714]
[null,null,null,null,99.9,394.26356357387482,null,111,294.18357558749466]
[null,null,null,null,100.8,425.24457041589915,null,112,296.8939032779565]
[null,null,null,null,101.7,422.52269931635732,null,113,294.75520351403179]
[null,null,null,null,102.6,396.94491225284406,null,114,290.55064626037813]
[null,null,null,null,103.5,392.89204504009086,null,115,288.16677779328296]
[null,null,null,null,104.4,423.19915780449196,null,116,290.52317246231723]
[null,null,null,null,105.3,450.33424283008173,null,117,298.01718190250278]
[null,null,null,null,106.2,441.43461194193736,null,118,308.31224960480677]
[null,null,null,null,107.1,416.49625002859227,null,119,317.58255373583586]
[null,null,null,null,108,419.05183150378218,null,120,322.55096831671864]
[null,null,null,null,108.9,452.33481264114948,null,121,322.23473941408054]
[null,null,null,null,109.8,474.53782650813343,null,122,318.46897054453814]
[null,null,null,null,110.7,460.11841455744951,null,123,314.92906138376179]
[null,null,null,null,111.6,437.25408862107287,null,124,315.17283776100197]
[null,null,null,null,112.5,446.52305938985654,null,125,320.74531243507602]
[null,null,null,null,113.4,481.4007267905622,null,126,330.3556533017092]
[null,null,null,null,114.3,497.8271812834567,null,127,340.56478055883036]
[null,null,null,null,115.2,478.81604429310056,null,128,347.6173160830005]
[null,null,null,null,116.1,{"$f":"E141^1.3+25 * SIN(DEGREES(E141))","v":459.36300143652858},null,129,{"$f":"H141^1.2+10 * SIN(DEGREES(H141))","v":349.44202228040973}]
[null,null,null,null,117,475.12844735676481,null,130,346.75511486904134]
[null,null,null,null,117.9,510.14541024570173,null,131,342.67872492660649]
[null,null,null,null,118.8,520.23324257943545,null,132,341.0777519878543]
[null,null,null,null,119.7,497.78351638635911,null,133,344.50105137868985]
[null,null,null,null,120.6,482.91684557774653,null,134,352.82366651946205]
[null,null,null,null,121.5,504.65040182488474,null,135,363.31337666622187]
[null,null,null,null,122.4,538.34738908443956,null,136,372.08611071043231]
[null,null,null,null,123.3,541.84406855874806,null,137,376.17494137059867]
[null,null,null,null,124.2,517.27808812370233,null,138,375.11052542856856]
[null,null,null,null,125.1,507.9537786388355,null,139,371.17110390128664]
[null,null,null,null,126,534.84110986750557,null,140,368.16888933178592]
[null,null,null,null,126.9,565.82549271137725,null,141,369.4193206211898]
[null,null,null,null,127.8,562.80015731101798,null,142,375.97494483483888]
[null,null,null,null,128.69999999999999,537.5453957312892,null,143,386.06472103920146]
[null,null,null,null,129.6,534.45400271683945,null,144,396.03742390020813]
[null,null,null,null,130.5,565.43412569608097,null,145,402.30660454376635]
[null,null,null,null,131.4,592.44722174699132,null,146,403.26104575659775]
[null,null,null,null,132.30000000000001,583.28725673577151,null,147,400.123029456121]
[null,null,null,null,133.19999999999999,558.80718279972359,null,148,396.29722516983196]
[null,null,null,null,134.1,562.34034113307678,null,149,395.55704069182883]
[null,null,null,null,135,596.15688659466821,null,150,400.03454938388614]
[null,null,null,null,135.9,618.13478826357925,null,151,409.08474151915203]
[null,null,null,null,136.80000000000001,603.5270116935493,null,152,419.62910262025645]
[null,null,null,null,137.69999999999999,581.25021078524492,null,153,427.79549774069562]
[null,null,null,null,138.6,591.48161685158243,null,154,430.98081028073608]
[null,null,null,null,139.5,626.74354971761272,null,155,429.23758644285067]
[null,null,null,null,140.4,642.86853319801787,null,156,425.24603246459105]
[null,null,null,null,141.30000000000001,623.76589812888415,null,157,422.88628144510005]
[null,null,null,null,142.19999999999999,605.01688540376745,null,158,425.17147020777276]
[null,null,null,null,143.1,621.69866647474623,null,159,432.64265730792459]
[null,null,null,null,144,656.94752607348016,null,160,443.08059472702377]
[null,null,null,null,144.9,666.68755309146047,null,161,452.68788984190195]
[null,null,null,null,145.80000000000001,644.26297715375631,null,162,458.11183076336499]
[null,null,null,null,146.69999999999999,630.19805009804338,null,163,458.23033442607209]
[null,null,null,null,147.6,652.77269654560678,null,164,454.74965916238818]
[null,null,null,null,148.5,686.55310302552505,null,165,451.29548571933015]
[null,null,null,null,149.4,689.68750367401901,null,166,451.48153957228391]
[null,null,null,null,150.30000000000001,665.2770595046029,null,167,456.98458181875282]
[null,null,null,null,151.19999999999999,656.82829322344674,null,168,466.65120345094243]
[null,null,null,null,152.1,684.45557586346945,null,169,477.11222555296411]
[null,null,null,null,153,715.38559103757143,null,170,484.57742003718545]
[null,null,null,null,153.9,712.01568469422966,null,171,486.85451954396927]
[null,null,null,null,154.80000000000001,687.05389959132253,null,172,484.5170083365764]
[null,null,null,null,155.69999999999999,684.88399423938472,null,173,480.59862262642883]
[null,null,null,null,156.6,716.48156410093441,null,174,478.97729721853477]
[null,null,null,null,157.5,743.3195020428135,null,175,482.30941536397506]
[null,null,null,null,158.4,733.86364217663345,null,176,490.61476808808823]
[null,null,null,null,159.30000000000001,709.81403715406395,null,177,501.2660022579214]
[null,null,null,null,160.19999999999999,714.28420189072153,null,178,510.38817830544394]
[null,null,null,null,161.1,748.57990773348979,null,179,514.92290596573446]
[null,null,null,null,162,770.28436226165263,null,180,514.25751173931837]
[null,null,null,null,162.9,755.45764460962141,null,181,510.55139542303982]
[null,null,null,null,163.80000000000001,733.74187340493336,null,182,507.58572855940497]
[null,null,null,null,164.7,744.89430052798821,null,183,508.74924995181578]
[null,null,null,null,165.6,780.48769250857788,null,184,515.23310661001415]
[null,null,null,null,166.5,796.26787692473476,null,185,525.39633189526944]
[null,null,null,null,167.4,777.04749260438473,null,186,535.63996487115696]
[null,null,null,null,168.3,758.97650896651487,null,187,542.32417544975488]
[null,null,null,null,169.2,776.53228597268537,null,188,543.70716024489866]
[null,null,null,null,170.1,811.9623294242831,null,189,540.8729769869725]
[null,null,null,null,171,821.3162926342784,null,190,537.15406856426205]
[null,null,null,null,171.9,798.89420234497982,null,191,536.35609286805368]
[null,null,null,null,172.8,785.60478581680002,null,192,540.73067539773263]
[null,null,null,null,173.7,{"$f":"E205^1.3+25 * SIN(DEGREES(E205))","v":808.97734620946892},null,193,{"$f":"H205^1.2+10 * SIN(DEGREES(H205))","v":549.77598082976817}]
[null,null,null,null,174.6,842.79306905222154,null,194,560.50402813956043]
[null,null,null,null,175.5,845.53193881528568,null,195,569.03235294674369]
[null,null,null,null,176.4,821.25715776491677,null,196,572.6521530625779]
[null,null,null,null,177.3,813.65686893152099,null,197,571.27123496040315]
[null,null,null,null,178.2,841.98033078675041,null,198,567.46311673852449]
[null,null,null,null,179.1,872.8109861659525,null,199,565.09613087386992]
[null,null,null,null,180,869.06806630649987,null,200,567.2727912301757]

{"sheet":"Blank page","index":2,"n_rows":33,"n_cols":162,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["DevFrame settings",null,"H",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HL"]
["HiddenStatus","VISIBLE"]
["ProtectSheet",false]
["HeadingsVisibility",false]
["GridlineVisibility",false]
[]
["Protection settings"]
["DrawingObjects",true]
["Contents",true]
["Scenarios",true]
["UserInterfaceOnly",false]
["AllowFormattingCells",false]
["AllowFormattingColumns",false]
["AllowFormattingRows",false]
["AllowInsertingColumns",false]
["AllowInsertingRows",false]
["AllowInsertingHyperlinks",false]
["AllowDeletingColumns",false]
["AllowDeletingRows",false]
["AllowSorting",false]
["AllowFiltering",false]
["AllowUsingPivotTables",false]
["EnableSelection",false]
[]
["Other settings"]
["MarkProtectedCellsStatus",false]
["RowColumnDimensionStatus",false]
[]
[]
[]
["TableStart"]
["TableStartRow",{"$f":"ROW(TableStart)","v":7}]
["TableStartColumn",{"$f":"COLUMN(TableStart)","v":5}]

{"sheet":"BlankPage","index":3,"n_rows":33,"n_cols":17,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
["DevFrame settings",null,"H",null,null,null,null,null,null,null,null,null,null,null,null,null,"HL"]
["HiddenStatus","VERY HIDDEN"]
["ProtectSheet",false]
["HeadingsVisibility",false]
["GridlineVisibility",false]
[]
["Protection settings"]
["DrawingObjects",true]
["Contents",true]
["Scenarios",true]
["UserInterfaceOnly",false]
["AllowFormattingCells",false]
["AllowFormattingColumns",false]
["AllowFormattingRows",false]
["AllowInsertingColumns",false]
["AllowInsertingRows",false]
["AllowInsertingHyperlinks",false]
["AllowDeletingColumns",false]
["AllowDeletingRows",false]
["AllowSorting",false]
["AllowFiltering",false]
["AllowUsingPivotTables",false]
["EnableSelection",false]
[]
["Other settings"]
["MarkProtectedCellsStatus",false]
["RowColumnDimensionStatus",false]
[]
[]
[]
["TableStart"]
["TableStartRow",{"$f":"ROW(TableStart)","v":6},"HL"]
["TableStartColumn",{"$f":"COLUMN(TableStart)","v":5}]

{"sheet":"WelcomePage","index":4,"n_rows":54,"n_cols":17,"rows_kept":54,"cut":false,"hidden":true,"merged":[[5,4,5,9],[12,4,12,9],[22,4,22,9]]}
["DevFrame settings",null,"H",null,null,null,null,null,null,null,null,null,null,null,null,null,"HL"]
["HiddenStatus","VERY HIDDEN"]
["ProtectSheet",false]
["HeadingsVisibility",false]
["GridlineVisibility",false]
[null,null,null,null,"COUNTERS"]
["Protection settings"]
["DrawingObjects",true,null,null,"OpenedTimes",1]
["Contents",true,null,null,"NotShowAgain",false]
["Scenarios",true]
["UserInterfaceOnly",false]
["AllowFormattingCells",false]
["AllowFormattingColumns",false,null,null,"MESSAGES RELATED TO SPREADSHEET"]
["AllowFormattingRows",false]
["AllowInsertingColumns",false,null,null,"SpreadsheetName"]
["AllowInsertingRows",false,null,null,"Zoom chart"]
["AllowInsertingHyperlinks",false]
["AllowDeletingColumns",false,null,null,"VideoLink"]
["AllowDeletingRows",false,null,null,"https://youtu.be/wYb8wJbfhX4"]
["AllowSorting",false]
["AllowFiltering",false]
["AllowUsingPivotTables",false]
["EnableSelection",false,null,null,"MESSAGES VALID FOR ALL SPREADSHEETS"]
[]
["Other settings",null,null,null,"WelcomeText"]
["MarkProtectedCellsStatus",false,null,null,"Thanks for downloading EnginExcel free material."]
["RowColumnDimensionStatus",false,null,null,{"$f":"\"A quick introductory video on \"  & SpreadsheetName &  \" main functionalities is linked below.\"","v":"A quick introductory video on Zoom chart main functionalities is linked below."}]
[]
[null,null,null,null,"ButtonText"]
[null,null,null,null,"Introductory video"]
["TableStart"]
["TableStartRow",{"$f":"ROW(TableStart)","v":{"$error":"#REF!"}},null,null,"FreeMaterialText"]
["TableStartColumn",{"$f":"COLUMN(TableStart)","v":{"$error":"#REF!"}},null,null,"If you like this spreadsheet please consider subscribing to EnginExcel free material newsletter. You will receive an email when a new free spreadsheet is released."]
[]
[null,null,null,null,"ButtonText2"]
[null,null,null,null,"Open subscription page"]
[]
[null,null,null,null,"FreeMaterialLink"]
[null,null,null,null,"http://enginexcel.com/newsletter"]
[]
[null,null,null,null,"ReminderText1"]
[null,null,null,null,"If you are enjoying this spreadsheet please consider subscribing to EnginExcel newsletter. You will receive an email when a new free spreadsheet is released."]
[]
[null,null,null,null,"ReminderText2"]
[null,null,null,null,"EnginExcel provides consultancy to develop customised spreadsheets for Mechanical Engineers and Project Managers using Microsoft Excel and Visual Basic for Applications (VBA)."]
[]
[null,null,null,null,"ButtonText3"]
[null,null,null,null,"See how I can help you"]
[]
[null,null,null,null,"ServicesLink"]
[null,null,null,null,"http://enginexcel.com/what-i-do"]
[]
[]
[null,null,"HL"]

{"sheet":"DevFrame","index":5,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
["DevFrame settings",null,"H"]
["HiddenStatus","VERY HIDDEN",null,"HiddenStatuses","TrueFalse"]
["ProtectSheet",false,null,"VISIBLE",true]
["HeadingsVisibility",true,null,"HIDDEN",false]
["GridlineVisibility",true,null,"VERY HIDDEN"]
[]
["Protection settings",null,null,"ProgrammingMode","Password","DevFramePassword"]
["DrawingObjects",true,null,false,"Password","EnginExce1"]
["Contents",true]
["Scenarios",true,null,"AllowAddSheet"]
["UserInterfaceOnly",false,null,true]
["AllowFormattingCells",false]
["AllowFormattingColumns",false]
["AllowFormattingRows",false]
["AllowInsertingColumns",false,null,null,"DEVELOPMENT FRAME"]
["AllowInsertingRows",false,null,"Features:"]
["AllowInsertingHyperlinks",false,null,"- Define visibility status of each sheet"]
["AllowDeletingColumns",false,null,"- Define which cells to protect"]
["AllowDeletingRows",false,null,"- Protect sheet with password"]
["AllowSorting",false,null,"- Define if to show the headings of each page"]
["AllowFiltering",false,null,"- Define if to show the gridline in each page"]
["AllowUsingPivotTables",false,null,"- Dev frame is protected by separate password"]
["EnableSelection",false,null,"- Define which rows and columns to hide"]
[null,null,null,"      - Rows and columns with \"H\" are hidden"]
["Other settings",null,null,"      - From the last \"H\", all the following rows (or columns) are hidden"]
["MarkProtectedCellsStatus",true]
["RowColumnDimensionStatus",false,null,"Activation:"]
[null,null,null,"- Activate development frame: CTRL + r"]
[null,null,null,"- Protect a selected cell: CTRL + p"]
[null,null,null,"- Unprotect a selected cell: CTRL + o"]
[]
[null,null,null,"Version control:"]
[null,null,null,"Version","Release date","Changed features"]
[null,null,null,"1.0","2017-01-08","First issue"]
[null,null,null,"1.1","2017-01-18","Updated SubErrorHandler (writes log file"]
[null,null,null,"1.2","2017-02-10","Added EnableSelection option"]
[null,null,null,"1.4","2017-03-10","Added UserInterfaceOnly renewal at workbook open"]
[null,null,null,"1.5","2017-05-21","Added TableStart variable and HL row-hiding parameter"]