Coordinate conversion



  • The requirement: "Draw a MGRS coordinate grid on the 2D map, it must regenerate after zoom level changing so that there is always a grid on the map."



    According to the Powers That Be, this is an insanely simple task. We've done it before! Just pull the code from the old software and use that! Nevermind that the old software was written in C, and this is C#. Any source code is better than no source code, right?


    Except... there is no source code. Turns out, the old software that had grids? Yeah. Someone hand drew them onto the map tiles using Paint.


    And yes, I did ask the guy who drew them before if he'd do it again. What he said pretty much boiled down to, "No".


    I'm going to the bar.



  • @CodeNinja said:

    I'm going to the bar.
     

    When you sober up, check out... http://www.developerfusion.com/project/15393/geoutility-library/

     



  • This could be done with Excel, a few clever formulas and a little bit of VBA magic.



  • <font size="4">Excel does it again!</font>




  •  Bar....Guinness...Excellent



  • @Ronald said:

    This could be done with Excel, a few clever formulas and a little bit of VBA magic.

     What in the world does that have to do with Excel?  That just happens to be what he implemented the formulas in to convert the numbers.  I don't remember the OP saying that was the problem.


  • @El_Heffe said:

    <font size="4">Excel does it again!</font>


    Excel and Go together... even better!



  • @Sutherlands said:

    @Ronald said:

    This could be done with Excel, a few clever formulas and a little bit of VBA magic.

     What in the world does that have to do with Excel?  That just happens to be what he implemented the formulas in to convert the numbers.  I don't remember the OP saying that was the problem.

    you asked for it...



  • If there's no requirement to interact with the grid or turn it off and on - if all it needs to be is displayed - then making it part of the map tiles is actually not a terribly stupid approach, and may in fact be your path of least work. Paint is the wrong tool, though; I would have thought scripting the map tile edits with something like ImageMagick would get you a cleaner and more maintainable result.



  • @Ronald said:

    This could be done with Excel, a few clever formulas and a little bit of VBA magic.

    Do you want to give someone an Epileptic Fit?


  • ♿ (Parody)

    @Sutherlands said:

    What in the world does that have to do with Excel?  That just happens to be what he implemented the formulas in to convert the numbers.  I don't remember the OP saying that was the problem.

    Fucking Excel deniers make me sick. Get over your stupid prejudice and learn a bit about the real world you ivory tower bigot. Excel is the obvious choice because you can be sure someone in the office is already using it!



  • @boomzilla said:

    Fucking Excel deniers make me sick.
    It's the Internet. Excel-deniers and Anti-bassoonites.



  • @Sutherlands said:

    What in the world does that have to do with Excel?  That just happens to be what he implemented the formulas in to convert the numbers.  I don't remember the OP saying that was the problem.
    Oh, come on! It's so obvious. Excel has to grid lines standard on the display. All you have to do is to paste in the picture, scale it properly, make a screen shot, and everything is hunky dory.

     



  • Get a gray Sharpie and draw the gridlines on the screen! Then use your video camera to take a video of the screen, and pull your new map tiles from the video! Keep it stupid simple!



  • @TGV said:

    @Sutherlands said:

    What in the world does that have to do with Excel?  That just happens to be what he implemented the formulas in to convert the numbers.  I don't remember the OP saying that was the problem.
    Oh, come on! It's so obvious. Excel has to grid lines standard on the display. All you have to do is to paste in the picture, scale it properly, make a screen shot, and everything is hunky dory.

     

    1) Print the scaled image.

    2) Place the scaled image on a wooden table.

    3) Place a screen door over the table at height necessary to produce desired grid.

    4) Take picture through the screen.

    5) Bring film to 1-hour photo service.

    6) Scan in developed picture.

    7) Profit!

     

     




  • BINNED

    The trolling is strong in this thread.



  • @PedanticCurmudgeon said:

    The trolling is strong in this thread.

    You'll quit calling us trolls once you learn2excel.



  • So the WTF is that the guy before you is a lazy asshole? And the same lazy asshole refused to continue to do more work?



  • @mott555 said:

    Get a gray Sharpie and draw the gridlines on the screen! Then use your video camera to take a video of the screen, and pull your new map tiles from the video! Keep it stupid simple!

    Or use Premiere to merge the output from two cameras and upload all the permutations to different Youtube accounts, and stream the right account as needed.



  • @flabdablet said:

    If there's no requirement to interact with the grid or turn it off and on - if all it needs to be is displayed - then making it part of the map tiles is actually not a terribly stupid approach, and may in fact be your path of least work. Paint is the wrong tool, though; I would have thought scripting the map tile edits with something like ImageMagick would get you a cleaner and more maintainable result.



    Originally there wasn't, but they've updated it so that they want the grid to dynamically render based on zoom/position so that an intersection is always visible. True, I could have them still draw it on the map, but considering I've yet to receive any maps, and we're supposed to be done on Friday, I'm hesitant to throw more work on the map guy.


    @Snooder said:

    So the WTF is that the guy before you is a lazy asshole? And the same lazy asshole refused to continue to do more work?



    Actually, the guy who drew the lines on the old maps was... er... you know, I'm not sure what his actual title is. I just know when Product Management gives us shit requirements (or none at all), we go to him and he has the answer. Anyway, the last time they tried to do this (before my time, so > 8 years ago), they were unable to make it work and he ended up using Paint at the last minute. I refuse to get to that point again.

    @TheCPUWizard said:

    @CodeNinja said:

    I'm going to the bar.
     

    When you sober up, check out... http://www.developerfusion.com/project/15393/geoutility-library/

     



    Already saw that, and pitched it to my boss. I'm not able to use it directly for some stupid legal reason (I think, mostly, they don't want to have to put the logo on the loading screen). I've got another library from NASA I'm trying to leverage.

    On a side note, this is the most screwy mapping coordinate system ever. It's just... weird. I'll be very glad once I have this done, so I'll never have to do it again.

    @Ronald said:

    This could be done with Excel, a few clever formulas and a little bit of VBA magic.



    Brilliant! Except... I don't have excel on the target system. (I'm assuming this was a troll attempt anyway... if it wasn't and you thought this was a good solution, I apologize and hope you never take a job here)


  • ♿ (Parody)

    @CodeNinja said:

    @Ronald said:

    This could be done with Excel, a few clever formulas and a little bit of VBA magic.



    Brilliant! Except... I don't have excel on the target system

    I call bullshit. Excel is fucking everywhere. Except in your ivory tower mindset.



  • @boomzilla said:

    I call bullshit. Excel is fucking everywhere. Except in your ivory tower mindset.


    That's funny, because it's true. We've even got a special version of Windows on the system.



  • @boomzilla said:

    Excel is fucking everywhere. Except in your ivory tower 8U server

    DCTFU. Note: Could be 4U if you put it on its side.


  • Considered Harmful



  • @joe.edwards said:

     

    I don't get what you did because my brain has switched off for the day.



  • @boomzilla said:

    posted from Excel

    							    <span id="ctl00_ctl00_bcr_bcr_ctl00_PostList_ctl23_ctl23_ctl01">Filed under: <a href="http://forums.thedailywtf.com/tags/posted+from+my+Excel/default.aspx" mce_href="http://forums.thedailywtf.com/tags/posted+from+my+Excel/default.aspx" rel="tag">posted from my Excel</a></span></blockquote></p><p>You really must share this Excel front-end to TDWTF Forums.</p><p>&nbsp;</p>

  • Considered Harmful

    @dhromed said:

    @joe.edwards said:

     

    I don't get what you did because my brain has switched off for the day.

    It's the ghost of Blakeyrat possessing the server rack to attack Nelson again.



  • @joe.edwards said:

    @dhromed said:

    @joe.edwards said:

     

    I don't get what you did because my brain has switched off for the day.

    It's the ghost of Blakeyrat possessing the server rack to attack Nelson again.

    It's one of those "When you see it" pictures.



  • @Ronald said:

    It's one of those "When you see it" pictures.
     

    The racks are eating the cartoon character?


Log in to reply