Almost every person of a technical persuasion who has worked in an office will have some tale of wildly inappropriate use of office technology for a task that could have been accomplished far more simply with an appropriate tool. There are jokes about people photocopying a blank sheet of paper when they need a few sheets themselves, but some of the real stories are very bit as surreal.
[Bjonnh]’s patience for such things was exceeded when he received a screenshot embedded in a Microsoft Word file. His response is both pointless and elegant, a Python script that takes a JPEG image and encodes it into an Excel file. It’s simply an array of cells whose background colours represent the pixels, and he warns us that the output files may take a while to load. We just had to subject it to a test, but are sorry to report that LibreOffice doesn’t seem to want to play ball.
So yes, this is a small departure from our usual fare of hardware, and it serves no use other than to be a fantastically awful misuse of office technology. If you’ve ever been emailed a PowerPoint invitation to the office party though, then maybe you’ll have cracked a smile.
If pushing your corporate spreadsheet to the limit is your thing, perhaps you’d also like to see it running a 3D engine.
A pile of Raspberry Pis isn’t what would spring to mind for most people when building a system to control a large office, but most people aren’t [Kamil Górski]. He decided to use Pis to run the office of his company Monterail when they moved to a larger space. The system they built is one of the largest Pi installations we have seen, controlling the lights, TVs, speakers and door access. It can all be controlled through a web interface, so anyone on the network can turn the lights on or off, check if a room is occupied or send sound and video to the fancy AV system in the conference room. He even hacked a bunch of HDMI switches so that every TV can show the same image if everyone wants to watch the same event. Even the radio station that plays in the lounge is controlled remotely from an employee slack channel.
The system is run on five Pis, one of which acts as a master, while the others are connected to each of the TVs, running Chrome in console mode being remotely controlled through the Chrome Debugging Protocol. That allows anyone on the network to control the display and send content to it. One interesting thing to note: [Kamil] freely admits that this is a bespoke system that couldn’t be easily sold as a product. Nothing wrong with that, but he decided to build in some backups: if the whole system fails, all of the lights, doors, and other devices can still be controlled through old-school switches, keys, and remote controls. Even a full system crash doesn’t render the office unusable. That’s a wide precaution that many people forget in systems like this.
Finding a good work space at home isn’t a trivial task, especially when you’ve got a wife and kid. A lot of us use a spare bedroom, basement, or garage as a space to work on our hobbies (or jobs). But, the lack of true separation from the home can make getting real work done difficult. For many of us, we need to have the mental distance between our living space and our working space in order to actually get stuff done.
This is the problem [Syonyk] had — he needed a quiet place to work that was separated from the rest of his house. To accomplish this, he used a Tuff Shed and set it up to run off-grid. The reason for going off-grid wasn’t purely environmental, it was actually more practical than trying to run power lines from the house. Because of the geology where he lives, burying power lines wasn’t financially feasible.
Continue reading “Working in Peace With an Off-Grid Office Shed”
[Stian] thought it would be nice if his coworkers could be electronically notified when the latest batch of coffee is ready. He ended up building an inexpensive coffee alarm system to do exactly that. When the coffee is done, the brewer can press a giant button to notify the rest of the office that it’s time for a cuppa joe.
[Stian’s] first project requirement was to activate the system using a big physical button. He chose a button from Sparkfun, although he ended up modifying it to better suit his needs. The original button came with a single LED built-in. This wasn’t enough for [Stian], so he added two more LEDs. All three LEDs are driven by a ULN2003A NPN transistor array. Now he can flash them in sequence to make a simple animation.
This momentary push button supplies power to a ESP8266 microcontroller using a soft latch power switch. When the momentary switch is pressed, it supplies power to the latch. The latch then powers up the main circuit and continues supplying power even when the push button is released. The reason for this power trickery is to conserve power from the 18650 li-on battery.
The core functionality of the alarm uses a combination of physical hardware and two cloud-based services. The ESP8266 was chosen because it includes a built-in WiFi chip and it only costs five dollars. The microcontroller is configured to connect to the WiFi network with the push of a button. The device also monitors the giant alarm button.
When the button is pressed, it sends an HTTP request to a custom clojure app running on a cloud service called Heroku. The clojure app then stores brewing information in a database and sends a notification to the Slack cloud service. Slack is a sort of project management app that allows multiple users to work on projects and communicate easier over the internet. [Stian] has tapped into it in order to send the actual text notification to his coworkers to let them know that the coffee is ready. Be sure to watch the demo video below. Continue reading “Alarm Notifies the Office When the Coffee is Ready”
[Cornel Masson] is a 46-year-old computer programmer. He’s been working on his computer for the last 30 years. Computer work can be good for the wallet but it can be bad for our health, particularly the neck and back. You can purchase adjustable desks to allow you to change positions from sitting to standing, but unfortunately these desks are often expensive. [Cornel] took matters into his own hands and build his own adjustable riser for under $100.
To start, [Cornel] used a typical computer desk. He didn’t want to build the entire thing from scratch. Instead he focused on building a riser that sits on top of the desk, allowing him to change the height of both the monitor and keyboard. His design used mostly wood, aluminum stock, threaded rods, and drawer slides.
The main component is the monitor stand and riser. The riser is able to slide up and down thanks to four drawer slides mounted vertically. [Cornel] wanted his monitor to move up and down with ease, which meant he needed some kind of counter weight. He ended up using a gas strut from the trunk of a Nissan, which acts as a sort of spring. The way in which it is mounted makes for a very close approximation of his monitor’s weight. The result is a monitor that can be raised or lowered very easily. The stand also includes a locking mechanism to keep it secured in the top position.
The keyboard stand is also mounted to drawer slides, only these are in the horizontal position. When the monitor is lowered for sitting, the keyboard tray is removed from the keyboard stand. The stand can then be pushed backwards, overlapping the monitor stand and taking up much less space. The keyboard stand has small rollers underneath to help with the sliding. The video below contains a slideshow of images that do a great job explaining how it all works.
Of course if replacing the entire desk is an option go nuts.
Continue reading “An Adjustable Sit/Stand Desk for Under $100”
The elevator at [Alex]’s office building has some quirks which make it very inconvenient to everyone in the building. The major problem was that the doors of the elevator at each floor stay locked until someone walks down the hall to hit a button. Obviously this was a hassle, so [Alex] built a controller that can remotely call and unlock the elevator. (Part 2 of the project is located on a separate page.)
The first step was to source the hardware and figure out exactly how the controls for the elevator worked. [Alex] decided to use an Electric Imp for this project, and after getting it connected to the Internet, he realized that he could power it directly off of the elevator’s 10V supply. From there, he used relays to interface the Electric Imp with the “elevator call” and “elevator unlock” buttons inside the elevator’s control panel.
Once the hardware side was completed, it was time to move on to the software side. [Alex] wrote a mobile app for a user interface that can be accessed from anywhere, and also wrote the code for the Electric Imp agent and the code that runs on the Electric Imp itself. Now, a simple tap of a button on a mobile device is enough to call the elevator or unlock it, rather than in the past where someone had to run down a hall to hit the button.
We hope there is some security on the mobile app, otherwise anyone in the world will be able to call the elevator and turn it into a passenger-less useless machine!
Before this project, [David]’s office had a fairly terrible system to tell everyone who was in the office, who was out, and who wasn’t coming in today. Velcro and whiteboards will do the job, but arcade buttons and LEDs called to [David], leading him to create this In/Out Status Board.
The old system consisted of a whiteboard on the side of each partition, with velcroed labels indicating if a particular person was in the office today, out, sick, or on holiday. Inconvenient to change, and there was no single place everyone could look to see if a particular person was in or not. The new system consists of a four-person pod with four arcade buttons and WS2811 LEDs, an Arduino Nano, and a 433 MHz radio. The main panel is just a bigger version of the four-person pod, keeping track of everyone in the office.
A single button switch will change a person from being in to being out, with longer presses necessary for ‘sick’ and ‘vacation’. It’s interesting to note what’s not included in this build: A fingerprint scanner was out of the question, because that would effectively eliminate anyone ever being marked as ‘sick’. An RFID tag reader was out for the same reason. Also not included is a display. That’s just fine, really – [David] won’t be changing the labels very often, anyway, and that would just add to the cost and complexity of the project.