Good morning everyone.
Did the graduation thing yesterday. Shook Former President Mbekis hand. 
5 Likes
Have heard of it. Haven’t used it though.
2 Likes
Congrats!!!
1 Like
unfortuantely that didnt work… because all the names are unique - so now I am trying to just remove the ones that have the word license or renewal in them
I’ve read up on it from a Digital Twin perspective a little. Not the ISO standard, though. It’s a pretty wide reaching field, essentially starting with digitizing documents that a building would require, to having a digital model that contains data about the building (think maintenance and legal records), to having a 3d model with clickable bits to control and read info.
Our company (head office in Belville) does some of this, so if you want I can get you some better informed people if your requirements line up with what we do.
What are you looking for in your case?
1 Like
- Open the Excel worksheet and select the rows that you want to delete. You can select multiple rows by clicking and dragging the row headers, or by holding down the “Shift” key and clicking on the first and last row headers of the range.
- Click on the “Find & Select” button in the “Editing” group on the “Home” tab.
- Select “Replace” from the drop-down menu.
- In the “Find what” field, enter the word or phrase that you want to search for in the selected rows.
- Leave the “Replace with” field blank.
- Click on “Options” to expand the dialog box.
- Check the “Within” box and select “Sheet” from the drop-down menu to search the entire worksheet.
- Check the “Match entire cell contents” box to ensure that only the cells containing the exact word or phrase are selected.
- Click on “Find All” to select all the cells that contain the specific word or phrase.
- Press “Ctrl” and “-” (minus) keys at the same time or right-click on the selected rows and choose “Delete” to remove the selected rows containing the word or phrase.
Note: Be sure to double-check your selected cells before deleting any rows, as this operation cannot be undone. It is also recommended to make a backup of your data before performing any changes.
Have tried that and it isnt picking the word I want nor will it let me do the ctr -
Filters are your Friends. It alliterates, so its true.
Highlight your list:
Hit the filter button:
And I mean hit it
Click the arrow, text filter, Contains:
I put in renewal in this case.
Now just delete the rows that appear:
2 Likes
This ought to work, but filtering using my method A) allows you to review before replace/deleting, B) Is pretty powerful for other manipulation you might want to do later on.
1 Like
Nevermind i got it to work you rockstar you! Thank you - that has helped a lot
From 1435 rows down to 1273
Now to figure out how to find duplicate projects 
even if the names differ
1 Like
I owe you a beer when you are in the cape again!
1 Like
This shall henceforth be known as Avatar’s Wife’s Law and it shall ride the heights of history alongside the Laws of Moore and of Murphy.
2 Likes
Avatar’s wife’s law. I am but a simple conduit of wisdomness.
2 Likes
I need to find and get some kefir, does anyone know where I may find this? Is it a milk or a water?
1 Like
I’ve been looking too.
There is some on takealot but half the reviews are complaining that the grains are too small and get washed away. This is to make it btw.
There is both water kefir and milk kefir.
1 Like
yoh, you guys need to careful how you google that.
Might end up on some list.
2 Likes
Yeah, I’ve had no idea what it is, just that we need it for dietary requirements.
Apparently, Woolworths sells the milk form, I’ll have a look in Clicks’ health or organic section along with Checkers too.
1 Like
Its apparently better than yoghurt. There are some special grains that you put in milk or water and leave overnight to ferment and it turns the milk thick and it has lots of beneficial gut bacteria.
Any fermented stuff should technically be good for your gut but kefir seems to come out at the top. Unless you can get your hands on natto (the taste is a different story though).
Probably already am.
2 Likes
How does it compare to Kombucha
Kombucha helps more with digestion and kefir is more probiotic from what I’ve read.
2 Likes
Lol someone is building Solitude in Cities Skylines
4 Likes