tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 138350d1327616656-search-one-worksheet-and-display-results-in-another-search-engine
Sheet: Claims

Date quotation obtained |  |  | Period - Cost per day |  |  |  |  |  |  |  |  |  |  | Vehicle options
 |  |  | (VAT at prevailing rate)
Day | Month | Year | Daily |  | <7 days | 7 - 14 days | 15 - 21 days |  |  | 22 - 28 Days |  | 28+ days | Location | Group | Make | Model | Body Style | Engine size | Taxi - (Y/N) | Transmission | Own insurance | [NAME]
1 | January | 2008 | Y |  |  | y | n |  |  | y |  | n | London | P4 | Mercedes | C200 | [NAME] | 2 | N | Manual | N | N
2 | February | 2009 | n |  | n | y | y |  |  | y |  | y | Birmingham | P4 | Audi | A4 | Estate | 2 | N | Auto | N | N
3 | March | 2010 | n |  | n | n | n |  |  | n |  | y | [NAME] | S6 | Ford | Mondeo | [NAME] | 2 | N | Manual | N | N
4 | April | 2011
5 | May
6 | June
7 | July
8 | August
9 | Septemper
10 | October
11 | November
12 | December
Spreadsheet: 132199d1323595094-count-unique-task-ids-completed-within-a-date-range-book1
Sheet: Sheet1

Task ID | Completion date |  | Follow these steps to use advace filters
1234 | 2011-01-01 00:00:00 |  | Click Data>> Under Sort and filter option click Advanced
2345 | 2011-02-01 00:00:00 |  | Select copy to another location | Task ID
3456 | 2011-07-01 00:00:00 |  | List range should be your task IDs. Entire ID's. | 1234 | 2011-01-01 00:00:00
4567 | 2011-10-15 00:00:00 |  | Criteria range should be the header like "Task ID" in this example. | 2345 | 2011-02-01 00:00:00
5678 | 2011-02-01 00:00:00 |  | Copy to should be any empty cell in sheet where you want excel to copy paste values. | 3456 | 2011-07-01 00:00:00
6789 | 2011-05-01 00:00:00 |  | Unique records only option should be checked. | 4567 | 2011-10-15 00:00:00
7890 | 2011-07-09 00:00:00 |  |  | 5678 | 2011-02-01 00:00:00
8901 | 2011-01-11 00:00:00 |  | Then do a vlookup for completion date based on IDs | 6789 | 2011-05-01 00:00:00
9012 | 2011-11-02 00:00:00 |  |  | 7890 | 2011-07-09 00:00:00
4567 | 2011-10-15 00:00:00 |  |  | 8901 | 2011-01-11 00:00:00
5678 | 2011-02-01 00:00:00 |  |  | 9012 | 2011-11-02 00:00:00
6789 | 2011-05-01 00:00:00
1234 | 2011-01-01 00:00:00
2345 | 2011-02-01 00:00:00
 |  |  | Finally do a count if to get the count of unique ID's
 | Task start date | Task completion date | Count of task ID's
 | 2011-01-01 00:00:00 | 2011-03-31 00:00:00 | 4
 | 2011-04-01 00:00:00 | 2011-06-30 00:00:00 | 1
 | 2011-07-01 00:00:00 | 2011-09-30 00:00:00 | 2
 | 2011-10-01 00:00:00 | 2011-12-31 00:00:00 | 2
Spreadsheet: 330574d1404804268-data-validation-not-working-for-excel-validation-please-help-bcr-testing
Sheet: ER Log

BCR# | Date BCR Opened | Description of Event  (Summary is acceptable) |  | BCR Owner | Agreed Completion Date Section B | Actual Completion Date Section B | Days Due for Section B (negative number indicates completed ahead of schedule) | Section B Status (Open/Closed) |  |  | Comments
1 | 2014-06-13 00:00:00 |  |  |  | 2014-07-27 00:00:00 | 2014-06-30 00:00:00 |  |  | wwwwwwww | wwwwwwwwwwwwwww | n/a
1 | 2014-05-23 00:00:00 |  |  |  | 2014-06-29 00:00:00 | 2014-07-03 00:00:00 |  |  |  |  | n/a
 | 2014-06-03 00:00:00 |  |  |  | 2014-06-28 00:00:00 | 2014-06-25 00:00:00
 | 2014-07-03 00:00:00 |  |  |  | 2014-07-15 00:00:00 | 2014-07-21 00:00:00
 | 2014-05-18 00:00:00 |  |  |  | 2014-06-23 00:00:00 | 2014-06-21 00:00:00
 |  |  |  |  | 2014-07-01 00:00:00 | 2014-07-04 00:00:00
 |  |  |  |  | 2014-01-23 00:00:00
Spreadsheet: 017da044-f6c1-457a-a788-83a786811f49
Sheet: Sheet1

NIGHT OF CHAMPIONS-DISTRICT, BI-DISTRICT, AREA, REGIONALS & STATE | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
SCHOOL:
PRINCIPAL:
SPORT:
Please list in Alpha order by last name and capitalize ONLY the first letter of the first and last name.
ATHLETES
FIRST NAME | LAST NAME | EVENT IN TRACK/SWIMMING                                              1ST PLACE ONLY
STUDENT TRAINERS
FIRST NAME | LAST NAME | FIRST NAME | LAST NAME
MANAGERS
FIRST NAME | LAST NAME | FIRST NAME | LAST NAME
COACHES
FIRST NAME | LAST NAME | FIRST NAME | LAST NAME
Spreadsheet: 177683d1346396757-conditionally-format-external-data-cf-ext-data
Sheet: Sheet1

Table from external source
Club | Pld | Pts |  | Club | Pld | Pts
Chelsea | 3 | 9 |  | Chelsea | 3 | 9
Swansea | 2 | 6 |  | Swansea | 2 | 6
Everton | 2 | 6 |  | Everton | 2 | 6
West Brom | 2 | 4 |  | West Brom | 2 | 4
Man City | 2 | 4 |  | Man City | 2 | 4
Fulham | 2 | 3 |  | Fulham | 2 | 3
Man Utd | 2 | 3 | Conditionally format this | Man Utd | 2 | 3
[NAME] | 2 | 3 | to look like this | [NAME] | 2 | 3
Newcastle | 2 | 3 |  | Newcastle | 2 | 3
West Ham | 2 | 3 |  | West Ham | 2 | 3
Stoke | 2 | 2 |  | Stoke | 2 | 2
Arsenal | 2 | 2 |  | Arsenal | 2 | 2
Sunderland | 1 | 1 |  | Sunderland | 1 | 1
Tottenham | 2 | 1 |  | Tottenham | 2 | 1
Reading | 2 | 1 |  | Reading | 2 | 1
Liverpool | 2 | 1 |  | Liverpool | 2 | 1
[NAME] | 2 | 1 |  | [NAME] | 2 | 1
QPR | 2 | 1 |  | QPR | 2 | 1
Southampton | 2 | 0 |  | Southampton | 2 | 0
[NAME] | 2 | 0 |  | [NAME] | 2 | 0
Spreadsheet: 33fcd049-be35-4d15-b0fa-edcf937d6630
Sheet: EDEBİYAT FAK.RUS DİLİ

GAZİ ÜNİVERSİTESİ YABANCI DİLLER YÜKSEKOKULU
EDEBİYAT FAKÜLTESİ RUS DİLİ VE EDEBİYATI BÖLÜMÜ
9 EYLÜL 2013 TARİHİNDE HAZIRLIK ATLAMA SINAVINA GİRECEK ÖĞRENCİLER
SINAV YERİ:EDEBİYAT FAKÜLTESİ                 DERSLİK: 110
# | Öğr.No | Adı | Soyadı
1 | 133396001 | [NAME] | AKSOY
2 | 133396002 | SEMANUR | AKSOY
3 | 133396003 | MİRAY | AYDIN
4 | 133396004 | MERYEM | BAŞKURT
5 | 133396005 | SİMGE | BAYTEK
6 | 133396006 | GÜLŞAH | BOSTAN
7 | 133396007 | ÖZLEM | CAMGÖZ
8 | 133396008 | SENA | ÇELİK
9 | 133396009 | SİMGE YILDIZ | [NAME]
10 | 133396010 | HATİCE BEYZA | ÇİFTCİER
11 | 133396011 | ABDÜRREZAK EMRE | EROĞLU
12 | 133396012 | EZGİ | EROĞLU
13 | 133396013 | KÜBRA | FİDAN
14 | 133396014 | HÜSEYİN EFE | GENÇ
15 | 133396015 | NERGİZ | GÜLEÇ
16 | 133396016 | ERDEM | GÜLER
17 | 133396017 | AYŞE | GÜNAYDIN
18 | 133396018 | SERGEN | HAMZAÇEBİ
19 | 133396019 | KEREM | KARABULUT
20 | 133396020 | [NAME] | KARCI
21 | 133396021 | FEYZANUR | KAZAKLI
22 | 133396022 | BURÇİN | KOÇ
23 | 133396023 | ZEYNEP | KOÇAK
24 | 133396024 | EMİNE | [NAME]
25 | 133396025 | ANIL | KÖMÜRCÜ
26 | 133396026 | GÖKŞİN ESRA | [NAME]
27 | 133396027 | TUĞÇE | [NAME]
28 | 133396028 | [NAME] | KÜÇÜKÖNER
29 | 133396029 | HAVVANUR | ÖKTE
30 | 133396030 | DAMLA | ÖZTÜRK
31 | 133396031 | DAMLA NUR | SAYRE
32 | 133396032 | BERKAY | ŞAHİN
33 | 133396033 | [NAME] | ŞANLI
34 | 133396034 | [NAME] | TASLAK
35 | 133396035 | TAYLAN | TUNAR
36 | 133396036 | TUĞÇE | UĞURDOĞAN
37 | 133396037 | MERAL | UYSAL
38 | 133396038 | SERHAT | UYSAL
39 | 133396039 | CİHAN CAN | ÜLGER
40 | 133396040 | [NAME] | YALÇINKAYA
41 | 133396041 | ÖZGÜR UMUT | YAZĞAN
42 | 133396042 | DENİZ EGE | YILDIRIM
43 | 133396043 | KIVILCIM DENİZ | YILDIRIM
44 | 133396044 | [NAME] ASLI | [NAME]
45 | 133396045 | MURAT | [NAME]
46 | 133396046 | ALİ RIZA | YÜCEFAYDALI
47 | 133396047 | AYTAÇ | [NAME]
Spreadsheet: 738301d1624961185-data-range-copy-and-paste-book1
Sheet: Sheet2

978 | A | 321 | 205 | 431 | 497 | 708
483 | S | 798 | 672 | 778 | 248 | 20
117 | D | 302 | 23 | 188 | 427 | 420
586 | F | 586 | 33 | 275 | 419 | 580
658 | G | 72 | 948 | 315 | 554 | 541
Spreadsheet: 165121d1341032680-i-need-to-look-up-the-current-date-and-return-a-value-based-on-specific-criteria-excel-help-
Sheet: Sheet2

FROM
INVOICE - Transfer to Make
DATE
FROM
Account Name | Amount
Account 3 |  |  | (to return value -68376.77)
Account 4 |  |  | (to return value -20984.1)
Account 5 |  |  | (to return value -277.89)
Account 6 |  |  | (to return value -65642.23)
Account 7 |  |  | (to return value -884.14)
Account 8 |  |  | (to return value -10321.78)
Account 9
Account 10 |  |  | (to return value-207.51)
TO
Account Name | Amount
Account 2
Spreadsheet: 856237d1705562256-autofilling-or-creating-a-dropdown-menu-for-a-monthly-shift-schedule-calendary
Sheet: Sheet1

 | 2023 | Year
 | [NAME] | Month |  |  |  |  |  |  | Work Schedule
 | Employee |  | Day of the month
1 | Employee 1 |  | x
2 | Employee 2 |  | x | x
3 | Employee 3 |  |  |  | x
4 | Employee 4 |  |  | x
5 | Employee 5 |  |  |  | x
6 | Employee 6 |  |  | x | x
7 | Employee 7 |  | x |  | x
8 | Employee 8 |  | x |  |  | x
9 | Employee 9 |  | x |  | x
10 | Employee 10 |  | x |  |  | x
11 | Employee 11 |  | x | x
12 | Employee 12 |  | x |  | x
13 | Employee 13 |  |  | x |  | x
14 | Employee 14 |  | x |  | x
15 | Employee 15 |  |  | x |  | x
16 | Employee 16 |  | x |  |  | x
17 | Employee 17 |  |  | x |  | x
18 | Employee 18 |  | x |  | x
Spreadsheet: 155439d1336841788-arrays-question-development-for-cubic
Sheet: Sheet2

 | [NAME] | coef | Inga | coef | Alise | coef | today()
[NAME] | 2012-01-01 00:00:00 | 1.688710444469143 | 2012-01-06 00:00:00 | 1.371252155020653 | 2012-01-03 00:00:00 | 1.040553926723608 | 2012-02-14 00:00:00
Alise | 2012-02-15 00:00:00 | 0.9871740102151009 | 2012-02-02 00:00:00 | 0.8076068832731258 | 2012-02-04 00:00:00 | 0.6022022025140813
 | 2012-03-25 00:00:00 | 0.07976106303538122 | 2012-03-31 00:00:00 | 0.1160746904611686 | 2012-03-15 00:00:00 | 0.5758473982879398
1. Getting coef knowing raws |  |  |  |  | 4. Maybe the future index solution
 |  |  | 0.5758473982879398 |  | index
 |  |  |  |  | Array | C1:Q1
2. Getting coef per one column |  |  |  |  | Row number | MATCH(SMALL(IF($C$2:$C$4>A13,$C$2:$C$4),1),$C$2:$C$4,0)
 |  | a |  |  |  | MATCH(A13,$C$2:$C$4,1)+1
 |  | b |  |  | Col number | match(A3:A5,C1:Q1)+2
3.Getting right columns
 |  |  |  |  |  | Alise
 |  |  | 5 |  | 2012-01-01 00:00:00 | 2012-01-03 00:00:00 |  |  |  | False | #N/A
 |  |  |  |  | 2012-02-15 00:00:00 | 2012-02-04 00:00:00 |  |  | 17 | False | #N/A
4. Two dimensional lookup |  |  |  |  | 2012-03-25 00:00:00 | 2012-03-15 00:00:00 |  |  | 18 | 18 | #N/A
 |  |  |  |  |  |  |  |  | #N/A | #N/A | #N/A
 |  |  | #N/A |  |  |  |  |  | #N/A | #N/A | #N/A
Spreadsheet: 707981d1607565894-find-the-column-number-of-the-first-instance-of-a-column-with-data-demo-file
Sheet: Worksheet

Concat | Employee | Pay Date | Type | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri2 | Sat2 | Sun2 | Mon2 | Tue2 | Wed2 | Thu2
 | Employee 1 | 2020-02-20 00:00:00 |  |  |  |  | 8 | 8.5 | 8 | 9 | 7 | 5 |  | 4 | 8 | 4
 | Employee 1 | 2020-05-15 00:00:00 |  |  |  |  |  |  | 6 | 4 |  | 3 |  | 5 | 7 | 4 | 6
 | Employee 2 | 2020-05-15 00:00:00 |  |  |  | 8 | 7 | 7 |  | 6
 | Employee 1 | 2020-05-29 00:00:00 |  |  |  |  |  | 8 |  |  |  |  |  | 8 | 8 | 8 | 8
 | Employee 2 | 2020-05-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 8 | 8 | 8 | 8
Employee: | Employee 2
Date: | 2020-05-15 00:00:00
 |  |  |  |  |  |  | Concat |  | Expected Column Number
 |  |  |  |  |  |  | Employee 1 - 43881
 |  |  |  |  |  |  | Employee 1 - 43966
 |  |  |  |  |  |  | Employee 2 - 43966
Get the first column number in $[NAME] with data in it. |  |  |  |  |  |  | Employee 1 - 43980
 |  |  |  |  |  |  | Employee 2 - 43980
=INDEX(Worksheet,MATCH(B10&" - "&B11,Worksheet[Concat],0),???)
Spreadsheet: d3f1c388-9995-414c-a2a7-d690e89bce4d
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
8776 | 68920 | Debbie | Trafford | GBR | 107 | 00:20:55 | 00:00:47 | 00:36:44 | 00:01:31 | 00:22:12 | 1 | 01:22:12
8776 | 69396 | Valentina | Mela | ITA | 106 | 00:20:49 | 00:00:55 | [NAME] | 00:01:11 | 00:25:47 | 2 | 01:31:27
Spreadsheet: 162634d1340018369-excel-formulas-seem-to-stop-working-at-a-certain-range-camp-sign-up-spreadsheet-test
Sheet: Olympic & Skate Week

 | Name | Age | Emergency Contact | Phone Number
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
Spreadsheet: 846279d1697548673-how-to-sum-single-criteria-over-multiple-rows-demo-excel-forum
Sheet: Report Needed

 | Generic Name | Criteria | Part Data 1 (Should contain sum of Data 1, 2 and 4 from Sheet 1) | Part Data 2 (Should contain Data 3)
 | Orange | B | 15 | 7
 | [NAME] | D | 15 | 5
 | Pineapple | J | 9 | 6
 | Sugarcane | A | 11 | 8
 | Beans | C | 7 | 6
 | [NAME] | F | 13 | 3
 | Melon | E | 21 | 4
 | Mango | G | 18 | 2
 | Grape | H | 19 | 1
 | Lemon | I | 14 | 5
Spreadsheet: 143656d1330511713-excel-2007-help-to-auto-fill-price-on-invoice-spreadsheet-copy-of-copy-of-members-25-discount-price-invoice-test-1
Sheet: Sheet1

Invoice Date: | 2012-02-29 00:00:00
Name: |  | Making the world healthier, One person at a time.
Address:
Phone #:
 |  | GET A FRIEND TO BECOME A MEMBER AND GET AN EXTRA 10% OFF YOUR NEXT ORDER
[NAME]:
SKU | Description | Qty | Tax | Retail Price | Total Price
84749 | Thingies | 1 | 1.1 | 56.19 | 61.809
86734 | doo-dads | 3 | 1.1 | 4.67 | 15.411
68542 | Whatchamacallitz |  |  | 23.41 | 0
69341 | piece of stuff |  |  | 64.37 | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  | Retail Total: | 77.22
Thank you for ordering
 |  |  |  | 25% discount: | 57.915
Please call me if you have any questions
 |  |  |  | Tax: | 0
GET 2 FRIENDS TO BECOME A MEMBER AND GET AN EXTRA 15% OFF YOUR NEXT 2 ORDERS
 |  |  |  | S&H: | 10.8108
 |  |  |  | Your Total Due: | 68.72579999999999
Spreadsheet: 268613d1380713679-change-a-date-cell-to-red-0a223
Sheet: Sheet1

[NAME]. | Date In | Customer | Part No. | Batch No. | Description | Spec. | Cast | Qty | Process | T/P No.
1 | 2013-10-02 00:00:00
2
3
4 | 2013-03-01 00:00:00
5
6
7 | 2013-02-15 00:00:00
8
9 | 2013-06-18 00:00:00
10
11
12
13 | 2013-05-18 00:00:00
14
15 | 2013-04-19 00:00:00
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
Spreadsheet: 672685d1586961827-help-with-an-if-formula-runners
Sheet: Sheet1

 |  | 5.84
0 | 9
5.451 | 8
6.151 | 7
6.451 | 6
7.301 | 5
8.001 | 4
9.001 | 3
10.001 | 2
11.001 | 1
Spreadsheet: 875717d1722333837-how-to-make-this-if-formale-work-mobilisation-forecast
Sheet: Сарын жагсаалт

Нэр | Хэлтэс | Ажилд орсон цэг | Ажлын эхний өдөр | Байршил
2023
JANUARY
FEBRUARY
[NAME]
APRIL
MAY
[NAME]
JULY
AUGUST
SEPTEMBER
OCTOBER
NOVEMBER
DECEMBER
2024
JANUARY
FEBRUARY
[NAME]
APRIL
MAY
[NAME]
JULY
AUGUST
SEPTEMBER
OCTOBER
NOVEMBER
DECEMBER
2025
JANUARY
Spreadsheet: 188373d1350852378-create-a-sub-table-by-specifying-specific-rows-from-another-table-specify_rows
Sheet: Sheet1

Catagory | Order Ranking | Chart |  | Name | Order Ranking | Chart
Some text 1 | 5 |  |  | Some text 5 | 1 | Plot
Some text 2 | 6 |  |  | Some text 7 | 1 | Plot
Some text 3 | 9 |  |  | Some text 9 | 3 | plot
Some text 4 | 11
Some text 5 | 1 | Plot
Some text 6 | 2
Some text 7 | 1 | Plot
Some text 8 | 3
Some text 9 | 3 | Plot
Some text 10 | 8
Some text 11 | 9
Some text 12 | 7
Some text 13 | 10
Some text 14 | 9
Some text 15 | 4
Spreadsheet: 0b405207-99c7-4a3a-bc47-07e0b78c73c5
Sheet: 14d

 | Swap Dealers/MSPs4 |  |  | Others
Product1 | HY3 | IG | Other |  | IG | Other
Index Tranche | 12 | 49 | 20 | 14 | 47 | 18
Index | 2618 | 2710 | 3546 | 2582 | 1799 | 2408
OTHER* | 0 | 0 | 266 | 0 | 0 | 136
TOTAL
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 119943d1314879400-inserting-rows-across-sheets-komet12_testing
Sheet: All

Last Name | First Name | Occp | Dept | Team | Shift | GMIN | BPD | [NAME] | Interview | Math | Written | Comments | Test Taken On:
Abate | [NAME] | T503 | 7103 | 1003 | 3 | 355 | 78 | 76 | 75 | 90 | 70
Abbott | [NAME] | T103 | 1701 | 4501 | 1 | 356 | 100 |  | 80 | 100 | 100
Abel | [NAME] | T103 | 1101 | 1301 | 1 | 357 | 100 | 92 | 80 | 59 | 90
Abt | [NAME] | T203 | 5001 | 5301 | 1 | 358 | 50 | 84 | 70 | 100 | 70
Adams | Blaine | T103 | 1103 | 1303 | 3 | 359 | 100 | 100 | 100 | 80 | 100
Aguilar | [NAME] | T103 | 1701 | 1801 | 1 | 360 | 82 | 85 | 75 | 80 | 50 | 2,4,5,7,10 | 2010-11-08 00:00:00
Aide | Randolph | T103 | 1102 | 1302 | 2 | 361 | 96 | 92 | 75 |  | 100
Akpoguma | [NAME] | T103 | 2502 | 2502 | 2 | 362 | 93 | 96 | 85 | 100 | 100
Aldrich | [NAME] | T103 | 1702 | 4502 | 2 | 363 | 100 | 100 | 90 | 80 | 80
[NAME] | Mark | T103 | 1702 | 3302 | 2 | 369 | 100 | 88 | 80 | 66 | 100
[NAME] | Dale | T103 | 2701 | 3201 | 1 | 365 | 93 | 85 | 80 | 90 | 80
[NAME] | [NAME] | T101 | 2703 | 3403 | 3 | 364 | 71 | 73 | 50 | 70 | 90
[NAME] | [NAME] | T503 | 3601 | 4001 | 1 | 368 | 90 | 85 | 100 | 100 | 44
[NAME] | [NAME] | T203 | 5003 | 7703 | 3 | 366 | 92 | 35 | 70 | 100 | 50
[NAME] | [NAME] | T503 | 7101 | 3001 | 1 | 367 | 95 | 84 | 85 | 80 | 80
[NAME] | [NAME] | T103 | 2501 | 4501 | 1 | 370 | 100 | 100 | 75 | 90 | 100
Andritsch | Troy | T103 | 1701 | 4501 | 1 | 371 | 100 | 100 | 70 | 100 | 90
[NAME] | [NAME] | T203 | 5003 | 4203 | 3 | 372 | 96 | 100 | 40 | 100 | 90
Arriaga | [NAME] | T103 | 1102 | 1302 | 2 | 373 |  | 100 |  |  | 71 | benefits
Babler | [NAME] | T203 | 5001 | 1201 | 1 | 374 | 40 |  |  |  |  | committeeman
[NAME] | Bradley | T103 | 1701 | 6401 | 1 | 375 | 96 | 98 | 80 | 90 | 90
[NAME] | [NAME] | T103 | 1703 | 2603 | 3 | 376 | 86 | 92 | 33 | 100 | 100
Bannister | Marcus | T203 | 5001 | 5301 | 1 | 377 | 100 | 96 | 80 | 80 | 80
Barger | [NAME] | T703 | 8302 | 2002 | 2 | 378 |  |  | 100 | 62 | 100
Spreadsheet: 718208d1613045630-locking-formulas-and-constants-from-sheet-1-in-sheet-2-example
Sheet: Costing

Ingredients | Purchase size gr/ml | Purchase Cost | Cost per gr/ml | Units needed |  | Cost per serving
Salt | 500gr | 9
Herbs | 18gr | 19
Oil | 2L | 50
Vinegar | 750ml | 11
Eggs | 30 | 50
Parsley | 3 | 12
Spring Onion | 8 | 13
[NAME] | 10 | 8 |  |  |  |  |  | COST TO MAKE 1L
Packaging
 |  | Purchase Cost | Plus Labelling | Ingredients | Ingredients and bottle | Selling Price | Profit/Loss | Refill
 |  |  |  |  |  |  |  | 30
 |  | 3.5 |  |  |  | 60 |  | 50
 |  | 4.5 |  |  |  | 80 |  | 70
 |  | 10.5 |  |  |  | 40 |  | 30
 |  | 11.9 |  |  |  | 60 |  | 50
 |  | 20 |  |  |  | 160 |  | 150
 |  | 2
 |  | 2.6
 |  | 0.35
 |  | 0.4
 |  | 0.35
 |  | 0.4
Spreadsheet: 128509d1321020225-remove-blank-from-drop-down-list-dependant-dropdown
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | S | 6 | 7 | 5 | 4 | 6 | 4
 |  | S | K | E | C | E | L |  | K | 10 | 9 | 9 | 10 | 8 | 5
 | 4 |  |  |  | X |  | X |  | E |  |  |  |  |  | 6
 | 5 |  |  | X |  |  |  |  | cc |  |  |  |  |  | 7
 | 6 | X |  |  |  | X | X |  | d |  |  |  |  |  | 8
 | 7 |  | X |  |  |  |  |  | L |  |  |  |  |  | 9
 | 8 |  |  |  |  |  | X |  |  |  |  |  |  |  | 10
 | 9 |  | X | X |  | X |  |  |  | Letters | Numbers
 | 10 | X |  |  | X |  | X |  |  | S | 7
 |  |  | Letters | Numbers
 |  |  | C | 9
Spreadsheet: 101361d1299513600-linking-workbooks-example
Sheet: Jul

 | Unit Sold
Salesman1 | 597
Salesman2 | 933
Salesman3 | 989
Salesman4 | 214
Salesman5 | 608
Salesman6 | 641
Salesman7 | 386
Salesman8 | 560
Salesman9 | 703
Salesman10 | 671
Salesman11 | 211
Salesman12 | 181
Salesman13 | 458
Salesman14 | 46
Salesman15 | 145
Salesman16 | 131
Salesman17 | 655
Salesman18 | 328
Salesman19 | 4
Salesman20 | 486
Salesman21 | 682
Salesman22 | 883
Spreadsheet: 884778d1734039792-combining-yearly-array-data-into-a-rolling-sum-sample-2025
Sheet: 1-2

 |  |  |  |  |  |  |  |  |  |  |  | REFERRAL | Patient | Clinic | Provider
 |  |  |  |  |  |  |  |  |  |  |  |  | A | DM FM [100110117] | HA. ILEY [165]
 |  |  |  |  |  |  |  |  |  |  |  | X | B | D PT FM [1004] | DU, RON [168]
 |  |  |  |  |  |  |  |  |  |  |  |  | C | DM FM [100200117] | ML, DAN [212]
 |  |  |  |  |  |  |  |  |  |  |  |  | D | DM FM [100200117] | SH, DIV [149]
 |  |  |  |  |  |  |  |  |  |  |  | X | E | DM FM [100200117] | TA, CHRIS [284]
 |  |  |  |  |  |  |  |  |  |  |  |  | F | FAMILY HLTH [46002] | RI, MARIA [226]
 |  |  |  |  |  |  |  |  |  |  |  |  | G | DP NC [130121] | FR, KREX [325]
 |  |  |  |  |  |  |  |  |  |  |  |  | H | SS HILL [13011] | EC, DORE [597]
 |  |  |  |  |  |  |  |  |  |  |  |  | I | SMIT MC [11102] | RI, TREE [569]
 |  |  |  |  |  |  |  |  |  |  |  |  | J | SSZV [1301] | FA, THOJ [132]
 |  |  |  |  |  |  |  |  |  |  |  |  | K | D IM [10010] | BR, MEW C [369]
 |  |  |  |  |  |  |  |  |  |  |  |  | L | DMUS FM [10016] | CAR, JEC [236]
 |  |  |  |  |  |  |  |  |  |  |  | x | M | SJ FM [13012] | SM, JACK [005]
Spreadsheet: 51272d1250799890-points-formatting-book1-1-1-
Sheet: Helping sheet

Position | Pts
0 | 0
1 | 400
2 | 340
3 | 310
4 | 290
5 | 270
6 | 250
7 | 230
8 | 210
9 | 190
10 | 170
11 | 150
12 | 130
13 | 110
14 | 90
15 | 80
16 | 70
17 | 60
18 | 50
19 | 40
20 | 30
21 | 20
22 | 10
Spreadsheet: 182625d1348562659-traverse-data-from-one-excel-tab-to-another-in-same-file-sample-file
Sheet: GM

PRICE_PLAN | ROAM_COST_1101 | ROAM_COST_1102 | ROAM_COST_1103 | ROAM_COST_1104 | ROAM_COST_1105 | ROAM_COST_1106 | ROAM_COST_1107 | ROAM_COST_1108 | ROAM_COST_1109 | [NAME] | ROAM_COST_1111 | ROAM_COST_1112 | ROAM_COST_1201 | ROAM_COST_1202 | ROAM_COST_1203 | [NAME] | ROAM_COST_1205 | ROAM_COST_1206 | ROAM_COST_1207 | ROAM_COST_1208
djuice all in 1 L
djuice all in 1 M
djuice all in 1 S
djuice allstar
djuice combi
djuice complete
djuice control
djuice explore
djuice friends
djuice magnum
djuice nonstop
djuice phone
djuice phone149
djuice phone175
djuice phone75
djuice simply
djuice zero
Fri120
Fri20
Fri60
FriFiks
FriHet
Spreadsheet: 159631d1338790504-update-worksheets-using-a-button-in-a-mastersheet-request-handling-partial
Sheet: Keyboard

Name | Department | Location | Designation | Comp./ID # | Supervisor | Ref # | Request Date | Equipmment / Access Control | Remarks | Status
 |  |  | /Job lvl |  | /Manager |  |  | Description
aa | a | a | a | a | a | a | aa | a | a | a
[NAME] | ICTD | field | 2 | 900333 | [NAME] | 96773 | [NAME] | computer set
Spreadsheet: 871304d1717681227-excel-function-to-compare-2-columns-same-row-and-select-the-new-value-in-a-new-column-excel-example-2
Sheet: Tab #2

[NAME]
Part # | Description | Jan-24 Cost | Feb-24 Cost
[NAME] | Widget 1 | 100 | 5
XYZ-2 | Widget 2 | 90 | 15
XYZ-3 | Widget 3 | 110 | 12
XYZ-4 | Widget 4 | 120 | 36
[NAME] | Widget 5 | 80 | #N/A
XYZ-6 | Widget 5 | 199 | #N/A
Spreadsheet: 53864d1253792439-colidating-data-in-column-column_consolidation_issue_240909
Sheet: Department B

Head Count - Department B
Position | Name | Department | Location | Comments | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00
BA | Z Zoo | B | Amsterdam |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
BB | Z [NAME] | B | Amsterdam | New position - starts in June 2010 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1
BC | Z Xoo | B | Amsterdam |  | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
BC | Z Xoo | B | Beijing |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
BD | Z Woo | B | Amsterdam |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
BE | Z Voo | B | Amsterdam |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
BF | Z Uoo | B | Amsterdam |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
BG | Z Too | B | Beijing | Position eliminates in Nov 2010 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0
BH | Z Soo | B | Beijing |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 342836d1409696050-event-calendar-with-recurring-event-140902_-calendar-of-events-2014-_-test
Sheet: Event Calendar - MAY 15

 |  |  |  | EVENT CALENDAR
 |  |  |  |  |  | ENTER MONTH: | May
 |  |  |  |  |  | ENTER YEAR: | 2015
 |  |  |  |  |  | ENTER START DAY: | Sunday
 | TO EVENT LIST >>
Spreadsheet: 139739d1328429608-fetch-value-of-a-cell-if-its-row-contain-a-value-0-sales_record_my_doubt-pending-cash
Sheet: Cash Pending

 | Customers List with Pending Cash
 | Customer ID | Customer Name | Pending Cash