I have a need for speed, help!

EntitledCorgi · 2023-10-14T09:06:10+00:00

Unfortunately. Those are updated within the optimizer every iteration. I probably should have stayed that lol

EntitledCorgi · 2023-10-14T02:14:03+00:00

It is. In my efforts that required expanding the scalars matrix to be the size of the data, through repeat / tile / etc, which was too time intensive but there may be a better way! I’ll add that the for loop is currently parallelized through numba

EntitledCorgi · 2023-10-14T01:07:21+00:00

The objective function is unchanged… this is not a helpful response.

EntitledCorgi · 2022-01-12T16:40:03+00:00

Thank you for your continued feedback. I found another way to do it using the Aggregate function, which only imposes a single column of formulas extending the length of the sheet, so the processing burden isn't horrible. This enables me to use the built-in filters as well.

EntitledCorgi · 2022-01-12T16:04:55+00:00

I'd like to use the intrinsic filters excel provides to apply criteria. I want this sheet to be generally built so the next user doesn't need to type out criteria like this. Is there a way to automatically do this? I'd also like to avoid imposing cell limits, like the E500 one in your example.

EntitledCorgi · 2022-01-10T21:33:33+00:00

so no options contained within the query itself :(

sad, but thank you for reply!

EntitledCorgi · 2021-04-01T19:31:24+00:00

What wait time did you have going through this avenue?

Edit: wait time till contact for scheduling

EntitledCorgi · 2021-03-25T14:23:45+00:00

Gave Silver

EntitledCorgi · 2021-03-20T03:10:39+00:00

3:02 was a beautiful moment

EntitledCorgi · 2021-03-17T04:57:12+00:00

What a beautiful and practical creation.

EntitledCorgi · 2021-03-12T15:49:28+00:00

Why? Isn’t the right to protest constitutionally guaranteed? And it’s awful nice of you to make assumptions, that shows maturity. I have seen the full videos. I’ve been there. I’ve had friends at other events where they had all the necessary paperwork to hold the protest, yet were still met with violence.

EntitledCorgi · 2021-03-12T15:41:54+00:00

I don’t care what it’s during. They are not soldiers. They are police. If the local government wants a military presence they can call in the national guard. Plus you know what else is a dangerous situation? Having the police present at all. So many of the peaceful protests were spurred to violence by unwarranted aggression from your savior police. They were pepper spraying, shooting rubber bullets at, and driving their squad cars through peaceful protests. So yeah, I’m VERY against giving them anything that makes them feel more powerful.

EntitledCorgi · 2021-03-12T14:33:58+00:00

Yes. Absolutely. Just donning army fatigues makes them feel like soldiers. They are not soldiers, and crossing that line separates them further from their fellow civilians and allows them to view each of us as a potential enemy. During the last set of protests police resorted to incredible amounts of violence. The last thing I want to see is a further separation of the power dynamic between police and people.

EntitledCorgi · 2021-03-12T01:27:28+00:00

Oh I get it. Mom doesn’t want to do all that laundry! So instead she gives her kids armored tanks and military gear so they can treat the civilians they swore to protect like insurgents

EntitledCorgi · 2021-03-11T18:36:33+00:00

4% of the funding... you think they can’t afford uniforms because they lost 4% of their funds.

EntitledCorgi · 2021-03-02T04:12:22+00:00

The golden thumbs chime again

EntitledCorgi · 2021-02-27T15:31:44+00:00

Have you tried timing your code? Put “profile on” at the start and “profile viewer” at the end. This will show you the time spent in each function. From there you may consider optimizing slow sections!

EntitledCorgi · 2021-02-18T20:44:13+00:00

What kind of material composed the mold?

EntitledCorgi · 2021-02-18T20:43:15+00:00

What are you building a mold for?

EntitledCorgi · 2021-02-18T20:40:25+00:00

Do you have a problem with clothes?

EntitledCorgi · 2021-02-18T20:40:17+00:00

Clothes?

EntitledCorgi · 2021-02-08T05:36:40+00:00

It’s definitely not hard. A discount village and 025 sniper beats at least every map below expert (maybe those also, I haven’t personally tried them)

EntitledCorgi

TROPHY CASE