Welcome to the ICM Forum. If you have an account but have trouble logging in, or have other questions, see THIS THREAD.
NOTE: Board emails should be working again. Information on forum upgrade and style issues.
Podcast: Talking Images (Episode 22 released November 17th * EXCLUSIVE * We Are Mentioned in a Book!!! Interview with Mary Guillermin on Rapture, JG & More)
Polls: Coming of Age (Results), DtC - Ratings (Results), 1933 (May 12th), 1970s (May 29th)
Challenges: Japan, Mystery/Thriller, Western
Film of the Week: La donna del lago, June nominations (May 28th)

Technical Support

Post Reply
User avatar
Tim2460
Posts: 6126
Joined: October 1st, 2018, 7:23 pm
Location: Dijon, France
Contact:

#1841

Post by Tim2460 »

That excel chick is captivating (l)
User avatar
joachimt
Donator
Posts: 33903
Joined: February 16th, 2012, 7:00 am
Location: Netherlands
Contact:

#1842

Post by joachimt »

Tim2460 wrote: March 30th, 2021, 7:56 am That excel chick is captivating (l)
I was talking about the formulas. ;)
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"
User avatar
maxwelldeux
Donator
Posts: 8991
Joined: June 7th, 2016, 6:00 am
Location: Seattle-ish, WA, USA
Contact:

#1843

Post by maxwelldeux »

joachimt wrote: March 30th, 2021, 8:09 am
Tim2460 wrote: March 30th, 2021, 7:56 am That excel chick is captivating (l)
I was talking about the formulas. ;)
I've used a few of those before. I'm by no means an expert, but they seriously come in handy at certain spots.
User avatar
joachimt
Donator
Posts: 33903
Joined: February 16th, 2012, 7:00 am
Location: Netherlands
Contact:

#1844

Post by joachimt »

maxwelldeux wrote: March 30th, 2021, 9:33 pm
joachimt wrote: March 30th, 2021, 8:09 am
Tim2460 wrote: March 30th, 2021, 7:56 am That excel chick is captivating (l)
I was talking about the formulas. ;)
I've used a few of those before. I'm by no means an expert, but they seriously come in handy at certain spots.
It's not just the new formulas. It's like she said, it changes the way you handle regular formulas in large expanding datasets. I'm certainly going to update some of my spreadsheets according to this. No need to copy down a formula again if you want to change something. Just change it at the top and the whole spill follows the update.
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"
User avatar
monk-time
Posts: 1425
Joined: March 23rd, 2015, 6:00 am
Contact:

#1845

Post by monk-time »

joachimt wrote: March 31st, 2021, 10:40 am It's not just the new formulas. It's like she said, it changes the way you handle regular formulas in large expanding datasets. I'm certainly going to update some of my spreadsheets according to this. No need to copy down a formula again if you want to change something. Just change it at the top and the whole spill follows the update.
If you liked that, wait till you see what LAMBDAs can do. ;)
User avatar
kongs_speech
Posts: 1492
Joined: April 4th, 2020, 10:32 pm
Location: FL
Contact:

#1846

Post by kongs_speech »

monk-time wrote: March 31st, 2021, 2:01 pm
joachimt wrote: March 31st, 2021, 10:40 am It's not just the new formulas. It's like she said, it changes the way you handle regular formulas in large expanding datasets. I'm certainly going to update some of my spreadsheets according to this. No need to copy down a formula again if you want to change something. Just change it at the top and the whole spill follows the update.
If you liked that, wait till you see what LAMBDAs can do. ;)
What's this about Lammetje?
🏳️‍⚧️
Quartoxuma wrote: A deeply human, life-affirming disgusting check whore.
Image
User avatar
joachimt
Donator
Posts: 33903
Joined: February 16th, 2012, 7:00 am
Location: Netherlands
Contact:

#1847

Post by joachimt »

monk-time wrote: March 31st, 2021, 2:01 pm
joachimt wrote: March 31st, 2021, 10:40 am It's not just the new formulas. It's like she said, it changes the way you handle regular formulas in large expanding datasets. I'm certainly going to update some of my spreadsheets according to this. No need to copy down a formula again if you want to change something. Just change it at the top and the whole spill follows the update.
If you liked that, wait till you see what LAMBDAs can do. ;)
I noticed some clips about that as well. Was planning to look into it. Thanks for the push!
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"
User avatar
xianjiro
Donator
Posts: 9429
Joined: June 17th, 2015, 6:00 am
Location: Kakistani Left Coast
Contact:

#1848

Post by xianjiro »

joachimt wrote: March 31st, 2021, 10:40 am
maxwelldeux wrote: March 30th, 2021, 9:33 pm
joachimt wrote: March 30th, 2021, 8:09 am
I was talking about the formulas. ;)
I've used a few of those before. I'm by no means an expert, but they seriously come in handy at certain spots.
It's not just the new formulas. It's like she said, it changes the way you handle regular formulas in large expanding datasets. I'm certainly going to update some of my spreadsheets according to this. No need to copy down a formula again if you want to change something. Just change it at the top and the whole spill follows the update.
you're starting to make me curious - I'm. just. scared. 😩 I still haven't gotten my brain around pivot tables.
User avatar
joachimt
Donator
Posts: 33903
Joined: February 16th, 2012, 7:00 am
Location: Netherlands
Contact:

#1849

Post by joachimt »

xianjiro wrote: March 31st, 2021, 7:56 pm
joachimt wrote: March 31st, 2021, 10:40 am
maxwelldeux wrote: March 30th, 2021, 9:33 pm
I've used a few of those before. I'm by no means an expert, but they seriously come in handy at certain spots.
It's not just the new formulas. It's like she said, it changes the way you handle regular formulas in large expanding datasets. I'm certainly going to update some of my spreadsheets according to this. No need to copy down a formula again if you want to change something. Just change it at the top and the whole spill follows the update.
you're starting to make me curious - I'm. just. scared. 😩 I still haven't gotten my brain around pivot tables.


She's pretty good. I just subscribed to her channel.

But I get what you mean. I always struggle with pivot tables as well.
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"
User avatar
xianjiro
Donator
Posts: 9429
Joined: June 17th, 2015, 6:00 am
Location: Kakistani Left Coast
Contact:

#1850

Post by xianjiro »

okay, I'll check her vids out in a day or two - today's not right and my minds not in the right space for such LOL
User avatar
Tim2460
Posts: 6126
Joined: October 1st, 2018, 7:23 pm
Location: Dijon, France
Contact:

#1851

Post by Tim2460 »

Much better than me in excel an wayyy better make up.... :wub:

I wasn't really sold on the Pivot Table concept but PA use one on his spreadsheet and i must says it's easier that way than my method ...
User avatar
joachimt
Donator
Posts: 33903
Joined: February 16th, 2012, 7:00 am
Location: Netherlands
Contact:

#1852

Post by joachimt »

monk-time wrote: March 31st, 2021, 2:01 pm
joachimt wrote: March 31st, 2021, 10:40 am It's not just the new formulas. It's like she said, it changes the way you handle regular formulas in large expanding datasets. I'm certainly going to update some of my spreadsheets according to this. No need to copy down a formula again if you want to change something. Just change it at the top and the whole spill follows the update.
If you liked that, wait till you see what LAMBDAs can do. ;)
A shame that function isn't available to me yet. :(
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"
User avatar
joachimt
Donator
Posts: 33903
Joined: February 16th, 2012, 7:00 am
Location: Netherlands
Contact:

#1853

Post by joachimt »

I bought VR glasses this week, the kind in which you put your smartphone to watch VR movies. I'm using the Youtube-app on my iPhone. I have one issue. After I start the VR glass mode, and I want to use the controls (pause, select a different time, etc...), the only way I found to open those options is tapping my screen. But my phone is inside the VR glasses, so I have to open the VR glasses to tap the screen, but controlling it is done by the movement of my head. It doesn't make sense at all. I've connected my headphone, so I expected the middle button of the (wired) earpods to open up the controls, but that's pause (or next clip with double click). I then expected the controls would open with a certain gesture like facing down or sideways, but nothing worked. I've searched for the problem on the internet, but couldn't find any info about it, but also hardly any complaints.

Anyone?
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"
User avatar
weirdboy
Donator
Posts: 4066
Joined: January 3rd, 2016, 7:00 am
Contact:

#1854

Post by weirdboy »

They make controllers you can connect to the phone via bluetooth.


My previous smart phone came with one of those fancy VR headset cases which I tried a few times, but:

1. VR mode ran the battery on the phone down surprisingly fast
2. The phone had a strong tendency to overheat inside that headset


I hope yours is working better than mine did, but I think the next time I get VR stuff it will be dedicated equipment, and definitely will avoid the oculus even though I like their technology.
My first VR goggles were way back in mid 90's, which were awesome when playing Descent but basically only a few games worked with them.
User avatar
xianjiro
Donator
Posts: 9429
Joined: June 17th, 2015, 6:00 am
Location: Kakistani Left Coast
Contact:

#1855

Post by xianjiro »

I was wondering tonight just how many people on here have tried VR. Can't say I'm all that excited yet.
User avatar
Tim2460
Posts: 6126
Joined: October 1st, 2018, 7:23 pm
Location: Dijon, France
Contact:

#1856

Post by Tim2460 »

For me Google Earth and the Alyx Game were my first love at first sight in VR...

The rest of it isn't that good.

Yet to see anything else really interesting.
User avatar
joachimt
Donator
Posts: 33903
Joined: February 16th, 2012, 7:00 am
Location: Netherlands
Contact:

#1857

Post by joachimt »

weirdboy wrote: May 10th, 2021, 3:04 am They make controllers you can connect to the phone via bluetooth.
Ah well, I don't think I'll bother with that. It's not like I'm going to use it a lot. It's just fun for one or two short clips. My kids enjoy it and since all amusementparks, zoos etc... are still closed, it's just a fun way to "get out". It's just weird something big as a Youtube-app hadn't figured out yet to let it work with an earpod button or a movement.
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"
User avatar
Tim2460
Posts: 6126
Joined: October 1st, 2018, 7:23 pm
Location: Dijon, France
Contact:

#1858

Post by Tim2460 »

Don't know if google earth is VR on the phone versions ... I guess not
User avatar
maxwelldeux
Donator
Posts: 8991
Joined: June 7th, 2016, 6:00 am
Location: Seattle-ish, WA, USA
Contact:

#1859

Post by maxwelldeux »

I dabbled in VR a bit on the phone, mostly for "adult" purposes. It's a neat novelty, but not really worth the effort. Like joachimt said, the UX is super clunky on the phone, and it really only works decently with either a bluetooth VR controller or an integrated headset.

The non-porn stuff had potential. I did a couple roller coasters, which were an awesome experience, but under-developed. A skilled filmmaker going hard at that tech could create an amazing and immersive experience, but it's just not there yet, IMHO.
Post Reply