tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 167625d1342042435-cell-formatting-help-star-sample
Sheet: Sheet1

What I want No formatting set
[NAME] |  |  |  |  |  | Summary Page
 | A | B | C | D |  |  | A | B | C | D | E | F | G
1 | Vol Hours |  |  |  |  | 1 | Summary Page
2 |  | Person 1 | Person 2 | Person 3 |  | 2
3 | Total Hours | 19:42 | 23:35 | 12:00:00 |  | 3 |  | Person 1 |  | Person 2 |  | Person 3
4 | Category |  |  |  |  | 4 | Stars | Earned | Presented | Earned | Presented | Earned | Presented
5 |  | 05:00:00 | 03:22:00 | 03:00:00 |  | 5 |  | 3 | 3 | 4 | 3 | 2 | 3
6 |  | 03:00:00 | 09:01:00 | 03:00:00 |  | 6
7 |  | 08:00:00 | 06:12:00 | 03:00:00 |  | 7
8 |  | 03:42:00 | 05:00:00 | 03:00:00 |  | 8
What I Get with my formatting
 | A | B | C | D |  |  | A | B | C | D | E | F | G
1 | Vol Hours |  |  |  |  | 1 | Summary Page
2 |  | Person 1 | Person 2 | Person 3 |  | 2
3 | Total Hours | 19:42:00 | 23:35:00 | 12:00:00 |  | 3 |  | Person 1 |  | Person 2 |  | Person 3
4 | Category |  |  |  |  | 4 | Stars | Earned | Presented | Earned | Presented | Earned | Presented
5 |  | 05:00:00 | 03:22:00 | 03:00:00 |  | 5 |  | 0.1641666666666667 | 3 | 0.1965277777777778 | 3 | 2 | 3
6 |  | 03:00:00 | 09:01:00 | 03:00:00 |  | 6
7 |  | 08:00:00 | 06:12:00 | 03:00:00 |  | 7
8 |  | 03:42:00 | 05:00:00 | 03:00:00 |  | 8
Spreadsheet: 738415d1625029858-calculating-running-average-cost-example_avg_cost-6-
Sheet: Version6

Limits: |  |  |  |  | TRANSACTION
 |  |  |  |  |  |  |  |  | OUTBOUND |  |  | OUTSTANDING |  |  | P/L
Trade Symbol | Transaction | Date | Sale Portion | [NAME] | Quantity | Price | Fees | Amount | Quantity | Price | Amount | Quantity | Price | Amount | Gain(+) /     Loss(-) |  |  |  |  | Total Cost | Needed for correct cumulative average cost value |  | Cumulative Units | Cumulative Average Cost | Current Balance (FIFO) | Sales Only -  Separated for RAW data |  | Gain (Loss) P & L | Notes
 | Purchase | 2021-02-22 00:00:00 |  |  | 3.514923 | 14.21 | 0
 | Purchase |  |  |  | 1.95554 | 12.8 | 0
 | Purchase | 2021-02-23 00:00:00 |  |  | 2.121327 | 11.78 | 0
 | Purchase | 2021-03-24 00:00:00 |  |  | 374.242645 | 13.45 | 0
 | Sale | 2021-03-29 00:00:00 | All | Short | -381.834442 | 13.34 | 0
 | Purchase | 2021-04-17 00:00:00 |  |  | 13.380624 | 37.72 | 0
 | Purchase |  |  |  | 12.706329 | 39.39 | 0
 | Purchase | 2021-04-27 00:00:00 |  |  | 28.600846 | 35.18 | 0
 | Purchase | 2021-05-04 00:00:00 |  |  | 74.626678 | 67.52 | 0
 | Purchase |  |  |  | 270.208195 | 74.56 | 0
 | Sale | 2021-05-04 00:00:00 | All | Short | -399.522672 | 78.52 | 0
 | Purchase | 2021-05-04 00:00:00 |  |  | 179.734944 | 84.04 | 0
 | Purchase | 2021-05-05 00:00:00 |  |  | 49.622456 | 101.4 | 0
 | Purchase |  |  |  | 246.20782 | 102.55 | 0
 | Purchase |  |  |  | 165.37101 | 103.4 | 0
 | Sale | 2021-05-05 00:00:00 | All | Short | -640.93623 | 104.18 | 0
 | Purchase | 2021-05-05 00:00:00 |  |  | 30.301633 | 99.03 | 0
 | Purchase | 2021-05-06 00:00:00 |  |  | 276.819944 | 145.41 | 0
 | Sale | 2021-05-06 00:00:00 | All | Short | -307.121577 | 168.49 | 0
 | Purchase | 2021-05-06 00:00:00 |  |  | 277.1079 | 182.23 | 0
 | Purchase |  |  |  | 138.149505 | 182.77 | 0
 | Sale | 2021-05-08 00:00:00 | Partial | Short | -107.381606 | 127.43 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Should be a negative number … here is where things get complicated…
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | How do we get Q26 to show a value that represents a portion of the loss based on the fact that this partial sale was done to minimize some of the losses when the price dropped $55 per share? That value should equate to somewhere around $5000.00
Totals: |  |  |  | Purchase
 |  |  |  | Sale
Spreadsheet: 677553d1589395307-highlight-a-row-that-fits-two-criteria-household2
Sheet: Sheet1

customer_id | firstname | lastname | address1 | homephone | workphone | cellphone | headofhousehold | FamilyID1 | FamilyName1 | FamilyRole1
44 |  |  |  |  |  |  | No | 2 | [NAME] | Adult / Guardian
121310 |  |  |  |  |  |  | No | 2 | [NAME] | Adult / Guardian
27 |  |  |  |  |  |  | No | 3 | Cauble | Adult / Guardian
46 |  |  |  |  |  |  | No | 4 | Shell | Adult / Guardian
48 |  |  |  |  |  |  | No | 6 | Kent | Adult / Guardian
50 |  |  |  |  |  |  | No | 8 | Mumford | Adult / Guardian
52 |  |  |  |  |  |  | No | 10 | Clayburn | Adult / Guardian
53 |  |  |  |  |  |  | Yes | 11 | Joyner | Adult / Guardian
395 |  |  |  |  |  |  | No | 11 | Joyner | Adult / Guardian
54 |  |  |  |  |  |  | Yes | 12 | [NAME] | Adult / Guardian
55 |  |  |  |  |  |  | No | 13 | Koonce | Adult / Guardian
5974 |  |  |  |  |  |  | No | 15 | Gray | Adult / Guardian
57 |  |  |  |  |  |  | Yes | 15 | Gray | Adult / Guardian
221 |  |  |  |  |  |  | No | 16 | Leatherman | Adult / Guardian
10736 |  |  |  |  |  |  | No | 16 | Leatherman | Adult / Guardian
4228 |  |  |  |  |  |  | Yes | 17 | Simpson | Adult / Guardian
62 |  |  |  |  |  |  | Yes | 19 | Corrigan | Adult / Guardian
69 |  |  |  |  |  |  | No | 21 | Acosta | Adult / Guardian
83 |  |  |  |  |  |  | No | 22 | Curry | Adult / Guardian
85 |  |  |  |  |  |  | Yes | 23 | [NAME] | Adult / Guardian
114263 |  |  |  |  |  |  | No | 23 | [NAME] | Adult / Guardian
114266 |  |  |  |  |  |  | No | 23 | [NAME] | Adult / Guardian
86 |  |  |  |  |  |  | No | 24 | Washington | Adult / Guardian
87 |  |  |  |  |  |  | No | 25 | Gettys | Adult / Guardian
89 |  |  |  |  |  |  | No | 27 | [NAME] | Adult / Guardian
90 |  |  |  |  |  |  | Yes | 28 | Cunningham | Adult / Guardian
91 |  |  |  |  |  |  | No | 29 | Dunlap | Adult / Guardian
93 |  |  |  |  |  |  | No | 31 | Gray | Adult / Guardian
94 |  |  |  |  |  |  | Yes | 32 | [NAME] | Adult / Guardian
97 |  |  |  |  |  |  | Yes | 34 | Haney | Adult / Guardian
98 |  |  |  |  |  |  | No | 35 | McDowell | Adult / Guardian
105 |  |  |  |  |  |  | No | 37 | Walker | Adult / Guardian
104 |  |  |  |  |  |  | Yes | 37 | Walker | Adult / Guardian
106 |  |  |  |  |  |  | No | 38 | Walls | Adult / Guardian
107 |  |  |  |  |  |  | No | 39 | Weathers | Adult / Guardian
108 |  |  |  |  |  |  | No | 40 | Wilson | Adult / Guardian
109 |  |  |  |  |  |  | Yes | 41 | [NAME] | Adult / Guardian
110 |  |  |  |  |  |  | No | 42 | Ng | Adult / Guardian
111 |  |  |  |  |  |  | No | 43 | Antoine | Adult / Guardian
112 |  |  |  |  |  |  | No | 43 | Antoine | Adult / Guardian
Spreadsheet: 798570d1664555591-sumproduct-arrays-different-size-match
Sheet: match-2arrays

UNMATCH |  | (check existing grades) |  | =SUMPRODUCT((1*ISNA(MATCH(A4&A5:A1000,E5:E10&F5:F10,0))=1)*(A5:A1000<>"")*1)
grade | location |  |  | type | grade
A | US |  |  | location | MX
A | DE |  |  | grade | A
B | MX |  |  | grade | B
C | US |  |  | location | US
D | DE |  |  | location | NL
a | MX |  |  | grade | C
F | US
A | DE
A | MX
B | FR
B | DE
D | MX
A | FR
B | US
Spreadsheet: 57762d1257969528-condition-based-italicizing-conditional-2
Sheet: Sheet1

Subdivision |  | Lot Size Range |  | Current House Price Range |  | Equipment on Site | Excavation | Street Paving | Streets  In | Total |  |  |  | Somerton Village |  |  | 28 | 23 | 14.61 | B
Beacon Hill(Kennedale) |  | 0 | 100 | 183 | 239 | 0 | 53 | 0 | 0 | 53 |  |  |  | La Frontera South |  |  | 22 | 35 | 7.54 | B
Hidden Meadow(Arlington) |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 20 | 20 |  |  |  | Spring Lake Estates (Mansfield) |  |  | 83 | 22 | 45.27 | C
La Frontera South |  | 0 | 100 | 136 | 176 | 0 | 0 | 82 | 0 | 82 |  |  |  | Hills of Westchester |  |  | 64 | 9 | 85.33 | C
Parkcrest Place |  | 0 | 100 | 0 | 0 | 0 | 0 | 0 | 111 | 111 |  |  |  | [NAME] |  |  | 62 | 11 | 67.64 | C
 |  |  |  |  |  |  |  |  |  | 0 |  |  |  | Wildood Estates |  |  | 53 | 11 | 57.82 | C
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Twin Creeks Addition |  |  | 51 | 12 | 51 | C
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Fannin Farm West |  |  | 47 | 30 | 18.8 | C
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Lake Parks/ East (AISD) |  |  | 29 | 23 | 15.13 | C
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Villages at Spring Lake |  |  | 27 | 25 | 12.96 | C
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] (Arlington) |  |  | 24 | 17 | 16.94 | C
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Lake Parks/West |  |  | 18 | 3 | 72 | C
Spreadsheet: 184173d1349174032-people-change-can-the-graph-change-with-them-864746
Sheet: Sept

 |  | Sept
 |  | Driver ID | Speeding Events | [NAME] speed | Distance(km) | Km per speeding event
 |  | Anomi | 1 | 122 | 1124.1
 |  | [NAME] | 0 | 114 | 1676.6
 |  | Duane Poore | 0 | 109 | 137.4
 |  | [NAME] | 3 | 108 | 1421.5
 |  | [NAME] | 23 | 121 | 4929.9 |  |  | So many people have changed by september that it will be a mess in a few more months.
 |  | [NAME] | 3 | 122 | 2286.6
 |  | [NAME] | 6 | 129 | 2547.1
 |  | Melvin | 3 | 116 | 2066.2
 |  | [NAME] | 1 | 116 | 1704.1
 |  | [NAME] | 1 | 116 | 1789.3
 |  | [NAME] | 5 | 117 | 1907.4
 |  | UNKNOWN | 2 | 108 | 797.8
 |  | [NAME] | 0 | 114 | 57.9
 |  |  | indicates more speeding then average
 |  |  | indicates less speeding then average
Spreadsheet: 749938d1633103050-formula-to-add-in-additional-data-sample-ex-2
Sheet: Sheet1

PRODUCT | TERM | WHSL COST (CURRENT)
ADAPTIVE Annual | 1 | 100
 | 2 | 200
 | 3 | 300
 | 4 | 400
 | 5 | 500
 | 6 | 600
 | 7 | 700
 | 8 | 800
 | 9 | 900
 | 10 | 1000
Spreadsheet: 53755d1253663500-trying-to-use-count-to-get-accumulated-values-demo
Sheet: Sheet1

Date | Name | Contents | Value |  |  | Contents | Value
2009-08-26 00:00:00 | WAY | CD | 1600 |  |  | CD | 16878
2009-08-27 00:00:00 | NNT | Book | 7272 |  |  | Book
2009-09-10 00:00:00 | WAY | Video | 12440 |  |  | Video
2009-09-10 00:00:00 | BBT | Food | 8065 |  |  | Food
2009-09-10 00:00:00 | GGT | Car | 18900 |  |  | Car
2009-09-10 00:00:00 | BBN | House | 3400 |  |  | House
2009-09-10 00:00:00 | WAVE | Book | 15813 |  |  | DVD
2009-09-12 00:00:00 | HILL | Food | 8177
2009-09-13 00:00:00 | MOVE | DVD | 740
2009-09-14 00:00:00 | WAY | CD | 452
2009-09-15 00:00:00 | NNT | Book | 558
2009-09-16 00:00:00 | WAY | Video | 2255
2009-09-17 00:00:00 | BBT | Food | 5855
2009-09-18 00:00:00 | GGT | Car | 27527
2009-09-19 00:00:00 | BBN | House | 727572
2009-09-20 00:00:00 | WAVE | Book | 777
2009-09-21 00:00:00 | HILL | Food | 755
2009-09-22 00:00:00 | MOVE | DVD | 7257
2009-09-23 00:00:00 | WAY | CD | 7272
2009-09-24 00:00:00 | NNT | Book | 7527
2009-09-25 00:00:00 | WAY | Video | 7527
2009-09-26 00:00:00 | BBT | Food | 7757
2009-09-27 00:00:00 | GGT | Car | 5775
2009-09-28 00:00:00 | BBN | House | 577
2009-09-29 00:00:00 | WAVE | Book | 5575
2009-09-30 00:00:00 | HILL | Food | 444
2009-10-01 00:00:00 | MOVE | DVD | 4445
2009-10-02 00:00:00 | WAY | CD | 7554
Spreadsheet: daren_farmer__6651__Gas  Assets Ops 0300 - Prelim
Sheet: 2940Detail

[NAME] Class |  | Co |  |  |  | Work Order |  | Invoice # | Vendor# |  | [NAME] |  | Amount
1 | SALARIES AND WAGES
 |  | 413 | 9200 | 999 | 413-025-11 |  | 401-K Allocation |  |  |  |  |  | 106.25
 |  | 413 | 9200 | 999 | 413-008-01 |  |  | SUMMARIZED | LD    1131 |  |  |  | 1770.83
 |  | 413 | 9200 | 999 | 413-008-02 |  |  | SUMMARIZED | LD    2471 |  |  |  | 1770.83
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]: | 3647.91
552 | BENEFITS
 |  | 413 | 9260 | 999 | 413-008-01 |  |  | SUMMARIZED | LD    1131 |  |  |  | 306.8
 |  | 413 | 9260 | 999 | 413-008-02 |  |  | SUMMARIZED | LD    2471 |  |  |  | 300.42
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]: | 607.22
557 | PAYROLL TAXES
 |  | 413 | 4081 | 520 | 413-008-01 |  |  | SUMMARIZED | LD    1131 |  |  |  | 135.4
 |  | 413 | 4081 | 520 | 413-008-02 |  |  | SUMMARIZED | LD    2471 |  |  |  | 135.4
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]: | 270.8
 |  |  |  |  |  |  |  |  |  |  |  |  | Field58: | 4525.93
Spreadsheet: 774085d1648206672-possible-if-and-formula-advice-help-if-and-formula-advice
Sheet: DATA TAB

 |  |  |  |  |  |  |  |  |  | UNITS | UNITS | UNITS | UNITS | UNITS
UNIQUE REF | LOCATON | TIME | YEAR | Article | DESC | CAT | COLOUR | GENDER | DIVISION | TW | LW | TWLY | YTD | YTD LY
 | ONLINE | TY | 2022 | 12345 | ITEM A | ELITE | Black | MEN | INDOOR | 10 | 8 | 5 | 100 | 50
 | STORE | TY | 2022 | 23456 | ITEM B | ELITE | Black | WOMEN | INDOOR | 10 | 8 | 5 | 100 | 50
 | ONLINE | TY | 2022 | 34567 | ITEM C | ELITE | Black | KIDS | INDOOR | 10 | 8 | 5 | 100 | 50
 | ONLINE | TY | 2022 | 45678 | ITEM D | ELITE | White | MEN | OUTDOOR | 8 | 6 | 4 | 80 | 40
 | ONLINE | TY | 2022 | 56789 | ITEM E | ELITE | Blue | WOMEN | OUTDOOR | 8 | 6 | 4 | 80 | 40
 | ONLINE | TY | 2022 | 67890 | ITEM F | ELITE | Red | KIDS | HYBRID | 6 | 4 | 3 | 60 | 30
 | ONLINE | TY | 2022 | 12345 | ITEM A | ELITE | Black | MEN | INDOOR | 10 | 8 | 5 | 100 | 50
 | STORE | TY | 2022 | 23456 | ITEM B | ELITE | Black | WOMEN | INDOOR | 10 | 8 | 5 | 100 | 50
 | STORE | TY | 2022 | 34567 | ITEM C | ELITE | Black | KIDS | INDOOR | 10 | 8 | 5 | 100 | 50
 | STORE | TY | 2022 | 45678 | ITEM D | ELITE | White | MEN | OUTDOOR | 8 | 6 | 4 | 80 | 40
 | STORE | TY | 2022 | 56789 | ITEM E | ELITE | Blue | WOMEN | OUTDOOR | 8 | 6 | 4 | 80 | 40
 | STORE | TY | 2022 | 67890 | ITEM F | ELITE | Red | KIDS | HYBRID | 6 | 4 | 3 | 60 | 30
Spreadsheet: 690622d1597202872-formula-for-producing-customers-statement-customers-statement
Sheet: Sales Data

 | SALES DATA
 | Date | [NAME] | Customer  Name | VAT Number | Invoice Number | Product  I.D | Product Name | Quantity | Unit Price | Gross Amount | Discount % | Discount Amount | Net Amount | VAT % | [NAME] | Amount Including VAT
 | 2020-08-01 00:00:00 | 100 | Ok Mart | 1000200 | 1 | A001 | Milk | 5000 | 2 |  | 0.01 |  |  | 0.15
 | 2020-08-02 00:00:00 | 101 | [NAME] | 1000201 | 2 | A002 | [NAME] | 1200 | 20 |  | 0.01 |  |  | 0.15
 | 2020-08-11 00:00:00 | 102 | Ok Mart | 1000200 | 3 | A003 | Milk | 4000 | 2 |  | 0.01 |  |  | 0.15
 | 2020-08-11 00:00:00 | 103 | ZIMNAT | 1000203 | 4 | A004 | Chairs | 20 | 70 |  | 0.01 |  |  | 0.15
Spreadsheet: 74700d1275230083-vacation-schedule-gantt-chart-gantt-chart-test-sample
Sheet: Holidays (Input)

Holiday every |  |  | Y/N*
 | Sunday |  | N
 | Monday |  | N
 | Tuesday |  | N
 | Wednesday |  | N
 | Thursday |  | Y
 | Friday |  | Y
 | Saturday |  | N
Holiday on |  |  | Date (maximum of 40 dates)*
 |  |  | 2009-12-25 00:00:00 | Christmas Day
 |  |  | 2010-01-01 00:00:00 | New Year's Day
 |  |  | 2010-01-18 00:00:00 | [NAME]
 |  |  | 2010-02-15 00:00:00 | Presidents Day
 |  |  | 2010-05-31 00:00:00 | Memorial Day
 |  |  | 2010-07-04 00:00:00 | Independence Day
 |  |  | 2010-09-06 00:00:00 | Labor Day
 |  |  | 2010-10-11 00:00:00 | Columbus Day
 |  |  | 2010-11-11 00:00:00 | Veterans' Day
 |  |  | 2010-11-25 00:00:00 | Thanksgiving Day
 |  |  | 2010-12-25 00:00:00 | Christmas Day
Spreadsheet: 297467d1392397521-time-calculation-between-two-cells-time-formula
Sheet: Sheet1

[NAME] | Document | Time Stamp | Total Time Taken (Output)
LAN 1 | A | 2014-05-01 19:12:00 | 11 hrs 55 Mins
LAN 1 | B | 2014-05-01 19:13:00 | 11 hrs 55 Mins
LAN 1 | C | 2014-05-01 08:00:00 | 11 hrs 55 Mins
LAN 1 | D | 2014-05-01 19:45:00 | 11 hrs 55 Mins
LAN 1 | E | 2014-05-01 19:46:00 | 11 hrs 55 Mins
LAN 1 | F | 2014-05-01 19:55:00 | 11 hrs 55 Mins
LAN 1 | G | 2014-05-01 19:50:00 | 11 hrs 55 Mins
LAN 1 | H | 2014-05-01 19:49:00 | 11 hrs 55 Mins
LAN 1 | I | 2014-05-01 19:48:00 | 11 hrs 55 Mins
LAN 2 | A | 2014-05-01 18:05:04 | 0 hrs 15 Mins
LAN 2 | B | 2014-05-01 18:06:05 | 0 hrs 15 Mins
LAN 2 | C | 2014-05-01 18:07:05 | 0 hrs 15 Mins
LAN 2 | D | 2014-05-01 18:08:05 | 0 hrs 15 Mins
LAN 2 | E | 2014-05-01 18:09:05 | 0 hrs 15 Mins
LAN 2 | F | 2014-05-01 18:10:05 | 0 hrs 15 Mins
LAN 2 | G | 2014-05-01 18:11:05 | 0 hrs 15 Mins
LAN 2 | H | 2014-05-01 18:12:05 | 0 hrs 15 Mins
LAN 2 | I | 2014-05-01 18:13:05 | 0 hrs 15 Mins
LAN 2 | A | 2014-05-01 18:14:05 | 0 hrs 15 Mins
LAN 2 | B | 2014-05-01 18:15:05 | 0 hrs 15 Mins
LAN 2 | C | 2014-05-01 18:16:05 | 0 hrs 15 Mins
LAN 2 | D | 2014-05-01 18:20:04 | 0 hrs 15 Mins
LAN 3 | A | 2014-05-01 17:15:00 | 2 hrs 15 mins
LAN 3 | B | 2014-05-01 17:16:00 | 2 hrs 15 mins
LAN 3 | C | 2014-05-01 19:30:00 | 2 hrs 15 mins
LAN 3 | D | 2014-05-01 17:25:00 | 2 hrs 15 mins
LAN 3 | E | 2014-05-01 17:30:00 | 2 hrs 15 mins
LAN 3 | F | 2014-05-01 18:15:00 | 2 hrs 15 mins
LAN 3 | G | 2014-05-01 17:18:00 | 2 hrs 15 mins
Spreadsheet: 813292d1673643034-duplicates-control-invoice-numbers-book2
Sheet: Sheet1

1
1
2
2
2
3
3
4
4
2
Spreadsheet: 876881d1723593430-how-to-link-or-import-data-between-two-excel-workbooks-with-very-different-formats-daily-sheets
Sheet: 06.05.24

 | AM SHIFT REPORT
 |  |  |  | 2024-06-05 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN | RN PD | TRVL | RN OT | RN Sick | Tech | NA | Comments
 | 3RD FL | 13 | 7 | 11 | 0 | 2 | 1 | 1 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 30 | 0 | 5 | 1 | 2 | 0 | 0 | 3 | 0
 | 5TH FL | 34 | 20 | 24 | 1 | 5 | 1 | 0 | 0 | 0 | 2 | 0
 | ABC | 27 | 18 | 23 | 0 | 6 | 0 | 1 | 0 | 0 | 2 | 0
 | MNO | 12 | 6 | 4 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 3 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 3 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 2 | 0 | 4 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds AM | N/A | N/A | 0 | 0 | 5 | 2 | 0 | 0 | 0 | 2 | 0
 | Total Holds MID |  |  | 0 | 0 | 5 | 2 | 0 | 0 | 0 | 1 | 0
 | Total House Census
 | PM SHIFT REPORT
 |  |  |  | 2024-06-05 00:00:00
 | UNIT | Bed Capacity | Bud. Beds | Census | Census Pending | RN | RN PD | TRVL | RN OT | RN Sick | Tech | NA | Comments
 | 3RD FL | 13 | 7 | 10 | 2 | 2 | 1 | 0 | 1 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 26 | 0 | 5 | 1 | 1 | 0 | 0 | 2 | 0
 | 5TH FL | 34 | 20 | 21 | 1 | 4 | 1 | 2 | 0 | 0 | 2 | 0 | (in house transfer
 | ABC | 27 | 18 | 20 | 0 | 6 | 1 | 1 | 0 | 0 | 2 | 0
 | MNO | 12 | 6 | 5 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 4 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0
 | GHI | N/A | N/A | 5 | 0 | 4 | 0 | 1 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds PM | N/A | N/A | 0 | 0 | 5 | 2 | 0 | 0 | 0 | 2 | 0
 | Total House Census
Spreadsheet: 799695d1665214530-control-comma-separated-values-in-a-cell-against-a-list-of-single-values-in-a-column-excel_help
Sheet: control-2arrays

UNMATCH |  | case-unsensitive |  | =SUMPRODUCT((1*ISNA(MATCH(A4&A5:A1000,E5:E10&F5:F10,0))=1)*(A5:A1000<>"")*1)
 | ? | case-sensitive
grade | location |  |  | label | value
A | US |  |  | location | MX
A | DE |  |  | grade | A
B | MX |  |  | grade | B
C | US |  |  | location | US
D | DE |  |  | location | NL
a | MX |  |  | grade | C
F | US
A | DE
A | MX
B | FR
B | DE
D | MX
A | FR
B | US
Spreadsheet: 810476d1671796056-autonumber-with-concatenate-issue-with-filter-ef_examp
Sheet: PORTS+CO

 | Port | Country
 | Taichung | TW
 | HCM | VN
 | Ningbo | CN
 | Xiamen | CN
 | Tainan | TW
 | Haiphong | VN
 | Shanghai | CN
 | Zhuhai | CN
 | Yantian | CN
 | Lahore | PK
 | Bangkok | TH
 | Taiwan | TW | because Taiwan is not big, most supplier is ok to use other ports
 | Semarange | ID
 | Kolm gmbH | TK
 | Gordona | IT
 | Jakarta | ID
 | Taipei | TW
 | Istanbul | TR
 | Puebla | MX
 | Chittagong | BD
 | Long Beach | US
 | Dalian | CN
 | Yantian | CN
 | Kaohsiung | TW
 | [NAME] | MY
 |  | CN
 | Hong Kong | HK
 | Middlesex | GB
 | Mount Airy, NC | US
 | Guangzhou | CN
 | Stuttgart | DE
 | Guangzhou | CN
Spreadsheet: 05165766-85cd-47cb-b777-4f9fa87172f3
Sheet: 7b

Product1 | EUR3 | USD | GBP | [NAME] | AUD | CAD | OTHER | TOTAL
Basis | 1134654 | 9331833 | 2261575 | 2072241 | 357383 | 134405 | 249945 | 15542036
Fixed-Float | 77032772 | 85936904 | 15447079 | 19448469 | 5050576 | 4602281 | 12890487 | 220408568
FRA | 26514845 | 17848059 | 8570594 | 25489 | 312824 | 57152 | 3843460 | 57172423
OIS | 20344121 | 6286560 | 5863521 | 148739 | 1430374 | 677303 | 864513 | 35615131
Swaption | 8694551 | 7738961 | 1301996 | 2642322 | 351240 | 15446 | 287578 | 21032094
OTHER* | 6232011 | 10745422 | 1116168 | 317193 | 185758 | 36763 | 256639 | 18889954
TOTAL | 139952954 | 137887739 | 34560933 | 24654453 | 7688155 | 5523350 | 18392622 | 368660206
*OTHER variable includes the following products: Cap/Floor, Debt Option, Exotic, Fixed-Fixed, and Inflation.
Spreadsheet: darron_c_giron__7906__Expedition
Sheet: Eddie Bauer 4X2

 |  | Expedition Eddie Bauer 4X4
 |  | Invoice | MSRP |  | TMV
 | Base | 32331 | 36815 |  | 33175
 | 5.4L V8 | 591 | 695 |  | 611
 | 5.4L V8 Discount | -591 | -695 |  | -611
 | Class IV Towing | 748 | 880 |  | 773
 | Eddie Bauer Premier Group | 1356 | 1595 |  | 1402
 | [NAME] | -680 | -800 |  | -704
 | Entertainment System | 1143 | 1345 |  | 1181
 | Entertainment System Discount | -1143 | -1345 |  | -1181
 | [NAME] | 217 | 255 |  | 224
 | Destination | 715 | 715 |  | 715
 | Over Invoice | 500 |  |  | 0
 | Tax
 | Title | 100 |  |  | 100
 | License | 50 |  |  | 50
 | Ford Citibank | -860 |  |  | -860
 | Driver Edge Citibank | -1087 |  |  | -1087
 | Down Payment | -2200 |  |  | -2200
 | Payment
 | Interest Rate | 0.08 |  |  | 0.08
 | Months | 60 |  |  | 60
Spreadsheet: 816516ae-b936-4f6c-b1a8-64d7995504a1
Sheet: Page 3

Permit No.: |  |  | WQ0003765 |  |  | Facility Name: |  | New Bern Seven Water Reclamation Facility |  |  |  |  |  | County: | [NAME] |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | 7-B |  | Field Name: |  | 7-C |  | Field Name: |  | 8-B |  | Field Name: |  | 8-C
 |  |  |  |  |  | Area (acres): |  | 0.61 |  | Area (acres): |  | 9.34 |  | Area (acres): |  | 1.91 |  | Area (acres): |  | 10.9
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  |  |  | [NAME] (in): |  |  |  | [NAME] (in): |  |  |  | [NAME] (in):
 |  |  |  |  |  | Annual Rate (in): |  | 65.2 |  | Annual Rate (in): |  | 52.1 |  | Annual Rate (in): |  | 65.2 |  | Annual Rate (in): |  | 52.1
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: 60990d1261573583-place-items-with-a-specific-date-in-monthly-calendar-month
Sheet: Sheet2

2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00
wilson1 |  |  | wilson9 |  | [NAME] |  | wilson2 |  |  | wilson7 | [NAME]
wilson3 |  |  |  |  | wilson5
wilson6
wilson10
Spreadsheet: 834538d1687885974-help-with-if-and-formula-aggregate-schedule
Sheet: Sheet1

 |  |  |  | 2023 |  |  |  |  |  |  |  |  |  |  |  | 2024
PROJECT START | PROJECT FINISH | Aggregate Volume Per Month |  | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00
2023-06-30 00:00:00 | 2024-07-04 00:00:00 | 2500
2023-10-05 00:00:00 | 2024-05-25 00:00:00 | 1200
Spreadsheet: 47344d1246377973-creating-list-with-true-false-field-delete-rows-based-on-condition
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
T/F | Col 1 | Col 2 | Col 3
1 | a | c | g
1 | b | d | h
1 | c | e | i
1 | d | f | j
1 | e | g | k
1 | f | h | l
0 | g | i | m
1 | h | j | n
1 | i | k | o
1 | j | l | p
1 | k | m | q
1 | l | n | r
1 | m | o | s
1 | n | p | t
1 | o | q | b
0 | p | r | c
1 | q | s | c
1 | r | t | d
1 | s | b | c
0 | t | c | d