{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["SIMULATOR","DATA"],"not_rendered":{"images":3,"macros":1,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"SIMULATOR","index":0,"n_rows":31,"n_cols":47,"rows_kept":31,"merged":[[0,0,0,43],[1,0,2,5],[1,6,1,23],[1,33,3,33],[1,34,1,35],[1,39,3,39],[1,40,1,43],[1,44,3,44],[1,45,3,45],[1,46,3,46],[2,6,2,11],[2,12,2,17],[2,18,2,23],[2,34,2,35],[2,40,2,41],[9,0,27,3],[13,5,14,6],[13,7,14,10],[13,31,47,42],[16,5,17,6],[16,7,17,10],[19,5,20,6],[19,7,20,10],[22,5,23,6],[22,7,23,10],[25,5,26,6],[25,7,26,10]]}
["XRACK - VIRTUAL MACHINE COSTS SIMULATOR - Excluding GST",{"$nulls":43},"Month to Month","12 Month Contract","36 Month Contract"]
["CELLS WITH A BLUE BORDER CAN BE CHANGED TO BUILD A VIRTUAL MACHINE",{"$nulls":5},"STORAGE",{"$nulls":26},"BASE\nMACHINE COST\nDC1\n(MONTHLY)","BACKUP*",{"$nulls":4},"TOTAL MACHINE COST\nDC1\n(MONTHLY)","WARM MACHINE IN DC2",{"$nulls":3},"TOTAL\nMACHINE COST\nDC1 + DC2\n(MONTHLY)","TOTAL\nMACHINE COST\nDC1 + DC2\n(MONTHLY)","TOTAL\nMACHINE COST\nDC1 + DC2\n(MONTHLY)"]
[{"$nulls":6},"DRIVE 1",{"$nulls":5},"DRIVE 2",{"$nulls":5},"DRIVE 3",{"$nulls":5},"NO","NO",{"$nulls":3},"WINDOWS SERVER","NO","NO",null,null,"NO",null,"NO","NO","NO",null,"NO",null,"NO","NO"]
["VM Name","VM Use Case","vCPU","RAM (GB)","vCPU\n($)","RAM\n($/GB)","DRIVE 1\n(GB)","DRIVE 1\nUSE CASE\n(Eg: Operating System)","DRIVE 1\nTIER LEVEL","DRIVE 1\nTIER TECHNOLOGY\nDESCRIPTION","DRIVE 1\nRAID\nLEVEL","DRIVE 1\n($)","DRIVE 2\n(GB)","DRIVE 2\nUSE CASE\n(Eg: User Profiles)","DRIVE 2\nTIER LEVEL","DRIVE 2\nTIER TECHNOLOGY\nDESCRIPTION","DRIVE 2\nRAID\nLEVEL","DRIVE 2\n($)","DRIVE 3\n(GB)","DRIVE 3\nUSE CASE\n(Eg: Data Store)","DRIVE 3\nTIER LEVEL","DRIVE 3\nTIER TECHNOLOGY\nDESCRIPTION","DRIVE 3\nRAID\nLEVEL","DRIVE 3\n($)","Virtual GPU","Unlimited Internet Data","Unlimited Storage Transactions","Intra Network Traffic & Infrastructure Levy\n(Priv. VLAN)","Compliance","Operating System","Microsoft\nSQL Server","Public IPv4 Adress","HOST POOL",null,"24 Hours of\n15 Min Replicas to Mass Storage\nMin 23 Held Per Day","Nightly Backup  of Replicas to DC2\nMultiple Copies","24/7 Operating System Support**","Operating System Maintenance","Machine Monitoring & Alerts",null,"Warm DR Replica Machine in DC2*** + Backup","Warm DR Unlimited\nTransit Data between DC1 and DC2","Warm DR Unlimited Internet Data DC2","Public IPv4 Adress"]
[{"$nulls":4},{"v":12.05,"d":"$12.05"},{"v":3.99,"d":"$3.99"},{"$nulls":18},{"v":90,"d":"$90.00"},{"v":0.05,"d":"5.00%"},{"v":0.2,"d":"20.00%"},{"v":0.03,"d":"3.00%"},{"v":0.055,"d":"5.50%"},{"v":36,"d":"$36.00"},{"v":98,"d":"$98.00"},{"v":45,"d":"$45.00"},{"$nulls":4},{"v":0.18,"d":"18.00%"},{"v":0.075,"d":"7.50%"},{"v":0.04,"d":"4.00%"},null,{"v":0.75,"d":"75.00%"},{"v":0.15,"d":"15.00%"},{"v":0.035,"d":"3.50%"},{"v":45,"d":"$45.00"}]
[{"$nulls":4},{"$f":"+C6*E$5","v":0},{"$f":"+D6*F$5","v":0},null,null,"NONE",{"$f":"IF($I$6=DATA!A2,DATA!B2,IF($I$6=DATA!A3,DATA!B3,IF($I$6=DATA!A4,DATA!B4,IF($I$6=DATA!A5,DATA!B5,\"\"))))","v":""},{"$f":"IF($I$6=DATA!A2,DATA!C2,IF($I$6=DATA!A3,DATA!C3,IF($I$6=DATA!A4,DATA!C4,IF($I$6=DATA!A5,DATA!C5,\"\"))))","v":""},{"$f":"IF($I6=\"TIER 1\",($G6*DATA!D2),(IF($I6=\"TIER 2\",($G6*DATA!D3),(IF($I6=\"TIER 3\",($G$6*DATA!D4),IF($I6=\"TIER 4\",($G6*DATA!D5),))))))","v":0},null,null,"NONE",{"$f":"IF($O$6=DATA!A2,DATA!B2,IF($O$6=DATA!A3,DATA!B3,IF($O$6=DATA!A4,DATA!B4,IF($O$6=DATA!A5,DATA!B5,\"\"))))","v":""},{"$f":"IF($O$6=DATA!A2,DATA!C2,IF($O$6=DATA!A3,DATA!C3,IF($O$6=DATA!A4,DATA!C4,IF($O$6=DATA!A5,DATA!C5,\"\"))))","v":""},{"$f":"IF($O6=\"TIER 1\",($M6*DATA!D2),(IF($O6=\"TIER 2\",($M6*DATA!D3),(IF($O6=\"TIER 3\",($M$6*DATA!D4),IF($O6=\"TIER 4\",($M6*DATA!D5),))))))","v":0},null,null,"NONE",{"$f":"IF($U$6=DATA!A2,DATA!B2,IF($U$6=DATA!A3,DATA!B3,IF($U$6=DATA!A4,DATA!B4,IF($U$6=DATA!A5,DATA!B5,\"\"))))","v":""},{"$f":"IF($U$6=DATA!A2,DATA!C2,IF($U$6=DATA!A3,DATA!C3,IF($U$6=DATA!A4,DATA!C4,IF($U$6=DATA!A5,DATA!C5,\"\"))))","v":""},{"$f":"IF($U6=\"TIER 1\",($S6*DATA!D2),(IF($U6=\"TIER 2\",($S6*DATA!D3),(IF($U6=\"TIER 3\",($S$6*DATA!D4),IF($U6=\"TIER 4\",($S6*DATA!D5),))))))","v":0},{"$f":"IF(Y3=\"YES\",90,)","v":0},{"$f":"IF(Z3=\"YES\",(Z5*(X6+R6+L6+F6+E6)),)","v":0},{"$f":"(L6+R6+X6)*AA5","v":0},{"$f":"(X6+R6+L6+F6+E6)*AB$5","v":0},{"$f":"(X6+R6+L6+F6+E6)*AC$5","v":0},{"$f":"IF(L6>0,IF(AD3=\"OTHER\", , AD5*C6),)","v":0},{"$f":"IF(AD6>0,IF(AE3=\"YES\",AE5*C6,),)","v":0},{"$f":"IF(AF3=\"YES\",IF(Z3=\"YES\",AF5,),)","v":0},{"$f":"IF(AE6>0,\"MS SQL\",IF(AD6>0,\"WINDOWS\",\"LINUX\"))","v":"LINUX"},{"$f":"AF6+AE6+AD6+AC6+AB6+AA6+Z6+Y6+X6+R6+L6+F6+E6","v":0},{"$f":"IF(AI3=\"YES\",IF(L6>0,((S6+M6+G6)*DATA!D2*1.2),),)","v":0},{"$f":"IF(AI3=\"YES\",IF(L6>0,(((S6+M6+G6)*DATA!D2)*1.8),),)","v":0},{"$f":"IF(AK3=\"YES\",IF(AD6>0,IF(AI3=\"YES\",(AK5*(AH6-AE6)),),),)","v":0},{"$f":"IF(AL3=\"YES\",IF(AD6>0,IF(AI3=\"YES\",AL5*(AH6-AE6),),),)","v":0},{"$f":"IF(AM3=\"YES\",AM5*(AH6-AE6),)","v":0},{"$f":"SUM(AH6:AM6)","v":0},{"$f":"IF(AO3=\"YES\",IF(AI6>0,($AO$5*(AH6-AE6-AD6)),),)","v":0},{"$f":"IF(AO3=\"YES\",IF(AI6>0,($AP$5*(AH6-AE6-AD6)),),)","v":0},{"$f":"IF(AQ3=\"YES\",IF(AO6>0,($AQ$5*AO6),),)","v":0},{"$f":"IF(AR3=\"YES\",IF(AQ6>0,AR5,),)","v":0},{"$f":"SUM(AN6:AR6)","v":0},{"$f":"AS6*0.9","v":0},{"$f":"AS6*0.75","v":0}]
[{"$nulls":17},"References to DC1 and DC2 represent data centres that are independently provisioned for power and geographically seperated by not less than 1000 meters"]
[{"$nulls":17},"* See link for more information including data rention periods",{"$nulls":3},"https://x.direct/1/en/topic/disaster-recovery-protocols-drp"]
["INSTRUCTIONS - Please Read",{"$nulls":6},"OTHER INCLUSIONS",{"$nulls":9},"** Operating System Support - is only for machines running Windows server 2016, Windows 10 or higher"]
["Hello,\n\nUsing this spreadsheet you can build up a virtual machine to meet your requirements.\n\nEnter data into any cell that has a BLUE border.\n\nSome of the cells with RED borders have drop down selections indicated by this logo:\n\nTo start a new line in any of the cells, hold down the \"ALT\" key and press the \"ENTER\" key.\n\nOnce you have completed this page, email the file to the following email address and a ticket will be raised to complete creation of your new virtual machine.\n\nEMAIL this file to: SUPPORT@XSTRAGROUP.COM\n\n",{"$nulls":6}," - 24/7 ACCESS",{"$nulls":9},"*** DR Replica hardware has a lower spec than production hardware "]
[{"$nulls":7}," - AUSTRALIAN BASED DATA CENTRES",{"$nulls":9},"Disk volume size increases can be co-ordinated through our Service Desk by raising a ticket and there is no cost for this. Excluding operating system volumes, Disk volume size decreases can be done but are more involved and will be billed at our standard Schedule 1 Rates & Charges"]
[{"$nulls":7}," - RESERVED INSTANCE",{"$nulls":9},"If a cell in this spreadsheet does not have a $ value greater than $0 then the applicable feature is NOT part of the machine configuration"]
[{"$nulls":17},"If the Client requests XSTRA to recover data from backups the following fee structure shall apply: ",{"$nulls":13},"ADDITIONAL NOTES & REQUIREMENTS",{"$nulls":3},"To start a new line hold down the \"ALT\" key and press the \"ENTER\" key"]
[{"$nulls":5},"DATE",{"$nulls":11},"All resource allocations are subject to XSTRA's fair use assessments at XSTRA's discretion"]
[]
[]
[{"$nulls":5},"COMPANY NAME"]
[]
[]
[{"$nulls":5},"YOUR NAME"]
[]
[]
[{"$nulls":5},"YOUR EMAIL ADDRESS"]
[{"$nulls":16},"Only need rackspace? We have you covered:"]
[]
[{"$nulls":5},"YOUR CONTACT NUMBER"]
[]
[]
[]
[]
["Version:",20210303]

{"sheet":"DATA","index":1,"n_rows":5,"n_cols":4,"rows_kept":5,"hidden":true}
["NONE"]
["TIER 1","SATA 7.2K RPM Hard Drive","RAID 5",0.03]
["TIER 2","SATA 7.2K RPM Hard Drive","RAID 6/10",0.05]
["TIER 3","SAS 15K RPM Hard Drive","RAID 10",0.08]
["TIER 4","Solid State Drive (SSD)","RAID 10",0.2]