tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 857881d1706741421-help-with-ifs-function-kansas-scheduler-v2-test-01302024_2
Sheet: Press Date Calculation

Press Time Totals by Date
↓Date↓ |  | ↓Tauro↓ | ↓3R↓ | ↓HP↓ | ↓HS↓ | ↓GS↓ | ↓Indigo↓ | ↓Cut Only↓ | ↓Fabrivue↓ | ↓TOTALS↓ |  | Kitting
2024-01-26 00:00:00 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
Spreadsheet: 0166127f-ad35-42d0-a3ea-7d6ecd52af5e
Sheet: Sheet1

Table 4 -- U.S. monthly average farm prices and marketings by class | 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 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17
 |  |  | Long-grain |  |  |  |  |  |  |  |  | Medium/Short Grain
 |  | 2011/12 |  |  |  | 2010/11 |  |  |  | 2011/12 |  |  |  | 2010/11
Month | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt
August | 12.4 |  | 9343 |  | 10.3 |  | 8570 |  | 19 |  | 2041 |  | 17.1 |  | 2121
September | 13.7 |  | 10310 |  | 9.98 |  | 12764 |  | 17.8 |  | 2197 |  | 16.9 |  | 2331
October | 14.1 |  | 8694 |  | 10.1 |  | 14295 |  | 15.9 |  | 2760 |  | 18.8 |  | 2836
November | 13.9 |  | 7196 |  | 10.6 |  | 12773 |  | 15.7 |  | 3732 |  | 18.9 |  | 4156
December | 13.8 |  | 9938 |  | 11.3 |  | 13085 |  | 15.2 |  | 4239 |  | 19.5 |  | 6052
January | 13.6 |  | 9482 |  | 11.8 |  | 15722 |  | 15.2 |  | 4940 |  | 19.6 |  | 6084
February | 13.2 |  | 9917 |  | 12 |  | 11726 |  | 15.3 |  | 3270 |  | 18.8 |  | 3121
March | 13 |  | 10041 |  | 11.6 |  | 12537 |  | 15 |  | 4124 |  | 18.5 |  | 3307
April | 13.2 |  | 9423 |  | 11.2 |  | 9562 |  | 15.3 |  | 3973 |  | 18.6 |  | 3165
May | 13.3 |  | 9689 |  | 10.9 |  | 11211 |  | 15.3 |  | 3523 |  | 19 |  | 3016
June | 13.4 |  | 7120 |  | 11 |  | 9573 |  | 15.7 |  | 3024 |  | 18.4 |  | 1744
July | 13.7 | 1/ |  |  | 11.4 |  | 9866 |  | 17.3 | 1/ |  |  | 19 |  | 2503
Average to date 2/ | 13.44166666666667 |  |  |  |  |  |  |  | 16.05833333333333
Season-average farm price | 13.4 | 3/ |  |  | 11 |  |  |  | 15.7 | 3/ |  |  | 18.8
Average marketings |  |  | 9403.3 |  |  |  | 11807 |  |  |  | 3479.9 |  |  |  | 3369.666666666667
Total volume marketed |  |  | 101153 |  |  |  | 141684 |  |  |  | 37823 |  |  |  | 40436
N/A = Not available.  1/  Mid-month only.  2/ Simple average. 3/ Forecast.
Source: Monthly cash price and marketings, Agricultural Prices, National Agricultural Statistics Service, USDA.
Last updated August 13, 2012.
Spreadsheet: 343380ac-bdf9-4b53-bc4d-57eec12069d6
Sheet: ARA Hist Bid Offer Template

FCM Annual Reconfiguration Auction Historical Bid/Offer Report
WW_FCMARAHB_ISO_<settlement_date>_<version>.CSV
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
Auction Information |  | Resource Information |  |  |  |  |  | Bid/Offer Segment Information
Commitment Period | Auction Type | Masked Resource ID | Masked Lead Participant ID | Masked Capacity Zone ID | Resource Type | Masked External Interface ID | [NAME] | Segment 1 MW | Segment 1 Price | Segment 2 MW | Segment 2 Price | Segment 3 MW | Segment 3 Price | Segment 4 MW | Segment 4 Price | Segment 5 MW | Segment 5 Price
String | String | Number | Number | Number | String | Number | String | MW-Month | $/kW-Month | MW-Month | $/kW-Month | MW-Month | $/kW-Month | MW-Month | $/kW-Month | MW-Month | $/kW-Month
Spreadsheet: 295044d1391577962-automatically-fitering-values-through-based-on-a-criteria-database-and-constituent-tabs
Sheet: Queensland

 |  |  | Category | List A | List B | List C
 |  |  | J | 0.8394135763577782 | 0.8460076582097226 | 0.1855530156749109
 |  |  | Category | List A | List B | List C
 |  |  | A | 0.9379289480935706 | 0.1125942215516547 | 0.6032566724812469
 |  |  | B | 0.02148405584523749 | 0.2760137571184543 | 0.03078485918895058
 |  |  | C | 0.3861707542190098 | 0.9290454108076764 | 0.9321961338523034
 |  |  | D | 0.9587887863945899 | 0.7152017101653185 | 0.9334198380408496
 |  |  | E | 0.6277384786537556 | 0.0788613678351262 | 0.478123875852604
 |  |  | F | 0.881949669949599 | 0.5210575432743497 | 0.9808378096680758
 |  |  | G | 0.2522017790907644 | 0.699365122310915 | 0.56547231736903
 |  |  | H | 0.4996123686366943 | 0.117396508287864 | 0.3499768761402722
 |  |  | I | 0.6771986600536704 | 0.1155271409927671 | 0.9367063027562584
 |  |  | J | 0.8394135763577782 | 0.8460076582097226 | 0.1855530156749109
Spreadsheet: 0e8c4e6a-d63d-46eb-8e76-00790c024607
Sheet: Sheet1

SAN ANTONIO INDEPENDENT SCHOOL DISTRICT | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
OFFICE OF DIRECTOR OF ATHLETICS
HIGH SCHOOL SOCCER  INVENTORY
 | READY TO USE | TO BE REPAIRED | UNUSABLE | TOTAL ITEMS | NO. ISSUED | EQUIP NEEDS
PRACTICE
1.  BALLS
2.  T-SHIRTS
3.  SHORTS
4.  WARM-UPS
A. TOP
B.  BOTTOM
GAME
1.  BALLS
2.  CORNER FLAGS
3.  [NAME]
4.  GOALIE
A.  SHIRT
B.  SHORTS
C.  PANTS
D.  GLOVES
5.  JERSEYS
A.  DARK
B.  LIGHT
6.  RAINWEAR
A.  TOP
B.  BOTTOM
7.  [NAME]
A.  DARK
B.  LIGHT
8.  WARM-UPS
A.  TOP
B.  BOTTOMS
9.  SOCKS
A.  DARK
B.  LIGHT
10.  SUPPORTERS
11.  LONG SLEEVE SHIRTS
12.  SWEAT TOPS
13.  SCRIMMAGE VEST
14.  ARMBANDS
15.  SHIN GUARDS
16.  SHOES
17.  SCOREBOOK
18.  PUMP
19.  PRACTICE CONES
20.  NETS
A.  GOAL
B.  BALL
21.  [NAME]
A. BALL
B. TRAVEL
DO NOT DISCARD OR DESTROY ANYTHING: UNUSABLES WILL BE CHECKED BY THE
ATHLETIC DIRECTOR OR ASSISTANT ATHLETIC DIRECTOR.
DATE: ________________________________________ |  |  | SCHOOL: __________________________________
COACH: ______________________________________ |  |  | COORDINATOR: ____________________________
PRINCIPAL: ___________________________________
PAD:/ FORMS / SENIOR SCHOOL SOCCER  INVENTORY
Spreadsheet: 140093d1328622649-daily-food-calculator-feb-food-total-values
Sheet: Database

Food | Weight | Price | Points
[NAME] | 1 | 0.008 | 1
[NAME] | 2 |  | 1
[NAME] | 3 |  | 1
[NAME] | 4 |  | 1
[NAME] | 5 |  | 1
[NAME] | 6 |  | 1
[NAME] | 7 |  | 1
[NAME] | 8 |  | 1
[NAME] | 9 |  | 1
[NAME] | 10 |  | 1
[NAME] | 11 |  | 1
[NAME] | 12 |  | 1
[NAME] | 13 |  | 1
[NAME] | 14 |  | 1
[NAME] | 15 |  | 2
[NAME] | 16 |  | 2
[NAME] | 17 |  | 2
[NAME] | 18 |  | 2
[NAME] | 19 |  | 2
[NAME] | 20 |  | 2
[NAME] | 21 |  | 2
[NAME] | 22 |  | 2
[NAME] | 23 |  | 2
[NAME] | 24 |  | 2
[NAME] | 25 |  | 2
[NAME] | 26 |  | 2
[NAME] | 27 |  | 2
[NAME] | 28 |  | 2
[NAME] | 29 |  | 2
[NAME] | 30 |  | 3
[NAME] | 31 |  | 3
[NAME] | 32 |  | 3
[NAME] | 33 |  | 3
[NAME] | 34 |  | 3
[NAME] | 35 |  | 3
[NAME] | 36 |  | 3
[NAME] | 37 |  | 4
[NAME] | 38 |  | 4
[NAME] | 39 |  | 4
[NAME] | 40 |  | 4
[NAME] | 41 |  | 4
[NAME] | 42 |  | 4
[NAME] | 43 |  | 4
[NAME] | 44 |  | 4
[NAME] | 45 |  | 4
[NAME] | 46 |  | 4
[NAME] | 47 |  | 4
[NAME] | 48 |  | 4
[NAME] | 49 |  | 4
[NAME] | 50 |  | 5
Spreadsheet: 69829d1270502619-conditional-calculation-based-on-cells-value-book1
Sheet: Realized Demand vs LY

Date | DOW | Days Out | RTS | GB | GS | GR | TB | TTL | alert |  | Last Week OTB | Var to Last Week
2010-04-05 00:00:00 | Mon | AR | 85 | 68 | 68 | 0 | 200 | 268 |  |  | 240 | 28
2010-04-06 00:00:00 | Tue | 1 | 30 | 73 | 68 | 5 | 250 | 323 | 11 |  | 109 | 214
2010-04-07 00:00:00 | Wed | 2 | 40 | 74 | 69 | 5 | 239 | 313 |  |  | 42 | 271
2010-04-08 00:00:00 | Thu | 3 | 128 | 90 | 86 | 4 | 135 | 225 |  |  | 33 | 192
2010-04-09 00:00:00 | Fri | 4 | 150 | 140 | 98 | 42 | 63 | 203 |  |  | 62 | 141
2010-04-10 00:00:00 | Sat | 5 | 100 | 168 | 103 | 65 | 85 | 253 |  |  | 118 | 135
2010-04-11 00:00:00 | Sun | 6 | 236 | 43 | 21 | 22 | 74 | 117 |  |  | 166 | -49
2010-04-12 00:00:00 | Mon | 7 | 127 | 31 | 18 | 13 | 195 | 226 |  |  | 222 | 4
2010-04-13 00:00:00 | Tue | 8 | 114 | 28 | 20 | 8 | 211 | 239 | 27 |  | 172 | 67
2010-04-14 00:00:00 | Wed | 9 | 129 | 40 | 23 | 17 | 184 | 224 |  |  | 144 | 80
2010-04-15 00:00:00 | Thu | 10 | 49 | 205 | 107 | 98 | 99 | 304 |  |  | 132 | 172
2010-04-16 00:00:00 | Fri | 11 | 29 | 255 | 115 | 140 | 69 | 324 |  |  | 38 | 286
2010-04-17 00:00:00 | Sat | 12 | 208 | 75 | 32 | 43 | 70 | 145 |  |  | 62 | 83
2010-04-18 00:00:00 | Sun | 13 | 246 | 52 | 7 | 45 | 55 | 107 |  |  | 68 | 39
Spreadsheet: 877593d1724403253-formulas-for-a-maintenance-table-examplesheet-1-
Sheet: LCRP 10year

 | Units | No of Units | 1
 |  |  |  |  |  |  |  |  |  | Total 10 Y LCR Price
 | Hours/ Day | Hours/Day | 10
 | Hours/Year | Hours/Year
 |  |  |  |  |  |  | M-F
 |  |  |  |  |  | Year |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 |  |  |  |  |  | Run Hours From D4
 | Description | Pcs / Unit | Change each x Year | Indicative run Hours | Guide Parts Price/Module | Cost of replacement | MHrs req. per change | Guide  Labour Price per change | Guide Parts & Labour Price * No. of Units | 10 Year LCR Price | LCR Year 1 price | LCR Year 2 price | LCR Year 3 price | LCR Year            4 price | LCR Year            5 price | LCR Year 6 price | LCR Year 7 price | LCR Year 8 price | LCR Year 9 price | LCR Year 10 price
 | Article 1 | 1 | 2 | 5000 | 5000 |  | 40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | These rows works somewhat correctly. They calculate the years and shows costs on those years.
 | Article 2 | 3 | 2 | 5000 | 3000 |  | inc
 | Article 3 | 1 | 8 | 20000 | 35000 |  | 36 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This row should be changed at 20000 hours (6th year).
 | Article 7 | 1 | 10 | 25000 |  | 500 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This row should be changed in the 7th (R10) year when accumulated hours goes above 25000h (E19)
 | Article 10 | 8 | 8 | 20000 |  | 200 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This row should be changed in the 3rd year due to the accumulated hours (N10) and not in the 4th year (D23)
 | Article 11 | 1 | 4 | 9000 |  |  | 10
 | Article 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The formulas are currently not working as they should "restart" the calculations after a replacement of the article.
 |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  | Sum
Spreadsheet: 695807d1600414440-convert-unstructured-column-base-data-into-single-row-excelforum
Sheet: Sheet1

 |  |  |  |  |  |  | Desired Result
Name | Years |  | Year | Name |  |  | Year | Name
[NAME] | 2013-2015 |  |  |  |  |  | 2013 | [NAME]
Barb | 2015 |  |  |  |  |  | 2014 | [NAME]
[NAME] | 2000-2004 |  |  |  |  |  | 2015 | [NAME]
[NAME] | 2001-2006 |  |  |  |  |  | 2015 | Barb
[NAME] | 2012-2015 |  |  |  |  |  | 2000 | [NAME]
[NAME] | 2016-2017 |  |  |  |  |  | 2001 | [NAME]
[NAME] | 2005 |  |  |  |  |  | 2002 | [NAME]
Hank | 2002-2005 |  |  |  |  |  | 2003 | [NAME]
Ike | 2010 |  |  |  |  |  | 2004 | [NAME]
Jared | 2014-2018 |  |  |  |  |  | 2001 | [NAME]
Kelly | 2002-2006 |  |  |  |  |  | 2002 | [NAME]
[NAME] | 2001-2006 |  |  |  |  |  | 2003 | [NAME]
[NAME] | 2006-2011 |  |  |  |  |  | 2004 | [NAME]
Nan | 2009 |  |  |  |  |  | 2005 | [NAME]
Otto | 2002 |  |  |  |  |  | 2006 | [NAME]
[NAME] | 2015-2019 |  |  |  |  |  | 2012 | [NAME]
Quenten | 2010-2011 |  |  |  |  |  | 2013 | [NAME]
Raul | 2013-2016 |  |  |  |  |  | 2014 | [NAME]
[NAME] | 2013-2016 |  |  |  |  |  | 2015 | [NAME]
 |  |  |  |  |  |  | 2016 | [NAME]
 |  |  |  |  |  |  | 2017 | [NAME]
 |  |  |  |  |  |  | 2005 | [NAME]
 |  |  |  |  |  |  | 2002 | Hank
 |  |  |  |  |  |  | 2003 | Hank
 |  |  |  |  |  |  | 2004 | Hank
 |  |  |  |  |  |  | 2005 | Hank
 |  |  |  |  |  |  | 2010 | Ike
 |  |  |  |  |  |  | 2014 | Jared
 |  |  |  |  |  |  | 2015 | Jared
 |  |  |  |  |  |  | 2016 | Jared
 |  |  |  |  |  |  | 2017 | Jared
 |  |  |  |  |  |  | 2018 | Jared
 |  |  |  |  |  |  | 2002 | Kelly
 |  |  |  |  |  |  | 2003 | Kelly
 |  |  |  |  |  |  | 2004 | Kelly
 |  |  |  |  |  |  | 2005 | Kelly
 |  |  |  |  |  |  | 2006 | Kelly
 |  |  |  |  |  |  | 2001 | [NAME]
 |  |  |  |  |  |  | 2002 | [NAME]
 |  |  |  |  |  |  | 2003 | [NAME]
 |  |  |  |  |  |  | 2004 | [NAME]
 |  |  |  |  |  |  | 2005 | [NAME]
 |  |  |  |  |  |  | 2006 | [NAME]
 |  |  |  |  |  |  | 2006 | [NAME]
 |  |  |  |  |  |  | 2007 | [NAME]
 |  |  |  |  |  |  | 2008 | [NAME]
 |  |  |  |  |  |  | 2009 | [NAME]
 |  |  |  |  |  |  | 2010 | [NAME]
 |  |  |  |  |  |  | 2011 | [NAME]
 |  |  |  |  |  |  | 2009 | Nan
 |  |  |  |  |  |  | 2002 | Otto
 |  |  |  |  |  |  | 2015 | [NAME]
 |  |  |  |  |  |  | 2016 | [NAME]
 |  |  |  |  |  |  | 2017 | [NAME]
 |  |  |  |  |  |  | 2018 | [NAME]
 |  |  |  |  |  |  | 2019 | [NAME]
 |  |  |  |  |  |  | 2010 | Quenten
 |  |  |  |  |  |  | 2011 | Quenten
 |  |  |  |  |  |  | 2013 | Raul
 |  |  |  |  |  |  | 2014 | Raul
 |  |  |  |  |  |  | 2015 | Raul
 |  |  |  |  |  |  | 2016 | Raul
 |  |  |  |  |  |  | 2013 | [NAME]
 |  |  |  |  |  |  | 2014 | [NAME]
 |  |  |  |  |  |  | 2015 | [NAME]
 |  |  |  |  |  |  | 2016 | [NAME]
Spreadsheet: 50075d1249476555-array-range-from-multiple-selections-rate-of-return-calculation
Sheet: Example 1

 |  | Date (di) |  |  | Days Between
 |  |  |  |  | the ith Transaction
 |  |  |  |  | and the Beginning
Transaction | Cash |  | Transaction | Dollar | Balance |  | Daily | Actual | Anualized
Number (i) | Flow (Ci) |  | Description | Amount | (di-BegDate) |  | Rate | Rate | Rate | YTD
1 |  | 2001-01-01 00:00:00 | Beginning Balance | 50000 | 0 |  |  | 0
2 | 1 | 2001-01-16 00:00:00 | Contribution | 1000 | 15 |  |  | 0
3 | 2 | 2001-03-16 00:00:00 | Contribution | 1000 | 74 |  |  | 0
4 | 3 | 2001-06-15 00:00:00 | Contribution | 1000 | 165 |  |  | 0
5 | 4 | 2001-06-20 00:00:00 | Loan | -20000 | 170 |  |  | 0
6 | 5 | 2001-08-16 00:00:00 | [NAME] | 425 | 227 |  |  | 0
7 | 6 | 2001-09-15 00:00:00 | [NAME] | 425 | 257 |  |  | 0
8 | 7 | 2001-10-16 00:00:00 | [NAME] | 425 | 288 |  |  | 0
9 | 8 | 2001-11-15 00:00:00 | [NAME] | 425 | 318 |  |  | 0
10 | 9 | 2001-12-16 00:00:00 | [NAME] | 425 | 349 |  |  | 0
11 |  | 2001-12-31 00:00:00 | Ending Balance | -40225 | 364 |  |  | 0 | 0.1208398640155792 | 0.1204896078300706
dailyrate (from the dailyrate formula) |  |  | = | 0
1 + dailyrate |  |  | = | 1
days = (EndDate - BegDate) |  |  | = | 364
 |  |  | = | 0
Spreadsheet: 700135d1602992003-formula-to-extract-numbers-from-within-a-cell-book1-1-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Column1 |  |  |  | 1
 |  |  |  |  |  |  |  |  | 21-3-1 |  |  |  | 2
 |  |  |  |  |  |  |  |  | 12-18-2 |  |  | 16 | 0
 |  |  |  |  |  |  |  |  | 5-16 |  |  | 3 | 1
 |  |  |  |  |  |  |  |  | 20-3-1 |  |  | 6 | 0
 |  |  |  |  |  |  |  |  | 22-6 |  |  | 17 | 0
 |  |  |  |  |  |  |  |  | 9-17
 |  |  |  | [NAME] in green works fine
 |  |  |  | Should be the number between the dashes but if there is only 1 dash it would be the number to the right of the dash
 |  |  |  | M3=Formula ok
 |  |  |  | M4=Only shows 1, not 18
 |  |  |  | Orange should be formula that reflects number to the right of the 2nd dash but 0 if there is no 2nd dash
 |  |  |  | Numbers in red reflect what the outcome of the formula should be
Spreadsheet: 93bcb298-d357-4609-9ed8-42993b2223bc
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
24318378 | 2011-07-11 20:28:09 | ALLIES | 0 | 2 | 5 | 242664 | Nygaard | 8086 | western | 1944-08-09 |  | Battle of Mairy | [NAME]
24318601 | 2011-07-11 20:41:58 | AXIS | 0 | 1 | 5 | 242664 | Nygaard | 8086 | western | 1944-08-09 |  | Battle of Mairy | [NAME]
24318809 | 2011-07-11 20:57:17 | AXIS | 0 | 2 | 6 | 242664 | Nygaard | 8143 | pacific | 1938-03-12 | 1938-03-23 | Linyi Online | Linyi Online
0 |  |  | 0 | 0 | 0 | 0 |  | 0
0 |  |  | 0 | 0 | 0 | 0 |  | 0
0 |  |  | 0 | 0 | 0 | 0 |  | 0
0 |  |  | 0 | 0 | 0 | 0 |  | 0
0 |  |  | 0 | 0 | 0 | 0 |  | 0
24597078 | 2011-07-27 21:08:47 | AXIS | 0 | 4 | 7 | 242664 | Nygaard | 8163 | pacific | 1937-08-13 |  | [NAME] last charge Online | La dernière charge [NAME] Online
Spreadsheet: 165014d1340986267-percentages-based-on-two-variables-table-lookup-oeldere-
Sheet: MD_Locations

 |  |  |  | helper row | helper | collum | adress
Physician | Specialty | Values | wRVUs Percentile | row |  |  |  |  | 0%tile | 25%tile | 50%tile | 60%tile | 75%tile | 90%tile
Physician 1 | Internal Medicine | 2000.028000000007 | 25%tile | 10 | j10:O10 | 10 | 0%tile | CHEMICAL DEPENDENCY | 0 | 3945 | 4750.378326386663 | 5132.36954588009 | 5705.356375120232 | 6801.380056428342
Physician 2 | Urgent Care | 490.8465000000025 | 25%tile | 19 | j19:O19 | 10 | 0%tile | DERMATOLOGY | 0 | 6318 | 8174 | 9252.8 | 10871 | 13123
Physician 3 | Pediatrics | 3303.771499999947 | 25%tile | 16 | j16:O16 | 10 | 0%tile | EMERGENCY MEDICINE | 0 | 4610 | 5544 | 5957.6 | 6578 | 7657
Physician 4 | Family Medicine | 1520.636500000024 | 25%tile | 7 | j7:O7 | 10 | 0%tile | ENDOCRINOLOGY | 0 | 3508 | 4326 | 4737.2 | 5354 | 6929
Physician 5 | Family Medicine | 4990.371500000017 | 50%tile | 7 | j7:O7 | 12 | 50%tile | FAMILY MEDICINE | 0 | 3945 | 4750.378326386663 | 5132.36954588009 | 5705.356375120232 | 6801.380056428342
Physician 6 | Internal Medicine | 7099.51350000005 | 90%tile | 10 | j10:O10 | 15 | 90%tile | GENERAL PRACTICE | 0 | 3945 | 4750.378326386663 | 5132.36954588009 | 5705.356375120232 | 6801.380056428342
 |  |  |  |  |  |  |  | HOSPITALIST | 0 | 2798 | 3765 | 4194.2 | 4838 | 6059
 |  |  |  |  |  |  |  | INTERNAL MEDICINE | 0 | 3945 | 4750.378326386663 | 5132.36954588009 | 5705.356375120232 | 6801.380056428342
 |  |  |  |  |  |  |  | NEUROLOGY | 0 | 3910 | 4857 | 5400.2 | 6215 | 8040
 |  |  |  |  |  |  |  | OBSTETRICS/GYNECOLOGY | 0 | 4900 | 6123 | 6995 | 8303 | 10498
 |  |  |  |  |  |  |  | ONCOLOGY | 0 | 3816 | 5113 | 5688.6 | 6552 | 7830
 |  |  |  |  |  |  |  | ORTHOPEDIC SURGERY | 0 | 6252 | 7791 | 8629.8 | 9888 | 13124
 |  |  |  |  |  |  |  | ORTHOPEDICS | 0 | 4599 | 5572 | 5835.2 | 6230 | 6929
 |  |  |  |  |  |  |  | PEDIATRICS | 0 | 4060 | 4829 | 5097 | 5499 | 6417
 |  |  |  |  |  |  |  | PODIATRY | 0 | 3918 | 5060 | 5687.6 | 6629 | 7661
 |  |  |  |  |  |  |  | RHEUMATOLOGY | 0 | 3980.24 | 4624.62 | 5106.616 | 5829.61 | 6899.4
 |  |  |  |  |  |  |  | URGENT CARE | 0 | 4204 | 5527 | 6093 | 6942 | 8049
 |  |  |  |  |  |  |  | OCCUPATIONAL MEDICINE | 0 | 3707 | 5006 | 5584.4 | 6452 | 6867
 |  |  |  |  |  |  |  | PHYSIATRY | 0 | 4304 | 5176 | 5607.2 | 6254 | 7285
 |  |  |  |  |  |  |  | SPORTS MEDICINE | 0 | 4740 | 5410 | 5750.8 | 6262 | 9946
Spreadsheet: 115794d1311288395-excel-2007-conditional-formatting-for-an-entire-range-contional-formatting-diffrent-value
Sheet: Sheet1

Master Code | Master Fee | Office #1 Fee | Office #2 Fee | Office #3 Fee | Office #4 Fee
D001 | 50 | 50 | 52 | 50 | 50
 | 60 | 60 | 60 | 60 | 75 |  | + select D2:E10
 | 60 | 55 | 60 | 45 | 60 |  | + Conditional formatting:  with rule by formular:  =D2<>$B2
Spreadsheet: 04ee76f2-efdb-4fc8-a540-8bde2dc353f7
Sheet: 4.2(AR) Major Group Enroll-Grad

Institution
Indicator 4: Student Enrollment and Graduation by Major Group
Table 4.2(AR): Major Group Fall Enrollment, Graduation & Post-Graduate / AY 2010-11
 | Major Group | AR - Art
 | Please enter the number of students enrolled in this major group for the fall semester.
 |  |  |  |  | Fall 2010 (October 15, 2010)
 | Fall Enrollment (Snapshot) |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
 |  | Full Time | 6 | 2 | 0 | 0
 |  | Part Time | 1 | 1 | 0 | 0
 |  | Total
 | Please enter the number of diploma, certificates, and degrees earned in this major group.  Also enter the number of students graduating with degrees who earned a GPA of 3.0 or above, and the number who were admitted to a 4 year (Associate degree graduates), or graduate school (Bachelor's degree graduates).  Lastly, enter the number of all graduating students(certificate or degree) who secured employment after graduation.
 |  |  |  |  | July 1, 2010- June 30, 2011
 | Graduation |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
Apprenticeship/Occupational Program |  |  | na | na | na | na
Diploma |  |  | na | na | na | na
Certificate |  |  | na | na | na | na
Associate Degree |  |  | 0 | 0 | 0 | 0
 | Assoc. graduates admitted to four-year program |  | 0 | 0 | 0 | 0
 | [NAME]. graduated with a GPA of 3.0 or above |  | 0 | 0 | 0 | 0
Bachelor's Degree |  |  | na | na | na | na
 | [NAME]. graduates admitted to graduate school |  | na | na | na | na
 | [NAME]. graduated with a GPA of 3.0 or above |  | na | na | na | na
Master's Degree |  |  | na | na | na | na
Employed after graduation |  |  | m | m | m | m
Notes:
na = not offered; m = not tracked;
Spreadsheet: 765003d1643116619-consider-empty-cell-with-formula-book1
Sheet: Folha1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 8
Spreadsheet: 25695d1217177993-continuation-of-car-ownership-database-2-car-ownership-database
Sheet: Cambelt replacement list

Cambelt replacement list
 |  |  |  |  |  | Mileage
 |  |  |  |  | Below: | 90000
Cambelt needs replacing? | Cambelt Needs Replacing |  |  |  | Above: | 40000
Last row record? | TRUE
Surname | Forename | Home Phone No | Mobile No | [NAME] | Car Registration | Car Model | Car Milage
Truser | Martin | 01428 722456 | [PHONE] | BMW | 7NY 8TT | [NAME] | 70000
Here I would like a list of cars which need their cambelts replacing.
To do this, when the 'replace cambelt' on the '2008' worksheet says 'cambelt needs replacing' I would like the details of the car, owner and their contact details to appear here
Spreadsheet: 786865d1657520506-formula-to-find-the-multiple-values-and-consolidate-in-new-row-consolidatemultiplelines
Sheet: Data

Chars. | Task | Value
SKA1 | AA | TK01
SKA1 | BB | TE22
SKA1 | CC | VK10
SKA1 | DD | AS11
SKA1 | DD | AS26
SKA1 | EE | BA01
SKA1 | FF | BA02
SKA1 | GG | 122
SKA1 | GG | 340
SKA1 | GG | 520
SKA1 | GG | 540
SKA1 | HH
SKA1 | II
SKA1 | JJ
SKA1 | KK
SKA1 | LL
SKA1 | MM
SKA1 | NN
SKA1 | OO
SKA1 | PP
SKA1 | QQ
SKA1 | RR
SKA1 | SS
SKA1 | TT
SKA1 | UU
[NAME] | DD | AS22
[NAME] | DD | AS54
[NAME] | DD | AS59
[NAME] | EE
[NAME] | FF
[NAME] | GG | 220
[NAME] | GG | 260
[NAME] | HH
[NAME] | II
[NAME] | JJ
[NAME] | KK
[NAME] | LL
SKT2 | DD | AS19
SKT2 | EE
SKT2 | FF
SKT2 | GG | 740
SKT2 | HH
SKT2 | II
SKT2 | JJ
SKT2 | KK
SKT2 | LL
Spreadsheet: 68698d1269285000-show-specific-category-by-day-and-how-many-times-exemple
Sheet: Folha1

Time | Type | Category | Specific
2010-03-15 00:11:00 | [NAME] | Vegetble | Tomato
2010-03-15 00:21:00 | [NAME] | meet | Pork
2010-03-15 00:37:00 | [NAME] | Fish | Pescada
2010-03-15 01:01:00 | [NAME] | Fish | Pescada |  |  | Pork | Pescada | Tomato
2010-03-15 01:27:00 | [NAME] | Fish | Pescada |  | 2010-03-15 00:00:00 | 17 | 10 | 7
2010-03-15 01:41:00 | [NAME] | Fish | Pescada |  | 2010-03-16 00:00:00 | 0 | 9 | 2
2010-03-15 02:19:00 | [NAME] | Fish | Pescada
2010-03-15 02:23:00 | [NAME] | Fish | Pescada
2010-03-15 03:11:00 | [NAME] | Fish | Pescada
2010-03-15 04:01:00 | [NAME] | meet | Pork
2010-03-15 04:41:00 | [NAME] | meet | Pork
2010-03-15 05:45:00 | [NAME] | meet | Pork
2010-03-15 06:17:00 | [NAME] | Vegetble | Tomato
2010-03-15 06:43:00 | [NAME] | Vegetble | Tomato
2010-03-15 07:47:00 | [NAME] | Vegetble | Tomato
2010-03-15 07:59:00 | [NAME] | meet | Pork
2010-03-15 08:23:00 | [NAME] | meet | Pork
2010-03-15 08:31:00 | [NAME] | meet | Pork
2010-03-15 08:45:00 | [NAME] | meet | Pork
2010-03-15 09:35:00 | [NAME] | Vegetble | Tomato
2010-03-15 09:53:00 | [NAME] | meet | Pork
2010-03-15 11:19:00 | [NAME] | meet | Pork
2010-03-15 13:39:00 | [NAME] | meet | Pork
2010-03-15 14:57:00 | [NAME] | meet | Pork
2010-03-15 15:17:00 | [NAME] | meet | Pork
2010-03-15 15:49:00 | [NAME] | meet | Pork
2010-03-15 15:55:00 | [NAME] | meet | Pork
2010-03-15 17:11:00 | [NAME] | meet | Pork
2010-03-15 20:35:00 | [NAME] | meet | Pork
2010-03-15 20:43:00 | [NAME] | Fish | Pescada
2010-03-15 21:29:00 | [NAME] | Fish | Pescada
2010-03-15 21:36:00 | [NAME] | Fish | Pescada
2010-03-15 21:49:00 | [NAME] | Vegetble | Tomato
2010-03-15 22:45:00 | [NAME] | Vegetble | Tomato
2010-03-16 00:15:00 | [NAME] | Vegetble | Tomato
2010-03-16 00:35:00 | [NAME] | Vegetble | Tomato
2010-03-16 00:47:00 | [NAME] | Fish | Pescada
2010-03-16 03:29:00 | [NAME] | Fish | Pescada
2010-03-16 03:55:00 | [NAME] | Fish | Pescada
2010-03-16 04:33:00 | [NAME] | Fish | Pescada
2010-03-16 04:59:00 | [NAME] | Fish | Pescada
2010-03-16 05:05:00 | [NAME] | Fish | Pescada
2010-03-16 05:25:00 | [NAME] | Fish | Pescada
2010-03-16 06:09:00 | [NAME] | Fish | Pescada
2010-03-16 06:35:00 | [NAME] | Fish | Pescada