tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 783588d1654940399-tiered-pricing-waterrates
Sheet: Sheet1

1-10 m3 : 10 x 1,500 = 15,000 |  | Volume Tiers | Rates | Marginal Rates | Usage | Cost
11-15 : 5 x 1.850 = 9.250 |  | 0 | 1500 | 1500 | 100
16-20 : 5 x 2,400 = 12,000 |  | 10 | 1850
> 20 : 80 x 3,000 = 240,000 |  | 15 | 2400
 |  | 20 | 3000
See ….
http://www.mcgimpsey.com/excel/variablerate.html
 |  | Tiers | [NAME] 1 | [NAME] | [NAME] 3 | [NAME] 4 | [NAME] 5
 |  | Volume Tiers | Marginal Rates | Marginal Rates | Marginal Rates | Marginal Rates | Marginal Rates
 |  | 0 | 1500 | 1600 | 1700 | 1800 | 1900
 |  | 10 | 350 | 450 | 450 | 450 | 450
 |  | 15 | 550 | 600 | 600 | 600 | 600
 |  | 20 | 600 | 600 | 600 | 600 | 600
Spreadsheet: 820256d1677956944-sort-mixed-data-from-1-sheet-to-other-tabs-bol-a
Sheet: Jan

helper | Name | date | del/pic | AM/PM | BOL | on/off
 | atwell | 1 | 2023-01-12 00:00:00 | del | am | 40
[NAME] | begli | 00:00:00 | 2023-01-13 00:00:00 | del | am | 41
ell44941 | atwell | 00:00:00 | 2023-01-15 00:00:00 | pic | pm | 42
[NAME] | maggie | 00:00:00 | 2023-01-15 00:00:00 | del | pm | 43
gan44942 | meggan | 00:00:00 | 2023-01-16 00:00:00 | del | pm | 44
ald44943 | [NAME] | 00:00:00 | 2023-01-17 00:00:00 | del | am | 45
gan44944 | meggan | 00:00:00 | 2023-01-18 00:00:00 | del | pm | 46
gli44946 | begli | 00:00:00 | 2023-01-20 00:00:00 | pic | am | 47
ood44955 | atwood | 00:00:00 | 44955 | del | am | 48
Spreadsheet: 2a658341-4090-4feb-a8d0-be8af76c6c3c
Sheet: Sheet1

For all Cub Scout Packs, Boy Scout Troops, Varsity Teams, and [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Annual Charter Renewal | Fee | Quantity | Total
Youth Membership | 24
Adult Membership | 24
Tiger Cub Adult Partners | 0 |  | 0
Boys' Life  (both youth and adults) | 12
Accident and Sickness Insurance:   Primary Youth and Adult Members (including [NAME]) | 1
Unit Liability Insurance Fee | 40 | 1 | 40
Grand Total |  |  | 40
For Explorer Posts Only
March Charters | Fee | Quantity | Total
Youth Membership | 24
Adult Membership | 24
Accident and Sickness Insurance:   Primary Youth and Adult Members | 1
Unit Liability Insurance Fee | 40 | 1 | 40
Grand Total |  |  | 40
Make checks payable to Crossroads of America Council.  Be sure that your District name, unit information and  "recharter" appears on the check.
Spreadsheet: 779331d1651702281-if-then-formula-help-22-01a-forney-hs-paving-audit
Sheet: PROCORE SETUP

PO # | CSP # | SCOPE | CONTRACTOR | BASE | ALLOWANCE | ALT#1 - Replace Existing Light Poles & Fixtures | ADJUSTMENTS | TOTAL PROJECT | BUDGET ALLOCATIONS
CONSTRUCTION COSTS TOTAL
 | 1-26-A | Electrical | Intex Electrical Contractors, Inc. |  |  | 28985
 | 1-31-A | Excavation | The Holbrook Company, Inc.
 | 1-32-A | Concrete Paving | JDS Contractors LLC |  | 50000
 | 1-3215 | Pole Bases for Alt. 1 | Estimate - BA to [NAME], if required |  |  | 3000
 | 1-32-B | Landscape and Irrigation | Texas Yard Pro, INC. |  | 5000
 | 1-33-A | Site Utilities | J&K Moore Enterprises LLC
 | 1-1111 | Survey and Layout | Estimate
 | 1-1155 | Temporary Construction Fence | Estimate
 | 1-1150 | Temporary Toilets | Estimate
 | 1-1110 | Subsurface Investigation - Utility Locate | Estimate
 | 1-31531 | Clean Up Equipment | Estimate
 | 1-31331 | Grading Equipment | Estimate
 | 1-31231 | General Cleanup | Estimate
 | 1-1161 | SWPPP Book/Silt Fence/Repairs | Estimate
 | 1-1253 | Mailing/Shipping Provisions | Estimate
 | 1-1700 | Closeout Document Scanning | Estimate
 | 1-1040 | Builder's Risk Insurance | Estimate
 | 1-1335 | Contruction Contingency | Estimate
 | 1-411 | Construction Manager's Fee | Gallagher |  |  | 3217
CONSTRUCTION COSTS TOTAL
FEES AND OWNER'S DIRECT EXPENSES
 | 2-511 | Civil Engineer | Estimate |  |  | 2640
 | 2-509 | Geotechnical Reports | Estimate
 | 2-1420 | Material Testing and Inspection | Estimate
 | 2-1254 | Printing | Estimate
 | 2-1140 | Construction Waste Removal Services | Estimate
 | 2-574 | Building Permit/Plan Review/Inspections | Estimate
 | 2-517 | TAS Reviews and Inspections | Estimate
FEES AND OWNER'S DIRECT EXPENSES TOTAL
FURNITURE ,FIXTURES, & EQUIPMENT (FF&E)
 | 3-12500 | Furniture, Fixtures, and Equipment
FURNITURE ,FIXTURES, & EQUIPMENT (FF&E) TOTAL
[NAME]
 | 4-1121 | Owner Contingency | Estimate
[NAME] CONTINGENCIES TOTAL
TOTAL COST
 |  |  |  |  |  |  |  | 943094
Spreadsheet: 715458d1611716603-sum-n-count-of-values-in-rows-sum-first-5-numbers
Sheet: Sheet1

Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 | Column 7 | Column 8 | Column 9 | Column 10 | Column 11 | Column 12 | Column 13 | Column 14 | Column 15 | Column 16 | Column 17 | Column 18 | Column 19 | Column 20 | [NAME] in this column to sum first 5 values in each row.
1 |  | 2 |  | 5 |  | 8 | 8 | 7 | 8 |  | 5 |  |  | 6 |  | 5 |  | 8 | 1
5 | 2 |  | 4 |  | 7 | 8 |  | 2 | 2 | 2 |  |  | 8 |  | 3 | 1 | 1 |  | 7
 |  | 8 |  |  |  | 2 | 8 |  | 3 |  | 3 |  | 7 |  |  | 9 |  | 4
5 |  |  | 8 | 7 | 8 |  | 5 | 5 |  |  | 8 | 7 | 8 |  | 5
 | 7 | 8 |  | 2 | 2 | 2 |  |  | 7 |  |  | 2 | 2 | 2 |  |  | 5 | 5
 |  | 2 | 8 |  | 3 |  | 3 |  |  | 2 | 8 |  | 3 |  | 3 | 2 |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 8 | 7 | 8 |  | 5
 |  |  |  |  | 7 | 8 |  | 2 | 2 | 2 |  |  | 8
 |  |  |  |  |  | 2 | 8 |  |  |  | 3 |  | 2 | 2 | 8 |  | 5 | 5
 |  |  |  |  | 5 |  | 8 | 8 |  | 8 |  | 5 | 3 |  | 2 | 2 |  |  | 7
 |  |  |  |  | 5 |  |  | 8 | 7 | 8 |  | 5 |  |  | 3 |  | 3
 |  |  |  |  |  | 7 | 8 |  | 2 | 2 | 2 |  | 8
 |  |  |  |  |  |  | 2 | 8 |  | 3 |  | 3 | 2 | 2 | 8 |  | 5 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  | 2 | 2 |  |  | 7
5 |  | 8 | 8 | 7 |  |  |  |  |  |  |  |  |  |  | 3 |  | 3
 | 7 |  |  | 2
Spreadsheet: 868286d1715012923-first-post-ai-cant-seem-to-help-me-sample-sheet
Sheet: Alabama

Store | concat1 | concat2 | concat2 | Zip | County | County Rate | City | City Rate-Change Guntersville City to 5% on  7.1.19 | Gross Sales | Exempt Sales | Grocery Sales @ reduced rate | Taxable at 4% state rate | Gross STATE Sales Tax Due | SEPARATE RETURN Taxable Purchases Subj. to Use Tax | SEPARATE RETURN Use Tax | Prepaid Wireless Cards | Prepaid Wireless Fee ($1.86) | Prepaid Wireless Fee Discount | Net Prepaid Wireless Fee | GROSS County Sales Tax | County Use Tax | GROSS City Sales Tax | City Use Tax | All Sales Taxes (excl PPD Wireless) | (INFORMATIONAL ONLY) Accrued Tax from GP
1107 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.22
3649
3652
5101
Cell Z in this sheet (in any given row) should equal:
if value in column A in current sheet and current row is equal to value in any row in column G in sheet named sales tax liabilities orig, then add sum of values in column L in sheet named sales tax liabilities orig.
+
Additionally, if column I in  sales tax liabilities orig equals lgarrigos2, then also add values in column K of those rows to the sum in previous statement.
=
Z in same row
Note: Expected result is currently entered in Z2 ONLY
Spreadsheet: 70961d1271713266-shift-schedule-template-color-fill-problem-weekly-shift-schedule-with-auto-fill-ws2
Sheet: Weekly Schedule

 | Weekly Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | For the Week of: | 2010-04-17 00:00:00
 | v1.0
 |  |  |  | Job | Cashier | Stocker | Manager | Driver | General
 |  |  |  | ID | 1 | 2 | 3 | 4 | 5
 |  |  | Monday |  |  | Tuesday |  |  | Wednesday |  |  | Thursday |  |  | Friday |  |  | Saturday |  |  | Sunday
 |  | Job |  |  | Job |  |  | Job |  |  | Job |  |  | Job |  |  | Job |  |  | Job
1 | Name
2 | Name
3 | Name
4 | Name
5 | Name
6 | Name
7 | Name
8 | Name
9 | Name
10 | Name
11 | Name
12 | Name
13 | Name
14 | Name
15 | Name
16 | Name
17 | Name
18 | Name
19 | Name
20 | Name
Spreadsheet: 342836d1409696050-event-calendar-with-recurring-event-140902_-calendar-of-events-2014-_-test
Sheet: Event Calendar - SEPT

 |  |  |  | EVENT CALENDAR
 |  |  |  |  |  | ENTER MONTH: | September
 |  |  |  |  |  | ENTER YEAR: | 2014
 |  |  |  |  |  | ENTER START DAY: | Sunday
 | TO EVENT LIST >>
Spreadsheet: 298513d1392825165-system-specs-for-heavy-processing-cleanup-process
Sheet: session_duration_custom_5

Session Duration
Session Duration for   department "All\XenDesktop Farms\FWDCPDDC01\Desktop Groups\CODV\HealthONE Desktop", between 1/1/2013 and 1/1/2013, grouped by  "User", "Date"
Date |  |  |  |  |  |  | [NAME] | Total Session Duration
2013-01-01 00:00:00 |  |  |  |  |  |  | 129 | 5 Days, 1:26:40
 |  | User |  |  |  |  | [NAME] | Total Session Duration
 |  | IZL8941 |  |  |  |  | 4 | 4:04:42
 |  |  | Device | Session Started | Session Ended | Client Address | Client Name | Session Duration
 |  |  | CODVPUC01064 | 2013-01-01 09:07:35 | 2013-01-01 09:58:36 | 192.168.1.131 | AAAAAA | 0:51:01
 |  |  | CODVPUC01145 | 2013-01-01 10:19:31 | 2013-01-01 11:07:56 | 192.168.1.131 | AAAAAA | 0:48:25
 |  |  | CODVPUC01111 | 2013-01-01 12:12:25 | 2013-01-01 14:08:36 | 192.168.1.131 | AAAAAA | 1:56:11
 |  |  | CODVPUC01097 | 2013-01-01 16:28:54 | 2013-01-01 16:57:59 | 192.168.1.131 | AAAAAA | 0:29:05
 |  | QXA8700 |  |  |  |  | 1 | 4:03:53
 |  |  | Device | Session Started | Session Ended | Client Address | Client Name | Session Duration
 |  |  | CODVPUC01102 | 2013-01-01 09:38:28 | 2013-01-01 13:42:21 | 192.168.2.2 | AAAAAA | 4:03:53
 |  | DZF7342 |  |  |  |  | 3 | 3:37:30
 |  |  | Device | Session Started | Session Ended | Client Address | Client Name | Session Duration
 |  |  | CODVPUC01065 | 2013-01-01 10:36:42 | 2013-01-01 12:07:29 | 192.168.1.3 | AAAAAA | 1:30:47
 |  |  | CODVPUC01056 | 2013-01-01 12:27:10 | 2013-01-01 13:30:22 | 192.168.1.3 | AAAAAA | 1:03:12
 |  |  | CODVPUC01139 | 2013-01-01 22:50:05 | 2013-01-01 23:53:36 | 192.168.1.3 | AAAAAA | 1:03:31
 |  | MVA9800 |  |  |  |  | 2 | 3:22:29
 |  |  | Device | Session Started | Session Ended | Client Address | Client Name | Session Duration
 |  |  | CODVPUC01052 | 2013-01-01 08:43:34 | 2013-01-01 11:01:19 | 192.168.0.3 | AAAAAA | 2:17:45
 |  |  | CODVPUC01145 | 2013-01-01 15:03:28 | 2013-01-01 16:08:12 | 192.168.0.3 | AAAAAA | 1:04:44
 |  | DEY9939 |  |  |  |  | 2 | 3:13:45
 |  |  | Device | Session Started | Session Ended | Client Address | Client Name | Session Duration
 |  |  | CODVPUC01034 | 2013-01-01 15:28:35 | 2013-01-01 16:38:42 | 10.0.1.10 | AAAAAA | 1:10:07
 |  |  | CODVPUC01081 | 2013-01-01 21:13:07 | 2013-01-01 23:16:45 | 192.168.1.3 | AAAAAA | 2:03:38
 |  | EVH9051 |  |  |  |  | 1 | 2:58:17
 |  |  | Device | Session Started | Session Ended | Client Address | Client Name | Session Duration
 |  |  | CODVPUC01122 | 2013-01-01 16:22:03 | 2013-01-01 19:20:20 | 192.168.1.4 | AAAAAA | 2:58:17
 |  | FTI8914 |  |  |  |  | 1 | 2:57:40
 |  |  | Device | Session Started | Session Ended | Client Address | Client Name | Session Duration
 |  |  | CODVPUC01146 | 2013-01-01 10:53:30 | 2013-01-01 13:51:10 | 192.168.1.101 | AAAAAA | 2:57:40
 |  |  | Device | Session Started | Session Ended | Client Address | Client Name | Session Duration
 |  |  | CODVPUC01082 | 2013-01-02 02:34:25 |  | 10.153.174.78 | AAAAAA
Spreadsheet: kim_ward__20942__Mar-01 Invoice
Sheet: March 01

 | ENRON NORTH AMERICA CORP. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PAGE 1 OF 1
 | INVOICE INFORMATION |  |  |  | CONTRACT INFORMATION |  |  |  | CUSTOMER INFORMATION |  |  |  |  | PAYMENT INFORMATION
 | INVOICE NUMBER: |  | U-0301-26176SA |  | CONTRACT NUMBER: |  |  |  | City of Pasadena Water and Power |  |  |  |  | WIRE TRANSFER BY 10:00 AM-CST
 | INVOICE DATE: |  | 2001-07-16 00:00:00 |  |  | 016-67729-301 |  |  | Attn:  [NAME] |  |  |  |  | NATIONS BANK - DALLAS, TEXAS
 | DUE DATE: |  | 2001-07-25 00:00:00 |  | VOLUME BASIS: |  |  |  | Water and Power Department |  |  |  |  | ENRON NORTH AMERICA CORP.
 |  |  |  |  |  | MMBTU 14.73 DRY |  |  | 45 E Gelnarm Avenue |  |  |  |  | ACCT. #[PHONE] ABA ROUTING #111000012
 |  |  |  |  |  |  |  |  | Pasadena, CA   91105
 | FAX#(626) 792-9647& (626) 744-7132 |  |  |  | FOR FURTHER INFORMATION CALL: JANINE CASHIN   (713) 345-8472  FAX (713) 646-8420
 | FACILITY |  |  |  |  |  | DATES |  | [NAME] |  |  |  |  | PRICE |  |  | TOTAL
 | FACILITY | PIPE/METER |  | [NAME] |  |  | START | END | TIER | TIER VOL | PER |  | MMBTU | INDEX | ADJUST. | FINAL | DOLLARS
 | TO INVOICE YOU FOR NATURAL GAS SALES:
 |  |  |  | NGI Deliveries |  |  | 2001-03-01 00:00:00 | 2001-03-31 00:00:00 |  |  |  |  | 170500 |  |  |  | 2153415
 |  | EPNG |  | Gas Daily Purchase |  |  |  |  |  |  |  |  | -86202 |  |  |  | -1159913.77
 |  |  |  | Gas Daily Sale |  |  |  |  |  |  |  |  | 1121 |  |  |  | 11148.35
 |  |  |  | Fixed Price Delivery
 |  |  |  | Net Usage
 |  |  |  | Kern River Station Purchase |  |  |  |  |  |  |  |  | -123501 |  |  |  | -1558582.62
 |  |  |  | Fixed |  |  |  |  |  |  |  |  | -120466 |  |  |  | -843262
 |  |  |  | Variable |  |  |  |  |  |  |  |  | -113558 |  |  |  | -24233.73
 | TOTAL DUE ENRON NORTH AMERICA / (CITY OF PASADENA)
Spreadsheet: 678848d1590081912-8-hours-worktime-book1-data-validation
Sheet: Sheet1

Personel | Hour | Date
[NAME] | 3 | 2020-05-21 00:00:00 |  |  |  |  |  |  | 3
[NAME] | 2 | 2020-05-21 00:00:00 |  |  |  |  |  |  | 2
[NAME] | 3 | 2020-05-21 00:00:00 |  |  |  |  |  |  | 4
[NAME] | 3 | 2020-05-21 00:00:00 |  |  |  |  |  |  | 3
[NAME] | 1 | 2020-05-21 00:00:00 |  |  |  |  |  |  | 1
[NAME] |  | 2020-05-21 00:00:00 |  |  |  |  |  |  | 2
Alexis | 3 | 2020-05-21 00:00:00 |  |  |  |  |  |  | 3
Alexis | 4 | 2020-05-28 00:00:00 |  |  |  |  |  |  | 4
Alexis | 3 | 2020-05-28 00:00:00 |  |  |  |  |  |  | 3
[NAME] | 2 | 2020-05-28 00:00:00 |  |  |  |  |  |  | 2
Alexis | 1 | 2020-05-25 00:00:00 |  |  |  |  |  |  | 1
[NAME] | 1 | 2020-05-25 00:00:00 |  |  |  |  |  |  | 1
[NAME] | 2 | 2020-05-25 00:00:00 |  |  |  |  |  |  | 2
Amanda | 3 | 2020-05-25 00:00:00 |  |  |  |  |  |  | 3
Amanda | 2 | 2020-05-25 00:00:00 |  |  |  |  |  |  | 2
Spreadsheet: 76361d1276868771-rearrange-pivot-table-columns-excelforumspt
Sheet: Sheet1

Date | Product | Units
2009-10-01 00:00:00 | Apples | 10
2009-10-15 00:00:00 | Peaches | 20 |  |  | Month | Date
2009-11-01 00:00:00 | Apples | 30 |  |  | Product | 2009-11-01 00:00:00 | 2009-11-15 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-01-15 00:00:00 | Grand Total
2009-11-15 00:00:00 | Peaches | 40 |  |  | Apples | 30 |  |  |  |  | 30
2009-12-01 00:00:00 | Lemons | 50 |  |  | Lemons |  |  | 50 |  |  | 50
2010-01-01 00:00:00 | Strawberries | 60 |  |  | Peaches |  | 40 |  |  |  | 40
2010-01-15 00:00:00 | Watermelons | 70 |  |  | Strawberries |  |  |  | 60 |  | 60
 |  |  |  |  | Watermelons |  |  |  |  | 70 | 70
 |  |  |  |  | Grand Total | 30 | 40 | 50 | 60 | 70 | 250
Spreadsheet: 862477d1710195762-exclude-holidays-in-total-holiday-sample
Sheet: Jan

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday Count | Weekdays Count | Weekend Count | Entitlement | Total Taken | Balance | Current formula
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If Holiday is on Weekend
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday Count | Weekdays Count | Weekend Count | Entitlement | Total Taken | Balance | Aiming for this result
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 3.5 | 4 | 10
 |  | 2017-01-01 00:00:00 | 1 | 1 | 1 |  |  |  | 1 | 1 |  |  | 1 | 0.5 |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | Holiday fall on weekend | 3.5 days is filled | 4 Weekend is filled excluding Holiday
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If Holiday is on Weekdays
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday Count | Weekdays Count | Weekend Count | Entitlement | Total Taken | Balance | Aiming for this result
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 6.5 | 2 | 10
 |  | 2018-01-01 00:00:00 | 1 | 1 | 1 |  |  |  | 1 | 1 |  |  | 1 | 0.5 |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  | Holiday fall on weekdays | 6.5 days is filled | 2 Weekend is filled excluding Holiday
Spreadsheet: 885529d1735221310-i-would-like-to-exclude-any-row-from-being-ranked-based-on-a-criteria-sample-worksheet-ranking
Sheet: Sheet1

Monthly Accts. | Type | Total | Rank |  |  | I would like to exclude any row for ranking if it has the following items in column "B":
Account 1 | ----- | 0
Account 2 | ----- | 0 |  |  |  | 1. "-----"
Account 3 | deposit | 98453.45000000003 |  |  |  | 2. "deposit"
Account 4 | deposit | 20700 |  |  |  | 3. "trans-cr"
Account 5 | deposit | 7210
Account 6 | trans-cr | 4000
Account 7 | autopy-c | 31692.12000000001
Account 8 | e-check | 1428
Account 9 | trans-dr | 8890
Account 10 | trans-dr | 3000
Account 11 | e-paymt | 3942.1
Account 12 | e-paymt | 576.3000000000001
Account 13 | ----- | 1812
Account 14 | e-paymt | 2069.5
Account 15 | autopy-c | 3492.5
Account 16 | e-paymt | 10075.83
Account 17 | 1st pymt | 35022.97
Account 18 | 1st pymt | 4068.61
Account 19 | e-paymt | 900.88
Account 20 | e-paymt | 445.1700000000001
Account 21 | e-paymt | 793.8599999999999
Account 22 | ----- | 516.9
Account 23 | autopy-b | 451.66
Account 24 | e-paymt | 1168.02
Spreadsheet: drew_fossum__8994__Fixed3_103100
Sheet: RMTC_2

[NAME]
FUEL HEDGING BOOK
Risk Management & Trading Corp._2
Prod. | Contract | Contract | Fixed |  | Fuel | Settled | [NAME] | (Gains) and Losses
Date | Number | Name | Price |  | Dth | Price | Price | Total | Realized | Unrealized
 |  |  |  |  |  | El Paso Prmn |  | (4) | (4) | (4)
2000-01-01 00:00:00 |  | RMTC | 2.365 |  |  | 2.19
2000-02-01 00:00:00 |  | RMTC | 2.365 |  |  | 2.41
2000-03-01 00:00:00 |  | RMTC | 2.365 |  |  | 2.41
2000-04-01 00:00:00 |  | RMTC | 2.365 |  |  | 2.79
2000-05-01 00:00:00 |  | RMTC | 2.365 |  |  | 2.87
2000-06-01 00:00:00 |  | RMTC | 2.365 |  |  | 4.1
2000-07-01 00:00:00 |  | RMTC | 2.365 |  |  | 4.35
2000-08-01 00:00:00 |  | RMTC | 2.365 |  |  | 3.77
2000-09-01 00:00:00 |  | RMTC | 2.365 |  |  |  | 4.5
2000-10-01 00:00:00 |  | RMTC | 2.365
2000-11-01 00:00:00 |  | RMTC | 2.365
2000-12-01 00:00:00 |  | RMTC | 2.365
 |  |  |  |  |  | TW Index
2000-01-01 00:00:00 |  | Over-retention | 2.365 |  |  | 2.26
2000-02-01 00:00:00 |  | Over-retention | 2.365 |  |  | 2.43
2000-03-01 00:00:00 |  | Over-retention | 2.365 |  |  | 2.64
2000-04-01 00:00:00 |  | Over-retention | 2.365 |  |  | 2.79
2000-05-01 00:00:00 |  | Over-retention | 2.365 |  |  | 3.31
2000-06-01 00:00:00 |  | Over-retention | 2.365 |  |  | 4.09
2000-07-01 00:00:00 |  | Over-retention | 2.365 |  |  | 3.85
2000-08-01 00:00:00 |  | Over-retention | 2.365 |  |  | 4
2000-09-01 00:00:00 |  | Over-retention | 2.365 |  |  |  | 4.64
2000-10-01 00:00:00 |  | Over-retention | 2.365 |  |  |  | 4.77
2000-11-01 00:00:00 |  | Over-retention | 2.365
2000-12-01 00:00:00 |  | Over-retention | 2.365
(4)Gain and [NAME] are a measurement of the effectiveness of meeting the stated hedge objective.
Spreadsheet: 882988d1731475529-calculating-non-overlapping-days-from-2-sets-of-2-dates-dates
Sheet: Sheet1

Arrival Start Date 1 | Departure Date 1 | Arrival Start Date 2 | Departure Date 2 | [NAME] | Departure Date 3 | Arrival Start Date 4 | Departure Date 4 | Visa 1 Start Date | Visa 1 End Date | Visa 2 Start Date | Visa 2 End Date |  | Days Without Visa Trip 1 | Days Without Visa Trip 2 | Total Days Without Visa (All Trips)
2023-04-23 00:00:00 | 2023-05-04 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2023-04-24 00:00:00 | 2023-05-03 00:00:00 | 00:00:00 | 00:00:00
Spreadsheet: 76710d1277223662-excel-2007-range-contains-text-then-insert-range-from-other-cells-copy-range-in-range_after_text-_filter
Sheet: After

Company Name | Industry
24/7 Customer Pvt Ltd |  | All these fields are coming from a different worksheet - (3) keywords
24x7 Learning Solutions PvtLtd
3D PLM Software Solutions Ltd | IT / ITES
3i Infotech Ltd | IT / ITES
Core BPO (India) Pvt Ltd | BPO / KPO
3M India Ltd
7Seas Technologies Ltd | IT / ITES
A G Technologies Pvt Ltd | IT / ITES
A.T. Road Software India Pvt. Ltd. | IT / ITES
A3TL
AABSyS Information outsourcing  Pvt Ltd | BPO / KPO
Appel Services (BPO Division of Essel Shyam Communication Ltd) | BPO / KPO
Spreadsheet: 438024d1451683103-track-scores-copy-of-season-scores-2
Sheet: Sheet1

Date | Meet | Bars | Beam | Vault | Floor | AA | Place
2016-01-01 00:00:00 | Brestyan's [NAME] | 8.8 | 9.45 | 8.65 | 9.175 | 36.075 | 1st
 | RI Invitational
 | Shen's New England Classic
Total
Spreadsheet: 6ae8f1d2-28a8-4151-a82e-67eb17552bfe
Sheet: Sheet1

Judgeship Number 6 (North Dakota) | Unnamed: 1 | Unnamed: 2
Downloaded at 9/21/2014 7:10:09 PM
Precincts Reporting: 528/528 - Total Ballots Cast: 321133
2008 General Election - OFFICIAL RESULTS
County | [NAME] | TOTALS
[NAME] | 56811 | 56811
Steele | 848 | 848
Traill | 3411 | 3411
TOTAL | 61070 | 61070
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 160348d1339061897-amalgamating-three-worksheets-into-one-sales-example
Sheet: Sheet2

Region | Branch | Sales ID | [NAME] | Sales Code | Company | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00
North | 1 | 789t | J Smith | xx/xxxx | smith & smith | 2600 | 3000 | 2600 | 3000 | 2600 | 3000 | 2600 | 3000 | 2600
Spreadsheet: 847842d1698684471-need-consolidated-total-duration-of-the-training-hours-spent-by-each-employee-formula-etaf-v2
Sheet: Data

EMP ID | Name | First Join | Last Leave | In-Meeting Duration | In Meeting Duration | first join real time | last leave real time
230456 | Vijay | 10/09/23, 2:03:31 PM | 10/09/23, 6:03:11 PM | 3h 59m 39s
230456 | Vijay | 10/09/23, 2:03:31 PM | 10/09/23, 6:03:11 PM | 3h 59m 39s
230456 | Vijay | 10/10/23, 2:09:53 PM | 10/10/23, 6:00:55 PM | 3h 30m 40s
230456 | Vijay | 10/10/23, 2:09:53 PM | 10/10/23, 4:30:07 PM | 2h 20m 14s
230456 | Vijay | 10/10/23, 4:35:17 PM | 10/10/23, 4:55:53 PM | 20m 35s
230456 | Vijay | 10/10/23, 5:11:04 PM | 10/10/23, 6:00:55 PM | 49m 51s
230456 | Vijay | 10/11/23, 2:01:22 PM | 10/11/23, 6:00:06 PM | 2h 9m 35s
230456 | Vijay | 10/11/23, 2:01:22 PM | 10/11/23, 2:24:30 PM | 23m 7s
230456 | Vijay | 10/11/23, 3:42:20 PM | 10/11/23, 4:22:36 PM | 40m 15s
230456 | Vijay | 10/11/23, 4:53:52 PM | 10/11/23, 6:00:06 PM | 1h 6m 13s
230456 | Vijay | 10/12/23, 2:00:43 PM | 10/12/23, 6:05:04 PM | 4h 4m 20s
230456 | Vijay | 10/12/23, 2:00:43 PM | 10/12/23, 6:05:04 PM | 4h 4m 20s
230456 | Vijay | 10/13/23, 2:15:37 PM | 10/13/23, 6:00:44 PM | 3h 41m 54s
230456 | Vijay | 10/13/23, 2:15:37 PM | 10/13/23, 2:37:00 PM | 21m 23s
230456 | Vijay | 10/13/23, 2:40:12 PM | 10/13/23, 6:00:44 PM | 3h 20m 31s
230456 | Vijay | 10/16/23, 1:58:08 PM | 10/16/23, 6:20:02 PM | 1h 23m 30s
230456 | Vijay | 10/16/23, 1:58:08 PM | 10/16/23, 2:36:15 PM | 38m 6s
230456 | Vijay | 10/16/23, 5:21:24 PM | 10/16/23, 5:24:11 PM | 2m 47s
230456 | Vijay | 10/16/23, 5:37:24 PM | 10/16/23, 6:20:02 PM | 42m 37s
230456 | Vijay | 10/17/23, 2:12:34 PM | 10/17/23, 5:57:31 PM | 3h 40m 19s
230456 | Vijay | 10/17/23, 2:12:34 PM | 10/17/23, 3:21:44 PM | 1h 9m 9s
230456 | Vijay | 10/17/23, 3:26:21 PM | 10/17/23, 5:57:31 PM | 2h 31m 10s
230456 | Vijay | 10/18/23, 2:01:05 PM | 10/18/23, 5:58:00 PM | 3h 56m 54s
230456 | Vijay | 10/18/23, 2:01:05 PM | 10/18/23, 5:58:00 PM | 3h 56m 54s
231786 | Kiran | 10/16/23, 1:58:08 PM | 10/16/23, 2:36:15 PM | 38m 6s
231786 | Kiran | 10/17/23, 5:21:24 PM | 10/17/23, 5:24:11 PM | 2m 47s
 | 1 -I need NO OF DAYS excluding SAT & SUN based on FIRST JOIN column data
 | 2- I need the total duration from the column In-Meeting Duration in other column with format HH:MM:SS
 | 3- If an employee joined only for few minutes it should only show in minutes with format MM:SS ( see example KIRAN from the below data last 2 rows)