Fix your data type processing to accept blank as a numeric 0 for numeric fields. Add more excel functions like "isodd"
Your data typing rejects blank in numeric fields as alpha. WRONG, should be 0.
You need a more complete representation of EXCEL functions. Like ISODD
1
vote
![](https://secure.gravatar.com/avatar/76d485cb1db9c5f780ab3f3500173491?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)