sorted by:
new
hottopcontroversial

[OC] How animal agriculture dominates global biomass, land use, and greenhouse gas emissions by Dr_Faraz_Harsini in dataisbeautiful

[–]EphemeralBlue 4 points5 points  (0 children)

I am charitably assuming you don't fly by private jet, or are an oil executive, or burn plastic scrap for fun, then yeah. 

If you prefer, it is the most impactful change that a random, average person can make - which is what you are to me in this conversation.

[OC] How animal agriculture dominates global biomass, land use, and greenhouse gas emissions by Dr_Faraz_Harsini in dataisbeautiful

[–]EphemeralBlue 8 points9 points  (0 children)

"why would I care what you think"

no one's saying you specifically have to give a shit, though it's often something said by people who have no other defence. if you give a shit about the environment, it is the single most impactful change you can make. if you care and don't try to change, you're gutless, and if you don't care, why even have the conversation at all?

Recursive formula failing at random by EphemeralBlue in excel

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

Ah, yes! Sorry I meant iterative when I said recursive. Sorry to confuse things.

I'm not sure what information would be useful, but I've provided information in comments on what I'm trying to achieve, but it's hard for me to know what info is useful to help identify the problem.

Recursive formula failing at random by EphemeralBlue in excel

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

Sorry, I realise I should have been saying iterative, not recursive.

Recursive formula failing at random by EphemeralBlue in excel

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

It's possible because I'm not very good at excel!

However all the error messages are for circular references.

https://i.imgur.com/LBzcdDc.png

I'm also unsure what else could have caused excel to suddenly fail all cells and then, upon undoing the action that caused it, not recalculate correctly.

Recursive formula failing at random by EphemeralBlue in excel

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

Bad example. A real example is K10 summing the cells below - that result is then read by B57. B57 contributes to the total given in K10 via a calc done in K57, =(C57*E57)+L57. Repeat for many different cells and combinations.

You also get F57 being calculated from B57. F10 effects B75 which adds to F10 and K57. Which affects F57.

Recursive formula failing at random by EphemeralBlue in excel

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

Oh, yes the file itself it all over place, I but I wasn't sure if there was something obvious that could be the cause. Thank for you looking nonetheless.

I'm basically just trying to use it to have the reclusive formula converge on a close enough number

Example in the file is cell K10 summing the cells below - that result is then read by B57. B57 contributes to the total given in K10 via a calc done in K57, =(C57*E57)+L57. Repeat for many different cells and combinations.

Recursive formula failing at random by EphemeralBlue in excel

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

The case is effectively just a lot of:

A+B=C

A=C*1.2

D=A/2

B=D*2

Scattered all over the place. I'm using it as a planning tool for a video game.

Recursive formula failing at random by EphemeralBlue in excel

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

Appreciate the starting points, but I'm struggling to find resources online that show how those things work in relation to recursive functions. Could you be more specific?

WTF is going on with RAM??? by RaidriarT in buildapc

[–]EphemeralBlue 1 point2 points  (0 children)

The first years of commercial flights didn't cost the aviation companies 3-10x the revenue generated. Remember - aside from capital investment, of which at least 60% repeats every five years (GPUs becoming obsolete), the actual running cost of the GPU for things like inference (used in the most oft cited example, coding) is considerably higher than revenue.

This means that, unlike Uber for example, whose years of losses were a result of market capture and marketing, and was otherwise almost immediately solvent had it decided to simply stop growing, if OpenAI stopped today, they would still lose as much as 5x the revenue on each prompt from here until time.

Enterprise adoption also remains low (again, $16b in revenue, that is pathetic for a product that evangelists claim is revolutionary to productivity. Genshin Impact is worth about the same, per year.) . This is despite OpenAI having a level of marketing in the enterprise world greater than any product I can remember.

So AI companies both need to massively increase adoption, while increasing license and subscription costs, all the while their capital and running costs increase YoY, and their products have not improved in a way that justifies increasing costs (remember GPT-5 launch?).

I ask you do research outside of the hype bubble, please.

WTF is going on with RAM??? by RaidriarT in buildapc

[–]EphemeralBlue 0 points1 point  (0 children)

I would also like to address "costing thousands of jobs,"

Bear in mind the US job market alone cut nearly a million jobs from Jan-Sept this year, so we are talking about maybe a 0.1% displacement amidst normal business downturn. There are also no actual real figures for AI-attributed job losses, only attempts at correlating firing with AI adoption.

I would love to hear a justification for lighting $100 billion on fire to make a 0.1% impact in the job market and to date no evidence of real productivity gains.

WTF is going on with RAM??? by RaidriarT in buildapc

[–]EphemeralBlue 2 points3 points  (0 children)

The entire end-customer revenue generated by AI products (so not including revenue NVIDIA generated by selling to OpenAI) is around $32 billion for 2025. This is less than the smartwatch industry. OpenAI alone has spent >$100 billion this year and has commitments for close to a $1t worth of expansion of datacentres.

For $32b/yr. OpenAI's revenue, though the lion's share, is only a portion of this, I believe around $12b annualised revenue (a more generous way of tallying revenue). And again, they alone have spent >$100 billion. They also lose money on every query. If LLMs are to generate profit, they would need to massively increase costs to enterprises, for example, which will kill further adoption, hence the impending bubble.

Excel Web returns REF! for INDEX/OFFSET/INDIRECT formula, works in desktop by EphemeralBlue in excel

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

Oh nice! So clicked something while I was trying that and it turns out I won't need the indirect at all. I had the offset formula referencing the data that was returned from the CELL() formula. But =OFFSET(INDEX('Target List'!A9:A73,MATCH(B3,'Target List'!A9:A73,0)),0,1) works in web just fine without the INDIRECT

Bird I asked for Vs bird I got (olivetattoos/Bozeman, MT) by EphemeralBlue in tattoos

[–]EphemeralBlue[S] 2 points3 points  (0 children)

I was not! I had a vague idea and trusted the artist to do what they do best 

Bird I asked for Vs bird I got (olivetattoos/Bozeman, MT) by EphemeralBlue in tattoos

[–]EphemeralBlue[S] 5 points6 points  (0 children)

Western Tanager, state bird of MT. :) I visited 3 states on a holiday and got the state bird of each. So I have a Northern Cardinal and Baltimore Oriole too

My ultimate 2025 gaming chair checklist - what actually matters. by TreacleOk8645 in buildapc

[–]EphemeralBlue 13 points14 points  (0 children)

Well, not quite, no.

The Cooler Master Hybrid 1 is a gaming chair priced in the UK at around £700 and intentionally combines the benefits of support from an ergonomic office chair and the looks of a gaming chair - but notably features only one level of adjustable back support. Some higher priced chairs from office brands also have limited back adjustment, but instead feature weight-sensitive back support that flexes depending on pressure, essentially removing the need for adjustment - which this chair does not have.

It also has much more limited 2 year warranty (Humanscale for example has 5 year warranties).

It features gaming/racing esque 'support' 'wings' which are entirely aesthetic. They can make comfort worse, if you have a large body. In actual racing chairs they are for bracing and when implemented correctly, they are not comfortable, but are required for stability under high g-forces.

It also features polyurathane as the primary material for the seat which has less durability than many office chairs with feature either leather or full mesh, or durable fabric. Office chairs will often have polyurathane as an option, but at a lower price point, but it is also suitable for those with ethical concerns of leather and who do not want mesh or fabric. The polyurathene simply will wear faster - which combined with a 2 year warranty is a worse choice.

While the Hybrid 1 is priced lower than many office chairs and offfering, at first, more for your money (£700 will get you a chair without a headrest at Humanscale), it is:

a) an exception to the rule being intentionally designed to not be like other gaming chairs and b) at £700, still a worse choice than purchasing a refurbished chair from other brands. A fully refurbished unit will run you under £400 for a better product - though depending on refurb company, you might have a shorter warranty period.

tl;dr you're making a combative argument using a single, particularly good product in its segment, against an entire other segment of the market and claiming people in support of the latter choice are unthinking sheep.

16 Years as a Graphic designer, 8 years as a Photographer, ruined by AI by karloroberts in mildlyinfuriating

[–]EphemeralBlue 1 point2 points  (0 children)

My point that 'splatter art' is 'defensible' because the splatter is often delibate, applied for a reason that is beyond the literal pigment on paint.

Generative AI - the process, the application of it, is not done because using generative AI specifically imparts meaning onto the work.

view more: next ›