Merry Christmas

@YellowsBestLtd we would like to thank our Customers for your enquiries and orders throughout this year, as well as our Suppliers for your support.

We’re pleased to have been of assistance providing services and solutions. Now into our fourth year of trading, we appreciate your continued interest and support, and look forward to continuing our business relationship in the New Year ahead.

Wishing a Merry Christmas to you and your family.  

Three years milestone

Three years completed; onward in our fourth year!

@YellowsBestLtd has now reached the significant milestone of completing three years of trading; something often useful to be able to state when qualifying for opportunities and registering with business customers.

Our aim continues to be “Keeping Customers Operational”; understanding requirements and fulfilling them by providing a range of management services and solutions, including:

  • consultancy, such as business development planning3_years_services
  • technical support, e.g. day-rate engineering, NMS assistance
  • systems supply, including legacy IT servers / workstations
  • spares for infrastructure, in particular telecoms and CCTV cameras
  • repairs at module and component level, e.g. LED displayboards
  • value recovery through reverse logistics, resale and recycling

As we move forward in year four, we’d very much like to discover what else to provide to our existing Customers, as well as what would be of interest to potential clients. We’re always keen to enhance our range of #business services, increase the #enterprise infrastructure we support and expand our mix of #sustainable solutions we offer for supply and maintenance of new and legacy #technologies and products.

Please get in touch to discuss your challenges; whether you’re implementing new systems or maintaining existing infrastructure to serve your operational business needs. We look forward to hearing from you.

Solar energy project

“Off-grid eCharger”

The aim of this ‘off-grid’ solar energy project was to build a charger for an eBike so that its battery could be charged (when not in use) from power collected from the sun via a ‘fixed’ off-grid installation, rather than relying on mains energy. This can also be used for other battery charging and small backup supply purposes.

Four main elements were put together to create the solar charging ‘system’:

SolarPorjectElements

Solar Panel

This fundamental part performs the key task of converting sunlight into electrical energy. There is a wide range of panel types to choose between. Firstly, sizes include the very small, through 50W, 60W, 80W and up to 100W. Thereafter, systems are typically built from connecting multiple panels together.

Solar Panel
50W Mono Flexi Solar Panel

Then, there are four main types of solar array:

a) Poly Crystalline – cheaper to manufacture, sensitive to high temperature, less efficient with a shorter lifespan
b) Mono Crystalline – more expensive, more efficient, with a longer lifespanc)
c) Thin-Film Amorphous (A-Si) – flexible, lower cost – easier to produce, shorter lifespan, lower power
d) Concentrated PV Cell (CVP) – very high performance, solar tracking and cooling required, very expensive.

Finally, there is the choice of construction type:

i) Rigid – cheapest and most solid, heavy and longest lasting
ii) Flexible – PET – light-weight and bendy, ideal for vehicles and temporary installations
iii) Flexible – ETFE – longer lasting, marine grade, can be walked on.

For this project, the aim was to use something lightweight that could be easily attached to an existing small building structure by means of the re-enforced ringlets in its corners (not all panels have these, so choosing had to be careful), rather than a permanent roof-top installation, and so the Flexible PET type was indicated.

After some consideration of likely ‘sun-hours’ – estimates tend to indicate an average of 2-3, depending on the season and weather – and also cost, a 50W 12V Mono Crystalline Flexible PET panel was selected. This size could prove to be an under-estimation for the task, but this can be supplemented later as necessary since its possible to join panels in parallel to increase current (or series, to increase voltage). That will require ‘T’ or ‘Y’ joining pieces for the MC-4 solar cable connectors, and potentially in-line fuses to protect separate ‘strings’ of connected panels (on their own they don’t need the fuses since their short-circuit current rating is sufficient).

If a panel becomes partly shaded, its whole output diminishes. Hence the advantage of having separate panels is that they may contribute more energy individually that using one large single panel. Another aspect is that it is likely that the cost of solar panels will reduce over time, and so adding to the system over time makes sense, rather than trying to ‘future proof’ the power requirement.

;

Charge Controller

The task performed by this element is to ‘condition’ the output of the solar capture, converting an unregulated supply of around 18V (for a single panel) to a more stable 12V, the energy from which can be directly used or stored in the battery. The use of a controller avoids the risk of over-charging of the battery or issues with varying power, and will shut off its output to the loads when the supply is diminished and the battery is discharged. There are many models, which vary in power rating and functionality, some with simple LED displays and others showing a range of information, and may include sense terminals for long cable runs, temperature measurement for adjustment due to the weather and equalisation functionality for spreading charge across multi-battery systems.

PWM Charge Controller
PWM Charge Controller

The controllers fall into two main types:

a) PWM – Pulse Width Modulation

b) MPPT – Maximum Power Point Tracking

The latter of these is much more efficient, likely to convert more of the captured solar energy into stored power. However, these tend to be at least 3 times more expensive, often much more.

A modestly–priced (reasonably-functioned) PWM unit was selected for this system, with a 20A rating (more than enough for the initial project requirements). The reasoning for this product selection is this: with a small system, should the captured energy be not enough, then purchasing additional panel(s) to increased the wattage is more cost-effective in terms of energy produced, compared with the gain from the more efficient controller. It only becomes worth purchasing the MPPT version when much more energy is being generated (and therefore ’lost’ with a less efficient charge controller).The controller model selected is capable of both 12V and 24V operation, which allows for the increase the voltage rating of the system if desired in the future.

;

Battery

The traditional choice for this type of storage application is the ‘Lead-Acid Cell’, though it needs to be of a Deep-Cycle ‘Leisure’ variety, which is intended to be frequently discharged and recharged, rather than the ‘starting’ classification which is used in a vehicle for short-bursts of energy to get a motor running, after which its mainly in stand-by and therefore expected to be 100% charged most of the time.

AGM Battery
AGM Battery

Apart from this distinction, there are two main types of product:

a) ‘Flooded’ Wet-Cell or Valve Regulated Lead-Acid (VRLA)

b) Absorbed Glass Mat (AGM) or Gelled Electrolyte (Gel)

Of these, the Wet-Cell traditionally required periodic ‘maintenance’, topping up with fluid, though VRLA sealed versions are now available, and tend to ‘vent’ gas and can’t be tipped over due to the fluid inside. The AGM and Gel types however are available maintenance-free, don’t ‘vent’ gases and don’t have fluid that can spill out.

The AGM-type was selected for this project as, whilst being a bit more expensive, offered the convenience of a product shouldn’t require special attention; these are less sensitive to over-charging and can stand for 30 days totally discharged without harm.

There are a number of measurements of the capacity and capability of batteries:

  • Reserve Capacity (RC) is how long the battery can deliver a constant current of 25A at 80F
  • AmpHour (AH / C20) represents how much charge is stored. It is the energy delivered continuously in 20 hours at 80F without falling below 10.5V
  • Cold Cranking Amps (CCA) is a measure of the ability to start an engine cold. It is the number of Amps delivered at 0F for 30sec by a 12V battery whilst maintaining at least 7.2 Volts

A capacity of 110AmH was chosen for this project.  Whilst ‘the more the merrier’ in terms of storage is certainly the case, this capacity should be sufficient for the basic storage needs.  It is advisable however to allow for discharge of only 50% of the stated rating, whilst also bearing in mind the possibility of a few days without sun.

It is possible to add batteries in Parallel to create more storage, or in Series to increase the voltage of the system. For a modest system set-up, 12V is sufficient and convenient for the purpose. Adding another battery to double the system voltage to 24V would have a side-benefit of requiring lower gauge of wiring.

;

Inverter

In order to convert the 12V DC power generated from the Solar Panel and stored in the battery, to the 240V AC required by the Load, the Li-Ion battery charger adapter, an inverter is needed. This wouldn’t be the case if a suitable 12V charger-adapter could be sourced, which would avoid the inefficient ‘double-conversion’ of 12V DC into 240V AC and back into 42V DC again. The inverter does however provide the flexibility for powering other equipment requiring an AC ‘mains’ supply and therefore is ideal for a range of charging and backup tasks.

PSW Inverter
PSW Inverter

Apart from the selecting the correct voltage, which is normally either 12V or 24V (12V required to fit with this system set-up), there are two main choices:

a) Modified Sine-Wave

b) Pure Sine-Wave

The first type is the low-cost product, and available in a wide range of power-ratings, so if high-power is required then that tends to be the preferred choice. The draw-back is that it is less-efficient, creating a ‘blocky’ AC waveform which can upset sensitive equipment. The second type produces a smooth sinusoidal AC waveform equivalent to the standard AC ‘mains’ supply, and therefore is suitable for all equipment types, though at higher cost and usually lower-power rating.

Given the performance uncertainty and potential for harm to some equipment that the MSW product might bring, and the modest power needed, it seemed sensible to select the PSW variant. A 300W product was chosen, partly limited by cost, but also since it is recommended to ‘match’ the power rating to the consumption requirements; in practice the inverter size should be around 3-7 times the power needed by the load appliance. A much higher-than needed inverter is ultimately less efficient for smaller loads, consuming more power than necessary.

.

Additional parts required were cabling and mounting accessories, plus some optional ‘add-ons’ in the form of other battery chargers and lights to make full use of the generated power:

System accessories

Accessories
Accessories – MC-4 Connectors & Cable, Light, Battery Charger, Fuses and holder

  • An extension cable to connect the solar panel to the solar controller. The panel itself comes with about 1m of ‘tails’, fitted with MC-4 connectors which are standard for solar equipment. A ‘male’ connector provides the positive supply, and a ‘female’ connector offers the return negative connection. Two cables are therefore required, with the appropriate MC-4 connectors at one end, and unterminated at the other to connect to the solar controller. A ‘top tip’ is to obtain a single fully-terminated extension cable of twice the required length, and cut the cable half-way. For this project, a 25m extension cable was sourced, which provided 12.5m as a sufficient length for both positive and negative connections once cut in half. Thickness of the cable is an important consideration, so that the rating is sufficient for the power of the system and the loss due to the length of the connection. For this installation, a 4mm2 (12AWG) cable was selected, suitable for up to around 15m and 23A, meeting the needs.
  • Battery terminal leads
  • Midi and Blade Fuses and holders for fusing of the output from the battery supply (40A) and protecting the input to the charger controller (15A). The inverter came with a 35A mini-blade input fuse.
  • Lugs and wire for the Solar supply and DC power connections
  • Fixing screws for the solar panel, and cable clips
  • 12V Lamp with remote and motion sensor, providing a light powered by the solar energy for the indoor work area
  • AA / AAA / C / D / PP3 battery charger, for supplementary battery charging requirements, fed from the 12V output from the charge controller (avoiding unnecessary 240V conversion)

The resultant assembly captures energy from the sun via the solar panel, ‘conditioned’ by the controller (to avoid over-charging or issues with varying power) and stored in the battery. Naturally, this can take place throughout the day when the sun shines, without the need for a load to be present. Then when required, the load can be supplied from the stored energy.

The inverter is utilised to supply a replacement AC feed to the specialised Li-ion charger required for the load battery, which can therefore be used as an ‘off-grid’ power source for other uses in place of a regular ‘mains’ supply.

Charging additional Li-ion or Ni-Cad batteries for other equipment can be also be facilitated using the 12V output to supply an appropriate battery charger, and as well as powering 12V LED lights for illumination of the work space.

Hopefully this project is of interest and of use to anyone contemplating establishing a solar energy system, with the aim of harvesting energy from the sun, a ‘free’ resource available to us all!

@YellowsBestLtd our mission is in “Keeping Customers Operational”. We’re always keen to enhance our range of #business services, widen our #enterprise infrastructure support  and expand our mix of #sustainable solutions we offer for supply and maintenance of new and legacy #technologies and products for our customers.

Please help us understand what would be of interest to you by getting in touch to discuss your management services or solutions requirements, whether you’re implementing new systems or maintaining existing infrastructure to serve your operational business needs. We look forward to hearing from you.

Legacy Computing – Windows through time

DOS Beginnings – the early days of ‘personal computing’

The ‘Personal Computer’ (PC) launched by IBM in 1981 was a breakthrough that revolutionised the workplace, though the early ones were quite limited especially in terms of how to use them and what they displayed. Not only did they have no ‘touch screens’ for ‘swiping’ and ‘apps’ as we know them now, but there was no ‘graphical user interface’ either. Rather than a ‘desktop’ with icons and a mouse pointer, there was just a black screen with text and a flashing cursor.

DOSscreen
DOS

This was Microsoft DOS (Disk Operating System), which seemed to be the ‘proper’ way to use computers for at least a decade.

GEM - Atari ST
GEM – Atari ST

Indeed, some PC users were initially ‘suspicious’ of icons and windows which had appeared on the Apple Mac as well as other alternatives in use like GEM on the Atari ST.

People had become so used to typing commands, and knew all the ‘switches’ and other modifiers e.g. DIR /W to display a list of the files across the screen rather than in a column. And ‘WP’ was all you needed to get ‘Word Perfect’ to launch – the then favoured Word Processor, which gave rise to some still familiar short-cuts like ‘Control-C’ to copy.

Desktop computing takes-off and ‘Windows’ takes-over

Windows 3.1
Windows 3.1

Windows 3.1 showed PC users something different from around 1992, when 386 and 486 PCs powerful enough to run it well became available.

mouse tutorial
mouse tutorial

It even came with a tutorial to show users how to use a mouse!

Windows 3.1 floppy disks
Windows 3.1 floppy disks

No-one enjoyed having to install it using 7 floppy disks though.

And at first it seemed somewhat unnecessary to run existing applications.

Win95-DOSprompt
Windows 95 – DOS prompt

Indeed, there was a bit of an ‘outcry’  that Windows 95 and later variants didn’t first boot into DOS!

But then it was realised there were some key benefits. Now you could delete a whole directory in one go without having to clear out each ‘level’ – not always the safest feature! Email really became more useable when you didn’t have to log in specifically to check to see if you had messages; now it could be running all the time in its own window.

The rise of the Internet – and security issues

Win98Desktop
Windows 98 ‘desktop’

With each variant of ‘Windows’ came more sophistication, and suddenly a whole world of connected information could be accessed with Netscape and then Internet Explorer, which then meant Windows really became a ‘must have’.

Internet Explorer - WinXP
Internet Explorer – Windows XP

Certain difficulties were experienced getting old and new applications to behave themselves in the Windows environment; stability and also backwards compatibility started to become issues. Users now had to deal with ‘blue screen’ crashes of Windows, and then a variety of increasing security threats and viruses requiring ever-more enhanced anti-malware protection applications and mandatory backups.

The continuing need for ‘Legacy’ support

Although the majority of modern offices, educational establishments and homes now use the latest PC hardware as well as phone and tablet computing devices running the newest generation of operating software and applications, some industrial workplaces have professional implementations of systems that still make use of early computing platforms (ranging from desktop PCs to OSS servers), where the basic requirements are unchanged, and particularly in stand-alone use where security threats aren’t an issue. And some people still have old PC games to play!

Drive Setup
Drive Setup

It can however be quite a task to restore the operation of legacy systems, particularly if backups are missing or incomplete.

FDISK for partitioning
FDISK for partitioning

Associated issues include obtaining the appropriate hardware replacement parts such as disks (modern versions can be too high capacity to work well with old systems) requiring the right settings of cylinders, heads and sectors, and preparation using FDISK and FORMAT commands.

Floppy Disk
Floppy Disk

Software ‘patching’ of configurations may be needed, hunting out correct versions of driver files and specifying the right parameters. Creating a floppy disk with ‘boot’ files can also be a helpful tool!

Emulation and Virtualisation

There’s still a way today to run legacy software even without the old PC hardware, and that’s via the ‘joy’ of emulation and virtualisation. Even using an Apple Mac or Linux computer, it’s possible to run various flavours of Windows legacy software.

Particularly useful applications to enable this include:

DOSbox
DOSbox

DOSBox – a handy emulator tool which enables the running of old DOS based applications in an application window. Relatively straight-forward to setup, with the ability to ‘mount’ folders so that files can be imported.

VBoxWin95
VirtualBox-Windows95

VirtualBox – a fully featured virtualisation tool that allows the creation of ‘virtual machines’ into which can be installed a full operating system, such as Windows 3.1, Windows 95 or Windows XP. The tool also emulates CD and Floppy drives for  loading disk images and running legacy applications.

CPU fix for Win95
CPU fix for Win95

Takes a bit of work to set up, preparing a virtual ‘hard disk’, and then installing the operating system. There’s a ‘work-around’ needed to take account of modern processors being ‘too fast’ for the old operating software! Also, to set the display to the necessary resolution and get sound working, special video and audio drivers may need to be installed.

win95app
Win95app

 

Or you could try the Windows 95 ‘computer as an’ App created by Felix Rieseberg, which can be downloaded and installed on macOS, Windows and Linux!

 

@YellowsBestLtd we can assist with support services for both legacy and new software and hardware solutions, so please get in touch if you have any requirements you’d like to discuss;  we look forward to hearing from you.

Legacy mobile phones

The original ‘smartphone’ – Nokia Communicator

Remember way back in the late 90’s and early 2000s, when Nokia ruled the mobile phone market, they launched the Communicator series. Essentially it was the coming together of a mobile phone and a PDA, joined with a hinge that ‘opened up’ to reveal a full QWERTY keyboard and display screen. Always somewhat big and bulky, it initially was way ahead of anything else, offering phone, text, email and even fax communication.

LegacySmartPhone
Nokia E90 Communicator

The E90 was the last and most feature-packed variant, produced in 2008. More compact and powerful, it featured colour screens inside and out, video and photo cameras with flash, 3G telephony, Bluetooth and WiFi connectivity, together with internet browsing, GPS maps, photos, video and music players, radio, clock, calendar, contacts and a file manager, plus games and the ability to install apps like quick office for document creation and spreadsheeting. In short, it had everything we’ve come to expect in a ‘smartphone’, lacking one key ingredient – a ‘touch’ screen.

Nokia E90
Nokia E90 (closed)

10 years on, it’s a testament to Nokia’s impressive build quality that it looks almost as good as new and still works as well as it did, though of course without the ability to pinch, zoom and swipe, and no ‘app store’. The photo and video quality now looks very basic, as do the limited number of games and apps; but it is possible to load it up with an up-to-date Opera web-browser and Google maps. The music player still works well, using a headset or in speaker mode, as does email and texts – and naturally it can still make telephone calls!

Nokia E90 Communicator
The original ‘smartphone’ – Nokia Communicator

The Nokia phone business itself didn’t fair so well, being eclipsed by the competition and then sold off, as recently well documented in “The rise and Fall of Nokia” (shown previously on BBC4, now on youtube) by Arto Koskinen. However, more recently Nokia phones have made a bit of a comeback, relaunched by HMD Global. Though probably no hope of a new Communicator model?!

Mobile phones for all – Nokia 5110 ‘featurephone’

If you can remember the 20th Century and the dawn of the mobile phone, then the Nokia 5110 maybe familiar. Introduced in 1998, during the period of Nokia’s seemingly unstoppable rise, and helped them become the world’s number one mobile phone producer, which they remained for the next 14 years.

Nokia 5110
‘Featurephone’ for all – Nokia 5110

This was the breakthrough when phones ceased to be ‘bricks’ (though still including an external antenna) and became mass-market devices that everyone could consider carrying, even just as an ‘emergency’ phone. Text messaging was included, though many people at the time couldn’t see what the point of that was: “its easier to just ring someone, isn’t it?” How times have changed! Plus it had a clock, calculator, and a choice of ring tones including the now famous ‘Nokia tune’. And Nokia introduced the world to ‘snake’, heralding in the era of mobile gaming. No app store yet, and ‘touch screens’ and even colour displays were still to come. But you could now choose the colour of the product; they didn’t have to be just black anymore!

'snake' game
Nokia 5110 – ‘snake’ game

The phones themselves were of the solid long-lasting construction that characterised the products of that time from the Finnish manufacturer, perhaps due to the harsh winter environment of home they were built to survive, which is why 20 years later, it still works! Looking back, the surprising thing is that despite its rugged nature, a case was often used, and given the (now, seemingly) impressive talk and standby time, it was quite usual to have a spare battery too. Perhaps that was because they were still seen as an expensive luxury, and given that ‘normal’ desk phones didn’t run out of power, ‘early adopters’ wanted to make sure they could always make use of their investment.

Legacy 'Featurephone'
Nokia 5110 with accessories

Much has since changed in the world of mobiles, such that they’re not even used much as just ‘phones’, and Nokia’s phone business itself came and went, though now being revived by HMD Global. On the cusp of the launch of a new ‘flagship’ model, the Nokia 6.1 plus, it’s also interesting to see the ‘re-introduction’ of some ‘classic’ phones, the 8110 and 3310, harking back to those early beginnings.

@YellowsBestLtd we’re always keen to hear from #business customers looking to maintain and keep operational “legacy” products and #enterprise equipment, as well as newer #systems, helping to source and supply spares, repair and support services so that assets and #technologies continue to serve and perform. Please get in touch to discuss your Management Services and Solutions requirements; we look forward to hearing from you.

IET Achievement Awards 2017

Delighted to have attended @TheIET @IETawards #IETAchieve ceremony on Wednesday 15th Novemeber 2017. Well organised with a good turnout at the impressive @theBreweryVenue, it was a chance to network with a very diverse, international mix of engineering professionals, academics, students, armed forces representatives and volunteers.

This year’s event was hosted by the very capable @AngelaLamont (best known for the #BBC1 It’ll Never Work? programme) who ensured the smooth running of the event whilst always keeping the tone enjoyable and interesting.

Naturally there were many awards. Key highlights included the Faraday Medal presented to Dr Bjarne Stroustrup for his revolutionary and now far-reaching work on the creation of the C++ programming language, and an Honorary Fellowship awarded to @iamwill‏ for his contribution to the engineering profession – helping to raise the industry profile even further!

The ceremony was interspersed with impressive and thought-provoking presentations by the Present Around The world (#PATW) global finalists, the audience being able to vote on presentation skills and technical content of the speakers, and so special mention goes to Shubham Saraff of the South Asia Region who emerged the winner with his presentation on “Neurons that Shaped Us”.

Next years’ @IETawards Ceremony, celebrating and networking as the winners of the #IETAchieve prestigious Achievements Awards and Scholarships are announced, will be held on 14th November 2018 in London.

Keen to hear more from others who attended this year’s event, or anyone interested in attending next year, feel free to get in touch!

Read more at the IET Website

 

Trade Shows and Industry Events

Although often busy with immediate actions and therefore time can become short, throughout the year it’s good to make the effort to attend a number of the multitude of trade shows and industry events held throughout the year. They can be helpful for finding out about industry developments and trends, products and services and generally networking with Customers and Suppliers.

There follows a non-exhaustive list of a few held recently in the U.K. Where possible, dates for next year’s events are included which should help with next year’s diary planning. If you’re going we could meet up, and if you’re exhibiting then do advise so your stand can be visited! Always keen to find opportunities and occasions to discuss how services and solutions can be best aligned for mutual success.

 

@CloudExpoEurope – March 2017 at ExCel, London.

The cloud event for business. Includes #CloudSecurityExpo, #BigDataWorld, #SmartIOTLondon, #DataCentreWorld.

Next scheduled for 21st & 22nd March, 2018, ExCel, London.

 

@Railtex – May 2017 at the NEC, Birmingham.

The UK’s International Rail Industry Exhibition. Specialising in the latest equipment, systems & services.

It’s sister event @Infrarail will be held 1st-3rd May 2018 at ExCel, London.

 

@TechXLR8 – June 2017 at ExCel, London.

#TechXLR8 is a festival of technology, connecting industries and enabling new thinking. Part of London Tech Week #LTW 2017.

Next scheduled for 12th-14th June 2018 at ExCel, London.

 

@IPEXPO Europe – October 2017 at ExCel, London.

Europe’s number one enterprise event. Includes #CloudEurope, #CyberSecurityEurope, Networks & Infrastructure Europe, AI Analytics & IOT Europe, #DevopsEurope, Open Source Europe.

Next scheduled for 3rd-4th October 2018 at ExCel, London.

Also IP Expo Manchester is on 25th-25th April 2018 at Manchester Central.

 

@EngDesignShow – October 2017, Coventry.

The #EngineeringDesignShow is the UK’s must-attend event for engineering, and also includes #ElectronicsDesignShow and #EmbeddedDesignShow.

Next scheduled for 17th-18th October 2018 at Ricoh Arena, Coventry

 

@IETAwards Ceremony, London.

Celebrating and networking as the winners of the #IETAchieve prestigious Achievements Awards and Scholarships are announced.

Held on 15th November 2017, at The Brewery, London – Read the review!

Next years’ @IETawards Ceremony will be held on 14th November 2018 in London.

 

Please contact us to let us know your plans for the coming year ahead, and perhaps we’ll meet up!

Solved: UK Date Format Issue on a new Apple Mac with Microsoft Excel:mac 2008

An annoying issue (for UK users) is of the date format defaulting to US (MM:DD:YY) rather than UK (DD:MM:YY). This occurs when transferring to a new Apple Mac computer with a previously correctly working installation of Microsoft Excel:mac 2008 (from an older computer, but running the same version of OS X). In theory, there should be no change, but hidden somewhere in the setup of the new computer lurks something preventing use of the UK date format.

The problem shows itself when, in a new Excel worksheet, a date is entered, e.g. using the formula =TODAY() returns something like 11/22/16 (for 22nd November 2016) instead of 22/11/16. Worse, if an existing workbook is opened, which had previously  correctly UK-formatted dates, they are all changed to the US-variation. A particular ongoing problem is then generated when new dates are added to the sheet, as entering 1/12/16 is then taken as 12th January not 1st December 2016.

 It turns out that the issue manifests itself in any User account set up on the Mac computer EXCEPT the ‘Guest’ account, which mysteriously sets the date to the UK-format. Hence this provides the clue to solving the problem. After some searching and trial-and-error, I have identified that the issue relates to the absence of a key file: com.apple.HIToolbox.plist, which for some reason is not created when setting up a new User account (and may not be copied across if importing from another computer). Luckily this file is created when opening the Guest account, which can then be copied across to all required User accounts.

Here is a detailed summary of the procedure I eventually used to fix this date format issue:

  1. Create and open a Guest Account (if not already enabled, go to Users & Group Preferences)
  2. Go to the Library folder (it’s a hidden folder, so to find it, use Finder to go to the home folder, then select from the menu ‘Go:Go to Folder’ and type in ‘Library’)
  3. Go to the Preferences folder
  4. Make a local copy of the file: com.apple.HIToolbox.plist (e.g. onto an SD card, or external/cloud drive)
  5. Now open your desired User account
  6. Go to your Library folder (again it will be hidden, so find it as above)
  7. Go to the Preferences folder
  8. Copy the file: com.apple.HIToolbox.plist (from local storage) into this folder
  9. Quit Excel and then log out of your user account, and then log back in
  10. Next time Excel starts, UK date format will be correct!

Repair of Panasonic DMR-EZ25 DVD Recorder

Panasonic DMR-EZ25 DVD Recorder

The DMR-EZ25 is a reliable and highly-specificationed DVD Recorder, and like several models made by Panasonic somewhat special by it’s capability of being able to use DVD-RAM disks (as well as the more common DVD-R and DVD-RW) for maximum flexibility of recording and playback.

This model does however sometimes fail, displaying various fault codes, preventing use but at least giving an indication of the likely problem(s). Fortunately, it is then relatively straight-forward to disassemble using just a screwdriver, and thereby replace (or repair) the relevant component modules.

Here are the full disassembly and reassembly procedures I followed to restore my unit, which had been displaying the fault code ‘U81’, to full working order by replacing the main PCB board.

Disassembly procedure

1. Remove top panel, removing 3 screws (normal, non-washer type) at rear and two on side (big).

2. Remove front panel, which pulls off once lugs are pushed back, being careful not to break lugs.

3. Remove HDMI board, removing one screw (normal type) and then easing it out of the black connector on the main board and the ribbon cable out of its socket on the digital board.

4. Remove the SD card board, removing two washer-type screws and the ribbon cable out of its socket on the digital board.

5. Remove the rear panel, removing 6 normal screws and 2 smaller machine screws by the SCART sockets, then unplugging the FAN connector cable from the PSU board (alternatively, you can leave this connector in place and lift the panel away with the PCB board).

6. Remove the PSU board, removing the three washer-type screws and easing the black power rail connector from its socket on the main board.

7. There’s no hard disk in the EZ25 model, other products have an extra step.

8. Release the digital board from its mounting frame, there are three washer-type screws (and an empty socket where a fourth one is not present), easing it out of its black connector socket on the main board hidden underneath and then fold it over onto the disk unit keeping the ribbon cables attached

9. Remove the DV input board, removing one normal-type screw.

10. Remove the digital board metal support frame, removing four washer-type screws.

11. Remove the power button pcb, removing the washer-type screw and sliding it from the lugs being careful not to pull the ribbon cable.

12. Remove the main board, removing the four washer-type screws and the ‘hidden’ normal type screw on the front by the AV sockets.

13. The remaining disk drive unit removes from the base panel, removing two washer-type screws and lifting out with the digital board (which can be disconnected if necessary by careful detaching of the ribbon cables).

Re-assembly procedure

1. Insert main board into chassis (and also the disk drive if removed, with digital board, with two washer-type screws). There is a lug to align into a hole at the front left edge, one at the front right side and a bent lug at the rear to slide under. A ‘hidden’ (non-washer type) screw is located at the front by the phono sockets, and four more screws secure the main PCB to the chassis, all are ‘washer-type’.

2. One screw secures the power button PCB, aligned with two lugs.

3. Five screws secure the metal frame for the digital support board.

4. One (non-washer) type screw holds the DV input board which needs aligning with the holes in the main board at the front next to the phono sockets.

5. The digital board flips over with its ribbon cables in place, mounts onto the frame, tucking under the lugs, slotting the DV input board into place and pressing down onto the main (black) connector underneath.

6. Three screws secure the digital board in place (a potential fourth, in the far right corner (away from the front panel) is not present.

7. No hard disk is present in the DMR-EZ25 model (different models have this extra step).

8. The power PCB is placed into position, and it’s power rail connector presses together. Three screws secure it in place.

9. The rear panel clips securely in place. Six screws secure it, all ‘non-washer’ style and two ‘machine-type’ screws locate between the SCART sockets . The connector for the fan presses in place.

10. The SD board mounts at the front onto the digital board, with a lug and two ‘washer-style’ screws. It’s ribbon cable presses in place.

11. The HDMI board slots into place onto its black connector and its ribbon cable slots into place on the digital board. A screw on the rear panel secures it in place.

12. The front panel clips in place.

13. The top panel pushes on, slides in place and is secured by three non-washer type screws on the rear and two large flat screws on the sides.

Photos (including views of the component modules from inside the product) of this repair project are on our Facebook page.