How to Delete Empty Columns in Excel with all Empty / Blank Cell Values

On the net you will find lots of info on how to delete empty columns in excel, using ‘go to special’. These are useless if you have some columns which have ‘some blanks’ and are looking for columns which have ‘only blanks’, because the method will delete the entire column even if it contains one blank cell.

I prefer instead to use the COUNTBLANK formula. Simply go to the last row/column of the data, and use countblank to find how many cells are empty/blank. then combine it with an IF statement, so that if the number of blanks is greater than the total number of columns/rows, then mark ‘delete’, and if not leave blank.

After this you simply sort your data by the column/row where you did the formula, and delete the relevant columns/rows. (Remember, when trying to delete empty columns, you will need to sort the data by the row which contains the formula. You do this by opening the ‘sort’ box and then pressing ‘options’ button)

Formula:

IF(COUNTBLANK(R[-27110]C:R[-1]C)>27109,”delete”,””)

in the above example, 27109 was the number of rows of data in my data – yours will be a different number.

delete empty columns in excel

 

 

List of Car Names for making sentences, stories or word games

Buy a car concept on brown paper bag which businessman has on head on cityscape backgroundList of Car Names which you can use as words for making funny sentences, stories, trivia/quiz challenges and word games.

The following English words are also the names of cars:

Applause, Beetle, Bluebird, Boxer, Caddy, Carry, Cavalier, Cherry, City, Cobra, Commander, Compass, Crown, Cube, Daily, Defender, Discovery, Dispatch, Expert, Fox, Ghost, Golf, Idea, Insight, Iq, Juke, Legend, Liberty, Logo, Magnum, Master, Metro, Midget, Mini, Montreal, Note, Panda, Partner, Patriot, Phantom, Pick Up, Picnic, Polo, Pony, Rapid, Rascal, Relay, Scenic, Shuttle, Spider, Sprinter, Stream, Superb, Swift, Trafic, Transporter, Tribute, Up, Wind, Yeti

And below is the breakdown of what car’s these are:

Model Word Associated Make
COBRA AC
LEGEND ACURA
MONTREAL ALFA ROMEO
SPIDER ALFA ROMEO
DISPATCH CITROEN
RELAY CITROEN
APPLAUSE DAIHATSU
IDEA FIAT
PANDA FIAT
CITY HONDA
INSIGHT HONDA
LEGEND HONDA
LOGO HONDA
SHUTTLE HONDA
STREAM HONDA
PONY HYUNDAI
DAILY IVECO
COMMANDER JEEP
COMPASS JEEP
LIBERTY JEEP
PATRIOT JEEP
DEFENDER LAND ROVER
DISCOVERY LAND ROVER
TRIBUTE MAZDA
SPRINTER MERCEDES-BENZ
METRO MG
MIDGET MG
MINI MINI
BLUEBIRD NISSAN
CHERRY NISSAN
CUBE NISSAN
JUKE NISSAN
NOTE NISSAN
PICK UP NISSAN
BOXER PEUGEOT
EXPERT PEUGEOT
PARTNER PEUGEOT
MASTER RENAULT
SCENIC RENAULT
TRAFIC RENAULT
WIND RENAULT
GHOST ROLLS-ROYCE
PHANTOM ROLLS-ROYCE
RAPID SKODA
SUPERB SKODA
YETI SKODA
CARRY SUZUKI
SWIFT SUZUKI
CROWN TOYOTA
IQ TOYOTA
PICNIC TOYOTA
CAVALIER VAUXHALL
MAGNUM VAUXHALL
RASCAL VAUXHALL
BEETLE VOLKSWAGEN
CADDY VOLKSWAGEN
FOX VOLKSWAGEN
GOLF VOLKSWAGEN
POLO VOLKSWAGEN
TRANSPORTER VOLKSWAGEN
UP VOLKSWAGEN

Understanding Car Parts: Part 1 – Genuine, OE Quality, Aftermarket and OE Parts

Before we begin Part 1 of our series ‘Understanding Car Parts,’ there’s a few things we need to clarify about OE Parts:

  1. Car Manufacturers (e.g. Ford) don’t manufacturer car parts, they manufacturer cars. They mostly assemble car parts which are bought from Car Part Manufacturers (e.g. Bosch Car Parts).
  2. OE stands for “Orignal Equipment” – It refers to the ‘factory fitted part‘. OE and Genuine refer to the same thing.
  3. Car Part Manufacturers (e.g. Bosch) who supply parts directly to Car Manufacturers (e.g. Ford) are referred to as OEM (Original Equipment Manufacturer)

What are OE Parts?

An OE Car Part refers to any car part fitted to a vehicle from production/factory. It stands for Original Equipment and refers to any part which was originally fitted to the vehicle.

As previously stated, the OE part is the same as ‘factory fitted part’ or ‘genuine part’. It won’t usually be manufactured by the car manufacturer themselves, but by an Original Equipment Manufacturer (OEM) who are a manufacturer of original car parts; Bosch, Mahle, Delphi, TRW, Lucas, Valeo, Hella are all examples of OEM.

Since OE refers to original part it is often considered to be the best in terms of quality as one assumes the OE Part manufacturer must adhere to the original specification of the Vehicle Manufacturer.

Aftermarket Parts

Aftermarket Part refers to any part which is not OE; OE Parts are replicated/copied by lots of different companies. Another term for an aftermarket part is ‘Pattern Part.’

E.g. Honda Accord/Civic 2.2 Mass Air Flow Sensor. The OE (original) part is/was made by Hitachi. OE  (Honda) Part Number is 37980RMAE01. In this case the OEM is Hitachi.

But this part will be available on the aftermarket (i.e. from non-dealership parts shops) who will offer the same part by different aftermarket part manufacturers.

E.g. Delphi Part Number AF10180-12B1 is equivalent to the OE Part number 37980RMAE01.

It is normal to fit aftermarket parts to vehicles and all garages/mechanics will replace OE parts with aftermarket parts when they need replacing. Is this bad? Not at all –  as long as the garage/mechanics fits a reputable aftermarket brand (OE Quality – see later) you shouldn’t worry because the aftermarket part will function the same as the OE part. Note that in the above example, the OEM for that Honda car is Hitachi, but it is also offered by another OEM called Delphi, and although Delphi is not the OEM for that model Honda they are considered to be an OEM because Delphi are also a company who supply parts directly to vehicle manufacturers but for other car models.

OE PartsFinding which brand originally made the any one part on the car is not easy, and in most cases the only option is to look for the brand name on the part itself.

Difference between OE and OE Quality?

So we have disguished between OE and Aftermarket, but there is another confusing term called “OE Quality“. OE Quality refers to a quality assurance certification which is given to Aftermarket Manufacturers to say ‘this company produces parts which match or exceed the quality of the original.’ Note that “OE Quality” and “OE” don’t refer to the same thing. There is an European Regulation which states that when an OE Quality certified part is fitted to a vehicle it should not invalidate the car’s warranty.

Below is an example of an OE Quality Certification statement:

“Blue Print components are specified to perform to the same standards as original equipment and to meet or exceed the matching quality requirements as detailed in the Block Exemption Regulation EC No. 46/2010. According to this regulation, the correct installation of such parts will not invalidate the vehicle manufacturer’s warranty.”

Many car parts brands are accredited with OE-Quality Certification but there are still variations in quality between different brands. Deciding which parts are better quality will often come down to Brand Reputation.

Is the OE part always the best quality?

Mostly OE is best, but unless you happen to know who the OEM is, the OE Part will only be available from the car’s dealership and this means it will be much more expensive. Also, there are examples of when the OE Part is not so durable or has a design flaw; this can lead to the part becoming a ‘common failure’ or ‘common mot failure’ – in these cases other part manufacturers may decide to tweak/modify the original part so that it is stronger/more durable than the original to prevent further failure. Such examples are common in suspension parts like anti-roll bar links, stabiliser links and ball joints, where the aftermarket offer a heavy duty version of the original part.

Some aftermarket manufacturers like First Line or ADL Blueprint have a high reputation for producing excellent OE Quality parts and there will be odd examples where the aftermarket version of the part is better than the original.

Sometimes the original OE Part is redesigned midway through the vehicle’s production. Such events contribute to complications like ‘part choices’ or ‘part options’ where the same model/specification car uses a certain part like e.g. brake pads will fit only up to a specific chassis number, and  after this chassis number it needs a different OE Part.

So which parts should I buy?

There are a few things to consider:

Price.

Because we often don’t know which company made the original part, OE Parts are usually bought from a Dealership. Dealerships are expensive and you can Buy Cheaper Car Parts from a multitude of other motor factors and stores which sell Car Parts Online.

OE Quality is OK

Aftermarket/Pattern Parts produced by reputable brands, who have OE Quality Certification, are widely accepted and used by the industry when a OE/Genuine/Original Part needs replacing. OE Quality parts will not invalidate your vehicle’s warranty.

What Part is it?

The type of part required is often a factor to consider. For example, many experts will say that it’s always better to use OE or OEM parts when replacing Engine Management Parts, like Mass Air Flow Sensors, EGR Valves and Lambda Sensors. This is because there are many diagnostic stories (maybe myths?) of cases where the aftermarket/pattern part did not turn off the fault light, but the OE or OEM part did. Conversely, when buying consumable parts and regular service items like brake pads, filters, suspension parts etc it might not be so crucial to look at OE or OEM. For Clutch Kits we always advise you buy a reputable OEM brand because fitting a clutch is an art and not all mechanics will have success installing a non-OEM clutch; Luk Clutches are Clutch Specialists and widely considered to be the best clutch brand.

Final Verdict: Buying OEM Brand Parts is the best of both

At Doctor Car Parts we choose our brands carefully. On all our product pages there is information about the brand including whether it’s an OE Quality Brand or an OEM Brand. Whenever possible we would advise to choose OEM Brand because this gives proper OE Quality from a parts manufacturer who is reputable enough to supply to vehicle manufacturers direct. Many OEMs will source and buy parts from other OEMs meaning it will often be the OE Part in the box (i.e. it will be manufactured by the same company who supplied the factory fitted original part).

I think that leaves us with only one thing to say…..

OE! OE! OE! ….Oi Oi Oi !!!

Aftermarket Lambda Sensor is different to the original?

Today I received an interesting email from one of my engine management part suppliers, Cambiare. It was about buying lambda sensors and why aftermarket parts can sometimes physically look different to the original but still be the correct part.

Below is the  example they gave:

LAMBDA 1

Figure A shows lambda sensor-A which corresponds to two O.E. numbers JP-123 and JP-124. (original equipment number means the genuine/dealer’s number). Notice the corner cut-out of the plug.

Figure B shows lambda sensor-B LAMBDA 2which  corresponds to OE number JP-125. Here the cut-out on the plug is bottom left.

 

Figure C shoLAMBDA 3ws  lamba sensor-C. This is the aftermarket version of the two sensors above.

This sensor can be used to replace any of the 3 OE numbers, namely JP-123, JP-124 and JP-125.

This practice of designing a part to cover more applications is common with lambda/oxygen sensors, but the same might apply in other parts where two parts are essentially the same except for e.g. the plug.

Anyone in the motor trade will agree that when buying car parts there’s a higher-than-average chance that you’ve got the wrong part, so it’s easy to immediately jump to this conclusion but this article is one example where it might not be so straightforward.  Good luck !

 

 

How to change Vauxhall Corsa C Handbrake Cables

The smaller engine Corsa C’s all have brake drums on the back. The handbrake cable assembly on these is made up of 3 main cable sections and 2 small pieces which fit to the brake shoes. The sections are listed below:

  1. A short 33cm Front Section which connects to the handbrake lever
  2. A 105cm Middle Section goes from the handbrake lever towards the rear left (nearside) brake drum
  3. A shorter 83cm Middle Section, runs towards the right (offside) brake drum.
  4. Two short cable sections (only 22cm long) connect to the two main cables to each wheel’s brake shoes.

Both the middle cables are connected together by the equaliser, located above the rear axle cross member.  Either part of the cable assembly can be replaced independently of the others. The common replacement is the longest 105cm cable which runs from the front towards the left wheel.

The Long Middle 105cm Brake Cable – Replacement procedure

  • First, slacken the nuts which hold the exhaust shield in place underneath the car and you will then have access to the bottom part of the handbrake lever.
  • From inside the car, remove the handbrake cable adjuster nut.
  • Take off the left-hand rear brake drum
  • Carefully extract the upper and lower return springs, next remove the spring cup, spring and retainer pin and lastly remove the rear brake shoe. You can leave the front shoe and adjuster strut mechanism as they are, in position.
  • Release the handbrake cable from its retaining clip, which is located on the lower pivot point of the brake shoe, after removing the retaining clip you can withdraw the cable from the rear of the backplate.
  • Work along the length of the cable, releasing it from its retaining clips and associated guides. Remember to note how and where it was fixed (for when you are reinstalling the new cable).
  • Disconnect the front end of the cable from the rubber grommet which is around the equaliser link and remove the cable from underneath the car.
  • When you refit the new cable, connect the front end of the cable to the handbrake lever, and then hook the cable through the equaliser link.
  • Make sure the cable is securely held in position by the rubber grommet.

Facebook is hard to use

I’m not from an IT background, but over the years I’ve often needed to learn new softwares and websites for business. e.g. ebay, shopping carts, wordpress, linkedin etc and I like to think I’m quite fast as picking up these things. And then there’s Facebook. I used Facebook a few years back as I had a personal account and at that time I remember it being simple.

I’ve now had to go back to Facebook to promote my business and I am literally pulling my hair out – I’m finding Facebook’s site functionality and navigation to be very frustrating. Doing simple things like adding photos, which I would normally figure out in seconds, take me ages to figure out. Editting my business page and adding additional functionality like apps and feeds and proving very difficult.

My message to Mark Zuckerberg – make your site easier because right now it’s feels as ergonomic as gloves on feet.

Anyway, that’s my moan for the day. If you stumble across the Doctor Car Parts Facebook Page, bear with me while I struggle with it.

How to Fit a Pollen Cabin Filter to 3 Series E90 E91 E92 E93

Here is the simple procedure to follow in order to replace the Bmw 3-Series E90 Pollen filter (also called Cabin Filter) on the BMW E90 series (2005 onward).

All Pollen Filters for 3 Series 2005 onwards model (Model Code E90,E91,E92,E93) are the same. It is advisable to replace the pollen filter with one which is ‘carbon coated’ as provide better filtration.

First, simply open the bonnet and locate the air filter housing, which is found towards the back of the engine compartment, just below and in front of the windscreen.

It is a long rectangular shaped black plastic housing approximately 832mm x 20mm x 132mm. There are six T20 torque screws that fasten the top of the plastic housing to its mounting.

You will need to loosen these screws first, with a suitable torque driver, in order to remove the housing from the mounting and gain access to replace the cabin air filter.

Two  of the T20 torque screws are found on the front edge of the casing, one at either rear corner of the housing and two more on the back edge of the housing – after removing all six screws you can pull the housing up and out from its resting position and remove it from the vehicle.

You will now see the light coloured filter inside the casing and this can be released by undoing the three latches located along the edge of the casing.

Inspect the casing for any sign of damage such as cracks or splits and clean the inside of the casing if necessary. Unpack and insert the new filter – there are three hooks on the lower edge to locate the new cabin air filter and then snap the three latches into position to lock it into place inside the housing.

Once the new cabin air filter is in place you can align the casing with the mounting and after making sure that it is positioned well – lock it in place with the six T20 torque screws to secure it to the mounting again.

Bmw 5 Series E34 Steering Idler Arm or Pitman Arm

Today a customer asked for an steering idler arm for an old e34. they are available from us. delphi part number is tl530 / bmw 32211136450

It fits like to one side of the car only.

PITMAN ARMturns out this part has quite a few names:

steering idler arm, pitman arm, steering lever…so when you’re searching you might want to try all of them for the best prices!