More Guild/Info For google spreadsheets

[rickyis911]

I'm back for anther google spreadsheet toon+guild pull

My first one witch is is not working http://www.ownedcore.com/forums/worl...readsheet.html (Inport your guild list into google spreadsheet)

Auto Pull Amory

https://docs.google.com/spreadsheets...it?usp=sharing


Toon template only has HFC https://docs.google.com/spreadsheets...it?usp=sharing
Updates by it's self.

Gear Info

https://docs.google.com/spreadsheets...it?usp=sharing

Guild Output Tool

https://docs.google.com/spreadsheets...it?usp=sharing

Missing Mounts

https://docs.google.com/spreadsheets...it?usp=sharing

PETS

https://docs.google.com/spreadsheets...it?usp=sharing

I will update the spread sheets once evey 2 weeks and they should auto update if not let me know here or via PM and i will update this thread as needed.

Enjoy

[razer86]

  
var toonInfo = new Array( 
    toon.level, toon.items.averageItemLevelEquipped, Math.floor(CM_iL), 
    Math.max(toon.items.finger1.itemLevel, toon.items.finger2.itemLevel), 
    nerzhulkills+zaelakills+gugrokkkills+skullockills+terongorkills+viryxkills+yalnukills+tovrakills, 
    toon.items.head.itemLevel, toon.items.neck.itemLevel, 
    toon.items.shoulder.itemLevel, toon.items.back.itemLevel, 
    toon.items.chest.itemLevel, toon.items.wrist.itemLevel, 
    toon.items.hands.itemLevel, toon.items.waist.itemLevel, 
    toon.items.legs.itemLevel, toon.items.feet.itemLevel, 
    toon.items.finger1.itemLevel, toon.items.finger2.itemLevel, 
    toon.items.trinket1.itemLevel,toon.items.trinket2.itemLevel, 
    toon.items.mainHand.itemLevel, offhand, 
    wepchant, neckchant, cloakchant, r1chant, r2chant, 
    highmaulN, highmaulH, highmaulM,
    brfN, brfH, brfM,
    hfcN, hfcH, hfcM

Your return didn't include the brf kills
Also the headers for hfc are wrong letters

[rickyis911]

is this the working code or my code?

  
var toonInfo = new Array( 
    toon.level, toon.items.averageItemLevelEquipped, Math.floor(CM_iL), 
    Math.max(toon.items.finger1.itemLevel, toon.items.finger2.itemLevel), 
    nerzhulkills+zaelakills+gugrokkkills+skullockills+terongorkills+viryxkills+yalnukills+tovrakills, 
    toon.items.head.itemLevel, toon.items.neck.itemLevel, 
    toon.items.shoulder.itemLevel, toon.items.back.itemLevel, 
    toon.items.chest.itemLevel, toon.items.wrist.itemLevel, 
    toon.items.hands.itemLevel, toon.items.waist.itemLevel, 
    toon.items.legs.itemLevel, toon.items.feet.itemLevel, 
    toon.items.finger1.itemLevel, toon.items.finger2.itemLevel, 
    toon.items.trinket1.itemLevel,toon.items.trinket2.itemLevel, 
    toon.items.mainHand.itemLevel, offhand, 
    wepchant, neckchant, cloakchant, r1chant, r2chant, 
    highmaulN, highmaulH, highmaulM,
    brfN, brfH, brfM,
    hfcN, hfcH, hfcM

Your return didn't include the brf kills
Also the headers for hfc are wrong letters

[razer86]

That's my modified code (working)
The last 2 lines are what is changed

[rickyis911]

Thanks i did not see that there i guess working on a lot of them doesn't help

[rickyis911]

updated a few of the google docs to clean up some code

[Wisterwind]

Thanks works good.

[Cecu]

Could you update your spreadsheets with the new WoW API changes?