tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: c3cfad70-eb3e-4379-be1b-4d3beb92eaf1
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
District Name: |  |  | School:
Student | 1 = Completed required components | Student |  | Retake | Retake | School | Review | Research | Reflection
Unique | with or without accomidations. | Portfolio |  | Interest | Career | and | & Revise | and | Statement
Identifier | 2 = Completed alternate components | Completed |  | Profiler | [NAME] | College | Post | Complete | Completed
 | according to IEP |  |  | and | ment | Choices | Secondary | Job
 | See instructions tab--lower left |  |  | Compare | Compare |  | Plans | Interview
(10 digit #) | (1 or 2) | (Y) | (N) | (Y or N) | (Y or N) | (Y or N) | (Y or N) | (Y or N) | (Y or N)
Spreadsheet: 840218d1692567837-need-excel-formula-to-divide-annual-budget-on-monthly-prorated-basis-sample-data
Sheet: Sheet1

 |  |  |  |  |  |  |  | 2023-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | FY2023
Name | Role | Team | Start Date | End Date | Salary | Funding Type
Adam | VP | R&D | 2020-06-15 00:00:00 |  | 275000 | Budget
Pam | VP | Product | 2021-01-01 00:00:00 | 2023-06-20 00:00:00 | 250000 | Budget
Vipul | VP | Growth | 2023-03-04 00:00:00 | 2023-08-21 00:00:00 | 350000 | Budget
Vipul | VP | Growth | 2023-03-04 00:00:00 |  | 350000 | Budget
Spreadsheet: 329260d1404241043-obtaining-a-average-price-from-vlookup-formula-assembly-evaluation-before
Sheet: Senco

Kit # | SKU | Quantity | Initial Cost | eBay     Price | Amazon Price | Averge Price | Percent | Item Cost | StoneEdge Current
PC1289 | SEN-AMB-PC1289 |  | 70.5 | 100 | 100 |  |  |  | X
 | SEN-CHG-VB0156 | 1 |  | 40 | 59 |  |  |  | X
 | SEN-BAT-VB0155 | 1 |  | 87 | 95 |  |  |  | X
- |  |  | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
Spreadsheet: 803397d1667430682-sum-with-criteria-across-worksheets-formula-help
Sheet: Feb Summary 2023

 | 2023-02-01 00:00:00
 | BOMA | Account Title | Actual | Budget | Budget $ | Budget %
 | 401
 | 1150
 | 1550
 | 1800
 | 1825
 | 1861
 | 1400
 | 1860
 | 1300
 | 1650
 | 3500
 | 5510
 | 406
 | 1900
 | 1700
 | 1705
 | Total
Spreadsheet: 126570d1319747749-excel-2007-grouping-in-pivot-tables-pivotdatatwotables
Sheet: Sheet3

 | Row Labels | Sum of Amt
 | Jan | 1016
 | Feb | 912
 | Mar | 1105
 | Apr | 1245
 | May | 911
 | Jun | 1089
 | Jul | 943
 | Aug | 1029
 | Sep | 834
 | Oct | 1017
 | Nov | 963
 | Dec | 1335
 | Grand Total | 12399
Spreadsheet: 014829b3-f663-4ed1-bd6d-b87988566190
Sheet: Sheet1

Student Club Grant
SAMPLE                                                                    Expenditure Report                                                   SAMPLE
Club: |  |  |  |  | Campus: |  | Sponsor:
Documentation required: Receipts, invoices, Time & Effort Report (if applicable), In-Kind Contribution Form (if applicable)
Expenses Incurred |  |  |  |  |  |  | Cash Match |  |  |  |  | In-Kind Contributions
Date of Expense | Description (Brief) | Amount of Expense | Fund Balance |  | Date of Cash Match | Description (Brief) | Budget Code | Amount of Match | Running Total |  | Date of In Kind | Description (Brief) | Amount of In Kind | Running Total
 | Beginning Balance |  | 5000 |  | 2009-09-09 00:00:00 | Supplies/Office Depot | 167-11-XXXX.XX-XXX-0-XX-0-00 | 348.6 | 348.6 |  | 2009-09-03 00:00:00 | Facility Usage Rm # 211 | 250 | 250
2009-10-02 00:00:00 | Field Trip - UT  [NAME] | 500 | 4500 | 2009-09-18 00:00:00 | 2009-09-09 00:00:00 | Club T Shirts | Club Account #0033 | 540 |  |  | 2009-09-03 00:00:00 | Sponsor Donated Time 1 hr | 23 | 273
2009-10-22 00:00:00 | Light Refreshments - HEB | 50 | 4450 |  | 2009-09-21 00:00:00 | Supplies/Asels Art | 167-11-XXXX.01-XXX-0-XX-0-00 | 699.41 |  |  | 2009-09-17 00:00:00 | Facility Usage Rm #111 | 250 | 523
 |  |  |  |  | 2009-09-21 00:00:00 | Supplies/Asels Art | 167-11-XXXX.01-XXX-0-XX-0-00 | 313.53 |  |  | 2009-09-17 00:00:00 | Sponsor Donated Time 1 hr | 23 | 546
 |  |  |  |  | 2009-09-21 00:00:00 | supplies/SAISD Warehouse | 167-11-XXXX.01-XXX-0-XX-0-00 | 100.44 |  |  | 2009-10-01 00:00:00 | Facility Usage Rm # 103 | 250 | 796
 |  |  |  |  | 2009-09-28 00:00:00 | supplies/SAISD Warehouse | 167-11-XXXX.01-XXX-0-XX-0-00 | 206.64 |  |  | 2009-10-01 00:00:00 | Sponsor Donated Time 1 hr | 23 | 819
 |  |  |  |  |  |  |  |  |  |  | 2009-10-07 00:00:00 | Facility Usage Rm # 211 | 250 | 1069
 |  |  |  |  |  |  |  |  |  |  | 2009-10-07 00:00:00 | Sponsor Donated Time 1 hr | 23 | 1092
 |  |  |  |  |  |  |  |  |  |  | 2009-10-22 00:00:00 | Facility Usage Rm #211 | 250 | 1342
 |  |  |  |  |  |  |  |  |  |  | 2009-10-22 00:00:00 | Guest Speaker - Bank One | 100 | 1442
Please submit at the end of each month to
 | [EMAIL]
Spreadsheet: 00979d51-2fed-470c-8f22-fd55ca36c5fc
Sheet: Sheet2

DIS Academic Programs |  |  |  | DIS Core Courses
Architecture & Design |  | Fine Arts |  | Urban Design Studio |  |  | See Chair for Approvals
Biotechnology & |  | Biology |  | Medical Biotechnology and |  |  | BL 300-level
Biomedicine |  |  |  | Drug Development
Communication & |  | Communication |  | Current Trends in Mass Media |  |  | CM 300-level
Mass Media
European Culture & |  | History |  | Memory & Identity, 1.0 credit |  |  | Elective  (1.0 credit)
History
European Politics & |  | Political Science |  | European Politics: |  |  | PS 300-level
Society |  |  |  | The European Union
International Business & |  | Business |  | European Business Strategy |  |  | IB 282
Economics |  | Business |  | Economic Theories of Globalization |  |  | EC 300-level, GB 300-level
Optional Study Tours:  (1 credit course requirement)
Reading the City: Literary London
 |  |  |  |  |  | Russia: Past and Present
Reading the City: Impressionism in Paris
 |  |  |  |  |  | Turkey at the Crossroads
Greenland: A Scientific Expedition
 |  |  |  |  | Service Learning in East Central Europe
Iceland: Vikings and Sagas
Lines of Inquiry: Mediterranean Journal (Studio Art course)
Classical and Renaissance Rome
Spreadsheet: 889455d1740249431-sum-with-map-sumwithmap
Sheet: Sheet1

 |  |  |  |  |  |  |  | SUM row by row using MAP |  |  |  |  | SCAN row by row
 |  |  | 2 | 3 | 4 |  |  |  | 3 | 6 | 10 |  |  | 3 | 6 | 10
 |  | 5 | 6 | 7 | 8 |  |  | 5 | 11 | 18 | 26 |  |  | 11 | 18 | 26
 |  | 9 | 10 | 11 | 12 |  |  | 9 | 19 | 30 | 42 |  |  | 19 | 30 | 42
 |  | 13 | 14 | 15 | 16 |  |  | 13 | 27 | 42 | 58 |  |  | 27 | 42 | 58
 |  | 17 | 18 | 19 | 20 |  |  | 17 | 35 | 54 | 74 |  |  | 35 | 54 | 74
 |  |  |  |  |  |  |  | restrict index range to actual range
 |  |  |  |  |  |  |  |  | 3 | 6 | 10
 |  |  |  |  |  |  |  | 5 | 11 | 18 | 26
 |  |  |  |  |  |  |  | 9 | 19 | 30 | 42
 |  |  |  |  |  |  |  | 13 | 27 | 42 | 58
 |  |  |  |  |  |  |  | 17 | 35 | 54 | 74
Spreadsheet: 539092d1505956530-adapt-array-formula-to-remove-need-for-helper-row-excelforum
Sheet: Sheet1

2
4
2
3 |  | N: | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
4 |  | Nth lowest distinct value:
5
1
5
2
2
6
4
5
3
9
3
3
9
Spreadsheet: 769418d1645531643-if-and-function-gives-value-error-sample-edited
Sheet: Sheet1

Region | Client type | Ranking
EMEA | B | 4
APAC | A | 7
APAC | A | 7
APAC | A | 10
EMEA | A | 7
EMEA | C | -1
EMEA | A | 9
EMEA | A | 9
EMEA | A | 10
EMEA | A | 8
EMEA | B | 9
EMEA | A | 8
EMEA | B | -1
AMERICAS | A | 10
APAC | D | 10
EMEA | A | 8
EMEA | E | -1
APAC | A | -1
APAC | F | 8
APAC | A | 8
 |  |  |  |  |  |  |  |  |  |  | "A"
 |  |  |  |  |  |  |  |  |  | >8
 |  |  |  |  |  |  |  |  |  | 7, 8
Spreadsheet: jonathan_mckay__17308__enequotes
Sheet: Sheet1

Phone List
Northeast
Company |  | Trader |  | Phone Number
Dynegy |  | [NAME] |  | (713) 767-0332
[NAME] | * | [NAME] |  | (816) 527-1358
J.Aron | * | [NAME] |  | (212) 902-8616
Duke |  | [NAME] |  | (713) 989-0962
AEP | * | [NAME] |  | (614) 324-4503
Mirant |  | Will Hector |  | (678) 579-3192
El Paso | * | [NAME] |  | (713) 420-2294
[NAME] |  | [NAME] |  | (918) 573-3871
Reliant |  | [NAME]
[NAME] |  | [NAME] |  | (713) 961-4563
Southeast
Dynegy
[NAME]
J.Aron
Duke
AEP
Mirant
El Paso |  | [NAME] |  | (713) 420-6711
Sempra |  | [NAME] |  | (203) 355-5053
Spreadsheet: 84506d1284556224-calculate-days-between-2-dates-e-g-how-many-days-in-may-between-15-4-2010-4-6-2010-dateintervals
Sheet: Sheet1

 |  | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00
2010-04-15 00:00:00 | 2010-06-16 00:00:00 | 0 | 0 | 0 | 16 | 31 | 16 | 0 | 0 | 0 | 0 | 0 | 0
2010-04-20 00:00:00 | 2010-06-17 00:00:00 | 0 | 0 | 0 | 11 | 31 | 17 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 797110d1663709853-pull-information-via-data-validation-and-return-value-in-a-2nd-column-based-on-adjacency-adjacent-formula-for-invoice-tracking-v2
Sheet: Invoice tracking

Month of event/invoice | date on invoice | vendor name & # | [NAME] | vendor # | amount
 |  |  |  | formula below that pull in corresponding vendor # without having to use formula to CONCATENATE as in F4 pulling from "reminders tab column C
August | 8.31.22 | ACE 22918 | ACE |  | 143.29
August | 8.29.22 | American 18454 | American |  | 370
August | 9.1.22 | ASDER 14400 | ASDER |  | 7100
Sept | 9.7.22 | Adobe 5564 | Adobe |  | 527.5
Sept | 9.6.22 | American 18454 | American |  | 2550
July | 7.12.22 | ASSOCIATES 22888 | ASSOCIATES, INC. |  | 32.1
June | 6.30.22 | Arcon 27759 | Arcon |  | 8.7
June | 8.3.22 | ACE 22918 | ACE |  | 8.7
 |  | DELETE COLUMN C
Spreadsheet: chris_germany__2331__storage
Sheet: .csv)StorageBalDly(1)

TSP | Storage Contract Holder Id | Storage Contract Holder Name | Rate Schedule | Storage Contract | Beginning Date | Ending Date | Effective Date | Beginning Balance | Injections | Withdrawals | Ending Balance
54748041 | 791182710 | ENRON N A | FSS | 67713 | 20010301 | 20010323 | 20010301 | 979195 | 0 | 49986 | 929209
54748041 | 791182710 | ENRON N A | FSS | 67713 | 20010301 | 20010323 | 20010302 | 929209 | 0 | 61791 | 867418
54748041 | 791182710 | ENRON N A | FSS | 67713 | 20010301 | 20010323 | 20010303 | 867418 | 0 | 69707 | 797711
54748041 | 791182710 | ENRON N A | FSS | 67713 | 20010301 | 20010323 | 20010304 | 797711 | 0 | 64662 | 733049
54748041 | 791182710 | ENRON N A | FSS | 67713 | 20010301 | 20010323 | 20010305 | 733049 | 0 | 72002 | 661047
54748041 | 791182710 | ENRON N A | FSS | 67713 | 20010301 | 20010323 | 20010306 | 661047 | 0 | 60575 | 600472
54748041 | 791182710 | ENRON N A | FSS | 67713 | 20010301 | 20010323 | 20010307 | 600472 | 0 | 32630 | 567842
54748041 | 791182710 | ENRON N A | FSS | 67713 | 20010301 | 20010323 | 20010308 | 567842 | 0 | 35118 | 532724
54748041 | 791182710 | ENRON N A | FSS | 67713 | 20010301 | 20010323 | 20010309 | 532724 | 0 | 34439 | 498285
54748041 | 791182710 | ENRON N A | FSS | 67713 | 20010301 | 20010323 | 20010310 | 498285 | 0 | 21203 | 477082
54748041 | 791182710 | ENRON N A | FSS | 67713 | 20010301 | 20010323 | 20010311 | 477082 | 0 | 24538 | 452544
54748041 | 791182710 | ENRON N A | FSS | 67713 | 20010301 | 20010323 | 20010312 | 452544 | 0 | 1562 | 450982
54748041 | 791182710 | ENRON N A | FSS | 67713 | 20010301 | 20010323 | 20010313 | 450982 | 0 | 17389 | 433593
54748041 | 791182710 | ENRON N A | FSS | 67713 | 20010301 | 20010323 | 20010314 | 433593 | 0 | 22484 | 411109
54748041 | 791182710 | ENRON N A | FSS | 67713 | 20010301 | 20010323 | 20010315 | 411109 | 0 | 6586 | 404523
54748041 | 791182710 | ENRON N A | FSS | 67713 | 20010301 | 20010323 | 20010316 | 404523 | 0 | 29042 | 375481
54748041 | 791182710 | ENRON N A | FSS | 67713 | 20010301 | 20010323 | 20010317 | 375481 | 0 | 49836 | 325645
54748041 | 791182710 | ENRON N A | FSS | 67713 | 20010301 | 20010323 | 20010318 | 325645 | 0 | 40527 | 285118
54748041 | 791182710 | ENRON N A | FSS | 67713 | 20010301 | 20010323 | 20010319 | 285118 | 0 | 19852 | 265266
54748041 | 791182710 | ENRON N A | FSS | 67713 | 20010301 | 20010323 | 20010320 | 265266 | 0 | 12806 | 252460
54748041 | 791182710 | ENRON N A | FSS | 67713 | 20010301 | 20010323 | 20010321 | 252460 | 0 | 19068 | 233392
54748041 | 791182710 | ENRON N A | FSS | 67713 | 20010301 | 20010323 | 20010322 | 233392 | 0 | 16197 | 217195
54748041 | 791182710 | ENRON N A | FSS | 67713 | 20010301 | 20010323 | 20010323 | 217195 | 0 | 14913 | 202282
 | [NAME], looks like your balance on 3/23/2001 is 202282 if I ran the report correctly.\
Spreadsheet: 485861d1477117179-find-trends-in-employee-data-example
Sheet: page 1

Tur | Mandag | Tirsdag | Onsdag | Torsdag | Fredag | Lørdag | Søndag
1 |  |  | 14:17    23:39 | 16:17    22:32 | 22:25     6:17 |  | 19:32     8:55
 | 21:31     7:11 |  |  | 12:20    19:17 | 3:23     10:48
 | 6:28     15:33 | 6:00     15:30 |  |  | 6:17     20:37 | 11:35    19:55 | 11:27    19:39
 | 10:11    15:25 | 9:06     20:38 | 19:12     7:34
 | 7:19     14:25 | 7:31     21:24 | 12:00    21:00 | 8:00     17:00 | 6:28     15:33
 | 14:35     0:05 | 15:00     1:00 | 15:11     6:50 |  | 0:07      6:44
Tur | Mandag | Tirsdag | Onsdag | Torsdag | Fredag | Lørdag | Søndag
2 |  | 6:25     15:49 | 12:20    19:17 | 3:23     10:48 |  | 7:27     14:24 | 7:51     20:37
 | 16:17    22:32 | 12:17    21:48 | 14:35     0:05 | 23:35     8:23
 |  |  | 6:28     15:33 | 7:31     21:24 | 13:25    20:54 | 9:32     22:58 | 15:11     6:50
 |  |  | 9:06     20:38 | 10:11    15:25 | 6:00     15:00
 |  | 22:02     6:58 |  |  | 12:20    19:17 | 6:37     15:33 | 6:02     15:40
 | 13:30    21:27 |  | 7:12     15:39 | 6:00     14:00 | 6:00     14:00
Spreadsheet: 871186d1717590414-countif-with-a-range-an-criteria-declared-in-a-let-statement-countspill
Sheet: Sheet1

 |  |  | ItemList |  | Name | Item |  |  | Helper | result
 |  |  | A |  | [NAME] | A | [NAME]
 |  |  | B |  | [NAME] | B |  | #[NAME]! | C | 0
 |  |  | C |  | [NAME] | C |  | #[NAME]! | D | 1
 |  |  | D |  | [NAME] | D |  | #[NAME]! | E | 1
 |  |  | E |  | [NAME] | D |  | #[NAME]! | F | 1
 |  |  | F |  | [NAME] | D |  | #N/A |  | 1
 |  |  | G |  | [NAME] | A |  | #N/A |  | 0
 |  |  | H |  | [NAME] | E |  | #N/A |  | 0
 |  |  |  |  | [NAME] | E
 |  |  |  |  | [NAME] | A
 |  |  |  |  | [NAME] | F
 |  |  |  |  | [NAME] | D
 |  |  |  |  | [NAME] | F
Spreadsheet: 824702d1680773976-create-table-from-many-tables-at-different-sheets-book2-7-
Sheet: Summary

I want a table here, that combanes the two tables from the two other sheets.
 | unique and sorted
Atenolol | Atenolol
[NAME] | [NAME]
Benzotriazole | Benzotriazole
Bisoprolol | Bisoprolol
Bisphenol A | Bisphenol A
[NAME] | [NAME]
Ciprofloxacin | Ciprofloxacin
Citalopram | Citalopram
Clarithromycin | Clarithromycin
Diclofenac | Diclofenac
Erythromycin | Erythromycin
[NAME] (E2) | [NAME] (E2)
Estrone | Estrone
Etinylestradiol (EE2) | Etinylestradiol (EE2)
Fluconazole | Fluconazole
Furosemide | Fluoxetine
Hydrochlorothiazide | Furosemide
Ibuprofen | Hydrochlorothiazide
Acetamiprid | Ibuprofen
Atenolol
[NAME]
Benzotriazole
Bisoprolol
Bisphenol A
[NAME]
Ciprofloxacin
Citalopram
Clarithromycin
Diclofenac
Erythromycin
[NAME] (E2)
Estrone
Etinylestradiol (EE2)
Fluconazole
Furosemide
Hydrochlorothiazide
Fluoxetine
Spreadsheet: andy_zipper__136__ICE - Mar06 Power & Gas VOL
Sheet: Financial Gas

 |  |  |  |  |  |  | FINANCIAL GAS VOLUME |  |  | TRANSACTIONS
'); } else { document.write(''); } } else { if (navigator.platform == "[NAME]") { document.write(''); } else { document.write(''); } }
Commodity Type:   Financial Gas Swaps/Forwards
Hub:  All
Trade Dates:  Mar-6-01 thru Mar-6-01
 | Description | Strip | Low Price | High Price | Weighted | Last Price | Last Price Date | Volume
 |  |  |  |  | Average Price
 | NG Fin BS, LD1 for GDM
 | NG Fin BS, LD1 for GDM - Mich - Apr01-Oct01 | Apr01-Oct01 | 0.245 | 0.245 | 0.245 | 0.245 | Mar-06-01 14:22 GMT | 1070000 | MMBtus
 | NG Fin Sw Swap, FP for GDD
 | NG Fin Sw Swap, FP for GDD - Henry - Bal Month Gas | Bal Month Gas | 5.255 | 5.27 | 5.263 | 5.27 | Mar-06-01 15:05 GMT | 250000 | MMBtus
 | NG Fin, FP for LD1
 | NG Fin, FP for LD1 - Henry - Apr01 | Apr01 | 5.315 | 5.355 | 5.333 | 5.315 | Mar-06-01 20:02 GMT | 7350000 | MMBtus
 | NG Fin, FP for LD1 - Henry - May01 | May01 | 5.355 | 5.4 | 5.384 | 5.375 | Mar-06-01 21:12 GMT | 1860000 | MMBtus
 | NG Fin, FP for LD1 - Henry - Apr01-Oct01 | Apr01-Oct01 | 5.433 | 5.433 | 5.433 | 5.433 | Mar-06-01 15:35 GMT | 1070000 | MMBtus
 | NG Fin, FP for LD1 - Henry - Apr02-Oct02 | Apr02-Oct02 | 4.685 | 4.685 | 4.685 | 4.685 | Mar-06-01 14:47 GMT | 3210000 | MMBtus
 | NG Fin, FP for LD1 - Henry - Cal 02 | Cal 02 | 4.9 | 4.913 | 4.906 | 4.913 | Mar-06-01 20:06 GMT | 3650000 | MMBtus
Spreadsheet: 81714d1281856423-splitting-a-bank-account-741601_jdavidson100
Sheet: Sheet1

 |  | Balance
 |  | % Alloc | 0.1 | 0.1 | 0.8
Date | Amount | Category | Car Fund | House Fund | General Savings
2010-08-13 00:00:00 | 4000
2010-08-14 00:00:00 | 500 | Car Fund
2010-08-21 00:00:00 | -1500 | Car Fund
Spreadsheet: 218804d1362585279-football-league-table-database
Sheet: Sumário - Tabela 2-3-1-1-1-1-10

Jornada | 21
West Bromwich Albion | 1 | 2 | Fulham
Manchester City | 3 | 0 | Stoke City
Swansea City | 2 | 2 | [NAME]
[NAME] | 3 | 1 | Reading
West Ham United | 2 | 1 | Norwich City
Wigan Athletic | 0 | 4 | [NAME]
Southampton | 1 | 1 | Arsenal
Chelsea | 0 | 1 | Queen Parks Rangers
Liverpool | 3 | 0 | Sunderland
Newcastle United | 1 | 2 | Everton
Spreadsheet: f0e92490-0833-497a-bf88-a0f6f1b5567f
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259424 | 64378 | [NAME] | Loesler | GER | 74 | 00:14:58 | 00:01:07 | 00:34:21 | 00:01:01 | 00:25:13 | 1 | 01:16:38
259424 | 56314 | [NAME] | Devicenzi | ITA | 71 | [NAME] | 00:00:58 | 00:34:36 | [NAME] | 00:35:24 | 2 | 01:27:17
259424 | 73560 | Giovanni | [NAME] | ITA | 75 | 00:18:49 | 00:01:12 | 00:37:23 | 00:00:47 | 00:30:10 | 3 | [NAME]
259424 | 56507 | [NAME] | Solodovnikov | RUS | 72 | [NAME] | 00:01:05 | 00:41:57 | 00:01:25 | 00:40:39 | 4 | 01:42:39
259424 | 55904 | Christian | Troger | AUT | 73 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DQ | 00:00:00
Spreadsheet: cooper_richey__4024__AB Power Fax
Sheet: Peak Load

 |  | GFI Alberta Electricity Desk
 |  | [NAME] [PHONE]
2001-12-04 00:00:00 |  | [EMAIL]
 |  | PEAK | LOAD
 | Maturity | bid $/Mwh | ask $/Mwh
 | BOM
 | 2002-01-02 00:00:00
 | 2002-02-01 00:00:00
 | 2002-03-01 00:00:00
 | Q1 2002
 | Q2 2002
 | Q3 2002
 | Q4 2002
 | Cal 2002
Note:
GFI Brokers Limited ("GFI") has provided this information on the basis that its intended use is for indicative price only.
GFI provides no warranties as to the accuracy of this information.
GFI (and its affiliates) accept no liability whatsoever for any loss that may arise as a result of the provision and use of this information.
Spreadsheet: 106697d1303915293-calculate-comm-based-on-full-collection-within-60days-sample-sales-comm
Sheet: Sheet1

Traget Sales
Mth | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00
Sales Target | 7000 | 7000 | 7000 | 8000 | 8000 | 8000
Sales Summary
Date | Inv | Customer | [NAME] | Sales amt | GST | Inv Amt |  | Collection | Collection | Collection
 |  |  |  |  |  |  |  | Jan | Feb | March
2011-01-01 00:00:00 | INV0001 | AAA | A | 1000 |  |  |  | 1000 | 0 | 0
2011-01-02 00:00:00 | INV0002 | AAB | A | 1500 |  |  |  | 500 | 500 | 500
2011-01-03 00:00:00 | INV0003 | AAC | A | 2000 |  |  |  | 2000 | 0 | 0
2011-01-04 00:00:00 | INV0004 | ABB | B | 2500 |  |  |  | 800 | 1000 | 100
2011-02-05 00:00:00 | INV0005 | ABC | B | 3000 |  |  |  | 0 | 2700 | 300
2011-02-06 00:00:00 | INV0006 | ACC | B | 3500 |  |  |  | 0 | 5000 | 0
2011-02-07 00:00:00 | INV0007 | BBB | C | 4000 |  |  |  | 0 | 4000 | 0
2011-03-08 00:00:00 | INV0008 | BBA | C | 4500 |  |  |  | 0 | 0 | 4000
2011-03-09 00:00:00 | INV0009 | [NAME] | C | 5000 |  |  |  | 0 | 0 | 5000
2011-03-10 00:00:00 | INV0010 | BAB | C | 5500 |  |  |  | 0 |  | 5000
Commission Table
1) Calculate based on full Collection on the Sales amt (exclude the GST)
2) Within 60 days due for the collection
Sales Target  (%) | Comm Rate (%)
80 | 1
90 | 1.5
100 | 2
120 | 3
Spreadsheet: 549581d1511804758-sum-index-match-array-formula-v2
Sheet: MAIN

 |  |  |  |  |  | Aug 2017 |  |  |  |  |  |  |  | Sep 2017
 |  |  |  |  | Key if needed->
 | Category | Group | Brand | Model Number |  | Sales | Sales Change | Text | Text | Text | Text | Sales Volume |  | Sales | Sales Change | Text | Text | Text | Text | Sales Volume
 | PC | Small | Apples |  |  | 13721610 | 0 |  |  |  |  | 2433 |  | 245652 | 0 |  |  |  |  | 2433
 | PC | Small | Oranges |  |  | 4831505 | 0 |  |  |  |  | 1345 |  | 245 | 0 |  |  |  |  | 2452
 | PC | Small | Peach |  |  | 15470910 | 49140 |  |  |  |  | 13451 |  | 2527455 | 49140 |  |  |  |  | 13451
 | PC | Small | [NAME] |  |  | 31847970.7 | 0 |  |  |  |  | 145 |  | 2345645 | 0 |  |  |  |  | 245
 | Category | Group | Brand | Model Number |  | Sales | Sales Change | Text | Text | Text | Text | Sales Volume |  | Sales | Sales Change | Text | Text | Text | Text | Sales Volume
 | PC | Small | Apples |  |  | 13721610 | 0 |  |  |  |  | 2433 |  | 13721610 | 52567 |  |  |  |  | 2433
 | PC | Small | Oranges |  |  | 4831505 | 0 |  |  |  |  | 1345 |  | 2435526 | 0 |  |  |  |  | 1345
 | PC | Small | Peach |  |  | 15470910 | 49140 |  |  |  |  | 13451 |  | 15470910 | 49140 |  |  |  |  | 24
 | PC | Small | [NAME] |  |  | 31847970.7 | 0 |  |  |  |  | 145 |  | 2524 | 0 |  |  |  |  | 145
 | Category | Group | Brand | Model Number |  | Sales | Sales Change | Text | Text | Text | Text | Sales Volume |  | Sales | Sales Change | Text | Text | Text | Text | Sales Volume
 | GN | Small | Apples |  |  | 13721610 | 0 |  |  |  |  | 2433 |  | 13721610 | 0 |  |  |  |  | 2742
 | GN | Small | Oranges |  |  | 4831505 | 0 |  |  |  |  | 1345 |  | 4831505 | 74784 |  |  |  |  | 1345
 | GN | Small | Peach |  |  | 15470910 | 49140 |  |  |  |  | 13451 |  | 243524 | 49140 |  |  |  |  | 13451
 | GN | Small | [NAME] |  |  | 31847970.7 | 0 |  |  |  |  | 145 |  | 47525 | 0 |  |  |  |  | 27
 | Category | Group | Brand | Model Number |  | Sales | Sales Change | Text | Text | Text | Text | Sales Volume |  | Sales | Sales Change | Text | Text | Text | Text | Sales Volume
 | PC | Med | Apples |  |  | 13721610 | 0 |  |  |  |  | 2433 |  | 13721610 | 2497478 |  |  |  |  | 2433
 | PC | Med | Oranges |  |  | 4831505 | 0 |  |  |  |  | 1345 |  | 25626 | 0 |  |  |  |  | 5727
 | PC | Med | Peach |  |  | 15470910 | 49140 |  |  |  |  | 13451 |  | 2565 | 25662127 |  |  |  |  | 13451
 | PC | Med | [NAME] |  |  | 31847970.7 | 0 |  |  |  |  | 145 |  | 22656 | 0 |  |  |  |  | 145