tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 828492d1683554438-pull-multiple-data-table-based-on-specific-value-test-68-aligw
Sheet: DB_Info

Customer | Country | Location | Contract Type | Contract Start Date | Contract Duration | Equipment | SF Link | Training | Scheduled | CSMV Q1 | Scheduled Q1 | CSM Q2 | Scheduled Q2 | CSM Q3 | Scheduled Q3 | CSM Q4 | Scheduled Q4
Cranswick | UK | Hull | Standard | 2023-01-01 00:00:00 | 3Y | GC 60 |  | YES | 2023-03-20 00:00:00 | [NAME] | 2023-02-12 00:00:00 | PENDING | 2023-06-09 00:00:00 | PENDING |  | PENDING
Öresundschark | SE | Malmo | Pilot | 2023-01-01 00:00:00 | 1Y | GC 70 |  | NO | 2023-04-20 00:00:00 | [NAME] | 2023-03-28 00:00:00 | [NAME] | 2023-04-12 00:00:00 | PENDING |  | PENDING
Pascal Processing | NL | Helmond | Standard | 2023-03-01 00:00:00 | 3Y | HPP |  | NO | 2023-04-20 00:00:00 | N/A | 2023-03-23 00:00:00 | PENDING | 2023-05-03 00:00:00 | PENDING |  | PENDING
Moy Park [C] | UK | Craigavon | Standard | 2023-04-01 00:00:00 | 3Y | GC M7 (3) |  | NO | 2023-05-10 00:00:00 | N/A | 2023-03-21 00:00:00 | PENDING | 2023-05-09 00:00:00 | PENDING |  | PENDING
Moy Park [G] | UK | Grantham | Standard | 2023-04-01 00:00:00 | 3Y | GC M9 |  | NO | 2023-05-12 00:00:00 | N/A | 2023-03-21 00:00:00 | PENDING | 2023-05-10 00:00:00 | PENDING |  | PENDING
Salpa | IT | [NAME] | Standard | 2023-04-01 00:00:00 | 3Y | GC 60 |  | NO | 2023-05-04 00:00:00 | N/A | 2023-03-20 00:00:00 | PENDING | 2023-05-04 00:00:00 | PENDING |  | PENDING
Nowel | PL | Warsaw | Standard | 2023-06-01 00:00:00 | 3Y | GC M10 |  | NO | 2023-05-25 00:00:00 | N/A | 2023-04-01 00:00:00 | PENDING | 2023-05-25 00:00:00 | PENDING |  | PENDING
Test | DE | Berlin | Standard | 2023-01-01 00:00:00 | 3Y | GC 70 |  | YES | 2023-01-21 00:00:00 | [NAME] | 2023-01-21 00:00:00 | [NAME] | 2023-04-17 00:00:00 | PENDING |  | PENDING
Spreadsheet: 780940d1652878847-how-can-i-cycle-through-range-and-extract-text-from-rows-if-rows-contain-specific-text-example-sheet
Sheet: Sheet1

Services List | Extracted Main Service | Extracted Secondary service list for each main service
Discovery Meeting: Durlu |  |  | <- example only
Discovery Meeting: Discovery Research
Location Scouting: In Oradea
Creative Development: Creative Research |  |  | <- example only (I need to extract them without the string coming after the second ":"
Creative Development: Trends Research
Creative Development: Roadmap Creation
Production Management: Location Scouting: In Oradea
Video Production: Camera Setup: With Collaborators
Cloud Asset Management: Copying
Final Handout Message
Spreadsheet: 886668d1736763767-table-choosecols-and-filter-returns-n-a-for-deleted-data-book2-etaf
Sheet: Sheet1

 |  |  |  |  |  |  |  | 2023-01-01 00:00:00 |  | 0
 |  |  |  |  |  |  |  | 2023-01-02 00:00:00
 |  |  |  |  |  |  |  | 2023-01-03 00:00:00
 |  |  |  |  |  |  |  | 2023-01-04 00:00:00 |  | 0
 |  |  |  |  |  |  |  | 2023-01-05 00:00:00
 |  |  |  |  |  |  |  | 2023-01-06 00:00:00
 |  |  |  |  |  |  |  | 2023-01-07 00:00:00 |  | 0
 |  |  |  |  |  |  |  | 2023-01-08 00:00:00
Spreadsheet: 886214d1736249955-leave-entitlement-calculation-excel-formula
Sheet: Off day

Entitlement | 2025-01-01 00:00:00 | 2025-12-31 00:00:00 |  |  | FT | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8
 | 2025-12-31 00:00:00 |  |  |  | FT-M | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8
Emp Code | Entity | Join Date | Entitle 2025 | Off days as of 31/12 | Terminated | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total Off
T-124 | FT-M | 2018-12-11 00:00:00 |  |  | 2025-01-08 00:00:00
T-148 | FT | 2022-06-01 00:00:00
[NAME] | FT-M | 2022-06-01 00:00:00
[NAME] | FT-M | 2023-12-16 00:00:00
T-154 | FT-M | 2023-12-16 00:00:00
T-166 | FT-M | 2025-07-08 00:00:00 |  |  | 2025-11-30 00:00:00
T-168 | FT | 2024-07-25 00:00:00
T-169 | FT-M | 2024-08-01 00:00:00 |  |  | 2025-06-15 00:00:00
T-171 | FT-M | 2024-08-11 00:00:00
T-175 | FT-M | 2024-08-15 00:00:00
T-176 | FT-M | 2024-09-01 00:00:00
T-177 | FT | 2024-09-01 00:00:00
T-178 | FT-M | 2024-09-01 00:00:00
T-179 | FT-M | 2024-09-01 00:00:00 |  |  | 2025-11-18 00:00:00
T-180 | FT | 2024-09-01 00:00:00
T-181 | FT | 2024-09-01 00:00:00
T-182 | FT | 2024-09-01 00:00:00
T-183 | FT-M | 2025-09-01 00:00:00 |  |  | 2025-11-18 00:00:00
T-184 | FT-M | 2024-09-01 00:00:00
T-185 | FT-M | 2024-09-01 00:00:00
Spreadsheet: 88267d1288128728-support-renewal-formulae-assistance-support-test
Sheet: Schedule

 | Support Summary of Contracts
 | Exchange rate $1.58 to £1 as of 26/10/10
 | Product | Serial | Location | Provider | Service | Start Date | End Date | Support Level | Status | Cost £ | Cost $
 | Juniper SSG 20 HW | 0164042007000816 | London | Juniper |  | 2007-12-05 00:00:00 | 2010-10-26 00:00:00 | SVC-NDCE-SSG20 1yr |  | 87
 | Juniper SSG 20 SW | 0164042007000816 | London | Juniper |  | 2007-12-05 00:00:00 | 2009-02-24 00:00:00 | SW Subs 1yr |  | 362
 | Juniper SSG 20 HW | 0164032009000605 | Croatia | Juniper |  | 2009-04-09 00:00:00 | 2010-10-14 00:00:00 | SVC-NDCE-SSG20 1yr |  | 87
 | Juniper SSG 20 SW | 0164032009000605 | Croatia | Juniper |  | 2009-04-09 00:00:00 | 2013-08-18 00:00:00 | SW Subs 1yr |  | 362
Spreadsheet: 86092d1286110142-data-validation-define-maximum-limit-of-characters-digits-in-cell-data-validation-error
Sheet: Sheet1

1234 | 4
12345 | 5
123456 | 6 | 15443546
1234567 | 7
12345678 | 8
54656544 | 8
 | 0
154545 | 6
 | 0
9876543210 | 10
54666454 | 8
54541212 | 8
4541 | 4
245454 | 6
14547114 | 8
 | 0
 | 0 |  |  |  | 9876543210
 | 0 |  |  |  | 123
 |  |  |  |  |  |  | [NAME] | SunOffice
 |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 867368d1714197822-automatisation-of-the-consolidation-data-consolidation-aligw
Sheet: Sheet1

TTT333391100020 | 0 |  | TTT333391100020 | 0 |  |  | 0
TTT333391100020 | 0 |  | TTT333305201161 | 1 |  | TTT333305201161 | 1
TTT333391100020 | 0 |  | TTT333356301413 | 5 |  | TTT333356201678 | 3
TTT333305201161 | 0 |  | TTT333356401666 | 0 |  | TTT333356301413 | 5
TTT333305201161 | 0 |  | TTT320509101666 | 0 |  | TTT333356401666 | 0
TTT333305201161 | 1 |  | TTT333356201678 | 3 |  | TTT333391100020 | 0
TTT333305201161 | 0
TTT333305201161 | 0
TTT333305201161 | 0
TTT333305201161 | 0
TTT333305201161 | 0
TTT333305201161 | 0
TTT333305201161 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 1
TTT333356301413 | 1
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 1
TTT333356301413 | 1
TTT333356301413 | 1
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356301413 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT333356401666 | 0
TTT320509101666 | 0
TTT333356401666 | 0
TTT320509101666 | 0
TTT333356401666 | 0
TTT320509101666 | 0
TTT333356201678 | 1
TTT333356201678 | 1
TTT333356201678 | 1
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
TTT333356201678 | 0
Spreadsheet: 157885d1337900077-need-formula-for-final-test-grade-with-a-criteria-please-excel-q-1-modified-by-tigeravatar-
Sheet: SH 1

 | grade A | grade B | grade C | grade D | grade F
person 1 | 0 | 0 | 0 | 0 | 2
person 2 | 0 | 9 | 8 | 9 | 1
person 3 | 0 | 0 | 8 | 2 | 2
person 4 | 7 | 12 | 6 | 1 | 1
person 5 | 0 | 0 | 0 | 7 | 1
Spreadsheet: 160595d1339129218-excel-2007-need-help-with-using-the-date-functions-monthly-sales-tracking
Sheet: Sheet1

Date | Name | MC | Type | Value |  | Total MTD | Tracking % | Sales/Day |  | Budget
2012-06-01 00:00:00 | [NAME] | Adam | 12MDD |  |  |  |  |  |  | 135
2012-06-01 00:00:00 | [NAME] | Adam | CORPORATE
2012-06-04 00:00:00 | [NAME] | Adam | RENEWAL |  | 0.5 |  |  |  |  |  |  | Company Sales/day | Sales/day needed to hit Budget
2012-06-05 00:00:00 | [NAME] | Adam | CORPORATE |  | 1 | Sales MTD
2012-06-06 00:00:00 | [NAME] | Adam | PROMO |  |  | Sales/Day
2012-06-06 00:00:00 | [NAME] | Adam | PROMO |  | 2 | 12MDD%
2012-06-07 00:00:00 | [NAME] | Adam | 12MDD |  |  | EZDD%
2012-06-07 00:00:00 | [NAME] | Adam | PROMO |  | 2 | PROMO%
 |  |  |  |  |  | Corporate %
 |  |  |  |  |  | Renewal %
Spreadsheet: 31319d1227125465-counting-types-of-or-cases-by-month-researchrn_countcases_v1b
Sheet: Sheet7

Count of surgType
surgDate | surgType | Total
2008-04-08 00:00:00 | craniotomy | 1 |  | I created this Dynamic Named Range in this workbook:
2008-04-10 00:00:00 | transsphenoidal | 1 |  | [NAME]
2008-04-16 00:00:00 | transsphenoidal | 1
2008-04-21 00:00:00 | craniotomy | 1
2008-04-24 00:00:00 | transsphenoidal | 1
2008-05-01 00:00:00 | [NAME] | 1
2008-05-05 00:00:00 | craniotomy | 1
2008-05-12 00:00:00 | craniotomy | 1
2008-05-13 00:00:00 | craniotomy | 1
2008-05-14 00:00:00 | craniotomy | 2
2008-05-15 00:00:00 | craniotomy | 1
2008-05-16 00:00:00 | craniotomy | 1
2008-05-21 00:00:00 | craniotomy | 1
 | transsphenoidal | 1
2008-05-27 00:00:00 | craniotomy | 1
2008-05-28 00:00:00 | craniotomy | 2
2008-05-29 00:00:00 | craniotomy | 2
2008-05-30 00:00:00 | craniotomy | 1
2008-06-02 00:00:00 | craniotomy | 1
2008-06-04 00:00:00 | [NAME] | 1
 | craniotomy | 1
2008-06-05 00:00:00 | craniotomy | 1
2008-06-06 00:00:00 | craniotomy | 1
2008-06-09 00:00:00 | transsphenoidal | 1
2008-06-11 00:00:00 | transsphenoidal | 1
2008-06-12 00:00:00 | transsphenoidal | 1
2008-06-13 00:00:00 | craniotomy | 1
2008-06-16 00:00:00 | transsphenoidal | 1
2008-06-23 00:00:00 | [NAME] | 1
 | transsphenoidal | 1
2008-06-24 00:00:00 | craniotomy | 1
2008-06-25 00:00:00 | craniotomy | 1
2008-06-26 00:00:00 | transsphenoidal | 1
2008-06-30 00:00:00 | craniotomy | 2
2008-07-03 00:00:00 | transsphenoidal | 1
2008-07-07 00:00:00 | craniotomy | 1
2008-07-08 00:00:00 | craniotomy | 1
 | transsphenoidal | 1
2008-07-09 00:00:00 | craniotomy | 2
2008-07-10 00:00:00 | transsphenoidal | 1
2008-07-17 00:00:00 | transsphenoidal | 1
2008-07-24 00:00:00 | craniotomy | 1
 | transsphenoidal | 1
2008-07-29 00:00:00 | craniotomy | 1
2008-08-06 00:00:00 | craniotomy | 2
2008-08-07 00:00:00 | craniotomy | 1
2008-08-13 00:00:00 | craniotomy | 1
2008-08-15 00:00:00 | craniotomy | 1
2008-08-21 00:00:00 | craniotomy | 1
 | transsphenoidal | 1
2008-08-27 00:00:00 | craniotomy | 1
2008-09-03 00:00:00 | craniotomy | 1
2008-09-04 00:00:00 | [NAME] | 1
2008-09-08 00:00:00 | craniotomy | 1
2008-09-09 00:00:00 | craniotomy | 1
2008-09-11 00:00:00 | craniotomy | 1
2008-09-15 00:00:00 | craniotomy | 1
 | transsphenoidal | 1
2008-09-16 00:00:00 | craniotomy | 1
2008-09-22 00:00:00 | craniotomy | 1
2008-09-29 00:00:00 | transsphenoidal | 1
2008-09-30 00:00:00 | [NAME] | 1
2008-10-02 00:00:00 | transsphenoidal | 1
2008-10-06 00:00:00 | craniotomy | 1
 | transsphenoidal | 1
2008-10-08 00:00:00 | transsphenoidal | 1
2008-10-09 00:00:00 | craniotomy | 1
2008-10-10 00:00:00 | [NAME] | 1
2008-10-13 00:00:00 | craniotomy | 1
2008-10-22 00:00:00 | craniotomy | 1
2008-10-23 00:00:00 | transsphenoidal | 1
2008-10-30 00:00:00 | craniotomy | 1
2008-11-03 00:00:00 | craniotomy | 1
2008-11-06 00:00:00 | craniotomy | 1
2008-11-13 00:00:00 | craniotomy | 1
 | transsphenoidal | 1
2008-11-14 00:00:00 | [NAME] | 1
2008-11-17 00:00:00 | transsphenoidal | 1
2008-11-18 00:00:00 | transsphenoidal | 1
Grand Total |  | 85
Spreadsheet: 98586d1297440974-formatting-and-matching-gathered-information-sample-1
Sheet: Sheet3

EQUIP. NUMBER: | OS NUMBER: | P&ID NUMBER: | [NAME]: | PLANT ZONE: | LOCATION/ELEV.: | VENDOR: | MFG.: | REBUILD DATE: | MODEL# | SERIAL#: | DEPARTMENT: | COST CENTER: | CRITICALITY: | YRS. IN SERVICE: | SIZE/TYPE: | MAT. CASE: | MAT. IMPELLER: | SEAL TYPE: | SEAL SLEEVE O.D. | [NAME]. NO. | SUC.FLG SIZE/RATE | DISCH. FLG.SIZE/RATE: | DIFFERENTIAL PRESS: | SP.GR. @ P.T. | NPSHR: | Wk. on [NAME] | TAR REQ'D. | PROCESS: | IFA: | IFC: | REV. #:
14-P-001 | OS-14-01 | F-1481 | SAMPLE SYSTEM | 5 | GRADE |  | PRICE |  | SC100-75 |  | Manufacturing | 601400 |  |  | SC100-75 | 316 S.S. | 316 S.S. |  |  | 14-PM-001 | .75" NPT | .5" TUBING | 22 PSI MAXIMUM | .86 @ 60 F. |  | YES | NO | HC | 39245 | 39308
Spreadsheet: 846419d1697631606-how-to-split-a-cell-value-into-multiple-cells-split-order-into-multiple-payments-test
Sheet: Costs and Payment Terms

 |  | Payment Terms
Parent Items |  | Amount |  |  | Days for payment
 | Landed Cost | Payment 1  ( Deposit) | Payment 2 | Payment 3 (Final) | Payment 1  ( Deposit) | Payment 2 | Payment 3 (Final)
Product A | 15 | 0.2 | 0.3 | 0.5 | 0 | 50 | 15
Product B | 20 | 0.3 | 0.3 | 0.4 | 0 | 40 | 30
Product C | 30 | 0.3 | 0.3 | 0.4 | 0 | 50 | 30
Spreadsheet: 377365d1423927182-conditonal-format-book1
Sheet: Sheet1

NAME | AGE | MASCULINITY | JOB | 5
[NAME] | 36 | MALE | HR | FIT
JILL | 32 | FEMALE | IT | UNFIT
DEB | 40 | FEMALE | IT | FIT
[NAME] | 57 | MALE | HR | FIT
RHONDA | 26 | FEMALE | PRINTING | FIT
VERA | 44 | FEMALE | MAIL | UNFIT
Spreadsheet: 275471d1383530304-nested-if-statements-are-returning-false-values-cannot-find-error-in-code-fairbank-roster-summary-page
Sheet: Lists

Production/Packaging | Shift Hours | Total | Load bay | Shift times | Length
[NAME] | 12:30am | 8 | [NAME] | 6am | 10
[NAME] | 1am | 8 | Billy He | 7am | 10
[NAME] | 1:30am | 8 | [NAME] | 8am | 10
[NAME] | 2am | 8 | [NAME] | 9am | 10
[NAME] | 2:15am | 8 | Dat Le | 10am | 10
[NAME] | 2:30am | 8 | [NAME] | 11am | 10
Asif Juya | 3am | 8 | [NAME] | 12:00pm | 10
Bhagwan Toor | 3:30am | 8 | Hai Thanh Nguyen | 1:30pm | 10
[NAME] | 4am | 8 | [NAME] | 2pm | 10
[NAME] | 4:30am | 8 | [NAME] | 3pm | 10
Dat Le | 5am | 8 | [NAME]
[NAME] | 5:30am | 8 | Monsor [NAME]
[NAME] | 6am | 8 | Parvinder [NAME]
[NAME] | 6:30am | 8 | [NAME]
[NAME] | 7am | 8 | [NAME]
[NAME] | 7:30am | 8 | [NAME]
[NAME] | 8am | 8 | Simranjeet Singh
[NAME] | 8:30am | 8 | [NAME]
[NAME] | 9am | 8 | [NAME]
[NAME] | 9:30am | 8 | [NAME]
Forster Tapusini | 10am | 8 | [NAME]
Hai Thanh Nguyen | 10:30am | 8 | Upinder Kumar
[NAME] | 11am | 8
Hue Ngi (Joy) [NAME] | 11:30am | 8
Ioan ([NAME]) [NAME] | 12noon | 8
Jagdeep Singh | 12:30pm | 8
[NAME] | 1pm | 8
[NAME] | 1:30pm | 8
Jhaman (JD) Das | 2pm | 8
Jiye ([NAME]) [NAME] | 2:30pm | 8
[NAME] | 3pm | 8
[NAME] | 3:30pm | 8
[NAME] | 4pm | 8
[NAME] | 4:30pm | 8
[NAME] | 5pm | 8
Mahmood [NAME] | 5:30pm | 8
[NAME] | 6pm | 8
Monsor [NAME] | 6:30pm | 8
[NAME] | 7pm | 8
[NAME] | 7:30pm | 8
[NAME] | 8pm | 8
[NAME] | 8:30pm | 8
Parveen Kumar | 9pm | 8
Parveen Parveen | 9:30pm | 8
Parvinder [NAME] | 10pm | 8
[NAME] ([NAME]) [NAME] | 10:30pm | 8
[NAME] | 11pm | 8
Phi [NAME] | 11:30pm | 8
Pravin Pindoria | 12midnight | 8
[NAME] | ASAP
Ramanjit Dhillon
[NAME]
[NAME]
[NAME]
Sami Suresh
[NAME]
[NAME]
[NAME]
Simranjeet Singh
[NAME]
Sumit Kumar
[NAME]
[NAME]
[NAME]
Upinder Kumar
Uyen (Jenny) Le
[NAME]
[NAME]
[NAME]
Spreadsheet: 197236d1354257504-graph-next-to-items-sample
Sheet: Sheet1

 |  | Items | Revenue
 |  | Pork Belly
 |  | Wok Fried Tofu
 |  | Korean Fish
 |  | Poached Chicken
 |  | Peking Duck
 |  | Peking Duck Half
 |  | Egg Flake Noodle
 |  | [NAME]
 |  | Eye Fillet
 |  | [NAME]
 |  | Barramundi
Spreadsheet: 829840d1684482784-conditional-formatting-how-to-compare-to-bank-statements-for-inter-company-transactions-demo
Sheet: Co B

No | Date | Account | Details | Debit | Credit
103491 | 2020-10-30 00:00:00 | 1205 | Bank Transfer | 600
96375 | 2020-11-06 00:00:00 | 1205 | Bank Transfer | 700
104667 | 2020-11-19 00:00:00 | 1205 | Bank Transfer | 500
96327 | 2020-11-27 00:00:00 | 1205 | Bank Transfer | 5850
96329 | 2020-11-27 00:00:00 | 1205 | Bank Transfer | 700
96331 | 2020-11-27 00:00:00 | 1205 | Bank Transfer | 1300
96333 | 2020-11-27 00:00:00 | 1205 | Bank Transfer | 1600
96335 | 2020-11-27 00:00:00 | 1205 | Bank Transfer | 1500
96337 | 2020-12-04 00:00:00 | 1205 | Bank Transfer | 16700
96339 | 2020-12-11 00:00:00 | 1205 | Bank Transfer | 1300
96341 | 2020-12-11 00:00:00 | 1205 | Bank Transfer | 22000
96382 | 2020-12-14 00:00:00 | 1205 | Bank Transfer |  | 20000
96356 | 2020-12-18 00:00:00 | 1205 | Bank Transfer | 23266
96417 | 2020-12-18 00:00:00 | 1205 | Bank Transfer |  | 1035.42
96360 | 2020-12-22 00:00:00 | 1205 | Bank Transfer | 5000
Spreadsheet: 142037d1329594135-auto-populate-data-from-sheet-1-to-specific-places-in-multiple-other-worksheets-2012-fantasy-golf
Sheet: The Memorial

 |  | WEEK 9 THE MEMORIAL
 |  | Total Earnings |  |  |  | Rankings Through Week 9 | Total
 | [NAME] | 0 |  | 2 |  | [NAME]
 | [NAME] | 5000 |  | 1 |  | [NAME]
 | [NAME] | 0 |  | 3 |  | [NAME]
 |  | 0 |  | 4 |  | 0
 |  | 0 |  | 5 |  | 0
 |  | 0 |  | 6 |  | 0
 |  | 0 |  | 7 |  | 0
 |  | 0 |  | 8 |  | 0
 |  | 0 |  | 9 |  | 0
 |  | 0 |  | 10 |  | 0
 |  | 0 |  | 11 |  | 0
 |  | 0 |  | 12 |  | 0
 |  | 0 |  | 13 |  | 0
 |  | The Memorial |  | YTD
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 5000
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 5000
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
Spreadsheet: af9c9606-8a29-45ba-8ef0-c88e52a223b2
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
MUC | Test | MUC | Mucor, IgE | Mucor, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m. - 8 p.m., Saturday; 8 a.m. - 3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
MUC | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
MUC | Result | MUC | Mucor, IgE | Mucor, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 51932116-45da-457b-a0e9-3ab98e5e534e
Sheet: BP Training Albania

 |  | TRAINING BUDGET TEMPLATE | 1 Workshop
 |  | Training Title: | Business plan development
 |  | Country | Albania | NP Dajti
 |  | Regional BP development Lead
 |  | PROJECT STAFF PARTICIPANTS
 | Ref. | ITEM Description |  | number man/days | daily cost | Total cost
 | 1 | Honorare/Personal
 | 1.2 | Training local coordination: x days X Euro
 | 1.3 | External Trainers:  days x Euro
 | 1.4 | Translation fees:  days x  Euro | 2 | 1 | 300
 | 1.5 | Facilitation fees :  days X  Euro
 | Sub-total 1
 | Ref. | ITEM Description |  | number days | daily cost | Total cost
 | 2 | Rent of facilities & insurence
 | 2.1 | Meeting room  and equipment | in-kind
 | 2.2 | Translation cabine (  days x euro) |  | 1 | 53 | 52
 | 2.3 | Translation cabine transport |  | 1 | 100 | 100
 | 2.4 | Technician/operator |  | 1 | 50 | 50
 | Sub-total 2
 | Ref. | ITEM Description |  |  |  | Total cost
 | 3 | Travel costs
 |  | Local travel cost for regional project coordinator |  | 1 | 350 | 350
 |  | Local travel cost for regional BP lead |  | 1 | 350 | 350
 | 3.1 | Local travel costs for participants (20 particpants) | in-kind | 0 | 0 | 0
 | 3.2 | International travel costs lecturers: (Nº  lectures x [NAME] ) |  | 0 | 0 | 1300
 | 3.3 | Travel costs translater: Nº translater x Euro |  | 0 | 0 | 0
 | 3.4 | Local transport ( part x  Euro public transport) |  | 0 | 0 | 0
 | 3.5 | Local transport (Nº lecture + Nº translater x  Euro public transport) |  | 0 | 0 | 0
 | Sub-total 3
 | Ref. | ITEM Description | number participants |  |  | Total cost
 | 4 | Board and Lodging
 |  | Regional project coordinator |  | 2 | 50 | 100
 |  | Regional BP lead |  | 2 | 50 | 100
 | 4.1 | External Trainers: Nº person x Nº days x  Euro |  | 2 | 50 | 100
 | 4.2 | Participants: Nº participants x  days x  Euro | 25 | 1 | 50
 |  | Participants not sleeping in the hotel |  | 0 | 0 | 0
 | 4.3 | [NAME]:  days x  Euro
 | Sub-total 4
 | Ref. | ITEM Description |  | Number items | cost | Total cost
 | 7 | Printing
 | 7.1 | Documentation: Nº pax x  Euro
 | 7.2 | Certificates: Nº0 x  Euro
 | Sub-total 6
 | GRAND TOTAL
Spreadsheet: 116371d1311785527-new-thread-for-countifs-to-2003-format-vbax-1-
Sheet: Data

3
 | 2007
 | 1 | 1 | 2007
 | 1 | 1 | 2007
 | 1 | 1 | 2007
 | 0 | 0 | 2007
 | 0 | 1 | 2007
 | 1 | 1 | 2008
 | 1 | 1 | 2008
 | 1 | 0 | 2008
 | 0 | 0 | 2008
 | 0 | 1 | 2008
Spreadsheet: 871272d1717661235-returning-a-value-where-a-condition-ends-get-last-header-in-block-ans
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Expected values:
 | Header | Input | Block # |  | End of Block |  | Block # | [NAME] | [NAME] | Col. Start | Col. End | No. Cols.
 | Image |  |  |  |  |  | 2 | P&D status | Style | 7 | 18 | 12
 | Team Freeze | Y | 1 |  |  |  | 3 | Class |  | 20 | 20 | 1
 | [NAME] | Y |  |  |  |  | 4 | Code Sub-class |  | 22 | 22 | 1
 | Hits released | Y
 | Total Hits
 | P&D status | Y | 2
 | Sourcing status | Y
 | Merchant status | Y
 | Planning status | Y
 | General comments | Y
 | P&D comments | Y
 | Sourcing comments | Y
 | Merchant comments | Y
 | Planning comments | Y
 | Alloc. comments | Y
 | USIM | Y
 | Style | Y
 | Colour
 | Class | Y | 3
 | Class helper
 | Code Sub-class | Y | 4
 | Code
 | Class code