![]() ![]() " I am going to work with this and try to set the oil change alarm to go off based on TachTime and Date. They can be kept or deleted as you see fit. Incidentally, B4 and C4 are not used in further calculations in this version. Using this might require a change in labeling of the "Warning" cells. The conditional format rules are the same as for H4 (above), but in this case the number represents Days rather than hours. The date + 365 formula will set a date a day earlier in leap years (which is likely insignificant).Īs in H4, this is intended to get a numerical result to allow the setting of two alarm levels-amber for 10 days or less away, Red for 0 days or past due. It's only benefit is to put the annual inspection on the same date in the next year for any year. More complicated than Jerry's formula, and probably overkill. The two conditional format rules below are used so that the alarm cell goes amber (shown) when the oil change is due in 10 hours or fewer, and goes red when the engine hours to the next change is zero or negative. I wanted a number here in order to have the possibility of a two-stage alarm. The result here is the number of engine hours until the next change is due. My number is different here, as I revised the sample data to supply a number that would trigger the conditional formattng rule in H4.ĭifferent in that I went directly to the data in column L rather than the copy in B4. We used the same formula, =MAX(B) for C4. I misinterpreted what was wanted in the "Last oil change' box (B4) and used the formula below, which returns the date of that change:Įngine hours at the last change makes more sense, of course, and Jerry's formula, =MAX(L) gives you that. These use the same formula as Jerry's column L example, with a minor revision:įor each formula, I've placed the comparison strings ("Oil Change" and "Annual Inspection") into one of the header cells for that column, then used a reference to that cell to pick it up. New Columns: L (Oil Change) and M (Annual Inspection) The dates are needed only for Oil Change and Annual Inspection rows in the current form, but later versions may require then for similar purposes. Notes and formulas below.Ĭhanges: Every maintenance item is individually dated in column A. Here's a screen shot of the main table with my changes. ![]() I figured out how to use the MATCH function to search in the "oil change" category (column B), but then I can't figure out how to search for the Max Tach: in (column C) The problem is if I use Max tach for the entire column I get the most recent maintenance tach time, not the most recent "oil change" tach time.Ĭan anyone guide me in a general direction, If I could only use the Maximum # that is revealed in the category row, that would solve my main problem. But as I enter new oil changes I have to continually change the reference cell. for instance in the oil category I have a max tach time of 3800 Oil changes are due every 50 hours so I made a conditional cell that turns red when the tach time of the most recent maintenance entry =3800+50. ![]() I want to use the conditional cell as an alarm. Now I have a problem In my category row I can choose "maximum" in the Tachometer (tach) column, but I cannot use the number that result as a paremeter for a conditional cell. time and a date, and future maintenance is based on hours and/or calender time. All log book entries are made with reference to a Tach. I'm Trying to make a maintenance log to track all maintenance on a light aircraft. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |