tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 97628d1296753319-need-help-pulling-catalog-data-into-usable-format-catalog
Sheet: All Colors

All Possible Colors |  | Applicable Color Group
White |  | Color Group 1
Heathers |  | Color Group 2
Neutrals |  | Color Group 2
Lights |  | Color Group 2
Lime |  | Color Group 2
Orange |  | Color Group 2
Colors |  | Color Group 2 IF there is a Premium designation for this product. COLOR GROUP 2 AND COLOR GROUP 3 if there is not
Premium |  | Color Group 3
Camouflage |  | Color Group 3
PFD |  | Ignored if there are any other Color Group 2 designations for this product, Color Group 2 if there are not.
Spreadsheet: 178247d1346734114-list-unique-data-referencing-column-c-for-team-and-column-b-for-name-sample-solution
Sheet: ReportCSR

 | Agent Name | Team Leader
1 | Rachel | A
2 | Samant | A
3 | [NAME] | C
4 | [NAME] | G
5 | Erin | A
6 | Sean | A
7 | Rene | A
8 | [NAME] | A
9 | Lauren | G
10 | [NAME] | G
11 | Reena | B
12 | Chloe | B
13 | Jasjeet | F
14 | Chanel | H
15 | [NAME] | A
16 | Jade | A
17 | [NAME] | H
18 | Shveta | F
19 | [NAME] | F
20 | Lydia | A
21 | Eva | C
22 | Tahlia | G
23 | [NAME] | D
24 | [NAME] | F
25 | [NAME] | G
26 | Mohamed | I
27 | [NAME] | E
28 | Mick | H
29 | Whitney | F
30 | Wakeel | A
31 | Erin | E
32 | [NAME] | I
33 | Viknesh | D
34 | [NAME] | H
35 | Peregrine | G
36 | Nuulua | H
37 | Karmen | D
38 | Kadejeh | C
39 | Shae | I
40 | Rosemary | G
41 | [NAME] | F
42 | Phea | F
43 | [NAME] | I
44 | [NAME] | I
45 | Lina | E
46 | April | H
47 | Rebecca | E
48 | [NAME] | B
49 | [NAME] | F
50 | Phoebe | E
51 | Elle | F
52 | [NAME] | I
53 | [NAME] | B
54 | Urvashi | H
55 | [NAME] | E
56 | Greg | H
57 | [NAME] | C
58 | Kait | G
59 | Scott | E
60 | [NAME] | B
61 | [NAME] | C
62 | Fabian | E
63 | Ricky | F
64 | Rene | I
65 | Vania | F
66 | Jessica | D
67 | [NAME] | B
68 | [NAME] | E
69 | [NAME] | H
70 | [NAME] | B
71 | [NAME] | D
72 | [NAME] | B
73 | [NAME] | A
74 | [NAME] | E
75 | Andries | F
76 | [NAME] | D
77 | Sandra | G
78 | Gemma | C
79 | [NAME] | B
Spreadsheet: 679101d1590187941-timesheet-with-rules-team-weekly-times-ww21-rev2
Sheet: Original Format

WW21 | Friday |  |  | Saturday | Sunday | Monday |  |  | Tuesday |  |  | Wednesday |  |  | Thursday |  |  | Weekly Hours
Name | In | Out | Hours |  |  | In | Out | Hours | In | Out | Hours | In | Out | Hours | In | Out | Hours
[NAME] | 07:27:00 | 14:59:00 |  |  |  | 07:27:00 | 17:57:00 |  | 07:32:00 | 18:53:00 |  | 07:30:00 | 17:20:00 |  | 07:34:00 | 18:30:00
[NAME] | 08:00:00 | 17:00:00 |  |  |  | 08:00:00 | 17:00:00 |  | 08:00:00 | 17:14:00 |  | 08:00:00 | 17:00:00 |  | 08:00:00 | 17:00:00
[NAME] | 08:00:00 | 17:30:00 |  |  |  | 08:00:00 | 17:00:00 |  | 08:00:00 | 17:00:00 |  | 08:00:00 | 17:00:00 |  | 13:00:00 | 17:00:00
[NAME] | 07:50:00 | 17:15:00 |  |  |  | 07:50:00 | 17:15:00 |  | 07:50:00 | 17:15:00 |  | 07:50:00 | 17:15:00 |  | 07:50:00 | 18:30:00
[NAME] | 07:00:00 | 16:22:00 |  |  |  | 08:13:00 | 21:15:00 |  | 08:07:00 | 17:56:00 |  | 08:01:00 | 17:11:00 |  | 08:05:00
Ricardo Cardoso | 07:54:00 | 17:39:00 |  |  |  | 07:58:00 | 18:09:00 |  | 08:04:00 | 17:54:00 |  | 08:00:00 | 18:17:00 |  | 07:56:00
Hours worked = total time - 30 mins [NAME] break (should be built in)
If In OR Out times not entered then hours  = 0
If In AND Out times not entered then hours  = 0
If hours worked exceed 8.5 hours, then hours = 8.5
Spreadsheet: 101568d1299678254-excel-2007-using-excel-to-return-value-to-the-left-weaponx2011
Sheet: Shick & Noah

# | Position | Player | Cost | Years
1 | 1B | [NAME] | 2 | 1
2 | 2B | [NAME] | 2 | 1 |  | Shick and [NAME] |  |  | C | 1B | 2B
3 | 3B | Pablo Sandoval | 1.5 | 1 |  | Roster: |  |  | #N/A | [NAME] | [NAME]
4 | OF | [NAME] | 2 | 1 |  | C: | 0 |  | #N/A | [NAME] | #N/A
5 | OF | Shin-Soo Choo | 5 | 1 |  | 1B: | 2 |  | #N/A | #N/A | #N/A
6 | 3B | [NAME] | 0.5 | 1 |  | 2B: | 1 |  | #N/A | #N/A | #N/A
7 | OF | [NAME] | 1 | 1 |  | SS: | 0
8 | 1B | [NAME] | 0.5 | 2 |  | 3B: | 2 |  | 3B | SS | OF
9 | FARM | [NAME] | 0.75 | 2 |  | OF: | 3 |  | Pablo Sandoval | #N/A | [NAME]
10 | SP | [NAME] | 0.5 | 1 |  | SP: | 7 |  | [NAME] | #N/A | Shin-Soo Choo
11 | SP | [NAME] | 3 | 1 |  | RP: | 0 |  | #N/A | #N/A | [NAME]
12 | SP | [NAME] | 5.25 | 1 |  | FARM: | 1 |  | #N/A | #N/A | #N/A
13 | SP | [NAME] | 2 | 1 |  | DH: | 0 |  |  |  | #N/A
14 | SP | [NAME] | 2 | 1 |  |  |  |  |  |  | #N/A
15 | SP | [NAME] | 0.25 | 2 |  | Spent: | 32 |  |  |  | #N/A
16 | SP | [NAME] | 3 | 1 |  | Available: | 93
17 | DEAD | [NAME] | 0.75 | 1 |  | Farm Spent | 0.75 |  | SP | RP | FARM
18 |  |  |  |  |  | Farm Available | 9.25 |  | [NAME] | #N/A | [NAME]
19 |  |  |  |  |  | Farm Over $2 | 0 |  | [NAME] | #N/A | #N/A
20 |  |  |  |  |  |  |  |  | [NAME] | #N/A | #N/A
21 |  |  |  |  |  | Players / Roster |  |  | [NAME] |  | #N/A
22 |  |  |  |  |  | Total Players | 17 |  | [NAME] |  | #N/A
23 |  |  |  |  |  | Farm Players | 1 |  | [NAME] |  | #N/A
24 |  |  |  |  |  | Players Remaing | 23 |  | [NAME] |  | #N/A
25 |  |  |  |  |  |  |  |  | #N/A |  | #N/A
26 |  |  |  |  |  | Per Player Stats |  |  | #N/A |  | #N/A
27 |  |  |  |  |  | Per Player Remain | 4.043478260869565 |  | #N/A |  | #N/A
28 |  |  |  |  |  | [NAME] for one: | 87.5 |  | #N/A |  | #N/A
29 |  |  |  |  |  |  |  |  | #N/A |  | #N/A
30 |  |  |  |  |  | Dead Contracts | 1 |  | #N/A
31 |  |  |  |  |  |  |  |  | #N/A | DH
32 |  |  |  |  |  |  |  |  | #N/A | #N/A
33 |  |  |  |  |  |  |  |  |  | #N/A
34
35
36
37
38
39
40
Spreadsheet: 694994d1599940220-auto-updating-months-and-remaining-amount-sample
Sheet: Data

ID# | NAME | PAYMENT CLEAR TILL | NEXT PAYMENT | CURRENT MONTH | TOTAL MONTHS | MONTHLY PAYMENT | REMAINS | TOTAL | LAST AMOUNT PAID | ON DATE
3001 | CUSTOMER 1 | 2020-07-01 00:00:00 |  |  |  | 1500 | 500
3002 | CUSTOMER 2 | 2019-11-01 00:00:00 |  |  |  | 2000 | 0
3003 | CUSTOMER 3 | 2020-01-01 00:00:00 |  |  |  | 4000 | 2500
3004 | CUSTOMER 4 | 2019-10-01 00:00:00 |  |  |  | 500 | 0
Spreadsheet: 780850d1652814997-counting-quantity-of-a-product-number-throughout-multiple-tabs-estimate-totals
Sheet: 102

RC#
Branch Name |  | Ownership:
Address
City, St |  | Installer:
Product No. | Existing Sign | New Sign | Notes | Qty | Product Price | Removal | Install | Ext Price
CB-MON-LR-46 |  | Freestanding Monument - Low Range |  | 1
CB-ATM-WALL-60 |  | [NAME] Topper |  | 1
Recover Awning |  | Recover Awning |  | 1
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Survey |  |  | 0
 | Patch & Repair |  |  | 0
 | Foundation |  |  | 1
 | SED |  |  | 0 | 0
 | Banners & Unveiling |  |  | 0 | 0
 | Permit Procurement |  |  | 0 | 0
 | Estimated Permit Cost |  |  | 0 | 0
 |  |  |  |  | Sub Total
 |  |  |  |  | Total
Patch & Repair Needed | No
New Foundation Required | Yes
Permit Approved
Released
Spreadsheet: michelle_lokay__26750__imball0112
Sheet: Amarillo

Amarillo Natural Gas |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
contract 21534
 | poi 28786 |  | poi 56993 |  | poi 500170 |  | poi 10746 |  | poi 13247 |  | poi 500520 |  | poi 500171
 | Adobe [NAME] |  | [NAME] |  | ANG-Scott/Bandy II |  | [NAME] |  | [NAME] |  | [NAME] |  | ANG O Neal&Shadid
 | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -3406 |  |  | -25 |  | -30
2 | -1974 |  |  | -25 |  | -30
3 | -1939 | -1900 |  | -25 |  | -30
4 | -1840 | -2104 |  | -25 |  | -30
5 | -1968 | -2104 |  | -25 |  | -30
6 | -1992 | -2104 |  | -25 |  | -30
7 | -1997 | -2104 |  | -25 |  | -30
8 | -2162 | -2104 | -3 | -25 |  | -30
9 | -2166 | -2104 |  | -25 |  | -30
10 | -2128 | -2104 |  | -25 |  | -30
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
index
2001-11-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 102894.9
2001-12-10 00:00:00
CBS Volume
 |  |  | 43028
Spreadsheet: 377455d1424003791-need-some-help-please-excel-example
Sheet: Sheet 2

 | Argentina | Brazil | Chile | Spain | Mexico | Perú | Poland | Portugal | Puerto Rico | United Kingdom | United States | Uruguay | Totals
Type of Business
Sourcing
Freight
Marketing
Business Admin.
Spreadsheet: 5a4d0538-b048-42f6-827b-f86d65da432e
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
40935851 | 2014-04-11 03:17:04 | ALLIES | 0 | 4 | 6 | 1531424 | djarv | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
40935993 | 2014-04-11 03:26:21 | AXIS | 0 | 1 | 6 | 1531424 | djarv | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
40944069 | 2014-04-11 19:19:13 | ALLIES | 0 | 2 | 5 | 769684 | [NAME] | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
Spreadsheet: 005b6801-8580-4d96-b866-5fd00c9c0c81
Sheet: 9c

Product | AUD** | CAD | CHF | DKK | KRW | NOK | NZD | SEK | ZAR | TOTAL
Basis* | 54835 | 48977 | 126570 | <1,000 |  |  |  |  |  | 230382
FRA |  |  | 429656 | 119779 |  | 313253 |  | 895793 |  | 1758481
IRS- [NAME] | 1962236 | 1932629 | 1321676 | 92230 |  | 233015 | 426689 | 773483 | 377010 | 7118968
OIS |  | 93194 | 66834 |  |  |  |  |  |  | 160028
VNS
Zero Coupon |  | <1,000 |  |  |  |  |  | <1,000 |  | <1,000
TOTAL | 2017071 | 2074800 | 1944736 | 212009 | 0 | 546268 | 426689 | 1669276 | 377010 | 9267859
Estimated gross notional amount outstanding, November 9 weekly snapshot, by product type and supermajor currency (millions of USD), cleared swaps only, all participant types and tenors. 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 Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for currency descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 92697d1292261509-help-sum-by-date-and-category-ledger_example
Sheet: Sheet1

Date | Category | Amount |  | Week Start | Week End | Gas | Food | Bills
2010-12-01 00:00:00 | Gas | 31 |  | 2010-12-01 00:00:00 | 2010-12-07 00:00:00
2010-12-01 00:00:00 | Food | 18 |  | 2010-12-08 00:00:00 | 2010-12-14 00:00:00
2010-12-02 00:00:00 | Bills | 75 |  | 2010-12-15 00:00:00 | 2010-12-21 00:00:00
2010-12-03 00:00:00 | Food | 22
2010-12-05 00:00:00 | Food | 17
2010-12-07 00:00:00 | Gas | 27
2010-12-08 00:00:00 | Food | 23
2010-12-14 00:00:00 | Bills | 105
2010-12-15 00:00:00 | Gas | 28
2010-12-15 00:00:00 | Food | 14
Spreadsheet: 709926d1608629554-counting-instances-of-not-blank-and-adjacent-cells-sample-of-absence-sheet
Sheet: Sheet1

 |  | Hidden |  |  | 2020-12-14 00:00:00 | 2020-12-15 00:00:00 | 2020-12-16 00:00:00 | 2020-12-17 00:00:00 | 2020-12-18 00:00:00 | 2020-12-19 00:00:00 | 2020-12-20 00:00:00 | 2020-12-21 00:00:00 | 2020-12-22 00:00:00 | 2020-12-23 00:00:00 | 2020-12-24 00:00:00 | 2020-12-25 00:00:00 | 2020-12-26 00:00:00 | 2020-12-27 00:00:00 | 2020-12-28 00:00:00 | 2020-12-29 00:00:00 | 2020-12-30 00:00:00 | 2020-12-31 00:00:00
Person | Taken |  | Bradford | Spells
Quality Manager |  |  |  |  | 1 |  | 1 | 1 |  | 1
Maintenance
Maintenance
Operator
[NAME]
Operator
Operator
Sales Director
Team Leader
Front End Engineer
Operator
Operator
Accounts
Accounts
Operator
Goods-in
Production Manager
Operator
Engineering & Sales  Manager
Spreadsheet: 774314d1648388635-array-lookup-formula-issue-fcs-incentive-plan-expedition-class-copy-1-
Sheet: Exact Commission

VS PAX  ONBOARD | TOT. BOOKING  AMOUNT (MIN) | 0 | 8 | 11 | 17
1 | 0 | 0.0022 | 0.0029 | 0.0048 | 0.0058
 | 259952 | 0.0024 | 0.003 | 0.0045 | 0.0061
 | 329952 | 0.0026 | 0.0033 | 0.0056 | 0.0067
 | 449952 | 0.003 | 0.0039 | 0.0065 | 0.0078 |  | # VS PAX ONBOARD |  |  |  | 5
2 | 0 | 0.0022 | 0.0029 | 0.0048 | 0.0058 | BOOKING AMOUNT IN USD $ |  |  |  |  | 250000
 | 259953 | 0.0024 | 0.003 | 0.0045 | 0.0061 |  | # DAYS |  |  |  | 8
 | 329953 | 0.0026 | 0.0033 | 0.0056 | 0.0067 |  | TOTAL COMMISSION:
 | 449953 | 0.003 | 0.0039 | 0.0065 | 0.0078
3 | 0 | 0.0022 | 0.0029 | 0.0048 | 0.0058
 | 259954 | 0.0024 | 0.003 | 0.0045 | 0.0061
 | 329954 | 0.0026 | 0.0033 | 0.0056 | 0.0067
 | 449954 | 0.003 | 0.0039 | 0.0065 | 0.0078
4 | 0 | 0.0022 | 0.0029 | 0.0048 | 0.0058
 | 259955 | 0.0024 | 0.003 | 0.0045 | 0.0061
 | 329955 | 0.0026 | 0.0033 | 0.0056 | 0.0067
 | 449955 | 0.003 | 0.0039 | 0.0065 | 0.0078
5 | 0 | 0.0022 | 0.0029 | 0.0048 | 0.0058
 | 259956 | 0.0024 | 0.003 | 0.0045 | 0.0061
 | 329956 | 0.0026 | 0.0033 | 0.0056 | 0.0067
 | 449956 | 0.003 | 0.0039 | 0.0065 | 0.0078
Spreadsheet: 195359d1353500682-remove-duplicate-text-sample_1
Sheet: Sheet1

ID | A1 | B1 | Answer should be in this formate
1 | Rain Bazar Graveyard | rain [NAME], Rain Bazar Road | Rain Bazar Road
2 | [NAME] | [NAME],rangeli,Khidki Road | Rangeli Khidki, Road
3 | Rain Bazar Graveyard | Rain Bazar Graveyard,Shalbagh Main Road | Shalbagh Main Road
4 | [NAME] | [NAME], Yakutpura Road | Yakutpura Road
5 | Talab Katta Graveyard | Talab Katta Graveyard ,118/25/B,Bibi Bazar X Road | 118/25/B,Bibi Bazar X Road
6 | vijay [NAME] | Vijay Nagar Colony Graveyard,Vijay Nagar Colony Road | [NAME]
7 | Bazar Ghat Graveyard | Bazar Ghat Graveyard,Bazar Ghat Road,pu | Bazar Ghat Road, Pu
Spreadsheet: 551815d1513173025-show-error-in-cells-q34-and-q42-if-c3-q2-is-left-blank-rer
Sheet: PRODUCT

Item Code | Details | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
or17 | lei joda 2nd | 2.61 |  |  |  |  |  |  |  |  |  |  |  |  | 2017-10-30 11:37:41
NP1 | 1 joda nanapi wtst 5.26 | 5.18 |  |  |  |  |  |  |  |  |  |  |  |  | 2017-10-30 11:38:51
BM31 | balting mana thread 1st quality | 4.46
BM33 | balting mana thread 1st quality | 4.56
N10 | 1st gents earing | 1.93 |  |  |  |  |  |  |  |  |  |  |  |  | 2017-10-13 10:15:28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-10-30 09:05:41
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-11-03 11:54:30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-11-14 15:11:10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-11-14 15:13:19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-11-17 17:05:56
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-11-22 09:09:40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-12-06 16:05:11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-12-07 13:05:49
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-12-07 13:16:02
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-12-07 15:47:57
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-12-09 13:10:11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-12-12 21:28:29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2017-12-12 21:24:31
Spreadsheet: 699588d1602673789-automatically-update-one-sheet-from-multiple-sheets-direct-lead-tracker
Sheet: Team Overview

BDM | Total Number of Agents | Total Number of Branches | Total Leads Received | Total 1st Appointment Booked | Total Contracts Out | Total Contracts Back
DV
Gemma
Mark
Will
Spreadsheet: 888096d1738486507-auto-total-from-a-list-example
Sheet: Sheet1

Date | Shop | Type | Item | Weight in grams | Amount | Price | Price each |  |  | Totals
2024-12-23 00:00:00 | WHSmith | Magazine | Computer active |  | 1 | 3.2 |  |  | Magazines
 | Poundland | Kitchen | Non-stick pan |  | 1 | 8 |  |  | Kitchen
 |  | Kitchen | Food containers with lids |  | 5 | 1.5 |  |  | Health
 |  | Kitchen | Cling film 300mm x 50m |  | 1 | 1 |  |  | Food
 |  | Food | Coffee mate | 550 | 1 | 4.75 |  |  | Misc
 | Superdrug | Health | S/D Ibuprofen x16 |  | 1 | 3.49
 |  | Health | Colgate Toothpaste | 75 | 1 | 0.99
 | Lidl | Misc | Heavy duty carrier bag |  | 1 | 0.65
 |  | Food | White Potatoes | 2000 | 1 | 0.08
 |  | Food | Red apples |  | 6 | 1.19
 |  | Food | Bananas |  | 5 | 0.78
 |  | Food | Fat free natural yoghurt | 500 | 2 | 0.9
 |  | Food | [NAME] |  | 2 | 0.78
 |  | Food | Mature Cheddar | 400 | 1 | 2.69
 |  | Food | Closed cup mushrooms | 400 | 1 | 1.19
 |  | Food | Pink onions | 750 | 1 | 0.69
Spreadsheet: 769069d1645278152-adding-extra-spaces-in-a-cell-separating-data-from-a-single-cell-aligw-xlsx-version
Sheet: Sheet3

 | 73.29 BF2192 Brown-line Bright-eye [NAME] conigera
 | 73.291 BF2199 [NAME] Mythimna pallens
 | 73.292 BF2200 [NAME]'s Wainscot [NAME] favicolor
 | 73.293 BF2198 [NAME] [NAME] impura
 | 73.294 BF2197 Southern Wainscot [NAME] straminea
 | 73.295 BF2195 The Delicate [NAME] vitellina
 | 73.296 BF2203 White-speck [NAME] unipuncta
 | 73.297 BF2194 White-point [NAME] albipuncta
 | 73.298 BF2193 The Clay Mythimna ferrago
 | 73.299 BF2201 Shore Wainscot [NAME] litoralis
 | 73.3 BF2202 L-album Wainscot Mythimna l-album
 | [NAME] Shoulder-striped [NAME] Leucania comma
 | 73.302 BF2204 Obscure Wainscot Leucania obsoleta
 | 73.303 BF2206 [NAME] Leucania putrescens
 | 73.3031 BF2210 The Maori Graphania averilla [NAME]
Spreadsheet: 5702d052-21ca-4a99-a01c-48e0d30dd997
Sheet: age graph

back to tables |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Column Labels
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Values | <18 | 18 & 19 | 20 to 24 | 25 to 29 | 30 to 34 | 35 to 39 | 40 to 49 | 50 + | Unknown | Grand Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AY07-08# | 327 | 1771 | 2355 | 949 | 618 | 473 | 736 | 512 | 2 | 7743
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AY08-09# | 395 | 2206 | 2709 | 1063 | 693 | 575 | 771 | 484 | 0 | 8896
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AY09-10# | 277 | 2301 | 3186 | 1291 | 714 | 551 | 871 | 501 | 2 | 9694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AY10-11# | 131 | 1850 | 2993 | 1061 | 605 | 417 | 678 | 406 | 1 | 8142
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AY11-12# | 76 | 1680 | 2943 | 1012 | 552 | 390 | 587 | 366 | 1 | 7607
Spreadsheet: 726804d1617477501-dynamic-array-spill-and-sort-into-2-columns-spill-and-sort
Sheet: Sheet1

 | NOTE: There will name be more than 10 Unique Names
 | SOURCE TABLE |  |  |  |  | CURRENT FUNCTION |  |  |  | WHAT I'D LIKE (SPILT INTO TWO COLUMNS AND SORTED BY TOTAL) |  |  |  |  |  |  | WHAT SHOULD HAPPEN IF THERE ARE 5 OR LESS UNIQUE NAMES
 | Name | Dividend Date | Total |  |  | Name | Total |  |  | Name | Total |  | Name | Total |  |  | Name | Total |  | Name | Total
 | Arizona | 2021-01-31 00:00:00 | 345 |  |  |  |  |  |  | Florida | 987 |  | Georgia | 414 |  |  | Florida | 987
 | Maine | 2020-04-15 00:00:00 | 216 |  |  |  |  | 414 |  | Illinois | 933 |  | Arizona | 345 |  |  | Illinois | 933
 | Georgia | 2021-03-15 00:00:00 | 267 |  |  |  |  | 589 |  | Maine | 787 |  | Washington | 237 |  |  | Maine | 787
 | California | 2021-08-09 00:00:00 | 589 |  |  |  |  | 933 |  | Alabama | 753 |  |  |  |  |  | Alabama | 753
 | Illinois | 2021-09-07 00:00:00 | 246 |  |  |  |  | 987 |  | California | 589
 | Florida | 2021-12-01 00:00:00 | 987 |  |  |  |  | 753 |  | BREAK AT 5 UNIQUE NAMES |  |  |  |  |  |  | LESS THAN 5 UNIQUE NAMES
 | Georgia | 2021-02-28 00:00:00 | 147 |  |  |  |  | 787
 | Alabama | 2021-04-15 00:00:00 | 753 |  |  |  |  | 237
 | Maine | 2021-06-12 00:00:00 | 23
 | Arizona | 2020-12-12 00:00:00 | 237 |  |  |  |  |  |  |  | 987 |  | Georgia | 414
 | Illinois | 2021-03-13 00:00:00 | 687 |  |  |  |  |  |  | Illinois | 933 |  | Arizona | 345
 | Washington | 2021-11-23 00:00:00 | 237 |  |  |  |  |  |  | Maine | 787 |  | Washington | 237
 | New York | 2020-02-09 00:00:00 | 975 |  |  |  |  |  |  | Alabama | 753
 | Maine | 2021-11-06 00:00:00 | 764 |  |  |  |  |  |  | California | 589
Spreadsheet: 542798d1508105667-my-lookup-table-gets-confused-invoice-framework-mock-up-bvj-
Sheet: Sheet1

Date: October 15 2017
S.O. # | Recive | Commodity | Destination | Rate ($) | Weight (Mt) | Amount($)
123456 | 123456789 | Beans | Chatham |  | 10
123456 |  | Beans | Windsor |  | 10
234567 |  | Wheat | Transfer Thamesville |  | 10
543216 |  | Corn | Suncore |  | 10
111111 |  | Beans |  |  | 10
1111111 |  | Wheat |  |  | 10
1254367 |  | Beans |  |  | 10
123453 |  | Corn |  |  | 10
82671534 |  | Wheat |  |  | 10
 |  |  |  |  | 10
Total:
 |  | Corn | Alymer | 12.5
 |  | Beans | Cargill | 9.5
 |  | Wheat | Chatham | 7.5
 |  |  | Suncore | 8
 |  |  | Thamesville | 7.5
 |  |  | Transfer Thamesville | 6
 |  |  | Transfer Tupperville | 6
 |  |  | Tupperville | 7.5
 |  |  | Windsor | 12
Spreadsheet: 293630d1391039856-finding-duplicate-and-or-similar-info-across-columns-and-highlight-names-and-addresses-example
Sheet: Sheet1

Business Name | FIRST NAME | LAST NAME | Shipping Address | City | State | Zip Code | Country
 | [NAME] | [NAME] | PO Box 2138 | Meridian | ca | 83642 | USA
 | [NAME] | [NAME] | PO Box 122 | Dickinson | mo | 80020 | USA
 | [NAME] | [NAME] | P.O. Box 1125 | [NAME] | ne | 3876 | USA
 | [NAME] | [NAME] | 3820 Pie Court | Troy | wy | 99006 | USA
 | [NAME] | Ares | 31 allcock road R.D. 6 | Te Awamutu | ny | 98005 | USA
 | Kenny | [NAME] | 3033 135th ave ne | Deer Park | ut | 58601 | USA
 | Lucas | allcock | 2599 Weber Rapids | Bellevue | co | 22003 | USA
 | [NAME] | [NAME] | 20930 E Happy Trails Lane | [NAME] | wa | 83830 | USA
 | [NAME] | Jones | 1612 Prairie ave #2 | Wilbraham | ca | 99027 | USA
 | Kenny | [NAME] | 3033 135th ave ne | Deer Park | ut | 58601 | USA
 | [NAME] | [NAME] | 15 Falcon Heights Rd. | Fernwood | nv | 82435 | USA
 | [NAME] | [NAME] | 12642 Hazel Street | Otis Orchards | tx | 83812 | USA
 | [NAME] | [NAME] | 1073 road 12 | Annandale | [NAME] | 01095 | USA
 | [NAME] | Jones | 1612 Prairie ave #2 | Wilbraham | ca | 99027 | USA
 | [NAME] | [NAME] | P.O. Box 122 | Dickinson | mo | 80020 | USA
 | [NAME] | [NAME] | PO Box 2138 | Meridian | ca | 83642 | USA
 | [NAME] | [NAME] | PO Box 122 | Dickinson | mo | 80020 | USA
 | [NAME] | [NAME] | P.O. Box 1125 | [NAME] | ne | 3876 | USA
 | [NAME] | [NAME] | 3820 Pie Court | Troy | wy | 99006 | USA
 | [NAME] | Ares | 31 allcock road R.D. 6 | Te Awamutu | ny | 98005 | USA
 | Kenny | [NAME] | 3033 135th ave ne | Deer Park | ut | 58601 | USA
 | Lucas | allcock | 2599 Weber Rapids | Bellevue | co | 22003 | USA
 | [NAME] | [NAME] | 20930 E Happy Trails Lane | [NAME] | wa | 83830 | USA
 | [NAME] | Jones | 1612 Prairie ave #2 | Wilbraham | ca | 99027 | USA
 | Kenny | [NAME] | 3033 135th ave ne | Deer Park | ut | 58601 | USA
 | [NAME] | [NAME] | 15 Falcon Heights Rd. | Fernwood | nv | 82435 | USA
 | [NAME] | [NAME] | 12642 Hazel Street | Otis Orchards | tx | 83812 | USA
 | [NAME] | [NAME] | 1073 road 12 | Annandale | [NAME] | 01095 | USA
 | [NAME] | Jones | 1612 Prairie ave #2 | Wilbraham | ca | 99027 | USA
 | [NAME] | [NAME] | P.O. Box 122 | Dickinson | mo | 80020 | USA
 | If the first lame, last name, city, and [NAME] highlight all cells, no need for diff colors, just an example
Spreadsheet: 232309d1367384920-society-scoring-system-template-society-scoring-system-template
Sheet: wellingborough

 |  |  | Am Results |  |  |  |  |  |  |  | Pm Results
 | Name         H/caps |  | Front 9 | Back 9 | Total | Points |  |  | Name         H/caps |  | Front 9 | Back 9 | Total | Points
Leaders in red
 | Team Ball   A Walker A stokes M Stokes  63 points
 | Handicap change A Stokes 16  N Turner 13   J Cooper 9
Spreadsheet: 83927d1283962951-conditional-look-up-or-if-statement-active-cc
Sheet: Sheet1

 |  | Chase (WaMu) | Amazon | Citi Platinum | [NAME] | [NAME] | Citi Forward | Citi (Jillian) | 53rd | [NAME] ([NAME]) | [NAME] (Jillian) | Discover
2010-09-01 00:00:00 | Bills |  | 20
2010-09-01 00:00:00 | Groceries |  |  | 50 |  |  |  | 800
2010-09-01 00:00:00 | Gas |  |  |  |  | 70
2010-09-01 00:00:00 | Misc |  |  |  | 100 |  |  |  | 900
2010-09-01 00:00:00 | Big Purchase |  |  | 1256
2010-10-01 00:00:00 | Bills |  | 70 |  | 60
2010-10-01 00:00:00 | Groceries |  |  | 50 |  |  |  | 800
2010-10-01 00:00:00 | Gas |  |  |  |  | 70
2010-10-01 00:00:00 | Misc |  |  |  | 50 |  |  |  | 800
2010-10-01 00:00:00 | Big Purchase |  |  | 10 |  | 100