tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 806891d1669652439-help-converting-an-attendance-tracker-from-days-to-hrs-attendance-pbi
Sheet: Detailed View

 | Overview |  | Detailed View |  |  |  | Employees |  |  |  | [NAME] |  |  |  | Reports |  |  |  | Settings |  |  |  | How to Use
 | Employee: |  |  | Year |  | 2023 |  |  | End Date
 | ID : |  |  |  |  |  |  | Name : |  |  |  |  | An Other |  |  |  |  |  | < - Select Employee
 | Department : |  |  |  |  |  |  | Position :
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Working Hours Total
 | Shift : |  |  |  |  |  |  | Holiday Entitlement :
 | Start Date :
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Leave Hours | Worked Hours | Working Hours Per Month
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | Pass Outs
Spreadsheet: 705300d1605996461-format-cells-if-they-contain-certain-words-condfrm-etaf-1-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wid
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hgt
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wgt
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | User1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | User2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | User3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | user1 | user1 |  | #[NAME]!
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | hgt |  | #value
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | wid
 | User2 | wid
 | User3
 | User4
Spreadsheet: d640de8c-10b6-4760-a790-b8a578c2c1a0
Sheet: Sheet3 (2)

Regulus | 11.9 | Degrees Declination |  | Time | 0.81 | 360 |  | 15.04 | * Time *
 |  |  |  | 86164 |  |  | TFOV = 15.04*T*Cos(delta)
 | Time |  | Time |  | Time |  |  | Time |  | Time |  | Time |  |  | Time |  | Time |  | Time
25mm |  | 2x Barlow | 102.64 | 3x Barlow | 72.8 |  | 18mm | 92.91 | 2x Barlow | 61.84 | 3x Barlow | 41.3 |  | 8mm | 59.47 | 2x Barlow | 41.64 | 3x Barlow | 27.23
Plossl | 163.04 |  | 102.16 |  | 73.53 |  | [NAME] | 93.09 |  | 61.81 |  | 41.08 |  | TMB II | 58.75 |  | 41.07 |  | 27.47
 | 163.54 |  | 102.36 |  | 73.33 |  |  | 92.59 |  | 61.7 |  | 41.78 |  |  | 58.93 |  | 41.36 |  | 27.1
 | 163.12 |  | 96.6 |  | 73.46 |  |  | 93.07 |  | 61.98 |  | 41.7 |  |  | 58.88 |  | 41.5 |  | 27.4
 | 163.43 |  | 99.05 |  | 72.99 |  |  | 92.57 |  | 62.16 |  | 41.79 |  |  | 59.17 |  | 41.65 |  | 27.6
Avg
TFOV |  |  |  |  |  |  | TFOV |  |  |  |  |  |  | TFOV
 | Barlow
 | Time |  | Time |  | Time |  |  | Time |  | Time |  | Time |  |  | Time |  | Time |  | Time
10mm | 63.89 | 2x Barlow | 40.6 | 3x Barlow | 28.12 |  | 12mm | 67.63 | 2x Barlow | 44.91 | 3x Barlow | 30.42 |  | 6mm | 43.55 | 2x Barlow | 31.51 | 3x Barlow | 20.81
 | 63.24 |  | 41.8 |  | 28.24 |  |  | 67.31 |  | 44.72 |  | 30.28 |  |  | 44.85 |  | 31.79 |  | 20.74
 | 63.26 |  | 41.12 |  | 28.3 |  |  | 67.64 |  | 44.19 |  | 30.38 |  |  | 44.51 |  | 31.39 |  | 20.32
 | 63.79 |  | 41.33 |  | 27.79 |  |  | 67.62 |  | 44.57 |  | 30.2 |  |  | 44.07 |  | 31.4 |  | 20.21
 | 63.73 |  | 41.06 |  | 27.87 |  |  | 67.77 |  | 43.79 |  | 31.13 |  |  | 44.67 |  | 31.58 |  | 20.54
TFOV |  |  |  |  |  |  | TFOV |  |  |  |  |  |  | TFOV
Spreadsheet: 761994d1641334270-date-and-time-format-conversion-ugly-dates
Sheet: Sheet1

Date & Time | Date | Time (hour)
Tue, Dec 28, 2021, 11:36 AM (7 days ago) | 2021-12-28 00:00:00 | 11:00:00
Tue, Dec 28, 2021, 11:36 AM (7 days ago) | 2021-12-28 00:00:00 | 11:00:00
Mon, Dec 27, 2021, 10:33 PM (8 days ago) | 2021-12-27 00:00:00 | 22:00:00
Mon, Dec 27, 2021, 10:55 PM (8 days ago) | 2021-12-27 00:00:00 | 22:00:00
Mon, Dec 27, 2021, 10:59 PM (8 days ago) | 2021-12-27 00:00:00 | 22:00:00
Mon, Dec 27, 2021, 10:59 PM (8 days ago) | 2021-12-27 00:00:00 | 22:00:00
Mon, Dec 27, 2021, 11:07 PM (8 days ago) | 2021-12-27 00:00:00 | 23:00:00
Mon, Dec 27, 2021, 11:07 PM (8 days ago) | 2021-12-27 00:00:00 | 23:00:00
Tue, Dec 28, 2021, 1:06 PM (7 days ago) | 2021-12-28 00:00:00 | 13:00:00
Tue, Dec 28, 2021, 1:06 PM (7 days ago) | 2021-12-28 00:00:00 | 13:00:00
Tue, Dec 28, 2021, 1:06 PM (7 days ago) | 2021-12-28 00:00:00 | 13:00:00
Tue, Dec 28, 2021, 1:07 AM (7 days ago) | 2021-12-28 00:00:00 | 01:00:00
Tue, Dec 28, 2021, 1:07 AM (7 days ago) | 2021-12-28 00:00:00 | 01:00:00
Tue, Dec 28, 2021, 1:10 PM (7 days ago) | 2021-12-28 00:00:00 | 13:00:00
Tue, Dec 28, 2021, 1:17 PM (7 days ago) | 2021-12-28 00:00:00 | 13:00:00
Tue, Dec 28, 2021, 1:22 AM (7 days ago) | 2021-12-28 00:00:00 | 01:00:00
Tue, Dec 28, 2021, 1:40 PM (7 days ago) | 2021-12-28 00:00:00 | 13:00:00
Tue, Dec 28, 2021, 1:40 PM (7 days ago) | 2021-12-28 00:00:00 | 13:00:00
Tue, Dec 28, 2021, 1:43 PM (7 days ago) | 2021-12-28 00:00:00 | 13:00:00
Tue, Dec 28, 2021, 1:43 PM (7 days ago) | 2021-12-28 00:00:00 | 13:00:00
Spreadsheet: 272936d1382550776-need-formula-to-count-cells-in-row-based-on-info-in-other-colums-excel-forum-example-2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Store Rank by Factor
Product Factors |  |  |  |  | Factor Importance |  |  |  |  | Store |  |  |  |  | Factor 1 |  |  |  |  | Factor 2 |  |  |  |  | Factor 3 |  |  |  |  | Factor 4 |  |  |  |  | Factor 5
Factor 1 | Factor 2 | Factor 3 | Factor 4 | Factor 5 | Importance 1 | Importance 2 | Importance 3 | Importance 4 | Importance 5 | Store 1 | Store 2 | Store 3 | Store 4 | Store 5 | Store 1 | Store 2 | Store 3 | Store 4 | Store 5 | Store 1 | Store 2 | Store 3 | Store 4 | Store 5 | Store 1 | Store 2 | Store 3 | Store 4 | Store 5 | Store 1 | Store 2 | Store 3 | Store 4 | Store 5 | Store 1 | Store 2 | Store 3 | Store 4 | Store 5
Price | Color | Size | Shape | Quality | 1 | 2 | 3 | 4 | 5 | A | B | C | D | E | 2 | 1 | 3 | 4 | 5 | 1 | 3 | 2 | 4 | 5 | 5 | 1 | 2 | 4 | 3 | 4 | 3 | 2 | 1 | 5 | 3 | 2 | 4 | 1 | 5
Price | Size | Shape |  |  | 2 | 1 | 3 |  |  | A | B |  |  |  | 1 | 2 |  |  |  | 2 | 1 |  |  |  | 1 | 2
Color | Price | Quality |  |  | 3 | 1 | 2 |  |  | A | D | E | C |  | 3 | 1 | 2 | 4 |  | 1 | 2 | 3 | 4 |  | 4 | 3 | 2 | 1
Price | Size |  |  |  | 1 | 2 |  |  |  | A | B | D |  |  | 1 | 3 | 2 |  |  | 2 | 1 | 3
Quality | Shape | Size | Color |  | 4 | 2 | 1 | 3 |  | A | D | E | B |  | 3 | 2 | 4 | 1 |  | 2 | 3 | 1 | 4 |  | 4 | 1 | 2 | 3 |  | 2 | 3 | 1 | 4
 |  |  |  |  | See Comment on F18
 |  |  |  |  | Number of times [NAME] is listed per Factor
 |  |  |  |  | Price | Color | Size | Shape | Quality | Total
 |  |  |  | A | 4 | 3 | 4 | 3 | 3
 |  |  |  | B | 3 | 2 | 4 | 3 | 2
 |  |  |  | C | 2 | 2 | 1 | 1 | 2
 |  |  |  | D | 3 | 3 | 3 | 2 | 3
 |  |  |  | E | 2 | 3 | 2 | 2 | 3
 |  |  |  | Total
Spreadsheet: 783951d1655308873-summary-page-that-automatically-adds-new-row-when-a-new-tab-is-created-wip-metrc-submission-forms-sample
Sheet: FP6425

 | WASH UID | INTERNAL CODE |  | DISTILLATE UID |  | WEIGHT (g) | TBR UID | WEIGHT (g) | Completed By: |  |  | Date: | OZ-G CONVERSION
 | 6331 | 2F3 |  | 6425 |  | 8636.81 | 7425 | 510 |  |  |  |  |  |  | Product UID | Multiplier | Biomass Liability/Product
 |  |  |  |  |  |  |  |  |  |  |  |  | Enter Weight Here
 | Have WIP UID been wasted? |  |  |  |  |  |  | Total Biomass for Entire Lot (g)
 | #1 Short Path Internal Code:
 | Pre SP UID |  | 1255 | Post- SP UID |  | 3254 | SP By-Product UID |  | 2456 | SP By-Product Weight (g) |  | 1205
 | Crude UID #1 | 1254 |  | Crude UID #2 | 2135 |  | Crude UID #3 |  |  | Crude UID #4
 | Total Raw Materials (Wip Trim) (g) |  | 54000 | Total Raw Materials (Wip Trim) (g) |  | 45000 | Total Raw Materials (Wip Trim) (g) |  |  | Total Raw Materials (Wip Trim) (g)
 | TPP UID |  | 1253 | TPP UID |  | 2134 | TPP UID |  |  | TPP UID
 | #2 Short Path Internal Code:
 | Pre SP UID |  | 2255 | Post- SP UID |  | 4254 | SP By-Product UID |  | 3456 | SP By-Product Weight (g) |  | 2500
 | Crude UID #1 | 2254 |  | Crude UID #2 | 3135 |  | Crude UID #3 |  |  | Crude UID #4
 | Total Raw Materials (Wip Trim) (g) |  | 32000 | Total Raw Materials (Wip Trim) (g) |  | 51000 | Total Raw Materials (Wip Trim) (g) |  |  | Total Raw Materials (Wip Trim) (g)
 | TPP UID |  | 3255 | TPP UID |  | 3134 | TPP UID |  |  | TPP UID
 | #3 Short Path Internal Code:
 | Pre SP UID |  |  | Post- SP UID |  |  | SP By-Product UID |  |  | SP By-Product Weight (g)
 | Crude UID #1 |  |  | Crude UID #2 |  |  | Crude UID #3 |  |  | Crude UID #4
 | Total Raw Materials (Wip Trim) (g) |  |  | Total Raw Materials (Wip Trim) (g) |  |  | Total Raw Materials (Wip Trim) (g) |  |  | Total Raw Materials (Wip Trim) (g)
 | TPP UID |  |  | TPP UID |  |  | TPP UID |  |  | TPP UID
 | #4 Short Path Internal Code:
 | Pre SP UID |  |  | Post- SP UID |  |  | SP By-Product UID |  |  | SP By-Product Weight (g)
 | Crude UID #1 |  |  | Crude UID #2 |  |  | Crude UID #3 |  |  | Crude UID #4
 | Total Raw Materials (Wip Trim) (g) |  |  | Total Raw Materials (Wip Trim) (g) |  |  | Total Raw Materials (Wip Trim) (g) |  |  | Total Raw Materials (Wip Trim) (g)
 | TPP UID |  |  | TPP UID |  |  | TPP UID |  |  | TPP UID
Spreadsheet: 02e36d03-14a0-4c29-9e83-502963ef59c7
Sheet: 3-6T

 | Section 3: Cost
 | Table 3-6Trend:  Cost Per Mile - Commercially Leased Vehicles by Year
 | Vehicle Type | 2009 | 2010 | 2011 | 2012 | 2013
 | Passenger Vehicles | 1.700169 | 0.7481 | 1.37461 | 1.462025 | 0.639741
 | Trucks | 2.039689 | 1.379583 | 1.469239 | 1.579758 | 1.254866
 | Other | 3.047249 | 3.088736 | 2.612236 | 2.50474 | 2.773011
 | Overall | 2.010334 | 1.115244 | 1.554217 | 1.626436 | 1.00639
Spreadsheet: 0284e22a-2ac7-42a7-b3ab-29225bcff66b
Sheet: Sheet1

Line # | Exit Codes | Code | 2009 Counts | Changes or Issues
1 | Transferred to Adult Education | AE | 771 | Proposal to eliminate code, use DO instead.
2 | Death | DE | 90
3 | Dropout | DO | 8149
4 | Expelled | EX | 82
5 | Foreign Exchange Student | FE | 100 | Use for FE students returning to home country.
6 | GED | GE | 215 | Proposal to eliminate code, use DO instead.
7 | Transferred to [NAME], except UCAT | HE | 3
8 | Other Graduate | OG | 0
9 | Early Graduate - 1st Quarter Senior Year | Q1 | 47
10 | Early Graduate - 2nd Quarter Senior Year | Q2 | 424
11 | Early Graduate - 3rd Quarter Senior Year | Q3 | 384
12 | Suspended | SU | 56
13 | Transferred out of the country | TC | 1668
14 | Transferred within the LEA | TD | 28021
15 | Transferred to home schooling | TH | 2611 | Home schooled but enrolled part time at a district.
16 | Transferred to another school by choice - NCLB | TN | 36
17 | Transfer out of State | TO | 13787
18 | Transferred to a Private School | TP | 687
19 | Transferred to a Charter School | TR | 1706
20 | Transferred to another LEA within the State | TS | 33569
21 | Transferred to another Track with the School | TT | 52
22 | Early Graduate - 1st Trimester Senior Year | T1 | 32
23 | Early Graduate - 2nd Trimester Senior Year | T2 | 130
24 | Transferred Utah College of Appl. Tech (UCAT) | UC | 2
25 | Unknown | UN | 317
26 | Withdraw | WD | 211
27 | Withdrawn from Preschool | WP | 1047
28 | Early Graduate - 11th Grade | 11 | 99
29 | If EXIT DATE is left blank | Blank | 558151
Line # | High School Completion Status Codes | Code | 2009 Counts | Changes or Issues
30 | Basic HS Diploma - Passed all 3 UBSCT subtests | GR | 28952
31 | Basic HS Diploma - 3+ attempts to pass UBSCT | [NAME] | 1203
32 | Basic HS Diploma - 1 or 2 att. to pass UBSCT | G2 | 263
33 | Basic HS Diploma - assessment thru UAA | G3 | 111
34 | Basic HS Diploma - Military | GM | 0
35 | Aged Out of Special Education | AO | 98
36 | Certificate of Completion - Awarded by LEA | CT | 615
37 | Dropout | DO | 415
38 | Graduation Pending | GP | 1396 | For 2010, will count as dropout for graduation rate.
39 | Retained Senior | RT | 1348 | For SWDs, need to use if not exiting or graduating.
40 |  | Blank | 618055
Note:  2009 Counts are from USOE data warehouse student_enrollment table which was populated by the July 15, 2009 clearinghouse and updated by  October 1, 2009 exit status change records.
Spreadsheet: 33a1b759-dc73-45d0-8fe4-f78970d68896
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1
This information is required by the Indiana Department of Administration for all contractors, vendors/suppliers to the State of Indiana (complete all 22 items).
1 | [NAME] of firm:
2 | Address/City/State/Zip Code:
3 | Telephone #/Fax #/Website:
4 | Federal Tax Identification Number:
5 | State/Country of domicile/incorporation:
6 | Location of firm's headquarters or principal place of business:
7 | Name of parent company or holding company (if applicable):
8 | State/Country of domicile/incorporation of company listed in #7:
9 | Address of company listed in #7:
10 | IN Department of Workforce Development (DWD) account number:
11 | IN Department of Revenue (DOR) account number:
12 | Number of Indiana resident employees per most recently completed IRS Form W-2 distribution:
13 | Total number of employees per most recently completed IRS Form W-2 distribution:
14 | Total amount of payroll paid to Indiana resident employees per most recently completed IRS Form W-2 distribution:
15 | Total amount of payroll paid to all employees per the most recently completed IRS Form W-2 distribution:
16 | Total amount of this proposal, bid, or current contract:
 | ACCOUNTING OF INDIANA RESIDENT EMPLOYEES
17 | Prime Contractor Company Name:
18 | Number of Full Time Equivalent (FTE) employees that are Indiana residents specifically for this proposal or contract:
19 | Subcontractor Company Name:
20 | Address/Contact Person/Telephone Number/Tax ID Number:
21 | Number of Full Time Equivalent (FTE) employees that are Indiana residents specifically for this proposal or contract:
22 | Affirmation by authorized official:  I affirm under penalties of perjury that the foregoing representations are true to be the best of my knowledge and belief:
 | Signature:
 | Name of auththorized official:
 | Title:
 | Date:
Spreadsheet: 798781d1664724164-first-instance-of-number-less-than-or-equal-to-number-w-other-conditions-example-oct-2
Sheet: Sheet1

2022-09-01 00:00:00 | 1.1 |  | Number | Desired Result | Notes
2022-09-02 00:00:00 | 1.2 |  | 2.7 |  | Because all #'s still greater than 2.7
2022-09-03 00:00:00 | 1.8
2022-09-04 00:00:00 | 1.9
2022-09-05 00:00:00 | 2
2022-09-06 00:00:00 | 2.5
2022-09-07 00:00:00 | 2.7
2022-09-08 00:00:00 | 3
2022-09-09 00:00:00 | 9
2022-09-10 00:00:00 | 4
2022-09-11 00:00:00 | 9
2022-09-12 00:00:00 | 7
2022-09-13 00:00:00 | 5
2022-09-14 00:00:00 | 5
2022-09-15 00:00:00 | 5
Spreadsheet: 182841d1348632091-compare-sheet1columns-a-with-sheet2-column-a-and-output-the-difference-to-sheet3-column-a-compare-sheets-and-output-difference
Sheet: Sheet2

Check | Name | Name
 |  | [NAME], [NAME]
 |  | [NAME], [NAME]
 |  | [NAME], [NAME]
 |  | [NAME], Stoneway
Spreadsheet: gstorey__12106__April01
Sheet: Table2a

NATURAL GAS EXPORTS BY TERM, REGION, AND CUSTOMER TYPE |  |  |  |  |  |  |  |  |  |  |  | TABLE 2
EXPORTATIONS DE GAZ NATUREL PAR TERME, RÉGION, ET CLIENT
 |  |  |  | AVERAGE PRICE |  |  |  |  |  | AVERAGE PRICE
 | VOLUME |  |  | PRIX MOYEN |  |  | VOLUME |  |  | PRIX MOYEN
 | (BCF) |  |  | ($US/MMBTU) |  |  | (BCF) |  |  | ($US/MMBTU)
 |  |  | % CHANGE |  |  | % CHANGE |  |  | % CHANGE |  |  | % CHANGE
 |  |  | VARIATION |  |  | VARIATION | 1999/11 | 2000/11 | VARIATION | 1999/11 | 2000/11 | VARIATION
 | 2000-04-01 00:00:00 | 2001-04-01 00:00:00 | EN % | 2000-04-01 00:00:00 | 2001-04-01 00:00:00 | EN % | 2000-04-01 00:00:00 | 2001-04-01 00:00:00 | EN % | 2000-04-01 00:00:00 | 2001-04-01 00:00:00 | EN %
TERM/TERME
LONG-TERM (FIRM)/LONG TERME (GARANTI) | 83.3 | 63.4 | -24 | 2.84 | 4.8 | 68.8 | 488.5 | 396.3 | -18.9 | 2.64 | 5.47 | 107.4
SHORT-TERM (FIRM)/COURT TERME (GARANTI) | 111.7 | 132.5 | 18.7 | 2.78 | 5.23 | 88.3 | 787.7 | 950.7 | 20.7 | 2.48 | 6.41 | 158.2
SHORT-TERM/COURT TERME (INTERRUPTIBLE) | 74.7 | 90.4 | 21 | 2.83 | 5.53 | 95.5 | 488.6 | 628.8 | 28.7 | 2.57 | 6.93 | 169.4
TOTAL - TERM/TERME | 269.7 | 286.3 | 6.1 | 2.81 | 5.23 | 86 | 1764.9 | 1975.8 | 12 | 2.55 | 6.39 | 150.5
REGION/RÉGION
CALIFORNIA/CALIFORNIE | 48.9 | 38.9 | -20.4 | 2.69 | 6.13 | 127.9 | 354.4 | 304.6 | -14.1 | 2.4 | 7.02 | 192.8
MIDWEST/MIDWEST | 101.8 | 116.1 | 14.1 | 2.65 | 5.14 | 94.3 | 646.7 | 757.4 | 17.1 | 2.42 | 6.1 | 152.2
MOUNTAIN/ROCHEUSES | 2.4 | 1 | -56.4 | 2.7 | 3.04 | 12.6 | 17.6 | 7.4 | -57.9 | 2.35 | 4.24 | 80.6
NORTHEAST/NORD-EST | 80.1 | 79.9 | -0.2 | 3.18 | 5.12 | 61.1 | 489.2 | 607.7 | 24.2 | 2.92 | 6.19 | 111.7
PACIFIC NORTHWEST/NORD-OUEST PACIFIQUE | 36.6 | 50.3 | 37.5 | 2.64 | 4.94 | 87.3 | 257 | 298.7 | 16.2 | 2.4 | 6.93 | 188.7
TOTAL - REGION/RÉGION | 269.7 | 286.3 | 6.1 | 2.81 | 5.23 | 86 | 1764.9 | 1975.8 | 12 | 2.55 | 6.39 | 150.5
END-USER/UTILISATEURS ULTIMES
LDC/SDL | 73.1 | 53.4 | -26.9 | 2.89 | 5.18 | 79.35 | 466.8 | 410.7 | -12 | 2.61 | 6.16 | 136.2
MARKETING CO./DISTRIBUTEURS | 167 | 198.3 | 18.7 | 2.78 | 5.42 | 94.7 | 1097.1 | 1353 | 23.3 | 2.51 | 6.71 | 166.9
PIPELINE/PIPELINES | 7.2 | 10 | 38.7 | 2.22 | 4.28 | 93.17 | 60.1 | 80 | 33.1 | 2.16 | 5.03 | 132.5
TOTAL - CUSTOMER TYPE/CLIENT | 269.7 | 286.3 | 6.1 | 2.81 | 5.23 | 86 | 1764.9 | 1975.8 | 12 | 2.55 | 6.39 | 150.5
NOTE: | THE AVERAGE PRICE IS THE WEIGHTED AVERAGE |  |  |  |  |  | NOTA: | LE PRIX MOYEN EST LE PRIX MOYEN PONDÉRÉ
 | PRICE AT THE INTERNATIONAL BORDER |  |  |  |  |  |  | À LA FRONTIÈRE INTERNATIONALE
Spreadsheet: 686274d1594469075-help-with-formulas-on-historic-stock-prices-2020-07-11-oeldere-chrispelletier-686260d1594467601-help-with-formulas-on-historic-stock-pric
Sheet: Portfolio

 | Name | Symbol | Quantity | Buy Price (avg) | Price Start Year | Price Current |  | % return 2 months
 | Tesla | XNAS:TSLA | 10 | 500 | 418.33 |  |  | 0.9
 | Apple | XNAS:AAPL | 10 | 15 | 293.65
 | Box | XNYS:BOX | 10 | 20 | 16.78
 | Example for Tesla
 | Price start of year = Price as of 2019-12-31 = 418.33
 | % return 2 months
 | [NAME] for date 2 months from now (2020-07-11)=WORKDAY(TODAY(), -55)=2020-05-11
 | Today (2020-07-11) price= 1514.20, Price on 2020-05-11=811.29
 | % return 2 months = Price 2020-07-11/ price 2020-05-11 = 1544.64/811.29= 1.90
 | Substract 1 to get actual return and convert to %= 1.90 -1 = .90 = 90%
Spreadsheet: 773688d1648004819-extract-all-number-that-is-not-between-multiple-two-numbers-sample
Sheet: Sheet1

Between |  |  | Range |  |  | Need Results
11 | 20 |  | 11 |  |  | 44
21 | 30 |  | 12 |  |  | 82
51 | 60 |  | 13 |  |  | 150
61 | 70 |  | 22 |  |  | 515
91 | 100 |  | 25
 |  |  | 30
 |  |  | 44
 |  |  | 61
 |  |  | 62
 |  |  | 65
 |  |  | 82
 |  |  | 91
 |  |  | 92
 |  |  | 93
 |  |  | 150
 |  |  | 515
Spreadsheet: 777033d1650087807-concatenating-text-using-conditions-concatenate-names-using-conditions
Sheet: Sheet1

COUNTRY | PERSON |  | COUNTRY | PERSON/PEOPLE |  | COUNTRY | PERSON/PEOPLE
England | [NAME] |  |  | [NAME]/[NAME]/Ringo Starr |  | England | [NAME]/[NAME]/Ringo Starr
England | [NAME] |  |  | [NAME] |  | Wales | [NAME]
England | Ringo Starr |  |  | [NAME] |  | Scotland | [NAME]
Wales | [NAME]
Scotland | [NAME]
Scotland | [NAME]
Spreadsheet: 725324d1616619025-sum-data-by-month-and-category-210324-formula-question
Sheet: Sheet1

 | Date | Account | Description | Category | Amount
 | 2021-01-01 00:00:00 | Checking | [NAME] | Grocery | 100
 | 2021-02-15 00:00:00 | Savings | Betterment | Investment | 1500
 | 2021-03-01 00:00:00 | Credit Card 1 | Amazon | Clothing | 225
 | 2021-03-10 00:00:00 | Credit Card 2 | Amazon | Pet Food | 50
 | 2021-03-24 00:00:00 | Credit Card 1 | Saks | Clothing | 125
 |  |  | January | February | March | Total
 |  | Clothing
 |  | Grocery
 |  | Investment
 |  | Pet Food
Spreadsheet: 156566d1337347597-how-to-associate-multiple-cells-associated-with-one-cell-until-a-different-date-is-entered-051812-ex
Sheet: FORMULAS TEST SHEET

 | USEAGE | AMOUNT | IS IT   HIGH COST |  |  |  | BREAKFAST | LUNCH | DINNER |  | NON TAX MEALS pg 1
 | AGENCY VEHICLE | 0 | YES |  |  |  | 6 | 14 | 21
 | AGENCY VEHICLE (HIGH) | 0 | NO |  |  |  | 5 | 13 | 18
 | FRAUD INVESTIGATION OWN VEHICLE | 0.23
 | FRAUD INVESTIGATION OWN VEHICLE (HIGH) | 0.23 |  |  |  |  |  |  |  |  |  | NON TAX MEALS pg 2
 | NO VEHICLE AVAILABLE FRAUD INVESTIGATION (.51) | 0.51
 | NO VEHICLE AVAILABLE FRAUD INVESTIGATION (.555) | 0.555
 | NO VEHICLE AVAILABLE FRAUD INVESTIGATION (HIGH) (.51) | 0.51
 | NO VEHICLE AVAILABLE FRAUD INVESTIGATION (HIGH) (.555) | 0.555
 | RIDE ALONG | 0
 | RIDE ALONG (HIGH) | 0
 | VEHICLE NOT FEASIBLE - ASSIGNMENT (.51) | 0.51
 | VEHICLE NOT FEASIBLE - ASSIGNMENT (.555) | 0.555
 | VEHICLE NOT FEASIBLE FRAUD INVESTIGATION (.51) | 0.51
 | VEHICLE NOT FEASIBLE FRAUD INVESTIGATION (.555) | 0.555
 | VEHICLE NOT FEASIBLE FRAUD INVESTIGATION (HIGH) (.51) | 0.51
 | VEHICLE NOT FEASIBLE FRAUD INVESTIGATION (HIGH) (.555) | 0.555
 | CALC INFORMATION |  |  |  |  |  |  |  |  | ACTUAL SUM
 | PURP |  | [NAME] | VLOOKUP ENTRY | VLOOKUP # | VLOOKUP CALC | MEALS | 03' MATTER part A | PRIVATE VEHICLE USE |  |  |  | SUM 03' MATTER part B |  | Test Sheet A
1st |  |  |  |  |  |  |  |  | SUM |  | SUM PUBLIC +RENTAL FRONT TEST
2nd |  |  |  |  |  |  |  |  | SUM 03' CALC |  | SUM PUBLIC +RENTAL FRONT TEST A
3rd
4th |  |  |  |  |  |  |  |  | PER DIEM IN LIEU OF SALARY FIRST SHEET |  | SUM OF PUBLIC AND RENTAL
5th
6th
7th |  |  |  |  |  |  |  |  | LESS TRAVEL ADVANCE DISPLAYED ON TWO  FRONT SHEETS
8th
9th
10th
11th |  |  |  |  |  |  |  |  | TOTAL PRIVATE VEHICLE
12th
13th
14th
15th |  |  |  |  |  |  |  |  | TOTAL MEALS (NON TAXABLE) TWO FRONTS
16th
17th
18th
19th |  |  |  |  |  |  |  |  | TOTAL TIP AMOUNT
20th
21st
22nd
Spreadsheet: 870420d1716934060-barclays-premier-league-best-11-for-2024-toty-23-24-premier-league-alif
Sheet: Sheet7

 |  | # | Player | Club
 |  | 1 | [NAME] | Arsenal FC
 |  | 2 | [NAME] | Manchester City
 |  | 3 | [NAME] | Chelsea FC
 |  | 4 | [NAME] | [NAME]
 |  | 5 | [NAME] | [NAME]
 |  | 6 | Lucas Paquetá | West Ham United
 |  | 7 | [NAME] | Arsenal FC
 |  | 8 | [NAME] | Manchester City
 |  | 9 | [NAME] | Chelsea FC
 |  | 10 | [NAME] | West Ham United
 |  | 11 | [NAME] | Crystal Palace
 |  | 12 | [NAME] | [NAME]
 |  | 13 | Mason Mount | [NAME]
 |  | 14 | Morgan Gibbs-White | [NAME]
 |  | 15 | [NAME] | Liverpool FC
 |  | 16 | [NAME] | Fulham FC
 |  | 17 | Emile Smith Rowe | Arsenal FC
 |  | 18 | [NAME] | Arsenal FC
 |  | 19 | [NAME] | Brighton & Hove Albion
 |  | 20 | [NAME] | [NAME]
 |  | 21 | [NAME] | Fulham FC
 |  | 22 | [NAME] | [NAME]
 |  | 23 | [NAME] | Brighton & Hove Albion
 |  | 24 | [NAME] | [NAME]
 |  | 25 | Matheus França | Crystal Palace
 |  | 26 | [NAME] | Burnley FC
 |  | 27 | [NAME] | AFC Bournemouth
 |  | 28 | [NAME] | Fulham FC
 |  | 29 | [NAME] | [NAME]
 |  | 30 | [NAME] | [NAME]
 |  | 31 | [NAME] | [NAME]
 |  | 32 | [NAME] | Brighton & Hove Albion
 |  | 33 | [NAME] | [NAME]
 |  | 34 | Noha Lemina | [NAME]