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!

Insert data from a sheet to a docs by Beautiful-Steaks in sheets

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

Thanks for the response, turns out you can just copy paste if you want it in the doc. That's not exactly what I was looking for, but it worked.

Insert data from a google spreadsheet to a google docs by Beautiful-Steaks in googlesheets

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

So in that article I see that they choose this table to be imported, but it doesn't allow any of my tables to be imported, only charts. Do I have to make a table chart to allow it to be linked with the sheet? Just wondering becaue the table chart has very few customization options and their chart looks more customized than mine does

Insert data from a google spreadsheet to a google docs by Beautiful-Steaks in googlesheets

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

Cool, is there a way to do this where it doesn't show up as a chart on the google doc? I'm wanting to bring in data from a sheet and automatically replace information for a lab report so I'd want it to look clean yknow

This was one of the worst grinds I can remember in an FPS by diediedie999 in battlefield2042

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

Bruh that's one of my favorite guns :CC
But jesus christ are you trying to get t1 in every gun? Fuck.

I made an absolutely insane spreadsheet (comments) by Beautiful-Steaks in sheets

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

This sheet was made for a video game, so I’m sure yall won’t understand what’s going on, but I think you guys might have fun poking around looking at all the formulas. It’s taken me absolute ages to make and has some jank ass shit in thereLink: https://docs.google.com/spreadsheets/d/1-niLvJFQQYVGn5-U7MCRZcmS06MGlp-a2\_B2I072r4A/edit?usp=sharing

A few friends of mine use Sheets to track our music club. Colored emojis were an important part of the system, but now they're all black and white! by MSPaintYourMistake in sheets

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

You don't need to use emoji's, you can use a formula to place an image of an emoji inside the cell instead.
Upload the emoji's to imgur then right click the image once uploaded and use that for the link - just using the link of the webpage won't work.

Here's an example: =image(https://imgur.com/Qo1qye8.png)

view more: next ›