SRG

I helped you yesterday with this UI, this is an extension of my suggestions.

First match the id of the menu items to the id in your toolitems then you can use Array#find() to get the object needed to create your new element. I simplified this only getting some text.

I also used a global draggableOptions object that you can pass to the new element draggable method. The stop event uses the suggestions I provided yesterday of how to loop over all the items to create an array of objects.

The following is not well styled and the items are very primitive but the dragging works as does the logging of array of items meta data that you can store

Try logging into the world without Optifine, walking away from where the creeper exploded, then save the world, then come back into with Optifine loaded. I'm no Java developer, so I'm not sure what this error message means, but it sounds something like it ran out of video memory. Optifine is really buggy around particles in 1.16, so it may be something like that. If I use shaders, I have issues with particles. And I have an RTX 2070 Super. Oh, and be sure you're running the latest version of Optifine for 1.16.4.

When the destination sheet has more data than the source sheet, you will need to clear it before you copy over the data. You could do it with the Range-method ClearContents:

Turns out the decompiled code was in the src folder

Dragging the contents from that into the Client folder worked

I have no idea why it didn't decompile into the Eclipse folder

Using Redim Preserve in the Loop is very costly and time consuming. There is no reason for it. You already limit the size or the output.

Also your problem is that you assume the array starts at 1 but it starts at 0. Which is why you columns are off.

Create the two arrays the same number of rows as the input and just post where they are full. The counters k and p will track that.

Also Dim i, k, p As Long only declare k as a Long the others are Variant

Not going too far from your original method...

(untested but you should get the general idea)

If I understand you correctly you just need a row number partitioned by the patient and then a CASE expression to convert that into a multiplier. I've added an id column to the sample data to allow for an order by (which you need for a row number).

When presented with this kind of problem -- parsing a set of data on one or more Excel worksheets, and summarizing or pasting the results somewhere else -- I find it much simpler to treat the Excel worksheet as a database table, using ActiveX Data Objects.

Add a reference (Tools -> References...) to the latest version of Microsoft ActiveX Data Objects (usually 6.0).

Then you could write code similar to the following:

You can try creating a new list variable with the port number appended to each element, using this approach: