{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Main Page","ztC Sizing","Tables","ftServer Sizing","Resource Guidelines","Resource Guidelines ztC","Reference Links","Aveva Technical Specifications","System Platform","Revision Notes","Data Elements"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":3,"defined_names":69,"comments":3,"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":"Main Page","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"ztC Sizing","index":1,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":false,"merged":[[28,5,28,11],[29,5,29,11],[32,2,32,14],[1,1,5,15],[7,1,12,1],[6,15,18,15],[17,12,18,14],[15,8,15,11],[13,8,14,11],[17,8,18,11],[17,5,17,6],[22,5,22,11],[24,5,24,11],[25,5,25,11],[26,5,26,11],[27,5,27,11],[20,2,20,14],[21,4,21,13],[6,12,7,12],[6,13,7,13],[6,14,7,14],[6,1,6,11]]}
[]
[null,"Stratus ztC Edge Sizing Tool for Aveva"]
[]
[]
[]
[]
[null,{"$f":"IF(COUNTIF(MDE,FALSE)=0,\"\",\"Manual Data Entry in vCPU, vMemory, or vDisk when ✔ set to Use AVEVA Defined Resource Guidelines\")","v":""},null,null,null,null,null,null,null,null,null,null,"   CPU Resources:\n    100i = 8 vCPU\n    110i = 12 vCPU\n    FT  = vCPU + 2 \n  vCPU Summary","Memory Capacity:\n100i = 32GB \n110i = 64GB\n\nvMemory Summary","Raw Disk Space:\n100i = 512GB Raw\n 110i  = 2TB  Raw\n \nDisk Summary"]
[null,null,"Use Aveva Defined Resources","Virtual Machine","Applications/Function","Availability HA/FT/Single","Enter Quantity",null,"vCPU","vMemory(GB)","vDisk(GB)","OS Required**"]
[null,null,"✔","VM1",null,null,{"$f":"IF(E9=\"\",\"\",1)","v":""},{"$f":"IF(C9=\"✔\",VLOOKUP(E9,VApps,{2,3,4,5},FALSE),\"\")","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"IF(G9=\"\",\"\",IF(F9=\"FT\",(I9+2)*G9,I9*G9))","v":""},{"$f":"IF(G9=\"\",\"\",J9*G9)","v":""},{"$f":"IF(G9=\"\",\"\",G9*K9)","v":""}]
[null,null,"✔","VM2",null,null,{"$f":"IF(E10=\"\",\"\",1)","v":""},{"$f":"IF(C10=\"✔\",VLOOKUP(E10,VApps,{2,3,4,5},FALSE),\"\")","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"IF(G10=\"\",\"\",IF(F10=\"FT\",(I10+2)*G10,I10*G10))","v":""},{"$f":"IF(G10=\"\",\"\",J10*G10)","v":""},{"$f":"IF(G10=\"\",\"\",G10*K10)","v":""}]
[null,null,"✔","VM3",null,null,{"$f":"IF(E11=\"\",\"\",1)","v":""},{"$f":"IF(C11=\"✔\",VLOOKUP(E11,VApps,{2,3,4,5},FALSE),\"\")","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"IF(G11=\"\",\"\",IF(F11=\"FT\",(I11+2)*G11,I11*G11))","v":""},{"$f":"IF(G11=\"\",\"\",J11*G11)","v":""},{"$f":"IF(G11=\"\",\"\",G11*K11)","v":""}]
[null,null,"✔","VM4",null,null,{"$f":"IF(E12=\"\",\"\",1)","v":""},{"$f":"IF(C12=\"✔\",VLOOKUP(E12,VApps,{2,3,4,5},FALSE),\"\")","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"IF(G12=\"\",\"\",IF(F12=\"FT\",(I12+2)*G12,I12*G12))","v":""},{"$f":"IF(G12=\"\",\"\",J12*G12)","v":""},{"$f":"IF(G12=\"\",\"\",G12*K12)","v":""}]
[null,null,"✔",null,null,null,{"$f":"IF(E13=\"\",\"\",1)","v":""},{"$f":"IFERROR(IF(C13=\"✔\",VLOOKUP(E13,VApps,{2,3,4,5},FALSE),\"\"),\"\")","v":""},null,null,null,null,{"$f":"IF(G13=\"\",\"\",IF(F13=\"FT\",(I13+2)*G13,I13*G13))","v":""},{"$f":"IF(G13=\"\",\"\",J13*G13)","v":""},{"$f":"IF(G13=\"\",\"\",G13*K13)","v":""}]
[null,null,null,null,null,null,null,null,"Total Resources* "]
[null,null,null,null,null,"Total Virtual Machines ",{"$f":"IF(SUM(G9:G13)=0,\"\",SUM(G9:G13))","v":""},null,null,null,null,null,{"$f":"IF(SUM(M9:M13)=0,\"\",SUM(M9:M13))","v":""},{"$f":"IF(SUM(N9:N13)=0,\"\",SUM(N9:N13)+(SUM(N9:N13)/100*20))","v":""},{"$f":"IF(SUM(O9:O13)=0,\"\",SUM(O9:O13))","v":""}]
[null,null,null,null,null,null,null,null,"Model  ",null,null,null,{"$f":"IF(SUM(M9:M13)=0,\"\",IF(M15>Tables!D2,IF(M15>Tables!E2,\"^^^\nCPU resources Exceeded\",\"110i\"),IF(OR(COUNTIF(F9:F13,\"FT\"),N16=\"110i\",O16=\"110i\"),\"110i\",\"100i\")))","v":""},{"$f":"IF(SUM(N9:N13)=0,\"\",IF(AND(N15<>\"\",N15>64),\" ^^^ \nMemory Capacity Exceeded\",IF((N15>24),\"110i\",IF(COUNTIF(F9:F13,\"FT\"),\"110i\",\"100i\"))))","v":""},{"$f":"IF(SUM(O9:O13)=0,\"\",IF(O15>Tables!D4,IF(O15>Tables!E4,\"^^^\nDisk Capacity Exceeded\",\"110i\"), IF(COUNTIF(F9:F13,\"FT\"),\"110i\",\"100i\")))","v":""}]
[null,null,null,null,"Platform Recommendation:",{"$f":"ztC_Recommendation&\" \"&(IF(ztC_Recommendation<>\"ztC Edge\",\"\",IF((N16=\"110i\"),\"110i\",IF(OR(M16=\"110i\",O16=\"110i\",COUNTIF(F8:F12,\"FT\")),\"110i\",\"100i\"))))","v":" "},{"$f":"IF(ISNUMBER(K14),IF(OR(K14>12,L14>64,M14>1960),\"Exceeds ztC Edge Resources, ftServer Recommended\",\"\"),\"\")","v":""},null,null,null,null,"Platform ",{"$f":"IF(SUM(M9:M13)=0,\"\",IF(OR(COUNTIF(M16,\"110i\"),COUNTIF(M16,\"100i\")),\"ztC Edge\",\"ftServer\"))","v":""},{"$f":"IF(SUM(M9:M13)=0,\"\",IF(OR(COUNTIF(N16,\"110i\"),COUNTIF(N16,\"100i\")),\"ztC Edge\",IF(COUNTIF(N16,\"110i + 64\"),\"ztC Edge\",\"ftServer\")))","v":""},{"$f":"IF(SUM(M9:M13)=0,\"\",IF(OR(COUNTIF(O16,\"110i\"),COUNTIF(O16,\"100i\")),\"ztC Edge\",\"ftServer\"))","v":""}]
[null,null,null,null,"Required ztC Support Level Selected:",null,null,{"$f":"IF(ISNUMBER(L15),IF(OR(L15>12,M15>64,N15>1960),\"Exceeds ztC Edge Resources, ftServer Recommended\",\"\"),\"\")","v":""},{"$f":"IF(ISNUMBER(M15),IF(OR(M15>12,N15>64,O15>1960),\"Exceeds ztC Edge Resources, ftServer Recommended\",\"\"),\"\")","v":""},null,null,null,"*Total Resources includes +20% memory overhead\n**ztC approved OS list - Does not verify OS compatiblity with application/function"]
[]
[]
[]
[null,null,null,null,"Enter Project Information"]
[null,null,null,null,"Project name:"]
[null,null,null,null,"Project location (Country, City, State/Province):"]
[null,null,null,null,"Contact Name:"]
[null,null,null,null,"Contact Company"]
[null,null,null,null,"Contact Email:"]
[null,null,null,null,"Contact Phone:"]
[null,null,null,null,"Your Stratus Distributor:"]
[null,null,null,null,"Your Stratus Distributor Primary Contact:"]
[]
[null,null,"GET A QUOTE"]
[null,null,"Stratus Technologies is a AVEVA Global Partner and AVEVA distributors and AVEVA can deliver Stratus solutions. Contact Stratus for product selection support and to get introduced to your local Stratus reseller."]

{"sheet":"Tables","index":2,"n_rows":36,"n_cols":16,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["Models",null,"Maximums","100i","110i","110i + 64",null,"Type",null,null,"OS Versions",null,null,"Auto Fill",null,"ztC Data Validataion Prep"]
["100i",null,"cpu",8,12,12,null,"Single",1,null,"WinServer 2019",null,null,"✔",null,{"$f":"TRANSPOSE(_xlfn._xlws.FILTER(RASoftware,ISNUMBER(SEARCH('ztC Sizing'!$E9,RASoftware)),\"not found\"))","v":{"$error":"#NAME?"}}]
["110i",null,"memory (GB)",24,24,52,null,"HA",1,null,"WinServer 2016",null,null,"X",null,{"$f":"TRANSPOSE(_xlfn._xlws.FILTER(RASoftware,ISNUMBER(SEARCH('ztC Sizing'!$E10,RASoftware)),\"not found\"))","v":{"$error":"#NAME?"}}]
["110i + 64",null,"disk (GB)",470,1900,1900,null,"FT",2,null,"WinServer 2012 R2",null,null,null,null,{"$f":"TRANSPOSE(_xlfn._xlws.FILTER(RASoftware,ISNUMBER(SEARCH('ztC Sizing'!$E11,RASoftware)),\"not found\"))","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,"Windows 10",null,null,null,null,{"$f":"TRANSPOSE(_xlfn._xlws.FILTER(RASoftware,ISNUMBER(SEARCH('ztC Sizing'!$E12,RASoftware)),\"not found\"))","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,"CentOS7",null,null,null,null,{"$f":"TRANSPOSE(_xlfn._xlws.FILTER(RASoftware,ISNUMBER(SEARCH('ztC Sizing'!$E13,RASoftware)),\"not found\"))","v":{"$error":"#NAME?"}}]
["ztC Worksheet Recommendation:",null,null,{"$f":"(IF('ztC Sizing'!G15=\"\",\"\",IF(AND('ztC Sizing'!M17=\"ztc Edge\",'ztC Sizing'!N17=\"ztc Edge\",'ztC Sizing'!O17=\"ztc Edge\"), \"ztC Edge\", \"ftServer\")))","v":""},null,null,null,null,null,null,"Ubuntu 12-16 64Bit"]
[]
[]
["ztC Manual Data entered",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ftServer Data Validataion Prep"]
[{"$f":"IF('ztC Sizing'!C9=\"✔\",'ztC Sizing'!I9:'ztC Sizing'!K9=INDEX(VApps,MATCH('ztC Sizing'!E9,'Resource Guidelines'!$A$4:$A$53,0),{3,4,5}),\"\")","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn._xlws.FILTER(RASoftware,ISNUMBER(SEARCH('ftServer Sizing'!$F21,RASoftware)),\"not found\"))","v":{"$error":"#NAME?"}}]
[{"$f":"IF('ztC Sizing'!C10=\"✔\",'ztC Sizing'!I10:'ztC Sizing'!K10=INDEX(VApps,MATCH('ztC Sizing'!E10,'Resource Guidelines'!$A$4:$A$53,0),{3,4,5}),\"\")","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn._xlws.FILTER(RASoftware,ISNUMBER(SEARCH('ftServer Sizing'!$G22,RASoftware)),\"not found\"))","v":{"$error":"#NAME?"}}]
[{"$f":"IF('ztC Sizing'!C11=\"✔\",'ztC Sizing'!I11:'ztC Sizing'!K11=INDEX(VApps,MATCH('ztC Sizing'!E11,'Resource Guidelines'!$A$4:$A$53,0),{3,4,5}),\"\")","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn._xlws.FILTER(RASoftware,ISNUMBER(SEARCH('ftServer Sizing'!$G23,RASoftware)),\"not found\"))","v":{"$error":"#NAME?"}}]
[{"$f":"IF('ztC Sizing'!C12=\"✔\",'ztC Sizing'!I12:'ztC Sizing'!K12=INDEX(VApps,MATCH('ztC Sizing'!E12,'Resource Guidelines'!$A$4:$A$53,0),{3,4,5}),\"\")","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn._xlws.FILTER(RASoftware,ISNUMBER(SEARCH('ftServer Sizing'!$G24,RASoftware)),\"not found\"))","v":{"$error":"#NAME?"}}]
[{"$f":"IF('ztC Sizing'!C13=\"✔\",'ztC Sizing'!I13:'ztC Sizing'!K13=INDEX(VApps,MATCH('ztC Sizing'!E13,'Resource Guidelines'!$A$4:$A$53,0),{3,4,5}),\"\")","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn._xlws.FILTER(RASoftware,ISNUMBER(SEARCH('ftServer Sizing'!$G25,RASoftware)),\"not found\"))","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn._xlws.FILTER(RASoftware,ISNUMBER(SEARCH('ftServer Sizing'!$G26,RASoftware)),\"not found\"))","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn._xlws.FILTER(RASoftware,ISNUMBER(SEARCH('ftServer Sizing'!#REF!,RASoftware)),\"not found\"))","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn._xlws.FILTER(RASoftware,ISNUMBER(SEARCH('ftServer Sizing'!#REF!,RASoftware)),\"not found\"))","v":{"$error":"#NAME?"}}]
["ztC Support Level",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn._xlws.FILTER(RASoftware,ISNUMBER(SEARCH('ftServer Sizing'!#REF!,RASoftware)),\"not found\"))","v":{"$error":"#NAME?"}}]
["System Support",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn._xlws.FILTER(RASoftware,ISNUMBER(SEARCH('ftServer Sizing'!#REF!,RASoftware)),\"not found\"))","v":{"$error":"#NAME?"}}]
["System Support + System Health",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn._xlws.FILTER(RASoftware,ISNUMBER(SEARCH('ftServer Sizing'!#REF!,RASoftware)),\"not found\"))","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn._xlws.FILTER(RASoftware,ISNUMBER(SEARCH('ftServer Sizing'!$G33,RASoftware)),\"not found\"))","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn._xlws.FILTER(RASoftware,ISNUMBER(SEARCH('ftServer Sizing'!$G34,RASoftware)),\"not found\"))","v":{"$error":"#NAME?"}}]
["AVEVA Software Headings",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn._xlws.FILTER(RASoftware,ISNUMBER(SEARCH('ftServer Sizing'!$G35,RASoftware)),\"not found\"))","v":{"$error":"#NAME?"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn._xlws.FILTER(RASoftware,ISNUMBER(SEARCH('ftServer Sizing'!$G38,RASoftware)),\"not found\"))","v":{"$error":"#NAME?"}}]
["General",null,null,null,null,null,"General",null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn._xlws.FILTER(RASoftware,ISNUMBER(SEARCH('ftServer Sizing'!$G39,RASoftware)),\"not found\"))","v":{"$error":"#NAME?"}}]
["AVEVA_Plant_SCADA",null,null,null,null,null,"AVEVA_Plant_SCADA_ztC",null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn._xlws.FILTER(RASoftware,ISNUMBER(SEARCH('ftServer Sizing'!#REF!,RASoftware)),\"not found\"))","v":{"$error":"#NAME?"}}]
["AVEVA_InTouch_HMI",null,null,null,null,null,"AVEVA_InTouch_HMI_ztC",null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn._xlws.FILTER(RASoftware,ISNUMBER(SEARCH('ftServer Sizing'!$G42,RASoftware)),\"not found\"))","v":{"$error":"#NAME?"}}]
["AVEVA_System_Platform",null,null,null,null,null,"AVEVA_System_Platform_ztC",null,null,null,null,null,null,null,null,{"$f":"TRANSPOSE(_xlfn._xlws.FILTER(RASoftware,ISNUMBER(SEARCH('ftServer Sizing'!$G44,RASoftware)),\"not found\"))","v":{"$error":"#NAME?"}}]
["AVEVA_Unified_Operations_Center",null,null,null,null,null,"AVEVA_AssetInformation_ztC"]
["AVEVA_Workflow_Management",null,null,null,null,null,"AVEVA_Enterprise_Data_Mngmt_ztC"]
["AVEVA_Predicitive_Asset_Analytics",null,null,null,null,null,"AVEVA_Manufacturing_Execution_ztC"]
["AVEVA_Enterprise_Asset_Mngmt",null,null,null,null,null,"AVEVA_Workflow_Management_ztC"]
["AVEVA_Mobile_Operator_Rounds",null,null,null,null,null,"AVEVA_Production_Management_ztC"]
["Manual_Entry",null,null,null,null,null,"AVEVA_Recipe_Management_ztC"]
[null,null,null,null,null,null,"AVEVA_Batch_Management_ztC"]

{"sheet":"ftServer Sizing","index":3,"n_rows":58,"n_cols":15,"rows_kept":58,"cut":false,"hidden":false,"merged":[[54,0,54,6],[54,7,54,16],[56,0,56,17],[57,2,57,14],[51,0,51,6],[51,7,51,16],[52,0,52,6],[52,7,52,16],[53,0,53,6],[53,7,53,16],[48,0,48,6],[48,7,48,16],[49,0,49,6],[49,7,49,16],[50,0,50,6],[50,7,50,16],[41,5,41,10],[41,14,42,14],[42,3,42,8],[46,0,46,17],[47,0,47,6],[47,7,47,16],[17,1,43,2],[17,3,18,3],[21,6,21,9],[22,6,22,9],[23,6,23,9],[24,6,24,9],[25,6,25,9],[26,6,26,9],[27,6,27,9],[28,6,28,9],[17,13,18,13],[17,14,18,14],[18,6,18,9],[19,6,19,9],[20,6,20,9],[17,5,17,9],[17,11,18,11],[17,12,18,12],[15,4,15,9],[15,11,16,13],[16,4,16,9],[13,4,13,6],[13,7,13,9],[12,4,12,6],[12,7,12,9],[12,11,12,13],[13,11,13,13],[14,4,14,9],[9,4,9,6],[9,7,9,9],[9,11,9,13],[10,11,10,13],[11,4,11,6],[11,7,11,9],[11,11,11,13],[6,11,6,13],[7,11,7,13],[8,4,8,6],[8,7,8,9],[8,11,8,13],[31,6,31,9],[0,0,0,17],[1,0,43,0],[1,1,2,16],[1,17,43,17],[3,4,3,9],[3,11,3,14],[3,15,43,16],[4,4,4,6],[4,7,4,9],[4,11,4,13],[5,4,5,6],[5,7,5,9],[5,11,5,13],[6,4,6,6],[6,7,6,9],[39,6,39,9],[40,6,40,9],[37,6,37,9],[38,6,38,9],[3,1,16,3],[32,6,32,9],[33,6,33,9],[34,6,34,9],[35,6,35,9],[36,6,36,9],[7,4,7,6],[7,7,7,9],[10,4,10,6],[10,7,10,9],[29,6,29,9],[30,6,30,9]]}
[]
[null,"Stratus ftServer Sizing Tool for Aveva"]
[]
[null,null,null,null,"Configuration Options",null,null,null,null,null,null,"Recommended Solution"]
[null,null,null,null,"Include VMware vSphere license(s):",null,null,null,null,null,null,"ftServer Model:",null,null,{"$f":"IF(OR(H9>6,(SUM(H9:J11)>12)),\"PCI Capacity Exceeded\",'Data Elements'!I12)","v":"ft2910"}]
[null,null,null,null,"Select vSphere license:",null,null,null,null,null,null,"Redundant Memory:",null,null,{"$f":"Recommended_RAM& \" GB\"","v":"32 GB"}]
[null,null,null,null,"Include Windows Server license(s):",null,null,null,null,null,null,"RAW Storage:",null,null,{"$f":"IF(N43<600,\"600 GB\",CEILING(N43,600)/1000&\"TB\")","v":"600 GB"}]
[null,null,null,null,"Microsoft OEM or Volume licenses:",null,null,null,null,null,null,"Additional 1Gb PCI NICs:",null,null,{"$f":"IF(AND(Recommended_ftServer='Data Elements'!$H$4,'ftServer Sizing'!$H$9=2,'ftServer Sizing'!$H$10='Data Elements'!$N$4),0,IF(AND(OR(Recommended_ftServer='Data Elements'!$H$5,Recommended_ftServer='Data Elements'!$H$6),'ftServer Sizing'!$H$10='Data Elements'!$N$4),IF(('ftServer Sizing'!$H$9-4)/2<0,0,('ftServer Sizing'!$H$9-4)/2),IF(('ftServer Sizing'!$H$9-2/2)<0,0,('ftServer Sizing'!$H$9-2)/1)/2))&\" Pair\"","v":"0 Pair"}]
[null,null,null,null,"No. of Usable 1Gb Connections:",null,null,null,null,null,null,"Additional 10Gb PCI NICs:",null,null,{"$f":"IF(AND('ftServer Sizing'!$H$10<=2,H11<1),0,ROUND((('ftServer Sizing'!$H$10-2)/2/2+H11/2),0))&\" Pair\"","v":"0 Pair"}]
[null,null,null,null,"No. of Usable 10G Copper Connections:",null,null,null,null,null,null,"VMware License:",null,null,{"$f":"IF(OR(H5=\"No\",H5=\"\",H6=\"\"),\"Partner Supplied\",H6)","v":"Partner Supplied"}]
[null,null,null,null,"No. of Usable 10G Fiber Connections:",null,null,null,null,null,null,"WinServer 2019 Lic.:",null,null,{"$f":"IF(OR(H7=\"No\",H7=\"\"),\"Partner Supplied\",'Data Elements'!H32)","v":"Partner Supplied"}]
[null,null,null,null,"Phone Home Option:",null,null,null,null,null,null,"Windows Device Server CALs:"]
[null,null,null,null,"Include Rack Enclosure:",null,null,null,null,null,null,"Microsoft Device RDS CALs:"]
[null,null,null,null,"Required Support Level Selected:",null,null,null,null,null,null,"CPU Over Provision Allowance:",null,null,1]
[]
[null,null,null,null,"Select \"✔\" to use AVEVA defaults",null,null,null,null,null,null,"Virtual Machine Resources"]
[null,null,null,null,"Select \"X\" to use Custom Values"]
[null,null,null,"Virtual Machine",null,"Applications/Function",null,null,null,null,null,"vCPU","vMem (GB)","Total vDisk (GB)","OS Version"]
[null,null,null,null,null,"Main Software Groups Selection","Application / Function"]
[null,null,null,"VM1",null,null,"Stratus Appliance",null,null,null,null,1,5,20,"Linux"]
[null,null,null,"VM2","X",null,"Select Main Software Group first then Application function.......",null,null,null,{"$f":"IF($E21=\"✔\",VLOOKUP(G21,VApps,{2,3,4,5},FALSE),\"\")","v":""}]
[null,null,null,"VM3","✔",null,"Select Main Software Group first then Application function.......",null,null,null,{"$f":"IF($E22=\"✔\",VLOOKUP(G22,VApps,{2,3,4,5},FALSE),\"\")","v":{"$error":"#N/A"}}]
[null,null,null,"VM4","✔",null,"Select Main Software Group first then Application function.......",null,null,null,{"$f":"IF($E23=\"✔\",VLOOKUP(G23,VApps,{2,3,4,5},FALSE),\"\")","v":{"$error":"#N/A"}}]
[null,null,null,"VM5","✔",null,"Select Main Software Group first then Application function.......",null,null,null,{"$f":"IF($E24=\"✔\",VLOOKUP(G24,VApps,{2,3,4,5},FALSE),\"\")","v":{"$error":"#N/A"}}]
[null,null,null,"VM6","✔",null,"Select Main Software Group first then Application function.......",null,null,null,{"$f":"IF($E25=\"✔\",VLOOKUP(G25,VApps,{2,3,4,5},FALSE),\"\")","v":{"$error":"#N/A"}}]
[null,null,null,"VM7","✔",null,"Select Main Software Group first then Application function.......",null,null,null,{"$f":"IF($E26=\"✔\",VLOOKUP(G26,VApps,{2,3,4,5},FALSE),\"\")","v":{"$error":"#N/A"}}]
[null,null,null,"VM8","✔",null,"Select Main Software Group first then Application function.......",null,null,null,{"$f":"IF($E27=\"✔\",VLOOKUP(G27,VApps,{2,3,4,5},FALSE),\"\")","v":{"$error":"#N/A"}}]
[null,null,null,"VM9","✔",null,"Select Main Software Group first then Application function.......",null,null,null,{"$f":"IF($E28=\"✔\",VLOOKUP(G28,VApps,{2,3,4,5},FALSE),\"\")","v":{"$error":"#N/A"}}]
[null,null,null,"VM10","✔",null,"Select Main Software Group first then Application function.......",null,null,null,{"$f":"IF($E29=\"✔\",VLOOKUP(G29,VApps,{2,3,4,5},FALSE),\"\")","v":{"$error":"#N/A"}}]
[null,null,null,"VM11","✔",null,"Select Main Software Group first then Application function.......",null,null,null,{"$f":"IF($E30=\"✔\",VLOOKUP(G30,VApps,{2,3,4,5},FALSE),\"\")","v":{"$error":"#N/A"}}]
[null,null,null,"VM12","✔",null,"Select Main Software Group first then Application function.......",null,null,null,{"$f":"IF($E31=\"✔\",VLOOKUP(G31,VApps,{2,3,4,5},FALSE),\"\")","v":{"$error":"#N/A"}}]
[null,null,null,"VM13","✔",null,"Select Main Software Group first then Application function.......",null,null,null,{"$f":"IF($E32=\"✔\",VLOOKUP(G32,VApps,{2,3,4,5},FALSE),\"\")","v":{"$error":"#N/A"}}]
[null,null,null,"VM14","✔",null,"Select Main Software Group first then Application function.......",null,null,null,{"$f":"IF($E33=\"✔\",VLOOKUP(G33,VApps,{2,3,4,5},FALSE),\"\")","v":{"$error":"#N/A"}}]
[null,null,null,"VM15","✔",null,"Select Main Software Group first then Application function.......",null,null,null,{"$f":"IF($E34=\"✔\",VLOOKUP(G34,VApps,{2,3,4,5},FALSE),\"\")","v":{"$error":"#N/A"}}]
[null,null,null,"VM16","✔",null,"Select Main Software Group first then Application function.......",null,null,null,{"$f":"IF($E35=\"✔\",VLOOKUP(G35,VApps,{2,3,4,5},FALSE),\"\")","v":{"$error":"#N/A"}}]
[null,null,null,"VM17","✔",null,"Select Main Software Group first then Application function.......",null,null,null,{"$f":"IF($E36=\"✔\",VLOOKUP(G36,VApps,{2,3,4,5},FALSE),\"\")","v":{"$error":"#N/A"}}]
[null,null,null,"VM18","✔",null,"Select Main Software Group first then Application function.......",null,null,null,{"$f":"IF($E37=\"✔\",VLOOKUP(G37,VApps,{2,3,4,5},FALSE),\"\")","v":{"$error":"#N/A"}}]
[null,null,null,"VM19","✔",null,"Select Main Software Group first then Application function.......",null,null,null,{"$f":"IF($E38=\"✔\",VLOOKUP(G38,VApps,{2,3,4,5},FALSE),\"\")","v":{"$error":"#N/A"}}]
[null,null,null,"VM20","✔",null,"Select Main Software Group first then Application function.......",null,null,null,{"$f":"IF($E39=\"✔\",VLOOKUP(G39,VApps,{2,3,4,5},FALSE),\"\")","v":{"$error":"#N/A"}}]
[null,null,null,"VM21","X","Custom Selection",null,null,null,null,{"$f":"IF($E40=\"✔\",VLOOKUP(G40,VApps,{2,3,4,5},FALSE),\"\")","v":""}]
[null,null,null,"VM22","X","Custom Selection",null,null,null,null,{"$f":"IF($E41=\"✔\",VLOOKUP(G41,VApps,{2,3,4,5},FALSE),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,"Totals:",null,{"$f":"SUM(L20:L41)","v":1},{"$f":"SUM(M20:M41)","v":5},{"$f":"SUM(N20:N41)","v":20}]
[null,null,null,"Allowance for Growth:",null,null,null,null,null,0.2,null,{"$f":"ROUND(L42+(L42*$J$43),0)","v":1},{"$f":"ROUND(M42+(M42*$J$43),0)","v":6},{"$f":"ROUND(N42+(N42*$J$43),0)","v":24}]
[]
[]
[]
["Enter Project Information"]
["Project name:"]
["Project location (Country, City, State/Province):"]
["Contact Name:"]
["Contact Company"]
["Contact Email:"]
["Contact Phone:"]
["Your Stratus Distributor:"]
["Your Stratus Distributor Primary Contact:"]
[]
["GET A QUOTE"]
[null,null,"Stratus Technologies is a AVEVA Global Partner and AVEVA distributors and AVEVA can deliver Stratus solutions. Contact Stratus for product selection support and to get introduced to your local Stratus reseller."]

{"sheet":"Resource Guidelines","index":4,"n_rows":84,"n_cols":7,"rows_kept":84,"cut":false,"hidden":false,"merged":[[0,0,1,6]]}
["Aveva Application Server resource guidelines for Virtualization on Stratus Platforms"]
[]
["Software Application",null,"vCPU","vMem","vDisk","Supported OS","Notes"]
["Windows Domain Controller",null,2,4,60,"WinServer 2019","Domain controller Role (If using more than 10 computing devices in a architecture a domain controller is recommended for central administration of policies, security, users etc.)"]
["SQL Database Server",null,2,8,250,"WinServer 2019","Separate SQL Database"]
["AVEVA Operations Control and HMI"]
["AVEVA Plant SCADA (formerly Citect)"]
["AVEVA Plant SCADA - Workstation HMI/Client",null,4,4,10,"Win10 / WinServer 2019","Unlimited tags, AVEVA Plant SCADA communication driver, Includes one desktop HMI Client or supports one RDS  Client"]
["AVEVA Plant SCADA - Compact - Server",null,2,4,10,"WinServer 2019","<1500 I/O Points  ( Same option can be selected if a redundant server is required)"]
["AVEVA Plant SCADA - Compact - Engineering Server",null,2,8,10,"Win10 / WinServer 2019","<1500 I/O Points"]
["AVEVA Plant SCADA - Small - Server",null,4,8,20,"WinServer 2019","<15k I/O Points  ( Same option can be selected if a redundant server is required)"]
["AVEVA Plant SCADA - Small - Engineering Server",null,2,8,20,"WinServer 2019","<15k I/O Points"]
["AVEVA Plant SCADA - Medium - Server",null,4,8,100,"WinServer 2019","<50k I/O Points  ( Same option can be selected if a redundant server is required)"]
["AVEVA Plant SCADA - Medium - Engineering Server",null,4,8,50,"WinServer 2019","<50k I/O Points"]
["AVEVA Plant SCADA - Large - Server",null,8,16,500,"WinServer 2019","<200k I/O Points  ( Same option can be selected if a redundant server is required)"]
["AVEVA Plant SCADA - Large - Engineering Server",null,4,8,100,"WinServer 2019","<>500k I/O Points"]
[]
["AVEVA InTouch HMI (formerly InTouch)"]
["AVEVA InTouch HMI - Workstation Client",null,4,4,100,"Win10 / WinServer 2019","Software to be installed: WindowViewer, ViewApp, Historian Client, Remote IDE"]
["AVEVA InTouch HMI - Small - SCADA Server",null,4,4,200,"Win Server 2019","1 - 25k I/O, Up to 10 InTouch Web Sessions ( Same option can be selected if a redundant server is required)"]
["AVEVA InTouch HMI - Medium - SCADA Server",null,8,12,500,"Win Server 2019","25k I/O - 50k I/O, Up to 20 InTouch Web Sessions ( Same option can be selected if a redundant server is required)"]
["AVEVA InTouch HMI - Large - SCADA Server",null,16,24,1000,"Win Server 2019","50K I/O - 400K I/O, Up to 40 InTouch Web Sessions ( Same option can be selected if a redundant server is required)"]
["AVEVA InTouch HMI - Unlimite - Reporting Server",null,16,16,1000,"Win Server 2019","<100k tag Historian Server and Dream Report Server"]
[]
["AVEVA System Platform"]
["AVEVA System Platform - Small - Development Server",null,4,4,200,"Win Server 2019","<25K I/O,  Galaxy Repository Server, with up to 2 X IDE Client sessions"]
["AVEVA System Platform - Small - Application Server",null,4,4,200,"Win Server 2019","<25K I/O, Applications Object Server, Communication Drivers, up to 4 Application Engines ( Same option can be selected if a redundant server is required)"]
["AVEVA System Platform - Small - Historian Server",null,4,4,200,"Win Server 2019","<25K I/O, Historian Server + Historian Insight Server, with up to 2 Historian Client/Web connections"]
["AVEVA System Platform - Small - Supervisory Client",null,4,4,100,"Win10","Software to be installed: WindowViewer, ViewApp, Historian Client, Remote IDE"]
["AVEVA System Platform - Small - Development Client",null,4,4,200,"Win10","<25K I/O, dedicated Development Client running IDE software"]
["AVEVA System Platform - Medium - Development Server",null,8,12,500,"Win Server 2019","25K I/O - 50K I/O, Galaxy Repository Server, with up to 5 X IDE Client sessions"]
["AVEVA System Platform - Medium - Application Server",null,8,12,500,"Win Server 2019","25K I/O - 50K I/O, Applications Object Server, Communication Drivers, up to 8 Application Engines ( Same option can be selected if a redundant server is required)"]
["AVEVA System Platform - Medium - Historian Server",null,8,12,500,"Win Server 2019","25K I/O - 50K I/O, Historian Server + Historian Insight Server, with up to 5 Historian Client/Web connections"]
["AVEVA System Platform - Medium - Supervisory Client",null,8,8,100,"Win10","Software to be installed: WindowViewer, ViewApp, Historian Client, Remote IDE"]
["AVEVA System Platform - Medium - Development Client",null,8,8,200,"Win10","25K I/O - 50K I/O, dedicated Development Client running IDE software"]
["AVEVA System Platform - Large - Development Server",null,16,24,1000,"Win Server 2019",">100K I/O, Galaxy Repository Server, with up to 10 X IDE Client sessions"]
["AVEVA System Platform - Large - Application Server",null,16,24,1000,"Win Server 2019","50K I/O - 100K I/O, Applications Object Server, Communication Drivers, up to 16 Application Engines ( Same option can be selected if a redundant server is required)"]
["AVEVA System Platform - Large - Historian Server",null,16,24,1000,"Win Server 2019","100K I/O - 2M I/O, Historian Server + Historian Insight Server, with up to 10 Historian Client/Web connections"]
["AVEVA System Platform - Large - Supervisory Client",null,8,8,100,"Win10","Software to be installed: WindowViewer, ViewApp, Historian Client, Remote IDE"]
["AVEVA System Platform - Large - Development Client",null,8,8,200,"Win10",">100K I/O, dedicated Development Client running IDE software"]
[]
["AVEVA Anywhere Server (InTouch | Citect) - Compact ",null,8,12,20,"WinServer 2019","Allows for up to 5 concurrent RDS Sessions"]
["AVEVA Anywhere Server (InTouch | Citect) - Small ",null,16,24,20,"WinServer 2019","Allows for up to 10 concurrent RDS Sessions"]
["AVEVA Anywhere Server (InTouch | Citect) - Medium ",null,32,40,20,"WinServer 2019","Allows for up to 25 concurrent RDS Sessions"]
["AVEVA Anywhere Server (InTouch | Citect) - Large ",null,64,80,100,"Win Server 2019","Allows for up to 50 concurrent RDS Sessions"]
[]
["AVEVA Unified Operations Center (OMI)"]
["AVEVA Unified Operations Center - Small - Visualisation Server",null,16,32,100,"Win Server 2019","Allows for 10 OMI Sessions"]
["AVEVA Unified Operations Center - Medium - Visualisation Server",null,32,64,100,"Win Server 2019","Allows for 25 OMI Sessions"]
["AVEVA Unified Operations Center - Large - Visualisation Server",null,64,128,100,"Win Server 2019","Allows for >25 OMI Sessions"]
[]
[]
["AVEVA Operations Execution"]
["AVEVA Manufacturing Execution System"]
["AVEVA MES - Small - Application Server",null,4,4,200,"Win Server 2019","<25K I/O, Applications Object Server, Communication Drivers, up to 50 UCO/OCO Entities"]
["AVEVA MES - Small - Database and Report Server",null,4,4,1000,"Win Server 2019","MES Database + MES Webserver Support data records for up to 50 UCO/OCO Entities and up to 5 X MES Client Sessions"]
["AVEVA MES - Medium - Application Server",null,8,8,500,"Win Server 2019","<50K I/O, Applications Object Server, Communication Drivers, up to 150 UCO/OCO Entities"]
["AVEVA MES - Medium - Database and Report Server",null,8,8,1000,"Win Server 2019","MES Database + MES Webserver Support data records for up to 150 UCO/OCO Entities and up to 10 X MES Client Sessions"]
["AVEVA MES - Large - Application Server",null,16,16,500,"Win Server 2019","<100K I/O, Applications Object Server, Communication Drivers, up to 300 UCO/OCO Entities"]
["AVEVA MES - Large - Database and Report Server",null,32,32,2000,"Win Server 2019","MES Database + MES Webserver Support data records for up to 300 UCO/OCO Entities and up to 20 X MES Client Sessions"]
["AVEVA MES - Enterprise - Application Server",null,32,32,1000,"Win Server 2019","<100K I/O, Applications Object Server, Communication Drivers, up to 500 UCO/OCO Entities"]
["AVEVA MES - Enterprise - Database Server",null,64,64,2000,"Win Server 2019","MES Database Support data records for up to 500 UCO/OCO Entities"]
["AVEVA MES - Enterprise - Report Server",null,64,64,2000,"Win Server 2019","MES Webserver Support up to 200 X MES Client Sessions"]
[]
["AVEVA Workflow Management"]
["AVEVA Workflow Management - Small - BPM Server",null,8,8,500,"Win Server 2019","Up to 5 concurrent user sessions"]
["AVEVA Workflow Management - Medium - BPM Server",null,16,16,1000,"Win Server 2019","Up to 10 concurrent user sessions"]
["AVEVA Workflow Management - Large - BPM Server",null,32,32,2000,"Win Server 2019","Up to 100 concurrent user sessions"]
["AVEVA Workflow Management - Enterprise - BPM Server",null,64,64,2000,"Win Server 2019","> 100 concurrent user sessions"]
[]
["AVEVA Asset Performance"]
["AVEVA Predicitive Asset Analytics"]
["AVEVA Predicitive Asset Analytics - Small - Applications Server",null,4,16,20,"Win Server 2016","up to 100 models, 5 users - 1 VM ( Please contact local AVEVA technical support for detailed assistance in architecture)"]
["AVEVA Predicitive Asset Analytics - Medium - Applications Server",null,12,64,300,"Win Server 2016","up to 800 models, 20 users - 2 VMs ( Please contact local AVEVA technical support for detailed assistance in architecture)"]
["AVEVA Predicitive Asset Analytics - Large - Applications Server",null,16,128,1200,"Win Server 2016","up to 3000 models, 50 users - 3 VMs ( Please contact local AVEVA technical support for detailed assistance in architecture)"]
["AVEVA Predicitive Asset Analytics - Very Large - Applications Server",null,24,256,2000,"Win Server 2016","over 3000 models, over 50 users - 4 VMs ( Please contact local AVEVA technical support for detailed assistance in architecture)"]
[]
["AVEVA Enterprise Asset Management"]
["AVEVA Enterprise Asset Management - Medium - All In One Server",null,16,16,1000,"Win Server 2016","up to 50 users ( Please contact local AVEVA technical support for detailed assistance in architecture)"]
["AVEVA Enterprise Asset Management - Large - All In One Server",null,32,32,2000,"Win Server 2016","> 50 users  (Please contact local AVEVA technical support for detailed asistance in architecture)"]
[]
["AVEVA Mobile Operator Rounds"]
["AVEVA Mobile Operator Mobile - Medium - Server",null,8,16,1000,"Win Server 2016","up to 50 users"]
["AVEVA Mobile Operator Mobile - Large - Server",null,16,32,2000,"Win Server 2016","> 50 users"]

{"sheet":"Resource Guidelines ztC","index":5,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":true,"merged":[[0,0,1,6]]}
["Aveva Application Server resource guidelines for Virtualization on Stratus on ztC Edge Server"]
[]
["Software Application",null,"vCPU","vMem","vDisk","Supported OS","Notes"]
[]
["Windows Domain Controller",null,2,4,60,"WinServer 2019","Domain controller Role (If using more than 10 computing devices in a architecture a domain controller is recommended for central administration of policies, security, users etc.)"]
["SQL Database Server",null,2,8,250,"WinServer 2019"]
[]
["AVEVA Plant SCADA - Workstation HMI/Client",null,4,4,10,"Win10 / WinServer 2019","Unlimited tags, AVEVA Plant SCADA communication driver, Includes one desktop HMI Client or supports one RDS  Client"]
["AVEVA Plant SCADA - Compact - Server",null,2,4,10,"WinServer 2019","<1500 I/O Points"]
["AVEVA Plant SCADA - Compact - Engineering Server",null,2,8,10,"Win10 / WinServer 2019","<1500 I/O Points"]
["AVEVA Plant SCADA - Small - Server",null,4,8,20,"WinServer 2019","<15k I/O Points "]
["AVEVA Plant SCADA - Small - Engineering Server",null,2,8,20,"WinServer 2019","<15k I/O Points"]
["AVEVA Plant SCADA - Medium - Server",null,4,8,100,"WinServer 2019","<50k I/O Points"]
["AVEVA Plant SCADA - Medium - Engineering Server",null,4,8,50,"WinServer 2019","<50k I/O Points"]
["AVEVA Plant SCADA - Large - Engineering Server",null,4,8,100,"WinServer 2019","<>500k I/O Points"]
[]
["AVEVA InTouch HMI - Workstation Client",null,4,4,100,"Win10 / WinServer 2019","Software to be installed: WindowViewer, ViewApp, Historian Client, Remote IDE"]
["AVEVA InTouch HMI - Small - SCADA Server",null,4,4,200,"Win Server 2019","1 - 25k I/O, Up to 10 InTouch Web Sessions"]
["AVEVA InTouch HMI - Medium - SCADA Server",null,8,12,500,"Win Server 2019","25k I/O - 50k I/O, Up to 20 InTouch Web Sessions"]
[]
["AVEVA System Platform - Small - Development Server",null,4,4,200,"Win Server 2019","<25K I/O,  Galaxy Repository Server, with up to 2 X IDE Client sessions"]
["AVEVA System Platform - Small - Application Server",null,4,4,200,"Win Server 2019","<25K I/O, Applications Object Server, Communication Drivers, up to 4 Application Engines"]
["AVEVA System Platform - Small - Historian Server",null,4,4,200,"Win Server 2019","<25K I/O, Historian Server + Historian Insight Server, with up to 2 Historian Client/Web connections"]
["AVEVA System Platform - Small - Supervisory Client",null,4,4,100,"Win10","Software to be installed: WindowViewer, ViewApp, Historian Client, Remote IDE"]
["AVEVA System Platform - Small - Development Client",null,4,4,200,"Win10","<25K I/O, dedicated Development Client running IDE software"]
["AVEVA System Platform - Medium - Development Server",null,8,12,500,"Win Server 2019","25K I/O - 50K I/O, Galaxy Repository Server, with up to 5 X IDE Client sessions"]
["AVEVA System Platform - Medium - Application Server",null,8,12,500,"Win Server 2019","25K I/O - 50K I/O, Applications Object Server, Communication Drivers, up to 8 Application Engines"]
["AVEVA System Platform - Medium - Historian Server",null,8,12,500,"Win Server 2019","25K I/O - 50K I/O, Historian Server + Historian Insight Server, with up to 5 Historian Client/Web connections"]
["AVEVA System Platform - Medium - Supervisory Client",null,8,8,100,"Win10","Software to be installed: WindowViewer, ViewApp, Historian Client, Remote IDE"]
["AVEVA System Platform - Medium - Development Client",null,8,8,200,"Win10","25K I/O - 50K I/O, dedicated Development Client running IDE software"]
["AVEVA System Platform - Large - Supervisory Client",null,8,8,100,"Win10","Software to be installed: WindowViewer, ViewApp, Historian Client, Remote IDE"]
["AVEVA System Platform - Large - Development Client",null,8,8,200,"Win10",">100K I/O, dedicated Development Client running IDE software"]
[]
["AVEVA Anywhere Server (InTouch | Citect) - Compact ",null,8,12,20,"WinServer 2019","Allows for up to 5 concurrent RDS Sessions"]
["AVEVA Asset Information Management - Small - Discovery Server",null,8,8,150,"Win Server 2019","Supports 20K documents, Up to 25  users,\n"]
[]
["AVEVA EDGE Embedded HMI",null,2,3,60,"Win10 / Win Server 2019","Embedded HMI "]
["AVEVA APC",null,2,16,250,"Win Server 2019","Advance Process Control"]

{"sheet":"Reference Links","index":6,"n_rows":29,"n_cols":2,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Reference Links"]
[null,"Stratus Technologies"]
[]
[null,"ztC Edge Data Sheet"]
[null,"https://resources.stratus.com/datasheets/ds-ztc-edge"]
[null,"ztC Edge Support Service"]
[null,"https://resources.stratus.com/datasheets/sb-ztc-edge-support-services"]
[null,"ThinManager Characterization Report for ztC 100i"]
[null,"https://www.stratus.com/en-us/lp/ia/ztc-edge-characterization-report-ty/"]
[null,"ztC Edge Introduction Video"]
[null,"https://www.stratus.com/resources/video/stratus-ztc-edge-solution/"]
[null,"ftServer Data Sheet"]
[null,"https://resources.stratus.com/ftserver/ds-ftserver-2900-4900-6900"]
[null,"ftServer Support Services"]
[null,"https://resources.stratus.com/ftserver/ds-ftservice-offerings"]
[null,"ftServer Introduction Video"]
[null,"https://www.youtube.com/watch?v=hfZ61uJ5xtc&t=0s"]
[null,"Stratus ftServer Site Planning Guide"]
[null,"https://stratadoc.stratus.com/linux/11.1.6.0/r786-03/wwhelp/wwhimpl/common/html/r786-03.pdf"]
[]
[]
[]
[null,"Aveva"]
[]
[null,"Online Documentation"]
[null,"https://softwaresupport.aveva.com/"]
[null,"Thinmanager"]
[null,"https://kb.thinmanager.com/index.php/System_Requirements"]

{"sheet":"Aveva Technical Specifications","index":7,"n_rows":113,"n_cols":7,"rows_kept":113,"cut":false,"hidden":false,"merged":[[0,0,0,6],[4,6,5,6],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[10,6,11,6],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,4,8,4],[7,5,8,5],[7,6,8,6],[10,1,11,1],[10,2,11,2],[10,3,11,3],[10,4,11,4],[10,5,11,5],[82,1,85,1],[86,1,91,1],[62,0,63,0],[64,1,68,1],[69,1,73,1],[74,1,77,1],[78,0,81,0],[78,1,81,1]]}
["AVEVA System Platform 2020"]
[]
["Application","Level","CPU Cores ","RAM","HD Space ","Screen Resolution","Network Speed "]
["Server Nodes: for Historian Server, Galaxy Repository (GR node), Application Server IDE, AppEngine host"]
["Small Application","Minimum ",2,"2 GB","100 GB","1024 x 768","100 Mbps"]
["(1 - 25K I/O per Node)"]
[null,"Recommended ",4,"4 GB","200 GB","1920 x 1080","1000 Mbps"]
["Medium Application","Minimum ",4,"8 GB","200 GB","1024 x 768","1000 Mbps"]
["(25k - 50k I/O per Node)"]
[null,"Recommended ",8,"12 GB","500 GB","1920 x 1080","1000 Mbps"]
["Large Application","Minimum ",8,"16 GB","500 GB","1024 x 768","1000 Mbps"]
["(> 50k I/O per Node)"]
[null,"Recommended ",16,"24 GB","1000 GB","1920 x 1080","Dual 1000 Mbps"]
["Thin Client Node"]
["RDP clients, ITAA, mobile devices","Minimum ",1,"512 MB","N/A","800 x 600","100 Mbps"]
[null,"Recommended ",2,"2 GB","N/A","1280 x 1024","100 Mbps"]
["Client Node"]
["WindowViewer, ViewApp, Historian Client, Remote IDE","Minimum",2,"1 GB","100 GB","1024 x 768","100 Mbps"]
[null,"Recommended",4,"4 GB","200 GB","1920 x 1080","1000 Mbps"]
["Thin Client-Server Node","Basic RDS - Minimum",4,"8 GB","200 GB","1024 x 768","1000 Mbps"]
["RDS, ITAA Server","Basic RDS - Recommended",8,"12 GB","500 GB","1920 x 1080","1000 Mbps"]
["Supports up to five remote sessions","Large RDS - Minimum",8,"16 GB","500 GB","1024 x 768","1000 Mbps"]
[null,"Large RDS - Recommended",16,"24 GB","1000 GB","1920 x 1080","Dual 1000 Mbps"]
["All-In-One Node","Minimum",4,"8 GB","200 GB","1280 x 1024","100 Mbps"]
["All products on a single node","Recommended",6,"12 GB","500 GB","1920 x 1080","1000 Mbps"]
["1,000 I/O maximum"]
[]
["Server node type applies to Historian Server, Galaxy Repository node, and nodes hosting AppEngines."]
["In redundant environments, increase CPU and RAM to maintain a maximum of 40% typical resource utilization."]
[]
["Supported and Recommended Node Hardware Types"]
[]
["Product","Server Node","Thin Client- Server Node","Client Node","Thin Client","All-In-One"]
["Application Server"]
["Galaxy Repository","Preferred","Supported","Supported","No","Supported"]
["Application Engine","Preferred","Supported","Supported","No","Supported"]
["IDE","Preferred","Supported","Supported","RDP","Supported"]
["ViewApp Runtime","Supported","Supported","Preferred","ITAA/RDP","Supported"]
["InTouch Standalone"]
["WindowMaker (No Modern Apps)","Supported","Supported","Preferred","RDP","Supported"]
["WindowMaker (with Modern Apps)","Preferred","Supported","Supported","RDP","Supported"]
["WindowViewer / InTouch ViewApp (runtime only)","Supported","Supported","Preferred","ITAA/RDP","Supported"]
["InTouch for System Platform"]
["WindowMaker (with Managed Apps)","Preferred","Supported","Supported","RDP","Supported"]
["WindowViewer / InTouch ViewApp (runtime only)","Supported","Supported","Preferred","ITAA/RDP","Supported"]
["InTouch Access Anywhere"]
["InTouch Access Anywhere Server","Supported","Preferred","No","No","Supported"]
["InTouch Access Anywhere Client (HTML5 Browser)","Browser","Browser","Browser","Browser","Browser"]
["InTouch Access Anywhere Secure Gateway","Supported","No","No","No","No"]
["Historian"]
["Historian Server","Preferred","Supported","Supported","No","Supported"]
["Historian InSight Client ","Browser","Browser","Browser","Browser","Browser"]
["Historian Client (Active Factory)","Supported","Supported","Preferred","RDP","Supported"]
["Support Components"]
["OI Gateway","Preferred","Supported","Supported","No","Supported"]
["AVEVA Enterprise Licensing - Server","Preferred","Supported","Supported","No","Supported"]
["AVEVA Enterprise Licensing - Manager","Preferred","Supported","Supported","No","Supported"]
["AVEVA Enterprise Licensing - Manager Client","Browser","Browser","Browser","Browser","Browser"]
[]
[]
["Supported Operating Systems at Time of Release"]
["64-bit only"]
["System Platform Product / Component","Windows 8.1","SAC Windows 10 ","LTSC Windows 10","LTSC Windows Server"]
[null,"Pro/Enterprise","Pro/Enterprise/IoT Enterprise","Enterprise/IoT Enterprise ","See Windows Server Notes"]
["Application Server 2020","Supported",1803,2016,2012]
["Galaxy Repository",null,1809,2019,"2012 R2 (including Embedded)"]
["AppEngine / Platform / Bootstrap",null,1903,null,2016]
["IDE (including remote)",null,1909,null,"2019 (Desktop Experience)"]
["InTouch OMI ViewApp (run time)"]
["InTouch HMI 2020","Supported",1803,2016,2012]
["WindowMaker (no Modern apps)",null,1809,2019,"2012 R2 (including Embedded)"]
["WindowMaker (Modern apps)",null,1903,null,2016]
["WindowViewer (run time) / InTouchViewApp",null,1909,null,2019]
["InTouch Web Client (run time)"]
["InTouch for System Platform 2020","Supported",1803,2016,2012]
["WindowMaker (Managed Apps)",null,1809,2019,"2012 R2 (Embedded not supported)"]
["WindowViewer (run time) / InTouchViewApp",null,1903,null,2016]
[null,null,1909,null,"2019 (Desktop Experience)"]
["Historian Server 2020","Supported",1803,2016,2012]
[null,null,1809,2019,"2012 R2 (including Embedded)"]
[null,null,1903,null,2016]
[null,null,1909,null,"2019 (Desktop Experience)"]
["InTouch Access Anywhere Server 2020","Supported",1803,2016,2012]
["ITAA Client (HTML5 browser)",null,1809,2019,"2012 R2 (Embedded not supported)"]
["InTouch Access Anywhere Secure Gateway 2020",null,1903,null,2016]
[null,null,1909,null,"2019 (Desktop Experience)"]
["Other System Platform 2020 components / products","Supported",1803,2016,2012]
["Historian Client 2020",null,1809,2019,"2012 R2 (including Embedded)"]
["OI Gateway",null,1903,null,2016]
["System Management Server",null,1909,null,"2019 (Desktop Experience)"]
["AVEVA Licensing"]
["System Monitor Agent / Manager"]
[]
[]
[]
["Supported SQL Server Versions at Time of Release"]
["64-bit only"]
["System Platform Product / Component","SQL Server Express SSMSE","SQL Server"]
["Application Server 2020"]
["Galaxy Repository","2012 SP4 ","2012 Standard/Enterprise SP4"]
["AppEngine / Platform / Bootstrap","v11.0.7001.0 or higher","v11.0.7001.0 or higher"]
["IDE (including remote)"]
["InTouch OMI ViewApp (run time)","2014 SP3","2014 Standard/Enterprise SP3"]
["InTouch HMI 2020","v12.0.6024.0 or higher","v12.0.6024.0 or higher"]
["WindowMaker (no Modern apps)"]
["WindowMaker (Modern apps)","2016 SP2","2016 Standard/Enterprise SP2"]
["WindowViewer (run time) / InTouchViewApp","v13.0.5026.0 or higher","v13.0.5026.0 or higher"]
["InTouch Web Client (run time)"]
["InTouch for System Platform 2020","2017 Core","2017 Standard/Enterprise"]
["WindowMaker (Managed Apps)","v14.0.1000.169 or higher","v14.0.1000.169 or higher"]
["WindowViewer (run time) / InTouchViewApp"]
["Historian Server 2020","2019 Core","2019 Standard/Enterprise"]
["System Monitor Manager","v15.0.2000.5 or higher","v15.0.2000.5 or higher"]

{"sheet":"System Platform","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Revision Notes","index":9,"n_rows":4,"n_cols":14,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Rockwell Sizing Guides",null,null,"ztC Sizing",null,null,"ftServer Sizing",null,null,"Resource Guidelines",null,null,"Reference Links"]
["Version","Description",null,"Version","Description",null,"Version","Description",null,"Version","Description",null,"Version","Description"]
["1.1.0","Initial Release",null,"2.1.0","Initial Release",null,"10.3.0","Initial Release",null,"1.1.0","Initial Release",null,"1.1.0","Initial Release"]
["1.2",null,null,"2.2","Add \"GB\" to description",null,"11.0","Change ftServer data to Aquarius-C"]

{"sheet":"Data Elements","index":10,"n_rows":32,"n_cols":18,"rows_kept":32,"cut":false,"hidden":true,"merged":[[22,1,22,3],[1,1,1,3],[13,1,13,3],[26,7,26,8],[30,7,30,8],[31,7,31,8],[7,13,11,13],[8,12,11,12],[1,7,1,13],[20,7,20,8]]}
[]
[null,"FSE Contact Information",null,null,null,"Ethernet Port Options",null,"ftServer Resource Options",null,null,null,null,null,null,null,"Yes/No","OEM/Volume","CALs"]
[null,"Name","E-Mail Address:","Phone",null,null,null,"ftServer","Processors","vCPU","Memory","Disk Options","1Gb Ethernet","10Gb Ethernet",null,"Yes","OEM","Partner Supplied"]
[null,"George Kaszas","George.Kaszas@stratus.com","(978) 461-7157",null,"emb 1Gb 10 left",null,"ft2910",1,20,1280,"Empty",2,0,null,"No","Volume",5]
[null,"Gerald Ziegler","Gerald.Ziegler@stratus.com","(231) 288-3786",null,"emb 1GB 11 left",null,"ft4910",2,40,768,600,4,2,null,null,null,10]
[null,"Kenneth Petty","Kenneth.Petty@stratus.com","(404) 210-5806",null,"emb 1GB 10 right",null,"ft6910",2,72,640,1200,6,4,null,"Phone Home",null,15]
[null,"Peter Dali","Peter.Dali@stratus.com","(516) 205-9050",null,"emb 1GB 11 right",null,6410,null,null,512,800,8,6,null,"Internet",null,20]
[null,"Robert Zarr","Robert.Zarr@stratus.com","(954) 415-7246",null,"emb 10GB 10 left",null,null,null,null,320,null,10,null,null,"Dial-Up",null,25]
[null,"Steve Reardon","Steve.Reardon@stratus.com","(978) 793-2177",null,"emb 10GB 11 left",null,null,null,null,256,null,null,null,null,"None",null,30]
[null,null,null,null,null,"emb 10GB 10 right",null,null,null,null,128,null,null,null,null,null,null,35]
[null,"Tyler Laney","Tyler.Laney@stratus.com","(972) 330-6906",null,"emb 10GB 11 right",null,null,null,null,64,null,null,null,null,null,null,40]
[null,"Vignesh Velayuthan","Vigneswaran.Velayuthan@stratus.com","(917) 502-2061",null,null,null,"Recommended ftServer",{"$f":"IF(AND('ftServer Sizing'!$L$43<='Data Elements'!$J$4*HT_Allocation,'ftServer Sizing'!$M$43<='Data Elements'!$K$8,'ftServer Sizing'!$H$10='Data Elements'!$N$4,'ftServer Sizing'!$H$11='Data Elements'!$N$4),'Data Elements'!$H$4,IF(AND('ftServer Sizing'!$L$43<='Data Elements'!$J$5*HT_Allocation,'ftServer Sizing'!$M$43<='Data Elements'!$K$6),'Data Elements'!$H$5,IF(AND('ftServer Sizing'!$L$43<'Data Elements'!$J$6*HT_Allocation,'ftServer Sizing'!$M$43<='Data Elements'!$K$4),'Data Elements'!$H$6,\"Requires multiple servers. Please contact Stratus for assistance.\")))","v":"ft2910"},null,32,null,null,null,null,null,null,45]
[null,null,null,null,null,"PCI-1 10 0",null,null,null,null,null,null,null,null,null,null,null,50]
[null,"SE Contact Information",null,null,null,"PCI-1 11 0",null,"VMware Licenses",null,"Oper. Sys Options","Server Racks","Provisioning","H-T Allowances","Support"]
[null,"Name","E-Mail Address:","Phone",null,"PCI-1 10 1",null,"vSphere Essentials",null,"WinServer 2019","No","Thick",0.7,"Total Assurance"]
[null,"Cole Cranford","Cole.Cranford@stratus.com","(985) 285-2745",null,"PCI-1 11 1",null,"vSphere Essentials Plus",null,"WinServer 2016","24U","Thin",0.8,"System Assurance"]
[null,"David Ulmer","David.Ulmer@stratus.com","(660) 221-2720",null,"PCI-2 10 0",null,"vSphere Standard",null,"WinServer 2012 R2","38U",null,0.9,"Ext. Platform Support"]
[null,"Gary Fort","Gary.Fort@stratus.com",9095973439,null,"PCI-2 11 0",null,"vSphere Enterprise Plus",null,"Windows 10/8/7",null,null,1]
[null,"Ken Espiau ","Ken.Espiau@stratus.com","(602) 852-3073",null,"PCI-2 10 1",null,null,null,"Linux",null,null,1.1000000000000001]
[null,"Munsey Slack","munsey.slack@stratus.com","(978) 461-7476",null,"PCI-2 11 1",null,null,null,null,null,null,1.2]
[null,"Walter Hladun","Walter.Hladun@stratus.com",2014012650,null,"PCI-3 10 0",null,"WinServer 2016 Lic. Calculator",null,null,null,null,1.3]
[null,null,null,null,null,"PCI-3 11 0",null,"No. Physical CPUs",{"$f":"VLOOKUP(Recommended_ftServer,ftServer_CPU_Table,2)","v":1},null,null,null,1.4]
[null,"TAM Contact Information",null,null,null,"PCI-3 10 1",null,"No. Physical Cores",{"$f":"((VLOOKUP(Recommended_ftServer,ftServer_CPU_Table,3))/2)","v":10},null,null,null,1.5]
[null,"Name","E-Mail Address:","Phone",null,"PCI-3 11 1",null,"No. Virtual Machines",{"$f":"COUNTA('ftServer Sizing'!F21:F44)","v":2}]
[null,"Brad Betenson","Brad.Betenson@stratus.com","(602) 852-3113",null,"PCI-4 10 0",null,"No. 2-Core License Packs",{"$f":"IF((I24/2>=6),\"WinServer Datacenter\",ROUND((I24/2),0)&\" WinServer Standard Ed.\")","v":"1 WinServer Standard Ed."}]
[null,"Charlie Cornish","Charlie.Cornish@stratus.com","(602) 852-3163",null,"PCI-4 11 0"]
[null,"Chris Wendel","Chris.Wendel@stratus.com",9784617188,null,"PCI-4 10 1",null,"WinServer 2012 Lic. Calculator"]
[null,"Mike Oldano","Mike.Oldano@stratus.com","(201) 405-0860",null,"PCI-4 11 1",null,"No. Virtual Machines",{"$f":"COUNTA('ftServer Sizing'!G21:G44)","v":19}]
[null,"Tom Finizio","Tom.Finizio@stratus.com","(978) 461-7147",null,null,null,"No. Licenses",{"$f":"IF(AND(I28<12,I28>0),EVEN(I28)/2&\" Standard Edition\",1&\" Datacenter Edition\")","v":"1 Datacenter Edition"}]
[]
[null,null,null,null,null,null,null,"Recommended WinServ Lic."]
[null,null,null,null,null,null,null,{"$f":"IF('ftServer Sizing'!K11=\"WinServer 2012 R2 Lic.:\",'Data Elements'!I29,'Data Elements'!I25)","v":"1 WinServer Standard Ed."}]