DavidOverton.com
This site is my way to share my views and general business and IT information with you about Microsoft, IT solutions for ISVs, technologists and businesses, large and small.  

Blogs

  • UK 2024/25 Excel formulas to work out take home, NI and income tax.

    I know most people don't need this sort of information, but since I just entered it into a spreadsheet and found the information wrong in Co-Pilot, I thought I'd share the correct information. In the UK, NI rates can be found here and income tax rates can be found here. The formula to calculate NI is as follows.  I've used the LET function to make it easier to read. This presumes the annual salary is in cell A1. If you want a monthly figure, you will need to divide PT and UEL by 12 (directly in the formula eg “12570/12”) =LET ( salary , A1 , PT , 12570 , UEL , 50270 , rate1 , 0.08 , rate2 , 0.02 , IF ( salary <= PT , 0 , IF ( salary <= UEL , ( salary - PT ) * rate1 , ( UEL - PT ) * rate1 + ( salary - UEL ) * rate2 ) ) ) The UK Tax calculation would look like this. It has a lot of variables. =LET ( salary , A1 , pension_rate , 5%, pension_contrib , salary * pension_rate , adjusted_salary , salary - pension_contrib , base_PA , 12570 , BR , 50270 , HR , 125140 , rate_basic , 20% , rate_higher...
    Posted to David Overton's Blog by David Overton on Thu, Aug 29 2024
    Filed under: ,
  • Webinar: Overcoming the challenges of a Dispersed Workforce Apps, Data and Security

    British Computer Society on delivering solutions for remote working during the Covid Pandemic.

    ...
    Posted to David Overton's Blog by David Overton on Wed, Aug 5 2020
    Filed under: , ,
  • Citrix Essentials seems to be edging out the partners whilst Awingu is welcoming them

    Azure RemoteApp was the official Microsoft way to run your Windows Desktop Applications on Azure and access them from any device. The service was only available for a short time before Microsoft closed the solution stating that you would need a partner’s software to complete a solution. Awingu is one such partner, offering the ability to access your Windows applications via any html browser on any device without the need for plug-ins or downloads, while ensuring a highly secure solution. Awingu offers so much more than this though as Awingu is a Workspace Aggregator. We offer Single Sign On to all your cloud applications and access to all your files, whether on internal file shares or stored in cloud solutions. This is wrapped in security while enabling easy collaboration. Have a look at http://www.awingu.com/awingu-vs-azure-remoteapp to see how much more Awingu offers. We expect our partners to implement and manage the solution and if they want, our partners can deliver this as a multi-tenant service to...
    Posted to David Overton's Blog by David Overton on Thu, Feb 9 2017
    Filed under: ,
  • How to Use Office Conditional Formatting to put in icon sets comparing a range of cells, or relative references as Office calls it

    So it has been a while since I last dropped out a blog, but this one was useful to me at work, so I thought I would share. Office 2016 (or 2013 and 365) has some lovely functions, one of them being conditional formatting. I use this quite a lot, but one thing stumped me. Below is what I wanted to get to: When I wanted to compare to tables of data and put in place icons to show if the data had moved up or down, I could not do it. Excel would politely tell me that “This type of reference cannot be used in a Conditional Formatting formula” Now, not being one to like these limitations, I realised that I could do it cell by cell, but that would be an awful lots of mouse clicks, so I’ve written this short piece of VBA to do it for you. To open the VBA environment, press-Alt-F11 then right click your VBAProject and select Insert Module. You can then paste the code from below into that window and modify the CompareIcons sub to match your needs. The “CompareIcons” sub makes a call GenericIconsComparison...
  • Fixing my Office 365 Lync Voice (P1) and PGi world wide phone integration problems–error ID 3110 (source ID 243)

    I use Office 365.  Probably no surprise for many, but I like the world wide access and simplicity.  However, since leaving Microsoft I found having to Skype people a little frustrating if I wanted to host a multi-party conference call, especially if some people need to dial in using a phone, rather than Lync from a PC.  To this end I ended up purchasing a certified solution from PGi. PGi charge me per minute per person and I have dial in and out capability, so I can dial people to join the call and people can dial in with numbers for most countries around the world.  Perfect, just like the solution I had when I worked at Microsoft. Except it didn’t work.  People could dial the conference number and hear each other and others could be connected via VoIP, but the two groups could not hear each other. Not the solution I wanted.  I ran the DNS tests that Microsoft asks for and did test calls with the nice people from PGi, but nothing was showing up as the error.  Searching the internet...
    Posted to David Overton's Blog by David Overton on Sun, Sep 22 2013
    Filed under: ,
  • Version 7 of Sync for SkyDrive

    Thank-you for your interest in Sync for SkyDrive. Following all the feedback from version 1, 2 and 6 I’ve finished release 7 (version number 7.0.0.2 in the store) and submitted to the Windows Store where it will be available here: The tool is not free, but it is at the lowest price point I can make for the Windows Store (from the UK). The purpose of the tool is very simple, to enable you to synchronise chosen folders from Microsoft SkyDrive to a Windows RT (or Windows 8) device. While I would like this to be something that happened automatically, the processing time required does not fit into the Microsoft allowed timings for a Windows RT/8 device for battery consumption, so this is still a “user initiated process”. While Windows 8 has a synchronisation tool for the desktop, Windows RT does not, so here is my offering in this space. How does it work The tool scans chosen folders on SkyDrive and the matching folders on your Windows RT device and draws up a list of differences. You can then choose...
    Posted to David Overton's Blog by David Overton on Mon, Mar 25 2013
  • Version 6 of Sync for SkyDrive

    Thank-you for your interest in Sync for SkyDrive. Following all the feedback from version 1 and 2, I’ve finished release 6 (version number 2.0.0.26 in the store) and submitted to the Windows Store and can be found at the Windows Store: [27th March 2013] A new version of the application is now in the Windows Store. You can find details of it here . The tool is not free, but it is at the lowest price point I can make for the Windows Store (from the UK). The purpose of the tool is very simple, to enable you to synchronise chosen folders from Microsoft SkyDrive to a Windows RT (or Windows 8) device. While I would like this to be something that happened automatically, the processing time required does not fit into the Microsoft allowed timings for a Windows RT/8 device for battery consumption, so this is still a “user initiated process”. While Windows 8 has a synchronisation tool for the desktop, Windows RT does not, so here is my offering in this space. How does it work The tool scans chosen folders...
    Posted to David Overton's Blog by David Overton on Fri, Mar 8 2013
  • Sync for SkyDrive–version 2 for Windows RT and Windows 8

    Version 2 of Sync for SkyDrive [9th March 2013] A new version of the application is now in the Windows Store. You can find details of it here . Thank-you for your interest in Sync for SkyDrive. Following all the feedback from version 1, I’ve finished version 2 and submitted to the Windows Store. When it is released I will update this with store location. The tool is not free, but it is at the lowest price point I can make for the Windows Store (from the UK). The purpose of the tool is very simple, to enable you to synchronise chosen folders from Microsoft SkyDrive to a Windows RT (or Windows 8) device. While I would like this to be something that happened automatically, the processing time required does not fit into the Microsoft allowed timings for a Windows RT/8 device for battery consumption, so this is still a “user initiated process”. While Windows 8 has a synchronisation tool for the desktop, Windows RT does not, so here is my offering in this space. How does it work The tool scans chosen...
    Posted to David Overton's Blog by David Overton on Sat, Feb 16 2013
  • Sync for Windows SkyDrive

    [updated 25/02/2013] - The next version has now been submitted to Microsoft. Information on the updated version can be found here . This is an update on my Sync tool. Thank-you to all those who have provided input, submitted bugs and made other suggestions. The updated version is not yet ready to go into the Windows Store yet, but feedback and suggestions are still welcome. I’ve been asked by Microsoft to change the logo and name, so this is what we now have: [Changelog] Adding selective folder sync Made more “metro like” with reduced colours, no rounded corners, remove gradient background Bug fixing on file upload Bug fixing on file download Detect deleted files to enable removal Removed the cache files from the SkyDrive sync folder Sync activities now reported in flip out panel New 1st time experience Link to web site included in the settings menu Hopefully the updates will make people happy and unless you are syncing all your folders, after the first time start-up, scanning of both local are...
    Posted to David Overton's Blog by David Overton on Tue, Feb 12 2013
  • Simple SkyDrive Sync for Windows 8 and Windows RT

    It has taken a while to get there, however this project is now complete. I’ve managed to write a tool that keeps my SkyDrive and my Windows RT slate in sync. I’m now going through the process to publish this in the Windows Store for all to use and enjoy. [updated 8th Feb 2013] I've received a lot of feedback about the colours, gradient fills, rounded corners etc. I am working on a minor update that will change the colours and then a major update that completely change the layout, work on a folder by folder basis. [updated 12th Feb 2013] To see what the next version will look like and the feature changes, please look at my change log post . [updated 25th Feb 2013] The next version has finally been submitted to Microsoft. Details can be found here . What does the tool do? The tool scans a chosen set of folders on your hard disk and compares these to a corresponding set on SkyDrive. It then notes any where the file date or size is different, or where they only exist on one system (either as an updated...
    Posted to David Overton's Blog by David Overton on Fri, Feb 1 2013
  • Good WPF 4.5 cookbook from Pavel Yosifovich

    I was looking for a book to bring me up to date with WPF and XAML and talking to my publishers, Packt Publishing, then offered me the Windows Presentation Foundation 4.5 Cookbook by Pavel Yosifovich. I was hoping to review this book sooner, however Christmas and illness got in the way, so here is my slightly late review.  In simple terms, this was an excellent book for me.  I write in both C# and VB.Net (more VB than C#).  I’ve never used WPF or XAML except in the designers from Microsoft and my work is basically hacking those tools without enough experience.  There are lots of features that I could not get working, so I simply coded around them with my 10-20 year old programming knowledge.  This book has enabled me to change this. The book is 437 pages long excluding the index and there are 80 “recipe's” in the book.  While you can dip in and out at random, as with all good knowledge acquisition, starting at the beginning offers the best platform to understand the more complex...
  • Merry Christmas for 2012

    Click to advance through the 3 pages
    Posted to David Overton's Blog by David Overton on Thu, Dec 20 2012
  • Do you want to see what is new and search the Windows 8 Store from the web–now you can

    Hi, just a little note as I’ve been using this for a little while now.  You can access the Windows 8 store, search it and filter from this web site - http://metrostore.preweb.sk/ .  It is unofficial, however Vlko and Peter both seem open to suggestions too.   Enjoy David
    Posted to David Overton's Blog by David Overton on Fri, Dec 14 2012
    Filed under: ,
  • Upgrade Windows XP/Vista/7 to Windows 8 Pro for $40 or £25 AND Media Center Pack for free – until 31st January

    This is a simple offer. Download the upgrade assistant from Microsoft, run the tool, purchase the license for a shockingly low price and get the benefits of Windows 8. Even if you think you might not use it for a year, you can burn the ISO so it is ready. All indications are that the price will increase once this offer expires. So, what is the processes? Go to the web site - http://windows.microsoft.com/en-GB/windows/buy (UK) or http://windows.microsoft.com/en-us/windows/buy (US) Press the Download link - Download Pro for £24.99 ERP (UK) or Download Pro for $39.99 ERP (US) ) - note the link is the same for any country for the assistant. Run the assistant and fill in the details, including the purchase options There is also one other thing you may wish to consider. Getting the currently free Media Center Pack. This is also very simple, go to http://windows.microsoft.com/en-gb/windows-8/feature-packs (UK) http://windows.microsoft.com/en-US/windows-8/feature-packs (US), enter your e-mail address and get a free...
  • I’m taking a break from Microsoft

    Hi, I’ve always been open and honest on my blog and it is time to share broadly the news that I’ve left Microsoft.  I’ve been considering my career and a few things became apparent. I wanted a break .  When I joined Microsoft over 12 years ago, a sabbatical was part of the deal.  While this changed during my employment, I’ve decided to take one anyway, so I’ve been putting my feet up over the last few weeks and will continue to do so into the new year.  Obviously, I’m not sitting at home completely idle, but it does mean that I’m generally here when my girls get home from school and cannot say a pressing piece of work is keeping me from spending time with them.  This is something I’ve wanted to do for a while, but not been able to do so while in full time employment.  Playing The Gunstringer (includes Fruit Ninja Kinect) with Lizzy or visiting the Royal Institute with Molly tonight for the filming of the Christmas Lectures are just two highlights. Finding a new passion .  Looking...
    Posted to David Overton's Blog by David Overton on Thu, Dec 13 2012
    Filed under:
  • Windows 2012 jump start videos

    Hi, Just a quick note to say that these were shared with me today and they came from the blog at http://blogs.msdn.com/b/microsoft_press/archive/2012/06/27/free-videos-on-windows-server-2012-from-the-jump-start-series.aspx • Designed for Microsoft Partners, early adopters, and experienced IT Pros/ITDMs familiar with Microsoft server technologies • All twelve (12) modules are under an hour and packed with engaging discussion and real-world demos -- watch them all! Links to Every Module from this Jump Start The HD-quality video recordings of this course are published to TechNet Edge and are highly recommended. Windows Server 2012 is a game-changing release for so many reasons and this course will help experienced IT Pros truly understand why -- check it out! • Windows Server 2012 Jump Start (01): Core Hyper-V • Windows Server 2012 Jump Start (02a): Virtualization Infrastructure, Part 1 • Windows Server 2012 Jump Start (02b): Virtualization Infrastructure, Part 2 • Windows Server 2012 Jump Start (03a): Storage Architecture...
  • Getting my Nokia Lumia 800 to work with Virgin Mobile UK MMS settings (and trimming the SIM too)

    I recently fell of the back of a boat which resulted in my faithful Samsung Omnia being written off.  Since this was a personal phone, I decided to upgrade to a Nokia Lumia 800 as it looked like a fab phone.  I have so far not been disappointed, however I hit two problems. The first was that my SIM was not a micro-sim. I contacted Virgin who told me they were very soon to launch a micro-sim, but not yet.  I bought a 30-day sim from Vodafone in the short term, but then discovered that I could trim the current SIM to fit by following the detailed instructions at http://www.solutios.com/simcutting/ .  All has been happy until my wife asked about sending MMS pictures from her phone.  When I tried to do it from mine, I discovered that it kept on failing with an error and asking me to try again.  This has been the second challenge that I have had with the phone! Searching the web found many frustrated people, some who had resorted to resetting their phones to factory defaults to get things...
    Posted to David Overton's Blog by David Overton on Sat, Jun 2 2012
  • UK / EMEA Virtual Desktop Infrastructure (VDI) Practice Accelerator, 16th April, Live Meeting 4 day course

    I saw this and thought I should share it ASAP. Virtual Desktop Infrastructure (VDI) Practice Accelerator, 16th April, Live Meeting Description: 4 day organisational training for partners interested in developing a Virtual Desktop Infrastructure practice. Can be paid for using advisory hours. Microsoft Virtual Desktop Infrastructure empowers enterprises with unified management of centralized desktops and corporate data through Microsoft System Center technology. Microsoft VDI offers tremendous value by providing a high performance virtual desktop platform while reducing the cost of deploying virtual desktops. Citrix technology adds value to the Microsoft VDI stack by offering additional scale and flexibility. Take Practice Accelerator for VDI and help your customers extend existing management tools and processes to the virtual desktop environment while reducing management overhead, enabling rapid deployment, improving operational efficiencies and driving business agility. Ten Partner Advisory Hours will be deducted...
    Posted to David Overton's Blog by David Overton on Sat, Apr 7 2012
    Filed under: , , ,
  • IE6–> IE8/9/10 and Windows 7 compatibility events with Citrix, Camwood and Quest (3 events)

    Microsoft have teamed up with Camwood , Citrix Systems and Quest Software , all application compatibility experts, to help show you the range of solutions available to help you overcome App Compat road blocks. Join them to learn how browser compatibility issues occur, how to overcome them with Group Policy , virtualisation and simple application fixes and how to develop a successful migration plan. Not only that, they will also cover some of the latest App Compat tools and techniques that apply to desktop, web and server compatibility issues. Take your pick of the dates below and use the links to find out more and Register Now with our partners. Who, Where & When? Thurs 22 nd March Microsoft & Citrix AppDNA Chalfont St. Peter (Easy access via the M40 & M25 as well as rail) 09:00 – 16:00 Register Here Thurs 19 th April Microsoft & Quest ChangeBASE Reading Football Ground (Madejski Stadium) 09:30 – 14:00 (+Stadium Tour!) Register Here Thurs 3 rd May Microsoft & Camwood Cote St Paul’s, London...
  • Turn off Ctrl-Alt-Del in Windows 8

    This is a very quick one.  I saw the videos and saw that Ctrl-Alt-Del was turned off in Windows 8.  While this can be done by setting the local security policy, it can also be done via command prompt.  This is no different to other versions of Windows. If you search for cmd and then right click it to select Run as Administrator Then once cmd is running, use this command (it is all one line) to turn off C-A-D as a requirement: REG ADD HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System /v DisableCAD /t REG_DWORD /d 1 /f To turn it back on, use this command: REG ADD HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System /v DisableCAD /t REG_DWORD /d 0 /f   That is it.   ttfn   David
    Posted to David Overton's Blog by David Overton on Sat, Mar 3 2012
  • Windows Server 8–Remote Desktop and VDI enhancements

    VDI and RDS have been something I’ve been writing about, so I wanted to share the documents I’ve discovered from Microsoft that discuss the new features for VDI and RDS. The 3 documents are: Understand and Troubleshoot Remote Desktop Services in Windows Server "8" Beta This Understand and Troubleshoot Guide (UTG) enables you to learn technical concepts, functionality, and troubleshooting methods for Remote Desktop Services in Windows Server “8” Beta. Date Published: 2/29/2012          Download This Understand and Troubleshoot Guide (UTG) enables you to learn technical concepts, functionality, and troubleshooting methods for Remote Desktop Services in Windows Server “8” Beta. This UTG provides you with: • A technical overview and functional description of this feature. • Technical concepts to help you successfully install, configure, and manage this feature. • User Interface options and settings for configuration and management. • Relevant architecture of this...
  • My Top Tips for Windows 8 so far–closing windows, dual booting, using the keyboard and mouse

    Hi, I loaded Windows 8 Consumer Preview with some concerns about how the new interface would impact me.  As a keyboard user, the Developer Preview just didn’t do enough for me, however Windows 8 is now my primary home OS and I’m loving it.  What is more, my daughter is once again asking to have it (as she wants “Snap”) for her applications. So my top tips are: How to close a Metro Application There are two ways to do this – dragging the open application from the top of the screen to the bottom – you will see something like the screen below (top half is once it is grabbed and the bottom half is as it is dragged to the bottom of the screen). The second way to do this is to hover in the top left corner and one Metro application will show.  However if we now scroll down the left edge the other open applications will show.  We can now right click on one of those and select close. It is also worth noting that we can also snap the application to the left or right hand side of the screen too. Of course...
    Posted to David Overton's Blog by David Overton on Thu, Mar 1 2012
    Filed under: , ,
  • Does Windows Intune require an underlying operating system to load Windows 7 Enterprise Edition?

    I just saw this question being asked, so thought I would should with everyone: Question: “If I have a paid subscription to Windows Intune, do I need an existing Operating System to install the Windows 7 Enterprise license included with the subscription?” Answer: Yes – from the FAQ: What are the Windows 7 Enterprise upgrade rights included with Windows Intune? All of your managed PCs covered by Windows Intune may be upgraded to Windows 7 Enterprise as long as the qualifying OS is one of the following business editions of Windows: Business, Professional, Ultimate, or Enterprise. The machines must also meet the Windows 7 system requirements. This list can be found at http://windows.microsoft.com/systemrequirements . In addition to Windows 7 upgrade rights, Windows Intune customers will also have rights to upgrade to future versions of Windows, as well as downgrade rights to older versions. As long as your subscription is active, you will have access to the best version of Windows for your business to standardize...
    Posted to David Overton's Blog by David Overton on Tue, Feb 28 2012
  • Upgrade from Windows XP to Windows 7 and manage the PC’s–Windows Intune did this for eLitigation Solutions and reduced IT spend by 30%

    Hi, I’ve just seen the case study on eLitigation solutions and how they did this and reduced costs by 30% in the process.  The case study can be found here .  Electronic Discovery Firm Reduces IT Costs by 30 Percent with Cloud-Based PC Management To meet its various business requirements, eLitigation Solutions needed a stable, well-monitored, and regularly updated PC environment, but the company also wanted to simplify and reduce the cost of managing its PCs. In 2011, eLitigation began using Windows Intune to manage, monitor, and update its PCs. Now the company has standardized its PC environment, enhanced security, and reduced PC costs by 30 percent. This was the problem: Most eLitigation employee PCs were still running the Windows XP operating system and the company wanted to upgrade its PCs to the Windows 7 Enterprise operating system. But at the same time, eLitigation needed to simplify and reduce the cost of managing its PC environment. The Solution: The company worked with InfinIT Consulting, a...
    Posted to David Overton's Blog by David Overton on Tue, Feb 28 2012
  • Windows Intune feedback and support tools and useful blogs

    I’ve been reading and responding to the posts on the Windows Intune forums site and realised that I should share with everyone the support and feedback tools available for us.  These enable conversations with the support teams and input into the people making decisions about updates and major releases for Windows Intune.  The following sites are available: Support Forum Support for Windows Intune Microsoft Online Services support The forum has responses from the community as well as great Microsoft support people. This site provides resources to enable you to access support by phone and e-mail on technical, non-technical issues, Windows and MDOP This site provides the details for phone and support page access to help with the Microsoft Online Services Customer Portal (MOCP)   Feedback Windows Intune feedback This site provides free-form feedback to the Microsoft team, so not support issues, but product hits, misses and desires   I hope this helps you get more out of Windows Intune as well as...
    Posted to David Overton's Blog by David Overton on Mon, Jan 30 2012
1 2 3 4 5 Next > ... Last »

(c)David Overton 2006-23