tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 863188d1710774461-orders-and-returns-detailed-contract-summary-order-and-returns-contract-summary-jrich16-
Sheet: Sheet1

Contract Summary
Order and [NAME] |  |  |  |  | Customer Contract Details
Type | Date | Serial Number | Customer # |  |  | Start Date | Customer Number | Cash Back (Purchase Only) | Annual Volume Commitments
Order | 2000-01-01 00:00:00 | 1 | 100 |  |  | 2022-01-01 00:00:00 | 100 | 5 | 10
Return | 2021-01-01 00:00:00 | 2 | 100 |  |  | 2024-01-01 00:00:00 | 200 | 10 | 20
Order | 2022-01-01 00:00:00 | 3 | 100
Return | 2023-01-01 00:00:00 | 1 | 100 |  | Rules
Return | 2023-01-01 00:00:00 | 3 | 100 |  | 1 | Orders must be at => after start date (i.e 1/1/2022 or after for customer 100)
Order | 2023-01-01 00:00:00 | 8 | 200 |  | 2 | Returns are only counted if the returned serial number was purchased => start date (i.e 1/1/2022 or after for customer 100)
Order | 2024-01-01 00:00:00 | 4 | 100 |  | 3 | Orders and returns can happen on the same date since this is a customer product (returns are easy)
Order | 2024-01-01 00:00:00 | 5 | 100 |  | 4 | Volume commitments are counted as the NET # orders (orders - returns)
Order | 2024-01-01 00:00:00 | 6 | 200 |  | 5 | Cash back is counted on NET # orders (orders-returns)
Return | 2024-01-01 00:00:00 | 5 | 100
Order | 2025-01-01 00:00:00 | 7 | 200
Return | 2025-01-01 00:00:00 | 7 | 200
Order | 2026-01-01 00:00:00 | 9 | 200
Answer (cells in yellow are what will be filled by formulas)
Below are the answers - I mannually entered in the  correct answer and did my best to show all details :)
Customer # | Orders | Returns | Cash Back |  | Net Orders | Volume Commitment | [NAME]
Spreadsheet: 6e537e52-4565-4f41-b421-b1893255d7e7
Sheet: Budget YTD

 | Days on Month Calc |  |  | 31 |  | 31 | 30 | 31 | 30 | 31 | 31 | 30 | 31 | 30 | 31
 | Month and Year Calc
 | Items Revenue/Expense |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 |  | Total Income
 |  | Month and Year Calc Income/Expense
 |  | Expenses |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | Total Expenses
 | Income Less Expenses
 | 1 | Beginning Cash Balance
 | 2 | Income Less Expense
 | 3 | Ending Cash Balance
 | 1 | Roth IRA Cumulative Contribution
Spreadsheet: 809630d1671189331-find-median-between-2-dates-and-product-median-1-
Sheet: Ark1

 |  |  |  |  | Apple | [NAME] | Orange
 |  |  |  | 2022-10-01 00:00:00 | 10 | 20 | 5
 |  |  |  | 2022-11-01 00:00:00 | 12 | 23 | 6
 |  |  |  | 2022-12-01 00:00:00 | 14 | 24 | 7
 |  |  |  | 2023-01-01 00:00:00 | 16 | 25 | 8
 |  |  |  | 2023-02-01 00:00:00 | 18 | 26 | 9
 |  |  |  | 2023-03-01 00:00:00 | 20 | 27 | 10
 |  |  |  | 2023-04-01 00:00:00 | 22 | 28 | 11
 |  |  |  | 2023-05-01 00:00:00 | 24 | 29 | 12
 |  |  |  | 2023-06-01 00:00:00 | 26 | 30 | 13
 |  |  |  | 2023-07-01 00:00:00 | 28 | 31 | 14
 |  |  |  | 2023-08-01 00:00:00 | 30 | 32 | 15
 |  |  |  |  |  | Example 1
 |  |  |  |  |  | Product | Startdate | number of months | Median
 |  |  |  |  |  | Apple | 2022-11-01 00:00:00 | 3 | 14
 |  |  |  |  |  | Example 2
 |  |  |  |  |  | Product | Startdate | number of months | Median
 |  |  |  |  |  | [NAME] | 2022-12-01 00:00:00 | 5 | 18
Spreadsheet: 489208d1479145188-table-lookup-challenge-annualreview
Sheet: Sheet1

 | Revuer | Revuee
 | Jon | [NAME]
 | Jon | [NAME] |  |  | Row Labels
 | Jon | Greg |  |  | Jon
 | [NAME] | Ashkay |  |  | Greg
 | [NAME] | [NAME] |  |  | [NAME]
 | [NAME] | [NAME] |  |  | [NAME]
 | [NAME] | [NAME] |  |  | [NAME]
 | [NAME] | Jon |  |  | [NAME]
 | [NAME] | [NAME] |  |  | Jon
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | Ashkay
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | Grand Total
Spreadsheet: 785797d1656691305-formula-for-gating-value-from-pivot-table-and-by-verifying-the-date-filter-2022-07-01-oeldere-jocky6688-pivot-query
Sheet: Sheet1

Date | Quarter | Month | Year | Consumption | Year | 2016
2015-01-01 00:00:00 | Q4 | Jan | 2014 | 1250 |  |  |  |  | HI need help on Pivot table data.
 | Q4 | Jan | 2014 | 1658 | Row Labels | Sum of Consumption
 | Q4 | Feb | 2014 | 1798 | Q1 | 10873 |  |  | Kindly find the attached sheet in which I need to get the consumption details for the year 2015 from the [NAME] sheet (and [NAME]), but if I change the filter year, the consumption details change, which should not happen.
 | Q4 | Mar | 2014 | 4963 | Q2 | 12819
 | Q1 | Apr | 2015 | 7896 | Q3 | 27708.6642 |  |  | Kind Regards,
 | Q1 | May | 2015 | 1238 | Q4 | 10820.3379 |  |  | J
 | Q1 | May | 2015 | 2098 | Grand Total | 62221.0021
 | Q1 | Jun | 2015 | 7964
 | Q2 | Jul | 2015 | 1597
 | Q2 | Aug | 2015 | 9876
 | Q2 | Sep | 2015 | 7958 | Year | Consumption
 | Q3 | Oct | 2015 | 1656 | 2015
 | Q3 | Oct | 2015 | 2597
 | Q3 | Nov | 2015 | 7965
 | Q3 | Dec | 2015 | 1597
 | Q4 | Jan | 2015 | 9876 |  | Som van Consumption | Kolomlabels
 | Q4 | Feb | 2015 | 7958 |  | Rijlabels | 2014 | 2015 | 2016 | 2017 | Eindtotaal
 | Q4 | Mar | 2015 | 1656 |  | Q1 |  | 19196 | 10873 | 1658 | 31727
 | Q4 | Mar | 2015 | 2597 |  | Q2 |  | 19431 | 12819 |  | 32250
 | Q1 | Apr | 2016 | 7965 |  | Q3 |  | 13815 | 15517.7608 |  | 29332.7608
 | Q1 | May | 2016 | 1250 |  | Q4 | 9669 | 22087 | 10820.3379 |  | 42576.3379
 | Q1 | Jun | 2016 | 1658 |  | Eindtotaal | 9669 | 74529 | 50030.0987 | 1658 | 135886.0987
 | Q2 | Jul | 2016 | 1798
 | Q2 | Jul | 2016 | 4963
 | Q2 | Aug | 2016 | 1128
 | Q2 | Sep | 2016 | 4930
 | Q3 | Oct | 2016 | 2282
 | Q3 | Nov | 2016 | 5450.5133
 | Q3 | Dec | 2016 | 6435.2475
 | Q3 | Dec | 2016 | 1350
 | Q4 | Jan | 2016 | 4834.3825
 | Q4 | Feb | 2016 | 2443.7409
 | Q4 | Mar | 2016 | 3542.2145
 | Q1 | Apr | 2017 | 1658
Spreadsheet: mark_whitt__25315__El paso pipeline marketing
Sheet: Sheet1

Marketing Target
1) [NAME] | Lead | Customer Contact | Status | Comments
Huber | [NAME] | [NAME] | Should close this week | Recommending to Management
Pure | J.Z. |  | Package being prepared--presented this week
Phillips | [NAME] | [NAME] | Not considering long term deals at this time
Amoco | [NAME] |  | Continuing conversations via phone | low probability
[NAME] | [NAME] |  | Will look at deal in next few weeks | low probability
Texaco/Chevron | [NAME] |  | Continuing conversations via phone | medium probability
Cross Timbars | [NAME] |  | not interested
Western Gas | M.N. | [NAME] | reviewing; minimal interest
BP Amoco ([NAME]) | [NAME] |  | Interested in capacity for Calpeak deal | -$30MM bid, negotiating
2) Generation | Lead |  | Status | Comments
Reliant | [NAME] |  | Had detailed conversation in which they informed me they are not interested | Dead for now
Calpine | [NAME] |  | 10/3 Calpine "frozen " - do not expect action soon | medium probability
Mirant | [NAME] |  | Based on 9/25 discussion,[NAME] to provide feedback on their valuation - 10/3 left message | low probability
NRG | [NAME] | [NAME] | Call into [NAME] | low probability
FPL | [NAME] |  | Proposal sent to [NAME] 9/26 - phone call from FPL 10/5 [NAME] is rep. | low probability
AES | [NAME] |  | 2 low load factor plants in [NAME]. with 2004 start. Not looking to buy firm transport - projects doubtful ([NAME]) | no probability
Tractabel | [NAME] |  | [NAME] advised (9/25) that they're "done" on firm transport. No need for incremental | medium probability
Mexicana de Cobre | [NAME] |  | Offered earlier start date (9/21) to go with package previously assigned | low probability
SPPC/NPC | [NAME] |  |  | low probability
[NAME] ([NAME]) | [NAME] | [NAME] | Showed term sheet | Waiting for reply
Delta Power | [NAME] | [NAME] | Showed term sheet | Waiting for reply
Ogden Pacific | [NAME] | [NAME] | Showed term sheet | Plant not on-line until 04
3) Current EPNG Shippers | Lead |  | Status | Comments
Duke | [NAME] |  | Low interest on Duke's part - last offer was $7.5 - $8MM for 1/02 start  and $1 MM for a 11/03 start | low probability
El Paso | N/A
Tenaska | [NAME] |  | Fred passed to [NAME] -will call today. | low probability
SMUD | [NAME] |  | [NAME] regarding '03 capacity sent
4) Industrial | Lead |  | Status | Comments
Palo Alto | [NAME] | [NAME] | create term sheet/structure.  Would only be interest jan. 2003 forward.   Sent presentation and will discuss this week. | Interseted
NCPA | [NAME] | [NAME] | create term sheet/structure.  No interest in additional capacity of any kind. | No Interest
Santa Clara | [NAME] | [NAME] | create term sheet/structure.  Would only be interest jan. 2003 forward.  Sent presentation and left three phone messages to discuss | Interested but low probability
Knauf Fiberglass | [NAME] | [NAME] | create term sheet/structure.  Working on structure for Knauf.
Merced | [NAME] | [NAME] | No interest. | No Interest
[NAME] | [NAME] | [NAME] | Left messages for [NAME].  No returned calls. | Very low probability due to current market - for power and airlines!
Spreadsheet: 682212d1591966160-shortlisting-of-values-with-1-criteria-map3
Sheet: Blad1

 | Data |  |  |  |  | Output
 |  | Fruits | Vegetables |  |  | Fruits | Vegetables
 | Apple | x |  |  |  | Apple | Lettuce
 | [NAME] | x |  |  |  | [NAME] | Tomatoe
 | Grape | x |  |  |  | Grape | Carrot
 | Lettuce |  | x |  |  | Orange
 | Tomatoe |  | x |  |  | Lemon
 | Orange | x |  |  |  | Peach
 | [NAME] | x
 | Lemon | x
 | Peach | x
 | Apple | x
 | Tomatoe |  | x
 | Carrot |  | x
 | Tomatoe |  | x
Spreadsheet: 768597d1645040039-counting-cells-based-on-part_work_order-and-route_step_num-excel-question
Sheet: Sheet1

Part_Work_Order | Route_Step_Num | Cell |  |  |  | Cell: | Count:
1RRR | 3 | Saw1 |  | [NAME] would only count Saw1 once because the route_step_num 1 to 3 is in sequece with each other. |  | Saw1
1RRR | 5 | Inspection |  | So the count for Part_Work_Order would be 1 Saw1 & 1 Inspection. |  | Inspection
1RRR | 1 | Saw1 |  |  |  | Saw2
[NAME] | 2 | Saw1 |  |  |  | Ground
[NAME] | 4 | Inspection |  |  |  | Ship
[NAME] | 5 | Saw1
[NAME] | 6 | Saw1
[NAME] | 8 | Saw1
[NAME] | 11 | Saw2
[NAME] | 12 | Saw2
[NAME] | 13 | Ground
[NAME] | 15 | Ground
[NAME] | 16 | Ship
3FFF | 2 | Ship
3FFF | 3 | Saw1
3FFF | 1 | Ship
3FFF | 5 | Saw1
3FFF | 8 | Inspection
3FFF | 9 | Ship
4GGG | 3 | Saw1
4GGG | 4 | Saw1
4GGG | 5 | Saw1
4GGG | 6 | Saw1
4GGG | 8 | Inspection
4GGG | 10 | Inspection
4GGG | 11 | Inspection
4GGG | 12 | Inspection
4GGG | 13 | Saw1
4GGG | 14 | Saw1
4GGG | 15 | Saw1
4GGG | 16 | Saw2
4GGG | 17 | Saw2
4GGG | 18 | Saw2
4GGG | 19 | Saw2
4GGG | 21 | Ground
4GGG | 22 | Ground
4GGG | 23 | Ship
Spreadsheet: 842130d1694186048-alternative-to-indirect-for-referencing-named-ranges-sample-excel-1-tms
Sheet: Attendance

 | Month | Primary | Secondary | Total | Bonus | Other (+) | Other (-) | Nett Payment | Basic | Comm P | Comm S | EPF 11% | SOCSO | EIS | EPF 13% | SOCSO | EIS
ABC | 09/2023 | 345 | 130
DEF | 08/2023 | 456 | 23
GHI | 02/2023 | 345 | 150
Spreadsheet: 69202d1269720543-excel-2007-auto-sum-and-fill-in-prem2
Sheet: Sheet1

Spurs | Prediction | Result | Man City | Prediction | Result | [NAME] | Prediction | Result | Liverpool | Prediction | Result
Portsmouth | W | W | Everton | D | L | Sunderland | W | D | Sunderland | W
Sunderland | W |  | [NAME] | W |  | Chelsea | L | L | Birmingham | D
Arsenal | L |  | Burnley | W |  | [NAME] | W |  | Fulham | W
Chelsea | L |  | Birmingham | W |  | Everton | D |  | West Ham | W
Man United | L |  | Man United | L |  | Portsmouth | D |  | Burnley | D
[NAME] | W |  | Arsenal | L |  | Hull | W |  | Chelsea | L
Man City | D |  | [NAME] | D |  | Birmingham | D |  | Hull | W
Burnley | W |  | Spurs | D |  | Man City | D
 |  |  | West Ham | W |  | [NAME] | W
Total Points
 | +/- |  |  | +/- |  |  | +/- |  |  | +/-
 |  | Example 0 |  |  | Example -1 |  |  | Example -2 |  |  | Example 0
Spreadsheet: darrell_schoolcraft__7323__imball0202
Sheet: PG&E

56698
Day | Measured | Scheduled
1 | -246404 | -244010
2 | -244917 | -244299
3 | -242647 | -242291
4 | -244008 | -243254
5 | -246342 | -243974
6 | -251402 | -250987
7 | -248856 | -248311
8 | -264991 | -264300
9 | -253917 | -251967
10 | -244921 | -244417
11 | -228979 | -229000
12 | -229532 | -228999
13 | -227809 | -226276
14 | -224634 | -224000
15 | -229328 | -229000
16 | -254408 | -254408
17 | -254405 | -254408
18 | -254411 | -254408
19 | -254111 | -254408
20
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | 28722
2002-02-19 00:00:00
CBS Dollars
 |  |  | -143669
Spreadsheet: 689870d1596715018-library-users-excel-formula-for-making-a-list-and-count-excel_2020_chris
Sheet: Sheet1

Count of PUBLICATION | Column Labels
Row Labels | yes | (blank) | Grand Total
[NAME] |  | 1 | 1
Surnamaa Namaa | 2 | 5 | 7
[NAME] | 1 | 2 | 3
[NAME] |  | 5 | 5
[NAME] |  | 1 | 1
[NAME] | 2 | 2 | 4
Surname Name | 5 | 2 | 7
[NAME] | 3 | 1 | 4
Surnameee Nameee | 1 | 1 | 2
Grand Total | 14 | 20 | 34
Spreadsheet: 724584d1616249103-i-need-some-help-on-sum-diferent-criterios-centro-de-custos-2021
Sheet: Vale - Estrada

 |  | CENTROS DE CUSTOS
 |  | VALE - Tap.Buracos e Pintura - Estrada
 |  | Data | [NAME] | Req. / Fact nº | Valor - Mzn | Observação
 |  | 2020-09-03 00:00:00 | Combustivel | 54562 | 4342.3 | Logistica
 |  | 2020-09-03 00:00:00 | Combustivel | 54561 | 6644.8 | Gerador
 |  | 2020-09-03 00:00:00 | Combustivel | 54561 | 6961.6 | Compressor
 |  | 2020-09-10 00:00:00 | Combustivel | 54597 | 1286.8 | Compressor
 |  | 2020-09-10 00:00:00 | Combustivel | 54597 | 2784.4 | Maq. Pintar Estrada
 |  | 2020-09-14 00:00:00 | Combustivel | 54614 | 5147.2 | Compressor
 |  | 2020-09-23 00:00:00 | Combustivel | 54681 | 2000 | Compressor
 |  | 2020-09-23 00:00:00 | Combustivel | 54681 | 1250 | Cut Machine
 |  | 2020-09-26 00:00:00 | Combustivel | 54697 | 1392.2 | Cilindro duplo Manual
 |  | 2020-09-26 00:00:00 | Combustivel | 54697 | 1392.2 | Saltitao
 |  | 2020-09-27 00:00:00 | Combustivel | 54703 | 2169.85 | Logistica
 |  | 2020-10-05 00:00:00 | Combustivel | 54748 | 4640.2 | Logistica
 |  | 2020-10-06 00:00:00 | Combustivel | 54752 | 2784.4 | Maq. Pintar Estrada
 |  | 2020-10-09 00:00:00 | Combustivel | 54772 | 3498.2 | Logistica
 |  | 2020-11-05 00:00:00 | Combustivel | 54937 | 3850.2 | Logistica
 |  | 2020-11-08 00:00:00 | Combustivel | 54954 | 3750.5 | Logistica
 |  | 2020-11-11 00:00:00 | Combustivel | 54980 | 2580 | Logistica
 |  | 2020-11-14 00:00:00 | Combustivel | 54997 | 4128.1 | Logistica
Spreadsheet: 101105d1299255891-using-mode-to-find-the-most-popular-values-not-working-766922_adhamija
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | List |  | ID# | Rx 1 | Rx 2 | Rx 3 | Rx 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900 | GBN | GJK | . | .
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1901 | NTO | GBN | GJK | .
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1902 | #N/A | #N/A | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1903 | GBN | . | . | .
Spreadsheet: 112861d1308840492-drop-down-menu-variable-fields-pulldownexample-2
Sheet: Sheet1

 |  | Company 1
Company |  |  |  |  |  |  |  |  |  |  |  | Company 1 | *O4-2300*
Company 2 |  |  |  |  |  |  |  |  |  |  |  | Company 2 | *05-6100*
 |  |  |  |  |  |  |  |  |  |  |  | Company 3 | 6000
 |  |  |  |  |  |  |  |  |  |  |  | Company 4 | 7000
 |  |  |  |  |  |  |  |  |  |  |  | Company 5 | 8000
 |  |  |  |  |  |  |  |  |  |  |  | Company 6 | 9000
 |  |  |  |  |  |  |  |  |  |  |  | Company 7 | 10000
 |  |  |  |  |  |  |  |  |  |  |  | Company 8 | 11000
 |  |  |  |  |  |  |  |  |  |  |  | Company 9 | 12000
 |  |  |  |  |  |  |  |  |  |  |  | Company 10 | 13000
 |  |  |  |  |  |  |  |  |  |  |  | Company 11 | 14000
 |  |  |  |  |  |  |  |  |  |  |  | Company 12 | 15000
 |  |  |  |  |  |  |  |  |  |  |  | Company 13 | 16000
Spreadsheet: hunter_shively__12678__Nov_01 Volume Changes
Sheet: Nov 7

Pipeline | Producer | Deal | Zone | Current Volume | New Volume | Change | Index | GDA
ANR | Torch | 1060018 | Gath | 0 | 5 |  |  | 5
ANR | Torch | 1059865 | Gath | 1 | 6 |  | 5
ANR | Cosstex | 1131077 | Gath | 3010 | 2720 |  |  | -290
CGFL | Forest | 1109818 | [NAME] | 3856 | 2256 |  | -1600
SNAT | Stone | 1054822 | Uncnstrnd WH | 4697 | 4232 |  | -465
TENN | Panaco | 1135603 | Zone 500 | 5070 | 4800 |  |  | -270
TENN | Forest | 1109820 | Zone 500 | 3542 | 2835 |  | -707
TENN | W&T | 1135864 | Zone 800 | 2900 | 3638 |  | 738
TENN | Progas | 1143677 | Zone 800 | 2203 | 5051 |  |  | 2848
TENN | Westport | 1143232 | Zone 800 | 5670 | 8000 |  |  | 2330
TETCO | Unimark | 1146397 | ELA | 6722 | 4267 |  |  | -2455
TRCO | Energy Res | 1135719 | Z 3 | 7320 | 5850 |  |  | -1470
TRNKL | Forest | 1127986 | ELA | 2512 | 2300 |  |  | -212
 |  |  |  |  |  | Daily Total
 |  |  |  |  |  | MTD Total | -34514 | -1285
Spreadsheet: 465444d1465656539-excel-date-dropdown-on-cell-date-dropdown
Sheet: Sheet1

 |  |  |  |  |  | 2016-05-01 00:00:00
 |  |  | 2016-05-03 00:00:00 |  |  | 2016-05-02 00:00:00
 |  |  |  |  |  | 2016-05-03 00:00:00
 |  |  |  |  |  | 2016-05-04 00:00:00
 |  |  |  |  |  | 2016-05-05 00:00:00
 |  |  |  |  |  | 2016-05-06 00:00:00
 |  |  |  |  |  | 2016-05-07 00:00:00
 |  |  |  |  |  | 2016-05-08 00:00:00
 |  |  |  |  |  | 2016-05-09 00:00:00
 |  |  |  |  |  | 2016-05-10 00:00:00
 |  |  |  |  |  | 2016-05-11 00:00:00
 |  |  |  |  |  | 2016-05-12 00:00:00
 |  |  |  |  |  | 2016-05-13 00:00:00
 |  |  |  |  |  | 2016-05-14 00:00:00
 |  |  |  |  |  | 2016-05-15 00:00:00
 |  |  |  |  |  | 2016-05-16 00:00:00
 |  |  |  |  |  | 2016-05-17 00:00:00
 |  |  |  |  |  | 2016-05-18 00:00:00
 |  |  |  |  |  | 2016-05-19 00:00:00
 |  |  |  |  |  | 2016-05-20 00:00:00
 |  |  |  |  |  | 2016-05-21 00:00:00
 |  |  |  |  |  | 2016-05-22 00:00:00
 |  |  |  |  |  | 2016-05-23 00:00:00
 |  |  |  |  |  | 2016-05-24 00:00:00
 |  |  |  |  |  | 2016-05-25 00:00:00
 |  |  |  |  |  | 2016-05-26 00:00:00
 |  |  |  |  |  | 2016-05-27 00:00:00
 |  |  |  |  |  | 2016-05-28 00:00:00
 |  |  |  |  |  | 2016-05-29 00:00:00
 |  |  |  |  |  | 2016-05-30 00:00:00
 |  |  |  |  |  | 2016-05-31 00:00:00
 |  |  |  |  |  | 2016-06-01 00:00:00
 |  |  |  |  |  | 2016-06-02 00:00:00
 |  |  |  |  |  | 2016-06-03 00:00:00
 |  |  |  |  |  | 2016-06-04 00:00:00
 |  |  |  |  |  | 2016-06-05 00:00:00
 |  |  |  |  |  | 2016-06-06 00:00:00
 |  |  |  |  |  | 2016-06-07 00:00:00
 |  |  |  |  |  | 2016-06-08 00:00:00
 |  |  |  |  |  | 2016-06-09 00:00:00
 |  |  |  |  |  | 2016-06-10 00:00:00
Spreadsheet: 524809d1498336112-formula-to-transfer-data-from-one-range-of-cells-to-another-based-on-conditions-example
Sheet: Summary

SUMMARY
TOTAL UPSETS BY YR. |  | TOTAL UPSETS BY SEED RANKING PER YR. |  |  |  |  |  |  |  | TOTAL SEED RANKING UPSET % PER YR. |  |  |  |  |  |  |  |  |  | TOTAL PROBABILITY COMPARISON
Year | Upsets | 16th | 15th | 14th | 13th | 12th | 11th | 10th | 9th | Upset %/Yr | 16(th) | 15(th) | 14(th) | 13(th) | 12(th) | 11(th) | 10(th) | 9(th) |  | [NAME] | Mean | Stdev. | Upset Prob. | Upset Prob. % | Projected Upsets | Actual Upsets | Difference | Avg. [NAME]. Upset
1985 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 vs. 16
1986 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 vs. 15
1987 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 vs. 14
1988 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 vs. 13
1989 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 vs. 12
1990 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 vs. 11
1991 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 vs. 10
1992 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 vs. 9
1993
1994 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BASIC |  |  | QUICK DROP DOWN SUMMARY
1995 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Tourneys |  |  | DROP DOWN LIST 1
1996 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Games/Yr | 32 |  | Team Name | General [NAME] | Answer
1997 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kentucky | [NAME].
1998
1999
2000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DROP DOWN LIST 2
2001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Team Name | Seed Stats | Category | Answer
2002 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Duke | 1 vs 16 | Win %
2003
2004
2005 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DROP DOWN LIST 3
2006 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Team Name | Conference Stats | Category | Answer
2007 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Arizona | America East | Win/Loss Record
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
Spreadsheet: 59498d1259999263-excel-2007-circular-formula-testdungeon
Sheet: Sheet1

 |  |  | Guild 1 | Guild 2 | Guild 3 | Guild 4 | Guild 5 | Guild 6 | Guild 7 | Guild 8 | Guild 9 | Guild 10
Daily participants |  |  | 1 | 1 | 1 | 2 | 2 | 2 | 3 | 4 | 5 | 6
Total Participants |  |  | 1 | 1 | 1 | 2 | 2 | 2 | 3 | 4 | 5 | 6
Hearts Received |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Activity points |  |  | 1 | 1 | 1 | 2 | 2 | 2 | 3 | 4 | 5 | 6
 |  |  |  |  | Type in daily participants on row 6,  and Total Participants will adjust …
 |  |  |  |  | Don’t forget to change "hearts received" number for next time!
 |  |  |  |  | Points are calculated by total participants/(hearts received+1)
Spreadsheet: 840207d1692555646-need-help-creating-a-worksheet-that-when-data-is-entered-it-auto-adds-info-example-attach-example
Sheet: Data

This Page is where we will enter the data.
Examples of Target data. That will be entered: | Tours | Volume
Level 1: 75% of Budget | 544 | 2499534
Level 2: 85% of Budget | 617 | 2832805
Level 3: Budget | 726 | 3332712
Level 4: 105% of Budget | 762 | 3499348
Level 5: 110% of Budget | 798 | 3665983
Level 6: 115% of Budget | 834 | 3832619
Level 7: 120% of Budget | 871 | 3999254
Level 8: 130 of Budget | 943 | 4332526
Example of date info:
2023-08-01 00:00:00 | 35 | 131759
Spreadsheet: john_zufferli__16719__HedgeSummary
Sheet: Sheet1

 | CONFIDENTIAL:  PPA - POWER AND GAS POSITIONS:
 |  |  |  |  |  |  |  |  | Current to | Hedgeable | Current |  | AECO
 |  |  |  |  | Power Price | Aeco Gas Price | Heat Rate | Jan 11/2001 | Beg. Year | Volume | Gas Hedges |  | Hedge
 |  | Power (MWh) | Discount Days | Power (MW) | ($/MWh) | ($[NAME]) | (GJ/MWh) | Heat Rates | HR Delta | (cont/day) | (cont/day) | % Hedged | (cont/day)
2002-01-01 00:00:00 | Cal 2002 |  |  |  |  |  |  | 14.25
2003-01-01 00:00:00 | Cal 2003 |  |  |  |  |  |  | 12.03
2004-01-01 00:00:00 | Cal 2004 |  |  |  |  |  |  | 8.9
2005-01-01 00:00:00 | Cal 2005 |  |  |  |  |  |  | 9.06
2006-01-01 00:00:00 | Cal 2006 |  |  |  |  |  |  | 7.5
2007-01-01 00:00:00 | Cal 2007 |  |  |  |  |  |  | 7.02
2008-01-01 00:00:00 | Cal 2008 |  |  |  |  |  |  | 7.09
2009-01-01 00:00:00 | Cal 2009 |  |  |  |  |  |  | 7.1
2010-01-01 00:00:00 | Cal 2010 |  |  |  |  |  |  | 7.14
2011-01-01 00:00:00 | Cal 2011 |  |  |  |  |  |  | 7.11
2012-01-01 00:00:00 | Cal 2012 |  |  |  |  |  |  | 7.08
2013-01-01 00:00:00 | Cal 2013 |  |  |  |  |  |  | 7.04
2014-01-01 00:00:00 | Cal 2014 |  |  |  |  |  |  | 7.03
2015-01-01 00:00:00 | Cal 2015 |  |  |  |  |  |  | 7
2016-01-01 00:00:00 | Cal 2016 |  |  |  |  |  |  | 7
2017-01-01 00:00:00 | Cal 2017 |  |  |  |  |  |  | 7
2018-01-01 00:00:00 | Cal 2018 |  |  |  |  |  |  | 7
2019-01-01 00:00:00 | Cal 2019 |  |  |  |  |  |  | 7
2020-01-01 00:00:00 | Cal 2020 |  |  |  |  |  |  | 7
 | Total
 | Note: Power position is 710MW * Availability factor (of 81-87%) - 9% transmission losses - hedges
Spreadsheet: 768642d1645058207-stacking-multiple-ranges-to-one-combined-range-pq-append-week
Sheet: Saturday

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7
Run | Run | Start_Time | End_Time | Day of Week | Route | Block
[NAME] | 800 | 0.15625 | 0.4895833333333333 | Saturday | 800 | 800
FT_34 | 801 | 0.15625 | 0.4895833333333333 | Saturday | 801 | 801
FT_36 | 805 | 0.3020833333333333 | 0.625 | Saturday | 805 | 805
[NAME] | 809 | 0.3125 | 0.6458333333333334 | Saturday | 809 | 809
FT_39 | 302 | 0.3125 | 0.6458333333333334 | Saturday | 302 | 302
FT_40 | 303 | 0.3125 | 0.6458333333333334 | Saturday | 303 | 303
FT_42 | 309 | 0.3958333333333333 | 0.7395833333333335 | Saturday | 309 | 309
FT_43 | 310 | 0.3958333333333333 | 0.7395833333333335 | Saturday | 310 | 310
FT_45 | 802 | 0.15625 | 0.4895833333333333 | Saturday | 802 | 802