{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Home","Data analysis","WelcomePage"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":14,"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":58,"n_cols":3,"rows_kept":58,"cut":false,"hidden":false,"merged":[[4,1,4,2],[43,1,43,2],[46,1,46,2],[47,1,47,2],[7,1,7,2],[35,1,37,1],[39,1,40,1]]}
[null,null,"ENGINEXCEL"]
[null,null,"Email: alessandro@enginexcel.com"]
[null,null,"Website: www.enginexcel.com"]
[]
[null,"EXCEL DATA ANALYSIS"]
[]
[null,"Introduction"]
[null,"Excel data analysis allows to quickly calculate and print some basic statistical analysis and frequency distribution of a sample. "]
[]
[null,"Features"]
[null,"- Automated basic statistical analysis of a user-defined sample including:"]
[null,"      - Maximum"]
[null,"      - Minimum"]
[null,"      - Average"]
[null,"      - Variance"]
[null,"      - Standard deviation"]
[null,"      - Relative standard deviation (RSD and 3RSD)"]
[null,"- Configurable data frequency distribution including:"]
[null,"      - Size of the interval"]
[null,"      - Number of intervals"]
[null,"      - Automated configuration also available"]
[null,"- Automated creation of charts:"]
[null,"      - Data plot"]
[null,"      - Frequency distribution histogram"]
[null,"- Automated inclusion of data unit of measure"]
[null,"- Configurable analysis output"]
[null,"      - Choose which analysis to plot"]
[null,"      - Automatic save of last used settings"]
[null,"- Excel add-in available"]
[]
[]
[null,"Instructions"]
[null,"Operation","How to"]
[null,"How to open the data analysis tool when in spreadsheed mode","- Go to \"Data analysis\" page\n- Click on \"Data analysis\""]
[null,"How to open the data analysis tool when in add-in mode","- Install the add-in in Excel (see instructions on the website)\n- Click on the \"EnginExcel\" tab in Excel\n- Click on \"Open data analysis tool\""]
[null,"How to perform an analysis","- Open the data analysis tool (see instructions above)\n- Type the data unit of measure under \"What's the data unit of measure?\""]
[null,null,"- Click on the button under \"Select the data you want to analyse\" and select the data to be analised. Data must be positioned on a single column"]
[null,null,"- Click on the button under \"Select the cell where you want the results to be located\" and select a single cell in the spreadsheet\n- Click on \"OK\""]
[null,"How to customise which results to print at the end of the analysis","- Open the data analysis tool (see instructions above)\n- Click on \"Options\"\n- Tick the checkboxes of the analysis that are to be printed\n- Click on \"OK\""]
[null,"How to customise the frequency distribution calculation","- Open the data analysis tool (see instructions above)\n- Click on \"Options\"\n- Verify that the tick next to the \"Analysis\" checkbox is active"]
[null,null,"- Click on \"Manual intervals\"\n- Type the interval Max value, Min value and select the number of intervals that will be calculated"]
[]
[null,"Terms of use"]
[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,"Disclaimer"]
[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,"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 above)."]
[]
[null,"Version history"]
[null,"1.0   -   09/03/2018","First release"]
[null,"1.1   -   07/04/2018","Added welcome page"]
[null,"1.2   -   20/04/2018","Added internet connection check"]
[null,"1.3   -   28/05/2018","Added Excel 365 compatibility\nAdded Windows 10 x64 compatibility"]
[null,"1.4   -   08/06/2018","Added automated % formatting"]
[]
[null,"Copyright"]
[null,"EnginExcel, All rights reserved"]

{"sheet":"Data analysis","index":1,"n_rows":206,"n_cols":5,"rows_kept":206,"cut":false,"hidden":false,"merged":[[0,4,2,13]]}
[null,null,null,null,"INSERT TITLE HERE"]
[]
[]
[]
[null,"Data"]
[null,1.003180573139794]
[null,1.3277848708464515]
[null,1.4974000020517566]
[null,1.7614795799038823]
[null,1.9809245939377156]
[null,2.1594484944479753]
[null,2.2517669117014893]
[null,2.3404456247008523]
[null,2.4250325955821834]
[null,2.5080014746869974]
[null,2.580636861377001]
[null,2.5196500148863699]
[null,2.5592902134860451]
[null,2.5320036632504843]
[null,2.3867717929641472]
[null,2.207155987589184]
[null,2.2021922615699476]
[null,1.954275579517786]
[null,1.8772973309077063]
[null,1.7405368007833821]
[null,1.6054611720902787]
[null,1.3971238477261059]
[null,1.4134012005307706]
[null,1.2572192350144995]
[null,1.1190739389392308]
[null,1.1486772711419975]
[null,1.1288707899363866]
[null,1.080216829140042]
[null,1.0177066118631695]
[null,1.1260468792164979]
[null,1.1368636521192446]
[null,1.2444894601129708]
[null,1.3663708245565855]
[null,1.6113561615306566]
[null,1.6616772779352396]
[null,1.9295954699423985]
[null,2.0166748725060932]
[null,2.2114955390285385]
[null,2.2971035082054727]
[null,2.393780699964116]
[null,2.5661256107758397]
[null,2.7343738462661187]
[null,2.7189551596848007]
[null,2.7169498323187264]
[null,2.757629851486513]
[null,2.7144321912324738]
[null,2.7326559601930702]
[null,2.6929797524108308]
[null,2.5078370389574118]
[null,2.3840690516724217]
[null,2.2346226245144161]
[null,2.0480144085080845]
[null,1.8616263068885106]
[null,1.6284669550894353]
[null,1.3977293312534982]
[null,1.112757175866256]
[null,0.87360970103822688]
[null,0.72821609790047082]
[null,0.53407939901247581]
[null,0.35794993291514399]
[null,0.26753100153220155]
[null,0.12008890962628205]
[null,3.4520020324973033E-2]
[null,-0.14716570711446897]
[null,-7.148489457533802E-2]
[null,-0.1220854288429214]
[null,-0.15884708134175407]
[null,-0.11351583620506522]
[null,-2.6023615493853236E-2]
[null,0.15609379574016158]
[null,0.18472166662747275]
[null,0.42445367595007899]
[null,0.48377732075356877]
[null,0.60966675118032287]
[null,0.69600043194593364]
[null,0.83031427234520039]
[null,0.97651340922732754]
[null,1.134312210493051]
[null,1.0585124180845629]
[null,1.1418648879885887]
[null,1.2669740198237149]
[null,1.2404779965547581]
[null,1.1991360632536034]
[null,1.0804120090126181]
[null,0.98059884856518831]
[null,0.89189988352233252]
[null,0.70246919829893895]
[null,0.57415081245152733]
[null,0.36084639460838053]
[null,0.20247902977486784]
[null,0.11112749210524232]
[null,-0.12984821188267776]
[null,-0.18970618794724672]
[null,-0.34256378644983509]
[null,-0.5596608126921867]
[null,-0.69611066415894585]
[null,-0.81470801518983893]
[null,-0.81660031229144325]
[null,-0.82179651195644654]
[null,-0.86274393658837034]
[null,-0.82000881622878219]
[null,-0.77636214660223823]
[null,-0.52955616895018676]
[null,-0.51134290541991734]
[null,-0.3072368493055227]
[null,-0.18184381655004173]
[null,0.11185013068249233]
[null,0.3097614265161166]
[null,0.55934970813699525]
[null,0.72750581559309957]
[null,0.90605400711685347]
[null,1.1868381918749609]
[null,1.2587081704594216]
[null,1.4922503823769135]
[null,1.6510422420123847]
[null,1.685896836014479]
[null,1.9164627915103127]
[null,1.923642606660513]
[null,1.9776941371118104]
[null,1.9270798253617083]
[null,2.0048755687629733]
[null,1.9434146409417172]
[null,1.8536603643889142]
[null,1.7978253551991172]
[null,1.6957578157458075]
[null,1.466519452163737]
[null,1.4132670243972527]
[null,1.2688905296725055]
[null,1.1106303337983883]
[null,1.0722369136274128]
[null,0.92978443535978106]
[null,0.82878031021388909]
[null,0.79629517567740382]
[null,0.82741815921055284]
[null,0.68738138332943788]
[null,0.75607460848359653]
[null,0.79666012782901197]
[null,0.87705932251585206]
[null,1.06585840261556]
[null,1.2046858485283307]
[null,1.3558570553081919]
[null,1.3974400142820964]
[null,1.6861620715080607]
[null,1.8788769667327958]
[null,1.9979671827963275]
[null,2.1594896456026875]
[null,2.4593822954375284]
[null,2.6363085710008942]
[null,2.6821906780580735]
[null,2.8136575281106362]
[null,2.8861897861608443]
[null,2.9539273759091405]
[null,3.0682923491459837]
[null,3.0834972627456825]
[null,2.9783655957354012]
[null,2.9343005679175289]
[null,2.81803464155522]
[null,2.819708975811027]
[null,2.5638908334847499]
[null,2.4809721561695661]
[null,2.2524652917438099]
[null,2.1350139053444366]
[null,1.8941996841950668]
[null,1.6137054318492081]
[null,1.4100185243523018]
[null,1.3357042833504451]
[null,1.1683395438630431]
[null,0.88734349081647668]
[null,0.82590447206853224]
[null,0.66959882977543761]
[null,0.57686052717267355]
[null,0.51353211902286056]
[null,0.52168260595015903]
[null,0.44806395021760859]
[null,0.57014750590105634]
[null,0.63402788513269082]
[null,0.67067075712033286]
[null,0.75697737542679155]
[null,0.77240231542585147]
[null,0.88473388057487679]
[null,1.05946670747496]
[null,1.255905876905794]
[null,1.3245781682906781]
[null,1.4652137216974872]
[null,1.4803639734057241]
[null,1.6068863011005243]
[null,1.6225631289400115]
[null,1.6160657752210663]
[null,1.6611021078695081]
[null,1.6342613528104866]
[null,1.5579395788760915]
[null,1.5422348366633274]
[null,1.3625456181480655]
[null,1.1470950023583915]
[null,0.97834968860090754]
[null,0.8500302087433137]
[null,0.67996555966039551]
[null,0.49873836338329824]
[null,0.32857056060841516]
[null,4.9061607406360314E-2]
[null,-7.2279653356737805E-2]

{"sheet":"WelcomePage","index":2,"n_rows":50,"n_cols":3,"rows_kept":50,"cut":false,"hidden":true,"merged":[[4,1,4,6],[11,1,11,6],[21,1,21,6]]}
[]
[]
[]
[]
[null,"COUNTERS"]
[]
[null,"OpenedTimes",1]
[null,"NotShowAgain",false]
[]
[]
[]
[null,"MESSAGES RELATED TO SPREADSHEET"]
[]
[null,"SpreadsheetName"]
[null,"Excel data analysis"]
[]
[null,"VideoLink"]
[null,"https://youtu.be/u3bf15oRtBM"]
[]
[]
[]
[null,"MESSAGES VALID FOR ALL SPREADSHEETS"]
[]
[null,"WelcomeText"]
[null,"Thanks for downloading EnginExcel free material."]
[null,{"$f":"\"A quick introductory video on \"  & SpreadsheetName &  \" main functionalities is linked below.\"","v":"A quick introductory video on Excel data analysis main functionalities is linked below."}]
[]
[null,"ButtonText"]
[null,"Introductory video"]
[]
[null,"FreeMaterialText"]
[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,"ButtonText2"]
[null,"Open subscription page"]
[]
[null,"FreeMaterialLink"]
[null,"http://enginexcel.com/newsletter"]
[]
[null,"ReminderText1"]
[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,"ReminderText2"]
[null,"EnginExcel provides consultancy to develop customised spreadsheets for Mechanical Engineers and Project Managers using Microsoft Excel and Visual Basic for Applications (VBA)."]
[]
[null,"ButtonText3"]
[null,"See how I can help you"]
[]
[null,"ServicesLink"]
[null,"http://enginexcel.com/what-i-do"]