Search results for query: *

I'm setting up a database to store laboratory analytical data: I have a 'sample' table with a sample_id, sample_date, sample_location (when was the sample take, and from where) I have a 'method' table with method_id, method_name and method_table_name (name of the analytical method and what...

I'm running PHP 5.2.9-2 $year1=$year2=$year3=2009; while ($year1 <= date('Y')){ $array1[$year1] = $year1 . "-" . ++$year1; $array2[$year2+0] = $year2 . "-" . ++$year2; $array3[$year3+1] = $year3 . "-" . ++$year3; } print_r($array1); print_r($array2); print_r($array3); Produces the...

I'm using a package called Image_Graph to produce some scatter plots on the fly in a website. The way this file works is, it accepts values as $_GET parameters and produces a png image. You call it with <img src="Image_Graph?title=foo&x0=1&y0=0...."> It works great, but I have so much data that...

I'm using a package called Image_Graph to produce some scatter plots on the fly. The way this file works is, it accepts values as $_GET parameters and produces a png image. You call it with <img src="Image_Graph?title=foo&x0=1&y0=0...."> It works great, but I have so much data that the URL is...

I have a worksheet with three columns; an x value, a y value and a confidence value. I'd love to be able to plot the x and y in a scatter plot, and use the confidence value somehow in the marker color. I could easily add 3 more columns for RGB values and manipulate them using the confidence if...

I have two tables: sample has three columns; s_id (int), s_start(timestamp), and s_end(timestamp) temp has two columns; t_timestamp (timestamp), and t_temp (real) I want to do the following: for each row in sample, return the s_id and the average temperature from temp between the times...

I have a spreadsheet which is being used as a logsheet in a manufacturing facilty. I have a webserver running a PosgreSQL database and PHP and a decent web site running with pages allowing entry of this data into the database through a form. I also have a method where I can cut the data from...

I have DSL service from Bellsouth. My service is a static IP, but that IP address is handed out by a DHCP server. The server hands out the following: WAN IP Address 65.5.248.x Gateway IP Address 68.152.239.152 Netmask: 255.255.0.0 Now my understanding of network protocols says this...

I'm trying to move some matlab code over to vba. One commonly used matlab function takes a vector of booleans and extracts only those elements from another vector where the boolean value at the same position is true. My problem is I keep getting #VALUE errors if I try to access the myBool...

If one has a range of cells containing: A 1 1 2 0 3 3 4 0 5 5 And you type in a cell: =A1:A4>0 you get a result of {True False True False True}. If, however, you have a VBA function: Public Function NewFunc(myBools As Range) NewFunc = myBools End Function and call it as...

I'd like to be able to determine the row number of the cell currently calling a specific funcion. Currently I call a public function as =Find_Last_Entry(Glucose_Consumed,ROW()) I'm hoping there's a way for the VB to determine the row on it's own. I can't use Activecell.Row because the cell...

I'd like to set a cell's value to "#N/A" if another cell is #N/A. I was hoping the following would work, but using the =isNA() funtion on the result cell yields a false. Unfortunately there is no Application.Worksheetfunction.NA() Here's what I was using: If...

I have a directory containing several Excel Workbooks. I'd like to create a new workbook which extracts data from the other sheets and displays the data on charts. My example: File Master.xls contaions cells A1 and B1 which contain the phrases "Book1" and "Book2" respectively. After a button...

I have a workbook with 12 identical worksheets. I’m wanting to do dynamic charting (Add a new row entry and the graph automagicaly updates) this requires replacing all range and cell references with defined names. I want to make it as straight-forward as I can. One can define a named range...

Hey there all. I'm setting up a database to organize a collection. I have a table of items, dates and prices. I would like to be able to display a chart with the price of each item over time. I was hoping I could either use a listbox to select which item to display, or use the record...

I'm creating a database to manage a collection. I have a table of items, dates and prices. I would like to use a form to view charts of the price fluctuations of each item over time. I was hoping I could use the record selector at the bottom of the form to select each graph. I used the chart...