tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 833100d1686786530-formula-to-calculate-capital-gain-loss-share-holdings-by-value-sample
Sheet: Summary

Share Holdings by Value
Share Code | Platform | Country | Type | Allocation | Date | Qty | Price | Allocation | Date | Qty | Price | Allocation | Date | Qty | Price | Allocation | Date | Qty | Price | Allocation | Date | Qty | Price | Allocation | Date | Qty | Price | Allocation | Date | Qty | Price | Allocation | Date | Qty | Price | Allocation | Date | Qty | Price | Total Holding | Average Price | Capital Gain/Loss 2022-2023 Tax Year | Capital Gain/Loss 2023-2024 Tax Year
BRN | CMC | Australia | Equity | Purchase | 2022-01-25 00:00:00 | 1500 | 1.4 | Sale | 2023-05-29 00:00:00 | -1500 | 0.46
EYPT | Interactive | USA | Equity | Purchase | 2023-04-28 00:00:00 | 27 | 6.25 | Purchase | 2023-04-28 00:00:00 | 80 | 6.1 | Sale | 2023-05-12 00:00:00 | -107 | 6.28
TNYA | Interactive | USA | Equity | Purchase | 2023-04-28 00:00:00 | 150 | 5.04 | Sale | 2023-05-24 00:00:00 | -100 | 6.9 | Sale | 2023-06-01 00:00:00 | -50 | 6.95
BYND | Tradestation | USA | Equity | Purchase | 2021-09-20 00:00:00 | 10 | 110 | Sale | 2023-05-11 00:00:00 | -10 | 11.16
CIFR | Interactive | USA | Equity | Purchase | 2023-05-23 00:00:00 | 200 | 2.48 | Sale | 2023-06-06 00:00:00 | -200 | 2.17
APLD | Interactive | USA | Equity | Purchase | 2023-05-23 00:00:00 | 50 | 8.26 | Purchase | 2023-06-01 00:00:00 | 50 | 8.2 | Purchase | 2023-06-03 00:00:00 | 50 | 0.3478260869565217 | Sale | 2023-06-05 00:00:00 | -80
AI | Interactive | USA | Equity | Purchase | 2023-05-30 00:00:00 | 20 | 38.5 | Sale | 2023-05-30 00:00:00 | -20 | 36.82
Spreadsheet: 142901d1330081325-show-sumif-data-within-other-file-without-opening-it-picking-list-template-2
Sheet: Sheet3

Project Picking List
Contract | N16000
Site | RTU PROJECT
PO Number | SUPPLIER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unique | Qty Taken | Qty Requested
120526 | R.Sthal | 1 |  | 1 |  | 2 x 18W Eexe Luminaire |  |  |  |  |  |  |  | 320.14 | 320.14 | 0.35 | 208.091 |  |  |  | 1 | 1
120526 | R.Sthal | 2 |  | 1 |  | CEILING CLIP BRACKET (PAIR) |  |  |  |  |  |  |  | 18.13 | 18.13 |  | 18.13 |  |  |  | 1 | 1
120526 | R.Sthal | 3 |  | 5 |  | 8030/51-033 |  |  |  |  |  |  |  | 103.1 | 515.5 | 0.35 | 335.075 |  |  |  | 3 | 3
120539 | Cleveland | 1 |  | 2 |  | 32mm E1FW gland + shroud + hardware (Pack of 2) |  |  |  |  |  |  |  | 20.11 | 40.22 |  | 40.22 |  |  |  | 2 | 2
120539 | Cleveland | 2 |  | 100 |  | 2x2x24/0.2 PT2 TY1, O/SCR black BS5308 |  |  |  |  |  |  |  | 0.55 | 55.00000000000001 |  | 55.00000000000001 |  |  |  | 99 | 99
120531 | Euro | 1 |  | 200 |  | LNGF106.4/06.4PP |  |  |  |  |  |  |  | 0.69 | 138 | 0 | 138 |  |  |  | 1 | 1
120531 | Euro | 2 |  | 50 |  | LN209.5PP |  |  |  |  |  |  |  | 0.36 | 18 | 0 | 18 |  |  |  | 2 | 2
Spreadsheet: 777076d1650123502-pull-data-from-multiple-sheets-floor-stock-sheets-template
Sheet: Nuclear Medicine Cardio 2004131

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Service Units
Item | Price | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu
Coke | 0.56
diet Coke | 0.56
Sprite | 0.56
Diet Sprite | 0.56
Dr. [NAME] | 0.56
Diet Dr. Pepper | 0.56
Bottled Water | 0.14
Crackers, [NAME] | 0.08
[NAME] ea | 0.05
Peanut Butter Crackers | 0.25
Juice Orange | 0.23
Juice Apple | 0.23
[NAME] | 0.16
Ensure | 0.14
Water | 0.14
 | 0.25
Plastic Ware (fork,spoon knife)
Monthly Total
Spreadsheet: 127439d1320347115-distribute-work-hours-when-the-required-work-hrs-are-more-than-available-work-hrs-work-allocation
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Work Item Type | Qty of Items to be actioned | Time needed to action one item | Total Time Required | Weitage on Worktype | Actual number of items that can be can be actioned
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | 25 | 0:01:00 |  | 0.6 | Help!
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | 25 | 0:01:00 |  | 0.25 | Help!
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C | 25 | 0:01:00 |  | 0.1 | Help!
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D | 25 | 0:01:00 |  | 0.05 | Help!
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Actual time available |  | 1:00:00
Spreadsheet: 757464d1638280738-currency-formats-and-spilled-lists-currency-formats-and-spilled-lists
Sheet: Sheet1

Stock | Ticker | Stock Exchange | Units | Price | Currency | Transaction Amount
#[NAME]! |  |  | 10
#[NAME]! |  |  | 10
#[NAME]! |  |  | 10
#[NAME]! |  |  | 1
#[NAME]! |  |  | 10
#[NAME]! |  |  | 10 |  |  |  |  |  | 1) How can I have a conditional format that changes the $ to a £ for GBp stocks?
 |  |  |  |  |  |  |  |  | 2) Then, when the total reports pounds, how can this be changed to pence i.e. £1,380 NOT £13,800?
 |  |  |  |  |  |  |  |  | 3) Finally, if I have this in a spilled list instead of a table, how would I do 1) and 2) above?
 |  |  |  |  |  | This column multiplies the units (Col D) by the Unit Price (Col E)
Spreadsheet: 271326d1381913423-countifs-a-b-c-or-d-ab-testing-stats-master
Sheet: Android

Android | Geek Culture |  |  | Science & Research |  |  | Personal/Opinion |  |  | Historic |  |  | AppStore Rating |  |  | Quotation |  |  | Anecdote/Fact |  |  | Question |  |  | App's Success |  |  | Country Specific |  |  | Endorsement |  |  | Love/Sex
 | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | %
Canada
UK
Australia
Germany
Russia
France
Sweden
Spain
Italy
Netherlands
Norway
Denmark
Korea
Turkey
Japan
Finland
Spreadsheet: 695083d1600039328-vlookup-based-on-the-results-exam-vlookup-formula
Sheet: Sheet1

 | STUDENT RESULT
 | SUBJECT | MATH |  | SCIENCE |  | ART |  | ECONOMIC |  | COMPUTER |  | BIOLOGY |  | PHYSIC |  | CHEMISTRY
 | SCORE / GRED | M | G | M | G | M | G | M | G | M | G | M | G | M | G | M | G
 |  | 100 | A | 80 | A | 70 | B | 40 | D | 65 | C | 95 | A | 83 | A | 67 | C
 | CRITERIA CLASS |  |  |  |  |  |  |  | YOUR CLASS 2021
 | CLASS |  | SUBJECT |  | MINIMUM GRED |  |  |  | T4
 | SCIENCE STREAM |  | MATH |  | B
 |  |  | PHYSIC |  | A
 |  |  | BIOLOGY |  | A
 |  |  | CHEMISTRY |  | A
 | ECONOMY |  | MATH |  | B
 |  |  | SCIENCE |  | C
 |  |  | ECONOMIC |  | A
 |  |  | ART |  | C
 |  |  | COMPUTER |  | B
 | LITERATURE |  | ART |  | A
 |  |  | SCIENCE |  | D
 |  |  | COMPUTER |  | C
 |  |  | MATH |  | B
 |  |  | PHYSIC |  | C
Spreadsheet: mary_fischer__25630__1581 - 2001
Sheet: E12.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
ANALYSIS OF LONG-TERM DEBT
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  |  |  |  |  |  |  |  |  | ** Credit Positive Liability  (Debit Negative Liability) **
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-12
 |  |  |  |  |  |  |  | ORIGINAL |  | BEGINNING BALANCE |  |  |  |  |  |  |  |  |  | OTHER (NON-CASH) |  |  |  | ENDING BALANCE
PAYEE AND [NAME] |  | HYPERION |  | DUE |  | INTEREST |  | AMOUNT |  | CURRENT |  | LONG-TERM |  |  |  | ADDITIONS |  | RETIREMENTS |  | AMOUNT |  | [NAME] |  | CURRENT |  | LONG-TERM
 |  | ACCOUNT |  | DATE |  | RATE |  | AUTHORIZED |  | PORTION |  | PORTION |  | TOTAL |  | DR (CR) |  | DR (CR) |  | DR (CR) |  |  |  | PORTION |  | PORTION |  | TOTAL
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Current:
Current Maturities of Long-Term Debt * |  | 0450 |  |  |  | 0
Notes Payable - Other |  | TOT_NP_OTHER |  | 2001-03-01 00:00:00 |  | 0.085
Total Short-Term
Long-Term:
Long-Term Debt (Hyperion Accts. 0705, 0770)
Notes (list by name of payee or issue):
 |  |  |  |  |  | 0.085
Total (Hyperion Accts 0705 & 0770)
Current Maturities of L/T Debt (Contra) * |  | 0775
Unamortized Premium on L/T Debt |  | 0765
Total Long-Term Debt
Total Debt  DR/(CR)
!!DO NOT INCLUDE INTERCOMPANY DEBT!!
*  HYPERION ACCOUNTS 0450 & 0775 MUST BE THE SAME AMOUNT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-12
 |  |  |  | Income Accts:  (DR)/CR Reverse signs from Hyperion
 |  |  |  |  |  |  | Income Accts: (DR)/CR  Reverse signs from Hyperion
Spreadsheet: 773058d1647599811-copying-multiple-comments-to-one-box-comments-issue
Sheet: Input

 | 1 | Comment 1
 | 2 | comment 2
 | 3 | Comment 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
Spreadsheet: 846113d1697433446-countifs-with-wildcards-tempcountifs
Sheet: Data

DATA |  |  |  |  |  | Summary
Date | Character | Lessons_Abs | Code |  |  | Date | Character | Count
2023-02-20 00:00:00 | 4 | 1 | RAD |  |  | 2023-02-20 00:00:00 | H | 4
2023-02-20 00:00:00 | 6 | 1 | RAD |  |  | 2023-02-20 00:00:00 | 1 | 4
2023-02-20 00:00:00 | H 1 2 | 2.2 | RAD |  |  | 2023-02-20 00:00:00 | 2 | 4
2023-02-20 00:00:00 | H 1 2 3 4 5 6 | 6.2 | RAD |  |  | 2023-02-20 00:00:00 | 3 | 3
2023-02-20 00:00:00 | H 1 2 3 4 5 6 | 6.2 | RAD |  |  | 2023-02-20 00:00:00 | 4 | 4
2023-02-20 00:00:00 | H 1 2 3 4 5 6 | 6.2 | RAD |  |  | 2023-02-20 00:00:00 | 5 | 3
2023-06-15 00:00:00 | H 1 2 3 4 5 6 | 6.2 | RAD |  |  | 2023-02-20 00:00:00 | 6 | 4
2023-06-15 00:00:00 | H 1 2 3 4 5 6 | 6.2 | RAD
2023-06-15 00:00:00 | H 1 2 3 4 5 6 | 0 | RAD
2023-02-08 00:00:00 | 5 6 | 2 | LAL
2023-03-09 00:00:00 | H 1 2 3 4 5 6 | 6.2 | LAL
Spreadsheet: 861561d1709448689-how-to-use-reverse-writing-of-numbers-from-top-to-bottom-pp1-aligw
Sheet: Sheet1

1 |  | 10
2 |  | 9 |  | 9 |  | 9
3 |  | 8 |  | 8 |  | 8
4 |  | 7 |  | 7 |  | 7
5 |  | 6 |  | 6 |  | 6
6 |  | 5 |  | 5 |  | 5
7 |  | 4 |  | 4 |  | 4
8 |  | 3 |  | 3 |  | 3
9 |  | 2 |  | 2 |  | 2
10 |  | 1 |  | 1 |  | 1
Spreadsheet: 664eed05-33ec-4e28-b687-16f21bc46e15
Sheet: Sheet1

PRESIDENTIAL PRIMARY | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
1996-02-20 00:00:00
[NAME]
 | Republican |  |  |  | Democratic |  |  |  | Libertarian
Rockingham County | Regular | Absentee | Total |  | Regular | Absentee | Total |  | Regular | Absentee | Total
Atkinson | 1260 | 52 | 1312 |  | 360 | 13 | 373 |  | 11 | 0 | 11
Auburn | 1007 | 31 | 1038 |  | 384 | 8 | 392 |  | 6 | 0 | 6
Brentwood | 542 | 28 | 570 |  | 196 | 10 | 206 |  | 4 | 0 | 4
Candia | 990 | 40 | 1030 |  | 288 | 8 | 296 |  | 16 | 0 | 16
Chester | 830 | 17 | 847 |  | 193 | 2 | 195 |  | 12 | 0 | 12
Danville | 495 | 8 | 503 |  | 208 | 1 | 209 |  | 10 | 1 | 11
[NAME] | 824 | 48 | 872 |  | 230 | 8 | 238 |  | 13 | 0 | 13
[NAME] | 4710 | 130 | 4840 |  | 1498 | 32 | 1530 |  | 49 | 0 | 49
East Kingston | 362 | 22 | 384 |  | 110 | 4 | 114 |  | 1 | 0 | 1
Epping | 847 | 31 | 878 |  | 319 | 7 | 326 |  | 3 | 0 | 3
Exeter | 2708 | 215 | 2923 |  | 968 | 50 | 1018 |  | 8 | 0 | 8
Fremont | 588 | 14 | 602 |  | 144 | 0 | 144 |  | 9 | 0 | 9
Greenland | 670 | 20 | 690 |  | 231 | 3 | 234 |  | 4 | 0 | 4
Hampstead | 1475 | 59 | 1534 |  | 441 | 8 | 449 |  | 11 | 0 | 11
Hampton | 2566 | 184 | 2750 |  | 1271 | 65 | 1336 |  | 11 | 0 | 11
[NAME] | 525 | 41 | 566 |  | 111 | 2 | 113 |  | 3 | 0 | 3
Kensington | 363 | 11 | 374 |  | 122 | 4 | 126 |  | 3 | 0 | 3
Kingston | 1145 | 77 | 1222 |  | 350 | 13 | 363 |  | 19 | 0 | 19
[NAME] | 4126 | 89 | 4215 |  | 1175 | 25 | 1200 |  | 46 | 5 | 51
New Castle | 265 | 19 | 284 |  | 127 | 0 | 127 |  | 3 | 0 | 3
Newfields | 300 | 4 | 304 |  | 94 | 3 | 97 |  | 2 | 0 | 2
Newington | 197 | 20 | 217 |  | 61 | 5 | 66 |  | 0 | 0 | 0
Newmarket | 1119 | 35 | 1154 |  | 705 | 16 | 721 |  | 16 | 0 | 16
Newton | 538 | 20 | 558 |  | 210 | 6 | 216 |  | 7 | 0 | 7
[NAME] | 1010 | 75 | 1085 |  | 334 | 14 | 348 |  | 6 | 0 | 6
Northwood | 648 | 43 | 691 |  | 175 | 5 | 180 |  | 8 | 0 | 8
[NAME] | 586 | 35 | 621 |  | 257 | 3 | 260 |  | 7 | 0 | 7
Plaistow | 1114 | 35 | 1149 |  | 334 | 7 | 341 |  | 8 | 0 | 8
Portsmouth Ward 1 | 338 | 13 | 351 |  | 363 | 14 | 377 |  | 5 | 0 | 5
Portsmouth Ward 2 | 556 | 53 | 609 |  | 557 | 79 | 636 |  | 8 | 0 | 8
Portsmouth Ward 3 | 342 | 52 | 394 |  | 296 | 25 | 321 |  | 3 | 0 | 3
Portsmouth Ward 4 | 842 | 70 | 912 |  | 505 | 30 | 535 |  | 2 | 0 | 2
Portsmouth Ward 5 | 667 | 52 | 719 |  | 560 | 48 | 608 |  | 8 | 0 | 8
[NAME] | 1485 | 45 | 1530 |  | 600 | 11 | 611 |  | 29 | 0 | 29
Rye | 1203 | 159 | 1362 |  | 450 | 23 | 473 |  | 16 | 1 | 17
Salem | 3629 | 130 | 3759 |  | 2175 | 72 | 2247 |  | 27 | 0 | 27
Sandown | 811 | 26 | 837 |  | 275 | 4 | 279 |  | 14 | 0 | 14
Seabrook | 948 | 48 | 996 |  | 467 | 16 | 483 |  | 10 | 0 | 10
[NAME] | 138 | 14 | 152 |  | 52 | 5 | 57 |  | 0 | 0 | 0
Stratham | 1423 | 73 | 1496 |  | 419 | 7 | 426 |  | 13 | 0 | 13
Windham | 2017 | 78 | 2095 |  | 555 | 24 | 579 |  | 22 | 0 | 22
Totals | 46209 | 2216 | 48425 |  | 18170 | 680 | 18850 |  | 453 | 7 | 460
Spreadsheet: 807662d1669991872-creating-model-from-data-sample-forecastingtest-rhino10-
Sheet: Sheet1

Project A Data Set | 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
Revenue | 1000 | 2000 | 3000 | 4000 | 5000 | 6000 | 7000 | 8000 | 9000 | 10000 | 11000 | 12000 | 13000 | 14000 | 13000 | 12000 | 11000 | 10000 | 9000 | 8000 | 7000 | 6000 | 5000 | 4000 | 3000 | 2000 | 1000 | 500
Percentage
Percentage Sum
 | [NAME] from Data Sample (excelforum.com)
Model for Forecasting | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
Revenue |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60000
Percentage
Percentage Sum
[NAME] value
median month(s)
ratio (guess) | 0.8323829471218892
total percentage sum
total revenue
Spreadsheet: 850884d1701195987-using-conditional-formatting-to-highlight-like-numbers-or-opposite-numbers-stock-short-term-comparison-23-lar9149-
Sheet: Sheet1

First #
Second #
Match first #
Match second #
Opposite first #
Opposite second #
 |  |  |  |  | 1234X2cl..12..34t |  |  |  |  |  |  |  | a t6=4,t8=5,..b t4=5,t6=7,t9=3,
 | 1/2e | 0/1e | 3e | -2e |  | -4/-3e |  | -3/0a
 | 1 ext | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
 | 0 | 0 | 1 | 0 | 1 | 0 | 2 | 0 | 3 | 1 | 2 | 0 | 1 | 2 | 4
 | 0 | 0 | 1 | 0 | 1 | 0 | 3 | 1 | 4 | 1 | 3 | 1 | 2 | 4 | 6
 | 0 | 0 | 1 | 0 | 2 | 0 | 4 | 2 | 4 | 1 | 4 | 2 | 3 | 7 | 10
 | 0 | 0 | 1 | 0 | 3 | 0 | 5 | 2 | 5 | 4 | 6 | 6 | 6 | 11 | 15
 | 0 | 0 | 1 | 0 | 3 | 0 | 6 | 2 | 5 | 6 | 10 | 10 | 11 | 16 | 20
 | 0 | 0 | 1 | 0 | 3 | 0 | 6 | 2 | 5 | 6 | 10 | 11 | 11 | 17 | 21
 | 0 | 0 | 1 | 0 | 4 | 0 | 7 | 2 | 6 | 7 | 11 | 12 | 12 | 18 | 22
Spreadsheet: 59889d1260408943-generate-a-master-worksheet-from-individual-worksheets-rc1272
Sheet: RateSheet

PROVIDER NAME: | South Island |  |  | File Name: | RC1272
PROVIDER NUMBER: | RC1272 |  |  | Tab: | RateSheet
REPORTING PERIOD: | 7/1/2008 - 6/30/2009 |  |  | Pprd By: | PR
OSS/IPC RESIDENT DAYS: | 1000 |  |  |  | OSS/IPC % OCC: | 0.08561643835616438
TOTAL RESIDENT DAYS: | 12025 |  |  |  | TOTAL % OCC: | 1.029537671232877
TOTAL PROVIDER BEDS: | 32 |  |  |  | OSS/IPC to TOTAL: | 0.08316008316008315
TOTAL ALLOWABLE DAYS | 11680 | Verify Days
 |  |  | IPC
SUMMARY OF PROVIDER'S REPORTED INCOME, COSTS and PER PATIENT DAY COSTS
 | AS FILED | DEBITS | CREDITS |  | ADJUSTED | PER DIEM
INCOME | 414639 | 0 | 151679 |  | 566318 | 47.09505197505197
Operating Expenses
ADMINISTRATION | 43139 | 0 | 0 |  | 43139 | 3.587442827442827
RESIDENT CARE & ACTIVITY | 121030 | 0 | 0 |  | 121030 | 10.06486486486486
DIETARY | 61874 | 0 | 0 |  | 61874 | 5.145446985446985
LAUNDRY, HSKPG & MAINT | 35259 | 0 | 0 |  | 35259 | 2.932141372141372
UTILITIES | 29431 | 0 | 0 |  | 29431 | 2.447484407484407
TAXES, INSUR, & LICEN | 26022 | 0 | 0 |  | 999 | 0.08307692307692308
COST OF CAPITAL | 71413 | 0 | 0 |  | 71413 | 5.938711018711019
SUBTOTAL | 388168 | 0 | 0 |  | 363145 | 30.1991683991684
OTHER | 460 | 0 | 0 |  | 460 | 0.03825363825363826
TOTAL EXPENSES | 388628 | 0 | 0 |  | 363605 | 30.23742203742204
NET INCOME/(LOSS) | 26011 | 0 | 151679 |  | 202713 | 16.85762993762994
 |  |  |  |  | 177690
Spreadsheet: 137011d1326910131-formula-calculation-problem-help-needed-please-excel-calculation-help-khalid-solution
Sheet: Sheet1

 |  |  | 2012-01-01 00:00:00 |  |  |  | 2012-02-01 00:00:00 |  |  |  | 2012-03-01 00:00:00 |  |  |  | 2012-04-01 00:00:00
 | VOLUME | CURR | CHARGE |  | VOLUME | CURR | CHARGE |  | VOLUME | CURR | CHARGE |  | VOLUME | CURR | CHARGE
 | 50 | GBP | 6186 |  | 24 | GBP | 3688 |  | 50 | GBP | 5241 |  | 47 | GBP | 961
 | 76 | GBP | 2271 |  | 100 | GBP | 3526 |  | 74 | GBP | 8010 |  | 20 | GBP | 8844
 | 35 | GBP | 9139 |  | 77 | GBP | 1027 |  | 64 | GBP | 6824 |  | 17 | GBP | 3202
 | 95 | GBP | 8590 |  | 34 | GBP | 5012 |  | 39 | GBP | 8970 |  | 63 | GBP | 9320
 | 74 | GBP | 6569 |  | 39 | GBP | 7944 |  | 12 | GBP | 7638 |  | 90 | GBP | 792
 | 71 | GBP | 7686 |  | 3 | GBP | 8971 |  | 85 | GBP | 2461 |  | 3 | GBP | 2972
 | 57 | GBP | 2949 |  | 3 | GBP | 8350 |  | 18 | GBP | 7133 |  | 57 | GBP | 3277
 | 74 | GBP | 3075 |  | 20 | GBP | 5938 |  | 76 | GBP | 8707 |  | 64 | GBP | 6458
 | 84 | GBP | 1995 |  | 11 | GBP | 5321 |  | 68 | GBP | 4517 |  | 69 | GBP | 1769
 | 14 | GBP | 6249 |  | 69 | GBP | 5978 |  | 77 | GBP | 2832 |  | 80 | GBP | 8901
 | 4 | GBP | 707 |  | 6 | GBP | 4498 |  | 48 | GBP | 8223 |  | 45 | GBP | 4987
 | 35 | GBP | 4018 |  | 71 | GBP | 9278 |  | 31 | GBP | 3901 |  | 22 | GBP | 9257
 |  |  | 59434 |  |  |  | 69531
Enter month in yellow cell
2012-02-01 00:00:00
 |  | YTD Charge |  | Q1 Charge
 |  | I need the calculation to calculate the total charge up to and including the month specified in cell A19.
 |  | e.g. Id Mar-12 is entered then calculation adds up Jan, Feb and Mar. If [NAME] is entered then only Jan-12 is calculated
Spreadsheet: 210102d1359382027-data-validation-fromn-two-different-named-range-alternatives-dummy-for-help1
Sheet: Sheet 1

 | 2013 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  | AA
 |  | BB
 |  | CC
 |  | DD
 |  | EE
 |  | FF
 |  | GG
 |  | HH
Spreadsheet: 9fd3dd05-a3c3-4b06-b886-fcdbc92f0782
Sheet: 3.3

Cuadro 3.3
[NAME]
Matrimonios registrados por grupos [NAME] del contrayente, según grupos [NAME], 2010
Grupos de edad de la contrayente | Grupos de edad del contrayente
 | Menor de 15 años | 15-19 | 20-24 | 25-29 | 30-34 | 35-39 | 40-44 | 45-49 | 50  y más | No especificado
Total País
Menor de 15 años |  | 3 | 5 | 1 | 1 | 0 | 1 | 0 | 1 | 0
15-19 |  | 173 | 1117 | 699 | 298 | 131 | 52 | 34 | 37 | 2
20-24 |  | 187 | 2753 | 3379 | 1559 | 665 | 318 | 201 | 207 | 4
25-29 |  | 54 | 974 | 3471 | 2702 | 1253 | 630 | 332 | 404 | 7
30-34 |  | 24 | 318 | 1033 | 2157 | 1934 | 949 | 489 | 556 | 4
35-39 |  | 7 | 114 | 356 | 792 | 1387 | 1216 | 644 | 646 | 2
40-44 |  | 3 | 54 | 141 | 338 | 487 | 952 | 781 | 902 | 1
45-49 |  | 3 | 21 | 58 | 121 | 218 | 349 | 532 | 1067 | 1
50  y más |  | 1 | 20 | 49 | 82 | 122 | 239 | 288 | 2221 | 3
No especificado |  | 0 | 17 | 31 | 22 | 13 | 10 | 9 | 20 | 338
Nota: Elaborado con datos registrados en las oficialías del estado civil. Junta Central Electoral
Fuente: Oficina Nacional de Estadística, (ONE)
Spreadsheet: 49669d1249006702-single-vs-mutiple-entry-sheets-testing
Sheet: Sheet2

Alphabets | Numbers
A | 1
A | 2
A | 3
B | 1
B | 2
B | 3
C | 1
C | 2
C | 3
D | 1
E | 2
E | 3
F | 2
F | 3
F | 1
Spreadsheet: 809842d1671370944-how-to-only-show-data-on-page-soa-mo-10-lf-there-is-data-in-gl-mo-10-oktober-2022-nuut-01
Sheet: SOA MO 12

Statement of Activity
 | Cash Beginning of Period
 | Revenue:
 |  | Total Revenue:
 | Expenses:
 |  | Total Expenses:
 | Net : Income Gain / (Loss)
 | Cash End of Period
Spreadsheet: 825564d1681397095-pull-data-from-one-sheet-to-another-from-last-data-entered-in-a-column-and-the-12-24-above-ak-sample3
Sheet: XX-XX-XX

 | ANIMAL KINGDOM |  |  |  |  |  | unlock 1111 |  |  |  |  |  |  | combo
Well No. | 12H | 13H | 14H | 15H | Total |  |  |  |  |  |  |  |  | combo
Start Date: |  |  |  |  |  |  |  |  |  |  |  |  |  | combo
Online/Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  | combo
Choke |  |  |  |  |  |  |  |  |  |  |  |  |  | lt f
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | lt p
Casing PSI |  |  |  |  |  |  | Copy and paste table into email body |  |  |  |  |  |  | fork
Surface Csg |  |  |  |  |  |  |  |  |  |  |  |  |  | lift
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | trash
Water / Day |  |  |  |  |  | Clear | enter water totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | ft
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | ft
Oil / Day |  |  |  |  |  |  | enter oil totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | plug C
[NAME] to sales |  |  |  |  |  |  |  |  |  |  |  |  |  | plug C
Gas / Day |  |  |  |  |  |  | enter gas totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | plug C
Inj / Day | off | off | off | off |  |  |  |  |  |  |  |  |  | st
 |  |  |  |  |  |  |  |  |  |  |  |  |  | st
Yesterday Lact |  |  |  |  |  |  |  |  |  |  |  |  |  | st
Comments |  |  |  |  |  |  | gfhghcghghgvhvgvgvhgvhvghvgvgh
 | PM
 | 7 | 8 | 9
GAS
WATER
OIL
 | AM |  |  |  |  |  | lact total
 | 7 | 8 | 9 |  |  |  | 0430 | 24 b4 |  |  |  |  | IF(g28-h28<0,0,g28-h28)
GAS |  |  |  |  |  | 750
WATER |  |  |  |  |  | 760
OIL |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  | 0
Spreadsheet: 9bf9e8fc-b756-4c66-845d-785015a77293
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
FAMYS | Test | FAMYS | Amylase, Isoenzymes | Amylase Isoenzymes | Quantitative Enzymatic | Serum Gel Tube: SGT |  |  | 1 | mL | Submit only 1 of the following specimens:   Serum  Draw blood in a plain, red-top tube(s). (Serum gel tube is acceptable.) Spin down and send 1 mL of serum refrigerated in a plastic vial.   [NAME] blood in a green-top (sodium or lithium heparin) tube(s). Spin down and send 1 mL plasma refrigerated in a plastic vial. | 0.5 mL | Hemolysis:	Mild reject; Gross reject Thawing:	Warm reject; Cold OK Lipemia:	NA Icterus:	NA Other:	Body fluids | Pancreatic amylase 6-35 months:  2-28 U/L 3-6 years:  8-34 U/L 7-17 years:  9-39 U/L     18 years and older: 12-52 U/L   Salivary amylase   18 months and older:  9-86 U/L   Total amylase 3-90 days:  0-30 U/L 3-6 months:  7-40 U/L 7-8 months:  7-57 U/L 9-11 months:  11-70 U/L 12-17 months:  11-79 U/L 18-35 months:  19-92 U/L       3-4 years:  26-106 U/L   5-12 years:  30-119 U/L            13 years and older:  30-110 U/L     Test Performed By:    ARUP Laboratories                                 500 [NAME]                                 Salt Lake City, UT  84108 | Sunday through Saturday | 1 day | 3-5 days | 2 | 82150 |  |  |  |  | ARUP Laboratories
FAMYS | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 30 days
FAMYS | Result | Z2611 | Pancreatic Amylase Isoenzyme | Pancreatic Amylase Isoenzyme | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FAMYS | Result | Z2612 | Salivary Amylase Isoenzyme | Salivary Amylase Isoenzyme | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FAMYS | Result | [NAME] | Total Amylase For Isoenzymes | Total Amylase For Isoenzymes | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 60005d1260530022-vlookup-price_list
Sheet: Sheet1

Currently
A004 | 1.75 | 5.95 |  |  |  |  |  |  |  |  |  | A004 | 1.85 | 6.05
A005 | 1.65 | 5.61 |  |  |  |  |  |  |  |  |  | A005 | 1.75 | 5.81
A006 | 1.79 | 6.09 |  |  |  |  |  |  |  |  |  | A006 | 1.89 | 6.29
A007 | 2.25 | 7.65 |  |  |  |  |  |  |  |  |  | A007 | 2.35 | 7.85
Would like
A004 | 1.85 | 6.05
A005 | 1.75 | 5.81
A006 | 1.89 | 6.29
A007 | 2.35 | 7.85
A004
A005
A006
A007
 | or
A004
A005
A006
A007