tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 03e5baba-4fd1-4d3b-81c5-5745782ba9fa
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 8731.0 Building Approvals, Australia
 | TABLE 37. Value of Building Approved - Australian Capital Territory
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Value of Approval ;  Australian Capital Territory ;  Total residential building ;  New ; |  |  | Original | A420494A | 1970-07-01 00:00:00 | 2011-03-01 00:00:00 | 489 | $'000 | FLOW | Month | 1
Value of Approval ;  Australian Capital Territory ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A420503T | 1973-07-01 00:00:00 | 2011-03-01 00:00:00 | 453 | $'000 | FLOW | Month | 1
Value of Approval ;  Australian Capital Territory ;  Total residential building ;  Total (Type of work) ; |  |  | Original | A420515A | 1973-07-01 00:00:00 | 2011-03-01 00:00:00 | 453 | $'000 | FLOW | Month | 1
Value of Approval ;  Australian Capital Territory ;  Total non-residential building ;  Total (Type of work) ; |  |  | Original | A421178T | 1970-07-01 00:00:00 | 2011-03-01 00:00:00 | 489 | $'000 | FLOW | Month | 1
Value of Approval ;  Australian Capital Territory ;  Total building ;  Total (Type of work) ; |  |  | Original | A422865L | 1973-07-01 00:00:00 | 2011-03-01 00:00:00 | 453 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 868256d1715001298-array-formula-help-tool-change-log-1-
Sheet: Sheet1

Tool Change Log
Operator | Machine | Part Count | Tool Changed | Reason
[NAME] | 2 | 5 |  |  |  |  |  | 5
[NAME] | 2 | 4 |  |  |  | 4 |  | 4 | [NAME]
[NAME] | 3 | 5 |  |  |  |  |  | 36 | [NAME]
[NAME] | 4 | 4 |  |  |  |  | 36 | 5 | [NAME]
[NAME] | 5 | 5 |  |  |  |  |  | 4 | [NAME]
[NAME] | 6 | 4 |  |  |  |  | 4 |  | [NAME]
[NAME] | 2 | 5 |  |  |  |  |  |  | [NAME]
[NAME] | 2 | 36 |  |  |  | 36 | #REF! |  | [NAME]
[NAME] | 2 | 5 |  |  |  | 5 | #[NAME]! |  | [NAME]
[NAME] | 5 | 4 |  |  |  |  | #[NAME]! |  | [NAME]
[NAME] | 2 | 5 |  |  |  |  | #[NAME]! |  | [NAME]
[NAME] | 2 | 4 |  |  |  | 4 | #[NAME]! |  | [NAME]
[NAME] | 3 | 5 |  |  |  |  | #[NAME]! |  | [NAME]
[NAME] | 6 | 4 |  |  |  |  | #[NAME]! |  | [NAME]
Spreadsheet: 799714d1665228925-case-sensitive-with-match-while-using-arrays-excel_help-hd
Sheet: control-2arrays

UNMATCH: |  | (case-unsensitive) |  | =SUMPRODUCT((1*ISNA(MATCH(A4&A5:A1000,E5:E10&F5:F10,0))=1)*(A5:A1000<>"")*1)
 | ? | (case-sensitive)
grade | location |  |  | label | value
A | US |  |  | location | MX
A | DE |  |  | grade | A
B | MX |  |  | grade | B
C | US |  |  | location | US
D | DE |  |  | location | NL
a | MX |  |  | grade | C
F | US
A | DE
A | MX
B | FR
B | DE
D | MX
A | FR
B | US
Spreadsheet: 715504d1611745491-creating-a-condensed-list-using-formulas-forumans
Sheet: Result

Sl.No | Farmer | Survey | Crop Sublist | Extent
1 | Kannan A | 63-1 | Cotton | 0.74
 |  | 28-1 | [NAME] | 1.52
 |  | 61-4 | Sugarcane | 1.25
 |  | 68-2, 61-7, 63-A, 61-4, 63-8, 61-4,63-4 | Pulses | 3.64
2 | [NAME] | 111-6, 55- | [NAME] | 3.17
3 | S.Chandrasekararajulu | 35-2 | [NAME] | 0.88
4 | Koussalya A | 19-1 | Cotton | 0.5
 |  | 34-1, 95-, 50-3 | [NAME] | 4.26
 |  | 18-2 | Black Gram | 0.7
5 | Gurusamy M | 54-4 | [NAME] | 1.06
6 | J Jeyaseela | 23-2 | Pulses | 0.42
7 | [NAME] | 110-8 | [NAME] | 0.89
8 | [NAME] | 101- | [NAME] | 1.8
 |  | 102-, 101- | Pulses | 1
Spreadsheet: darrell_schoolcraft__7639__OutageRequest for401 022502
Sheet: Sheet1

Enron Transportation Services
System Outage Request/Notification
 |  |  |  |  | Submittal Date:  1/11/2002
 |  |  | Planned: | xxxxx |  | Late: |  | Unplanned:
 | Region/Location: |  | [NAME]
 | Reported By: |  | [NAME] |  |  |  |  | New: | X | Revised
 | Telephone No: |  | [PHONE] |  |  | If a Revision Enter outage ID#
 |  |  |  |  |  | or the Original Est. Start Date
 | FAX No: |  | [PHONE]
 | Starting Date: |  | 2002-02-25 00:00:00 | Time: | 08:00 | Completion Date: |  | 2002-02-26 00:00:00 | Time: | 15:00
 | Descripition of Work: |  |  | Shut unit 401 down to perform bearing and power cylinder inspection and allow bearing company to measure for custome bearings.
 | Facilities Affected
 | Compressor Station: |  | Station 4 (transwestern Pipeline) |  |  |  |  | Estimated Volume: |  | 250 to 400 mcf
 |  |  | Units 401 |  |  |  |  | Horse Power: |  | 4000 hp
 | Services Affected
 | Mainline: |  | N/A |  |  |  |  | Aprox. [NAME]: |  | N/A
 | Branchline/Transmission: |  | N/A |  |  |  | Reduced Operation Pressure: |  |  | N/A
 |  | TBS: |  |  |  |  |  | Farmtap: |  | N/A
 | Comments: |  | This outage is in preparation for our April outage.
 | All Outages Fax Or E:mail To   ([NAME]) |  |  |  |  | fax# (713)-345-3478   Houston
 | Facility Planning               (Outage Coordinator) |  |  |  |  | fax# (402)-3987041     Omaha
 | For Unplanned Outages Add these Burst FAX Numbers ( Project Link):
 | ( For unplanned outages in the [NAME], Liberal, Mullinville & Amarillo Regions Only)
 | Oneok - Tulsa |  | [NAME] |  |  | (918) 732-1355 |  | ET&S Gas Control (Houston): |  |  | 7138539155
 | Oneok - Bushton |  | [NAME] |  |  | (316) 562-4373 |  | ET&S [NAME]: |  |  | 7136468000
 | Exxon-Mobil-Liberal |  | Ulysses |  |  | (316) 356-7580
 |  |  |  |  |  |  |  | Anadarko: |  |  | 3166294505
 | OXY-Liberal |  | [NAME] |  |  | (316) 624-7014
 | ETS - Liberal Operatons |  |  |  |  | (316) 626-2251
Spreadsheet: 109829d1306604542-multiple-strings-in-each-colomn-cell-to-be-compared-and-returned-with-similar-strings-multiple-string-compare
Sheet: Sheet2

 |  |  | 1 | 2 | 3 | 4 | 5 |  |  |  |  | Check-1 |  |  |  |  | Ch-2 |  |  |  |  | Ch-3 |  |  |  |  | [NAME] |  |  |  |  | Ch-5 |  |  |  |  | Comnine
A | TABLE1a Table2a TABLE5a TABLE5a TABLE10a | TABLE1a Table2a TABLE5a TABLE5a TABLE10a | TABLE1a | Table2a | TABLE5a | TABLE5a | TABLE10a |  |  |  |  |  |  |  |  |  | TABLE2a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TABLE2a
 | TABLE2a TABLE4a TABLE6a | TABLE2a TABLE4a TABLE6a | TABLE2a | TABLE4a | TABLE6a
B | TABLE1a TABLE3a TABLE4a TABLE10a | TABLE1a TABLE3a TABLE4a TABLE10a | TABLE1a | TABLE3a | TABLE4a | TABLE10a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TABLE10a |  |  |  |  |  |  |  | TABLE10a
 | TABLE2a TABLE9a TABLE10a | TABLE2a TABLE9a TABLE10a | TABLE2a | TABLE9a | TABLE10a
C | Table2a Table1a | Table2a Table1a | Table2a | Table1a |  |  |  |  |  |  |  |  |  |  |  |  | TABLE1a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TABLE1a
 | TABLE1a | TABLE1a | TABLE1a
D | TABLE3a TABLE10a Table6a | TABLE3a TABLE10a Table6a | TABLE3a | TABLE10a | Table6a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TABLE6a |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TABLE6a
 | TABLE6a | TABLE6a | TABLE6a
Spreadsheet: 794128d1661889171-fix-formula-to-get-unique-op-from-multiple-rows-unique-row-op
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Unique |  | Correct OP
A1 | B1 | C1 | A2 | B2 | C2 | A3 | B3 | [NAME] | A4 |  |  | A1
B2 | [NAME] | A1 | B3 | C4 | A2 | B4 | C5 | A3 | B5 |  |  | B2
A2 | B2 | B3 | A3 | B4 | B5 | A4 | B6 | B7 | A5 |  |  | A2
A3 | B4 | C5 | A4 | B5 | C6 | A5 | B6 | C7 | A6 |  |  | A3
A1 | B3 | C4 | A2 | B4 | C5 | A3 | B5 | C6 | A4 |  |  | B3 | B3 is correct because [NAME] is already above
B1 | C2 | A2 | B2 | [NAME] | A3 | B3 | C4 | A4 | B4 |  |  | B1
C1 | B2 | A3 | C2 | B3 | A4 | [NAME] | B4 | A5 | C4 |  |  | C2 | C2 is correct because B2 is already above
B2 | C2 | D2 | B3 | [NAME] | D3 | B4 | C4 | D4 | B5 |  |  | D2
A1 | D1 | B2 | A2 | D2 | B3 | A3 | D3 | B4 | AC1 |  |  | D1
D1 | B1 | C2 | D2 | B2 | [NAME] | D3 | B3 | C4 | D4 |  |  | D2
A3 | B2 | D2 | A4 | B3 | D3 | A5 | B4 | D4 | A6 |  |  | A4
Spreadsheet: 130301d1322161610-vlookup-help-example-workbook
Sheet: CMTS Service Group ID Lookup

 |  |  |  |  |  |  |  |  | Instructions: In the CMTS Selection field click the drop down and choose the CMTS you wish to search for information on. In the Service Group # [NAME] field enter in the service group number identified on the cable line card description in the CMTS in order to pull the specific information for that CMTS/Service Group.
 |  |  |  |  | CMTS Selection
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cornerstone Data Last Updated: 11/24/2011
 |  |  |  |  | Service Group # [NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] Last Updated: 11/24/2011
 | Las Vegas Node Combining Plan Information |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] Last Updated: 11/24/2011
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Version 2.0
 | Node # |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  |  | DHCP Server IP
 | 0 |  |  |  | #N/A |  |  |  |  |  | #N/A |  |  |  |  |  | #N/A
 | Primary Locator (Slice ID) |  |  |  | MTC / STC |  |  |  | Headend |  |  |  | Service Group ID |  |  |  | Modulation Scheme
 | #N/A |  |  |  | #N/A |  |  |  | #N/A |  |  |  | #N/A |  |  |  | #N/A
 | GEO & Sec Loc |  |  |  | CMTS |  |  |  | CMTS Card Information |  |  |  | CMTS IP Address |  |  |  | Channel Width
 | #N/A |  |  |  | #N/A |  |  |  | #N/A |  |  |  | #N/A |  |  |  | #N/A
 |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  | #N/A
 | RF Gateway Information
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | #N/A
 | Slot |  |  |  | RF Gateway IP Address |  |  |  | [NAME] |  |  |  | Service Type |  |  |  | Network Element
 | #N/A |  |  |  | #N/A |  |  |  | #N/A |  |  |  | #N/A |  |  |  | #N/A
 | Modulation Scheme |  |  |  | Spa Interface ID #1 |  |  |  | Spa Interface ID #2 |  |  |  | Spa Interface ID #3 |  |  |  | Spa Interface ID #4
 | #N/A |  |  |  | #N/A |  |  |  | #N/A |  |  |  | #N/A |  |  |  | #N/A
 | Channel Width |  |  |  | QAM Frequency #1 |  |  |  | QAM Frequency #2 |  |  |  | QAM Frequency #3 |  |  |  | QAM Frequency #4
 | #N/A |  |  |  | #N/A |  |  |  | #N/A |  |  |  | #N/A |  |  |  | #N/A
 | North DNCS |  | HE |  | Non DNCS/DAC Fed |  |  |  | HE
 | Bell |  | P2 |  | Wickenburg |  |  |  | C2
 | Fowler / Verrado / Tartesso |  | P4 |  | Gila Bend |  |  |  | [NAME]
 | McDowell |  | P5
 | [NAME] |  | P6 |  | South DNCS |  |  |  | HE
 | Peoria / Festival Ranch |  | P7 |  | Tempe / Chandler |  |  |  | A1 / P1
 |  |  |  |  | E. Mesa |  |  |  | P3
 | Moto/Cisco SA |  | HE |  | Queen Creek / Pinal |  |  |  | C1
 | Las Vegas |  | 91 |  | S. Scottsdale |  |  |  | P8
 |  |  |  |  | Casa Grande |  |  |  | S1
 |  |  |  |  | Tucson / Green Valley / Vail / Corona De Tucson |  |  |  | T1
 |  |  | Cochise |  | Sierra Vista / Benson /  Ft Huachuca |  |  |  | 12
 |  |  |  |  | Motorola DAC |  |  |  | HE
 |  |  |  |  | Douglas / Pirtlesville |  |  |  | T2
 |  |  |  |  | Tombstone / Whetstone |  |  |  | T3
 |  |  |  |  | Patagonia |  |  |  | T4
 |  |  |  |  | [NAME] Sites |  |  |  | 12
Spreadsheet: 734869d1622554510-help-with-an-area-formula-plate-utilisation
Sheet: Plate Cutouts

 | Stock Sheet Size 1250x1700 |  |  |  | Surface Area
 |  |  | 1250 | 1700
 |  | Machines | [NAME] | Length | Cutouts | % Utilisation | %Waste
 |  | Bobst 76 | 556 | 798 | 4
 |  | Bobst 102 | 715 | 1052 | 2
 |  | Bobst 103 | 718 | 1052 | 2
 |  | Bobst 104 | 736 | 1074 | 2
 |  | Bobst 106s | 760.5 | 1090 | 2
 |  | Bobst 106c | 730 | 1090 | 2
 |  | Bobst SPO 1600 | 1090 | 1629 | 1
 |  | Bobst 142 | 1028 | 1449 | 1
 |  | Bobst 145 | 1064 | 1484 | 1
 | Stock Sheet Size 1500x2200 |  |  |  | Surface Area
 |  |  | 1500 | 2200
 |  | Machines | [NAME] | Length | Cutouts | % Utilisation | %Waste
 |  | Bobst 76 | 556 | 798 | 5
 |  | Bobst 102 | 715 | 1052 | 4
 |  | Bobst 103 | 718 | 1052 | 4
 |  | Bobst 104 | 736 | 1074 | 4 |  |  |  |  | Cutouts 106s | Cutouts 76 | % Utilisation | Waste
 |  | Bobst 106s | 760.5 | 1090 | 2 |  |  |  | Bobst106 s+ Bobst 76 | 2 | 1
 |  | Bobst 106c | 730 | 1090 | 4
 |  | Bobst SPO 1600 | 1090 | 1629 | 1
 |  | Bobst 142 | 1028 | 1449 | 2
 |  | Bobst 145 | 1064 | 1484 | 2
Spreadsheet: 884207d1733288581-if-formula-with-index-and-match-that-doesnt-work-follow-up-test
Sheet: test

No. | Region | Country | Mode
 |  | Romania | ASE | =IF(MATCH(C4,Countries!B:B),INDEX(Countries!A:A,MATCH(C4,Countries!B:B,0)),INDEX(Countries!A:A,MATCH(C4,Countries!F:F,0)))
 |  | Spain | AE | =IFS(MATCH(C5,Countries!B:B),INDEX(Countries!A:A,MATCH(C5,Countries!B:B,0)),MATCH(C5,Countries!F:F),INDEX(Countries!A:A,MATCH(C5,Countries!F:F,0)))
 |  | UK | AI | =IF(MATCH(C6,Countries!F:F),INDEX(Countries!A:A,MATCH(C6,Countries!F:F,0)))
 |  | UAE | AE | =IF(MATCH(C7,Countries!B:B),INDEX(Countries!A:A,MATCH(C7,Countries!B:B,0)),INDEX(Countries!A:A,MATCH(C7,Countries!F:F,0)))
 |  | USA | SE | =IFS(MATCH(C8,Countries!B:B),INDEX(Countries!A:A,MATCH(C8,Countries!B:B,0)),MATCH(C8,Countries!F:F),INDEX(Countries!A:A,MATCH(C8,Countries!F:F,0)))
 |  | Australia | AI
 |  | France | SI
 |  | China | SE
 |  | Chile | SE
 |  | Vietnam | SI
Spreadsheet: 868010d1714726760-calculate-first-date-and-from-today-no-of-days-dow-but-only-if-after-a-specific-date-date-calculation
Sheet: Sheet1

Today | daysToDeparture | dayOfWeek | First Poss Date | What is this Date? |  | RaulSerg |  | Bebo
 | 32 |  | 2024-06-06 00:00:00
What is the first Saturday (col C) after the date in col D if the first Saturday (col c) from today + col b is less than Col D
My expectation is the result would be 06JUL24
Spreadsheet: 786798d1657454165-sum-values-with-multiple-columns-book1
Sheet: Sheet1

 |  |  |  | TABLE 1 |  |  |  |  |  |  |  |  |  |  |  | TABLE 2
 |  |  |  | PO1 | PO1 | PO2 | PO3 | PO4 | PO4 | PO5 | PO6 | PO7 | PO8 |  |  | PO1 | PO2 | PO3 | PO4 | PO5 | PO6 | PO7 | PO8
 |  |  | Name A | 7 | 12 | 2 | 0 | 1 | 2 | 0 | 5 | 3 | 0 |  | Name A
 |  |  | Name B | 12 | 19 | 4 | 4 | 4 | 2 | 1 | 4 | 3 | 7 |  | Name B
 |  |  | Name C | 11 | 22 | 4 | 3 | 3 | 4 | 0 | 3 | 0 | 2 |  | Name C
 |  |  | Name D | 7 | 21 | 0 | 5 | 3 | 1 | 1 | 4 | 1 | 6 |  | Name D
 |  |  | Name E | 0 | 3 | 6 | 7 | 2 | 2 | 2 | 1 | 4 | 5 |  | Name E
 |  |  | Name F | 13 | 4 | 0 | 7 | 3 | 0 | 3 | 1 | 2 | 7 |  | Name F
 |  |  | Name G | 3 | 3 | 2 | 0 | 4 | 2 | 1 | 1 | 2 | 1 |  | Name G
 |  |  | Name H | 9 | 28 | 6 | 2 | 2 | 0 | 2 | 3 | 2 | 3 |  | Name H
 |  |  | Name I | 11 | 30 | 9 | 5 | 2 | 5 | 3 | 5 | 3 | 6 |  | Name I
 |  |  | Name J | 11 | 12 | 10 | 4 | 1 | 2 | 1 | 1 | 2 | 10 |  | Name J
 |  |  | Name K | 2 | 12 | 0 | 3 | 1 | 3 | 3 | 2 | 5 | 9 |  | Name K
 |  |  | Name L | 4 | 3 | 9 | 0 | 0 | 4 | 1 | 1 | 4 | 6 |  | Name L
 |  |  | Name M | 0 | 3 | 2 | 0 | 2 | 5 | 0 | 5 | 3 | 8 |  | Name M
 |  |  | Name N | 2 | 3 | 6 | 3 | 4 | 4 | 0 | 5 | 0 | 2 |  | Name N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1. I have a data namely Table 1. In the Table 1 consists of Names (A-N) & POs (1 to 8).
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2. My problem is I want to sum the values according to each PO as you can see in the Table 2.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3. I tried to use filter and sum functions. However, it adds up all the values in column PO1.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4. Example: Other POs are no issue, and the problem is Name A supposedly get values of 19 (7+12) for PO1 and 3 (1+2) for [NAME].
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5. I hope anyone experts here can help me to solve this problem. I appreciate any help you can provide. Thank you!
Spreadsheet: 60127d1260661875-solving-a-multivariable-equation-with-excel-solver2
Sheet: Sheet1

t | 248 | 8 | 1 | 1387 | 1353 | 34 |  | 828 | 22
u | 145 | 3 | 1 | cell to change | sumproduct for col b | sumproduct for col c |  | result wanted for | result wanted for
v | 180 | 3 | 1 |  |  |  |  | col b | col c
w | 290 | 7 | 1
x | 300 | 9 | 1
y | 90 | 2 | 1
z | 100 | 2 | 1
 |  |  | fill this col with 1's
Spreadsheet: 853220d1703119678-array-reference-in-custom-formula-without-spilling-lambda-example
Sheet: Sheet1

Product type | Brand | [NAME] | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 |  | HISTORICAL CAGR
Ice Cream | [NAME] | Tio Lupe | 6652 |  |  |  |  | 0 | 0 | 0
Popsicle | Lime Storm | Bugsy Brands | 0 | 23
Popsicle | Blue-bearied | Mordor Inc | 528 |  |  |  |  |  |  | 0
Popsicle | Skarch | French Frances | 7785
Ice Cream | [NAME] | Bugsy Brands | 0 | 0 | 0 | 0 | 0
Ice Cream | Frankfurt Craze | French Frances | 0 | 0 | 898
=LAMBDA(a,IFERROR(RRI(COUNTIF(a,">0")-1,INDEX(a,[NAME],INDEX(a<>0,),0)),LOOKUP(2,1/(a<>0),a)),0))
just sp
Spreadsheet: darrell_schoolcraft__7299__imball0112
Sheet: Agave

Agave imbalance
 | Measured | Scheduled | Imbalance
56339 | 337478 | 378203
500232 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500238 | 320826 | 368027 |  |  |  |  |  |  |  |  | lunch | 7.6
500239 | 384805 | 388380 |  | 2001-11-03 00:00:00
500293 | 182551 | 217849
500302 |  | 3031
500303 |  | 111886
500305 | 613453 | 476896
500307 | 39993 | 23408
500313 |  | 1111
500314
500655 | 26061
500657 | 64660 | 61897
INDEX
2001-11-30 00:00:00 |  |  | 40288.34
2001-12-11 00:00:00
CBS Volume
 |  |  | 31564
Spreadsheet: 748857d1632391172-index-match-not-returning-the-expected-value-book2
Sheet: Sheet1

 | 500 | 1000 | 2000 | 3000 | 4000 | 5000 | 8000 | 10000
1 | 30 | 57.89999999999999 | 111.6 | 161.1 | 206.4 | 247.5 | 345.6 | 390
2 | 57 | 110.01 | 212.04 | 306.09 | 392.16 | 470.2499999999999 | 656.6399999999999 | 741
3 | 81 | 156.33 | 301.32 | 434.97 | 557.28 | 668.25 | 933.12 | 1053
4 | 102 | 196.86 | 379.44 | 547.74 | 701.76 | 841.4999999999999 | 1175.04 | 1326
5 | 120 | 231.6 | 446.4 | 644.4 | 825.6 | 989.9999999999999 | 1382.4 | 1560
6 | 135 | 260.55 | 502.2 | 724.9499999999999 | 928.8 | 1113.75 | 1555.2 | 1755
7 | 147 | 283.7099999999999 | 546.84 | 789.39 | 1011.36 | 1212.75 | 1693.439999999999 | 1911
8 | 156 | 301.08 | 580.32 | 837.72 | 1073.28 | 1287 | 1797.12 | 2028
9 | 162 | 312.66 | 602.6400000000001 | 869.94 | 1114.56 | 1336.5 | 1866.24 | 2106
10 | 165 | 318.45 | 613.8000000000001 | 886.05 | 1135.2 | 1361.25 | 1900.8 | 2145
 | 4000 |  | =INDEX(B3:I12,MATCH(B15,B2:I2,0),MATCH(B16,A3:A12,0))
 | 1
Spreadsheet: 788371d1658420395-coping-specific-names-from-one-sheet-to-a-another-automatically-test
Sheet: N

Surname | Given Name(s) | Section | Lot | Number | Date Bought | Date Paid | Address | Town / City | Prov | Postal | Phone
Nause | kathy | 1 | 1 | 1 | July 20 2022 | July 20 2020 | 123 Any street | Anywhere | ON | H0H 0H0 | [PHONE]
Spreadsheet: 878199d1725264087-cell-reference-when-inserting-rows-new-micro-excel-work31-8-24
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Excel 2013 |  | <<32bit.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cannot use "INDEX:INDEX"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nor OFFSET, ADDRESS….etc volatile functions, please!
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | There(sheet2) will be insert 10 rows from 2-11(new wday new report), also deleting everything below 3511 row.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SUMIFS not working
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ROW(whole column) also not working….
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date: |  |  |  | Uhh, HELP ME PLEASE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-06-09 00:00:00 | << type date in
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =SUMPRODUCT((INDEX(Sheet2!$A:$A;2))*(ISNUMBER(MATCH(Sheet2!$G:$G;{"S-5";"S-6";"S-7";"S-8";"S-9";"S-12";"S-13";"S-14"};0)))*(Sheet2!$B:$B))
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | First part, latest report, around rows 2-11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -SUMPRODUCT((Sheet2!$A:$A=$Q$12)*(INDEX(Sheet2!$A:$A;ROW(Sheet2!$A:$A))>=12)*(ISNUMBER(MATCH(Sheet2!$G:$G;{"S-5";"S-6";"S-7";"S-8";"S-9";"S-12";"S-13";"S-14"};0)))*(Sheet2!$B:$B))
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | second part of formula, everything below row 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | latest report minus some previous = Difference
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | "INDEX:INDEX" is volatile in 2013, not in 2016 or latest :( :( :(
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EUROPA, semicolon(;) in formulae
Spreadsheet: 768458d1644978691-date-field-and-checking-the-date-portion-of-the-date-field-not-the-time-sr-workbook
Sheet: Output

Quick Project Summary |  | =SUMPRODUCT(--(INT(Closed!(G1:G9999)= INT(C2)))
[NAME] (Previous Day) |  | 2022-02-15 00:00:00
[NAME]
BOOKED
DELAYED
CALLED
NEW
ON HOLD
DESPATCHED
Booked for Today:
Spreadsheet: richard_shapiro__32653__2002 Plan Budget Pack -  Reg Affairs FINAL
Sheet: Cost Summary 

 |  |  |  | 2001 |  | $000's |  | 2002 |  | 2002 VS 2001
 |  |  |  | Aug YTD Annualised
 |  |  |  | 5186 |  | Expenses |  | 2675
 |  |  |  | 146 |  | Corp. Allocations |  | 213
 |  |  |  | -5332 |  | Allocations |  | -2888
 |  |  |  | 0 |  | Residual |  | 0
 |  |  |  | 19 |  |  |  | 10
 |  |  | EEL Employee's | 18 |  |  |  | 9
 |  |  | Non - EEL Employee's | 1 |  |  |  | 1
 |  | Note : See the following two pages for a summary /scenario sumary (page 3) and a Consultancy / Legal & Subscriptions summary (page 4)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Cumulative $000's | Dec / YTD
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2002 Plan | 2674
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Actuals / CE2
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2001 Plan
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10% Target
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 20% Target
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Baseline
 | Planned Cost Reductions
 | Reduce Headcount to 10 from 19 people (September 30). CE2 had budgeted to go from 22 people to 25 at year end.
 | 3 headcount have recently left, these are not to be replaced.
 | Limit travel to 1 trip for each of the 5 main travellers in the group.
 | New policy for Authorisation.  [NAME] raised to sign off level of VP , P.Styles sign off reduced to Senior Director level.
 | All Consultancy/ Legal invoices to be approved by [NAME].
 | Extra Cost Reductions
 | Close Brussels office? Save $100k per year in office rental and $45k in Data line for office (Budgeted by IT)
 | Additional aims going forward
 | For relevant items seek Commercial aprroval before commencing Consultancy/Legal work and code the cost directly to those areas.
 | Graph Data only - not to be included in pack
 | Cumulative | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec / YTD
 | 2002 Plan
 | Actuals / CE2
 | 2001 Plan
 | 10% Target
 | 20% Target
 | 50% Target
 | Baseline
Spreadsheet: 116023d1311506325-selective-columns-marcol
Sheet: sa

Scott. [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 18 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 854640d1704444066-offset-values-and-identify-leftover-balance-cells-book2-1-
Sheet: Example

Example 1 |  |  |  |  |  |  |  |  | Need this output through [NAME]
Ref No |  |  | Client Name | Address | Date | Amount |  |  | Cumulative Sum
1 |  |  | ABC | XYZ | 2022-04-14 00:00:00 | 370
2 |  |  | ABC | XYZ | 2022-04-15 00:00:00 | 650
3 |  |  | ABC | XYZ | 2022-05-19 00:00:00 | 1357
4 |  |  | ABC | XYZ | 2022-06-29 00:00:00 | 708
5 |  |  | ABC | XYZ | 2022-08-18 00:00:00 | 4200
6 |  |  | ABC | XYZ | 2022-09-15 00:00:00 | 1003
7 |  |  | ABC | XYZ | 2022-09-27 00:00:00 | 885
8 |  |  | ABC | XYZ | 2022-11-07 00:00:00 | 7080
9 |  |  | ABC | XYZ | 2022-11-25 00:00:00 | 944
10 |  |  | ABC | XYZ | 2022-12-07 00:00:00 | -17197
11 |  |  | ABC | XYZ | 2023-01-10 00:00:00 | 708
12 |  |  | ABC | XYZ | 2023-02-04 00:00:00 | 550
13 |  |  | ABC | XYZ | 2023-02-13 00:00:00 | 490
14 |  |  | ABC | XYZ | 2023-03-15 00:00:00 | 1003
15 |  |  | ABC | XYZ | 2023-03-15 00:00:00 | -1