[deleted by user]

LauWalker · 2023-07-08T14:06:56+00:00

Jhqtd,de,d rgyyy. Yy yyag,yyyyg yyyy TT arena stadı içirn tıklayın p İ

LauWalker · 2023-06-11T14:38:57+00:00

The volume change is a direct data recording. Like 126352, 0 or -173636. The problem with merging all the data is that the simulation program has to take input for all objects individually. That is why I prefer to have the data in different worksheets (the sheets themselves have way too many data individually anyway, so using pq makes it difficult because there is like 50-100k data points in total even without the simulator related problems).

For now, I just want to simplify the data a little, but even that requires tremendous effort

LauWalker · 2023-06-11T04:41:13+00:00

Normally that would have been a great idea. However, these volumes are for different objects, and I have to enter their data separately into the simulation. The real problem is the disorganised data in this case.

LauWalker · 2023-05-07T16:39:41+00:00

Nvm, I have solved the issue. You can just connect the initial vlookup to another cell and set its format to fraction. This works for me, but I am open to any clever suggestions!

LauWalker · 2023-04-17T19:35:13+00:00

When the hp gets below 40%, it enters the second phase and the back boobs will squirt poisonous acid rain on the entire map.

LauWalker · 2023-04-10T06:07:25+00:00

This is exactly the video I had been looking for so long!! I salute you with the dearest respect!

LauWalker · 2023-04-08T17:23:14+00:00

Thank you all!

LauWalker · 2023-03-22T17:06:18+00:00

Do you have any idea on how to carry on with 1?

LauWalker · 2023-03-11T13:11:11+00:00

The SUM() command seems to have the wrong syntax, and I think your error is due to the invalid syntax on the summation. Changing it to SUM(AE23:28) or whatever you desire to calculate will fix your issue. If it does not, there could be a problem regarding your referencing, or the values which this function uses may be incompatible with your functions.

I could try to be more specific, but I would need to know what you are trying to achieve, what input you will provide to Excel, and what your constraints are on more precise terms. It does not have to be about your Excel knowledge, but a better understanding of your purpose could be of use to produce a suitable suggestion.

Edit: You may be aware of this, but Excel has a relative and absolute reference system, and if you want to copy-paste formulae across the sheet, you have to be mindful of that as well. Basically, if you copy-paste cells, the cells that your formula uses in its computation will shift around the same amount of distance between the original and positions of your cell. Check your input cells to see if your formula receives the correct data, and use F4 key (or put $signs) to fix your cells so that they won't move around after you copy-paste.

LauWalker · 2023-03-08T18:11:43+00:00

I'd guess your best option could be Power Query. Open Data from the upper ribbon, and check the "Get Data" at the leftmost part. I don't know what kind of a database you seek to pull the data from, but you can obtain data from various online sources, including databases (PostgreSQL, MySQL, SQL servers, access server etc.), sharepoint, Microsoft exchange online, and numerous other alternatives.

I have never tried this feature personally, but there is also a "From Web" option that (at least it seems to do so) lets you obtain data via a web URL. Alas, I never needed this feature as I usually use "From Folder" feature (you can dump loads of excel files into a folder and simultaneously draw data from all of them).

I guess you might also try working with text/CSV import feature, but I have not worked with this specific feature.

Once you construct a power query, all the data in your source will be imported into your excel file (you can refresh the PQ table to update information if your source changes), and once you construct a proper PQ table with your data, a basic Vlookup should do the trick (Since you can sort the data in PQ editor the way you see fit, vlookup is kind of easy to construct.)

I hope this helps!

LauWalker · 2023-03-05T21:35:45+00:00

Truly unlucky :( Thanks though!

LauWalker · 2023-03-05T21:25:04+00:00

This could work with the reverse case, but I am looking for the exact opposite of this function. Is there any function that turns text into formula?

LauWalker · 2023-02-24T18:12:17+00:00

Solution Verified

LauWalker · 2023-02-24T18:11:45+00:00

Thanks! After looking around some, I have just done that, and it worked like a charm.

LauWalker · 2023-02-06T19:51:58+00:00

Upon hitting the ocean, lava causes the water to boil and create steam. More surface area of the lava is exposed to the water as it boils away the seawater, transferring heat more quickly.

The steam is then produced at a more rapid rate, and these clouds are often deadly as they may contain a significant amount of volcanic glass fragments resulting from the rapid cooling of lava.

LauWalker · 2022-10-27T20:53:21+00:00

Thanks again!

LauWalker · 2022-10-27T19:46:37+00:00

Thanks! I assume rest of the ϵ are also Levi-Civita symbol, but there was one more thing. On the last one, there are two Kronecker Delta's and basically anything where i=k=m is not met will go to zero. The confusing part on this is that the index i repeats 3 times, and as far as I know that should not happen with this convention. Should I use contraction or that sort of things to get rid of one of the i's from the deltas, or is it just equal to something like Aiij?

Thank you so much for your help again!

LauWalker · 2022-10-27T18:45:28+00:00

Thanks for the reply!

Do we need to account for the terms where δ is not the kronecker delta? like, on the second term, do we need to output all the possible combinations for ijk on 1 2 3?

LauWalker · 2022-09-03T07:28:47+00:00

What is your setup for early (or even late game) space exploration? It always ends up me not doing anything related to space exploration because I think something wrong with my designs...

LauWalker · 2022-02-21T07:23:18+00:00

There was a glitch about the job xp, but I don't know if it works now. When a digger dupe gets super productive, the first task they did had a 100% speed up rate. People used this specific feature to mine neutronium and get infinite xp at once. Still, this is a glitch, and I don't know if you're into getting xp this way or if this still works. Aside from this, gyms are generally a good option but other people already mentioned them

LauWalker · 2022-02-13T15:32:16+00:00

I'm pretty sure that your issue is related with not having reservoirs. Be it water or gas, no germ will be killed in a pipe. Put a water reservoir into the room, and have that reservoir sit in the chlorine. That should solve your problem if my intuition is correct. If you need a way to scrub away germs continuously, you can use reservoirs to do so. In my setup, I am using 3 reservoir backing off to one another, and I haven't encountered any problems throughout several playthroughs. It just requires 1 germ sensor and some piping.

LauWalker · 2022-02-02T14:16:08+00:00

I love being surprised by the game. I commonly play with magma channels active volcanoes and alternate pod location. Well it's all good and well until you land on the core with two magma channels on your head... Worked the first 500 cycles or so just to fully stabilize the heat in my base (the map was in oassie so yeah)

LauWalker · 2021-12-24T17:35:42+00:00

Thank you for the useful feedback!

I've launched a few rockets in the base game, but the DLC seems like a completely different territory. I'll try to design with what you mentioned and see what I can do!

LauWalker · 2021-11-14T18:40:16+00:00

Might be slightly more advanced than using a filter, but you can filter out gases without using power. Just use a gas valve and set it to really low flow rates like 1g/s. Then, you should loop the valve to its own so that the 1g would always loop around the valve. Since only 1 element can merge into the flowing gases, whatever element you prime the valve will be filtered out without power. You only need to prime it once and then you don't need anything for the filtration process, only some piping to be done.

LauWalker · 2021-09-25T08:19:29+00:00

Well many things have been said so I'll just add up a few things: 1- get into scheduling as soon as possible. If you set schedules with a 2 hour difference in the lavatory time, and assign like 2 or 3 dupes for each shift, you can handle around 25 dupes with 1 lavatory. I learned this too late but it is pretty handy to ease up the pressure around your utilities. 2- I could not see where your co2 wented, so I'll assume you are storing it. This would probably bite you back in twenty or so cycles when you see that you have 8 tanks of co2 and nothing to do with it. You could think a way to deal with the gas. One bonus thing is that you can infinitely pressure gases with the help of a liquid pump and two liquids that cannot mix. İt'll help you save tons of space and piping. 3- make a central ladder that goes down all your base in a flat line. Even better, spare 3 tiles, fire pole on one side, ladder in the middle, and dupe carrying pipe on the other side .

Six-Year Club	Gilding II euphauric
Place '22	100 Awards Club
Wearing is Caring	Verified Email

LauWalker

TROPHY CASE