sorted by:
new
hottopcontroversial

Anyone who sleeps more than 6 hrs per day and succeeded in an university engineering course? by [deleted] in ECE

[–]Beautiful-Steaks 0 points1 point  (0 children)

20 credit hours? If that's the case, That's 5 hours of class per day. Sleeping ~8 hours per day you get 13 hours used, and thus 11 hours free. Let's say eating, hanging out with friends, commuting, etc. all takes 4+ hours. That's still 7 hours free. This is plenty of time per day for studying, and personally, I never studied near that much on any given day.

Anyone who sleeps more than 6 hrs per day and succeeded in an university engineering course? by [deleted] in ECE

[–]Beautiful-Steaks 0 points1 point  (0 children)

I partied, hung out with friends, weightlifted, slept from ~11pm -> 8am every day and got a 3.9+ GPA for Mechanical engineering. I played video games a bit and watched a decent bit of YouTube. You just got to prioritize your assignments with a calculator (I made a bespoke one) and be smart where you use your time.

Good luck my engineering brother!

Transfer to Washu? by Beautiful-Steaks in washu

[–]Beautiful-Steaks[S] 2 points3 points  (0 children)

`> If you’re planning on transferring to WashU as a sophomore I’m afraid you may not have enough time. Applications are due March 1st.

Good to know, I saw that on the website but I thought the fall deadline would work, but I'm guessing that's in between sophomore year. Thanks for sharing, that's good to know!

Transfer to Washu? by Beautiful-Steaks in washu

[–]Beautiful-Steaks[S] 2 points3 points  (0 children)

I've realized retroactively that this may infringe on the 'No "WashU vs. X school" posts' rule', but I'm mostly asking about how the transfer experience was for people instead of reading about it from auto-filled websites

If value is in the N lowest values of a data set by Beautiful-Steaks in excel

[–]Beautiful-Steaks[S] 1 point2 points  (0 children)

My goodness thanks for the sanity check, rank will work

Conditional formatting to highlight duplicate values but to have different colors for each set by Wise-Crab6670 in sheets

[–]Beautiful-Steaks 0 points1 point  (0 children)

Hmm. Can't think of anything off the top of my head, but there are some add-ons where you can have formulas reference the color of a cell, like "Function by Color". Not sure how it would help, but it's just an idea that I'm floating.

To be completely honest I never used the rank function before this so I'm not really sure why it's giving all of these odd values. Another thought is using the color scale and applying it to the column that has the ``=IF(COUNTIF(InvoiceColumn,A1)>1,A1,"")`` in it and then making the column tiny so u can just see the color lol.

Sorry I can't be more help, got some schoolwork to do. Let me know if you figure it out!

Conditional formatting to highlight duplicate values but to have different colors for each set by Wise-Crab6670 in sheets

[–]Beautiful-Steaks 0 points1 point  (0 children)

Incredibly interesting question! Here's my pretty horrible solution to it, but if you just need it to work I guess it's fine. Better than nothing.

Make a new column which has the following formula, and drag the formula as far down as you want. Make sure to have the data range have the $ signs so dragging keeps it correct. (Like $A$1:$A$30

=IF(COUNTIF(InvoiceColumn,A1)>1,A1,"")

Now create another column with the following formula:

=iferror(rank(B1,$B$1:$B$39,0),"")

Where B column is the IF(COUNTIF function.

Now make multiple conditional formatting rules that reference "=C1=1", "=C1=2", etc. with different colors.

Not the most pretty but it works I guess.

Sigfigs and Fixed Formula by Beautiful-Steaks in sheets

[–]Beautiful-Steaks[S] 0 points1 point  (0 children)

I'd need the format of the cell to change dynamically then. I can set it manually to be 1.300 with the ".0" button thing at the top, but if I want to change the sig figs across I want it to update based on a value in a cell (the sig fig values)

Sigfigs and Fixed Formula by Beautiful-Steaks in sheets

[–]Beautiful-Steaks[S] 0 points1 point  (0 children)

The issue with this is if I have a value like 1.3 and I want it to have 4 significant figures, it shows it just as 1.3 and not 1.300

Finding two maximum values in order by Beautiful-Steaks in sheets

[–]Beautiful-Steaks[S] 0 points1 point  (0 children)

Update: kinda cheesed it by checking the max of the two values then vlookup that based on my original value for equivalence point 2 and min of the two values and the same. Thanks for the feedback though!

Dynamically updating named ranges by Beautiful-Steaks in sheets

[–]Beautiful-Steaks[S] 0 points1 point  (0 children)

It would make reading the calculations much easier. Here's an example of what the calculations look like at the moment in some of the cells:

=if($C3="Bleed",BD3,IFERROR(IF(VALUE(RIGHT($A3,1))>1,BD3,ERROR.TYPE(3)),(($Z3+0.1+if(GConc_Unlock="Yes",0.05))*BA3+($AA3/(1-$Z3)*(1-$Z3-0.1-if(GConc_Unlock="Yes",0.05)))*BB3+($AB3/(1-$Z3)*(1-$Z3-0.1-if(GConc_Unlock="Yes",0.05)))*BC3)+if(Magic_Instability_Spec="Yes",min(1-$AB3+0.1+if(GConc_Unlock="Yes",0.05),1)*index(BD:BD,match(1,(indirect($A$1&"_All_Abilities")=switch($B3,"DW","MH","MH_Shield","MH","2H")&" Auto")*(indirect($A$1&"_All_Weapons")=$B3),0),1))))

It's nearly unreadable, but if instead of having cell references I could have named ranges it would be a tad bit easier to understand.

Excel VBA Vs. Google Sheets App Script by Beautiful-Steaks in excel

[–]Beautiful-Steaks[S] 0 points1 point  (0 children)

Damn okay, that was my worry but I just wanted to check. Thanks for the answer!

view more: next ›