➤ IT Cheatsheet

The scripts and code snippets I copy and paste most often Regex Remove duplicate linesFirst sort so duplicates are next to each other Option 1 Replace: ^(.*)(\n\1)+$ with $1 Option 2 Replace: ^((^[^\S$]?(?=\S)(?:.)+$)[\S\s]*?)^\2$(?:\n)? with $1 Find lines excluding specific stringOption 1 ((?!STRING).)*$ Option 2 ^(?:(?!STRING).)*$ Find Korean/한글 text[가-힣] Javascript Select all text by class/ID etcAlso TagName, ID, … a=document.getElementsByClassName('CLASS');b=[];Array.from(a).forEach((e)=>{b.push(e.innerText)});c=b.toString();copy(c);

Consumption Week 26

Liveable cities, Green Business Awards, and xkcd on the alphabet.

Business Sustainability in the Circular Economy (RH/UoL) Course Notes

https://www.coursera.org/learn/business-sustainability-circular-economy Lower food miles is not necessarily better - green beans grown in Kenya (hand-raised, natural fertilisers) and flown to the UK may emit less than those grown in the UK (tractors, oil-based fertilisers). Emissions from the entire supply chain must be considered, and the bottom of the pyramid (the most distant suppliers in the supply chain) are usually hardest. Linear (take, make, dispose) vs circular (make, use, return) → reduces virgin material use (and hence mining etc), reduces landfill (and hence emissions and waste) Reverse logistics (getting something back to the supplier) What: End-of-use product or packaging Why: For recycling, repurposing, reuse How: More complicated than forward logistics due to uncertainty (when, where, what (condition), etc) so often use third-party logistcs (3PL) companies Who: B2B is easier than B2C New legislation Design must consider end-of-life dismantling for recycling/reuse Right to repair

Consumption Week 25

Food waste, mortgage rates, new Black Mirror.

Corporate Strategy (UCL/UoL) Course Notes

https://www.coursera.org/learn/corporatestrategy IntroductionCorporation = multiple businesses Businesses differentiated by who, what, how (customer, product, place) Corporate strategy = portfolio selection + portfolio organisation OwnershipOwnership matrix: Parent vs business, public vs private Shares ≠ votes. Example: Family owns 80% of parent, which owns 40% of business (but 60% of voting rights). Family have 32% of shares and 48% of votes. But as family has 80% of parent (majority), they can control all 60% of voting rights.


1일째 호텔에 계시면서 필요한 것이 있으면 바로 전화 주세요. 세탁기 사용하는 방법 좀 알려 줄래요? 대중교통 이용하는 게 이제는 익숙해졌어요. 친구와 싸웠는데 다시 생각해 보니 내가 잘못한 것 같다. 처음에는 사람들이 관심을 안 보였지만 반복해서 말하자 관심을 보이기 시작했습니다. 가능하면 그렇게 처리해 주십시오. 건강 검진 결과가 나오면 연락을 드리겠습니다. 백화점 세일 덕분에 판매량이 30%정도 늘었다고 합니다. 여기서 한국 돈을 일본 돈으로 바꿀 수 있어요? 노력하면 안 되는 일이 어디 있겠어요?

Launching an Edible Insect Business, Part IV: Go-to-Market

We’ve assessed the potential market size and we’ve seen who’s currently in the market, along with their product lines. Next: based on everything we’ve found so far from our research, what’s our go-to-market strategy? Product-market fitIn my previous article, I hypothesised that larger insects (likely crickets and/or locusts) would be a good product to sell, for three reasons: It is an unfulfilled niche - most insects sold in the UK are small.

Consumption Week 23

Birds loves solar, corporations love greenwashing, and Wall Street loves double-clicking (although everyone else hates it)

Launching an Edible Insect Business, Part III: Product

Current products on the marketPart II gave us an idea of the products are currently available in the UK market. We could categorise them thusly: Insect-based snacks Unflavoured roasted insects Insect-derived ingredients Insect-based snacksThe snacks are insect-based substitutes for foods such as bags of crisps and bags of nuts. Generally they’re low-weight (<35g) and are single-portion. These seem to come in two forms, either flavoured insects by themselves (often crickets), or a more traditional mix of fruits/vegetables with a few insects thrown in (often mealworms).

Launching an Edible Insect Business, Part II: Competitors

In Part 1, I assessed the market for edible insects in the UK, and determined it has a lot of potential. In this post, Part II, I’ll look at who are the current market players. Finding the companiesThe first step is to get a list of companies. The most obvious method is to use a search engine. It’s good to use a variety of websites - Google, DuckDuckGo, Ecosia - and phrases - “edible insects uk”, “buy crickets uk”.

Launching an Edible Insect Business, Part I: Market

Along with energy and transport, I’ve always been interested in agriculture; growing up on a farm no doubt influenced that. In particular, entomophagy - eating insects - has always intrigued me. Aside from the (illogical) “yuck factor”, they’re nutritious, environmentally-friendly, and ethical. Cultures across the planet and throughout history have eaten insects. So why don’t we now? Your client is considering launching an edible insect brand in the UK. What do you suggest?

Consumption Week 20

Crony capitalism, Chinese automotive domination, and AI job cuts

Exploring SIC 30910

In a previous post I investigated a few companies using Companies House and the Office for National Statistics. In particular, I looked into the ONS data for electric vehicles, primarily based on SIC code 30910 (manufacture of motorcycles). ONS provides big-picture data - overall numbers of companies by size, revenue, location, etc. In this post I search for data on Companies House, which is more small-picture - information about individual companies.

Consumption Week 19

Recycling and cleaning, lightbulbs, timezones, annd the true cost of natural capital.

Using AI for Learning Languages

I’ve read a lot recently about using AI as a language learning aid, so I thought I’d give it a go. After all, it’s cheaper than a tutor, and always available. I mostly used (the free version of) ChatGPT as it seemed better than Bard and Bing. What’s the word?Quizzing on words, flash-card style, can be useful, but tends to be a bit boring (sorry Anki, Memrise, Quizlet, etc). Instead, ask ChatGPT to define a word.

PESTLE and Grid-Scale Energy Storage

I’ve been thinking about energy storage recently, and what may affect the industry in the coming months and years. PESTLE is a framework for analysing external factors that can affect an organisation or an industry. It’s an acronym that stands for Political, Economical, Social, Technological, Legal, and Environmental. Below is a quick outline of grid-scale energy storage, followed by a PESTLE analysis of the industry. Grid-Scale Energy StorageThe transition to renewable energy sources is also a transition to intermittent ones.