tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 51725d1251357627-situational-average-dummy
Sheet: Sales Records

Date | Item | Price | Quantity | Profit
2009-08-27 00:00:00 | Apples | 0.5 | 100 | 50
2009-08-27 00:00:00 | Oranges | 0.45 | 50 | 22.5
2009-08-27 00:00:00 | Apples | 0.45 | 50 | 22.5
2009-08-28 00:00:00 | Grapes | 1 | 100 | 100
Spreadsheet: 804168d1667923272-conditional-formating-across-tabs-if-istext-contac-bonus-meeting-at-1-3-week-look-ahead-work-in-progress
Sheet: 22-011

Job # | Current Awarded Jobs | Resource | Mon | Tue | Wed | Thurs | Fri | Mon | Tue | Wed | Thurs | Fri | Mon | Tue | Wed | Thurs | Fri | Mon | Tue | Wed | Thurs | Fri | Mon | Tue | Wed | Thurs | Fri
22-011 | Operation |  | 2022-11-07 00:00:00
Captain D's Ellenwood | DEMO
 | MOBILZATION
 | [NAME] | RG
 | EROSION CONTROL
 | survey
 | testing
 | permits
 | MOT
 | barricades
 | barrier wall
 | mot sub
 | MOBILZATION
 | EARTHWORK - ROUGH GRADE
 | clearing and grubbing
 | stripping & stockpiling
 | onsite cuts
 | onsite fills
 | rock excavation
 | bld. Bulk excvation & backfill
 | bld. Pad prep |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8/24 ?
 | hauling
 | finish grading/ top soil respread
 | other earthwork
 | dewatering
 | Drilling
 | Blasting
 | Boring
 | Excavation
 | STORM
 | STORM PIPE SUBMITT
 | STORM PIPE APPROVALS
 | STORM  PIPE DELIVERY
 | STORM PIPE INSTALL
 | STORM STRUCTURES SUBMITT
 | STORM STRUCTURES APPROVALS
 | STORM STRUCTURES DELIVERED
 | STORM STRUCTURES INSTALLED
 | SANITARY SEWER
 | SANITARY PIPE SUBMIT
 | SANITARY PIPE APPROVAL
 | SANITARY  PIPE DELIVERED
 | SANITARY  PIPE INSTALLED
 | SANITARY  STRUCTURES SUBMITTAL
 | SANITARY  STRUCTURES APPROVED
 | SANITARY  STRUCTURES DELIVERED
 | SANITARY STRUCTURES INSTALLED
 | WATER
 | WATER PIPE SUBMITTAL
 | WATER PIPE APPROVAL
 | WATER LIFT STATION SUBMITTAL
 | WATER LIFT STATION APPROVAL
 | WATER QUALITY SUBMITTAL
 | WATER METER  APPROVAL
 | WATER METER  SUBMITTAL
 | UNDERGROUND DETENTION SUBMITTAL
 | FILTERRA STRUCTURES SUBMITTAL
 | PAVING
 | ASPHALT SUBMITTAL
 | ASPHALT APPROVAL
 | CONCRETE SUBMITTAL
 | CONCRETE APPROVAL
 | STRIPING SUBMITTAL
 | STRIPING APPROVAL
 | SIDEWALK
 | CURB
 | PAVING BASES
 | PARKING LOT
 | BUILDING PAD
 | [NAME]
 | erosion control | RG
 | clearing and grubbing | RG
 | stripping & stockpiling | RG
 | onsite cuts
 | onsite fills
 | rock excavation
 | bld. Bulk excvation & backfill
 | bld. Pad prep |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8/24 ?
 | hauling
 | finish grading/ top soil respread
 | other earthwork
 | dewatering
 | Drilling
 | Blasting
 | Boring
 | Excavation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-09-01 00:00:00
Spreadsheet: 165dbb7a-fcfb-475c-af87-a29dd9fe5302
Sheet: İptaller

Bakanlığımızca Yetki Belgesi İptal Edilen OSGB'ler
Belge No | Unvan | Adres | İl
8 | ARGE Araştırma ve Geliştirme [NAME] Mesleki [NAME] ve Özel [NAME]Ltd.Şti. | [NAME].Çağlayanğil Cad.[NAME]/ANTALYA | ANTALYA
10 | [NAME] [NAME]. ve Tic. Ltd. Şti. | 1042 Cad.1335 [NAME].No:8/10 A.Öveçler/ANKARA | ANKARA
23 | ORTAK Özel İşyeri [NAME] ve İş Eğitimi Hizmetleri Tic.Ltd.Şti. | 2818 [NAME].No:1 C [NAME] | İZMİR
96 | ZİRVE [NAME] ve Güvenlik Birimleri Tic.Ltd.Şti. | [NAME] YOLU CAD. HİTİT PLAZA NO:426 KAT:3 OSMANGAZİ / BURSA | BURSA
128 | [NAME] İSG [NAME]. Tic.Ltd.Şti. (Sakarya Şb.) | 1.Organize Sanayi Bölgesi Şehit Onbaşı Zekeriya Gözyuman [NAME] /SAKARYA | SAKARYA |  | mailto:[EMAIL]
18 | DETAM Danışmanlık [NAME] Mühendislik Ltd.Şti. | [NAME]. No:35 C27 Mebusevleri/ ANKARA | ANKARA |  | mailto:[EMAIL]
99 | İSTANBUL UZMAN Sağlık ve İş [NAME].[NAME] | İKİTELLİ OSB TURGUT ÖZAL CAD. NO:137 KAT:2 BAŞAKŞEHİR/İSTANBUL | İSTANBUL
180 | [NAME] ve [NAME] ve İşyeri [NAME] ve Turizm Tic. Ltd. Şti. | Peyas Mah. 270 Cad. 79.Sokak Güzel Feza Evleri Sitesi 15-A Blok Kat:1 D:2 Kayapınar/DİYARBAKIR | DİYARBAKIR |  | mailto:[EMAIL]
[NAME] Yetki Belgesi İptal Edilen OSGB'ler
108 | ORSA İş Güvenliği Çevre Mühendisliği Danışmanlık Özel [NAME] Ticaret Ltd. Şti. | Organize San. Böl. 103.cad. [NAME] | UŞAK
114 | UKM UĞUR KARAHAN MERKEZ SAĞLIK TURİZM HİZ. SAN. VE TİC LTD. ŞTİ.(Tekirdağ [NAME]) | [NAME] osmanpaşa mah. [NAME]. [NAME]. No: 3/3 Çerkezköy / TEKİRDAĞ | TEKİRDAĞ
136 | İLERİ İŞ SAĞLIĞI VE İŞ GÜVENLİĞİ ÖZEL SAĞLIK VE EĞİTİM HİZ. DANIŞMANLIK TİC. A.Ş. | Tuzla Sanayicileri OSB Melek [NAME]. Sosyal [NAME] No:7 Tuzla / İSTANBUL | İSTANBUL |  | mailto:[EMAIL]
31 | İLKEM Danışmanlık Eğitim ve Sağlık Hizmetleri Tic. Ltd. Şti. | OSB 9. CAD DİSPANSER ÜNİTESİ NO:1/C ANBAR/KAYSERİ | KAYSERİ
116 | ÖNLEM EĞİTİM VE SAĞLIK HİZMETLERİ A.Ş. | Yenikent Mahallesi Dicle [NAME] 4 Bl. No:2/D Daire:2 Gebze / KOCAELİ | KOCAELİ
169 | [NAME] ve [NAME] (İstanbul Şubesi) | [NAME] 1001. [NAME]. [NAME] | İSTANBUL
179 | [NAME] ve Güvenlik Birimi ve İstihdam Hizmetleri Ltd. Şti. | İnönü Mah. Kartal Cad. No : 48/A Ataşehir/İSTANBUL | İSTANBUL
Not: İş Sağlığı ve [NAME] Yönetmeliği'nin 20. [NAME] fıkrası gereği "Yetki belgesinin  iptali  veya  [NAME]  [NAME][NAME]  önceden  yapılan hizmet ve iş sözleşmelerinden [NAME] OSGB’ler sorumludur."
Spreadsheet: d97e4852-dcd4-4df1-bd2f-542616517fe7
Sheet: Sheet1

Cryptosporidiosis Incidence,  by Selected Demographics, Maine 2011, and by Year, Maine 2002-2011 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | Number |  | Rate*
Maine Total |  | 51 |  | 3.83981785711059
Sex
 | Male | 22 |  | 3.384287369070382
 | Female | 29 |  | 4.276497695852535
Ethnicity
 | Hispanic | 1 |  | 5.568548836173293
 | Not Hispanic | 47 |  | 3.587156453447105
 | Unknown | 3
Race
 | American Indian or [NAME] | 0 |  | 0
 | Asian, Native Hawaiian or Pacific Islander | 0 |  | 0
 | Black or African American | 0 |  | 0
 | White | 50 |  | 3.944004600286966
 | Multiple races | 0 |  | 0
 | Unknown | 1
Age Group (yrs)
 | 0-4 | 1 |  | 1.47725761895617
 | 5-14 | 6 |  | 3.965028449079123
 | 15-24 | 9 |  | 5.41682465738584
 | 25-44 | 15 |  | 4.806105676651618
 | 45-64 | 16 |  | 3.858192147614431
 | 65+ | 4 |  | 1.849984737625915
10-Year Trend
 | 2002 | 12 |  | 0.927023189485085
 | 2003 | 20 |  | 1.53170788492585
 | 2004 | 22 |  | 1.670142334084644
 | 2005 | 30 |  | 2.270138970340634
 | 2006 | 52 |  | 3.934702105216961
 | 2007 | 56 |  | 4.251419860356041
 | 2008 | 46 |  | 3.494229962870008
 | 2009 | 67 |  | 5.082299110749366
 | 2010 | 93 |  | 7.001108885310544
 | 2011 | 51 |  | 3.83981785711059
* Rate = number of cases per 100,000 population using the corresponding year census estimate as the denominator.
Spreadsheet: 52c936aa-7d56-4472-8dc8-8c340d271954
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
8014 | 30097 | [NAME] | Robinette | USA | 5455 | 00:00:00 | 00:00:00 | 00:18:45 | 00:02:35 | 00:24:54 | 1 | 00:46:15
8014 | 33082 | [NAME] | Wakat | USA | 5456 | 00:00:00 | 00:00:00 | [NAME] | 00:02:28 | 00:23:10 | 2 | 00:47:08
8014 | 64833 | [NAME] | Boyle | NZL | 5450 | 00:00:00 | 00:00:00 | 00:22:10 | 00:02:34 | 00:22:41 | 3 | 00:47:26
8014 | 64831 | Derek | Eaton | NZL | 5451 | 00:00:00 | 00:00:00 | 00:16:20 | 00:02:41 | 00:33:25 | 4 | 00:52:26
8014 | 64832 | [NAME] | Meekings | NZL | 5452 | 00:00:00 | 00:00:00 | [NAME] | 00:02:39 | 00:25:02 | 5 | 00:52:29
8014 | 33081 | [NAME] | [NAME] | USA | 5454 | 00:00:00 | 00:00:00 | [NAME] | 00:05:44 | 00:30:37 | 6 | 01:00:53
8014 | 33079 | [NAME] | [NAME] | USA | 5453 | 00:00:00 | 00:00:00 | 00:31:02 | 00:04:43 | 00:39:09 | 7 | 01:14:57
Spreadsheet: 812122d1672966954-due-upcoming-overdue-123perwinkle-123
Sheet: R13

Project Phase | Deliverable | Responsible Party | Date Assigned | Date Due | Date Completed | Color | Current Issue? | Issues Resolved? | Due/Overdue | NOTES
Planning & Scope | Set up stakeholder meeting to create a transition and relocation plan | [NAME] | 2022-12-13 00:00:00 | 2022-12-16 00:00:00 |  |  |  |  |  | Dept. of Health surveyors are scheduled to visit the facility on Dec. 14th.
Spreadsheet: 782619d1654162055-counting-cells-up-to-a-value-excluding-some-sample-worksheet-attached-sample
Sheet: Sheet1

 |  |  |  |  |  | Column1 | Column2 | Column3 | Column4
 |  |  |  |  | START | 2 | 2 | 2 | 2
 |  |  |  |  |  | 3 | 3 | 3 | 3
 |  |  |  |  |  | 4 | 4 | 4 | 4
 |  |  |  |  |  | 4.5 | 4.5 | 4.5 | 4.5
 |  |  |  |  |  | 5 | 5 | 5 | 5
 |  |  |  |  |  | 10 | 10 | 10 | 10
 |  |  |  |  |  | 20 | 10 | 10 | 10
 |  |  |  |  |  | 30 | 20 | 20 | 10
 |  |  |  |  |  | 40 | 30 | 30 | 20
 |  |  |  |  |  | 50 | 40 | 40 | 30
 |  |  |  |  |  | 60 | 50 | 50 | 40
 |  |  |  |  |  | 70 | 60 | 60 | 50
 |  |  |  |  |  | 80 | 70 | 70 | 60
 |  |  |  |  |  | 92 | 80 | 80 | 70
 |  |  |  |  |  | 90.5 | 92 | 80 | 80
 |  |  |  |  |  | 90 | 90.5 | 92 | 80
 |  |  |  |  |  | 90 | 90 | 90.5 | 92
 |  |  |  |  |  | 80 | 90 | 90 | 90.5
 |  |  |  |  |  | 70 | 80 | 80 | 90
 |  |  |  |  |  | 60 | 70 | 70 | 80
 |  |  |  |  |  | 50 | 60 | 60 | 70
 |  |  |  |  |  | 40 | 50 | 50 | 60
 |  |  |  |  |  | 30 | 40 | 40 | 50
 |  |  |  |  |  | 20 | 30 | 30 | 40
 |  |  |  |  |  | 10 | 20 | 20 | 30
 |  |  |  |  |  | 3 | 10 | 10 | 20 |  | Expected Figures | 26 | 27 | 28 | 29
 |  |  |  |  |  | 4.5 | 3 | 10 | 10
 |  |  |  |  |  | 0 | 4.5 | 3 | 10 |  | Calculated figures
 |  |  |  |  |  | 0 | 0 | 4.5 | 3
 |  |  |  |  |  | 0 | 0 | 0 | 4.5
Spreadsheet: 103862d1301527423-vlookup-if-blank-search-somewhere-else-vlookuptwice
Sheet: Sheet1

Col1 | Col2 | Found |  |  | [NAME] |  | <<Here is your [NAME]
[NAME] | Fred | Found1
Fred | [NAME] | Found2
[NAME] | [NAME] | Found3
Betty | Matilda | Found4 |  |  | Change the name in Yellow
[NAME] | Mohammad | Found5
Spreadsheet: john_griffith__16108__1_22_02LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL G2 | EXP | 1 | 1 | 94.5 | 107.1 | 1.2 | 2002-01-15 14:52:00
 | CL H2 | 19 | 205 | 218 | 54 | 57.4 | 0.67 | 2002-01-22 10:41:00
 | CL J2 | 19 | 300 | 310 | 52.8 | 54.5 | 0.64 | 2002-01-22 10:41:00
 | CL K2 | 19.5 | 370 | 385 | 49.8 | 51.9 | 0.62 | 2002-01-22 10:41:00
 | CL M2 | 19.5 | 410 | 425 | 47.9 | 49.6 | 0.6 | 2002-01-22 10:41:00
 | CL N2 | 19.5 | 450 | 465 | 46.6 | 48.2 | 0.58 | 2002-01-22 10:41:00
 | CL Q2 | 20 | 470 | 490 | 43.4 | 45.3 | 0.56 | 2002-01-22 10:41:00
 | CL U2 | 20 | 480 | 500 | 41.3 | 43 | 0.53 | 2002-01-22 10:41:00
 | [NAME] | 20 | 490 | 510 | 39.2 | 40.8 | 0.5 | 2002-01-22 10:41:00
 | CL X2 | 20 | 495 | 515 | 37.5 | 39 | 0.48 | 2002-01-22 10:41:00
 | [NAME] | 20 | 500 | 520 | 36.1 | 37.6 | 0.46 | 2002-01-22 10:41:00
 | CL F3 | 20 | 505 | 525 | 34.9 | 36.3 | 0.45 | 2002-01-22 10:41:00
 | CL M3 | 20.5 | 510 | 540 | 29.1 | 30.8 | 0.39 | 2002-01-22 10:41:00
 | CL Z3 | 20.5 | 520 | 550 | 25.9 | 27.4 | 0.34 | 2002-01-22 10:41:00
 | CL M4 |  |  |  | 21.8 | 24.4 | 0.31 | 2002-01-04 13:39:00
 |  |  |  |  |  |  |  | ,
Spreadsheet: 851516d1701735660-issue-with-basic-lookup-functions-excel-copy
Sheet: Sheet1

Column 1 | Column 2 | Column 3 | Column 4
411222949 | 1 | 411222949
411222950 | 2 | 411222950
411222951 | 3 | 411222951
411222952 | 4 | 411222952
411222953 | 5 | 411222953
411222954 | 6 | 411222954
411222955 | 7 | 411222955
411222956 | 8 | 411222956
411222957 | 9 | 411222957
411222958 | 10 | 411222958
411222959 | 11 | 411222959
411222960 | 12 | 411222960
411222961 | 13 | 411222961
411222962 | 14 | 411222962
411222964 | 15 | 411222964
411222965 | 16 | 411222965
411222966 | 17 | 411222966
411222967 | 18 | 411222967
411222968 | 19 | 411222968
411222969 | 20 | 411222969
411222970 | 21 | 411222970
411222971 | 22 | 411222971
411222972 | 23 | 411222972
411222973 | 24 | 411222973
411222974 | 25 | 411222974
411222975 | 26 | 411222975
411222977 | 27 | 411222977
411222979 | 28 | 411222979
411222980 | 29 | 411222980
411222982 | 30 | 411222982
411222984 | 31 | 411222984
411222985 | 32 | 411222985
411222989 | 33 | 411222989
411222990 | 34 | 411222990
411222991 | 35 | 411222991
411222992 | 36 | 411222992
411222993 | 37 | 411222993
411222994 | 38 | 411222994
411222995 | 39 | 411222995
411222996 | 40 | 411222996
411222997 | 41 | 411222997
411222998 | 42 | 411222998
411222999 | 43 | 411222999
411223000 | 44 | 411223000
411223001 | 45 | 411223001
411223002 | 46 | 411223002
411223003 | 47 | 411223003
411223004 | 48 | 411223004
411223005 | 49 | 411223005
411223006 | 50 | 411223006
411223007 | 51 | 411223007
411223009 | 52 | 411223009
411223010 | 53 | 411223010
411223011 | 54 | 411223011
411223012 | 55 | 411223012
411223013 | 56 | 411223013
411223014 | 57 | 411223014
411223016 | 58 | 411223016
411223017 | 59 | 411223019
411223018 | 60 | 411223021
411223019 | 61 | 411223024
411223021 | 62 | 411223025
411223024 | 63 | 411223026
411223025 | 64 | 411223029
411223026 | 65 | 411223030
411223029 | 66 | 411223032
411223030 | 67 | 411223033
411223032 | 68 | 411223034
411223033 | 69 | 411223035
411223034 | 70 | 411223036
411223035 | 71 | 411223038
411223036 | 72 | 411223040
411223038 | 73 | 411223041
411223040 | 74 | 411223042
411223041 | 75 | 411223043
411223042 | 76 | 411223044
411223043 | 77
411223044 | 78
Spreadsheet: 57324d1257434981-transpose-or-vlookup-book4
Sheet: DATA

 | A | B | C
1 | idform:*AA01 | idform:*AA02 | idform:*AA03
2 | ITEM | ITEM | ITEM
3 | GSM03 | GSM03 | Sub Total-0.0
4 | 160.00 	2.00 	320.00 | 160.00 1.00 160.00 | GrandTotal-0.00
5 | Sub Total-2.0 | GSM10
6 | GrandTotal-320.00 | 160.00 	2.00 	320.00
7 |  | Sub Total-3.0
8 |  | GrandTotal-480.00
Spreadsheet: 875252d1721833226-find-duplicates-rows-assess-difference-in-date-and-add-adjacent-column-single-vs-multiple-payments-example
Sheet: Example Sheet

 |  |  | *If payments occur within 6 months of each other then the objective is to merge in to one 'record' as a 'single tranche'. If outside of 6 month they should b eleft as Multiple Tranche
Company Name | Date Money Received | Amount | Single Payment / Converted Single Payment / One of Multiple Payments | (If appropriate) Combined Amount
AAA | 2019-01-01 00:00:00 | 500
BBB | 2020-01-01 00:00:00 | 2500
CCC | 2020-01-01 00:00:00 | 3000
DDD | 2019-01-01 00:00:00 | 1200
EEE | 2019-01-01 00:00:00 | 800
EEE | 2019-04-01 00:00:00 | 900
EEE | 2022-01-01 00:00:00 | 750
FFF | 2023-01-01 00:00:00 | 2000
GGG | 2023-04-04 00:00:00 | 3500
GGG | 2023-06-08 00:00:00 | 4500
Spreadsheet: 70802d1271488143-trying-to-reference-a-column-to-another-column-with-the-new-column-sorting-in-numeric-till-reconciliation-2
Sheet: Sheet1

 | PARTS DEPT RECONCILIATION
 | DATE |  |  | STORE |  |  | NAME
Type | INV# | AMOUNT |  | Sum of AMOUNT | Type
Cash | 710628 | 12.5 |  | INV# | Cash | Check | Credit Card | Grand Total
Check | 710629 | 52.5 |  | 710628 | 12.5 |  |  | 12.5
Credit Card | 710630 | 1029.3 |  | 710629 |  | 52.5 |  | 52.5
Credit Card | 710633 | 52.5 |  | 710630 |  |  | 1029.3 | 1029.3
Credit Card | 710636 | 10.5 |  | 710633 |  |  | 52.5 | 52.5
 |  |  |  | 710636 |  |  | 10.5 | 10.5
 |  |  |  | Grand Total | 12.5 | 52.5 | 1092.3 | 1157.3
Spreadsheet: 132954d1324055624-excel-2007-using-index-and-match-or-other-to-return-cell-based-on-largest-associated-value-daddy_scoresv2
Sheet: Sheet2

Actor1 | 1
Actor2 | 10
Actor3 | 11
Actor4 | 12
Actor5 | 13
Actor6 | 14
Actor7 | 15
Actor8 | 16
Actor9 | 17
Actor10 | 18
Actor11 | 19
Actor12 | 20
Actor13 | 21
Actor14 | 22
Actor15 | 23
Actor16 | 24
Actor17 | 25
Actor18 | 26
Actor19 | 27
Actor20 | 28
Actor21 | 29
Actor22 | 30
Actor23 | 31
Actor24 | 32
Actor25 | 33
Actor26 | 34
Actor27 | 35
Actor28 | 36
Actor29 | 38
Actor30 | 39
Actor31 | 41
Actor32 | 42
Actor33 | 43
Actor34 | 45
Actor35 | 48
Actor36 | 51
Actor37 | 53
Actor38 | 56
Actor39 | 73
Actor40 | 77
Actor41 | 78
Actor42 | 80
Actor43 | 88
Actor44 | 89
Actor45 | 90
Actor46 | 99
Actor47
Actor48
Actor49
Actor50
Actor51
Actor52
Actor53
Actor54
Actor55
Actor56
Actor57
Actor58
Actor59
Actor60
Spreadsheet: 102649d1300626675-automated-worksheet-for-accounting-filter-problem-automated-worksheets
Sheet: Suplrs_Food

SUPPLIER NAME | ACCOUNT
Acme (Clean. Supl.) | 60750.276 | Acme
Acme (Jan. Supl.) | 62750.275 | Acme
Acme (Off. Supl.) | 62750.175 | Acme
Canada Bread Co. | 60300.166 | Canada Bread Co.
Cintas (Uniforms - Food) | 60850 | Cintas
Ecolab (Repairs) | 60340 | Ecolab
Growers Direct (60308) | 60308 | Growers Direct
Growers Direct (76052) | 76052 | Growers Direct
Henrix Equipment | 60305 | Henrix Equipment
Islands West | 60300.168 | Islands West
K-Bro Linen (Premier) | 60325 | K-Bro Linen
Pacific Blue | 60340 | Pacific Blue
Praxair (171) | 60300.171 | Praxair
Praxair (Rental) | 60330 | Praxair
Reflex (Brochures, Fldrs) | 76060 | [NAME]
[NAME] (Direct Mail) | 76142 | [NAME]
[NAME] (Statnery, Badges) | 76055 | [NAME]
Reliable Parts | 68700.564 | Reliable Parts
[NAME] (176) | 60750.176 | [NAME]
Russell Food (China, Cutlry) | 60305 | [NAME]
Russell Food (Repairs) | 60340 | [NAME]
Russell Food (Supplies) | 60750.175 | [NAME]
Snap Victoria | 76050 | Snap Victoria
Soaptronic | 60750.176 | Soaptronic
Stericycle | 69130 | Stericycle
Superior Propane | 70015 | Superior Propane
Sysco (164) | 60300.164 | Sysco
Sysco (165) | 60300.165 | Sysco
Sysco (166) | 60300.166 | Sysco
Sysco (167) | 60300.167 | Sysco
Sysco (168) | 60300.168 | Sysco
Sysco (169) | 60300.169 | Sysco
Sysco (171) | 60300.171 | Sysco
Sysco (750.175) | 60750.175 | Sysco
Sysco (750.176) | 60750.176 | Sysco
Sysco (750.177) | 60750.177 | Sysco
The Arbutus Crafts | 60315 | The Arbutus Crafts
Spreadsheet: 753903d1635811577-vlookup-xlookup-with-2-conditions-sample
Sheet: Merge1

Catalogo | Codigo | Table2.Piezas
21594-17241 | TRLI | 1000
21594-17241 | 125A | 800
21594-17241 | 125A | 800
21594-17241 | 32IN | 900
24107-12140 | SURF | 2000
24107-12140 | SURF | 2000
24107-12140 | SEMI | 2000
24107-12140 | SEMI | 2000
24107-12140 | OBCT | 3492
Spreadsheet: 267832d1380225889-detect-what-comes-after-two-identical-cells-with-a-couple-of-conditions-twoidenticalcells-solved
Sheet: Sheet3

Employeed id | # | rand
123
 | 15 | partner
 | 26 | partner
456 | 7 | Apple
 | 4 | Partner
 | 25 | Partner
 | 31 | Apple
 | 6 | partner
 | 22 | partner
 | 24 | Sale
Spreadsheet: 678402d1589873315-formula-to-get-unique-data-excel-formula1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500 | Expenses Airfare Aug-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2500 | Expenses Airfare Jul-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 800 | Expenses Airfare Jun-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500 | Expenses Airfare May-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 350 | Expenses Airfare May-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500 | Expenses Airfare May-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 700 | Expenses Airfare Sep-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500 | Expenses Airfare Sep-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 300 | Expenses Airfare Oct-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 200 | Expenses Airfare Oct-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 300 | Expenses Hotel Aug-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500 | Expenses Hotel Aug-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 700 | Expenses Hotel Jul-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1200 | Expenses Hotel Sep-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1250 | Expenses Hotel Oct-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1100 | Expenses Hotel Oct-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1300 | Expenses Hotel Nov-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 900 | Expenses Hotel Nov-19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
Spreadsheet: 108708d1305717685-return-fullpath-without-filename-remove_filename
Sheet: Sheet1

Original filename | Result
D:\Shares\Admin | D:\Shares\Admin
D:\Shares\Admin\110122.CTOM-Annual-Dinner | D:\Shares\Admin\110122.CTOM-Annual-Dinner
D:\Shares\Admin\110122.CTOM-Annual-Dinner\IMG_0044.jpg | D:\Shares\Admin\110122.CTOM-Annual-Dinner\
D:\Shares\Admin\110122.CTOM-Annual-Dinner\P1000774.JPG | D:\Shares\Admin\110122.CTOM-Annual-Dinner\
D:\Shares\Admin\CHEERS Photo\P1010084.JPG | D:\Shares\Admin\CHEERS Photo\
D:\Shares\Admin\CHEERS Photo\P1010085.JPG | D:\Shares\Admin\CHEERS Photo\
D:\Shares\Admin\CHEERS Photo\P1010086.JPG | D:\Shares\Admin\CHEERS Photo\
D:\Shares\Admin\CHEERS Photo\Thumbs.db | D:\Shares\Admin\CHEERS Photo\
D:\Shares\Admin\CTOM Photos | D:\Shares\Admin\CTOM Photos
D:\Shares\Admin\CTOM Photos\101015.MarkLwinBirthday\MarkLwinBirthday-0007.jpg | D:\Shares\Admin\CTOM Photos\101015.MarkLwinBirthday\
D:\Shares\Admin\CTOM Photos\101015.MarkLwinBirthday\MarkLwinBirthday-0008.jpg | D:\Shares\Admin\CTOM Photos\101015.MarkLwinBirthday\
D:\Shares\Admin\CTOM Photos\101015.MarkLwinBirthday\Thumbs.db | D:\Shares\Admin\CTOM Photos\101015.MarkLwinBirthday\
D:\Shares\Admin\CTOM Photos\101022.Teambuilding\P1000045.JPG | D:\Shares\Admin\CTOM Photos\101022.Teambuilding\
D:\Shares\Admin\CTOM Photos\101022.Teambuilding\P1000046.JPG | D:\Shares\Admin\CTOM Photos\101022.Teambuilding\
Spreadsheet: 687188d1595013001-formula-help-to-work-out-commission-percentages-commission-calculator
Sheet: Sheet1

Monthly Breakeven Level | 1430000 |  |  | Low Threshold | High Threshold | Percentage of GP Dollars into Pool
 |  |  |  | 0 | 1430000 | 0
Monthly Sales | 2451563.47 |  |  | 1430000.01 | 2430000 | 0.05
 |  |  |  | 2430000.01 | 3430000 | 0.06
Sales above Breakeven |  |  |  | 3430000.01 | 6500000 | 0.07
Gross Profit Margin | 0.4 |  |  | Threshold | Commission Rate | [NAME]
 |  |  |  | 1430000 | 0
Gross Profit Dollars |  |  |  | 2430000 | 0.05
 |  |  |  | 3430000 | 0.06
Bonus Pool |  |  |  | 6500000 | 0.07
Spreadsheet: 0b5ae286-c0bf-43d1-8db8-9a1c32d0596b
Sheet: Hourly Daily

Daily Financial Position Report |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Daily Financial Position Report
BL_DAILYPOSITION_<customerid>_<settlementdate>_<version>.CSV |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BL_DAILYPOSITION_<customerid>_<settlementdate>_<version>.CSV
<[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
Description | Total | Day 1 | Day 2 | Day 3 | Day 4 | Day 5 | Day 6 | Day 7 | Day 8 | Day 9 | Day 10 | Day 11 | Day 12 | Day 13 | Day 14 | Day 15 | Day 16 | Day 17 | Day 18 | Day 19 | Day 20 | Day 21 | Day 22 | Day 23 | Day 24 | Day 25 | Day 26 | Day 27 | Day 28 | Day 29 | Day 30
String | $ | $ | $ | $ | $ | $ | $ | $
Spreadsheet: 771873d1646903148-flagging-a-cell-based-on-a-flagged-cell-mod2
Sheet: Sheet1

 | INPUTS: | Row 6 first flag | Row 6 following flags | Row 7 flag that follows row 6
 |  | 1 | 2 | 2
 | 1
FILTER YEAR?
2ND FILTER YEAR?
Spreadsheet: 785822d1656710260-if-statements-for-multiple-dates-and-date-ranges-that-correspond-to-different-formulas-excel-example
Sheet: Assumptions

 | Utilization Rates
 |  | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2023-02-01 00:00:00
 |  | Phase 1 | Phase 2 | Phase 3 | Phase 4 | Phase 5
 | Senior Employee Lead | 1 | 0.75 | 0.5 | 0 | 0
 | Senior Employee | 1 | 0.75 | 0.5 | 0.5 | 0.5
 | Mid-Level Employee | 1 | 0.75 | 0.5 | 0.5 | 0.5
 | Junior Employee | 1 | 0.75 | 0.5 | 0.5 | 0.5
 | Intern | 0 | 0.5 | 1 | 0.5 | 0.5
Spreadsheet: 838625d1691177354-how-to-transpose-uneven-rows-of-data-into-column-format-sample
Sheet: Sheet1

Patient Name | Appointment Date |  | Patient Name
[NAME], [NAME] | 08/17/2023 |  | [NAME], [NAME] | 08/17/2023 | 08/30/2023 | 09/14/2023 | 09/28/2023
[NAME], [NAME] | 08/30/2023
[NAME], [NAME] | 09/14/2023
[NAME], [NAME] | 09/28/2023
[NAME], [NAME] | 08/09/2023 |  | [NAME], [NAME] | 08/09/2023 | 08/11/2023 | 08/15/2023 | 08/21/2023 | 08/25/2023 | 08/31/2023
[NAME], [NAME] | 08/11/2023
[NAME], [NAME] | 08/15/2023
[NAME], [NAME] | 08/21/2023
[NAME], [NAME] | 08/25/2023
[NAME], [NAME] | 08/31/2023
Doe, [NAME] | 08/10/2023 |  | Doe, [NAME] | 08/10/2023 | 09/05/2023
[NAME], [NAME] | 08/10/2023 |  | [NAME], [NAME] | 08/10/2023 | 08/25/2023 | 08/28/2023 | 08/30/2023 | 09/12/2023 | 09/27/2023
[NAME], [NAME] | 08/25/2023
[NAME], [NAME] | 08/28/2023
[NAME], [NAME] | 08/30/2023
[NAME], [NAME] | 09/12/2023
[NAME], [NAME] | 09/27/2023