tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 89554d1289337910-dependent-percentile-formula-in-table-with-nested-lookup-or-index-match-benchmark-help2
Sheet: Inputs

 |  |  |  | REQUIRED INPUTS: | enter values below |  | LEGENED:
 | Note: To protect formulas, only the those cells with a red border may be edited. |  |  | OneVoice Industry (select from list) |  |  | "Industry Leader" (4th Quartile) | Top 25%
 |  |  |  | SIC Segment (select from list) | (forthcoming)
 |  |  |  | Current Year Revenue (in Millions) | 986.21 |  | "Above Average" (Above Median) | Top 50%
 |  |  |  | Last Year Revenue (in Millions) | 825.45
 |  |  |  | Employees (Total) | 1121 |  | "Industry Laggard" (Below Median) | Bottom 50%
 |  |  |  | Cost of Goods Sold (in Millions) | 725
 |  |  |  | Total SGA Expense (in Millions) | 154.21
 |  |  |  | DSO (in days) | 31
 |  |  |  | DII (in days) | 13
 |  |  |  | DPO (in days) | -16
 |  |  |  | Return on Invested Capital (%) | 0.0612
 |  | RESULTS and RANKINGS
 |  | No. | Benchmark | Format | 4th Quartile | Average | 1st Quartile | Your Business Today | Your Ranking | ?Potential Value of Improvement?
 |  | 1 | Revenue per Employee | In Thousands of $
 |  | 2 | Revenue Growth | Percentage of Year/Year growth
 |  | 3 | Cost of Goods Sold | As a % of Revenue
 |  | 4 | Selling, General, and [NAME] (SG&A) | As a % of Revenue
 |  | 5 | Days Sales Outstanding (DSO) | No. of days
 |  | 6 | Days in Inventory (DII) | No. of days
 |  | 7 | Days Payable Outstanding (DPO) | No. of days
 |  | 8 | Operating Profit | As a % of Revenue
 |  | 9 | Return on Capital (ROIC) | As a % of Return
 |  | 10 | Operational Profit per Employee | In Thousands of $
Spreadsheet: 73578d1274216174-auto-populating-columns-in-one-sheet-from-another-based-on-criteria-daily-sched-automation-test
Sheet: Daily Format Trial

 | 2010-05-22 00:00:00
 | Sunrise | Sunset | Moonrise | Moonset | Illum. |  |  |  |  |  |  |  | OPS
 |  |  |  |  |  |  |  |  |  |  |  |  | XO
 |  |  |  |  |  |  |  |  |  |  |  |  | LT Jones
 | OPS Calls | OPS |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Oncoming Duty: |  |  |  |  |  | Offgoing Duty:
 | SDO: |  | ODO: |  |  |  | SDO:
 |  |  |  |  |  |  | ODO:
 | Med: | LV: | TAD: | Slide:
Spreadsheet: 168789d1342581526-extending-formulas-containing-worksheets-phat-routine
Sheet: Week 1

 | Weight | Exercise | Weight (KG) | Reps | Weight (KG) | Reps | Weight (KG) | Reps | Weight (KG) | Reps | Weight (KG) | Reps | Weight (KG) | Reps
Monday | 67 | [NAME] | 87.5 | 3 |  | 3 |  | 3
 |  | Weighted Dips |  | 6 |  | 6
 |  | Weighted Pull Up |  | 6 |  | 6
 |  | Rack Pull |  | 6 |  | 6
 |  | BB Row |  | 3 |  | 3 |  | 3
 |  | DB Press |  | 6 |  | 6 |  | 6
 |  | [NAME] |  | 6 |  | 6 |  | 6
 |  | Skullcrusher |  | 6 |  | 6 |  | 6
Tuesday | 67.5 | Squat | 80 | 3 |  | 3 |  | 3
 |  | Deadlift | 110 | 3 |  | 3 |  | 3
 |  | [NAME] |  | 6 |  | 6
 |  | Leg Extension |  | 6 |  | 6
 |  | Glute Ham Raise |  | 6 |  | 6 |  | 6
 |  | Standing Calf |  | 6 |  | 6 |  | 6
 |  | Seated Calf |  | 6 |  | 6
Wednesday | ??? | REST
Thursday | ??? | Bench (65-70%) |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3
 |  | [NAME] |  | 8 |  | 8 |  | 8
 |  | DB Bench |  | 12 |  | 12 |  | 12
 |  | Incline Cable Fly |  | 15 |  | 15
 |  | [NAME] |  | 8 |  | 8 |  | 8
 |  | [NAME] |  | 12 |  | 12
 |  | Machine Curl |  | 15 |  | 15
 |  | Tricep Extension |  | 8 |  | 8 |  | 8
 |  | Tricep Pulldown |  | 12 |  | 12
 |  | Cable Kickback |  | 15 |  | 15
Friday | ??? | Squats (65-70%) |  | 3 |  | 3 |  | 3 |  | 3 |  | 3 |  | 3
 |  | [NAME] |  | 8 |  | 8 |  | 8
 |  | [NAME] |  | 12 |  | 12 |  | 12
 |  | Leg Extension |  | 15 |  | 15 |  | 15
 |  | Stiff Legged |  | 8 |  | 8 |  | 8
 |  | Leg Curl |  | 12 |  | 12 |  | 12
 |  | SM Calf Raise |  | 10 |  | 10 |  | 10 |  | 10
 |  | Seated SM Calf Raise |  | 15 |  | 15 |  | 15
Saturday | ??? | BB Row (65-70%) |  | 3 |  | 3 |  | 3 |  | 3 |  | 3
 |  | [NAME] |  | 8 |  | 8 |  | 8
 |  | Seated Row |  | 8 |  | 8 |  | 8
 |  | Shrugs |  | 12 |  | 12
 |  | CG Pull Down |  | 15 |  | 15
 |  | DB Press |  | 8 |  | 8 |  | 8
 |  | Upright Row |  | 12 |  | 12
 |  | Side Raise |  | 12 |  | 12 |  | 12
Spreadsheet: 199734d1355312465-using-conditional-formatting-from-a-table-to-a-list-on-2-different-sheets-on-excel-2007-exmaple-1
Sheet: Job List

Engineer Name | Site | Postcode | Serial | Service Type | Last service date | Booking Description | week num
Engineer 1 | site 1 | aa1 bb4 | 12345678 | fsbi | 2012-03-06 09:00:00
Engineer 1 | site 3 | aa6 ll2 | 34567890 | mini | 2012-03-09 15:05:00
Engineer 1 | site 4 | at9 pp0 | 45678901 | fsbi | 2012-03-08 11:30:00
Engineer 1 | site 5 | aq4 hh7 | 56789012 | fsbi | 2012-03-08 10:40:00
Engineer 1 | site 6 | au8 eg6 | 67890123 | mini | 2012-03-08 09:00:00
Engineer 1 | site 2 | [NAME] | 23456789 | mini | 2012-03-21 10:20:56
Engineer 2 | site 7 | ba4 mm6 | 78901234 | fsbi | 2012-03-07 11:50:00
Engineer 2 | site 8 | bb9 lr5 | 89012345 | mini | 2012-03-07 11:30:00
Engineer 2 | site 9 | bk9  fs5 | 90123456 | mini | 2012-03-14 17:00:00
Engineer 2 | site 10 | [NAME] | 01234567 | fsbi | 2012-03-16 11:20:00
Engineer 2 | site 11 | bi33 jd7 | 13579024 | mini | 2012-03-16 09:30:00
Engineer 2 | site 13 | bp6 ks9 | 57912468 | mini | 2012-03-15 15:20:00
Engineer 2 | site 12 | bd9 ll0 | 35791246 | fsbi | 2012-03-19 09:50:00
Engineer 3 | site 14 | cv8 kp0 | 78934529 | mini | 2012-03-07 14:25:00
Engineer 3 | site 15 | ce9 le1 | 97027456 | fsbi | 2012-03-05 10:00:00
Engineer 3 | site 17 | co10 eu7 | 57382015 | fsbi | 2012-03-06 10:00:00
Engineer 3 | site 19 | [NAME] nn5 | 57820578 | fsbi | 2012-03-15 12:20:00
Engineer 3 | site 16 | ck7 oo1 | 47230937 | mini | 2012-03-19 09:10:00
Engineer 3 | site 18 | cw9 [NAME] | 47381074 | mini | 2012-03-22 09:45:00
Engineer 4 | site 23 | pl9 vs4 | 91352138 | fsbi | 2012-03-02 09:00:00
Engineer 4 | site 22 | pi2 [NAME] | 65413987 | fsbi | 2012-03-05 09:00:00
Engineer 4 | site 20 | [NAME] | 56489413 | mini | 2012-03-13 11:00:00
Engineer 4 | site 21 | [NAME] | 25486318 | mini | 2012-03-20 10:15:00
My wish list ;-)
the booking description is what is taken into the schedule sheet.  When these have been populated into the schedule sheet, i need to have them highlighted
so I do not rebook them on the following weeks schedules.
Spreadsheet: 715288d1611653489-2-way-percentage-scoring-increased-or-decreased-sample-countifs-file
Sheet: Sheet6

Current | Future | % Score |  | What it should be.
5 | 1 |  |  | Correct
1 | 5
5 | 5 |  |  | Correct
Current [NAME]: =IF(OR(B2="",A2=""),"",(A2-B2)/A2)
1. If the values in Current are higher than Future it should get how much percentage it decreases.
2. If the values in Current are lower than Future it should get how much percentage it increases.
3. If no values on either Current or Future, % Score should be blank. Will be able to fill up the rest of the column the formula but will show blank if there's no value on Column A & B
Spreadsheet: 752158d1634615520-auto-populate-information-from-one-tab-to-another-test-book_1
Sheet: Total Reporting

TOTALS REPORT
Recipient | Zip/Postal Code | OFC USE | Code | Cost | LOG NUMBER
 |  |  |  |  |  |  |  | TR-AUS-DAL-21-1
 |  |  |  |  |  |  |  |  | go to Kisam AM and run report with DC 05 and add to my Non-Fed Recipients report
Spreadsheet: 822275d1679231854-formula-index-and-match-pontaj-2023-draft
Sheet: IANUARTIE

 |  | DATE | 2023-03-01 00:00:00
 |  | NORM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TODAY
 | Nr. [NAME]. | ID | Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NORM HOURS | WORK HOURS | SCREEN HOURS | WEEK HOURS | NIGHT HOURS | CO | CM |  |  | S | P | Z | N | H
 | 1 | 111 | Jhon | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S
 | 2 | 112 | [NAME] | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H
 | 3 | 113 | Adalyn | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N
 | 4 | 114 | [NAME] | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z
 | 5 | 115 | Beverly | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P | Z | N | H | S | P
 | I am looking for a formula that will bring me in cells AS10-AW10, the names of the people that correspond to the shifts in the table. That is, in AS10 under shift S - the name [NAME], today being 19.03.2023. I think the INDEX and MATCH functions should solve this but they are probably doing something wrong as I always get #N/A or sometimes #REF error.
Spreadsheet: 142136d1329678382-summarise-data-from-multiple-sheets-based-on-dates-test-data
Sheet: Area 2

Date | reference | problem |  |  | problem a
 |  |  |  |  | problem b
2012-02-01 00:00:00 | 123abc12 | [NAME] |  |  | problem c
2012-02-02 00:00:00 | 123abc13 | problem c |  |  | [NAME]
2012-02-03 00:00:00 | 123abc14 | problem b
2012-02-04 00:00:00 | 123abc15 | problem b
2012-02-05 00:00:00 | 123abc16 | problem a
2012-02-05 00:00:00 | 123abc17 | [NAME]
2012-02-07 00:00:00 | 123abc18 | problem c
2012-02-08 00:00:00 | 123abc19 | problem b
2012-02-09 00:00:00 | 123abc20 | problem b
Spreadsheet: 869973d1716491396-copy-scores-across-from-date-or-list-to-match-list-penang-league
Sheet: League Table

Position | Club | [NAME] | Wins | Draws | Losses | GF | GA | [NAME] | Points
Club | [NAME] | Wins | Draws | Losses | GF | GA | [NAME] | Points | Ranking Points |  | Rank | Club |  | Bonus
Spreadsheet: 390670d1429721417-auto-populate-fields-based-on-drop-down-selection-table1
Sheet: Sheet2

Product | Product A | Australia | Brazil | Canada | ProductB
Product | Country | Industry | Industry | Industry | Country
ProductA | Australia | Automotive | Automotive | Automotive | Australia
ProductB | Brazil | CPG | CPG | CPG | Brazil
 | Canada | QSR | QSR | QSR | Canada
 |  | Retail | Retail | Retail
Value example table:
Product A | Australia | Automotive | High | 1.2
 |  |  | Medium | 0.7
 |  |  | Low | 0.2
 |  | CPG | High | 1.2
 |  |  | Medium | 0.9
 |  |  | Low | 0.2
 |  | QSR | High | 1.2
 |  |  | Medium | 0.7
 |  |  | Low | 0.2
 |  | Retail | High | 1.3
 |  |  | Medium | 0.7
 |  |  | Low | 0.2
 | Brazil | Automotive | High | 1.2
 |  |  | Medium | 0.6
 |  |  | Low | 0.3
 |  | CPG | High | 1.2
 |  |  | Medium | 0.7
 |  |  | Low | 0.2
 |  | QSR | High | 1.2
 |  |  | Medium | 0.6
 |  |  | Low | 0.3
 |  | Retail | High | 1.2
 |  |  | Medium | 0.9
 |  |  | Low | 0.2
 |  |  | ↓ and so on
Spreadsheet: 90853d1290563674-excel-2007-finding-and-returning-the-numeric-cells-in-a-column-book1
Sheet: Sheet1

raw | numeric | text | others | wanted - numeric | wanted - text
12
3
412
34
235
567
123
te
asd
dfg
cbg
er
123
sra
2345
[NAME]
123
65456
sdfgh
fb
b
Spreadsheet: 86538d1286495785-find-group-and-sum-by-each-dummy-sample
Sheet: Data Dump Tab

 | Name | ID | Proj ID | Totals
 | [NAME] | 1111 | 55555 | 34
 | [NAME] | 1111 | 121212 | 44
 | [NAME] | 1111 | 3232323 | 22
 | [NAME] | 2222 | 55555 | 335
 | [NAME] | 2222 | 121212 | 456
 | [NAME] | 1111 | 434343 | 2132
 | [NAME] | 1111 | 434356 | 54
 | [NAME] | 2222 | 68757 | 7668
 | [NAME] | 2222 | 76578 | 7453
 | Mart Doe | 3333 | 24565 | 234
 | Mart Doe | 3333 | 55555 | 657
 | Mart Doe | 3333 | 3232323 | 2243
 | Mart Doe | 3333 | 345345 | 76576
 | Mart Doe | 3333 | 654645 | 7566
 | [NAME] | 2222 | 3232323 | 342
 | [NAME] | 2222 | 55555 | 32432
 | [NAME] | 2222 | 343434 | 65
 | Mart Doe | 3333 | 34534636 | 345
 | Mart Doe | 3333 | 234324 | 788
Spreadsheet: 15bbf489-2793-43ac-a7e7-5678a5ea2a60
Sheet: Income-Expenses

 | INCREASED HOUSING SERVICE COSTS, p.1  Income and Expenses.
 | Effective Date of Increase:
 |  |  | INCOME
 |  |  | Notes
1 | Rents
2 | Laundry
3 | Parking
4 | Other, specify:
5 | Other, specify:
6 | Other, specify:
7 | Other, specify:
8 | (sum of lines 2-8) |  | Gross Operating Income
 |  |  | EXPENSES
 |  |  | Notes
9 | Business License Tax
10 | Electricity/Gas
11 | Furnishings
12 | Insurance
13 | Laundry
14 | Parking expense
15 | Refuse removal
16 | Replacement
17 | Security
18 | Taxes
19 | Water/Sewer
20 | Other: (specify)
21 | (sum of lines 9-20) |  | Gross Operating Expenses
 | AND EITHER:
22 | Maintenance/Repairs
23 | Management expenses/accounting/legal
24 | SUBTOTAL
 | OR:
25 | 8% of gross op. income
 | The greater of either line 24 or line 25
26 | Other expense, specify:
27 | Other expense, specify:
28 |  |  | Total Operating Expenses
29 |  |  | Difference in expenses (YR2-YR1)
Spreadsheet: 0b40f953-d277-4356-9376-ddca69bce3d1
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Aminoglycosides | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Penicillins | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | [NAME] | Unnamed: 11 | Unnamed: 12 | Macrolide | Unnamed: 14 | Quinolones | Unnamed: 16 | Unnamed: 17 | Cephalosporins | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Others | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30
YOUR FACILITY NAME HERE Antibiogram       2012                    % Susceptible -Systemic | # Isolates Tested | Amikacin | Gentamicin | Streptomycin | Tobramycin | Ampicillin | [NAME] | [NAME] | Piperacillin |  | Imipenem | Meropenem | Erythromycin | Vancomycin | [NAME] | Moxifloxacin | Ciprofloxacin | Cefazolin | Cefepime | Ceftazidime | Cefoxitin | Ceftriaxone | Trimethoprim/ Sulfamethoxazole | Linezolid | Nitrofurantoin | Quinupristin/Dalfopristin | Rifampin | Tetracycline | Tigecycline | Clindamycin
[NAME]
C. freundii | 6 | 100 | 100 |  | 100 |  |  |  | 100 |  | 100 | 100 |  |  | 100 |  | 100 |  | 100 | 100 |  | 100 | 100 |  | 83
E. coli | 98 | 100 | 94 |  | 96 | 64 | 74 |  | 68 |  | 100 | 100 |  |  | 93 |  | 93 | 94 | 99 | 97 | 93 | 99 | 79 |  | 89
[NAME] | 7 | 100 | 100 |  | 100 |  | 57 |  |  |  | 100 | 100 |  |  | 100 |  | 100 | 71 | 86 | 83 | 100 | 86 | 71 |  | 43
K.  pneumoniae | 13 | 100 | 100 |  | 100 |  | 92 |  |  |  | 100 | 100 |  |  | 100 |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  | 31
P. aeruginosa | 10 | 100 | 80 |  | 90 |  |  |  | 100 |  | 100 | 100 |  |  | 60 |  | 70 |  | 100 | 100
[NAME] | 7 | 100 | 100 |  | 100 | 71 | 71 |  | 71 |  |  |  |  |  | 86 |  | 71 | 100 | 100 | 100 | 100 | 100 | 71 | 100
[NAME]
Gram Positive
E. faecalis | 16 |  | 73 | 63 |  | 38 |  | 38 |  |  |  |  | 6 | 94 | 63 |  | 56 |  |  |  |  |  |  | 100 | 100 |  |  | 19 | 100
S. aureus | 55 |  | 100 |  |  |  |  | 9 |  |  |  |  | 49 | 100 | 75 | 92 | 73 |  |  |  |  |  | 98 | 100 | 100 | 100 | 100 | 100 | 100 | 76
S. epidermidis | 6 |  | 100 |  |  |  |  |  |  |  |  |  | 17 | 100 | 17 |  | 17 |  |  |  |  |  |  | 100 | 100 | 100 | 100 | 67 | 100 | 50
CNS - MR
S. lugdunensis | 5 |  | 100 |  |  |  |  | 40 |  |  |  |  | 80 | 100 | 80 |  | 80 |  |  |  |  |  |  |  | 100 |  | 100 | 80 | 100 | 80
Strep. Agalactiae | 8 |  |  |  |  | 100 |  | 100 |  |  |  |  |  | 100 | 100 |  |  |  |  |  |  |  |  | 100 |  | 100 |  | 13 | 100
Spreadsheet: 755806d1637100882-group-scores-highest_partnership_for-_inningsv03
Sheet: Example B

No. Batsman | Player |  |  |  | Not Out | FOW - Team Total | FOW - Number wicket
1 | [NAME] |  |  |  | Retired | 71 | 3
2 | [NAME] |  |  |  |  | 35 | 1 |  |  |  |  | 1
3 | [NAME] |  |  |  |  | 43 | 2 |  |  |  |  | 2
4 | [NAME] |  |  |  |  | 95 | 6 |  |  |  |  | 6
5 | Lucas Clarke |  |  |  |  | 91 | 4 |  |  |  |  | 4
6 | [NAME] |  |  |  |  | 94 | 5 |  |  |  |  | 5
7 | Freddie Schneidereit |  |  |  |  | 96 | 7 |  |  |  |  | 7
8 | [NAME] |  |  |  |  | 118 |  |  |  |  |  | 9
9 | [NAME] |  |  |  |  | 111 | 8 |  |  |  |  | 8
10 | [NAME] |  |  |  | Not Out | 118 |  |  |  |  |  | 9
11 | [NAME]
12
13
14
15
 | 1st Wicket Partnership | 2nd Wicket Partnership | 3rd Wicket Partnership | 4th Wicket Partnership | 5th Wicket Partnership | 6th Wicket Partnership | 7th Wicket Partnership | 8th Wicket Partnership | 9th Wicket Partnership | 10th Wicket Partnership
Batters:
Partnership: | 35 | 8 | 28 | 20 | 3 | 1 | 1 | 15 | 7
Fall of Wicket: | 35 | 43 | 71 | 91 | 94 | 95 | 96 | 111 | 118
Spreadsheet: 92745d1292307101-iteration-continuously-increases-after
Sheet: Week9

Week | Day | Date | Winner/tie | PtsW |  | [NAME]/tie | PtsL
9 | Sun | 2010-11-07 00:00:00 | Philadelphia Eagles | 26 |  | Indianapolis Colts | 24
9 | Sun | 2010-11-07 00:00:00 | Minnesota Vikings | 27 |  | Arizona Cardinals | 24
9 | Sun | 2010-11-07 00:00:00 | [NAME] | 34 |  | New England Patriots | 14
9 | Sun | 2010-11-07 00:00:00 | New Orleans Saints | 34 | @ | Carolina Panthers | 3
9 | Sun | 2010-11-07 00:00:00 | Chicago Bears | 22 | @ | Buffalo Bills | 19
9 | Sun | 2010-11-07 00:00:00 | Atlanta Falcons | 27 |  | Tampa Bay Buccaneers | 21
9 | Sun | 2010-11-07 00:00:00 | Green Bay Packers | 45 |  | Dallas Cowboys | 7
9 | Sun | 2010-11-07 00:00:00 | New York Giants | 41 | @ | [NAME] | 7
9 | Sun | 2010-11-07 00:00:00 | Oakland Raiders | 23 |  | Kansas City Chiefs | 20
9 | Sun | 2010-11-07 00:00:00 | Baltimore Ravens | 26 |  | [NAME] | 10
9 | Sun | 2010-11-07 00:00:00 | San Diego Chargers | 29 | @ | Houston Texans | 23
9 | Sun | 2010-11-07 00:00:00 | New York Jets | 23 | @ | Detroit Lions | 20
9 | Mon | 2010-11-08 00:00:00 | Pittsburgh Steelers | 27 | @ | Cincinnati Bengals | 21
Spreadsheet: 858071d1706845056-enter-first-date-of-the-year-only-and-will-populate-the-rest-of-the-months-calendar-test
Sheet: Nov

 |  |  | WK No. |  | 44 | 44 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 46 | 46 | 46 | 46 | 46 | 46 | 46 | 47 | 47 | 47 | 47 | 47 | 47 | 47 | 48 | 48 | 48 | 48 | 48 | 48
 |  |  | Day |  | 2024-11-02 00:00:00 | 2024-11-03 00:00:00 | 2024-11-04 00:00:00 | 2024-11-05 00:00:00 | 2024-11-06 00:00:00 | 2024-11-07 00:00:00 | 2024-11-08 00:00:00 | 2024-11-09 00:00:00 | 2024-11-10 00:00:00 | 2024-11-11 00:00:00 | 2024-11-12 00:00:00 | 2024-11-13 00:00:00 | 2024-11-14 00:00:00 | 2024-11-15 00:00:00 | 2024-11-16 00:00:00 | 2024-11-17 00:00:00 | 2024-11-18 00:00:00 | 2024-11-19 00:00:00 | 2024-11-20 00:00:00 | 2024-11-21 00:00:00 | 2024-11-22 00:00:00 | 2024-11-23 00:00:00 | 2024-11-24 00:00:00 | 2024-11-25 00:00:00 | 2024-11-26 00:00:00 | 2024-11-27 00:00:00 | 2024-11-28 00:00:00 | 2024-11-29 00:00:00 | 2024-11-30 00:00:00
 |  |  |  |  | 2024-11-02 00:00:00 | 2024-11-03 00:00:00 | 2024-11-04 00:00:00 | 2024-11-05 00:00:00 | 2024-11-06 00:00:00 | 2024-11-07 00:00:00 | 2024-11-08 00:00:00 | 2024-11-09 00:00:00 | 2024-11-10 00:00:00 | 2024-11-11 00:00:00 | 2024-11-12 00:00:00 | 2024-11-13 00:00:00 | 2024-11-14 00:00:00 | 2024-11-15 00:00:00 | 2024-11-16 00:00:00 | 2024-11-17 00:00:00 | 2024-11-18 00:00:00 | 2024-11-19 00:00:00 | 2024-11-20 00:00:00 | 2024-11-21 00:00:00 | 2024-11-22 00:00:00 | 2024-11-23 00:00:00 | 2024-11-24 00:00:00 | 2024-11-25 00:00:00 | 2024-11-26 00:00:00 | 2024-11-27 00:00:00 | 2024-11-28 00:00:00 | 2024-11-29 00:00:00 | 2024-11-30 00:00:00
Spreadsheet: tracy_geaccone__40573__EA Alloc to Other BUs - Support
Sheet: HR

Human Resources Consolidated
Analysis of I/C Billings
2001 Forecast |  |  |  |  |  | 2002 Plan
 | $ | % | HC |  |  |  | $ | % | HC
 |  |  | 138 |  |  |  |  |  | 164
APACHI |  |  |  |  |  | APACHI | 0
CALME |  |  |  |  |  | CALME | 0
CF-MTBE |  |  |  |  |  | CF-MTBE | 0
Citrus |  |  |  |  |  | Citrus | 0
CORP |  |  |  |  |  | CORP
EBS |  |  |  |  |  | EBS
ECB |  |  |  |  |  | ECB | 0
EEDC |  |  |  |  |  | EEDC | 0
EEL | 68004 |  |  |  |  | EEL
EEOS |  |  |  |  |  | EEOS
[NAME] |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  | [NAME]
EFS |  |  |  |  |  | EFS | 0
EGAS |  |  |  |  |  | EGAS
EGEP |  |  |  |  |  | EGEP | 0
EGF |  |  |  |  |  | EGF | 0
EGM |  |  |  |  |  | EGM
EIM |  |  |  |  |  | EIM
EIP |  |  |  |  |  | EIP | 0
ENA |  |  |  |  |  | ENA
ENW |  |  |  |  |  | ENW
EPI |  |  |  |  |  | EPI
EREC |  |  |  |  |  | EREC | 0
ETS |  |  |  |  |  | ETS
FGT |  |  |  |  |  | FGT | 0
HPLP |  |  |  |  |  | HPLP | 0
India |  |  |  |  |  | India | 0
[NAME] |  |  |  |  |  | [NAME] | 0
NNG |  |  |  |  |  | NNG | 0
Northern Plains |  |  |  |  |  | Northern Plains | 0
South America |  |  |  |  |  | South America | 0
TW |  |  |  |  |  | TW | 0
Xcelerator | 0 |  |  |  |  | Xcelerator
Total 2001 Forecast Allocations |  |  |  |  |  | Total 2002 Plan Allocations
Other Business Units |  |  |  |  |  | Other Business Units
Net ENA |  |  |  |  |  | Net ENA
Note
2002 Plan Direct Expense and allocations to business units include Bonus Accrual.
Spreadsheet: darrell_schoolcraft__7307__imball0201
Sheet: SoCal

 | 10487 |  | 56697
Day | Measured | Scheduled | Measured | Scheduled
1 | -492632 | -494656
2 | -501900 | -485325
3 | -540213 | -539549
4 | -472917 | -473220
5 | -501953 | -499242
6 | -549512 | -560014
7 | -525598 | -521371
8 | -534270 | -531085
9 | -607985 | -606773
10 | -588011 | -634161
11 | -603183 | -611815
12 | -599978 | -580516
13 | -586866 | -580516
14 | -573809 | -573034
15 | -541773 | -542075
16 | -554650 | -567930
17 | -534042 | -533662
18 | -560683 | -561288
19 | -565794 | -575734
20 | -566988 | -568953
21 | -539935 | -542926
22 | -554211 | -535626
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  |  |  | 104420
2002-01-22 00:00:00
CBS Dollars
 |  |  | 331917
Spreadsheet: 740443d1626343385-increasing-the-reference-row-in-a-series-of-random-formulas-by-one-demo
Sheet: 2021-22 Q2

Performance Indicator | Current Year Q2 | Last Year Q2 | [NAME] Past 5 Years
Measure 1
Measure 2
Measure 3
Measure 4
Measure 5
Measure 6
Measure 7
Measure 8
Measure 9
Measure 10
Measure 11
Measure 12
Measure 13
Measure 14 | n/a | n/a | n/a
Measure 15
Measure 16
Measure 17
Measure 18
Measure 19 | n/a | n/a | n/a
Measure 20
Measure 21
Measure 22
Measure 23
Measure 24
Measure 25
Measure 26
Measure 27
Measure 28
Measure 29
Measure 30
Measure 31
Measure 32
Measure 33
Measure 34
Measure 35
Measure 36
Measure 37
Measure 38
Measure 39
Measure 40
Measure 41
Measure 42
Measure 43
Measure 44
Measure 45
Measure 46
Measure 47
Measure 48
Measure 49
Measure 50
Measure 51
Measure 52
Measure 53
Measure 54
Measure 55
Measure 56
Measure 57
Measure 58
Measure 59
Measure 60 | 0.8328 | n/a | n/a
Spreadsheet: 820665-counting-available-beds-in-a-facility-sample_mg
Sheet: Tabelle1

 |  |  |  |  |  |  |  |  | I want to count all empty cells in column D, but only if columns E and F are also empty  and only if column C of the same room number is also empty or contains the value "f".
 | Room | Sex | Name | Infos | Planning |  | Available Beds
 | 1
 | 2 |  |  |  |  |  | Female
 | 2 | f | Mrs. [NAME]
 | 3
 | 3 |  |  |  |  |  | Male
 | 4
 | 4 | m | Mr. [NAME]
 | 5 |  |  |  |  |  | Unisex
 | 6
 | 7
 | 7
Spreadsheet: 155471d1336866959-paste-certain-files-to-a-sheet-where-cells-are-merged-excel-20forumq-1-
Sheet: Sheet1

Name | ID | Age
Pieter | 2121212L | 232
Rutger | 1211234L
Amelie | 5662W4L | 23
Jan | 4342233L
[NAME] | 4465775L | 23 |  |  | Copy all the cells from column B to sheet 2 column B if the cell in column C has a value
Nepre | 3435463L | 4 |  |  | The difficult part is that in sheet 2 cells are merged. See example
[NAME] | 3454656L
[NAME] | 3454653L | 5
Gort | 3564346L
[NAME] | 2355335L | 3
Oster | 4453234L
[NAME] | 4534367L | 32
[NAME] | 3334563L | 5
Thijs | 5674322L
Robbert | 6763677L | 43