tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 859068d1707510546-excel-formula-split-over-time-periods
Sheet: Sheet1

From | To | Break | Hours | 00:00 to 18:00 | 18:00 to 20:00 | 20:00 to 24:00 | 24:00 to 00:00 | Total | Check
06:00:00 | 18:00:00 | 00:30:00
05:59:00 | 18:00:00 | 00:30:00
23:00:00 | 01:00:00 | 00:30:00
00:00:00 | 06:00:00 | 00:30:00
1900-01-01 00:00:00 | 06:00:00 | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
 |  | 00:30:00
https://www.excelforum.com/excel-formulas-and-functions/1419338-excel-formula.html
Spreadsheet: 167363d1341961555-excel-2007-copying-editing-conditional-sum-formulas-check-register
Sheet: CHECK REG. PIVOT TABLE

Account | Check # | Sum of Credit
Calumet | 1511 | 247.7
 | 1524 | 396.7
 | 1548 | 238.3
 | 1567 | 962.95
 | 1578 | 218.45
 | 1594 | 133.75
Calumet Total |  | 2197.85
Glazer/Olinger | 1510 | 115.02
 | 1521 | 2132.9
 | 1546 | 335
 | 1564 | 269.4
Glazer/Olinger Total |  | 2852.32
National | 1562 | 1600.55
National Total |  | 1600.55
Northcoast | 1513 | 553.45
 | 1528 | 1087.36
 | 1551 | 1600.7
 | 1576 | 2761.4
 | 1600 | 2405.7
Northcoast Total |  | 8408.61
Pepsi | 1522 | 134.79
 | 1565 | 157.62
 | 1590 | 174.75
Pepsi Total |  | 467.16
Republic National | 1517
 | 1520 | 1259.26
 | 1529 | 709.5
 | 1574 | 785.17
Republic National Total |  | 2753.93
Roasted Tomato | 1514 | 1944.91
 | 1525 | 2322.86
 | 1554 | 2336.9
 | 1570 | 2159.43
 | 1579 | 2782.88
 | 1603 | 2142.99
Roasted Tomato Total |  | 13689.97
Roasted Tomato Supplies | 1596 | 49.5
 | 1602 | 29.5
Roasted Tomato Supplies Total |  | 79
[NAME] | 1553 | 687
 | 1573 | 84.74
 | 1585 | 388
Safari Marketing Total |  | 1159.74
Southern Wine and Spirits | 1519 | 1786
 | 1547 | 132
 | 1560 | 2152.41
 | 1599 | 228
Southern Wine and Spirits Total |  | 4298.41
Grand Total |  | 37507.54000000001
Spreadsheet: 871102d1717533672-would-like-to-add-automatic-date-and-day-yearly-xda-sickness-file
Sheet: NOVEMBER 

 | DATE | DAY | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE
 |  |  | Total Hours |  |  |  | Total Hours |  |  |  | Total Hours |  |  |  | Total Hours |  |  |  | Total Hours |  |  |  | Total Hours |  |  |  | Total Hours |  |  |  | Total Hours |  |  |  | Total Hours
 | DATE | DAY | STAFF NAME | PAY | TOIL
 |  |  | TOTALS
Spreadsheet: 23760d1213476284-sorting-cells-sort-colum1
Sheet: Sheet1

Ami |  |  |  |  |  |  | Ola | [NAME] | Tami | Fareed | Ami | [NAME] | Lina | [NAME] | Noor
[NAME]
Fareed |  |  |  |  |  |  | Ami | [NAME] | Fareed | [NAME] | Lina | [NAME] | Noor | Ola | Tami
[NAME]
Lina
[NAME]
Noor
Ola
Tami
Spreadsheet: 780304d1652378966-return-blank-when-the-dates-from-to-are-not-within-those-dates-range-formula-date-range
Sheet: Payroll Week

Payroll Week
TASKS LIST | 2022-05-09 00:00:00
Missing Comp Plan (HX_TL_EMP_MISSING_COMPPLAN_ENR)
 | Start | End
Missing Comp Plan Query | 2022-04-27 00:00:00 | 2022-05-06 00:00:00 | [NAME]
Payroll Wed through Maint Friday | 2022-05-11 00:00:00 | 2022-05-20 00:00:00 | [NAME]
 |  |  | Ana
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | Ana
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | Ana
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | Ana
 |  |  | [NAME]
Spreadsheet: 160850d1339249741-arranging-in-order-highest-to-lowest-rank-row
Sheet: Sheet1

Rank | Name | Weight | Name of fish |  | Rank | Name | Weight | Name of fish
 | Name1 | 120 | [NAME]
 | [NAME] | 134 | Dog
 | Name3 | 210 | cat
 | Name4 | 110 | Pig
 | Name5 | 210 | Fox
Spreadsheet: 670319d1585834905-text-numbers-to-numbers-number-conversion-pg-0-cci
Sheet: Sheet1

 |  |  | +$35,167.45 | +$35,171.69 | +$61.55 | -$65.79
429.000 |  |  | +$35,167.45 | +$35,171.69 | +$61.55 | -$65.79
3.000 | 11/14/2011 | 12/28/2018 | +$275.31 | +$194.44 | -- | +$80.87
1.213 | 02/15/2012 | 11/26/2018 | +$111.04 | +$78.75  s* | -- | +$32.29
1.282 | 08/15/2012 | 11/26/2018 | +$117.36 | +$85.73  s* | -- | +$31.63
1.295 | 11/15/2012 | 11/26/2018 | +$118.55 | +$86.45  s* | -- | +$32.10
1.007 | 11/16/2015 | 11/26/2018 | +$92.18 | +$74.75  s* | -- | +$17.43
5.219 | 05/15/2018 | 11/26/2018 | +$477.76 | +$382.36  s* | +$95.40 | --
38.984 | 11/14/2011 | 11/26/2018 | +$3,568.71 | +$2,526.75  s* | -- | +$1,041.96
1.133 | 11/15/2013 | 10/16/2018 | +$91.38 | +$95.40 | -- | -$4.02
1.136 | 02/15/2013 | 10/16/2018 | +$91.62 | +$87.18 | -- | +$4.44
1.170 | 08/15/2013 | 10/16/2018 | +$94.37 | +$94.70 | -- | [NAME]
1.182 | 05/15/2013 | 10/16/2018 | +$95.33 | +$93.99 | -- | +$1.34
1.194 | 11/17/2014 | 10/16/2018 | +$96.30 | +$105.23 | -- | -$8.93
1.209 | 02/18/2014 | 10/16/2018 | +$97.51 | +$96.09 | -- | +$1.42
1.233 | 02/17/2015 | 10/16/2018 | +$99.45 | +$106.00 | -- | -$6.55
1.271 | 08/15/2014 | 10/16/2018 | +$102.51 | +$104.41 | -- | -$1.90
1.276 | 05/15/2014 | 10/16/2018 | +$102.91 | +$103.59 | -- | -$0.68
1.360 | 05/15/2015 | 10/16/2018 | +$109.69 | +$109.99 | -- | -$0.30
1.378 | 02/16/2016 | 10/16/2018 | +$111.14 | +$112.86 | -- | -$1.72
1.464 | [NAME] | 10/16/2018 | +$118.08 | +$110.89 | -- | +$7.19
0.500 | 11/16/2015 | 10/16/2018 | +$40.32 | +$37.12 | -- | +$3.20
3.822 | 02/15/2017 | 10/16/2018 | +$308.26 | +$343.26 | -- | -$35.00
3.862 | 08/15/2016 | 10/16/2018 | +$311.49 | +$337.95 | -- | -$26.46
3.905 | 08/15/2017 | 10/16/2018 | +$314.95 | +$359.03 | -- | -$44.08
4.062 | 11/15/2016 | 10/16/2018 | +$327.62 | +$340.54 | -- | -$12.92
4.078 | 11/15/2017 | 10/16/2018 | +$328.91 | +$361.73 | -$32.82 | --
4.109 | 05/15/2017 | 10/16/2018 | +$331.41 | +$356.20 | -- | -$24.79
4.149 | [NAME] | 10/16/2018 | +$334.63 | +$335.18 | -- | -$0.55
4.507 | 02/15/2018 | 10/16/2018 | +$363.51 | +$364.54 | -$1.03 | --
329.000 | 03/31/2016 | 10/16/2018 | +$26,535.15 | +$27,686.58 | -- | -$1,151.43
Spreadsheet: 865968d1712910298-index-indirect-match-query-exampletest
Sheet: March 24

1 | Yes | [NAME] | No
2 | Yes | Fred | Yes
3 | No | [NAME] | Yes
4 | No | [NAME] | No
5 | Yes | [NAME] | Yes
6 | No | [NAME] | Yes
7 | Yes | Sue | No
Spreadsheet: 702856d1604576972-formula-not-working-when-name-changed-cycle-pay
Sheet: Cycle data

 | Name: | [NAME]
 | Week start | 2020-11-05 00:00:00 |  |  |  |  | when I change C1 back to [NAME] everything is fine but change it back to Pa or [NAME] no data appears - Names are fed from the name sheet
 | [NAME] | Cycle | Claimed | Paid To Part
 |  |  |  |  | + / -
 |  | Totals
Spreadsheet: 51924d1251495976-drag-fill-skipping-a-lot-of-rows-updated-psp-outreach-report-template-08-25-09-fs
Sheet: August

 |  | Week of 7/26 - 8/01 | Week of 8/02 - 8/08 | Week of 8/09 - 8/15 | Week of 8/16 - 8/22 | Week of 8/23 - 8/31
School:
Previous Units:
Previous GPA:
GPA Trend:
[NAME]. GPA:
Class Standing:
Previously Full-Time:
Currently Full-Time:
Outreach Frequency:
Independence Status:
Program Standing:
School:
Previous Units:
Previous GPA:
GPA Trend:
[NAME]. GPA:
Class Standing:
Previously Full-Time:
Currently Full-Time:
Outreach Frequency:
Independence Status:
Program Standing:
Spreadsheet: 733126d1621409778-how-do-i-remove-duplicates-from-multiple-columns-so-that-only-unique-ones-remain-duplicates123
Sheet: Sheet1

Customernumber | Name | Product
51594886 | Aage OS | SU52437
51594886 | Aage OS | SU52437
51594886 | Aage OS | SU52437
51535221 | Aagot La | PP87592
51535221 | Aagot La | PR38042
51535474 | Aasa Br | RZ41688
105226039 | Aase Ei | TV92698
105341729 | Aase FL | PR33298
51095882 | Aase He | AE39764
51095882 | Aase He | HB82012
106861401 | Aase VH | KH29793
106861401 | Aase VH | NV64431
106958813 | Aase WJ | NF17362
106994644 | Aashild DV | EL58878
106994644 | Aashild DV | EK34850
51412117 | [NAME] | NV73848
107743262 | Aasmund IB | VH13668
107743262 | Aasmund IB | VX35420
51523844 | Aasmund Le | VF45680
51523844 | Aasmund Le | VH72923
106925923 | Aasne VH | UF55526
108114012 | Abdelhak H | DK76004
105698185 | Abdelouahid elH | DL85010
107330413 | Abdirahman A | AR98979
Spreadsheet: 471042d1468849898-i-need-an-excel-formula-that-will-show-negative-in-the-variance-line-if-actual-is-zero-copy-of-excel-formula
Sheet: Sheet2

 |  |  | 2016-10-01 00:00:00 | 2016-11-01 00:00:00 | 2016-12-01 00:00:00 | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | 2016-04-01 00:00:00 | 2016-05-01 00:00:00 | 2016-06-01 00:00:00 | 2016-07-01 00:00:00 | 2016-08-01 00:00:00 | 2016-09-01 00:00:00
 |  | plan | 25 | 30 | 35 | 40 | 45 | 50 | 60 | 70 | 80 | 105 | 120 | 130
 |  | actual | 1 | 2 | 3 | 0 | 5 | 0 | 7 | 8 | 9 | 10 | 0 | 0
Spreadsheet: ac2b9db4-490d-43f8-a6b6-e2457c790c4c
Sheet: Pounds

County Population, Waste Disposal, Per Capita Rate and Percent Reduction, FY 2010-2011
County | Population July 2010 | MSW Pounds Managed 1991-1992 | MSW and C&D Pounds Disposed 2006-2007 | MSW and C&D Pounds Disposed 2007-2008 | MSW and C&D Pounds Disposed 2008-2009 | MSW and C&D Pounds Disposed 2009-2010 | MSW and C&D Pounds Disposed 2010-2011 | Base Year Per Capita 1991-1992 (pounds/person) | Per Capita 2010-2011 (pounds/person) | % Change from Base Year 1991-1992
Alamance | 151745
[NAME] | 37254
Alleghany | 11171
[NAME] | 26973
[NAME] | 27378
Avery | 17812
Beaufort | 47929
Bertie | 21267
Bladen | 35243
Brunswick | 108176
Buncombe | 239179
Burke | 91008
Cabarrus | 179025
Caldwell | 83176
Camden | 10000
[NAME] | 66712
Caswell | 23676
Catawba | 154654
Chatham | 63870
Cherokee | 27527
[NAME] | 14762
Clay | 10622
Cleveland | 98249
Columbus | 58204
Craven | 104147
Cumberland | 326673
Currituck | 23559
Dare | 33886
[NAME] | 163488
Davie | 41378
Duplin | 58729
[NAME] | 268925
Edgecombe | 56681
[NAME] | 351798
Franklin | 60978
Gaston | 206384
Gates | 12214
[NAME] | 8888
Granville | 60547
Greene | 21277
Guilford | 490371
Halifax | 54627
Harnett | 115579
Haywood | 59148
Henderson | 107177
Hertford | 24822
Hoke | 47376
Hyde | 5783
Iredell | 160107
[NAME] | 40480
Johnston | 170151
Jones | 10159
[NAME] | 58059
Lenoir | 59493
Lincoln | 78684
Macon | 33946
[NAME] | 20795
Martin | 24498
McDowell | 45031
Mecklenburg | 923944
Mitchell | 15588
Montgomery | 27992
Moore | 88594
Nash | 96215
New Hanover | 203439
Northampton | 22111
Onslow | 185304
Orange | 134325
Pamlico | 13136
Pasquotank | 40605
Pender | 52504
Perquimans | 13486
Person | 39585
Pitt | 169378
Polk | 20588
Randolph | 142127
Richmond | 46600
Robeson | 134502
Rockingham | 93764
[NAME] | 138651
Rutherford | 68006
Sampson | 63481
Scotland | 36098
Stanly | 60714
Stokes | 47478
[NAME] | 73791
Swain | 14020
Transylvania | 33189
Tyrrell | 4390
Union | 202592
Vance | 45477
Wake | 907314
[NAME] | 21031
Washington | 13224
Watauga | 51326
Wayne | 122893
Wilkes | 69419
Wilson | 81643
Yadkin | 38451
Yancey | 17802
STATE TOTAL
Percent Change formula: (current year per capita minus base year per capita) divided by base year per capita
Spreadsheet: 89833d1289560085-excel-workbook-link-wont-update-without-open-book2
Sheet: Sheet1

ABCDE | FGHIJK
A | 1
B | 2
C | 3
D | 4
E | 5
AA | 11
BB | 22
CC | 33
DD | 44
EE | 55
Spreadsheet: 836513d1689433523-index-match-using-multiple-criteria-smaple
Sheet: Sheet1

 |  |  |  |  | Company Name | Emp Name | Month | Invoice
 |  |  |  |  | Knight Consulting | [NAME] | May | 1000
 |  |  |  |  | Knight Consulting | [NAME] | May | 1500
 |  |  |  |  | Alpha Solutions | [NAME] | May | 1200
 |  |  |  |  | Precision Plus | [NAME] | April | 1650
 |  |  |  |  | Alpha Solutions | [NAME] | April | 900
 |  |  |  |  | Alpha Solutions | [NAME] | March | 1800
 |  |  |  |  | Precision Plus | [NAME] | March | 1475
 |  |  |  |  | Precision Plus | [NAME] | March | 1325
 |  |  |  |  | Alpha Solutions | [NAME] | March | 2000
 |  |  |  |  | Emp Name | [NAME]
 |  |  |  |  | Month | May
 |  |  |  |  | Company Name | Alpha Solutions
 |  |  |  |  | Invoice
Spreadsheet: 864615d1711712794-please-help-to-create-accounting-sheet-accounts-follow-up-list-2024
Sheet: Purchase Orders

Purchase Orders
Name: | Company: | PO Number: | Description: | Opening Balance: | Remaining balance: | Complete: | Comments:
SS | Company 1 | PO00001 | The PO number should be shown in drop down menue in invoice tab. As on invoice tab I used this PO0001 3 times for 700 + 200 + 100 = 1000, zero remaining balance remaining. | 1000
SS | Company 2 | PO00002 | The PO number should be shown in d;rop down menue in invoice tab. | 1000
SS | Company 3 | PO00003 | The PO number should be shown in d;rop down menue in invoice tab. | 1000
Spreadsheet: 41661d1240224240-duplicating-rows-by-a-set-number-book2
Sheet: Sheet1

Store No. | Name | Warehouse | Boxes
1111 | London | South | 20
2222 | [NAME] | North | 10
3333 | Birmingham | South | 15
4444 | Leicester | North | 20
5555 | Blackpool | North | 10
Spreadsheet: 033d4855-ec7b-4602-8b8c-aaab9c75b6fc
Sheet: 13b

 |  | Dealers** |  |  | Buyside |  |  | TOTAL
Product |  | HY*** | IG | Other | HY | IG | Other | HY | IG | Other
Index Tranche* | Asia |  | <100 | 440 |  | <100 |  |  |  | 440
 | Europe |  |  | 827129 |  |  | 86833 |  |  | 913962
 | North America | 106632 | 772564 | 17060 | 9061 | 23279 | 912 | 115693 | 795843 | 17972
Index | Asia | 3545 | 90251 | 161483 | 284 | 8732 | 34446 | 3829 | 98983 | 195929
 | Europe |  |  | 2975454 |  |  | 714437 |  |  | 3689891
 | North America | 276857 | 1464736 | 216858 | 133345 | 667548 | 39466 | 410203 | 2132284 | 256324
TOTAL |  | 387034 | 2327551 | 4198423 | 142690 | 699559 | 876094 | 529724 | 3027110 | 5074517
Estimated gross notional amount outstanding, February 1 weekly snapshot, by product type (millions of USD), all participant types, tenors and currencies.  Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for participant type descriptions.
***See Data Dictionary for product grade descriptions.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 160611d1339141503-conditional-formatting-when-cells-are-from-certain-sheets-textdata
Sheet: Combined

Text 1
data 2
Text 3
data 4
Text 5
data 6
Text 7
data 8
Text 9
data 10
data 1
Text 2
data 3
Text 4
data 5
Text 6
data 7
Text 8
data 9
Text 10
Spreadsheet: 709726d1608527800-enter-two-conditions-to-query-the-size-forum1221
Sheet: Sheet1

Model | Size | inlet * Outlet |  |  | Model | Size | in
 |  | in | [NAME] |  | T5 | 1 | 1/2" * 5/8"
T5 | 1~2 | 1/2" * 5/8"
 | 3 | 1/2" * 7/8"
 | 4 | 5/8" * 7/8"
 | 5 | 7/8" * 1-1/8"
T12 | 1~2 | 5/8" * 7/8"
 | 3~4 | 7/8" * 1"
 | 5~6 | 7/8" * 1-1/8"
T20 | 1 | 7/8" * 1-1/8"
T55 | 1~2 | 1-1/8" * 1-3/8"
 |  |  | TABLE
Spreadsheet: 42292d1240898824-charts-rollingchartdata
Sheet: Sheet1

Date | Raw Data |  |  | ChartDate | Chart Data
2008-01-01 00:00:00 | 3 |  | ChartSeed: | 2008-07-01 00:00:00 | 8 |  | <--- Just change the date/month in the yellow cell.
2008-02-01 00:00:00 | 7 |  |  | 2008-08-01 00:00:00 | 4
2008-03-01 00:00:00 | 5 |  |  | 2008-09-01 00:00:00 | 2
2008-04-01 00:00:00 | 7 |  |  | 2008-10-01 00:00:00 | 6
2008-05-01 00:00:00 | 8 |  |  | 2008-11-01 00:00:00 | 1
2008-06-01 00:00:00 | 3 |  |  | 2008-12-01 00:00:00 | 6
2008-07-01 00:00:00 | 8
2008-08-01 00:00:00 | 4
2008-09-01 00:00:00 | 2
2008-10-01 00:00:00 | 6
2008-11-01 00:00:00 | 1
2008-12-01 00:00:00 | 6
2009-01-01 00:00:00 | 5
2009-02-01 00:00:00 | 3
2009-03-01 00:00:00 | 6
2009-04-01 00:00:00 | 5
2009-05-01 00:00:00 | 6
2009-06-01 00:00:00 | 8
2009-07-01 00:00:00 | 6
2009-08-01 00:00:00 | 4
2009-09-01 00:00:00 | 3
2009-10-01 00:00:00 | 4
2009-11-01 00:00:00 | 6
2009-12-01 00:00:00 | 7
Spreadsheet: 92407d1291972158-auto-sorting-league-table-league
Sheet: Week3

 |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  |  | WTD |  |  |  | MTD
 |  | Hotkeys | Qualified | Hotkeys | Qualified | Hotkeys | Qualified | Hotkeys | Qualified | Hotkeys | Qualified |  | Hotkeys | Qualified | Conversion % |  | Name | Qualified
4126 | Agent1 |  |  |  |  | 1 | 1 | 3 | 2 | 3 | 3 |  |  |  |  |  | Agent1
4028 | Agent2 | 6 | 4 | 5 | 4 | 5 | 5 | 1 | 1 | 2 | 1 |  |  |  |  |  | Agent2
4023 | Agent3 | 1 | 1 | 4 | 4 | 1 | 1 | 2 | 1 |  |  |  |  |  |  |  | Agent3
4006 | Agent4 | 6 | 5 | 1 | 1 |  |  | 4 | 3 | 9 | 7 |  |  |  |  |  | Agent4
4145 | Agent5 | 2 | 2 |  |  | 4 | 4 | 4 | 4 | 2 | 2 |  |  |  |  |  | Agent5
4031 | Agent6 |  |  |  |  | 1 | 1 | 3 | 2 | 5 | 3 |  |  |  |  |  | Agent6
4125 | Agent7 | 3 | 3 | 1 | 1 | 1 | 1 | 1 | 0 | 3 | 2 |  |  |  |  |  | Agent7
4057 | Agent8 | 5 | 2 | 2 | 2 | 4 | 4 |  |  |  |  |  |  |  |  |  | Agent8
4108 | Agent9 | 2 | 2 |  |  |  |  | 5 | 4 | 2 | 2 |  |  |  |  |  | Agent9
4171 | Agent10 | 9 | 6 | 5 | 5 | 12 | 10 | 2 | 1 | 6 | 5 |  |  |  |  |  | Agent10
4036 | Agent11 |  |  | 1 | 1 | 4 | 3 |  |  | 1 | 1 |  |  |  |  |  | Agent11
4158 | Agent12 | 2 | 1 | 8 | 7 | 5 | 5 | 4 | 2 | 6 | 4 |  |  |  |  |  | Agent12
4148 | Agent13 | 3 | 3 | 2 | 1 | 1 | 1 | 3 | 2 |  |  |  |  |  |  |  | Agent13
4024 | Agent14 |  |  | 2 | 2 | 4 | 4 | 1 | 1 |  |  |  |  |  |  |  | Agent14
 | Total
Spreadsheet: 713775d1610926152-check-if-cell-contains-value-from-list-and-return-data-sample
Sheet: Sheet1

 | Desired results - Codes | Desired results - Descriptions
Syntax Error 100 Mand | 100 | commodity missing
Syntax Error 101 Mand | 101 | description missing
[NAME] 102 Mand | 102 | commodity incomplete
[NAME] 103 Mand | 103 | description incomplete
Syntax Error 100 Mand Syntax Error 100 Mand Syntax Error 100 Mand | 100 | commodity missing
Syntax Error 100 Mand Syntax Error 101 Mand Syntax Error 101 Mand | 100 101 | commodity missing description missing
Spreadsheet: 887120d1737278658-gantt-chart-help-g-chart-1
Sheet: Sheet1

Project Name
Company Name
Project start date: | 2025-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | Scrolling increment: |  |  |  |  |  | 1
Task / Job / Description | Assigned to | Start | Days
task 1 | ABC | 2025-03-03 00:00:00 | 1
 |  | 2025-03-04 00:00:00 | 7
 |  | 2025-03-05 00:00:00 | 6
 |  | 2025-03-06 00:00:00 | 5
 |  | 2025-03-07 00:00:00 | 4
 |  | 2025-03-11 00:00:00 | 1
 |  | 2025-03-12 00:00:00 | 1
Assisgned to (list)
Name 1
name 2
name 3
name 4
name 5
name 6
name 7
Name 8
Spreadsheet: 718590d1613224117-if-with-vlookup-example
Sheet: example

 |  |  | vlookup with if function
 | [NAME]: | IZHAR | drop down |  |  |  |  | C4
 |  | IZHAR | INAM | AMIN | NOOR | SHAMS | AHSAN |  | Product | Price | Quantity | Total
 | Egg |  |  |  |  |  |  |  | Egg |  | 12
 | Milk |  |  |  |  |  |  |  | Milk |  | 3
 | Masala |  |  |  |  |  |  |  | Masala |  | 1
 | Salt Biscuit |  |  |  |  |  |  |  | Salt Biscuit |  | 5
 | Vinegar |  |  |  |  |  |  |  | Vinegar |  | 3
 |  |  |  |  |  |  |  |  |  |  | Total
Spreadsheet: 3ddcdb7b-cead-4639-8067-f21e82c6f073
Sheet: Fields A-D

Permit No.: |  |  | WQ0029233 |  |  | Facility Name: |  | Bear Lake Reserve |  |  |  |  |  | County: | [NAME] |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | A |  | Field Name: |  | B |  | Field Name: |  | C |  | Field Name: |  | D
 |  |  |  |  |  | Area (acres): |  | 0.67 |  | Area (acres): |  | 0.84 |  | Area (acres): |  | 0.82 |  | Area (acres): |  | 1.26
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.05 |  | [NAME] (in): |  | 0.05 |  | [NAME] (in): |  | 0.05 |  | [NAME] (in): |  | 0.05
 |  |  |  |  |  | Annual Rate (in): |  | 70.5 / 7.0 |  | Annual Rate (in): |  | 85.7 / 8.6 |  | Annual Rate (in): |  | 72.5 / 7.2 |  | Annual Rate (in): |  | 69.6 / 7.0
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 685079d1593705655-google-sheets-how-to-have-values-appear-from-one-tab-but-skip-rows-as-needed-sample-performance-attempt-2-4-
Sheet: Stats

 |  | Employee 1 | Daily Output | goal % | Comment |  | Employee 2 | Daily Output | goal % | Comment |  | Employee 3 | Daily Output | goal % | Comment |  | Employee 4 | Daily Output | goal % | Comment |  | Employee 5 | Daily Output | goal % | Comment |  | Employee 6 | Daily Output | goal % | Comment
DAY | 2020-06-29 00:00:00 | Printed |  |  |  |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed
 |  | QC |  |  |  |  | QC |  |  |  |  | QC |  |  |  |  | QC |  |  |  |  | QC |  |  |  |  | QC
 |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage%
DAY | 2020-06-30 00:00:00 | Printed |  |  |  |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed
 |  | QC |  |  |  |  | QC |  |  |  |  | QC |  |  |  |  | QC |  |  |  |  | QC |  |  |  |  | QC
 |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage%
DAY | 2020-07-01 00:00:00 | Printed |  |  |  |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed
 |  | QC |  |  |  |  | QC |  |  |  |  | QC |  |  |  |  | QC |  |  |  |  | QC |  |  |  |  | QC
 |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage%
DAY | 2020-07-02 00:00:00 | Printed |  |  |  |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed
 |  | QC |  |  |  |  | QC |  |  |  |  | QC |  |  |  |  | QC |  |  |  |  | QC |  |  |  |  | QC
 |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage%
DAY | 2020-07-03 00:00:00 | Printed |  |  |  |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed
 |  | QC |  |  |  |  | QC |  |  |  |  | QC |  |  |  |  | QC |  |  |  |  | QC |  |  |  |  | QC
 |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage%
Weekly Average | Weekly Average | Printed |  |  |  |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed |  |  |  |  | Printed
 |  | QC |  |  |  |  | QC |  |  |  |  | QC |  |  |  |  | QC |  |  |  |  | QC |  |  |  |  | QC
 |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage% |  |  |  |  | Damage%
Spreadsheet: 215540d1361401521-order-form-worksheet-populated-sequentially-with-items-selected-from-other-worksheets-sample
Sheet: Fluorescent

SKU | CAT # | [NAME] | PRICE
5587456 | CB 601 | 1 Lamp Surface Wrap | 88 |  |  | False
558746 | CB 608 | 2 lamp Surface Wrap | 89 |  |  | False
6985569 | CB 995 | 3 Lamp Suface Wrap | 98 |  |  | True
6652138 | CG 88 | 2 Lamp Recessed Troffer | 105 |  |  | False
842684 | CG 98 | 3 Lamp Recessed Troffer | 110 |  |  | False
8887988 | CG 108 | 4 Lamp Recessed Troffer | 155 |  |  | True
898815 | EF 885 | 2 Lamp Strip | 68 |  |  | False