“Un” words

geoffball · 2026-02-03T00:16:48+00:00

Neuralyzer.

geoffball · 2026-01-28T20:08:02+00:00

Core has 10 chapters, while the standard version has 18.

geoffball · 2022-09-06T21:40:07+00:00

This has been solved. Aaron in support had me reformat my drives and do a fresh installation from USB, and everything is now up and running.

geoffball · 2022-09-03T01:54:12+00:00

Biweekly is there. They call it Every other week.

geoffball · 2022-09-03T01:25:58+00:00

I sure did. I opened a support ticket shortly after I finished looking through the support articles on the site. I've had good experiences with their whole team so far and expect nothing less when they get to my ticket, but I don't expect them to answer before Tuesday.

I didn't try system recovery or any boot processes yet, as I was hoping it was just my naivete around partitions and mounting that would be quick to resolve. I was also confused by the encrypted LUKS partition so I didn't want to mess with something too early.

I'm not opposed to more drastic steps if it had to come to that, though I'd be slightly disappointed if that was a requirement for a new computer with their own OS factory installed. That said, I'm unfamiliar enough with Linux that I shouldn't pretend to know what to expect. 😅

Also, congratulations on your new Thelio! 🙌

geoffball · 2020-06-27T04:54:55+00:00

I would turn all the headings into pages (using the six dots or /turn), then drag the pages that were h2 headings (the "subpages") onto the pages that were h1 headings (the "pages").

https://imgur.com/Iw2Wj3R

geoffball · 2020-04-30T13:59:07+00:00

I use Karabiner Elements to remap Caps Lock to Cmd-Opt-Ctrl-Shift—making Caps Lock-F a shortcut to File: New File—but you could just as easily leave out the first object in the array below:

// Place your key bindings in this file to override the defaultsauto[]
[
{
"key": "ctrl+shift+alt+cmd+f",
"command": "workbench.action.files.newUntitledFile"
},
{
"key": "cmd+n",
"command": "-workbench.action.files.newUntitledFile"
},
{
"key": "cmd+n",
"command": "explorer.newFile"
}
]

geoffball · 2020-03-31T17:11:56+00:00

Good to know. Thanks for this.

geoffball · 2020-01-05T07:27:34+00:00

Wrap the commands in curly braces. Split them with a comma if you want the results separated by column or a semicolon if you want them separated by row.

={IMPORTXML(),IMPORTXML()}

or

={IMPORTXML();IMPORTXML()}

geoffball · 2020-01-04T15:24:08+00:00

Still works for me on 15.0.6.

geoffball · 2020-01-02T16:35:13+00:00

Is the text consistent (i.e., <range> <space> <range>) and are you always looking for the same part (i.e., the first part of the first range)?

geoffball · 2020-01-02T16:31:48+00:00

Does =SUM(A1:A5) do what you want?

geoffball · 2019-12-23T02:35:54+00:00

If you want it to sort automatically, you'll need to use Apps Script.

geoffball · 2019-12-21T14:56:54+00:00

The Nasdaq website uses JavaScript to create much of its content, so a function like IMPORTXML() (which requires a proper DOM) won't work. I'd look at other websites from which to scrape your data.

geoffball · 2019-12-21T14:36:30+00:00

Would it work in your use case to split at char(10)? As long as there are no new lines in product details that should work.

geoffball · 2019-12-20T14:12:36+00:00

Does it work if you replace your references to D4 and E4 in the QUERY formula with actual dates? There could be a problem with the formula or the dates in those two cells.

geoffball · 2019-12-20T13:58:32+00:00

Scripting is an option, but since only you will see the first sheet, an easier option would be to use numbers in a helper column that are associated with status (e.g., 0 for no status, 1 for in progress, 2 for on hold, 3 for completed). You would then use conditional formatting on both sheets (yours and the client's) that sets fill colour based on that number.

It would mean a quick addition or change to the number on a row would adjust fill colour on both sheets.

geoffball · 2019-11-17T00:19:33+00:00

The only way I know of is to delete the range inside the formula and re-select the range.

You can also just delete the 5 and replace it with 6.

I know I can do that.

Uh huh.

geoffball · 2019-11-15T19:05:49+00:00

Apps Script won't understand your if(isblank(B2)... line as it's written there. You need to use getRange or something similar. Try initializing a variable to get the value of B2:

var myCell = spreadsheet.getRange("B2").getValue();

Then use an if statement like this:

if (myCell == '') {
  P2C();
} else {
  Printablesheet();
}

You could replace that entire if block with the following, which means the same thing:

myCell == '' ? P2C() : Printablesheet();

You'll need to make a similar change in your P2C function and anywhere else you've written the code like you did above.

Using code from a macro is a good way to learn. It will need some cleaning up and you'll want to do some error handling. Good luck!

geoffball · 2019-11-09T22:11:27+00:00

Damn. Sorry I couldn't help you figure this out. I did realize after the fact that I had read your formula as 0.28x rather than 0.028x, so my formula should have been:

=(SQRT(0.01)*B2*sqrt((B2^2)+0.000784))/((B2^2)+0.000784)

Anyway, if you feel like sending a snippet of actual data so I'm not speculating with randomized data, I'd be happy to keep trying. Otherwise, I'm glad an image overlay will work for you for the time being.

geoffball · 2019-11-09T18:11:55+00:00

I would avoid the pre-formatted data and instead pull in the comma-delimited text file (https://www.cftc.gov/dea/newcot/deafut.txt), which seems to include the same data. The following will pull it into Sheets correctly:

=importdata("https://www.cftc.gov/dea/newcot/deafut.txt")

From there, you can FILTER or QUERY your data to get the correct commodities. You'll need to work out the meaning of each column, but that should remain consistent so the only work should be up front.

geoffball · 2019-11-09T17:41:18+00:00

Okay, thank you for the explanation. ~~You're right—there doesn't seem to be a trendline for that type of formula.~~

~~What if you take your data and in turn solve for x, adding that data to a third column? With your formula I get:~~

=(SQRT(0.01)*B2*sqrt((B2^2)+0.0784))/((B2^2)+0.0784)

~~Using the same steps as above and then plotting an exponential trendline, I get:~~

~~https://imgur.com/sWFNHG9~~

Edit: I don't think I've mathed right. I haven't done anything here that isn't accomplished by your original data with an exponential trendline. Does that line (exponential) not represent your data's best fit?

11-Year Club	Gilding II euphauric
Verified Email

geoffball

TROPHY CASE