|
Doctor Moxie
@
DoctorMoxie
London, England
|
|
NHS Accountant and Excel whizz with a penchant for pivot tables - tutorials have a healthcare focus. Newbie programmer starting with @MakersAcademy in June.
|
|
|
81
Tweets
|
265
Following
|
77
Followers
|
| Tweets |
|
|
Doctor Moxie
@DoctorMoxie
|
May 16 |
|
A new blog sharing a macro that will split a large spreadsheet into multiple spreadsheets based on the value of a given field. The example shows how to split a monthly NHS monitoring report by commissioner. nhsexcel.com/macro-generate…
|
||
|
||
|
|
Doctor Moxie
@DoctorMoxie
|
May 15 |
|
How to Clear the Pivot Table Filter Cache. Cleaning up for a new year of data or simply removing errors that still show in your pivot filter lists. excelpivots.com/pivot/clear-pi… pic.twitter.com/z9ONTwnUNO
|
||
|
|
||
|
|
Doctor Moxie
@DoctorMoxie
|
May 9 |
|
New blog illustrating the use of the Code to Group spreadsheet with a Acute Kidney Injury as the example. HRG Grouping logic for NHS payment. nhsexcel.com/code-to-group/
|
||
|
|
||
|
|
Doctor Moxie
@DoctorMoxie
|
Apr 25 |
|
Episode 1 Series is of @CodeNewbies was so inspiring. 54 yo woman teaching herself to code in order to create an iPhone app for victims of domestic violence. Yes!
|
||
|
|
||
|
|
Doctor Moxie
@DoctorMoxie
|
Mar 31 |
|
R1D23 #100DaysOfCode Still working on classes today - building a ruby address book application. I got up early to start coding and the freshness seemed to help with my comprehension, or perhaps its the repetition. Either way I feel like I'm finally getting it.
|
||
|
|
||
|
|
Doctor Moxie
@DoctorMoxie
|
Mar 28 |
|
R1D21 of #100DaysOfCode Working with ruby blocks in Treehouse. It made me sweat a bit. I feel like I am on the edge of my understanding now. About to teeter into the abyss...
|
||
|
|
||
|
|
Doctor Moxie
@DoctorMoxie
|
Mar 6 |
|
My favourite GETPIVOTDATA hack: nhsexcel.com/getpivotdata-t… #exceltips
|
||
|
|
||
|
|
Doctor Moxie
@DoctorMoxie
|
Mar 4 |
|
thanks for the boost. I like your training log, it has encouraged me to be less lazy with mine.
|
||
|
|
||
|
|
Doctor Moxie
@DoctorMoxie
|
Mar 4 |
|
R1D14 of #100DaysOfCode Chapter 5 of TWGR sent me into a tail spin. I can't get my head around self. I tried some Ruby katas on Codewars and just can't get them to run, even at 8kyu. In desperation I headed to Learn Ruby the Hard Way. Ex 13 onwards.
|
||
|
|
||
|
|
Doctor Moxie
@DoctorMoxie
|
Feb 25 |
|
R1D12 started learning CSS Grid with the polished and free tutorial on scrimba scrimba.com/g/gR8PTE
The grid-template-area methodology is inspired. #100DaysOfCode
|
||
|
|
||
|
|
Doctor Moxie
@DoctorMoxie
|
Feb 11 |
|
R1D6 completed Chapter 4 of TWGR. Classes and modules. Error capture with method_missing methods, which illustrate the use of super to pick up the kernel method_missing (or next highest definition). #100DaysOfCode
|
||
|
|
||
|
|
Doctor Moxie
@DoctorMoxie
|
Feb 9 |
|
Almost finished chapter 3 of TWGR for R1D4 of #100DaysOfCode . Covered inheritance and then some really conceptually tricky stuff about objects that are classes and classes that are objects. Did my head in really.
|
||
|
|
||
|
|
Doctor Moxie
@DoctorMoxie
|
Feb 7 |
|
and that fixed it - thanks for the help. I like that app.
|
||
|
|
||
|
|
Doctor Moxie
@DoctorMoxie
|
Feb 7 |
|
blimey that was quick. Sorry I just discovered you have a dedicated @draftsapp account so I just deleted and resent my tweet. Didn’t mean to spam you!
|
||
|
|
||
|
|
Doctor Moxie
@DoctorMoxie
|
Feb 7 |
|
Hey @draftsapp Is there a problem with the Drafts app? The markdown toolbar takes total priority on my screen, squishing my writing off the screen and leaving me with a vast space of nothingness. Very disconcerting. pic.twitter.com/8dlm1suqC0
|
||
|
|
||
|
|
Doctor Moxie
@DoctorMoxie
|
Feb 7 |
|
Yesterday was #R1D3 of #100daysofcode and I finished Chapter 2 of #TWGR objects and arguments galore.
|
||
|
|
||
|
|
Doctor Moxie
@DoctorMoxie
|
Feb 5 |
|
R1D2 of #100daysofcode yesterday. Worked through chapter 2 of The Well Grounded Rubyist. It’s a pretty thorough book, glad it wasn’t my first intro to Ruby though.
|
||
|
|
||
|
|
Doctor Moxie
@DoctorMoxie
|
Feb 4 |
|
I’m starting with @makersacademy in June so it seems like a great time to start the #100daysofcode challenge. Html recaps for today.
|
||
|
|
||
|
|
Doctor Moxie
@DoctorMoxie
|
Nov 20 |
|
Using Pivot Tables to Compare Data beats the VLOOKUP method hands down. excelpivots.com/excel/compare-… pic.twitter.com/KapBMVK0UW
|
||
|
|
||
|
|
Doctor Moxie
@DoctorMoxie
|
Oct 27 |
|
I'm on a SQL Server roll - new pictorial showing how to easily import csv as SQL table.
nhsexcel.com/import-csv-sql…
|
||
|
|
||