tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 77707d1278140589-collate-and-index-info-example1
Sheet: Main

Entry | Unit 1 Criteria 1 | Unit 1 Criteria 2 | Unit 1 Criteria 3 | Unit 1 Criteria 4 | Unit 1 Criteria 5 | Unit 1 Criteria Collated | Unit 2 Criteria 1 | Unit 2 Criteria 2 | Unit 2 Criteria 3 | Unit 2 Criteria 4 | Unit 2 Criteria 5 | Unit 2 Criteria Collated
Entry 1 | Y |  | Y |  | Y | 1, 3, 5 |  | Y | Y | Y |  | 2, 3, 4
Entry 2 |  |  |  |  |  |  | Y | Y |  |  |  | 1, 2
Entry 3 |  |  |  | Y | Y | 4, 5 |  |  |  |  | Y | 5
Spreadsheet: 804824d1668380436-match-formula-for-last-column-schedule
Sheet: Schedule

Date
(S) Lead
(OP) Opening
(B) Bread
(C) Drink
(O) Offer
(A) Assist
(CP) Closing
Spreadsheet: 856526d1705738815-how-to-solve-the-problem-of-finding-the-last-0-numbers-in-a-formula-excel
Sheet: Sheet1

 | B1 | B2 | B3 | B4 | B5 | B6 | B7 | B8 | B9 |  | RESULT
A1 | 2 | 2 | 2 | 0 | 0 | 1 | 0 | 0 | 0 |  | 3
A2 | 0 | 4 | 2 | 2 | 0 | 0 | 0 | 0 | 2 |  | 0 | 0
A3 | 2 | 3 | 1 | 0 | 0 | 0 | 0 | 1 | 0 |  | 1 | 1
A4 | 0 | 4 | 0 | 0 | 1 | 1 | 0 | 0 | 0 |  | 3 | 3
A5 | 0 | 4 | 2 | 0 | 0 | 0 | 0 | 1 | 0 |  | 1 | 1
A6 | 0 | 0 | 0 | 0 | 7 | 0 | 5 | 0 | 0 |  | 2 | 2
A7 | 9 | 5 | 0 | 10 | 2 | 2 | 0 | 0 | 0 |  | 3 | 3
A8 | 0 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 |  | 4 | 4
A9 | 2 | 0 | 0 | 3 | 4 | 0 | 0 | 0 | 0 |  | 4 | 4
A10 | 2 | 0 | 3 | 2 | 2 | 0 | 0 | 0 | 0 |  | 4 | 4
A11 | 0 | 5 | 2 | 0 | 12 | 0 | 0 | 0 | 0 |  | 4 | 4
A12 | 2 | 4 | 7 | 2 | 2 | 0 | 0 | 0 | 0 |  | 4 | 4
A13 | 2 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 |  | 5 | 5
Spreadsheet: 61811d1262728592-nested-ifs-sched-with-omm
Sheet: Sunday

 | One Minute Meeting
 | Date:
 | Yest.Goal | Yest Act. |  | $ +/- | TODAY'S GOAL | ASH | ADT Goal | UPT Goal
 | $ | $ |  | $ | 779 | 48.69 | $
 | WTD Goal | WTD Act. |  | $ +/- |  |  | ADT WTD | UPT WTD
 | $ | $ |  | $ |  |  | $
 | MTD [NAME] | MTD Act. |  | $ +/- |  |  | ADT MTD | UPT MTD
 | $ | $ |  | $ |  |  | $
 | Merchandise Message
 | Today's Schedule
 | Employees Scheduled |  |  | 3
 | Name/Initals | Shift Start | Shift End | Sales Goal | Sales Actual | % to Goal | ADT | UPT | SOCKS |  | I would like to populate each day from the schedule
1 | [NAME] | 10:30:00 | 17:30:00 | 292.21 | $ | % | $
2 | Natasha | 11:00:00 | 17:30:00 | 292.21 | $ | % | $
3 | [NAME] | 12:00:00 | 16:00:00 | 194.75 | $ | % | $
4 |  |  |  | $ | $ | % | $
5 |  |  |  | $ | $ | % | $
6 |  |  |  | $ | $ | % | $
7 |  |  |  | $ | $ | % | $
8 |  |  |  | $ | $ | % | $
9 |  |  |  | $ | $ | % | $
10 |  |  |  | $ | $ | % | $
 | [NAME]
 | Hour | % By Hour |  | Target Sales | Actual Sales | UPT | ADT | ASH
 | 11:00:00 | 0.1 |  | 77.9 | $ |  | $ | $
 | 12:00:00 | 0.2 |  | 155.8 | $ |  | $ | $
 | 13:00:00 | 0.3 |  | 233.7 | $ |  | $ | $
 | 14:00:00 | 0.4 |  | 311.6 | $ |  | $ | $
 | 15:00:00 | 0.5 |  | 389.5 | $ |  | $ | $
 | 16:00:00 | 0.6 |  | 467.4 | $ |  | $ | $
 | 17:00:00 | 0.7 |  | 545.3 | $ |  | $ | $
 | 18:00:00 | 0.8 |  | 623.2 | $ |  | $ | $
 | 19:00:00 | 0.9 |  | 701.1 | $ |  | $ | $
 | 20:00:00 | 1 |  | 779 | $ |  | $ | $
Spreadsheet: 775844d1649347663-calculation-in-sum_range-of-sumif-daf-product-aligw
Sheet: Sheet1

id | p |  | id | p1 | p2
a | 0.2 |  | a
a | 0.8 |  | b
b | 0.3
b | 0.6 |  | I'd like p2 to be calculated by something like
 |  |  | =1-PRODIF(Table1[id];[@id];1-Table1[p])
Spreadsheet: 855057d1704781403-course-enrollment-averages-calculations-to-active-terms-course-enrollment-averages-calculations-to-active-terms
Sheet: Sheet1

Course | Term | Mode | ToT Enrl |  |  |  | Face to Face |  |  |  |  |  |  | Sum of ToT Enrl | Column Labels
HST 3111 | 20231 | Online | 87 |  |  |  | 63 |  |  |  |  |  |  | Row Labels | 20215 | 20231 | 20238 | 20241 | 20245 | Grand Total
HST 3111 | 20231 | Online | 32 |  | HST 2122 | 65.5 | 70.5 |  |  |  |  |  |  | HST 2122 | 56 |  | 139 | 77 |  | 272
HST 3111 | 20241 | Online | 11 |  |  |  |  |  |  |  |  |  |  | Face to Face | 56 |  | 85 |  |  | 141
HST 3111 | 20245 | Face to Face | 74 |  |  |  |  |  |  |  |  |  |  | Online |  |  | 54 | 77 |  | 131
HST 3111 | 20215 | Face to Face | 52 |  |  |  |  |  |  |  |  |  |  | HST 3111 | 52 | 119 |  | 11 | 74 | 256
HST 2122 | 20215 | Face to Face | 56 |  |  |  |  |  |  |  |  |  |  | Face to Face | 52 |  |  |  | 74 | 126
HST 2122 | 20241 | Online | 77 |  |  |  |  |  |  |  |  |  |  | Online |  | 119 |  | 11 |  | 130
HST 2122 | 20238 | Online | 54 |  |  |  |  |  |  |  |  |  |  | Grand Total | 108 | 119 | 139 | 88 | 74 | 528
HST 2122 | 20238 | Face to Face | 85
Spreadsheet: 131373d1322934001-checking-previous-data-based-on-selection-return-values-if-workouttrackersheet1
Sheet: Exercises

Choose One | Flat Bench Press | Military Press | Squat | Machine Ham Curl | Pullups | Sled Calf Raise | [NAME] | Concentration Curl | Decline sit-up
Abs | Decline Bench Press | Dumbbell Military Press | Single-leg leg press (L) | Single Leg Curl (Lt) | Cable Pulldown | Sled Inside Raise | Dumbbell Kickback | Hammer Curl | Crunches
Back | Incline Bench Press | Side Raise | Single-leg leg press (R) | Single Leg Curl (Rt) | Cable Row | Sled Outside Raise | [NAME] | Preacher Curl Close | Decline Medicine Ball
Biceps | Flat Dumbbell Press | Front Raise | Machine Leg Extension | Barbell Lunges | One-Arm dumbbell row | Standing Raise | French Skull Crusher | Preacher Curl Wide | [NAME]
Calves | Incline Dumbbell Press | Overhead Fly | Single Leg Extension (Lt) | [NAME] | [NAME] fly |  | Dumbbell Bench Extension | Straight Bar Curls | V-ups
Chest | Decline Dumbbell Press | Shrugs | Single Leg Extension (Rt) | Deadlift | Upright Row |  | Overhead Dumbbell Extension | [NAME] | [NAME]
Hamstrings | [NAME] Fly | Upright Rows | Leg Press (Sled) |  | Wide Cable Pulls |  | Cable Tricep Extension | Superman | [NAME]
Quads | [NAME] | 6 Station Circuit | [NAME] |  | Chinups |  | Close Grip Reverse Bench Press | Close Grip Pullup | 6 Inches
Shoulders | [NAME] |  |  |  | Lower Back Extensions |  | Close Grip Reverse Decline Bench Press | Cable Bar Curl | Planks
Triceps | Cable Fly |  |  |  | Reverse Pushups |  | [NAME] | Crazy 8s
 | Cable Incline Fly |  |  |  | Dumbbell Row |  |  | 21s
 | Cable [NAME]
 | Pushups
 | Hammer Press
Spreadsheet: darrell_schoolcraft__7779__imbalsumm0106
Sheet: KN_Westar

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract 8289 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
[NAME] | 12353 | WestarCarson | 500168 | Westar Ward
 | Scheduled | Measured | Scheduled | Measured
1 |  |  | 28261 | 32518
2 |  |  | 15248 | 16267
3 |  |  | 15248 | 16171
4 |  |  | 33781 | 35902
5 |  |  | 43200 | 43017
6 |  |  | 72748 | 72064
7 |  |  | 39748 | 42722
8 |  |  | 97083 | 82378
9 |  |  | 90041 | 103739
10 |  |  | 75041 | 75942
11 |  |  | 56886 | 57625
12 |  |  | 29748 | 31461
13 |  |  | 88919 | 90366
14 |  |  | 79148 | 78922
15 |  |  | 81301 | 80189
16 |  |  | 82227 | 85181
17 |  |  | 95132 | 101901
18 |  |  | 60108 | 61461
19 |  |  | 64251 | 65434
20 |  |  | 67619 | 68771
21 |  |  | 61516 | 71394
22 |  |  | 44940 | 55339
23 |  |  | 53548 | 58992
24 |  |  | 59038 | 64711
25 |  |  | 51181 | 54039
26 |  |  | 46122 | 53864
27 |  |  | 62496 | 53842
28
29
30
31
index
2001-05-31 00:00:00 |  |  |  |  | 327664.29
2001-06-27 00:00:00
Spreadsheet: 233142d1367628653-sales-order-form-from-a-master-product-list-excel-order-form
Sheet: Quote Page

 | My Company Name
 | Customer name |  | Quote Number
 | Customer number
 | Quote Creation Date
 | Quote Expiration Date
Quantity | Part Number | Part Description | List Price
 |  |  |  | If more than 8 lines of product selected if it could automatically insert lines, it happens.
 |  |  |  | that would be great but that many lines are rare and I can deal with it as a one off if
 |  | Total Price
Scope Of work:
Spreadsheet: 156238d1337238452-index-and-match-2-criteria-1-unique-value-kosmonautas_solution
Sheet: Sheet1

Day | Product | Client
2012-01-01 00:00:00 | A | E |  |  | Day | Product | Client
2012-01-01 00:00:00 | B | D |  |  | 2012-01-02 00:00:00 | A | F
2012-01-02 00:00:00 | A | F
2012-01-02 00:00:00 | B | G
Spreadsheet: 364daa95-dd1c-4782-8726-543f4aa288b1
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
HCVG | Test | HCVG | Hepatitis C Virus Genotype, Serum | HCV [NAME], S | Reverse Transcriptase-Polymerase Chain Reaction (RT-PCR) (PCR is utilized pursuant to a license agreement with Roche Diagnostic Systems, Inc.) | Serum Gel Tube: SGT OR |  |  | 1.5 | mL | Collection Container/Tube: Serum gel Submission Container/Tube: Plastic vial [NAME]: 2 mL  Collection Instructions: 1. Spin down and separate serum from cells within 6 hours of collection. 2. Freeze serum immediately, and ship specimen frozen on dry ice only. 3. If shipment will be delayed for >24 hours, freeze serum at [NAME] (up to 35 days) until shipment on dry ice. Additional Information: Specimens should contain a recommended minimum HCV viral load of 1,000 IU/mL. | 1 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold <24 hours OK, refreeze with note to lab Lipemia	Mild OK; [NAME] OK Icterus	NA Other	Heparinized specimen, red-top tube, or plasma | Undetected | Monday through Friday; 8 a.m. | 3 days | 6 days | 1 | 87902 |  |  |  |  | Rochester
HCVG | [NAME] | SST | Serum SST |  |  |  | Frozen | 35 days
HCVG | Result | 81618 | HCV [NAME], S | HCV [NAME], S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32286-7 | Hepatitis C virus genotype:Prid:Pt:Ser/Plas:Nom:Probe.amp.tar
Spreadsheet: 776887d1649958226-transpose-data-into-the-adjoining-cells-test_140422_transpose-data-into-adjacent-cells-and-delete-the-blank-rows
Sheet: Sheet1

increase in price & open interest
Symbol | [NAME] | Last Price | Chg | Chg | High | Average | Open | Increase in OI | Increase | Vol. Shares | % Change
 |  |  | (Rs) | (%) | Low | Price | Interest |  | (%) | Prev. Volume
NTPC | 2022-04-28 00:00:00 | 154.45 | 1.7 | 0.0111 | 156.65 | 154.84 | 67356900 | 3254700 | 0.0508 | 21870900 | 0.4855 |  | 1 | I need to get the data in a format which helps me to use filter data option
 |  |  |  |  | 153.3 |  |  |  |  | 14723100 |  |  | 2 | insert two columns after col F and K
AMBUJACEM | 2022-04-28 00:00:00 | 370.2 | 10.25 | 0.0285 | 375.65 | 368.35 | 29545500 | 2877000 | 0.1079 | 28225500 | 0.086 |  | 3 | rename col headers so that it contains in a single cell
 |  |  |  |  | 359.55 |  |  |  |  | 25990500 |  |  | 4 | col G header= high,col H header= low
ONGC | 2022-04-28 00:00:00 | 174.25 | 4.85 | 0.0286 | 174.9 | 173.86 | 56433300 | 2233000 | 0.0412 | 21013300 | 0.3332 |  | 5 | col L header= Vol.Shares   ,col M header= prev.volume
 |  |  |  |  | 171.2 |  |  |  |  | 15761900 |  |  | 6 | copy and paste data from col F to G and H(values only)
ITC | 2022-05-26 00:00:00 | 269.15 | 4.2 | 0.0159 | 270.6 | 267.96 | 9705600 | 1648000 | 0.2045 | 5068800 | 0.0173 |  | 7 | copy and paste data from col K to L and M(values only)
 |  |  |  |  | 263.7 |  |  |  |  | 4982400 |  |  | 8 | delete col F and K
VEDL | 2022-05-26 00:00:00 | 423.45 | 7.3 | 0.0175 | 426.25 | 424.44 | 5403300 | 1057100 | 0.2432 | 2073900 | -0.4773 |  | 9 | del the blank rows
 |  |  |  |  | 421.8 |  |  |  |  | 3968000 |  |  | 10 | now it must be ready for data filter
COALINDIA | 2022-04-28 00:00:00 | 186.55 | 0.1 | 0.0005 | 191.7 | 188.63 | 36640800 | 982800 | 0.0276 | 22113000 | -0.1716 |  | 11 | pls have a look at the result sheet for the expected outcome
 |  |  |  |  | 185.8 |  |  |  |  | 26695200
COALINDIA | 2022-05-26 00:00:00 | 187.5 | 0.25 | 0.0013 | 192.2 | 189.71 | 2961000 | 714000 | 0.3178 | 2066400 | 0.0513
 |  |  |  |  | 186.75 |  |  |  |  | 1965600
SUNPHARMA | 2022-04-28 00:00:00 | 937.5 | 14.9 | 0.0162 | 943.35 | 935.29 | 16712500 | 582400 | 0.0361 | 3721200 | 0.5635
 |  |  |  |  | 924.05 |  |  |  |  | 2380000
INFY | 2022-04-28 00:00:00 | 1755.45 | 7.85 | 0.0045 | 1763.5 | 1752.54 | 35168400 | 483300 | 0.0139 | 10626000 | 0.0775
 |  |  |  |  | 1736.2 |  |  |  |  | 9861900
NTPC | 2022-05-26 00:00:00 | 154.95 | 1.6 | 0.0104 | 157 | 155.23 | 1761300 | 381900 | 0.2769 | 1749900 | 0.8606
 |  |  |  |  | 153.85 |  |  |  |  | 940500
Spreadsheet: 123755d1317837646-using-a-command-button-to-switch-tabs-in-excel-2007-rosterphnyc
Sheet: Bar

 | August | Mon |  | [NAME] |  | Wed |  | Thurs |  | Fri |  | Sat |  | Sun
 | 2011 | 31 |  | 4
 | BAR | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM
 | Name | 10
 | Name
 | Name
 | Name
 | Name
 | Name
 | Name
Spreadsheet: 827210d1682543740-parsing-data-set-with-index-match-or-another-method-test
Sheet: Parsed Data

[NAME] Desired Response
Company | Division | Status
Microsoft | Office | Backlog
Microsoft | Windows | In-Progress
Intel | Hardware | Backlog
Intel | MobilEye | In-Progress
AMD | Hardware | On Hold
Tesla | Automotive | In-Progress
Telsa | Space | On Hold
Adobe | [NAME] | In-Progress
Spreadsheet: 69110d1269610187-using-sum-match-copy-of-book1-5
Sheet: Sheet1

 | How many CAT I Apples are from the Sheet2 etc…
 | Cat I | Cat II | Cat III
Apple
Grape
cherry
 | Count of Fruit | CAT
 | Fruit | I | II | III | Grand Total
 | Apple | 5 | 3 | 1 | 9
 | [NAME] | 2 | 1 | 1 | 4
 | Grape |  | 2 |  | 2
 | Grand Total | 7 | 6 | 2 | 15
Spreadsheet: 742779d1628025332-formula-to-dynamically-reference-cell-in-another-worksheet-sample
Sheet: Store 1

 | P1 | P2 | P3 | P4 | P5 | P6 | P7
Dept 1 | 392 | -1287 | -20079 | 0 | 0 | 0 | 1
Dept 2 | -219 | -126 | -429 | -49 | -509 | 1594 | 3
Dept 3 | -1188 | -1056 | -24176 | -10581 | 0 | 12 | 0
Dept 4 | -643 | -278 | -7870 | -342 | -36 | 483 | -788
Spreadsheet: 472025d1469407026-converting-data-between-tabs-department-performance
Sheet: Team

332082 |  | [NAME]
149798 |  | [NAME]
334037 |  | [NAME]
347343 |  | [NAME]
111111 |  | [NAME]
349732 |  | [NAME]
 |  |  | RCV Goal = 30 PPH |  |  | FH Goal = 30 PPH |  |  | [NAME] = 20 PPH
Week |  |  | RCV Qty | RCV Time | RCV PPH | FH  Qty | FH  Time | FH  PPH | RCH  Qty | RCH  Time | RCH  PPH | Average PPH | Total Time | Notes
2016-07-03 00:00:00 | -
2016-07-10 00:00:00 | -
2016-07-17 00:00:00 | -
2016-07-24 00:00:00 | -
2016-07-31 00:00:00 | -
2016-08-07 00:00:00 | -
2016-08-14 00:00:00 | -
2016-08-21 00:00:00 | -
2016-08-28 00:00:00 | -
2016-09-04 00:00:00 | -
2016-09-11 00:00:00 | -
2016-09-18 00:00:00 | -
2016-09-25 00:00:00 | -
2016-10-02 00:00:00 | -
2016-10-09 00:00:00 | -
2016-10-16 00:00:00 | -
2016-10-23 00:00:00 | -
2016-10-30 00:00:00 | -
2016-11-06 00:00:00 | -
2016-11-13 00:00:00 | -
2016-11-20 00:00:00 | -
2016-11-27 00:00:00 | -
2016-12-04 00:00:00 | -
2016-12-11 00:00:00 | -
2016-12-18 00:00:00 | -
2016-12-25 00:00:00 | -
 |  | TOTAL
Spreadsheet: 806347d1669245869-isnumber-search-across-multiple-variables-cell-contains-one-of-many-things
Sheet: Sheet1

Description | Test | HELP!! |  |  | Description | Category
[NAME] FROM 00488084443700 |  |  |  |  | STRIPE | STRIPE
WIRE TYPE:WIRE IN DATE: 221003 TIME:0602 ET TRN:2022100300299306 SEQ:2022093000316210/244962 ORIG:DEPOSITIQ & RENTERSIQ INS ID:000004989601588 [NAME]:WELLS FARGO BANK NA ID:0407 PMT DET:4926 TO  TRANSFER FUNDS FROM DIQ CLAIMS ACCOUNT TO REIMBUR |  |  |  |  | [NAME] | DBI Cobra
WIRE TYPE:WIRE IN DATE: 221003 TIME:0534 ET TRN:2022100300292121 SEQ:2022093000313999/240611 ORIG:MULTIFAMILY INTERNET VENT ID:000004333929305 SND BK:WELLS FARGO BANK NA ID:0407 PMT DET:4925 TO  TRANSFER FUNDS FROM DEPOSIT INSURANCE ACCOUNT TO |  |  |  |  | Solium | Org Solium Capital Fed
[NAME] FROM 00488084443700 |  |  |  |  | FIDELITY | Fidelity G5 401k Loan
[NAME] FROM 00488084443700 |  |  |  |  | CITIBANK N.A.    DES:CCD | Cigna-Dental
[NAME] FROM 00488084443700 |  |  |  |  | BANCORPSV | Discovery Benefits
[NAME] FROM 00488084443700 |  |  |  |  | DISCOVERY BENEFI PLAN Fund | Discovery Benefits Plan Fund
[NAME] FROM 00488084443700 |  |  |  |  | DISCOVERY BENEFI CLAIM FUND | Discovery Benefits
[NAME] FROM 00488084443700
BAMBORA          DES:BF10000761 ID: 23493568  INDN: INC            CO ID:[PHONE] PPD
BANCORPSV        DES:BANCORPSV  ID:99994 INDN:WEX HEALTH DBI          CO ID:[PHONE] CCD  PMT INFO:WH-WEX HEALTH DBI-99994-SETTLE PURCHASE
[NAME] FROM 00488084443700
[NAME] FROM 00488084443700
[NAME] FROM 00488084443700
[NAME] FROM 00488084443700
BANCORPSV        DES:BANCORPSV  ID:99994 INDN:WEX HEALTH DBI          CO ID:[PHONE] CCD  PMT INFO:WH-WEX HEALTH DBI-99994-SETTLE PURCHASE
BANCORPSV        DES:BANCORPSV  ID:99994 INDN:WEX HEALTH DBI          CO ID:[PHONE] CCD  PMT INFO:WH-WEX HEALTH DBI-99994-SETTLE PURCHASE
BANCORPSV        DES:BANCORPSV  ID:99994 INDN:WEX HEALTH DBI          CO ID:[PHONE] CCD  PMT INFO:WH-WEX HEALTH DBI-99994-SETTLE PURCHASE
BAMBORA          DES:BF10000765 ID: 23941637  INDN: INC            CO ID:[PHONE] PPD
WEX HEALTH INC   DES:CLAIM REIM ID:22084752788861  INDN: INC CO ID:[PHONE] CCD
[NAME] FROM 00488084443700
BANCORPSV        DES:BANCORPSV  ID:99994 INDN:WEX HEALTH DBI          CO ID:[PHONE] CCD  PMT INFO:WH-WEX HEALTH DBI-99994-SETTLE PURCHASE
BANCORPSV        DES:BANCORPSV  ID:99994 INDN:WEX HEALTH DBI          CO ID:[PHONE] CCD  PMT INFO:WH-WEX HEALTH DBI-99994-SETTLE PURCHASE
, Inc.    DES:rpieft      FL# [PHONE] INDN:SETT-BATCH [PHONE]  CO ID:[PHONE] CCD  BATCH DESC:EFT BATCH # 890
Spreadsheet: 126069d1319505264-offset-and-match-on-3-variables-template_dashboard_080811
Sheet: Dashboard

Select reporting period: |  | Select segment: |  |  |  |  |  |  |  | 1) Select a time period and a segment on the left. 2) Modify data in the WebData sheets ONLY
19 |  | 1
 |  |  |  |  |  |  |  |  |  | Comment
Site Statistics | Current Month |  | Previous Month | Same Month of Last Year |  | Trend |  |  |  | General statistics for the site. Compare month to month (M2M) and Year To Year (Y2Y) data.
Unique Visitors |  |  |  |  |  |  |  | 5 – 6 |  | General site statistics. The 3 numbers beside the sparkline are the upper and lower limits (+/- 1xStandard Deviation) and the middle number is the average.
Visits |  |  |  |  |  |  |  | 5 – 6 |  | General site statistic. In most cases, an increase in visits will correlate directly with higher outcomes.
Visits/Visitor |  |  |  |  |  |  |  | 5 – 6 |  | Degree of fidelity toward the site.
[NAME] |  |  |  |  |  |  |  | 5 – 6 |  | Are you bringing quality traffic?
Page Views |  |  |  |  |  |  |  | 5 – 6 |  | General site statistic. Can be considered an indicator of engagement.
Page Views/Visits |  |  |  |  |  |  |  | 5 – 6 |  | Depending on the context, this can indicate interest in your content... Or lost trying to find something.
 |  |  |  |  |  |  |  |  |  | Space reserved for the analyst comments, edited through WebData sheet.
eCommerce | Current Month |  | Previous Month | Same Month of Last Year |  | Trend |  |  |  | This section focus on typical ecommerce metrics.
Customers |  |  |  |  |  |  |  | 5 – 6 |  | General metric.
Orders |  |  |  |  |  |  |  | 5 – 6 |  | General metric.
Items |  |  |  |  |  |  |  | 5 – 6 |  | General metric.
Items/Order |  |  |  |  |  |  |  | 5 – 6 |  | General metric.
Average [NAME] |  |  |  |  |  |  |  | 5 – 6 |  | Share of wallet.
Revenues |  |  |  |  |  |  |  | 5 – 6 |  | Bottom line...
eCommerce Conversion |  |  |  |  |  |  |  | 5 – 6 |  | Orders by Visit (or could also be Customers/Visitors)
 |  |  |  |  |  |  |  |  |  | Space reserved for the analyst comments, edited through WebData sheet.
Online Events | Current Month |  | Previous Month | Same Month of Last Year |  | Trend
Orders |  |  |  |  |  |  |  | 5 – 6 |  | Same as eCommerce above.
Success Event 1 |  |  |  |  |  |  |  | 5 – 6 |  | Significant activity
Success Event 2 |  |  |  |  |  |  |  | 5 – 6 |  | Significant activity
Success Event 3 |  |  |  |  |  |  |  | 5 – 6 |  | Significant activity
Success Rate |  |  |  |  |  |  |  | 5 – 6 |  | Percentage of visits that result in a positive outcome.
 |  |  |  |  |  |  |  |  |  | Space reserved for the analyst comments, edited through WebData sheet.
Spreadsheet: 10c7e8dc-95f6-4ec1-b486-d9564e29b119
Sheet: Directions

DIRECTIONS
This is a tool designed to help you assess aspects of your local context that may affect the success of your quality improvement project
We have identified a number of contextual factors at multiple levels of the health care system that we believe influence the successful implementation of quality improvement
We have summarized these factors and how they influence success in a model called MUSIQ.  This tool is meant to help you examine context using MUSIQ.
This excel spreadsheet has eight tabs (worksheets)
The first tab includes definitions of terms you will find throughout the tool.  Please reference this page to make sure you are familiar with the terms that will be used.
The third, fourth, fifth, sixth, seventh, and eigth tabs have questions assessing aspects of context at multiple levels including:
QI team, [NAME], QI Support Infrastructure, Organization, Environment, and Other
On each of these tabs (tabs 3-8), a series of questions is listed on  left hand side of the spreadsheet.
Indicate the extent to which you agree or disagree with that statement by typing the appropriate response (number 1-7) in the indicated cell.
For example:
 | Question | Totally Agree |  |  | Neither Agree Nor Disagree |  |  | Totally Disagree | Don't Know N/A
 |  | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 0
 | Most members of our QI team have worked on improvement projects before |  |  |  | 4
 | The QI team members have diverse professional backgrounds and experiences |  |  |  |  |  |  | 1
In this example, the respondent has answered the first question with a 4=Neither Agree Nor Disagree, and the second question with a 1=Totally Disagree
by entering the numbers in the appropriate columns
The final tab gives your score for each contextual factor in MUSIQ.  A higher score (max=7) for a contextual factor indicates that your context is likely to be supportive for this feature.
A lower score (min=1) indicates that this is an area you may want to address before or during your QI project.
IF YOU USE THE MUSIQ EXCEL CALCULATOR:
MUSIQ Excel Calculator by Cincinnati Children's Hospital Medical Center is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3.0 [NAME].
Spreadsheet: 93646d1293308751-condtional-format-maximum-and-text-windme_book34-1-
Sheet: Sheet2 

0 |  | 0 |  | 0 |  | Conditonal Formatting
0 |  | 0 |  | 0 |  | In examples on left I want the maxium value (which are in row 8) to match that value in rows 1 to 7.
3 |  | 0 |  | 0 |  | Both columns A and C are returning the maximum and highlighting in red.
T |  | 0 |  | 0
T |  | T |  | 0 |  | In column E I would like to find the maximum in E8 and to match that value in E1 to E 7 if NOT zero.
0 |  | 0 |  | 0 |  | In other words I would like the zero's in E1 to E 7 to have no color because the [NAME] is a zero but
1 |  | 0 |  | 0 |  | if a "T" or number was in E1 to E7 then it would color it red if it was the maximum
3 |  | T |  | 0
Spreadsheet: 707841d1607501976-dividing-a-number-into-its-multiplication-factors-excel-forum-2020-12-09-a
Sheet: Sheet1

24 | 2^3 | 3
881
589 |  |  |  |  |  |  |  | 19 |  |  | 31
983
547
791 |  |  |  | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 113
1005 |  | 3 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 67
89 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89
434 | 2 |  |  | 7 |  |  |  |  |  |  | 31
520 | 2^3 |  | 5 |  |  | 13
1011 |  | 3
412 | 2^2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 103
418 | 2 |  |  |  | 11 |  |  | 19
350 | 2 |  | 5^2 | 7
368 | 2^4 |  |  |  |  |  |  |  | 23
316 | 2^2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 79
Spreadsheet: 682796d1592334360-hyperlink-to-select-correct-cell-reference-in-pivot-table-data-dynamically-hyperlink
Sheet: Data Pivots

 |  |  | Count of ID | Column Labels
Row Labels | Sum of No of Positions in Class |  | Row Labels | Pass | Fail | Hold | Pending | Waiting | Grand Total
Jan | 1 |  | Jan | 1 | 5 | 4 | 1 | 2 | 13
Feb | 11 |  | Feb | 8 | 21 | 1 | 2 | 1 | 33
Mar | 1 |  | Mar |  | 3 | 5 |  | 1 | 9
Apr | 3 |  | Jun | 4 | 16 | 6 | 5 | 2 | 33
Jun | 11 |  | Dec |  | 2 | 1 | 1 | 3 | 7
Dec | 1 |  | Grand Total | 13 | 47 | 17 | 9 | 9 | 95
Grand Total | 28