I have a spreadsheet to calculate the number of physical servers required to support an application in a mixed business / residential environment. And can’t seem to make it work when I have a mixed percentage of Business and Residential users.
Facts:
1 – Node will support a maximum of 150,000 subscribers for Bus or Res.
2 – Each node has 1 standby server
3 – For Bus, each device will support 20,000 subs to a maximum of 8 servers per node +1 standby server.
4 – For Res, each server will support 40,000 subs to a maximum of 4 servers per node +1 standby server.
Where I am having trouble (an understatement) is when I have more than one node in a mixed Bus / Res mode. My formulas are as follows:
I35 = Number of subscribers
I36 = Number of nodes required
F37 = Percentage of residential users
Business
=IF(AND(B37="Yes",C37="N+1",$I$35>150001),ROUNDUP((I35-(I36-1)*150000)/20000,0)+1+ROUNDUP((I36-1),0)*9,0)
Residential
=IF(AND(B37="Yes",C37="N+1",E37="Yes",I35<150001),ROUNDUP(I35/40000,0)+1,0)
I cannot seem to get my formula for calculating the number of servers required in a mixed environment, 50% residential. <banging head here>
For less than one node I am using this formula,
=IF(AND(B37="Yes",C37="N+1",E37="Mixed",I35<150001),ROUNDUP((((I35*F37)/200/200)+((I35*(1-F37))/100/200)),0)+1,0)
But I cannot get it to work correctly for the multiple nodes formula
Any help will be Greatly Appreciated
Thanks in advance,
Jesse
Facts:
1 – Node will support a maximum of 150,000 subscribers for Bus or Res.
2 – Each node has 1 standby server
3 – For Bus, each device will support 20,000 subs to a maximum of 8 servers per node +1 standby server.
4 – For Res, each server will support 40,000 subs to a maximum of 4 servers per node +1 standby server.
Where I am having trouble (an understatement) is when I have more than one node in a mixed Bus / Res mode. My formulas are as follows:
I35 = Number of subscribers
I36 = Number of nodes required
F37 = Percentage of residential users
Business
=IF(AND(B37="Yes",C37="N+1",$I$35>150001),ROUNDUP((I35-(I36-1)*150000)/20000,0)+1+ROUNDUP((I36-1),0)*9,0)
Residential
=IF(AND(B37="Yes",C37="N+1",E37="Yes",I35<150001),ROUNDUP(I35/40000,0)+1,0)
I cannot seem to get my formula for calculating the number of servers required in a mixed environment, 50% residential. <banging head here>
For less than one node I am using this formula,
=IF(AND(B37="Yes",C37="N+1",E37="Mixed",I35<150001),ROUNDUP((((I35*F37)/200/200)+((I35*(1-F37))/100/200)),0)+1,0)
But I cannot get it to work correctly for the multiple nodes formula
Any help will be Greatly Appreciated
Thanks in advance,
Jesse