tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 92148d1291809831-spreadsheet-to-determine-login-logout-times-ats
Sheet: Sheet1

Name | Date | Seg_Start | Seg_Finish | Segment Type(what it should read) | My [NAME] (lookup based on instance) |  | Instance # | Total  # Instances
Louise | 2010-12-01 00:00:00 | 11:53:11 | 20:14:08 | SINGLE
[NAME] | 2010-12-01 00:00:00 | 11:59:04 | 13:22:26 | START
Michelle | 2010-12-01 00:00:00 | 09:37:18 | 17:32:40 | SINGLE
Dean | 2010-12-01 00:00:00 | 10:30:49 | 19:01:23 | SINGLE
Adam | 2010-12-01 00:00:00 | 13:27:57 | 19:08:57 | SINGLE
Shelly | 2010-12-01 00:00:00 | 07:54:09 | 14:12:03 | SINGLE
Byron | 2010-12-01 00:00:00 | 09:51:29 | 19:03:02 | SINGLE
[NAME] | 2010-12-01 00:00:00 | 11:35:58 | 19:27:38 | FINISH
[NAME] | 2010-12-01 00:00:00 | 13:57:22 | 16:29:48 | START
[NAME] | 2010-12-01 00:00:00 | 16:33:17 | 18:59:28 | FINISH
Corrine | 2010-12-01 00:00:00 | 11:34:57 | 17:28:36 | START
Corrine | 2010-12-01 00:00:00 | 17:45:36 | 19:00:29 | FINISH
[NAME] | 2010-12-01 00:00:00 | 13:57:10 | 19:00:17 | SINGLE
[NAME] | 2010-12-01 00:00:00 | 13:09:32 | 18:13:58 | SINGLE
[NAME] | 2010-12-01 00:00:00 | 13:51:23 | 13:58:24 | START
[NAME] | 2010-12-01 00:00:00 | 13:59:20 | 14:59:20 | MIDDLE
[NAME] | 2010-12-01 00:00:00 | 15:00:20 | 19:00:17 | FINISH
Ann | 2010-12-01 00:00:00 | 11:54:43 | 20:00:09 | SINGLE
[NAME] | 2010-12-01 00:00:00 | 12:04:08 | 18:19:50 | SINGLE
Daniel | 2010-12-01 00:00:00 | 11:00:55 | 11:01:55 | START
Daniel | 2010-12-01 00:00:00 | 11:08:53 | 19:00:08 | FINISH
[NAME] | 2010-12-01 00:00:00 | 10:09:10 | 19:45:46 | SINGLE
Corrine | 2010-12-02 00:00:00 | 09:24:50 | 09:24:58 | START |  |  |  |  | This should be 1/2 &
Corrine | 2010-12-02 00:00:00 | 09:26:41 | 17:30:40 | FINISH |  |  |  |  | 2/2 as it is the next day
[NAME] | 2010-12-02 00:00:00 | 08:17:32 | 13:00:07 | SINGLE
[NAME] | 2010-12-02 00:00:00 | 08:16:26 | 08:16:29 | SINGLE
Spreadsheet: 845561d1697028106-show-working-instructions-depending-on-ghs-hazard-pictograms-sample-book-v2-1-1-
Sheet: Search

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Right: | Wrong: | no double requirements should occur for one product and one room
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Room 2 + (text for 5 and 7) | Room 2 + (text for 5; 7; 5; 7)
 |  |  |  |  |  |  |  |  |  |  |  | Room 3, not allowed to be warmed, need to be in room 9 |  | Room 3 + (text for 5 and 7) | Room 3 + (text for 5; 7; 5; 7)
 |  |  |  |  |  |  |  |  |  |  |  | Room 4, depending, max 10 liter, large amounts, max 10 g, not allowed to be warmed, no water, need to be in room 9, box, if possible in room 8 |  | Room 4 + (text for 1-9) | Room 4 + (text for 1-9; 5; 7)
 | Organische Peroxide CD |  | Organische Peroxide EF |  |  |  |  |  |  |  |  | Room 6, not allowed to be warmed |  | Room 6 + (text for 5) | Room 6 + (text for 5; 5)
 |  |  |  |  |  |  |  |  |  |  |  | Room 7, not allowed to be warmed |  | Room 7 + (text for 5) | Room 7 + (text for 5; 5)
 |  |  |  |  |  |  |  |  |  |  |  | Room 9, not allowed to be warmed, no water, need to be in room 9, box, if possible in room 8, if possible in room 10, if possible in room 6 |  | Room 9 + (text for 5-11) | Room 9 + (text for 5-11; 5)
 | Possible Rooms: |  |  |  |  |  |  |  |  |  | Possible Rooms
 | Room 1, depending, if possible in room 6 Room 2, [NAME] 10 g, if possible in room 6 Room 3, if possible in room 6 Room 4, if possible in room 6
 | Chemical is a |  | Powder
 | Special Requirements: |  |  |  |  |  |  |  |  |  | Special Requirements
 | B12: be aware of B15: if, then do [NAME]: Need xy B59: not allowed to
Spreadsheet: 761931d1641306520-looking-to-activate-a-formula-only-after-another-action-is-taken-c-town-rose-random-4s-or-6s-vball-tournament
Sheet: Intermediate Players

Players per team: | 4
Intermediate Players: |  |  |  |  | # of Teams
 |  |  |  |  | 1
 | Intermediate Net
Participants | Player Name | Player's Number |  | Team #
 | [NAME] |  |  | PLAYERS
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Shane Doe
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
Spreadsheet: 706079d1606459517-transpose-previous-value-to-next-column-based-on-conditions-sampleb
Sheet: Sheet1 (2)

Name | Total | 1
A | 1
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
B | 1
B
B
B
B
C | 1
C
C
C
C
C
C
C
D | 1
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
D
Spreadsheet: 167671d1342057972-average-of-non-blanks-sepsis-monitoring-7-11-2012
Sheet: July

Sepsis [NAME]
Pt name | MRN | Location | Admission date | Trigger Date | [NAME] | Physician | [NAME] | RR called | [NAME] other than Rapid Response | Additional Comments on Alert Acknowledgement | Indivdiual Acknowledging Alert | Individual's Role Acknowledging Alert | Pt met SIRS criteria per RR assessment? | Lactate level drawn | Lactate level | Name of Physician notified | Adequate Fluid Resuscitation | ATB change | Intubation | Dialysis | Other Orders Y/N | Other Orders (specify) | Outcome | Outcome  Date | [NAME] | Other Comments
 |  |  | 2012-06-18 00:00:00 | 2012-06-21 00:00:00 | 12:20:00
 |  |  | 2012-06-16 00:00:00 | 2012-06-20 00:00:00 | 02:04:00
 |  |  | 2012-06-18 00:00:00 | 2012-06-19 00:00:00 | 20:56:00
 |  |  | 2012-06-11 00:00:00 | 2012-06-19 00:00:00 | 22:07:00
 |  |  | 2012-06-14 00:00:00 | 2012-06-17 00:00:00 | 09:56:00
 |  |  | 2012-06-04 00:00:00 | 2012-06-10 00:00:00 | 23:45:00
 |  |  |  |  |  |  |  |  | Physician made aware
 |  |  |  |  |  |  |  |  | [NAME] notified
 |  |  |  |  |  |  |  |  | [NAME] notified
 |  |  |  |  |  |  |  |  | Physician made aware
 |  |  |  |  |  |  |  |  | Physician made aware
 |  |  |  |  |  |  |  |  | Hospice/Comfort
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes
Totals |  |  |  |  |  |  | % BP | % Yes | % Hospice/Comfort |  |  | % RN | % Yes | % Yes |  |  | % Yes | %Yes | %Yes | %Yes | %Yes |  | %Home |  | % Yes
Total # Sepsis Alerts
 |  |  |  |  |  |  | % Cognitive | % No | % Physician Notified |  |  | % LPN | %No | %No |  |  | %No | %No | %No | %No | %No |  | % xfer higher |  | % No
 |  |  |  |  |  |  |  |  | % Physician Made Aware |  |  | % PCT |  |  |  |  |  |  |  |  |  |  | % xfer lower
 |  |  |  |  |  |  |  |  | % Primary Nurse Notified |  |  | % Other |  |  |  |  |  |  |  |  |  |  | % expired
Spreadsheet: 226211d1365305489-filter-help-vanpool
Sheet: Data Lists

 |  | Semi-Monthly Home Budget |  |  |  |  |  |  |  |  |  |  | DATA LISTS
 |  | SETUP         The Category data below populates the drop down lists in the [NAME] table on the Expenditures & Income sheet. Modify the category names or the descriptions below each category to update the lists.
 |  | [NAME] | Debits | Credit | Column2
 |  | Borszich | Monthly [NAME] | Fuel
 |  | [NAME] | [NAME]
 |  | [NAME] | TranServ Payments
 |  | Craycraft
 |  | [NAME]
 |  | Kubik
 |  | Lagasse
 |  | McManus
 |  | Mendoza
 |  | Moore
 |  | Neiswender
 |  | Noehl
 |  | Ramos
 |  | Shurbet
 |  | [NAME]
 |  | [NAME]
 |  | Wood
 |  | Caliman
 |  | [NAME]
 |  | [NAME]
 |  | McGavin
 |  | [NAME]
 |  | Parrish
 |  | Smith
Spreadsheet: 106853d1304009629-multiple-cell-drop-down-list-pricing-system-test-file-1
Sheet: Door Style

[NAME] Door Profile | 0
Standard Overlay - Premium Door Profile | 0.05
[NAME] | 0.1
[NAME] Door | 0.15
[NAME] | 0.2
[NAME] | 0.25
Inset Door - Standard Door Profile - Smooth Frame | 0.1
Inset Door - Premium Door Profile - Smooth Frame | 0.1
Inset Door - Standard Door Profile - Beaded Frame | 0.2
Inset Door - Premium Door Profile - Beaded Frame | 0.2
Spreadsheet: 777076d1650123502-pull-data-from-multiple-sheets-floor-stock-sheets-template
Sheet: Phase 2 2003420

Phase 2 2003420 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Service Units
Item | Price | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu
Lemon Lime- Soda | 0.25 |  |  |  | 24 |  |  |  |  |  |  | 24
Diet Lemon Lime- Soda | 0.25
Cola- Soda | 0.25 |  |  |  |  |  |  |  |  |  |  | 24
Diet Cola- Soda | 0.25
Pudding-Vanilla | 0.27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24
Pudding [NAME] | 0.35
Crackers, [NAME] | 0.08 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50
[NAME] ea | 0.05
[NAME] | 1.13
Applesauce | 0.32
Juice Orange | 0.23
Juice Apple | 0.23
Juice Cranberry | 0.23
Broth, [NAME] | 0.1
Broth, Beef | 0.1
Popsicles | 0.25
Peanut Butter Crackers Toasted | 0.25
Peanut Butter Crackers Cheese | 0.25
Coffee Decaf Prepack cs. | 37.84
Coffee Regular | 95.11
Tea Bags | 0.03
[NAME] | 11
[NAME] | 0.16
Creamer | 0.03
Sugar | 0.02
Sweetner-Equal | 0.03
Sweetner-Sweet N Low | 0.03
Sweetner-Splenda | 0.03
Plates | 0.03
Bowls | 0.03
Straw | 1.75
Plastic Ware (fork,spoon knife) | 0.03
[NAME] | 0.13
[NAME] | 0.11
monthly Coffee total
Monthly Total
Spreadsheet: 738156d1624877640-get-address-of-the-value-maxifs-brings-samplew
Sheet: Sheet1

Name | Score | CODE |  | DESIRED OUTCOME |  | LOOKUP?
[NAME] | 50 | AB |  | DD |  |  | what am I doing wrong ?
[NAME] | 25 | AC |  | DD |  | #N/A
[NAME] | 80 | DD |  | DD |  | #N/A
[NAME] | 30 | FD |  | DD |  | #N/A
[NAME] | 45 | DS |  | DD |  | #N/A
[NAME] | 80 | FC |  | FC |  | #N/A
[NAME] | 70 | SA |  | FC |  | #N/A
[NAME] | 80 | FC |  | FC |  | #N/A
[NAME] | 55 | DE |  | FC |  | #N/A
[NAME] | 65 | DF |  | FC |  | #N/A
[NAME] | 25 | RC |  | AR |  | #N/A
[NAME] | 30 | RF |  | AR |  | #N/A
[NAME] | 65 | GG |  | AR |  | #N/A
[NAME] | 40 | FV |  | AR |  | #N/A
[NAME] | 90 | AR |  | AR |  | #N/A
[NAME] | 10 | PR |  | CC |  | #N/A
[NAME] | 50 | DK |  | CC |  | #N/A
[NAME] | 55 | CC |  | CC |  | #N/A
[NAME] | 40 | MV |  | CC |  | #N/A
[NAME] | 50 | QP |  | CC |  | #N/A
[NAME] | 25 | LS |  | GM |  | #N/A
[NAME] | 50 | BS |  | GM |  | #N/A
[NAME] | 55 | GM |  | GM |  | #N/A
[NAME] | 40 | XV |  | GM |  | #N/A
[NAME] | 45 | ZD |  | GM |  | #N/A
Spreadsheet: judy_townsend__17723__trans1
Sheet: Lookup

[NAME]
Gas Daily |  |  |  |  |  |  | Pipe Locations |  |  | Transport |  |  |  |  |  | Location/Location Cost
 | Layman | Curve | Curve | Book |  |  |  |  |  |  |  |  |  |  |  | Combined | Transport
Number | Location | Location | Type | Type | [NAME] |  | Number | Location |  | Number | Location | Number | Location |  |  | Location | Cost |  | Stop Date
1 | CNG-N | GD-CNG/NORTH | SP | D |  |  | 1 | Algonquin |  | 1 | FT | 1 | FT
2 | CNG-S | GD-CNG/SOUTH | SP | D |  |  | 2 | Cgulf Leach |  | 2 | IT | 2 | IT
3 | Gulf Mainline | GD-COLGULF/RAYN | SP | D |  |  | 3 | Cgulf Mainline (Rayne) |  | 3 | FT Summer | 3 | Show All
4 | Gulf Onshore | GD-COLGULF/LA | SP | D |  |  | 4 | Cgulf Offshore |  | 4 | FT Winter
5 | TCO | GD-CGT/APPALAC | SP | D |  |  | 5 | Cgulf Onshore |  | 5 | IT Summer
6 | [NAME]0 | GD-TENN/CORPUS | SP | D |  |  | 6 | CNG-N |  | 6 | IT Winter
7 | [NAME] | IF-TENN/Z5 | PR | M |  |  | 7 | CNG-S |  | 7 | FTS1
8 | [NAME] 500 | GD-TENN/500 | SP | D |  |  | 8 | CNG N/Citygate |  | 8 | FTS1 Summer
9 | [NAME] | GD-TENN/800 | SP | D |  |  | 9 | CNG S/Citygate |  | 9 | FTS1 Winter
10 | Tetco   STX | GD-TETCO/STX | SP | D |  |  | 10 | [NAME] |  | 10 | FTS2
11 | Tetco  ETX | GD-TETCO/ETX/CR | SP | D |  |  | 11 | [NAME] |  | 11 | ITS1
12 | Tetco  WLA | GD-TETCO/WLA | SP | D |  |  | 12 | Sonat |  | 12 | ITS1 Summer
13 | Tetco ELA | GD-TETCO/ELA | SP | D |  |  | 13 | TC0/Citygate |  | 13 | ITS1 Winter
14 | Tetco M1 | GD-TETCO/M1 | SP | D |  |  | 14 | TCO |  | 14 | ITS2
15 | Tetco M2 | IF-TETCO/M2 | PR | M |  |  | 15 | [NAME]0 |  | 15 | FT Gathering
16 | Tetco M3 | GD-TETCO/M3 | SP | D |  |  | 16 | [NAME]L 500 |  | 16 | IT Gathering
17 | Texas Gas Z/1 | GD-TGT/Z1 | SP | D |  |  | 17 | [NAME]
18 | Texas Gas Z/SL | GD-TGT/ZSL | SP | D |  |  | 18 | [NAME] |  | Path
19 | [NAME] (30) | GD-TRANSCO/Z1 | SP | D |  |  | 19 | [NAME] |  | Number
20 | [NAME] (45) | GD-TRANSCO/Z2 | SP | D |  |  | 20 | [NAME] |  | 1
21 | [NAME] (65) | GD-TRANSCO/Z3 | SP | D |  |  | 21 | [NAME] |  | 2
22 | [NAME] (85) | GD-TRANSCO/Z4 | SP | D |  |  | 22 | [NAME] |  | 3
23 | [NAME] (nonNY) | GD-TRCOZ6/NONY | SP | D |  |  | 23 | [NAME] |  | 4
24 | [NAME] (NY) | GD-TRCOZ6/NY | SP | D |  |  | 24 | [NAME] |  | 5
 |  |  |  |  |  |  | 25 | Tetco   STX |  | 6
 |  |  |  |  |  |  | 26 | Tetco  ETX |  | 7
 |  |  |  |  |  |  | 27 | Tetco  WLA |  | 8
 |  |  |  |  |  |  | 28 | Tetco ELA |  | 9
 |  |  |  |  |  |  | 29 | Tetco M1 |  | 10
 |  |  |  |  |  |  | 30 | Tetco M2
 |  |  |  |  |  |  | 31 | Tetco M3
 |  |  |  |  |  |  | 32 | Texas Gas Z0 (SL)
 |  |  |  |  |  |  | 33 | Texas Gas Z1 (S)
 |  |  |  |  |  |  | 34 | Texas Gas Z2
 |  |  |  |  |  |  | 35 | Texas Gas Z3
 |  |  |  |  |  |  | 36 | Texas Gas Z4
 |  |  |  |  |  |  | 37 | [NAME]
 |  |  |  |  |  |  | 38 | [NAME]
 |  |  |  |  |  |  | 39 | [NAME]
 |  |  |  |  |  |  | 40 | Transco Z3/Wellhead
 |  |  |  |  |  |  | 41 | [NAME]
 |  |  |  |  |  |  | 42 | [NAME]
 |  |  |  |  |  |  | 43 | [NAME]
 |  |  |  |  |  |  | 44 | [NAME] (nonNY)
 |  |  |  |  |  |  | 45 | [NAME] (NY)
 |  |  |  |  |  |  | 46 | Empty
Spreadsheet: 838580d1691152485-maximum-drawdown-in-percentage-max-dd-chart
Sheet: Sheet1

Total R2 | [NAME] DD%
-0.005
-0.01
0
0.01
0.005
0.015
0.025
0.035
0.04500000000000001
0.02
0.01
Spreadsheet: 93958931-753f-4758-b58e-102acdf1e6e5
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
HEXAI | Test | HEXAI | Hexahydrophtalic Anhydride, IgE | Hexahydrophtalic Anhydride, 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
HEXAI | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
HEXAI | Result | HEXAI | Hexahydrophtalic Anhydride, IgE | Hexahydrophtalic Anhydride, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 19742-6
Spreadsheet: 730619d1619794586-address-cell-to-reference-row-test
Sheet: Sheet2

3 |  |  |  | <<<< this would reference the row on sheet 1
DATE |  |  |  | FORMULA TO PULL DATA FROM SHEET 1 USING ROW REFERENCED IN A1 THEN REFERENCE THE CORRECT CELL (A3) |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-30 00:00:00
CUSTOMER |  |  |  | FORMULA TO PULL DATA FROM SHEET 1 USING ROW REFERENCED IN A1 THEN REFERENCE THE CORRECT CELL (B3) |  |  |  |  |  |  |  |  |  |  |  |  | Progress Container & Display
CSR |  |  |  | FORMULA TO PULL DATA FROM SHEET 1 USING ROW REFERENCED IN A1 THEN REFERENCE THE CORRECT CELL (C3) |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | WOULD RETURN THIS DATA
CUSTOMER NUMBER |  |  |  | FORMULA TO PULL DATA FROM SHEET 1 USING ROW REFERENCED IN A1 THEN REFERENCE THE CORRECT CELL (D3) |  |  |  |  |  |  |  |  |  |  |  |  | 1833
SHIP DATE |  |  |  | FORMULA TO PULL DATA FROM SHEET 1 USING ROW REFERENCED IN A1 THEN REFERENCE THE CORRECT CELL (E3) |  |  |  |  |  |  |  |  |  |  |  |  | 2021-05-12 00:00:00
DUE |  |  |  | FORMULA TO PULL DATA FROM SHEET 1 USING ROW REFERENCED IN A1 THEN REFERENCE THE CORRECT CELL (F3) |  |  |  |  |  |  |  |  |  |  |  |  | 2021-05-14 00:00:00
EXAMPLE # 2
4 |  |  |  | <<<< this would reference the row on sheet 1
DATE |  |  |  | FORMULA TO PULL DATA FROM SHEET 1 USING ROW REFERENCED IN A1 THEN REFERENCE THE CORRECT CELL (A4) |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-30 00:00:00
CUSTOMER |  |  |  | FORMULA TO PULL DATA FROM SHEET 1 USING ROW REFERENCED IN A1 THEN REFERENCE THE CORRECT CELL (B4) |  |  |  |  |  |  |  |  |  |  |  |  | XYZ Company
CSR |  |  |  | FORMULA TO PULL DATA FROM SHEET 1 USING ROW REFERENCED IN A1 THEN REFERENCE THE CORRECT CELL (C4) |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | WOULD RETURN THIS DATA
CUSTOMER NUMBER |  |  |  | FORMULA TO PULL DATA FROM SHEET 1 USING ROW REFERENCED IN A1 THEN REFERENCE THE CORRECT CELL (D4) |  |  |  |  |  |  |  |  |  |  |  |  | 2244
SHIP DATE |  |  |  | FORMULA TO PULL DATA FROM SHEET 1 USING ROW REFERENCED IN A1 THEN REFERENCE THE CORRECT CELL (E4) |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-22 00:00:00
DUE |  |  |  | FORMULA TO PULL DATA FROM SHEET 1 USING ROW REFERENCED IN A1 THEN REFERENCE THE CORRECT CELL (F4) |  |  |  |  |  |  |  |  |  |  |  |  | 2021-04-26 00:00:00
Spreadsheet: 1e5b4365-85b0-4f77-8d8a-1d39c36d8cb5
Sheet: 08-Jo 

UNIVERSITETI I PRISHTINËS
Nr. 120
Prishtinë , më 18 . 1 . 2012.
 | Komisioni për lirim nga pagesa e semestrit të studentëve të Universitetit të Prishtinës,në mbledhjen e mbajtur më 16.1. 2012, mori
 | V E N D I M
 | Mbi mos lirimin nga pagesa e semestrit për [NAME] 2011/2012
 | [NAME] 2011/2012 [NAME] nga pagesa e semestrit këta studentë nga
 | Fakulteti i Inxhinierisë Mekanike
Nr. | Emri, emri i prindit dhe mbiemri | Komuna | Kategoria | Arsyeja
1 | Granit Mehmet [NAME] | Gllogoc | Me aftësi të kufizuara | Ti kompletojë dokumentet sipas konkursit
2 | [NAME] | [NAME] | Asistencë sociale | Mungon certifikata e lindjes
3 | [NAME] | Suharekë | Prindi invalid | [NAME] i përket asnjë kategorie për lirim
4 | [NAME] | Kaçanik | Asistencë sociale | Ti kompletojë dokumentet sipas konkursit
5 | Arsim [NAME] | Prishtinë | Prindi i vrarë | Ti kompletojë dokumentet sipas konkursit
6 | [NAME] | Skënderaj | Prindi invalid | [NAME] i përket asnjë kategorie për lirim
7 | Shkëlqim Rashit Bojaj | Klinë | Prindi invalid | [NAME] i përket asnjë kategorie për lirim
8 | Arbër [NAME] | Deçan | Asistencë sociale | Ti kompletojë dokumentet sipas konkursit
 | VËREJTJE:
 | Kundër këtij [NAME] të parashtrohet ankesa e argumentuar në afat prej 8 ditësh nga dita e publikimit të këtij vendimi. Ankesa dorëzohet në fakultetin përkatës.
 |  |  |  | K O M I S I O N I:
 |  |  |  | Prof.Dr.[NAME],kryetar              ________________
 |  |  |  | [NAME], anëtar                           ________________
 |  |  |  | [NAME], anëtar                         ________________
 |  |  |  | [NAME] Samadraxha(MASHT), anëtar ________________
 |  |  |  | Fehmi Ibrahimi(MPMS), anëtar          ________________
Spreadsheet: 814637d1674522064-transfer-selected-data-from-a-master-sheet-to-another-sheet-in-a-different-cell-address-player-test
Sheet: LONDON

 |  | LONDON
 | TEE | LAST NAME | FIRST NAME | ORDER
 |  |  | Hank
 |  | Canter | Cole
 |  | Chance | Bray
 |  | Faust | Hugh
 |  | [NAME] | Juan
 |  | Heuber | Hal
 |  | [NAME] | Doug
 |  | Jaimeson | [NAME]
 |  | Sellers | [NAME]
 |  | Wilde | [NAME]
Spreadsheet: 772907d1647523346-if-and-to-return-cell-value-priority
Sheet: Sheet1

 | Code | Category | Fault X | Fault Y | Fault Z | Repair Priority
 | HC2-I | Time Qual Defect | 0 | 0 | 1
 | HCD-2 | Immediate Defect | 1 | 0 | 0
 | HC2-E | Immediate Defect | 1 | 0 | 0
 | HC2-MQ | Time Qual Defect | 0 | 1 | 0
Spreadsheet: 130683d1322515477-lookup-lookup-issue-among-sheets
Sheet: Sheet2

B1 |  | C1
2 |  | A
3 |  | B
4 |  | C
1 |  | D
65 |  | E
5 |  | F
7 |  | G
8 |  | H
9 |  | I
12 |  | J
15 |  | K
13 |  | L
17 |  | M
19 |  | N
11 |  | O
16 |  | M
111 |  | P
352 |  | Q
55 |  | R
66 |  | S
24
78
67
54
90
33
31
27
41
Spreadsheet: 48431d1247650139-multiple_lookup-multiple_lookup
Sheet: Report

 | [NAME] | Forecast | Moment I select the mode, corresponding values gets picked up from "Lookup" sheet and data pertaining to the values get displayed from "Data-Backup" Sheet.
 |  |  | Values need to be displayed in ROW 5 only and Total column should be there by default.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Forecast
Campaign | Q1 | Q2 | Q3 | Q4 | Total |  |  |  |  |  |  |  |  |  |  |  |  | Pillars
EUP | 0.2999999996988894 | 0.2999999996988894 | 0.2000000003011107 | 0.2000000003011107 | 1 | Data picking from Data-Backup sheet |  |  |  |  |  |  |  |  |  |  |  | Budget
GSI | 0.2500000000503529 | 0.2999999999798589 | 0.2500000000503529 | 0.1999999999194354 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | KPI's
BA | 0.2999999996104125 | 0.2999999996104125 | 0.2000000003895875 | 0.2000000003895875 | 1
BI | 0.3 | 0.3 | 0.2 | 0.2 | 0.9999999999999999
WWP | 0.1500000000458848 | 0.2500000002294238 | 0.2999999998623458 | 0.2999999998623458 | 1
BMO | 0.25 | 0.25 | 0.25 | 0.25 | 1
EDU | 0.25 | 0.25 | 0.25 | 0.25 | 1
[NAME] | 0.1500000001193177 | 0.2999999997362451 | 0.3500000000690787 | 0.2000000000753586 | 1
Collab | 0.1499999999951359 | 0.2999999999902719 | 0.2500000000243203 | 0.2999999999902719 | 1
Spreadsheet: 75687d1276228113-formula-not-work-on-word-good-traffic-control-sample
Sheet: Sheet1

 |  | TRAFFIC CONTROL COMPLIANCE
LOCATIONS | Type | Material | Quantity | CONDITION | COST | Cost of | CURRENT | USEFUL | REMAINING
 |  |  | & Size |  | REPLACEMENT | Repair | VALUE | IN LIFE | IN LIFE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Traffic Lights |  | Good | Vegetation
Wattle Street | Traffic Lights | Paved | 1 | Good | 125000 | 125000 | 0 | 35 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Roundabouts |  | Average | Solid
 | Roundabouts | Vegetation | 1 | Good | 10000 | 10000 | 0 | 10 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Roundabouts Protrudence |  | Poor | Paved
 | Roundabouts Protrudence | With 2 Ramps | 4 | Good | 1200 | 4800 | 0 | 15 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Slow Point |  |  | With Lights
 | Slow Point |  |  |  | 6000 | 0 | 0 | 20 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | One Way Traffic |  |  | Without Lights
 | One Way Traffic |  |  |  |  | 0 | 0 | 10 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Speed Humps |  |  | With 2 Ramps
 | Speed Humps | Paved | 4 | Good | 4800 | 19200 | 0 | 10 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Emu Crossing |  |  | Asphalt
 | Emu Crossing                  large | Without Lights | 1 | Good |  | 0 | 0 | 15 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | Side Refuge
 | small | With Lights | 1 | Good |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Protrudence |  |  | Centre Refuge
 | [NAME] |  |  |  |  | 0 | 0 | 15 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Centre Island |  |  | Centre
 | Protrudence                    small | Vegetation | 24 | Poor | 1000 | 24000 | 1600 | 15 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Side Island
 |  | Vegetation | 6 | Average | 1000 | 6000 | 3000 | 15
 |  | Vegetation | 5 | Poor | 1000 | 5000 | 333.3333333333333 | 15
 |  | Solid | 1 | Good | 1000 | 1000 | 0 | 15