Home

need help

%3CLINGO-SUB%20id%3D%22lingo-sub-646113%22%20slang%3D%22en-US%22%3Eneed%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-646113%22%20slang%3D%22en-US%22%3E%3CP%3EI%20wanted%20to%20create%20a%20spreadsheet%20that%20had%204-6%20buttons%20tied%20to%20macros.%20If%20button%201%20is%20pushed%20it%20fills%20column%201%20by%20one%20increment%2C%20and%20timestamps%20the%20moment%20it%20is%20hit.%20Buttons%202%20through%206%20would%20do%20the%20same.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBasically%20we%20are%20tracking%20behaviors%20on%20phone%20calls%20via%20recordings%2C%20but%20this%20would%20be%20for%20the%20associate%20to%20in%20a%20way%20monitor%20their%20own%20calls%20real%20time%20and%20have%20a%20visual%20readout.%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F116033i643BD5BBDA55A7D8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Apaint.jpg%22%20title%3D%22Apaint.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20my%20spreadsheet%20in%20a%20perfect%20world%20would%20have%20roughly%205%20buttons%20tied%20to%20macros%2C%20and%20each%20button%20would%20timestamp%20and%20fill%20a%20single%20increment%26nbsp%3B%20of%20a%20column%20to%20show%20a%20real%20time.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHopefully%20I%20am%20painting%20the%20right%20visualization%2C%20but%20it%20is%20basically%20showing%20a%20graph%20that%20grows%20by%20hitting%20a%20single%20button.%20Hit%20button%20a%201%20time%20and%20the%20graph%20shows%20one%20unit.%20hit%20it%20again%20it%20shows%202.%20after%20the%20call%20it%20can%20be%20saved%2Fcleared%20and%20then%20on%20to%20the%20next%20call.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20would%20be%20a%20visual%20representation%20to%20make%20sure%20all%20scored%20behaviors%20are%20covered.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOur%20calls%20are%20evaluated%20by%20a%203rd%20party%20and%20we%20have%20to%20challenge%20many%20of%20them%20so%20this%20would%20help%20us%20make%20sure%20if%20we%20were%20marked%20down%20in%20a%20behavior%2C%20that%20we%20can%20have%20a%20timestamped%20record%20of%20the%20fact%20we%20did%20indeed%20display%20a%20behavior.%20I%20know%20it's%20subjective%20but%20it%20can%20also%20be%20used%20for%20training%20purposes.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20the%20macro%20code%20to%20put%20in%20for%20a%20button%20to%20fill%20a%20graph%20increment%3F%20Is%20this%20beyond%20simple%20or%20beyond%20complex%3F%20Any%20help%20would%20be%20appreciated.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-646113%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EGraph%20tracker%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
noah777
Occasional Visitor

I wanted to create a spreadsheet that had 4-6 buttons tied to macros. If button 1 is pushed it fills column 1 by one increment, and timestamps the moment it is hit. Buttons 2 through 6 would do the same. 

 

Basically we are tracking behaviors on phone calls via recordings, but this would be for the associate to in a way monitor their own calls real time and have a visual readout. Apaint.jpg

 

So my spreadsheet in a perfect world would have roughly 5 buttons tied to macros, and each button would timestamp and fill a single increment  of a column to show a real time. 

 

Hopefully I am painting the right visualization, but it is basically showing a graph that grows by hitting a single button. Hit button a 1 time and the graph shows one unit. hit it again it shows 2. after the call it can be saved/cleared and then on to the next call.

 

It would be a visual representation to make sure all scored behaviors are covered.

 

Our calls are evaluated by a 3rd party and we have to challenge many of them so this would help us make sure if we were marked down in a behavior, that we can have a timestamped record of the fact we did indeed display a behavior. I know it's subjective but it can also be used for training purposes. 

 

Does anyone know the macro code to put in for a button to fill a graph increment? Is this beyond simple or beyond complex? Any help would be appreciated. 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies