tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 73367d1274028271-how-to-expand-arrays-in-the-formula-packaging-1-
Sheet: MAIN

UNIT 2 PACKAGING KEY PERFORMANCE INDICATOR
 |  |  |  |  |  |  |  |  |  |  |  | 102
 | Sift | NS2 | Sets | 142 | Date | 2010-05-04 00:00:00 |  |  | 0 |  | Completed |  | 0.704225352112676
 |  |  |  |  |  |  |  |  |  |  |  | H | S | UNPD
 | PRODUCTS | TASKS |  |  |  |  |  |  |  | PROCESS CREDITS |  | STAFF 4X4
 |  | COLOUR | CARAMEL | TOPPING | CUTTING | BOATING | PACKING | REWRAPING | [NAME] |  |  | HOLIDAYS | SICK | UNPAID LEAVE
 | WTWBNL |  |  |  | 77 |  | 100 |  |  | 177 |  | NighShift2 name3 | NighShift2 [NAME] | NighShift2 [NAME] | So, when I select a shift in C5 and a date, I want the formula to retrieve the names only from this shift and day
 | WETGR |  |  |  | 88 |  |  |  |  | 0 |  | NighShift2 name6 | NighShift2 [NAME] | #N/A
 | WTFNFJ |  |  |  |  |  |  |  |  | 0 |  | NighShift2 name13 | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | NighShift2 name18 | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  | STAFF 8 HRS EARLIES
 |  |  |  |  |  |  |  |  |  |  |  | HOLIDAYS | SICK | UNPAID LEAVE
 |  |  |  |  |  |  |  |  |  |  |  | STAFF 8 HRS LATES
 |  |  |  |  |  |  |  |  |  |  |  | HOLIDAYS | SICK | UNPAID LEAVE
 |  |  |  |  |  |  |  |  |  |  |  | OVERTIME | HOURS TRANSFERRED
 |  |  |  |  |  |  |  |  |  |  |  |  | IN | OUT
 |  |  |  |  |  |  |  |  |  |  |  | EFFICIENCY
 |  |  |  |  |  |  |  |  |  |  |  | Man hours used | Sets packed | Process credits
 |  |  |  |  |  |  |  |  |  |  |  |  | 100 | 177
 |  |  |  |  |  |  |  |  |  |  |  | COMMENTS
 |  |  |  |  |  |  |  |  | TOTAL | 177
Spreadsheet: 2a1eb375-0ee4-43a9-8e4a-28bbb93b2c5e
Sheet: 4.2(NS) Major Group Enroll-Grad

Institution
Indicator 4: Student Enrollment and Graduation by Major Group
Table 4.2(NS): Major Group Fall Enrollment, Graduation & Post-Graduate / AY 20010-11
 | Major Group | NS - Natural Science
 | Please enter the number of students enrolled in this major group for the fall semester.
 |  |  |  |  | Fall 2011 (October 15, 2011)
 | Fall Enrollment (Snapshot) |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
 |  | Full Time | na | na | na | na
 |  | Part Time | na | na | na | na
 |  | Total
 | Please enter the number of diploma, certificates, and degrees earned in this major group.  Also enter the number of students who were admitted to a 4 year (Associate degree graduates), or graduate school (Bachelor's degree graduates).  Lastly, enter the number of all graduating students(certificate or degree) who secured gainful employment after graduation.
 |  |  |  |  | July 1, 2011- June 30, 2012
 | Graduation |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
Apprenticeship/Occupational Program |  |  | na | na | na | na
 | App. graduates admitted to a college program |  | na | na | na | na
Diploma |  |  | na | na | na | na
 | [NAME]. graduates admitted to a college program |  | na | na | na | na
Certificate |  |  | na | na | na | na
 | Cert. graduates admitted to a college program |  | na | na | na | na
Associate Degree |  |  | na | na | na | na
 | Assoc. graduates admitted to four-year program |  | na | na | na | na
Bachelor's Degree |  |  | na | na | na | na
 | [NAME]. graduates admitted to graduate school |  | na | na | na | na
Master's Degree |  |  | na | na | na | na
Gainfully Employed after graduation |  |  | na | na | na | na
Graduates who completed remedial courses during their time at the TCU |  |  | na | na | na | na
Graduates who received A*CF support at some point during their coursework |  |  | na | na | na | na
Notes:
Spreadsheet: 409a74cb-e787-441f-9c84-165250e4793e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
2014 State Growth Summary by Subgroups
Math Growth by Subgroups (2014)
Subgroup |  | Growth Percentiles 14 |  |  | Catch-Up 14 |  | Keep-Up 14 |  | Move-Up 14
 |  | Count | MGP | AGP | Count | % | Count | % | Count | %
MIN | YES | 183269 | 48 | 76 | 95775 | 9.4 | 87494 | 54.3 | 58055 | 14.4
 | NO | 226971 | 52 | 48 | 64410 | 13.8 | 162561 | 66.7 | 83206 | 18
FRL | YES | 171159 | 47 | 78 | 94962 | 9.5 | 76197 | 49 | 54929 | 13.5
 | NO | 238988 | 52 | 46 | 65158 | 13.6 | 173830 | 68.2 | 86315 | 18.4
IEP | YES | 38501 | 44 | 96 | 31441 | 5.5 | 7060 | 43.5 | 5534 | 13.6
 | NO | 371708 | 51 | 57 | 128723 | 12.6 | 242985 | 62.9 | 135718 | 16.6
ELL | YES | 77768 | 50 | 81 | 45111 | 9.7 | 32657 | 52.2 | 23417 | 15.1
 | NO | 332477 | 50 | 56 | 115077 | 11.8 | 217400 | 63.9 | 117845 | 16.8
Reading Growth by Subgroups (2014)
Subgroup |  | Growth Percentiles 14 |  |  | Catch-Up 14 |  | Keep-Up 14 |  | Move-Up 14
 |  | Count | MGP | AGP | Count | % | Count | % | Count | %
MIN | YES | 181157 | 49 | 41 | 77103 | 27.6 | 104054 | 75.3 | 97295 | 10.3
 | NO | 226389 | 51 | 19 | 42047 | 36.8 | 184342 | 83.8 | 160267 | 15.8
FRL | YES | 169079 | 48 | 45 | 77674 | 27.2 | 91405 | 71.7 | 87773 | 8.5
 | NO | 238378 | 52 | 17 | 41434 | 37.8 | 196944 | 84.9 | 169747 | 16.4
IEP | YES | 38091 | 45 | 79 | 30422 | 16.9 | 7669 | 61.6 | 7458 | 6.9
 | NO | 369434 | 51 | 24 | 88721 | 35.7 | 280713 | 81.2 | 250092 | 13.9
ELL | YES | 76142 | 51 | 53 | 40550 | 26.7 | 35592 | 72.7 | 34165 | 8.9
 | NO | 331408 | 50 | 22 | 78602 | 33 | 252806 | 81.8 | 223399 | 14.4
Writing Growth by Subgroups (2014)
Subgroup |  | Growth Percentiles 14 |  |  | Catch-Up 14 |  | Keep-Up 14 |  | Move-Up 14
 |  | Count | MGP | AGP | Count | % | Count | % | Count | %
MIN | YES | 181507 | 49 | 59 | 102095 | 22.7 | 79412 | 66.7 | 70182 | 15
 | NO | 226368 | 51 | 36 | 73132 | 30.5 | 153236 | 75.4 | 122853 | 19.8
FRL | YES | 169444 | 48 | 63 | 103711 | 22 | 65733 | 61.8 | 60630 | 12.5
 | NO | 238341 | 52 | 34 | 71458 | 31.7 | 166883 | 76.6 | 132375 | 20.6
IEP | YES | 38193 | 44 | 88 | 33998 | 11.7 | 4195 | 51.3 | 3973 | 10.7
 | NO | 369661 | 51 | 42 | 141221 | 29.4 | 228440 | 72.8 | 189049 | 18.2
ELL | YES | 76276 | 52 | 68 | 49353 | 22.7 | 26923 | 64.2 | 24740 | 13.7
 | NO | 331603 | 50 | 41 | 125876 | 27.3 | 205727 | 73.5 | 168297 | 18.7
Spreadsheet: 89514d1289302556-how-to-get-div-0-to-show-as-zero-averagesforum
Sheet: Agent 1

Agent Name: | 0
 | Monday | Tuesday | Wednesday | Thursday | Friday | Average | Sum
PNC | 0 | 19 | 0 | 42 | 12 | 24.33333333333333 | 73
CONFLICTS | 0 | 0 | 0 | 0 | 0 | #N/A | 0
ID'S | 0 | 250 | 0 | 0 | 0 | 250 | 250
ISA | 170 | 82 | 222 | 182 | 152 | 161.6 | 808
Spreadsheet: 1f1b1ce4-f60b-448a-a481-66d9dff26d29
Sheet: LexisNexis

LexisNexis
2004-2005
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Price for 2004-2005 | Price per unit
Academic | 2004-07-01 00:00:00 | 2004-08-01 00:00:00 | 2004-09-01 00:00:00 | 2004-10-01 00:00:00 | 2004-11-01 00:00:00 | 2004-12-01 00:00:00 | 2005-01-01 00:00:00 | 2005-02-01 00:00:00 | 2005-03-01 00:00:00 | 2005-04-01 00:00:00 | 2005-05-01 00:00:00 | 2005-06-01 00:00:00 | Total
TOTAL
Academic
Searches | 4217 | 2324 | 10075 | 12757 | 11646 | 8125 | 7314 | 12467 | 8923 | 11700 | 5101 | 2189 |  | 21786
Documents Retrieved | 6435 | 3155 | 9933 | 14644 | 13503 | 9958 | 9371 | 16643 | 11553 | 15024 | 7128 | 3526 |  | 21786
Congressional | 2004-07-01 00:00:00 | 2004-08-01 00:00:00 | 2004-09-01 00:00:00 | 2004-10-01 00:00:00 | 2004-11-01 00:00:00 | 2004-12-01 00:00:00 | 2005-01-01 00:00:00 | 2005-02-01 00:00:00 | 2005-03-01 00:00:00 | 2005-04-01 00:00:00 | 2005-05-01 00:00:00 | 2005-06-01 00:00:00 | Total
TOTAL
Congressional
Searches | N/A | N/A | N/A | 16 | 78 | 56 | 58 | 264 | 607 | 477 | 66 | 147 |  | 4947
Documents Retrieved | N/A | N/A | N/A | 29 | 68 | 18 | 36 | 835 | 754 | 526 | 40 | 154 |  | 4947
Spreadsheet: 141359d1329231416-sort-one-positive-and-one-negative-number-sort
Sheet: Sheet2

-44
-59
73
-85
-85
-85
85
-58
0
-54
-21
21
47
38
1
-91
-55
79
89
-25
61
23
-70
-58
54
35
79
58
85
44
-60
-78
-79
Spreadsheet: 3ea56839-e5cd-4b41-977e-4542f3ff5eab
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
ORNG | Test | ORNG | Orange, IgE | Orange, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
ORNG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
ORNG | Result | ORNG | Orange, IgE | Orange, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6194-5 | Citrus sinensis [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 224817d1364794469-filtering-values-test
Sheet: Sheet1

 | Total Raw Data |  |  |  |  |  |  |  | End result after filtering
 | Number | Amt | Number | Amt | Number | Amt |  |  | Number | Amt | Number | Amt | Number | Amt
 | 12741 | 3350 | 190894 | 4000 | 153344 | 3790 |  |  | 12741 | 3350 | 190894 | 4000 | 153344 | 3790
 | 302362 | 2300 | 221847 | 4000 | 223356 | 1800 |  |  | 302362 | 2300 | 221847 | 4000 | 219958 | -2000
 | 150440 | 170 | 10374 | 3000 | 127108 | 360 |  |  | 210848 | -2000 | 10374 | 3000 | 144017 | -3000
 | 214238 | 160 | 148852 | 300 | 181117 | 360 |  |  | 173272 | -3400 | 221537 | -5000 | 155933 | -6000
 | 10373 | 110 | 12414 | 300 | 217921 | 300
 | 10374 | 100 | 206617 | 200 | 114038 | 200
 | 161786 | 20 | 120012 | 200 | 223188 | 150
 | 1164 | 0 | 221653 | 120 | 140738 | 100
 | 304058 | -40 | 129086 | 119 | 149063 | 50
 | 220887 | -60 | 132091 | 100 | 132818 | 22
 | 119823 | -160 | 187859 | 100 | 222733 | 20
 | 210848 | -2000 | 143596 | 100 | 100770 | -1400
 | 173272 | -3400 | 151363 | 100 | 219958 | -2000
 |  |  | 10214 | 90 | 144017 | -3000
 |  |  | 148890 | 85 | 155933 | -6000
 |  |  | 151575 | 70
 |  |  | 128294 | 70
 |  |  | 144199 | 0
 |  |  | 303467 | 0
 |  |  | 221537 | -5000
Spreadsheet: 838441d1691009740-excel-calander-employee-absence-schedule12023
Sheet: April

 | Absence Type Key | AL | Vacation |  |  | P | Personal |  |  | S | Sick |  |  | Custom 1 |  |  |  | Custom 2
 | April | Dates of Absence
 | Employee Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | Total Days | AL | Personal | Sick
 | [NAME] |  |  |  |  |  |  |  |  |  | BH
 | [NAME] |  |  |  |  |  |  |  |  |  | BH
 | Alsop |  |  |  |  |  |  |  |  |  | BH
 | [NAME] |  |  |  |  |  |  |  |  |  | BH
 | [NAME] |  |  |  |  |  |  |  |  |  | BH
 | Avery |  |  |  |  |  |  |  |  |  | BH
 | Bailey |  |  |  |  |  |  |  |  |  | BH
 | [NAME] |  |  |  |  |  |  |  |  |  | BH
 | [NAME] |  |  |  |  |  |  |  |  |  | BH
 | Bell |  |  |  |  |  |  |  |  |  | BH
 | Berry |  |  |  |  |  |  |  |  |  | BH
 | Black |  |  |  |  |  |  |  |  |  | BH
 | Blake |  |  |  |  |  |  |  |  |  | BH
 | Bond |  |  |  |  |  |  |  |  |  | BH
 | Bower |  |  |  |  |  |  |  |  |  | BH
 | [NAME] |  |  |  |  |  |  |  |  |  | BH
 | Buckland |  |  |  |  |  |  |  |  |  | BH
 | Burgess |  |  |  |  |  |  |  |  |  | BH
 | Butler |  |  |  |  |  |  |  |  |  | BH
 | Cameron |  |  |  |  |  |  |  |  |  | BH
 | Campbell |  |  |  |  |  |  |  |  |  | BH
 | [NAME] |  |  |  |  |  |  |  |  |  | BH
 | Chapman |  |  |  |  |  |  |  |  |  | BH
 | Churchill |  |  |  |  |  |  |  |  |  | BH
 | [NAME] |  |  |  |  |  |  |  |  |  | BH
 | Clarkson |  |  |  |  |  |  |  |  |  | BH
 | [NAME] |  |  |  |  |  |  |  |  |  | BH
 | Cornish |  |  |  |  |  |  |  |  |  | BH
 | [NAME] |  |  |  |  |  |  |  |  |  | BH
 | Davies |  |  |  |  |  |  |  |  |  | BH
 | [NAME] |  |  |  |  |  |  |  |  |  | BH
 | [NAME] |  |  |  |  |  |  |  |  |  | BH
 | [NAME] |  |  |  |  |  |  |  |  |  | BH
 | Dyer |  |  |  |  |  |  |  |  |  | BH
 | Edmunds |  |  |  |  |  |  |  |  |  | BH
 | [NAME] |  |  |  |  |  |  |  |  |  | BH
 | Ferguson |  |  |  |  |  |  |  |  |  | BH
 | Fisher |  |  |  |  |  |  |  |  |  | BH
 | [NAME] |  |  |  |  |  |  |  |  |  | BH
 | [NAME] |  |  |  |  |  |  |  |  |  | BH
 | [NAME] |  |  |  |  |  |  |  |  |  | BH
 | [NAME] |  |  |  |  |  |  |  |  |  | BH
 | Glover |  |  |  |  |  |  |  |  |  | BH
 | [NAME] |  |  |  |  |  |  |  |  |  | BH
 | Grant |  |  |  |  |  |  |  |  |  | BH
 | Gray |  |  |  |  |  |  |  |  |  | BH
 | Greene |  |  |  |  |  |  |  |  |  | BH
 | [NAME] |  |  |  |  |  |  |  |  |  | BH
 | Hardacre |  |  |  |  |  |  |  |  |  | BH
 | [NAME] |  |  |  |  |  |  |  |  |  | BH
Spreadsheet: 109397d1306268023-need-help-with-multiple-values-sample_bol
Sheet: Sheet1

On sheet2 scanning off a barcode label
Part No. | Qty. | Wt. | W/O No. | P/O No.
896-73733-001 | 2036 | 7.12 | 549625 | 17881
896-73733-001 | 2159 | 7.56 | 549625 | 17881
896-73733-001 | 2106 | 7.38 | 549625 | 17881
896-73733-001 | 2039 | 7.14 | 549626 | 17882
896-73733-001 | 2047 | 7.16 | 549626 | 17882
896-73733-001 | 2034 | 7.12 | 549626 | 17882
896-73733-001 | 2141 | 7.5 | 549627 | 17883
896-73733-001 | 2126 | 7.44 | 549627 | 17883
896-73733-001 | 2128 | 7.44 | 549627 | 17883
896-73733-001 | 2120 | 7.42 | 549627 | 17883
612-13327-001 | 2000 | 8.5 | 601100 | 18522
612-13327-001 | 2000 | 8.5 | 601100 | 18522
612-13327-001 | 2000 | 8.5 | 601100 | 18522
On Sheet1 (This is how I want it to come out)
Part No. |  | P/O No. |  | W/O No.
896-73733-001 |  | 17881 |  | 549625
896-73733-001 |  | 17882 |  | 549626
896-73733-001 |  | 17883 |  | 549627
612-13327-001 |  | 18522 |  | 601100
Spreadsheet: 687967d1595510772-retrieving-table-headers-example-correlation-matrix
Sheet: Summary

 | A | B | C | D | E | F
A
B | 0.8735912783758089
C | 0.8351574699918901 | 0.7592321573040427
D | 0.965427561158188 | 0.82669920327941 | 0.7488337053886939
E | 0.8758835235369993 | 0.9873473614018807 | 0.7750678691338861 | 0.8209155384808761
F | 0.9975997615337668 | 0.8884050123375267 | 0.8456950199542151 | 0.9585209402717993 | 0.8913281422766228
Spreadsheet: 30453d1225977805-formula-to-calculate-staff-performance-staff1
Sheet: Staff1

1=YES. 0=NO. LEAVE BLANK = N/A.
0 | 14
0 | 14
CALL REFERENCE:
DATE:
Date Feedback:
STANDARD
1 Agent is fluent, clearly audible.. | 1
2 Agent is enthusiastic, uses positive words.. | 1
3 Agent fills gaps, explains actions being taken.. | 1
4 Customer does not ask agent to repeat.. | 1
5 Agent emphathises with customer..
6 Agent is able to diffuse customer's anger.. | 1
7 Agent attempts service recovery of call..
8 Agent attempts to build rapport where feasible.. | 1
9 Agent uses formal business language..
10 Agent alligns with the customer.. | 1
11 Agent gave clear, relevant responses.. | 1
12 Agent does not make the customer.. | 1
13 Agent takes ownership.. | 1
14 Agent does not deflect call inappropriately.. | 1
15 Agent does not use the mute button.. | 1
16 Agent gives appropriate greeting..
17 Agent gives own name.. | 1
18 Agent uses standard phonetics..
19 Agent offers to hold where appropriate.. | 1
20 Agent thanks the customer..
SCORE: | 1
Spreadsheet: 37905d1236011443-moving-entire-rows-to-another-sheet-and-to-another-file-salescontacts-1-
Sheet: main

sales person | name | phone | email
[NAME] | [NAME] | [PHONE] | [EMAIL]
rich | [NAME] | [PHONE] | [EMAIL]
[NAME] | [NAME] | [PHONE] | [EMAIL]
[NAME] | pete buckanon | [PHONE] | [EMAIL]
[NAME] | graig strauss | [PHONE] | [EMAIL]
[NAME] | [NAME] | [PHONE] | [EMAIL]
[NAME] | [NAME] | [PHONE] | [EMAIL]
rich | [NAME] | [PHONE] | [EMAIL]
[NAME] | [NAME] | [PHONE] | [EMAIL]
 |  |  |  |  |  |  | Hi ….I have 2 questios……for this table that is contantly expanding with new entries....FIRST, based on column A, how I can send each row entries to its corresponding tab below…for example, all [NAME] entries need to go to the joe tab, etc..... SECOND.....how can I send all the entries already located in the "salescontacts" file in the JOE tab....then send those entries to the other file called [NAME] and specificly to its tab named "potentialsales"
Spreadsheet: 81274d1281520642-averaging-percentages-with-blank-cells-percentage-average
Sheet: Feuil1

Price 1 | Price 2 | Comparison price 2 vs Price 1
100 | 100 | 1
5489 | 3589 | 0.6538531608671889
259 |  | 0
240 | 234 | 0.975
3300 | 3365 | 1.01969696969697
1265 | 1385 | 1.094861660079051
145 |  | 0
10798 | 8673 | 0.8032042970920541
Spreadsheet: 28907d1223480837-dividing-the-sum-of-two-rows-ignoring-null-entries-example
Sheet: Sheet1

Test Date | 2008-09-01 00:00:00 | 2008-09-08 00:00:00 | 2008-09-15 00:00:00 | 2008-09-22 00:00:00 | 2008-09-29 00:00:00 | 2008-10-06 00:00:00 | 2008-10-13 00:00:00 | 2008-10-20 00:00:00 | 2008-10-27 00:00:00 | 2008-11-03 00:00:00 | 2008-11-10 00:00:00 | 2008-11-17 00:00:00
Total Questions | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30 | 30
Questions Answered Correctly | 10 | 15 | 20 | 10 | 15 | 20
Total Average | 0.25
Spreadsheet: 422857d1443972687-call-center-forecasting-help-copy-of-phone-call-volume-september-2015-ndm
Sheet: Sheet5

Row Labels
1:07:20 PM
1:09:29 PM
1:08:19 PM
1:12:13 PM
1:08:28 PM
1:08:39 PM
1:09:47 PM
1:10:06 PM
1:10:08 PM
1:10:20 PM
1:11:10 PM
1:13:47 PM
1:11:15 PM
1:12:54 PM
1:13:30 PM
1:36:15 PM
1:15:25 PM
1:16:44 PM
1:22:09 PM
1:26:37 PM
1:23:37 AM
1:24:03 AM
1:24:17 PM
1:25:27 PM
1:25:40 AM
1:25:53 AM
1:36:36 PM
1:36:54 PM
1:36:47 PM
1:44:10 PM
1:40:57 PM
1:41:39 PM
1:54:47 PM
1:55:54 PM
1:56:03 PM
2:00:21 PM
1:57:00 AM
1:57:21 AM
10:05:43 AM
10:05:57 AM
10:06:30 AM
10:06:38 AM
10:06:41 AM
10:07:23 AM
10:17:45 AM
10:23:50 AM
10:22:49 AM
10:23:25 AM
10:24:38 AM
10:24:49 AM
10:24:59 AM
10:30:28 AM
10:34:14 AM
10:34:24 AM
10:37:35 AM
10:37:42 AM
10:40:22 AM
10:42:52 AM
10:43:53 AM
10:45:36 AM
10:45:09 AM
10:57:13 AM
10:45:44 AM
10:47:30 AM
10:47:11 AM
10:48:48 AM
10:47:55 AM
10:55:06 AM
10:50:11 AM
10:50:17 AM
10:50:56 AM
10:54:17 AM
10:54:34 AM
10:55:29 AM
10:55:21 AM
10:57:22 AM
11:18:02 AM
11:30:38 AM
11:35:07 AM
11:35:08 AM
11:35:42 AM
11:35:42 AM
11:36:10 AM
11:36:56 AM
11:38:04 AM
11:38:55 AM
11:40:45 AM
11:41:51 AM
11:42:16 AM
11:43:05 AM
11:43:27 AM
11:45:08 AM
11:45:48 AM
11:46:56 AM
11:46:13 AM
11:47:24 AM
11:51:03 AM
11:51:11 AM
12:06:22 PM
12:13:32 PM
12:06:45 PM
12:12:53 PM
12:16:28 PM
12:17:15 PM
12:17:24 PM
12:26:37 PM
2:00:40 AM
2:01:12 AM
2:01:58 PM
2:02:11 PM
2:32:43 PM
2:34:39 PM
2:47:52 PM
2:48:01 PM
2:48:40 PM
2:49:11 PM
2:50:06 PM
2:50:57 PM
2:59:37 PM
3:02:18 PM
3:00:20 PM
3:23:40 PM
3:05:54 PM
3:07:20 PM
3:06:41 PM
3:07:29 PM
3:10:17 PM
3:11:22 PM
3:24:15 PM
3:25:46 PM
3:33:15 PM
3:36:30 PM
3:34:16 PM
3:35:11 PM
3:36:57 PM
3:37:46 PM
3:37:52 PM
3:38:28 PM
3:40:48 PM
3:41:47 PM
3:42:01 PM
3:42:53 PM
3:45:30 PM
3:47:00 PM
3:58:48 PM
3:58:49 PM
4:04:28 PM
4:05:36 PM
4:05:30 PM
4:06:24 PM
4:05:41 PM
4:07:17 PM
4:05:52 PM
4:06:14 PM
4:24:51 PM
4:25:04 PM
4:25:44 PM
4:26:41 PM
4:26:44 PM
4:27:29 PM
4:28:12 PM
4:29:20 PM
4:36:28 PM
4:36:30 PM
4:38:21 PM
4:39:44 PM
4:38:42 PM
4:40:14 PM
4:44:05 PM
4:45:58 PM
4:48:01 AM
4:48:45 AM
4:56:28 PM
4:57:40 PM
4:58:31 PM
4:59:21 PM
4:59:00 PM
4:59:45 PM
5:04:48 PM
5:34:08 PM
5:06:15 PM
5:06:22 PM
5:07:17 PM
5:08:28 PM
5:12:41 PM
5:13:59 PM
5:32:32 PM
5:33:02 PM
5:32:43 PM
5:34:18 PM
5:47:31 PM
6:24:37 PM
6:01:51 PM
6:03:36 PM
6:04:17 PM
6:06:30 PM
6:10:10 PM
6:10:31 PM
6:33:36 PM
6:33:39 PM
6:34:45 PM
6:35:42 PM
6:39:50 PM
6:41:46 PM
6:44:00 PM
6:44:46 PM
6:44:09 PM
6:44:24 PM
7:17:23 PM
7:19:07 PM
7:57:09 PM
7:57:36 PM
8:04:03 PM
8:04:16 PM
8:40:01 PM
8:41:09 PM
9:01:49 AM
9:01:58 AM
9:09:03 AM
9:09:59 AM
9:10:09 AM
9:11:18 AM
9:11:36 AM
9:13:00 AM
9:16:01 PM
9:16:29 PM
9:29:42 AM
9:30:48 AM
9:31:00 AM
9:31:18 AM
9:33:19 AM
9:35:31 PM
9:35:47 PM
9:46:49 AM
9:49:07 AM
9:55:10 AM
9:55:33 AM
Grand Total
Spreadsheet: 270268d1381425972-sumproduct-with-id-numbers-that-has-minus-signs-and-using-time-as-an-array-samplehelpv1
Sheet: DPS Hours

Actual ID | Start Time | End Time
13-01294-001 | 05:00:00 | 07:00:00 |  |  | 13-01294
13-01294-002 | 12:00:00 | 01:00:00 |  |  | 13-00842
13-01294-003 | 03:00:00 | 05:00:00
13-01294-004 | 21:30:00 | 23:30:00
13-01294-005 | 22:00:00 | 23:00:00
13-01294-006 | 19:00:00 | 20:00:00
13-01294-007 | 22:00:00 | 23:00:00
13-01294-008 | 12:01:00 | 02:01:00
13-01294-009 | 12:30:00 | 02:00:00
13-01294-010 | 04:00:00 | 04:30:00
13-01294-011 | 18:00:00 | 20:00:00
13-00842-012 | 20:00:00 | 22:00:00
13-00842-013 | 20:00:00 | 22:00:00
13-00842-014 | 20:00:00 | 22:00:00
13-00842-015 | 20:00:00 | 22:00:00
13-00842-085 | 20:00:00 | 23:59:00
13-00842-086 | 20:00:00 | 23:59:00
13-00842-016 | 20:00:00 | 22:00:00
13-00842-017 | 20:00:00 | 22:00:00
13-00842-018 | 20:00:00 | 23:00:00 |  |  | Sumproduct of 13-01294 | ???
13-00842-019 | 20:00:00 | 22:00:00 |  |  | Sumproduct of 13-00842 | ???
13-00842-020 | 20:00:00 | 22:00:00
13-00842-087 | 20:00:00 | 23:59:00
13-00842-088 | 20:00:00 | 23:59:00
13-00842-021 | 20:00:00 | 22:00:00
13-00842-022 | 20:00:00 | 22:00:00
13-00842-023 | 20:00:00 | 22:00:00
13-00842-024 | 20:00:00 | 22:00:00
13-00842-025 | 20:00:00 | 22:00:00
13-00842-089 | 20:00:00 | 23:59:00
13-00842-090 | 20:00:00 | 23:59:00
13-00842-026 | 20:00:00 | 22:00:00
13-00842-027 | 20:00:00 | 22:00:00
13-00842-028 | 20:00:00 | 22:00:00
13-00842-029 | 20:00:00 | 22:00:00
Spreadsheet: 55182d1255353070-how-to-automatically-alter-formula-when-filters-are-applied-malchemist-2
Sheet: 31945

Date of Order | Date of Order | Year of Order | Month Of Order | Item No. | Description | Quantity | [NAME] value £ | Order Number | Contract
20081128 | 2008-11-28 | 2008 | 11 | 244283 | Cordl. ham. dr. driver SFH 144-A Li-Ion | 1 | 91.95 | 131367 | 31945
20081128 | 2008-11-28 | 2008 | 11 | 272444 | Battery charger C 4/36-ACS Li TPS 230V | 1 | 71.65 | 131367 | 31945
20081128 | 2008-11-28 | 2008 | 11 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 49.42 | 131367 | 31945
20081128 | 2008-11-28 | 2008 | 11 | 273114 | Battery pack B 144 2.6 Li-Ion | 1 | 49.42 | 131367 | 31945
Spreadsheet: 704339d1605516296-formula-to-find-the-non-zero-values-with-conditions-example1
Sheet: Sheet1

Criteria 1 | [NAME] | Criteria 3
X | PL | 20
X | PL | 0
X | MT | 20
X | MT | 30
Y | PL | 0
Y | MT | 0
Z | PL | 5
Z | MT | 5
B | PL | 2
B | MT | 2
A | PL | 20
A | MT | 20
Z | PL | 0
Z | MT | 0
Z | PL | 2
Z | MT | 2
D | PL | 0
D | MT | 0
D | PL | 30
D | MT | 30
Requirement is |  | [NAME] which is not equal to zero
 |  | [NAME] which is equal to PL
 |  | Criteria eliminate the duplicaes if the above two coniditions matched
Spreadsheet: 84820d1284914039-extract-data-from-cells-budget-tracking-2003
Sheet: Budget

Project Name: | Service Desk Tool Implementation
Project Manager:
 |  |  |  |  |  | Total Budget | 200000
 |  |  | Project Phase | % | start | End | Planned Budget
 |  |  | Pre-Initiation (10%) | 10 | 2010-09-01 00:00:00 | 2010-09-25 00:00:00 | 20000
 |  |  | Initiation (10%) | 10 | 2010-09-26 00:00:00 | 2010-10-10 00:00:00 | 20000
 |  |  | Planning (15%) | 15 | 2010-10-11 00:00:00 | 2010-11-11 00:00:00 | 30000
 |  |  | Execution (60%) | 60 | 2010-11-11 00:00:00 | 2011-02-01 00:00:00 | 120000
 |  |  | Closeout (5%) | 5 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 10000
 |  |  | Q1 | Q2 | Q3 | Q4
Planned Budget |  |  | 0 | 0 | 20000 | 50000
Planned work (%) |  |  | 0 | 0 | 10 | 25
Planned work Cumulative
Actual Work
Actual Work Cumulative
Actual Cost
Actual Cost Cumaltive
PV
EV
SPI
CPI
Spreadsheet: 1fe98130-b1a4-471d-85f9-88d59326acaf
Sheet: 12a

Product1 | Cleared2 | Uncleared | TOTAL
Cross_Currency Basis | 0 | 68319 | 68319
Cross_Currency Fixed-Fixed | 0 | 3170 | 3170
Cross_Currency Fixed-Float | 0 | 15126 | 15126
TOTAL | -