tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 730703d1619861324-group-countif-formula-with-multiple-conditions-book1
Sheet: Sheet1

TABLE-1 |  |  |  |  |  |  | TABLE-2 |  |  |  |  |  |  |  |  | Answer should be
Item | A | B | C | D | E |  | Item | A | B | C | D | E |  |  |  |  | No. of Item | Valid count | Compliance %
AA | M |  |  |  | M |  | AA | 2022-01-15 00:00:00 |  |  | 2022-01-05 00:00:00 | 2022-02-04 00:00:00 |  |  |  | A | 5 | 5
AB |  | M |  |  |  |  | AB |  | 2020-12-31 00:00:00 |  |  |  |  |  |  | B | 4 | 2
AC |  |  | M |  |  |  | AC | 2023-01-15 00:00:00 |  | 2022-01-15 00:00:00 |  |  |  |  |  | C | 4 | 3
AD |  |  |  | M |  |  | AD |  |  |  | 2020-12-31 00:00:00 |  |  |  |  | D | 4 | 2
AE | M |  |  |  | M |  | AE | 2022-05-01 00:00:00 |  |  |  | 2022-01-15 00:00:00 |  |  |  | E | 5 | 5
AG |  |  | M |  |  |  | AG |  |  | 2022-05-01 00:00:00
AH |  |  |  | M |  |  | AH |  | 2022-06-05 00:00:00 |  | 2022-05-01 00:00:00
BA |  |  | M |  |  |  | BA |  |  | 2020-01-01 00:00:00 |  |  |  |  | Conditions
BB | M |  |  |  |  |  | BB | 2023-04-06 00:00:00 |  |  |  |  |  |  | 1 | I have to count dates based against the Item
BC |  |  |  |  | M |  | BC |  |  |  |  | 2023-04-06 00:00:00 |  |  | 2 | I have to count only the cells which are having dates and is  greater than today
BD |  | M |  |  |  |  | BD |  | 2020-01-01 00:00:00 |  |  |  |  |  | 3 | Count if only if the second table matches with the first table criteria (M)
BE |  | M |  |  |  |  | BE |  | 2022-01-01 00:00:00 | 2023-03-04 00:00:00
BG |  |  |  | M |  |  | BG |  |  |  | 2022-01-01 00:00:00 | 2023-08-17 00:00:00
BH | M |  |  |  |  |  | BH | 2022-01-01 00:00:00
CG |  | M |  |  |  |  | CG |  | 2023-04-06 00:00:00
CF |  |  |  | M | M |  | CF |  |  |  |  | 2023-04-06 00:00:00
CH |  |  | M |  |  |  | CH |  |  | 2022-01-15 00:00:00
CO | M |  |  |  | M |  | CO | 2020-12-31 00:00:00 |  |  |  | 2022-05-01 00:00:00
 | Legend : M - Mandatory
Spreadsheet: 30208d1225586060-manipulating-the-format-of-contents-from-sheet1-and-formatting-them-diff-on-sheet2-test2
Sheet: Sheet2

Automation to perform:
For every unique value found
in column C (which is 516, 517, 216, 217)
figure out which buildings are affected
In the case of 516, BldgA and BldgB are affected. Copy and  paste 516 as the heading (as shown in A10), insert a line break, followed by the building names separated by commas (as shown in A11) . On the cell to the right of that (as shown in B11), copy and paste the contents of description. The description should only appear once. If there is more than  one Bldg, as in this case, the description should be copied only once. If a character "\n" is found, insert a line break
In the case of 517, BldgB is only affected. Copy and paste  517 as the heading (as shown in A13), insert a line break, followed by the building names separated by commas (as shown in A14). Multiple buildings were not found in this case. On the cell to the right of that (as shown in B14), copy and paste the contents of description. The description should only appear once. If there is more than  one Bldg (multiple bldg's not found in this case) the description should be copied only once. If a character "\n" is found, insert a line break
In the case of 216, BldgA is only affected (similar concept as 517)
In the case of 217, BldgB is only affected (similar concept as 517)
Desired Output:
516 | Description:
BldgA, BldgB | High weakness1 determined,but no evidence
517 | Description:
BldgB | High Weakness2 determined with evidence
216 | Description:
BldgA | Low Weakness1 determined, but no evidence
217 | Description:
BldgB | Low Weakness2 determined with evidence
How it is supposed to work?
516 (Copy first unique value in Column C) | Description: (\n was found. Insert line break here)
BldgA, BldgB (Copy the contents of column A | High weakness1 determined,but no evidence
associated with Column C) and separate
them by commas. Multiple Bldg's were found for 516 here
517 (Copy second unique value in Column C) | Description: (\n was found. Insert line break here)
BldgB (Copy the contents of column A | High Weakness2 determined with evidence
associated with Column C) and separate
them by commas. Multiple Bldg's were not found for 517 here
216 (Copy the third unique value in Column C) | Description: (\n was found. Insert line break here)
BldgA | Low Weakness1 determined, but no evidence
217 (Copy the fourth unique value in Column C) | Description: (\n was found. Insert line break here)
BldgB | Low Weakness2 determined with evidence
Spreadsheet: 164966d1340973560-can-do-in-access-cant-in-excel-henryauction2
Sheet: Sheet1

ADDRESS | FILE NO. | ORIG LOAN | SALE DATE | COUNTY | OPENING BID | MAXIMUM PROTECTIVE BID
2060 [NAME] , McDonough, Georgia, 30253 | 08-22603 | 139900 | 2012-07-03 00:00:00 | [NAME] | 135789.55 | $170,796.53
109 Watkins [NAME] , McDonough, Georgia, 30252 | 08-23440 | 375000 | 2012-07-03 00:00:00 | [NAME] | 414839.44
115 Sterling Avenue , McDonough, Georgia, 30252 | 09-04225 | 112000 | 2012-07-03 00:00:00 | [NAME] | Not Yet Available
860 [NAME] , Hampton, Georgia, 30228 | 09-09647 | 128514 | 2012-07-03 00:00:00 | [NAME] | 166758.4
831 [NAME] , McDonough, Georgia, 30253 | 09-16381 | 278000 | 2012-07-03 00:00:00 | [NAME] | Not Yet Available
Spreadsheet: 758729d1639043246-excel-dashboard-help-sum-data-from-multiple-tabs-service-support-management-db_v2
Sheet: Calculations (2)

 | PROJECTS | [NAME] | Kat | Kat | Matan | [NAME] | [NAME] | All Managers | Calls | [NAME] | Kat | [NAME] | [NAME]
CLIENT PROJECTS | January |  |  |  |  |  |  |  | CLIENT CALLS
 | February
 | March
 | April
 | May
 | June
 | July
 | August
 | September
 | October
 | November
 | December
 | PAT TICKETS
 | Month | Tickets
 | January | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
 | February | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
 | March | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18) |  |  |  |  |  | Days Spent | Hours spent
 | April | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
 | May | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
 | June | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
 | July | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
 | August | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
 | September | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
 | October
 | November
 | December
 | Client Information
 | Client Name
 | Total number of Client Calls
 | Average number of Client Calls
 | Not started
 | On hold
 | In progress
 | Completed
 | Total number of Client Proects
 | Completed
 | Total number of Client Projects
 | Average number of Client Projects
 | Not started
 | On hold
 | In progress
 | Completed
Spreadsheet: 769325d1645467880-index-match-case-size-issue-index-match-case-issue
Sheet: Sheet1

Scientific | Code
1000 |  |  | Code | Result | Should Be | TEST
1000000 | K |  | K
1000000000 | M |  | M
1000000000000 | B |  | B
1000000000000000 | T |  | T
1e+18 | q |  | q
1e+21 | Q |  | Q
1e+24 | s |  | s
9.999999999999999e+26 | S |  | S
9.999999999999999e+29 | O |  | O
1e+33 | N |  | N
9.999999999999999e+35 | d |  | d
9.999999999999998e+38 | U |  | U
9.999999999999999e+41 | D |  | D
1e+45 | ! |  | !
1e+48 | @ |  | @
1e+51 | # |  | #
1e+54 | $ |  | $
1e+57 | % |  | %
1e+60 | ^ |  | ^
1e+63 | & |  | &
1e+66 | * |  | *
Spreadsheet: 267632d1380124153-vlookup-to-another-worksheet-with-an-inbedded-index-match-possible-test
Sheet: Sheet1

No DO | No Inv | Data
BG0001 | BC0001 | aa
BG0002 | BC0002 | bb
BG0003 | BC0003 | cc
BG0004 | BC0004 | dd
BG0005 | BC0005 | ee
BG0006 | BC0006 | ff
BG0007 | BC0007 | gg
BG0008 | BC0008 | ss
BG0009 | BC0009 | jj
BG0010 | BC0010 | [NAME]
Spreadsheet: 65281d1265971569-looking-up-xth-number-in-data-testcmb80
Sheet: Data

Field1 | Field2
Blue | 20
Red | 19
Blue | 18
Green | 17
Blue | 16
Red | 15
Blue | 14
Green | 13
Blue | 12
Red | 11
Blue | 10
Green | 9
Blue | 8
Red | 7
Blue | 6
Green | 5
Red | 4
Green | 3
Green | 2
Green | 1
Spreadsheet: 187311d1350403858-check-time-is-between-2-times-and-highlight-cell-conditional-formatiing_solution
Sheet: Sheet1

 |  |  | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00 | 23:00:00 | 23:30:00 | 00:00:00 | 00:30:00 | 01:00:00 | 01:30:00 | 02:00:00 | 02:30:00 | 03:00:00 | 03:30:00 | 04:00:00 | 04:30:00 | 05:00:00 | 05:30:00
Start | Finish | Elapse | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00 | 23:00:00 | 23:30:00 | 00:00:00 | 00:30:00 | 01:00:00 | 01:30:00 | 02:00:00 | 02:30:00 | 03:00:00 | 03:30:00 | 04:00:00 | 04:30:00 | 05:00:00 | 05:30:00 | 06:00:00
Off | Off
08:00:00 | off
Spreadsheet: 829192d1684016461-lookup-based-on-a-value-test
Sheet: Sheet1

Country | Level | To find | How to find column C value
USA | 1
Mexico | 2 | USA | This is in level 2. So immediate upper level 1 value (in col A) should be filled in
India | 2 | USA | This is in level 2. So immediate upper level 1 value (in col A) should be filled in
Austria | 3 | India | This is in level 3. So immediate upper level 2 value (in col A) should be filled in
Dubai | 3 | India | This is in level 3. So immediate upper level 2 value (in col A) should be filled in
England | 2 | USA | This is in level 2. So immediate upper level 1 value (in col A) should be filled in
China | 3 | England | This is in level 3. So immediate upper level 2 value (in col A) should be filled in
Russia | 4 | China | This is in level 4. So immediate upper level 3 value (in col A) should be filled in
Denmark | 4 | China | This is in level 4. So immediate upper level 3 value (in col A) should be filled in
Australia | 4 | China | This is in level 4. So immediate upper level 3 value (in col A) should be filled in
Japan | 3 | England | This is in level 3. So immediate upper level 2 value (in col A) should be filled in
Chile | 2 | USA | This is in level 2. So immediate upper level 1 value (in col A) should be filled in
 |  |  | Need a formula to fill in values in column C
Spreadsheet: 125187d1318925376-search-function-multiple-parentheses-search-list-in-text
Sheet: Sheet1

Page | Area
/business-services/areas/corporate |  |  |  | Commercial
/business-services/areas/Commercial |  |  |  | Corporate
/business-services/areas/Commercial
/business-services/Pages/Recruitment.aspx
/business-services/areas/Commercial
/business-services/News/Pages/NewsViewer.aspx?item=4921
/business-services/News/Pages/NewsViewer.aspx?item=4971
Spreadsheet: 61510d1262380115-comparing-groups-of-numbers-for-duplicates-sampledata-1-
Sheet: Sheet1

0 | 2 | 16 | 32 | 50 | 61 | 3 | 19 | 36 | 51 | 64 | 4 | 23 | 37 | 53 | 65 | 13 | 24 | 40 | 54 | 70 |  | 15 | 25 | 45 | 58 | 72
1 | 6 | 20 | 31 | 46 | 66 | 9 | 21 | 33 | 52 | 67 | 11 | 27 | 39 | 55 | 69 | 12 | 29 | 41 | 57 | 73 |  | 14 | 30 | 42 | 60 | 75
5 | 1 | 6 | 34 | 47 | 62 | 5 | 18 | 35 | 48 | 63 | 7 | 22 | 38 | 49 | 68 | 8 | 26 | 43 | 56 | 71 |  | 10 | 28 | 44 | 59 | 74
0 | 1 | 17 | 33 | 47 | 61 | 4 | 21 | 37 | 53 | 63 | 9 | 22 | 39 | 56 | 64 | 11 | 25 | 41 | 58 | 65 |  | 12 | 29 | 44 | 59 | 73
0 | 3 | 20 | 31 | 46 | 67 | 6 | 23 | 34 | 48 | 68 | 10 | 24 | 38 | 50 | 69 | 13 | 27 | 40 | 52 | 72 |  | 15 | 30 | 42 | 60 | 75
7 | 2 | 16 | 32 | 49 | 62 | 5 | 18 | 35 | 51 | 66 | 7 | 19 | 36 | 54 | 70 | 8 | 26 | 43 | 55 | 71 |  | 14 | 28 | 45 | 57 | 74
0 | 2 | 17 | 31 | 47 | 66 | 7 | 21 | 32 | 52 | 67 | 10 | 25 | 37 | 54 | 69 | 13 | 26 | 40 | 55 | 74 |  | 14 | 28 | 41 | 58 | 75
0 | 4 | 16 | 35 | 46 | 63 | 5 | 20 | 42 | 48 | 64 | 9 | 22 | 43 | 53 | 68 | 12 | 27 | 44 | 57 | 70 |  | 15 | 30 | 45 | 60 | 72
6 | 1 | 18 | 33 | 49 | 61 | 3 | 19 | 34 | 50 | 62 | 6 | 23 | 36 | 51 | 65 | 8 | 24 | 38 | 56 | 71 |  | 11 | 29 | 39 | 59 | 73
0 | 4 | 16 | 31 | 48 | 62 | 10 | 18 | 34 | 49 | 64 | 11 | 20 | 36 | 53 | 67 | 14 | 24 | 40 | 54 | 68 |  | 15 | 26 | 42 | 60 | 73
Spreadsheet: cara_semperger__1456__ENA_PGE_DEC20_2001
Sheet: LOSSES

From: | EPMI
To: | PGE System Transactions
Date:
HE
ENDING | TOTAL |  | TOTAL
Pacific
Prevailing
Time | NO SCHEDULE POSTED
(PPT)
0100 |  | 1
0200 |  | 1
0300 |  | 1
0400 |  | 1
0500 |  | 1
0600 |  | 1
0700 |  | 2
0800 |  | 2
0900 |  | 2
1000 |  | 2
1100 |  | 2
1200 |  | 2
1300 |  | 2
1400 |  | 2
1500 |  | 2
1600 |  | 2
1700 |  | 2
1800 |  | 2
1900 |  | 2
2000 |  | 2
2100 |  | 2
2200 |  | 2
2300 |  | 1
2400 |  | 1
 | PGE | PGE | PGE
 | REAL POWER LOSSES | PGE LOSSES | [NAME] [NAME]
 | PGE | PGE | PGE
 | 640902
 | 640903
 | NEW COLUMN
Spreadsheet: michelle_lokay__26808__sharris0800wk4
Sheet: Actuals V. Plan

Transwestern Pipeline Company
($[NAME])
 |  |  |  |  |  | 2000-09-01 09:39:27.460000
 |  | August, 2000
 |  | Plan | Estmate | [NAME] |  | Comments
West Demand Revenues |  | 9.8464 | 10.15766454 | 0.311264539999998 |  | Prices in excess of $0.12/mmbtu on 63/day.
West Commodity Revenues |  | 0.7731999999999999 | 0.8231737437999999 | 0.04997374379999997 |  | Higher volumes than in plan.
East Demand Revenues |  | 1.1254 | 0.9970535704 | -0.1283464296000002 |  | Burlington 24216--($53k), [NAME])
East Commodity Revenues |  | 0.1709 | 0.2594166169880001 | 0.08851661698800006 |  | Higher east volumes
[NAME] |  | 0.6644000000000001 | 0.65624675 | -0.008153250000000112
[NAME] Revenues |  | 0.05890000000000001 | 0.1772938536 | 0.1183938536 |  | higher IT volumes than in plan
 |  | ------------- | ------------- | -------------
Revenue Variance |  | 12.6382 | 13.070849074788 | 0.4326490747879976
[NAME] due to Price |  |  |  | 0.7419375925396023 |  | Current index price of $3.85
[NAME] due to net fuel retention. |  |  |  | -0.05330320610187494
Hedging Adjustment |  |  |  | 0.1069499999999999
Unaccounted for Variance |  |  |  | -0.134
 |  |  |  | -------------
Fuel Variance |  |  |  | 0.6615843864377274
 |  |  |  | -------------
TOTAL MONTH-TO-DATE VARIANCE |  |  |  | 1.094233461225725
 |  |  |  | ========
[NAME]
 |  | Year-to-Date | Year-to-Date | Year-to-Date
 |  | Margin | Fuel & UAF | Total
Plan (through August) |  | 97.41619999999999 | 11.7072 | 109.1234
Actuals through June and July est. |  | 97.80774907478799 | 14.3025 | 112.110249074788
 |  | ------------- | ------------- | -------------
Variance from Plan |  | 0.3915490747880028 | 2.595299999999998 | 2.986849074788001
 |  | ------------- | ------------- | -------------
Spreadsheet: 524826d1498375800-how-to-align-duplicate-data-to-the-same-column-how-to-align-duplicate-data-to-the-same-column-bw
Sheet: 工作表1

Job | Part
1 | Part 1 |  | Job | Part 1 | Part 2 | Part 3 | Part 4
1 | Part 2 |  | 1
2 | Part 2 |  | 2
2 | Part 3 |  | 3
3 | Part 1 |  | 4
3 | Part 2
3 | Part 3
4 | Part 4
4 | Part 3
4 | Part 1
Spreadsheet: 754701d1636456057-how-to-type-a-word-and-fill-some-cells-with-numeric-values-associated-fill-text-aligw
Sheet: Plan1

F | A | K | E |  | 1° STEP |  |  |  |  |  | LETTERS | VALUE
 |  |  |  |  |  |  |  |  |  |  | F | 1
 |  |  |  |  |  |  |  |  |  |  | A | 2
 |  |  |  |  |  |  |  |  |  |  | K | 3
 |  |  |  |  |  |  |  |  |  |  | E | 4
 |  |  |  |  | 2° STEP
2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034
Spreadsheet: 744190d1629054081-get-min-of-range-using-vlookup-and-indirect-vlookupindir
Sheet: Analysis

 |  |  |  |  |  |  |  |  | OPEN PRICE | PRICE: DAYS OUT |  |  |  |  |  | Low
 |  |  |  | Call | Date | Token | RANGENAME |  |  | 7 | 14 | 30 | 60 |  |  | 60
 |  |  |  | $DOT | 2020-12-02 00:00:00
 |  |  |  | $AAVE | 2020-12-16 00:00:00
 |  |  |  | [ this sheet has 1000+ more rows, and the workbook has 50+ sheets each with a Token name ]
Spreadsheet: 782409d1654020158-check-if-cell-contains-a-number-in-a-given-range-of-numbers-fmea-smockpuv-
Sheet: Sheet2

Detection | Occurance | Severity | AP
 | 10 | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 | 10 | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 |  | 8
 | 10 | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
 |  | 6
Spreadsheet: 145387d1331565006-index-match-several-sheets-to-one-formula-vml
Sheet: tab3

1.14 |  |  | Dep Date |  |  |  |  |  |  | 2011-04-28 00:00:00 | 2011-05-05 00:00:00 | 2011-05-12 00:00:00 | 2011-05-19 00:00:00 | 2011-05-26 00:00:00 | 2011-06-02 00:00:00 | 2011-06-09 00:00:00 | 2011-06-16 00:00:00 | 2011-06-23 00:00:00 | 2011-06-30 00:00:00 | 2011-07-07 00:00:00 | 2011-07-14 00:00:00 | 2011-07-21 00:00:00 | 2011-07-28 00:00:00 | 2011-08-04 00:00:00 | 2011-08-11 00:00:00 | 2011-08-18 00:00:00 | 2011-08-25 00:00:00 | 2011-09-01 00:00:00 | 2011-09-08 00:00:00 | 2011-09-15 00:00:00 | 2011-09-22 00:00:00 | 2011-09-29 00:00:00 | 2011-10-06 00:00:00
AEOLIAN |  |  | W/c Date |  | 2011-04-02 00:00:00 | 2011-04-09 00:00:00 | 2011-04-16 00:00:00 | 2011-04-23 00:00:00 | 2011-04-30 00:00:00 | 2012-05-05 00:00:00 | 2012-05-12 00:00:00 | 2012-05-19 00:00:00 | 2012-05-26 00:00:00 | 2012-06-02 00:00:00 | 2012-06-09 00:00:00 | 2012-06-16 00:00:00 | 2012-06-23 00:00:00 | 2012-06-30 00:00:00 | 2012-07-07 00:00:00 | 2012-07-14 00:00:00 | 2012-07-21 00:00:00 | 2012-07-28 00:00:00 | 2012-08-04 00:00:00 | 2012-08-11 00:00:00 | 2012-08-18 00:00:00 | 2012-08-25 00:00:00 | 2012-09-01 00:00:00 | 2012-09-08 00:00:00 | 2012-09-15 00:00:00 | 2012-09-22 00:00:00 | 2012-09-29 00:00:00 | 2012-10-06 00:00:00 | 2012-10-13 00:00:00 | 2012-10-20 00:00:00 | 2012-10-27 00:00:00 | TOTAL | 2011-04-30 00:00:00 | 2011-05-31 00:00:00 | 2011-06-30 00:00:00 | 2011-07-31 00:00:00 | 2011-08-31 00:00:00 | 2011-09-30 00:00:00 | 2011-10-31 00:00:00 | Total
MJT |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 4 | 5 | 5 | 5 | 5 | 6 | 6 | 6 | 6 | 6 | 7 | 7 | 7 | 7 | 8 | 8 | 8 | 8 | 9 | 9 | 9 | 9 | 9 | 10 | 1 | 1 |  | 4 | 5 | 6 | 7 | 8 | 9 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.138736923335579 | 0.2116118481927624 | 0.2959580724249751 | 0.2214708276535242 | 0.1080150321919689 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Other Costs | Transfers | -18.42105263157895 |  |  |  |  |  |  |  | -3083.684210526316 | -3083.684210526316 | -3083.684210526316 | -3083.684210526316 | -3249.473684210527 | -3150 | -3150 | -3150 | -3150 | -3150 | -3232.894736842105 | -3232.894736842105 | -3232.894736842105 | -3232.894736842105 | -3232.894736842105 | -3232.894736842105 | -1939.736842105263 | -3150 | -3150 | -3150 | -3083.684210526317 | -2466.947368421053 | 0 | 0 |  |  | -67671.94736842107 | -3083.684210526316 | -12500.52631578948 | -15750 | -12931.57894736842 | -11555.52631578947 | -11850.63157894737 | 0 | -67671.94736842105 | 0
 | Handling | 0 | 0 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 126657d1319810067-comparing-dates-example
Sheet: Sheet1

Account | ID | Date |  | Associated Accounts | ID | Date
PPP Account A | 21 | 1992-10-05 00:00:00 |  | PPP Account A IDX1 | 3794 | 1992-10-05 00:00:00
PPP Account B | 22 | 1992-10-05 00:00:00 |  | PPP Account A IDX2 | 6802 | 1992-10-05 00:00:00
PPP Account C | 439 | 1999-05-03 00:00:00 |  | PPP Account I IDX1 | 8705 | 2002-03-01 00:00:00
PPP Account I | 1252 | 2002-03-01 00:00:00 |  | PPP Account I IDX2 | 8706 | 2002-03-01 00:00:00
PPP Account R1 | 4101 | 1992-10-05 00:00:00 |  | PPP Account I IDX3 | 8707 | 2002-03-01 00:00:00
 |  |  |  | PPP Account R1 IDX1 | 8424 | 1992-10-05 00:00:00
 |  |  |  | PPP Account R1 IDX2 | 8425 | 1992-10-05 00:00:00
 |  |  |  | PPP Account R1 IDX3 | 8426 | 1992-10-05 00:00:00
Spreadsheet: 819912d1677762977-split-column-nowy-microsoft-excel-worksheet-2-
Sheet: Arkusz1

1 | 2 | 3 | 4 | 5
looks like this | Looks like this |  | Should look like this COLUMN | OR EVEN BETTER TO LOOK LIKE THIS COLUMN
41-203 | SŁONECZNA 14 SOSNOWIEC | →→ | SŁONECZNA 14 | [NAME], 41-203 SOSNOWIEC, POLSKA
40-315 | AL. ROŹDZIEŃSKIEGO 210 KATOWICE | →→ | AL. ROŹDZIEŃSKIEGO 210 | AL. ROŹDZIEŃSKIEGO 210, 40-315 KATOWICE, POLSKA
40-315 | GEN. [NAME] PSZCZYNA | →→ | GEN. [NAME] | GEN. [NAME], 40-315 PSZCZYNA, POLSKA
43-500 | 1 MAJA 7 GOLESZÓW | →→ | 1 MAJA 7 | 1 MAJA 7, 43-500 GOLESZÓW, POLSKA
40-212 | ROLNA 14 KATOWICE | →→ | ROLNA 14 | ROLNA 14, 40-212 KATOWICE, POLSKA
Spreadsheet: 104290d1301932343-excel-2007-transfer-only-data-with-a-value-book1
Sheet: Data

Materials Required
Item Description |  | Qty. |  | Unit |  | Total
 |  |  |  | Price |  | Price/Row
interior framing | 2x4x8 | 15 | pcs. | 2.99 | /pc.
framing | 1x2x8 | 0 | pcs. | 1.99 | /pc.
exterior framing | 2x6x10 | 200 | pcs. | 10.99 | /pc.
framing | 2x8x10 | 0 | pcs. | 12.99 | /pc.
framing | 2x12x10 | 1 | pcs. | 14.99 | /pc.
 |  | 0 | pcs. | 0 | /pc.
 |  |  | gal. | 9 | gal.
 |  | 0 | pcs. | 0 | /pc.
 |  | 0 | pcs. | 0 | /pc.
 |  | 0 | pcs. | 0 | /pc.