Other Parts Discussed in Thread: AM2732
Tool/software:
Hello,
It seems that the Total Power estimated by the AM2732 Power Estimation Spreadsheet SPRM803 remains #N/A irrespective of user input.
Kind Regards,
D.T
This thread has been locked.
If you have a related question, please click the "Ask a related question" button in the top right corner. The newly created question will be automatically linked to this question.
D.T,
I just downloaded the AM273 PET zip file (SPRM803) and was able to validate the tool works as expected, with power numbers changing on the fly based on user input.
Did you unzip the the zip file before opening the .xlsx file? I have seen issues if you are trying to open and use the .xlsx file from within the zip folder without unzipping first.
If this doesn't help, can you post a screenshot of what you are seeing in excel?
Thanks,
Mike
Hi Mike,
Thank you for the feedback. I have tried to uzip the file before opening but the issue persists. All power consumption cells always report #N/A irrespective of changing the yellow colored user cells as shown in the attached picture.
I am using Excel for Microsoft 365 MSO.
Thank you,
Dimitris
Hi Dimitris,
Just to be sure there aren't any artifacts or something from previous versions, can you download a new version of the zip file, saved in a different location, unzip the excel document and open it up to try again?
If the problem persists with the above, can you send a full screenshot of the excel window, showing the tool bars and everything at the top along with the status bars / etc at the bottom?
Thanks,
Mike
Hi Mike,
I have downloaded a new version and saved the .zip file in a different location and the .xlsx file was unzipped before opening, however the same #N/A issue seem to persist.
I have also enabled the macro content after right-clicking on .xlsx file -> Properties and to the best of my knowledge, the corresponding macro enabling options are all green in the corresponding Trust Center forms of the Options Tree.
Attaching a full picture of the PET .xlsx with some of the yellow fields modified to check its functionality.
Kind Regards,
Dimitris
Dimitris,
Can you try modifying your system separators (File -> Options -> Advanced) as shown below and see if that helps?
Thanks,
Mike
That was it!
The spreadsheet is fully functional after unchecking the Use system separators option .
Thank you very much Mike!
Dimitris