trashcan Posted August 20, 2022 Share Posted August 20, 2022 2.1 through 2.4 are calculated from Records. I want to add a column that is Extras Spares and then a sum Column that calculates the total. Column 3, 4 are manually added as they are spares not on the plot. I want to manually put in spare #s in column C that are calculated from records, but it won't let me. Is there a way to do this? Also the =SUM isn't working for total units for 2.1 through 2.4. It's calculating as "1" Help? thx Quote Link to comment
0 Mark Aceto Posted August 21, 2022 Share Posted August 21, 2022 1 hour ago, michaelk said: EL Dooro If you decide to create a plugin for multiple small doors, I have a name ready for that one too. 1 1 Quote Link to comment
0 hollister design Studio Posted August 24, 2022 Share Posted August 24, 2022 On 8/21/2022 at 9:22 AM, Mark Aceto said: @trashcansave these scripts Mark - I was looking at the scripts and wondering what are they showing and how would the info be useful? Quote Link to comment
0 Mark Aceto Posted August 24, 2022 Share Posted August 24, 2022 1 hour ago, hollister design Studio said: Mark - I was looking at the scripts and wondering what are they showing and how would the info be useful? @michaelk wrote a bunch of scripts to format cells etc without having to constantly disrupt your workflow by right-clicking, clicking Format Cells, clicking on a tab, yada, yada, yada... more clicking... Enter... They're the next best thing to having the Excel / Sheets editing interface we all dream of (not holding my breath). 2 Quote Link to comment
0 michaelk Posted August 24, 2022 Share Posted August 24, 2022 The scripts you're looking at are actually being triggered by the worksheet. It's pretty cool. The scripts Mark is talking about are in the attached document. Basically: select a cell or range of cells, double click on the script with the name of what you would like to do. Saves about 300 clicks. :-). Let me know if you have any questions about how to use them. New York Worksheets.vwx 2 Quote Link to comment
0 michaelk Posted August 24, 2022 Share Posted August 24, 2022 Wait! Never mind. I was conflating this thread with a different worksheet question thread. @hollister design Studio same scripts. I didn't mean to leave them open in response to @trashcan's question. 2 Quote Link to comment
0 hollister design Studio Posted August 24, 2022 Share Posted August 24, 2022 1 hour ago, michaelk said: ...Saves about 300 clicks. :-). now this is something I can get behind! 1 Quote Link to comment
0 michaelk Posted August 24, 2022 Share Posted August 24, 2022 17 minutes ago, hollister design Studio said: now this is something I can get behind! Seriously! 🙂 It can take up to 6 clicks to center the contents of a cell. With these scripts it's only one double click. It adds up fast if you have to do a lot of formatting to a worksheet. 1 Quote Link to comment
0 trashcan Posted August 25, 2022 Author Share Posted August 25, 2022 @michaelk you are a monster!! Can’t wait to try these out!! 1 Quote Link to comment
0 trashcan Posted August 25, 2022 Author Share Posted August 25, 2022 @michaelk amazing work. have been using today and it's insane that this stuff isn't built in! I want to combine your palletes into a single windows w/ several palletes and give the tools icons and all of that good-good. Wish I could dock 'em ! Again, amazing work. Thanks for making these. Quote Link to comment
0 michaelk Posted August 25, 2022 Share Posted August 25, 2022 You should feel free to rename them and move them between palettes to get it set up the way you want. I wish it was possible to give them icons! I don't remember if these scripts are in that file, but I have one script that opens all the other palettes and another one that closes them. I make those two scripts into menu commands with keyboard shortcuts. So I can open and close them quickly. Anything that speeds up worksheet editing speeds up the entire drawing :-). 3 Quote Link to comment
0 trashcan Posted August 25, 2022 Author Share Posted August 25, 2022 You didn't include that handy-dandy additional super-power. I'd love it though. Quote Link to comment
0 Mark Aceto Posted August 25, 2022 Share Posted August 25, 2022 1 hour ago, michaelk said: Anything that speeds up worksheet editing speeds up the entire drawing :-). Especially when editing a worksheet that bi-directionally edits objects in the drawing 😎 Quote Link to comment
0 michaelk Posted August 25, 2022 Share Posted August 25, 2022 Here's the code. It's super complicated: OpenScriptResPal('WS Cell Border/Fill',TRUE); OpenScriptResPal('WS Formatting',TRUE); OpenScriptResPal('WS Image',TRUE); OpenScriptResPal('WS Numbers',TRUE); OpenScriptResPal('WS Sort Sum Summarize',TRUE); Whatever script palettes you want, the name goes in the single quotes. If the last argument is TRUE it opens the palette. If it's false, it closes the palette. You can make these into menu commands with keyboard shortcuts or just run them as their own scripts. See. Vector script is easy! 1 Quote Link to comment
Question
trashcan
2.1 through 2.4 are calculated from Records. I want to add a column that is Extras Spares and then a sum Column that calculates the total.
Column 3, 4 are manually added as they are spares not on the plot.
I want to manually put in spare #s in column C that are calculated from records, but it won't let me. Is there a way to do this?
Also the =SUM isn't working for total units for 2.1 through 2.4. It's calculating as "1"
Help? thx
Link to comment
39 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.