tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 853124d1703065421-count-unique-from-multiple-crieteria-unique-count-values
Sheet: Sheet1

Plant | DIVISION | STATUS
81D6 | [NAME] | IN PROGRESS
81D8 | [NAME] | IN PROGRESS
81D8 | [NAME] | COMPLETED
81E0 | [NAME] | IN PROGRESS
81E0 | [NAME] | COMPLETED
81D9 | [NAME] | IN PROGRESS
81D9 | [NAME] | IN PROGRESS
81F9 | big t | IN PROGRESS
81F9 | big t | IN PROGRESS
81F0 | big t | IN PROGRESS
81F9 | big t | IN PROGRESS
81F9 | big t | IN PROGRESS
81F9 | big t | COMPLETED
 |  | CRITERIA 1 | [NAME]
 |  | CRITERIA 2 | in progress
 |  | OUTPUT required | unique count of column A, i.e - 4
Spreadsheet: 1946b719-e20e-4b96-b736-164b39ac3315
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | EC09 IP Cost Sharing Funds Request Form | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | EC09 IP In-Kind Contribution Declaration Form
 |  | Company Name Here
Labor Funding Request |  |  |  |  |  | Running Total
Function or Task | WBS Task | Assigned Personnel | [NAME] | Projected Labor Hours | Task Funding Request
Write GetView spec | WBS 3.1 | Sr. Software Eng. |  |  | 0
Modify brand x client to support with GetView | WBS 3.2 | Assoc. Software Eng. |  |  | 0
 | WBS 3.3 | Expand form as needed |  |  | 0
 | WBS 3.4 |  |  |  | 0
 | WBS 3.5 |  |  |  | 0
 | WBS 3.6 |  |  |  | 0
 | WBS 3.7 |  |  |  | 0
 | WBS 3.8 |  |  |  | 0
 | WBS 3.9 |  |  |  | 0
 | WBS 3.10 |  |  |  | 0
 | WBS 3.10.1
 | WBS 3.10.2
 | WBS 3.10.3
 | WBS 3.10.4
 | WBS 3.10.5
 | WBS 3.10.6
 | WBS 3.10.7
 | WBS 3.10.8
 | WBS 3.10.9
 | WBS 3.10.10
 | WBS 3.10.11
 | WBS 3.10.12
 | WBS 3.10.13
 | WBS 3.10.14
 | WBS 3.10.15
 | WBS 3.11 |  |  |  | 0
 | WBS 3.12 |  |  |  | 0
Total Labor |  |  |  |  | 0 | 0
Travel Funding Request
Function or Event | Duration | Aspects of Travel | Est. Trip Cost | # of Travelers | Trip Funding Request
EC09 Kickoff | 3 days | flight, lodging, per diem |  |  | 0
EC09 Demo | 18 days | flight, lodging, per diem |  |  | 0
Total Travel |  |  |  |  | 0 | 0
Other Expense Requests
Expense Type | Purpose or Use | Justification | Est. Cost | Amount (Units) | Expense Funding Request
Brand X Server CPU | Host WBS software | Required by submitter in order to have adequate infrastructure to show results | 5000 | 1 | 5000
[NAME] (Seat licenses) | Data storage and retrieval | Required by submitter in order to have adequate infrastructure to show results | 3000 | 20 | 60000
Total Other Expenses |  |  |  |  | 65000 | 65000
Grand Total Matching Funds Request |  |  |  |  | 65000
Spreadsheet: 845708d1697103447-group-and-increment-avoiding-duplications-seq1_a
Sheet: Sheet1

VARIATION 1
 | Cust1 | Cust2 | Cust3 | Cust4 | Cust5 | SEQUENCE
Grp1 |  |  |  |  |  |  | 1
[NAME] |  |  |  |  |  |  | 1
Grp3 |  |  |  |  |  |  | 2
Grp4 |  |  |  |  |  |  | 3
Grp5 |  |  |  |  |  |  | 1
Grp6 |  |  |  |  |  |  | 2
Grp7 |  |  |  |  |  |  | 4
Grp8 |  |  |  |  |  |  | 5
Grp9 |  |  |  |  |  |  | 3
[NAME] |  |  |  |  |  |  | 6
 | Cust1 | Cust2 | Cust3 | Cust4 | Cust5 | SEQUENCE
Grp1 | X |  | X |  |  |  | 1
[NAME] |  | X |  |  |  |  | 1
Grp3 | X |  |  | X |  |  | 2
Grp4 |  |  |  | X |  |  | 3
Grp5 |  |  |  |  | X |  | 1
Grp6 |  |  | X |  | X |  | 2
Grp7 | X |  |  | X | X |  | 4
Grp8 | X |  |  |  |  |  | 5
Grp9 |  | X | X |  |  |  | 3
[NAME] | X |  | X | X |  |  | 6
Spreadsheet: 217157d1361995077-fnding-lowest-number-within-a-range-simple-sample
Sheet: Monthly 3

 | January | February | March | April | May | June | July | August | September | October | November | December | TOTAL
Year 1 | 0.04674476483714011 | 0.03655935706973992 | 0.01718772940632333 | 0.1134096215518506 | 0.1531742508929883 | 0.1654957672497334 | 0.06477254208479784 | 0.1028001328735407 | 0.08074413021606945 | 0.1134096215518505 | 0.05351586259940627 | 0.2436058367011014 | 2.068194566814578 | Total (%)
P/L | 294.2219236539768 | 238.8447160410151 | 112.2885815965556 | 753.6472207242887 | 1133.336656411167 | 1412.066005529075 | 644.1243981042735 | 1088.502239747209 | 942.8517714976861 | 1431.216213272386 | 751.9567223380836 | 3606.110951971748 | 12409.16740088747 | Profit (£)
D/D |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Year 2 | 0.1253062580342249 | 0.1193421348666438 | 0.05912924761174857 | 0.170471864656383 | 0.05912924761174836 | 0.2071206160800811 | 0.2555699466530841 | 0.0969552921693112 | 0.0535158625994064 | 0.1134096215518507 | 0.007495122579546844 | -0.01265477987204387 | 2.208344708810498 | Total (%)
P/L | 2306.783880530846 | 2472.285851717847 | 1371.103015125151 | 4186.676509804474 | 1699.730336826215 | 6305.941874600307 | 9392.627163786892 | 4473.935642959616 | 2708.879401727769 | 6047.809753998125 | 445.0224596889166 | -757.0084674096215 | 40653.78742335653 | Profit (£)
D/D |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Year 3 | 0.0379466626595137 | 0.1361322668896437 | 0.1193421348666441 | 0.1028001328735406 | 0.1767084192785597 | 0.1531742508929885 | 0.1361322668896437 | -0.01265477987204425 | 0.03794666265951355 | 0.1704718646563831 | 0.02805624753014992 | 0.1193421348666442 | 2.097712132644623 | Total (%)
P/L | 2241.242022389684 | 8345.47928658119 | 8312.141042508214 | 8014.485164727012 | 15192.73648199647 | 15496.49173519193 | 15881.94314269433 | -1677.359102273287 | 4966.084090864446 | 23156.25007833581 | 4460.73149803892 | 19506.85148360318 | 123897.0769246579 | Profit (£)
D/D |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Year 1 |  |  |  |  |  |  |  |  | Profit (£) | Gain (%)
 |  |  |  |  |  |  |  | Account Balance | 18409.16740088747 | 2.068194566814578
 |  |  |  |  |  |  |  | Peak Drawdown
 |  |  |  |  |  |  |  | Losing Streak
 |  |  |  |  |  |  |  | Winning Streak
Spreadsheet: 836537d1689455185-how-easely-prevent-problems-with-match-on-a-array-with-one-value-test-match
Sheet: Sheet1

3 |  | <<--
3 |  | <<--
3 |  | <<--
Why returns Excel in a MATCH on an array with one value always #N/A?
It doesn't care if it is an exact match or not.
3 |  | <<--
3 |  | <<--
3 |  | <<--
Match on a range of 1 cell does Excel well.
How to prevent problems with match on arrays of 1 value? (if you don't know before the size of the array in dynamic formules)
Solution (not elegant at all):
3 |  | <<--
Spreadsheet: 102262d1300223394-random-item-number-equals-correct-price-new-job-template
Sheet: Order Form

Order Form
 |  |  |  |  |  |  | Date: | 2011-03-05 00:00:00
Contractor: | LaMorinda Tile and Stone |  |  | Job Name: | 0
Address: | 2261 Commerce Ave., Suite B |  |  | Address: | 0
City: | Concord, CA 94520 |  |  | City: | 0
Phone: | [PHONE] |  |  | Phone: | 0
Fax : | [PHONE] |  |  | Fax: | 0
[NAME]: | [EMAIL] |  |  | [NAME]: | 0
Order Form
Kitchen Cabinets Modular
 |  | Door Style:
Item | Description of Job |  |  |  |  | Quantity | Color
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
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
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
0 | 0 |  |  |  |  | 0
0 | 0 |  |  |  |  | 0
0 | 0 |  |  |  |  | 0
0 | 0 |  |  |  |  | 0
0 | 0 |  |  |  |  | 0
0 | 0 |  |  |  |  | 0
Spreadsheet: 694244d1599474789-consolodating-date-power-query-product-report-analysis
Sheet: Drinks

 | NEW MENU LAUNCHED 8 AUG | COS | Gross Price | Net Price | COS % | Net Profit |  | Platform | Supply Chain | Royalties | Marketing | Profit 1 |  | Variable | Staff | Facility | Profit 2 | Profit % |  | Discount 13% | Net Price | Profit AD | Profit % |  | Key:
 | Coffee |  |  | avg |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <10
CT1 | Espresso | 8.59375 | 60 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <5
CT2 | Espresso Large | 17.1875 | 75
CT3 | Americano Large | 30.6455 | 85
CT4 | Americano Small | 17.84612 | 70
CT5 | Cappuccino Large | 39.3833 | 100
CT6 | [NAME] | 24.2473 | 85
CT7 | [NAME] | 26.73833 | 90
CT8 | [NAME] Large | 41.89567 | 110
CT9 | [NAME] | 26.9917 | 90
CT10 | Moccaccino Large | 43.0964 | 110
CT11 | Lucky 13 Latte | 38.7233 | 100
CT19 | Hot Chocolate | 26.7 | 70
CT12 | Ice Americano | 24.66475 | 90
CT13 | Ice Latte | 26.3091 | 110
CT14 | Ice Caramel Latte | 31.55983 | 120
CT15 | Ice Cream Frappuccino | 32.64079 | 120
CT20 | Iced Chocolate | 19.44467 | 80
CT16 | Tea | 21.0765 | 70
CT17 | [NAME] | 7.68596 | 60
CT18 | Thai Iced Tea | 17.35366 | 60
 | [NAME]
DKS4 | Coke | 12.47166 | 30
DKS6 | Coke Zero | 12.29166 | 30
DKS2 | Evian Water | 39.25 | 80
[NAME] | Fanta Orange | 12.47166 | 30
JS4 | Orange Juice (Bottle) | 17 | 60
DKS10 | [NAME] | 13.75 | 30
DKS1 | Lucky Water | 4.76333 | 20
DKS17 | Red Bull | 12.5 | 50
DKS3 | [NAME] | 7.38833 | 20
DKS9 | Sprite | 12.47166 | 30
DKS11 | Tonic Water | 13.93 | 30
 | Milkshake | COS
MS2 | Banana & Vanilla Milkshake | 17.91872 | 120
MS1 | Passion Fruit Milkshake | 22.07747 | 120
 | Cocktails
CW2 | Classic Mojito | 42.26586 | 200
CW1 | Passion Mojito | 43.31211 | 200
 | Shots
CW14 | [NAME] | 39 | 160
CW18 | Gordons Gin | 29.35 | 140
CW16 | [NAME] | 27.85 | 140
CW19 | [NAME] | 55.7 | 160
CW12 | Sangsom | 11.52 | 90
 | Fruit Soda
SFS5 | [NAME] | 16.83258 | 99
SFS3 | Lemonade Soda | 10.95058 | 99
SFS2 | Passion Fruit Soda | 13.06383 | 99
SFS4 | [NAME] | 17.02258 | 99
 | Fruit Shake
JS9 | Orange Shake | 11.01205 | 99
 | Detox Juice
JS2 | [NAME] | 32.265 | 150
 | Beer
BE13 | Chalawan | 89 | 190
BE1 | [NAME] | 34.23 | 90
BE4 | Heineken | 38.3178 | 110
BE5 | San Miguel Light | 39.2524 | 110
BE3 | Singha Beer | 34.5795 | 90
BE2 | Tiger Beer | 29.20561 | 90
BE12 | Budweiser | 41.14 | 160
Spreadsheet: 349295d1412269851-help-with-conditional-formatting-format-sample
Sheet: Sheet1

CUSTOMER NAME | ORDER # | PART # | QTY SHIPPED | ORIGINAL ORDER QTY | BACK ORDERS | AVAILABLE TO SHIP
KYOSHO CORPORATION | 29416 | 13014SR | 0 | 60 | 60 | 60
KYOSHO CORPORATION | 29416 | 13015CR | 0 | 120 | 120 | 120
KYOSHO CORPORATION | 29416 | 13016SR | 0 | 60 | 60 | 60
KYOSHO CORPORATION | 29416 | 13120CR | 0 | 180 | 180 | 0
KYOSHO CORPORATION | 29416 | 13320CR | 0 | 105 | 105 | 105
KYOSHO CORPORATION | 29416 | 23001 | 0 | 180 | 180 | 180
KYOSHO CORPORATION | 29416 | 23111W | 0 | 90 | 90 | 90
KYOSHO CORPORATION | 29555 | 14016SR | 0 | 60 | 60 | 60
KYOSHO CORPORATION | 29555 | 14016VR | 0 | 300 | 300 | 70
KYOSHO CORPORATION | 29617 | 13120CR | 0 | 90 | 90 | 0
KYOSHO CORPORATION | 29617 | 13220CR | 0 | 105 | 105 | 0
KYOSHO CORPORATION | 29617 | 13320CR | 0 | 105 | 105 | 66
KYOSHO CORPORATION | 29617 | 14002SR | 0 | 60 | 60 | 24
KYOSHO CORPORATION | 29617 | 14002VR | 0 | 60 | 60 | 20
KYOSHO CORPORATION | 29617 | 14007SR | 0 | 60 | 60 | 36
KYOSHO CORPORATION | 29617 | 14007SX | 0 | 60 | 60 | 35
KYOSHO CORPORATION | 29617 | 14007VR | 0 | 60 | 60 | 29
KYOSHO CORPORATION | 29617 | 23311W | 0 | 105 | 105 | 97
KYOSHO CORPORATION | 29617 | 24003W | 0 | 36 | 36 | 36
KYOSHO CORPORATION | 29642 | 13107S | 0 | 90 | 90 | 0
KYOSHO CORPORATION | 29642 | 13201S | 0 | 60 | 60 | 0
KYOSHO CORPORATION | 29642 | 14001SR | 0 | 60 | 60 | 29
KYOSHO CORPORATION | 29642 | 14001SX | 0 | 60 | 60 | 1
KYOSHO CORPORATION | 29642 | 14001VX | 0 | 60 | 60 | 39
KYOSHO CORPORATION | 29642 | 14002SX | 0 | 60 | 60 | 27
KYOSHO CORPORATION | 29642 | 14007SR | 0 | 60 | 60 | 0
KYOSHO CORPORATION | 29642 | 14007SX | 0 | 120 | 120 | 0
KYOSHO CORPORATION | 29642 | 14007VR | 0 | 60 | 60 | 0
KYOSHO CORPORATION | 29642 | 14007VX | 0 | 120 | 120 | 3
KYOSHO CORPORATION | 29642 | 14015VR | 0 | 60 | 60 | 38
KYOSHO CORPORATION | 29642 | 23111W | 0 | 90 | 90 | 53
KYOSHO CORPORATION | 29642 | 23212W | 0 | 105 | 105 | 105
KYOSHO CORPORATION | 29642 | 33012 | 0 | 90 | 90 | 90
KYOSHO CORPORATION | 29642 | 34001MFG | 0 | 36 | 36 | 36
KYOSHO CORPORATION | 29642 | 34001S | 0 | 36 | 36 | 36
KYOSHO CORPORATION | 29642 | 44002 | 0 | 30 | 30 | 30
Spreadsheet: 1faea3e4-f6ec-4e91-8a42-45f4a402f47a
Sheet: Sheet1

[NAME] July 2010 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30 | Unnamed: 31 | Unnamed: 32 | Unnamed: 33 | Unnamed: 34
User Name | Names | Days Left | SSB? | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
 |  |  |  | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S
Jed | [NAME] | 148 | Y | X | X | X | X | X | X | X | X | X | X | X
 | Arthur & Liz | 148 | Y | X | X | X | X | X | X | X | X | X | X | X
Mandynjeff | Mandy & Jeff | 149 | Y |  | X | X | X | X | X | X | X | X | X | X
Dandes | David & Erin | 149 | Y |  | X | X | X | X | X | X | X | X | X
notherz | Pat & Deb | 155 |  |  |  |  |  |  |  |  | X | X | X | X | X | X
[NAME] | Joel & Renee | 155 | Y |  |  |  |  |  |  |  | X | X | X | X | X | X | X | X | X | X | X
[NAME] | [NAME] | 155 | Y |  |  |  |  |  |  |  | X | X | X | X | X | X | X | X | X | X | X
U.N.C.L.E.Agent | Cindy & Randy | 158 | Y |  |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X | X
Bilkat | Bill & Kathy | 161 | Y |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X | X | X
AngNAaron | ??? | 163 | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X | X
irishabroad | John & Wilma | 164 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
soontobemrsd2010 | ??? | 166 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X
Scotsaway | Russell & Fiona | 171 | Y |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X | X | X | X | X | X | X | X
Spreadsheet: 215689d1361457285-merging-seperate-spreadsheets-bill
Sheet: Bill

Head 1 | Head 2 | Head 3 | Head 4 | Head 5 | Head 6 | Head 7 | Head 8 | Head 9 | Head 10
1 | Blah 1 | Widget 1 | Value 1 | Head 5 1 | Head 6 1 | Head 7 1 | Head 8 1 | Head 9 1 | Head 10 1
2 | Blah 2 | Widget 2 | Value 2 | Head 5 2 | Head 6 2 | Head 7 2 | Head 8 2 | Head 9 2 | Head 10 2
3 | Blah 3 | Widget 3 | Value 3 | Head 5 3 | Head 6 3 | Head 7 3 | Head 8 3 | Head 9 3 | Head 10 3
4 | [NAME] | Widget 4 | Value 4 | Head 5 4 | Head 6 4 | Head 7 4 | Head 8 4 | Head 9 4 | Head 10 4
Spreadsheet: 867569d1714404666-even-team-distribution-for-draft-team-example
Sheet: Sheet1

Team | Under Class | Upper Class | Total | [NAME] Under Class | Draft Upper Class | Total Draft | # Needed to [NAME] Under Class | # Needed to Draft Upper Class | New Total Under | New Total Upper
A | 3 | 6 | 9 | 17 | 13 | 30
B | 3 | 11 | 14
C | 4 | 10 | 14
Spreadsheet: 838469d1691039096-textsplit-function-is-it-possible-to-spill-an-empty-cell-with-zero-txtsplit-aligw
Sheet: Sheet1

 | # Name |  | E1 | E2/ LP | Speed |  | E1 | E2 | LP | Speed
 | 1 Smoke Wagon |  | 86 | 85/ 73 | 67 |  |  |  | 73 |  |  |  |  |  |  |  |  | 85 | 73 | 67
 | 2 Global Hysteria |  | No Starts Available
 | 3 I Strong |  | 86 | [NAME] 75 * | 71* |  |  |  | 75 |  |  |  |  |  |  |  | 86 | 86 | 75 | 71
 | 4 Maluma |  | No Starts Available
 | 5 Warrior's Cause |  | 93 | 91/ 65 | 66 |  |  |  | 65 |  |  |  |  |  |  |  | 93 | 91 | 65 | 66
 | 6 Exclusive Entry |  | No Starts Available
 | 7 Bundaburg |  | No Starts Available
 | 8 Imposter Syndrome |  | 85 | 87/ 75 | 72 |  |  |  | 75 |  |  |  |  |  |  |  | 85 | 87 | 75 | 72
 | # Name |  | E1 | E2/ LP | Speed |  | E1 | E2 | LP | Speed
 | 3 Protectthewitness |  | 95 | 85/ 57 * | 66* |  |  |  | 57
 | 2 R Girl Faith |  | 79 | 73/ 61 * | 63* |  |  |  | 61
 | 5 Vaccina |  | 88 | 81/ 55 * | 63* |  |  |  | 55
 | 1 Phancy Philly |  | 79 | 67/ 51 * | 54* |  |  |  | 51
 | 4 Sailor's Salute |  | 82 | 71/ 50 * | 53* |  |  |  | 50
 | 6 Calvary Kat
Spreadsheet: 83e59cfc-0de3-43b1-9224-b6a2659197bb
Sheet: Sheet1

Table S2. Transcription status of FL-L1s within a 6-Mb genomic region of the 10q25 neocentromere | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Background | Cell line | Human chromosome | FL-L1a | FL-L1b | FL-L1c | FL-L1d | FL-L1e | FL-L1f
Human/CHO monochromosomal hybrid | CHO#8 | Unrelated normal chromosome 10 | undetected | undetected | undetected | undetected | undetected | undetected
 | GM10926 | Unrelated normal chromosome 10 | undetected | transcribed | undetected | undetected | undetected | undetected
 | CHOK1-N10 | Progenitor normal chromosome 10 | undetected | transcribed | undetected | undetected | undetected | undetected
 | CHOK1-M10 | [NAME]) chromosome | undetected | transcribed | undetected | undetected | undetected | undetected
Human/mouse monochromosomal hybrid | GM11688 | Unrelated normal chromosome 10 | undetected | transcribed | undetected | undetected | undetected | undetected
 | ES-M10 | [NAME]) chromosome | undetected | transcribed | undetected | undetected | undetected | undetected
Spreadsheet: 680487d1591043668-assessment-report-result-formulas-20200-06-01-oeldere-mariyav-1041000-assessment-report-result-formulas-measures-assessment
Sheet: DefaultPrimaryResponses

PrimaryResponse | SortIndex | ResponseValue | Intensity | ResponseScore | Colour
Fully  Compliant | 1 | 1 | 250 |  | Green
Almost Fully Compliant, small deviation found | 2 | 2 | 30 |  | Yellow
Partially Compliant, small part implemented | 3 | 2 | 20 |  | Orange
Not Implemented | 4 | 2 | 10 |  | Red
Not Applicable | 5 | 3 | 190 |  | Blue
Not Checked | 6 | 3 | 0 |  | Purple
Spreadsheet: 150989d1334753019-lookup-nearest-billing-cycle-and-count-days-prorated-billing-cycle
Sheet: Decription

No | Purchase Date(dd/mm/yyyy) | Billing Cycle(dd/mm/yyyy) | Total Days |  | Billing Cycle Fixed for every month:
1 |  |  |  |  | 7th
2 |  |  |  |  | 10th
3 |  |  |  |  | 13th
4 |  |  |  |  | 16th
5 |  |  |  |  | 19th
 |  |  |  |  | 22nd
 |  |  |  |  | 25th
 |  |  |  |  | Example on no of days in the month of BC range
 |  |  |  |  | 1.       On 1st March, the nearest BC is 7th Mar, the proration calculation is based on 7th Feb to 6th Mar, therefore is no. of days is 29.
 |  |  |  |  | 2.       On 24th [NAME], the nearest BC is 25th Mar, the proration calculation is based on 25th Feb to 24th Mar, therefore the no. of days is 29
 |  |  |  |  | 3.       On 26th Mar, the nearest BC is 7th Apr, the proration calculation is based on 7th Mar to 6th April, therefore the no. of days is 31.
Spreadsheet: 819438d1677512067-combine-columns-with-matching-headers-holiday-and-pto
Sheet: Holidays & PTO

Holidays to Exclude from Work Days
Date | Description |  | Employee 1 | Employee 2 | Employee 3 | Employee 4 | Employee 5 | Employee 6 | Employee 7
1900-01-01 00:00:00 | Do not delete this row
 | New Year's Day
 | New Year's Day |  | 2023-03-28 00:00:00 | 2023-04-04 00:00:00 | 2023-05-06 00:00:00 | 2023-05-11 00:00:00 | 2023-05-16 00:00:00 | 2023-05-19 00:00:00 | 2023-05-24 00:00:00
 | Memorial Day |  | 2023-03-29 00:00:00 | 2023-04-05 00:00:00 | 2023-05-07 00:00:00 | 2023-05-12 00:00:00 | 2023-05-17 00:00:00 | 2023-05-20 00:00:00 | 2023-05-25 00:00:00
 | Memorial Day |  | 2023-05-02 00:00:00 | 2023-04-06 00:00:00 | 2023-05-08 00:00:00 | 2023-06-05 00:00:00 | 2023-05-31 00:00:00 | 2023-05-21 00:00:00 | Employee 7
 | Independence Day |  | 2023-05-03 00:00:00 | 2023-04-07 00:00:00 | 2023-05-09 00:00:00 | 2023-06-06 00:00:00 | 2023-06-01 00:00:00 | 2023-05-22 00:00:00
 | Independence Day |  | 2023-05-04 00:00:00 | 2023-04-08 00:00:00 | 2023-06-08 00:00:00 | 2023-06-07 00:00:00 | 2023-06-02 00:00:00 | 2023-05-26 00:00:00
 | Labor Day |  | 2023-05-05 00:00:00 | 2023-04-09 00:00:00 | 2023-06-09 00:00:00 | Employee 4 | Employee 5 | 2023-05-27 00:00:00
 | Labor Day |  | Employee 1 | 2023-04-10 00:00:00 | 2023-06-10 00:00:00 | Employee 4 | Employee 5 | 2023-05-28 00:00:00
 | Thanksgiving |  | Employee 1 | 2023-04-11 00:00:00 | 2023-06-11 00:00:00 |  |  | 2023-05-29 00:00:00
 | Day after Thanksgiving |  |  | 2023-04-12 00:00:00 | 2023-06-12 00:00:00 |  |  | 2023-05-30 00:00:00
 | Thanksgiving |  |  | 2023-04-13 00:00:00 | Employee 3 |  |  | Employee 6
 | Day after Thanksgiving |  |  | Employee 2 | Employee 3 |  |  | Employee 6
 | Christmas
 | Christmas
[NAME] new rows above this one
PTO to Exclude from Work Days
Start Date | End Date | Resource
2023-03-27 00:00:00 | 2023-03-29 00:00:00 | Employee 1
2023-04-03 00:00:00 |  | Employee 2 | 2023-03-28 00:00:00 | 2023-04-04 00:00:00 | 2023-05-03 00:00:00 | 2023-05-06 00:00:00 | 2023-05-11 00:00:00 | 2023-05-16 00:00:00 | 2023-05-19 00:00:00 | 2023-05-24 00:00:00 | 2023-05-27 00:00:00 | 2023-06-01 00:00:00 | 2023-06-06 00:00:00 | 2023-06-09 00:00:00
2023-05-02 00:00:00 | 2023-05-05 00:00:00 | Employee 1 | 2023-03-29 00:00:00 | 2023-04-05 00:00:00 | 2023-05-04 00:00:00 | 2023-05-07 00:00:00 | 2023-05-12 00:00:00 | 2023-05-17 00:00:00 | 2023-05-20 00:00:00 | 2023-05-25 00:00:00 | 2023-05-28 00:00:00 | 2023-06-02 00:00:00 | 2023-06-07 00:00:00 | 2023-06-10 00:00:00
 |  | Employee 3 |  | 2023-04-06 00:00:00 | 2023-05-05 00:00:00 | 2023-05-08 00:00:00 |  |  | 2023-05-21 00:00:00 |  | 2023-05-29 00:00:00 |  |  | 2023-06-11 00:00:00
 |  | Employee 4 |  | 2023-04-07 00:00:00 |  | 2023-05-09 00:00:00 |  |  | 2023-05-22 00:00:00 |  | 2023-05-30 00:00:00 |  |  | 2023-06-12 00:00:00
 |  | Employee 5 |  | 2023-04-08 00:00:00
 |  | Employee 6 |  | 2023-04-09 00:00:00
 |  | Employee 7 |  | 2023-04-10 00:00:00
 |  | Employee 6 |  | 2023-04-11 00:00:00
 |  | Employee 5 |  | 2023-04-12 00:00:00
 |  | Employee 4 |  | 2023-04-13 00:00:00
 |  | Employee 3
Spreadsheet: 855019d1704741196-indirect-cadence-ending-in-xlookup-excelforum-question-doc
Sheet: Sheet 2

Soort woning |  | M2 |  |  | [NAME] |  |  |  | [NAME]
Selecteer soort Woning |  | Eengezinswoning | Meergezinswoning |  | Eengezinswoning25M2 | Eengezinswoning 25M2 40M2 | Eengezinswoning groter 40M2 |  | Meergezinswoning kleiner 25M2 | Meergezinswoning 25M2 40M2 | Meergezingswoning groter 40M2
Eengezinswoning |  | Eengezinswoning25M2 | Meergezinswoning25M2 |  | [NAME] | [NAME] | [NAME] |  | [NAME] | [NAME] | [NAME]
Meergezinswoning |  | Eengezinswoning25M40M2 | Meergezinswoning25M240M2 |  | A+ | A+ | A+ |  | A+ | A+ | A+
 |  | Eengezinswoning40M2 | Meergezingswoning40M2 |  | A | A | A |  | A | A | A
 |  |  |  |  | B | B | B |  | B | B | B
 |  |  |  |  | C | C | C |  | C | C | C
 |  |  |  |  | D | D | D |  | D | D | D
 |  |  |  |  | E | E | E |  | E | E | E
 |  |  |  |  | F | F | F |  | F | F | F
 |  |  |  |  | G | G | G |  | G | G | G
 |  |  |  |  | [NAME] Punten E<25M | [NAME] punten E25-40M | [NAME] punten E>40M |  | Energielabel m<25M | [NAME]M | Energielabel m>40M
 |  |  |  |  | 52 | 48 | 44 |  | 48 | 44 | 40
 |  |  |  |  | 48 | 44 | 40 |  | 44 | 40 | 36
 |  |  |  |  | 44 | 40 | 36 |  | 40 | 36 | 32
 |  |  |  |  | 40 | 36 | 32 |  | 36 | 32 | 28
 |  |  |  |  | 36 | 32 | 22 |  | 32 | 28 | 15
 |  |  |  |  | 32 | 22 | 14 |  | 28 | 15 | 11
 |  |  |  |  | 22 | 14 | 8 |  | 15 | 11 | 5
 |  |  |  |  | 4 | 4 | 4 |  | 1 | 1 | 1
 |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0