Good morning, afternoon and evening everyone! I’m creating a ranking system and need some opinions! Do you believe a ranking system should start with a 0 or 1 for the lowest?

like
Posting as :
works at
You are currently posting as works at

It depends on what you are ranking and who the audience is.

If you're dealing with developers, 0 based ranking is largely popular.

However, 0 means nothing. So if you are ranking maturity efforts, 0 would mean "nothing". So, for a company that's doing "nothing" in an area, they'd get a zero.

However, if we are talking "how much do you like the product", I like a 1 based system. Because 0 means nothing and is ambiguous in this context. I like it 1 means it's my least level of liking, or I like it 5, my most level of liking.

So, if for what you are ranking "nothing" is an option, then I'd do a zero based list. If "nothing" is not a valid option, I'd do a one based list.

like

Ah that makes sense, if you see my reply to Walmart above that’ll give some context. So for my example it would probably be better to limit the lowest ranking to a 1 rather than 0.

I have your solution. Scale from 0-1 using decimals.

Post Photo
like

Hospitality Group

Post Photo

I don’t really have an opinion, but I a fan of 0-base systems in other contexts so I’ll say 0. Out of curiosity, what are you ranking and what will the ranking be used for?

Honestly, the comment below saying to use percentages is 100% correct (pun intended). If you’re already estimating the probability of exit, use it! Don’t hide that useful information behind a score that can be misinterpreted.

like

1 for best 💯

Related Posts

26, Chicago, $39k

like

Conference call horror stories, go!

likefunny

Waited a week for them to get a fresh piece in. So happy with this piece

Post Photo
like

Can anyone please help me with inhand salary calculation after tax deduction, considering no investment at all ....

Post Photo
like

Any CLT,NC businesses looking to hire for a Junior level Full stack developer / Junior Front-End Developer/ Technology Associate /Systems Engineer entry level / IT Support Engineer??

like
like

Hi, How's EPAM Systems in terms of wlb and work. Thave received an offer from them and would like to know if someone is working in EPAM. Yoe:7 Tech: Java, Springboot, React, Microservices Offer: 23fixed+1 joining bonus cctc: 13 EPAM Systems

like

Can someone refer me at suitable position in citi

Skill set - Big Data QA, sql, python, Unix

YOE - 10.5

like

Hello all,

Does citi provide guest house for few days if we are going to work location from base loacation for 2 days.

Plase give ur thoughts on this.

like

Hi Fishes,

I have received an email from HR that you have been selected at citi and asking to send few documents like id, salary slip,few other forms that need to filled and scanned. It does not have compensation offered in any of the attached document. Can you help when they will release compensation offered part? What will be the further process? Will they call me and discuss? How does it go in citi?

like

Some clients are really nervous about getting scammed by a realtor. How can I ensure them that this is not the case?

like

What is the best way to reach out to your in house agency ? I want to share our call for artists . Do I have go through HR? Or is there a place I can simply post an announcement ?

like
like

Yesterday i got resignation acceptance mail from hr with lwd mentioned.

My TL called me that need to go office else they will extend your notice period.

Will that possible or else he is scaring me?

likefunny

Does anyone have a helpful recommenders guide I could give to my recommenders?

like

Is there anybody working as BA in BFSI? I wish to connect.

like

Hey Fishes,

Any update on the hike letter ?

like

Honest question but are you able to tie your work directly back to making a difference with sustainability? Or do you feel like a lot of these roles are just optics? Asking as someone who really cares about the subject

like

Is there anyone who can discuss the current development trend of the world economy? I am very willing to learn and share what I know.

like

Hello Fishers,

After how many days EY GDS releases the offer letter.. I have submitted the candidature form and had HR discussion..

Does that means I am selected?

Thanks.

like

Additional Posts in Excel Genius

Would anyone be willing to teach me vlookup?

like

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

How can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

Post Photo
like

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

Best websites to get more of a handle on Excel as a beginner-intermediate?

like

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

Any book recommendations on excel modeling for real world business applications?

like

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

like

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

What are your top Excel ninja tricks? Ones that few people know...

like

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

like

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

like

I’m helping my GF with excel and need help lol. She works at a hospital and is trying to make an excel schedule for doctors to reserve rooms. She wants drop downs for days of the week (column K) and also different drop down menus in column P for the reserved time slots.

Is it possible to do this with two sets of drop downs (days of week + time slots) and not use index match here? She could make 5 tables for each day of the week, but prefers one table that can be easily navigated by doctors.

Post Photo
like

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

Our Data is only showing when something has changed, is there any way to make excel fill in the values?

Post Photo
like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal