File: dtn-ssi.png (932KB, 1288x966px) Image search:
[Google]
932KB, 1288x966px
When humanity colonizes other planet would each major planet need there own Internet e.g Mars, earth Venus
13 Posts / 2 Images
View this topic
>>
Information speed is capped at c, the speed of light
so there would be massive lag if you managed to send information between the planets
>>
>>
>>9164362
good point
Hi all,
I'm looking for /sci/'s finest MS Excel savants who could potentially crack a painfully annoying issue I have been facing on a daily basis. To put it briefly; I work with sets of data on MS Excel on a daily basis and I frequently have to use the CTRL+F solution to find the criteria I am looking for so I can subsequently replace it with another value. Take the following example:
I have two spreadsheets open- A and B. In spreadsheet A I will have to CTRL+F the word 'unknown'. This will give a result which will contain the word unknown (of course) among other information which I require i.e. 'ABCCorpeation;Unknown;ID1234'. I then manually CTRL+C the ID value at the end of this string of information and open up spreadsheet B. I again CTRL+F and instead of searching for 'uknown' in spreadsheet B, I paste my copied ID. Spreadsheet B is a very simple spreadsheet which just contains IDs and names, so when I paste this ID it gives me a single result and in the column beside it, I can copy down the name associated with the ID. I then go back to spreadsheet A and replace the word 'unknown' with this copied name. Then I would move on.
I assume you struggled to read through that cripplingly long-winded description of my task, but that is an issue which I have to laboriously tackle every day. To add to my woes; the spreadsheet 'A' I describe is actually dozens of spreadsheets which I look for the word unknown in and replace with an actual name after matching it with its corresponding ID.
So my big question is; is there any way that this could be conceivably simplified using a several nested functions, because to date I have been struggling to do this or even fathom how to tackle it or what to use. Please /sci/, help this MS Excel goblin ease the pain in his fingers. Any advice would be truly appreciated
16 Posts / 1 Images
View this topic
>>
>>9164304
You could use VBA, or C# (adding reference to the office assemblies).
/g/ could help, but they'll give you shit at first because LOL, not FLOSS
>>
Several possible ways, ordered by increasing complexity and timeconsumption (2 minutes to 1-2 days of work)
A) Check out the vlookup-Function and its documentation
B) Design a pivot table to do what you wish
C) Write a custom macro
D) Write a C# program that parses your Excel-File and returns a new excel-File with the desired result.
>>
>>9164321
Thanks man, I might holler at /g/ alright. VBA was the method I was thinking for this one
>>9164323
Cheers pal. I'm aware of how VLOOKUP works, but i'm struggling as to how I would implement it when the data is not only separated by semi colons, but that the task I'm performing takes place over so many spreadsheets. Thoughts on how vlookup may be written to attack this issue?
File: 1501069672282.jpg (214KB, 1054x1500px) Image search:
[Google]
214KB, 1054x1500px
Math majors and working mathematicians come in here please.
So I'm 19 and going back to school January. I thought since most people aren't that good in math and I practically have 4 months of free time. I want to get really good at math and major in math. The market can't be saturated, not a field where employers can pull the "you're overqualified" bullshit, they're all high paying jobs, probably no grad school so less debt and I become a better critical thinker. No one is born a fine artist neither, sure some folks are gifted in mathematics, but after learning the reason most folks are bad at math due to laziness. I really want to be good at it. /adv/ is full of depressed people who only talk about relationship problems. So I know I'm at the right place. Thanks in advance.
30 Posts / 4 Images
View this topic
>>
>>9163819
I'm 19 too, 4th semester sophomore, pure mathematics. I say sure, go for it. It is literally impossible to not get a job with a math degree (but you shouldn't get into math to get a job). If you want a kickstart get a geometry book (proof based) and study it. Euclidean Geometry is amazing to teach the essence of math. Also, I don't mean coordinate geometry. I assume you already know algebra so coordinate geometry won't help you. I mean pure axiomatic geometry, so that you learn the more abstract way math is done.
Other than that, if you get into math prepare yourself for the existential dread. Let me tell you something about me. When I was 5 I was diagnosed a genius. I attended special genius schools. I attended prestigious private high schools. I had all the odds in my side, and now I am succesful as a math major but you want to know what I am compared to Terence Tao? A piece of shit. What I am compared to Gauss? A retard. What I am compared to Riemann? A disgusting worthless ant that has no value at all and will die with no one caring for it.
I have to live with that every day. Could you live with that? Could you stay happy with those thoughts killing you from the inside? I can. Can you?
>>
>>9163819
There are jobs you can get with a math degree that still pay like shit. Teaching, for example. Grad school can pay for itself, and graduate level math classes are really where you get into meaty, interesting problems. Undergraduate math is all introductory or survey courses, rarely (if ever) developing theory from a fundamental level. If you're going to major in math, at least minor in computer science (or just take some CS electives). The courses at your CS department are not going to be mathematically rigorous, and they'll be full of the most annoying autistic weebs you will ever meet, but they will teach you skills you're likely to need. Look into undergraduate research assistantships. They'll give you a glimpse of what grad school is like, letting you make a more informed decision about whether or not it's for you.
>>
>>9163888
Jesus Christ get off of the internet and go socialize please.
File: 1504700148952.gif (2MB, 252x252px) Image search:
[Google]
2MB, 252x252px
How hard is it to get a reasonable working understanding of quantum mechanics? Is this a worthy goal for the pure intellectual sake of it if you aren't a physicist and your profession is in another field?
I feel like it's kind of an ultimate goal of mine but I don't know how long and arduous this road is.
Background: Bachelor's in CS, currently in the process of beginning to self study a Bachelor's in Mathematics
13 Posts / 2 Images
View this topic
>>
If you understand linear algebra? Idk about 2 hours?
>>
>>9163575
I found this guy's lecturing style easy to follow.
https://www.youtube.com/watch?v=gCAxGTt7nLg&list=PLOarn8QL6W_ImlqPOMluvxIUx9hkWMiTY
>>
>>9163575
>Background: Bachelor's in CS
I am so sorry.
File: NO_FILE_GIVEN (0B, 0x0pxpx)
0B, 0x0pxpx
If a human was born 10 times the size of other humans, and somehow didn't die, would their brains be noticably more powerful than normal sized brains?
Pic unrelated
39 Posts / 4 Images
View this topic
>>
>>9162975
This is all assuming the human is at perfect health and can allocate respurces properly in their massive body, btw, don't become a premise pedant
>>
>>9162975
>allocate ressources properly
This is your island savant with existing people.
Useless in other fields but way above in the one were all ressources go. Same result as if you would upscale the brain but keep the ressource allocation normal.
Btw if you are interested in a real example of bigger brains with people look at neanderthal. They had bigger brains but research says it was allocated different so not quite what you're looking for.
>>
Connectivity is more important than size
I have 300$ and I wan to try a super combo wombo for health & cognition.
I plan on buying
>Selegiline
>SAM-E
>MK677
>NSI-189
>Tianeptine
>Magnesium
>Vitamin D
>Vitamin B
>Choline
>Melatonin
What would you add or remove? Anyone tried mixing all of these together?
67 Posts / 19 Images
View this topic
>>
>>9162962
>/x/
>>
File: 1502416918199.jpg (195KB, 1080x1080px) Image search:
[Google]
195KB, 1080x1080px
>>9162965
What do Nootropics have to do with /x/?
>>
>>9162969
They're pseudoscience.
File: hotline_miami_rasmus_art_mask_owl_minimalism_98193_3840x2160.jpg (1MB, 3840x2160px) Image search:
[Google]
1MB, 3840x2160px
/sci/ Is it normal for me to constantly be hearing music in my head and being able to remember the timbre of all instruments, on top of hearing the song fully?
Would this be a reason to learn how to play an instrument, or is it just a normal thing everyone experiences?
55 Posts / 13 Images
View this topic
>>
I have always had that shit since I was a kid.
It's a mental disorder.
You'll get schizophrenia if you don't treat yourself.
And you don't want that.
>>
>>9161687
Are you just trolling me now?
>>
File: 1453422025072.jpg (11KB, 250x250px) Image search:
[Google]
11KB, 250x250px
>>9161687
>>9161697
Bump
File: Organians.jpg (34KB, 700x529px) Image search:
[Google]
34KB, 700x529px
Why isn't science and intellectual inquiry at the forefront of the public mind? I'm sick of excuses being made for anti-intellectuals and pseudo-intellectuals. The topics being denied by the public to the detriment of society and the environment are not advanced. They are high school level let's make no mistakes here. And these people do not understand them
Why is education not a primary concern of the US? Please explain this to me. Do these people not realize the amazing use cases for mathematical and scientific knowledge? Do they not comprehend that adherence to the intellectual status quo holds our species back from reaching its full potential
I can go on and on for hours about this and it's beyond frustrating in a way that is just demoralizing and disappointing. What can be done?
How can we fix this? I'm so sick of this. Is it just a problem of the fact that the average IQ of our species is relatively low and the only people who understand what's going on are at the high extremes? How can we overcome this without trampling the rights of the unwashed idiotic masses?
95 Posts / 11 Images
View this topic
>>
>>9161430
>Why is education not a primary concern of the US?
the American Left likes to "educate" people into ignorant, mindless sheep since such people are easier to tax
>>
>>9161430
>the average IQ of our species is relatively low
but the average is defined to always be 100...
>>
File: 1501546673610.jpg (40KB, 780x454px) Image search:
[Google]
40KB, 780x454px
>>9161430
Why do we have a narcissistic anti-intellectual uneducated buffoon running the most powerful nation on Earth? Why are we allowing him to appoint a woman fundamentally against education, as the head of the Department of Education? A person fundamentally against environmental restrictions on businesses, as the head of the Environmental Protection Agency?
Why is this happening? What has gone wrong? Is democracy just broken? Have we allowed ourselves to get intellectually lazy as a society and years of standing by as conservatives pumped out anti-intellectual propaganda through the radio and television waves has condemned us to mediocrity?
Literally what the fuck is happening that we are allowing this to happen
File: 1483345825456.png (127KB, 601x508px) Image search:
[Google]
127KB, 601x508px
I still don't get why multiplication is commutative?!
Why is 5+5+5 equal to 3+3+3+3+3
151 Posts / 15 Images
View this topic
>>
>>9158085
Because it's defined that way.
>>
>>9158085
PRIME NUMBERS
>>
>>9158088
also 15/5=3 and 15/3=5
File: 1504463472823.jpg (210KB, 1179x742px) Image search:
[Google]
210KB, 1179x742px
How are you people dealing with the saturation in STEM, especially in the US?
Everyone and their mother is being memed into getting a science degree, and the job market simply can't handle it.
None of my friends who did mechanical engineering found jobs yet, same with my chem E friend, and it's been 6 months since graduation.
The only one in my group of friends that has a job in his field is a comp E, but even then he's only making like 40k, 20k less than the average for a new grad 5 years ago.
I decided to get my PharmD and I'm seeing that it's literally fucking impossible to find a job as a pharmacist anywhere but Texas and Alaska, the market is simply too saturated; too much supply and not enough demand.
Stem degrees aren't cheap, I was on a full ride in undergrad and I'm most likely going to finish grad school with 120k in debt.
What are you /sci/entists planning to do once you finish school? This shit literally keeps me up at night and the apathy is starting to affect my desire to study.
314 Posts / 41 Images
View this topic
>>
>>9146515
>What are you /sci/entists planning to do once you finish school
Dunno lol, I'll figure it out once I get there.
>>
>>9146515
>None of my friends who did mechanical engineering found jobs yet
Hey don't you dare scare me ok
>>
>>9146515
I focus on what I can control and do my best at it.
File: compskel.jpg (16KB, 300x240px) Image search:
[Google]
16KB, 300x240px
I'm in my mid 30's and went back to community college a few years ago, decided to major in Computer Science. I'll be transferring to a good University next year.
My question is: Can I earn a living wage while being competent at my profession? I'm not a genius but I have straight A's in everything CS, MATH, Physics, etc related, so I think I can at least function.
Or do I need to "stand out" and out perform everyone while working ungodly hours weekly just to keep my job. I really just want to live and not make my job my life.
9 Posts / 2 Images
View this topic
>>
>>9165342
>As in Computer Science, Physics, and Mathmematics courses taken with young people (age 18-22).
>I'm not a genius
You are actually quite smart to get A's while being over 30 years old and competing with young people, you know that right?
>>
>>9165342
>decided to major in Computer Science
I am so sorry.
>>
>>9165348
Is it true that in Computer Science there is no *science*, and there's no... *computer* as well...?
File: 1438606616751.jpg (74KB, 800x400px) Image search:
[Google]
74KB, 800x400px
What would happen, if a sun made out of ice would collide with a normal, lava made sun?
The stars would be exactly the same sized and the overall temperature of the sun made of ice would be -1000 °C and the normal sun's would be respectively 1000 °C.
Would the suns annul each other so that only empty space would remain or would a sun of zero °C spring up?
8 Posts / 2 Images
View this topic
>>
it'd turn into saturn. it's on the bottom right of the picture, idiot
>>
why the arbitrary temperature of 1832F and -1768F? does something happen at that temperature you didnt mention in op?
>>
>-1000 °C
I expect many interesting things to happen even without collision.
File: IMG_4454.jpg (95KB, 720x840px) Image search:
[Google]
95KB, 720x840px
Holders of bachelor degrees in math, how much harder than calc 2 does a math degree get? I've done well in everything so far but I'm just curious how much harder it would get. Does the switch away from mostly algabra based problems mess with you?
6 Posts / 1 Images
View this topic
>>
>>9165218
Intro to proofs is to analysis as Calc 2 is to multivariable and diff eq.
I think that the difficulty is the same or easier because hopefully you reach a level of maturity such that the difficulty comes from volume of work more than application of ideas.
>>
at the undergraduate level many of the proof problems are still "algebra based" that is, they are proofs by symbolic manipulation.
on the whole though, the difficulty depends on the school. If you go to a serious school and get hit with hard real analysis (rudin tier stuff) then it will be pretty difficult, atleast relative to the average math student's capabilities.
>>
>>9165221
I'm going to a pretty decent state school. Then the next issue is figuring out what I wanna do with this degree because I'm not interested in any more schooling and I'd rather die than become a teacher.
File: NO_FILE_GIVEN (0B, 0x0pxpx)
0B, 0x0pxpx
Did you get a minor in college? What was it?
Do you think it was worth it?
21 Posts / 3 Images
View this topic
>>
Wish I could get a minor, too bad I have few attractive qualities and have no game. Know some guys who pull minors every weekend at 24
>>
>>9165048
Chemistry minor
I'm a doctorate holder in Pharmaceutical Science
I don't use it and it isn't on my wall certificate.
>>
>>9165048
I did a minor in art, and I also got an EMT-B during a summer, which I sort of consider another minor. The art classes got me out of the math zone and in touch with some really cool people who are still my friends 3-4 years after I finished my degree (whereas I never talk to any of the people I met through my major). I also considered applying to medical illustration programs for a while, but ultimately decided it wasn't a direction I wanted to take.
The EMT was a cool experience and enabled me to work Friday nights letting chads puke into my bucket and reporting them over to the police.
File: 1504718092707.jpg (27KB, 550x535px) Image search:
[Google]
27KB, 550x535px
>some jew slaves build structures that are impossible unless modern machinery is used around the world in all continents (including antarctica) that need mathematical knowledge that wasn't invented until milenia after in just a couple of years using animals or in some cases simply human force (there wasn't cargo animals in america) that somehow correlates physically with undiscovered star constelations until XX century that makes a perfect alineation thousands of years before babilon using rocks and materials that wasn't available in the location
>sci chooses to ignore this and believe it was the joos who build the pyramids using ropes
13 Posts / 2 Images
View this topic
>>
>>9164972
I don't think any historians actually believe jews were slaves in Egypt.
>>
>>9164990
It says it in the Bible
>>
>>9164990
Not only that, but not even the BIBLE says that Jews built the pyramids. It says that the Jews built the cities of Ramses and Pithom.
The "Jews built the pyramids" is christardation revisionism at its finest.