S
server
Guest
message unavailable
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
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.
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.
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?)
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 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...
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.
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.
I suppose I can just generate a README.TXT file off to the side to
document what the csv actually is.
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.
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.
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.
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
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 ?
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)
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
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
Another fake research paperOn 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
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
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.
I dunno\' ... the pictures and descriptions are exactly the same. ButThe price suggests the build quality fairly accurately, [...]
Yet, I expect very little to come of it. He\'s not so much Teflon as heNobody 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.
[...]
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
voltageower 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..
SSR data sheets don\'t have SOAR curves, so I\'ll have to blow some up.
How fast does it have to switch? relays?
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 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...
!