From Newsgroup: sci.electronics.design

My goal is to generate this 24 VDC arb:

<https://crcomp.net/misc/waveform.png>

Keysite suggests it's easy peasy with Excel:

<https://faculty.uccs.edu/mwickert/wp-content/uploads/sites/58/2024/10/ARB_file_creation.pdf>

My Signal Generator accepts CSV files as input:

<https://wiki.analog.com/university/tools/m2k/scopy/siggen>

It is indeed easy peasy for Excel to export the requisite CSV file.

Are there any available Excel arb gurus in-group to point me in the
right direction?

If not, it's probably easier for me to use octave to create a MAT file
for my Signal Generator.

Thank you in advance.

--
73, Don, WD7Q veritas _|_
liberabit | https://www.qsl.net/wd7q vos |

--- Synchronet 3.22a-Linux NewsLink 1.2

From Newsgroup: sci.electronics.design

My goal is to generate this 24 VDC arb:

<https://crcomp.net/misc/waveform.png>

Keysite suggests it's easy peasy with Excel:

<https://faculty.uccs.edu/mwickert/wp-content/uploads/sites/58/2024/10/ARB_file_creation.pdf>

My Signal Generator accepts CSV files as input:

<https://wiki.analog.com/university/tools/m2k/scopy/siggen>

It is indeed easy peasy for Excel to export the requisite CSV file.

Are there any available Excel arb gurus in-group to point me in the
right direction?

If not, it's probably easier for me to use octave to create a MAT file
for my Signal Generator.

Thank you in advance.

# # #

Curve fitting techniques found in Numerical Analysis can create arbs. On
its surface, Cubic Spline Interpolation and other approaches look not so
easy peasy.

It's time to move on to digitizing a freehand sketch.

--
73, Don, WD7Q veritas _|_
liberabit | https://www.qsl.net/wd7q vos |

--- Synchronet 3.22a-Linux NewsLink 1.2

From Newsgroup: sci.electronics.design

On 8/16/26 8:35 AM, Don wrote:

My goal is to generate this 24 VDC arb:

<https://crcomp.net/misc/waveform.png>

Keysite suggests it's easy peasy with Excel:

<https://faculty.uccs.edu/mwickert/wp-content/uploads/sites/58/2024/10/ARB_file_creation.pdf>

My Signal Generator accepts CSV files as input:

<https://wiki.analog.com/university/tools/m2k/scopy/siggen>

It is indeed easy peasy for Excel to export the requisite CSV file.

Are there any available Excel arb gurus in-group to point me in the
right direction?

If not, it's probably easier for me to use octave to create a MAT file
for my Signal Generator.

Thank you in advance.

# # #

Curve fitting techniques found in Numerical Analysis can create arbs. On
its surface, Cubic Spline Interpolation and other approaches look not so
easy peasy.

It's time to move on to digitizing a freehand sketch.

--
73, Don, WD7Q veritas _|_
liberabit | https://www.qsl.net/wd7q vos |

Your picture is pretty small but to me that looks basically like
positive gaussian pulses and then half of a positive gaussian pulse
followed by a vertical negative spike followed by an exponential decay
back to the x axis. Define your x axis point spacing from your arb
waveform size, use Excel to model each shape in separate columns using
the appropriate formula, copy and paste the models into one big column separated by sections of zeros for the baseline between pulses to get
one cycle of your waveform, and output the column as csv. Carry the
gaussian and exponential decay models out far enough for them to get
close enough to zero so that you don't have a big discontinuity where
you insert a run of actual zeros before the next pulse if that matters,
or just insert a linear slope to zero long enough to smooth out the transition. If the positive pulses look more like some other standard
pulse shape and it matters, use that formula instead of gaussian.
That's how I'd approach it, anyway.
--
Regards,
Carl
--- Synchronet 3.22a-Linux NewsLink 1.2

From Newsgroup: sci.electronics.design

On Sun, 16 Aug 2026 04:11:03 -0000 (UTC), "Don" <g@crcomp.net> wrote:

My goal is to generate this 24 VDC arb:

<https://crcomp.net/misc/waveform.png>

Keysite suggests it's easy peasy with Excel:

<https://faculty.uccs.edu/mwickert/wp-content/uploads/sites/58/2024/10/ARB_file_creation.pdf>

My Signal Generator accepts CSV files as input:

<https://wiki.analog.com/university/tools/m2k/scopy/siggen>

It is indeed easy peasy for Excel to export the requisite CSV file.

Are there any available Excel arb gurus in-group to point me in the
right direction?

If not, it's probably easier for me to use octave to create a MAT file
for my Signal Generator.

Thank you in advance.

That's similar to a waveform that we're working with, a gear-tooth
wheel with a variable-reluctance pickup. The gear has long or short or
offset teeth to give a once-per-rev index.

One of my guy used some AI thing to simulate the geometry and make the
waveform files.

--- Synchronet 3.22a-Linux NewsLink 1.2

From Newsgroup: sci.electronics.design

"Don" <g@crcomp.net>wrote:

My goal is to generate this 24 VDC arb:

<https://crcomp.net/misc/waveform.png>

Keysite suggests it's easy peasy with Excel:

<https://faculty.uccs.edu/mwickert/wp-content/uploads/sites/58/2024/10/ARB_file_creation.pdf>

My Signal Generator accepts CSV files as input:

<https://wiki.analog.com/university/tools/m2k/scopy/siggen>

It is indeed easy peasy for Excel to export the requisite CSV file.

Are there any available Excel arb gurus in-group to point me in the
right direction?

If not, it's probably easier for me to use octave to create a MAT file
for my Signal Generator.

Thank you in advance.

# # #

Curve fitting techniques found in Numerical Analysis can create arbs. On
its surface, Cubic Spline Interpolation and other approaches look not so
easy peasy.

It's time to move on to digitizing a freehand sketch.

If you draw on a 2000 x 1000 pixels screen (as example),
you can scan left ot right x and y position of each dot.
You could add log if you want,
If the signal is periodic draw one period.
Who needs big software packages?
Bit of C coding.

--- Synchronet 3.22a-Linux NewsLink 1.2

From Newsgroup: sci.electronics.design

Thank you Carl and Jan for your input elsewhere. "To each his own." In
this particular situation, GNU Octave offers the easiest solution for
me. Your mileage may vary.

john larkin <jl@htigct.com> wrote:

On Sun, 16 Aug 2026 04:11:03 -0000 (UTC), "Don" <g@crcomp.net> wrote:

My goal is to generate this 24 VDC arb:

<https://crcomp.net/misc/waveform.png>

Keysite suggests it's easy peasy with Excel:

<https://faculty.uccs.edu/mwickert/wp-content/uploads/sites/58/2024/10/ARB_file_creation.pdf>

My Signal Generator accepts CSV files as input:

<https://wiki.analog.com/university/tools/m2k/scopy/siggen>

It is indeed easy peasy for Excel to export the requisite CSV file.

Are there any available Excel arb gurus in-group to point me in the
right direction?

If not, it's probably easier for me to use octave to create a MAT file
for my Signal Generator.

Thank you in advance.

That's similar to a waveform that we're working with, a gear-tooth
wheel with a variable-reluctance pickup. The gear has long or short or
offset teeth to give a once-per-rev index.

One of my guy used some AI thing to simulate the geometry and make the waveform files.

Yes, it simultaneously occured to me too, that AI ought to be good for something. Give your guy a big fat raise. He earned it.

AI cooked up a GNU octave recipe. It ought to be enough to kickstart my
arb: <https://crcomp.net/misc/Octave%20image%20to%20CSV.pdf>

--
73, Don, WD7Q veritas _|_
liberabit | https://www.qsl.net/wd7q vos |

--- Synchronet 3.22a-Linux NewsLink 1.2

From Newsgroup: sci.electronics.design

Normalize the time axis between 0 and 1. Then assuming 24 V scale:

1.Positive Guassian Pulse Vpulse(t)=A*EXP(((t-u)/s)^2)

A (Amplitude): Peak voltage height (set to 15V
u (Mean): Center location of the pulse on the time axis (placed at t = 0.15 and t = 0.35).
s (sigma ) Standard Deviation/Width: Controls pulse sharpness (set to 0.03)

2.Half Gaussian Pulse (Rising Edge)For the indexing tooth segment leading up to the trigger point (t<= 0.55):

Vrise(t)=A*EXP(((t-0.55)/s)^2)

3.Sharp Vertical Negative Spike & Exponential Decay

Vdecay(t)= -Aspike(t)*EXP(-lambda*(t-0.55))

-Aspike The maximum negative peak depth ( set to -20V)
lambda (Decay Rate Constant): Controls how quickly the signal settles back to zero (set to 15) for a rapid recovery)

The CSV file contains a single column of 2,000 digitized voltage points representing a complete 24 VDC arbitrary waveform cycle. It models the components discussed in the forum: two distinct positive pulses, a rising half-pulse, a sharp negative vertical spike, and an exponential decay back to the baseline.

AI is kind of amazing. It still requires human oversight, but it's not much, and it saves time on the minutiae. It even prepares the 2000-point CSV file contents. Looks like one column for normalized time and a second for amplitude. Dazzlingly uncomplicated.
--
For full context, visit https://www.electrondepot.com/electrodesign/arb-assist-ask-4408725-.htm

--- Synchronet 3.22a-Linux NewsLink 1.2