Hi. I can only do the basic stuff with Excel so I hope to get help from the advanced Excel users in this forum.
work with textiles, clothes in particular, and it's production includes obviously measurement specifications for body length,
sleeve length, chest, waist, neck widths and so on...with grading for every different sizes (S, M, L, XL), besides materials
and acessories specs, etc.
It´s very common to have these size measurement charts in excel (see attached Report)
and the differences found when checking samples for approval or production, are noted down for reference and eventually to
determine corrections to be made.
I recently started to try Nuance Dragon Naturally Speaking (DNS) to dictate
numbers into Excel.
Using DNS, I tried and succeeded to input in Excel the differences found when measuring
garments, by dictating plus or minus 1 or 0.5 or whatever difference found in relation to spec, but the process was
complicated because I allways had to dictate the difference found + "press enter" everytime in the end to enter
data in the cells.
Then I tried and succeded with DNS command scripts, but it was also complicated as it meant
having a different script assigned for each of the typical differences (plus or minus 0.5, 1, 1.5, 2, 2.5, 3...) and
executing according to what was found.
Finally I thought: the best way to do it would be dictating the exact
measurement found and have some sort of script or macro to account the difference between spec and measurement found and
"enter" the plus or minus difference in the cell, even if it was + 0.8 or - 1.3.
I imagine this could
be done by having a formula on the cells depending on a variable value. The variable value would be the exact measurement
given by the DNS dictation and the formula would then execute and move to the adjacent cell down for the next measurement.
Example on Report: chest width, size S is defined 44. Cell G8 would have a formula like =(F8-V), variable being V.
If we got 45 as real measurement than V=45 and that would make cell formula =(44-45) result -1.
dictating 45 is not the biggest issue here, so it remains a pure Excel problem so far. How to get the + or - result value in
a cell, inputting the real value found to replace the variable V and make formula execute.
45 is in fact + 1 in
relation to spec 44 so, this means that all minus results should become plus signs and the opposite is also true. If real
measurement was 43, then, result of formula (44-43=1). Positive 1 meaning in fact -1 in relation to spec.
way, I need to have the + and - signs together with the number in the cells and the way I found it to work was formatting the
cells where the differences have to be filled in, as text (columns G,H,J,K,M,N, P,Q).
I do not know if there is a
better way, or if this complicates things because the method I am describing means having a calc formula in those cells.
Again, I repeat: although my plan is to dictate the values they could be typed as well. How to solve the Excel part
is the problem for me.
Can anyone help me out on this? Any suggestion or hints to try.