tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 872127d1718488134-totalling-scheduled-hours-but-does-not-recognize-their-days-off-work-week-schedule
Sheet: June 2

DATE |  | 26 | 26 | 27 | 27 | 28 | 28 | 29 | 29 | 30 | 30 | 31 | 31 | 2024-06-01 00:00:00 |  |  | 2024-06-02 00:00:00 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8
EMPLOYEE | POSITION | S              IN | S              OUT | M          IN | M        OUT | T         IN | T     OUT | W          IN | W       OUT | Th        IN | TH       OUT | F       IN | F      OUT | Sat       IN | Sat    OUT | WEEK TOTAL | S              IN | S              OUT | M          IN | M        OUT | T         IN | T     OUT | W          IN | W       OUT | Th        IN | TH       OUT | F       IN | F      OUT | Sat       IN | Sat    OUT
RACHEL | COOK/AIDE | OFF | OFF | 10:00:00 | 14:00:00 | 10:00:00 | 14:00:00 | 10:00:00 | 14:00:00 | OFF | OFF | OFF | OFF | 10:00:00 | 14:00:00 |  | 10:00:00 | 14:00:00 | 10:00:00 | 14:00:00 | 10:00:00 | 14:00:00 | 10:00:00 | 14:00:00 | 10:00:00 | 14:00:00 | 10:00:00 | 14:00:00 | 10:00:00 | 14:00:00
 |  | OFF | OFF | 15:00:00 | 19:00:00 | 15:00:00 | 19:00:00 | 15:00:00 | 19:00:00 | OFF | OFF | OFF | OFF | 15:00:00 | 19:00:00 |  | 15:00:00 | 19:00:00 | 15:00:00 | 19:00:00 | 15:00:00 | 19:00:00 | 15:00:00 | 19:00:00 | 15:00:00 | 19:00:00 | 15:00:00 | 19:00:00 | 15:00:00 | 19:00:00
JULIE | COOK/AIDE | 06:00:00 | 09:00:00 | 06:00:00 | 09:00:00 | 06:00:00 | 15:00:00 | 06:00:00 | 16:00:00 | 06:00:00 | 16:00:00 | 06:00:00 | 15:00:00 | 06:00:00 | 09:00:00 |  | 06:00:00 | 09:00:00 | 06:00:00 | 09:00:00 | 06:00:00 | 09:00:00 | 06:00:00 | 09:00:00 | 06:00:00 | 09:00:00 | 06:00:00 | 09:00:00 | 06:00:00 | 09:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:00:00 | 19:00:00 | 15:00:00 | 19:00:00
FLETCHER | COOK/AIDE | 06:00:00 | 09:00:00 | 06:00:00 | 10:00:00 | 06:00:00 | 09:00:00 | 06:00:00 | 09:00:00 | 06:00:00 | 09:00:00 | 06:00:00 | 09:00:00 | 06:00:00 | 09:00:00 |  | 06:00:00 | 09:00:00 | 06:00:00 | 09:00:00 | OFF | OFF | OFF | OFF | 06:00:00 | 09:00:00 | 06:00:00 | 09:00:00 | 06:00:00 | 09:00:00
 |  | 10:00:00 | . | . |  |  |  | 10:00:00 | 14:00:00 | 10:00:00 | 14:00:00 |  |  | 10:00:00 | 14:00:00 |  | 10:00:00 | 14:00:00 | 10:00:00 | 14:00:00 |  |  |  |  |  |  |  |  | 10:00:00 | 14:00:00
DARLENE | AIDE | OFF | OFF | 10:00:00 | 14:00:00 | 10:00:00 | 14:00:00 | 10:00:00 | 14:00:00 | 10:00:00 | 14:00:00 | 10:00:00 | 14:00:00 | OFF | OFF |  | OFF | OFF | OFF | OFF | 10:00:00 | 14:00:00 | 10:00:00 | 14:00:00 | 10:00:00 | 14:00:00 | 10:00:00 | 14:00:00 | OFF | OFF
RO | AIDE | 15:00:00 | 19:00:00 | 15:00:00 | 19:00:00 | OFF | OFF | 15:00:00 | 19:00:00 | OFF | OFF | 15:00:00 | 19:00:00 | 10:00:00 | 14:00:00 |  | 15:00:00 | 19:00:00 | 15:00:00 | 19:00:00 | OFF | OFF | OFF | OFF | 15:00:00 | 19:00:00 | 15:00:00 | 19:00:00 | 10:00:00 | 14:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:00:00 | 19:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:00:00 | 19:00:00
 |  |  |  |  |  | ****SCHEDULE IS SUBJECT TO CHANGE****
Spreadsheet: 773351d1647805634-transposing-complex-data-into-usable-format-example-excel-file
Sheet: Sheet1

 | CURRENT |  |  |  |  | How ID Like It To Be
Site Name | VLAN | IP ADDRESS | SUBNET MASK |  |  | Site ID | Vlan 10 IP | Vlan 10 Mask | Vlan 20 IP | Vlan 20 Mask
Site ID |  | 1234 | Site 1 |  |  | 1234 | 10.10.10.0 | 255.255.255.240 | 10.10.20.0 | 255.255.255.224
 |  |  |  |  |  | 2345 | 10.10.10.16 | 255.255.255.240 | 10.10.20.32 | 255.255.255.224
 | Vlan 10 | 10.10.10.0 | 255.255.255.240 |  |  | 3456 | 10.10.10.32 | 255.255.255.240 | 10.10.20.64 | 255.255.255.224
 | Vlan 20 | 10.10.20.0 | 255.255.255.224
Site ID |  | 2345 | Site 2
 | Vlan 10 | 10.10.10.16 | 255.255.255.240
 | Vlan 20 | 10.10.20.32 | 255.255.255.224
Site ID |  | 3456 | Site 3
 | Vlan 10 | 10.10.10.32 | 255.255.255.240
 | Vlan 20 | 10.10.20.64 | 255.255.255.224
Spreadsheet: louise_kitchen__23083__Commercial Headcount for NEWCO
Sheet: Fundys - Structuring

[NAME] AND STRUCTURING
Ed McMichaeal | VP | Structuring | Gas
[NAME] | Manager | Structuring | Gas
[NAME] | Manager | Structuring | Gas
[NAME] | Manager | Structuring | Gas
Kelly Little | Assoc | Structuring | Gas
[NAME] | Assoc | Structuring | Gas
[NAME] | Assoc | Structuring | Gas | 7
[NAME] | Dir | Fundys | Gas
[NAME] | Manager | Fundys | Gas
[NAME] | Analyst | Fundys | Gas
[NAME] | Analyst | Fundys | Gas
[NAME] | Analyst | Fundys | Gas
[NAME] | Analyst | Fundys | Gas
[NAME] | Analyst | Fundys | Gas
[NAME] | Intern | Fundys | Gas
[NAME] | Associate | Fundys | Gas
[NAME] | Analyst | Fundys | Gas | 10
[NAME], [NAME] | Director | Fundies | West Power
[NAME], [NAME] | Sr. Spec | Fundies | West Power
[NAME], [NAME] | Analyst | Fundies | West Power
[NAME], [NAME] | Specialist | Fundies | West Power
[NAME], Maria | Sr. Spec | Fundies | West Power
Swain, [NAME] | Sr. Spec | Fundies | West Power
Oh, [NAME] | Manager | Fundies | West Power | 7
[NAME], Todd | Manager | Structuring | West Power
[NAME], [NAME] | Manager | Structuring | West Power
Elafandi, Mo | Associate | Structuring | West Power
[NAME], [NAME] | Analyst | Structuring | West Power
[NAME], Gray | Associate | Structuring | West Power
Stokley, [NAME] | Associate | Structuring | West Power | 6
Benchluch, Moises | Associate | Fundamentals | East Power
Cline, [NAME] | Sr. Spec | Fundamentals | East Power
Giron, Gustavo | Associate | Fundamentals | East Power
Imai, Rika | Manager | Fundamentals | East Power
Kaniss, [NAME] | Analyst | Fundamentals | East Power
Marquez, Maurico | Associate | Fundamentals | East Power
[NAME], [NAME] | Manager | Fundamentals | East Power | 7
Hiemstra, Nick | Sr. Spec | Structuring | East Power
Meyn, [NAME] | Dir | Structuring | East Power
Reyes, [NAME] | Analyst | Structuring | East Power
Rust, [NAME] | Manager | Structuring | East Power
Trefz, Greg | Sr. Spec | Structuring | East Power
[NAME], [NAME] | Analyst | Structuring | East Power | 6
 |  |  | TOTAL
Spreadsheet: 44459d1243231948-want-to-add-list-and-the-formula-for-this-excel-order-list
Sheet: Product2

Product | Weight | Price | Quantity
aa | 1 | 12 | 30
bb | 2 | 1 | 0
cc | 3 | 1 | 0
dd | 4 | 1 | 2
gg | 5 | 7 | 0
ee | 1 | 1 | 0
ff | 2 | 131 | 1
Spreadsheet: 166095d1341469255-offset-function-that-i-cannot-get-to-work-properly-excel-example
Sheet: Sheet1

DATE | TIME | OPEN | HIGH | LOW | CLOSE |  | DATE | TIME | OPEN | HIGH(MAX) | LOW(MIN) | CLOSE
07/01/11 | 17:30:00 | 335.83 | 335.86 | 335.485 | 335.71 |  | 07/01/11 | 17:30:00 | 335.83 | 336.16 | 334.82 | 334.985
07/01/11 | 17:31:00 | 335.56 | 335.73 | 335.56 | 335.62 |  | 07/01/11 | 17:35:00 | 334.97 | 335.56 | 334.2 | 334.44
07/01/11 | 17:32:00 | 335.62 | 335.65 | 335.24 | 335.36 |  | 07/01/11 | 17:40:00 | 334.4 | 337.79 | 334.4 | 335.305
07/01/11 | 17:33:00 | 335.27 | 335.32 | 335.1 | 335.1
07/01/11 | 17:34:00 | 335.1 | 336.16 | 334.82 | 334.985
07/01/11 | 17:35:00 | 334.97 | 334.07 | 334.84 | 334.94
07/01/11 | 17:36:00 | 334.87 | 334.87 | 334.52 | 334.54
07/01/11 | 17:37:00 | 334.52 | 334.64 | 334.2 | 334.6
07/01/11 | 17:38:00 | 334.51 | 334.58 | 334.43 | 334.47
07/01/11 | 17:39:00 | 334.54 | 335.56 | 334.34 | 334.44
07/01/11 | 17:40:00 | 334.4 | 337.79 | 334.4 | 334.79
07/01/11 | 17:41:00 | 334.8 | 334.93 | 334.71 | 334.89
07/01/11 | 17:42:00 | 334.94 | 335.23 | 334.94 | 335.17
07/01/11 | 17:43:00 | 335.23 | 335.37 | 335.2 | 335.29
07/01/11 | 17:44:00 | 335.32 | 335.36 | 335.22 | 335.305
Spreadsheet: 759418d1639522648-help-with-a-formula-returning-a-value-based-on-multiple-criteria-sample-data
Sheet: Sheet1

Table 1
Carriers | Commission | CT | PA | DC | CA | NJ
AETNA | 215 | 265 | 265 | 265 | 315 | 315
[NAME] | 215 | 265 | 265 | 265 | 315 | 315
Humana | 240 | 290 | 290 | 290 | 340 | 340
Table 2
[NAME] | WI | 215 | <Return this value
[NAME] | DC | 265
Humana | OH | 240
Humana | CA | 340
Aetna | AZ | 215
Aetna | PA | 265
Spreadsheet: 59388d1259872123-running-total-709557_dulanic
Sheet: DO

Month | Month | Incentive Group | Department | Function | Manager | Associate NBK copy to the BOPayout tab | Associate Name | Productive Hours | Total Production | P-Score | Number of Claims Audited | Quality Points | Q-Score | Final Occurences | Running Occurences (w/3 month wipeout) | Key
 | 2009-01-01 00:00:00 | Debit 1st CB | Debit | Master [NAME] | [NAME] | NB1234 | [NAME] | 74.865 | 50 | 18.8664 | 10 | 7.5 | 88.2352941176471
 | 2009-02-01 00:00:00 | Debit 1st CB | Debit | Master [NAME] | [NAME] | NB1234 | [NAME] | 114.498 | 388 | 90.7421 | 10 | 9 | 105.882352941176
 | 2009-03-01 00:00:00 | Debit 1st CB | Debit | Master [NAME] | [NAME] | NB1234 | [NAME] | 129.564 | 435 | 100.024 | 10 | 10 | 117.647058823529
 | 2009-04-01 00:00:00 | Debit 1st CB | Debit | Master [NAME] | [NAME] | NB1234 | [NAME] | 112.881 | 425 | 113.882 | 10 | 9 | 105.882352941176
 | 2009-05-01 00:00:00 | Debit 1st CB | Debit | Master [NAME] | [NAME] | NB1234 | [NAME] | 120.057 | 410 | 103.146 | 10 | 10 | 117.647058823529
 | 2009-06-01 00:00:00 | Debit 1st CB | Debit | Master [NAME] | [NAME] | NB1234 | [NAME] | 131.261 | 417 | 92.5315 | 10 | 5 | 58.8235294117647
 | 2009-07-01 00:00:00 | Dbt All Other | Debit | Master [NAME] | [NAME] | NB1234 | [NAME] | 100.26 | 429 | 92.06 | 10 | 7.5 | 88.2352941176471
 | 2009-08-01 00:00:00 | Dbt All Other | Debit | Master [NAME] | [NAME] | NB1234 | [NAME] | 86.91 | 308 | 72.77 | 8 | 6 | 88.2352941176471
 | 2009-09-01 00:00:00 | Dbt All Other | Debit | Master [NAME] | [NAME] | NB1234 | [NAME] | 72.57 | 415 | 101.09 | 8 | 8 | 117.647058823529
 | 2009-10-01 00:00:00 | Dbt All Other | Debit | Master [NAME] | [NAME] | NB1234 | [NAME] | 44.6 | 253 | 116.48 | 8 | 8 | 117.647058823529
 | Range B:N sorted by G, C and B in that order -- no other columns should be sorted
 | You can then run a PT off B:P where P would give you you're running occurences
Spreadsheet: 62896d1263897939-conditional-count-sumproduct_problem_matejabg
Sheet: Sheet1

 | cells can be filled eather by numbers (representing hours of work), or by letters (sick leave, holiday, state holiday, …)
 | workday | workday | state_holiday | workday | workday | weekend | weekend
 | Mon | Tue | Wed | Thu | Fri | Sat | Sun |  | State holiday # of days
Shift 1 |  |  |  |  |  |  |  |  | 1
Shift 2 |  |  | 12 |  |  |  |  |  |  | correct
Shift 3
 | workday | workday | state_holiday | workday | workday | weekend | weekend
 | Mon | Tue | Wed | Thu | Fri | Sat | Sun |  | State holiday # of days
Shift 1 |  |  | holiday |  |  |  |  |  | 1
Shift 2 |  |  |  |  |  |  |  |  |  | correct
Shift 3
 | workday | workday | state_holiday | workday | workday | weekend | weekend
 | Mon | Tue | Wed | Thu | Fri | Sat | Sun |  | State holiday # of days
Shift 1 |  |  | 8 |  |  |  |  |  | 2
Shift 2 |  |  | 4 |  |  |  |  |  |  | wrong | should be only 1 day, no matter how many shifts a person worked
Shift 3
 |  |  |  |  |  |  |  |  | "bo" and "nz" are types of possible data entered in each cell, that should not produce a result of State holiday # of days
Spreadsheet: 821535d1678782538-lookup-different-ranges-based-on-chosen-category-sample
Sheet: Sheet6

Catageory | Start Date | Day / Week Number | 7 day range
7 day range | 2023-03-09 00:00:00 | 7 range
14 day range | 2023-03-09 00:00:00 | 14 range
 |  |  | 14 day range
Spreadsheet: 710023d1608669810-array-lookup-from-columns-to-rows-stock-report-examplesumifs-and-custom-format
Sheet: Availability

 | RRD COB:
 | SKU # | B-Stock  Available | B1 | B2 | B3 | SHOW
 | ZD-AA87
 | ZD-KL-12
 | ZD-KL-12-Q19
 | ZD-KL5499
 | ZD-ZD10544
 | ZD-ZD10545
 | ZD-ZD10546
 | ZD-ZD10547
 | ZD-ZD7000
 | ZD-ZD8721
 | ZD-ZD8721-100
 | ZD-ZK-64
 | ZD-ZK-64-Q
Spreadsheet: 71020d1271774118-understanding-how-this-factor-is-calculated-how-factor-is-calculated-improved2
Sheet: temp correction

 | Temp | 20.5
 | Correction
 | Corr. Curve
 | Temp(x) | °C | 34 | 33 | 32 | 31 | 30.5 | 30 | 29 | 28 | 27 | 26 | 25.5 | 25 | 24.5 | 24 | 23 | 22 | 21 | 20 | 19 | 18 | 17 | 16 | 15 | 14 | 13 | 12 | 11 | 10 | 9
 | correction(y) |  | 1.06280243421613 | 1.05578615902926 | 1.04845588806701 | 1.031183997383186 | 1.02672070094287 | 1.024371308378185 | 1.018050188986899 | 1.012286214789809 | 1.007537943660338 | 1.003333588006641 | 1.001608009951706 | 1 | 0.9985100709248589 | 0.9971381872245121 | 0.9949642081103467 | 0.9931632199585045 | 0.9920123670164718 | 0.9910714566903372 | 0.9903306406956988 | 0.9897784582534002 | 0.9894019927724257 | 0.989146630000986 | 0.9889225320010581 | 0.9887225282984441 | 0.9885237776015761 | 0.9883113668162781 | 0.988078311045766 | 0.987825553590648 | 0.9875619659489241
Spreadsheet: 721951d1614961607-formula-direction-needed-shop1
Sheet: mechanic

date | [NAME] | gage yount | [NAME] | [NAME]
2021-03-01 00:00:00 | [NAME]
2021-03-02 00:00:00 | sumif
2021-03-03 00:00:00 | sumif with vlookup
2021-03-04 00:00:00
2021-03-05 00:00:00
2021-03-06 00:00:00
2021-03-07 00:00:00
2021-03-08 00:00:00
2021-03-09 00:00:00
2021-03-10 00:00:00
2021-03-11 00:00:00
2021-03-12 00:00:00
2021-03-13 00:00:00
2021-03-14 00:00:00
2021-03-15 00:00:00
2021-03-16 00:00:00
2021-03-17 00:00:00
2021-03-18 00:00:00
2021-03-19 00:00:00
2021-03-20 00:00:00
2021-03-21 00:00:00
2021-03-22 00:00:00
2021-03-23 00:00:00
2021-03-24 00:00:00
2021-03-25 00:00:00
2021-03-26 00:00:00
2021-03-27 00:00:00
2021-03-28 00:00:00
2021-03-29 00:00:00
2021-03-30 00:00:00
2021-03-31 00:00:00
Spreadsheet: 82997d1283005960-problem-with-the-uneditable-background-versorgungsberechnung-ungenauer-berblick-
Sheet: Eingabe

Bruttoeinkommen monatlich |  |  |  |  | 4000
Nettoeinkommen monatlich |  |  |  |  | 3000
 |  | [NAME] |  | Berechnungshilfen
Bruttolohn
Nettolohn
Lohnfortz.
Krankeng.
volle EMR
halbe [NAME]
keine [NAME] | 0
AR
Pflegeheimk. | 3000
PPV | 1432
Spreadsheet: 709815d1608567200-how-do-i-create-a-dynamic-table-from-another-tables-data-test-sheet-1
Sheet: Sheet1

Master Table
Project Name | Status | Unit
Echo | Closed | A
Delta | Open | B
[NAME] | Closed | B
Beta | Open | A
Alpha | Open | A
Desired Outcome
Table 1
Project Name | Status | Unit | Jan | Feb | Mar
 | Open | A | 50 | 30 | 20
Alpha | Open | A | 60 | 80
Table 2
Project Name | Status | Unit | Q1 | Q2 | Q3
 | Open | B | 80 | 60 | 200
Spreadsheet: 718372d1613127203-conditional-time-subtraction-book1
Sheet: Sheet1

 | FLY1 |  | AAA | AAA | 2021-01-03 06:05:00 | 1:35:00 | 2021-01-03 06:08:00 | 2021-01-03 08:00:00
 | FLY |  | DDD | DDD |  | 1:30:00 | 2021-01-03 08:45:00 | 2021-01-03 10:34:00
 | FLY |  | AAA | AAA |  | 0:55:00 | 2021-01-03 12:36:00 | 2021-01-03 12:47:00
 | FLY |  | CCC | CCC |  | 1:00:00 | 2021-01-03 13:35:00 | 2021-01-03 14:36:00
Spreadsheet: 139370d1328202970-table-structure-tablestructure
Sheet: TableStructure

 | 2011
 | Jan |  |  |  | Feb |  |  |  | Mar
PRODUCT | Data 1 | Data 2 | Data 3 | Data 4 | Data 1 | Data 2 | Data 3 | Data 4 | Data 1 | Data 2 | Data 3 | Data 4
Product 1 | 534 | 7647 | 14760 | 21873 | 28986 | 36099 | 43212 | 50325 | 57438 | 64551 | 71664 | 78777
Product 2 | 543 | 867 | 1191 | 1515 | 1839 | 2163 | 2487 | 2811 | 3135 | 3459 | 3783 | 4107
Product 3 | 65 | 8 | -49 | -106 | -163 | -220 | -277 | -334 | -391 | -448 | -505 | -562
Product 4 | 32 | 876 | 1720 | 2564 | 3408 | 4252 | 5096 | 5940 | 6784 | 7628 | 8472 | 9316
Product 5 | 5 | 87687 | 175369 | 263051 | 350733 | 438415 | 526097 | 613779 | 701461 | 789143 | 876825 | 964507
Product 6 | 543 | 6 | -531 | -1068 | -1605 | -2142 | -2679 | -3216 | -3753 | -4290 | -4827 | -5364
Product 7 | 45 | 65 | 765 | 756 | 756 | 75 | 765 | 75 | 45 | 756 | 45 | 75
Product 8 | 64 | 786 | 1508 | 2230 | 2952 | 3674 | 4396 | 5118 | 5840 | 6562 | 7284 | 8006
Product 9 | 645 | 86 | -473 | -1032 | -1591 | -2150 | -2709 | -3268 | -3827 | -4386 | -4945 | -5504
Product 10 | 645 | 867 | 1089 | 1311 | 1533 | 1755 | 1977 | 2199 | 2421 | 2643 | 2865 | 3087
Product 11 | 64 | 867 | 1670 | 2473 | 3276 | 4079 | 4882 | 5685 | 6488 | 7291 | 8094 | 8897
Product 12 | 645 | 786 | 927 | 1068 | 1209 | 1350 | 1491 | 1632 | 1773 | 1914 | 2055 | 2196
Product 13 | 456 | 867 | 1278 | 1689 | 2100 | 2511 | 2922 | 3333 | 3744 | 4155 | 4566 | 4977
Product 14 | 654 | 867 | 1080 | 1293 | 1506 | 1719 | 1932 | 2145 | 2358 | 2571 | 2784 | 2997
Product 15 | 64 | 867 | 1670 | 2473 | 3276 | 4079 | 4882 | 5685 | 6488 | 7291 | 8094 | 8897
Spreadsheet: 55419d1255533451-if-name-name-then-count-adjacent-cells-example
Sheet: Leaderboards

 |  |  | WK 23 |  | WEEKLY AVERAGE % | WEEKLY TEAM AVERAGE % | WK 24 |  | WEEKLY AVERAGE % | WEEKLY TEAM AVERAGE % | WK 25 |  |  | WEEKLY AVERAGE % | WEEKLY TEAM AVERAGE % | WK 26 |  |  | WEEKLY AVERAGE %
 |  | [NAME] |  |  | N/A | 0.89 |  |  | N/A | 0.94 |  |  |  | N/A | 0.88 |  |  |  | N/A
 |  | [NAME] | 0.85 | 1 | 0.925 |  | 1 |  | 1 |  | 1 | 0.95 | 0 | 0.65 |  | 0.95 |  |  | 0.95
 |  | [NAME] | 0.95 | 0.65 | 0.8 |  | 0.5 | 0.95 | 0.725 |  | 0.95 | 1 | 0.95 | 0.9666666666666667 |  |  |  |  | N/A
 |  | [NAME] | 0.95 | 1 | 0.975 |  | 0.95 | 0.95 | 0.95 |  |  |  |  | N/A |  |  |  |  | N/A
 |  | [NAME] |  |  | N/A |  | 1 |  | 1 |  | 0.95 |  |  | 0.95 |  | 0 | 1 |  | 0.5
 |  | [NAME] |  |  | N/A |  |  |  | N/A |  |  |  |  | N/A |  |  |  |  | N/A
 |  | [NAME] |  |  | N/A |  |  |  | N/A |  |  |  |  | N/A |  |  |  |  | N/A
 |  | [NAME] | 0.9 |  | 0.9 |  | 0.95 |  | 0.95 |  |  |  |  | N/A |  | 1 |  |  | 1
 |  | [NAME] |  |  | N/A |  |  |  | N/A |  |  |  |  | N/A |  |  |  |  | N/A
 |  | [NAME] |  |  | N/A |  | 1 |  | 1 |  | 0.95 |  |  | 0.95 |  |  |  |  | N/A
 |  | [NAME] |  |  | N/A |  |  |  | N/A |  | 0.9 |  |  | 0.9 |  | 1 |  |  | 1
 |  | [NAME] | 0.95 |  | 0.95 |  |  |  | N/A |  | 1 | 0.6 | 0.95 | 0.85 |  | 0 | 0.8 |  | 0.4
 |  | Mercu Polant | 0.8 |  | 0.8 |  | 0.95 | 0.95 | 0.95 |  |  |  |  | N/A |  |  |  |  | N/A
Spreadsheet: 2628b62c-8169-4b70-88b6-212da50ca875
Sheet: Back-Up

 |  |  |  |  | LIU PO #:
 |  |  |  |  | Application #:
 |  |  |  |  | Application Date:
PROCUREMENT AND SOURCING SERVICES
A | B | C | D | E | F | G | H | I
Item No. | Description of Work | Scheduled Value | Work Completed From Previous Application | Work Completed This Period | Mateirals Presently Stored (not included in D or E) | Total Completed and Stored to Date | % Completed | Retainage
 |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 833827d1687271727-rank-table-using-values-in-multiple-columns-book1
Sheet: Sheet1

Player | Score | back 9 | last 6 | last 3 | Rank |  | helper
Player A | 28 | 12 | 8 | 3
Player B | 28 | 13 | 9 | 3 |  |  | 28130903
Player C | 28 | 12 | 8 | 4 |  |  | 28120804
Spreadsheet: 764308d1642686457-compare-two-tables-find-matches-and-extract-rows-based-on-matches-mwa-schools-ans
Sheet: Blad1

TABLE 1 |  |  | TABLE 2
Skol-enhetskod | Skolkommun |  | Skol-enhetskod | Skolkommun |  | Skol-enhetskod | Skolkommun1 | Skolkommun2
76026322 | Kiruna |  | 76026322 | Kiruna
44673074 | Stockholm |  | 44673074 | Stockholm
99648792 | Stockholm |  | 99648792 | Stockholm
22335099 | Knivsta |  | 22335099 | Knivsta
47684564 | Örebro |  | 47684564 | Örebro
15561397 | [NAME] |  | 15561397 | [NAME]
71387206 | Ale |  | 71387206 | Ale
41408780 | Nacka |  | 41408780 | Nacka
10715898 | Österåker |  | 37796564 | Stockholm
48184058 | Vallentuna |  | 10715898 | Österåker
28145722 | Vallentuna |  | 48184058 | Vallentuna
59092675 | Timrå |  | 28145722 | Vallentuna
90711097 | Stockholm |  | 59092675 | Timrå
84230115 | Hultsfred |  | 90711097 | Stockholm
27323097 | Solna |  | 84230115 | Hultsfred
85416841 | Jönköping |  | 27323097 | Solna
92304123 | Ovanåker |  | 85416841 | Jönköping
65024773 | Bollnäs |  | 92304123 | Ovanåker
82838118 | Stockholm |  | 65024773 | Bollnäs
60217642 | Skurup |  | 82838118 | Stockholm
45270097 | Vara |  | 60217642 | Skurup
56528690 | [NAME] |  | 45270097 | Vara
51403955 | Lerum |  | 56528690 | [NAME]
Spreadsheet: 96866d1296134909-hightlighting-row-with-the-current-date-copy-of-copy-of-counting1
Sheet: Sheet3

WEEK START | WEEK NUM | DAY | START | FINISH |  | Testing
2011-01-03 00:00:00 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
Spreadsheet: 47071d1245964558-sumif-multiple-worksheets-add-all-cells-adjacent-to-cell-w-value-matching-query-kor-cart-quotas
Sheet: SPH - CS-SPD

K-BRO LINEN SYSTEMS - EDMONTON  PLANT
CS/SPD
FACILITY: | STONY PLAIN HOSPITAL
Date:
 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | STATS
DELIVERY DAYS:
[NAME] |  |  |  | PACK # |  | QUOTA | SHELF | REC | +/-/HOLD
1-GOWN STD XL |  |  |  | GP0002
2-GOWN STD XL |  |  |  | GP0004
1-GOWN GORE XL |  |  |  | GP0010
MAJOR LITHOTOMY PACK |  |  |  | CP0002
LITHO PLUS PACK |  |  |  | CP0003
DELIVERY PACK |  |  |  | CP0004
1-GOWN GORE XL |  |  |  | GP0010
FULL SHEET |  |  |  | SP0021
MED BARRIER |  |  |  | SP0016
LAPAROTOMY PACK |  |  |  | CP0005
BASIC PACK |  |  |  | CP0008
LITHOTOMY PACK |  |  |  | CP0010
CHEST/BREAST PACK |  |  |  | CP0018
MAYO COVER |  |  |  | SP0003
LG SPLIT DRAPE |  |  |  | SP0010
HALF SHEET |  |  |  | SP0015
LAP DRAPE |  |  |  | SP0018
3/4 SHEET |  |  |  | SP0020
All changes or additions to this order must be faxed in to (780) 451-5788 before 07:30 a.m. the day of delivery.
UPDATED:
June 17th 2009
Spreadsheet: 66426d1267087028-create-list-from-pivot-table-listfrompivot-v2
Sheet: Report

Staff
[NAME]
Jake
[NAME]
 |  | staff member: | Jake
 |  |  |  | yellow | red | blue
 |  |  | quote (not converted) | 4 | 3 | 2
 |  |  | sale (converted) | 0 | 3 | 4
 |  |  | total customers | 0 | 6 | 6
 |  |  | payment | 0 | 75 | 400
 |  |  | 5 |  | 2 | 7
 |  |  | 1 | 2 | 1 | 4
 |  |  | 6 | 2 | 3 | 11
 |  |  | 100 | 50 | 50 | 200
 |  |  | 2 | 3 | 4 | 9
 |  |  | 4 | 3 |  | 7
 |  |  | 6 | 6 |  | 12
 |  |  | 400 | 75 |  | 475
 |  |  | 6 | 3 | 2 | 11
 |  |  | 1 | 1 | 4 | 6
 |  |  |  | 4 |  | 4
 |  |  | 100 | 25 | 200 | 325
Spreadsheet: 770604d1646188577-auto-import-of-data-in-summary-sheet-from-other-sheets-customers-visit-schedule
Sheet: B

S/No. | Name | Date | Time | Status | Remarks
1 | B1
2 | B2 | 2022-03-01 00:00:00 | 1500pm | Confirmed
3 | B3
4 | B4
5 | B5 | 2022-02-14 00:00:00 | 1030am | To be confirmed
6 | B6
Spreadsheet: 791091d1660148638-mail-address-lookup-advanced-drainage-systems-response
Sheet: Sheet1

 |  | Lookup Field | Address | City | State | ZIP |  |  | Actions Taken:
 |  |  | 345 Chesnut Street | Houston | TX | 26505 |  |  | 1 | I have created a fictitious address table
 |  |  | 900 West Walnut Hill Lane | Yoakum | TX | 75038 |  |  | 2 | Created in "Lookup Field" a combined field to use in a lookup
 |  |  | 2502 East Kansas Avenue | Hempstead | TX | 67846 |  |  | 3 | On Other Sheet have created a Lookup field in Column G
 |  |  | 2818 Avenue R 1/2 | Ennis | TX | 77550 |  |  | 4 | Used Data in Column G (As above) to lookup in this "Address" table
 |  |  | 2276 Pipestone Road | Winter Garden | FL | 49022 |  |  | 5 | returns the address field.
 |  |  | 3825 28th Street Southwest | Norcross | GA | 49418
 |  |  | 1741 Phoenix Street | Bessemer | AL | 49090
 |  |  | 161 Saint Anthony Avenue | Eagle Grove | IA | 55103
 |  |  | 2033 Penrose Avenue | Kansas City | MO | 19145
 |  |  | 2590 Capital Avenue Southwest | Phoenix | AZ | 49015
 |  |  | 100 Spring Street | London | OH | 54022
 |  |  | 8200 Palm Parkway | Deerfield Beach | FL | 32836
 |  |  | 404 Touring Drive | [NAME] | MS | 46706
 |  |  | 2007 South Service Road | [NAME] | GA | 72301
 |  |  | 6121 North Interstate Highway 35 | Wooster | OH | 78752
 |  |  | 1000 Admiral [NAME] | Logan Township | NJ | 94951
 |  |  | 2625 Thousand Oaks Boulevard | Panama City Beach | FL | 38118
 |  |  | 33 East 55th Street | Mendota | IL | 45402
 |  |  | 1925 Cedar Creek Road | [NAME] | OH | 28312
 |  |  | 4343 Northwest A Avenue | North Salt Lake | UT | 97801
 |  |  | 915 Burford Highway | Ludlow | MA | 30041
 |  |  | 3591 State Road 23 | Monticello | IL | 53533
 |  |  | 220 Greens Landing Drive | Clifford | MI | 77038-2642