-- Getting path to this filetellapplication"Finder"togetfolderof(path tome)as Unicode textsetcurrentLocationtoresultsetcurrentPOSIXtoPOSIXpathofcurrentLocation
Running other AppleScript files
run scriptfile"HD:path:to:file.scpt"-- How it is used with above file pathrun scriptfile(currentLocation&"reformat_with_textwrangler.scpt")
Running multiple shell commands
do shell script"command 1; command 2;"-- How it is used with above file path to change directory and run a scriptdo shell script"cd ""ed formofcurrentPOSIX&"; python "&"count_days.py"
Given that the lists days and count are built above by the Counter(), you can pass them to matplotlib for charting:
frommatplotlibimportpyplotasplt######## Bar Chart ######## xs=[i+0.1fori,_inenumerate(days)]plt.bar(xs,count)plt.ylabel("Number of photos taken")plt.title("Photo frequency by day")plt.xticks([i+0.5fori,_inenumerate(days)],days)plt.savefig('img/weekdays_bar.png')plt.clf()######## Pie chart ######## colors=['red','orange','green','purple','lightcoral','lightskyblue','yellowgreen']explode=[0,0,0,0,0,0.1,0]plt.pie(count,explode=explode,labels=days,colors=colors,autopct='%1.1f%%')plt.axis('equal')plt.suptitle("Percent of total photos taken on a given day of the week",fontsize=18)plt.savefig('img/weekdays_pie.png')
If you donât want to save the images, you could just show them instead with plt.show()
plt.clf() clears the figure so you can plot something else on it. Otherwise youâd need to close it before continuing. plt.close() can do that.
Depending on the source CSV, the above creates these two charts:
I took a 10-day break from my TILs and now I’m reinvigorated and back on track. In the past 10 days I spent a lot of time doing things I already knew how to do, but I also worked on a small project related to data visualization to see if I could apply some things I learned over the past few months. The result was my recent blog post on Steph Curry’s stats.
A new project
I got a lot of good feedback on Facebook on some more things I can explore (and about how little I understand basketball.) I decided to work on another personal project to apply some of the data science I’ve been learning by reading Joel Grus’s Data Science from Scratch. I decided to find some data (photo dates and locations), extract it (AppleScript), format it (grep FTW), analyze it (forthcoming in Excel and Python), then visualize the insights (Python and/or D3). You can follow my progress on GitHub.
Dealing with files in AppleScript
AppleScript natively deals with file paths with colons: Macintosh HD:usr:local:bin: If you get a file path then want to pass it to the shell, you’ll first need to turn it into a POSIX path:
If you want to create a file in the same folder as a script you are running, you might have to jump back and forth between AppleScript paths and POSIX paths because it is easier to make files by using the command do shell script. Notice the use of quoted form of, which quotes the file path and keeps you clear of pesky errors caused by characters in the path that need to be escaped:
-- Creating the file in the same folder as this scriptsetscriptPathtoPOSIXpathof((path tomeas text)&"::")do shell script"> ""ed formofscriptPath&"photo_dates_location.csv"
Then if you want to get the path to the file you just created and make an it an alias to reference later:
Suppose you have a [spreadsheet full of photos, the date they were taken, and the days of the week they were taken on] (https://github.com/cagrimmett/apple_photos_analysis) and you want to count how many were taken on Monday, Tuesday, etc. Then you’d use the function COUNTIFS(range,argument) to work it out.
Example: Suppose I have the days of the week in column A and cell H2 contained the word I was looking for, Monday. Then my formula would be:
=COUNTIFS(A2:A8500,H2)
I quickly repeated this for the cells that contained the values for the other days of the week and got instant results:
I don’t really follow basketball. But since I’ve been hearing a lot about this Steph Curry guy in the news, on Facebook, and on podcasts, I decided to look into his stats. And since I’m trying to teach myself about data science and visualization, I thought I’d visualize some of his stats to see what I could learn.
From what I could tell Steph Curry had a decent start to his career, but while his was above-average, he didn’t seem to be a star. Then after he got injured during the 2011-12 season, he must have had a revelation because he came back the next season and made a name for himself.
The next season he started taking radically more three point shots and it paid off for him. His overall points went up as he made more three point attempts:
Here are the number of three point attempts vs three point shots made by season with the circles scaled by the number of overall points he made that season:
Even though he took more shots, his overall shooting percentage and percentage on three-pointers has increased recently, but not dramatically. It has fluctuated over his career:
Many current players have him beat on overall shooting percentage and a few guys are rivaling him on three point percentage (Jason Kapono, Steve Novak, Kyle Korver.)
So if you can’t stand out by being more accurate than everyone else, what can you do? In a game that is driven by the final overall score instead of percentages, being about as accurate as everyone else but willing to shoot more pays off. Curry is willing to take more long shots than anyone else in the league, by far.
Here are Curry’s 3 point attempts vs 3 point shots made compared with the other top shooters in the league for the past four years:
Here is the same data visualized as a bump chart. You can see the other top shooters jostling positions, but Curry has been king for the past four years:
I realize that there is more to the game than just taking more shots. You need incredible talent and skill to keep up a percentage like Curry’s from anywhere on the court. Given his success, I’m willing to bet that we’ll see more players trying to emulate his approach next season.
Side note: James Harden seems to be using the same strategy, except with two point shots and free throws. It is paying off for him, too. He is currently the number two leader in the NBA, right behind Steph Curry.
For example: here is how I’d combine columns of hours and minutes and put a colon in-between: =[@Hour] & ":" & [@Minute]
Convert hours.minutes to hh:mm:ss in Excel
Take 275.75 and convert it to 275:45 =CELL/24 converts the hours.minutes to days Then you format the column by Custom > Time > 37:30:55 (hh:mm:ss)
SQL Dates, Concatenation, and Grouping
I learned some useful things today in SQL: SUM(), CONCAT_WS() to get CSV output, DATE() to get the date part of a datetime stamp, and GROUP BY to get the sums grouped by another column
There are almost always multiple paths to your end goal. If you are stuck spinning your wheels on one path, try another.
If you get stuck, write down your end goal and then write down the discrete steps you need to get there. Then, at each bullet point, ask, “How can this step be eliminated or completed in a better way?”
Every time I go through this exercise I get some traction and start moving forward again.
If you’ve ever tried to write a sum() function in Excel while you have filters on, you likely didn’t get the result you expected. The sum() function adds up what is in the raw cells. It does not take whether or not they’ve been hidden via a filter into account.
subtotal() is the function you are looking for. Specifically, subtotal(9,range). The 9 refers to sum for hidden (not at a result of filtering, though) and non-hidden rows. See the documentation.subtotal() functions only on the results of filtered data.
=SUBTOTAL(9,G1670:G640501) gave me the sum of the the filtered data from G1670 to G640501. (You can see why filtering would be important with such a large data set!)
Remind yourself why
Sometimes I spend too much time and effort trying to convince myself to do something I don’t want to do. This leads to general angst and despair.
My wife reminded me yesterday that the best way of convincing myself is to reflect on why I’m doing it in the first place.
Whatever your reason why is, as long as it outweighs the cost of not doing it, you’ll get over it and find a way. I keep an index card with some why bullet points on it nearby to keep things in perspective.
Last year Amanda and I went to Montana for a week in early May and visited Yellowstone for a couple days before the official start of the summer season. It was chilly and some roads were closed due to snow, but we avoided the crowds and got to explore the park in relative solitude.
I haven’t shot photos much since graduating from Hillsdale, so I decided to take my camera along. Like any other skill, you need to practice photography regularly so you don’t lose your sense of composition, light, and technical settings like aperture and shutter speed. It was frustrating to discover that I’ve lost some of the edge that I worked so hard to hone in high school and college, but it was nice to put my gear through its paces again.
Here is the best of what I shot over two days in Yellowstone. I took a few landscapes, but I mostly focused on the colors and textures I encountered.
We also drove down into Grand Teton National Park for a little while:
According to the Jekyll docs, the jekyll-paginator plugin does not support categories or tags. That means there is no way to exclude a category as a whole. You can only exclude posts individually by including hidden: true in each post’s YAML front-matter.
I’m hiding all of my TIL posts from the front page of my site, so I did a global find and replace to accomplish it.
Mirror of If statement in Liquid
Liquid has a neat concept that is the inverse of an If statement. It executes if a condition is not met.
{%unlesspost.categoriescontains'TIL'%} Code here to display all the things! {%endunless%}
Inserting via mysqli()
Using the mysqli() function I wrote about yesterday, here is how to insert something into a table:
$connect=newmysqli($server,$db_username,$password,$db);$connect->query("INSERT INTO `table_name` (username) VALUES ('$user');");
Make sure your variables are sanitized first! You don’t want someone doing a SQL injection.
Eric Davis told me that mysqli() is the old way of doing things and I should check out PDO instead.
This checks for a table called scorecard_test and creates it if it doesn’t exist. The SQL parameters for the columns are:
An integer called ID that is the primary key and auto increments
A username that can’t be NULL
A column called counter that has a default value of 1 if there is nothing passed, and the length can’t be longer than one digit
A column that holds the current timestamp.
// SQL syntax$sql="CREATE TABLE IF NOT EXISTS scorecard_test ( id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, username varchar(255) NOT NULL, counter int(1) NOT NULL DEFAULT 1, time TIMESTAMP )";// Connecting, sending query, showing errors, and closing connectionif($connect->query($sql)===TRUE){echo"Done!";}else{echo"Error: ".$connect->error;}$connect->close();
Philosophies like Agile Development are great for teams working on large projects, but for someone just getting started with development and working on small projects, they can be a little much. For situations like this, Readme Driven Development strikes the right balance of planning out your project, writing documentation, and actually doing the work.
Write your Readme first! (H/t to Eric Davis for telling me about this.)
WordPress Plugin Basics
I have a food & drink website where I post regularly. Lately I’ve been trying lots of kinds of coffee to dial in my ROK Espresso maker and I’m starting to reach the limits of how many I can accurately remember. I’ve been wanting to make a WordPress plugin for a while, so why not make a plugin that makes a Coffee Reviews custom post type? (The main goal here is to write my own plugin and learn how it is done, so please don’t suggest already made plugins that I could use.)
Hooks allow you to tap into WordPress without editing the core files. (Rule #1 is to never edit the core files.) You pass functions through hooks to extend or change WordPress functionality.
The register_activation_hook() runs when you press “Activate” on a plugin. Since I’m making a custom post type, I’ll want to use the activation hook to refresh permalinks once the post type is created. If your plugin needs a custom database table, you can create that with a function passed to this hook.
The register_deactivation_hook() is basically the reverse of the activation hook. When you deactivate the plugin, the items passed to this hook fire. I’ll want to clear the permalinks again.
I made a barebones plugin tonight that registers the custom post type. I definitely have more work to do, but saving, hitting refresh, and seeing this appear never gets old!
{%highlightliquid%} Put your foo here bar end foo {%endhighlight%}
I need to go back though my previous posts and remove the Pygments highlighting then uninstall the plugin. Rouge supports fewer languages than Pygments, but Rouge supports all of the languages I use, plus Liquid and Markdown, which Pygments doesnât.
Downloading WordPress.com Email Subscribers
I learned today that it is possible to download a CSV of the email subscribers to your WordPress.com blog (or WordPress.org blog powered by WordPress.comâs JetpackArchived Link). They donât make it obvious, but the option is there:
Back in the summer of 2015, I decided to trash my website and rebuild it from scratch on top of Jekyll, a static site generator.
My goal was two-fold:
Build a new, fresh website to house my personal brand.
Learn the Liquid templating language.
I found a starter theme, gutted it, and spent a week digging in to how Jekyll works in order to build the features I wanted. Along the way I built out some tools and templates for myself and decided to share them on Github.
When doing development work, it is best if you have a separate, dedicated area for each of these things:
Development – The area where you do your development work.
Staging – The area where you deploy changes and thoroughly test them. The only thing that should be out of sync with the production environment is the single change you are testing.
Production – The live system for stable, tested code.
I’ve attempted to replicate this best-practice with the development of my Toggl slash command for Slack. My development environment is on a Homestead box on my local machine. The staging area is a folder on my dev server that a /toggldev command posts to. Once the changes here have been confirmed, I commit my code to the repository and then deploy it to production. The production environment is a folder on my main server that the /toggl command posts to. This is the one my team uses and it stays up to date with releases in the repository.
Of course, the entire process is better if you have version control:
A method for committing changes in Git
Eric Davis advises me that it is better form to commit changes after each feature you want to release is completed rather than commit after a full day of work. If you don’t commit after each feature (and develop each feature in a separate branch), you’ll end up with a mass of code changes in each commit that is about as tangled as spaghetti.
Right now, since I’m the only one working on my Toggl project and the changes I’m making aren’t major, I’ve only been working directly on the master branch. This Atlassian tutorial on branches has convinced me that I should be using branches on a daily basis for development, so I’m going to start that this weekend with some new features I plan to work on.
For the Toggl Slack slash command, I’m using it to check if someone’s Toggl API key is in the array in variables.php:
if(key_exists($user_name,$toggl_api_key_mapping)==FALSE){echo":warning: You haven't set up your Toggl API key with this command yet. Get it at the bottom of https://toggl.com/app/profile and send it to @$your_admin_name.";}
Notes:
Case sensitive. If you need it to be insensitive, use strtolower() on the $key
Boolean (returns TRUE or FALSE)
Looking up a key and returning a value in an array
$array['key']
For the Toggl Slack slash command, I’m using it to set someone’s API key from the array in variables.php:
If you are serving something on your webserver that you don’t want anyone else to be able to access, you can restrict access to by adding this snippet to your site’s .htaccess file:
log.csv>orderallow,denydenyfromall
If you need only a certain IP address, you can achieve this by adding allow from 0.0.0.0 (replace that number with your IP address):
I asked Eric Davis about logging for debugging and usage stats on my Toggl Slack slash command and he suggested that I look into writing to a CSV or JSON file. I opted for CSV.
Here I build the array from the information I get back from Slack (plus a datetime stamp) and pass it to a file called log.csv via fputcsv().
A note on fopen() – A lot of tutorials replace that 'a' with a 'w'. According to the docs, w writes at the beginning of the file, which is why my first couple tries overwrote each other. The a starts writing at the end of the file, which is always a new line since fputcsv() always ends with a line break.
Installation is simple: Clone the project to your _plugins folder and add it to the Plugins section of your _config.yaml, then you are ready to go.
Usage is equally as simple: Specify the language at the end of the first line of your code blocks and the plugin will add the proper classes and highlight the code according to the language.
I didn’t do much technical work today besides some front-end debugging. Instead I did a lot of administrative and project management work and ended up thinking a lot about how I work.
Here is what I thought about.
Always provide a solution
As a consultant, you aren’t paid to tell people they have problems. They already know that and chose to hire you. It is your job to provide solutions.
Instead of being negative or saying that a proposal can’t be done, try to get at the heart of the request and offer an alternative solution. You and your clients will be much happier.
As things get frustrating, it is easy to take the, “look how messed up this thing is” route. But that isn’t your job. You need to roll up your sleeves, brew some coffee, and come up with a solution.
Learning
I find time and time again that I retain so much more of what I learn if I’m applying it as I’m learning. So why do I continue to use books with pre-designed activities that I mindlessly copy? Because it is a lot easier than coming up with a project from scratch.
From now on I’m applying what I learn in my own way. No more copying examples. I’m going to figure it out and learn it the hard way.
Culture
Sometimes you need to find software that is a better fit for your culture. But sometimes you need to take a hard look at the culture and its ability to adapt if there doesn’t seem to be any good solution.
Like learning, sometimes cultural change only comes the hard way: Adapting because it is necessary.
Distractions
Second screens are great for productivity when you are in the zone. Unfortunately they are also great for procrastination when you aren’t in the zone. Sometimes you need to turn that second screen off and focus on one thing at a time.
Filter, filter, filter. Reduce the number of things that can distract you. If you don’t need to make a decision on it, don’t let yourself see it. For example, in Excel, if you only need to read items that have a specific attribute, filter your view by that specific attribute and hide the rest.
Idea for a Slack bot: What is distracting you right now?
Regular messages (10, 2, and 4?) via Slack
Respond with comma separated items that are distracting me.
Save those responses in a database for later analysis
I like to learn by giving myself projects. I treat them as if I were releasing them to the public, even if I’m going to move on after I’ve learned what I want to learn. This is one of those projects. I created a roadmap of features that I probably won’t ever implement, but I learned a ton getting what I have so far to work, so I’m calling this a win.
What I learned
How to read from and write to an API
How to structure complex if/then statements to parse input text
Dealing with arrays in PHP
Deeper regex processing
Unicode conversions
Releasing code to a public repo on Github
Designing security measures for a system deployed on the web
How to structure and design a codebase from scratch
How to work within the bounds of the different systems you are working in and finding ways around barriers
Implementing command line options
Using other projects in your own project via dependency managers like Composer
Writing documentation
Features
Show a list of projects and their corresponding IDs in a given workspace
Show a list of tasks associated with a given project
Add time entries to Toggl straight from Slack’s message input box
Screenshots
Setup & Installation
Dependencies
You must have PHP 5.3.2+ installed locally and on an accessible server.
You need Composer installed locally to install the third-party dependencies.
Two third-party libraries are dependencies included via Composer:
Clone or download this repository onto your local machine
Install Composer in this repository if you don’t already have it
Open a command line terminal and navigate to this directory.
Run: php composer.phar install via the command line to install the third-party dependencies
Configure the variables file.
Copy the variables-dist.php file to variables.php
Fill out the Slack token you got while setting up the slash command.
Fill out users’ Slack usernames with their corresponding Toggl API keys in the array. They can get those keys at the bottom of https://toggl.com/app/profile.
Enter a workspace ID for your team. to find yours, log in to Toggl, then go to https://www.toggl.com/api/v8/workspaces. Pick the ID of the workspace you want to use. Don’t wrap it in quotes; it needs to be an integer.
Set your team’s default timezone. Right now it is set to america/new_york.
Save the file as variables.php in the same directory and you are good to go!
Upload to a server with a valid SSL certificate
Once the dependencies are installed, upload the whole directory to a server running PHP 5.3.2+
Ensure you have a valid SSL certificate. Slash command URLs must support HTTPS and serve a valid SSL certificate. Self-signed certificates are not allowed. Check out CloudFlare for an easy way to obtain a valid certificate.
--date [mm/dd/yy] – Adds the time entry to a specific date. If none is passed, it defaults to today’s date.
--task [task id] – Adds the time entry to a task ID. See above to find your task ID for a project.
Logging
I added basic logging to CSV for usage stats and debugging. This happens individually per project, stored in log.csv. Nothing is transmitted back to me.
If you’d prefer to not log usage, simply comment out lines 14-19 in slash_parsing.php.
Since the log includes a Slack token, you’ll want to deny access to log.csv on your webserver. I achieved that via my .htaccess file.
Unicode quotation marks (sometimes called smart quotes) are those curved/slanted single and double quotation marks: “ ” ‘ ’. The ASCII ones look like this: " '. They are usually interchangeable in word processing, but the stylized ones sometimes cause issues on the web (in a parser, for example).
To convert one to the other in PHP, use iconv():
$output=iconv('UTF-8','ASCII//TRANSLIT',$input);
If you use OS X and want to turn off smart quotes, go to System Preferences > Keyboard > Text and uncheck “Use smart quotes and dashes.”
Remote git repositories
Using git locally is one thing, but it is far more powerful (and exciting!) to push that code to a remote repository like Github for display and collaboration.
Assuming you have a local repository that wasn’t cloned from a remote one, you’ll need to hook it up to a remote repository:
$ git remote add origin
If there is code already on the remote repository, you’ll need to merge it in to your local:
$ git pull $ git merge origin/master
Then push your committed files to the remote repository:
In CSS some styles are automatically inherited from their ancestors (i.e. elements which contain that element). For example, if you set body {color: red;}, all text inside the body element, regardless of what other elements the text is in, will be red unless the color style is set on one of those other elements later in the .css file.
This simultaneously makes writing CSS a breeze and debugging it a bit of a headache. There isn’t a great way to tell if a style is inheritable without looking at the docs.
If you encounter an issue where your style isn’t displaying as it should and it is not responding to changes, check the docs to see if the style can be automatically inherited. If so, check the ancestors of the element you are working on.
The issue I ran into today was that my
snippets kept wrapping no matter what overflow and width were set to. It turns out that word-wrap is automatically inherited and I had it set on an ancestor element.
Date/time conversions in PHP
Date conversions are tricky. Thankfully, PHP has some built-in functions to make this easier.
time() returns the current Unix timestamp (see below)
date() converts either the current time or a given timestamp into a specified format.
Example: date("c", time()) will take the current time (provided as a Unix timestamp) and convert it to ISO 8601 format.
Unix timestamps are the number of seconds that have elapsed since the Unix Epoch (00:00:00 Coordinated Universal Time (UTC), Thursday, 1 January 1970). They can be frustrating at first because they are so foreign looking, but they are really useful because:
They are not subject to timezones.
Since they are simply seconds, time math with Unix timestamps is pretty simple: Convert the time you wand to add or subtract into seconds and do the direct calculation. Then if you want to get it back into a recognizable format, use one of the functions above.
I’ve been working on a custom Slack command to input time into Toggl, so I’ve been doing quite a bit with time conversions to get everything right.
I used to be really interested in how people worked. When they get up, what their morning rituals are, what tools they use, how they use them, etc. While these things are interesting and tell a story about a person, they miss the point.
How someone works isn’t nearly as important as the fact that they are doing the work. They made the choice to do what it takes each day to practice their craft. The rest is minutiae.
If using the GTD method or having morning rituals works for you, great. But don’t think that those things are what really matter. If you’ve committed yourself to doing the work, you’ll find a way. If you haven’t committed yourself, none of the rituals or methods will make a difference.
This commitment is very difficult, but necessary.
Flipping the Status Quo
We all suffer from status quo bias. How do we overcome it? We can get 80% of the way there by:
Instead of asking, “Why should this be different?” ask “Why should this stay the same?” – This is especially powerful when confronting clutter. (By the way, the answer, “because it gives me joy” is a valid reason for keeping something. Change for change’s sake isn’t helpful.)
Recognize the difference between acknowledging a feeling and rationalizing that feeling to keep the status quo.
It was starting to annoy me that my tags were not in alphabetical order on my Today I learned page. So I learned how to sort them alphabetically with Liquid and I added anchor links with counts for each tag.
Slack is wonderful for collaborating with remote teams, but if there is a lot of activity at once, it can be easy to lose files and requests.
If IâÂÂve seen the request or file, I acknowledge by marking it with , then I put it on my to-do list of choice, WunderlistArchived Link. (They have a great Slack commandArchived Link to make this easy: /wunderlist add)
If IâÂÂve fulfilled the request or processed the file, I mark it with
If the request/file is no longer needed or IâÂÂve tried to process it, encountered an error, and notified the appropriate parties, I mark it with so that I know in the future that there was an issue with it instead of assuming it was done and I moved on.
Using SlackâÂÂs great search functionality, I can easily visually figure out what IâÂÂve processed and what is still outstanding.
If I get a request when IâÂÂm in the middle of something else, I copy the link and use SlackâÂÂs /remindcommand to remind me about it later in the day.
There are a lot of things that are easy to track that are completely useless to track.
Make sure the things you track relate directly to your goals.
Sometimes the things you want to track aren’t easy (or possible) to track and you need proxies instead. This is okay.
Visible statistics like Facebook likes and Twitter followers, etc, are easy to obsess over because they are public and they are so easy to find. But don’t fall into to the trap of thinking these numbers are what really matter. Getting more followers is unlikely to be your actual goal. Purchases, downloads, or donations and what directly affects those things are what you should really focus on. The closer the things you test are to your actual goals the better.
Instead of Twitter followers, test and track your click-through rate for specific types of content at different times of day.
Instead of website pageviews, track the length of time on page and how far people scroll down through your content.
Instead of likes on a Facebook status track how many people see that status and follow your calls to action.
Scalability
You can always scale with more people or by working more hours. The trick is to design your business to scale the amount of products and services you provide without a 1:1 (or worse) increase in costs, labor or otherwise. In order to scale you want to become more efficient and more automated. When building your product/service, bake in efficiency and automation from the beginning so you can eventually move on to the next thing (or next version) while it sustains itself.
RSI
I’ve been experiencing some RSI lately in my right wrist, just below my thumb. It primarily hits when I use my mouse for an extended period. I read a number of sources and asked some friends today about how to cope with it. Here are some solutions:
Stretching and regularly stopping to do so during the day
Varying input devices, such as switching between a trackpad and a mouse or a Wacom tablet and a mouse
Switching to a trackpad (like the Magic Trackpad 2) to minimize wrist movements.
I decided to buy a Magic Trackpad 2 and try it. The reason I went with that over a tablet or ergonomic mouse is that I can’t stand the idea of using my computer without gestures. I’d have to change all of my workflows. If the trackpad doesn’t help, I can return it within 14 days for a full refund and try one of the other mice. The past hour of use has been promising. We’ll see.