tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 168799d1342587983-radio-buttons-radiobutton-solution
Sheet: DATA SHEET

 | Hotel 1
 |  | Revenue | Nights | ARR
 | Segment 1 | 10000 | 25 | 400
 | Segment 2 | 20000 | 35 | 500
 | Segment 3 | 30000 | 45 | 600
 | Segment 4 | 40000 | 55 | 700
 | Segment 5 | 50000 | 65 | 800
 | Segment 6 | 60000 | 75 | 900
 | Segment 7 | 70000 | 85 | 1000
 | Segment 8 | 80000 | 95 | 1100
 | Segment 9 | 90000 | 105 | 1200
 | Segment 10 | 100000 | 115 | 1300
 | Segment 11 | 110000 | 125 | 1400
 | Hotel 2
 |  | Revenue | Nights | ARR
 | Segment 1 | 1000 | 10 | 40
 | Segment 2 | 2000 | 20 | 50
 | Segment 3 | 3000 | 30 | 60
 | Segment 4 | 4000 | 40 | 70
 | Segment 5 | 5000 | 50 | 80
 | Segment 6 | 6000 | 60 | 90
 | Segment 7 | 7000 | 70 | 100
 | Segment 8 | 8000 | 80 | 110
 | Segment 9 | 9000 | 90 | 120
 | Segment 10 | 10000 | 100 | 130
 | Segment 11 | 11000 | 110 | 140
 | Hotel 3
 |  | Revenue | Nights | ARR
 | Segment 1 | 2000 | 20 | 80
 | Segment 2 | 4000 | 40 | 100
 | Segment 3 | 6000 | 60 | 120
 | Segment 4 | 8000 | 80 | 140
 | Segment 5 | 10000 | 100 | 160
 | Segment 6 | 12000 | 120 | 180
 | Segment 7 | 14000 | 140 | 200
 | Segment 8 | 16000 | 160 | 220
 | Segment 9 | 18000 | 180 | 240
 | Segment 10 | 20000 | 200 | 260
 | Segment 11 | 22000 | 220 | 280
 | Hotel 4
 |  | Revenue | Nights | ARR |  |  |  |  |  |  | 3
 | Segment 1 | 1000 | 10 | 40
 | Segment 2 | 2000 | 20 | 50
 | Segment 3 | 3000 | 30 | 60
 | Segment 4 | 4000 | 40 | 70
 | Segment 5 | 5000 | 50 | 80
 | Segment 6 | 6000 | 60 | 90
 | Segment 7 | 7000 | 70 | 100
 | Segment 8 | 8000 | 80 | 110
 | Segment 9 | 9000 | 90 | 120
 | Segment 10 | 10000 | 100 | 130
 | Segment 11 | 11000 | 110 | 140
 | Hotel 5
 |  | Revenue | Nights | ARR
 | Segment 1 | 3000 | 30 | 120
 | Segment 2 | 6000 | 60 | 150
 | Segment 3 | 9000 | 90 | 180
 | Segment 4 | 12000 | 120 | 210
 | Segment 5 | 15000 | 150 | 240
 | Segment 6 | 18000 | 180 | 270
 | Segment 7 | 21000 | 210 | 300
 | Segment 8 | 24000 | 240 | 330
 | Segment 9 | 27000 | 270 | 360
 | Segment 10 | 30000 | 300 | 390
 | Segment 11 | 33000 | 330 | 420
Spreadsheet: 56368d1256567490-if-function-deeper-than-8-nested-levels-indicator
Sheet: Sheet1

 |  |  |  |  |  | a
 |  |  |  |  |  | b
 |  |  |  |  |  | c
 |  | Unit:
 |  | Level 3 | Level 4 | Level 5 | Level 6 | Level 7
 |  | 0 | They combine and refine different forms of information from various sources. | They use ICT to structure, refine and present information in different forms and styles for specific purposes and audiences. | They plan and design ICT-based solutions to meet a specific purpose and audience, demonstrating increased integration and efficiency in their use of ICT tools. | 0 |  | effort | BFL/Warnings | detention(auto) | HWK |  | highest level achieved int THIS lesson | HWK score
 |  | eg: tell me | eg:show me | eg: show bias etc on PC | eg:>1 w/s shown | eg: write/tell and choice made
 |  | a | a |  | a | a |  | 3 |  |  |  |  | 5c | 0 | should read '4a'
 |  | a | a | a | c | a |  |  |  |  |  |  | 6c | 0 | should be '5a'
 |  | a | a |  | a | a |  | 3 |  |  |  |  | 5c | 0
 |  | a | a | a | a | a |  | 3 |  |  |  |  | 7a | 0
 |  | a | c | a | a | a |  | 3 |  |  |  |  | 4c | 0 | should read '4c'
 |  | a |  | a | a | a |  | 3 | 1 |  |  |  | 4c | 0 | should read '3a'
 |  | a |  | a | a | a |  | 3 |  |  |  |  | 4c | 0
Spreadsheet: eric_saibi__9834__100201
Sheet: Mill Creek 04

Owner Name | Louisville Gas and Electric Company
Station Name | Mill Creek Power Station
Unit Name | [NAME] 04
NERC Region | ECAR
State | KY
Fuel Type | Coal
Capacity | 544 MW
Start Date | 2001-09-28 00:00:00
End Date | 2001-09-28 00:00:00
Comments | Unit Tripped for 90 minutes
SIC | 4911
Plant ID | 1013423
Unit ID | 1007010
Outage ID | 18563
Spreadsheet: 583809d1532667825-polleat-the-list-one-or-more-sheets-get-list-report-sheet-in-excel-formula-dsr-new
Sheet: thoothukudi

S.No | Date | Name | BRANCH OFFICE | CLIENT NAME | PAX NAME | CLIENT TYPE | BOOKED BY | MODE OF BOOKING | SERVICE | DESTINATION | LCC OR FSC | CRS | YY | NO OF SEGMENTS | PNR/TKT NO | STOCK | PLB | [NAME] | TOTAL AMOUNT | CREDIT AMOUNT | TF AMOUNT | SERVICE TAX | REMARKS
 | 2018-07-24 00:00:00 | JKL | thoothukudi | KDFJA | JKDS | KDJFS | KDJS | [NAME] | [NAME] | [NAME] | JDFKJA | KJDAK | [NAME] | JDAK | KJDSFK | [NAME] | [NAME] | KDJSA | 10000
Spreadsheet: 374097d1422652460-need-help-combining-table-data-from-a-range-of-worksheets-to-a-separate-worksheet-orientation-roster
Sheet: ORIGINAL (14)

 |  | Last Name | First Name | LAST FOUR DIGITS OF SOCIAL SECURITY NUMBER | PHONE NUMBER | BACKGROUND CHECK STATUS | COMPONENT NUMBER | POSITION HIRED FOR | [NAME]
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Spreadsheet: darrell_schoolcraft__7798__Southpoint Gas Model
Sheet: Sheet1

Southpoint |  |  | Transwestern's 24 hr Gas Control [PHONE]
 |  |  | Gas Nomination for 31st = 80,000
 |  |  | SoCal Gas Price |  | 3.655
 |  |  | San Juan Gas Price |  | 2.78
 |  |  | Unit 1 | Unit 2 | Steam TurB | Total MW | HR | Total Gas Usage
he 6 | 07:00:00 |  | 0 | 0 | 0 | 234 | 7
he 7 | 08:00:00 |  | 0 | 0 | 0 | 482 | 7
he8 | 09:00:00 |  | 0 | 0 | 0 | 482 | 7
he9 | 10:00:00 |  | 0 | 0 | 0 | 482 | 7
he10 | 11:00:00 |  | 0 | 0 | 0 | 482 | 7
he11 | 12:00:00 |  | 0 | 0 | 0 | 482 | 7
he12 | 13:00:00 |  | 0 | 0 | 0 | 482 | 7
[NAME] | 14:00:00 |  | 0 | 0 | 0 | 482 | 7
he14 | 15:00:00 |  | 0 | 0 | 0 | 482 | 7
he15 | 16:00:00 |  | 0 | 0 | 0 | 482 | 7
he16 | 17:00:00 |  | 0 | 0 | 0 | 482 | 7
he17 | 18:00:00 |  | 0 | 0 | 0 | 482 | 7
he18 | 19:00:00 |  | 0 | 0 | 0 | 482 | 7
he19 | 20:00:00 |  | 0 | 0 | 0 | 482 | 7
he20 | 21:00:00 |  | 0 | 0 | 0 | 482 | 7
he21 | 22:00:00 |  | 0 | 0 | 0 | 482 | 7
he22 | 00:00:00 |  | 0 | 0 | 0 | 482 | 7
he23 | 01:00:00 |  | 0 | 0 | 0 | 234 | 7
he24 | 02:00:00 |  | 0 | 0 | 0 | 234 | 7
he1 | 03:00:00 |  | 0 | 0 | 0 | 234 | 7
he2 | 04:00:00 |  | 0 | 0 | 0 | 234 | 7
he3 | 05:00:00 |  | 0 | 0 | 0 | 234 | 7
he4 | 06:00:00 |  | 0 | 0 | 0 | 234 | 7
[NAME] | 07:00:00 |  | 0 | 0 | 0 | 234 | 7
Spreadsheet: 783491d1654866055-summarize-and-total-data-from-another-sheet-sample-excel-1-
Sheet: Project Estimate

Video Phase |  |  | PDF Phase |  |  | Webpage Phase |  |  | Event Phase
Stage / Description | Hours |  | Stage / Description | Hours |  | Stage / Description | Hours |  | Stage / Description | Hours
Video Phase |  |  | PDF Phase |  |  | Webpage Phase |  |  | Event Phase
Copy Editing |  |  | Creative Design |  |  | Copywriting |  |  | Copywriting
- Copywriting | 16 |  | - Creative Senior -Art Direction | 12 |  | - Creative Director - Concepts | 2 |  | - Creative Director - Concepts
Creative Design |  |  | - Creative Director - Concepts | 2 |  | - Copywriter Senior |  |  | - Copywriter Senior
- Creative Senior -Art Direction | 20 |  | - Production Manager | 1 |  | INK Copywriting for Webpage |  |  | Copy Editing
- Creative Director - Concepts | 2 |  | Design Development |  |  | Copy Editing |  |  | - Copywriter Senior
- Production Manager | 1 |  | - Creative Mid - Design & Amends | 8 |  | - Copywriter Senior | 4 |  | Creative Design
Design Development |  |  | Artwork |  |  | Creative Design |  |  | - Creative Senior -Art Direction | 16
- Creative Mid - Design & Amends | 16 |  | - Creative Artworker | 8 |  | - Creative Senior -Art Direction |  |  | - Creative Senior -Art Direction
Artwork |  |  | Project Management |  |  | - Creative Director - Concepts |  |  | - Creative Director - Concepts | 2
- Creative Artworker | 12 |  | - Account Director | 4 |  | - Creative Director - Concepts |  |  | Design Development
- Production Manager | 1 |  | - Project Manager Senior | 8 |  | Design Development |  |  | - Creative Mid - Design & Amends | 8
Project Management |  |  |  |  |  | - Creative Mid - Design & Amends |  |  | Artwork
- Account Director | 7 |  |  |  |  | Artwork |  |  | - Creative Artworker
- Project Manager Senior | 13 |  |  |  |  | - Creative Artworker | 4 |  | Project Management
 |  |  |  |  |  | Project Management |  |  | - Account Director
 |  |  |  |  |  | - Account Director | 4 |  | - Project Manager Senior | 1.5
 |  |  |  |  |  | - Group Account Director
 |  |  |  |  |  | - Project Manager Senior | 7.5
Spreadsheet: 153471d1335928068-data-as-per-choosing-the-options-excel-data
Sheet: Sheet1

S.No. | Category | Branch Code | Branch | SB | CDCC | TERM DEPOSITS | TOTAL DEPOSITS | ADVANCES | BUSINESS MIX
1 | Rural | 1120 | Dubbak | 263.4 | 9.03 | 431.12 | 703.55 | 808.4 | 1511.95
2 | Rural | 920 | Ingurthy | 159.52 | 5.35 | 125.67 | 290.54 | 903.46 | 1194
3 | Rural | 1275 | [NAME] | 2798.85 | 467.96 | 5230.86 | 8497.67 | 1423.72 | 9921.39
4 | Rural | 862 | Kothalabad | 308.47 | 48.51 | 441.31 | 798.29 | 1923.7 | 2721.99
5 | Rural | 878 | [NAME] | 217.96 | 32.6 | 208 | 458.56 | 1166.98 | 1625.54
6 | Rural | 711 | Lingampet | 548.58 | 13.84 | 326.26 | 888.68 | 2010.57 | 2899.25
7 | Rural | 460 | Nandipet | 589.5 | 109.47 | 643.66 | 1342.63 | 1520.3 | 2862.93
8 | Rural | 712 | Parvathagiri | 405.17 | 34.89 | 506.28 | 946.34 | 1129.92 | 2076.26
9 | Rural | 960 | Vangoor | 365.39 | 16.24 | 277 | 658.63 | 1589.11 | 2247.74
10 | Rural | 861 | Veepanagandla | 234.63 | 25.29 | 281.26 | 541.18 | 2299.19 | 2840.37
11 | Rural | 717 | Yellareddypet | 1912.88 | 129.01 | 1275.17 | 3317.06 | 3061.81 | 6378.87
12 | S U | 623 | Alwal | 2364.74 | 560.25 | 4037.21 | 6962.2 | 9692.85 | 16655.05
13 | S U | 404 | Armoor | 605.83 | 22.13 | 1082.92 | 1710.88 | 778.22 | 2489.1
 |  |  | TOTAL
Spreadsheet: 156587d1337353667-displaying-values-after-multiple-drop-down-box-selection-dropdown-example
Sheet: Sheet1

REP | Company | Stage
Smith | WorldWide Corp | Pre-Presentation
Jones | AmeriCorp | 1st Presentation Complete
Ferguson | Innetech | Contract Presented
Black | Innetrode | Pre-Presentation
Jones | DM Company | Contract Presented
Jones | Perfect Products | Contract Presented
Ferguson | Sample A | 1st Presentation Complete
Black | Sample B | Contract Presented
Black | Sample C | 1st Presentation Complete
Smith | Company 1 | Contract Presented
Jones | Famous Company | 1st Presentation Complete
Ferguson | Best Company | Contract Presented
Black | Worst Company | Pre-Presentation
Smith | City Corp | Pre-Presentation
Ferguson | [NAME] | Pre-Presentation
Spreadsheet: 57177d1257333551-comparing-grades-text-to-give-a-numerical-score-blank-award-system
Sheet: Data

Surname Forename | Registration Group | Gender | Predicted [NAME] 1 | Actual Grade Subject 1 | Subject Points | Predicted Grade Subject 2 | Actual Grade Subject 2 | Subject Points | Predicted Grade Subject 2 | Actual Grade Subject 2 | Subject Points | Predicted Grade Subject 3 | Actual Grade Subject 3 | Subject Points | Predicted Grade Subject 3 | Actual Grade Subject 3 | Subject Points | Predicted [NAME] 4 | Actual [NAME] 4 | Subject Points | Predicted [NAME] 4 | Actual [NAME] 4 | Subject Points | Predicted Grade Subject 5 | Actual Grade Subject 5 | Subject Points | Predicted Grade Subject 5 | Actual Grade Subject 5 | Subject Points | Predicted [NAME] 6 | Actual [NAME] 6 | Subject Points | Predicted [NAME] 6 | Actual [NAME] 6 | Subject Points | Predicted [NAME] 7 | Actual [NAME] 7 | Subject Points | Predicted [NAME] 7 | Actual [NAME] 7 | Subject Points | Predicted Grade Subject 8 | Actual Grade Subject 8 | Subject Points | Predicted Grade Subject 8 | Actual Grade Subject 8 | Subject Points | Predicted [NAME] 9 | Actual [NAME] 9 | Subject Points | Predicted [NAME] 9 | Actual [NAME] 9 | Subject Points | Predicted [NAME] 10 | Actual [NAME] 10 | Subject Points | Predicted [NAME] 10 | Actual [NAME] 10 | Subject Points | Predicted [NAME] 11 | Actual [NAME] 11 | Subject Points | Predicted [NAME] 11 | Actual [NAME] 11 | Subject Points | Predicted [NAME] 12 | Actual [NAME] 12 | Subject Points | Predicted [NAME] 12 | Actual [NAME] 12 | Subject Points | Predicted [NAME] 13 | Actual [NAME] 13 | Subject Points | Predicted [NAME] 13 | Actual [NAME] 13 | Subject Points | Total Points
Pupil 1 |  |  | D | C |  | D | C |  | D | D |  | D | D |  |  |  |  |  |  |  | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E | D |  | D | C |  |  |  |  | E | C |  |  |  |  |  |  |  | C
Pupil 2 |  |  | D | D |  | D | U |  | D | E |  | D | D |  |  |  |  |  |  |  | D |  |  |  |  |  |  |  |  | D | E |  |  |  |  |  |  |  |  |  |  | D | C |  | D |  |  | E | D |  |  |  |  |  |  |  |  |  |  | D
Spreadsheet: 128331d1320919199-cell-formula-to-record-many-values-and-date-entered-tank-maintenance
Sheet: Sheet1

 |  | PH | Ammonia (ppm) | Nitrate
 | Tank 1 | 6 | 0 | 30
 | Tank 2 | 6.5 | 2 | 60
 | Tank 3 | 6 | 3 | 30
 | Tank 4 | 5.5 | 0 | 40 |  |  |  | These are the numbers that people will enter.
 | Tank 5 | 8 | 1 | 30 |  |  |  | However, ideally the cells want to be left blank so that a new student can
 | Tank 6 | 8 | 0 | 50 |  |  |  | enter values into a blank square…like the table below, along with an 'enter' button to enter the value into the database to be recorded.
 | Tank 7 | 7 | 2 | 60 |  |  |  | If possible record the values onto 'Sheet 2' with the dates that they were entered. I've done a quick example of this on sheet 2.
 | Tank 8 | 6.5 | 0 | 20 |  |  |  | The idea being that people can look at the values over a period of time and see how the levels are changing.
 | Tank 9 | 8 | 0 | 30 |  |  |  | It would have to work so that the value that was entered into the system is recorded on sheet 2 automatically.
 | Tank 10 | 6 | 0 | 40 |  |  |  | Thank You for the help, it's very much appreciated!!
 | Tank 11 | 7 | 2 | 60
 | Tank 12 | 7 | 0 | 30
 | Tank 13 | 8 | 3 | 40
 | Tank 14 | 6 | 1 | 30
 | Tank 15 | 7 | 0 | 40
 |  | PH | Ammonia (ppm) | Nitrate
 | Tank 1
 | Tank 2
 | Tank 3
 | Tank 4
 | Tank 5
 | Tank 6
 | Tank 7
 | Tank 8
 | Tank 9
 | Tank 10
 | Tank 11
 | Tank 12
 | Tank 13
 | Tank 14
 | Tank 15
Spreadsheet: 846538d1697711515-cross-checking-between-two-lists-excel-forum
Sheet: Sheet1

First List | Second List | [NAME] downwards
XXL-S-M-L-XL | XXL-M-L-XL-3XL | True
XXL | XXL-XL | True
3XL | 4XL-3XL-S-M-L-XL-XXL | True
XXL-S-M-L-XL | S-M-L-XL | True
XL | XXL-S-M-XL | True
XXL-S-XL-3XL | XXL-S-M-L-XL-3XL-4XL | True
XXL-S-M-L-XL | S-M-XL | True
XXL | XXL-3XL-S-M-L-XL | True
XXL-3XL-S-M-L-XL | S-XL | True
XL | S-XL | True
S-XL | XL | True
XXL-3XL-S-M-L-XL | XXL-3XL-S-M-L-XL | True
XXL-XL | XXL | True
S-M-L-XL | XXL-S-M-L-XL | True
S-M-XL | [NAME] | True
XL | XXL-S-M-L-XL | True
XXL | S | False
XXL-XL | XXL-3XL | True
XXL-S-M-L-XL | XXL-XL-S-M-L | True
XXL | XXL-S-M-L-XL-3XL-4XL | True
XXL-S-M-L-XL | XXL-S-3XL | True
XXL-S-M-L-XL | XXL-S-M-L-XL-3XL-4XL | True
XXL-S-M-L-XL | XXL-S-M-L-XL-3XL-4XL | True
XXL-S-XL | XXL-S-M-L-XL-3XL-4XL | True
S | XXL-3XL-S-M-L-XL | True
S-XL | XXL-S-M-L-XL-3XL-4XL | True
XXL-S-M-XL | XXL-S-M-L-XL-3XL-4XL | True
XXL-M | S-XL | False
XXL-S-M-L-XL-3XL-4XL | XXL-S-XL | True
XXL-S-XL-4XL | XL-XXL | True
XXL-S | S-M-L-XL-XXL-3XL | True
XXL-S-XL-3XL-4XL | S-XL | True
XXL-S-3XL-4XL | S | True
XXL-S-M-L-XL | XXL-S-M-XL | True
S | S-M-L-XL-XXL-3XL | True
XXL-S-M-XL | S-M-XL | True
S | XXL-S-M-XL | True
S | S-M-XL | True
S | XXL-S | True
XXL-XL-3XL-4XL | XXL-S-XL | True
S-L | XXL-XL | False
Spreadsheet: 141326d1329221203-can-only-select-a-drop-down-option-once-last_man_standing
Sheet: Sheet1

Name | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 |  |  |  |  |  |  |  |  |  |  |  |  | Arsenal
[NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] m | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] | Fulham |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chelseaa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Evertona
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fulham
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Liverpool
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Manchester City
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Newcastle United
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Norwich City
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Queens Park Rangers
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stoke City
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sunderland
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Swansea City
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | West Bromwich Albion
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wigan Athletic
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 676047d1588620992-double-dependent-drop-down-blank-cells-drop-down-from-2-inidices-of-table-matrix-va-graves1907-
Sheet: Lookups-Master

 |  |  | Category | BMcD | Client | BMcD LT | This section to the left is located on a separate sheet from the drop downs | The actual sheet is 500 - 1000 lines long for this section as well as the green and yellow below. | People will add data to this table periodically and those changes need to appear on the data validation (I.E. new "Categories", different name options, new columns, etc.)
 |  |  | Dev | [NAME] | [NAME] | [NAME]
 |  |  | Dev | [NAME] | [NAME] | [NAME]
 |  |  | Dev | Darrin | Darrin
 |  |  | Dev | Neel
 |  |  | Dev | Greg
 |  |  | Mis | Greg | Greg | Greg
 |  |  | Mis
 |  |  | Mis | [NAME] | [NAME] | [NAME]
 |  |  | Mis |  | [NAME] | [NAME]
 |  |  | Mis |  | Neel | Neel
 |  |  | Fin | Neel | Neel | Neel
 |  |  | Fin | [NAME] | [NAME] | [NAME]
 |  |  | Fin |  |  | Darrin
 |  |  |  |  |  | Drop-Down continent on 2 Drop-Down Selections at left in green cells
 |  | Drop-Down | Mis | BMcD LT |  | Greg
 |  |  | Dev | Client |  | Fin-BMcD2
 |  |  | Cleaned up list from index rows for building drop-down | Cleaned up list from table headers for building drop-down
Spreadsheet: 76845d1277320950-counting-categories-and-summing-points-categories-weights
Sheet: Sheet1

Categories | Keywords | Points
category1 | KW1 | 15
category1 | KW2 | 12
category2 | KW3 | 10
category3 | KW4 | 9
category2 | KW5 | 8
category4 | KW6 | 5
category5 | KW7 | 5
category1 | KW8 | 5
category3 | KW9 | 3
category5 | KW10 | 2
category1 | KW11 | 1
Spreadsheet: 187913d1350627585-copy-every-second-cell-in-a-colomn-copy-every-2nd-value
Sheet: Sheet1

1
2
3
4
5
6
7
8
9
10
Spreadsheet: darrell_schoolcraft__7324__imball0202
Sheet: NGPL

 | 52862 |  | 6828 |  | 6838
 | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Imbalance
1 | 38753 | 38839 |  | -1752 | 27848 | 23815
2 | 40637 | 40684 |  |  | 27871 | 25215
3 | 40652 | 40676 |  |  | 28102 | 25164
4 | 40650 | 40684 |  |  | 27824 | 25215 |  |  |  | Winkler/Eddy OBA |  |  |  |  |  |  | Gray  OBA
5 | 37651 | 37644 |  |  | 24510 | 24952
6 | 37652 | 37684 |  |  | 26762 | 25198 |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount |  | Month | Measured | Scheduled | Imbalance | Index | Amount
7 | 37653 | 37684 |  |  | 26569 | 25217
8 | 39631 | 39684 |  |  | 21066 | 25215 |  |  |  | 2001-05-01 00:00:00 | 1103057 | 1120793 |  | 4.01 |  |  | 2001-05-01 00:00:00 | -202726 | -185000 |  | 4.01 |  |  | 2001-05-01 00:00:00 | 4.01
9 | 45455 | 45458 |  |  | 24054 | 23449 |  |  |  | 2001-06-01 00:00:00 |  | 1681871 |  | 3.51 |  |  | 2001-06-01 00:00:00 | -153623 | -88473 |  | 3.51 |  |  | 2001-06-01 00:00:00 | 3.51
10 | 45361 | 45458 |  |  | 23079 | 23449 |  |  |  | 2001-07-01 00:00:00 |  | 1270571 |  | 2.94 |  |  | 2001-08-01 00:00:00 | -34269 | -27046 |  | 2.85 |  |  | 2001-07-01 00:00:00 | 2.94
11 | 45428 | 45458 |  |  | 27403 | 19517 |  |  |  | 2001-08-01 00:00:00 |  | 1418897 |  | 2.85 |  |  | 2001-09-01 00:00:00 | -1191628 | -1210937 |  | 1.96 |  |  | 2001-08-01 00:00:00 | 2.85
12 | 45768 | 37497 |  |  | 14699 | 23449 |  |  |  | 2001-09-01 00:00:00 | 1109912 | 1111335 |  | 1.96 |  |  |  |  |  |  |  |  |  | 2001-09-01 00:00:00 | 1.96
13 | 33659 | 33643 |  |  | 29075 | 28943
14 | 33891 | 33684 |  |  | 28918 | 28943 |  |  |  | 5/01 - 9/01  balance |  |  |  |  |  |  | 5/01 - 9/01  balance
15 | 33682 | 33684 | -3456 | -10000 | 28439 | 28452
16 | 33687 | 33684 |  | -4795 | 28439 | 28452 |  |  |  | Volume balance @ 4/30/01 |  |  | 19880 |  |  |  | Volume balance @ 4/30/01 |  |  | 37185
17 | 33681 | 33684 |  | -5000 | 28436 | 28452
18 | 33667 | 33684 |  | -4813 | 28416 | 28452
19 | 33680 | 33684 |  | -5000 | 28419 | 28452
20 | 50293 | 50450 |  | -5000 | 28415 | 28452
21
22
23
24
25
26
27
28
29
30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10000 | 2
31 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -10000 | 1.5
2002-01-31 00:00:00
2002-02-20 00:00:00
CBS Dollars
 |  |  |  |  | 338741
Spreadsheet: 6f8c0665-f41c-4656-8ac5-8a9ff82ad21e
Sheet: Instructions fr

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Français
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
1
2
3
 | Please select…
 | Please select…
 | Please select…
1
2
3
4
5
6
 |  | 1
 |  |  |  |  |  | N | % |  |  |  |  | N | % | N | % | N | %
 |  |  |  |  |  | D |  |  |  |  |  | D |  | D |  | D
 |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  | 0
Please select…
Please select…