tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 52726d1252564665-multiple-criteria-per-conditional-formatting-rule-test
Sheet: sheet2

 | 2009-09-05 00:00:00
 | 2009-09-30 00:00:00
 |  |  |  | 252 | 253 | 254 | 255 | 256 | 257 | 258 | 259 | 260 | 261 | 262 | 263 | 264 | 265 | 266 | 267 | 268 | 269 | 270 | 271 | 272 | 273 | 274 | 275 | 276 | 277 | #N/A | #N/A
 |  | DATE |  | 2009-09-05 00:00:00 | 2009-09-06 00:00:00 | 2009-09-07 00:00:00 | 2009-09-08 00:00:00 | 2009-09-09 00:00:00 | 2009-09-10 00:00:00 | 2009-09-11 00:00:00 | 2009-09-12 00:00:00 | 2009-09-13 00:00:00 | 2009-09-14 00:00:00 | 2009-09-15 00:00:00 | 2009-09-16 00:00:00 | 2009-09-17 00:00:00 | 2009-09-18 00:00:00 | 2009-09-19 00:00:00 | 2009-09-20 00:00:00 | 2009-09-21 00:00:00 | 2009-09-22 00:00:00 | 2009-09-23 00:00:00 | 2009-09-24 00:00:00 | 2009-09-25 00:00:00 | 2009-09-26 00:00:00 | 2009-09-27 00:00:00 | 2009-09-28 00:00:00 | 2009-09-29 00:00:00 | 2009-09-30 00:00:00
 |  | EMPLOYEE |  | 2009-09-05 00:00:00 | 2009-09-06 00:00:00 | 2009-09-07 00:00:00 | 2009-09-08 00:00:00 | 2009-09-09 00:00:00 | 2009-09-10 00:00:00 | 2009-09-11 00:00:00 | 2009-09-12 00:00:00 | 2009-09-13 00:00:00 | 2009-09-14 00:00:00 | 2009-09-15 00:00:00 | 2009-09-16 00:00:00 | 2009-09-17 00:00:00 | 2009-09-18 00:00:00 | 2009-09-19 00:00:00 | 2009-09-20 00:00:00 | 2009-09-21 00:00:00 | 2009-09-22 00:00:00 | 2009-09-23 00:00:00 | 2009-09-24 00:00:00 | 2009-09-25 00:00:00 | 2009-09-26 00:00:00 | 2009-09-27 00:00:00 | 2009-09-28 00:00:00 | 2009-09-29 00:00:00 | 2009-09-30 00:00:00
 | 1 | A | TEST1 | -8 | -8 | -8 | -8 | 0 | -8 | -8 | -8 | -8 | 0 | 0 | -8 | -8 | -8 | -8 | -8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | LA
 | 2 | A | TEST2 | Z | Z | Z | LD | 0 | LN | LN | LN | LN | 0 | 0 | LA | LA | LA | LA | LA | 0 | 0 | CA | CA | CA | CA | 0 | LA | LA | LA
 | 3 | A | TEST3 | CA | CA | CA | CA | 0 | CN | CN | CN | CN | 0 | 0 | LA | LA | LA | LA | LA | 0 | 0 | LD | LD | LD | LD | 0 | LA | LA | LA
 | 4 | A | TEST4 | Z | Z | Z | LD | 0 | LN | LN | LN | LN | C | C | C | C | C | LA | LA | C | C | LD | LD | LD | LD | 0 | LA | LA | LA
 | 5 | A | TEST5 | LD | LD | LD | LD | 0 | LN | LN | LN | LN | 0 | 0 | LA | LA | LA | LA | LA | 0 | 0 | LD | LD | LD | LD | 0 | CA | CA | CA
 | 10 | B | TEST10 | LN | LN | 0 | 0 | LA | LA | LA | LA | LA | 0 | 0 | LD | LD | LD | LD | 0 | LA | LA | LA | LA | LA | 0 | 0 | LN | LN | LN
 | 6 | B | TEST6 | -8 | -8 | LD | LD | 0 | LN | LN | LN | LN | 0 | 0 | LA | LA | -8 | -8 | -8 | 0 | 0 | LD | LD | LD | LD | 0 | LA | LA | LA
 | 7 | B | TEST7 | LD | LD | 0 | 0 | 0 | -8 | -8 | -8 | -8 | 0 | 0 | -8 | -8 | -8 | -8 | -8 | 0 | 0 | LD | LD | LD | LD | 0 | LA | LA | LA
 | 8 | B | TEST8 | LD | LD | LD | LD | 0 | LN | LN | LN | LN | 0 | 0 | LA | LA | LA | LA | LA | 0 | 0 | LD | LD | LD | LD | 0 | LA | LA | LA
 | 9 | B | TEST9 | CD | CD | CD | CD | 0 | LN | LN | LN | LN | 0 | 0 | LA | LA | LA | LA | LA | 0 | 0 | LD | CN | CN | CN | 0 | LA | LA | LA
Spreadsheet: 284ca5fb-a950-4230-9458-932c4c78e3fc
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Single Family Residential Starts | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
YEAR | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | TOTAL
2014 | 40 | 59 | 45 | 49 | 60 | 38 | 32 | 34 | 59 | 16 |  |  | 432
2013 | 50 | 31 | 53 | 67 | 45 | 47 | 31 | 24 | 31 | 36 | 35 | 29 | 479
2012 | 19 | 19 | 44 | 46 | 38 | 46 | 46 | 48 | 26 | 37 | 22 | 26 | 417
2011 | 5 | 20 | 32 | 44 | 26 | 51 | 9 | 10 | 36 | 19 | 12 | 37 | 301
2010 | 19 | 47 | 60 | 44 | 33 | 83 | 36 | 37 | 25 | 27 | 25 | 19 | 455
2009 | 57 | 93 | 68 | 85 | 89 | 61 | 44 | 67 | 19 | 31 | 35 | 39 | 688
2008 | 50 | 105 | 87 | 82 | 106 | 76 | 45 | 35 | 28 | 53 | 23 | 25 | 715
2007 | 112 | 91 | 124 | 90 | 111 | 107 | 85 | 59 | 63 | 101 | 49 | 54 | 1046
2006 | 322 | 178 | 337 | 242 | 170 | 191 | 126 | 113 | 81 | 55 | 90 | 144 | 2049
2005 | 193 | 347 | 195 | 335 | 288 | 315 | 254 | 317 | 236 | 218 | 146 | 240 | 3084
2004 | 94 | 85 | 201 | 176 | 142 | 185 | 166 | 135 | 113 | 181 | 121 | 121 | 1720
2003 | 60 | 79 | 110 | 114 | 111 | 135 | 141 | 105 | 93 | 103 | 71 | 102 | 1224
2002 | 71 | 66 | 83 | 75 | 68 | 77 | 70 | 83 | 66 | 90 | 75 | 77 | 901
2001 | 62 | 67 | 102 | 78 | 114 | 83 | 64 | 92 | 68 | 72 | 58 | 56 | 916
2000 | 44 | 28 | 47 | 64 | 57 | 57 | 69 | 43 | 70 | 51 | 44 | 54 | 628
1999 | 20 | 53 | 26 | 61 | 47 | 23 | 55 | 48 | 48 | 30 | 37 | 58 | 506
1998 | 35 | 33 | 85 | 85 | 63 | 75 | 57 | 38 | 66 | 60 | 16 | 51 | 664
1997 | 48 | 70 | 69 | 35 | 87 | 79 | 18 | 63 | 23 | 43 | 49 | 91 | 675
1996 | 34 | 81 | 58 | 48 | 65 | 64 | 91 | 110 | 40 | 91 | 38 | 58 | 778
1995 | 56 | 60 | 105 | 77 | 117 | 63 | 56 | 67 | 55 | 64 | 50 | 89 | 859
1994 | 63 | 72 | 69 | 64 | 41 | 52 | 41 | 65 | 67 | 91 | 56 | 91 | 772
1993 | 29 | 73 | 105 | 91 | 90 | 115 | 80 | 100 | 48 | 111 | 70 | 91 | 1003
1992 | 22 | 43 | 59 | 54 | 48 | 55 | 69 | 81 | 72 | 24 | 52 | 41 | 620
1991 | 35 | 31 | 39 | 39 | 31 | 44 | 45 | 43 | 48 | 49 | 95 | 75 | 574
1990 | 29 | 20 | 14 | 25 | 53 | 39 | 30 | 76 | 29 | 35 | 38 | 28 | 416
1989 | 58 | 65 | 105 | 64 | 61 | 59 | 51 | 53 | 37 | 49 | 8 | 46 | 656
1988 | 38 | 75 | 100 | 70 | 99 | 127 | 54 | 58 | 103 | 55 | 45 | 39 | 863
1987 | 102 | 106 | 95 | 78 | 36 | 48 | 43 | 39 | 84 | 81 | 43 | 45 | 800
1986 | 73 | 85 | 89 | 118 | 74 | 129 | 76 | 95 | 109 | 74 | 72 | 32 | 1026
1985 | 91 | 108 | 67 | 73 | 182 | 105 | 93 | 103 | 81 | 128 | 37 | 59 | 1127
TOTAL |  |  |  |  |  |  |  |  |  |  |  |  | 24310
**Totals include [NAME] as well as stick-built homes.**
***BUILDING INSPECTION BECAME A DIVISION OF C.D.D. IN MAY, 1987.
(Prior to that date, permits were obtained through C.I.D.-State)
Spreadsheet: 83082d1283150824-excel-2007-assigning-values-in-cells-and-then-summing-total-score-excluding-blanks-scoring_table-2-
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Scores | Missing
2 |  | 1 |  | 2 |  | 2 |  | 2 |  |  |  | 1 |  | 4 |  | 2 | 7 | 1 |  | if answer=1 or 2, then score = 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | if asnwer=3, then score = -1
1 |  | 2 |  | 4 |  | 2 |  | 2 |  | 3 |  | 2 |  | 4 |  | 1 | 5 | 0 |  | if answer=4, then score=0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | if answer is missing, then score= MISSING
2 |  | 1 |  | 1 |  | 1 |  | 2 |  | 2 |  | 1 |  | 1 |  | 2 | 9 | 0
2 |  | 1 |  | 2 |  | 2 |  | 2 |  | 2 |  | 1 |  | 2 |  | 2 | 9 | 0
2 |  | 1 |  | 2 |  | 2 |  | 2 |  | 2 |  | 1 |  | 4 |  | 1 | 8 | 0
2 |  | 4 |  | 2 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 2 | 3 | 0
3 |  | 2 |  | 2 |  | 2 |  |  |  | 2 |  | 4 |  |  |  | 2 | 4 | 2
1 |  | 1 |  | 2 |  | 1 |  | 2 |  | 4 |  | 1 |  | 3 |  | 2 | 6 | 0
4 |  | 4 |  | 4 |  | 1 |  | 2 |  | 3 |  | 1 |  | 3 |  | 4 | 1 | 0
Spreadsheet: 148193d1333241314-how-to-make-x-equal-total-help
Sheet: Sheet1

Items | Count | Price | Per Piece | number of pieces | Total | Use This Item | Column8 | # of X Boxes | Column10
Ribbons | 83 | 1.5 |  | 2 |  | x
Pull Bow 5.5 | 50 | 14.75 |  | 3 |  | x
Pull Bow 4 | 100 | 14.75
Pull Bow 1 | 87 | 14.75
Pull Bow 3.5 | 10 | 14.75 |  | 5 |  | x
Pull Bow 2 | 58 | 14.75
I need to calculate the amount for the X boxes.
How do I get the X cells in column G to give a complete total of the cell for the items being used?
Spreadsheet: 839891d1692282946-finding-partial-text-in-two-arrays-and-returning-one-or-more-values-listed-in-second-array-partial-match-of-arrays-example
Sheet: Result

Narrative | Matching Key Word? | Predetermined Key Words
Professional football players used to wear leather helms. | football; helmet | width
Many professional athletes are adept at playing many different sports. | adept | height
How was the width and height of the modern football goal posts determined? | width; height; football | helmet
Baseball players wear helmets as well. | helmet | adept
Soccer players don't wear helmets, but due to the many head injuries, perhaps they should. | helmet | AZ
AZ has many different sport venues. | AZ | Football
Spreadsheet: 148724d1333537233-vlookup-does-not-produce-searched-for-values-template
Sheet: Summary

Type | Productive
Somme de Hours |  |  | Period
CC | Item | Description | 1 | 2
66-4103 | 6600002 | TR: [NAME] | 1.5
 | 6600005 | TR: Nav Canada | 7.25 | 8.5
 | 6600006 | TR: SAGEM | 15 | 8.5
 | 6600008 | TR: Translation Bureau | 100 | 112.75
 | 6600010 | TR: CAE | 52.75 | 91
 | 6600011 | TR: IBM | 11.5 | 7.5
 | 6600012 | TR: Other clients |  | 0.25
 | 6600013 | TR: New Clients Budget |  | 3.5
 | 6600014 | TR: euroscript Luxembourg | 4
 | 6600015 | TR: euroscript Deutschland |  | 1
 | 6600032 | TR: Ontario Energy Board | 4.5 | 11
 | 6600033 | TR: MCIS | 3 | 4.5
 | 6600034 | TR: TWIST | 5 | 0.5
66-4122 | 6600003 | TR: [NAME] | 152 | 168
 | 6600005 | TR: Nav Canada | 1.75
 | 6600008 | TR: Translation Bureau | 163.25 | 136
 | 6600009 | TR: [NAME] | 164.5 | 163
 | 6600010 | TR: CAE | 32.5 | 70.5
 | 6600011 | TR: IBM | 1.75
 | 6600014 | TR: euroscript Luxembourg | 0.5 | 3
 | 6600032 | TR: Ontario Energy Board | 8 | 8
66-4123 | 6600005 | TR: Nav Canada | 62.75 | 76.75
 | 6600006 | TR: SAGEM | 3 | 3.5
 | 6600008 | TR: Translation Bureau | 290 | 415.75
 | 6600009 | TR: [NAME] | 3
 | 6600010 | TR: CAE | 109.5 | 89.25
 | 6600011 | TR: IBM | 77 | 16.5
 | 6600012 | TR: Other clients |  | 1.25
 | 6600014 | TR: euroscript Luxembourg | 13.75 | 4.75
 | 6600016 | TR: euroscript Services (France) | 3
 | 6600032 | TR: Ontario Energy Board | 1 | 11
 | 6600034 | TR: TWIST |  | 0.5
66-4202 | 6600023 | SI/C: [NAME] | 175 | 238
 | 6600024 | SI/C: CMC Electronique | 124 | 8
 | 6600026 | SI/C: New Clients Budget | 8 | 36
66-4301 | 6600018 | CM/DM: Bell Helicopter | 153 | 151
 | 6600028 | CM/DM: SAGEM | 52 | 160.75
 | 6600029 | CM/DM: L-3 Communications |  | 88
Spreadsheet: 861857d1709687879-vlookup-to-subtract-using-indirect-and-column-functions-vlookup-indirect-column-formula
Sheet: Sheet4

NODE | X | Y | HEADU
363574 | 623750 | 7156250 | 200
363575 | 625250 | 7156250 | 586.8925
363576 | 628250 | 7156250 | 590.3536
363577 | 629750 | 7156250 | 609.9778
Spreadsheet: eric_saibi__9825__092701R
Sheet: Coronado 01

Owner Name | Salt River Project Agricultural Improvement
Station Name | Coronado [NAME]
Unit Name | Coronado 01
NERC Region | WSCC
State | AZ
Fuel Type | Coal
Capacity | 411 MW
Start Date | 2001-11-29 00:00:00
End Date | 2001-01-09 00:00:00
Prv. Start Date | 2001-10-13 00:00:00
Prv. End Date | 2001-11-23 00:00:00
Comments | [NAME]
SIC | 4911
Plant ID | 1016260
Unit ID | 1007076
Outage ID | 9521
Spreadsheet: 805533d1668745913-consolidate-the-sum-of-numbers-in-multiple-rows-when-they-have-a-unique-reference-sample-problem
Sheet: Outcome

[NAME]. | SH-TO Name | Bill/ Date | Month | Year | Description | Material | Grid Value | EAN/UPC | Inv Quan | Sales unit | Division | SH-TO Zipc | SH-TO Street | SH-TO City | Region | Prod.hier. | Dead Weight | [NAME]
3890035589 | Customer 1 | 2022-01-05 00:00:00 |  |  | Product Names | 417962 |  | 792460350077 | 1 | PC | M | 4010 | Street Address | Suburb | NI | 34115 | 6.834 | 0.065772
3890035590 | Customer 2 | 2022-01-05 00:00:00 |  |  | Product Names | 423827 | 20 MT | 792460150264 | 1 | PC | M | 2571 | Street Address | Suburb | NI | 34213
3890035591 | Customer 3 | 2022-01-05 00:00:00 |  |  | Product Names | 482257 | S9 | 194151016208 | 2 | PC | M | 4310 | Street Address | Suburb | NI | 34112 | 7.28 | 0.03072
3890035592 | Customer 4 | 2022-01-05 00:00:00 |  |  | Product Names | 480124 | TBS  BL | 792460205827 | 1 | EA | M | 8042 | Street Address | Suburb | SI | 34424 | 19.635 | 0.108172
3890035593 | Customer 5 | 2022-01-05 00:00:00 |  |  | Product Names | 410759 | [NAME] | 792460367693 | 1 | EA | M | 9371 | Street Address | Suburb | SI | 34424 | 4.966 | 0.053887
Spreadsheet: fd9ec136-cf94-4e5a-aa08-90cca77fc2f9
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  | [NAME] |  |  |  |  | Elite
 |  | Championnat suisse de groupes
 |  | Gewehr 50m / carabine 50m
Stellung  Position: |  | Name + Vorname / Nom et prénom | Lizenz-Nr.   [NAME] no: |  | Name + Vorname / Nom et prénom | Lizenz-Nr.   [NAME] no: | Auswechselschütze tireurs remplaçants |  | Name + Vorname / Nom et prénom | Lizenz-Nr.   [NAME] no: | Auswechselschütze tireurs remplaçants
liegend/couché:
liegend/couché:
liegend/couché:
kniend/à genou:
kniend/à genou: |  |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  | [NAME]. / groupe no: |  |  |  | Elektronische Scheiben/                     Cibles électronique:
Verein/Société:
Vereinsnummer |  |  |  |  |  |  |  |  | Ja
 |  |  |  |  |  |  |  |  | [NAME]:
Gruppenchef/chef du group:
Name/Nome:
Adresse/adresse: |  |  |  |  |  |  |  |  | 1. [NAME].
PLZ+Ort/lieau |  |  |  |  |  |  |  |  | 1. Carton-no:
Tel./tél: |  |  |  |  |  |  |  |  | Elektronisch
E-Mail: |  |  |  |  |  |  |  |  | cibles électronique
Erläuterungen / remarques:
Bei Auswechselschützen muss ein x in die entsprechende Spalte eingetragen werden
Die Scheibenart muss mit einem x im entsprechenden Feld eingetragen werden
Die erste Nummer der ausgeteilten Kartons ist im entsprechenden Feld einzutragen.
Signalez les tireurs remplaçants par un x dans la colonne correspondante
Placez un x dans la case correspondant au type de cibles.
Le numéro du 1er des cartons distribués doit figurer dans la casse prévue à cet effet
Spreadsheet: 79261d1279552087-date-and-time-display-in-pivot-table-dummy_pvt
Sheet: Data

Consignee Code | Appointment ID | Scheduled Start Time | Gate In Time | Adj Gate In Time | [NAME] | [NAME] | Vendor # / Name
8L | 2821464 | 06/01/10 08:00 AM | 06/01/10 08:15 AM | 06/01/10 08:15 AM | 0.01041666666424135 | 0 hour(s) 15 min(s) Late | 66688      JOHN KEELER & CO INC
8L | 2823934 | 06/03/10 06:00 AM | 06/03/10 05:12 AM | 06/03/10 05:12 AM | -0.03333333333284827 | 0 hour(s) 48 min(s)  Early | 38112      DOT FOODS/SPECIAL ORDER DRY
8L | 2813096 | 06/04/10 02:00 PM | 06/07/10 09:21 AM | 06/07/10 09:21 AM | 2.806249999994179 | 67 hour(s) 21 min(s) Late | 1501      HERITAGE BAG CO
8L | 2837796 | 06/06/10 10:00 AM | 06/07/10 09:20 AM | 06/07/10 09:20 AM | 0.9722222222262644 | 23 hour(s) 20 min(s) Late | 5787      CASTELLINI COMPANY
8L | 2837804 | 06/06/10 10:00 AM | 06/07/10 09:20 AM | 06/07/10 09:20 AM | 0.9722222222262644 | 23 hour(s) 20 min(s) Late | 2841      CLUB CHEF INC
8L | 2837810 | 06/06/10 10:00 AM | 06/07/10 09:19 AM | 06/07/10 09:19 AM | 0.9715277777795563 | 23 hour(s) 19 min(s) Late | 53856      GRANT COUNTY FOODS
8L | 2788852 | 06/07/10 06:00 AM | 06/08/10 12:52 PM | 06/08/10 12:52 PM | 1.286111111112405 | 30 hour(s) 52 min(s) Late | 6820      R3/BUNZL-SPEC ORDER
8L | 2788852 | 06/07/10 06:00 AM | 06/08/10 12:52 PM | 06/08/10 12:52 PM | 1.286111111112405 | 30 hour(s) 52 min(s) Late | 2182      R3/BUNZL DISTRIBUTION
8L | 2795328 | 06/07/10 06:00 AM | 06/08/10 12:53 PM | 06/08/10 12:53 PM | 1.286805555559113 | 30 hour(s) 53 min(s) Late | 59196      HAUSBECK PICKLES/SUBWAY
8L | 2805321 | 06/07/10 06:00 AM | 06/07/10 06:14 AM | 06/07/10 06:14 AM | 0.00972222222480923 | 0 hour(s) 14 min(s) Late | 91334      MILLARD FROZEN SUBWAY
8L | 2806544 | 06/07/10 06:00 AM | 06/07/10 06:09 AM | 06/07/10 06:09 AM | 0.006249999998544808 | 0 hour(s) 9 min(s) Late | 3812      BAY STATE MILLING CO.
8L | 2808466 | 06/07/10 06:00 AM | 06/07/10 08:18 AM | 06/07/10 08:18 AM | 0.09583333333284827 | 2 hour(s) 18 min(s) Late | 22179      NEW WINCUP HOLDINGS
8L | 2816435 | 06/07/10 06:00 AM | 06/08/10 12:55 PM | 06/08/10 12:55 PM | 1.288194444445253 | 30 hour(s) 55 min(s) Late | 24024      RALCORP FRZ BAKERY/BAKERY CHEF
 |  |  |  | I want my pivot table display same as this format
Spreadsheet: 739737d1625905360-phone-format-00-to-1-or-86-excelphone
Sheet: Sheet1

Billing Country | Phone | Should be | remarks
Macedonia | 00389 2 2550 850
Trinidad and Tobago | [PHONE]
Italy | 0039 [PHONE]
Bahamas | [PHONE]
Trinidad and Tobago | [PHONE]
Nigeria | 00234-[PHONE]
United Kingdom | 0044-1457-860006
Belgium | 0032-14-578100
Macedonia | 00389 2 2461583
Jamaica | [PHONE]
Slovakia | 00421 33 640 00 71
Singapore | 0065 6221 1181
Portugal | 00351 217226110
Guyana | [PHONE]
France | 0033 4 78 04 41 04
Trinidad and Tobago | [PHONE]
China | 00852 2 8322060
Indonesia | 0062 21 - 5152-040
Belgium | 0032-2-7632222
Russia | [PHONE]
Jamaica | [PHONE]
Jamaica | [PHONE]
Trinidad and Tobago | [PHONE]
Macedonia | 00389-2-240-0850
Hungary | 0036-52-418-666
Czech Republic | 0042-[PHONE]
Ireland | 00353-1-8365007
United Kingdom | 00353-48-90738395
Czech Republic | 00420 272 690 799
Canada | [PHONE]
Slovakia | 00421 232115017
United Kingdom | 0044-20-8207 3222
Ireland | 00353 1 276 3500
Argentina | 0054 11 47 33 33 03
Spreadsheet: 697881d1601581019-scheduling-formula-if-this-criteria-is-met-copy-cell-text-to-a-different-page-simple-rn-schedule
Sheet: 2 Week Master

DATE |  |  | 2020-10-06 00:00:00 |  | 2020-10-07 00:00:00 |  | 2020-10-08 00:00:00 |  | 2020-10-09 00:00:00 |  | 2020-10-10 00:00:00 |  | 2020-10-11 00:00:00 |  | 2020-10-12 00:00:00 |  | 2020-10-13 00:00:00 |  | 2020-10-14 00:00:00 |  | 2020-10-15 00:00:00 |  | 2020-10-16 00:00:00 |  | 2020-10-17 00:00:00 |  | 2020-10-18 00:00:00 |  | 2020-10-19 00:00:00
Unit | Position | time | Sun |  | Mon |  | [NAME] |  | Wed |  | Thurs |  | Fri |  | Sat |  | Sun2 |  | Mon |  | [NAME] |  | Wed |  | Thurs |  | Fri |  | Sat
Medicare | Nurse | 6:30a-7p | [NAME] | 12
 | Nurse | 6:30p-7a |  |  | Jared | 12
 | QMA/Nurse | 6:30a-7p
 | QMA/Nurse | 6:30p-7a
 | C.N.A. | 6:30a-7p
 | C.N.A. | 6:30p-7a
 | C.N.A. | 6:30a-7p
 | C.N.A. | 6:30p-7a
A-wing | Nurse | 6:30a-7p | [NAME] | 12
 | Nurse | 6:30p-7a
 | QMA/Nurse | 6:30a-7p
 | QMA/Nurse | 6:30p-7a
 | C.N.A. | 6:30a-7p
 | C.N.A. | 6:30p-7a
 | C.N.A. | 6:30a-7p
 | C.N.A. | 6:30p-7a
B-wing | Nurse | 6:30a-7p
 | Nurse | 6:30p-7a
 | QMA/Nurse | 6:30a-7p
 | QMA/Nurse | 6:30p-7a
 | C.N.A. | 6:30a-7p |  |  | [NAME] | 12
 | C.N.A. | 6:30p-7a
 | C.N.A. | 6:30a-7p | Smith | 12
 | C.N.A. | 6:30a-7p
 | C.N.A. | 6:30p-7a
Isolation | Nurse | 6:30a-7p
 | Nurse | 6:30p-7a
 | QMA/Nurse | 6:30a-7p
 | QMA/Nurse | 6:30p-7a
 | C.N.A. | 6:30a-7p
 | C.N.A. | 6:30p-7a
 | C.N.A. | 6:30a-7p
 | C.N.A. | 6:30p-7a
HC Total
Hickory | Nurse | 7a-7:30p
 | Nurse | 7p-7:30a
 | QMA/Nurse | 7a-7:30p
 | QMA/Nurse | 7p-7:30a
 | C.N.A. | 6:30a-5p
 | C.N.A. | 9am-7pm
 | C.N.A. | 6:30a-5p
 | C.N.A. | 9am-7pm
MC Total
Hawthorn | Nurse | 7am-7:30p
 | Nurse | 8:30am-5p
 | Nurse | 7p-7:30a
 | QMA/Nurse | 7am-7:30p
 | QMA/Nurse | 7p-7:30a
 | C.N.A. | 7am-7:30p
 | C.N.A. | 6:30p-7a
 | C.N.A. | 3-11:30p
 | C.N.A. | 6:30p-7a
AL Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | total
Spreadsheet: 852711d1702656865-conditional-formatting-based-on-an-exact-or-non-exact-match-from-another-sheet-headshot-formatting
Sheet: elections

county | city | race | race | PR | WIN | candidate 1 | candidate 2 | candidate 3 | candidate 4 | candidate 5 | candidate 6
OAK | Sherwood | City Council | Seat 2 |  |  | [NAME] [inc.] | [NAME] | [NAME]
OAK | Forest City | Mayor |  |  |  | [NAME] [R-inc.] | [NAME] [D]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 34838d1232183575-possible-combinations-of-columns-workbook3
Sheet: Sheet1

Modifyers | Brands | Descriptor | Subjects |  |  | Brands | Descriptor | Subjects
discount | [NAME] | Ski | goggles |  | super sale | oakley | Ski | goggles
cheap | oakley | Snowboard | pants
wholesale | grenade | Snow | jacket
best price | L1 | Snow Board | shirt
low price | marker | Skiing | hat
outlet | helly hansen | Snowboarding | beanie
blowout | [NAME] | Snow Boarding | gloves
clearance | [NAME] | snowboards | mittens |  | Click to change value
deep discount | salomon | snow boards | sunglasses
closeout | dakine | winter
last season | anon | mountain
last year | red | outdoor
reduced | foursquare | downhill
80% off | special blend
75% off | analog
70% off | quiksilver
65% off | roxy
60% off | volcom
55% off
50% off
markdown
super sale
Spreadsheet: 373899d1422570947-percentage-formula-percentage
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | 0.25
 |  | A |  | B |  | C |  | D
 |  | 12 |  | 15 |  | 8 |  | 9
 |  | 13 |  | 15 |  | 15 |  | 15
 |  | 15 |  | 12 |  | 16 |  | 16
 |  | 18 |  | 12 |  | 14 |  | 18
 |  | 18 |  | 12 |  | 12 |  | 64
 |  | 15 |  | 31 |  | 31 |  | 12
 |  | 16 |  | 12 |  | 12 |  | 22
 |  | 12 |  | 31 |  | 22 |  | 13
 |  | 8 |  | 55 |  | 15 |  | 8
 |  | 1 |  | 18 |  | 17 |  | 15
 |  | 12 |  | 19 |  | 19 |  | 15
 |  | 12 |  | 15 |  | 18 |  | 16
 |  | 16 |  | 15 |  | 14 |  | 19
 |  | 18 |  | 4 |  | 16 |  | 22
 |  | 16 |  | 16 |  | 15 |  | 7
 |  | 17.5 |  | 18 |  | 13 |  | 18
 |  | 22 |  | 16 |  | 18 |  | 16
 |  | 23 |  | 19.5 |  | 33 |  | 17
 |  | 17 |  | 12 |  | 32 |  | 15
Spreadsheet: 268810d1380832724-sumproduct-formula-working-on-all-but-one-worksheet-2012-inpt-mb
Sheet: Aug

August |  |  |  |  |  |  | 8
 | SUMPRODUCT(--('Outpatient Data'!C:C=Aug!$A7),--('Outpatient Data'!F:F=Aug!$H$1),('Outpatient Data'!D:D))
Expenses | Total Expenses HTG | Total Expenses USD | Inpatient Total HTG | Inpatient Total USD | Outpatient Total HTG | Outpatient Total USD
bongu/juice
formula
patient food
medical supplies
medical services
medication
x-ray
office supplies
photocopy
other transportation
outpatient nurse for injections
employee compensation
school
other expenses
phone list
physical phone
telephone minutes
oxygen
volunteer expenses
patient transportation
Spreadsheet: 686089d1594356688-more-efficient-counta-sumif-and-sum-formulas-needed-for-training-spreadsheet-training
Sheet: Training 1

 | Training 1
 |  |  | 7:30am | 8:30am | 8:30am | 8:30am | 8:30am | 8:30am | 8:30am | 9:00am | 9:30am | 10:00am | 10:00am | 10:00am | 10:00am | 10:00am | 10:30am | 11:00am | 11:00am | 12:00pm | 12:00pm | 12:00pm | 12:00pm | 12:00pm | 12:00pm | 1:30pm | 1:30pm | 1:30pm | 1:30pm | 1:30pm | 2:00pm | 2:00pm
 | # of Sessions |  | 1
 | # of Expected on Training Day |  | 1 | 2 | 2 | 3 | 3 | 2 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 2 | 2 | 3 | 3 | 3 | 2 | 3 | 3 | 2 | 3 | 2 | 2 | 3 | 2 | 2 | 2 | 3
 | # [NAME] |  | 1 | 2 |  | 3 | 3 | 2 | 2 | 2 |  | 2 | 3 | 3 |  | 2 | 2 | 3 |  | 3 | 1 | 3 | 2 | 2 | 2 | 2 | 2 | 3 | 2 | 2 | 2 | 3
 | New Hire Show Rate
 | [NAME] | The same for training 1-6
 | C6: | Count Row 6 from column D and over, Only the cells with data entered in them
 | C7: | Sum of row 7 tfrom Column D and over "IF" Row 8 has data enetered
 | C8: | Sum of Row 8 from Column D and over
 | Column D and Over: | Manually entered.
Spreadsheet: 773312d1647787718-make-project-form-with-master-database-of-electrical-components-using-job-id-database-with-form
Sheet: Form

JOB ID |  | 8876
PROJECT NAME
S.# | Component [NAME] | Rating | Model | Make | Req. Qty. | Issued Qty. | Bal. Qty. | Breif [NAME] | Status | ETA
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
Spreadsheet: 872514d1718886281-help-with-complex-formula-sor-template-etaf
Sheet: SOR Code Rates

SOR Code | Item | Description | Item Type | Star Rate | Trade | Unit | Unit Price | Scope
Rate 1 | Upto 0.1m2 | seal floor or wall (one face) Opening up to 0.1m2 | SOR | No | General Building | ITEM | 10 | Excluded |  | 0 | Rate1
Rate 2 | upto 0.2m2 | seal floor or wall (one face) Opening up to 0.2m2 | SOR | No | General Building | ITEM | 20 | Excluded |  | 0.10000001 | Rate2
Rate 3 | upto 0.4m2 | seal floor or wall (one face) Opening up to 0.4m2 | SOR | No | General Building | ITEM | 100 | Excluded |  | 0.20000001 | Rate3
Rate 4 | upto 0.6m2 | seal floor or wall (one face) Opening up to 0.6m2 | SOR | No | General Building | ITEM | 200 | Excluded |  | 0.40000001 | Rate4
Rate 5 | upto 0.8m2 | seal floor or wall (one face) Opening up to 0.8m2 | SOR | No | General Building | ITEM | 250 | Excluded |  | 0.60000001 | Rate5
Rate 6 | upto 0.9m2 | seal floor or wall (one face) Opening up to 0.9m2 | SOR | No | General Building | ITEM | 290 | Excluded | 325 | 0.900000001 | [NAME]
 |  | Once it has the right SOR Code it would then fill in the correct unit cost allowing me to calculate the Total cost easily with one caveat if the total in column D is greater than 0.9m2 then it should use a fixed rate shown in cell J7 on the SOR Code rates.