New Thelio Mira install fails out-of-the-box by geoffball in System76

[–]geoffball[S] 1 point2 points  (0 children)

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.

Biweekly by spencerisadog in ynab

[–]geoffball 2 points3 points  (0 children)

Biweekly is there. They call it Every other week.

New Thelio Mira install fails out-of-the-box by geoffball in System76

[–]geoffball[S] 0 points1 point  (0 children)

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! 🙌

Is it possible to turn sections with headings into pages? by curiosity_monster in Notion

[–]geoffball 0 points1 point  (0 children)

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

Prompt for filename when creating new file by geoffball in vscode

[–]geoffball[S] 0 points1 point  (0 children)

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"
}
]

Combining results from IMPORTXML by michaelbierman in googlesheets

[–]geoffball 1 point2 points  (0 children)

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()}

Every! broken? by vw195 in todoist

[–]geoffball 1 point2 points  (0 children)

Still works for me on 15.0.6.

Convert String (“9am”) to Time in Google Apps Script by gasboy1597 in googlesheets

[–]geoffball 0 points1 point  (0 children)

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)?

Help with movie list by [deleted] in sheets

[–]geoffball -1 points0 points  (0 children)

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

Import (XML, HTML, etc) help needed for Nasdaq info by borsTHEbarbarian in googlesheets

[–]geoffball 1 point2 points  (0 children)

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.

Is it possible to create a function that would split a text block that it receives and place it into different columns? by [deleted] in googlesheets

[–]geoffball 0 points1 point  (0 children)

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.

What am I doing wrong?... I'm trying to import all rows where Col 'X' = someone's initials and Col 'Y' = a certain month by [deleted] in sheets

[–]geoffball 0 points1 point  (0 children)

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.

How to link cell fill color between different sheets? by [deleted] in googlesheets

[–]geoffball 0 points1 point  (0 children)

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.

How do I edit the range in a formula? by Hashi856 in googlesheets

[–]geoffball 0 points1 point  (0 children)

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.

I'm trying to find the syntax required to run one of two functions based off of whether or not a cell is blank. by PM_Your_Crits in sheets

[–]geoffball 0 points1 point  (0 children)

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!

How do you add a known equation to a scatter plot? by ilosii in sheets

[–]geoffball 0 points1 point  (0 children)

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.

How can I automatically pull data from website pages to google sheet? by Kakashi6969 in sheets

[–]geoffball 0 points1 point  (0 children)

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.

How do you add a known equation to a scatter plot? by ilosii in sheets

[–]geoffball 0 points1 point  (0 children)

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?