tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 854188d1704158774-a-networkday-formula-that-excludes-holidays-and-multiple-leave-date-entries-by-employee-formula-play_with-expected-results-highlighted-in-yellow_v4
Sheet: Leave

employee | Start | end |  | Leave type
AS123 | 2024-02-11 00:00:00 | 2024-02-19 00:00:00 |  | [NAME]
AP345 | 2024-03-12 00:00:00 | 2024-03-19 00:00:00 |  | Recreational
AS123 | 2024-02-07 00:00:00 | 2024-02-10 00:00:00 |  | Sick without Pay - MC
AP346 | 2024-02-10 00:00:00 | 2024-02-19 00:00:00 |  | Leave without pay
[NAME] | 2024-02-10 00:00:00 | 2024-02-19 00:00:00 |  | [NAME]
AP345 | 2024-02-10 00:00:00 | 2024-02-19 00:00:00 |  | [NAME]
Spreadsheet: 820163d1677893442-if-time-range-is-between-a-set-range-enter-number-or-word-if-time-range-is-between-a-set-time-range
Sheet: Sheet1

 | Shifts |  |  |  |  | Time range event occurred
# | Start Time | End Time | length |  |  | Event Start | Event End | event length | event start shift | event end shift
1 | 07:00:00 | 15:00:00 |  |  |  | 15:10:53 | 16:11:37
2 | 15:00:00 | 23:00:00 |  |  |  | 07:21:46 | 16:26:57
3 | 23:00:00 | 07:00:00 |  |  |  | 03:23:44 | 08:29:52
Spreadsheet: 96266d1295658957-vlookup-with-multiple-conditions-question
Sheet: Sheet2

2010
Tracking # | Year | QTR | Cost
200 |  |  |  |  | Sum of Cost | Column Labels
 |  |  |  |  | Row Labels | 1 | 2 | 3 | 4 | Grand Total
 |  |  |  |  | 2010
 |  |  |  |  | 200 | 3000 |  |  | 5000 | 8000
 |  |  |  |  | 202 |  |  | 4000 |  | 4000
 |  |  |  |  | 2010 Total | 3000 |  | 4000 | 5000 | 12000
2011 |  |  |  |  | 2011
Tracking # | Year | QTR | Cost |  | 210 |  | 2500 |  |  | 2500
 |  |  |  |  | 211 | 6500 |  |  |  | 6500
 |  |  |  |  | 2011 Total | 6500 | 2500 |  |  | 9000
 |  |  |  |  | Grand Total | 9500 | 2500 | 4000 | 5000 | 21000
Spreadsheet: 51887d1251476490-how-do-i-adding-a-condition-to-an-if-and-vlookup-forumula-formula
Sheet: Drop Down

Customer |  |  | MC | Insp | AM |  |  | Applied by | Reason | Removed
CAT
DEERE |  |  | Invisible | RB |  |  |  | A | New Check | A
CNH |  |  | Mix | DN |  |  |  | DAV | New Trap | DAV
CAMOPLAST |  |  | Burlington | RB |  |  |  | Mar | New Route | Mar
 |  |  | Juan | RB |  |  |  | MM | A to B | MM
MAIN CUSTOMERS | Account Manager |  |  |  |  |  |  | Mist |  | Mist
Camoplast | [NAME] |  | OTHER CUSTOMERS |  |  |  |  | [NAME] |  | [NAME]
Caterpillar | [NAME] |  | A.R.E. | RB |  |  |  | [NAME] |  | [NAME]
Caterpillar Paving Products | [NAME] |  | AAA | RB
[NAME] (Tyler) | [NAME] |  | Miller W | CR
[NAME] | [NAME]
CNH Burlington | [NAME]
[NAME] | [NAME]
[NAME] (Kobelco) | [NAME]
CNH Davenport / Mt. Joy | [NAME]
[NAME], Ga. | [NAME]
CNH Fargo | [NAME]
CNH Goodfield | [NAME]
CNH Grand Island | [NAME]
CNH New Holland | [NAME]
CNH Saskatoon(Flexi) | [NAME]
CNH Service | [NAME]
CNH Tractor | [NAME]
CNH Transmission | [NAME]
CNH Wichita | [NAME]
[NAME] | [NAME]
[NAME] Des Moines | [NAME]
[NAME]. | [NAME]
[NAME] | [NAME]
[NAME] Ottumwa | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
Spreadsheet: 828293d1683367508-calculate-normal-and-after-hours-from-start-and-finish-time-example-time-calculation-rj
Sheet: All Good

Start & End |  | Tot. Hours | After Hours | Working (A/H) | Normal Hours | Manually Entered for reference |  |  |  |  | test b3 < | test as value
Start | End |  |  | But need for XX:XX |  | [NAME] | A/H Correct | N/H Correct
20:00:00 | 01:00:00 |  |  |  |  | 05:00:00 | 02:00:00 | 03:00:00
16:00:00 | 00:00:00 |  |  |  |  | 08:00:00 | 01:00:00 | 07:00:00
04:00:00 | 11:00:00 |  |  |  |  | 07:00:00 | 02:00:00 | 05:00:00
11:00:00 | 13:00:00 |  |  |  |  | 02:00:00 | 00:00:00 | 02:00:00
20:00:00 | 04:00:00 |  |  |  |  | 08:00:00 | 05:00:00 | 03:00:00
22:00:00 | 08:00:00 |  |  |  |  | 10:00:00 | 07:00:00 | 03:00:00
 | This uses from 23:00 - 6:00 for after hours calc
Start & End |  | Tot. Hours | After Hours | Working (A/H) | Normal Hours | Manually Entered for reference
Start | End |  |  | But need for XX:XX |  | [NAME] | A/H Correct | N/H Correct |  | with time() function
20:00:00 | 01:00:00 |  |  |  |  | 05:00:00 | 02:00:00 | 03:00:00
16:00:00 | 00:00:00 |  |  |  |  | 08:00:00 | 01:00:00 | 07:00:00
04:00:00 | 11:00:00 |  |  |  |  | 07:00:00 | 02:00:00 | 05:00:00
11:00:00 | 13:00:00 |  |  |  |  | 02:00:00 | 00:00:00 | 02:00:00
20:00:00 | 04:00:00 |  |  |  |  | 08:00:00 | 05:00:00 | 03:00:00
23:00:00 | 07:00:00 |  |  |  |  | 08:00:00 | 08:00:00 | 00:00:00 | <-- added test
22:00:00 | 08:00:00 |  |  |  |  | 10:00:00 | 07:00:00 | 03:00:00
Spreadsheet: 1e5b4365-85b0-4f77-8d8a-1d39c36d8cb5
Sheet: 16-Jo 

UNIVERSITETI I PRISHTINËS
Nr. 120
Prishtinë , më 18 . 1 . 2012.
 | Komisioni për lirim nga pagesa e semestrit të studentëve të Universitetit të Prishtinës,në mbledhjen e mbajtur më 16.1. 2012, mori
 | V E N D I M
 | Mbi mos lirimin nga pagesa e semestrit për [NAME] 2011/2012
 | [NAME] 2011/2012 [NAME] nga pagesa e semestrit këta studentë nga
 | Fakulteti i  Shkencave të Aplikuara në Biznes në Pejë
Nr. | Emri, emri i prindit dhe mbiemri | Komuna | Kategoria | Arsyeja
1 | [NAME] | Pejë | Prindi i vrarë | [NAME] ka vendim mbi njohjën e statusit të familjës së dëshmorit
2 | [NAME] | Deçan | Prindi i vrarë | [NAME] ka vendim mbi njohjën e statusit të familjës së dëshmorit
3 | Pajtim [NAME] | Pejë | Prindi i vrarë | [NAME] ka vendim mbi njohjën e statusit të familjës së dëshmorit
4 | [NAME] | Pejë | Prindi i vrarë | [NAME] ka vendim mbi njohjën e statusit të familjës së dëshmorit
5 | Valentina Idriz [NAME] | Pejë | Prindi i vrarë | [NAME] ka vendim mbi njohjën e statusit të familjës së dëshmorit
6 | [NAME] | Klinë | Prindi i vrarë | [NAME] ka vendim mbi njohjën e statusit të familjës së dëshmorit
7 | [NAME] | Deçan | Invalid i luftes | [NAME] ka vendim mbi njohjën e statusit të invalidit
8 | Argjentina [NAME] | Deçan | Asistencë sociale | [NAME] ka vendim te ndihmes socoale
9 | [NAME] | Deçan | Asistencë sociale | [NAME] ka vendim te ndihmes socoale
10 | Leotrim Ragip Gervalla | Deçan | Asistencë sociale | [NAME] ka vendim te ndihmes socoale
11 | [NAME] | Deçan | Asistencë sociale | [NAME] ka vendim te ndihmes socoale
12 | Berat Agim Alimusaj | Deçan | Asistencë sociale | [NAME] ka vendim te ndihmes socoale
13 | [NAME] | Pejë | Asistencë sociale | [NAME] ka vendim te ndihmes socoale
14 | Armend Daut Sadikaj | Istog | Asistencë sociale | [NAME] ka vendim te ndihmes socoale
15 | Pajtim Gani Shala | Deçan | Asistencë sociale | [NAME] ka vendim te ndihmes socoale
16 | Gazmend [NAME] | Pejë | Asistencë sociale | [NAME] ka vendim te ndihmes socoale
 | VËREJTJE:
 | Kundër këtij [NAME] të parashtrohet ankesa e argumentuar në afat prej 8 ditësh nga dita e publikimit të këtij vendimi. Ankesa dorëzohet në fakultetin përkatës.
 |  |  |  | K O M I S I O N I:
 |  |  |  | Prof.Dr.[NAME],kryetar              ________________
 |  |  |  | [NAME], anëtar                           ________________
 |  |  |  | [NAME], anëtar                         ________________
 |  |  |  | [NAME] Samadraxha(MASHT), anëtar ________________
 |  |  |  | Fehmi Ibrahimi(MPMS), anëtar          ________________
Spreadsheet: 695688d1600345835-averageifs-div-0-averageifs
Sheet: Sheet1

Town | Produce 1 | Revenue 1 | Produce 2 | Revenue 2 | Produce 3 | Revenue 3 |  |  | Town: | S | L | B
S | Cardamom | 5 | Cardamom | 7 | Betel nut | 4 |  |  | Cardamom
S | Cardamom | 8 | Cardamom | 8 | Betel nut |  |  |  | Betel nut
S | Cardamom | 6 | Cardamom | 0 | Betel nut | 0 |  |  | Tumeric
S | Betel nut | 0 | Cardamom | 9 | Betel nut | 9
L | Betel nut | 5 | Cardamom | 6 | Betel nut | 6
L | [NAME] | 4 | Cardamom | 3 | Betel nut | 3
L | [NAME] | 0 | [NAME] | 2 | Cardamom | 2
L | [NAME] | 8 | [NAME] | 1 | Cardamom | 1
B | [NAME] | 9 | [NAME] | 4 | Cardamom | 4
B | Cardamom | 3 | [NAME] | 7 | Cardamom | 7
B | Cardamom | 7 | [NAME] | 8 | Cardamom | 5
Spreadsheet: 03782350-354f-4f3b-9701-a8a9117e9b09
Sheet: Sheet1

ENCROACHMENT REMOVAL AGREEMENT APPLICATION | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
CITY OF OCEANSIDE
ENGINEERING DIVISION
COMPLETE THE INFORMATION BELOW
Project Address:
Owner/Applicant |  |  |  |  |  |  |  |  |  | Phone:
Mailing Address: |  |  |  |  |  |  |  |  |  | Fax:
City/State/Zip |  |  |  |  |  |  |  |  |  | E-Mail:
Contact: |  |  |  |  |  |  |  |  |  | Phone:
Address: |  |  |  |  |  |  |  |  |  | E-Mail:
Explain the reason for encroachment:
Encroachment is located on:
Street/Right-Of-Way width _________________   Easement Type ________________________   Easement width _______
Is this encroachment associated with a project?  □ Yes  □ No   List Project File No:                    Project Plan No:
Detailed description of encroachment:
[NAME]  _______  Yes    _______ No
NOTE: Any construction performed in the right-of-way or easement requires submittal of a Construction Certificate and Traffic Control Plan to [NAME] and approval by Engineering and Transportation Divisions
Construction Certificate Permit N0._____________ |  |  |  |  |  |  |  | Traffic Control Permit No. ______________
Submittal Check List:
□ | Preliminary Title Report/Vesting Deed |  |  |  |  | □ | Deeds/Reference Maps
□ | Assessor's [NAME] |  |  |  |  | □ | Site [NAME] (Exhibit A) Provide 5 copies.
□ | Photograph |  |  |  |  | □ | Signature Authority
□ | Transmittal Letter |  |  |  |  | □ | Encroachment Removal Agreement
Received By: |  | Date: |  |  |  |  | Recording Fee: |  |  | Permit No: ERA-
NOTE: The legal owner(s) of the parcel involved will be responsible for the accuracy of all the information submitted in connection with this application. All costs related to the preparation, submittal and recording of ERA shall be at the owner/applicant's sole expense. By accepting the application, the City of Oceanside, its officers, boards, commissioners, employees, agents and representitives, make no warranties, expressed or implied, that permission to place the encroachment with-in the right-of-way/easement will be granted or ERA will be approved.
The owner is hereby informed that any private improvements placed within the public right-of-way/easement by owner, its agents and/or contractors without prior written approval and consent by the City is done so at the owner’s sole responsibility and risk, and subject to the provisions of Chapter 31 of the Oceanside City Code.
G:\DEVELOPMENT REVIEW\ENCROACHMENT REMOVAL AGREEMENT\ERA APPLICATION |  |  |  |  |  |  |  |  |  |  |  | ENGINEERING DIVISION  (760)435-5097
Spreadsheet: 716780d1612361711-convert-raw-data-into-table-with-various-subtotals-sample-data
Sheet: SplitOut

Produit | Reference Contract | Garantie / Support | Date début effet | Date fin effet | Type de Commission | Date de règlement | Prime TTC | Prime HT | Montant commission | Taux de commission | Type de transaction
W0E | Agent1 | DA |  | 082020 | PSC | 2021-01-21 00:00:00 | 0 | 0 | -12971.13 | 0 | Manual
W0E | Agent1 | DS |  | 082020 | PSC | 2021-01-21 00:00:00 | 0 | 0 | 5.97 | 0 | Manual
W0E | Agent1 | LR |  | 082020 | PSC | 2021-01-21 00:00:00 | 0 | 0 | -194584.92 | 0 | Manual
W0O | Agent1 | DA |  | 082020 | PSC | 2021-01-21 00:00:00 | 0 | 0 | -11346.87 | 0 | Manual
W86 | Agent2 | LR | 01-JAN-21 | 31-JAN-21 | COM | 2021-01-21 00:00:00 | 9000 | 9000 | -1476.9 | 16.4 | Premium Collection
W86 | Agent2 | DS | 01-JAN-21 | 31-JAN-21 | COM | 2021-01-21 00:00:00 | 830 | 830 | -136.2 | 16.4 | Premium Collection
W86 | Agent2 | DA | 01-JAN-21 | 31-JAN-21 | COM | 2021-01-21 00:00:00 | 170 | 170 | -27.9 | 16.4 | Premium Collection
WH3 | Agent3 | DA | 01-DEC-19 | 31-DEC-19 | COM | 2021-01-21 00:00:00 | 28.13 | 25.81 | -0.39 | 1.5 | Premium Collection
WH3 | Agent3 | LR | 01-DEC-19 | 31-DEC-19 | COM | 2021-01-21 00:00:00 | 321.21 | 321.21 | -4.82 | 1.5 | Premium Collection
WH3 | Agent3 | DS | 01-DEC-19 | 31-DEC-19 | COM | 2021-01-21 00:00:00 | 137.35 | 126.01 | -1.89 | 1.5 | Premium Collection
WH3 | Agent3 | DA | 01-DEC-20 |  | COM | 2021-01-21 00:00:00 | 0 | 0 | -0.08 | 0 | Manual
WH3 | Agent3 | DS | 01-DEC-20 |  | COM | 2021-01-21 00:00:00 | 0 | 0 | -0.39 | 0 | Manual
WH3 | Agent3 | LR | 01-DEC-20 |  | COM | 2021-01-21 00:00:00 | 0 | 0 | -0.99 | 0 | Manual
WKE | Agent4 | LR |  | 082020 | PSC | 2021-01-21 00:00:00 | 0 | 0 | 0.48 | 0 | Manual
WKE | Agent4 | DS |  | 082020 | PSC | 2021-01-21 00:00:00 | 0 | 0 | 0.36 | 0 | Manual
WKE | Agent4 | DA |  | 082020 | PSC | 2021-01-21 00:00:00 |  |  |  | 0 | Manual
WKI | Agent4 | LR |  | 082020 | PSC | 2021-01-21 00:00:00 | 0 | 0 | -4308.78 | 0 | Manual
WPA | Agent4 | LR |  | 082020 | PSC | 2021-01-21 00:00:00 | 0 | 0 | -4308.78 | 0 | Manual
Y6Y | Agent1 | DU |  | 082020 | PSC | 2021-01-21 00:00:00 | 0 | 0 | 0.42 | 0 | Manual
Y6Y | Agent1 | DS |  | 082020 | PSC | 2021-01-21 00:00:00 | 0 | 0 | 34.92 | 0 | Manual
Y6Y | Agent1 | DA |  | 082020 | PSC | 2021-01-21 00:00:00 | 0 | 0 | -68623.02 | 0 | Manual
Y6Y | Agent1 | DT |  | 082020 | PSC | 2021-01-21 00:00:00 | 0 | 0 | -6908.28 | 0 | Manual
Y6Y | Agent1 | LR |  | 082020 | PSC | 2021-01-21 00:00:00 | 0 | 0 | 14923.59 | 0 | Manual
Y6Z | Agent1 | DA | 04-JAN-21 | 18-JAN-21 | COM | 2021-01-21 00:00:00 | 0 | 0 | -122 | 0 | Manual
Y6Z | Agent1 | DA |  | 082020 | PSC | 2021-01-21 00:00:00 | 0 | 0 | -11914.02 | 0 | Manual
Spreadsheet: 1acbc5b5-eba7-43ce-aba6-394b78c6d600
Sheet: INTDIS

 | PROGRAM LEVEL | # | SLOs | # | ASSESSMENT METHOD DEFINED | # | ASSESSED COURSE | # | DISCUSSION/ IMPROVEMENT | #
 | Humanities | 1 | X | 1
 | Humanities Honors Program | 1 | X | 1
 | TOTAL
 | PERCENTAGE
 | COURSE
5 | INTDIS 101 | 1
5 | INTDIS 102 | 1
5 | INTDIS 103 | 1
5 | INTDIS 140 | 1
5 | INTDIS 200A | 1
5 | INTDIS 200B-Z | 1
 | TOTAL
 | PERCENTAGE
Spreadsheet: 788973d1658828645-tools-book-out-and-returned-summary-sheet-for-stores-stock_balance-v2
Sheet: Sheet1

Part | Opening Stock | Out Date | Return date | Qty | Stock Balance | Stock Balance (inc Futures)
ABC | 20
DEF |  | 2022-07-01 00:00:00 | 2022-07-10 00:00:00 | 3
ABC |  | 2022-07-05 00:00:00 | 2022-07-13 00:00:00 | 5
ABC |  | 2022-07-17 00:00:00 | 2022-07-28 00:00:00 | 7
ABC |  | 2022-07-22 00:00:00 | 2022-07-25 00:00:00 | 3
ABC |  | 2022-07-24 00:00:00 | 2022-07-30 00:00:00 | 8
ABC |  | 2022-07-29 00:00:00 | 2022-07-30 00:00:00 | 2
Spreadsheet: louise_kitchen__23042__AAearn by month
Sheet: Mar

E N R O N   N O R T H  A M E R I C A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1Q 2001
March 2001
in Millions of $
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar
 | 2001-03-01 00:00:00 | 2001-03-02 00:00:00 | 2001-03-05 00:00:00 | 2001-03-06 00:00:00 | 2001-03-07 00:00:00 | 2001-03-08 00:00:00 | 2001-03-09 00:00:00 | 2001-03-12 00:00:00 | 2001-03-13 00:00:00 | 2001-03-14 00:00:00 | 2001-03-15 00:00:00 | 2001-03-16 00:00:00 | 2001-03-19 00:00:00 | 2001-03-20 00:00:00 | 2001-03-21 00:00:00 | 2001-03-22 00:00:00 | 2001-03-23 00:00:00 | 2001-03-26 00:00:00 | 2001-03-27 00:00:00 | 2001-03-28 00:00:00 | 2001-03-29 00:00:00 | 2001-03-30 00:00:00 | Total
Margin
Gas Trading | -13.8 | 7.9 | 39.8 | -22.5 | 23.9 | 6.9 | 40.8 | 23 | -16.5 | -11.7 | 9.5 | 11.1 | 38.5 | 44.9 | 12.4 | -9.9 | 15.1 | 20.3 | -27.3 | 67.3 | 33.4 | 42.7
Power Trading | 25.3 | 7 | 40.6 | 10.1 | -8.1 | 8.1 | 5.3 | -20.7 | -21.1 | -0.5 | 16.5 | 30.5 | 25.5 | 4.1 | 10 | 3.8 | 7.4 | 1.5 | 15.2 | 7.4 | 1 | 18
Other Trading | 0.6 | 0.5 | 1.5 | 0.6 | 0.5 | 0.5 | 0.4 | 1.5 | 0.5 | 0.4 | 0.5 | 0.5 | 1.5 | 0.4 | 0.5 | 0.3 | 0.5 | 1.3 | 0.4 | 0.5 | 0.4 | 0.3
Peakers | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 225 | 0 | 0 | 0 | 0
Originations/Office of the Chair/Other | 0 | 1.7 |  | 0 |  |  |  | 0 | 0 | 0.3 | 0.7 | -0.1 | 0 | 0 | 0 | 1 | -2.1 |  | 0
MPR | 0.2 | -0.3 | 0.1 | 0.2 | 0.3 | 3.2 | 0 | -0.2 | 0.6 | -0.5 | -0.6 | 1 | -2.6 | -5.8 | -4.3 | -3.3 | 3.1 | 4.1 | 4.1 | -3 | -2.8 | 11.1
Total Margin
Schedule C
Gas | 0 | 0 | -1.7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 40 | 0 | 0 | 0 | 0 | 75 | 0
Power | 0 | 0 | -18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 26.2 | 0
Schedule C
Total Daily Margin
Spreadsheet: 3fdfe860-45f0-47e6-a0f8-0c641dcf4625
Sheet: EDCP

Old course number | New course number
EDCP-500 | EDCP-3101
EDCP-500 | EDCP-6101
EDCP-610 | EDCP-6610
EDCP-732 | EDCP-7320
EDCP-735 | EDCP-7350
EDCP-736 | EDCP-7360
EDCP-737 | EDCP-7370
EDCP-770 | EDCP-7700
[NAME] | EDCP-8100
EDCP-820 | EDCP-8200
EDCP-850 | EDCP-8500
Spreadsheet: sally_beck__35759__MgmtSum-Q1-0331-PRELIM-C
Sheet: Shankman

ENRON NORTH AMERICA
1ST QUARTER 2000 EARNINGS ESTIMATE
Results based on Activity through February 17, 2000
 |  | Earnings Before Tax |  |  |  | Components of Earnings Before Tax |  |  |  |  |  |  |  |  |  | Variances from Plan
 |  |  |  |  |  | Actual | Deals | Forecast | Total | Operating | Capital | Direct | Allocated |  |  | Total | Operating | Capital | Direct | Allocated
Business Team |  | Estimate | Plan | [NAME] |  | Margin | Identified | Margin | Margin | Expenses | Charge | Expenses | Expenses | Total |  | Margin | Expenses | Charge | Expense | Expense | Total
Gas Trading
Canada
Gas Assets - Trading
Executive Trading
Total Trading & Risk Mgt.
Spreadsheet: 718912d1613411724-help-with-vlookup-that-matches-multiple-criteria-sample-revised
Sheet: data

country | expenditure | latest year | example
Algeria | 1077640000000 | 2016
Bangladesh | 145870000000 | 2017
Benin | 24386631217 | 2019
Benin | 61022224836 | 2015
Bhutan | 766000000 | 2018
Cambodia
Gambia | 51070000 | 2006
Gambia
Ghana | 1235750000 | 2015
India
India
India
India
Indonesia | 90100000000000 | 2018
Indonesia
Indonesia
Iraq | 1535239656000 | 2016
Iraq | 42848400000 | 2013
Kenya | 60960000000 | 2016-2017
Kenya | 3660000000 | 2017
Laos | 1459724321032 | 2019
Liberia | 3600000 | 2014
Liberia
Malaysia | 26600000000 | 2019
Spreadsheet: 78285d1278670300-reverse-calculation-for-profit-calculator-copy
Sheet: eBay

Electronics, Pro Audio Equipment, Computers & Networking,  Car Electronics, Cameras & Photo, and Video Game Systems. |  |  |  |  |  |  |  |  | All other categories |  |  |  |  |  |  |  |  | Books, DVDs & Movies, Music, Video Games |  |  |  |  |  |  |  |  | Motors - Parts & Accessories Clothing, Shoes and Accessories
SKU | Cost | Ship | Buy it Now | Ship | Fee | Profit I want | Profit |  | SKU | Cost | Ship | Buy it Now | Ship | Fee | Profit I want | Profit |  | SKU | Cost | Ship | Buy it Now | Ship | Fee | Profit I want | Profit |  | SKU | Cost | Ship | Buy it Now | Fee | Profit I want | Profit
38991 | 1085 | 5 | 1240 | 55 |  | 3 |  |  | 83907 | 58.49 | 6 | 84.99 |  |  | 2 |  |  | 33419 | 11.5 | 0 | 17.9 |  |  | 4 |  |  | 33084 | 251.65 | 7.95 | 305.99 |  | 6
Spreadsheet: 108255d1305290636-if-statement-across-multiple-worksheets-example
Sheet: WAR1a

 | HEAVY BREAKERS
 | LIGHT BREAKERS
 | FLOCK NO.
 | Week Ending | Flock | [NAME] | Jumbo | Ex-Large | Large | Net XL/LG | Medium | Small | [NAME] | Chex/U.G. | Loss | [NAME] | Total
 | Date | Age | Case | Dozens | Dozens | Dozens | Dozens | Dozens | Dozens | Dozens | Dozens | Dozens | Dozens | Dozens
 |  |  |  | 2
Spreadsheet: 688338d1595724868-compare-data-from-two-different-size-databases-show-matches-example-data-city-tax
Sheet: Sheet1

Account # | Prime Location Address | City | Site_Address
0200-016900 | 13401 SE  252ND ST |  | 13405 SE  252ND ST
0200-017500 | 13405 SE  252ND ST |  | 15004 SE 256TH ST
0200-017501 | 13409 SE  252ND ST |  | 15008 SE 253RD PL
0200-017502 | 13413 SE  252ND ST |  | 15013 SE 253RD PL
0200-017503 | 13417 SE  252ND ST |  | 15016 SE 253RD PL
0200-017504 | 13421 SE  252ND ST |  | 15016 SE 260TH ST
0200-017505 | 15125 SE  276TH PL |  | 15020 SE 253RD PL
0200-017506 | 25209  135TH AVE SE |  | 15023 SE 256TH ST
0200-017507 | 25211  136TH AVE SE |  | 15045 SE 256TH ST
0200-017508 | 25213  136TH AVE SE |  | 15124 SE 260TH ST
0200-017509 | 25215  135TH AVE SE |  | 15219 SE 251ST ST
0200-017510 | 25217  136TH AVE SE |  | 15220 SE 255TH CT
0200-017511 | 25221  135TH AVE SE |  | 15221 SE 255TH CT
0200-017512 | 25223  136TH AVE SE |  | 25213  136TH AVE SE
0200-017513 | 25301  135TH AVE SE |  | 25215  135TH AVE SE
0200-017514 | 25307  135TH AVE SE |  | 25301  135TH AVE SE
0200-017515 | 25313  135TH AVE SE |  | 25301  135TH AVE SE
0200-017516 | 25319  135TH AVE SE |  | 25319  135TH AVE SE
0200-017517 | 25325  135TH AVE SE |  | 25325  135TH AVE SE
Spreadsheet: 820601d1678193616-formula-to-work-out-hours-worked-with-parameters-sample
Sheet: Sheet1

 | Date of Work | Start Time | End Time | Hours worked in hours 08:00 -18:00 | Hours worked out of hours 18:00-08:00 & Weekends | Total
 | 2022-05-01 00:00:00 | 05:00:00 | 16:00:00
 | 2022-05-02 00:00:00 | 16:00:00 | 22:00:00
 | 2022-05-03 00:00:00 | 23:00:00 | 1900-01-01 06:00:00
 | 2022-05-04 00:00:00 | 15:00:00 | 19:00:00
 | 2022-05-05 00:00:00 | 07:00:00 | 12:00:00
Spreadsheet: 757250d1638153536-different-result-in-total-interest-paid-cumipmt-vs-loan-ammortization-table-cdub39
Sheet: Blad1

month | interest | principal | total interest +principal | remaining | check interest
 |  |  |  |  |  |  |  | 927750 | loan
 |  |  |  |  |  |  |  | 0.02 | intrest
 |  |  |  |  |  |  |  |  | divide /12
Totaal
Spreadsheet: 287827d1389011176-check-value-in-column-against-another-column-in-another-spreadsheet-ss1
Sheet: Sheet1

RecordKey | ItemCode
RecordKey | Item Number
1 | WV 700
2 | WV 612
3 | WV 181
4 | WV 180.2
5 | WV 180
6 | WV 040.1
7 | WV 040-D
8 | WV 040-C
9 | WV 040-B
Spreadsheet: 882813d1731297099-filter-vstack-multiple-tables-and-criteria-my-step-by-step-time-sheet-so-i-can-filter-_r3
Sheet: May 24

Trainer Name | Student name: (first name, last name) | What action have you taken? | Session date: | How was the training conducted? | Travel time costs (if any) | Travel mileage (if any) | What was training subject 1? (select from drop down list) | Training subject 1 - how much time () did you train on this today? (select from drop down list) | What was training subject 2? (select from drop down list) | Training subject 2 (if appropriate) - how much time (hours) did you train on this today? | What was training subject 3? (select from drop down list) | Training subject 3 (if appropriate) - how much time (hours) did you train on this today? | Ad-hoc fee - If you completed approved training or a service that is not on the list or is ad-hoc briefly summarise here. Include as much detail as is needed. | Rate | Count | Value | TORF Ref #
[NAME] | Lucan Heron | I have completed today's training | 2024-05-03 00:00:00 | Remote training via Zoom video conferencing |  |  | Xero | 1.5 |  |  |  |  |  | 31.5
[NAME] | Lucan Heron | I have completed today's training | 2024-05-06 00:00:00 | Remote training via Zoom video conferencing |  |  | Google Drive | 1.5 |  |  |  |  |  | 31.5
[NAME] | [NAME] | I am submitting a student progress update | 2024-05-10 00:00:00 |  |  |  |  |  |  |  |  |  |  | 20 | 1 | 20
[NAME] | Lucan Heron | I have completed today's training | 2024-05-10 00:00:00 | Remote training via Zoom video conferencing |  |  | Google Drive | 1.5 |  |  |  |  |  | 31.5
[NAME] | Lucan Heron | I have completed today's training | 2024-05-13 00:00:00 | Remote training via Zoom video conferencing |  |  | [NAME] | 1.5 |  |  |  |  |  | 31.5
[NAME] | Lucan Heron | I have completed today's training | 2024-05-17 00:00:00 | Remote training via Zoom video conferencing |  |  | [NAME] | 1.5 |  |  |  |  |  | 31.5
[NAME] | Lucan Heron | I have completed today's training | 2024-05-20 00:00:00 | Remote training via Zoom video conferencing |  |  | Windows | 1.5 |  |  |  |  |  | 31.5
[NAME] | Lucan Heron | I have completed today's training | 2024-05-24 00:00:00 | Remote training via Zoom video conferencing |  |  | Internet Google Chrome | 1.5 |  |  |  |  |  | 31.5 |  |  | TORF# 17817736
[NAME] | Lucan Heron | I have completed today's training | 2024-05-27 00:00:00 | Remote training via Zoom video conferencing |  |  | Internet Google Chrome | 0.5 | Keyboarding | 1 |  |  |  | 31.5 |  |  | TORF# 17825096
[NAME] | [NAME] | I have completed a TNA | 2024-05-28 00:00:00 | Remote training via Zoom video conferencing |  |  |  |  |  |  |  |  |  | 50 | 1 | 50 | TORF# 17819578
[NAME] | [NAME] | I am submitting a student timetable |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 0