URGENT !! A nuclear plant near Minneapolis in th e U.S. state of Minnesota has leaked radioactive material fo r a second...

On 01/04/2023 17:37, John Larkin wrote:
On Sat, 1 Apr 2023 17:19:34 +0100, Clive Arthur
clive@nowaytoday.co.uk> wrote:

On 01/04/2023 17:10, John Larkin wrote:
I\'m writing a program to create a CSV file that lists possible
resistor matrix values. I might hand it off to other people to use. I
don\'t use spreadsheets so don\'t know much about them.

I can do lines with numbers and strings and commas, but I\'d like the
spreadsheets to start with introductory comments. So, how does one
format comments into a csv file?


If you mean comments in the sense that they\'re invisible to whatever
opens the .csv, then I don\'t think it\'s possible.

I assume the usual Microsoft thing, Excel or something, would be used.
I\'ve seen spreadsheets that start with a few introductory title lines.
And some that actually label the columns that follow.

Most csv files are just heaps of numbers with no context, no revision
control, no hint of author, date, or even what it is.

If you want to put some explanatory text info blurb on the front you can
just do it as is provided that there are no commas in the text. If there
are then enclose the thing in double quotes.

A leading single quote \' will act as a comment delimiter for the rest of
the line (but beware of commas).

Better control can be had by including all strings in double quotes \"
and escaping in any double quotes as \"\".

CSV might not be the most user friendly choice though these days. Tab
delimited is one of the Excel defaults and that is much more readable on
a dumb terminal. That said I more often see space delimited files.

Having text and column headings in quotes also makes the CSV/tabbed
files compatible with the likes of Gnu plot.

---sample of most common forms of text inclusion and mistakes ---

\' Full line comment, and contains escaped double quotes \"and works OK\"
\"Heading1\",\"heading2\",\"heading3\" \'
1.2 2.4 5678 or
1.2,2.4,5678,\"which would you prefer?\"
This is plain text on its own
\"This contains \"\"quoted\"\" text\"
This might not do what you expect, or then it might
--end--

Columns in tab delimited form rather than csv. I find it much easier for
browsing data files. Size is the same but readability on a dumb terminal
or in notepad or nano greatly enhanced.

One other useful trick is that in most cases ,, can be used as a
shorthand for 0, although the cell will be blank rather than 0.
(empty cells evaluate to numerical zero). It can be a huge saving in
image photon counting files where the majority of cells are zero.

--
Martin Brown
 
On 2023-04-02 19:53, Don Y wrote:
On 4/2/2023 5:09 AM, Carlos E.R. wrote:
On 2023-04-02 05:08, Don Y wrote:
On 4/1/2023 2:57 PM, Carlos E.R. wrote:
Spreadsheets are a wonderful invention when used properly, as many
other inventions. They go back to 1969.

The problem with spreadsheets is that most folks use them where
a database would be the more effective mapping.

I\'ve seen organizations use spreadsheets with scores of columns.

I attribute this to a fear of the unknown; they can relate to
a spreadsheet as \"just a big table\" -- yet the notion that
a \"database\" (\"relation\") is just a big table escapes them.

And, they seem to get some comfort from seeing *all* of the data.
(really?  would you be able to spot BAD data *if* you could see it?)

[Also, a spreadsheet has a lower cost of entry -- you can
just type until things appear to \"stick\" without having to
invest much in learning how to set up a schema.  OTOH, there
are a few visual DBs that can give the same sort of feel.]

If it doesn\'t fit on a single page (now and forever), a
spreadsheet may well be the wrong solution to your problem!
Esp if you want to query and analyze its content.

Well, you can feed spreadsheets from databases :-D

Yes -- and no.  Spreadsheets are *flat* \"databases\".  Many
schema aren\'t well suited to a flat form.

I used to track key parameters of my workstations in a
text table (which is effectively a spreadsheet).  I figured
I could manually enumerate the boards in each, type of
GPU, CPU, amount (and type) of RAM, MAC, assigned IP, etc.

This worked fine -- when I had 6 workstations.  \"Fits on a
single sheet of paper\".

But, recently decided I should be doing the same with all of
my machines.  *Doesn\'t* fit on a single sheet of paper!

All but the smallest machines have at least two physical CPUs.
So, two columns for that.  And, I\'ll need to add a column
to indicate the number of cores in each (assuming them
to be identical).

Similarly, all but the smallest have at least 4 disks -- and
two or more optical drives.  So, at least 6 columns for that.

You can figure out a way to do that without columns ;-)

....

Everybody knows how to do a spreadsheet, but not everybody knows how
to do a database.

Before there were spreadsheets, no one knew how to \"do\" them.
Visual tools are hardly more involved than those of a spreadsheet
(for flat relations).

You may not have database software. I think that M$ Office did not
always include it. And LO Base is not that intuitive.

Most have visual \"front ends\" that you can use -- making the
relations *look* like tables (spreadsheets).

And, it\'s commonplace to have a DBMS put constraints on data
in ways that spreadsheets can\'t/don\'t.  As well as having a wider
range of data types (how do you store a MAC in a spreadsheet?)

Infinite ways. As text, for example. As a huge number.


But, by far, the best pitch for a DB is that it encourages you
to use the data within.  E.g., I can now build bootptab, my
namedb files, etc. just by running queries on the tables that
I\'ve built.  And, do so while \"someone\" is simultaneously
accessing and updating that data.

--
Cheers, Carlos.
 
On Sun, 02 Apr 2023 16:26:53 GMT, Jan Panteltje <alien@comet.invalid
wrote:

Somehow every time I think about this
that thing I did see back in the fifties had a big tank with salt? water
and some metal plates put into it to control speed of things at some fair
comes to mind...
:)

PS
I remember somebody doing a light dimmer for the school band
by de-capping a fluorescent light tube, filling it with salty water IIRC,
and lowering a wire with a piece of iron in it
using it as high power variable resistor.
Worked very nicely.
So, no electronics, but then you could use AI controlling a motor...
:)
no end to computah power needed....
AI powered robot, can do the design too...
where will it go? .. After WW3 that is of course...
!
 
On 2023-04-01, Lamont Cranston <amdx62@gmail.com> wrote:
I have an Arduino PCB that has the usual tactile membrane switches with through hole solder on both sides of the pcb. I want to remove the switch with out damaging the pcb. I know it sounds easy but I can\'t heat and unsolder four
connections at the same time. I don\'t mind damaging the switch I\'m removing. I have an SMD hot air station, and could heat the pcb. Is the solder removable with reasonable hot air station temps? What temperature would you recommend? I don\'t want to over heat other pcb components.
I could also try heating the pcb and apply a solder iron to the joints and try to lift one side at a time.
I have a hand operated solder sucker, but don\'t expect that to remove enough solder to free the switch lead.
Just looking for the best procedure to preserve the board.

if your holes are large enough you could try desoldering tubes.
https://www.aliexpress.com/item/1005004200362252.html

they have a wall thickness of about 0.1mm so the leads need to be a
bit smaller than the hole.


The price suggests the build quality fairly accurately, you could
probably do better with a dispensing needle on a 10ml syringe body,
if you can find one the right size - needle needs to fit over the pin
and go through the hole.


--
Jasen.
🇺🇦 Слава Україні
 
On 01/04/2023 17:53, John Larkin wrote:
On Sat, 1 Apr 2023 09:40:37 -0700 (PDT), Tabby <tabbypurr@gmail.com
wrote:

On Saturday, 1 April 2023 at 17:38:04 UTC+1, John Larkin wrote:
On Sat, 1 Apr 2023 17:19:34 +0100, Clive Arthur
cl...@nowaytoday.co.uk> wrote:

On 01/04/2023 17:10, John Larkin wrote:
I\'m writing a program to create a CSV file that lists possible
resistor matrix values. I might hand it off to other people to use. I
don\'t use spreadsheets so don\'t know much about them.

I can do lines with numbers and strings and commas, but I\'d like the
spreadsheets to start with introductory comments. So, how does one
format comments into a csv file?


If you mean comments in the sense that they\'re invisible to whatever
opens the .csv, then I don\'t think it\'s possible.
I assume the usual Microsoft thing, Excel or something, would be used.
I\'ve seen spreadsheets that start with a few introductory title lines.
And some that actually label the columns that follow.

Most csv files are just heaps of numbers with no context, no revision
control, no hint of author, date, or even what it is.

What difficulty are you having? You can put anything into any cell, at least until you run into the many misinterpretations these programs make.

I guess I could stick some words into the normally numeric cells, but
I have seen spreadsheets with nice title lines.

The cells of a spreadsheet are not \"normally numeric\" they are capable
of taking on any value that the computer can represent.
I suppose I can just generate a README.TXT file off to the side to
document what the csv actually is.

A few lines of text at the top with no commas in will be fine.
Your problem arises when something else expects the first line of the
file to contains headings in some particular format (eg Gnu plot).

So, I can\'t understand why so many people use spreadsheets. They are
awful as controlled engineering documents. Apparently there is not
even a standard for including comment lines.

They are extremely powerful tools for mocking up test data and having a
quick look see at modest amounts of experimental data.

The best thing about Excel or any other spreadsheet or scratchpad for
testing algorithms is that mistakes made in a spreadsheet are completely
orthogonal to those made in a procedural programming language.

You also have the oddity of Excel computing in FP and rounding to
strictly 15 decimal digits for display. This can sometimes cause
annoyance if you are working to machine precision. I have a work around
found by trial and error when I noticed an unusual value one day...

An example to demonstrate this behaviour (staring in A1):

column A column B column C

=1-2^ROW() =1-A1 =(1-A1)

And drag them down to row 55

You will see that column B is rounded to 15 decimal digits but column C
is full machine precision 53 mantissa. This can be very useful. But it
is quite arcane and not so far as I know documented Excel behaviour.

But then MS the help system would define \"Help\" as
\"He\" the masculine pronoun
\"LP\" obsolete black vinyl music disk now making a comeback.

--
Martin Brown
 
On 4/3/2023 1:08 AM, Carlos E.R. wrote:
I used to track key parameters of my workstations in a
text table (which is effectively a spreadsheet).  I figured
I could manually enumerate the boards in each, type of
GPU, CPU, amount (and type) of RAM, MAC, assigned IP, etc.

This worked fine -- when I had 6 workstations.  \"Fits on a
single sheet of paper\".

But, recently decided I should be doing the same with all of
my machines.  *Doesn\'t* fit on a single sheet of paper!

All but the smallest machines have at least two physical CPUs.
So, two columns for that.  And, I\'ll need to add a column
to indicate the number of cores in each (assuming them
to be identical).

Similarly, all but the smallest have at least 4 disks -- and
two or more optical drives.  So, at least 6 columns for that.

You can figure out a way to do that without columns ;-)

Not in a spreadsheet. Unless you treat the spreadsheet as a text table
and all of the data as typeless.

In which case, why aren\'t you just using a word processor? And, living
with the inevitable mistakes that will creep into your data? E.g., l00
is not a number -- despite looking like one!

In a database (\"relation\") you can \"relate\" different tables to each other.
So, in addition to 1:1 relationships (implicit in a spreadsheet), you can
have 1:1, 1:n, n:m, n:1, etc. relationships, as dictated by the data.

Everybody knows how to do a spreadsheet, but not everybody knows how to do a
database.

Before there were spreadsheets, no one knew how to \"do\" them.
Visual tools are hardly more involved than those of a spreadsheet
(for flat relations).

You may not have database software. I think that M$ Office did not always
include it. And LO Base is not that intuitive.

Most have visual \"front ends\" that you can use -- making the
relations *look* like tables (spreadsheets).

And, it\'s commonplace to have a DBMS put constraints on data
in ways that spreadsheets can\'t/don\'t.  As well as having a wider
range of data types (how do you store a MAC in a spreadsheet?)

Infinite ways. As text, for example. As a huge number.

The reason you want \"typed\" fields is to reduce errors.
Is this a number: THIS
Is this a MAC: HeLlOboysandgirls
Is this a float: 123.456.78,,90

DBMSs present so many richer ways of presenting and preserving
data to make the DBAs job easier.

What do you do when there are two entries in a spreadsheet that
obviously refer to the same thing? E.g., a part number having
two different descriptions? In a DBMS, you can ensure that
all part numbers are unique (trying to add another record with
an existing part number throws an error). You can also encode
other criteria to safeguard the data going into the relation.
E.g., \"biological child\'s age must be less than age of parents\"
(duh!) or \"birthdate must be in the past\", etc.

Try some simple problems in a spreadsheet... like keeping track
of the songs in your music collection. Then, try to convince
yourself that your spreadsheet is better than just a textual table!

Or, document your family tree for a couple of generations.

But, by far, the best pitch for a DB is that it encourages you
to use the data within.  E.g., I can now build bootptab, my
namedb files, etc. just by running queries on the tables that
I\'ve built.  And, do so while \"someone\" is simultaneously
accessing and updating that data.
 
On 01/04/2023 15:00, Fred Bloggs wrote:
On Saturday, April 1, 2023 at 1:05:21 AM UTC-4, Jan Panteltje wrote:
Ultrasonic sounds from plants, plants speaking at 40 kHz to 80 kHz
https://www.sciencedaily.com/releases/2023/03/230330133551.htm

The plants are not speaking at all. Sounds caused by cavitation effects as internal water columns drain due to dehydration is not speaking.

They might just possibly be communicating with insects - saying words to
the effect of \"Go away - I\'m toxic\". But I don\'t see an obvious
mechanism for them to generate such ultrasonic clicks though.

Capillary effects in xylem are strong enough to support very tall
columns of water as tall trees demonstrate so well.

--
Martin Brown
 
On 2/04/2023 2:41 am, Lamont Cranston wrote:
I have an Arduino PCB that has the usual tactile membrane switches with through hole solder on both sides of the pcb. I want to remove the switch with out damaging the pcb. I know it sounds easy but I can\'t heat and unsolder four
connections at the same time. I don\'t mind damaging the switch I\'m removing. I have an SMD hot air station, and could heat the pcb. Is the solder removable with reasonable hot air station temps? What temperature would you recommend? I don\'t want to over heat other pcb components.
I could also try heating the pcb and apply a solder iron to the joints and try to lift one side at a time.
I have a hand operated solder sucker, but don\'t expect that to remove enough solder to free the switch lead.
Just looking for the best procedure to preserve the board.
Mikek

I have some wide tips for my Metcal e.g. SMTC-161 (though sometimes a
less wide one like SMTC-160 fits better). Those can melt all of the
joints on one side of a DIP package or two pins on a switch, and then I
can tilt it and get that side further from the board. Then I let it cool
before releasing the force, and melt the other side and tilt it the
other way, let it cool, and then go back and do the other side. By
rocking it back and forth I can get it out without damaging anything.

A good solder sucker might also work.

If there are internal ground planes without thermal reliefs then all
bets are off, and the big hot air gun is usually needed, sometimes in
addition to the metcal.
 
OP here, I\'m surprised this is getting so much attention. I felt a little silly even asking the question,
about desoldering a switch. The switches I removed came out very easy. Not what I expected! I did crank up
the temp on my soldering iron to 830* and just moved from pin to pin with a little prying force near each pin with
an Exacto blade, until I got enough room to insert my needle nose pliers and then used those to pry with.
After the switches were out I added solder and then heated the topside and sucked out the solder from the other side.
The holes were very clean after that, didn\'t have to do any further solder removal. This was my Arduino
and they are fairly inexpensive. Recently my son brought a pcb home from work that was some type of controller,
it had a bad membrane switch in the middle of the board, surrounded by parts, not any room to get a
good prying action, I didn\'t want to attempt removal on that board. It wasn\'t mine, it was expensive and
would stop work until they got a new one, if they could. We just added wires and outboarded a new switch.
There was plenty of room on the front panel for adding the outboarded switch.
Mikek
 
On 2023-03-31, Sid 03 <sidwelle@gmail.com> wrote:
On Friday, March 31, 2023 at 5:19:31 PM UTC-5, Ralph Mowery wrote:
In article <n5ee2i1sfuok1a8sh...@4ax.com>,
jla...@highlandSNIPMEtechnology.com says...

Why play chess or do crosswords when you can design electronics?

How \'bout this? People usually don\'t get paid for doing crosswords or playing chess. That makes it fun. People get paid tons and tons of money to design electronics so that makes it work.

Some of it is work. But designing is fun.



Where I worked about 3/4 of the time was fun. The other 1/4 of the time
was work because I did not enjoy that part. If I could have paid the
bills I would have done the 3/4 time for nothing. Is it work or fun for
the people doing sports ? Even the chess can be a job or for fun or
both. Golf is probably the best paying job for fun. Not much physical
abuse to the body compaired to other sports.

Yes, \"Yes wire sizes for amperage can vary all over the place.\" is exactly what I found.
I used the calculator that was linked and it shows that AWG 40 was suitable for 1 amp at 1 foot long ?
I thought the rule etched it stone was the #10 was used for 30 Amp, #12 for 20 Amps, and #14 for Amps, where does this standard come from ?

NFPA NEC

> And why can\'t I find a chart that follows the AWG down into the 2? AWG gauges ?

NEC doesn\'t allow LV on those sizes.

Years ago I had a shop class where the instructor stated that 18 AWG was good for 3 amps and another instructor stated that 18 AWG was good for 5 amps maximum.
I just thought it would be simple to find a chart that definitively shows the small AWG(s)

Figure out how much energy you can afford to lose in the wires and choose a
size that does better

--
Jasen.
🇺🇦 Слава Україні
 
On Sunday, April 2, 2023 at 7:14:17 PM UTC-4, a a wrote:
A series of storms and tornadoes in the U.S. over the weekend has killed at least 29 people. The cities of Wynne and Little Rock in the U.S. state of Arkansas were among the hardest hit areas. #tornadoes #disaster #Arkansas https://bit.ly/3K7UzLH

https://twitter.com/i/status/1642659374115028993

https://www.fema.gov/emergency-managers/risk-management/safe-rooms/protection

People need a room they can walk into like any other room in their house. Those underground bomb shelter type rooms requiring going outside and climbing, descending actually, a ladder don\'t cut it for ultra-short notice events or people with mobility issues. These are very expensive, on order of $1000/sf. Mainly walls have to hold up against being struck by objects travelling 300 MPH, and the substructure has to be anchored with 10s of thousands lbs of weight ( thick concrete slab w/strong anchoring )- tornadoes have no problem uprooting big trees means they have no problem making your safe room go airborne. It can be done, DIY actually.

https://www.forbes.com/sites/quora/2016/03/22/what-would-it-take-to-build-a-completely-tornado-proof-house/?sh=627b29ed27ca

You don\'t need to make the WHOLE house tornado proof to survive- cost and aesthetically prohibitive.
 
On Monday, April 3, 2023 at 6:32:52 AM UTC-4, Martin Brown wrote:
On 01/04/2023 15:00, Fred Bloggs wrote:
On Saturday, April 1, 2023 at 1:05:21 AM UTC-4, Jan Panteltje wrote:
Ultrasonic sounds from plants, plants speaking at 40 kHz to 80 kHz
https://www.sciencedaily.com/releases/2023/03/230330133551.htm

The plants are not speaking at all. Sounds caused by cavitation effects as internal water columns drain due to dehydration is not speaking.
They might just possibly be communicating with insects - saying words to
the effect of \"Go away - I\'m toxic\". But I don\'t see an obvious
mechanism for them to generate such ultrasonic clicks though.

Capillary effects in xylem are strong enough to support very tall
columns of water as tall trees demonstrate so well.

Pretty sure they were talking about the herbaceous forb variety, not ligneous.


--
Martin Brown
 
On Monday, 3 April 2023 at 15:40:53 UTC+2, Fred Bloggs wrote:
On Monday, April 3, 2023 at 6:32:52 AM UTC-4, Martin Brown wrote:
On 01/04/2023 15:00, Fred Bloggs wrote:
On Saturday, April 1, 2023 at 1:05:21 AM UTC-4, Jan Panteltje wrote:
Ultrasonic sounds from plants, plants speaking at 40 kHz to 80 kHz
https://www.sciencedaily.com/releases/2023/03/230330133551.htm

The plants are not speaking at all. Sounds caused by cavitation effects as internal water columns drain due to dehydration is not speaking.
They might just possibly be communicating with insects - saying words to
the effect of \"Go away - I\'m toxic\". But I don\'t see an obvious
mechanism for them to generate such ultrasonic clicks though.

Capillary effects in xylem are strong enough to support very tall
columns of water as tall trees demonstrate so well.
Pretty sure they were talking about the herbaceous forb variety, not ligneous.



--
Martin Brown
Another fake research paper
 
In article <u0ega9$6dl$1@gonzo.revmaps.no-ip.org>, usenet@revmaps.no-
ip.org says...
Years ago I had a shop class where the instructor stated that 18 AWG was good for 3 amps and another instructor stated that 18 AWG was good for 5 amps maximum.
I just thought it would be simple to find a chart that definitively shows the small AWG(s)

Figure out how much energy you can afford to lose in the wires and choose a
size that does better

There are 2 main things to look at for wire sizes. The amount of
voltage drop and the temperature rise.

Not lookimg at any codes , but an example. You could use # 16 wire for
say a 10 foot dropcord and only loose a couple of volts. Extend it out
to 100 or 200 feet and the same load would drop say 15 volts. So while
it would carry the curent the voltage drop would be excessive and you
would need to go up to # 12 or # 10.

For temperature rise it would depend on the insulation type and if it
was in open air or in a conduit with several similar wires or wound in a
transformer .
 
On 4/3/2023 4:07 AM, Jasen Betts wrote:
if your holes are large enough you could try desoldering tubes.
https://www.aliexpress.com/item/1005004200362252.html

they have a wall thickness of about 0.1mm so the leads need to be a
bit smaller than the hole.

Well, I\'ll be ... as they used to say. I\'ve never heard of them, but
they look like they could be very useful.

The price suggests the build quality fairly accurately, [...]
I dunno\' ... the pictures and descriptions are exactly the same. But
for a coupla\' bux it\'s worth the chance that the more expensive ones are
actually better.

Thanks for the tip.
 
On 4/2/2023 2:54 PM, Fred Bloggs wrote:
Nobody would care about this jackass paying off a bunch of sluts to keep quiet, which in itself is not a criminal act. Or maybe even if he mis-used his campaign financing to do it, which is a misdemeanor. But when he covered it up by filing fraudulent finance expenditure to the FEC ( I guess) then it becomes a felony. Also if he intentionally lies to criminal investigators, and it can be proven quite easily, those are yet more felonies. He\'s facing trial on 30 different felonies and misdemeanors in the indictment.
[...]
Yet, I expect very little to come of it. He\'s not so much Teflon as he
is slimy - very hard to grab & keep a hold of.
 
On Mon, 03 Apr 2023 05:43:58 GMT, Jan Panteltje <alien@comet.invalid>
wrote:

On a sunny day (Sun, 02 Apr 2023 10:08:11 -0700) it happened John Larkin
jlarkin@highlandSNIPMEtechnology.com> wrote in
fmcj2ipm5so0l2obinqami6lc38amc92ap@4ax.com>:

On Sun, 02 Apr 2023 16:26:53 GMT, Jan Panteltje <alien@comet.invalid
wrote:

On a sunny day (Sun, 02 Apr 2023 08:00:00 -0700) it happened John Larkin
jlarkin@highlandSNIPMEtechnology.com> wrote in
ak5j2i13tp7qtgf113cfor3oslpppbndv0@4ax.com>:

On Sun, 02 Apr 2023 14:32:40 GMT, Jan Panteltje <alien@comet.invalid
wrote:

On a sunny day (Sun, 2 Apr 2023 16:14:53 +0200) it happened \"Carlos E.R.\"
robin_listas@es.invalid> wrote in <t7fofjxe1d.ln2@Telcontar.valinor>:

On 2023-04-02 15:23, Jan Panteltje wrote:
On a sunny day (Sun, 2 Apr 2023 14:13:05 +0200) it happened \"Carlos E.R.\"
robin_listas@es.invalid> wrote in <h38ofjx1t.ln2@Telcontar.valinor>:

On 2023-04-02 07:50, Jan Panteltje wrote:
On a sunny day (Sat, 1 Apr 2023 19:55:36 -0700 (PDT)) it happened Simon S
Aysdie <gwhite@ti.com> wrote in
9a5cb22f-c985-45c7-914b-38adb0287aa4n@googlegroups.com>:

On Saturday, April 1, 2023 at 9:11:05 AM UTC-7, John Larkin wrote:
I\'m writing a program to create a CSV file that lists possible
resistor matrix values. I might hand it off to other people to use. I
don\'t use spreadsheets so don\'t know much about them.

I can do lines with numbers and strings and commas, but I\'d like the
spreadsheets to start with introductory comments. So, how does one
format comments into a csv file?

A CSV file isn\'t a spread spreadsheet. It is a text file. Put your introduc=
tory strings in separated by commas.
You can put something like a # to start a line/comment, if you want. Your i=
nterpreter needs to be written to understand it.

--------
Make a text file called text.csv with a text editor and then open it with e=
xcel.,,,\" \"
2A,,,2D
,,3C,\" \"
,4B,,\" \"
5A,,,5D
closing,,comment,\" \"
--------
Above, I am not sure if the\\t in between the \'\" will make it past gaggle gr=
oups. (I mean \"\\t\")

Hey, that TAB appears here as 8 spaces :)
Could be 4 spaces too, depends?
Just using spaces should be OK too I think..

I was wondering what happens if you use European notition for numbers..

300,2 for 300.2 for example ;-)

You can use semicolons as separators instead of commas ;-)

I did write some code to allow input like 1,456,789,911
in the frequency input fields of my spectrum analyzer...
https://panteltje.nl/pub/xpsa_fm_spectrum.gif

If he has numbers like that for that spreadsheet then he may encounter that,
csv format does not make a lot of sense for numbers.


It should work, setting the locale appropriately (USA). I just tried with:

cer@Telcontar:~> cat p.csv
1;2;3;1,456,789,911;\"coment\"
2;2;3;1,456,789,911;\"coment\"
3;2;3;1,456,789,911;\"coment\"
4;2;3;1,456,789,911;\"coment\"
5;2;3;1,456,789,911;\"coment\"
6;2;3;1,456,789,911;\"coment\"
7;2;3;1,456,789,911;\"coment\"
8;2;3;1,456,789,911;\"coment\"
cer@Telcontar:~> localc p.csv


And it worked. If I leave locale as Spain, it doesn\'t.

OK, nice.
Yes Spain / Europe will see 2 or more commas in a field as wrong.
And ,911 I deliberately used will alarm the NSA ;-)
Testing mike:
1,2,3,4,5,6,7,8,9,11




Hers\'s my file:

https://www.dropbox.com/s/y8pkfpmjhcs3aml/P955_m2.csv?dl=0

I have a matrix of resistors with 9 programmable SSRs shorting various
nodes. I want a range of resistances that users can select, 32
different values maybe, plus open, short, and ground fault.

Some resistances are redundant (or very close) but have different
voltage:power capability, so we\'d select the higher power choices. I
should add that to the math and then maybe sort by resistance to help
people select.

Interesting little problem. The design is pretty dull otherwise.

https://www.dropbox.com/s/qh6rxnhaujq8n29/M2.jpg?raw=1

Well, cannot get much info from that PCB ? Circuit?

resistors 1, 2, 4, 8, 16 etc?
9 bits, 512 values matches your list

The little bits (high values) would be lower power ones?

The software a lookup list of the customer selector knob to binary?


Here\'s my current thinking. I started with just a conductance DAC,
namely resisors R, 2R, 4R etc in parallel, each with an SSR to switch
them in and out.

https://www.dropbox.com/s/3jpo8n6s7wrhnsl/Matrix_m2.jpg?raw=1

It gets complicated for the high bits :)
The lower 3 bits OK.

This lets me put 5-watt resistors in series and parallel, which helps
with power dissipation. And adds \"short\" for free.

Interesting solution, really!

We\'d prowl the spreadsheet and pick an assortment of resistance values
that the customer can request. A lookup table would map them to relay
patterns.

Yes


Of course a customer can program some resistance and then apply some
outrageous voltage and blow things up. The \"short\" case needs
protection too. I\'m optimistic that if I digitize voltage and current,
an FPGA can shut things off before we fry resistors or SSRs. We\'ll
need an isolated 2-channel ADC per load.

Maybe a simple hardware comparator across that .1 Ohm series shunt?
Should be faster?
Same for input voltage...
Thermal protection too..

I can compute the power dissipation of each channel, based on the
programmed resistance and digitized voltage and current. Air flow is
left to right on the board, but it could fail too and the board would
cook. So we need a surface temperature sensor or two.

This goes in a chassis with up to 8 plugin cards and two big
controlled fans. My idea is for each board to present one bit to the
main controller, I\'M TOO HOT. If the controller sees any such bit from
any board, it nudges up fan speeds. If no bits, it nudges down towards
minimum. Maybe 2% fan speed per second?

SSR data sheets don\'t have SOAR curves, so I\'ll have to blow some up.

How fast does it have to switch? relays?

A user will send a SCPI command to select a resistance, which will set
up a solid-state-relay pattern. That won\'t happen often and needn\'t be
fast. The SSRs themselves operate in roughly a millisecond.


Somehow every time I think about this
that thing I did see back in the fifties had a big tank with salt? water
and some metal plates put into it to control speed of things at some fair
comes to mind...
:)
 
On Mon, 03 Apr 2023 08:14:32 GMT, Jan Panteltje <alien@comet.invalid>
wrote:

On Sun, 02 Apr 2023 16:26:53 GMT, Jan Panteltje <alien@comet.invalid
wrote:

Somehow every time I think about this
that thing I did see back in the fifties had a big tank with salt? water
and some metal plates put into it to control speed of things at some fair
comes to mind...
:)

PS
I remember somebody doing a light dimmer for the school band
by de-capping a fluorescent light tube, filling it with salty water IIRC,
and lowering a wire with a piece of iron in it
using it as high power variable resistor.
Worked very nicely.
So, no electronics, but then you could use AI controlling a motor...
:)
no end to computah power needed....
AI powered robot, can do the design too...
where will it go? .. After WW3 that is of course...
!

We once used a full-sized plastic garbage can, full of water, as a
dummy load, and we boiled it.
 

Welcome to EDABoard.com

Sponsor

Back
Top