tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 865859d1712839601-xlookup-accross-3-tabs-maybe-not-best-solution-help
Sheet: Days

 |  |  | EMPLOYEE'S DAILY / WEEKLY TIME RECORD
INDUSTRIAL - DAYS
 |  |  | WEEK 1(Pay week#2)
MECHANICS |  |  | SUN. |  | MON. |  | TUES. |  | WED. |  | THURS. |  | FRI. |  | SAT.
 |  |  | 2024-04-07 00:00:00 |  | 2024-04-08 00:00:00 |  | 2024-04-09 00:00:00 |  | 2024-04-10 00:00:00 |  | 2024-04-11 00:00:00 |  | 2024-04-12 00:00:00 |  | 2024-04-13 00:00:00
BOOKED STAFF |  |  | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN | CODE | TIME IN
128176 | Ryann | Barajas | DO |  |  |  |  |  |  |  |  |  |  |  | DO
3362 | Brennan | Cortez | DO |  |  |  |  |  |  |  |  |  |  |  | DO
123981 | Haven | Wilkinson | DO |  | Vac | 8 |  |  |  |  |  |  |  |  | DO
3322 | Leonard | Villa | DO |  | Sick | 8 |  |  |  |  |  |  |  |  | DO
128167 | [NAME] | Pearson | DO |  | SICK | 8 | SICK | 8 | SICK | 8 | SICK | 8 | SICK | 8 | DO
128968 | Gunner | Haley | DO |  |  |  |  |  |  |  |  |  |  |  | DO
155064 | Addilynn | [NAME] | DO |  |  |  |  |  |  |  |  |  |  |  | DO
Spreadsheet: 871983d1718357919-combining-cells-over-sheets-and-keeping-conditional-formatting-example-sheet
Sheet: Sheet1

Preferred Forename | Preferred Surname | Reg | Overall Category
Jessica | [NAME] | a | Graduated
[NAME] | [NAME] | a | Graduated
[NAME] | [NAME] | a | Graduated
[NAME] | Brooks | a | Honours
[NAME] | Rogers | a | Honours
[NAME] | [NAME] | b | Honours
[NAME] | [NAME] | b | Graduated
Darcy | [NAME] | b | Graduated
[NAME] | Turner | c | Special Mention
[NAME] | Perkins | c | Special Mention
Spreadsheet: michael_maggi__26465__NYMEXWEEKLY
Sheet: ng

 |  |  |  |  |  |  |  | 0..
Week Ending: | 2001-10-19 00:00:00
 | Futures Settlement Prices (in  $/MMBtu)
 | HENRY HUB NATURAL GAS |  |  |  |  | Contract Symbol:  NG
 | Contract | Monday | Tuesday | Wednesday | Thursday | Friday | Open
 | Month | 2001-10-15 00:00:00 | 2001-10-16 00:00:00 | 2001-10-17 00:00:00 | 2001-10-18 00:00:00 | 2001-10-19 00:00:00 | Interest
 | 2001-11-01 00:00:00 | 2.378 | 2.592 | 2.418 | 2.486 | 2.681 | 53678
 | 2001-12-01 00:00:00 | 2.66 | 2.852 | 2.703 | 2.8 | 2.99 | 51812
 | 2002-01-01 00:00:00 | 2.852 | 3.037 | 2.898 | 2.99 | 3.171 | 49372
 | 2002-02-01 00:00:00 | 2.85 | 3.032 | 2.901 | 2.997 | 3.173 | 29351
 | 2002-03-01 00:00:00 | 2.81 | 2.982 | 2.866 | 2.965 | 3.126 | 31890
 | 2002-04-01 00:00:00 | 2.727 | 2.889 | 2.786 | 2.883 | 3.031 | 37775
 | 2002-05-01 00:00:00 | 2.757 | 2.911 | 2.816 | 2.918 | 3.059 | 19402
 | 2002-06-01 00:00:00 | 2.804 | 2.956 | 2.866 | 2.968 | 3.109 | 14933
 | 2002-07-01 00:00:00 | 2.847 | 2.999 | 2.914 | 3.013 | 3.151 | 13674
 | 2002-08-01 00:00:00 | 2.89 | 3.042 | 2.961 | 3.058 | 3.191 | 30186
 | 2002-09-01 00:00:00 | 2.892 | 3.039 | 2.961 | 3.058 | 3.191 | 18327
 | 2002-10-01 00:00:00 | 2.92 | 3.059 | 2.986 | 3.083 | 3.214 | 24078
 | Total Weekly Volume
 |  |  | 385161 |  | Total Open Interest |  | 520469
 |  |  |  | *Weekly volume and open interest reflects all traded months.
 | Historial Volatility-Spot Month Futures
 |  |  |  | [NAME]
 | 5 Day Hist. Vol. |  |  | 1.1451
 | 20 Day Hist. Vol. |  |  | 1.041
 | Implied Volatility-Options |  |  | [NAME]
 | At the Money Call & Put |  |  | 0.9112
Spreadsheet: 268548d1380683141-desired-multiple-data-into-single-cell-09-13
Sheet: ABS

DUTY ATTENDANCE ABSTRACT OF HOME GUARDS PS NIRMAL - TOWN (NIGHT BEAT) FOR THE MONTH OF SEPTEMBER -  2013
Sl.No. | [NAME]. | 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 | No. of Days Present | No. of Days Absent
1 | 334 | RAMULU
2 | 341 | N VENKATESH
3 | 358 | CH SANJEEV KUMAR
4 | 365 | M A SALEEM
5 | 397 | V C RAMESH
6 | 483 | B V TIRUPATHI RAO
7 | 489 | G MAHENDER
8 | 523 | MD MUSTAQ
9 | 537 | G.VINOD
10 | 557 | M A KALEEM
11 | 750 | A SHIVA KRISHNA
12 | 827 | G KIRAN KUMAR
13 | 994 | K NARENDER
14 | 997 | SD MUJAHID ALI
Certificate:
 |  |  |  |  |  |  |  |  | This is to certify that the above HGs have attended
 |  |  |  |  |  |  |  |  | and performed their duties on the above dates are corect".
DUTY ATTENDANCE ABSTRACT OF HOME GUARDS PS NIRMAL - TOWN (General Duties) FOR THE MONTH OF SEPTEMBER  - 2013
Sl.No. | [NAME]. | 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 | No. of Days Present | No. of Days Absent
1 | 13 | M RAMESH
2 | 172 | M A LATEEF
3 | 288 | NAMDEV
4 | 302 | SD JAVEED ALI
5 | 308 | S CHINNAMMA
6 | 315 | SK WALI HYDER
7 | 321 | T SRINIVAS
8 | 327 | P PRAVEEN KUMAR
9 | 369 | K RAMAKRISHNA
10 | 490 | KHAJA IQBALUDDIN
11 | 572 | RAMADEVI
12 | 573 | G VENU
13 | 691 | BHARATH SINGH
14 | 1054 | MD FIRDOS AHMED
Certificate:
 |  |  |  |  |  |  |  |  | This is to certify that the above HGs have attended
 |  |  |  |  |  |  |  |  | and performed their duties on the above dates are corect".
DUTY ATTENDANCE ABSTRACT OF HOME GUARDS PS NIRMAL - TOWN (TRAFFIC) FOR THE MONTH OF SEPTEMBER - 2013
Sl.No. | [NAME]. | 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 | No. of Days Present | No. of Days Absent
1 | 311 | A CHINNA REDDY
2 | 455 | M.SANTHOSH
3 | 488 | R SUDHAM
4 | 524 | V RAVINDER
5 | 534 | K SHEKAR
6 | 990 | K SUDERSHAN
7 | 993 | K SAGAR
8 | 996 | SHIVA PRAKASH
Certificate:
 |  |  |  |  |  |  |  |  | This is to certify that the above HGs have attended
 |  |  |  |  |  |  |  |  | and performed their duties on the above dates are corect".
Spreadsheet: 68435d1268956724-excel-2007-help-populating-cells-according-to-combinations-722322-combinations
Sheet: Sheet1

[NAME]: | 20 | 10 | 2 | [NAME] columns to left as needed
Count: | 2 | 5 | 2
 | Item 1 | Item 2 | Item 3
 | 12 mos | 5 Data pack | New | Add items as needed, no interspersed blanks
 | 24 mos | 10 Data pack | Upgrade
 |  | 29 Data pack
 |  | 39 Data pack
 |  | 59 Data pack
# | Permutations |  |  | [NAME] rows above as needed
1 | 12 mos | 5 Data pack | New
2 | 12 mos | 5 Data pack | Upgrade
3 | 12 mos | 10 Data pack | New
4 | 12 mos | 10 Data pack | Upgrade
5 | 12 mos | 29 Data pack | New
6 | 12 mos | 29 Data pack | Upgrade
7 | 12 mos | 39 Data pack | New
8 | 12 mos | 39 Data pack | Upgrade
9 | 12 mos | 59 Data pack | New
10 | 12 mos | 59 Data pack | Upgrade
11 | 24 mos | 5 Data pack | New
12 | 24 mos | 5 Data pack | Upgrade
13 | 24 mos | 10 Data pack | New
14 | 24 mos | 10 Data pack | Upgrade
15 | 24 mos | 29 Data pack | New
16 | 24 mos | 29 Data pack | Upgrade
17 | 24 mos | 39 Data pack | New
18 | 24 mos | 39 Data pack | Upgrade
19 | 24 mos | 59 Data pack | New
20 | 24 mos | 59 Data pack | Upgrade
Spreadsheet: 4ac452d7-6417-4cad-a660-6fa20556b5e4
Sheet: Noten B + Es

Priv. | Archiv | Titel der Sammlung | Seite/Nr. | Titel der Komposition | Nr. | Komponist | Arrangeur | [NAME] | Besetzung | Anmerkung | Einstufung
Es/535 |  |  |  | [NAME] |  | [NAME] |  |  | 3 Pf.B+4Pf.Es+4Alph.F |  | #
Es/586 |  |  |  | Dr.[NAME] |  | [NAME] |  | A.:Sollfelner | 4Es+3Fpl+2PfB | und Blasorchester | #
[NAME] |  |  |  | Festliche Jagdhornklänge |  | SchreierBernhard |  |  | 3 Pf.Es + 2 F.Pl. |  | #
Es/429 |  |  |  | [NAME] |  | [NAME] |  |  | 3Pl.+2Pf.+ 5 Pf.Es |  | #
Es/587 |  |  |  | Freischütz - Melodienfolge |  | [NAME] |  |  | 4Es+3Fpl+2PfB | und Blasorchester | #
Es/578 |  |  |  | Große Jagdhornfanfare |  | Banco Gerhart |  | [NAME] | 3 FP.+1PfB+4PfEs |  | #
Es/670 |  |  |  | Ich schieß den [NAME]... |  | [NAME] |  |  | 4 Pf.Es+ 3Fpl.+2Pf.[NAME] 1 Posaune |  | #
Es/578 |  |  |  | Im [NAME] |  | Banco Gerhart |  | [NAME] | Theorie und Stücke |  | #
Es/003 |  | [NAME]. u. gr. Jagdhörner | 30 - 32 | Jagdfanfare |  | [NAME] |  | Zimmermann | 4 F.Pl. + 4 Es | E | #
Es/003 a |  |  |  | Jagdfanfare |  | [NAME] |  |  | 3 FPl.+2Pf.B+4Pf.Es | E | #
Es/650 |  |  |  | [NAME] |  | [NAME] |  |  | 4 Es+3FPl.+2Pf [NAME] gem Chor |  | #
Es/1177 |  |  |  | Jagdhornklänge aus bekannten [NAME] |  |  | [NAME] | Eigenverlag | 3Fpl.+2 PfB+4 Es |  | # | E
Es/1116 |  |  |  | La Polka des Biches |  | [NAME]Gruyer | Damm Peter |  | 1 FPl.+2Pf.B+4Pf.Es |  | #
Es/789 |  |  |  | Melodienaus d.Oper "Der Freischütz" |  | Weber C.M.v. | [NAME] |  | 2FP,2 Pf.B,4 Pf.Es und Musikanten+4Waldh. | mit Chor | #
Es/651 |  |  |  | Muss i denn |  | Hayden Johann |  |  | 4 Es+3FPl.+2Pf B+ 1Tp. |  | #
Es/0963 |  |  |  | [NAME] |  | [NAME] | Damm Peter |  | 1 FP + 2 Pf-B + 4 |  | #
Es/510 |  |  |  | Polka für Es- und B-Hörner |  | [NAME] |  |  | 4 | u.3FPl.+3Parf.B | #
G/610 |  |  |  | s is Feierab`nd |  | Hayden Johann | Eigenverlag |  | 3Pl.+2Pf.+4 Es |  | # | E
Es/0968 |  |  |  | Suite für Naturhörner |  | [NAME] |  |  | 1 Pf-B+ 3 Pf Es |  | #
Es/652 |  |  |  | Ulanenritt |  | [NAME] |  |  | 4F + 1 Tromp.B |  | #
ES/506 |  |  |  | [NAME] ins greane Tal |  | [NAME] |  |  | 4 | u. 3Pl. + 2 Pf.B +Quintett | #
Es/337 |  |  |  | Waldszenen |  | Kretz Andreas |  |  | ES u.B | mit [NAME] | #
Es/671 |  |  |  | Weinviertler-Mährische Treibjagd |  | [NAME] |  | Eigenverlag | 2FP,2 Pf.B,4 Pf.Es und Musikanten |  | #
Es/532 |  |  |  | [NAME] und Alphorn sch. |  | [NAME] |  |  | [NAME].F+4Pf.Es+3 Fpl.+2 Pf.B |  | #
Es/578 |  |  |  | [NAME] |  | Banco Gerhart |  | [NAME] | 3 FP.+1PfB+4PfEs |  | #
Spreadsheet: 142900d1330081074-excel-2010-if-statement-to-pull-through-start-and-end-dates-of-a-project-test
Sheet: Project Scheduling

 |  |  |  | 2012
BUILDING NO | BUILDING | PROJECT | Type | 2012-01-31 00:00:00 | 2012-02-29 00:00:00 | 2012-03-31 00:00:00 | 2012-04-30 00:00:00 | 2012-05-31 00:00:00 | 2012-06-30 00:00:00 | 2012-07-31 00:00:00 | 2012-08-31 00:00:00 | 2012-09-30 00:00:00 | 2012-10-31 00:00:00 | 2012-11-30 00:00:00 | 2012-12-31 00:00:00
1 | House
 |  | Project 1 | Electrical
 |  | Project 2
 |  | Project 3
 |  | Project 4
 |  | Project 5
 |  | Project 6
 |  | Project 7
Spreadsheet: 1ea11d02-57af-4715-b09d-aac1b4970fb0
Sheet: Sheet1

Australian Bureau of Statistics | Unnamed: 1 | Unnamed: 2
Table A1. Expenditure Weights, Wage Price Index, Australia
Released at 11.30am (Canberra time) 14 November 2012
 | Contents
 | Tables
 | 1 | Distribution of Expenditure on Wages, Australia by Sector
 | 2 | Distribution of Expenditure on Wages, Sector by State/Territory
 | 3 | Distribution of Expenditure on Wages, Sector by Broad Industry Group
 | Explanatory Notes
 | More information available from the ABS website
 | Wage Price Index, Australia, September 2012
 | Summary
 | Explanatory Notes
 | Inquiries
 | For further information about these and related statistics, contact the National Information and Referral Service on 1300 135 070 or Luci Burrage on Perth (08) 9360 5151.
 | © Commonwealth of Australia 2012
Spreadsheet: 822317d1679262294-shopping-list-generator-find-recipe-in-table-return-ingredients-and-amounts-shopping-list-generator-find-recipe-in-table-return-ingredients-and-amounts
Sheet: Sheet1

 |  |  | Ingredients | Amounts
 | Meals | [NAME] |  |  |  | Meal | Sausage | Fish | Potatoes | Mushroom (g) | Pasta (g)
 |  |  | Pasta (g) | 150 |  | Sausage and [NAME] | 2 |  | 3
 |  |  |  |  |  | Fish and Chips |  | 1 | 3
 |  |  |  |  |  | [NAME] |  |  |  | 240 | 150
Spreadsheet: 767308d1644403894-need-help-to-get-the-count-based-on-criteria-sample-1
Sheet: Status Master

 | Status
# |  | Details |  | Status |  |  |  | Position
 | Not Suitable | Based on Resume |  | Pending |  |  |  | CCT
 | Not Interested | Not Interested |  | No Show |  | Offer Accepted |  | Fresher
 | Scheduled | Scheduled for Interview |  | Rejected |  | Declined Offer |  | [NAME]
 | Pending | No Response after schedule |  | On Hold |  | On Hold |  | [NAME]
 | No Show | No Show after Schedule |  | Selected |  | No Show |  | PSM
 | In Progress |  |  |  |  |  |  | SE
 | Rejected (1st) |  |  |  |  |  |  | SQA
 | Rejected (2nd) |  |  |  |  |  |  | TAS
 | Rejected (Final) |  |  |  |  |  |  | Web Designer
 | Declined Offer
 | On Hold
 | Selected
 | Selected - Not Interested | Didn't join after selection
 | Didn't join after selection
 | Duplicate
 | Offer Accepted
 | Not Yet Scheduled
 | Reschedule
 | Rejected-Online Test
Spreadsheet: 754111d1635951082-how-to-use-today-function-to-cover-an-entire-week-gantt-example
Sheet: Gantt example

Start date: | 2021-11-01 00:00:00
Display week: | 1
Task/project | Start | End
Spreadsheet: 865185d1712238421-are-there-duplicate-in-non-contiguous-columns-in-same-row-disregarding-blanks-are-there-duplicates_2
Sheet: Sheet1

Customer | [NAME] | Lead2 | Sales | Items | Manager1 | Manager2 | Sales | Items | Associate1 | Associate2 | Sales | Items |  |  | Are there Duplicate Names?
Amazon | Lomez | [NAME] | 100 | 25 | [NAME] |  | 120 | 15 | Lomez | Newman | 10 | 5 |  |  | <-- [NAME] is duplicated
Spreadsheet: 168258d1342352389-excel-2007-vlookup-returns-n-a-with-special-characters-folderlist
Sheet: Sheet2

Folder ID | [NAME]
-uecBgd@Do[XaZ.T5%0g | Bases 1
+0*2hqH"+sJ\&`X?c[sQ | Bases 2
9(Dij':``%U33O7DX@MM | Data
*5bF#XA16=XGfQRXs.&O | Data 2
!!!!!!!!!!!!!!!!!!!! | Root
3Y=A[$(c!/VH!ga`,T&u | Folder 1
gQ1rgV*`$kO9JKLjcCC" | Folder 2
N[0$CF$h<CM0qqoVjoPs | Folder 3
`&HC#GeTG1S>+s?J#A1g | Folder 5
\BqcJLABFgS<hh=?,Nhq | Folder 4
Kjo@FZoK4%T$qe.WC;kb | Folder 6
Spreadsheet: 687270d1595072630-return-last-value-from-multiple-columns-book1
Sheet: Sheet1

Name | Rating | Name | Value
[NAME] | 2 | [NAME] | 4 |  | Last rating of [NAME]
[NAME] | 4 | [NAME] | 5 |  | Last Row
Zak | 6 | Will | 2 |  | Last Column
[NAME] | 3 | [NAME] | 3
Will | 4 | Zak | 4
[NAME] | 1 | [NAME] | 5
[NAME] | 3 | Zak | 6
Spreadsheet: 106978d1304110122-birthday-paradox-simulation-test
Sheet: Sheet1 (2)

22
Spreadsheet: chris_germany__2114__Transco_Doyle_confirms_Jan_2001
Sheet: Sheet2

ENRON POWER MARKETING INC.
PROJECTED BURN RATES
DOYLE
GAS NOMINATIONS
 |  | GAS | GAS
 | DATE | NOMINATED | REQUIREMENT
 |  | via TRANSIT | ESTIMATE | LONG / SHORT | BALANCE
 |  |  |  |  | -36590 | estimate
 |  | 20000 | 15000
 |  | 20000 | 18000
 |  | 20000 | 5000
 |  | 20000 | 5000
 |  | 20000 | 18000
GAS FLOW ESTIMATES
 |  |  | ESTIMATED | ESTIMATED
 |  | TOTAL EST | TOTAL FLOW | HRLY RATE | ESTIMATED
 | DATE | FLOW HRS | QUANTITY | MMMBTU/HOUR | FLOW HRS (CST)
 |  | 3 |  | 750 | 9:00am - noon
 |  | 9 |  | 1750 | 11:45am - 9:00pm
 |  | 0 |  | 0 | 7:00pm - 9:00pm
 |  | 0 |  | 0 | 9:00am - 11:00am
 |  | 5 |  | 1000 | 10:45am - 3:00pm
 |  | 0 |  | 0 | 4:00pm - 6:00pm
 |  | 0 |  | 0 | 9:00am - 11:00am
 |  | 5 |  | 1000 | 10:45am - 3:00pm
 |  | 0 |  | 0 | 4:00pm - 6:00pm
CONTACT:    [NAME] |  |  | [PHONE]  office |  | DATE / TIME
 |  |  | [PHONE]  pager
Jason Crawford |  |  | [PHONE]  office |  | Generation Control Room (24 Hour)
 |  |  | [PHONE]  pager |  |  | [PHONE]
Spreadsheet: 124873d1318678325-required-formula-for-text-test-j
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Emp Code | 2
 |  |  |  |  |  |  |  |  | Term Begining Status | #N/A | When I Enter the emp code, the staus of term has to come in the concerned box. (For ex: when emp code 1 is given the term 1 status 'poor' should come at the term status 1 box)
 |  |  |  |  |  |  |  |  | Term 2 Status | Poor
 |  |  |  |  |  |  |  |  | Term 3 Status | Better
 |  |  |  |  |  |  |  |  | Term 4 Status | Poor
 | Emp Code | Name | Term | Term Status
 | 1 | AAAAAAAAAA | Starting | Poor
 | 2 | BBBBBBBBBB | Starting | Better
 | 3 | CCCCCCCCCCCC | Starting | Outstanding
 | 4 | [NAME] | Starting | Good
 | 1 | AAAAAAAAAA | 2 | Outstanding
 | 2 | BBBBBBBBBB | 2 | Poor
 | 3 | CCCCCCCCCCCC | 2 | Better
 | 4 | [NAME] | 2 | Good
 | 1 | AAAAAAAAAA | 3 | Poor
 | 2 | BBBBBBBBBB | 3 | Better
 | 3 | CCCCCCCCCCCC | 3 | Good
 | 4 | [NAME] | 3 | Outstanding
 | 1 | AAAAAAAAAA | 4 | Outstanding
 | 2 | BBBBBBBBBB | 4 | Poor
 | 3 | CCCCCCCCCCCC | 4 | Good
 | 4 | [NAME] | 4 | Better
 | 1 | AAAAAAAAAA | 5 | Outstanding
 | 2 | BBBBBBBBBB | 5 | Poor
 | 3 | CCCCCCCCCCCC | 5 | Good
 | 4 | [NAME] | 5 | Better
 | 1 | AAAAAAAAAA | 6 | Outstanding
 | 2 | BBBBBBBBBB | 6 | Poor
 | 3 | CCCCCCCCCCCC | 6 | Good
 | 4 | [NAME] | 6 | Better
Spreadsheet: 838441d1691009740-excel-calander-employee-absence-schedule12023
Sheet: December

 | Absence Type Key | AL | Annual Leave |  |  | P | Personal |  |  | S | Sick |  |  | Custom 1 |  |  |  | Custom 2
 | December | Dates of Absence
 | Employee 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 | Total Days | AL | Personal | Sick
 | [NAME]
 | [NAME]
 | Alsop
 | [NAME]
 | [NAME]
 | Avery
 | Bailey
 | [NAME]
 | [NAME]
 | Bell
 | Berry
 | Black
 | Blake
 | Bond
 | Bower
 | [NAME]
 | Buckland
 | Burgess
 | Butler
 | Cameron
 | Campbell
 | [NAME]
 | Chapman
 | Churchill
 | [NAME]
 | Clarkson
 | [NAME]
 | Cornish
 | [NAME]
 | Davies
 | [NAME]
 | [NAME]
 | [NAME]
 | Dyer
 | Edmunds
 | [NAME]
 | Ferguson
 | Fisher
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Glover
 | [NAME]
 | Grant
 | Gray
 | Greene
 | [NAME]
 | Hardacre
 | [NAME]
Spreadsheet: 812969d1673465304-conditional-formatting-woring-on
Sheet: DAY PROGRAM

YELLOW: AT LEAST ONE CRITICAL ITEM WAS CHECK | PRS HAS OVER 10 CRTICIAL ITEMS | SERVICES PROVIDED BY KAAUM | RESIDENTIAL | DAY PROGRAM | Mentorship | Community Connector (CES ONLY) | Personal Care | Homemaker | Respite | HEALTH | MEDICATION REMINDER BOX | MEDICATION DURING SERVICE DELIVERY | SELF ADMINISTRATION PROTOCOL | CONTROLLED MEDICATION | PSYCH MEDS | INFORMED CONSENTS | INSULIN | [NAME] | BISSP | SUSPENSION OF RIGHTS | RIGHTS RESTRICTIONS | EMERGENCY CONTROL PROCEDURE | SAFETY CONTROL PROCEDURE | TRACKING(EATING) | G-TUBE FEEDING | J-TUBE FEEDING | FEEDING ASSISTANCE | DIET TRACKING | BOWEL TRACKING | ASSISTIVE/ADAPTIVE EQUIPMENT | PROTOCOLS | MOBIITY | TRANSFERRING | WOUND CARE | SEIZURE | DIABETIES | G-TUBE | J-TUBE | BATHING | SKIN CARE | CHOKING & ASPIRATION | [NAME] | OXYGEN | [NAME] | SELF-HARM | SUICIDE IDEATION | FALL | ELOPMENT | GERD | PICA | BOWEL | ALLERGY | (ADD AS NEEDED)
Total
LAST NAME | FIRST NAME
Last Name | First Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  | Cell D4 has the formulas inside the cell for conditional formatting.  Everytime I copy the cell as in E4 it will reflect the correct formula.  If I copy the cell on more time (F4) it will not reflect the same value.  Then If I copy the cell down below (D5) it will not copy correctly and will reference to the 4 row and not the 5 row |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
Spreadsheet: 479412d1473350917-converting-rows-to-columns-converting-rows-to-columns
Sheet: Division Emp

ID | Name | Location |  |  | Location | ID | Name | ID | Name | ID | Name | ID | Name
109585 | [NAME] | 0001 | 1 |  | 0001 | 109585 | [NAME] | 110504 | [NAME] | 112264 | [NAME]
110504 | [NAME] | 0001 | 2 |  | 0006 | 113079 | [NAME] | 115254 | Aundrea McCadams | 115540 | [NAME]
112264 | [NAME] | 0001 | 3 |  | 0008 | 126861 | [NAME] | 132071 | [NAME]
113079 | [NAME] | 0006 | 4 |  | 0010 | 310832 | [NAME]
115254 | Aundrea McCadams | 0006 | 5 |  | 0011 | 367207 | [NAME]
115540 | [NAME] | 0006 | 6 |  | 0013 | 384484 | [NAME] | 383678 | [NAME] | 384484 | [NAME] | 114102 | [NAME]
126861 | [NAME] | 0008 | 7
132071 | [NAME] | 0008 | 8 |  | What I need it to look like.
310832 | [NAME] | 0010 | 9
367207 | [NAME] | 0011 | 10 |  | Location | ID | Name | ID | Name | ID | Name
383678 | [NAME] | 0013 | 11 |  | 0001
384484 | [NAME] | 0013 | 12 |  | 0006
114102 | [NAME] | 0013 | 13 |  | 0008
 |  |  |  |  | 0010
 |  |  |  |  | 0011
 |  |  |  |  | 0013
Raw Data is Above
Spreadsheet: 673518d1587419271-discerning-between-success-and-fail-in-each-row-where-player-has-multiple-scores-test-file
Sheet: Sheet1

War ID | War Battle | Battle ID | Home Alliance | [NAME] | Player SC Att | Player Att # | Player sc Def | Player Def # | Original Result | Adjusted Result** | exp TD # | exp [NAME] type (a#-td#) | exp att result
1 | 1 | 1 |  |  |  |  | but |  | 50 |  | 1 | One-Shot | success
1 | 2 | 2 |  |  |  |  | but |  | 22 |  | 2 | One-Shot | fail
1 | 3 | 3 |  |  |  |  | but |  | 29 |  | 2 | 1st CU | success
1 | 4 | 4 |  |  |  |  | ice |  | 50 |  | 1 | One-Shot | success
1 | 5 | 5 |  |  |  |  | but |  | 3 |  | 3 | One-Shot | fail
1 | 6 | 6 |  |  |  |  | but |  | 6 |  | 3 | 1st CU | fail
1 | 7 | 7 |  |  |  |  | but |  | 9 |  | 3 | 2nd CU | fail
1 | 8 | 8 |  |  |  |  | but |  | 32 |  | 3 | 3rd CU | success
2 | 1 | 16 |  |  |  |  | but |  | 20 |  | 1 | One-Shot | fail
2 | 2 | 17 |  |  |  |  | but |  | 10 |  | 1 | 1st CU | fail
2 | 3 | 18 |  |  |  |  | but |  | 21 |  | 1 | 2nd CU | success
2 | 4 | 19 |  |  |  |  | but |  | 50 |  | 2 | One-Shot | success
2 | 5 | 20 |  |  |  |  | ice |  | 20 |  | 1 | One-Shot | fail
2 | 6 | 21 |  |  |  |  | ice |  | 31 |  | 1 | 1st CU | success
2 | 7 | 22 |  |  |  |  | ice |  | 5 |  | 2 | One-Shot | fail
2 | 8 | 23 |  |  |  |  | ice |  | 46 |  | 2 | 1st CU | success
2 | 9 | 24 |  |  |  |  | but |  | 50 |  | 3 | One-Shot | success
2 | 10 | 25 |  |  |  |  | ice |  | 50 |  | 3 | One-Shot | success
2 | 11 | 26 |  |  |  |  | but |  | 2 |  | 4 | One-Shot | fail
2 | 12 | 27 |  |  |  |  | but |  | 2 |  | 4 | 1st CU | fail
2 | 13 | 28 |  |  |  |  | but |  | 6 |  | 4 | 2nd CU | fail
2 | 14 | 29 |  |  |  |  | but |  | 2 |  | 4 | 3rd CU | fail
2 | 15 | 30 |  |  |  |  | but |  | 40 |  | 4 | 4th CU | success
Spreadsheet: 96601d1295972269-combining-data-data
Sheet: Sheet2

Name | App1 | App2 | App3 | App4 | Acct1 | Acct2 | Acct3 | Acct4 | OFFICER | Class1 | Class2 | Class3 | Class4 | Maturity1 | Maturity2 | Maturity3 | Maturity4 | Orig Ln1 | Orig Ln2 | Orig Ln3 | Orig Ln4 | Bk Owned1 | Bk Owned2 | Bk Owned3 | Bk Owned4 | Avail1 | Avail2 | Avail3 | Avail4 | Rating1 | Coll1 | Coll2 | Coll3 | [NAME] | [NAME] | NC
ABC Co. | 15 | 15 | 15 | 15 | xxx1 | xxx2 | xxx3 | xxx4 | AALBART | 1E | 1E | 1A | 1E | 05/20/13 | 05/20/13 | 02/01/13 | 02/01/13 | 50 | 51 | 52 | 53 | 30 | 29 | 28 | 27 | 0 | 0 | 0 | 0 | 05 | 59 | 59 | 65 | 59 | 3310 | Metal Manufacturing    (Iron & Steel Mills, Aluminum Production, etc)
Spreadsheet: 268667d1380729889-how-to-dynamically-synchronize-data-between-two-sheets-projects
Sheet: Project Table

KICK OFF MEETING
DBE
FIRST ROUND CONTENT DUE
LOGO DESIGN DUE
LOGO REVISION 1 DUE FROM CLIENT
LOGO REVISION 1 DUE TO CLIENT
LOGO REVISION 2 DUE FROM CLIENT
LOGO REVISION 2 DUE TO CLIENT
LOGO SIGN OFF
HP DESIGN DUE
SECOND ROUND CONTENT DUE
HP REVISIONS 1 DUE FROM CLIENT
HP REVISIONS 1 DUE TO CLIENT
HP REVISIONS 2 DUE FROM CLIENT
HP REVISIONS 2 DUE TO CLIENT
HP SIGN OFF
INNER PAGE DESIGN DUE
DESIGN PHASE INVOICE SENT
INNER PAGE REVISIONS 1 DUE FROM CLIENT
INNER PAGE REVISIONS 1 DUE TO CLIENT
INNER PAGE REVISIONS 2 DUE FROM CLIENT
INNER PAGE REVISIONS 2 DUE TO CLIENT
INNER PAGE SIGN OFF
ENTER DEV
INTERNAL DEV REVIEW
CLIENT DEV REVIEW
DEVELOPMENT PHASE INVOICE SENT
DEV REVISIONS DUE FROM CLIENT
DEV REVISIONS DUE TO CLIENT
DEV SIGN OFF
Final Payment
GO LIVE!