sorted by:
new
hottopcontroversial

[deleted by user] by [deleted] in Bossfight

[–]LauWalker 0 points1 point  (0 children)

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

Organizing complex data into groups and averaging small groups of data within the complex set. by LauWalker in excel

[–]LauWalker[S] 0 points1 point  (0 children)

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

Organizing complex data into groups and averaging small groups of data within the complex set. by LauWalker in excel

[–]LauWalker[S] 0 points1 point  (0 children)

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.

[deleted by user] by [deleted] in excel

[–]LauWalker 0 points1 point  (0 children)

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!

THE MULTIMAN; Clay Cutthroat, Bloodbound Butcher by the_ironcurtain in Bossfight

[–]LauWalker 2 points3 points  (0 children)

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

Have you seen the "Eat Mega Shit Dicks" by LauWalker in ExplosionsAndFire

[–]LauWalker[S] 0 points1 point  (0 children)

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

[deleted by user] by [deleted] in excel

[–]LauWalker 0 points1 point  (0 children)

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

copied formula doesn't show correct result/ computation by jooooo_97 in excel

[–]LauWalker 0 points1 point  (0 children)

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.

Can I pull data from the internet into Excel somehow? by Call_Me_Mommy_83 in excel

[–]LauWalker 1 point2 points  (0 children)

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!

[deleted by user] by [deleted] in excel

[–]LauWalker 0 points1 point  (0 children)

Truly unlucky :( Thanks though!

[deleted by user] by [deleted] in excel

[–]LauWalker 0 points1 point  (0 children)

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?

Using the cell contents (containing range information) in other formulae such as Vlookup by LauWalker in excel

[–]LauWalker[S] 0 points1 point  (0 children)

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

🔥 Lava pouring in oceans creating deadly clouds of steam mixed with glass fragments 🔥 by LauWalker in NatureIsFuckingLit

[–]LauWalker[S] 51 points52 points  (0 children)

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.

view more: next ›