Hi,
A few more functions and hopefully I can put this spreadsheet to bed
In my spreadsheet I have formulas highlighting equipment that has been missed, they are displayed in box L46:O54 in the take off. This is being worked out by formulas in the dependencies tab.
I have selected 'DL3MVBL' in I5.
The formulas in the dependency tabs mean that DL3SBL and DL3SUL are being flagged up.
DL3MVBL - this is the software base build
DL3SBL - this is a server license (and includes 10 intelligent device licences) and is needed if DL3MVBL is selected.
DL3SUL - this is an intelligent device license and is needed per intelligent device if DL3MVBL is selected.
However...
I need the L46:O54 box to tell me exactly how many licenses I need? I have created a column J in the 'Data' tab and have either marked each device with a 'Y' or left it blank. This indicates whether it's intelligent. For Example, the sheet I will upload shows 50 intelligent devices. I need the L46:O54 box to indicate that I need 1x DL3SBL, and 40x DL3SUL.
Many Thanks
Sam
Bookmarks