tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 155115d1336672489-is-it-possible-to-unhide-row-based-on-cell-content-sample
Sheet: Regnskap 2012

 | Company - Regnskap |  |  |  |  |  |  |  | Balanse |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Resultatregnskap
 | 2012
 |  |  |  |  |  |  |  |  | Aksjer |  | Bank (Drift) |  | Bank (Likviditet) |  | Bank (Skattetrekk) |  | Bank (Utbytte) |  | Bank (Investering) |  | Opptjent Kapital |  | Innskudd Kontanter |  | MasterCard |  |  |  | [NAME] |  | Strøm |  | [NAME] |  | Inventar & Driftsutstyr |  | Møter & Kursing |  | Telefon |  | Internett |  | Reisekostnader |  | Forsikring |  | Renteinntekter |  | [NAME] |  | Utbytte |  | [NAME] |  | Tap Valuta |  | Tap Verdipapirer |  | [NAME]
 |  |  |  |  |  |  |  |  | 1810 |  | 1920 |  | 1921 |  | 1922 |  | 1923 |  | 1924 |  | 2050 |  | 2055 |  | 2380 |  |  |  | 6320 |  | 6340 |  | 6390 |  | 6540 |  | 6860 |  | 6900 |  | 7098 |  | 7140 |  | 7500 |  | 8050 |  | 8060 |  | 8071 |  | 8078 |  | 8160 |  | 8178 |  | 8800
BilagsNr | Dato | Beskrivelse | OK | Kontroll | Kontroll | Kontroll | Kontroll | Kontroll | Debet | Kredit | Debet | Kredit | Debet | Kredit | Debet | Kredit | Debet | Kredit | Debet | Kredit | Debet | Kredit | Debet | Kredit | Debet | Kredit |  |  | Debet | Kredit | Debet | Kredit | Debet | Kredit | Debet | Kredit | Debet | Kredit | Debet | Kredit | Debet | Kredit | Debet | Kredit | Debet | Kredit | Debet | Kredit | Debet | Kredit | Debet | Kredit | Debet | Kredit | Debet | Kredit | Debet | Kredit | Debet | Kredit
 | 2012-01-01 00:00:00 | Fictional Transaction
 | 2012-01-02 00:00:00 | Fictional Transaction |  |  |  |  |  |  |  |  |  | -200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 200
 | 2012-01-10 00:00:00 | Fictional Transaction |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -151 |  |  |  |  |  |  |  |  | 151
 | 2012-01-15 00:00:00 | Fictional Transaction |  |  |  |  |  |  |  |  | 2000 |  |  |  |  |  |  |  |  |  |  |  |  | -2000
 | 2012-02-01 00:00:00 | Fictional Transaction |  |  |  |  |  |  |  |  |  | -500 |  |  |  |  |  |  |  |  |  |  |  |  | 500
When i write stuff here, i want row 33 unhidden, and so on.
 | 2012-12-31 00:00:00 | Renteoppgjør MasterCard
 | 2012-12-31 00:00:00 | Årsavslutning
 |  |  |  |  |  |  |  |  | Saldo |  | Saldo |  | Saldo |  | Saldo |  | Saldo |  | Saldo |  | Saldo |  | Saldo |  | Saldo |  |  |  | Saldo |  | Saldo |  | Saldo |  | Saldo |  | Saldo |  | Saldo |  | Saldo |  | Saldo |  | Saldo |  | Saldo |  | Saldo |  | Saldo |  | Saldo |  | Saldo |  | Saldo |  | Saldo
Spreadsheet: 128354d1320927774-calculating-payment-dates-to-exclude-weekends-and-holidays-payroll-dates
Sheet: Sheet2

Name | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-02 00:00:00
Start date | 2012-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-06 00:00:00
Salary payment date | 28th of each month |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-09 00:00:00
Salary start date | 2012-01-28 00:00:00 |  |  | I want cell B5 to calculate the next salary payment date in the following month |  |  |  |  |  |  |  |  |  | 2012-05-07 00:00:00
Subsequent salary pay dates | 2012-02-28 00:00:00 |  |  | to be on the same monthly pay date, or the next working day, and to exclude the dates |  |  |  |  |  |  |  |  |  | 2012-06-04 00:00:00
 | 2012-03-28 00:00:00 |  |  | in column O |  |  |  |  |  |  |  |  |  | 2012-06-05 00:00:00
 | 2012-04-30 00:00:00 |  |  | Cell B6 will then be 2 months etc etc |  |  |  |  |  |  |  |  |  | 2012-08-27 00:00:00
 | 2012-05-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-25 00:00:00
 | 2012-06-28 00:00:00 |  |  | Based on the start date in B4, from cell B5 to B15 show the dates I would expect to be |  |  |  |  |  |  |  |  |  | 2012-12-26 00:00:00
 | 2012-07-30 00:00:00 |  |  | returned. In essence it will always be the 28th of each month unless the 28th is a
 | 2012-08-28 00:00:00 |  |  | weekend (as in April, July and October) or one of the dates in column O (which in this case it isn't)
 | 2012-09-28 00:00:00 |  |  | Where it does fall on a weekend or holiday date I want it to default to the next working day.
 | 2012-10-29 00:00:00
 | 2012-11-28 00:00:00
 | 2012-12-28 00:00:00
Spreadsheet: 852159d1702262419-days-without-incident-counter-book1
Sheet: Safety

 |  | Safety Incident Tracking
 | Date | Type | Incident | Action | PIC | Status | Remarks | Month
 | 2023-10-01 00:00:00 |  | No incident
 | 2023-10-02 00:00:00 |  | No incident
 | 2023-10-03 00:00:00 |  | No incident
 | 2023-10-04 00:00:00 |  | No incident
 | 2023-10-05 00:00:00 |  | No incident
 | 2023-10-06 00:00:00 |  | No incident
 | 2023-10-07 00:00:00 |  | No incident
 | 2023-10-08 00:00:00 |  | No incident
 | 2023-10-09 00:00:00 |  | No incident
 | 2023-10-10 00:00:00 |  | No incident
 | 2023-10-11 00:00:00 |  | No incident
 | 2023-10-12 00:00:00 |  | No incident
 | 2023-10-13 00:00:00 |  | No incident
 | 2023-10-14 00:00:00 |  | No incident
 | 2023-10-15 00:00:00 |  | No incident
 | 2023-10-16 00:00:00 |  | No incident
 | 2023-10-17 00:00:00 |  | No incident
 | 2023-10-18 00:00:00 |  | No incident
 | 2023-10-19 00:00:00 |  | No incident
 | 2023-10-20 00:00:00 |  | No incident
 | 2023-10-21 00:00:00 |  | No incident
 | 2023-10-22 00:00:00 |  | No incident
 | 2023-10-23 00:00:00 |  | No incident
 | 2023-10-24 00:00:00 |  | No incident
 | 2023-10-25 00:00:00 |  | No incident
 | 2023-10-26 00:00:00 |  | No incident
 | 2023-10-27 00:00:00 |  | Test incident
 | 2023-10-28 00:00:00 |  | Test incident
 | 2023-10-29 00:00:00 |  | No incident
 | 2023-10-30 00:00:00 |  | No incident
 | 2023-10-31 00:00:00 |  | No incident
 | 2023-11-01 00:00:00 |  | No incident
 | 2023-11-02 00:00:00 |  | No incident
 | 2023-11-03 00:00:00 |  | No incident
 | 2023-11-04 00:00:00 |  | No incident
 | 2023-11-05 00:00:00 |  | No incident
 | 2023-11-06 00:00:00 |  | No incident
 | 2023-11-07 00:00:00 |  | No incident
 | 2023-11-08 00:00:00 |  | No incident
 | 2023-11-09 00:00:00 |  | No incident
 | 2023-11-10 00:00:00 |  | No incident
 | 2023-11-11 00:00:00 |  | No incident
 | 2023-11-12 00:00:00 |  | No incident
 | 2023-11-13 00:00:00 |  | No incident
 | 2023-11-14 00:00:00 |  | No incident
 | 2023-11-15 00:00:00 |  | No incident
 | 2023-11-16 00:00:00 |  | No incident
 | 2023-11-17 00:00:00 |  | No incident
 | 2023-11-18 00:00:00 |  | No incident
 | 2023-11-19 00:00:00 |  | No incident
 | 2023-11-20 00:00:00 |  | No incident
 | 2023-11-21 00:00:00 |  | No incident
 | 2023-11-22 00:00:00 |  | No incident
 | 2023-11-23 00:00:00 |  | No incident
 | 2023-11-24 00:00:00 |  | No incident
Spreadsheet: john_griffith__15686__05_15_01ON
Sheet: Sheet1

N
Commodity: | ON - NAT. GAS OPTS.
Month | STRIKE | BID | OFFER | Volatility | Future
M01-P/C | 460 | 35 | 37
N01-P/C | 470 | 68.5 | 70
Q01-P/C | 475 | 89 | 93
U01-P/C | 475 | 108 | 111
V01-P/C | 475 | 123.5 | 126
X01-P/C | 495 | 143 | 149
[NAME]-P/C | 510 | 163 | 169
F02-P/C | 515 | 178 | 183
G02-P/C | 505 | 184 | 190
H02-P/C | 480 | 170 | 172
J02-P/C | 445 | 125 | 135
K02-P/C | 430 | 115 | 125
M02-P/C | 430
Z02-P/C | 470 | 161 | 164
Spreadsheet: 37207d1235144950-help-master-sheet-to-sub-cat-sheets-issuetracker-1
Sheet: Housek Fitness

 | Issue to be Addressed | Date Created | Area | Dept Assigned To | Date Read | Date Completed | Comments
 | [NAME] needs deep clean | 2009-02-08 00:00:00 | [NAME] | Kitchen
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
 |  | .
Spreadsheet: 60454d1260988790-help-with-sumprodcut-formulas-sumproduct-help
Sheet: Sheet1

Account | Account Manager | # User Licenses | Status | EOI Date | Registration Date | License Signed Date
Acct 1 | [NAME] | 2 | License Signed | 2009-04-12 00:00:00 | 2009-05-12 00:00:00 | 2009-06-12 00:00:00
Acct 2 | [NAME] | 1 | License Signed | 2009-08-07 00:00:00 | 2009-11-07 00:00:00 | 2009-12-07 00:00:00
Acct 3 | [NAME] | 1 | Registered | 2009-06-03 00:00:00 | 2009-10-08 00:00:00
Acct 4 | [NAME] | 3 | EOI | 2009-01-03 00:00:00
Acct 5 | [NAME] | 4 | EOI | 2009-02-26 00:00:00
Acct 6 | [NAME] | 4 | EOI | 2009-12-02 00:00:00
 | Example Totals
 | April 2009 - April 2010
 | EOI Users | 4
 | Registered Users | 1
 | [NAME] | 3
 | April 2009 - April 2010 - Bob
 | EOI Users | 4
 | Registered Users | 0
 | [NAME] | 2
 | April 2009 - April 2010 - Jill
 | EOI Users | 0
 | Registered Users | 1
 | [NAME] | 1
Spreadsheet: f6bd4d89-b046-45ea-a22c-76be515392da
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
43634489 | 2014-10-18 18:03:41 | AXIS | 1 | 7 | 3 | 298050 | MrBlonde | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
43634742 | 2014-10-18 18:21:43 | ALLIES | 0 | 2 | 7 | 298050 | MrBlonde | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
Spreadsheet: 329659d1404378732-collate-data-problem-solving-sample-work-book
Sheet: Tab 10

 |  |  |  |  |  |  |  | Price [NAME]
 | Labour | Grade | Cost | Personnel | Days | Hr/Day
 | Travel and Subsistence | Basis
 | Materials and Subcontract | Basis | Cost
 | Pricing
 | Total labour
 | Total T&S
 | Total materials
Spreadsheet: 784487d1655759337-need-to-apply-discount-to-a-product-selected-from-drop-down-list-testquote21
Sheet: 3Design Quote

 |  |  |  |  |  | QUOTE # |  | 20220620-TB
[NAME] to |  |  |  |  |  | Ship to
Company
Name
Address
City/State
Quote Date |  |  |  | Purchase Order # |  |  | Order Confirmation (if no P.O provided)
 |  |  |  |  |  |  | By signing, I approve payment terms, amount
 |  |  |  |  |  |  | and agree to purchase products as described below
Terms | At time of order |  |  | All Prices are in US $ |  |  | Signature:
 |  |  | All Software Sales are Final - NonRefundable
Quantity | Product ID | Product Description |  |  |  |  |  | Unit Price |  | Total
SALES QUOTE VALID FOR 30 DAYS ONLY |  |  |  |  |  |  |  | Subtotal
Quote prepared by: |  | [NAME] |  |  | $0.00 shipping |  |  | Sales Tax | 0.03
For questions, please call me at  or email |  |  |  |  |  |  |  | Shipping & Handling
We accept check, wire transfer and major credit cards as methods of payment |  |  |  |  |  |  |  | Total in USD
Spreadsheet: 812869d1673432970-filter-formula-for-does-not-equal-and-contain-does-not-equal-and-contain
Sheet: Sheet1

 | List |  | Result
 | ALFREDO |  |  |  | Does Not Equal | LFR
 | EDI |  | EDA |  | Does Not Contain | ALF
 | EDA |  | RALF
 | ALFRED |  | ALF EDO
 | RALF |  | ALFFREDO |  | [NAME]:B10,ISNUMBER(SEARCH(G2,B2:B10))=FALSE,"-")
 | ALF EDO
 | R.ALFR
 | ALFFREDO
 | LFR
Spreadsheet: 328348d1403876654-formula-to-add-up-totals-from-lots-of-worksheets-testings
Sheet: sheet4

 |  |  | Item | Date of PAT Test | [NAME] |  | [NAME] key
 |  |  | 1 | 2012-08-21 00:00:00 | 2013-08-21 00:00:00 |  | Test Due
 |  |  | 1 | TBA |  |  | Test in 30 days
 |  |  | 1 | 2014-01-20 00:00:00 | 2015-01-20 00:00:00
 |  |  | In need of first test:
 |  |  | Overdue for PAT test:
 |  |  | Total
Spreadsheet: 807655d1669990195-excel-copy-and-paste-workbook2
Sheet: Sheet1

 | List
 | ABCD
 | [PHONE]
 | Abcd1
 | 1234, westway rd, AB
 | yzx1234
 | 123456
 | CDEF
 | [PHONE]
 | cdef2
 | 3456, east garden, VC
 | abc4321
 | 876542
 | Result needed
 | ABCD | [PHONE] | Abcd1 | 1234, westway rd, AB | yzx1234 | 123456
 | CDEF | [PHONE] | cdef2 | 3456, east garden, VC | abc4321 | 876542
Spreadsheet: e764fec9-9e44-4597-862f-73b7e86ed990
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
43328642 | 2014-09-27 01:39:58 | ALLIES | 0 | 2 | 6 | 1240562 | Big Taz | 6154 | mediterranean | 1944-08-20 | 1944-08-26 | Toulon | Toulon
43328753 | 2014-09-27 02:10:36 | AXIS | 1 | 6 | 5 | 1240562 | Big Taz | 6154 | mediterranean | 1944-08-20 | 1944-08-26 | Toulon | Toulon
43329335 | 2014-09-27 03:22:12 | ALLIES | 0 | 3 | 6 | 1257313 | prototypetolyfe | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
43329546 | 2014-09-27 03:47:06 | AXIS | 1 | 6 | 5 | 1257313 | prototypetolyfe | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
Spreadsheet: 747234d1631299629-how-to-count-the-total-of-numbers-in-a-range-of-percentage-sample-opp-
Sheet: PV

Adjusted Cycle | C1
Grouping | A
 |  |  | I tried the formula below but it is not the result I wish to get
Row Labels | Count of ID
0.35 | 8
70% | 58
APP CLOSED | 1
APP REJ | 1 |  | 1) I would like to count the total of those more than or equals to 32% |  |  |  |  |  |  |  | 66
DOC | 4 |  | 2) I would like to count the total of those listed as words instead of numbers |  |  |  |  |  |  |  | 7
WTH | 1
Grand Total | 73
Spreadsheet: 838567d1691144131-split-number-into-seperate-cells-and-remove-characters-dob-book1
Sheet: Sheet1

example 1 | employee number | DESIRED RESULT:
 | 87082702 | 8 | 7 | 0 | 8 | 2 | 7 | 0 | 2
example 2 | DOB | DESIRED RESULT:
 | 1999-09-07 00:00:00 | 0 | 7 | 0 | 9 | 1 | 9 | 9 | 9
Spreadsheet: 798149d1664331726-spill-error-when-converting-to-table-spill-error-when-converting-to-table
Sheet: Sheet1

 |  |  |  |  |  |  |  | Dropdown | Paid
 |  | No | Place | Status
 |  | 1 | Place 1 | Pending
 |  | 2 | Place 2 | Paid
 |  | 3 | Place 3 | Paid
 |  | 4 | Place 4 | Pending |  |  | Without table is working fine below: |  |  | Spill Error when converting to table below:
 |  | 5 | Place 5 | Pending
 |  | 6 | Place 6 | Pending |  |  | PLACE | Status |  | PLACE | Status
 |  | 7 | Place 1 | Pending
 |  | 8 | Place 3 | Pending |  |  | Place 3
 |  | 9 | Place 3 | Pending |  |  | Place 12
 |  | 10 | Place 3 | Paid |  |  | Place 13
 |  | 11 | Place 3 | Paid |  |  | Place 14
 |  | 12 | Place 12 | Paid |  |  | Place 4
 |  | 13 | Place 13 | Paid |  |  | Place 20
 |  | 14 | Place 14 | Paid
 |  | 15 | Place 4 | Pending
 |  | 16 | Place 4 | Pending
 |  | 17 | Place 4 | Paid
 |  | 18 | Place 4 | Pending
 |  | 19 | Place 19 | Pending
 |  | 20 | Place 20 | Paid
Spreadsheet: 683900d1593030985-rank-multiple-criteria-alpha-and-numeric-ranking-alpha-and-numeric-sample
Sheet: Data

 |  | Lookup | Office | Position | Staff | What I need
 |  | AtlantaAD | Atlanta | AD | Cooke | 1
 |  | AtlantaAD | Atlanta | AD | Cooke | 1
 |  | AtlantaAD | Atlanta | AD | Cooke | 1
 |  | AtlantaAD | Atlanta | AD | Cooke | 1
 |  | AtlantaAD | Atlanta | AD | Lovet | 2
 |  | AtlantaAD | Atlanta | AD | Troy, | 2
 |  | AtlantaAD | Atlanta | AD | Troy, | 2
 |  | AtlantaAD | Atlanta | AD | Troy, | 2
 |  | AtlantaCS | Atlanta | CS | Klein | 1
 |  | AtlantaCS | Atlanta | CS | Klein | 1
 |  | AtlantaCS | Atlanta | CS | Klein | 1
 |  | AtlantaCS | Atlanta | CS | Klein | 1
 |  | AtlantaCS | Atlanta | CS | Klein | 1
 |  | AtlantaCS | Atlanta | CS | Milli | 2
 |  | AtlantaCS | Atlanta | CS | Milli | 2
 |  | AtlantaCS | Atlanta | CS | Milli | 2
 |  | AtlantaCS | Atlanta | CS | Milli | 2
 |  | AtlantaCS | Atlanta | CS | Milli | 2
 |  | AtlantaCS | Atlanta | CS | Norri | 3
 |  | BostonAD | Boston | AD | Ayer, | 1
 |  | BostonAD | Boston | AD | Ayer, | 1
 |  | BostonAD | Boston | AD | Ayer, | 1
 |  | BostonAD | Boston | AD | Ayer, | 1
 |  | BostonAD | Boston | AD | Chagn | 2
 |  | BostonAD | Boston | AD | Chagn | 2
 |  | BostonAD | Boston | AD | Chagn | 2
 |  | BostonAD | Boston | AD | Chagn | 2
 |  | BostonAD | Boston | AD | Chagn | 2
 |  | BostonAD | Boston | AD | Chagn | 2
 |  | BostonAD | Boston | AD | Smith | 3
 |  | BostonAD | Boston | AD | Smith | 3
 |  | BostonAD | Boston | AD | Turco | 4
 |  | BostonCCP | Boston | CCP | Fred | 1
 |  | BostonCCP | Boston | CCP | Fred | 1
 |  | BostonCCP | Boston | CCP | Fred | 1
 |  | BostonCCP | Boston | CCP | Fred | 1
 |  | BostonCCP | Boston | CCP | Fred | 1
 |  | BostonCCP | Boston | CCP | Fred | 1
 |  | BostonCCP | Boston | CCP | Fred | 1
 |  | BostonCCP | Boston | CCP | Fred | 1
 |  | BostonCS | Boston | CS | Crow, | 1
 |  | BostonCS | Boston | CS | Crow, | 1
 |  | BostonCS | Boston | CS | Crow, | 1
 |  | BostonCS | Boston | CS | Doria | 2
 |  | BostonCS | Boston | CS | Kanne | 3
 |  | BostonCS | Boston | CS | Kanne | 3
 |  | BostonCS | Boston | CS | Kanne | 3
 |  | BostonCS | Boston | CS | Kanne | 3
 |  | BostonCS | Boston | CS | Kanne | 3
 |  | BostonCS | Boston | CS | Redmo | 4
 |  | BostonCS | Boston | CS | Redmo | 4
 |  | BostonCS | Boston | CS | Redmo | 4
 |  | BostonCS | Boston | CS | Redmo | 4
 |  | BostonCS | Boston | CS | Redmo | 4
Spreadsheet: mary_fischer__25822__Analysis of Changes
Sheet: Net State Income Taxes

Enron Corp & Subs
2nd Current Estimate
Net State Income Taxes Analysis
 |  | 2nd CE |  | 1st CE |  | Difference |  | Contact |  | Explanation
CE & Plan Reclasses |  | 0 |  | 0
Corp & Other* |  | 7906 |  | -7018 |  |  |  | [NAME] |  | 66% Increase in Overview Income
EBS |  | -19467 |  | -2543 |  |  |  | [NAME]
ECM - Wholesale |  | -2928 |  | -628
EE&CC |  | 2086 |  | 2795
EES** |  | 5650 |  | 5650
EGA |  | 0 |  | 0
EGM |  | 807 |  | 942
EGEP |  | 0 |  | 0
EIM |  | 220 |  | 1199
Enron Americas |  | 4207 |  | 19039 |  |  |  | [NAME]
Enron Networks |  | -263 |  | 2028
ETS |  | 13116 |  | 14921
Europe*** |  | 0 |  | 0
PGE |  | 7073 |  | 9489
Wholesale Other |  | 0 |  | 0
Grand Total
*For comparison purposes, includes EREC, Finance, Overview, & Clean Fuels
**For comparison purposes, includes EES-Retail & EES-Wholesale
***For comparison purposes, includes CATS/Margaux & Middle East
Spreadsheet: 216081d1361575010-time-log-for-various-employees-on-various-projects-on-various-days-labor-expense-reclass-to-afe-02_19_2012-example-pcb-
Sheet: Summary

AFE | AFE Description | Employee Name | Date | Rate | Reg Hours | OT Hours | Total | Reg $ | OT $ | Total$ | Year-Month | Year-Month | 2013-02
1870 | Line # 2 Upgrade | Bubba | 2013-02-20 00:00:00 | 11 | 10 |  | 10 | 110 | 0 | 110 | 2013-02
1870 | Line # 2 Upgrade | [NAME] | 2013-02-20 00:00:00 | 12 | 3 |  | 3 | 36 | 0 | 36 | 2013-02 |  |  |  | Gegevens
1870 | Line # 2 Upgrade | Cletus | 2013-02-21 00:00:00 | 13 | 3 |  | 3 | 39 | 0 | 39 | 2013-02 | Employee Name | AFE | AFE Description | Som van Reg Hours | Som van OT Hours | Som van Total | Som van Reg $ | Som van OT $ | Som [NAME]
1870 | Line # 2 Upgrade | [NAME] | 2013-02-21 00:00:00 | 14 | 1 |  | 1 | 14 | 0 | 14 | 2013-02 | [NAME] | 1870 | Line # 2 Upgrade | 1 |  | 1 | 14 | 0 | 14
1873 | Line # 3 Upgrade | [NAME] | 2013-02-14 00:00:00 | 11 |  | 8.5 | 8.5 | 0 | 140.25 | 140.25 | 2013-02 | Bubba | 1870 | Line # 2 Upgrade | 10 |  | 10 | 110 | 0 | 110
1873 | Line # 3 Upgrade | [NAME] | 2013-02-14 00:00:00 | 22 |  | 1 | 1 | 0 | 33 | 33 | 2013-02 | Cletus | 1870 | Line # 2 Upgrade | 3 |  | 3 | 39 | 0 | 39
1933 | 72 Inch Die | [NAME] | 2013-02-14 00:00:00 | 22 |  | 1 | 1 | 0 | 33 | 33 | 2013-02 | [NAME] | 1873 | Line # 3 Upgrade |  | 1 | 1 | 0 | 33 | 33
1933 | 72 Inch Die | [NAME] | 2013-02-18 00:00:00 | 33 |  | 3 | 3 | 0 | 148.5 | 148.5 | 2013-02 |  | 1933 | 72 Inch Die |  | 4 | 4 | 0 | 181.5 | 181.5
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 1870 | Line # 2 Upgrade | 3 |  | 3 | 36 | 0 | 36
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 1873 | Line # 3 Upgrade |  | 8.5 | 8.5 | 0 | 140.25 | 140.25
 |  |  |  |  |  |  |  |  |  |  |  | Eindtotaal |  |  | 17 | 13.5 | 30.5 | 199 | 354.75 | 553.75
Spreadsheet: 385906d1427479760-problem-with-protecting-workbooks-which-have-lists-recording-sheet-version-8
Sheet: Micro Moths

Micro Moths |  |  |  |  | Please enter data in as many fields below as possible - leave blank where information not known. Required fields are highlighted with a blue cell below. Comments are also inserted in each header below giving extra user information.
ABH Log | BF Log | Status | Species [NAME] | Species Latin name | Place Name | [NAME]. | [NAME]. | [NAME] | Determiners Name | Date of Record | Qty Recorded | Method of Recording | [NAME] | Stage | Weather | Aspect | Altitude | [NAME]. | Notes
37.026 | 509 | None | - | [NAME] violacea
37.028 | 510 | C | - | Coleophora juncicolella
37.029 | 511 | D | - | [NAME]
37.03 | 512 | D | - | Coleophora binderella
37.027 | 513 | None | - | [NAME] potentillae
37.031 | 514 | None | - | Coleophora ahenella
37.032 | 515 | C | - | [NAME]
37.033 | 516 | C | - | Coleophora trifolii
37.03 | 512 | D | - | Coleophora binderella
37.027 | 513 | None |  | [NAME] potentillae
37.031 | 514 | None |  | Coleophora ahenella
37.032 | 515 | C |  | [NAME]
37.033 | 516 | C |  | Coleophora trifolii
37.03 | 512 | D |  | Coleophora binderella
37.027 | 513 | None |  | [NAME] potentillae
37.031 | 514 | None |  | Coleophora ahenella
37.032 | 515 | C |  | [NAME]
37.033 | 516 | C |  | Coleophora trifolii
Spreadsheet: 189508d1351200862-match-data-between-sheets-match-sample-question
Sheet: Prod

281a39 | hi | Is there a function that can match of unlinked values from 'prod' to 'data', then pull the associated data into the B column? (So if A10  = Data!A6 then B10 = Data!B6)
281a79
281b02
281b66
281b71
281b80
281d56
283331
283344
284091
284091
284310
284c57
284c57
284c58
290170
290204
290321
290354
290368
290386
Spreadsheet: 25692d1217170702-counting-duplicates-within-a-date-range-exampledate1
Sheet: Sheet1

Customer Name | Customer Last Name | Company Name | Region | Source Code | U$S | Creation date |  |  | Summary
Juan | [NAME] | ITAU | Sur | Q1_breakfast_hilton | 11000 | 2008-07-14 00:00:00
Alberto | [NAME] | BBCS | Sur | Q1_breakfast_hilton | 90000 | 2008-07-18 00:00:00 |  |  | Period | U$S | # | Average
Jaime | Rotundo | Makro | Sur | Q1_breakfast_hilton | 17800 | 2008-07-13 00:00:00 |  |  | Creation Period
Rodrigo | Schoum | Bansud | Sur | Q4_LAUNCH_11 | 12000 | 2008-07-07 00:00:00 |  |  | 7 days ago | 0 | 0
Jorge | Bazan | Bansud | Sur | Q4_LAUNCH_11 | 50000 | 2008-07-08 00:00:00 |  |  | 15 days ago | 118800 | 3 | 39600
Belen | Bapoz | [NAME] | Sur | Q2_COCKTAIL_BO | 2300 | 2008-06-30 00:00:00 |  |  | 30 days ago | 326250 | 8 | 40781.25
Josefa | [NAME] | Ainco | Sur | Q2_COCKTAIL_BO | 150 | 2008-06-29 00:00:00 |  |  | YTD | 326250 | 8 | 40781.25
Marian | Jones | INCA | Sur | Q4_LAUNCH_11 | 143000 | 2008-06-28 00:00:00
Spreadsheet: 164402d1340746395-add-rows-if-referenced-cells-in-another-sheet-contain-data-excel-help
Sheet: Sheet6

Job: | #N/A |  | Description: | Pit Frames and Hatches |  |  |  |  |  |  |  |  | Reference
Phase: | 40 |  | Comment: |  |  |  |  |  |  |  |  |  |  | Type: | Drawing number:
Date: | 2012-06-26 17:24:24 |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  | Exclusions and Qualifications: |  |  |  |  |  |  |  |  |  | 2
Drawing Reference |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  | Notes
 |  |  |  |  |  |  |  |  |  |  |  |  |  | LF/SF: | Quantities: | Connections: | Material: | Finish:
 |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  | Other
Spreadsheet: 781703d1653495165-how-to-index-match-a-cell-that-has-formula-with-another-sheet-reference-efwitherror-fixed-aligw-with-2-dexter2-
Sheet: Sheet2

ID | Start | End | Begin | Last |  | ID | Total Places |  | ID | Unique
101 |  |  |  |  |  | 101 |  |  | 102
102 |  |  |  |  |  | 102 |  |  | 103
 |  |  |  |  |  | 103 |  |  | 101
 |  |  |  |  |  | 101 |  |  | 101