tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 101339d1299496906-excel-2007-combining-numeric-data-from-several-spreadsheets-into-a-master-spreadsheet-template_blank_form
Sheet: Sheet1

SUMMARY |  |  | AMOUNT
Section 1: |  | £
Section 2: |  | £
Section 3: |  | £
Section 4: |  | £
Section 5: |  | £
Section 6: |  | £
form total: |  | £
 |  | £
 |  | £
Amount: |  | £
Beneficiary | amount |  | Beneficiary | amount
Supplier 1 |  |  | Supplier 27
Supplier 2 |  |  | Supplier 28
Supplier 3 |  |  | etc
Supplier 4 |  |  | etc
Supplier 5 |  |  | etc
Supplier 6
Supplier 7
Supplier 8
Supplier 9
etc
etc
etc
Supplier 26 |  |  | etc
 |  |  | Supplier 53
Total Section 1 | total amount |  | Total Section 2 | total amount
 |  |  |  | amount
Supplier 54 |  |  | Supplier 81
Supplier 55 |  |  | Supplier 82
 |  |  |  | total amount
 |  |  |  | amount
Supplier 102 |  |  | Supplier 124
Supplier 103 |  |  | Supplier 125
 |  |  |  | total amount
Spreadsheet: 808858d1670709335-countif-or-counta-centre-across-selection-timetable
Sheet: Term 1

LSU Teacher Timetable |  | T1 | Week | 1 | 2023-01-30 00:00:00 |  | Class 1 | Class 2 | Class 3 | Class 4 | Class 5 | Class 6 | Class 7 | N-A
Day | Teacher | 7 AM | 8 AM | 9 AM | 10 AM | 11 AM | 12 PM | 1 PM | 2 PM | 3 PM | 4 PM | 5 PM | 6 PM | 7 PM | 8 PM | 9 PM | 10 PM | Total teaching
 | Teacher 1 | x
 | Teacher 2 |  |  |  |  |  | 12.00-3.00 |  |  |  |  |  | 6.00-8.00
 | Teacher 3 |  |  | 9.30-12.30
 | Teacher 4 |  |  |  |  |  | 12.30-2.30 |  |  |  |  |  | 6.00-8.00
 | Teacher 5 |  |  |  | 10.00-12.00 |  |  |  |  |  |  |  | 6.00-8.00
 | Teacher 1 |  |  | 9.00-3.30 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 | Teacher 2 |  | 8.00-9.00 |  | 10.00-1.00 |  |  |  |  |  |  |  |  |  |  |  |  | 4
 | Teacher 3 | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Teacher 4 |  |  | 9.00-12.00 |  |  | 12.30-3.30 |  |  |  |  |  |  |  |  |  |  | 6
 | Teacher 5 |  |  | 9.00-12.00 |  |  |  |  |  |  |  |  | 6.00-8.00 |  |  |  |  | 5
 | Teacher 1 |  |  | 9.00-3.30 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 | Teacher 2 |  |  | 9.00-12.00 |  |  |  | 1.00-3.00 |  |  |  |  |  |  |  |  |  | 5
 | Teacher 3 |  |  |  |  |  |  |  | 2.00-4.00 |  |  |  |  |  |  |  |  | 2
 | Teacher 4 |  |  | 9.30-12.00 |  |  | 12.30-3.00 |  |  |  |  |  | 6.00-8.00 |  |  |  |  | 7
 | Teacher 5 |  |  | 9.00-12.00 |  |  |  |  | 2.00-4.00 |  |  |  | 6.00-8.00 |  |  |  |  | 7
Spreadsheet: 1de2ef0e-999d-40eb-863d-cf023a8ab332
Sheet: L

Course color corresponds with term of offering. ORANGE for Fall semester, PURPLE for J-term, GREEN for both Fall and J-term.
 | AOK Designation | CAR Designation | Comment
Latin
LATN 211-212 | Foreign Language
LATN 215 | Foreign Language
LATN 341 | Arts & Literature-Literature
LATN 342 | Arts & Literature-Literature
LATN 343 | Arts & Literature-Literature
LATN 344 | Arts & Literature-Literature
LATN 345 | Arts & Literature-Literature
LATN 346 | Arts & Literature-Literature
LATN 347 | Arts & Literature-Literature
LATN 348 | Arts & Literature-Literature
LATN 481-482 |  | Experiential-Research
LATN 487-488 |  | Experiential-Research
LATN 496-498 |  | Experiential-Research
Spreadsheet: 800397d1665652527-filter-and-sort-formulas-sample
Sheet: Sheet1

 | Task | Type | Task ID | Priority | Start | End | Status |  | Target> | sort by End Date all active tasks, excluding "Completed" on Sheet 2
 | Task 1 | Various 1 | T1 | High | 2022-10-13 00:00:00 | 2022-12-31 00:00:00 | Completed |  | [NAME] is to get last active 14 tasks
 | Task 2 | Various 2 | T2 | High | 2022-09-25 00:00:00 | 2022-12-16 00:00:00 | Planned
 | Task 3 | Various 3 | T3 | High | 2022-09-07 00:00:00 | 2022-12-01 00:00:00 | Completed
 | Task 4 | Various 4 | T4 | High | 2022-08-20 00:00:00 | 2022-11-16 00:00:00 | Behind
 | Task 5 | Various 5 | T5 | High | 2022-08-02 00:00:00 | 2022-11-01 00:00:00 | Stalled
 | Task 6 | Various 6 | T6 | High | 2022-07-15 00:00:00 | 2022-10-17 00:00:00 | Stalled
 | Task 7 | Various 7 | T7 | High | 2022-06-27 00:00:00 | 2022-10-02 00:00:00 | Completed
 | Task 8 | Various 8 | T8 | High | 2022-06-09 00:00:00 | 2022-09-17 00:00:00 | Completed
 | Task 9 | Various 9 | T9 | High | 2022-05-22 00:00:00 | 2022-09-02 00:00:00 | Planned
 | Task 10 | Various 10 | T10 | High | 2022-05-04 00:00:00 | 2022-08-18 00:00:00 | Stalled
 | Task 11 | Various 11 | T11 | High | 2022-04-16 00:00:00 | 2022-08-03 00:00:00 | Stalled
 | Task 12 | Various 12 | T12 | High | 2022-03-29 00:00:00 | 2022-07-19 00:00:00 | Stalled
 | Task 13 | Various 13 | T13 | High | 2022-03-11 00:00:00 | 2022-07-04 00:00:00 | Planned
 | Task 14 | Various 14 | T14 | High | 2022-02-21 00:00:00 | 2022-06-19 00:00:00 | Completed
 | Task 15 | Various 15 | T15 | High | 2022-02-03 00:00:00 | 2022-06-04 00:00:00 | Behind
 | Task 16 | Various 16 | T16 | High | 2022-01-16 00:00:00 | 2022-05-20 00:00:00 | Behind
 | Task 17 | Various 17 | T17 | High | 2021-12-29 00:00:00 | 2022-05-05 00:00:00 | Completed
 | Task 18 | Various 18 | T18 | High | 2021-12-11 00:00:00 | 2022-04-20 00:00:00 | Completed
 | Task 19 | Various 19 | T19 | High | 2021-11-23 00:00:00 | 2022-04-05 00:00:00 | Planned
 | Task 20 | Various 20 | T20 | High | 2021-11-05 00:00:00 | 2022-03-21 00:00:00 | In Progress
 | Task 21 | Various 21 | T21 | High | 2021-10-18 00:00:00 | 2022-03-06 00:00:00 | In Progress
 | Task 22 | Various 22 | T22 | High | 2021-09-30 00:00:00 | 2022-02-19 00:00:00 | In Progress
 | Task 23 | Various 23 | T23 | High | 2021-09-12 00:00:00 | 2022-02-04 00:00:00 | Planned
 | Task 24 | Various 24 | T24 | High | 2021-08-25 00:00:00 | 2022-01-20 00:00:00 | Completed
 | Task 25 | Various 25 | T25 | High | 2021-08-07 00:00:00 | 2022-01-05 00:00:00 | Completed
 | Task 26 | Various 26 | T26 | High | 2021-07-20 00:00:00 | 2021-12-21 00:00:00 | Completed
 | Task 27 | Various 27 | T27 | High | 2021-07-02 00:00:00 | 2021-12-06 00:00:00 | Planned
 | Task 28 | Various 28 | T28 | High | 2021-06-14 00:00:00 | 2021-11-21 00:00:00 | Planned
 | Task 29 | Various 29 | T29 | High | 2021-05-27 00:00:00 | 2021-11-06 00:00:00 | Planned
 | Task 30 | Various 30 | T30 | High | 2021-05-09 00:00:00 | 2021-10-22 00:00:00 | Planned
 | Task 31 | Various 31 | T31 | High | 2021-04-21 00:00:00 | 2021-10-07 00:00:00 | Planned
 | Task 32 | Various 32 | T32 | High | 2021-04-03 00:00:00 | 2021-09-22 00:00:00 | Planned
Spreadsheet: 867443d1714300720-how-to-summarise-dependent-totals-on-a-single-data-set-sample-275-aligw
Sheet: Pivot

Row Labels | Count of samAccountName | Column to show how many of each of these have a password greater than 10 days old | Column to show how many of the retun of column C also have a password set to never expire | How do I add columns in a pivot table anyway
OU=SERVICE Accounts,OU=IT,OU=New Users | 4
OU=Admin Accounts,OU=IT,OU=New Users | 3
OU=Prod2,OU=ADH,OU=New Servers | 2
Grand Total | 9
Spreadsheet: 758141d1638697942-hyperlink-function-make-result-independant-from-source-text-url-cells-dna
Sheet: Sheet2

link | cM | combined
https://www.ancestry.com.au/discoveryui-matches/compare/FBC90D17-28A5-4E31-9D14-85B0245CF797/with/00BAB0C5-2F1B-4E9C-81EB-562C70621FC2 | 33
https://www.ancestry.com.au/discoveryui-matches/compare/FBC90D17-28A5-4E31-9D14-85B0245CF797/with/00C98E8D-9974-4CCD-A6DE-C23982C2AE31 | 11
https://www.ancestry.com.au/discoveryui-matches/compare/FBC90D17-28A5-4E31-9D14-85B0245CF797/with/00F40993-0C73-4A56-930C-7115F4E2EAA1 | 11
https://www.ancestry.com.au/discoveryui-matches/compare/FBC90D17-28A5-4E31-9D14-85B0245CF797/with/0133496C-0224-46A4-921A-62C8BF0E9715 | 8
https://www.ancestry.com.au/discoveryui-matches/compare/FBC90D17-28A5-4E31-9D14-85B0245CF797/with/015384DA-02DA-478F-A5FA-90D269244F39 | 10
https://www.ancestry.com.au/discoveryui-matches/compare/FBC90D17-28A5-4E31-9D14-85B0245CF797/with/018F184F-357E-42B8-95A1-82E19D2FA18F | 13
https://www.ancestry.com.au/discoveryui-matches/compare/FBC90D17-28A5-4E31-9D14-85B0245CF797/with/01BDD817-817F-405B-91E4-D26CD0BD7582 | 10
https://www.ancestry.com.au/discoveryui-matches/compare/FBC90D17-28A5-4E31-9D14-85B0245CF797/with/01BE26DC-307F-494E-9657-B2E8FD493ED8 | 11
Spreadsheet: 6f84a86b-4a7c-4e16-bd00-f744e1dd4ee2
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Raschau-Markersbach - Variante 1
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 20 | 782 | 785 | 748 | 671
20 - 60 | 2807 | 2434 | 2083 | 1845
60 und mehr | 1872 | 2000 | 2072 | 2072
Insgesamt | 5461 | 5219 | 4903 | 4588
%
unter 20 | 14.31972166269914 | 15.041195631347 | 15.25596573526412 | 14.62510897994769
20 - 60 | 51.4008423365684 | 46.63728683655873 | 42.48419335100959 | 40.21360069747166
60 und mehr | 34.27943600073247 | 38.32151753209428 | 42.25984091372629 | 45.16129032258064
Insgesamt | 100 | 100 | 100 | 100
Abhängigkeitsquotient
Jugendquotient | 27.85892411827574 | 32.25143796220213 | 35.90974555928948 | 36.36856368563686
Altenquotient | 66.6904168151051 | 82.16926869350863 | 99.47191550648104 | 112.3035230352303
Gesamtquotient | 94.54934093338083 | 114.4207066557108 | 135.3816610657705 | 148.6720867208672
Gebietsstand: | 1. Januar 2012
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: 89666d1289423472-vlookup-index-match-sample-1-
Sheet: Sheet1

 | RANK | NAME | TOTALS
 | 1 | I | 500 | I | 500
 | 2 | J | 260 | J | 260
 | 3 | H | 160 | H | 160
 | 4 | B | 150 | B | 150
 | 5 | F | 120 | F | 120
 | 6 | G | 115 | G | 115
 | 7 | A | 100 | A | 100
 | 8 | E | 80 | E | 80
 | 9 | C | 50 | C | 50
 | 10 | D | 25 | D | 25
Spreadsheet: 328510d1403921930-conditional-formatting-changing-a-color-of-a-cell-if-duplicated-in-another-cell-roster-setup
Sheet: WEST SIDE STATION SETUP

ASSOCIATES | POSITION |  | WEST   SIDE   STATIONS
 |  | OPEN AREA    -    NO SETUP | S/M/L |  | Line 1    PG    &    PS    AREA | S/M/L |  | Line 2    PA    &    PS    AREA | LP |  | HRV   PS   AREA | HRV |  | HRV  INSPECT AREA | Prep |  | PREP   PG  &  PS  AREA
 |  |  | Line 1-1 | Line 1-15 |  | Line 2-1 | Line 2-15 |  | Line 3-1 | Line 3-15 |  | Line 4-1 | Line 4-15 |  | Line 5-1 | Line 5-13
 |  |  | Line 1-2 | Line 1-16 |  | Line 2-2 | Line 2-16 |  | Line 3-2 | Line 3-16 |  | Line 4-2 | Line 4-16 |  | Line 5-2 | Line 5-14
 |  |  | Line 1-3 | Line 1-17 |  | Line 2-3 | Line 2-17 |  | Line 3-3 | Line 3-17 |  | Line 4-3 | Line 4-17 |  | Line 5-3 | Line 5-15
 |  |  | Line 1-4 | Line 1-18 |  | Line 2-4 | Line 2-18 |  | Line 3-4 | Line 3-18 |  | Line 4-4 | Line 4-18 |  | Line 5-4 | Line 5-16
 |  |  | Line 1-5 | Line 1-19 |  | Line 2-5 | Line 2-19 |  | Line 3-5 | Line 3-19 |  | Line 4-5 | Line 4-19 |  | Line 5-5 | Line 5-17
 |  |  | Line 1-6 | Line 1-20 |  | Line 2-6 | Line 2-20 |  | Line 3-6 | Line 3-20 |  | Line 4-6 | Line 4-20 |  | Line 5-6 | Line 5-18
 |  |  | Line 1-7 | Line 1-21 |  | Line 2-7 | Line 2-21 |  | Line 3-7 | Line 3-21 |  | Line 4-7 | Line 4-21 |  | Line 5-7 | Line 5-19
 |  |  | Line 1-8 | Line 1-22 |  | Line 2-8 | Line 2-22 |  | Line 3-8 | Line 3-22 |  | Line 4-8 | Line 4-22 |  | Line 5-8 | Line 5-20
 |  |  | Line 1-9 | Line 1-23 |  | Line 2-9 | Line 2-23 |  | Line 3-9 | Line 3-23 |  | Line 4-9 | Line 4-23 |  | Line 5-9 | Line 5-21
 |  |  | Line 1-10 | Line 1-24 |  | Line 2-10 | Line 2-24 |  | Line 3-10 | Line 3-24 |  | Line 4-10 | Line 4-24 |  | Line 5-10 | Line 5-22
 |  |  | Line 1-11 | Line 1-25 |  | Line 2-11 | Line 2-25 |  | Line 3-11 | Line 3-25 |  | Line 4-11 | Line 4-25 |  | Line 5-11 | Line 5-23
 |  |  | Line 1-12 | Line 1-26 |  | Line 2-12 | Line 2-26 |  | Line 3-12 | Line 3-26 |  | Line 4-12 | Line 4-26 |  | Line 5-12 | Line 5-24
 |  |  | Line 1-13 | Line 1-27 |  | Line 2-13 | Line 2-27 |  | Line 3-13 | Line 3-27 |  | Line 4-13 | Line 4-27
 |  |  | Line 1-14 | Line 1-28 |  | Line 2-14 | Line 2-28 |  | Line 3-14 | Line 3-28 |  | Line 4-14 | Line 4-28
 |  |  |  | Line 1-29 |  |  | Line 2-29 |  |  | Line 3-29 |  |  | Line 4-29
 |  |  |  | Line 1-30 |  |  | Line 2-30 |  |  | Line 3-30 |  |  | Line 4-30
Spreadsheet: 848234d1698998459-let-unique-formula-only-display-results-based-on-text-in-column-unique-values-test-05
Sheet: Sheet1

DATE | SHIFT | PATRON | CR # | ISSUES | STATUS |  | NAME | NUMBER | TRANS | TOTAL
 |  | JOE | 123 | 10 | PAID
 |  | JOE | 123 | 15 | OS
 |  | SUE | 456 | 30 | OS
 |  | MARK | 789 | 5 | PAID
 |  | LISA | 12 | 20 | PAID
 |  | SUE | 456 | 60 | OS
 |  | JOE | 123 | 80 | OS |  | PATRON | CR # | Count | sum
 |  | JOE | 123 | 15 | PAID |  | JOE | 123 | 2 | 95
 |  | SUE | 888 | 10 | PAID |  | SUE | 456 | 2 | 90
 |  | SUE | 888 | 10 | PAID
Spreadsheet: fb93593a-5ed9-4eee-9780-96493eafb5de
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | U.S. Census Bureau
 |  | Source: Quarterly Services Survey
 |  | 51: Information: U.S. Total
 |  | Seasonally Adjusted Total Revenue [Millions of Dollars]
 |  | Period: 2003 to 2013
 |  | Data Extracted on: March 11, 2014 (11:57 pm)
Year | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter
2003 | X | X | X | 229371
2004 | 229175 | 233474 | 235336 | 238105
2005 | 241837 | 244380 | 247183 | 247443
2006 | 250954 | 254990 | 258328 | 262731
2007 | 263776 | 266272 | 270025 | 272054
2008 | 276013 | 278199 | 280692 | 273583
2009 | 267567 | 267416 | 268461 | 271132
2010 | 273221 | 275247 | 279408 | 281844
2011 | 284136 | 290132 | 292370 | 293684
2012 | 296354 | 298357 | 300019 | 308848
2013 | 309155 | 311078 | 314603 | X
Spreadsheet: 020b1087-5be6-489a-aa1f-70297ca3c691
Sheet: Miscellaneous Services

[NAME]
Item # | Item | Year | Install Price | Deinstall Price | Move Price | Relocate Price
 | Mail box | 1 | 11.67
 | (key system) | 2 | 11.91
 |  | 3 | 12.15
 |  | 4 | 12.39
 |  | 5 | 12.64
 | Program change to voice mailbox | 1 | 11.67
 | First on an order | 2 | 11.91
 | (key system) | 3 | 12.15
 |  | 4 | 12.39
 |  | 5 | 12.64
 | Program change to voice mailbox | 1 | 4.67 | 11.67 | 11.67 | 11.67
 | each additional on same order | 2 | 4.76 | 11.91 | 11.91 | 11.91
 | (key system) | 3 | 4.88 | 12.15 | 12.15 | 12.15
 |  | 4 | 4.98 | 12.39 | 12.39 | 12.39
 |  | 5 | 5.05 | 12.64 | 12.64 | 12.64
 | Active automated attendent | 1 | 166.76 | 70.04 | 280.17 | 373.56
 | Per Layer | 2 | 190.52 | 71.44 | 285.77 | 381.03
 | (key system) | 3 | 194.33 | 72.87 | 291.49 | 388.65
 |  | 4 | 198.21 | 74.33 | 297.32 | 396.42
 |  | 5 | 202.18 | 75.82 | 303.27 | 404.35
Spreadsheet: hunter_shively__12696__11-20 Enovate
Sheet: ENOVATE DPR

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ENOVATE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAILY POSITION REPORT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | As of November 20, 2001
 |  |  |  |  |  |  |  | In thousands (000's)
 |  | Position |  |  | Maturity / Gap Risk |  |  | Value-at-Risk |  |  |  | P&L ($000)
Business Unit - Commodity Group |  | Net Open | Limit |  | Sensitivity | Limit |  | 1-Day |  | Limit |  | Today | 5 Day Rolling | MTD | QTD | YTD
ENOVATE |  |  |  |  |  |  |  |  |  |  |  | -171.5877995950032 | -766.1201589759894 | 128.6245778820183 | -4078.375422117982 | -4078.184422117982
GAS TRADING |  | -3.713757520302805 | 10 Bcf |  | -2.4682094986626 | 20 Bcf |  | 823.286184048893 |  | 2000 |  | -171.5877995950032 | -766.1201589759894 | 128.6245778820183 | -4078.375422117982 | -4078.184422117982
Short Term Trading |  | -0.4378201308999998 |  |  |  |  |  | 823 |  | 2000 | -172 | -171.5877995950032 | -766.1201589759894 | 128.6245778820183 | -4078.375422117982 | -4078.184422117982
Long Term Trading |  | -3.275937389402805 |  |  |  |  |  |  |  | -2000 |  | 0 | 0 | 0 | 0 | 0
Spreadsheet: 89479d1289270747-summing-countif-results-copy-of-hamshire
Sheet: Hamshire

Accounts | Revenue | Toys | Minimum | Maximum | # Between Range | Sumproduct
Hamshire 1 | 3273.18 | 717 | 0 | 500 | 8 | 489
Hamshire 2 | 646.11 | 207 | 500 | 1000 | 1 | 594
Hamshire 3 | 58.15 | 25 | 1000 | 1500 | 0 | 0
Hamshire 4 | 500 | 6 | 1500 | 2000 | 1 | 318 |  | COUNTIF($B$2:$B$20,">="&$D2)-COUNTIF($B$2:$B$20,">"&$E2)
Hamshire 5 | 500 | 25 | 2000 | 2500 | 2 | 644
Hamshire 6 | 8000 | 15 | 2500 | 3000 | 0 | 0
Hamshire 7 | 4300 | 11 | 3000 | 3500 | 1 | 717
Hamshire 8 | 2200 | 91 | 3500 | 4000 | 0 | 0
Hamshire 9 | 500 | 89 | 4000 | 4500 | 1 | 11
Hamshire 10 | 6200 | 16 | 4500 | 5000 | 0 | 0
Hamshire 11 | 8500 | 94 | 5000 | 5500 | 0 | 0
Hamshire 12 | 500 | 253 | 5500 | 6000 | 0 | 0
Hamshire 13 | 9000 | 106 | 6000 | 6500 | 1 | 16
Hamshire 14 | 500 | 14 | 6500 | 7000 | 0 | 0
Hamshire 15 | 0 | 0 | 7000 | 7500 | 0 | 0
Hamshire 16 | 1687.34 | 318 | 7500 | 8000 | 1 | 15
Hamshire 17 | 295.8 | 77 | 8000 | 8500 | 1 | 109
Hamshire 18 | 9200 | 106 | 8500 | 9000 | 1 | 200
Hamshire 19 | 2221.62 | 553 | 9000 | 9500 | 1 | 212
Spreadsheet: 714697d1611331228-assisted-needed-with-matching-multiple-fields-excel-match-help
Sheet: Sheet1

Original Regular System |  |  | Original Matching "I" system |  |  | GOAL Full Alignment of Regular with *i* system
IP Address: | System Name: |  | IP Address: | System Name: |  | IP Address: | System Name: | *i* IP Address: | *i* System Name:
1.10.11.1 | Computer 1 |  | 2.10.9.3 | Computer 2i |  | 1.10.11.1 | Computer 1 | 2.10.10.10 | Computer 1i
1.10.11.2 | Computer 2 |  | 2.10.9.2 | Computer 9i |  | 1.10.11.2 | Computer 2 | 2.10.9.3 | Computer 2i
1.10.11.3 | Computer 3 |  | 2.10.9.1 | Computer 16d |  | 1.10.11.3 | Computer 3 | 2.10.10.5 | Computer 3i
1.10.11.4 | Computer 4 |  | 2.10.10.0 | Computer 5i |  | 1.10.11.4 | Computer 4 | 2.10.10.16 | Computer 4i
1.10.11.5 | Computer 5 |  | 2.10.10.1 | Computer 17e |  | 1.10.11.5 | Computer 5 | 2.10.10.0 | Computer 5i
1.10.11.6 | Computer 6 |  | 2.10.10.2 | Computer 15i |  | 1.10.11.6 | Computer 6 | 2.10.10.6 | Computer 6i
1.10.11.7 | Computer 7 |  | 2.10.10.3 | Computer 19d |  | 1.10.11.7 | Computer 7 | 2.10.10.12 | Computer 7i
1.10.11.8 | Computer 8 |  | 2.10.10.4 | Computer 18e |  | 1.10.11.8 | Computer 8 | 2.10.10.15 | Computer 8i
1.10.11.9 | Computer 9 |  | 2.10.10.5 | Computer 3i |  | 1.10.11.9 | Computer 9 | 2.10.9.2 | Computer 9i
1.10.11.10 | Computer 10 |  | 2.10.10.6 | Computer 6i |  | 1.10.11.10 | Computer 10 | 2.10.10.22 | Computer 10i
1.10.11.11 | Computer 11 |  | 2.10.10.7 | Computer 13i |  | 1.10.11.11 | Computer 11 | 2.10.10.26 | Computer 11i
1.10.11.12 | Computer 12 |  | 2.10.10.8 | Computer 20a |  | 1.10.11.12 | Computer 12 | 2.10.10.25 | Computer 12i
1.10.11.13 | Computer 13 |  | 2.10.10.9 | Computer 25d |  | 1.10.11.13 | Computer 13 | 2.10.10.7 | Computer 13i
1.10.11.14 | Computer 14 |  | 2.10.10.10 | Computer 1i |  | 1.10.11.14 | Computer 14 | 2.10.10.21 | Computer 14i
1.10.11.15 | Computer 15 |  | 2.10.10.11 | Computer 21a |  | 1.10.11.15 | Computer 15 | 2.10.10.2 | Computer 15i
 |  |  | 2.10.10.12 | Computer 7i
 |  |  | 2.10.10.13 | Computer 26d
 |  |  | 2.10.10.14 | Computer 27d
 |  |  | 2.10.10.15 | Computer 8i
 |  |  | 2.10.10.16 | Computer 4i
 |  |  | 2.10.10.17 | Computer 22a
 |  |  | 2.10.10.18 | Computer 28d
 |  |  | 2.10.10.19 | Computer 29a
 |  |  | 2.10.10.20 | Computer 23b
 |  |  | 2.10.10.21 | Computer 14i
 |  |  | 2.10.10.22 | Computer 10i
 |  |  | 2.10.10.23 | Computer 30a
 |  |  | 2.10.10.24 | Computer 24c
 |  |  | 2.10.10.25 | Computer 12i
 |  |  | 2.10.10.26 | Computer 11i
Spreadsheet: 744319d1629148553-subtract-2-cells-if-amount-in-cell-b-is-greater-than-cell-c-i-need-the-sum-to-go-alt-cell-sample-worksheet
Sheet: Mar 2021

Subscriptions | [NAME] | [NAME] | Difference
Gas |  | 35
Gas
Net Flix |  | 12.99
Cox |  | 161.98
HBO Max | 14.99
Disney Plus | 8.89
MS Office | 11.06
You Tube | 9.99
Spotify | 12.99
Billie | 10
Sprint | 135.83
Discovery plus | 7.78
Chewy | 56.71
Club carwash | 21.75
Total |  |  | 80.02 | luci owes
Spreadsheet: 166547d1341620873-how-to-create-and-read-any-function-in-excel-including-nesting-xl-functions
Sheet: Sheet3

Use a Dynamic Data Source
You can use a dynamic formula to define the source range for an Excel Pivot Table. As new items are added to the table, the named range will automatically expand.
You can download the zipped sample [NAME] file used for this pivot table tutorial.
1. Name the Range
1. Choose Insert>Name>Define
2. Type a name for the range, e.g. Database
3. In the Refers To box, enter an Offset formula that defines the range size, based on the number of items in a column that doesn't contain any blank cells. , e.g.:
=OFFSET(Data!$A$1,0,0,COUNTA(Data!$A:$A),7)
In this example, the list is on a sheet named 'Data', starting in cell A1. The arguments used in this Offset function are:
1. Reference cell: Data!$A$1
2. Rows to offset: 0
3. Columns to offset: 0
4. Number of Rows: COUNTA(Data!$A:$A)
5. Number of Columns: 7
Note: for a dynamic number of columns,
replace the 7 with: COUNTA(Data!$1:$1)
4. Click OK
2. Base the Pivot Table on the Named Range
1. Select a cell in the database
2. Choose Data>PivotTable and PivotChart Report
3. Select 'Microsoft Excel List or Database', click Next.
4. For the range, type your range name, e.g. Database
5. Click Next
6. Click the Layout button
7. [NAME] field buttons to the row, column and data areas
8. Click OK, click Finish
Spreadsheet: 9efe83b0-d694-4836-ba56-c10adab8f31d
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
LBC | Test | LBC | [NAME], Amniotic Fluid | [NAME], AF | Sysmex XE5000, Platelet Count by [NAME] | Varies: Var |  |  | 10 | mL | Collection Container/Tube: Amniotic fluid container Submission Container/Tube: Plastic vial [NAME]: 10 mL Collection Instructions: Do not centrifuge. Additional Information: Centrifuging the specimen may cause erroneous results. | 9.8 mL | Hemolysis	Visible hemolysis, reject Thawing	Reject if frozen Lipemia	NA Icterus	NA Other	NA | Immature: <15,000/mcL Indeterminate: 15,000-50,000/mcL Mature: >50,000/mcL   Cutoffs are based on consensus protocol (Neerhof M, Dohnal JC, [NAME], et al: Lamellar body counts: a consensus on protocol. Obstet Gynecol 2001;97:318-320) | Monday through Sunday; Continuously |  | 1 day | 1 | 83664 |  |  |  |  | Rochester
LBC | [NAME] | AMNIOTIC | Amniotic Fld |  |  |  | Refrigerated | 28 days
LBC | Result | LBCC | [NAME] | [NAME] | Numeric |  |  |  |  | /mcL |  |  |  |  |  |  |  |  |  | In Process
LBC | Result | LBCI | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 49454d1248806393-name-referrence-to-consolidate-financial-consolidated-financial-example
Sheet: Sheet1

 | Main Company
 | Workbook / Worksheet 1 (Consolidated)
 |  | 2008 Actual | 2008  Budget | Var +/(-) | 2010 Budget
 | Revenues
 | Management Fees
 | Interest Income
 | Rents
 | Lease
 | Total Revenues
 | Expenses
 | Salary & Wages
 | Payroll Taxes
 | Group Insurance
 | Other
 | Total Expenses
 | Net Profit
 | Owned or Operated Company
 | Workbook / Worksheet 2 (Consolidated)
 |  | 2008 Actual | 2008  Budget | Var +/(-) | 2010 Budget
 | Revenues
 | Management Fees | 125000 | 125000 |  | 135000
 | Interest Income | 4.1 | 20 |  | 25
 | Rents | 750 | 2250 |  | 3000
 | Lease | 1150 | 16000 |  | 17500
 | Total Revenues
 | Expenses
 | Salary & Wages | 64000 | 66000 |  | 64500
 | Payroll Taxes | 11500 | 11000 |  | 11000
 | Group Insurance | 9500 | 9000 |  | 10000
 | Other | 4000 | 5000 |  | 5000
 | Total Expenses
 | Net Profit
 | Owned or Operated Company
 | Workbook / Worksheet 3 (Consolidated)
 |  | 2008 Actual | 2008  Budget | Var +/(-) | 2010 Budget
 | Revenues
 | Management Fees | 125000 | 125000 |  | 135000
 | Interest Income | 4.1 | 20 |  | 25
 | Rents | 750 | 2250 |  | 3000
 | Lease | 1150 | 16000 |  | 17500
 | Total Revenues
 | Expenses
 | Salary & Wages | 64000 | 66000 |  | 64500
 | Payroll Taxes | 11500 | 11000 |  | 11000
 | Group Insurance | 9500 | 9000 |  | 10000
 | Other | 4000 | 5000 |  | 5000
 | Total Expenses
 | Net Profit