tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 103129d1300930942-vlookup-isnt-updating-on-data-change-mage_gear
Sheet: Calculations

Int Test | Before | After | Difference |  |  |  |  |  |  |  |  |  |  | [NAME] | T1 Plaque Boots | T2 Plaque Boots | [NAME]
Intelligence | 408 | 510 |  |  | 1 int is worth… |  | Relative stat worth… |  |  |  |  |  |  | Int | 17 | 19 | 20
Spell Power | 859 | 910 |  |  |  |  |  |  |  |  |  |  |  | Wis | 10 | 12 | 14
Crit Rating | 478 | 580 |  |  | DPS |  | (be sure to enter your int modifier in the bottom right) |  |  |  |  |  |  | Spell | 9
Crit % | 18.12 | 21.99 |  |  |  |  |  |  |  |  |  |  |  | Crit |  | 19 | 20
[NAME] | 343 | 358 |  |  |  |  |  |  |  |  |  |  |  | Focus
[NAME] | 517 | 540
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | Item worth:
[NAME]
Cast Time | 2
Crit Test | Before | After | Difference
Intelligence |  |  |  |  | 1 crit is worth… |  | Relative stat worth (for TWO crit)…
Spell Power
Crit Rating |  |  |  |  | DPS |  | (for items spell crit is always 2x what it would be for any other stat)
Crit %
[NAME]
[NAME]
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter your int modifier: | 1 | (1.00 for normal, 1.25 for Chloro, 1.10 for Dom, 1.35 for Chloro/Dom)
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | (this is to determine your relative stat worth and item worth, even though we use Chloro spec to help test this data if you don't plan on using Chloro spec normally just enter 1.00)
Spell Test | Before | After | Difference
Intelligence |  |  |  |  | 1 spell is worth… |  | Relative stat worth…
Spell Power
Crit Rating |  |  |  |  | DPS
Crit %
[NAME]
[NAME]
[NAME]
[NAME]
Wis Test | Before | After | Difference
Wisdom |  |  |  |  | 1 wis is worth… |  | Relative stat worth…
Spell Power
Crit Rating |  |  |  |  | DPS
Crit %
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 158974d1338470225-conditional-formatting-example-1
Sheet: Sheet1

 | Valid for | 24 months | 12 months | 12 months | 6 months | 12 months | 36 months | 18 months | 12 months | 12 months
 | Staff Name | Course 1 | Course 2 | Course 3 | Course 4 | Course 5 | Course 6 | Course 7 | Course 8 | Course 9
 | Colleague 1 | 2005-03-24 00:00:00 | 2009-05-02 00:00:00 | 2011-01-10 00:00:00 |  |  |  | 2009-04-30 00:00:00 | 2010-10-19 00:00:00 | 2010-01-04 00:00:00
 | Colleague 2
 | Colleague 3
 | Colleague 4
 | Colleague 5
 | Colleague 6
 | Colleague 7
 | Colleague 8
 | Colleague 9
 | Colleague 10
 | Colleague 11 |  | 02.11.10 | 08.11.10 |  | 03.06.11 |  | 03.05.12 | 25.10.10
 | Colleague 12
 | Colleague 13
 | Colleague 14
 | Colleague 15
 | Colleague 16
 | Colleague 17
 | Colleague 18
 | Colleague 19
Spreadsheet: 164760d1340884878-ctc-calculation-ended-up-with-error-ctc-calculation
Sheet: Sheet1

 |  | 0.31 | 0.4 |  |  |  |  |  |  | 0.12 | 0.0481 | 0.0475
 | CTC | BASIC | HRA | Other Allowance | Monthly Gross | Sodexo | TOTAL A | TOTAL A*12 | LTA | PF | GRAT | ESI | Total B | Total A*12 + Total B | PI | AG | Med | Transport | New CTC
my data | 100000 |  |  |  |  | 1300 |  |  |  |  |  |  |  |  | 12000 |  |  | 16200
Actual value | 100000 | 2583.333333333333 | 86.11111111111113 | 1348.44 |  | 1300 |  |  |  |  |  |  |  |  | 12000 |  |  | 16200
 |  | Monthly | Monthly | Monthly | Monthly | Monthly | Monthly | Annually | Annually | Annually | Annually | Annually | Annually | Annually | Annually | Annually | Annually | Annually | Annually
 |  |  | Balancing figure
 |  |  | Balancing figure of Column T-Column B
 |  |  | value of E4 is manual keyed in…
 |  |  | can I get value of E4 automatically by formulas or with any codes which will help me in this regards.
Spreadsheet: 719697d1613757837-count-distinct-values-in-two-columns-where-the-third-matches-a-value-unique-count
Sheet: Sheet1

days | ID | organisation |  |  | expected results
2020-01-01 00:00:00 | 1 | CNN |  |  |  | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00
2020-01-02 00:00:00 | 124 | CNN |  |  | ABC | 0 | 2 | 1
2020-01-21 00:00:00 | 123 | CNN | same day and IDs |  | CNN | 3 | 0 | 1
2020-01-21 00:00:00 | 123 | CNN |  |  | IBM | 0 | 1 | 0
2020-02-01 00:00:00 | f | IBM | same day different IDs
2020-02-01 00:00:00 | C | IBM
2020-02-02 00:00:00 | B | ABC | same ID different dates
2020-02-03 00:00:00 | B | ABC
2020-03-01 00:00:00 | B | ABC
2020-03-01 00:00:00 |  | CNN | blank ID - handling this (i.e. not producing an error) is not essential
2020-03-01 00:00:00 | v | CNN
Spreadsheet: 120906d1315622964-if-function-example
Sheet: Sheet 1 - Table 1

Customer Name | Products | No. of product | Price
ABC | 1 | 89 | US$ 160
DEF | 2 | 70 | US$ 260
GHI | 1 | 140 | US$ 230
JGK | 2 | 188 | US$ 380
TTT | 1 | 300 | US$ 230
ZZZ | 2 | 450 | US$ 380
BBBB | 1 | 640 | US$ 340
QQQQ | 2 | 700 | US$ 570
Green | 1 | 1200 | US$ 600
BBBZOO | 2 | 1011 | US$ 1000
Spreadsheet: 216786d1361888943-d-funtion-and-multiple-criteria-forumla-issue-204-daverage-problem-pivot-table
Sheet: Sheet1

Name | Company | Age
bob | Nestle | 23
anne | Nestle | 21 |  |  |  |  |  |  |  |  |  | Row Labels | Age (Average)
[NAME] | Cadburys | 25 |  |  |  | Company | Age | D-averages |  |  |  | [NAME] | 28
Beverly | [NAME] | 28 |  |  |  | Nestle |  |  |  |  |  | Cadburys | 25
[NAME] | Mars | 32 |  |  |  | Cadburys |  |  |  |  |  | Mars | 33.5
Kelly | Mars | 35 |  |  |  | [NAME] |  |  |  |  |  | Nestle | 22
 |  |  |  |  |  |  |  |  |  |  |  | Grand Total | 27.33333333333333
Spreadsheet: 147385d1332776829-daily-simple-interest-daily-simple-interest
Sheet: Compound

Loan Amount |  | 10000 |  |  |  |  | Daily statement
Annual interest rate % |  | 73 |  | (wow) |  |  | Loan Amount |  |  |  | Current balance
Daily interest rate % |  |  |  |  |  |  | Annual interest rate %
Start date |  | 2012-03-01 00:00:00 |  |  |  |  | Daily interest rate %
Current date |  |  |  |  |  |  | Start date |  |  |  | Total payments made
Days since loan started |  |  |  |  |  |  | Current date
 |  |  |  |  |  |  | Days since loan started
 |  |  |  |  |  |  |  |  |  |  | Total interest charged
Date | Beginning Daily Balance | Daily interest |  | Withdrawn | Payment | Current bal
2012-03-01 00:00:00 |  |  |  | 3000 | 1000
2012-03-02 00:00:00 |  |  |  |  | 250
2012-03-03 00:00:00
2012-03-04 00:00:00
2012-03-05 00:00:00 |  |  |  | 250
2012-03-06 00:00:00
2012-03-07 00:00:00
2012-03-08 00:00:00
2012-03-09 00:00:00
2012-03-10 00:00:00
2012-03-11 00:00:00
2012-03-12 00:00:00
2012-03-13 00:00:00
2012-03-14 00:00:00
2012-03-15 00:00:00
2012-03-16 00:00:00
2012-03-17 00:00:00
2012-03-18 00:00:00
2012-03-19 00:00:00
2012-03-20 00:00:00
2012-03-21 00:00:00
2012-03-22 00:00:00
2012-03-23 00:00:00
2012-03-24 00:00:00
2012-03-25 00:00:00
2012-03-26 00:00:00
2012-03-27 00:00:00
2012-03-28 00:00:00
2012-03-29 00:00:00
Spreadsheet: 854575d1704396027-formula-help-request-pull-in-clean-data-test-2-
Sheet: Sheet2

 | Service Delivery: Service Delivery Name | Delivery Date | Quantity | Unit of Measurement | Program Engagement
 |  | 11/30/2023 | 1 | 1 | [NAME]: LSC Restorative Justice CM
 | [NAME]: Individual Session  - Counseling | 11/7/2023 | 1 | 1 | [NAME]: YSC Counseling
 | [NAME]: Individual Session  - Counseling | 11/29/2023 | 1 | 1 | [NAME]: YSC Counseling
 | [NAME]: Individual Session  - Counseling | 11/1/2023 | 1 | 1 | [NAME]: YSC Counseling
 | [NAME]: Brief CC - Counseling | 11/8/2023 | 1 | 1 | [NAME]: YSC Counseling
 | [NAME]: Brief CC - Counseling | 11/8/2023 | 1 | 1 | [NAME]: YSC Counseling
 | [NAME]: Brief CC - Counseling | 11/8/2023 | 1 | 1 | [NAME]: YSC Counseling
 | [NAME]: Individual Session  - Counseling | 11/8/2023 | 1 | 1 | [NAME]: YSC Counseling
 | [NAME]: Brief CC - Counseling | 11/13/2023 | 1 | 1 | [NAME]: YSC Counseling
 | [NAME] Collateral & Advocacy - Counseling | 11/14/2023 | 1 | 1 | [NAME]: YSC Counseling
Spreadsheet: 329647d1404376012-removed-repeated-charecteristics-with-1-creteria-removed-repeated-charecteristics-with-1-creteria
Sheet: Sheet1

[NAME]
AAA |  | AAA |  | In the Yellow cells the `XXX' to be omitted and the repetaed charecteristics should be plotted once.
AAA |  | BBB |  | `XXX' to be removed
AAA |  | CCC |  | Repetead charectertics should be plotted at only once.
[NAME] |  | DDD
[NAME] |  | EEE |  | How to do this by using formulas ?
[NAME]
AAA
AAA
AAA
BBB
BBB
[NAME]
[NAME]
CCC
DDD
DDD
DDD
EEE
EEE
EEE
EEE
EEE
EEE
EEE
Spreadsheet: 688104d1595573013-vlookup-from-2-different-points-to-return-value-from-different-sheets-sample
Sheet: Print

 |  |  |  |  |  | Truck 01 | Cell g will change all the time to match truck number
 |  |  |  |  |  |  | which will change cell E   if Cell |  |  |  |  |  |  |  | SAMPLE | Monday |  |  |  | SAMPLE | Tuesday
 |  |  |  | carrier
 |  | carrier |  |  |  |  |  |  |  |  |  | Pick day below |  |  |  |  | carrier |  |  |  |  | carrier
 |  |  |  |  |  |  |  |  |  |  |  | Monday |  |  | Truck 01 |  | aaaa |  |  | Truck 01 |  | aaaa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Truck 02 |  | bbbb |  |  | Truck 02 |  | aaaa
 |  |  |  |  |  |  |  |  | day will only change once a day |  |  |  |  |  | Truck 03 |  | aaaa |  |  | Truck 03 |  | aaaa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Truck 04 |  | dddd |  |  | Truck 04 |  | aaaa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Truck 05 |  | rrrrr |  |  | Truck 05 |  | aaaa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Truck 06 |  | aaaa |  |  | Truck 06 |  | aaaa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Truck 07 |  | abc123 |  |  | Truck 07 |  | abc123
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Truck 08 |  |  |  |  | Truck 08
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Truck 09 |  | abc123 |  |  | Truck 09 |  | abc123
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Truck 10 |  | dddd |  |  | Truck 10 |  | dddd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Truck 11 |  |  |  |  | Truck 11 |  | dddd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Truck 12 |  | abc123 |  |  | Truck 12 |  | dddd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Truck 13 |  |  |  |  | Truck 13 |  | dddd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Truck 14 |  | bbbb |  |  | Truck 14 |  | bbbb
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Truck 15 |  |  |  |  | Truck 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Truck 16 |  | aaaa |  |  | Truck 16 |  | abc123
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Truck 17 |  |  |  |  | Truck 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Truck 18 |  | aaaa |  |  | Truck 18 |  | abc123
Spreadsheet: 766783d1644054661-log-book-weekly-accumulation-logbook
Sheet: WS7.2.22

Date | Client | Place | Activity Type | [NAME] | Hrs Type | Hours | Reflection | Competencies
Hrs Type | Previous Cumulative | This Week | Total
CC
CR
CPD
Supervision
Total cumulative hours
Provisional Psychologist Signature: |  |  |  |  |  |  | Date:
Pricipal Supervisor Signature: |  |  |  |  |  |  | Date:
Spreadsheet: 80f39450-3116-4d73-bf67-93b4f6a60548
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
2575 | 14502 | [NAME] | Redman | CAN | 471 | 01:48:18 | 05:56:13 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
2575 | 14768 | [NAME] | Gearing | GBR | 472 | 01:36:52 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 2f686ff4-e089-419d-a8ec-2a39b1d3fcdd
Sheet: Sheet1

Permit No.: | Unnamed: 1 | WQ0000193 | Unnamed: 3 | Facility Name: | Unnamed: 5 | Village of [NAME] | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | County: | Brunswick | Unnamed: 13 | Month: | Unnamed: 15 | Unnamed: 16 | Year: | Unnamed: 18
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050 | 00310 | 00680 | 00940 | 31616 | 00610 | 00620 | 00400 | 70300 | 00530
Day | ORC Arrival Time | ORC Time On Site | Flow | BOD5 | Total Organic Carbon | Chloride | Fecal Coliform | Ammonia | Nitrate | pH | Total Dissolved Solids | Total Suspended Solids
 | 24-hr | hrs | GPD | mg/L | mg/L | mg/L | #/100 mL | mg/L | mg/L | su | mg/L | mg/L
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
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Recorder | Composite | Grab | Grab | Grab | Composite | Grab | Grab | Grab | Composite
Monthly Limit: |  |  | 400000 | 10 |  |  | 14 | 4 |  |  |  | 20
Daily Limit: |  |  |  |  |  |  | 43
Sample Frequency: |  |  | [NAME] | See Permit | 3 x Year | 3 x Year | See Permit | See Permit | 3 x Year | 3 x Year | 3 x Year | See Permit
 |  | Average
 |  | Geomean
 |  | MAX/MIN
Spreadsheet: louise_kitchen__24127__North America Plan 01-02
Sheet: West Power Origination

 | West Power Origination
 | 2002 Plan
 |  |  |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | 2002 |  | % of |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | Plan |  | Total Exp |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  |  |  | Compensation | 0 | 64
 | Special Pays
 | Analysts & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  |  |  | Total
ENAOUTSV | Outside Services |  |  |  |  | 50000
ENASUPP | Supplies Expense |  |  |  |  | 31680
ENAMKTEX | Marketing |  |  |  |  |  |  |  |  | [NAME] | 33600 | 0
ENACONTR | Charitable Contributions |  |  |  |  |  |  |  |  | [NAME] | 52800 | 0
ENARENT | Rent |  |  |  |  |  |  |  |  | Staff | 54000 | 0
ENATECH | Technology |  |  |  |  |  |  |  |  | Specialist | 63000 | 0
ENATRANS | Transportation |  |  |  |  |  |  |  |  | Sr. Specialist | 78000 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  |  | Analyst | 66000 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  |  |  |  | Associate | 97200 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  |  | Manager | 120000 | 5
 |  |  |  |  |  |  |  |  |  | Director | 156000 | 4
 | Headcount |  |  |  |  |  |  |  |  | Sr. Director | 180000 | 0
 |  |  |  |  |  |  |  |  |  | VP | 216000 | 2
 | Analyst & Associate Headcount |  |  |  |  |  |  |  |  | MD | 240000 | 1
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 677322
 |  |  |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 52069d1251779297-spreadsheets-rgp5-south-earthworks-spreadsheet
Sheet: Sheet1

RGP5 South Blast & Excavate Quota - SP16
 | SP16 m3 Rock | Amount/Day Neede | Actual Amount/Day | Daily Excess or Under | Cumulative Excess or Under | Amount Needed Next Day to Meet Quota | Quota Meet This Day | Cumulative Amount | Days Remaining To Acheive Total | Days Remaining To Achieve Target
2009-09-12 00:00:00 | 500 | 500 | 500 |  |  | 0 |  |  |  | 23
2009-09-13 00:00:00 | 1000 | 500 | 555 |  | 55 |  |  |  |  | 22
2009-09-14 00:00:00 | 1500 | 500 | 450 |  |  |  |  |  |  | 21
2009-09-15 00:00:00 | 2000 | 500 | 444 |  |  |  |  |  |  | 20
2009-09-16 00:00:00 | 2500 | 500 | 560 |  |  |  |  |  |  | 19
2009-09-17 00:00:00 | 3000 | 500 | 555 |  |  |  |  |  |  | 18
2009-09-18 00:00:00 | 3500 | 500 | 430 |  |  |  |  |  |  | 17
2009-09-19 00:00:00 | 4000 | 500 | 506 |  |  |  |  |  |  | 16
2009-09-20 00:00:00 | 4500 | 500 | 555 |  |  |  |  |  |  | 15
2009-09-21 00:00:00 | 5000 | 500 | 565 |  |  |  |  |  |  | 14
2009-09-22 00:00:00 | 5500 | 500 | 345 |  |  |  |  |  |  | 13
2009-09-23 00:00:00 | 6000 | 500 | 235 |  |  |  |  |  |  | 12
2009-09-24 00:00:00 | 6500 | 500 | 335 |  |  |  |  |  |  | 11
2009-09-25 00:00:00 | 7000 | 500 | 445 |  |  |  |  |  |  | 10
2009-09-26 00:00:00 | 7500 | 500 | 567 |  |  |  |  |  |  | 9
2009-09-27 00:00:00 | 8000 | 500 | 0 |  |  |  |  |  |  | 8
2009-09-28 00:00:00 | 8500 | 500 | 0 |  |  |  |  |  |  | 7
2009-09-29 00:00:00 | 9000 | 500 | 0 |  |  |  |  |  |  | 6
2009-09-30 00:00:00 | 9500 | 500 | 0 |  |  |  |  |  |  | 5
2009-10-01 00:00:00 | 10000 | 500 | 0 |  |  |  |  |  |  | 4
2009-10-02 00:00:00 | 10500 | 500 | 0 |  |  |  |  |  |  | 3
2009-10-03 00:00:00 | 11000 | 500 | 0 |  |  |  |  |  |  | 2
2009-10-04 00:00:00 | 11500 | 500 | 0 |  |  |  |  |  |  | 1
2009-10-05 00:00:00 | 12000 | 500 | 0 |  |  |  |  |  |  | 0
Spreadsheet: geir_solberg__11245__0413
Sheet: Sheet2

DATE | FERC FILE | SERVICE CUST | HR BEG | HR END | TOTAL HRS | DEL PT | SUPPLY | MW PER HR | TOTAL MW | SCHEDULE ID | SELL PRICE
2001-04-13 00:00:00 |  |  | 1 | 5 | 5 | SP15 | EES | 12 | 60 |  | 70 | SOLD
2001-04-13 00:00:00 |  |  | 6 | 6 | 1 | SP15 | EES | 6 | 6 |  | 70 | SOLD
2001-04-13 00:00:00 |  |  | 7 | 8 | 2 | SP15 | EES | 12 | 24 |  | 120 | SOLD
2001-04-13 00:00:00 |  |  | 17 | 17 | 1 | SP15 | EES | 8 | 8 |  | 65 | SOLD
2001-04-13 00:00:00 |  |  | 18 | 18 | 1 | SP15 | EES | 9 | 9 |  | 65 | SOLD
2001-04-13 00:00:00 |  |  | 19 | 19 | 1 | SP15 | EES | 8 | 8 |  | 65 | SOLD
2001-04-13 00:00:00 |  |  | 20 | 20 | 1 | SP15 | EES | 9 | 9 |  | 65 | SOLD
2001-04-13 00:00:00 |  |  | 21 | 21 | 1 | SP15 | EES | 9 | 9 |  | 65 | SOLD
2001-04-13 00:00:00 |  |  | 22 | 22 | 1 | SP15 | EES | 14 | 14 |  | 65 | SOLD
Spreadsheet: c6c92bf5-d9b9-4165-94f2-3a7d401374e3
Sheet: PAG 23

CONSOLIDATED BALANCE SHEET | December 2011 | December 2010
R$ million
Assets
Current assets
Cash and cash equivalents | 8076.241 | 5909.34
Investment securities (CURRENT) | 193.385 | 1069.276
Trade and other receivables (current) | 3879.65 | 3794.072
Inventories | 2238.517 | 1905.229
Income tax receivable | 291.327 | 181.199
Assets held for sale | 0.4 | 51.833
 | 14679.52 | 12910.949
Non-current assets
Investment securities | 242.106 | 208.742
Trade and other receivables | 1231.992 | 1200.295
Deferred tax assets | 1447.135 | 2021.599
Income tax receivable (non-current) | 16.25 | 0
Employee benefits | 18.506 | 20.923
Investments in associates | 21.681 | 18.502
Property, plant and equipment | 9265.205999999998 | 7032.298
Intangible assets | 1763.034 | 1823.238
Goodwill | 17454.039 | 17441.756
 | 31459.949 | 29767.343
Total assets | 46139.4 | 42678.2
Equity and liabilities
Current liabilities
Trade and other payables | 11288.02 | 7142.943
Interest-bearing loans and borrowings (current) | 2212.078 | 2606.228
Bank overdrafts | 12.306 | 1.041
Income tax and social contribution payable | 793.864 | 701.647
Provisions | 101.645 | 102.996
 | 14407.913 | 10554.7
Non-current liabilities
Trade and other payables (NON CURRENT) | 1196.609 | 1343.367
Interest-bearing loans and borrowings | 1890.208 | 4164.214
Deferred tax liabilities | 734.484 | 548.728
Provisions (non-CURRENT) | 478.418 | 536.073
Employee benefits (non CURRENT) | 1602.95 | 966.221
 | 5902.669 | 7558.603
Total liabilities | 20310.582 | 18113.303
Equity
Issued capital | 8303.936 | 7613.78
Reserves | 17307.384 | 16748.083
Equity attributable to equity holders of AmBev | 25611.32 | 24361.863
Non-controlling interests | 217.525 | 202.979
Total Equity | 25828.845 | 24564.85
Total equity and liabilities | 46139.427 | 42678.14999999999
Spreadsheet: 125678d1319157705-index-and-match-formula-combination-test-complete
Sheet: Sheet1

Customer number | Part number | Quantity | Price
111 | A | 10
222 | B | 11
333 | A | 33
444 | C | 4
555 | D | 54
555 | A | 4
Spreadsheet: mary_hain__25859__IOU04
Sheet: 400 CRAC

 |  |  | Using Rate Case Market Estimate |  |  | Using 42 $/MWh |  | Using $42 and $400 million CRAC
 |  | Load | Price | Market | Benefit in Millions | Market | Benefit in Millions | Price w/CRAC | Market | Benefit in Millions | m/kwh Incr | CRAC share in $ | % share of CRAC
IOU
 | Exchange | 900
 | RL | 1000 | 19.25 | 28.1 |  | 42
Public
 | PF | 5575 | 19.25 | 28.1
 | FPS I&S | 125 | 14.25 | 28.1
DSI
 | IPTAC | 1490 | 23 | 28.1
 |  |  |  | Revenue Subject to CRAC: |  |  |  | million | Benefits
 |  |  |  |  | Rate multiplier
 |  |  |  |  |  | CRAC $ | 400
Spreadsheet: 174857d1345216237-stoked-bar-excel-q-2010
Sheet: Sheet3

line | week | without | with
1 | week 25 | 12.72
 | week 26 | 11.37
 | week 27 | 10.35
 | week 28 | 22.25 | 14.73
 | week 29 | 13.75 | 12.42
 | week 30 | 13.83
 | week 31 | 17.22 | 12.07
2 | week 25 | 11.14
 | week 26 | 12.17 | 10.41
 | week 27 | 16.56 | 15.19
 | week 28 | 16.66 | 12.38
 | week 29 | 23.71 | 22.15
 | week 30 | 15.96
 | week 31 | 10.52 | 9.06
Spreadsheet: 0e70cec7-51f5-481d-be09-e9b3a2a0cd16
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
CATLN | Test | CATLN | Calcitonin, Fine-Needle Aspiration Biopsy (FNAB)-Needle Wash, [NAME] | Calcitonin, FNAB, [NAME] | Immunoenzymatic Assay |  |  |  | 1.5 | mL | Container/Tube: Plain, plastic, screw-top tube [NAME]: 1.5 mL Collection Instructions: After collection of the cytology specimens and expulsion of the material for smear or CytoTrap, process as follows: 1. Wash/rinse each FNA needle from a single biopsied area with 0.1 to 0.5 mL of normal saline.  2. Pool each wash from a single biopsied area into 1 vial. The washes from a biopsied area are pooled (final volume 1-1.5 mL). If more than 1 area is biopsied, each biopsy area should be submitted as a separate specimen, under a separate order. 3. Inspect the specimen as follows: a. If the specimen shows visible blood or tissue contamination, centrifuge the specimen, transfer the supernatant to a new plastic vial, and freeze. b. If specimen is clear, freeze specimen in plastic vial. [NAME] should be frozen within 2 to 4 hours of collection. | 1 mL (Samples <1 mL may be rejec | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold reject Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Monday through Friday; Varies | Same day/1 day | 3 days | 1 | 82308 |  |  |  |  | Rochester
CATLN | [NAME] | FNWASH | Fine Needle Wash |  |  |  | Frozen | 7 days
CATLN | Result | CATL | Calcitonin, FNAB, [NAME] | Calcitonin, FNAB, [NAME] | Numeric |  |  |  |  | pg/mL |  |  |  |  |  |  |  |  |  | In Process
CATLN | Result | SITEB | Site | Site | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39111-0 | Body site:[NAME]:Pt:^Patient:Nom:
Spreadsheet: 740169d1626205965-how-to-auto-populate-information-from-one-tab-to-the-other-moveuniquevalues-1-
Sheet: Sheet7

Result |  | Cl Seen | # of Self Pay | # of Units | Rate | Total | Need to Follow Up
 |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  | 10
Spreadsheet: 88537d1288344224-vba-to-group-rows-uat-dashboard-2010-wip2
Sheet: Data

 |  | JOB AREAS | TOTAL | SMALL | MEDIUM | LARGE | X LARGE | SUPER
 |  | MOTOR | 40 | 17 | 8 | 10 | 4 | 1
 |  | HOUSEHOLD | 7 | 2 | 0 | 2 | 2 | 1
 |  | COMMERCIAL | 5 | 2 | 1 | 2 | 0 | 0
 |  | GENERAL | 12 | 6 | 1 | 4 | 1 | 0
 | JOB SIZE | AVERAGE T/ARND
 | All | 24.78125
 | Small | 3.962962962962963
 | Medium | 15.25
 | Large | 35.76470588235294
 | X-Large | 66.14285714285714
 | Super | 121.5
SMALL (0 - 10 days)
MEDIUM (11 - 20 days)
LARGE  (21 - 50 days)
X LARGE (51 - 99 days)
SUPER (100 + days)