Talk:Experience Levels/@comment-26224165-20150424205306

I should have used different wording instead of saying that many values needed to be fixed. My original assumption was that the values were copied/imported from Excel, where a formula was used to calculate the  Point to Next Level (PNL) values. using the Experience Points (EP)s values (or vice versa). The self-correcting of the EPs in item 1) was confusing. When I came across item 2), I figured it was caused by a Custom Format accidently applied to the Excel cell. I'll admit, I didn't consider that the values might have been manually entered (or maybe my brain blocked this thought because the thought of someone manually entering the values was too painful).

However...since you did have to type the values, I pulled a fresh copy of the table w/your edits, created 2 new columns for calculated values of EPs and PNLs (based on your +300 increment in PTNs from L8 onward), applied Conditional Formatting (bold + red font) to flag any differences between table values and calculated values, then applied AutoFilter to only display table rows containing cells with a red font color.

No issues were found with the PNL values and 12 possible issues were found in the EP values. I am handing off the results to you to review/verify and update the table. Since I don't have a way to send you the info directly, I am attaching a screenshot. The table column header names are abbreviated to compact the values (the 2 that begin with "C_" are the calculated values).