Writing VBA Script



I am trying to write a script to help me determine the Mean Time Between
Repair for equipment. I played with it all day yesterday but was not able to
figure it out. Right now I have to enter the string manually. The formula I
am using is "=AVERAGE(C7-C6,C6-C5,C5-C4,C4-C3,C3-C2)" where C7 would be the
latest date to C2 the earliest date. As you can see this would become
cumbersome with numerous dates.
--
Jim
.



Relevant Pages

  • Writing a VBA program
    ... I am trying to write a script to help me determine the Mean Time Between ... Repair for equipment. ... cumbersome with numerous dates. ...
    (microsoft.public.excel.programming)
  • RE: Writing a VBA program
    ... but given that the mean is just the sum of all the ... Repair for equipment. ... cumbersome with numerous dates. ...
    (microsoft.public.excel.programming)
  • Re: Phone Line Interfacing - FCC Part-68
    ... it becomes cheaper than wholesale replacement and burying. ... Not when usable equipment can be salvaged and used for repairs at ... Have you ever run a component level repair department for a major ... cables. ...
    (sci.electronics.design)
  • Re: Military may face $100B in repairs
    ... The military is scrambling to re-equip because the Pentagon failed to plan for the long and expensive war in Iraq, ... Pentagon leaders realize they face a choice between a larger military and improved equipment, said Adm. Michael Mullen, chairman of the Joint Chiefs of Staff. ... Military operations have cost $572 billion since the Sept. 11, 2001, terrorist attacks, Pentagon records show. ... the Army has issued repair contracts worth more than $1 billion for armored Bradley Fighting Vehicles. ...
    (soc.retirement)
  • Re: newbie repair equipment advice!
    ... Of course I had no money at all and had to rely on improvised equipment. ... Now I've got a fairly good lab with decent equipment. ... However, when I attempt to repair a device, I have to rely on my soldering skills, experience, instinct and ability to read circuits or at least to guess important circuit functionality from the PCB layout. ... Currently I am reading through some books to learn this technology ...
    (sci.electronics.repair)