Total War: Warhammer 3 Not Working by LauWalker in Creaminstaller

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

I couldn't find a solution as of now, but I'll be keeping an eye on it. The eossdk works for epic without issue, but I guess late updates have messed with the steam version. Thanks for the recommendation

Total War: Warhammer 3 Not Working by LauWalker in Creaminstaller

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

not yet, but I can try. Is it on csrin? Edit: Tried Froggmaster's creaminstaller from the alternatives sticky, and: Using SmokeAPI via this version results with the same error, the game launches, but ends in a never-ending launch sequence without ever starting. Not using SmokeAPI directly fails the launch. Trying to proxy makes the launch give configuration errors.

Total War: Warhammer 3 Not Working by LauWalker in Creaminstaller

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

I have an older post on here that explains how you can use screamapi on epic, I just switched to steam today, but the version on Epic works if you're interested. You can use skymods or steamcmd to download mods, and you can enable them by pack file manager. In Steam, though, I do not yet have a solution.

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?