The totally off-topic thread

[Deleted User]

It was testing time tonight.
Qwibble rebate site plus an RAC sourced 5% off Wish Card from Woolies to see if I can get a combined 14.6% off the Dan Murphy's champagne special in a 6 carton with free delivery.
I paid an ATO bill on the US Citi Visa to get AA points at 0.42cents per point seeing the last one exchanged at .9345 I will book the funds replacement tomorrow to recycle the funds.
Don't assume these two thought bubbles will work but I would never, never know if I didn't give it a go. If it all goes pear shaped the Billecart will be the medicine.

Cove, please let me know ;-)

 

[anat0l]

My boss quite often emails me with a spreadsheet and asks me to insert or change a formula to alter prices or fx rates by x% or whatever. To be honest, I despise the fact that someone can put numbers into a spreadsheet (and it looks the same) and then send it to the boss and get credited for doing the same thing. The problem (my problem admittedly) is that, the boss doesn't know the difference. What takes me 5 minutes to do, someone has spent 3 hours doing.

Only other thing to consider is that the formulae may have been "executed" on another sheet, with the results then copied and pasted as values only, leaving the formulae behind. This is useful if someone is copying and pasting it later, as sometimes if they do it wrong, they may end up copying garbage. This is especially true if they are copying the given values into another Excel spreadsheet.

 

[docjames]

Wow, 830pm on a monday and Victoria St (Melbourne) has a particularly unpleasant "vibe"......

 

[Deleted User]

I often send excel sheets with only "dumb data" and no calculations included (paste values only)

Some quotation documents these days are done on excel sheets provided by the client / customer... I don't want them to see any calculations (margins etc) that have been applied, hence I don't provide sheets with calculations or "smart data"

 

[whatmeworry]

My boss quite often emails me with a spreadsheet and asks me to insert or change a formula to alter prices or fx rates by x% or whatever. To be honest, I despise the fact that someone can put numbers into a spreadsheet (and it looks the same) and then send it to the boss and get credited for doing the same thing. The problem (my problem admittedly) is that, the boss doesn't know the difference. What takes me 5 minutes to do, someone has spent 3 hours doing.

What I often have to remind myself of is that, when I'm upset by things at work, it often signifies that there is no drama happening at home. This is a good thing!

Lock the spreadsheet and send it directly to your overboss if you are 100% you are correct.

 

[JohnK]

The right half of the brain controls the left half of the body. This means that only left handed people are in their right mind.

Which explains why this world is a mess....

 

[straitman]

Can't have been a nice experience No Cookies | The Courier-Mail

[h=1]A CATHAY Pacific flight from New York to Hong Kong was stranded for more than 16 hours in a Chinese city with all 256 passengers kept on board for the entire time late last month because of immigration regulations, bad weather and limits on the crew's work hours.[/h]Flight 831 was diverted to the southern city of Zhuhai on the night of March 30 because of a hailstorm.The plane was left sitting on the tarmac for hours until Cathay Pacific sent in a new flight crew, with the first crew having reached work-hour limits.

There is a thread on this.

 

[Deleted User]

It was testing time tonight.
Qwibble rebate site plus an RAC sourced 5% off Wish Card from Woolies to see if I can get a combined 14.6% off the Dan Murphy's champagne special in a 6 carton with free delivery.

Cove, I'm interested on your take on this... if your test works does this mean you will (1) consume 14.6% more... or (2) Purchase a 14.6% better product...

:shock:

 

[cove]

It might become Krug city over here in the west. Anyway I will know in a little while.
I just added up my FF points. I may have to retire to stop those points banking up. It is a first world problem I think having to travel to stop the points growth.

 

[amaroo]

There is a thread on this.

Oops. I'll send this one to the delete pit.

 

[tuapekastar]

Just checked prices on our Santorini accommodation booked last November for July 2014 to see if prices had come down. Nope. Just I room left and prices now three times the price of our booking. (1,000 euros now 3,000 euros for 5 nights caldera view).

Nothing like supply and demand.

Dangerous ground there, re-checking prices, but seems a win this time.

 

[erkpod]

Interesting day...

Outside work, I've been asked to be a beta tester on a coffee locator app based on where you can get coffee around train stations. I don't drink coffee but the developer knows I know the train network & the city so he's happy with me to test the train side of things, map usability etc.

I've also offered my services as a writer for the Australian Ice Hockey League website with the angle of being a hockey newbie. I'm about to write my first couple of articles.

Then at work, I had suspected graffiti vandals ask me if I like to paint trains (yeah right) among other things & later helped a guy who partly fell between my train & the platform. The ironic thing was that he was trying to board my train & it wasn't going to where he wanted it to go anyway.

 

[SeatBackForward]

There are those who don't know maths. And there are those who don't know how to program.

Doesn't the expression about three types of people in the world, fit the above?

That subdivides them relatively well.

Of course, if that person's profession is supposed to include some technical functional usage of Excel, that's a very good reason why you should be irked.

I am the "excel" guy at my workplace, often answering queries that would otherwise have gone to IT Helpdesk. I do ask they raise a ticket when they come and ask me a for help. By ticket, I mean a coffee.

I once worked south with an accountant, admittedly an older less IT savvy gentleman who somehow managed to get all his work done in Excel. Spreadsheets, reports, letters, documents....

 

[SeatBackForward]

I'm not sure how you would determine if their profession should include this technical function. For example, should an accountant know or a sales manager?

I think I'd just be happier if the spreadsheet was PDF'd and that way I wouldn't know if there were any formulas in it. :/

If you want a quick look at where the formulas are, press "CTRL+~ " (control key and the tilde at the same time) to view reach cells contents. Again to return to normal view.

 

[robd]

I am the "excel" guy at my workplace, often answering queries that would otherwise have gone to IT Helpdesk. I do ask they raise a ticket when they come and ask me a for help. By ticket, I mean a coffee.

I like the coffee idea - I'm going to implement that one

If you want a quick look at where the formulas are, press "CTRL+~ " (control key and the tilde at the same time) to view reach cells contents. Again to return to normal view.

I know about formula view - I refer to it as "control squiggly thing" (very technical).

 

[SeatBackForward]

I like the coffee idea - I'm going to implement that one

Actually, in our IT dept, they have a habit of not opening tickets until they're at a point where they can resolve them, it must make their stats look spectacular, meanwhile a lodged ticket can take weeks to be opened. The coffee system is foolproof.

I know about formula view - I refer to it as "control squiggly thing" (very technical).

I like it, bit like how I'm constantly confused about back and forward slash. The one that points up and the one that points down.

 

[Pushka]

Dangerous ground there, re-checking prices, but seems a win this time.

It's what I do. I'll book a cancellable booking with a price I'm happy with a few months out so I know I've got somewhere then revisit a couple of months out to see if prices have improved. They did with the Dubai booking but not with Santorini.

 

[markis10]

It's what I do. I'll book a cancellable booking with a price I'm happy with a few months out so I know I've got somewhere then revisit a couple of months out to see if prices have improved. They did with the Dubai booking but not with Santorini.

Good move, a lot of hotels wind down the price in the week leading up to a stay if there is soft demand.

 

[serfty]

Where I work there are service standards for both response and resolution, however a 'ticket' may be placed in 'pending'. When that occurs the customer gets an email notification.

 

[blackcat20]

And this is post 33333

I see it as 33332....