tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: michelle_lokay__26631__imbalsumm0102
Sheet: Duke

Duke Energy Field Services
Contract  24268
2001-01-31 00:00:00 |  | 26997.22
2001-02-18 00:00:00
60874 | 2864
500235
500248
500251
500254
500255
500262
500267
Duke Energy Trading and Marketing
Contract  24693
2001-01-31 00:00:00 |  | 275313.72
2001-02-18 00:00:00
9164
9167
Duke Energy Trading and Marketing
Contract  24361
2001-01-31 00:00:00 |  | 470803.55
2001-02-18 00:00:00
500241
500391 | 5250
500392 | 1408
Duke Energy Trading and Marketing
21665 |  | 73449.16 | POI 9109 Mobil Waha Plant
22664 |  | 23612.35 | POI 59918 Grand Valley Plant
20248 |  | -15794
25873 |  | -259
26758 |  | -596
26372 |  | 2997.09
26700 |  | 4077.9
26422 |  | 8155.8
26661 |  | 146862.35
27291 |  | -17965
27123 |  | -6425.19
Spreadsheet: 188849d1351007590-distribute-quarterly-cost-values-to-months-based-on-start-finish-date-of-the-activity-from-quarterly-to-monthly-cost-calculation
Sheet: Sheet1

 | Start | Finish | 2013-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | q1 | q2 | q3 | q4
Cost of activity A | 2013-01-01 00:00:00 | 2013-03-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 60 | 0 | 0 | 0
Cost of activity b | 2013-02-01 00:00:00 | 2013-05-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 40 | 0 | 0
Spreadsheet: 79cc519d-477e-4d75-985c-6bf95817d379
Sheet: FEBRUARY

SEATTLE UNIVERSITY
NON-EXEMPT EMPLOYEE TIME REPORT
NAME: |  |  |  |  | DEPT: |  |  | (Use 4 letter-code as shown on paystub under DEPT)
Datatel ID Number or SSN:
PE: |  | 2015-02-01 00:00:00 | TO | 2015-02-28 00:00:00 |  | MO. NO.: |  | 2
Holiday Pay |  |  |  | HP | 7.5
Sick Pay |  |  |  | SP
Vacation Pay |  |  |  | VP
[NAME] |  |  |  | BR |  | (up to 5 days of paid leave)
Jury Duty Leave |  |  |  | JL
[NAME] |  |  |  | DP
 |  |  |  |  |  |  |  |  | Employee Signature |  |  |  | Date
Regular Pay |  |  |  | RP
SUB-TOTAL |  |  |  |  | 150 |  |  |  | Supervisor Signature |  |  |  | Date
Overtime (1.0 rate) |  |  |  |  |  | (If total hours worked (Sunday-Saturday) is between 37.50 and 40)
Overtime (1.5 rate) |  |  |  |  |  | (If total hours worked (Sunday-Saturday) is above 40)
TOTAL
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
 |  |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5
 | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7
 |  |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5
 | 8 |  | 9 |  | 10 |  | 11 |  | 12 | Time sheets due | 13 |  | 14
 |  | HP | 7.5 |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5
 | 15 |  | 16 |  | 17 |  | 18 |  | 19 |  | 20 |  | 21
 |  |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5 |  | 7.5
 | 22 |  | 23 |  | 24 |  | 25 |  | 26 | Pay day | 27 |  | 28
REMEMBER: Adjustment from Prior Month!! INCLUDE PRIOR MONTH ADJ HOURS IN THE ABOVE CALCULATION!
Spreadsheet: 83198d1283240240-combining-input-data-from-2-columns-combine-columns
Sheet: Sheet1

MODEL 1 |  |  |  |  | MODEL 2 |  |  |  |  | SUMMARY
Part | Size |  |  |  | Part | Size |  |  |  | Part | Size
xx223 | large |  |  |  | xx541 | medium |  |  |  | xx223 | large
xx331 | large |  |  |  | xx479 | medium |  |  |  | xx331 | large
 |  |  |  |  |  |  |  |  |  | xx541 | medium
 |  |  |  |  |  |  |  |  |  | xx479 | medium
Spreadsheet: 327915d1403720388-weekday-result-used-in-an-array-formula-doesnt-work-formula-works-if-i-type-in-date-sales_force_leads_one_page
Sheet: Sheet1

 |  |  |  |  |  |  |  | Report Date:
 |  |  |  | AARCO Environmental Services Corp | AARCO Environmental Services Corp.
* * * * * *  Sales Leads / Follow-up / Reporting  * * * * * *
PM | PM | JOB NO. | JOB NO. | COMPANY / CLIENT NAME | COMPANY / CLIENT NAME | LEAD/JOB DESCRIPTION | LEAD/JOB DESCRIPTION | CURRENT STATUS
Spreadsheet: 269132d1380973088-if-and-index-formula-index-d11-d59-counta-d11-d59-1-book2
Sheet: TEST

 | Surveyor 1 |  |  |  |  |  |  | >> |  | <<
Serial Number |  |  |  |  |  |  |  |  | Yes
Product Number |  |  |  |  |  |  |  |  | No
Password
Admin Account Set Up?
Ruggered Case
[NAME]
Teamviewer
Date Issued | [NAME] | Project | Surveyor | Loan agreement in place | Issued with (Charger/Bag/Cover/Sim) | Comments | Notes
2013-09-18 00:00:00 |  |  | [NAME] | Yes | Yes |  | As [NAME] hasn’t returned the equipment (B11) he would remain the current user.
 |  |  |  |  |  |  | When [NAME] returns the equipment the next row will represent the new user, asssuming a date has been applied in A12?
 |  |  |  |  |  |  | What would be great is if the there is a date in B11 and no date in A12 the returned value would be "Unassigned"
 |  |  |  |  |  |  | This is one of many exact sheets which feedback onto a "Overview" type sheet
Spreadsheet: 862758d1710399526-add-a-rank-column-based-on-multiple-criteria-sample-249-aligw
Sheet: Sheet1

id | name | Crit_A | Crit_B |  | EXPECTED OUTPUT | EXPLANATION
12047 | name A | 1 | 0.1 |  |  | <--- col C is less than 5, so nothing should show here. Also, col D is less than 20% so nothing should show
12610 | name B | 7 | 0.2 |  | 6
12330 | name C | 12 | 0.21 |  | 5
12375 | name D | 1 | 0.14 |  |  | <--- col C is less than 5, so nothing should show here
12554 | name E | 7 | 0.77 |  | 3
12596 | name F | 8 | 0.9 |  | 1
11909 | name G | 9 | 0.88 |  | 2
12505 | name H | 13 | 0.66 |  | 4
12325 | name I | 19 | 0.15 |  |  | <--- col C is greater than 5, but col D is less than 20% so nothing should show here
12999 | name J | 1 | 0.01 |  |  | <--- col C is less than 5, so nothing should show here
Spreadsheet: 519779d1495646051-count-number-of-occurrencies-for-account-number-test-file
Sheet: EXPECTED RESULTS

account number | name | address | attended |  | ACCOUNT NUMBER | NAME | TIMES ATTENDED
1 | [NAME] doe | 1234 drive | 1 |  | 1 | [NAME] doe | 6
1 | [NAME] doe | 1234 drive | 1 |  | 2 | mary | 5
1 | [NAME] doe | 1234 drive | 1 |  | 3 | [NAME] | 5
1 | [NAME] doe | 1234 drive | 1 |  | 4 | [NAME] | 6
1 | [NAME] doe | 1234 drive | 1
1 | [NAME] doe | 1234 drive | 1
2 | mary | 5678 drive | 1
2 | mary | 5678 drive | 1
2 | mary | 5678 drive | 1
2 | mary | 5678 drive | 0
2 | mary | 5678 drive | 1
2 | mary | 5678 drive | 1
3 | [NAME] | 9876 drive | 1
3 | [NAME] | 9876 drive | 1
3 | [NAME] | 9876 drive | 1
3 | [NAME] | 9876 drive | 0
3 | [NAME] | 9876 drive | 1
3 | [NAME] | 9876 drive | 1
4 | [NAME] | 5432 drive | 1
4 | [NAME] | 5432 drive | 1
4 | [NAME] | 5432 drive | 1
4 | [NAME] | 5432 drive | 0
4 | [NAME] | 5432 drive | 1
4 | [NAME] | 5432 drive | 1
4 | [NAME] | 5432 drive | 1
Spreadsheet: 59710d1260288197-populating-sheet-with-data-from-another-claims-inventory-work
Sheet: Claims work locations

Command | Where? | 2009-11-30 00:00:00 | 2009-12-07 00:00:00 | 2009-12-14 00:00:00 | 2009-12-21 00:00:00 | 2009-12-28 00:00:00 | 2010-01-04 00:00:00 | 2010-01-11 00:00:00 | 2010-01-18 00:00:00 | 2010-01-25 00:00:00 | 2010-02-01 00:00:00 | 2010-02-08 00:00:00 | 2010-02-15 00:00:00 | 2010-02-22 00:00:00 | 2010-03-01 00:00:00 | 2010-03-08 00:00:00 | 2010-03-15 00:00:00 | 2010-03-22 00:00:00 | 2010-03-29 00:00:00
CST1 | Desktop | 5825 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Files available in BF | 7526 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CST2 | Desktop | 12642 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Files available in BF | 8095 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CST3 | Desktop | 3441 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Files available in BF | 4856 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
BCU | Desktop | 3697 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Files available in BF | 263 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EXPORT/INTERNAL | Desktop | 2747 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Files available in BF | 1923 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
To use: Select graph to show data regions being used.
Move mouse over data encased in blue until move cursor displayed and drag over to new date to be used.
Spreadsheet: f95404aa-5640-4c66-b409-5da0e2f2097a
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42407802 | 2014-07-22 16:09:58 | AXIS | 0 | 1 | 5 | 828272 | hester24 | 6153 | western | 1944-08-24 | 1944-08-24 | Liberation of Paris | Libération de Paris
42407952 | 2014-07-22 16:23:34 | ALLIES | 1 | 5 | 0 | 828272 | hester24 | 6153 | western | 1944-08-24 | 1944-08-24 | Liberation of Paris | Libération de Paris
Spreadsheet: 45002d1243797168-count-the-number-of-files-in-a-specified-folder-number-of-files
Sheet: Sheet1

Subfolders | 100 | 99 | 97 | 96
FolderA | 1 | 1 | 1 | 1
FolderB | 1 | 2 | 1 | 1
FolderC | 1 | 1 | 1 | 2
Spreadsheet: 885190d1734617938-calculating-bus-fare-through-distance-sample
Sheet: Feuil2

Line 1 distance in m | Station A | Station B | Station C | Station D | Station E | Station F |  | Ticket price | distance
Station A |  | 9000 | 14000 | 19000 | 2200 | 27000 |  | 3 | >7000
Station B | 9000 |  | 5000 | 10000 | 13000 | 18000 |  | 4 | > 15000
Station C | 14000 | 5000 |  | 5000 | 8000 | 13000 |  | 5 | >22000
Station D | 19000 | 10000 | 5000 |  | 3000 | 8000 |  | 6 | >28000
Station E | 22000 | 13000 | 8000 | 3000 |  | 5000 |  | 7 | >38000
Station F | 27000 | 18000 | 13000 | 8000 | 5000 |  |  | 8 | >44000
 |  |  |  |  |  |  |  | 9 | >52000
 |  |  |  |  |  |  |  | 12 | <52000
Spreadsheet: ea499296-9844-42c9-a6be-f02367a38eda
Sheet: New  Table 17

Table 17
Weekly Port Region Grain Ocean Vessel Activity (number of vessels)
 |  |  |  | Pacific | Vancouver
 | Gulf |  |  | Northwest | B.C.
 |  | Loaded | Due next
Date | In port | 7-days | 10-days | In port | In port
2012 range | (13..50) | (13..46) | (27..78) | (4..20)
2012 avg. | 28 | 33 | 46 | 11 | n/a
Source:  Transportation & Marketing Programs/AMS/USDA
Spreadsheet: 719167d1613537708-function-help-show-values-in-cell-from-lookup-help
Sheet: Cost Codes

Chart of Accounts
 |  | Precincts & Stages |  |  |  | Professional Fees - DA
 |  | 000 | ALL | General |  | 51200 | Acoustic Engineering
 |  | 001 | S1 | Stage 1 |  | 51201 | Civil Engineering & Drafting
 |  | 002 | S2 | Stage 2 |  | 51202 | Electrical & Telecom Engineering
 |  | 003 | S3 | Stage 3 |  | 51203 | Geotech Engineering
 |  | 004 | [NAME] | Stage 4 |  | 51204 | Mechanical Engineering
 |  | 005 | S5 | Stage 5 |  | 51205 | Structural Engineering
 |  | 006 | S6 | Stage 6 |  | 51206 | Traffic Engineering
Spreadsheet: 725141d1616559641-wta-formula-to-separate-the-unmatched-excel
Sheet: Sheet1

Player ID | Member [NAME] | Currency | Amount | Booking Date (GMT+7) | MATCHED
10083@015 | [NAME] | IDR | 1100 | 2021-03-21 00:00:00 | 1 |  |  |  |  |  | I want this result appear in another sheet
47392@015 | [NAME] | IDR | 100 | 2021-03-21 00:00:00 | 0
50302@015 | Heru mulyanto | IDR | 400 | 2021-03-21 00:00:00 | 1 |  | RESULT>>
50123@015 | Imron rosadi | IDR | 50 | 2021-03-21 00:00:00 | 1 |  |  |  |  |  | 47392@015 | [NAME] | IDR | 100 | 2021-03-21 00:00:00 | 0
51512@015 | [NAME] | IDR | 50 | 2021-03-21 00:00:00 | 1 |  |  |  |  |  | 36457@015 | Saut barita situmorang | IDR | 200 | 2021-03-21 00:00:00 | 0
36457@015 | Saut barita situmorang | IDR | 200 | 2021-03-21 00:00:00 | 0 |  |  |  |  |  | 51218@015 | Irwana damayanti | IDR | 30 | 2021-03-21 00:00:00 | 0
48277@015 | Fiki Apriyansyah | IDR | 39 | 2021-03-21 00:00:00 | 1
45083@015 | Bun kit jin | IDR | 450 | 2021-03-21 00:00:00 | 1
49277@015 | Andri kesuma | IDR | 25 | 2021-03-21 00:00:00 | 1
8389@015 | [NAME] mai | IDR | 250 | 2021-03-21 00:00:00 | 1
51218@015 | Irwana damayanti | IDR | 30 | 2021-03-21 00:00:00 | 0
 |  |  |  |  | 1
Spreadsheet: 879824d1727402995-looking-to-add-up-the-total-hours-x-cost-hour-broken-into-fiscal-year-fiscal
Sheet: Sheet2

 |  |  |  |  |  | Total hours per month
 |  |  |  |  |  | End of fiscal |  |  | Start of fiscal
 | Session | Directorate | Group | Training Provider | [NAME] | January | February | March | April | May | June | July | August | September | October | November | December | Total Cost | Directorate2
 | F22-23 | BCD | 0 | 0 | 85 |  | 12 |  |  |  |  |  |  |  | 6 |  |  |  |  |  | Total Cost 2023 fiscal
 | F22-23 | BCD |  | [NAME] | 13.5 |  | 0 |  |  |  |  |  |  | 63 | 73.5 |  |  |  |  |  | Directorate | School
 |  |  |  | Educacentre | 70 |  | 0 |  |  |  |  |  |  |  | 12 |  |  |  |  |  |  | [NAME] | Cité-Caron | Alliance Française Vancouver | Alliance Française Edmonton | Alliance Française Manitoba | Educacentre | [NAME] Belliveau & Associates
 |  |  |  | Cité-Caron | 17.5 |  | 0 |  |  |  |  |  |  | 24 | 24 |  |  |  |  |  | ACO
 |  |  | Group | [NAME] | 13.5 |  | 3 |  |  |  |  |  |  | 57 | 60 |  |  |  |  |  | BCD
 |  |  |  | Educacentre | 85 |  | 12 |  |  |  |  |  |  |  | 6 |  |  |  |  |  | CD
 |  |  |  | Alliance Française Vancouver | 85 |  | 0 |  |  |  |  |  |  | 1.5 | 10 |  |  |  |  |  | ICD
 |  |  |  | Cité-Caron | 17.5 |  | 0 |  |  |  |  |  |  | 12 | 12 |  |  |  |  |  | TABID
 |  | TABID | 0 | [NAME] | 13.5 |  | 9 |  |  |  |  |  |  | 189.5 | 210 |  |  |  |  |  | HPTD
 |  |  |  | Alliance Française Edmonton | 75 |  | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  | Group | [NAME] | 13.5 |  | 3 |  |  |  |  |  |  | 42 | 51
 |  | ACO | 0 | [NAME] | 13.5 |  | 0 |  |  |  |  |  |  | 24 | 24
 |  |  | Group | [NAME] | 13.5 |  | 0 |  |  |  |  |  |  | 21 | 24
 | W2022 | BCD | 0 | [NAME] | 13.5 |  | 6 | 12 | 12 | 12 | 11 | 3
 |  | BCD | Group | [NAME] | 13.5 |  | 6 | 15 | 12 | 12 | 15
 |  | CD | 0 | [NAME] | 13.5 |  | 12 | 30 | 24 | 24 | 24.5
 |  |  | Group | [NAME] |  |  | 9 | 12 | 9 | 12 | 12 | 3
 |  | ICD | 0 | [NAME] | 13.5 |  | 58.5 | 127.5 | 105 | 114 | 105.5 | 9
 |  |  | Group | [NAME] | 13.5 |  | 18 | 42 | 36 | 36 | 39 | 3
 | W2023 | 0 | 0 | 0 | 40 |  |  |  |  | 9 | 13.5 | 12
 | W2023 |  | Group | [NAME] | 15 |  | 6 | 12 | 6 | 12 | 15
 |  |  |  | Alliance Française Vancouver | 35
 |  |  | Individual | [NAME] | 15 |  | 6 | 12 | 6 | 12 | 15
 |  | BCD | 0 | 0 | 64 |  | 13 | 14.5 | 7.5 | 12 | 11.5 | 4.5
 |  | BCD |  | Alliance Française Manitoba | 42 |  | 0 | 15 | 3 | 6 | 12
 |  |  |  | [NAME] | 13.5 |  | 33 | 69 | 57 | 63 | 69 | 12
 |  |  |  | Educacentre | 35 |  | 0 | 12 | 7.5 | 15.5 | 10.5 | 7.5
 |  |  | Group | [NAME] | 13.5 |  | 69 | 138 | 118 | 134 | 137 | 24
 |  |  |  | Educacentre | 64 |  | 14.5 | 3.5
Spreadsheet: 192405d1352397309-need-help-using-and-understanding-if-function-testing
Sheet: Team Change Report (Step 2)

 |  | PROGRESSION JOURNAL |  |  |  |  | REGRESSION JOURNAL |  |  |  |  | PLAYER OF THE WEEK JOURNAL |  |  |  |  | INJURED PLAYERS
WEEK | POS | NAME | OVR |  | WEEK | POS | NAME | OVR |  | WEEK | POS | NAME | OVR |  | WEEK | POS | NAME | OVR
1 | QB | [NAME] |  |  | 1 | RB | [NAME] |  |  | 1 | WR | [NAME] |  |  | 1 | QB | [NAME] | 83
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FB
1
 |  |  |  |  |  |  |  |  |  | CURRENT POINT CAP LIMIT |  |  |  | 1000
 |  |  |  |  |  |  |  |  |  | # OF OFFENSIVE PLAYERS |  |  |  |  | OFFENSE TOTAL
 |  |  |  |  |  |  |  |  |  | # OF DEFENSIVE PLAYERS |  |  |  |  | DEFENSE TOTAL
 |  |  |  |  |  |  |  |  |  | # OF SPEACIAL TEAMS PLAYERS |  |  |  |  | SPC TEAM TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  | TOTAL |  |  |  |  | Points over/under [NAME]
 |  |  |  |  |  |  |  |  |  | ROSTER SPOTS LEFT
Spreadsheet: 878101d1725069212-staff-required-in-relation-to-forecast-takings-formula-staff-working
Sheet: Sheet1

GROSS BAR SALES | DRINKS SOLD AT £5 EACH | SHOW HOURS | DRINKS PER HR SOLD | DUTY MGR | BAR STAFF REQUIRED | TOTAL BAR STAFF COST | TEAM LEADER
 |  |  |  |  |  |  |  |  |  | Staffing | Quantity | [NAME] | Hours
500 |  | 5 |  |  |  |  |  |  |  | Duty Manager | 1 | 18 | 6 | ALWAYS REQUIRED
1000 |  | 5 |  |  |  |  |  |  |  | Team Leader | 1 |  | 6 | REQUIRED WHEN 3 STAFF OR MORE ARE WORKING
1500 |  | 5 |  |  |  |  |  |  |  | Bar Staff | 4 |  | 5 | DEPENDENT ON GROSS SALES FORECAST
2000 |  | 5
2500 |  | 5 |  |  |  |  |  |  |  | [NAME] # drinks each bar staff can handle per hour
3000 |  | 5
3500 |  | 5 |  |  |  |  |  |  |  | Try, =ROUNDUP(D3/$N$7,0)
4000 |  | 5 |  |  |  |  |  |  |  | where N7 is the maximum # drinks each bar staff can handle per hour
4500 |  | 5
5000 |  | 5
5500 |  | 5
6000 |  | 5
6500 |  | 5
7000 |  | 5
7500 |  | 5
8000 |  | 5
8500 |  | 5
9000 |  | 5
9500 |  | 5
10000 |  | 5
10500 |  | 5
11000 |  | 5
11500 |  | 5
12000 |  | 5
12500 |  | 5
13000 |  | 5
13500 |  | 5
14000 |  | 5
Spreadsheet: gstorey__12108__May01
Sheet: Table10

NATURAL GAS EXPORTS BY TERM, REGION, AND CUSTOMER TYPE |  |  |  |  |  |  |  |  |  |  |  | TABLE 10
EXPORTATIONS DE GAZ NATUREL PAR TERME, RÉGION, ET CLIENT
CALENDAR YEAR TO DATE
 |  |  |  | AVERAGE PRICE |  |  |  |  |  | AVERAGE PRICE
 | VOLUME |  |  | PRIX MOYEN |  |  | VOLUME |  |  | PRIX MOYEN
 | (MILLIONS M3) |  |  | ($CDN/GJ) |  |  | (BCF) |  |  | ($US/MMBTU)
 |  |  | % CHANGE |  |  | % CHANGE |  |  | % CHANGE |  |  | % CHANGE
 | 2000-01-01 00:00:00 | 2001-01-01 00:00:00 | VARIATION | 2000-01-01 00:00:00 | 2001-01-01 00:00:00 | VARIATION | 2000-01-01 00:00:00 | 2001-01-01 00:00:00 | VARIATION | 2000-01-01 00:00:00 | 2001-01-01 00:00:00 | VARIATION
 | 2000-05-01 00:00:00 | 2001-05-01 00:00:00 |  | 2000-05-01 00:00:00 | 2001-05-01 00:00:00 |  | 2000-05-01 00:00:00 | 2001-05-01 00:00:00 |  | 2000-05-01 00:00:00 | 2001-05-01 00:00:00
TERM/TERME
LONG-TERM (FIRM)/LONG TERME (GARANTI) | 11879.8 | 9049.1 | -23.8 | 3.7 | 7.88 | 112.9 | 419.4 | 319.4 | -23.8 | 2.71 | 5.52 | 103.7
SHORT-TERM (FIRM)/COURT TERME (GARANTI) | 18089.1 | 21734.2 | 20.2 | 3.51 | 8.92 | 154.1 | 638.6 | 767.2 | 20.2 | 2.57 | 6.25 | 143.3
SHORT-TERM/COURT TERME (INTERRUPTIBLE) | 11057.4 | 14178.3 | 28.2 | 3.67 | 9.69 | 164 | 390.3 | 500.5 | 28.2 | 2.68 | 6.8 | 153.4
TOTAL - TERM/TERME | 41026.4 | 44961.7 | 9.6 | 3.61 | 8.96 | 148.2 | 1448.3 | 1587.2 | 9.6 | 2.64 | 6.28 | 137.8
REGION/RÉGION
CALIFORNIA/CALIFORNIE | 7989.4 | 6646.7 | -16.8 | 3.33 | 10.36 | 211.3 | 282 | 234.6 | -16.8 | 2.44 | 7.26 | 198
MIDWEST/MIDWEST | 15101.1 | 17540.5 | 16.2 | 3.42 | 8.67 | 153.9 | 533.1 | 619.2 | 16.2 | 2.5 | 6.08 | 143.3
MOUNTAIN/ROCHEUSES | 399.7 | 147 | -63.2 | 3.37 | 5.67 | 68.2 | 14.1 | 5.2 | -63.2 | 2.47 | 3.98 | 61.2
NORTHEAST/NORD-EST | 11680.2 | 13252.8 | 13.5 | 4.18 | 8.79 | 110.2 | 412.3 | 467.8 | 13.5 | 3.06 | 6.17 | 101.5
PACIFIC NORTHWEST/NORD-OUEST PACIFIQUE | 5856 | 7374.7 | 25.9 | 3.37 | 8.72 | 159.2 | 206.7 | 260.3 | 25.9 | 2.46 | 6.11 | 148.1
TOTAL - REGION/RÉGION | 41026.4 | 44961.7 | 9.6 | 8.96 | 3.61 | 148.2 | 1448.3 | 1587.2 | 9.6 | 2.64 | 6.28 | 137.8
CUSTOMER TYPE/CLIENT
END-USER/UTILISATEURS ULTIMES | 3295.9 | 3300.1 | 0.1 | 3.92 | 6.66 | 70.2 | 116.3 | 116.5 | 0.1 | 2.87 | 4.66 | 62.5
LDC/SDL | 10964.8 | 8667.9 | -20.9 | 3.7 | 8.69 | 134.6 | 387.1 | 306 | -20.9 | 2.71 | 6.09 | 124.9
MARKETING CO./DISTRIBUTEURS | 25431.7 | 31558.1 | 24.1 | 3.57 | 9.35 | 162.1 | 897.8 | 1114 | 24.1 | 2.61 | 6.56 | 151.2
PIPELINE/PIPELINES | 1333.9 | 1435.5 | 7.6 | 2.83 | 7.01 | 147.6 | 47.1 | 50.7 | 7.6 | 2.07 | 4.89 | 135.7
TOTAL - CUSTOMER TYPE/CLIENT | 41026.4 | 44961.7 | 9.6 | 3.61 | 8.96 | 148.2 | 1448.3 | 1587.2 | 9.6 | 2.64 | 6.28 | 137.8
NOTE: | THE AVERAGE PRICE IS THE WEIGHTED |  |  |  |  |  |  | NOTA: | LE PRIX MOYEN EST LE PRIX MOYEN PONDÉRÉ
 | AVERAGE PRICE AT THE INTERNATIONAL BORDER |  |  |  |  |  |  |  | À LA FRONTIÈRE INTERNATIONALE
Spreadsheet: 115884d1311346907-excel-claim-sorting-claims-sorting-1-
Sheet: Data

Serial | Date | Paid | Oustanding | Total | Title
1 | 2007-02-04 00:00:00 | 500 | 12312 | 12812 | EL
2 | 2007-02-04 00:00:00 | 522 |  | 522 | PL
3 | 2007-02-04 00:00:00 | 12132 |  | 12132 | MD
4 | 2007-02-04 00:00:00 | 6545 |  | 6545 | TH
5 | 2007-02-04 00:00:00 | 554 | 4545 | 5099 | MD | Renewal Date
6 | 2007-02-04 00:00:00 | 545 | 44 | 589 | EL | 2011-02-02 00:00:00
7 | 2007-02-04 00:00:00 | 500 | 454 | 954 | PL
8 | 2007-02-04 00:00:00 | 522 | 5454 | 5976 | EL | I want date sorting for yearwise
9 | 2007-02-04 00:00:00 | 12132 | 5454 | 17586 | PL
10 | 2007-02-04 00:00:00 | 6545 | 54 | 6599 | PL | 2006-02-02 00:00:00 | To | 2007-02-01 00:00:00
11 | 2007-02-04 00:00:00 | 554 | 454 | 1008 | PL | 2007-02-02 00:00:00 | To | 2008-02-01 00:00:00
12 | 2007-02-04 00:00:00 | 545 | 45 | 590 | PL | 2008-02-02 00:00:00 | To | 2009-02-01 00:00:00
13 | 2007-02-04 00:00:00 | 500 | 454 | 954 | EL | 2009-02-02 00:00:00 | To | 2010-02-01 00:00:00
14 | 2007-02-04 00:00:00 | 522 | 45 | 567 | EL | 2010-02-02 00:00:00 | To | 2011-02-01 00:00:00
15 | 2007-02-04 00:00:00 | 12132 | 454 | 12586 | EL
16 | 2007-02-04 00:00:00 | 6545 | 545 | 7090 | EL
17 | 2007-02-04 00:00:00 | 554 | 45 | 599 | MD
18 | 2007-02-04 00:00:00 | 545 | 45 | 590 | MD
19 | 2007-02-04 00:00:00 | 500 | 45 | 545 | MD
20 | 2007-02-04 00:00:00 | 522 | 45 | 567 | MD
21 | 2007-02-04 00:00:00 | 12132 | 45 | 12177 | TH
22 | 2007-02-04 00:00:00 | 6545 | 45 | 6590 | TH
23 | 2007-02-04 00:00:00 | 554 | 45 | 599 | TH
24 | 2007-02-04 00:00:00 | 545 | 45 | 590 | TH
25 | 2007-02-04 00:00:00 | 500 | 45 | 545 | TH
26 | 2007-02-04 00:00:00 | 522 | 4 | 526 | EL
27 | 2007-02-04 00:00:00 | 12132 | 54 | 12186 | EL
28 | 2007-02-04 00:00:00 | 6545 | 5457545 | 5464090 | EL
29 | 2007-02-04 00:00:00 | 554 | 45 | 599 | PL
30 | 2007-02-04 00:00:00 | 545 | 45 | 590 | PL
31 | 2007-02-04 00:00:00 | 545 | 45 | 590 | PL
32 | 2007-02-04 00:00:00 | 121 | 212 | 333 | PL
33 | 2007-02-04 00:00:00 | 212 | 55 | 267 | PL
34 | 2007-02-04 00:00:00 | 55 | 54 | 109 | TH
35 | 2007-02-04 00:00:00 | 4554 | 544 | 5098 | TH
36 | 2007-02-04 00:00:00 | 45 | 545 | 590 | TH
37 | 2007-02-04 00:00:00 | 4545 | 454 | 4999 | EL
38 | 2007-02-04 00:00:00 | 44 | 545 | 589 | EL
39 | 2007-02-04 00:00:00 | 4 | 45 | 49 | MD
40 | 2007-02-04 00:00:00 | 454 | 45 | 499 | MD
41 | 2007-02-04 00:00:00 | 54 | 454421 | 454475 | MD
42 | 2007-02-04 00:00:00 | 54 | 545 | 599 | PL
Spreadsheet: 42225-transactions-over-a-month-broken-down-to-each-product-type-book1-1-
Sheet: Sheet1

 |  |  |  | start date | end date | write task
 |  |  |  | 2009-01-03 00:00:00 | 2009-01-09 00:00:00 | a
 |  |  | a | 2009-01-01 00:00:00 | 1 |  | 4
 |  |  | b | 2009-01-02 00:00:00 | 2
 |  |  | c | 2009-01-03 00:00:00 | 4
 |  |  | a | 2009-01-04 00:00:00 | 2
 |  |  | b | 2009-01-05 00:00:00 | 3
 |  |  | c | 2009-01-06 00:00:00 | 4
 |  |  | a | 2009-01-07 00:00:00 | 2
 |  |  | b | 2009-01-08 00:00:00 | 5
 |  |  | c | 2009-01-09 00:00:00 | 32
 |  |  | b | 2009-01-10 00:00:00
 |  |  | b | 2009-01-11 00:00:00 | 54
 |  |  | c | 2009-01-12 00:00:00 | 3
 |  |  | c | 2009-01-13 00:00:00 | 4
 |  |  | b | 2009-01-14 00:00:00 | 34
 |  |  | a | 2009-01-15 00:00:00 | 5
Spreadsheet: cd4c2b5e-d302-41df-8119-7426a0a500f6
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
261671 | 72657 | Ahmed | Andaloussi | FRA | 2 | 00:16:09 | 00:01:07 | 00:53:34 | 00:02:46 | [NAME] | 1 | 01:25:13
261671 | 72658 | Christophe | Delestre | FRA | 29 | 00:16:26 | 00:02:44 | 01:04:46 | 00:02:50 | 00:10:50 | 2 | [NAME]
261671 | 72684 | Emeric | [NAME] | FRA | 3 | [NAME] | 00:02:58 | 01:20:55 | 00:01:17 | [NAME] | 3 | 02:12:41
Spreadsheet: 809196d1670952693-created-sumifs-formula-but-doesnt-work-when-table-is-sorted-book1
Sheet: Daily Difference

Account | Who's | Yesterdays Total | Todays Total
Asda | Ray | 50
Sainsburys | Gemma | 250
Tesco | Julie | 12.6
M and S | [NAME] | 10
Next | Gemma | 0
Very | Julie | 0
 | Currently there is [NAME] formula in D2:D7. If I sort the table in 'accounts' tab then the formula doesn’t work.
Spreadsheet: 648407d1573037736-scale-on-horizontal-axis-on-a-graph-with-secondary-vertical-axis-toforum
Sheet: Sheet1

emissions per ton constraint | Cost (€/t) | CO2 Emisions (Kg CO2e/t)
237 | 157.3681666666667 | 236.436666666667
250 | 157.3681666666667 | 236.4366666666667
300 | 155.9473333333333 | 298.708333333333
357 | 297.6633333333334 | 356.78
450 | 200.4266666666667 | 450
550 | 149.2 | 550
650 | 97.77916666666667 | 650
776.71 | 32.40583333333333 | 776.71
Spreadsheet: 701656d1603877925-how-to-add-sumifs-formula-to-express-time-value-sumifs-and-counitfs-over-multiple-sheets
Sheet: Sheet4

Parameter A | Parameter B | Parameter C | Parameter D
A | 1 | X | 100
A | 2 | X | 200
A | 1 | Y | 300
A | 2 | Y | 400
A | 1 | Y | 500
B | 2 | X | 600
B | 1 | X | 700
B | 2 | Y | 800
B | 1 | X | 900
B | 2 | X | 1000
B | 1 | X | 1100
B | 2 | X | 1200