tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 52466d1252220318-formula-help-for-if-or-len-left-book1-1-
Sheet: Sheet1

EXAMPLE/STEP ONE:
 |  | FORMULA |  | WANT TO DISPLAY
ABC | 123 | 123 |  | 123 | 123
BCD | 234 | IT'S BROKEN |  | 234 | 234
CDE | 345 | IT'S BROKEN |  | 345 | 345
DEF | 456 | IT'S BROKEN |  | 456 | 456
 |  |  |  |  | #N/A
EXAMPLE/STEP TWO: |  |  |  |  | 345
 |  |  |  |  | #N/A
FORWARD & INVERSE PAIRS |  |  |  |  | 456
ABC | 123 |  |  | 123 | 123
BCD | 234 |  |  | 234 | 234
CDE | 345 |  |  | 345 | 345
DEF | 456 |  |  | 456 | 456
CBA | 123 |  |  | 123 | 234
BCD | 234 |  |  | 234 | 234
EDC | 345 |  |  | 345 | 345
FED | 456 |  |  | 456 | 456
DATA I'M WORKING WITH:
ABC | 123 |  |  | 123 | 123 |  | KEY:
ABC | 123AA |  |  | 123 | 123AA |  | ABC & CBA = 123
ABC | 123BB |  |  | 123 | 123BB |  | BCD & DCB = 234
ABC | 123CC |  |  | 123 | 123CC |  | CDE & EDC = 345
ABC | 123DD |  |  | 123 | 123DD |  | DEF & FED = 456
BCD | 234 |  |  | 234 | 234
BCD | 234AA |  |  | 234 | 234AA
BCD | 234BB |  |  | 234 | 234BB
BCD | 234CC |  |  | 234 | 234CC
BCD | 234DD |  |  | 234 | 234DD
CDE | 345 |  |  | 345 | 345
CDE | 345AA |  |  | 345 | 345AA
CDE | 345BB |  |  | 345 | 345BB
CDE | 345CC |  |  | 345 | 345CC
CDE | 345DD |  |  | 345 | 345DD
DEF | 456 |  |  | 456 | 456
DEF | 456AA |  |  | 456 | 456AA
DEF | 456BB |  |  | 456 | 456BB
DEF | 456CC |  |  | 456 | 456CC
DEF | 456DD |  |  | 456 | 456DD
CBA | 123 |  |  | 123 | 234
CBA | 123AA |  |  | 123 | 234AA
CBA | 123BB |  |  | 123 | 234BB
CBA | 123CC |  |  | 123 | 234CC
CBA | 123DD |  |  | 123 | 234DD
BCD | 234 |  |  | 234 | 234EE
BCD | 234AA |  |  | 234 | 234EE
BCD | 234BB |  |  | 234 | 234EE
BCD | 234CC |  |  | 234 | 234EE
BCD | 234DD |  |  | 234 | 234EE
EDC | 345 |  |  | 345 | 345
EDC | 345AA |  |  | 345 | 345AA
EDC | 345BB |  |  | 345 | 345BB
EDC | 345CC |  |  | 345 | 345CC
EDC | 345DD |  |  | 345 | 345DD
FED | 456 |  |  | 456 | 456
FED | 456AA |  |  | 456 | 456AA
FED | 456BB |  |  | 456 | 456BB
FED | 456CC |  |  | 456 | 456CC
FED | 456DD |  |  | 456 | 456DD
Spreadsheet: 837456d1690193669-excel-formula-for-data-mining-test2
Sheet: Sheet1

AA1234 | 123
AA1234 | 456
AA1234 | 789
BB1234 | 789
BB1234 | 456
CC1234 | 234
CC1234 | 456
Spreadsheet: phillip_allen__29899__Post_close_utilities
Sheet: Sheet1

 |  |  |  |  |  | Stagecoach Apartments
 |  |  |  |  |  | Post Closing Utility Summary
 | Unit | April 9 - May 7 |  | [NAME]'s share* |  | [NAME]'s share |  | May 8 -June 12 |  | Total
 | 1-4 | 176.88 |  |  |  |  |  | 227.25
 | 5-8** | 781.25
 | 9-12 | 125.05 |  |  |  |  |  | 224.12
 | 13 | 44.91 |  |  |  |  |  | 76.44
 | 14 | 54.64 |  |  |  |  |  | 86.98
 | 15 | 39.89 |  |  |  |  |  | 79.45
 | 16 | 60.22 |  |  |  |  |  | 84.41
 | 17 | 49.3 |  |  |  |  |  | 77.75
 | 18 | 57.28 |  |  |  |  |  | 76.25
 | 19 | 41.15 |  |  |  |  |  | 66.78
 | 20 | 47.74 |  |  |  |  |  | 72.23
 | 21 | 40.46 |  |  |  |  |  | 20.22
 | 22 | 36.95 |  |  |  |  |  | 47.51
 | 23 | 42.28 |  |  |  |  |  | 52.22
 | 24 | 78.49 |  |  |  |  |  | 143.46
 | 25 | 35.94 |  |  |  |  |  | 51.27
 | 26 | 50.63 |  |  |  |  |  | 92.76
 | 27 | 72.4 |  |  |  |  |  | 114.84
 | 28 | 73.02 |  |  |  |  |  | 98.53
 | 29 | 65.19 |  |  |  |  |  | 98.96
 | 30 | 45.23 |  |  |  |  |  | 66.9
 | 31 | 50.43 |  |  |  |  |  | 58.87
 | 32 | 29.1 |  |  |  |  |  | 47.26
 | 33 | 54.02 |  |  |  |  |  | 65.9
 | 34 | 65.31 |  |  |  |  |  | 89.49
 | 35 | 60.29 |  |  |  |  |  | 99.03
 | 36 | 52.19 |  |  |  |  |  | 81.02
 | 37 | 58.16 |  |  |  |  |  | 88.11
 | 38 | 59.29 |  |  |  |  |  | 47.33
 | 39 | 76.48 |  |  |  |  |  | 107.25
 | 40 | 85.39 |  |  |  |  |  | 109.26
 | 41 | 62.86 |  |  |  |  |  | 89.55
 | 42 | 58.28 |  |  |  |  |  | 91.06
 | 43 | 36.25 |  |  |  |  |  | 55.29
 | 44 | 60.17 |  |  |  |  |  | 115.1
 | HSMTR | 24.58 |  |  |  |  |  | 30.15
 | Water 7th | 108.5 |  |  |  |  |  | 192.15
 | Water | 191.04 |  |  |  |  |  | 233.44
 | Water 30-39 | 182 |  |  |  |  |  | 202.65
 | Water 41-43 | 61.25 |  |  |  |  |  | 97.65
 | Water 44 | 80.79 |  |  |  |  |  | 96.94
 | Total
 | *The bill covering period April 9th to May 7th was prorated 11 of 28 days to the seller.
 | **Apartments 5-8 are on a different cycle. The bill covering March 23 to April 24 was
 | prorated 28 of 32 days to the seller.
Spreadsheet: 220367d1363131085-copy-data-from-other-sheets-by-typing-in-unique-identifier-from-them-example
Sheet: Fruit

FOOD | MAIN INGREDIENT | WEIGHT | UNIQUE CODE | PRICE
Apple | Apple | 0.2 | Fruit01 | 1
Orange | Orange | 0.3 | Fruit02 | 1.2
[NAME] | [NAME] | 0.6000000000000001 | Fruit03 | 1
Blueberry | Blueberry | 0.6000000000000001 | Fruit04 | 1.2
Spreadsheet: eab95850-d70e-4680-a381-2985c145ba0d
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
FCOCN | Test | FCOCN | [NAME] | [NAME] | Enzyme Immunoassay (FEIA) |  |  |  |  |  | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | <2 mcg/mL   The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG tests has not been established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food-related complaints. It should be recognized that the presence of food-specific IgG alone cannot be taken as evidence of food allergy and only indicates immunologic sensitization by the food allergen in question. This test should only be ordered by physicians who recognize the limitations of the test.  Test Performed by:	Viracor-IBT Laboratories 			1001 NW Technology Dr. 			Lee's Summit, MO 64086 | Monday through Friday | 3 days | 5 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FCOCN | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FCOCN | Result | FCOCN | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 105942d1303216776-index-indirect-match-help-projbudg
Sheet: ActualDaysWorked

 |  |  |  |  | 2009-06-08 00:00:00
Name | Role | Total Days | Rate |  | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F | M | T | W | T | F
 | Project Manager-external |  | 0
 | Project Manager - internal |  | 0
 | Agresso Senior Financial Consultant |  | 0
 | Agresso HR/Payroll Consultant |  | 0
 | [NAME] Manager |  | 0
 | [NAME] |  | 0
 | [NAME] |  | 0
 | [NAME] HR Consultant |  | 0
 | [NAME] HR Consultant |  | 0
 | [NAME] |  | 0
 | [NAME] |  | 0
 | [NAME] |  | 0
 | [NAME] |  | 0
 | [NAME]/PCB consultant |  | 0
 | [NAME]/PCB consultant |  | 0
 | Agresso Technical Consultant |  | 0
 | Agresso Technical Trainer |  | 0
 | Agresso Technical Consultant |  | 0
 | [NAME] |  | 0
 | [NAME] |  | 0
 | [NAME] |  | 0
 | [NAME] |  | 0
 | KCS Consultant |  | 0
 | Infor Consultant - Data Migration |  | 0
 | Infor Consultant - Interfaces |  | 0
 | Infor Consultant - Interfaces |  | 0
 | ImageNow Consultant |  | 0
 | Agresso Technical Consultant |  | 0
 | [NAME]) |  | 0
 | [NAME] consultant |  | 0
 | [NAME] |  | 0
 | Agresso Data Migration |  | 0
 | [NAME] |  | 0
 | [NAME] |  | 0
 | [NAME] |  | 0
 | [NAME] Consultant |  | 0
 | [NAME] |  | 0
 | [NAME] and enquiry /excellerator trainers |  | 0
 | Agresso Technical Consultant |  | 0
 | Agresso HR/Payroll DM Consultant |  | 0
 | [NAME] |  | 0
 | [NAME] |  | 0
 | [NAME] HR report consultant |  | 0
 | Business Implementation support consultant |  | 0
 | Data migration |  | 0
 | Procedures Developer |  | 0
 |  |  |  | Invoice for time and expenses
 |  |  |  | Invoice for expenses only
 |  |  |  | Invoice for time only
 |  |  |  | Invoice for training
 |  |  |  | Project mgt build
Spreadsheet: 707406d1607251206-using-a-list-to-reduce-worksheets-midshires-master
Sheet: WL

 |  |  |  | ADJUSTED HANDICAP |  |  |  |  |  | OFFICIAL HANDICAP |  |  |  |  | HANDICAPPING ALTERATIONS
hole | par | S/I | SHOTS | CALC | points | PAR 3 | SI/1 | SI/2 | S1/3 | SI/1 | S1/2 | S1/3 | CALC | points | EXACT | catagory | BUFFER | css | Nett | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAP |  | ZONE |  | Differential
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out |  |  |  |  |  | TOTAL
total
Spreadsheet: 888654d1739222071-change-format-of-data-diabetes-27-apr-2017-to-23-april-2018
Sheet: Table 40

00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Sun 4 Mar Glucose mmol/L
Mon 5 Mar Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Tue 6 Mar Glucose mmol/L
 |  |  |  |  | 6.3
Wed 7 Mar Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
 |  |  |  |  |  | 6.7
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
[NAME]L
Fri 9 Mar Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Sat 10 Mar Glucose mmol/L
Legend          High Glucose (>13.3)            Low Glucose (<3.9)
Sun 11 Mar Glucose mmol/L
Spreadsheet: 708072d1607608577-simplifying-a-very-old-worksheet-bourn
Sheet: Clarke

hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | INDEX 1 | INDEX 2 | INDEX 3 | points | handicap | handicap | HANDICAPPING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 80523d1280762194-updating-monthly-total-test1-1
Sheet: January

Items | Requested
A | 1
B | 2
C | 3
D | 4
E | 5
F | 6
G | 7
H | 8
I | 9
Spreadsheet: stacey_white__39170__Pre-bankruptcy Payouts
Sheet: Sheet1

 | Pre-bankruptcy Payouts
In Legal Pre-Petition Packet? | Counterparty | Cash In | Related Commodities | Commodity MTM | Commodity Receivable / (Payable) | % of Total Cash In | Net Gain / (Loss) | Comments
Yes | The Energy Authority | 724333.25 | Power |  | 111664
 |  |  | Gas
Yes | BP Capital Energy Equity International Holdings I, Ltd. | 541000 | Natural Gas Only
Yes | BP Capital Energy Equity Fund, L.P. |  | Financial (Non-power)
Yes, but amount not confirmed | Southern California Edison Company, PG& E Energy Trading-Power, L.P. | 5000000 | Power (assignment # 461072)
No | Public Service Company of Colorado | 6000000 | Power |  | -2200000
 |  |  | Gas
Yes | UGI Utilities, Inc. | 1460000 | Gas
Yes | NUI Energy Brokers, Inc. | 42900000 | No Power
No | Pemex | 4122000
Yes | International Paper Company | 12163283 | Gas & Financial
Yes | Constellation Power Source, Inc. | 45000000 | Power (Physical Only) |  | 6902944.75 |  |  | Per Contract: $45 MM = Physical Power, ($3) MM = All Financial Commodities
 |  | -3000000 | Financial (including weather) - no power
 |  |  | Physical Gas
 |  |  | Coal
 |  |  | Emissions
No | Bear Stern | 541000
No | Socal - J.P. Morgan | 1200000
No | [NAME] | 7063860
Yes | Michigan Consolidated Gas Company | 0 | Firm Gas Storage Contract
Yes | Sprague Energy Corp. | 14000000 | Gas Only
Yes | Thermo Cogeneration Partnership LP | 274396 | Gas Only
Yes | Wells Fargo Bank N.A. | 43638 | Gas Only
Yes | Wells Fargo Bank N.A. | 32280 | Timber Only
Spreadsheet: 127243d1320251897-count-values-in-a-range-that-appear-for-specific-dates-test-sheet
Sheet: Sheet3

DATE | TIME | Code1 | Code | First Name | Surname | Area
2011-10-31 00:00:00 | 2011-10-31 17:25:00 | 400440847 | 4004 | Names | Names | [NAME]
2011-10-31 00:00:00 | 2011-10-31 17:30:00 | 436840847 | 4368 | "" | "" | [NAME]
2011-10-31 00:00:00 | 2011-10-31 11:00:00 | M17502040847 | M175020 | "" | "" | [NAME]
2011-10-31 00:00:00 | 2011-10-31 16:15:00 | 434740847 | 4347 | "" | "" | Area2
2011-10-31 00:00:00 | 2011-10-31 14:10:00 | 436640847 | 4366 | "" | "" | Area2
2011-10-31 00:00:00 | 2011-10-31 19:50:00 | 381340847 | 3813 | "" | "" | Area3
2011-10-30 00:00:00 | 2011-10-30 17:25:00 | 400440847 | 4004 | "" | "" | [NAME]
2011-10-30 00:00:00 | 2011-10-30 17:30:00 | 436840847 | 4368 | "" | "" | Area4
Spreadsheet: 03ede496-e4f6-4434-9f77-6c3155c714f0
Sheet: Sheet1

ACQUISITIONS UNIT | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
SERIAL STATISTICS - 2003/2004
 | JUL | AUG | SEP | OCT | NOV | DEC | JAN | FEB | MAR | APR | MAY | JUN | YTD
[NAME] | 81 | 92 | 40 | 11 | 6 | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 238
Titles added | 6 | 4 | 12 | 3 | 3 | 0 | 7 | 9 | 4 | 9 | 2 | 1 | 60
[NAME] added | 284 | 303 | 318 | 595 | 374 | 162 | 227 | 421 | 410 | 340 | 449 | 562 | 4445
-To checklist | 72 | 78 | 106 | 60 | 74 | 84 | 54 | 52 | 80 | 74 | 46 | 79 | 859
-By binding | 212 | 225 | 212 | 535 | 300 | 78 | 173 | 369 | 330 | 266 | 403 | 483 | 3586
[NAME] processed | 1755 | 899 | 811 | 1596 | 1156 | 513 | 978 | 1048 | 1336 | 1504 | 1450 | 441 | 13487
[NAME] temp bound | 125 | 55 | 0 | 10 | 84 | 5 | 205 | 71 | 12 | 118 | 62 | 1 | 748
[NAME] mended | 234 | 11 | 30 | 47 | 86 | 44 | 44 | 54 | 44 | 73 | 0 | 0 | 667
Mform pieces added | 1105 | 1131 | 1827 | 1305 | 1298 | 1466 | 1489 | 1283 | 1131 | 1095 | 1164 | 1181 | 15475
-Mfilm | 13 | 17 | 14 | 24 | 9 | 15 | 32 | 26 | 12 | 16 | 14 | 17 | 209
-Mfiche | 1092 | 1114 | 1813 | 1281 | 1289 | 1451 | 1457 | 1257 | 1119 | 1079 | 1150 | 1164 | 15266
Claims | 190 | 168 | 198 | 225 | 149 | 90 | 199 | 142 | 150 | 126 | 180 | 104 | 1921
Spreadsheet: 881809d1730009566-table-planner-for-an-event-adding-peoples-names-to-a-specific-table-table-booking
Sheet: Summary

 | Status | Number
 | Awaiting Response
 | Possible
 | Confirmed
 | Paid Deposit
 | Paid Full Amount
 | Dropped Out
 | Table Allocations | Number | Dietry needs
 | Table 1
 | Table 2
 | Table 3
 | Table 4
 | Table 5
 | Table 6
 | Table 7
 | Table 8
 | Table 9
 | Table 10
 | Table 11
 | Reserve
Spreadsheet: 843097d1695056235-filter-specific-column-base-on-user-selection-my-formula-not-working-filter-by-area
Sheet: Sheet1

Name | Region | Inv | Amount |  | Region
A | North | #1 | 10 |  | North | x |  | Name | Invoice |  | South | West |  |  | Name | Invoice | South | East | West
B | East | #2 | 20 |  | South | x | Why is it not working?--> |  |  |  |  |  |  |  | B | #2 |  | 20 |  |  | <---- What I want
C | North | #3 | 30 |  | East |  |  |  |  |  |  |  |  |  | D | #4 |  |  | 40
D | West | #4 | 40 |  | West | x |  |  |  |  |  |  |  |  | E | #5 |  | 50
E | East | #5 | 50 |  |  |  |  |  |  |  |  |  |  |  | F | #6 | 60
F | South | #6 | 60 |  |  |  |  |  |  |  |  |  |  |  | A | #8 |  | 80
F | North | #7 | 70 |  |  |  |  |  |  |  |  |  |  |  | C | #10 |  | 100
A | East | #8 | 80 |  |  |  |  |  |  |  |  |  |  |  | D | #11 |  | 110
B | North | #9 | 90 |  |  |  |  |  |  |  |  |  |  |  | E | #12 | 120
C | East | #10 | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <---- Possible to Vstack a total at end?
D | East | #11 | 110
E | South | #12 | 120
F | North | #13 | 130
 |  |  |  |  |  |  |  |  | False | False
 |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  | True | False | False
 |  |  |  |  |  |  |  | False | False | True
 |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  | False | True | False
 |  |  |  |  |  |  |  | True | False | False
 |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  | True | False | False
 |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  | False | False | False
 |  |  |  |  |  |  |  | False | True | False
 |  |  |  |  |  |  |  | True | False | False
Spreadsheet: 266727d1379704579-nested-formula-function-to-count-unique-entries-excel_forum_query
Sheet: DAY TO DAY

DATE | DAY OF WEEK | Event Location | Event Coordinator | CON. # | FIRST NAME | LAST NAME | Event Manager
2013-09-30 00:00:00 | Monday | Location A | Mr B | 123 | [NAME] | Jones | Billy
2013-09-30 00:00:00 | Monday | Location B | Mr B |  | [NAME] | Jones | Billy
2013-09-30 00:00:00 | Monday | Location A | Mr B | 123 | [NAME] | Jones | Billy
2013-09-30 00:00:00 | Monday | Location C | Mr B |  | [NAME] | Jones | Billy
2013-09-30 00:00:00 | Monday | Location A | Mr B | 123 | [NAME] | Jones | Billy
2013-09-30 00:00:00 | Monday | Location A | Mr B | 123 | [NAME] | Jones | Billy
2013-10-01 00:00:00 | Tuesday | Place 1 | Mr B | 123 | [NAME] | Jones | Billy
2013-10-01 00:00:00 | Tuesday | Place 1 | Mr B | 123 | [NAME] | Jones | Billy
2013-10-01 00:00:00 | Tuesday | Place 1 | Mr B | 123 | [NAME] | Jones | Billy
2013-10-01 00:00:00 | Tuesday | Place 2 | Mr B | 123 | [NAME] | Jones | Billy
2013-10-01 00:00:00 | Tuesday | Place 2 | Mr B | 123 | [NAME] | Jones | Billy
2013-10-01 00:00:00 | Tuesday | Place 1 | Mr B | 123 | [NAME] | Jones | Billy
2013-10-01 00:00:00 | Tuesday | Place 1 | Mr B | 123 | [NAME] | Jones | Billy
2013-10-01 00:00:00 | Tuesday | Place 1 | Mr B | 123 | [NAME] | Jones | Billy
2013-10-01 00:00:00 | Tuesday | Place 3 | Mr B | 123 | [NAME] | Jones | Billy
2013-10-01 00:00:00 | Tuesday | Place 3 | Mr B | 123 | [NAME] | Jones | Billy
2013-10-01 00:00:00 | Tuesday | Place 4 | Mr B | 123 | [NAME] | Jones | Billy
Spreadsheet: 767364d1644427811-making-a-schedule-for-part-time-employees-employee-list-tracker-reference
Sheet: Sheet1

 | TL Nola Val Mobile Team | Mon- Wed Shift | Wed - Fri Shift | Full Time | On the Tracker Check list | Make Sure on list for Today | Today's Date | Day of the week
 | [NAME] | False | False | True | False | - |  |  |  | = Not required on Task Tracker
 | [NAME] | False |  | True |  | -
 | [NAME] | False | False | True
 | [NAME] | False |  | True
 | [NAME] | False |  | True
 | [NAME] |  |  | True
 | [NAME] |  |  | True |  | -
 | [NAME] |  |  | True |  | -
 | [NAME] |  |  | True
 | [NAME] |  |  | True
 | [NAME] |  |  | True
 | Tristen lacoste | True
 | [NAME] | True
 | [NAME] |  |  | True
 | [NAME] |  |  | True
 | [NAME] | True
 | [NAME] |  |  | True
 | [NAME] |  | True
 | [NAME] | True
 | [NAME] | True
 | [NAME] |  |  | True
 | [NAME] |  |  | True |  | -
 | Danielle Tanguis |  |  | True
 | [NAME] |  |  | True
 | [NAME] |  | True
 | Tyler Plaisance |  |  | True
 | [NAME] | True
 | [NAME] |  |  | True
 | [NAME] |  |  | True
 | [NAME] |  |  | True
 | [NAME] |  |  | True
 |  |  | False
 |  |  |  |  | Working on [NAME], not updating properly
 |  |  |  |  | MON TO WED fORMULA ---->
 |  |  |  |  | WED TO FRI fORMULA ---->
 |  |  |  |  | Full Time Formula ------>
Spreadsheet: 8ffddd12-3b15-428b-8fa1-056331749050
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | EcoCheck Data: Choptank River for 2010
Indicator | 2010
Chlorophyll a | 8.982
Aquatic Grasses | 4.12
[NAME] | 90.739
[NAME] | 30.86565
Water Clarity | 48.984
Phytoplankton Index | 13.86
Water Quality Index | 49.56833333
Biotic Index | 16.28188333
Bay Health Index | 32.92510833
Spreadsheet: 693011d1598698239-conditional-formating-with-equal-or-more-with-problems-monte
Sheet: Folha2 (2)

 |  | FR. | DÍV 2019 | 1ºT |  |  | 2ºT |  |  | 3ºT |  |  | 4ºT
 |  | A
 |  | B
 |  | C
 |  | D
 |  | E
 |  | F
 |  | G
 |  | H
 |  | I
 |  | J
 |  | L
 |  | M
 |  | N
 |  | O
 |  | P
 |  | Q
 |  | R
 |  | S
 |  | T
 |  | U
 |  | V
 |  | X
 |  | Z
 |  | AA
Spreadsheet: 0ff25ebc-3fa2-4fc5-8904-a6fbbc9cd04d
Sheet: Encode_Services

 | Annex 3 - Consortium's services
S# | A_TYPE | SERVICE_TYPE
1 | A01
2 | A01
3 | A01 | …
4 | A02
5 | A02
6 | A02 | …
7 | A03
8 | A03
9 | A03 | …
10 | A05
11 | A05
12 | A05 | …
13 | A06
14 | A06
15 | A06 | …
Spreadsheet: 122725d1317105838-conditional-formatting-formula-data-range-elfiky-2011-09-26
Sheet: Stoplight

 |  |  |  |  |  |  | 0 - 1.49 = Red
 |  |  |  |  |  |  | 1.5-2.49 = Yellow
 |  |  |  |  |  |  | 2.5-3.49= Green
 |  |  |  |  |  |  | >3.5 = Blue
Metric |  | Weight | Overall Category Weight | Current Performance Stats |  |  | Overall Category Performance | Key Performance Drivers/Comments | 2011 Target B,G,Y,R | Frequency | Data Timing | Data Source
Client Satifaction
Annual Survey |  | 0.75 | 0.3 |  | Accessible |  |  | No score automatic yellow | Truly Loyal
 |  |  |  |  |  |  |  |  | Accessible
 |  |  |  |  |  |  |  |  | Vulnerable
 |  |  |  |  |  |  |  |  | At Risk
Quarterly Survey |  | 0.25 |  |  | Good |  |  | * No score automatic yellow * Qtrly Score but no annual score this weights 50% * No score on either automatic red | Excellent
 |  |  |  |  |  |  |  |  | Good
 |  |  |  |  |  |  |  |  | Fair
 |  |  |  |  |  |  |  |  | Poor
Client Satifaction
Spreadsheet: 684168d1593181136-need-formula-to-move-data-from-multiple-row-to-single-row-having-different-number-of-rows-multiple-rows
Sheet: Sheet1

Phone number | Plan Name | Price
10213456 | Plan A | 5
10213456 | Plan B | 10
10213456 | Plan C | 6
10213456 | Plan D | 4
71891011 | Plan B | 8
71891011 | Plan C | 9
71891011 | Plan A | 10
71891011 | Plan D | 12
71891011 | Plan E | 22
12131415 | Plan B | 15
12131415 | Plan C | 18
12131415 | Plan D | 14
12131415 | Plan A | 6
17181920 | Plan A | 5
17181920 | Plan B | 4
17181920 | Plan C | 3
17181920 | Plan D | 2
17181920 | Plan E | 12