tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 776209d1649605805-help-with-transpose-and-frequency-formula-excel-example-abell-
Sheet: Example

Filter by Rep email address | Cadence |  |  |  |  | Employee1
 | Monthly | Weekly | Daily | Never / Rarely |  |  | Monthly | Weekly | Daily | Never / Rarely
Assist warehouse with lost/mis-directed shipments - Cadence | 6 | 2 | 1 | 2
Assist warehouse with product identifcation - Cadence | 6 | 5 | 2 | 3 |  | Assist warehouse with product identifcation - Cadence
Calling customers for pickup orders - Cadence | 6 | 2 | 2 | 0 |  | Calling customers for pickup orders - Cadence
Collections / Chasing Payments - Cadence | 1 | 5 | 5 | 2 |  | Collections / Chasing Payments - Cadence
Contacting Purchasing for missing order confirmation in JDE - Cadence | 4 | 3 | 5 | 2 |  | Contacting Purchasing for missing order confirmation in JDE - Cadence
Correcting JDE or warehouse generated errors (kits, ship confirm, ) - Cadence | 5 | 5 | 5 | 2 |  | Correcting JDE or warehouse generated errors (kits, ship confirm, ) - Cadence
Costing from vendor - Cadence | 2 | 1 | 5 | 2 |  | Costing from vendor - Cadence
Credit card orders - Cadence | 1 | 2 | 5 | 2 |  | Credit card orders - Cadence
Credits/RGA/Debits - Cadence | 4 | 2 | 5 | 2 |  | Credits/RGA/Debits - Cadence
Drop Ship Orders - Cadence | 6 | 2 | 5 | 2 |  | Drop Ship Orders - Cadence
Expediting- internal departments (warehouse, shop) - Cadence | 8 | 5 | 5 | 2 |  | Expediting- internal departments (warehouse, shop) - Cadence
Expediting- with vendor - Cadence | 3 | 2 | 5 | 2 |  | Expediting- with vendor - Cadence
Export Docs - Cadence | 2 | 6 | 5 | 2 |  | Export Docs - Cadence
Freight Quotes & Freight Charges on Orders - Cadence | 5 | 6 | 5 | 2 |  | Freight Quotes & Freight Charges on Orders - Cadence
Generate customer UPS pick-up & waybills - Cadence | 6 | 8 | 5 | 2 |  | Generate customer UPS pick-up & waybills - Cadence
Incorrect JDE information - parts needing corrections/duplicates - Cadence | 7 | 8 | 5 | 2 |  | Incorrect JDE information - parts needing corrections/duplicates - Cadence
New Vendor Set Up - Cadence | 8 | 2 | 5 | 2 |  | New Vendor Set Up - Cadence
Non divisional Calls from customers - Cadence | 5 | 1 | 5 | 2 |  | Non divisional Calls from customers - Cadence
Release M1/C1 Holds - Cadence | 5 | 0 | 5 | 2 |  | Release M1/C1 Holds - Cadence
Reseller Quote Follow Ups - Cadence | 3 | 6 | 5 | 2 |  | Reseller Quote Follow Ups - Cadence
Re-send Packing Slips - Cadence | 3 | 5 | 5 | 2 |  | Re-send Packing Slips - Cadence
Send tracking information - Cadence | 2 | 3 | 5 | 2 |  | Send tracking information - Cadence
Sending invoices to customers - Cadence |  | 8 | 5 | 2 |  | Sending invoices to customers - Cadence
Sorting out billing issues/advising correct amounts - Cadence | 5 | 7 | 5 | 2 |  | Sorting out billing issues/advising correct amounts - Cadence
Vendor Purchase order Corrections - Cadence | 6 | 1 | 5 | 2 |  | Vendor Purchase order Corrections - Cadence
Spreadsheet: 721022d1614431136-need-help-to-remove-false-and-shorten-the-formula-sample-workbook-2-
Sheet: Prototype

Care Setting: |  |  |  | Start Point: | Free text field |  | Total Manpower Cost:
Length of Inpatient Stay: |  |  |  | End Point: | Free text field |  | Total Non-Manpower Cost:
Date of Update: |  |  |  | Exclusions: | Free text field |  | Overall Cost per Carepath:
S/N | Type of Cost | Type of Care Setting | Activity/ Therapy/ Procedures | Profession | Seniority | Generic Cost from Finance (Manpower) | FTE required | Activity Duration (minutes) | Manpower Cost per Activity | Generic Cost from Finance (Non-Manpower) | Non-Manpower Cost based on LOS
1 | Supplies Cost | Specialist Outpatient Clinic | Standard subsidised clinic (per attendance) | Doctor | Senior Consultant |  | 1 | 30
2 | Supplies Cost | Specialist Outpatient Clinic | Private clinic (per attendance)
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
Spreadsheet: 755ed4d2-eaa4-4053-993e-10975d9d2f27
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
FPOLS | Test | FPOLS | Poliovirus Antibody, Neutralization | [NAME] | Neutralization | Plain, Red-Top Tube: Red |  |  | 1 | mL | Draw blood in a plain, red-top tube(s). (Serum gel tube is acceptable.) Spin down and send 1 mL of serum refrigerated. | 0.5 mL | Specimens other than	Serum Anticoagulants other than	NA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | Polio 1 Titer:  <1:8 Polio 2 Titer:  <1:8 Polio 3 Titer:  <1:8    The presence of neutralizing serum antibodies (titers 1:8 up to >1:128) against polioviruses implies lifelong immunity. The serum neutralization test is type specific; antibodies detected against one type does not indicate immunity against other types. Some persons without detectable titers (<1:8) may also be immune as demonstrated by elicitation of a secondary-type  serum antibody response upon rechallenge with live polio vaccine.    Test Performed by:  Focus Diagnostics, Inc.                                              5785 Corporate Ave.                                         Cypress, CA 90630-4750 | Monday and Thursday | 1 day | 1- 5 days | 3 | 86382 |  |  |  |  | Focus Diagnositics, Inc.
FPOLS | [NAME] | SERUM | Serum |  |  |  | Refrigerated
FPOLS | Result | Z0704 | Polio 1 Titer | Polio 1 Titer | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FPOLS | Result | Z0496 | Polio 2 Titer | Polio 2 Titer | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FPOLS | Result | Z0497 | Polio 3 Titer | Polio 3 Titer | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 727066d1617700988-calculate-transactions-of-buying-and-selling-stocks-according-to-fifo-fifo-trades
Sheet: Sheet3

Date | Symbol | Type | Units | Cumulative Units | Price | Transaction value | Cumulative Transaction value | Average Price
2021-03-01 00:00:00 | GOOGL | BUY | 10 |  | 2050
2021-03-05 00:00:00 | GOOGL | BUY | 5 |  | 2040
2021-03-06 00:00:00 | GOOGL | BUY | 1 |  | 2030 |  |  |  |  | Closed Trades
2021-04-02 00:00:00 | GOOGL | SELL | -12 |  | 2100 |  |  |  |  | Date | Units | Price | Average Price | SELL Price | Profit/Loss
 |  |  |  |  |  |  |  |  |  | 2021-03-01 00:00:00 | 10 | 2050
 |  |  |  |  |  |  |  |  |  | 2021-03-05 00:00:00 | 2 | 2040
 |  |  |  |  |  |  |  |  |  | Open Position
 |  |  |  |  |  |  |  |  |  | Date | Units | Price | Average Price | Market Price | Profit/Loss
 |  |  |  |  |  |  |  |  |  | 2021-03-05 00:00:00 | 3 | 2040
 |  |  |  |  |  |  |  |  |  | 2021-03-06 00:00:00 | 1 | 2030
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2200
Spreadsheet: 96732d1296049119-stuck-lookup-help-tcc-new-final-left
Sheet: wk12

Tuesday
06:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank | Name | Night
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points |  | 1
1 |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  | 4
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
5 |  |  |  |  |  |  | 6
7 |  |  |  |  |  |  | 8
07:20:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
9 |  |  |  |  |  |  | 10
11 |  |  |  |  |  |  | 12
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
13 |  |  |  |  |  |  | 14
15 |  |  |  |  |  |  | 16
08:40:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
17 |  |  |  |  |  |  | 18
19 |  |  |  |  |  |  | 20
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
21 |  |  |  |  |  |  | 22
23 |  |  |  |  |  |  | 24
Wednesday
06:00:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
25 |  |  |  |  |  |  | 26
27 |  |  |  |  |  |  | 28
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
29 |  |  |  |  |  |  | 30
31 |  |  |  |  |  |  | 32
07:20:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
33 |  |  |  |  |  |  | 34
35 |  |  |  |  |  |  | 36
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
37 |  |  |  |  |  |  | 38
39 |  |  |  |  |  |  | 40
08:40:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
41 |  |  |  |  |  |  | 42
43 |  |  |  |  |  |  | 44
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
45 |  |  |  |  |  |  | 46
47 |  |  |  |  |  |  | 48
Thursday
06:00:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
49 |  |  |  |  |  |  | 50
51 |  |  |  |  |  |  | 52
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
53 |  |  |  |  |  |  | 54
55 |  |  |  |  |  |  | 56
07:20:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
57 |  |  |  |  |  |  | 58
59 |  |  |  |  |  |  | 60
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
61 |  |  |  |  |  |  | 62
63 |  |  |  |  |  |  | 64
08:40:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
65 |  |  |  |  |  |  | 66
67 |  |  |  |  |  |  | 68
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
69 |  |  |  |  |  |  | 70
71 |  |  |  |  |  |  | 72
Spreadsheet: 268767d1380780070-indirect-function-to-pull-desired-no-of-cells-row-data-based-on-data-validation-in-input-file1
Sheet: M3

 | Nebico Pvt.Ltd.Ktm |  | Period
SN | Name of Product | Type of Scheme | From | To | Minimum Sales Qty | Scheme given on sales per carton(in Rs)
1 | Jackpot | A | 2013-07-16 00:00:00 | 2013-08-16 00:00:00 | 1 | 5
2 | Bonbon New | A | 2013-07-16 00:00:00 | 2013-08-16 00:00:00 | 1 | 5
1 | Jackpot | B |  | 2013-09-16 00:00:00 | 1 | 5
2 | Bonbon New | B |  | 2013-09-16 00:00:00 | 1 | 5
1 | Jackpot | C |  | 2013-10-17 00:00:00 | 1 | 5
2 | Bonbon New | C |  | 2013-10-17 00:00:00 | 1 | 5
1 | Jackpot | D |  | 2013-11-15 00:00:00 | 1 | 5
2 | Bonbon New | D |  | 2013-11-15 00:00:00 | 1 | 5
Spreadsheet: 676924d1589061679-index-match-with-3-criteria-example
Sheet: Sheet2

Bank 1 | $$ | Eur
Account A | 100 | 124
Account B | 200 | 856
Account C | 500 | 500
Account D | 570 | 400
Account E | 823 | 653
Bank 2 | $$ | Eur
Account A | 120 | 124
Account B | 200 | 300
Account C | 580 | 147
Account D | 570 | 400
Account E | 823 | 653
Bank 3 | $$ | Eur
Account A | 63 | 124
Account B | 200 | 45
Account C | 56 | 500
Account D | 220 | 400
Account E | 823 | 653
Spreadsheet: darron_c_giron__7957__midland_cogen
Sheet: firm9810

ENRON CAPITAL & TRADE RESOURCES
NETBACK AND FIRM CALCULATIONS
1998-10-01 00:00:00
IFGMR (TRKL/TX) |  |  | 1.94 |  |  | No. of Days: | 31
IFGMR (TRKL/LA) |  |  | 1.94
IFGMR (PEPL/TX/OK) |  |  | 1.9
IFGMR (ANR/LA) |  |  | 1.94
IFGMR (HENRY HUB) |  |  | 2.07
MIDLAND COGENERATION VENTURES
CONTRACT #16-60548-302 (Ultramar)
FIXED CONTRACT: | YEAR | PRICE | YEAR | PRICE
 | 1992 | 2.52 | 2001
 | 1993 | 2.4 | 2002
 | 1994 | 2.51 | 2003
 | 1995 | 2.61 | 2004
 | 1996 | 2.53 | 2005
 | 1997 | 2.65 | 2006
 | 1998 |  | 2007 | 6.37
 | 1999
 | 2000
TERM: Through year 2004 ([NAME])  with annual renewal thereafter.
MaxDQ: 8500 MMBtu/DAY
MinDQ: 60% OF MaxDQ F7,000 MMBtu/DAY | DQ for December, January, and February, 80% of MaxDQ for all other months.
MIDLAND COGENERATION VENTURES
CONTRACT #016-60548-305 (Union Pacific)
PEPL VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.45 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR(PEPL-TX/OK)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
DESIGNATED QUANTITY -PEPL |  | 5000 | MMBTU/D
ANR VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.45 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR (ANR/LA)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
[NAME] -ANR |  | 4000 | MMBTU/D
TRKL/ LA-TRKL/TX AVG  VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.45 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS AVG IFGMR (TRKL/LA)/IFGMR(TRKL/TX)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
DESIGNATED TRKL TOTAL |  | 6000 | MMBTU/D
*Customer prefers rounding to nearest penny.
Spreadsheet: 886219d1736255049-match-index-lookup-test-match
Sheet: Orders

Items | Tourniquets | [NAME] | Dressings
Client1 | 2 | 4 | 4
Cost
Client2 | 1 | 1 | 0
Cost
Client3 | 3 | 3 | 3
Cost
ITEM TOTALS
TOTAL ORDER
Spreadsheet: 199191d1355139624-how-to-link-2-columns-from-one-sheet-to-another-ef290_example12
Sheet: Hoja1

 |  | I want to calculate the difference between these numbers and connect them with the other numbers on the other sheet…
 |  |  |  |  |  | Difference
Spreadsheet: 121b6377-7e0b-40c6-8fd9-271ea4a4e931
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 | Student Payroll       STUDENT HOURLY HIRE LIST        School Year: ____________________
 | Please complete all information. |  |  |  |  | Please Circle Term:         ( Fall / Spring )         Summer
 | Business Office                             Use Only | STUDENT LEGAL NAMES                      (No Nicknames) (must match SU information) |  |  | Use Student ID #'s                      on all Payroll Forms |  |  |  |  |  | [NAME].# of Hours Per Semester
 |  | Last | First | M.I. | Student ID # | [NAME] # | New          or          Rehire | Start Date | End Date | [NAME] | Unless limited by FA Office. | Pay Code Financial Aid Use Only
 | Example: | Doe | [NAME] | L. | 1234567 | 7488 | R | 2013-08-26 00:00:00 | 2014-05-11 00:00:00 | 7.25 | 374
 |  | Fall Hours - Semester Limit (Unless limited by the Financial Aid Office) |  |  |  |  |  | 2013-08-26 00:00:00 | 2013-12-15 00:00:00 |  | 374
 |  | Spring Hours - Semester Limit (Unless limited by the Financial Aid Office) |  |  |  |  |  | 2014-01-13 00:00:00 | 2014-05-11 00:00:00 |  | 289
 |  | Summer Hours - Semester Limit (Unless limited by the Financial Aid Office) |  |  |  |  |  | 2014-05-12 00:00:00 | 2014-08-24 00:00:00 |  | 221
 | Students are never to earn over 884 total hours for the "Calendar Year".  (Financial Aid may also limit hours.)
 | Dept. [NAME] (Please Print):___________________________________________ |  |  |  |  | Ext. #__________  Dept._________________________________
 | Department Supervisor Signature:____________________________________________________ |  |  |  |  |  | Department Account   # | _____-_________-____________*
 | Authorization to sign student time sheets: (Alternate Supervisor) |  |  |  |  | *Academic Year Term: - 51830   *Summer Term: - 51835
 | Name: ______________________________ Signature: _______________________________________________
 | Date Signed: _________________________         Budget Officer Approval:___________________________________________
 | Students are never to earn over 884 total hours for the "Calendar Year".  (Financial Aid may also limit hours.)
 | **Please Complete all Information and Return This Form To The Business Office**
 | For Pay Period Calendar and other Payroll Information visit our web site:     http://www.southwestern.edu/businessoffice/
 | [NAME]
Spreadsheet: 155273d1336748827-keeping-cells-in-one-column-linked-to-cells-in-another-linking-column-issue-sample-workbook
Sheet: Team Stats

# | Team | Wins | Losses
T001 | Thunder | 5 | 1
T002 | Celtics | 3 | 3
T003 | Lakers | 2 | 4
T004 | Bulls | 6 | 0
T005 | Heat | 0 | 6
Spreadsheet: 49708d1249035305-how-to-recalculate-with-drop-down-menu-dependentdropboxes
Sheet: Sheet3

(m) |  | (N) | (O) | (P) | (Q) | (R)
values |  | Tea | Coffee | Hot Chocolate | Milkshake | Water
1000
1500
500
100
500
 | Total |  |  |  |  |  |  | this is the total  of each column
 | Grand Total
 |  | The formula in C3 now uses an INDIRECT() reference to the cell "Choice" to slip the value into an INDEX() formula.
 |  | The SUBSTITUTE() function strips out the space so the result matches one of the named ranges on Sheet2.
 |  | After that, it's essentially a INDEX/MATCH
 |  | =$A3*INDEX(INDIRECT(SUBSTITUTE(Choice," ","")),MATCH(C$2,Drinks,0))
 |  | …becomes
 |  | =$A3*INDEX(Option3,MATCH(C$2,Drinks,0))
Spreadsheet: c3494d8b-5443-4f50-bba6-f63d1becbe4f
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
B12 | Test | B12 | [NAME], Serum | [NAME], S | Immunoenzymatic Assay | Plain, Red-Top Tube: Red Serum Gel Tube: SGT |  |  | 0.6 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.6 mL | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK  Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | 180-914 ng/L | Monday through Friday; 5 a.m.-12 a.m., Saturday; 6 a.m.-6 p.m. | Same day/1 day | 3 days | 1 | 82607 |  |  |  |  | Rochester
B12 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
B12 | Result | B12 | [NAME], S | [NAME], S | Numeric |  |  |  |  | ng/L |  |  |  |  |  |  |  |  |  | 2132-9 | Cobalamins:MCnc:Pt:Ser:Qn:
Spreadsheet: 749225d1632607333-how-to-countif-abc-count-cell-a1-book1
Sheet: Sheet1

Item | Preorder Total
Swimming Pool | 12 |  | "=COUNTIFS(B:B,"TV")"
Dresser | 15
Couch | 6
TV | 8
Buyer | Item | Preorder
[NAME] | Swimming Pool | 10
[NAME] | Dresser | 5
[NAME] | Couch | 2
[NAME] | TV | 1
[NAME] | TV | 5
Morgan | Dresser | 6
Morgan | Couch | 3
Beam | Swimming Pool | 2
Beam | Dresser | 4
Beam | Couch | 1
Beam | TV | 2
Spreadsheet: 71299d1271965896-excel-2007-return-an-item-from-an-invoice-book2-1-solution
Sheet: Breeds

105 | American Cocker Spaniel | 100
110 | Welsh Springer [NAME] | 100
115 | [NAME] | 100
120 | Golden Retriever | 100
125 | German Wirehaired Pointer | 100
205 | Beagle | 200
210 | Irish Wolfhound | 200
215 | Dachshund | 200
305 | [NAME] | 300
310 | Great Dane | 300
315 | Rottweiler | 300
320 | Doberman Pinscher | 300
325 | [NAME] | 300
405 | Scottish Terrier | 400
410 | West Highland White Terrier | 400
415 | Airedale Terrier | 400
420 | [NAME] | 400
505 | Papillon | 500
510 | Chihuahua | 500
605 | Dalmation | 600
610 | [NAME] | 600
615 | Lhasa Apso | 600
620 | Bichon Frise | 600
705 | [NAME] | 700
710 | German Shepherd Dog | 700
715 | Bouvier des [NAME] | 700
Spreadsheet: 762544d1641628853-vlookup-for-multiple-criteria-vlookup
Sheet: Sheet3

Ticket Count
Month | (All)
Ticket Assignees
Count of Ticket No. |  |  | State
MUD ID | Assigned To | Category | Work In Progress | On Hold | Closed [NAME] | Closed Incomplete | Closed Skipped | Grand Total | Total Tickets Closed
[NAME] | A | Incident |  | 1 |  |  |  | 1
cb832551 | B | Request |  | 1 |  |  |  | 1
dvr95541 | C | Incident |  |  | 1 |  |  | 1
gg336016 | D | Request | 1 |  |  |  |  | 1
md891090 | E | Incident |  |  |  |  | 1 | 1
md891090 | E | Request |  |  | 1
mg104360 | F | Request |  |  | 1 |  |  | 1
nm846496 | G | Request |  |  |  | 1 |  | 1
Spreadsheet: 275487d1383545365-formula-to-check-data-by-date-test-1_-angnz
Sheet: Sheet1

 | Date |  |  | 2013-08-31 00:00:00 | 2013-09-30 00:00:00 | 2013-10-31 00:00:00 | 2014-08-31 00:00:00
 |  | Accepted Jobs
ACCEPTED JOBS |  |  | Total  Quote value |  |  | Total Accepted Quoted value
Q NO. | REP | NAME | JOB | QUOTED VALUE |  | DATE | ACCEPTED VALUE | ACCEPTED DATE | NOTES | COMMENTS FOLLOW UP | W =WON | F =Factory
Q5433 | # | # | # | 12550.66 |  | 2013-08-05 00:00:00 |  |  |  |  | W
Q5539 | # | # | # | 194398.03 |  | 2013-08-26 00:00:00 | 194398.03 |  |  |  | W
Q5545 | # | # | # | 3278.09 |  | 2013-08-30 00:00:00 | 3278.09 |  |  |  | W
Q5573 | # | # | # | 165862.08 |  | 2013-09-11 00:00:00 | 165862.08 |  |  |  | W
Q5442 | # | # | # | 96090.81 | w | 2013-10-17 00:00:00 | 96098.81 |  |  |  | w
 |  |  | #
Spreadsheet: 708097d1607614599-lookup-with-3-criteria-test-5-ans
Sheet: Sheet1

Store | Product | Qty | Part Price | Cost |  |  |  |  | Expected
1001 | 881041 |  |  |  | Note: Pl See change in D1 |  |  |  | 1001 | 881041 | 4.9 | 33.27 | 12.99
1002 | 881050
1001 | 881629
Spreadsheet: 221429d1363550027-beerfest-bracket-creation-brewfest
Sheet: Team Flags

USA
African Refugee Camp
Alaska
Bahamas
Bermuda
Canada
Colonial Americans
Confederacy
Cuba
Djibouti
Egypt
France
Greece
Holland
India
Italy
Ivory Coast
Kenya
Namibia
Naughty America
North Korea
[NAME]
Rock Nation
Sanduskyland
Scotland
Somalia
South Africa
Sweden
Switzerland
USSR
Vatican City
Zimbabwe