tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 02dc2077-bc3b-420f-a229-84801632a8c7
Sheet: Total

NASP Equipment  - Supplemental Order Form
NASP, Inc. |  |  | Prices effective: |  |  |  |  |  |  | Phone: (920) 523-6040
W4285 Lake Drive |  |  | Jan 1 - Dec 31, 2014 |  |  |  |  |  |  | Fax:     (920) 523-6042
Waldo, WI  53093 |  |  |  |  |  | Email: [EMAIL]
 |  |  |  |  |  | www.naspschools.org
Organization: |  |  |  |  | [NAME]:
Contact Name: |  |  |  |  | (If different)
Ship-To Address: |  |  |  |  | City State Zip:
(NO PO Box) |  |  |  |  | Phone:
City State Zip: |  |  |  |  | Fax:
 |  |  |  |  | E-mail:
 | Evidence of Non-Profit Status: |  |  |  | Copy of 501c3 |  |  | Copy of Sales Tax Exemption
 |  | **Sales tax will be added in KY, WI, OH, and MD if sales tax exemption certificate is not rec'd.**
Payment accepted by Check, MasterCard, Visa, or [NAME]: |  |  |  |  |  |  |  | VISA / MasterCard:
 |  |  |  |  |  | Name:
PO Number: |  |  |  |  |  | Card #:
*PO Number is REQUIRED if order is not prepaid. |  |  |  |  |  | Expires: |  |  | 3-Digit Code
 |  |  |  |  |  |  | Retain CC# for future orders?       Yes       No
 | Number | Item |  |  |  | Qty |  | (Includes Shipping) | Price
Mini | 11413 | Mini Right Hand Red |  |  |  |  | Ea | $111/bow
Genesis | 11415 | Mini Right Hand Blue |  |  |  |  | Ea | $111/bow
Bows: | 11417 | Mini Right Hand Black |  |  |  |  | Ea | $111/bow
 | 11414 | [NAME] Red |  |  |  |  | Ea | $111/bow
 | 11416 | [NAME] |  |  |  |  | Ea | $111/bow
 | 11418 | [NAME] Black |  |  |  |  | Ea | $111/bow
Genesis | 10492A | Genesis Pro Right Hand Black |  |  |  |  | Ea | $131/bow |  | ***
Pro | 10496A | Genesis Pro Right Hand Black/Red |  |  |  |  | Ea | $131/bow |  | ***
Bows: | 10491A | Genesis Pro Left Hand Black |  |  |  |  | Ea | $131/bow |  | ***
 | 10497A | Genesis Pro Left Hand Black/Red |  |  |  |  | Ea | $131/bow |  | ***
Replacement | BG20014 | Right Hand Arrow Rest (Not Pro) |  |  |  |  | Ea | $8/each
Parts: | BG20015 | Left Hand Arrow Rest (Not Pro) |  |  |  |  | Ea | $8/each
 | BG20016 | Arrow Rest Plastic Sleeves (100/pack) |  |  |  |  | Pk | $40/pack
 | BG11498 | String (Orig or Pro) 94 1/4" (Blk & Wht) |  |  |  |  | Ea | $17/each
 | BG10897 | String (Orig or Pro) 94 1/4" (Blk & Red) |  |  |  |  | Ea | $17/each
 | BG11490 | [NAME] 79 1/4" (Blk and Wht) |  |  |  |  | Ea | $17/each
 | BG11491 | [NAME] 79 1/4" (Black and Red) |  |  |  |  | Ea | $17/each
 | BG11497 | Power Cable Genesis & Pro 37.25" |  |  |  |  | Ea | $10/each
 | BG11492 | Power Cable Mini 31" |  |  |  |  | Ea | $10/each
 | 50138 | Cable Rod Slide |  |  |  |  | Ea | $1/each
 | ** All prices include shipping to a commercial
 | address in the lower 48 States |  |  |  |  |  |  | Total
*** Please note - Genesis Pro does NOT include a rest.  You will have to purchase a rest separately ***
from another source.  [NAME] and [NAME] are not eligible for NASP tournament competition.
*** BY SUBMITTING AN ORDER TO NASP YOU AGREE THESE ITEMS WILL STAY PROPERTY OF THE ORGANIZATION***
*** AND WILL NOT BE RESOLD ***
Spreadsheet: 694539d1599664552-how-to-create-a-grouping-from-multiple-rows-and-assign-rankings-rankingsample
Sheet: Detail

[NAME]
 | Supplier | Product | Status
 | C-Tech | [NAME] | Planning
 | R-Cal | [NAME] | Design
 | Dragon | [NAME] | Ready
 | Dragon | Flux Capacitor | Referred
 | Halo Design | Flux Capacitor | Planning
 | TMZ | Gullwing doors
 | Doc Brown Inc | Gullwing doors | Referred
 | R-Cal | Digital Readout
 | C-Tech | Digital Readout
 | Doc Brown Inc | Digital Readout
 | TMZ | Opposable hinge | Ready
 | Dragon | Opposable hinge | Not Needed
Spreadsheet: 605761d1547251528-populate-name-vacation-date-information-into-calendar-format-in-separate-tab-leave-planner-template-v2
Sheet: October

Legend:
b | = bereavement
o | = other day off |  | o.5 | = half other day off
v | = paid vacation |  | v.5 | = half paid vacation
s | = sick day |  | s.5 | = half sick day
u | = unpaid day off |  | u.5 | = half unpaid day off
x | = present
st | = statutory holiday
 | Summary of Leave Taken This Month
Employee Name | Vacation | Sick | Unpaid | Bereavement | Statutory | Other | 2018-10-01 00:00:00 | 2018-10-02 00:00:00 | 2018-10-03 00:00:00 | 2018-10-04 00:00:00 | 2018-10-05 00:00:00 | 2018-10-06 00:00:00 | 2018-10-07 00:00:00 | 2018-10-08 00:00:00 | 2018-10-09 00:00:00 | 2018-10-10 00:00:00 | 2018-10-11 00:00:00 | 2018-10-12 00:00:00 | 2018-10-13 00:00:00 | 2018-10-14 00:00:00 | 2018-10-15 00:00:00 | 2018-10-16 00:00:00 | 2018-10-17 00:00:00 | 2018-10-18 00:00:00 | 2018-10-19 00:00:00 | 2018-10-20 00:00:00 | 2018-10-21 00:00:00 | 2018-10-22 00:00:00 | 2018-10-23 00:00:00 | 2018-10-24 00:00:00 | 2018-10-25 00:00:00 | 2018-10-26 00:00:00 | 2018-10-27 00:00:00 | 2018-10-28 00:00:00 | 2018-10-29 00:00:00 | 2018-10-30 00:00:00 | 2018-10-31 00:00:00 | # of Days Worked | # of Week Days | Days in Lieu Earned
Spreadsheet: 674616d1587951616-list-multiple-pages-and-remove-duplicates-test123-xatomicx-
Sheet: Thursday

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wednesday | Thursday (new) |  | Cumulative
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Carmen Pace
Total
Spreadsheet: 857645d1706615971-formula-for-sort-the-given-table-and-remove-the-contents-with-zero-sort-and-exclude-zero
Sheet: Sheet1

 |  |  |  | Need to eliminate this helpher table.
 |  |  |  | Sort for Descending |  |  | Sort for Descending and elimate the Zeros
 | Order delievered | 9 |  |  | 14
 | Order Cancelled | 0 |  | Under Packaging | 12
 | Under Packaging | 12 |  | Order delievered | 9
 | Items verified | 14 |  | Under delivery | 1
 | Cash not recevied | 0 |  | (No response) | 1
 | Blocked customer | 0 |  | Order Cancelled | 0
 | Order creation | 0 |  | Cash not recevied | 0
 | Cash recevied | 0 |  | Blocked customer | 0
 | Address review | 0 |  | Order creation | 0
 | Door locked | 0 |  | Cash recevied | 0
 | Vehicle not ready | 0 |  | Address review | 0
 | Under delivery | 1 |  | Door locked | 0
 | COD misused | 0 |  | Vehicle not ready | 0
 | [NAME] | 0 |  | COD misused | 0
 | (No response) | 1 |  | [NAME] | 0 |  | [NAME] for Sort the given table and remove the contents with Zero
 |  |  |  |  |  |  | Hello
 |  |  |  |  |  |  | I need to sort the given table and plot the non zero contents as shown in the attached excel file.
 |  |  |  |  |  |  | I have used 2 tables with helper formula and try to eliminate the helper table.
 |  |  |  |  |  |  | Any suggestions invited.
 |  |  |  |  |  |  | thanks in advance
Spreadsheet: 809411d1671070585-formula-to-find-a-resource-rate-and-multiple-by-days-working-in-month-and-sum-total-mth-sample
Sheet: Forecast

FORECAST
 |  |  |  | 21 | 20 | 20 | 20 | 22 | 17 | 23 | 21 | 21 | 22 | 23
Expenditure Type | Type | Resource | PO/Description | NOV | DEC | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP
CAPEX | RESOURCE | person 1 | BNI | 6 | 5
CAPEX | RESOURCE | person 6 | BNI | 6 | 5
CAPEX | RESOURCE | person 4 | BNI | 6 | 5 | 2
CAPEX | RESOURCE | person 7 | BNI | 19 | 15 | 15
CAPEX | RESOURCE | person 2 | BNI | 7 | 5 | 5
CAPEX | RESOURCE | person 8 |  |  |  | 5 | 5 | 6 | 5 | 6 | 6
CAPEX | RESOURCE | person 3 |  |  |  | 5 | 5 | 6 | 5 | 6 | 6
CAPEX | RESOURCE | person 9 |  |  |  | 5 | 5 | 2 | 2 | 0.5
CAPEX | RESOURCE | person 10 |  | 5 | 15 | 10 | 10 | 10 | 5
CAPEX | SOW |  | TBA - Vendor |  |  |  | 100000 | 100000 | 250000 | 250000 | 150000
OPEX | SOW |  | TBA - Licence |  |  |  |  | 125000 | 100000 | 100000
OPEX | SOW |  | TBA - Professional Labour |  |  | 25000 | 25000
OPEX | SOW |  | TBA - Professional Labour |  |  |  |  |  |  |  |  | 50000 | 50000 | 25000
CAPEX | SOW |  | TBA - Vendor |  |  |  |  |  |  |  |  | 150000 | 150000 | 75000
CAPEX | RESOURCE
Spreadsheet: 827514d1682768927-how-to-check-if-a-date-falls-within-weeknum-in-excel-check-if-date-falls-within-last-week-of-today
Sheet: Sheet1

 |  |  | Date | Today
 |  |  | 2022-12-31 00:00:00 | 2023-01-01 00:00:00
 | Date falls within last week from Today
 |  |  | Week starts on
 |  | Date | Sun | Mon |  | How to check if a date falls within weeknum in excel
 | 1 |  |  |  |  | https://www.excelforum.com/excel-formulas-and-functions/1404475-how-to-check-if-a-date-falls-within-weeknum-in-excel.html#post5820629
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 17
Spreadsheet: 187843d1350593108-group-sort-needed-have-burned-the-candle-at-both-ends-complete-cell-values
Sheet: Sheet1

failed reason | case #
 | 583946
 | 583946
 | 583946
Action date of 169D must be within 7 calendar days of the action date of 969L/169L, 168M/968M, 168L/968L | 583946
 | 609221
 | 609221
 | 609221
Missing or Late CSP | 609221
 | 622455
 | 622455
DVE Initiated / Re-Iniated Code not found | 622455
 | 637020
 | 637020
No VRSFCO action code found | 637020
Spreadsheet: 38358d1236520192-display-data-in-horizontal-format-task2-4a
Sheet: Sheet2

Your Base Data
Required format
 | Label | Label | Label | carton | bottle | cap | cap | tube | nozzle | tin | can | leaflet | box | pin | syringe
123456 | [NAME] | VVV |  | YYY | ZZZ | AAA | WWW
123457 | [NAME] |  |  |  |  |  |  | BBB
123458 | [NAME] | VVV | QQQ | EEE | ZZZ |  |  | BBB | GGG | JJJ | KKK | LLL
123459 |  |  |  |  |  |  |  |  |  |  |  |  | UUU
123460 |  |  |  | YYY |  |  |  | BBB |  |  |  |  |  | CCC | TTT
Spreadsheet: 88379d1288209121-sorting-and-count-keywords-database-example
Sheet: Sheet1

Goin- 983774 | Promos |  |  | Goin | Promos |  |  | Goin | 1 | FINAL PRODUCT
When Already-09093 | Other |  |  | Not Goin | Promos |  |  | Not Goin | 3
Not Goin-0909434 | Section1 |  |  | May be | Promos |  |  | May be | 2
May be-903 | Section2 |  |  | Thinking | Promos |  |  | Thinking | 2
Thinking-0993 | Section2 |  |  | Hello | Promos |  |  | Hello | 3
Hello-093 | Section2 |  |  | Hello | Promos |  |  | Hiding | 2
Hiding-737982 | Section2 |  |  | Hiding | Promos |  |  | Will Not | 2
Will Not- 0934 | Section2 |  |  | Will Not | Promos
Not Goin-0909434 | Promos |  |  | Not Goin | Promos
May be-903 | Promos |  |  | Hiding | Promos
Thinking-0993 | Promos |  |  | Will Not | Promos
Hello-093 | Promos |  |  | Not Goin | Promos
Hiding-737982 | Section2 |  |  | May be | Promos
Will Not- 0934 | Section2 |  |  | Thinking | Promos
Not Goin-0909434 | Section2 |  |  | Hello | Promos
May be-903 | Section2
Thinking-0993 | Section2
Hello-093 | Section2
Hiding-737982 | Section2
Will Not- 0934 | Section2
Hiding-737982 | Section2
Will Not- 0934 | Other
Not Goin-0909434 | Other
May be-903 | Other
Thinking-0993 | Other
Hello-093 | Promos
Hiding-737982 | Promos
Will Not- 0934 | Promos
Not Goin-0909434 | Promos
May be-903 | Other
Thinking-0993 | Other
Hello-093 | Other
Hiding-737982 | Promos
Will Not- 0934 | Promos
Not Goin-0909434 | Promos
May be-903 | Promos
Thinking-0993 | Promos
Hello-093 | Promos
Spreadsheet: 204267d1357418268-relating-columns-of-data-to-a-name-example
Sheet: Sheet1

Name |  |  |  |  |  | Column 1 | Column 2 | Column 3
1 |  | 750 |  |  | First
2 |  | 750 |  |  | Second
3 |  | 790 |  |  | Third
4 |  | 700 | 50 |  |  | Column 1 | Column 2 | Column 3
5 | 10 | 660 |  |  | First
6 | 20 |  | 750 |  | Second
7 | 10 |  | 750 |  | Third
8 |  |  | 750
9 |  |  | 650
10 |  |  | 810
11 |  | 300 | 535
12 | 30 |  | 810
13 | 445 | 650 | 30
14 | 720 |  | 10
15 | 40
16 |  | 30
17 | 750
18 |  | 320 | 570
19 | 222 | 212 | 192
20 | 750
21 | 520 | 700
22 | 800 | 20
23 | 750
24 | 222 | 192 | 222
25 | 30 |  | 730
Spreadsheet: 108612d1305645680-collating-data-from-multiple-sheets-wages
Sheet: Piotr Wasilewski

Date Invoiced | Invoice Number | Invoice Value | Payment Due | Net Amount | CIS Amount | Paid Employee | Paid CIS | Overdue |  | Amounts Match? |  | Yes/No Options
2011-04-29 00:00:00 | 000015 | 200 |  |  |  |  |  |  |  |  |  | Yes
2011-05-06 00:00:00 | 000016 | 250 |  |  |  |  |  |  |  |  |  | No
2011-05-13 00:00:00 | 000017 | 250
Spreadsheet: 713533d1610766622-automatically-filter-out-row-based-on-cell-value-example-workbook
Sheet: Sheet1

Order Date | First Name | Last Name | [NAME] | Job Title | Company |  | Order Date | First Name | Last Name | [NAME] | Job Title | Company
2021-01-02 00:00:00 | [NAME] | Doe | [EMAIL] | OSR | Smith LLC
2021-01-02 00:00:00 | Al | Doe | [EMAIL] | ISR | Johnson Inc.
2021-01-02 00:00:00 | Greg | Doe | [EMAIL] | ISR | Smith LLC
2021-01-02 00:00:00 | Peggy | Doe | [EMAIL] | OSR | Johnson Inc.
 |  |  | INPUT TABLE |  |  |  | OUTCOME TABLE
Spreadsheet: darrell_schoolcraft__7797__imbalsumm0107
Sheet: PNM

PNM imbalance
 | Measured | Scheduled | Imbalance
9236 | -67379 | -46256
9238 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
56422 | -2580271 | -2766526
58710 | -29412 | -6358
60921 | 2310218 | 2292027
78026 |  | 50311
500084 | -13782 | -28000
500085 | -7993
500097 | -512
INDEX
2001-06-30 00:00:00 |  |  | 692868.31
2001-07-28 00:00:00
Spreadsheet: 483018d1475429224-using-excel-to-write-wiring-connection-plan-sorting-wire-connection-by-gk-mod
Sheet: Sheet3

Other thing | Cable | Apparatus | Terminal | Terminal BLOCK | Terminal CONNECTION | Aparatus | Terminal | Cable | Other thing
Spreadsheet: 91118d1290797247-vlookup-multiple-sheets-in-a-different-other-file-samp_b
Sheet: v25-35

C-code |  |  |  | Qty
c123 |  | xxx | yyy | 7
c125 |  | xxx | yyy | 2
c126 |  | xxx | yyy | 5
c124 |  | xxx | yyy | 4
c128 |  | xxx | yyy | 2
c127 |  | xxx | yyy | 1
Spreadsheet: 880468d1728276202-filter-functions-with-combobox-example-2-1-
Sheet: Raw

Company | Month | Level | Partcipant | Training Topic | Department | Training hours | Amount | Result
A | Jan | Manager | [NAME] | Excel | GA | 6 | 50 | Passed |  |  |  |  |  |  |  | Topics | Dept | Company
A | Jan | Staff | [NAME] | Excel | HR | 6 | 50 | Passed |  |  |  |  |  |  |  | Excel | GA | A
A | Feb | Staff | Marlyn | Excel | HR | 6 | 50 | Passed |  | Cell link Topics | 4 |  |  |  |  | Powerpoint | HR | B
B | Feb | Manager | [NAME] | Excel | Sales | 6 | 55 | Passed |  | Cell link Dept | 6 |  |  |  |  | Power BI | Sales | C
B | Mar | Manager | [NAME] | Powerpoint | Sales | 5 | 30 | Not Passed |  | Cell link Company | 4 |  |  |  |  | ALL | Finance | ALL
B | Mar | Staff | Cathy | Powerpoint | Finance | 5 | 30 | Passed |  |  |  |  |  |  |  |  | Logistics
C | Mar | Staff | [NAME] | Power BI | Finance | 7 | 60 | Not Passed |  |  | Topics |  |  |  |  |  | ALL
C | Mar | Staff | Michelle | Powerpoint | Logistics | 5 | 50 | Passed
C | Apr | Staff | Michelle | Excel | Logistics | 6 | 60 | Not Passed
 | Total training hour by Topic |  |  | if choose topic=ALL, dept = ALL, company = ALL then hours = 18 |  |  |  |  |  |  | Dept
 |  |  |  | if choose topic=ALL,dept =sales, company =B then hours =11
 | Dept | Amount
 | GA |  |  |  |  |  |  |  |  |  | Company
 | HR
 | Sales
 | Finance
 | Logistics
 | Dept | Total Participant passed
 | GA
 | HR
 | Sales
 | Finance
 | Logistics
 | Level | Total Participant passed
 | Staff
 | Manager
Spreadsheet: 159788d1338843035-excel-2007-i-need-a-formula-to-calculate-six-months-at-a-time-from-separate-sheet-tabs-hr-calendar-with-formulas
Sheet: Jun

 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY |  | 1. Absent - EX  2. Absent - UN  3. Bereavement  4. Discipline  5. FMLA  6. Tardy
 |  |  | NOTES:
 |  |  | Type in Employee's Last Name and the Corresponding Number
Spreadsheet: 684400d1593347638-fixture-list-table-needed-excel-help-needed-table-of-unique-jobs
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | SCORE KEY | 0 : Job1 = Job2
 |  |  |  |  |  |  |  |  |  | 1 : Job1 > Job2
 | This will be a unique ID | There could be a few 100 of these! |  |  |  |  |  |  |  | 2 : Job2 > Job1
 | JobRef | Description |  |  |  |  |  | Job 1 | Job 2 | Response |  | understanding
 | 1 | A |  |  | B |  |  |  |  |  |  | in this case Job A = Job B
 | 2 | B |  | A | C |  |  |  |  |  |  | In this case Job A > Job B
 | 3 | C |  | A | D |  |  |  |  |  |  | In this case Job A < Job B
 | 4 | D |  | A | E |  |  |  |  |  |  | In this case Job A < Job B
 | 5 | E |  | A | F |  |  |  |  |  |  | In this case Job A > Job B
 | 6 | F |  | A | G
 | 7 | G |  | A | H |  |  | etc….
 | 8 | H |  | A | I
 | 9 | I |  | A | J
 | 10 | J |  | B | C
 |  |  |  | B | D
 |  |  |  | B | E
 |  |  |  | B | F
 |  |  |  | B | G
 |  |  |  | B | H
 |  |  |  | B | I
 |  |  |  | B | J
 |  |  |  | C | D
 |  |  |  | C | E
 |  |  |  | C | F
 |  |  |  | C | G
 |  |  |  | C | H
 |  |  |  | C | I
 |  |  |  | C | J
 |  |  |  | D | E
 |  |  |  | D | F
 |  |  |  | D | G
 |  |  |  | D | H
 |  |  |  | D | I
 |  |  |  | D | J
 |  |  |  | E | F
 |  |  |  | E | G
 |  |  |  | E | H
 |  |  |  | E | I
 |  |  |  | E | J
 |  |  |  | F | G
 |  |  |  | F | H
 |  |  |  | F | I
 |  |  |  | F | J
 |  |  |  | G | H
 |  |  |  | G | I
 |  |  |  | G | J
 |  |  |  | H | I
 |  |  |  | H | J
 |  |  |  | I | J
Spreadsheet: 672608d1586936301-subtract-until-0-then-move-to-next-cell-to-subtract-until-0-zeszyt4
Sheet: Sheet1

 | Units | Units from | to | Output |  |  |  |  |  | Each product has 41 units | units | Range from | to
Person 1 | 25 |  |  |  |  |  |  |  |  | Product 1 | 41
Person 2 | 10 |  |  |  |  |  |  |  |  | Product 2 | 41
Person 3 | 12 |  |  |  |  |  |  |  |  | Product 3 | 41
Person 4 | 15 |  |  |  |  |  |  |  |  | Product 4 | 41
Person 5 | 20 |  |  |  |  |  |  |  |  | Product 5 | 41
Person 6 | 21
Person 7 | 18
Person 8 | 17
Person 9 | 22
Person 10 | 16
Example of Output
Person 1 | Product 1 | 25
Person 2 | Product 1 | 10
Person 3 | Product 1 | 6
 | Product 2 | 6
Spreadsheet: 83083d1283151471-copy-only-values-skip-n-a-copy-matching-values
Sheet: Sheet1

columns compared is B and C result only matching numbers | W.O. | Series of W.O.s | Copy only matching numbers without N/A's
123 | 123 | 123 | 123
#N/A | 124 | 985 | 125
125 | 125 | 125 | 127
#N/A | 126 | 245 | 129
127 | 127 | 127 | 131
#N/A | 128 | 278 | 133
129 | 129 | 129 | 135
#N/A | 130 | 788 | 137
131 | 131 | 131 | 139
#N/A | 132 | 522 | 141
133 | 133 | 133 | 143
#N/A | 134 | 2121
135 | 135 | 135
#N/A | 136 | 455
137 | 137 | 137
#N/A | 138 | 795
139 | 139 | 139
#N/A | 140 | 465
141 | 141 | 141
#N/A | 142 | 147
143 | 143 | 143
Spreadsheet: 78830d1279129684-calculating-avergae-weekly-workload-based-on-2-columns-of-dates-anygivenweek
Sheet: Sheet1

Beginning | Ending |  | Week of
2010-01-05 00:00:00 | 2010-01-15 00:00:00 |  | 2010-02-15 00:00:00 | 2010-02-19 00:00:00
2010-01-06 00:00:00 | 2010-01-13 00:00:00 |  | Ongoing Projects
2010-01-08 00:00:00 | 2010-01-14 00:00:00
2010-01-09 00:00:00 | 2010-01-19 00:00:00
2010-01-13 00:00:00 | 2010-01-20 00:00:00
2010-01-17 00:00:00 | 2010-02-01 00:00:00
2010-01-17 00:00:00 | 2010-01-30 00:00:00
2010-01-21 00:00:00 | 2010-02-04 00:00:00
2010-01-21 00:00:00 | 2010-02-03 00:00:00
2010-01-27 00:00:00 | 2010-02-03 00:00:00
2010-01-29 00:00:00 | 2010-02-10 00:00:00
2010-01-29 00:00:00 | 2010-02-12 00:00:00
2010-02-02 00:00:00 | 2010-02-12 00:00:00
2010-02-02 00:00:00 | 2010-02-13 00:00:00
2010-02-03 00:00:00 | 2010-02-13 00:00:00
2010-02-04 00:00:00 | 2010-02-13 00:00:00
2010-02-06 00:00:00 | 2010-02-11 00:00:00
2010-02-11 00:00:00 | 2010-02-22 00:00:00
2010-02-14 00:00:00 | 2010-02-22 00:00:00
2010-02-16 00:00:00 | 2010-02-25 00:00:00
2010-02-22 00:00:00 | 2010-03-03 00:00:00
2010-02-24 00:00:00 | 2010-03-07 00:00:00
2010-02-26 00:00:00 | 2010-03-13 00:00:00
2010-02-28 00:00:00 | 2010-03-13 00:00:00
2010-03-03 00:00:00 | 2010-03-15 00:00:00
2010-03-03 00:00:00 | 2010-03-15 00:00:00
2010-03-10 00:00:00 | 2010-03-19 00:00:00
2010-03-12 00:00:00 | 2010-03-18 00:00:00
2010-03-13 00:00:00 | 2010-03-27 00:00:00
Spreadsheet: 330754d1404843913-transpose-lines-and-alternate-columns-test1
Sheet: Folha1

 | x | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | xn…
I have this:
 | y1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | y2 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | y3 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | y4 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | y5 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | y6 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | yn..
 |  | x | y1 | x | y2 | x | y3 | x | y4 | x | y5
I need this: |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
 |  | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
 |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
 |  | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6
 |  | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7
 |  | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8
 |  | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9
 |  | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
Spreadsheet: 221214d1363419648-nearest-value-yyy
Sheet: version 1

236 | 141 | 300 | 150 | North | 1 |  |  |  |  |  | Coords |  | Latitude |  | Logitude
 | 141 | 300 | 300 | Central |  |  |  |  |  |  | 142630307
 | 141 | 300 | 450 | South
 | 141 | 150 | 300 | West
 | 141 | 450 | 300 | East |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 141599 | 236
237 | 141 | 900 | 150 | North |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 142199 | 237
 | 141 | 900 | 300 | Central |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 142200 | 238
 | 141 | 900 | 450 | South
 | 141 | 750 | 300 | West
 | 142 | 050 | 300 | East
238 | 142 | 500 | 150 | North |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 141600600 | 141600000
 | 142 | 500 | 300 | Central |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 142200600 | 142200000
 | 142 | 500 | 450 | South
 | 142 | 350 | 300 | West
 | 142 | 650 | 300 | East
239 |  |  |  | North
 |  |  |  | Central
 |  |  |  | South
 |  |  |  | West
 |  |  |  | East
Spreadsheet: sara_shackleton__36407__PHONE_LIST
Sheet: ext. Rio office

[NAME] do [NAME]. |  |  |  |  | [NAME] do [NAME].
RIO DE JANEIRO OFFICE |  |  |  |  | RIO DE JANEIRO OFFICE
Av. [NAME], 01 - 9º andar/setor A - 20090-003 - Rio de Janeiro - Brasil                                          Tel. 55 21 550 -8870    Fax. 55 21 550-8888  CGC 00624942/002-21 IE: ISENTA |  |  |  |  | Av. [NAME], 01 - 9º andar/setor A - 20090-003 - Rio de Janeiro - Brasil                                          Tel. 55 21 550 -8870    Fax. 55 21 550-8888  CGC 00624942/002-21 IE: ISENTA
 | STAFF & SUPPORT TELEPHONE |  |  |  | GENERAL
NAME | DEPARTMENT | EXTENSION | FLOOR |  | CONFERENCE ROOM
[NAME] | Administrative | 3036 | 9th |  |  | Conference Room 9C1 | 3032
Andréa Gavino | Legal | 3029 | 9th |  |  | Conference Room 9C2 | 3033
Ane Borges | Administrative | 3026 | 9th |  |  | Conference Room 9C3 | 3017
[NAME] | Commercial Devolopment | 3050 | 9th
[NAME] | Administrative | 3011 | 9th |  | [NAME]
[NAME] | Operations | 3049 | 9th |  |  | Library | 3045
Fernanda Figueiredo | Administrative | 3020 | 9th
[NAME] | Operations | 3021 | 9th |  | RECEPTION
[NAME] | Legal | 3051 | 9th |  |  | Ane Borges | 3026
Isabel Pojo | Finance | 3043 | 9th |  |  | Visitors | 3022
[NAME] | Finance | 3018 | 9th
[NAME] | Origination | 3045 | 9th |  | FAXES
[NAME] | Origination | 3015 | 9th |  |  | Office | 550-8888
[NAME] | Legal | 3027 | 9th |  |  | [NAME] | 550-8887
[NAME] | Regional Director | 3013 | 9th |  |  | Legal | 550-8886
[NAME] | Administrative | 3041 | 9th
[NAME] | Administrative | 3016 | 9th
[NAME] | Finance | 3019 | 9th
Orlando Puppin | Executive Staff | 3014 | 9th |  | VISITORS
[NAME] | Legal | 3034 | 9th |  |  | [NAME] | extension:  3012
[NAME] | Finance | 3048 | 9th |  |  |  | cell phone: 021 9648-6292
[NAME] | Commercial Devolopment | 3050 | 9th
[NAME] | Operations | 3046 | 9th
[NAME] | Executive Staff | 3010 | 9th
[NAME] | Operations | 3028 | 9th
Rodrigo Benevides | Systems | 3044 | 9th
[NAME] | Administrative | 3041 | 9th
[NAME] | Operations | 3023 | 9th
Valéria Amoroso Lima | Finance | 3040 | 9th
[NAME] | Legal | 3025 | 9th
[NAME] | Operations | 3047 | 9th
Spreadsheet: 717424d1612642131-numbering-returned-matches-in-array-by-date-excel-forum-example
Sheet: Sheet1

Item | Position | Type | Date | Helper | Desired Outcome
10000 | 1
10003 | 1 | [NAME] | 2021-01-04 00:00:00
10005 | 1
10004 | 1
10004 | 2
10003 | 1 | Apple | 2021-01-15 00:00:00 |  | 1
10001 | 1
10007 | 1
10003 | 1 | Apple | 2021-02-01 00:00:00 |  | 2
9865 | 1
10008 | 1
10009 | 1
10003 | 1 | Apple | 2021-02-07 00:00:00 |  | 3