augus

cross-posted from: https://ohai.social/users/augus/statuses/115928581130162056

HG Unicorn Gundam 02 Banshee Norn (Destroy Mode)

(that's a mouthfull)

I went into this kit expecting extra work, but the result was worth it. It even came with an extra shield (from the Unicorn mode?). I do wish it came with some basic beams for the sabers and tonfas, though.

@gunpla

#gunpla #gundam #modelkits #plamo #mecha #HighGrade #GundamUnicorn

I currently keep track of which model kits, brick building sets, and painting miniatures that I own and whether I have made progress on them in a Google Sheet. As part of my attempt to degoogle, I am looking into various alternatives.

My current preferences for an alternative are:

• Accessible online
• Can be edited online/in-browser (potentially through some frontend)
• Loads relatively quickly/efficiently
  • Hardware is an issue here; my server computer is quite low end
• Accessible on an Android device (does not have to be able to be edited on mobile)
• Preferably can display linked images, whether on Nextcloud's filesystem or through hyperlinks

One of the alternatives I've already tried is the Nexcloud Office plugin for my existing Nextcloud server using Collabora Online as a backend. In addition to it loading quite slowly, I had issues editing any files created with the plugin, and after tinkering with it for a while I decided to put that solution aside. This was several months ago.

Another alternative I have considered is coverting this sheet into a database. I do not have much experience with databases (pretty much just creating one in MariaDB for Nextcloud), but from what I know about them this seems like a good use case for one. I do not know what would be best as a frontend; phpMyAdmin? DBeaver?

Any suggestions? If all else fails, I'll just keep an .ods document on Nexcloud and install LibreOffice Viewer on my phone, but I would prefer not to have to download and upload the .ods through Nextcloud every time I want to update my inventory (this is primarily an issue when I update it at work).

This is what I currently use:

There are only a few formulae used:

• One to both link to a webpage for that kit and display an image of it; these could be easily separated into two fields
  Formula 1: =HYPERLINK("https://bandai-hobby.net/item/5886/",IMAGE("https://bandai-hobby.net/images/157_5886_s_5pwg9tvxlm5v4gwrz49ly8ry3j8e.jpg"))
• One to convert the Japanese retail of a product (in the Yen column) to equivalent USD in the release year (could easily be replaced with a manual conversion or a researched US retail)
  Formula 2: =M36&"円 / $"&TEXT(M36*VLOOKUP(F36,'Currency Rates'!$A$2:$B$52,2,FALSE),"#,##0.00")
• And one to grab the current average conversion rate for the year (again, could be replaced with a quick search)
  Formula 3: =QUERY(GOOGLEFINANCE("CURRENCY:JPYUSD","price",DATE(A47,1,1),IF(DATE(A47,12,31)-TODAY()>0,TODAY(),DATE(A47,12,31)),"DAILY"),"select avg(Col2) where Col1 is not null label avg(Col2)''",1)

This last formula is used on a conversion sheet referenced in Formula 2, which looks like this:

I appreciate any help.

cross-posted from: https://ohai.social/users/augus/statuses/115888873923228056

MGSD Gundam Aerial

Finally figured something out for pictures, just in time to finish another Aerial.

This kit is super fun. The strange proportions highlight a lot of what I like about the original design, and the eyes are absolutely wild. The permet could stand out more, but I appreciate that I can swap between red and blue.

@gunpla

#gunpla #gwitch #gundam #modelkits #plamo #mecha #mgsd #SuperDeformed

cross-posted from: https://ohai.social/users/augus/statuses/115289041571944881

RG Gundam Epyon (with decals)

I finally finished putting the decals on my RG Gundam Epyon. Even with the matte top coat I've flaked off two of them, but I'm still happy with the result. I love this kit.

@gunpla

#gunpla #modelkits #plamo #mecha #gundam #gundamwing

cross-posted from: https://ohai.social/users/augus/statuses/115096005495812266

HGIBO Gundam Vidar

Super fun kit, as long as you go in expecting to do some painting. Gundam Color Phantom Gray and Gundam Marker Metallic Red were all I needed (besides my panel lining fluid), and I'm pretty happy with the result.

That said, any tips on how to apply the metallic Gundam markers more evenly?

@gunpla

#highgrade #gundam #gunpla #hgibo #IronBloodedOrphans #modelkits #plamo #mecha