So this is how I did it:<p>1. Read a bunch about self-publishing. Traditional publishers give 10-15% royalty, and this book really isn't built for paper-back, so I decided to go digital. Amazon gives you 35% or 70% royalty depending on what you price it at. Write Publish Repeat (<a href="http://www.amazon.com/Publish-Repeat-No-Luck-Required-Self-Publishing-Success-ebook/dp/B00H26IFJS" rel="nofollow">http://www.amazon.com/Publish-Repeat-No-Luck-Required-Self-P...</a>) is an excellent book on what it takes to be an independent author, and I highly recommend it if you want more info there.<p>2. Started looking at the College Confidential forums and writing my scrapers. It wasn't too much coding, about 1.5k lines in python to do all the scraping, clean up, and storage (flat files + SQLAlchemy). It took some time to figure out what fields to use and what would be relevant, and the other hard part was actually parsing data. For example, some people report "SAT: 2370", while others do "SAT: 800/770/800", while others do "800 CR, 800 M, 800 W". All three represent the same score (2370), but they all have different info, so it just took some regex fanciness + manual verification to get good parsers in place.<p>3. Started writing the text. I've been dreaming of writing this since I was in 10th grade so it wasn't hard to get the outline ready. I finished up the text on what the application process is like (after you submit), and then I started generating tables from my data and analyzing it.<p>I used Google Docs, but that was a mistake for two reasons. For one, once you hit 40-50 pages on Docs, the whole thing becomes slow. It was annoying to scroll through to different pages, and after a while I just exported to ODT and edited in LibreOffice.<p>The other reason that was a bad call was because it is really difficult to export it to something that Amazon will like. You see, tables are kinda hard to do in Kindle, and a lot of the formatting gets messed up because you have to go Docs -> ODT -> HTML, when Amazon then turns into MOBI or AZW. Eventually I had to download Office 365 and export as .docx, then edit in word, export that to HTML, and upload that. Some guess and check got the tables to print mostly ok, but the lists were all messed up because Microsoft uses some random HTML stuff. So I went through all the pages and then just used <ul> and <ol> to do what I needed to with lists.<p>And that worked well. A few more tweaks and dealing with Amazon's system (once you send something to 'Publish', you can't cancel it. They approve it quickly but it takes ~6 hours to actually publish, at which point I would republish a final version and wait 6 more hours =\)<p>Overall, a really fun process. I do want to write more books and experiment with different tools like Scrivener. Happy to discuss college admissions or publishing or anything else. Thanks for your support, and eager for your feedback!!<p>P.S.: My last few Show HNs (<a href="https://news.ycombinator.com/item?id=8821393" rel="nofollow">https://news.ycombinator.com/item?id=8821393</a>, <a href="https://news.ycombinator.com/item?id=8006940" rel="nofollow">https://news.ycombinator.com/item?id=8006940</a>), are all around admission/college application tips. Didn't realize the theme haha.