tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 776318d1649685791-sumifs-formula-with-no-criteria-equal-blanks-instead-of-zero-test
Sheet: Sheet1

Player | FP | Tm | Opp |  | FP | Player
[NAME] | 17 | SD | ARI |  | ARI
[NAME] | 0 | SD | ARI |  | ATL
[NAME] | 0 | SD | ARI |  | BAL
[NAME] | 0 | SD | ARI |  | BOS
[NAME] | 7 | SD | ARI |  | CHC
Tyler Mahle | 26 | CIN | ATL |  | CIN
[NAME] | 6 | CIN | ATL |  | CLE
[NAME] | 6 | CIN | ATL
[NAME] | 2 | CIN | ATL
[NAME] | 2 | CIN | ATL
[NAME] | 0 | MIL | CHC
[NAME] | 0 | MIL | CHC
[NAME] | 0 | MIL | CHC
[NAME] | 6 | ATL | CIN
[NAME] | 15 | ATL | CIN
Tyler Thornburg | 6 | ATL | CIN
[NAME] | 0 | ATL | CIN
[NAME] | 8 | KC | CLE
[NAME] | 13 | KC | CLE
[NAME] | 4 | KC | CLE
[NAME] | 0 | KC | CLE
Spreadsheet: 697749d1601505141-sum-of-2-criterias-in-different-sheet-example
Sheet: Sheet1

Order | Suborder | Budget | January | February | March | April | May | June | July | August
10 | 001 | 500000 |  |  |  |  |  | 725814.75 | 773260.67 | 1110746.109999999
10 | 002 | 1220 |  |  |  |  |  | 343372.34 | 353093.25 | 349438.23
10 | 003 | 12303 |  |  |  |  |  | 393347.78 | 707547.3700000002 | 292618.59
10 | 004 | 257582.89 |  | 5796.639999999999 | 7292.8 | 7841.21
10 | 005 | 13734.39 |  | 40801.13 | 42046.42 | 43470.67000000001
10 | 006 | 500000 |  | 0.64 | 0.65 | 0.6
10 | 007 | 1220 |  | 23071.75 | 20610.39 | 24798.3299999999
10 | 008 | 12303 |  |  |  |  | 725814.75 | 773260.67 | 1110746.109999999
10 | 009 | 257582.89 |  |  |  |  | 343372.34 | 353093.25 | 349438.23
10 | 010 | 13734.39 |  |  |  |  | 393347.78 | 707547.3700000002 | 292618.59
10 | 011 | 500000 |  |  |  |  | 0 | 0 | 0
11 | 001 | 1220 |  |  |  |  | 80934.70999999999 | 84884.14 | 160911.19
11 | 002 | 12303
11 | 003 | 257582.89 |  | 725814.75 | 773260.67 | 1110746.109999999
11 | 004 | 13734.39 |  | 343372.34 | 353093.25 | 349438.23
11 | 005 | 500000 |  | 393347.78 | 707547.3700000002 | 292618.59
11 | 006 | 1220 |  | 0 | 0 | 0
11 | 007 | 12303 |  | 80934.70999999999 | 84884.14 | 160911.19
11 | 008 | 257582.89 |  |  |  |  |  | 725814.75 | 773260.67 | 1110746.109999999
11 | 009 | 13734.39 |  |  |  |  |  | 343372.34 | 353093.25 | 349438.23
11 | 010 | 500000 |  |  |  |  |  | 393347.78 | 707547.3700000002 | 292618.59
11 | 011 | 1220 |  |  |  |  |  | 0 | 0 | 0
12 | 001 | 12303 |  |  |  |  |  | 80934.70999999999 | 84884.14 | 160911.19
12 | 002 | 257582.89
12 | 003 | 13734.39 |  |  |  |  | 725814.75 | 773260.67 | 1110746.109999999
12 | 004 | 500000 |  |  |  |  | 343372.34 | 353093.25 | 349438.23
12 | 005 | 1220 |  |  |  |  | 393347.78 | 707547.3700000002 | 292618.59
12 | 006 | 12303 |  |  |  |  | 0 | 0 | 0
12 | 007 | 257582.89 |  |  |  |  | 80934.70999999999 | 84884.14 | 160911.19
12 | 008 | 13734.39 |  |  |  |  |  | 725814.75 | 773260.67 | 1110746.109999999
12 | 009 | 500000 |  |  |  |  |  | 343372.34 | 353093.25 | 349438.23
12 | 010 | 1220 |  |  |  |  |  | 393347.78 | 707547.3700000002 | 292618.59
12 | 011 | 12303 |  |  |  |  |  | 0 | 0 | 0
Spreadsheet: a9ab486a-76a4-49b8-beaf-60724d7241bc
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2013-10-22 09:35:48.130000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.625 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
4.5 | 101.972 | 101.847 | 101.722 | 101.347
4.375 | 101.526 | 101.401 | 101.276 | 100.901 |  | Note: | Refer To Price [NAME]
4.25 | 101.008 | 100.883 | 100.758 | 100.383 |  |  | For all Price Adjs
4.125 | 100.24 | 100.115 | 99.99 | 99.365
4 | 99.281 | 99.156 | 99.031 | 98.406
3.875 | 98.266 | 98.141 | 98.016 | 97.391
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.75 | 102.125 | 102 | 101.875 | 101.5
3.625 | 102.071 | 101.946 | 101.821 | 101.446
3.5 | 101.806 | 101.681 | 101.556 | 101.181
3.375 | 101.053 | 100.928 | 100.803 | 100.428
3.25 | 100.33 | 100.205 | 100.08 | 99.455
3.125 | 99.581 | 99.456 | 99.331 | 98.706
3 | 99.049 | 98.924 | 98.799 | 98.174 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2013-11-05 09:35:48.130000
30 DAY | 2013-11-20 09:35:48.130000
45 DAY | 2013-12-05 09:35:48.130000
60 DAY | 2013-12-20 09:35:48.130000
90 DAY | 2014-01-19 09:35:48.130000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 64257d1265132910-search-tabs-and-return-results-kc-environmental-aspects-and-impacts-worksheet-questions
Sheet: Process - Activity 9

Operating Condition | Process Evaluated |  | Date |  |  |  |  | Team
 | Aspect | Impact | NR | RD | KC | L&R | Total Score | Significant? | Objective and Target? | Operational Controls
Normal | Polymer [NAME] | Resource Preservation | 3 | 3 | 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: 30359d1225848153-how-to-sort-and-count-to-sort-and-count
Sheet: Sheet1

Group 1
FIN Number | S/No | Name | Sub Group | Age | DOB | Exam Grade
11 | 1 | [NAME] | A | 25 | 2007-09-03 00:00:00 | 5
12 | 2 | [NAME] | B | 30 | 2004-08-02 00:00:00 | 5
13 | 3 | Gabe | A | 30 | 2007-07-16 00:00:00 | H4
14 | 4 | Viv | A | 27 | 2007-11-06 00:00:00 | 4
15 | 5 | [NAME] | B | 25 | 2007-07-30 00:00:00 | H4
16 | 6 | [NAME] | A | 31 | 2007-08-01 00:00:00 | 5
17 | 7 | [NAME] | A | 27 | 2007-06-18 00:00:00 | [NAME]
18 | 8 | [NAME] | B | 33 | 2007-11-12 00:00:00 | 5
19 | 9 | [NAME] | A | 27 | 2007-08-13 00:00:00 | 5
20 | 10 | [NAME] | A | 25 | 2008-01-07 00:00:00 | 3
21 | 11 | Adrain | B | 32 | 2007-08-06 00:00:00 | 5
22 | 12 | [NAME] | B | 33 | 2007-10-01 00:00:00 | 3
23 | 13 | Pauline | A | 29 | 2007-11-06 00:00:00 | 5
24 | 14 | [NAME] | B | 35 | 2007-11-05 00:00:00 | 3
 | Group | Score 5 | Score H4 | Score 4 | Score L4 | Score 3
 | A
 | B
 | Please teach me how to sort and count the number of people under group A who have scored the various scores
 | and likewise for [NAME]
Spreadsheet: 819644d1677609191-dept-and-expense-type-match-to-calculate-total-amount-test
Sheet: Income Statement by Dept

 | Budget Expenses | BDR | CSM | CSM | Marketing | Engineering | Marketing | General and Administrative | Product & Design | Marketing | Engineering | General and Administrative | Product & Design
 | Employee Compensation | 1000 | 150 | 2000 | 5000 | 9000 | 17000 | 900 | 508791.78 | 308784.14 | 239204.54 | 1070005.66 | 518798.21
 | Commission & Bonus
 | Commission & Bonus
 | Commission & Bonus
 | Payroll Taxes
 | Health Benefits | 0 | 0 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50
 | Third Party Services | 1000
 | Third Party Services |  | 2000
 | Third Party Services |  |  | 3000
Spreadsheet: 883915d1732691183-lambda-and-xlookup-issue-jp-bagel-excel-sumif-let-riddle-spill-365-aligw
Sheet: Sheet1

Raw data |  |  |  |  |  |  |  | Named ranges
Fruits | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 |  |  | References | Name
Apples | 2229 | 2366 | 2623 | 2878 | 3001 |  |  | A2:F13 | tblData
Pears | 700 | 849 | 1140 | 1294 | 1568 |  |  | B3:F13 | tblDataBody
[NAME] | 0 | 0 | 0 | 0 | 0 |  |  | B2:F2 | lstMonths
Bananas | 176 | 184 | 219 | 224 | 226 |  |  | A3:A13 | lstFruits
Peaches | 7 | 8 | 9 | 10 | 10 |  |  | A17:[NAME] | tblBundles
Cherries | 296 | 207 | 205 | 217 | 222 |  |  | A11:A19 | lstBundles
Tomatoes | 155 | 158 | 161 | 164 | 168
Dates | 383 | 390 | 397 | 444 | 451
Nuts | 0 | 23 | 46 | 35 | 89
Raspberries | 4511 | 5622 | 7732 | 8966 | 11132
Strawberries | 11877 | 12088 | 15770 | 16041 | 18154
Bundles
Name | Includes |  |  |  |  |  |  | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 |  |  | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00
Red | Strawberries | Raspberries | Cherries | Tomatoes |  |  | Red | 16839 | 18075 | 23868 | 25388 | 29676 |  | Red | 16839 | 18075 | 23868
Yellow | Pears | Apples | Peaches |  |  |  | Yellow | 2936 | 3223 | 3772 | 4182 | 4579 |  | Yellow | 2936 | 3223 | 3772
Dry | Nuts | [NAME] | Dates |  |  |  | Dry | 383 | 413 | 443 | 479 | 540 |  | Dry | 383 | 413 | 443
Reports
Bundle | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 |  | <- This solution works great enough, but I am looking to simplify it even more.
Red |  |  |  |  | =SUM(SUMIFS(B$4:B$14,lstFruits,FILTER(tblBundles,lstBundles=$A25,0)))
Yellow |  |  |  |  | Look in January data,in the list of fruits and sum if fruit is included in the bundle filtered to the bundle color.
Dry
Bundle | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 |  | <- I'd love to have a clean LET function, pass the ranges for months and bundle names to a LAMBDA function
Red |  | 18075 | 23868 |  | and spill the values in the table. I banged my head on the SUMIF only accepting ranges issue for days…
Yellow | 2936 | 3223 | 3772 |  | Can I use the same FILTER approach, and use a LAMBDA to SUM all the XLOOKUP values for each fruit?
Dry | 383 | 413 | 443 |  | I've failed so far…
Spreadsheet: 131825d1323348057-recording-macros-over-serveral-workbooks-overall-results
Sheet: Counter

 | Training rate
blanc | 100 | 100 | 100 | 100
rouge |  |  |  |  |  |  | Min | [NAME] | Frontière rouge | Valeur
[NAME] |  |  |  |  |  |  | 0 | 100 | 0
vert |  |  |  |  |  |  | Nb négatif | Nb positif | Entre 0 et min
 | Inspection rate
blanc | 100 | 100 | 100 | 100
rouge |  |  |  |  |  |  | Min | [NAME] | Frontière rouge | Valeur
[NAME] |  |  |  |  |  |  | 0 | 100 | 0
vert |  |  |  |  |  |  | Nb négatif | Nb positif | Entre 0 et min
Spreadsheet: 774142d1648228885-one-formula-to-contain-multiple-conditions-new-fahadmohsin-
Sheet: Fee Slabs

Size tier |  | [NAME] dimension |  | Shipping weight ¹ |  | Fulfillment fee per unit ²
 |  |  |  |  |  |  |  | WORKINGS
 |  |  |  |  |  |  |  | HEIGHT | LENGTH | WIDTH /THICK NESS | Unit Weight | Result
 |  |  |  | 6 oz or less or 0.375 (lb) |  | 2.92 |  | 15 | 12 | 0.75 | 0.375
Small standard |  | 15" x 12" x 0.75" |  | 6+ to 12 oz or 0.375 to 0.75 (lb) |  | 3.07 |  | 15 | 12 | 0.75 | 0.75
 |  |  |  | 12+ to 16 oz or 1(lb) |  | 3.59 |  | 15 | 12 | 0.75 | 1
 |  |  |  | 6 oz or less or 0.375(lb) |  | 3.54 |  | 18 | 14 | 8 | 0.375
 |  |  |  | 6+ to 12 oz or 0.375 to 0.75 (lb) |  | 3.77 |  | 18 | 14 | 8 | 0.75
 |  |  |  | 12+ to 16 oz or 1(lb) |  | 4.52 |  | 18 | 14 | 8 | 1
 |  |  |  | 1+ to 2 lb |  | 5.14 |  | 18 | 14 | 8 | 2
Large standard |  | 18” x 14” x 8” |  | 2+ to 3 lb |  | 5.79 |  | 18 | 14 | 8 | 3
 |  |  |  | 3+ lb to 20 lb |  | $6.13 + $0.30/lb above first 3 lbs |  | 18 | 14 | 8 | 20
 |  |  |  | 70 lb or less |  | $8.94 + $0.38/lb above first lb
Small oversize |  | 60" x 30"
 |  |  |  | 150 lb or less |  | $12.73 + $0.44/lb above first lb
Medium oversize |  | 108” (longest side)
 |  |  |  | 150 lb or less |  | $82.58 + $0.79/lb above first 90 lbs
Large oversize |  | 108” (longest side)
 |  |  |  | Over 150 lb |  | $150.94 + $0.79/lb above first 90 lbs
Special oversize |  | >108” (longest side)
Spreadsheet: 152500d1335413804-indexing-problem-idexproblem
Sheet: Sheet1

 | Array 1 |  |  |  | 2 | 3 | 4 | 5 | 8 | 9 | 10
 | 1 | d |  | a
 | 2 | b |  | b
 | 3 | a
 | 4 | a
 | 5 | b
 | 6 | c
 | 7 | d
 | 8 | a
 | 9 | b
 | 10 | b
 | In the yellow row, the numbers displayed in array 1 next to a letter identical to a letter in the blue array, are displayed. The order does not matter (I displayed them from small to large, but this does not matter).
 | In other words:
 | If a or b from the blue cells are found in Column C, display the corresponding number from Column B in the yellow array.
Spreadsheet: 165c55d5-2c92-423e-942e-d393076b0bbe
Sheet: Sheet1

[NAME] | Name | Parametric p-value | [NAME] | Permutation p-value
PRKCSH | protein kinase C substrate | 0.0057803 | 0.234 | 0.0056
CDK16 | cyclin-dependent kinase 16 | 0.0051758 | 0.234 | 0.0049
CHKA | [NAME] alpha | 0.009091 | 0.234 | 0.008
PLK1 | polo-like kinase 1 | 0.0312112 | 0.234 | 0.0307
RYK | RYK receptor-like tyrosine kinase | 0.0316162 | 0.234 | 0.0286
MARK1 | MAP/microtubule affinity-regulating kinase 1 | 0.0448221 | 0.234 | 0.0385
SRPK2 | SRSF protein kinase 2 | 0.0456667 | 0.234 | 0.0449
KHK | ketohexokinase (fructokinase) | 0.0463016 | 0.234 | 0.0426
Spreadsheet: 127282d1320268742-reorganize-data-sample
Sheet: raw data

SHEET NUMBER | REMOVE Conc CURB |  |  |  |  | [NAME] |  |  |  |  | REMOVE MBGR |  |  |  |  | REMOVE RW |  |  |  |  | CL FENCE |  |  |  |  | [NAME] ([NAME]) |  |  |  |  | [NAME]
 | [NAME] |  |  |  |  | [NAME] |  |  |  |  | [NAME] |  |  |  |  | [NAME] |  |  |  |  | [NAME] |  |  |  |  | [NAME] |  |  |  |  | [NAME]
 | Beg | END | LENGTH | DIRECTION | ALIGNMENT | Beg | END | LENGTH | DIRECTION | ALIGNMENT | Beg | END | LENGTH | DIRECTION | ALIGNMENT | Beg | END | LENGTH | DIRECTION | ALIGNMENT | Beg | END | LENGTH | DIRECTION | ALIGNMENT | Beg | END | LENGTH | DIRECTION | ALIGNMENT | Beg | END | LENGTH | DIRECTION | ALIGNMENT
C-1 | 155219.55 | 155565.64 | 354.97 | SB | A | 155219.55 | 155850 | 629.6 | MEDIAN | A | 155219.55 | 155588.37 | 375.85 | SB | A |  |  |  |  |  | 155173.39 | 155850 | 690.01 | SB | A |  |  |  |  |  | 155522.89 | 155850 | 333.28 | SB | A
 | 155231.51 | 155660.82 | 434.81 | NB | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 155208.23 | 155662.15 | 442.69 | NB | A
 | 155522.89 | 155850 | 333.28 | SB | A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 155662.92 | 155850 | 187.97 | SB | A
C-2 | 155980.23 | 156900 | 965 | NB | A | 155850 | 156900 | 1078.7 | MEDIAN |  | 156271.7 | 156373.23 | 101.2 | SB | A | 155850 | 156036.53 | 184.4 | SB | A | 155850 | 156043.1 | 190.8 | SB | A |  |  |  |  |  | 155850 | 156900 | 1030.4 | SB | A
 | 55983.42 | 56900 | 970.7 | NB | D | 155972.52 | 156271.7 | 298 | SB | A | 56682.69 | 56732.8 | 51.1 | NB | D | 156833.09 | 156900 | 70.2 | NB | A | 56425.99 | 56850.12 | 439.1 | SB | C
 | 55872.89 | 56459.42 | 594.2 | NB | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 155850 | 156900 | 1044 | SB | A
C-3 | 57431.95 | 57587.92 | 159.4 | NB | C | 156900 | 157600 | 720.5 | MEDIAN | A | 57200.95 | 57248.75 | 64.7 | SB | C | 56872.42 | 57167.45 | 310.2 | SB | C | 156900 | 157136.07 | 233.9 | SB | A | 1352.69 | 1598.19 | 66.8 | NB | B | 156900 | 157198.03 | 302.8 | SB | A
 | 156900 | 157124.43 | 222 | SB | A |  |  |  |  |  | 157252.3 | 157414.44 | 164.8 | NB | A | 156900 | 157128.1 | 238.2 | NB | A | 57097.49 | 57248.75 | 255.5 | SB | C
Spreadsheet: ae754c81-0a25-41dd-a2aa-9283cff9f7c2
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
CCP | Test | CCP | Cyclic Citrullinated Peptide Antibodies, IgG, Serum | Cyclic Citrullinated Peptide Ab, S | Enzyme-Linked Immunosorbent Assay (ELISA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | <20.0 U (negative) 20.0-39.9 U (weak positive) 40.0-59.9 U (positive) > or =60.0 U (strong positive) Reference values apply to all ages. | Monday through Saturday; 4 p.m. | Same day/1 day | 3 days | 1 | 86200 |  |  |  |  | Rochester
CCP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 21 days
CCP | Result | CCP | Cyclic Citrullinated Peptide Ab, S | Cyclic Citrullinated Peptide Ab, S | Numeric |  |  |  |  | U |  |  |  |  |  |  |  |  |  | 32218-0 | Cyclic citrullinated peptide [NAME]:ACnc:Pt:Ser:Qn:EIA
Spreadsheet: 874285d1720862060-name-by-the-line-of-the-sheet-of-excel-livro111
Sheet: Folha1

LT 1 | AA
LT 2 | AB |  |  |  |  |  |  | NOME | A
LT 3 | ABC
LT 4 | DEE
LT 5 | DER
LT 6 | AFD
LT 7
LT 8
LT 9
LT 10
LT 11
LT 12
LT 13
Spreadsheet: 01225ed2-ed30-4bf5-acce-3708a5b2c08d
Sheet: Sheet1

Tuesday
Packet stuff | [NAME] | : [NAME] [NAME] | [NAME] | Over night tech inspection
 | [NAME] | [NAME]John | [NAME] | Marco &  [NAME]
Wednesday
Task | 8-10 AM | 10-12 PM | 1- 3 PM | 3-5 PM
Tech Inspection | Rockrunner | [NAME] (daisydog) | [NAME] | [NAME]
 | [NAME] | [NAME] | [NAME] (cruiserman) | [NAME]
 | [NAME] | [NAME] | [NAME] | [NAME]
 | [NAME] | [NAME] | [NAME] | [NAME][NAME]
 | [NAME] | [NAME]
Wednesday
Registration & Merch sales | [NAME] | [NAME] | [NAME] | [NAME]
 | [NAME] | Idelle | [NAME] | [NAME]
 | [NAME] | [NAME] | Nakman & son | [NAME] (gf)Mickley
Thursday
Tech Inspection             7-8 am | [NAME]
 | [NAME]
Registeration 7-8 AM | [NAME]
 | [NAME]
Friday
Tech Inspection             7-8 am | [NAME]
 | [NAME]
 | [NAME]
Registeration 7-8 AM | [NAME]
 | [NAME]
 | [NAME]
Dinner first shift
Marco Capote | Caroline Capote | Rockrunner | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] R.(Jacket) | [NAME] | [NAME]
Dinner second shift
[NAME] | [NAME] | [NAME] | Corsair23 + family
Megan Volmer | [NAME] | [NAME] | [NAME]
[NAME] | [NAME]
Spreadsheet: 816516ae-b936-4f6c-b1a8-64d7995504a1
Sheet: Page 7

Permit No.: |  |  | WQ0003765 |  |  | Facility Name: |  | New Bern Seven Water Reclamation Facility |  |  |  |  |  | County: | [NAME] |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | SF-1 |  | Field Name: |  | SF-2 |  | Field Name: |  | SF-2 EXT |  | Field Name: |  | SF-3
 |  |  |  |  |  | Area (acres): |  | 2.12 |  | Area (acres): |  | 2.16 |  | Area (acres): |  | 0.91 |  | Area (acres): |  | 2.11
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.57 |  | [NAME] (in): |  | 0.57 |  | [NAME] (in): |  | 0.57 |  | [NAME] (in): |  | 0.57
 |  |  |  |  |  | Annual Rate (in): |  | 21 |  | Annual Rate (in): |  | 21 |  | Annual Rate (in): |  | 21 |  | Annual Rate (in): |  | 21
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 677935d1589600159-formula-resulting-to-hashtags-05-may-2020
Sheet: Statement of Payment

 | PLDT
 | Office | Acct no. | Nature of Payment / Particulars
 |  | 1106260
 |  | 1036300
 |  | 28356870
 |  | 28356870
 |  | 28356870
 |  | 28356870
 |  | 500585
 |  | 501549
 |  | 504459
 |  | 652949266
 |  | 653730705
 |  | 95226655
 |  | 500615
 |  | 28356919
 |  | 504548
 |  | 148595356
 |  | 504572
 |  | 502618
 |  | 500682
 |  | 502294
 |  | 1180363
 |  | 504483
 |  | 500623
 |  | 504491
 |  | 651271711
 |  | 151013325
 |  | 151013392
 |  | 161359262
 |  | 161359203
 |  | 149512217
 |  | 149512330
 |  | 607982147
 |  | 151013236
 |  | 502626
 |  | 1036823
 |  | 500593
 |  | 601605147
Spreadsheet: 734896d1622567652-help-with-indirect-formula-book1-etaf
Sheet: Sheet1

 | 2021-01-01 00:00:00
 |  |  |  |  |  | I need [NAME] in Sheet1,Cell C31 to get value from "Jan" Tab, cell [NAME] (This needs to be defined by cell A31, Sheet1) Result in cell C31 in Sheet1 needs to be 1500.15
Spreadsheet: 112129d1308261350-if-statement-comparing-3-values-if-statement-help
Sheet: Sheet1

Part Number | Manufacturer | Qty | Cost | Overhead | Price | Ext. |  | Cost | Overhead | Price | Ext. |  | Cost | Overhead | Price | Ext.
 |  |  | A |  |  |  |  | B |  |  |  |  | C
 |  | 1 | 103 |  |  |  |  | 102.56 |  |  |  |  | 98.94
 |  |  |  |  |  |  |  | I am trying to compare the three highlighted values and have the cell return the lowest value
 |  |  |  |  |  |  |  | hopefully with the representation of either A, B or C
Spreadsheet: 44600d1243371476-nested-if-formula-categorise-dates-into-appropriate-financial-quarter-dummy-wookbook-v2
Sheet: Asbestos (2)

ASBESTOS | No. of Days Lost
January | 2 |  |  | 2009-01-01 00:00:00
February | 0 |  |  | 2009-02-01 00:00:00
March | 3 |  |  | 2009-03-01 00:00:00
April | 0 |  |  | 2009-04-01 00:00:00
May | 0 |  |  | 2009-05-01 00:00:00
June | 0 |  |  | 2009-06-01 00:00:00
July | 0 |  |  | 2009-07-01 00:00:00
August | 0 |  |  | 2009-08-01 00:00:00
September | 0 |  |  | 2009-09-01 00:00:00
October | 0 |  |  | 2009-10-01 00:00:00
November | 0 |  |  | 2009-11-01 00:00:00
December | 0 |  |  | 2009-12-01 00:00:00
TOTALS | 5 |  |  | 2010-01-01 00:00:00
Spreadsheet: 747376d1631447145-combining-data-from-multiple-sheets-maintaing-sequence-excel-query-dynamically-combining-data-from-multiple-sheets-in-sequence
Sheet: Sheet2

S.no. | Item | Make | Parameter1 | Parameter2 | Parameter3 | Model | Partno. | Price
1 | B | SCH | 25KVAR | HD | Cylinder | MPPHD | [NAME] | 210
2 | B | SIE | 37KVAR | SD | Bpx | MPSD | MSIESD | 120
3 | B | SIE | 25KVAR | HD | Cylinder | MPPHD | MSIEHD | 230