The Chat/Spam Thread

[anon]

Excel? What is that. Some new virus?

You missed the opportunity to say "yes, I excel at it" Anyway, I don't... but these guys do.

https://www.excelforum.com/

[cirulilu]

@yoco
if you tell us what you need help with we might be able to get crack at it.

need help with some formula?

[yoco]

@yoco
if you tell us what you need help with we might be able to get crack at it.

need help with some formula?

I made an invoice. I would like when I click on clients "drop down" list it would also show clients full address in cell bellow. Now I only know how to make it show client name. I made "clients" list on another sheet. I hope I made some sense in explaining this :)

[yoco]

I made an invoice. I would like when I click on clients "drop down" list it would also show clients full address in cell bellow. Now I only know how to make it show client name. I made "clients" list on another sheet. I hope I made some sense in explaining this :)

I managed to do it

[cirulilu]

Well I told you we can work it out

next time don't be afraid to ask.

[yoco]

Well I told you we can work it out

next time don't be afraid to ask.

If only I had this perseverance in my life when it comes to other stuff

[cirulilu]

Spam, sausage, Spam, Spam, Spam, bacon, Spam, tomato and Spam
Spam, Spam, Spam, Spam, Spam, Spam, baked beans, Spam, Spam, Spam and Spam

[anon]

I made an invoice. I would like when I click on clients "drop down" list it would also show clients full address in cell bellow. Now I only know how to make it show client name. I made "clients" list on another sheet. I hope I made some sense in explaining this :)

I managed to do it

Nice! The usual method is indeed doing a drop-down that gets its data from columns in a different sheet. A pivot table will also work and will let you match one to many (single customer with multiple addresses) or do reverse searches (all customers in -city-), but is overkill for this, and also only compatible with MS Excel 2010 and above.

[anon]

Update 6!

Status report: Service finished, data recovered, verification recommended

Technician's notes: After the recovery attempt we were able to access 90% of your disk through a cloning procedure. During the sector-by-sector scanning process it was possible to rebuild the structure of files and directories, encountering partial damage. Random verification of images, videos and documents revealed a damage rate of around 8%. In total, 1.77 TB of data was recovered. We recommend verifying this data online via Remote Desktop.

Laboratory analysis: Technicians have informed us the data recovery service was successful, nonetheless we require you to verify the data remotely before proceeding to obtain a copy. You may install any programs required for this task in the computer we've put at your disposal. Download the TeamViewer software from its official site www.teamviewer.com and request your access credentials.

I have just seen this and requested the TeamViewer password, but it's fairly late here so I'll have to wait until tomorrow morning. They did give me a directory listing, and the most important stuff was there. The "diagnosis" is very positive, but let's see what happens after I check the SHA-1 hashes.

[anon]

Update 7. Did TeamViewer, ran checksums. Most of the non-recoverable data was music, games and old software... easily reobtainable given enough time and effort. I'll make the payment next Monday and should finally get everything back a few days later.

Of course, even after all is said and done, there's still the fact I no longer have my 4 TB disk (and those are extremely expensive now), or anything else close to that capacity. But well, a sorting and cleanup was long overdue. My ultimate goal is to make everything fit in 500 GB or less. May have to cheat a bit here and there to make it, but I'm sure 1 TB at least is definitely possible with zero compromises.

[Sazzy]

Wasnt actually expecting it, glad you got your stuff back! that's pretty damn amazing to be honest.

[anon]

Wasnt actually expecting it

I appreciate the optimism.

Let this also be a lesson to you all... there's only two kinds of data: the one you have good backups (plural) of, and the one you effectively don't mind losing. I "knew" this before, but now I know it.

[slikrapid]

there's only two kinds of data: the one you have good backups (plural) of, and the one you effectively don't mind losing. I "knew" this before, but now I know it.

in a spiritual sense, there are also only two kinds of data:

- spiritually useful - data which speaks of the nature of reality, purpose/meaning of life, God, relationship between Him and other living beings and the like - this kind of data is divinely revealed and eternally useful, regardless of whether you were born in a small village thousands of years ago or in a megalopolis full of modern technological gadgets - ancient, current and future people have the same kind of fundamental problems which are solved with this data - the application of this data in a human society ensures a healthy lifestyle, peaceful and harmonious co-existence with nature and other living beings, where spiritual advancement is the central goal of every individual - this data is being guarded, maintained and distributed by trustworthy world religions throughout ages and may be termed 'spiritual science'

- spiritually useless - ~99.9% of the data that we use or backup - if this is lost, it is certainly annoying and costly but not particularly important in the greater scheme of things - this means backups may be done, but no need to obsess about them - in our current societies there is an over-reliance on this kind of data, which is proving to be detrimental to human health, the environment and the health of other living beings, where material advancement (sense gratification) is the central goal of practically every individual - this happens when the so-called 'material science' (based on fallible human research, consisting of assumptions and theories, bottom-up approach) takes over the primary role of shaping human societies, whereas it ought to be secondary, in line with the aforementioned 'spiritual science' (based on divine revelation, consisting of certainties, top-down approach)

[anon]

Well, as of some hours ago, I have a new entry in my problem list: a pipe in my water heater snapped, flooding the entire kitchen. I was able to cut off the water flow after having a free shower... took me two hours to dry and clean the whole mess. Currently getting by until I can find a plumber tomorrow.

[Sazzy]

Holy crap, when will this bad luck end?
I guess you're lucky to have been home at the time to react to it. And that it snapped in a place you noticed. But still, damn man! Sorry to hear that :( Water issues especially are awful. Hope you're keeping warm.