Reply by John Larkin February 14, 20192019-02-14
On Thu, 14 Feb 2019 11:26:56 +0200, Tauno Voipio
<tauno.voipio@notused.fi.invalid> wrote:

>On 13.2.19 22:10, John Larkin wrote: > >> It takes a little while to get good with LT Spice, but it's a fabulous >> tool. I even use it for simple stuff like voltage dividers and time >> constants. >> >> I "design by fiddling" a lot too, using instinct and Spice. When you >> have an idea at 3AM, Spice is an ideal way to try/remember it. >> >> The HELP is mediocre, so if you have any other questions, post them >> here. I still do. > > >W&#2013266172;rth Elektronik has published a book: >Gilles Brocard, The LTSpice IV Simulator, 744 pages, >ISBN 978-3-89929-258-9
I hope it's not as dreadful as some of the other stuff Wurth has published. The Inductor Trilogy was awful. -- John Larkin Highland Technology, Inc lunatic fringe electronics
Reply by Tauno Voipio February 14, 20192019-02-14
On 14.2.19 13:35, blocher@columbus.rr.com wrote:
> On Thursday, February 14, 2019 at 4:27:02 AM UTC-5, Tauno Voipio wrote: >> On 13.2.19 22:10, John Larkin wrote: >> >>> It takes a little while to get good with LT Spice, but it's a fabulous >>> tool. I even use it for simple stuff like voltage dividers and time >>> constants. >>> >>> I "design by fiddling" a lot too, using instinct and Spice. When you >>> have an idea at 3AM, Spice is an ideal way to try/remember it. >>> >>> The HELP is mediocre, so if you have any other questions, post them >>> here. I still do. >> >> >> W&uuml;rth Elektronik has published a book: >> Gilles Brocard, The LTSpice IV Simulator, 744 pages, >> ISBN 978-3-89929-258-9 >> >> -- >> -TV > > As an aside, I have that book. It is the heaviest book I have ever had. I got a free one at a seminar. It is really heavy.
Win Hill's The Art of Electronics, 3rd ed is still sturdier. The LTSpice book is 1.880 kg, the AOE is 2.326 kg, and 2014 ARRL handbook is 2.500 kg. -- -TV
Reply by February 14, 20192019-02-14
On Thursday, February 14, 2019 at 4:27:02 AM UTC-5, Tauno Voipio wrote:
> On 13.2.19 22:10, John Larkin wrote: > > > It takes a little while to get good with LT Spice, but it's a fabulous > > tool. I even use it for simple stuff like voltage dividers and time > > constants. > > > > I "design by fiddling" a lot too, using instinct and Spice. When you > > have an idea at 3AM, Spice is an ideal way to try/remember it. > > > > The HELP is mediocre, so if you have any other questions, post them > > here. I still do. > > > W&uuml;rth Elektronik has published a book: > Gilles Brocard, The LTSpice IV Simulator, 744 pages, > ISBN 978-3-89929-258-9 > > -- > -TV
As an aside, I have that book. It is the heaviest book I have ever had. I got a free one at a seminar. It is really heavy.
Reply by Tauno Voipio February 14, 20192019-02-14
On 13.2.19 22:10, John Larkin wrote:

> It takes a little while to get good with LT Spice, but it's a fabulous > tool. I even use it for simple stuff like voltage dividers and time > constants. > > I "design by fiddling" a lot too, using instinct and Spice. When you > have an idea at 3AM, Spice is an ideal way to try/remember it. > > The HELP is mediocre, so if you have any other questions, post them > here. I still do.
W&uuml;rth Elektronik has published a book: Gilles Brocard, The LTSpice IV Simulator, 744 pages, ISBN 978-3-89929-258-9 -- -TV
Reply by February 13, 20192019-02-13
On Wednesday, February 13, 2019 at 7:01:44 PM UTC-5, jurb...@gmail.com wrote:
> >"Excel isn't hard. What are you trying to do? " > > Back when I had big trouble with ascites I wanted to plot my gut size and calf size each day and correlate it with what I ate, how much beer, and I also experimented with the dosage of the diuretics I take. I found that if I went low salt, low cars and low beer I could actually do away with the drugs, but salt and beer are two of the major food groups. Carbs I could eliminate, the other two no way. I am in life to live, not exist. But I am fine, BMI still under 30, all numbers good enough. > > All I wanted was a graph, a line plotted by day horizontal and vertical by my measurement, two different colors and two different scales. Around 30 to 45 inches for the gut and I forget, maybe 15 for the calf. Even with one line and one scale I couldn't make the MF do it. Thing is, I know it is simple but I lack the SPECIFIC information.
If you can't get the chart the way you want it, email me your data or the file you've created and I will make it pretty for you. LibreOffice can work with Excel formats so you will be able to open it once I edit it. I almost forgot about the blank row/line. I always include this at the end of the selection when I start a chart I might want to add data to. You can then insert rows or columns ahead of this last one and they will automatically be included in the chart. If you know a simpler way to extend a chart or sum, I'd like to know it. Rick C.
Reply by February 13, 20192019-02-13
On Wednesday, February 13, 2019 at 7:01:44 PM UTC-5, jurb...@gmail.com wrote:
> >"Excel isn't hard. What are you trying to do? " > > Back when I had big trouble with ascites I wanted to plot my gut size and calf size each day and correlate it with what I ate, how much beer, and I also experimented with the dosage of the diuretics I take. I found that if I went low salt, low cars and low beer I could actually do away with the drugs, but salt and beer are two of the major food groups. Carbs I could eliminate, the other two no way. I am in life to live, not exist. But I am fine, BMI still under 30, all numbers good enough. > > All I wanted was a graph, a line plotted by day horizontal and vertical by my measurement, two different colors and two different scales. Around 30 to 45 inches for the gut and I forget, maybe 15 for the calf. Even with one line and one scale I couldn't make the MF do it. Thing is, I know it is simple but I lack the SPECIFIC information.
This is very simple really. Enter the X and Y coordinates in rows or columns, your choice. You can even add a label to each one and it will show up. Select all the data and the labels and maybe an extra set of cells at the end of the row or column if you wish to continue to add data. I use LibreOffice rather than Excel, but this works the same, maybe in a different menu. I go to Insert and Chart. In the dialog box select X/Y Scatter. There should be a few options of points and lines to be displayed. I see there is one called "line" but there is some reason why I don't use it. I think maybe the X axis is always arbitrary rather than a variable with the Line type chart. Click finish and you should get what you want. You can click the chart and then select the Y axis and in the right click menu there should be a way to change the axis so there are two scales one for each data value so the curves can have their own range. Sometimes this requires a bit of work to find. Rick C.
Reply by February 13, 20192019-02-13
>"Excel isn't hard. What are you trying to do? "
Back when I had big trouble with ascites I wanted to plot my gut size and calf size each day and correlate it with what I ate, how much beer, and I also experimented with the dosage of the diuretics I take. I found that if I went low salt, low cars and low beer I could actually do away with the drugs, but salt and beer are two of the major food groups. Carbs I could eliminate, the other two no way. I am in life to live, not exist. But I am fine, BMI still under 30, all numbers good enough. All I wanted was a graph, a line plotted by day horizontal and vertical by my measurement, two different colors and two different scales. Around 30 to 45 inches for the gut and I forget, maybe 15 for the calf. Even with one line and one scale I couldn't make the MF do it. Thing is, I know it is simple but I lack the SPECIFIC information.
Reply by Clifford Heath February 13, 20192019-02-13
On 14/2/19 6:38 am, gnuarm.deletethisbit@gmail.com wrote:
> On Wednesday, February 13, 2019 at 2:17:28 PM UTC-5, jurb...@gmail.com wrote: >> I am top posting to say thanks to both of you. It works. >> >> Damn, all I had to do was put in one parameter. I would say I feel stupid but I am numb. >> >> I am not dumb though. I used to build PCs and knew all about the hardware n shit back then, useless knowledge now.Software was never my thing. >> >> Anyone care to teach me how to use Excel ? That SOB, I know what I want to do is so easy but if I don't know where the button is... > > Excel isn't hard. What are you trying to do? > I had used macros a few times, but
I had to automate an Excel spreadsheet with VBA code for a client once. Those three days were the worst month of my programming life. It's just so totally unnecessarily awful. Zero error reporting or debug capability, you just have to stumble around in the dark looking for things. Clifford Heath.
Reply by John Larkin February 13, 20192019-02-13
On Wed, 13 Feb 2019 11:17:23 -0800 (PST), jurb6006@gmail.com wrote:

>I am top posting to say thanks to both of you. It works. > >Damn, all I had to do was put in one parameter. I would say I feel stupid but I am numb. > >I am not dumb though. I used to build PCs and knew all about the hardware n shit back then, useless knowledge now.Software was never my thing.
It takes a little while to get good with LT Spice, but it's a fabulous tool. I even use it for simple stuff like voltage dividers and time constants. I "design by fiddling" a lot too, using instinct and Spice. When you have an idea at 3AM, Spice is an ideal way to try/remember it. The HELP is mediocre, so if you have any other questions, post them here. I still do.
> >Anyone care to teach me how to use Excel ? That SOB, I know what I want to do is so easy but if I don't know where the button is...
Don't use Excel! -- John Larkin Highland Technology, Inc picosecond timing precision measurement jlarkin att highlandtechnology dott com http://www.highlandtechnology.com
Reply by February 13, 20192019-02-13
On Wednesday, February 13, 2019 at 2:17:28 PM UTC-5, jurb...@gmail.com wrote:
> I am top posting to say thanks to both of you. It works. > > Damn, all I had to do was put in one parameter. I would say I feel stupid but I am numb. > > I am not dumb though. I used to build PCs and knew all about the hardware n shit back then, useless knowledge now.Software was never my thing. > > Anyone care to teach me how to use Excel ? That SOB, I know what I want to do is so easy but if I don't know where the button is...
Excel isn't hard. What are you trying to do? Spreadsheets use formulas frequently to do things as simple as sum columns of numbers or much more complex things. My production spread sheet will generate serial numbers containing letters and digits and properly increment them. That is one long formula! I use conditional formatting to flag errors in my record keeping. I've never figured out what good pivot tables are. I had used macros a few times, but when I would return to the same spread sheet a year or two later I didn't remember what they were doing. I don't use them any more. Rick C.