tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 219820d1362977685-creating-list-from-text-in-another-sheet-baby-inventory-room-2-2012
Sheet: Rack 20

20
[NAME] | [NAME] | F Pastel | 1
[NAME] | M Albino | F Albino | 2
[NAME] | M Bee | [NAME] | 3
M Sentinel Het Albino | M Leopard | M Spotnose | 4
M Sentinel Het Albino | M Sentinel Het Albino | F Mojave | 5
F Mojave | F Sentinel | [NAME] | 6
F Butter YB | F Hypo Pin | F Pin Het Albino | 7
F Pin Het Albino | F Spider | [NAME] | 8
M Sentinel Het Albino | F Sentinel Het Albino | F Spider | 9
F Pin | F Butter YB | F Sentinel Het Albino | 10
F Pastel | F Sentinel Het Albino | F Enchi | 11
F Albino | F Mojave | F Mojave | 12
F Pin | F Woma | F Woma | 13
F Enchi YB | F Calico | [NAME] | 14
M Banana | F Pin | F Enchi | 15
F Spider | F Desert Spider | M Mahogany | 16
F Pastel | F Pastel | F Pastel | 17
Spreadsheet: 857048d1706131149-ratio-of-no-of-employees-in-each-dept-to-total-no-of-employees-book1
Sheet: JAN 2024

JANUARY |  |  |  |  |  |  |  | 27
DATE | SHIFT | DEPT | TITLE | EMPLOYEE'S NAME |  | dept | ratio | total count
2024-01-01 00:00:00 | Day | 3rd Fl | [NAME] | Ana |  | 7th Fl
2024-01-01 00:00:00 | Day | 1st Fl | [NAME] | [NAME] |  | 4th Fl
1/1/2024 | Night | 1st Fl | [NAME] | [NAME] |  | 6th Fl
2024-01-02 00:00:00 | Day | 4th Fl | [NAME] | Cory |  | 3rd Fl
2024-01-02 00:00:00 | Day | 3rd Fl | [NAME] | Ana |  | 5th Fl
2024-01-02 00:00:00 | Day | 1st Fl | [NAME] | [NAME] |  | 1st Fl
2024-01-02 00:00:00 | Night | 5th Fl | [NAME] | [NAME] |  | 2nd Fl
2024-01-03 00:00:00 | Day | 4th Fl | [NAME] | Lewis
2024-01-03 00:00:00 | Day | 3rd Fl | [NAME] | Ana
2024-01-04 00:00:00 | Night | 4th Fl | [NAME] | [NAME]
2024-01-05 00:00:00 | Night | 4th Fl | [NAME] | [NAME]
2024-01-06 00:00:00 | Day | 4th Fl | [NAME] | [NAME]
2024-01-06 00:00:00 | Day | 3rd Fl | [NAME] | Ana |  | Ratio of employees in each dept to total # of employees for the month
2024-01-06 00:00:00 | Day | 6th Fl | [NAME] | [NAME]
2024-01-08 00:00:00 | Day | 1st Fl | [NAME] | Tiffany
2024-01-08 00:00:00 | Night | 5th Fl | [NAME] | Maria
2024-01-10 00:00:00 | Day | 4th Fl | [NAME] | Lewis
2024-01-12 00:00:00 | Day | 5th Fl | [NAME] | [NAME]
2024-01-12 00:00:00 | Night | 5th Fl | [NAME] | [NAME]
2024-01-12 00:00:00 | Night | 6th Fl | [NAME] | Doug
2024-01-12 00:00:00 | Night | 4th Fl | [NAME] | [NAME]
2024-01-14 00:00:00 | Day | 2nd Fl | [NAME] | Rachel
2024-01-15 00:00:00 | Day | 5th Fl | [NAME] | [NAME]
2024-01-15 00:00:00 | Day | 1st Fl | [NAME] | [NAME]
2024-01-15 00:00:00 | Night | 4th Fl | [NAME] | [NAME]
2024-01-16 00:00:00 | Day | 5th Fl | [NAME] | [NAME]
2024-01-16 00:00:00 | Night | 5th Fl | [NAME] | [NAME]
Spreadsheet: 51283d1250809343-data-validation-list-sort-problem-tempodjustments3
Sheet: Value Trends Tempo

Value Trends
 | 7815 corbin | Winnetka, CA 91306
Comps Past 12 Months | REO Comps past year | % REO | Average SP | Average sales per month | [NAME]
99 | 48 | 0.4848484848484849 | 361809.898989899 | 8.25 | 53.05050505050505
Comps Past 6 Months | REO Comps past 6 months | % REO |  | Average sales per month
49 | 25 | 0.5102040816326531 | 350378.1632653061 | 8.166666666666666 | 50.6530612244898
Comps Past 3 Months | REO Comps past 3 months | %REO |  | Average sales per month
24 | 12 | 0.5 | 357397.0833333333 | 8 | 44.70833333333334
Current Active | REO Active | %REO |  | List Price Low | 195000
32 | 4 | 0.125
 |  |  |  | List Price High | 799995
Months supply of properties based on 6 month average
3.918367346938776 |  |  |  | Sale Price Low | 198000
Months supply based on standard national average of 4.5 |  |  |  | Sale Price High | 645900
7.111111111111111
Price trends | based on Ave Sale Price |  | per month
90 Day to 1 Year |  | 0.9878034966182923 | 0.001016375281808979
90 Day to Six Months |  | 1.020032412986629 | -0.003338735497771528
Spreadsheet: 101397d1299536208-excel-function-for-calculating-hours-in-a-week-for-several-employees-productionreport
Sheet: Template

Week of | MMM DD-DD 2011
Client | Project | Account Manager | Staff | Time | Status
Monday | Monday | Monday | Monday | Monday
Tuesday | Tuesday | Tuesday | Tuesday | Tuesday
Wednesday | Wednesday | Wednesday | Wednesday | Wednesday
Thursday | Thursday | Thursday | Thursday | Thursday
Friday | Friday | Friday | Friday | Friday
Totals | Totals | Totals | Totals | Totals | Totals
 | Completed | 0 | 0
 | WOS | 0 | 0
 | WOC | 0 | 0
 | Feedback | 0 | 0
 | Push | 0 | 0
 | Cancelled | 0 | 0
 | Follow-up | 0 | 0
 | FIRM | 0 | 0
 | Empty | -4 | 1
 | Total | -4 | 1
Time Totals | Mon | [NAME] | Wed | Thur | Fri | Week
Erin | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
[NAME] | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
[NAME] | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Jon | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Justin | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Victor | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
[NAME] | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
[NAME] | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Variables - Don't touch anything in here!
R:Totals | 148
R:Monday | 3
R:Tuesday | 34
R:Wed | 65
R:Thur | 93
R:Fri | 123
Spreadsheet: 217606d1362128086-look-up-with-a-difference-test
Sheet: Sheet2

 | Results | Scores | MOST | LEAST
From the 4 phrases below choose the answer that is most like you and the one answer that is least like you. - Easy going, Agreeable | Least | s | S | S |  |  | If b3 = least look up e3 and give me the letter in e3
From the 4 phrases below choose the answer that is most like you and the one answer that is least like you. - Trusting, Believing in others | most | i | I | I |  |  | If b3 = most look up d3 and give me the letter in e3
From the 4 phrases below choose the answer that is most like you and the one answer that is least like you. - Adventurous, Risk Taker | most | * | * | D |  |  | If b4 = most look up d4 and give me the letter in e4
 |  |  |  |  |  |  | If b4 = most Least up e4 and give me the letter in e4
 |  |  |  |  |  |  | If b5 = most look up d5 and give me the letter in d5
 |  |  |  |  |  |  | If b5 = most least up e5 and give me the letter in e5
Spreadsheet: 98806d1297661132-vlook-up-from-a-range-of-numbers-book1
Sheet: Score

Name |  | Sit-Up | Points | Standing [NAME] | Points | Chin Up | Points | 4x10m [NAME] | Points | 2.4km Run-Walk | Points |  | Total Points
Jasper |  | 40 |  | 244 |  | 12 |  | 9.9 |  | 10.21
[NAME] |  | 37 |  | 243 |  | 5 |  | 10.1 |  | 10
[NAME] |  | 40 |  | 231 |  | 12 |  | 10.4 |  | 10.5
[NAME] |  | 40 |  | 234 |  | 4 |  | 10.3 |  | 9.55
Jordon |  | 41 |  | 245 |  | 5 |  | 10 |  | 11.34
[NAME] |  | 38 |  | 231 |  | 8 |  | 10.5 |  | 10.56
Zul |  | 37 |  | 222 |  | 6 |  | 10.2 |  | 11.13
Fandi |  | 41 |  | 223 |  | 11 |  | 10.4 |  | 10.14
Lucus |  | 36 |  | 233 |  | 11 |  | 10.4 |  | 11.4
Marcus |  | 44 |  | 242 |  | 9 |  | 10.1 |  | 11.2
[NAME] |  | 44 |  | 244 |  | 8 |  | 9.8 |  | 11.43
[NAME] |  | 40 |  | 231 |  | 9 |  | 10.1 |  | 11.54
Darras |  |  |  | 231 |  | 12 |  | 10.2 |  | 10.5
[NAME] |  | 31 |  | 234 |  | 10 |  | 8.9 |  | 9.9
[NAME] |  | 35 |  | 256 |  | 4 |  | 9.1 |  | 9.35
[NAME] |  | 43 |  | 278 |  | 11 |  | 10.2 |  | 10.14
Zack |  | 39 |  | 267 |  | 10 |  | 10.1 |  | 9.97
[NAME] |  | 39 |  | 267 |  | 11 |  | 10.4 |  | 10.46
Leonard |  | 38 |  | 244 |  | 11 |  | 10.3 |  | 9.55
[NAME] |  | 42 |  | 231 |  | 9 |  | 9.9 |  | 10.11
[NAME] |  | 41 |  | 233 |  | 8 |  | 10.1 |  | 10.58
[NAME] |  | 38 |  | 245 |  | 9 |  | 10.4 |  | 10.67
[NAME] |  | 46 |  | 236 |  | 11 |  | 10.3 |  | 10.41
[NAME] |  | 35 |  | 234 |  | 4 |  | 10 |  | 13
Mark |  | 46 |  | 235 |  | 5 |  | 10.5 |  | 12.45
[NAME] |  | 32 |  | 232 |  | 6 |  | 10.2 |  | 11.12
[NAME] |  | 46 |  | 222 |  | 6 |  | 10.4 |  | 10.24
[NAME] |  | 44 |  | 224 |  | 7 |  | 10.4 |  | 10.31
Julius |  | 41 |  | 235 |  | 12 |  | 10.1 |  | 10.21
Syed |  | 40 |  | 235 |  | 9 |  | 9.8 |  | 9.9
Spreadsheet: 76709d1277222032-count-with-multiple-criteria-sales-terms
Sheet: Sheet2

Employee # | Name | Department | Status
910 | [NAME] | Administration | Terminated
456 | [NAME] | Manufacturing | Active
123 | [NAME] | Marketing | Active
124 | [NAME] | Marketing | Active
125 | [NAME] | Marketing | Terminated
789 | [NAME] | Sales | Terminated
126 | [NAME] | Sales | Active
Spreadsheet: 80516d1280757618-arange-imported-data-example
Sheet: Sheet1

 |  |  | IMPORTED DATA |  |  |  |  |  |  |  |  |  |  |  | RESULTS
user1 | xyz | xyz | xyz | 19.57 (A) |  |  |  | 18.68 (A) |  |  |  | Details |  |  | USER NAME | TOTAL
 |  |  |  | set1 | set2 | set3 | set4 | set1 | set2 | set3 | set4
 |  |  |  | 19.57 | 0 | 0 | 0 | 18.68 | 0 | 0 | 0 |  |  |  | user1 | 19.57
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | user2 | 257.02
 |  |  |  | Total: 19.57 |  |  |  | Total: 18.68 |  |  |  |  |  |  | user3 | 8.15
user2 | xyz | xyz | xyz | 153.00 (A) |  |  |  | 127.82 (A) |  |  |  | Details |  |  | user4 | 24.88
 |  |  |  | set1 | set2 | set3 | set4 | set1 | set2 | set3 | set4 |  |  |  | user5 | 105.36
 |  |  |  | 153 | 0 | 0 | 0 | 127.82 | 0 | 0 | 0
 |  |  |  | 104.02 (AB) |  |  |  | 86.90 (AB)
 |  |  |  | set1 | set2 | set3 | set4 | set1 | set2 | set3 | set4
 |  |  |  | 104.02 | 0 | 0 | 0 | 86.9 | 0 | 0 | 0
 |  |  |  | Total: 257.02 |  |  |  | Total: 214.72
user3 | xyz | xyz | xyz | 8.15 (AB) |  |  |  | 7.78 (AB) |  |  |  | Details
 |  |  |  | set1 | set2 | set3 | set4 | set1 | set2 | set3 | set4
 |  |  |  | 8.15 | 0 | 0 | 0 | 7.78 | 0 | 0 | 0
 |  |  |  | Total: 8.15 |  |  |  | Total: 7.78
user4 | xyz | xyz | xyz | 19.71 (A) |  |  |  | 16.47 (A) |  |  |  | Details
 |  |  |  | set1 | set2 | set3 | set4 | set1 | set2 | set3 | set4
 |  |  |  | 19.71 | 0 | 0 | 0 | 16.47 | 0 | 0 | 0
 |  |  |  | 5.17 (AB) |  |  |  | 4.32 (AB)
 |  |  |  | set1 | set2 | set3 | set4 | set1 | set2 | set3 | set4
 |  |  |  | 5.17 | 0 | 0 | 0 | 4.32 | 0 | 0 | 0
 |  |  |  | Total: 24.88 |  |  |  | Total: 20.78
user5 | xyz | xyz | xyz | 74.23 (A) |  |  |  | 62.02 (A) |  |  |  | Details
 |  |  |  | set1 | set2 | set3 | set4 | set1 | set2 | set3 | set4
 |  |  |  | 74.23 | 0 | 0 | 0 | 62.02 | 0 | 0 | 0
 |  |  |  | 31.12 (AB) |  |  |  | 18.48 (AB)
 |  |  |  | set1 | set2 | set3 | set4 | set1 | set2 | set3 | set4
 |  |  |  | 16.14 | 0 | 14.99 | 0 | 13.48 | 0 | 5 | 0
 |  |  |  | Total: 105.36 |  |  |  | Total: 80.50
Spreadsheet: 845140d1696665127-generate-a-receipt-from-repeat-customer-file-hotel-2-aligw
Sheet: Receipt

 |  |  |  |  |  |  |  |  |  |  | Enter clients name | 1 [NAME]
 |  |  |  |  |  |  |  |  |  |  | Reservation | 1
Receipt
Dates |  | Description |  | No. Nights | Price | Total Price
 |  | Room number
 |  |  |  |  | Total price of stay
 |  |  |  |  | Tax
 |  |  |  |  | Deposits received
 |  |  |  |  | Total to Pay
Spreadsheet: 674223d1587725849-convert-text-to-bullets-convert-formula-to-number-format
Sheet: Finish

 | Value
RED BULLET | 7
GREEN BULLET | 4
RED BULLET | 1
RED BULLET | 1
RED BULLET | 1
RED BULLET | 1
GREEN BULLET | 4
YELLOW BULLET | 3
YELLOW BULLET | 2
GREEN BULLET | 4
RED BULLET | 1
RED BULLET | 1
RED BULLET | 1
Spreadsheet: 84920d1285007766-combining-data-from-multiple-workbooks-mock-up
Sheet: Invoice

 |  |  |  |  |  |  |  |  |  |  |  | Line Item 1 | 50
 |  |  |  |  |  |  |  |  |  |  |  | Line Item 2 | 100
 |  |  |  |  |  |  |  |  |  |  |  | Line Item 3 | 150
 |  |  |  |  |  |  |  |  |  |  |  | Line Item 4 | 125
 |  |  |  |  |  |  |  |  |  |  |  | Line Item 5 | 110
 | Number: |  |  | Date:
 |  |  | Name & Address
 |  |  |  | Name
 |  |  |  | Street
 |  |  |  | City, State
 |  |  | Account No. | 303522018
 |  | Line Item |  |  | Amount
 |  | Line Item 1 |  |  | 50
 |  | Line Item 2 |  |  | 100
 |  | Line Item 5 |  |  | 110
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  | Total: | 260
Spreadsheet: 582518d1531921248-get-spefic-value-return-in-uniques-forum-9
Sheet: Sheet1

Vendor | POrg | Funct |  | Vendor - Uniques of Column A & B | POrg - Uniques of Column A & B | Target Results
31593 | [NAME] | VN |  | 31593 | [NAME] | [NAME]
31593 | 7014 | VN |  | 31593 | 7014 | 7014 - XX
31593 | 9012 | VN |  | 31593 | 9012 | 9012 - XX
31593 | M004 | VN |  | 31593 | M004 | M004 - XX
31593 | S002 | VN |  | 31593 | S002 | S002 - XX
45975 | 9012 | VN |  | 45975 | 9012 | 9012 - XX
45975 | 9013 | VN |  | 45975 | 9013 | 9013 - XX
45975 | 9014 | VN |  | 45975 | 9014 | 9014 - XX
45975 | V002 | VN |  | 45975 | V002 | V002 - PI
45975 | V002 | PI |  | 45975 | V005 | V005 - PI
45975 | V005 | VN |  | 45975 | V006 | V006 - PI
45975 | V005 | PI |  | 72833 | P003 | P003 - XX
45975 | V006 | VN |  | 72833 | V005 | V005 - PI
45975 | V006 | PI |  | 72833 | V006 | V006 - PI
72833 | P003 | VN |  | 72863 | J002 | J002 - XX
72833 | V005 | VN
72833 | V005 | PI |  | 1. 31593 - OU02 has just one entry in column B, no PI in C2, so target value is OU02 - XX 2. 45975 - V002 has two entries in A10, A11 with VN & PI , so target value is V002 - PI And So on…... Column E & F are unique values for Columns A&B together.
72833 | V006 | VN
72833 | V006 | PI
72863 | J002 | VN
Spreadsheet: 104026d1301650143-balance-calculation-sample_shaj
Sheet: BKNG

CUSTOMERWISE BOOKING DETAILS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Executive
Sales Officer |  | [NAME]
Booking Date Range |  | From | 2010-12-01 00:00:00 | To | 2011-02-28 00:00:00 |  |  |  |  |  |  |  | Report run on
Total Sales for the period
Row Ref | Customer | Address | BKNG Date | Tower | Type | SqFt | Rate | Car Park No | Balance | Installments | Due Months | Paid Install | Total Paid | AGM
Spreadsheet: 847242d1698260489-correct-if-iserror-search-formula-re-sample-etaf
Sheet: RE Batch Table

Batch number | Description | Created By | Created On | [NAME] | Times Committed | Org | CC: T/F | AccCode | Column1 | Column2
26024 | AK CC - 7.2 to 7.8.23 Friends Place WPH | MYohannes | 2023-07-11 00:00:00 |  | 1
26131 | AK CC - Disbursed 8-15-23 Friends Place - $1,400.00 | MYohannes | 2023-08-23 00:00:00 |  | 1
26132 | EDF - August 23, 2023 - $5,700.00 | MYohannes | 2023-08-24 00:00:00 |  | 1
26133 | FCNL - August 23, 2023 - $7,000.00 | MYohannes | 2023-08-24 00:00:00 |  | 1
26134 | WPH - August 23, 2023 - $1,000.00 | MYohannes | 2023-08-24 00:00:00 |  | 1
26211 | AK CC - Disbursed 9-8-23 Friends Place WPH - $1,968.75 | MYohannes | 2023-09-14 00:00:00 |  | 1
26212 | WPH - September 14, 2023 - $3,375.00 | MYohannes | 2023-09-15 00:00:00 |  | 1
 | Column E looks into B to return Organization but one is being used interchangeably and needs to return same organization. Wherever you have "Friends Place WPH" and "Friends Place," both should give organization in Colum E as WPH.
Spreadsheet: 17bacb0e-5837-48c0-99d9-84c8f66e2d2c
Sheet: Sheet1

1. [NAME] (under Google logo) | 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 | Unnamed: 35
2. Select "Download As..."
3. Select "Excel"
Group Name: | Anytown Lacrosse Club | PLEASE DO NOT MODIFY SPREADSHEET HEADINGS OR LOCATIONS
Group USL ID: | 1234567
City, State: | Anytown, USA
Items in Red are mandatory |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Youth and HS.................................................................................................................... |  |  |  |  |  |  |  |  |  |  |  |  | Coach - Rulebook (Select One)..........................................
ID | DOB | LastName | FirstName | MiddleName | NickName | Suffix | Gender | HomeEmail | WorkEmail | HomePhone | WorkPhone | Address1 | Address2 | Address3 | City | State | Zip | Membership Level (Youth, HS, Adult) | Carrier | Policy | YouthUpgrade | FirstNameGuardian | LastNameGuardian | Relationship | GuardianPhone | GuardianEmail | FirstNameGuardian2 | LastNameGuardian2 | Relationship2 | GuardianPhone2 | GuardianEmail2 | Men's USL | Men's NCAA | Women's USL | Women's NCAA
1234567 | [NAME]/dd/yyyy | Doe | [NAME] |  | [NAME] | [NAME] | Male | [EMAIL] | [EMAIL] | [PHONE] | [PHONE] | 123 Main St | Apt |  | city | MD | 123456 | Youth |  |  |  | [NAME] | Doe | Mother | [PHONE] | [EMAIL]
Spreadsheet: 877730d1724586388-apply-sum-function-only-for-level-1-parent-row-level-1-sum-function
Sheet: TDSheet

 | Company 1 |  |  |  |  | 353.9 | 416
 | Company 2 |  |  |  |  | 112.34 | 115 |  |  | Modifying from Gregb11's formula in post #3,
 | Company 3 |  |  |  |  | 16 | 25 |  |  | I2: =IF(B2="","",IF(B2="Company 1",SUM(I3:[NAME]:I99,MATCH(TRUE,$B3:$B99="",0))),MAX(G2:H2))), enter with Ctrl+Shift+Enter
 | Company 4 |  |  |  |  | 225.55 | 276 |  |  | copy down
 | Company 1 |  |  |  |  | 372221.37 | 104449.56
 | Company 5 |  |  |  |  | 372221.37 | 104449.56
 | Company 1 |  |  |  |  | 14463.21 | 36802
 | Company 6 |  |  |  |  | 247.02 | 253
 | Company 7 |  |  |  |  | 43.24 | 70
 | Company 8 |  |  |  |  | 99.05 | 115
 | Company 9 |  |  |  |  | 52.61 | 96
 | Company 10 |  |  |  |  | 247.3 | 311
 | Company 11 |  |  |  |  | 12.75 | 30
 | Company 12 |  |  |  |  | 1732.09 | 2835
 | Company 13 |  |  |  |  | 19.46 | 64
 | Company 14 |  |  |  |  | 289.36 | 610
 | Company 15 |  |  |  |  | 852.54 | 1274
 | Company 16 |  |  |  |  | 95.17 | 74.8
 | Company 17 |  |  |  |  | 240.86 | 602
 | Company 18 |  |  |  |  | 34.81 | 54.8
 | Company 19 |  |  |  |  | 108.42 | 85
 | Company 20 |  |  |  |  | 11.14 | 15
 | Company 21 |  |  |  |  | 9468.99 | 27545
 | Company 22 |  |  |  |  | 908.41 | 2767.5
 | Company 1 |  |  |  |  | 494.1 | 758
 | Company 2 |  |  |  |  | 249.15 | 408
 | Company 2 |  |  |  |  | 210.46 | 300
 | Company 2 |  |  |  |  | 34.49 | 50
 | Company 1 |  |  |  |  | 84520.12
 | Company 2 |  |  |  |  | 84461.03
 | Company 2 |  |  |  |  | 59.1
 | Company 1 |  |  |  |  | 35832.56 | 288
 | Company 2 |  |  |  |  | 35632.66
 | Company 2 |  |  |  |  | 9 | 12
 | Company 2 |  |  |  |  | 11.24 | 15
 | Company 2 |  |  |  |  | 42.51 | 80
 | Company 2 |  |  |  |  | 93.75 | 125
 | Company 2 |  |  |  |  | 29.98 | 24
 | Company 2 |  |  |  |  | 13.42 | 32
 | Company 1 |  |  |  |  | 65947.97 | 195
 | Company 2 |  |  |  |  | 65771.16 | 25
 | Company 2 |  |  |  |  | 34.15 | 45
 | Company 2 |  |  |  |  | 15.85 | 25
 | Company 2 |  |  |  |  | 126.82 | 100
 | Company 1 |  |  |  |  | 2710.9
 | Company 2 |  |  |  |  | 2710.9
 | Company 1 |  |  |  |  | 33863.95 | 7010
 | Company 2 |  |  |  |  | 33863.95 | 7010
 | Company 1 |  |  |  |  | 7669.92 | 2906.96
 | Company 2 |  |  |  |  | 4662.36 | 12
 | Company 2 |  |  |  |  | 815.95
 | Company 2 |  |  |  |  | 2191.62 | 2894.96
 | Company 1 |  |  |  |  | 1700.71 | 5084
 | Company 2 |  |  |  |  | 131.19 | 200
 | Company 2 |  |  |  |  | 1569.52 | 4884
 | Company 1 |  |  |  |  | 10866.26 | 10700
 | Company 2 |  |  |  |  | 10866.26 | 10700
 | Company 1 |  |  |  |  | 4003.07
 | Company 2 |  |  |  |  | 4003.07
 | Company 1 |  |  |  |  | 88689.11 | 57
 | Company 2 |  |  |  |  | 476.49
 | Company 2 |  |  |  |  | 9 | 12
 | Company 2 |  |  |  |  | 87288.84
 | Company 2 |  |  |  |  | 56.71 | 45
 | Company 2 |  |  |  |  | 43.78
 | Company 2 |  |  |  |  | 814.3
 | Company 1 |  |  |  |  | 24200.96 | 30
 | Company 2 |  |  |  |  | 24183.25 | 30
 | Company 2 |  |  |  |  | 17.72
Spreadsheet: 0476c305-e194-4802-9926-e3334e1dbbc6
Sheet: Sheet1

RACM Asbestos Fee Calculation | 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
 |  |  |  | Fees for any amount of RACM are required pursuant to 20.11.2.14 NMAC.
 |  |  |  | In addition, no fee is required for ACM.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fee = | 22
 | Total RACM Asbestos Fee = |  |  |  |  | 0
 |  | RACM to be Removed |  |  |  |  |  | [NAME] |  |  | ACM to be Removed |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fee  =  $22.00 x ([NAME])
 |  | Ln. Ft. |  | Sq. Ft. |  | Cu. Ft. |  |  |  |  | Ln. Ft. |  | Sq. Ft. |  | Cu. Ft. |  |  |  |  |  |  |  |  |  |  | LF  =  linear Feet, SF  =  Square Feet, & CF =  [NAME]
 | Pipes | 0 |  | 0 |  | 0 |  | 0 |  | Pipes | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 | Surface Area | 0 |  | 0 |  | 0 |  | 0 |  | Surface Area | 0 |  | 0 |  | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 | Vol RACM Off Facility Component | 0 |  | 0 |  | 0 |  |  |  | Vol RACM Off Facility Component |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  | 0
 | Non Friable Asbestos Material to be Removed
 |  | Cat I to be Removed |  |  |  |  |  |  |  |  | Cat II to be Removed
 |  | Ln. Ft. |  | Sq. Ft. |  | Cu. Ft. |  |  |  |  | Ln. Ft. |  | Sq. Ft. |  | Cu. Ft.
 | Pipes | 0 |  | 0 |  | 0 |  |  |  | Pipes | 0 |  | 0 |  | 0
 | Surface Area | 0 |  | 0 |  | 0 |  |  |  | Surface Area | 0 |  | 0 |  | 0
 | Vol RACM Off Facility Component |  |  |  |  |  |  |  |  | Vol RACM Off Facility Component
 |  |  |  |  | Fee  =  $22.00 x ([NAME])
 |  |  |  |  | LF  =  linear Feet, SF  =  Square Feet, & CF =  [NAME]
 | Rev 05   02/19/14
Spreadsheet: 40340d1238637540-formula-to-count-highest-number-of-continuous-cells-w-data-in-a-range-and-their-sum-row-blanks-count
Sheet: Sheet1

 | Values | 10 | [NAME]
 |  | 0
 |  | 0
 | 1 | 1
 | 3 | 2
 | 5 | 3
 | 7 | 4
 | 9 | 5
 |  | 0
 | 2 | 1
 | 4 | 2
 | 6 | 3
 | 8 | 4
 | 10 | 5
 | 12 | 6
 | 14 | 7
 | 16 | 8
 | 18 | 9
 | 20 | 10
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 | 2 | 1
 | 4 | 2
 | 6 | 3
 | 8 | 4
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 | 2 | 1
 | 4 | 2
 | 6 | 3
 | 8 | 4
 | 10 | 5
 | 12 | 6
 | 14 | 7
 | 16 | 8
 | 18 | 9
Spreadsheet: 799069d1664898796-nesting-5-formulas-into-1-cell-forquestion
Sheet: Sheet1

Number | Location of Formula(s) | THE FORMULA | Searches for in T7
1 | Column U | IF(OR(ISNUMBER(SEARCH("5/3 Bankcard",T7,1))=TRUE,TRIM(T7)="DEPOSIT")=TRUE,"REMOVE","Ok") | "5/3 Bankcard" anywhere in T7 **or** the word "DEPOSIT" when it is the ONLY word in T7
2 | Column V | IF(AND(ISERROR(SEARCH("AETNA",T7,1))=TRUE,(SEARCH(SUBSTITUTE("TRN*1*2522","*","~*"),T7,1))),"OK","REMOVE") | the word "Aetna" AND the phrase "TRN*1*2522" in T7
3 | Column W | IF(AND(ISERROR(SEARCH("HUMANA",T7,1))=TRUE,(SEARCH(SUBSTITUTE("TRN*1*1","*","~*"),T7,1))),"Ok","REMOVE") | the word "Humana" AND the phrase "TRN*1*1" in T7
4 | Column X | IF(ISNUMBER(SEARCH("VANTIV",T7,1))=TRUE,"REMOVE","OK") | The word VANTIV anywhere in T7
5 | Column Y | IF(SEARCH("CENTER DEPOSIT",T7,1)>0,"REMOVE","OK") | The phrase "CENTER DEPOSIT"anywhere in T7
 | Nest into 1 column | =(formula 1,formula 2,formula 3,formula 4,formula 5)
Spreadsheet: 62660aad-6b40-4220-830a-baa50f091d42
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Paramount | 667068645224 | Various | [NAME]: King Of Dreams (D-Se-Ws) | 2008-12-02 | DVD | Children | 7.99 | Y | Available
Paramount | 97368748347 | Peanuts | Cbs: Boy Named [NAME] (D-Se) | 2008-12-02 | DVD | Children | 14.99 | Y | Available
Spreadsheet: 455701d1460470051-how-to-combination-of-three-columns-with-specified-steps-combination
Sheet: Sheet1

 |  |  |  | Desired result
name | size | color
aaa | 20*20 | yellow |  | aaa 20*20 yellow
bbb | 50*40 | green |  | aaa 20*20 green
[NAME] | 70*90 | Blue |  | aaa 20*20 blue
 |  |  |  | aaa 50*40 yellow
 |  |  |  | aaa 50*40 green
 |  |  |  | aaa 50*40 blue
 |  |  |  | aaa70*90 yellow
 |  |  |  | aaa70*90 green
 |  |  |  | aaa70*90 blue
 |  |  |  | bbb 20*20 yellow
 |  |  |  | bbb 20*20  green
 |  |  |  | bbb 20*20 blue
 |  |  |  | .
 |  |  |  | .
 |  |  |  | .
 |  |  |  | .
 |  |  |  | etc.