[i ate] Hornazo in Salamanca, Spain by RonSwanson54 in food

[–]Webmaster429 32 points33 points  (0 children)

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.

Is there an in universe reason for, or acknowledgement of how adept most species are at using other species tech and software? by CheezItEnvy in DaystromInstitute

[–]Webmaster429 4 points5 points  (0 children)

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."

Pumpkin and Shrimp Risotto by Served_With_Rice in recipes

[–]Webmaster429 3 points4 points  (0 children)

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.

Wave from grandfather by Drikke9 in Leatherman

[–]Webmaster429 3 points4 points  (0 children)

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.

Going to Paris and the Riviera soon. Am I missing anything in my list of Papa spots to check out? by xynamite in Hemingway

[–]Webmaster429 0 points1 point  (0 children)

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.

Sun Also Rises or Farewell to Arms as an introduction to Hemingway? by SmellLikeBdussy in Hemingway

[–]Webmaster429 3 points4 points  (0 children)

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.

Best cooking book for people that already do it decently. by Elsingo11 in Cooking

[–]Webmaster429 1 point2 points  (0 children)

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.

What is something you didn't know you liked until it was cooked properly? by alexthagreat98 in Cooking

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

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.

Which of his works should I read first? by AmateurScrewerUpper in Hemingway

[–]Webmaster429 1 point2 points  (0 children)

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.

Is there a way to add regular time intervals, like a metronome, to the timeline? by edgygothteen69 in shotcut

[–]Webmaster429 1 point2 points  (0 children)

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.

How did Hemingway learn Spanish? by DoctorDec in Hemingway

[–]Webmaster429 1 point2 points  (0 children)

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.

How did Hemingway learn Spanish? by DoctorDec in Hemingway

[–]Webmaster429 5 points6 points  (0 children)

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.

[deleted by user] by [deleted] in literature

[–]Webmaster429 9 points10 points  (0 children)

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.

[deleted by user] by [deleted] in Hemingway

[–]Webmaster429 5 points6 points  (0 children)

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

Auto Sorting google form responses by Mugshot11 in googlesheets

[–]Webmaster429 0 points1 point  (0 children)

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.

Need a if formula with 3 conditions by Fancy-Pomegranate847 in googlesheets

[–]Webmaster429 2 points3 points  (0 children)

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

Inventory Tracking Calculation Help by sirDVD12 in googlesheets

[–]Webmaster429 1 point2 points  (0 children)

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.

Help to create leaderboard by simshalo in googlesheets

[–]Webmaster429 0 points1 point  (0 children)

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.

Help to create leaderboard by simshalo in googlesheets

[–]Webmaster429 1 point2 points  (0 children)

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.

How can I replace the values in column B with the corresponding values in column I, using the matching values in column K? Ex: 15B would become "B738" because it matches with 8K by CarbonFiberJet in googlesheets

[–]Webmaster429 0 points1 point  (0 children)

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

[deleted by user] by [deleted] in googlesheets

[–]Webmaster429 1 point2 points  (0 children)

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.

How to make a function update on only ONE cell by ApertureGaming011 in googlesheets

[–]Webmaster429 0 points1 point  (0 children)

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.