Blog1 2 3 4 5 6 7 8 9 10 Older →
An Excellent Final! 30 June 2016, by Sue
Advanced Data Capture and Reporting in Excel with VBA 26 May 2016, by Dominic
At Village we push Excel Macros to their limit. Excel’s accessibility and omnipresence are its greatest strengths. It’s a pretty safe bet that you’ll have opened it up at some point to do some calculations or plot some graphs. Maybe you’ll have e-mailed a spreadsheet of data to a client or stored it on a shared drive so that a colleague can see your results.
Excel’s accessibility and omnipresence are its greatest weaknesses, as people feel empowered to use its more complex features. Multiple users will try and access sheets at the same time, risking data integrity issues. Users might start writing macros without understanding what they’re really doing and end up with workbooks that act unexpectedly or crash. Maybe you’ve inherited someone else’s spreadsheet and don’t really know how it works.
We can help you wrangle spreadsheets that have grown out of control. Often the best solution might be to migrate to a sturdier platform; we can assist with that process. Other times there is a business case for sticking with the software that you know and we can use our wealth of design experience to build robust systems that use the full breadth of Excel’s capability.
With our help, your spreadsheets can integrate with your various operational databases. They can present easy-to- use data entry tables or forms. We can automate your data manipulation and calculation and generate in nicely-formatted paginated reports for printing and distribution. We can also set up other systems to pull data from the spreadsheet - maybe you’d be interested in our Business Intelligence stack.
It might be a technology from the last century, but it’s still commonplace. If you’re in need of a spreadsheet saviour, maybe we can help.
So drop us an e-mail, because we’re email@example.com
PECTAB for rail tickets 8 October 2015, by SteWhether you buy your rail tickets online, from the ticket office, or at a self-service kiosk, they always look the same. And in all likelihood, they come out of the same model of printer!
We've been working with the Newbury Data ND4020 and ND4030 printers for a couple of years now, integrating them into kiosk products to vend magstripe tickets and contactless cards (respectively). Consequently, one of the things we've become experts in is the "PECTAB" language, which is used to print ticket text.
PECTAB is a contraction of "Parametric Tables", and it works like a stylesheet for serial devices. Ticket printers contain a thermal print head just like in a receipt printer, but whereas those devices often need the KPL language to describe layout, here we use PECTAB to format a list of text lines. I think this goes to show the broad range of skills that are needed to build a feature-complete self service device!
Naturally, as developers, we had to build a tool which let us rapidly test different PECTAB designs. That's why myself and new developer Ankit built 'Pectabber' (pictured). This means we can rapidly iterate on designs according to your needs. Not only that, but our connections to rail industry web services like SilverRail mean that we can produce standard-compliant tickets without an minute of original design work being done.
Are you creating a new ticketing product for rail or any other industry? Do you want the benefit of the hardware and software expertise which we bring to the table? Well, we're firstname.lastname@example.org; just get in touch for more information!
Ankit joins the crew 14 September 2015, by SteWe've got a new Villager! Ankit Soni joined us today as our graduate trainee developer. We're all joyful to be growing the team, and gaining a friendly new colleague.
Now we face the dilemma of every web-facing company... when to find the time to update the Staff page!
Contactless payments in the UK; a history 4 September 2015, by Ste
Contactless payment saves you time when you check out that coffee/bag of shopping/train ticket. But you knew that already, because you've either experienced it, or enviously await the day you actually have a contactless card!
Paying this way means you don't need to put in a PIN or a signature. As a result of this lack of authentication, there's a limit on how much you can pay for at once. I'd like to make a little reference here of the history of contactless roll-out in the UK and the transaction limits that went with it.
2007 - £10
- The UK Cards Association tell us that contactless cards were introduced to the UK in 2007, although reports differ
- The initial transaction limit was £10
- The first contactless cards are issued by Barclaycard
- EAT becomes the first restaurant chain to accept contactless payments
June 2010 - £15
- The transaction limit rises to £15 thanks to pressure from MasterCard and Visa, coming closer to the eurozone limit of 25 EUR.
- McDonalds lead another charge in adoption of the technology. Interestingly, at time of writing in 2015, their limit for transactions is still just £15. Maybe they should call us for help with reprogramming their payment devices?
June 2012 - £20
- The limit rises to £20 as adoption increases nationally
September 2015 - £30
- The latest limit increase, to £30, means that the UK's average shopping bill of £25 is now covered.
Which brings us up to the present day. I use my contactless card every day, I just wish ASDA's self checkout would support it! At Village Software, we integrate payment devices from Ingenico and ViVOTech to enable quick and convenient payment. If that's something you'd like to talk about, please get in touch with us; we're email@example.com.
New Graduate Blood Needed 28 July 2015, by Johnny
We are once again looking for fresh blood at Village, it's been a year since Dom arrived as a fresh faced recruit and he has now heard all my jokes so it is time to get someone new in. The photo below shows Dom's face (on the right) described by Ste as 'Mortified' for showing what I (on the left) think of as fashion sense, he is now campaigning against dress down Friday as too dangerous.
In our last round of appraisals we found out why we like working together as a team, well who doesn't. It came down to a sense of empowerment to have your technical opinion listened to, a family feel to the company which I think means that people know that we are looking out for each other and have a sense of values. There is solid and varied work to crack on with and we are enough in touch with our inner geek to enjoy solving business problems by writing software.
I've been talking with some of our clients, most of whom have their own teams, about recruiting software developers and how to find or be found by someone who fits. Because we have to face it we are not Google, we don't have the money to pay super salaries, there isn't a company jet, no-one is going to be resigning their 6 figure salary job in New York to hit the VillagePlex, it is a bit of a lifestyle option I guess. But we do like coming to work, we put food our tables and we get to play with software, what is not to like. Oh and there's dress down Fridays, although to be honest I normally just wear a work shirt to avoid the dangers of T shirt synchronisation shown above.
If you know someone who might want to be part of Village by all means get them to drop us a line, see our careers page, or probably talk to one of the recent graduates. You don't have to have a planet 'T' shirt but realistically you have got to like and be good at programming.
1 2 3 4 5 6 7 8 9 10 Older →