tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: c68094bf-3ee0-492b-9c1c-656c750c4af7
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5212 | 13652 | JP | Theberge | USA | 0 | [NAME] | 00:01:29 | 01:03:57 | 00:01:46 | 00:42:07 | 1 | 02:19:13
5212 | 31951 | Rivaldo | Martins | BRA | 0 | [NAME] | 00:02:13 | 01:06:16 | 00:02:35 | 00:45:27 | 2 | 02:20:37
5212 | 30746 | Ernst | Scheiber | AUT | 0 | 00:30:37 | 00:01:36 | [NAME] | 00:02:01 | [NAME] | 3 | 02:26:08
5212 | 13651 | Martin | Falch | AUT | 0 | [NAME] | 00:01:52 | 01:07:42 | [NAME] | 00:46:30 | 4 | 02:28:29
5212 | 7983 | [NAME] | Martin | USA | 0 | 00:33:17 | 00:01:26 | 01:05:38 | 00:02:16 | 00:51:02 | 5 | 02:33:38
5212 | 31683 | [NAME] | Szucs | BRA | 0 | 00:27:08 | 00:02:11 | 01:12:51 | [NAME] | 00:55:08 | 6 | 02:39:06
Spreadsheet: 793323d1661416374-apply-formula-based-on-blank-and-non-blank-cells-excel-forum-25-august
Sheet: Sheet1

Number | [NAME] | Discount Code | [NAME] to be displayed here
#28800 | [EMAIL] | michelsawma78 | 0
#28800 | [EMAIL] |  | 0
#28800 | [EMAIL] |  | 0
#28800 | [EMAIL] |  | 0
#28800 | [EMAIL] |  | 0
#28800 | [EMAIL] |  | 0
#28800 | [EMAIL] |  | 0
#29185 |  |  | 0
#29184 |  | MahmoudFree | 0
#29183 |  | souadmarket71 | 0
#29183 |  |  | 0
#29183 |  |  | 0
#29183 |  |  | 0
#29183 |  |  | 0
#29183 |  |  | 0
#29183 |  |  | 0
#29183 |  |  | 0
#29183 |  |  | 0
#29183 |  |  | 0
#29183 |  |  | 0
#29181 | [EMAIL] |  | 1
#29181 | [EMAIL] |  | 1
#29181 | [EMAIL] |  | 1
#29181 | [EMAIL] |  | 1
#29181 | [EMAIL] |  | 1
#29181 | [EMAIL] |  | 1
#29181 | [EMAIL] |  | 1
#29180 |  |  | 0
#29180 |  |  | 0
#29180 |  |  | 0
#29180 |  |  | 0
#29180 |  |  | 0
#29180 |  |  | 0
#29180 |  |  | 0
#29180 |  |  | 0
#29180 |  |  | 0
#29180 |  |  | 0
#29180 |  |  | 0
#29179 | [EMAIL] |  | 1
#29179 | [EMAIL] |  | 1
#29179 | [EMAIL] |  | 1
#29178 |  | harfouchtrading50 | 0
#29178 |  |  | 0
#29178 |  |  | 0
#28799 | [EMAIL] |  | 1
#28798 |  |  | 0
#28797 |  |  | 0
#28796 |  |  | 0
#28607 |  | Sponsor101 | 0
#28606 |  | WF30 | 0
#28605 |  | hadad71 | 0
Spreadsheet: 9e52e88b-5211-437b-9628-c244213e6a73
Sheet: Sheet1

International Programs Grant - Faculty Travel Budget | Unnamed: 1
Please be as detailed as possible and provide relevant documentation.  [NAME] additional lines as necessary.
Faculty name:                                         Dates of travel:
Item | Amount
1. Transportation – provide information on travel to and from and within course country/countries
Outbound/inbound travel:
In-country travel:
Mileage to & from airport and/or airport parking, shuttle, etc.
Other (departure tax, etc.):
Total transportation | 0
2. Accommodation - provide name of hotel(s) and rates for each; if not staying in hotel, please describe.
name:  ___ nights @ $_______ per night
name:  ___ nights @ $_______ per night
Total accommodation | 0
3. Meals - estimate food costs; www.lonelyplanet.com may be helpful
___ days @ $________ per day
___ days @ $________ per day
Total meals | 0
4. Other - please itemize (e.g. immunizations, visa fees, etc.)
Insurance* (TW Lord required @ $1 per day)
Total other | 0
TOTAL BUDGET | 0
5. If receiving funding from other sources, list source and amount.
Amount requested from International Programs | 0
If traveling before or on June 30, estimate amount expended before June 30. Include total airfare with this amt. even if you return in the next fiscal year.
If traveling after June 30, estimate amount expended after June 30.
* insurance form will be sent to you upon awarding of grant
Spreadsheet: 712054d1610033513-sumifs-month-help-monthspending-aligw
Sheet: Sheet1

Date | Amount
2020-06-17 00:00:00 | 20.99
2020-06-26 00:00:00 | 25.99 |  |  | Month Start | Month End | Sum
2020-06-27 00:00:00 | 20.99 |  |  | 2020-06-01 00:00:00
2020-06-27 00:00:00 | 17.99
2020-06-28 00:00:00 | 17.99
2020-06-29 00:00:00 | 5.49
2020-06-30 00:00:00 | 25.99
2020-07-01 00:00:00 | 17.99
2020-07-08 00:00:00 | 13.99
2020-07-11 00:00:00 | 11.99
2020-07-11 00:00:00 | 6.49
2020-07-11 00:00:00 | 24.99
2020-07-11 00:00:00 | 6.49
2020-07-11 00:00:00 | 24.99
2020-07-11 00:00:00 | 24.99
2020-07-11 00:00:00 | 11.99
2020-07-11 00:00:00 | 24.99
2020-07-12 00:00:00 | 24.99
2020-07-13 00:00:00 | 6.49
2020-07-14 00:00:00 | 25.99
2020-07-15 00:00:00 | 17.99
2020-07-20 00:00:00 | 6.49
2020-07-21 00:00:00 | 24.99
2020-07-21 00:00:00 | 6.49
2020-07-23 00:00:00 | 13.99
2020-07-25 00:00:00 | 9.99
2020-07-27 00:00:00 | 24.99
2020-07-28 00:00:00 | 25.99
2020-07-30 00:00:00 | 61.99
2020-08-02 00:00:00 | 6.49
2020-08-03 00:00:00 | 6.49
2020-08-03 00:00:00 | 6.49
2020-08-04 00:00:00 | 24.99
2020-08-04 00:00:00 | 6.49
2020-08-08 00:00:00 | 6.49
2020-08-08 00:00:00 | 21.99
2020-08-09 00:00:00 | 13.99
2020-08-11 00:00:00 | 25.99
2020-08-12 00:00:00 | 17.99
2020-08-15 00:00:00 | 6.49
2020-08-15 00:00:00 | 24.99
2020-08-15 00:00:00 | 6.49
2020-08-16 00:00:00 | 6.49
2020-08-16 00:00:00 | 24.99
2020-08-17 00:00:00 | 6.49
2020-08-18 00:00:00 | 24.99
2020-08-18 00:00:00 | 6.49
2020-08-18 00:00:00 | 61.99
2020-08-24 00:00:00 | 24.99
2020-08-27 00:00:00 | 6.49
2020-08-27 00:00:00 | 25.99
2020-08-29 00:00:00 | 17.99
2020-08-31 00:00:00 | 6.49
2020-09-01 00:00:00 | 139.99
2020-09-08 00:00:00 | 13.99
2020-09-08 00:00:00 | 13.99
2020-09-14 00:00:00 | 24.99
2020-09-14 00:00:00 | 6.49
2020-09-17 00:00:00 | 13.99
2020-09-19 00:00:00 | 10
2020-09-19 00:00:00 | 50
2020-09-22 00:00:00 | 24.99
2020-09-22 00:00:00 | 25.99
2020-09-25 00:00:00 | 17.99
2020-10-05 00:00:00 | 27.99
2020-10-06 00:00:00 | 27.99
2020-10-08 00:00:00 | 24.99
2020-10-08 00:00:00 | 25.99
2020-10-09 00:00:00 | 13.99
2020-10-11 00:00:00 | 17.99
2020-10-20 00:00:00 | 6.99
2020-10-23 00:00:00 | 24.99
2020-10-27 00:00:00 | 13.99
2020-10-31 00:00:00 | 109.99
2020-11-06 00:00:00 | 27.99
2020-11-19 00:00:00 | 24.99
2020-11-21 00:00:00 | 17.49
2020-11-23 00:00:00 | 6.45
2020-11-23 00:00:00 | 61.99
2020-11-27 00:00:00 | 69.99
2020-11-28 00:00:00 | 69.99
2020-11-29 00:00:00 | 6.45
2020-12-03 00:00:00 | 24.99
2020-12-07 00:00:00 | 25.99
2020-12-08 00:00:00 | 17.99
2020-12-08 00:00:00 | 17.99
2020-12-08 00:00:00 | 17.99
2020-12-09 00:00:00 | 13.99
Spreadsheet: john_griffith__15575__FetchContract
Sheet: Run Query

Input | First Contract | Second Contract |  |  |  |  | Results |  |  |  |  |  |  |  |  |  | Available Indexes
User ID: | model_pc | Spot Index |  |  |  |  | Period | From: |  | To: |  |  |  |  |  |  | None | d
Password: | model_pc | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dated BRENT | 1
UOM CD | EACH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unleaded US Gulf Pipe Mid | 4
Database | egsprod32 |  |  |  |  |  | Avg. Correlation |  |  |  |  |  |  |  |  |  | Jet 54 US Gulf Pipe Mid | 7
Start Date: | 2001-01-01 00:00:00 | True
End Date: | 2001-04-09 00:00:00
Curve Code | NG | IF-HPL/SHPCHAN
Curve Type CD | PR | PR
Book Type CD | P | D
Contract | 2001-06-01 00:00:00 | 2001-07-01 00:00:00
[NAME]
Number of days in rolling period |  | 10
Results:
Spreadsheet: 776096d1649497961-elaborate-the-else-condition-in-the-if-function-if-statement-aligw
Sheet: CLIENTS

CID | DENOMINATION | PHONE | VAT | FIRST NAME | LAST NAME | ADDRESS | POST | CITY | COUNTRY | [NAME] | WEBSITE | STATUS | LAST BILLED
9
8
7
6
5
4
3
2
1
Spreadsheet: 218868d1362596394-dynamic-drop-down-listing-test-worksheet
Sheet: KIT LOC OVERVIEW (2)

 |  | KIT | [NAME] |  |  | DURBAN | EWMS | GALLE | SUEZ | 21N - SEA PATROL
 |  | KIT004 | 21N - SEA PATROL
 |  | KIT001 | DURBAN
 |  | KIT002 | DURBAN
 |  | [NAME] | DURBAN
 |  | KIT008 | DURBAN
 |  | KIT010 | DURBAN
 |  | KIT003 | EWMS
 |  | KIT009 | EWMS
 |  | KIT006 | GALLE
 |  | KIT019 | SUEZ
 |  | KIT005
 |  | KIT011
 |  | KIT012
 |  | KIT013
 |  | KIT014
 |  | KIT015
 |  | KIT016
 |  | KIT017
 |  | KIT018
Spreadsheet: 106401d1303634810-military-rank-formula-example-workbook
Sheet: HHD

HHD
Rank | Last Name | First Name | [NAME] | Duty Status | Remarks
MSG |  |  |  | PDY | Assigned
CSM |  |  |  | PDY | Assigned
PV2 |  |  |  | PDY | Assigned
1LT |  |  |  | PDY | Assigned
SSG |  |  |  | PDY | Assigned
SPC |  |  |  | PDY | Assigned
SGT |  |  |  | PDY | Assigned
LTC |  |  |  | PDY | Assigned
2LT |  |  |  | PDY | Assigned
SPC |  |  |  | PDY | Assigned
MAJ |  |  |  | PDY | Assigned
PFC |  |  |  | PDY | Assigned
SFC |  |  |  | PDY | Assigned
SPC |  |  |  | PDY | Assigned
CW2 |  |  |  | PDY | Assigned
SGT |  |  |  | PDY | Assigned
SSG |  |  |  | PDY | Assigned
SFC |  |  |  | PDY | Assigned
CPT |  |  |  | PDY | Assigned
SGT |  |  |  | PDY | Assigned
SFC |  |  |  | PDY | Assigned
SSG |  |  |  | OLV | Assigned
SGT |  |  |  | PDY | Assigned
MAJ |  |  |  | PDY | Assigned
SFC |  |  |  | PDY | Assigned
SFC |  |  |  | PDY | Assigned
SPC |  |  |  | PDY | Assigned
SSG |  |  |  | PDY | Assigned
SSG |  |  |  | PDY | Assigned
CPT |  |  |  | PDY | Assigned
SFC |  |  |  | PDY | Assigned
SGT |  |  |  | PDY | Assigned (Temp)
SSG |  |  |  | PDY | Attached  (56)
PV2 |  |  |  | PDY | Attached (228)
SSG |  |  |  | PDY | Attached (228)
SSG |  |  |  | PDY | Attached (228)
SGT |  |  |  | PDY | Attached (228)
SPC |  |  |  | PDY | Attached (228)
SFC |  |  |  | PDY | Attached (519)
SSG |  |  |  | PDY | Attached (519)
SPC |  |  |  | PDY | Attached (519)
CW4 |  |  |  | PDY | Attached (56)
2LT |  |  |  | PDY | Attached (581)
SFC |  |  |  | PDY | Attached (581)
SSG |  |  |  | PDY | Attached (C Co 151)
SGT |  |  |  | PDY | Detached (BDE)
PFC |  |  |  | PDY | Detached (BDE)
TOTAL OFFICERS
TOTAL WARRANTS
TOTAL ENLISTED
TOTAL ATTACHED
TOTAL DETACHED
Spreadsheet: 857473d1706488801-listing-column-headings-based-on-cell-values-mosom-9-1-
Sheet: Sheet1

 | Role 1 | Role 2 | Role 3 | Role 4 | Role 5 |  |  | Drop down list of Permissions: | Permission 1
Permission 1 | y |  | y |  | y
Permission 2 |  | y |  | y
Permission 3 | y |  | y |  | y |  |  | What I want to appear: | Role 1
Permission 4 |  |  | y | y |  |  |  |  | Role 3
Permission 5 | y | y |  | y | y |  |  |  | Role 5
same data transposed:
 | Permission 1 | Permission 2 | Permission 3 | Permission 4 | Permission 5
Role 1 | y |  | y |  | y
Role 2 |  | y |  |  | y |  |  | Winning Formula:
Role 3 | y |  | y | y |  |  |  | (needed to transpose data first) | Role 3
Role 4 |  | y |  | y | y |  |  |  | Role 5
Role 5 | y |  | y |  | y
Spreadsheet: 97990d1297098402-change-numbers-to-words-examples-aranechan
Sheet: Sheet1

 | tenth | ninth | eigth | seventh | sixth | fifth | fourth | third | second | first
985236578 |  | 9 | 8 | 5 | 2 | 3 | 6 | 5 | 7 | 8 | nine eagle eight fish five monkey two mouse three worm six owl five snake seven cat eight dog
8436 |  |  |  |  |  |  | 8 | 4 | 3 | 6 | eight owl four snake three cat six dog
24 |  |  |  |  |  |  |  |  | 2 | 4 | two cat four dog
9 |  |  |  |  |  |  |  |  |  | 9 | nine dog
 | pigeon | eagle | fish | monkey | [NAME] | worm | owl | snake | cat | dog
1 = one
2 = two
3 = three
4 = four
5 = five
6 = six
7 = seven
8 = eight
9 = nine
Spreadsheet: 795889d1662991150-get-days-in-date-range-date
Sheet: Conteggi (2)

 |  |  |  |  |  |  |  |  |  | From      L | To           L | From      M | To          M | From     H | To           H
 |  |  |  |  |  |  |  |  |  | 2023-06-01 00:00:00 | 2023-06-30 00:00:00
 |  |  |  |  |  |  |  |  |  | 2023-09-01 00:00:00 | 2023-09-30 00:00:00 | 2023-07-01 00:00:00 | 2023-07-31 00:00:00 | 2023-08-01 00:00:00 | 2023-08-31 00:00:00
 | From | To | GG | L | M | H | correct   result
 | 2023-07-15 00:00:00 | 2023-08-15 00:00:00 |  |  |  |  | 0 | 17 | 15
 | 2023-07-10 00:00:00 | 2023-08-20 00:00:00 |  |  |  |  | 0 | 22 | 20
 | 2023-06-01 00:00:00 | 2023-09-30 00:00:00 |  |  |  |  | <--OK
 | 2023-07-01 00:00:00 | 2023-08-31 00:00:00 |  |  |  |  | 0 | 31 | 31
 | 249 | 259 | 259
Spreadsheet: 224994d1364848436-data-challenge-turning-massive-amounts-of-sales-order-data-into-summarized-customer-data-eforum-example
Sheet: Desired

Account |  | JAN | FEB | MAR | 2012 | 2011 | 2010
100000 | Total
100000 | # of Orders
100000 | [NAME]
100000 | Orders of $99+
100000 | Orders of $199+
100000 | Orders of $499+
100005 | Total
100005 | # of Orders
100005 | [NAME]
100005 | Orders of $99+
100005 | Orders of $199+
100005 | Orders of $499+
100010 | Total
100010 | # of Orders
100010 | [NAME]
100010 | Orders of $99+
100010 | Orders of $199+
100010 | Orders of $499+
100018 | Total
100018 | # of Orders
100018 | [NAME]
100018 | Orders of $99+
100018 | Orders of $199+
100018 | Orders of $499+
Spreadsheet: 825349d1681266242-cell-formatting-to-display-a-certain-text-or-number-try-out-report
Sheet: OT HRS Master

D A I L Y   L A B O R   R E P O R T
DISTRICT: |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | DATE:
FOREMAN: |  |  |  |  |  | R/M HIGHWAY |  | X |  |  | OTHER |  |  |  |  | APPROVED:
 |  |  |  |  |  |  |  |  |  |  | W.O. #
L A B O R |  |  |  |  |  |  |  |  |  |  | E Q U I P M E N T (County & Rental)
HC NO | PAY | NAME |  |  | AREA | JOB | HOURS | HRLY | AMOUNT |  | CH NO. | HOURS | HRLY | EQUIP | REMARKS
 | CODE |  |  |  | CODE | CODE |  | RATE |  |  |  |  | RATE | COST
316 |  |  |  |  |  |  | 199
1069 |  |  |  |  |  |  | 1
M A T E R I A L S  &  S U P P L I E S |  |  |  |  |  |  |  |  |  |  | J O B  C O S T  SUMMARY
QTY | ITEMS |  |  |  |  | AREA                  CODE | JOB          CODE | UNIT | AMOUNT |  | AREA | JOB | HRS |  |  | M/S | C/S | TOTAL
 |  |  |  |  |  |  |  | COST |  |  | CODE | CODE |  | LABOR | EQUIP
 |  |  |  |  |  |  |  |  |  |  | GRAND TOTAL
Spreadsheet: 65821d1266477796-urgently-need-help-sample
Sheet: Proses CTKI

 |  |  |  |  | 2010-02-18 00:00:00
 |  |  |  |  |  |  |  | Medical |  |  | BLK-LN
 |  |  | No. |  | Full name | Date of entry | To | Tgl.Medical | MC | Result | BLK | In | Out | Duration
 |  |  | 1 |  | Fatmah bt Udin | 2010-02-01 00:00:00 | saudi | 2010-02-02 00:00:00 | Tihama | fit | [NAME] |  |  | 17
 |  |  | 2 |  | [NAME] | 2009-12-12 00:00:00 | saudi | 2009-12-13 00:00:00 | Raihan | fit | Akbar |  |  | 68
 |  |  | 3 |  | [NAME] | 2009-12-13 00:00:00 | abu dhabi | 2009-12-13 00:00:00 | Tihama | fit | Dini Noer |  |  | 67
 |  |  | 4 |  | [NAME] | 2010-02-13 00:00:00 | kuwait | 2010-02-14 00:00:00 | Ar ridho | fit | Akbar |  |  | 5
 |  |  | 5 |  | [NAME] Saripudin | 2010-02-10 00:00:00 | Jordan | 2010-02-10 00:00:00 | salamat | fit | Dini Noer |  |  | 8
 |  |  | 6 |  | [NAME] | 2010-01-12 00:00:00 | malaysia | 2010-01-12 00:00:00 | salamat | fit |  |  |  | 37
 |  |  | 7 |  | [NAME] | 2010-01-12 00:00:00 | brunai | 2010-01-12 00:00:00 | salamat | fit | Dini Noer |  |  | 37
 |  |  | 8 |  | Ridwan bn tatang | 2010-02-15 00:00:00 | saudi | 2010-02-15 00:00:00 | salamat |  |  |  |  | 3
Spreadsheet: 697613d1601447381-using-index-and-match-but-omitting-some-results-report-help
Sheet: Work_load

Network | Contact | Sign Stat | [NAME] stat | Path stat | Address | Rate | Sign | PATH | DROP
2233412 | xxx-xxxx-xxxx | complete | canceled | complete | 123 Address | 2
2233412 | xxx-xxxx-xxxx | pending | complete | complete | 1b basemment | 1
2233412 | xxx-xxxx-xxxx | canceled | complete | complete | 23 flower garden | 4
2233412 | xxx-xxxx-xxxx | complete | pending | - | 12 can place | 2
2233412 | xxx-xxxx-xxxx | pending | pending | pending | 1 False st | 3
2233412 | xxx-xxxx-xxxx | canceled | pending | complete | 19 fake St | 4
2233412 | xxx-xxxx-xxxx | complete | complete | complete | 20 fake St | 1
2233412 | xxx-xxxx-xxxx | pending | complete | complete | 21 fake St | 4
2233412 | xxx-xxxx-xxxx | canceled | complete | - | 22 fake St | 2
2233412 | xxx-xxxx-xxxx | complete | canceled | - | 23 fake St | 3
5631412 | xxx-xxxx-xxxx | Scheduled | Scheduled | Scheduled | 162 Grand Ave
5631412 | xxx-xxxx-xxxx | Scheduled | Scheduled | Scheduled | 163 Grand Ave
5631412 | xxx-xxxx-xxxx | Scheduled | Scheduled | Scheduled | 164 Grand Ave
5631412 | xxx-xxxx-xxxx | Scheduled | Scheduled | Scheduled | 165 Grand Ave
5631412 | xxx-xxxx-xxxx | Scheduled | Scheduled | Scheduled | 166 Grand Ave
5631412 | xxx-xxxx-xxxx | Scheduled | Scheduled | Scheduled | 167 Grand Ave
5631412 | xxx-xxxx-xxxx | Scheduled | Scheduled | Scheduled | 168 Grand Ave
5631412 | xxx-xxxx-xxxx | Scheduled | Scheduled | Scheduled | 169 Grand Ave
5631412 | xxx-xxxx-xxxx | Scheduled | Scheduled | Scheduled | 170 Grand Ave
Spreadsheet: 722720d1615386061-use-icon-sets-to-display-difference-between-current-months-data-and-previous-month-example
Sheet: Sheet1

 |  | Changes | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00
 | Number of |  | 22 | 25
 | Number of |  | 24 | 24
 | Number of |  | 31 | 28
 | Number of |  | 28 | 28
 | Number of |  | 23 | 22
 |  | Changes | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00
 | Number of |  | 22 | 25 | 22
 | Number of |  | 24 | 24 | 24
 | Number of |  | 31 | 28 | 31
 | Number of |  | 28 | 28 | 28
 | Number of |  | 23 | 22 | 23
Spreadsheet: 697296d1601301735-nest-formula-to-display-text-expiring-certifications-template-shareable
Sheet: Status Report w_formulas

NAME | Certification | Expires | Days Remaining | Status |  | Today
 | Cogent | 2055-12-31 00:00:00 |  |  |  | Warning days |  | 90
 | Cogent | 2055-12-31 00:00:00
 | Cogent | 2055-12-31 00:00:00 |  |  |  |  |  | Legend
 | Cogent | 2055-12-31 00:00:00 |  |  |  |  |  | Expired
 | Cogent | 2055-12-31 00:00:00 |  |  |  |  |  | About to Expire
 | Cogent | 2055-12-31 00:00:00 |  |  |  |  |  | Valid
 | Cogent | 2055-12-31 00:00:00 |  |  |  |  |  | Indefinite
 | Cogent | 2055-12-31 00:00:00
 | Cogent | 2055-12-31 00:00:00
Spreadsheet: 794101d1661874727-vlookup-with-multiple-conditions-template-update
Sheet: Steel Detail

# | Qty | MATERIAL |  |  |  |  | MATERIAL | SHEET PRICE | POWDER | Price per [NAME] | MAX PER WIDTH | MAX PER LENGTH | MAX PER SHEET | Total SQ/FT | [NAME] | Length | Material | MATERIAL WEIGHT | TOTAL WEIGHT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shop Labor
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Solid | Powder | Shear&Brake | [NAME] | Shipping |  | shop labor steel detail |  | SELL |  | Material | Price
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1233
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0785
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0516
Total Cost |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Materials
Buy Price From CAGSIL NO ADD ON
Buy Price From CAGSIL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shop labor
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | `
Spreadsheet: 785328d1656344317-convert-date-using-number-that-is-not-formatted-correctly-dummy-list
Sheet: Sheet1

PHL Loan Number | Months DIFF DUE DATE | Current Due Date | DATE(YEAR(A2)+B2,MONTH(A2),DAY(A2))
1234567890 | 108 | 2022-06-01 00:00:00
 | 96 | 2022-06-02 00:00:00
 | 96 | 2022-06-03 00:00:00
 | 108 | 2022-06-04 00:00:00
 | 108 | 2022-06-05 00:00:00
 | 84 | 2022-06-06 00:00:00
 | 108 | 2022-06-07 00:00:00
 | 108 | 2022-06-08 00:00:00
 | 60 | 2022-06-09 00:00:00
 | 84 | 2022-06-10 00:00:00
 | 108 | 2022-06-11 00:00:00
 | 108 | 2022-06-12 00:00:00
 | 72 | 2022-06-13 00:00:00
 | 84 | 2022-06-14 00:00:00
 | 60 | 2022-06-15 00:00:00
 | 108 | 2022-06-16 00:00:00
 | 84 | 2022-06-17 00:00:00
 | 96 | 2022-06-18 00:00:00
 | 96 | 2022-06-19 00:00:00
 | 120 | 2022-06-20 00:00:00
 | 120 | 2022-06-21 00:00:00
 | 84 | 2022-06-22 00:00:00
 | 120 | 2022-06-23 00:00:00
 | 60 | 2022-06-24 00:00:00
 | 72 | 2022-06-25 00:00:00
 | 36 | 2022-06-26 00:00:00
 | 96 | 2022-06-27 00:00:00
 | 108 | 2022-06-28 00:00:00
 | 84 | 2022-06-29 00:00:00
 | 96 | 2022-06-30 00:00:00
 | 84 | 2022-07-01 00:00:00
 | 72 | 2022-07-02 00:00:00
 | 96 | 2022-07-03 00:00:00
 | 84 | 2022-07-04 00:00:00
 | 36 | 2022-07-05 00:00:00
 | 48 | 2022-07-06 00:00:00
 | 12 | 2022-07-07 00:00:00
 | 12 | 2022-07-08 00:00:00
Spreadsheet: 96824d1296104148-sum-if-sum-range-dependent-on-range-criteria-test-budget
Sheet: Budget Graph

 | Month | Jan |  | <<<<drop down list here
 | Monthly Budget | $/Mo. | 0.1 | 0.2 | 0.3 | 0.4 | 0.5 | 0.6 | 0.7 | 0.8 | 0.9 | 1 | 1.1 | 1.2 | 1.3 | 1.4 | 1.5 | Savings
 | Food |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jan
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Feb
 | Clothes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apr
 | Body |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jun
 | Work |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jul
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aug
 | Household |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sep
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Oct
 | Dogs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nov
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dec
 | Office
 | Internet
 | Nicor
 | ComED
 | Water
 | Mortgage
 | Entertainment
 | Computer
 | Video Game
 | Golf
 | Bowling
 | Alcohol
 | Event
 | [NAME].