tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 682474d1592128738-help-with-drivers-hours-calculations-2020-06-14-oeldere-motzil-682470d1592124157-help-with-drivers-hours-calculations-weekly-runni
Sheet: Oeldere

Date | Day | [NAME] | Start Location | End Millage | End Location | Total Miles | Start Time | Finish Time | Total Hrs Worked | Daily Rest | Driver | manualy |  | help 1 | help 2
2020-06-07 00:00:00 | Sun |  |  |  |  |  |  |  |  |  | 1
2020-06-08 00:00:00 | Mon | 421537 | Halfway | 421969 | Oakham |  | 00:45:00 | 15:45:00 |  |  | 1 | 09:30:00
2020-06-09 00:00:00 | [NAME] | 421969 | Oakham | 422376 | Ashford |  | 01:14:00 | 16:13:00 |  |  | 1 | 11:02:00
2020-06-10 00:00:00 | Weds | 422376 | Ashford | 422777 | Basildon |  | 03:45:00 | 18:42:00 |  |  | 1 | 10:53:00
2020-06-11 00:00:00 | Thurs | 422777 | Basildon | 423008 | [NAME] |  | 04:15:00 | 18:56:00 |  |  | 1 | 11:27:00
2020-06-12 00:00:00 | Fri | 423008 | [NAME] | 423348 | [NAME] |  | 05:23:00 | 18:03:00 |  |  | 1 | 11:12:00
2020-06-13 00:00:00 | Sat | 423348 | [NAME] | 423538 | Halfway |  | 05:15:00 | 11:00:00 |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  | Total
I am a small transport company and I am trying to perfect a spread sheet that will record each drivers shift hours, [NAME] and Weekly rest. I have created a framework that works in part. However it falls downs in certain areas. I have enclosed a copy so that you can see what I’m trying to achieve.
You will see that from rows H & I. I have a drivers Start Time and Finish Time. What I want to do in row K is workout the drivers daily rest. By taking the Finish time on Tuesday and the start time on the Wednesday and deduct those hours. As currently I’m having to enter it manually. Which is way too slow. However I am currently using Sum to deduct H from I to give me the drivers total shift hours.
I would then like to take row J and work out the total number of hours worked over a 6 day period. But sum will not work for this calculation. I not sure if this is due to time cell format or the fact that I’m using H&I already
My third task is to calculate a drivers weekly rest. i.e take his/her finish time on Fri/Sat and calculate the number of hours from their Start time on Monday or whatever day they return to work i.e 17:00 Friday to 04:00 Monday which is 59 hours and for this to be displayed in a stand alone cell.
I have been using excel for a few years. But only for basics and I don’t wish to sound ungrateful when I ask if its possible for some to explain/show me how I need to make this calculation so that i can understand the principal should i have a similar problem later. I’m happy to play about till i get it right
Incidentally I am using office 365 on an iMac and on an iPad if this has any bearing.
Spreadsheet: 835305d1688487853-latest-data-copy-and-paste-in-sheet-2-latest-data-copy-and-paste
Sheet: Sheet2

TIME | PRODUCT NO | PRICE
2023-07-04 20:12:11.300000 | 19000
2023-07-04 20:12:11.300000 | 19050
2023-07-04 20:12:11.300000 | 19100
2023-07-04 20:12:11.300000 | 19150
2023-07-04 20:12:11.300000 | 19200
2023-07-04 20:12:11.300000 | 19250
2023-07-04 20:12:11.300000 | 19300 |  |  |  | Dear Sir
2023-07-04 20:12:11.300000 | 19350 |  |  |  | I have data in sheet 1 which has updating in specific time interval.The Data has content with Product Number and Product Price.
2023-07-04 20:12:11.300000 | 19400 |  |  |  | I want copy and paste the current Time Interval Product Price in Sheet 2 .
2023-07-04 20:12:11.300000 | 19450 |  |  |  | The Data will have updating in 1 minute time interval. and i want to copy and paste current time interval Price in respective product Number.
2023-07-04 20:12:11.300000 | 19500 | 200136 |  |  | (In our example 8.12.11 PM Product Number of 19500  PRICE IS 200136 which should be copy and paste in sheet 2 at their respective Product Number)
2023-07-04 20:12:11.300000 | 19550 |  |  |  | The Sheet 2 will update when the new data will come in Sheet 1 after 1 minute time interval.
2023-07-04 20:12:11.300000 | 19600
2023-07-04 20:12:11.300000 | 19650
2023-07-04 20:12:11.300000 | 19700
2023-07-04 20:12:11.300000 | 19750
2023-07-04 20:12:11.300000 | 19800
2023-07-04 20:12:11.300000 | 19850
2023-07-04 20:12:11.300000 | 19900
2023-07-04 20:12:11.300000 | 19950
2023-07-04 20:12:11.300000 | 20000
Spreadsheet: 785467d1656430893-index-and-match-to-lookup-a-holiday-date-for-an-employee-holidays-index-aggregate
Sheet: A to Z

PERIOD THREE |  | PERSON 1
 |  | PERSON 2
 |  | PERSON 3
Spreadsheet: e570a8e3-9385-4d1d-8ffb-ce02b34c5dbd
Sheet: Sheet1

Unnamed: 0 | [NAME] liberalų sąjūdžio nario mokesčio suvestinė Nr. ___ / 2012 M | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | ________________________[NAME]
 | 2012 [NAME]
Eil. Nr. | Nario vardas | Nario pavardė | Data | Nario mokesčio suma | Grynųjų pinigų priėmimo kvito/mokėjimo pavedimo Nr. | Pastabos
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
 |  |  | Suma: | 0
 | Data:
 |  | (suma žodžiais)
 |  | Iždininkė _______________________
Spreadsheet: 044aa192-1a62-484e-96c0-6ec346c93213
Sheet: PAG 15 - table 2

Special items | 3Q10 | 3Q11 | YTD10 | YTD11
R$ million
Restructuring | -3.027 | -1.202 | -34.877 | -6.494
Proceeds from sale of property | 0 | 43.073 | 0 | 43.073
[NAME] closure expenses | 0.375 | 0 | -46.731 | 0
Others | -0.002 | 0.017 | -2.689 | 0.017
 | -2.654 | 41.88800000000001 | -84.29700000000001 | 36.596
Spreadsheet: 888653d1739222042-change-format-of-data-diabetes-27-apr-2017-to-23-april-2018
Sheet: Table 23

00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Thu 19 Oct Glucose mmol/L
 |  |  |  |  | 8.6 | 7.4
Fri 20 Oct Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Sat 21 Oct Glucose mmol/L
Sun 22 Oct Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Mon 23 Oct Glucose mmol/L
Tue 24 Oct Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
 |  |  |  |  |  | 5.4
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Wed 25 Oct Glucose mmol/L
Legend          High Glucose (>13.3)            Low Glucose (<3.9)
Thu 26 Oct Glucose mmol/L
Spreadsheet: 839427d1691978410-extract-a-number-from-text-extract-numbers-from-text
Sheet: Sheet1

Program # and Name |  |  | Program #
8 Me and My Shadow |  |  | 8
6 Fortyfiveseventy |  |  | 6
1 Seattle Causeway |  |  | 1
4 Tito's Calling |  |  | 4
9 Bedazzle Me |  |  | 9
2 Delphia |  |  | 2
3 Fashionably Fab |  |  | 3
5 Collect Dattt |  |  | 5
7 Great Kate |  |  | 7
10 [NAME] 20/1 |  |  | 10
11 Whelen Springs 5/1 |  |  | 11
Spreadsheet: 33889d1230750700-finding-a-value-within-a-number-text-numbermatch
Sheet: Sheet1

001-01-12 | 001-01-12 | 4 | 7 | 101 | 112 | Match | 111
001-11:13 | 001-11-13 | 4 | 7 | 111 | 113 | Match
341!137:150 | 341-137-150 | 4 | 8 | 341137 | 341150 | No Match
Spreadsheet: 720280d1614093501-need-to-extract-data-and-skip-blanks-indexing-with-conditions-from-multiple-sheets-dawn-clark-
Sheet: CNC-1

Projected Delivery Date (to Production / ENG) | Priority | Part# | S/O # | S/O Due ENG PROMISE | Rev | ORIG Job Qty | ACTUAL QTY | Raw Mat'l PO / ECO# | Job # | Job At Eastern (YES or NO) | VT MEC PO# | Programming Status | CNC Status | Chemfilm/PASSIVATE | Paint / Silkscreen | PROJECTED RUN TIME (IN DAYS) | CYCLE TIME PER PC | Projected Machine Finish Date | [NAME] | Ready for chem film process | Notes
2021-03-01 00:00:00 | 1 | P/N 1 | NPI | 2021-01-04 00:00:00 | A | 22 |  | [NAME] |  | N/A | 55922 | done | ip | YES | No | 1 |  | 2021-02-23 00:00:00 |  |  | MAT'L ON ORDER
2021-03-10 00:00:00 | 2 | P/N 2 | 17874 | 2021-02-05 00:00:00 | A | 10 |  | STAINLESS | 31633 | yes |  |  |  | YES | YES | 1 |  | 2021-02-24 00:00:00 |  | x
2021-02-24 00:00:00 | 3 | P/N 3 | 17875 4pcs, 17974 2pcs | 2021-02-23 00:00:00 | A2 | 11 |  | [NAME] | 26903 | yes | - |  |  | No | No | 0.1 |  | 2021-02-24 00:00:00
2021-02-24 00:00:00 | 4 | P/N 4 | 17231 | 2020-06-26 00:00:00 | A | 3 |  | [NAME] | 31737 | Not Kitted |  |  |  | No | No | 0.1 |  | 2021-02-24 00:00:00
Spreadsheet: 126272d1319609517-excel-2007-if-function-timestamp-with-data-changes-for-excelforum-
Sheet: Sheet2

 |  | Helper Columns(You can hide these)
 | Data | First-Timestamp | Historical of Data | Timestamp Backup | Last-Timestamp
 | Fotis | 2011-10-26 08:53:59 | 3 – Fotis | 3 – 40842,[PHONE] | 2011-10-26 08:59:50
 | Greece | 2011-10-26 08:56:47 | 1 – Greece | 1 – 40842,[PHONE] | 2011-10-26 09:03:09
 | Kastalarial | 2011-10-26 08:59:37 | 0 - Kastalarial | 0 – 40842,[PHONE] | 2011-10-26 08:59:37
 | Kastalarial | 2011-10-26 08:59:37 | 0 - Kastalarial | 0 – 40842,[PHONE] | 2011-10-26 08:59:37
 | Athens | 2011-10-26 09:02:57 | 1 – Athens | 1 – 40842,[PHONE] | 2011-10-26 09:09:48
Spreadsheet: 852851d1702827955-need-help-with-filtering-drop-down-lists-from-vstack-data-on-a-separate-tab-digital-operator-production-log-v2-aligw
Sheet: Bill S.

Client | Job # | Lettercode/ Part | Remake # | Printer | Speed | Scheduled  Time | Start Time | Stop Time | Actual Time | [NAME] | Sheets Printed | Material | [NAME] | Height | # Up | Column1 | Column2 | Square Feet | Sq. Feet / Hr | MS UPDATE
CKCC | 231234 | 1 | N | Tauro-1 | 4 Pass | 1 | 15:00:00 | 16:00:00 |  |  | 25 | ART-3111 | 25 | 25
CKCC | 266766 | 1 | N | Tauro-1 | 4 Pass | 1.88 | 15:00:00 | 17:00:00 |  |  | 33 | ART-3112 | 30 | 40
CKCC | 266543 | 1 | N | Tauro-1 | 6 Pass | 2.88 | 15:00:00 | 17:30:00 |  |  | 67 | ART-3113 | 50 | 60
CKCC | 267500 | 1 | N | Tauro-2 | 4 Pass | 3.88 | 15:00:00 | 18:50:00 |  |  | 56 | ART-3114 | 56 | 77
CKCC | 255000 | 1 | N | 3R-1 | 4 Pass | 0.99 | 15:00:00 | 16:00:00 |  |  | 32 | ART-3115 | 54 | 77
CKCC | 266700 | 1 | N | 3R-2 | 4 Pass | 0.25 | 15:00:00 | 15:15:00 |  |  | 1 | ART-5445 | 22 | 22
Total
 |  |  |  |  |  |  |  | Press Summary
 |  |  |  |  |  |  |  | Press | Hrs | Sq. Ft | % SchHrs | % of SqFt | Run Time | SqFt/Hr
 |  |  |  |  |  |  |  | GS3250
 |  |  |  |  |  |  |  | HS125
 |  |  |  |  |  |  |  | Tauro-1
 |  |  |  |  |  |  |  | Tauro-2
 |  |  |  |  |  |  |  | 3R-1
 |  |  |  |  |  |  |  | 3R-2
Spreadsheet: 266830d1379774598-scrollbar-date-setting-depreciation-schedule
Sheet: Schedule

 | Asset | Price | Year | Salvage | Life | 1905-08-01 00:00:00 | 1905-09-01 00:00:00 | 1905-10-01 00:00:00 | 1905-11-01 00:00:00 | 1905-12-01 00:00:00 | 1906-01-01 00:00:00 | 1906-02-01 00:00:00 | 1906-03-01 00:00:00 | 1906-04-01 00:00:00 | 1906-05-01 00:00:00
 | Asset Name | 9000 | 2010-03-01 00:00:00 | 500 | 3 | - | - | - | - | - | - | - | - | - | -
 | Asset Name | 9000 | 2012-05-13 00:00:00 | 500 | 7 | - | - | - | - | - | - | - | - | - | -
 | Asset Name | 9000 | 2012-07-09 00:00:00 | 500 | 5 | - | - | - | - | - | - | - | - | - | -
 | Asset Name | 9000 | 2011-08-11 00:00:00 | 500 | 5 | - | - | - | - | - | - | - | - | - | -
Spreadsheet: 95105d1294783178-how-to-make-vlookup-find-a-record-only-once-my2011-27
Sheet: test

1 | aab | 55
2 | aaf | 66
3 | abc | 99
3 | asd | 88
4 | bmn | 77
4 | fhg | 44
4 | gjh | 11
4 | gjh | 22
5 | glt | 33
6 | hkj | 54
7 | nmh | 65
8 | tyg | 98
 | abc
Spreadsheet: 540698d1506893917-problem-with-accounting-data-analysis-data-comparison-analysis
Sheet: Sample result1

Account (costs) | Account (expenditures) | Document symbol (costs) | Document symbol (expenditures) | Description (costs) | Description (expenditures) | Dt | Ct | Code1 (costs) | Code1 (expenditures) | Code2 (costs) | Code2 (expenditures) | Transaction date (costs) | Transaction date (expenditures) | Document number (costs) | Document number (expenditures)
402-1-450-75011-4300 | 130-1-750-75011-4300 | 87K3/0424/17 | EXPENDITURES/EX 12/2017 | 87K3/0424/17 car services/Smith J. | EXPENDITURES/EX 12/2017 invoice 87K3/0424/17 | 22.9 | 22.9 | 16 | 16 | 000000 | 000000 | 2017-01-02 00:00:00 | 2017-01-06 00:00:00 | 95 | 12
402-1-130-75011-4300 | 130-1-750-75011-4300 | 65K2/0424/17 | EXPENDITURES/EX 12/2017 | 65K2/0424/17 car services/Green A. | EXPENDITURES/EX 12/2017 invoice 65K2/0424/17 | 23.99 | 23.99 | 16 | 15 | 000000 | 000000 | 2017-01-03 00:00:00 | 2017-01-06 00:00:00 | 95 | 12
402-1-450-75011-4300 | 130-1-750-75011-4300 | 23K3/0424/17 | EXPENDITURES/EX 12/2017 | 23K3/0424/17 car services/Brown J. | EXPENDITURES/EX 12/2017 invoice 23K3/0424/17 | 23.99 | 23.99 | 16 | 16 | 000000 | 000000 | 2017-01-04 00:00:00 | 2017-01-06 00:00:00 | 95 | 12
402-1-090-75011-4300 | 130-1-750-75011-4300 | FF/253/07/17 | EXPENDITURES/EX 12/2017 | FF/253/07/17 car services/Smith J. | EXPENDITURES/EX 12/2017 invoice FF/253/07/17 | 21.9 | 21.9 | 16 | 16 | 000000 | 000000 | 2017-01-05 00:00:00 | 2017-01-06 00:00:00 | 102 | 12
402-1-450-75011-4300 | 130-1-750-75011-4300 | 412/0424/17 | EXPENDITURES/EX 12/2017 | 412/0424/17 car services/Brown J. | EXPENDITURES/EX 12/2017 invoice 412/0424/17 | 23.99 | 23.99 | 16 | 16 | 000000 | 000000 | 2017-01-05 00:00:00 | 2017-01-06 00:00:00 | 103 | 12
402-1-450-75011-4300 | 130-1-750-75011-4300 | FF/254/07/17 | EXPENDITURES/EX 12/2017 | FF/254/07/17 car services/Green A. | EXPENDITURES/EX 12/2017 invoice FF/254/07/17 partial payment | 23.99 | 13.99 | 16 | 16 | 000000 | 000000 | 2017-01-05 00:00:00 | 2017-01-06 00:00:00 | 104 | 12
 | 130-1-750-75011-4300 |  | EXPENDITURES/EX 12/2017 |  | EXPENDITURES/EX 12/2017 invoice FF/254/07/17 partial payment |  | 10 |  | 16 |  | 000000 |  | 2017-01-06 00:00:00 |  | 12
402-1-450-75011-4300 | 130-1-750-75011-4300 | 891/0654/17 | EXPENDITURES/EX 12/2017 | 891/0654/17 car services/Smith J. | EXPENDITURES/EX 12/2017 invoice 891/0654/17 | 23.9 | 23.9 | 16 | 16 | 000000 | 000000 | 2017-01-04 00:00:00 | 2017-01-06 00:00:00 | 105 | 12
Spreadsheet: 743290d1628367652-list-values-based-on-other-cells-list-values
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
30 | 1 | 49 | 7 | 38 | 26 | 1 | 36 | 39 | 28
37 | 27 | 46 | 11 | 26 | 20 | 3 | 22 | 38 | 15
18 | 18 | 26 | 5 | 10 | 10 | 13 | 23 | 13 | 38
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] if a2-J2 is between 25 and 40
Spreadsheet: 678907d1590112314-counting-over-several-pages-and-if-conditions-arent-met-then-blank-iauditor-dashboard-for-example-sammyghr-
Sheet: 13 Jan 20 - 18 Jan 20

IAuditor Health & Safety Docs Dashboard
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Percentage
Daily Pre Start - Foremen | 2020-01-13 00:00:00 | 2020-01-14 00:00:00 | 2020-01-15 00:00:00 | 2020-01-16 00:00:00 | 2020-01-17 00:00:00 | 2020-01-18 00:00:00 | ❌ | ✓ |  | Weekly Workplace Inspection  - Foremen | 13/01/2020 - 18/01/2020
Dameon | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Dameon | ❌
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ❌
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |  | 1 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ❌
Harley | AWAY | AWAY | AWAY | AWAY | AWAY |  |  | 1 |  | Harley | ❌
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ❌
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
Nathan | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |  | 1 |  | Nathan | ❌
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | N/A
[NAME] | ✓ | ❌ | ✓ | ✓ | ✓ |  | 0.2 | 0.8 |  | [NAME] | ❌
Tyson | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |  | 1 |  | Tyson | ✓
Will | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Will | N/A
Daily Pre Start - Contractors |  |  |  |  |  |  |  |  |  | Weekly Workplace Inspection  - Contractors
 | ✓ | ✓ | AWAY | ✓ | AWAY |  |  |  |  |  | ❌
 |  | ✓ | AWAY | AWAY | AWAY |  |  |  |  |  | ❌
 | ✓ | ✓ | ✓ | ✓ | ✓ |  |  |  |  |  | ❌
Edge Protection [NAME] |  |  | 13/01/2020 - 18/01/2020 |  |  |  |  |  |  | Fortnightly [NAME] Foremen | 13/01/2020 - 18/01/2020
Lilburn |  |  | ❌ |  |  |  |  |  |  | Dameon | ❌
Camden |  |  | ✓ |  |  |  |  |  |  | [NAME] | ❌
63 [NAME] |  |  | ❌ |  |  |  |  |  |  | [NAME] | ❌
Canterbury Linen |  |  | ✓ |  |  |  |  |  |  | [NAME] | ❌
Northlink |  |  | ❌ |  |  |  |  |  |  | [NAME] | ✓
Blum |  |  | ✓ |  |  |  |  |  |  | Harley | ❌
 |  |  |  |  |  |  |  |  |  | [NAME] | ❌
 |  |  |  |  |  |  |  |  |  | [NAME] | ❌
 |  |  |  |  |  |  |  |  |  | Nathan | ❌
*** Means received but had to ask for it |  |  |  |  |  |  |  |  |  | [NAME] | N/A
❌   Means did not get one at all |  |  |  |  |  |  |  |  |  | [NAME] | ❌
 |  |  |  |  |  |  |  |  |  | Tyson | ❌
 |  |  |  |  |  |  |  |  |  | Will | N/A
 |  |  |  |  |  |  |  |  |  | Fortnightly [NAME]
 |  |  |  |  |  |  |  |  |  |  | ❌
 |  |  |  |  |  |  |  |  |  |  | ❌
 |  |  |  |  |  |  |  |  |  |  | ❌
Spreadsheet: 485861d1477117179-find-trends-in-employee-data-example
Sheet: page 15

Tur | Mandag | Tirsdag | Onsdag | Torsdag | Fredag | Lørdag | Søndag
2 9 | 14:00    24:00 | 13:25    20:54 |  |  | 15:40    22:17 | 14:00    22:00 | 22:47     6:04
 | 22:49     6:11 |  | 15:00    24:00 | 15:00     1:00
 | 22:55     5:47 | 22:09     7:17 |  |  |  | 6:25     15:47 | 8:55     16:04
 | 5:55     14:17 | 7:19     14:25 | 6:00     15:00 | 6:00     14:00 | 6:00     15:00
 |  |  | 12:50    22:02 | 16:00    24:00 | 23:27    10:19 | 22:00     6:00
 | 15:40    22:47 |  | 4:17     10:27 | 6:32     15:47 | 6:40     15:54
Tur | Mandag | Tirsdag | Onsdag | Torsdag | Fredag | Lørdag | Søndag
3 0 |  | 23:27     6:54 | 23:02     5:41 |  |  | 6:49     15:19 | 6:00     14:00
 | 4:17     11:17 | 5:49     13:22 | 14:00    23:00 | 15:00     1:00
 |  |  | 14:00    22:24 | 23:02     5:41 | 22:09     6:17 |  | 17:55     0:17
 | 14:00    23:00 | 12:50    22:02 |  | 6:00     15:00 | 6:32     15:47
 | 6:00     15:00 | 6:00     15:00 |  |  | 15:31    23:02 | 13:42    23:23 | 20:55     6:47
 | 23:31     7:41 |  | 15:00    23:00 | 13:50    22:47
Spreadsheet: 113793d1309646955-i-could-use-nested-if-statements-but-vlookupvalidation
Sheet: Sheet1

Payor | ID | Prop | Interest
 |  | Prop 6 |  |  | Column C has a Validation Lookup on Sheet 2
 |  | Prop 4 |  |  | Column D has a Vlookup Formula to return the correct Interest.
 |  |  |  |  | Click in C4 to see how it works.
Spreadsheet: 829271d1684078847-concat-formula-returns-serial-date-quickbooks-payroll-journal-entries-import-template-2-
Sheet: Payroll JE

SAMPLE COMPANY
Semi-monthly Payroll Journal Entry
Tax Period: | 6/01-6/15/2023
[NAME] |  | DEBIT | CREDIT | REFERENCE
Salaries |  | 9375
Empr Social Security Expense
[NAME] Expense
SUTA Expense |  | 432
FUTA Expense |  | 63
FWH Payable |  |  | -1357.55
Emp Social Security Payable
Emp Medicare Payable
Empr Social Security Payable
[NAME]
State WH Payable |  |  | -535.3
Local WH Payable |  |  | -200
SUI Payable
FUI Payable
Disability Insurance |  |  | -2.33
Checking
Spreadsheet: 159858d1338878973-chart-question-test
Sheet: option3

 |  | January | February | March
A | Forecast | 4252 | 7973 | 4555
 | Revenue | 5147.158 | 510.3077 | 5430.962
B | Forecast | 4555 | 4770 | 4252
 | Revenue | 5430.962 | 511.5 | 5069.692
C | Forecast | 4770 | 4595 | 4083
 | Revenue | 5687.308 | 1352.077 | 4868.192
D | Forecast | 429 | 4555 | 3466
 | Revenue | 511.5 | 1875.5 | 4132.538
E | Forecast | 428 | 4252 | 2664
 | Revenue | 510.3077 | 2422.769 | 3176.308
F | Forecast | 4083 | 4083 | 1573
 | Revenue | 4868.192 | 3176.308 | 1875.5
G | Forecast | 4595 | 3466 | 2032
 | Revenue | 5478.654 | 4132.538 | 2422.769
H | Forecast | 2664 | 2664 | 7973
 | Revenue | 3176.308 | 4868.192 | 4868.192
I | Forecast | 1573 | 2032 | 3466
 | Revenue | 1875.5 | 5147.158 | 5147.158
J | Forecast | 2032 | 1573 | 1134
 | Revenue | 2422.769 | 5430.962 | 5430.962
K | Forecast | 7973 | 1134 | 429
 | Revenue | 9154.185 | 5478.654 | 5478.654
L | Forecast | 3466 | 429 | 428
 | Revenue | 4132.538 | 5687.308 | 510.3077
M | Forecast | 1134 | 428 | 2664
 | Revenue | 1352.077 | 9154.185 | 511.5
Spreadsheet: 856411d1705662245-transpose-with-conditions-example-1-6-aligw
Sheet: Sheet1

ID | Prio | Code | String |  |  | ID | Code4 | Code1 | Code1 | Code1 | Code1 | Code2 | Code3 | Code3 | Code5 | Code5 | Code5
1000 | 2 | Code1 | String0 |  |  | 1000 | String3 | String0 | String1 | String2
1000 | 3 | Code2 | String1 |  |  | 1001 |  | String4 | String5 |  |  | String6
1000 | 4 | Code3 | String2 |  |  | 1002 |  | String7 | String8 | String9 | String10
1000 | 1 | Code4 | String3 |  |  | 1003 |  | String11 |  |  |  |  | String12 | String13
1001 | 2 | Code1 | String4 |  |  | 1004 | String15 | String14 |  |  |  |  |  |  | String16 | String17 | String18
1001 | 2 | Code1 | String5
1001 | 3 | Code2 | String6
1002 | 2 | Code1 | String7 |  |  | Result |  |  |  |  | AliGW
1002 | 2 | Code1 | String8
1002 | 2 | Code1 | String9 |  |  |  |  |  |  |  | String4|String5|String6
1002 | 2 | Code1 | String10 |  |  |  |  |  |  |  | String7|String8|String9|String10
1003 | 2 | Code1 | String11 |  |  |  |  |  |  |  | String11|String12|String13
1003 | 4 | Code3 | String12 |  |  |  |  |  |  |  | String15|String14|String16|String17|String18
1003 | 4 | Code3 | String13
1004 | 2 | Code1 | String14
1004 | 1 | Code4 | String15
1004 | 5 | Code5 | String16
1004 | 5 | Code5 | String17
1004 | 5 | Code5 | String18
Spreadsheet: benjamin_rogers__921__Gas Supply FP
Sheet: Nymex Close

 | Gas Positions
 | US Gas Swap | Nymex |  |  | As of Date
 |  |  |  |  | 2002-02-13 00:00:00
 | Term | Volume (Mmbtu) | Notional Quantity | Purchase price | Closing Price | Curve shift
 | 2002-03-01 00:00:00 | 5231250 |  |  | 2.256
 | 2002-04-01 00:00:00 | 3562500 |  |  | 2.32
 | 2002-05-01 00:00:00 | 2751250 |  |  | 2.398
 | 2002-06-01 00:00:00 | 2662500 |  |  | 2.465
 | 2002-07-01 00:00:00 | 2751250 |  |  | 2.533
 | 2002-08-01 00:00:00 | 2751250 |  |  | 2.588
 | 2002-09-01 00:00:00 | 2662500 |  |  | 2.599
 | 2002-10-01 00:00:00 | 2751250 |  |  | 2.628
Total:
Spreadsheet: 161796d1339625528-help-with-filtering-faturas
Sheet: Inv Tracker

IsporCleaning
 | Nome do Cliente
 | Area |  |  | B |  |  | Filtro
 |  |  |  |  |  |  | Mês/Ano |  | 2012-06-01 00:00:00
 | Total By Areas |  |  | Invoices
 | A |  |  | Invoice | Description | Price W/ [NAME] | Price [NAME] | Issue Date | Receipt Date | PO | Area
 | B |  |  | 4101 | Cleaning Services | 200 | 246 | 2012-03-01 00:00:00 | 2012-03-03 00:00:00 | 1 | C
 | C |  |  | 4102 | Industrial Production | 200 | 246 | 2012-03-02 00:00:00 | 2012-03-05 00:00:00 | 1 | D
 | D
 | E
 | F
 | Observações
 |  |  |  | Fatura | Descrição | Preço S/IVA | Preço C/IVA | Data Emissão Fatura | Data Recebimento | PO | Área
Spreadsheet: andy_zipper__258__Broker detail 4-19-2001
Sheet: Broker Data

[NAME] for 4/19/2001:
Broker: | Commodity: | Daily Deal Count: | LTD Deal Count: | Daily Failed Transaction Count: | LTD Failed Transaction Count:
APB Energy, Inc. | U.S. Nat Gas | 4 | 6 | 0 | 2
 | U.S. Power | 2 | 7 | 0 | 1
 | Subtotal
Natsource LLC | U.S. Nat Gas | 3 | 11 | 0 | 0
 | U.S. Power | 11 | 42 | 1 | 10
 | Subtotal
Power Merchants | U.S. Nat Gas | 0 | 1 | 0 | 1
 | U.S. Power | 0 | 0 | 0 | 0
 | Subtotal
 | Total
Spreadsheet: 104251d1301915387-need-with-nested-if-statement-test
Sheet: Sheet4

 | Price | code
 | 34 | #12
 | 56 | #20
 | 77 | #12
 | 898 | #16
 | 79 | #12
 | 24 | #8
 | 23 | #20
 | 34 | #12
 | 4354 | #16
 | 4656 | #12
 | 7678 | #8
 | 6786 | #20
 | 87 | #12
Total