So much for Dura-Ace

Cycling equipment can be expensive. The top of the range components are not cheap. Bikes fitted out with top of the range equipment have price tags competing with high end motor cycles.

Are they worth it?

Screen Shot 2019 09 24 at 7 21 15 AMScreen Shot 2019 09 24 at 7 20 56 AMMy recent experience with Shimano’s top of the range Dura-Ace crank-set suggests not. A base level Shimano crank set will set you back €82.90. The Dura-Ace version costs €419.00.

2019 09 22 13 31 422019 09 22 13 32 18The crank arm snapped while riding. There had been some warning signs that all was not well. Most recently, the crank arm had been catching the chain in the high gears. The replacement was already en route.

2019 09 22 13 30 362019 09 22 13 58 58An investigation of how things went wrong is revealing. To keep it light, the crank is a monocoque construction made up of a chassis and an outer shell which are welded together at various points.

2019 09 22 13 34 42At the heart of the design is a weld-point that joins the spider to a cap, which connects to the axle. The cap is pushed into the axle, like a cork. If they separate, the unit’s strength is compromised, and the crank will start to flex, and eventually breaks from metal fatigue.2019 09 22 13 33 06

A clue that this might be happening is when the crank starts to creak. In my case, the creaking disappeared. That’s the sign that the welding has separated, and the crank is on its last legs.

2019 09 22 13 36 522019 09 22 13 39 00The real surprise is that this weakness could be easily designed out. On the opposite crank there is a threaded bolt that is used to tighten the left crank in place. A similar bolt on the right crank would ensure that the two components making up the right crank couldn’t separate. Yes, it would need to be checked for tightness every now and then, but it would be a better construction.

Shimano obviously thinks that some cyclists wouldn’t bother to check.

At least give us a choice.

This is clearly a design flaw. In my small circle of cycling friends. it’s happened to two others. There are plenty of complaints on the web. Shimano won’t do anything while their products remain so popular.

Perhaps a boycott will adjust their thinking.

0.00 avg. rating (0% score) - 0 votes

Open letter to the Chief Executive Officer of EasyJet

Sep 12, 2019

Attention: Johan Lundgren

The Chief Executive Officer
EasyJet

Dear Mr Lundgren

The study conducted on strategies to improve aircraft boarding and their impact on airline profitability makes for interesting reading.

My recent experience on EasyJet runs contrary to those findings. Customers in the boarding queue traveling with a hand-bag and cabin luggage were instructed that this was contrary to EasyJet policy, and that the handbag must be packed in the cabin luggage. Those of us who travel frequently separate our luggage in a way that security, boarding, and in flight inconvenience are minimised, and the handbag is an effective part of the tactic.

Fitting the handbag into the carry-on was not an issue. But there were issues, as other passengers were held up as I retrieved my passport from the handbag as we were leaving the terminal, and again when extracting the handbag before putting the carryon into the overhead.

After discussing these issues with the senior cabin attendant, a number of passengers who were on their first flight with EasyJet expressed their support. Never again, was their common refrain.

Given that getting new customers is approximately ten times more expensive that retaining existing ones, the EasyJet policy is unsound business practice.

In the short term, the additional charges for excess luggage may conceal the long term losses that this strategy generates.

The EasyJet policy certainly derives from the profitability of ancillary services when they were introduced by airlines early in this decade. But charging customers at the airport is a delicate balancing act, if one values customer loyalty.

Being informed by the ground crew that the inconvenience of packing a handbag into one’s carry on is the customer’s fault, because of the way they booked the flight, does not generate any goodwill.

There are low cost carriers that treat their customers well, and their ongoing profitability proves its value.

There is increasing evidence that the world’s economies are headed for recession in 2020. The economic implications of the quantitative easing strategy used to recover from the great recession of 2007/8 will be felt at that time. Businesses that have not built good customer relationships will suffer most.

Good luck.

Yours sincerely,

Roy R Dalle Vedove

0.00 avg. rating (0% score) - 0 votes

Open letter to the CEO of Webhostinghub.com

July 5, 2019

Attention: Mr Todd Robinson
CEO
Webhostinghub.com

Dear Mr Robinson

Int-forex.com

Changing service providers is challenging. Webhostinghub promised the services that I needed, and I subscribed. Your technical support team is excellent. Not only that, your documentation is detailed, and easy to follow.

But I’m unhappy. The transcript of the initial conversation with your sales agent, Adam Block, confirms that you provide event scheduling on MySQL on the Nitro package that I purchased. The conversation confirmed that Webhostinghub will meet the explicit requirement to create events from within applications, without manual intervention.

Following the principle of “Caveat Emptor”, the needs were specifically stated, without any opportunity for misunderstanding.

Now, I have been informed that the service is not available unless I upgrade my package. That’s a bait and switch strategy. Tarnishing Webhostinghub’s hard-won reputation like that is undesirable.

I have been reminded that you have a 90 days money back guarantee. What I want is what I was promised. Technically, this is a simple using a single command with super admin privileges. My needs place no additional load on the server. Yes, other users might, but that cannot be used to force me to pay for an upgraded service.

We have routes to a sensible solution. Please contact me if you wish to explore them.

Yours sincerely,

Roy R Dalle Vedove

1.00 avg. rating (34% score) - 1 vote

Financial modeling

It struck me as peculiar that my accounting degree did not include any financial modeling. It was in the real world that I learned, initially as a CFO, and then in finance.

As a working capital financier, you see plenty of cash flow projections. Working capital finance is usually needed because people have made mistakes with their modeling at the outset. Financiers have to have own models into which they plug the numbers. It’s better than trusting the sanguine figures that are usually presented.

So that’s what we did.

As the spreadsheet guru, I was tasked with creating a model that integrated the balance sheet, income statement and cash flow projections.

Getting all three to balance is tricky, but crucial. Errors in assumptions become evident as the ratios go out of kilter, and that let’s you know if the numbers can be trusted.

Once the model is working, the starting point is to enter the last three months figures. If the assumptions and calculations are right, the most recent balance sheet will pop out from the input. If it doesn’t there are errors. Fix them, and you’re on your way.

The assumptions are key. They will guide the strategic planning, and the executive that has a grip on them is likely to succeed.

One of the best tools for getting a feel for the key factors in a business is also one of the simplest: break-even analysis.

To the uninitiated, break-even analysis is like a magic trick. Sitting in a pub, you can scribble down the variable expenses, then the fixed expenses, calculate the contribution, and tell a desperate friend why his business is struggling, and how long it will take to fix.

The financial model must include the results of a proper break-even analysis. Then, slotting in past figures will immediately reveal any misallocation of fixed and variable expenses.

The exercise of entering past figures has another benefit.

It provides the executives with confidence that the model works, and the understanding that by continuing to enter results they will know in advance whether something is out of line.

They become proactive.

They look good.

They are good.

1.00 avg. rating (34% score) - 1 vote

The Excel mistake that changed the world

In 2010, two leading Harvard economists, Carmen Reinhart and Kenneth Rogoff, published a paper. They had found that debt levels exceeding 90% of GDP led to a decline in economic growth. Governments took notice, and policies were implemented to reduce debt, with sometimes draconian austerity measures.

George Osborne quoted the paper as he introduced his measures to repair Britain’s economy. We are still living with the consequences.

The problem is that their results were wrong.

The Harvard professors had used Excel, and had accidentally only included 15 of the 20 countries under analysis in their key calculation. It made a big difference to their results. Their finding of a decline in GDP of 0.1% was really a increase of 2.2%.

As their data had grown, they had failed to change the formula.

Excel is a great tool. It’s intuitive, easy to work with, and presents results well with graphs and pivot tables.

It’s the best tool for creating and checking complex algorithms, doing financial projections, and quick and dirty calculations.

It falls down when handling big data, data that grows over time, or there are multiple users making updates.

It’s easy to end up with multiple versions of the data, and then have to decide which is correct.

Excel makes entering data easy. But it’s also easy to make mistakes. Validations to guard against bad data have to be programmed in. Garbage in – garbage out.

Ray Panko, a professor at the University of Hawaii and the elder statesman of small coterie of research academics who study Excel errors, claims that 84 percent of spreadsheets contain some kind of materially significant error. Other economists agree.

Databases are not visual, not in the way that Excel is. The terminology and design can seem arcane. You can’t just open a database and start entering data. They’re not intuitive. They are also not as complex as they seem.

So, which should you use? – The answer: both.

It’s a matter of deciding which is the right tool for the job. It’s not necessary to decide up front. Using Excel to become familiar with the data is a great way to start a database project. When you get going, importing the initial data into the database is easy. so nothing’s lost.

Having an existing spreadsheet that should be a database is an excellent way to learn. The best choice for a project is one where you’re struggling to tie up the relationships in the data. What’s difficult in Excel is easy in a database.

Great, now the data is in a database, but now you need to present the result of your analysis. Simple. Export the summaries into Excel and do it there. It’s easy to do, and it’s the best tool for the job.

What about the cost? Unlike Excel, many of the best databases are open source and free.

So, how do you get started. Next time.

1.00 avg. rating (34% score) - 1 vote