search

tomas3svoboda / ChroMo

Chromatography model determination
2 stars 0 forks source link

Excel formating #23

Closed svoboad3 closed 2 years ago

svoboad3 commented 2 years ago

I have found out a problem with Excel formating in our test set. For some reason, when I write decimal number not beginning with 0 with comma instead of dot into excel, it interprets it as not decimal number (e.g. 18,823 is interpreted as 18823). Not sure if it's problem just on my PC. Anyway it explains why some calculations seemed to return weird values for me.

I can't fix that in program (unless we want to do something like "if number too big -> divide it by 1000") so we need to make sure the excel format is correct.

meloun67 commented 2 years ago

It is in the excel setup

image

do we then make a rule "USE DOT AS A DECIMAL SEPARATOR" ?

svoboad3 commented 2 years ago

Both comma and dot should work fine, I just need to not have comma or dot as thousands separator.

meloun67 commented 2 years ago

Both comma and dot should work fine, I just need to not have comma or dot as thousands separator.

So if Thousand separator is nothing in excel options everything works fine?

svoboad3 commented 2 years ago

yep