tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 835418d1688569836-complex-formula-split-text-into-several-chunks-based-on-character-count-test-copy-1-
Sheet: Sheet1

 |  |  |  | Source copy: | Text_Chunk_1 | Text_Chunk_2 | Text_Chunk_3 | Text_Chunk_4 | Text_Chunk_5 | Text_Chunk_6 | Text_Chunk_7 | Text_Chunk_8 | Text_Chunk_9 | Text_Chunk_10
 |  |  |  | [NAME] ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et [NAME]. Sapien eget mi proin sed libero enim sed faucibus turpis. Dofnefc adipiscing tristique risus nec feugaaaaaaaaaiat in fermentum. [NAME] ut porttitor [NAME] a [NAME] tempor. Eget duis at tellus at. Faucibus et molestie ac feugiat sed. Arcu felis bibendum ut tristique et egestas quis. Dictum varius duis at consectetur lorem donec. Ullamcorper a lacus vestibulum sed arcu. Eget felis eget nunc lobortis mattis. [NAME] eget egestas purus [NAME] in nisl. In hac habitasse platea dictumst quisque sagittis purus sit. [NAME] adipiscing enim [NAME] turpis egestas pretium aenean pharetra. Arcu ac tortor dignissim convallis aenean et tortor at risus. Egestas fringilla phasellus faucibus scelerisque eleifend donec pretium vulputate. [NAME] turpis nunc eget lorem dolor.  [NAME] augue ut lectus arcu bibendum at varius. Tristique risus nec feugiat in fermentum posuere urna nec. Sagittis vitae et leo [NAME] [NAME] porttitor. Eget egestas purus [NAME] in nisl nisi scelerisque eu. Tincidunt eget nullam non nisi est sit amet facilisis magna. [NAME] fringilla urna porttitor rhoncus dolor purus non enim praesent. Ut [NAME] [NAME] justo eget magna. Et malesuada fames ac turpis egestas integer. Mattis molestie a iaculis at erat pellentesque adipiscing. Condimentum vitae sapien pellentesque habitant morbi tristique senectus et. In fermentum posuere urna nec.  [NAME] rhoncus mattis rhoncus urna neque viverra justo nec. [NAME] duis ultricies lacus sed turpis tincidunt id. [NAME] sed vulputate mi sit amet [NAME].
Spreadsheet: 65370d1266051573-payroll-calcualtions-nested-if-payroll-2520help-1-1-
Sheet: Sheet1

 | Yale/Mercer | Jan | Feb | March | April | May | June | July | Aug | Sept | Oct | Nov | Dec | FICA FF 7.15% | 09 Total
[NAME] | M | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2145 | 30000
[NAME] | Y | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 857.9999999999999 | 12000
[NAME] | Y | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | 2145 | 30000
[NAME] | M | 35800 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 5312.45 | 74300
[NAME] | M | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1500 | 1287 | 18000
Total |  | 43300 | 11000 | 11000 | 11000 | 11000 | 11000 | 11000 | 11000 | 11000 | 11000 | 11000 | 11000 |  | 164300
Yale |  | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 | 3500 |  | 42000
FICA | 0.0715 | 250.25 | 250.25 | 250.25 | 250.25 | 250.25 | 250.25 | 250.25 | 250.25 | 250.25 | 250.25 | 250.25 | 250.25 |  | 3003
Unemployment | 0.0057 | 0
L&I | 0.003474
Mercer |  | 39800 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 | 7500 |  | 122300
FICA | 0.0715 | 2845.7 | 536.25 | 536.25 | 536.25 | 536.25 | 536.25 | 536.25 | 536.25 | 536.25 | 536.25 | 536.25 | 536.25 |  | 8744.45
Unemplyoment | 0.0057 | 22.8 | 42.75 | 42.75 | 42.75 | 42.75 | 42.75 | 42.75 | 42.75 | 42.75 | 42.75 | 42.75 | 42.75
L&I | 0.003445
Spreadsheet: b24526bc-2d02-4c8e-a568-fb30d4a3f013
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40159992 | 2014-02-21 08:34:06 | ALLIES | 0 | 2 | 6 | 774449 | Quintilus | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
40160102 | 2014-02-21 08:49:38 | AXIS | 1 | 6 | 4 | 774449 | Quintilus | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
40175682 | 2014-02-22 07:43:12 | ALLIES | 1 | 5 | 1 | 1264474 | ulsif1 | 6153 | western | 1944-08-24 | 1944-08-24 | Liberation of Paris | Libération de Paris
40192826 | 2014-02-23 06:34:40 | AXIS | 1 | 4 | 2 | 1529587 | [NAME] | 6158 | western | 1944-06-06 | 1944-06-06 | Pegasus Bridge | Pegasus Bridge
40192953 | 2014-02-23 06:52:01 | ALLIES | 1 | 4 | 2 | 1529587 | [NAME] | 6158 | western | 1944-06-06 | 1944-06-06 | Pegasus Bridge | Pegasus Bridge
40193140 | 2014-02-23 07:14:11 | ALLIES | 1 | 6 | 5 | 1068355 | Dejerik | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
40193321 | 2014-02-23 07:30:50 | AXIS | 0 | 3 | 6 | 1068355 | Dejerik | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
40261611 | 2014-02-27 07:02:17 | ALLIES | 0 | 6 | 7 | 558961 | jostaline | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
40261822 | 2014-02-27 07:23:08 | AXIS | 1 | 7 | 4 | 558961 | jostaline | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
40277249 | 2014-02-28 06:52:31 | AXIS | 1 | 6 | 5 | 1462356 | ossobolev | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
40277364 | 2014-02-28 07:04:12 | ALLIES | 1 | 6 | 3 | 1462356 | ossobolev | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
40277475 | 2014-02-28 07:29:59 | AXIS | 0 | 4 | 10 | 1022086 | Mishgan | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40277654 | 2014-02-28 07:55:05 | ALLIES | 1 | 10 | 9 | 1022086 | Mishgan | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
Spreadsheet: 816229d1675435647-vacation-time-vacation-time-calculator
Sheet: Nicole Bobb

Vacation Time Calculated
Employee Name |  | Date of Hire | [NAME] | Starting Balance | Used Vacation Time | Vacation Balance
[NAME] |  | 2021-09-24 00:00:00 |  | 40 | 8
[NAME] |  | 2022-05-23 00:00:00
[NAME] |  | 2021-07-19 00:00:00
[NAME] |  | 2020-03-16 00:00:00
[NAME] |  | 2022-12-20 00:00:00
[NAME] |  | 2020-02-28 00:00:00
[NAME] |  | 2021-12-13 00:00:00
[NAME] |  | 2022-05-12 00:00:00
[NAME] |  | 2018-10-11 00:00:00
[NAME] |  | 2020-12-16 00:00:00
[NAME] |  | 2022-05-16 00:00:00
[NAME] |  | 2022-10-18 00:00:00
Penelope Nicholson |  | 2022-08-09 00:00:00
[NAME] |  | 2022-04-05 00:00:00
[NAME] |  | 2022-12-08 00:00:00
[NAME] |  | 2023-01-06 00:00:00
[NAME] |  | 2014-02-20 00:00:00
[NAME] |  | 2022-07-27 00:00:00
[NAME] |  | 2020-12-07 00:00:00
[NAME] |  | 2021-05-14 00:00:00
Spreadsheet: 798996d1664869716-how-to-copy-formula-down-rcti-example
Sheet: RCTI Prep

Policy Number | SID | Amount | Cost Centre | Entity | Reason |  |  | Gross | Net | GST |  | Check
P003490672 | 2599520 | 845.7 | CSCEN | A11 | Upgrade
P003717202 | 2434413 | 724.95 | ISCEN | A14 | New Policy Comm
P003731332 | 2431222 | 295.3 | ISCEN | A11 | New Policy Comm
P002816769 | 2552887 | -860.63 | ISCEN | A14 | Deferral
P003729944 | 2552887 | 461.78 | ISCEN | A14
P002816865 | 2568220 | -688.5 | ISCEN | A14
P003715660 | 2568220 | 306.75 | ISCEN | A14
P002817024 | 2565647 | -573.75 | ISCEN | A14
P003742161 | 2565647 | 238.2 | ISCEN | A14
P002817145 | 2597284 | -661.5 | ISCEN | A11
P003708693 | 2597284 | 305.62 | ISCEN | A11
P003374465 | 2614551 | -688.5 | ISCEN | A14
P003731363 | 2614551 | 472.96 | ISCEN | A14
P003744035 | 2660187 | 463 | ISCEN | A14
P002810961 | 2434413 | -33.1 | ISCEN | A14
P002808884 | 2413093 | -204.08 | ISCEN | A11
P002808906 | 2417066 | -138.83 | ISCEN | A11
P002808907 | 2413086 | -138.83 | ISCEN | A11
P002812714 | 2484644 | -285.62 | ISCEN | A11
P002812715 | 2483158 | -285.62 | ISCEN | A11
P002808481 | 2409824 | -167.01 | ISCEN | A11
P002808492 | 2371250 | -319.6 | ISCEN | A11
P002809107 | 2413600 | -370.6 | ISCEN | A14
P002810202 | 2424020 | -411.71 | ISCEN | A11
P002810315 | 2429703 | -392.28 | ISCEN | A14
P002810791 | 2443293 | -343.18 | ISCEN | A14
P002811177 | 2417803 | -450.3 | ISCEN | A14
P002811702 | 2451836 | -485.8 | ISCEN | A14
P002811790 | 2459600 | -180.86 | ISCEN | A11
P002812852 | 2426096 | -366.66 | ISCEN | A14
P003717202 | 2434413 | -659.27 | ISCEN | A14
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
 |  | -659.27
Spreadsheet: 763722d1642349983-find-some-with-consecutive-days-book1
Sheet: Sheet1

 | 2020-11-11 00:00:00 |  |  |  |  |  |  |  |  |  | 0.9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Consec. Days: | 20 | [NAME]: | ???
 | 2020-12-14 00:00:00 |  |  |  |  |  |  |  |  |  | 2.1
 | 2021-01-01 00:00:00 |  |  |  |  |  |  |  |  |  | 0.1
 | 2021-01-02 00:00:00 |  |  |  |  |  |  |  |  |  | 0.1
 | 2021-01-03 00:00:00 |  |  |  |  |  |  |  |  |  | 0.1
 | 2021-01-04 00:00:00 |  |  |  |  |  |  |  |  |  | 0.1
 | 2021-01-05 00:00:00 |  |  |  |  |  |  |  |  |  | 0.1
 | 2021-01-06 00:00:00 |  |  |  |  |  |  |  |  |  | 0.1
 | 2021-01-07 00:00:00 |  |  |  |  |  |  |  |  |  | 0.1
 | 2021-01-08 00:00:00 |  |  |  |  |  |  |  |  |  | 0.1
 | 2021-01-09 00:00:00 |  |  |  |  |  |  |  |  |  | 0.1
 | 2021-01-10 00:00:00 |  |  |  |  |  |  |  |  |  | 0.1
 | 2021-01-11 00:00:00 |  |  |  |  |  |  |  |  |  | 0.1
 | 2021-01-12 00:00:00 |  |  |  |  |  |  |  |  |  | 0.1
 | 2021-01-13 00:00:00 |  |  |  |  |  |  |  |  |  | 0.1
 | 2021-01-14 00:00:00 |  |  |  |  |  |  |  |  |  | 0.1
 | 2021-01-15 00:00:00 |  |  |  |  |  |  |  |  |  | 0.1
 | 2021-01-16 00:00:00 |  |  |  |  |  |  |  |  |  | 0.1
 | 2021-01-17 00:00:00 |  |  |  |  |  |  |  |  |  | 0.1
 | 2021-01-18 00:00:00 |  |  |  |  |  |  |  |  |  | 0.1
 | 2021-01-19 00:00:00 |  |  |  |  |  |  |  |  |  | 0.1
 | 2021-01-20 00:00:00 |  |  |  |  |  |  |  |  |  | 0.1
 | 2021-01-21 00:00:00
 | 2021-01-22 00:00:00
 | 2021-01-23 00:00:00
 | 2021-01-24 00:00:00 |  |  |  |  |  |  |  |  |  | 0.6
 | 2021-02-22 00:00:00 |  |  |  |  |  |  |  |  |  | 0.9
Spreadsheet: darrell_schoolcraft__7775__imbalsumm0106
Sheet: Agave

Agave imbalance
 | Measured | Scheduled | Imbalance
56339 | 717076 | 774860
500232 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500238 | 709036 | 710067 |  |  |  |  |  |  |  |  | lunch | 7.6
500239 |  | 874261
500293 | 364411 | 465324
500302 | 8629
500303 |  | 255445
500305 | 776750 | 1042887
500307 | 50122 | 49795
500313 |  | 2365
500314
500655 | 561514
500657 | 164543 | 137550
INDEX
2001-05-31 00:00:00 |  |  | 151158.36
2001-06-23 00:00:00
Spreadsheet: darrell_schoolcraft__7792__imbalsumm0107
Sheet: Oasis

POI  8516
 | Measured | Scheduled | Imbal
1 | -137341 | -136796
2 | -125680 | -124374
3 | -103730 | -110538
4 | -64504 | -65000
5 | -65339 | -64480
6 | -110873 | -111438
7 | -104259 | -103558
8 | -123476 | -123233
9 | -115393 | -114855
10 | -91816 | -91920
11 | -44422 | -44371
12 | -18430 | -18414
13 | -44797 | -44092
14 | -194555 | -194162
15 | -206012 | -204162
16 | -194790 | -194162
17 | -77025 | -77300
18 | -126017 | -123466
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2001-06-30 00:00:00 |  | 28278
 | 2001-07-18 00:00:00
Spreadsheet: 164351d1340731672-macro-question-copying-rows-into-worksheets-based-on-criteria-of-a-specific-column-testing-account
Sheet: MAIN

Account | Program | Revenue | [NAME] | Net
0260-100 | AAA | 100 | 50
0260-100 | AAA | 250 | 50
0260-100 | AAA | 150 | 50
0260-100 | AAA | 100 | 0
0260-100 | AAA | 75 | 25
0260-200 | BBB | 50 | 0
0260-300 | CCC | 500 | 75
0260-100 | AAA | 225 | 0
0260-200 | BBB | 75 | 0
0260-200 | BBB | 45 | 0
0260-200 | BBB | 80 | 0
0260-200 | BBB | 110 | 0
0260-500 | EEE | 50 | 50
0260-500 | EEE | 75 | 25
0260-400 | DDD | 355 | 100
0260-100 | AAA | 145 | 50
0260-300 | CCC | 575 | 75
0260-300 | CCC | 600 | 75
Spreadsheet: 118049d1313410282-text-to-columns-with-no-delimiters-book1
Sheet: Sheet1

Rijon Manufacturing Company 13733 Chatham Street Blue Island IL (708) 388-3629 | Rijon Manufacturing Company | 13733 Chatham Street | Blue Island | IL | (708) 388-3629 |  |  |  | Street
Ideal Carbide Die Company 625 Woodcreek Drive Bolingbrook IL (630) 759-1810 | Ideal Carbide Die Company | 625 Woodcreek Drive | Bolingbrook | IL | (630) 759-1810 |  |  |  | Road
Thermo Systems Tool & Mold, Inc. 751 N Bolingbrook Drive Bolingbrook IL (630) 226-0252 | Thermo Systems Tool & Mold, Inc. | 751 N Bolingbrook Drive | Bolingbrook | IL | (630) 226-0252 |  |  |  | Avenue
Visco Machine 317 Rockhurst Road Bolingbrook IL (630) 739-9045 | Visco Machine | 317 Rockhurst Road | Bolingbrook | IL | (630) 739-9045 |  |  |  | Drive
R C Machine Shop [NAME] (815) 935-5350 | R C Machine Shop | 240 W Johnson Avenue | Bonfield | IL | (815) 935-5350 |  |  |  | Boulevard
C & M Engineering 1220 Larry Power Road Bourbonnais IL (815) 932-3388 | C & M Engineering | 1220 [NAME] | Bourbonnais | IL | (815) 932-3388
M X Tech 4136 W 6940n Road Bourbonnais IL (815) 936-6277 | M X Tech | 4136 W 6940n Road | Bourbonnais | IL | (815) 936-6277
Spreadsheet: 187428d1350459570-lookup-to-same-code-number-that-has-double-value-prototaip-advance-progressive
Sheet: Master

 | [NAME] by Name: | BODY, WELDMENT, 18-3/4 IN HOUSING,STM15
 | [NAME]Number | 2018507-22 |  |  | QP BASED ON PART NUMBER Number
 |  |  |  |  | [NAME] : Number
 | Part Description
 |  |  |  |  |  | Records Furnished to Customer | Records Reviewed by Third Party
 | Standard manufacturing process |  | Standard Documentation involve
 | Standard Quality Inspection |  | Standard BOM requirement
 | Reference Part : |  | Sub-assembly component (optional)
Spreadsheet: 682155d1591930163-help-investment-tracker-with-foreign-currency-excel-spreadsheet-portfolio
Sheet: CORE

ASSET | Stock | Price | P1 | P1 AUD | P2 | P2 AUD | P3 | P3 AUD | [NAME] | Capital Gains AUD | Currency Gains | Currency Gains AUD | Profit/Loss | Country | Total AUD | Weight
 |  |  |  |  |  |  |  |  |  |  |  |  |  | USD
 |  |  |  |  |  |  |  |  |  |  |  |  |  | USD
 |  |  |  |  |  |  |  |  |  |  |  |  |  | USD
 |  |  |  |  |  |  |  |  |  |  |  |  |  | USD
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AUD
 |  |  |  |  |  |  |  |  |  |  |  |  |  | HKG
 |  |  |  |  |  |  |  |  |  |  |  |  |  | USD
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AUD
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AUD
 |  |  |  |  |  |  |  |  |  |  |  |  |  | EUR
 |  |  |  |  |  |  |  |  |  |  |  |  |  | AUD
Spreadsheet: 117056d1312413022-auto-populate-a-sheet-based-on-criteria-in-another-sheet-example
Sheet: Data

Employee Name | Total Meetings | Arrived at | Percentage | Address | Phone
[NAME] | 10 | 7 | 0.7 | 123 Baker St | [PHONE]
[NAME] | 10 | 5 | 0.5 | 124 [NAME] | [PHONE]
[NAME] | 10 | 4 | 0.4 | 125 [NAME] | [PHONE]
[NAME] | 10 | 9 | 0.9 | 126 [NAME] | [PHONE]
[NAME] | 10 | 3 | 0.3 | 127 [NAME] | [PHONE]
Maria | 10 | 10 | 1 | 128 [NAME] | [PHONE]
[NAME] | 10 | 8 | 0.8 | 129 [NAME] | [PHONE]
[NAME] | 10 | 8 | 0.8 | 130 [NAME] | [PHONE]
Spreadsheet: 792444d1660908440-formula-with-multiple-matches-training-example-v2
Sheet: Oct 2022

Trainer | 2022-10-03 00:00:00 | 2022-10-04 00:00:00 | 2022-10-05 00:00:00 | 2022-10-06 00:00:00 | 2022-10-07 00:00:00 | 2022-10-10 00:00:00 | 2022-10-11 00:00:00 | 2022-10-12 00:00:00 | 2022-10-13 00:00:00 | 2022-10-14 00:00:00 | 2022-10-17 00:00:00 | 2022-10-18 00:00:00 | 2022-10-19 00:00:00 | 2022-10-20 00:00:00 | 2022-10-21 00:00:00 | 2022-10-24 00:00:00 | 2022-10-25 00:00:00 | 2022-10-26 00:00:00 | 2022-10-27 00:00:00 | 2022-10-28 00:00:00 | 2022-10-31 00:00:00 | Training days | AL | Personal | Development
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Clive Barber
[NAME]
[NAME]
[NAME]
[NAME] R
[NAME]
Jan Nascimento
[NAME]
[NAME]
[NAME]
Clare Hazelwood
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Enforcement
Spreadsheet: 24831224-627d-466d-8f42-16ced77f8298
Sheet: Beth U15-U18 - Dec 16

Sunday December 16th
Home Club: | Loudoun |  | Locations: | Loudoun Soccer Park
[NAME]: | Bethesda |  | Field Directions:
Loudoun Soccer wears Red shirts, Black shorts, Red socks |  |  | http://www.loudounsoccer.com/Default.aspx?tabid=193688
Loudoun Soccer Park #1
U15/16 (40 mins x2) + U17/U18 (45 mins x2)
 | Time | Teams
 | 9am | U18B
 | 11am | U17B
 | 1pm | U17G
 | 3pm | [NAME]
Loudoun Soccer Park #2
U15/16 (40 mins x2) + U17/U18 (45 mins x2)
 | Time | Teams
 | 9am | U15B
 | 11am | U16G
 | 1pm | U15G
 | 3pm | U16B
Spreadsheet: 706872d1606931507-need-an-if-formula-for-pulling-inventory-numbers-example
Sheet: Quotation

 |  |  |  |  | Quotation
 |  |  |  |  | DATE OF QUOTE | Sept. 21st 2020
 |  |  |  |  | Customer #
 | Quotation For:
 | Name |  |  |  | Prepared by:
 | Company Name |  |  |  | SLOC # | 9
 | Street Address
 | City, ST, Zip
 | Phone
 |  |  |  |  | T = Taxable or      Leave Blank
 | PART NUMBER | QTY | [NAME] | UNIT PRICE | TAXABLE? | AMOUNT |  | Current Inventory
 |  |  |  |  | SUBTOTAL
 | [NAME] FOR 30 DAYS FROM DATE OF QUOTE |  |  |  | TAX RATE
 |  |  |  |  | SALES TAX
 |  |  |  |  | OTHER | 0
 |  |  |  |  | TOTAL
Spreadsheet: 53124d1253048382-vlookup-or-index-match-sample-9-15-09
Sheet: DATA 1

SALES REPORT
 |  |  |  |  |  |  |  | NYC
AAA ITEM NBR | BBB ITEM NBR | BRAND |  | PRODUCT DESCRIPTION | PACK | SIZE |  | April | May | June | July | August
OLIVES |  |  |  |  |  |  |  | CASE QUANTITY | CASE QUANTITY | CASE QUANTITY | CASE QUANTITY | CASE QUANTITY
9173011 | 231872 | AAA |  | Sliced Black Olives | 6 | A10 |  |  | 40 | 80 | 70
 | 246217 | AAA |  | Sliced Black Olives | 10 | 33 oz Pouch
9173313 | 231829 | AAA |  | Medium Pitted Black Olives | 6 | A10 |  |  | 4
9173015 | 231824 | AAA |  | Sliced Green Olives | 6 | A10
9236 | 79264 | AAA |  | Sliced Green Olives | 4 | 1 Gal.
9173511 | 231863 | AAA |  | Whole Queen Olives, 160 / 180 Ct. | 4 | 1 Gal.
9173530 | 231866 | AAA |  | Stuffed Queen Olives, 140 / 160 Ct. | 4 | 1 Gal. |  |  | 6 | 3 | 48
9173531 | 231879 | AAA |  | [NAME]. Olives 340 / 360 Ct. | 4 | 1 Gal. |  |  | 24
PEPPERS AND PEPPERONCINI
9452048 | 232061 | Piancone |  | Fire Roasted Red Peppers | 6 | A10
9452056 | 231098 | Assoluti |  | Fire Roasted Red Peppers- Grade B | 6 | A10
9452045 | 231623 | AAA |  | Fire Roasted Red Peppers | 12 | 28 oz
9176001 | 232034 | Piancone |  | Green & Red Pepper Strips | 6 | A10
9176002 | 79214 | Piancone |  | [NAME] | 6 | A10
9452005 | 231651 | AAA |  | [NAME] | 4 | 1 Gal
9452010 | 118561 | AAA |  | [NAME] | 1 | 5 Gal
9452015 | 231203 | AAA |  | Sliced [NAME] | 4 | 1 Gal
9452022 | 231210 | AAA |  | Nacho Sliced Jalapeno Peppers | 6 | A10 |  |  | 56 |  | 112
9452017 | 128341 | AAA |  | Nacho Sliced Jalapeno Peppers | 4 | 1 Gal
52544 | 231701 | AAA |  | [NAME] | 4 | 1 Gal
ARTICHOKES
9459013 | 234253 | AAA |  | [NAME], 30 / 40 Ct. | 6 | 3 KG
9459010 | 231717 | AAA |  | [NAME], 5 / 7 Ct. | 24 | 14 oz
9459027 | 231702 | AAA |  | Quartered [NAME] | 6 | 3 KG |  |  | 16 | 16
Spreadsheet: 682155d1591930163-help-investment-tracker-with-foreign-currency-excel-spreadsheet-portfolio
Sheet: DIVIDENDS

Dividends
CORE |  |  |  |  | CYCLICAL |  |  |  |  | OPPORTUNISTIC |  |  |  |  | RISK MANAGEMENT |  |  |  |  | INFLOWS/OUTFLOWS
Date | Stock | Currency | Dividend |  | Date | Stock | Currency | Dividend |  | Date | Stock | Currency | Dividend |  | Date | Stock | Currency | Dividend |  | Date | Stock | Currency | Amount
2020-03-17 00:00:00 | V |  | 4.43 |  |  |  |  |  |  | 2020-04-23 00:00:00 | TT |  | 11.29 |  | 2020-04-23 00:00:00 | IEF |  | 100
2020-06-05 00:00:00 | V |  | 4.02
Spreadsheet: 809899d1671416191-creating-formula-help-if-statement-i-want-it-to-do-if-statement-on-sheet-placement-file-working-project
Sheet: Placement File

 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26
Pitch | EC | FL | VP | WS | SC | Reg | CT | Aug | Sep | Oct | N | S | [NAME] | Cold W | Str Cnt
test 1 | N | N | N | Y | N | N | N | Y | y | y | Y | Y | Y | Y | 1815
test 2 | N | Y | N | Y | N | N | N | Y | Y | Y | Y | Y | Y | Y | 1815
test 1 test | N | N | N | Y | N | N | N | Y | Y | Y | Y | Y | Y | Y | 1815
Link2Home Brand extension cord | N | N | N | Y | N | N | N | Y | Y | Y | Y | Y | Y | Y | 1815
Link2Home Brand extension cord + outlet | N | N | Y | N | N | N | N | N | Y | N | Y | Y | Y | Y | 1815
Wrap-It Storage - 12" Quick-Straps Counter Display | N | N | N | N | N | N | Y | Y | Y | Y | Y | Y | Y | Y | 1815
[NAME] 14/3 25ft Single Lighted Tap Extension Cord | Y | Y | Y | Y | N | N | N | Y | Y | Y | Y | Y | Y | Y | 1815
screen prot | Y | Y | Y | Y | N | N | N | Y | Y | Y | Y | Y | Y | Y | 1815
hard hats | Y | Y | Y | Y | N | N | N | Y | Y | Y | N | N | N | Y | 1815
hard hats test 1 | Y | Y | Y | Y | N | N | N | Y | Y | Y | Y | Y | Y | Y | 1815
150 Lumens Pocket Work Light | N | N | N | Y | N | N | Y | Y | Y | Y | Y | N | N | Y | 1815
300lm Mini Travel Work Light +battery level indicator | N | N | N | Y | N | N | N | Y | Y | Y | Y | Y | Y | Y | 1815
500lm/200LM Mini  Work Light 2 pack | Y | Y | Y | Y | N | N | N | Y | Y | Y | N | Y | Y | Y | 1815
1000 Lumens Portable Work Light
Spreadsheet: 2ae39f09-5cc3-4461-8f77-fbe018e2e5e5
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
5389 | 21751 | [NAME] | [NAME] | CZE | 94 | 00:15:58 | [NAME] | 00:22:11 | 00:00:59 | [NAME] | 1 | 01:01:12
5389 | 28243 | Emilie | Moberg | NOR | 95 | 00:16:49 | 00:00:35 | 00:22:15 | 00:01:22 | [NAME] | 2 | 01:03:00
5389 | 39491 | Ekaterina | Mineava | RUS | 0 | 00:15:58 | 00:00:45 | 00:23:38 | 00:01:09 | [NAME] | 3 | 01:03:27
5389 | 28252 | Natalia | Skuratovich | RUS | 96 | 00:17:22 | 00:00:48 | 00:23:34 | 00:01:03 | 00:25:20 | 4 | 01:08:07
5389 | 39351 | Marthe | Trønnes | NOR | 98 | 00:18:06 | 00:00:43 | 00:24:53 | 00:00:16 | [NAME] | 5 | 01:09:08
Spreadsheet: 164903d1340957853-returning-values-based-on-date-falling-between-date-ranges-date-calc-problem-with-examples
Sheet: Sheet1

Variable value to be inputted by user | Needs the value appearing in column G,  if the value in A5 is (less than F5, then return G5), if its equal or more than F5 but less than F6, then return G6), if its equal or more than F6 but less than F7, then return G7 ) and so on…….
2012-06-29 00:00:00 |  |  |  |  | 2012-06-30 00:00:00 | 3
 |  |  |  |  | 2012-07-15 00:00:00 | 4
Examples | Value should return as |  |  |  | 2012-07-31 00:00:00 | 5
2012-06-29 00:00:00 | 3 |  |  |  | 2012-08-15 00:00:00 | 6
2012-06-30 00:00:00 | 3 |  |  |  | 2012-08-31 00:00:00 | 7
2012-07-01 00:00:00 | 4 |  |  |  | 2012-09-15 00:00:00 | 8
2012-07-14 00:00:00 | 4 |  |  |  | 2012-09-26 00:00:00 | 9
2012-07-15 00:00:00 | 4
2012-07-16 00:00:00 | 5
2012-08-14 00:00:00 | 6
2012-08-15 00:00:00 | 6
2012-09-25 00:00:00 | 9
2012-09-26 00:00:00 | 9