Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.
Filter this topic showing only the reply marked as answer View this topic in a long page with up to 500 replies per page Create new topic
1 | ... | 1813 | 1814 | 1815 | 1816 | 1817 | 1818 | 1819 | 1820 | 1821 | 1822 | 1823 | ... | 1828
geoffwnz
1590 posts

Uber Geek

ID Verified

  #3391727 7-Jul-2025 16:43
Send private message quote this post

kingdragonfly:
richms:

 

Finding that someone has entered product codes into an excel sheet with a backslash instead of a forwardslash and their reason was that it was dividing the numbers if they used a forwardslash. FFS these people end up employed.

 



I'm guessing you know, if you format the column cell category as "text" instead of the default "general", Excel will treat any text in cell as text.


 

The "annoy" was about other people from the way I read it. 

 

But I immediately went to Excel to test it.  You can enter "365/256" (without quotes) and it will treat it as text.  In order to divide, you need to type "=365/256" for it to become a formula.

 

The only proviso might be that if you enter a valid date "25/6" then it might auto interpret that as a date and format accordingly.  But generally even those will default to whatever you type unless you have an overriding date format default somehow.

 

So, from what I could gather, the "someone" would have needed to go to some effort to get it to divide the product codes instead of just displaying the text.  (Unless later versions of Excel changed this behaviour, I'm still using Excel 2010).





richms
28176 posts

Uber Geek

Trusted
Lifetime subscriber

  #3391735 7-Jul-2025 17:47
Send private message quote this post

kingdragonfly:

I'm guessing you know, if you format the column cell category as "text" instead of the default "general", Excel will treat any text in cell as text.


 

I know that, and anyone that has a job that uses a computer should know that, which is why I am amazed that these people get themselves into a position who don't know that and put an order into an excel sheet to email thru to us and do things like that.





Richard rich.ms

richms
28176 posts

Uber Geek

Trusted
Lifetime subscriber

  #3391736 7-Jul-2025 17:49
Send private message quote this post

geoffwnz:

 

The "annoy" was about other people from the way I read it. 

 

But I immediately went to Excel to test it.  You can enter "365/256" (without quotes) and it will treat it as text.  In order to divide, you need to type "=365/256" for it to become a formula.

 

The only proviso might be that if you enter a valid date "25/6" then it might auto interpret that as a date and format accordingly.  But generally even those will default to whatever you type unless you have an overriding date format default somehow.

 

So, from what I could gather, the "someone" would have needed to go to some effort to get it to divide the product codes instead of just displaying the text.  (Unless later versions of Excel changed this behaviour, I'm still using Excel 2010).

 

 

That's why they told me they did it. I have always just put the quote in to stop it interpreting things and also I don't generally use excel as a shopping list.





Richard rich.ms

Handsomedan
7293 posts

Uber Geek

ID Verified
Trusted
Subscriber

  #3391795 8-Jul-2025 09:03
Send private message quote this post

People on the internet and their inability to look beyond their own bias and dislike of "the elites". 

 

Takapuna Golf Course is one of only two public golf courses in Auckland. The other being Chamberlain Park. 

 

Auckland Council plans to either completely get rid of it and turn it into a wetland, or reduce it to 9 holes, with a proposed wetland on the other half. 

 

This is to mitigate the increasing flooding along the nearby Wairau Stream and surrounding area. 

 

What annoys me is twofold:

One - the lack of infrastructure to support the continued housing intensification in Auckland - a problem that is partially to blame for the increase in flooding (replacing one home on a large grass section with 4-6 homes on a near-fully concreted section reduces permeable land, increases the burden on drainage and sewage  - most of the single dwellings were 1 bathroom/WC, being replaced by multiple dwellings with at least 2 bathrooms/WC's - often in a flood-prone area). 

Two - the commenters and armchair experts who say that golf courses should all go, as golf is only for the elites and the rich and it's a stupid sport and nobody wants golf courses anyway. Then they say there are multiple council owned courses that people can go to instead, if the plan goes ahead. 

There are ONLY TWO public golf courses in Auckland - a city of nearly two million people. They are the only places that the general public can get a round of golf in, without having to either be a member of a private golf club (very expensive and often very exclusive) or pay exorbitant green fees at said private courses. 

If you mention this, the argument is that there are 18+ council owned golf courses in Auckland. I'm not sure how accurate that is, but the fact still remains...there are only two that are open to the pblic. The rest are potentially council owned land, privately leased and with memberships and expensive green fees. These are not easily accessed by the casual golfer. The other agrument is that golf is stupid and people should all get behind the All Blacks/Warriors/MMA or some other bollocks. 

 

 

 

I don't play golf myself - I don't have the patience, but I have played casually in the past and my dad used to play - my eldest son and his friends play occasionally, too. But none of us are "millionaires" or "elites". It's a ridiculous way to label golfers. 
Both of the public courses are jam-packed with ordinary people playing rounds of golf all week and weekend. 

Golf can be a fantastic way to ruin a day, but it's also an amazing outlet for mental health and physical well being, despite the fact that it's low impact and takes up a lot of land. 

And that is the end of my sermon. 







Handsome Dan Has Spoken.
Handsome Dan needs to stop adding three dots to every sentence...

 

Handsome Dan does not currently have a side hustle as the mascot for Yale 

 

 

 

*Gladly accepting donations...


Rikkitic
Awrrr
18660 posts

Uber Geek

Lifetime subscriber

  #3391799 8-Jul-2025 10:04
Send private message quote this post

I don't play golf and I am not a fan of any sports but disparaging someone because they enjoy something you don't value is petty, arrogant and mean. There needs to be space for everyone. Why can't private golf courses be made to offer public days or hours as a way of sharing a limited resource? 

 

 

 

 





Plesse igmore amd axxept applogies in adbance fir anu typos

 


 


geek3001
64 posts

Master Geek

ID Verified
Subscriber

  #3391802 8-Jul-2025 10:23
Send private message quote this post

richms:

 

Finding that someone has entered product codes into an excel sheet with a backslash instead of a forwardslash and their reason was that it was dividing the numbers if they used a forwardslash. FFS these people end up employed.

 

 

Shall I mention the time I had an exec using Excel as a word processor and they called for assistance because they could not get the text to look the way they wanted. It was truly a dog's breakfast. Showed them Word and they didn't like the interface and insisted on continuing to use Excel and made it my job to make it easier for them to use. Um... no, please use the correct tool provided on your computer for the task you are doing, that's what it's there for, training options are available if you need them.

 

Another time, a marketing manager was trying to finish their monthly report which was already late. They had used Word and had a complex table of sales figures on one page. After-hours weekend panic call for help, "my table has gone all wonky, heeeeelp!!". Found they had drawn table lines using the Draw functionality in Word instead of the table functionality, and used a mixture of tabs and spaces to format the numbers between the lines they had drawn. Explained the correct functionality, they weren't interested, and wanted me to sort it out. Said sorry, I'm already late to be elsewhere, I'm leaving (was late Saturday afternoon).

 

Very annoying.

 

 


  #3391804 8-Jul-2025 10:30
Send private message quote this post

I've played golf since I was 8 (now 50). I'm neither rich nor elite. I started playing wth my father who was a builder. He would knock off early on a Friday and pick me up after school and we'd go to the local public course for 9 holes. Some of my best childhood memories were Firday afternoon golf with Dad and his tradie mates after school. At first I would just caddie for him, but as soon as we got out of sight of the clubhouse he would give me wedge and I would just chop it up down the side of the fairway away from the real golfers. He bought me my first set when I was 13, it was only a half set and 2nd hand. I think they cost him a carton of beer from one of his mates.

 

Some people think that's elite?


Handsomedan
7293 posts

Uber Geek

ID Verified
Trusted
Subscriber

  #3391806 8-Jul-2025 10:58
Send private message quote this post

Senecio:

 

I've played golf since I was 8 (now 50). I'm neither rich nor elite. I started playing wth my father who was a builder. He would knock off early on a Friday and pick me up after school and we'd go to the local public course for 9 holes. Some of my best childhood memories were Firday afternoon golf with Dad and his tradie mates after school. At first I would just caddie for him, but as soon as we got out of sight of the clubhouse he would give me wedge and I would just chop it up down the side of the fairway away from the real golfers. He bought me my first set when I was 13, it was only a half set and 2nd hand. I think they cost him a carton of beer from one of his mates.

 

Some people think that's elite?

 

 

Yes...we (as an elite and incredibly wealthy family) have the "family clubs" - I bought a set from a garage sale as I thought they looked nice (must have been 20 years ago). I then inherited some woods from my dad - actual wood, too! I won a driver at a corporate golf day, which was probably pretty special back in the day, but I am told it's worth about $11 now. Those are the clubs my son uses as an elitist and wealthy young golfer. 

I have fond memories of waiting with the other kids in the Wainuiomata golf club carpark in the 1970's for dad to play a round of golf. We were too loud and full of energy to caddy back then. 
I later tried to learn how to play, so I could enjoy it with him...I simply didn't have the patience or grace - although apparently I did have the skill. I couldn't do more than 5 holes before losing the plot. 

 

I just don't understand the whole "golf is elitist" thing. It's not America, or Korea. It's NZ - public courses are a thing here. And they're relatively cheap to play at. 

 

 





Handsome Dan Has Spoken.
Handsome Dan needs to stop adding three dots to every sentence...

 

Handsome Dan does not currently have a side hustle as the mascot for Yale 

 

 

 

*Gladly accepting donations...


elpenguino
3423 posts

Uber Geek


  #3391807 8-Jul-2025 11:02
Send private message quote this post

If we set aside the elitist thing for now, if you had to decide - would you pick flooding or golf ?





Most of the posters in this thread are just like chimpanzees on MDMA, full of feelings of bonhomie, joy, and optimism. Fred99 8/4/21


richms
28176 posts

Uber Geek

Trusted
Lifetime subscriber

  #3391808 8-Jul-2025 11:05
Send private message quote this post

elpenguino:

 

If we set aside the elitist thing for now, if you had to decide - would you pick flooding or golf ?

 

 

I would pick not building in a known flood plain. Red sticker the whole valley.





Richard rich.ms

  #3391809 8-Jul-2025 11:08
Send private message quote this post

elpenguino:

 

If we set aside the elitist thing for now, if you had to decide - would you pick flooding or golf ?

 

 

A well designed golf course can provide for both. If that means reducing it to 9 holes then that's better than losing the facility altogether. 


Handsomedan
7293 posts

Uber Geek

ID Verified
Trusted
Subscriber

  #3391839 8-Jul-2025 11:43
Send private message quote this post

Senecio:

 

elpenguino:

 

If we set aside the elitist thing for now, if you had to decide - would you pick flooding or golf ?

 

 

A well designed golf course can provide for both. If that means reducing it to 9 holes then that's better than losing the facility altogether. 

 

 

A mix of this and not building in a flood plain, along with providing the correct infrastructure BEFORE building high density housing in areas that have been designed for low density. 





Handsome Dan Has Spoken.
Handsome Dan needs to stop adding three dots to every sentence...

 

Handsome Dan does not currently have a side hustle as the mascot for Yale 

 

 

 

*Gladly accepting donations...


mudguard
2119 posts

Uber Geek


  #3391903 8-Jul-2025 14:55
Send private message quote this post

Senecio:

 

elpenguino:

 

If we set aside the elitist thing for now, if you had to decide - would you pick flooding or golf ?

 

 

A well designed golf course can provide for both. If that means reducing it to 9 holes then that's better than losing the facility altogether. 

 

 

 

 

To be fair, going to nine holes is like your local pub only serving low strength beer. 

 

I am fortunate enough to be a member of two courses and I struggle to emphasis how much of a gut punch this is to those golfers who don't/can't spend four figures annually for a subscription.

 

Takapuna and Chamberlain is the equivalent of a Toyota dealership surrounded by Italian and German car manufacturers. And we are getting rid of Toyota. 

 

 

 

Furthermore, golf will always be a elite in a way, in New Zealand for the most part it's really quite cheap compared to other countries. But it will never be as accessible as say basketball or soccer etc where the equipment pricing and course/court maintenance is much, much lower. 


johno1234
2805 posts

Uber Geek


  #3391956 8-Jul-2025 15:14
Send private message quote this post

Handsomedan:

 

People on the internet and their inability to look beyond their own bias and dislike of "the elites". 

 

Takapuna Golf Course is one of only two public golf courses in Auckland. The other being Chamberlain Park. 

 

Auckland Council plans to either completely get rid of it and turn it into a wetland, or reduce it to 9 holes, with a proposed wetland on the other half. 

 

This is to mitigate the increasing flooding along the nearby Wairau Stream and surrounding area. 

 

What annoys me is twofold:

One - the lack of infrastructure to support the continued housing intensification in Auckland - a problem that is partially to blame for the increase in flooding (replacing one home on a large grass section with 4-6 homes on a near-fully concreted section reduces permeable land, increases the burden on drainage and sewage  - most of the single dwellings were 1 bathroom/WC, being replaced by multiple dwellings with at least 2 bathrooms/WC's - often in a flood-prone area). 

Two - the commenters and armchair experts who say that golf courses should all go, as golf is only for the elites and the rich and it's a stupid sport and nobody wants golf courses anyway. Then they say there are multiple council owned courses that people can go to instead, if the plan goes ahead. 

There are ONLY TWO public golf courses in Auckland - a city of nearly two million people. They are the only places that the general public can get a round of golf in, without having to either be a member of a private golf club (very expensive and often very exclusive) or pay exorbitant green fees at said private courses. 

If you mention this, the argument is that there are 18+ council owned golf courses in Auckland. I'm not sure how accurate that is, but the fact still remains...there are only two that are open to the pblic. The rest are potentially council owned land, privately leased and with memberships and expensive green fees. These are not easily accessed by the casual golfer. The other agrument is that golf is stupid and people should all get behind the All Blacks/Warriors/MMA or some other bollocks. 

 

 

 

I don't play golf myself - I don't have the patience, but I have played casually in the past and my dad used to play - my eldest son and his friends play occasionally, too. But none of us are "millionaires" or "elites". It's a ridiculous way to label golfers. 
Both of the public courses are jam-packed with ordinary people playing rounds of golf all week and weekend. 

Golf can be a fantastic way to ruin a day, but it's also an amazing outlet for mental health and physical well being, despite the fact that it's low impact and takes up a lot of land. 

And that is the end of my sermon. 


 

Golf at Takapuna and Chamberlain Park is in no way elite as anyone who goes play there will soon see.  Anyone can play there and it is not too expensive. It means that people from all walks of life can try golf. When those two are gone, then golf will be elite - at least within Auckland.

 

 


johno1234
2805 posts

Uber Geek


  #3391961 8-Jul-2025 15:19
Send private message quote this post

Rikkitic:

 

I don't play golf and I am not a fan of any sports but disparaging someone because they enjoy something you don't value is petty, arrogant and mean. There needs to be space for everyone. Why can't private golf courses be made to offer public days or hours as a way of sharing a limited resource? 

 

 

Well, compelling private groups to do anything with their own property runs the wrong way for me. Owning and operating a golf course is quite expensive. Many of the club members find it quite difficult these days to afford membership. Having to miss out on using the facility because they are compelled to let others use it for free would be unfair.

 

Now it might be different in cases where the land is owned by the city but the public courses such as Takapuna are already at rock bottom prices for the public to use.

 

 


1 | ... | 1813 | 1814 | 1815 | 1816 | 1817 | 1818 | 1819 | 1820 | 1821 | 1822 | 1823 | ... | 1828
Filter this topic showing only the reply marked as answer View this topic in a long page with up to 500 replies per page Create new topic



News and reviews »

Air New Zealand Starts AI adoption with OpenAI
Posted 24-Jul-2025 16:00


eero Pro 7 Review
Posted 23-Jul-2025 12:07


BeeStation Plus Review
Posted 21-Jul-2025 14:21


eero Unveils New Wi-Fi 7 Products in New Zealand
Posted 21-Jul-2025 00:01


WiZ Introduces HDMI Sync Box and other Light Devices
Posted 20-Jul-2025 17:32


RedShield Enhances DDoS and Bot Attack Protection
Posted 20-Jul-2025 17:26


Seagate Ships 30TB Drives
Posted 17-Jul-2025 11:24


Oclean AirPump A10 Water Flosser Review
Posted 13-Jul-2025 11:05


Samsung Galaxy Z Fold7: Raising the Bar for Smartphones
Posted 10-Jul-2025 02:01


Samsung Galaxy Z Flip7 Brings New Edge-To-Edge FlexWindow
Posted 10-Jul-2025 02:01


Epson Launches New AM-C550Z WorkForce Enterprise printer
Posted 9-Jul-2025 18:22


Samsung Releases Smart Monitor M9
Posted 9-Jul-2025 17:46


Nearly Half of Older Kiwis Still Write their Passwords on Paper
Posted 9-Jul-2025 08:42


D-Link 4G+ Cat6 Wi-Fi 6 DWR-933M Mobile Hotspot Review
Posted 1-Jul-2025 11:34


Oppo A5 Series Launches With New Levels of Durability
Posted 30-Jun-2025 10:15



Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.