tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 823510d1679995746-number-of-suppliers-grouped-and-not-grouped-book2
Sheet: Sheet1

Logistics |  |  |  | Total | Ungrouped
[NAME] |  |  | [NAME]
Supplier 1 |  |  | Logistics/Undefined
Supplier 2 |  |  | Movable Material Handling Equipment
Supplier 3
Supplier 4
Supplier 5
Supplier 6
Supplier 7
Supplier 8
Supplier 9
Supplier 10
Supplier 11
Supplier 12
Supplier 13
Supplier 14
Supplier 15
Supplier 16
Supplier 17
Supplier 18
Logistics/Undefined
Supplier 1
Movable Material Handling Equipment
Supplier 1
Supplier 2
Supplier 3
Supplier 4
Supplier 5
Supplier 6
Spreadsheet: 843013d1694990547-calculate-the-duration-book1-71-ans
Sheet: Sheet1

start | end | duration | FORMULA
2023-09-15 09:00:00 | 2023-09-15 12:00:00 | 3 hours
2023-09-15 09:00:00 | 2023-09-17 12:00:00 | 1 day 3 hours
2023-09-15 09:00:00 | 2023-09-19 16:30:00 | 2 days 7 hours 30 Mins
2023-09-14 09:00:00 | 2023-09-15 10:00:00 | 1 day 1 hour
2023-09-15 00:00:00 | Friday
2023-09-16 00:00:00 | Saturday
2023-09-17 00:00:00 | Sunday
2023-09-18 00:00:00 | Monday
2023-09-19 00:00:00 | Tuesday
2023-09-20 00:00:00 | Wednesday
2023-09-21 00:00:00 | Thursday
Spreadsheet: darrell_schoolcraft__7307__imball0201
Sheet: Agave

Agave imbalance
 | Measured | Scheduled | Imbalance
56339 | 665672 | 658331
78311 | 251333 | 237052 |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500238 | 571524 | 587795 |  |  |  |  |  |  |  |  | lunch | 7.6
500239 | 651744 | 540286
500293 | 381956 | 418666
500302 |  | 6105
500303 |  | 212317
500305 | 1079719 | 1008860
500307 | 62700 | 27664
500313 |  | 1313
500314
500655 | 159117
500657 | 116429 | 146988
INDEX
2001-12-31 00:00:00 |  |  | 40609.26
2002-01-21 00:00:00
CBS Volume
 |  |  | 31706
Spreadsheet: 850406d1700749476-my-formula-is-not-getting-me-a-round-number-book30
Sheet: Sheet1

 | Quantity | rate | total amount | Calculation | % | Check
 | -31880 | 0.0081 | -258.23 |  | 1
 | 488 | 0.25 | 122 |  | 1
 | 1345 | 0.3219 | 432.96 |  | 1
 | 1345 | 0.4125 | 554.81 |  | 1
 | 149 | 0.75 | 111.75 |  | 1
 | 8687 | 0.235 | 2041.45 |  | 1
 | 38317 | 0.0133 | 509.62 |  | 1
 | -20024 | 0.0205 | -410.49 |  | 1
 | -20024 | 0.0224 | -448.54 |  | 1
 | 278 | 0.44 | 103.97 |  | 0.85
Spreadsheet: 863247d1710809926-pull-range-of-values-based-on-upper-and-lower-bound-in-1-or-2-cells-book4
Sheet: ListPull 

Low Bound | 0.9
High Bound | 1.2
List Desired from sheet1
0.9 | Prod A
0.9 | Prod B
0.9 | Prod C
1 | Prod D
1 | Prod E
1 | [NAME]
1.1 | [NAME]
1.1 | Prod H
1.2 | Prod I
1.2 | Prod J
Spreadsheet: 853713d1703670785-formula-for-total-number-in-diff-column-total-for-each-person
Sheet: Sheet1

Name | Hobby | total 1 | total 2
[NAME] | Football |  |  |  | is there any automation formula in coloumn C & D for Total for each person ?
14 | 2 | 0 | 0 |  | currently I only use Manual SUM Function for it
15 | 3 | 0 | 0
66 | 4 | 0 | 0
[NAME] | Swimming
15 | 5 | 0 | 0
16 | 8 | 0 | 0
[NAME] | Dance
45 | 4 | 0 | 0
33 | 3 | 0 | 0
25 | 4 | 0 | 0
67 | 5 | 0 | 0
8 | 6 | 0 | 0
23 | 1 | 0 | 0
45 | 3 | 0 | 0
Jhon | Running
15 | 1 | 0 | 0
Spreadsheet: michelle_lokay__26587__keyexRevenueList2
Sheet: Summary

 |  | SUMMARY
INVITATIONS SENT |  |  | 141
 | Northern |  |  | 91 |  | Top 20 |  | 43
 | TW |  |  | 30 |  | Top 25 |  | 27
 | Other |  |  | 20
ATTENDEES |  |  | 86
 | Northern |  |  | 44 |  | Top 20 |  | 18
 | TW |  |  | 9 |  | Top 25 |  | 8
 | Other |  |  | 5
 | Employees/Speakers |  |  | 28
Spreadsheet: 777724d1650563989-remove-duplicates-remove-duplicates
Sheet: Sheet1

Member [NAME] | First Name | Last Name | Member [NAME] | Member [NAME] | Member [NAME] | Member Name 6 | Member [NAME] | Member [NAME] 8 | Relationship Code
Mora, Daniel | Daniel | [NAME] | Mora, Daniel | Mora-estrada, Daleyza | 0 | 0 | 0 | 0 | Dependent
Mora-estrada, Daleyza | Daleyza | Mora-estrada | Mora, Daniel | Mora-estrada, Daleyza | 0 | 0 | 0 | 0 | Dependent
Knapp, [NAME] | [NAME] | Knapp | Knapp, [NAME] | Knapp, [NAME] | 0 | 0 | 0 | 0 | Dependent
Knapp, [NAME] | [NAME] | Knapp | Knapp, [NAME] | Knapp, [NAME] | 0 | 0 | 0 | 0 | Dependent
Emond, [NAME] | Emma | Emond | Emond, [NAME] | Emond, Gage | 0 | 0 | 0 | 0 | Dependent
Emond, Gage | Gage | Emond | Emond, [NAME] | Emond, Gage | 0 | 0 | 0 | 0 | Dependent
Murphy, Braxton | Braxton | Murphy | Murphy, Braxton | Murphy, [NAME] | 0 | 0 | 0 | 0 | Dependent
Murphy, [NAME] | Raider | Murphy | Murphy, Braxton | Murphy, [NAME] | 0 | 0 | 0 | 0 | Dependent
[NAME], [NAME] | [NAME] | [NAME] | [NAME], [NAME] | [NAME], [NAME] | 0 | 0 | 0 | 0 | Dependent
[NAME], [NAME] | Thomas | [NAME] | [NAME], [NAME] | [NAME], [NAME] | 0 | 0 | 0 | 0 | Dependent
Ryczek, [NAME] | [NAME] | Ryczek | Ryczek, [NAME] | Ryczek, Adera | 0 | 0 | 0 | 0 | Dependent
Ryczek, Adera | Adera | Ryczek | Ryczek, [NAME] | Ryczek, Adera | 0 | 0 | 0 | 0 | Dependent
Barlas, [NAME] | [NAME] | Barlas | Barlas, [NAME] | Barlas, [NAME] | 0 | 0 | 0 | 0 | Dependent
Barlas, [NAME] | Joan | Barlas | Barlas, [NAME] | Barlas, [NAME] | 0 | 0 | 0 | 0 | Dependent
Elsbury, Warner | Warner | Elsbury | Elsbury, Warner | Elsbury, [NAME] | Elsbury, [NAME] | 0 | 0 | 0 | Dependent
Elsbury, [NAME] | Henry | Elsbury | Elsbury, Warner | Elsbury, [NAME] | Elsbury, [NAME] | 0 | 0 | 0 | Dependent
Elsbury, [NAME] | [NAME] | Elsbury | Elsbury, Warner | Elsbury, [NAME] | Elsbury, [NAME] | 0 | 0 | 0 | Dependent
Spreadsheet: 33608d1230062439-excel-2007-populating-from-one-worksheet-to-another-rehab-cost-estimate
Sheet: Contractor Bid Sheet

 | [NAME]
 | Address
 | Labor & Material Items |  |  | Number needed |  | Quote
 | Replace Roof (Labor & Materials) |  |  | Contractor Measure
 | Paint Exterior (Labor & Materials) |  |  | Contractor Measure
 | Paint Interior (Labor & Materials) |  |  | Contractor Measure
 | Landscaping (Labor & Materials) |  |  | Contractor Measure
 | Foundation (Labor & Materials) |  |  | Contractor Measure |  |  |  |  | All Contractor Measure items require a separate detailed bid sheet
 | Driveway (Labor & Materials) |  |  | Contractor Measure
 | Central Heat and Air (Labor & Materials) |  |  | Contractor Measure
 | Drywall (Labor & Materials) |  |  | Contractor Measure
 | Electrical (Labor & Materials) |  |  | Contractor Measure
 | Plumbing (Labor & Materials) |  |  | Contractor Measure
 | Install Bathroom Cabinets |  |  | Contractor Measure
 | Install Kitchen Cabinets |  |  | Contractor Measure
 | Labor Only Items
 | Install Hot Water Heater |  |  | 1
 | Install Carpet |  |  |  | sq ft
 | Install Tile |  |  |  | sq ft
 | Install Linoleum |  |  |  | sq ft
 | Refinish existing wood floors |  |  |  | sq ft
 | Install Ceiling Fans |  | Yes
 | Install Overhead Lights |  | Yes
 | Install Blinds |  | Yes
 | Install Light Switches |  | Yes
 | Install GFI Outlets |  | Yes
 | Install Electrical Outlets |  | Yes
 | Install Switch & Outlet Covers |  | Yes
 | [NAME]
 | Replace Tub
 | [NAME]
 | Install Toilets
 | Install Kitchen Sink |  |  | 1
 | Install Kitchen Faucet |  |  | 1
 | Install Bathroom Sinks
 | Install Bathroom Faucets
 | Install Pedestal Sink
 | Install Vanity/ Sink Combo
 | Install Bathroom Exhaust Fan
 | Install Vanity Lights
 | Install Interior Door Knobs |  | Yes
 | Install Interior Doors
 | Install Exterior Doors
 | Install Door Knob/ Dead Bolt Combo
 |  |  |  | Total
 | Days to perform items quoted
 | Signature |  |  |  |  | Date
 | List without blanks
 |  | 0 | 1 | @ | 79.96 | 0 | 79.96 | 0 | 0 | 0 | 79.96
 | Blinds | 0 | 1 | @ | 8 | 0 | 8 | 0 | 0 | 0 | 8
 | Switch & Outlet Covers | 0 | 1 | @ | 0.44 | 0 | 0.44 | 0 | 0 | 0 | 0.44
 | Exterior Door | 0 | 1 | @ | 200 | 0 | 200 | 0 | 0 | 0 | 200
 | Carpet Pad | 0 | 1 | ft @ | 0.44 | 0 | 0.44 | 0 | 0 | 0 | 0.44
Spreadsheet: cdbed530-6751-45b7-846d-dbc3d0029da9
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
8221 | 53867 | Sean | Vangerena | USA | 0 | 00:00:00 | 00:00:00 | 04:19:50 | [NAME] | 02:53:22 | 1 | 07:16:03
8221 | 52932 | Nick | Ruane | NZL | 0 | 00:00:00 | 00:00:00 | [NAME] | 00:05:57 | 03:10:18 | 2 | 07:57:52
Spreadsheet: 860153d1708360367-need-help-with-rag-status-for-multiple-projects-project-kpi-status
Sheet: RAG Key for KPIs

[NAME]:
KPI | RED | AMBER | GREEN
Delivery | Major delay (1-2 weeks) | Minor delay (<1 week) | On-time
Utilization | <90% | <95% but >90% | 95-100%
Quality | Major issues & Negative feedback | Minor issues & No negative feedback | No issues & Good feedback
Resources | Unavailable | Shortfall | Available
Spreadsheet: 689717d1596616447-help-needed-excel-formula-yes-no-na-and-auto-zero-scoring-sample
Sheet: Sheet1

No. | Compliance 1 |  |  |  | Error Type | Yes/No/NA | Scores |  |  |  |  | Pass
1 | Category 1 |  |  |  | Auto Zero | Pass |  |  |  |  |  | Fail
 |  |  |  |  |  |  |  |  |  |  |  | NA
 | Compliance 2
2 | Category 2
2.A | Sub Category 1 |  |  |  | Auto Zero | Pass
2.B | Sub Category 2 |  |  |  | Auto Zero | NA
[NAME] | Sub Category 3 |  |  |  | Auto Zero | Pass
3 | Category 3
3.A | Sub Category 1 |  |  |  | Auto Zero | Pass
3.B | Sub Category 1 |  |  |  | Auto Zero | Pass
3.C | Sub Category 1 |  |  |  | Auto Zero | NA
4 | Category 4
4.A | Sub Category 1 |  |  |  | NON-FATAL | Pass
4.B | Sub Category 1 |  |  |  | Auto Zero | Pass
4.C | Sub Category 1 |  |  |  | Auto Zero | Pass
Spreadsheet: 64efc0e3-eb3b-4fc6-b73a-d8f37d420905
Sheet: Sheet1

FY 2011 AEA STATE AID PAYMENTS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  | ORIGINAL | SEPT-NOV | PAID THROUGH | AMOUNT
 |  | BUDGET | PAYMENT | NOVEMBER | REMAINING
1 | [NAME] 1 | 13431398 | 1343141 | 4029423 | 9401975
5 | PRAIRIE LAKES AEA 8 | 13196032 | 1319603 | 3958809 | 9237223
7 | AEA 267 | 28293632 | 2829366 | 8488098 | 19805534
9 | MISSISSIPPI BEND AEA 9 | 19600648 | 1960068 | 5880204 | 13720444
10 | GRANT WOOD AEA 10 | 27263347 | 2726336 | 8179008 | 19084339
11 | HEARTLAND AEA 11 | 49241026 | 4924107 | 14772321 | 34468705
12 | NORTHWEST AEA | 16359617 | 1635961 | 4907883 | 11451734
13 | LOESS HILLS AEA 13 | 16376170 | 1637617 | 4912851 | 11463319
15 | GREAT PRAIRIE AEA 15 | 15006162 | 1500620 | 4501860 | 10504302
 |  | 198768032 | 19876819 | 59630457 | 139137575
Spreadsheet: 879663d1727226424-format-row-colors-based-on-time-cf-time-eba
Sheet: Sheet1

 |  |  | Morning | Afternoon | Night
 |  |  | 06:00:00 | 12:00:00 | 18:00:00
2024-03-16 00:00:00 | 20:00:00
2024-03-19 00:00:00 | 19:00:00
2024-03-21 00:00:00 | 20:00:00
2024-03-23 00:00:00 | 12:00:00
2024-03-23 00:00:00 | 20:00:00
2024-03-26 00:00:00 | 13:00:00
2024-03-26 00:00:00 | 22:00:00
2024-03-27 00:00:00 | 10:00:00
2024-03-27 00:00:00 | 20:00:00
2024-03-28 00:00:00 | 20:00:00
2024-03-29 00:00:00 | 20:00:00
2024-03-30 00:00:00 | 20:00:00
2024-03-31 00:00:00 | 21:00:00
2024-04-01 00:00:00 | 20:00:00
2024-04-04 00:00:00 | 21:00:00
2024-04-05 00:00:00 | 21:00:00
2024-04-11 00:00:00 | 21:00:00
2024-05-15 00:00:00 | 22:00:00
2024-05-19 00:00:00 | 21:00:00
2024-05-20 00:00:00 | 21:00:00
2024-05-22 00:00:00 | 20:00:00
2024-05-23 00:00:00 | 21:00:00
2024-05-24 00:00:00 | 09:00:00
Spreadsheet: 231504d1367098248-two-misaligned-cells-16-team-planning-bracket
Sheet: 120

az120 | Aztec | 1
bl120 | Bloomfield
cib120 | Cibola
cle120 | Cleveland
far120 | Farmington
gal120 | Gallup
grt120 | Grants | 8
kc120 | [NAME]
miy120 | Miyamura | 5
new120 | Newcomb
pv120 | Piedra Vista
rr120 | Rio Rancho
sf120 | Santa Fe
ship120 | Shiprock
vv120 | [NAME] | 4
win120 | Wingate
 |  | 3
Paste Value - CTRL-N
 |  | 6
 |  | 7
 |  | 2
Spreadsheet: 004f542c-a245-4cea-a8c2-867b80002117
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 40. OPERATING LEASE FINANCE COMMITMENTS: By Lender: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Banks ; |  |  | Original | A2413831L | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Finance Companies ; |  |  | Original | A2413832R | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
General Financiers ; |  |  | Original | A2413833T | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
Other Lessors ; |  |  | Original | A2413834V | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413835W | 1985-01-01 00:00:00 | 2012-11-01 00:00:00 | 335 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2013
Spreadsheet: 131021d1322692963-automatic-data-insertion-803727-automatic-data-insertion-examplecalc
Sheet: Foods

Food Description | Meaurement | Unit | GDI |  | Calories | Protein | Carbohydrate | Carbs as Sugars | Fat | Fats as Saturates | Fibre | mono-unsaturates | polyunsaturates | Salt | Salt as Sodium
GDA |  |  |  |  | 2500 | 55 | 300 | 120 | 95 | 300 | 24 |  |  | 2.4 | 6
Special Drink | 250 | ml |  |  | 250 | 14 | 35 | 31 | 2.5 | 0.4 | 4 |  |  |  | 0.24
Potatoes Mashed (200G) | 200 | g |  |  | 197 | 3.6 | 26.5 |  | 8.1 |  | 3
Spreadsheet: 848931d1699534199-no-grid-lines-in-particular-columns-media-log-aligw
Sheet: Film recommendations

Title
[NAME] Hotel (1979)
Lips of Blood (1975)
Witchfinder General (1968)
[NAME] (1979)
Last Exit to Brooklyn (1989)
[NAME] World Cinema Project
White Boy (2017)
52 Pick-Up (1986)
Warning from Space (1956)
The Singing Detective (1986)
[NAME] (1944)
The Man Who Laughs (1928)
Vasya (2002)
A Woman Under the Influence (1974)
[NAME] (1971)
Uncommon Valor (1983)
Colin Quinn & Friends: A Parking Lot Comedy Show
Empire of Dust (2011)
Raising Arizona (1987)
Victoria (2015)
The [NAME] (2020)
Syndromes and a Century (2006)
Picnic (1955)
The Chess Game of the Wind (1976)
The Rider (2017)
שנות השמונים
The Legend of Billie Jean (1985)
[NAME] and [NAME] (2008)
the killer elite (1975)
Mindhunter (2017)
This Is My Desire (2020)
Land Without Bread (1933)
Mandabi (1968)
The Last Seduction (1994)
Drive (1997)
Genius Party & Genius Party Beyond
Eyes of Fire (1983)
The Lovers on the Bridge (1991)
Red Desert (1964)
Billions (2016)
[NAME] (2002)
In the Mouth of Madness (1994)
Man on a Swing (1974)
Life Is Sweet (1990)
[NAME] (1975)
The House [NAME] (2018)
Night Tide (1961)
The Motive (2021)
Out of the Blue (1980)
קלף מלוכלך (2021)
The Beatles: Get Back (2021)
Bringing Up Baby (1938)
Revolver (1973)
[NAME] (1980)
Crimes and Misdemeanors (1989)
Tomorrow (1972)
Too Late for Tears (1949)
Born to [NAME] (1947)
מישהו לרוץ איתו
[NAME]
Naked (1993)
Falling Down (1993)
The Mother and the Whore (1973)
The Stepfather (1987)
Diner (1982)
The Catherine Tate Show
The Last Detail (1973)
Wag the Dog (1997)
10 Years with [NAME] (2019)
Future Boy Conan (1978)
Whisper of the Heart (1995)
Let's Scare Jessica to Death (1971)
[NAME] (1987)
[NAME] (TV Series 2015–2018)
The [NAME] and the Clergyman
Nadja (1994)
[NAME] (1988)
The Hunger (1983)
The Burnt Orange Heresy (2019)
The White Lotus
Style Wars (1983)
The [NAME] Teacher (2001)
[NAME] (1979)
The Velvet Underground (2021)
Snake Eyes (1998)
[NAME] (1984)
King [NAME] (1988)
Leaving Las Vegas (1995)
[NAME] (1972)
Making Mr. [NAME] (1987)
Baby Face (1933)
Labyrinth of Dreams (1997)
Succession
by Brakhage: an anthology
i'm [NAME]
To Die For (1995)
Class of 1984 (1982)
Over the Edge (1979)
The Decline of Western Civilization Part II
Looker (1981)
[NAME] (1986)
East Is East (1999)
Sexy Beast (2000)
[NAME] (1986)
A Fish Called [NAME] (1988)
The Shout (1978)
Amateur (1994)
[NAME] (1922)
Pickup on South Street (1953)
One False Move (1992)
Alice Doesn't Live Here Anymore (1974)
Prince of Darkness (1987)
Spreadsheet: andy_zipper__165__DYNEGY-ICE VOL Apr9
Sheet: Enron Activity - Dynegy Direct

DYNEGY DIRECT
Transactions and Notional Volume
By Enron Entity, Commodity, and [NAME]
Note: Total Activity for Dynegy Direct is not available, therefore Enron's percentage can not be calculated
Enron North America - Dynegy Direct |  |  |  |  | Enron Power Marketing - Dynegy Direct |  |  |  |  | Enron Global Liquids - Dynegy Direct
 |  | Data |  |  |  |  | Data |  |  |  |  | Data
Major Commodity | Enron Trader | Transactions | Notional Volume |  | Major Commodity | Enron Trader | Transactions | Notional Volume |  | Major Commodity | Enron Trader | Transactions | Notional Volume
Power | [NAME] | 1 | 800 |  | Power | [NAME] | 3 | 26400 |  | (blank) | #N/A | 1 | 0
Power Total |  | 1 | 800 |  |  | [NAME] | 2 | 1600 |  | (blank) Total |  | #N/A | 0
US Natural Gas | [NAME] | 2 | 10000 |  | Power Total |  | 5 | 28000 |  | Grand Total |  | #N/A | 0
 | [NAME] | 9 | 45000 |  | Grand Total |  | 5 | 28000
 | [NAME] | 2 | 10000
US Natural Gas Total |  | 13 | 65000
Grand Total |  | 14 | 65800
Spreadsheet: 122612d1317029427-lookup-value-across-a-row-and-then-countif-book1_joesmalls-
Sheet: Sheet2

Department | Active Employees | Non-Active Employees | Unclassified
Department 1
Department 2
Department 3
Department 4
Department 5
Or
From [NAME]-down | Active Employees | Non-Active Employees | Unclassified
Department 2
Spreadsheet: 683709d1592910202-sum-display-not-displaying-properly-excelexample
Sheet: Sheet1

2020-06-23 00:00:00 | -46933.63 | -38227 | -23808.2 | -58002 | -208897 | -174979 | -80825 | -116651.09 | -246100 | -994422.92
2020-06-18 00:00:00 | -47343.63 | -41971 | -33130.2 | -83022 | -214474 | -182395 | -80825 | -122267.09 | -207520 | -1012947.92
2020-06-15 00:00:00 | -47343.63 | -41971 | -33130.2 | -85913 | -266363 | -182395 | -80825 | -122267.09 | -158155 | -1018362.92
2020-06-11 00:00:00 | -47343.63 | -42074 | -33130.2 | -131913 | -268598 | -184092 | -80825 | -122711.09 | -134813 | -1045499.92
2020-06-09 00:00:00 | -47343.63 | -46769.25 | -33130.2 | -139215 | -284502 | -184092 | -80825 | -122711.09 |  | -938588.17
2020-06-07 00:00:00 | -47343.63 | -46769.25 | -33130.2 | -139215 | -284502 | -184092 | -80825 | -122711.09 |  | -938588.17
2020-06-01 00:00:00 | -47519.63 | -57848.25 | -45757.2 | -150839 | -262192 | -184092 | -80825 | -122711.09 |  | -951784.17
2020-05-31 00:00:00 | -61614.43 | -18036 | -60526 | -126137 | -233450 | -172044 | -60000 | -66948 |  | -798755.4299999999
2020-05-26 00:00:00 | -62433.43 | -20376 | -60526 | -126137 | -233450 | -172044 | -60000 | -66948 |  | -801914.4299999999
2020-05-21 00:00:00 | -62474.43 | -24934 | -69681 | -178662 | -229354 | -172044 | -60000 | -66948 |  | -864097.4299999999
Spreadsheet: 842561d1694606503-help-with-auto-fill-formula-help-15-
Sheet: Summary

Day | Date | S Average | V Average | T Average | Target %
 | 2023-05-01 00:00:00 | data from "rolling week" cell "D93" | data from "rolling week" cell "D94" | data from "rolling week" cell "95" | 0.95
 | 2023-05-02 00:00:00 | data from "rolling week" cell "D104" | data from "rolling week" cell "D105" | data from "rolling week" cell "106" | 0.95
 | 2023-05-03 00:00:00 | data from "rolling week" cell "D115" | data from "rolling week" cell "D116" | data from "rolling week" cell "D117" | 0.95
 |  | I want the following cells to always add 11 onto their below number, the same as above
1 | 2023-05-01 00:00:00
2 | 2023-05-02 00:00:00 | 1 | 1 | 1
3 | 2023-05-03 00:00:00 | 1 | 1 | 1
Spreadsheet: 708841d1608046541-extract-and-sum-numerical-values-using-string-matching-from-single-multi-value-cell-submission
Sheet: For Internet Help

 |  |  |  |  |  | Monday
Jake |  |  |  |  |  | 2675_Mechanism Drive_Guard Bottom_Fit _02
Liam |  |  |  |  |  | 2675_Mechanism Drive_Guard Bottom_Weld_04, 2675_Mechanism Drive_Guard Bottom_Fit _04
[NAME] |  |  |  |  |  | 2675_Mechanism Drive_Guard Bottom_Fit _05
Background:
Project Overhead: 2675
Project: Mechanism Drive
Components Available: Guard Bottom, [NAME]
Actions: Fit, Weld
Time for action: 00-08 hours
PROJECT OVERVIEW
1 | 2675 |  | EXTRACT NUMERICAL SUM VALUES HERE
1.1 | Mechanism Drive | Term to Search | Fit | Weld
1.1.1 | Guard Bottom
1.1.1.1 | Fit
1.1.1.2 | Weld
1.1.2 | Guard Top
1.1.2.1 | Fit
1.1.2.2 | Weld
Spreadsheet: 24919d1215817574-dynamically-transpose-data-transpose-2
Sheet: Solution

Megacorp | mmm | Megacorp |  |  | mmm | [NAME] | Emma | [NAME]
Megacorp | [NAME] | Tiny PLC |  |  | [NAME]
Megacorp | Emma | TFP PLC |  |  | [NAME] | [NAME]
Megacorp | [NAME] | end
Tiny PLC | [NAME]
TFP PLC | [NAME]
TFP PLC | [NAME]
end
 |  |  |  |  | To allocate names to companies
 |  |  |  |  | Put names on right of companies (not essential but fits with existing formulae)
 |  |  |  |  | Prepare list of unique values in Column C (use Data, Filter, Advanced)
 |  |  |  |  | Enter end after last name
 |  |  |  |  | Enter formula in F1, copy right to the maximum needed
 |  |  |  |  | Copy this range down as required.
Spreadsheet: 192174d1352325612-compiling-data-from-one-column-into-separate-columns-example-compiling-issue-unknown
Sheet: Sheet1

 | I have this |  |  |  |  | I want this
 |  |  |  |  |  | Item
 | Item | Item Description | Ingredients |  |  | 123 | 4523 | 12301
 | 123 | Cookies | A |  |  | Cookies | Pie | Pizza
 |  |  | B |  |  | A | A | A
 |  |  | C |  |  | B | T | S
 |  |  | D |  |  | C | F | V
 |  |  | E |  |  | D | C | G
 |  |  | F |  |  | E | A | J
 |  |  | T |  |  | F | Z | Y
 |  |  | G |  |  | T | A
 |  |  | H |  |  | G | V
 |  |  | Y |  |  | H | N
 |  |  | L |  |  | Y | TY
 | 123 Total |  |  |  |  | L | A
 | 4523 | Pie | A |  |  |  | S
 |  |  | T |  |  |  | V
 |  |  | F
 |  |  | C
 |  |  | A
 |  |  | Z
 |  |  | A
 |  |  | V
 |  |  | N
 |  |  | TY
 |  |  | A
 |  |  | S
 |  |  | V
 | 4523 Total
 | 12301 | Pizza | A
 |  |  | S
 |  |  | V
 |  |  | G
 |  |  | J
 |  |  | Y
 | 12301 Total
Spreadsheet: 767081d1644276083-need-help-on-spreadsheet-do-i-need-to-use-vlookup-hlookup-index-match-2022-law-dogs-standings
Sheet: Mudcats

Mudcats
Wk# | Opponent | W | L | PF | PA | MARGIN
1 | Wet Farts
2 | Sharks
3 | Gator Dawgs
4 | Thundermutts
5 | Capo Crimini
6 | Cajun Cooonasses
7 | King of Queens
8 | Deadbirds
9 | Pics Hitmen
10 | Muckdogs
11 | [NAME]
12 | King of Queens
13 | Cajun Cooonasses
14 | [NAME]
15 | Muckdogs
16 | Capo Crimini
17 | Thundermutts
18 | Pics Hitmen
19 | Deadbirds
20 | Gator Dawgs
21 | Sharks
22 | Wet Farts
Spreadsheet: 0470106a-e7a8-4977-8462-c6e1ad71ae37
Sheet: Sheet1

Crime Index | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 | 1993
Age Group | Total | Male | Female
12 and under | 216.2377865006121 | 329.5619833812408 | 97.3993671469256
13-14 | 3268.648677769661 | 4736.796827457937 | 1726.792408631901
15 | 4776.662548863222 | 7154.259752992342 | 2271.137293695423
16 | 5144.989726358295 | 7889.871735708395 | 2234.372747019514
17 | 4934.277615897331 | 7719.037641710733 | 1969.595957853767
18 | 4623.29552841254 | 7385.216858002711 | 1719.427006575146
19 | 3683.865539023285 | 5839.156292949861 | 1436.3120585947
20 | 3033.256801930158 | 4737.597676050175 | 1254.217894275207
21 | 2713.978252463543 | 4229.086621455505 | 1132.677001944681
22 | 2493.759224408468 | 3848.700133234265 | 1091.90765284896
23 | 2339.745029505012 | 3580.744600613682 | 1060.622884628342
24 | 2212.108749608051 | 3368.301108800531 | 1025.368158210536
25-29 | 2001.407557741952 | 3052.788006366031 | 942.2455478023264
30-34 | 1613.013795324355 | 2464.017886718289 | 766.6913609981319
35-39 | 1190.526358901617 | 1838.576416421995 | 549.6175691121789
40-44 | 770.7882796698584 | 1207.088461706447 | 344.8615653916194
45-49 | 476.6017656826385 | 739.0927020666733 | 223.5666443657285
50-54 | 312.2046007924064 | 479.8844924123608 | 153.5484852450039
55-59 | 205.5656232529797 | 306.2743044419845 | 112.7762328175229
60-64 | 140.4704121386664 | 207.8890230673929 | 80.83303552680839
65 and over | 67.11903032550113 | 110.7045621517592 | 37.40353108180933