Tag Archive | validation
Excel shenanigans
I have been involved with a great stack of data over the last few months; building a massive formula that so far covers all the possible falsey input I can think of!
I’ve edited all cell references so it’s obvious where they lie; and not what they refer to. Personally I find cognitive search-and-replace really frustrating, and Excel has never made debugging input to its formula bar easy (I can only imagine the frustration a command-line PHP dev’ must have!)…
The magic started life as:
=IF(OR(I6="",K6=""),"?",NETWORKDAYS(I6,K6,))
Designed around NETWORKDAYS to figure out the amount of time between two user-defined dates; it makes a nominal effort to filter out bad data. Read More…
Conditional Comments – Spawn or Saviour?
Having found out IE10 will No Longer Support Conditional Comments, I wondered if version 1.3 of the W3’s Markup Validator supported them yet. Turns out it’s a no (surprise surprise)…
However: looking more closely at MSDN’s article on downlevel hidden / revealed comments (yes: buzzwords alert!) I notice that the Validator only complains about proper downlevel comments… Read More…