[Picklet]

This is a fragment of the Excel sheet. (Spreadsheet aligns poorly in this example.)

Code:

TASK    TYPE    RADIUS    ITEM1    ITEM2    MINLEVEL    MAPID    POS_X    POS_Y    POS_Z    NORMALPRIORITY    USESTEALTH    GATHERMAPS    SKILLPROFILE    ITEMID    COUNT
1    botany    150    Maple Log    Maple Branch    1    154    78.23959351    4.323957443    -196.3209229    true    true    false    Botanist    5380    95
2    botany    150    Maple Branch    Maple Log    1    154    78.23959351    4.323957443    -196.3209229    true    true    true    Botanist    5396    5

This is the MS Word LUA template

Code:

        [«TASK»] = {
            ["type"] = "«TYPE»";
            ["radius"] = «RADIUS»;
            ["item1"] = "«ITEM1»";
            ["item2"] = "«ITEM2»";    
            ["minlevel"] = «MINLEVEL»;
            ["mapid"] = «MAPID»;
            ["pos"] =  {
                ["x"] = «POS_X»;
                ["y"] = «POS_Y»;     
                ["z"] = «POS_Z»;
            };
            ["normalpriority"] = «NORMALPRIORITY»;
            ["usestealth"] = «USESTEALTH»;
            ["gathermaps"] = «GATHERMAPS»;
            ["skillprofile"] = "«SKILLPROFILE»";
            ["condition"] = {
                ["ItemCount(«ITEMID») < «COUNT»"] = true;
            };
            ["complete"] = {
                ["ItemCount(«ITEMID») >= «COUNT»"] = false;
            };
        };

And this is the actual LUA output (minus the opening and ending lines which I'll add to an output form).

Code:

        [1] = {
            ["type"] = "botany";
            ["radius"] = 150;
            ["item1"] = "Maple Log";
            ["item2"] = "Maple Branch";    
            ["minlevel"] = 1;
            ["mapid"] = 154;
            ["pos"] =  {
                ["x"] = 78.23959350586;
                ["y"] = 4.3239574432373002;     
                ["z"] = -196.32092285156;
            };
            ["normalpriority"] = true;
            ["usestealth"] = true;
            ["gathermaps"] = false;
            ["skillprofile"] = "Botanist";
            ["condition"] = {
                ["ItemCount(5380) < 95"] = true;
            };
            ["complete"] = {
                ["ItemCount(5380) >= 95"] = false;
            };
        };
        [2] = {
            ["type"] = "botany";
            ["radius"] = 150;
            ["item1"] = "Maple Branch";
            ["item2"] = "Maple Log";    
            ["minlevel"] = 1;
            ["mapid"] = 154;
            ["pos"] =  {
                ["x"] = 78.23959350586;
                ["y"] = 4.3239574432373002;     
                ["z"] = -196.32092285156;
            };
            ["normalpriority"] = true;
            ["usestealth"] = true;
            ["gathermaps"] = true;
            ["skillprofile"] = "Botanist";
            ["condition"] = {
                ["ItemCount(5396) < 5"] = true;
            };
            ["complete"] = {
                ["ItemCount(5396) >= 5"] = false;
            };
        };

Totally selectable, filterable, and all modifications are done on the spreadsheet, not in the LUA script. Will be a bit of effort to complete the spreadsheet, but considering gatherers on multiple accounts I think it will be well worth the effort. When complete I'll start working on all the unspoiled nodes, which should go much more quickly.