Useful Technologies

" 1 down vote Instead of writing the very long: =OFFSET(INDIRECT(ADDRESS(ROW(), COLUMN())),0,-1) You can simply write: =OFFSET(*Name of your Cell*,0,-1) Thus for example you can write into Cell B2: =OFFSET(B2,0,-1) to reference to cell B1"

"This report sets out the findings of a review exploring how distributed ledger technology can revolutionise services, both in government and the private sector. It covers the: technology governance and regulation security and privacy disruptive potential applications in government global perspectives It recommends 8 actions for government to maximise the opportunities and reduce the risks of this new technology."

"In the opening chapter of his famous Lectures on Physics, Richard Feynman pondered the nature of science, the laws of physics, and the best way to teach it all. He emphasized that much of the vast accumulation of scientific knowledge could be condensed into some essential principles that allowed all sorts of sophisticated deductions."

"TeamViewer - the All-In-One Software for Remote Support and Online Meetings Remote control any computer or Mac over the internet within seconds or use TeamViewer for online meetings. Find out why TeamViewer has been activated on more than a billion devices."

Connectivity Tests for network services and computer profiles

"One of the biggest issues concerning UHD/4K is how it will be encoded/compressed and what bit rate will be required to convey a high-quality image. As I've written before, everyone at NAB 2014 seems to have settled on H.265 (aka HEVC or High-Efficiency Video Coding) as the codec of choice for UHD/4K. HEVC is said to offer up to 50 percent greater efficiency than H.264 (aka AVC or Advanced Video Coding), which is often used for high-def content, and even greater gains in efficiency over MPEG-2.   So I was particularly interested in a presentation called "Bit Rate Requirements for HEVC: Comparing H.265, H.264, and MPEG-2" by John Pallett, Director of Product Marketing for Enterprise Products at Telestream, a company that provides video capture, encoding, transcoding, and network-based delivery. The testing he discussed was based on SD and HD content, not UHD, but the findings should apply similarly."

"I've got a Panasonic HC-V750 camcorder which supports AVCHD and MP4. The highest quality AVCHD settings are called "1080/60p", while the highest quality MP4 settings are called "1080/50M" (also at 60p). Both are 1920x1080 full HD resolution.   When I check out some sample files recorded in those 2 formats with MediaInfo, I see the AVCHD bitrate is variable and seems to be in the 22.8 - 25.0 mbps range, while the MP4 bitrate is close to the advertised "50M" at a variable 45.4 - 49.2 mbps.   So, although I know the answer is a bit subjective, I am interested in which format people think has better video quality.  By bitrate and file size alone, I would be inclined to say MP4 in this scenario.  But the instruction manual implies that the AVCHD is better quality.   FYI: on the audio side, the AVCHD has AC3 384 kbps 6 channel audio, while the MP4 has AAC 128 kbps 2 channel, so the AVCHD AC3 audio clearly seems superior."

Change the time until voice mail for iPhone

How to Remove One Color from Your Image (Photoshop CS6 - Beginners)

"Gatekeeper is new security feature starting in Mac OS 10.8. See http://support.apple.com/kb/HT5290 for more information about Gatekeeper features and benefits. If you are unsure what version of the Mac OS you are running, see http://its.uiowa.edu/support/article/101460.  You can find Gatekeeper settings in System Preferences > Security & Privacy > General. To disable Gatekeeper, click on the lock on the lower left of the window and type in your system password. By default Gatekeeper will only open apps purchased and downloaded from the Mac App Store or from a list of "identified developers" that have been given the ok from Apple by obtaining an unique Developer ID.  To install other apps, select the option to install from Anywhere."

"Connect your iPhone, iPad, iPod touch, and Mac using Continuity Continuity lets you seamlessly move between your iPhone, iPad, and Mac, or use them together. Continuity features include Handoff, Phone Calling, Instant Hotspot, and SMS. You can start an email or document on iPhone, for example, and then pick up where you left off on your iPad. You can use your iPad or Mac to make and receive phone calls through your iPhone."

"IPAD AIR FLEXIBLE STAND PED4 COIL IPA10 PIVOTING & GOOSENECK The long, snake like, flexible, gooseneck coil stand can be manipulated into any shape you imagine to hold your iPad Air. The PED4 Coil IPA10 is Made in USA from solid and flexible steel. The PED4 Coil IPA10 iPad Air stand can be mounted anywhere and everywhere you can imagine."

"Your Mac's built-in screen recorder Posted on Wednesday, January 8th, 2014 at 5:54 am. PT Written by Dave Mark Not sure when this feature got added, but since this was new to me, thought this was worth sharing. Launch QuickTime Player (it's in your Applications folder). Now select New Screen Recording from the File menu, or type control-command-N. A small screen recording window will appear, like so:"

"Free Screen Capture Tool on Mac DuckCapture for Mac is a free screen capture tool for Apple Mac OS X! The major functionalities have been introduced in Free Screen Capture Tool, this article will be focusing on installation and usage on Mac OS X."

"first glance, the bright red shipping container that sits by the side of the road in a slum outside Johannesburg doesn't look like something that could transform hundreds of lives. Two sliding doors open to reveal a small shop counter, behind which sit rows of canned food, toilet paper, cooking oil, and first-aid supplies. Solar panels on the roof power wireless Internet and a television, for the occasional soccer game. And two faucets dispense free purified drinking water to anyone who wants it."