tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 809333d1671035406-identify-top-2-and-lowest-2-value-and-include-in-comment-dynamic-varaince-summary_test-2-
Sheet: Sheet1

 |  | Products | Sales
 | All regions | Prod1 | 75
 | All regions | Prod2 | 65
 | All regions | Prod3 | 85
 | All regions | Prod4 | 87
 | All regions | Prod5 | 82
 | N.America | Prod1 | 36
 | N.America | Prod2 | 9
 | N.America | Prod3 | -5
 | N.America | Prod4 | 65
 | N.America | Prod5 | 102
 | Europe | Prod1 | 13
 | Europe | Prod2 | 36
 | Europe | Prod3 | -10
 | Europe | Prod4 | -40
 | Europe | Prod5 | 20
 | [NAME] | Prod1 | 12
 | [NAME] | Prod2 | 20
 | [NAME] | Prod3 | 100
 | [NAME] | Prod4 | 62
 | [NAME] | Prod5 | -40
 | [NAME] | Prod1 | 15
 | [NAME] | Prod2 | -17
 | [NAME] | Prod3 | 39
 | [NAME] | Prod4 | 15
 | [NAME] | Prod5 | -30
 | UK | Prod1 | 17
 | UK | Prod2 | 12
 | UK | Prod3 | -19
 | UK | Prod4 | 10
 | UK | Prod5 | -15
 | AUS | Prod1 | -18
 | AUS | Prod2 | 5
 | AUS | Prod3 | -20
 | AUS | Prod4 | -25
 | AUS | Prod5 | 45
Spreadsheet: 0a8791de-84e4-4eb4-bfac-22483612972b
Sheet: Historic Info Mang

HISTORIC INFORMATION MANAGEMENT
Certificates
Student Name:
ID #
Archival Management | Semester | Grade
___ ENG 101 (3) Writing I
___ Heritage/Humanities (3)
___ Social/Behavioral Sciences (3)
___ HIM 102 (3) Archives Studies:  Characteristics  Overview
___ HIM 210 (3) Archives Studies:  Appraisal & Accessioning
___ HIM 212 (3) Archives Studies:  Arrangement & Description
___ HIM 214 (3) Archives Studies:  Preservation & Conservation
___ HIM 216 (3) Archives Studies:  Automation & Electronics Records
Museum Management
___ ENG 101 (3) Writing I
___ Heritage/Humanities (3)
___ Social/Behavioral Sciences (3)
___ HIM 104 (3) Museum Studies: Characteristics & Overview
___ HIM 230 (3) Museum Studies:  Collections Care & Management
___ HIM 232 (3) Museum Studies:  Conservation and Preservation
___ HIM 236 (3) Museum Studies:  Automation
Records Management
___ ENG 101 (3) Writing I
___ Heritage/Humanities (3)
___ Social/Behavioral Sciences (3)
___ OST 160 (3)Records and Database Management
___ HIM 106 (3) Records management:  Characteristics & Overview
___ HIM 250 (3) Records Inventory & Analysis
___ HIM 252 (3) Electronic Records Management
___ HIM 254 (3) Records Reproduction & Imaging Systems
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: 0dba8da1-ab9b-42e0-873a-91725d223206
Sheet: import success seats course

Row Labels | FA11 | SP12 | Grand Total | 0 | 01 | 02 | 03 | 04 | 05 | 06 | 07 | 08 | 09 | 010 | 011 | 012 | 013 | 014 | 015 | 016 | 017 | 018 | 019 | 020 | 021
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26
Sum of Count
Row Labels
ENGL-101 | 5 |  | 5
ENGL-103 |  | 1 | 1
HIST-111 | 1 |  | 1
HIST-112 |  | 1 | 1
MATH-105 | 4 |  | 4
MATH-110 |  | 4 | 4
MATH-211 | 8 |  | 8
PSYC-101 |  | 2 | 2
SPAN-101 | 2 |  | 2
SPAN-102 |  | 1 | 1
Grand Total | 20 | 9 | 29
Spreadsheet: 691376d1597670737-listing-multiple-occurances-nom_list-pivot-no-values
Sheet: Sheet1

 |  |  | Code | Letter |  | Row Labels
 |  |  | 4000 | a |  | a |  |  | a | 4000 | 4003 | 4004 | 4006
 |  |  | 4001 | b |  | 4000 |  |  | b | 4001 | 4002 | 4005
 |  |  | 4002 | b |  | 4003 |  |  | c | 4007
 |  |  | 4003 | a |  | 4004 |  |  | d | 4008
 |  |  | 4004 | a |  | 4006 |  |  | e | 4009 | 4010
 |  |  | 4005 | b |  | b |  |  | f | 4011
 |  |  | 4006 | a |  | 4001 |  |  | g | 4012 | 4013
 |  |  | 4007 | c |  | 4002 |  |  | h | 4014
 |  |  | 4008 | d |  | 4005 |  |  | i | 4015
 |  |  | 4009 | e |  | c |  |  | j | 4016
 |  |  | 4010 | e |  | 4007
 |  |  | 4011 | f |  | d
 |  |  | 4012 | g |  | 4008
 |  |  | 4013 | g |  | e
 |  |  | 4014 | h |  | 4009
 |  |  | 4015 | i |  | 4010
 |  |  | 4016 | j |  | f
 |  |  |  |  |  | 4011
 |  |  |  |  |  | g
 |  |  |  |  |  | 4012
 |  |  |  |  |  | 4013
 |  |  |  |  |  | h
 |  |  |  |  |  | 4014
 |  |  |  |  |  | i
 |  |  |  |  |  | 4015
 |  |  |  |  |  | j
 |  |  |  |  |  | 4016
 |  |  |  |  |  | Grand Total
Spreadsheet: 11a5fd0f-7f2b-4156-8487-c92800e88dfb
Sheet: $ serials totals

Total Serials Expenditures by [NAME] FY08 and FY09
[NAME], Library Budget Only (No Endowments):
Library | FY08 | FY09 | % change | % of total FY09 expend.
Kingston serials funds | 3122274.89 | 2602491.17
[NAME] (pelp) | 33309.56 | 27264.41
CCE (ccep) | 47909.7 | 4194.3
TOTALS
Total Serials Endowment Expenditures FY08 and FY09
Fund code | Fund | FY08 | FY09 | % change
xbwp | B.Woods serials | 148.23 | 90.27
xcap | Carr fund serials | 7105.81 | 7795.66
xclp | Cloudman serials | 4290 | 9853.38
xgap | Galanti serials | 2694.76 | 3176.68
xiip | Ind.Ins.Agt serials | 14698.85 | 15550.85
 | TOTALS
Total Serials Expenditures (Including Endowments):
University Libraries | FY08 | FY09 | % change | % of total FY09 expend.
All branches
Endowments
TOTALS
Spreadsheet: 850298d1700663743-finding-formula-for-the-excel-file-attached-excelproblem
Sheet: Sheet1

code | date start | ID | [NAME]
1 | 2015-05-01 00:00:00 | 50 | 51
1 | 2023-05-01 00:00:00 | 51 | 51
2 | 2012-04-01 00:00:00 | 16 | 10
2 | 2018-06-01 00:00:00 | 10 | 10
2 | 2009-01-01 00:00:00 | 25 | 10
3 | 2022-01-01 00:00:00 | 89 | 87
3 | 2022-06-01 00:00:00 | 87 | 87
Spreadsheet: 0d838d4d-8367-42e9-9ae9-ed9500fc99b8
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Travel and Training June 16, 2011  through October 15, 2011 | Unnamed: 4 | Unnamed: 5
 | Name | Month | Vendor | Amount | Description
City Manager | [NAME] | 2011-07-11 00:00:00 | ICMA | 600 | ICMA Conference Registration
Municipal Judge | [NAME] | 2011-07-11 00:00:00 | NM Municipal League | 90 | Registration for annual [NAME] conference
 |  |  | Judge [NAME] | 223.38 | Mileage reimbursment [NAME] conference
 |  |  | [NAME] | 172.68 | Hotel NMML conference
Governing Body | [NAME] | 2011-09-01 00:00:00 | [NAME] | 345.36 | Reimbursement Hotel annual [NAME] conference
 | [NAME] | 2011-08-01 00:00:00 | NM Municipal League | 280 | Registration for annual [NAME] conference
 | Councilor [NAME] | 2011-08-11 00:00:00 | NM Municipal League | 280 | Registration for annual [NAME] conference
Spreadsheet: 87707d1287581631-excel-2007-updating-values-on-one-excel-spreadsheet-by-using-values-from-another-example
Sheet: Sheet1

Product Code | Description | Stock
B10/1081 | CLAAS ATLES 935RZ TRACTOR W/CLAAS DISC MOWER | 1
[NAME] | WRONG | 0
B10/1966 | JOHN DEERE 07930 TRACTOR W/LOADER & TWIN AXLE TIPP | 1
B10/2001 | WHEELS FOR 2000 SERIES TRACTOR | 4
B10/2005 | FRONTLOADER FOR 2000 TRACTOR | 4
B10/20060 | ROADMAX SKID STEER LOADER | 8
B10/2010 | Tandem axle tipping trailer | 1
B10/20102 | [NAME] | 0
B10/20105 | Roadmax road loader w/ backhoe | 1
B10/20115 | ROADMAX TRACTOR W/TIPPING TRAILER | 2
B10/2017 | JOHN DEERE BIG BALEPRESS | 0
Spreadsheet: 269976d1381337421-huge-problem-with-the-indirect-function-trying-to-create-dependent-drop-downs-pcard-amounts-removed
Sheet: April

Regina Downtown | [NAME]
P-card
Purpose: | May 2013 Statement
Description | Retailer | Goods Purchased | Total | GST | Fund | Org | Activity | Acct | Project | [NAME]
Meetings, Receptions & Food | [NAME] | other stakeholder -folk fest | 102.05 |  | 520 | 0000 | R110 | 64115 | Y0709 | 00
Meetings, Receptions & Food | Copper Kettle | Board Meeting | 131.39 |  | 520 | 0000 | R110 | 64115 | Y0709 | 00
Equipment, Rentals & Office Supplies | Staples | Stationary Supplies | 77.74 | 3.53 | 520 | 0000 | R110 | 65112 | Y0706 | 00
Communications | Mail Chimp | Newsletter | 31.42 | 0 | 520 | 0000 | R210 | 64232 | Y0720 | 00
Advertising | Cornwall Centre | [NAME] | 25 |  | 520 | 0000 | R210 | 68102 | Y0720 | 00
Advertising | Fresh on [NAME] | Other stakeholder meeting | 11.59 |  | 520 | 0000 | R210 | 64115 | Y0720 | 00
Special Projects | Atlantis | Grey Cup Meeting | 25 |  | 520 | 0000 | R310 | 68102 | Y0732 | 00
Advertising | Facebook | General | 28.52 |  | 520 | 0000 | R210 | 64202 | Y0720 | 00
CS Programming Summer | Bai Sushi | HR | 30.9 |  | 520 | 0000 | R310 | 64115 | Y0730 | 00
Special Projects | Earl's | Grey Cup Meeting | 51.33 |  | 520 | 0000 | R310 | 64115 | Y0732 | 00
CS Programming Summer | Dinasty Resturant | Team meeting | 86.88 |  | 520 | 0000 | R310 | 64115 | Y0730 | 00
TOTAL RECEIPTS
Spreadsheet: 824420d1680572896-comparing-two-lists-with-multiple-columns-s666-pq-ists-difference
Sheet: Sheet4

17 | 13 | Laplante | [NAME] | v
 | 13 | Angers-Trottier | Anne-Marie | v
17 | 13 | Belvedere | Calista | v
17 | 13 | Belvedere | [NAME] | v
17 | 13 | Hudon | Sandra | v
17 | 13 | [NAME] | Sylvie | v
17 | 13 | [NAME] | Alain | v
 | 13 | Charbonneau | [NAME] | v
17 | 13 | Lafleur | [NAME]
17 | 13 | Lafleur | [NAME]
 |  | Amal | Diabi
17 |  | Dupont | [NAME]
 |  | George | hebert
Spreadsheet: john_zufferli__16811__Enron Security Calculation 2002
Sheet: Flat

Direct Sales listed with the Power Pool of Alberta (Flat)
 |  | Deal | Start | End | Volume | Price | Counterparty
 |  |  | 2001-02-01 00:00:00 | 2002-12-31 00:00:00 | 25 |  | Encore
 |  |  | 2001-02-01 00:00:00 | 2003-12-31 00:00:00 | 25 |  | Encore
 |  |  | 2002-01-01 00:00:00 | 2002-06-30 00:00:00 | 1 |  | Lethbridge
 |  |  | 2001-10-10 00:00:00 | 2006-12-31 00:00:00 | 2.5 |  | Suncor
 |  |  | 2002-01-01 00:00:00 | 2002-12-31 00:00:00 | 10 |  | Chevron
 |  |  | 2002-01-01 00:00:00 | 2002-12-31 00:00:00 | 25 |  | Encore
 |  |  | 2002-01-01 00:00:00 | 2002-03-31 00:00:00 | 5 |  | Encore
 |  |  | 2002-01-01 00:00:00 | 2002-12-31 00:00:00 | 25 |  | Encore
 |  |  | 2002-01-01 00:00:00 | 2002-12-31 00:00:00 | 25 |  | Encore
 |  |  | 2002-01-01 00:00:00 | 2002-12-31 00:00:00 | 5 |  | Encore
 |  |  | 2002-01-01 00:00:00 | 2002-12-31 00:00:00 | 5 |  | Encore
 |  |  | 2002-01-01 00:00:00 | 2002-12-31 00:00:00 | 15 |  | Encore
MWh per deal per month
Days in Month
 | 2002-01-01 00:00:00 | 2002-02-01 00:00:00 | 2002-03-01 00:00:00 | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 2002-06-01 00:00:00 | 2002-07-01 00:00:00 | 2002-08-01 00:00:00 | 2002-09-01 00:00:00 | 2002-10-01 00:00:00 | 2002-11-01 00:00:00 | 2002-12-01 00:00:00 | 2003-01-01 00:00:00 | 2003-02-01 00:00:00 | 2003-03-01 00:00:00 | 2003-04-01 00:00:00 | 2003-05-01 00:00:00 | 2003-06-01 00:00:00 | 2003-07-01 00:00:00 | 2003-08-01 00:00:00 | 2003-09-01 00:00:00 | 2003-10-01 00:00:00 | 2003-11-01 00:00:00 | 2003-12-01 00:00:00 | 2004-01-01 00:00:00 | 2004-02-01 00:00:00 | 2004-03-01 00:00:00 | 2004-04-01 00:00:00 | 2004-05-01 00:00:00 | 2004-06-01 00:00:00 | 2004-07-01 00:00:00 | 2004-08-01 00:00:00 | 2004-09-01 00:00:00 | 2004-10-01 00:00:00 | 2004-11-01 00:00:00 | 2004-12-01 00:00:00 | 2005-01-01 00:00:00 | 2005-02-01 00:00:00 | 2005-03-01 00:00:00 | 2005-04-01 00:00:00 | 2005-05-01 00:00:00 | 2005-06-01 00:00:00 | 2005-07-01 00:00:00 | 2005-08-01 00:00:00 | 2005-09-01 00:00:00 | 2005-10-01 00:00:00 | 2005-11-01 00:00:00 | 2005-12-01 00:00:00 | 2006-01-01 00:00:00 | 2006-02-01 00:00:00 | 2006-03-01 00:00:00 | 2006-04-01 00:00:00 | 2006-05-01 00:00:00 | 2006-06-01 00:00:00 | 2006-07-01 00:00:00 | 2006-08-01 00:00:00 | 2006-09-01 00:00:00 | 2006-10-01 00:00:00 | 2006-11-01 00:00:00 | 2006-12-01 00:00:00 | 2007-01-01 00:00:00
Hours
Curve | 36.5 | 36.5 | 36.5 | 34.5 | 34.5 | 34.5 | 38.5 | 38.5 | 38.5 | 42 | 41.75 | 41.75 | 38 | 38 | 38 | 38 | 38 | 38 | 38 | 38 | 38 | 38 | 38 | 38 | 38 | 38 | 38 | 38 | 38 | 38 | 38 | 38 | 38 | 38 | 38 | 38 | 39 |  |  |  |  |  |  |  |  |  |  |  | 40
Total MWh
Value
 | 168.5
Spreadsheet: 346d3ec3-7ca8-4b5b-a210-f12389bb2ccb
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
2013 range | (16..60) | (20..56) | (31..81) | (0..24) | n/a
2013 avg. | 32 | 33 | 51 | 12 | n/a
Source:  Transportation & Marketing Programs/AMS/USDA
Spreadsheet: b5eb85e2-4586-41b6-9c3e-f6824e85a177
Sheet: Resultatopgørelse

RESULTATOPGØRELSE
 |  |  |  |  |  | 2012 |  | Budget 2012
INDTÆGTER
Note
 | Tilskud
 | Renteindtægter
 | Øvrige indtægter
 | INDTÆGTER I ALT
UDGIFTER
Note
 | Personaleomkostninger
 | Partskonsulentbistand m.v.
 | Ekstern konsulentbistand
 | Mødeudgifter
 | Rejseudgifter
 | Husleje
 | [NAME] og it
 | [NAME] og web
 | Renteudgifter
 | UDGIFTER I ALT
 | ÅRETS RESULTAT
Spreadsheet: 875290d1721877419-populate-invoice-sequence-at-each-change-in-order-number-ren_ski00-excel-forum-test-data-formula-help
Sheet: Sheet1

Invoice | Order No | Code | Customer Name | Cost
INV-4000 | 888001506835701-A | 203684-WHT | [NAME] | 57
 | 888001506835701-A | 203684-WHT | [NAME] | 57
 | 888001506640401-A | 203684-WHT | Tas Pavlakis | 57
 | 888001506640401-A | 203684-WHT | Tas Pavlakis | 57
 | 888001506332001-A | 102188 | [NAME] | 196.2
 | 888001495916101-A | TVS202 | [NAME] | 59.4
 | 888001495916101-A | TVS202 | [NAME] | 59.4
 | 888001481187301-A | 4319-WHT | [NAME] oakes | 104.4
 | 888001506452301-A | 5290-WHT | [NAME] | 63
 | 888001505494901-A | 57946 | [NAME] | 50.4
 | 888001506748401-A | 203242-07 | Robyn Young | 55.8
 | 888001506748401-A | 203242-07 | Robyn Young | 55.8
 | 888001506748401-A | 203194 | Robyn Young | 54
 | 888001506553701-A | 502088 | [NAME] | 38.7
 | 888001506553701-A | 502088 | [NAME] | 38.7
 | 888001506848001-A | 63232 | [NAME] | 130.5
 | 888001506640501-A | MEU3880 | [NAME] | 81
 | 888001503176301-A | 5290-WHT | [NAME] | 63
 | 888001506656301-A | 2115-LSO | [NAME] | 113.4
 | 888001506365501-A | 203594-BLK | [NAME] | 100.8
 | 888001504447601-A | 203684-WHT | [NAME] | 57
 | 888001504447601-A | 203684-WHT | [NAME] | 57
 | 888001506470401-A | 102052-06 | [NAME] | 168.75
 | 888001506470401-A | 102052-06 | [NAME] | 168.75
 | 888001506470401-A | 102052-06 | [NAME] | 168.75
 | 888001505904201-A | 203684-WHT | [NAME] | 57
 | 888001506371201-A | 203684-WHT | [NAME] | 57
 | 888001506371201-A | 203684-WHT | [NAME] | 57
 | 888001506459101-A | 203684-WHT | [NAME] | 57
 | 888001506459101-A | 203684-WHT | [NAME] | 57
 | 888001506921401-A | 203684-WHT | [NAME] | 57
 | 888001506921401-A | 203684-WHT | [NAME] | 57
 | 888001506670101-A | 203683-BLK | [NAME] | 38.7
 | 888001506670101-A | 203683-BLK | [NAME] | 38.7
 | 888001506281601-A | 23669 | [NAME] | 130.5
Spreadsheet: 698897d1602235104-create-a-list-based-on-the-value-of-a-cell-create-a-list-based-on-the-value-of-a-cell
Sheet: Sheet1

Unique name | Value | List
[NAME] | English | English, German, Russian |  |  | Row Labels |  |  | Unique name | Value
[NAME] | German | English, German, Russian |  |  | [NAME] |  |  | [NAME] | English
[NAME] | Russian | English, German, Russian |  |  | English |  |  |  | German
[NAME] | English | English, Russian |  |  | German |  |  |  | Russian
[NAME] | Russian | English, Russian |  |  | Russian |  |  | [NAME]
 |  |  |  |  | [NAME] |  |  | [NAME] | English
 |  |  |  |  | English |  |  |  | Russian
 |  |  |  |  | Russian |  |  | [NAME]
 |  |  |  |  | Grand Total |  |  | Grand Total
Spreadsheet: 57502d1257719548-pivot-table-trouble
Sheet: Sheet1

Fault Desc | Total Causes
[6659] MCP 18A E-Stop Pushed | 2 |  | 45 | [6665] MCP 18A Stop
[6660] Panel 18A1 E-Stop Pushed | 2 |  | 26 | [6755] Motor 18A2 Jammed
[6661] MCP 1A E-Stop Pushed | 1 |  | 11 | [6759] Motor 18A5 Jammed
[6662] MCP 1B E-Stop Pushed | 7
[6665] MCP 18A Stop | 45
[6666] Panel 18A1 Stop | 4
[6667] MCP 1A Stop | 15
[6668] MCP 1B Stop | 55
[6669] MCP 1C Stop | 65
[6670] MCP 18A Disconnect Open | 5
[6693] Motor 18A4 Not Running | 3
[6698] CDLR After Reintroduction Not Running B18 | 1
[6734] Turn Table 1 Not In Position Fault | 24
[6735] Turn Table 1 Run Too Long | 2
[6736] Turn Table 2 Not In Position Fault | 3
[6739] Door 9 Lane 1 Transfer Not Down | 1
[6746] Jam at MCC Guard Conveyor 18A04 | 7
[6748] B18 Auto Swing Gate Not Ok to Close | 4
[6755] Motor 18A2 Jammed | 26
[6757] Motor 18A3 Jammed | 3
[6758] Motor 18A4 Jammed | 5
[6759] Motor 18A5 Jammed | 11
In this example, I need excel to report back a list of the fault descriptions
with the highest 3 total causes, that contain 18A in the fault description.
Spreadsheet: 850581d1700937662-transpose-rows-from-one-sheet-to-another-sheet-based-on-a-value-in-one-of-the-columns-transpose-worksheet-copy
Sheet: Sheet2

AREA ID | A | B | B | B | A | A | A | B
QUANTITY |  | 30 | 9 | 3 | 7 | 20 | 10 | 10
COST | 133 | 1713 | 289 | 285 | 287 | 283 | 166.25 | 571
DATE | 2016-03-31 00:00:00 | 2016-09-13 00:00:00 | 2017-01-29 00:00:00 | 2017-11-13 00:00:00 | 2017-11-20 00:00:00 | 2018-02-08 00:00:00 | 2018-03-06 00:00:00 | 2018-03-28 00:00:00
SELLER | Seller 3 | Seller 2 | Seller 4 | Seller 2 | Seller 3 | Seller 1 | Seller 1 | Seller 2
BUYER | Buyer 5 | Buyer 3 | Buyer 3 | Buyer 3 | Buyer 6 | Buyer 6 | Buyer 6 | Buyer 6
ITEM | Item 1 | Item 2 | Item 6 | Item 4 | Item 5 | Item 3 | Item 1 | Item 2
Spreadsheet: 727674d1618021423-help-with-co-ed-kickball-lineup-kickball-lineup-4-9-2021
Sheet: Sheet1

 |  | Line Up |  |  | Boy |  |  | Girl
1 | Girl |  |  | 1 | Rory |  | 1 | Whitney
2 | Boy |  |  | 2 | [NAME] |  | 2 | Lindsey
3 | Boy |  |  | 3 | [NAME] |  | 3 | Carlie
4 | Girl |  |  | 4 | [NAME] |  | 4 | [NAME]
5 | Boy |  |  | 5 | Adam |  | 5 | Amanda
6 | Boy |  |  | 6 | [NAME]
7 | Girl |  |  | 7 | [NAME]
8 | Boy |  |  | 8 | [NAME]
9 | Boy
10 | Girl
11 | Boy
12 | Boy
13 | Girl
14 | Boy
15 | Boy
16 | Girl
17 | Boy
18 | Boy
19 | Girl
20 | Boy
21 | Boy
22 | Girl
23 | Boy
24 | Boy
25 | Girl
26 | Boy
27 | Boy
28 | Girl
29 | Boy
30 | Boy
31 | Girl
32 | Boy
33 | Boy
34 | Girl
35 | Boy
36 | Boy
37 | Girl
38 | Boy
39 | Boy
40 | Girl
41 | Boy
42 | Boy
43 | Girl
44 | Boy
45 | Boy
Spreadsheet: 79958d1280220538-hiding-conditional-format-when-activating-cell-is-empty-new-plog-test
Sheet: Sheet2

 |  |  |  | Name: - | [NAME]
 |  |  |  | Licence No. - | 12345/67
 |  |  |  | [NAME] |  |  | Alert
 |  |  |  | Revalidation |  |  | Alert
 |  |  |  | Medical |  |  | Alert
 |  |  |  | Radio-Telephony licence |  |  | Alert
 |  |  |  | Night Rating |  |  | Alert
 |  |  |  | I.M.C |  |  | Alert
 |  |  |  | Instructor |  |  | Alert
 |  |  |  | [NAME] |  |  | Alert
 |  |  |  |  |  |  | Alert
Spreadsheet: 123677d1317803795-find-value-by-testing-sums-in-a-range-solver_find_invoice
Sheet: Column_setup

 | Invoices | binary col.
 | 10
 | 5 |  |  |  |  |  |  |  | Solver is not installed by default in Excel2003 and 2007 so it has to be set up as an "Add-Ins"
 | 3 |  |  |  |  |  |  |  | before you can use it. How Excel 2010 behaves in regard to Solver I don't know.
 | 5
 | 18
 | 2 |  |  |  |  |  |  |  | Then there are problems with multiple choices when using Solver
 | 6
 | 20 |  |  |  |  |  |  |  | If your invoice target is 15 then you could get that sum by combining
 | 8 |  |  |  |  |  |  |  | 5 + 2 + 8 but it's also possible to combine 5 + 3 + 5 + 2 or 10 + 5 or 5 + 3 + 5 + 2
 | sum inv. | 0 |  |  |  |  |  |  | and get the same result. So how do you decide what is the "right" result?
 | Object f | 15 |  |  |  |  |  |  | In this set up there is a possibility to influence the result. Cell C12 sums the binary helper
 |  |  |  |  |  |  |  |  | column. By adding a constraint to Solver i.e. C12 = 4 you "force" Solver to use four numbers to
 | Target | 15 |  |  |  |  |  |  | reach your invoice target. You can chose between <=, =, or => when setting up a constraint.
 |  |  |  |  |  |  |  |  | To test this model put your invoice number in cell C16 and run Solver.
 |  |  |  |  |  |  |  |  | To do a rerun with another number I would recommend you clear the range C3 to C11 prior to
 |  |  |  |  |  |  |  |  | running Solver.
 |  |  |  |  |  |  |  |  | Alf
Spreadsheet: 851918d1702041888-formula-to-change-text-color-if-2-criteria-are-met-ticket-tracking
Sheet: 3B2

 |  |  |  |  |  | ../../../../../../../MIMS%20Tracking%20Comments.xlsx |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Priority | Emergency
 | Ticket Number | Type of Ticket | Issue/Task Comment | Asset Category | Asset Names |  | Time Created | Ack By | Mobilization Time | Mobilization Time in days:hrs:min | Completion Time | Resolution Time in hrs:min | Resolution Time in days:hrs:min | Completed Date | Solution | Avg. Priority [NAME] | Avg. Priority Resolution Time | Avg. Emergency Acknowledge Time | Avg. Emergency Resolution Time | Longest Priority Response Time | Longest Priority Resolution Time | Longest Emergency Response Time | Longest Emergency Resolution Time | "Priority" Over Allotted Acknowledge Time | Priority Over Allotted Resolution Time | "Emergency" Over Allotted Acknowledge Time | "Emergency" Over Allotted Resolution Time | Unresolved Priority Tickets | Unresolved Emergency Tickets |  |  | Total Priority Tickets | Total Emergency Tickets
1 | T00226562 | Emergency | Unknown Error | DMS | 95SB045.7-LS |  | 2023-02-19 05:00:00 | SICE | 2023-02-19 06:56:00 |  | 2023-02-19 08:17:00
2 | T00226581 | Priority | Pixel Error | ADMS | GLAD808EB9 |  | 2023-02-22 18:07:00 | SICE | 2023-02-22 18:25:00 |  | 2023-02-23 18:19:00
3 | T00229040 | Priority | Lane Speed Configuration | MVDS | FLD4095046.5NBNS |  | 2023-03-01 19:49:00 | SICE | 2023-03-01 20:57:00 |  | 2023-03-02 08:49:00
4 | T00229202 | Priority | No DMS Communication | ADMS | GLAD808EB9 |  | 2023-03-03 12:43:00 | SICE | 2023-03-03 12:54:00 |  | 2023-03-06 10:37:00
5 | T00229300 | Priority | Lane Speed Configuration | MVDS | FLD4095048.1SBNS |  | 2023-03-06 21:29:00 | SICE | 2023-03-13 08:39:00 |  | 2023-03-13 14:29:00
122
123
124
125
Spreadsheet: 845441d1696958058-pivot-with-multiple-tabs-as-range-forecasts-and-orders-10102023
Sheet: NPW

Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI |  | Order Date | PO | Description | Item Code | Qty.
PERRIER L'ORAN 24/16.9Z BTL | 10292 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-06-20 00:00:00 | 297356 | PERRIER LIME 24/16.9Z BTL | 10290 | 13 | * Ask if [NAME] has allocations.
PERRIER LIME 24/16.9Z BTL | 10290 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PERRIER ORIGNL 24/16.9Z BTL | 10291 | 13
PERRIER ORIGNL 12/750ML | 10298
PERRIER ORIGNL 24/16.9Z BTL | 10291 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-09-26 00:00:00 | 297476 | PERRIER LIME 24/16.9Z BTL | 10290 | 12
PERRIER PINAPL 24/16.9Z BTL | 10293 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PERRIER ORIGNL 24/16.9Z BTL | 10291 | 13
PERRIER POMEGR 4/6/300ML | 10296
PERRIER TANGER 4/6/300ML | 10297
S.PELLEGRINO 12/500ML | 10295
ACQUA PANA 12/1L | 10294
Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI
PERRIER L'ORAN 24/16.9Z BTL | 10292
PERRIER LIME 24/16.9Z BTL | 10290
PERRIER ORIGNL 12/750ML | 10298
PERRIER ORIGNL 24/16.9Z BTL | 10291
PERRIER PINAPL 24/16.9Z BTL | 10293
PERRIER POMEGR 4/6/300ML | 10296
PERRIER TANGER 4/6/300ML | 10297
S.PELLEGRINO 12/500ML | 10295
ACQUA PANA 12/1L | 10294
Spreadsheet: jonathan_mckay__16902__EnronDirect Deal Sheet-Area Managers
Sheet: McKay Buy

Enron Direct Deal Sheet |  |  |  |  |  |  |  |  |  |  |  |  | 1 | January
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | February
Counterparty Name: | [NAME] |  |  |  | Deal Date: | 2001-05-30 00:00:00 |  |  |  |  |  |  | 3 | March
Originator: | Greg Frers |  |  |  | Deal ID #: |  |  |  |  |  |  |  | 4 | April
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | May
Deal Start Date: | 2001-08-01 00:00:00 |  |  |  | Unit of Measure: | GJ |  |  |  |  |  |  | 6 | June
Deal End Date: | 2002-07-31 00:00:00 |  |  |  | Volume (Monthly/Daily): | Monthly |  |  |  |  |  |  | 7 | July
Term Duration (months): |  |  |  |  |  |  |  |  |  |  |  |  | 8 | August
 |  |  |  |  | Price: |  |  |  |  |  |  |  | 9 | September
Fuel Rate %: | 0.01561 |  |  |  | Buy/Sell: | Buy |  |  |  |  |  |  | 10 | October
 |  |  |  |  |  |  |  |  |  |  |  |  | 11 | November
 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | December
 | Month | Rate 11 Volume | Rate 13 Volume | Combined Volume | Fuel | Total
 | January | 12202 | 8749
 | February | 10364 | 6807
 | March | 8559 | 6888
 | April | 6948 | 5055
 | May | 3640 | 3478
 | June | 2924 | 2632
 | July | 1785 | 1955
 | August | 1947 | 1505
 | September | 3378 | 2968
 | October | 5592 | 4973
 | November | 9090 | 7009
 | December | 10840 | 8001
 | TOTAL: