Priority Sorter; All hail importance of visualizing, precedence and sequencing.
Interesting, Google seems to have squashed the Knurling Calculator on PJs website, both it's online presence AND his contact me? The fact it's accurate multiplies their insult to PJs. Sure, an app promotes them instead. HMT.net to the rescue. PJs offers emailing it on request. Take that Goliath We smite thee severely about ankle and shin, and taunt you a second time! Not everyone is smartphone'd. But a freaking LOT of us are smart!
Excerpt of Mr. Rick Sparber quote on PJs Knurling Calculator.
Quote:
Originally Posted by
rgsparber
I agree. Spreadsheets are a powerful computer "language". If equations exist, spreadsheets can make them easy to use. Another way to use spreadsheets is to format numbers and text that can be simply printed out.
Hats off to Excel and similar spreadsheet tools!
Rick
Yes, voting again, again and again in favor of excel spreadsheets. Most creative use for me is textual in nature. Works in Word too, but figures are less convenient to manipulate, and columns don't want to play along. Bad dog! So...
The effort to get my shop off the ground calls for extremely long stretches of accomplishment. OK for most to be concurrent. Hence, I have 4 priority 'sheets' within a single excel folder 'SHOP'. All four are prospective, one includes current inventory.
Building. described below.
Grounds. fencing, driveway & parking, flagpole, landscape haha [severe torture of volunteer growth].
Capital Equipment /Tooling. inseparable in my book. Populated by the total inventory and series, say NMTB 50 x diameter, or collets, rotary tables by size, QCTP by part number and description, etc but NO consumables.
Vehicles. A real truck, trailer, fork and pallet lifts, certain artwork, everything transport related.
Central is every possible thing I'd do in Building without considering cost. Drive in ramp, hot water heat, big gantry crane, plumbing, air rifle range, windows, artwork banner depicting machine work [NOT a business sign!] it's zoned M1, 'guests' will figure it out, entry way, solar array, mezzanine, related projects such as wiring it up [not components just the project].
Not endless but there are many, many more. Last count, way over 6000 items. Near impossible for a person to memorize or categorize on paper, very impractical to insert or edit. And no, actually doing them all probably won't occur - yet considering them remains important. Whether you hobby or enterprise; if you're on ebuy, cramizon, craigslist [plug], or Lost Creek Machine [!plug!] expansion is on the mind. "Have I got one of those"? My glorified man-cave is 60 miles away, no way to recall every item. Good for insurance too.
Anyway, whatever sheet I'm adding/ editing text in sub-groups within any subject, identified by vertical text merged cells in far left column. Within, rows are numbered in one of 1-3-5-7 or 9 to rank order they should be performed. Numerals and text occupy same cell. Recommend not going beyond 9, just group and numeral accordingly. ie Drywall ceiling, cut access openings, make removable panels, blow insulation, replace 110v lamps, wire 440v/ 3ph, add transformer, add florescent 277v, and so on. So when you decide 'paint', simple to identify when; too early, convenient, too late. Convenient, naturally is shortest time span. It can hold up progress too. That's where all this really starts to perform...are there workarounds? Just type it anywhere in correct set of rows, apply odd numeral, highlight the rows, A-Z sort = KAPOW. You can add fifty items, number them, the sort function does the rest. And CtrlF search works bingo when you 'lose' or 'did I add?', irrespective to any set of rows. Ooops, there it is! A hip-hop sound bite would be funny here.
Don't DELETE upon completion or when deciding 'No', just remove the numeral and re-sort. Avoids re-adding way down the road, BUT sometimes a new product, finding Blackbeard's treasure, or idea makes it work, just re-apply a numeral.
Won't post it in actuality, considering size and entries not useful to anyone. I'll annotate a screen shot instead; just playing in excel teaches you how to do things. And doesn't require a full PC; all I have is a laptop! OK, and a few thumbdrives. Appreciate air gap security, best of all!
Never bothered to see what kind of software has been prepared to do this, unless it's freeware [+ learning curve], a waste cause excel is already in there! Could have initiated four or five entire sheets, against time used to compose and write this. Well, as of noon,...a lot of distractions, text alts and previewing for maximum clarity since then. I mean, there's but a few letters difference from brevity to levity:rofl:.
As PJ's might say 'Oh my'...Sure enjoy everyone's feedback, and humor. I think prioritization is a big deal and precedence is what makes it work - just harder to discern and implement accurately.
HMT.net and a particular 'Off Topic' thread has given myself such means to forget about 'the box' completely. Thinking just 'outside it' is so old school.
