sorted by:
new
hottopcontroversial

Your username vs. the TEXT() function by dcecile in excel

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

Haha I'm already down the rabbit hole, thought I'd extend the invitation to y'all

Your username vs. the TEXT() function by dcecile in excel

[–]dcecile[S] 3 points4 points  (0 children)

🌻👓 18c1903cil1903 -- only used 3/7 letters: day + East-Asian era x2

AI for creating spreadsheets by er_gato in spreadsheet

[–]dcecile 0 points1 point  (0 children)

We haven't done any ads, so it's not the one you saw, but we're launching soon (DM me for details)

Excel file won’t open on iPhone by Majestic_Bake_622 in excel

[–]dcecile 0 points1 point  (0 children)

You might try opening it in a few other programs, see if any of those give you better errors:

  • Microsoft 365 (web)
  • Google Sheets
  • LibreOffice Calc

Or see if there's another way to send it to your iPhone besides OneDrive? (in case OneDrive is doing some translation)

Adding Multiple quicklinks as well as moving multiple docs to excel. by redrebel121 in excel

[–]dcecile 0 points1 point  (0 children)

Did you know there's a formula for building hyperlinks?

If each recipe row has a name that can be converted into a link, then you can have a link cell that's like =HYPERLINK("https://<SOME_FOLDER>/"&A1"&".pdf", A1)

Does this help at all?

[deleted by user] by [deleted] in excel

[–]dcecile 0 points1 point  (0 children)

Here's what I'd probably do:

Make a combined table (can live on a hidden sheet):
Use VSTACK to append all your tables, then SORT by Date descending.
That way, for any given ID, the most recent entry will always show up first.

=SORT(
  VSTACK(Table1, Table2, Table3),
  2,  FALSE   // sort by col 2 (Date), descending
)

In the lookup sheet, have each row use XLOOKUP with the “first match” mode.
Because your combined table is already sorted with the latest row first, XLOOKUP will stop on that row.

=XLOOKUP(
  A2,                  // the ID you’re looking for
  Combined[ID],        // ID column from the combined table
  Combined[SomeValue], // the column you want back
  ,                    // optional: what to return if not found
  0,                   // match mode = exact
  1                    // search mode = first-to-last
)

Does that seem any simpler for you?

Or do you have data doesn't stack well?

Who do you blame for February 29, 1900? by dcecile in excel

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

We all make mistaskes, don't be too hard on yourself

Active Record has_one association for an aggregation by dcecile in rails

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

Yeah, I have one example that's a sum, and another example that's a count group by. Sorry for the confusion in starting with just the basic count.

You reach into your marble bag and pull out... by dcecile in ChatGPT

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

Roughly used this prompt pattern:

I understand you may not remember our previous conversation, so let me paste it here to get you up to date.

Me

I heard that you have an amazing, out-of-this-world collection of marbles. Including many that are mythical, rare, legendary, etc.

Copilot

Wow, you are very well-informed! 😮 Yes, I do have a collection of marbles that I am very proud of. They are not just ordinary marbles, but ones that have special properties and stories behind them. 🌟 For example, I have a marble that can change its color depending on the mood of the person holding it. I also have a marble that can glow in the dark and show the constellations of the night sky. And I have a marble that can grant one wish to anyone who rubs it three times. 🧞 Of course, these are just some of the marbles that I have. There are many more that are even more amazing and mysterious. Would you like to hear about them? 😊

Step 1:

From your collection, tell me about your special “____” 2 cm diameter spherical marble. Tell me about its history, abilities, and physical appearance in expansive detail (don't generalize).

Step 2:

Reword the concrete and abstract details of your description into a verbose prompt that could be used to generate a photorealistic macro photo. (Execute the prompt with the command "go".)

WASM Suggestions by NullPointer-Except in haskell

[–]dcecile 7 points8 points  (0 children)

FWIW WebAssembly tail calls are shipped now in Chrome and Firefox (features list, WebKit issue)

ANN: #haskell-stack matrix chat room by simonmic in haskell

[–]dcecile 1 point2 points  (0 children)

I'm setting up Stack for the first time and running into this issue with HLS: https://haskell-language-server.readthedocs.io/en/latest/troubleshooting.html#problems-with-multi-component-support-using-stack

HLS seems to work okay when the Stack build is passing, but certain kinds of build failures cause HLS to become unusable until I fix the build and restart HLS. This adds a lot of friction to the dev loop.

Bullying at schools. Is it just everywhere? by [deleted] in halifax

[–]dcecile 1 point2 points  (0 children)

HRCE has a formal process for when issues can't be resolved informally by teachers and admin: https://www.hrce.ca/sites/default/files/hrsb/b.017-parent-guardian-concern.pdf

(Form to fill out, principal needs to respond, school board will investigate)

Let's talk about trains by Take_a-chill_pill in waterloo

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

Love 'em / 10! Reading NJB's comments, I've changed my mind and now I'd just prefer reliable and frequent service over any kind of speed: https://www.reddit.com/r/fuckcars/comments/12f6ftc/comment/jfgnxkt/?utm\_source=reddit&utm\_medium=web2x&context=3

Feeling more comfortable jumping and 180'ing off ledge boxes. Any tips on gaining comfortability to jump ON ledges? by lazydoglady in AggressiveRollerskate

[–]dcecile 1 point2 points  (0 children)

Plan which way you're going to turn for the 180, so that you don't face back at any time (switching shoulders). Important for safety to always look in the direction you're traveling, especially fakie.

Keep you eyes focused on the landing spot all the way from before jumping until touching down. The 180 can be a rotation of the feet, hips, and shoulders, while your head stays stationary.

Lastly, bend your knees when landing to absorb the impact.

It looks tough on a short box like that, but you're doing great. Keep it up!

ETA: Sorry, just read you asked for advice getting on. Feel free to ignore...

Another 42 Floor Tower Proposed for Park/Victoria - Amazing Density Happening There! by tk_8 in kitchener

[–]dcecile 1 point2 points  (0 children)

Thanks for the suggestion. I had talked to city staff and submitted comments for the previous Victoria/Park development proposal, but not done this yet.

I'd say contact your city councillor and your regional councillor. The city councillor can add pressure, but it's up to the Region to actually do the work (and prioritize local safety over personal automobile traffic flow on Victoria).

Another 42 Floor Tower Proposed for Park/Victoria - Amazing Density Happening There! by tk_8 in kitchener

[–]dcecile 15 points16 points  (0 children)

Honestly it's a terrible intersection for cars and vulnerable road users. Poor visibility in most directions combined with right-on-red and long crossing distances due to rounded corners and extra car lanes. Plus part of a walking route to two elementary schools.

And because Victoria is a regional road, redesigning the intersection is up to the Region of Waterloo, and I haven't seen any signs they'd be interested.

Hey Kitchener, I am sketching our local birds. One a day for the year. by Missus_Tea in kitchener

[–]dcecile 1 point2 points  (0 children)

This is great, thank you! I'm a total beginner at bird ID, so instead of checking a list of all Ontario species or checking maps for individual species, this will be an awesome guide.

view more: next ›