tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 82655d1282684658-worksheet-not-fitting-page-when-printing-dummy-sheet_10
Sheet: Expense Form

 |  |  | xx
Expense Form
Site |  |  |  |  |  | Union | BCGEU
Name |  |  |  |  |  | Employee Number | 41394
Cost Centre |  |  |  |  |  | Pay Period | 2010-07-01 00:00:00
Date | Start location | Destination | Reason for claim | # of KM (see Note 1) | Minimum Milage of $2.00 (Code 1 per trip) | Parking Receipt Totals | Taxi/Skytrain/Bus Receipt Totals
2010-07-05 00:00:00 |  |  | Client mtg | 4 | 2
2010-07-05 00:00:00 |  |  | Client mtg | 2 | 1
2010-07-06 00:00:00 |  |  | ICM | 17 | 8
2010-07-07 00:00:00 |  |  | Client mtg | 17 | 8
2010-07-07 00:00:00 |  |  | Client mtg | 17 | 8
2010-07-08 00:00:00 |  |  | Client mtg | 5 | 2.5
2010-07-08 00:00:00 |  |  | Client mtg | 5 | 2.5
2010-07-09 00:00:00 |  |  | Client mtg | 17 | 8
2010-07-12 00:00:00 |  |  | Client mtg | 5 | 2.5
2010-07-12 00:00:00 |  |  | Client mtg | 5 | 2.5
2010-07-13 00:00:00 |  |  | Client mtg | 17 | 8
2010-07-14 00:00:00 |  |  | Client mtg | 17 | 8
2010-07-14 00:00:00 |  |  | Client mtg | 17 | 8
2010-07-15 00:00:00 |  |  | Client mtg | 5 | 2.5
2010-07-15 00:00:00 |  |  | Client mtg | 5 | 2.5
2020-07-19 00:00:00 |  |  | Client mtg | 11 | 5
2020-07-19 00:00:00 |  |  | Client mtg | 11 | 5
2020-07-21 00:00:00 |  |  | Client mtg | 5 | 2.5
2020-07-21 00:00:00 |  |  | Client mtg | 5 | 2.5
2020-07-23 00:00:00 |  |  | Client mtg | 17 | 8
2020-07-23 00:00:00 |  |  | Client mtg | 17 | 8
2020-07-26 00:00:00 |  |  | Client mtg | 5 | 2.5
2020-07-26 00:00:00 |  |  | Client mtg | 5 | 2.5
2020-07-27 00:00:00 |  |  | Client mtg | 5 | 2.5
2020-07-27 00:00:00 |  |  | Client mtg | 6 | 3
 |  |  |  | Pay Code | Pay Code | Pay Code | Pay Code
(Enter Appropriate Code in each box)
116 |  |  |  | 242 | 115.5 | 0 | 0
Employee's Signature |  |  |  |  | Date: | 2010-07-30 00:00:00
Supervisor's Authorization |  |  |  |  | Date: | 2010-07-30 00:00:00
All receipts should be attached to this form and kept by the dept. manager for audit purposes
Note 1: Mileage as per the odometer reading or per FHA Mileage Chart
Spreadsheet: 5d3c4940-3109-4df8-97bd-ba29e3cac265
Sheet: PAGE 1

 | STUDENT EVALUATION RECORD
 | SCHOOL NAME : |  |  |  |  |  |  |  | SCHOOL # : |  |  |  |  |  |  | DATES : |  |  |  | TO
 | STUDENT NAME                                                  (LAST, FIRST M.I.) |  | LAST 4 SSN | FAILED TECHNICAL SKILLS (X) |  |  |  |  |  |  |  |  |  |  | DROPOUT (X) | EXTENSION (MED/MIL) | EXTENSION COMPLETE (Y/N) | MANDATORY [NAME]          (Y/N) | TOTAL % NM HRS MISSED | EXAM ELIGIBLE (Y/N) | STATE EXAM SCORE
 |  |  |  | CPR | DR | FA | HAZ | ICS | NB | NIMS | PT | SC | SFST | STOPS |  |  |  |  |  |  | INITIAL | RETEST
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
 |  |  |  |  |  |  |  |  |  |  |  | COMMANDER SIGNATURE |  |  |  |  |  |  | DATE
Spreadsheet: 885486d1735117825-rank-students-according-to-marks-obtained-based-on-multiple-criteria-rank-function2-1-
Sheet: RESULT

ABCD SCHOOL
TOTAL
Sl. No. | Name of the Student | Class | Sec. | Roll No. | Sex | Cat. | Status | Total Marks Obtained | Grade | % Marks Obtained | Exected Rank | Qualified / Not-qualified
 | [NAME] | X | A | 1 | G | SC | AP | 447 | 0D | 0.6385714285714286 |  | PASS
 | RIYA BARMAN | X | A | 2 | G | SC | AP | 447 | 0D | 0.5971428571428572 |  | PASS
 | [NAME] | X | A | 3 | G | GEN | AP | 447 | 0D | 0.6385714285714286 |  | PASS
 | [NAME] | X | A | 4 | G | GEN | AP | 300 | 0D | 0.5842857142857143 |  | PASS
 | [NAME] | X | A | 5 | B | GEN | AP | 447 | 2D | 0.4442857142857143 |  | PASS
 | [NAME] | X | A | 6 | G | SC | AP | 350 | 0D | 0.5642857142857143 |  | PASS
 | [NAME] | X | A | 7 | G | SC | AP | 447 | 4D | 0.4828571428571429 |  | PASS
 | KAKALI BARMAN | X | A | 8 | G | GEN | AP | 447 | 1D | 0.4728571428571429 |  | PASS
 | BARNALI BARMAN | X | A | 9 | G | SC | AP | 450 | 1D | 0.4642857142857143 |  | PASS
Spreadsheet: daren_farmer__5685__HPLN0123
Sheet: Sheet1

HPLN0123.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - January 23, 2001
 |  |  |  |  |  | **Tuesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-01-23 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
Enron (S) |  | LS Teco Katy I/C |  | Enron | 0 | 0
Enron (S) |  | Oasis Sealy |  | Enron | 0 | 0
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 850658d1701072258-could-you-please-look-at-my-code-sumif-not-working-for-me-budget-tracker-to-upload
Sheet: Non Pay Budget

Pathway Budget Code | Expense Category | Total Budget Lines | Total Budget Lines Minus Expenses and Expenditure
MC1825 Film Music | £ 2,300 COURSE MATERIALS (Credit card) | 2300
MC1825 Film Music | £ 500 TRAVELLING EXP. | 500
MC1825 Film Music | £ 500 HOSPITALITY | 455
MC1825 Film Music | £ 500 ACCOMMODATION | 500
MC1825 Film Music | Visiting Artists (Non Curricular) | 5040
MC1910 Classical Music | External Guests (Curriculum) | 6500
MC1910 Classical Music | Opera North Partnership | 24500
MC1910 Classical Music | Travel | 250
MC1910 Classical Music | Hospitality | 350
MC1910 Classical Music | Staff Development | 600
MC1910 Classical Music | Student Trips | 300
MC1700 LJC | Staff Travel Costs | 1500
MC1700 LJC | Music Mark,Musical Futures online | 500
MC1700 LJC | Summer Academy Accomodation Fees | 6800
MC1700 LJC | Course materials | 300
MC1700 LJC | Visiting lecture fees | 300
MC1700 LJC | Leverhulme scholarships | 33075
MC1700 LJC | Wolfson bursaries | 15000
MC1700 LJC | Summer Academy Bursaries | 3000
MC1700 LJC | Individual giving | 600
MC1700 LJC | Access Agreement bursaries | 10000
MC1920 Jazz Studies | Media development | 4000
MC1920 Jazz Studies | Room/Space Hire | 2000
MC1920 Jazz Studies | Conferences/Visits | 1500
MC1920 Jazz Studies | Hospitality | 500
MC1920 Jazz Studies | External Guests (extra curricula) | 2250
MC1700 LJC | [NAME] | 5000
MC1910 Classical Music | Additional accompanists | 2700
MC2300 Music & Education | Curriculum Development TDAP | 10000
MC2300 Music & Education | International Scholarships UG | 10000
MC2300 Music & Education | Agent Fees - International Recruitment | 1250
Spreadsheet: 694160d1599399805-auto-copy-of-certain-relevant-field-from-one-sheet-to-another-sheet-on-basis-of-condition-autocopycertainfieldstoanother2
Sheet: Sheet2

[NAME] |  |  |  |  |  |  |  |  |  | Age between 17-19 |  |  |  |  |  |  |  |  |  | ABOVE 19
DOB AFTER |  |  |  |  |  |  |  | 2003-01-01 00:00:00 |  | DOB BETWEEN |  |  |  |  |  |  | 2001-01-01 00:00:00 | 2003-12-31 00:00:00 |  | DOB BEFORE |  |  |  |  |  |  |  | 2000-12-31 00:00:00
DOB | NAME | PHYISCS | MATH | CHEMISTRY | SOCIAL SCIENCE | HISTORY | ARTS | Geography |  | DOB | NAME | PHYISCS | MATH | CHEMISTRY | SOCIAL SCIENCE | HISTORY | ARTS | Geography |  | DOB | NAME | PHYISCS | MATH | CHEMISTRY | SOCIAL SCIENCE | HISTORY | ARTS | Geography
Spreadsheet: 819972d1677794010-need-a-formula-to-return-balance-of-last-day-of-previous-month-sample12-updated
Sheet: Sheet1

 |  |  | CARD | Date | Balance
Card | Card 1
Today's Date | 2023-02-25 00:00:00 |  | Card 1 | 2023-01-23 00:00:00 | 265
End of Month Previous Balance | =VLOOKUP(EOMONTH(B2,-1),D2:E20,2,FALSE) |  | Card 2 | 2023-01-25 00:00:00 | 270
 |  |  | Card 3 | 2023-01-18 00:00:00 | 280.3
 |  |  | Card 1 | 2023-01-29 00:00:00 | 295.23
 |  |  | Card 2 | 2023-01-30 00:00:00 | 301.24
 |  |  | Card 3 | 2023-01-31 00:00:00 | 285.65
 |  |  | Card 1 | 2023-02-08 00:00:00 | 297.22
 |  |  | Card 2 | 2023-02-15 00:00:00 | 298.31
 |  |  | Card 3 | 2023-02-16 00:00:00 | 301.23
 |  |  | Card 1 | 2023-02-18 00:00:00 | 303.25
 |  |  | Card 2 | 2023-02-22 00:00:00 | 305.41
 |  |  | Card 3 | 2023-02-28 00:00:00 | 308.41
 |  |  | Card 1 | 2023-03-06 00:00:00 | 357.11
=VLOOKUP(EOMONTH(B2,-1),D2:E20,2,FALSE) |  |  | Card 2 | 2023-03-08 00:00:00 | 380.96
 |  |  | Card 3 | 2023-03-11 00:00:00 | 405.33
 |  |  | Card 1 | 2023-03-20 00:00:00 | 408.89
 |  |  | Card 2 | 2023-03-21 00:00:00 | 440.85
 |  |  | Card 3 | 2023-03-25 00:00:00 | 460.18
 |  |  | Card 1 | 2023-03-31 00:00:00 | 508.85
Spreadsheet: 46098d1244938612-search-and-return-value-farmingattach
Sheet: Info

Production |  |  | Warehouse |  |  | Hiding Place |  |  |  | Wood | Clay | Ore | Carry | Speed | Pop
0 | 0 |  | 0 | 0 |  | 0 | 0 |  | Spear | 50 | 30 | 10 | 25 | 18 | 1
1 | 30 |  | 1 | 1000 |  | 1 | 150 |  | Sword | 30 | 30 | 70 | 15 | 22 | 1
2 | 35 |  | 2 | 1229 |  | 2 | 200 |  | Axe | 60 | 30 | 40 | 10 | 18 | 1
3 | 41 |  | 3 | 1512 |  | 3 | 267 |  | [NAME] | 100 | 30 | 60 | 10 | 18 | 1
4 | 47 |  | 4 | 1859 |  | 4 | 356 |  | Scout | 50 | 50 | 20 | 0 | 9 | 2
5 | 55 |  | 5 | 2285 |  | 5 | 474 |  | LC | 125 | 100 | 250 | 80 | 10 | 4
6 | 64 |  | 6 | 2810 |  | 6 | 632 |  | MA | 250 | 100 | 150 | 50 | 10 | 5
7 | 74 |  | 7 | 3454 |  | 7 | 843 |  | HC | 200 | 150 | 600 | 50 | 11 | 6
8 | 86 |  | 8 | 4247 |  | 8 | 1125 |  | Ram | 300 | 200 | 200 | 0 | 30 | 5
9 | 100 |  | 9 | 5222 |  | 9 | 1500 |  | Catapult | 320 | 400 | 100 | 0 | 30 | 8
10 | 117 |  | 10 | 6420 |  | 10 | 2000 |  | Paladin | 20 | 20 | 40 | 100 | 10 | 10
11 | 136 |  | 11 | 7893 |  |  |  |  | [NAME] | 28000 | 30000 | 25000 | 0 | 35 | 100
12 | 158 |  | 12 | 9705
13 | 184 |  | 13 | 11932
14 | 214 |  | 14 | 14670 |  |  | World speed
15 | 249 |  | 15 | 18037 |  |  | 1 |  |  |  |  | Speed of unit/(world speed * unit speed) =
16 | 289 |  | 16 | 22177 |  |  | Unit Speed |  |  |  | [NAME]
17 | 337 |  | 17 | 27266 |  |  | 1
18 | 391 |  | 18 | 33523
19 | 455 |  | 19 | 41217 |  | Javascripts that will put in how many of a unit to send and where to send it. Click on cell, and click ctrl c
20 | 530 |  | 20 | 50675 |  | and then go to your internet browser. In tribal wars go to the rally point of the village you wish to send
21 | 616 |  | 21 | 62305 |  | the units from. Then in the location bar (where you type www.google.com in) paste the javascript
22 | 717 |  | 22 | 76604 |  | you copied and press enter
23 | 833 |  | 23 | 94184
24 | 969 |  | 24 | 115798
25 | 1127 |  | 25 | 142373
26 | 1311 |  | 26 | 175047
27 | 1525 |  | 27 | 215219
28 | 1774 |  | 28 | 264611
29 | 2063 |  | 29 | 325337
30 | 2400 |  | 30 | 400000
javascript:function%20end(){c='578|717';var%20d=document;if(window.frames.length>0)d=window.main.document;url[NAME]URL;if(url.indexOf('screen =place')==-1);a=c.match(/(\d+\|\d+)/g);b=a[Math.round(Math.random()*(a.length-1))].split("|");d.forms[0].x.value=b[0];d.forms[0].y.value=b[1];d.forms[0].spear.value=0;d.forms[0].sword.value=0;d.forms[0].axe.value=0;d.forms[0].spy.value=0;d.forms[0].light.value=0;d.forms[0].heavy.value=0;d.forms[0].ram.value=0;d.forms[0].catapult.value=0;d.forms[0].snob.value=0;d.forms[0].archer.value=0;d.forms[0].marcher.value=0;d.forms[0].knight.value=0;}end();
Old scripts:
Spreadsheet: e35bb453-b555-4fc1-8a17-31505ad519d4
Sheet: Sheet1

Date | Sport | Opponent | Time_Results
09/05/2009 | Football | LIBERTY | W, 33-20
09/12/2009 | Football | EAST CAROLINA | W, 35-20
09/19/2009 | Football | at Auburn | L, 30-41
10/01/2009 | Football | COLORADO | W, 35-24
10/10/2009 | Football | at Syracuse | W, 34-13
10/17/2009 | Football | [NAME] | W, 24-7
10/24/2009 | Football | CONNECTICUT | W, 28-24
10/30/2009 | Football | at USF | L, 19-30
11/07/2009 | Football | LOUISVILLE | W, 17-9
11/13/2009 | Football | at Cincinnati | L, 21-24
11/27/2009 | Football | PITT | W, 19-16
12/05/2009 | Football | at Rutgers | W, 24-21
01/01/2010 | Football | Florida State (Gator Bowl) | L, 21-33
Spreadsheet: 884778d1734039792-combining-yearly-array-data-into-a-rolling-sum-sample-2025
Sheet: 1-4

 |  |  |  |  |  |  |  |  |  |  |  | REFERRAL | Patient | Clinic | Provider
 |  |  |  |  |  |  |  |  |  |  |  |  | B2 | SS HILL [13011] | RI, MARIA [226]
 |  |  |  |  |  |  |  |  |  |  |  | x | B3 | DM FM [100110117] | FR, KREX [325]
 |  |  |  |  |  |  |  |  |  |  |  |  | B4 | DM FM [100110117] | SH, DIV [149]
 |  |  |  |  |  |  |  |  |  |  |  | X | B5 | D PT FM [1004] | TA, CHRIS [284]
 |  |  |  |  |  |  |  |  |  |  |  | X | B6 | DM FM [100200117] | EC, DORE [597]
 |  |  |  |  |  |  |  |  |  |  |  |  | B7 | SJ FM [13012] | RA, KI [173]
 |  |  |  |  |  |  |  |  |  |  |  | X | B8 | SMIT MC [11102] | RI, TREE [569]
 |  |  |  |  |  |  |  |  |  |  |  |  | B9 | SSZV [1301] | OS, AEM [286]
 |  |  |  |  |  |  |  |  |  |  |  |  | B10 | D IM [10010] | BR, MEW C [369]
 |  |  |  |  |  |  |  |  |  |  |  | X | B11 | DMUS FM [10016] | RI, MARIA [226]
Spreadsheet: 871089d1717521416-countif-statement-counting-incorrectly-help-5
Sheet: Sheet1

 |  | should be | answer from formula
 |  | 1
Claimant | Appts on holding on build | 13/05/2024 | No Appt Reason 13th | 20/05/2024 | No Appt Reason 20th | 28/05/2024 | No Appt Reason 28th | 03/06/2024 | No Appt Reason 3rd
Adsfasdmra Affan | Thursday 30 May 2024 at 10:20am | 0 |  | 0 | d | 1 | d | 0
[NAME] | Tuesday 4 June 2024 at 9:00am | 0 |  | 0 | d | 0 |  | 0
Kaydfasfode Akinwale | Thursday 6 June 2024 at 9:40am | 0 |  | 1 |  | 0 |  | 0
Spreadsheet: 692699d1598512422-split-one-colunm-in-severals-columns-in-accordance-with-criterias-attendance
Sheet: Sheet3

Working spliting
Morning |  |  |  | Afternoon |  |  |  | Night
Start |  | End |  | Start |  | End |  | Start |  | End
06:00:00 | 09:00:00 | 11:00 | 13:00 | 12:15 | 14:00 | 17:00 | 17:45 | 17:50 | 18:30 | 19:00 | 24:00
Spreadsheet: benjamin_rogers__1024__TLR Analysis
Sheet: Nov

 | TLR Max Level | Number of Incidents
 | 1 | 11
 | 2a | 0
 | 2b | 0
 | 2c | 18
 | 3 | 3
 | 4 | 0
 | 5 | 0
 | 6 | 0
 | Total
 | Curtailment | TLR level | MW Curtailed | Controller | Start Time | End Time | Total Time
1 | 1999-11-04 00:00:00 | 2a | 139 | MAIN | 01:16:00 | 03:35:00
1 | 1999-11-04 00:00:00 | 2b | 405 | MAIN | 03:35:00 | 06:00:00
1 | 1999-11-04 00:00:00 | 2c | 447 | MAIN | 06:00:00 | 08:56:00
1 | 1999-11-10 00:00:00 | 2c | 1151 | MAIN | 05:20:00 | 18:15:00
1 | 1999-11-15 00:00:00 | 3 | 40 | AEP | 00:21:00 | 08:26:00
Spreadsheet: 215454d1361384045-problem-with-date-formula-nse-holiday-2013
Sheet: Sheet1

Sr. No. | Date | Day | Description |  | 2013-03-28 00:00:00
1 | 2013-03-27 00:00:00 | Wednesday | Holi |  | 2013-09-10 00:00:00
2 | 2013-03-29 00:00:00 | Friday | Good Friday
3 | 2013-04-19 00:00:00 | Friday | [NAME]
4 | 2013-04-24 00:00:00 | Wednesday | [NAME]
5 | 2013-05-01 00:00:00 | Wednesday | May Day
6 | 2013-08-09 00:00:00 | Friday | Ramzan ID
7 | 2013-08-15 00:00:00 | Thursday | Independence Day
8 | 2013-09-09 00:00:00 | Monday | Ganesh Chaturthi
9 | 2013-10-02 00:00:00 | Wednesday | [NAME]
10 | 2013-10-16 00:00:00 | Wednesday | Bakri ID
11 | 2013-11-04 00:00:00 | Monday | Diwali-Balipratipada
12 | 2013-11-14 00:00:00 | Thursday | Moharram
13 | 2013-12-25 00:00:00 | Wednesday | Christmas
Spreadsheet: 122422d1316791195-help-charts-793621
Sheet: Sheet1

abc | xyz | abc error | xyz error
1 | 2
23 | 3
3 | err
4 | 1
4 | err
5 | 2
err | 2
3 | err
8 | 2
3 | 4
Spreadsheet: louise_kitchen__22711__North America Plan 01-09 inc AA adj (2)
Sheet: Weather

 | Weather
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002 |  |  |  |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Plan |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  | Compensation | 0
 | Analyst & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  | Total |  |  |  |  | 24109311.02937501
ENAOUTSV | Outside Services |  |  |  |  |  | 147233.52
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  |  | Intern | 33000
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 48400
ENARENT | Rent |  |  |  |  |  |  | Staff | 49500
ENATECH | Technology |  |  |  |  |  |  | Specialist | 57750
ENATRANS | Transportation |  |  |  |  |  |  | Sr. Specialist | 71500 | 1
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Analyst | 60500
ENATAXES | Taxes Other than Income |  |  |  |  |  |  | Associate | 89100
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000 | 3
 |  |  |  |  |  |  |  | Director | 143000
 | Headcount |  |  |  |  |  |  | Sr. Director | 165000
 |  |  |  |  |  |  |  | VP | 198000 | 1
 | A&A Headcount |  |  |  |  |  |  | MD | 220000
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2 |  |  |  |  | 1
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 768199d1644876986-trying-to-work-out-the-number-of-times-a-month-appears-within-a-given-date-range-chrisbus-example-dates-data
Sheet: Sheet1

Start | End | Notes - counts in
2022-01-01 00:00:00 | 2022-03-01 00:00:00 | Jan, Feb, Mar |  | 2022-01-01 00:00:00
2022-02-01 00:00:00 | 2022-04-18 00:00:00 | Feb, [NAME], Apr | Example response | 1 | 2 | 3 | 2 | 1
2022-03-01 00:00:00 | 2022-05-01 00:00:00 | Mar, Apr, May | [NAME] solution:
Spreadsheet: 739612d1625819189-count-range-with-text-if-a-certain-criteria-meet-count
Sheet: Sheet1

 | MANAGER | Claimant name |  |  | STATS BY MANAGER | count
 | [NAME] | [NAME] |  |  | [NAME] | 12
 | [NAME] | Sadaf Qureshi |  |  | [NAME] | 6
 | [NAME] | [NAME] |  |  | Sona
 | Sona | Wioletta Maruszewska |  |  | Gurjeet
 | [NAME] | Man Kapoor |  |  | Zafar | 6
 | Gurjeet | [NAME] |  |  | Nisha
 | Zafar | [NAME] |  |  | Nishi
 | [NAME] | [NAME] |  |  | Unspecified
 | Sona | nelu pufu
 | Sona | MICHAEL-ELLIOTT HAGGER
 | Sona | Ewa Brozyna
 | Sona | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | Gurjeet | [NAME]
 | [NAME] | [NAME]
 | Nisha | Rahul rai
 | Nisha | [NAME]
 | Sona | [NAME]
 | Nisha | [NAME]
 | [NAME] | [NAME]
 | Sona | [NAME]
 | Nishi | [NAME]
 | Unspecified | [NAME]
 | Zafar | [NAME]
 | [NAME] | [NAME]
 | Gurjeet | [NAME] win
 | Zafar | [NAME]
 | Zafar | Monika Jeleniewska
 | [NAME] | VICTOR CRUICKSHANK
 | [NAME] | [NAME]
 | Gurjeet | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | Zafar | [NAME]
 | Gurjeet | [NAME]
 | Zafar | [NAME]
 | [NAME] | Pramjeet Khurana
Spreadsheet: 3d2eac66-4f84-4daf-8eac-f4f82d076760
Sheet: Gamma Target

BT.1886 Caculator |  |  | a | b | vc | a1 | a2 | k | gamma
 |  |  |  |  | 0.35 | 2.6 | 3 |  | 2.4
Enter Peak white and mll values and then
adjust 10 pt controls to hit L primary targets
 |  | Y [cd/m2] |  |  |  |  | Enter 10 or 20 step grey scale Y's here
 | White | 121.5 |  | L(1.83%)
 | Black | 0.03
 | Alt_b | 0.05 | <-Adjust this to get luminance of measured
 |  |  | 1.83% pattern for alternate CRT emulation
 |  | Stimulus[%] | L Primary | L Alternate | gamma [primary] | gamma [alternate] | Measured luminance | Normalized | Measured gamma
 |  | 0.01 |  |  |  |  | 0.041703
 |  | 0.02 |  |  |  |  | 0.067194
 |  | 0.03 |  |  |  |  | 0.113235
 |  | 0.04 |  |  |  |  | 0.168965
 |  | 0.0502283105022831 |  |  |  |  | 0.25991
 |  | 0.1004566210045662 |  |  |  |  | 0.906863
 |  | 0.1506849315068493 |  |  |  |  | 1.939177
 |  | 0.2009132420091324 |  |  |  |  | 3.470132
 |  | 0.2511415525114155 |  |  |  |  | 5.35542
 |  | 0.3013698630136986 |  |  |  |  | 8.107444
 |  | 0.3515981735159817 |  |  |  |  | 11.115225
 |  | 0.4018264840182648 |  |  |  |  | 15.064519
 |  | 0.4520547945205479 |  |  |  |  | 19.923949
 |  | 0.502283105022831 |  |  |  |  | 25.086036
 |  | 0.547945205479452 |  |  |  |  | 30.706118
 |  | 0.5981735159817352 |  |  |  |  | 37.118627
 |  | 0.6484018264840182 |  |  |  |  | 43.750081
 |  | 0.6986301369863014 |  |  |  |  | 52.578807
 |  | 0.7488584474885844 |  |  |  |  | 62.701256
 |  | 0.7990867579908676 |  |  |  |  | 72.079879
 |  | 0.8493150684931506 |  |  |  |  | 83.483013
 |  | 0.8995433789954338 |  |  |  |  | 94.892588
 |  | 0.9497716894977168
 |  | 1 |  |  |  |  | 121.502147 |  |  | average
 |  |  |  |  |  |  |  |  |  | 10-100%
Note: If black levels are < 0.01 cd/m^2 BT.1886 recommends setting Black=0.0 cd/m^2 |  |  |  |  |  |  | 0.873804 | 3.42218 | 7.817614 | 14.622611 | 24.161513 | 36.417416 | 51.441887 | 70.169922 | 92.890071 | 119.051821
Peak white of alternate is fixed at 100 cd/m^2 reference
http://www.itu.int/dms_pubrec/itu-r/rec/bt/R-REC-BT.1886-0-201103-I!!PDF-E.pdf
Spreadsheet: kate_symes__18549__MeadMktplace (2)
Sheet: MeadMktplace

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME]
 | 2001-01-31 00:00:00 |  | 250 | 64 | 145 | 32
 | 2001-01-30 00:00:00 |  | 200.83 | 384 | 142.84 | 592 | 205.28 | 1618 | 135.46 | 1365
 | 2001-01-29 00:00:00 |  | 232.86 | 224 | 197.1 | 1000 | 188.91 | 2740 | 130.63 | 1506
 | 2001-01-28 00:00:00 |  | 200 | 320 | 175 | 0 | 178.38 | 3068 | 130.84 | 1999
 | 2001-01-27 00:00:00 |  | 232.14 | 560 | 159 | 1000 | 196.47 | 1231 | 125.85 | 2421
 | 2001-01-26 00:00:00 |  | 241.67 | 720 | 159 | 1000 | 198.58 | 1670 | 142.36 | 652
 | 2001-01-25 00:00:00 |  | 239.29 | 560 | 151.67 | 600 | 144.13 | 2493 | 118.25 | 883
 | 2001-01-24 00:00:00 |  | 175 | 800 | 141.17 | 1200 | 131.25 | 2165 | 106.42 | 399
 | 2001-01-23 00:00:00 |  | 260 | 400 | 175.13 | 1600 | 153.02 | 1895 | 130.64 | 179
 | 2001-01-22 00:00:00 |  | 300 | 64 | 175 | 32 | 240.14 | 2002 | 135.3 | 335
 | 2001-01-21 00:00:00 |  | 175 | 0 | 130 | 0 | 156.73 | 1457 | 156.37 | 606
 | 2001-01-20 00:00:00 |  | 454 | 800 | 275.37 | 1080 | 176.21 | 3868 | 161.24 | 270
 | 2001-01-19 00:00:00 |  | 454 | 800 | 275.37 | 1080 | 206.29 | 1390 | 133.1 | 909
 | 2001-01-18 00:00:00 |  | 429.73 | 592 | 228.64 | 1704 | 275.21 | 3577 | 187.25 | 1153
 | 2001-01-17 00:00:00 |  | 235 | 160 | 150.91 | 880 | 284 | 1630 | 156.87 | 546
 | 2001-01-16 00:00:00 |  | 174.75 | 640 | 114.61 | 1264 | 198.32 | 1393 | 118.67 | 961
 | 2001-01-15 00:00:00 |  | 174.29 | 560 | 114.61 | 1264 | 163.34 | 2155 | 121.91 | 913
 | 2001-01-14 00:00:00 |  | 135 | 160 | 102.1 | 496 | 151.06 | 2920 | 119.25 | 1375
 | 2001-01-13 00:00:00 |  | 170 | 160 | 116.65 | 1696 | 149.38 | 3307 | 112.78 | 1208
 | 2001-01-12 00:00:00 |  | 167.65 | 544 | 116 | 2136 | 146.77 | 361 | 110.31 | 1207
 | 2001-01-11 00:00:00 |  | 159.09 | 704 | 116 | 2136 | 147.18 | 1708 | 100.51 | 774
 | 2001-01-10 00:00:00 |  | 150 | 960 | 94.32 | 2280 | 140.57 | 584 | 101.31 | 555
 | 2001-01-09 00:00:00 |  | 127.81 | 1024 | 77.19 | 912 | 156.86 | 390 | 88.91 | 1464
 | 2001-01-08 00:00:00 |  | 132.55 | 1024 | 76.1 | 912 | 127.42 | 1330 | 71.95 | 583
 | 2001-01-07 00:00:00 |  | 115 | 0 | 62.5 | 0 | 63.78 | 2249 | 57.2 | 1278
 | 2001-01-06 00:00:00 |  | 124.17 | 384 | 93.8 | 432 | 102.76 | 521 | 66.24 | 647
 | 2001-01-05 00:00:00 |  | 136.45 | 1216 | 93.11 | 528 | 129.45 | 1527 | 123.46 | 455
 | 2001-01-04 00:00:00 |  | 146.87 | 2016 | 88.03 | 912 | 125.05 | 1851 | 107.45 | 778
 | 2001-01-03 00:00:00 |  | 145.65 | 544 | 75.2 | 32 | 125.71 | 1965 | 99.79 | 652
 | 2001-01-02 00:00:00 |  | 151.43 | 224 | 80 | 32 | 120.29 | 1597 | 76.99 | 944
 | 2001-01-01 00:00:00 |  |  |  |  |  | 102.04 | 432 | 64.43 | 628
Spreadsheet: 694771d1599780961-index-match-array-possibly-formula-needed
Sheet: Sheet1

Date | Name | Points | [NAME] For:
2020-07-25 16:17:25 | -Julie- | 771247
2020-09-04 08:37:00 | -Julie- | 792492
2020-05-30 10:54:54 | [NAME] | 633278
2020-08-07 16:27:33 | [NAME] | 664369
2020-08-30 10:26:24 | [NAME] | 671951
2020-09-03 18:10:56 | 1aasvik | 92840
2020-09-04 17:31:20 | 1aasvik | 92892
2020-10-04 15:01:00 | 1aasvik | 92900
2020-08-24 08:42:53 | 1kung | 2410
2020-09-09 16:35:08 | Timmo | 23668
Spreadsheet: 238590d1369638415-how-to-create-drop-down-list-to-calculate-next-column-see-the-details
Sheet: Data Setup

10 | 21
11 | 22
12 | 23
13 | 24
14 | 25
15 | 26
16 | 27
17 | 28
18 | 29
19 | 30
20 | 31