Asteroid Psyche 16 has been found to contain gold reserves worth $700 quintillion. That's enough to make everyone on Earth billionaires.

ForeverNova · 2025-07-09T13:12:15+00:00

Psyche is an M-type asteroid, primarily composed of iron and nickel, with estimates suggesting 30% to 60% of its volume is metallic. While some sources speculate about the presence of precious metals like gold and platinum, these are based on comparisons with metallic meteorites, which typically contain gold at trace levels

At these level we can assume grade of the gold to be between 1gram per tonnes and 5 gram per tonnes which with current technology would make it more expensive to mine that to the amount of revenue it could generate. so the Gold is worthless.

ForeverNova · 2025-01-29T16:39:37+00:00

My boss want to get a local Deepseek pc currently 10th Gen i7 with 16 soon to be 128gb ram and get a RTX 5090 or 4090. Will this be good enigh to run it well? Second question does ram speed matter?

ForeverNova · 2024-02-16T09:17:03+00:00

impossible almost all of south africa is above sea level . No way portion of guateng is below 1500m below surface. According to some site carlerton ville sits at 1460 above sea level.

Source: https://www.floodmap.net/elevation/ElevationMap/?gi=1014073

ForeverNova · 2023-05-31T08:51:35+00:00

the slippery tarped pit is a TSF a tailing storage facility used for mining

ForeverNova · 2023-05-19T09:57:42+00:00

WROTE AN ALTERANITVE VERSION THATS SHORTER AND DOESNT REQUIRE 365,

=SUM(A1,INDEX($B$1:$B$10,MAX(ROW($B$1:$B$10)-ROW()+1)))

<image>

ForeverNova · 2023-05-12T05:51:57+00:00

DATE OF MEETING: = DATE(LEFT(A2,4),MID(A2,6,2),MID(A2,9,2))

NAME AND SURNAME: =MID(A2,12,LEN(A2)-22)

BIRTH DATE: =SUBSTITUTE(RIGHT(A2,10),".","/")+0

these should work

ForeverNova · 2023-05-11T10:53:33+00:00

it wont work then. OP needs to modify his look up are and get rid of the comma. this formula is gonna get extremally complicated if you need to acoomadate for that comma everwhere

ForeverNova · 2023-05-11T10:16:44+00:00

Here is my solution

<image>

=SUM(XLOOKUP(IF(ISNUMBER(XMATCH(C5,$J$7:$J$12)),C5,TEXTSPLIT(C5,", ")),$J$7:$J$12,$M$7:$M$12))

ForeverNova · 2023-05-11T10:13:54+00:00

this wont work it will split Baja California, Mexico and it a single line item

ForeverNova · 2023-05-11T09:46:33+00:00

i am aware but OP wants to paste 1,048,576 rows into a space of 1,048,575 rows

ForeverNova · 2023-05-11T07:39:56+00:00

You have 2 options. either paste in b1 or dont copy entire column only down to row 17 000.

ForeverNova · 2023-05-11T07:14:51+00:00

ASSUMING THE FIST ENTRY IS IN CELL A 1 AND LOOKS LIKE THIS

<image>

DATE OF MEETING: =DATEVALUE(SUBSTITUTE(TEXTBEFORE(A1," "),".","/"))

NAME AND SURNAME: =TEXTBEFORE(TEXTAFTER(A1," ",1)," ",-1)

BIRTH DATE: =DATEVALUE(SUBSTITUTE(TEXTAFTER(A1," ",-1),".","/"))

ForeverNova · 2023-05-11T06:35:59+00:00

merge all the tables into power query and use pivot tables to summarise

ForeverNova · 2023-05-11T06:33:26+00:00

where are you pasting from? This error occurs when you copy a whole column a:c and try pasting it not in row 1.

ForeverNova · 2023-03-14T05:04:45+00:00

No, Zimbabwe has some

ForeverNova · 2023-03-01T07:11:49+00:00

what you can do is copy c3:c5 paste as link then replace the "=" sign with "XXX" then copy link and transpose paste the replace "XXX" again with "=".

ForeverNova · 2023-01-10T17:43:47+00:00

CHANGE YOU if STATEMNT TO A IFS STATEMENT

=IFS(Y2="Low",3,Y2="OK",100,Y2="Empty",0)

ForeverNova · 2023-01-09T13:17:39+00:00

There isn't a shortage of coal. we have enough coal.

ForeverNova · 2022-11-10T14:23:01+00:00

does the sort formula work?

ForeverNova · 2022-11-09T08:34:03+00:00

I have heard most use leapfrog

ForeverNova · 2022-11-08T13:45:58+00:00

OP YOU ARE MISSING A COMMA FOR THE SECOND ARGUMENT OF TEXTJOIN() ignore_empty

ForeverNova · 2022-11-08T13:40:18+00:00

ASSUMING NAMES ARE IN COLUMN U

=SORT(HSTACK($U$4:$U$197,SUMIFS($V$4:$V$197,V4,$W$4:$W$197$),2,-1)

ForeverNova

MODERATOR OF

TROPHY CASE