Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.


Skip to first unread message

Ophelia Quarry

Dec 3, 2023, 2:21:02 AM12/3/23
A duplicate device was detected. This error occurs when a bus driver incorrectly creates two identically named sub-processes (known as a bus driver error), or when a device with a serial number is discovered in a new location before it is removed from the old location.

Download Zip

Most Garmin devices will have a unique serial number listed on the back or bottom of the device. If your Garmin device is registered to your Garmin Connect account, you can also find its serial number using Garmin Connect web by following these steps:

When it comes to calculating dates in Excel, DATE is the most essential function to understand. As you probably know, Excel does not keep the year, month and day for a date, nor does it explicitly store weekday information in a cell. Instead, Microsoft Excel stores dates as serial numbers and this is the main source of confusion.

Not all Excel date functions can recognize dates entered as text values, therefore it's not recommended to supply dates directly in calculations. Instead, you should use the DATE function to get a serial number representing the date, the number that Excel understands and can operate on.

Excel interprets the year argument according to the date system set up on your computer. By default, Microsoft Excel for Windows uses the 1900 system where January 1, 1900 is represented by the serial number 1. For more details, please see Excel date format.

Tip. To avoid confusion, always supply four-digit years. For example, if you input "01" or "1" in the year argument, your DATE formula will return the year of 1901.MonthIf the month argument is greater than 12, Excel adds that number to the first month in the specified year. For example, DATE(2015, 15, 5) returns the serial number representing March 1, 2016 (January 5, 2015 plus 15 months).If the month argument is less than 1 (zero or negative value), Excel subtracts the magnitude of that number of months, plus 1, from the first month in the specified year. For example, DATE(2015, -5, 1) returns the serial number representing July 1, 2014 (January 1, 2015 minus 6 months).DayAs well as month, the day argument can be supplied as a positive and negative number, and Excel calculates its value based on the same principles as described above.

Instead of specifying the values representing the year, month and day directly in a formula, you can have some or all arguments driven by of other Excel date functions. For instance, combine the YEAR and TODAY to get a serial number for the first day of the current year.

As already mentioned, Microsoft Excel stores dates as serial numbers and operates on those numbers in formulas and calculations. That is why when you want to add or subtract some days to/from a given date, you need to convert that date to a serial number first by using the Excel DATE function. For example:

Hours: since 24 hours = 1 day, we can infer that 24 hours has a time serial number of 1, which can be formatted as time to display 24:00 or 12:00 AM or 0:00. Whereas 12 hours or the time 12:00 has a value of 0.50 because it is half of 24 hours or half of a day, and 1 hour is 0.41666' because it's 1/24 of a day.

Seconds: since a second is 1/60 of a minute, which is 1/60 of an hour, which is 1/24 of a day. We can also say one second is 1/86400 of a day or in time serial number form it's 0.0000115740740740741...

You can type in various configurations of a date and Excel will automatically recognise it as a date and upon pressing ENTER it will convert it to a date serial number and apply a date format on the cell.

Now that we understand that Excel stores dates and time as serial numbers, you'll see how logical it is to perform math operations on these values. We'll look at some simple examples here and tackle the more complex scenarios later when we look at Date and Time Functions.

The time being added is input as a time serial number. Notice there are no negative times in the table below. Remember we can't display negative times. Instead we need to use the math operator to tell Excel to subtract time. See examples below.

Note: Times that roll over to the next day result in a time-date serial number >= 1. Cell E28 actually contains a time-serial number of 1.08333', but since the cell is formatted to display time formatted as h:mm:ss, only the time portion is visible.

Notice the last result in the table below shows ######, this is because it results in a negative time and Excel can't display that, but notice it can return a negative time serial number. More on how to solve this later.

This is important because if you try to take 14 hours from 12 hours (without a date) you'll get the dreaded ###### display in the cell, because negative dates and times cannot be displayed. We'll cover workarounds for this later, but for now keep in mind that math on dates and time that result in negative date-time serial numbers cannot be formatted as a date.

In the 1904 date system dates are calculated using 1st January 1904 as the starting point. The difference between the two date systems is 1,462 days. This means that the serial number of a date in the 1900 date system is always 1,462 days greater than the serial number of the same date in the 1904 date system. 1,462 days is equal to four years and one day (including one leap day).

- Excel applies date number formats based on your system region settings. For example, my system is set to display dates in dd/mm/yyyy format, but if you're in the U.S. your system is likely to format them as mm/dd/yyyy. Excel will automatically convert the format of date serial numbers to suit your system settings as long as it's one of the default date formats and not a custom number format.

On this page we have listed the various models of Ford tractors produced between 1939 and 1964. We will show unique features and list serial numbers and other identifying marks. We will attempt to list some, but certainly not all, of the noticeable changes made to each of the models throughout the years. By documenting these changes and features it will hopefully aid in correctly identifying the tractors and be a help to restorers who want their tractors to be "as original".

The best way to identify a tractor is by the serial number. Serial numbers on the 9N-2N and 8N tractors are located on the left side of the engine block, just below the head and behind the oil filter.

The numbers are usually not stamped very deep (or very straight). Try different angles and light sources to make the number visible. There will always be either a star or a diamond at the beginning and at the end of the serial number. You will only see the diamonds on 8N tractors with a serial number after 8N 433578. All earlier 9N-2N-8N models have the stars. All models made after the 8N will have the diamond markers. The format for the serial number on the 9N-2N-8N tractors is *8N12345*. All serial numbers will begin with either 9N or 8N followed by the number.

There are no 2N serial numbers; all 2N tractors retained the 9N serial numbers. The exception to the 9N or 8N format is the 9NAN and 8NAN prefix which identifies a kerosene burning tractor. These are common in Europe, but extremely rare in the US. There is also the 9NBN prefix for industrial tractors and the BNO25 and BNO40 prefix used on the MotoTug tractors.

It's also not unheard of to find N tractors with an engine serial number that begins with A253-xx or a similar variant. These were stationary power unit engines or combine engines. Some will have "Ford Industrial Engine" tags attached. Since they were the same as the tractor engine, many have found their way into tractors as replacement engines over the years.

Note that the "font" used on the number stamps was a little unusual. The uppercase letter "I" was used as number "1", and a lower case letter "b" was used a the number "6". That same "b" was turned over to become the number "9". The NAA serial number was the last one to use the model prefix as part of the serial number. After the NAA tractor, the hundred series and up tractors have a model number stamped above a strictly numerical serial number. You will need both of those numbers to identify your tractor.

Some casting codes on 9N-2N-8N engine blocks, transmission housings, and rear axle housings can also help pinpoint a date of manufacture. A code such as G187 would mean the part was cast on or after July 18th, 1947. D252 would be April 25th, 1952. The hydraulic pump housing on the 8N is aluminum and has the actual casting date on it directly in front of the bottom drain plug. However, pumps have been changed over the years, so this date should only be considered to confirm other dating clues. Below are the serial number ranges and some of the features of the tractors in that range.

Visual differences on the right side of the engine from the early 9N to the later 9N and 2N tractors include the length of the carburetor mounting throat on the manifold. The early manifolds have a longer drop to the carburetor where the later models had a thicker intake chamber which made this distance appear much shorter. The early 9N (left) up to serial number 9N16953 had a much smaller diameter generator than the later models (right), and the later model used a spring tensioner to keep the belt tight. An oil line was added to the governor for better lubrication on later models. Also note the upper spindle steering arms. The early arms used only a wedge bolt to keep them in place where the later arms ('43) had a Woodruff key and a bolt across the split rear to keep things tight. They worked much better than the early ones.

The infamous 9N rear "smooth axle" (left) was replaced by a stronger 2 piece riveted axle hub around serial number 9N41500. The smooth axles are coveted by collectors today. A wider 10x28" rear tire and wheel was offered as an option to replace the standard 8x32" inch rear tires.

A safety interlock starter button was introduced at serial number 9N12500. The button was moved from the left side of the dash to its new spot just in front of the shift lever. The operator was now required to have the tractor transmission in neutral before the button could be depressed. The aluminum dash panel went through a couple more changes as the starter button was moved with the ignition key ending up on the lower left side and the red indicator light disappearing. At serial number 9N47508 the dipstick was moved from the upper left side of the transmission cover in front of the filler cap to the right rear side cover on the differential housing.
0 new messages