tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 732126d1620780970-number-of-different-values-in-a-range-based-on-criteria-test1
Sheet: Sheet1

JAN | 2021-01-01 00:00:00 | AAA | hq
 | 2021-01-12 00:00:00 | AAA | hq
 | 2021-01-20 00:00:00 | AAA |  | 2x AAA, so desired value is "1"
FEB | 2021-02-03 00:00:00 | BBB | hq
 | 2021-02-17 00:00:00 | BBB | hq
 | 2021-02-18 00:00:00 | BBB
 | 2021-02-24 00:00:00 | AAA |  | 2x BBB, so desired value is "1"
MAR | 2021-03-03 00:00:00 | AAA | hq
 | 2021-03-07 00:00:00 | AAA | hq
 | 2021-03-08 00:00:00 | CCC
 | 2021-03-11 00:00:00 | CCC | hq
 | 2021-03-14 00:00:00 | CCC
 | 2021-03-21 00:00:00 | CCC
 | 2021-03-23 00:00:00 | CCC
 | 2021-03-29 00:00:00 | AAA | hq
 | 2021-03-30 00:00:00 | AAA | hq | 4x AAA & 1xCCC, so desired value is "2"
APR | 2021-04-02 00:00:00 | BBB
 | 2021-04-04 00:00:00 | BBB | hq
 | 2021-04-04 00:00:00 | AAA | hq
 | 2021-04-06 00:00:00 | CCC
 | 2021-04-08 00:00:00 | CCC | hq
 | 2021-04-18 00:00:00 | BBB | hq
 | 2021-04-20 00:00:00 | DDD
 | 2021-04-23 00:00:00 | DDD | hq
 | 2021-04-27 00:00:00 | DDD | hq
 | 2021-04-28 00:00:00 | AAA | hq
 | 2021-04-30 00:00:00 | DDD | hq | 2x AAA, 2xBBB, 1xCCC, 3xDDD, so desired value is "4"
MAY | 2021-05-02 00:00:00 | EEE
 | 2021-05-04 00:00:00 | AAA | hq
 | 2021-05-05 00:00:00 | CCC | hq
 | 2021-05-07 00:00:00 | CCC | hq
 | 2021-05-08 00:00:00 | BBB |  | 1xAAA, 2xCCC, so desired value is "2"
Spreadsheet: 875450d1722007835-formula-to-add-fill-color-to-cell-if-day-of-the-week-matches-today-find-the-date-of-the-next-weekday-metal_-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Patient | Start | Weeks | Next | Duration
 | Mon | Tue | Wed | Thu | Fri |  |  |  | Patient A | 2024-07-01 00:00:00 | 1
 | Meds | Meds | Meds | Meds | Meds |  |  |  | Patient B | 2024-07-01 00:00:00 | 2
 | Patient A | Patient C | Patient D | Patient F | Patient G |  |  |  | Patient C | 2024-07-02 00:00:00 | 1
 | Patient B |  | Patient E |  |  |  |  |  | Patient D | 2024-07-03 00:00:00 | 2
 |  |  |  |  |  |  |  |  | Patient E | 2024-07-03 00:00:00 | 4
 |  |  |  |  |  |  |  |  | Patient F | 2024-07-04 00:00:00 | 2
 |  |  |  |  |  |  |  |  | Patient G | 2024-07-05 00:00:00 | 1
Spreadsheet: 868416d1715162058-calculating-summary-sheet-using-indirect-function-for-multiple-months-yiyi2-payroll-example
Sheet: Jan-2024

Emp Code | [NAME] | Date | Roster Schedule | Roster Location | Start Time | End Time | Roster TTL excl Lunch | FT Official Hour | Place | Clock In | Clock Out | Lunch | Lateness | Early Leave | Overtime | Total Hours | Compare
147 | [NAME] | 2024-01-01 00:00:00 | 09:15-19:30 |  |  |  |  |  | OP | 09:38 | 19:49 | 0.75
147 | [NAME] | 2024-01-02 00:00:00 | 11:45-21:00 |  |  |  |  |  | OP | 11:50 | 21:12 | 1
147 | [NAME] | 2024-01-03 00:00:00 | Off-1
147 | [NAME] | 2024-01-04 00:00:00 | 10:00-19:00 |  |  |  |  |  | OP | 10:29 | 19:03 | 1
147 | [NAME] | 2024-01-05 00:00:00 | 09:15-18:30 |  |  |  |  |  | OP | 09:08 | 18:31 | 1
147 | [NAME] | 2024-01-06 00:00:00 | SL-1
147 | [NAME] | 2024-01-07 00:00:00 | SL-1
147 | [NAME] | 2024-01-08 00:00:00 | 11:45-21:00 |  |  |  |  |  | OP | 11:55 | 21:30 | 1
147 | [NAME] | 2024-01-09 00:00:00 | Off-1
147 | [NAME] | 2024-01-10 00:00:00 | 11:45-21:00 |  |  |  |  |  | OP | 11:47 | 21:01 | 1
147 | [NAME] | 2024-01-11 00:00:00 | 11:45-21:00 |  |  |  |  |  | OP | 11:52 | 21:00 | 1
147 | [NAME] | 2024-01-12 00:00:00 | 11:45-21:00 |  |  |  |  |  | OP | 12:18 | 22:33 | 1
147 | [NAME] | 2024-01-13 00:00:00 | 11:45-22:00 |  |  |  |  |  | OP | 11:58 | 16:35 | 1
147 | [NAME] | 2024-01-14 00:00:00 | 11:45-21:00 |  |  |  |  |  | OP | 12:00 | 22:10 | 1
147 | [NAME] | 2024-01-15 00:00:00 | 09:15-18:30 |  |  |  |  |  | OP | 10:01 | 18:31 | 0.5
147 | [NAME] | 2024-01-16 00:00:00 | Off-1
147 | [NAME] | 2024-01-17 00:00:00 | 09:30-18:30 |  |  |  |  |  | OP | 10:26 | 19:00 | 1
147 | [NAME] | 2024-01-18 00:00:00 | 09:15-18:30 |  |  |  |  |  | OP | 09:22 | 19:00 | 0.75
147 | [NAME] | 2024-01-19 00:00:00 | 09:15-18:30 |  |  |  |  |  | OP | 09:22 | 18:47 | 1
147 | [NAME] | 2024-01-20 00:00:00 | Off-1
147 | [NAME] | 2024-01-21 00:00:00 | Off-1
147 | [NAME] | 2024-01-22 00:00:00 | 09:15-18:30 |  |  |  |  |  | OP | 10:09 | 18:35 | 1
147 | [NAME] | 2024-01-23 00:00:00 | 11:45-21:00 |  |  |  |  |  | OP | 12:17 | 21:15 | 1
147 | [NAME] | 2024-01-24 00:00:00 | 09:15-18:30 |  |  |  |  |  | OP | 10:14 | 18:49 | 1
147 | [NAME] | 2024-01-25 00:00:00 | Off-1
147 | [NAME] | 2024-01-26 00:00:00 | 09:15-18:30 |  |  |  |  |  | OP | 10:26 | 18:58 | 1
147 | [NAME] | 2024-01-27 00:00:00 | 09:15-13:35 |  |  |  |  |  | OP | 09:54 | 13:38 | 1
147 | [NAME] | 2024-01-28 00:00:00 | SL-1
147 | [NAME] | 2024-01-29 00:00:00 | SL-1
147 | [NAME] | 2024-01-30 00:00:00 | 11:45-21:00 |  |  |  |  |  | OP | 12:08 | 21:16 | 1
PWHK147 | [NAME] | 2024-01-31 00:00:00 | 11:45-21:00 |  |  |  |  |  | OP | 12:03 | 21:00 | 1
Total
 |  |  |  |  |  |  |  |  |  |  |  |  | EG
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | 7.7
 |  |  |  |  |  |  |  |  |  |  |  |  | 07:46:00
Spreadsheet: 489945d1479497041-vlookup-on-date-and-then-add-book2
Sheet: Sheet1

Customer | Date
1 | 2016-01-01 00:00:00 |  |  | 1
2 | 2016-02-01 00:00:00 |  |  | 1
3 | 2016-03-01 00:00:00 |  |  | 2
4 | 2016-04-01 00:00:00 |  |  | 2
 |  |  |  | 3
 |  |  |  | 4
 |  |  |  | 4
 |  |  |  | 4
Spreadsheet: 808483d1670492340-combine-2-sheets-grade-6
Sheet: MKEKA MKUU

[NAME] MATOKEO MTIHANI WA MUHULA WILAYA DARASA LA III WILAYA [NAME] 2021.
[NAME] |  |  |  |  | MASOMO
NA | JINA LA MTAHINIWA | JINSI WAV=1 &WAS=2 | SHULE |  | KISWAHILI |  | ENGLISH |  | HISABATI |  | SAYANSI &TEKNOLOJIA |  | M/JAMII |  | URAIA NA MAADILI |  | S/KAZ |  |  | DARAJA
 |  |  |  | KATA | A | D | A | D | A | D | A | D | A | D | A | D | A | D | JML | WASTANI | DARAJA | KISHULE | KIKATA
1
 |  | DARAJA |  |  |  |  |  |  |  |  |  | WASTANI
 | SHULE | DARAJA | SOMO |  | KISW |  | ENGL |  | [NAME] |  | SAYANSI &TEKNOLOJIA |  | M/JAMII |  | URAIA NA MAADILI |  | S/KAZ |  |  | DARAJA
 | NAMELOCK |  | JINSI |  | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 |  | 1 | 2
 |  | A
 |  | B
 |  | C
 |  | D
 |  | E
 |  | ABS
 |  |  | JML
 | KINUA | A
 |  | B
 |  | C
 |  | D
 |  | E
 |  | ABS
 |  |  | JML
 | NJIAPANDA | A
 |  | B
 |  | C
 |  | D
 |  | E
 |  | ABS
 |  |  | JML
 | OLOIMUGI | A
 |  | B
 |  | C
 |  | D
 |  | E
 |  | ABS
 |  |  | JML
 | KAZINGUMU | A
 |  | B
 |  | C
 |  | D
 |  | E
 |  | ABS
 |  |  | JML
 | [NAME] | A
 |  | B
 |  | C
 |  | D
 |  | E
 |  | ABS
 |  |  | JML
Spreadsheet: 43b69930-eb81-421c-ae0b-0c4fc116fa96
Sheet: Report

Unit | Unit Priority | Objective Name | Strategic Direction | Impact Type | Resource Id | Resource Name | Resource Type | Year 1 Cost | Year 1 Savings | Year 2 Cost | Year 2 Savings | Year 3 Cost | Year 3 Savings | Year 4 Cost | Year 4 Savings
Payroll | 1 | Payroll Training | None | -- Pick One -- | 1.1.r1 | [NAME] | OnGoing | 800 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Payroll | 1 | Newsletter by e-mail | None | -- Pick One -- | 2.1.r1 | Monthly letter | OnGoing | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 299e05e2-6f81-47fc-886a-ffcdebbd8cf0
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40252273 | 2014-02-26 19:02:40 | AXIS | 1 | 7 | 2 | 1330438 | Dohun | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
40252482 | 2014-02-26 19:23:12 | ALLIES | 0 | 6 | 7 | 1330438 | Dohun | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
40267799 | 2014-02-27 18:39:35 | ALLIES | 0 | 3 | 5 | 1515134 | [NAME] | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
40268001 | 2014-02-27 18:52:26 | ALLIES | 1 | 5 | 1 | 29441 | w a r r i o r | 9597 | western | 1944-06-06 | 1944-06-06 | Utah Beach | Utah Beach
40268166 | 2014-02-27 19:06:31 | AXIS | 0 | 1 | 5 | 29441 | w a r r i o r | 9597 | western | 1944-06-06 | 1944-06-06 | Utah Beach | Utah Beach
40389626 | 2014-03-06 23:33:35 | ALLIES | 0 | 6 | 7 | 506159 | Hurletout | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40390010 | 2014-03-06 23:50:02 | AXIS | 1 | 7 | 3 | 506159 | Hurletout | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
Spreadsheet: 44048d1242725136-help-to-make-moving-conditional-formatting-research
Sheet: surplus,deficit

 | Requirement |  | Jan | Feb | Mar | Apr | May | June | July
 |  | X | 9 | 8 | 5 | 2 | 6 | 5 | 36
 |  | Y | 4 | 6 | 17 | 1 | 5 | 4 | 30
 |  | Z | 3 | 10 | 7 | 5 | 3 | 7 | 37
 | Availability |  | Jan | Feb | Mar | Apr | May | June | July
 |  | X | 5 | 5 | 5 | 5 | 5 | 4 | 4
 |  | Y | 5 | 7 | 5 | 5 | 5 | 6 | 6
 |  | Z | 5 | 5 | 5 | 5 | 5 | 3 | 3
 | Surplus/Deficit |  | Jan | Feb | Mar | Apr | May | June | July
 |  | X | -4 | -3 | 0 | 3 | -1 | -1 | -32
 |  | Y | 1 | 1 | -12 | 4 | 0 | 2 | -24
 |  | Z | 2 | -5 | -2 | 0 | 2 | -4 | -34
Spreadsheet: 3c40a58f-e4c0-46e5-9091-a9bc20e8abc7
Sheet: Calculator

 | HP | Atk | Def | SpA | SpD | Spe |  | SF | BST |  | PT | ST | PS | SS |  | BSR
1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | PT / ST / PS / SS Range | Description
2 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | x < 25 | Horrible
3 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | 25 < x < 50 | Bad
4 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | 50 < x < 75 | Poor
5 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | 75 < x < 100 | Below Average
6 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | 100 < x < 125 | Above Average
7 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | 125 < x < 150 | Good
8 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | 150 < x < 175 | Very Good
9 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | 175 < x < 200 | Excellent
10 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | 200 < x < 225 | Fantastic
11 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | 225 < x | Amazing
12 | 1 | 1 | 1 | 1 | 1 | 1
13 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | BSR Range | Description
14 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | x < 50 | Horrible
15 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | 50 < x < 100 | Bad
16 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | 100 < x < 150 | Poor
17 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | 150 < x < 200 | Below Average
18 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | 200 < x < 250 | Above Average
19 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | 250 < x < 300 | Good
20 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | 300 < x < 350 | Very Good
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 350 < x < 400 | Excellent
 | Hello, and welcome to CAP's Base Stat Rating Calculator! This calculator will perform all the tricky mathematics for you, and rate your [NAME]'s stat spread relative to all other [NAME] in the game. To get started, here's what to do: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 400 < x < 450 | Fantastic
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 450 < x | Amazing
 | 1. Enter your stat spread into the pink table under any of the rows - there are twenty in total, so you can compare different stat spreads. This is all you need to add - the calculator will do everything else for you.
 | 2. If you prefer, you can copy and paste the data of an existing [NAME] in to see its stat ratings (look under the "BSR of All Pokemon" tab at the bottom of the screen).
 | 3. Copy and paste your calculated stat ratings anywhere you want to. If you enter an official [NAME] stat spread competition, you'll need to include these values for your submission to be legal.
 | Oh, and one last thing - don't mess about with the formulae if you don't know what they do! These are quite complicated, so we'd recommend reading up on them if you want to fiddle with them.
Spreadsheet: 736940d1623953901-finding-repeate-value-repeatcheck_jimmiboy
Sheet: Sheet1

 |  |  |  |  |  |  |  | OldNumber | donor_name | donor_mobile | account_no | donor_pan | NewNumber | Check
 |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  | 15 |  |  |  |  | 2455721 | Repeate
 |  |  |  |  |  |  |  | 401029 |  |  |  |  | 401030 | Unique
 |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  | 15 |  |  |  |  | 2455620 | Unique
 |  |  |  |  |  |  |  | 15 |  |  |  |  | 396790 | Unique
 |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  | 2455721 |  |  |  |  | 2455721 | Unique
 |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  | 15 |  |  |  |  | 401028 | Unique
 |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  | 15
Spreadsheet: 188557df-1e70-4da0-aca5-ee5eeab30000
Sheet: 4ED OUT OF 68

RANK | ANON#
585962 | 7
587173 | 12
587184 | 8
587194 | 10
587209 | 5
587218 | 16
587219 | 4
587220 | 2
587236 | 1
587242 | 3
587243 | 11
587254 | 9
587264 | 17
587280 | 15
587290 | 13
587297 | 6
587622 | 14
Spreadsheet: 876153d1722846756-need-formula-for-tier-incentive-calculation-calculation-doing-formula-etaf
Sheet: Tareq Toma

Contract Terms (*)
 |  | Description | Commission
 |  | Net Revenue = Revenue - 5% Admin - Ticket&Accomodation - Consumables) Or 1500 minimum guaranteed per working day . | 0.5
Doctor Calculation
 |  | Revenue | 21850
 |  | Admin Fee
 |  | Tickets and Accomodation
 |  | Consumables | 0
 |  | Net Revenue
 |  | Amount to be paid
 |  | 1500 per working day | 1500 | 7 | Days
 |  | Amount to be paid
 |  | Total amount to be paid
 |  | Add Home Visits | 0
 |  | less Salary | 6000
 |  | Total amount to be paid
Prepared By …................. |  |  |  | CFO | .......................
Spreadsheet: 84692f9c-4a88-42c7-9a73-5a7b2f77898c
Sheet: SEAR

 |  | Diet and Physical Activity for the Prevention of Non Communicable Diseases in Low and Middle-Income Countries: A Systematic Policy Review
 |  | Lachat et al. Plosmed
 |  | Table S1: Availability of national policy documents and strategies for NCD prevention in low- and middle- income countries by WHO region
 |  | South-East Asia region
 |  | Short name | Full name | Classification | WHO region | Policy status assessed | County with policy elibigle for review | Reason for exclusion from review | Language | Type of policy | Classification code | NCD Strategy
 |  |  |  |  |  |  |  |  |  |  |  | Salt | Fat | FV | PA | Number of strategies
 | 1 | Bangladesh | the People’s Republic of Bangladesh | Low income | SEAR | yes | yes |  | English | NP | 4 |  |  | yes
 | 2 | Bhutan | the Kingdom of Bhutan | Lower middle income | SEAR | yes | yes |  | English | NCD | 4 | yes | yes | yes | yes
 | 3 | India | the Republic of India | Lower middle income | SEAR | yes | yes |  | English | 5 year plan | 4 |  |  | yes | yes
 | 4 | Indonesia | the Republic of Indonesia | Lower middle income | SEAR | yes | yes |  | English | NP | 4 | yes | yes | yes | yes
 | 5 | Korea, Dem. Rep. | Democratic People’s Republic of Korea | Low income | SEAR | no |  |  |  |  | 1
 | 6 | Maldives | the Republic of Maldives | Lower middle income | SEAR | yes | yes |  | English | NP | 4 |  |  | yes
 | 7 | Myanmar | the Republic of the Union of Myanmar | Low income | SEAR | yes | yes |  | English | HP | 3
 | 8 | Nepal | the Federal Democratic Republic of Nepal | Low income | SEAR | yes | yes |  | English | NP | 4 |  |  | yes
 | 9 | [NAME] | the Democratic Socialist Republic of Sri Lanka | Lower middle income | SEAR | yes | yes |  | English | NP | 4 |  |  | yes | yes
 | 10 | Thailand | the Kingdom of Thailand | Lower middle income | SEAR | yes | yes |  | English | HP | 3
 | 11 | Timor-Leste | the Democratic Republic of Timor-Leste | Lower middle income | SEAR | yes | yes |  | English | NP | 3
Spreadsheet: daren_farmer__5236__BMSPT051
Sheet: BMSPT066

BAMMEL STORAGE ACTIVITY
VOLUME SPLIT BY Counterparties
2001-05-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | SWING CONTRACT VOLUMES |  |  |  |  | ECT LONG/(SHORT) |  |  |  | LONG/(SHORT)
 |  | HPL INDEX |  |  | HPL FIXED PRICE |  |  |  |  | TOTAL | HL&P | CP&L | TUFCO | TOTAL |  | ECT FIRST OF THE MONTH | TUFCO/ HL&P/ CP&L SWING VOLUME | ECT LONG OR (SHORT) |  | ECT TOTAL | HPLC Excluding 3rd Party | Net LONG/ (SHORT)
 |  | MTD Adjustment | CURRENT DAY | Total | MTD Adjustment | CURRENT DAY | Total | 3rd Party | HPLC Total |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  | Reinject Fees
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Injected Volume | Value
Beginning Balance
1 | Scheduled |  |  |  |  |  |  |  |  |  | 0 | 0
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Estimated
 | Estimated
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Index: | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fuel: | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fuel Rate:
Ending Balance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prod.[NAME]:
Variances:
Total Projected
April 28 thru May 4
May 5 thru May 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Previous Position: |  | 586654
May 12 thru May 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]:
May 19 thru May 25
Spreadsheet: 805658d1668807959-formula-split-complete-description-to-their-respective-headers-s666-pq-split-complete-description-to-their-respective-headers
Sheet: SAMPLE

description |  | Description | Code | Pays
COUVRE VOLANT COUTURES 38 CM Nomenclature douaniere 39269097 Pays d'origine CHINE |  | COUVRE VOLANT COUTURES 38 CM | 39269097 | CHINE
COUVRE VOLANT BIMATIERE SPORT 38 Nomenclature douantere 39269097 Pays d'origine CHINE |  | COUVRE VOLANT BIMATIERE SPORT | 39269097 | CHINE
HOUSSE DE PROTECTION MOTO-L Nomenclature douantere 63079098 Pays d'origine CHINE |  | HOUSSE DE PROTECTION MOTO-L | 63079098 | CHINE
ARBRE MAGIQUE PARFUM SPORT Nomenclature douaniere 33074900 Pays d'origine SUISSE |  | ARBRE MAGIQUE PARFUM SPORT | 33074900 | SUISSE
ARBRE MAGIQUE PARFUM BUBBLE GUM Nomenclature douaniere 33074900 Pays d'origine SUISSE |  | ARBRE MAGIQUE PARFUM BUBBLE GUM | 33074900 | SUISSE
 |  | EXPECTED REDULTS
 |  | [NAME] | CODE | PAYS
 |  | COUVRE VOLANT COUTURES 38 CM | 39269097 | CHINE
 |  | COUVRE VOLANT BIMATIERE SPORT | 39269097 | CHINE
 |  | HOUSSE DE PROTECTION MOTO-L | 63079098 | CHINE
 |  | ARBRE MAGIQUE PARFUM SPORT | 33074900 | CHINE
 |  | ARBRE MAGIQUE PARFUM BUBBLE GUM | 33074900 | CHINE
Spreadsheet: 91287d1291056945-excel-2007-copy-from-one-sheet-to-another-if-a-condition-is-met-copy-of-admin-budget-revised2
Sheet: Sheet3

[NAME]
Spreadsheet: 864811d1711961267-conditional-formatting-to-highlight-percentages-question2-edited-cf-rule-aligw
Sheet: Annual leave entitlement

 |  | Employees | Annual leave entitlement | 50% | 75%
 |  | [NAME] | 25
 |  | [NAME] | 27
 |  | [NAME] | 30
 |  | Mark | 28
Spreadsheet: 889750d1740664820-help-with-index-vlookup-and-calculations-test_updated
Sheet: Buy

 | date | name | amount
 | 2025-02-20 00:00:00 | Name 1 | 10
 | 2025-02-20 00:00:00 | Name 2 | 22
 | 2025-02-20 00:00:00 | Name 3 | 3
 | 2025-02-20 00:00:00 | Name 4 | 25
 | 2025-02-22 00:00:00 | Name 1 | 10
 | 2025-02-24 00:00:00 | Name 4 | 5
Spreadsheet: 816227d1675434575-cross-check-and-sum-excel-example
Sheet: Sheet1

 |  |  |  | Product: | Adis1 | Adis5 | Adis6 | Adis2 | Adis7 | Adis9 | Adis10 | Adis11 | Adis12 | Adis13 | Adis3 | Adis14 | Adis8 | Adis15 | Adis16 | Adis17 | Adis4 | Adis18 | Adis19 | Adis20
Compoenent
ABC1 | Do SUM for only products founded in Sheet2 but are founded in this sheet to. There are 10 different products in Sheet2 that match with Products in this sheet. SUM of these products should give Result 5 in this sheet and this row. |  |  |  | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 10 | 10 | 10 | 0 | 10 | 1 | 10 | 10 | 10 | 0 | 10 | 10 | 10
[NAME] |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
ABC3 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
[NAME] |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
ABC5 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
ABC6 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
ABC7 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
ABC8 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
ABC9 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
ABC10 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
ABC11 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
ABC12 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
ABC13 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
ABC14 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
ABC15 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
ABC16 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
ABC17 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
ABC18 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
ABC19 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
ABC20 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 10 | 10 | 10 | 1 | 10 | 1 | 10 | 10 | 10 | 1 | 10 | 10 | 10
Spreadsheet: 846234d1697512119-listng-team-wise-names-from-a-list-bebo021999
Sheet: Sheet1

Sno | Name | Department | Designation | Category | Team | Helper
1 | Naveena | Administration | Accountant | A | IPL-D
2 | Nandini | Housekeeping | Supervisor - Housekeeping | B | IPL-C
3 | Satish | Operations | Supervisor - Operations | D | IPL-B
4 | Sunil | Inpark Sales | Assistant Manager - Revenue Operations | D | IPL-A
5 | Basavaraj | Inpark Sales | Executive - Inpark Sales | E | IPL-C
6 | Manjunath | Maintenance | Manager - Maintenance | F | IPL-D
7 | Devaraju | Maintenance | Assistant Manager - Maintenance | G | IPL-C
8 | Girish | Maintenance | Assistant Manager - Stores | G | IPL-B
9 | Madhu | Maintenance | Executive - Maintenance | G | IPL-B
10 | Raju | Maintenance | Executive - Maintenance | G | IPL-A
11 | Ravikiran | Maintenance | Assistant Manager -Maintenance | G | IPL-A
12 | Meghana | Marketing | Digital Marketing Specialist | H | IPL-D
13 | Veena | Operations | Assistant Manager-Snow Park Operations | I | IPL-A
14 | [NAME] (FnB) | Restaurant | Assistant [NAME] | J | IPL-B
15 | Venkatesh H P | Restaurant | Executive - F & B | J | IPL-C
16 | Venkatesh B | Sales | Area Sales Manager (Off: [PHONE]) | K | IPL-D
At I3 | IFERROR(INDEX($F$2:$F$17,MATCH(0,INDEX(COUNTIF($H$3:H3,$F$2:$F$17),),0)),"")
At I4 | IFERROR(INDEX($B:$B,AGGREGATE(15,6,ROW($F$2:$F$17)/($F$2:$F$17=I$3),ROWS($1:1))),"")
Spreadsheet: 163643d1340384783-excel-2007-how-to-match-two-field-with-reference-field-stimulation_1
Sheet: Sheet3

Invoice# | DR | CR
a | 10
a |  | 10 |  |  | Row Labels | Sum of CR | Sum of DR | Sum of check
b | 33 |  |  |  | a | 10 | 10 | 0
b |  | 31 |  |  | f | 16 | 16 | 0
c | 12 |  |  |  | e | 43 | 43 | 0
d | 22 |  |  |  | d | 21 | 22 | 1
d |  | 21 |  |  | b | 31 | 33 | 2
e | 43 |  |  |  | c |  | 12 | 12
e |  | 43 |  |  | Grand Total | 121 | 136 | 15
f | 16
f |  | 16