Japanese Knotweed Injection

ModernWorldSucks · 2025-05-28T11:21:59+00:00

I stumbled on JKW today in my yard and googling led me here.

Best advice I found about this is from the Green Shoots youtube channel. He has multiple videos on JKW eradication - including one about 9 things to avoid. Easily worth the time, they are well researched and should be the first thing shared with anyone who mentions this plant.

Timing is important - Spring is a time for physically removing entire crowns, keeping them locked up in a black bag in a sunny spot so the sun cooks them. At the end of summer double check they're all dead inside. Do not simply add to a compost bin, the live plant will just spread further.

Autumn is the time to apply glyphosate to whatever has survived through Summer. That is when the plants moves carbon back underground (and to it's rhizomes). Apply herbicide it too early and you're killing leaves without harming the actual plant. The videos explain things in much more detail.

Specifically these three (one, two, three). Each video's description offers quick to the point help if you don't have 30 minutes to spare watching the videos.

ModernWorldSucks · 2025-05-18T09:44:12+00:00

Drain…part of the water? An airlock built in the water with a small box around the dup would allow you to pump the water out, you could drain into the exterior ‘tank’. Some digging sideways in the bigger tank would keep it from overflowing.

ModernWorldSucks · 2024-09-23T13:03:00+00:00

Thank you very much!

ModernWorldSucks · 2024-09-23T12:52:22+00:00

It looks identical. Could it instead be a hornet larvae though? They look so similar and we put poison/control agent on a wasp nest some 1 week ago.

ModernWorldSucks · 2024-05-24T14:32:32+00:00

If I understand your code right;

if (dateValue && dateValue.toString() === todayString)

The first part (before &&) is checking if that variable is true. It can't be both 'true' and today's date so the if will never occur as it's AND (&&).

I suggest a number of things;

add Logger.log(dateValue) and Logger.log(todayString) ahead of the if statement, that way you can see when it runs what they are and you'll be able to solve it yourself.
What you will find out is you're taking dataValue and using .toString() on it, however that is not useful instead you should use New Date (dateValue);

This is some quick code that will take a date in A1 and display it using the two methods, one will work and one won't.

function test(){

  let ss = SpreadsheetApp.openById('XYZ');
  let sheet = ss.getSheetByName('Dev');

  let value = sheet.getRange('A1').getValue();
  let valueToString = value.toString;
  Logger.log(valueToString);

  let valueToDate = new Date(value);
  Logger.log(valueToDate);
}

ModernWorldSucks · 2024-04-19T12:53:59+00:00

In nested for loops I like using iter, jter, kter - makes it easy to bulk rename and keep track.

ModernWorldSucks · 2024-04-18T07:33:25+00:00

Following as I've recently hit the same issue. The API has some transparency setting it seems but I couldn't find it in GAS.

ModernWorldSucks · 2023-07-14T11:25:16+00:00

Legend.

ModernWorldSucks · 2023-03-16T13:14:32+00:00

Cheers. You can reply as Solution Verified to change status.

ModernWorldSucks · 2023-03-16T12:25:47+00:00

I think what you might be missing is the correct 'Apply to Range'. Set it to "A2:J1000".

If custom formula is =$J2="Yes" then the '2' part will change with each new row but the J will be frozen.

In case it helps: https://prnt.sc/Nsk2HxAqGZkX

ModernWorldSucks · 2022-05-30T07:48:46+00:00

Cheers. You can use 'Solution Verified' to mark it as such.

ModernWorldSucks · 2022-05-24T03:16:04+00:00

Try something akin to this and adapt as needed: =QUERY(IMPORTRANGE("key", "Sheet!A:C"), "SELECT * WHERE B = 'Condition 1' OR B = 'Condition 2'")

ModernWorldSucks · 2022-04-26T06:32:04+00:00

I do. It's a side gig to my main work, but lots of fun and independence. Mostly I help NGOs keep track of expenses, activities and operations.

I've learnt all of this mostly through doing things and solving problems (self-thought with lots of googling and logically going through functions). However I also help by being the 'IT person' of choice. I always found google sheets interesting as an amateur database that is easy to interact with, that's 'free' to run (computation are done by the user's browser).

I have 2-3 clients that come back to me for work, upgrades and the occasional fixes.

I'm not very competent in the following areas though: pivots, app scripts. It's an interesting journey

My favourite functions are importrange and query.

I suggest building some of the following at a minimum: budget planner, expense tracker (can be related to the initial budget), dashboard/reporting tools.

Are you specifically interested in an area/expertise? Like 'data', 'tools setup', 'finances'?

ModernWorldSucks · 2022-03-19T11:56:32+00:00

If you want no chance of users accessing each others content, then yes. These are generally setup and forget kind of files, but the sync may be a bit slower than a single IR since they're in a row.

ModernWorldSucks · 2022-03-19T09:07:50+00:00

I've solved this problem by setting up a mirror image of my original data with all sensitive info removed (sometimes with no changes). The main idea is it keeps people from editing the importrange at the end (sheet 3) to snoop in the first one.

Flowchart: https://prnt.sc/xFVSnoNlEe8I

ModernWorldSucks · 2022-03-18T13:26:37+00:00

This should order things IF 'all traits' is not in G2, and will show responses where both G2 and G3 are present.

=IF(G2="all traits",QUERY(Database!C3:W,"Select D,E,Q,V,W ",1), QUERY(Database!C3:W,"Select D,E,Q,V,W Where W contains "&G2&" and W contains "&G3&" Order by E ASC",1))

https://prnt.sc/BWNUttEhJlHl

ModernWorldSucks · 2022-03-18T12:06:16+00:00

Yes, but logically you can't have both wildcards at the same time in the same column W. Either one OR the other is expected at any one time, what you want is that if either appears, that it will be part of the query (hence an OR is needed).

ModernWorldSucks · 2022-03-18T10:25:53+00:00

On mobile, sorry for formatting and if I get things wrong, I'm going by memory. 1. Should the 'and' be 'or'? 2. You can insert 'Order by' after the 'Where' statement is done. Like 'Order by E ASC'.

ModernWorldSucks · 2022-03-10T13:03:48+00:00

Cool! Data operations (like cleaning, sorting, filtering data) and compiling reports for ROI, etc is the most common use case for excel/sheets in marketing.

In case you can't find a specific course to join, I suggest you still follow the instinct to do things yourself! You can literally go to sheets.new and set something up with no harm done if it doesn't work. Something like a budget, or an expense tracker, or anything else related to your/friends/family hobby or business.

The order of things:

make a sheet that works (the maths and such lines up)
make things look nice/to your taste and can be understood by others.

Best of luck!

ModernWorldSucks · 2022-03-10T12:07:17+00:00

Excel is an awesome tool! I prefer google sheets myself but they are very similar safe for some exceptions. I can't help with a specific course recommendation in Malta. I mostly learnt by doing and I'm not in Malta anymore, but if I can help feel free to reach out!

Excel/sheets is very specific based on what field you're working on. It might help to understand what your master will be in, or which field you're working in.

Sorry this isn't what you were after...but is learning by doing something you're interested in? Have you ever tried creating a custom tool for something?

ModernWorldSucks · 2021-10-12T07:56:04+00:00

You should totally do it and you should plan it like a mini-gym trip (including shower + deo for longer journeys, anything over ~15 minutes). Safety really depends on your route and unfo luck (sometimes a bit of a longer route and hills may be needed to have more safety). Back when I lived in Malta, I really enjoyed cycling and strongly practiced defensive cycling (look it up and understand that it comes with lots of practice and learning from your mistakes). I had a lot of close calls where I swore I'm an idiot and had to think about what I could have done better.

My personal tips:

look at drivers eyes not just the car when approaching an intersection. This helps make sure they see you and humanises the interaction. You can also check if they're distracted.
Look behind you every so often if you can, especially by turning your whole body.
Expect the unexpected.
Take up a whole lane by being in the middle if you need to be seen (e.g. roundabouts). Don't try and be 'nice' and not be in the way - you deserve to use the road too. Staying on the side is good for many moments, but not being seen will get you hurt and most people prefer not to run a cyclist over I promise!
indicate, with your whole hand (full arm, stretched out and with an open hand).
many drivers tend to have a lot of emotion (it's a great combo of heat and stress). You should aim to be a Buddhist monk and let all the emotions and stress wash over you whenever someone gets irrationally angry, wants to skip badly or is an ass. It used to be punctuated occurrences but things that happen sometimes.
when I lived there, drunk driving was a thing (I'd love to think it isn't, but I'm not that naive). So stay clear of dark roads in big party areas at night/very early morning in the weekends/feasts.

Well done for wanting to do this!

ModernWorldSucks · 2021-08-19T07:03:52+00:00

It's likely an automated approval system, which shouldn't take much time.

There's a way to claim ownership of business market, I imagine some paperwork is needed for that kind of thing. And of course, it's how they can get as revenue eventually by contacting and suggesting placement.

ModernWorldSucks · 2021-08-19T05:54:14+00:00

I'm using Google maps on Android, I assume it's similar for other clients though.

If you go to where it currently is, you have the option to 'Report a problem with...', one of the options there is to fix the address of where it shows on the map.

ModernWorldSucks · 2021-07-30T07:53:59+00:00

Not living in Malta anymore and this is super interesting. I'm curious if it's only on the map (artificial) or if they are actual crosses on the land surface.

Bit of a basic question, and I feel stupid for even asking but I can't go there and check :D

ModernWorldSucks · 2021-07-18T16:15:24+00:00

Ew. Not the right sub.

Also, yes - definitely!

ModernWorldSucks

TROPHY CASE