tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 884770d1734025114-need-ti-find-a-matching-date-and-have-that-work-in-conjunction-with-formula-already-in-cel-t-off-order
Sheet: Team Matches

 | WEEK 1 |  | WEEK 2 |  | WEEK 3 |  | WEEK 4 |  | WEEK 5 |  | WEEK 6 |  | WEEK 7 |  | WEEK 8 |  | WEEK 9 |  | WEEK 10 |  | WEEK 11 |  | WEEK 12 |  | WEEK 13 |  | WEEK 14 |  | WEEK 15 |  | WEEK 16 |  | WEEK 17 |  | WEEK 18 |  | WEEK 19 |  | WEEK 20
Team # | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  |  |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1 |  | 1
 | 10 |  | 3 |  | 5 |  | 7 |  | 9 |  | 2 |  | 4 |  | 6 |  | 8 |  |  |  | 10 |  | 3 |  | 5 |  | 7 |  | 9 |  | 2 |  | 4 |  | 6 |  | 8
 | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 3 |  | 2 |  | 2 |  | 2 |  |  |  | 2 |  | 2 |  | 2 |  | 2 |  | 2 |  | 3 |  | 2 |  | 2 |  | 2
 | 9 |  | 10 |  | 4 |  | 6 |  | 8 |  | 9 |  | 3 |  | 5 |  | 7 |  |  |  | 9 |  | 10 |  | 4 |  | 6 |  | 8 |  | 9 |  | 3 |  | 5 |  | 7
 | 3 |  | 4 |  | 3 |  | 3 |  | 3 |  | 4 |  | 5 |  | 3 |  | 3 |  |  |  | 3 |  | 4 |  | 3 |  | 3 |  | 3 |  | 4 |  | 5 |  | 3 |  | 3
 | 8 |  | 9 |  | 10 |  | 5 |  | 7 |  | 8 |  | 9 |  | 4 |  | 6 |  |  |  | 8 |  | 9 |  | 10 |  | 5 |  | 7 |  | 8 |  | 9 |  | 4 |  | 6
 | 4 |  | 5 |  | 6 |  | 4 |  | 4 |  | 5 |  | 6 |  | 7 |  | 4 |  |  |  | 4 |  | 5 |  | 6 |  | 4 |  | 4 |  | 5 |  | 6 |  | 7 |  | 4
 | 7 |  | 8 |  | 9 |  | 10 |  | 6 |  | 7 |  | 8 |  | 9 |  | 5 |  |  |  | 7 |  | 8 |  | 9 |  | 10 |  | 6 |  | 7 |  | 8 |  | 9 |  | 5
 | 5 |  | 6 |  | 7 |  | 8 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  |  |  | 5 |  | 6 |  | 7 |  | 8 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9
 | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10 |  |  |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 10 |  | 10 |  | 10 |  | 10
 | WEEK 1 |  | WEEK 2 |  | WEEK 3 |  | WEEK 4 |  | WEEK 5 |  | WEEK 6 |  | WEEK 7 |  | WEEK 8 |  | WEEK 9 |  | WEEK 10 |  | WEEK 11 |  | WEEK 12 |  | WEEK 13 |  | WEEK 14 |  | WEEK 15 |  | WEEK 16 |  | WEEK 17 |  | WEEK 18 |  | WEEK 19 |  | WEEK 20
 | 2025-05-02 00:00:00
 | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5
 | 2 |  | 3 |  | 4 |  | 5 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 1
 | 3 |  | 4 |  | 5 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 1 |  | 2
 | 4 |  | 5 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 1 |  | 2 |  | 3
 | 5 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 1 |  | 2 |  | 3 |  | 4
Spreadsheet: 600673d1543905532-range-lookup-formula-example
Sheet: Sheet1

System | Min | [NAME] | DateToRevtive |  |  |  |  |  | System | Data Set | Result
OS_RHEL_7_2_FOR_SAP | 1 | 13 | "ok2" |  |  |  |  |  | OS_RHEL_7_2_FOR_SAP | 42
OS_RHEL_7_2_FOR_SAP | 90 | + | "ok3" |  |  |  |  |  | OS_RHEL_7_2_FOR_SAP | 12
OS_RHEL_7_2_FOR_SAP | 30 | 50 | "ok" |  |  |  |  |  | OS_RHEL_7_2_FOR_SAP | 99
Spreadsheet: 882342d1730720729-looking-up-data-in-a-different-worksheet-dataa
Sheet: ExportedPasswordsReworked

creditExpiry:"" | creditNumber:"" | modifiedDate:[PHONE] | notes:"none " | password:"xxxxxxxxx" | passwordList:[] | rev:122 | service:"Telegraph" | style:"" | type:1 | url:"none " | username:"[EMAIL]"}
creditExpiry:"" | creditNumber:"" | modifiedDate:[PHONE] | notes:"none " | password:"yyyyyy" | passwordList:[] | rev:5 | service:"Curve Theatre" | style:"website" | type:1 | url:"none " | username:"[EMAIL]"}
favorite:0 | modifiedDate:[PHONE] | notes:"none " | [NAME]" | passwordList:[{"changedate":"[PHONE]" | password:"zzzzzzzz"}] | passwordModifiedDate:"[PHONE]" | rev:3 | service:"Clear Score Protect" | style:"" | type:1 | url:"https://app.clearscore.com" | username:"[EMAIL]"}
Spreadsheet: louise_kitchen__22837__Hot List Update 4-30-01
Sheet: Bridgeline

Deal Description Sheet - 4/30/01
Bridgeline
Project Name | Description | Potential Valuation | Last Contact | Probability | Expected Closing (Month/Year) | Weekly Updates / Comments
Compensation Plan | Incentive Plan for President.  Recommend Accural Bonus Funding based on EBITDA performance targets.  Revision of Performance Review to incorporate new categories. | 0 |  | 1 | 2001-05-15 00:00:00 | Have sent out final version of Compensation documents to all [NAME] board members.  Setting up a meeting this week for final approval.  Presented draft documents to [NAME].
Blowfish | Sale of Napoleonville Land led by [NAME] / [NAME]. | 5 million. | 2001-04-20 00:00:00 | 1 | 2001-09-15 00:00:00 | Need to set up meetings with Oxy, Texas Brine and Dow.  [NAME].
13 & 14 Workorder | Workorder drafted by Technical Services for infrastructure to get pad gas out of Wells 13 & 14 on Dow property. | -847 K | 2001-04-30 00:00:00 | 1 | 2001-05-05 00:00:00 | Waiting on revised work order with new numbers for labor.  Accepted by [NAME].
Spreadsheet: 780285d1652373171-return-multiple-values-across-many-rows-and-columns-20210302-projects
Sheet: Earthworks

 |  | 2020-02-19 00:00:00
 | Task | Description | Contract Amount (ex GST) | Percent Complete | Billed To Date | Previously Billed | Current Billed
 | Stage 1 | Earthworks Standards and Specifications Review | 14740 |  |  | 13200
 | Stage 2 | Options Study and Coordination with Agencies | 2270 |  |  | 2270 | 0
 | Stage 3 | Technical Memo of Recommendations | 5670 |  |  | 4550 | 0
 |  | Project Total
 |  |  | Subtotal of This Invoice
 |  |  | GST
 |  |  | Invoice Total (Including GST)
 |  | 2020-06-29 00:00:00
 | Task | Description | Contract Amount (ex GST) | Percent Complete | Billed To Date | Previously Billed | Current Billed
 | Stage 1 | Earthworks Standards and Specifications Review | 14740 |  |  | 14740
 | Stage 2 | Options Study and Coordination with Agencies | 2270 |  |  | 2270 | 0
 | Stage 3 | Technical Memo of Recommendations | 5670 |  |  | 4550 | 1120
 |  | Project Total
 |  |  | Subtotal of This Invoice
 |  |  | GST
 |  |  | Invoice Total (Including GST)
Spreadsheet: 847915d1698759345-dropdown-list-with-links-to-other-cells-in-same-sheet-chip1951-test
Sheet: Sheet1

PRODUCTS |  |  | Drop down list here with links to each of the sections in col. A. So if I select Product Section 2 from the dropdown list, the live cell moves to A6 |  | Prices
Product section 1 |  |  | Section1
ABC
XYZ
hjk
Product Section 2
a456
b647
Product section 3
Hht
Kyt
BYT
Product section 4
U&&&
U777
L888
Product section 5
TTT
RRR
EEE
Spreadsheet: 260518d1377438784-vlookup-from-different-sheets-data-tracker-1
Sheet: Sheet1

Loan Number | Investor Loan Number | F/c sale date | STATUS | Touch Date | Followup | Comments | CBR ASKED | CBR RECE | BPO AS IS | BPO AS REPAIRED | BPO DATE | [NAME] | Date
598231454 | 1702685442 | F/c sale date is 9/11/2013 | [NAME] | 2013-08-05 00:00:00 | 2013-08-08 00:00:00 | Missing Documents |  |  |  |  |  | Done
609504303 | 1710814581 |  | [NAME] | 2013-08-02 00:00:00 | 2013-08-07 00:00:00 | Incomplete Tasks - "Property Data" |  |  |  |  |  | Done
596768701 | 1706647422 | F/c sale date is 8/22/2013 | DOCUMENT COLLECTIONS | 2013-08-05 00:00:00 | 2013-08-08 00:00:00 | Completed BPO Task | REQUIRED |  |  |  |  | Done
609021092 | 1698908219 | UNAVAILABLE | UNAVAILABLE | UNAVAILABLE | UNAVAILABLE | UNAVAILABLE | UNAVAILABLE | UNAVAILABLE | UNAVAILABLE | UNAVAILABLE | UNAVAILABLE | UNAVAILABLE
609677521 | 1694946315 | F/c sale date is 9/5/2013 | UNAVAILABLE | UNAVAILABLE | UNAVAILABLE | UNAVAILABLE | UNAVAILABLE | UNAVAILABLE | UNAVAILABLE | UNAVAILABLE | UNAVAILABLE | UNAVAILABLE
609563069 | 1712011132 |  |  |  |  |  |  |  |  |  |  | PENDING | 2013-08-06 00:00:00
609197405 | 1701685391 |  | D |  |  |  | REQUIRED |  |  |  |  | Done
596742648 | 1703840432 |  | DOCUMENT COLLECTIONS | 2013-08-05 00:00:00 | 2013-08-08 00:00:00 | Incomplete TasK - "Hardship Reasons (Agent)" |  |  |  |  |  | Done
608800058 | 1695459050 |  | [NAME] | 2013-08-02 00:00:00 | 2013-08-07 00:00:00 | Incompete Task |  |  |  |  |  | PENDING | 2013-07-29 00:00:00
607442100 | 1702444472 |  | [NAME] | 2013-08-02 00:00:00 | 2013-08-07 00:00:00 | Incompete Task | REQUIRED |  |  |  |  | Done
596727439 | 1702306108 |  | [NAME] | 2013-08-02 00:00:00 | 2013-08-07 00:00:00 | Incompete Task |  |  |  |  |  | Done
596525701 | 1701700436 | F/c sale date is 9/11/2013 | [NAME] | 2013-08-02 00:00:00 | 2013-08-07 00:00:00 | Incompete Task - "Financial Information (Agent)" | REQUIRED |  |  |  |  | Done
607314119 | 1700641726 |  | [NAME] | 2013-08-02 00:00:00 | 2013-08-07 00:00:00 | Incompete Task - "Upload 3rd Party Authorization" |  |  |  |  |  | ORDER
596730680 | 1702780965 |  | VERIFY OFFER | 2013-08-05 00:00:00 | 2013-08-08 00:00:00 | RE: BRP Form |  |  |  |  |  | Done
596727993 | 1702320619 |  | [NAME] | 2013-08-02 00:00:00 | 2013-08-07 00:00:00 | Incompete Task |  |  |  |  |  | Done
609258306 | 1703291783 |  | [NAME] | 2013-08-02 00:00:00 | 2013-08-07 00:00:00 | Incomplete Task - "Upload 3rd Party Authorization" |  |  |  |  |  | ORDER
607420874 | 1701981556 |  | [NAME] | 2013-08-02 00:00:00 | 2013-08-07 00:00:00 | Incomplete Task |  |  |  |  |  | PENDING | 2013-08-02 00:00:00
596700976 | 4004493368 |  | [NAME] | 2013-08-02 00:00:00 | 2013-08-07 00:00:00 | [NAME]Third Party Authorization form" | REQUIRED
Spreadsheet: mary_hain__25905__ENE Power Costs for Treasury Summit
Sheet: Summary

Calculated Short Position
 | Annual Load Growth
 | 0.03
 | Load (MWa) | Retained Generation | QF Contracts | [NAME] Utility Resources ($/MWH) | Utility Short Position (MWa) | Market Price to Cover Short | Added Cost for A/S ($/MWH) | TOTAL COST $/MWH | RETAIL RATE AFTER CPUC 1/4/01 ORDER $/MWH | GROSS MARGIN $/MWH
SCE
2001 |  |  |  |  |  |  | 1.584 |  | 75.65
2001-2005 (5-Yr) |  |  |  |  |  |  | 0.856 |  | 75.65
2001-2007 (7-Yr) |  |  |  |  |  |  | 0.79 |  | 75.65
2001-2010 (10-Yr) |  |  |  |  |  |  | 0.766 |  | 75.65
PG&E
2001 |  |  |  |  |  |  |  |  | 62.8
2001-2005 (5-Yr) |  |  |  |  |  |  | 0.973 |  | 62.8
2001-2007 (7-Yr) |  |  |  |  |  |  | 0.918 |  | 62.8
2001-2010 (10-Yr) |  |  |  |  |  |  | 0.919 |  | 62.8
Spreadsheet: 785108d1656155121-i-need-help-to-extract-data-status-from-one-sheet-to-another-vertically-to-horizontally-example-1-
Sheet: Horizontal

Employee ID | 22 | 23 | 24 | 25 | 26 | 27
P10
P12
P13
P14
P15
P16
IF IN THE DATA SHEET SAME DATE "ON TIME" "IN" AND "OUT" THEN IT MEAN "P"
IF HALF DAY OR SHORT LEAVE WILL SHOW HERE IN THIS SHEET.
Spreadsheet: 95054d1294760854-adding-info-book2_norm01-concatenate-
Sheet: CONCATENATE PROBLEM

 |  | Enter code parameters
A |  | S | 1 | 1 | A |  | S01001A1 | S01001A2 | S01001A3 | S01001A4 | S01001A5
B |  |  |  |  |  |  | S01002A1 | S01002A2 | S01002A3 | S01002A4 | S01002A5
C |  |  |  |  |  |  | S01003A1 | S01003A2 | S01003A3 | S01003A4 | S01003A5
D |  |  |  |  |  |  | S01004A1 | S01004A2 | S01004A3 | S01004A4 | S01004A5
E |  |  |  |  |  |  | S01005A1 | S01005A2 | S01005A3 | S01005A4 | S01005A5
F |  |  |  |  |  |  | S01006A1 | S01006A2 | S01006A3 | S01006A4 | S01006A5
G |  |  |  |  |  |  | S01007A1 | S01007A2 | S01007A3 | S01007A4 | S01007A5
H |  |  |  |  |  |  | S01008A1 | S01008A2 | S01008A3 | S01008A4 | S01008A5
I |  |  |  |  |  |  | S01009A1 | S01009A2 | S01009A3 | S01009A4 | S01009A5
J |  |  |  |  |  |  | S01010A1 | S01010A2 | S01010A3 | S01010A4 | S01010A5
K |  |  |  |  |  |  | S01011A1 | S01011A2 | S01011A3 | S01011A4 | S01011A5
L |  |  |  |  |  |  | S01012A1 | S01012A2 | S01012A3 | S01012A4 | S01012A5
M |  |  |  |  |  |  | S01013A1 | S01013A2 | S01013A3 | S01013A4 | S01013A5
N |  |  |  |  |  |  | S01014A1 | S01014A2 | S01014A3 | S01014A4 | S01014A5
O |  |  |  |  |  |  | S01015A1 | S01015A2 | S01015A3 | S01015A4 | S01015A5
P |  |  |  |  |  |  | S01016A1 | S01016A2 | S01016A3 | S01016A4 | S01016A5
Q |  |  |  |  |  |  | S01017A1 | S01017A2 | S01017A3 | S01017A4 | S01017A5
R |  |  |  |  |  |  | S01018A1 | S01018A2 | S01018A3 | S01018A4 | S01018A5
S |  |  |  |  |  |  | S01019A1 | S01019A2 | S01019A3 | S01019A4 | S01019A5
T |  |  |  |  |  |  | S01020A1 | S01020A2 | S01020A3 | S01020A4 | S01020A5
U |  |  |  |  |  |  | S01021A1 | S01021A2 | S01021A3 | S01021A4 | S01021A5
V |  |  |  |  |  |  | S01022A1 | S01022A2 | S01022A3 | S01022A4 | S01022A5
W |  |  |  |  |  |  | S01023A1 | S01023A2 | S01023A3 | S01023A4 | S01023A5
X |  |  |  |  |  |  | S01024A1 | S01024A2 | S01024A3 | S01024A4 | S01024A5
Y |  |  |  |  |  |  | S01025A1 | S01025A2 | S01025A3 | S01025A4 | S01025A5
Z |  |  |  |  |  |  | S01026A1 | S01026A2 | S01026A3 | S01026A4 | S01026A5
 |  |  |  |  |  |  | S01027A1 | S01027A2 | S01027A3 | S01027A4 | S01027A5
 |  |  |  |  |  |  | [NAME] | S01028A2 | S01028A3 | S01028A4 | S01028A5
 |  |  |  |  |  |  | S01029A1 | S01029A2 | S01029A3 | S01029A4 | S01029A5
 |  |  |  |  |  |  | S01030A1 | S01030A2 | S01030A3 | S01030A4 | S01030A5
 |  |  |  |  |  |  | S01031A1 | S01031A2 | S01031A3 | S01031A4 | S01031A5
 |  |  |  |  |  |  | S01032A1 | S01032A2 | S01032A3 | S01032A4 | S01032A5
 |  |  |  |  |  |  | S01033A1 | S01033A2 | [NAME] | S01033A4 | S01033A5
 |  |  |  |  |  |  | S01034A1 | S01034A2 | S01034A3 | S01034A4 | S01034A5
 |  |  |  |  |  |  | S01035A1 | S01035A2 | S01035A3 | S01035A4 | [NAME]
 |  |  |  |  |  |  | S01036A1 | S01036A2 | S01036A3 | S01036A4 | S01036A5
 |  |  |  |  |  |  | S01037A1 | S01037A2 | S01037A3 | S01037A4 | S01037A5
 |  |  |  |  |  |  | S01038A1 | S01038A2 | S01038A3 | S01038A4 | S01038A5
 |  |  |  |  |  |  | S01039A1 | S01039A2 | S01039A3 | S01039A4 | S01039A5
Spreadsheet: 550332d1512228984-table-with-blank-rows-at-the-top-and-sum-columns-2017-craft-buisness-expenses
Sheet: Income and Expenses

Date | Category | Location | Description | Income | Expense | YTD Total
12/01/2017 | supplies | [NAME] | saw blade, jig parts |  | -297.97
12/02/2017 | income | Heather | 24x36 blue | 195 | 56.5
Total
Spreadsheet: 87782d1287638366-age-column-populating-book2
Sheet: Sheet1

60 | Age
90 | End Analysis age
Simple way
Spreadsheet: 0442c9f2-30dc-4cc0-8949-0c2e0acac3ed
Sheet: Holds

2013-10-01 00:00:00 |  | Mental Holds (I.C. 66-326) by Ordering County
 |  |  |  |  |  |  |  | SFY2014 -YTD
 |  | 24 Hour-MD Hold | 24 Hour-Police Hold | Field Petition | Administrative Hold | County Total | Regional Total | 24 Hour-MD Hold | 24 Hour-Police Hold | Field Petition | Administrative Hold | County Total | Regional Total
Region 1 | Benewah | 2 | 3 |  |  |  |  | 3 | 4
 | [NAME] | 1 | 2 |  |  |  |  | 1 | 20
 | Boundary
 | Kootenai | 9 | 33 |  | 5 |  |  | 49 | 142 |  | 25
 | Shoshone |  |  |  |  |  |  | 1 | 8
Region 2 | Clearwater | 1 |  |  | 1 |  |  | 3 | 1 | 1 | 2
 | Idaho | 1 |  |  |  |  |  | 3 | 2 | 1
 | Latah | 5 | 1 |  |  |  |  | 10 | 11 | 2
 | Lewis |  |  |  |  |  |  |  |  | 2
 | Nez Perce | 6 | 5 |  |  |  |  | 32 | 16
Region 3 | Adams |  | 1 |  |  |  |  | 3 | 4
 | Canyon | 46 | 29 |  | 3 |  |  | 172 | 156 |  | 7
 | Gem | 4 | 3 |  |  |  |  | 7 | 12
 | Owyhee
 | Payette |  |  |  |  |  |  | 2 | 7
 | Washington |  | 3 |  |  |  |  | 5 | 7
Region 4 | [NAME] | 88 | 67 | 17 | 1 |  |  | 328 | 253 | 53 | 1
 | Boise |  | 1 |  |  |  |  |  | 3
 | Elmore | 3 | 3 |  |  |  |  | 5 | 8 | 1
 | Valley
Region 5 | Blaine | 1 | 2 |  |  |  |  | 4 | 7 | 1
 | [NAME] |  |  |  |  |  |  | 1 | 1 |  | 1
 | Cassia | 4 |  |  |  |  |  | 15
 | Gooding | 1 |  |  |  |  |  | 9
 | [NAME] | 1 |  |  |  |  |  | 6 | 2 |  | 4
 | Lincoln | 1 | 1 |  |  |  |  | 3 | 2
 | Minidoka | 1 |  |  |  |  |  | 6 | 5 |  | 3
 | [NAME] | 18 | 9 |  |  |  |  | 78 | 24 |  | 2
Region 6 | Bannock | 15 | 3 |  | 1 |  |  | 78 | 6 | 1 | 7
 | Bear Lake |  |  |  |  |  |  | 1 | 1
 | [NAME] |  |  |  |  |  |  | 1
 | Franklin | 1 |  |  |  |  |  | 2 | 3
 | Oneida |  |  |  |  |  |  | 1
 | Power | 1 |  |  |  |  |  | 3
Region 7 | Bingham | 6 | 1 |  | 1 |  |  | 10 | 4 |  | 32
 | [NAME] | 2 | 5 |  | 11 |  |  | 4 | 15 |  | 52
 | [NAME]
 | [NAME]
 | Custer |  |  |  |  |  |  |  | 2 |  | 1
 | Fremont |  | 2 |  |  |  |  |  | 2 |  | 1
 | [NAME] |  |  |  | 2 |  |  | 1 | 1 |  | 6
 | Lemhi |  |  |  |  |  |  |  | 2 |  | 1
 | [NAME] |  |  |  | 3 |  |  |  |  |  | 8
 | Teton |  |  |  |  |  |  | 2 | 1
Out of State and Other |  |  |  |  |  |  |  | 2
Statewide
Spreadsheet: 806919d1669668536-formula-ignoring-blank-cells-during-or-example
Sheet: tracker

 | test 1 |  | test 2 |  | test 3 |  | test 4 |  | test 5 |  |  |  | STATUS
 | Test Date | Scrore | Test Date | Score | Test Date | Score | Test Date | Score | Test Date | Score
[NAME] |  | 3 |  | 3 |  | 2 |  |  |  |  |  |  |  | In this situation it should say [NAME] (but it doesn’t because the formula is looking at test 4 and 5 being the same (they are blank) so it considers it "SAME"
 |  | 3 |  | 3 |  | 2 |  | 2 |  |  |  |  |  | In this situation it should say Same  (it seems to be looking at the blank test 5 as being lower even though its blank)
Spreadsheet: 33733d1230423598-consolidate-multiple-rows-of-data-into-1-row-for-each-record-consolidation_example
Sheet: Output

field1 | field2 | [NAME] | [NAME]
record1-field1number | record1-field2text | record1-field3text | record1-field4text | 1
0 | record2-field1number | record2-field2text | record2-field3text | 6
record1-field1number | record1-field2text | record1-field3text | record1-field4text | 1
0 | record2-field1number | record2-field2text | record2-field3text | 6
record1-field1number | record1-field2text | record1-field3text | record1-field4text | 1
0 | record2-field1number | record2-field2text | record2-field3text | 6
record1-field1number | record1-field2text | record1-field3text | record1-field4text | 1
0 | record2-field1number | record2-field2text | record2-field3text | 6
record1-field1number | record1-field2text | record1-field3text | record1-field4text | 1
0 | record2-field1number | record2-field2text | record2-field3text | 6
record1-field1number | record1-field2text | record1-field3text | record1-field4text | 1
0 | record2-field1number | record2-field2text | record2-field3text | 6
record1-field1number | record1-field2text | record1-field3text | record1-field4text | 1
0 | record2-field1number | record2-field2text | record2-field3text | 6
record1-field1number | record1-field2text | record1-field3text | record1-field4text | 1
0 | record2-field1number | record2-field2text | record2-field3text | 6
record1-field1number | record1-field2text | record1-field3text | record1-field4text | 1
0 | record2-field1number | record2-field2text | record2-field3text | 6
record1-field1number | record1-field2text | record1-field3text | record1-field4text | 1
 |  |  |  | 6
Spreadsheet: danny_mccarty__4629__3rdCEPipesContribution
Sheet: Commercial Net Contribution-TW

Revised 6/14/01 | First Quarter |  |  | Second Quarter |  |  | Third Quarter |  |  | Fourth Quarter |  |  | TOTAL
 | 3rd CE | 2nd CE | Plan | 3rd CE | 2nd CE | Plan | 3rd Ce | 2nd CE | Plan | 3rd CE | 2nd CE | Plan | 3rd CE | 2nd CE | Plan
Transwestern
Net Margins:
Demand & Commodity Margins | 50.3 | 50.3 | 38.1 | 45.9 | 45.9 | 38.3 | 41.2 | 40 | 38.1 | 39.1 | 39.5 | 37
Fuel | 12.4 | 12.4 | 8.5 | 8.8 | 8.8 | 7.6 | 8.9 | 9.2 | 7.9 | 8.2 | 9.4 | 9
Reserve | -9.3 | -9.3 | 0 | -0.7 | -0.7 | 0 | 0 | 10 | 0 | -0.4 | 0 | 0
STRETCH | 0 |  | 2.5 | 0 | 0 | 2.5 | 0 | 0 | 2.5 | 0 | 0 | 2.5
Target Adjustments | 0 | 0 | -0.3 | 0 | 0 | -1.7 | 0 | 0 | -1 | 0 | 0 | -1
Other Revenue | 0.1 | 0.1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Quarter Adjustment | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -0.1
Total Net Margins
Expenses | -4.3 | -4.3 | -3.2 | -2.5 | -2.5 | -3.4 | -2 | -2.8 | -3.2 | -2.9 | -3.3 | -3.6
Non-Recurring:
 | 0 | 0 | 0 |  | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
System Balancing Entries | -1.4 | -1.4 | 0 | 0.8 | 0.8 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Non-Recurring
TOTAL NET CONTRIB
Spreadsheet: 804164d1667922832-conditional-formatting-cond-frmt-dates
Sheet: Sheet1

 |  | year | <30day | >30days
2021-01-01 00:00:00
2021-02-01 00:00:00
2021-03-01 00:00:00 |  |  |  |  |  |  |  | AND( cell <> "", cell < date(year(today())-1,month(today()),day(today()) )
2021-04-01 00:00:00 |  |  |  |  |  |  |  | AND( cell <> "", cell < date(year(today()),month(today()),day(today())-30 )
2021-05-01 00:00:00 |  |  |  |  |  |  |  | AND( cell <> "", cell < date(year(today()),month(today()),day(today()))
2021-06-01 00:00:00
2021-07-01 00:00:00
2021-08-01 00:00:00 |  |  |  |  |  |  |  | Red - A year after the original date entered
2021-09-01 00:00:00 |  |  |  |  |  |  |  | Amber - 30 days before we reach the next year
2021-10-01 00:00:00 |  |  |  |  |  |  |  | Green - From date recorded until 30 days when it would change to Amber
2021-11-01 00:00:00
2021-12-01 00:00:00
2022-01-01 00:00:00
2022-02-01 00:00:00
2022-03-01 00:00:00
2022-04-01 00:00:00
2022-05-01 00:00:00
2022-06-01 00:00:00
2022-07-01 00:00:00
2022-08-01 00:00:00
2022-09-01 00:00:00
2022-10-01 00:00:00
2022-11-01 00:00:00
2022-12-01 00:00:00
2023-01-01 00:00:00
2023-02-01 00:00:00
Spreadsheet: 0890ba3d-4d0f-44ca-889f-a531e8ff4ca4
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Name | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  |  | Learner ID
 |  |  |  | School/College/University
Human Services: Early Childhood Development and Services
Career Pathway Plan of Study for ►Learners ►Parents ►Counselors ►Teachers/Faculty
This Career Pathway Plan of Study (based on the Early Childhood Development and Services Pathway of the Human Services Career Cluster) can serve as a guide, along with other career planning materials, as
learners continue on a career path. Courses listed within this plan are only recommended coursework and should be individualized to meet each learner’s educational and career goals. *This Plan of Study, used
for learners at an educational institution, should be customized with course titles and appropriate high school graduation requirements as well as college entrance requirements.
EDUCATION | LEVELS | GRADE | [NAME] | Math | Science | Social Studies/ Sciences | Other Required Courses Other Electives Recommended       Electives                         Learner Activities | *Career and Technical Courses                    and/ or Degree Major Courses for            Early Childhood Development and Services Pathway | SAMPLE                                   Occupations Relating                            to This Pathway
 |  | Interest Inventory Administered and Plan of Study Initiated for all Learners
[NAME] |  | 9 |  |  |  |  |  |  | Occupations Requiring Less Than a Baccalaureate Degree                       ►Childcare Assistant/Worker ►Nanny ►Teacher Assistant                              .                                                                     .                                                                         .                                                           Occupations Requiring Baccalaureate Degree                                                 ►Assistant Director, Childcare                 .   Facilities ►Director, Childcare Facilities ►Educator for Parents ►Elementary School Counselor ►Preschool Teacher
 |  | 10
 |  | 11
 |  | College Placement Assessments-Academic/Career Advisement Provided
 |  | 12
 |  | Articulation/Dual Credit Transcripted-Postsecondary courses may be taken/moved to the secondary level for articulation/dual credit purposes.
POSTSECONDARY |  | Year 13
 |  | Year14
 |  | Year 15
 |  | Year 16
 |  |  |  |  |  | Project funded by the U.S. Department of Education (VO51B020001)
Spreadsheet: 107415d1304594527-incrementing-a-column-by-reference-of-another-book1
Sheet: Sheet2

 |  |  |  |  |  |  | 0
1. | Xyz. | 1 |  |  |  | 1. | 1 | Xyz. | 1
2-3. | Abc. | 2 |  |  |  | 2-3. | 2 ~ 3 | Abc. | 2
4-7. | Lmn. | 4 |  |  |  | 4-7. | 4 ~ 7 | Lmn. | 4
8. | [NAME]. | 1 |  |  |  | 8. | 8 | [NAME]. | 1
 |  |  |  |  |  |  | 9 ~ 8
 |  |  |  |  |  |  | 9 ~ 8
 |  |  |  |  |  |  | 9 ~ 8
 |  |  |  |  |  |  | 9 ~ 8
 |  |  |  |  |  |  | 9 ~ 8
 |  |  |  |  |  |  | 9 ~ 8
 |  |  |  |  |  |  | 9 ~ 8
 |  |  |  |  |  |  | 9 ~ 8
 |  |  |  |  |  |  | 9 ~ 8
 |  |  |  |  |  |  | 9 ~ 8
 |  |  |  |  |  |  | 9 ~ 8
 |  |  |  |  |  |  | 9 ~ 8
 |  |  |  |  |  |  | 9 ~ 8
 |  |  |  |  |  |  | 9 ~ 8