tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: joe_parks__14513__P&L_JUN01
Sheet: NYMEX_juL1

Sells |  |  |  | Buys
106 | 3.81 |  |  | 31 | 3.76
46.5 | 3.79 |  |  | 31 | 3.76
23.25 | 3.925 |  |  | 38.75 | 3.705
31 | 4.065 |  |  | 15.5 | 3.695
15.5 | 4.05 |  |  | 38.75 | 3.905
31 | 3.98 |  |  | 31 | 3.81
31 | 3.985 |  |  | 31 | 3.895
31 | 3.86 |  |  | 23.25 | 3.925
31 | 3.95 |  |  | 23.25 | 3.82
31 | 4.04 |  |  | 15.5 | 4.06
15.5 | 4.135 |  |  | 46.5 | 4.16
15.5 | 4.15 |  |  | 15.5 | 4.035
15.5 | 4.17 |  |  | 31 | 3.9625
31 | 4.13 |  |  | 31 | 3.88
31 | 3.925 |  |  | 31 | 3.77
31 | 3.85 |  |  | 15.5 | 3.765
15.5 | 3.87 |  |  | 31 | 3.7525
31 | 3.865 |  |  | 31 | 3.7825
31 | 3.775 |  |  | 15.5 | 3.79
15.5 | 3.8 |  |  | 46.5 | 3.85
23.25 | 3.78 |  |  | 31 | 3.855
15.5 | 3.83 |  |  | 62 | 3.9
31 | 3.785
31 | 3.83
15.5 | 3.865 |  |  |  |  |  |  | *
15.5 | 3.87
 |  |  |  |  |  |  |  |  |  | <- Realized PL
 |  |  |  |  |  |  |  |  |  | <- MTM PL w/o Real PL |  | preserve realized
 |  |  |  |  |  |  |  |  |  | <- MTM PL with Real PL |  | breakeven
 |  | <- Current Nymex
 |  | <- Price Overide |  |  |  |  |  |  |  | <- Total Pl
Spreadsheet: 850812d1701167930-line-combo-chart-adding-a-solid-horizontal-line-from-one-data-cell-test-file
Sheet: Data

 | Look up refs |  |  |  | TEST |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Metric Count | All 12 months [NAME] | Partial Months Completed Metric | [NAME] |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Time Bound | Data Not Available
 | [NAME] | [NAME] |  |  |  | Measurement | 2022-09 | 2022-10 | 2022-11 | 2022-12 | 2023-01 | 2023-02 | 2023-03 | 2023-04 | 2023-05 | 2023-06 | 2023-07 | 2023-08 | 2023-09 |  |  |  |  | Minimum Threshold | [NAME]
 |  |  |  |  |  | TEST | 0.052844 | 0.04558 | 0.047959 | 0.039698 | 0.049555 | 0.047472 | 0.045844 | 0.058929 | 0.049492 | 0.048967 | 0.068813 | 0.064172 | 0.069152 |  |  |  |  | 0.05 | 0.1 |  | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Example:
Spreadsheet: 858873d1707382019-getting-price-using-multiple-reference-points-test-new-1
Sheet: Price

ND - 24 Hour
Zone | Full Pallet | Half Pallet | [NAME]
Local | 35.43 | 27.09 | 22.92
2 | 43.71 | 38.92 | 37.23
3 | 47.51 | 39.48 | 37.23
4 | 51.04 | 41.74 | 39.48
5 | 54.02 | 45.14 | 39.48
6 | 53.22 | 46.95 | 41.33
7 | 60.53 | 48.54 | 42.32
8 | 58.65 | 54.19 | 47.68
9 | 55.11 | 49.89 | 47.15
10 | 55.65 | 50.8 | 46.83
11 | 62.71 | 57.59 | 48.54
12 | 62.71 | 59.86 | 49.53
13 | 67.05 | 64.37 | 55.32
14 | 67.05 | 57.59 | 48.54
15 | 67.05 | 64.37 | 55.32
16 | 63.51 | 62.47 | 58.64
17 | 91.94 | 82.48 | 82.48
18 | 67.39 | 67.39 | 60.83
19 | 105.1 | 93.79 | 93.15
20 | 81.46 | 71.85 | N/A
21 | 86.43 | 75.12 | N/A
22 | 92.17 | 81.14 | N/A
23 | 92.08 | 75.12 | N/A
24 | 80.77 | 80.77 | N/A
25 | 86.43 | 86.43 | N/A
26 | 126.02 | 114.71 | N/A
27 | 120.37 | 120.37 | N/A
28 | 159.45 | 126.02 | N/A
29 | 131.68 | 131.68 | N/A
30 | 148.65 | 148.65 | N/A
31 | 182.59 | 182.59 | N/A
32 | N/A | N/A | N/A
33 | N/A | N/A | N/A
EC - 48 Hour
Zone | Eco Full Pallet Price | Eco Half Pallet Price
Local | 32.3 | 26.05
2 | 37.73 | 35.52
3 | 40.45 | 35.52
4 | 43.17 | 36.08
5 | 43.17 | 37.78
6 | 43.44 | 40.62
7 | 50.22 | 40.62
8 | 47.83 | 46.27
9 | 48.28 | 44.96
10 | 48.28 | 46.27
11 | 52.4 | 46.83
12 | 52.4 | 47.82
13 | 63.25 | 53.63
14 | 56.73 | 46.83
15 | 63.25 | 53.63
16 | 57.21 | 57
17 | 76.43 | 63.8
18 | 64.66 | 64.66
19 | 86.43 | 75.4
20 | N/A | N/A
21 | 86.43 | 75.12
22 | N/A | N/A
23 | 92.08 | 75.12
24 | N/A | N/A
25 | N/A | N/A
26 | 126.02 | 114.71
27 | N/A | N/A
28 | N/A | N/A
29 | N/A | N/A
30 | N/A | N/A
31 | N/A | N/A
32 | 86.98 | 74.94
33 | 99.91 | 91.82
Spreadsheet: 860798d1708798298-sum-values-based-on-specific-end-text-word-and-year-example
Sheet: Categories

What I want
All Years |  |  |  | 2024 |  |  |  |  | 2023
Location | Cost | Overall % |  | Location | Cost | Overall % |  |  | Location | Cost | Overall %
Amsterdam |  |  |  | Amsterdam | 8 |  |  |  | Amsterdam | 1.2
Porto |  |  |  | Porto | 31 |  |  |  | Porto | 2
Wexford |  |  |  | Wexford | 35 |  |  |  | Wexford | 1.5
Total |  |  |  | Total |  |  |  |  | Total
Equation
All Years |  |  |  | 2024 |  |  |  |  | 2023
Location | Cost | Overall % |  | Location | Cost | Overall % |  |  | Location | Cost | Overall %
Amsterdam |  |  |  | Amsterdam |  |  |  |  | Amsterdam
Porto |  |  |  | Porto |  |  |  |  | Porto
Wexford |  |  |  | Wexford |  |  |  |  | Wexford
Total |  |  |  | Total |  |  |  |  | Total
Spreadsheet: 108673d1305689995-excel-2007-sumproduct-question-ptsumproduct
Sheet: SUMMARY

Date | ID | Bought | Sold | % Sold |  | Date | (All)
2011-01-01 00:00:00 | 8178541110001 | 90 | 48
2011-01-01 00:00:00 | 3531670110003 | 42 | 40 |  |  | Row Labels | Sum of Bought | Sum of Sold
2011-01-01 00:00:00 | 7855760111824 | 75 | 32 |  |  | 3531670110003 | 91 | 80
2011-01-01 00:00:00 | 8262480013000 | 40 | 31 |  |  | 7009790210003 | 97 | 25
2011-01-01 00:00:00 | 8385850010003 | 39 | 25 |  |  | 7199790210003 | 100 | 24
2011-01-01 00:00:00 | 7199790210003 | 100 | 24 |  |  | 7286200510003 | 55 | 24
2011-01-01 00:00:00 | 7686200510003 | 101 | 24 |  |  | 7686200510003 | 101 | 24
2011-01-01 00:00:00 | 8263830010002 | 33 | 21 |  |  | 7855760111824 | 156 | 64
2011-01-01 00:00:00 | 8389450210000 | 31 | 17 |  |  | 8178541110001 | 155 | 68
2011-02-01 00:00:00 | 8178541110001 | 65 | 20 |  |  | 8262480013000 | 81 | 62
2011-02-01 00:00:00 | 3531670110003 | 49 | 40 |  |  | 8263830010002 | 33 | 21
2011-02-01 00:00:00 | 7855760111824 | 81 | 32 |  |  | 8385850010003 | 73 | 50
2011-02-01 00:00:00 | 8262480013000 | 41 | 31 |  |  | 8389450210000 | 31 | 17
2011-02-01 00:00:00 | 8385850010003 | 34 | 25 |  |  | 9163830010002 | 33 | 21
2011-02-01 00:00:00 | 7009790210003 | 97 | 25 |  |  | 9989450210000 | 34 | 17
2011-02-01 00:00:00 | 7286200510003 | 55 | 24 |  |  | Grand Total | 1040 | 497
2011-02-01 00:00:00 | 9163830010002 | 33 | 21
2011-02-01 00:00:00 | 9989450210000 | 34 | 17
Spreadsheet: 59212d1259699631-match-formula-pick4matchformula09
Sheet: Sheet1

 | Date | Pick4 |  |  |  |  | Num 1 (+) |  |  |  | Num 2 (+) |  |  |  | Num 3 (+) |  |  |  | Num 3 (+)
 |  | 3 | 4 | 1 | 5
 |  | Matrix | +X+8 | +X+0
 |  | +5+Y | +5+8 | +5+0
 |  | +0+Y | +0+8 | +0+0
 |  |  |  |  |  |  | Num 1 (-) |  |  |  | Num 2 (-) |  |  |  | Num 3 (-) |  |  |  | Num 3 (-)
 |  | +5 Numbers
 |  | +5 / +8 Numbers
 |  | Swing (+/-) Numbers
 |  |  |  |  |  |  | 6413 |  |  |  | 1913 |  |  |  | 1463 |  |  |  | 1408
 |  |  |  |  |  |  | 6414 |  |  |  | 1914 |  |  |  | 1464 |  |  |  | 1409
 |  |  |  |  |  |  | 6415 |  |  |  | 1915 |  |  |  | 1465 |  |  |  | 1410
 |  |  |  |  |  |  | 6415 |  |  |  | 1915 |  |  |  | 1465 |  |  |  | 1410
 |  |  |  |  |  |  | 6416 |  |  |  | 1916 |  |  |  | 1466 |  |  |  | 1411
 |  |  |  |  |  |  | 6417 |  |  |  | 1917 |  |  |  | 1467 |  |  |  | 1412
 |  |  |  |  |  |  | 8213 |  |  |  | 3713 |  |  |  | 3263 |  |  |  | 3208
 |  |  |  |  |  |  | 8214 |  |  |  | 3714 |  |  |  | 3264 |  |  |  | 3209
 |  |  |  |  |  |  | 8215 |  |  |  | 3715 |  |  |  | 3265 |  |  |  | 3210
 |  |  |  |  |  |  | 8215 |  |  |  | 3715 |  |  |  | 3265 |  |  |  | 3210
 |  |  |  |  |  |  | 8216 |  |  |  | 3716 |  |  |  | 3266 |  |  |  | 3211
 |  |  |  |  |  |  | 8217 |  |  |  | 3717 |  |  |  | 3267 |  |  |  | 3212
 |  |  |  |  |  |  | 8411 |  |  |  | 3911 |  |  |  | 3443 |  |  |  | 3416
 |  |  |  |  |  |  | 8412 |  |  |  | 3912 |  |  |  | 3444 |  |  |  | 3417
 |  |  |  |  |  |  | 8413 |  |  |  | 3913 |  |  |  | 3445 |  |  |  | 3418
 |  |  |  |  |  |  | 8413 |  |  |  | 3913 |  |  |  | 3445 |  |  |  | 3418
 |  |  |  |  |  |  | 8414 |  |  |  | 3914 |  |  |  | 3446 |  |  |  | 3419
 |  |  |  |  |  |  | 8415 |  |  |  | 3915 |  |  |  | 3447 |  |  |  | 3420
 |  |  |  |  |  |  | 8493 |  |  |  | 3993 |  |  |  | 3461 |  |  |  | 3488
 |  |  |  |  |  |  | 8494 |  |  |  | 3994 |  |  |  | 3462 |  |  |  | 3489
 |  |  |  |  |  |  | 8495 |  |  |  | 3995 |  |  |  | 3463 |  |  |  | 3490
 |  |  |  |  |  |  | 8495 |  |  |  | 3995 |  |  |  | 3463 |  |  |  | 3490
 |  |  |  |  |  |  | 8496 |  |  |  | 3996 |  |  |  | 3464 |  |  |  | 3491
 |  |  |  |  |  |  | 8497 |  |  |  | 3997 |  |  |  | 3465 |  |  |  | 3492
Spreadsheet: 832709d1686559740-need-formula-to-individual-calculate-of-ratings-1-to-5-from-16-people-polls-ratings_skill
Sheet: Dashboard

Name | Ownership rating | [NAME] | [NAME] | Wick | Scott | [NAME] | Participant | % | Missing Participants
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Missing Partipant
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Rating first Person
Wick
Scott
 |  | expected result
Name | Ownership rating | [NAME] | [NAME] | Wick | Scott | [NAME] | Participant | % | Missing Participants
[NAME] | 5 |  | 3 | 4 | 1 |  |  |  | 0 |  |  |  | Missing Partipant
[NAME] | 5 | 5 |  | 3 | 4 |  |  |  | 0 |  |  |  | Rating first Person
Wick | 5 | 1 | 2 |  | 5 |  |  |  | 0
Scott | 5 | 5 | 2 |  |  |  |  |  | 1
Spreadsheet: 128548d1321039453-count-formula-load-20-1-
Sheet: Sheet1

 | load # | location | load | truck | driver
 | 1 | Friendly's | 1 | T15 | B
 |  | [NAME]'s Valley | 2 | T15 | B
 |  | [NAME]'s Valley | 3 | T15 | B
 |  | big sky | 4 | T15 | B
 |  | Lakeside | 5 | T15 | B
 |  | [NAME]'s mart | 6 | T1 | M
 |  | 457 | 6 | T1 | M
 |  | crossroads | 7 | T1 | M
Spreadsheet: 715462d1611717745-conditional-sum-2-columns-sum-with-conditions
Sheet: Sheet1

 | Original | Reduced
 | 12 | 0
 | 4 | 0
 | 8 | 0
 | 4 | 2
 | 5 | 0
 | 15 | 0
 | 12 | 0
 | 6 | 0
 | 35 | 18
 | 10 | 9
 | 25 | 20
 | 22 | 0
 | 25 | 21
 | 10 | 0
 | 13 | 0
 | SUM
Spreadsheet: 36892d1234866109-advanced-conditional-formatting-and-pivot-tables-pivot_table
Sheet: DATA

PRODUCT FAMILY | PRODUCT | STOCK | SALES
FRUIT | APPLE | 100 | 5
FRUIT | BANANA | 200 | 10
FRUIT | ORANGE | 50 | 7
MISC | MILK | 10 | 5
MISC | VODKA | 500 | 50
VEGETABLE | CARROT | 30 | 2
VEGETABLE | ONION | 30 | 15
VEGETABLE | PATATO | 30 | 20
Spreadsheet: c1a002b3-c6d7-4bc6-8581-8fab32161524
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5776 | 40952 | [NAME] | Egan | GBR | 1 | 00:21:46 | 00:05:54 | 01:03:01 | 00:04:15 | 00:27:49 | 1 | 02:02:43
Spreadsheet: 89656d1289415703-sumif-not-working-the-way-i-want-2011-budget-wip-trimmed
Sheet: PercentOfSales

 |  |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
Sales-Automotive
Sales-Advertising Program
Sales-Builders Hardware
Sales-Building Specialties
Sales - Propane
Sales-Carpet & Floor Covering
Sales-Christmas
Sales-Clearance Items
Sales-Electrical Supplies
Sales-Electronics/Appl&Gifts
Sales-Employees
Sales-Farm Fencing & Supplies
Sales-Farm, Lawn & Garden
Sales-Feed
Sales-Furniture
Sales-Game Licenses
Sales-Garden Center
Sales-General
Sales-Layaway
Sales-Gift Certificates
Sales - Misc Cull Lumber
Sales-Hilman
Sales-Home & Office Sup Snacks
Sales-Housewares
Sales-Hydraulic
Sales-Labor
Sales-Lumber & Bldg Materials
Sales-Millwork
[NAME]
Sales-Nature Center
Sales-Non Inventory Items
Sales-Package Express
Sales-Paint & Sundries
Sales-Benjamin Moore Paint
Sales-Plumbing & Heating
Sales-Radio Shack
Sales-Sporting Goods
Sales-Store Supplies
Sales-Tools
Sales-Whirlpool Appliances
Sales - Consignment Inventory
Damaged/Returned Goods
Sales Discounts
[NAME]
Cost-Automotive
Cost-Advertising Program
Cost-Builders Hardware
Cost-Building Specialties
COGS - Propane
Cost-Carpet & Floor Covering
Cost-Christmas
Cost-Clearance Items
Cost-Corrections
Cost-Electrical Supplies
Cost-Electronics/Appl&Gifts
Cost-Farm Fencing & Supplies
Cost-Farm, Lawn & Garden
Cost-Feed
Cost-Furniture
Cost-Game Licenses
Cost-Garden Center
Cost-Layaways
Cost-General
Cost-Gift Certificates
Cost - Misc Cull Lumber
Cost-Hilman
Cost-Home & Office Sup Snacks
Cost-Housewares
Cost-Hydraulic
Cost-Labor
Cost-Lumber & Bldg Materials
Cost-Millwork
[NAME]
Cost-Nature Center
Cost-Non Inventory Items
Cost-Package Expresss
Cost-Paint & Sundries
Cost-Benjamin Moore Paint
Cost-Plumbing & Heating
Cost-Radio Shack
Cost-Sporting Goods
Cost-Store Supplies
Cost-Tools
Cost-Whirlpool Appliances
COGS - Consignment Inventory
Spreadsheet: sally_beck__33906__GlobalMgmtSum-Q101-0111
Sheet: GrossMargin

PLAN2000
[NAME] | ENRON GLOBAL MARKETS
2000-12-01 00:00:00 | 1st QUARTER 2001 DETAIL OF GROSS MARGIN
M.QTD
ENA
 |  |  |  |  |  |  |  | Actual | Deals | Forecast | Total | Margin
 | Business Team |  | DPR(1) | MPR | Accruals | Other | FTA | Margin | Identified | Margin | Margin | Plan | [NAME]
 | Liquids |  | -4389 | 0 | 0 | 0 | 0 |  |  | 0 |  | 40000
COAL | Coal |  |  |  | 0 | 0 | 0 |  |  | 0 |  | 13750
SO2 | Emissions |  | -957 | 0 | 0 | 0 | 0 |  |  | 0
WEATHER | Weather |  | -4 | 0 | 0 | 0 | 0 |  |  | 0 |  | 8509.251
INSURANCE | Global Risk Markets |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  | 4875
ECT_INV_IRFX | Equity Trading |  | 269 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
ECT_INV_IRFX | Convertible Trading |  | 809 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | FX / Int Rate Trading |  | 999 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Soft Commodities Trading |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Grain Trading |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Meat Trading |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Financial Trading |  |  |  |  |  |  |  |  |  |  | 20000
 | Transportation |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  | 500
 | LNG |  | -34 | 0 | 0 | 0 | 0 |  |  | 0 |  | 3000
 | Middle East |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  | 1413
 | Puerto Rico |  | 0 | 0 | 0 | 0 | 0 |  |  | 0
 | Office of the Chairman |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Subtotal Gross Margin
 | Other Interest Related Charges |  | 0 | 0 | 0 | -500 | 0 |  |  | 0
 | EGM Gross Margin
 | (1) Excludes Cap. Charge & Operating Costs
Spreadsheet: 880771d1728627622-total-count-of-unique-text-from-a-column-book1
Sheet: Sheet1

 |  |  |  | should be 6
 |  |  | GARREA
 |  |  | GARREA
 |  |  | GARREA
 |  |  | GARREA
 |  |  | GARREA
 |  |  | GARREA
 |  |  | GARREA
 |  |  | GARREA
 |  |  | GARREA
 |  |  | GARREA
 |  |  | GARREA
 |  |  | MRF
 |  |  | MRF
 |  |  | MRF
 |  |  | MRF
 |  |  | MRF
 |  |  | ayush
 |  |  | aru
 |  |  | b2
 |  |  | rg
Spreadsheet: 881838d1730055520-worksheet-with-month-drop-down-sheet-changes-based-on-month-help-bills
Sheet: 2023

 | Finances 2023
 |  |  |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  |  |  | Check | 2418.99 | 2513.26 | 2513.26 | 2513.26 | 2513.26 | 2513.26 | 2513.26 | 2527.26 | 2527.26 | 2527.26 | 2527.26 | 2527.26
 | [NAME] | Amount | Monthly | Renewal | [NAME]
 | Mortgage | 686.04 |  | 04/02/2024 | 1st | x |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Life Insurance | 50 |  |  | 3rd |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Pet Health Club | 18 |  |  | 3rd |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Type | Barclaycard | Santander | Virgin | [NAME] | Barclay Loan
 | Broadband | 23 |  | 15Feb24 | 5th |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Total
 | Gas & Electric | 172 |  | Feb24 | 3rd |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Payments
 | Water | 29 |  |  | 3rd |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Received of [NAME] | 0 | 0 | 0 | 0 | 0
 | Council Tax | 169 |  |  | 3rd |  |  | - | - |  |  |  |  |  |  |  |  | 0
 | Home Insurance | 22 |  | Sep23 | 23rd |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Remaining
 | TV License | 15 | 0 |  | 1st |  | 16 | 25 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 0
 | Phone | 25 |  | [NAME] | 5th |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Car | 240.71 |  | Mar24 | 28th | x
 | Car Tax | 13.56 |  |  | 1st | x
 | Car Insurance | 59 |  | Sep23 | 23rd |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Chiropractor | 34 | 34 |  | 2nd | x
 | Debt | Total | Monthly | End Date | [NAME]
 | Barclaycard | 8085.18 | 163.42 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 313.42 | 313.42 | pay 350 service | credit
 | Santander | 0 | - |  |  |  | 50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Virgin | 2766 | 150 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 150 | 0 | 0
 | [NAME] | 0 | - |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | shortfal 50 each to bills
 | Barclays Loan | 5217.47 | 134.53 |  | 1st | x | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | House & Savings | Total | 1000
 | Gavin | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | [NAME] | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | extra each | 35 | 65.22
 | [NAME] | 7900 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total Transfer
 | Split Total
 | Gavin
 | Bills
 | [NAME]
 | Mortgage
 | Bills
 | Total
 | [NAME]
 | Salary - Outgoing
Spreadsheet: 269591d1381224928-out-of-the-box-is-there-a-functionality-to-tell-how-well-cells-look-like-each-other-fuzzy-search-using-helpers
Sheet: Sheet2

Name1 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | %Dif
Wabush Hotel Limited | Hotel Wabush Limited
Community Recreation Rebroading Service Association | Re-Broading Community Recreation Service Assoc
Test1 Test2 Test3 | Test3 Test1 Test2
Test1 Test2 Test3 | Test3 Test5 Test9
Downing Street 10 | 10, Downing Street
Downing Street 10 | Oxford Street 1
Spreadsheet: 142916d1330089325-excel-2007-duration-between-two-dates-in-month-week-and-days-book1
Sheet: Sheet1

Start | End | Days | Duration
2011-12-19 00:00:00 | 2012-01-27 00:00:00 | 40 | 1 month 10 days
2012-01-07 00:00:00 | 2012-02-08 00:00:00 | 33 | 1 month 3 days
2012-01-07 00:00:00 | 2012-02-06 00:00:00 | 31 | 1 month 1 day
2012-01-10 00:00:00 | 2012-02-15 00:00:00 | 37 | 1 month 7 days
2012-01-12 00:00:00 | 2012-01-25 00:00:00 | 14 | 2 weeks
2011-12-01 00:00:00 | 2012-02-29 00:00:00 | 91 | 3 months 1 day
2012-02-01 00:00:00 | 2012-02-03 00:00:00 | 3 | 3 days
2012-02-02 00:00:00 | 2012-02-10 00:00:00 | 9 | 1 week 3 days
Spreadsheet: 871624d1718047747-how-to-copy-paste-all-rows-and-columns-of-data-from-one-sheet-to-another-sheet-2024_commissions_dale-inc-commission-report
Sheet: Sheet4

DALE INC COMMISSION REPORT / DAVIS WINDOWS AND DOOR SALES / APRIL / 2024
# | CHECK # | CHECK AMOUNT INCLUDING TAX | % PAID BY CUSTOMER | CUSTOMER | JOB NAME | PRODUCT SOLD | INVOICE / SALES ORDER / ESTIMATE # | SUB-TOTAL | COST | GROSS PROFIT $$$ | GROSS PROFIT % | COMMISION RATE | COMMISSION AMOUNT
1 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
2 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
3 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
4 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
5 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
6 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
7 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
8 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
9 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
10 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
11 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
12 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
13 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
14 |  |  |  |  |  |  |  | 0 | 0 |  |  | 0.3
# | CHECK # | CHECK AMOUNT INCLUDING TAX | % PAID BY CUSTOMER | CUSTOMER | JOB NAME | PRODUCT SOLD | INVOICE / SALES ORDER / ESTIMATE # | SUB-TOTAL | COST | GROSS PROFIT $$$ | GROSS PROFIT % | COMMISION RATE | COMMISSION AMOUNT
Spreadsheet: 40552d1238897697-if-vlookup-or-database-problem-mcl_test
Sheet: 03

SERIAL # | ACCOUNT # | DATE CHECKED OUT | DATE INSTALLED | DATE RETURNED
12555 | 987654 | 2009-04-01 00:00:00 | 2009-04-01 00:00:00
12556 | 987655 | 2009-04-01 00:00:00 | 2009-04-01 00:00:00
12557 | 987656 | 2009-04-01 00:00:00 | 2009-04-01 00:00:00
12558 | 987657 | 2009-04-01 00:00:00 | 2009-04-02 00:00:00
12559 | 987658 | 2009-04-02 00:00:00 | 2009-04-02 00:00:00
12560 | 987659 | 2009-04-02 00:00:00 | 2009-04-02 00:00:00
12561 | 987660 | 2009-04-02 00:00:00 |  | 2009-04-03 00:00:00
12562 | 987661 | 2009-04-03 00:00:00 | 2009-04-03 00:00:00
12563 | 987662 | 2009-04-03 00:00:00 | 2009-04-03 00:00:00
Spreadsheet: 698306d1601913275-if-statement-with-networkdays-error-ge-parts-logistics-tracker-we41
Sheet: Eskom- Collection Status  - End

Eskom Shipping Collection - Cycle time (Orders collected > 14 days)
Shipment Status | (All)
Eskom - Actual collection | Eskom - Collection Status
Region | Late | On Time | Grand Total
France | 0.7553956834532374 | 0.2446043165467626 | 1
Germany | 0.4050632911392405 | 0.5949367088607594 | 1
UK | 0.36 | 0.64 | 1
Grand Total | 0.5071090047393365 | 0.4928909952606635 | 1
Eskom Shipping Collection - Cycle time (Orders collected > 14 days)
Shipment Status | (All)
Sum of Eskom Notified- Collection (Age Indicator) | Eskom Notified - Collection (Status)
Power Station | Late | On Time | Grand Total
Arnot | 0.4 | 0.6 | 1
Duvha | 0.2631578947368421 | 0.7368421052631579 | 1
Koeberg | 0.8709677419354839 | 0.1290322580645161 | 1
[NAME] | 0.3333333333333333 | 0.6666666666666666 | 1
Kusile | 1 | 0 | 1
Lethabo | 0.7090909090909091 | 0.2909090909090909 | 1
[NAME] | 0.6296296296296297 | 0.3703703703703703 | 1
Matimba | 0.4025974025974026 | 0.5974025974025974 | 1
Matla | 0.5384615384615384 | 0.4615384615384616 | 1
Medupi | 0.6363636363636364 | 0.3636363636363636 | 1
Tutuka | 0.3170731707317073 | 0.6829268292682927 | 1
Grand Total | 0.5071090047393365 | 0.4928909952606635 | 1
Shipment Status | (All)
 | Values
Region | Weight - KG | Count of Shipment
France | 218385.7 | 122
Germany | 108843.31 | 111
UK | 13762.9 | 85
Grand Total | 340991.9100000001 | 318
Spreadsheet: 349140d1412224457-unexplainable-behavior-in-excel-bug
Sheet: Engine

 |  | CALCULATION ENGINE
 |  |  |  |  |  |  |  |  |  | [NAME] |  | Portion to [NAME] |  |  |  |  |  |  |  |  | [NAME]
 |  | Month |  |  | Principal left |  |  |  |  |  |  |  |  |  |  | Principal left
 |  | 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
 |  | 32
 |  | 33
 |  | 34
 |  | 35
 |  | 36
Spreadsheet: 51eb7d61-74cf-4d84-8e42-f09bf5896c3d
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
LIPA | Test | LIPA | [NAME] (a), Serum | [NAME] (a), S | Automated Turbidimetric Immunoassay | Plain, Red-Top Tube: Red |  |  | 1 | mL | Collection Container/Tube:  Preferred: Serum gel Acceptable: Red top Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions: Fasting-overnight (12-14 hours) Additional Information: Because Lp(a) acts like an acute-phase protein, it should not be measured during periods of active inflammation. Lp(a) levels should not be measured for at least 1 month following a myocardial infarction or stroke. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK  Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | < or =30 mg/dL Values >30 mg/[NAME] may suggest increased risk of coronary heart disease. | Monday through Saturday; Continuously | 1 day (not reported on Sunday) | 1 day | 1 | 83695 |  |  |  |  | Rochester
LIPA | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
LIPA | Result | LIPA | [NAME] (a), S | [NAME] (a), S | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 10835-7 | [NAME] (little a):MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 717502d1612704399-extract-values-using-left-right-or-mid-function-left_right_function_extract_sample_3
Sheet: Here

Name | Name_1 | Name_2