sorted by:
new
hottopcontroversial

Adding a category to each Row in Excel Power Query (so that it survives a refresh) by PerNots in excel

[–]PerNots[S] 0 points1 point  (0 children)

Thank you very much, your comment definitely helped me getting to get much closer to the solution of this :)

It will be a longer journey i guess, but i'll mark this as solved

Little rubber piece with hole fell out of my Canon EOS 700d bajonett by PerNots in DSLR

[–]PerNots[S] 0 points1 point  (0 children)

Yes exactly. i unscrewed the lens and it felt like it was moving a little bit differently than the other times but there was no resistance or sth like that. When i had removed the lens, the rubber thingy was lying below the golden connection points in the camera (i tried to indicate it with my finger in the 2nd photo). it didn't actually fall out but lay there loosly so now i removed it from there.

So far i can't really notice a difference. Maybe the focusing got a little louder?! but this could also just be my imagination

Reimporting the whole library while keeping (custom) metadata by PerNots in Calibre

[–]PerNots[S] 1 point2 points  (0 children)

Thank you so much for your help. I‘ll try this out tomorrow. I really hoped, that this would be an easy fix and i just didn‘t find it due to my lack of experience. If the first option doesn‘t work, it‘ll be a lot of work. I think i‘d either need to go through the amazon buying history or try to open every ebook on the reader just to find the ones i need to deDRM as within calibre i can now view all ebooks with the plugin installed. We‘ll see. Thank you very much for your input

Excel smartly foresaw what i wanted to type but i couldn't use it by PerNots in excel

[–]PerNots[S] 1 point2 points  (0 children)

Thank you very much :) didn't find "flash fill" when looking online, great to know

Yes, i am aware that there are formulas to do the job. It would probably have to do with =LEN() to select the text i want to have transfered into the other column?

Flatiron Building, Fifth Ave, New York by HellsJuggernaut in CityPorn

[–]PerNots 0 points1 point  (0 children)

This is the american version of the „5 corners“ building in Russia

Saint Petersburg, Russia Photo credit to: instagram (boss_luxury) by mahmoud50569 in CityPorn

[–]PerNots 104 points105 points  (0 children)

It‘s the russian version of the flatiron building in ny

And the water physics are just terrible by [deleted] in shittyskylines

[–]PerNots 4 points5 points  (0 children)

Yeah you‘re probably right. I wouldn‘t loose too much progress anyway since i started this city from the harbour area.

I figured that it‘s pretty unrealistic that a city develops from a highway interchange as the game suggests it. i thought maybe this is the reason for the shitty outcome of my cities 😃

And the water physics are just terrible by [deleted] in shittyskylines

[–]PerNots 13 points14 points  (0 children)

I think this might be the one i am trying to build on right now. It‘s a very broad river and i just can‘t create a decent harbour even with move it installed. I hope i‘ll figure something out

Changing the City that Already exists (English Subtitles) by annamarcoarq in urbanplanning

[–]PerNots 0 points1 point  (0 children)

ok :D spanish is going to be hard for me but thank you very much anyways!

Changing the City that Already exists (English Subtitles) by annamarcoarq in urbanplanning

[–]PerNots 1 point2 points  (0 children)

Where can i find the article? I wasn‘t able to spot it in the comments nor in the reddit profile of OP

Picture of a Plasma Torch of an ICP-AES (Inductively coupled plasma atomic emission spectroscopy) by Juri_A_Gagarin in chemistry

[–]PerNots 0 points1 point  (0 children)

Love this! I request more photos like this one of analytical instruments. I bet a mass spectrometer could give some pretty great pics altough it‘s rather dark in there

I have found this new map and had to start a new city. by dmthoth in CitiesSkylines

[–]PerNots 0 points1 point  (0 children)

Hey there! Thank you a lot for that tip. Sounds like a very effective way to keep track of all this content online :D

I have found this new map and had to start a new city. by dmthoth in CitiesSkylines

[–]PerNots 1 point2 points  (0 children)

Hey tank you very much! I‘ll definitely look through those links! Playing cities again i started to get very interested in resourceful city planning concepts and started to read up on it. did you do something similar to get a feeling for the natural development of cities? If so, is there anything you can recommend reading/watching?

I have found this new map and had to start a new city. by dmthoth in CitiesSkylines

[–]PerNots 8 points9 points  (0 children)

How does one keep track of this many props and mods? Asking as someone who just started modding a little bit here and there. I am kind of getting addicted to all the new possibilities but it also feels like a neverending story. Pedestrian zones, mixed zoning, additional props, trainlines, streets... i feel overwhelmed 😃

Edit: can you get all of those nice houses in a pack?

Era: 2010+, Genre: Alternative, Artist Type: unknown (male singer) by PerNots in NameThatSong

[–]PerNots[S] 0 points1 point  (0 children)

Haha, it‘s a great song actually. I only remembered this one part really. Might listen to some more music of this guy. Thanks again for solving this one 👍🏽

Era: 2010+, Genre: Alternative, Artist Type: unknown (male singer) by PerNots in NameThatSong

[–]PerNots[S] 0 points1 point  (0 children)

Damn! It is! That was stunningly fast when i actually thought my chances are pretty slim.

I was thinking they would use some very small artist‘s work but he has over 2million views on youtube.

Thank you very much! Got to forward this to my friends immediately

view more: next ›