tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 842447d1694525485-rolling-calculation-example
Sheet: Sheet1

Region | Jul 2022 | Aug 2022 | Sep 2022 | Oct 2022 | Nov 2022 | Dec 2022 | Jan 2023 | Feb 2023 | Mar 2023 | Apr 2023 | May 2023 | June 2023 | Jul 2023 | Aug 2023 | Sep 2023 | Oct 2023 | Nov 2023 | Dec 2023 | Jan 2024 | Feb 2024 | Mar 2024 | VS Prior Month | VS PY | VS Prior 6 Months | VS Prior 12 Months
Territory 1 | 86118.63 | 126859.59 | 76883.35 | 90932.71 | 90466.84 | 69726.27 | 76280.31 | 61440.82 | 87304.35 | 108757.95 | 53716.34 | 79644.16 | 64184.87
Territory 2 | 101492.71 | 124631.16 | 146052.37 | 89587.98 | 186526.83 | 137164.76 | 122946.73 | 99532.94 | 114672.84 | 96769.05 | 136331.73 | 153595.93 | 96365.53
Territory 3 | 269984.87 | 321286.66 | 421870.74 | 269539.67 | 364012.47 | 357367.37 | 331032.84 | 325889.65 | 438793.77 | 285095.09 | 321867.97 | 402809.87 | 317118.7
Territory 4 | 25944.51 | 18335.23 | 21297.26 | 13362.16 | 26404.7 | 16105.44 | 30692.75 | 13624.44 | 35108.39 | 26654.19 | 24124.69 | 20571.13 | 40951.22
Territory 5 | 6348.53 | 2224.72 | 3927.29 | 2750.53 | 3906.02 | 5804.93 | 1670.85 | 13139.35 | 4992.88 | 6723.41 | 3932.21 | 6002.36 | 11275.43
Spreadsheet: 674404d1587822869-can-a-worksheet-create-an-image-membership-card-generator2
Sheet: Sheet1

 |  |  |  |  |  |  | FRONT OF CARD |  |  |  |  | BACK OF CARD
 |  |  |  |  |  | GIBRALTAR SCALE MODELING SOCIETY |  |  |  | The bearer of this card is a member in good
Date Issued |  | Card Generation Number |  |  |  |  |  |  |  | standing with Gibraltar Scale Modeling Society.
 |  | 1
[NAME] |  |  |  |  |  |  |  |  |  | If you have any questions regarding your membership
 |  |  |  |  |  |  | Member No. |  |  | or Society contact the Secretary  by visiting the
 |  |  |  |  |  |  |  |  |  | Society's Facebook Page:
 |  |  |  |  | Date issued |  |  | [NAME] |  | www.facebook.com/groups/1118683841524009/
Card Generation Number | Member [NAME] | Member Registration Number | Role
1 | [NAME] | 180536 | Society President
2 | [NAME] | 196125 | Society Vice President
3 | [NAME] | 205489 | Society Secretary
4 | [NAME] | 231023 | Society Vice Secretary
5 | Adrian Curtis | 257786 | Society Treasurer
6 | [NAME] | 272473 | Society Member
7 | Hector Zammit | 285241 | Society Member
8 | [NAME] | 287602 | Society Member
9 | [NAME] | 324397 | Society Member
10 | [NAME] | 347341 | Society Member
11 | [NAME] | 399843 | Society Member
12 | [NAME] | 405679 | Society Member
13 | [NAME] | 456260 | Society Member
14 |  | 467630 | Society Member
15 |  | 524290 | Society Member
16 |  | 641140 | Society Member
17 |  | 685637 | Society Member
18 |  | 770231 | Society Member
19 |  | 783541 | Society Member
20 |  | 797721 | Society Member
21 |  | 826970 | Society Member
22 |  | 869236 | Society Member
23 |  | 885738 | Society Member
24 |  | 904459 | Society Member
25 |  | 923157 | Society Member
26 |  | 974903 | Society Member
27 |  | 975745 | Society Member
Spreadsheet: 703109d1604758857-lookup-sample-file
Sheet: Sheet1

 | input |  |  | result
Instrument Number | Amount | Account No: (Optional) |  | Instrument Number | Amount | Account No: (Optional)
1246578 | 50000 | 15720311113840 |  | 1246578 | 50000 | 15720311113840
61045 | 33000 | 15720311272641 |  | 61045 | 33000 | 15720311272641
501026 | 33500 | 15720610109515 |  | 501026 | 33500 | 15720610109515
26141 | 450000 | 17620311126632 |  | 12767 | 290319 | 15720311272184
12767 | 290319 | 15720311272184 |  | 566010 | 70720 | 15720311272184
31856 | 1000 | 41220311107057
566011 | 70720 | 10620311584714
566010 | 70720 | 15720311272184
 | when I tying data its autmatically filter only -57- number record
Spreadsheet: 810466d1671789834-holiday-and-sunday-computation-formula-help
Sheet: 2

[NAME]
 | Name: |  |  |  |  |  |  |  |  |  | Personalnummer: |  |  |  |  |  |  |  |  |  |  | Eintritt:
 | Vorname: |  |  |  |  |  |  |  |  |  | Kategorie: |  |  |  |  |  |  |  |  |  |  | Austritt:
 |  |  | KZ | Arbeitszeit |  |  |  | Zimmer |  |  | [NAME] |  |  | [NAME] |  | [NAME] |  | Zimmer | [NAME] |  |  |  | Abrechnung |  |  |  |  | [NAME]
Feiertag | Tag | Datum | A/F/K/U | Von | Bis | Pause (min.) | Std. o. Pause | Standard | Suit | Dom Suit | Standard | Suit | Dom Suit | Ex.Arbeit | Spät | Ex.[NAME] | MiniBar | Zusätzlich eingeteilt | DND | Kein Service | Clean Zimmer | OS / Sonstiges | Std. Zimmer | Std. Geasmt | +/- [NAME]. | +/- Min. | [NAME] | [NAME] | [NAME]
 |  | 1900-01-01 00:00:00
 |  | 1900-01-02 00:00:00
 |  | 1900-01-03 00:00:00
 |  | 1900-01-04 00:00:00
 |  | 1900-01-05 00:00:00
 |  | 1900-01-06 00:00:00
 |  | 1900-01-07 00:00:00
 |  | 1900-01-08 00:00:00
 |  | 1900-01-09 00:00:00
 |  | 1900-01-10 00:00:00
 |  | 1900-01-11 00:00:00
 |  | 1900-01-12 00:00:00
 |  | 1900-01-13 00:00:00
 |  | 1900-01-14 00:00:00
 |  | 1900-01-15 00:00:00
 |  | 1900-01-16 00:00:00
 |  | 1900-01-17 00:00:00
 |  | 1900-01-18 00:00:00
 |  | 1900-01-19 00:00:00
 |  | 1900-01-20 00:00:00
 |  | 1900-01-21 00:00:00
 |  | 1900-01-22 00:00:00
 |  | 1900-01-23 00:00:00
 |  | 1900-01-24 00:00:00
 |  | 1900-01-25 00:00:00
 |  | 1900-01-26 00:00:00
 |  | 1900-01-27 00:00:00
 |  | 1900-01-28 00:00:00
 |  | 1900-01-29 00:00:00
 |  | 1900-01-30 00:00:00
 |  | 1900-01-31 00:00:00
Summe
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | So. zusch. | Ft. Zusch.
 |  |  | Stunden pro Zimmer |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gesamtstunden
 | Zimmer Stunden : |  |  |  |  |  |  |  |  |  | Krankheitstage : |  |  |  |  |  |  |  |  | [NAME] u. [NAME] :
 | Zimmer [NAME]  : |  |  |  |  |  |  |  |  |  | Krankheitsstunden : |  |  |  |  |  |  |  |  | [NAME] :
 | [NAME] : |  |  |  |  |  |  |  |  |  | Urlaubstage : |  |  |  |  |  |  |  |  | Feiertag :
 | [NAME] : |  |  |  |  |  |  |  |  |  | Urlaubsstunden : |  |  |  |  |  |  |  |  | [NAME] :
 | [NAME] : |  |  |  |  |  |  |  |  |  | Probetag Stunden : |  |  |  |  |  |  |  |  | Sonstiges :
Spreadsheet: 275628d1383592506-make-unique-name-list-and-sum-data-namelist-and-total
Sheet: Sheet1

Day1 |  |  | Day2 |  |  | Day3 |  |  | Day4 |  |  | Day5 |  |  | Day6 |  |  | Day7 |  |  |  | WANTED:
Name | Data1 | Data2 | Name | Data1 | Data2 | Name | Data1 | Data2 | Name | Data1 | Data2 | Name | Data1 | Data2 | Name | Data1 | Data2 | Name | Data1 | Data2 |  | UNİQUE NAME LİST | TOTAL DATA  2
a | 1 | 10 | e | 2 | 20 | a | 2 | 25 | m | 6 | 15 | c | 4 | 10 | k | 5 | 20 | a | 1 | 10 |  | a
b | 2 | 11 | f | 1 | 15 | f | 3 | 10 | n | 2 | 1 | t | 6 | 20 | p | 6 | 30 | x | 6 | 20 |  | b
c | 1 | 15 | g | 2 | 16 | j | 4 | 6 | a | 1 | 6 | u | 8 | 25 | r | 7 | 15 | t | 6 | 25 |  | c
d | 2 | 16 | a | 3 | 21 | k | 6 | 15 | h | 3 | 20 | v | 1 | 15 | s | 8 | 10 | s | 8 | 5 |  | d
e | 3 | 12 | h | 3 | 10 | l | 1 | 16 | t | 4 | 10 | a | 5 | 8 | a | 1 | 5 | z | 5 | 1 |  | e
 |  |  | x | 1 | 5 | c | 1 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | f
 |  |  |  |  |  | d | 2 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  | g
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | h
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | j
NOTES: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | k
All  This Name Data1 and Data2  columns are coming from another worksheet by formulas. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | l
So, colums are to  row 300 with formula. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | m
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | n
Wanted: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | p
In W column , to make a Unique Name List from table above |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | r
In X column , to make Total Data2 values to Unique Names |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | t
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | u
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | v
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | z
Spreadsheet: 826873d1682348746-merging-data-for-match-cases-vlookup-merge-value-vlookup
Sheet: Source

xxxx | xxxx | xxxx | Grid | Sample | xxxx | xxxx | xxxx | xxxx | xxxx | Grid Clean
 |  |  | A01
 |  |  | A02
 |  |  | B01
 |  |  | B02
 |  |  | B03 | 2375410
 |  |  | A03
 |  |  | A04
 |  |  | B04 | 2375369
 |  |  | A05
 |  |  | A06
 |  |  | B05 | 2375371
 |  |  | A07
 |  |  | A08
 |  |  | B06 | 2375409
 |  |  | A09
 |  |  | A10
 |  |  | B07 | 2375408
 |  |  | B08 | 2375408
 |  |  | A11
 |  |  | A12
 |  |  | B09 | 2375400
 |  |  | B10 | 2375389
 |  |  | B11 | 2375364
 |  |  | B12 | 2375362
 |  |  | C01 | 2375364
 |  |  | C02 | 2375364
 |  |  | C03 | 2375361
 |  |  | C04 | 2375361
 |  |  | C05
 |  |  | C06
 |  |  | C07
 |  |  | C08
 |  |  | C09
 |  |  | C10
 |  |  | C11
 |  |  | C12
 |  |  | D01
 |  |  | D02
 |  |  | D03
 |  |  | D04
 |  |  | D05
 |  |  | D06
 |  |  | D07
 |  |  | D08
 |  |  | D09
 |  |  | D10
 |  |  | D11
 |  |  | D12
 |  |  | E01
 |  |  | E02
 |  |  | E03
 |  |  | E04
 |  |  | E05
 |  |  | E06
 |  |  | [NAME]
 |  |  | E08
 |  |  | E09
 |  |  | E10
 |  |  | E11
 |  |  | E12
 |  |  | F01
 |  |  | F02
 |  |  | F03
 |  |  | F04
 |  |  | F05
 |  |  | F06
 |  |  | F07
 |  |  | F08
 |  |  | F09
 |  |  | [NAME]
 |  |  | F11
 |  |  | F12
 |  |  | G01
 |  |  | G02
 |  |  | G03
 |  |  | G04
 |  |  | G05
 |  |  | [NAME]
 |  |  | G07
 |  |  | G08
 |  |  | [NAME]
 |  |  | G10
 |  |  | G11
 |  |  | G12
 |  |  | H01
 |  |  | H02
 |  |  | H03
 |  |  | H04
 |  |  | H05
 |  |  | H06
 |  |  | H07
 |  |  | H08
 |  |  | H09
 |  |  | H10
 |  |  | H11
 |  |  | H12
Spreadsheet: darrell_schoolcraft__7322__imball0202
Sheet: Continental

 | Contintental
 | 500204 |  | 500205
Day | Measured | Scheduled | Measured | Scheduled
1 |  |  |  | 65
2 |  |  |  | 65
3 |  |  |  | 65
4 |  |  |  | 33
5 |  |  |  | 65
6
7 |  |  |  | 135
8 |  |  |  | 135
9 |  |  |  | 135
10 |  |  |  | 135
11 |  |  |  | 135
12 |  |  |  | 135
13 |  |  |  | 135
14 |  |  |  | 135
15 |  |  |  | 135
16 |  |  |  | 135
17 |  |  |  | 135
18 |  |  |  | 135
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  |  |  | 42790.44
2002-02-18 00:00:00
CBS Volume
 |  |  | 4581
Spreadsheet: 4843f539-c31f-4ad3-bc25-ab25225585a2
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Schema – skolbarnsomsorg
 |  |  |  | En blankett per barn
 | Personuppgifter
 | Barnets för- och efternamn |  |  | Barnets personuppg
 | Utdelningsadress | Postnr, ortnamn |  | tfn bostaden
 | Vårdnadshavare / sammanboende
 | Namn |  |  | tfn arbetet
 | Namn |  |  | tfn arbetet
 | Fritidshemmets namn:  Montessori Friskola Gotland
 | Barnet går i förskoleklass
 | Barnet är nyplacerat, gäller fr o m....................................
 | Fast schema kan ej anges, ange antal [NAME] i genomsnitt per vecka: ………. [NAME]
 | Schemaändring, gäller fr o m...........................................
 | Lämnas minst 14 dagar före ändringen träder i kraft.
 |  | fr o m kl | t o m kl
 | Måndag
 | Tisdag
 | Onsdag
 | Torsdag
 | Fredag
 | Övriga upplysningar
 | Datum och underskrift
 |  |  |  | [NAME] till schema - skolbarnomsorg
 | Fritidsavgift
 | Vi [NAME]
 |  |  | [NAME]
 | barn 1 | 0.02 | 840
 | barn 2 | 0.01 | 420
 | barn 3 | 0.01 | 420
 | barn 4 | 0 | 0
 | Avgiften är inkomstbaserad.
 | [NAME] i barnomsorg (såväl kommunal som enskild verksamhet)
 | är barn nr 1.
 | Som förälder betalar du avgiften i förskott  11 månader per år.
 | [NAME] månad är betalningsfri.
 | På somrarna stänger vårt fritidshem vecka 28, 29, 30 och 31
 | [NAME] behov erbjuds plats på ett annat fritidshem.
 | Avgiften betalas i förskott till bankgiro: 5007 - 0069
 | Om man börjar mitt i en månad är första avgiften reducerad.
 | Uppsägning av fritidsplats
 | [NAME] för uppsägning finns på [NAME]
 | www.montessorigotland.se
 | [NAME]: parent
 | [NAME]: anges i veckobrev
 | Uppsägningstiden träder i kraft vid kommande månadsskifte och löper en månad.
Spreadsheet: 215897d1361533206-vlookup-based-on-more-than-one-criteria-todaysample
Sheet: Sheet1

original_order_id | orderline_id | [NAME]
99858802 | 38290339 | 9780307886279
[PHONE]-6202708 | 38275851 | 9781603420358
[PHONE]-6202708 | 38275852 | 9781450582230
[PHONE]-6202708 | 38275853 | 9781934170113
[PHONE]-9380354 | 38286550 | 9781592407330
[PHONE]-3041966 | 38276169 | 9780061670121
[PHONE]-7904312 | 38276181 | 9780785160090
[PHONE]-6594713 | 38286999 | 9781421550619
[PHONE]-4106718 | 38276533 | 9781592407330
[PHONE]-7537932 | 38287286 | 9781592407330
[PHONE]-3959558 | 38276747 | 9781592407330
[PHONE]-3110712 | 38271582 | 9780688109905
[PHONE]-3110712 | 38271583 | 9781849392662
[PHONE]-3110712 | 38271584 | 9780061236273
[PHONE]-3110712 | 38271585 | 9780395968871
[PHONE]-8278745 | 38276910 | 9781421520025
[PHONE]-8278745 | 38276911 | 9781612622767
[PHONE]-7914724 | 38296858 | 9780807068793
[PHONE]-9231554 | 38277039 | 9781891369902
[PHONE]-9231554 | 38277040 | 9780984762514
[PHONE]-1246769 | 38277320 | 9780307595836
[PHONE]-1307512 | 38287967 | 9780785162926
BDA-076-[PHONE] | 38279784 | 9781592407330
BDA-107-[PHONE] | 38281778 | 9781416509769
BDA-272-[PHONE] | 38291810 | 9780316085298
BDA-272-[PHONE] | 38291811 | 9781442436152
BDA-272-[PHONE] | 38291812 | 9781597073011
BDA-272-[PHONE] | 38291813 | 9781597072922
BDA-272-[PHONE] | 38291814 | 9781597073202
BDA-272-[PHONE] | 38464146 | 9781597073813
BDA-298-[PHONE] | 38297809 | 9780385619226
BDA-298-[PHONE] | 38297810 | 9780778313908
BDA-298-[PHONE] | 38297811 | 9781444765502
[NAME] | 38297842 | 9781849701969
[NAME] | 38297843 | 9781849703475
BDA-461-[PHONE] | 38290914 | 9780312937669
BDA-461-[PHONE] | 38290915 | 9781416577607
BDA-504-[PHONE] | 38211826 | 9781904633464
BDA-504-[PHONE] | 38211827 | 9780446310789
BDA-504-[PHONE] | 38211828 | 9780140623239
BDA-504-[PHONE] | 38211829 | 9780762445264
Spreadsheet: 349317d1412275721-track-purchase-orders-for-multiple-locations-book1-ndm
Sheet: Sheet1

Date | Store ID | Order # | Item # | Description | Unit Cost | Quatitity | Total
2014-01-01 00:00:00 | 123 | 100 | 1497D | Tennis Shoes size 5 | 15 | 3
2014-01-01 00:00:00 | 101 | 35 | 900ABB | Sweat Shirts | 5 | 50
Spreadsheet: 130184d1322115561-how-to-use-if-formula-for-change-price-copy-of-december
Sheet: 14

 |  |  |  | 2011-12-14 00:00:00
Newspaper | Price | Quantity | Total
Value | 0.88 |  | 0
Value1 | 0.98 |  | 0
Value2 | 1.22 |  | 0
Value3 | 1.22 |  | 0
Value4 | 0.83 |  | 0
Value5 | 1.01 |  | 0
Value6 | 1.03 |  | 0
Value7 | 1.01 |  | 0
Value8 | 0.8 |  | 0
Value9 | 1.04 |  | 0
Value10 | 1.04 |  | 0
Value11 | 1.04 |  | 0
Total |  |  | 0
 | Grand Total |  | 0
Spreadsheet: 51e1e9b5-0141-4de6-b2b4-76db48f78577
Sheet: Sheet1

electronica 2010 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (28 Entries):
 | 12 Assemblies and subsystems 12.1 Assemblies for control applications
No. | Company | Country | City | [NAME] | Hall/Booth
1 | ABATEC Electronic AG | Austria | Regau | 4844 | B1.650
2 | Anylink Systems AG | Germany | Ingolstadt | 85055 | A4.375
3 | Asia Pacific CIS Thailand Co. Ltd. | Thailand | Ayutthaya | 13210 | B1.443/3
4 | Benchmark Drives GmbH | Germany | [NAME] am Main | 63791 | B2.474
5 | Brüel & Kjaer GmbH | Germany | Bremen | 28359 | A1.467
6 | cms electronics gmbh | Austria | Klagenfurt am Wörthersee | 9020 | A6.420
7 | ebm-papst St. Georgen GmbH & Co.[NAME] | Germany | St. Georgen | 78112 | A2.261
8 | Elma Trenew Electronic GmbH | Germany | [NAME] | 75179 | A2.175
9 | GMK electronic design GmbH | Germany | Wernberg-Köblitz | 92533 | B5.252
10 | Hokami CZ, s.r.o. | Czech Republic | Liberec | 460 08 | B5.133/2
11 | [NAME] und [NAME] | Germany | München | 81549 | A2.239
12 | Marquardt Mechatronik GmbH | Germany | Rietheim-Weilheim | 78604 | B5.461
13 | MEV Elektronik Service GmbH | Germany | Hilter | 49176 | A4.260
14 | MSL Circuits | France | [NAME] | 45130 | B1.349
15 | Georg Schlegel GmbH & Co. [NAME]Elektrotechnische [NAME] | Germany | Dürmentingen | 88525 | B5.472
16 | SE Spezial-Electronic AG Design Driven Distribution ACTIVEs | PASSIVEs | EMECHs | Germany | Bückeburg | 31675 | A4.550
17 | SGS Tekniks Mfg. Pvt Ltd. | India | Gurgaon | 122001 | B1.275/1
18 | [NAME] | Switzerland | Sonceboz | 2605 | A2.321
19 | [NAME] und Akustik GmbH Dresden | Germany | Dresden | 01217 | A2.330
20 | TEFAG Elektronik AG | Switzerland | Mels | 8887 | B5.373
21 | Tesla Blatna, a.s. | Czech Republic | Blatna | 388 15 | B5.137/4
22 | Tremba GmbH Komponenten & Service | Germany | Neufahrn | 85375 | A1.657
23 | Trinamic Motion Control GmbH & Co.[NAME] | Germany | Hamburg | 20357 | A4.515
24 | [NAME] (M) Sdn. | Malaysia | [NAME] | 13600 | A4.406
25 | VX Instruments GmbH | Germany | Landshut-Altdorf | 84032 | A1.639
26 | WAGO Kontakttechnik GmbH & Co. [NAME] | Germany | Minden | 32423 | B4.606
27 | Westline Electronic Engineering | France | Le Mesnil-le-Roi | 78600 | B6.135/4
28 | [NAME] (Hong Kong) Automation Technology Co Ltd | Hong Kong | Mongkok, Kowloon |  | A1.175/4
Spreadsheet: 840512d1692790657-help-request-for-unconventional-issue-production-example
Sheet: Chronological

M | A | C/L | V | W | Rpr | Material | Customer Name |  | Received | LOC | B | K | PROJECT | SS/PL | MAT    REC | RDY | 23 | 0.25 | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ORD
 |  |  |  | 1 | 1 | W | Gonfrade | Scott | 2023-06-28 00:00:00 | Wells | 1 |  | Repair | 7-6 | 7-17 | Y | 1
 |  |  | 1 |  |  | V | [NAME] | [NAME] | 2023-06-29 00:00:00 | Kbk | 1 |  | 69' 6' Guardian | 7-6 | 7-25 | Y | 1
 |  |  | 1 |  |  | V | [NAME] | [NAME] | 2023-07-05 00:00:00 | Wells |  | 1 | 8' 36" Wht Vnyl Handrail | 7-10 | 8-10 | Y | 1
 |  |  | 1 |  |  | V | Griffin | [NAME] | 2023-07-12 00:00:00 | OOB |  | 1 | 6'h to 4'h Priv Taper Panel | 4-13 |  |  | 1
 |  |  | 1 |  |  | V | Mudd | Kerry | 2023-07-14 00:00:00 | Kbk |  | 1 | 23' 5' Roman Grid | 7-20 | 8-10 | Y | 1
 | 1 |  |  |  |  | A | Ferland | Pam | 2023-07-14 00:00:00 | Ogt |  | 1 | (2) 5' x [NAME] | 7-21 |  |  | 1
 |  | 1 |  |  | 1 | C/L | Hwang | [NAME] | 2023-07-14 00:00:00 | Bid | 1 |  | Dumpster Gate Replacement |  |  |  | 1
 | 1 |  |  |  |  | A | [NAME] | [NAME] | 2023-07-17 00:00:00 | Ogt |  | 1 | Scal [NAME] |  | 7-25 | Y | 1
 |  |  | 1 |  |  | V | Chase Const. | Riverside Ln. | 2023-07-17 00:00:00 | Wells |  | 1 | 104' 6' Scal OTB | 7-21 |  |  | 1
 | 1 |  |  |  |  | A | Crowe | [NAME] | 2023-07-19 00:00:00 | [NAME] |  | 1 | 17' Blk Alum Hndrl | 7-21 |  |  | 1
 |  | 1 |  |  | 1 | C/L | Dumont | [NAME] | 2023-07-24 00:00:00 | Kit | 1 |  | 6' Blk VC Repair |  | STK |  | 1
 |  |  | 1 |  |  | V | [NAME] | Ward | 2023-07-24 00:00:00 | Yk B | 1 |  | 8', 42" Berk D-e | 7-24 | 8-1 | Y | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | No highlighting in this column indicates that materials have been received or fabricated.
 |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  | [NAME]
M | A | C/L | V | W | Rpr |  |  |  |  |  | B | K |  |  |  |  | 2 | 2 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 5 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | % | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J | E | J
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O | P | O
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B |  | B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | S |  | S
Spreadsheet: 132919d1324033250-need-help-with-an-if-forumula-bonuscalcrough
Sheet: Sheet1

Supervisor RBC Bonus Calculator
Agent Name | ABS% | Transfer % | IR% | Amount
 | 10 | 13 | 92.1
 | 10% goal | 13%goal | 92.1% goal
emp 1 | 8.6 | 9 | 100
emp 2 | 6 | 15 | 95
emp 3 | 11 | 15 | 95
emp 4 | 15 | 20 | 88
Spreadsheet: 802796d1667045772-check-if-there-is-duplicated-records-in-date-range-duplicated-in-date-range
Sheet: Sheet1

 | # | Code | Date | Error |  |  | Check if there duplicated Code in exact and before and after 2 days from the date
 | 1 | 22 | 2022-10-25 00:00:00 | Yes
 | 2 | 33 | 2022-09-10 00:00:00 | Yes
 | 3 | 33 | 2022-09-11 00:00:00 | Yes
 | 4 | 11 | 2022-01-01 00:00:00 | No
 | 5 | 22 | 2022-10-27 00:00:00 | Yes
 | 6 | 77 | 2022-01-01 00:00:00 | No
 | 7 | 99 | 2022-01-01 00:00:00 | No
 | 8 | 66 | 2022-01-01 00:00:00 | No
 | 9 | 22 | 2022-10-20 00:00:00 | No
 | 10 | 88 | 2022-01-01 00:00:00 | No
Spreadsheet: 875ee3b3-1c89-4957-83ca-a97bbc79b345
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
HBIM | Test | HBIM | Hepatitis B Core Antibody, IgM, Serum | HBc IgM Ab, S | Chemiluminescence Immunoassay | Serum Gel Tube: SGT |  |  | 1 | mL | Collection Container/Tube: Serum gel Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions: Spin down and remove serum from clot.  Additional Information: Date of draw is required. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | Negative  See Viral Hepatitis Serologic Profiles in Special Instructions. | Monday through Saturday; Varies | 1 day | 2 days | 1 | 86705 |  |  |  |  | Rochester
HBIM | [NAME] | SST | Serum SST |  |  |  | Frozen
HBIM | Result | HBIM | HBc IgM Ab, S | HBc IgM Ab, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31204-1 | Hepatitis B virus core [NAME].IgM:ACnc:Pt:Ser:Ord:
Spreadsheet: 126926d1320066074-pivot-table-to-count-dates-from-two-columns-milestone-measurement-rev-03_jpr73
Sheet: Sheet2

 | Values
Row Labels | Count of Project Managers Target (a) P1 | Count of Project Managers Target (a) P1_2
Jan | 24 | 24
Feb | 48 | 24
Mar | 69 | 21
Apr | 89 | 20
May | 108 | 19
Jun | 122 | 14
Jul | 138 | 16
Aug | 149 | 11
Sep | 166 | 17
Oct | 184 | 18
Nov | 207 | 23
Dec | 232 | 25
Row Labels | Count of Project Managers Target (a) P1
[NAME]
Jan | 15
Feb | 38
Mar | 59
Apr | 79
May | 96
Jun | 106
Jul | 115
Aug | 116
Sep | 119
Oct | 123
Nov | 130
Dec | 144
Grand Total
Row Labels | Count of Project Managers Target (a) P1
[NAME]
Jan | 9
Feb | 10
Jul | 13
Aug | 17
Sep | 21
Oct | 31
Nov | 39
Dec | 48
Grand Total
Row Labels | Count of Project Managers Target (a) P1
Nick
May | 2
Jun | 6
Jul | 10
Aug | 16
Sep | 26
Oct | 30
Nov | 38
Dec | 40
Grand Total
Spreadsheet: 825234d1681205267-dynamic-inventory-calculation-based-on-demand-and-goods-to-be-expired-demand-plan_inventory
Sheet: Sheet1

Starting Inventory | 2000
 |  | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00
 | Demand | 33 | 700 | 26 | 39 | 65 | 129 | 147 | 222 | 233 | 309 | 321 | 400
 | Cumulative Demand
 | [NAME] | 0 | 0 | 0 | 0 | 500 | 0 | 0 | 1000 | 0 | 0 | 1000 | 0
 | Inventory
Spreadsheet: 853402d1703261988-allow-excel-to-read-a-rounded-number-as-a-whole-number-in-a-table-round-up-error-in-lookup-table
Sheet: Sheet1

Mathematics |  |  |  |  | School xx
Subject | UK  Years | Result |  |  | Mathematics
Phase 2  Pr imary | 1 | 4 |  |  | Attainment
 | 2 | 2 |  | Phase 2
 | 3 | 4 |  | Phase 3 |  | Good
 | 4 | 3 |  | Phase 4 |  | Weak
 | 5 | 2
 | 6 | 2 |  | Overall |  | Acceptable
Phase 3 Secondary | 7 | 4
 | 8 | 2 |  |  | 1 | Very Weak
 | 9 | 4 |  |  | 2 | Weak
 | 10 | 6 |  |  | 3 | Acceptable
 | 11 | 5 |  |  | 4 | Good
Phase 4 Post 16 | 12 | 3 |  |  | 5 | Very Good
 | 13 | 1 |  |  | 6 | Outstanding