Why do recreated uploads cause errors?

Problem: When creating an upload file that starts based on an existing Blockly model (Such as a model that does not have an existing upload file), some formulas do no work on a new upload such as the Excel functions MIN and Max. This even though the formulas exist and work if created in Blockly. The same is true for any new upload model.

Solution: Break the Functions into separate formulas

MIN Example

= MIN(Variable1,Variable 2)

Do this instead:

=Variable1

=Variable2

=IF(Variable1<Variable2,Variable1,Variable2)

MAX Example

= MAX(Variable1,Variable 2)

Do this instead:

=Variable1

=Variable2

=IF(Variable1>Variable2,Variable1,Variable2)

Alternate Solution: Create the formula in Blockly