> Help! Audio only works while I'm moving my mouse!
This is my all-time favorite technology problem. What's yours?
__________
|photo|info|
|_____|____|
[ shadow ]
After debugging the CSS and inspecting every element, I couldn't figure it out. I ended up taking a screenshot, zooming in to the pixels in GIMP, and using the color picker to see just how different they were, but it turned out the shadow was the same color! It was the same principle behind the checker shadow optical illusion (https://en.wikipedia.org/wiki/Optical_illusion#/media/File:C...), where the darker side (the photograph) made the shadow look lighter than the shadow below the lighter side.Definitely made for an interesting writeup as I closed the issue.
The user would upload a spreadsheet file that contains hundreds of equations for different "KPIs", and the solver would go through them, look for the variables in database tables and columns, and then solve the system.
Example:
kpi1 = sales.clients + marketing.last_year_accounts – kpi2*legal.billable_hours
sales, marketing, legal being database tables, and clients, last_year_accounts, billable_hours being column names. kpi2 is another KPI defined somewhere solved iteratively.I squinted my eyes hard looking at one equation that used to be solved that raised an exception. As a matter of fact, I don't know if you have spotted it in the equation above.
The problem is the dash[0] instead of the - (minus). It would be "minus", then somehow Excel would transform it to an en dash if I recall correctly. Since I used abstract syntax trees and parsed the equations, it threw the solver off.
I remember at some point, I just noticed a difference in length compared to the - sign.