tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 56054d1256181435-summarize-info-from-line-item-cash-flow-worksheet-703947-summarize-info-from-line-item-cash-flow-worksheet2
Sheet: August

Date | Code | Description | Voucher # | I / E | $ Type | Amount | USD | Baht | [NAME] | Cash Flow (USD) | Income USD | Expense USD | USD
 |  |  |  | I, E | D B K |  | Totals | Totals | Totals |  | Total | Total |  |  | USD | Baht | [NAME] |  | USD | Baht | [NAME]
Total Balance
Total Income
Total Expense |  |  |  |  |  |  |  |  |  | [NAME] | Baht Run Balance | [NAME]
 |  |  |  |  |  |  | Daily Transactions
2009-07-31 00:00:00 | - | Balance Forward September | - | I | D | 0 | 379
2009-07-31 00:00:00 | - | Balance Forward September | - | I | B | 0 |  | 8363.5
2009-07-31 00:00:00 | - | Balance Forward September | - | I | K | 0 |  |  | 975000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cashflow | Currency Conversion
2009-07-31 00:00:00 | - | Adjustment to Books | - | I | D | 51 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Baht | [NAME]
2009-07-31 00:00:00 | - | Adjustment to Books | - | I | B | 126 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33 | 8600
2009-07-31 00:00:00 | - | Adjustment to Books | - | e | K | 129000
 | 6-0510 | Postage | 8-3292 | e | k | 34000 | 1
 | 6-0330 | Driver's License - S Carlisle | 8-3293 | e | k | 50000
 | 6-0670 | Medicine for Ki Vang | 8-3294 | e | k | 39000
 | 6-0501 | Petrol | 8-3295 | e | k | 10000
 | 6-0520 | Unsure | 8-3296 | e | k | 60000
 | 6-0520 | Unsure | 8-3297 | e | k | 24000 | 50 |  | 0
 | 6-0500 | Parking fee | 8-3298 | e | k | 2000 | 50 |  | 0
 | 6-0500 | Parking fee | 8-3299 | e | k | 2000
 | 6-0670 | Medicine for Neng | 8-3300 | e | k | 37000
 | 6-0541 | Magazine cost | 8-3301 | e | k | 30000
 | 6-0500 | Parking fee | 8-3302 | e | k | 4000 |  | 100 | 0
 | 6-0501 | Petrol and oil | 8-3303 | e | k | 10000 |  | 100 | 0
 | 6-0510 | Postage fees | 8-3304 | e | k | 20000
 | 6-0510 | Postage fees | 8-3305 | e | k | 28000
 | 6-0501 | Petrol - DP for month of Sep | 8-3306 | e | k | 279000
 | 6-0671 | Drinking water | 8-3307 | e | k | 24000
 | 6-0720 | Cooking gas | 8-3308 | e | k | 149000
 | 6-0510 | Postage, freight to [NAME] | 8-3309 | e | k | 23000
Spreadsheet: 1e25bab8-460e-47e5-8e7f-1347e6191800
Sheet: LW_Temp_Ozone_Data

 | Daily Ozone Maximum (ppb) | TMAX (F) - Surface Obs | LW Up Allsky radiation (w/m2) | LW - Temperature (C) | LW - Temperature (F)
2007-08-01 00:00:00 | 62 | 96.98
2007-08-02 00:00:00 | 62 | 98.06
2007-08-03 00:00:00 | 67 | 96.98
2007-08-04 00:00:00 | 66 | 96.98
2007-08-05 00:00:00 | 56 | 95
2007-08-06 00:00:00 | 55 | 96.08
2007-08-07 00:00:00 | 31 | 96.08
2007-08-08 00:00:00 | 42 | 96.98
2007-08-09 00:00:00 | 58 | 98.96
2007-08-10 00:00:00 | 63 | 102.02
2007-08-11 00:00:00 | 64 | 102.02
2007-08-12 00:00:00 | 65 | 102.92
2007-08-13 00:00:00 | 72 | 105.08
2007-08-14 00:00:00 | 71 | 104
2007-08-15 00:00:00 | 89 | 105.98
2007-08-16 00:00:00 | 81 | 105.08
2007-08-17 00:00:00 | 68 | 102.02
2007-08-18 00:00:00 | 82 | 100.94
2007-08-19 00:00:00 | 62 | 95
2007-08-20 00:00:00 | 57 | 95
2007-08-21 00:00:00 | 60 | 96.98
2007-08-22 00:00:00 | 59 | 100.04
2007-08-23 00:00:00 | 68 | 100.04
2007-08-24 00:00:00 | 64 | 100.04
2007-08-25 00:00:00 | 58 | 96.98
2007-08-26 00:00:00 | 55 | 96.08
2007-08-27 00:00:00 | 66 | 100.94
2007-08-28 00:00:00 | 64 | 93.02000000000001
2007-08-29 00:00:00 | 68 | 98.96
2007-08-30 00:00:00 | 76 | 96.08
2007-08-31 00:00:00 | 64 | 93.92
Spreadsheet: 98147d1297182168-group-by-date-and-count-groupby_counting
Sheet: Sheet2

 |  |  |  |  |  | SAR (DATE & NUMBER)
 |  |  |  |  |  | DATE | NUMBER
Spreadsheet: 704fd552-caba-4ee2-958f-bf16f64aa297
Sheet: Sheet1

C.elegans homolog | filarial gene ID | description
T05G5.3 | 14907.m00582 | CAE65141.1| Hypothetical protein CBG10007
Y105E8A.8 | BMW00012 | NP_659073.1| WD repeat domain 79 [Mus musculus]
B0035.4 | 14972.m07043 | CAE62053.1| Hypothetical protein CBG06071 (Prefoldin subunit)
[NAME] | 14972.m07828 | CAC70149.1| putative pre-mrna cleavage factor
[NAME] | 14570.m00059 | EAL33024.1| GA14824-PA [Drosophila
T14G10.6 | 14992.m11338 | NP_501853.1| T14G10.6 ([NAME] family integral membrane protein) [Caenorhabditis elegans]
T24H10.4 | 14977.m04913 | CAE59804.1| Hypothetical protein CBG03266 ( Eukaryotic protein of unknown function (DUF829 )
C37C3.1 | BMC03411 | CAG06358.1| unnamed protein product [Tetraodon
F25B3.6 | 14963.m01804 | [NAME] PREDICTED: similar to CG10955-PA [Apis mellifera]
F35H10.7 | 15196.m00035 | NP_501396.1| F35H10.7 (Uncharacterized conserved protein) [Caenorhabditis elegans]
C32D5.10 | 14981.m02383 | EAL25260.1| GA13494-PA [Drosophila
F28C6.6 | BMW01413 | XP_796577.2| PREDICTED: similar to Cleavage stimulation factor, 3 pre-RNA, subunit 3, 77kDa [Strongylocentrotus purpuratus]
K07C5.8 | 14992.m11191 | [NAME] PREDICTED: similar to Striatin-3 (Cell-cycle autoantigen SG2NA) (S/G2 antigen) [Strongylocentrotus purpuratus]
C44B7.10 | 14975.m04535 | NP_495409.3| C44B7.10 (Acetyl-CoA hydrolase ) [Caenorhabditis
R11E3.6 | 14651.m00258 | NP_001013397.2| hypothetical protein LOC234358 [Mus musculus]
C16C2.3 | 14990.m07775 | BAC33188.1| unnamed protein product [Mus
Spreadsheet: 142196d1329725438-data-entry-new-dcr-format
Sheet: week4

ABM/SR. ABM  WEEKLY REPORT
[Soft copy to be submitted on every Monday by 11 AM]
Name: |  |  |  |  |  | HQ |  |  |  |  |  | Date of Posting
Week No: |  | 4 |  |  |  | From: |  |  |  |  |  | To:
Date : |  |  |  |  |  | Date : |  |  |  |  |  | Date :
Mon Worked with: |  |  |  |  |  | Tue Worked with: |  |  |  |  |  | Wed Worked with:
Place: |  |  |  |  |  | Place: |  |  |  |  |  | Place: |  |  |  |  |  | A+
Name of Doctor |  | Cat | Speciality | Activity |  | Name of Doctor |  | Cat | Speciality | Activity |  | Name of Doctor |  | Cat | Speciality | Activity |  | A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PHY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DENTIST
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SKIN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ENT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PEAD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ORTHO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SURGN
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RMP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FIELD WORK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | STOKIST VISIT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MEETING
No of  Dr.s visited |  |  | No of VIP Dr |  |  | No of  Dr.s visited |  |  | No of VIP Dr |  |  | No of  Dr.s visited |  |  | No of VIP Dr |  |  | ADMIN WORK
Day Utilised |  |  | Chemist: |  |  | Day Utilised |  |  | Chemist: |  |  | Day Utilised |  |  | Chemist: |  |  | LEAVE
Work Type |  |  | Stockist: |  |  | Work Type |  |  | Stockist: |  |  | Work Type |  |  | Stockist:
[NAME] with: |  |  |  |  |  | [NAME] with: |  |  |  |  |  | [NAME] with:
Place: |  |  |  |  |  | Place: |  |  |  |  |  | Place:
Name of Doctor |  | Cat | Speciality | Activity |  | Name of Doctor |  | Cat | Speciality | Activity |  | Name of Doctor |  | Cat | Speciality | Activity
No of  Dr.s visited |  |  | No of VIP Dr |  |  | No of  Dr.s visited |  |  | No of VIP Dr |  |  | No of  Dr.s visited |  |  | No of VIP Dr
Day Utilised |  |  | Chemist: |  |  | Day Utilised |  |  | Chemist: |  |  | Day Utilised |  |  | Chemist:
Work Type |  |  | Stockist: |  |  | Work Type |  |  | Stockist: |  |  | Work Type |  |  | Stockist:
Particulars |  |  | Week | Cumulative
Total Dr. Calls [Self]
Total VIP Drs met  [Self]
[NAME]  [Self]
Stockist Calls  [Self]
Dr. [NAME].  [Self]
Chemist [NAME].  [Self]
No. of Field Working Days  [Self]
Total Dr. Calls [Team]
Total VIP Drs met   [Team]
[NAME]  [Team]
POB total [Team]
Primary Sales [Team]
Collection   [Team]
Spreadsheet: 117404d1312789322-excel-2007-help-with-excel-vlookup-invoicesample
Sheet: Sheet8

[NAME] | [NAME]
[NAME]
Aspen Paper Product | upon request
Astra Paper Company | under gainsway
[NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 8.4
 |  |  |  |  |  |  |  |  |  |  |  |  | 8.4
 |  |  |  |  |  |  |  |  |  |  |  |  | 8.7
 |  |  |  |  |  |  |  |  |  |  |  |  | 8.4
 |  |  |  |  |  |  |  |  |  |  |  |  | 8.4
 |  |  |  |  |  |  |  |  |  |  |  |  | 8.4
 |  |  |  |  |  |  |  |  |  |  |  |  | 8.4
 |  |  |  |  |  |  |  |  |  |  |  |  | 8.7
 |  |  |  |  |  |  |  |  |  |  |  |  | 8.4
 |  |  |  |  |  |  |  |  |  |  |  |  | 8.4
 |  |  |  |  | 1 | c/s | 200 | pcs | compo | [NAME] | 80s
 |  |  |  |  | 1 | c/s | 200 | pcs | compo | capt barbel | 80s
 |  |  |  |  | 1 | c/s | 200 | pcs | compo | [NAME] | 80s
[NAME] | [NAME] |  |  |  | 1 | c/s |  |  | grade pad | pilot | 1
 |  |  |  |  | 1 | c/s | 200 | pcs | writing | classmate | 80s w/cover
 |  |  |  |  | 100 | pcs |  |  | writing | classmate | 80s w/cover
 |  |  |  |  | 300 | pcs |  |  | notebook | 8s0 | cover
 |  |  |  |  | 150 | pcs |  |  | grade pad | pilot
 |  |  |  |  | 50 | pcs |  |  | longpad | access
 |  |  |  |  | 50 | pcs |  |  | 1/2 cw | astra
 |  |  |  |  | 50 | pcs |  |  | 1/2 lw | astra
 |  |  |  |  | 50 | pcs |  |  | 1/4 q pad | astra
 |  |  |  |  | 20 | pcs |  |  | yellow pad | silver
 |  |  |  |  | 100 | pcs |  |  | cartolina | colored | us
 |  |  |  |  | 4 | roll |  |  | manila paper
 |  |  |  |  | 4 | ream |  |  | ultra bright | shades
 |  |  |  |  | 100 | pcs |  |  | [NAME] | short
 |  |  |  |  | 100 | pcs |  |  | [NAME] | long
 |  |  |  |  | 50 | pcs |  |  | non expand | env plastic | short
 |  |  |  |  | 100 | pcs |  |  | non expand | env plastic | long
 |  |  |  |  | 100 | pcs |  |  | notebook | 80s | spiral
 |  |  |  |  | 6 | doz |  |  | mongol | penciol
 |  |  |  |  | 6 | doz |  |  | mongol | XL
 |  |  |  |  | 3 | doz |  |  | g medal | 8
 |  |  |  |  | 7 | doz |  |  | g medal | 16
 |  |  |  |  | 36 | set |  |  | so big | crayon
 |  |  |  |  | 50 | pcs |  |  | illust board | 10x15
 |  |  |  |  | 20 | pcs |  |  | illust board | 15x20
 |  |  |  |  | 20 | pcs |  |  | illust board | 20x30
 |  |  |  |  | 100 | pcs |  |  | window card
 |  |  |  |  | 10 | pcs |  |  | [NAME] | 6x8 | 80s
 |  |  |  |  | 12 | doz |  |  | ballpen | [NAME]
 |  |  |  |  | 100 | pcs |  |  | ballpen | matrix
 |  |  |  |  | 50 | pcs |  |  | ballpen | [NAME]
 |  |  |  |  | 30 | pcs |  |  | clay | single
 |  |  |  |  | 5 | box |  |  | fastener | plastic
 |  |  |  |  | 5 | box |  |  | paste | small
 |  |  |  |  | 5 | box |  |  | paste | med
 |  |  |  |  | 5 | doz |  |  | hbw | glue | small
 |  |  |  |  | 10 | pcs |  |  | university | 80s | spiral
 |  |  |  |  | 60 | pcs |  |  | spelling book | 123 | vanda
 |  |  |  |  | 40 | pcs |  |  | spelling book | 456 | vanda
 |  |  |  |  | 40 | pack |  |  | popsicle stick | colored
 |  |  |  |  | 5 | doz |  |  | hbw | marker
 |  |  |  |  | 4 | doz |  |  | pilot | marker
 |  |  |  |  | 10 | doz |  |  | sharpener | double
 |  |  |  |  |  | pack |  |  | glitter | 1/4 kilo
 |  |  |  |  |  |  |  |  |  | butterfly
Spreadsheet: 829573d1684320260-how-to-count-how-many-times-2-cell-are-in-the-same-row-in-a-table-byrow-lambda-sum-countif-aligw
Sheet: Sheet1

1 | 2 | 7 | 18 | 26 | 29 | 32 |  |  | AliGW: |  |  |  | 1
2 | 3 | 5 | 17 | 19 | 26 | 34 |  |  |  |  |  |  | 2
1 | 2 | 4 | 8 | 14 | 17 | 28
Spreadsheet: 164934d1340963307-look-values-with-a-twist-0alook-up-query-v2martins
Sheet: Result

Account | Amount | Cost Center
5000001 |  | 1405801100 | 50000011405801100 |  | 8861.25
5000001 | 37980.95 | 1505800650 | 50000011505800650 |  | 37980.95
5000001 | 58436.78 | 1705800001 | 50000011705800001 |  | 58436.78
5000001 | 130282.09 | 1705800002 | 50000011705800002 |  | 130282.09
5000001 | 10081.42 | 1705800012 | 50000011705800012 |  | 10081.42
5000001 | 26357 | 1705800022 | 50000011705800022 |  | 26357
5000001 |  | 1805800004 | 50000011805800004
5000001 | 6988.5 | 1805800005 | 50000011805800005 |  | 6988.5
5000001 | 23385.01 | 1805800018 | 50000011805800018 |  | 23385.01
5000001 | 6524.8 | 1805800035 | 50000011805800035 |  | 6524.8
5000001 | 11818.58 | 1805807100 | 50000011805807100 |  | 11818.58
5000001 | 17259.92 | 1905800002 | 50000011905800002 |  | 17259.92
5000001 | 19736.79 | 2305800001 | 50000012305800001 |  | 19736.79
5010001 |  | 1705800001 | 50100011705800001
5010001 |  | 1705800002 | 50100011705800002
5010001 |  | 1705800012 | 50100011705800012
5010001 |  | 2305800001 | 50100012305800001
5010015 | 6779 | 1505800650 | 50100151505800650 |  | 6779
5010015 |  | 1805800005 | 50100151805800005
5010015 | 5352 | 1805807100 | 50100151805807100 |  | 5352
5010015 |  | 1805800035 | 50100151805800035
5010015 | 2182 | 2305800001 | 50100152305800001 |  | 2182
5010015 |  | 1805800004 | 50100151805800004
5010015 | 3803 | 1805800018 | 50100151805800018 |  | 3803
5010015 |  | 1905800002 | 50100151905800002
5010015 | 3545 | 1405801100 | 50100151405801100 |  | 3545
5010015 |  | 1805800004 | 50100151805800004
5010015 |  | 1805800005 | 50100151805800005
5010015 |  | 1805800035 | 50100151805800035
1379001 |  | X | 1379001X
2203015 |  | X | 2203015X
2206001 |  | X | 2206001X
2200001 |  | X | 2200001X
 | 370512.84
 | To look values from [NAME] and insert above
Spreadsheet: 693314d1598911477-help-with-index-match-max-and-avg-formulas-given-multiple-criteria-tracker-sample
Sheet: Calc

 |  |  | 2020-08-06 00:00:00
Category | Community |  | End Inventory | [NAME] | Avg
Product #1 | Name #1
Product #1 | Name #2
Product #1 | Name #3
Category | Community |  | End Inventory | [NAME] | Avg
Product #2 | Name #1
Product #2 | Name #2
Product #2 | Name #3
Spreadsheet: 830262d1684832466-split-data-which-uses-from-1-cell-to-multiple-row-split-ipadd
Sheet: Sheet1

DATA looks like this
ABC | any | 10.124.123.10;10.12.1.68;10.127.160.2 | any | TCP-121;TCP-13
XYZ | any | 10.12.161.100;10.12.169.149;10.12.209.111 | any | TCP-15;TCP-19;TCP-545;UDP-145-123;UDP-45;UDP-125
AAA | any | 10.128.123.2;10.128.169.128;10.128.178.22;10.2.142.9;10.121.9.13 | any | TCP-6382
CCC | any | 10.11.19.14;10.18.15.17;10.13.19.3 | any | application-default
DDD | any | 10.85.45.4
RESULT: Would like to split the IP address in each row with data repeated.
ABC | any | 10.124.123.10 | any | TCP-121;TCP-13
ABC | any | 10.12.1.68 | any | TCP-121;TCP-13
ABC | any | 10.127.160.2 | any | TCP-121;TCP-13
XYZ | any | 10.12.161.100 | any | TCP-15;TCP-19;TCP-545;UDP-145-123;UDP-45;UDP-125
XYZ | any | 10.12.169.149 | any | TCP-15;TCP-19;TCP-545;UDP-145-123;UDP-45;UDP-125
XYZ | any | 10.12.209.111 | any | TCP-15;TCP-19;TCP-545;UDP-145-123;UDP-45;UDP-125
AAA | any | 10.128.123.2 | any | TCP-6382
AAA | any | 10.128.169.128 | any | TCP-6382
AAA | any | 10.128.178.22 | any | TCP-6382
AAA | any | 10.2.142.9 | any | TCP-6382
AAA | any | 10.121.9.13 | any | TCP-6382
CCC | any | 10.11.19.14 | any | application-default
CCC | any | 10.18.15.17 | any | application-default
CCC | any | 10.13.19.3 | any | application-default
DDD | any | 10.85.45.4 | any | application-default
Spreadsheet: 150396d1334504036-tally-number-locations-student-responses
Sheet: Sheet1

Date | Student ID Responses |  |  |  | Student IDs | Total Responses | Response Cells
2012-04-13 00:00:00 | 2 | 6 | 15 |  | 1 | 2 | 3 | 10
2012-04-12 00:00:00 | 1 | 9 | 22 |  | 2 | 4 | 2 | 8 | 12 | 15
2012-04-11 00:00:00 | 5 | 11 | 21 |  | 3 | 1 | 6
2012-04-10 00:00:00 | 4 | 15 | 24 |  | 4 | 3 | 5 | 6 | 14
2012-04-09 00:00:00 | 3 | 4 | 7 |  | 5 | 2 | 4 | 13
2012-04-06 00:00:00 | 10 | 17 | 19 |  | 6 | 1 | 2
2012-04-05 00:00:00 | 2 | 12 | 13 |  | 7 | 2 | 6 | 15
2012-04-04 00:00:00 | 8 | 9 | 23 |  | 8 | 2 | 9 | 15
2012-04-03 00:00:00 | 1 | 2 | 14 |  | 9 | 4 | 3 | 9 | 11 | 13
2012-04-02 00:00:00 | 9 | 12 | 20 |  | 10 | 2 | 7 | 14
2012-03-30 00:00:00 | 2 | 13 | 21 |  | 11 | 2 | 4 | 16
2012-03-29 00:00:00 | 5 | 9 | 24 |  | 12 | 2 | 8 | 11
2012-03-28 00:00:00 | 4 | 10 | 16 |  | 13 | 1 | 12
2012-03-27 00:00:00 | 2 | 7 | 8 |  | 14 | 1 | 10
2012-03-26 00:00:00 | 11 | 16 | 20 |  | 15 | 2 | 2 | 5
 |  |  |  |  | 16 | 2 | 14 | 16
 |  |  |  |  | 17 | 1 | 7
 |  |  |  |  | 18 | 0
 |  |  |  |  | 19 | 1 | 7
 |  |  |  |  | 20 | 2 | 11 | 16
 |  |  |  |  | 21 | 2 | 4 | 12
 |  |  |  |  | 22 | 1 | 3
 |  |  |  |  | 23 | 1 | 9
 |  |  |  |  | 24 | 2 | 5 | 13
Spreadsheet: 64954d1265748895-excel-2007-intervals-example
Sheet: Sheet1

 | 1 | 4 | 9 | 15
 | 4 | 12 | 13 | 17
 | 7 | 8 | 10 | 14
 | 1 | 3 | 9 | 13
 |  | 3 | A
 |  | 6 | B
 |  | 9 | C
 |  | 12 | D
 |  | 15 | E
 |  | 18 | F
 |  | 21 | G
 | A | B | C | E
 | B | D | D | E
 | C | C | D | D
 | A | A | C | E
Spreadsheet: 42131d1240680510-extracting-data-from-inventory-report-with-unknown-names-teethless-mama-result
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Qty | PxQ
 |  |  | Apples
 |  |  |  |  |  |  |  |  |  | Apples |  |  |  | 5 | 20
 |  |  |  |  |  |  |  |  |  | Apples |  |  |  | 8 | 32
 |  |  |  |  |  |  |  |  |  | Apples |  |  |  | 4 | 22
 |  |  |  |  |  |  |  |  |  | Apples |  |  |  | 3 | 15
 |  |  | Total Apples |  |  |  |  |  |  |  |  |  |  |  | 89
 |  |  | Oranges
 |  |  |  |  |  |  |  |  |  | Oranges |  |  |  | 4 | 101
 |  |  |  |  |  |  |  |  |  | Oranges |  |  |  | 5 | 120
 |  |  |  |  |  |  |  |  |  | Oranges |  |  |  | 6 | 131
 |  |  | Total Oranges |  |  |  |  |  |  |  |  |  |  |  | 352
 |  |  | Beets
 |  |  |  |  |  |  |  |  |  | Beets |  |  |  | 1 | 5
 |  |  |  |  |  |  |  |  |  | Beets |  |  |  | 2 | 19
 |  |  | Total Beets |  |  |  |  |  |  |  |  |  |  |  | 24
Spreadsheet: 716914d1612421811-dynamic-indirect-substitutes-all-default-to-errors-dynamic-dependent-issues-v3
Sheet: FINISHING SCHEDULE

 |  | Using Dynamic "Row" Ranges - works perfectly
 |  |  | =OFFSET(ROWRANGES!$D$4,,MATCH(C11,ROWRANGES!$D$3:$AR$3,)-1,COUNTA(INDEX(ROWRANGES!$D$4:$AR$10,,MATCH(C11,ROWRANGES!$D$3:$AR$3,))))
 |  | CATEGORY | PRODUCT | Brand | Type/Range | Type/Range
 |  | Carpet | Stair/Landing Carpet | Brand  C Exterior Wood | Brand B [NAME]
 |  | Using Dynamic "Column" Ranges not working.
 |  |  | D21 DropList is picking up rows 5 - 5 in Cols C, D or e , not C5:E5, C6:E6 or C7:H7.
 |  |  | =OFFSET(COLRANGES!$C$5,MATCH(C21,COLRANGES!$B$5:$B$146,)-1,,,COUNTA(INDEX(COLRANGES!$C$5:$I$146,MATCH(C21,COLRANGES!$B$5:$B$146,),)))
 |  | CATEGORY | PRODUCT | Brand | Type/Range | Type/Range
 |  | Interior Paint | Internal Woodwork
 |  | Exterior Paint | Exterior Woodwork
 |  | Carpet | TBC by Client
Spreadsheet: 34750d1232064334-changing-the-page-break-page-break
Sheet: carb intake

Date | Time | CARB INTAKE (225/DAY) | daily carb average | FOODS EATEN
OCT.17, 2008 | 17:30:00 | 51 |  | DISCHARGED FROM HOSPITAL THIS AFTERNOON
2008-10-18 00:00:00 | 08:30:00 | 37
 | 12:25:00 | 28
 | Dinner | 65 | 130
2008-10-19 00:00:00 | 9AM | 57
 | 12:12:00 | 50
 | Dinner | 60 | 167
2008-10-20 00:00:00 | 08:17:00 | 61
 | 11:45:00 | 63
 | 17:00:00 | 55 | 179
2008-10-21 00:00:00 | 08:45:00 | 38
 | 11:30:00 | 53
 | 16:00:00 | 56 | 147
2008-10-22 00:00:00 | 08:00:00 | 47
 | Lunch | 43
 | Dinner | 32 | 122
2008-10-23 00:00:00 | Breakfast | 31
 | 12:00:00 | 24 |  | snack - doctors office visit and then pick up scripts
 | Lunch - 2:30 pm | 45
 | 18:00:00 | 62 | 162
2008-10-24 00:00:00 | 08:15:00 | 23
 | 11:36:00 | 48
 | Dinner | 56 | 127
2008-10-25 00:00:00 | 08:21:00 | 54
 | Lunch | 57
 | Dinner | 45 | 156
2008-10-26 00:00:00 | 08:15:00 | 38
 | 11:50:00 | 60
 | dinner |  | 98
2008-10-27 00:00:00 | did not
 | record
 | foods
2008-10-30 00:00:00 | [NAME] | 23
 | lunch | 43
 | dinner | 22 | 88
11/1/2008 THRU 11/4/08 | DID NOT
 | RECORD
 | FOOD
 | INTAKE | average daily carb intake==> | 137.6
Spreadsheet: 734305d1622100092-extraction-of-multiple-numbers-from-a-cell-codon-extraction
Sheet: Sheet1

data | Codon 1 | [NAME]
p.Gln52_Pro60del |  |  |  |  |  |  |  |  |  |  | 52 | 60
p.Gly266delinsAlaAlaArg |  |  |  |  |  |  |  |  |  |  | 266
p.Asn239del |  |  |  |  |  |  |  |  |  |  | 239
p.Gly262_Ser269del |  |  |  |  |  |  |  |  |  |  | 262 | 269
p.His179delinsProTyr |  |  |  |  |  |  |  |  |  |  | 179
p.Pro87del |  |  |  |  |  |  |  |  |  |  | 87
p.Gln5_Pro12del |  |  |  |  |  |  |  |  |  |  | 5 | 12
p.Met1del |  |  |  |  |  |  |  |  |  |  | 1
p.Gln52_Trp53insTer |  |  |  |  |  |  |  |  |  |  | 52 | 53
p.Ser94_Gln100delinsTer |  |  |  |  |  |  |  |  |  |  | 94 | 100
p.Ala79_Ala88del |  |  |  |  |  |  |  |  |  |  | 79 | 88
p.Ile162delinsArgLeu |  |  |  |  |  |  |  |  |  |  | 162
p.Glu51_Gln52del
p.Ala84_Ser90del
p.Leu114delinsSerVal
p.Met243delinsIleValThrValProAlaTrp
p.Ser240delinsArgCysAsnIle
p.Arg282delinsProTrp
p.Asn247delinsXaaXaa
p.Val173_Arg174delinsGly
Spreadsheet: 679631d1590539102-lookup-based-on-2-criteria-lookup-example
Sheet: data

ID | Name | Project | Hours
12345 | [NAME], [NAME] | 85000.AZ.3000 | 2500
98765 | Doe, [NAME] | 90000.AB.3000 | 4500
24680 | [NAME], [NAME] | 85000.AZ.3000 | 1000
13579 | [NAME], [NAME] | 85000.AZ.3000 | 700
13579 | [NAME], [NAME] | 90000.AB.3000 | 2500
12390 | Nicole, Amber | 85000.AB.3000 | 25
24680 | [NAME], [NAME] | 90000.AB.3000 | 55
12345 | [NAME],[NAME] | 85000.AB.3000 | 300
98765 | Doe, [NAME] | 90000.AZ.3000 | 5000
Spreadsheet: 1a77b8e8-04d1-4391-b7d4-3d9cb09892e2
Sheet: Sheet1

Lp. | Nazwa | Adres | Kontak | Osoba do kontaktu | Ilość stażystów
KOSMETOLOGIA
1 | Idylla Beauty&Spa | Wyzwolenia 40  43-438 Brenna | + 48 33 855 69 96 wew. 600 [EMAIL] | Agnieszka Jurkiewicz | od 1 do 3
2 | HOTEL ZIMNIK LUKSUS NATURY ****                       HOTEL ZIMNIK *** | 34-324 LIPOWA, 990 | [NAME]          e-mail: [EMAIL] tel.: 33 860 15 91 | Magdalena Szwed Manager [NAME] e-mail: [EMAIL] | od 2 do 4
3 | [NAME] | Generała Stanisława Maczka 41, Bielsko-Biała | [NAME]. 33 810 54 87    e-mail: [EMAIL] | [NAME] | od 2 do 4
4 | MAGDALENA PYCLIK "PRETTY WOMAN" KOSMETYKA I KOSMETOLOGIA PROFESJONALNA | ul. Sznelowiec 12b 43-200 Pszczyna | tel. 604 19 29 56 | Magdalena Pyclik | od 1 do 2
5 | YASUMI-SLIM | BIELSKO BIAŁA Ul. ŻYWIECKA 132 | tel. (+48) 537 000 587 email: [EMAIL] | [NAME] | od 1 do 2
6 | Jawor - Hotel**** SPA | Turystyczna 204  43-384 Jaworze | tel. 33 819 86 00 | [NAME], Bartłomiej Gwóźdź SPA & WELLNESS: [NAME]. 033 819 86 30 [EMAIL] | od 2 do 4
7 | Hotel & SPA Kocierz | Beskidzka 206  34-120 Targanice | tel. 33 875 06 00 | SPA - KOCIERZ Manager [NAME] [NAME].: 0 33 875 06 31  E-mail: [EMAIL] | od 1 do 2
8 | [NAME] i Urody Babski Raj | [NAME], 43-303 Bielsko-Biała | tel. 33 444 50 30 e-mail: [EMAIL] | Agnieszka Bury 501 055 305 | 1
9 | Papuga Park Hotel | [NAME], 43-382 Bielsko-Biała | tel. 33 818 58 50  [EMAIL] | SPA & Wellness Marrakesz [NAME] [EMAIL] | 1
10 | Hotel Elbrus*** Spa&Wellness | ul. [NAME] | tel. 33 826 13 00 | [EMAIL] | 1
11 | Gabinet Kosmetyczny Butterfly Beauty Ewa Hankus | [NAME] ul.Bielska 5 | tel. 692 815 102 | [NAME] | 1
12 | Słup-Ostrawska Katarzyna Gabinet Specjalistycznej Pielęgnacji Stóp i Dłoni Butterfly Beauty Ewa Hankus | ul. Barlickiego 7  43-300 Bielsko-Biała 43-300 Bielsko-Biała | tel. 501 330 740 [EMAIL] | Słup-Ostrawska Katarzyna | 1
[NAME]
1 | Januszówka. Pracownia architektury krajobrazu | 43-300 Bielsko-Biała, Rynek 4 | tel./fax: 33 812 39 13 mobile: 606 410 491 [EMAIL] | Przemysław Janusz | od 1 do 3
2 | POLSPORT S.A. | 43-300 Bielsko-Biała ul. Wyzwolenia 59 | Tel: +48 33 816 12 89 | [NAME] [EMAIL] | od 1 do 2
3 | LINEART PROJEKTOWANIE W ZAKRESIE ARCHITEKTURY I DEKORATORSTWA WNĘTRZ | ul.Piekarska 163  43-300 Bielsko-Biała | tel./fax [PHONE] | [NAME] [NAME] e-mail: [EMAIL]  [NAME] tel./fax [PHONE] e-mail: [EMAIL] | 1
4 | BRANKA PROJEKT | ul.1 Maja 16A  43-300 Bielsko-Biała | tel./fax 033 811 55 48 | [NAME] | 1
5 | DesignOff | [NAME]44-100 Gliwice | 502823198 | [EMAIL] | od 1 do 2