| Actually there a relatively easy way to check the memories but you would need the Excel spreadsheet that I wrote to do it. There is a macro behind it that adds a rather lengthy formula to the page that analyses whether there are overlaps and spaces for you. All you have to do is list up the memories using matworx export them into an excel sheet then cut and paste the data into my worksheet. If anyone can tell me how to post the worksheet along with the macro I'll let you all have the use of it!
Alternatively you can try pasting in the formulae which I will list below and drag and fill it on the worksheet but you will have to sort by the memory allocation column first.
The memory details should be in column D
=IF(D2="NONE","",IF(D2="DATA NOT FOUND","",IF(D2="DATA ERROR","",IF(VALUE(LEFT(D2,3))<(VALUE(LEFT(D1,3))) +(VALUE(RIGHT(D1,1))),"Overlap",IF(VALUE(LEFT(D2,3 ))=(VALUE(LEFT(D1,3)))+(VALUE(RIGHT(D1,1))),"",IF( VALUE(LEFT(D2,3))>(VALUE(LEFT(D1,3))+(VALUE(RIGHT( D1,1)))),"Space",))))))
Note that when you copy and paste this you may end up with unwanted spaces or carriage returns so make sure it goes in as one continuous line.
I also have one for finding screwups in call pickup groups but that is much to complicated to just post the formula for. |