Showing posts with label hobbies. Show all posts
So, it's been a hot minute since my last utterances, but not for lack of things to bleat about. Rather, quite the opposite.
For the best part of about 4 maybe 5 months now, I've been deep inside of an unusual spurt of energetic release of artistic endeavours. I've taken up writing, and found it to be very rewarding - I really enjoy the 'style' I seem to use when putting words to paper in a narrative form... Something just feels good. I often end up quite giddy after an evening typing away.
So, at some point in the hopefully not-too-distant future, I shall release two very different books. Certainly in the realm of 'short story' the very concept of 'novel' is daunting. But I'll write until the story is told. In one book I'm writing an overly elaborate character background for a character I am currently playing in a Vampire the Masquerade Role-Playing Game.
It is with no shame that the other story is the re-telling of one of my own hosted Role-Playing Games from two years ago, The stories and nostalgia are often broached by the players and I decided that with my newfound urge to 'do' I would make the best and also create the story of that game, a tale of surprise and misery set in a cyberpunk world.
Two very different settings, and two strangely different narratives, both giving me a lot of fun!
Along with this, I decided why not do EVEN more (probably too much) and make an actual computer game... from scratch... not knowing the slightest of how to do so...
Thanks to ChatGPT (which I personally think is a fantastic tool) I can very quickly discover many things, including how to code. It has been a truly fascinating experience; I still know next to nothing about coding, and yet already have a 'working' base of a game! It's got a LOT of work yet to do, but now I have an actual reason to use my Patreon!
And so... With this and my general attempts at playing games a lot and attempting to have some form of social life, I've actually been very busy and a little exhausted. I'm genuinely amazed at how little time there is in the day, I find myself fighting to get a little more done and realising too late it's gone 4am ... again.
I have to give a little shout-out to Mum for making this possible, without having what she gave, I could not do what I now do. RIP mum.
My Muse Must Unleash
And so, within my now ageing brain rattle details that nobody cares about, and that have exactly zero effect in any real-life circumstance. Thanks brain! ... Within this mess, I include my contemplation of how machine-guns are portrayed in the game Battletech. It is with some annoyance I find myself at the wrong end of how these are perceived at large. But, it's annoying enough that I shall now go into a lengthy internet-bound diatribe detailing my upset on the matter.
ELI5: Battletech-
Set in a fantasy future in which technological progression is halted by the spread and politic of humanity among a (widely spread) universe. Huge, stompy, gun-toting robots aka "mechs" (battlemechs) are a de facto way of ending future-space arguments.Machine Guns
Along with lasers, and other 'future' weaponry, mech's have an array of more conventional ballistic weapons. Most are akin to what our modern battle-tanks might have, be it a 30mm automated cannon or a 280mm howitzer style weapon. These are easy for my minds-eye to envision as I get heated and excited mid game as we players discuss the battlefield carnage attempting to bring a cinematic edge to what otherwise boils down to grown men rolling dice and filling out a spread sheet.But then comes "The Machine-Gun"... and here's where I differ greatly from nearly all flavours of Battletech machine-gun I'd seen put into video games, and from that, posted into the mind of players everywhere.
Too often, the machine gun is depicted, or enacted as though it were a trusty modern heavy machine gun probably around 12.7mm / 50 cal. in format and with that familiar thuuba-thuuba-thuuba noise associated to such weapons...
Listen to some dakka:
Well, in my head, this is just wrong... plain and simple, just, well... not right. It's the FUTURE... and also, the image of a 'machine-gun' in the reference materials looks like this:-
I'm gonna need more Cowbell...
More audio dakka:
And to me it meshes well with the fact that in the canon (pun intended) of the fantasy universe that is Battletech, machine guns are supposed to be very fast firing, primarily anti-infantry defence weapons but (and it is a big but...) they are also supposed to be able to just about cause damage to some of the most highly armoured fighting machines ever made... And to me... a minigun has far more potential to find a weaker spot, an exposed gap or even just through impact tear away armour more so than a less lead-spewey weapon.
More so, I would hesitate on a side of caution to state that the weapons of the Mechwarrior sci-fi are more developed than any modern equivalent. I could guess that such a multi-barrelled weapon would likely be akin to the weapons we see on out attack helicoptors or even the ship-bound air-defence weapons...
All while firing some sci-fi armour-piercing tipped bullets of doom. It also follows that in the lore of battletech, one ton of ammo (including the cases and load-feed mechanisms) can fire a machine gun 200 times... Warning BORING MATHS AHEAD...
I would postulate the following;
- A machine gun can be fired once in a game turn.
- One game turn lasts for 10 seconds of time.
- A rotary barrelled machine gun could expel up to around 100 bullets (not including downtime for cooling...).
And so, one ton of bullets, being 200 "shots" would allow each "shot" to be around 100 bullets of fire-effect. This means one ton is actually loading around 20,000 rounds. This would also make more logistic sense of scale in the 'fitting' of the ammo into the mech.
200 bullets can easily be carried by one guy in a small plastic bag, but 20,000 rounds, well that would require specialised ammo bins with enough ammo in them to be 'impressive' in a mecha sci-fi scale.
And so, this rant closes as I frown at the many computer games which portray an underwhelming concept of a firearm. When I shoot a machine-gun from my 10 meter tall death-robot, I want whatever is in-front of me to understand that fact and not just laugh at an impotent pea-shooter.
Some Reference Noise Dakka:
- Mechwarrior 2:
- Mechwarrior 3: I have to say... this is the closest to my liking.
- Mechwarrior 4:
- Mechwarrior 5:
Credits: Sounds from-
- https://freesound.org/
- http://soundbible.com/
- And a bunch of people on YouTube that have done sound sampling from the games...
- Oh, and then by fact of original production; the respective game dev companies that commissioned those sounds...
Wargaming Woes - Battletech
No... This is a post about Excel and my nature of sometimes being excessively obsessed on superfluous details. In this instance, the character sheet for a GURPS role-playing game I'm intending to run among some friends.
My wife has assured me, that this point, this one thing encapsulates and captures so much of who I am as a person that I've decided to memorialise the event of me being able to produce the number 10 in an Excel spreadsheet.
The Number 10;
Not just any number 10, and not even always the number 10. But it was the number 10 which sparked literal weeks of commentary on my mentally obsessive behaviour, although not in the true medical definition of obsessive behaviour, more of a flippant observation made about me.Prepare for preamble reasoning...
Within the GURPS mechanics and within the established core of rules, it is encouraged that players adopt and implement their own concepts. The core rules book (GURPS Basic Set) outright tells players to ignore the published rule books. With this in mind, I use GURPS to do whatever I feel fits my desired game. To that fact, I expand or invent what I want as a character sheet, and what I want as the format in which the numerical details of a character are built and dictate effect within the game.
Thanks, GURPS! I hate having to look up rules, so now I don't!
Excel-lent
Fair Warning: Most of this blog-post is likely VERY boring.
It's simple really...
Here's the offending formula:
With this 'truth' equation, I can determine a row number based on a known detail. Here the SUMPRODUCT looks at all of the details of the stats table (red box) as too does the INDEX function, so I'm looking for details 'in the same place'.
The VLOOKUP here is doing it's best to resolve one little detail, using the name of the stat it is calculating, determine on which skill it must base its calculation. but because only one word can be 'true' it can only create a result for the true detail.
The VLOOKUP function, from it's newly acquired information, and with the same 'true/false' declaration that it began with, now tells the ROW function in which row the true detail is from the stats table (the red box) by multiplying [true] by the required detail. Sadly, because SUMPRODUCT is not a lookup function it requires tricking into doing the job by correcting its result... Done with the second ROW function negating a sort of overflow error.
At this point the formula has worked out ONE-HALF or ONE detail required for its first INDEX function. Right now, the formula only has 'some' idea of what it is supposed to be doing, It still doesn't even have a number, let alone the number 10!!!
This all boils into:
Calculate a reference number for when a known detail is equal to desired detail and multiply by oneTime for a short breather...
I'm nowhere near clever enough to do THIS, but borrowed from a source such as the one linked below:As the INDEX function requires a ROW and a COLUMN declaration, the same calculation from above is done once more, but this time, looking for (by way of calculating a details position as true and then spitting out the number of the column in which the detail exists.
Now that we have both a row and a column, the INDEX can finally do something. It looks up a number, from the stats table, that is called for as one half of a simple addition.
INDEX($F$3:$U$8,SUMPRODUCT(($F$3:$U$8=VLOOKUP(N10,'PC stat share'!$E$3:$G$61,2,FALSE))*ROW($F$3:$U$8))-ROW($F$3:$U$8)+1,SUMPRODUCT(($F$3:$U$8=VLOOKUP(N10,'PC stat share'!$E$3:$G$61,2,FALSE))*COLUMN($F$3:$U$8))-COLUMN($F$22:$U$27)+1+3)
Using the section of formula shown above, Excel can begin to calculate the characters 'Smooth Talk' stat. The reference of N10 is where that stat is shown on the sheet. And from this first and more complex half of the calculation, Excel can now find that 'Haggle' is the required skill, which has a score of 9. Thanks, Excel, you're doing a great job!
The second half of the stat calculation is far easier...
INDEX($A$4:$D$12,MATCH(VLOOKUP(N10,'PC stat share'!$E$3:$G$61,3,FALSE)&"*",$A$4:$A$12,0),4)
An INDEX/MATCH formula looks up which primary stat is required to be added and then gives the appropriate detail of that stat. In this case, it looks for the stat 'Smarts' in which this character has 9 points. Yeah, nice one Excel.. whatever...
And finally-
After much effort, Excel can now lookup (based on the name of a character's stat) what the secondary stat is calculated as, and then include that into the secondary stat calculation.Smooth talk requires the calculation of the characters 'Haggle' stat score, added to the characters 'Smarts' primary stat. Reduced by 1 and then divided by 2.
To be done by hand this is super easy; Haggle is 9, Smarts is 9, that's 18. And then -1 for 17, finally divided by 2 for a score of 8.5 which is rounded down to 8. And while I could very, very simply do this just in my head, I don't fancy doing so more than 200 times if I decide to change the requirements of a stat, or the primary statistics of a character.
Getting this calculation right took me the better part of two nights of work, and all so I could be lazy.
And it didn't even calculate the number 10 this time...
Number 10
Or at the very least, I think it's pissing me off, I may yet find it's actually not, and I'm just venting over nothing.
So, here's the schtick, I like hanging about on Quora, for a while I even thought I 'liked' answering questions there, I felt as though I was helping spread a little learning, some positive (I hope...) opinions and making things better.
This feeling has died now and I'm left feeling confused and slightly angry at the Quora site.
As I see it, at the very heart of Quora is the concept of a question & an answer, perhaps not always a good or correct answer, but an answer, inquiry met with feedback, an honest two-way interaction of inquisitive minds and those with the information to feed forward.
But now, I'm jaded, I see a website filled with questions which with even a tiny amount of research are easily answered elsewhere, questions phrased and clearly intoned to be aggravating or 'trolling' and questions which seem to fill no other role than an abuse of the fact that asking questions is rewarded with a share of the site profits (no doubt because of the increase in ad revenue those same questions draw into the site)
Cash for Shit, bring out your shit!
If I might stick with the last point, it seems ass-backwards that a really shit question is rewarded, but a superb, well written and meticulously explained answer yields it's progenitor no benefit.Someone asking "is the outcome of 2+2 different on Tuesdays" would likely get a few hundred views, maybe even some earnest answers, and probably a few 'triggered' answers too...
But that question, regardless of how inane it may be, will earn the asker some cash. The asker can then go on to ask the exact same question but rephrased replacing "Tuesdays" with Monday, or June, or 2006... each time they do, being rewarded for their effort and clogging up the site with ever more redundant and objectively poor content.
But, hypothetically; if a theoretical physicist, one whom also has a deep and well-educated grasp of quantum theory and chaos theory (or whatever) were to drop by and give a lengthy and detailed 'actual' answer explaining how even basic mathematics is affected by some hitherto unknown esoteric scientific theorem.
That answer, the sum of their extensive learning, experience, and the time they'd given to put together the answer. Is somehow less valuable?
Fucking what?
And so, I come to realise that once again, idiocy, banality and feigned ignorance are being rewarded while talent, ability and a willingness to help are simply ignored, or even worse - are abused.
Sigh.
I've no doubt I'll continue to read, and even post on Quora, but I do so feeling somewhat ashamed that I cannot find a better use of my time and a little depressed that I continue to sink in an intellectual mire of self-depreciation.Happy Christmas folks.