tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 107187d1304419396-total-hours-is-date-is-the-same-example
Sheet: Sheet1

2011-01-04 00:00:00 | 01:00
2011-01-04 00:00:00 | 02:00
2011-01-05 00:00:00 | 00:10
2011-01-05 00:00:00 | 04:30
2011-01-06 00:00:00 | 02:02
2011-01-10 00:00:00 | 00:10
2011-01-10 00:00:00 | 03:19
2011-01-11 00:00:00 | 01:30
2011-01-12 00:00:00 | 02:01
2011-01-12 00:00:00 | 02:05
2011-01-14 00:00:00 | 01:15
2011-01-14 00:00:00 | 01:22
2011-01-14 00:00:00 | 01:32
2011-01-17 00:00:00 | 01:46
2011-01-18 00:00:00 | 01:33
2011-01-19 00:00:00 | 01:47
2011-01-19 00:00:00 | 01:47
2011-01-22 00:00:00 | 01:01
2011-01-22 00:00:00 | 01:36
2011-01-22 00:00:00 | 01:41
Spreadsheet: 547340d1510503270-filling-across-a-range-of-sheets-test
Sheet: West Eleven 1629

BOAT NAME
OWNER NAME
MOORING TYPE
ADDRESS
HOME TEL
MOBILE TEL
[NAME]
BOAT TYPE
LENGTH
HULL COLOUR
UPPER DECK
TENDER?
DURATION
FEE
NEXT INVOICE DUE DATE | 2017-11-01 00:00:00
INVOICE DUE DATE | INVOICE REMINDER DATE | INVOICE SENT DATE | DATE PAID | NOTES
2017-11-01 00:00:00
Spreadsheet: 211928d1359992347-pull-data-based-on-day-of-week-from-another-workbook-for-previous-three-weeks-salesreport2013
Sheet: 0120

 | Date: | 2013-01-20 00:00:00
 | Day
 | Time | Trans. | Total Sales | Avg. Sales
 | 09:00:00 | 0 | 0
 | 10:00:00 | 7 | 68.47
 | 11:00:00 | 22 | 175.35
 | 12:00:00 | 56 | 469.76
 | 13:00:00 | 45 | 288.02
 | 14:00:00 | 44 | 269.42
 | 15:00:00 | 39 | 302.4
 | 16:00:00 | 27 | 173.63
 | 17:00:00 | 29 | 249.14
 | 18:00:00 | 25 | 223.91
 | 19:00:00 | 18 | 127.9
 | 20:00:00 | 16 | 114.43
 | 21:00:00 | 21 | 144.3
 | 22:00:00 | 23 | 142.47
 | 23:00:00 | 12 | 78.83
 | 1900-01-01 00:00:00 | 13 | 73.71
 | 1900-01-01 01:00:00 | 0 | 0
 | 1900-01-01 02:00:00 | 0 | 0
 | 1900-01-01 03:00:00 | 0 | 0
 | 04:00:00 | 0 | 0
 | Total
Spreadsheet: 809293d1671012150-lookup-with-unique-id-and-match-date-by-month-gee83-v2
Sheet: Sheet1

 |  |  | Status return |  |  |  |  |  | Status
 |  |  |  |  | 2022-11-11 00:00:00 |  | 12440 |  | Ok
 |  |  |  |  | 2022-11-02 00:00:00 |  | 12440 |  | Ok
 |  |  |  |  | 2022-10-03 00:00:00 |  | 12443 |  | Ok
 | Unique ID | Date |  |  | 2022-12-04 00:00:00 |  | 12443 |  | Check
 | 12456 | 2022-12-10 00:00:00 |  |  | 2022-12-05 00:00:00 |  | 12444 |  | Ok
 |  |  |  |  | 2022-12-06 00:00:00 |  | 12445 |  | Ok
 |  |  |  |  | 2022-11-07 00:00:00 |  | 12446 |  | Ok
 |  |  |  |  | 2022-12-20 00:00:00 |  | 12446 |  | Check
 |  |  |  |  | 2022-12-09 00:00:00 |  | 12448 |  | Ok
 |  |  |  |  | 2022-10-10 00:00:00 |  | 12449 |  | Ok
Spreadsheet: 51dfc0a5-c087-42a1-b403-41c6573b8a4a
Sheet: Sheet1

GENERAL | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
 | Brief Title |  | Approval Deadline |  | Reason
 | Coopreative Sewer Agreement Between Grandview, Missouri |  |  |  | Execution of Cooperative Sewer Agreement
 | and KCMO, Amendment 2 |  |  |  | Amendment
Details |  |  |  |  | Positions/Recommendations
 | Reason for Legislation |  |  |  | Sponsor |  | [NAME], Acting Director of
 |  |  |  |  |  |  | Water Services
 |  |  |  |  | Programs,
 |  |  |  |  | Departments,
 |  |  |  |  | or Groups |  | Water Services
 |  |  |  |  | Affected
 |  |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents
 |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  | Water Services
 |  |  |  |  |  |  | Other
 |  |  |  |  |  |  | Grandview, Missouri
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  | None Known
 |  |  |  |  |  |  | Basis of opposition
 |  |  |  |  | Staff
 |  |  |  |  | Recommendation |  | X |  | For
 |  |  |  |  |  |  |  |  | Against
 |  |  |  |  |  |  | Reason Against
 |  |  |  |  | Board or
 |  |  |  |  | Commission |  | By
 |  |  |  |  | Recommendation
 |  |  |  |  |  |  |  |  | For |  |  |  | Against |  | No action taken
 |  |  |  |  |  |  |  |  | For, with revisions or conditions
 |  |  |  |  |  |  |  |  | (see details column for conditions)
 |  |  |  |  | Council
 |  |  |  |  | Committee |  |  |  | Do pass
 |  |  |  |  | Actions
 |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  | Without Recommendation
 |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  | Do not pass
 |  |  |  |  |  |  |  |  |  |  |  | (Continued on reverse side)
Details |  |  |  |  | Policy/Program Impact
 |  |  |  |  | Policy or Program
 |  |  |  |  | Change |  | X |  | No |  |  |  | Yes
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Finances
 |  |  |  |  | Cost & Revenue
 |  |  |  |  | Projections --
 |  |  |  |  | Including Indirect
 |  |  |  |  | Costs
 |  |  |  |  | Financial Impact |  | Execution of this Amendment and
 |  |  |  |  |  |  | implementation of the amendment
 |  |  |  |  |  |  | will continue generating revenue
 |  |  |  |  |  |  | for the Water Services Department
 |  |  |  |  | Fund Source (s)
 |  |  |  |  | and Appropriation
 |  |  |  |  | Account Codes
 |  |  |  |  | (Use this space for further discussion, if necessary)
Applicable Dates:
Fact Sheet Prepared by:
 | [NAME] |  | 2011-03-18 00:00:00
 | Contract Administration Section
Reviewed by:
 | [NAME] |  | 2011-03-18 00:00:00
 | Procedures Compliance/Analyst
Reference Numbers
Spreadsheet: 699727d1602743734-sorting-a-list-based-on-2-criteria-for-a-schedule-schedule-example
Sheet: THURS

Thurs 10/15 |  |  | Fred |  |  | TOTAL [NAME] - THIS TRUCK |  |  |  |  |  | CREW | ORDER | CUSTOMER | STORE | PHONE | NOTES | ADDRESS | JOB
08:30:00 | - |  |  |  |  |  |  |  |  |  |  | FRED | 1 | DOT, BLUE | SPRINGFIELD | 5557891023 |  | 123 MAIN STREET | WINDOW
 |  |  |  |  |  |  |  |  |  |  |  | GEORGE | 1 | SQUARE, GREEN | CHESTERFIELD | 5551234567 |  | 57 THIS ROAD | DOOR
 |  |  |  |  |  |  |  |  |  |  |  | FRED | 3 | CIRCLE, RED | DEERFIELD | 5558294837 |  | 2098 THAT STREET | WORK ORDER
 |  |  |  |  |  |  |  |  |  |  |  | FRED | 4 | TRIANGLE, ORANGE | DEERFIELD | 5552938503 |  | 385 PARK WAY | MEASURE
 |  |  |  |  |  |  |  |  |  |  |  | FRED | 2 | RECTANGLE, YELLOW | CHESTERFIELD | 5550928342 |  | 832 APPLE LANE | MEASURE
 | -
 | -
 | -
 |  |  |  |  |  | RETURN TO ACCOMODATIONS
 |  | RAY
 |  |  | GEORGE |  |  | TOTAL MILES - THAT TRUCK
10:00:00 | -
 |  |  |  |  |  | RETURN TO ACCOMODATIONS
Spreadsheet: 818253d1676670192-need-formula-to-return-phrase-based-upon-drop-down-choice-example-data-validation-tms-v2
Sheet: States

State Name | USPS Abbreviation | Traditional Abbreviation | Can we work
Alabama | AL | Ala. | Yes
Alaska | AK | Alaska | No
Arizona | AZ | Ariz. | Maybe
Arkansas | AR | Ark. | Not even if hell freeze's over
California | CA | Calif. | Yes but it will cost an arm and a leg
Colorado | CO | Colo. | With management agreement
Connecticut | CT | Conn. | With CEO agreement
Delaware | DE | Del. | Yes
Florida | FL | Fla. | No
Georgia | GA | Ga. | Maybe
Hawaii | HI | Hawaii | Not even if hell freeze's over
Idaho | ID | Idaho | Yes but it will cost an arm and a leg
Illinois | IL | Ill. | With management agreement
Indiana | IN | Ind. | With CEO agreement
Iowa | IA | Iowa | Yes
Kansas | KS | Kans. | No
Kentucky | KY | Ky. | Maybe
Louisiana | LA | La. | Not even if hell freeze's over
Maine | ME | Maine | Yes but it will cost an arm and a leg
Maryland | MD | Md. | With management agreement
Massachusetts | MA | Mass. | With CEO agreement
Michigan | MI | Mich. | Yes
Minnesota | MN | Minn. | No
Mississippi | MS | Miss. | Maybe
Missouri | MO | Mo. | Not even if hell freeze's over
Montana | MT | Mont. | Yes but it will cost an arm and a leg
Nebraska | NE | Neb. or Nebr. | With management agreement
Nevada | NV | Nev. | With CEO agreement
New Hampshire | NH | N.H. | Yes
New Jersey | NJ | N.J. | No
New Mexico | NM | N.Mex. | Maybe
New York | NY | N.Y. | Not even if hell freeze's over
North Carolina | NC | N.C. | Yes but it will cost an arm and a leg
North Dakota | ND | N.Dak. | With management agreement
Ohio | OH | Ohio | With CEO agreement
Oklahoma | OK | Okla. | Yes
Oregon | OR | Ore. or [NAME]. | No
Pennsylvania | PA | Pa. | Maybe
Rhode Island | RI | R.I. | Not even if hell freeze's over
South Carolina | SC | S.C. | Yes but it will cost an arm and a leg
South Dakota | SD | S.Dak. | With management agreement
Tennessee | TN | Tenn. | With CEO agreement
Texas | TX | Tex. or Texas | Yes
Utah | UT | Utah | No
Vermont | VT | Vt. | Maybe
Virginia | VA | Va. | Not even if hell freeze's over
Washington | WA | Wash. | Yes but it will cost an arm and a leg
West Virginia | WV | W.Va. | With management agreement
Wisconsin | WI | Wis. or Wisc. | With CEO agreement
Wyoming | WY | Wyo. | Yes
Spreadsheet: 752787d1634946496-multiple-entries-in-a-table-with-different-timestamps-how-to-determine-time-difference-excelhelp
Sheet: Sheet1

 |  |  | Local Date and Time | Email Conversation ID
 |  |  | 2021-10-20 16:13:22 | 122134567890
 |  |  | 2021-10-20 16:14:13 | 132456789
 |  |  | 2021-10-20 16:15:58 | 3253124534354
 |  |  | 2021-10-20 16:18:48 | 6575675675
 |  |  | 2021-10-20 16:23:19 | 6575675675
 |  |  | 2021-10-20 16:26:15 | 476874685674
 |  |  | 2021-10-20 16:30:23 | 89078786756756
 |  |  | 2021-10-20 16:29:39 | 35434563546
 |  |  | 2021-10-20 16:33:53 | 567567567567
 |  |  | 2021-10-20 16:34:29 | 467867458657
 |  |  | 2021-10-20 16:41:27 | 3454564563567670
 |  |  | 2021-10-20 16:41:57 | 234564564536
 |  |  | 2021-10-20 16:43:43 | 132456789
 |  |  | 2021-10-20 16:46:48 | 846754756846758
 |  |  | 2021-10-20 16:49:00 | 46745674567456
 |  |  | 2021-10-20 16:51:34 | 2546546456
 |  |  | 2021-10-20 16:53:02 | 3253124534354
 |  |  | 2021-10-20 16:56:50 | 3567546785768
 |  |  | 2021-10-20 16:57:52 | 2452345235
 |  |  | 2021-10-20 16:59:30 | 6.57865786789789e+17
 |  |  | 2021-10-20 17:01:25 | 869587946573546
 |  |  | 2021-10-20 17:04:18 | 46745674567456
 |  |  | 2021-10-20 17:05:53 | 3422354254543
 |  |  | 2021-10-20 17:08:43 | 122134567890
 |  |  | 2021-10-20 17:10:18 | 4.56453635467546e+17
 |  |  | 2021-10-20 17:10:53 | 132412341
 |  |  | 2021-10-20 17:14:01 | 123412341241324
 |  |  | 2021-10-20 17:14:23 | 1234123441234120
 |  |  | 2021-10-20 17:15:14 | 47646574567456
 |  |  | 2021-10-20 17:17:20 | 7574567456745
 |  |  | 2021-10-20 17:21:13 | 3563536735674560
 |  |  | 2021-10-20 17:21:28 | 747467457
 |  |  | 2021-10-20 17:30:53 | 764674567
 |  |  | 2021-10-20 17:36:55 | 89746545635643
 |  |  | 2021-10-20 17:39:23 | 898789897987689
 |  |  | 2021-10-20 17:40:32 | 467456745
 |  |  | 2021-10-20 17:52:43 | 46745674567456
 |  |  | 2021-10-20 17:55:42 | 132456789
 |  |  | 2021-10-20 18:05:52 | 4674674
 |  |  | 2021-10-20 18:26:29 | 4567456745674560
 |  |  | 2021-10-20 18:30:56 | 7467457
 |  |  | 2021-10-20 18:43:26 | 356354634563456
 |  |  | 2021-10-20 18:46:43 | 122134567890
 |  |  | 2021-10-20 18:58:24 | 3.45643573547635e+17
 |  |  | 2021-10-20 18:59:18 | 223423452345
 |  |  | 2021-10-20 18:59:48 | 245243523452345
 |  |  | 2021-10-20 19:01:42 | 122134567890
 |  |  | 2021-10-20 19:26:11 | 7.87456356356345e+16
 |  |  | 2021-10-20 19:39:47 | 1234847634657
 |  |  | 2021-10-20 20:13:29 | 46745674
 |  |  | 2021-10-20 20:13:23 | 9.57878434653254e+17
 |  |  | 2021-10-20 20:19:09 | 4.67545674567456e+17
 |  |  | 2021-10-20 20:46:25 | 234523453245
 |  |  | 2021-10-20 20:48:52 | 46745674567456
 |  |  | 2021-10-20 21:06:08 | 2.34556746757686e+16
 |  |  | 2021-10-20 21:17:11 | 457654745
 |  |  | 2021-10-20 21:31:56 | 3456657756897
Spreadsheet: 727879d1618182191-complete-versus-planned-level-of-progress-with-conditional-formatting-proximity-cf-data-bars-for-scheduled-v-actual-halesowenmum-
Sheet: Document for Excel Forum

Start Date | Actual % Complete (as reported by item owner) | % Scheduled Completion | Due Date |  |  | Scheduled Completion v Actual Completion
2021-04-01 00:00:00 | 50 |  | 2021-04-20 00:00:00
2021-04-01 00:00:00 | 50 |  | 2021-04-19 00:00:00
2021-04-01 00:00:00 | 50 |  | 2021-04-15 00:00:00
Spreadsheet: joe_parks__14513__P&L_JUN01
Sheet: basis

 | PERMIAN | KATY | [NAME] | HSC
2001-06-01 00:00:00 |  |  |  |  | -0.06
2001-07-01 00:00:00 | 0 |  |  | -139.5 | 0.04 | 0.015
2001-08-01 00:00:00 |  |  |  |  | 0.07
2001-09-01 00:00:00 |  |  |  |  | 0.04
2001-10-01 00:00:00 |  |  |  |  | 0.015
2001-11-01 00:00:00
2001-12-01 00:00:00
2002-01-01 00:00:00
2002-02-01 00:00:00
2002-03-01 00:00:00
2002-04-01 00:00:00
2002-05-01 00:00:00
2002-06-01 00:00:00
2002-07-01 00:00:00
Spreadsheet: 777626d1650531120-certain-number-value-with-several-text-combinations-sample_travelexpenses
Sheet: Sheet1

Week | Date | To work |  |  | Back |  |  | Totaal | Weektotaal
 |  | from | to | km | from | to | km
12 | 2022-03-21 00:00:00 | A | work 1 |  | work 1 | A
 | 2022-03-22 00:00:00 | A | work 2 |  | work 2 | C
 | 2022-03-23 00:00:00 | C | work 1 |  | work 1 | A
 | 2022-03-24 00:00:00 | A | work 1 |  | work 1 | B
 | 2022-03-25 00:00:00 | B | work 1 |  | work 1 | D
13 | 2022-03-28 00:00:00
 | 2022-03-29 00:00:00
 | 2022-03-30 00:00:00
 | 2022-03-31 00:00:00
 | 2022-04-01 00:00:00
 | work 1 |  |  | work 2
 | Home | km |  | Home | km
 | A | 80 |  | A | 57
 | B | 46 |  | B | 60
 | C | 32 |  | C | 4
 | D | 43 |  | D | 66
Spreadsheet: 1de2ef0e-999d-40eb-863d-cf023a8ab332
Sheet: I

Course color corresponds with term of offering. ORANGE for Fall semester, PURPLE for J-term, GREEN for both Fall and J-term.
 | AOK Designation | CAR Designation | Comment
International Studies
INST 245 | Social Sciences OR | Non-Western | cross-listed with EVST 245
 | Natural & Mathematical Sciences-Nat Sci w Lab
INST 251 | Social Sciences
INST 261 | Social Sciences | Experiential -Travel* | * when course travels-the course does not travel for all offerings
INST 270 | Social Sciences
INST 321 | Social Sciences |  | cross-listed with PSCI 321
INST 335 |  | Experiential-Travel
INST 391-392 |  | Experiential-Research
INST 422 |  | Capstone; Experiential-Research
INST 448-449 |  | Capstone
INST 452-453 |  | Capstone
INST 483-484 |  | Capstone
INST 487-488 |  | Experiential-Research
INST 493-494 |  | Capstone; Experiential-Research
INST 496-498 |  | Capstone; Experiential-Research
Spreadsheet: 704436d1605546892-count-days-by-month-in-a-date-range-summing-fractions-of-months-using-datedif-dimitrisheets-
Sheet: Tasks from to

 |  |  |  |  | Team Member 1 |  |  | Team Member 2 |  |  | Team Member 3
No. | Task | from | to | from-to | duration in months | start date | end date | duration in months |  |  | duration in months
1 | Task1 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 1 - 2 | 0.5 | 2021-01-01 00:00:00 | 2021-01-16 00:00:00 | 0.5 | 2021-01-01 00:00:00 | 2021-01-16 00:00:00 | 0.5 | 2021-01-01 00:00:00 | 2021-01-16 00:00:00
2 | [NAME] | 2021-01-16 00:00:00 | 2021-02-16 00:00:00 | 1 - 2 | 0 |  |  | 0 |  |  | 0.5 | 2021-01-16 00:00:00 | 2021-01-31 00:00:00
3 | Task3 | 2021-02-01 00:00:00 | 2021-03-16 00:00:00 | 2 - 3 | 0 |  |  | 0 |  |  | 0
4 | Task4 | 2021-01-01 00:00:00 | 2021-02-15 00:00:00 | 1 - 2 | 0 |  |  | 0 |  |  | 0.5 | 2021-01-31 00:00:00 | 2021-02-15 00:00:00
5 | Task5 | 2021-01-01 00:00:00 | 2021-03-02 00:00:00 | 1 - 3 | 0 |  |  | 0 |  |  | 0.5 | 2021-02-15 00:00:00 | 2021-03-02 00:00:00
6 | Task6 | 2021-01-01 00:00:00 | 2021-03-17 00:00:00 | 1 - 3 | 0 |  |  | 0 |  |  | 0.5 | 2021-03-02 00:00:00 | 2021-03-17 00:00:00
7 | Task7 | 2021-01-16 00:00:00 | 2021-03-01 00:00:00 | 1 - 3 | 0 |  |  | 0.5 | 2021-01-16 00:00:00 | 2021-01-31 00:00:00 | 0
8 | Task8 | 2021-01-01 00:00:00 | 2021-04-01 00:00:00 | 1 - 4 | 1 | 2021-01-16 00:00:00 | 2021-02-16 00:00:00 | 1 | 2021-01-31 00:00:00 | 2021-03-03 00:00:00 | 0.5 | 2021-03-17 00:00:00 | 2021-04-01 00:00:00
9 | Task9 | 2021-03-18 00:00:00 | 2021-04-18 00:00:00 | 3 - 4 | 0 |  |  | 0 |  |  | 0
10 | Task10 | 2021-02-01 00:00:00 | 2021-04-16 00:00:00 | 2 - 4 | 0.5 | 2021-02-16 00:00:00 | 2021-03-03 00:00:00 | 0.5 | 2021-03-03 00:00:00 | 2021-03-18 00:00:00 | 0.5 | 2021-04-01 00:00:00 | 2021-04-16 00:00:00
Spreadsheet: 808263d1670373674-insert-graph-for-the-data-series-of-wanted-years-and-months-bookm-fakhteh-
Sheet: Pivot Table & Chart

Name | (All)
Year | Filter | Sum of Data
1396 | Jun | 2629.12
 | Jul | 2628.82
 | Aug | 2625.14
 | Sep | 2625.36
 | Oct | 2625.22
 | Nov | 2625.64
 | Dec | 2625.84
1397 | Jan | 2625.5
 | Feb | 2625.26
 | Mar | 2624.48
 | Apr | 2624.28
 | May | 2623.4
 | Jun | 2623
Spreadsheet: 881848d1730091419-sum-of-the-row-above-until-reach-bold-sample
Sheet: Sheet1

ID | Name | Code | Hours | $ [NAME]
000001 | [NAME] | 1 | 5 | 1000
000001 | [NAME] | 12 | 5 | 1000
Total 000001 | [NAME]
000002 | [NAME] | 1 | 5 | 1200
000002 | [NAME] | 9 | 10 | 1600
Total 000002 | [NAME]
000003 | Julia | 1 | 5 | 1000
000003 | Julia | 3 | 6 | 1200
Total 000003 | Julia
Spreadsheet: 109724d1306501121-excel-2007-specific-date-compared-to-date-range-fed-calc-v3
Sheet: Year 16

 | Case Number |  |  |  |  | Date Prepared
 | Non Custodial Parent |  |  |  |  |  | Reconciliation Date
 | CP/Caretaker
 | YEAR 16:
 |  | Amount Due |  |  |  |  |  | Charging
 |  |  |  |  |  |  |  | Order
Month |  | ORDER 1 | ORDER 2 | ORDER 3 | ORDER 4 | ORDER 5 |  | Amount
181 | January
182 | February
183 | March
184 | April
185 | May
186 | June
187 | July
188 | August
189 | September
190 | October
191 | November
192 | December
 | Support Due
 | Support Paid
 | [NAME]
 | Accrued Arrearage
 | Last Year Carryover
 | Lump/TANF
 | This Year
 | Total
 | Interest Rate
 | Arrears Interest
 | Fees Due
 | Fees Paid
 | Fees Owed
Spreadsheet: 859635d1707953876-vlookup-for-given-table-test1
Sheet: Sheet1

Store 1 | REVENUE | 0.005 | 0.0075 | 0.01 | 0.0125 | 0.015 | 0.03 |  |  | incentive
T-shirts | 1000
Full-Sleves | 2000 |  |  |  |  |  |  |  | T-shirts | 0.005
Half-sleves | 3000 |  |  |  |  |  |  |  | Full-Sleves | 0.005
Shorts pants | 4000 |  |  |  |  |  |  |  | Half-sleves | 0.005
Full pants | 5000 |  |  |  |  |  |  |  | Shorts pants | 0.0075
Jeans | 6000 |  |  |  |  |  |  |  | Full pants | 0.015
Ties | 7000 |  |  |  |  |  |  |  | Jeans | 0.03
Watch | 8000 |  |  |  |  |  |  |  | Ties | 0.01
Cufflinks | 9000 |  |  |  |  |  |  |  | Watch | 0.01
Belts | 10000 |  |  |  |  |  |  |  | Cufflinks | 0.0125
SOX | 11000 |  |  |  |  |  |  |  | Belts | 0.02
Shoes | 12000 |  |  |  |  |  |  |  | SOX | 0.02
Pens | 13000 |  |  |  |  |  |  |  | Shoes | 0.02
 |  |  |  |  |  |  |  |  | Pens | 0.02
[NAME]  to give following results,
(only table part is shown here)
Store 1 | REVENUE | 0.005 | 0.0075 | 0.01 | 0.0125 | 0.015 | 0.03
T-shirts | 1000
Full-Sleves | 2000
Half-sleves | 3000
Shorts pants | 4000
Full pants | 5000
Jeans | 6000
Ties | 7000
Spreadsheet: kate_symes__18204__MidC
Sheet: DJ Mid-C Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-03-06 00:00:00 |  | 342.28 | 17200 | 304.1 | 7232
 | 2001-03-05 00:00:00 |  | 322.23 | 12560 | 296.39 | 4712 | 305.57 | 470 | 252.06 | 1447
 | 2001-03-04 00:00:00 |  | 310 | 0 | 270 | 0 | 289.47 | 475 | 246.67 | 375 |  | 296.48 | 15336
 | 2001-03-03 00:00:00 |  | 305.25 | 20560 | 267.01 | 8232 | 250.36 | 685 | 281.25 | 160
 | 2001-03-02 00:00:00 |  | 305.25 | 20560 | 267.01 | 8232 | 377.23 | 90 | 300 | 100
 | 2001-03-01 00:00:00 |  | 298.9 | 27200 | 269.54 | 7872 | 372.61 | 244 | 255 | 160
 | 2001-02-28 00:00:00 |  | 200.96 | 25024 | 183.83 | 13864 | 316.43 | 2298 | 258.89 | 1480
 | 2001-02-27 00:00:00 |  | 201.92 | 15424 | 178.85 | 6464 | 244.23 | 455 | 204.11 | 1255
 | 2001-02-26 00:00:00 |  | 245.45 | 11424 | 227.06 | 6928 | 198.18 | 550 | 160 | 50
 | 2001-02-25 00:00:00 |  | 240 | 800 | 210 | 0 | 173.83 | 962 | 159.04 | 584 |  | 227.06 | 20784
 | 2001-02-24 00:00:00 |  | 194.5 | 20624 | 152.04 | 7328 | 186.82 | 2727 | 184.22 | 870
 | 2001-02-23 00:00:00 |  | 194.65 | 20624 | 152.04 | 7328 | 278.92 | 300 | 186.49 | 208
 | 2001-02-22 00:00:00 |  | 253.75 | 17824 | 217.96 | 5880 | 190.34 | 576 | 143.24 | 795
 | 2001-02-21 00:00:00 |  | 291.88 | 11824 | 261.34 | 6928 | 295 | 50 | 220.57 | 485
 | 2001-02-20 00:00:00 |  | 326.7 | 22224 | 310.97 | 5328 | 275 | 78 | 222.94 | 375
 | 2001-02-19 00:00:00 |  | 326.67 | 22624 | 310.97 | 5328 | 335.35 | 174 | 259.78 | 115
 | 2001-02-18 00:00:00 |  | 325 | 800 | 310 | 0 | 275.26 | 476 | 266.22 | 555 |  | 336.69 | 11784
 | 2001-02-17 00:00:00 |  | 349.98 | 15824 | 336.58 | 3800 | 347.69 | 281 | 332.5 | 0
 | 2001-02-16 00:00:00 |  | 460.66 | 15248 | 410.94 | 5160 | 397.28 | 230 | 350 | 40
 | 2001-02-15 00:00:00 |  | 460.66 | 15248 | 410.94 | 5160 | 348.8 | 1693 | 398.23 | 784
 | 2001-02-14 00:00:00 |  | 327.05 | 15664 | 314.82 | 3928 | 479.05 | 452 | 472.12 | 165
 | 2001-02-13 00:00:00 |  | 335.68 | 13424 | 322.6 | 4728 | 386.38 | 1053 | 330 | 0
 | 2001-02-12 00:00:00 |  | 302.64 | 12624 | 279.2 | 4528 | 271.84 | 1346 | 324.32 | 544
 | 2001-02-11 00:00:00 |  | 285 | 0 | 270 | 0 | 312.37 | 316 | 326.04 | 96 |  | 278.81 | 12600
 | 2001-02-10 00:00:00 |  | 276.16 | 15824 | 238.78 | 3328 | 322.06 | 790 | 309.3 | 328
 | 2001-02-09 00:00:00 |  | 276.16 | 15824 | 238.78 | 3328 | 341.87 | 3340 | 307.19 | 1050
 | 2001-02-08 00:00:00 |  | 381.43 | 15120 | 316.79 | 3376 | 341.12 | 2521 | 320.97 | 373
 | 2001-02-07 00:00:00 |  | 274.49 | 8688 | 253.14 | 4024 | 294.97 | 2143 | 251.02 | 216
 | 2001-02-06 00:00:00 |  | 213.71 | 10784 | 195.79 | 4096 | 259.92 | 63 | 196.16 | 307
 | 2001-02-05 00:00:00 |  | 200.43 | 11824 | 196.63 | 3968 | 204.52 | 1904 | 179.61 | 727
 | 2001-02-04 00:00:00 |  | 200 | 0 | 185 | 0 | 181.95 | 1513 | 175.11 | 1100 |  | 196.25 | 10704
 |  |  |  |  |  | ..
Spreadsheet: 879916d1727514072-help-with-time-forum-help
Sheet: Sheet1

(b) | (c) |  | (a)
Total Accrued Working Time | Revised Contract Hours | Contract Hours | Flex Balance B/F | Need (a) + (b) - (c)
393:15 | 00:00:00 | 420:00 | -1:00
453:45 | 01:00:00 | 420:00 | 37:00
432:30 | 01:15:00 | 420:00 | 26:30
Spreadsheet: 860433d1708530408-consecutive-count-book1
Sheet: Sheet1

 |  |  |  |  | CURRENT
Member ID | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | Consecutive
1 | 0 | 0 | 18 | 11 | 21 | 2 | 254.25 |  |  | 5 | 20 | 236.24 | 2 | 3
2 | 1 | 20 | 20 | 1 | 1 |  |  |  |  | 2 | 2
3 |  | 1 |  | 1
4 | 1 |  |  | 1 | 1 |  |  |  |  |  | 1
5 |  | 20.87 | 29 | 1
 |  |  |  | DESIRED
Member ID | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | Consecutive
1 | 0 | 0 | 18 | 11 | 21 | 2 | 254.25 |  |  | 5 | 20 | 236.24 | 2 | 3 | 5
2 | 1 | 20 | 20 | 1 | 1 |  |  |  |  | 2 | 2 |  |  |  | 2
3 |  | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  | 1
4 | 1 |  |  | 1 | 1 |  |  |  |  |  | 1 |  |  |  | 1
5 |  | 20.87 | 29 | 1 |  |  |  |  |  |  |  |  |  |  | 3