tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 724590d1616251146-i-need-some-help-on-sum-diferent-criterios-centro-de-custos-2021
Sheet: Vale - Uzina

 |  | CENTROS DE CUSTOS
 |  | VALE - Uzina
 |  | Data | [NAME] | Req. / Fact nº | Valor - Mzn | Observação
 |  | 2020-10-01 00:00:00 | Combustivel | 54735 | 1930.2 | TLB 315 SL
 |  | 2020-10-23 00:00:00 | Combustivel | 54852 | 4000 | TLB 315 SL
 |  | 2020-10-26 00:00:00 | Combustivel | 54863 | 4296.6 | Logistica
 |  | 2020-10-26 00:00:00 | Combustivel | 54864 | 11150.4 | Logistica
 |  | 2020-10-28 00:00:00 | Combustivel | 54884 | 5147.2 | Logistica
 |  | 2020-10-29 00:00:00 | Combustivel | 54889 | 4080.4 | Logistica
 |  | 2020-10-30 00:00:00 | Combustivel | 54898 | 9007.6 | TLB 315 SL
 |  | 2020-10-30 00:00:00 | Combustivel | 54901 | 4176.6 | PowerFloot
 |  | 2020-11-02 00:00:00 | Combustivel | 54917 | 2151.2 | Logistica
 |  | 2020-11-02 00:00:00 | Combustivel | 54920 | 3860.4 | Camiao Tank - Agua
 |  | 2020-11-11 00:00:00 | Combustivel | 54978 | 2845.8 | TLB 315 SL
 |  | 2020-11-16 00:00:00 | Combustivel | 55007 | 4176.6 | Gerador
 |  | 2020-11-20 00:00:00 | Combustivel | 55033 | 2513.6 | TLB 315 SL
 |  | 2020-11-20 00:00:00 | Combustivel | 55037 | 4785.5 | Logistica
 |  | 2020-12-02 00:00:00 | Combustivel | 55117 | 1304.87 | Logistica
 |  | 2020-12-22 00:00:00 | Combustivel | 55266 | 7540.8 | Compressor
 |  | 2021-01-07 00:00:00 | Combustivel | 55347 | 3770.4 | Compressor
 |  | 2021-01-11 00:00:00 | Combustivel | 55356 | 7540.8 | Compressor
 |  | 2021-01-19 00:00:00 | Combustivel | 55427 | 3770.4 | Compressor
Spreadsheet: 857755d1706679547-sum-of-values-corresponding-to-a-range-of-cells-sum-of-values-ans
Sheet: Sheet1

 |  | Price | Total
 | 123 Street | 100
 | 124 Street | 200
 | 125 Street | 150
 |  | 170
 | 126 Street | 200
 |  | 150
 | 127 Street | 200
 |  | 200
 | 128 Street | 100
 | 129 Street | 200
 |  | 150
 |  | 170
 |  | 200
 | 130 Street | 150
 | 131 Street | 150
 | 132 Street | 200
Spreadsheet: c6610f5d-a418-489f-a92a-4b780a3ec7e7
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
260015 | 72797 | [NAME] | Yalchik | RUS | 10027 | 00:00:00 | 00:00:00 | 00:15:40 | 00:00:48 | [NAME] | 1 | 00:36:04
Spreadsheet: mark_whitt__25341__Epngrts
Sheet: Sheet1

El Paso Natural Gas Rates
 | 2001 | 2002 | 2003 | 2004 | 2005
Fixed
Reservation | 0.29908 | 0.29908 | 0.29908 | 0.29908 | 0.29908
[NAME] | 0.0574 | 0.0574 | 0.0574 | 0 | 0
[NAME]. | 0.00296 | 0.00197 | 0.00164 | 0 | 0
Variable
Usage | 0.0168 | 0.0168 | 0.0168 | 0.0168 | 0.0168
GRI | 0.007 | 0.005 | 0.004 | 0 | 0
ACA | 0.0022 | 0.0022 | 0.0022 | 0.0022 | 0.0022
Total Rate
Current Fuel % | 0.0347 | 0.0347 | 0.0347 | 0.0347 | 0.0347
Spreadsheet: 05165766-85cd-47cb-b777-4f9fa87172f3
Sheet: 14b

Product1 | HY3 | IG | Other | TOTAL
Index/Index Tranche | 1219 | 2443 | 2219 | 5881
Asia | - | - | 22 | 22
Europe | - | - | 2042 | 2042
North America | 1219 | 2443 | 6 | 3668
Other | - | - | 149 | 149
Other | - | - | 242 | 242
TOTAL | 1219 | 2443 | 2461 | 6123
Spreadsheet: 45316d1244075148-nesting-vlookup-in-if-vice-versa-and-pivot-table-sample
Sheet: Feb Cat1

Model | Amount-Cat1
750 | -205.6622
900 | -2669.357555600005
AB | -781.1330488
AG | -63.58996399999999
AN | -1797.5294
BX | -4786.3809
BZ | -3810.1728
CA | -2172.7989
CB | -474.72875
DE | -1471.4364
DV | -4460.2879
DX | -3484.0798
MF | -891.2694208362112
MR | -10948.26850350159
OA | -387.3093814209659
OB | -145.4543661579462
OR | -182.7213715871364
RA | -565.1764208362113
RF | -10622.17550350159
TM | -61.21638142096588
ZP | -320.4162152328041
Grand Total | -50301.16518289542
Spreadsheet: kevin_presto__20238__EIA411 Reporting Forms Revised 01 30 02
Sheet: Report - Summer Assessment

2002 Summer Assessment
Actual Peak* Demand, in Megawatts |  | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00
All-Time Peak* Demand, in Megawatts |  | Summer | Date | Winter | Date
Forecast Peak Demands and Capacity Resources
[NAME], in Megawatts |  | 2002-06-01 00:00:00 | 2002-07-01 00:00:00 | 2002-08-01 00:00:00 | 2002-09-01 00:00:00
1 | Internal Demand
2 | Standby Demand (If not included in Line 1)
3 | Total Internal Demand (Line 1 + Line 2)
4 | Load Management
5 | Interruptible Demand
6 | Net Internal Demand (Line 3 - Line 4 - Line 5)
Net Capacity Resources, in Megawatts |  | 2002-06-01 00:00:00 | 2002-07-01 00:00:00 | 2002-08-01 00:00:00 | 2002-09-01 00:00:00
7 | Total Capacity
8 | Inoperable Capacity (If included in Line 7)
9 | Net Operable Capacity (Line 7 - Line 8)
10 | Total Capacity Purchases - I
 | Total Capacity Purchases - II
 | Total Capacity Purchases - III
 | Total Capacity Purchases - IV
10a | Full Responsibility Purchases | 0 | 0 | 0 | 0
11 | Total Capacity Sales - I
 | Total Capacity Sales - II
 | Total Capacity Sales - III
 | Total Capacity Sales - IV
11a | Full Responsibility Sales | 0 | 0 | 0 | 0
12 | Adjustment to Purchase and Sales
13 | Net Capacity Resources (Line 9 + Line 10 + Line 11 - Line 12 + Line 12b)
14 | Capacity Margin (Line 13 - Line 6)
Spreadsheet: 49775d1249134279-excel-2007-how-can-i-genereate-report-based-on-cell-value-report
Sheet: report

student | info 1 | info 2 | info 3 | [NAME] | [NAME] | grade % |  | threshhold % | 0.8
fred 2 | blah 2 | stuff 2 | more stuf 2 | [NAME]2 | rhubarb 2 | 0.79
fred 3 | blah 3 | stuff 3 | more stuf 3 | [NAME]3 | rhubarb 3 | 0.69
fred 5 | blah 5 | stuff 5 | more stuf 5 | [NAME]5 | rhubarb 5 | 0.44
fred 7 | blah 7 | stuff 7 | more stuf 7 | [NAME]7 | rhubarb 7 | 0.49
fred 10 | blah 10 | stuff 10 | more stuf 10 | [NAME]10 | rhubarb 10 | 0.67
Spreadsheet: 782704d1654188655-calculate-various-values-based-on-results-of-dependent-drop-down-lists-example-for-forum
Sheet: DATA

DATA FOR DROP DOWN LISTS |  |  |  |  |  |  |  | DATA FOR INDEX MATCH
STAGE |  | DEMO |  | FOUNDATION |  | BEAMS |  | Item | QTY | UOM | COST | MARKUP % | TOTAL AMOUNT | Column1 | STAGE
DEMO |  | TRAILER |  | 4X4-8'- PRESSURE TREATED |  | 2X6-10' PRESSURE TREATED |  | TRAILER |  | DAY | 135 | 0.25 |  |  | DEMO
FOUNDATION |  | JOURNEYMAN |  | PB44 POST ANCHOR - TRIPLE GALV. |  | 16D NAILS- TRIPLE GALV. |  | JOURNEYMAN |  | HR | 70 | 0.25 |  |  | DEMO
BEAMS |  | APPRENTICE |  | LOAD EXCESS DIRT |  | INSTALL VICOR |  | APPRENTICE |  | HR | 45 | 0.25 |  |  | DEMO
[NAME] |  | LOAD |  | HAUL EXCESS DIRT |  | SET AND SECURE BEAM |  | LOAD |  | HR | 45 | 0.25 |  |  | DEMO
 |  | HAUL |  | 6X6-10'- PRESSURE TREATED |  | LAY OUT, CUT |  | HAUL |  | HR | 70 | 0.25 |  |  | DEMO
 |  |  |  | PB66 POST ANCHOR - TRIPLE GALV. |  | INSTALL HANGERS |  | 4X4-8'- PRESSURE TREATED |  | EA | 16.15 | 0.25 |  |  | FOUNDATION
 |  |  |  | 1⁄ 2" X 4" WEDGE ANCHOR |  |  |  | PB44 POST ANCHOR - TRIPLE GALV. |  | EA | 13.99 | 0.25 |  |  | FOUNDATION
 |  |  |  | 12" SONOTUBE - 4' LONG |  |  |  | LOAD EXCESS DIRT |  | HR | 70 | 0.25 |  |  | FOUNDATION
 |  |  |  | 21" BIGFOOT |  |  |  | HAUL EXCESS DIRT |  | HR | 70 | 0.25 |  |  | FOUNDATION
 |  |  |  | CONCRETE MIX - 80# [NAME] |  |  |  | 6X6-10'- PRESSURE TREATED |  | EA | 45.5 | 0.25 |  |  | FOUNDATION
 |  |  |  | MIX AND PLACE CONCRETE |  |  |  | PB66 POST ANCHOR - TRIPLE GALV. |  | EA | 29.99 | 0.25 |  |  | FOUNDATION
 |  |  |  | 11⁄ 2" HANGER NAILS - TRIPLE GALV. |  |  |  | 1⁄ 2" X 4" WEDGE ANCHOR |  | EA | 1.55 | 0.25 |  |  | FOUNDATION
 |  |  |  |  |  |  |  | 12" SONOTUBE - 4' LONG |  | EA | 10.49 | 0.25 |  |  | FOUNDATION
 |  |  |  |  |  |  |  | 21" BIGFOOT |  | EA | 25.95 | 0.25 |  |  | FOUNDATION
 |  |  |  |  |  |  |  | CONCRETE MIX - 80# [NAME] |  | EA | 4.65 | 0.25 |  |  | FOUNDATION
 |  |  |  |  |  |  |  | MIX AND PLACE CONCRETE |  | HR | 70 | 0.25 |  |  | FOUNDATION
 |  |  |  |  |  |  |  | 11⁄ 2" HANGER NAILS - TRIPLE GALV. |  | LB | 3 | 0.25 |  |  | FOUNDATION
 |  |  |  |  |  |  |  | 2X6-10' PRESSURE TREATED |  | EA | 18.8 | 0.25 |  |  | BEAMS
 |  |  |  |  |  |  |  | 16D NAILS- TRIPLE GALV. |  | LB | 3 | 0.25 |  |  | BEAMS
 |  |  |  |  |  |  |  | INSTALL VICOR |  | HR | 70 | 0.25 |  |  | BEAMS
 |  |  |  |  |  |  |  | SET AND SECURE BEAM |  | HR | 70 | 0.25 |  |  | BEAMS
 |  |  |  |  |  |  |  | LAY OUT, CUT |  | HR | 70 | 0.25 |  |  | BEAMS
 |  |  |  |  |  |  |  | INSTALL HANGERS |  | HR | 70 | 0.25 |  |  | BEAMS
Spreadsheet: 779564d1651855435-count-dynamic-array-based-on-date-to-return-dynamic-array-spill-range-count-dynamic-array-based-on-date-range-as-in-quarters
Sheet: Sheet1

Type | Date |  | Where it'll land |  | # of quarters |  | 10
A | 2023-12-18 00:00:00 |  | 2023-12-31 00:00:00
B | 2022-02-13 00:00:00 |  |  |  | Type |  | A | C
C | 2024-05-09 00:00:00 |  | 2024-06-30 00:00:00 |  |  |  |  |  | Dynamic Array formula resulting in Spill Range
D | 2024-05-03 00:00:00 |  | 2024-06-30 00:00:00
A | 2023-07-15 00:00:00 |  | 2023-09-30 00:00:00
B | 2022-09-05 00:00:00 |  | 2022-09-30 00:00:00 |  | 2022-02-01 00:00:00 |  | 2022-09-30 00:00:00 | 2022-12-31 00:00:00 | 2023-03-31 00:00:00 | 2023-06-30 00:00:00 | 2023-09-30 00:00:00 | 2023-12-31 00:00:00 | 2024-03-31 00:00:00 | 2024-06-30 00:00:00 | 2024-09-30 00:00:00
C | 2022-12-05 00:00:00 |  | 2022-12-31 00:00:00 |  |  |  | 0 | 1 | 0 | 1 | 2 | 1 | 0 | 1 | 2
D | 2022-09-01 00:00:00 |  | 2022-09-30 00:00:00 |  |  | 0 | 2 | 1 | 1 | 1 | 4 | 1 | 0 | 2 | 3
A | 2024-09-16 00:00:00 |  | 2024-09-30 00:00:00 |  |  |  | 0 | 1 | 0 | 1 | 2 | 1 | 0 | 1 | 2
B | 2024-09-17 00:00:00 |  | 2024-09-30 00:00:00
C | 2023-09-08 00:00:00 |  | 2023-09-30 00:00:00
D | 2023-02-03 00:00:00 |  | 2023-03-31 00:00:00 |  |  |  |  | Desired result to be dynamic array formula to have it Spill based on G7#
A | 2023-05-02 00:00:00 |  | 2023-06-30 00:00:00 |  |  |  |  | also, instead of #[NAME] if there's no value, to show as 0
B | 2023-09-09 00:00:00 |  | 2023-09-30 00:00:00
C | 2024-08-04 00:00:00 |  | 2024-09-30 00:00:00 |  | Current Not Working Formula
D | 2023-07-15 00:00:00 |  | 2023-09-30 00:00:00
 |  |  |  |  |  | =LET(qtrRange, G7#,
 |  |  |  |  |  | beginQuarter, EOMONTH(INDEX(qtrRange, SEQUENCE(1,COLUMNS(qtrRange))),-3)+1,
 |  |  |  |  |  | endQuarter,EOMONTH(INDEX(qtrRange, SEQUENCE(1,COLUMNS(qtrRange))),0),
 |  |  |  |  |  | COUNTA(FILTER(tblDummy[Type],
 |  |  |  |  |  | (ISNUMBER(MATCH(tblDummy[Type],$H$3:$I$3,0)))*
 |  |  |  |  |  | (tblDummy[Date]>=beginQuarter)*
 |  |  |  |  |  | (tblDummy[Date]<=endQuarter)
 |  |  |  |  |  | ))
 |  |  |  |  |  | )
Spreadsheet: 858541d1707191377-mailmerge-with-data-from-different-sheets-but-same-file-mailmerge-excel
Sheet: FH.3

NOME | PESO (KG) | Idade | [NAME]
ANTÓNIO JOSÉ | 70
MIGUEL TAVARES | 94
NUNO MELO | 90
JOSÉ ANTUNES | 85
AMILCAR CABRAL | 54
KIKO ESTVES | 58
Spreadsheet: 771445d1646674161-nested-if-and-sample-4
Sheet: Sheet1

Achieved Value % | 1.767053156467854 | 0.5334983143246539 | 0.39
Achieved Volume % | 1 | 0.5 | 0.43
 | month 1 | month 2 | month 3
 |  | 0.35 | 0.38 | 0.41 | 0.45
Month | 1 | 50 | 75 | 150 | 250
 | 2 | 50 | 75 | 150 | 250
 | 3 | 50 | 75 | 150 | 250
Spreadsheet: 826706d1682182431-nested-if-to-pull-most-recent-dates-attendance-tracker-4-22-23-sample
Sheet: Occurrences

[NAME]
Associate: | Bottas, Valtteri |  | Date Prepared:
Total Points: |  | Level:
Last Accountability Issue Date: |  |  | Expiration Date:
Date | ID# | Employee ID | Associate Name | Occ. Type | WLB Hours | Age (Days old) | Points | Notes
2022-11-02 00:00:00 | 999999 |  |  | Absent - Failure to Report
2022-11-15 00:00:00 | 111115 |  |  | Absent - Failure to Report
2022-12-01 00:00:00 | 111111 |  |  | Absent - Failure to Report
2022-12-02 00:00:00 | 999999 |  |  | Absent - Failure to Report
2022-12-15 00:00:00 | 555555 |  |  | Early Quit - Worked LESS than 1/2 Scheduled Day
2022-12-15 00:00:00 | 111115 |  |  | Absent - Failure to Report
2023-01-01 00:00:00 | 111111 |  |  | Tardy
2023-01-15 00:00:00 | 777777 |  |  | WLBD | 2
2023-01-15 00:00:00 | 111115 |  |  | Absent
2023-01-17 00:00:00 | 777777 |  |  | WLBD2 | 2
2023-02-01 00:00:00 | 111111 |  |  | Tardy
2023-02-02 00:00:00 | 999999 |  |  | Absent
2023-02-03 00:00:00 | 111119 |  |  | Absent - Failure to Report
2023-02-04 00:00:00 | 111119 |  |  | Absent
2023-03-01 00:00:00 | 999999 |  |  | Absent
2023-03-01 00:00:00 | 777777 |  |  | Tardy
2023-03-20 00:00:00 | 111114 |  |  | WLBD | 6
2023-03-23 00:00:00 | 111111 |  |  | WLBD | 8
2023-03-29 00:00:00 | 111123 |  |  | WLBD | 8
Spreadsheet: 742825d1628073130-weekly-summary-of-values-changed-between-same-day-divided-into-zones-weekly-summary-of-values-changed-between-same-day-divided-into-zones
Sheet: Sheet1

 |  |  | IFERROR(ABS(@INDEX(Database!$H:$H,AGGREGATE(14,6,ROW(Database!$M:$M)/((INT(Database!$M:$M)=INDEX($AE$6:$BF$6,1+4*INT((COLUMNS($C8:C8)-1)/4)))*(Database!$O:$O=$B8)*(Database!$P:$P=C$7)),1))-@INDEX(Database!$H:$H,AGGREGATE(15,6,ROW(Database!$M:$M)/((INT(Database!$M:$M)=INDEX($AE$6:$BF$6,1+4*INT((COLUMNS($C8:C8)-1)/4)))*(Database!$O:$O=$B8)*(Database!$P:$P=C$7)),1)))/100,"")
 | Week # 52 | 2021-06-20 00:00:00 |  |  |  | 2021-06-21 00:00:00 |  |  |  | 2021-06-22 00:00:00 |  |  |  | 2021-06-23 00:00:00 |  |  |  | 2021-06-24 00:00:00 |  |  |  | 2021-06-25 00:00:00 |  |  |  | 2021-06-26 00:00:00 |  |  |  |  | NOTE
 |  | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC |  | [NAME] in table 1 are different from other tables
 | Zone A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | From table2 on words formulas are same
 | Zone B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Drag down of table1 should not be done
 | Zone C
 | Zone D
 | Zone E
 | Week # 53
 |  | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC
 | Zone A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOTE
 | Zone B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | To extend to week 54
 | Zone C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Select B14:AD21
 | Zone D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Use fill handle and drag down.
 | Zone E |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Similarly for further weeks
 | Week # 54
 |  | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC | FM | SC | LP | QC
 | Zone A
 | Zone B
 | Zone C
 | Zone D
 | Zone E
Spreadsheet: andy_zipper__128__DYNEGY-ICE VOL Jun7
Sheet: ICE-ECC

Enron Canada Corporation
Activity on ICE
UOM | Deals | Volume
 |  |  |  |  |  |  | START | END
Enron Canada Corp.
Commodity Type:  All
Instruments:  All
Trade Dates:   Jun-7-01 thru Jun-7-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
Spreadsheet: 681801d1591757503-date-appear-in-cell-only-if-certain-time-met-demobook
Sheet: Sheet1

BLANK | BLANK | BLANK | BLANK | BLANK | Last licenced | 2 Months | [NAME]
BLANK | BLANK | BLANK | BLANK | BLANK | 2019-09-13 11:46:38
BLANK | BLANK | BLANK | BLANK | BLANK | 2019-05-25 11:02:49
BLANK | BLANK | BLANK | BLANK | BLANK | 2019-08-09 09:02:53
BLANK | BLANK | BLANK | BLANK | BLANK | 2019-07-09 08:09:22
BLANK | BLANK | BLANK | BLANK | BLANK | 2019-06-04 10:30:22
BLANK | BLANK | BLANK | BLANK | BLANK | 2019-08-22 08:00:04
BLANK | BLANK | BLANK | BLANK | BLANK | 2019-09-02 10:40:29
BLANK | BLANK | BLANK | BLANK | BLANK | 2019-09-02 10:39:24
BLANK | BLANK | BLANK | BLANK | BLANK | 2019-08-21 12:21:26
BLANK | BLANK | BLANK | BLANK | BLANK | 2019-08-20 09:26:08
BLANK | BLANK | BLANK | BLANK | BLANK | 2019-08-08 17:03:20
BLANK | BLANK | BLANK | BLANK | BLANK | 2019-08-19 10:32:31
BLANK | BLANK | BLANK | BLANK | BLANK | 2019-08-14 08:35:09
BLANK | BLANK | BLANK | BLANK | BLANK | 2019-03-26 12:04:25
BLANK | BLANK | BLANK | BLANK | BLANK | 2020-01-20 00:00:00
BLANK | BLANK | BLANK | BLANK | BLANK | 2020-01-25 00:00:00
BLANK | BLANK | BLANK | BLANK | BLANK | 2020-02-22 00:00:00
Spreadsheet: 161430d1339517055-excel-2007-offset-positional-reference-offset_code_excelforums
Sheet: Sheet1

 |  |  |  |  |  |  |  | Time 1 | Time 2 | Time 3
blank | Item | Machine | Start Date | Customer | Lot | [NAME] | Total Time | 20
19587 | 12345 | line 2 |  | C 1 | 12345 | 1 | 52
blank | TYPE II CO |  |  |  | 20 Mins
blank | REPASS |  |  |  | 7 Mins
blank | [NAME] |  |  |  | 25 Mins
blank | COMMIT |  |  |  | 0 Mins
blank | Item | Machine | Start Date | Customer | Lot | [NAME] | Total Time | 19
19588 | 6798 | line 2 |  | C 1 | 12345 | 1 | 224
blank | TYPE II CO |  |  |  | 19 Mins |  |  |  |  | 32
blank | REPASS |  |  |  | 7 Mins |  |  |  | 48
blank | NC |  |  |  | 32 Mins
blank | LAB |  |  |  | 48 Mins
blank | REPASS |  |  |  | 11 Mins
blank | [NAME] |  |  |  | 107 Mins
blank | COMMIT |  |  |  | 0 Mins
 | LOOKUP VALUE | CODE
 | Item ID | Time 1
 | 19587
Spreadsheet: 59222d1259710435-merging-two-sheets-into-a-third-sheet-database-assignment
Sheet: Motor Vehicle Death Rate

 | Motor Vehicle Death per 100,000
Alabama | 26.6
Alaska | 13.1
Arizona | 21.4
Arkansas | 25.9
California | 12.2
Colorado | 12.3
Connecticut | 10.1
Delaware | 16.4
District of Columbia | 6.8
Florida | 18.9
Georgia | 18.9
Hawaii | 11.9
Idaho | 20.4
Illinois | 10.9
Indiana | 15
Iowa | 14.6
Kansas | 17.4
Kentucky | 22
Louisiana | 23.7
Maine | 14.3
Maryland | 12.9
Massachusetts | 7.3
Michigan | 11.5
Minnesota | 11.6
Mississippi | 33.3
Missouri | 18.8
Montana | 27.3
Nebraska | 14.8
Nevada | 17.9
New Hampshire | 9.5
New Jersey | 8.8
New Mexico | 24.1
New York | 8.1
North Carolina | 19.2
North Dakota | 17.9
Ohio | 11.7
Oklahoma | 21.8
Oregon | 13.5
Pennsylvania | 12.8
Rhode Island | 7.8
South Carolina | 24.1
South Dakota | 24.2
Tennessee | 22.8
Texas | 16.8
United States | 15
Utah | 13.9
Vermont | 14.1
Virginia | 12.5
Washington | 11.4
West Virginia | 23.1
Wisconsin | 13.5
Wyoming | 29.7
Spreadsheet: 93915d1293681237-finding-and-eliminating-numbers-has3or8
Sheet: Sheet1

Number | String | Has 3 | Has 8 |  |  |  | Result |  | Has 3 | False
521 |  |  |  | 3 | 8 |  | 029 |  | Has 8 | False
270 |  |  |  |  |  |  | 126
225 |  |  |  |  |  |  | 127 |  | Row Labels
234 |  |  |  |  |  |  | 225 |  | 029
126 |  |  |  |  |  |  | 227 |  | 126
028 |  |  |  |  |  |  | 229 |  | 127
127 |  |  |  |  |  |  | 245 |  | 225
253 |  |  |  |  |  |  | 247 |  | 227
029 |  |  |  |  |  |  | 264 |  | 229
182 |  |  |  |  |  |  | 267 |  | 245
227 |  |  |  |  |  |  | 270 |  | 247
623 |  |  |  |  |  |  | 275 |  | 264
245 |  |  |  |  |  |  | 291 |  | 267
291 |  |  |  |  |  |  | 296 |  | 270
822 |  |  |  |  |  |  | 521 |  | 275
372 |  |  |  |  |  |  | 529 |  | 291
264 |  |  |  |  |  |  | 562 |  | 296
229 |  |  |  |  |  |  | 727 |  | 521
283 |  |  |  |  |  |  | 942 |  | 529
247 |  |  |  |  |  |  |  |  | 562
562 |  |  |  |  |  |  |  |  | 727
293 |  |  |  |  |  |  |  |  | 942
482 |  |  |  |  |  |  |  |  | Grand Total
275
942
258
267
529
862
727
296
287
Spreadsheet: 122629d1317035407-cant-get-correct-with-lookup-example
Sheet: Sheet1

Date | Shift | Gross | Net
2011-01-01 00:00:00 | Day | 100 | 95
2011-01-01 00:00:00 | Night | 110 | 101
2011-01-02 00:00:00 | Day | 89 | 78
2011-01-02 00:00:00 | Night | 100 | 99
2011-01-03 00:00:00 | Day | 97 | 94
2011-01-03 00:00:00 | Night | 101 | 100
2011-01-04 00:00:00 | Day | 107 | 103
2011-01-04 00:00:00 | Night | 100 | 97
2011-01-05 00:00:00 | Day | 88 | 81
2011-01-05 00:00:00 | Night | 96 | 88
Spreadsheet: 700877d1603381868-subtracting-feet-and-inches-while-maintaining-format-pump-foundation-fdn
Sheet: Summary

PIPE SUPPORT FOUNDATION SUMMARY SCHEDULE
FDN TYPE | ITEM # | N/S | N/S | E/W | E/W |  | TOC
PILE FDN | MPS-01 | -87'-4 7/16" | S. 0+87'-4 7/16" | 28'-1" | E. 0+28'-1" | 1900-01-01 00:00:00 | 80'-6"
PILE FDN | MPS-02 | -82'-0 5/16" | S. 0+82'-0 5/16" | 28'-1" | E. 0+28'-1" |  | 80'-6"
PILE FDN | MPS-03 | -79'-9" | S. 0+79'-9" | 42'-9 1/4" | E. 0+42'-9 1/4" |  | 80'-5 7/8"
PILE FDN | MPS-04 | -79'-9" | S. 0+79'-9" | 53'-2 13/16" | E. 0+53'-2 13/16" |  | 81'-8 7/16"
PILE FDN | MPS-05 | -79'-9" | S. 0+79'-9" | 64'-3 5/8" | E. 0+64'-3 5/8" |  | 81'-8 7/16"
Spreadsheet: 132103d1323480952-combining-vlookup-and-if-formula-to-return-a-value-breeze123
Sheet: Sheet5

[NAME] | Mar | Comm % | Bonus  Scheme | Total Sales
Gibbons,[NAME] | 3360
Pascoe,[NAME] | 7988
Walters,[NAME] | 7420
Stringer,[NAME] | 5600
Knott,Delia | 4325
Thompson,[NAME] | 6740
[NAME],[NAME] | 6950
Gordon,Marie | 8745
Spreadsheet: 800825d1665912338-excel-bar-graph-multiple-data-sets-excel-question-help-123
Sheet: Sheet2

 |  |  | Q4 2015 | Q1 2016 | Q2 2016 | Q3 2016 | Q4 2016 | Q1 2017 | Q2 2017 | Q3 2017 | Q4 2017
 |  | Total sales | 50
 |  | Chair sales | 10
 |  | Competitor | 65
Spreadsheet: 50201d1249578870-2007-drop-down-list-array-not-sure-cnp-purchase-order
Sheet: Purchase Order

 | [NAME]
KSMB LTD |  |  |  |  | Date:
Supplying the Fitness World |  |  |  |  | P.O. #: | [0004]
 |  |  |  |  | Customer ID: | [CNP]
Vendor | CNP Professional |  | Ship to | [NAME]
 | Unit 5 Windmill Trading Estate |  |  | KSMB Ltd
 | [NAME] |  |  | 8 Chaucer Close
 | Denton, [NAME], M34 3JN |  |  | Waterlooville, Hants, PO7 6AQ
 | [PHONE] |  |  | 02392 350212
Shipping Method |  | Shipping Terms |  |  | Delivery Date
Qty | Item # | Description | Flavour | Job | Unit Price | Line Total
 |  | Pro-Bar XS 12 off
 |  | Pro-Recover Shake N Take
 |  | Pro-Mass 4.5kg
 |  | [NAME] 2.27kg
 |  | Pro-MR 20 Sachets
 |  | Pro-Peptide 908g
 |  | Pro-Peptide 2.27kg
 |  | Pro-MS
 |  | Pro-GF Nox
 |  | Pro-Solo, 1200g
 |  | Pro-Energy, 500g
 |  | Pro-Hydrate, 500g
 |  | Pro-Energy Bar, 30 bars
 |  | Pro-Flapjack Bars 24
 |  | Pro-Bar XS 12 off
 |  | Pro-Dessert 15 off
 |  | Pro-Tect 500g
 |  | Pro-Creatine 100g
 |  | Pro-Creatine 500g
 |  | Pro-Fuel 1.8kg
 |  | Pro-Recover
 |  | Pro-Recover Shake N Take
 |  | Pro-Recover 5kg
 |  | Pro Slam 12 vials
 |  |  |  |  | Subtotal
 |  |  |  |  | Sales Tax
 |  |  |  |  | Total
 |  |  |  | [NAME]
 |  |  |  | Authorized by:                          Kieren Schneider |  | Date
KSMB Ltd, 8 Chaucer Close, Waterlooville, Hants, PO7 6AQ, [NAME]: 02392 350212 Business Registration Number: 6*********
Spreadsheet: 789162d1658934086-dynamically-place-maximum-pay-range-in-last-row-column-b-starting-trend-test
Sheet: Sheet1

Pay Band Calculator - 10 Years
[NAME] |  |  |  |  | Pay Increase Jumps
Pay Band | Min | [NAME] |  |  | Semi-Annual Increase | Annual Increase
Rates | 35
Enter Years of Experience Here to get Rate
YOE | Calculated Rate |  |  |  | YOE Move | Market Move
8 |  |  |  |  | 0.02 | 0.02
YOE Salary | [NAME] band | [NAME] Years
 |  | 15
[NAME]: based off of the amount of years in c12.  I want the dollars to be automatically populated in column B18 down.  When [NAME] Years is entered…I want dynamically adjust the Dollars column.
Years of Experience | Dollars | Pay Increase
 |  | 0
0.5
1
1.5
2
2.5
3
3.5
4
4.5
5
5.5
6
6.5
7
7.5
8
8.5
9
9.5
10 | 45.5
10.5
11
11.5
12
12.5
13
13.5
14
14.5
15
Spreadsheet: 115228d1310839996-if-function-book1_kameran
Sheet: Sheet1

100
100
101
101
102
102
103
103
104
104
105
105
106
106
107
107
108
108
109
109
110
110
111
111
112
112
113
113
114
114
115
115
116
116
117
117
118
118
119
119
120
120
121
121
122
122
123
123
124
124
125
125
126
126
127
127
128
128
129
129
130
130
131
131
132
132
133
133
134
134
135
135
136
136
137
137
138
138
139
139
140
140
141
141
142
142
143
143
144
144
145
145
146
146
147
147
148
148
149
149