I was quick to regret my shoe choice. I had to run most of the 4km route with a large pebble sized, hollow, impression in my right heel but at least it encouraged me to run up on my toes.

When I arrived at the village I slowed down to a nonchalant saunter hoping I could cool off and not look like a crazy dying thing in front if the locals. The air in the little shop was furnace like. I stepped in and immediately a gallon of sweat made it’s escape from my body. My hands were dripping as I selected the tomatoes.

After the tomatoes my purchases went downhill a bit. I was scavenging for breakfast but couldn’t find eggs, yoghurt or cheese. In the end I came back with the heaviest products on offer – home made honey, a bag of flour and a bottle of dubious looking brown liquid.

I’m hoping it’s the famed Cretan wine and not some DIY plant fertiliser. I’ll have to wait til lunchtime to find out.

Now to bake some honey bread…..

Originally published on my warriorwomen blog.

I don’t recommend late night, barefoot runs on rainy nights. For one thing the gravel sticks more persistently but more importantly the damp attracts soft squishy critters with hard shells and the darkness means you can’t see them.

You can feel them squelching between your toes though.

I ridded myself of the slime after 330m and put the mocassins back on for the remaining 2 miles.

It seemed a shame to cook it, so although it is way too late in the season I decided it might be worth planting.

I had a sense that sweet potatoes are a right faff in the UK and although Bob Flowerdew grows them successfully I didn’t stand a cat in hells chance.

I’ve done a bit more research now and I’m beginning to hope that it rots in situ. Here’s a quote from one site on How To Grow Sweet Potatoes:

In fact, the question is not how to grow sweet potatoes, it’s rather how to stop sweet potato vines from taking over the whole garden! Sweet potato is a very invasive creeper…

Sounds like I might have inadvertently attempted to cultivate a persistent weed on the allotment. Great.

Sweet Potatoes are usually cultivated from slips which I think are the shoots that you can see on my sweet potato photo. They can be potted up and grown on before planting out in May but I imagine they will still grow ok if you chuck the whole tuber in. This one will never be harvested though, they need about 4 to 6 months of sunshine to mature and I don’t expect we’ll have a lot of that between November and February.

I’ll be sure to let you know if anything outstanding happens.

Originally published on my earthwoman blog.

Not that it worked very well, we hopped and squealed almost evenly.

So marked the start of our true barefoot experience.

I’ve been trying out the minimal footwear such as Vibram Five Fingers and Soft Star RunAmoc for a few weeks but yesterday I was inspired to try running completely unshod. I had been listening to the rather excellent Living Barefoot Podcast which featured an interview with Michael Sandler. Michael is a hugely enthusiastic barefoot runner with a fantastic story to tell. I’ve heard other barefoot officianados’ say that you should really start barefoot before transitioning to a minimal shoe but that just sounded counter intuitive to me. Michael spoke at length in the interview and was incredibly infectious, so much so that today I managed to persuade Lynn to venture out of the door clutching our shoes in our hands.

We ran tentatively but were definitely up on our toes. With gritty tarmac roads for our debut attempt we wanted to ensure that our feet had only the tiniest contact with the ground. I was the slowest to become accustomed to the feeling but I developed a rhythm of two steps followed by a medial swipe down my inside leg – to dislodge embedded gravel.

We made it 300m before deciding enough was enough and we finished the rest of the mile – me in my RunAmocs and Lynn in my Nike Frees.

Originally published on my warriorwomen blog.

I was offered a pair of Merrell Siren shoes to try out recently. They are a far cry from my recent spate of minimal running shoes but as I had a planned expedition to the Peak District I thought they’d be ideal for a few rough walks.

I’ve worked my way through many pairs of Merrell women’s shoes in the past, they look great and feel extremely comfortable but I’ve always felt let down by the soles which have proved to be very slippy on wet rock and pavement. These Siren shoes have very sturdy Vibram soles so I was hopeful that things might have improved in the intervening decade or so and with a lining of Merrell Gore-Tex they are clearly designed to be worn in all weathers.

We were in the Peaks for my birthday so my folks joined us for our first walk. We’d picked accommodation by the highest pub in Derbyshire which was fine when it came to drinking real ale with a view but became a bit hairy when we tried to descend the valley through a jungle of Gorse.

After 429 metres of moaning we abandoned the descent, got back in the car and headed off to Grindleford for the obligatory chip butty and a walk up and around the Longshaw Estate.

This is one of my favourite walks around the Peak District and it isn’t all about the chip butty.

It’s a steep climb up through the woods with a stream cutting through the valley to the right. When you reach the Estate the fields there are always teeming with an amazing variety of fungi.

The most exciting point of the weekend came when we spotted a clump of Stinkhorns. At least I thought so, the others appeared somewhat less impressed.

The Merrel Siren shoes held up extremely well but then they are so sturdy it is only to be expected. They were fairly clumpy for day to day pavement walking but on the trails they offered a degree of confidence that you only usually experience with a good walking boot.

When I think of ways to describe them I come up with words like, solid, dependable, secure. I really felt as though I could bound along the trail oblivious to the conditions underfoot and the shoes would get me through. The protective toe area was much appreciated in the rocky conditions.

The Merrell Siren shoes are an excellent alternative to the full walking boot. They are solid yet light enough to walk in for hours and provided you don’t get them submerged above the ankle line they’ll remain dry.

It started raining with a vengeance when we’d cleared the cover of the woods, so I got to try out the performance of the Vibram soles on the wet rock.

I didn’t end up on my arse once!

Through dry rock, wet rock and mud the Merrel Siren shoes didn’t let me down.

Apart from a brief interlude where I had to review some hiking shoes, the RunAmocs became a bit of a permanent feature – much to Lynn’s disappointment – I’m not sure she approves of my new obsession and it’s associated crusty geography teacher fashion accessories.

My initial thought on the sizing was that perhaps they were too big. There was a very big gap, lets say an inch, between my big toe and the end of the shoe but I’d measured my foot according to the guidelines on the website so decided to try them out. Despite having loads of room in the toe area they didn’t slosh around my foot and felt generally very comfortable.

It’s normally my toes that suffer the most in standard shoes so it was quite a blessing to leave them feeling so free. The roomy toe box creates an obvious point of difference between the feeling of running in the RunAmoc vs the Vibram Five Fingers. Although there is a huge degree of movement available with the Five Fingers, I still feel constrained by the toe compartments while the RunAmocs left me feeling as though I had only a very light drape across the top of my foot.

I ordered the RunAmoc with the slightly thicker sole. At 5mm it is not huge but it is designed to give maximal protection for trail running while still enabling you to feel in-touch with the ground surface.

On Sunday we were running along the Manifold River in Ilam and the tracks varied between limestone paths and root laden trail runs. I was grateful for the protection and managed to run amongst the pebbles without too many exclamations of pain. These soles are thicker than on my Vibram Sprint Five Fingers and were noticeably more comfortable on the rougher surface but I didn’t lose any of the barefoot feel.

As I was running up the limestone steps built into the side of the valley I was aware of my feet bending and hugging the surface. It was a huge contrast to the previous days hike in the solid Merrel Walking Shoes.

Barefoot or minimal running can become almost a spiritual experience where you begin to feel part of the landscape and the track you are running along. It’s a much more involved and gentle way to interact with the trail.

All this barefoot running is reminding me of a trip to Vienna.

At Kunsthauswein I tuned in to the amazing architecture of Hundertwasser and tried to scribble down his writings on the uneven floor.

It seems that Hundertwasser may have been an early adopter of the barfoot movement, this photo shows him wearing a pair of his handmade shoes (summer & winter) – very minimal.

The Uneven Floor

The flat floor is an invention of the architects. It fits engines – not human beings.

People not only have eyes to enjoy the beauty they see and ears to hear melodies and noses to smell nice scents. People also have a sense of touch in their hands and feet.

If modern man is forced to walk on flat asphalt and concrete floors as they were planned thoughtlessly in designers’ offices, estranged from man’s age-old relationship and contact to earth, a crucial part of man withers and dies. This has catastrophic consequences for the soul, the equilibrium, the well being and the health of man. Man forgets how to experience things and becomes emotionally ill.

An uneven and animated floor is the recovery of man’s mental equilibrium, of the dignity of man which has been violated in our levelling, unnatural and hostile urban grid system.

The uneven floor becomes a symphony, a melody for the feet and brings back natural vibrations to man. Architecture should elevate and not subdue man. It is good to walk on uneven floors and regain our human balance.

Hundertwasser, April, 1991

Originally published on my warriorwomen blog.

They then told us that we had won the best new comers award – no congratulations implied.

Apparently we were now in the running for best new comers in the whole of Croydon. The committee had seemed slightly pre-occupied by the pan-Croydon allotment competition for a few weeks. A fancy new pergola has been erected by the entrance and bee hives have been introduced into a tiny corner.

Everyone has been instructed to tidy up and now it was our turn. All eyes on our plot.

We thanked them in shame and scooted off to de-weed our flower bed.

In the privacy of our own plot we allowed a little smugness to sneak through. Lynn insisted that it must have been her onions what done it while I maintain that it can only be the peaches of wonder.

Here’s a quick tour of our award winning plot.

I heard about the video after listening to the interview with Christopher McDougall on the Living Barefoot podcast.

Learning the Skill of Barefoot Running from Terra Plana on Vimeo.

Originally published on my warriorwomen blog.

An interest in sport increased my repertoire but even then I managed to live in a pair of Specialized Sonoma cycling shoes throughout my student days.

I blame running.

It must have ticked disturbing boxes in my psyche. I have now commandeered the shoe rack that spans the length of our hall and still have an overspill. I still only have one pair of work shoes but there is a tremendous glut of running shoes and my stockpile is set to increase.

Hiking shoes arrived last week, Nike Free 3.0 trainers yesterday, I’m awaiting stock of a pair of Vibram Five Finger Bilkilas and my Soft Star Run Amoc moccasins are slowly winging their way across the Atlantic as we speak. We have a romantic weekend booked away and my only packing demand after spare pants was a selection of running shoes. I may have to hunt out an appropriate 12 step program when we get back.

In the mean time, here are my thoughts on the Nike Free 3.0

I’ve pinned a lot of hopes on minimal running shoes and expect them to revolutionise my mornings and long runs by removing the crippling pains of plantar fasciitis. With this in mind I’ve been diligently introducing Vibram Five Finger runs in to my schedule but reverting to my standard shoe for long runs.

My standard shoe is a heavy duty, cushioned, supported, mega structure so I started looking around for a suitable transition shoe. RunBlogger provided me with some much appreciated advice and Donald from Running and Rambling has written an excellent overview of the options.

Hence the arrival of the Nike Free 3.0

It’s not a truly barefoot experience or even an almost-barefoot-best-described-as-minimal experience but its half way there and a half-way house was just what I needed.

The shoe is incredibly flexible, in fact you want to pick it up and mould it like playdoh. It has a peculiarly innovative sole, made up of little cubes of rubber that enable it to flex freely, this way and that.

We were at Waterloo Station last night picking up one of the kids of Railway Children fame. We were waiting patiently on the platform when I leapt up onto my toes and declared: “Tadaaaa….bet you can’t do that!”

Well it seems they all could but I maintain that it means something that I was the only one who felt suitably empowered by my footwear to display such idiocy in public.

These are flexible shoes.

The uppers are fairly minimal, a little padding around the ankle but in the main these are made of a lightweight waffle fabric. I’m used to shoes with rigid plates in the heel and all this floppiness comes as a bit of a shock. It makes for an incredibly comfortable shoe though. Regardless of your views of Nike and the position of the Free 3.0 on the barefoot-standard shoe scale, you can’t deny that the word on the block is “comfort”.

We went for quick midnight run when we got back from the station and it was such a joy. It was only a short so I need to test this further with a weekend long run but the first impressions were great. No pain from my feet at all. When I wear standard shoes I get the impression that my second toe nail is being ripped from its bed but there was no discomfort at all with the Nike Free 3.0

The run was silent and fast – at least by my standards. The sole felt as though it had a strange stickiness to it but it didn’t seem to hold me back as we knocked a minute off our usual mile pace.

I think I might have found my half marathon shoe.

Originally published on my warriorwomen blog.

 Yesterday I had to deal with a data file that looked a little like this only  it spread out across 455 columns and was frankly useless.

I wrote a post a while back that demonstrated how to convert a simple cross tab back to a manageable data list but I wanted to expand this with a slightly more complex example which had more field headings.

So starting with the table above which was probably a pasted copy from a pivot table I applied a little bit of formatting to achieve the following starting table.

What I have done is remove the grouping that the pivot table applies and ensured that I have the relevant  week number, project and department details against each name

I often wish to convert pivot table outputs back into a data file and the way I fill in the blanks caused by grouping data is to prepare a sheet with formulas that copy values from above (or the side as appropriate):

I then copy the pivot table data and then use the paste special command selecting paste values and skip blanks as the options.

This results in the following output, which I then copy and paste over itself as values, to give me the desired structure.

Having spent a bit of time on the structure of my starting file I can run the macro that will work through each row and transpose the data from a columnar layout to one based on rows.

The advantage of this format is that I can now create my own pivot tables and cut the data as I see fit to produce multiple summary formats according to my audience.

Here’s the macro I use:

Sub CrossTabToList()

Dim wsCrossTab As Worksheet
Dim wsList As Worksheet
Dim iLastCol As Long
Dim iLastRow As Long
Dim iLastRowList As Long
Dim rngCTab As Range ‘Used for range in Sheet1 cross tab sheet
Dim rngList As Range ‘Destination range for the list
Dim ROW As Long

Set wsCrossTab = Worksheets(“Sheet1″) ‘AMEND TO SHOW SHEET NUMBER WITH THE CROSS TAB
Set wsList = Worksheets.Add

‘Find the last row in Sheet1 with the cross tab
iLastRow = wsCrossTab.Cells(Rows.Count, “A”).End(xlUp).ROW

‘Set the initial value for the row in the destination worksheet
iLastRowList = 2

‘Find the last column in Sheet1 with the cross tab
iLastCol = wsCrossTab.Range(“A2″).End(xlToRight).Column

‘SET THE HEADING TITLES IN THE LIST SHEET
wsList.Range(“A1:F1″) = Array(“NAME”, “PROJECT”, “TYPE”, “PLAN/ACTUAL”, “WEEK”, “HOURS”)

‘Start looping through the cross tab data

For ROW = 3 To iLastRow ‘START AT ROW 3 AS THIS IS WHERE DATA BEGINS
Set rngCTab = wsCrossTab.Range(“A” & ROW, “C” & ROW) ‘initial value A3 SETS THE RANGE TO

‘INCLUDE ALL STATIC DATA – IN THIS CASE NAME, PROJECT, TYPE
Set rngList = wsList.Range(“A” & iLastRowList) ‘initial value A3

‘Copy individual names in Col A (A3 initially) into as many rows as there are data columns
‘in the cross tab (less 3 for Col A-C).
rngCTab.Copy rngList.Resize(iLastCol – 3)

‘SELECT THE HEADING ROW WITH FORECAST/ACTUAL
‘Move up ROW (INITIALLY 3) rows less TWO and across 3 columns (using offset function). Copy.
rngCTab.Offset(-(ROW – 2), 3).Resize(, iLastCol – 3).Copy

‘Paste transpose to columns in the list sheet alongside the static data
rngList.Offset(0, 3).PasteSpecial Transpose:=True

‘SELECT THE ROW WITH THE WEEK NUMBERS
‘Move up ROW (INITIALLY 3) rows less ONE and across 3 columns (using offset function). Copy.
rngCTab.Offset(-(ROW – 1), 3).Resize(, iLastCol – 3).Copy

‘Paste transpose to columns in the list sheet alongside the static data
rngList.Offset(0, 4).PasteSpecial Transpose:=True

‘Staying on same row (3 initially) copy the data from the cross tab
rngCTab.Offset(, 3).Resize(, iLastCol – 3).Copy

‘Past transpose as column in list sheet
rngList.Offset(0, 5).PasteSpecial Transpose:=True

‘Set the new last row in list sheet to be just below the last name copied
iLastRowList = iLastRowList + (iLastCol – 3)

‘increment ROW by 1
Next ROW

End Sub

I’m afraid the VBA code isn’t rendering very well – you’ll have to replace all the ” and ‘ marks before the macro editor will recognise the code.
Here is a copy of file – you could copy the macro code from here: Excel to CrossTab.xls