Centering Wizard (Excel)

dytch2220

I made this little spreadsheet for calculating centering on a card. To make it simpler for me, I converted the centering into a whole number. 50/50 = 1.00 and 80/20 = 4.00, for example. The only thing that breaks it is 100/0 or worse centering, in which case what is the point? You can measure in any unit you like so long as you're consistent. I used a loupe with mm markings, but you could just as easily use pixels. If you use standard measuring units such as 17/64 for example, that works too so long as you type '=17/64' in the cell. To avoid rendering the spreadsheet unusable, be sure to only enter text in the "Units" column. I typed in the scale based on the grading standards listed on PSA's website. Hopefully someone gets use of this.

Spreadsheet

DetroitSquirreL

JUST A FYI if you want to d/l this file you have to have a gmail account and be logged in I found out

dytch2220

Weird, the share setting I have it on says "Anyone who has the link can access. No sign in required", just verified.

Edit: It works without signing in. Just select "File" from the menu and "Download" or CTRL+S to save to your local PC.

Rosatos_Hotel

This is an amazing tool. Thank you so much for creating and sharing!

Tom_Martucci

Can this be used with using a centering tool?

RufussCkingston

@Tom_Martucci said:
Can this be used with using a centering tool?

You lose the chart

dytch2220

I have received no less than 8,000,000,000 requests for this file to be shared via email. I've been ignoring them because the file was shared to the public. Turns out some security policy changes nerfed it. Reshared, updated hyperlink.

NGS428

Thank for the tool. It is similar to the one I created:
https://docs.google.com/spreadsheets/d/1gvoWEKuCaUZf3KmyniGd3LRWIL3Pq4zw/edit?usp=sharing&ouid=105701788369247605782&rtpof=true&sd=true

This tool is helpful to get the measurements off a PC screen.
http://www.styopkin.com/perfect_screen_ruler.html

Edit 1: That site no longer loads... Hope I have a backup....
Edit 2: It can be found here:
https://download.cnet.com/Perfect-Screen-Ruler/3000-2191_4-10457284.html

DBesse27

Hi Nate, great to see you around!