tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 841829-same-name-with-different-values-and-sum-of-them-sample
Sheet: Solution 1

Date | Company | Quantity |  | Count
2023-08-05 00:00:00 | ABC LTD | 3000
2023-08-05 00:00:00 | ABC LTD | 92109
2023-08-05 00:00:00 | ABC LTD | 250000
2023-08-05 00:00:00 | ABC LTD | -56050
2023-08-05 00:00:00 | ABC LTD | -217936
2023-08-05 00:00:00 | ABC LTD | -682022
2023-08-05 00:00:00 | EFG LTD | 5000
2023-08-05 00:00:00 | EFG LTD | -3000
2023-08-05 00:00:00 | EFG LTD | 7000
2023-08-05 00:00:00 | JKL LTD | -9000
2023-08-05 00:00:00 | JKL LTD | 10000
2023-08-05 00:00:00 | JKL LTD | 5000
Spreadsheet: 112525d1308648022-ratings-based-on-numerical-value-example
Sheet: Sheet1

724 | D |  | 0 | D
978 | [NAME] |  | 768 | C
770 | C |  | 864 | B
1115 | A |  | 960 | [NAME]
806 | C |  | 1056 | A
624 | D
1025 | [NAME]
938 | B
872 | B
1232 | A
1288 | A
1268 | A
732 | D
908 | B
775 | C
631 | D
693 | D
783 | C
952 | B
723 | D
Spreadsheet: 223289d1364150493-list-example
Sheet: Sheet1

Number |  |  |  |  |  | Data1 |  | Data2 | HELPER COL |  |  |  |  | Data1 | Data2
1 |  |  |  |  |  | 0 |  | 100
 |  |  |  |  |  |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: hunter_shively__12724__Fundamentals_Netco
Sheet: Fundies-Hou

 | Fundamentals- Houston
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002 |  |  |  |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Plan |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  | Compensation | 0
 | Special Pays |  |  | 0
 | Analyst & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  | Total |  |  |  |  | 24109311.02937501
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  |  | Intern | 33000 | 1
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 48400 | 0
ENARENT | Rent |  |  |  |  |  |  | Staff | 49500 | 0
ENATECH | Technology |  |  |  |  |  |  | Specialist | 57750 | 0
ENATRANS | Transportation |  |  |  |  |  |  | Sr. Specialist | 71500 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Analyst | 60500 | 6
ENATAXES | Taxes Other than Income |  |  |  |  |  |  | Associate | 89100 | 4
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000 | 4
 |  |  |  |  |  |  |  | Director | 143000 | 1
 | Headcount |  |  |  |  |  |  | Sr. Director | 165000 | 0
 |  |  |  |  |  |  |  | VP | 198000 | 1
 | A&A Headcount |  |  |  |  |  |  | MD | 220000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2 |  |  |  |  | 1
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 676561d1588867991-help-w-advanced-formula-search-table-and-return-latest-date-it-shows-up-sample
Sheet: Sheet2

 |  | Date | examplex | example 1 | Type 1 | example 2 | Type 2 | example 3 | Type 3 | example 4 | Type 4 | example 5 | Type 5 | example 6 | Type 6 | example 7 | Type 7 | example 8 | Type 8 | example 9 | Type 9 | example 10 | Type 10
 |  | 2020-05-07 00:00:00 |  |  | a |  | b |  | c
 |  | 2020-05-01 00:00:00 |  |  | h |  | b |  | l
 |  | 2020-04-20 00:00:00 |  |  | b |  | f |  | d
 |  | 2020-04-01 00:00:00 |  |  | f |  | j |  | a
Spreadsheet: 793460d1661496958-replace-exact-characters-abbreviations
Sheet: WordList

 | abbreviations |  |  | Short need a space at the end (except when end with /)
 |  |  |  |  | all Full_Text are need a space
 | No | Rank | LEN | Short | Full_Text | Sort.Short | Sort.Full_Text
 |  |  |  | FR | Front
 |  |  |  | W/ | with |  |  |  |  | << W/ is not need a space after /.
 |  |  |  | W/O | with out
 |  |  |  | RH | right hand
Spreadsheet: 872260d1718646433-dashboard-without-pivot-tables-only-formula-and-functions-dummy_data-sakram3ntum-
Sheet: dashboard

 |  | Fiscal Month |  |  | Staff Type
 | Select the fiscal month → | 2023P08 |  |  | OS Lvl 1 Phone
 |  | Fiscal Week |  |  | [NAME]
 | Select the fiscal week → | 2023P08W3 |  |  | OS Lvl 1 Phone
 |  | Supervisors |  |  | Agent Name
 | Select the Team Manager → | [NAME] |  |  | [NAME]
 | Case Component
 | Case Details | Answered | SAT | Surveys | Pos. Survey | Neg. Survey | AHT
 | Team | Answered | SAT | Surveys | Pos. Survey | Neg. Survey | AHT
Spreadsheet: 6f69db28-e401-43b3-9470-189ce749bc99
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
TUP | Test | TUP | T3 (Triiodothyronine), Uptake, Serum | T3 (Triiodothyronine), Uptake, S | Chemiluminometric Immunoassay | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Serum gel Acceptable: Red top [NAME]: 0.5 mL | 0.3 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | Males: 27-37% Females: 20-37% | Monday through Friday, Sunday; 6 a.m.-3 p.m. | Same day/1 day | 2 days | 1 | 84479 |  |  |  |  | Rochester
TUP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
TUP | Result | TUP | T3 (Triiodothyronine), Uptake, S | T3 (Triiodothyronine), Uptake, S | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 3050-2
Spreadsheet: 2ecb0e40-4820-4375-b93a-a2f3a6642550
Sheet: Sheet1

Historic prices | Capitol Federal® Financial, Inc. | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Price | Date | High | Low | Volume
11.77 | 4/5/2012 12:00:00 AM | 11.8682 | 11.7 | 732307
11.79 | 4/4/2012 12:00:00 AM | 11.85 | 11.71 | 961604
11.87 | 4/3/2012 12:00:00 AM | 11.95 | 11.82 | 893642
11.83 | 4/2/2012 12:00:00 AM | 11.9 | 11.42 | 1512653
11.88 | 3/30/2012 12:00:00 AM | 11.92 | 11.79 | 833985
11.88 | 3/29/2012 12:00:00 AM | 11.94 | 11.72 | 610340
11.94 | 3/28/2012 12:00:00 AM | 11.98 | 11.83 | 785850
11.85 | 3/27/2012 12:00:00 AM | 11.94 | 11.78 | 672297
11.86 | 3/26/2012 12:00:00 AM | 11.93 | 11.77 | 1045634
11.86 | 3/23/2012 12:00:00 AM | 11.93 | 11.77 | 912950
11.88 | 3/22/2012 12:00:00 AM | 11.9 | 11.69 | 625357
11.88 | 3/21/2012 12:00:00 AM | 11.97 | 11.84 | 852272
11.97 | 3/20/2012 12:00:00 AM | 12.02 | 11.9 | 528440
12 | 3/19/2012 12:00:00 AM | 12.13 | 11.93 | 478575
11.99 | 3/16/2012 12:00:00 AM | 11.99 | 11.87 | 713087
11.94 | 3/15/2012 12:00:00 AM | 11.98 | 11.74 | 645878
11.89 | 3/14/2012 12:00:00 AM | 11.95 | 11.81 | 947241
11.88 | 3/13/2012 12:00:00 AM | 11.9 | 11.74 | 718888
11.75 | 3/12/2012 12:00:00 AM | 11.81 | 11.71 | 637950
11.83 | 3/9/2012 12:00:00 AM | 11.86 | 11.71 | 738493
11.72 | 3/8/2012 12:00:00 AM | 11.88 | 11.69 | 981724
11.82 | 3/7/2012 12:00:00 AM | 11.88 | 11.6 | 853303
Spreadsheet: 715167d1611591321-return-a-certain-response-to-an-if-function-between-a-number-range-com-test-chart
Sheet: Sheet1

Month | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 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
Target | 0.01 | 7800 | 7800 | 13000 | 13000 | 13000 | 13000 | 13000 | 11666 | 11666 | 11666 | 11666 | 11666 | 11666 | 11666 | 11666 | 11666 | 11666 | 11666 | 11666
Achieved | 624 | 6212.959999999999 | -5512 | 5546.32 | 9550.32 | 25224.68 | 37428.04 | 27347.32 | 3692
Running %
Commission Level
Required to reach 15%
Required to reach 20%
Spreadsheet: 51932116-45da-457b-a0e9-3ab98e5e534e
Sheet: COMMUNICATIONS & WSHOPS

 | Project Title: | [NAME] | New Coalitions for Biodiversity - Developing public-private partnerships within protected areas in five countries of the South East Europe - Budget
 | Project Activities: | COMMUNICATIONS & WORK-SHOPS
 |  | YEAR 1 - 2011 |  |  | YEAR 2 - 2012 |  |  | YEAR 3 -2013 |  |  |  | TOTAL  3 YEARS
 | Category | Donor | WWF MEDPO | Total | Donor | WWF MEDPO | Total | Donor | WWF MEDPO | Total |  | Donor | WWF MEDPO | Total
1 | Project Staff
1.1
1.2
1.5
1.4
1.7
1.3
1.6
 | Total 1
2 | Studies, publications and workshops
2.1 | Training on public-private partnership development for PA managers | 18000 |  |  | 18000
2.2 | Capacity building on BP and N. 2000  (€ 2000 per PA)
2.3 | Promotion of PAs values, communications work to attract business, promotional materials for development of pub-priv partnerships (2,5) | 30000 |  |  | 30000 |  |  | 20000 |  |  |  |  |  |  |  | 12000
2.4 | Production of “how-to” guide for establishing public private partnerships based on the project experiences (off line or online tool) (At. 2,8) |  |  |  |  |  |  | 7000 |  |  |  |  |  |  |  | -10000
2.5 | One Planet Leader - Training on corporate & private sector relationships development (2 people training) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -10000
 | Total 2
3 | Travel
3.1
3.2
3.3
3.4
 | Total 3
4 | Local Office Running Costs
4.1
4.2
4.3
4.4
4.5
 | Total 4
5 | Management Fees - 8,5%
 | Total
 |  | Donor | WWF MedPO | Total
 | Year 1
 | Year 2
 | Year 3
 | Total 3 years
 | Total Direct Cost for MedPO ORC and Admin
Spreadsheet: 879239d1726682240-merging-both-match-and-look-up-with-quartile-book-1-upload
Sheet: Sheet2

Row Labels | Count of concat | 1st quartile | rounded up
87635QW | 10
87807QW | 1
87811QW | 1
87880QW | 1
9464000 | 13 |  |  |  |  | this was my test
9464059 | 1 |  |  |  |  | should look up 4th row that matches 9464000 on charges spread sheet
9466000 | 1
Grand Total | 28
Spreadsheet: 732432d1620942636-how-to-make-text-to-columns-automatic-stock-short-term-comparison-3
Sheet: text

13c/17c/22c/24c/28c/35c/37c/40c/42c/48c/51c |  |  |  |  |  |  |  |  |  |  |  |  | end 13c/19c/21c/26c/29c/36c/39c/42c/44c/51c/53c
13 | 17 | 22 | 24 | 28 | 35 | 37 | 40 | 42 | 48 |  |  |  | 13 | 19 | 21 | 26 | 29 | 36 | 39 | 42 | 44 | 51
 |  |  |  |  |  |  |  |  |  | bot
 |  |  |  |  |  |  |  |  |  | top
 |  |  |  |  |  |  |  |  |  | top
 |  |  |  |  |  |  |  |  |  | bot
 |  |  |  |  |  |  |  |  |  | 21r(45wa)(d4e)>>-106d(>)
 |  |  |  |  |  |  |  |  |  | 11r(16wa)>?s?-172d(inc)(>s)
 |  |  |  |  |  |  |  |  |  | 073d(dec)<vvs-072d(-114d)(dec)(<s)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07 11 08 17
 |  |  |  |  |  |  |  |  |  | -087d(-17wa) |  |  | i(dp>I, d=[NAME] -1.0)(=<s(or >)=)
 |  |  |  |  |  |  |  |  |  |  | 3.62d, 2.0r 1.54d(dec), 1.82d, 2.2r, 5.614d(inc), 3.7r, 1.9wa?(dec?), 3.8wa, 2.9r, 1.9r(dec2), 5.710d, 2.66d, 2.92d, 2.4r, 1.5r(long dec3), 1.7wa, 222d, 302d, 21r, 45wa(long inc)
 |  |  |  |  |  |  |  |  |  |  | -1.95d, -3.22d, -3.6r(inc2), -2.7wa?, -2.43d, -1.512d(dec), -2013d, -183d, -23r, -377d?(inc), [NAME], -172d(dec)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 np (quasi)
 |  |  |  |  |  |  |  |  | 2912.39 |  |  |  |  |  |  |  | 4c (or vs)
Spreadsheet: 130179d1322113439-how-to-use-if-formula-for-change-price-december
Sheet: 24

 |  |  |  | 2011-12-24 00:00:00
Newspaper | Price | Quantity | Total
Value | 1.1 |  | 0
Value1 | 0.98 |  | 0
Value2 | 1.63 |  | 0
Value3 | 1.63 |  | 0
Value4 | 0.83 |  | 0
Value5 | 1.01 |  | 0
Value6 | 1.03 |  | 0
Value7 | 1.01 |  | 0
Value8 | 0.8 |  | 0
Value9 | 1.2 |  | 0
Value10 | 1.2 |  | 0
Value11 | 1.2 |  | 0
Total |  |  | 0
 | Grand Total |  | 0
Spreadsheet: 2628b62c-8169-4b70-88b6-212da50ca875
Sheet: Cover

PROCUREMENT & SOURCING SERVICES
Application for Payment for Construction Services
To: | Long Island University |  |  | CAMPUS: |  |  |  | APPLICATION NO.:
 | 700 Northern Blvd. |  |  | BUILDING:
 | Brookville, NY 11548 |  |  | PROJECT: |  |  | PERIOD TO:
From: |  |  |  | LIU PROJECT # |  |  |  | CONTRACT DATE:
 |  |  |  |  |  |  | The undersigned Contractor certifies that the Work covered by this Application for Payment has been completed in accordance with the Contract Documents, that all amounts due workers or suppliers paid by LIU under previous Certificates for Payment have been paid, and that the current payment shown herein is now due.
ORIGINAL CONTRACT SUM
NET CHANGE BY CHANGE ORDERS
CONTRACT SUM TO DATE
TOTAL COMPLETED & STORED TO DATE
RETAINAGE
TOTAL EARNED LESS RETAINAGE
LESS PREVIOUS CERTIFICATES FOR PAYMENTS |  |  |  |  |  | Signed:
CURRENT PAYMENT DUE |  |  |  |  |  | Date:
BALANCE TO FINISH PLUS RETAINAGE |  |  |  |  |  |  | Based on on-site observations and Contract Document requirements, Architect certifies to University that to the best of the Architect's knowledge, information and belief the Work has progressed as indicated, the quality of the Work is in accordance with the Contract Documents and the Contractor is entitled to payment of the requested CURRENT PAYMENT DUE
CHANGE ORDER SUMMARY
Total Approved in Previous Months
Total Approved this Month
Total Change Orders to Date
LIU APPROVALS
Project Manager |  |  |  | Date |  | Signed:
Facilities Director |  |  |  | Date
CFS or Controller's Office |  |  |  | Date |  | Date
 |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: darrell_schoolcraft__7301__Southpoint Gas Model
Sheet: Sheet1

Southpoint |  |  | Transwestern's 24 hr Gas Control [PHONE]
 |  |  | 2002-01-08 00:00:00
 |  |  | SoCal Gas Price |  | 2.13
 |  |  | San Juan Gas Price |  | 1.98
 |  |  | Unit 1 | Unit 2 | Steam TurB | Total MW | HR | Total Gas Usage
California Gas Day
he 6 | 07:00:00 |  | 0 | 0 | 0 | 485 | 7
he 7 | 08:00:00 |  | 0 | 0 | 0 | 540 | 7
he8 | 09:00:00 |  | 0 | 0 | 0 | 540 | 7
he9 | 10:00:00 |  | 0 | 0 | 0 | 540 | 7
he10 | 11:00:00 |  | 0 | 0 | 0 | 540 | 7
he11 | 12:00:00 |  | 0 | 0 | 0 | 540 | 7
he12 | 13:00:00 |  | 0 | 0 | 0 | 540 | 7
[NAME] | 14:00:00 |  | 0 | 0 | 0 | 540 | 7
he14 | 15:00:00 |  | 0 | 0 | 0 | 540 | 7
he15 | 16:00:00 |  | 0 | 0 | 0 | 540 | 7
he16 | 17:00:00 |  | 0 | 0 | 0 | 540 | 7
he17 | 18:00:00 |  | 0 | 0 | 0 | 540 | 7
he18 | 19:00:00 |  | 0 | 0 | 0 | 540 | 7
he19 | 20:00:00 |  | 0 | 0 | 0 | 540 | 7
he20 | 21:00:00 |  | 0 | 0 | 0 | 540 | 7
he21 | 22:00:00 |  | 0 | 0 | 0 | 540 | 7
he22 | 23:00:00 |  | 0 | 0 | 0 | 540 | 7
he23 | 12:00:00 |  | 0 | 0 | 0 | 510 | 7
he24 | 01:00:00 |  | 0 | 0 | 0 | 510 | 7
he1 | 02:00:00 |  | 0 | 0 | 0 | 510 | 7
he2 | 03:00:00 |  | 0 | 0 | 0 | 510 | 7
he3 | 04:00:00 |  | 0 | 0 | 0 | 510 | 7
he4 | 05:00:00 |  | 0 | 0 | 0 | 510 | 7
[NAME] | 06:00:00 |  | 0 | 0 | 0 | 510 | 7
Spreadsheet: 27e1dbf7-f1c1-411a-b889-7c91ea7ccb53
Sheet: 10c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60+ | TOTAL
Cross-Currency Basis | 832179 | 636151 | 970227 | 1639096 | 2485163 | 2410070 | 8972886
Cross-Currency Fixed-Fixed | 68358 | 10528 | 32689 | 34627 | 101493 | 162296 | 409991
Cross-Currency Fixed-Float | 156062 | 121553 | 173413 | 238730 | 367617 | 1616655 | 2674030
TOTAL | 1056599 | 768232 | 1176329 | 1912453 | 2954273 | 4189021 | 12056907
Spreadsheet: 59864d1260389993-drop-down-list-values-dependant-on-value-of-another-drop-down-list-dummy-worksheet1
Sheet: Sheet1

Status | Cancellation/ NTU Reason |  | NTU Drop |  | LAPSE
Lapse
Lapse
Lapse
Lapse
Lapse
Lapse
Lapse
Lapse
Lapse
Lapse
Lapse
Lapse
Status | Cancellation/ NTU Reason
Lapse | Global Policy
NTU | policy wording not as concise
NTU | policy wording not as concise
NTU | policy wording not as concise
NTU | policy wording not as concise
Lapse
Lapse
Lapse
Lapse
Lapse
Lapse
Lapse
Spreadsheet: 214856d1361157492-nested-if-function-bsbitu402a-part-b-task-1-1-
Sheet: John Bourke

Bobs Building Services
Weekly Time Sheet
Employee Name:
Payroll period commencing: |  |  | 2013-01-28 00:00:00
Payroll period ending:
Day | Date | Start Time: | Lunch Break: | Finish Time: | Total Hours | Ordinary  Hours | Overtime | T 1/2 | DT
Monday |  | 07:30:00 | 00:30:00 | 16:00:00
Tuesday |  | 07:30:00 | 00:30:00 | 18:00:00
Wednesday |  | 09:30:00 | 00:30:00 | 15:00:00
Thursday |  | 07:30:00 | 00:30:00 | 16:00:00
Friday |  | 07:30:00 | 00:30:00 | 16:00:00
Saturday |  | 08:00:00 | 00:00:00 | 11:00:00
Total
Spreadsheet: 762963d1641918865-sum-of-values-across-multiple-sheets-sum-of-vls-mltpl-sheets
Sheet: DEC

2022-11-28 00:00:00 |  |  | 2500
2022-04-01 00:00:00 |  |  | 1250
2022-11-28 00:00:00 |  |  | 750
2022-11-29 00:00:00 |  |  | 54.01600000000001
2022-12-01 00:00:00 |  |  | 3500
2022-12-01 00:00:00 |  |  | 932.45
2022-12-01 00:00:00 |  |  | 1284
2022-12-01 00:00:00 |  |  | 750
2022-12-01 00:00:00 |  |  | 20
2022-12-01 00:00:00 |  |  | 350
2022-12-01 00:00:00 |  |  | 550
2022-12-02 00:00:00 |  |  | 4.037696
2022-12-04 00:00:00 |  |  | 150
2022-12-04 00:00:00 |  |  | 11
2022-12-05 00:00:00 |  |  | 750
2022-12-06 00:00:00 |  |  | 2278.62
2022-12-06 00:00:00 |  |  | 2323
2022-12-08 00:00:00 |  |  | 80
2022-12-08 00:00:00 |  |  | 80
2022-12-10 00:00:00 |  |  | 7
2022-12-12 00:00:00 |  |  | 750
2022-12-13 00:00:00 |  |  | 16.98
2022-12-15 00:00:00 |  |  | 16
2022-12-16 00:00:00 |  |  | 300
2022-12-18 00:00:00 |  |  | 155.85
2022-12-19 00:00:00 |  |  | 750
2022-12-26 00:00:00 |  |  | 750
Spreadsheet: 852234d1702322057-calculating-the-number-of-ot-hours-between-two-times-from-times-that-cross-midnight-time-sheet-calculator
Sheet: OT Codes - Codes TS

OVERTIME CODES  CODES TEMPS SUPPLÉMENTAIRE | [NAME]
NOT ON TRAVEL STATUS / SANS STATUT DE VOYAGE
260R | Overtime before or after regular working hours when the employee is not on travel status and not entitled to meals (i.e. meal provided during an event) / Temps supplémentaire lorsque l'employé n'est pas en statu de voyage mais non éligible à la prime de repas (repas fournis lors d'un évènement)
260 | Overtime before or after regular working hours when the employee is not on travel status and entitled to meals / Temps supplémentaire avant ou après les heures de travail régulières lorsque l'employé n'est pas en statu de voyage et éligible à la prime de repas
ON TRAVEL STATUS / EN STATUT DE VOYAGE
260R | Overtime before or after regular working hours when the employee is on travel status and not entitled to meals (i.e. receives meal allowance as per NJC Travel directive) / Temps supplémentaire lorsque l'employé est en statu de voyage et non éligible à la prime de repas (allocations de repas reçu selon la directive de voyage du CNM)
89 | Hours of travel outside regular working hours during the week / Heures de déplacement journée ouvrable
72 | Hours of travel on a weekend or statutory holiday / Heures de déplacement fin de semaine ou férié
Drop down list | Description
260R | OT no meals - TS sans repas
260 | OT with meals - TS avec repas
89 | OT Travel reg hours - TS voyage hr rég.
72 | OT Travel W-E - TS voyage fds
Spreadsheet: 158706d1338360866-need-help-with-calculations-derived-from-pivot-data-book2_solution
Sheet: Sheet2

 | Phase of the Project | Values
 | 2. Initiate |  |  | 4. Execute |  |  | Total Max of For Period Ending | Total Min of For Period Starting | Total Sum of Field1
Project ID | Max of For Period Ending | Min of For Period Starting | Sum of Field1 | Max of For Period Ending | Min of For Period Starting | Sum of Field1
ES10159 |  |  | 0 | 2012-05-03 00:00:00 | 2012-01-26 00:00:00 | 93 | 2012-05-03 00:00:00 | 2012-01-26 00:00:00 | 93
ES12037 | 2012-05-03 00:00:00 | 2012-01-26 00:00:00 | 101 |  |  | 0 | 2012-05-03 00:00:00 | 2012-01-26 00:00:00 | 101
Grand Total | 2012-05-03 00:00:00 | 2012-01-26 00:00:00 | 101 | 2012-05-03 00:00:00 | 2012-01-26 00:00:00 | 93 | 2012-05-03 00:00:00 | 2012-01-26 00:00:00 | 194
Spreadsheet: 21759e4b-164c-466c-9ab2-1ad04ed09bb0
Sheet: Sheet1

Instructions: 1. Save this file into new circular directory. Do "save as" s:\shared\circular\0007. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
2. Update cells [NAME], D7, & E7  w/new months (ie change  Feb to March & March to April).
3.  Update prices.
4. On final sheet, replace "ERR" with "n/a"
NASS Agricultural Prices
 | Domestic | 2001 | 2002 |  | % Change | % Change
Commodity | units | July | June | [NAME] | Last Month | Last Year
 |  | Dollars/unit
Grapefruit   2/ | Box | 5.01 | 4.16 | 6.36 | 0.5288461538461539 | 0.2694610778443115
Lemons   2/ | Box | 16.14 | 9.52 | 14.3 | 0.5021008403361346 | -0.114002478314746
Limes   2/ | Box | 0 | 0 | 0
Oranges   2/ | Box | 4.33 | 4.13 | 3.9 | -0.05569007263922518 | -0.09930715935334876
Tangelos   2/ | Box | 0 | 0 | 0
Tangerines   2/ | Box | 0 | 0 | 0
Temples   2/ | Box | 0 | 0 | 0
Apples, fresh  3/ | [NAME]. | 0.152 | 0.22 | 0.206 | -0.0636363636363637 | 0.3552631578947368
Grapes | Ton | 630 | 920 | 1000 | 0.08695652173913043 | 0.5873015873015873
Peaches | [NAME]. | 0.288 | 0.275 | 0.205 | -0.2545454545454546 | -0.2881944444444444
Pears, fresh  3/ | Ton | 405 | 337 | 312 | -0.07418397626112759 | -0.2296296296296296
Strawberries, fresh | [NAME]. | 0.689 | 0.573 | 0.45 | -0.2146596858638743 | -0.3468795355587808
Asparagus  4/ | [NAME]. | 109 | 98 | 136 | 0.3877551020408163 | 0.2477064220183486
Broccoli   4/ | [NAME]. | 23.6 | 28.4 | 25.2 | -0.1126760563380281 | 0.06779661016949143
Cantaloupes | [NAME]. | 19 | 14 | 14.4 | 0.0285714285714286 | -0.2421052631578947
Carrots   4/ | [NAME]. | 22 | 21.5 | 21.2 | -0.01395348837209306 | -0.0363636363636364
Cauliflower   4/ | [NAME]. | 25.6 | 32.7 | 32.9 | 0.006116207951070205 | 0.2851562499999999
Celery   4/ | [NAME]. | 13.5 | 9.37 | 10.1 | 0.07790821771611531 | -0.2518518518518519
[NAME]4/ | [NAME]. | 19.8 | 17 | 21.6 | 0.2705882352941177 | 0.09090909090909094
Cucumbers   4/ | [NAME]. | 18.7 | 17.7 | 20.6 | 0.1638418079096046 | 0.1016042780748664
Lettuce   4/ | [NAME]. | 16.4 | 10.5 | 12.3 | 0.1714285714285715 | -0.2499999999999999
Onions   4/ | [NAME]. | 15.5 | 20.7 | 19.4 | -0.0628019323671498 | 0.2516129032258064
Snap Beans  4/ | [NAME]. | 59.4 | 47.1 | 46.4 | -0.01486199575371556 | -0.2188552188552189
Tomatoes   4/ | [NAME]. | 27.4 | 28.4 | 29.8 | 0.0492957746478874 | 0.0875912408759125
1/  Preliminary
2/  Equivalent on-tree returns.
3/  Equivalent packinghouse-door returns for CA and NY (apples only), OR (pears only), and
WA (apples,  peaches, and pears).  Prices as sold for other states.
4/  Fresh-market, FOB shipping point.
Note: Zeroes indicate insufficient information or insufficient sales to establish a price.
Source:  National Agricultural Statistics Service (NASS), USDA.
Spreadsheet: 693999d1599269832-zone-weight-base-rate-calculation-excel-formula-file1
Sheet: Daily Data

CHARGBLE WEIGHT | ZONE | BASE RATE
8.3 | 4
20 | 5
1 | 5
20 | 5
30 | 5
0.1 | 5
49 | 5
0.5 | 4
1.5 | 4
22 | 5
7 | 5
0.5 | 5
21 | 4
21 | 4
23 | 4
12.5 | 4
0.5 | 7
1 | 5
44 | 4
16 | 4
32.5 | 4
23 | 4
3 | 5
12 | 4
6.5 | 4
5 | 5
2.5 | 4
1 | 5
8 | 6
22 | 4
9 | 4
1.5 | 6
21.5 | 5
22 | 5
0.1 | 4
25 | 5
11.5 | 5
1.5 | 4
1 | 4
21 | 4
12 | 4
9 | 5
2 | 6
7 | 4
30 | 5
30 | 6
15 | 5
7.5 | 5
1 | 5