question

sunwisegwh avatar image
sunwisegwh asked

Smart Solar Regulators Excel Calculator SpreadSheet with 450/100/200???

Has anyone got the code to unprotect the VE MPPT Calc - Smart Solar Regulators Excel Calculator Spread Sheet so I can add in the 450/100/200???

MPPT Controllers
4 comments
2 |3000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 8 attachments (including images) can be used with a maximum of 190.8 MiB each and 286.6 MiB total.

sunwisegwh avatar image sunwisegwh commented ·

Went to online link - see below - to see if it works with 450/100/200 regs and it does not work - as soon as the PV VOC exceeds 30V it wigs out so not usable for 450/100 or 450/200 regs

I got into the excell spread sheet - but cant adjust it fr 450/100-200 regs - is there some way I can upload the spread sheet


https://mppt.victronenergy.com/#djM7ZXlKdVlXMWxJam9pVUdWeWRHZ2dWMEVzSUVGMWMzUnlZV3hwWVNJc0lteGhkQ0k2TFRNeExqazFNak14TWpNc0lteHVaeUk2TVRFMUxqZzJNVE13T1gwPTtleUptWldGMGRYSmxjeUk2V3lKMlpVTmhiaUpkTENKMFpYSnRhVzVoYkNJNlptRnNjMlVzSW1Gc2JHOTNUM1psY25OcGVtVmtJanAwY25WbGZRPT07Y3VzdG9tLDEwLDEsNTQsLTUsNjQsNDgsMTMuMzUsMC4wNCwxNC4wMiw0MTUsMzEuMSwtMC4zMywzNy40LDE1LDQ7Y3VzdG9tLDEwLDEsNTQsLTUsNjQsNDgsMTMuMzUsMC4wNCwxNC4wMiw0MTUsMzEuMSwtMC4zMywzNy40LDE1LDQ=

0 Likes 0 ·
Matthias Lange - DE avatar image Matthias Lange - DE ♦ sunwisegwh commented ·
Your problem are the settings for "VE.Can" and "MC4" remove that and you get a result.
0 Likes 0 ·
sunwisegwh avatar image sunwisegwh commented ·
Got into mppt excel victron calculator - 450/200 is not listed in the spread sheet - has anybody got a fix for this
0 Likes 0 ·
Matthias Lange - DE avatar image Matthias Lange - DE ♦ sunwisegwh commented ·

Just do the calculations twice.

The 450/200 is the same as 2x 450/100.

0 Likes 0 ·
2 Answers
kevgermany avatar image
kevgermany answered ·

Unprotecting the code won't happen.

Are you sure they're not in there?

They are in the online calculator.

https://www.victronenergy.com/mppt-calculator

I'll report to Victron for you.

4 comments
2 |3000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 8 attachments (including images) can be used with a maximum of 190.8 MiB each and 286.6 MiB total.

sunwisegwh avatar image sunwisegwh commented ·
Many Thanks Kev - found the current spread sheet - any ideas how to unlock it - cant get it to populate the 450/200 reg
0 Likes 0 ·
sunwisegwh avatar image sunwisegwh commented ·
The spread sheet has an issue with selecting the qty of paralel panels - u can only increase - it will not reduce - both up/dow button insrease paralell strings
0 Likes 0 ·
Matthias Lange - DE avatar image Matthias Lange - DE ♦ sunwisegwh commented ·
What program do you use?

I have no problem with Excel 2019

0 Likes 0 ·
sunwisegwh avatar image sunwisegwh commented ·
Yes certain - there is no 450/200 in there - have to duplicate 450/100 design and assume its OK
0 Likes 0 ·
Matthias Lange - DE avatar image
Matthias Lange - DE answered ·

Are you sure you have the latest version 4.0 of the Excel sheet?

1679128494278.png

https://www.victronenergy.com/support-and-downloads/software
At the very bottom.


1679128494278.png (126.4 KiB)
2 comments
2 |3000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 8 attachments (including images) can be used with a maximum of 190.8 MiB each and 286.6 MiB total.

ejrossouw avatar image ejrossouw commented ·

The latest excel only contains the 450/1001679238362773.png

0 Likes 0 ·
1679238362773.png (74.1 KiB)
Guy Stewart (Victron Community Manager) avatar image Guy Stewart (Victron Community Manager) ♦♦ ejrossouw commented ·

Hi @ejrossouw,

The MPPT RS 450/200 will not be added to excel calculator - the 4 trackers adds considerable complexity to the model. It's possible to work around the limitation with the 450/100 twice :)

It is now recommended to use the web based calculator which does include the 450/200.

0 Likes 0 ·