tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: darron_c_giron__7977__midland_cogen
Sheet: firm9801

ENRON CAPITAL & TRADE RESOURCES
NETBACK AND FIRM CALCULATIONS
1998-01-01 00:00:00
IFGMR (TRKL/TX) |  |  | 2.15 |  |  | No. of Days: | 31
IFGMR (TRKL/LA) |  |  | 2.16
IFGMR (PEPL/TX/OK) |  |  | 2.15
IFGMR (ANR/LA) |  |  | 2.17
IFGMR (HENRY HUB) |  |  | 2.27
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: 793182d1661350528-creating-a-results-list-of-multiple-races-finn-resultaten-2022
Sheet: 10 juli

 | Lange afstand
 |  | Place | sailnumber | points | points overall
 |  | 1 | 250 | 1 | 6
 |  | 2 | 19 | 2 | 5
 |  | 3 | 220 | 3 | 4
 |  | 4 | 222 | 4 | 3
 |  | 5 | 1015 | 5 | 2
 |  | 6 | 1013 | 6 | 1
Spreadsheet: fe875949-827b-46ba-998f-5cea84454d0b
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
BOV | Test | BOV | [NAME], IgE | [NAME], 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
BOV | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
BOV | Result | BOV | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 10922-3
Spreadsheet: sally_beck__35413__Financial Settlements Key personnel
Sheet: Sheet1

Financial Settlements |  |  |  | must keep
1 | Blay-Smith | [NAME] |  | *
2 | Bosse | [NAME] |  | *
3 | [NAME] | Mechelle |  | *
4 | Tackett | Scott |  | *
5 | Gosnell | Geralynn |  | *
7 | Amerson | Innocetta
8 | [NAME] | [NAME]
9 | Dahanayake | Hiran
10 | Dawson | [NAME]
11 | Lakes | Beverly
12 | Martinez | Norma
13 | Pena | Yolanda
14 | Shoup | [NAME]
15 | Summers | Nichole
Spreadsheet: 104259d1301916997-simple-sumproduct-help-i-think-sumpr_help
Sheet: Summary

 | Test | Qty | Diff | P
2010-10-31 00:00:00
 | TEST3 | 4934 | 2.3 | 2010-12-01 00:00:00
 | TEST3 | 89708 | 2.3 | 2010-12-01 00:00:00
Spreadsheet: 770135d1645822840-sums-of-dynamic-unique-values-with-multiple-criteria-sample-tests
Sheet: combo box

Year |  |  |  |  |  | Negative bugs | Positive bugs |  | Negative bugs | Positive bugs
Type |  |  |  |  |  | Citrobacter freundii | Group B Strep |  | Citrobacter freundii |  | Group B Strep
 |  |  |  |  |  | E. coli | MRSA |  | E. coli |  | MRSA
 |  |  |  |  |  | Enterobacter cloacae complex | MSSA |  | Enterobacter cloacae complex |  | MSSA
 |  |  |  |  |  | Klebsiella aerogenes | Staphylococcus aureus |  | Klebsiella aerogenes |  | Staphylococcus aureus
 |  |  |  |  |  | Klebsiella pneumoniae |  |  | Klebsiella pneumoniae |  | 0
 |  |  |  |  |  | Morganella morganii |  |  | Morganella morganii |  | 0
 |  |  |  |  |  | Proteus mirabilis |  |  | Proteus mirabilis |  | 0
Spreadsheet: 740428d1626340073-using-index-match-to-return-values-in-ascending-order-index-match-example-_sort
Sheet: Company

 | Example |  |  |  |  |  |  | Actual Result - Branch 1 |  |  |  |  | Actual Result - Branch 2 |  |  |  |  | Actual Result - Branch 3
 | Customer No. | Customer Name | Inv. No. | Ref. No. |  | helper |  | Customer No. | Customer Name | Inv. No. | Ref. No. |  | Customer No. | Customer Name | Inv. No. | Ref. No. |  | Customer No. | Customer Name | Inv. No. | Ref. No.
 | AAA |  | 31895 | RO098789654 | Branch 1 |  |  | A |  | 45048 | H084567 |  | D |  | 1234 | C045678 |  | CD |  | 12368 | B06987
 | ABA |  | 31896 | RO0874144 | Branch 1 |  |  | C |  | 31898 | RO061558 |  | A |  | 45049 | RO06486
 | AA |  | 31897 | RO0865137 | Branch 1 |  |  | AA |  | 31897 | RO0865137
 | C |  | 31898 | RO061558 | Branch 1 |  |  | ABA |  | 31896 | RO0874144
 | A |  | 45048 | H084567 | Branch 1 |  |  | AAA |  | 31895 | RO098789654
 | A |  | 45049 | RO06486 | Branch 2
 | CD |  | 12368 | B06987 | Branch 3
 | D |  | 1234 | C045678 | Branch 2
 |  |  |  |  |  |  |  | Branch 1 |  |  |  |  | Branch 2 |  |  |  |  | Branch 3
 |  |  |  |  |  |  |  | Customer No. | Customer Name | Inv. No. | Ref. No. |  | Customer No. | Customer Name | Inv. No. | Ref. No. |  | Customer No. | Customer Name | Inv. No. | Ref. No.
Spreadsheet: 718629d1613241593-combine-if-and-sum-formula-sample
Sheet: Sheet1

Golf Event | negative |  | Golf Event | positive
 | result |  |  | result
 | hdcp |  |  | hdcp
[NAME] | -2 |  | [NAME] | 6
[NAME] | -3 |  | [NAME] | 8
[NAME] | -3 |  | [NAME] | 12
[NAME] | -4 |  | [NAME] | 14
Team Handicap: | ??? | Result ? | Team Handicap: | 4 | Result
Searching for one formula to do either calculation based on the result of the sum total.
Spreadsheet: 92001d1291681717-ranking-a-list-with-conditions-rank-with-conditions
Sheet: Sheet1

Millimetres | Inches
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Score |  |  |  | Cat | Rank #1 | Rank #2
Spreadsheet: 475652d1471390649-auto-copy-cells-to-another-sheet-test-barcode-timer-xlsx
Sheet: RICH

RICH | CLIENT START | START DATE | START TIME | CLIENT STOP | STOP DATE | STOP TIME
Rich
Rich
Rich
Rich
Rich
Rich
Rich
Rich
Rich
Rich
Rich
Rich
Rich
Rich
Rich
Rich
Rich
Rich
Rich
Rich
Rich
Rich
Rich
Rich
Spreadsheet: 301033d1393631500-filtering-problem-benchmark-demo-ndm
Sheet: Incident Categories

 | Fire Incident Code | Description | Type of Call
 | 100 | Fire, other | Fire
 | 111 |  | Fire
 | 112 |  | Fire
 | 113 |  | Fire
 | 114 |  | Fire
 | 115 |  | Fire
 | 116 |  | Fire
 | 117 |  | Fire
 | 118 |  | Fire
 | 120 |  | Fire
 | 121 |  | Fire
 | 122 |  | Fire
 | 123 |  | Fire
 | 130 |  | Fire
 | 131 |  | Fire
 | 132 |  | Fire
 | 133 |  | Fire
 | 134 |  | Fire
 | 135 |  | Fire
 | 136 |  | Fire
 | 137 |  | Fire
 | 138 |  | Fire
 | 140 |  | Fire
 | 141 |  | Fire
 | 142 |  | Fire
 | 143 |  | Fire
 | 150 |  | Fire
 | 151 |  | Fire
 | 152 |  | Fire
 | 153 |  | Fire
 | 154 |  | Fire
 | 155 |  | Fire
 | 160 |  | Fire
 | 161 |  | Fire
 | 162 |  | Fire
 | 163 |  | Fire
 | 164 |  | Fire
 | 170 |  | Fire
 | 171 |  | Fire
 | 172 |  | Fire
 | 173 |  | Fire
 | 200 |  | Fire
 | 210 |  | Fire
 | 211 |  | Fire
 | 212 |  | Fire
 | 213 |  | Fire
 | 220 |  | Fire
 | 221 |  | Fire
 | 222 |  | Fire
 | 223 |  | Fire
 | 231 |  | Fire
 | 240 |  | Fire
 | 241 |  | Fire
 | 242 |  | Fire
 | 243 |  | Fire
 | 244 |  | Fire
 | 251 |  | Fire
 | 300 |  | EMS
 | 311 |  | EMS
 | 320 |  | EMS
 | 321 |  | EMS
 | 322 |  | EMS
 | 323 |  | EMS
 | 324 |  | EMS
 | 331 |  | Fire
 | 340 |  | Fire
 | 341 |  | Fire
 | 342 |  | Fire
 | 343 |  | Fire
 | 350 |  | Fire
 | 351 |  | Fire
 | 352 |  | Fire
 | 353 |  | Fire
 | 354 |  | Fire
 | 355 |  | Fire
 | 356 |  | Fire
 | 357 |  | Fire
 | 360 |  | Fire
 | 361 |  | Fire
 | 362 |  | Fire
 | 363 |  | Fire
 | 364 |  | Fire
 | 365 |  | Fire
 | 370 |  | Fire
 | 371 |  | Fire
 | 372 |  | Fire
 | 381 |  | Fire
 | 400 |  | Fire
 | 410 |  | Fire
 | 411 |  | Fire
 | 412 |  | Fire
 | 413 |  | Fire
 | 420 |  | Fire
 | 421 |  | Fire
 | 422 |  | Fire
 | 423 |  | Fire
 | 424 |  | Fire
 | 430 |  | Fire
 | 431 |  | Fire
 | 440 |  | Fire
 | 441 |  | Fire
 | 442 |  | Fire
 | 443 |  | Fire
 | 444 |  | Fire
 | 445 |  | Fire
 | 451 |  | Fire
 | 460 |  | Fire
 | 461 |  | Fire
 | 462 |  | Fire
 | 463 |  | Fire
 | 471 |  | Fire
 | 480 |  | Fire
 | 481 |  | Fire
 | 482 |  | Fire
 | 500 |  | Fire
 | 510 |  | Fire
 | 511 |  | Fire
 | 512 |  | Fire
 | 520 |  | Fire
 | 521 |  | Fire
 | 522 |  | Fire
 | 531 |  | Fire
 | 540 |  | Fire
 | 541 |  | Fire
 | 542 |  | Fire
 | 550 |  | Fire
 | 551 |  | Fire
 | 552 |  | Fire
 | 553 |  | Fire
 | 554 |  | Fire
 | 555 |  | Fire
 | 561 |  | Fire
 | 571 |  | Fire
 | 600 |  | Fire
 | 611 |  | Fire
 | 621 |  | Fire
 | 622 |  | Fire
 | 631 |  | Fire
 | 632 |  | Fire
 | 641 |  | Fire
 | 650 |  | Fire
 | 651 |  | Fire
 | 652 |  | Fire
 | 653 |  | Fire
 | 661 |  | Fire
 | 671 |  | Fire
 | 672 |  | Fire
 | 700 |  | Fire
 | 710 |  | Fire
 | 711 |  | Fire
 | 712 |  | Fire
 | 713 |  | Fire
 | 714 |  | Fire
 | 715 |  | Fire
 | 721 |  | Fire
 | 730 |  | Fire
 | 731 |  | Fire
 | 732 |  | Fire
 | 733 |  | Fire
 | 734 |  | Fire
 | 735 |  | Fire
 | 736 |  | Fire
 | 740 |  | Fire
 | 741 |  | Fire
 | 742 |  | Fire
 | 743 |  | Fire
 | 744 |  | Fire
 | 745 |  | Fire
 | 746 |  | Fire
 | 751 |  | Fire
 | 800 |  | Fire
 | 811 |  | Fire
 | 812 |  | Fire
 | 813 |  | Fire
 | 814 |  | Fire
 | 815 |  | Fire
 | 900 |  | Fire
 | 911 |  | Fire
Spreadsheet: 831650d1685800408-filter-entire-list-by-sorting-2-columns-2sorting
Sheet: Ordered by

 | 1 | S |  |  | Chainsaw
 | 2 | Bh |  |  | Man of the Day
 | 3 | A |  |  | Prema
 | 4 | K |  |  | Ice Cream
 | 5 | M |  |  | Red Apple
 | 6 | P |  |  | Text1
 | 7 | Ma |  |  | [NAME]
 | 8 | F
 | 9 | Ch
 | 10 | B
Spreadsheet: 69853d1270541088-pulling-info-out-of-an-old-layout-oct-08
Sheet: 10-28-08 2nd

Daily Problem Report |  |  |  |  |  | 2nd shift |  | Date |  | 2008-10-28 00:00:00
 |  | Daily cases |  | Daily hours |  | Daily Avg Per Month |  | Note
ER |  | 8 |  | 2.5 |  | 3.6
PR |  | 4 |  |  |  | 2.4
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
ER |  | 5-1 | 51155/64-04010-T1 |  | Problem: MIS-LOCATED PART |  |  | Station:1/5 |  | 200 OF 1400 | 0
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause: | LAST PART IN STACK CAME UP CROOKED. |  |  | 7:15-7:30
 |  |  |  |  | Explain: | CLEANED DIE AND HELPED ADJUST FINGERS. |  |  |  |  | P.J.
 |  |  |  |  |  |  |  |  |  |  | support
Stamping T/L: GLEN C
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
ER |  | 5-1 | 51155/64-04010-T1 |  | Problem: O/L BURR |  |  | Station:5/5 |  | Ran:704 OF 1400 | 0.5
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause: |  |  |  | 7:55-8:20
 |  |  |  |  | Explain: | CHIPPED LOWER. WELDED AND GROUND IN. OK. NOT ENOUGH PARTS IN STORAGE. |  |  |  |  | P.J.
Stamping T/L: GLEN C
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
PR |  | 3-1 | 53731/2-08010 |  | Problem: O/L BURR |  |  | Station:4/6 |  | Ran:START OF RUN | 0
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause: | CLEARANCE WAS TO TIGHT GAULDED UPPER TRIM. |  |  | P.J.
 |  |  |  |  | Explain: | DAY SHIFT OK BURR. 2ND SHIFT QA TL VETO 'D IT. PULLED DIE. WELDED AND
 |  |  |  |  | GROUND IN UPPER. 2ND SHIFT WAS NOT GOING TO RUN IT ANY WAY. JUST GETTING  READY FOR 1ST.
Stamping T/L: SHANE R |  |  |  |  | WORK IS [NAME].
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
Misc.Notes:
Spreadsheet: 843479d1695297256-help-with-formula-for-countiifs-index-match-multiple-criteria-same-column-countif_index_match-hd_2
Sheet: Example

Headers | Values | Criteria |  | Original#
Start date | 2023-06-19 00:00:00 | Green |  |  | <------ The Countif Index Match formula matches column headers and counts the number of values in the column.
End date | 2024-09-24 00:00:00 | Red |  |  | ,[NAME],x,LET(v,OFFSET(x,,1,,COLUMNS(val)),i*((CONCAT(v)="")+ISNUMBER(XMATCH(INDEX(d,,XMATCH(x,h)),v))))))))))
Start time | 00:00:00 | Total
End time | 23:59:59
States | nv | TX
Cities
Languages | english
Cars
Planets
Animals
Vegetables
Count | 3
Expexted |  |  |  |  |  |  | [NAME]
Headers | Green | Red | Green% | Red% | Total
States
TX
NV | 3 | 0
Cities
Houston | 2 | 2
Las Vegas | 3 | 0
Languages
English | 5 | 2
Spanish | 0 | 0
French | 0 | 0
Cars
Toyota | 1 | 0
Ford | 3 | 1
Honda | 1 | 1
Planets
Earth | 3 | 1
Mars | 1 | 1
Jupiter | 1 | 0
Animals
Cat | 3 | 1
Dog | 1 | 1
Bird | 0 | 0
Hamster | 1 | 0
Vegetables
Carrots | 0 | 0
Broccoli | 1 | 0
Spinach | 4 | 0
Tomatoes | 0 | 0
Cucumbers | 1 | 0
Bell Peppers | 0 | 1
Lettuce | 0 | 0
[NAME] | 0 | 0
Count
1 | 0 | 0
2 | 0 | 0
3 | 5 | 2
4 | 0 | 0
5 | 0 | 0
6 | 0 | 0
7 | 0 | 0
None | 0 | 0
Spreadsheet: 101122d1299260502-using-mode-to-find-the-most-popular-values-not-working-normalizingdata
Sheet: Sheet1

ID# | Rx 1 | Rx 2 | Rx 3 | Rx 4
1900 | GBN | GJK | . | .
1901 | NTO | GBN | GJK | .
1902 | #N/A | #N/A | #N/A | #N/A
1903 | GBN | . | . | .
Count of Value | Total | <------- Pivot Table from Wizard using "Multiple Consolidation Ranges"
Total | 16
Spreadsheet: 101362d1299513828-excel-2007-handling-data-problem-for-climate-change-project-tempsfillin
Sheet: FillIn

Date | [NAME] |  |  |  |  |  |  | Start by putting in dates in Column A.
1980-03-01 00:00:00 |  |  | <<This is a short Example of how |  |  |  |  | Type your minimum date in A2 and pull down
1980-03-02 00:00:00 |  |  | <<To fill in Blank Temp values. |  |  |  |  | This will give you all dates
1980-03-03 00:00:00
1980-03-04 00:00:00 |  |  |  |  |  |  |  | Then look at the formula in B2
1980-03-05 00:00:00 |  |  |  |  |  |  |  | This does an Index Match for the date in A2
1980-03-06 00:00:00 |  |  |  |  |  |  |  | If it finds a value in Vostok it returns it
1980-03-07 00:00:00 |  |  |  |  |  |  |  | If no value is found it gets it from [NAME]
1980-03-08 00:00:00
1980-03-09 00:00:00 |  |  |  |  |  |  |  | The assumption is that [NAME] is the closest town to Vostok.
1980-03-10 00:00:00
1980-03-11 00:00:00
1980-03-12 00:00:00
1980-03-13 00:00:00
1980-03-14 00:00:00
1980-03-15 00:00:00
1980-03-16 00:00:00
1980-03-17 00:00:00
1980-03-18 00:00:00
1980-03-19 00:00:00
1980-03-20 00:00:00
1980-03-21 00:00:00
1980-03-22 00:00:00
1980-03-23 00:00:00
1980-03-24 00:00:00
1980-03-25 00:00:00
1980-03-26 00:00:00
1980-03-27 00:00:00
1980-03-28 00:00:00
1980-03-29 00:00:00
1980-03-30 00:00:00
1980-03-31 00:00:00
1980-04-01 00:00:00
1980-04-02 00:00:00
1980-04-03 00:00:00
Spreadsheet: 846665d1697800460-collate-data-from-another-sheet-depending-on-month-selected-in-dropdown-list-sample
Sheet: Sheet1

 |  |  |  |  |  |  |  | Monthly Report |  |  |  | April
 |  |  |  |  |  |  |  |  | Sample 1 | Sample 2 | Sample 3 | Sample 4 | Sample 5
 |  |  |  |  |  |  |  |  |  | 15 | 1 | 0 | 0.9375
 |  |  |  |  |  |  |  | Report 2 | 15 | 11 | 2 | 2 | 0.6000000000000001
 |  |  |  |  |  |  |  | Report 3 | 18 | 15 | 3 | 0 | 0.8333333333333333
 |  |  |  |  |  |  |  | Report 4 | 19 | 17 | 2 | 0 | 0.8947368421052633
 |  |  |  |  |  |  |  | Report 5 | 21 | 21 | 0 | 0 | 1
 |  |  |  |  |  |  |  | Report 6 | 14 | 11 | 3 | 0 | 0.7857142857142857
 |  |  |  |  |  |  |  | Report 7 | 20 | 14 | 3 | 3 | 0.55
 |  |  |  |  |  |  |  | Report 8 | 25 | 21 | 1 | 3 | 0.72
 |  |  |  |  |  |  |  | Report 9 | 31 | 29 | 2 | 0 | 0.9354838709677419
 |  |  |  |  |  |  |  | Report 10 | 23 | 22 | 1 | 0 | 0.9565217391304347
 |  |  |  |  |  |  |  | Report 11 | 26 | 22 | 3 | 1 | 0.8076923076923077
 |  |  |  |  |  |  |  | Report 12 | 23 | 21 | 1 | 1 | 0.8695652173913043
 |  |  |  |  |  |  |  | Report 13 | 37 | 33 | 2 | 2 | 0.8378378378378379
 |  |  |  |  |  |  |  | Report 14 | 27 | 26 | 1 | 0 | 0.9629629629629629
 |  |  |  |  |  |  |  | Report 15 | 26 | 21 | 2 | 3 | 0.6923076923076924
 |  |  |  |  |  |  |  | Report 16 | 14 | 11 | 1 | 2 | 0.6428571428571428
 |  |  |  |  |  |  |  | Report 17 | 24 | 23 | 1 | 0 | 0.9583333333333335
 |  |  |  |  |  |  |  |  | Sample 1 | Sample 2 | Sample 3 | Sample 4 | Sample 5
 |  |  |  |  |  |  |  | Report 2
 |  |  |  |  |  |  |  | Report 3
 |  |  |  |  |  |  |  | Report 4
 |  |  |  |  |  |  |  | Report 5
 |  |  |  |  |  |  |  | Report 6
 |  |  |  |  |  |  |  | Report 7
 |  |  |  |  |  |  |  | Report 8
 |  |  |  |  |  |  |  | Report 9
 |  |  |  |  |  |  |  | Report 10
 |  |  |  |  |  |  |  | Report 11
 |  |  |  |  |  |  |  | Report 12
 |  |  |  |  |  |  |  | Report 13
 |  |  |  |  |  |  |  | Report 14
 |  |  |  |  |  |  |  | Report 15
 |  |  |  |  |  |  |  | Report 16
 |  |  |  |  |  |  |  | Report 17
Spreadsheet: 0a7d1b5b-c6fa-42ad-855d-4fe6eb974e4d
Sheet: China

Export Sales | Unshipped Balance |  | Accumulated Exports |  | Total Commitments
China | this year | last year | this year | last year | this year | last year
Spreadsheet: 214220d1360848816-data-in-8-columns-should-reflect-in-8-rows-there-are-27-labes-to-be-made-with-8-rows-mohammad-ali
Sheet: Lable

Associate ID1 |  | Associate ID2 |  | Associate ID3
Associate Name |  | Associate Name |  | Associate Name
Circle |  | Circle |  | Circle
Sub Cirlcle |  | Sub Cirlcle |  | Sub Cirlcle
Location |  | Location |  | Location
URN No |  | URN No |  | URN No
Card No |  | Card No |  | Card No
Load Value |  | Load Value |  | Load Value
Associate ID |  | Associate ID |  | Associate ID
Associate Name |  | Associate Name |  | Associate Name
Circle |  | Circle |  | Circle
Sub Cirlcle |  | Sub Cirlcle |  | Sub Cirlcle
Location |  | Location |  | Location
URN No |  | URN No |  | URN No
Card No |  | Card No |  | Card No
Load Value |  | Load Value |  | Load Value
Associate ID |  | Associate ID |  | Associate ID
Associate Name |  | Associate Name |  | Associate Name
Circle |  | Circle |  | Circle
Sub Cirlcle |  | Sub Cirlcle |  | Sub Cirlcle
Location |  | Location |  | Location
URN No |  | URN No |  | URN No
Card No |  | Card No |  | Card No
Load Value |  | Load Value |  | Load Value
Associate ID |  | Associate ID |  | Associate ID
Associate Name |  | Associate Name |  | Associate Name
Circle |  | Circle |  | Circle
Sub Cirlcle |  | Sub Cirlcle |  | Sub Cirlcle
Location |  | Location |  | Location
URN No |  | URN No |  | URN No
Card No |  | Card No |  | Card No
Load Value |  | Load Value |  | Load Value
Associate ID |  | Associate ID |  | Associate ID
Associate Name |  | Associate Name |  | Associate Name
Circle |  | Circle |  | Circle
Sub Cirlcle |  | Sub Cirlcle |  | Sub Cirlcle
Location |  | Location |  | Location
URN No |  | URN No |  | URN No
Card No |  | Card No |  | Card No
Load Value |  | Load Value |  | Load Value
Associate ID |  | Associate ID |  | Associate ID
Associate Name |  | Associate Name |  | Associate Name
Circle |  | Circle |  | Circle
Sub Cirlcle |  | Sub Cirlcle |  | Sub Cirlcle
Location |  | Location |  | Location
URN No |  | URN No |  | URN No
Card No |  | Card No |  | Card No
Load Value |  | Load Value |  | Load Value
Associate ID |  | Associate ID |  | Associate ID
Associate Name |  | Associate Name |  | Associate Name
Circle |  | Circle |  | Circle
Sub Cirlcle |  | Sub Cirlcle |  | Sub Cirlcle
Location |  | Location |  | Location
URN No |  | URN No |  | URN No
Card No |  | Card No |  | Card No
Load Value |  | Load Value |  | Load Value
Associate ID |  | Associate ID |  | Associate ID
Associate Name |  | Associate Name |  | Associate Name
Circle |  | Circle |  | Circle
Sub Cirlcle |  | Sub Cirlcle |  | Sub Cirlcle
Location |  | Location |  | Location
URN No |  | URN No |  | URN No
Card No |  | Card No |  | Card No
Load Value |  | Load Value |  | Load Value
Associate ID |  | Associate ID |  | Associate ID
Associate Name |  | Associate Name |  | Associate Name
Circle |  | Circle |  | Circle
Sub Cirlcle |  | Sub Cirlcle |  | Sub Cirlcle
Location |  | Location |  | Location
URN No |  | URN No |  | URN No
Card No |  | Card No |  | Card No
Load Value |  | Load Value |  | Load Value
Spreadsheet: 57189d1257340994-late-fees-from-aged-receivable-late-fee-calculation
Sheet: Sheet1

 |  |  |  |  |  | Days to | Interest Charge
Customer ID | Customer | Invoice/CM # | Amount Due | Inv Date | Due Date | 2009-11-01 00:00:00 | 0.08
211 | Jones | 14562 | 490 | 2008-07-01 00:00:00
211 | Jones | [NAME] | 19 | 2009-01-31 00:00:00
211 | Jones | LF-8532 | 20 | 2009-02-01 00:00:00
211 | Jones | LF-8533 | 21 | 2009-02-02 00:00:00
211 | Jones | Misc | 18.5 | 2009-02-02 00:00:00
211 | Jones
212 | Smith | 14563 | 490 | 2008-07-01 00:00:00
212 | Smith | LF-8534 | 21 | 2009-02-02 00:00:00
212 | Smith | LF-8534 | 21 | 2009-02-02 00:00:00
212 | Smith | Misc | 18.5 | 2009-02-02 00:00:00
212 | Smith
Spreadsheet: 826986d1682418440-countif-s-2-cells-need-to-match-and-then-count-if-value-in-another-book1
Sheet: Data

London | Item | Car | Sent
Canada | Item | Truck
US | Data | Utility | Sent
London | Data | Truck
London | Item | Car | 2023-10-10 00:00:00
Canada | Item | Truck | 2023-10-10 00:00:00
US | Data | Utility
London | Data | Truck | Sent
London | Item | Car | Ordered
Canada | Item | Truck
US | Data | Utility | Sent
London | Data | Truck
London | Item | Car | Sent
Canada | Item | Truck
US | Data | Utility | 2023-10-10 00:00:00
London | Data | Truck | 2023-10-10 00:00:00
London | Item | Car
Canada | Item | Truck | Sent
US | Data | Utility | Ordered
London | Data | Truck | Sent
London | Item | Car
Canada | Item | Truck | Sent
US | Data | Utility
London | Data | Truck | 2023-10-10 00:00:00
Canada | Item | Truck | 45209
US | Data | Utility
London | Data | Truck | Sent
US | Data | Utility | Ordered