tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 80f73d72-931a-43d6-bcc0-97f8e0c731a8
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
[NAME] | Test | [NAME] | Apolipoprotein A-I (APOA1) Gene, Known Mutation | APOA1 Gene, Known Mutation | Polymerase Chain Reaction (PCR) Followed by DNA Sequence Analysis (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | VACUTAINER: VAC |  |  | 3 | mL | This test can only be performed if a mutation has previously been identified in a family member of this individual.   [NAME] must arrive within 96 hours of draw.   [NAME] blood Container/Tube: Preferred: Lavender top (EDTA) or yellow top (ACD) Acceptable: Any anticoagulant [NAME]: 3 mL Collection Instructions: 1. Invert several times to mix blood. 2. Send specimen in original tube. Forms:	 1. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. 2. Molecular Genetics-Congenital Inherited Diseases Patient Information Sheet (Supply T521) in Special Instructions | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	Plasma or serum | An interpretive report will be provided. | Wednesday 10 am | 10 days | 16 days | 1 | 81479 |  |  |  |  | Rochester
[NAME] | [NAME] | VARIES | Varies |  |  |  | Ambient
[NAME] | Result | 33393 | [NAME] | [NAME] | Alphanumeric
[NAME] | Result | 33394 | [NAME] | [NAME] | Alphanumeric
[NAME] | Result | 33395 | Source | Source | Alphanumeric
[NAME] | Result | 33396 | Order Date | Order Date | Alphanumeric
[NAME] | Result | 33397 | Reason For Referral | Reason For Referral | Alphanumeric
[NAME] | Result | 33398 | Method | Method | Alphanumeric
[NAME] | Result | 33399 | Result | Result | Alphanumeric
[NAME] | Result | 33400 | Interpretation | Interpretation | Alphanumeric
[NAME] | Result | 33401 | Amendment | Amendment | Alphanumeric
[NAME] | Result | 33402 | Reviewed By | Reviewed By | Alphanumeric
[NAME] | Result | 33403 | Release Date | Release Date | Alphanumeric
Spreadsheet: 108799d1305765144-excel-2007-specific-time-period-calculation-from-a-time-range-book1
Sheet: Sheet1

2011-01-04 16:40:00 | 2011-01-04 22:05:00
2011-01-05 00:18:00 | 2011-01-05 08:42:00
2011-01-07 19:15:00 | 2011-01-07 23:47:00 |  |  | 04:32:00
 |  |  |  | Blank
2011-01-29 07:25:00 | 2011-01-29 11:00:00 |  |  | Blank
Spreadsheet: 99438d1298052031-predetermined-sliding-scale-book2
Sheet: Sheet1

type | A | B | C
Total # of users | photoshop | Illustrator | Photoshop + Illustrator
0 - 9 | 12 | 11 | 20
10 - 39 | 11 | 10 | 19
40 - 79 | 10 | 9.5 | 18.5
80 - 149 | 9 | 9 | 16
150 - 229 | 8 | 7.5 | 13
230 - 349 | 7 | 6 | 10
350 - 499 | 6 | 3 | 9
500 - 749 | 5 | 2 | 8
750 - 999 | 4 | 1.5 | 7
 |  | Sept
 |  | Users
Mo | All | 52 | Total user Usage % | Pays # of mo | Pay for  # of users | User Cost
Project A | C | 150
Project B | C | 8
Project C | B | 10
Project D | A | 11
total P Users
total all
Spreadsheet: 740880d1626672622-how-to-count-the-number-of-blank-cells-719forumhelp-ans
Sheet: Sheet1

 | DEPT | 1 | 2 | 3 | 4 | 5 | Count | FORMULA
 | A |  | 4
 | A |  |  | 4 | 3 | 4
 | A |  | 4 | 3 | 4 | 4
 | A | 4 | 4 |  | 3
 | A |  | 4 | 3 |  | 4
 |  | 0.4 | 0.4 | 0.3333333333333334 | 0.3333333333333334 | 0.4 | 11 | 11
 | B | 4 | 4 | 4 | 3 | 4
 | B | 3 | 4 | 3 | 4 | 3
 | B | 4 | 5 | 4 | 4 | 5
 | B | 3 | 3 | 3 | 3 | 4
 | B |  | 3 | 2 | 3 | 2
 | B | 4 | 4 | 4 | 3 | 4
 | B | 3 | 3 | 3 | 3 | 2
 | B |  | 4 | 4 | 5 | 4
 | B | 4 | 5 | 4 | 4 | 4
 | B | 5 | 5 | 5 | 4 | 5
 |  | 0.3666666666666667 | 0.4 | 0.3625 | 0.35 | 0.375 | 2 | 2
 | C |  | 4
 | C |  |  | 4 | 3 | 4
 | C |  | 4 | 3 | 4 | 4
 | C | 4 | 4 |  | 3
 | C |  | 4 | 3 |  | 4
 |  |  |  |  |  |  | 11 | 11
 | D | 3 | 4 | 5 | 4 | 5
 | D | / | 3 | 3 | 3 | 4
 | D | 4 | 4 | 4 | 3 | 5
 | D | 3 | 3 | 4 | 5 | 5
 | D | / | 4 | 4 | 3 | 4
 | D | / | 4 | 3 | 3 | 4
 | D | / | 4 | / | 3 | 5
 | D | 3 | 4 | 4 | 5 | 3
 | D | / | 2 | 2 | 2 | 1
 | D | / | 3 | 3 | 3 | 2
 | D | / | 3 | 3 | 3 | 4
 | D | 3 | 4 | 4 | 3 | 4
 | D | 3 | 4 | 5 | 3 | 5
 | D | 4 | 4 | 4 | 4 | 4
 | D | 4 | 4 | 3 | 4 | 4
 | D | 3 | 4 | 4 | 3 | 4
 | D | 2 | 2 | 3 | 3 | 3
 | D | 4 | 4 | 4 | 4 | 5
 | D | 4 | 4 | 4 | 4 | 4
 | D | 3 | 5 | 4 | 4 | 3
 | D | 4 | 5 | 4 | 5 | 4
 |  |  |  |  |  |  | 0 | 0
Spreadsheet: 273436d1382711824-table-with-a-number-equaling-a-formula-book2
Sheet: Sheet1

 | Height | [NAME] | SF | ASSY SUB TOTAL | Add Sol Cool Glass | Add Low E | Add Solid Panel | Add Self Closing | Add locks (+ $42 per assembly) | Track Only | Doors (Pair) Only
Net Opening |  |  |  |  |  |  | Contact
[NAME] |  |  |  |  |  |  | [NAME] |  | 42
Door Size
Door [NAME] |  |  | to be used when ordering doors only based on net opening specs
Doors Only |  |  |  |  |  |  | N/A |  | 21
Door Size |  |  | to be used if ordering doors only with set measurements
Doors Only |  |  |  |  |  |  | N/A |  | 21
No Glass Calculations Below
Net Opening - No Glass
[NAME] |  |  |  |  | N/A | N/A |  | N/A | N/A | N/A
Door [NAME]
Door [NAME] |  |  | to be used when ordering doors only based on net opening specs
Doors Only |  |  |  |  |  |  | N/A |  | 21
Spreadsheet: 139182d1328117937-list-boxes-in-combination-assets
Sheet: Sheet1

 | Asset Type | Asset Class
 | Water Mains | Unlined Cast Iron |  | Water Mains | General Assets | Pumping | Treatment Systems | Storage, Civil and Concrete Structures. | Network Services | Electrical Assets | Control Systems | Water Quality meters
 | General Assets | Plant inlet [NAME] |  | Unlined Cast Iron | Plant inlet [NAME] | Pumps less than 5kW | Flouride metering systems and pipework | Concrete Tanks and Storages | Water Services | A | PLC Units | Turbidimeters/Turbidity meters
 | Pumping | Pumps less than 5kW |  | Insitu Lined Cast Iron with Lead Jointing |  | Pump/Motor Units 5kW-20kW | Sulphuric Acid Systems | Dams and [NAME] |  | B | Printed circuit control cards | Aluminium analysers
 | Treatment Systems | Alum Dosing Systems |  | DICL with Rubber Ring Jointing |  | Pump/Motor Units 20kW-50kW | Alum Dosing Systems | Steel and lined Timber tanks |  | C | Computers | [NAME]
 | Storage, Civil and Concrete Structures. | Dams and [NAME] |  | [NAME] |  | Pump/Motor Units 50kW-200kW | Lime Dosing Systems | Evaporation Basins (Rehabilitation Cycle) |  |  | Chemical dosing control systems (General) | pH meters
 | Network Services | Water Services |  | PVC |  | Pump/Motor Units 200kW-1200kW | Potassium Permanganate Systems | Manholes |  |  | Telemetry Systems (Central)
 | Electrical Assets | A |  | HDPE, MDPE, PE (Assume appropriate selection) |  | Pump Motor Units Greater than 1200kW | Activated Carbon | Filter structure |  |  | Telemetry Systems RTUs
 | Control Systems | Turbidimeters/Turbidity meters |  |  |  | Flocculators | Poly electrolyte systems | Storage tank roofs
 | Water Quality meters | Aluminium analysers |  |  |  | Instrument air compressors | Sand Filtration underdrain | Building Roofs
 |  |  |  |  |  | Air blowers
 | or |  |  |  |  | Cranes and fixed lifting equipments
 | Pumping | Pump/Motor Units 5kW-20kW
Spreadsheet: 30699d1226393888-excel-2007-customer-retention-models-example-worksheet
Sheet: Sheet1

August | September | October | November | December | January | February | March | April | May | June | July
123 | 3456 | 34 | 34
231 | 34 | 890 | 890 | etc…
312 | 326457 | 312 | 312
254453 | 2354 | 444 | 444
46434 | 34568 | 222 | 222
234 | 890 | 7856 | 111
3345 | 465 | 666 | 4444
5756 | 5756 | 777 | 5555
34756 | 312 | 888 | 6666
Spreadsheet: 16576474-b68c-4d66-a241-d0ecc93ae4ea
Sheet: Age Group Information

Recommendations on the Amount of Tournaments and Amount of Travel |  |  | ***Please note these are guidelines and can be adjusted as needed
U9-U11 | # of Tournaments per season | # of "away" tournaments per season
Red/Black | 2 to 3 | 1
White/Silver | 1 to 2 | 0 to 1
U12-U14 | # of Tournaments per season | # of "away" tournaments per season
Red/Black | 2 to 4 | 1 to 2
White/Silver | 1 to 2 | 1
U15-U18 | # of Tournaments per season | # of "away" tournaments per season
Red | 3 to 5 | 2 to 3
Black | 2 to 4 | 2 to 3
White/Silver | 1 to 3 | 1 to 2
Spreadsheet: 842384d1694481483-help-with-ifs-statements-cpp-test-spreadsheet-v2
Sheet: Sheet1

 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Income | 1000 | 1200 | 900 | 1000 | 1100 | 850 | 950 | 1000 | 1150 | 1200 | 950 | 1000 |  | Tax Rate
CPP |  |  |  |  |  |  |  |  | 2.81 |  |  |  |  | 0.0559
Overflow |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
YTD |  |  |  |  |  |  |  |  |  |  |  |  |  | 450
 | 1. if the SUM of the YTD is < O5 ([NAME] amount)  "do nothing"
 | 2. if the SUM of the YTD is > O5 ([NAME] amount) AND < the SUM of the YTD + the next month (only the one where it pass the $450.00 (MAX amount)
 | 3. if the SUM of the YTD is > OS ([NAME] amount) multiply MONTH INCOME by [NAME] (tax rate)
Spreadsheet: 72766d1273503775-attendance-tracker-attendance-tracker
Sheet: Back

2010-01-01 00:00:00 | 1 | [NAME] | M
2010-02-01 00:00:00 | 2 | [NAME] | M
2010-03-01 00:00:00 | 3 | MARY | F
2010-04-01 00:00:00 | 4 | THOMAS | M
2010-05-01 00:00:00 | 5 | RITA | F
2010-06-01 00:00:00
2010-07-01 00:00:00
2010-08-01 00:00:00
2010-09-01 00:00:00
2010-10-01 00:00:00
2010-11-01 00:00:00
2010-12-01 00:00:00
Spreadsheet: 816478d1675652729-extract-values-into-column-d-e-and-f-extract-values_sample_2
Sheet: Here

S/N | Names | Name and Number | Status | Payrate Type | Sales #
1
2
3
3
4
5
6
7
8
Spreadsheet: 2a30195d-6a3e-4ea6-a594-242fd09e30d7
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
44000522 | 2014-11-13 05:22:25 | AXIS | 1 | 6 | 4 | 1503014 | Agent Avacado | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
44000724 | 2014-11-13 05:46:11 | ALLIES | 1 | 6 | 2 | 1503014 | Agent Avacado | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
44088124 | 2014-11-19 05:01:21 | AXIS | 0 | 1 | 5 | 1257313 | prototypetolyfe | 12500 | pacific | 1943-01-13 | 1943-01-13 | Clearing Matanikau River | Nettoyage du secteur Matanikau
44088275 | 2014-11-19 05:16:02 | ALLIES | 1 | 5 | 1 | 1257313 | prototypetolyfe | 12500 | pacific | 1943-01-13 | 1943-01-13 | Clearing Matanikau River | Nettoyage du secteur Matanikau
44101275 | 2014-11-20 04:39:48 | AXIS | 1 | 7 | 6 | 1503014 | Agent Avacado | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
44101525 | 2014-11-20 05:05:54 | ALLIES | 0 | 5 | 7 | 1503014 | Agent Avacado | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
44132820 | 2014-11-22 15:45:08 | AXIS | 0 | 7 | 10 | 1088314 | bino_zoet | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44133154 | 2014-11-22 16:01:33 | ALLIES | 1 | 10 | 6 | 1088314 | bino_zoet | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44138123 | 2014-11-22 22:25:43 | AXIS | 0 | 4 | 10 | 1574433 | Spernatz45 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44138411 | 2014-11-22 23:00:08 | ALLIES | 1 | 10 | 6 | 1574433 | Spernatz45 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44139396 | 2014-11-23 00:03:10 | ALLIES | 0 | 5 | 6 | 1216091 | player1534275 | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
44139731 | 2014-11-23 00:33:16 | AXIS | 1 | 6 | 3 | 1216091 | player1534275 | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
44148108 | 2014-11-23 16:04:51 | AXIS | 0 | 5 | 6 | 681429 | Caverne | 6147 | western | 1944-06-06 | 1944-06-06 | First Assault Wave | 1ère vague d'assaut
44148404 | 2014-11-23 16:20:44 | ALLIES | 1 | 6 | 4 | 681429 | Caverne | 6147 | western | 1944-06-06 | 1944-06-06 | First Assault Wave | 1ère vague d'assaut
Spreadsheet: 4ebaca7d-eb83-47a4-ba22-feb9bff565ac
Sheet: Sheet1

Table 5--Wheat: National average price received by farmers (dollars per bushel) 1/, 11/13/2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Month | All wheat |  | Winter |  | Durum |  | Other spring
 | 2012/13 | 2013/14 | 2012/13 | 2013/14 | 2012/13 | 2013/14 | 2012/13 | 2013/14
June | 6.7 | 7.32 | 6.55 | 7.18 | 8.31 | 8.26 | 7.78 | 7.72
July | 7.89 | 6.93 | 7.76 | 6.85 | 8.67 | 8.17 | 8.39 | 7.29
August | 8.04 | 6.87 | 7.92 | 6.81 | 7.76 | 7.76 | 8.27 | 6.97
September | 8.27 | 6.8 | 8.25 | 6.79 | 7.77 | 7.9 | 8.38 | 6.71
October | 8.38 | 7.09 | 8.33 | 7.09 | 7.61 | 7.33 | 8.56 | 7.06
November | 8.47 |  | 8.38 |  | 8.11 |  | 8.65
December | 8.3 |  | 8.15 |  | 8.31 |  | 8.48
January | 8.12 |  | 8.01 |  | 8.24 |  | 8.34
February | 7.97 |  | 7.85 |  | 8.19 |  | 8.11
March | 7.79 |  | 7.63 |  | 8.12 |  | 7.95
April | 7.71 |  | 7.52 |  | 8.01 |  | 7.9
May | 7.68 |  | 7.49 |  | 8.06 |  | 7.84
1/ Preliminary mid-month, weighted-average price for current month. Source: USDA, National Agricultural Statistics Service, Agricultural Prices.
Date run: 11/12/2013
Spreadsheet: 674616d1587951616-list-multiple-pages-and-remove-duplicates-test123-xatomicx-
Sheet: Sunday

 | [NAME]
 | Orlaith Connelly
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Lorelei Daniel
 | Darsh Bartlett
 | [NAME]
Total
Spreadsheet: 190722d1351774603-counting-the-number-of-times-an-item-appears-and-then-copy-that-selection-to-another-sheet-samplefile
Sheet: Sheet1

Shoe Type | Colour | Qty
School shoe | black | 3
sandle | red | 1
thong | purple | 10
sneeker | white | 4
high heel | green | 0
school shoe | [NAME] | 6
thong | blue | 2
high heel | yellow | 1
sandle | black | 9
sandle | white | 2
high heel | red | 3
Spreadsheet: 141975d1329551996-array-formula-to-auto-populate-results-interventions-template-2
Sheet: Interventions

Patient's Name | MRN | FIN (if readily available) | Date | Intervention Type | Intervention Type (additional details/ comments if needed) | Intervention Details/ Recommendation | Recommendation Made? (Y/N) | Recommendation Accepted if Made? (Y/N/Pending) | Intervention Type (additional details/comments if needed) | Intervention Details/ Recommendation | RPh Initials | Recommendation Made? (Y/N) | Recommendation Accepted if Made? (Y/N/Pending) | Recommendation (further comments/details if needed) | Outcome Value | RPh Initials |  |  |  |  |  | Intervention Types | IV to PO Pantoprazole | 1 RXs - D/C counseling/filled at Apothecary | 2 RXs - D/C counseling/filled at Apothecary | 3 RXs - D/C counseling/filled at Apothecary | 4 RXs - D/C counseling/filled at Apothecary | 5 RXs - D/C counseling/filled at Apothecary | Antibiotic Monitoring | Antibiotic Use | [NAME] | Drug - Disease | Drug - Drug | Drug Dosing | Drug Therapy - General | IV/PO Switch | Nursing - General | Other | PPI Use | Provider - General | Provider Order Entry
 |  |  |  | Drug Dosing |  |  |  |  |  |  |  | y | n |  | 30 |  |  |  |  |  |  |  | 15 | 15 | 30 | 45 | 60 | 75 | 30 | 30 | 15 | 15 | 15 | 30 | 15 | 30 | 15 | 15 | 15 | 15 | 15
 |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | 15 |  |  |  |  |  |  | Recommendation Made | y | n
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Accepted | y | pending | n
Spreadsheet: darrell_schoolcraft__7597__NNG LAMAR NOMNATION
Sheet: 01-(3)

 |  |  |  | Time/Date
 |  |  |  | Beginning Gas Day: | 1.3.02
 |  |  |  | Ending Gas Day: | 1.3.02
 |  | [NAME] |  |  | 60000
 |  | Hour
 |  | Ending | [NAME] | Accumulated | Remaining | Daily Burn
 |  | CST |  |  |  | Rate
 |  | 10 | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
 |  | 1 | 2500
 |  | 2 | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
 |  |  | 2500
Spreadsheet: 271887d1382098376-excel-coding-and-formulas-for-master-and-cost-sheets-pricing-sheet
Sheet: Master

Code | Description | Material | Labour | Paint | Total | excl [NAME] | VAT | Total inc VAT
A1 | 800mm x 900mm side panel | side panel | 150 | 30 | 180 | 180 | 0.2 | 216
A2 | 800mm x 900mm side panel | side panel | 100 | 30 | 130 | 130 | 0.2 | 156
A3 | 800mm x 900mm side panel | side panel | 45 | 30 | 75 | 75 | 0.2 | 90
A4 | 800mm x 900mm side panel | side panel | 254 | 30 | 284 | 284 | 0.2 | 340.8
A5 | 800mm x 900mm side panel | side panel | 678 | 30 | 708 | 708 | 0.2 | 849.6
A6 | 800mm x 900mm side panel | side panel | 43 | 30 | 73 | 73 | 0.2 | 87.6
A7 | 800mm x 900mm side panel | side panel | 9876 | 30 | 9906 | 9906 | 0.2 | 11887.2
A8 | 800mm x 900mm side panel | side panel | 34 | 30 | 64 | 64 | 0.2 | 76.8
A9 | 800mm x 900mm side panel | side panel | 66 | 30 | 96 | 96 | 0.2 | 115.2
A10 | 800mm x 900mm side panel | side panel | 85 | 30 | 115 | 115 | 0.2 | 138
A11 | 800mm x 900mm side panel | side panel | 24 | 30 | 54 | 54 | 0.2 | 64.8
A12 | 800mm x 900mm side panel | side panel | 150 | 30 | 180 | 180 | 0.2 | 216
Spreadsheet: 65624b71-1736-4b85-8d64-9e587a12c206
Sheet: JVS - August

daria.shams:offset_dereg_fy13_august.xlsx
 |  |  | FIXED RATE | FIXED RATE
 |  |  | OPERATING | [NAME]
 |  |  | LEVY LOSS | LOSS
 |  |  | REIMBURSEMENT | REIMBURSEMENT
 |  |  | (PAID IN | (PAID IN
 |  |  | AUGUST 2012) | AUGUST 2012)
IRN | DISTRICT | COUNTY | FY13 | FY13
50773 | Apollo JVSD | [NAME] | 0 | 3158.23
50799 | Southern Hills JVSD | [NAME] | 0 | 1917.51
50815 | Ashtabula County JVSD | Ashtabula | 0 | 2884.76
50856 | Belmont-Harrison JVSD | Belmont | 0 | 0
50880 | Butler Technology and Career D | Butler | 0 | 0
50906 | Columbiana County JVSD | [NAME] | 0 | 0
50922 | Cuyahoga Valley JVSD | Cuyahoga | 0 | 0
50948 | [NAME] | Cuyahoga | 0 | 0
50963 | Four County JVSD | [NAME] | 0 | 2189.88
50989 | Delaware JVSD | Delaware | 0 | 2542.11
51003 | Eastland Fairfield Career/Tech | Franklin | 0 | 0
51029 | EHOVE JVSD | Erie | 0 | 0
51045 | Greene County JVSD | Greene | 0 | 8733.07
51060 | Great Oaks Inst Of Technology | [NAME] | 0 | 0
51128 | Jefferson County JVSD | [NAME] | 0 | 0
51144 | Knox County JVSD | Knox | 0 | 0
51169 | Auburn JVSD | Lake | 4359.23 | 0
51185 | Lawrence County JVSD | [NAME] | 0 | 0
51201 | Licking County JVSD | Licking | 0 | 0
51227 | Lorain County JVSD | Lorain | 0 | 0
51243 | Mahoning County JVSD | Mahoning | 0 | 0
51284 | Miami Valley Career Technical | Montgomery | 0 | 0
51300 | Mid-East Ohio JVSD | Muskingum | 0 | 0
51334 | Ohio Hi-Point JVSD | Logan | 0 | 0
51359 | Penta County JVSD | Wood | 0 | 0
51375 | Pike County Area JVSD | Pike | 0 | 0
51391 | Maplewood Career Center | Portage | 0 | 0
51417 | Pioneer JVSD | Richland | 0 | 0
51433 | Pickaway-Ross County JVSD | [NAME] | 0 | 0
51458 | [NAME] JVSD | Sandusky | 0 | 0
51474 | Warren County JVSD | [NAME] | 0 | 0
51490 | Scioto County JVSD | Scioto | 0 | 0
51532 | Springfield-Clark County JVSD | [NAME] | 0 | 0
51607 | Tri-County JVSD | Athens | 0 | 0
51631 | Trumbull County JVSD | Trumbull | 0 | 0
51656 | [NAME] | Tuscarawas | 0 | 0
51672 | Vantage JVSD | Van Wert | 0 | 1693.41
51698 | Washington County JVSD | Washington | 0 | 0
51714 | Wayne County JVSD | Wayne | 0 | 0
62026 | Stark County Area JVSD | [NAME] | 0 | 0
62042 | Ashland County-West Holmes JVS | Ashland | 0 | 2026.57
62067 | Gallia-Jackson-Vinton JVSD | Gallia | 0 | 0
62109 | Medina County JVSD | Medina | 0 | 0
62125 | Upper Valley JVSD | Miami | 0 | 0
62802 | U S Grant JVSD | Clermont | 400225.64 | 0
63495 | Portage Lakes JVSD | Summit | 0 | 0
63511 | Central Ohio JVSD | [NAME] | 0 | 0
65227 | Coshocton County JVSD | Coshocton | 0 | 0
65268 | Tri-Rivers JVSD | Marion | 0 | 0
 | TOTAL |  | 404584.87 | 25145.54
Spreadsheet: 140022d1328595818-how-do-i-conditional-format-a-row-with-reference-from-column-manhours-extraction-solution-
Sheet: Employee Summary

Type | (All)
Sum of Days |  |  |  |  | Month
Project | Department | Name | SAP | Time | 2008-06-01 00:00:00 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | Grand Total
BO-620 | Hull | Gawade Prashant Bhaguji | 30002140 | Normal Time | 21 | 23 | 20 | 22 | 22 | 20 | 22 | 19 | 20 | 22 |  |  |  |  |  |  |  |  | 211
 |  |  |  | Overtime | 7 | 5 | 6 | 5 | 9 | 7 | 9 | 3 | 6 | 8 |  |  |  |  |  |  |  |  | 65
 |  | [NAME] | 30002470 | Normal Time |  |  |  |  | 22 | 20 | 22 | 19 | 20 | 22 | 21 | 20 |  |  |  |  |  |  | 166
 |  |  |  | Overtime |  |  |  |  | 4 | 6 | 4 | 4 | 3 | 4 | 2 | 3 |  |  |  |  |  |  | 30
 |  | [NAME] | 30001863 | Normal Time | 21 | 23 | 20 | 22 | 22 | 20 | 11 | 10 | 10 | 11 | 11 | 10 | 11 | 12 | 10 | 11 |  |  | 235
 |  |  |  | Overtime | 2 |  | 1 | 2 | 0.5 | 1 | 0.5 | 0.5 | 2 | 1 | 1 | 1 | 0.5 | 2 | 1 | 2 | 1 | 2 | 21
Grand Total |  |  |  |  | 51 | 51 | 47 | 51 | 79.5 | 74 | 68.5 | 55.5 | 61 | 68 | 35 | 34 | 11.5 | 14 | 11 | 13 | 1 | 2 | 728
Spreadsheet: 843195d1695122820-formatting-names-copy-of-example
Sheet: Sheet1

 | Name | Qty |  |  | Name
1 | [NAME] | 6 | 1 |  | [NAME]
 | Mark | 4 | 2 |  | [NAME]
 | Isobel | 5 | 3 |  | [NAME]
 |  |  | 4 |  | [NAME]
 |  |  | 5 |  | [NAME]
 |  |  | 6 |  | [NAME]
 |  |  | 7 |  | Mark
 |  |  | 8 |  | Mark
 |  |  | 9 |  | Mark
 |  |  | 10 |  | Mark
 |  |  | 11 |  | Isobel
 |  |  | 12 |  | Isobel
 |  |  | 13 |  | Isobel
 |  |  | 14 |  | Isobel
 |  |  | 15 |  | Isobel
Spreadsheet: 739229d1625583806-looking-for-a-formula-to-find-a-value-based-on-multiple-criteria-in-multiple-sheets-sample1
Sheet: Tab2

 |  | Thomas Franks Ltd.
 |  | Stock trend
 |  | 12 Months
 |  |  |  |  |  | Jul 20 |  | Aug 20 |  | Sep 20 |  | Oct 20 |  | Nov 20 |  | Dec 20 |  | Jan 21 |  | Feb 21 |  | Mar 21 |  | Apr 21 |  | May 21 |  | Jun 21
Location number | Location name | OPS | RD |  | Value | Weeks | Value | Weeks | Value | Weeks | Value | Weeks | Value | Weeks | Value | Weeks | Value | Weeks | Value | Weeks | Value | Weeks | Value | Weeks | Value | Weeks | Value | Weeks
 |  | 0 | 0
 |  | 0 | 0
131 | Test131 |  |  |  | 2047.36 | 8785.7 | - | 7955.96 | 6.29 | 13277.85 |  | 5271.9 |  | 6551.32 |  | 4002.28 |  | 3641.41 |  | 554 |  | 1121 |  | 7003.67 |  | 1541 |  | 521
141 | test141 |  |  |  | 1336.56 | 3582.78 | 9 | 7857.63 | 5.81 | 8324.49 |  | 6928.69 |  | 7543.4 |  | 6814.56 |  | 554 |  | 5851.15 |  | 5062.39 |  | 5647 |  | 10694.57 |  | 57451
- | - | - | - |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Total | Tab2
- | - | - | - |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -