AnAverageName

I'm writing a program using Python 3.7 that needs to export cells into an Excel document with part of the text in each cell underlined. To form the Excel document I'm currently using the openpyxl library, which, as far as I have been able to find, has the ability to style cell by cell, but not just portions of text inside the cells - I've also looked into using xlsxwriter, which has one picture that looks like it may have been able to format on the string level, but nothing in the documentation. I'm open to using any export solution though. I've also tried using U+0332, combining low line, between characters but since I'm working partially with Chinese text it does not render correctly. Text is scraped using Beautiful Soup 4 and portions that needed to be underlined could be enclosed in <u> tags if needed. If there is a macro or number format that I could use to remove the tags and replace them with an underline that would also work great for my use case. Thanks for your help in advance! Edit: So looking at the Excel object model it looks like the smallest object you can really work with is a range of one cell, not content inside the cell. Fairly certain that there isn't a Python library that can format pieces of the string, going to try to write something in VBA. Direction on that would also be appreciated.

Hey guys! So, I'm looking to upgrade to a new laptop and want to spend about $1600 +/- $100 on it. Currently, the best option that I've found so far is the Asus ROG G752VT for $1597.96, rocking an i7 6700HQ, GTX 970M, 16GB of RAM, a 1TB HDD, and a 128GB SSD. Now, I'm not actually going to use this system for gaming, but my job does require me to have a fair amount of horsepower and the ability to use CUDA. A 960M or above should work just fine, although a higher end card within the price range would be great. Also, if the laptop has an analog output (DVI-I, DVI-A, or VGA) that would be a massive bonus. Portability is a bit irrelevant to me so I'm totally fine if it's a bit of a brick. Finally, I found this laptop on Asus' website and saw that it had a 980M for only $1400. It doesn't have an SSD, the RAM is DDR3, and the CPU is an i7 4720HQ. The lack of an SSD doesn't bother me, but will this CPU and RAM make that much of a difference in general compute performance? According to CPU Boss, the 4720HQ is actually more powerful. Thanks!

Hey, guys! I'm looking for a new camera that will be used primarily for shooting video. I'm looking to spend approximately $700-$1200 on it. This would preferably include storage media, lenses you feel are necessary for shooting video, and a microphone. My budget is flexible so if you feel like there's an option that costs a bit more and is a lot better feel free to throw it in. Please let me know if you need any more details. Thanks!

Same questions as DXMember. You'd use something like an Arduino if you were to do PWM brightness/color control, but what is often much easier is voltage based dimming. The Atmel chip would also require supporting hardware (oscillating crystal, a few capacitors, etc.).

First off, my last question may have been a bit intimidating. Me being me, I assumed you were just going to purchase an RC522 chip. If you get a breakout there are plenty of libraries available for you to use with it, along with prebuilt hardware. The shield you just linked will also work. Looking at the documentation for both an RC522 and the audio shield you sent to me they want to use the same pins. (8-13 and SDA for the audio and 9 - 13 or 9,10, and ICSP 1, 3, and 4 for the RFID). You can change these around and make it work, but out of the gate, it will not work on an Uno. You probably will have to solder, nothing complex though just header pins. That's really all there is to it! I actually like the generic Arduinos. Usually they work as advertised and are fairly reliable, only problem is that you may need a different USB driver to interface with them.

It should work, but are you using a breakout with supporting hardware or just purchasing the RC522 chip?

Just noticed that you posted this a bit ago. Might as well start on my answer. First off, audio on an Arduino can either be really easy or really hard depending on what type of sound you want to make. Looking at your parts list, it looks like you want to load audio files from an SD card and then play them on the Arduino. Is that correct? If it is the case, congratulations! You have chosen the hard way. At least, you have if you are doing it from scratch. If you're not bent on making the audio component yourself there are some great shields you can use that give you a nice library and all the hardware you'll need. One of my favorites can be found here. If you want to do more simple sounds you can use tone() or analogWrite() to specify a frequency for your speaker to output at. There are a ton of awesome guides that can walk you through how to use these functions, and even give you a list of frequencies that correspond to notes. As for RFID, I would recommend that you use an RFID shield. A great one can be found here. These parts should be able to work together on an Uno. Just make sure you have stackable headers for the RFID shield to make it easier on yourself! Let me know if you need any help or have any questions! ~Cheers! Edit: Started before I saw the last post one sec.

What Arduino are you using? I'm assuming an Uno, but I could be wrong.

Awesome! An idea that I've been kicking around that may be a bit fun is a device that tests to see if two people are in love. This sounds a bit crazy, but hear me out! Two years ago Professor Emilio Ferrer at UC Davis published two papers that essentially said that if two people that are either in a relationship or like each other stare at each other for a few minutes their heart beats will sync up. The same behavior was not observed between people that were not in a relationship. Links to the papers are here and here. I will admit that the science is a bit sketchy since I haven't seen another researcher publish any similar results, and the sample size used in these experiments was only 32 couples. But why not make a device that measures two individuals heat beats and experiment on some people yourself? You'd need the Arduino, a display of your choice, a clock module if you want to be super accurate and not use millis(), and two pulse sensors which can be found here at a minimum. Haven't read the documentation for the sensors so I don't know if any supporting hardware is required. Probably not. Your program would start by getting a baseline reading of the time between one pulse on each sensor. Heat rate may also be an interesting metric to measure. Have the program watch the time between pulses and see if the heart rate changes, and by how much. Based on these two metrics you should be able to see if the beats are syncing and determine if the two people are actually in love. (Note: I'd measure the time on the front and back end of each beat. May help with accuracy.) I did something like this at Valentines day last year, only it spat out random numbers for how much the two people liked each other. (Don't judge me, it was like 1 am when I did it and Valentines was the next day. ) People absolutely loved it. Left it in a common area and couples went by all day testing their "love" (aka luck on getting a good random number). Kinda like those arcade games that are like squeeze the handle to see how good you are at kissing or whatever. Point is, you'll be able to have some fun with this. If you do decide to do it tell me how it goes and if you need help don't hesitate to ask! ~Cheers!

Just wondering, but what type of Arduino do you have? I'm assuming an Uno, but I could be wrong.

Incredibly sorry, looks like I got the dynamic transducer on headphones like the Beyerdynamic DT 990 confused with orthodynamics. Not as familiar as I should be with transducers.

Forgot to quote. See above post.

That's a bit hard to tell since there isn't just a list of every HTML template out there. I can tell you that this doesn't have the hallmarks of a website created in Drupal, WordPress, Wix, Squarespace, or Weebly and all in all, looks like it could be written by someone relatively new to web design. He is using some JS that isn't written by him, although it is open source. Also, really curious about the, " I really don't want the person who made this get in trouble." Would you mind giving a bit of background? Oh, and the, "Wheatless in Seattle," name is awesome.

You really don't need a separate amp for these headphones. Looking at the product page, we see that they are, "low impedance, for portable devices." This usually means that the headphones are in the neighborhood of 8-32 ohms, which can easily be driven by computers and phones. With your amp rated at headphones that are 600 ohms, which is quite a bit more than you'll need to get everything you want out of them. Edit: Error pointed out by SSL corrected.

A VPN is a much better solution. Betternet is my favorite as they have free, unlimited data. Clients are available for Mac, Windows, iOS, and Android. Plugins are also available for Firefox and Chrome.