SpreadEveryone: The Fetchland Excel wire

88 watchers
20 Sep
3:58pm, 20 Sep 2022
139,340 posts
  •  
  • 0
GregP
Anyone going Olympia tomorrow?
20 Sep
4:14pm, 20 Sep 2022
578 posts
  •  
  • 0
icenutter
=if(A1="Olympia","Hi","What?")
20 Sep
4:18pm, 20 Sep 2022
15,591 posts
  •  
  • 0
Badger
Garfield I'd be minded to use openpyxl to turn them into a spreadsheet, just read each file in individually and write it into a column cell by cell
20 Sep
4:43pm, 20 Sep 2022
16,881 posts
  •  
  • 0
Garfield
Thanks Badger , I'll try that tomorrow...
21 Sep
11:45am, 21 Sep 2022
16,885 posts
  •  
  • 0
Garfield
Very close...I bypassed the csv bit and went straight to xlsx...not xsl (I've dealt with a lot of xslt in the past, so that naturally comes to my fingers!)
21 Sep
2:19pm, 21 Sep 2022
16,886 posts
  •  
  • 0
Garfield
Thanks again Badger!
21 Sep
2:32pm, 21 Sep 2022
15,593 posts
  •  
  • 0
Badger
Welcome! openpyxl is wonderful, I scripted pulling data out of two long text files and generating a pile of graphs that I could then dump straight into PowerPoint for quarterly steering groups. Ten minutes for what had been a few hours work.
21 Sep
2:40pm, 21 Sep 2022
16,887 posts
  •  
  • 0
Garfield
I've taken one report and twisted it around for some of our sales people. The lucky recipient is on holidays until Monday...so she'll have a little surprise in her inbox!

Got something to say?

To join the discussion, sign in or join us.

About This Thread

Maintained by John66
This is bugging me, I'm sure it should be much easier

A1 has 25/6/2010
B1 has 24/6/2013

So t...

Related Threads

  • excel
  • support
  • tech
  • work

The Doctor K Cup

This year sees the fifth edition of our annual challenge in memory of the Fetchies who have sadly passed away. It's named after Doctor K, who died of pancreatic cancer in 2017

Are you doing the right training?

See typical mileage, pace and long run stats for every distance and goal. See a comparison with your own training.

Heart Rate Analysis

See your heart rate training data from the last 12 months broken down in technicolour.

Flat as a pancake?

We've collected thousands of your reviews from events, and worked out which races give you the best chance of a fast time!


Back To Top
X

Free training & racing tools for runners, cyclists, swimmers & walkers.

Fetcheveryone lets you analyse your training, find races, plot routes, chat in our forum, get advice, play games - and more! Nothing is behind a paywall, and it'll stay that way thanks to our awesome community!
Get Started
Click here to join 109,081 Fetchies!
Already a Fetchie? Sign in here