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. Ca1icoJack

    Analysis of series on a graph

    I'll try using your solution from earlier then. If it were possible to upload the full set of data I could show you, since I can't I'll continue on my own. Thank you for the help though
  2. Ca1icoJack

    Analysis of series on a graph

    I was just providing a random set of data with which you could look at the tolerance bands. I didn't check whether the set was a pass or fail. This is a set which fails those bands. And yes, I do want help, I'm just finding it difficult to explain exactly what I want. y x 0.0131 0.0000 0.0160...
  3. Ca1icoJack

    Analysis of series on a graph

    What do you mean by value pair? As I said, none of the x values are the same so I can't simply compare values. I'm not sure whether the data I provided you with would pass or fail.
  4. Ca1icoJack

    Analysis of series on a graph

    Here's a full set of tolerances, we only use the tolerances from x = ~0 to x = ~1 so some at the bottom are unused. Columns in pairs: Nominal, Lower, Upper, Actual. Nominal and Actual are y then x Lower and upper are x then y Nominal Lower Tolerance Upper Tolerance Actual y x x y x y y x...
  5. Ca1icoJack

    Analysis of series on a graph

    Basically the upper tolerance has a greater number of data points than the lower or actual measured data. By that I mean that if I am analysing 100 data series I'd like to know how many go outside of the upper tolerance and how many outside of the lower tolerance. So if you drew two curves on a...
  6. Ca1icoJack

    Analysis of series on a graph

    Is it possible for excel to calculate the number of series which at some point go out of tolerance? e.g. If a series 1 is the lower tolerance and series 2 is the upper tolerance can I check to see whether series 3 lies within this range or not? The number of values used for the upper...
  7. Ca1icoJack

    Coloured Cells

    Thanks for the help. ScreenUpdating has always been off. I'm trying it out with your code now.
  8. Ca1icoJack

    Coloured Cells

    There are ~30 different colours the code goes through to test for. I don't actually use Type in the code... I cut down all of the detail just to show the loop as the rest is just a repetition of the two if statements and a lot of calculations which cannot be changed. If you want to see the...
  9. Ca1icoJack

    Coloured Cells

    I've missed out all of the detal in the code except for the way the loop works, any idea on how to make this faster? (I never know where the coloured cells will begin or end) Thanks for your help ____________________________________________________________ For R = 1 To LastRow(0)...
  10. Ca1icoJack

    Coloured Cells

    I have a loop which looks down thousands of lines and across 20 cells on each row. The code takes a huge amount of time to run, since it is looped on a lot of files. Is there a way to make the code only look at a line if the line contains colour since many are blank? Thank you
  11. Ca1icoJack

    SQL Data Manipulation and outputs

    I'll upload the files at some point later today if possible. Is it possible to edit posts btw?
  12. Ca1icoJack

    SQL Data Manipulation and outputs

    Okay, thanks for the help. I'm not able to upload anything. Uploading files is blocked here. However, I'll list what I can. If anything doesn't make sense I'll attempt to explain what is needed. The column headings I need are: Measured_Date Measured_Time Serial_No Feature Nominal Actual...
  13. Ca1icoJack

    SQL Data Manipulation and outputs

    Sorry, forgot to mention we runs on Windows 2000.
  14. Ca1icoJack

    SQL Data Manipulation and outputs

    I'm completely new to SQL and would like to know exactly what I can do with it. I want to be able to extract a load of data for a feature, calculate some new values, order the data by date and take the most recent 30 values. Then repeat this for each feature. An example of the value I'd want...
  15. Ca1icoJack

    Graph formatting changing

    Immediately before the line of code to print. The formats are all correctly displayed on the screen, if I print manually they are also correct. However, if the code prints automatically they are all reset.
  16. Ca1icoJack

    Graph formatting changing

    Using a macro I have imported some data and created 8 graphs on a sheet which is then printed. The printout reverts all character formatting to the default sizes. How can I prevent it from doing this so the formatting I specify in the code is retained? I've done this before in other macros...
  17. Ca1icoJack

    Code within a sheet

    Sorry, nevermind, it seems to be working now that I've re-run it. I don't know why since I didn't change anything.
  18. Ca1icoJack

    Code within a sheet

    Thanks. This works fine for the data copying bit, but doesn't work when I'm trying to select a range for a graph. Any ideas?
  19. Ca1icoJack

    Code within a sheet

    I have been trying to create some code behind a command button in a worksheet. When it is clicked it links to another sheet and collects data which it then uses to create a graph. I always get an error: ___________________________________________ Runtime Error '1004': Application-Defined or...
  20. Ca1icoJack

    Process Capability

    Okay... And if I were to use your method instead what formulae would I used in place of SpreadsheetFunction for each? Thanks

Part and Inventory Search

Back
Top