Where am i supposed to get the Fate/zero visual novel?
>>97121
does it even exist?
It's a light novel, not a VN
>>97127
my life was a lie
>saving thumbnails
Excel help needed-
What I'm trying to do is create a spreadsheet where as entries are added on the first sheet, there will be a "yes or no" drop down near each name. Any of the names where the user selects "yes" will then automatically populate into the second sheet, which will have similar columns, but not quite the same. The goal here is that sheet 1 will be a large sample of individuals, but only some of them will be identified as "more info needed", so they can get grouped into sheet 2.
Thing is, it has to be set up so that names can continually be added or removed, without having to copy formulas every time. Any ideas? Screenshot related- I can't post the actual document cuz it's for my job, but here's an example. Thanks a TON for any input.
>>97111
Fundamental principle of programming: DRY.
Don't. Repeat. Yourself.
Less succinctly, "every item of data should be defined in one, and only one, place".
What this means for Excel is that you should not be creating or updating copies of your data.
What you should be doing instead is keeping all your data on sheet 1, and inserting a pivot table into sheet 2 that /references/ sheet 1.
Google "introduction to pivot tables", because a pivot table does everything you need to solve your problem.
Also, if you're using Excel in your job and don't already know this, for heaven's sake read a book on Excel. There'll be a million things Excel could be doing to make your life easier, but you're not using them because you don't yet know they're possible.
>>97111
Also, check out Excel's data integrity constraints. If your column should only ever say "yes" or "no", you can apply that constraint to a column, and Excel will make it impossible to enter any other value.
It can also simplify data entry by turning every cell into a dropdown with only the valid options available.
>>97114
>>97111
>The goal here is that sheet 1 will be a large sample of individuals, but only some of them will be identified as "more info needed", so they can get grouped into sheet 2.
If you're planning on doing this, store the actual data on sheet 1, and hide the columns. DRY.
It's way easier to keep all your data in one place than to keep some kind of relational mapping between two sheets when you don't need to.
i've been busy with work since i moveed to japan last year.
could someone tell me what anime that have aired recently that are good?
as you know its "hard " to download anime in japan.
i watched gate already on my phone with oneseg, but what happened to the second season of Suisei no Gargantia?
is there anything amazing in the last 8 months besides that and hero acadmia?
Shouwa Genroku Rakugo Shinjuu
>>97104
>what happened to the second season of Suisei no Gargantia?
I imagine the trainwreckishness of the first season precluded it.
>>97109
This
Also Haikyuu, Akagami no Shirayuki-hime S2. Concrete Revolutio was pretty good but S2 looks like it'll be fantastic, so I'd say it's definitely worth it to check it out along with S2, but it's fairly polarizing, either you love it or you hate it because of the way the storytelling is set up.
Saying that, a bit on the edge of your timeline Rokka no Yuusha and Non Non Biyori Repeat were both really good as well.
Is there a program or browser addon that dumps images to 4chan that works with reCaptcha?
>>97098
No.
4Chan X
>>97110
That's what i use, but it's pretty uncomfortable. You can't choose a folder and you have to check back every picture because the Captcha is only valid for a limited time.
>Zenphone 2 32GB - US$ 290
Should I buy it?
No, you can get a better deal with the samsung galaxy S4 ($179) from the best buy website:
http://www.bestbuy.com/site/boost-mobile-samsung-galaxy-s-4-4g-lte-with-16gb-memory-no-contract-cell-phone-white/9130016.p?id=1219700124139&skuId=9130016
1080p screen
accepts 128GB microsd cards
16GB internal/2GB RAM
removable battery (you can use bigger zero lemon batteries)
1.9GHz 4-core krait 400
adreno 320
13MP camera
The zenfone 2 is nice but only worth it if you get the 64GB version with 4GB of RAM. But last time I checked it was like $350.
The 64GB is $300 on amazon
>>97086
>snapdragon
Dropped.
http://wccftech.com/security-exploits-put-snapdragon-powered-devices-at-risk-of-hacking/
Do you know any web developers that don't make your website look like college-tier b.s.?
Thanks,
Concerned Junkie
>>97049
Yes.
>>97059
Would you elaborate?
>>97060
I am one (well, more of a general custom software dev, but that does include web applications and sites).
I also have a few friends who are quite solid web devs.
What of it?
Hi, I'm from Germany here and got some toast with this clip you see in the pic (my sis bought it on Monday in an American store)
Can you please explain what the numbers on the stamp mean and until when the toast will be good. Thanks.
>>96940
There isn't a universal format for bread clips. Every company could have its own way of creating the bread clips.
I'd imagine the 4 and the 7 correspond to March 7th but your guess is as good as mine as to what the day refers to.
Are you sure there isn't a date on the actual bag the bread came in?
>>96940
it's good till it smells bad or starts turning blue
I'm looking for a manga drawing of a red-eyed girl who's making a cake and is cutting her wrist into a mixing bowl.
The drawing has a very mild amount of blood in it and the girl looks pretty happy about the whole thing.
>>96908
I have it, just a min I don't sort my images
>>96911
Godspeed anon
It's not this one. The girl in the pic I'm looking for has one eye closed and is sticking her tongue out a bit. It's also much more lighthearted.
I have desperately been searching for the complete 2003 soundtrack, to no avail, every link is broken or there are no seeders.
If anyone has a source of download for it that works I would greatly appreciate it.
https://bakabt.me/torrent/129556/fullmetal-alchemist-ost-collection
>>96887
Thank you, however the soundtracks aren't listed.
The complete best soundtrack on there only has a few tracks. I'm looking for the entire soundtracks.
>>96894
Ah I didn't look too closely.
AnimeBytes might have it, but I don't have an account to check.
Alright /wsr/, show me your pixel art skills.
>>96848
Are you fucking kidding me?
I just fulfilled your request here >>96806 , you fucking nigger.
And anyway, the only thing I did was, I scaled it down, and then I scaled it back up, with no interpolation. Oh, and I made it indexed with 24 colors instead of RGB.
This is the last one I make for you. Fuck off back to ribbit, or better yet, kill yourself.
>>96857
I don't think this kid understands pixel art...
I don't know a ton about tech, I do know my power supply is a little on the low side for what i have, 500W, but Ive had these same specs for a year, is the power supply just dying? its the oldest piece of hardware i have
When my computer wants to turn on, it stays on as long as I am actively using it, then when the power goes off it goes into this state
System Specs
Gigabyte Z97X-SLI
i5 4690k 4CPU ~3.5GHz
GTX 9604gb vid ram
16gb ram
And windows 10, which ive not had problems with the entire time Ive had it
TL:DR
What the fuck is wrong with my computer
Bump, Really need help
>>96846
Gonna need a little more detail OP.
> it stays on as long as I am actively using it
Do you mean so long as youre moving the mouse or pressing a key on your keyboard? What do you mean by this?
It looks like youre stuck in a boot loop.
Do you have a motherboard speaker? Is it beeping? If so, check the beep codes. But if theres no beep code, see below.
Have you tried clearing your CMOS yet? Does your motherboard have a dual BIOS or an option to flash your BIOS?
If the CMOS doesnt work, try flashing/switching the BIOS if you can.
If that doesnt work, is your power button on your case sticking
If this doesnt work, try reseating all of your components.
If that doesnt work, you're gonna have a lot of fun.
What youre gonna wanna do is remove parts until you can determine what the faulty part is.
Firstly, unplug ALL hard drives from both the powersupply and your motherboard. Also unplug any front panel connectors (i.e.USB2 USB3, audio etc.) just have the CPU, GPU, RAM and a monitor and keyboard plugged into your motherboard.
Start by removing your graphics card and plug your monitor into your onboard graphics. Does this work? If yes, graphics card is fucked, if not, we have to go deeper.
Remove all but one stick of RAM. Check your motherboard manual if theres a main RAM slot. Once found, put one stick of RAM into that slot. If it works, you have either faulty RAM or RAM slots. If not, swap out that stick for another. If all the sticks dont work, check if the motherboard doesnt have a main RAM slot (i.e. you can plug it into any slot and it will work), then repeat this process with all slots.
Once we've gotten to this point, troubleshooting is going to be a pain, you may need to buy a really cheap 1150 CPU to test if its the CPU or not, but they're not that expensive.
(TBC)
>>96866
(CTD)
If the system still doesnt work, you have two paths, the quick way and the cheap way.
For the cheap way, RMA your motherboard, it should still have some warranty left on it and then test with the replacement, if it still doesnt work, then its the power supply.
The quick way is to buy a new PSU and try rebuilding the tower. If it still doesnt work, RMA your motherboard.
Ask any questions that you need.
I need a large amount of "OP Is A Faggot/This Thread Is Shit" pics in a short amount of time.
Tried google?
https://www.google.com/search?q=op+is+a+fag&safe=off&source=lnms&tbm=isch&sa=X&ved=0ahUKEwiL8Oeq0_7LAhWCWiwKHamtC5IQ_AUIBygB&biw=1269&bih=678
I didn't want to help you but my urge to call you a faggot with pictures got the better of me. Well played you faggot.
Sup /wsr/
Stupid question incoming.
I toyed with the idea of going to a skylake build but I don't really want to spend the money to put together a whole new rig right now. My 770 and 4670k are actually still going really strong for me and I'm getting much better performance than I feel like I should be.
Only thing I don't have right now that I would like to do is get an SSD. I still have Win 7 on my regular HDD and I suppose it would only make sense to install Win 10 on the SSD so I don't have to go through the upgrade process later. I'm also going to get a new power supply along with it, because the one I have now that I got when I put the build together (my first build) is not modular and the SATA cable came a little frayed which wasn't an issue until now when I want to add an SSD.
So my question to you is, once the new power supply is in can I simply pull out the HDD, put the SSD into the existing machine, install win 10 on it, then change the boot order to the SSD so that I don't have to worry about any cloning software for my HDD?
I feel like this is an obvious yes but before I commit I wanted some input.
TLDR: Any problems if I install win 10 on a new SSD then put back in my win 7 HDD for mass storage?
Bumping with cars?
Hey all, I'm building my very first PC and I would like some input.
I mainly want a PC that can run basic 1920x1080 at 60-80 fps reliably and with most games that you throw at it.
I don't know about PCs so most of my choices are based off quick google searches on what's good, what's not good, etc.
I'm looking for advice, help, or any tips that you would give to someone building a PC for the first time.
Here's a list to my build
http://pcpartpicker.com/p/PYrPbv
Well you made a basic pc that could deliver qhd with 75 fps. So what u should add is an SSD and a cpu cooler. Optional u could add another 8 gb ram
>>96756
Also is the price important to you or do you have a limit?
Have you checked out Logical Increments?
http://www.logicalincrements.com/
/r/ing a fake ID maker. Facebook kicked me out and requires verification of my real name, so I need to upload a "government-issued ID".
leave the botnet and reclaim your privacy
>>96752
fakenamegenerator dot com
>>96752
>Facebook kicked me out and requires verification of my real name, so I need to upload a "government-issued ID".
Sounds like a scam to me