6 kyu
Get the Excel column title!
176 of 463goodwin64
Loading description...
Algorithms
.avif)
This comment has been reported as {{ abuseKindText }}.
Show
This comment has been hidden. You can view it now .
This comment can not be viewed.
- |
- Reply
- Edit
- View Solution
- Expand 1 Reply Expand {{ comments?.length }} replies
- Collapse
- Spoiler
- Remove
- Remove comment & replies
- Report
{{ fetchSolutionsError }}
-
-
Your rendered github-flavored markdown will appear here.
-
Label this discussion...
-
No Label
Keep the comment unlabeled if none of the below applies.
-
Issue
Use the issue label when reporting problems with the kata.
Be sure to explain the problem clearly and include the steps to reproduce. -
Suggestion
Use the suggestion label if you have feedback on how this kata can be improved.
-
Question
Use the question label if you have questions and/or need help solving the kata.
Don't forget to mention the language you're using, and mark as having spoiler if you include your solution.
-
No Label
- Cancel
Commenting is not allowed on this discussion
You cannot view this solution
There is no solution to show
Please sign in or sign up to leave a comment.
It's difficult understanding some katas like this one, challenging.
Random tests should also generate invalid cases (at least 30-50% of the time) and not just rely on fixed and sample tests (presumably all languages)
Missing fixed, sample and random tests for cases below:
n = true / false
n is a floating-point number (
1.23)python new test framework is required. updated in this fork
Ruby 3.0 should be enabled.
I'd suggest updating the description to have the Markdown headings rendered properly.
Correct syntax:
#Examples Python, Ruby:=># Examples Python, Ruby:As a minor improvement, code blocks could be annotated with specific language: Syntax:
Hi, thanks for the suggestion!
#1is fixed,#2is not actual because there are no code examples as is, but result of code invocation in console.Python 3 should be enabled.
Already done
JS: The logs for the random number tests are wrong:
Result for 210 (expected A):The string shown in the log is not the expected value, but rather the value returned by the function.
Fixed
@goodwin64, seeing your CodeEval screenshot further on down in the discourse I wanted to say that I am also a CodeEval user and had solved their version a while back, but theirs only goes up to ZZZ. I haven't finished with yours yet, but using Python am seeing some weird stuff in the output log with medium random numbers, as shown here:
Really a good kata. Feeling it as 5 kyu. In the check of "medium random numbers", I got 'CMNN' and I saw Result for 61896 (expected CMNN). So that's the correct result. But what is 'Re-complement: 61894 should equal 61896'? It's failed, why? thanks [Python]
Thanks for response! As I tested, the result for 61896 is CMNP, not CMNN:
Or am I misunderstood your question?
Great kata!, thank you for it!! I have the same problem. I manually checked the expected output from my script and the test and it is the same:
Log: Result for 276566 (expected ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZCD): Re-complement: 372459756756357562986387763880035959872579720173698638852531996811214534411852649703269355986059663892536430019369012662876029014757139137404159340940236985295654612397188270100619585319152469820997417320336673178543792021880120601080512425241309826457018097144789980091100215589095705985594957227818443100072600757837831884219060013375379452092040079213109369649731192236271181490218149428185888003756386334382118247916761580162639055909910776946615064413020859708441444722383355642297891069139413527291107755439301855638471552952591132075766130843088720693191001651218266528457066L should equal 276566
STDERR: Traceback: in in test_numbers File "./frameworks/python/cw-2.py", line 28, in assert_equals expect(actual == expected, message, allow_raise) File "./frameworks/python/cw-2.py", line 18, in expect raise AssertException(message) cw-2.AssertException: Re-complement: 372459756756357562986387763880035959872579720173698638852531996811214534411852649703269355986059663892536430019369012662876029014757139137404159340940236985295654612397188270100619585319152469820997417320336673178543792021880120601080512425241309826457018097144789980091100215589095705985594957227818443100072600757837831884219060013375379452092040079213109369649731192236271181490218149428185888003756386334382118247916761580162639055909910776946615064413020859708441444722383355642297891069139413527291107755439301855638471552952591132075766130843088720693191001651218266528457066L should equal 276566
Output of my script: ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZCD
Thank you in advance!
[Can't reply @goodwin64's comments. Had to reply mine] Another example, The input number was 395195, I returned VLOS. And I saw "expected VLOS" (marked as yellow below). I returned what was expected. But it's still failed.
C#-Translation kumited!
https://www.codewars.com/kumite/57d922a51a62824fa600101d
Please check and approve it! ;-)
Hi goodwin64.
I've tried to solve this kata and have got some strange errors while submit my solution. They looks like:
Check medium random numbers Log 77024 Result for 77024 (expected EJXL): ✘ Re-complement - Expected: 77024, instead got: 95276 === and many other similar messages.
When I'm running local tests with the same test case I'm getting successfull result message:
Test Results: Example tests Log 77024 ✔ Test Passed: Value == 'EJXL' Completed in 5ms You have passed all tests! :) ===
Can you help me with this strange issue ?
Hi tvolf!
Please specify the programming language that you accepted on solving this Kata. (I'm author of Pythons and Javascript versions, other versions are provided not by me)
Hi goodwin64.
I use Javascript to solve this kata.
@goodwin64, can you see this one?
Wow! Where did you find it? :hushed:
In the list of pending translations; for some reason sometimes the author misses a few, I think it is a bug.
This comment has been hidden.
What's the language you're talking about?
Also, try to directly submit your code ignoring example test cases.
I've just opened "Trainer" and I see that my edits haven't been updated. Maybe, the codewars' bug.
At first, actual and expected values were swapped in example test cases.
If you are talking about the example test cases, they are not updated for users who already attempted the kata (if so, it would overwrite their own tests, provided they wrote some).
Also, notice you still have a Haskell translation pending; approve it if you wish, otherwise any edit to the description might give troubles later :)
Oh, my friend said that he has proposed Haskell translation, but I don't see it.
I saw his Java translation and your Ruby one, but didn't saw the Haskell version O_o
Where can I find it?
My solution passed this test correctly so it seems that you make a mistake in your code.
I use Java. The issue was with example test cases. Thank you for answer.
Duplicate: http://www.codewars.com/kata/generate-excel-column-names
I found this task on codeeval at half past February:
When I was solving it, I found the following article on support.microsoft.com:
https://support.microsoft.com/en-us/kb/833402 where an algorithm, that for some input numbers is not working properly, was filed.
I wrote my own solution (later I found another solution on StackOverflow) and sent it to Microsoft support. It will be attached below because it has a spoiler.
I have not received a reply for 2 weeks so I decided to publish this Kata on codewars and... voilà! The "alaudo" newbie with only 3 completed Katas published this task here. That's a coincidence: alaudo works at Microsoft.
I wouldn't be against to expand alaudo's Kata by writing translations, but he didn't put a tick next to "allow conributors", so I haven't had the opportunity to supplement his Kata at the time of the publication of my Kata.
My description and test cases are more extensive and readable and I gave the proof that my task is not plagiary (including codewars Katas, not codeeval) so I mark your issue as resolved.
This comment has been hidden.
Also, I'm open to accept alaudo's translation on my Kata.
Wrong output of testcases (JS): "expected" switched with "user result";-)...
This comment has been hidden.
This comment has been hidden.
This comment has been hidden.
One more hint.
You can use the following formulas in Excel to check yourself: