tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 298033d1392674698-conditional-formatting-based-on-value-in-another-column-demo
Sheet: Fleet Volume-PC

Print Volumes
 |  |  |  | Equipment Information |  |  |  | Quarterly Averages |  |  |  | Current Year Total Print Volumes |  |  |  |  |  |  |  |  |  |  |  | YTD Volumes
 | Building | Department | Status | Location | Model | Serial Number | Volume in Base | Q1 AVG | Q2 AVG | [NAME] | Q4 AVG | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sept | YTD Avg Volume | YTD Total Volume
1 | A | B | C | D | E | F | 2000 |  |  |  |  | 1136 | 625 | 968 | 751
2 | A | B | C | D | E | F | 5000 |  |  |  |  | 12247 | 7590 | 17559 | 10604
3 | A | B | C | D | E | F | 15000 |  |  |  |  | 12124 | 8704 | 16630 | 9149
4 | A | B | C | D | E | F | 5000 |  |  |  |  | 8727 | 9297 | 14870 | 12689
5 | A | B | C | D | E | F | 5000 |  |  |  |  | 9661 | 5949 | 9815 | 7738
6 | A | B | C | D | E | F | 2700 |  |  |  |  | 3113 | 1521 | 3129 | 2763
7 | A | B | C | D | E | F | 3500 |  |  |  |  | 7289 | 5994 | 9768 | 3793
8 | A | B | C | D | E | F | 8400 |  |  |  |  | 3553 | 3083 | 6600 | 3999
9 | A | B | C | D | E | F |  |  |  |  |  | 0 | 0 | 0 | 0
10 | A | B | C | D | E | F | 3000 |  |  |  |  | 4769 | 2493 | 4599 | 4782
11 | A | B | C | D | E | F | 20000 |  |  |  |  | 0 | 0 | 0 | 0
Spreadsheet: 840945d1693221451-use-lookup-function-to-total-all-cells-that-contain-text-mock1
Sheet: lookup

 | category1 | [NAME] company
 | category2 | [NAME]
 | category2 | overseas central public orgainisation
 | category1 | overseas company(non-european)
 | category2 | overseas other
 | Category2 | central public organisation
 | Category1 | central public organisation, uk company, buying, purchasing company
 | Category2 | uk charity
 | Category2 | uk Educational Institution
 | Category1 | Health and Hospital Authority
 | Category2 | Health and Hospital Authority,buying,purchasing company, uk company
 | Category1 | UK company, buying, purchasing company
 | Category1 | UK company,buying,purchasing company,overseas company (non-european)
 | Category2 | uk company,buying,purchasing company,central public organisation
 | Category2 | uk company,buying,purchasing company,uk charity
 | Category2 | uk other
 | Category2 | research council
 | Category2 | unknown company
Spreadsheet: 287630d1388909322-new-here-and-need-help-with-auto-populating-cells-call-log
Sheet: crew

[NAME], N.
Anjum, M.
Bayer, K.
Castiglia, J.
Cha, R.
[NAME], J.
[NAME], V.
Daloio, A.
[NAME], C.
[NAME], K.
Grazioli, A.
Kaziu, H.
Krug, N.
Markinson, P.
McDonald, K.
McLaughlin, K.
[NAME], K.
Niepla, A.
Novak, K.
Pratts, S.
[NAME], [NAME]
Rodriguez, T.
[NAME], [NAME].
[NAME], [NAME].
Sanzone, M.
Shah, A.
Sil, M.
Stefanelli, F.
Stefans, A.
Stone, J.
Toro, E.
Ziemba, H.
Spreadsheet: 702743d1604508442-copy-different-and-changing-length-lists-from-multiple-sheets-dept-summary-for-questions
Sheet: DEPT HEAD

TYPE 1
TYPE 2
TYPE 3
TYPE 4
TOTAL
TYPE 2
LAST NAME | FIRST NAME | DIVISION | START | STOP
TYPE 3
LAST NAME | FIRST NAME | DIVISION | START | STOP
Spreadsheet: 123129d1317365418-when-using-match-function-can-your-lookup-array-be-multiple-rows-and-columns-help
Sheet: Raw Data

Mgr | IPT | AC | BCWS | BCWP | ACWP | CPI | SPI | [NAME] | SV
[NAME] | os | 11AW | 21 | hello | 23 | 24 | 25 | 26 | 27
[NAME] | int | 11BT | 31 | 32 | 33 | 34 | 35 | 36 | 37
[NAME] | sw | 11PI | 41 | 42 | 43 | 44 | 45 | 46 | 47
[NAME] | acc | 11KL | 51 | 52 | 53 | 54 | 55 | 56 | 57
pat | sw | 11MN | 61 | 62 | 63 | 64 | 65 | 66 | 67
[NAME] | sw | 11TR | 71 | 72 | 73 | 74 | 75 | 76 | 77
Spreadsheet: 124293d1318307928-min-and-max-value-of-data-form-date-to-date-minmaxindirect
Sheet: Sheet1

 |  | 2011-01-01 00:00:00 | 2011-01-02 00:00:00 | 2011-01-03 00:00:00 | 2011-01-04 00:00:00 | 2011-01-05 00:00:00 | 2011-01-06 00:00:00 | 2011-01-07 00:00:00 | 2011-01-08 00:00:00 | 2011-01-09 00:00:00 | 2011-01-10 00:00:00 | 2011-01-11 00:00:00 | 2011-01-12 00:00:00
from | to | 6 | 8 | 2 | 8 | 9 | 5 | 2 | 7 | 4 | 1 | 6 | 8
2011-01-04 00:00:00 | 2011-01-09 00:00:00
min
2 | <<See this formula | 4
mix
9 | <<See this formula
Date | Value
2011-01-01 00:00:00 | 6 | << It is easier with your data transposed like this
2011-01-02 00:00:00 | 8
2011-01-03 00:00:00 | 2
2011-01-04 00:00:00 | 8
2011-01-05 00:00:00 | 9
2011-01-06 00:00:00 | 5
2011-01-07 00:00:00 | 2
2011-01-08 00:00:00 | 7
2011-01-09 00:00:00 | 4
2011-01-10 00:00:00 | 1
2011-01-11 00:00:00 | 6
2011-01-12 00:00:00 | 8
Spreadsheet: 272137d1382221848-search-for-a-value-or-somthing-immediately-lesser-and-return-its-sl-no-small-last-nearest
Sheet: Sheet1

Sl No. | Value | helper 1 | helper 2 | Search Value | Sl No.
1 | 23134 |  |  | 25160
2 | 25156
3 | 24999
4 | 25159
5 | 22132
6 | 22789
7 | 25159
8 | 26789
9 | 22132
10 | 24555
Spreadsheet: 142386d1329818661-excel-2007-sum-of-hours-converted-into-days-hours-into-days
Sheet: Sheet1

Machine No | Total
1 | 27 days, 1:30:00
2 | 16 days, 8:25:00
3 | 15 days, 18:41:00
4 | 11 days, 1:24:00
5 | 11 days, 0:37:00
6 | 10 days, 15:40:00
7 | 10 days, 6:57:00
8 | 9 days, 20:26:00
9 | 9 days, 9:51:00
Spreadsheet: stacey_white__39105__termination dates
Sheet: 11-28

Deal ID | Leg | Portfolio | Counterparty | Nature | Deal End Date | Bankrupt Deal #
343350.1 | 1 | EAST | FP&L | P | 2001-12-31 00:00:00 | 884503
347149.1 | 1 | EAST | FP&L | P | 2001-12-31 00:00:00 | 884504
360720.1 | 1 | EAST | FP&L | P | 2001-12-31 00:00:00 | 884505
361092.1 | 1 | EAST | FP&L | P | 2001-12-31 00:00:00 | 884506
411783.1 | 1 | EAST | FP&L | P | 2001-12-31 00:00:00 | 884507
424701.1 | 1 | EAST | FP&L | P | 2001-12-31 00:00:00 | 884508
442383.1 | 1 | EAST | FP&L | P | 2001-12-31 00:00:00 | 884509
470663.1 | 1 | EAST | FP&L | P | 2001-12-31 00:00:00 | 884510
470663.2 | 2 | EAST | FP&L | P | 2001-12-31 00:00:00 | 884511
479381.1 | 1 | EAST | FP&L | P | 2001-12-31 00:00:00 | 884512
479423.1 | 1 | EAST | FP&L | P | 2001-12-31 00:00:00 | 884513
524395.1 | 1 | EAST | FP&L | P | 2001-12-31 00:00:00 | 884514
732911.1 | 1 | EAST | FP&L | P | 2001-12-31 00:00:00 | 884515
733918.1 | 1 | EAST | FP&L | P | 2001-12-31 00:00:00 | 884516
817667.1 | 1 | EAST | OPPD | P | 2001-12-05 00:00:00 | 817667
650236.1 | 1 | WEST | SNO | P | 2001-12-31 00:00:00 | 650236.1
793854.1 | 1 | WEST | FP&L | P | 2001-12-31 00:00:00
882046.1 | 1 | WEST | SNO | P | 2001-12-31 00:00:00
882047.1 | 1 | WEST | SNO | P | 2001-12-31 00:00:00
410767.1 | 1 | EAST | MIRANT | F | 2001-12-31 00:00:00 | 884517
585226.1 | 1 | EAST | MIRANT | F | 2001-12-31 00:00:00 | 884518
613192.1 | 1 | EAST | MIRANT | F | 2001-12-31 00:00:00 | 884519
667401.1 | 1 | EAST | MIRANT | F | 2001-12-31 00:00:00 | 884520
671233.1 | 1 | EAST | MIRANT | F | 2001-12-31 00:00:00 | 884521
671327.1 | 1 | EAST | MIRANT | F | 2001-12-31 00:00:00 | 884522
691786.1 | 1 | EAST | MIRANT | F | 2001-12-31 00:00:00 | 884523
695584.1 | 1 | EAST | MIRANT | F | 2001-12-31 00:00:00 | 884524
703665.1 | 1 | EAST | MIRANT | F | 2001-12-31 00:00:00 | 884525
770513.1 | 1 | EAST | MIRANT | F | 2001-12-31 00:00:00 | 884526
775101.1 | 1 | EAST | MIRANT | F | 2001-12-31 00:00:00 | 884527
376563.1 | 1 | EAST | MIRANT | F | 2001-12-31 00:00:00 | 884528
379112.1 | 1 | EAST | MIRANT | F | 2001-12-31 00:00:00 | 884529
473128.1 | 1 | EAST | MIRANT | F | 2001-12-31 00:00:00 | 884530
474456.1 | 1 | EAST | MIRANT | F | 2001-12-31 00:00:00 | 884531
554083.1 | 1 | EAST | MIRANT | F | 2001-12-31 00:00:00 | 884532
714791.1 | 1 | EAST | MIRANT | F | 2001-12-31 00:00:00 | 884533
730235.1 | 1 | EAST | MIRANT | F | 2001-12-31 00:00:00 | 884534
735300.1 | 1 | EAST | MIRANT | F | 2001-12-31 00:00:00 | 884535
755070.1 | 1 | EAST | MIRANT | F | 2001-12-31 00:00:00 | 884536
809356.1 | 1 | EAST | MIRANT | F | 2001-12-31 00:00:00
834838.1 | 1 | EAST | MIRANT | F | 2001-12-31 00:00:00
841056.1 | 1 | EAST | MIRANT | F | 2001-12-31 00:00:00
841358.1 | 1 | EAST | MIRANT | F | 2001-12-31 00:00:00
841684.1 | 1 | EAST | MIRANT | F | 2001-12-31 00:00:00
844388.1 | 1 | EAST | MIRANT | F | 2001-12-31 00:00:00
Spreadsheet: 767157d1644317937-how-to-group-existing-values-in-numerous-cells-to-one-cell-example-grouping-
Sheet: Sheet1

Id | Items |  | Id | items
10001 | Laptop |  | 10001
10001 | Keyboard
10001 | [NAME]
10001 | Stapler
10002 | [NAME]
10002 | Laptop
10002 | Keyboard |  |  | Row Labels | ItemList
10002 | Stapler |  |  | 10001 | Laptop, [NAME], Mouse, Stapler
10002 | Calendar |  |  | 10002 | Laptop, [NAME], Mouse, [NAME], [NAME], Diary
10002 | Diary |  |  | 10003 | Laptop, [NAME], Mouse, Stapler, Diary, Charger, Usb cable
10003 | Diary |  |  | Grand Total | Laptop, [NAME], Mouse, [NAME], [NAME], Diary, Charger, Usb cable
10003 | Stapler
10003 | Keyboard
10003 | Charger
10003 | Laptop
10003 | [NAME]
10003 | Usb cable
Spreadsheet: 168959d1342640118-index-and-match-formula-index-and-match-calculation
Sheet: Tab B

 |  | Indicates Colleagues Offered Roles to Other Divisions
 |  | Indicates Resignations
Division | Heritage File Number | Function | CoE Transfers | First Name | Last Name | Full Name | FTE | VR Yes / No | Current Grade | Colleague Scope Area | Is Interested In Vr | Current Job Title | Work City | Work Building | Current Line Manager Name | Number of Preferences | Selected Job | Selected Division | First Preference Job Number | First Preference Job Grade | First Preference Job Title | First Preference Job BU | Second Preference Job Number | Second Preference Job Grade | Second Preference Job Title | Second Preference Job BU | Third Preference Job Number | Third Preference Job Grade | Third Preference Job Title | Third Preference Job BU | Other Selections | Choose From Drop Down 1st Preference | Choose From Drop Down 2nd Preference | Choose From Drop Down 3rd Preference | Choose From Drop Down Other Selection | Outstanding | Resigned / Leaver / Transfer | [NAME] Yes / No | Choose From Drop Down Reason For Non-Preference | Comments / Notes
Group Finance/CoE |  |  |  | [NAME] | [NAME] |  | 1 |  |  |  |  |  |  |  |  |  | GFO007918 | Group Operations
Group Finance/CoE |  |  |  | [NAME] | Smith |  | 1 |  |  |  |  |  |  |  |  |  | GFO008296 | Group Finance
Group Finance/CoE |  |  |  | [NAME] | [NAME] |  | 1 |  |  |  |  |  |  |  |  |  | GFO008358 | Retail
Group Finance/CoE |  |  |  | [NAME] | [NAME] |  | 1 |  |  |  |  |  |  |  |  |  | [NAME] | Group Operations
Spreadsheet: 785581d1656502281-create-a-list-of-words-based-on-conditional-rule-oak-2122-56-termly-cew-analysis-sheet-updated
Sheet: Class Analysis

Class Average |  |  | Summer 2 Misspelled Word List
Term | Score
Autumn 1 2021 |  |  |  | Autumn 1 Misspelled Word List
Autumn 2 2021 |  |  |  | Autumn 2 Misspelled Word List
Spring 1 2022 |  |  |  | Spring 1 Misspelled Word List
Spring 2 2022 |  |  |  | Spring 2 Misspelled Word List
Summer 1 2022 |  |  |  | Summer 1 Misspelled Word List
Summer 2 2022 |  |  |  | Summer 2 Misspelled Word List
Autumn 1 Misspelled Word List
Autumn 2 Misspelled Word List
Spring 1 Misspelled Word List
Spring 2 Misspelled Word List
Summer 1 Misspelled Word List
Summer 2 Misspelled Word List
Spreadsheet: andy_zipper__110__Brazil Invoice
Sheet: InvNEPCO

 | ENRON ENGINEERING & CONSTRUCTION
 | 333 Clay Street,  Ste 400
 | Houston ,  Texas  77002
 | INVOICE
 | To: |  |  |  | Please  Remit  To:
 | ENRON  CAPITAL & TRADE RESOURCES |  |  |  | Nations  Bank  - Dallas
 | 121 S.W. Salmon Street |  |  |  | A/C  #  [PHONE]
 | 3WTC 0306 |  |  |  | ABA  #  111 000 012
 | Portland, OR 97204 |  |  |  | Co#082
 | Attn:  [NAME] |  |  |  | For  questions , please  contact:
 |  |  |  |  | [NAME]
 |  |  |  |  | (713)  646-6595
 | Invoice | Invoice |  |  |  | Payment
 | Date | Number |  |  |  | Due  Date
 | 1998-12-10 00:00:00 | S8P704-NEPCO |  |  |  | DUE UPON RECEIPT
 | To invoice for NEPCO's costs incurred in rendering support to the
 | New Albany Power project for October and November 1998.
 | Work Order #: | S8P704
 | Project Name: | New Albany Power Plant
 | Project Mngr: | [NAME]
 |  |  | Total  Amount  Due
Spreadsheet: 101140d1299266726-chart-that-measures-amount-of-swimming-lengths-weight-and-date-anagoge-swimming-log
Sheet: Sheet1

Date | Weight | Stone | Pounds | Laps
2011-01-01 00:00:00 | 178
 | 182
 | 182 |  |  | 15
 | 177 |  |  | 22
 | 183 |  |  | 22
 | 183
 | 177
 | 178 |  |  | 20
 | 179 |  |  | 17
 | 180 |  |  | 20
 | 178 |  |  | 15
 | 182 |  |  | 19
 | 177 |  |  | 16
 | 179
 | 177
 | 183 |  |  | 20
 | 183 |  |  | 25
 | 181 |  |  | 22
 | 183 |  |  | 21
 | 180 |  |  | 25
 | 183 |  |  | 15
 | 180 |  |  | 16
 | 178 |  |  | 19
 | 180 |  |  | 23
 | 178 |  |  | 24
 | 179
 | 180
 | 178 |  |  | 18
 | 182 |  |  | 16
 | 177 |  |  | 24
 | 179 |  |  | 21
 | 177 |  |  | 19
 | 183 |  |  | 18
 | 183
 | 181 |  |  | 15
 | 183
 | 180
 | 183 |  |  | 25
 | 180
 | 178
 | 180 |  |  | 25
 | 183
Spreadsheet: 137907d1327427931-how-to-find-the-smaller-number-in-the-list-smallest
Sheet: Sheet1

S.No | Name | Scores
1 | a | 10
2 | b | 20
3 | c | NA
4 | d | 5
5 | e | 6
6 | f | 9
Spreadsheet: 94268d1294135292-automatic-number-and-date-sorting-formula-number_n_category_answer_done-sorting-output-donkeyv2
Sheet: Alt

BA Number | Filtered | First Invoice |  | Invoice Date | Invoice Number | Invoice Amount | BA First Invoice Date | BA Total Amount | BA Total Rounddown Amount | BA Due Date | Days Left
801102 | BA Number |  |  | 2010-11-10 00:00:00 | INV20918 | 5000
801102 | 801102 |  |  | 2010-11-13 00:00:00 | INV20919 | 6390
801102 | 801103 |  |  | 2010-11-12 00:00:00 | INV20920 | 8432
801102 | 801104 |  |  | 2010-11-13 00:00:00 | INV20921 | 7582
801102 |  |  |  | 2010-11-09 00:00:00 | INV20922 | 8450
801102 |  |  |  | 2010-11-15 00:00:00 | INV20923 | 31242
801103 |  |  |  | 2010-11-12 00:00:00 | INV20924 | 3912
801103 |  |  |  | 2010-11-06 00:00:00 | INV20925 | 734
801103 |  |  |  | 2010-11-09 00:00:00 | INV20926 | 450
801103 |  |  |  | 2010-11-15 00:00:00 | INV20927 | 12
801104 |  |  |  | 2010-11-15 00:00:00 | INV20927 | 1699
Spreadsheet: 167347d1341955697-excel-2007-calculating-sick-hours-out-of-a-forty-hour-work-week-employees-sick-hrs-nicks-version
Sheet: 2008

Employees Sick Hours for the year 2008
Name | Allowed Hrs | Date | Used Hrs | Remaining Hrs
Arielle | 40
Fellicia | 40 | 14-18 Jan | 38.35 mins | 1 hr 25 mins
[NAME] | 40 | 2008-02-26 00:00:00 | 5 hrs 20 mins | 34 hrs 40 mins
 |  | 2008-02-27 00:00:00 | 8
 |  | 2008-02-28 00:00:00 | 8
 |  | 2008-02-29 00:00:00 | 8 | 10.4
[NAME] | 40 | 2008-01-31 00:00:00 | 8 | 32
 |  | 2008-06-26 00:00:00 | 8 | 24
[NAME] | 40 | 2008-03-03 00:00:00 | 8 | 32
 |  | 2008-03-10 00:00:00 | 4 | 28
 |  | 2008-05-07 00:00:00 | 8 | 20
 |  | 2008-06-21 00:00:00 | 8 | 12
 |  |  | 8 | 8
 |  |  |  | 0
[NAME] | 40 | 2008-01-08 00:00:00 | 8 | 32
 |  | 2008-05-28 00:00:00 | 8 | 24
 |  | 2008-05-29 00:00:00 | 8 | 16
Avi | 40
Mira | 40
[NAME] | 40 | 2008-02-14 00:00:00 | 5 | 35
 |  | 2008-07-11 00:00:00 | 8 | 27
 |  | 2008-12-02 00:00:00 | 8 | 19
 |  | 2008-12-02 00:00:00 | 8 | 11
Nicol | 40 | 2008-01-04 00:00:00 | 8 | 32
 |  | 2008-01-07 00:00:00 | 8 | 24
 |  | 2008-02-06 00:00:00 | 8 | 16
 |  | 2008-03-03 00:00:00 | 8 | 8
 |  | 2008-03-27 00:00:00 | 8 | 0
Kristen | 40 | 2008-02-08 00:00:00 | 8 | 32
 |  | 2008-03-03 00:00:00 | 8 | 24
 |  | 2008-03-28 00:00:00 | 8 | 16
 |  | 2008-11-20 00:00:00 | 8 | 8
 |  | 2008-12-04 00:00:00 | 8 | 0
[NAME] | 40 | 2008-01-02 00:00:00 | 8 | 32
 |  | 2008-01-03 00:00:00 | 8 | 24
 |  | 2008-01-04 00:00:00 | 8 | 16
 |  | 2008-02-20 00:00:00 | 8 | 8
 |  | 2008-04-17 00:00:00 | 8 | 0
[NAME] | 24 | 2008-10-06 00:00:00 | 8 | 16
 |  | Oct | 8 | 8
[NAME] | 24 | 2008-10-06 00:00:00 | 8 | 16
 |  | 2008-10-21 00:00:00 | 8 | 8
 |  | 2008-10-22 00:00:00 | 8 | 0
Felix | 24 | 2008-12-09 00:00:00 | 8 | 16
Spreadsheet: 221721d1363647244-separating-name-and-address-phone-number-with-odd-delimiter-left-right-dashes2
Sheet: Sheet1

American Communications Services Of Louisville
462 S 4th Av ----------------------------------------------------- 589-0893
American Communications Services Of Louisville
462 S 4th Av ----------------------------------------------------- 589-1044
Arrow Electric 317 Wabasso Av Louisville ----------------------- 367-0141
D & J Cable Contractors Inc 3099 Element Ln Lsvl ------------ 614-4137
Ecomtek Telecom 4169 Westport Rd Lsvl ------------------------326-5739
Fishel Technologies 4508 Bishop Ln ---------------------------- 456-9444
Granite telecommunications 4675 Outer Loop Louisville ------- 969-3523
Impact Office Products Inc 1305 [NAME] --------------- 366-6988
Independent Telephone 4525 Poplar Level Rd Lsvl -------------409-7191
Nationwide Telecom 2400 Ash Ave [NAME]
OR Communications Louisville ---------------------------------- 966-9292
Telecompute Louisville -------------------------------------------540-5577
Spreadsheet: michelle_lokay__26795__sharris0600wk4
Sheet: Actuals V. Plan

Transwestern Pipeline Company
($[NAME])
 |  | June, 2000
 |  | Plan | Estmate | [NAME] |  | Comments
West Demand Revenues |  | 9.53 |  |  |  | Lower actual demand rates than in plan
West Commodity Revenues |  | 0.723 | 0.76 |  |  | 983/day vs. 972/day in plan. Includes bringing west down to 860/day 6-29 and 6-30
East Demand Revenues |  | 1.089 | 1.032 |  |  | Burlington 24216--($53k)
East Commodity Revenues |  | 0.166 | 0.171
[NAME] |  | 0.644 | 0.627
[NAME] Revenues |  | 0.0594 | 0.21 |  |  | 100/d IT Ignacio to Blanco vs. 0/day in plan
 |  | ------------- | ------------- | -------------
Revenue Variance
[NAME] due to Price |  |  |  | 0.63601 |  | Index price $4.09
[NAME] due to transport volumes |  |  |  | -0.1526 |  | Higher fuel usage--30/day vs. 25/day in plan.
Hedging Adjustment |  |  |  | -0.0045
Unaccounted for Variance |  |  |  | 0.547 |  | Positive UAF
 |  |  |  | -------------
Fuel Variance
 |  |  |  | -------------
TOTAL MONTH-TO-DATE VARIANCE
 |  |  |  | ========
[NAME]:
 |  | Year-to-Date | Year-to-Date | Year-to-Date
 |  | Margin | Fuel & UAF | Total
Plan (throughJune)
Actuals through May, June est.
 |  | ------------- | ------------- | -------------
Variance from Plan
 |  | ------------- | ------------- | -------------
Spreadsheet: 719159d1613529919-match-search-and-return-donation-tracker
Sheet: Tracker

 |  |  |  |  |  | 2021
 | EXPENDABLES MC PHX DONATION TRACKER
 | ID | RECEIPT | DATE | TYPE | SOURCE | VALUE | F M V | DISTRIBUTED | LOCATION OF DISTRIBUTION | [NAME] OF DONATION
 | 21-01 | YES | 2021-02-11 00:00:00 | PRODUCT | Black Rifle Coffee |  |  | NO | N/A | coffee, tumblers, blankets, hats
 | 21-02 | YES | 2021-02-15 00:00:00 | PRODUCT | Fire dept. Coffee |  |  | NO | N/A | $5 E-Gift Cards
Spreadsheet: 827020d1682435958-vlookup-multiple-criteria-different-sheet-sample-document
Sheet: Cost Prices

Channel | Product Name | Our SKU | Selling Price (Inc. VAT) | Net | Shipment Cost to customer | Shipping Net | Fee | Fee | Approx Cost of Unit | Packaging Costs | Shipment Cost to [NAME] | Cost of Shipping to Customer | Label Cost | Total Costs | Proft | Profit %
ECOMM2 | Sample Product 3 | SAMPLE3 | 384 | 320 | 0 | 0 | 0 | 0 | 155 | 0 | 2 | 6 | 0
ECOMM2 | Sample Product 4 | SAMPLE4 | 178 | 148.33 | 0 | 0 | 0 | 5 | 77 | 0.3 | 8 | 13.5 | 0
ECOMM2 | Sample Product 1 | SAMPLE1 | 22 | 18.33 | 0 | 0 | 0 | 1 | 4 | 0.3 | 1 | 10 | 0
ECOMM1 | Sample Product 3 | SAMPLE3 | 450 | 375 | 20 | 16.67 | 0 | 0 | 155 | 0 | 2 | 10 | 0
ECOMM1 | Sample Product 4 | SAMPLE4 | 165 | 137.5 | 20 | 16.67 | 0 | 0 | 77 | 0.3 | 8 | 13.5 | 0
ECOMM1 | Sample Product 1 | SAMPLE1 | 21.6 | 18 | 9 | 7.5 | 0 | 0 | 4 | 0.3 | 1 | 10 | 0
ECOMM3 | Sample Product 2 | SAMPLE2 | 33 | 27.5 | 0 | 0 | 0 | 4 | 8 | 0.84 | 0.5 | 5 | 0
ECOMM3 | Sample Product 1 | SAMPLE4 | 203 | 169.17 | 0 | 0 | 0 | 31 | 77 | 0.3 | 8 | 13.5 | 0
ECOMM3 | Sample Product 1 | SAMPLE1 | 18 | 15 | 0 | 0 | 0 | 3 | 4 | 0.3 | 1 | 10 | 0
Spreadsheet: daren_farmer__6368__Prebid Info
Sheet: Sheet1

 | Supply |  |  | Market | Net |  | Comments
 | [NAME] | Other
BDOL | 0 | 208 |  | 208 |  |  | Spinnaker sale to Dow
CCNG | 0 | 1032 |  | 1032 |  |  | [NAME] to CCNG
CSGT | 0 | 1233 |  | 1233 |  |  | Spinnaker sale to Dow
DEFS | 0 | 155 |  | 155 |  |  | Rep Royalty sale to [NAME] (Last month)
ETXG | 78732 | 3054 |  |  |  |  | 13500 Sale to TXU Lonestar Expired 2/00
 |  |  |  |  |  |  | 3500 makeup is inclusive of supply vol
GEMC | 13264 | 1159 |  |  |  |  | Waiting on Co-owner vols
GPPP | 12085 |  |  |  |  |  | [NAME] Pdn to HPL / Tenn Zn 0
KMID | 1597 | 131 |  | 1728 |  |  | [NAME] sale to Delhi
LONE | 4446 | 673 |  | 5119 |  |  | [NAME] sale to TXU Energy
MTPC | 2213 |  |  | 2213 |  |  | [NAME] sale to MTPL
TOMC | 2027 |  |  | 0 |  |  | Kerr McGee to HPL
Spreadsheet: 869434d1716000998-formula-to-find-vlookup-or-hlookup-for-values-report-formula
Sheet: AFTER End (3)

REPORT FOR MONTH OF |  |  |  |  |  |  |  | January | January 1-31 | January 31 |  | 31 |  | 1
 |  |  |  |  | Monthly report |  |  | February | February 1-28 | February 28 |  | 28 |  | 1
MONTH | YEAR |  |  |  | Start of Project |  |  | March | March 1-31 | March 31 |  | 31 |  | 1
August | 2024 |  |  |  | End of Project |  |  | April | April 1-30 | April 30 |  | 30 |  | 1
 |  |  |  |  |  |  |  | May | May 1-31 | May 31 |  | 31 |  | 1
 | DATE |  |  |  |  |  |  | June | June 1-30 | June 30 |  | 30 |  | 1
End of Project | 3 |  |  |  |  |  |  | July | July 1-31 | July 31 |  | 31 |  | 1
 |  |  |  |  |  |  |  | August | August 1-31 | August 31 |  | 31 |  | 1
 |  |  |  |  |  |  |  | September | September 1-30 | September 30 |  | 30 |  | 1
 |  |  |  |  |  |  |  | October | October 1-31 | October 31 |  | 31 |  | 1
Report Date |  |  |  |  |  |  |  | November | November 1-30 | November 30 |  | 30 |  | 1
Report Date |  |  |  |  |  |  |  | December | December 1-31 | December 31 |  | 31 |  | 1
 |  | Col 1 | Col 2
 | Monthly report
 | Start of Project
 | End of Project
Spreadsheet: 173891d1344843246-update-master-file-columns-with-columns-from-slave-files-bob
Sheet: Bob

Date | Customer Name | Contact No. | [NAME] | [NAME] (RM) | Call Back Time | PFM | 1st Attemp | 2nd Attemp | 3rd Attemp | STATUS | Remark | Submission Date | Approval Date | [NAME] case
2012-05-01 00:00:00 | HUSSEIN DAING ALI | 6013xxxxxx (Mobile) | [EMAIL] | 20000 | From 10.00am to 5.00pm | [NAME]
Spreadsheet: 759568d1639594519-sum-column-based-on-values-in-2-other-columns-audits-master
Sheet: DC 21 Audits Master

[NAME] | Errors | Cases |  |  |  | [NAME] | Cases without errors
[NAME] |  | 144 |  |  |  | [NAME]
[NAME] | 1 | 182 |  |  |  | [NAME]
Luc | 1 | 187 |  |  |  | Luc
[NAME] |  | 265 |  |  |  | [NAME]
[NAME] |  | 226 |  |  |  | Brae
Brae |  | 241 |  |  |  | [NAME]
[NAME] |  | 90 |  |  |  | [NAME]
[NAME] | 1 | 150 |  |  |  | Ry
[NAME] | 0 | 100 |  |  |  | [NAME]
[NAME] | 0 | 80 |  |  |  | Will
Ry | 0 | 60 |  |  |  | Jo
[NAME] | 1 | 40 |  |  |  | [NAME]
Will | 1 | 880 |  |  |  | [NAME]
Will |  | 100 |  |  |  | [NAME]
Jo | 1 | 220 |  |  |  | JR
[NAME] | 0 | 233
[NAME] | 1 | 80
[NAME] | 1 | 232
[NAME] | 1 | 234
Will |  | 259
JR |  | 191
Ry |  | 191
Spreadsheet: 187199d1350376945-how-to-search-for-a-month-in-a-worksheet-that-has-all-the-months-in-0a1_fot_1verjaarsdae-test1
Sheet: Verjaarsdae

Datum Verjaar |  | Ouderdom | Naam | Van | Tel# | Address | Address 2 | Address 3 | Address 4 | [NAME] | E-pos
1965-08-28 00:00:00
1968-04-08 00:00:00
1990-10-23 00:00:00
1996-08-02 00:00:00
2000-08-04 00:00:00
1998-02-23 00:00:00
1982-08-25 00:00:00