tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 842262d1694407657-trying-to-reference-same-cell-from-different-sheets-using-indirect-function-indirect-issue
Sheet: Sheet1

 | index match indirect formula |  |  |  |  | formula
 | Total Rents
 |  | 2023-08-31 00:00:00
Clarence | Cash Flow
Biddulph | Cash Flow
5240 | Cash Flow
 | Regular | 2023-08-31 00:00:00
 | 1
 | 2
 | 3
Spreadsheet: 681541d1591629411-how-to-use-match-function-and-get-result-as-ture-if-condition-is-true-then-match-function-auto-parts
Sheet: Sheet1

item number. | searchbox | parts no. |  | In stock/out of stock | item no. refrence > | table no.
1 | 7 | 12 | 26 | In stock | 1 | 2 | 3 | 4 | 10 | 9 | 8
2 | 5 | 25 | 11 | in stock | 2 | 3 | 4 | 5 | 1 | 8 | 7
3 | 2 | 99 | 9 | out of stock | 3 | 4 | 5 | 6 | 2 | 7 | 6
4 |  |  |  |  | 4 | 5 | 6 | 7 | 3 | 6 | 5
5 |  |  |  |  | 5 | 6 | 7 | 8 | 4 | 5 | 4
6 |  |  |  |  | 6 | 7 | 8 | 9 | 5 | 4 | 3
7 |  |  |  |  | 7 | 8 | 9 | 10 | 6 | 3 | 2
8 |  |  |  |  | 8 | 9 | 10 | 11 | 7 | 2 | 1
9 |  |  |  |  | 9 | 10 | 1 | 2 | 8 | 1 | 0
10 |  |  |  |  | 10 | 1 | 2 | 3 | 9 | 10 | -1
Spreadsheet: 773225d1647710366-extract-all-values-in-column-excluding-immediate-duplicates-only-column-list
Sheet: Sheet1

Alejandro [NAME] |  |  | Alejandro [NAME]
Alejandro [NAME] |  |  | [NAME]
Alejandro [NAME] |  |  | [NAME]
Alejandro [NAME] |  |  | [NAME]
Alejandro [NAME] |  |  | [NAME]
Alejandro [NAME] |  |  | Alejandro [NAME]
Alejandro [NAME]
Alejandro [NAME]
Alejandro [NAME]
Alejandro [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Alejandro [NAME]
Alejandro [NAME]
Alejandro [NAME]
Alejandro [NAME]
Alejandro [NAME]
Alejandro [NAME]
Alejandro [NAME]
Alejandro [NAME]
Alejandro [NAME]
Alejandro [NAME]
Spreadsheet: 181550d1348070120-creating-charts-my-test
Sheet: Sheet1

 | Resource Count | Name | Customer | Project |  | October | November | December | January
 | 1 | JK | A | AAA |  | A | A | A | A
 | 1 | [NAME] | C | BBB |  | C | C
 | 1 | [NAME] | A | AAA |  | A | A | A | A
 | 1 | [NAME] | All | BBB |  | All | All | All | All
 | 1 | [NAME] |  | DDD |  | A | A | A
 | 1 | [NAME] | A | CCC |  | A | A | B | B
 | 1 | [NAME] | B | SSS |  | B | B | D | D
 | 1 | Kelly | C | FFF |  | C | C | C | C
 | 1 | Mo | C | WWW |  | C | D | D | D
 | 1 | [NAME] | All | AAA |  | All | All | All | All
 | 1 | [NAME] | A | BBB |  | A | C | C | C
 | 1 | [NAME] |  | AAA |  | A | A
 | 1 | [NAME] | D | VVV |  | D | D | D | D
Total =
Spreadsheet: 216516d1361797480-quantity-formulas-between-sheets-formula-help-2
Sheet: 01

PART NUMBER | [NAME] | PTA | PTB | PTC | PTD | PTE | PTF | PTG | PTH | PTJ
1234 | 630A | 1
5678 | 1250A |  |  |  |  |  | 1
9123 | 200A
59645 | 630 TEST | 1
59646 | 1250 TEST |  |  |  |  |  | 1
59647 | 2000 TEST
Spreadsheet: 104056d1301676999-stacked-graph-graph_stacked_sidebyside1
Sheet: Sheet1

 |  |  |  | Stacked side by side |  |  | Stacked side by side |  |  | Stacked side by side |  |  | Stacked side by side |  |  | Stacked side by side
 |  | Name | Sample ID | Annual NAR Quota | Projected Revenue to Quota |  | Send Report NAR | Projected revenue per S.R |  | Sales contest NAR | Projected revenue per S.C |  | Branch audit | Projected revenue per branch audit |  | Audited NAR | Projected revenue per audit
 |  | [NAME] | Sample 2 | 10400 | 72800 |  | 24317 | 170219 |  | 18080 | 126560 |  | 17280.12 | 120960.84 |  | 17280.12 | 120960.84
Spreadsheet: 189825d1351372063-using-multiple-match-tables-on-1-spreadsheet-excel-forum-example
Sheet: Sheet1

Select Equipment Number from List | Select Number of Colors from List | Select Code From List | Results
Machine #2 | 2 color | 101 | 551.75
 |  |  |  | Equipment #1 |  |  |  | Equipment #2
 |  |  | Color | Code | Total Price |  | Color | Code | Total Price
 |  | Results >> | 2 color | 101 | 551.75 |  | 2 color | 101 | 557.25 | << Results
Machine #1 | 1 color | 100 | 1 color | 100 | 375 |  | 1 color | 100 | 380.5
Machine #2 | 2 color | 101 | 1 color | 101 | 400.25 |  | 1 color | 101 | 405.75
 | 3 color | 102 | 1 color | 102 | 425.5 |  | 1 color | 102 | 431
 | 4 color | 103 | 1 color | 103 | 450.75 |  | 1 color | 103 | 456.25
 |  | 104 | 1 color | 104 | 476 |  | 1 color | 104 | 481.5
 |  | 105 | 1 color | 105 | 501.25 |  | 1 color | 105 | 506.75
 |  | 200 | 2 color | 100 | 526.5 |  | 2 color | 100 | 532
 |  | 201 | 2 color | 101 | 551.75 |  | 2 color | 101 | 557.25
 |  | 202 | 2 color | 102 | 577 |  | 2 color | 102 | 582.5
 |  | 203 | 2 color | 103 | 602.25 |  | 2 color | 103 | 607.75
 |  | 204 | 2 color | 104 | 627.5 |  | 2 color | 104 | 633
 |  | 205 | 2 color | 105 | 652.75 |  | 2 color | 105 | 658.25
These are the drop down list options |  |  | 3 color | 100 | 678 |  | 3 color | 100 | 683.5
for A2, B2 and C2 |  |  | 3 color | 101 | 703.25 |  | 3 color | 101 | 708.75
 |  |  | 3 color | 102 | 728.5 |  | 3 color | 102 | 734
 |  |  | 3 color | 103 | 753.75 |  | 3 color | 103 | 759.25
 |  |  | 3 color | 104 | 779 |  | 3 color | 104 | 784.5
 |  |  | 3 color | 105 | 804.25 |  | 3 color | 105 | 809.75
 |  |  | 4 color | 100 | 829.5 |  | 4 color | 100 | 835
 |  |  | 4 color | 101 | 854.75 |  | 4 color | 101 | 860.25
 |  |  | 4 color | 102 | 880 |  | 4 color | 102 | 885.5
 |  |  | 4 color | 103 | 905.25 |  | 4 color | 103 | 910.75
 |  |  | 4 color | 104 | 930.5 |  | 4 color | 104 | 936
 |  |  | 4 color | 105 | 955.75 |  | 4 color | 105 | 961.25
Spreadsheet: 792925d1661236699-index-and-match-for-for-two-criteria-data-by-rows-populated-horizontally-device_database-edit-ans
Sheet: DataViewer

 | Workorder# | W0001
 | ID# | 11
 | Device DB
 | ID
 | WO
 | SO
 | Date
 | PSI @ 0%
 | mA @ 0%
 | PSI @ 20%
 | mA @ 20%
 | PSI @ 40%
 | mA @ 40%
 | PSI @ 60%
 | mA @ 60%
 | PSI @ 80%
 | mA @ 80%
 | PSI @ 100%
 | mA @ 100%
 | PASS or FAIL?
Spreadsheet: 875732d1722343350-if-or-and-with-many-condition-statements-formula
Sheet: Sheet1

 |  |  | Result:
Y | A |  | A |  | If A3="Y" and B3="A" and [NAME]blank, result D3 = "A"
NA | B | C | C |  | If A4="NA" and B4="B", and C4="C", result D4 = "C"
NA | B | A | A |  | If A5="NA" and B5="B", and C5="A", result D5 = "A"
Y | A | C | A |  | If A6="Y" and B6="A", and C6="C", result = D6 = "A"
Y | B |  | B |  | If A7="Y" and B7="B", and C7=blank, result D7 = "B"
Spreadsheet: 89251d1288990660-trying-to-get-vlookup-to-include-formatting-of-lookup-cell-vlookup-sample-need-to-include-formatting
Sheet: SOURCE

[NAME] | ID | Full Name | DEGREE
ALB | 5 | NANCY | BA
SEA | 2 | BOB | MBA
SEA | 3 | CARRIE | BS
SEA | 4 | STEVE | MBA
SPO | 1 | JOE | BA
Spreadsheet: f6a204df-43fc-44e2-97ad-1ae8a92d073f
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Rhino | 706301667620 | Chanticleer | Wondrous Love: A World Folk Song Collection | 2008-07-01 | Compact Disc | Classical | 16.99 | Y | While Supplies Last
Rhino | 745099087821 | Chanticleer | Where The Sun Will Never Go Down: Spituals And Traditional Gospel Music | 2008-07-01 | Compact Disc | Classical | 16.99 | Y | While Supplies Last
Rhino | 825646029020 | Chanticleer | Purcell: [NAME], Anthems & Sacred Songs | 2008-07-01 | Compact Disc | Classical | 17.99 | Y | While Supplies Last
Rhino | 809274855626 | Chanticleer | Our American Journey | 2008-07-01 | Compact Disc | Classical | 17.99 | Y | While Supplies Last
Spreadsheet: 123179d1317391374-comparing-2-excel-files-and-culling-the-different-data-sample1
Sheet: Sheet1

name | address | city | state | zip
bob | 111 street | dallas | tx | 75052
lilly | 222 street | arlington | tx | 76013
[NAME] | 333 way | fort worth | tx | 75112
[NAME] | 444 blvd | dallas | tx | 76102
jane | 555 street | dallas | tx | 76525
Spreadsheet: 847330d1698317102-calculating-hours-worked-overtime-n-example
Sheet: Sheet1

You must use the format HH:[NAME] (ie 09:00 or 17:00) when entering your time. It reformats the cell if you use any other way (ie 9 or 17 or 9.00 ect) this will change the calculations and the sheet won't be correct.
 |  | Enter start time: 24hr clock | Enter time work over lunch. ie 00:30 minuets worked | Enter finish time: 24hr clock | Hours worked | Running total of overtime. | Enter time taken back as hours:minutes | Final running total of overtime
Date | Day | Start | Lunch | Finish | Hours | Overtime | Time taken back | Total
2023-09-18 00:00:00 | Mon
2023-09-19 00:00:00 | Tue
2023-09-20 00:00:00 | Wed
2023-09-21 00:00:00 | Thu
2023-09-22 00:00:00 | Fri
2023-09-23 00:00:00 | Sat
2023-09-24 00:00:00 | Sun
2023-09-25 00:00:00 | Mon | 06:50:00 |  | 16:50:00
2023-09-26 00:00:00 | Tue
2023-09-27 00:00:00 | Wed | 06:50:00 |  | 17:20:00
2023-09-28 00:00:00 | Thu
2023-09-29 00:00:00 | Fri
2023-09-30 00:00:00 | Sat
2023-10-01 00:00:00 | Sun
2023-10-02 00:00:00 | Mon | 06:50:00 |  | 16:45:00
2023-10-03 00:00:00 | Tue | 07:10:00 |  | 17:30:00
2023-10-04 00:00:00 | Wed | 05:40:00 |  | 16:30:00
2023-10-05 00:00:00 | Thu | 05:40:00 |  | 16:40:00
2023-10-06 00:00:00 | Fri
2023-10-07 00:00:00 | Sat
2023-10-08 00:00:00 | Sun
2023-10-09 00:00:00 | Mon
2023-10-10 00:00:00 | Tue | 07:05:00 |  | 16:45:00
2023-10-11 00:00:00 | Wed | 06:40:00 |  | 17:00:00
2023-10-12 00:00:00 | Thu | 06:40:00 |  | 16:45:00
2023-10-13 00:00:00 | Fri
2023-10-14 00:00:00 | Sat
2023-10-15 00:00:00 | Sun
2023-10-16 00:00:00 | Mon | 07:05:00 |  | 17:00:00
2023-10-17 00:00:00 | Tue
2023-10-18 00:00:00 | Wed
2023-10-19 00:00:00 | Thu | 06:45:00 |  | 17:00:00
2023-10-20 00:00:00 | Fri
2023-10-21 00:00:00 | Sat
2023-10-22 00:00:00 | Sun
2023-10-23 00:00:00 | Mon | 06:55:00 |  | 17:05:00
2023-10-24 00:00:00 | Tue
2023-10-25 00:00:00 | Wed | 07:00:00 |  | 17:15:00
2023-10-26 00:00:00 | Thu
2023-10-27 00:00:00 | Fri
2023-10-28 00:00:00 | Sat
2023-10-29 00:00:00 | Sun
2023-10-30 00:00:00 | Mon
2023-10-31 00:00:00 | Tue
2023-11-01 00:00:00 | Wed
2023-11-02 00:00:00 | Thu
2023-11-03 00:00:00 | Fri
2023-11-04 00:00:00 | Sat
2023-11-05 00:00:00 | Sun
2023-11-06 00:00:00 | Mon
2023-11-07 00:00:00 | Tue
2023-11-08 00:00:00 | Wed
2023-11-09 00:00:00 | Thu
2023-11-10 00:00:00 | Fri
2023-11-11 00:00:00 | Sat
2023-11-12 00:00:00 | Sun
2023-11-13 00:00:00 | Mon
2023-11-14 00:00:00 | Tue
2023-11-15 00:00:00 | Wed
2023-11-16 00:00:00 | Thu
2023-11-17 00:00:00 | Fri
2023-11-18 00:00:00 | Sat
2023-11-19 00:00:00 | Sun
2023-11-20 00:00:00 | Mon
2023-11-21 00:00:00 | Tue
2023-11-22 00:00:00 | Wed
2023-11-23 00:00:00 | Thu
2023-11-24 00:00:00 | Fri
2023-11-25 00:00:00 | Sat
2023-11-26 00:00:00 | Sun
2023-11-27 00:00:00 | Mon
2023-11-28 00:00:00 | Tue
2023-11-29 00:00:00 | Wed
2023-11-30 00:00:00 | Thu
2023-12-01 00:00:00 | Fri
Spreadsheet: 712808d1610418509-vacation-accrual-question-timesheet-formula
Sheet: 20 Feb -3 Mar

TIME SHEET
DAY: | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | TOTAL
DATE: | 2021-02-20 00:00:00
 | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours | Hours
Regular Time (Hrs)
Overtime (Hrs)
Vacation (Hrs)
[NAME] (Hrs) | 1 |  |  | 1 |  |  |  |  |  | 1
Holiday Pay (Hrs) | 1
Total:
 |  |  |  |  |  | Disclaimer: Time-and-a-half is only paid after 106 total hours. Anything under 106 will be paid at straight time……….^^
 |  |  |  |  |  |  | Prior Balance |  | Used This Period |  | Added This Period |  | Total Remaining
 |  |  |  |  | Vacation (Days): |  | 40 | - |  | + | 1 | =
 |  |  |  |  | [NAME] (Days): |  | 46.15 | - |  | + | 1 | =
 |  |  |  |  | Where does this come from, and over what period?
Spreadsheet: 776319d1649686101-conditional-formating-based-on-cell-value-jeriss-dashboard
Sheet: OVERVIEW 3

TYPE | (Tous)
 | Étiquettes de colonnes
 | HTVA |  |  | TVAC |  |  | Total HTVA | Total TVAC
PÉRIODE | canceled | received | to receive | canceled | received | to receive
2023 |  |  | 2950 |  |  | 2950 | 2950 | 2950
Q1 |  |  | 2950 |  |  | 2950 | 2950 | 2950
2024 |  |  | 2950 |  |  | 2950 | 2950 | 2950
Q1 |  |  | 2950 |  |  | 2950 | 2950 | 2950
2025 |  |  | 3538 |  |  | 3538 | 3538 | 3538
Q1 |  |  | 3538 |  |  | 3538 | 3538 | 3538
2021 |  | 6290 |  |  | 6290 |  | 6290 | 6290
Q3 |  | 1790 |  |  | 1790 |  | 1790 | 1790
Q4 |  | 4500 |  |  | 4500 |  | 4500 | 4500
2022 | 16.92 | 4105.46 | 3882.5 | 16.92 | 4105.46 | 3882.5 | 8004.88 | 8004.88
Q1 | 16.92 | 4105.46 |  | 16.92 | 4105.46 |  | 4122.38 | 4122.38
Q2 |  |  | 3882.5 |  |  | 3882.5 | 3882.5 | 3882.5
TOTAL | 16.92 | 10395.46 | 13320.5 | 16.92 | 10395.46 | 13320.5 | 23732.88 | 23732.88
The problem is that your "Year" column has some Text and some Numbers mixed together. [NAME] a column E and check the Year column with "=IsText(D2)" and pull it down. You are trying to sort numbers and text in your pivot table. That is the problem. Make all the Year values or numbers and try it again.
Spreadsheet: 158368d1338203454-depentent-fropdown-list-with-some-specifice-features-book2
Sheet: Sheet1

Tool Type |  | Tool No. |  | Bottom Connection |  | Top Connection |  | Pressure Rating | [NAME]. Date | Comments
[NAME]
GREASE INJECTION HEAD
LUBRICATOR 5-1/8"
BOP 5-1/8"
LUBRICATOR 3"
BOP 3"
PRESSURE TEST CAP
INTEGRAL PUMP IN SUB
INJECTION SUB 5 3/4" - 4 OTIS PIN / COLLAR
Test [NAME]
Test Plug
QTS SUB
Test Stump
Blind Flange
X.O.
X.O.
Spreadsheet: 50723d1250186192-continual-updates-of-most-recent-information-testing
Sheet: Shifts

Month | Shift Date | Team | Driver | email1 | Drive Phone # | Navigator | [NAME] | Nav. Phone # | [NAME] | email 3 | dis. Phone
August | 2009-08-01 00:00:00 | Red | a | [EMAIL] | xxx-xxx-xxxx | b | [EMAIL] | xxx-xxx-xxxx | c | [EMAIL] | xxx-xxx-xxxx
August | 2009-08-01 00:00:00 | Blue | d | [EMAIL] | xxx-xxx-xxxx | f | [EMAIL] | xxx-xxx-xxxx | e | [EMAIL] | xxx-xxx-xxxx
August | 2009-08-01 00:00:00 | Green | OPEN |  |  | OPEN
August | 2009-08-01 00:00:00 | Gold | OPEN |  |  | OPEN
August | 2009-08-01 00:00:00 | Magenta | OPEN |  |  | OPEN
August | 2009-08-01 00:00:00 | Silver | OPEN |  |  | OPEN
August
August | 2009-08-07 00:00:00 | Red | d | [EMAIL] | xxx-xxx-xxxx | h | [EMAIL] | xxx-xxx-xxxx | b | [EMAIL] | xxx-xxx-xxxx
August | 2009-08-07 00:00:00 | Blue | t | [EMAIL] | xxx-xxx-xxxx | q | [EMAIL] | xxx-xxx-xxxx
August | 2009-08-07 00:00:00 | Green | OPEN |  |  | OPEN
August
August | 2009-08-08 00:00:00 | Red | p | [EMAIL] | xxx-xxx-xxxx | q | [EMAIL] | xxx-xxx-xxxx | v | [EMAIL] | xxx-xxx-xxxx
August | 2009-08-08 00:00:00 | Blue | OPEN |  |  | OPEN |  |  | y | [EMAIL] | xxx-xxx-xxxx
August | 2009-08-08 00:00:00 | Green | OPEN |  |  | OPEN
August | 2009-08-08 00:00:00 | Gold | OPEN |  |  | OPEN
August | 2009-08-08 00:00:00 | Magenta | OPEN |  |  | OPEN
August | 2009-08-08 00:00:00 | Silver | OPEN |  |  | OPEN
August
August | 2009-08-14 00:00:00 | Red | j | [EMAIL] | xxx-xxx-xxxx | k | [EMAIL] | xxx-xxx-xxxx | g | [EMAIL] | xxx-xxx-xxxx
August | 2009-08-14 00:00:00 | Blue | z | [EMAIL] | xxx-xxx-xxxx | y | [EMAIL] | xxx-xxx-xxxx
August | 2009-08-14 00:00:00 | Green | OPEN |  |  | OPEN
August
August | 2009-08-15 00:00:00 | Red | m | [EMAIL] | xxx-xxx-xxxx | p | [EMAIL] | xxx-xxx-xxxx | e | [EMAIL] | xxx-xxx-xxxx
August | 2009-08-15 00:00:00 | Blue | r | [EMAIL] | xxx-xxx-xxxx | q | [EMAIL] | xxx-xxx-xxxx | b | [EMAIL] | xxx-xxx-xxxx
August | 2009-08-15 00:00:00 | Green | a | [EMAIL] | xxx-xxx-xxxx | d | [EMAIL] | xxx-xxx-xxxx
August | 2009-08-15 00:00:00 | Gold | OPEN |  |  | OPEN
August | 2009-08-15 00:00:00 | Magenta | OPEN |  |  | OPEN
August | 2009-08-15 00:00:00 | Silver | OPEN |  |  | OPEN
Spreadsheet: 06095e07-dce6-45a1-8157-b78a95094898
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 8731.0 Building Approvals, Australia
 | TABLE 81. Value of Building Approved, Chain Volume Measures, Original - Queensland
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Value of Approval ($M) ;  Chain Volume Measures ;  Queensland ;  Total houses ;  New ; |  |  | Original | A590497K | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Queensland ;  Total other residential building ;  New ; |  |  | Original | A590498L | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Queensland ;  Total residential building ;  New ; |  |  | Original | A590499R | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Queensland ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A590500L | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Queensland ;  Total residential building ;  Total (Type of Work) ; |  |  | Original | A590501R | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Queensland ;  Total non-residential building ;  Total (Type of Work) ; |  |  | Original | A590502T | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Queensland ;  Total building ;  Total (Type of Work) ; |  |  | Original | A590503V | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2012
Spreadsheet: 769133d1645340243-planned-vs-actual-weeks-behind-or-ahead-calculation-planned-vs-actual-week-status-rev-pcb-answer-1-ans
Sheet: Sheet2

Date | Planned Week | Actual Week | Planned Cumulative | Actual Cumulative | Status (Weeks behind or ahead) | Column F should read: | Y1 | Y2 | X1 | X2 | RESULT
2022-01-03 00:00:00 | 0 | 0 |  |  | 0 | 0
2022-01-10 00:00:00 | 14 | 7 |  |  |  | -0.5
2022-01-17 00:00:00 | 14 | 14 |  |  |  | -0.5
2022-01-24 00:00:00 | 14 | 7 |  |  |  | -1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Answer:
2022-01-31 00:00:00 | 21 | 7 |  |  |  | -1.5 |  |  |  |  |  |  |  |  |  |  |  |  | how do you come to -1,5  ? |  |  | Cummulative actual on cell D6 is achieved half way in the week commencing 17/1/2022 (or between cell D4 to D5). Noted on graph
2022-02-07 00:00:00 | 21 | 21 |  |  |  | -1.33 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Planned production in W.C. 17/01 is 2/d. 35 cummulative planned is reached 3,5 d later or 0,5weeks. This would result in a cummulative planned value of 35 1,5 weeks before actual date of Cell E6
2022-02-14 00:00:00 | 14 | 21 |  |  |  | -1.33 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The formula will only work on if the planned and actual data match in the week or if the average weekly production of the planned cummulative is 14.
2022-02-21 00:00:00 | 14 | 21 |  |  |  | -1
2022-02-28 00:00:00 | 7 | 21 |  |  |  | 0
2022-03-07 00:00:00 | 7 | 21 |  |  |  | 1
2022-03-14 00:00:00 | 14 | 21 |  |  |  | 1.5
2022-03-21 00:00:00 | 14 | 7 |  |  |  | 1
2022-03-28 00:00:00 | 14 | 7 |  |  |  | 0.5
2022-04-04 00:00:00 | 14 | 7 |  |  |  | 0
2022-04-11 00:00:00 | 14 | 7 |  |  |  | -0.5
2022-04-18 00:00:00 | 21 | 7 |  |  |  | -1
2022-04-25 00:00:00 | 21 | 7 |  |  |  | -1.67
2022-05-02 00:00:00 | 7 | 7 |  |  |  | -2.33
2022-05-09 00:00:00 | 7 | 7 |  |  |  | -3
2022-05-16 00:00:00 | 14 | 7 |  |  |  | -3.67
2022-05-23 00:00:00 | 14 | 7 |  |  |  | -4.33
 |  |  |  |  |  | NOTE: columns H, I, J and K are helper columns
 |  |  |  |  |  | Columns H and  I are ARRAY formulas
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 63-35=28 | 63/4=15,75 | 28/15,75=1,78
Spreadsheet: 044aa192-1a62-484e-96c0-6ec346c93213
Sheet: PAG 5 - Table 2

Ambev results |  |  | Currency Translation | Organic Growth |  | % As | %
R$ million | YTD10 | Scope |  |  | YTD11 | Reported | Organic
Volume ('000 hl) | 117103.8154606034 | -1088.015892 | 0 | 882.6402920649988 | 116898.4398606684 | -0.001753790848976089 | 0.007607931810555413
Net revenue | 17777.966 | -170.883 | -479.647824020162 | 1620.842824020162 | 18748.278 | 0.05457947213983871 | 0.09205629484566878
Net revenue/hl | 151.8137212700891 | -0.04919380511714166 | -4.103115701046615 | 12.71949684654129 | 160.3809086104667 | 0.05643223332320413 | 0.08381073666556905
[NAME] | -5996.626 | 33.81599999999999 | 193.8855356992177 | -487.0285356992181 | -6255.953 | 0.04324548504442327 | 0.08266088917864638
[NAME]/hl | -51.20777641969669 | -0.1887576917975196 | 1.658581037782116 | -3.778184587804091 | -53.51613766151618 | 0.04507833386281512 | 0.07438706179287036
Gross profit | 11781.34 | -137.067 | -285.7622883209443 | 1133.814288320944 | 12492.325 | 0.06034839839950279 | 0.09678149572055376
Gross margin | 0.6626933587340644 |  |  |  | 0.6663185280269472 | 30 | 30
SG&A excl. deprec.&amort. | -4862.891000000001 | 70.086 | 126.0181765256263 | -306.5851765256267 | -4973.372000000001 | 0.02271920139686467 | 0.06396779683830797
SG&A deprec.&amort. | -441.4560000000001 | -15.987 | 11.16268298001925 | 40.35031701998074 | -405.93 | -0.08047461128628919 | -0.09288640098521135
SG&A total | -5304.347000000002 | 54.099 | 137.1808595056457 | -266.2348595056447 | -5379.302000000001 | 0.0141308628564456 | 0.05093249735626551
Other operating income | 371.731 | -2.011 | 3.991739432017175 | 90.20326056798282 | 463.915 | 0.2479857746596328 | 0.2439772275451229
Normalized EBIT | 6848.723999999998 | -84.979 | -144.5896893832814 | 957.7826893832824 | 7576.937999999996 | 0.1063284197173078 | 0.1396651518332998
Normalized EBIT margin | 0.3852366463070071 |  |  |  | 0.4041404762613397 | 190 | 170
Normalized EBITDA | 7885.029 | -0.2669999999999959 | -176.3786929308075 | 926.5576929308078 | 8634.941 | 0.09510580113275435 | 0.1175124490670496
Normalized EBITDA margin | 0.4435281853953371 |  |  |  | 0.4605724856437483 | 170 | 100
Spreadsheet: 159520d1338728046-create-dynamic-data-validation-list-based-upon-criteria-data-validation-example2
Sheet: Hourly

I need the Data Validation List in Column A to use Name "Lookup_Hourly_Names" to only include Employees from Name "Range_Employees" whos status is "Active" and Type is "Hourly"
Name | Rate | Start Date
Spreadsheet: 682620d1592230206-counting-number-of-occurences-since-last-bad-item-book1
Sheet: Sheet1

Item | Good / Bad | Qty | Count of good lots since last know bad lot
Apples | Good | 10 | 1
Oranges | Good | 10 | 1
Pears | Good | 10 | 1
Apples | Bad | 10 | 0
Apples | Good | 10 | 1 | first good sample since C5
Oranges | Bad | 10 | 0
Apples | Good | 10 | 2 | total here is C6+C8
Apples | Bad | 5 | 0
Oranges | Good | 10 | 1 | first good sample since C7
Apples | Good | 25 | 1 | first good sample since C9
Spreadsheet: 156021d1337153286-a-fun-one-matching-rows-to-columns-book1_nonarraysolution
Sheet: Sheet1

Players | Team | Helper
[NAME] | Bulls | 1
[NAME] | Suns | 1
[NAME] | Yankees | 1
[NAME] | Knicks | 1
Scottie Pippen | Bulls | 2
[NAME] | Spurs | 1
[NAME] | Suns | 2
[NAME] | Yankees | 2