Archive for the ‘Spreadsheet’ Category

Gods Own County

Wednesday, 31st July, 2019

Take care if you are in Gods Own County at the moment. Its raining like its Cumbria!!

I’ve (mis) spent lots of time in Swaledale, especially Gunnerside, so to see the bridges washed out is quite shocking.

Hailstones the size of pickled onions. (proper English ones, not the tiny ones from t’continent.)

 

Advertisements

Self Spreadsheet Saboteur risks 10 years porridge

Tuesday, 23rd July, 2019

I used to put a little support contact details messagebox  in some of my more complex spreadsheets in the hope I may get a lucrative support gig.

This guy went a bit further.

He time bombed his VBA and locked the projects. Now its in court and it could be 10 years in prison and/or 250kUSD fine. Oops!

I wouldn’t accept a contractor keeping passwords, a proper external supplier maintaining their IP ok, but a contractor working on company files? no. And I personally wouldn’t lock my VBA either, if the client wants to do that fine, until they lose the password and I have to hack it…

 

 

Eusprig 2019

Monday, 17th June, 2019

If you are interested in Excel, and therefore spreadsheets you could do a lot worse then spend a day immersed in the risks and challenges associated with them.

That’s where the European Spreadsheet Risk Group comes in with their annual conference, this year in that London.
—————————————–

The European Spreadsheet Risk Interest Group Conference (EuSpRIG 2019)
will be held at Browns Courtrooms, Browns Covent Garden, London, on
Thursday 11th and Friday 12th July 2019.

http://www.eusprig.org

Real life case studies of EUC control, deep dive into data analysis,
experience with skills transfer, and two tutorials on new features.

—————————————–

I can’t be there this year, but I’ve been a few times and would heartily recommend it to anyone with more than a passing interest in spreadsheets.

Even if the content does not seem immediately, directly relevant, a day in that environment will raise your awareness of the risks and dangers and have you thinking more cautiously next time you are building or changing a spreadsheet. Which is a very good thing.

cheers

simon

Old VB6 books

Thursday, 2nd May, 2019

What did you do with yours??

I am having a tidy out and I am thinking it might be time to say goodbye to my Excel 5 books and maybe some VB6 stuff. Maybe even that Access 97 one too. Bit early to bin the Access 2000 stuff, but I’m not even sure anything I built with my old VB6 machine would run on Win 10.

(I am keeping all my COM stuff, that’s bound to come in at some point.)

So what do you do with your old IT books? (I have some iOS 5 ones too…)(and Android 2…)

cheers

simon

most spreadsheets

Thursday, 31st January, 2019

I don’t have any media but I do have a working lapper with win 3.11 and Excel 5, and most versions since somewhere. But this guy beats me by a million miles.

Fair play, the world record for most spreadsheet applications, including media and instruction manuals. (around 800 !!)

I never used Visicalc commercially but I did have an exe that ran on Windows at one point.

When I started we were using paper spreadsheets and gradually introducing Lotus 123 on dos. Dunno what version but the upgrade to the one with the : shortcut to all the formatting stuff was eye popping.

What is the oldest working spreadsheet you have access to?

Spreadsheet modelling competition

Thursday, 15th November, 2018

Dunno if anyone fancies it but there is a spreadsheet modelling  compo going on at the moment.

info here.

I’d like to have the time to do it but I don’t at the moment, being a busy boy looking for my next contract.

I have been doing so much SQL Server recently I have finally decided (about 10 years after first being advised to…) to bite the bullet and go for SQL dev/DBA roles.

So expect a bit more SQL related content here. And heavens forbid perhaps some Power BI as I have finally used that in anger too.

But anyway back on topic if you do do the spreadsheet challenge do let us know how it went. (I think its mainly for glory rather than prizes)

cheers

simon

 

DevelopExcel conf almost sold out

Wednesday, 3rd October, 2018

Yep, you read that right, if you want to see me and some proper developers talking about advanced Excel mischief your time is fast running out.

Details are here

be there or be square

Spaces are limited and we already have about 100 people coming, so if you are umming and ahhing, get booked on quick sharp.

By the same token, if you are booked on and can’t make it please let us know as we are on the verge of running a waiting list.

ta muchly

simon

Bluetooth mice

Friday, 21st September, 2018

Any of you using them?

Any good?

I have just swapped out the one I had at work because it randomly ignored me for 30 seconds every now and then.

Now I have one with the thickest most inflexible cable ever. Its doing my RSI no end of bad.

Initially I really like the bluetooth rodent, but after changing the batteries didnt improve its obedience it had to go. It also sometimes would not release like dragging and dropping but without the drop

I dunno what brand it was, but I am very underwhelmed. I am thinking I may have to go back to a track ball.

Anyone had good experiences with them? maybe I need to upgrade..

cheers

simon

ps don’t forget the amazing brilliant and excellent DevelopExcel conf is coming soon to that London. If you have not booked on yet, why the bloody hell not? linky.

 

About Time

Friday, 31st August, 2018

EU going to sack off summer time nonsense.

finally, I hope I am still around to see it actually happen, and that local non-EU countries go for it too.

Not sure what those in the far north think, but even when we lived at the top of England the clock change was unhelpful. Especially for young kids.

I could make a (rubbish) joke about Excel 2016 performance here but I won’t. :-)

Which do you prefer: going to bed an hour earlier when you aren’t tired or getting up an hour earlier when you are?

cheers

simon

 

more perf figures

Wednesday, 22nd August, 2018

WP wouldn’t let me add this as a comment so I made a new post…

 

Microsoft Excel for Office 365 MSO (16.0.10813.20004) 32 bit
Office Insider Program
Grid not visible
0.7578125
0.6953125
0.71875
0.7578125
0.71875
0.7265625
0.7265625
0.703125
0.71875
0.7265625
Grid visible
1.757813
1.710938
1.703125
1.695313
1.710938
1.703125
1.664063
1.6875
1.679688
1.703125

Processor: Intel(R) Core(TM) i7-5820K CPU @3.30GHzRam:
32.0 GBWindows 10 Home 64-bit

———————————————————–

Results (c.47 hours since last reboot):
4.015625
4.484375
4.402344
4.324219
4.144531
4.214844
4.441406
4.332031
4.453125
4.351563

Results (after rebooting):
4.738281
5.519531
4.609375
4.527344
4.640625
4.652344
4.640625
4.636719
4.734375
4.667969

Following on from above but gridlines hidden:
5.015625
5.140625
4.988281
5.105469
5.179688
5.238281
5.054688
5.042969
5.050781
5.039063

System:
OS Name Microsoft Windows 10 Pro
Version 10.0.17134 Build 17134
System Model Surface Pro 3
System Type x64-based PC
Processor Intel(R) Core(TM) i5-4300U CPU @ 1.90GHz, 2501 Mhz

Installed Physical Memory (RAM) 8.00 GB

Office:
Microsoft Excel 2013 (15.0.5041.1000) MSO (15.0.5031.1000) 32 bit
Part of Microsoft Office 365

Rubberduck Version 2.2.6672.28001 loaded.

———————————————————

Excel 2k3 (11.0.8169)
Windows XP Pro (5.1, Build 2600)
AMD Athlon XP64 Cpu 3200+ 2.8GHz
2048MB RAM

0.15625
0.296875
0.3125
0.3125
0.3125
0.328125
0.296875
0.3125
0.3125
0.3125

——————————————————–

EXCEL 2016

‘i7-3770 3.4GHz 16GB 64-bit OS, SSD & HD

Windows (32-bit) NT 10.00 Excel 16.0 Build 10325
Seed 3.1 Select:True
3.585938
3.4375
3.527344
3.316406
3.390625
Seed 3.1 Select:False
0.078125
0.078125
0.078125
0.0625
0.09375

EXCEL 2010

Windows (32-bit) NT 6.02 Excel 14.0 Build 7212
Seed 3.1 Select:True
0.9453125
0.9140625
0.9179688
0.90625
0.9101563
Seed 3.1 Select:False
2.734375E-02
0.046875
0.03125
0.046875
0.03125

CODE

Option Explicit
‘Simon Murphy

‘i7-3770 3.4GHz 16GB 64-bit OS, SSD & HD

Public Sub multiLoop()

Debug.Print Evaluate(“INFO(“”OSVERSION””)”), “Excel ” & Application.Version & ” Build ” & Application.Build
RepeatCellEntryTest 3.1, True
RepeatCellEntryTest 3.1, False
End Sub

Public Sub RepeatCellEntryTest(seed As Double, bSelect As Boolean)

——————————————————————–

Intel i7-7700HQ @ 2.8 GHz
32 GB RAM
Windows Pro 64 bit V1803
Excel 2016 (O365) Build 10325.20118

1:
1.289063
1.167969
1.152344
1.144531
1.148438
1.140625
1.148438
1.15625
1.167969
1.175781

2:
1.371094
1.308594
1.28125
1.257813
1.269531
1.25
1.210938
1.207031
1.277344
1.238281