tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 168080d1342208092-excel-2007-help-pay-scale-calculation-sheet-help-hourly-timesheet-7-12-12_singerj6
Sheet: Hourly Timesheet

 |  |  | DATE:
Employee Name:
 |  |  |  |  |  | Daily Timesheet
Date | Time | Hours | Job # | Class | Pay Rate | Total Pay
 | 07:00:00
 | 07:05:00 |  | 1254 | ELEC
 | 08:05:00 |  | 1255 | A/C M
 | 09:05:00 |  | 1252 | INSUL
 | 10:30:00 |  | 1255 | ELEC T
 | 13:30:00 |  | 1252 | A/C SRVC
 | 16:00:00 |  | 1252 | A/C SRVC H
 |  |  | 1252 | ELEC T
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
 |  |  | 1252 | ELEC
Current Jobs |  |  | Job Classes | CODE | [NAME]
 | 1252
 | 1254 |  |  | A/C M | A/C MECHANIC
 | 1255 |  |  | A/C M H | A/C MECHANIC HELPER
 | 1257 |  |  | A/C SRVC | A/C SERVICE MAN
 | 1279 |  |  | A/C SRVC H | A/C SERVICE MAN HELPER
 | 1280 |  |  | CRPT | CARPENTER
 |  |  |  | ELEC | ELECTRICIAN
 |  |  |  | ELEC T | ELECTRICIAN TECHNICIAN
 |  |  |  | INSUL | ASBESTOS / INSULATION WORKER
 |  |  |  | IRON WRKR | IRON WORKER
 |  |  |  | LAB | LABORER
 |  |  |  | LAB S | LABORER SKILLED
 |  |  |  | LAB UN-S | LABORER UN-SKILLED
 |  |  |  | PLMB-PFTR | PLUMBER-PIPEFITTER (INCL. HVAC)
 |  |  |  | PLMB-PFTR H | PLUMBER-PIPEFITTER HELPER (INCL. HVAC)
 |  |  |  | SMW | SHEET METAL WORKER
 |  |  |  | SMW DUCT | SHEET METAL WORKER (DUCT)
 |  |  |  | SMW DUCT H | SHEET METAL WORKER (DUCT) HELPER
 |  |  |  | SMW OTHER | SHEET METAL WORKER (OTHER)
 |  |  |  | SMW ROOF | SHEET METAL WORKER (ROOF)
 |  |  |  | SMW ROOF H | SHEET METAL WORKER (ROOF) HELPER
Spreadsheet: 855427d1704988737-derive-a-formula-without-calculating-multiple-countifs-wfh_o-ratio
Sheet: Sheet1

 | Nick
 | Jon
January | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We
Nick | PH | O | O | O | O |  |  | O | S | O | O | O |  |  | O | O | O | O | O |  |  | O | O | O | O | O |  |  | O | O | O
Jon |  | H | O | O | O |  |  | O | O | O | O | O |  |  | O | O | O | O | O |  |  | O | O | O | O | O |  |  | O | O | O
February | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29
 | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th
Nick | O | O |  |  | O | O | O | O | O |  |  | O | L | L | L | L |  |  | O | O | O | O | O |  |  | O | O | O | O
Jon
March | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su
Nick
Jon
April | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
 | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME] | We | Th | Fr | Sa | Su | Mo | [NAME]
Nick
Jon
Spreadsheet: 747257d1631311055-quantity-needed-to-get-to-a-specific-number-2nd-pt-rotor-gap-calculator-concept
Sheet: Sheet1

2nd PT Circumferential check |  |  |  |  |  |  |  | SAMPLE of what I would like this chart to look like |  |  |  |  |  |  | All possible dimensions of blades
 |  |  |  |  |  |  |  | Blades required to close gap
Blade # | A | B | Deviation from nominal (A blade) | Deviation from nominal (B blade) | Combined Circumference | ESTIMATED GAP |  | New A blades | New B blades | Est gap with new | Used A blades | Used B blades | Est gap with used |  | New A | New B | Used A | Used B
1 | 0.673 | 0.649 |  |  |  |  |  | 0.683 | 0.653 |  | 0.68 | 0.653 |  |  | 0.683 | 0.653 | 0.674 | 0.644
2 | 0.676 | 0.651 |  |  |  |  |  | 0.683 | 0.651 | Total new A&B | 0.68 | 0.651 | Total Used A&B |  |  |  | 0.675 | 0.645
3 | 0.679 | 0.651 |  |  |  |  |  | 0.679 | 0.651 |  | 0.679 | 0.651 |  |  |  |  | 0.676 | 0.646
4 | 0.679 | 0.651 |  |  |  |  |  | 0.679 | 0.651 | 4 | 0.679 | 0.651 | 8 |  |  |  | 0.677 | 0.647
5 | 0.679 | 0.649 |  |  |  |  |  | 0.679 | 0.649 |  | 0.679 | 0.65 |  |  |  |  | 0.678 | 0.648
6 | 0.676 | 0.649 |  |  |  |  |  | 0.676 | 0.649 |  | 0.679 | 0.65 |  |  |  |  | 0.679 | 0.649
7 | 0.679 | 0.651 |  |  |  |  |  | 0.679 | 0.651 |  | 0.679 | 0.651 |  |  |  |  | 0.68 | 0.65
8 | 0.679 | 0.651 |  |  |  |  |  | 0.679 | 0.651 |  | 0.679 | 0.651 |  |  |  |  | 0.681 | 0.651
9 | 0.679 | 0.651 |  |  |  |  |  | 0.679 | 0.651 |  | 0.679 | 0.651 |  |  |  |  | 0.682 | 0.652
10 | 0.679 | 0.651 |  |  |  |  |  | 0.679 | 0.651 |  | 0.679 | 0.651
11 | 0.676 | 0.651 |  |  |  |  |  | 0.676 | 0.651 |  | 0.679 | 0.651
12 | 0.68 | 0.651 |  |  |  |  |  | 0.68 | 0.651 |  | 0.68 | 0.651
13 | 0.679 | 0.651 |  |  |  |  |  | 0.679 | 0.651 |  | 0.679 | 0.651
14 | 0.68 | 0.652 |  |  |  |  |  | 0.68 | 0.652 |  | 0.68 | 0.652
15 | 0.679 | 0.651 |  |  |  |  |  | 0.679 | 0.651 |  | 0.679 | 0.651
16 | 0.679 | 0.649 |  |  |  |  |  | 0.679 | 0.649 |  | 0.679 | 0.649
17 | 0.6785 | 0.65 |  |  |  |  |  | 0.6785 | 0.65 |  | 0.6785 | 0.65
18 | 0.679 | 0.65 |  |  |  |  |  | 0.679 | 0.65 |  | 0.679 | 0.65
19 | 0.681 | 0.6505 |  |  |  |  |  | 0.681 | 0.6505 |  | 0.681 | 0.6505
20 | 0.679 | 0.652 |  |  |  |  |  | 0.679 | 0.652 |  | 0.679 | 0.652
21 | 0.679 | 0.652 |  |  |  |  |  | 0.679 | 0.652 |  | 0.679 | 0.652
22 | 0.68 | 0.65 |  |  |  |  |  | 0.68 | 0.65 |  | 0.68 | 0.65
23 | 0.68 | 0.65 |  |  |  |  |  | 0.68 | 0.65 |  | 0.68 | 0.65
24 | 0.68 | 0.652 |  |  |  |  |  | 0.68 | 0.652 |  | 0.68 | 0.652
25 | 0.68 | 0.651 |  |  |  |  |  | 0.68 | 0.651 |  | 0.68 | 0.651
26 | 0.679 | 0.651 |  |  |  |  |  | 0.679 | 0.651 |  | 0.679 | 0.651
27 | 0.679 | 0.651 |  |  |  |  |  | 0.679 | 0.651 |  | 0.679 | 0.651
28 | 0.679 | 0.651 |  |  |  |  |  | 0.679 | 0.651 |  | 0.679 | 0.651
29 | 0.679 | 0.652 |  |  |  |  |  | 0.679 | 0.652 |  | 0.679 | 0.652
30 | 0.6785 | 0.6505 |  |  |  |  |  | 0.6785 | 0.653 |  | 0.6785 | 0.651
31 | 0.679 | 0.6505 |  |  |  |  |  | 0.679 | 0.6505 |  | 0.679 | 0.6505
 | TOTAL GAP TO CLOSE |  |  |  |  |  |  | Combined Circumfrence |  |  | Combined Circumfrence
Spreadsheet: 003cb88b-50d1-46b2-b1fe-31524b1bb45a
Sheet: +55 WS qualification 

BWF World Senior Championships 2013
WS 55-Qualification |  | Redrawn on 02nd September 2013
Badminton Tournament Planner - bwf.tournamentsoftware.com
WS 55 - Group A
 | Member ID | St. | Cnty | Flag |  | 1 | 2 | 3
1 | 964 |  | GER |  | [NAME] [1] |  | R2 | R3
2 | 96678 |  | FRA |  | [NAME] | R2 |  | R1
3 | 57497 |  | JPN |  | [NAME] | R3 | R1
 | Standings | Pts | Pl. |  | Games |  |  | Points
1 | [NAME] | 0 | 0 | 0 | - | 0 | 0 | - | 0
1 | [NAME] | 0 | 0 | 0 | - | 0 | 0 | - | 0
1 | [NAME] | 0 | 0 | 0 | - | 0 | 0 | - | 0
WS 55 - Group B
 | Member ID | St. | Cnty | Flag |  | 1 | 2 | 3 | 4
1 | 189 |  | SCO |  | [NAME] [2] |  | R2 | R3 | R1
2 | 68951 |  | SUI |  | [NAME] | R2 |  | R1 | R3
3 | 73210 |  | GER |  | [NAME] | R3 | R1 |  | R2
4 | 65941 |  | FRA |  | Marie-Odile Puype | R1 | R3 | R2
 | Standings | Pts | Pl. |  | Games |  |  | Points
1 | [NAME] | 0 | 0 | 0 | - | 0 | 0 | - | 0
1 | [NAME] | 0 | 0 | 0 | - | 0 | 0 | - | 0
1 | [NAME] | 0 | 0 | 0 | - | 0 | 0 | - | 0
1 | Marie-Odile Puype | 0 | 0 | 0 | - | 0 | 0 | - | 0
WS 55 - Group C
 | Member ID | St. | Cnty | Flag |  | 1 | 2 | 3 | 4
1 | 96318 |  | ENG |  | [NAME] |  | R2 | R3 | R1
2 | 78709 |  | FRA |  | Chantal Kielbasa | R2 |  | R1 | R3
3 | 71535 |  | IND |  | [NAME] | R3 | R1 |  | R2
4 | 70330 |  | RUS |  | [NAME] | R1 | R3 | R2
 | Standings | Pts | Pl. |  | Games |  |  | Points
1 | [NAME] | 0 | 0 | 0 | - | 0 | 0 | - | 0
1 | Chantal Kielbasa | 0 | 0 | 0 | - | 0 | 0 | - | 0
1 | [NAME] | 0 | 0 | 0 | - | 0 | 0 | - | 0
1 | [NAME] | 0 | 0 | 0 | - | 0 | 0 | - | 0
WS 55 - Group D
 | Member ID | St. | Cnty | Flag |  | 1 | 2 | 3 | 4
1 | 78460 |  | FRA |  | Brigitte Avril |  | R2 | R3 | R1
2 | 87604 |  | IND |  | [NAME] | R2 |  | R1 | R3
3 | 66338 |  | RUS |  | [NAME] | R3 | R1 |  | R2
4 | 68889 |  | AUT |  | [NAME] | R1 | R3 | R2
 | Standings | Pts | Pl. |  | Games |  |  | Points
1 | Brigitte Avril | 0 | 0 | 0 | - | 0 | 0 | - | 0
1 | [NAME] | 0 | 0 | 0 | - | 0 | 0 | - | 0
1 | [NAME] | 0 | 0 | 0 | - | 0 | 0 | - | 0
1 | [NAME] | 0 | 0 | 0 | - | 0 | 0 | - | 0
Spreadsheet: 81180d1281443935-copy-text-from-one-sheet-to-another-using-macro-request-form-template2
Sheet: March

 |  |  |  | Date | 2010-08-10 12:26:51 |  |  | March Total Hours
 |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | Percentage
 | Year | Month | Date | Hours | Total Hours |  |  | Total Hours |  |  | 248 | 100
 | 2011 | March | 2011-03-01 00:00:00 | 0 | 0 |  |  | Total Hours Requested |  |  | 0 | 0
 |  |  | 2011-03-02 00:00:00 | 0 |  |  |  | Hours Not Requested |  |  | 248 | 100 |  | Key
 |  |  | 2011-03-03 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  | Hours Requested
 |  |  | 2011-03-04 00:00:00 | 0 |  |  |  |  |  |  |  |  |  |  | Left Over Hours
 |  |  | 2011-03-05 00:00:00 | 0
 |  |  | 2011-03-06 00:00:00 | 0
 |  |  | 2011-03-07 00:00:00 | 0
 |  |  | 2011-03-08 00:00:00 | 0
 |  |  | 2011-03-09 00:00:00 | 0
 |  |  | 2011-03-10 00:00:00 | 0
 |  |  | 2011-03-11 00:00:00 | 0
 |  |  | 2011-03-12 00:00:00 | 0
 |  |  | 2011-03-13 00:00:00 | 0
 |  |  | 2011-03-14 00:00:00 | 0
 |  |  | 2011-03-15 00:00:00 | 0
 |  |  | 2011-03-16 00:00:00 | 0
 |  |  | 2011-03-17 00:00:00 | 0
 |  |  | 2011-03-18 00:00:00 | 0
 |  |  | 2011-03-19 00:00:00 | 0
 |  |  | 2011-03-20 00:00:00 | 0
 |  |  | 2011-03-21 00:00:00 | 0
 |  |  | 2011-03-22 00:00:00 | 0
 |  |  | 2011-03-23 00:00:00 | 0
 |  |  | 2011-03-24 00:00:00 | 0
 |  |  | 2011-03-25 00:00:00 | 0
 |  |  | 2011-03-26 00:00:00 | 0
 |  |  | 2011-03-27 00:00:00 | 0
 |  |  | 2011-03-28 00:00:00 | 0
 |  |  | 2011-03-29 00:00:00 | 0
 |  |  | 2011-03-30 00:00:00 | 0
 |  |  | 2011-03-31 00:00:00 | 0
Spreadsheet: 184260d1349195289-need-to-get-same-length-series-of-numbers-from-different-columns-in-the-same-cell-numbers
Sheet: Sheet1

Needed results 1 | Needed results 2
[PHONE] [PHONE] | 9998766567876 | 7409998765 | 9998766 | 9998766 | 7409998766 | 9998766 | 9998766567876 | 9998766 | 9998766 | 9998766 | 9998766 | 9998766 | 9998766 | 9998766 | 9998766 | 9998766 | 9998766 | 9998766 | 9998766 | 9998766 | 9998766 | 9998766 | 9998766 | 9998766 | 9998766 | 9998766 | 9998766 | 9998766 | 9998766 | 9998766 | 9998766 | 9998766 | 9998766 | 9998766
….. | ….. | … | …. | ….
Spreadsheet: 816555d1675697025-extract-learners-from-one-column-and-paste-individual-learner-along-with-the-course-s666-pq-extract-learners-from-one-column-and-paste-individual-learner-along-with-the-course
Sheet: Course Offerings 

Course | Learners
Course #1 | [NAME], TBD Manager
Course #2 | [NAME], TBD Functional Admin, TBD Manager
Course #3 | [NAME], TBD Manager
Course #4 | [NAME], [NAME], [NAME], TBD Manager
Course #5 | TBD Manager, [NAME]
Course #6 | [NAME], TBD Manager
Course #7 | [NAME], [NAME], [NAME], TBD Manager
Course #8 | TBD Functional Admin
Course #9 | [NAME], TBD Manager
Course #10 | [NAME], TBD Manager
Course #11 | [NAME], TBD Functional Admin, TBD Manager
Course #12 | [NAME], TBD Manager
Course #13 | [NAME], TBD Functional Admin, TBD Manager
Course #14 | [NAME], [NAME], [NAME], TBD Manager
Course #15 | TBD Manager, [NAME]
Course #16 | [NAME], TBD Manager
Course #17 | [NAME], [NAME], [NAME], TBD Manager
Course #18 | [NAME], TBD Functional Admin, TBD Manager
Course #19 | TBD Functional Admin
Course #20 | [NAME]
Course #21 | [NAME], [NAME], [NAME], [NAME], [NAME], [NAME]
Course #22 | TBD Functional Admin
Course #23 | [NAME]
Course #24 | [NAME], [NAME], [NAME], [NAME]
Course #25 | TBD Functional Admin
Course #26 | TBD Functional Admin
Course #27 | [NAME], [NAME]
Course #28 | [NAME], [NAME], [NAME], [NAME], [NAME], [NAME], [NAME]
Course #29 | TBD Functional Admin
Course #30 | Trinity [NAME]
Course #31 | [NAME], Amanda Green, [NAME], [NAME], Trinity [NAME], [NAME], [NAME]
Course #32 | [NAME], Trinity [NAME], [NAME], [NAME], [NAME], [NAME], [NAME]
Course #33 | [NAME], Amanda Green, [NAME], [NAME], Trinity [NAME], [NAME], [NAME], [NAME], [NAME], [NAME], [NAME], [NAME], [NAME], [NAME], [NAME], [NAME], [NAME], [NAME], [NAME], [NAME], [NAME], [NAME], [NAME], [NAME]
Course #34 | [NAME], [NAME], [NAME], TBD Manager
Course #35 | [NAME], TBD Manager
Course #36 | [NAME], [NAME], [NAME], TBD Manager
Spreadsheet: 6595fa9e-bb7f-4022-a665-4ba7cde1e645
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
UNIVERSIDAD TECNOLÓGICA DE LA HUASTECA HIDALGUENSE
ORGANISMO PÚBLICO DESCENTRALIZADO DEL GOBIERNO DEL ESTADO
 | DISTRIBUCIÓN DE CARGA ACADÉMICA
HORA | LUNES | MARTES | MIERCOLES | [NAME] | VIERNES
7:30-8:00 | Matemáticas Financieras | [NAME] | DHP III-C | Matemáticas Financieras | [NAME]
8:00-8:30 | Matemáticas Financieras | [NAME] | DHP III-C | Matemáticas Financieras | [NAME]
8:30-9:00 | Matemáticas Financieras | [NAME] | DHP III-C | Tutorías | [NAME]
9:00-9:30 | Matemáticas Financieras | [NAME] | DHP III-C | Tutorías | [NAME]
9:30-10:00 | Análisis e Interp.de Estados Financieros | Calidad | [NAME] | Tutorías | [NAME]
10:00-10:30 | Análisis e Interp.de Estados Financieros | Calidad | [NAME] | Tutorías | [NAME]
10:30-11:00 | R  E  C  E  S  O
11:00-12:00 | Inglés III | Inglés III | Inglés III | Inglés III | [NAME] Fiscal
12:00-13:00 | [NAME] | Matemáticas Financieras | [NAME] Fiscal | Análisis e Interp.de Estados Financieros | [NAME] Fiscal
13:00-14:00 | [NAME] | Matemáticas Financieras | [NAME] Fiscal | Análisis e Interp.de Estados Financieros | Calidad
14:00-15:00 | [NAME] | Análisis e Interp.de Estados Financieros | [NAME] | [NAME] I | Calidad
15:00-16:00 | [NAME] | Análisis e Interp.de Estados Financieros | [NAME] | [NAME] I
16:00-17:00
PERIODO: | MAYO-AGOSTO 2012 |  |  | GRUPO: | A
[NAME]: | CONTADURIA |  |  | GRADO: | TERCERO
 |  |  |  | SALÓN : | K 7
MATERIA |  | HORAS/SEMANA |  | PROFESOR
Matemáticas Financieras |  | 5 |  | Ing. [NAME]
[NAME] |  | 4 |  | L.C. Felicitas Hernández Hernández
[NAME] |  | 6 |  | [NAME]
[NAME] Fiscal |  | 4 |  | L.C. Cecilia [NAME]
[NAME] I |  | 2 |  | [NAME] Nelly [NAME]
Análisis e Int. de Edos. Financ. |  | 5 |  | [NAME]
Calidad |  | 3 |  | [NAME]
Inglés III |  | 4 |  | [NAME]. [NAME]
[NAME] |  | 2 |  | LAE. [NAME] Flores
DHP III-C |  | 2 |  | LAE. [NAME] Flores
Tutorías |  | 2 |  | [NAME]
 | TOTAL: | 39
Elaboró |  | Revisó |  | Vo. Bo.
________________________ |  | _____________________________ |  | _____________________
[NAME] |  | MAD. Marisol Flores Contreras |  | M.A. Alberto Escamilla Vital
[NAME] |  | [NAME] Académico |  | Rector
HUEJUTLA DE REYES, HGO., [NAME]  2012
Spreadsheet: 884602d1733834982-report-number-of-instances-in-another-sheet-based-on-variable-conditions-tool-order-tracking-development
Sheet: Front

 | Spend | Date From | Date To |  | Name | Tool Type | Quantity
 |  | 2023-09-09 00:00:00 | 2024-12-03 00:00:00 |  | User1 | Socket Set |  | <- Cell H2 to show the number of instances of the tool type given in Cell G2, that appear in the relevant sheet to the name given in Cell F2, within the date range provided in cells C2 and D2. for example, if C2 = 09/09/2023, D2=03/12/2024, F2="User1" and G2="Socket Set" then H2 should return "1". If [NAME] is changed to "10/12/2024" H2 should then return "2".
User 1
User 2
User 3
User 4
User 5
User 6
User 7
User 8
User 9 |  |  |  |  |  |  |  | The list in Cell F2 is generated fron Column A
User 10
User 11 |  |  |  |  |  |  |  | The List in Cell D2 is generated from data in Sheet "Reference!" to allow for list expansion.
User 12
User 13 |  |  |  |  |  |  |  | In Column A, each User is hyperlinked to an induvidual record sheet of the same name.
User 14
User 15
User 16 |  |  |  |  |  |  |  | In each of the "user" sheets cell A1 is linked back to this sheet, for ease of navigation
User 17
User 18
User 19
User 20 |  |  |  |  |  |  |  | Some additional notes can be seen in Sheet "User1!"
User 21
User 22
User 23
User 24
User 25
User 26
User 27
User 28
User 29
User 30
Total
Spreadsheet: 31064d1226783777-calculating-formula-not-working-properly-dif-formula-book-1
Sheet: FoodList

Food List | serv size | calories | fat | sat fat | carbs | sugar | fiber | protein | sodium | calcium | chol
8th ff 1 cup | 1 | 60 | 0 | 0 | 8 | 7 | 0 | 7
broth, beef (college inn) 1 cup | 1 | 25 | 1 | 0 | 0 | 0 | 0 | 4 | 900 | 20 | 0
broth, beef (college inn) 8 oz | 8 | 25 | 1 | 0 | 0 | 0 | 0 | 4 | 900 | 20 | 0
carrots - raw (ounces) | 2.5 | 24 | 0.13 |  | 7.19 |  | 2.13 | 0.73
egg - 1 large whole raw (usda sr21) | 1 | 80 | 5.57 | 1.735 | 0.43 | 0.43 | 0 | 7.04 | 78 | 30 | 237
egg substitute (as per usda sr21)  (tablespoon) | 1 | 13 | 0.53 | 0.105 | 0.1 | 0.1 | 0 | 1.92 | 28 | 8 | 0
egg white | 1 | 17 | 0 | 0 | 0.35 | 0 | 0 | 3.58 | 55 | 2 | 0
egg yollk - 1 large (usda sr21) | 1 | 54 | 4.51 | 1.624 | 0.43 | 0.1 | 0 | 2.7 | 8 | 22 | 210
[NAME] all purpose enriched, unbleached (cup) | 1 | 455 | 1.23 | 0.194 | 95.39 | 0.34 | 3.4 | 12.91
[NAME] all purpose enriched, unbleached (grams) | 100 | 364 | 0.98 | 0.155 | 76.31 | 0.27 | 2.7 | 10.33
[NAME] lean (raw)  grams | 100 | 176 | 10 | 4.058 | 0 | 0 | 0 | 20
[NAME] lean (raw) grams | 100 | 137 | 5 | 2.25 | 0 | 0 | 0 | 21.41
[NAME], Raw - as per USDA sr21 (grams) | 100 | 149 | 8.26 | 2.25 | 0 | 0 | 0 | 17.46 | 94 | 13 | 79
[NAME], Raw - 4 oz patty (edible portion 114 grams) USDA SR21 | 4 | 170 | 9.42 | 2.256 | 0 | 0 | 0 | 19.9 | 107 | 15 | 90
[NAME], cooked - 4oz after cooking as per USDA SR21 (edible portion 82 grams) | 4 | 193 | 10.78 | 2.78 | 0 | 0 | 0 | 22.44 | 88 | 21 | 84
[NAME], cooked - from 1 # (edible portion = 330 gr.) USDA SR21 | 16 | 776 | 43.4 | 11.187 | 0 | 0 | 0 | 27.36 | 107 | 25 | 102
skim milk - 8oz | 8 | 90 | 0 | 0 | 11 | 11 | 0 | 8
[NAME] | 1 | 96 | 0 | 0 | 24 | 0 | 0 | 0
sugar - 1 cup | 1 | 774 | 0 | 0 | 199.96 | 199.82 | 0 | 0
sugar - 1 tsp | 1 | 16 | 0 | 0 | 4.2 | 4.2 | 0 | 0
Onion, raw  (1 c. chopped) usda sr21 | 1 | 64 | 0.16 | 0.067 | 14.94 | 6.78 | 2.7 | 1.76 | 6 | 37 | 0
Onion, raw 100 grams (usda sr21) | 100 | 40 | 0.1 | 0.042 | 9.34 | 4.24 | 1.7 | 1.1 | 4 | 23 | 0
Spreadsheet: 163990d1340592599-count-number-of-repeat-stays-repeat2-1-
Sheet: Sheet2

MEMBERSHIP_NO. | MEMBERSHIP_LEVEL | RESORT | DEPARTURE_DATE
5866 | GOLD | BKK | 2010-08-08 00:00:00
1292 | GOLD | BKK | 2010-08-01 00:00:00
5623 | BLACK | MNL
3235 | PLATINUM | PVG
1231 | GOLD | BKK
3232 | RED | DPS
2235 | BLACK | CGK
1289 | PLATINUM | MNL
3265 | GOLD | MNL
3235 | RED | BKK
1231 | BLACK | MNL
3265 | PLATINUM | PVG
3235 | GOLD | DPS
1231 | RED | CGK
Spreadsheet: 200802d1355770483-look-up-matching-dates-in-one-column-and-then-add-the-corresponding-points-in-next-column-point-sheet-1-
Sheet: Sheet1

date | points
2015-12-12 00:00:00 | 20 |  | Row Labels | Sum of points
2015-12-12 00:00:00 | 7 |  | 2015-12-10 00:00:00 | 5
2015-12-11 00:00:00 | 24 |  | 2015-12-11 00:00:00 | 59
2015-12-11 00:00:00 | 13 |  | 2015-12-12 00:00:00 | 40
2015-12-11 00:00:00 | 16 |  | Grand Total | 104
2015-12-11 00:00:00 | 6
2015-12-12 00:00:00 | 13
2015-12-10 00:00:00 | 5
Spreadsheet: de259111-ab55-46df-8270-bc3ac423d296
Sheet: Sheet1

Campus | Last Name | First Name | [NAME] | Phone Number | Fax Number | Street | Street2 | City | State | Zip
Appalachian State University | Maxey | Maranda | [EMAIL] | [PHONE] | [PHONE] | Anne Belk Hall |  | Boone | NC | 28608
East Carolina University | Johnston | [NAME] | [EMAIL] | [PHONE] |  | East Fifth Street |  | Greenville | NC | 27858
Elizabeth City State University | [NAME] | Felecia | [EMAIL] | [PHONE] | [PHONE] | 1704 Weeksville Road |  | Elizabeth City | NC | 27909
Fayetteville State University |  |  |  |  |  | 1200 Murchison Road |  | Fayetteville | NC | 28301
NC Agricultural and Technical State University | Oliphant | Peggy | [EMAIL] | [PHONE]-2901 | [PHONE] | 1601 East Market Street |  | Greensboro | NC | 27411
North Carolina Central University | [NAME] | Kesha | [EMAIL] | [PHONE] | [PHONE] | 1801 Fayetteville Street |  | [NAME] | NC | 27707
NC State University | Vacant |  |  | [PHONE] |  | Student Health Services Center 1900 | Box 7509 | Raleigh | NC | 27695-7509
UNC Asheville | Kaufman | [NAME] | [EMAIL] | [PHONE] |  | 1 University Heights |  | Asheville | NC | 28804
UNC-Chapel Hill | [NAME] | [NAME] | [EMAIL] | [PHONE] |  | 2126 Student Academic Services Building  North | [NAME] | Chapel Hill | NC | 27514-1015
UNC Charlotte |  |  |  |  |  | 9201 University City Boulevard |  | Charlotte | NC | 28223
UNC Greensboro | Pomeroy | [NAME] | [EMAIL] | [PHONE] | [PHONE] | Post Office Box 26170 |  | Greensboro | NC | 27402
UNC Pembroke | Walker | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1 University Drive |  | Pembroke | NC | 28372
[NAME] | Turner | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 601 South College Road |  | [NAME] | NC | 28403
UNC School of the Arts | [NAME] | [NAME] | [EMAIL] | [PHONE] |  | 1533 S. Main Street |  | Winston-Salem | NC | 27127
Western Carolina University |  |  |  |  |  |  |  | Cullowhee | NC | 28723
Winston-Salem State University | Waddell | [NAME] | [EMAIL] | [PHONE] |  | 601 [NAME], Jr. Drive |  | Winston-Salem | NC | 27110
North Carolina School of Science and Mathematics |  |  |  |  |  | 1219 Broad Street |  | [NAME] | NC | 27705
Spreadsheet: 262812d1378294806-lookup-multiple-rows-where-2-conditions-must-be-met-dgt1
Sheet: Data

ID | Team | Date
7264 | A | 2013-07-16 00:00:00
6904 | A | 2013-07-18 00:00:00
7389 | A | 2013-08-05 00:00:00
7295 | C | 2013-08-12 00:00:00
7517 | A | 2013-08-16 00:00:00
7518 | A | 2013-08-16 00:00:00
7587 | A | 2013-08-16 00:00:00
7215 | B | 2013-08-20 00:00:00
4955 | A | 2013-08-21 00:00:00
6649 | A | 2013-08-21 00:00:00
7165 | E | 2013-08-21 00:00:00
7449 | A | 2013-08-21 00:00:00
7630 | D | 2013-08-21 00:00:00
1233 | A | 2013-08-22 00:00:00
7542 | A | 2013-08-22 00:00:00
7671 | C | 2013-08-23 00:00:00
Spreadsheet: 0ce9f04d-2796-49c6-a3f3-4a250543cf00
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
7778 | 40036 | Hilary | [NAME] | GBR | 0 | 01:04:43 | 00:01:37 | 01:55:47 | 00:01:23 | [NAME] | 1 | [NAME]
Spreadsheet: 293871d1391113051-create-list-listing-each-item-multiple-times-based-number-in-another-column-gen_new_list-pcb-
Sheet: Blad1

Code | Number |  | New List
031031 | 4 |  | 031031 |  |  |  | Note:
021111 | 5 |  | 031031 |  |  |  | To see the [NAME] code: | press Alt+F11
025813 | 13 |  | 031031 |  |  |  |  | goto Module1
test | 6 |  | 031031 |  |  |  |  | find subroutine: Gen_List
 |  |  | 021111
 |  |  | 021111
 |  |  | 021111
 |  |  | 021111
 |  |  | 021111
 |  |  | 025813
 |  |  | 025813
 |  |  | 025813
 |  |  | 025813
 |  |  | 025813
 |  |  | 025813
 |  |  | 025813
 |  |  | 025813
 |  |  | 025813
 |  |  | 025813
 |  |  | 025813
 |  |  | 025813
 |  |  | 025813
 |  |  | test
 |  |  | test
 |  |  | test
 |  |  | test
 |  |  | test
 |  |  | test