Actuarial Outpost
 
Go Back   Actuarial Outpost > Actuarial Discussion Forum > Professional Surveys
FlashChat Actuarial Discussion Preliminary Exams CAS/SOA Exams Cyberchat Around the World Suggestions



View Poll Results: What Is The Appropriate Response To Someone Who Center Aligns Columns of Numbers?
Center-aligning numbers is beautiful. The person responsible should be promoted immediately. 10 22.73%
Meh! I don't care one way or the other. 6 13.64%
Not crazy about it but it's not a big deal. 13 29.55%
The person responsible should be publicly flogged after the first offence and boiled in oil and sulfur after the second. 15 34.09%
42 ways of aligning are OK with me. 0 0%
Voters: 44. You may not vote on this poll

Reply
 
Thread Tools Search this Thread Display Modes
  #11  
Old 04-29-2020, 04:44 PM
Maphisto's Sidekick's Avatar
Maphisto's Sidekick Maphisto's Sidekick is offline
Member
CAS
 
Join Date: Nov 2001
Location: South Park Genetics Lab
College: Ardnox
Favorite beer: The kind with alcohol
Posts: 3,511
Default

I agree with the idea that in certain cases (percentages, labels, "just a few numbers" in a presentation deck, etc.), it is OK, or even desirable to center-align numbers.

However for tabular numbers, my strong preferences are:
  • I want the decimal separators (points, commas, or invisible notional spot to the right of the units digit) aligned with one another
  • If there must be a currency symbol before each figure, I want the currency symbols aligned.

...which translates to something close to, but not quite, right-aligned.

Last edited by Maphisto's Sidekick; 04-29-2020 at 04:48 PM..
Reply With Quote
  #12  
Old 05-03-2020, 12:37 PM
Colonel Smoothie's Avatar
Colonel Smoothie Colonel Smoothie is online now
Member
CAS
 
Join Date: Sep 2010
College: Jamba Juice University
Favorite beer: AO Amber Ale
Posts: 50,693
Default

The numbers on AO forum tables are center aligned
__________________
Recommended Readings for the EL Actuary || Recommended Readings for the EB Actuary

Quote:
Originally Posted by Wigmeister General View Post
Don't you even think about sending me your resume. I'll turn it into an origami boulder and return it to you.
Reply With Quote
  #13  
Old 05-03-2020, 03:01 PM
Vorian Atreides's Avatar
Vorian Atreides Vorian Atreides is online now
Wiki/Note Contributor
CAS
 
Join Date: Apr 2005
Location: As far as 3 cups of sugar will take you
Studying for CSPA
College: Hard Knocks
Favorite beer: Most German dark lagers
Posts: 68,554
Default

Worst formatting to try and read:

Header left aligned

Values right aligned



I would also consider whether the "presentation" is a final one or an "update" (i.e., it's not the "final draft").

If it's a "quick hitter" report, then center aligning (both header and values) is quick and easy.

But if it's something that is going to be sent on up the chain . . . then yeah, spend some time to make it look readable at a glance.
__________________
I find your lack of faith disturbing

Why should I worry about dying? It’s not going to happen in my lifetime!


Freedom of speech is not a license to discourtesy

#BLACKMATTERLIVES
Reply With Quote
  #14  
Old 05-03-2020, 03:20 PM
Lucy's Avatar
Lucy Lucy is offline
Member
CAS
 
Join Date: Sep 2001
Posts: 7,813
Default

Quote:
Originally Posted by Vorian Atreides View Post
Worst formatting to try and read:

Header left aligned

Values right aligned



I would also consider whether the "presentation" is a final one or an "update" (i.e., it's not the "final draft").

If it's a "quick hitter" report, then center aligning (both header and values) is quick and easy.

But if it's something that is going to be sent on up the chain . . . then yeah, spend some time to make it look readable at a glance.
Oh yeah, I HATE that. And i admit I sometimes just center-align it all so I can read it. But usually I right-align everything instead. It kind of depends on whether the titles or the numbers are more visually important.
Reply With Quote
  #15  
Old 05-05-2020, 02:55 PM
Gonzo's Avatar
Gonzo Gonzo is offline
Member
SOA
 
Join Date: Jun 2009
Location: gonzo.
Studying for gonzo?
Favorite beer: gonzo!
Posts: 8,944
Default

what about dates? center?

what format is best? 05/05/2020 or 5-May?
Reply With Quote
  #16  
Old 05-05-2020, 03:20 PM
Maphisto's Sidekick's Avatar
Maphisto's Sidekick Maphisto's Sidekick is offline
Member
CAS
 
Join Date: Nov 2001
Location: South Park Genetics Lab
College: Ardnox
Favorite beer: The kind with alcohol
Posts: 3,511
Default

Quote:
Originally Posted by Gonzo View Post
what about dates? center?

what format is best? 05/05/2020 or 5-May?
Alignment would depend on usage.

Regarding date format: yyyy-mm-dd FTW (although different/no separators are OK, if consistent).
Reply With Quote
  #17  
Old 05-05-2020, 04:30 PM
Dr T Non-Fan Dr T Non-Fan is offline
Member
SOA AAA
 
Join Date: Sep 2001
Location: Just outside of Nowhere
Posts: 100,500
Default

Quote:
Originally Posted by Gonzo View Post
what about dates? center?

what format is best? 05/05/2020 or 5-May?
Big issue with the bold.
What year?
Is the year implied somehow?
Placed in header?

Also, for showing or for using? if using, it makes no difference.
__________________
"Facebook is a toilet." -- LWTwJO

"45 es un titere" -- Seal of The President of The United States of America protest art

“That is reminiscent of Harry Truman’s famous saying, ‘The buck stops, uh, somewhere over there, maybe?' That is a level of dodging responsibility that Trump has been perfecting ever since he was very much not in Vietnam.” -- LWTwJO
Reply With Quote
  #18  
Old 05-07-2020, 03:32 PM
Gonzo's Avatar
Gonzo Gonzo is offline
Member
SOA
 
Join Date: Jun 2009
Location: gonzo.
Studying for gonzo?
Favorite beer: gonzo!
Posts: 8,944
Default

Quote:
Originally Posted by Dr T Non-Fan View Post
Big issue with the bold.
What year?
Is the year implied somehow?
Placed in header?

Also, for showing or for using? if using, it makes no difference.
yeah that's my least favorite. lot of peeps in my company like to use that. i'm guessing it's a military thing.
Reply With Quote
  #19  
Old 05-07-2020, 04:19 PM
Vorian Atreides's Avatar
Vorian Atreides Vorian Atreides is online now
Wiki/Note Contributor
CAS
 
Join Date: Apr 2005
Location: As far as 3 cups of sugar will take you
Studying for CSPA
College: Hard Knocks
Favorite beer: Most German dark lagers
Posts: 68,554
Default

I like 5 Mar 20 over 5-3-20 as it's clear which position is the month.

And this format is used in the military in that you don't have to encode separators for the components of the date (5MAR20). Granted that this isn't as important in business communications (apart from having the components of a date clear, so I'd prefer Mar 5, 2020 over 3/5/20); but in military communications, when it's possible to be coordinating with another group with different structures (Europe tends to use d/m/yyyy with Americans tending to use m/d/yyyy), it pays off to just have a consistent format that is clear w/o the need to clarify the format.
__________________
I find your lack of faith disturbing

Why should I worry about dying? It’s not going to happen in my lifetime!


Freedom of speech is not a license to discourtesy

#BLACKMATTERLIVES
Reply With Quote
  #20  
Old 05-29-2020, 06:51 PM
Colonel Smoothie's Avatar
Colonel Smoothie Colonel Smoothie is online now
Member
CAS
 
Join Date: Sep 2010
College: Jamba Juice University
Favorite beer: AO Amber Ale
Posts: 50,693
Default

Quote:
Originally Posted by Vorian Atreides View Post
I like 5 Mar 20 over 5-3-20 as it's clear which position is the month.

And this format is used in the military in that you don't have to encode separators for the components of the date (5MAR20). Granted that this isn't as important in business communications (apart from having the components of a date clear, so I'd prefer Mar 5, 2020 over 3/5/20); but in military communications, when it's possible to be coordinating with another group with different structures (Europe tends to use d/m/yyyy with Americans tending to use m/d/yyyy), it pays off to just have a consistent format that is clear w/o the need to clarify the format.
Unix timestamp imo.

5 Mar 20 12:0:0 AM GMT = 1588464000
__________________
Recommended Readings for the EL Actuary || Recommended Readings for the EB Actuary

Quote:
Originally Posted by Wigmeister General View Post
Don't you even think about sending me your resume. I'll turn it into an origami boulder and return it to you.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


All times are GMT -4. The time now is 09:10 AM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
*PLEASE NOTE: Posts are not checked for accuracy, and do not
represent the views of the Actuarial Outpost or its sponsors.
Page generated in 0.27549 seconds with 10 queries