Visualizing Bitcoin Adventures

I’ve been riding a Bitcoin (and Ethereum) roller coaster for a year .. and its been a fun little diversion.   However, its hard to see the journey .. it feels like I’ve come out ahead, but have I really?

I doodled various (complicated) ways to try to show stuff via a 3D graph .. but when I actually went to play, this 2D version works just as well:

image

  • Vertical (down) drops ==  I transferred bitcoin (either to another account, or buying something with bitcoin).
  • To the top-left = I bought bitcoin for USD
  • To the bottom-right = I sold bitcoin for USD (for buying something usually)
  • Note: A similar chart would exist for my Ethereum account.  No, i did not buy a switch for $90, it was more than that.
  • Steep curve vs Shallow curve gives a feeling for price.   buy Steep, sell Shallow is the desire.
  • I could beat myself up .. if only I hadn’t spent the bitcoin, I’d have so much more now…
  • Currently, my experiment is net-positive.  Even if bitcoin goes to $0 right now.

How I created this

  • Download transaction report from Coinbase.   This is a .CSV file, which I then open in excel.
  • Their report has a “Amount” (Column C) which has + for bitcoin added, – for bitcoin removed.
  • Their report has a “Transfer Total” (Column H) .. but it isn’t signed. 
  • Their report also has a Transfer Fee column .. I’m ignoring that for this graph.    I did sum it up, I’ve paid $30 in fees this year.
  • Add a new column, “Signed Transfer Total”   formula is something like “=IF(H27<>0,H27*SIGN(-C27),0)” – to get a signed USD column.  Note that I’m reversing the sign so that a plus in bitcoin is a minus in USD.
  • Add a new column, “USD Balance”, which sums up all the Signed Transfer Total to date.   Something like “=SUM(J$6:J27)”.  For simplicity I added it right next to their bitcoin balance column
  • Grab those two columns and chart it, scatterplot, lines
  • Adjust the vertical size of the graph till you get something that works for you.  

In summary

I do not regret this Bitcoin experiment.

I do hope to leave stuff in Bitcoin, i think it will continue to grow for a while.

Tagged with:
Posted in Code

Upgrading my ReFS

I got a larger capacity drive to upgrade my ReFS (Resilient File System, Windows 10 “RAID” array) with.. also, most of my drives are >5y old, and I’m running low on capacity, so I better start upgrading before the world starts upgrading me.

Here’s what it looked like before the upgrade:  (“Manage Storage Spaces” are the magic words to Start->Search for):

image

Now I’m going to save this draft post, open up the computer, and unhook the 931G drive (if I can find it) while the machine is running to simulate a fault.

DANG! I have two 1TB disks.  Oh wait, one is a WDC and the other is a Seagate.   Cool.   The WDC is the one to unplug.

The WDC is unplugged!  It hasn’t figured it out yet.. Opening up the drive … drive opened..  WinDirStat to exercise the array .. 

there we go.  “Reduced Resiliency”

image

Okay, cool.  I’ll power down the machine and swap out the drive.

The Storage Spaces UI is unchanged – the (now removed) drive shows up with the yellow icon.

I have a new drive in regular Disk Management:

image

First, I click Change Settings .. I tried to find a way to remove the old drive, but I couldn’t find one.

So I went with adding in the new drive first.  I clicked “Add Drives” —

image

Once it was happier with the drives, the option to remove the errant drive showed up. 

image

I clicked “Remove”, and it asked me to confirm the drive that I was removing ..

image

This took a LONG time.   From 7:20pm to  9:38pm, so about 2 hours.  Opening up a second Storage Spaces UI, i could see the drive listed as “Preparing for Removal”, which I think meant “I’m going to find all the stuff that was supposed to be on this drive and make sure it is elsewhere”.    (Confirmed – the % used started dropping slowly.) 

The other thing I didn’t realize is I had to increase the size of the storage space to use the new free space in the storage pool.

And… I’m going to post this before its all done.  But basically:    I now have about 3TB of Mirrored Space.  I’m also Resilio-Syncing the important bits to an off-site backup.  So, any two of three things could die, and I should still be good.

Tagged with: ,
Posted in Life

Cancelling my Model 3 Reservation

I’m still feeling a bit icky about it, but running my head through the Math, it still makes sense.

Here’s what the experience looked like.

A link to Ben’s very well done calculator:  https://teslanomics.co/model3cost2

Looking forward to 2020.

Tagged with:
Posted in Vehicles

Switching from iPhone to Android (Samsung S7)

img_20170903_110354_847I wanted to write a nice detailed blog post with pictures and screenshots. Would take too long to get it “Perfect” so I am punting.  (I did write this using the WordPress app on the phone)  ** I continued this from my laptop later.

Here are crib notes instead.

Summary: it’s good, it’s functional. It’s less pretty on the watch side, and MMS is subpar, but better voice recognition, LastPass integration, wireless charging make up for that. I’m going to stick with it for a year.

Addendum: it’s frustrating to learn a new ecosystem. And because Android has so many variations it’s hard to know what information applies. For example – getting that screenshot in this post – there is probably a better way but I had to use Google voice to take it, send it to WordPress media library, then include it in this post.   (Addendum to the dum:  Turns out there’s a “swipe left with your palm” gesture for my phone, but I still can’t save the screenshot to my camera roll)

Stuff I like:

  • Chat heads – if I use FB messenger for SMS.  They pop open over any app, and let me continue a conversation without switching apps.
  • Voice recognition is better – especially in the car.  It seems to want to use the phone’s microphone, rather than the 3 second delay switching to bluetooth through the car microphone.
  • Can choose default apps – like which Messenger app to use.    Thank you “Intentions”.
  • Widgets – Not going crazy with this, I only have two or three.
  • Not all apps on home screen – I can leave some in the drawer.  I don’t have to force myself to choose a position for EVERY FRICKING APP, just the ones that matter.
  • Always on screen – specific to my Samsung S7 device?   Shows time, date, next calendar appointment, etc before I hit the power button.   Major phone use case.
  • Number row – by default, turned on, on the keyboard.  Also a swipe keyboard, very nice for one hand use.
  • Better large screen shrinking – for single hand use.  Much more usable than Apple’s double-finger-home-button thing that never worked for me.
  • Last pass for apps – incredibly useful, when I’m in an App, Lastpass can integrate in and provide passwords.
  • Wireless charging – Coworker Steve gave me his old wireless charger.  I’m hooked.  No plugging in.  I bought one for the car, and I need to buy one for home.
  • Workout app has better sharing options – Pretty pictures, square format, straight to instagram, YES.
  • S2 watch can control which notifications go to watch and which dont.
  • Way more watch faces – This is also a curse.  I could not find a decent watch face which had battery, calendar, date, time, and actually worked across my multiple calendars.
  • I can put any icon anywhere on the page – I don’t have to plan from the top.   Thank God.  Clusters are easier to cluster.

What I miss:

  • Miss pretty emoji – I’m used to the iPhone and Slack emoji sets.  I don’t know for sure when I send my wife a kiss-with-eyes-closed emoji that its showing up the same.
  • Hue / OK Google integration misses things – I’ll say turn the lights off, and it will say “I got 18 of them, three not responding”, but only 8 will change.
  • Miss overcast podcast player with it’s auto silence trimming – For this reason alone, I have my de-SIM’ed iPhone living in the car, being an iPod for playing podcasts.
  • Group messaging wierdness interacting with iMessage – I won’t get pictures or video.  My entire family is iOS based, so I’m at a disadvantage.
  • Miss sharing position easily (find my friends) – Wife and I used to use this in passive always-on mode.  i can do Glympse for limited engagements.  I think Google has a solution for this somewhere.
  • Text selection wierd no magnifying glass for fine control – it took me a while, but I finally (with writing this post) got a handle on the text select stuff.  I have to take this back – I prefer the Android one.  I can actually drag the little draggers around, and they snap intelligently.   But I do miss the magnifying glass.
  • Miss square Apple Watch – It was smaller, looked better, and seemed more functional – especially the voice command part.
  • Miss scroll to top.
  • S2 battery life not great.   However, if I turn on Airplane mode (the S2 has its own 3G connection that I haven’t activated), its very comparable – down to 50% at the end of the day.

Btw, the screenshot is my second screen, not my home screen.

 


Tagged with: ,
Posted in Life, Uncategorized

test post for 360 content

Trying to see if I can embed this 360 image in here:

That should be a 360 photo.  I was able to do it with the built in vr tag for wordpress.com.

Furthermore, this should be a 360 video:

Lets see if it works…

Posted in Uncategorized

Optimizing Cycling

Now that we have youtube, I watched some videos on “Fitting” a cycle.  Armed with that info – maybe my bicycle is not the best fit for me, but I could change some things.

imageI rode the same route three times .. ignore the dark part, that’s me putting the app on “pause”, but apparently it continues to record while doing so, which is actually great.  Its about 1.1 miles mostly up-hill.  I did it three times ..

Look at the pink.  That’s my speed going up the hill.  Note how second and third ones were definitely better.

Look at orange.  That’s my heart rate.  Look at how second and third ones were higher.

Here’s what it was: 

  • My seat was not high enough.  As a result, on the downstroke, at the 3pm point, my knee was actually out beyond where the pedal was – which brings some strain into the system. As a result, my legs hurt  .. kneecaps back to hamstrings .. so my heart couldn’t drive my legs as hard as my heart actually could.
  • 2nd trial – I brought my seat up about 2 inches ** , so that my leg was almost fully straight but my foot still parallel to the ground when the pedal was at its lowest.    I also inflated my tires up to 70 (they were at 40 before), which maybe helped some as well – although you’d think you’d see that on the downhill.  I guess air resistance trumps rolling resistance there.  ** because the seat rises up and to the back, raising the seat also moved me back a little bit. 
  • 3rd trial – I brought my seat up another inch or so, so that my foot points a bit down at the lowest spot.  It also for sure got my knee behind the line of the pedal when the pedal is at 3 o’clock.  It was a bit uncomfortable, but … seemed smoother, and .. the heart rate vs speed graph seems to agree.   I also reinstalled the bar-ends so that my hand position was further out, and I think that shows up in the downhill speed (the part not marked with pink) is higher for this trial. 

This could also all be B.S.   It could also be that:

  • The evening progressed and it got cooler
  • I drank more water so the weight of the bike went down
  • I got more properly warmed up.

Things I did not do that would probably make things even better:

  • Put my seat further back.  Its as far back as it can go.
  • Use a lighter bicycle.  Mine is a hybrid with shocks and stuff .. quite heavy.
  • Take off my very heavy bicycle pack (leftover from RAGBRAI.  I needed somewhere to stick my towel and other stuff for my commute to work.  Don’t leave home without your towel!  (Don’t panic!)

Things that I am doing already:

  • I’m using .. clips?  and cleats?  I don’t know the names of them.  Basically, i have power on the upstroke as well, I just have to remember to try to bring my knees up to touch my arms.

The real test will be riding to work .. I hope on Monday .. and compare that against last Monday, see how I do.

I am excited.

Tagged with: ,
Posted in Health

Running Metrics

Looking at (some) of my numbers from this round of getting back into running –

image

  • This does not take into account exhaustion (time of day) or heat
  • The graph does not take into account distance – in general, over longer distances, your body can do less for a given HR.

Most of the numbers are in about the same line – the green line (which is data between 7/2 and 7/19). 

You can see me actually being worse than the blue line (which is data from 6/3 – 6/10).

However, notice that once I got serious and did a “long run” at low HR (the 125 HR on 7/19 which ended up at 90 minutes), my next performance jumped to the north significantly.  This is what HR training (LONG and slow, 50% between L1 and L2) can do for you.

Or, maybe I’m full of falafel and the next piece of data I get will be completely different.

This is kinda fun.   I wonder if I could convert this into a 3D sculpture of sort.

Tagged with: ,
Posted in Health
Categories
Tags
.net 3d 3d-printing 4k abc15 algorithms ames android anonymous types asp.net audio editing aws backup basecamp beatunes biorhythm bitcoin bittorrent blender blog boston marathon bpm c# caffeine campfire candycrush car carmax charity chiropractor cities-skylines clog clone codelouisville codepalousa coding coffee collaboration color run ComputerElbow ComputerVision configuration consulting cooking crash course crashplan crestwood cycling dabda dan dapper DataSet ddl diabetes dictation dotnetcore dotnetmud downtown e-cycling elite excel exercise expiration facebook feature-branching firefall flipflops Flow FL Studio focus food forecastle fortresscraft franklinplanner gadgets game-design games git github google docs google maps gopro gps grandpa greenshot hack half marathon headless health heart rate hiren ignew integration testing interop inventory ios ipad itunes javascript jobs karma kdf keyboards keys kittens lamont laptop lavalamp lego life lifehack linq linqtotwitter linux los angeles louisville mandelbulber massage therapy mastery-teaching maths merge metformin Minecraft miniature modeling monitor mud muhammad ali institute music mvc mycartracks netfabb nexus10 node nostalgia nutrition nwipe oldham county grand slam opal openjscad openscad owin pacedj paper mockup pepakura performance photoscan politics pomodoro postgresql powershell premiere prius process product-management project-management qa ReFS resharper review rmi roman road 5k RSI rubiks running samsung 700t sandals schedule scooter scribblelive selenium service shapeways sleep slic3r sneakersync snot software software-engineering solidoodle soylent spacegame speaking sql sqlite SSDT SSIS standing state-machine stayfocusd stonehearth sunset tablet teaching team teamcity teamtreehouse terraform tesla testing tfs time timelapse torque touch tracks trs80 Tuple tutor twitter ubuntu unit testing utilities video video editing visual studio vscode vsvim warp stabilizer windows 8 windows home server wordpress wpf xml
Archives