tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 207850d1358581749-how-to-get-values-via-data-validation-tool-list-from-one-sheet-to-another-copy-of-electrical-parts
Sheet: daily sheet

 |  | SPARE PART REQUISITION EVERYDAY
 | MACHINE TYPE |  |  | MACHINE NUMBER
 | BAAN NO | [NAME] | PART NUMBER | QTY IN STOCK | [NAME] | ISSUED QTY | DATE | BALANCE QTY | REQUEST BY | APPROVED BY
 | 0110-03240 | [NAME] | WT160-F480   /  6022822 | 1 | [NAME] | 1 |  | 0
 | 0110-03240 | [NAME] | WT160-F480   /  6022822 | 1 | [NAME] | 5 |  | -4
Spreadsheet: 75974d1276565944-picking-numbers-from-a-list-spacer-solver
Sheet: Sheet1

Strand 1 |  |  | Strand 2 |  |  | Strand 3 |  |  | Strand 4 |  |  | Strand 4 |  |  | Strand 5
Target Value | 152.4 |  | Target Value | 80 |  | Target Value | 100 |  | Target Value | 100 |  | Target Value | 100 |  | Target Value | 300
Values | Use? |  | Values | Use? |  | Values | Use? |  | Values | Use? |  | Values | Use? |  | Values | Use?
76.2 | 1 |  | 76.2 | 1 |  | 76.2 | 1 |  | 76.2 | 1 |  | 76.2 | 1 |  | 76.2 | 1
76.2 | 1 |  | 76.2 | 1 |  | 76.2 | 1 |  | 76.2 | 1 |  | 76.2 | 1 |  | 76.2 | 1
76.2 | 1 |  | 76.2 | 1 |  | 76.2 | 1 |  | 76.2 | 1 |  | 76.2 | 1 |  | 76.2 | 1
75.95 | 1 |  | 75.95 | 1 |  | 75.95 | 1 |  | 75.95 | 1 |  | 75.95 | 1 |  | 75.95 | 1
50.8 | 0 |  | 50.8 | 1 |  | 50.8 | 1 |  | 50.8 | 1 |  | 50.8 | 1 |  | 50.8 | 1
50.8 | 0 |  | 50.8 | 1 |  | 50.8 | 1 |  | 50.8 | 1 |  | 50.8 | 1 |  | 50.8 | 1
50.8 | 0 |  | 50.8 | 1 |  | 50.8 | 1 |  | 50.8 | 1 |  | 50.8 | 1 |  | 50.8 | 1
50.55 | 0 |  | 50.55 | 0 |  | 50.55 | 0 |  | 50.55 | 0 |  | 50.55 | 0 |  | 50.55 | 0
25.15 | 0 |  | 25.15 | 1 |  | 25.15 | 1 |  | 25.15 | 1 |  | 25.15 | 1 |  | 25.15 | 1
25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 0
25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 0
25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 0
25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 0 |  | 25.15 | 0
18.8 | 0 |  | 18.8 | 0 |  | 18.8 | 0 |  | 18.8 | 0 |  | 18.8 | 0 |  | 18.8 | 0
12.45 | 1 |  | 12.45 | 1 |  | 12.45 | 1 |  | 12.45 | 1 |  | 12.45 | 1 |  | 12.45 | 1
12.45 | 0 |  | 12.45 | 0 |  | 12.45 | 0 |  | 12.45 | 0 |  | 12.45 | 0 |  | 12.45 | 0
6.1 | 0 |  | 6.1 | 0 |  | 6.1 | 0 |  | 6.1 | 0 |  | 6.1 | 0 |  | 6.1 | 0
2.9 | 1 |  | 2.9 | 1 |  | 2.9 | 1 |  | 2.9 | 1 |  | 2.9 | 1 |  | 2.9 | 1
2 | 1 |  | 2 | 1 |  | 2 | 1 |  | 2 | 1 |  | 2 | 1 |  | 2 | 1
1 | 1 |  | 1 | 1 |  | 1 | 1 |  | 1 | 1 |  | 1 | 1 |  | 1 | 1
Total Width | 1220 |  | Total | 1220 |  | Total | 1220 |  | Total | 1220 |  | Total | 1220 |  | Total | 1220
[NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME]
Spacers
Spreadsheet: 162439d1339876877-search-multiple-spreadsheets-d-report-log-2012-2
Sheet: September 2012

NHSP-W DISCIPLINARY REPORT LOG
D-Report Number | Date | Inmate | Reporting Staff | Violation(s) |  |  |  |  | Date of Disposition | Date of Hearings | Outcome | Sanctions (in days) |  |  |  |  |  |  |  |  |  |  |  | Notes
 |  |  |  |  |  |  |  |  |  |  | PG, FWOP, BS, Inc, FG, FNG | P/S | [NAME] | XD | Lost Cant | Lost Rec | Lost Radio | Lost TV | Lost Phone | Lost Radio | Good Time | Lost Visit | Restitution
09-01
09-02
09-03
09-04
09-05
09-06
09-07
09-08
09-09
09-10
09-11
09-12
09-13
09-14
09-15
09-16
09-17
09-18
09-19
09-20
09-21
09-22
09-23
09-24
09-25
09-26
09-27
09-28
09-29
09-30
09-31
09-32
09-33
09-34
09-35
09-36
09-37
09-38
09-39
09-40
09-41
09-42
09-43
09-44
09-45
09-46
09-47
09-48
09-49
09-50
09-51
09-52
09-53
09-54
09-55
09-56
09-57
09-58
09-59
09-60
09-61
09-62
09-63
09-64
09-65
09-66
09-67
09-68
09-69
09-70
09-71
09-72
09-73
09-74
09-75
09-76
09-77
09-78
09-79
09-80
09-81
09-82
09-83
09-84
09-85
09-86
09-87
09-88
09-89
09-90
09-91
09-92
09-93
09-94
09-95
09-96
09-97
09-98
09-99
Spreadsheet: 51754d1251372536-index-and-match-697337_hoshyar
Sheet: Sheet2

Modell | Cuba
type | Soffa
 |  | Values
supplier | Color | Sum of size | Sum of Price
RGE | yellow | 130 | 120
rowico | red | 120 | 150
Top line | yellow | 100 | 130
Grand Total |  | 350 | 400
Spreadsheet: 717952d1612908952-vlookup-and-averages-on-different-tab-vlookup-example
Sheet: 2021 tickets

Total Days Open | Status | EDG RPS Issue Type
18 | Completed | Data Verification
0 | Completed | ETA
1 | Completed | ETA
1 | Completed | ETA
1 | Completed | ETA
1 | Completed | Offense/Disposition Update
5 | Completed | Offense/Disposition Update
24 | Assigned | Data Verification
7 | Completed | Data Verification
0 | Completed | ETA
1 | Completed | ETA
0 | Completed | ETA
23 | Completed | ETA
3 | Completed | Offense/Disposition Update
11 | Completed | SOR Image
22 | Assigned | Data Verification
2 | Completed | Mis-categorization
3 | Completed | Offense/Disposition Update
5 | Completed | Suppression
5 | Completed | Suppression
3 | Completed | Mis-categorization
3 | Completed | Suppression
1 | Completed | ETA
1 | Completed | ETA
1 | Completed | ETA
1 | Completed | ETA
1 | Completed | ETA
2 | Completed | Offense/Disposition Update
16 | Completed | Data Verification
9 | Completed | Offense/Disposition Update
0 | Completed | ETA
5 | Completed | ETA
2 | Completed | Suppression
2 | Completed | ETA
2 | Completed | Suppression
14 | Working | Data Verification
1 | Completed | ETA
2 | Completed | ETA
1 | Completed | ETA
1 | Completed | ETA
0 | Completed | ETA
1 | Completed | Offense/Disposition Update
4 | Completed | Suppression
0 | Completed | ETA
1 | Completed | Data Verification
0 | Completed | ETA
0 | Completed | ETA
3 | Completed | Mis-categorization
2 | Completed | Mis-categorization
10 | Completed | Mis-categorization
3 | Completed | Offense/Disposition Update
9 | Assigned | Data Verification
0 | Completed | ETA
0 | Completed | ETA
1 | Completed | ETA
1 | Completed | ETA
2 | Completed | Offense/Disposition Update
7 | Assigned | Data Verification
1 | Completed | ETA
0 | Completed | Mis-categorization
1 | Completed | ETA
2 | Completed | ETA
2 | Completed | ETA
3 | Completed | Suppression
3 | Completed | Offense/Disposition Update
3 | Completed | Offense/Disposition Update
2 | Completed | ETA
3 | Completed | ETA
1 | Completed | ETA
3 | Assigned | Criminal Research
0 | Completed | ETA
0 | Completed | ETA
1 | Completed | ETA
0 | Completed | ETA
0 | Completed | ETA
0 | Completed | ETA
2 | Completed | Suppression
2 | Completed | Suppression
1 | Completed
2 | Assigned
1 | Completed | ETA
1 | Completed | ETA
1 | Completed | ETA
1 | Completed | ETA
2 | Assigned | ETA
0 | Completed | ETA
2 | Assigned | ETA
2 | Assigned | ETA
1 | Assigned | ETA
1 | Assigned | ETA
1 | Assigned | ETA
1 | New | ETA
1 |  | ETA
1 |  | ETA
0 | New
Spreadsheet: 486303d1477411417-22-people-randomized-into-4-groups-excel-forum-example
Sheet: students

 | [NAME]
 | student2
 | student3
 | student4
 | [NAME]
 | student6
 | student7
 | student8
 | student9
 | student10
 | student11
 | student12
 | student13
 | student14
 | student15
 | student16
 | student17
 | student18
 | student19
 | student20
 | student21
 | student22
 | group 1 | group 2 | group 3 | group 4
Spreadsheet: 648431d1573046790-sorting-hierarchical-excel-table-keeping-certain-rows-groups-intact-hierarchical-sort-example-jcarwsc-
Sheet: Sheet1

[NAME] | Zone | Sub Zone | Consumption | Cluster | Zone | Sub Zone | Cluster Rnk | Zone Rnk | Sub Zone Rnk |  |  |  |  |  |  |  |  |  |  |  |  |  | Results:: | [NAME] | Zone | Sub Zone | Consumption
Cluster A |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cluster B |  |  | 14
 | Zone A1 |  | 10.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Zone B3 |  | 16
 | Zone A1 | SubZone A1.1 | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Zone B2 |  | 15
 | Zone A1 | SubZone A1.2 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Zone B1 |  | 11.5
 | [NAME] |  | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SubZone B1.1 | 14
 | [NAME] |  | 9.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SubZone B1.1 | 10
Cluster B |  |  | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cluster C |  |  | 12
 | Zone B1 |  | 11.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Zone C2 |  | 15
 | Zone B1 | SubZone B1.1 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 13
 | Zone B1 | SubZone B1.2 | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Zone C1 |  | 11
 | Zone B2 |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SubZone c1.1 | 11.5
 | Zone B3 |  | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SubZone C1.1 | 8
Cluster C |  |  | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cluster A |  |  | 10
 | Zone C1 |  | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Zone A1 |  | 10.5
 | Zone C1 | SubZone c1.1 | 11.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SubZone A1.1 | 12
 | Zone C1 | SubZone c1.2 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SubZone A1.1 | 7
 | Zone C2 |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 9.5
 | [NAME] |  | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 9
Spreadsheet: 191291d1352047563-loan-repayment-formula-repayments
Sheet: AnotherSheet

 |  | Yes
 | Six Month Grace Period
Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18
Principal | #N/A | #N/A | #N/A | #N/A | 40 | 50 | 60 | 70 | 80 | 90 | 100 | 110 | 120 | 130 | 140 | 150 | #N/A | #N/A
Spreadsheet: 683484d1592760049-count-and-lookup-help-for-a-leaderboard-scrabble-data
Sheet: Leaderboard

Name | Played | Points
[NAME] |  |  | Played Week 1 and scored 3
[NAME]
Bec
Cara
[NAME]
[NAME]
Debbie |  |  | [NAME]
Gemma P |  |  | Debbie
Gemma S |  |  | Gemma P
G |  |  | Gemma S
Georgina |  |  | G
Heather |  |  | Heather
[NAME]
[NAME]
[NAME]
Jon
[NAME] |  |  | Didn’t play week 1 but has in week 2
[NAME]
Julie B & Louise |  |  | Didn’t play week 1 so should be zero, will play in week 2
[NAME]
[NAME]
L & D |  |  | Scored 2 in week 1
[NAME]
[NAME]
Mandi
Mandy
[NAME]
[NAME]
Nicki
[NAME]
Roberta
Sandra
Stephen |  |  | How do I add his points for week 2
Sue
[NAME]
[NAME]
Spreadsheet: benjamin_rogers__935__PJM DAILY NEW
Sheet: Hourly_Demand

 | HE 1 | HE 2 | HE 3 | HE 4 | HE 5 | HE 6 | HE 7 | HE 8 | HE 9 | HE 10 | HE 11 | HE 12 | HE 13 | HE 14 | HE 15 | HE 16 | HE 17 | HE 18 | HE 19 | HE 20 | HE 21 | HE 22 | HE 23 | HE 24
Interchange
Nuke
Coal
Hydro
Gas - ST/CC/CS/CH
Gas - GT/CT/IC/JE
Oil-Fo6
Oil-Fo2 & Fo1
Other
 | HE 1 | HE 2 | HE 3 | HE 4 | HE 5 | HE 6 | HE 7 | HE 8 | HE 9 | HE 10 | HE 11 | HE 12 | HE 13 | HE 14 | HE 15 | HE 16 | HE 17 | HE 18 | HE 19 | HE 20 | HE 21 | HE 22 | HE 23 | HE 24
Interchange
Nuke
Coal
Hydro
Gas - ST/CC/CS/CH
Gas - GT/CT/IC/JE
Oil-Fo6
Oil-Fo2 & Fo1
Other
 | HE 1 | HE 2 | HE 3 | HE 4 | HE 5 | HE 6 | HE 7 | HE 8 | HE 9 | HE 10 | HE 11 | HE 12 | HE 13 | HE 14 | HE 15 | HE 16 | HE 17 | HE 18 | HE 19 | HE 20 | HE 21 | HE 22 | HE 23 | HE 24
Interchange
Nuke
Coal
Hydro
Gas - ST/CC/CS/CH
Gas - GT/CT/IC/JE
Oil-Fo6
Oil-Fo2 & Fo1
Other
Interchange
Nuke
Coal
Hydro
Gas - ST/CC/CS/CH
Gas - GT/CT/IC/JE
Oil-Fo6
Oil-Fo2 & Fo1
Other
Interchange
Nuke
Coal
Hydro
Gas - ST/CC/CS/CH
Gas - GT/CT/IC/JE
Oil-Fo6
Oil-Fo2 & Fo1
Other
Interchange
Nuke
Coal
Hydro
Gas - ST/CC/CS/CH
Gas - GT/CT/IC/JE
Oil-Fo6
Oil-Fo2 & Fo1
Other
Interchange
Nuke
Coal
Hydro
Gas - ST/CC/CS/CH
Gas - GT/CT/IC/JE
Oil-Fo6
Oil-Fo2 & Fo1
Other
Spreadsheet: 271291d1381896641-sum-with-blank-cell-that-has-if-formula-wip-calculator
Sheet: February

***Balance Sheet is the "holder" of the WIP number.  It should always match report total.
Period 2 | February | Work In Progress Report
 |  | A | B | C | D | E | F | G | H | J
 |  | Job ID | Contract price | Esimated Job Cost Expenses | Estimated GP% | Total Actual Job Cost to date | % of completion of each job in accounting | Earned Revenue | TOTAL Invoiced to Client to date | Over(-) or [NAME]) Status
 |  | Report Total
 |  | Once you have given your final invoice for a project, take the project off this report. |  |  |  |  |  | Report Status
 |  |  |  |  |  |  |  | Prior Period to adjust
Period 2 | February |  |  | Enter the amount showing on line #3 of the appropriate 'Profit Center' in the 'Profit Center" tab.
 |  |  |  | Enter this amount on line #3 of the 'Balance Sheet' in the 'Financial Data" tab.
 |  |  |  | Enter this amount on line #13 of the 'Balance Sheet' in the 'Financial Data" tab.
Journal Entries for Accounting Software
Period 2 | February |  | Journal Entry      Dated February 28
 |  |  | G/L Account |  | Debit | Credit
 |  |  | WIP Income Acct
 |  |  | WIP Asset Acct
 |  |  | !!!REVERSE JOURNAL ENTRY!!!      Dated March 1
 |  |  | G/L Account |  | Debit | Credit
 |  |  | WIP Income Acct
 |  |  | WIP Asset Acct
 |  |  | Journal Entry      Dated February 28
 |  |  | G/L Account |  | Debit | Credit
 |  |  |  | WIP Income Acct
 |  |  |  | WIP Liability Acct
 |  |  | !!!REVERSE JOURNAL ENTRY!!!      Dated March 1
 |  |  | G/L Account |  | Debit | Credit
 |  |  |  | WIP Income Acct
 |  |  |  | WIP Liability Acct
Spreadsheet: 836155d1689132862-assistance-with-countifs-for-two-values-accident-review-spreadsheet-v2
Sheet: 2023

Sunshine Accident Review
 | drop down list options |  | drop down list options |  |  |  |  |  |  | FREQUENCY OF TYPE |  |  |  |  |  |  | TENURE OF DRIVER - DECIMAL FOR YEARS
DATE OF ACCIDENT | ACCIDENT TYPE | ACCIDENT LOCATION/ADDRESS | ACCIDENT SUBURB | TIME | TENURE OF DRIVING EXP (DECIMAL) |  | FINDINGS | TOTAL ACCIDENT COUNT | D.A.F (MOVING) | D.A.F (ST-NARY) | THIRD PARTY AT FAULT | CONTRIB | NON ACCIDENT INCIDENT | OTHER | 0 - 0.5 YRS | 0.6 - 2 YRS | 2.1 - 5 YRS | 5.1 - 10 YRS | 10.1 - 15 YRS | 15 YRS +
2023-07-04 00:00:00 | Driver At Fault (Stationary Obj) |  | Albion |  |  |  | [NAME]
2023-07-04 00:00:00 | Third Party At Fault |  | Maribyrnong |  |  |  | Burnside
2023-07-01 00:00:00 | Third Party At Fault |  | Maribyrnong |  |  |  | Cairnlea
2023-06-28 00:00:00 | Contributory |  | [NAME] |  | 5.5 |  | [NAME]
2023-06-24 00:00:00 | Driver At Fault (Stationary Obj) |  | St Albans |  |  |  | Charter - Long Distance
2023-06-16 00:00:00 | Third Party At Fault |  | Maribyrnong |  |  |  | Charter - Metro
 |  |  |  |  |  |  | Charter - Rural
 |  |  |  |  |  |  | Charter - Souther Cross Station
 |  |  |  |  |  |  | Deanside
 |  |  |  |  |  |  | Delahey
 |  |  |  |  |  |  | Footscray
 |  |  |  |  |  |  | Fraser Rise
 |  |  |  |  |  |  | Kealba
 |  |  |  |  |  |  | Keilor
 |  |  |  |  |  |  | Keilor East
 |  |  |  |  |  |  | Kingsville
 |  |  |  |  |  |  | Maidstone
 |  |  |  |  |  |  | Maribyrnong
 |  |  |  |  |  |  | Seddon
 |  |  |  |  |  |  | St Albans
 |  |  |  |  |  |  | Sunshine
 |  |  |  |  |  |  | Sydenham
 |  |  |  |  |  |  | Taylors Hill
 |  |  |  |  |  |  | Taylors Lakes
 |  |  |  |  |  |  | West Footscray
 |  |  |  |  |  |  | Yarraville
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Albanvale
 |  |  |  |  |  |  | Deer Park
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Braybrook
 |  |  |  |  |  |  | Albion
Spreadsheet: 102593d1300535158-excel-2007-combining-two-data-sets-to-make-a-report-sample
Sheet: DataSet2

 | Barcelona |  | Cardiff |  | Nitra |  | Milan
 | Production | Inventory | Production | Inventory | Production | Inventory | Production | Inventory
AAA-001 | 99 | 111 | 131 | 187
AAA-002 |  |  | 250 | 161 | 161 | 138
AAA-003 | 238 | 297 | 295 | 131
AAB-001 |  |  | 272 | 58 | 116 | 116
BAA-001 | 295 | 97 | 82 | 285 | 59 | 213
CAA-001 |  |  |  |  |  |  | 267 | 70
CAA-002 |  |  |  |  |  |  | 296 | 56
CAA-003 |  |  |  |  |  |  | 64 | 185
Spreadsheet: 32481d1228681514-update-cells-dynamically-book2
Sheet: Sheet1

 | Refresh | 2
 | Hamburg | 3
 | [NAME] | 4
 | Brandenburg | 23
 | Fight Club | 234
 | Brooklyn Bridge | 1
 | Gate | 647
 | Smoothin | 4
 | Cool | 38
 | Bed Me Rose | 94
 | Shallow | 83
 | [NAME] | 72
 | 3D | 7
 | River Wash | 829
 | Waverunner | 82
 | Crush | 19
 | Zebra | 374
 | Grand Central | 78
 | Eiffel | 28
 | Shanghai | 192
 | Keyboard | 819
 | Spring Garden | 29
 | Paris | 2
 | New York | 45
 | Batman | 399
Spreadsheet: 880198d1727822397-drop-down-list-small-problem-kawola223-categories-tms
Sheet: Arkusz1

works well (I select a category and then the appropriate product) |  |  |  |  |  |  |  |  | I have a problem here
Cat1 |  | Cat1 | Product 1 cat1 |  | Drop down list 1 : | Cat2 |  |  | Cat1 |  | Cat1 | Product 1 cat1 | 0 |  | Choose1 : | Cat4
Cat2 |  | Cat1 | Product 2 cat1 |  | Drop down list 2: | Product 1 cat4 |  |  | Cat2 |  | Cat1 | Product 2 cat1 | 1 |  | Choose2: | Product 3 cat4 | <-- | after selecting the category above I want to display only those products (from the selected category) with status 1 and I don't know how to do it
Cat3 |  | Cat1 | Product 3 cat1 |  |  |  |  |  | Cat3 |  | Cat1 | Product 3 cat1 | 0
Cat4 |  | Cat1 | Product 4 cat1 |  |  |  |  |  | Cat4 |  | Cat1 | Product 4 cat1 | 0
 |  | Cat2 | Product 1 cat2 |  |  |  |  |  |  |  | Cat2 | Product 1 cat2 | 1
 |  | Cat2 | Product 2 cat2 |  |  |  |  |  |  |  | Cat2 | Product 2 cat2 | 1
 |  | Cat2 | Product 3 cat2 |  |  |  |  |  |  |  | Cat2 | Product 3 cat2 | 1
 |  | Cat2 | Product 4 cat2 |  |  |  |  |  |  |  | Cat2 | Product 4 cat2 | 1
 |  | Cat2 | Product 5 cat2 |  |  |  |  |  |  |  | Cat2 | Product 5 cat2 | 0
 |  | Cat2 | Product 6 cat2 |  |  |  |  |  |  |  | Cat2 | Product 6 cat2 | 0
 |  | Cat2 | Product 7 cat2 |  |  |  |  |  |  |  | Cat2 | Product 7 cat2 | 0
 |  | Cat3 | Product 1 cat3 |  |  |  |  |  |  |  | Cat3 | Product 1 cat3 | 1
 |  | Cat3 | Product 2 cat3 |  |  |  |  |  |  |  | Cat3 | Product 2 cat3 | 1
 |  | Cat3 | Product 3 cat3 |  |  |  |  |  |  |  | Cat3 | Product 3 cat3 | 1
 |  | Cat3 | Product 4 cat3 |  |  |  |  |  |  |  | Cat3 | Product 4 cat3 | 1
 |  | Cat3 | Product 5 cat3 |  |  |  |  |  |  |  | Cat3 | Product 5 cat3 | 0
 |  | Cat3 | Product 6 cat3 |  |  |  |  |  |  |  | Cat3 | Product 6 cat3 | 0
 |  | Cat3 | Product 7 cat3 |  |  |  |  |  |  |  | Cat3 | Product 7 cat3 | 0
 |  | Cat3 | Product 8 cat3 |  |  |  |  |  |  |  | Cat3 | Product 8 cat3 | 0 |  |  | Product 2 cat4
 |  | Cat4 | Product 1 cat4 |  |  |  |  |  |  |  | Cat4 | Product 1 cat4 | 1 |  |  | Product 3 cat4
 |  | Cat4 | Product 2 cat4 |  |  |  |  |  |  |  | Cat4 | Product 2 cat4 | 1
 |  | Cat4 | Product 3 cat4 |  |  |  |  |  |  |  | Cat4 | Product 3 cat4 | 1
 |  | Cat4 | Product 4 cat4 |  |  |  |  |  |  |  | Cat4 | Product 4 cat4 | 0
 |  | Cat4 | Product 5 cat4 |  |  |  |  |  |  |  | Cat4 | Product 5 cat4 | 0
Spreadsheet: 100069d1298541380-excel-2007-calculation-help-in-excel-2007-leave-overstay-2011
Sheet: DEDUCTION

LEAVE OVER STAY DEDUCTION
SNO | S/C NO | CATEGORY (S/W) | NAME | DESIGNATION | LEAVE ST. DATE | DAYS APPROVED | LEAVE END DATE | REJOIN DATE | OVERSTAY DAYS | [NAME] | REASON FOR OVERSTAY | REMARKS | STATUS
1 |  | S |  |  | 2011-02-15 00:00:00 | 20 |  | 2011-04-10 00:00:00
 |  | W
Spreadsheet: john_zufferli__16822__Can PWR Stack & Website for New Version 122001
Sheet: CAN PWR - Stack

STACK MANAGER ACCESS |  |  |  | Read
Canada Power |  |  |  | Execute
 |  |  |  | None
Name | User ID | Position | Tenor  (1-120 Months) | CAN Power Fin Swap (1916)
Cooper Richey | CRICHEY | Assoc-Power Trader | 24 | Execute
[NAME] | JZUFFER | VP-Canada Trading | [NAME] | Execute
Spreadsheet: 148562d1333467718-loolkup-item-in-a-data-range-and-return-text-from-another-cell-in-row-exam1
Sheet: Lookup

Item # | Tech
1005 | ?
1012 | ?
1070 | ?
1080 | ?
1104 | ?
1106 | ?
1107 | ?
1111 | ?
1119 | ?
1182 | ?
1198 | ?
1200 | ?
1304 | ?
Spreadsheet: 38faf3a9-0ed9-4bcf-8809-49018caa2297
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
3609 | 15669 | [NAME] | Rassinger | AUT | 6 | 00:19:07 | 00:00:00 | 00:29:46 | 00:00:00 | 00:23:20 | 1 | [NAME]
3609 | 15837 | [NAME] | [NAME] | AUT | 5 | 00:18:30 | 00:00:00 | [NAME] | 00:00:00 | 00:23:17 | 2 | 01:12:57
3609 | 6043 | Stuart | Sievwright | GBR | 7 | 00:18:18 | 00:00:00 | 00:36:00 | 00:00:00 | 00:26:36 | 3 | 01:20:54
3609 | 10265 | Xavier | Murguia | ESP | 8 | 00:24:02 | 00:00:00 | 00:38:19 | 00:00:00 | [NAME] | 4 | 01:28:58
Spreadsheet: eric_saibi__9856__101101
Sheet: Indian River 2

Owner Name |  | NRG Energy Incorporated
Station Name |  | Indian River Power Station
Unit Name |  | Indian River 02
NERC Region |  | MAAC
State |  | DE
Fuel Type |  | Coal
Capacity |  | 82 MW
Start Date |  | 2001-10-09 00:00:00
End Date |  | 2001-10-14 00:00:00
Comments |  | Had several Tube Leaks
SIC |  | 4931
Plant ID |  | 1515051
Unit ID |  | 1008232
Outage ID |  | 18640
Spreadsheet: 773129d1647629456-alternative-to-the-indirect-function-raw
Sheet: 4

 |  |  | Yadda
 |  |  | 24
 |  |  | 23
 |  |  | 94
 |  |  | 76
 |  |  | 52
 |  |  | 46
 |  |  | 58
 |  |  | 97
 |  |  | 65
 |  |  | 89
 |  |  | 13
 |  |  | 43
 |  |  | 15
 |  |  | 48
 |  |  | 31
 |  |  | 39
 |  |  | 3
 |  |  | 2
 |  |  | 18
 |  |  | 83
 |  |  | 24
Spreadsheet: 821804d1678901583-vlookup-or-similar-way-of-archieving-this-task-example
Sheet: Sheet1

Table A | Type 2 |  |  | 1 | fill as 1a when it is type 2 |  |  |  |  | Table 1 | Type 1 |  |  | 1a
 |  |  |  | 2 | fill as 2a when it is type 2 |  |  |  |  |  |  |  |  | 2a
 |  |  |  | 3 | fill as 3a when it is type 2 |  |  |  |  |  |  |  |  | 3a
 |  |  |  | 4 | fill as 4a when it is type 2 |  |  |  |  |  |  |  |  | 4a
 |  |  |  | 5 | fill as 5a when it is type 2 |  |  |  |  |  |  |  |  | 5a
 |  |  |  | 6 | fill as 6a when it is type 2 |  |  |  |  |  |  |  |  | 6a
 |  |  |  | 7 | fill as 7a when it is type 2 |  |  |  |  |  |  |  |  | 7a
 |  |  |  | 8 | fill as 8a when it is type 2 |  |  |  |  |  |  |  |  | 8a
 |  |  |  | 9 | fill as 9a when it is type 2 |  |  |  |  |  |  |  |  | 9a
 |  |  |  | 10 | fill as 10a when it is type 2 |  |  |  |  |  |  |  |  | 10a
 |  |  |  | 11 | fill as 11a when it is type 2 |  |  |  |  |  |  |  |  | 11a
Table B | Type 1 |  |  | a | fill as aa when it is type 1 |  |  |  |  | Table 2 | Type 2 |  |  | aa
 |  |  |  | b | fill as bb when it is type 1 |  |  |  |  |  |  |  |  | ba
 |  |  |  | c | fill as cc when it is type 1 |  |  |  |  |  |  |  |  | ca
 |  |  |  | d | fill as dd when it is type 1 |  |  |  |  |  |  |  |  | da
 |  |  |  | e | fill as ee when it is type 1 |  |  |  |  |  |  |  |  | ea
 |  |  |  | f | fill as ff when it is type 1 |  |  |  |  |  |  |  |  | fa
 |  |  |  | g | fill as gg when it is type 1 |  |  |  |  |  |  |  |  | ga
 |  |  |  | h | fill as hh when it is type 1 |  |  |  |  |  |  |  |  | ha
 |  |  |  | i | fill as ii when it is type 1 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | j | fill as jj when it is type 1 |  |  |  |  |  |  |  |  | ja
 |  |  |  | k | fill as kk when it is type 1 |  |  |  |  |  |  |  |  | ka
Spreadsheet: 777076d1650123502-pull-data-from-multiple-sheets-floor-stock-sheets-template
Sheet: 2004235 Cardiac Rehab 

[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Service Units
Item | Price | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu
Lemon Lime- Soda | 0.25
Diet Lemon Lime- Soda | 0.25
Cola- Soda | 0.25
Diet Cola- Soda | 0.25
 | 0.56
Crackers, [NAME] | 0.08
[NAME] | 0.16
Juice Orange | 0.23
Juice Cranberry | 0.23
Juice Apple | 0.23
Peanut Butter Crackers Toasted | 0.25
Peanut Butter Crackers Cheese | 0.25
Plasticware | 0.03
Pudding chocolate | 0.28
Pudding Vanilla | 0.28
Refrigerator Thermometer (reg.)
Monthly Total