tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 61474d1262345493-excel-2007-check-for-text-from-a-list-then-return-a-specific-value-if-matched-book2
Sheet: List

[NAME] | Gosford - NSW | Adaminaby - NSW | NSW
Rosehill - NSW | Grafton - NSW | Bungendore - NSW | QLD
Warick Farm - NSW | Hawkesbury - NSW | Crookwell - NSW | VIC
Doomben - Qld | KemblaGrange - NSW | Lockhart - NSW | WA
Eagle Farm - Qld | Newcastle - NSW | Burrandowan - Qld | SA
 | Canberra - ACT | Calliope - QLD | TAS
 | Fannie Bay - NT | Cunnamulla - QLD | NT
Spreadsheet: 787435d1657799220-conditional-formating-or-list-required-to-highlight-values-not-pulled-through-that-should-pricing-review-examples
Sheet: Dashboard

 | WSP Contract Payment [NAME] |  |  |  | Submission Month
 |  | No Jobs | Value |  | 2022-05-01 00:00:00
 | Total Number Jobs | 19 | #REF! |  | Contract Lot
 | Number of Errors (Input) | 0 | #REF! |  | Lot 3 (Dev Serv)
Yes | Total Number of Audits | #REF! | #REF! |  | Partner |  | Region
Yes | Number Audits In Query | #REF! | #REF! |  | Network Plus |  | Regional
 | Number Audits Complete | #REF! | #REF!
 | Total in CSV Extract | 0 | #REF!
 | Unique Service Products | 7.000000000000001
 | Total Excluding Fee |  | #REF!
 | Fee |  | #REF!
 | Total Including Fee |  | #REF!
Spreadsheet: 674036d1587641489-vlookup-between-dates-month-counts-data
Sheet: Sheet3

Month start | Month end |  | Name | Date of issue
2020-01-01 00:00:00 | 2020-01-31 00:00:00 |  | bill | 2020-03-04 00:00:00
2020-02-01 00:00:00 | 2020-02-28 00:00:00 |  | bob | 2020-01-12 00:00:00
2020-03-01 00:00:00 | 2020-03-31 00:00:00 |  | pedro | 2020-04-23 00:00:00
2020-04-01 00:00:00 | 2020-04-30 00:00:00 |  | [NAME] | 2020-02-27 00:00:00
Totals
Total Jan |  | <<to tell me how many from column E fall between Jan month start and month end
Total Feb
Total Mar
Total Apr
Spreadsheet: 860782d1708774905-populate-from-another-sheet-with-duplicates-product-pick-dj
Sheet: Data

Customer # | Customer Name | Product name | [NAME] (lbs) | [NAME] (kgs)
2714 | Jordan | Poly Bags | 550
2714 | Jordan | Poly Bags | 550
2714 | Jordan | Poly Bags | 550
3004 | [NAME] | Carton | 100
3004 | [NAME] | Poly Bags | 100
3004 | [NAME] | Sacks | 100
3006 | Jordan | Carton | 550
2872 | [NAME] | Small Carton | 1000
2920 | Jordan | Small Carton | 150
2772 | [NAME] | Strapping | 50
2772 | [NAME] | Green Strapping | 50
2772 | [NAME] | Sacks | 50
3003 | [NAME] | Carton | 1500
3001 | Hollis | Carton | 150
2918 | [NAME] | Large Carton | 5000
Spreadsheet: 857810d1706709127-populate-a-column-with-a-code-based-on-dropdown-selection-in-another-column-draft
Sheet: Course structure

DO NOT EDIT THIS PAGE
Clifton - BSc (Hons) Nursing
Course Code | Course Title
SWRK114 (Ad) | BSc (Hons) Nursing (Adult)
SWRK115 (MH) | BSc (Hons) Nursing (Mental Health)
SWRK117 (Ad App) | BSc [NAME] in Adult Apprenticeship
SWRK150 (LD) | BSc (Hons) Nursing (Learning Disabilities)
SWRK151 (LD App) | BSc (Hons) Nursing (Learning Disabilities) (Level 6 Registered Nurse Degree Apprenticeship)
[NAME] Code
SWRK30890 Innov Improve Health Yr3
[NAME] in Nursing Yr3
SWRK30900 Lead Manage Applied Nurse Yr3
Mansfield - BSc (Hons) Nursing
Course Code | Course Title
SWRK146 (Ad) | BSc (Hons) Nursing (Adult)
SWRK147 (MH) | BSc (Hons) Nursing (Mental Health)
SWRK149 (Ad App) | BSc [NAME] in Adult Apprenticeship
Mansfield Module Code
SWRK31275 Innov Improve Health Yr3
SWRK31280 Leadership in Nursing Yr3
SWRK31285 Lead Manage Applied Nurse Yr3
[NAME] | Mansfield
SWRK30890 Innov Improve Health Yr3 | SWRK31275 Innov Improve Health Yr3
[NAME] in Nursing Yr3 | SWRK31280 Leadership in Nursing Yr3
SWRK30900 Lead Manage Applied Nurse Yr3 | SWRK31285 Lead Manage Applied Nurse Yr3
Spreadsheet: 869400d1715964849-left-and-if-formula-test-file-etaf
Sheet: Data

Age (YYMM) | FT/PT | Origina Month | Hours | First Day Worked | Last Day Worked | Days Elapse | Range | Length | AGE-Over/Under 26
55 years, 8 months | P | 1996-12-30 00:00:00 | 25 | 2023-04-17 00:00:00 | 2024-04-14 00:00:00 | 363 | 00.00 to 50.00 | Over 1 Year
18 years, 5 months | F | 1997-01-06 00:00:00 | 40 | 2023-04-17 00:00:00 | 2024-04-14 00:00:00 | 363 | 00.00 to 50.00 | Over 1 Year
43 years, 11 months | F | 2010-07-28 00:00:00 | 23 | 2023-04-17 00:00:00 | 2024-04-14 00:00:00 | 363 | 00.00 to 50.00 | Over 1 Year
25years, 3 months | F | 2012-06-28 00:00:00 | 50 | 2023-04-17 00:00:00 | 2024-04-14 00:00:00 | 363 | 00.00 to 50.00 | Over 1 Year
37 years, 10 months | P | 2016-02-29 00:00:00 | 20 | 2023-04-17 00:00:00 | 2024-04-14 00:00:00 | 363 | 00.00 to 50.00 | Over 1 Year
52years, 5 months | F | 2016-04-01 00:00:00 | 30 | 2023-04-17 00:00:00 | 2024-04-14 00:00:00 | 363 | 00.00 to 50.00 | Over 1 Year
34 years, 3 months | P | 2010-12-17 00:00:00 | 34 | 2023-04-17 00:00:00 | 2024-04-14 00:00:00 | 363 | 00.00 to 50.00 | Over 1 Year
22 years, 9 months | F | 2016-06-01 00:00:00 | 40 | 2023-04-17 00:00:00 | 2024-04-14 00:00:00 | 363 | 00.00 to 50.00 | Over 1 Year
28 years, 8 months | F | 2016-09-01 00:00:00 | 35 | 2023-04-17 00:00:00 | 2024-04-14 00:00:00 | 363 | 00.00 to 50.00 | Over 1 Year
Spreadsheet: 107424d1304599166-need-formula-for-a-macro-function-example
Sheet: 26

1403
Name | Amount
Name 2 | 153
Name 1 | 132
Name 1 | 142
Name 2 | 168
Name 2 | 102
Name 1 | 200
Name 2 | 110
Name 1 | 109
Name 2 | 114
Name 2 | 142
Name 1 | 151
Name 2 | 187
Name 2 | 161
Name 3 | 175
Name 1 | 148
Name 1 | 180
Name 3 | 107
Name 1 | 194
Name 2 | 168
Name 3 | 119
Name 2 | 122
Name 3 | 121
Name 2 | 185
Name 2 | 193
Name 1 | 147
Spreadsheet: a1504701-2a25-4bcb-9326-350f9955deb7
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
43995306 | 2014-11-12 21:29:22 | ALLIES | 1 | 7 | 5 | 366106 | [NAME] | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
43995608 | 2014-11-12 21:44:43 | AXIS | 0 | 2 | 7 | 366106 | [NAME] | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
44003295 | 2014-11-13 12:29:47 | ALLIES | 0 | 4 | 6 | 470347 | hilarion lefuneste | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
44003487 | 2014-11-13 12:57:08 | AXIS | 1 | 6 | 4 | 470347 | hilarion lefuneste | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
44009107 | 2014-11-13 21:59:35 | ALLIES | 1 | 6 | 4 | 1515794 | Bodega28 | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
44009526 | 2014-11-13 22:26:18 | AXIS | 1 | 6 | 2 | 1515794 | Bodega28 | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
44046074 | 2014-11-16 11:06:37 | ALLIES | 1 | 5 | 1 | 443634 | caty | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
44046332 | 2014-11-16 11:21:08 | AXIS | 1 | 5 | 4 | 443634 | caty | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
44096253 | 2014-11-19 21:12:26 | ALLIES | 1 | 10 | 6 | 366106 | [NAME] | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44096619 | 2014-11-19 21:42:00 | AXIS | 0 | 6 | 10 | 366106 | [NAME] | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
Spreadsheet: 719427d1613661045-sumifs-formula-not-valid-value-hh_job_-template_2021
Sheet: Bonus WK 2

 | Week 2 - Bonus Hours
 | Begin Date:
 | End Date:
 | Employee | Bonus Hours
Spreadsheet: 735401d1622961171-traffic-sign-for-kpi-book1
Sheet: Report

 | Financial Report (Yearly) |  |  |  |  | 2011
 | ABC. Inc
 | Key Performance Indicators
 | Net Income |  | Muncipal Tax |  | Service Charge |  | Other Exp |  | Income Tax |  |  |  | Net Profit
 | All Indicators
 | KPIs |  |  |  |  |  | % CHANGE
 | Net Income
 | Muncipal Tax |  | t should be red | `
 | SERvice Chrg
 | Other Exp
 | Income Tax
 | Net Profit
Spreadsheet: 124045d1318017855-formatting-box-inventory
Sheet: Crane Dust

 |  | Crane Dust Vacuum Box Inventory
Box # | Start Date | 50 Day | 70 Day | Box Location | Box Weight Empty | Material Weight | Delivered to Staging | Issues
2 | 2011-08-01 00:00:00 |  |  | Baghouse | 8890 | 1 |  | None
15 | 2011-08-01 00:00:00 |  |  |  | 9080 | 2 |  | None
16 | 2011-08-01 00:00:00 |  |  | Baghouse | 9440 | 3 |  | None
18 | 2011-08-01 00:00:00 |  |  | Baghouse | 9290 | 4 |  | None
 | Baghouse
 | Transfer Tower
 | Dedust
 | Fans
Spreadsheet: 524985d1498491505-vacation-calendar-spreadsheet-time-off-calendar-help-forum
Sheet: 2018

VACATION - 2018 |  |  |  |  |  |  |  |  |  |  | Name: |  |  | [NAME]
Start Date: |  |  |  |  |  | 2016-07-05 00:00:00 |  |  |  | Today's Date:
Total Vacation Days: |  |  |  |  |  |  |  |  |  | Total Sick Days: |  |  |  |  |  |  |  | Total STOP Time: |  |  |  |  | 8
Vacation Days Taken: |  |  |  |  |  |  |  |  |  | Paid Sick Hours Taken |  |  |  |  |  |  |  | STOP Time Taken
Remaining Vacation Days |  |  |  |  |  |  |  |  |  | Remaining Sick Days
2018 | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September |  | October |  | November |  | December
 | V/S/ST | .5 / 1 | V/S/ST | .5 / 1 | V/S/ST | .5 / 1 | V/S/ST | .5 / 1 | V/S/ST | .5 / 1 | V/S/ST | .5 / 1 | V/S/ST | .5 / 1 | V/S/ST | .5 / 1 | V/S/ST | .5 / 1 | V/S/ST | .5 / 1 | V/S/ST | .5 / 1 | V/S/ST | .5 / 1
1 | HOLIDAY
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HOLIDAY |  | HOLIDAY
25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HOLIDAY |  | HOLIDAY
26
27
28
29
30
31
TOTALS
Vacation
Sick
STOP (hrs)
Spreadsheet: 850545d1700912073-i-want-to-lookup-data-in-other-sheets-and-put-them-each-in-a-seperate-row-in-the-same-col-2023-sponsor-data-4-1-2-
Sheet: Students Secondary

Edukid ID | Student | Preferred Name | Sponsored (under fee programme) YES/NO (if yes, please do not place under half-price kiokit or law firm.) | SEND Children (put 'yes' next to SEND children) | SEND | Half Price ([NAME]/law firm etc) | School | AGE | Class | DOB | Additional Information | Image Reference | Additional Photos | What are you most excited to achieve this school year? | What are you most proud of yourself for? | Who is your role model and why? | What is your aspiration for your future? | How would you change the world if you could?
UG1234 | [NAME] | [NAME] |  |  |  |  |  | 15 | s 1 - 2023 | 21-3-2007 |  | UG1234 |  | I want to perform very well in the all exams that I am going to do in school this year because I want to work had and finish my studies. | I am most proud of my knowledge and wisdom because it is helping me in many ways. | My uncle because he always guide me | I want to become a lawyer so that I keep law and order. | I would fight for rights of all people the poor and richest equally and set strick laws aganist human rights.
UG1555 | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  | UG1555 |  | I want to join school football team because it shall keeps me motivated | Working hard because I get to be very supportive both to myself and my parents to. | The district water engineer of nwoya because he earn alot of money | An engineer | I shall provides work to my colleagues so that it can change the world
Spreadsheet: 774658d1648587217-add-new-field-based-on-looping-through-existing-data-without-vba-add-field-with-unique-value
Sheet: Sheet1

Excerpt from Existing Worksheet |  |  |  |  |  | Desired New field
CustNbr | Season | CustStatus | ItemNbr | ItemAmount |  | CustStat_Unique
1 | Fall | Current | 10000 | 10000 |  | Overdue |  | OBJECTIVE:  Create a new field (CustStat_Unique) within an existing worksheet with the value:
1 | Fall | Overdue | 10001 | 7883 |  | Overdue |  | (1) "Current" if ALL records for that customer have a CustStatus of Current, or
1 | Fall | Current | 10034 | 400 |  | Overdue |  | (2) "Overdue" if ANY record for that customer has a CustStatus of Overdue.
1 | Fall | Overdue | 10043 | 4233 |  | Overdue
1 | Fall | Current | 10044 | 3000 |  | Overdue
1 | Fall | Current | 10313 | 1000 |  | Overdue |  | (colored text and highlighting has been added only to provide clarity)
2 | Spring | Current | 10305 | 500 |  | Current
2 | Spring | Current | 10307 | 500 |  | Current
2 | Spring | Current | 50074 | 1926.65 |  | Current
2 | Fall | Current | 10313 | 750 |  | Current
3 | Spring | Overdue | 10044 | 6942 |  | Overdue
3 | Spring | Current | 10289 | 2500 |  | Overdue
3 | Spring | Current | 10306 | 750 |  | Overdue
3 | Spring | Current | 50074 | 1250 |  | Overdue
3 | Fall | Current | 10044 | 2238 |  | Overdue
3 | Fall | Current | 10063 | 2000 |  | Overdue
3 | Fall | Current | 10122 | 3400 |  | Overdue
3 | Fall | Current | 10289 | 1250 |  | Overdue
3 | Fall | Current | 10313 | 1000 |  | Overdue
3 | Fall | Current | 10315 | 1000 |  | Overdue
3 | Fall | Current | 50074 | 1500 |  | Overdue
3 | Fall | Current | 50076 | 1666.75 |  | Overdue
3 | Fall | Current | 50123 | 8383 |  | Overdue
Spreadsheet: 674384d1587810765-maximize-the-mass-yield-of-each-truck-freight-example-hydr-
Sheet: Sheet1

FREIGHT | TONS |  | A LOGICAL SOLUTION:
JOB 1 |  |  | TRUCK 1 | TRUCK 2 | TRUCK 3 | TRUCK 4 | TRUCK 5 | TRUCK 6 | TRUCK 7 | TRUCK 8 | TRUCK 9 | TRUCK 10 | TRUCK 11
JOB 2 | 3.2 |  | JOB 1 (100%) | JOB 16 (46.37%) | JOB 16 (46.37%) | JOB 16 (7.26%) | JOB 13 (79.36%) | JOB 13 (20.64%) | JOB 11 (100%) | JOB 6 (46.90%) | JOB 7 (100%) | JOB 18 (92.07%) | JOB 12 (95.60%)
JOB 3 | 4.5 |  | JOB 2 (100%) |  |  | JOB 17 (100%) |  | JOB 4 (100%) | JOB 6 (53.10%) | JOB 20 (100%) | JOB 8 (100%) | JOB 19 (100%) | JOB 15 (100%)
JOB 4 | 18 |  | JOB 3 (100%) |  |  |  |  | JOB 10 (100%) |  | JOB 9 (100%) | JOB 18 (7.93%)
JOB 5 |  |  | JOB 14 (100%) |  |  |  |  | JOB 5 (100%) |  |  | JOB 12 (4.40%)
JOB 6 | 14.5
JOB 7
JOB 8 |  |  | SIDE NOTE: OUR LOGISTICS COMPANY IS A LITTLE CARELESS, AND TENDS TO GET THE DELIVERIES MIXED UP. IT IS BEST TO KEEP THE NUMBER OF JOBS ON THE TRUCKS TO A MINIMUM…
JOB 9 |  |  | SO THE COLUMN'S MARKED IN GREEN ARE A BIT OF A PROBLEM. IT WOULD BE BEST IF WE COULD KEEP THE NUMBER OF JOB'S PER TRUCK TO LESS THAN 3. THIS HOWEVER, IS LESS
JOB 10 |  |  | IMPORTANT THAN ACHIEVING A HIGHER % YIELD (>90%). AS YOU CAN SEE, TRUCK 9 IS A PROBLEM.
JOB 11
JOB 12
JOB 13
JOB 14
JOB 15
JOB 16
JOB 17
JOB 18
JOB 19
JOB 20
TOTAL:
TRUCKS:
tons/truck | 30
percentage | 0.9
num jobs | 3
 |  |  | OPTIMIZED EXCEL SOLUTION
 |  |  | TRUCK 1 | TRUCK 2 | TRUCK 3 | TRUCK 4 | TRUCK 5 | TRUCK 6 | TRUCK 7 | TRUCK 8 | TRUCK 9 | TRUCK 10 | TRUCK 11
 | 12.6 | JOB 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 1
 | 3.2 | JOB 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |  |  | 1
 | 4.5 | JOB 3 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 1
 | 18 | JOB 4 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 |  |  | 1
 | 0.8 | JOB 5 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 1
 | 14.5 | JOB 6 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 1
 | 12.9 | JOB 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |  |  | 1
 | 11.1 | JOB 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |  |  | 1
 | 8.5 | JOB 9 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |  |  | 1
 | 1.4 | JOB 10 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 1
 | 22.3 | JOB 11 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 1
 | 15.9 | JOB 12 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 1
 | 37.8 | JOB 13 | 0 | 0.37301587 | 0.044973545 | 0 | 0 | 0 | 0 | 0.4021164 | 0.15873016 | 0 | 0.021164021 |  |  | 1
 | 9.5 | JOB 14 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 1
 | 14.8 | JOB 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 |  |  | 1
 | 64.7 | JOB 16 | 0.27047913 | 0 | 0 | 0.049459042 | 0 | 0.28593509 | 0.13910355 | 0 | 0 | 0.058732612 | 0.19629057 |  |  | 1
 | 23 | JOB 17 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |  |  | 1
 | 16.4 | JOB 18 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 1
 | 14.9 | JOB 19 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |  |  | 1
 | 12.4 | JOB 20 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 1
 |  | lowest
 |  | highest | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  | #jobs
Spreadsheet: 835501d1688633483-text-split-then-create-spilling-table-textsplit
Sheet: Feuil1

 |  |  |  |  |  |  | EXPECTED RESULT (SPILLING ARRAY)
values |  |  | values |  |  |  | value1 | value2 | value3 | value4 |  |  | value2 | value3 | value4
value1:554,value2:36,value3:987 |  |  |  |  |  |  | 554 | 36 | 987 |  |  | 554 | 36 | 987
value1:54,value2:396,value4:52 |  |  | value1:54,value2:396,value4:52 |  |  |  | 54 | 396 |  | 52 |  | 54 | 396 |  | 52
value3:594,value2:6 |  |  | value3:594,value2:6 |  |  |  |  | 6 | 594 |  |  |  | 6 | 594
 |  |  |  |  |  |  |  | value2 | value3 | value4
 |  |  |  |  |  |  | 554 | 36 | 987
 |  |  |  |  |  |  | 54 | 396 |  | 52
 |  |  |  |  |  |  |  | 6 | 594
 |  |  |  |  |  |  |  | value2 | value3 | value4
 |  |  |  |  |  |  | 554 | 36 | 987
 |  |  |  |  |  |  | 54 | 396 |  | 52
 |  |  |  |  |  |  |  | 6 | 594
Spreadsheet: 109911d1306729936-lookup-compare-and-copy-in-2-woorkbooks-match-and-copy01
Sheet: Result

 | 2 | 3 | 4 | 5 | 6
Barcode | Description | Att-1 | Att-2 | Att-3 | att-4
N/A | N/A | N/A | N/A | N/A | N/A |  | For [NAME] 'IF(AND(Data!B3=Master!B3,Data!C3=Master!C3,Data!D3=Master!D3,Data!E3=Master!E3,Data!F3=Master!F3),INDEX(Master!$A$3:$A$18,ROW(A1),1),"N/A")
N/A | N/A | N/A | N/A | N/A | N/A |  | For Description =IF(ISERROR(VLOOKUP($A3,Master!$A$3:$F$16,C$1,FALSE)),"N/A",VLOOKUP($A3,Master!$A$3:$F$16,C$1,FALSE))
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
733905615559 | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
N/A | N/A | N/A | N/A | N/A | N/A
Spreadsheet: 818155d1676625946-formula-to-sum-up-qty-each-month-by-given-date-book4-3-ans
Sheet: Sheet1

X |  |  |  |  |  |  |  |  | Y
Activity | Start | Finish | Qty |  |  |  |  |  | Month | Qty
A | 2015-01-01 00:00:00 | 2015-02-05 00:00:00 | 500 |  |  |  |  |  | 2015-01-31 00:00:00
B | 2015-05-10 00:00:00 | 2015-08-10 00:00:00 | 1000
C
D
E
F
G
H
Spreadsheet: 076096bf-f9ed-4098-9fdc-7a3abda4685d
Sheet: Bid Worksheet

Instructions: Complete YELLOW cells
1 | Determine importance of Price in overall bid and put as % in cell O:21
2 | [NAME] should match what is in RFP
3 | Determine importance of each non price criteria in relation to rank , % of total bid will auto calculate
4 | Bid Price - prices should reflect the whole life cost of the purchase where possible.  In all cases the prices entered in the template must represent a ‘like for like’ comparison between bidders.
5 | Use the following guide when ranking quality and technical criteria
 | Scoring Rationale: | 0= no submission/submission not relevant
 |  | 1= submission partially relevant but poor
 |  | 2= submission partially relevant and acceptable
 |  | 3= submission completely relevant and acceptable
 |  | 4= submission completely relevant and good
 |  | 5= submission completely relevant and exceptional
6 | For more than 4 bidders edit formula in D:35 to include the addional array and copy paste across all bidders.
 | Cost | Bidder 1 |  | [NAME] |  | Bidder 3 |  | [NAME] |  | Bidder 5 |  | Bidder 6 |  | Lowest Cost
C-1 | Bid Price | 115 |  | 120 |  | 110 |  | 122
 | % Variance |  |  |  |  |  |  |  |  |  |  |  |  | Weight as % of total
 | Rank by Price |  |  |  |  |  |  |  |  |  |  |  |  | 0.5
 | Quality and Technical |  |  |  |  |  |  |  |  |  |  |  |  | Weight (% of importance) does not have to =100% | MAX
C-2 | Spec 1 | 5 |  | 5 |  | 5 |  | 5 |  |  |  |  |  | 1
C-3 | Spec 2 | 4 |  | 4 |  | 4 |  | 5 |  |  |  |  |  | 1
[NAME] | Spec 3 | 5 |  | 5 |  | 5 |  | 5 |  |  |  |  |  | 0.75
C-5 | Spec 4 | 4 |  | 4 |  | 4 |  | 5 |  |  |  |  |  | 0.75
C-6 | Spec 5 | 5 |  | 5 |  | 5 |  | 5 |  |  |  |  |  | 0.75
C-7 | Spec 6 | 5 |  | 5 |  | 5 |  | 5 |  |  |  |  |  | 0.5
C-8 | Spec 7 | 4 |  | 4 |  | 4 |  | 5 |  |  |  |  |  | 0.5
C-9 | Spec 8 | 5 |  | 5 |  | 5 |  | 5 |  |  |  |  |  | 0.1
C-10 | Spec 9 | 5 |  | 5 |  | 5 |  | 5 |  |  |  |  |  | 0.1
 | Quality and Technical Score
 | Price (weighted score)
 | Overall Weighted Score
 | Overall Rank
Spreadsheet: 583761d1532629190-returning-names-in-ranked-order-with-ties-leaderboard
Sheet: Ranking (Display)

 | Name |  |  |  | Name
Rank | Team | Score |  | Rank | Team | Score
1 |  |  |  | 14
2 |  |  |  | 15
3 |  |  |  | 16
4 |  |  |  | 17
5 |  |  |  | 18
6 |  |  |  | 19
7 |  |  |  | 20
8 |  |  |  | 21
9 |  |  |  | 22
10 |  |  |  | 23
11 |  |  |  | 24
12 |  |  |  | 25
13
Spreadsheet: 170176d1343191855-excel-schedule-with-daily-availability-and-process-length-schedule
Sheet: Sheet1

 |  | Hours Availability for the Day
 |  | 8 | 12 | 8 | 8 | 8
Jobs | Hours | Monday | Tuesday | Wednesday | Thursday | Friday
Job 1 | 6 | 6
Job 2 | 3 | 2 | 1
Job 3 | 7 |  | 7
Job 4 | 2 |  | 2
Job 5 | 13 |  | 2 | 8 | 3
Job 6 | 5 |  |  |  | 5
Job 7 | 6 |  |  |  |  | 6
Spreadsheet: 811841d1672828227-copy-whole-rows-if-condition-is-fulfilled-example-file-hd
Sheet: Sheet1

 |  |  | Start | Starts at | End | Ends at | All-day event | Reminder on/off | Reminder on | Reminder at | Organizer | Mandatory participants | Optional participants | Ressources | Information | Description | Categories | Location | Priority | Private | Kilometers | Vertraulichkeit | Show as | Duration | Day | Month | Year | Calendar week
 |  | Appointment 1 | 2023-03-06 00:00:00 | 09:00:00 | 2023-03-06 00:00:00 | 18:00:00 | Off | On | 2023-03-06 00:00:00 | 08:45:00 | 0 | 0 | 0 | 0 | 0 | 0 | Blue | 0 | Normal | Off | 0 | Normal | 2 | 9:00:00 | Monday | March | 2023 | 10
 |  | Appointment 2 | 2023-03-06 00:00:00 | 11:00:00 | 2023-03-06 00:00:00 | 12:00:00 | Off | On | 2023-03-06 00:00:00 | 10:45:00 | 0 | 0 | 0 | 0 | 0 | 0 | Yellow | 0 | Normal | Off | 0 | Normal | 2 | 1:00:00 | Monday | March | 2023 | 10
 |  | Appointment 3 | 2023-03-07 00:00:00 | 08:30:00 | 2023-03-08 00:00:00 | 09:00:00 | Off | On | 2023-03-07 00:00:00 | 16:30:00 | 0 | 0 | 0 | 0 | 0 | 0 | Green | 0 | Normal | Off | 0 | Normal | 2 | 1 day, 0:30:00 | Tuesday | March | 2023 | 10
 |  | Appointment 3 | 2023-03-08 00:00:00 | 00:00:00 | 2023-03-08 00:00:00 | 09:00:00 | Off | On | 2023-03-07 00:00:00 | 16:30:00 | 0 | 0 | 0 | 0 | 0 | 0 | Green | 0 | Normal | Off | 0 | Normal | 2 | 1 day, 0:30:00 | Tuesday | March | 2023 | 10
 |  | Appointment 4 | 2023-03-08 00:00:00 | 08:00:00 | 2023-03-08 00:00:00 | 10:30:00 | Off | On | 2023-03-08 00:00:00 | 07:30:00 | 0 | 0 | 0 | 0 | 0 | 0 | Red | 0 | Normal | Off | 0 | Normal | 2 | 2:30:00 | Wednesday | March | 2023 | 10
 |  | Christmas | 2023-12-25 00:00:00 | 00:00:00 | 2023-12-26 00:00:00 | 00:00:00 | On | Off | 2023-12-23 00:00:00 | 14:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | White | 0 | Normal | Off | 0 | Normal | 1 | 1 day, 0:00:00 | TTT | december | 2023 | 52