tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 842151d1694200912-add-a-second-condition-to-sumproduct-countifs-test
Sheet: Sheet1

 |  |  | Hollywood |  |  |  |  |  |  |  |  |  | 2023-01-05 00:00:00 | 2023-01-30 00:00:00 | 2023-02-08 00:00:00
 |  |  | LA |  |  |  |  |  |  |  |  |  | 2023-01-08 00:00:00 | 2023-02-06 00:00:00 | 2023-02-23 00:00:00
 |  |  | Denver |  |  |  |  |  |  |  |  |  | 2023-01-31 00:00:00 | 2023-02-08 00:00:00 | 2023-03-05 00:00:00
 |  |  | Hollywood |  |  |  |  |  |  |  |  |  | 2023-02-06 00:00:00 | 2023-01-25 00:00:00 | 2023-01-30 00:00:00
 |  |  | NYC |  |  |  |  |  |  |  |  |  | 2023-01-14 00:00:00 | 2023-03-05 00:00:00 | 2023-03-06 00:00:00
 |  |  | NYC |  |  |  |  |  |  |  |  |  | 2023-01-16 00:00:00 | 2023-03-08 00:00:00 | 2023-02-05 00:00:00
 |  |  | Hollywood |  |  |  |  |  |  |  |  |  | 2023-01-28 00:00:00 | 2023-02-02 00:00:00 | 2023-01-08 00:00:00
Spreadsheet: 329504d1404324259-sum-depending-the-number-falls-sum-depending-where-the-number-is
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80
 | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | 10 | 20 | 30 | 40 | 50 | 60 | 70
Spreadsheet: 76b3c24b-b0ea-4296-9545-2a86c76efaa2
Sheet: Sheet1

[NAME] | Unnamed: 1
Quelle: http://ergebnisse.vimentis.ch/
Frage:
Falls mehr in die Verkehrsinfrastruktur investiert wird, wo soll der Schwerpunkt der [NAME] liegen?
 | schweizweites Ergebnis
Antwort | schweizweites Ergebnis
[NAME] | 0.59
Strasseninfrastruktur | 0.3
Neutral / Weiss nicht | 0.11
Angaben zu den [NAME]
Erhebungsjahr | 2011
Stichprobengrösse | 30565
Erhebungszeitraum | 05.11.2011 bis: 30.12.2011
[NAME] | [NAME]
Methodik / Repräsentativität
Um soziodemographische Verzerrungen [NAME], wurden sämtliche [NAME] nach [NAME], Alter, Bildung und Region gemäss der wahren [NAME] älter als 15 Jahre gewichtet. Es bleibt eine psychographische Verzerrung wegen
der [NAME] über das Internet, welche nicht korrigiert [NAME]. Diese Verzerrung wird anhand einzelner [NAME] für jede [NAME] abgeschätzt. Demnach sind [NAME] auf dieser Seite angegebenen [NAME] mit einer
Präzision von &plusmn;2% [NAME].
[NAME] und [NAME] auf dieser Seite dürfen unter Angabe der Quelle weiterverwendet werden.
Spreadsheet: 0b444169-1e6a-4923-853d-6cf6097f03f3
Sheet: Sheet1

This Excel Spreadsheet is authored by
[NAME]
Scholastic Bowl Coach
Blacksburg High School
3109 Price's Fork Road
Blacksburg, VA 24060
You have my permission to use this for any Quizbowl related tournament and to pass it along to anyone else who might like to use it for their Quizbowl related tournament as well.
You may modify this spreadsheet as much as you would like to suit your own purposes.
You don't have to give credit if you use it or pass it along, but I sure would appreciate it.
The spreadsheet in its current form supports round robin schedules of 5 to 10 teams.
On the worksheets named: "n Team" where n is the number of teams you desire to use; simply edit the cells that are not in bold and
your entries will appear on the corresponding worksheet named: "n Team Matrix"
Print in Landscape and enjoy the ease of developing and printing your tournament schedules.
If you have an idea of who your top teams are likely to be place them in the seed 1 and seed 2 spots and they will not play until the final round of the round robin.
A lot of effort was put into trying to balance the number of times each team visits each of the rooms assigned to their pool, so that
teams would not have the same moderator over and over all day long.
This was not perfectly achieved except for the 5 and 7 Team cases, but every team does visit each of its group's rooms at least once, and in most cases twice.
If you notice any errors or find any improvements that you would like to incorporate or see incorporated, please let me know by e-mail:
[EMAIL]
Disclaimer: These schedules have not all been put through actual tournament play, and there might be small errors. You should place yourself in the "shoes" of each team
to make sure the schedule will work as intended.
Spreadsheet: 58104d1258416187-solver-add-in-not-iterating-poiseulles-viscosity-exp
Sheet: Black tube

height H (m) | time t (s) | mass m (kg) | volume V (m^3) | error in V | dV/dt | error in dv/dt | expected dv/dt |  | Top/cm | Bottom/cm | D/cm | Mean | Stdev(D) | Stderror(D)
0.133 | 59.8 | 0.05160000000000001 | 5.169827842729028e-05 | 5.009590048034667e-08 | 8.64519706141978e-07 | 7.276806911862687e-09 | 8.7971372e-07 |  | 4.177 | 4.329 | 0.1520000000000001 | 0.1615000000000001 | 0.003922867431980017 | 0.001240519604395251
0.122 | 59.8 | 0.0486 | 4.869256456523852e-05 | 5.009582490108456e-08 | 8.142569325290723e-07 | 6.859514237168222e-09 | 7.8385048e-07 |  | 4.139 | 4.297 | 0.1579999999999995
0.113 | 59.9 | 0.04119999999999999 | 4.127847037217749e-05 | 5.009565782173362e-08 | 6.891230446106426e-07 | 5.81275746134964e-09 | 7.0541692e-07 |  | 4.14 | 4.3 | 0.1600000000000001 |  | Mean  diameter (m) |  | 0.001615000000000001
0.102 | 59.8 | 0.03619999999999998 | 3.626894726875789e-05 | 5.009556051859838e-08 | 6.065041349290617e-07 | 5.139832301529609e-09 | 6.095536799999999e-07 |  | 4.137 | 4.301 | 0.1640000000000006 |  | Mean radius (m) |  | 0.0008075000000000006
0.093 | 59.5 | 0.03159999999999999 | 3.166018601361186e-05 | 5.009548210269386e-08 | 5.321039666153254e-07 | 4.550036922928419e-09 | 5.311201199999999e-07 |  | 4.136 | 4.299 | 0.1630000000000003
0.081 | 60 | 0.02610000000000001 | 2.614971059985033e-05 | 5.009540231134273e-08 | 4.358285099975054e-07 | 3.726637293578217e-09 | 4.2654204e-07 |  | 4.177 | 4.34 | 0.1630000000000003 |  | Error on radius (m) |  | 6.202598021976254e-06
0.07200000000000001 | 60.2 | 0.02079999999999999 | 2.083961611022552e-05 | 5.009533981326705e-08 | 3.461730250868027e-07 | 2.993191571845173e-09 | 3.481084800000001e-07 |  | 4.176 | 4.341 | 0.165
0.062 | 59.8 | 0.01550000000000001 | 1.552952162060077e-05 | 5.009529144050248e-08 | 2.59690997000013e-07 | 2.32732377965151e-09 | 2.609600799999999e-07 |  | 4.174 | 4.338 | 0.1639999999999997
0.055 | 60 | 0.01179999999999998 | 1.182247452407023e-05 | 5.009526604346239e-08 | 1.970412420678372e-07 | 1.84208882407945e-09 | 1.999562e-07 |  | 4.172 | 4.335 | 0.1630000000000003
 |  |  |  |  |  |  |  |  | 4.167 | 4.33 | 0.1630000000000003
 |  |  |  | error
 | temp degrees C |  | 21.5 | 0.5 |  |  |  | [NAME]
 | density (kg/m^3) |  | 998.099 | 0.005 |  |  |  | 4.359767543984262
 | mass of container (kg) |  | 0.1688 | 5e-05 |  |  |  | 19.64919604280551
 | length of tube (m) |  | 0.16 | 0.0007000000000000001 |  |  |  | 7.857499764532455
 |  |  |  |  |  | parameters |  | 0.3520239518407409
LINEST | 8.714844883158039e-06 | -2.793582476324897e-07 |  |  |  |  |  | 0.04675466503656468
 | 1.923860653102975e-07 | 1.84762975969096e-08 |  |  |  | 8.71484e-06 | -2.7936e-07 | 6.209649228634867
 |  |  |  |  |  |  |  | 0.4181162919747577
 |  |  |  |  |  |  |  | 0.2973489704652987
 |  |  |  |  |  |  |  | 2.50405260139116
 |  |  |  |  |  |  | total | 41.69440906066561
Spreadsheet: d58f2581-7076-454b-96f5-2e21cfa355fc
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40222636 | 2014-02-24 22:07:20 | AXIS | 1 | 6 | 2 | 1442898 | [NAME] | 6147 | western | 1944-06-06 | 1944-06-06 | First Assault Wave | 1ère vague d'assaut
40222854 | 2014-02-24 22:32:42 | ALLIES | 0 | 3 | 6 | 1442898 | [NAME] | 6147 | western | 1944-06-06 | 1944-06-06 | First Assault Wave | 1ère vague d'assaut
40355868 | 2014-03-04 21:02:17 | AXIS | 1 | 7 | 5 | 288073 | Dukik-Team du Sud | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40356346 | 2014-03-04 21:29:52 | ALLIES | 0 | 5 | 7 | 288073 | Dukik-Team du Sud | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
Spreadsheet: 119878d1314814283-excel-2007-sumifs-works-for-returning-numbers-but-what-do-you-use-for-text-find-rep
Sheet: Master

Cust # | Name | Line | Rep # | Sales Rep
103555 | BBB INC | CIA | 4C | [NAME]
103555 | BBB INC | DW | 101 | [NAME]
103555 | BBB INC | FW | 101 | BILL BLACK
103555 | BBB INC | GAD | 76 | MARY GREEN
103555 | BBB INC | GW | 101 | [NAME]
Spreadsheet: 222653d1363899053-how-to-link-2-worksbook-together-to-get-all-info-master-list-example-1
Sheet: list with no contact name

 | Company name | Address | City | State
 | depot 2 | 123 fake stree | Burlington | VT
 | mission | 45454 f street | Oakland | CA
 | [NAME] | bld c | Tempe | AZ
 | beer vendor | 4350 cedar road | St. Louis Park | MN
 | computer vendor | 8525463 topper | North Hollywood | CA
 | table person | 589585 eight street | Castle Afb | CA
 | clothes person | 10 street street | New Britain | CT
 | lights person | 777 casper | Orlando | FL
 | lamp depot | 458336 crenshaw | Singapore | TI
 | door and garage | 452 polk | Singapore | TI
 | paint and body | 34344 pike ave | Lowry Afb | CO
 | ruffels | 80220 washinhton | Washington | DC
 | chicken house | 67 watson | Griffies | NY
 | cords and lighting | 458226 appelton | Keesler Afb | MS
 | computer vendor | 758226 whites street | [NAME] | WA
 | ruffels | 258354 fourth street | [NAME] | WA
 | lights person | 1202251 blank | Hollywood | FL
 | beer vendor | 58526 ryan | Alameda | CA
Spreadsheet: drew_fossum__8891__Blk-exh
Sheet: Sheet1

ENRON TRANSPORTATION & STORAGE
CERTIFICATE FILING
EXHIBITS AND RESPONSIBLE PARTIES
 | EXHIBIT |  | INFO NEEDED
EXHIBIT | [NAME] | RESPONSIBLE PARTY | TO COMPLETE | DUE DATE
SECTION 7(c) PORTION
A | Articles of Incorporation and Bylaws | Certificate Analyst -  (Secretary Division)
B | State authorization | Certificate Analyst - (Secretary Division)
C | Company Officials | Certificate Analyst -  (Secretary Division)
D | Subsidiaries and Affiliation | Certificate Analyst - (Secretary Division)
E | Other pending applications and filings | Certificate Analyst -
F | Location of facilities | Facility Planning  - (maps)
F-I | Environmental Report - 13 Resource Reports | Regional DES
G | Flow diagrams showing daily design capacity and reflecting operations with and without proposed facilities added | Facility Planning  -
G-I | Flow diagrams reflecting maximum capabilities | Facility Planning - | Refer to G
G-II | Flow diagram data | Facility Planning  -
H | Total gas supply data | Marketing/Customers
I | Market data | Marketing/Customers
J | Conversion to natural gas | N/A
K | Cost of facilities | Technical Services -   Engineering/Construction- (pipeline to compressor) | Send to COS for    Exhibit N
L | Financing | Business Analysis  -   (example available if using internal funds)
M | Construction, operation, and management | Construction  -   (examples available) | STANDARD LANGUAGE
N | Revenues, Expenses, and Income | COS | Need Exhibit K       Rates needs Exhibit N
O | Depreciation and depletion | Business Analysis  -  (example available) | STANDARD LANGUAGE
P | Tariff | Rates -
Z-I | Additional Exhibits begin at Exhibit Z-I | IF REQUIRED TO SUPPORT APPLICATION
SECTION 7(b) PORTION (if required)
F-I | Environmental Report - 13 Resource Reports  or why not applicable | Regional DES
T | Related Applications | Certificate Analyst -
U | Contracts and other agreements | Marketing or Legal
V | Flow Diagram showing daily design capacity after abandonment | Facility Planning
W | Impact on customers whose service will be terminated. | Rates/Law/Marketing
X | Effect of the abandonment on existing Tariff | Rates and Tariffs
Y | Accounting Entries | Property Accounting  -
Z | Location of facilities (Maps) | Facility Planning/Design
Identify the location of the nearest [NAME] or public access building in each county within the project area.
Identify the appropriate newspaper(s) with general circulation in the project area.  What
is the circulation timing (daily, weekly, etc.)
Provide description and location of appurtenant facilities (including abandonments)
Make sure everyone understands this includes any facilities even if at another location.
For abandonment applications what is in the easement agreement and landowner's preference
regarding the method of abandonment.
Landowner Notification requirements.
Are there any third party facilities?
Spreadsheet: 227a1501-41e8-4de9-bf24-08cf228988d0
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
3170 | 9274 | Maria | Cimonetti | USA | 0 | 00:10:15 | 00:00:33 | 00:16:57 | 00:00:42 | [NAME] | 1 | 00:39:30
3170 | 8821 | [NAME] | Harnum | USA | 0 | 00:10:10 | 00:00:50 | 00:18:41 | [NAME] | [NAME] | 2 | 00:41:11
Spreadsheet: 824420d1680572896-comparing-two-lists-with-multiple-columns-s666-pq-ists-difference
Sheet: VLOOKUP

La liste 2017 (au bas) contient les numéros
[NAME] transférer a la liste 2021.
J'ai mélangé les noms, sur la liste 2021
[NAME] fonctionne
Cette méthode utilise les "array" et a la fin
pour "entrer" la formule is faut faire
CTRL+SHIFT+ENTER puisqu'il y a un
un "array" dans la formule
Liste 2021
Arsenault | Stéphane | V
Eastwood | [NAME] | v
Arcand | [NAME] | A
Rozon | Gilles
Kelso | [NAME]
Du Preez | [NAME]
Cross | [NAME] | X
Beaulieu | Michel
Legault | [NAME]
Covo | [NAME] | V
Roman | [NAME]
Liste 2021 (sans les #N/A)
Arsenault | Stéphane | V
Eastwood | [NAME] | v
Arcand | [NAME] | A
Rozon | Gilles
Kelso | [NAME]
Du Preez | [NAME]
Cross | [NAME] | X
Beaulieu | Michel
Legault | [NAME]
Covo | [NAME] | V
Roman | [NAME]
Nouvelle liste (on met la cellule vide si elle
contient des 0)
Arsenault | Stéphane | V
Eastwood | [NAME] | v
Arcand | [NAME] | A
Rozon | Gilles
Kelso | [NAME]
Du Preez | [NAME]
Cross | [NAME] | X
Beaulieu | Michel
Legault | [NAME]
Covo | [NAME] | V
Roman | [NAME]
Liste 2017
Arsenault | Stéphane | V | 697-7803
Covo | [NAME] | V
Eastwood | [NAME] | v | 695-3197
Arcand | [NAME] | A | 695-2732
Beaulieu | Michel
Legault | [NAME]
Rozon | Gilles |  | 695-6565
Cross | [NAME] | X | 694-4895
Kelso | [NAME]
Du Preez | [NAME]
Spreadsheet: 2839b932-f420-4124-be6d-2a136ccaad9c
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
PBU | Test | PBU | Lead, 24 Hour, [NAME] | Lead, 24 Hr, U | Inductively Coupled Plasma-Mass Spectrometry (ICP-MS) | Plastic urine container with no metal cap or glued insert |  |  | 10 | mL | Collection Container/Tube: Clean, plastic urine container with no metal cap or glued insert Submission Container/Tube: Plastic, 10-mL urine tube (Supply T068) or a clean, plastic aliquot container with no metal cap or glued insert [NAME]: 10 mL Collection Instructions: 1. Collect urine for 24 hours. 2. No preservative. 3. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. 4. Refrigerate specimen within 4 hours of completion of 24-hour collection. Additional Information: 1. 24-Hour volume is required. 2. See [NAME] in Special Instructions for multiple collections. 3. High concentrations of gadolinium and iodine are known to interfere with most metals tests. If either gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours.   Urine Preservative Collection Options Ambient	Yes Refrigerated	Preferred Frozen	Yes 6N HCl	Yes 50% Acetic Acid	Yes Na2CO3	No Toluene	Yes 6N HNO3	Yes Boric Acid	No Thymol	No | 2 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | 0-4 mcg/specimen Reference values apply to all ages. | Monday through Friday; 3 p.m.-9 p.m.; Saturday; 8 a.m.-3 p.m.; Continuously | 1 day | 2 days | 1 | 83655 |  |  |  |  | Rochester
PBU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
PBU | Order Question | TM83 | Collection Duration |  | Plain Text
PBU | Order Question | VL84 | [NAME] |  | Plain Text
PBU | Result | 31085 | Lead, 24 Hr, U | Lead, 24 Hr, U | Numeric |  |  |  |  | mcg/spec |  |  |  |  |  |  |  |  |  | 5677-0 | Lead:MRat:24H:[NAME]:Qn:
PBU | Result | TM83 | Collection Duration | Collection Duration | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13362-9 | Collection duration:Time:*:Urine:Qn:
PBU | Result | VL84 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3167-4 | [NAME] volume:Vol:24H:[NAME]:Qn:
PBU | Result | 866 | Pb Concentration | Pb Concentration | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | 20625-0 | Lead:MCnc:24H:[NAME]:Qn:
Spreadsheet: 168388d1342434861-conditional-formatting-multiple-rows-00aaexample-44-
Sheet: Sheet1

12 | A | 21.4 |  | 12 | A | 21.4
12 | A | 22.5 |  | 13 | A | 22.5
13 | B | 20.9 |  | 13 | B | 20.8
12 |  |  |  | 12
Spreadsheet: 131135d1322752978-charts-traffic-light-background-customers
Sheet: Sheet1

Customers | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 |  | band | Colour | left | right
Swansea | 19 | 13 | 18 | 16 | 19 | 16 |  | 1 | Red | 20 | 20
Neath & Port Talbot | 5 | 6 | 6 | 5 | 8 | 12 |  | 2 | Orange | 20 | 20
Bridgend | 15 | 1 | 7 | 9 | 5 | 6 |  | 3 | Green | 20 | 20
Cardiff | 5 | 9 | 11 | 11 | 16 | 23
Vale Of Glamorgan | 6 | 2 | 4 | 2 | 6 | 6
Rhondda Cynon Taff | 6 | 11 | 10 | 14 | 16 | 10
[NAME] | 2 | 4 | 5 | 1 | 3 | 3
Spreadsheet: 41818d1240347937-array-formula-test10
Sheet: Data Information

Client Name | ABC Company
Employee enrollment | 350
Member [NAME] | 500
Budget | 20000
Wellness code to Narrow | BIO
Smoking Population | 150
Wellness Codes
SC | Smoking Cessation
EAP | EAP
BIO | Biometric screenings
GM | Gym Membership
Spreadsheet: 701261d1603664477-display-data-from-a-data-table-in-a-planner-view-room-allocation-multiple-dates
Sheet: Visual

 | 2020-10-19 00:00:00
 | 2020-10-19 00:00:00
 | 08:00:00 | 10:00:00 | 12:00:00 | 14:00:00 | 16:00:00 | 08:00:00 | 10:00:00 | 12:00:00 | 14:00:00 | 16:00:00 | 08:00:00 | 10:00:00 | 12:00:00 | 14:00:00 | 16:00:00 | 08:00:00 | 10:00:00 | 12:00:00 | 14:00:00 | 16:00:00 | 08:00:00 | 10:00:00 | 12:00:00 | 14:00:00 | 16:00:00
 | 10:00:00 | 12:00:00 | 14:00:00 | 16:00:00 | 18:00:00 | 10:00:00 | 12:00:00 | 14:00:00 | 16:00:00 | 18:00:00 | 10:00:00 | 12:00:00 | 14:00:00 | 16:00:00 | 18:00:00 | 10:00:00 | 12:00:00 | 14:00:00 | 16:00:00 | 18:00:00 | 10:00:00 | 12:00:00 | 14:00:00 | 16:00:00 | 18:00:00
Person 1
Person 2
Person 3
Person 4
Person 5
Person 6
Person 7
Person 8
Person 9
Spreadsheet: 158036d1337958398-allocating-data-by-age-stock-ageing-profile
Sheet: FINISHED GOODS

 |  |  | STOCK AGEING (QTY) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRODUCTION
CODE |  |  | 2012-04-01 00:00:00 | 2012-03-01 00:00:00 | 2012-02-01 00:00:00 | 2012-01-01 00:00:00 | 2011-12-01 00:00:00 | 2011-11-01 00:00:00 | 2011-10-01 00:00:00 | 2011-09-01 00:00:00 | 2011-08-01 00:00:00 | 2011-07-01 00:00:00 | 2011-06-01 00:00:00 | 2011-05-01 00:00:00 | 2011-04-01 00:00:00 | 2011-03-01 00:00:00 | 2011-02-01 00:00:00 | 2011-01-01 00:00:00 | 2010-12-01 00:00:00 | OLDER | TOTAL |  | 2012-04-01 00:00:00 | 2012-03-01 00:00:00 | 2012-02-01 00:00:00 | 2012-01-01 00:00:00 | 2011-12-01 00:00:00 | 2011-11-01 00:00:00 | 2011-10-01 00:00:00 | 2011-09-01 00:00:00 | 2011-08-01 00:00:00 | 2011-07-01 00:00:00 | 2011-06-01 00:00:00 | 2011-05-01 00:00:00 | 2011-04-01 00:00:00 | 2011-03-01 00:00:00 | 2011-02-01 00:00:00 | 2011-01-01 00:00:00 | 2010-12-01 00:00:00 | 2010-11-01 00:00:00 | 2010-10-01 00:00:00 | 2010-09-01 00:00:00 | 2010-08-01 00:00:00 | 2010-07-01 00:00:00 | 2010-06-01 00:00:00 | 2010-05-01 00:00:00 | 2010-04-01 00:00:00 | 2010-03-01 00:00:00 | 2010-02-01 00:00:00 | 2010-01-01 00:00:00 | 2009-12-01 00:00:00 | 2009-11-01 00:00:00 | 2009-10-01 00:00:00 | 2009-09-01 00:00:00 | 2009-08-01 00:00:00 | 2009-07-01 00:00:00 | 2009-06-01 00:00:00 | 2009-05-01 00:00:00 | 2009-04-01 00:00:00 | 2009-03-01 00:00:00 | 2009-02-01 00:00:00 | 2009-01-01 00:00:00
00855 | 475 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 314 |  |  | 1886 |  | 871 | 9502 | 7250 | 1853 | 1506 | 1259 | 1401 | 767 | 1299 | 8747 |  | 2033 | 1960 | 16475 |  | 3714
00857 | 906 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 682 |  | 1663 | 1374 | 1406 | 1090 | 2027 | 2558 | 718 | 2918 | 1600 | 2949 | 2130 | 3304 | 7834 |  | 3159 |  | 3767 | 1344 | 2600
00915 | 625 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 532 |  | 529 | 500 | 451 | 532 |  | 442 | 1121 | -294 | 300 |  |  | 464 |  |  |  | 1309
00998 | 741 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 528 | 333 | 333 |  |  | 410 | 994
01010 | 3509 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2093 | 1657 | 1814 | 629
Spreadsheet: 684069d1593123642-rank-multiple-criteria-alpha-and-numeric-ranking-alpha-and-numeric-sample-lmgovin-
Sheet: Data

 |  | Lookup | Office | Position | Staff | What I need | Hide |  |  |  |  |  |  |  |  | Distinct | Parse |  | ID
 |  | AtlantaAD | Atlanta | AD | Cooke
 |  | AtlantaAD | Atlanta | AD | Cooke
 |  | AtlantaAD | Atlanta | AD | Cooke
 |  | AtlantaAD | Atlanta | AD | Cooke
 |  | AtlantaAD | Atlanta | AD | Lovet
 |  | AtlantaAD | Atlanta | AD | Troy,
 |  | AtlantaAD | Atlanta | AD | Troy,
 |  | AtlantaAD | Atlanta | AD | Troy,
 |  | AtlantaCS | Atlanta | CS | Klein
 |  | AtlantaCS | Atlanta | CS | Klein
 |  | AtlantaCS | Atlanta | CS | Klein
 |  | AtlantaCS | Atlanta | CS | Klein
 |  | AtlantaCS | Atlanta | CS | Klein
 |  | AtlantaCS | Atlanta | CS | Milli
 |  | AtlantaCS | Atlanta | CS | Milli
 |  | AtlantaCS | Atlanta | CS | Milli
 |  | AtlantaCS | Atlanta | CS | Milli
 |  | AtlantaCS | Atlanta | CS | Milli
 |  | AtlantaCS | Atlanta | CS | Norri
 |  | BostonAD | Boston | AD | Ayer,
 |  | BostonAD | Boston | AD | Ayer,
 |  | BostonAD | Boston | AD | Ayer,
 |  | BostonAD | Boston | AD | Ayer,
 |  | BostonAD | Boston | AD | Chagn
 |  | BostonAD | Boston | AD | Chagn
 |  | BostonAD | Boston | AD | Chagn
 |  | BostonAD | Boston | AD | Chagn
 |  | BostonAD | Boston | AD | Chagn
 |  | BostonAD | Boston | AD | Chagn
 |  | BostonAD | Boston | AD | Smith
 |  | BostonAD | Boston | AD | Smith
 |  | BostonAD | Boston | AD | Turco
 |  | BostonCCP | Boston | CCP | Fred
 |  | BostonCCP | Boston | CCP | Fred
 |  | BostonCCP | Boston | CCP | Fred
 |  | BostonCCP | Boston | CCP | Fred
 |  | BostonCCP | Boston | CCP | Fred
 |  | BostonCCP | Boston | CCP | Fred
 |  | BostonCCP | Boston | CCP | Fred
 |  | BostonCCP | Boston | CCP | Fred
 |  | BostonCS | Boston | CS | Crow,
 |  | BostonCS | Boston | CS | Crow,
 |  | BostonCS | Boston | CS | Crow,
 |  | BostonCS | Boston | CS | Doria
 |  | BostonCS | Boston | CS | Kanne
 |  | BostonCS | Boston | CS | Kanne
 |  | BostonCS | Boston | CS | Kanne
 |  | BostonCS | Boston | CS | Kanne
 |  | BostonCS | Boston | CS | Kanne
 |  | BostonCS | Boston | CS | Redmo
 |  | BostonCS | Boston | CS | Redmo
 |  | BostonCS | Boston | CS | Redmo
 |  | BostonCS | Boston | CS | Redmo
 |  | BostonCS | Boston | CS | Redmo
Spreadsheet: 839402d1691938708-nested-if-else-with-nearest-match-sample
Sheet: Sheet1

Salary Structure:  [NAME]
Month/Year:  Aug/2023
SLNO | EMP ID. | Name | DA | HRA | CONVEYANCE | LUNCH | OTHERS | UNIFORM | BASIC. | RES CH PAY | Remarks |  | Gross | [NAME]
1 | AV00001 | Muruganandam D |  |  |  | 0 | 0 | 0 |  |  | 35000