tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 734716d1622426406-how-to-apply-appropriate-discount-from-a-grid-when-its-based-on-several-factors-fruit
Sheet: Sheet1

 |  |  |  |  |  |  | Discount table
Product | Ordering Location | Price per unit | Quantity | Price after Discount
Apple | 1 | 2 | 6 |  |  |  | Product | Location 1 | Location 2 | Location 3
Apple | 2 | 2 | 8 |  |  |  | Apple | 0.05 | 0.2 | 0.2
Apple | 3 | 2 | 9 |  |  |  | Pear | 0.2 | 0.05 | 0.2
Pear | 1 | 3 | 13 |  |  |  | Orange | 0.2 | 0.2 | 0.05
Pear | 2 | 3 | 14
Pear | 3 | 3 | 14
Orange | 1 | 1 | 7
Orange | 2 | 1 | 7
Orange | 3 | 1 | 7
Spreadsheet: richard_shapiro__32163__CE2 Pack Template 2506 (FINAL VERSION)
Sheet: Summary PL

 |  | YTD |  |  |  | Forecast July To Dec |  |  |  | Forecast Full Year
 |  | YTD | YTD | YTD |  | FC | Budget | [NAME] |  | FC | Budget | [NAME]
 |  | Actuals & June CE1 | CE1 | [NAME] |  | (CE2) July - Dec | (CE1) July - Dec | July  -  Dec |  | CE2 Full Year | CE1 Full Year | Full Year
 | Gross Margin*
 | Expenses
 | Total Allocations
 |  |  |  | 0 |  | 0 | 0 |  |  | 0 | 0
 | IBIT | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | Headcount | 19 | 19 |  |  | 25 | 25 |  |  | 25 | 25
 | * Separate meetings to be held on Gross Margin.
Highlights:
YTD
Original Budget was $13,501,263. [NAME] forecast of $11,193,492 represents a $2,307,771 (18%) Saving
Headcount is currently (19) v forecast (25) and original budget "plan" (32)
[NAME] left.  Last salary costs April, still incurring rental until his family relocates.
[NAME] and wages YTD $14k over forecast. Due to yearly Expat PAYE payments in April for $98k.
Travel and Entertainment YTD major underspend $354k.
Legal / Consultancy YTD spend still has a significant underspend $963k, possible late billings to come through.
General & Admin YTD is overspent Annual subscriptions fees.
Occupancy Costs YTD for the Dutch /Brussels offices are higher than forecast due to some late billing.
Telephone costs YTD are well under Forecast.
Forecast July to Dec.
Same headcount and phasing as CE1 (Jan-Jun forecast).
Travel and Entertainment reduced inline with reduced headcount from original plan. ie 25 people instead of 32 so 25/32 of original cost.
Legal / Consultancy forecast has been retained despite underspend.  This is partially due to possible late billings.
Phone cost underspend has been retained. IT will now be charging out landline cost which will increase monthly spend.
Issues Recommendations
Late billings for Consultancy /Legal still to come.
Legal/ Consultancy not to be reduced at present. Review run rate and adjust for 2002 Budget (plan) .
Follow Up Points from Q1 Reforecast Meeting
[NAME] spend by Vendor has been reviewed by the team. The team have reviewed May YTD costs and Legal
are going to provide copies of approximately 15 contracts. This will be used to identify notice periods for any possible future cancellations.
[NAME] has now started after his delayed arrival.
Conclusion
Major saving from original budget of (18%). Consultancy /Legal spend under review.
Spreadsheet: 222639d1363895537-conditional-formatting-problem-r-and-s-sample
Sheet: Sheet1

Division 1001 | WEEK 1 |  |  | Season To Date |  | Total |  | WEEK 2 |  |  | Season To Date |  | Total |  | WEEK 3 |  |  | Season To Date |  | Total |  | WEEK 4 |  |  | Season To Date |  | Total |  | WEEK 5 |  |  | Season To Date |  | Total |  | WEEK 6 |  |  | Season To Date |  | Total |  | WEEK 7 |  |  | Season To Date |  | Total |  | WEEK 8 |  |  | Season To Date |  | Total |  | WEEK 9 |  |  | Season To Date |  | Total |  | WIN%
 | Win | Loss |  | Win | Loss | Games |  | Win | Loss |  | Win | Loss | Games |  | Win | Loss |  | Win | Loss | Games |  | Win | Loss |  | Win | Loss | Games |  | Win | Loss |  | Win | Loss | Games |  | Win | Loss |  | Win | Loss | Games |  | Win | Loss |  | Win | Loss | Games |  | Win | Loss |  | Win | Loss | Games |  | Win | Loss |  | Win | Loss | Games
[NAME] WHOCARES | 9
HARVEY'S OUTLAWS | 11
HARVEY'S WABBITS | 8.5
HARVEY'S BUTKICKR | 11
Division 1002 | WEEK 1 |  |  | Season To Date |  | Total |  | WEEK 2 |  |  | Season To Date |  | Total |  | WEEK 3 |  |  | Season To Date |  | Total |  | WEEK 4 |  |  | Season To Date |  | Total |  | WEEK 5 |  |  | Season To Date |  | Total |  | WEEK 6 |  |  | Season To Date |  | Total |  | WEEK 7 |  |  | Season To Date |  | Total |  | WEEK 8 |  |  | Season To Date |  | Total |  | WEEK 9 |  |  | Season To Date |  | Total |  | WIN%
 | Win | Loss |  | Win | Loss | Games |  | Win | Loss |  | Win | Loss | Games |  | Win | Loss |  | Win | Loss | Games |  | Win | Loss |  | Win | Loss | Games |  | Win | Loss |  | Win | Loss | Games |  | Win | Loss |  | Win | Loss | Games |  | Win | Loss |  | Win | Loss | Games |  | Win | Loss |  | Win | Loss | Games |  | Win | Loss |  | Win | Loss | Games
[NAME]'S BALLERS
[NAME]'S FTS
[NAME]'S [NAME]
[NAME]'S TASTY
Spreadsheet: matthew_lenhart__26266__West Daily Prices1119-01
Sheet: Power & Gas Heat Rates

Peak Heat Rates
Off Peak Heat Rates
Spreadsheet: 358c9dfb-5795-4ed2-8abd-b65d337a2153
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
ISMY | Test | ISMY | Mycobact Ident by Sequencing | Mycology Ident by Sequencing |  |  |  |  |  |  | This test is for Billing Purposes Only.  This is not an orderable test. |  |  |  |  |  |  | 1 | 87153 |  |  |  |  | Rochester
ISMY | [NAME] | VARIES | Varies |  |  |  | See instructions
Spreadsheet: 830096d1684714014-conditional-formatting-to-highlight-a-valve-shown-on-a-separate-worksheet-test-conditional-formatting-bvj2
Sheet: Sheet1

Player | Group | Flight | Hcp
BERGER, DAVE | BLUE | A | 32.3
BEWALDA, BOB | BLUE | C | 25.5
BISHOP, DAVE | BLUE | Z | N/A
BISHOP, REB | BLUE | N | 32.4
Spreadsheet: 842492d1694558614-line-chart-for-selective-period-offset-last-n-days-analystbank-
Sheet: Sheet2

 | Data
Date | Sum of Series1 | Sum of Series2
2023-07-03 00:00:00 | 148 | 95
2023-07-04 00:00:00 | 110 | 107.6
2023-07-05 00:00:00 | 110 | 116.6
2023-07-06 00:00:00 | 155 | 127
2023-07-07 00:00:00 | 113 | 127.2
2023-07-10 00:00:00 | 102 | 118
2023-07-11 00:00:00 | 108 | 117.6
2023-07-12 00:00:00 | 135 | 122.6
2023-07-13 00:00:00 | 145 | 120.6
2023-07-14 00:00:00 | 112 | 120.4
2023-07-17 00:00:00 | 180 | 136
2023-07-18 00:00:00 | 121 | 138.6
2023-07-19 00:00:00 | 124 | 136.4
2023-07-20 00:00:00 | 246 | 268.2
2023-07-24 00:00:00 | 318 | 266.2
2023-07-26 00:00:00 | 132 | 139.2
2023-07-27 00:00:00 | 132 | 139
2023-07-28 00:00:00 | 147 | 145.8
2023-07-31 00:00:00 | 147 | 144.8
2023-08-01 00:00:00 | 217 | 155
2023-08-02 00:00:00 | 100 | 148.6
2023-08-03 00:00:00 | 208 | 272.6
2023-08-07 00:00:00 | 149 | 134.8
2023-08-08 00:00:00 | 149 | 121.2
2023-08-09 00:00:00 | 121 | 125.4
2023-08-10 00:00:00 | 219 | 261.2
Grand Total | 3948 | 3905.6
Spreadsheet: 111798d1308085666-merging-two-worksheets-and-setting-a-migration-date-merge-excel-worksheets2
Sheet: Sports Players

Name | Testing | Migration Date
[NAME] | a
[NAME] | b
[NAME] | c
[NAME] | d
[NAME] | e
[NAME] | f
[NAME] | g | 2011-06-06 00:00:00
[NAME] | h
[NAME] | i
[NAME] | j
[NAME] | k
[NAME] | l | 2011-06-10 00:00:00
Dirk Notitzki | m | 2011-06-13 00:00:00
[NAME] | n
Jean-Sebastien Giguere | o | 2011-06-14 00:00:00
[NAME] | p | 2011-06-14 00:00:00
[NAME] | q
[NAME] | r
Spreadsheet: 0db04d26-597a-485e-8ca8-624537df22ef
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | Central | IBC | NEPA | Highmark | Totals
 | ADAMS | 156 |  |  |  | 156
 | ALLEGHENY |  |  |  | 4826 | 4826
 | ARMSTRONG |  |  |  | 452 | 452
 | BEAVER |  |  |  | 825 | 825
 | BEDFORD |  |  |  | 312 | 312
 | BERKS | 928 |  |  |  | 928
 | BLAIR |  |  |  | 652 | 652
 | BRADFORD |  |  | 151 |  | 151
 | BUCKS |  | 1685 |  |  | 1685
 | BUTLER |  |  |  | 797 | 797
 | CAMBRIA |  |  |  | 1217 | 1217
 | CAMERON |  |  |  | 35 | 35
 | CARBON |  |  | 223 |  | 223
 | CENTRE | 316 |  |  | 123 | 439
 | CHESTER |  | 864 |  |  | 864
 | CLARION |  |  |  | 215 | 215
 | CLEARFIELD |  |  |  | 790 | 790
 | CLINTON |  |  | 131 |  | 131
 | COLUMBIA | 175 |  |  |  | 175
 | CRAWFORD |  |  |  | 513 | 513
 | CUMBERLAND | 354 |  |  |  | 354
 | DAUPHIN | 501 |  |  |  | 501
 | DELAWARE |  | 1879 |  |  | 1879
 | ELK |  |  |  | 292 | 292
 | ERIE |  |  |  | 1970 | 1970
 | FAYETTE |  |  |  | 942 | 942
 | FOREST |  |  |  | 27 | 27
 | FRANKLIN | 278 |  |  |  | 278
 | FULTON | 38 |  |  |  | 38
 | GREENE |  |  |  | 299 | 299
 | HUNTINGDON |  |  |  | 259 | 259
 | INDIANA |  |  |  | 546 | 546
 | JEFFERSON |  |  |  | 311 | 311
 | JUNIATA | 66 |  |  |  | 66
 | [NAME] |  |  | 527 |  | 527
 | LANCASTER | 685 |  |  |  | 685
 | [NAME] |  |  |  | 522 | 522
 | LEBANON | 207 |  |  |  | 207
 | LEHIGH | 674 |  |  |  | 674
 | LUZERNE |  |  | 848 |  | 848
 | LYCOMING |  |  | 188 |  | 188
 | MCKEAN |  |  |  | 226 | 226
 | MERCER |  |  |  | 589 | 589
 | MIFFLIN | 194 |  |  |  | 194
 | MONROE |  |  | 408 |  | 408
 | MONTGOMERY |  | 2036 |  |  | 2036
 | MONTOUR | 21 |  |  |  | 21
 | NORTHAMPTON | 451 |  |  |  | 451
 | NORTHUMBERLAND | 235 |  |  |  | 235
 | PERRY | 127 |  |  |  | 127
 | PHILADELPHIA |  | 8435 |  |  | 8435
 | PIKE |  |  | 134 |  | 134
 | POTTER |  |  |  | 159 | 159
 | SCHUYLKILL | 315 |  |  |  | 315
 | SNYDER | 80 |  |  |  | 80
 | [NAME] |  |  |  | 623 | 623
 | SULLIVAN |  |  | 22 |  | 22
 | SUSQUEHANNA |  |  | 185 |  | 185
 | TIOGA |  |  | 141 |  | 141
 | UNION | 53 |  |  |  | 53
 | VENANGO |  |  |  | 337 | 337
 | WARREN |  |  |  | 228 | 228
 | WASHINGTON |  |  |  | 971 | 971
 | WAYNE |  |  | 133 |  | 133
 | WESTMORELAND |  |  |  | 2099 | 2099
 | WYOMING |  |  | 82 |  | 82
 | YORK | 593 |  |  |  | 593
 | Totals | 6447 | 14899 | 3173 | 21157 | 45676
Spreadsheet: 086ffc82-cafd-46fa-b99d-6d493ef5c784
Sheet: Summary

Summary Sheet
 | Service 1 | Service 2
ANNUAL COSTS
Salaries and [NAME]
Travel
Operating Costs
Equipment < $5,000
Capital equipment depreciation
TOTAL ANNUAL COSTS
% of Total Costs
Prior Year Balance (Add Deficit, Subtract Surplus)
Estimated 2 months working capital
TOTAL REVISED COSTS
# of Annual Units
Unit Base
CALCULATED RATE PER SERVICE PER UNIT
UNIT RATE THAT WILL BE CHARGED TO CUSTOMERS | 0 | 0
SUBSIDY
Subsidized Rate
Spreadsheet: 789464d1659105551-formula-to-make-one-column-data-from-multi-columns-data-sample-file-5-1-
Sheet: Sheet1

Expected Results
 |  | 1 | 11 | 21 | 31 | 41
 |  | 2 | 12 | 22 | 32 | 42
 |  | 3 | 13 | 23 | 33 | 43
 |  | 4 | 14 | 24 | 34 | 44
 |  | 5 | 15 | 25 | 35 | 45
 |  | 6 | 16 | 26 | 36 | 46
 |  | 7 | 17 | 27 | 37 | 47
 |  | 8 | 18 | 28 | 38 | 48
 |  | 9 | 19 | 29 | 39 | 49
 |  | 10 | 20 | 30 | 40 | 50
Spreadsheet: 7a37bc63-9563-4d28-904c-ba8a0bdf2b9b
Sheet: Sheet1

Release: Harmonized Indices of Consumer Prices (HICP) | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=251
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-04-20 9:25 AM [NAME]
 | Real-Time | Period
Name: | Start | End
Harmonized Indices of Consumer Prices (HICP) | 2012-06-15 00:00:00 | Current
Link:
http://epp.eurostat.ec.europa.eu/portal/page/portal/hicp/data/main_tables | 2012-06-15 00:00:00 | Current
Source:
Eurostat | 2012-06-15 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2012-06-15 00:00:00
2012-07-15 00:00:00
2012-08-16 00:00:00
2012-09-14 00:00:00
2012-10-16 00:00:00
2012-11-15 00:00:00
2012-12-14 00:00:00
2013-01-16 00:00:00
2013-02-28 00:00:00
2013-03-15 00:00:00
2013-04-16 00:00:00
2013-05-16 00:00:00
2013-06-14 00:00:00
2013-07-16 00:00:00
2013-08-16 00:00:00
2013-09-16 00:00:00
2013-10-16 00:00:00
2013-11-15 00:00:00
2013-12-20 00:00:00
2014-01-21 00:00:00
2014-02-24 00:00:00
2014-03-17 00:00:00
Spreadsheet: 198476d1354793108-if-and-formula-with-multiple-conditions-000___f_worksheet-a
Sheet: 2010

Dubai Ladies Club
Trade Creditors Balance List
For The Year Ending 2010
Creditor Name | Balance | Paid/Cleared On
Active Sports | 2523.5
[NAME] | 2100
Al Futtaim Technologies | 449
Al Suwaidi Computer Co. LLC | 1632
Amber [NAME] | 2005
Aree Suriphat | 971
Aryoni Nikadek | 915.75
Basri Buses Rental | 11500
Bling Design Hook | 532
BROOK FOODS LLC | 441.6
Canon Emirates LLC | 1635
[NAME]C. | 610
Diversified General [NAME] | 492.2
DLC Unknown Creditor - AEP | 56544
Dubai eGovernment | 33354.92
E-Vision | 897
First Security Group | 21500
Flowers by Comtempo LLC | 2550
Group 4 Falck Services LLC | 83632
[NAME] | 1905
[NAME] | 804
Healthcare LLC | 2318.35
JACQUELINE PRETTY | 900
[NAME] | 418
[NAME] | 150
Joz Trading Co. [NAME] | 200
[NAME] | 834
[NAME] Foudah General Trading Co. L.L.C. | 3772.44
[NAME] | 19056.65
Lesley Jones | 2400
[NAME] | 3060
Madi International Co.LLC | 333
[NAME] | 1500
[NAME] | 1600
[NAME] | 1350
[NAME] | 5373
Modern Design Contracting CO. (L.L.C) | 312000
[NAME] Abdulla | 5000
[NAME] | 1050
[NAME] | 1145.5
Namah [NAME] | 197663.95
Nestle Dubai L.L.C | 575.04
[NAME] | 952
NICOLETA ANCA CONNIFF | 985
[NAME] | 517
Oasis | 1476
Ofelia Romasoc Paran | 2284
Pinnacle Computer Systems LLC | 24000
Plantorama LLC | 19000
[NAME] | 600
[NAME] | 406
SALINA BALLOUT | 900
[NAME] | 13247.5
[NAME] | 5520.75
[NAME] | 150
SNACKZONE VENDING MACHINE LLC. | 3185
Technograph Trading Co. LLC | 450
Technogym Emirates LLC | 500
Technology People LLC | 5500
TECOM-ITEP | 4212
The Tribe Advertising LLC | 25000
Titia Bierman | 570
Viking Gulf Trading | 1480
[NAME] | 4831.5
Total
Prepared By: | Approved By:
[NAME] | [NAME]
Accountant | Finance Manager
Grand Total | -904985.65
Spreadsheet: 811342d1672418357-sumif-formula-lookup-3-dimensions-and-sum-total-between-two-dates-sumif-formula-lookup-3-dimensions-and-sum-total-between-two-dates
Sheet: Sheet1 (2)

RAW DATA | Date of Sale | SKU | Colour | Product | Units Sold |  | OUTPUT NEEDED |  |  | SKU | Colour | Product | Units Sold |  | With spill formula
 | 2022-01-01 00:00:00 | SKU030 | Red | Dresses | 5 |  | 2022-01-03 00:00:00 | 2022-01-09 00:00:00 |  | SKU030 | Red | Dresses |  |  |  | Red | Dresses
 | 2022-01-02 00:00:00 | SKU019 | White | Jumpsuits | 6 |  |  |  |  | SKU019 | White | Jumpsuits |  |  | SKU019 | White | Jumpsuits | 19
 | 2022-01-03 00:00:00 | SKU042 | Black | Tops | 9 |  |  |  |  | SKU042 | Black | Tops |  |  | SKU042 | Black | Tops | 13
 | 2022-01-04 00:00:00 | SKU035 | Black | Jacket | 3 |  |  |  |  | SKU035 | Black | Jacket |  |  | SKU035 | Black | Jacket | 5
 | 2022-01-05 00:00:00 | SKU036 | Black | Blazer | 2 |  |  |  |  | SKU036 | Black | Blazer |  |  | SKU036 | Black | Blazer | 2
 | 2022-01-06 00:00:00 | SKU030 | Red | Dresses | 1
 | 2022-01-07 00:00:00 | SKU019 | White | Jumpsuits | 19 |  |  |  |  |  |  |  |  |  | With PivotTable
 | 2022-01-08 00:00:00 | SKU042 | Black | Tops | 4 |  |  |  |  |  |  |  |  |  | Date of Sale | (Multiple Items)
 | 2022-01-09 00:00:00 | SKU035 | Black | Jacket | 2
 | 2022-01-10 00:00:00 | SKU036 | Black | Blazer | 0 |  |  |  |  |  |  |  |  |  | SKU | Colour | Product | Sum of Units Sold
 | 2022-01-11 00:00:00 | SKU030 | Red | Dresses | 2 |  |  |  |  |  |  |  |  |  | SKU019 | White | Jumpsuits | 19
 | 2022-01-12 00:00:00 | SKU019 | White | Jumpsuits | 1 |  |  |  |  |  |  |  |  |  | SKU030 | Red | Dresses | 1
 | 2022-01-13 00:00:00 | SKU042 | Black | Tops | 4 |  |  |  |  |  |  |  |  |  | SKU035 | Black | Jacket | 5
 | 2022-01-14 00:00:00 | SKU035 | Black | Jacket | 5 |  |  |  |  |  |  |  |  |  | SKU036 | Black | Blazer | 2
 | 2022-01-15 00:00:00 | SKU036 | Black | Blazer | 6 |  |  |  |  |  |  |  |  |  | SKU042 | Black | Tops | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total |  |  | 40
Sumif formula - lookup 3 dimensions & sum total between two dates
https://www.excelforum.com/excel-formulas-and-functions/1396539-sumif-formula-lookup-3-dimensions-and-sum-total-between-two-dates.html
Spreadsheet: 829785d1684441939-assigning-points-to-a-column-of-numbers-new-society-to-share-1-trial
Sheet: Sheet1

 |  | All Hallows Invitational |  |  |  | Finau Fresh |  |  | Butter Brook |  |  |  |  |  |  | Sheeps Hill |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | The Old 38th |  |  |  | White Tailed National | White | Tailed | National |  |  |  |  | Tenessee Open |  |  |  |  |  |  |  | Stratvern Isles |  |  |  |  | Wilderness Peak |  |  |  |  |  | Orion Ranch |  |  |  |  |  | Dubai Classico |  |  |  |  |  |  | The Renaissance Club |  |  |  |  |  | Middle Eastern Promise
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ending  May 22nd |  |  |  |  |  |  |  |  | Ending May 24th |  |  |  |  | Ending May 30th |  |  |  |  |  |  |  |  | Ending June 4th |  |  |  |  |  | Ending June 8th |  |  |  |  | Ending June 10th |  |  |  |  |  | Ending June 16 |  |  |  |  |  |  | Ending June 20th |  |  |  |  |  | Ending June 27th |  |  |  |  |  | Ending June 29th
 |  | Position | Score |  |  |  |  |  |  |  |  | Comb |  |  |  |  |  | Comb |  |  |  |  |  |  | Comb |  |  |  | Rd 1 |  |  |  |  |  |  |  |  |  | Comb |  |  |  |  |  |  |  |  | Comb |  |  |  |  | Comb |  |  |  |  |  |  |  | Rd 1 | Rd 2 | RD 3 | Comb |  |  | Rd 1 | Rd 2 | Rd 3 | RD 4 | Comb |  |  | Rd 1 | Rd 2 | Rd 3 | Comb |  |  | Rd 1 | Rd 2 | Rd 3 | Comb |  |  | Rd 1 | Rd 2 | Rd 3 | Rd 4 | Comb |  |  | Rd 1 | Rd 2 | Rd 3 | Rd 4 | Comb |  |  | Rd 1 | Rd 2 | Rd 3 | Rd 4 | Comb |  |  | Rd 1 | Rd 2 | Rd 3 | Rd 4 | Comb
 |  |  |  |  |  | Score | Position |  | Rd1 | Rd2 | Rd3 | Score | POINTS | Position |  | Rd1 | Rd2 | Score | Position | Points |  | Rd 1 | Rd 2 | Rd 3 | Score | Position | Points |  |  |  |  | Rd 1 | Position |  | Rd1 |  | Rd2 | Rd3 | Score | Position |  |  |  | Rd1 | Rd2 | Rd3 | Rd4 | Score | Position |  | Rd1 | Rd2 | Score | Position |  |  | Score | Position |  |  |  |  |  | Score | Position |  |  |  |  |  | Score | Position |  |  |  |  | Score | Position |  |  |  |  | Score | Position |  |  |  |  |  | Score | Position |  |  |  |  |  | Score | Position |  |  |  |  |  | Score | Position |  |  |  |  |  | Score | Position
Marktallman59 | [NAME] |  |  |  |  | 90 |  |  | 58 | 58 | 62 |  |  |  |  | 60 | 58 |  |  |  |  | 53 | 65 | 62
spankyhog | [NAME] |  |  |  |  | 85 |  |  | 64 | 62 | 65 |  |  |  |  | 60 | 63 |  |  |  |  | 57 | 66 | 74
tuenvsc3 |  |  |  |  |  | 110
Bailymaus | [NAME] |  |  |  |  | 62 |  |  | 61 | 60 | 58 |  |  |  |  | 61 | 61 |  |  |  |  | 58 | 59 | 70
bstroth |  |  |  |  |  |  |  |  | 60 | 58 | 60 |  |  |  |  | 59 | 57
raideyes | [NAME] |  |  |  |  |  |  |  | 62 | 61 | 59 |  |  |  |  |  |  |  |  |  |  | 57 | 72 | 69
scotland4ever73 |  |  |  |  |  |  |  |  | 61 | 63 | 63
[NAME] |  |  |  |  |  |  |  |  | 60 | 63 | 65 |  |  |  |  | 63 | 67
anubis24212
Surichatto |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 58 | 65 | 64
ts9217 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 65 | 70 | 70
Spreadsheet: 759564d1639593686-query-to-find-the-highest-overal-percentage-from-different-data-types-generals-hydr-
Sheet: Foglio1

General | total attack | total def | total hp | gr atk | gr def | gr hp | mount atk | mount hp | range atk | seige atk |  |  |  | [NAME] vars |  | Reduction
1 |  |  |  |  |  |  |  |  | -0.3 | -0.2 |  |  |  | 1
2 | -0.1 |  | -0.1 |  |  |  |  |  |  |  |  |  |  | 0
3 |  | -0.1 |  |  |  |  |  |  | -0.3 |  |  |  |  | 1
4 |  |  |  |  |  | -0.15 |  | -0.15 | -0.25 |  |  |  |  | 1
5 |  |  |  |  |  | -0.1 |  | -0.1 | -0.15 | -0.15 |  |  |  | 1
6 | -0.15 |  |  |  |  |  |  |  |  |  |  |  |  | 0
7 |  |  |  |  |  | -0.2 |  |  |  | -0.2 |  |  |  | 1
8 | -0.1 |  |  |  |  |  | -0.2 |  |  |  |  |  |  | 0
9 |  |  |  | -0.25 |  |  |  |  | -0.15 | -0.15 |  |  |  | 1
10 |  |  |  | -0.35 |  | -0.2 |  | -0.2 |  |  |  |  |  | 1
11 |  | -0.15 |  |  | -0.15 |  |  |  |  |  |  |  |  | 0
12 |  |  | -0.15 |  |  |  |  |  |  |  |  |  |  | 0
13 | -0.1 |  |  |  |  |  |  |  |  |  |  |  |  | 0
14 |  |  |  |  |  |  |  | -0.2 | -0.2 |  |  |  |  | 1
15 |  |  |  |  |  |  |  |  | -0.1 | -0.1 |  |  |  | 0
16 |  |  |  |  |  | -0.15 |  | -0.15 |  |  |  |  |  | 0
17 |  |  |  | -0.2 |  |  | -0.2 |  |  |  |  |  |  | 1
18 |  |  |  |  |  |  | -0.25 |  |  |  |  |  |  | 0
19 |  |  |  | -0.15 |  |  | -0.15 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  | Obj. Fun.
 |  |  |  |  |  |  |  |  |  |  |  |  | Constr.
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
Spreadsheet: 162855d1340104832-using-left-and-right-and-if-formulas-drawings
Sheet: Sheet1

90769255 |  | 90769255
90769256 |  | 90769256
90769257 |  | 90769257
90769258 |  | 90769258
90769260 |  | 90769260
90769261 |  | 90769261
90769264 |  | 90769264
90769265 |  | 90769265
90769266 |  | 90769266
90769267 |  | 90769267
90769268 |  | 90769268
90769269 |  | 90769269
90769270 |  | 90769270
90769271 |  | 90769271
90769272 |  | 90769272
90769273 |  | 90769273
90769274 |  | 90769274
90769279 |  | 90769279
90769280 |  | 90769280
90769281 |  | 90769281
90769282 |  | 90769282
90769283 |  | 90769283
90769284 |  | 90769284
90769285 |  | 90769285
90769286 |  | 90769286
90769287 |  | 90769287
90769288 |  | 90769288
90769289 |  | 90769289
90769291 |  | 90769291
90769292 |  | 90769292
90769293 |  | 90769293
90769294 |  | 90769294
90769295 |  | 90769295
90769296 |  | 90769296
90769297 |  | 90769297
90769298 |  | 90769298
90769299 |  | 90769299
90769300 |  | 90769300
90769301 |  | 90769301
90769302 |  | 90769302
90769303 |  | 90769303
90769304 |  | 90769304
90769305 |  | 90769305
90769306 |  | 90769306
90769307 |  | 90769307
90769308 |  | 90769308
90769309 |  | 90769309
90769310 |  | 90769310
90769311 |  | 90769311
90769312 |  | 90769312
90769313 |  | 90769313
90769314 |  | 90769314
90769315 |  | 90769315
90769316 |  | 90769316
90769317 |  | 90769317
90769318 |  | 90769318
90769319 |  | 90769319
90769320 |  | 90769320
90769321 |  | 90769321
90769322 |  | 90769322
90769323 |  | 90769323
90769324 |  | 90769324
90769325 |  | 90769325
90769326 |  | 90769326
90769327 |  | 90769327
90769328 |  | 90769328
90769687 |  | 90769687
90769689 |  | 90769689
90769690 |  | 90769690
90774570 |  | 90774570
90774573 |  | 90774573
90774574 |  | 90774574
90774575 |  | 90774575
90774576 |  | 90774576
90774578 |  | 90774578
90774579 |  | 90774579
90774580 |  | 90774580
90774581 |  | 90774581
90774582 |  | 90774582
90774583 |  | 90774583
90774584 |  | 90774584
90774585 |  | 90774585
90774586 |  | 90774586
90774587 |  | 90774587
90774588 |  | 90774588
90774589 |  | 90774589
90774590 |  | 90774590
90774591 |  | 90774591
90774592 |  | 90774592
90774593 |  | 90774593
90774594 |  | 90774594
90774595 |  | 90774595
90774596 |  | 90774596
90774600 |  | 90774600
90776780 |  | 90776780
90776781 |  | 90776781
90777348 |  | 90777348
Spreadsheet: 587109d1534848429-random-assign-with-equal-count-zeszyt2
Sheet: Sheet3

No | Name | Number Task | RAND formula | Validator A | Validator B | Validator C | Assigned validators | Validator
1 | Person A | 2 |  | 0 | 1 | 0
2 | Person B | 2 |  | 0 | 0 | 1
3 | Person C | 2 |  | 0 | 0 | 1
4 | Person D | 2 |  | 0 | 1 | 0
5 | Person E | 5 |  | 1 | 0 | 0
6 | Person F | 1 |  | 0 | 1 | 0
7 | Person G | 1 |  | 0 | 0 | 1
8 | Person H | 0 |  | 0 | 0 | 1
9 | Person I | 0 |  | 0 | 0 | 1
10 | Person J | 0 |  | 1 | 0 | 0
 |  |  | assigned tasks