tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 140448d1328750567-formulas-amanda
Sheet: Inspections

Unit | Branch | Hours of Last AService | Date from pg 1 warning | Service Completed Date | Next A Service | Hours of Last B Service | Next Service
1 | Cob | 353 |  | 2012-02-07 00:00:00
2 | [NAME] | 777
3 | Job | 161
4 | God | 159
5 | GOT | 368 |  |  |  |  |  |  |  | B | A
6 | Bopt | 257 |  |  |  |  |  |  |  | 400 | 200 |  | If C2 is within  the range of 350 to 400 hours then I want the cell to turn orange on sheet 1 when with in this range. Also, if we hit the magic number (350-400) I want the cell in the first sheet to hit red and populate the date to the second tab. Also, I will need this for the A service of 150-200 hrs same criteria as the b service of 350-400 hrs.
7 | GDT | 168
 |  |  |  |  |  |  |  |  |  |  |  |  | Ok, So we got our formula working. We hit our magic number and it tells us a service is due…..the hours don’t reset on the truck engine…so how do we coninute to the next service date.
I am trying to do a running total of hours / inspections due. What i need is #1 when the hours hit between 350 to 399 from the date of the last inspection i need the cell to turn one color. #2 When the cell hits 400 - i need the cell to hit another color. #3 When the cell turns red - i need it to generate the date in another cell the date that the 400 took place #4 because its a running yearly total. the hours will start from 0 and go up to the thousands. I do not want to change the total weekly hours - but i do need the 0-400 count to reset once the inspection date cell has been filled in. ie: week 1 total hours was 412 (therefore it is red) inspection was completed and the date filled in. Start of week 2 the hours total continuing equal 512 (this will not be red as the count has reset to 0) at the end of week two i have not yet hit 400 so nothing has been red and no inspection date has been filled in. Week 3 i hit 812 the box once again turns red as it has been 400 hrs since the last inspection date. I have tried a few different things however I am not having much luck. Any advice you can offer would be appreciated .
Spreadsheet: 478878d1473133769-select-cells-from-row-in-sequences-which-omit-some-then-display-consecutively-music-alphabetical-musical-scale-speller
Sheet: Sheet1

 | Two octaves of Chromatic scale (Accidentals as #'s and also as b's shown on two rows) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Scale type |  | Key |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 1
 | C | C# | D | D# | E | F | F# | G | G# | A | A# | B | C | C# | D | D# | E | F | F# | G | G# | A | A# | B | C |  | Major ([NAME]) |  | C |  | C | D | E | F | G | A | B | C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ^
 | Scale type |  |  |  |  |  |  | Key |  |  |  |  |  |  |  | Major ([NAME]) |  |  |  |  |  | 2,2,1,2,2,2,1 |  |  |  |  | Scale type |  | Key |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 1
 | Major ([NAME]) |  |  |  |  |  |  | C |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  | 2,1,2,2,2,1,2 |  |  |  |  | [NAME] |  | D |  | D | E | F | G | A | B | C | D
 | [NAME] |  |  |  |  |  |  | G |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  | 1,2,2,2,1,2,2
 | [NAME] |  |  |  |  |  |  | D |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  | ... |  |  |  |  |  | This is a simplified description of what I am going to do. The green areas are input and output. (for now output was just manually typed). If you know music theory it may help but it isn't essential. The grey areas are source data and in red and yellow I have shown the numerical sequences for the selection of scale data that depends on the options chosen in the two drop down menus: Scale type and Key. The major scale for example has the following selection sequence to be applied to the long horizontal table at top left: 2,2,1,2,2,2,1 i.e.  As C is the key chosen, the first note is C. The second note in the scale will be the one that is positioned 2 'cells' after the first note: = D The 3rd not is 2 'cells' after the second note: = E the 4th note is 1 cell after the 3rd note: = F.... and so on if the user selects Dorian mode in the key of D the selction sequence to display must START on D and follow the slightly altered sequence of 2,1,2,2,2,1,2 as shown in red and yellow. There are 105 scale possibilites in this scenario. Even if you can just point me to the right functions to use this will be much appreciated
 | [NAME] |  |  |  |  |  |  | A |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  | ...
 | [NAME] |  |  |  |  |  |  | E |  |  |  |  |  |  |  | Minor ([NAME]) |  |  |  |  |  | ...
 | Minor ([NAME]) |  |  |  |  |  |  | B |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  | ...
 | [NAME] |  |  |  |  |  |  | --Cb--
 |  |  |  |  |  |  |  | F#
 |  | Source for drop down lists |  |  |  |  |  | --Gb--
 |  |  |  |  |  |  |  | Db
 |  |  |  |  |  |  |  | --C#--
 |  |  |  |  |  |  |  | Ab
 |  |  |  |  |  |  |  | Eb
 |  |  |  |  |  |  |  | Bb
 |  |  |  |  |  |  |  | F
Spreadsheet: 113310d1309266388-best-way-to-get-adjusted-score-esc-scores
Sheet: Sheet1

Hole | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | Front | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | Back | Gross | HCP | NET
Par | 4 | 3 | 4 | 4 | 5 | 4 | 3 | 4 | 5 |  | 4 | 3 | 4 | 4 | 5 | 3 | 4 | 4 | 5
Fred | 5 | 6 | 4 | 4 | 6 | 9 | 4 | 4 | 6 |  | 5 | 5 | 4 | 5 | 4 | 4 | 7 | 8 | 5 |  |  | 24
[NAME] | 6 | 4 | 4 | 4 | 12 | 8 | 5 | 7 | 9 |  | 6 | 6 | 5 | 5 | 8 | 7 | 5 | 5 | 10 |  |  | 33
[NAME] | 4 | 4 | 5 | 8 | 5 | 5 | 5 | 4 | 5 |  | 4 | 3 | 4 | 4 | 5 | 4 | 5 | 4 | 5 |  |  | 12
George | 4 | 3 | 4 | 4 | 5 | 6 | 6 | 4 | 5 |  | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 |  |  | 9
ESC Scores
Hole | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | Front | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | Back | Gross | HCP | NET
Par | 4 | 3 | 4 | 4 | 5 | 4 | 3 | 4 | 5 |  | 4 | 3 | 4 | 4 | 5 | 3 | 4 | 4 | 5
Fred |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
George |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
Fred's HCP is 24.  Most he can score on a hole is a 8.
[NAME]'s HCP is 33.  Most he can score on a hole is a 9.
[NAME]'s HCP is 12.  Most he can score on a hole is a 7.
George's HCP is 9.  Most he can score on a hole is double bogey (2 over Par).
And a golfer with a HCP of 40 plus.  Most he can score on a hole is 10
Spreadsheet: 810775d1672057933-auto-formulas-from-one-sheet-to-another-autoformula-column-i
Sheet: Feiertage

Feiertage |  | Falls ein Feiertag ein Sonntag ist bitte Streichen !
2020-01-01 00:00:00 | Neujahr
2020-04-10 00:00:00 | [NAME]
2020-04-13 00:00:00 | Ostermontag
2020-05-01 00:00:00 | Tag der Arbeit
2020-05-21 00:00:00 | [NAME]
2020-06-01 00:00:00 | Pfingstmontag
2020-06-11 00:00:00 | Fronleichnam
2020-10-03 00:00:00 | Tag der [NAME]
 |  |  | 2020-11-01 00:00:00 | Allerheiligen
2020-12-25 00:00:00 | 1 Weihnachtsfeiertag
2020-12-26 00:00:00 | 2 Weihnachtsfeiertag
2021-01-01 00:00:00 | Neujahr
2021-04-02 00:00:00 | [NAME]
2021-04-05 00:00:00 | Ostermontag
2021-05-01 00:00:00 | Tag der Arbeit
2021-05-13 00:00:00 | [NAME]
2021-05-24 00:00:00 | Pfingstmontag
2021-06-03 00:00:00 | Fronleichnam
 |  |  | 2021-10-03 00:00:00 | Tag der [NAME]
2021-11-01 00:00:00 | Allerheiligen
2021-12-25 00:00:00 | 1 Weihnachtsfeiertag
 |  |  | 2021-12-26 00:00:00 | 2 Weihnachtsfeiertag
2022-01-01 00:00:00 | Neujahr
2022-04-15 00:00:00 | [NAME]
2022-04-18 00:00:00 | Ostermontag
 |  |  | 2022-05-01 00:00:00 | Tag der Arbeit
2022-05-26 00:00:00 | [NAME]
2022-06-06 00:00:00 | Pfingstmontag
2022-06-16 00:00:00 | Fronleichnam
2022-10-03 00:00:00 | Tag der [NAME]
2022-11-01 00:00:00 | Allerheiligen
 |  |  | 2022-12-25 00:00:00 | 1 Weihnachtsfeiertag
2022-12-26 00:00:00 | 2 Weihnachtsfeiertag
Spreadsheet: 692146d1598116823-combine-payments-to-specific-payment-days-but-split-at-crossover-point-between-2-months-month-end-v2
Sheet: Month-End

Month | Year | Last Day of Month | Day of left | Last Working Day of Month, inc Holidays | Day of left
Dec | 2020-12-01 00:00:00
Jan | 2021-01-01 00:00:00
Feb | 2021-02-01 00:00:00
Mar | 2021-03-01 00:00:00
Apr | 2021-04-01 00:00:00
May | 2021-05-01 00:00:00
Jun | 2021-06-01 00:00:00
Jul | 2021-07-01 00:00:00
Aug | 2021-08-01 00:00:00
Sep | 2021-09-01 00:00:00
Oct | 2021-10-01 00:00:00
Nov | 2021-11-01 00:00:00
Dec | 2021-12-01 00:00:00
Jan | 2022-01-01 00:00:00
Feb | 2022-02-01 00:00:00
Mar | 2022-03-01 00:00:00
Apr | 2022-04-01 00:00:00
May | 2022-05-01 00:00:00
Jun | 2022-06-01 00:00:00
Jul | 2022-07-01 00:00:00
Aug | 2022-08-01 00:00:00
Sep | 2022-09-01 00:00:00
Oct | 2022-10-01 00:00:00
Nov | 2022-11-01 00:00:00
Dec | 2022-12-01 00:00:00
Jan | 2023-01-01 00:00:00
Feb | 2023-02-01 00:00:00
Mar | 2023-03-01 00:00:00
Apr | 2023-04-01 00:00:00
May | 2023-05-01 00:00:00
Jun | 2023-06-01 00:00:00
Jul | 2023-07-01 00:00:00
Aug | 2023-08-01 00:00:00
Sep | 2023-09-01 00:00:00
Oct | 2023-10-01 00:00:00
Nov | 2023-11-01 00:00:00
Dec | 2023-12-01 00:00:00
Jan | 2024-01-01 00:00:00
Feb | 2024-02-01 00:00:00
Mar | 2024-03-01 00:00:00
Apr | 2024-04-01 00:00:00
May | 2024-05-01 00:00:00
Jun | 2024-06-01 00:00:00
Jul | 2024-07-01 00:00:00
Aug | 2024-08-01 00:00:00
Sep | 2024-09-01 00:00:00
Oct | 2024-10-01 00:00:00
Nov | 2024-11-01 00:00:00
Dec | 2024-12-01 00:00:00
Spreadsheet: c78a6f0d-3617-4f5f-a7cb-150abdde429a
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 |  |  |  |  |  |  | WORKFORCE
 |  |  |  |  |  |  | BRANCH: ORANGE
 |  |  |  |  |  |  | TIMESHEET: send approved timesheets to [EMAIL]
 |  |  |  |  |  |  | or FAX to: 1300 301 994 before 9am Monday
 |  |  |  |  |  |  | PAYROLL queries: Ph 1300 853 100
 |  |  |  |  |  |  | PAYROLL queries email: [EMAIL]
Time Sheet
Week ending day & date |  |  |  |  | Client Name
Employee Name |  |  |  |  | Client Address
Employee Position
Client Cost Centre |  |  |  |  | Supervisor's Name
[NAME] |  |  |  |  | Supervisor's Title
Employee's Signature |  |  |  |  | [NAME]'s Signature
By signing this, you are verifying the hours worked, that you are satisfied with the work completed and that you accept the Chandler Macleod Terms of Business. If you have not been provided with the Chandler Macleod Terms of Business, please contact your Consultant.
Day | Date | Time Start use AM/PM or use 24hr clock | Time Finish use AM/PM or use 24hr clock | Less Lunch | Hours Worked |  |  |  |  |  |  | Allowances
 |  |  |  |  | Ordinary | Shift | T 1/2 | T 2 | T 2 1/2 | Public Holiday | Total Hours or Days | Meal | Travel | Other:
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
 |  |  | Total Hours or Days
Send original receipts and client approval to [NAME], Suite 3, 24 Sale Street, ORANGE NSW 2800
August 2010
Spreadsheet: 741822d1627376157-how-to-highlight-value-in-cell-based-on-maximum-value-in-another-column-example
Sheet: Data

Deformation | Deformation | Load, P |  | Area                            A, m2 | qu,                 kPa |  |  |  | 100
D h, [NAME] | e1,% | N | kN |  |  |  |  |  | 65
0 |  | 0 |  |  | 0
0.07 |  | 4
0.25 |  | 6
0.41 |  | 7
0.9 |  | 9
1.09 |  | 10
1.27 |  | 11
2.7 |  | 14
4.26 |  | 17
5.69 |  | 19
7.09 |  | 20
8.69 |  | 22
10.1 |  | 24 |  |  |  |  |  | qu, kPa
11.71 |  | 25 |  |  |  |  |  | Deformation
12.95 |  | 25
Spreadsheet: 142669d1329952107-sumproduct-condition-to-avoid-duplicates-daddy_duplicate-test
Sheet: Sheet1

 | BUID | ORDER_NUM | CASE_ID | Order Date Week | Status
 | 4747 | 390131977 | 17275173 | 201245 | Confirmed
 | 7878 | 389174384 | 16768143 | 201244 | Confirmed
 | 7878 | 386472799 | 17275173 | 201244 | Confirmed
 | 7878 | 394607923 | 17275173 | 201244 | Confirmed
 | 3232 | 389711672 | 16793172 | 201245 | Pending
 | 7878 | 395261795 | 17221810 | 201245 | Confirmed
 | 7878 | 387159908 | 16582637 | 201245 | Pending
 | 3232 | 390029304 | 16787467 | 201245 | Pending
 | 3232 | 396236176 | 16793172 | 201245 | Pending
 | 3232 | 387361553 | 16589484 | 201245 | Confirmed
 | 3232 | 396493272 | 17393829 | 201244 | Pending
 | 3232 | 396061129 | 16793172 | 201245 | Pending
 |  |  |  |  |  |  |  |  | I | J
 |  |  |  |  |  |  |  |  | 201244 | 201245
 |  |  |  |  |  |  | 17 | Confirmed
 |  |  |  |  |  |  | 18 | Pending
Spreadsheet: 5e942752-9f69-4c82-9ee6-12823f099c3b
Sheet: Sheet1

Kérjük, a működtetési terv kitöltése [NAME] nevét és Ügyfél-regisztrációs számát. (Az Ön által megadott adatok a további munkalapokon automatikusan kitöltésre kerülnek) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Ügyfél neve:
ÜR-szám:
 |  | Pontszám | Súlyozás
I. | Fejlesztés összefoglaló | 2 | 0.06666666666666667
II. | [NAME] | 5 | 0.1666666666666667
III. | Fejlesztés bemutatása | 10 | 0.3333333333333333
IV. | Fejlesztés várható hatásai | 4 | 0.1333333333333333
V. | Pénzügyi fenntarthatóság | 3 | 0.1
VI. | Kockázatelemzés | 6 | 0.2
 | [NAME] | 30 | 1
+ VII. | Kommunikációs terv | 5
+ VIII. | Társadalmi felelősségvállalás | 5
[NAME] |  | 10
Spreadsheet: 68662d1269263020-help-with-formula-to-pull-multiple-criterian-from-one-sheet-to-an-organized-list-everything-lookup
Sheet: EVERYTHING

SKU # |  | S/O # | SERIAL # | MODEL # | SKU # | GRADE | BATCH # | [NAME] | [NAME] |  | Total # of S/O #'s:
 |  |  |  |  |  |  |  |  |  |  | # of D-Units:
BATCH #
11
Serial No.
S/O #
[NAME]
[NAME]
89590757
Spreadsheet: michelle_lokay__26627__imbalsumm0102
Sheet: williams

 | Milagro |  | La Maquina |  | [NAME] |  | [NAME]
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 334710 | 339430 | 67545 | 70147 | 44382 | 44890 | 165424 | 152641
2 | 234782 | 259819 | 87870 | 67797 | 30709 | 34191 | 121870 | 130584
3 | 326583 | 336985 | 74701 | 67075 | 39819 | 31890 | 165343 | 168246
4 | 339550 | 338460 | 42482 | 48418 | 41469 | 31612 | 144642 | 153213
5 | 349246 | 334305 | 50756 | 54026 | 67157 | 54143 | 142121 | 168899
6 | 337262 | 324264 | 36102 | 53490 | 64150 | 53026 | 153231 | 155563
7 | 332993 | 303628 | 42736 | 42944 | 50435 | 50798 | 105619 | 124843
8 | 307104 | 325011 | 63040 | 42549 | 50873 | 50798 | 146689 | 153033
9 | 306848 | 324109 | 64681 | 50949 | 49838 | 50798 | 159074 | 150892
10 | 308723 | 312337 | 67005 | 53977 | 47323 | 51076 | 150287 | 152804
11 | 300617 | 316052 | 72069 | 52123 | 53004 | 51076 | 154997 | 159282
12 | 229737 | 240639 | 61485 | 53645 | 51578 | 51076 | 164079 | 157654
13 | 298122 | 301530 | 52306 | 48956 | 51386 | 50891 | 168284 | 161725
14 | 303241 | 324918 | 70360 | 45341 | 52022 | 50757 | 129217 | 127195
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-01-31 00:00:00 |  |  |  |  |  |  |  |  | -44467
2001-02-14 00:00:00
 |  |  | 516.78
 |  |  | 212.08
 |  |  | 58.33
 |  |  | 25
Spreadsheet: 125983d1319458662-creating-multiple-leaderboards-from-one-set-of-data-siress-1
Sheet: Statistics

Statistics
Overall Points Leaders
1
2
3
4
MIG
1
2
3
4
ARC
1
2
3
4
TIG Steel
1
2
3
4
TIG Aluminum
1
2
3
4
GAS
1
2
3
4
Spreadsheet: 613451ab-348a-4932-b143-2c3e10964aed
Sheet: El-Civics

Grant: |  | EL CIVICS
CFDA # |  | 84.002
GRANT NUMBER: |  | 6002
FISCAL YEAR: |  | 2013-14
[NAME]: |  | Not allowed on this grant
Question regarding payments: |  | [NAME]-866-6724 or [EMAIL]
Questions regarding grant: |  | Marti Rodriguez  [PHONE] or [EMAIL]
GBL/ORG: |  | 614M/7000
LAST DAY TO SUBMIT REQUESTS FOR THIS GRANT  - SEPTEMBER 30, 2014
Code | District/Agency Name | ALLOCATION | PAYMENTS TO DATE | BALANCE | July  2013 | August  2013 | September  2013 | October  2013 | November  2013 | December  2013 | January  2014 | February  2014 | March  2014 | April  2014 | May  2014 | June  2014 | July  2014 | August  2014 | September  2014
0030 | ILC | 102832 |  |  |  |  |  |  | 29390 | 17259 |  | 10940
1010 | Adult & Family Education SD11 | 124565 |  |  |  |  |  | 6499 | 5944 | 9540 |  | 4236
1420 | [NAME] Dual Language | 68126 |  |  |  |  |  | 10422 | 8692 | 8441 |  | 3910
2180 | Montrose School District RE-1J | 16897 |  |  |  |  | 557 |  |  | 4937
Y001 | TSJC - Adult Education Services | 34000 |  |  |  |  |  | 5049 |  |  | 10098
Y014 | El  Comite de Longmont-St Vrain Adult Education | 35990 |  |  |  |  |  |  |  |  |  | 1935
[NAME] | Focus Points Family Resource Center | 100011 |  |  |  |  | 23234 | 14801 | 18006 | 15240 | 12937 | 7364
Y695 | Learning Source | 85609 |  |  |  |  |  | 8572 | 5000 | 1500 | 8000
Y699 | Northeastern Junior College | 33504 |  |  |  |  |  | 7300 |  | 6501
Y701 | Spring Institute for Intercultural Learning | 106413 |  |  |  |  | 11834 | 7932 | 9994 | 8288 | 7765 | 6859
Y703 | MCC | 53521 |  |  |  |  |  | 1651 |  |  | 16525
Y705 | Durango Adult Education Center,  Inc. | 50000 |  |  |  |  | 10000 | 5000 |  | 5000 | 5000 | 5000
Y711 | Right to Read Weld | 11045 |  |  |  | 1004 | 1004 | 1300 | 1300 | 1100
Y815 | Asian Pacific | 22000 |  |  |  |  |  |  | 3266 | 2562 |  | 2070
Spreadsheet: 708072d1607608577-simplifying-a-very-old-worksheet-bourn
Sheet: Donnelly

hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | INDEX 1 | INDEX 2 | INDEX 3 | points | handicap | handicap | HANDICAPPING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 295500d1391712567-creating-a-time-off-tracker-for-work-and-i-am-at-a-total-loss-track
Sheet: People in Department

Employee Name | Pto Given | PTO Used | Pto Left
employee a | 320
employee b | 280
employee c | 320
employee d | 280
employee e | 120
employee f | 120
employee g | 120
employee h | 160
employee i | 54
employee j | 240
employee k | 160
employee l | 160
employee m | 132
employee n | 160
employee o | 101
employee p | 320
employee q | 100
Spreadsheet: 887863d1738184172-sorting-customer-data-in-excel-while-keeping-related-dates-aligned-testcopyonline
Sheet: Ark1

Customer Name | Country | Person | Customer ID
[NAME] | Norway | Anne | 123
Beta | Sweden | Fabian | 456
Delta | Germany | [NAME] | 789
Ekko | Estonia | [NAME] | 102
[NAME] | France | [NAME] | 106
Gamma | Denmark | Sven | 21212
Spreadsheet: 145951d1331827532-combine-results-from-one-work-sheet-to-another-with-item-count-test
Sheet: Filter Order Form

Desired Results
Number | Qty
[NAME] | 1
LF3970 | 2
LF3630 | 4
LF667 | 1
LF3313 | 2
LF3883 | 1
FF5019 | 1
FF5245 | 2
FF185 | 3
FF209 | 2
ff5035 | 3
AF364 | 1
AF25130M | 2
AF1878 | 3
AF1731 | 1
AF987 | 1
AF1731 | 1
AF26154 | 1
AF979M | 1
WF2074 | 2
WF2051 | 3
WF2053 | 2
WF2071 | 1
FS19798 | 3
FS19513 | 4
FS20403 | 1
FS19798 | 1
FS20403 | 2
TF15002 | 3
TF15025 | 4
TF15000 | 4
CCV | 11
Spreadsheet: 14b5fbfb-66f0-44da-b16d-9f40cd2c05f0
Sheet: Sheet1

DELTA AIR LINES INC /DE/ | Unnamed: 1
10-Q
[NAME]
Balance Sheet
Table of Contents
 | Page
Forward Looking Statements | 1
Part I. Financial Information
Item 1. Financial Statements | 2
Consolidated Balance Sheets | 2
Condensed Consolidated Statements of | 3
Operations and Comprehensive Income
Condensed Consolidated Statements of | 4
Cash Flows
Notes to the Condensed Consolidated Financial | 5
Statements
Item 2. Management's Discussion and Analysis | 14
of Financial Condition and Results of Operations
Item 3. Quantitative and [NAME] | 25
about Market Risk
Item 4. Controls and Procedures | 26
Part II. Other Information
Item 1. Legal Proceedings | 28
Item 1A. Risk Factors | 28
Item 2. Unregistered Sales of Equity Securities | 28
and Use of Proceeds
Item 6. Exhibits | 28
Signature | 29
____________________________
Created by Morningstar Document Research.
http://documentresearch.morningstar.com/
Spreadsheet: 775753d1649297884-how-to-get-the-data-of-column-c-from-the-more-to-less-repeated-column-a-help407
Sheet: Sheet1

DATA
3 |  | 0
 |  | 3
 |  | 5
 |  | 6
 |  | 4
4 |  | 8
 |  | 2
 |  | 7
5
0
0
3
8
2
0
8
5
7
6
5
0
3
6
4
5
0
3
6
3
Spreadsheet: 144793d1331138577-count-within-an-if-statement-example-speeding
Sheet: Matrix

Vehicle Registration Number | Branch Code | Area | Regional Trading Director | Area Trading Manager | Network Manager | GVW | 30 mph | 40mph | 50mph | 60mph | 70mph
 |  |  |  |  |  |  | 45 | 7 | 3 | 0 | 0
Spreadsheet: 812bfaa0-bcbc-4eff-b740-044f10560f7a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 | Oplevet effekt af resultatløn
 | suvey blandt kommunale ledere
 | I hvilken grad vurderer I, at resultatlønnen har ført til, at medarbejderne [NAME] ekstra indsats over for målgruppen?
 |  | Antal | Pct
 | Slet ikke | 8 | 33.3
 | I mindre grad | 13 | 54.2
 | I nogen grad | 1 | 4.2
 | I høj grad | 0 | 0
 | [NAME] | 2 | 8.3
 | I alt | 24 | 100
 | KILDE: Rambøll management
Spreadsheet: 793735d1661676959-show-sum-beside-the-last-value-of-b-column-rnet
Sheet: after

Date | Amount
2022-08-27 00:00:00 | 135
2022-08-28 00:00:00 | 135
2022-08-29 00:00:00 | 135
 | 100
Spreadsheet: mary_fischer__25620__77M
Sheet: E20.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  077M
COMPANY NAME    MEP Services, Inc.
ANALYSIS OF OTHER INCOME AND DEDUCTIONS
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  |  |  |  |  |  |  | E-20
[NAME] |  | 1ST QTR |  | 2ND QTR |  | 3RD QTR |  | 4TH QTR |  | YEAR TO DATE
OTHER INCOME - OTHER
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Other Income - Other
(MUST TIE TO HYPERION ACCOUNT 1690)
Income Accts:  DR/(CR)
Reverse signs from Hyperion
[NAME] |  | 1ST QTR |  | 2ND QTR |  | 3RD QTR |  | 4TH QTR |  | YEAR TO DATE
OTHER DEDUCTIONS - OTHER
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Other Deductions - Other
(MUST TIE TO HYPERION ACCOUNT 1775)
Asset/Expense Accts:  DR/(CR)
Same signs as Hyperion
 |  |  |  |  |  |  |  |  |  | E-20
Spreadsheet: 33f85aea-fa39-48c9-bc2d-02a62259f7b7
Sheet: Sheet1

Table S2.  qPCR validation of Class 4 CNVs | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Segment | CGH copy number | qPCR copy number | [NAME] | Validation | Forward primer | Reverse primer
1_95 | 2.019130309123775 | 2.106100428596774 | 0.33 | Yes | ATAGCGTGCATAAACCATGTGATTCC | GCGGATCTGCTTTGATTTCCTAAAAC
10_104 | 2.02227887921035 | 3.937477189400469 | 2.6 | Yes* | TATCAAGGAGTGCAGGAAGGAGACAC | AAGATCTGCGTGTCAAACTGAAGGAC
2_1446 | 2.097409291674926 | 2.165970457635311 | 0.503 | Yes | AAAGGCAGACCAACTGAAAAAGAAGG | ACCAACCGAGGGTCTATGTAAATTCG
8_2178 | 2.114854429465928 | 1.888188632531147 | 0.31 | Yes | GACAGAAGCCAAATGGTTCATACAGG | CTGCTGTTATGTTTATGCCTGGCTTC
2_2850 | 2.234838602029989 | 1.863 | 0.22 | Yes | CTACCGGGCAAGAGTTTATCAGAACC | TCTTTCGGTTTGCATTTTATGGTCAG
4_308 | 2.341615936393778 | 2.554272122253655 | 0.58 | Yes | GATAATCAAACTTGACCACGCCACTC | CGAGCTCTATCACTGCTTCTGGTCTC
5_104 | 2.34927505645976 | 1.767685843546895 | 0.29 | Yes | GTAGCTAAATTTGAGAGCGCACATCG | CATGAATGAGCAAATCCAGATCACAG
8_2206 | 2.363845666208847 | 2.007874223045929 | 0.22 | Yes | ACTGTCAACGTCCTTCTGCATCTTTC | AGTGTTCTCGCAGTTCAGCAATAAGG
8_2152 | 2.505966104827914 | 5.021088773851329 | 0.84 | Yes* | GGTAAAAGGGGAGCTCGGTACTAACC | AACCAGCATGCCATTTTGTGATTTAG
1_4146 | 2.892876583882214 | 3.302330619249998 | 0.78 | Yes | [NAME] | GAGTTGCCCATAGCTTTACCTCCATC
5_2925 | 3.435006238718121 | 8.510317161097097 | 2.3 | Yes* | AAAGAAGTTAACAGAGAGGCCGCAAG | ATTGGAATGGAGGGAGTGTTATTTGG
10_69 | 4.967456900962587 | 1.153201724242763 | 0.56 | No | CAACGAGGAAGTGGTACTGCATTTTC | [NAME]
[NAME] control |  | 1.143327381705658 | 0.24 |  | GATGATGCGCCAAGAGCTG | GCCTCATCACCTACGTAGGCAT
Fie1 control |  | 1.143327381705658 | 0.31 |  | CAATGACAATGCACTTCCTTAAATCCCTA | CCTTTTTCCACACTTGTTTTGGTGAA
Mez1 control |  | 1.135245402953302 | 0.21 |  | TGTATTCGATATTTTATGCTGACGGAGGAA | TCGGTACGTGTGAGCGTTATTATGG
*The qPCR actually suggests even greater CNV than the aCGH
Spreadsheet: 168167d1342276440-lookup-values-accross-several-sheets-to-create-summary-sheet-example-workbook
Sheet: Playerstats

 | Players | Cup | Playoffs | Goals | Cup goals | [NAME]
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
28
29
30
31
32
33
34
35
36
37
38
39
40