tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 120744d1315494824-projected-component-change-outs-budget
Sheet: 5324

5324 |  |  |  | Current Hours |  | Year
 |  |  |  |  |  | 2012 |  |  |  |  |  |  |  |  |  |  |  | 2013 |  |  |  |  |  |  |  |  |  |  |  | 2014 |  |  |  | 2015 |  |  |  | 2016
 |  |  |  |  |  | 744 | 696 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 744 | 672 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 2160 | 2184 | 2208 | 2208 | 2160 | 2184 | 2208 | 2208 | 2184 | 2184 | 2208 | 2208
 |  |  |  |  | Projected 2011 End | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th
Projected Future Hours
Spreadsheet: jonathan_mckay__17203__Tariffs New Update
Sheet: Westcoast

Westcoast Tariff Summary
 |  |  | T-South Heating Value
Gordondale Receipt/Delivery |  | GJ/E3M3
T-South Deliveries |  | GJ/E3M3
T-North Long Haul | $C/GJ | $US/MMBtu
Firm Demand
Winter IT Commodity
Summer IT Commodity
Winter Fuel Tax
June Fuel Tax Estimate
T-South PNG Delivery
PNG Demand
Winter PNG IT Commodity
Summer PNG IT Commodity
Winter Fuel Tax
Summer Fuel Tax
T-South  Inland Delivery
Inland Delivery Demand
Winter Inland IT Commodity
Summer Inland IT Commodity
Winter Fuel Tax
Summer Fuel Tax
T-South Huntingdon Delivery
[NAME]
[NAME] IT Commodity
Summer Huntingdon IT Commodity
Winter Fuel Tax
Summer Fuel Tax
Westcoast Alberta Zone B
Zone B Demand
Winter Zone B IT Commodity
Summer Zone B IT Commodity
Westcoast Alberta Zone C
Zone C Demand
Winter Zone C IT Commodity
Summer Zone C IT Commodity
Charges only payable on eastern direction flows
Spreadsheet: 755288d1636751308-help-with-formula-for-cash-flow-sheet-inla-mningsuppgift-copy
Sheet: Likviditetsbudget

 |  | M1 | M2 | M3 | M4 | M5 | M6 | M7 | M8 | M9 | M10 | M11 | M12 | [NAME] | M14 | M15 | M16 | [NAME] | M18 | M19 | M20 | M21 | M22 | M23 | M24 | M25 | M26 | M27 | M28 | M29 | M30 | M31 | M32 | M33 | M34 | M35 | M36 | M37 | M38 | M39 | M40 | M41 | M42 | M43 | M44 | M45 | M46 | M47 | M48 | M49 | M50 | M51
Omsättning | 1
Kontant | 0.3
30 dagar | 0.3
60 dagar | 0.4
Egen insats | 85000
Lån/VC Investering | 0 | 0
Summa inbetalningar
Hyra | 5000 | 5000 |  |  |  |  |  |  |  |  |  |  |  | 6000
Lön Smith |  | 2000 |  |  |  |  |  |  |  |  |  |  |  | 3000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4000
Lön [NAME] |  | 1500
Total löneutbetalningar
Supplies | 0.07 |  |  |  |  |  |  | 0 | 0
[NAME] (Cost of Goods Sold) | 0.25
Missing
Purchase | 3000
"Lager"/"Inventory" |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
[NAME] material |  |  |  |  |  |  |  | 0
Investering | 100000
Amortering
Ränta
Reklamkostnader | 500
Försäkring | 600
[NAME] | 0.28
Summa utbetalningar
Kassaflöde
Kassa
Övrig info från uppgiften
Lönevillkor baserat på försäljning
Grundlön | 1500
25000 | 2500
35000 | 3500
45000 | 4500
55000 | 5500
65000 | 6500
75000 | 7500
Spreadsheet: 542880d1508155619-add-calculated-field-in-pivot-pivot
Sheet: Data

Month | Area | Location | USD '000
201708 | AG | UAE | 350
201708 | IS | INDIA | 543
201708 | EU | BELGIUM | 583
201708 | US | NEW YORK | 596
201708 | FE | CHINA | 511
201708 | AG | BAHRAIN | 493
201708 | IS | SRI LANKA | 619
201708 | EU | GERMANY | 622
201708 | US | FLORIDA | 554
201708 | FE | SINGAPORE | 429
201709 | AG | UAE | 363
201709 | IS | INDIA | 443
201709 | EU | BELGIUM | 308
201709 | US | NEW YORK | 398
201709 | FE | CHINA | 447
201709 | AG | BAHRAIN | 392
201709 | IS | SRI LANKA | 447
201709 | EU | GERMANY | 309
201709 | US | FLORIDA | 479
201709 | FE | SINGAPORE | 592
Spreadsheet: 852948d1702924169-solved-validate-month-based-on-contract-dates-and-calculate-correct-number-of-weeks-on-date-ssue-new-2
Sheet: Sheet1

Name | Start contract | End contract | Contract weeks | Hours a week |  |  | 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
Piet | 2024-01-08 00:00:00 | 2024-04-15 00:00:00 |  | 30
Kees | 2024-01-15 00:00:00 | 2024-03-04 00:00:00 |  | 20
Klaas1 | 2024-10-08 00:00:00 | 2024-12-31 00:00:00 |  | 25
Piet2 | 2024-01-08 00:00:00 | 2024-04-15 00:00:00
Kees2 | 2024-01-15 00:00:00 | 2024-03-04 00:00:00
Klaas2 | 2024-10-08 00:00:00 | 2024-12-31 00:00:00
Piet3 | 2024-01-08 00:00:00 | 2024-04-15 00:00:00
Kees3 | 2024-01-15 00:00:00 | 2024-03-04 00:00:00
Klaas3 | 2024-10-08 00:00:00 | 2024-12-31 00:00:00
Spreadsheet: 175316d1345486679-how-to-sort-data-with-pictures-book1
Sheet: Sheet1

SKU | Picture | Item | Serving | Price | Discount | S. Price | Sale
1 |  | [NAME] | 365 | 165 |  | 125 | 805
2 |  | Nature Made Fish Oil | 375 1200mg | 158 |  | 144 | 494
3 |  | Kirkland | 567g | 85 |  | 65 | 600
4 |  | GNC | 100 300mg | 138 |  | 99 | 279
5 |  | Kirkland Calcium+D3 | 500 600mg | 113 |  | 113 | 233
6 |  | Neocell 100% | 198g | 82.5 |  | 82.5 | 318
7 |  | Schiff Move Free | 160 | 159 |  | 159 | 268
8 |  | [NAME] | 285 | 155 |  | 155 | 189
9 |  | Childlife | 474ml | 129 |  | 126.42 | 209
10 |  | [NAME] | 350 | 165 |  | 165 | 212
Spreadsheet: 837100d1689850671-indirect-a1-a5-and-a1-to-spill-a1-from-other-sheets-doesnt-work-how-could-i-do-it-example-132-aligw
Sheet: DATABASE1

Who | How many | Where |  | 1 - This is DATABASE 1
1 | 1 | 10
2 | 3 | 10 |  | 2 - This database is pasted from an erp to here in this format.
3 | 2 | 20
2 | 2 | 30 |  | 3 - Each year we paste a database to the excel file.
1 | 4 | 10
3 | 1 | 50
3 | 2 | 50
1 | 3 | 10
1 | 5 | 20
Spreadsheet: 586661d1534511871-copy-data-from-one-excel-sheet-to-another-if-a-value-is-present-only-from-drop-down-list-sample-of-billing-matrix
Sheet: OVERALL BILLS

DATE | COMPANY | TOTAL COUNT | 1 COUNT | 1 AMOUNT | 2 COUNT | 2 AMOUNT | 3 COUNT | 3 AMOUNT | 4 COUNT | 4 AMOUNT | 5 COUNT | 5 AMOUNT | 6 COUNT | 6 AMOUNT | TOTAL AMOUNT
2018-08-01 00:00:00 | 1 - ATT | 550 | 350 |  | 200 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 1 - ATT | 100
2018-08-01 00:00:00 | 2 - ADT | 5 | 0 |  | 0 |  | 5 |  | 0 |  | 0 |  | 0 |  |  |  | 2 - ADT | 90
2018-08-01 00:00:00 | 3 - CNN | 350 | 0 |  | 0 |  | 145 |  | 150 |  | 55 |  | 0 |  |  |  | 3 - CNN | 80
2018-08-01 00:00:00 | 4 - ESPN | 9 | 0 |  | 0 |  | 0 |  | 0 |  | 9 |  | 0 |  |  |  | 4 - ESPN | 70
2018-08-02 00:00:00 | 1 - ATT | 555 | 350 |  | 200 |  | 5 |  | 0 |  | 0 |  | 0 |  |  |  |  | 60
2018-08-02 00:00:00 | 2 - ADT | 5 | 0 |  | 0 |  | 5 |  | 0 |  | 0 |  | 0 |  |  |  |  | 50
2018-08-02 00:00:00 | 3 - CNN | 350 | 0 |  | 0 |  | 140 |  | 150 |  | 60 |  | 0
2018-08-02 00:00:00 | 4 - ESPN | 20 | 0 |  | 0 |  | 0 |  | 0 |  | 20 |  | 0
2018-08-03 00:00:00 | 1 - ATT | 550 | 350 |  | 200 |  | 0 |  | 0 |  | 0 |  | 0
2018-08-03 00:00:00 | 2 - ADT | 10 | 0 |  | 0 |  | 10 |  | 0 |  | 0 |  | 0
2018-08-03 00:00:00 | 3 - CNN | 350 | 0 |  | 0 |  | 140 |  | 150 |  | 60 |  | 0
2018-08-03 00:00:00 | 4 - ESPN | 15 | 0 |  | 0 |  | 0 |  | 0 |  | 15 |  | 0
Spreadsheet: 163531d1340352245-question-re-conditional-formatting-cells-with-formula-cformatting
Sheet: Sheet1

With [NAME] |  | No Formula
Champions League |  | (Just copied and pasted some text)
 |  | Everton
 |  | UNITED
 |  | Southampton
 |  | UNITED
 |  | Champions League
 |  | Liverpool
Competition | Team |  |  | competition
Premier League | Everton |  |  | Premier League
Premier League | UNITED |  |  | Champions League
Premier League | Southampton |  |  | League Cup
Premier League | UNITED |  |  | FA Cup
Champions League | Juventus
Premier League | Liverpool
League Cup | [NAME]
Premier League | UNITED
Champions League | Barcelona
Premier League | Newcastle United
FA Cup | Birmingham
Champions League | Real Madrid
Premier League | Chelsea
League Cup | Wolves
Premier League | UNITED
Champions League | Bayern Munich
Premier League | [NAME]
Premier League | Norwich City
FA Cup | Stoke City
Champions League | Lille
Premier League | UNITED
Premier League | Reading
Champions League | PSG
Premier League | Manchester City
League Cup | Southampton
Premier League | UNITED
Premier League | Swansea City
Premier League | UNITED
Premier League | UNITED
Premier League | Wigan Athletic
FA Cup | Arsenal
Spreadsheet: 125555d1319099928-reverse-gpa-as-percentage-to-calculate-a-total-score-gpa_related_to_score
Sheet: Sheet1

Case 1 - GPA = 10 biggest; GPA = 1 smallest. |  |  | SOLVED
GPA | % from Score (100points) | Score
10 | 50 | 50
9 | 50 | 45
8 | 50 | 40
7 | 50 | 35
6 | 50 | 30
5 | 50 | 25
4 | 50 | 20
3 | 50 | 15
2 | 50 | 10
1 | 50 | 5
Case 2 - GPA = 1 biggest; GPA = 5 smallest. |  |  | [NAME]
GPA | % from Score (100points) | Score | Expected Score Values | Test1
1 | 50 |  | 50 | 50
2 | 50 |  | 40 | 41.66666666666667
3 | 50 |  | 30 | 37.5
4 | 50 |  | 20 | 35
5 | 50 |  | 10 | 33.33333333333334
Spreadsheet: 456754d1461047754-to-get-desired-result-based-on-the-conditions-sample-file-1
Sheet: Sheet3

HOME_CNUM | ASSIGNMENT_STATUS | ASSIGNEE_LAST_NAME | ASSIGNEE_FIRST_NAME | HOST_CNUM | ACTUAL_START_DATE | ACTUAL_END_DATE | Home_Country | [NAME]
00013F744 | Completed | PODDAR | NITIN | 100603866 | 2013-12-06 00:00:00 | 2015-04-04 00:00:00 | India | United Kingdom
00013F744 | Completed | PODDAR | NITIN | 100603866 | 2013-03-21 00:00:00 | 2013-12-09 00:00:00 | India | United Kingdom
00013F744 | Completed | PODDAR | NITIN | 100603866 | 2012-12-15 00:00:00 | 2014-01-06 00:00:00 | India | United Kingdom
00013F744 | Completed | PODDAR | NITIN | 100603866 | 2012-11-03 00:00:00 | 2013-05-17 00:00:00 | India | United Kingdom
00013F744 | Completed | PODDAR | NITIN | 100603866 | 2012-08-06 00:00:00 | 2013-02-12 00:00:00 | India | United Kingdom
00013F744 | Completed | PODDAR | NITIN | 100603866 | 2011-08-01 00:00:00 | 2012-08-27 00:00:00 | India | United Kingdom
00013F744 | Completed | PODDAR | NITIN | 100603866 | 2010-12-03 00:00:00 | 2011-12-08 00:00:00 | India | United Kingdom
000251744 | Current | [NAME] | Swapna | 110053866 | 2013-12-01 00:00:00 | 2016-04-30 00:00:00 | United States | United Kingdom
000251744 | Completed | [NAME] | Swapna | 110053866 | 2013-06-01 00:00:00 | 2013-12-31 00:00:00 | United States | United Kingdom
000251744 | Completed | [NAME] | Swapna | 110053866 | 2010-02-01 00:00:00 | 2011-04-14 00:00:00 | United States | United Kingdom
000251744 | Completed | [NAME] | Swapna |  | 2009-11-25 00:00:00 | 2010-03-28 00:00:00 | United States | United Kingdom
000251744 | Completed | [NAME] | Swapna | 110053866 | 2008-12-30 00:00:00 | 2009-04-29 00:00:00 | United States | United Kingdom
000251744 | Completed | [NAME] | Swapna | 110053866 | 2008-01-15 00:00:00 | 2008-12-28 00:00:00 | United States | United Kingdom
000251744 | Completed | [NAME] | Swapna | 110053866 | 2000-01-01 00:00:00 | 2002-07-31 00:00:00 | United States | United Kingdom
000251744 | Completed | [NAME] | Swapna |  | 1998-05-31 00:00:00 | 1998-11-30 00:00:00 | United States | United Kingdom
00026J744 | Current | [NAME] | [NAME] | 115131866 | 2010-01-01 00:00:00 | 2010-07-14 00:00:00 | South Africa | United Kingdom
Spreadsheet: 80532d1280765851-combining-two-excel-sheets-to-a-standard-format-excel-list2
Sheet: 13826--CUTTER WHEEL ASM-She (2

ITEM | QTY | PART# | [NAME]
1 | 3 | 995598 | example-11
2 | 5 | 995599 | example-12
3 | 4 | 995600 | example-13
4 | 9 | 995601 | example-14
5 | 34 | 995602 | example-15
6 | 99 | 995603 | example-16
7 | 45 | 995604 | example-17
8 | 1 | 995605 | example-18
9 | 2 | 995606 | example-19
10 | 1 | 995607 | example-20
11 | 1 | 995608 | example-21
12 | 48 | 995609 | example-22
13 | 1 | 995610 | example-23
14 | 1 | 995611 | example-24
15 | 6 | 995612 | example-25
16 | 6 | 995613 | example-26
17 | 6 | 995614 | example-27
18 | 3 | 995615 | example-28
19 | 3 | 995616 | example-29
20 | 6 | 995617 | example-30
21 | 2 | 995618 | example-31
22 | 2 | 995619 | example-32
23 | 1 | 995620 | example-33
24 | 4 | 995621 | example-34
25 | 5 | 995622 | example-35
26 | 4 | 995623 | example-36
Spreadsheet: 116474d1311860978-using-the-trend-line-equation-for-trend-line
Sheet: P-2A_ON SHELL_0.04

 |  |  |  |  |  | LINEST Function
 |  |  |  |  |  | This function finds parameters for the line of best fit for linear data
x | f(x) |  |  |  |  | Steps.
1176 |  |  |  |  |  | Insert/Function/Statistical/LINEST
 |  |  |  |  |  | Enter in required fields
 |  |  |  |  |  | Use the slope and the y-intercept generated by the function to draw a line of best fit
 | Figure | L/2a | Reinforcement | R/t | 0.02 | x | f(x) | Line of best fit
 | P-2A | 1 | ON SHELL | 400 | 0.00025
 | P-2A | 1 | ON SHELL | 500 | 0.00018
 | P-2A | 1 | ON SHELL | 600 | 0.000125
 | P-2A | 1 | ON SHELL | 700 | 8.8e-05
 | P-2A | 1 | ON SHELL | 800 | 7e-05
 | P-2A | 1 | ON SHELL | 900 | 6e-05
 | P-2A | 1 | ON SHELL | 1000 | 4.8e-05
 | P-2A | 1 | ON SHELL | 1500 | 2.8e-05
 | P-2A | 1 | ON SHELL | 2000 | 1.5e-05
 |  |  |  |  |  | Output from the LINEST function:
 |  |  |  |  |  | slope | y-intercept
 |  |  |  |  |  |  | 0.0002059748427672956
Spreadsheet: 63906d1264764764-data-cleanup-problem-sample
Sheet: Tabelle2

N+ L/W
l1
l1
l1
l1
l1
l1
l1
l1 | L1T-8
l2
l2
l2
l2
l3
l3
[NAME]
[NAME]
w1
w1
w14
w2
w2
w2
w3
w3
w3
w4
w4
w4
w4
[NAME]
w7
Spreadsheet: 51549d1251206825-unable-to-build-list-of-names-example
Sheet: Sheet1

Row | Name | Fri PM | Sat AM | Sat PM | Sun AM | Sun PM | Mon AM
1 | [NAME] | 0 | 0 | 1 | 0 | 0 | 1
2 | [NAME] | 1 | 1 | 1 | 1 | 1 | 1
3 | [NAME] | 0 | 0 | 0 | 1 | 1 | 0
5 | [NAME] | 0 | 1 | 1 | 1 | 1 | 1
4 | Chrstopher | 0 | 1 | 1 | 1 | 1 | 0
6 | [NAME] | 0 | 0 | 1 | 1 | 1 | 0
7 | [NAME] | 1 | 1 | 1 | 1 | 1 | 1
9 | Debbie | 0 | 0 | 0 | 0 | 0 | 0
8 | [NAME] | 0 | 0 | 0 | 1 | 1 | 1
10 | Derek | 0 | 0 | 0 | 0 | 0 | 0
11 | [NAME] | 1 | 1 | 1 | 1 | 1 | 1
13 | Ian | 0 | 1 | 1 | 1 | 1 | 1
14 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0
15 | [NAME] | 0 | 1 | 1 | 1 | 1 | 0
16 | [NAME] | 0 | 1 | 1 | 1 | 1 | 1
17 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0
18 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0
19 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0
20 | [NAME] | 0 | 1 | 1 | 1 | 1 | 1
21 | Maria | 0 | 0 | 0 | 0 | 0 | 0
22 | Mark | 0 | 0 | 0 | 1 | 1 | 0
23 | Martin | 0 | 0 | 1 | 0 | 0 | 0
24 | [NAME] | 0 | 0 | 0 | 1 | 1 | 0
26 | [NAME] | 0 | 0 | 1 | 0 | 1 | 1
12 | Michelle | 0 | 0 | 0 | 0 | 0 | 0
25 | Milly | 0 | 0 | 0 | 1 | 1 | 0
27 | [NAME] | 0 | 1 | 1 | 0 | 0 | 0
29 | Nick | 0 | 1 | 1 | 1 | 1 | 1
28 | [NAME] | 0 | 1 | 1 | 1 | 1 | 0
30 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0
33 | Paddy | 0 | 1 | 1 | 1 | 1 | 0
32 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0
31 | [NAME] | 0 | 0 | 1 | 1 | 0 | 0
34 | Pauline | 0 | 0 | 1 | 1 | 0 | 0
36 | Percy | 0 | 0 | 0 | 1 | 1 | 1
37 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0
35 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0
38 | [NAME] | 0 | 0 | 0 | 1 | 1 | 0
39 | Rich | 0 | 1 | 1 | 1 | 1 | 0
40 | [NAME] | 1 | 1 | 1 | 1 | 1 | 1
41 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0
42 | Robb | 0 | 1 | 1 | 1 | 1 | 1
43 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0
44 | [NAME] | 1 | 0 | 0 | 0 | 0 | 1
46 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0
45 | Surart | 0 | 0 | 0 | 1 | 1 | 0
47 | [NAME] | 1 | 1 | 1 | 1 | 1 | 1
48 | Wilbert | 0 | 1 | 1 | 0 | 0 | 1
49 | [NAME] | 0 | 0 | 0 | 0 | 0 | 1
 |  | [NAME]
 |  | Fri PM | Sat AM | Sat PM | Sun AM | Sun PM | Mon AM
 |  | List of names here for each session based on 1's above
Spreadsheet: 15d39b28-4bfa-4697-900c-f9d35a650b53
Sheet: Sheet1

Permit No.: | Unnamed: 1 | Unnamed: 2 | WQ0000488 | Unnamed: 4 | Unnamed: 5 | Facility Name: | Unnamed: 7 | [NAME] | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | County: | Chatham | Unnamed: 16 | Month: | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | 1 |  | Field Name: |  |  |  | Field Name: |  |  |  | Field Name:
 |  |  |  |  |  | Area (acres): |  | 1.6 |  | Area (acres): |  |  |  | Area (acres): |  |  |  | Area (acres):
 |  |  |  |  |  | Cover Crop: |  | Trees |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  |  |  | [NAME] (in): |  |  |  | [NAME] (in): |  |  |  | [NAME] (in):
 |  |  |  |  |  | Annual Rate (in): |  | 20.8 |  | Annual Rate (in): |  |  |  | Annual Rate (in): |  |  |  | Annual Rate (in):
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: 216438d1361776456-vlookup-or-index-problem-excel_question_v1
Sheet: Output

Team 1 |  |  | Team 2
LAC (dynamic field where I enter team name) | Age | G | DEN | Age | G
Display first 5 results as shown under "DEN" |  |  | [NAME] | 23 | 57
 |  |  | [NAME] | 24 | 54
 |  |  | [NAME] | 25 | 56
 |  |  | [NAME] | 23 | 56
 |  |  | [NAME] | 25 | 54
Spreadsheet: b4c18bb4-94f7-421d-aa82-35ad448a6e58
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | CODES | TITLES | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | BALANCES
 | DEPARTMENT |  |  |  |  |  |  |  |  |  |  |  | B-3
 | PROGRAM
 | FUND
 | NUMERIC APPROPRIATION
 | DECISION ITEM
 | REVENUE TYPE
 | REVENUES AND EXPENDITURES |  |  |  | Prior Year |  | Base Year |  | 1st Year |  | 2nd Year
 |  |  |  |  | Actuals |  | Estimate |  | Estimate |  | Estimate
1 | Opening Balance |  |  |  | 0 |  | 0 |  | 0 |  | 0
2 |  |  |  |  | 0 |  | 0 |  | 0 |  | 0
3
4
5
6
7
8
9
11
12
13
14
...
21 | Total Revenue |  |  |  | 0 |  | 0 |  | 0 |  | 0
22 | Total Available |  |  |  | 0 |  | 0 |  | 0 |  | 0
23 | B-2 Expenditure Total |  |  |  | 0 |  | 0 |  | 0 |  | 0
24
25 | Employe Compensation Reserve |  |  |  | 0 |  | 0 |  | 0 |  | 0
26 | Health Insurance Reserve |  |  |  | 0 |  | 0 |  | 0 |  | 0
27 | Space Rent  Reserve
28 | SBFO Charge Back Cost Increase Reserve
29
30 | Total Expenditures & Reserves |  |  |  | 0 |  | 0 |  | 0 |  | 0
 | CLOSING BALANCE |  |  |  | 0 |  | 0 |  | 0 |  | 0
Spreadsheet: 772453d1647280380-need-to-find-viscosity-from-multiple-tables-of-data-viscosity-table-1
Sheet: Sheet1

Viscosities for Acetonitrile and Methanol and function of Temperature and % Composition (with water):
 |  |  |  | Tables of Viscosity (in cP) from Temp and % Composition, for two solvents, Acetonitrile and Methanol: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | User seperately selects the following:
 |  |  |  | NOTE:  Viscosity tables of data are static, and can be re-arranged and/or combined as needed.  User will not see these tables,
 |  |  |  | only the viscosity for a given type, % composition and temp. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - Type of solvent (acetonitrile or methanol)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - Temperature
 |  |  | Temp: |  | % Acetonitrile: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - % of solvent (acetonitrile or methanol)
 |  |  |  | 0 | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100
 |  |  | 15 | 1.1 | 1.18 | 1.23 | 1.3 | 1.09 | 0.98 | 0.89 | 0.81 | 0.7 | 0.54 | 0.4 |  |  |  |  |  | e.g:
 |  |  | 20 | 1 | 1.14 | 1.1 | 1.13 | 0.99 | 0.9 | 0.81 | 0.69 | 0.56 | 0.5 | 0.37 |  |  |  |  |  |  | Organic Type: | Acetonitrile
 |  |  | 25 | 0.89 | 1.01 | 0.98 | 0.98 | 0.89 | 0.82 | 0.72 | 0.59 | 0.52 | 0.46 | 0.35 |  |  |  |  |  |  | Enter % Org: | 20
 |  |  | 30 | 0.79 | 0.9 | 0.87 | 0.86 | 0.8 | 0.74 | 0.65 | 0.52 | 0.45 | 0.43 | 0.32 |  |  |  |  |  |  | Enter Temp: | 25
 |  |  | 35 | 0.7 | 0.73 | 0.78 | 0.76 | 0.72 | 0.68 | 0.59 | 0.47 | 0.43 | 0.39 | 0.3
 |  |  | 40 | 0.64 | 0.72 | 0.7 | 0.68 | 0.65 | 0.62 | 0.54 | 0.44 | 0.41 | 0.36 | 0.27
 |  |  | 45 | 0.58 | 0.61 | 0.64 | 0.61 | 0.59 | 0.58 | 0.5 | 0.43 | 0.38 | 0.33 | 0.25 |  |  |  |  | Needed:
 |  |  | 50 | 0.54 | 0.6 | 0.6 | 0.57 | 0.55 | 0.53 | 0.46 | 0.41 | 0.36 | 0.31 | 0.24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The viscosity for that solvent type,  % composition and temperature
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Viscosity = |  | ??
 |  |  |  |  | % Methanol:
 |  |  | Temp: | 0 | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 | 100
 |  |  | 15 | 1.1 | 1.43 | 1.72 | 1.92 | 2 | 2.02 | 1.91 | 1.69 | 1.4 | 1.05 | 0.63
 |  |  | 20 | 1 | 1.32 | 1.57 | 1.75 | 1.83 | 1.83 | 1.72 | 1.52 | 1.25 | 0.93 | 0.6
 |  |  | 25 | 0.89 | 1.18 | 1.4 | 1.56 | 1.62 | 1.62 | 1.54 | 1.36 | 1.12 | 0.84 | 0.56
 |  |  | 30 | 0.79 | 1.04 | 1.23 | 1.36 | 1.43 | 1.43 | 1.36 | 1.21 | 1.01 | 0.76 | 0.51
 |  |  | 35 | 0.7 | 0.92 | 1.07 | 1.19 | 1.24 | 1.26 | 1.21 | 1.09 | 0.91 | 0.69 | 0.46
 |  |  | 40 | 0.64 | 0.82 | 0.96 | 1.05 | 1.11 | 1.12 | 1.08 | 0.98 | 0.83 | 0.64 | 0.42
 |  |  | 45 | 0.58 | 0.75 | 0.87 | 0.96 | 1 | 1.02 | 0.98 | 0.89 | 0.76 | 0.58 | 0.39
 |  |  | 50 | 0.54 | 0.71 | 0.82 | 0.89 | 0.93 | 0.94 | 0.9 | 0.82 | 0.7 | 0.54 | 0.37
Spreadsheet: 784503d1655789748-how-to-hide-a-row-based-on-a-date-in-a-column-sample-spreadsheet
Sheet: Sheet2

Child's Last Name | Child's First Name | Date of Birth | Start Date | Last Day (Date ) | Face Sheet | Last Physical | Lead Test | Immunizations | Accident/ Incident | Emergency Contact/  Consent and Release | Transportation Plan | Last Progress Report | Developmental History | Referrals | IHCP | Medications | Developments Placement | Custody Agreements | Notes
Spreadsheet: 274709d1383198850-how-to-control-user-input-on-a-multiple-drop-down-lists-dv-example
Sheet: Named Ranges

Range Name ---> | Main | Mammal | Bird | Fish |  | feline | bovine | marsupial | ape
 | Mammal | Mammal | Bird | Fish |  | feline | bovine | marsupial | ape
 | Bird | feline | bird1 | Fish1 |  | Lion | Cow | kanga | Chimp
 | Fish | bovine | bird2 | Fish2 |  | Tiger | Ox | Roo | Gibboon
 |  | marsupial | bird3 | [NAME]
 |  | ape | bird4 | Fish4
Spreadsheet: 1a43ce3b-cf5c-4924-af4b-6a6998f1d987
Sheet: Sheet1

Bib | Firstname | Lastname | City | State | TeamName | Age | Gender | AgeGroup | Swim | T1 | Bike | T2 | [NAME] | Run | Finish | AG Place | OverAll | Order | Masters | Penalty
218 | Bronwen | [NAME] | Sioux Center | IA |  | 35 | F | F35-39 | 00:13:49.050000 | 00:01:19.200000 | 00:37:41.870000 | 00:00:24.820000 | -- | 00:32:10.930000 | 01:25:25.870000 | -- | 1 | 10
244 | Anna | Brennan | Storm Lake | IA |  | 33 | F | F30-34 | 00:16:48.690000 | 00:01:40.240000 | 00:43:31.690000 | 00:00:55.180000 | -- | 00:31:13.130000 | 01:34:08.930000 | -- | 2 | 18
225 | [NAME] | [NAME] | West Des Moines | IA |  | 26 | F | F25-29 | 00:18:54.080000 | 00:03:14.730000 | 00:42:00.400000 | 00:00:32.860000 | -- | 00:33:33.960000 | 01:38:16.030000 | -- | 3 | 23
232 | [NAME] | [NAME] | Storm Lake | IA |  | 24 | F | F20-24 | 00:21:16.300000 | 00:01:07.890000 | 00:38:50.630000 | 00:00:44.530000 | -- | 00:37:17.210000 | 01:39:16.560000 | 1 | 4 | 25
241 | [NAME] | Simons | Minneapolis | MN |  | 30 | F | F30-34 | 00:21:55.870000 | 00:01:16.690000 | 00:45:19.620000 | 00:00:05.170000 | -- | 00:32:08.310000 | 01:40:45.660000 | 1 | 5 | 27
242 | [NAME] | Stanwood | Des Moines | IA |  | 32 | F | F30-34 | 00:24:42.030000 | 00:02:41.160000 | 00:47:01.170000 | 00:00:24.500000 | -- | 00:33:49.620000 | 01:48:38.480000 | 2 | 6 | 30
235 | Breanna | Platt | Early | IA |  | 23 | F | F20-24 | 00:21:11.130000 | 00:01:45.830000 | 00:48:45.420000 | 00:00:52.970000 | -- | 00:36:12.810000 | 01:48:48.160000 | 2 | 7 | 31
230 | Heather | Maassen | Avoca | IA |  | 20 | F | F20-24 | [NAME] | 00:02:09.230000 | 01:07:20.870000 | 00:00:17 | -- | 00:49:28.780000 | 02:18:50.880000 | 3 | 8 | 32
Spreadsheet: 91276d1291048065-vlookup-working-for-some-values-but-not-others-book1
Sheet: Ingredients

 | Product Code |  | Item |  | Quantity |  | Unit |  | Price |  | cost per unit
 | E001 |  | Eggs |  | 6 |  | singles |  | 1.54
 | M001 |  | Milk |  | 568 |  | ml |  | 0.89
 | F001 |  | [NAME] |  | 1000 |  | g |  | 2.68
 | I001 |  | Icing Sugar |  | 1000 |  | g |  | 4.26