Friday, August 10, 2018

Days Gone 13 - The Hero Makes a Cameo

Haven't had time to work on Days Gone for a while now, but the other day I needed an illustration for a mailing label for the Collectors' Club Newsletter, so I took an old illustration and colorized it.

© 2018 Mike Mitchell

Not a bad job for a quickie. To be honest, I had expected to make his trousers blue or brown, but I found that they looked nice when I matched them to the red arm bands. I don't think these are the definitive colors I'll use when I create cover art for the book, but it was still a fun exercise in digital coloring.

Saturday, July 28, 2018

Random Barbarian Image Post 3

I created this as a mailing label for a fanzine.
The figure was created by compositing multiple renders created in Poser Pro 11, and then doing clean up in combination of Photoshop and Manga Studio 5EX (aka Clip Studio Paint). For no reason in particular, I decided to work in color this time, rather than black & white. I don't think it's perfect, but I do think it looks okay.

Conan the Barbarian © 2018 Marvel Comics
Image © 2018 Mike Mitchell

Saturday, June 23, 2018

Comics Talk: The Time I Wandered Away from Comics

I was discussing comics on Facebook earlier today and wound up writing the following response to someone who said that he quit reading comics a long time ago because he didn't like the "to be continued stories" that were popularized by Marvel Comics. He much preferred the stand-alone stories of the old DC Comics.

The following is based what I wrote (I fleshed it out a bit):

"Back in the day" I loved the continued stories at Marvel Comics. It allowed for more complex stories and really built the mythology that is modern comics storytelling in a shared universe. For me, the thing that killed my love of CURRENT comics is the MEGA EVENT. It all started with Secret Wars, which was okay. It was novel at the time and I liked it. 

But... then along came SW2, Contest of Champions, Marvel Mutant Massacre, and tons of other series-changing events. And then DC got in on the act. I think it was the whole Batman Earthquake mega storyline that got me tired of the gimmicks (the entire arc, including Cataclysm, Aftershock, Road to No Man's Land, No Man's Land, had at least 80 issues!). 

© 2018 DC Comics

That wore me down financially and ate away my enthusiasm because it completely disrupted other ongoing series that I followed, including Nightwing, Robin and Anarchy. All of those had ongoing stories that were either disrupted or destroyed by the mega event. Then, no sooner had the dust settled than they disrupted everything again by the Bruce Wayne: Murderer storyline. 

I'm not saying any of these were bad stories. In fact, a lot of good came out of them. I really liked parts of the No Man's Land (I thought Barbara Gordon's portrayal was some of the best ever). Ditto for some of what happened in the "Murderer" storyline. But, honestly... it was just too much.

I didn't make a conscious decision to quit buying comics, but the local store where I shopped went out of business and at the time I never bothered to find another. 

During this time, I still read comics (notably Archie and various Walt Disney titles, as well as a wide variety of indie comics and graphic novels (Blankets, Sin City,Dropsey Avenue), various gaming comics (Knights of the Dinner Table, Dork Tower, Nodwick and others). But I didn't follow anything by the big companies at all.

It took years before I wandered back into "mainstream" comics, and even then, today I only buy about two Marvel titles (Squirrel Girl and Moon Girl (Hellcat and Howard the Duck were recently canceled). I might pick up an occasional DC trade, or a mini-series (Deadman by Neal Adams was just weird, but the Batman '66 and Wonder Woman '77 were a lot of fun), but mostly I'm diving back into the b&w mags of the 1970s (Savage Sword of Conan, Marvel Premiere, Space: 1999, Planet of the Apes, Eerie, Creepy and so forth). 

One of the many issues I've picked up over the past year.
© 1979 Marvel Comics, cover by Bob Larkin

Another old mag I picked up, Marvel Preview #9
© 1976 Marvel Comics, cover by Earl Norem
New comics just don't appeal to me much, any, and the constant barrage of "Mega Events" like Civil War, Rebirth, 52 and all that jazz are definitely a factor in keeping me away. I just don't have the patience for all these constant reboots, especially when coupled with the onslaught of gender, race and orientation changes (Ice Man is gay? Really? I don't give a crap that they have a gay hero, but forcing Bobby to become gay feels like a cheap stunt designed to appeal to Social Justice Warriors). 

There are still good comics out there, but I've moved on from the mainstream and I seriously doubt I will ever move back.

Friday, May 18, 2018

Days Gone [Addendum]

Hard to believe that I haven't posted an update on this project for almost six months. Wow. Time flies when your full-time career starts consuming almost all of your waking hours with commute and work. But I think the big hurdle in that particular project has been passed, so I'm trying to get a handle on time again so I can get back to work on Days Gone #3.

As a side note to this project, I found myself needing a back cover illustration for the Collectors' Club Newsletter #122, so I quickly pulled out two separate illustrations from the Days Gone project and combined them into the illustration below.

Dragon Spire
© 2018 Mike Mitchell

I made the color choices because I wanted to emulate the old three -color printing process that was frequently used in fanzines back in the 1970s and early 1980s. I also chose the framing effect (cropping the background smaller than the figure so we could see paper on the sides) based on a Conan or Kull portfolio piece I saw in an old Savage Sword of Conan magazine.

Speaking of which, I've really been enjoying reading those old issues. I've been buying lots of them this year, and have about half of the series. I'll write more about this in a future blog.

Thursday, May 10, 2018

Excel - Get URLs from a range

I'm storing this info here so I can find it later. I have a spreadsheet with a lot of URLs stored in a column (more than 150). The URLs are embedded in files stored on a remote server so when you click on the file it will take you to the file.

Great, except I need the actual hyperlink info. I could get the URL by right clicking then cutting/pasting each file, but that would take hours. So I need a custom function or macro to extract them for me.

The basic info is copied from this location:

The cure for tedium—like them or not—is a macro. With a macro, getting at the underlying URL for a hyperlink is child's play. All the macro needs to do is pay attention to the Address property of the hyperlink. The following is an example of a macro that will find each hyperlink in a worksheet, extract each one's URL, and stick that URL in the cell directly to the right of the hyperlink.
Sub ExtractHL()
    Dim HL As Hyperlink
    For Each HL In ActiveSheet.Hyperlinks
        HL.Range.Offset(0, 1).Value = HL.Address
End Sub
Instead of a "brute force" macro, you could also create a user-defined function that would extract and return the URL for any hyperlink at which it was pointed:
Function GetURL(rng As Range) As String
    On Error Resume Next
    GetURL = rng.Hyperlinks(1).Address
End Function
In this case you can place it where you want. If you want, for example, the URL from a hyperlink in A1 to be listed in cell C25, then in cell C25 you would enter the following formula:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3281) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Extracting URLs from 

How to create a custom function
That's all good and fun, but it doesn't tell me how to create a custom function. So, here's another source:

BEFORE YOU PROCEED, you will need to go into your Excel settings and, in the File > Options you need to edit the Auto correct setting that automatically turns URLs into hyperlinks.
  1. Press Alt + F11.
    This gets you to the Visual Basic Editor, where VBA is written.
    You can also click the Visual Basic button on the Developer tab of the Ribbon. The Developer tab is visible only if the Developer checkbox is checked on the Customize Ribbon tab of the Excel Options dialog box.
  2. Choose Insert→Module in the editor.
    You have an empty code module sitting in front of you. Now it’s time to create your very own function!
  3. Type this programming code, shown in the following figure:
    Writing your own function.
    Writing your own function.
  4. Function GetURL(rng As Range) As String
        On Error Resume Next
        GetURL = rng.Hyperlinks(1).Address
    End Function
  5. Macros and VBA programming can be saved only in a macro-enabled workbook.
    After you type the first line and press Enter, the last one appears automatically. This example function adds two numbers, and the word Public lists the function in the Insert Function dialog box. You may have to find the Excel workbook on the Windows taskbar because the Visual Basic Editor runs as a separate program. Or press Alt+ F11 to toggle back to the Workbook. Save the file as a Macro-Enabled Excel file (necessary).
  6. Return to Excel.
  7. Click the Insert Function button on the Formulas tab to display the Insert Function dialog box.
    Finding the function in the User Defined category.
    Finding the function in the User Defined category.
  8. Click OK.
    The Function Arguments dialog box opens, ready to receive the arguments. Isn’t this incredible? It’s as though you are creating an extension to Excel, and in essence, you are.
    Using the custom Add function.
    Using the custom Add function.

BTW: I am not copying this here to rip off anybody's content. I'm just storing it here in case the original links ever go away.

Sunday, April 15, 2018

Random Barbarian Image 2

A bit of fun for a Sunday afternnon. I was in the mood to play around with inking, so rather than create something new, I took an earlier render of a Conan figure I was working on and experimented with some new pen settings in Manga Studio 5 EX (aka Clip Studio Paint). Not all my inking choices worked, but I don't think it's all that bad. Especially fro something I'm just playing around with.

© 2018 Mike Mitchell

As with most of my work, this was rendered in Poser 11 pro and cleaned up in Photoshop and Manga Studio 5 EX/ Clip Studio Paint.

Saturday, March 31, 2018

Random Barbarian Post 2

I wanted to do something really GRAPHIC (not violence or sex, but in terms of design). So I tapped into the feel of 1960s posters and came up with this. Obviously, this is based on Conan the Barbarian, and I really need to thank takezo_3001 over at Daz for sharing his custom morph with me. The outfit is from the M4 Warrior, and I'm not sure which of my many swords I used.

As usual, this was rendered in Poser Pro 11, then edited in Photoshop and Manga Studio 5EX (aka Clip Studio Paint).

I'm calling this one, "Warrior of the Wastes."

© 2018 Mike Mitchell

And yes, this is a precursor to me getting back to work on my Days Gone comic book very soon.