tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0eae1fe3-caa9-4502-8434-c047256ebdce
Sheet: Sheet1

Last | First | District | Room | Phone | COS | LD
[NAME] | [NAME] | CA-43 | 2245 Rayburn | 225-6161 | [EMAIL] | [EMAIL]
Barrow | [NAME] | GA-12 | 213 Cannon | 225-2823 | [EMAIL] | [EMAIL]
Boswell | Leonard | IA-03 | 1427 Longworth | 225-3806 | [EMAIL] | [EMAIL]
Bright | [NAME] | AL-02 | 1205 Longworth | 225-2901 | [EMAIL] | [EMAIL]
[NAME] | Dennis | CA-18 | 1224 Longworth | 225-6131 | [EMAIL] | [EMAIL]
Childers | Travis | MS-01 | 1708 Longworth | 225-4306 | [EMAIL] | [EMAIL]
Costa | [NAME] | CA-20 | 1314 Longworth | 225-3341 | [EMAIL] | [EMAIL]
Cuellar | [NAME] | TX-28 | 336 Cannon | 225-1640 | [EMAIL] | [EMAIL]
Dahlkemper | Kathy | PA-3 | 516 Cannon | 225-5406 | [EMAIL] | [EMAIL]
Donnelly | [NAME] | IN-02 | 1530 Longworth | 225-3915 | [EMAIL] | [EMAIL]
Ellsworth | [NAME] | IN-08 | 513 Cannon | 225-4636 | [EMAIL] | [EMAIL]
[NAME] | [NAME] | TN-06 | 2306 Rayburn | 225-4231 | [EMAIL] | [EMAIL]
Harman | [NAME] | CA-36 | 2400 Rayburn | 225-8220 | [EMAIL] | [EMAIL]
[NAME] | [NAME] | SD-AL | 331 Cannon | 225-2801 | [EMAIL] (DCOS) | [EMAIL]
Hill | Baron | IN-09 | 223 Cannon | 225-5315 | [EMAIL] | [EMAIL]
Holden | [NAME] | PA-17 | 2417 Rayburn | 225-5546 | [EMAIL] | [EMAIL]
Kratovil | [NAME] | MD-01 | 314 Cannon | 225-5311 | [EMAIL] | [EMAIL]
[NAME] | [NAME] | GA-08 | 504 Cannon | 225-6531 | [EMAIL] | [EMAIL]
[NAME] | [NAME] | UT-02 | 2434 Rayburn | 225-3011 | [EMAIL] | [EMAIL]
[NAME] | [NAME] | [NAME] | 2437 Rayburn | 225-2731 | [EMAIL] | [EMAIL]
Minnick | [NAME] | ID-01 | 1517 Longworth | 225-6611 | [EMAIL] | [EMAIL]
Moore | Dennis | KS-03 | 1727 Longworth | 225-2865 | [EMAIL] | [EMAIL]
[NAME] | Collin | MN-07 | 2211 Rayburn | 225-2165 | [EMAIL] | [EMAIL]
Pomeroy | [NAME] | ND-AL | 1501 Longworth | 225-2611 | [EMAIL] | [EMAIL]
[NAME] | [NAME] | AR-04 | 2436 Rayburn | 225-0798 | [EMAIL] | [EMAIL]
Scott | [NAME] | [NAME] | 225 Cannon | 225-2939 | [EMAIL] | [EMAIL]
Shuler | Heath | NC-11 | 422 Cannon | 225-6401 | [EMAIL] | [EMAIL]
Space | Zack | OH-18 | 315 Cannon | 225-6265 | [EMAIL] | [EMAIL]; [EMAIL]
Wilson | [NAME] | OH-06 | 226 Cannon | 225-5705 | [EMAIL] | [EMAIL]
Spreadsheet: 453375d1459286786-sumif-possible-sumproduct-sum-product-test-workbook
Sheet: Sheet1

 |  |  |  |  |  |  |  | ID | DEPARTMENT | REGION | TOTAL
 | Department | 1 | 3 | 4 |  |  |  | 1001 | 1 | 1 | 4300
 | Region | 1 | 2 | 6 |  |  |  | 1001 | 1 | 1 | 1000
 |  |  |  |  |  |  |  | 1002 | 1 | 1 | 5200
 | ID | TOTALS NEEDED |  |  |  |  |  | 1003 | 2 | 3 | 600
 | 1001 |  |  |  |  |  |  | 1003 | 2 | 4 | 3200
 |  |  |  |  |  |  |  | 1003 | 2 | 5 | 4000
 | 1003 |  |  |  |  |  |  | 1003 | 2 | 6 | 5600
 | 1004 |  |  |  |  |  |  | 1003 | 3 | 1 | 5700
 |  |  |  |  |  |  |  | 1003 | 3 | 1 | 9800
 |  |  |  |  |  |  |  | 1004 | 3 | 2 | 7800
 |  |  |  |  |  |  |  | 1004 | 4 | 1 | 5000
 |  |  |  |  |  |  |  | 1004 | 4 | 5 | 3600
 |  |  |  |  |  |  |  | 1004 | 4 | 5 | 6200
 |  |  |  |  |  |  |  | 1004 | 4 | 6 | 1000
 |  |  |  |  |  |  |  |  |  | Total needed
Spreadsheet: 32099d1228223951-re_ordering-cells-help-i_got
Sheet: Sheet1

 | 1
CamPos | 8951.613281 | 608.357666 | 858.072937
CamH | -55.3807
CamP | -4.67577
CamB | -0.0484182
SunDir | -180 | 0
Zoom | 2.4
FRend
 | 2
CamPos | 8941.80957 | 614.679749 | 857.285522
CamH | -55.459
CamP | -4.65108
CamB | -0.0963516
SunDir | -180 | 0
Zoom | 2.4
FRend
Spreadsheet: 45793d1244585191-ranking-the-data-perfectly-student-grades_2003
Sheet: Sheet1

 | NAMES | 1ST TEST | 2ND TEST | 3RD TEST | FINAL MARKS
 | [NAME] | 80 | 70 | 72 | 74
 | Vicky | 70 | 75 | 85 | 76.66666666666667
 | [NAME] | 75 | 80 | 88 | 81
 | Mark | 85 | 96 | 90 | 90.33333333333333
 | Sue | 95 | 90 | 92 | 92.33333333333333
 | Vito | 88 | 90 | 92 | 90
 | [NAME] | 92 | 85 | 95 | 90.66666666666667
 | [NAME] | 90 | 94 | 96 | 93.33333333333333
Spreadsheet: jeff_dasovich__14150__Historical and Forward 122200 Prices
Sheet: Hydro Chart

 |  | [NAME] Production
 |  | (Percent of Historical Normal)
 |  | Year | Pacific Northwest | California
 |  | 2001 (projected) | 75% - 85% | less than 90%
 |  | 2000 | 0.93 | 0.94
 |  | 1999 | 1.16 | 1.08
 |  | 1998 | 0.98 | 1.53
 |  | 1997 | 1.52 | 0.84
 |  | 1996 | 1.38 | 1.29
Spreadsheet: 184172d1349172917-calculating-the-number-of-days-example-ss_rev_b
Sheet: Sheet2

Route | Exercise | Type | Day | Month | Wk | Distance (Miles) | Time (mins sec) | Run No. This Year TOTAL | Days Since Last Run | Total Weeks Run Miles | Cycle No. This Year TOTAL | Days Since Last Cycle | Total Weeks Cycle Miles
Track 2x500m, 3x1k, 2x500m | Run | Reps | 2012-09-25 00:00:00 | 2012-09-25 00:00:00 | 39 | 4.97 | 35.11 | 1 | 7 | 31.3 |  |  | 31.57
Torquay-Newton Abbot | Cycle | Ride | 2012-09-22 00:00:00 | 2012-09-22 00:00:00 | 38 | 14.03 | 67.12 |  |  |  | 1 | 10
Track Pyramid | Run | Reps | 2012-09-20 00:00:00 | 2012-09-20 00:00:00 | 38 | 5.64 | 49.4 | 1 | 12
Track 2x1 mile, 3x800m, 4x400m | Run | Reps | 2012-09-18 00:00:00 | 2012-09-18 00:00:00 | 38 | 6.17 | 49.36 | 1 | 14
Home-Paignton | Cycle | Ride | 2012-09-17 00:00:00 | 2012-09-17 00:00:00 | 38 | 12.32 | 45.12 |  |  |  | 1 | 15
[NAME] | Run | Run | 2012-09-16 00:00:00 | 2012-09-16 00:00:00 | 37 | 14.52 | 117.18 | 1 | 16
[NAME] | Cycle | Ride | 2012-09-14 00:00:00 | 2012-09-14 00:00:00 | 37 | 5.22 | 36.45 |  |  |  | 1 | 18
The Columns in Yellow will up-date
Automatically as you enter a date on the
next line.
Spreadsheet: e8d53abb-3ca8-451d-b13d-7f344081a42f
Sheet: Seite1

Hochschule für [NAME]
Hofstallstr. 6-8, 97070 Würzburg, [NAME].: 0931/32187-0, Fax: 0931/32187-2800
 |  |  |  |  | Lieferanschrift:
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Verwaltung, [NAME].:
 |  |  |  |  |  | Hofstallstr. 6-8
 |  |  |  |  |  | Ebracher Gasse 1 (Bibrastrasse)
 |  |  |  |  |  | [NAME]. 13
 |  |  |  |  |  | 97070 Würzburg
 |  | Unsere Bestell-/Kundennummernummer |  |  | Unsere Buchungskennzeichen |  |  | Würzburg
 |  | ..
Bestellung |  |  |  |  |  |  |  | Seite 1
Menge | Gegenstand |  |  |  |  |  | Preis/Einheit € | Gesamtpreis €
Aufragsbedingungen: |  |  |  |  |  | Übertrag/Zwischensumme:
 |  |  |  |  |  | Summen Seite 2 und weitere
Preis lt. [NAME] |  |  |  |  |  | MwSt: | 0.19
[NAME] frei [NAME] bis: |  |  |  |  |  | Zwischensumme:
 |  |  |  |  |  | Verpackung / Porto
 |  |  |  |  |  | Summe:
 |  |  |  |  |  | Skonto: | 0
 |  |  |  |  |  | Gesamtsumme:
Besteller (Name)
 | Name, Unterschrift |  |  | Ref. Haushalt |  |  | Die Kanzlerin
Name der FG /Org.-einheit
Leiter FG /Org.-einheit
 | Name, Unterschrift |  |  | Hr. Streitenberger |  |  | Dr. Stumpf-Wirths
Spreadsheet: 885269d1734722927-multiple-sumifs-book22-pivot-table-bvj-
Sheet: Pivot Table 2

Vendor | All
Weights by Year | Months
Years | Jan | Feb | Mar | May | Jun | Oct | Nov | Dec | Grand Total
2020 |  | 978 |  |  |  | 6862 | 1411 |  | 9251
2021 |  |  | 599 |  |  | 1974 | 1680 | 771 | 5024
2022 | 8777 |  |  |  |  |  |  |  | 8777
2023 |  |  |  | 815 | 1400 |  | 1040 | 1618 | 4873
2024 | 1083 | 6056 |  |  |  |  | 860 | 3419 | 11418
Grand Total | 9860 | 7034 | 599 | 815 | 1400 | 8836 | 4991 | 5808 | 39343
Spreadsheet: 83388d1283367301-excel-2007-adding-multiple-data-labels-chart
Sheet: Sheet2

1 | 20 | A
2 | 19 | A
3 | 16 | A
4 | 16 | A
5 | 27 | A
1 | 7 | B
2 | 15 | B
3 | 22 | B
4 | 16 | B
5 | 4 | B
Spreadsheet: 185879d1349869820-stop-age-when-closed-date-entered-test-oct-2012-v1
Sheet: Database

 |  | Attendance (Attending,     On-Hold, Cancelled) |  |  |  |  | Date of Birth | Age:                                                            A closed date in column Y must be entered if the client has left the service. This will ensure their date of age stays at the age they left. If no closed date is entered the age will show as [NAME] | Age Range: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Closed Date    (When client left service)
 |  | Cancelled |  |  |  |  | 1926-10-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-02 00:00:00
 |  | Cancelled |  |  |  |  | 1926-10-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-02 00:00:00
Spreadsheet: 271258d1381874717-pulling-pricing-formula-book2
Sheet: Sheet1

1 | t | 2
2 | u | 3
3 | v | 5
4 | w | 7
5 | x | 1
6 | y | 4
7 | z | 6
Spreadsheet: 549635d1511848189-conditional-formatting-date-cf-a-row-based-on-cell-of-today
Sheet: Sheet1

Date
 |  |  |  |  | Press F9 a few tunes to change dates and Today will go green.
 |  |  |  |  | Look at the Conditional Formatting to see this example.
Spreadsheet: 883973d1732799154-lambda-and-xlookup-issue-excel-sumif-let-riddle-thunks
Sheet: Sheet1

Raw data |  |  |  |  |  |  |  | Named ranges
Fruits | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 |  |  | References | Name
Apples | 2229 | 2366 | 2623 | 2878 | 3001 |  |  | A3:F4 | tblData
Pears | 700 | 849 | 1140 | 1294 | 1568 |  |  | A4:A14 | lstFruits
[NAME] | 0 | 0 | 0 | 0 | 0 |  |  | A18:D20 | tblBundles
Bananas | 176 | 184 | 219 | 224 | 226 |  |  | A18:A20 | lstBundles
Peaches | 7 | 8 | 9 | 10 | 10
Cherries | 296 | 207 | 205 | 217 | 222
Tomatoes | 155 | 158 | 161 | 164 | 168
Dates | 383 | 390 | 397 | 444 | 451
Nuts | 0 | 23 | 46 | 35 | 89
Raspberries | 4511 | 5622 | 7732 | 8966 | 11132
Strawberries | 11877 | 12088 | 15770 | 16041 | 18154
Bundles
Name | Includes |  |  |  |  |  |  |  | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00
Red | Strawberries | Raspberries | Cherries | Tomatoes |  |  |  | Red | 16839 | 18075 | 23868 | 25388 | 29676
Yellow | Pears | Apples | Peaches |  |  |  |  | Yellow | 2936 | 3223 | 3772 | 4182 | 4579
Dry | Nuts | [NAME] | Dates |  |  |  |  | Dry | 383 | 413 | 443 | 479 | 540
Reports
Bundle | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 |  | <- This solution works great enough, but I am looking to simplify it even more.
Red |  |  |  |  | =SUM(SUMIFS(B$4:B$14,lstFruits,FILTER(tblBundles,lstBundles=$A25,0)))
Yellow |  |  |  |  | Look in January data,in the list of fruits and sum if fruit is included in the bundle filtered to the bundle color.
Dry
Bundle | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 |  | <- I'd love to have a clean LET function, pass the ranges for months and bundle names to a LAMBDA function
Red |  | 18075 | 23868 |  | and spill the values in the table. I banged my head on the SUMIF only accepting ranges issue for days…
Yellow | 2936 | 3223 | 3772 |  | Can I use the same FILTER approach, and use a LAMBDA to SUM all the XLOOKUP values for each fruit?
Dry | 383 | 413 | 443 |  | I've failed so far…
Spreadsheet: 9f5ba97b-5680-4416-b0a4-e3f439266d97
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
AMOXY | Test | AMOXY | Amoxicillin, IgE | Amoxicillin, 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
AMOXY | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
AMOXY | Result | AMOXY | Amoxicillin, IgE | Amoxicillin, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6829-6 | [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 1005b0c3-9829-46c0-9592-2c0c7835afe7
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2013-11-20 09:46:28.190000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.875 | 102.625 | 102.5 | 102.375 | 102 |  | and are added to price quote
4.75 | 102.371 | 102.246 | 102.121 | 101.746
4.625 | 102.165 | 102.04 | 101.915 | 101.54 |  | Note: | Refer To Price [NAME]
4.5 | 101.791 | 101.666 | 101.541 | 101.166 |  |  | For all Price Adjs
4.375 | 100.87 | 100.745 | 100.62 | 99.995
4.25 | 100.334 | 100.209 | 100.084 | 99.459
4.125 | 99.542 | 99.417 | 99.292 | 98.667
4 | 98.555 | 98.43 | 98.305 | 97.68
3.875 | 97.528 | 97.403 | 97.278 | 96.653 |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 102.625 | 102.5 | 102.375 | 102
3.75 | 102.478 | 102.353 | 102.228 | 101.853
3.625 | 102.096 | 101.971 | 101.846 | 101.471
3.5 | 101.542 | 101.417 | 101.292 | 100.917
3.375 | 100.821 | 100.696 | 100.571 | 99.946
3.25 | 100.064 | 99.939 | 99.814 | 99.189
3.125 | 99.041 | 98.916 | 98.791 | 98.166 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2013-12-04 09:46:28.190000
30 DAY | 2013-12-19 09:46:28.190000
45 DAY | 2014-01-03 09:46:28.190000
60 DAY | 2014-01-18 09:46:28.190000
90 DAY | 2014-02-17 09:46:28.190000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 781406d1653305484-count-unique-text-by-month-book2
Sheet: Sheet1

ID | Date | W/C | Month |  | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00
0022JZ72F | 2022-03-24 00:00:00
0022JZ72F | 2022-03-24 00:00:00 |  |  | should be | 1 |  | 1 |  | 1 | 3 | 1 |  | 1 | 4 |  |  | 1
003GQ9Z2D | 2021-08-12 00:00:00
003GQ9Z2D | 2021-08-13 00:00:00
003GQ9Z2D | 2021-08-13 00:00:00
005L1VR6N | 2022-03-19 00:00:00
005L1VR6N | 2022-03-19 00:00:00
005L1VR6N | 2022-03-19 00:00:00
0062VRR0B | 2021-10-26 00:00:00
0062VRR0B | 2021-10-27 00:00:00
0062VRR0B | 2021-10-27 00:00:00
00LBX9H8S | 2022-01-09 00:00:00
00LBX9H8S | 2022-01-10 00:00:00
00LBX9H8S | 2022-01-10 00:00:00
00M80GLL9 | 2021-09-28 00:00:00
00M80GLL9 | 2021-09-28 00:00:00
00M80GLL9 | 2021-09-28 00:00:00
010H63QTQ | 2021-09-15 00:00:00
010H63QTQ | 2021-09-15 00:00:00
015659LCR | 2022-01-24 00:00:00
015659LCR | 2022-01-24 00:00:00
015659LCR | 2022-01-24 00:00:00
01Q5J536S | 2022-04-19 00:00:00
01Q5J536S | 2022-04-19 00:00:00
01Q5J536S | 2022-04-19 00:00:00
01R0Z52CR | 2022-05-06 00:00:00
01R0Z52CR | 2022-05-06 00:00:00
01R0Z52CR | 2022-05-07 00:00:00
01R0Z52CR | 2022-05-07 00:00:00
01VMPK3JR | 2021-07-03 00:00:00
01VMPK3JR | 2021-07-03 00:00:00
024MFXK0Q | 2022-03-24 00:00:00
024MFXK0Q | 2022-03-24 00:00:00
025ZNK8JJ | 2021-12-30 00:00:00
025ZNK8JJ | 2021-12-30 00:00:00
025ZNK8JJ | 2021-12-30 00:00:00
02P8X8XX4 | 2022-01-02 00:00:00
02P8X8XX4 | 2022-01-02 00:00:00
02P8X8XX4 | 2022-01-03 00:00:00
02RC3PRG1 | 2022-02-04 00:00:00
02RC3PRG1 | 2022-02-04 00:00:00
02RC3PRG1 | 2022-02-04 00:00:00
03F70RBW4 | 2021-04-25 00:00:00
03F70RBW4 | 2021-04-26 00:00:00
03KG3TM9T | 2022-03-27 00:00:00
03KG3TM9T | 2022-03-27 00:00:00
03KG3TM9T | 2022-03-27 00:00:00
03N8FB3MQ | 2021-09-28 00:00:00
03N8FB3MQ | 2021-09-29 00:00:00
Spreadsheet: 771761d1646835477-calculate-value-if-certain-conditions-met-stylist-bonuses-2019-working-v2-help-file-2
Sheet: Salons

Salons Names & Numbers |  |  | Month
Number | Name
372 | Corsicana |  | Jan
594 | CCR |  | Feb
942 | Euless |  | Mar
947 | [NAME] |  | Apr
1661 | El Campo |  | May
2546 | N Hurst |  | Jun
2676 | TMS |  | Jul
2996 | Ennis |  | Aug
4913 | [NAME] |  | Sep
4940 | Trinity |  | Oct
4943 | Stanton |  | Nov
4951 | Cooper |  | Dec
4954 | Lake Worth
4968 | [NAME]
4970 | [NAME]
5150 | GBC Sherwood
6100 | Sherwood
6118 | Stadium Park
6200 | [NAME]
6241 | N Midland
6316 | N Victoria
7144 | Thor Ranch
7173 | Cleburne
7714 | Riverview
Spreadsheet: 599037d1542825818-help-creating-a-formula-to-sum-cells-depending-on-the-text-initials-in-other-cells-work-schedule
Sheet: Sheet1

Work Order |  | Contract # | [NAME] | Man/Hours | Hours | Contractor | Total Hours | Elec-1 | Elec-2 | Elec-3 | Elec-4
4082136901 |  |  |  | 1 | 5 | Yes |  | DH | SC | BJ | ??
4082137601 |  |  |  | 2 | 10 | Yes |  | ?? | DH | DJW | ??
4082132801 |  |  |  | 2 | 8 | Yes |  | ?? | ?? | DJW
4082234401 |  |  |  | 2 | 8 | Yes |  | ?? | ?? | DJW
40821374;75;77/01 |  |  |  | 1 | 10 | Yes |  | ?? | ??
4082137301 |  |  |  | 2 | 20 | Yes |  | ?? | KW
 |  |  |  | 1 | 1
4082132701 |  |  |  | 1 | 1 | Yes |  | ?? | KW
4082132601 |  |  |  | 1 | 1 | Yes |  | ?? | KW
4082132501 |  |  |  | 1 | 1 | Yes |  | ?? | KW
4082132401 |  |  |  | 1 | 1 | Yes |  | ?? | KW
4082132301 |  |  |  | 1 | 1 | Yes |  | ?? | KW
4082132201 |  |  |  | 1 | 1 | Yes |  | ?? | KW
4082234501 |  |  |  | 1 | 1 | Yes |  | ?? | KW
4082168701 |  |  |  | 1 | 1 | Yes |  | ?? | KW
Work Order |  | Contract | [NAME] | Man/Hours | Hours | Contractor | Total Hours
4082135601 |  |  |  | 1 | 1 | Yes |  | BJ
4082135501 |  |  |  | 1 | 1 | Yes |  | BJ
4082135401 |  |  |  | 1 | 1 | Yes |  | BJ
4082135301 |  |  |  | 1 | 1 | Yes |  | BJ
Employee |  | Hours
Dean Hanover
[NAME]
Spreadsheet: darrell_schoolcraft__7321__imball0202
Sheet: PG&E

56698
Day | Measured | Scheduled
1 | -246404 | -244010
2 | -244917 | -244299
3 | -242647 | -242291
4 | -244008 | -243254
5 | -246342 | -243974
6 | -251402 | -250987
7 | -248856 | -248311
8 | -264991 | -264300
9 | -253917 | -251967
10 | -244921 | -244417
11 | -228979 | -229000
12 | -229532 | -228999
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | 28722
2002-02-12 00:00:00
CBS Dollars
 |  |  | -143669
Spreadsheet: 538811d1505838094-finding-a-point-on-a-grid-armour-trips
Sheet: North Sydney

North Sydney To: | [NAME]
Atholville, NB | 487
Dartmouth, NS | 248
Debert, NS | 200
Hantsport, NS | 282
Kentville, NS | 302
New Glasgow, NS | 158
New Minas, NS | 297
[NAME], NB | 394
Port Hawkesbury, NS ([NAME]) | 94
[NAME], NB | 388
Scoudouc, NB | 296
Sydport-Term, NS | 15
Truro, NS | 194
Valley Station, NS | 188
Spreadsheet: 58392d1258642795-pulling-multiple-and-varied-of-rows-from-one-sheet-into-another-incentive-payment-report3
Sheet: Report

October Incentive Payments - Based on Sales Invoiced in September
TM Name | TM # | Employee # | Country | Dealer Incentive | Retail Incentive | W | Total | Comments
[NAME] | 221 | 26050 | CDN | 231.648 | 0 | 0 | 231.648
[NAME] | 560 | 86007 | CDN | -189.6584499999997 | 2022 | 0 | 1832.34155
BRIAN BANK | 576 | 83050 | CDN | 62351.35949999999 | 0 | 201.60483 | 62552.96432999999
DON FRANK | 581 | 82020 | CDN | 3246.477 | 0 | 59.58939000000001 | 3306.06639
[NAME] | 343 | 28830 | CDN | 34.67 | 0 | 0 | 34.67
[NAME] | 980 | 91029 | CDN | 0 | 191368.66 | 0 | 191368.66
[NAME] | 582 | 81005 | CDN | 57.04560000000001 | 0 | 1359.77709 | 1416.82269
ABE LORMER | 456 | 18065 | CDN | 0 | 8.32125 | 0 | 8.32125
[NAME] | 584 | 29418 | CDN | 0 | 20.1432 | 72.24336000000001 | 92.38656000000002
RALPH DARK | 996 | 92050 | CDN | 0 | 512.645 | 0 | 512.645
BRADLEY PITT | 114 | 6015 | CDN | 416.77 | 0 | 0 | 416.77
ANGIE [NAME] | 333 | 60042 | CDN | 190.1699 | 0 | 0 | 190.1699
[NAME] | 894 | 8006 | US | 213 |  |  | 213
DANIEL NORTH | 841 | 8567 | US | 0 | 3646 |  | 3646
CHRIS BROWN | 848 | 28870 | US | 0 |  | 4477 | 4477
[NAME] | 867 | 1669 | US | 0 | 524 | 35 | 559
[NAME] | 845 | 29007 | US | 467 |  |  | 467
Spreadsheet: 119309d1314304443-need-your-opinion-my-sample
Sheet: M Recipe

Recipe |  |  |  | Department |  | Ingredient |  | Units |  | Cost per Unit |  | Serving Units |  | Cost per Serving |  | Meals per Serving |  | Cost per meal
M Caesar Salad |  |  |  | M Salads |  | Kos Lettuce |  |  |  |  |  |  |  |  |  | 1
M Caesar Salad |  |  |  | M Salads |  | Musgraves Parmesan Cheese |  |  |  |  |  |  |  |  |  | 1
M Caesar Salad |  |  |  | M Salads |  | Musgraves Caesar Dressing |  |  |  |  |  |  |  |  |  | 1
M Caesar Salad |  |  |  | M Salads |  | Donaghmede's Sliced Chicken Fillet 4kg Total |  |  |  |  |  |  |  |  |  | 1
M Caesar Salad |  |  |  | M Salads |  | Demi Baguette426143 |  |  |  |  |  |  |  |  |  | 1
M Caesar Salad |  |  |  | M Salads |  | [NAME] |  |  |  |  |  |  |  |  |  | 1
M Caesar Salad  Total |  |  |  | M Salads
M Baked Potato |  |  |  | M Salad Main Course |  | Donaghmede's Baked Potato Total |  |  |  |  |  | 1 |  |  |  | 1
M Baked Potato |  |  |  | M Salad Main Course |  | Donaghmede's Baby Potato Salad 5kg Total |  |  |  |  |  |  |  |  |  | 1
M Baked Potato |  |  |  | M Salad Main Course |  | Donaghmede's Tomato Chutney 2kg Total |  |  |  |  |  |  |  |  |  | 1
M Baked Potato |  |  |  | M Salad Main Course |  | [NAME] |  |  |  |  |  |  |  |  |  | 1
M Baked Potato Total |  |  |  | M Salad Main Course |  |  |  |  |  |  |  |  |  |  |  | 1
Maud's Goats Cheese |  |  |  | M Salad Main Course |  | Musgraves Feta Cheese |  |  |  |  |  |  |  |  |  | 1
Maud's Goats Cheese |  |  |  | M Salad Main Course |  | Arnotts Asparagus |  |  |  |  |  | 0.01 |  |  |  | 1
Maud's Goats Cheese |  |  |  | M Salad Main Course |  | Donaghmede's Roast Veg Salad 5kg Total |  |  |  |  |  |  |  |  |  | 1
Maud's Goats Cheese |  |  |  | M Salad Main Course |  | [NAME] |  |  |  |  |  |  |  |  |  | 1
Maud's Goats Cheese |  |  |  | M Salad Main Course |  | [NAME] |  |  |  |  |  |  |  |  |  | 1
Maud's Goats Cheese |  |  |  | M Salad Main Course |  | Donaghmede's Baby Potato Salad 5kg Total |  |  |  |  |  |  |  |  |  | 1
Maud's Goats Cheese Total |  |  |  | M Salad Main Course