Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mkuethe

    Macro Needed to Manipulate Numbers

    Thanks for attempting to help, but I have it figured out... ="0"&LEFT("0"&TEXT(A1,0),8)&MID("0"&A1,11,2)&MID("0"&A1,9,2)&RIGHT("0"&TEXT(A1,0),2)&"00
  2. mkuethe

    Macro Needed to Manipulate Numbers

    I've been struggling with this for a while and desperately need someone's help. I need a macro that will take a 13 digit number, add a zero at the front, change the place of the 9th and 10th digit and then add two more zeros at the end. For instance: Take 08347004003486 in Column A and change...
  3. mkuethe

    Macro Needed to Manipulate Numbers

    I've been struggling with this for a while and desperately need someone's help. I need a macro that will take a 13 digit number, add a zero at the front, change the place of the 9th and 10th digit and then add two more zeros at the end. For instance: Take 08347004003486 in Column A and change...
  4. mkuethe

    Lookup formula??? in Excel

    I want to export a query from Access to Excel and then analyze the data. What I'm pulling into Excel is data with 31 columns. (30 are audit questions and the last is the name of the person being audited.) Row 1 is a header row, showing each question's description. (i.e. Greeting, time...
  5. mkuethe

    "If then Sum" Formula in Excel

    That worked! Thanks!
  6. mkuethe

    "If then Sum" Formula in Excel

    I'm struggling with an Excel spreadsheet that contains 91 rows. What I’m trying to do is: Sum all rows in Column G when Column B=.0001 and Column E=1 within the same row. In other words, only add cells in Column G if, within that same row, Column B=.0001 and E-1. Make sense? Can anyone...
  7. mkuethe

    IIf Then Statement for Check Box

    SELECT Tbl_Main.ContactID, Tbl_Main.[Consultant Name], Tbl_Main.[Company Name], Tbl_Main.[Date of Service], Tbl_Main.[Date Audit Completed], Tbl_Main.Auditor, Tbl_Main.CFMI1, Tbl_Main.CFMI2, Tbl_Main.CFMI3, Tbl_Main.CFMI4, Tbl_Main.CFMI5, Tbl_Main.CFMI6, Tbl_Main.CFMI7, Tbl_Main.CFMI8 FROM...
  8. mkuethe

    IIf Then Statement for Check Box

    Yes, that's what I need. Can you walk me through setting up the summary and the check box command?
  9. mkuethe

    IIf Then Statement for Check Box

    Yes, there is a table (tbl_score) that the question scoring combo boxes pull from. We want it scored per audit. We have auditors that review others' work and answer 8 questions (MI1, MI2, MI3, etc.) Based on the work, the questions are either "1" (Yes) if that indicator was met, "0" (No) if...
  10. mkuethe

    IIf Then Statement for Check Box

    I have a form that lists 8 audit questions that are scored 1, 0, -1 (Yes, No, N/A) using combo boxes. What I need is a query that will count the "1" scores and mark a check box as true if the result is 3 or greater - excluding the No's and N/A's. Can anyone assist???
  11. mkuethe

    Assigning scores in Excel

    Got it - It worked! Thanks so much!!!
  12. mkuethe

    Assigning scores in Excel

    Yes. I've tried formatting both as percentages, both as numbers with decimal places, nothing works. That's why I'm struggling so much. I can't figure out what I'm doing wrong.
  13. mkuethe

    Assigning scores in Excel

    I tried that, but obviously I'm doing something wrong. Here's my scoring scale: 100.00% 5 99.80% 5 99.79% 4 99.50% 4 99.49% 3 99.00% 3 98.99% 2 98.50% 2 98.49% 1 0.00% 1 Any percentage I'm putting in is returning a "#NA" with the exception of 100%, which is returning a "1". I've tried...
  14. mkuethe

    Assigning scores in Excel

    I'm creating an employee performance database and need to know how to assign a score dependent on a percentage. For instance, if an employee achieves between 99.8% and 100%, the score should be "5". If the employee achieves between 99.5% and 99.79%, the score should be "4" - and so forth. The...
  15. mkuethe

    IE 6.0 Stalling

    For the last couple of weeks, IE stalls everytime I go to a new web page. The page will load, but I have to wait approximately 20-30 seconds before I can click any links. This is getting extremely frustrating, since I'm working on a LAN and am use to almost instant page loading. Anyone have...
  16. mkuethe

    SUMIF Questions (I think!)

    I'm needing to design a report that will score employees on their performance. I've tried several different possibilities, but cannot get any of them to work. I'll explain what I'm trying to do below: There will be a total of 14 possible measures listed in 14 columns across the spreadsheet...
  17. mkuethe

    "Catching" Hours

    Is there any way to "catch" the hours in a cell and convert them to text in another cell. For instance - I have a cell with "172:10:20". The cell has been formatted to hhh:mm:ss, but still shows as "1/7/1900 4:10:20 AM" in the formula bar. How can I get an empty...
  18. mkuethe

    Excel Formatting & Formulas

    Two questions... 1.) What formula would I use if I'm given - start time of 9:30, finish time of 10:00 and 500 pieces printed - if I need to figure the time taken to print each piece (# of pieces/hour)? 2.) Is there a way to setup time cells so that I do not have to type the colon everytime...
  19. mkuethe

    Setting Control Limits in Excel

    Let me better clarify... Our main responsibility is to monitor scoring of contractual performance guarantees. Say, for instance, we are supposed to answer 95% of all calls made to our call center within 30 seconds. Based on our monthly scores for the last two years, we would like to set...
  20. mkuethe

    Setting Control Limits in Excel

    I have been asked to determine the upper and lower control limits for monthly data in a simple spreadsheet. The data consists of just one percentage amount per month for two years. Is there an easy way to do this?

Part and Inventory Search

Back
Top