Forums
New posts
Search forums
What's new
Articles
Latest reviews
Author list
Classifieds
Log in
Register
What's new
Search
Search
Search titles and first posts only
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Rifles, Reloading, Optics, Equipment
Rifles, Bullets, Barrels & Ballistics
MERC - Maximum Effective Range Calculator
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="speedengineer" data-source="post: 1975857" data-attributes="member: 112986"><p>Thank you for the feedback! Scott and I had discussed that exact topic! We decided to choose the path of least resistance (option 4). </p><ol> <li data-xf-list-type="ol">Add a button to copy the inputs from the other simulation worksheet. Negative - yet another button = more confusing to use the tool.</li> <li data-xf-list-type="ol">Unlock the narrow cells in between each block of inputs, so you can select the whole block of inputs, and then copy/paste. Negative - users could accidentally type stuff in those narrow cells, since they aren't locked. </li> <li data-xf-list-type="ol">Delete the narrow rows between each input block, thus all inputs can be copy/pasted at once. Negative - it looks ugly <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite1" alt=":)" title="Smile :)" loading="lazy" data-shortname=":)" /></li> <li data-xf-list-type="ol">Do nothing, and see if anyone complains about it. </li> </ol><p>I'll look into fixing this for a future release. </p><p></p><p></p><p>For the time being, here is a trick!</p><p>On the SimB tab, reference each user input cell to equal the value from the SimA tab. For example, the MVSD input on the SimB tab would contain the following formula:</p><p><strong>='Simulation A - (Baseline)'!E10</strong></p><p>This way, whatever you type into the SimA inputs, the SimB inputs will match. Or you could do vise-versa to make simA match what you type into simB.</p><p></p><p>For those who don't know, you don't have to type all this out. The follow steps are how to reference a cell from another worksheet:</p><ol> <li data-xf-list-type="ol">Click a SimA input cell. </li> <li data-xf-list-type="ol">Hit "="</li> <li data-xf-list-type="ol">Click the SimB worksheet</li> <li data-xf-list-type="ol">Click the SimB input cell you want to reference</li> <li data-xf-list-type="ol">Hit Enter</li> </ol></blockquote><p></p>
[QUOTE="speedengineer, post: 1975857, member: 112986"] Thank you for the feedback! Scott and I had discussed that exact topic! We decided to choose the path of least resistance (option 4). [LIST=1] [*]Add a button to copy the inputs from the other simulation worksheet. Negative - yet another button = more confusing to use the tool. [*]Unlock the narrow cells in between each block of inputs, so you can select the whole block of inputs, and then copy/paste. Negative - users could accidentally type stuff in those narrow cells, since they aren't locked. [*]Delete the narrow rows between each input block, thus all inputs can be copy/pasted at once. Negative - it looks ugly :) [*]Do nothing, and see if anyone complains about it. [/LIST] I'll look into fixing this for a future release. For the time being, here is a trick! On the SimB tab, reference each user input cell to equal the value from the SimA tab. For example, the MVSD input on the SimB tab would contain the following formula: [B]='Simulation A - (Baseline)'!E10[/B] This way, whatever you type into the SimA inputs, the SimB inputs will match. Or you could do vise-versa to make simA match what you type into simB. For those who don't know, you don't have to type all this out. The follow steps are how to reference a cell from another worksheet: [LIST=1] [*]Click a SimA input cell. [*]Hit "=" [*]Click the SimB worksheet [*]Click the SimB input cell you want to reference [*]Hit Enter [/LIST] [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
Rifles, Reloading, Optics, Equipment
Rifles, Bullets, Barrels & Ballistics
MERC - Maximum Effective Range Calculator
Top