{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Input data","Scenarios","Result details","Sizing check","Notes","Version History","h1","h2","Links"],"not_rendered":{"charts":5,"images":15,"macros":1,"external_links":1,"defined_names":104,"comments":2,"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":"Input data","index":0,"n_rows":36,"n_cols":29,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,4,0,6],[32,1,32,3],[33,1,33,3],[34,1,34,3],[35,1,35,3],[14,1,14,2]]}
[{"$f":"\"            Dynatrace 7.1 Deployment Sizing Calculator Version \" &INDEX('Version History'!A:A,COUNTA('Version History'!A:A))","v":"            Dynatrace 7.1 Deployment Sizing Calculator Version 1.8.7"},null,null,null,{"$f":"INDEX('Version History'!C:C,COUNTA('Version History'!C:C))","v":"2018-03-28"}]
["Please select the used technologies:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Type",null,"Measures","Weighting","total measures","Collector weight","Agents"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Java",null,150,400,{"$f":"AC3*Y3","v":75000},{"$f":"AC3*'Result details'!$I$29/'Input data'!Z3","v":500},{"$f":"IF(javaAgent=FALSE,0,$B$10)","v":500}]
[null,true,null,false,null,false,null,false,null,false,null,false,null,false,null,false,null,false,null,false,null,null,".NET",null,{"$f":"23+Y10","v":58},250,{"$f":"Y4*AC4","v":0},{"$f":"AC4*'Result details'!$I$30/'Input data'!Z4","v":0},{"$f":"IF(dotnetAgent=FALSE,0,$D$10+$D$11)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"App pools",null,{"$f":"Y8","v":43},null,{"$f":"D12*Y5","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PHP",null,0,250,{"$f":"Y6*H10","v":0},{"$f":"AC6*'Result details'!I31/'Input data'!Z6","v":0},{"$f":"IF(phpAgent=FALSE,0,$H$10)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Native",null,null,1000,{"$f":"0","v":0},{"$f":"AC7*'Result details'!I32/'Input data'!Z7","v":0},{"$f":"IF(nativeAgent=FALSE,0,$T$10)","v":0}]
[null,"Java",null,".NET",null,"Webserver (Apache, IIS, etc.)",null,"PHP",null,"Node.js",null,"Host Monitoring",null,"Database",null,"Mainframe",null,"MessageBroker",null,"Native",null,null,"Web server",null,{"$f":"Y10+8","v":43},500,{"$f":"AC8*Y8","v":0},{"$f":"AC8*'Result details'!I33/'Input data'!Z8","v":0},{"$f":"IF(webserverAgent=FALSE,0,($F$10+$F$11))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Message broker",null,{"$f":"Y10","v":35},100,{"$f":"Y9*AC9","v":0},{"$f":"AC9*'Result details'!I34/'Input data'!Z9","v":0},{"$f":"IF(messageBrokerAgent=FALSE,0,$R$10)","v":0}]
["Number of agents/processes (for .NET IIS w3wp worker processes)?",500,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,"Host",null,35,1000,{"$f":"AC10*Y10","v":0},{"$f":"AC10*'Result details'!I35/'Input data'!Z10","v":0},{"$f":"IF(hostAgent=FALSE,0,$L$10)","v":0}]
[{"$f":"IF(OR(dotnetAgent,webserverAgent),\"Total number of non-IIS .NET instances?\",\"\")","v":""},null,null,0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mainframe",null,0,250,{"$f":"Y11*AC11","v":0},{"$f":"AC11*'Result details'!I36/'Input data'!Z11","v":0},{"$f":"IF(mainframeAgent=FALSE,0,$P$10)","v":0}]
[{"$f":"IF(dotnetAgent,\"Total number of app pools across all servers?\",\"\")","v":""},null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Node.js",null,0,500,{"$f":"Y12*AC12","v":0},{"$f":"AC12*'Result details'!I37/'Input data'!Z12","v":0},{"$f":"IF(nodeAgent=FALSE,0,$J$10)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Database",null,16,500,{"$f":"Y13*AC13","v":0},{"$f":"AC13*'Result details'!I38/'Input data'!Z13","v":0},{"$f":"IF(databaseAgent=FALSE,0,$N$10)","v":0}]
["Scenario:"]
["Do you want to capture transactions only from server side, users or both?","Server side & UEM"]
["How many System Profiles are planned for your enviroment? ",5]
[]
["Server load:"]
[{"$f":"IF(scenario=\"UEM only\",\"How many visits are handled from the datacenter?\",\"Transactions (server side requests, user actions) handled from the datacenter?\")","v":"Transactions (server side requests, user actions) handled from the datacenter?"},{"$f":"5000000","v":5000000},{"$f":"IF(scenario=\"UEM only\",\"visits/day\",\"transactions/day\")","v":"transactions/day"}]
["What is the average number of nodes per transaction?",100,"nodes"]
["How high is the max. peak factor (Black Friday, X-Mas, etc.)?",3]
["During which time do you assume the load? From","08:00:00","to","20:00:00",{"$f":"ROUNDUP(endTime-startTime,2)","v":0.5},"hours"]
[null,null,{"$f":"IF(B23=TRUE,TIMEVALUE(TIMEVALUE(\"00:00 AM\"))-startTime,\"\")","v":""}]
["User Experience Monitoring:"]
["Estimated average number of user actions (clicks, wipes, etc.) per visit?",10,{"$f":"IF(staticResourcesPerDay<>numberOfTransactions*numberOfEstimatedUserActions,TRUE,FALSE)","v":true}]
[{"$f":"\"Transactions caused by the estimated avg. number of \"&numberOfStaticResources&\" static resources?\"","v":"Transactions caused by the estimated avg. number of 8 static resources?"},{"$f":"numberOfTransactions*numberOfStaticResources","v":40000000},"transactions/day"]
["How many max. concurrent visits do you have?",10000,"visits"]
[]
["Storage:"]
["How long do you want to store the raw data (PurePaths, etc.) on your disk?",7,"days"]
[]
["Recommended deployment size:",null,null,null,null,null,null,null,null,null,"OnPrem","Result"]
["Based on your sizing data, you have a",{"$f":"HYPERLINK(VLOOKUP(K33,Links!A2:B9,2,TRUE),K33)","v":"Large"},null,null,"size deployment.",null,null,null,null,null,{"$f":"IF(L33,\"No sizing\",Scenarios!F25)","v":"Large"},{"$f":"'Result details'!P39","v":false}]
[{"$f":"\"Based on a peak value of \" &peakFactorInput&\", you have a\"","v":"Based on a peak value of 3, you have a"},{"$f":"HYPERLINK(VLOOKUP(K34,Links!A2:B9,2,TRUE),K34)","v":"Large"},null,null,"size deployment.",null,null,null,null,null,{"$f":"IF(L34,\"No sizing\",Scenarios!F26)","v":"Large"},{"$f":"'Result details'!Q39","v":false}]
["Based on your sizing data, you have a",{"$f":"HYPERLINK(VLOOKUP(K35,Links!A2:B9,2,TRUE),K35)","v":"Large"},null,null,"size deployment with UEM.",null,null,null,null,null,{"$f":"IF(L35,\"No sizing\",Scenarios!G25)","v":"Large"},{"$f":"'Result details'!R39","v":false}]
[{"$f":"\"Based on a peak value of \" &peakFactorInput&\", you have a\"","v":"Based on a peak value of 3, you have a"},{"$f":"HYPERLINK(VLOOKUP(K36,Links!A2:B9,2,TRUE),K36)","v":"Large"},null,null,"size deployment with UEM.",null,null,null,null,null,{"$f":"IF(L36,\"No sizing\",Scenarios!G26)","v":"Large"},{"$f":"'Result details'!S39","v":false}]

{"sheet":"Scenarios","index":1,"n_rows":60,"n_cols":15,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
["Maximums"]
[null,null,"Demo","Small","Medium","Large","XLarge","XXLarge","XXXLarge"]
[null,"tps",{"$f":"MAX(C39,C40)","v":330},{"$f":"MAX(D39,D40)","v":640},3300,7600,12600,14400,16400]
[null,"Java/.NET agents",5,10,250,750,2000,2000,2000]
[null,"total agents",20,30,300,1000,2500,2500,2500]
[null,"system profiles",1,1,5,25,100,100,100]
[null,"measures",1000,5000,50000,200000,{"$f":"'Result details'!O11","v":600000},{"$f":"'Result details'!O11","v":600000},{"$f":"'Result details'!O11","v":600000}]
[null,"nps",{"$f":"MAX(C50,C51)","v":15000},{"$f":"MAX(D50,D51)","v":30000},150000,350000,650000,850000,950000]
[null,"collectors",1,1,4,10,60,60,60]
[null,"concurrent visits",{"$f":"F10/25","v":2400},{"$f":"F10/15","v":4000},{"$f":"F10/2.5","v":24000},{"$f":"G10*0.6","v":60000},100000,150000,200000]
[]
["Input sizing"]
[{"$f":"scenario","v":"Server side & UEM"},null,null,{"$f":"IF(scenario<>\"UEM only\",\"w/o UEM\",\"\")","v":"w/o UEM"},{"$f":"IF(scenario<>\"Server side only\",\"w/ UEM\",\"\")","v":"w/ UEM"},{"$f":"IF(scenario<>\"UEM only\",\"w/o UEM\",\"\")","v":"w/o UEM"},{"$f":"IF(scenario<>\"Server side only\",\"w/ UEM\",\"\")","v":"w/ UEM"},null,null,{"$f":"IF(scenario<>\"UEM only\",\"w/o UEM\",\"\")","v":"w/o UEM"},{"$f":"IF(scenario<>\"Server side only\",\"w/ UEM\",\"\")","v":"w/ UEM"},{"$f":"IF(scenario<>\"UEM only\",\"w/o UEM\",\"\")","v":"w/o UEM"},{"$f":"IF(scenario<>\"Server side only\",\"w/ UEM\",\"\")","v":"w/ UEM"},{"$f":"IF(scenario<>\"UEM only\",\"w/o UEM\",\"\")","v":"w/o UEM"},{"$f":"IF(scenario<>\"Server side only\",\"w/ UEM\",\"\")","v":"w/ UEM"}]
[null,null,"tps",{"$f":"IF(scenario<>\"UEM only\",ROUND(tps,2),\"\")","v":115.74},{"$f":"IF(scenario<>\"Server side only\",ROUND(tpsUEM,2),\"\")","v":1041.67},{"$f":"IF(scenario<>\"UEM only\",IF(J14>7,\"No sizing\",INDEX($C$32:$I$32,1,J14)),\"\")","v":"Demo"},{"$f":"IF(scenario<>\"Server side only\",IF(K14>7,\"No sizing\",INDEX($C$32:$I$32,1,K14)),\"\")","v":"Medium"},null,null,{"$f":"IF(scenario<>\"UEM only\",IFERROR(MATCH(D14-1,C39:I39),0)+1,\"\")","v":1},{"$f":"IF(scenario<>\"Server side only\",IFERROR(MATCH(E14-1,C40:I40),0)+1,\"\")","v":3},{"$f":"IF(F14=\"No sizing\",TRUE,FALSE)","v":false},{"$f":"IF(G14=\"No sizing\",TRUE,FALSE)","v":false}]
[null,null,"peak tps",{"$f":"IF(scenario<>\"UEM only\",'Result details'!C14,\"\")","v":347.22222222222223},{"$f":"IF(scenario<>\"Server side only\",'Result details'!E14,\"\")","v":3125},{"$f":"IF(scenario<>\"UEM only\",IF(J15>7,\"No sizing\",INDEX($C$32:$I$32,1,J15)),\"\")","v":"Medium"},{"$f":"IF(scenario<>\"Server side only\",IF(K15>7,\"No sizing\",INDEX($C$32:$I$32,1,K15)),\"\")","v":"Medium"},null,null,{"$f":"IF(scenario<>\"UEM only\",IFERROR(MATCH(D15-1,C39:I39),0)+1,\"\")","v":3},{"$f":"IF(scenario<>\"Server side only\",IFERROR(MATCH(E15-1,C40:I40),0)+1,\"\")","v":3},false,false]
[null,null,"agents",{"$f":"IF(scenario<>\"UEM only\",agents,\"\")","v":500},{"$f":"IF(scenario<>\"Server side only\",agents,\"\")","v":500},{"$f":"IF(scenario<>\"UEM only\",IF(J16>7,\"No sizing\",INDEX($C$32:$I$32,1,J16)),\"\")","v":"Large"},{"$f":"IF(scenario<>\"Server side only\",IF(K16>7,\"No sizing\",INDEX($C$32:$I$32,1,K16)),\"\")","v":"Large"},null,null,{"$f":"IF(scenario<>\"UEM only\",IFERROR(MATCH(D16-1,C4:I4),0)+1,\"\")","v":4},{"$f":"IF(scenario<>\"Server side only\",IFERROR(MATCH(E16-1,C4:I4),0)+1,\"\")","v":4},false,false]
[null,null,"total agents",{"$f":"IF(scenario<>\"UEM only\",agents+agentsDBWebServer+hostAgents,\"\")","v":500},{"$f":"IF(scenario<>\"Server side only\",agents+agentsDBWebServer+hostAgents,\"\")","v":500},{"$f":"IF(scenario<>\"UEM only\",IF(J17>7,\"No sizing\",INDEX($C$32:$I$32,1,J17)),\"\")","v":"Large"},{"$f":"IF(scenario<>\"Server side only\",IF(K17>7,\"No sizing\",INDEX($C$32:$I$32,1,K17)),\"\")","v":"Large"},null,null,{"$f":"IF(scenario<>\"UEM only\",IFERROR(MATCH(D17-1,C5:I5),0)+1,\"\")","v":4},{"$f":"IF(scenario<>\"Server side only\",IFERROR(MATCH(E17-1,C5:I5),0)+1,\"\")","v":4},false,false]
[null,null,"system profiles",{"$f":"IF(scenario<>\"UEM only\",totalSystemProfiles,\"\")","v":5},{"$f":"IF(scenario<>\"Server side only\",totalSystemProfiles,\"\")","v":5},{"$f":"IF(scenario<>\"UEM only\",IF(J18>7,\"No sizing\",INDEX($C$32:$I$32,1,J18)),\"\")","v":"Medium"},{"$f":"IF(scenario<>\"Server side only\",IF(K18>7,\"No sizing\",INDEX($C$32:$I$32,1,K18)),\"\")","v":"Medium"},null,null,{"$f":"IF(scenario<>\"UEM only\",IFERROR(MATCH(D18-1,C6:I6),0)+1,\"\")","v":3},{"$f":"IF(scenario<>\"Server side only\",IFERROR(MATCH(E18-1,C6:I6),0)+1,\"\")","v":3},false,false]
[null,null,{"$f":"\"max. tps for \" & totalSystemProfiles & \" profiles\"","v":"max. tps for 5 profiles"},2792.3076923076928,2792.3076923076928,"Medium","Medium",null,null,null,null,false,false,{"$f":"IF(scenario<>\"UEM only\",VLOOKUP(totalSystemProfiles,$B$55:$I$60,MATCH(IF(F18=\"No sizing\",\"XLarge\",F18),$B$54:$I$54,0),FALSE),\"\")","v":2792.3076923076928},{"$f":"IF(scenario<>\"Server side only\",VLOOKUP(totalSystemProfiles,$B$55:$I$60,MATCH(IF(G18=\"No sizing\",\"XLarge\",G18),$B$54:$I$54,0),FALSE),\"\")","v":2792.3076923076928}]
[null,null,"measures",{"$f":"IF(scenario<>\"UEM only\",measures,\"\")","v":76000},{"$f":"IF(scenario<>\"Server side only\",measures,\"\")","v":76000},{"$f":"IF(scenario<>\"UEM only\",IF(J20>7,\"No sizing\",INDEX($C$32:$I$32,1,J20)),\"\")","v":"Large"},{"$f":"IF(scenario<>\"Server side only\",IF(K20>7,\"No sizing\",INDEX($C$32:$I$32,1,K20)),\"\")","v":"Large"},null,null,{"$f":"IF(scenario<>\"UEM only\",IFERROR(MATCH(D20-1,C7:I7),0)+1,\"\")","v":4},{"$f":"IF(scenario<>\"Server side only\",IFERROR(MATCH(E20-1,C7:I7),0)+1,\"\")","v":4},false,false]
[null,null,"nps",{"$f":"IF(scenario<>\"UEM only\",D14*B29,\"\")","v":11574},{"$f":"IF(scenario<>\"Server side only\",E14*C29,\"\")","v":19791.730000000003},{"$f":"IF(scenario<>\"UEM only\",IF(J21>7,\"No sizing\",INDEX($C$32:$I$32,1,J21)),\"\")","v":"Demo"},"Medium",null,null,{"$f":"IF(scenario<>\"UEM only\",IFERROR(MATCH(D21-1,C50:I50),0)+1,\"\")","v":1},{"$f":"IF(scenario<>\"Server side only\",IFERROR(MATCH(E21-1,C51:I51),0)+1,\"\")","v":3},false,false]
[null,null,"peak nps",{"$f":"IF(scenario<>\"UEM only\",D15*B29,\"\")","v":34722.222222222226},{"$f":"IF(scenario<>\"Server side only\",E15*C29,\"\")","v":59375},{"$f":"IF(scenario<>\"UEM only\",IF(J22>7,\"No sizing\",INDEX($C$32:$I$32,1,J22)),\"\")","v":"Medium"},"Large",null,null,{"$f":"IF(scenario<>\"UEM only\",IFERROR(MATCH(D22-1,C50:I50),0)+1,\"\")","v":3},{"$f":"IF(scenario<>\"Server side only\",IFERROR(MATCH(E22-1,C51:I51),0)+1,\"\")","v":4},false,false]
[null,null,"collectors",{"$f":"IF(scenario<>\"UEM only\",collectors,\"\")","v":2},{"$f":"IF(scenario<>\"Server side only\",collectors,\"\")","v":2},{"$f":"IF(scenario<>\"UEM only\",IF(J23>7,\"No sizing\",INDEX($C$32:$I$32,1,J23)),\"\")","v":"Medium"},"Medium",null,null,{"$f":"IF(scenario<>\"UEM only\",IFERROR(MATCH(D23-1,C9:I9),0)+1,\"\")","v":3},{"$f":"IF(scenario<>\"Server side only\",IFERROR(MATCH(E23-1,C9:I9),0)+1,\"\")","v":3},false,false]
[null,null,{"$f":"IF(scenario<>\"Server side only\",\"concurrent visits\",\"\")","v":"concurrent visits"},null,{"$f":"IF(scenario<>\"Server side only\",uemConcurrentVisits,\"\")","v":10000},null,"Medium",null,null,null,{"$f":"IF(scenario<>\"Server side only\",IFERROR(MATCH(E24-1,C10:I10),0)+1,\"\")","v":3},null,{"$f":"IF(G24=\"No sizing\",TRUE,FALSE)","v":false}]
[null,"Scenario ",null,null,null,{"$f":"IF(scenario<>\"UEM only\",IF(J25>7,\"No sizing\",INDEX($C$32:$I$32,1,J25)),\"\")","v":"Large"},"Large",null,null,{"$f":"IF(scenario<>\"UEM only\",MAX(J14,J16,J17,J18,J19,J20,J21,J23),\"\")","v":4},{"$f":"IF(scenario<>\"Server side only\",MAX(K14,K16,K17,K18,K19,K20,K21,K23,K24),\"\")","v":4},{"$f":"IF(F25=\"No sizing\",TRUE,FALSE)","v":false},{"$f":"IF(G25=\"No sizing\",TRUE,FALSE)","v":false}]
[null,"Scenario Peak",null,null,null,{"$f":"IF(scenario<>\"UEM only\",IF(J26>7,\"No sizing\",INDEX($C$32:$I$32,1,J26)),\"\")","v":"Large"},"Large",null,null,{"$f":"IF(scenario<>\"UEM only\",MAX(J14:J23),\"\")","v":4},{"$f":"IF(scenario<>\"Server side only\",MAX(K14:K24),\"\")","v":4},{"$f":"IF(F26=\"No sizing\",TRUE,FALSE)","v":false},{"$f":"IF(G26=\"No sizing\",TRUE,FALSE)","v":false}]
[]
[null,{"$f":"IF(scenario<>\"UEM only\",\"w/o UEM\",\"\")","v":"w/o UEM"},{"$f":"IF(scenario<>\"Server side only\",\"w/ UEM\",\"\")","v":"w/ UEM"}]
["Avg. PP node length",{"$f":"IF(scenario<>\"UEM only\",nodes,\"\")","v":100},{"$f":"IF(scenario<>\"Server side only\",nodesUEM,\"\")","v":19},null,null,{"$f":"IF(scenario<>\"UEM only\",IF(B29>'Result details'!O14,TRUE,FALSE),\"\")","v":false}]
[]
["Max. tps per nodes"]
[null,"nodes","Demo","Small","Medium","Large","XLarge","XXLarge","XXXLarge"]
[null,5,550,1100,5500,13000,22000,24000,28000]
[null,10,450,850,4500,10000,16500,18000,20000]
[null,25,250,500,2500,6000,10000,12000,14000]
[null,50,200,450,2200,5200,7500,9500,10500]
[null,100,150,300,1500,3500,6500,8500,9500]
[null,1000,15,30,150,350,450,550,600]
[{"$f":"IF(scenario<>\"UEM only\",\"Avg. PP length w/o UEM\",\"\")","v":"Avg. PP length w/o UEM"},{"$f":"IF(scenario<>\"UEM only\",nodes,\"\")","v":100},{"$f":"IF(scenario<>\"UEM only\",'h2'!C9,\"\")","v":150},{"$f":"IF(scenario<>\"UEM only\",'h2'!E9,\"\")","v":300},{"$f":"IF(scenario<>\"UEM only\",'h2'!G9,\"\")","v":1500},{"$f":"IF(scenario<>\"UEM only\",'h2'!I9,\"\")","v":3500},{"$f":"IF(scenario<>\"UEM only\",'h2'!K9,\"\")","v":6500},{"$f":"IF(scenario<>\"UEM only\",'h2'!M9,\"\")","v":8500},{"$f":"IF(scenario<>\"UEM only\",'h2'!O9,\"\")","v":9500}]
[{"$f":"IF(scenario<>\"Server side only\",\"Avg. PP length w/ UEM\",\"\")","v":"Avg. PP length w/ UEM"},{"$f":"IF(scenario<>\"Server side only\",nodesUEM,\"\")","v":19},{"$f":"IF(scenario<>\"Server side only\",'h2'!C10,\"\")","v":330},{"$f":"IF(scenario<>\"Server side only\",'h2'!E10,\"\")","v":640},{"$f":"IF(scenario<>\"Server side only\",'h2'!G10,\"\")","v":3300},{"$f":"IF(scenario<>\"Server side only\",'h2'!I10,\"\")","v":7600},{"$f":"IF(scenario<>\"Server side only\",'h2'!K10,\"\")","v":12600},{"$f":"IF(scenario<>\"Server side only\",'h2'!M10,\"\")","v":14400},{"$f":"IF(scenario<>\"Server side only\",'h2'!O10,\"\")","v":16400}]
[]
["Nodes per second"]
[null,"nodes","Demo","Small","Medium","Large","XLarge","XXLarge","XXXLarge"]
[null,5,{"$f":"$B$33*C33","v":2750},{"$f":"$B$33*D33","v":5500},{"$f":"$B$33*E33","v":27500},{"$f":"$B$33*F33","v":65000},{"$f":"$B$33*G33","v":110000},{"$f":"$B$33*H33","v":120000},140000]
[null,10,{"$f":"$B$34*C34","v":4500},{"$f":"$B$34*D34","v":8500},{"$f":"$B$34*E34","v":45000},{"$f":"$B$34*F34","v":100000},{"$f":"$B$34*G34","v":165000},{"$f":"$B$34*H34","v":180000},200000]
[null,25,{"$f":"$B$35*C35","v":6250},{"$f":"$B$35*D35","v":12500},{"$f":"$B$35*E35","v":62500},{"$f":"$B$35*F35","v":150000},{"$f":"$B$35*G35","v":250000},{"$f":"$B$35*H35","v":300000},350000]
[null,50,{"$f":"$B$36*C36","v":10000},{"$f":"$B$36*D36","v":22500},{"$f":"$B$36*E36","v":110000},{"$f":"$B$36*F36","v":260000},{"$f":"$B$36*G36","v":375000},{"$f":"$B$36*H36","v":475000},525000]
[null,100,{"$f":"$B$37*C37","v":15000},{"$f":"$B$37*D37","v":30000},{"$f":"$B$37*E37","v":150000},{"$f":"$B$37*F37","v":350000},{"$f":"$B$37*G37","v":650000},{"$f":"$B$37*H37","v":850000},950000]
[null,1000,{"$f":"$B$38*C38","v":15000},{"$f":"$B$38*D38","v":30000},{"$f":"$B$38*E38","v":150000},{"$f":"$B$38*F38","v":350000},{"$f":"$B$38*G38","v":450000},{"$f":"$B$38*H38","v":550000},600000]
[{"$f":"IF(scenario<>\"UEM only\",\"Avg. PP length w/o UEM\",\"\")","v":"Avg. PP length w/o UEM"},{"$f":"IF(scenario<>\"UEM only\",nodes,\"\")","v":100},{"$f":"IF(scenario<>\"UEM only\",'h2'!R9,\"\")","v":15000},{"$f":"IF(scenario<>\"UEM only\",'h2'!T9,\"\")","v":30000},{"$f":"IF(scenario<>\"UEM only\",'h2'!V9,\"\")","v":150000},{"$f":"IF(scenario<>\"UEM only\",'h2'!X9,\"\")","v":350000},{"$f":"IF(scenario<>\"UEM only\",'h2'!Z9,\"\")","v":650000},{"$f":"IF(scenario<>\"UEM only\",'h2'!AB9,\"\")","v":850000},{"$f":"IF(scenario<>\"UEM only\",'h2'!AD9,\"\")","v":950000}]
[{"$f":"IF(scenario<>\"Server side only\",\"Avg. PP length w/ UEM\",\"\")","v":"Avg. PP length w/ UEM"},{"$f":"IF(scenario<>\"Server side only\",nodesUEM,\"\")","v":19},{"$f":"IF(scenario<>\"Server side only\",'h2'!R10,\"\")","v":5550},{"$f":"IF(scenario<>\"Server side only\",'h2'!T10,\"\")","v":10900},{"$f":"IF(scenario<>\"Server side only\",'h2'!V10,\"\")","v":55500},{"$f":"IF(scenario<>\"Server side only\",'h2'!X10,\"\")","v":130000},{"$f":"IF(scenario<>\"Server side only\",'h2'!Z10,\"\")","v":216000},{"$f":"IF(scenario<>\"Server side only\",'h2'!AB10,\"\")","v":252000},{"$f":"IF(scenario<>\"Server side only\",'h2'!AD10,\"\")","v":290000}]
[]
[{"$f":"\"TPS for \"&totalSystemProfiles&\" profiles and \"&IF(scenario=\"Server side only\",ROUND(nodes,0),ROUND(nodesUEM,0) &\" nodes\") & \" nodes\"","v":"TPS for 5 profiles and 19 nodes nodes"}]
[null,"profiles","Demo","Small","Medium","Large","XLarge","XXLarge","XXXLarge"]
[null,1,{"$f":"IF(scenario=\"Server side only\",C39,C40)","v":330},640,3300,7600,12600,14400,16400]
[null,5,null,null,{"$f":"E55*'h2'!L16","v":2792.3076923076928},{"$f":"F55*'h2'!M16","v":6430.7692307692305},{"$f":"G55*'h2'!N16","v":10661.538461538461},{"$f":"H55*'h2'!O16","v":13552.941176470587},{"$f":"I55*'h2'!P16","v":15536.842105263157}]
[null,10,null,null,null,{"$f":"F56*'h2'!M17","v":5846.1538461538457},{"$f":"G56*'h2'!N17","v":9692.3076923076915},{"$f":"H56*'h2'!O17","v":11858.823529411764},{"$f":"I56*'h2'!P17","v":14673.684210526315}]
[null,25,null,null,null,{"$f":"F57*'h2'!M18","v":5846.1538461538457},{"$f":"G57*'h2'!N18","v":9692.3076923076915},{"$f":"H57*'h2'!O18","v":10164.705882352941},{"$f":"I57*'h2'!P18","v":12084.210526315788}]
[null,50,null,null,null,null,{"$f":"G58*'h2'!N19","v":8723.076923076922},{"$f":"H58*'h2'!O19","v":9317.6470588235279},{"$f":"I58*'h2'!P19","v":11221.052631578947}]
[null,100,null,null,null,null,{"$f":"G59*'h2'!N20","v":7753.8461538461524},{"$f":"H59*'h2'!O20","v":8470.5882352941153},{"$f":"I59*'h2'!P20","v":10357.894736842105}]

{"sheet":"Result details","index":2,"n_rows":45,"n_cols":19,"rows_kept":45,"cut":false,"hidden":false,"merged":[[0,17,0,18],[0,0,0,4],[0,7,0,10],[0,12,0,13],[0,15,0,16]]}
["Sizing Computations",null,null,null,null,null,null,"Defaults",null,null,null,null,"Size calculations",null,"Maximum values","Issue flags w/o UEM",null,"Issue flags w UEM"]
[null,null,null,null,null,null,null,null,"Value","Default"]
[null,"w/o UEM","w/ UEM",null,null,null,null,"PurePath percentage",1,1,null,null,"Agents (incl. CLRs):"]
["Average analyzed transactions per Day",{"$f":"numberOfTransactions*ppPercentage","v":5000000},{"$f":"IF(scenario=\"Server side only\",0,staticResourcesPerDay)","v":40000000},null,null,null,null,"UEM visit percentage",1,1,null,null,{"$f":"IF(scenario=\"UEM only\",0,'Input data'!AC3+'Input data'!AC4+'Input data'!AC6+'Input data'!AC7+'Input data'!AC9+'Input data'!AC11+'Input data'!AC12)","v":500},null,{"$f":"Scenarios!G4","v":2000},{"$f":"IF(agents>O4,TRUE,FALSE)","v":false}]
["Total PurePath transactions per Day (incl. UEM)",null,{"$f":"IF(scenario=\"Server side only\",0,B4+staticResourcesPerDay)","v":45000000},null,null,null,null,"Average node size per PurePath UEM only",{"$f":"numberOfEstimatedUserActions","v":10},10,null,null,"Agents (DB, Web server)"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(scenario=\"UEM only\",0,'Input data'!AC8+'Input data'!AC13)","v":0},null,2000,{"$f":"IF(agentsDBWebServer>O6,TRUE,FALSE)","v":false}]
["Average Instrumented nodes per PurePath",{"$f":"averagePPNodeSize*B4/B4","v":100},{"$f":"IF(scenario=\"Server side only\",0,IF(scenario=\"UEM only\",I5,(averagePPNodeSize*B4+numberOfEstimatedUserActions*totalTransactionswithUEM)/(B4+totalTransactionswithUEM)))","v":19},null,null,null,null,"Estimated average number of static resources per transaction:",8,{"$f":"40/5","v":8},null,null,"Host Agents:"]
["Cyclic measures",{"$f":"M11+1000","v":76000},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(scenario=\"UEM only\",0,'Input data'!AC10)","v":0},null,4000,{"$f":"IF(hostAgents>O8,TRUE,FALSE)","v":false}]
["Total hours",{"$f":"loadDistribution*24","v":12},null,null,null,null,null,"Autosensors:"]
[null,null,null,null,null,null,null,"Average path duration [ms]:",{"$f":"20000*1%+1000*20%+100*50%+10*29%","v":452.9},1000,null,null,"Cyclic Measures generated by Agents:"]
[null,null,null,null,null,null,null,"Typical autosensor node size [bytes]:",20,20,null,null,{"$f":"IF(scenario=\"UEM only\",0,SUM('Input data'!AA3:AA13))","v":75000},"Max. Measures",600000,{"$f":"(measures>O11)","v":false}]
[null,"Avg w/o UEM","Peak w/o UEM","Avg w/ UEM","Peak w/ UEM",null,null,"Stack trace rate [ms]:",100,100]
["Transactions per Hour",{"$f":"B4/loaddistributioninhours","v":416666.66666666669},{"$f":"B13*peakFactorInput","v":1250000},{"$f":"C5/loaddistributioninhours","v":3750000},{"$f":"D13*peakFactorInput","v":11250000},null,null,null,null,null,null,null,"PP node size"]
["Transactions per Second (tps)",{"$f":"B13/3600","v":115.74074074074075},{"$f":"C13/3600","v":347.22222222222223},{"$f":"D13/3600","v":1041.6666666666667},{"$f":"E13/3600","v":3125},null,null,"Network compression rate:",4,4,null,null,{"$f":"averagePPNodeSize","v":100},null,1000,{"$f":"IF(M14>O14,TRUE,FALSE)","v":false}]
["Nodes per Second (NPS)",{"$f":"B14*nodes","v":11574.074074074075},{"$f":"C14*nodes","v":34722.222222222226},{"$f":"D14*nodesUEM","v":19791.666666666668},{"$f":"E14*nodesUEM","v":59375}]
[null,null,null,null,null,null,null,"Typical node size [bytes]:",100,100,null,null,"Average node size [bytes]",null,{"$f":"Scenarios!I3","v":16400},{"$f":"(tps>O16)","v":false},{"$f":"(C14>O16)","v":false},{"$f":"(tpsUEM>Q16)","v":false},{"$f":"(E14>Q16)","v":false}]
[null,null,null,null,null,null,null,"Average attachment size [bytes]:",100,200,null,null,{"$f":"I16+I17*I18*(1-I19)","v":130},"Max. NPS",430000,{"$f":"(nps>O17)","v":false},{"$f":"(C15>O17)","v":false},{"$f":"(npsUEM>Q17)","v":false},{"$f":"(E15>Q17)","v":false}]
[null,null,null,null,null,null,null,"Percentage of nodes with attachments:",1,0.8]
["Bandwidth sizing",null,null,null,null,null,null,"Attachments cache factor:",0.7,0.2]
["Bandwidth normal [Mbit/sec]",{"$f":"ROUNDUP(B27*10,0)","v":15},{"$f":"ROUNDUP(SUM(M22:N22)*peakFactorInput/POWER(1024,2)*10,0)","v":44},null,null,null,null,"Block size to write [kb]",16,16]
["Bandwidth compressed [Mbit/sec]",{"$f":"ROUNDUP(SUM(M22:N22)/POWER(1024,2)*10/compression,1)","v":3.7},{"$f":"ROUNDUP(SUM(M22:N22)*peakFactorInput/POWER(1024,2)*10/compression,1)","v":10.9},null,null,null,null,null,null,null,null,null,"Transmitted PurePath node data [bytes/sec] w/o UEM"]
["Original values normal [Mbit/sec]",{"$f":"ROUNDUP(B13*8/3600/500,0)","v":2},{"$f":"ROUNDUP(C13*8/3600/500,0)","v":6},null,null,null,null,"Database overhead factor:",1.5,1.5,null,null,{"$f":"M17*nps","v":1504629.6296296297},{"$f":"tps*I10/I12*I11","v":10483.796296296296}]
[]
[null,null,null,null,null,null,null,"Measurements high period (=minutes) [days]:",14,14,null,null,"Transmitted PurePath node data [bytes/sec] w UEM"]
["PurePath Session Storage sizing",null,null,null,null,null,null,"Measurements medium period (=hours) [days]:",60,60,null,null,{"$f":"M17*npsUEM","v":2572916.666666667},{"$f":"tpsUEM*I10/I12*I11","v":94354.166666666686}]
["Session Storage [GB]",{"$f":"ROUNDUP(M28/POWER(1024,3),0)","v":854},null,null,null,null,null,"Measurements low period (=days) [days]:",{"$f":"365*5","v":1825},1825]
["Data written into the Session Storage [MB/sec]",{"$f":"SUM(M22:N22)/POWER(1024,2)","v":1.444924760747839},null,null,null,null,null,null,null,null,null,null,"Computed session storage [bytes] w/o UEM"]
["Estimated IOPS",{"$f":"(B27/I20)*1024","v":92.475184687861699},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M22:N22)*3600*24*storeRawData","v":916340600000.00012},null,{"$f":"2*POWER(1024,5)","v":2251799813685248},{"$f":"(M28>O28)","v":false},null,{"$f":"(M31>O28)","v":false}]
[null,null,null,null,null,null,null,"Agents per collector Java",400,400]
["Performance Warehouse sizing",null,null,null,null,null,null,"Agents per collector .NET",250,250,null,null,"Computed session storage [bytes] w UEM"]
["Performance Warehouse gross size [GB]",{"$f":"ROUNDUP(performanceWarehouse*I22/POWER(1024,3),0)","v":179},null,null,null,null,null,"Agents per collector PHP",400,400,null,null,{"$f":"SUM(M25:N25)*3600*24*storeRawData","v":1613165400000}]
["Average DB Measures per Second",{"$f":"(SUM(M36:N38)+SUM(M36:N37))/(3600*24)","v":2585.0555601851852},null,null,null,null,null,"Agents per collector Native",1000,1000]
[null,null,null,null,null,null,null,"Agents per collector Web server",500,500]
["Collector sizing",null,null,null,null,null,null,"Agents per collector MessageBroker",100,100,null,null,"Performance warehouse data per day:"]
["Estimated number of Collectors",{"$f":"ROUNDUP(SUM('Input data'!AB3:AB13)/I29,0)","v":2},null,null,null,null,null,"Agents per collector Host",1000,1000,null,null,56,566]
[null,null,null,null,null,null,null,"Agents per collector Mainframe",250,250,null,null,{"$f":"60*24*measures","v":109440000},0.2]
[null,null,null,"Legend:",null,null,null,"Agents per collector Node.js",500,500,null,null,{"$f":"24*measures","v":1824000},{"$f":"M37*N36","v":364800}]
[null,null,null,"Default parameter, only change if you have good reasons:",null,null,null,"Agents per collector Database",500,500,null,null,{"$f":"measures","v":76000},{"$f":"M38*N36","v":15200}]
[null,null,null,"Customer environment parameter, change to improve the estimates:",null,null,null,"Max. NPS per collector:",100000,100000,null,null,{"$f":"(M35*(measureHigh*M36+measureMedium*M37+measureLow*M38)+N35*(measureMedium*N37+measureLow*N38))","v":127786248000},null,"Sizing feasible? ",{"$f":"OR(flagMeasure,flagTps,flagNps,flagSession,flagTooManyAgents,flagTooManyagentsDBWebServer,flagTooManyHostAgents,flagPPnodeSize)","v":false},{"$f":"OR(flagMeasure,flagTpsPeak,flagNpsPeak,flagSession,flagTooManyAgents,flagTooManyagentsDBWebServer,flagTooManyHostAgents,flagPPnodeSize)","v":false},{"$f":"OR(flagMeasure,flagTpsUEM,flagNpsUEM,flagSessionUEM,flagTooManyAgents,flagTooManyagentsDBWebServer,flagTooManyHostAgents,flagPPnodeSize)","v":false},{"$f":"OR(flagMeasure,flagNpsUEMPeak,flagNpsUEMPeak,flagTooManyAgents,flagTooManyagentsDBWebServer,flagTooManyHostAgents,flagPPnodeSize,flagTpsUEMPeak,flagSessionUEM)","v":false}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Values to double check:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Time to complete a full 6GB session store file [sec]",{"$f":"IFERROR(6*1024/B27,0)","v":4252.1245167257675}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data written to session storage per minute [MB]",{"$f":"B27*60","v":86.695485644870345}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bandwidth [MB/sec]",{"$f":"M22/POWER(1024,2)","v":1.4349266334816262}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data written to performance warehouse per minute [MB]",{"$f":"ROUNDUP((M35*(M36*2+M37*2+M38)+N35*(N37*2+N38))/(24*60)/POWER(1024,2),3)","v":8.5350000000000001}]

{"sheet":"Sizing check","index":3,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,"Info"]
[null,null,null,null,null,null,"Warning"]
[null,null,null,null,null,null,"Problem"]
[]
[]
["Info","Link","The peak factor of 3 is the default. Please make sure that this value is correct"]

{"sheet":"Notes","index":4,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Note by","Date","Note"]
["Jon Doe","2016-03-03","Test note"]

{"sheet":"Version History","index":5,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Version","Performed by","Date","Actions"]
["0.1","Thorsten Roth","2014-11-07","fixed minor bugs"]
["0.2","Thorsten Roth","2014-12-05","Updated the KPIs to 6.1"]
["1","Thorsten Roth","2014-12-06","Updated URLs "]
["1.1","Thorsten Roth","2014-12-17","Fixed N/A for Small Environments, fixed minor bugs"]
["1.2","Thorsten Roth","2015-02-24","Scenario fix for NPS, consider peak values for size"]
["1.3","Thorsten Roth","2015-03-27","Increased Block size to 16kB (IOPS calculation)"]
["1.4","Thorsten Roth","2015-06-15","Updated KPIs for Collector"]
["1.5","Thorsten Roth","2016-02-24","Major updates for usability and 6.3 KPIs"]
["1.6","Thorsten Roth","2016-03-03","Fixed load distribution bug for charting, added drop down for time selection"]
["1.7","Thorsten Roth","2016-03-03","Fixed bug in .NET app pools and removed ASP.NET apps"]
["1.8","Thorsten Roth","2016-09-23","Health check, improved scenarios, updated KPIs, fixed minor bugs, etc."]
["1.8.1","Thorsten Roth","2016-09-27","Updated wrong TPS value, fixed minor bugs"]
["1.8.2","Thorsten Roth","2016-10-05","Wrong user action formular, fixed minor bugs"]
["1.8.3","Thorsten Roth","2016-10-19","SaaS scenario delivered wrong sizes"]
["1.8.4","Thorsten Roth","2017-01-04","Fixed missing reference for MacOS"]
["1.8.5","Thorsten Roth","2017-05-12","Updated guide with new KPIs and modified UEM contribution"]
["1.8.6","Thorsten Roth","2017-06-02","Fixed max. measure limit"]
["1.8.7","Thorsten Roth","2018-03-28","Updated KPIs for new version, removed SaaS offering, added new server sizes, etc."]

{"sheet":"h1","index":6,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,"Time","StartTime","EndTime","Position","Avg. Load w/o UEM",{"$f":"\"Peak load of \"&peakFactorInput& \" w/o UEM\"","v":"Peak load of 3 w/o UEM"},{"$f":"IF(scenario<>\"Server side only\",\"Avg. Load w/ UEM\",\"\")","v":"Avg. Load w/ UEM"},{"$f":"IF(scenario<>\"Server side only\",\"Peak load of \"&peakFactorInput& \" w/ UEM\",\"\")","v":"Peak load of 3 w/ UEM"}]
[1,1,null,null,"00:01:00",{"$f":"EXACT(E2,startTime)","v":false},{"$f":"EXACT(E2,endTime)","v":false},2,{"$f":"IF(AND(H2>=$F$28,H2<=$G$28),avgTransactionsWithPercentage/(loadDistribution*24),0)","v":0},{"$f":"I2*peakFactorInput","v":0},{"$f":"IF(AND(H2>=$F$28,H2<=$G$28),totalTransactionswithUEM/(loadDistribution*24),0)","v":0},{"$f":"K2*peakFactorInput","v":0}]
[0.5,0.9,null,null,"01:00:00",false,false,3,0,0,0,0]
[0.25,0.8,null,null,"02:00:00",false,false,4,0,0,0,0]
[0.1,0.7,null,null,"03:00:00",false,false,5,0,0,0,0]
[0.01,0.6,null,null,"04:00:00",false,false,6,0,0,0,0]
[1E-3,0.5,null,null,"05:00:00",false,false,7,0,0,0,0]
[1E-4,0.4,null,null,"06:00:00",false,false,8,0,0,0,0]
[1.0000000000000001E-5,0.3,null,null,"07:00:00",false,false,9,0,0,0,0]
[null,0.2,null,null,"08:00:00",true,false,10,416666.66666666669,1250000,3750000,11250000]
[null,0.1,null,null,"09:00:00",false,false,11,416666.66666666669,1250000,3750000,11250000]
[null,null,null,null,"10:00:00",false,false,12,416666.66666666669,1250000,3750000,11250000]
[null,null,null,null,"11:00:00",false,false,13,416666.66666666669,1250000,3750000,11250000]
[null,null,null,null,"12:00:00",false,false,14,416666.66666666669,1250000,3750000,11250000]
[null,null,null,null,"13:00:00",false,false,15,416666.66666666669,1250000,3750000,11250000]
[null,null,null,null,"14:00:00",false,false,16,416666.66666666669,1250000,3750000,11250000]
[null,null,null,null,"15:00:00",false,false,17,416666.66666666669,1250000,3750000,11250000]
[null,null,null,null,"16:00:00",false,false,18,416666.66666666669,1250000,3750000,11250000]
[null,null,null,null,"17:00:00",false,false,19,416666.66666666669,1250000,3750000,11250000]
[null,null,null,null,"18:00:00",false,false,20,416666.66666666669,1250000,3750000,11250000]
[null,null,null,null,"19:00:00",false,false,21,416666.66666666669,1250000,3750000,11250000]
[null,null,null,null,"20:00:00",false,true,22,416666.66666666669,1250000,3750000,11250000]
[null,null,null,null,"21:00:00",false,false,23,0,0,0,0]
[null,null,null,null,"22:00:00",false,false,24,0,0,0,0]
[null,null,null,null,"23:00:00",false,false,25,0,0,0,0]
[null,null,null,null,"23:59:00",false,false,26,0,0,0,0]
[null,null,null,null,null,{"$f":"CELL(\"address\",INDEX(F2:F26,MATCH(TRUE,F2:F26,0)))","v":"$F$10"},{"$f":"CELL(\"address\",INDEX(G2:G26,MATCH(TRUE,G2:G26,0)))","v":"$G$22"},null,0,0]
[null,null,null,null,null,{"$f":"_xlfn.NUMBERVALUE(RIGHT(F27,LEN(F27)-3))","v":10},{"$f":"_xlfn.NUMBERVALUE(RIGHT(G27,LEN(G27)-3))","v":22},null,0,0]

{"sheet":"h2","index":7,"n_rows":21,"n_cols":30,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
[null,"Max. tps per nodes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nodes per second"]
[null,{"$f":"Scenarios!$B$32","v":"nodes"},{"$f":"Scenarios!C32","v":"Demo"},{"$f":"Scenarios!$B$32","v":"nodes"},{"$f":"Scenarios!D32","v":"Small"},{"$f":"Scenarios!$B$32","v":"nodes"},{"$f":"Scenarios!E32","v":"Medium"},{"$f":"Scenarios!$B$32","v":"nodes"},{"$f":"Scenarios!F32","v":"Large"},{"$f":"Scenarios!$B$32","v":"nodes"},{"$f":"Scenarios!G32","v":"XLarge"},{"$f":"Scenarios!$B$32","v":"nodes"},"XXLarge ",{"$f":"Scenarios!$B$32","v":"nodes"},"XXXLarge ",null,{"$f":"Scenarios!$B$43","v":"nodes"},{"$f":"Scenarios!C43","v":"Demo"},{"$f":"Scenarios!$B$43","v":"nodes"},{"$f":"Scenarios!D43","v":"Small"},{"$f":"Scenarios!$B$43","v":"nodes"},{"$f":"Scenarios!E43","v":"Medium"},{"$f":"Scenarios!$B$43","v":"nodes"},{"$f":"Scenarios!F43","v":"Large"},{"$f":"Scenarios!$B$43","v":"nodes"},{"$f":"Scenarios!G43","v":"XLarge"},{"$f":"Scenarios!$B$32","v":"nodes"},"XXLarge ",{"$f":"Scenarios!$B$32","v":"nodes"},"XXXLarge "]
[null,{"$f":"Scenarios!$B$33","v":5},{"$f":"Scenarios!C33","v":550},{"$f":"Scenarios!$B$33","v":5},{"$f":"Scenarios!D33","v":1100},{"$f":"Scenarios!$B$33","v":5},{"$f":"Scenarios!E33","v":5500},{"$f":"Scenarios!$B$33","v":5},{"$f":"Scenarios!F33","v":13000},{"$f":"Scenarios!$B$33","v":5},{"$f":"Scenarios!G33","v":22000},{"$f":"Scenarios!$B$33","v":5},{"$f":"Scenarios!H33","v":24000},{"$f":"Scenarios!$B$33","v":5},{"$f":"Scenarios!I33","v":28000},null,{"$f":"Scenarios!$B$44","v":5},{"$f":"Scenarios!C44","v":2750},{"$f":"Scenarios!$B$44","v":5},{"$f":"Scenarios!D44","v":5500},{"$f":"Scenarios!$B$44","v":5},{"$f":"Scenarios!E44","v":27500},{"$f":"Scenarios!$B$44","v":5},{"$f":"Scenarios!F44","v":65000},{"$f":"Scenarios!$B$44","v":5},{"$f":"Scenarios!G44","v":110000},{"$f":"Scenarios!$B$44","v":5},{"$f":"Scenarios!H44","v":120000},{"$f":"Scenarios!$B$44","v":5},{"$f":"Scenarios!I44","v":140000}]
[null,{"$f":"Scenarios!$B$34","v":10},{"$f":"Scenarios!C34","v":450},{"$f":"Scenarios!$B$34","v":10},{"$f":"Scenarios!D34","v":850},{"$f":"Scenarios!$B$34","v":10},{"$f":"Scenarios!E34","v":4500},{"$f":"Scenarios!$B$34","v":10},{"$f":"Scenarios!F34","v":10000},{"$f":"Scenarios!$B$34","v":10},{"$f":"Scenarios!G34","v":16500},{"$f":"Scenarios!$B$34","v":10},{"$f":"Scenarios!H34","v":18000},{"$f":"Scenarios!$B$34","v":10},{"$f":"Scenarios!I34","v":20000},null,{"$f":"Scenarios!$B$45","v":10},{"$f":"Scenarios!C45","v":4500},{"$f":"Scenarios!$B$45","v":10},{"$f":"Scenarios!D45","v":8500},{"$f":"Scenarios!$B$45","v":10},{"$f":"Scenarios!E45","v":45000},{"$f":"Scenarios!$B$45","v":10},{"$f":"Scenarios!F45","v":100000},{"$f":"Scenarios!$B$45","v":10},{"$f":"Scenarios!G45","v":165000},{"$f":"Scenarios!$B$45","v":10},{"$f":"Scenarios!H45","v":180000},{"$f":"Scenarios!$B$45","v":10},{"$f":"Scenarios!I45","v":200000}]
[null,{"$f":"Scenarios!$B$35","v":25},{"$f":"Scenarios!C35","v":250},{"$f":"Scenarios!$B$35","v":25},{"$f":"Scenarios!D35","v":500},{"$f":"Scenarios!$B$35","v":25},{"$f":"Scenarios!E35","v":2500},{"$f":"Scenarios!$B$35","v":25},{"$f":"Scenarios!F35","v":6000},{"$f":"Scenarios!$B$35","v":25},{"$f":"Scenarios!G35","v":10000},{"$f":"Scenarios!$B$35","v":25},{"$f":"Scenarios!H35","v":12000},{"$f":"Scenarios!$B$35","v":25},{"$f":"Scenarios!I35","v":14000},null,{"$f":"Scenarios!$B$46","v":25},{"$f":"Scenarios!C46","v":6250},{"$f":"Scenarios!$B$46","v":25},{"$f":"Scenarios!D46","v":12500},{"$f":"Scenarios!$B$46","v":25},{"$f":"Scenarios!E46","v":62500},{"$f":"Scenarios!$B$46","v":25},{"$f":"Scenarios!F46","v":150000},{"$f":"Scenarios!$B$46","v":25},{"$f":"Scenarios!G46","v":250000},{"$f":"Scenarios!$B$46","v":25},{"$f":"Scenarios!H46","v":300000},{"$f":"Scenarios!$B$46","v":25},{"$f":"Scenarios!I46","v":350000}]
[null,{"$f":"Scenarios!$B$36","v":50},{"$f":"Scenarios!C36","v":200},{"$f":"Scenarios!$B$36","v":50},{"$f":"Scenarios!D36","v":450},{"$f":"Scenarios!$B$36","v":50},{"$f":"Scenarios!E36","v":2200},{"$f":"Scenarios!$B$36","v":50},{"$f":"Scenarios!F36","v":5200},{"$f":"Scenarios!$B$36","v":50},{"$f":"Scenarios!G36","v":7500},{"$f":"Scenarios!$B$36","v":50},{"$f":"Scenarios!H36","v":9500},{"$f":"Scenarios!$B$36","v":50},{"$f":"Scenarios!I36","v":10500},null,{"$f":"Scenarios!$B$47","v":50},{"$f":"Scenarios!C47","v":10000},{"$f":"Scenarios!$B$47","v":50},{"$f":"Scenarios!D47","v":22500},{"$f":"Scenarios!$B$47","v":50},{"$f":"Scenarios!E47","v":110000},{"$f":"Scenarios!$B$47","v":50},{"$f":"Scenarios!F47","v":260000},{"$f":"Scenarios!$B$47","v":50},{"$f":"Scenarios!G47","v":375000},{"$f":"Scenarios!$B$47","v":50},{"$f":"Scenarios!H47","v":475000},{"$f":"Scenarios!$B$47","v":50},{"$f":"Scenarios!I47","v":525000}]
[null,{"$f":"Scenarios!$B$37","v":100},{"$f":"Scenarios!C37","v":150},{"$f":"Scenarios!$B$37","v":100},{"$f":"Scenarios!D37","v":300},{"$f":"Scenarios!$B$37","v":100},{"$f":"Scenarios!E37","v":1500},{"$f":"Scenarios!$B$37","v":100},{"$f":"Scenarios!F37","v":3500},{"$f":"Scenarios!$B$37","v":100},{"$f":"Scenarios!G37","v":6500},{"$f":"Scenarios!$B$37","v":100},{"$f":"Scenarios!H37","v":8500},{"$f":"Scenarios!$B$37","v":100},{"$f":"Scenarios!I37","v":9500},null,{"$f":"Scenarios!$B$48","v":100},{"$f":"Scenarios!C48","v":15000},{"$f":"Scenarios!$B$48","v":100},{"$f":"Scenarios!D48","v":30000},{"$f":"Scenarios!$B$48","v":100},{"$f":"Scenarios!E48","v":150000},{"$f":"Scenarios!$B$48","v":100},{"$f":"Scenarios!F48","v":350000},{"$f":"Scenarios!$B$48","v":100},{"$f":"Scenarios!G48","v":650000},{"$f":"Scenarios!$B$48","v":100},{"$f":"Scenarios!H48","v":850000},{"$f":"Scenarios!$B$48","v":100},{"$f":"Scenarios!I48","v":950000}]
[null,{"$f":"Scenarios!$B$38","v":1000},{"$f":"Scenarios!C38","v":15},{"$f":"Scenarios!$B$38","v":1000},{"$f":"Scenarios!D38","v":30},{"$f":"Scenarios!$B$38","v":1000},{"$f":"Scenarios!E38","v":150},{"$f":"Scenarios!$B$38","v":1000},{"$f":"Scenarios!F38","v":350},{"$f":"Scenarios!$B$38","v":1000},{"$f":"Scenarios!G38","v":450},{"$f":"Scenarios!$B$38","v":1000},{"$f":"Scenarios!H38","v":550},{"$f":"Scenarios!$B$38","v":1000},{"$f":"Scenarios!I38","v":600},null,{"$f":"Scenarios!$B$49","v":1000},{"$f":"Scenarios!C49","v":15000},{"$f":"Scenarios!$B$49","v":1000},{"$f":"Scenarios!D49","v":30000},{"$f":"Scenarios!$B$49","v":1000},{"$f":"Scenarios!E49","v":150000},{"$f":"Scenarios!$B$49","v":1000},{"$f":"Scenarios!F49","v":350000},{"$f":"Scenarios!$B$49","v":1000},{"$f":"Scenarios!G49","v":450000},{"$f":"Scenarios!$B$49","v":1000},{"$f":"Scenarios!H49","v":550000},{"$f":"Scenarios!$B$49","v":1000},{"$f":"Scenarios!I49","v":600000}]
["w/o UEM",{"$f":"nodes","v":100},{"$f":"ROUNDUP(interpolate($B$9,B3:C8),0)","v":150},null,{"$f":"ROUNDUP(interpolate($B$9,D3:E8),0)","v":300},null,{"$f":"ROUNDUP(interpolate($B$9,F3:G8),0)","v":1500},null,{"$f":"ROUNDUP(interpolate($B$9,H3:I8),0)","v":3500},null,{"$f":"ROUNDUP(interpolate($B$9,J3:K8),0)","v":6500},null,{"$f":"ROUNDUP(interpolate($B$9,L3:M8),0)","v":8500},null,{"$f":"ROUNDUP(interpolate($B$9,N3:O8),0)","v":9500},null,null,{"$f":"ROUNDUP(interpolate($B$9,Q3:R8),0)","v":15000},null,{"$f":"ROUNDUP(interpolate($B$9,S3:T8),0)","v":30000},null,{"$f":"ROUNDUP(interpolate($B$9,U3:V8),0)","v":150000},null,{"$f":"ROUNDUP(interpolate($B$9,W3:X8),0)","v":350000},null,{"$f":"ROUNDUP(interpolate($B$9,Y3:Z8),0)","v":650000},null,{"$f":"ROUNDUP(interpolate($B$9,AA3:AB8),0)","v":850000},null,{"$f":"ROUNDUP(interpolate($B$9,AC3:AD8),0)","v":950000}]
["w UEM",{"$f":"nodesUEM","v":19},{"$f":"ROUNDUP(interpolate($B$10,B3:C8),0)","v":330},null,{"$f":"ROUNDUP(interpolate($B$10,D3:E8),0)","v":640},null,{"$f":"ROUNDUP(interpolate($B$10,F3:G8),0)","v":3300},null,{"$f":"ROUNDUP(interpolate($B$10,H3:I8),0)","v":7600},null,{"$f":"ROUNDUP(interpolate($B$10,J3:K8),0)","v":12600},null,{"$f":"ROUNDUP(interpolate($B$10,L3:M8),0)","v":14400},null,{"$f":"ROUNDUP(interpolate($B$10,N3:O8),0)","v":16400},null,null,{"$f":"ROUNDUP(interpolate($B$10,Q3:R8),0)","v":5550},null,{"$f":"ROUNDUP(interpolate($B$10,S3:T8),0)","v":10900},null,{"$f":"ROUNDUP(interpolate($B$10,U3:V8),0)","v":55500},null,{"$f":"ROUNDUP(interpolate($B$10,W3:X8),0)","v":130000},null,{"$f":"ROUNDUP(interpolate($B$10,Y3:Z8),0)","v":216000},null,{"$f":"ROUNDUP(interpolate($B$10,AA3:AB8),0)","v":252000},null,{"$f":"ROUNDUP(interpolate($B$10,AC3:AD8),0)","v":290000}]
[]
[]
[]
[null,{"$f":"\"TPS for \"&totalSystemProfiles&\" profiles and \"&IF(scenario=\"Server side only\",ROUND(nodes,0),ROUND(nodesUEM,0) &\" nodes\") & \" nodes\"","v":"TPS for 5 profiles and 19 nodes nodes"},null,null,null,null,null,null,null,null,null,"Conversion rates"]
[null,"profiles","Demo","Small","Medium","Large","XLarge","XXLarge ","XXXLarge ",null,null,"Medium","Large","XLarge","XXLarge ","XXXLarge "]
[null,1,120,200,1200,3000,{"$f":"Scenarios!G37","v":6500},8500,9500,null,null,{"$f":"E17/E16","v":0.84615384615384626},{"$f":"F17/F16","v":0.84615384615384615},{"$f":"G17/G16","v":0.84615384615384615},{"$f":"H17/H16","v":0.94117647058823528},0.94736842105263153]
[null,5,null,null,{"$f":"(E16/F16)*F17","v":1015.3846153846155},{"$f":"(F16/G16)*G17","v":2538.4615384615386},5500,8000,9000,null,null,null,{"$f":"F18/F17","v":0.90909090909090906},{"$f":"G18/G17","v":0.90909090909090906},0.875,0.94444444444444442]
[null,10,null,null,null,{"$f":"F17/G17*G18","v":2307.6923076923076},5000,7000,8500,null,null,null,{"$f":"F19/F18","v":1},{"$f":"G19/G18","v":1},0.8571428571428571,0.82352941176470584]
[null,25,null,null,null,{"$f":"F18/G18*G19","v":2307.6923076923076},5000,6000,7000,null,null,null,null,{"$f":"G20/G19","v":0.9},0.91666666666666663,0.9285714285714286]
[null,50,null,null,null,null,4500,5500,6500,null,null,null,null,{"$f":"G21/G20","v":0.88888888888888884},0.90909090909090906,0.92307692307692313]
[null,100,null,null,null,null,4000,5000,6000]

{"sheet":"Links","index":8,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[null,"Link"]
["Demo","https://www.dynatrace.com/support/doc/appmon/installation/deployment-guide/assess-results/default-deployment-sizes/demo-poc-environment/"]
["Small","https://www.dynatrace.com/support/doc/appmon/installation/deployment-guide/assess-results/default-deployment-sizes/small-environment/"]
["Medium","https://www.dynatrace.com/support/doc/appmon/installation/deployment-guide/assess-results/default-deployment-sizes/medium-environment/"]
["Large","https://www.dynatrace.com/support/doc/appmon/installation/deployment-guide/assess-results/default-deployment-sizes/large-environment/"]
["XLarge","https://www.dynatrace.com/support/doc/appmon/installation/deployment-guide/assess-results/default-deployment-sizes/xlarge-environment/"]
["XXLarge","https://www.dynatrace.com/support/doc/appmon/installation/deployment-guide/assess-results/default-deployment-sizes/xlarge-environment/"]
["XXXLarge","https://www.dynatrace.com/support/doc/appmon/installation/deployment-guide/assess-results/default-deployment-sizes/xlarge-environment/"]
["No Sizing","https://www.dynatrace.com/support/doc/appmon/installation/deployment-guide/assess-results/default-deployment-sizes/sizing-questions-or-issues/"]
["Bandwidth","https://www.dynatrace.com/support/doc/appmon/installation/deployment-guide/additional-deployment-best-practices/network-bandwidth-best-practices/"]
["Storage","https://www.dynatrace.com/support/doc/appmon/installation/deployment-guide/additional-deployment-best-practices/disk-io-determination-best-practices/"]
["Update","https://www.dynatrace.com/support/doc/appmon/installation/deployment-guide/use-the-deployment-sizing-calculator/"]
["HelpDotNet","https://www.dynatrace.com/support/doc/appmon/installation/deployment-guide/collect-sizing-data/"]
[]
[]
[]
[]
[]
[]
["Agent Info","https://www.dynatrace.com/support/doc/appmon/installation/deployment-guide/collect-sizing-data/"]