tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 729876d1619425337-only-count-cells-with-any-one-of-each-of-several-separate-values-on-dates-before-today-examplebook2
Sheet: Sheet1

 |  |  | 2021-03-03 00:00:00 | 2021-03-10 00:00:00 | 2021-03-17 00:00:00 | 2021-03-24 00:00:00 | 2021-03-31 00:00:00 | 2021-04-07 00:00:00 | 2021-04-14 00:00:00 | 2021-04-21 00:00:00 | 2021-04-28 00:00:00 | 2021-05-05 00:00:00 | 2021-05-12 00:00:00 | 2021-05-19 00:00:00 | 2021-05-26 00:00:00
 | spot | beautifully | s | s | Bl | s | s | Bl | s | s
 | twist | queerly | s | s | Bl | s | s | Bl | s | s |  |  |  |  |  |  | Gr
 | blink | fervently | Gr | Gr | Gr | Gr | Gr | Gr | Gr | Bl |  |  |  |  |  |  | Bl
 | blot | even | Re | Gr | Gr | Re | Gr | Gr | Bl | _ |  |  |  |  |  |  | Re
 | rhyme | finally | Bl | Gr | Bl | Gr | Gr | _ | _ | Bl |  |  |  |  |  |  | s
 | shock | again | Gr | Gr | _ | Gr | Gr | Re | Gr | Gr
 | flow | longingly | Gr | Gr | Bl | Gr | Gr | Gr | Gr | Gr
 | increase | knavishly | Gr | Gr | Gr | _ | Gr | Re | Re | Gr
 | rush | ultimately | Gr | Gr | _ | Gr | Gr | _ | Gr | _
 | advise | briefly | Gr | Gr | Gr | Gr | Gr | Gr | _ | Gr
 | refuse | joyously | Bl | Bl | Bl | Bl | Gr | Gr | Bl | Bl
 | mourn | cleverly | Gr | Gr | Gr | Gr | Gr | Gr | Gr | Re |  |  |  |  |  |  | number
 | observe | helpfully | Gr | Re | Gr | Gr | Gr | Re | Re | Bl |  |  |  |  |  |  | previous number |  |  | 44
 | explain | quaintly | Gr | Gr | Gr | Gr | Gr | Gr | Gr | Gr |  |  |  |  |  |  | Increase/decrease
 | happen | evenly | Gr | Re | Re | Gr | Re | Gr | Gr | Re
 | punch | intensely | Gr | Gr | Gr | Gr | Gr | Gr | Gr | Gr
 | inject | correctly | Gr | Re | Gr | Gr | Re | Re | Gr | Re
 | entertain | ever | Gr | Gr | Gr | Gr | Gr | Gr | Gr | Re
 | analyze | necessarily | _ | Bl | Re | Re | Re | Re | Re | Re
 | question | acidly | Gr | Gr | Gr | Gr | Gr | Gr | Gr | Gr
 | tickle | voluntarily | _ | _ | Gr | Gr | Gr | Bl | Gr | Gr
 | educate | unabashedly | Gr | Re | Gr | Gr | Gr | Re | Re | Re
 | mine | utterly | Gr | Gr | Gr | Gr | Gr | Bl | Gr | Gr
 | identify | abnormally | Gr | Bl | _ | Re | Bl | _ | Gr | Gr
 | warn | truthfully | Bl | _ | Gr | Gr | _ | Bl | Re | Gr
 | sail | generously | _ | Bl | Gr | Re | Re | Gr | Gr | Gr
 | fill | else | Re | Re | Gr | Re | Gr | Re | Gr | Gr
 | SESSION DATES |  | 2021-03-03 00:00:00 | 2021-03-10 00:00:00 | 2021-03-17 00:00:00 | 2021-03-24 00:00:00 | 2021-03-31 00:00:00 | 2021-04-07 00:00:00 | 2021-04-14 00:00:00 | 2021-04-21 00:00:00 | 2021-04-28 00:00:00 | 2021-05-05 00:00:00 | 2021-05-12 00:00:00 | 2021-05-19 00:00:00 | 2021-05-26 00:00:00 | AVERAGES
 | SESSION DAY COUNT
 | NUMBER OF ENTITIES
 | COUNTS AR! AR! AR!
Gr | Green things
Bl | Blue things
 | TOTAL THINGS
Re | Red non-things
_ | Orange non-things
 | TOTAL NON-THINGS
 | …and to confirm
 | PERCENTAGES
Gr | Green things
Bl | Blue things
 | TOTAL THINGS
Re | Red non-things
_ | Orange non-things
 | TOTAL NON-THINGS
 | …and to confirm
Gr | % of things = green
Bl | % of things = blue
Spreadsheet: 676984d1589127316-combine-different-formula-in-one-working
Sheet: RAMS

 | step 1 | step 2 | step3 | step 4
Crucial 16GB DDR4-2400 SODIMM
Crucial 8GB DDR4-3200 SODIMM
Crucial 16GB DDR4-3200 SODIMM
Crucial 4GB DDR4-2400 SODIMM
Crucial 4GB DDR4-3200 SODIMM
Crucial 4GB DDR4-2666 SODIMM
Crucial 32[NAME] (2 x 16GB) DDR4-2666 SODIMM
[NAME] • CL=17 • Dual Ranked • x8 based • Unbuffered • NON-ECC • DDR4-2400 • 1.2V • 2048Meg x 64 •
Crucial 16GB DDR4-2400 SODIMM
Crucial 16[NAME] (2 x 8GB) DDR4-2666 SODIMM
Crucial 8GB DDR4-3200 SODIMM
Crucial 16[NAME] (2 x 8GB) DDR4-3200 SODIMM
step 1 | get value if Column A contains "Crucial" and "DDR" but exclude "KIT".
step 2 | get all the data of column B removing all blanks
step 3 | remove the duplicate of column C.
step 4 | get all the data of column D removing all blanks
Spreadsheet: 750773d1633627700-if-then-else-false-error-book1
Sheet: 75Props

Row Labels | Sum of swl6-7 | Sum of swl7-8 | Sum of swl8-9 | Sum of swl9-10 | Sum of swl10-11 | Sum of swl11-12 | Sum of swl12-13 | Sum of swl15-16
Length | 6.5 | 7.5 | 8.5 | 9.49 | 10.5 | 11.5 | 12.49 | 15.5
Sum | 1127 | 226 | 185 | 132 | 30 | 18 | 18 | 5
Prop swl/swl
Cum prop
Total swl
Spreadsheet: 131182d1322775472-creating-a-dynamic-budget-setting-for-new-budget-example
Sheet: SETTINGS

 |  |  |  |  |  |  | INCOME |  |  |  | OUTITGOES
 | FREQUENCY |  | STATUS |  | FREQUENCY | Column1 | NAME | AMOUNT |  | FREQUENCY | TYPE | NAME | AMOUNT
 | 7 |  | IN |  | 2011-11-21 00:00:00 | 7 | CUSTOMER 1 | 55 |  | MONTHLY | DD | INVOICE 1 | -60
 | 14 |  | OUT |  | 2011-11-22 00:00:00 | 14 | CUSTOMER 2 | 120 |  | MONTHLY | DD | INVOICE 2 | -7.99
 | 28 |  | NOT PAID |  | 2011-11-23 00:00:00 | 28 | CUSTOMER 3 | 200 |  | MONTHLY | DD | INVOICE 3 | -53.09
 |  |  |  |  | 2011-11-24 00:00:00 | 28 | CUSTOMER 4 | 450 |  | MONTHLY | DD | INVOICE 4 | -12.37
 |  |  |  |  | 2011-11-25 00:00:00 | 28 | CUSTOMER 5 | 80 |  | MONTHLY | DD | INVOICE 5 | -37.97
 |  |  |  |  | 2011-11-28 00:00:00 | MONTHLY | CUSTOMER 6 | 1000 |  | MONTHLY | DC | INVOICE 6 | -14.99
 | HOLIDAYS
 | 2012-01-02 00:00:00
 | 2012-04-06 00:00:00
 | 2012-04-09 00:00:00
 | 2012-05-07 00:00:00
 | 2012-06-04 00:00:00
 | 2012-06-05 00:00:00
 | 2012-08-27 00:00:00
 | 2012-12-25 00:00:00
 | 2012-12-26 00:00:00
Spreadsheet: 58205d1258488595-excel-2007-sales-commission-formula-sample-commission-for-donkey
Sheet: Sheet1

50000 | 0 | 0 | 100000 |  | If we assume
 | 0.03 | 0.2 | 0.35
 | 0.03 | 0.17 | 0.15 |  | A1: base salary
 |  |  |  |  | B1: =0
250000 | 72500 |  |  |  | C1: =B1*2.5
 |  |  |  |  | D1: =C1+100000
 |  |  |  |  | Then if we want to make rates variable also let's put those in row below, ie
 |  |  |  |  | B2: =3%
 |  |  |  |  | C2: =20%
 |  |  |  |  | D2: =35%
 |  |  |  |  | To keep things simple in the calc itself let's then use the row below to calculate the incremental movement in each tier
 |  |  |  |  | B3: =B2-A2
 |  |  |  |  | copied across to D3
 |  |  |  |  | Now let's assume sales amount is entered into A5 and commission is to be calculated in B5
 |  |  |  |  | B5: =SUMPRODUCT(--($A5>$B$1:$D$1),$A5-$B$1:$D$1,$B$3:$D$3)
 |  |  |  |  | Your boss should then find by changing value(s) in A1/B2:D2/A5 so the output in B5 will adjust accordingly.
 |  |  |  |  | Hi,
 |  |  |  |  | My problem is similar to ShinyMagics:
 |  |  |  |  | http://www.excelforum.com/excel-gene...n-formula.html
 |  |  |  |  | My boss just gave me this spreadsheet and wants it done pronto. I may have given him the impression my excel skills were better than they actually are
 |  |  |  |  | Here is what I need to calculate:
 |  |  |  |  | Base salary paid
 |  |  |  |  | Up to 2.5 times base salary made in sales- 3%
 |  |  |  |  | Another 100000 on top of that is 20%
 |  |  |  |  | anything over that is 35%
 |  |  |  |  | So en example:
 |  |  |  |  | Base Salary 50000
 |  |  |  |  | up to 125000 earns 3% (3750)
 |  |  |  |  | 125001 to 225000 earns 20% (20000)
 |  |  |  |  | over 225001 earns 35% (8750)
 |  |  |  |  | So commission earnt is $32,500 on top of $50,000.
 |  |  |  |  | I used the formula DonkeyOte posted in the thread I mentioned above. I made it work for my figures, but only when I typed numbers, not added formulas instead.
 |  |  |  |  | How do I create a formula so that my boss can enter a different base salary and hypothetical sales amount and calculate the commission earnt?
Spreadsheet: fad5b8a5-2f62-4078-af17-06729998453b
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
BUTAS | Test | BUTAS | Butalbital, Serum | Butalbital, S | Gas Chromatography-Mass Spectrometry (GC-MS) | Plain, Red-Top Tube: Red |  |  | 1.5 | mL | Container/Tube: Red top [NAME]: 1.5 mL Collection Instructions: Spin down within 2 hours of draw. | 0.6 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Serum gel tube | <10 mcg/mL | Wednesday; 8 a.m. | 2 days | 8 days | 1 | 82205 |  |  |  |  | Rochester
BUTAS | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
BUTAS | Result | 8427 | Butalbital, S | Butalbital, S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 6895-7
Spreadsheet: 858328d1707053598-combined-two-operations-result-in-one-summary-sheet-shipment_receipt_report
Sheet: Summary

 | Offloading Expense by WH
 |  | Old WH |  | New WH |  |  | Offloading Expense Summary 2024
 | Month | Shipments Received | Outsourced Expense | Shipments Received2 | Outsourced Expense3 |  | Month | Shipments Received | Outsourced Expense
 | 2024-01-01 00:00:00 |  |  |  |  |  | 2024-01-01 00:00:00
 | 2024-02-01 00:00:00 |  |  |  |  |  | 2024-02-01 00:00:00
 | 2024-03-01 00:00:00 |  |  |  |  |  | 2024-03-01 00:00:00
 | 2024-04-01 00:00:00 |  |  |  |  |  | 2024-04-01 00:00:00
 | 2024-05-01 00:00:00 |  |  |  |  |  | 2024-05-01 00:00:00
 | 2024-06-01 00:00:00 |  |  |  |  |  | 2024-06-01 00:00:00
 | 2024-07-01 00:00:00 |  |  |  |  |  | 2024-07-01 00:00:00
 | 2024-08-01 00:00:00 |  |  |  |  |  | 2024-08-01 00:00:00
 | 2024-09-01 00:00:00 |  |  |  |  |  | 2024-09-01 00:00:00
 | 2024-10-01 00:00:00 |  |  |  |  |  | 2024-10-01 00:00:00
 | 2024-11-01 00:00:00 |  |  |  |  |  | 2024-11-01 00:00:00
 | 2024-12-01 00:00:00 |  |  |  |  |  | 2024-12-01 00:00:00
 | YTD Total |  |  |  |  |  | YTD Total
Spreadsheet: 763106d1641996293-wanting-to-highlight-out-of-specification-cells-in-excel-based-different-specifications-demo-sheet-2022
Sheet: Demo

Date | Time | Customer | Density | Absorption (W) | Absorption (O) | Moisture | <0,5 | 0.5 - 1.0 | 1.00-2.00 | 2.0 - 2.8 | 2.8 - 4.0 | 4.0 - 5.6 | 5.6 - 6.7 | 6.7 - 10 |  |  |  |  |  |  | Date | Time | Density 1 | Density 2 | Average |  | Cone 1 | +Sample 1 | Cone 2 | +Sample 2 | Cone 3 | +Sample 3 | +Water 1 | +Water 2 | +Water 3 | Result |  |  |  | Cone 1 | +Sample 1 | Cone 2 | +Sample 2 | Cone 3 | +Sample 3 | +Water 1 | +Water 2 | +Water 3 | Result |  |  |  | Moisture
 |  |  | G/L | % | % | % | % | % | % | % | % | % | % | %
2021-01-01 00:00:00 | 15:00:00 | Ford |  |  |  |  | 12.2 | 10 | 16 | 15 | 22 | 10.8 | 12 | 2 |  |  |  |  |  |  |  |  | 750 | 745 |  |  | 35 | 55 | 35 | 55 | 35 | 55 | 80 | 80 | 80 |  |  |  |  | 35 | 55 | 35 | 55 | 35 | 55 | 70 | 65 | 60 |  |  |  |  | 5.5
2021-01-01 00:00:00 | 15:00:00 | Renault |  |  |  |  | 5.2 | 10 | 16 | 15 | 22 | 17.8 | 12 | 2 |  |  |  |  |  |  |  |  | 800 | 800 |  |  | 35 | 55 | 35 | 55 | 35 | 55 | 70 | 70 | 60 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12.5
2021-01-01 00:00:00 | 15:00:00 | Volvo |  |  |  |  | 11.2 | 10 | 10 | 15 | 22 | 17.8 | 12.5 | 1.5 |  |  |  |  |  |  |  |  | 300 | 300 |  |  | 35 | 55 | 35 | 55 | 35 | 55 | 80 | 80 | 80 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15.5
2021-01-01 00:00:00 | 15:00:00 | Tesla |  |  |  |  | 6.2 | 15 | 10 | 15 | 22 | 17.8 | 12.5 | 1.5 |  |  |  |  |  |  |  |  | 900 | 900 |  |  | 35 | 55 | 35 | 55 | 35 | 55 | 80 | 80 | 80 |  |  |  |  | 35 | 55 | 35 | 55 | 35 | 55 | 65 | 65 | 50 |  |  |  |  | 12
2021-01-01 00:00:00 | 15:00:00 | Spar |  |  |  |  | 11.2 | 10 | 10 | 15 | 22 | 17.8 | 12.5 | 1.5 |  |  |  |  |  |  |  |  | 900 | 900 |  |  | 35 | 55 | 35 | 55 | 35 | 55 | 80 | 80 | 80 |  |  |  |  | 35 | 55 | 35 | 55 | 35 | 55 | 65 | 65 | 50 |  |  |  |  | 16
Spreadsheet: debra_perlingiere__8418__South Jersey Resources Master Phys 04022001
Sheet: AMASTPSA 

MASTER FIRM PURCHASE/SALE AGREEMENT INFORMATION SHEET
ENA Entity: | ENA | ATTORNEY:
DATE: | 2001-07-17 00:00:00 | ENA CONTACT:
COUNTERPARTY: | South Jersey Resources Group, LLC | CONTACT: | Mr. [NAME]
ADDRESS: | 1 South Jersey Plaza | TITLE:
 | Folsom, New Jersey 08037 | PHONE: | (609) 561-9000
 |  | FAX:
INCORPORATION STATE: |  | S&P RATING:
STRUCTURE | COUNTERPARTY | ENA ENTITY
COLLATERAL
THRESHOLD  in $ | 4000000 | 15000000
COMMITTED VOLUMES
THRESHOLD in $[NAME] | N/A | N/A
COLLATERAL REQUIRED FOR:
ALL TRADES
OTHER | N/A | N/A
COLLATERAL TYPE
Letter of Credit | OK | OK
Cash | OK | OK
COLLATERAL  MULTIPLE | 250000 | 250000
GUARANTOR (RATING) | South Jersey Industries, Inc. | Enron Corp. (BBB+)
LIMIT in $[NAME] | 5000000 | 15000000
Incorporation State: | NJ | OR
MATERIAL ADVERSE CHANGE TRIGGERS  APPLY TO:
-Counterparty
-Guarantor | X | X
Debt Ratings Change |  | X
-Below = |  | BBB- | Standard & Poor's
Financial Covenants | X
-Funded Debt/Net Worth | > 2:1
-Minimum Net worth
-EBITDA/Interest | < 3:1
-Current Ratio
Non-Specific
-Unilateral
Ownership Change
-Less than 51% owned by:
Non-Standard Definitions
-Funded Debt
-Net Worth
-Cash Flow
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty | 5000000
-Guarantor ($[NAME]) |  | 100000000
FIN'L STATEMENTS
-Standard | X | X | Upon request
CREDIT DECISION: | APPROVED:  X | DECLINED:
OUTSTANDING PHYSICAL TRADES: |  | YES:    X | NO:
ALL TRADES TO ROLL UP UNDER NEW MASTER: |  | YES:    X | NO:
OTHER COMMENTS | Current grty expires 11/31/01. The new grty should not have an expiration date.
Also working on ISDA which  will have a separate grty.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | Ext. 53923
Spreadsheet: 731397d1620321435-defining-a-pivot-table-column-in-a-sumif-formula-sample-data
Sheet: Data set

Data
classification | scheme | proposed budget | actual spend | detail | category 1 | category 2 | category 3 | category 4 | category 5 | category 6
x010 | address1 | 0 |  | apple, pear | a
x011 | address2 | 0 |  | orange, lemon | d
x012 | address3 | 0 |  | apple, pinapple | b
x013 | address4 | 100000 |  | grape | b
x014 | address5 | 200000 | 29000 | lemon | b
x015 | address6 | 300000 |  | pear | a
[NAME] | address7 | 400000 |  | clementine | a
x017 | address8 | 500000 |  | [NAME] and lemon | c
x018 | [NAME] | 600000 |  | blueberry | c
x019 | address10 | 0 |  | melon | d
x020 | address11 | 0 |  | melon, pear | d
x021 | address12 | 0 |  | cherry | a
x022 | [NAME] | 0 |  | grapes and cherry | a
x023 | address14 | 30000 |  | pear, lemon | b
x024 | address15 | 40000 |  | ginger | b
x025 | address16 | 50000 |  | carot | b
x026 | address17 | 0 |  | apple | b
Spreadsheet: 216268d1361677886-cannot-solve-this-value-error-please-help-degree-days
Sheet: Sheet1

65 | baseline
 | Date | T(low) | T(high) | Average | HDD | CDD
 | 2008-05-01 00:00:00 | 50 | 70
 |  | 57 | 72
 |  | 56 | 71
 |  | 55 | 72
 |  | 58 | 71
 |  | 60 | 67
 |  | 64 | 76
 |  | 66 | 74
 |  | 64 | 71
 |  | 63 | 73
 |  | 64 | 75
 |  | 45 | 75
 |  | 68
 |  | 70
 |  | 72
 |  | 71
 |  | 10
Spreadsheet: 1fa41163-0187-499f-be47-1122c8602d79
Sheet: Calculations

 |  | 2012 | 2012 |  |  | Required | Required | Required | Required | Total | 2011/12 UG | [NAME] | 2011/12 Projected | HeadCount Driven | 2011/12
 | BUDGET DIVISION | UG SCH | G SCH | UG Lab (HC) | G Lab (HC) | UG Fac. FTE | G Fac. FTE | UG Lab Fac | G Lab Fac | Faculty | Faculty Salaries | Faculty Salaries | SALARIES | ADMIN & SUPPORT | OPERATING | TOTAL ALLOCATION | HOLD HARMLESS | DIFFERENCE
 | President |  |  |  |  |  |  |  |  |  |  |  | 1033479
 | Provost |  |  |  |  |  |  |  |  |  |  |  | 2932244.71
 | Finance & Aministration |  |  |  |  |  |  |  |  |  |  |  | 6191740
 | Strategy, Planning & Policy |  |  |  |  |  |  |  |  |  |  |  | 1253406
 | Student Services & Enrollment Management |  |  |  |  |  |  |  |  |  |  |  | 1087604
 | Development |  |  |  |  |  |  |  |  |  |  |  | 362804
 | Agriculture
 | Art & Music
 | Biology
 | Chemistry & Biochemistry
 | Communication, Mass Media, & Theatre
 | English & Modern Langagues
 | Pol Science & Criminal Justice
 | History & Political Science
 | Mathematics & Computer Science
 | Physics
 | Accounting, Economics, & Finance
 | Aerospace Studies
 | Management & marketing
 | Security Studies & Criminal Justice
 | Teacher Education
 | Curriculum & Instruction
 | Kinesiology
 | Nursing
 | Athletic Training
 | Physical Therapy
 | Psychology, Sociology & Social Work
 | Academic Affairs
 | Facilities
Spreadsheet: 157546d1337786620-excel-2007-combining-data-from-two-worksheets-onto-one-and-sort-clientprocess
Sheet: APR_Clients

Client | Phone Call | Signed FPA | [NAME]? | Process CIW | Kick-off Meeting | [NAME] | Update CIW | Prepare Ass Doc | Send Ass Doc to Client | ESPlanner | Investment Analysis | Plan Delivery Meeting | Notes
C | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
D | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
E
Spreadsheet: 123673d1317801706-average-vlookup-over-multiple-sheets-test-data-file2
Sheet: 1

FLIGHT | TIMES
VX921 | 00:08:00
VX751 | 00:16:00
VX300 | 00:11:00
VX925 | 00:10:00
VX833 | 00:17:00
VX67 | 00:18:00
VX853 | 00:15:00
VX903 | 00:14:00
VX11 | 00:16:00
VX953 | 00:14:00
VX927 | 00:20:00
VX351 | 00:20:00
VX905 | 00:12:00
VX69 | 00:17:00
[NAME] | 00:19:00
VX753 | 00:13:00
VX23 | 00:21:00
VX251 | 00:17:00
VX929 | 00:13:00
VX961 | 00:21:00
VX837 | 00:19:00
VX909 | 00:14:00
VX861 | 00:21:00
VX945 | 00:19:00
VX755 | 00:01:00
VX947 | 00:18:00
VX913 | 00:18:00
VX305 | 00:24:00
VX27 | 00:15:00
[NAME] | 00:26:00
VX949 | 00:20:00
VX759 | 00:15:00
VX349 | 00:24:00
VX865 | 00:16:00
VX969 | 00:14:00
VX917 | 00:12:00
VX77 | 00:19:00
VX29 | 00:24:00
VX357
Spreadsheet: 1bf61dbf-57c4-4c71-b60e-b228eb5c2fdd
Sheet: Sheet1

Unnamed: 0 | WNCLAA SCHEDULE FOR 6-HOUR TRAINING COURSE | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Date:  4/24/13 |  |  | “OPERATIONS TRAINING”
 |  | MEETING AGENDA |  |  | $45.00/person (payable to WNCLAA)
Brief intro for speakers at 8:00am |  |  |  |  | [NAME] (2-3 minutes)
SPEAKER: | NICOLE JOHNSTON |  | (Introduction of day, emergency procedures, etc.) |  |  | (WNCLAA Chair)
8:00am to 9:00am |  |  | 1.00 hour (1.0 hour)
SPEAKER: | GARRY HAGER |  | "PUMP STATION SELECTION" |  |  | (Pete Duty & Associates, Inc.)
9:00am to 10:00am |  |  | 1.00 hour (1 hour)
SPEAKER: | ELLEN HUFFMAN |  | "SLUDGE 101" |  |  | (Former NCDENR employee)
10:00am to 10:15am |  | BREAK
 | (refreshments available)
10:15am to 11:45pm |  |  | 1.50 hour (1.5 hour)
SPEAKER: | [NAME] |  | "ACTIVATED SLUDGE MICROBIOLOGY" |  |  | (NCDENR)
11:45am to 12:30pm | MONTE WALL, LISA TRIPLETT, WHITNEY MUNROE |  | 0.75 hour (0.75 hour)
SPEAKER: |  |  | "WHAT IF?" GROUP DISCUSSION & SURVEY FORM |  |  | (WNCLAA Committee Members)
12:30pm to 1:45pm |  | LUNCH | V
 | (on your own) |  | v
1:45pm to 3:30pm |  |  | 1.75 hours (1.75 hours)
SPEAKER: | ORC & WWTP STAFF |  | "WWTP TOUR" |  |  | (McDowell Creek WWTP Staff)
 |  | TOTAL | 6.00 hours
Spreadsheet: 858815d1707345963-index-match-mmult-fomula-not-working-properly-formula-help
Sheet: Issue

ID # | data 1 | data2 | data3 | data4 | data5 | [NAME]
1000 | 2 | 3 | 5 | 449
 | 91 | 92 | 93 | 94 | 95
 | 96
 | 97 | 98 | 99 | 100 | 101 |  |  |  | the problem with the formula starts when I add data to column G. as soon as I do, the formula just reverts to always referencing the last used ID #. i have no idea why. In this example, after adding data to cell G6, all of the following rows have 1003 in column A, even though they dont match any data. see next sheet for how i expect it to function.
 | 97 | 98 | 99 | 100 | 101 | 134
 | 102 | 104 | 417
 | 103 | 104 | 417
 | 102 | 103 | 104 | 417
 | 105 | 106 | 107 | 108 | 466
 | 105 | 106 | 107 | 108 | 466
 | 109
 | 110 | 111 | 112 | 415
 | 110 | 111 | 112 | 415
 | 110 | 111 | 112 | 415
 | 113 | 114 | 115 | 116 | 420
 | 113 | 114 | 115 | 116 | 420
 | 113 | 114 | 115 | 116 | 420
 | 113 | 114 | 115 | 116 | 420
 | 117 | 118 | 371
 | 117 | 118 | 371
 | 119
 | 120
 | 121 | 398
 | 122 | 123 | 403
 | 122 | 123 | 403
 | 124
 | 125 | 126 | 127 | 461
 | 125 | 126 | 127 | 461
 | 125 | 126 | 127 | 461
 | 128 | 129 | 130 | 459
 | 128 | 129 | 130 | 459
 | 128 | 129 | 130 | 459
 | 131 | 493
 | 132
 | 133 | 134 | 135 | 416
 | 133 | 134 | 135 | 416
 | 133 | 134 | 135 | 416
 | 136 | 137 | 388
 | 136 | 137
 | 138 | 139 | 140 | 141 | 142
 | 138 | 139 | 140 | 141 | 142
 | 138 | 139 | 140 | 141 | 142
 | 138 | 139 | 140 | 141 | 142
 | 138 | 139 | 140 | 141 | 142
Spreadsheet: 732602d1621035884-sum-not-working-correctly-excelforum
Sheet: Feestdagen

Datum | Reden
2021-01-01 00:00:00 | Nieuwjaarsdag
2021-04-02 00:00:00 | Goede vrijdag
2021-04-04 00:00:00 | 1e Paasdag
2021-04-05 00:00:00 | 2e Paasdag
2021-04-27 00:00:00 | Koningsdag
2021-05-05 00:00:00 | [NAME]
2021-05-13 00:00:00 | Hemelvaartsdag
2021-05-23 00:00:00 | 1e Pinksterdag
2021-05-24 00:00:00 | 2e Pinksterdag
2021-12-25 00:00:00 | 1e Kerstdag
2021-12-26 00:00:00 | 2e Kerstdag
----------------------------------------
Spreadsheet: 121290d1315981152-finding-the-lowest-value-based-on-multiple-text-criteria-book2
Sheet: Sheet1

Project Name | [NAME] | Minimum Value |  | Imported Data: | ID | Data
Name1 | P01 | 9 |  |  | 1 Name1 P02 | 10
 | P02 | 10 |  |  | 2 Name1 P01 | 51
 | P03 |  |  |  | 3 Name2 P01 | 21
[NAME] | P01 |  |  |  | 4 Name1 P03 | 3
 | P02 |  |  |  | 5 Name2 P02 | 17
 | P03 |  |  |  | 6 Name1 P03 | 35
 |  |  |  |  | 7 Name2 P03 | 42
 |  |  |  |  | 8 Name1 P01 | 9
Spreadsheet: 888688d1739269915-returning-a-series-of-non-empty-results-based-on-a-reference-le-five-paris-17
Sheet: Rank Calcs

 | MATCH PLAYED (CUMULATIVE)
 | MATCH PLAYED (CUMULATIVE)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GOALS
 | Players | P | W | D | L | GF | GA | [NAME] | Pts | Win % | PPG | PPG | Pts | [NAME] | Played | Name | TOTAL | RANK | Players | P | W | D | L | GF | GA | Pts | Win % | PPG | PPG | Pts | [NAME] | Played | PPG | Pts | [NAME] | Played | Name | TOTAL | RANK | Goals | Played | Adjust. | Average | AVG | Goals | Name | Played | TOTAL | RANK | Players | Played | Adjust.
 | MATCH PLAYED (CUMULATIVE)
 |  | W1 | [NAME] | W3 | W4 | W5 | W6 | W7 | W8 | W9 | W10 | W11 | W12 | W13 | W14 | W15 | W16 | W17 | W18 | W19 | W20 | W21 | [NAME] | W23 | W24 | W25
 | MATCH RESULTS
 |  | W1 | [NAME] | W3 | W4 | W5 | W6 | W7 | W8 | W9 | W10 | W11 | W12 | W13 | W14 | W15 | W16 | W17 | W18 | W19 | W20 | W21 | [NAME] | W23 | W24 | W25
 | WINS
 |  | W1 | [NAME] | W3 | W4 | W5 | W6 | W7 | W8 | W9 | W10 | W11 | W12 | W13 | W14 | W15 | W16 | W17 | W18 | W19 | W20 | W21 | [NAME] | W23 | W24 | W25
 | DRAWS
 |  | W1 | [NAME] | W3 | W4 | W5 | W6 | W7 | W8 | W9 | W10 | W11 | W12 | W13 | W14 | W15 | W16 | W17 | W18 | W19 | W20 | W21 | [NAME] | W23 | W24 | W25
 | LOSSES
 |  | W1 | [NAME] | W3 | W4 | W5 | W6 | W7 | W8 | W9 | W10 | W11 | W12 | W13 | W14 | W15 | W16 | W17 | W18 | W19 | W20 | W21 | [NAME] | W23 | W24 | W25
 | POINTS (WEEKLY)
 |  | W1 | [NAME] | W3 | W4 | W5 | W6 | W7 | W8 | W9 | W10 | W11 | W12 | W13 | W14 | W15 | W16 | W17 | W18 | W19 | W20 | W21 | [NAME] | W23 | W24 | W25 | TOTAL
 | POINTS (CUMULATIVE)
 |  | W1 | [NAME] | W3 | W4 | W5 | W6 | W7 | W8 | W9 | W10 | W11 | W12 | W13 | W14 | W15 | W16 | W17 | W18 | W19 | W20 | W21 | [NAME] | W23 | W24 | W25
 | POINTS PER GAME
 |  | W1 | [NAME] | W3 | W4 | W5 | W6 | W7 | W8 | W9 | W10 | W11 | W12 | W13 | W14 | W15 | W16 | W17 | W18 | W19 | W20 | W21 | [NAME] | W23 | W24 | W25
 | RANKING
 |  | W1 | [NAME] | W3 | W4 | W5 | W6 | W7 | W8 | W9 | W10 | W11 | W12 | W13 | W14 | W15 | W16 | W17 | W18 | W19 | W20 | W21 | [NAME] | W23 | W24 | W25
 | GOALS FOR (WEEKLY)
 |  | W1 | [NAME] | W3 | W4 | W5 | W6 | W7 | W8 | W9 | W10 | W11 | W12 | W13 | W14 | W15 | W16 | W17 | W18 | W19 | W20 | W21 | [NAME] | W23 | W24 | W25 | TOTAL
 | GOALS FOR (CUMULATIVE)
 |  | 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
 | GOALS AGAINST (WEEKLY)
 |  | W1 | [NAME] | W3 | W4 | W5 | W6 | W7 | W8 | W9 | W10 | W11 | W12 | W13 | W14 | W15 | W16 | W17 | W18 | W19 | W20 | W21 | [NAME] | W23 | W24 | W25 | TOTAL
 | GOALS AGAINST (CUMULATIVE)
 |  | W1 | [NAME] | W3 | W4 | W5 | W6 | W7 | W8 | W9 | W10 | W11 | W12 | W13 | W14 | W15 | W16 | W17 | W18 | W19 | W20 | W21 | [NAME] | W23 | W24 | W25