Advertisement
Guest User

Untitled

a guest
Jun 20th, 2019
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.44 KB | None | 0 0
  1. +-------+-------+---------+
  2. | Style | Range | Int |
  3. +-------+-------+---------+
  4. | A | 0-1 | . |
  5. | A | 1-5 | . |
  6. | A | 5-11 | . |
  7. | A | 11-12 | . |
  8. | A | 12-24 | -999999 |
  9. | A | 24-36 | 0 |
  10. | A | 36-48 | 0 |
  11. | A | 48-60 | -999999 |
  12. | A | 60+ | 0 |
  13. +-------+-------+---------+
  14.  
  15. if(int = -999999) and range ='12-24'
  16. then get the first non null value in int from
  17. 11-12, 5-11, 1-5, 0-1 24-36, 36-48, 48-60, 60+ in that order
  18.  
  19. if(int = -999999) and range ='0-1' or '1-5' or '5-11' or '11-12'
  20. then get the first non null value in int from
  21. 12-24, 11-12, 5-11, 1-5, 0-1 24-36, 36-48, 48-60, 60+ in that order without looking up self
  22.  
  23. if(int = -999999) and range ='24-36'
  24. then get the first non null value in int from
  25. 36-48, 48-60, 60+, 12-24, 11-12, 5-11, 1-5, 0-1 in that order
  26.  
  27. if(int = -999999) and range ='36-48' or '48-60' or '60+'
  28. then get the first non null value in int from
  29. 24-36, 36-48, 48-60, 60+, 12-24, 11-12, 5-11, 1-5, 0-1 in that order without looking up self
  30.  
  31. +-------+-------+---------+
  32. | Style | Range | Int |
  33. +-------+-------+---------+
  34. | A | 0-1 | . |
  35. | A | 1-5 | . |
  36. | A | 5-11 | . |
  37. | A | 11-12 | . |
  38. | A | 12-24 | 0 |
  39. | A | 24-36 | 0 |
  40. | A | 36-48 | 0 |
  41. | A | 48-60 | 0 |
  42. | A | 60+ | 0 |
  43. +-------+-------+---------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement