thatsnice

6 ms·

1. 1.▲
   Stop Excel from changing large “numbers” (text) to scientific notation(excel.uservoice.com)

   1 points by thatsnice 6y ago|1 comments
2. 2.▲
   by thatsnice 6y ago

   In Taiwan, shops / restaurants are open as normal and people are walking around freely, other than the tiny percent in quarantine. Meanwhile Europe and the US are increasingly locked down. So which one has more freedom?
3. 3.▲
   by thatsnice 6y ago

   US$1 ~ 30.2NT so the original numbers seem correct.
4. 4.▲
   An engineer's guide to building a “What to Wear” app for children(mixedanalytics.com)

   1 points by thatsnice 7y ago|0 comments
5. 5.▲
   by thatsnice 7y ago

   I think it’s because there are 2 of them, each on the $6 plan. G Suite charges per person.
6. 6.▲
   by thatsnice 7y ago

   I pay for G Suite as a freelancer. It lets me use my own domain for email and meeting requests instead of an @gmail account.
7. 7.▲
   by thatsnice 7y ago

   FYI, there is a typo in the link to your blog.
8. 8.▲
   by thatsnice 7y ago

   Interesting idea, thanks. There's often multiple levels of nested data, would you want to see each level in a new sheet?
9. 9.▲
   by thatsnice 7y ago

   I made a Google spreadsheet add-on [1] that contains 3 built-in options for converting nested JSON to tabular format. Method 1: drills into nested json objects and arrays and returns the key names as headers, key values as rows. In cases wi
10. 10.▲
    by thatsnice 7y ago

    That was very cool & educational.
11. 11.▲
    by thatsnice 7y ago

    I also posted one recently, a plugin to connect to APIs directly in Google Sheets [1]. The primary use case I had in mind was for people looking to grab data from various APIs, in which case it's pretty clear why someone would want to
12. 12.▲
    by thatsnice 7y ago

    Hi HN, a couple days ago I released a Google Sheets Add-on to pull JSON API data directly into Google Sheets. You can enter the URL, query strings, and any required headers into the Add-on sidebar, and can make dynamic requests by referenci
13. 13.▲
    Show HN: Connect to APIs in Google Sheets(mixedanalytics.com)

    3 points by thatsnice 7y ago|1 comments
14. 14.▲
    by thatsnice 11y ago

    Thanks, filipm. It's interesting, the intro page does actually list all the things it audits in the box that says Site Settings, Goals and Funnels, Site Search, Campaign Tracking, etc. Did you not see that (perhaps because it's b
15. 15.▲
    by thatsnice 11y ago

    You're right, thank you for the feedback. It slipped through since I just made this new site last week. I am a web analyst and not a phisher but I see how it looks suspicious -- I'm editing the links now!
16. 16.▲
    by thatsnice 11y ago

    Thanks philipn. Typically web analytics firms call this type of account setup and implementation review an "audit", but you're right, it's not necessarily clear. Let me think what else I can call it... GA is pretty comp
17. 17.▲
    by thatsnice 11y ago

    Thanks for your feedback. They are not the same service -- the web app is a free automated audit that checks for 17 different issues I regularly find while auditing client accounts (for example, problems with event tracking, view filters, m
18. 18.▲
    by thatsnice 11y ago

    Thank you for your feedback. Those are all great ideas. Actually none of the user's GA data is directly accessed or stored whatsoever -- it's all done through the Google API using oAuth so we can't see any of their account da
19. 19.▲
    Show HN: A tool to audit your Google Analytics implementation(mixedanalytics.com)

    30 points by thatsnice 11y ago|12 comments