Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.os.linux.advocacy > #684500 > unrolled thread

Microsoft Excel World Championships!

Started byDFS <guhnoo-basher@linux.advocaca>
First post2025-01-23 08:46 -0500
Last post2025-01-24 17:39 -0500
Articles 14 — 8 participants

Back to article view | Back to comp.os.linux.advocacy


Contents

  Microsoft Excel World Championships! DFS <guhnoo-basher@linux.advocaca> - 2025-01-23 08:46 -0500
    Re: Microsoft Excel World Championships! Tyrone <none@none.none> - 2025-01-23 14:21 +0000
      Re: Microsoft Excel World Championships! DFS <guhnoo-basher@linux.advocaca> - 2025-01-23 09:47 -0500
        Re: Microsoft Excel World Championships! CrudeSausage <crude@sausa.ge> - 2025-01-23 11:54 -0500
        Re: Microsoft Excel World Championships! Flyer <nopenotachance@hotmail.com> - 2025-01-23 20:03 -0500
          Re: Microsoft Excel World Championships! CrudeSausage <crude@sausa.ge> - 2025-01-23 20:51 -0500
          Re: Microsoft Excel World Championships! Chris Ahlstrom <OFeem1987@teleworm.us> - 2025-01-24 07:43 -0500
      Re: Microsoft Excel World Championships! Chris Ahlstrom <OFeem1987@teleworm.us> - 2025-01-23 10:45 -0500
      Re: Microsoft Excel World Championships! RonB <ronb02NOSPAM@gmail.com> - 2025-01-23 21:12 +0000
    Re: Microsoft Excel World Championships! rbowman <bowman@montana.com> - 2025-01-23 18:17 +0000
      Re: Microsoft Excel World Championships! DFS <guhnoo-basher@linux.advocaca> - 2025-01-23 23:07 -0500
    Re: Mightgrowsoft Excel World Championships! Lawrence D'Oliveiro <ldo@nz.invalid> - 2025-01-24 01:00 +0000
      Re: Mightgrowsoft Excel World Championships! Chris Ahlstrom <OFeem1987@teleworm.us> - 2025-01-24 07:41 -0500
    Re: Microsoft Excel World Championships! DFS <guhnoo-basher@linux.advocaca> - 2025-01-24 17:39 -0500

#684500 — Microsoft Excel World Championships!

FromDFS <guhnoo-basher@linux.advocaca>
Date2025-01-23 08:46 -0500
SubjectMicrosoft Excel World Championships!
Message-ID<vmth7q$1l73o$3@dont-email.me>
Twelve Dudes and a Hype Tunnel: Scenes from the ‘Super Bowl for Excel Nerds’

At the Microsoft Excel World Championship in Las Vegas, there was 
stardust in the air as 12 finance guys vied to be crowned the world’s 
best spreadsheeter.


0:00/1:30
Highlights From the Microsoft Excel World Championship
The event’s organizer hopes to turn competitive Excel into a popular 
e-sport where pros compete for million-dollar prizes and big-league 
glory. That’s still a ways off.

♫ It’s the Excel World Championship. ♫ ♫ Who is going to win? ♫ “The 
Annihilator. The Child from Chile.” ♫ Who’s going in the spreadsheet 
bin? ♫ “You are not prepared.” “None of us are.” “Three, two, one, 
Excel!” “This is a tough case.” “It is.” “Oh, look at that. And he’s 
made the numbers out of it on off to the side.” “10 seconds.” “Come on.” 
“Anything. Is anything going to happen?” “Michael Jarman—” “Look at 
that!” “Takes the win. All those years of training have come to this 
moment in 2024.” “The world championship.”

Reporting by Yan Zhuang
Photographs by Mikayla Whitmore
Videos by Shawn Paik

Yan Zhuang, an Excel novice, reported from an e-sports arena in a Las 
Vegas hotel.
Jan. 20, 2025

Like soccer players taking the field in a giant stadium, the 12 
finalists ran through a glowing “hype tunnel,” some wearing jerseys with 
sponsorship logos. As an announcer bellowed introductions and cameras 
captured their every move, they approached a neon-lit stage to raucous 
cheers.

Then the men sat down at desktop computers, opened their Microsoft Excel 
spreadsheets and began to type.

Excel, a program that does complex math on a human’s behalf, is often 
associated, rightly, with corporate drudgery. But last month, in a Las 
Vegas e-sports arena that typically hosts Fortnite and League of Legends 
tournaments, finance professionals fluent in spreadsheets were treated 
like minor celebrities as they gathered to solve devilishly complex 
Excel puzzles in front of an audience of about 400 people, and more 
watching an ESPN3 livestream.

Organizers call the event the Microsoft Excel World Championship. “Yes, 
it is a thing,” the official website says.

Excel contestants reading instructions at the HyperX Arena in Las Vegas.
At stake was a $5,000 prize, a wrestling-style championship belt and the 
title of world’s best spreadsheeter. But the organizer, Andrew 
Grigolyunovich, is dreaming bigger. He hopes to turn competitive Excel 
into a popular e-sport where pros compete for million-dollar prizes and 
big-league glory.

“Excel was always thought of as a back-office product,” said Mr. 
Grigolyunovich, a Sudoku champion from Latvia. But in Vegas, “these 
people who are working, I don’t want to say boring jobs — but, you know, 
regular jobs — they could become stars.”

If that seems too ambitious, we’d like to introduce you to Erik Oehm, a 
software developer from San Francisco, who watched the action from the 
front row.

“This is the Super Bowl for Excel nerds,” Mr. Oehm said. “If Excel is 
the center of your universe, this is like hanging out with LeBron James 
and Kobe Bryant.”

Michael Jarman overtook the frontrunners as the competition progressed.
The “LeBron James of Excel,” as he was introduced in Vegas, was Diarmuid 
Early, 39, an Irish financial consultant who lives in New York, who 
entered the arena in jeans, sandals and a jersey patterned to resemble 
abdominal muscles. The Kobe Bryant was Andrew Ngai, 37, a soft-spoken 
actuary from Australia known as the Annihilator, who began the world 
championship as its reigning three-time champion.

“We’re friends — for now,” Mr. Early joked as they posed for a photo. 
But his anxiety was palpable.

“I probably take it too seriously,” he said. “I’m very invested in it.”

The format for the finals was a mock-up of World of Warcraft, an online 
role-playing game. It required the 12 men (this particular nerdfest was 
mostly a guy thing) to design Excel formulas for tracking 20 avatars and 
their vital signs. If that sounds unfathomably complicated, it was: The 
players were handed a seven-page instruction booklet.

To prepare, Mr. Early adjusted the width of his Excel columns with the 
precision of a point guard lining up a 3-point shot. Mr. Ngai queued up 
a YouTube compilation of “focus music.”

After an announcer kicked off the 40-minute event — “Five, four, three, 
two, one, and Excel!” — the 12 players leaned over their keyboards and 
began plugging in formulas. One example: “=CountChar(Lower(D5),”W”)” 
allowed one competitor, Michael Jarman, to figure out how many times the 
letter “W” appeared in a spreadsheet.

The aim was to score as many points as possible while staying ahead of 
rolling eliminations. As cascading answers filled Excel columns, Mr. 
Ngai took a significant lead, to audible gasps. Then he got stuck on a 
problem, as did Mr. Early. Mr. Jarman pulled ahead as the two 
front-runners frantically tried to troubleshoot.

“Oh my gosh, oh my gosh,” Mr. Oehm chanted.

Mr. Ngai queued up a YouTube compilation of “focus music” to help him 
concentrate on Excel formulas.

The players received a seven-page instruction booklet explaining the 
rules for the finals.

‘Well, this is ridiculous.’

The first electronic spreadsheet was VisiCalc, an “electronic 
blackboard” that automated pen-and-paper calculations. Microsoft 
introduced Excel in 1985. The company says its suite of office software, 
which includes Excel, has more than 400 million users. (Google has said 
that more than three billion people use its free suite of products, 
including Gmail and a spreadsheet program called Sheets.)

Part of the appeal, and the intimidation factor, of spreadsheets is 
their undefined scope. Excel can be a dating organizer or a tool for 
collating a country’s coronavirus caseload, for example.

Speaking in almost philosophical terms, Bob Frankston, a founder of 
VisiCalc, said that people who treat Excel merely as a finance tool 
ignore its vast potential. “They don’t realize it’s a mirror” of their 
minds, he said. “The financial planning tool they’re seeing is in their 
head.”

But for millions of people, it’s still just a tool for accomplishing the 
tasks their corporate overseers assign to them. It may say something 
about our times that the instruments of our servitude are also the basis 
of our games.

The first Excel competition, ModelOff, started in 2012. But ModelOff, 
which featured financial problems that took hours to solve, was not 
designed with thrills in mind.

When ModelOff was discontinued after seven years, Mr. Grigolyunovich, a 
former competitor, created the Financial Modeling World Cup, the 
organization that runs the Excel championship and other events. The 
championship — which has several corporate sponsors, including Microsoft 
— was held in person for the first time last year. He said its shortened 
rounds, eliminations, commentators and pregame “hype tunnel” were 
designed to raise tension and lure spectators.

“I remember thinking ‘Well, this is ridiculous, why do we have this?’” 
Mr. Jarman, 30, a British financial consultant who lives in Toronto, 
said of the tunnel. “But it’s all in good fun. And if the other e-sports 
do it, we should too.”

Mr. Grigolyunovich said his vision for future tournaments includes more 
spectators, bigger sponsors and a million-dollar prize for the winner. 
For now, many fans find out about the Excel championship through ESPN’s 
annual obscure sports showcase, where it is sandwiched between 
competitions like speed chess and the World Dog Surfing Championships.

Reluctant rivals
The competitors in Vegas said winning requires not just Excel-know how, 
but also problem-solving acumen, composure under pressure and intuition 
— or luck. Add the frisson of a live audience, they say, and the 
competition starts to resemble a sport in its unpredictability, if not 
physicality.

They seemed less interested in Mr. Grigolyunovich’s visions of fame and 
fortune, and more focused on adjusting to the transformation of their 
staid, niche hobby into a televised spectacle. Mostly they had come to 
geek out with fellow Excel buffs. Between rounds, they attended 
spreadsheeting workshops and added each other on LinkedIn.

More rivalries could help to build some excitement, several contestants 
said — but they were too polite, and on too friendly terms with one 
another, to initiate any.

The Excel championship featured a live audience of about 400 people. 
Other fans watched an ESPN3 livestream.
“Basically everything that they do to make it more fun for viewers makes 
it more traumatic for competitors,” Mr. Early said.

There was a bit of celebrity stardust in the air, though, as Mr. Early 
and Mr. Ngai, the LeBron and Kobe of Excel, fielded a stream of selfie 
requests.

“This guy is amazing,” one quarterfinalist, Joy Hezekiah Andriamalala, a 
finance student from Madagascar, said to a reporter after snapping a 
photo with Mr. Ngai. “Do you know him? Personally?”

Mr. Ngai, who appeared resigned to the possibility of losing his 
championship streak, admitted that being a minor celebrity for a few 
days was “pretty cool.” He said he had started to treat competitive 
Excel more like a sport than a hobby, setting aside more time to practice.

Onstage, the front-runners tried to prevent Mr. Jarman from running away 
with the championship belt. Mr. Early won a semifinal round by turning 
screens of mazes made of colored cells and emojis into numbers. In the 
finals, Mr. Ngai tried a Hail Mary: filling his remaining cells with 
random numbers.

As the clock ticked down to zero, Mr. Jarman turned to stare at the 
leaderboard.

“Ten seconds, is anything going to happen?” a commentator, Oz du Soleil, 
shouted. Nothing did.

Mr. Jarman leaped out of his seat and threw his hands in the air, his 
face gleaming with sweat. The audience erupted. “Look at that! Look at 
that!” Mr. du Soleil yelled.

Mr. Jarman held the championship belt aloft as someone dumped glitter on 
his head. Mr. Oehm let out a breath he had been holding.

“You’d never see this with Google Sheets,” he said. “You’d never get 
this level of passion.”


https://www.nytimes.com/2025/01/20/us/microsoft-excel-world-championships.html


This is SO SO cool!


MS Office is doomed by the LeeberOffice juggernaut

[toc] | [next] | [standalone]


#684502

FromTyrone <none@none.none>
Date2025-01-23 14:21 +0000
Message-ID<XeCcnbotqt3DzQ_6nZ2dnZfqnPSdnZ2d@supernews.com>
In reply to#684500
On Jan 23, 2025 at 8:46:36 AM EST, "DFS" <guhnoo-basher@linux.advocaca> wrote:

> “This is the Super Bowl for Excel nerds,” Mr. Oehm said. “If Excel is
> the center of your universe, this is like hanging out with LeBron James
> and Kobe Bryant.”

If Excel is the center of your universe, then you need to Get A Life. And a
girlfriend. Maybe even a dog.

> This is SO SO cool!

You misspelled "pathetic". 

This is quite possibly the most ridiculous thing I have ever read on usenet. 
 And as you can imagine, that's up against some pretty stiff competition.

[toc] | [prev] | [next] | [standalone]


#684503

FromDFS <guhnoo-basher@linux.advocaca>
Date2025-01-23 09:47 -0500
Message-ID<vmtkp9$1lsjt$2@dont-email.me>
In reply to#684502
On 1/23/2025 9:21 AM, Tyrone wrote:
> On Jan 23, 2025 at 8:46:36 AM EST, "DFS" <guhnoo-basher@linux.advocaca> wrote:
> 
>> “This is the Super Bowl for Excel nerds,” Mr. Oehm said. “If Excel is
>> the center of your universe, this is like hanging out with LeBron James
>> and Kobe Bryant.”
> 
> If Excel is the center of your universe, then you need to Get A Life. And a
> girlfriend. Maybe even a dog.

They mean work universe, of course.

And for millions of people in finance and accounting and decision 
sciences, Excel is what they spend all day using.



>> This is SO SO cool!
> 
> You misspelled "pathetic".

In a world of extreme ironing and worm charming contests, an Excel 
competition is very cool and relatable.



> This is quite possibly the most ridiculous thing I have ever read on usenet.
>   And as you can imagine, that's up against some pretty stiff competition.

The most pathetic thing on Usenet is Chris Ahlstrom.

[toc] | [prev] | [next] | [standalone]


#684507

FromCrudeSausage <crude@sausa.ge>
Date2025-01-23 11:54 -0500
Message-ID<ovukP.1374449$DYF8.858983@fx14.iad>
In reply to#684503
On 1/23/25 9:47 AM, DFS wrote:

>> This is quite possibly the most ridiculous thing I have ever read on 
>> usenet.
>>   And as you can imagine, that's up against some pretty stiff 
>> competition.
> 
> The most pathetic thing on Usenet is Chris Ahlstrom.

I concur.

-- 
CrudeSausage
Gab: @CrudeSausage
Telegram: @CrudeSausage
Unapologetic paleoconservative
KDE supporting member
ASUS Zephyrus GA401QM on Manjaro

[toc] | [prev] | [next] | [standalone]


#684528

FromFlyer <nopenotachance@hotmail.com>
Date2025-01-23 20:03 -0500
Message-ID<MPG.41fcb0e2bee521569897ff@news.giganews.com>
In reply to#684503
In article <vmtkp9$1lsjt$2@dont-email.me>, guhnoo-
basher@linux.advocaca says...
> 
> On 1/23/2025 9:21 AM, Tyrone wrote:
> > On Jan 23, 2025 at 8:46:36 AM EST, "DFS" <guhnoo-basher@linux.advocaca> wrote:
> > 
> >> ?This is the Super Bowl for Excel nerds,? Mr. Oehm said. ?If Excel is
> >> the center of your universe, this is like hanging out with LeBron James
> >> and Kobe Bryant.?
> > 
> > If Excel is the center of your universe, then you need to Get A Life. And a
> > girlfriend. Maybe even a dog.
> 
> They mean work universe, of course.
> 
> And for millions of people in finance and accounting and decision 
> sciences, Excel is what they spend all day using.
> 
> 
> 
> >> This is SO SO cool!
> > 
> > You misspelled "pathetic".
> 
> In a world of extreme ironing and worm charming contests, an Excel 
> competition is very cool and relatable.
> 
> 
> 
> > This is quite possibly the most ridiculous thing I have ever read on usenet.
> >   And as you can imagine, that's up against some pretty stiff competition.
> 
> The most pathetic thing on Usenet is Chris Ahlstrom.

Chris Ahlstrom appears to be a hen pecked soy boy.
I am assuming Chris is a he, but he acts more like a she.

[toc] | [prev] | [next] | [standalone]


#684531

FromCrudeSausage <crude@sausa.ge>
Date2025-01-23 20:51 -0500
Message-ID<umCkP.1107790$DPl.549844@fx13.iad>
In reply to#684528
On 1/23/25 8:03 PM, Flyer wrote:
> In article <vmtkp9$1lsjt$2@dont-email.me>, guhnoo-
> basher@linux.advocaca says...
>>
>> On 1/23/2025 9:21 AM, Tyrone wrote:
>>> On Jan 23, 2025 at 8:46:36 AM EST, "DFS" <guhnoo-basher@linux.advocaca> wrote:
>>>
>>>> ?This is the Super Bowl for Excel nerds,? Mr. Oehm said. ?If Excel is
>>>> the center of your universe, this is like hanging out with LeBron James
>>>> and Kobe Bryant.?
>>>
>>> If Excel is the center of your universe, then you need to Get A Life. And a
>>> girlfriend. Maybe even a dog.
>>
>> They mean work universe, of course.
>>
>> And for millions of people in finance and accounting and decision
>> sciences, Excel is what they spend all day using.
>>
>>
>>
>>>> This is SO SO cool!
>>>
>>> You misspelled "pathetic".
>>
>> In a world of extreme ironing and worm charming contests, an Excel
>> competition is very cool and relatable.
>>
>>
>>
>>> This is quite possibly the most ridiculous thing I have ever read on usenet.
>>>    And as you can imagine, that's up against some pretty stiff competition.
>>
>> The most pathetic thing on Usenet is Chris Ahlstrom.
> 
> Chris Ahlstrom appears to be a hen pecked soy boy.
> I am assuming Chris is a he, but he acts more like a she.

His wife took his balls away a long time ago, but promised that she'd 
give them back if he was a good boy.

-- 
CrudeSausage
Gab: @CrudeSausage
Telegram: @CrudeSausage
Unapologetic paleoconservative
KDE supporting member
ASUS Zephyrus GA401QM on Manjaro

[toc] | [prev] | [next] | [standalone]


#684536

FromChris Ahlstrom <OFeem1987@teleworm.us>
Date2025-01-24 07:43 -0500
Message-ID<vn01u0$27mq5$2@dont-email.me>
In reply to#684528
Flyer wrote this post while blinking in Morse code:

> soy boy

Looks like someone is obsessed with soi bois and their "tofu".

    https://soyboy.com/

-- 
Outside of a dog, a book is a man's best friend.  Inside a dog it's too
dark to read.
		-- Groucho Marx

[toc] | [prev] | [next] | [standalone]


#684506

FromChris Ahlstrom <OFeem1987@teleworm.us>
Date2025-01-23 10:45 -0500
Message-ID<vmto79$1mi49$2@dont-email.me>
In reply to#684502
Tyrone wrote this post while blinking in Morse code:

> On Jan 23, 2025 at 8:46:36 AM EST, "DFS" <guhnoo-basher@linux.advocaca> wrote:
>
>> “This is the Super Bowl for Excel nerds,” Mr. Oehm said. “If Excel is
>> the center of your universe, this is like hanging out with LeBron James
>> and Kobe Bryant.”
>
> If Excel is the center of your universe, then you need to Get A Life. And a
> girlfriend. Maybe even a dog.
>
>> This is SO SO cool!
>
> You misspelled "pathetic". 
>
> This is quite possibly the most ridiculous thing I have ever read on usenet. 
>  And as you can imagine, that's up against some pretty stiff competition.

Apparently Excel gives DFS a "stiffie".

-- 
Be different: conform.

[toc] | [prev] | [next] | [standalone]


#684515

FromRonB <ronb02NOSPAM@gmail.com>
Date2025-01-23 21:12 +0000
Message-ID<vmubcc$1qf2q$2@dont-email.me>
In reply to#684502
On 2025-01-23, Tyrone <none@none.none> wrote:
> On Jan 23, 2025 at 8:46:36 AM EST, "DFS" <guhnoo-basher@linux.advocaca> wrote:
>
>> “This is the Super Bowl for Excel nerds,” Mr. Oehm said. “If Excel is
>> the center of your universe, this is like hanging out with LeBron James
>> and Kobe Bryant.”
>
> If Excel is the center of your universe, then you need to Get A Life. And a
> girlfriend. Maybe even a dog.

Absolutely. Spreadsheets are gawky and often misused where a database would 
make much more sense. 

>> This is SO SO cool!
>
> You misspelled "pathetic". 

:)

> This is quite possibly the most ridiculous thing I have ever read on usenet. 
>  And as you can imagine, that's up against some pretty stiff competition.

-- 
“Evil is not able to create anything new, it can only distort and destroy 
what has been invented or made by the forces of good.”  —J.R.R. Tolkien

[toc] | [prev] | [next] | [standalone]


#684509

Fromrbowman <bowman@montana.com>
Date2025-01-23 18:17 +0000
Message-ID<lvffdaFsbtnU4@mid.individual.net>
In reply to#684500
On Thu, 23 Jan 2025 08:46:36 -0500, DFS wrote:

> The Excel championship featured a live audience of about 400 people.
> Other fans watched an ESPN3 livestream.
> “Basically everything that they do to make it more fun for viewers makes
> it more traumatic for competitors,” Mr. Early said.

Is there a video on the web? On those rare nights when I have trouble 
falling asleep it might help. 

[toc] | [prev] | [next] | [standalone]


#684532

FromDFS <guhnoo-basher@linux.advocaca>
Date2025-01-23 23:07 -0500
Message-ID<vmv3mt$1uev3$1@dont-email.me>
In reply to#684509
On 1/23/2025 1:17 PM, rbowman wrote:
> On Thu, 23 Jan 2025 08:46:36 -0500, DFS wrote:
> 
>> The Excel championship featured a live audience of about 400 people.
>> Other fans watched an ESPN3 livestream.
>> “Basically everything that they do to make it more fun for viewers makes
>> it more traumatic for competitors,” Mr. Early said.
> 
> Is there a video on the web? On those rare nights when I have trouble
> falling asleep it might help.


=Dismiss("Excel naysayers","with prejudice" = True)

[toc] | [prev] | [next] | [standalone]


#684527 — Re: Mightgrowsoft Excel World Championships!

FromLawrence D'Oliveiro <ldo@nz.invalid>
Date2025-01-24 01:00 +0000
SubjectRe: Mightgrowsoft Excel World Championships!
Message-ID<vmuon4$1sjgj$7@dont-email.me>
In reply to#684500
On Thu, 23 Jan 2025 08:46:36 -0500, DFS wrote:

> Twelve Dudes and a Hype Tunnel: Scenes from the ‘Super Bowl for Excel
> Nerds’

Was this written up in The Guardian, perchance?

“Microsoft Excel Champsionships” -- the Special Olympics for data 
analysts.

[toc] | [prev] | [next] | [standalone]


#684535 — Re: Mightgrowsoft Excel World Championships!

FromChris Ahlstrom <OFeem1987@teleworm.us>
Date2025-01-24 07:41 -0500
SubjectRe: Mightgrowsoft Excel World Championships!
Message-ID<vn01pd$27mq5$1@dont-email.me>
In reply to#684527
Lawrence D'Oliveiro wrote this post while blinking in Morse code:

> On Thu, 23 Jan 2025 08:46:36 -0500, DFS wrote:
>
>> Twelve Dudes and a Hype Tunnel: Scenes from the ‘Super Bowl for Excel
>> Nerds’
>
> Was this written up in The Guardian, perchance?
>
> “Microsoft Excel Champsionships” -- the Special Olympics for data 
> analysts.

 :-D

-- 
Stupidity, like virtue, is its own reward.

[toc] | [prev] | [next] | [standalone]


#684551

FromDFS <guhnoo-basher@linux.advocaca>
Date2025-01-24 17:39 -0500
Message-ID<vn14q5$2ed5m$2@dont-email.me>
In reply to#684500
On 1/23/2025 8:46 AM, DFS wrote:

> Twelve Dudes and a Hype Tunnel: Scenes from the ‘Super Bowl for Excel 
> Nerds’

> At the Microsoft Excel World Championship in Las Vegas, there was 
> stardust in the air as 12 finance guys vied to be crowned the world’s 
> best spreadsheeter.


> https://www.nytimes.com/2025/01/20/us/microsoft-excel-world-championships.html
> 
> 
> This is SO SO cool!
> 
> 
> MS Office is doomed by the LeeberOffice juggernaut


My winning Excel (2003) VBA entry.

* open Excel
* choose View | Toolbars | Visual Basic
* click the 'Visual Basic Editor' icon on the VB Toolbar
* arrange the VB IDE on the right of your screen, and sheet on left
* in the VB IDE, click Insert | Module
* add this line in General | Declarations

Public Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)


* in the VB IDE, dbl-click 'This Workbook' on the left
* copy-paste the following code into General | Declarations


Public Sub WorldChamp()
ActiveSheet.Cells.Clear
ActiveSheet.Cells.ColumnWidth = 8.43
ActiveSheet.Cells.RowHeight = 12.75
Dim i, j As Integer
Dim amt As Integer
Dim arr(4) As String
Dim edge As Byte
Dim bgColor As Byte
Dim startRow, startCol As Integer
startRow = ActiveCell.Row
startCol = ActiveCell.Column
edge = 9
For i = 1 To edge
   Rows(ActiveCell.Row).RowHeight = 60
   Columns.ColumnWidth = 15
   ActiveCell.Offset(1, 0).Select
Next i
amt = 50
bgColor = 9
Cells(startRow, startCol).Select
For i = 1 To edge - 1
   ActiveCell.Interior.ColorIndex = bgColor
   Sleep amt
   ActiveCell.Offset(0, 1).Select
Next i
For i = 1 To edge - 1
   ActiveCell.Interior.ColorIndex = bgColor
   Sleep amt
   ActiveCell.Offset(1, 0).Select
Next i
For i = 0 To edge - 2
   ActiveCell.Interior.ColorIndex = bgColor
   Sleep amt
   ActiveCell.Offset(0, -1).Select
Next i
For i = 0 To edge - 2
   ActiveCell.Interior.ColorIndex = bgColor
   Sleep amt
   ActiveCell.Offset(-1, 0).Select
Next i
arr(0) = "ooNhuG wercS"
arr(1) = "FSF eht kcuF"
arr(2) = "namllatS liaJ"
arr(3) = "OL oT oN yaS tsuJ"
Dim rndRow, rndCol As Integer
amt = 25
Cells(startRow + 1, startCol + 1).Select
Randomize
For i = 1 To 100
   rndRow = Int(Rnd * (edge - 2)) + startRow + 1
   rndCol = Int(Rnd * (edge - 2)) + startCol + 1
   Cells(rndRow, rndCol).Select
   cellSettings
   ActiveCell.Value = StrReverse(arr(Int(Rnd * 4)))
   Sleep amt
Next i
Cells(startRow + 1, startCol + 1).Select
For i = 1 To edge - 2
   For j = 1 To edge - 2
    Cells(startRow + j, startCol + i).Select
    If ActiveCell.Value = "" Then
      cellSettings
      ActiveCell.Value = StrReverse("demooD sI lecxE")
    End If
   Next j
Next i
Cells(startRow + 1, startCol + 1).Select
End Sub
Public Sub cellSettings()
    ActiveCell.Interior.ColorIndex = Int(Rnd * 56)
    ActiveCell.Font.ColorIndex = Int(Rnd * 56)
    ActiveCell.VerticalAlignment = xlCenter
    ActiveCell.HorizontalAlignment = xlCenter
    ActiveCell.Font.Bold = True
    ActiveCell.Font.Size = 12
    ActiveCell.WrapText = True
    ActiveCell.Borders.Color = vbWhite
End Sub





Click the Save button to save the new sheet and code

click inside the sheet, in any upper left cell

click the Run button in the VB IDE (or hit F5)

Enjoy the show!

[toc] | [prev] | [standalone]


Back to top | Article view | comp.os.linux.advocacy


csiph-web