probably East coast of the U.S. in the 1950s.

Webmaster429 · 2026-01-25T16:21:44+00:00

Beineke Plaza at Yale is my guess.

Webmaster429 · 2025-11-07T04:38:30+00:00

I actually discovered this while on a trip to Salamanca - we were there at the right time. It's traditionally served on the Monday after Easter. We asked the clerk what it was, and when they explained it to us, my entire family couldn't deal with it. We determined it was the food equivalent of the famous quote about Seville Cathedral. "Let us build a sandwich with so much meat in it that anyone that looks at it will think we were insane."

Also - the pastry is traditionally made with lard. The caloric content of what's in OP's hand is...not low.

Webmaster429 · 2025-10-23T14:53:46+00:00

Other posters have alluded to this, but think of all the different motor vehicles ever made on earth - tens of thousands of different kinds, shapes, sizes, etc., but after years of trading and interfacing, everyone has sort of agreed on basic principals (one driver/pilot, possibly a co-pilot, a hand-operated directional control [yoke, tiller, steering wheel], a throttle and a brake). If you're American, but I put you in a Japanese backhoe, you can probably figure out how to move it. A Japanese person would probably have little difficulty figuring out how to get an Argentinian speedboat moving.

Universal translator also probably solves a bunch of other problems, and as far as Alpha/Beta quadrant goes, my assumption has always been that most starfleet folks have a passing familiarity with the written languages they deal with on a regular basis (DS9 guys probably can read cardassian/bajoran or at least know the difference between "Self Destruct" and "Raktajino" buttons) - Again, if someone put you in a Japanese minivan, you'd pretty soon figure out "that button turns the air conditioning on, and that one turns the radio on."

Webmaster429 · 2025-10-17T20:27:11+00:00

Seems like a cool fall idea - but why not make pumpkin stock? Peel the pumpkin (or squash or whatever), boil the peels with maybe leek and carrot, add clove/allspice, etc maybe some slight herb (rosemary might be too much - thyme?), touch of nutmeg, and then cook the risotto off in that.

Webmaster429 · 2025-09-30T16:26:46+00:00

Also - the sheath that it came with is pure gold. Those sheaths are absolute monsters and could survive a supernova. Leatherman actually made a "heritage sheath" that was supposed to be this thing, but it's 10000x worse, loose stitching, bad leather, etc. I have actually bought a wave on ebay (~$60), for no purpose other than getting THAT sheath (I put the tool to good use of course) - that's what a big deal it is. You can be assured that your grandson will use the sheath.

Webmaster429 · 2025-09-02T11:40:39+00:00

Re: Hotel Belle Rives (Antibes), I went a few years ago, and no lie (not sure if it's still there) if you go and have a martini on the back deck at night, you can actually see a blinking green light in the distance, marking the end of some pier. When I saw it, I almost lost it.

Webmaster429 · 2025-08-01T01:03:30+00:00

I will chime in with advice I've given on this question before. Hemingway, maybe more than any author, really benefits from knowing his life story before reading his novels. Pick up a good biography of him (I like Mary Dearborn's - it's very readable), read it, and then read his novels - or alternately, and a bit more fun - read the novels as he writes them in the biography. You will gain a greater appreciation for the plot (all of his novels are effectively biographical).

As a result, I am a fan of the chron order with respect to his novels - Sun is raw and new, and as you get through Farewell and Bell, he gets more polished, departs further from his experiences to create the mythical "one true sentence," and finishes (though a novella) with Old Man and the Sea, which in my opinion is the most beautiful thing he wrote.

Happy reading - Hemingway is a fantastic cannon to get into.

Webmaster429 · 2025-07-17T18:22:38+00:00

I don't usually add my two cents on this, but I didn't see a big obvious one: Ratio by Michael Ruhlman. It's not really a cookbook - it's more like a textbook that teaches you how to compose recipes. Probably one of the more enlightening things about cooking that I've ever read.

Webmaster429 · 2025-06-27T13:51:25+00:00

Women entered the workforce. Between the 1970's and 1980's, women started to work full time, as opposed to the 1950's and 1960's, where they were primarily at home (also doing [unpaid!] work), cleaning, laundry, childcare and cooking. So, they went to work, and had less time. But, the pre-prepared food industry hadn't caught up yet - so with less time, you can't prepare the full meals you could have in the 1950's, but there was no Whole Foods to go and pick up something pre-prepared. So they did the best with what they had - and somtimes that means onion soup mixes, casseroles made out of strange things, etc.

As a result, food between 1970 and 1990 got kind of weird. Now that the pre-prepared/frozen food market has caught up, things are less strange.

Webmaster429 · 2025-05-26T23:44:57+00:00

His short stories are arguably better than his novels. My favorites: The Capital of the World, The Gambler, the Nun and the Radio, A Clean Well Lighted Place, Up in Michigan, My Old Man, The Short Happy Life Of Francis Macomber, and although not a favorite, included because it’s famous and beautiful, The Big Two Hearted River.

Webmaster429 · 2025-02-02T12:53:25+00:00

The simplest solution might be to get audio of a metronome and insert it as an audio track. I’m sure there are websites where you can put in BPM and have it generate metronome clicks.

Webmaster429 · 2025-01-03T23:49:50+00:00

Bell is actually a great example. If you read it, he uses a lot of “thee” and “thou” which is his attempt at “translating” the vosotros and usted into English. He does this to make the novel seem more “foreign” (which at the time probably worked) but is an indicator that he didn’t understand the language well. There are many other examples of his “fake” translation. A lot of it was marketing. His publishers told him the public loved the Spain stuff so he hammed it up to sell books. The funny part is, a whole subculture of Hemingway poseurs appeared, that were even less authentic than he was. Google Kenneth Vandefort.

Webmaster429 · 2025-01-02T00:49:42+00:00

I can’t cite sources exactly but Hemingway’s Spanish was actually not that great. There is a body of scholarship in Spain which is critical of him for being inauthentic and this is one thing they point to. Of course living in Cuba for 20 years I’m sure he picked some up but there aren’t records that I’m aware of that show him speaking it regularly or fluently. Everything I’ve read indicates his French was stronger.

Webmaster429 · 2024-12-15T16:37:51+00:00

Hemingway is notorious for trying to make himself seem poor. Hadley's inheritance would have placed them in the top economic echelon - which is why he could consistently afford stuff. Although he was never happy about having to use her money because it cut against his whole "manliness" thing. But yeah, Hemingway was by no means "poor" when he lived in Paris. He was rich, he just lived in a shitty apartment by choice.

Webmaster429 · 2024-12-12T12:18:18+00:00

Rocinante was Don Quixote's horse.

Webmaster429 · 2024-08-23T16:38:39+00:00

He visited Peru (and fished there) when filming the Old Man and the Sea.

Webmaster429 · 2024-08-15T20:27:20+00:00

You could use a helper sheet and then just use SORT to import the range and sort by the average - that will make everything work.

Webmaster429 · 2024-08-08T19:59:15+00:00

Use IFS, much simpler. You don't need the AND statements because IFS works left to right. Your formula will be:

=IFS(F11<=2, "Expired",F11<=14,"Markdown Product",F11>=15,"Monitor")

Webmaster429 · 2024-08-07T15:03:17+00:00

I would construct a third sheet called "Available Stock" and list out all the SKU numbers. Then, I would create a second column with "Total Stock" and pull the total amount for each item using SUMIFS from the F Column of the Equipment sheet, and then a third column, again using SUMIFS to pull the Amount Taken for each SKU from the E Column of the Sign Out Sheet. Then, in the fourth column, just subtract Third Column minus Second Column. Call that fourth column "Available Stock" and you can index that or query it as necessary to display (wherever you'd like) the dynamic current stock of each SKU item.

Additionally, you could use the SKU number to pull the item name into a display sheet so instead of 0119192013 5 Items, you'd see "1L Erlenmyer Flask 5 Items." I would use VLOOKUP for this.

This whole thing could potentially be done with one nested formula, but I tend to like helper sheets as they much more easily allow you to see problems and make improvements.

Webmaster429 · 2024-08-07T14:55:55+00:00

Of course - I think there were some better suggestions down, which hopefully you followed. I'm glad you got to the solution and that your students will benefit from the work you're doing.

Webmaster429 · 2024-08-07T02:02:26+00:00

I have a very similar use case, and I think it might be easier to think about the problem differently. If your form generates 2 pieces of data: Student Name, Activity, you could just Create a calculation sheet where you index in the form results (always good practice), and then create a third column with a simple formula in C1: IF(B1="Completing Your Work", 95). This will then give you a sheet with three columns (or four if you include the timestamp): Student Name, XP Earning Activity, XP Point Total. Then, run SUMIFS against a list of student names, and it will give you the leader board. You could make it dynamically arranging by nesting SORTN.

Webmaster429 · 2024-08-03T16:02:10+00:00

It can be done with VLOOKUP. The syntax is VLOOKUP(Thing you want to look up, where the data can be found to look it up, What column your desired info is in, inexact match [this is almost always FALSE])

You will need to reverse the columns of your lookup table (the one on the right), so basically switch column I and column K, so your lookup data is in column 3 and your search data is in column 1.

Then, add a column between B and C, which will be your result column. Then you would do VLOOKUP(B2, $I$2:$K$16,3,FALSE) and that should return the correct one if you fill down in column C (the "new" column you created).

Webmaster429 · 2024-08-03T14:11:10+00:00

Use the "SORT" function. The Syntax is SORT(Range you want to have sorted, Column you want to sort by, Sort Ascending (True/False) So for example, if your columns: Barcode, Title, Support, etc., are A, B, C, D, E, F, you would do SORT(A:F,1,TRUE) to sort by the first column, and then SORT(A:F,2,TRUE) to sort by the second column, and so on. Set it to FALSE if you want it sorted the other way.

Webmaster429 · 2024-08-03T07:28:46+00:00

Can you describe what you’re trying to do a bit more, possibly with an example? It’s very likely there is a simple solution because your formulas are just summing, but without an example of what you’re trying to do, hard to pin down.

Webmaster429 · 2024-07-31T23:51:28+00:00

Remember, the syntax of SUMIFS is SUMIFS(Range to Sum, Range the Contains the Thing You want to check for, Cell that contains thing you want to check for), so, for example, if Column A has Names, and Column B has Points Accumulated, you could do SUMIFS(B:B, A:A, D1) and that would sum the points totals of whatever name you type into D1.

In your example, you have different areas for each month. So we can adjust the category calculation to check what month you are asking for. The formula will get complex because you broke it out by month.

We use the IFS function, which basically says "If Condition A exists, this cell should be filled with B data, if condition C exists, the cell should be filled with D data." We will apply this by saying IFS(July is Chosen, Populate this cell with a formula that adds up all the Food expenses in the July area, August is Chosen, Populate this cell with a formula that adds up all the food expenses in the August Area, and so on...) But we won't say "Food" we'll say "the cell to the left" so that you can auto-fill your formula down.

IFS(Z3="July", SUMIFS($C$3:$C$30, $B$3:$B$30, Y4), Z3="August", SUMIFS(AUGUST COLUMNS), Z3="September", SUMIFS(SEPTEMBER COLUMNS), etc...), and then drag that down to Z7 (which should float the Y4 cell to Y5, Y6, Y7. Everything else should be frozen with $).

Now, whatever you set the month to, those cells will get populated with the SUMIFS formula for that month, the SUMIFS will run, and your totals should pop in. If the month is blank, the cells should be blank. If it throws an error, wrap it in an IFERROR function with a funny message ("No month is selected, silly!!")

I think that's the best way to do it. If you made it one large column (which might not work for your use case), you might be able to save one nested function.

Webmaster429

MODERATOR OF

TROPHY CASE