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

Search Actuarial Jobs by State @ DWSimpson.com:
AL AK AR AZ CA CO CT DE FL GA HI ID IL IN IA KS KY LA
ME MD MA MI MN MS MO MT NE NH NJ NM NY NV NC ND
OH OK OR PA RI SC SD TN TX UT VT VA WA WV WI WY

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
  #1  
Old 04-28-2020, 11:05 PM
Hedges Hedges is offline
Member
SOA
 
Join Date: Apr 2002
Location: I've been Shanghaied!
Posts: 539
Default Center Aligning Numbers in Columns

I frequently receive documents or spreadsheets with tables of numbers e.g. a table of Sales Volume by Month and Region where each row represents a month and each column a region. Often people will often center-align the numbers which ... upsets me slightly. What is the best response to this practice?

Last edited by Hedges; 04-28-2020 at 11:09 PM..
Reply With Quote
  #2  
Old 04-28-2020, 11:39 PM
Lucy's Avatar
Lucy Lucy is offline
Member
CAS
 
Join Date: Sep 2001
Posts: 8,567
Default

My real answer is that it depends a little on the numbers. If they all have the same number of digits, center-aligning sometimes looks good with no particular downside. But if someone will scan the column and have to compare $26 with $1984, it will be a lot easier if they are right-aligned.

Just please don't left-align numbers. Ugh.
Reply With Quote
  #3  
Old 04-29-2020, 12:22 AM
Dr T Non-Fan Dr T Non-Fan is offline
Member
SOA AAA
 
Join Date: Sep 2001
Location: Just outside of Nowhere
Posts: 100,984
Default

Don't be upset.

Just fix your copy the the way you want them to be.
__________________
"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
  #4  
Old 04-29-2020, 01:25 AM
Hedges Hedges is offline
Member
SOA
 
Join Date: Apr 2002
Location: I've been Shanghaied!
Posts: 539
Default

I agree that if all numbers have the same number of digits (and places after the decimal point!) then center aligning can often look better - no problem with that. As for left-aligned - yes I've got that too. Or numbers which are right aligned but haven't been formatted to the same number of decimal places. Or numbers that round off to, say 3 decimals, so that the mortality rate appears to be ...zero.

Last edited by Hedges; 04-29-2020 at 04:03 AM..
Reply With Quote
  #5  
Old 04-29-2020, 08:48 AM
DataDan's Avatar
DataDan DataDan is offline
Member
SOA
 
Join Date: Feb 2012
Location: East Coast US
Posts: 4,241
Default

align however you want, just dont 'merge and center'.
Reply With Quote
  #6  
Old 04-29-2020, 08:52 AM
Patience's Avatar
Patience Patience is offline
Member
SOA AAA
 
Join Date: Sep 2001
Location: a kinder, gentler place
Favorite beer: Scotch
Posts: 51,200
Default

If additive numbers, prefer right alignment

However, for percentages, or counting numbers, I will center if the sheet needs to be printed and space is tight. Centering can offer better visual spacing from neighboring columns
__________________
"I've been through the desert on a horse with no name...
In the desert you can remember your name
'Cause there ain't no one for to give you no pain"
Reply With Quote
  #7  
Old 04-29-2020, 10:45 AM
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,870
Default

Quote:
Originally Posted by Hedges View Post
I frequently receive documents or spreadsheets with tables of numbers e.g. a table of Sales Volume by Month and Region where each row represents a month and each column a region. Often people will often center-align the numbers which ... upsets me slightly. What is the best response to this practice?
sql plz
__________________
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
  #8  
Old 04-29-2020, 01: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,984
Default

Quote:
Originally Posted by DataDan View Post
align however you want, just dont 'merge and center'.
ooooh, you better believe that's a paddlin'.
__________________
"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
  #9  
Old 04-29-2020, 01:35 PM
tommie frazier tommie frazier is offline
Member
 
Join Date: Aug 2003
Favorite beer: The kind with 2 e's
Posts: 23,859
Default

Quote:
Originally Posted by Dr T Non-Fan View Post
ooooh, you better believe that's a paddlin'.
+1
Reply With Quote
  #10  
Old 04-29-2020, 04:02 PM
whisper's Avatar
whisper whisper is online now
Member
CAS AAA
 
Join Date: Jan 2002
Location: Chicago
Favorite beer: Hefewizen
Posts: 39,623
Default

Quote:
Originally Posted by Lucy View Post
My real answer is that it depends a little on the numbers. If they all have the same number of digits, center-aligning sometimes looks good with no particular downside. But if someone will scan the column and have to compare $26 with $1984, it will be a lot easier if they are right-aligned.

Just please don't left-align numbers. Ugh.
Also, it depends what the numbers represent on the table. If they're labels - centering may distinguish that they're labels and not results.
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 01:20 PM.


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.23298 seconds with 12 queries