Quote (Marieusz @ 16 Jul 2018 20:40)

Normal and Exceptional Wands have a magic level of 1, so you use the following formula:

IF(magiclvl > 0)

THEN alvl = MAX(ilvl,qlvl) + magiclvl

ELSE IF(MAX(ilvl;qlvl)<(99-INT(qlvl/2))

THEN alvl = (MAX(ilvl;qlvl)-INT(qlvl/2))

ELSE alvl = (2*MAX(ilvl;qlvl)-99))

'of Lower Resistance' is affix level 35, therefore: max{qlvl,ilvl} >= 35 is needed

The ilvl of shopped items is clvl +5, but be aware that normal Act 3 spawns ilvl 28 maximum, so you need to go to Act 4 (ilvl 36) or beyond.

__Level per ilvl__

Level 1: ilvl 35 - 75

Level 2: ilvl 76 - 98

Level 3: ilvl 99

thank you very much for this clear explanation