Skip to content →

The Idea Place Posts

An Update on Using Excel to Track a Fantasy Football Draft

Several years ago I wrote about how I used Excel to track a fantasy football draft. Everything in that post is still relevant but I wanted to provide a short update.

Most importantly, the spreadsheet I use is now available and updated for 2022. See the instructions sheet in the document for how to use it during a fantasy football draft.

The original post talked about my league having 16 players that each fantasy owner drafts. Over the last five years that number has increased to 18.

The short version of how to use this spreadsheet is to:

  1. Update team names on the Teams sheet to reflect players in your league.
  2. During the draft, use the Players sheet to track the player selections by entering the team owner and dollar amount for each player drafted on the Players sheet.
  3. For the various tracking sheets, most notably, the Auction Tracker, use the Data:Refresh Connections command on the Data ribbon or press CTRL+Alt+F5 to have the sheets update with info from what you enter as the draft progresses.
  4. Have fun.

I have made every reasonable effort to verify the accuracy of the formulas and such in this spreadsheet. If you find an issue, please let me know in the comments here or on Twitter, where I am @kellylford.

 

Leave a Comment

Sound From Two Mountain Streams

My wife and I did some hiking in the Rocky Mountains in Colorado this week. Here are two short recordings of a couple mountain streams from our hikes. I always enjoy the sounds of rivers and streams in the mountains and the different sounds they make.

The first was a fairly slow running stream. The second was a bit faster.

I was a bit surprised at the lack of sound in the parts of the mountains we were in. Birds and such were sparse at best and we encountered few streams. The most common sound was the silence of nature. Much as I enjoyed it, it certainly does not make for compelling recording. These two short samples will have to do from this trip.

In these two recordings you hear water running. The first is quieter with a gentle flowing sound. The water is noticeably louder in the second and sounds as though it is running more rapidly.

Leave a Comment

The ADA at 32

A version of this post, with some of the same content, was published last year. A bit of reorganization and some new commentary has been added. I’ve opted to use some of the same content because I do have to ask what has changed in the last year?

If anything, I’d say 31 wasn’t a great year for The Americans with Disabilities Act (ADA) or at the very least, the future is looking less optimistic. The last couple years and months have certainly shown that societal progress is not a certainty and in fact progress can backslide amazingly fast.

July marks the 32nd anniversary of the signing of the ADA. Each year as another year goes by and we celebrate the signing of the legislation, I am torn between feeling celebratory and sad.

I do feel celebratory about the fact that the work of many allowed us to reach this point. As someone who has worked on various accessibility efforts over the years in a small way, I know all too well the toil, endless negotiations and so much more that is required to make progress. So congratulations for sure to those involved in getting this landmark legislation passed and sustained. That is assuredly worth acknowledgement on a grand scale.

Great, celebrate the reality that we have a law that at least gives some hope if it is your choice. I understand perpetual exposure to commentary that it is all trouble can be tough to experience. While you are celebrating, just remember, it isn’t as if in passing the ADA, the amendments to the ADA or other accessibility legislation, Congress has said any of the eight findings they list have gone away.

I urge anyone reading this to read the congressional findings that are listed in the legislation. Like a lot of civil rights legislation, the congressional findings detail that as a class, in this case one to which I belong, people with disabilities are not treated very well and in fact that’s an understatement. Frankly we suffer a staggering amount of outright discrimination and I’m of the opinion that far too often the level of discrimination people with disabilities experience is drastically softened when speaking about the reality of life in the U.S. today. From what I know, the same holds true around the world.

I know from numerous firsthand experiences, calling something discriminatory makes a lot of people uncomfortable. But trust me, experiencing the actual discrimination does much more.

Lest you think discrimination isn’t the right word, here’s the dictionary definition:

“The unjust or prejudicial treatment of different categories of people, especially on the grounds of ethnicity, age, sex, or disability.”

I’m not sure what else you would call much that people with disabilities experience.

To be clear, not all discrimination is intentional in my opinion. In addition, the discrimination is often not the actions of any specific individual but rather the inaction of an organization of some sort, where often well-meaning individuals can find it difficult to go against the inertia that is causing the problematic situations. I also think people get uncomfortable around the term because they think, “Of course I couldn’t discriminate.”

Just because something isn’t intentional does not mean it isn’t happening. Words do matter and how we label what people with disabilities experience daily has an impact on how it is perceived. I recognize on the continuum of circumstances in life, I’m amazingly fortunate. The fact that I can write these words on a computer as someone who’s blind speaks volumes by itself. I have a high degree of security—food, shelter, employment, freedom from war, health insurance and so much more.

If reading that there are multiple challenges is tough or that something seems discriminatory, just remind yourself that the following are still part of the society we’ve created here in the U.S. according to our own congress.

The Congress finds that

(1) physical or mental disabilities in no way diminish a person’s right to fully participate in all aspects of society, yet many people with physical or mental disabilities have been precluded from doing so because of discrimination; others who have a record of a disability or are regarded as having a disability also have been subjected to discrimination;

(2) historically, society has tended to isolate and segregate individuals with disabilities, and, despite some improvements, such forms of discrimination against individuals with disabilities continue to be a serious and pervasive social problem;

(3) discrimination against individuals with disabilities persists in such critical areas as employment, housing, public accommodations, education, transportation, communication, recreation, institutionalization, health services, voting, and access to public services;

(4) unlike individuals who have experienced discrimination on the basis of race, color, sex, national origin, religion, or age, individuals who have experienced discrimination on the basis of disability have often had no legal recourse to redress such discrimination;

(5) individuals with disabilities continually encounter various forms of discrimination, including outright intentional exclusion, the discriminatory effects of architectural, transportation, and communication barriers, overprotective rules and policies, failure to make modifications to existing facilities and practices, exclusionary qualification standards and criteria, segregation, and relegation to lesser services, programs, activities, benefits, jobs, or other opportunities;

(6) census data, national polls, and other studies have documented that people with disabilities, as a group, occupy an inferior status in our society, and are severely disadvantaged socially, vocationally, economically, and educationally;

(7) the Nation’s proper goals regarding individuals with disabilities are to assure equality of opportunity, full participation, independent living, and economic self-sufficiency for such individuals; and

(8) the continuing existence of unfair and unnecessary discrimination and prejudice denies people with disabilities the opportunity to compete on an equal basis and to pursue those opportunities for which our free society is justifiably famous, and costs the United States billions of dollars in unnecessary expenses resulting from dependency and nonproductivity.

Leave a Comment

Fireworks Audio From Tuttle Lake

Warning: The audio linked to inn this post has multiple explosive sounds and they do start at the beginning and some can be loud.

Over the holiday weekend I was at a family cottage at Tuttle Lake in Wisconsin. Each 4th of July weekend, there is a sizable private fireworks display put on by some cottage owners at the lake.

This year, I captured some of the audio and find the sounds of fireworks over open water an interesting sound. I don’t have the audio equipment to capture the full sound field or the way the concussions echo around the lake but this is still an interesting sound. The fireworks are shot from across the lake, pretty much in a direct line of sight to the end of the dock I was sitting on to capture this.

In this audio you can hear the lingering echos of the explosions but live, you can hear them really sort of move around the lake.

With all that’s going on in the world, I do have to wonder too how these same explosions and yells could be the sounds of war and terror. I feel very fortunate to live where I do and not have had to experience the horror of war directly.

I know there are people on all sides of the political spectrum but will say I hope we can all find a way to come together and protect the people of our country, the institutions of the U.S. Government and work to make life better for the people and planet. It is far from perfect and I know firsthand many of the ways we need to improve but this is the world we have and I hope we can all remember we need to share it with each other and our future.

Leave a Comment

Transcribing Audio with Word Online and a Screen Reader

One of the handy but not so obvious features of a Microsoft 365 subscription in my opinion, is the ability to transcribe 300 minutes of audio a month using the online version of Word. I’ve been using this on and off for many months but have started making regular use of it for some personal projects of late. I also noticed a note when uploading audio recently, that the 300 minute restriction appears to be removed. A note in the transcription area said you can now upload unlimited audio. It did also say this may change in the future but this change makes the audio transcription functionality even more compelling to me.

Office has a help article on using this experience. Here are some notes on using this experience with a screen reader in particular that go a bit further than the help article.

Creating a Document

First off, you are going to want to create a new Word document using the online version of Word. I do this by navigating to http://word.office.com and choosing the option to create a new document. Since Word online works best with any screen reader virtual mode off, I typically turn off the JAWS VPC, Narrator Scan Mode or NVDA Browse mode before navigating to the site.

Assuming you are signed into your Microsoft 365 account, focus should land on the Create a New Blank Document link. Simply activate that link and a new document is created and focus is moved to the editing area.

Transcribing Audio

With focus in the document area, you are going to want to access the Dictation option on the Ribbon and specifically the Transcription option. There are different ways to navigate but what I do is:

  1. Press CTRL+Shift+F6 once to access the ribbon. You should be on the Home option. If on a Mac replace CTRL with CMD.
  2. Press Tab once to access the options on the Home ribbon.
  3. To move to different groups of controls here you can use CTRL+Left and Right arrows. Again, replace CTRL with CMD if on a Mac. I have found it faster to use CTRL+Left arrow from here until I reach the group that announces as Voice with focus on a Dictate button.
  4. Press alt+Down Arrow to access the choices here. Replace Alt with Option if on a Mac.
  5. Arrow down to Transcribe and press Enter.
  6. A new pane will open and focus should go to it. If for some reason it does not, again use CTRL+F6 and CTRL+Shift+F6 to locate the Transcribe Pane.
  7. Tab to the Upload audio button and activate it.
  8. You will get the standard File Open dialog for the operating system you are using. Locate the audio file you want to transcribe and upload the audio.
  9. You will get messages about the audio uploading and being transcribed. I have found it fastest to toggle on the virtual mode for a screen reader and read this text. You should find the text a couple lines above a cancel button when reading in this fashion. Remember to turn back off any virtual mode when done reading. Transcription is quite fast in my experience. It is usually done in less than three minutes for both uploading and transcribing an hour’s worth of audio for me.
  10. When the transcription is finished, you will have some new elements in this pane. They will include:
    1. A list of all the recognized speech you can arrow up and down to review/edit. Tab from an entry in this list for an edit button if you want to make an adjustment to the transcription.
    2. Note that if you choose Edit, a new dialog opens with the section of text in an edit box and the speaker identification in a second edit area. You can adjust the speaker name and there is an option to do it for the entire document as well.
    3. After you arrow to any transcript section, there is also a tab stop to that specific segment. Press enter on this to start audio playing at that point.
    4. Controls for adding sections or all the text to the document.
    5. Audio controls for playing the audio you transcribed.
  11. Use the Add to Document button. You will have choices for Text, text, text with speaker identification, text with timestamps or text with both speakers and timestamps. Use up and down arrow to move through choices and Press enter on the item you want.
  12. Focus will likely stay on the Add to Document button. Use CTRL+Shift+F6 to move back to the document area. You will be at the end of any inserted text.

At this point you can make any adjustments to the text you want. For minor edits, I will use either the edit transcription functionality in the Transcribe Pane or Word Online. For extensive edits, I tend to open the document in the full desktop version of Word. For example, a global search and replace can change all references of Speaker 1 to a specific name.

By default the document, is saved in the root of your OneDrive folder and can be edited online or with the desktop version of Word. Speech to text transcription still requires some editing but this is another helpful tool to use from my experience.

3 Comments

Accessibility Island, The Journey of Many Experienced As One

When I think of an island, tropical breezes, ocean surf and the warm sun-soaked sand between my toes is usually what comes to mind. Add in a blissful smile from memories of warm island beaches I’ve been fortunate to visit and for me the term island is generally a joyous one.

What then you ask do such happy ideas have to do with the term Accessibility Island? Yes, there is much that is joyous about both accessibility and islands but certainly not all.

I use the term accessibility island because of perhaps one of the downsides of island life. As marvelous as an island can be, you can be cut off from other parts of the world. Constraints, water in this case, can restrain you from all you want to reach.

So too with accessibility failings. You can be quickly cut off from achieving all you want, again through no fault of your own.

Several years ago I was talking with a good friend about the reality of working as an adult with a disability and how it differed from what we had expected before launching our careers. I don’t remember all the details of that conversation but now more than 30 years into my own career, the one thing I do recall being most surprised about hasn’t really changed. There are many, far too many in fact, times when you feel cut off or isolated through no choice of your own. I won’t lay claim to speaking for anyone other than myself here but suspect I’m not alone from various conversations I’ve had over the years.

At the start of my career, it was the meeting with paper handouts distributed to everyone. Oh and even me if I really wanted something I couldn’t read I could get the handouts also, to be read of course by that ubiquitous “someone can help you.” . Through all the technology changes, it is still far too common to end up in the functionally same situation. Sure you might get the PowerPoint deck, web site or app shared ahead of time but if the content itself isn’t consumable with a screen reader in my case it might as well be the same as those paper handouts.

This can be especially true in training or other learning activities. Accessibility Island is trying to learn the material in a class at the same time you are both educating the course creator about accessibility and figuring out how to use the technology in the course. Three for the price of one might be a great deal when shopping but is a disaster when trying to learn.

Anyone who has worked or lived around accessibility I’m sure can rattle off a long list of common failings. The point here isn’t to chronicle all that can and is wrong with the state of accessibility. Instead, it is to say that the truly unfortunate thing is that you are still left without a good alternative in far too many situations. Stay silent and you may not be able to contribute effectively because you are acting on limited information. Speak up and you are still far too often seen as complaining, not patient or counseled how you should have “handled that situation better” by someone after the fact. Please tell me how you should handle exclusion better other than feeling sad, frustrated, hurt and yes willing to educate still.

Meetings or training are not the point here. The examples are really illustrative of the entire workplace. What happens when a new software program, update or other technology is deployed? Has the organization ensured the experience is usable for everyone in the workplace?

Ask yourself how many workplaces are free from blocking accessibility issues? Now ask yourself what the new employee encountering these issues who is new to the organization, job or manager is supposed to do? Unless you have a policy in place ahead of time for how you are going to handle these sorts of situations, you are leaving the employee to potentially struggle and spend needless energy trying to figure out what they should do? You are also locking the employee out of opportunities and your organization out of all the employee has to contribute.

These are examples of finding yourself on what I’m calling accessibility island. You are alone, cut off and isolated.

Authenticity, the “lived experience” and such are the hot topics of the day in various diversity and accessibility circles. This is great but then do not shy away when people want to let you in on their true experiences. Don’t try and tell us all the things we could have done differently or how things will be fixed in a certain amount of time or to be patient. If you feel compelled to tell anyone anything, when you learn about people on Accessibility Island, tell those involved in sending people to such a destination what they can do differently.

Trust me, anyone who’s taken even one trip to Accessibility Island has likely tried dozens of creative problem solving techniques. Given the lack of alternatives I mentioned earlier I can also assure you that for anyone to actually show an outward sign that they’ve journeyed to Accessibility Island, things have to be quite problematic. The fact that is reality, is itself a problem too. It should be a safe space to acknowledge that you are experiencing such issues.

Educate about accessibility, ask if your organization has the right resources, not just policies, to ensure an accessible workplace. Do you have the right institutional policies and procedures in place from procurement onward to ensure what you are bringing into the workplace represents the values and qualities you want for your world? Are those policies backed with the resources and knowledge to ensure the policies are actually applied and working? Do employees have the necessary information and training to be successful and avoid sending their colleagues on unintentional trips to Accessibility Island?

I know for myself, I want to choose when I go to an island because I want to enjoy those tropical breezes, the sand and surf. I do not want to be isolated, trying to contribute and locked out. I’ve had more than enough visits to Accessibility Island.

2 Comments

Creating a Power BI report Using a Screen Reader

In my work at Microsoft, I work with a number of product teams on accessibility. One of the rewarding things about this is that I get to learn about a number of technologies and experiences. This is obviously accompanied by working to improve the accessibility and user experiences of these products.

I’ve been working with the Power BI team for close to a year and have learned a great deal about the technology. Creating a Power BI report using a screen reader is one of those things that having a few hints about how things work and such can save a lot of time learning what to do.

I put together this audio demo of the basics of creating a report, adding data to the report, understanding the visual layout of the report and how a few of the basic controls work. A transcript in text or Word is also available.

Microsoft has documentation on creating reports available. Accessibility information for creating reports and consuming them is also available. A help article on creating reports using assistive technology has also been created. You can also find various resources on the Power BI roadmap and other release plans.

If you have accessibility questions or concerns on Power BI, the Microsoft enterprise Disability Answer Desk is there to assist.

Leave a Comment

Some Training Videos From Me

In my work at Microsoft, I’ve created a few training resources recently. These have been shared in other arenas but I wanted to share them here as well. The list includes:

Leave a Comment

Variations on an Automatic Image Description

Reading through Twitter today, the following tweet showed up on the timeline of one of the people I follow as a retweet.

Doc🐕 – @DocAtCDI: A truck loaded with thousands of copies of Roget’s Thesaurus spilled its load leaving New York

Witnesses were stunned, startled, aghast, stupefied, confused, shocked, rattled, paralyzed, dazed, bewildered, surprised, dumbfounded, flabbergasted, confounded, astonished, and numbed.

I found the tweet amusing and was going to retweet but noticed it had a picture without any alt text. This lead me to be curious what was in the picture. From the tweet text, I’m assuming some form of vehicles on a road with a bunch of books scattered about is most likely.

I suspect most reading this know that iOS has the ability to automatically describe pictures. This functionality started in iOS 14. When using VoiceOver you can have a short machine-generated description of pictures such as the one attached to the tweet here.

Newer versions of iOS extended this functionality to include a feature called Explore Image. That allows you to use VoiceOver to step through individual objects recognized in the image. It can be accessed with a rotor option when focussed on the image. Here is where the experience gets a bit interesting.

My go to Twitter app on the iPhone is Twitterific. The accessibility of the app has been outstanding for years and the maker has been highly responsive if issues to creep in.

I’ve also been exploring another highly accessible Twitter app named Spring. So far I’ve had a great experience with this app as well.

As one would expect, both Twitterific and Spring offer the ability to view images included with tweets. When images are viewed in either app, the VoiceOver automatic image description and Explore Image functionality work. Differences in the same picture viewed in two different apps using the same automatic image description and exploration technology are plainly obvious though.

First off, the automatic description when viewing the image in Twitterific says:

an illustration of vehicles on a road X. VETERAN’S PLUMRNO. Rall

That same image viewed in Spring yields the following automatic description:

a group of cars driving on a highway ETERAN ‘S PLUMPING

Both descriptions mention that the picture deals with vehicles on a road in some fashion. and include what I’d suspect is the text of a sign on a van or truck in the picture from a plumbing company. Again the descriptions come from Apple, not the individual apps.

A picky point but cars do not drive, people drive them. I might not know what is in the photo for certain but I am quite confident it isn’t a bunch of Teslas with the self-driving mode engaged.

It is also interesting how the image description when using Spring is a bit more detailed. It uses the terms highway and cars, whereas the Twitterific version is more generic in nature. The detail about cars when using Spring is even more interesting when using the Explore Image feature to review the individual objects in the picture.

Again, the newest versions of iOS added a feature called Explore Image to VoiceOver. Focus an image, change the VoiceOver rotor to Actions and one of the choices will be Explore Image. This opens a pop-over experience with individual objects from the picture. You can use VoiceOver previous and next commands to move from object to object and have them highlighted visually in the picture.

Here are the objects from the picture in the tweet I mentioned when explored with Twitterrific:

  • Automobile near left edge
  • Automobile Centered
  • Automobile near right edge

Recall how the automatic description for Spring talked about cars driving on a highway? One can only wonder where the cars went and where the train came from when using the Explore Image feature. Here is what is reported when exploring the image in Spring.

  • Van near bottom-left edge
  • Van near right edge
  • Van near bottom-left edge
  • Train near top edge

Automatic image descriptions are another helpful tool for shaping the accessibility landscape. They’ll be even more impactful if the technology continues to advance to reduce the variability of something as simple as viewing an image in a different program seems to introduce and the accuracy and detail of what is described improves.

Leave a Comment

What Happens After the Accessibility Agreements End?

It is unfortunate that it takes landmark agreements far too often for progress on accessibility in the first place. Several years ago Major League Baseball was heralded for their agreement and commitment to accessibility. Progress was indeed made and I know I was one who commented on the agreement and progress.

The agreement closing date has long past and so the answer to the question about what happens afterword in their case is, “Unlabeled image Unlabeled image /121.svg.” If you don’t like that answer, how about “Unlabeled image Unlabeled image /140.svg?” Both of those answers are taken from www.mlb.com/scores as of this writing, and are how two teams are indicated from the live scoreboard when accessed with multiple screen readers.

They are just two of the more than 370 accessibility failures reported by multiple accessibility auditing tools run on the page. Of course, accessibility tools are just part of the story and I’m a big fan of user testing for accessibility. In this case I’m serving that role and just wanted to look up the score of a ballgame. I guess when I sort out who is represented by 121 or 140, I’ll know the score.

This is not a criticism of the efforts that lead to MLB’s agreement. It is, however, a serious question around what it is going to take to make accessibility matter long after the agreements end because I can assure you representing a baseball team as 121, 140 or any other random nonsense is not accessibility the way I want to experience it.

Leave a Comment