to do?
I might populate the data to the maximum number of queue depth and in the
formulas for the simulated queue data I would check to see of the data
applies.
Otherwise, I guess a macro to generate or copy the formulas to the required
queue depth might help.
Web Query - with queue depth as a parameter might be an easy way to generate
sample data with number of records.
Tell me more about you are trying to do? create test scripts?
eric
_____
From: Greg Saunders [mailto:[EMAIL PROTECTED]
Sent: July 26, 2004 8:41 AM
To: CF-Talk
Subject: Re: OT: Excel ?
Hi Michael,
This is trivial to do using VBScript in Excel, assuming that you're able to
run macros. Are your dynamic rows on the same worksheet as the cell
containing your number of customers? If you decrease the number of
customers, are rows deleted?
If you want, send me your spreadsheet off list, and I can add a script to
get you started.
Greg
At 08:02 PM 7/25/2004, Michael T. Tangorre wrote:
>Does anyone know how to dynamically add rows in excel?
>
>Here is what I have. I have a queue simulation setup in excel whereby in a
>cell you specify the number of "customers" as an interger. So for instance,
>500. When I put that number in there I would to dynamically create 500
rows.
>Now for the kicker, I have one row setup already, customer 1. All the
>formulas are in this row's columns.... So all new rows should be based on
>the formulas from customer row #1. Is this possible?
>
>I have been reading simulation info on google all day, but can't figure it
>out..
>
>TIA,
>
>Mike
>
>----------
>[<http://www.houseoffusion.com/lists.cfm/link=t:4>Todays Threads]
>[<http://www.houseoffusion.com/lists.cfm/link=i:4:172002>This Message]
>[<http://www.houseoffusion.com/lists.cfm/link=s:4>Subscription]
>[<http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=5467.4972.4>Fa
st
>Unsubscribe] [<http://www.houseoffusion.com/signin/>User Settings]
>[<https://www.paypal.com/cgi-bin/webscr?amount=&item_name=House+of+Fusion&b
usiness=donations%40houseoffusion.com&undefined_quantity=&cmd=_xclick>Donati
ons
>and Support]
>
>----------
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
