tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 887533d1737754000-generating-1-column-of-data-into-a-calendar-reviews-calendar-test2
Sheet: Family Calendar

 | Treatment Plan Reviews |  |  | 2025
 | Important Dates
 | Next Review Date | Client Name | Event Type
 | 2025-01-29 00:00:00 | Spiderman |  | G |  | Set the First Day of the Week
 | 2025-02-05 00:00:00 | Iron Man |  | H
 | 2025-02-05 00:00:00 | Black Widow |  | G
 | 2025-02-26 00:00:00 | Captain America |  | G |  | Sunday
 | 2025-01-28 00:00:00 | Hawkeye |  | I
 | 2025-01-29 00:00:00 | Hulk |  | G
 | 2025-02-12 00:00:00 | Antman |  | G |  | Name up to 5 event categories
 | 2025-01-28 00:00:00 | Red Guardian |  | I
 | 2025-02-12 00:00:00 | [NAME] |  | G
 | 2025-02-26 00:00:00 | Storm |  | G |  |  | Past Events
 | 2025-03-12 00:00:00 | Deadpool |  | H |  |  | State Holiday
 | 2025-01-28 00:00:00 | Wolverine |  | G |  |  | Other Major Events
 |  |  |  |  |  |  | G
 |  |  |  |  |  |  | H
 |  |  |  |  |  |  | I
 | 2025-01-01 00:00:00 | New Year's Day |  | State Holiday
 | 2025-01-20 00:00:00 | MLK jr Day |  | State Holiday
 | 2025-02-17 00:00:00 | Presidents Day |  | State Holiday
 | 2025-02-12 00:00:00 | Lincoln Day |  | State Holiday
 | 2025-05-08 00:00:00 | Truman Day |  | State Holiday
 | 2025-05-26 00:00:00 | Memorial Day |  | State Holiday
 | 2025-06-19 00:00:00 | Juneteenth |  | State Holiday
 | 2025-07-04 00:00:00 | Independence Day |  | State Holiday
 | 2025-10-13 00:00:00 | [NAME] |  | State Holiday
 | 2025-11-11 00:00:00 | Veteran's Day |  | State Holiday
 | 2025-11-27 00:00:00 | Thanksgiving |  | State Holiday
 | 2025-12-25 00:00:00 | Christmas |  | State Holiday
Spreadsheet: 217408d1362062806-calculate-multiple-cells-sums-based-upon-another-cell-purchase
Sheet: L10-0009-000

L10-0009-000
Part # | Description | QTY | [NAME]
30020-01 | ANODE MAG ALLOY 1-5/16X24+1-1/4 NPT | 2
30046-07 | BLANK CEMCO THREADED 4 X 2 | 1
30060-01 | BUSHING PIPE FS 3M 3 X 1 | 1
30126-01 | [NAME] | 1
30127-06 | [NAME] | 1
30127-07 | [NAME] WLLMRK ST4UP | 2
30210-04 | FLG THD ANSI 600 RF 3 | 1
30331-01 | GAUGE 1000 PSI DRY 2-1/2X1/4 BM | 2
30334-01 | GAUGE 200 PSI DRY 2-1/2X1/4 BM | 2
30338-01 | GAUGE 30 PSI DRY 2-1/2X1/4 BM | 5
30361-05 | GSKT FLG SPRWND 3 ANSI 3-600 | 1
30405-02 | PSSR PILOT HI 1000# 4660-XG | 1
30541-09 | PLUG PIPE FS 3M HH 3 | 2
30565-02 | REG 1PR-3P25S 35-80 1/4ORI 1 | 1
30570-01 | REG WATTS R125-04A 0-25 1/2 | 1
30624-02 | SIGHT GLASS 2 | 1
30638-05 | STUD BLK B7 +2 2H NUTS 3/4 X 5 | 8
30731-09 | TEE PIPE FS 2M SE 3 | 3
30745-01 | THERMOMETER 3X1/2 NPT X 6L 0250 | 2
30747-02 | THERMOSTAT KMRY T12 HAA | 2
30749-01 | THERMOWELL KMRY 4M 1 X 12 HCC | 2
30749-03 | THERMOWELL KMRY 4M 1 X 6 HCB | 3
30785-03 | VLV MTR KMRY 112 SMT DAB EMB3 | 1
30787-09 | VLV MTR [NAME] 2200 SMA PO ECM | 2
30787-11 | VLV MTR KMRY 2400 SMA PO ECU | 1
30788-03 | VLV MTR [NAME] 2200 SMT PO ECP | 1
30790-17 | VLV PR 1 X 1 740 MERCER E | 1
30230-02 | VLV PR 2X2 MNPT X FNPT 125 TAYLOR G | 1
30795-01 | VLV QUICK EXHAUST 544 SILVER PLTD | 4
30823-01 | VLV BALL BALON 1F-F92-SE 2000 | 1
30827-01 | VLV BALL BALON 2R-F92-SE 2000 | 1
30829-01 | VLV BALL BALON 2R-S32-UNI 750 | 1
30829-02 | VLV BALL BALON 2R-S42 SE 1000 | 3
30829-05 | VLV BALL BALON 2F-S42-SE 1000 | 1
30832-03 | VLV BALL BALON 3F-S32-SE 750 | 1
30885-01 | VLV MTR KMRY 2300 SD3W ESI | 1
30893-01 | VLV BCK PSSR KMRY AAATF6 212SGT | 1
Spreadsheet: 32a678d4-3854-449e-945d-56d46b7c2c15
Sheet: Segment Results 

Lockheed [NAME]
Business Segment Summary Operating Results
(unaudited; in millions)
 |  | Quarters Ended
 |  | March 31, 2013 |  | March 25, 2012 |  |  | % Change
Net sales
Aeronautics |  | 3186 |  | 3706 |  |  | -14 | %
Information Systems & Global Solutions |  | 2106 |  | 2090 |  |  | 1 | %
Missiles and Fire Control |  | 1988 |  | 1766 |  |  | 13 | %
Mission Systems and Training |  | 1830 |  | 1838 |  |  | 0 | %
Space Systems |  | 1960 |  | 1893 |  |  | 4 | %
Total net sales |  | 11070 |  | 11293 |  |  | -2 | %
Operating profit
Aeronautics |  | 379 |  | 385 |  |  | -2 | %
Information Systems & Global Solutions |  | 189 |  | 188 |  |  | 1 | %
Missiles and Fire Control |  | 344 |  | 371 |  |  | -7 | %
Mission Systems and Training |  | 201 |  | 157 |  |  | 28 | %
Space Systems |  | 230 |  | 239 |  |  | -4 | %
Total business segment operating profit |  | 1343 |  | 1340 |  |  | 0 | %
Unallocated expenses, net
Non-cash FAS/CAS pension adjustment
FAS pension expense |  | -487 |  | -485
Less:  CAS expense |  | 366 |  | 278
Non-cash FAS/CAS pension adjustment |  | -121 |  | -207 |  | -622
Special item - severance charges1 |  | -30 |  | 0
Stock-based compensation |  | -53 |  | -41 |  | -129
Other, net |  | -20 |  | -48 |  | -160
Total unallocated expenses, net |  | -224 |  | -296 |  |  | -24 | %
Total consolidated operating profit |  | 1119 |  | 1044 |  |  | 7 | %
Operating margins
Aeronautics |  |  | % |  | %
Information Systems & Global Solutions |  |  | % |  | %
Missiles and Fire Control |  |  | % |  | %
Mission Systems and Training |  |  | % |  | %
Space Systems |  |  | % |  | %
Total business segment operating margins |  |  | % |  | %
Total consolidated operating margins |  |  | % |  | %
1 Severance charges for the first quarter of 2013 consist of amounts associated with the planned
elimination of certain positions at the Corporation's Information Systems & Global Solutions business
segment.  Severance charges for initiatives that are not significant are included in business segment
operating profit.
Spreadsheet: 844188d1695937951-display-unique-values-with-a-count-for-a-date-range-unique-values-test-01
Sheet: Sheet1

NAME | DATE |  | UNIQUE FOR (COLUMN A) FOR THE LAST 30 DAYS (COLUMN B) AND A COUNT OF THE TOTAL UNIQUE DISPLAYED AND SORTED HIGH TO LOW
JOE | 2023-08-01 00:00:00 |  | JOE | 3
JOE | 2023-09-02 00:00:00 |  | SUE | 2
SUE | 2023-09-04 00:00:00 |  | MARK | 1
MARK | 2023-09-06 00:00:00 |  | LISA | 1
LISA | 2023-09-15 00:00:00
SUE | 2023-09-16 00:00:00
JOE | 2023-09-18 00:00:00
JOE | 2023-09-20 00:00:00
Spreadsheet: 78920d1279200752-hiding-column-hiding-comments
Sheet: Sheet1

Column a | Column b | Column c | Comments | Hide |  |  |  |  | Select an option
[NAME] | [NAME] | [NAME] |  |  |  |  |  |  | Hide
[NAME] | [NAME] | [NAME] |  |  |  |  |  |  | Unhide
[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
Spreadsheet: 766373d1643876592-enter-two-values-and-find-the-third-one-part2-findfl-values-filled-in-and-hidden-aligw
Sheet: Clacul FL

 | step1 |  |  |  |  |  |  | Tab2 | ISA
1 | FL | Temp | ISA |  |  |  |  | WT | -10 | -5 | 0 | 5 | 10 | 15 | 20
 | 250 | -44 |  |  |  |  |  | 13 | 240 | 240 | 240 | 240 | 240 | 220 | 240
 |  |  |  |  |  |  |  | 14 | 240 | 240 | 240 | 240 | 240 | 220 | 240
 |  |  |  |  |  |  |  | 15 | 240 | 240 | 240 | 240 | 240 | 220 | 240
2 | WT | ISA | FL |  |  |  |  | 16 | 240 | 240 | 240 | 240 | 240 | 220 | 220
 | 17.1 |  |  |  |  |  |  | 17 | 240 | 240 | 240 | 240 | 220 | 220 | 200
 |  |  |  |  |  |  |  | 18 | 240 | 240 | 220 | 220 | 200 | 200 | 180
 |  |  |  |  |  |  |  | 19 | 240 | 220 | 220 | 200 | 200 | 180 | 180
 |  |  |  |  |  |  |  | 20 | 220 | 220 | 200 | 200 | 180 | 180 | 160
 | [NAME] |  |  |  |  |  |  | 21 | 200 | 200 | 200 | 180 | 180 | 160 | 140
1 | FL | Temp | ISA |  |  |  |  | 21.5 | 200 | 200 | 180 | 180 | 160 | 140 | 120
 | 200 | -15 |  |  |  |  |  | 22 | 200 | 180 | 180 | 180 | 160 | 140 | 120
 |  |  |  |  |  |  |  | 22.5 | 200 | 180 | 180 | 160 | 160 | 140 | 120
 |  |  |  |  |  |  |  | 23 | 180 | 180 | 160 | 160 | 140 | 120 | 100
 | WT | ISA | FL
2 | 22 |  |  |  |  |  |  | Tab1 | ISA
 |  |  |  |  |  |  |  | FL | -10 | -5 | 0 | 5 | 10 | 15 | 20
 |  |  |  |  |  |  |  | 100 | -15 | -10 | -5 | 0 | 5 | 10 | 15
step1 |  |  |  |  |  |  |  | 110 | -17 | -12 | -7 | -2 | 3 | 8 | 13
for example: |  |  |  |  |  |  |  | 120 | -19 | -14 | -9 | -4 | 1 | 6 | 11
user add: FL250, temp -44 |  |  |  |  |  |  |  | 130 | -21 | -16 | -11 | -6 | -1 | 4 | 9
result ISA | -10 | (perfect!) |  |  |  |  |  | 140 | -23 | -18 | -13 | -8 | -3 | 2 | 7
user add: Wt 17.1 |  |  |  |  |  |  |  | 150 | -25 | -20 | -15 | -10 | -5 | 0 | 5
result FL | 0 | (not good!) |  |  |  |  |  | 160 | -27 | -22 | -17 | -12 | -7 | -2 | 3
 |  |  |  |  |  |  |  | 170 | -29 | -24 | -19 | -14 | -9 | -4 | 1
 |  |  |  |  |  |  |  | 180 | -31 | -26 | -21 | -16 | -11 | -6 | -1
Is possible to give me the result 240? |  |  |  |  |  |  |  | 190 | -33 | -28 | -23 | -18 | -13 | -8 | -3
I mean the result to be the first value from -10 column but out of red zone, i.e 240 |  |  |  |  |  |  |  | 200 | -35 | -30 | -25 | -20 | -15 | -10 | -5
 |  |  |  |  |  |  |  | 210 | -37 | -32 | -27 | -22 | -17 | -12 | -7
 |  |  |  |  |  |  |  | 220 | -39 | -34 | -29 | -24 | -19 | -14 | -9
 |  |  |  |  |  |  |  | 230 | -41 | -36 | -31 | -26 | -21 | -16 | -11
 |  |  |  |  |  |  |  | 240 | -43 | -38 | -33 | -28 | -23 | -18 | -13
 |  |  |  |  |  |  |  | 250 | -45 | -40 | -35 | -30 | -25 | -20 | -15
Spreadsheet: 12afdd7c-a79c-4249-95a3-cd5064c25d10
Sheet: Sheet1

ROASTER FOR THE PERIOD OF FEBRUARY TO MARCH
NAME/DATE | MON27 | TUES28 | WED29 | THURS01 | FRI02 | [NAME] | SUN04
ALVIN | P.M | A.M | OFF | OFF | P.M | P.M | P.M
SHAHIL | OFF | P.M | P.M | P.M | A.M | OFF | OFF
ANUSHKA | A.M | OFF | A.M | A.M | OFF | A.M | A.M
TINA | A.M | OFF | A.M | A.M | OFF | A.M | A.M
NAME/DATE | MON05 | TUES06 | WED07 | THURS08 | FRI09 | SAT10 | SUN11
ALVIN | P.M | P.M | OFF | A.M | P.M | OFF | OFF
SHAHIL | A.M | OFF | P.M | P.M | OFF | P.M | P.M
ANUSHKA | OFF | A.M | A.M | OFF | A.M | A.M | A.M
TINA | OFF | A.M | A.M | OFF | A.M | A.M | A.M
NAME/DATE | MON12 | TUES13 | WED14 | THURS15 | FRI16 | SAT17 | SUN18
ALVIN | OFF | A.M | P.M | P.M | OFF | A.M | P.M
SHAHIL | P.M | P.M | OFF | OFF | P.M | P.M | A.M
TINA | A.M | OFF | A.M | A.M | A.M | OFF | OFF
ANUSHKA | A.M | OFF | A.M | A.M | A.M | OFF | OFF
NAME/DATE | MON19 | TUES20 | WED21 | THURS22 | FRI23 | [NAME] | SUN25
ALVIN | P.M | P.M | P.M | A.M | OFF | OFF | OFF
SHAHIL | OFF | A.M | OFF | P.M | P.M | P.M | P.M
ANUSHKA | A.M | OFF | A.M | OFF | A.M | A.M | A.M
TINA | A.M | OFF | A.M | OFF | A.M | A.M | A.M
Spreadsheet: 803826d1667727107-formula-to-calculate-transit-times-example
Sheet: Sheet1

Day of Collection | Next Departure | No of Days to [NAME] (min) | Correct answer
1 | 2 |  | 1
2 | 3 |  | 1
3 | 4 |  | 1
4 | 5 |  | 1
5 | 1 |  | 1
1 | 2 |  | 1
2 | 3 |  | 1
3 | 4 |  | 1
4 | 5 |  | 1
5 | 1 |  | 1
5 | 5 |  | 5
4 | 4 |  | 5
3 | 3 |  | 5
2 | 2 |  | 5
1 | 1 |  | 5
Spreadsheet: 06f2f18c-aaa5-4d8e-ba8a-6ca1ff77a788
Sheet: Sheet1

a | 28200 | (to river) (ft)
b | 19000 | (no flow) (ft)
S | 0.1
T | 2000 | ft^2/day
4T/S
 |  | Pumping | 2-ps | 3-1s | 6-4s | 7-5s | 9-8s |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pumping | 2-ps | 3-1s | 6-4s | 7-5s | 9-8s
a mult |  | 1 | 1 | 3 | 3 | 5 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 3 | 3 | 5 | 5
b mult |  | 0 | 2 | 2 | 4 | 4 | 6 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 2 | 2 | 4 | 4 | 6 | 6
 |  | 1 | 1
t (days) | River_a | 1 |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 7
10
Spreadsheet: 726044d1617026916-pulling-data-at-the-end-of-a-business-day-sample
Sheet: TalentDashboard

 |  | Talent [NAME]
 |  |  |  |  |  |  | Select Position Type to Update Data Below: |  | 1 | 2
 |  |  | Applications & Hiring |  |  | Applicants | Current Staff |  |  | Applicants | Current Staff
 |  | Total  Applicants |  | Unique Applicants |  | Age
 |  | Total Positions |  | Avg Days To Fill |  | Gender
 |  |  | Retention |  |  | Experience
Spreadsheet: 51281d1250807634-data-validation-list-sort-problem-tempodjustments3
Sheet: Value Trends Tempo

Value Trends
 | 7815 corbin | Winnetka, CA 91306
Comps Past 12 Months | REO Comps past year | % REO | Average SP | Average sales per month | [NAME]
0 | 0 | #N/A | #N/A | 0 | #N/A
Comps Past 6 Months | REO Comps past 6 months | % REO |  | Average sales per month
0 | 0 | #N/A | #N/A | 0 | #N/A
Comps Past 3 Months | REO Comps past 3 months | %REO |  | Average sales per month
0 | 0 | #N/A | #N/A | 0 | #N/A
Current Active | REO Active | %REO |  | List Price Low | 0
0 | 0 | #N/A
 |  |  |  | List Price High | 0
Months supply of properties based on 6 month average
#N/A |  |  |  | Sale Price Low | 0
Months supply based on standard national average of 4.5 |  |  |  | Sale Price High | 0
0
Price trends | based on Ave Sale Price |  | per month
90 Day to 1 Year |  | #N/A | #N/A
90 Day to Six Months |  | #N/A | #N/A
Spreadsheet: 34374d1231567782-trouble-w-autofilter-excel-2003-protected-wks-clent-due-dates-1-9-2210
Sheet: Sheet1

 | CLIENT REVIEW DATES
 | Client Last Name, First MI | SFPR | Admit | Cycle | 60 Days | 6 month | Annual
 | Jones, [NAME] | [NAME], [NAME] | 2008-11-08 00:00:00 |  | 2009-01-07 00:00:00 | 2009-05-01 00:00:00 | 2009-11-01 00:00:00
 | Porter, [NAME] | Simpson, [NAME] | 2008-04-19 00:00:00 |  | 2008-06-18 00:00:00 | 2008-10-01 00:00:00 | 2009-04-01 00:00:00
 | [NAME], [NAME] | [NAME], [NAME] | 2008-01-11 00:00:00 |  | 2008-03-11 00:00:00 | 2008-07-01 00:00:00 | 2009-01-01 00:00:00
 | [NAME], [NAME] | Maxwell, [NAME] | 2007-05-16 00:00:00 |  | 2007-07-15 00:00:00 | 2007-11-01 00:00:00 | 2008-05-01 00:00:00
Spreadsheet: 135752d1326218302-subtracting-from-multiple-cells-percentage-full
Sheet: Sheet1

500 |  |  |  | 0.3196955280685062 |  | 0.3866513233601841 |  | 1051 | 336 | 182 | 1
Total | [NAME] | Total Gone | [NAME] | Total Gone |  | Excluding AddOns
79 | 29 | 15 | 0 | 0.189873417721519 |  | 0.3
72 | 22 | 14 | 0 | 0.1944444444444444 |  | 0.28
66 | 16 | 14 | 0 | 0.2121212121212121 |  | 0.28
80 | 30 | 17 | 0 | 0.2125 |  | 0.34
50 | 0 | 14 | 0 | 0.28 |  | 0.28
55 | 10 | 16 | 0 | 0.2909090909090909 |  | 0.3555555555555556
48 | 0 | 14 | 0 | 0.2916666666666667 |  | 0.2916666666666667
50 | 0 | 16 | 0 | 0.32 |  | 0.32
50 | 6 | 16 | 1 | 0.32 |  | 0.3636363636363636
79 | 29 | 26 | 0 | 0.3291139240506329 |  | 0.52
50 | 0 | 17 | 0 | 0.34 |  | 0.34
44 | 0 | 15 | 0 | 0.3409090909090909 |  | 0.3409090909090909
60 | 10 | 23 | 0 | 0.3833333333333334 |  | 0.46
47 | 0 | 20 | 0 | 0.425531914893617 |  | 0.425531914893617
69 | 20 | 30 | 0 | 0.4347826086956522 |  | 0.6122448979591837
49 | 0 | 22 | 0 | 0.4489795918367347 |  | 0.4489795918367347
44 | 0 | 20 | 0 | 0.4545454545454545 |  | 0.4545454545454545
59 | 10 | 27 | 0 | 0.4576271186440678 |  | 0.5510204081632653
Spreadsheet: 686314d1594493176-matching-addresses-to-phone-numbers-real-estate-address-1
Sheet: Second 

 | Address | City | State | Zip | Phone Number 1 | First Name | Last Name | Phone Number 2 | First Name | Last Name | Phone Number 3 | First Name | Last Name
 | 1210 Lake Kennedy Dr | Suffolk | VA | 23434 | 7575390705 | Gloria | Colbert
 | 400 [NAME] | Suffolk | VA | 23434 | 7575390073 | Echoe | Edmond
 | 823 Seminole Dr | Suffolk | VA | 23434 | 8045392944 |  | GRAHAM SALLIE R EST
 | 2701 E Washington St | Suffolk | VA | 23434 | 7577457021 | ANNA | SMITH
 | 2849 E Washington St | Suffolk | VA | 23434 | 7577616402 | [NAME] | Butler
 | 3408 Holland Rd | Suffolk | VA | 23434 | 7574833327 | LEOTIS | [NAME]
 | 2313 Manning Rd | Suffolk | VA | 23434 | 7575397274 | [NAME] | Manley
 | 3917 Holland Rd | Suffolk | VA | 23434 | 7576579927 | [NAME] | Eller
 | 1462 Whaleyville Blvd | Suffolk | VA | 23434 | 7578091221 | R Linwood | [NAME]
 | 1462 Whaleyville Blvd | Suffolk | VA | 23434 | 7578091221 | R Linwood | [NAME]
Spreadsheet: 114381d1310130644-pivot-table-calculation-book2
Sheet: Pivot

Count of What is your favorite color?
What is your favorite color? | Total |  | Percent
Blue | 5 |  | 0.2272727272727273
Green | 6 |  | 0.2727272727272727
Orange | 2 |  | 0.09090909090909091
Red | 1 |  | 0.04545454545454546
Yellow | 8 |  | 0.3636363636363636
Grand Total | 22 |  | 1
Spreadsheet: 202476d1356599658-how-do-i-create-an-automatic-list-in-an-excel-sheet-with-filtered-data-from-another-sheet-sample-excel
Sheet: GUEST LIST NAMES

 | INDUCTION GUEST LIST TRACK SHEET
 |  |  |  |  |  | TRACKING:
 |  |  |  |  |  | Confirmed | C
 |  |  |  |  |  | Declined | D
 |  |  |  |  |  | Pending | I
 |  |  |  |  |  | Not yet invited | N
 |  |  |  |  |  | Total Required Attendees
 | Date Hired |  | Status ('I'/ 'C'/ 'D') | Prefix ("Mr." / "Ms.") | Surname | First Name | Nickname | Position | Division | Assignment
1 | 2011-01-31 00:00:00 |  | C | Mr. | Almazan | [NAME] | Boj | Distributor Operations Executive | Grocery Sales | MAO
2 | 2011-07-01 00:00:00 |  | C | Ms. | [NAME] | Amelia | [NAME] | Financial Accounting Services Head | Finance and Control | MAO
3 | 2011-09-12 00:00:00 |  | I | Ms. | Serquina | [NAME] |  | Nutrition Specialist | [NAME] | MAO
4 | 2011-09-19 00:00:00 |  | D | Ms. | [NAME] | May |  | Nutrition Specialist | [NAME] | MAO
8 | 2011-10-10 00:00:00 |  | I | Mr. | Cena | [NAME] |  | Nutrition Specialist | [NAME] | MAO
6 | 2011-10-10 00:00:00 |  | C | Mr. | Magat | [NAME] | Ian | Area Nutrition Manager | [NAME] | MAO
5 | 2011-10-10 00:00:00 |  | D | Ms. | Alilio | Marienel |  | Nutrition Specialist | [NAME] | MAO
9 | 2011-10-10 00:00:00 |  | C | Ms. | Cruz | [NAME] |  | Nutrition Specialist | [NAME] | MAO
10 | 2011-10-10 00:00:00 |  | I | Ms. | [NAME] | Fate |  | Nutrition Specialist | [NAME] | MAO
7 | 2011-10-10 00:00:00 |  | I | Ms. | [NAME] | Ma. [NAME] |  | Nutrition Specialist | [NAME] | MAO
11 | 2011-10-17 00:00:00 |  | C | Mr. | Panaligan | Ronel | Une | Process Line Operator | Technical | TF
12 | 2011-10-24 00:00:00 |  | C | Mr. | Raymundo | [NAME] |  | Nutrition Specialist | [NAME] | MAO
13 | 2011-12-08 00:00:00 |  | D | Ms. | [NAME] | Glemhier |  | Nutrition Specialist | [NAME] | MAO
14 | 2011-12-12 00:00:00 |  | C | Ms. | Jacinto | Krista Mae |  | Nutrition Specialist | [NAME] | MAO
57 |  |  | C | Ms. | [NAME] | [NAME] |  | Administration Specialist | Technical | MAO
Spreadsheet: 468581d1467370299-first-and-second-value-in-row-range-first-and-second-value-in-row-range
Sheet: Sheet1

 |  | Week Ending | Week Ending | Week Ending | Week Ending | Week Ending | Week Ending | Week Ending | Week Ending | Total January 16 | Total January 16 | Week Ending | Week Ending | Week Ending | Week Ending | Week Ending | Week Ending | Week Ending | Week Ending | Total February 16 | Total February 16 | Week Ending | Week Ending | Week Ending | Week Ending | Week Ending | Week Ending | Week Ending | Week Ending | Week Ending | Week Ending | Total March 16 | Total March 16 | Total Q1 2016 | Total Q1 2016
 | Actual Cash Flow Statement | 2016-01-08 00:00:00 | 2016-01-08 00:00:00 | 2016-01-15 00:00:00 | 2016-01-15 00:00:00 | 2016-01-22 00:00:00 | 2016-01-22 00:00:00 | 2016-01-29 00:00:00 | 2016-01-29 00:00:00 |  |  | 2016-02-05 00:00:00 | 2016-02-05 00:00:00 | 2016-02-12 00:00:00 | 2016-02-12 00:00:00 | 2016-02-19 00:00:00 | 2016-02-19 00:00:00 | 2016-02-26 00:00:00 | 2016-02-26 00:00:00 |  |  | 2016-03-04 00:00:00 | 2016-03-04 00:00:00 | 2016-03-11 00:00:00 | 2016-03-11 00:00:00 | 2016-03-18 00:00:00 | 2016-03-18 00:00:00 | 2016-03-25 00:00:00 | 2016-03-25 00:00:00 | 2016-04-01 00:00:00 | 2016-04-01 00:00:00
 |  | Bank 01 | Bank 02 | Bank 01 | Bank 02 | Bank 01 | Bank 02 | Bank 01 | Bank 02 | Bank 01 | Bank 02 | Bank 01 | Bank 02 | Bank 01 | Bank 02 | Bank 01 | Bank 02 | Bank 01 | Bank 02 | Bank 01 | Bank 02 | Bank 01 | Bank 02 | Bank 01 | Bank 02 | Bank 01 | Bank 02 | Bank 01 | Bank 02 | Bank 01 | Bank 02 | Bank 01 | Bank 02 | Bank 01 | Bank 02
 | Actual Cash Inflow
 | Opening Balance
 | Total Cash Inflow
Spreadsheet: 778871d1651408424-formula-to-include-public-holidays-calendar
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Public Holidays | Pub Holiday Description
 |  | 2022-05-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2022-01-01 00:00:00 | 2022-01-01 00:00:00 | New Year's Day
 |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday |  |  |  |  |  |  | 2022-03-21 00:00:00 | Human Rights Day
 |  |  | 2022-04-26 00:00:00 | 2022-04-27 00:00:00 | 2022-04-28 00:00:00 | 2022-04-29 00:00:00 | 2022-04-30 00:00:00 | 2022-05-01 00:00:00 |  |  |  |  |  |  | 2022-04-15 00:00:00 | Good Friday
 |  | 2022-05-02 00:00:00 | 2022-05-03 00:00:00 | 2022-05-04 00:00:00 | 2022-05-05 00:00:00 | 2022-05-06 00:00:00 | 2022-05-07 00:00:00 | 2022-05-08 00:00:00 |  |  |  |  |  |  | 2022-04-17 00:00:00 | Easter Sunday
 |  | 2022-05-09 00:00:00 | 2022-05-10 00:00:00 | 2022-05-11 00:00:00 | 2022-05-12 00:00:00 | 2022-05-13 00:00:00 | 2022-05-14 00:00:00 | 2022-05-15 00:00:00 |  |  |  |  |  |  | 2022-04-18 00:00:00 | Family Day
 |  | 2022-05-16 00:00:00 | 2022-05-17 00:00:00 | 2022-05-18 00:00:00 | 2022-05-19 00:00:00 | 2022-05-20 00:00:00 | 2022-05-21 00:00:00 | 2022-05-22 00:00:00 |  |  |  |  |  |  | 2022-04-27 00:00:00 | Freedom Day
 |  | 2022-05-23 00:00:00 | 2022-05-24 00:00:00 | 2022-05-25 00:00:00 | 2022-05-26 00:00:00 | 2022-05-27 00:00:00 | 2022-05-28 00:00:00 | 2022-05-29 00:00:00 |  |  |  |  |  |  | 2022-05-02 00:00:00 | Workers' Day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-06-16 00:00:00 | Youth Day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-07-18 00:00:00 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-08-09 00:00:00 | National Women's Day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-09-24 00:00:00 | Heritage Day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-12-16 00:00:00 | Day of Reconciliation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-12-25 00:00:00 | Christmas Day
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-12-26 00:00:00 | Day of Goodwill