Jump to content

jbrohan

Members
  • Posts

    85
  • Joined

  • Last visited

Everything posted by jbrohan

  1. I need to click on a dialog put up by Excel when I re-write a spreadsheet file with the values of some cells changed. The approach I'm taking is to place the mouse at the
  2. The original routine had the sign wrong on the Time Zone. Here is the updated UTC Time Zone VI and the ExcelDateTime.vi This converts dates from Excel numeric value (Re Format a column of dates in a spreadsheet to Numeric and these numbers are the excel dates I'm starting with). The conversion is to LabVIEW Time Stamp. There is a reverse function included in the same VI. It is possible to determine your time zone from the G function Seconds to Date/Time. 1)feed in Zero this will give 1904-01-00 0:00:00 at Greenwich, but if you are in Montreal it gives 1903-12-31 20:00:00. (In the summer time) That's -4 hours offset. 2)Leave the Seconds input unconnected (Now) and examine the output Time Structure for DST. Add another hour for the Daylight Savings Time and you arrive at -5 which is out time zone. 3)This routine should work all over the world (Maybe even in Newfoundland which is 30 minutes ahead of Montreal.) Download File:post-230-1122943401.zip
  3. Here is a Pure G (LV6.1) solution to the question
  4. I've never worked with steam, but I expect it's straightforward. There are very good relay modules in Fieldpoint with NO and NC connections for 8 relays. You can probably wire these up to control the valves with 24V DC or 120VAC or whatever. In the program keep checking the temperature and when it goes < setpoint turn on the steam valve. When it is > setpoint turn off the steam. The temperature difference between < and > is called
  5. Routine to convert Excel dates to LabVIEW Excel has the alluring and simplistic notion that time can be expressed as a fractional number of days since 1900 01 01. LabView starts 4 years later. So the number of days between these two is 365*4. 1900 was not a leap year. Unfortunately this is not correct and we need to subtract 2 more days to get it right. Happy to get the truth of this! The time is represented as a decimal fraction in Excel eg 0.5 = 12:00 midday. There are 86400 s in a day so if you multiply this fractional part by this number you'll get the number of seconds. Well nearly! What LabVIEW gives is the time where I am (my computer thinks it is located) when it is x number of seconds past 1904/1/1 (midnight) in Greenwich England. So we need to add the 5 hours time zone difference to get Montreal time. But it's sometimes summer time so we need to subtract one hour if it is. The routine takes the simplistic notion that if a time turns out (according to
  6. There is a simple way using the select function. It takes a minute or two to test that it's correct with values just below, equal and just above each of the steps. I'm including a jpg of the diagram! Yours Sincerely John Just thought about this for a minute... It's a) upside down and b) the 8000 one has the wrong comparator... a not uncommon event in my programming!
  7. Hello I have one that has been working for a while. It converts only one and two letter columns to numeric. If you generalize it and test it, I'll be glad to see it back! Download File:post-230-1110321244.vi
  8. One path forward might be that after a "Duplicate Case" operation the text cursor is on the case selector and has focus; Generating simulated keystrokes should make a new case! This research fascinates me. I have a method of storing the Menu tags and need a method to verify that corresponding cases are missing or misspelled.
  9. I wanted to read only the string text and I could not get to in in LV 7.0. Sometimes if you have duplicate text items the tag gets a "_nnn" appended to it. Yours Sincerely John
  10. There is a very simple solution to this whole problem of Easter Eggs. Put it in the Spec. The one line "At Halloween the cursor is a pumpkin" will probably provoke nothing more than a shrug. Some of us feel that customers don't read specifications very well anyway.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.