tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 94690d1294424221-excel-2007-index-formula-copy-of-help
Sheet: Sheet2

data
 |  |  |  | [NAME]
912828PM6 | 315.1302095343181 |  |  | 912828PW4
912828PW4 | 34 |  |  |  | FORMULA | GOES HERE
912828PL8 | 80
912828PM6 | -412
912828PN4 | -515
912828PM6 | 114.7235781622218
912828PW4 | 10.51969277551341
912828PW4 | -26.61426587745434
912828PL8 | 52.30555811428707
912828PL8 | -148.6510081350195
912828PL8 | -31.45150265493742
912828PM6 | -6.148904103137898
912828PW4 | 44.22273107013118
912828PW4 | 47.26604581018324
912828PL8 | -36.18271671316359
912828PN4 | 509.6006752350447
#N/A Invalid Security | #[NAME]!
#N/A Invalid Security | #[NAME]!
#N/A Invalid Security | #[NAME]!
#N/A Invalid Security | #[NAME]!
#N/A Invalid Security | #[NAME]!
#N/A Invalid Security | #[NAME]!
#N/A Invalid Security | #[NAME]!
#N/A Invalid Security | #[NAME]!
#N/A Invalid Security | #[NAME]!
#N/A Invalid Security | #[NAME]!
#N/A Invalid Security | #[NAME]!
#N/A Invalid Security | #[NAME]!
#N/A Invalid Security | #[NAME]!
#N/A Invalid Security | #[NAME]!
#N/A Invalid Security | #[NAME]!
#N/A Invalid Security | #[NAME]!
#N/A Invalid Security | #[NAME]!
#N/A Invalid Security | #[NAME]!
#N/A Invalid Security | #[NAME]!
#N/A Invalid Security | #[NAME]!
#N/A Invalid Security | #[NAME]!
#N/A Invalid Security | #[NAME]!
#N/A Invalid Security | #[NAME]!
#N/A Invalid Security | #[NAME]!
#N/A Invalid Security | #[NAME]!
#N/A Invalid Security | #[NAME]!
#N/A Invalid Security | #[NAME]!
#N/A Invalid Security | #[NAME]!
#N/A Invalid Security | #[NAME]!
#N/A Invalid Security | #[NAME]!
#N/A Invalid Security | #[NAME]!
#N/A Invalid Security | #[NAME]!
#N/A Invalid Security | #[NAME]!
#N/A Invalid Security | #[NAME]!
Spreadsheet: 966239c5-8e48-40bf-be60-2c5bdb3131a1
Sheet: Spring 2016

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
[NAME] (including [NAME])
Spring 2016
Subject | Course and Title | Subtitle/Alternate Title | Section | [NAME] | Part of Term | Dates | Days | Times | Credits | Instructor(s) | Instructor ID | FT or Adj | Contract Code | Percentage | Registration Approval | [NAME] | Blackboard Y/N | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list?   SUBJ CRSE SEC | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 714e4973-6678-45b4-8e18-d5546ce5da1e
Sheet: Rev 3430

 |  | REQUEST FOR SUPPLEMENTAL REVENUE
 |  | CITY  OF  KANSAS  CITY,  MISSOURI
 |  |  | DEPARTMENT: |  |  | Finance
BUSINESS UNIT: |  |  |  | KCMBU |  | DATE: |  | 2012-04-05 00:00:00 |  | JOURNAL ID:
LEDGER GROUP: |  |  |  |  | REVENUE
 |  | FUND |  | DEPT ID |  | ACCOUNT |  | PROJECT |  | AMOUNT |  | INC/DEC
AL |  | 3430 |  | 120000 |  | 590000 |  |  |  | 40280000 |  | I
AL |  | 3430 |  | 120000 |  | 503290 |  |  |  | 1545000 |  | I
AL |  | 3430 |  | 120000 |  | 503980 |  |  |  | 3006245 |  | I
AL
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL
[NAME]:
APPROVED BY: |  |  |  |  |  | DATE |  | APPROVED BY:  DEPARTMENT HEAD |  |  |  |  |  | DATE
Spreadsheet: 848942d1699540028-pivot-table-how-to-add-an-extra-grand-total-column-for-min-and-max-excel-pivot-min-max
Sheet: Sheet1

Store | Product | Price
Red | Product 1 MIN | 124
Red | Product 1 MAX
Red | Product 2 MIN | 125
Red | Product 2 MAX
Red | Product 3 MIN | 126
Red | Product 3 MAX
Red | Product 4 MIN | 177
Red | Product 4 MAX
Red | Product 5 MIN | 128
Red | Product 5 MAX
Blue | Product 1 MIN | 129
Blue | Product 1 MAX
Blue | Product 2 MIN | 130
Blue | Product 2 MAX | 202
Blue | Product 3 MIN | 131
Blue | Product 3 MAX
Blue | Product 4 MIN | 132
Blue | Product 4 MAX
Blue | Product 5 MIN | 133
Blue | Product 5 MAX
White | Product 1 MIN | 134
White | Product 1 MAX
White | Product 2 MIN | 135
White | Product 2 MAX
White | Product 3 MIN | 136
White | Product 3 MAX
White | Product 4 MIN | 99
White | Product 4 MAX | 114
White | Product 5 MIN | 138
White | Product 5 MAX
Pink | Product 1 MIN | 139
Pink | Product 1 MAX
Pink | Product 2 MIN | 140
Pink | Product 2 MAX
Pink | Product 3 MIN | 141
Pink | Product 3 MAX
Pink | Product 4 MIN | 142
Pink | Product 4 MAX
Pink | Product 5 MIN | 143
Pink | Product 5 MAX
Spreadsheet: 81948d1282054375-calculate-nr-in-formula-r-r-mf-r-pt-nr-book1_azavasky
Sheet: Sheet1

Limit | 15 |  |  | Your Formula |  |  |  |  | I think it might possibly be
 |  |  |  | R + (R * MF) + (R * PT) = NR |  |  |  |  | R + (R * MF) + (R + (R * MF) )* PT = NR
 | [NAME]
R <=Limit | 3 |  |  | R | MF | PT | NR |  | R | MF | PT | NR
R >Limit | 0.25 |  |  | 15.1 | 3.775 | 1.51 | 20.385 |  | 15.1 | 3.775 | 1.8875 | 20.7625
PT | 0.1 |  |  | 15.1 | 3.775 | 1.510000000000003 | 20.385 |  | 15.1 | 3.774999999999999 | 1.887500000000003 | 20.7625
 |  |  | N.B. | If B4/B1 as a percentage is greater than B5 the flat rate result is displayed when the figures overlap.
 |  |  |  | This can appear to be an error but it actually is correct.
 |  |  |  | There are in these case two possible answers, and it is not possile to say which one of the two NR represents
 |  |  | LEGEND | R | Rate in $AUD
 |  |  |  | MF | fee for service (Management Fee). This will be a fixed amount if under a certain amount or a % if over the limit.
 |  |  |  | PT | Govt tax (Payroll Tax). This will be defined as absolute.
 |  |  |  | NR | New Rate or adjusted rate.
Spreadsheet: 732877d1621280548-find-average-hours-of-last-n-months-for-employee-example-book
Sheet: Sheet1

Employee Number | Hours Per Month | Year & Month
1 | 150 | 202002
1 | 160 | 202003
1 | 160 | 202004 |  |  | Employee 1
1 | 165 | 202005 |  |  | Employee 2
1 | 166 | 202006
1 | 168 | 202007
1 | 156 | 202008
1 | 145 | 202009
1 | 174 | 202010
1 | 178 | 202011
1 | 200 | 202012
1 | 200 | 202101
1 | 140 | 202102
1 | 145 | 202103
1 | 145 | 202104
2 | 150 | 202002
2 | 155 | 202003
2 | 156 | 202004
2 | 174 | 202005
2 | 146 | 202006
2 | 183 | 202007
2 | 155 | 202008
2 | 167 | 202009
2 | 166 | 202010
2 | 146 | 202011
Spreadsheet: 275319d1383445261-breaking-ties-using-vlookup-if-etc-book1
Sheet: scores

 |  | GAME 1 | GAME 2 | GAME 3 | GAME 4 | GAME 5 | GAME 6 | GAME 7 | GAME 8 | GAME 9 | TOTAL
#4 | RADER | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
 | JONES | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
#5 | LANCIA | 11 | 15 | 15 | 6 | 7 | 8 | 9 | 10 | 11
 | JOE | 11 | 17 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | LONG | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | NEWELL | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14
 | [NAME] | 7 | 18 | 22 | 10 | 11 | 12 | 13 | 14 | 15
 | KISS | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
Spreadsheet: 869375d1715948263-copying-data-to-next-line-and-remove-old-line-book1
Sheet: Sheet1

object network Flex_webservices.mf.nl_2 |  |  |  | description [NAME] helloflexgroup
host 82.161.207.74 |  | object network Flex_webservices.mf.nl_3 |  | description [NAME] helloflexgroep
description [NAME] helloflexgroup |  | object network Locatie_MF_Emmen
object network Flex_webservices.mf.nl_3 |  | object network WSUS_NAT |  | description t.b.v. AlwaysOnVPN
host 213.127.203.44 |  | object network o365-smtp
description [NAME] helloflexgroep |  | object network o365-outlook-1
object network Locatie_MF_Emmen
subnet 192.168.58.0 255.255.255.0
object network WSUS_NAT
host 192.168.61.35
description t.b.v. AlwaysOnVPN
object network o365-smtp
fqdn v4 smtp.office365.com
object network o365-outlook-1
subnet 40.92.0.0 255.254.0.0
Spreadsheet: 868599d1715279614-generate-spill-array-to-determine-the-performance-of-a-department-grades
Sheet: Sheet1

 | Excellent | Good | Better | Fair | Poor | % |  |  |  | Criteria
Department-1 |  |  | ü |  |  | 0.67 |  |  |  | Min | [NAME]
Department-2 |  |  |  | ü |  | 0.54 |  |  | Poor | 0 | 0.4
Department-3 | ü |  |  |  |  | 0.89 |  |  | Fair | 0.4 | 0.6
[NAME] | ü |  |  |  |  | 0.9 |  |  | Better | 0.6 | 0.7
Department-5 |  |  |  | ü |  | 0.49 |  |  | Good | 0.7 | 0.85
Department-6 |  | ü |  |  |  | 0.7 |  |  | Excellent | 0.85 | 1
Department-7 | ü |  |  |  |  | 0.85
Department-8 |  |  |  |  | ü | 0.36
Spreadsheet: 267313d1380041798-data-validation-list-with-a-mouse-over-descriptor-data-validation-example
Sheet: Sheet3

 | Cost Code
 |  |  |  |  |  | T-000 | Training Expenses
 |  |  |  |  |  | E1-000 | [NAME] Dept Expens
 |  |  |  |  |  | M1-000 | [NAME]
 |  |  |  |  |  | M1-200 | [NAME]
 |  |  |  |  |  | M1-205 | [NAME]
[NAME] is the Validation Cell, Is there a way when you go |  |  |  |  |  | M1-210 | Machining Foremen
into the dropdown, and any item(G5:G100) is highlighted, |  |  |  |  |  | M1-212 | Maching Gen Formn
that a popup(if you will) would show the corresponding |  |  |  |  |  | M1-217 | Site Access Tring
description of the highlighted code from Column H??? |  |  |  |  |  | M1-225 | Machining QC
 |  |  |  |  |  | M1-228 | [NAME]. Engineering
For instance…If I mouse hover in B5  M1-230…a popup |  |  |  |  |  | M1-230 | Machining E-Techs
will give the the description Machining E-techs. |  |  |  |  |  | M1-235 | Machining Mchnsts
This is just a sample list of codes…I have 3 sheets of them |  |  |  |  |  | M1-236 | Machinist Ovrsght
I will have to work with. |  |  |  |  |  | M1-237 | Machinist - Union
 |  |  |  |  |  | M1-240 | Machining - Admin
 |  |  |  |  |  | M1-245 | Machining Safety
 |  |  |  |  |  | M1-250 | Mach Site Per Dm
 |  |  |  |  |  | M1-260 | Mach Travel Time
 |  |  |  |  |  | M1-265 | PM Travel
 |  |  |  |  |  | M1-300 | [NAME] Vehicl Expns
 |  |  |  |  |  | M1-350 | Mach Auto Rental
 |  |  |  |  |  | M1-360 | Mach - Hotel
 |  |  |  |  |  | M1-400 | Mach Consumables
 |  |  |  |  |  | M1-410 | [NAME]
 |  |  |  |  |  | M1-425 | Mach Material
 |  |  |  |  |  | M1-450 | [NAME]
 |  |  |  |  |  | M1-500 | [NAME] Equip Rental
 |  |  |  |  |  | M1-600 | Mach Mob/Demob
 |  |  |  |  |  | M1-700 | Mach Subcontracts
 |  |  |  |  |  | M1-800 | [NAME]
 |  |  |  |  |  | M1-801 | Mach-Repair Parts
 |  |  |  |  |  | M1-802 | Machining Eqpment
 |  |  |  |  |  | M1-805 | Maching Smll Tls
 |  |  |  |  |  | M1-806 | Mch Ar/El Hnd Tls
 |  |  |  |  |  | M1-820 | [NAME] Mock Ups
 |  |  |  |  |  | M1-850 | [NAME]
 |  |  |  |  |  | M1-860 | [NAME] Tckts
Spreadsheet: 836095d1689087385-depreciation-calculator-depreciation
Sheet: Sheet1 (2)

 | 2023-12-31 00:00:00
 | Purchase Date | Amount | Rate | Days | Depreciation | 2023-04-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Total | Diff
 | 2023-03-31 00:00:00 | 49000 | 0.31
 | 2009-12-06 00:00:00 | 49000 | 0.31
 | 2023-02-28 00:00:00 | 49000 | 0.31
 | 2023-04-20 00:00:00 | 49000 | 0.31
 | 2024-01-31 00:00:00 | 49000 | 0.31
Spreadsheet: 715379d1611679346-autofill-with-same-pattern-autofill-club-info-ans
Sheet: Sheet1

Lewington | [NAME] | [NAME] | Krasniqi↓ | Elokobi | Corne | Rendell | Amalulzor↓ | Pattison↓ | Ellul | [NAME] |  |  | Start | Subbed
Lewington | [NAME] | [NAME] | Krasniqi | Seaman | Elokobi | Porter | Corne | Rendell | Ellul | [NAME] |  | [NAME] |  |  |  |  |  | Len(M2)-Find(" ", [NAME])
Lewington | [NAME] | [NAME] | Krasniqi | Seaman↓ | Elokobi | Porter | Rendell | Amaluzor | Ellul | Khan↓ |  | [NAME]
Constable | [NAME] | [NAME] | Krasniqi↓ | Seaman↓ | Elokobi | Porter | Corne | Rendell | Ellul | Pattison↓ |  | Raphe Brown
Lewington | [NAME] | [NAME] | Luque↓ | Elokobi | Porter | Corne | Rendell | Amaluzor↓ | Ellul | Odusanya↓ |  | [NAME]
Lewington | [NAME] | [NAME] | Seaman↓ | Elokobi | Porter | Corne | Rendell | Luque↓ | Ellul | Odusanya↓ |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Christie Pattison
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 1fb5e99c-7334-498c-91c3-eb6ff03b76fd
Sheet: Sheet1

stock description | origin | notes | synonym | Unnamed: 4
1-12    y Hmr v
1-13    w[1118]
1-16     C(1)RM, y pn v/Y[S]XY[L] In(1)EN, y B/0
1-17   y w/Y,  P{y[+t7.7]=CARY.attP}19
1-18    y[2] v f
1-2     C(1)M4, y[2]/y [NAME]] f mal/y[+]Y
1-21     w[1118] P{w[+mC]=FRT(w[+])Tub-PBac\T}A1
1-27     y w  P{w[+mC]=hs-hid}
1-30     Df(1)sc-B57, [NAME]] sn[3]/In(1)FM7a, y[31d] sc[8] w[a] sn v B P{lacZ-eve}
1-31    Ubi-RFP (Tomato) X2
1-32      C(1)DX, y w f/y [NAME]] f mal/y[+]Y
1-45     w[hd80k17]
1-49    In(1)AB
1-52    In(1)dl-49, y w f
1-57      C(1)M4, y[2]/B[S]Y
1-67      In(1)AB, f (M1)/C(1)M4, y[2]
1-68      ovo[D1] v[24]/C(1)DX, y f
1-69    w m f
1-9      Y, P{w[+mC]=hs-hid}
1-97      C(1)DX, f/FM7i, y[93j] sc[8] w oc ptg B P{w[+mC]=ActGFP}
12-100     y w M(eGFP, vas-int, dmRFP) ZH-2A; M(attP)ZH-51D
12-101 (y) w/Y, hs-hid; J6
12-102    w[1118]; Sp, P{w[+mC]=hs-hid}/CyO
12-103     w[1118]; CyO, P{w[+mC]=FRT(w[+])Tub-PBac\T}2/wg[Sp-1]
12-104      y[1] M{vas-int.Dm}ZH-2A w*; M{3xP3-RFP.attP'}ZH-51C
Spreadsheet: 771801d1646854036-nested-ifs-with-index-function-query-sample-data
Sheet: Condensed Data

SupplierCategory | SupplierName | ControlName | RAGStatusName
N/A | Supplier 1 | Control 1 | Green
N/A | Supplier 1 | Control 1 | Green
N/A | Supplier 1 | Control 1 | Red
N/A | Supplier 1 | Control 2 | Green
N/A | Supplier 1 | Control 2 | Red
N/A | Supplier 1 | Control 3 | Green
N/A | Supplier 1 | Control 3 | Green
N/A | Supplier 1 | Control 3 | Green
N/A | Supplier 1 | Control 3 | Green
N/A | Supplier 1 | Control 3 | Green
N/A | Supplier 1 | Control 3 | Green
N/A | Supplier 1 | Control 3 | Green
N/A | Supplier 1 | Control 3 | Green
N/A | Supplier 1 | Control 4 | Green
N/A | Supplier 1 | Control 4 | Green
N/A | Supplier 2 | Control 1 | Red
N/A | Supplier 2 | Control 1 | Red
N/A | Supplier 2 | Control 2 | Green
N/A | Supplier 2 | Control 2 | Green
Spreadsheet: 845399d1696935172-formula-for-total-to-stop-at-0-distro-example-ans
Sheet: Distro List 

 |  |  |  |  |  |  |  |  |  |  | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE | STORE
 |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 5 | 6 | 9 | 14 | 17 | 18 | 21 | 22 | 30 | 32 | 36 | 42 | 43 | 46 | 50 | 51 | 52 | 57 | 80 | 12 | 13 | 19 | 29 | 35 | 39 | 41 | 44 | 47 | 55 | 56 | 59 | 65 |  | total | ATS | REMAINING
SIZE | Item | Style Description | material |  |  |  | a | b | c | d | a | b | b | a | c | b | a | b | c | c | a | c | a | b | c | c | b | c | a | c | c | a | a | a | a | b | a | b | a | b | a | a | b | a
 | Cards
 | Cards |  |  |  |  |  | 300 | 250 | 250
 |  |  |  |  |  |  | 500 | 600 | 800
 | Items
 | SNAP WALLET: 1
 | SNAP WALLET: 2
 | SNAP WALLET: 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 159593d1338767549-need-text-to-appear-when-conditions-met-my-excel-headache
Sheet: Sheet1

 | Post name | Employee# | User Name | Duty On | Duty Off | Duty Time | Duty On (rounded) | Duty Off (rounded) | Duty Time (rounded) | comments
 | 1300~10020~EA-G11 |  |  | 6/1/2012 11:01:41 AM | 6/1/2012 2:18:07 PM | 3:16 | 6/1/2012 11:00:00 AM | 6/1/2012 2:15:00 PM | 3:15 |  | Cells B-F are not important for final report. Cell A-J need to alternate color based on Post listed in cell [NAME] for G is: =$h2<$g3. I need that to result in cell J comment "change"
 | 1300~10020~EA-G11 |  |  | 6/1/2012 2:32:11 PM | 6/1/2012 2:32:56 PM | 0:01 | 6/1/2012 2:30:00 PM | 6/1/2012 2:30:00 PM | 0:00
 | 1300~10020~EA-G11 |  |  | 6/1/2012 2:35:38 PM | 6/1/2012 7:08:40 PM | 4:33 | 6/1/2012 2:30:00 PM | 6/1/2012 7:15:00 PM | 4:45
 | 1300~10020~EA-G13 |  |  | 6/1/2012 6:07:46 AM | 6/1/2012 7:28:40 AM | 1:21 | 6/1/2012 6:15:00 AM | 6/1/2012 7:30:00 AM | 1:15
Spreadsheet: 22641aee-7541-416e-9b10-4380c38de7ec
Sheet: Sheet1

2227 | BLC | WGS | 201 | 15Z2 | 2013-06-27 00:00:00 | 2013-08-08 00:00:00 | [NAME] [NAME] | TBA | 32 | BW | LEC | 3 | Houghton,[NAME]
2228 | BLC | WGS | 201 | 15Z3 | 2013-06-27 00:00:00 | 2013-08-08 00:00:00 | [NAME] [NAME] | TBA | 32 | BW | LEC | 3 | Houghton,[NAME]
Spreadsheet: 150565d1334602720-sign-pricing-grid-for-estimating-signs-sign-estimating
Sheet: Sheet3

 |  |  |  | Screen Printing
 |  |  |  | Art  -   Screens  -   Film
233-A Jefferson Street • Newnan, GA 30263 |  |  |  | Phone: [PHONE]
 | Quantity
COLOR | 12 | 36 | 72 | 144 | 288 | 600
1 | 1.6 | 1.1 | 0.95 | 0.85 | 0.7 | 0.6
2 | 2.2 | 1.35 | 1.2 | 0.95 | 0.8 | 0.7
3 | 3.25 | 1.5 | 1.35 | 1.1 | 0.9 | 0.8
4 | 4 | 1.65 | 1.55 | 1.2 | 1.15 | 0.9
5 |  | 2.1 | 1.8 | 1.35 | 1.3 | 1.15
6 |  |  |  | 1.75 | 1.49 | 1.25
Process |  |  | 2.25 | 1.75 | 1.5 | 1.35
Artwork to Film |  |  |  | 10 | Per Color
Screen charges |  |  |  | 15 | a screen
re-order screens |  |  |  | 15 | re-burn per screen
color changes |  |  |  | 10 | per change
sleeve,pant,special locations |  |  |  | 0.15 | per location
Fleece Charge |  |  |  | 0.25 | per location
3% MISPRINT ALLOWANCE ON ALL JOBS PER INDUSTRY STANDARD
Spreadsheet: 218804d1362585279-football-league-table-database
Sheet: Sumário - Tabela 2-3-1-1-1-1-11

Jornada | 12
Arsenal | 3 | 3 | [NAME]
Liverpool | 2 | 1 | Wigan Athletic
Manchester City | 0 | 0 | [NAME]
Newcastle United | 1 | 1 | Swansea City
Queen Parks Rangers | 1 | 0 | Southampton
Reading | 1 | 2 | Everton
West Bromwich Albion | 2 | 3 | Chelsea
Norwich City | 2 | 1 | [NAME]
Fulham | 0 | 1 | Sunderland
West Ham United | 1 | 1 | Stoke City
Spreadsheet: 840151d1692490236-find-first-date-instance-in-latest-month-latest-month-solution-
Sheet: Sheet1

2022-07-01 00:00:00
2022-07-10 00:00:00
2023-02-26 00:00:00
2023-03-04 00:00:00 |  | First date instance of the latest month
2023-03-25 00:00:00 |  | (May not be current month)
2023-04-02 00:00:00 |  | 2023-07-02 00:00:00 | Expected result
2023-04-08 00:00:00
2023-05-04 00:00:00
2023-05-07 00:00:00
2023-05-18 00:00:00
2023-05-28 00:00:00
2023-06-04 00:00:00
2023-06-10 00:00:00
2023-06-18 00:00:00
2023-06-22 00:00:00
2023-06-24 00:00:00
2023-07-02 00:00:00
2023-07-17 00:00:00
2023-07-17 00:00:00
2023-07-27 00:00:00
Spreadsheet: df46a72b-0cc6-418e-8757-5709ff8ba404
Sheet: Sheet1

Date | Sport | Opponent | Time_Results
10/16/2010 | Women's Swimming | PENN STATE | L, 67-174
10/23/2010 | Women's Swimming | at [NAME] | W, 170.5-124.5
11/05/2010 | Women's Swimming | at Louisville | L, 105-186
11/06/2010 | Women's Swimming | at Cincinnati | L, 130-162
11/13/2010 | Women's Swimming | RUTGERS | W, 148-146
11/18/2010 | Women's Swimming | UNC Nike Cup (Chapel Hill, N.C.) | 5th place
11/19/2010 | Women's Swimming | UNC Nike Cup (Chapel Hill, N.C.) | 4th place
11/20/2010 | Women's Swimming | UNC Nike Cup (Chapel Hill, N.C.) | 4th place
12/31/2010 | Women's Swimming | at UC Santa Barbara | L, 103-158
01/08/2011 | Women's Swimming | at Pitt | L, 104-194
01/22/2011 | Women's Swimming | MARYLAND | L, 96-202
01/29/2011 | Women's Swimming | OHIO | L, 122-176
02/16/2011 | Women's Swimming | BIG EAST Swimming Championships (Louisville, Ky.) | 7th place
02/17/2011 | Women's Swimming | BIG EAST Swimming Championships (Louisville, Ky.) | 4th place
02/18/2011 | Women's Swimming | BIG EAST Swimming Championships (Louisville, Ky.) | 3rd place
02/19/2011 | Women's Swimming | BIG EAST Swimming Championships (Louisville, Ky.) | 3rd place
03/03/2011 | Women's Swimming | Indianapolis Grand Prix (Indianapolis, Ind.) | 9:00 a.m.
03/04/2011 | Women's Swimming | Indianapolis Grand Prix (Indianapolis, Ind.) | 9:00 a.m.
03/05/2011 | Women's Swimming | Indianapolis Grand Prix (Indianapolis, Ind.) | 9:00 a.m.
03/06/2011 | Women's Swimming | Indianapolis Grand Prix (Indianapolis, Ind.) | 9:00 a.m.
03/17/2011 | Women's Swimming | NCAA Women's Championships (Austin, Texas) | Noon
03/18/2011 | Women's Swimming | NCAA Women's Championships (Austin, Texas) | Noon
03/19/2011 | Women's Swimming | NCAA Women's Championships (Austin, Texas) | Noon
Spreadsheet: 52232d1251932902-combining-production-data-example
Sheet: Sheet1

Date | Production Days | [NAME] | Mo Oil Prod bbl | Mo Gas Prod Mcf | Mo Water Prod bbl | % Water | RGP lb | Oil Accum Mbbl | Gas [NAME] | Water Accum Mbbl | Water Inj Days | Real Rate Water Inj bbl/d | Volume [NAME]
19550501 | Totals for all these parameters for all wells with data on May 1st 1955
19550601 | Totals for all these parameters for all wells with data on June 1st 1955
19550701 | Totals for all these parameters for all wells with data on July 1st 1955
19550801 | Totals for all these parameters for all wells with data on August 1st 1955
19550901 | Totals for all these parameters for all wells with data on September 1st 1955
19551001 | Totals for all these parameters for all wells with data on October 1st 1955
19551101 | Totals for all these parameters for all wells with data on November 1st 1955
Spreadsheet: darrell_schoolcraft__7306__imball0201
Sheet: burlington

56423
Day | Measured | Scheduled | Imbal
1 | 165610 | 167344
2 | 166480 | 167796
3 | 137938 | 137645
4 | 125026 | 124963
5 | 146499 | 137011
6 | 145029 | 145160
7 | 142059 | 140564
8 | 158164 | 152788
9 | 146091 | 145561
10 | 170217 | 161989
11 | 155187 | 155406
12 | 142391 | 140202
13 | 133550 | 132844
14 | 132177 | 132427
15 | 129024 | 129066
16 | 119611 | 118469
17 | 128131 | 126618
18 | 122429 | 121479
19 | 118760 | 118536
20 | 125436 | 125694
21
22
23
24
25
26
27
28
29
30
31
 |  |  |  |  |  |  | 20
2001-12-31 00:00:00 |  |  | 47594.94 |  |  |  | 530
2002-01-20 00:00:00
 |  |  |  |  |  |  | 5989
CBS Volume
 |  |  | 20411
Spreadsheet: 728253d1618393140-rotation-shift-rotation-schedule-multiple-employees
Sheet: Help

HELP
[NAME] |  |  | © 2013-2018 Vertex42 LLC
[NAME]
 | This template uses the NETWORKDAYS.INTL function (available in Excel 2010 or later) to exclude weekends and holidays from the rotation schedule.
 | First, edit the input cells in the header area (year, month, etc.)
 | Edit the employee names in the rotation schedule.
 | To define the rotation for an employee, enter a repeating pattern as a string, such as "AABBxxx" or "AAxxxAAxxAAAxx" or "AABBCCDD".
 | You can change the letters from D,N,A,B (in cells U3:[NAME]) to other letters of your choosing, but if you use numbers, enter the numbers as text by placing an apostrophe before the number like '2.
Adding Rows for More Employees
 | To add another employee, select the row under the last employee in a particular month and right-click on the row number and select [NAME]. Then press CTRL+d to copy the formulas and formatting from the row immediately above the new row you have selected.
Weekends, Holidays, and Non-Working Days
 | Dates listed in the Holidays worksheet are considered "non-working days" and are highlighted in the schedule. You can edit the list to add your own non-working days.
 | No Holidays or Non-Working Days
 | To set up the rotation so that there are NO holidays or non-working days, choose "None" from the drop-down box under "Non Working Days" ... or choose "Holidays" from the drop-down box and delete all but one of the dates in the Holidays worksheet. Set the remaining date to some time in the past like 1/1/1980.
Using the Blank Rows
 | Under the rows labeled Pay Days, there are a couple blank rows that you can use for entering other information. You can manually highlight the cells as needed. You can insert more blank rows as needed.
Changing Colors
 | The template uses a fairly complex set of conditional formatting conditions to automatically highlight different shifts different colors and to format non-working days, and other cells.
 | To change colors for the Conditional Formatting rules, go to Home > Conditional Formatting > Manage Rules and select "This Worksheet" from the drop-down box to see and edit the rules.
Additional Help
 | The link at the top of this worksheet will take you to the web page on vertex42.com that talks about this template.
 | REFERENCES
TIPS | Vertex42.com Blog: Excel [NAME]
Spreadsheet: 749033d1632478517-how-to-select-rows-with-specific-difference-from-reference-row-selecting-rows
Sheet: Sheet1

data I have |  |  | I wish to get |  |  | Criteria
item | dp |  | item | dp |  | item | dp <=
1 | 911 |  |  |  |  | 6 | 100
2 | 925
3 | 934
4 | 980
5 | 1000
6 | 1020
7 | 1040
8 | 1075
9 | 1090
10 | 110