So I had given up on this but it bothers me not to have finished it.
I have submitted several times, and I get all items completed, but only 1 or 2 correct. How can that be? If it was file name or something like that which failed them, it would fail all of them. But for some reason I am getting one or two correct. Any suggestions as to what could make that behavior? Can´t seem to find anything wrong with my final reports…
I tried going through all of this, and as far as I can see it seems ok. Now the part that I find confusing is that the order of the columns seems to vary from one report to another. Some have the date in third place, some last. And it´s not even the same for all from the same customer. I have tried adding a column sorter putting them all either with date in third or last place, but then I get 0 correct. I have a feeling the problem is related to that… but I don´t know how to solve it. The description of the assignment does not specify the column order or format.
I really can´t understand why the robot checking this can´t give more specific information though. Should be simple since it seems it obviously checks some criteria… should be a no-brainer to be able to report which didn´t pass
I checked the updates and they seem fine. All the WI4 items are marked as completed, each with their individual ids all with a length of 32 characters and no spaces after.
However the reports do differ in column order. Any one who have cleared this can enlighten me on how you have done this?
I reset the data (for the nth time) and run the thing again, and resubmitted again… figured I´d post the resulting excel files so that you can give me some feedback, but the evaluation robot seems stuck cause it´s not returning…
Did you clear the Temp folder after resetting your data (before running it)? If Im not wrong the excel files generated must be exact with the test datas. So if there are other excel files that doesnt tally with the test data, the score will be affected.
So I finally got my evaluation back, and it´s the same as the others. 16 items completed out of the 16. Only 1 correct.
Still convinced that this has something to do with the actual reports, maybe the column name ordering i the issue.
Can anyone who has actually cleared this exercise tell me what they did about this column ordering? Or take a look at my files, I am enclosing my final result. Notice that the column order varies, but doesn´t match with the number of correct items though.