Saturday, September 13, 2014

Update to my printer-friendly Pocketbook report template


Recently, I built a printer-friendly version of Pocketbook’s Analyse feature. It was functional, but not very refined. I have spent a little time polishing it.

The new features are as follows:
  • Categories created by users no longer need to be added in manually. If you add new categories using Pocketbook, they will update once you click ‘Refresh PivotTable Data’. 
  • Categories can now be shown by both ‘Parent Category’ and ‘Detailed Category’ e.g. ‘Entertainment’ and ‘Entertainment – Drinks’ respectively. The Source Data tab has a function to define the Parent Category by looking at the Detailed Category string.
  • Because of this, the Income and Expenses by Category tables can now (and do) show a summary by the Parent Category. 
  • The Expenses by Category graph is now beside the ‘Income/Expenses Breakdown’ graph on the Report tab. It also now summarises transactions by the Parent Category and the categories are flipped to show to highest expenditure category at the top of the graph. 
  • A breakdown of the detailed categories is now given on the ‘Report p.2’ tab. This allows you to drill down, once you have the overall picture. If need be, you can look at the individual transactions by filtering the ‘Source Table’ worksheet. 
  • A new button has been added to the ‘Report’ tab that allows the ‘Transferring Money’ category to be excluded from the PivotTables (it is excluded from the Reconciliation table by default). If you want to put them back, just click ‘Refresh PivotTable Data’ again.
The only thing that needs to be done manually now is to load the latest transaction data from Pocketbook into the ‘Source Table’. Once that is done, just hit ‘Refresh PivotTable Data’ on the Report tab, and watch it work! 

Pocketbook has over 100,000 users now, so again I hope others find this useful. Unfortunately, I’ve only got my own data to test this on, so debugging can be a little difficult. If you have any problems, suggestions, questions or feedback about it, feel free to leave me a comment below.

Sunday, September 7, 2014

Chapter II - Command and Control (SW:EotE RPG Fiction)

 The following is a fan-fiction story based on our adventures in the Star Wars: Edge of the Empire roleplaying game. You can read Chapter I here or by, you know, scrolling down to the previous post.

I'm hoping to have the rest of the story written up soon. Writing the narrative version takes a lot longer than I expected!

Chapter II - Command and Control


     Oskara, Lowhhrick and Pash wandered out of the cantina and into the heat of Mos Shuuta. They made their way down the gritty dirt and sandy streets towards Vorn's Junk Shop. As they walked, they passed a stable of dewbacks in an enclosure. The cold-blooded reptiles were clearly unconcerned by the baking heat of the twin suns of Tatooine.

     The narrow alleyway they were walking down opened into a medium-sized, square plaza. Circling the outside of the plaza were a number of small pourstone buildings. Each must have been white originally, but were now discoloured to a pale orange by the constant desert winds over the years. Parts of the buildings had avoided at least some of the discolouration. The domed roofs, for instance, still reflected a slightly brighter white than the walls. Most of the buildings around the plaza had leather or hide awnings stretched out in front of their entrances to provide a skerrick more shade. Townsfolk were clustering around the few stalls that were scattered about the place. The plaza had exits on each of its four corners; one that they had come from, one that led towards the electrogate - the border and exit of the town itself into the rolling deserts of Tatooine - one wide thoroughfare that led towards Teemo the Hutt's Palace, and one that led deeper into Mos Shuuta.

     "I can see the junk shop," Oskara said pointing down the street, "the scrapyard is a dead giveaway."
     "Let's just hope he's still got that part, so we can get off this rock" Pash added.

     Stepping inside the junk shop, Vorn looked up from a low counter covered with disassembled droids and machine parts. He was a hunched, old man, but still reasonably sprightly for someone well past his middle years. Vorn turned to a garbage-can shaped R5 unit by his side, and gave it a swift kick.

     "You're supposed to tell me when I've got customers, you useless bucket of bolts!" he yelled angrily "Now get outside and finish stripping that speeder bike wreck." The R5 droid extended his lead wheel and trundled off with a surly string of beeps. It was probably something like '!@#$ you' in droid parlance.

     "You just can't get good help these days," he said frustratedly, turning towards the entrance "welcome to my shop anyhow".
     "As you can see," he continued, waving his arms toward the racks and shelves and enormous buckets full of scrap metal and parts "I have anything that you could want -". Vorn rubbed his thumb and forefingers together, "- for the right price, of course".
     "We're looking for a hypermatter reactor ignitor," Pash said "you wouldn't have one by any chance?"
     "Well, I did have one," Vorn replied, "but I've already promised it to Captain Trex of the Krayt Fang. He's paying top dollar for it too."
     "Wouldn't you rather sell the part to us than to Trex?" Pash went on, "You know, because we're so likeable and he's a bad man."
     "Fat chance," the old man replied curtly "if you want it so badly, why don't you try to convince me the only way that matters - with credits". Pash moved a little closer toward the shopkeeper and lowered his voice.
     "How about you sell it to us at the same price that Trex is paying you, or I'll get my Wookiee friend here to pull your arms out of your sockets" Pash flashed a glance to Lowhhrick, who grunted approvingly.
     "Alright, alright. No need to get nasty." Vorn walked over to one of the shelves and picked up the small, cylindrical part. "You drive a hard bargain, but you can have it for 500 credits."
     "Have you got anything else? Any weapons or armour?"
"Nothing like that here," Vorn conceded "but I've got a few stimpacks and repair kits lying around".
     "Perfect, we'll take those too."

     Oskara, Lohhrick and Pash pooled their credits and handed over the price Vorn had asked for the items. Pash bundled the hypermatter reactor ignitor into his backpack, and shared the stimpacks and repair kits around. Leaving the shop, Pash said to the others in a soft voice to avoid any prying ears, "I used to fly cargos in and out of this place. When you land, Spaceport Control engages docking clamps on your ship so they can control the arrivals and departures centrally - and to prevent smugglers from getting away easily. We won't get far unless we can disable those docking clamps."
     "What are we waiting for then?" Oskara chimed in, "Let's go get them un-clamped!"
"It's this way" said Pash, gesturing the others to follow him.

     The Spaceport Control facility was a low, squat building which clung to the edge of the rocky cliff-face Mos Shuuta was built upon. Two security droids were posted at the entrance, standing at attention.
     "You guys distract the droids," Oskara said "I'm going to see if there's another way in." Lohhrick gave a small grunt in agreement.
     As Pash and Lohhrick approached the droids, Oskara slipped casually down the alley beside the facility. As she made her way down the street, she could hear the faint sounds of Pash starting up a conversation with the droids.
    "So... er... how about that local sports team?"
Pash was definitely more attuned to charming ladies than to relating to droids.

     At the end of the alley, Oskara found a small, orange, metal door that belonged to a small chamber that jutted out of the side of the Spaceport Control facility. Two thick, but rusted iron rods held the door closed, and a small keypad terminal was attached to the wall beside them.
     "I've found a side entrance," Oskara whispered into her commlink "give me a minute to crack it"
Back with the droids, Pash was having a difficult time coming up with topics of shared interest.
"Umm... Did you hear about Alderaan? Crazy, right?" (Sidenote: In terms of timing, the destructive power of the Death Star had just been tested against Alderaan. Pash narrowly escaped his death by being arrested and transported offworld for grifting the streets of planet's capital city.)

     Oskara plugged her datapad into the terminal and ran a quick codebreak program. Cracking a lock isn't difficult for a seasoned bounty hunter, the trick is being able to crack it without any security system detecting that the code had been cracked. Fortunately, Oskara knows such a trick. Moments later, the door slid open in front of her with a satisfying swish of air.
     "I'm in" she whispered into her commlink.

     The room she entered was a small conference room. It possessed a small table with four high-backed chairs, a dark polished wood sideboard and a low, long grey cabinet. At the other side of the room was the door that led towards the facility's main control room. Moving stealthily, Oskara flattened herself against the wall beside the control room door.
     "What do you see?" Pash asked over the commlink.
"I see what you see human," The security droid responded condescendingly, "they don't give us state-of-the-art ocular receptors for nothing".
     Oskara spoke softly into the commlink.
"It's a large open chamber. Two more security droids on the inside near the hallways that lead toward the front entrance. There's also a woman here who looks to be in charge."

     The woman stood in front of a large holographic display of the local aerospace with her hands behind her back. Attached to her ear was a small blue and silver commlink headset.
"Imperial shuttle Lambda-11238, this is Overseer Brynn of Spaceport Control. You are cleared for landing. Welcome to Mos Shuuta." Half a dozen technicians of different species scurried around her, moving between different consoles and terminals .

     "If you do not have business at Spaceport Control, then move along human" one of the security droids said, as he pointed the pair down the street.
     "Ahh, I'm sick of these droids anyway, come on Lowhhrick" Pash said. Feigning to turn away, he quickly spun back, blaster drawn and fried one security droid at point-blank range. Lowhhrick roared, picking up the other droid and separating its smooth metallic head from its body.

     The sounds of blaster fire from outside whipped Spaceport Control into a frenzy. One of the technicians sounded the alarm, and the two droids guarding the main control room turned and ran towards the main entrance. Pash and Lowhhrick had taken cover behind the pourstone entryway pillars. The droids had them pinned under suppressive fire, but Pash and Lohhrick were serving up a volley of blaster fire in return. A droid landed a piercing shot to Lowhhrick's shoulder, causing the wookiee to howl and cry out in pain. Now he was really angry.

     Overseer Brynn drew a small blaster from a holster on her boot. Seeing a window of opportunity, Oskara dashed out from the conference room. Running with deadly silence and grace, she slid towards Brynn feet first, taking her legs out from under her. Whipping out a set of binders, Oskara cuffed Brynn's hands behind her back. The technicians scattered, making for the street.
     "Now, if you wouldn't mind deactivating those droids?" Oskara said curtly.
"Why should I, bounty hunter?" Brynn spat the words through clenched teeth. Oskara produced her blaster pistol and pointed it towards her.
     "Because I don't want to have to use this." There was a short pause before Brynn spoke defeatedly.
"Push that button there and bring the terminal to me," Brynn nodded toward the console "it's voice-imprinted". Oskara held the terminal up to her.
     "Security. Droid management." Brynn said flatly "Manual override. Remote shutdown. Confirm - shut them down".

     The droids stopped firing suddenly on Pash and Lowhhrick.
"Haha, she did it!" Pash exclaimed to the wookiee. Still in a foul temper and clutching his shoulder, Lowhhrick walked inside. The hair had been deeply seared and singed by the blaster shot. As he moved past the droids, a sudden impulse took him. He swung a giant haymaker at the motionless droid, knocking its head clean off.
"Yeah! Stupid droids! They can't hurt us, right Lowy?" Pash exclaimed. He took Lowhhrick's lead, jumped up and attempted to kick over the still droid he was walking past. Wookie strength and human strength differs greatly. Rather than knocking the droid over, Pash's kick had only succeeded in pushing himself away from the droid in mid-air and landing on the ground in a heap. Getting back on his feet, Pash looked around - nobody had seen, Lowhhrick had already made his way down the corridor to the main control room.

      "We need you to disengage the docking clamps of Landing Bay Aurek" Oskara demanded.
"The Krayt Fang?" Brynn stared at them all in shock "Why? The ship is a hunk of junk -"
     "Hunk of junk or not, it's our ticket off this rock" Pash interrupted.
Brynn spoke into the terminal once more,
"Departures. Docking Bay Aurek. Disengage docking bay clamps. There," she said "You're free to go."
     "But you're not," Oskara said slowly "I'm sorry. Lowhhrick?"
Lowhhrick approached the captive, crouched down to her level, licked her cheek and then summarily broke her neck. Let's just say that Lowhhrick's years of fighting to the death - everyone else's - as a gladiator, coupled with losing his family to Trandoshan hunters, had made the wookiee a prime candidate for post-traumatic stress disorder.

     "You didn't need to do that!" Pash interjected.
"What would you have me do? Let her go free?" Oskara glared at Pash "So she could re-arm the docking clamps on the Krayt Fang after we leave? Or re-activate the security droids, and send more of them after us? Or give our plan away to Teemo? Not a chance. I'm not taking any risks. I mean to be free of that disgusting Hutt, and get back home to protect my sister, whatever the cost."
     "Let's just... let's just have a look around and see if there's anything we can scrounge from around here" Pash responded uneasily. Oskara was right, but it was still difficult to stomach. Oskara retrieved her cuffs from the body, and tossed Brynn's nearby blaster to Pash.
"Here, two might be better than one."

     Searching the nearby office and side rooms, they found a few stimpacks, another set of binders,
and a small, broken pit repair droid.
     "This might come in handy," Oskara said as she put the compact, disc-shaped robot into her backpack "if I can find time to fix it up."

     "We'll have to cover our tracks." Oskara said to the other two as they were preparing to leave. "If we destroy the consoles and terminals here, no-one will be able to find out where we went." The smuggler and the wookiee nodded in agreement.
     "Ready?" she said "Now remember, the trick is to walk slowly and not look at the explosion".

     With sparks flying behind them, the crew sauntered casually down the steps at the entrance of the facility. You can imagine it in slow-motion, with Oskara carrying her heavy blaster rifle hefted over her shoulder and Pash putting on a pair of sunglasses, if you like.

A new game (Star Wars: Edge of the Empire) and a new story

Recently I bought Star Wars: Edge of the Empire - a properly nerdy pen and paper role playing game - and sat down with some friends and played through the beginner adventure included with the box. It was a hell of a lot of fun, but I thought it would be cool to write up what happened in our version of the adventure. I thought it might make an interesting running series, not to mention content for the blog.

Anyone who has played the Beginner Game will recognise the characters and the events that occur - they would have gone through the same adventure - however, what I think will make this interesting is the different choices that my friends made (they're a strange lot), and eventually when we break free of the opening adventure, it will be a chronicle of how events unfolded in one Edge of the Empire universe. Comments on the writing and story telling are welcomed. I've had to take a fair bit of poetic licence with the dialogue, but what unfolds is all in there unadulterated.

We're due to play again on Monday, so stick around if you're interested! Another chapter will be up later today!

Cast


Stuart Bell - Game Master (Guides the narrative, controls characters the players interact with etc)

Ryan Jackson - Oskara (Twi'lek - Former bounty hunter for Teemo the Hutt. Recently teamed up with Teemo's favourite gladiator, Lowhhrick, and pilot, Pash to flee Teemo's service after discovering his plans to seize a spice mine on her home planet which would put her sister in grave danger)

Ryan Davey - Lowhhrick (Wookie - Offered to help Oskara escape Teemo's servitude, under the condition that she take him with her)

Sam Broadbent - Pash (Human - Smuggler, conman, rogue... scoundrel. And an excellent pilot. Until recently, he had been flying cargos for Teemo in and out of Mos Shuuta - that is, until his last mission where the ship he had been flying (owned by Teemo) had been damaged beyond repair. He didn't stick around to see how Teemo reacted to this news)

                                                                                                                                                                   

Kudos to Kevin Lambert who made an opening sequence for this very adventure. Watch the below to get yourself in the right mindset, and to set the scene:


Chapter I - On the run from a gang of Gamorreans


     Oskara, Pash and Lowhhrick ran down a short flight of stairs into the cantina's shadowy common room. The cool air was a blessed relief from the scorching Tatooine heat. The Devaronian bartender paused in his chores to stare at the motley crew, his devilish features intimidating in the dim light. On a stage in the corner, a Twi'lek woman danced along to recorded music. Private booths lined the walls and chairs and tables scattered the cantina floor. Oskara's eyes darted around the room, looking for exits and places to hide. Storage closet, doorway behind the dancer, thick struts around the roof. Without a moment to lose, Oskara ran to the Twi'lek dancer.

     "Quick! You must help me," she spoke hurriedly in Twi'lekian, "there are Gamorrean thugs right behind us. I need to hide, please let me behind the stage". The dancer stopped in her routine, and suddenly looked afraid.
     "Come! You must hurry!" she speaks in a low whisper, as she ushers Oskara into the backstage dressing room. The dancer closed the door behind Oskara and returned to the stage, picking up her routine where she left off.

     As Oskara made her way to the dancer, Lowhhrick moved toward one of the booths, hoping to blend in with the cantina crowd. On his way, he attempted to take a drink from a nearby patron, to make it look as though he had been there all along. Unfortunately, the glass fumbled in his big, hairy Wookie hands, smashing it on the floor. The patron got up from his chair and began to shout at Lowhhrick.

     As the Wookie moved into the cantina, Pash decided to hideout behind the bar. Running quickly towards it, he put a hand on the bar to vault over it. Without noticing, he put his hand in a puddle from a spilt drink that had yet to be cleaned up by the Devaronian bartender. As he was mid-way through the vault, Pash's hand slipped out from underneath him, smashing a bunch of empty glasses and leaving him lying in a prone position atop the bar.

     At that moment, the three Gamorrean thugs burst into the cantina. They were pale-green, pig-featured beasts, and they were carrying heavy wooden cudgels. Pash drew his blaster pistol and let a shot fly, hitting one of the Gamorreans directly in the neck, killing him instantly. The patrons of the bar scattered; some hiding under the tables in the booths, others making for the door. The bartender took cover, crouching behind the bar, The remaining two thugs split up and quickly covered the distance to Lowhhrick and Pash. The one facing Lowhhrick dealt him a swift blow with his cudgel, while the one who ran to Pash swung the cudgel high and aimed for a crushing hit. Pash just managed to roll off the bar as the cudgel struck where his head would have been.

     Angered by the cudgel blow, Lowhhrick roared as he picked up the Gamorrean by his throat. Holding him high above the ground, Lowhhrick shook and choked the Gamorrean until he no longer moved. At that moment, Oskara ducked out from behind the stage, drew her blaster rifle, aimed and delivered a burst of laser fire to the thug standing over Pash, who had been ready to crack his skull open like a melon. The thug dropped to his knees, and then toppled over.

     There was silence in the cantina. Slow and unamused applause began to break it. The noise of conversation started back up, and patrons turned back to what they were doing; watching the Twi'lek dance or drowning their sorrows with a variety of beverages. The Devronian bartender stood up from behind the bar and peered over at Pash. He laughed a bitter, brittle laugh.

     "You look like folks who need to get off this planet in a hurry." he spoke. He wasn't concerned for their health and wellbeing - cantina brawls are a regular occurance in Mos Shuuta, the second-most wretched hive of scum and villainy in the galaxy - but more with the air of someone who doesn't want more trouble to befall his cantina. Lowhhrick and Oskara had moved to the bar, and helped to put Pash back on his feet.

     "Well there's good news and there's bad news," the bartender continued, "and then there's some more bad news. The good news is that there's a freighter docked in Landing Bay Aurek right now. The bad news is that it's captain, a Trandoshan-"

     Lowhhrick bared his teeth and growled at the mention of this. Trandoshans were the reason Lowhhrick had ended up working for Teemo the Hutt. On his home planet of Kashyyyk, Trandoshan raiding parties often hunt Wookiees for sport. One such raid had killed his sister and nephew. Lowhhrick had vowed to hunt down those responsible, but was captured and forced to fight for the amusement of others. Having made a name for himself in the ring, his contract had been acquired by Teemo.

     "-Trex is his name," the Devronian went on, eyeing the Wookie cautiously, "he's an associate of the Hutt's and he's not just going to welcome you on board. The other bad news is that the reason it's still in the landing bay is 'cause it's got a broken hypermatter reactor igniter. It won't be going anywhere until it gets a new one installed. Vorn over at the junk shop probably has one-". The bartender swept his arm up, pointing towards the door.

     "Now get out of my cantina! Haven't you caused enough trouble here?". Pash flipped the Devronian a credit chip.
     "Sorry about the mess." he added nonchalantly.

Saturday, September 6, 2014

Book Review: Eric by Terry Pratchett

Eric


Image Credit: Amazon, available in numerous formats.
So this one didn't take me long. It was much shorter than most of the others I've read in the Discworld series, but no less funny. This novel introduces the demons of Discworld, which haven't made an appearance until now (as far as I recall anyway), but they must have always been there given the number of gods present on the Disc. Pratchett's vision of Hell is particularly interesting.

Eric is a young demonologist who, while trying to summon a demon to grant him three wishes, ends up with Rincewind and what he asked for but not what he wanted. Contains Rincewind's return and subsequently running away from all danger, attempted human sacrifice, references to Greek mythology, and the creation of the universe. Another enjoyable read.