Utilizing Exceed expectations for Test Measurements.

Uploaded on:
Category: Travel / Places
George Jetson. 3. Bill Rate. Pay Rate. 2. D. C. B. Name a Cell Reference. Make ... George Jetson. tech 1. 3. Hours Worked. Name. Position. 2. D. C. B. Subtotal versus Merge ...
Slide 1

Utilizing Excel for Test Metrics

Slide 2

Agenda Application to Metrics Understand the numbers Types of reports Gas gage Progress graph Defect find/fix rate Understanding Excel Basics Text to segments and back Relative and outright values Names CountIf/sumIf Subtotal versus unite Paste exceptional Autofill Formulas – if, then Audit equations Filter Conditional organizing

Slide 3

Understanding Excel

Slide 4

Basics Auto measuring sections and lines Entering recipes Editing equations Cell arranging View or conceal recipes, gridlines, line and segment headers Hyperlinks Worksheet/exercise manual connections Status Bar adding machine Help

Slide 5

Text to Columns - TO - Select the phones that you need to part separated (make sure the segments to the privilege are unfilled as they will be overwritten). Click on Data, Text to Columns. Pick Delimited. Pick Space (or the delimiter that you are utilizing). Click Finish.

Slide 6

Combining Text Fields - TO - Click on a clear cell (for the most part to one side of the current cells). Sort in one of the accompanying equation cases: =A1&" "&B1 to rundown first name, then a space, then the last name =B4&", "&A4 to rundown last name, then a comma, then the primary name The ampersand (&) character permits you to connect content fields together. The quotes will appear as content as in " for a space or ", " for a comma and a space.

Slide 7

Relative and Absolutes $ images in recipes permit you to "bolt" a segment or line. This is an absolute necessity on the off chance that you attempt to duplicate and glue or autofill a recipe. At the point when the cell is chosen in the recipe, press F4 to have it cycle between $C$R, C$R, $CR, CR

Slide 8

Name a Cell Reference Make your equations more "discernable" by naming cells 1. Click on a cell 2. In the Formula bar where it demonstrates the Column/Row reference, sort in name and press enter. 3. Reference that name in an equation. To see the rundown of names, snap on Insert, Name, Define

Slide 9

CountIf/SumIf CountIf: =countif(range,criteria) SumIf: =sumif(range,criteria,[sum_range]) Range = the scope of cells you need assessed/included Criteria = the criteria the type of a number, expression, or content that characterizes which cells will be included. For instance, criteria can be communicated as 32, "32", ">32", "apples". Sum_range = the real cells to whole.

Slide 10

Subtotal versus Unite Subtotal Dynamic (if connected to source information, when source information upgrades, subtotals redesign) Ideal for a set number of lines (if referencing this information in another sheet) Adjusts existing information Consolidate Static (no change when source information is overhauled) Ideal for a shifting arrangement of lines (if referencing this information in another sheet) Results are put away in an alternate area

Slide 11

Subtotal Select a cell in the extent Click Tools, Subtotal Choose the reference section Choose the capacity (aggregate, normal, and so forth.) Choose the column(s) to subtotals

Slide 12

Consolidate Select a clear cell (for the most part another sheet or beneath the current information) Click Tools, Consolidate Choose the capacity (total, normal, and so on.) Choose the range(s) to solidify; click on Add after every one Choose Left Column Note: on the off chance that you check "make connections to source information," it will do a subtotal

Slide 13

Paste Special Accessible from the right snap menu after a duplicate Some choices accessible from the from the symbol after a glue

Slide 14

Paste Special Formulas – glues recipes just, no designing Values – glues the aftereffects of the equation (can likewise utilize F9) Formats – glues the configuration (no information); can likewise utilize the organization painter Skip spaces – glues the estimations of cells containing information, skips clear cells Transpose – transposes the information – changes over lines to segments or segments to lines

Slide 15

AutoFill Type in the initial two things in an arrangement; autofill the rest by dragging the cells Make your own particular autofill records under Tools, Options, Custom Lists Use the CTRL to modify the autofill Downfall: the rundown is static

Slide 16

Alternatives to AutoFill Formulas, obviously 

Slide 17

Formulas – if/then Use restrictive articulations in recipes Error taking care of (dodge div/0 blunders) Create "brilliant" recipes that can conform on the fly

Slide 18

Formula Audit Select the recipe you need to review Click on Tools, Formula Auditing, Evaluate Formula

Slide 19

Filter Select a cell in the information range Click on Data, Filter, Auto Filter

Slide 20

Conditional Formatting Based on the estimation of a cell/cells, modify the arranging on the fly Click the cell/cells, click on Format, Conditional Formatting Note: experimentation is important in here; acknowledges outright and relative qualities, acknowledges a few recipes

Slide 21

Application to Metrics

Slide 22

Understanding Numbers "Get your actualities in the first place, then mutilate them as you please." ~ Mark Twain "Facts are hardheaded, however measurements are more pliable." ~ Mark Twain Torture numbers, and they\'ll admit to anything.  ~Gregg Easterbrook 98% of all insights are made up.  ~Author Unknown

Slide 23

What does this mean? Decision of recipes has any kind of effect Using midpoints versus sums taking into account number of tests will demonstrate diverse results One perspective of numbers is never enough %pass, %fail numbers don\'t mean much in the event that you don\'t know sort of imperfections are logged Numbers alone are never enough Tests can\'t cover everything Gut feel ought to in any case mean something – in some cases numbers are difficult to get a handle on

Slide 24

Types of Metrics Gas Gage – review of pass, fall flat, blocked reports Progress Report – verifiable perspective of pass, fizzle, and blocked reports Defect Find/Fix Report – how quick are we discovering absconds versus how quick are they being altered Release Criteria – what are the criteria to discharge the venture Pass rate for all segments must be 97% or higher Submit rate of high need surrenders must be not exactly x% of the normal deformities signed in the last x weeks. Stress test GUI mistakes per 1,000 hours must be under .02

Slide 25

Gas Gage

Slide 26

How to fabricate the gas gage Gather the crude information Organize it by test zone/classification/test sort Create the accompanying for every line: % complete of arranged % go of planned - - % go of complete % come up short of planned - - % fall flat of complete % piece of planned - - % square of complete Determine whether to utilize % of arranged or % of complete (may utilize both relying upon the report) Determine whether aggregates ought to be midpoints or in view of the real number of tests Develop the gas gage

Slide 27

Progress Chart – Ideal world

Slide 28

Progress Chart – genuine

Slide 29

How to manufacture the advancement outline Determine the aggregate number of tests workable for every region Determine turning points for 100% execution, 60% pass, 80% pass, 90% pass Weekly, track the quantity of passes, fizzles, and squares

Slide 30

Find/Fix Rate – Ideal World

Slide 31

Find/Fix Rate – Real World

Slide 32

Find/Fix Rates Track for all imperfections Track for simply high need (must fixes for an item to ship) Track number of deformities submitted and determined every week Chart the outcomes

View more...