tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 868541d1715260995-i-need-to-alternate-content-in-column-a2-a3-etc-with-those-in-b2-b3-etc-sample-sheet
Sheet: Sheet1

Countries | Cities |  | Alternate them so…
Afghanistan | Bath |  | Afghanistan
Albania | Birmingham |  | Bath |  | Bath |  | Bath
Algeria | Bradford* |  | Albania |  | Albania |  | Albania
Andorra | Brighton & Hove |  | Birmingham |  | Birmingham |  | Birmingham
Angola | Bristol* |  |  |  | Algeria |  | Algeria
[NAME] and [NAME] | Cambridge |  |  |  | Bradford* |  | Bradford*
Argentina | Canterbury* |  |  |  | Andorra |  | Andorra
Armenia | Carlisle |  |  |  | Brighton & Hove |  | Brighton & Hove
Australia | [NAME] |  |  |  | Angola |  | Angola
Austria | [NAME] |  |  |  | Bristol* |  | Bristol*
Azerbaijan |  |  |  |  | [NAME] and [NAME] |  | [NAME] and [NAME]
 |  |  |  |  | Cambridge |  | Cambridge
 |  |  |  |  | Argentina |  | Argentina
 |  |  |  |  | Canterbury* |  | Canterbury*
 |  |  |  |  | Armenia |  | Armenia
 |  |  |  |  | Carlisle |  | Carlisle
 |  |  |  |  | Australia |  | Australia
 |  |  |  |  | [NAME] |  | [NAME]
 |  |  |  |  | Austria |  | Austria
 |  |  |  |  | [NAME] |  | [NAME]
 |  |  |  |  | Azerbaijan |  | Azerbaijan
 |  |  |  |  |  |  | 0
Spreadsheet: phillip_m_love__30657__9911_OA
Sheet: WE-GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  WEST
 |  |  | Total |  | Reclasses |  | November |  | December |  | January |  | February |  | March |  | April
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 75865d1276485117-count-and-sum-from-multiple-sheets-count-and-sum-from-multiple-sheets
Sheet: Summary

 |  |  | Sales Report
 | S.No. | Campus | No. of Registrations or Count of Campus (C) | Drop Out ( Count of Drop Out from Column Q) | Total Fee Due ( Sum From Column I) | Amount Paid In The Month Of  June'10 |  | Cumulative Amount Paid Till Date (Sum from Column I) | Bank Loan (Count of Bank Loan from Column Q
 |  |  |  |  |  | [NAME] ( Column K) | [NAME] (Column L)
 | 1 | AHMEDABAD | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2 | BANGALORE | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Grand Total
Spreadsheet: 717201d1612528401-extract-numbers-from-a-mixed-string-book4
Sheet: Sheet1

 | First | Second
120A_1BA_TEXTTEXTTEXTTEXT
1A_1BA_TEXTTEXTTEXTTEXT
28A_116BA_TEXTTEXTTEXTTEX
120A_1BA_TEXTTEXTTEXTTEXT
2A_2BA_TEXTTEXTTEXTTEXT
1A_135BA_TEXTTEXTTEXTTEXT
7A_88BA_TEXTTEXTTEXTTEXT
150A_120BA_TEXTTEXTTEXTTE
1A_0BA_TEXTTEXTTEXTTEXT
0A_58BA_TEXTTEXTTEXTTEXT
Spreadsheet: 21cfb8cc-0546-4513-affb-a75861d52a41
Sheet: Denial Rate Trend By Race

 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012
American Indian | 0.06666666666666667 | 0.1666666666666667 | 0.125 | 0.05882352941176471 | 0.02380952380952381 | 0.1785714285714286 | 0.02857142857142857
Asian | 0.09523809523809523 | 0.06666666666666667 | 0.226890756302521 | 0.1932367149758454 | 0.1256830601092896 | 0.1117647058823529 | 0.1893491124260355
Black or African American | 0.2941176470588235 | 0.5 | 0.3263157894736842 | 0.2037037037037037 | 0.0660377358490566 | 0.1842105263157895 | 0.2207792207792208
Native Hawaiian or Pacific Islander | 0 | 0.3333333333333333 | 0.3 | 0.1162790697674419 | 0.125 | 0.1481481481481481 | 0.1666666666666667
Hispanic | 0.1437699680511182 | 0.1826086956521739 | 0.1685393258426966 | 0.1146633876421765 | 0.08055274688237277 | 0.0967741935483871 | 0.09685729005667182
White | 0.1666666666666667 | 0.02325581395348837 | 0.3083333333333333 | 0.2045454545454546 | 0.1176470588235294 | 0.1457286432160804 | 0.1296296296296296
Overall Total | 0.1440217391304348 | 0.2004830917874396 | 0.1802074330164218 | 0.1213960546282246 | 0.0846751804553026 | 0.1010061919504644 | 0.1063569682151589
Spreadsheet: 43699d1242316691-conditional-formatting-3-conditions-conditional-formatting-by-date
Sheet: Sheet1

 | 2009-05-14 00:00:00
JOB # | DESC. | Mcam | TEFLON | SHIP | TO TEFLON | SHIP DATE
26082C | NISSAN L42A FRT DR FLASH REPAIR | JON | NO | 0 |  | 2009-05-14 00:00:00
26083D | NISSAN L42A RR DR FLASH REPAIR | JON | NO | 0 |  | 2009-05-14 00:00:00
27099A | HONDA ACURA SHOULDER HIP PAD | RYAN | NO | 3 |  | 2009-05-19 00:00:00
28036A | GMT 166-168 BIG TUB REVISION | JON | at TEFLON | 4 |  | 2009-05-20 00:00:00
29013A | B299N HEEL PAD NEW RH GAUGE | RYAN | YES | 5 | 2009-05-21 00:00:00 | 2009-06-01 00:00:00
29036 | HONDA SWA CENTER SUPPORT | TERRY | [NAME] | 7 |  | 2009-05-26 00:00:00
29012A | B299N HEEL PAD NEW RH | RYAN | NO | 11 |  | 2009-06-01 00:00:00
29014C | DS HEADREST | JON | YES | 19 | 2009-06-11 00:00:00 | 2009-06-19 00:00:00
29004A | HONDA TP6 REAR | MIAH | YES | 20 | 2009-06-14 00:00:00 | 2009-06-22 00:00:00
 |  |  | I NEED THESE GRAY SECTIONS TO REACT TO COLUMN E (SHIP)
 |  |  | FOR EXAMPLE, E5 IS ORANGE AND [NAME], I NEED THE CONTENTS
5 | DAYS TO ALLOW FOR TEFLON |  | IN A5, B5, F5, AND G5 TO BE ORANGE AND [NAME].
 | at TEFLON |  | THE SAME HOLDS TRUE FOR E8, I NEED THE SAME CELLS IN ROW 8
9 PAID | at TEXTURE |  | TO LOOK LIKE E8.
HOLIDAYS
2009-01-01 00:00:00
2009-03-10 00:00:00
2009-05-25 00:00:00
2009-07-06 00:00:00
2009-07-06 00:00:00
2009-07-08 00:00:00 | 4th OF JULY SHUT DOWN
2009-07-09 00:00:00
2009-07-10 00:00:00
2009-09-07 00:00:00
2009-11-23 00:00:00
2009-11-24 00:00:00
2009-12-24 00:00:00
2009-12-25 00:00:00
Spreadsheet: 170602d1343327210-smart-rounding-max-values-array-solved-tigeravatar-20example-20for-20xsoldoutx-1-
Sheet: Sheet1

 | Original | Adjusted
Total: | 0.9970000000000001 | 0.9990000000000001
Numbers: | 0.057 | 0.057
 | 0.057 | 0.057
 | 0.405 | 0.406
 | 0.405 | 0.406
 | 0.057 | 0.057
 | 0.008 | 0.008
 | 0.008 | 0.008
Spreadsheet: 709617d1608452082-do-i-use-index-and-match-to-count-products-on-different-sheets-stock-check-blanks-222222-1-
Sheet: A Aisle

 | Product code | Qty |  |  | Product code | Qty |  |  |  |  |  | A Aisle
A1A | apples | 3 |  | A5A |  |  |  |  |  |  |  | B Aisle
A1B | pears | 76 |  | A5B |  |  |  | want to count all of the different products |  |  |  | C Aisle
A1C | oranges | 44 |  | A5C |  |  |  | on this sheet: |  |  |  | D Aisle
A1D | grapes | 20 |  | A5D |  |  |  |  | This sheet | All sheets |  | E Aisle
A1E | plums | 50 |  | A5E |  |  |  | apples |  |  |  | F Rear Aisle
 |  |  |  |  |  |  |  | pears |  |  |  | F Front Aisle
A2A |  |  |  | A6A |  |  |  | oranges |  |  |  | G Aisle
A2B |  |  |  | A6B |  |  |  | grapes |  |  |  | Z Aisle
A2C |  |  |  | A6C |  |  |  | plums
A2D |  |  |  | A6D
A2E |  |  |  | A6E |  |  |  | Then I want to count all ths same products on the other sheets
 |  |  |  |  |  |  |  | to give me a grand total of my products.
A3A |  |  |  | A7A
A3B |  |  |  | A7B | apples | 2 |  | I have used fruit as an example
A3C |  |  |  | A7C | apples | 19
A3D |  |  |  | A7D | oranges | 5
[NAME] |  |  |  | A7E
A4A |  |  |  | A8A
A4B |  |  |  | A8B
A4C |  |  |  | A8C
A4D |  |  |  | A8D
A4E |  |  |  | A8E
 | Product code | Qty |  |  | Product code | Qty
A9A |  |  |  | A13A
A9B |  |  |  | A13B
A9C |  |  |  | A13C
A9D |  |  |  | A13D
A9E |  |  |  | A13E
A10A |  |  |  | A14A
A10B |  |  |  | A14B
[NAME] |  |  |  | A14C
A10D |  |  |  | A14D
A10E |  |  |  | A14E
A11A |  |  |  | A15A
A11B |  |  |  | A15B
A11C |  |  |  | A15C
A11D |  |  |  | A15D
A11E |  |  |  | A15E
A12A |  |  |  | A16A
A12B |  |  |  | A16B
A12C |  |  |  | A16C
A12D |  |  |  | A16D
A12E |  |  |  | A16E
 | Product code | Qty |  |  | Product code | Qty
A17A |  |  |  | A21A
A17B |  |  |  | A21B
A17C |  |  |  | A21C
A17D |  |  |  | A21D
A17E |  |  |  | A21E
A18A |  |  |  | A22A | apples | 8
A18B | pears | 44 |  | A22B | apples | 1
A18C | oranges | 6 |  | A22C
A18D | grapes | 11 |  | A22D
A18E |  |  |  | A22E
A19A |  |  |  | A23A | pears | 12
A19B | plums | 66 |  | A23B | oranges | 3
A19C | plums | 2 |  | A23C | grapes | 95
A19D |  |  |  | A23D | plums | 2
A19E |  |  |  | A23E
A20A | apples |  |  | A24A
A20B |  |  |  | A24B
A20C | pears |  |  | A24C | plums | 6
A20D | oranges |  |  | A24D
A20E | grapes |  |  | A24E
 | Product code | Qty |  |  | Product code | Qty
A25A |  |  |  | A29A
A25B |  |  |  | A29B | apples | 8
A25C |  |  |  | A29C | apples | 4
A25D |  |  |  | A29D
A25E |  |  |  | A29E
A26A |  |  |  | A30A
A26B |  |  |  | [NAME]
A26C |  |  |  | A30C
A26D |  |  |  | A30D
A26E |  |  |  | A30E
A27A |  |  |  | A31A
A27B |  |  |  | A31B
A27C |  |  |  | A31C
A27D |  |  |  | A31D
A27E |  |  |  | A31E
A28A |  |  |  | A32A
A28B |  |  |  | A32B
A28C |  |  |  | A32C
A28D |  |  |  | [NAME]
A28E |  |  |  | A32E
 | Product code | Qty
A33A
A33B
[NAME]
A33D
A33E
Spreadsheet: 93667d1293360702-highlight-rows-based-on-duplicate-with-conditions-highlight-dups-based-on-condtions
Sheet: Sheet1

Found | Option 1 | Target | Source | option 2 | Option 3 | Option 4 | Option 5 | Option 6 | Option 7
FOUND | yes | / | source 1 | [NAME] |  |  |  | YES | option 1
FOUND | no | / | source 2 | [NAME] |  |  |  | YES | option 1
FOUND | no | / | source 3 | [NAME] |  |  |  | YES | option 1
FOUND | yes | / | source 4 | anyword 2 |  |  |  | YES | option 1
FOUND | yes | /2 | source 5 | anyword 3 |  |  |  | YES | option 2
FOUND | no | / | source 6 | [NAME] |  |  |  | YES | option 2
Spreadsheet: 771490d1646696657-rank-and-provide-best-matches-between-two-tables-excel-forum-ranking
Sheet: Volunteer

ID | Tableu | Sharepoint | Power BI | Smartsheet | MS Excel | MS Word | MS Powerpoint | MS Project
1 | Expert | Novice | NA | Intermediate | Expert | Expert | Expert | Expert
2 | Intermediate | Intermediate | Novice | NA | NA | Intermediate | Intermediate | Intermediate
3 | Novice | Expert | Novice | Expert | Expert | Expert | Intermediate | Expert
4 | Novice | Novice | Novice | Novice | Expert | NA | Intermediate | Intermediate
Spreadsheet: 1714ceb9-de98-47b9-9a41-28e6b337212d
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
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 3. COMMERCIAL AND LEASE FINANCE COMMITMENTS By Lender: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Commercial Finance - Banks ; |  |  | Original | A2413463V | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Commercial Finance - Money market corporations ; |  |  | Original | A2413464W | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Commercial Finance - Finance companies ; |  |  | Original | A2413465X | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Commercial Finance - Other lenders ; |  |  | Original | A2413466A | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Commercial Finance - Total ; |  |  | Original | A2413467C | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Lease Finance - Banks ; |  |  | Original | A2413468F | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Lease Finance - Finance companies ; |  |  | Original | A2413469J | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Lease Finance - General financiers ; |  |  | Original | A2413470T | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Lease Finance - Other lessors ; |  |  | Original | A2413471V | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
Lease Finance - Total ; |  |  | Original | A2413472W | 1985-01-01 00:00:00 | 2009-12-01 00:00:00 | 300 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 836818d1689672138-data-transformation-power-query-data-into-the-one-record
Sheet: Before

Name | Subject | Date | Session
[NAME] | Math | 2023-07-14 00:00:00 | 1
[NAME] | English | 2023-07-11 00:00:00 | 2
[NAME] | Drama | 2023-07-11 00:00:00 | 1
[NAME] | Math | 2023-07-15 00:00:00 | 1
[NAME] | English | 2023-07-15 00:00:00 | 2
[NAME] | Drama | 2023-07-13 00:00:00 | 1
[NAME] | Science | 2023-07-13 00:00:00 | 3
Spreadsheet: monique_sanchez__28305__pos
Sheet: Sheet4

CurveGrp-> | IF-ELPO/PERMIAN | IF-ELPO/SJ | IF-HEHUB | IF-NWPL_ROCKY_M | IF-WAHA-TX | NG | NGI-MALIN | NGI-SOCAL | GDP-CAL BORDER | GDP-ELPO/PERM2 | GDP-ELPO/SANJUA | GDP-HEHUB | GDP-MALIN-CTYGA
Curve->
Risk-> | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | PRC | [NAME] | [NAME] | IM | IM | IM | IM | IM
PubCode->
DealType->
2001-05-01 00:00:00 | s | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2001-05-23 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.5 | 0 | 0 | 0 | -0.5
2001-05-24 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -0.5
2001-05-25 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -0.5
2001-05-26 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -0.5
2001-05-27 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -0.5
2001-05-28 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -0.5
2001-05-29 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -0.5
2001-05-30 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -0.5
2001-05-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -0.5
Jun, 2001 | 0 | -40.9 | 0 | -74.9 | 0 | -149.8 | 0 | 0 | 0 | 0 | 15 | 0 | 0
Jul, 2001 | 0 | -71.7 | 0 | -77.1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Aug, 2001 | 0 | -71.4 | 0 | -76.9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sep, 2001 | 0 | -69.2 | 0 | -74.1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Oct, 2001 | 0 | -15.3 | 0 | -61.1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Nov, 2001 | 0 | -29.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Dec, 2001 | 0 | -30.3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Jan, 2002 | 0 | -30.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Feb, 2002 | 0 | -27.2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Mar, 2002 | 0 | -30 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Apr, 2002 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
May, 2002 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Jun, 2002 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Jul, 2002 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Aug, 2002 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Sep, 2002 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Oct, 2002 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 84857d1284961889-selecting-entries-from-a-data-base-vegas-test-pay-sheet
Sheet: Sid Silverman

[NAME]
Date | Name | Rep | Pod | 1st TO | 2nd TO | Gross | Down | 649 | Net | Exit | [NAME] | P Exit | TO Pay | Pod Pay | Rep Pay | Total
2010-08-07 00:00:00 | Jones | [NAME] | [NAME] | [NAME] | [NAME] |  |  | 0 | 0 | 995 | 0 | 0 | 0 | 0 | 0 | 0
2010-08-10 00:00:00 | Sprinkle | [NAME] | [NAME] | [NAME] | [NAME] | 5644 | 5644 | 649 | 4995 |  | 0 | 0 | 0 | 0 | 0 | 0
2010-08-20 00:00:00 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | 3544 | 799 | 649 | 799 |  | 0 | 0 | 0 | 0 | 0 | 0
2010-08-29 00:00:00 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | 4995 | 4995 | 649 | 4346 |  | 0 | 0 | 0 | 0 | 0 | 0
2010-09-07 00:00:00 | [NAME] | Coy Smile | [NAME] | [NAME] | [NAME] | 4644 | 4644 | 649 | 3995 |  | 0 | 0 | 0 | 0 | 0 | 0
2010-09-07 00:00:00 | Palmer | [NAME] | [NAME] | [NAME] | [NAME] | 3544 | 799 | 649 | 799 |  | 0 | 0 | 0 | 0 | 0 | 0
2010-09-08 00:00:00 | Musall | [NAME] | [NAME] | [NAME] | [NAME] | 5500 | 5500 | 649 | 4851 |  | 0 | 0 | 0 | 0 | 0 | 0
2010-09-10 00:00:00 | Isaacs | [NAME] | [NAME] | [NAME] | [NAME] | 2500 | 2500 | 649 | 1851 |  | 0 | 0 | 0 | 0 | 0 | 0
2010-09-10 00:00:00 | Rega | [NAME] | [NAME] | [NAME] | [NAME] |  |  | 0 | 0 | 995 | 0 | 0 | 0 | 0 | 0 | 0
2010-09-11 00:00:00 | Walker | [NAME] | [NAME] | [NAME] | [NAME] | 3544 | 799 | 649 | 799 |  | 0 | 0 | 0 | 0 | 0 | 0
2010-09-12 00:00:00 | Rover | [NAME] | [NAME] | Coy Smile | Debroa Barker | 2995 | 2995 | 649 | 2346 |  | 0 | 0 | 0 | 0 | 0 | 0
2010-09-12 00:00:00 | DeYoung | [NAME] | [NAME] | Debroa Barker | [NAME] | 3544 | 3544 | 649 | 2895 |  | 0 | 0 | 0 | 0 | 0 | 0
2010-09-13 00:00:00 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | 5544 | 999 | 649 | 999 |  | 0 | 0 | 0 | 0 | 49.95 | 49.95
2010-09-13 00:00:00 | Birks | [NAME] | [NAME] | [NAME] | [NAME] | 1995 | 1995 | 649 | 1346 |  | 0 | 0 | 0 | 0 | 0 | 0
2010-09-16 00:00:00 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | 2995 | 2995 | 649 | 2346 |  | 0 | 0 | 0 | 0 | 0 | 0
2010-09-16 00:00:00 | Bekgevin | [NAME] | [NAME] | [NAME] | [NAME] |  |  | 0 | 0 | 995 | 0 | 0 | 0 | 0 | 0 | 0
2010-09-16 00:00:00 | Carver | [NAME] | [NAME] | [NAME] | [NAME] | 1995 | 1995 | 649 | 1346 |  | 0 | 0 | 0 | 0 | 67.3 | 67.3
2010-09-17 00:00:00 | [NAME] | [NAME] | [NAME] | Debroa Barker | [NAME] | 3644 | 3644 | 649 | 2995 |  | 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
 |  |  |  |  |  |  |  | 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 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 117.25 | 117.25
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Total | 117.25
Spreadsheet: 829417d1684217780-formula-to-find-a-given-number-in-a-row-midshires-master
Sheet: Results

INDIVIDUAL RESULT |  |  |  |  | TEAM |  | MIDDLE-4-DIDDLE |  |  |  |  |  |  |  |  | TEAM EVENT
No | PLAYER | PAR 3 | TOTAL |  | PLAYER | PLAYER | PLAYER | PLAYER | TOTAL | S/I 1 | S/I 2 | S/I 3 | S/I 4 |  |  |  | No | PLAYER | PLAYER | PLAYER | PLAYER | TOTAL | S/I 1 | S/I 2 | S/1/3 | S/1/4
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
11 |  |  |  |  | SKINS
12 |  |  |  |  | POT | 60
13 |  |  |  |  | HOLE
14 |  |  |  |  | 1
15 |  |  |  |  | 2
16 |  |  |  |  | 3
17 |  |  |  |  | 4
18 |  |  |  |  | 5
19 |  |  |  |  | 6
20 |  |  |  |  | 7
21 |  |  |  |  | 8
22 |  |  |  |  | 9
23 |  |  |  |  | 10
24 |  |  |  |  | 11
25 |  |  |  |  | 12
26 |  |  |  |  | 13
27 |  |  |  |  | 14
28 |  |  |  |  | 15
29 |  |  |  |  | 16
30 |  |  |  |  | 17
31 |  |  |  |  | 18
32
33
34 |  |  |  |  | Order of Merit Result | RANK | No |  | OoM | par 3
35 |  |  |  |  |  | 1 | 1
36 |  |  |  |  |  | 2 | 2
37 |  |  |  |  |  | 3 | 3
38 |  |  |  |  |  | 4 | 4
39 |  |  |  |  |  | 5 | 5
40 |  |  |  |  |  | 6 | 6
41 |  |  |  |  |  | 7 | 7
42 |  |  |  |  |  | 8 | 8
43 |  |  |  |  |  | 9 | 9
44 |  |  |  |  |  | 10 | 10
45 |  |  |  |  |  | 11 | 11
46 |  |  |  |  |  | 12 | 12
47 |  |  |  |  |  |  | 13
48 |  |  |  |  |  |  | 14
49 |  |  |  |  |  |  | 15
50 |  |  |  |  |  |  | 16
51 |  |  |  |  |  |  | 17
52 |  |  |  |  |  |  | 18
53 |  |  |  |  |  |  | 19
54 |  |  |  |  |  |  | 20
55 |  |  |  |  |  |  | 21
56 |  |  |  |  |  |  | 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
Spreadsheet: 792698d1661088157-splitting-numbers-from-texts-split-numbers-from-texts-hd
Sheet: Sheet1

 | Desired Result
Copied Data | + | -
01/07 CMS - CR PYMT MARS 1,164.63+ 289,724.35 | 1164.63
01/07 CHEQUE PROCESSING FEE .50- 289,723.85 |  | 0.5
01/07 INTER-BANK PAYMENT INTO A/C 906.30+ 290,630.15 | 906.3
01/07 INTER-BANK PAYMENT INTO A/C 115.76+ 290,745.91 | 115.76
02/07 CMS - CR PYMT MARS 838.44+ 291,584.35 | 838.44
02/07 TRANSFER TO A/C 166.10+ 291,750.45 | 166.1
02/07 TRANSFER TO A/C 237.05+ 292,384.45 | 237.05
02/07 TRANSFER FR A/C 300.00- 292,084.45 |  | 300
Spreadsheet: 125424d1319027227-problem-using-conditional-formatting-to-flag-cells-by-color-and-count-them-copy-of-example4
Sheet: Alindada

PT. # | LAST NAME | FIRST NAME | REQUIRED | IN DATE | COM DATE | NOTES |  |  | VISIT DATE
76925 |  |  | ATT | 2011-04-27 00:00:00 | 2011-05-16 00:00:00 | GOOD | Total # Yellow: | 0
80339 |  |  | DS [NAME] | 2011-05-14 00:00:00 | 2011-08-31 00:00:00 | DELIQUENT | Total # Orange: | 0
77195 |  |  | ATT | 2011-07-29 00:00:00 | 2011-08-31 00:00:00 | DELIQUENT | Total # Red: | 2 | should be 2
50085 |  |  | D/C Sum Sig | 2011-09-14 00:00:00 | 2011-10-11 00:00:00 | GOOD | Complient: | 4 | should be 4
81066 |  |  | DO | 2011-09-17 00:00:00 | 2011-10-11 00:00:00 | GOOD | All Total: | 6 | should be 6
55945 |  |  | D/C Sig | 2011-09-20 00:00:00 | 2011-10-11 00:00:00 | GOOD
 |  |  |  |  |  | In order to properly access | How do I get the spreadsheet to reflect this?
 |  |  |  |  |  | the progress of the providers
 |  |  |  |  |  | I need to flag the charts
 |  |  |  |  |  | that are completed after 30 days
 |  |  |  |  |  | RED. So the cell F3 would be red |  | Charts that are not complete
 |  |  |  |  |  | and therefore deliquent |  | after 30 days are deliquent
 |  |  |  |  |  | as would cell F4. All other cells
 |  |  |  |  |  | are good to go =) How can
 |  |  |  |  |  | I flag these cells that are
 |  |  |  |  |  | Deliquent as red?
Spreadsheet: eric_saibi__9912__102601R
Sheet: Pleasant Prairie 01

Owner Name |  | Wisconsin Electric Power Company
Station Name |  | Pleasant Prairie Power Station
Unit Name |  | Pleasant Prairie 01
NERC Region |  | MAIN
State |  | WI
Fuel Type |  | Coal
Capacity |  | 617 MW
Start Date |  | 2001-10-22 00:00:00
End Date |  | 2001-11-20 00:00:00
Prv. Start Date |  | 2001-10-27 00:00:00
Prv. End Date |  | 2001-11-25 00:00:00
Comments |  | Coal
SIC |  | 4911
Plant ID |  | 1012915
Unit ID |  | 1005900
Outage ID |  | 17340
Spreadsheet: 64055d1264912494-excel-2007-formula-for-multiple-criteria-excel-test
Sheet: Results

AHGFE | 1
BAHGF | 2
CBAHG | 3
ABCDE | 0
 |  |  | Should Return
Search for: | Total | Amt: | Total | Amt:
933 W Out Full 551 SN |  |  | 20 | 2000
933 WO Out Full 551 SN |  |  | 200 | 4500
933 WO Out Full 571 PT |  |  | 150 | 4500
939 WO Out Full 551 SN |  |  | 20 | 1500
939 WO Out LUP 551 SN |  |  | 0 | 0
939 WO Out PEP 551 SN |  |  | 0 | 0
999 W Out Full 551 SN |  |  | 50 | 7500