tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 834616d1687947508-how-can-i-write-a-formula-to-show-amounts-for-given-months-and-a-specific-category-insurance-expenditures-example
Sheet: Sheet1

 |  | LIFE INSURANCE POLICY's      YEAR - |  | 2023
 | Choose A Month From Below |  | AMOUNT SPENT YEAR TO DATE  ----> |  |  | Monthly Budgeted Amount | 113.41
 |  |  | AVERAGE MONTHLY  COST ---->
 |  |  | Amount Paid Current Month Month  ---->
 | 2023-01-01 00:00:00 | <----------------------Cost During Selected Month-----------------------> |  |  |  | Actual Amt Spent in January |  | Husband
 | DATE | NAME | DETAIL / DESCRIPTION / INFORMATION | AMOUNT
 | 2023-01-17 00:00:00 | (Husband) | TRANSAMERICA INSPAYMENT                Personal Policy $75,000             Policy #2 | 168.41
 | 2023-01-17 00:00:00 | (Wife) | TRANSAMERICA INSPAYMENT                Personal Policy $100,000           Policy #1 | 78.93
 | 2023-02-06 00:00:00 | (Husband) | APG Personal Policy             $150,000 Policy #4 Minnissota Life             ($135.00)        PD Quarterly! | 135 |  | Need assistance wrting a formula that will look at the entire list and provide a number amount for a given month.  The above example would be for January
 | 2023-02-06 00:00:00 | (Wife) | APG Personal Policy             $100,000 Policy #3 Minnissota Life              ($30.00)        PD Quarterly! | 15
 | 2023-02-16 00:00:00 | (Husband) | TRANSAMERICA INSPAYMENT                Personal Policy $75,000             Policy #2 | 68.41
 | 2023-02-16 00:00:00 | (Wife) | TRANSAMERICA INSPAYMENT                Personal Policy $100,000          Policy #1 | 78.93
 | 2023-03-06 00:00:00 | Individual #3 | Kristins Life Insurance ( comes out quarterly ) | 26.58
 | 2023-03-16 00:00:00 | (Husband) | TRANSAMERICA INSPAYMENT                Personal Policy $75,000             Policy #2 | 68.41
 | 2023-03-16 00:00:00 | (Wife) | TRANSAMERICA INSPAYMENT                Personal Policy $100,000          Policy #1 | 78.93
 | 2023-04-14 00:00:00 | (Husband) | TRANSAMERICA INSPAYMENT                Personal Policy $75,000             Policy #2 | 68.41
 | 2023-04-14 00:00:00 | (Wife) | TRANSAMERICA INSPAYMENT                Personal Policy $100,000          Policy #1 | 78.93
 | 2023-05-04 00:00:00 | (Husband) | APG Personal Policy             $150,000 Policy #4 Minnissota Life             ($135.00)        PD Quarterly! | 135
 | 2023-05-16 00:00:00 | (Wife) | TRANSAMERICA INSPAYMENT                Personal Policy $100,000           Policy #1 | 78.93
 | 2023-05-16 00:00:00 | (Husband) | TRANSAMERICA INSPAYMENT                Personal Policy $75,000             Policy #2 | 68.41
 | 2023-06-05 00:00:00 | Individual #3 | Kristins Life Insurance ( comes out quarterly ) | 26.58
 | 2023-06-15 00:00:00 | (Wife) | TRANSAMERICA INSPAYMENT                Personal Policy $100,000          Policy #1 | 78.93
 | 2023-06-15 00:00:00 | (Husband) | TRANSAMERICA INSPAYMENT                Personal Policy $75,000             Policy #2 | 68.41
 |  |  |  | 0
Spreadsheet: 882807d1731285353-dynamic-solution-to-get-forecast-completion-date-based-on-conditions-production-target-excelforum-jt-
Sheet: JT

 | Total | 200 |  | Date | Daily Completed Units | Cumulative Completed Units |  |  |  |  | [NAME]. # Days Break
 | Completed | 100 |  |  |  |  |  |  |  |  |  |  | Added 6 helper columns and assuming break occurs after every target is achieved and reset after the last target. Please advise if not correct.
 | On Date | 2024-02-02 00:00:00
 | Target Intervals | 1
 | Production rates
 | Starting | Per Day
 | 1 | 50
 | 151 | 10
 | 181 | 5
 | [NAME]
 | After target | Days
 | 50 | 2
 | 150 | 5
 | 180 | 3
 | Completion Date
 |  |  |  |  |  |  |  |  |  |  |  | x
Spreadsheet: 471361d1468969718-excel-calculation-problem-of-the-pi-value-nnsw-roadbase-blends-2014-15-16-1-
Sheet: MTBB20

[NAME] RTA 3051 April 2011 Mix B
 | % Passing Sieve |  |  |  |  |  |  | % Passing | Passing Specification |  | Deviation | % Retained | [NAME] |  | Deviation
Sieve mm | 20mm | 14mm | cd | 10mm | 5mm | Crun 210513 | Ammd 20mm Scalps | Blend Result | Lower | Upper | Passing | Blend Result | Lower | Upper | Retained
26.5 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 0
19 | 96 | 100 | 100 | 100 | 100 | 99 | 100 | 98.71428571428571 | 95 | 100 | 0 | 1.285714285714292
13.2 | 28 | 84 | 100 | 100 | 100 | 89 | 90 | 79.85714285714286 | 70 | 90 | 0 | 18.85714285714285 | 6 | 18 | 0.857142857142847
9.5 | 3 | 13 | 100 | 87 | 100 | 75 | 72 | 68.5 | 60 | 80 | 0 | 11.35714285714286 | 7 | 17 | 0
6.7 | 3 | 3 | 100 | 28 | 100 | 59 | 57 | 61.64285714285715 | 50 | 70 |  |  | 10 | 21
4.75 | 2 | 3 | 100 | 7 | 84 | 45 | 46 | 54.28571428571428 | 40 | 60 | 0 | 14.21428571428572 | 13 | 25 | 0
2.36 | 2 | 2 | 92 | 2 | 17 | 26 | 30 | 39.07142857142857 | 30 | 50 | 0 | 15.21428571428572 | 7 | 19 | 0
0.425 | 2 | 2 | 31 | 0 | 9 | 8 | 8 | 13.35714285714286 | 10 | 25 | 0 | 25.71428571428571 | 14 | 30 | 0
0.075 | 1 | 1 | 14 | 0 | 2 | 3 | 4 | 5.642857142857143 | 4 | 12 | 0 | 7.714285714285714 | 6 | 13 | 0
0.0135 | 0 | 0 | 3 | 0 | 0.1 | 1 | 2 | 1.292857142857143 | 3 | 7 | -1.707142857142857 | 4.350000000000001 | 3 | 8 | 0
PI |  |  |  |  |  |  |  | 0
Ratio | 3 | 0 | 4 | 0 | 1 | 6 | 0 | 14
Spreadsheet: phillip_m_love__30654__9902_OA
Sheet: STG_GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ALL
REGION:  STORAGE
 |  |  | Total |  | Reclasses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20833
2 |  | Liquidations |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
3 |  | Cost of Inventory |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -6014660 |  |  |  |  |  | -11296 |  |  |  | 3
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4: |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
23 | Fuel: |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | -22627 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -83150 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Transport Expense:
24 |  | Commodity
25 |  | Demand |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 635000 |  |  |  |  |  |  |  |  |  |  |  | -635000
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 110000
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance |  |  |  |  |  |  |  |  |  | 6921606 |  | -12923089
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  | 0
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous |  |  |  |  |  |  |  |  |  |  |  | -125739
 |  | TOTAL
Spreadsheet: 134997d1325748934-identify-cells-with-same-values-from-two-columns-book6
Sheet: Sheet1

col A | Col B | helper |  | result
F1 | F1
F2 | F4
F3 | F5
F5 | F6
F11 | F8
Spreadsheet: 215164d1361292450-sumif-for-multiple-data-test
Sheet: Sheet1

 |  |  | 1 | [NAME] | 9 |  |  |  | Total for [NAME], [NAME], [NAME], [NAME]
 |  |  | 2 | [NAME] | 8
 |  |  | 3 | [NAME] | 7
 |  |  | 4 | [NAME] | 6
 |  |  | 5 | [NAME] | 5
 |  |  | 6 | Kelly | 4
 |  |  | 7 | [NAME] | 3
 |  |  | 8 | [NAME] | 2
 |  |  | 9 | [NAME] | 1
 |  |  | 10 | Guil | 10
Spreadsheet: sally_beck__35532__EOL STATS 2001
Sheet: Sheet1

 | [NAME] | [NAME] | Total | % of EOL Deals
2001-01-01 00:00:00 | 33255 | 3736
2001-02-01 00:00:00 | 35400 | 2580
3001-03-01 00:00:00 | 38220 | 2172
 | Fin Nat Gas EOL | Fin Nat Gas Non-EOL | Total | % of EOL Deals
2001-01-01 00:00:00 | 25717 | 4716
2001-02-01 00:00:00 | 19022 | 3480
3001-03-01 00:00:00 | 19861 | 3651
 | Liquids EOL | Liquids NonEOL | Total | % of EOL Deals
2001-01-01 00:00:00 | 6022 | 578
2001-02-01 00:00:00 | 6111 | 427
3001-03-01 00:00:00 | 5867 | 555
 | Weather EOL | Weather NonEOL | Total | % of EOL Deals
2001-01-01 00:00:00 | 63 | 56
2001-02-01 00:00:00 | 60 | 38
3001-03-01 00:00:00 | 7 | 36
 | [NAME] | [NAME] | Total | % of EOL Deals
2001-01-01 00:00:00 | 6806 | 10215
2001-02-01 00:00:00 | 8123 | 9526
3001-03-01 00:00:00 | 9486 | 10801
 | Fin Pow-EOL | Fin Pow-NonEOL | Total | % of EOL Deals
2001-01-01 00:00:00 | 178 | 410
2001-02-01 00:00:00 | 294 | 361
3001-03-01 00:00:00 | 422 | 508
Spreadsheet: 80966d1281214513-transfer-columns-and-corresponding-data-to-row-format-example-origin-destination-table-bvj-
Sheet: Input

Origin
Origin | Destination1 | Destination2 | Destination3
a | 10 | 3 | 3
b | 3 | 2 | 4
c | 4 | 20 | 65
d | 1 | 2 | 10
OUTPUT
Origin | Destination | Distance
a | Destination1 | 10
b | Destination1 | 3
c | Destination1 | 4
d | Destination1 | 1
a | Destination2 | 3
b | Destination2 | 2
c | Destination2 | 20
d | Destination2 | 2
a | Destination3 | 3
b | Destination3 | 4
c | Destination3 | 65
d | Destination3 | 10
Spreadsheet: 847706d1698566021-convert-15-minute-data-to-30-minute-data-convert-interval-data
Sheet: Interval Data

Start Date Time | 15min kW Demand | 15min kWh Usage |  |  |  | Start Date Time | 30min kW Demand | 30min kWh Usage |  | Start Date Time | 30min kW Demand | 30min kWh Usage
2022-01-01 00:00:00 | 17.28 | 4.32 |  | >>> Avg the 15min Demand over 30 min |  |  |  |  |  | 2022-01-01 00:00:00 | 15.84 | 7.92
2022-01-01 00:15:00 | 14.4 | 3.6 |  | and [NAME] the 15 min Usage over 30 min >>> |  |  |  |  |  | 2022-01-01 00:30:00 | 16.13 | 8.06
2022-01-01 00:30:00 | 16.13 | 4.03 |  |  |  |  |  |  |  | 2022-01-01 01:00:00 | 15.84 | 7.92
2022-01-01 00:45:00 | 16.13 | 4.03 |  |  |  |  |  |  |  | 2022-01-01 01:30:00 | 15.84 | 7.92
2022-01-01 01:00:00 | 15.55 | 3.89 |  |  |  |  |  |  |  | 2022-01-01 02:00:00 | 15.55 | 7.78
2022-01-01 01:15:00 | 16.13 | 4.03 |  |  |  |  |  |  |  | 2022-01-01 02:30:00 | 15.55 | 7.78
2022-01-01 01:30:00 | 15.55 | 3.89 |  |  |  |  |  |  |  | 2022-01-01 03:00:00 | 15.84 | 7.92
2022-01-01 01:45:00 | 16.13 | 4.03 |  |  |  |  |  |  |  | 2022-01-01 03:30:00 | 15.84 | 7.92
2022-01-01 02:00:00 | 15.55 | 3.89 |  |  |  |  |  |  |  | 2022-01-01 04:00:00 | 14.975 | 7.49
2022-01-01 02:15:00 | 15.55 | 3.89 |  |  |  |  |  |  |  | 2022-01-01 04:30:00 | 14.69 | 7.34
2022-01-01 02:30:00 | 15.55 | 3.89 |  |  |  |  |  |  |  | 2022-01-01 05:00:00 | 15.55 | 7.78
2022-01-01 02:45:00 | 15.55 | 3.89 |  |  |  |  |  |  |  | 2022-01-01 05:30:00 | 14.975 | 7.49
2022-01-01 03:00:00 | 16.13 | 4.03
2022-01-01 03:15:00 | 15.55 | 3.89
2022-01-01 03:30:00 | 16.7 | 4.18
2022-01-01 03:45:00 | 14.98 | 3.74
2022-01-01 04:00:00 | 13.82 | 3.46
2022-01-01 04:15:00 | 16.13 | 4.03
2022-01-01 04:30:00 | 14.98 | 3.74
2022-01-01 04:45:00 | 14.4 | 3.6
2022-01-01 05:00:00 | 15.55 | 3.89
2022-01-01 05:15:00 | 15.55 | 3.89
2022-01-01 05:30:00 | 14.4 | 3.6
2022-01-01 05:45:00 | 15.55 | 3.89
Spreadsheet: thomas_martin__39654__2001 Plan 105977
Sheet: Headcount

E N R O N   N O R T H   A M E R I C A
2 0 0 1   P L A N |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H E A D C O U N T
SAP PROFIT CENTER: |  | Gas Control
PROFIT CENTER OWNER: |  | [NAME]
SAP COST CENTER: |  | 105977 |  |  |  |  |  |  |  |  |  |  | DUE DATE: | August 30th
 |  |  |  |  |  |  |  |  |  |  |  |  | E-mail to [NAME] ext (3-9021)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Annual
STAFFING SUMMARY | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00 | Expense
Executive | 1
Director | 1
Manager | 1
Non-Commercial Executive
Non-Commercial Director | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Non-Commercial Manager | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Associates | 1
Analysts | 1
Other Commercial | 1
Other Non-Commercial | 1 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7
Administrative Assistants |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Subtotal Headcount
Contractors | 1
TOTAL HEADCOUNT
PLEASE LIST ALL INDIVIDUALS AND VACANCIES WITHIN YOUR COST CENTERS.
EXAMPLE: Do use exact Staffing Summary descriptions as noted on this template.
Name |  | Staffing Summary
[NAME] |  | Non-Commercial Director
[NAME] |  | Non-Commercial Manager
[NAME] |  | Other Non-Commercial
[NAME] |  | Other Non-Commercial
[NAME] |  | Other Non-Commercial
[NAME] |  | Other Non-Commercial
[NAME] |  | Other Non-Commercial
[NAME] |  | Other Non-Commercial
[NAME] |  | Other Non-Commercial
[NAME] |  | Administrative Assistants
Spreadsheet: eaa8fefc-bbec-4a0d-995e-8d74305f03e4
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
233.3172948409516
Schematic
Enter required parameter
Device: | System parameter | Unit | Value | Note
Cable | Cable length | [m] | 250 | Cable length of the required power QUAD cable
Source | Voltage power supply | [V] | 240 | Input voltage on source side (e.g. 240V)
Device A | Voltage | [V] | 110 | Voltage from device A (e.g. power adapter 110V…230V)
 | Current | [A] | 1 | Current from device A  (e.g. power adapter [NAME] 16A)
Device B | Voltage | [V] |  | Voltage from device B (e.g. power adapter 110V…230V)
 | Current | [A] |  | Current from device B  (e.g. power adapter [NAME] 16A)
Device C | Voltage | [V] |  | Voltage from device C (e.g. power adapter 110V…230V)
 | Current | [A] |  | Current from device C  (e.g. power adapter [NAME] 16A)
Device D | Voltage | [V] |  | Voltage from device D (e.g. power adapter 110V…230V)
 | Current | [A] |  | Current from device D  (e.g. power adapter [NAME] 16A)
Device E | Voltage | [V] |  | Voltage from device E (e.g. power adapter 110V…230V)
 | Current | [A] |  | Current from device E  (e.g. power adapter [NAME] 16A)
Results:
Cable parameter | Unit | Value | Note
Conductivity | [% IACS] | 86 | Adjust the cable length till cable status  indicates PASSED
Wire Diameter | [mm²] | 1.5
Copper Resistance Rcu | [Ω] | 3.341352579524191
Voltage Drop ΔU | [V] | 6.682705159048382
Maximum voltage (Device | [V] | 110
Required Current (Device) | [A] | 1
Voltage | [V] | 233.3172948409516
Current | [A] | 16
Cable status |  | PASSED
Spreadsheet: 811058d1672250427-auto-fill-dates-on-monthly-time-sheets-time-sheet-test
Sheet: TIME SHEET

FOR EXEMPT SALARIED EMPLOYEES SUBJECT TO OVERTIME
NAME: |  |  |  |  |  |  |  | EMPLOYEE ID:
DIVISION: |  |  |  |  |  |  |  | DEPT:
LOCATION: |  |  |  |  |  |  |  | NORMAL SCHEDULED NUMBER OF HOURS:
Month of (MM:YYYY) |  |  |  |  |  |  |  | PER DAY | H:[NAME] |  | PER WEEK | H:[NAME]
WEEK OF | Regular Hours Worked |  | Overtime Hours Worked |  | Lunch | Total Hours |  | WEEK OF | Regular Hours Worked |  | Overtime Hours Worked |  | Lunch | Total Hours
 | From | To | From | To | H:[NAME] |  |  |  | From | To | From | To | H:[NAME]
Mon. |  |  |  |  |  |  |  | Mon.
[NAME]. |  |  |  |  |  |  |  | [NAME].
Wed. |  |  |  |  |  |  |  | Wed.
Thurs. |  |  |  |  |  |  |  | Thurs.
Fri. |  |  |  |  |  |  |  | Fri.
Sat. |  |  |  |  |  |  |  | Sat.
Sun. |  |  |  |  |  |  |  | Sun.
Week's Total Hours |  |  |  |  |  |  |  | Week's Total Hours
WEEK OF | Regular Hours Worked |  | Overtime Hours Worked |  | Lunch | Total Hours |  | WEEK OF | Regular Hours Worked |  | Overtime Hours Worked |  | Lunch | Total Hours
 | From | To | From | To | H:[NAME] |  |  |  | From | To | From | To | H:[NAME]
Mon. |  |  |  |  |  |  |  | Mon.
[NAME]. |  |  |  |  |  |  |  | [NAME].
Wed. |  |  |  |  |  |  |  | Wed.
Thurs. |  |  |  |  |  |  |  | Thurs.
Fri. |  |  |  |  |  |  |  | Fri.
Sat. |  |  |  |  |  |  |  | Sat.
Sun. |  |  |  |  |  |  |  | Sun.
Week's Total Hours |  |  |  |  |  |  |  | Week's Total Hours
WEEK OF | Regular Hours Worked |  | Overtime Hours Worked |  | Lunch | Total Hours |  | RECAP OF HOURS WORKED
 | From | To | From | To | H:[NAME] |  |  | STRAIGHT TIME |  |  |  |  | 9A0A
Mon.
[NAME].
Wed. |  |  |  |  |  |  |  | 1904-01-06 00:00:00
Thurs.
Fri.
Sat. |  |  |  |  |  |  |  | OTHER
Sun.
Week's Total Hours
 |  |  |  |  |  |  |  | TOTAL OVERTIME HOURS
NOTICE:
Whenever overtime is worked, a record of the total hours worked each work-day and work-week is required for each employee and is subject
to the Overtime provisions of the Fair Labor Standards Act, and/or the detailed hours worked as required by certain States.  No such employee
is permitted to work overtime either in the office or at home on Company business without the express authority of the Department having
jurisdiction. Include only full weeks ending on Sunday.
I HEREBY CERTIFY THAT I WORKED THE HOURS SET FORTH IN THE ABOVE SCHEDULE.
SIGNED:
 |  | EMPLOYEE
APPROVED:
 |  | AUTHORIZED SIGNATURE
Spreadsheet: 08abd120-b6ea-4b4f-88d3-f0dbfb36c141
Sheet: Sheet1

Calculation of points for the FAI World Cup competition classes F3B, F3F, F3J, [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
depending on the number of competitors
Ranking | Maximum |  | Number of |  | Calculated | Rounded | Points
 | points |  | competitors |  | points | points
 | if the number |  | 4 ≤ x ≤ 50
 | of competitors
 | [NAME] 50
1 | 50 |  | 25 | 25 | 37.5 | 37 | 37
2 | 40 |  |  |  | 27.5 | 27 | 27
3 | 30 |  |  |  | 17.5 | 17 | 17
4 | 25 |  |  |  | 12.5 | 12 | 12
5 | 20 |  |  |  | 7.5 | 7 | 7
6 | 19 |  |  |  | 6.5 | 6 | 6
7 | 18 |  |  |  | 5.5 | 5 | 5
8 | 17 |  |  |  | 4.5 | 4 | 4
9 | 16 |  |  |  | 3.5 | 3 | 3
10 | 15 |  |  |  | 2.5 | 2 | 2
11 | 14 |  |  |  | 1.5 | 1 | 1
12 | 13 |  |  |  | 0.5 | 0 | 0
13 | 12 |  |  |  | -0.5 | 0 | 0
14 | 11 |  |  |  | -1.5 | -1 | 0
15 | 10 |  |  |  | -2.5 | -2 | 0
16 | 9 |  |  |  | -3.5 | -3 | 0
17 | 8 |  |  |  | -4.5 | -4 | 0
18 | 7 |  |  |  | -5.5 | -5 | 0
19 | 6 |  |  |  | -6.5 | -6 | 0
20 | 5 |  |  |  | -7.5 | -7 | 0
21 | 4 |  |  |  | -8.5 | -8 | 0
22 | 3 |  |  |  | -9.5 | -9 | 0
23 | 2 |  |  |  | -10.5 | -10 | 0
24 | 1 |  |  |  | -11.5 | -11 | 0
 |  |  | Pmax = 50 – 0.5 x (50 – number „X“ of competitors)  with “X” ≤ 50; the results are rounded down
Spreadsheet: 606361d1547579905-sum-across-specified-columns-with-specific-conditions-sumfunction
Sheet: TestData

Age | Total1 |  |  | Total2 |  |  | Total3 |  |  | Total4 |  |  | Total
 | M | F | Tot | M | F | Tot | M | F | Tot | M | F | Tot | M | F | Tot
1 | 3/3 | 3/3 | 6/6 | 4/3 | 4/3 | 8/6 | 1/3 | 2/3 | 3/6 | 2/3 | 3/3 | 5/6
2 | 3/3 | 3/3 | 6/6 | 2/3 | 2/3 | 4/6 | 3/3 | 2/3 | 5/6 | 4/3 | 3/3 | 7/6
3 | 3/3 | 3/3 | 6/6 | 3/3 | 3/3 | 6/6 | 2/3 | 2/3 | 4/6 | 2/3 | 3/3 | 5/6
4 | 3/3 | 3/3 | 6/6 | 2/3 | 1/3 | 3/6 | 3/3 | 3/3 | 6/6 | 2/3 | 2/3 | 4/6
5 | 1/3 | 1/3 | 2/6 | 2/3 | 2/3 | 4/6 | 3/3 | 3/3 | 6/6 | 2/3 | 3/3 | 5/6
Total | 13/15 | 13/15 | 26/30 | 13/15 | 12/15 | 25/30 | 12/15 | 12/15 | 24/30 | 12/15 | 14/15 | 26/30
DESIRED RESULT
Age | Total1 |  |  | Total2 |  |  | Total3 |  |  | Total4 |  |  | Total
 | M | F | Tot | M | F | Tot | M | F | Tot | M | F | Tot | M | F | Tot
1 | 3/3 | 3/3 | 6/6 | 4/3 | 4/3 | 8/6 | 1/3 | 2/3 | 3/6 | 2/3 | 3/3 | 5/6 | 10/12 | 12/12 | 22/24
2 | 3/3 | 3/3 | 6/6 | 2/3 | 2/3 | 4/6 | 3/3 | 2/3 | 5/6 | 4/3 | 3/3 | 7/6 | 12/12 | 10/12 | 22/24
3 | 3/3 | 3/3 | 6/6 | 3/3 | 3/3 | 6/6 | 2/3 | 2/3 | 4/6 | 2/3 | 3/3 | 5/6 | 10/12 | 11/12 | 21/24
4 | 3/3 | 3/3 | 6/6 | 2/3 | 1/3 | 3/6 | 3/3 | 3/3 | 6/6 | 2/3 | 2/3 | 4/6 | 10/12 | 9/12 | 19/24
5 | 1/3 | 1/3 | 2/6 | 2/3 | 2/3 | 4/6 | 3/3 | 3/3 | 6/6 | 2/3 | 3/3 | 5/6 | 8/12 | 9/12 | 17/24
Total | 13/15 | 13/15 | 26/30 | 13/15 | 12/15 | 25/30 | 12/15 | 12/15 | 24/30 | 12/15 | 14/15 | 26/30
Spreadsheet: 701727d1603897330-excel-returning-specific-number-of-matching-results-auditing-exampl-aggregate
Sheet: Filter 3

 |  | Unique Associates | Number of cases to assign
 |  |  | 3
 |  |  | 3
 |  |  | 3
 |  |  | 3
 |  |  | 3
 |  |  | 3
 |  |  | 3
 |  |  | 3
 |  |  | 3
 |  |  | 3
 |  |  | 3
 |  |  | 3
 |  |  | 3
 |  |  | 3
 |  |  | 3
 |  |  | 3
 |  |  | 3
 |  |  | 3
Associate name | SLR number | associate_task | associate_queue | associate |  | associate_resolve_time | metric_wk_no | associate_action | investigator_task | investigator_queue | investigator |  | investigator_resolve_time |  | country | merchant_program_at_reg
Spreadsheet: 713796d1610942589-help-with-index-match-formula-for-multiple-occurances-of-same-value-sample
Sheet: Sheet1

S | S2 | MN | HT | AT | HTE Pre | HEC | HT Post | [NAME] | AEC | ATE Post
1 | 11 | 1 | SS | BH | 1500 | 29.29642803391735 |  | 1500 | -29.29642803391735
1 | 11 | 2 | MS | ST | 1500 | -23.52726870502823 |  | 1500 | 23.52726870502823
1 | 11 | 3 | AS | MR | 1500 | 42.67866191409707 |  | 1500 | -42.67866191409707
1 | 11 | 4 | PS | HH | 1500 | -34.96518324006727 |  | 1500 | 34.96518324006727
1 | 11 | 5 | BH | MS |  | -23.84781817881768 |  |  | 23.84781817881768 |  | <---- for the value in col F, look for previous value if "BH", which occurs in E2, so return the value in K2 (1471). |  |  |  |  |  |  |  |  |  |  | <---- for the value in col I, look for previous value if "MS", which occurs in D3, so return the value in H3 (1476).
1 | 11 | 6 | HH | SS |  | 39.9297942749922 |  |  | -39.9297942749922 |  | <---- for the value in col F, look for previous value of "HH", which occurs in E5, so return the value in K5 (1535). |  |  |  |  |  |  |  |  |  |  | <---- for the value in col F, look for previous value of "SS", which occurs in [NAME], so return the value in H2 (1529).
1 | 11 | 7 | MR | PS |  | -24.78992448663707 |  |  | 24.78992448663707
1 | 11 | 8 | ST | AS |  | 26.48117259005272 |  |  | -26.48117259005272
1 | 11 | 9 | SS | MS |  | 12.13118615720454 |  |  | -12.13118615720454
1 | 11 | 10 | AS | HH |  | -27.01002578225024 |  |  | 27.01002578225024
1 | 11 | 11 | PS | BH |  | 24.38433818337041 |  |  | -24.38433818337041
1 | 11 | 12 | ST | MR |  | -23.40144067551291 |  |  | 23.40144067551291
1 | 11 | 13 | HH | ST |  | 25.84525684070635 |  |  | -25.84525684070635 |  | <---- for the value in col F, look for previous value of "MR", which occurs in E13, so return the value in K13 (1456). |  |  |  |  |  |  |  |  |  |  | <---- for the value in col I, look for previous value of "ST", which occurs in D12, so return the value in H12 (1514).
1 | 11 | 14 | MR | SS |  | 31.08850314147424 |  |  | -31.08850314147424 |  | <---- for the value in col F, look for previous value of "MR", which occurs in E13, so return the value in K13 (1456). |  |  |  |  |  |  |  |  |  |  | <---- for the value in col F, look for previous value of "SS", which occurs in D10, so return the value in H10 (1501).
 |  |  |  |  |  |  |  |  |  |  | THESE LAST 2 HIGHLIGHTED IN YELLOW DO NOT RETURN THE CORRECT VALUE