E
Eeyore
Guest
Archimedes' Lever wrote:
Graham
Apologies, it was late.
Graham
M
Michael A. Terrell
Guest
Jim Thompson wrote:
Its predecessor was even worse. They only accepted copper braided RG
59 with a solid center conductor, and had no threads. You had to strip
the coax, insert it directly into the chassis mount connector, and crimp
the loose crimp ring over the jacket.
The nickel meet all FCC requirements, and used properly are as good,
or better than the gold plated connectors. Most of the gold plated I
tested were crap. The absolute worst was a batch of very high quality
unplated brass that corroded in months. If they had proper plating, we
would have switched all our CATV systems to that brand.
And CATV companies who have to meet FCC RF leakage regulations. They
used to use a double shielded copper braid, with a silver plated center
conductor for CATV head ends. The crimp type made air tight connection
to the body, and kept it. Unlike those soft plastic compression types
where the plastic slowly flows and reduces the pressure on the braid.
Those Ideal connectors don't impress me. We used to buy a better
grade of 'F' connector in multiples of 25,000. The Raychem wasn't bad,
but a lot of connectors failed our lab tests, and were blacklisted.
--
And another motherboard bites the dust!
Its predecessor was even worse. They only accepted copper braided RG
59 with a solid center conductor, and had no threads. You had to strip
the coax, insert it directly into the chassis mount connector, and crimp
the loose crimp ring over the jacket.
The nickel meet all FCC requirements, and used properly are as good,
or better than the gold plated connectors. Most of the gold plated I
tested were crap. The absolute worst was a batch of very high quality
unplated brass that corroded in months. If they had proper plating, we
would have switched all our CATV systems to that brand.
And CATV companies who have to meet FCC RF leakage regulations. They
used to use a double shielded copper braid, with a silver plated center
conductor for CATV head ends. The crimp type made air tight connection
to the body, and kept it. Unlike those soft plastic compression types
where the plastic slowly flows and reduces the pressure on the braid.
Those Ideal connectors don't impress me. We used to buy a better
grade of 'F' connector in multiples of 25,000. The Raychem wasn't bad,
but a lot of connectors failed our lab tests, and were blacklisted.
--
And another motherboard bites the dust!
M
Michael A. Terrell
Guest
Jim Thompson wrote:
I never had that problem with good quality hex crimp connectors, and
the right crimpers. Lots of cheap, imported crap out there.
--
And another motherboard bites the dust!
I never had that problem with good quality hex crimp connectors, and
the right crimpers. Lots of cheap, imported crap out there.
--
And another motherboard bites the dust!
E
Eeyore
Guest
bill.sloman@ieee.org wrote:
Graham
Certainly not Star Trek.
Graham
J
Joerg
Guest
Michael A. Terrell wrote:
[...]
off upon crimping. But they work since years, no corrosion and most of
all I could push them on, and that's all I really care about.
If they do corrode 40 years from now, oh well ...
[...]
--
Regards, Joerg
http://www.analogconsultants.com/
"gmail" domain blocked because of excessive spam.
Use another domain or send PM.
[...]
My gold plated ones probably fall into that category. The gold flaked
off upon crimping. But they work since years, no corrosion and most of
all I could push them on, and that's all I really care about.
If they do corrode 40 years from now, oh well ...
[...]
--
Regards, Joerg
http://www.analogconsultants.com/
"gmail" domain blocked because of excessive spam.
Use another domain or send PM.
R
RST Engineering (jw)
Guest
I saw several of your replies in abse, but don't understand what you are
trying to tell me. Can you explain in text please?
Jim
--
"It is the mark of an educated mind to be able to entertain a thought
without accepting it."
--Aristotle
trying to tell me. Can you explain in text please?
Jim
--
"It is the mark of an educated mind to be able to entertain a thought
without accepting it."
--Aristotle
J
Jon Kirwan
Guest
On Mon, 06 Apr 2009 12:52:54 -0700, John Larkin
<jjlarkin@highNOTlandTHIStechnologyPART.com> wrote:
Jon
<jjlarkin@highNOTlandTHIStechnologyPART.com> wrote:
I agree. And this is new information, how?
Jon
A
Archimedes' Lever
Guest
On Mon, 6 Apr 2009 13:07:30 -0700, "RST Engineering \(jw\)"
<jim@rstengineering.com> wrote:
Did you hit the shortcut key, and see that only the correctly marked
pages showed up in the print preview?
If so, then you see the sheet works as well as the macro. SO, if yours
does not (mine originally didn't), I concluded that it MUST be due to
cell formatting issues, as the macro works, and mine was fixed by hunting
down improperly formatted cells. Your formula returns a numeric zero
value, so the cell you are filling has to be filled with a numeric figure
as well as be formatted numeric. A numeric cell will hold an alpha
content, including a text based zero, which causes the failure.
My sheet skips any page with an N or a 0 in the F52 cell position. You
can also nest another IF statement in there and have it skip sheets that
have an empty cell value there as well. In fact, you can nest 7 levels
of IF statements in there and test for several values in any cell
position, so you have a lot of options.
The macro works. In print preview mode, you have to step through each
page. In the full print command mode, it should go straight to the
printer.
I don't know what I left out, but you didn't explain what you were
confused about either.
<jim@rstengineering.com> wrote:
Did you download the attached spreadsheets?
Did you hit the shortcut key, and see that only the correctly marked
pages showed up in the print preview?
If so, then you see the sheet works as well as the macro. SO, if yours
does not (mine originally didn't), I concluded that it MUST be due to
cell formatting issues, as the macro works, and mine was fixed by hunting
down improperly formatted cells. Your formula returns a numeric zero
value, so the cell you are filling has to be filled with a numeric figure
as well as be formatted numeric. A numeric cell will hold an alpha
content, including a text based zero, which causes the failure.
My sheet skips any page with an N or a 0 in the F52 cell position. You
can also nest another IF statement in there and have it skip sheets that
have an empty cell value there as well. In fact, you can nest 7 levels
of IF statements in there and test for several values in any cell
position, so you have a lot of options.
The macro works. In print preview mode, you have to step through each
page. In the full print command mode, it should go straight to the
printer.
I don't know what I left out, but you didn't explain what you were
confused about either.
M
Michael A. Terrell
Guest
Joerg wrote:
The push on connectors are 'G' connectors. Leave it to marketing
types to call anything that comes close 'F' connectors.
Some didn't last 40 hours.
--
And another motherboard bites the dust!
The push on connectors are 'G' connectors. Leave it to marketing
types to call anything that comes close 'F' connectors.
Some didn't last 40 hours.
--
And another motherboard bites the dust!
R
RST Engineering (jw)
Guest
I really appreciate your help, but I am firmly convinced that if every
engineer in the world were forced to teach a freshman circuit analysis class
for a couple of years that there would be far less confusion in the world.
You soon find out that a "simple base bias circuit" ain't so simple if you
haven't been doing it for a few dozen years.
Jim
--
"It is the mark of an educated mind to be able to entertain a thought
without accepting it."
--Aristotle
"Archimedes' Lever" <OneBigLever@InfiniteSeries.Org> wrote in message
news:usokt4524idpecbvevklln1lgip4o090pt@4ax.com...
comment on the difference between any of them.
and have it skip sheets that
character in a cell and if that character is there skipping the page in
print mode.
"magic" autoload feature I'm not familiar with? What is a "print command"
mode?
Jim
engineer in the world were forced to teach a freshman circuit analysis class
for a couple of years that there would be far less confusion in the world.
You soon find out that a "simple base bias circuit" ain't so simple if you
haven't been doing it for a few dozen years.
Jim
--
"It is the mark of an educated mind to be able to entertain a thought
without accepting it."
--Aristotle
"Archimedes' Lever" <OneBigLever@InfiniteSeries.Org> wrote in message
news:usokt4524idpecbvevklln1lgip4o090pt@4ax.com...
Yes I did. There were about five or six of them as I recall. THere was no
comment on the difference between any of them.
What's a shortcut key? What is a "correctly marked" page?
That's nice. What is the solution?
In where?
and have it skip sheets that
I understand nested IFs. What is the point? All I care about is putting a
character in a cell and if that character is there skipping the page in
print mode.
So do you have to run the macro every time you print, or is there some
"magic" autoload feature I'm not familiar with? What is a "print command"
mode?
All of the above {;-)I don't know what I left out, but you didn't explain what you were
confused about either.
Jim
J
Jim Thompson
Guest
On Tue, 7 Apr 2009 08:24:45 -0700, "RST Engineering \(jw\)"
<jim@rstengineering.com> wrote:
another makes it sink into your own skull.
To this day I can teach Calculus and Circuit Analysis, sans book, all
I need is an outline, so I don't forget a topic ;-)
...Jim Thompson
--
| James E.Thompson, P.E. | mens |
| Analog Innovations, Inc. | et |
| Analog/Mixed-Signal ASIC's and Discrete Systems | manus |
| Phoenix, Arizona 85048 Skype: Contacts Only | |
| Voice480)460-2350 Fax: Available upon request | Brass Rat |
| E-mail Icon at http://www.analog-innovations.com | 1962 |
I'll keep my guns, freedom, and money. You can keep the change.
<jim@rstengineering.com> wrote:
Teaching is the ultimate educator. Having to explain something to
another makes it sink into your own skull.
To this day I can teach Calculus and Circuit Analysis, sans book, all
I need is an outline, so I don't forget a topic ;-)
...Jim Thompson
--
| James E.Thompson, P.E. | mens |
| Analog Innovations, Inc. | et |
| Analog/Mixed-Signal ASIC's and Discrete Systems | manus |
| Phoenix, Arizona 85048 Skype: Contacts Only | |
| Voice
480)460-2350 Fax: Available upon request | Brass Rat || E-mail Icon at http://www.analog-innovations.com | 1962 |
I'll keep my guns, freedom, and money. You can keep the change.
R
RST Engineering (jw)
Guest
I really didn't know how to fly until I started teaching it. That's sort of
scary.
Jim
A
Archimedes' Lever
Guest
On Tue, 7 Apr 2009 08:24:45 -0700, "RST Engineering \(jw\)"
<jim@rstengineering.com> wrote:
do is remove the fucking sig flag.
The differences were easy to note. It jumped from 5 to 7 worksheets so
you could see that only the even numbered pages would print.
macro in order to make it 'run' the macro? So did I, and that key
combination is commented on the worksheet (the first worksheet) as an
instruction.
field YOU wanted to be referenced to is tested. "Correctly marked"
refers to pages that were marked with a zero or N in F52. They were not
supposed to print. They do not.
Did you not read any of my replies throughout the thread? It is cell
formatting, and cell filling. Your formula needs to fill f52 with a
numeric 0, so the cell must be numerically formatted. Such a cell will
accept text as well, but numerals are handled differently. Text cells
will handle numeric data, but it is handled differently.
The posts in abse were just the files. This thread here is where any
answers were given.
the location for other characters as well. That is why I mentioned it.
If you want managed print jobs, YOU have to include AND USE the macro
each time you want managed printing.
The macro uses "Print Preview" mode right now. To print, one line gets
commented out, and another gets un-commented. That switched the macro
from print preview to just "Print". When that call is invoked by the
macro, it prints the result. There is no stopping at each page.
works, or how the fact that it works would help you fix your sheet.
It is a simple matter of making sure that the cells that get examined
have the right cell formatting, so that the formula that performs the
test "sees" the right data type.
Otherwise the macro fails. Unless you had been reading all of my
replies to you and others, you would likely miss the things I did to make
your macro work.
<jim@rstengineering.com> wrote:
When you jack off with a top posted reply like this, the least you could
do is remove the fucking sig flag.
The differences were easy to note. It jumped from 5 to 7 worksheets so
you could see that only the even numbered pages would print.
You have already forgotten how you assigned a key combination to your
macro in order to make it 'run' the macro? So did I, and that key
combination is commented on the worksheet (the first worksheet) as an
instruction.
Some pages are marked as PRINT, and others as SKIP. In each case, the
field YOU wanted to be referenced to is tested. "Correctly marked"
refers to pages that were marked with a zero or N in F52. They were not
supposed to print. They do not.
Did you not read any of my replies throughout the thread? It is cell
formatting, and cell filling. Your formula needs to fill f52 with a
numeric 0, so the cell must be numerically formatted. Such a cell will
accept text as well, but numerals are handled differently. Text cells
will handle numeric data, but it is handled differently.
The posts in abse were just the files. This thread here is where any
answers were given.
In the macro formula, silly!
and your EXACT cell references. A nested IF would only allow checking
the location for other characters as well. That is why I mentioned it.
No, you and your idiot crew (based on your descriptions) does.
If you want managed print jobs, YOU have to include AND USE the macro
each time you want managed printing.
The macro uses "Print Preview" mode right now. To print, one line gets
commented out, and another gets un-commented. That switched the macro
from print preview to just "Print". When that call is invoked by the
macro, it prints the result. There is no stopping at each page.
I find it hard to imagine that you could not see how the test sheetI don't know what I left out, but you didn't explain what you were
confused about either.
All of the above {;-)
works, or how the fact that it works would help you fix your sheet.
It is a simple matter of making sure that the cells that get examined
have the right cell formatting, so that the formula that performs the
test "sees" the right data type.
Otherwise the macro fails. Unless you had been reading all of my
replies to you and others, you would likely miss the things I did to make
your macro work.
A
Archimedes' Lever
Guest
On Tue, 7 Apr 2009 10:03:51 -0700, "RST Engineering \(jw\)"
<jim@rstengineering.com> wrote:
<jim@rstengineering.com> wrote:
R
RST Engineering (jw)
Guest
OK, I got it all to work ... with one minor problem. In Excel when you
print, unless you check the "print the whole workbook" you have to print one
page at a time, move to the next page, print that page, and so on. The
macro simply sends the whole workbook whose pages have been "selected" to
the printer one sheet at a time.
To a real printer that's not a problem. However, when printing to a file
like a .pdf, you have to save one sheet at a time and then when all the
sheets are printed one pdf file at a time, you can combine them in a single
pdf. The saving one sheet at a time is nearly as time intensive as printing
the whole thing to a .pdf and then manually deleting the zero sum sheets.
Is there a nice way in the macro to tell Excel to print the selected sheets
as one file and not page at a time?
I am continuously amazed at how basic a student's mind is when it is so
obvious to me because I've done it a few thousand times.
I got it. That was the missing link.
Reading is one thing. COmprehending quite a different matter. Thanks for
your help.
Jim
A
Archimedes' Lever
Guest
On Tue, 7 Apr 2009 13:08:32 -0700, "RST Engineering \(jw\)"
<jim@rstengineering.com> wrote:
test to fill F52 based on whether the sheet has changed or whatever is
how that selection gets made. The macro merely tests the value of that
field, prints if true, and cycles through to the next sheet. You could
run the test first, and then run the print job based on the test.
Currently it: tests, prints, steps, repeats. You need it to: test, flag,
print.
You make NO selection on printing from ANY menu one would use in excel.
The MACRO selects it, remember? The macro also flags which sheets to
print based on the contents of the cell you fill. It merely does the
print function after testing each sheet. You need to find a way to
compile the print session into a single print job. You could 'print to
file' each page, then use a batch file to pipe it to the printer
directly, which would be a single print job from all observations.
In the macro, the current "print preview" mode my sheet is in will
ALWAYS step trough each sheet. With it set to print it out, they should
all fly without ANY user interaction. If your print dialog is coming up
at all when the macro is set to actual print mode, a different print
command is needed inside the macro. I will make a sheet that has
two buttons so you can choose preview or print. You can use those
buttons on your sheet. You paste the button as an image, and hyperlink
the image to a function. Then, it is a button you can use to call the
macro.
There is a way to modify the macro to highlight 'changed sheets' that
have specific data in F52, then run a standard print call which would
print those highlighted sheets all at once, instead of stepping through
each sheet, then printing it, it would step through each sheet,
highlighting it's tab, then calling the print job at the end.
You can also highlight ALL the worksheet tabs yourself using the shift
or alt keys and mouse cursor. All highlighted sheets will print. You do
not have to use the "print whole workbook" dialog at all.
<jim@rstengineering.com> wrote:
Yes, it does, and that is what you wanted when you made your post. Your
test to fill F52 based on whether the sheet has changed or whatever is
how that selection gets made. The macro merely tests the value of that
field, prints if true, and cycles through to the next sheet. You could
run the test first, and then run the print job based on the test.
Currently it: tests, prints, steps, repeats. You need it to: test, flag,
print.
You make NO selection on printing from ANY menu one would use in excel.
The MACRO selects it, remember? The macro also flags which sheets to
print based on the contents of the cell you fill. It merely does the
print function after testing each sheet. You need to find a way to
compile the print session into a single print job. You could 'print to
file' each page, then use a batch file to pipe it to the printer
directly, which would be a single print job from all observations.
In the macro, the current "print preview" mode my sheet is in will
ALWAYS step trough each sheet. With it set to print it out, they should
all fly without ANY user interaction. If your print dialog is coming up
at all when the macro is set to actual print mode, a different print
command is needed inside the macro. I will make a sheet that has
two buttons so you can choose preview or print. You can use those
buttons on your sheet. You paste the button as an image, and hyperlink
the image to a function. Then, it is a button you can use to call the
macro.
There is a way to modify the macro to highlight 'changed sheets' that
have specific data in F52, then run a standard print call which would
print those highlighted sheets all at once, instead of stepping through
each sheet, then printing it, it would step through each sheet,
highlighting it's tab, then calling the print job at the end.
You can also highlight ALL the worksheet tabs yourself using the shift
or alt keys and mouse cursor. All highlighted sheets will print. You do
not have to use the "print whole workbook" dialog at all.
R
RST Engineering (jw)
Guest
Not quite. The original macro was given to me in this thread when I made a
fairly detailed description of what I was trying to do.
Your
I understand that. I'm simply trying my level best to come up with a
solution to a problem ... namely to make a single pdf file from all the
sheets in the workbook that have a nonzero value in cell F52. So far I've
been able to format that cell as a number and the "print preview" routine
gives me those sheets and those sheets only. Now my task is to figure a way
to print only those sheets in a batch to a single pdf file.
I don't believe that I said that I did. I did comment that unless you hit
the "print the entire workbook" button in the standard Excel print menu that
you have to do the job one page at a time, which is a royal pain in the time
fanny.
That's one way to do it, but that entails the user (dummy, remember?) to
figure out how to "print to file" and then how to run a batch file. Somehow
I would think that all that could be done inside the macro, but I'm too
ignorant of VB to know how to do it.
Yes, I understand that, and that is how the macro prints also...sheet at a
time rather than selected sheets of the workbook in one swell foop. No
print dialog other than the pdf writer asking me for a new file name for
each sheet that it prints. No buttons are necssary; I'll presume that the
user is at least smart enough to remember that "CTRL-z" will get them the
workbook printed with selected sheets and the plain old print menu will give
them the whole book no matter what is in cell F52.
Can you elucidate that for me a bit? What might the mod look like?
I didn't know that. Evidently my knowledge of Excel is rudimentary at best.
I'll post the whole darned spreadsheet up on abse so that you can see what
I'm working with and the formulas that I'm using.
Jim
K
krw
Guest
On Tue, 07 Apr 2009 11:18:31 -0700, Archimedes' Lever
<OneBigLever@InfiniteSeries.Org> wrote:
<OneBigLever@InfiniteSeries.Org> wrote:
Wings either.
K
krw
Guest
On Tue, 07 Apr 2009 08:38:27 -0700, Jim Thompson
<To-Email-Use-The-Envelope-Icon@My-Web-Site.com> wrote:
once if I taught all the courses did I get the degree - MAIT) and
several at work, in the '80s. Putting together a course teaches a
lot. Standing up and teaching and (answering the questions) really
drives the subject home. After teaching for three hours I was pooped!
<To-Email-Use-The-Envelope-Icon@My-Web-Site.com> wrote:
I taught a couple of CS courses at the local college (asked the Dean
once if I taught all the courses did I get the degree - MAIT) and
several at work, in the '80s. Putting together a course teaches a
lot. Standing up and teaching and (answering the questions) really
drives the subject home. After teaching for three hours I was pooped!
R
RST Engineering (jw)
Guest
I'm teaching one theory and two tinbending classes next semester where the
three campuses are about 150 miles apart. One on Monday, one on Tuesday,
and one on Wednesday. I can do three hours of lecture without too much
problem, but the Monday class is half lecture, half lab and the other two
are all lab. Now LAB is what really poops you out.
Jim