tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 848286d1699028758-3rd-syntax-issue-sf_080141
Sheet: R

 | Sheet Name > | MAS
 |  |  |  |  |  |  |  |  |  | Poland |  | 5263 |  |  |  |  |  | 94560
 | Sunflower |  |  |  |  |  |  |  |  | Poland |  | 6523 |  |  |  |  |  | 50000
 | Sunflower |  |  |  |  |  |  |  |  | Poland |  | 326 |  |  |  |  |  | 2453.35
 | Polemonium |  |  |  |  |  |  |  |  | Poland |  | 44 |  |  |  |  |  | 4200
 | #Oman flower. |  |  |  |  |  |  |  |  | Mexico |  | 456.44 |  |  |  |  |  | 5236
 | Sunflower |  |  |  |  |  |  |  |  | Mexico |  | 66 |  |  |  |  |  | 512300
 | [NAME] |  |  |  |  |  |  |  |  | Mexico |  | 966 |  |  |  |  |  | 3250
 | #Oman flower. |  |  |  |  |  |  |  |  | Portugal |  | 634.2 |  |  |  |  |  | 3000
 | [NAME] |  |  |  |  |  |  |  |  | Portugal |  | 5000 |  |  |  |  |  | 380
 | Jasmine |  |  |  |  |  |  |  |  | Portugal |  | 256 |  |  |  |  |  | 6320
 | #Oman flower. |  |  |  |  |  |  |  |  | Bolivia |  | 1467 |  |  |  |  |  | 41250
 | Sunflower |  |  |  |  |  |  |  |  | Bolivia |  | 5000 |  |  |  |  |  | 4500
 | Kerria |  |  |  |  |  |  |  |  | Bolivia |  | 62 |  |  |  |  |  | 526
 | Forget-me-not |  |  |  |  |  |  |  |  | Bolivia |  | 98 |  |  |  |  |  | 490
 | Actaea |  |  |  |  |  |  |  |  | Bolivia |  | 990 |  |  |  |  |  | 4400
 | #Oman flower. |  |  |  |  |  |  |  |  | India |  | 85600 |  |  |  |  |  | 6000
 | Magnolia |  |  |  |  |  |  |  |  | India |  | 240 |  |  |  |  |  | 85900
 | #Oman flower. |  |  |  |  |  |  |  |  | Chile |  | 632 |  |  |  |  |  | 75600
 | Sunflower |  |  |  |  |  |  |  |  | Chile |  | 24 |  |  |  |  |  | 64.26
 | Kerria |  |  |  |  |  |  |  |  | Chile |  | 96 |  |  |  |  |  | 37
 | [NAME] |  |  |  |  |  |  |  |  | Chile |  | 125 |  |  |  |  |  | 635
 | #Oman flower. |  |  |  |  |  |  |  |  | Romania |  | 0 |  |  |  |  |  | 0
 | [NAME] |  |  |  |  |  |  |  |  | Romania |  | 44 |  |  |  |  |  | 634
 | #Oman flower. |  |  |  |  |  |  |  |  | Western Sahara |  | 326 |  |  |  |  |  | 9000
 | Balloon Flower |  |  |  |  |  |  |  |  | Western Sahara |  | 970 |  |  |  |  |  | 4500
 | #Oman flower. |  |  |  |  |  |  |  |  | Peru |  | 3260 |  |  |  |  |  | 6526
Spreadsheet: 545790d1509654365-formula-to-show-the-lowest-value-allowed-to-maintain-an-average-example
Sheet: Sheet1

Day | Maximum | Minimum
1 | 17 | 10
2 | 15 | 8 |  |  | <<<< The maximum and minimum values for the first 3 days of the month
3 | 13 | 6
Average temperature |  |  |  |  | <<<< Average temperatures for maximum and minimum
Mean temperature |  |  |  |  | <<<< The mean temperature so far: (average maximum + average minimum) / 2
Day | [NAME] | Min
4 | 17 | ?? |  |  | <<<< The maximum temperature on day 4. Cell [NAME] would show lowest value allowed
Average for days 1-4 |  | 8 |  |  | <<<< Average temperatures for maximum (including day 4) and minimum (days 1-3)
New mean temperature |  |  |  |  | <<<< The new mean temperature - maximum (day 1-4) and minimum (day 1-3)
Difference in mean temp | 0.3 |  |  |  | <<<< New mean temperature - old mean temp (day 1-3)
What is the lowest value that the day 4 minimum can be and still maintain the 0.3 increase in mean temp?
Spreadsheet: 861000d1709019774-building-customer-cohort-chart-with-dynamic-renewal-rates-and-periods-subscriber-cohort-chart
Sheet: Sheet1

 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 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-06-01 00:00:00 | 2025-07-01 00:00:00 | 2025-08-01 00:00:00 | 2025-09-01 00:00:00 | 2025-10-01 00:00:00 | 2025-11-01 00:00:00 | 2025-12-01 00:00:00 | 2026-01-01 00:00:00 | 2026-02-01 00:00:00 | 2026-03-01 00:00:00 | 2026-04-01 00:00:00 | 2026-05-01 00:00:00 | 2026-06-01 00:00:00 | 2026-07-01 00:00:00 | 2026-08-01 00:00:00 | 2026-09-01 00:00:00 | 2026-10-01 00:00:00 | 2026-11-01 00:00:00 | 2026-12-01 00:00:00 | 2027-01-01 00:00:00 | 2027-02-01 00:00:00 | 2027-03-01 00:00:00 | 2027-04-01 00:00:00 | 2027-05-01 00:00:00 | 2027-06-01 00:00:00 | 2027-07-01 00:00:00 | 2027-08-01 00:00:00 | 2027-09-01 00:00:00 | 2027-10-01 00:00:00 | 2027-11-01 00:00:00 | 2027-12-01 00:00:00 | 2028-01-01 00:00:00 | 2028-02-01 00:00:00 | 2028-03-01 00:00:00
New subscribers
Annual | 1000
Quarterly | 200
Retention rates
Annual | 0.5
Quarterly | 0.4
Active subscribers
Annual
Total active quarterly subscribers
Quarterly
Pricing
Annual | 2500
Quarterly | 750
Total revenue
Annual
Quarterly
Spreadsheet: 673907d1587585367-return-table-value-based-on-2-conditions-deposit-sheet-master
Sheet: Sheet3

February | Kamala
DATE |  |  |  |  |  |  | Extra
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
Spreadsheet: 669162d1585233927-creating-a-cleaning-and-product-usage-schedule-matrix-trial
Sheet: Sheet2

4th floor | time mins | 3rd floor | Time mins
hopper 1 |  | LIW 1
hopper 2 |  | LIW 2
hopper 3 |  | LIW 3
hopper 4 |  | LIW 4
hopper 5 |  | LIW 5
hopper 6 |  | LIW 6
hopper 7 |  | LIW 7
hopper 8
 |  | Hopper 1
Total time |  | Total time
Total time Mins
Spreadsheet: 880209d1727843133-rolling-count-of-all-the-overlapping-days-for-multiple-date-ranges-rolling-count-of-all-the-overlapping-days-for-multiple-date-ranges-1-
Sheet: Sheet1 (2)

Range# (A) | Start Date (B) | End Date (C) | Expected count (D) | Explination (E) | Current Duration (F) | ED - 30 days | SD List | Amended SD List | ED List | COUNT | SUM | With LET | windknife
1 | 2024-06-01 00:00:00 | 2024-06-03 00:00:00 | 2
2 | 2024-06-04 00:00:00 | 2024-06-10 00:00:00 | 8 | 6 + 2 |  |  |  |  |  |  |  |  | 8
3 | 2024-06-22 00:00:00 | 2024-06-29 00:00:00 | 15 | 7 + 6 + 2 |  |  |  |  |  |  |  |  | 15
4 | 2024-07-05 00:00:00 | 2024-07-15 00:00:00 | 17 | 10 + 7 |  |  |  |  |  |  |  |  | 17
5 | 2024-07-16 00:00:00 | 2024-07-25 00:00:00 | 23 | 9 + 10 + 4 |  |  |  |  |  |  |  |  | 23
6 | 2024-07-28 00:00:00 | 2024-08-05 00:00:00 | 27 | 8 + 9 + 10 |  |  | 2024-07-05 00:00:00 | 2024-07-05 00:00:00 | 2024-07-15 00:00:00 | 10 |  |  | 26
7 | 2024-08-20 00:00:00 | 2024-08-23 00:00:00 | 13 | 3 + 8 + 2 |  |  | 2024-07-16 00:00:00 | 2024-07-16 00:00:00 | 2024-07-25 00:00:00 | 9 |  |  | 12
Spreadsheet: 5a94c146-e332-4de9-bc6b-5a613371e86c
Sheet: Sheet1

Child Lead Poisoning Prevention Program | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | 91
Categories | Fiscal Year |  |  | Contract Total
 | 11/1/05 - 4/30/06 | 5/1/06 - 4/30/07 | 5/1/07 - 4/30/08 | 11/1/05 -10/31/07
A0110 Wages, Regular, Full | 33211.5 | 66423 | 33211.5 | 132846
A0160 Work out of Class
A0220 Extra Compensation Overtime
A0305 Employee Pension
A0306 Employee Pension Supplement
A0335 Fica Benefits
A0360 Emp Pension Su
A0510 [NAME]
A0515 Retirement Incentive
A0530 Hosp Life Ins
A0535 Health Ins Premium Increase
A0998 Employees Charged In
A0999 Employees Charged Out
A Personal Services | 33211.5 | 66423 | 33211.5 | 132846
B1012 Consultant Services | 0 | 77918 | 15583.5 | 93501.5
B1020 Info and Credit
B1022 Laboratory Services
B1024 Legal Services
B1026 Medical, Dental and Surgical
B1027 Employee Drug Testing
B1029 Security
B1031 Background Checks
B1032 Temporary Overload Employees
B1036 Educational Training Services
B1040 WKM Comp-Med
B1042 Wages Contract Employees
B1044 FICA Benefits - City
B1205 Advertising
B1210 Auto Allowance
B1211 [NAME]
B1230 Dryage Freight Express
[NAME]
B1240 Postage | 722 | 2888 | 722 | 4332
B1245 Promotional Exp
B1250 Travel Local
B1255 Travel Non Local | 1269.5 | 5078 | 1269.5 | 7617
B1298 Communication Transportation
B1325 Printing, Duplication | 250 | 1000 | 250 | 1500
[NAME]
B1415 WKM Comp Ins
B1450 Unemployment Comp Ins
B1535 Desktop phone usage | 378.5 | 1513 | 378.5 | 2270
B1537 [NAME]
B1538 [NAME] | 35.5 | 142 | 35.5 | 213
B1539 Long Distance
B1608 Communication Equipment
B1616 [NAME] and Other Sanitation
B1618 Computer and WP Maintenance
B1622 Office Equip Repair
B1640 Repair to Laboratory Equip
B16450 Lead Abatement - Owner
B16470 Lead Abatement - Rental
B1735 Rent office Equip
B1856 Medical Service (Other)
B1858 Clinical Services (Other)
B1912 [NAME] and Memberships
B1946 Tuition reimbursement
B1999 Charge-out of Contractural Services
B Contractural Services | 2655.5 | 88539 | 18239 | 91194.5
C2105 Books
C2110 Gen Office Supplies | 275 | 1100 | 275 | 1650
[NAME], Maps, Pamphlets | 533.5 | 2134 | 533.5 | 3201
C2210 Food
C2308 Cleaning Toilet Sanitation
C2318 Household and Institutional
C2405 Drugs and Medicines
C2410 Medical and Laboratory Supplies | 6756.5 | 27026 | 6756.5 | 40539
C2705 Computer and WP software
C2706 Computer and WP Hardware
C2720 Photographic Supplies
C2725 Training Materials
C2730 Video Equipment
C2735 [NAME]
C Commodities | 7565 | 30260 | 7565 | 45390
E3406 Computer and WP Equip
E Capital Outlay
Total | 43432 | 185222 | 59015.5 | 287669.5
Spreadsheet: 784447d1655737220-formula-for-2nd-half-points-scored-game-scores
Sheet: Sheet1

Name | Full Time Home Point | Full Time Away Point | Full Time ResultResult | Half Time Home Point | Half Time Away Point | Half Time Result
[NAME] | 0 | 0 | d | 0 | 0 | d
[NAME] | 1 | 0 | h | 0 | 0 | d
[NAME] | 0 | 1 | a | 0 | 0 | d
[NAME] | 1 | 1 | d | 1 | 0 | h
[NAME] | 1 | 0 | h | 0 | 0 | d
[NAME] | 2 | 1 | h | 1 | 0 | h
[NAME] | 0 | 0 | d | 0 | 0 | d
Bethany | 1 | 4 | a | 1 | 0 | h
[NAME] | 6 | 0 | h | 1 | 0 | h
[NAME] | 2 | 1 | h | 0 | 0 | d
Nicki | 0 | 0 | d | 0 | 0 | d
[NAME] | 0 | 1 | a | 0 | 0 | d
[NAME] | 3 | 0 | h | 1 | 0 | h
[NAME] | 0 | 1 | a | 0 | 0 | d
[NAME] | 0 | 0 | d | 0 | 0 | d
[NAME] | 2 | 1 | h | 1 | 0 | h
Nicki | 0 | 1 | a | 0 | 1 | a
[NAME] | 0 | 0 | d | 0 | 0 | d
[NAME] | 1 | 0 | h | 1 | 0 | a
[NAME] | 2 | 0 | h | 1 | 0 | a
[NAME] | 3 | 1 | h | 1 | 1 | d
Nicki | 1 | 0 | h | 0 | 0 | d
[NAME] | 2 | 1 | h | 1 | 0 | h
[NAME] | 1 | 1 | d | 0 | 1 | a
Nicki | 2 | 2 | d | 1 | 0 | h
[NAME] | 4 | 1 | h | 0 | 0 | d
[NAME] | 1 | 2 | a | 0 | 1 | a
[NAME] | 4 | 0 | h | 1 | 0 | h
Bethany | 0 | 2 | a | 0 | 1 | a
[NAME] | 0 | 0 | d | 0 | 0 | d
Nicki | 1 | 1 | d | 0 | 1 | a
[NAME] | 0 | 0 | d | 0 | 0 | d
[NAME] | 0 | 1 | a | 0 | 0 | d
[NAME] | 5 | 0 | h | 1 | 0 | h
[NAME] | 4 | 1 | h | 1 | 1 | d
[NAME] | 0 | 2 | a | 0 | 0 | d
[NAME] | 1 | 1 | d | 0 | 1 | a
[NAME] | 2 | 0 | h | 1 | 0 | h
Bethany | 1 | 0 | h | 0 | 0 | d
[NAME] | 0 | 4 | a | 0 | 2 | a
[NAME] | 1 | 1 | d | 0 | 1 | a
Bethany | 1 | 2 | a | 0 | 1 | a
[NAME] | 4 | 2 | h | 1 | 2 | a
Nicki | 3 | 1 | h | 1 | 1 | d
Spreadsheet: 388724d1428754509-sales-price-volume-mix-variance-analysis-who-can-explain-price-volume-mix-analysis
Sheet: Bridge Analysis Framework

 |  | Volume |  |  |  |  | Price |  |  |  |  | Cost |  |  |  |  | Unit profit |  |  |  |  | Mix
 |  |  |  | YOY
 |  | Y+1 | Y | Abs. | % |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Price | Volume | Mix | Cost | Total |  |  |  |  | Values | Ends | Blank | Up > 0 | Up < 0 | Down > 0 | Down < 0
Unit A |  |  | 420 |  | 0.02 |  |  | 95 |  | 0.02 |  |  | 90 |  | -0.03 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Unit B |  |  | 250 |  | -0.05 |  |  | 120 |  | 0.01 |  |  | 105 |  | 0.05 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | Price | 808.0800000000042
Unit C |  |  | 180 |  | 0.01 |  |  | 80 |  | -0.02 |  |  | 65 |  | -0.01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | Volume | -228.105882352937
Group |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | Mix | -329.894117647059
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cost | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | Revenue |  |  |  |  | Expense |  |  |  |  | Profit |  |  |  |  | Profit margin
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Price | 808.0800000000042
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Volume | -23.13529411764677
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mix | -95.3647058823529
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cost | 27.97500000000224
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | n.m.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | n.m.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | n.m.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | n.m.
Spreadsheet: 708872d1608052580-excel-top-10-dashboard-book
Sheet: RESULTS HERE

ID | RMA Number | Serial Number | Client | Days in service | Current Status
1 |  |  |  |  |  | All results should populate automatically. Top 10 from days in service (Highest to lowest).
2
3 |  |  |  |  |  | 2nd idea: When "Days in service" is more than 10 days values should show in this table. Same top10 needed.
4
5
6
7
8
9
10
Spreadsheet: 65005d1265791246-count_question-count_question03
Sheet: Sheet1

Site ID | Volt 1 | Volt 2 | Volt 3 | Volt 4 | Volt 5 |  | Criteria's | Output I need
1ID | 24 |  | 24 |  |  |  | Sites Count With > 1   24V SMPS | 5
1ID | 48 |  | 24 | 48 |  |  | Sites Count With > 2   24V SMPS | 1
1ID | 24 | 48 |  | 48 |  |  | Sites Count With > 3   24V SMPS | 1
1ID | 48 |  |  | 48 | 48 |  | Sites Count With > 4   24V SMPS | 0
1ID | 24 |  | 24 | 24 | 48
1ID | 48 |  | 24 |  | 48 |  | Sites Count With > 1   48V [NAME] | 6
1ID | 24 | 48 |  |  |  |  | Sites Count With > 2   48V [NAME] | 1
2ID | 24 | 48 |  |  | 24 |  | Sites Count With > 3   48V [NAME] | 0
1ID | 48 | 48 |  |  | 24 |  | Sites Count With > 4   48V [NAME] | 0
1ID | 48 |  |  | 24
1ID | 24 |  |  | 24 |  |  | Sites with > 1 SMPS | 13
1ID | 48 | 24 |  | 48 |  |  | Sites with > 2 SMPS | 9
1ID | 24 | 24 | 24 | 48 | 24 |  | Sites with > 3 SMPS | 2
1ID | 24 |  |  |  |  |  | Sites with > 4 SMPS | 1
 |  |  |  |  |  |  | Sites With [NAME] | 14
 |  |  |  |  |  |  | Sites with No [NAME] | 0
 |  |  |  |  |  |  | Total SMPS | 39
Spreadsheet: 154568d1336487244-help-required-to-create-a-sliding-scale-of-commission-based-on-variable-information-example-of-commission-scale
Sheet: Sheet1

 | Purchases per month | Commission | Actual Purchases | Total Value
 | 0-300 | 0 | 300 | 0
 | 301-1000 | 0.1 | 0 | 0
 | 1001-2000 | 0.15 | 0 | 0
 | 2001-3000 | 0.2 | 0 | 0
 | 3500+ | 0.2 | 0 | 0
 |  | Enter actual Purchases below | Enter actual Value of Purchases below | Average value per purchase | Full Commission
 |  | This would be a variable that would be manualy entered by me | This would be a variable that would be manualy entered by me | Auto generated e.g. (=E10/C10) | Auto Generated commission rate
Spreadsheet: 268059d1380395324-summarising-selections-from-drop-list-petty-cash-form-sample
Sheet: Sheet1

 | Petty cash log and Claim form
 |  |  |  | [NAME]:
 |  |  |  | Location:
 |  |  |  | Date:
 |  |  |  | 2013-05-08 10:07:57.560000
 |  |  |  | Initial Amount: | 4000
 |  |  |  | CASH ON HAND | 1984.324 |  |  |  | Cleaning | 530403
 | [NAME] | Date | PCV # | IN | OUT | Balance |  |  | Court | 560101
 | BEGINNING BALANCE |  |  |  |  |  |  |  | Paper | 530401
1 | Soft drink fee by Tunde | 2013-12-15 00:00:00 | Incentive |  | 1 |  |  |  | Incentive | 552603
2 | Stuffs by Shurooq | 2013-01-23 00:00:00 | Incentive |  | 4.36 |  |  |  | Rental | 554104
3 | Milk for office | 2012-12-26 00:00:00 | Repair |  | 19.17 |  |  |  | Repair | 530812
4 | Lunch meal for [NAME] | 2012-12-22 00:00:00 | Utilities |  | 24 |  |  |  | Govt.permit licence fee | 556401
5 | Lunch meal fee as per attached | 2012-12-26 00:00:00 | Repair |  | 3.47 |  |  |  | Off improvement | 550601
6 | Lunch meal fee for [NAME] | 2012-12-12 00:00:00 | Paper |  | 13.68 |  |  |  | Training course | 569601
7 | Lunch meal for QHSE driving course | 2012-12-11 00:00:00 | Rental |  | 17.3 |  |  |  | Travel insurance | 555701
8 | Lunch meal for Supply Chain meeting | 2012-12-31 00:00:00 | Training course |  | 59.85 |  |  |  | Computer equip | 550303
9 | Lunch meal fee for Driving course | 2013-01-12 00:00:00 | Travel insurance |  | 11.91 |  |  |  | Custom duty | 531006
10 | Lunch meal | 2013-01-22 00:00:00 | Govt.permit licence fee |  | 24.44 |  |  |  | Casual labour | 518302
11 | Lunch meal for ALS meeting | 2013-01-28 00:00:00 | Off improvement |  | 19.927 |  |  |  | Gifts&giveaway | 562301
 |  |  |  |  | 2015.676
 | TOTAL |  |  |  | 2015.68
 | ENDING BALANCE
 | [NAME] |  |  | 0
 | Difference |  |  | 0
 | Balance in A/C
 | NOTE: The shortfall will be charged to Custodian's Personal Account |  | Summary
 | [NAME]:
 | Manager [NAME]:
 | Checked By (MA/BA) :
Spreadsheet: 55501d1255615157-rank-problem-game-and-ranking-sheets-09-10-season
Sheet: DIV 2 Ranking 

DIVISION 2 RANKINGS 09 -10
No | Team | Win | Loss | Draw | Shots | Points
4 | [NAME] | 2 | 1 | 0 | 14 | 13
2 | Loxton RSL | 2 | 1 | 0 | 7 | 15
5 | [NAME] | 2 | 1 | 0 | 13 | 12
1 | Lyrup | 1 | 1 | 1 | 18 | 24
7 | Renmark RSL | 2 | 1 | 0 | 15 | 10
3 | Berri | 1 | 1 | 1 | 5 | 14
6 | Renmark | 2 | 1 | 0 | -6 | 11
9 | Loxton Green | 1 | 2 | 0 | 0 | 7
10 | Monash | 0 | 3 | 0 | 2 | 6
11 | Loxton Blue | 2 | 1 | 0 | 0 | 5
12 | [NAME] | 2 | 1 | 0 | -7 | 4
8 | Moorook | 1 | 2 | 0 | -36 | 8
FINAL RANKINGS
No | Team | Win | Loss | Draw | Shots | Points
1 | Lyrup | 1 | 1 | 1 | 18 | 24
2 | Loxton RSL | 2 | 1 | 0 | 7 | 15
3 | Berri | 1 | 1 | 1 | 5 | 14
4 | [NAME] | 2 | 1 | 0 | 14 | 13
5 | [NAME] | 2 | 1 | 0 | 13 | 12
6 | Renmark | 2 | 1 | 0 | -6 | 11
7 | Renmark RSL | 2 | 1 | 0 | 15 | 10
8 | Moorook | 1 | 2 | 0 | -36 | 8
9 | Loxton Green | 1 | 2 | 0 | 0 | 7
10 | Monash | 0 | 3 | 0 | 2 | 6
11 | Loxton Blue | 2 | 1 | 0 | 0 | 5
12 | [NAME] | 2 | 1 | 0 | -7 | 4
Spreadsheet: 149883d1334172668-copying-data-to-another-worksheet-test-tracker
Sheet: Test Tracker

test # | TEST #1 | TEST #2 | TEST #3 | TEST #4 | TEST #5
[NAME] | 0 | 1 | 1 | 1 | 1
JONES | 0 | 1 | 1 | 1 | 1
SMITH | 0 | 1 | 1 | 1 | 1
WHITEHALL | 0 | 1 | 1 | 1 | 1
Spreadsheet: 264845d1378996555-transfer-data-from-one-sheet-to-another-with-different-format-and-formatting-fixture_auto_update1
Sheet: Dummy Table

 | Livi Pool League Table
 |  |  |  | Total |  |  |  |  |  |  |  | Home |  |  |  |  |  |  |  | Away
Rank | Team | Setup | M | Played | Win | Draw | Lose | F | A | FD | Points | P | W | D | L | F | A | FD | Pt | P | W | D | L | F | A | FD | Pt | Pt Rank | FD Rank | F Rank | Setup Rank
Spreadsheet: 40456fd9-bb89-423a-96b3-f49653221d95
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 | Table S1. Statistics of small RNAs sequences from the soybean nodule NSN and SSN libraries.
 |  | Number of reads | Number of distinct sequences
 | NSN library
 | Tatal reads | 23252859
 | Sequences >18 nt | 12303456
 | Sequences matching Glycine max draft genome | 7607757
 | Non-coding RNA exact matches removed | 4017992 | 59606
 | Known miRNAs (exact match) | 1117544 | 104
 | New miRNA candidates With sequenced miRNA | 101809 | 495
 | SSN library
 | Tatal reads | 23794887
 | Sequences >18 nt | 12608512
 | Sequences matching Glycine max draft genome | 7667513
 | Non-coding RNA exact matches removed | 4835029 | 87993
 | Known miRNAs (exact match) | 1066263 | 104
 | New miRNA candidates With sequenced miRNA | 131714 | 456
 | Note: NSN and SSN represent Non-salt Stressed Nodules and [NAME], respectively.
Spreadsheet: 47121d1246025292-creating-list-from-data-with-blank-spaces-and-also-eliminating-a-repeating-value-demo
Sheet: Sheet1

Funds |  |  | No Blanks |  | What I am trying to do (also remove the "Fund Provider")
 |  |  | Fund Provider |  | Axa
 |  |  | Axa |  | JP Morgan
Fund Provider |  |  | Fund Provider |  | Morgan Stanley
 |  |  | JP Morgan
Axa |  |  | Fund Provider
 |  |  | Morgan Stanley
 |  |  |  |  |  |  |  |  | N.B. this is how I want it to work but I have not put any formulas in
 |  |  |  |  |  |  |  |  | Is there a formula that I can put in that will do this, even if I put the No Blanks
 |  |  |  |  |  |  |  |  | on a different sheet
Fund Provider
JP Morgan
Fund Provider
Morgan Stanley
Spreadsheet: phillip_m_love__30654__9902_OA
Sheet: RECLASS

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - RECLASSES
COMPANY:  ALL
REGION: ALL
 |  |  | Total |  | Central |  | Northeast |  | Southeast-LRC |  | Southeast-EGM |  | West |  | Texas-HPL |  | Texas-EGM |  | Storage |  | Transport |  | BUG
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -2025520
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements |  |  |  |  |  | 0 |  |  |  |  |  | 0
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit |  |  |  |  |  | 117344 |  |  |  |  |  |  |  |  |  |  |  | -117344
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand |  |  |  | 235669.68 |  | 637573.26 |  |  |  |  |  | 758928
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 93300
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance |  |  |  |  |  | 40393 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -40393
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  |  |  |  |  | 47210 |  | 987000 |  |  |  |  |  |  |  | -113999
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges |  |  |  |  |  | -240000 |  |  |  |  |  |  |  |  |  |  |  | 240000
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL