tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 02941c6c-45b5-4922-93a4-5c11f5deb217
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | IMPERIAL VALLEY COLLEGE | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  | WOMEN'S SOCCER
 |  | ROSTER
 |  | FALL 2013
 | No. | NAME | YEAR | HIGH SCHOOL | POSITION
 | 3 | Amezcua, [NAME] | FROSH | [NAME] | DEF
 | 5 | Arceo, Carolina | FROSH | BUHS | MID
 | 10 | Clautro, [NAME] | SOPH | BUHS | MID
 | 22 | De Dios Lopez, [NAME] | FROSH | CALEX | MID
 | 20 | Escobedo, April | FROSH | [NAME] | DEF
 | 1 | Espinoza, [NAME] | FROSH | CALEX | GK
 | 11 | Flores, [NAME] | FROSH | IMPERIAL | DEF
 | 6 | [NAME], Morgan A | SOPH | WESTMORLAND BASIC CHRISTIAN SCHOOL | DEF
 | 14 | Hernandez, [NAME] | FROSH | HOLT | MID
 | 15 | Medina, Olivia J | FROSH | RAILEY | MID
 | 9 | Mendez, Jaqueline | FROSH | [NAME] | FW
 | 21 | Navarro, Arlette P | FROSH | [NAME] | MID
 | 17 | Ortiz, [NAME] R | FROSH | S.WEST | MID
 | 13 | Ortiz, [NAME] | SOPH | [NAME] | FW
 | 2 | [NAME], [NAME] | SOPH | IMPERIAL | D/MID
 | 16 | Rocha, [NAME] | PROSH | S.WEST | DEF
 | 7 | Soto, [NAME] | FROSH | BUHS | DEF
 | 19 | Urias, Celeste S | FROSH | HOLT | DEF
 | 23 | Valadez, Tannya | FROSH | CALEX | D/MID
 | 8 | [NAME], Ilse A | SOPH | [NAME] | MID
 | [NAME] |  | Head Coach | (760) 355 - 6325
 | [NAME] |  | Assistant Coach | (760) 355 - 6325
 | [NAME] |  | Athletic Director | (760) 355 - 6341
 | [NAME] |  | Secretary | (760) 355 - 6325
 | [NAME] Mays |  | Athletic Trainer | (760) 355-6329
 |  |  | Athletic Fax | (760) 355 - 6514
 |  |  | Athletic Department 380 East Aten Rd. Imperial, CA 92251
Spreadsheet: 161894d1339669662-excel-2007-formula-counting-double-data-entries-as-one-copy-of-copy-of-count1
Sheet: Countif

 |  |  |  |  | Marcol |  |  | romperstomper |  |  | dewilk
 |  |  |  | Data | Counting | 14 |  | Counting | 14 |  | Expected Result | 14
 |  |  |  | 15 | 1 |  |  | 1 |  |  | 1
 |  |  |  | 15 | 1 |  |  | 1 |  |  | 1
 |  |  |  | 30 | 2 |  |  | 2 |  |  | 2
 |  |  |  | 30 | 2 |  |  | 2 |  |  | 2
 |  |  |  | 60 | 3 |  |  | 3 |  |  | 3
 |  |  |  | 110 | 4 |  |  | 4 |  |  | 4
 |  |  |  | 125 | 5 |  |  | 5 |  |  | 5
 |  |  |  | 125 | 5 |  |  | 5 |  |  | 5
 |  |  |  | 31 | 6 |  |  | 6 |  |  | 6
 |  |  |  | 75 | 7 |  |  | 7 |  |  | 7
 |  |  |  | 76 | 8 |  |  | 8 |  |  | 8
 |  |  |  | 80 | 9 |  |  | 9 |  |  | 9
 |  |  |  | 90 | 10 |  |  | 10 |  |  | 10
 |  |  |  | 95 | 11 |  |  | 11 |  |  | 11
 |  |  |  | 95 | 11 |  |  | 11 |  |  | 11
 |  |  |  | 65 | 12 |  |  | 12 |  |  | 12
 |  |  |  | 65 | 12 |  |  | 12 |  |  | 12
 |  |  |  | 102 | 13 |  |  | 13 |  |  | 13
 |  |  |  | 111 | 14 |  |  | 14 |  |  | 14
 |  |  |  | 111 | 14 |  |  | 14 |  |  | 14
Spreadsheet: 858405d1707121988-options-in-filter-arent-alphabetical-examplenumeric
Sheet: Sheet3

Artikel | Kolom1 | Artikelgroep
4 | A | 700 |  |  |  |  |  |  | Row Labels
5 | B | 300 |  |  |  |  |  |  | 4
6 | A | 710 |  |  |  |  |  |  | 5
7 | A | 564 |  |  |  |  |  |  | 6
9 | E | 300 |  |  |  |  |  |  | 7
14 | D | 300 |  |  |  |  |  |  | 9
16 | C | 300 |  |  |  |  |  |  | 14
19 | C | 300 |  |  |  |  |  |  | 16
20 | A | 300 |  |  |  |  |  |  | 19
21 | D | 850 |  |  |  |  |  |  | 20
46 | A | 300 |  |  |  |  |  |  | 21
125 | D | 300 |  |  |  |  |  |  | 46
62 | F | 564 |  |  |  |  |  |  | 62
63 | D | 210 |  |  |  |  |  |  | 63
66 | A | 310 |  |  |  |  |  |  | 66
72 | D | 564 |  |  |  |  |  |  | 72
73 | E | 800 |  |  |  |  |  |  | 73
89 | C | 200 |  |  |  |  |  |  | 89
97 | C | 100 |  |  |  |  |  |  | 97
98 | B | 300 |  |  |  |  |  |  | 98
99 | B | 564 |  |  |  |  |  |  | 99
100 | D | 710 |  |  |  |  |  |  | 100
101 | F | 700 |  |  |  |  |  |  | 101
105 | A | 900 |  |  |  |  |  |  | 105
106 | D | 120 |  |  |  |  |  |  | 106
108 | B | 200 |  |  |  |  |  |  | 108
 |  |  |  |  |  |  |  |  | 125
 |  |  |  |  |  |  |  |  | Grand Total
Spreadsheet: phillip_m_love__30683__onsys forms 0003
Sheet: Devon-Nevada

Devon Energy Corporation
Contract: various | 2000-03-01 00:00:00
 | CPR estimate | Actual Payment | [NAME] | UA 4 RATE
[NAME] | 0 | 0
VALUE | 0 | -92052
NET RATE |  |  |  | 2.54
Volume Variance:
 | 0 | =D8 (Volume Variance) * (B12-E12) CPR Price less UA 4 Rate
Rate Variance:
 | 92052 | =(B8+D8) Actual [NAME] * (C12-B12) Actual Price less CPR Price
 | TOTAL IMPACT TO INCOME:
 |  | =Volume [NAME]
 |  | Check Figure = ((D10/D8) less E12 UA 4 Rate) * D8
CHECK FIGURE |  | ($1,526,969)/(446,480) LESS $1.947 (UA4 RATE) BY (446,480MMBTU)
Note:
Liquidation only
Spreadsheet: 20ea4aa3-2ee0-4326-acf3-e0cb8428cfe9
Sheet: Instructions

Instructions for CRP Plan Sheet Usage
1. Go to the tab named 'Signature Page'
2. Enter Contract Name, County, Contract Number and Total Acres
This will transfer these items to all worksheet pages.
3. Go to the appropriate worksheet page for the planned practice
4. Enter the Tract number and acres of the practice for each component.
NOTE:  Some components do not have a cost shown on the worksheet I.E. Lime and Fertilizer per Soil Test.
You will need to enter the cost for these items in the Component List tab.
5. Do this for each practice on the tract.
6. The spreadsheet will automatically total the cost-sharing for each practice and the total cost-share for the contract.
Note: If hardwood trees are being planted over more than one year, the cost share entries and year will need to be typed in
order for them to be correct.
Be sure to save a copy of this spreadsheet with no tract information entered so that you will always have a blank one
to start from.
REMEMBER:  YOU ARE REQUIRED TO ENTER THE PRACTICE LAYER IN TOOLKIT AS A PLAN LAYER!
ALSO: BE SURE TO NOTIFY LANDOWNERS THAT THESE COSTS ARE ESTIMATES AND MAY CHANGE!
Producers need to refer to the FSA contract for exact dollar figures.
AD-1156 is included in this spreadsheet.  It is found between the CP33 tab and the Component List tab. Only the
header information is automatically populated.
Pen-and-ink changes are allowed for the following:
Rescheduling mid-management
Adding or changing contract number
Adding or deleting participants
Changing the year of practice implementation
Changing the quantity or dollar amount of a component code
Modifications (AD-1156) should be made for:
Switching to a different mid-management practice
Spreadsheet: 782692d1654186060-updated-splitting-a-lookup-value-among-several-rows-and-conditional-formatting-based-sold-data-example-1
Sheet: AR Query

GD_PRIME | GD_PERIOD_DATE | GD_REFERENCE_2 | GD_REFERENCE_1 | GD_AMOUNT | GD_REFERENCE_3 | GD_POST_DATE | GD_COMMENTS | GD_LEDGER | GD_DESC_CODE | Receivable | [NAME]
11000 | 2022-05-10 00:00:00 | M09426 | 172370 | -5830 | 05102022 | 2022-05-11 00:00:00 | AURORA AUTO WORKS LLC | A/R | P3
11000 | 2022-05-10 00:00:00 | M09465 | 5262 | -15995 | 13598 | 2022-05-11 00:00:00 | PACKAGING PRODUCTS | A/R | P3
11000 | 2022-05-10 00:00:00 | M09546 | 392780 | -106 | VI051022 | 2022-05-11 00:00:00 | FROM ME 2 YOU, LLC | A/R | V3
11000 | 2022-05-10 00:00:00 | M09465 | 5262 | -2500 | 050585MP | 2022-05-11 00:00:00 | PACKAGING PRODUCTS | A/R | WD
11000 | 2022-05-13 00:00:00 | M09539 | 130815 | -2120 | 20829 | 2022-05-16 00:00:00 | EUREKA ROAD FARM MARKET | A/R | P3
11000 | 2022-05-19 00:00:00 | H04434 | 382580 | -66988 | 95113268 | 2022-05-20 00:00:00 | FERROUS PROCESSING & TRADING | A/R | P3
11000 | 2022-05-19 00:00:00 | H04433 | 382580 | -66988 | 95113268 | 2022-05-20 00:00:00 | FERROUS PROCESSING & TRADING | A/R | P3
11000 | 2022-05-19 00:00:00 | [NAME] | 365885 | -10912.7 | 1958553 | 2022-05-20 00:00:00 | PRAIRIE [NAME] DAIRY | A/R | P3
11000 | 2022-05-20 00:00:00 | M09534 | 785880 | -26494.7 | 73020640 | 2022-05-23 00:00:00 | SYNVENTIVE MOLDING SOLUTIONS | A/R | P3
11000 | 2022-05-20 00:00:00 | [NAME] | 365885 | 2697.7 | 051085MP | 2022-05-23 00:00:00 | PRAIRIE [NAME] DAIRY | A/R | WD
11000 | 2022-05-23 00:00:00 | T00272 | 429509 | -14804.49 | 7753 | 2022-05-24 00:00:00 | HEARN INDUSTRIAL | A/R | P3
11000 | 2022-05-24 00:00:00 | M09558 | 829655 | -11995 | 208166 | 2022-05-25 00:00:00 | WASHTENAW INTERMEDIATE | A/R | P3
11000 | 2022-05-24 00:00:00 | H04554 | 6641 | -23850 | 42126 | 2022-05-25 00:00:00 | VALUE WORLD | A/R | P3
11000 | 2022-05-26 00:00:00 | [NAME] | 382440 | -14102.28 | AC052622 | 2022-05-27 00:00:00 | FERNCO - 300234 | A/R | P3
11000 | 2022-05-26 00:00:00 | H04560 | 782330 | -42750 | 302563 | 2022-05-27 00:00:00 | SUPERIOR MATERIALS | A/R | P3
11000 | 2022-05-26 00:00:00 | M09547 | 216890 | -10594.7 | 1035 | 2022-05-27 00:00:00 | BOMBSHELL TRUCKING | A/R | P3
Spreadsheet: larry_campbell__21029__BrownfieldPTE
Sheet: LOAD

NORTHERN NATURAL GAS COMPANY
BROWNFIELD COMPRESSOR STATION
TNRCC ACCOUNT NO. TD-0063-I
Storage Tank Potential To Emit
 |  | [NAME] | AVE. | AVG. VAPOR | SAT. | ANNUAL | LOADING
EPN: | PRODUCT | Wt | TEMP. | PRESSURE | FACTOR | THROUGHPUT | EMISSIONS
 |  | (lb/lb-mol) | deg F | psia |  | gals/year | tons/yr
LOAD | CONDENSATE | 68 | 65.56 | 4.1 | 0.6
Note:
(1) Annual throughput conservatively estimated.
(2) Physical data estimated.
Spreadsheet: 726536d1617286433-populate-text-from-other-sheet-based-on-number-or-word-entered-excelforum1345728reminders
Sheet: Example 2

Reminders
 |  | 2
Duty |  | Name | Signature
 |  | [NAME]
 | W/M | Ally
Detail Instructions |  | Dre
Weekly Minder: | 2 | [NAME]
Wall washing |  | [NAME]
 |  | Jordan
Lifting |  | [NAME]
 |  | [NAME]
Safety Minder: | 2 | Venus
Team work |  | Serena
 |  | Willie
Ask questions |  | [NAME]
 |  | Sandy
Customer Service: | 2 | Reed
[NAME] |  | [NAME]
 |  | Louis
 |  | [NAME]
 |  | [NAME]
Managers | 2 | [NAME]
Requests |  | Kenny
 |  | [NAME]
Onboarding |  | Blake
 |  | Chirs
Monthly Chat | January | Kris
Be kind |  | [NAME]
 |  | Shay
Golden rule |  | Destiny
 |  | [NAME]
 |  | CJ
 |  | [NAME]
 |  | Maria
 |  | Holly
 |  | [NAME]
 |  | [NAME]
Approved By
Week Ending Date
 |  |  |  |  |  | 1
Spreadsheet: darron_c_giron__7951__estate positions 1-30-02
Sheet: Financial Book Position

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ESTATE FINANCIAL POSITIONS
TIME BUCKET/KEY: |  |  | REPORT REGION | RISK TYPE | 1 |  | 2 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14 |  | 14
(Positions in Cont. [NAME].)     From: | Post ID |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2003-04-02 00:00:00 |  |  |  |  |  |  | Total ECT
To: | Order |  |  |  |  |  | Index |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2003-03-03 00:00:00 |  | 2003-10-01 00:00:00 |  | 2004-03-04 00:00:00 |  | 2005-03-01 00:00:00 |  | 2025-08-01 00:00:00
Price Book - In the Money Counterparties
Gas Daily |  |  |  |  | 0.6 |  |  |  | -60.1 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Gas Daily Index |  |  |  |  | 0 |  | -28 |  | -28 |  | -93.8 |  | -29.9 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0 |  |  |  | 0 |  | 0
Basis - Notional | 3 |  | NGLTX | P | 0 |  |  |  | -1943.5 |  | -2401 |  | -154.9 |  | -39.5 |  | -9 | 0 | -6.8 |  | -4.5 |  | 0.1 |  | 148 |  | 1878.83 |  | 1166.93 |  | 536.99 |  | 1077.61 |  | 13.52
Basis - Equivalent | 4 |  | NGFPL | P | 0 |  |  |  | 101.4 |  | 115.9 |  | 7.1 |  | 2.7 |  | 0.6 | 0 | 0.9 |  | -11.4 |  | -0.3 |  | -11.4 |  | 19.9 |  | 22.1979 |  | 22.2626 |  | 44.2335 |  | 112.344
Price | 5 |  | NGFPL | D | 0 |  |  |  | -2252.1 |  | -893.8 |  | -1036 |  | -933.3 |  | -786.6 |  | -633.7 |  | -517.4 |  | -568.1 |  | -14.89 |  | -8.41 |  | 191.93 |  | -810.85 |  | 1819.65 |  | 2736.06
TOTAL:
TIME BUCKET/KEY: |  |  | REPORT REGION | RISK TYPE | 1 |  | 2 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14 |  | 14
(Positions in Cont. [NAME].)     From: | Post ID |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2003-04-02 00:00:00 |  |  |  |  |  |  | Total ECT
To: | Order |  |  |  |  |  | Index |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2003-03-03 00:00:00 |  | 2003-10-01 00:00:00 |  | 2004-03-04 00:00:00 |  | 2005-03-01 00:00:00 |  | 2025-08-01 00:00:00
Price Book - Out of the Money Counterparties
Gas Daily |  |  |  |  | -0.7 |  |  |  | -167 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Gas Daily Index |  |  |  |  | 0
Basis - Notional | 3 |  | NGLTX | P | 0 |  |  |  | -1508.98 |  | -872.995 |  | -764.911 |  | -478.367 |  | -108.958 |  | -19.3159 |  | 46.7279 |  | -127.249 |  | -234.443 |  | -2059.1585 |  | -2418.891072 |  | -2913.993 |  | -5393.42677 |  | -15917.29329
Basis - Equivalent | 4 |  | NGFPL | P | 0 |  |  |  | -84.686 |  | 27.6177 | 0 | 31.68327 | 0 | 29.10941955 | 0 | 22.38317826 | 0 | 7.384346165 | 0 | 19.35923955 | 0 | 9.2526 | 0 | 2.7749235 | 0 | 0.86404 | 0 | -44.538 | 0 | -38.96642073 | 0 | -78.365 |  | -243.077
Price | 5 |  | NGFPL | D | 0 |  |  |  | -3354 |  | 114.6 |  | 908.6 |  | 1149.6 |  | 1228.1 |  | 1553.4 |  | 1673.9 |  | 1280.7 |  | 569.1 |  | 4670.374 |  | 7410.531566 |  | 2679.474537 |  | 3291.498 |  | -1330.242686
TOTAL:
Spreadsheet: 7ea86dd2-a503-4930-9a2b-0919f0db9542
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
43483257 | 2014-10-07 22:46:17 | ALLIES | 1 | 6 | 1 | 1580626 | player1580626 | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
43511671 | 2014-10-10 00:33:38 | AXIS | 1 | 12 | 7 | 867821 | b.kuntscher | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
43597023 | 2014-10-15 22:27:30 | AXIS | 1 | 5 | 3 | 805202 | canonman | 7430 | mediterranean | 1942-05-27 | 1942-05-27 | 1st Armoured to the rescue | Engagement blindé
43597244 | 2014-10-15 22:35:40 | ALLIES | 0 | 1 | 5 | 805202 | canonman | 7430 | mediterranean | 1942-05-27 | 1942-05-27 | 1st Armoured to the rescue | Engagement blindé
43626071 | 2014-10-18 02:02:56 | ALLIES | 0 | 2 | 7 | 1503014 | Agent Avacado | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43646619 | 2014-10-19 14:13:32 | AXIS | 1 | 4 | 3 | 1657989 | rafael-r.94 | 6162 | western | 1944-06-06 | 1944-06-06 | Pointe-du-Hoc | Pointe-du-Hoc
43646734 | 2014-10-19 14:30:04 | ALLIES | 0 | 3 | 4 | 1657989 | rafael-r.94 | 6162 | western | 1944-06-06 | 1944-06-06 | Pointe-du-Hoc | Pointe-du-Hoc
Spreadsheet: 882590d1730977570-if-a-cell-has-a-number-in-with-a-certain-text-for-it-then-to-be-added-in-a-different-cel-hallanita-molecular-spill-365-aligw
Sheet: Sheet1

Molecular | REDUCE("",A2:A67,LAMBDA(x,y,VSTACK(x,IFERROR(TEXTSPLIT(y,"-"),""))))
Panel 1 |  | #N/A | MCP's | smokes | heats | bases | sounder bases | sounder beacon bases | wall sounder beacons | I/O's
Loop 1 | Panel 1 | #N/A |  | 0 | 44 | 0 | 57 | 14 | 15 | 17
MCP's-3 | Loop 1 | #N/A | 36 | 147 | 44
Opticals-30 | MCP's | 3
Heats-0 | Opticals | 30 | FILTER(INDEX(f,,2),INDEX(f,,1)=TRIM(D2))
Sounder Bases-19 | Heats | 0
[NAME] Bases-4 | Sounder Bases | 19 | 9
Wall Sounder Beacons-2 | Sounder Beacon Bases | 4 | 11
I/O's-3 | Wall Sounder Beacons | 2 | 1
Panel 1 | I/O's | 3 | 4
[NAME] | Panel 1 | #N/A | 2
MCP's-9 | [NAME] | #N/A | 5
Opticals-3 | MCP's | 9 | 1
Heats-37 | Opticals | 3
Multi's-2 | Heats | 37 | SUM(--FILTER(INDEX(f,,2),INDEX(f,,1)=TRIM(D2)))
Wall Sounder Beacon-9 | Multi's | 2
I/O's-7 | Wall Sounder Beacon | 9
 | I/O's | 7
Panel 2 |  | #N/A
Loop 1 | Panel 2 | #N/A
MCP's-11 | Loop 1 | #N/A
Opticals-49 | MCP's | 11
Heats-3 | Opticals | 49
Multi's-1 | Heats | 3
Sounder Bases-17 | Multi's | 1
[NAME] Bases-6 | Sounder Bases | 17
Wall Sounder Beacons-5 | Sounder Beacon Bases | 6
I/O's-1 | Wall Sounder Beacons | 5
Panel 2 | I/O's | 1
[NAME] | Panel 2 | #N/A
MCP's-1 | [NAME] | #N/A
Opticals-1 | MCP's | 1
Sounder Bases-1 | Opticals | 1
 | Sounder Bases | 1
Panel 3 |  | #N/A
Loop 1 | Panel 3 | #N/A
MCP's-4 | Loop 1 | #N/A
Opticals-17 | MCP's | 4
Heats-2 | Opticals | 17
Sounder Bases-6 | Heats | 2
[NAME] Bases-2 | Sounder Bases | 6
Wall Sounder Beacons-3 | Sounder Beacon Bases | 2
I/O's-1 | Wall Sounder Beacons | 3
 | I/O's | 1
Panel 4 |  | #N/A
Loop 1 | Panel 4 | #N/A
MCP's-2 | Loop 1 | #N/A
Opticals-9 | MCP's | 2
Wall Sounder Beacons-2 | Opticals | 9
 | Wall Sounder Beacons | 2
Panel 5 |  | #N/A
Loop 1 | Panel 5 | #N/A
MCP's-5 | Loop 1 | #N/A
Opticals-37 | MCP's | 5
Heats-2 | Opticals | 37
Sounder Bases-13 | Heats | 2
[NAME] Bases-2 | Sounder Bases | 13
Wall Sounder Beacons-3 | Sounder Beacon Bases | 2
I/O's-4 | Wall Sounder Beacons | 3
 | I/O's | 4
Panel 6 |  | #N/A
Loop 1 | Panel 6 | #N/A
MCP's-1 | Loop 1 | #N/A
Opticals-1 | MCP's | 1
Sounder Bases-1 | Opticals | 1
I/O's-1 | Sounder Bases | 1
 | I/O's | 1
Spreadsheet: 684743d1593521690-sumifs-with-nested-index-match-formula-help-sample-sumifs-question-copy
Sheet: Sheet1

 |  |  | [NAME] | What I actually want
 | Metric 1 | 2019
 | Metric 2 | 2019 |  |  |  |  | <option 2
 | Metric 3 | 2019 |  |  |  |  | <option 1
 | Year | Month | Metric 1 | Metric 2 | Metric 3
 |  | 2017-01-31 00:00:00 | 1
 |  | 2017-02-28 00:00:00
 |  | 2017-03-31 00:00:00
 |  | 2017-04-30 00:00:00
 |  | 2017-05-31 00:00:00
 |  | 2017-06-30 00:00:00
 |  | 2017-07-31 00:00:00
 |  | 2017-08-31 00:00:00
 |  | 2017-09-30 00:00:00
 |  | 2017-10-31 00:00:00
 |  | 2017-11-30 00:00:00
 |  | 2017-12-31 00:00:00
 |  | 2018-01-31 00:00:00
 |  | 2018-02-28 00:00:00
 |  | 2018-03-31 00:00:00
 |  | 2018-04-30 00:00:00
 |  | 2018-05-31 00:00:00
 |  | 2018-06-30 00:00:00
 |  | 2018-07-31 00:00:00
 |  | 2018-08-31 00:00:00
 |  | 2018-09-30 00:00:00
 |  | 2018-10-31 00:00:00
 |  | 2018-11-30 00:00:00
 |  | 2018-12-31 00:00:00
 |  | 2019-01-31 00:00:00
 |  | 2019-02-28 00:00:00
 |  | 2019-03-31 00:00:00
 |  | 2019-04-30 00:00:00
 |  | 2019-05-31 00:00:00
 |  | 2019-06-30 00:00:00
 |  | 2019-07-31 00:00:00
 |  | 2019-08-31 00:00:00
 |  | 2019-09-30 00:00:00
 |  | 2019-10-31 00:00:00
 |  | 2019-11-30 00:00:00
 |  | 2019-12-31 00:00:00
Spreadsheet: 725518d1616716997-help-on-adjusting-excel-formula-to-calculate-more-date-sales-ledger-2021
Sheet: Customer Statement

Current solution calculate 100 record on the sheets. I want it to calculate at least 5000 record on the sheets.
I have tried to adjust the formula but I have failed. Please help me.
 | ST 001
Date | Receipt Number | Invoice Number | Debit | Credit | Cumulative Balance
Desired Outcome
 | ST 001
Date | Receipt Number | Invoice Number | Debit | Credit | Cumulative Balance
2020-01-01 00:00:00 |  | C001 | 400
2020-01-10 00:00:00 |  | 1 | 2000
2020-01-12 00:00:00 | R010 | C001 |  | 300
2020-01-14 00:00:00 | R012 | 3 |  | 1000
2020-05-12 00:00:00 |  | 5 | 2300
2020-09-09 00:00:00 |  | 9 | 2500
Spreadsheet: cf69683c-1b2e-499c-a54c-a3b797095d15
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
MATTEL, INC. AND SUBSIDIARIES
RECONCILIATION OF GAAP TO NON-GAAP FINANCIAL MEASURE
 |  |  |  |  | Three Months Ended September 30, |  |  |  |  |  | Nine Months Ended September 30,
(In millions, except percentage information) |  |  |  |  |  | 2010 |  |  | 2009 |  |  | 2010 |  |  | 2009
Gross Sales |  |  |  |  | $ | 1996.9 |  | $ | 1955.9 |  | $ | 4059.2 |  | $ | 3788.1
[NAME] |  |  |  |  |  | -163.8 |  |  | -164 |  |  | -327.6 |  |  | -312.4
Net Sales |  |  |  |  | $ | 1833.1 |  | $ | 1791.9 |  | $ | 3731.6 |  | $ | 3475.7
% Change |  |  |  |  |  | 0.02 |  |  | -0.08 |  |  | 0.07 |  |  | -0.13
Pos./(Neg.) Impact of Currency (in % pts) |  |  |  |  |  | -3 |  |  | -3 |  |  | -1 |  |  | -4
The financial information included herein should be read in conjunction with Mattel's consolidated financial statements and related notes in its Annual Reports
on Form 10-K and/or Quarterly Reports on Form 10-Q, as applicable.
Spreadsheet: 853385d1703249682-allow-excel-to-read-a-rounded-number-as-a-whole-number-in-a-table-round-up-error-in-lookup-table
Sheet: Sheet1

Mathematics |  |  |  |  | School xx
Subject | UK  Years | Result |  |  | Mathematics
Phase 2  Pr imary | 1 | 4 |  |  | Attainment
 | 2 | 2 |  | Phase 2
 | 3 | 4 |  | Phase 3
 | 4 | 3 |  | Phase 4
 | 5 | 2
 | 6 | 2 |  | Overall
Phase 3 Secondary | 7 | 4
 | 8 | 2 |  |  | 1 | Very Weak
 | 9 | 4 |  |  | 2 | Weak
 | 10 | 6 |  |  | 3 | Acceptable
 | 11 | 5 |  |  | 4 | Good
Phase 4 Post 16 | 12 | 3 |  |  | 5 | Very Good
 | 13 | 1 |  |  | 6 | Outstanding
Spreadsheet: 720499d1614178106-gantt-project-sheet-excel
Sheet: data

ID | TASK DESCRIPTION | TASK DURATION | PROJECT START DATE | PROJECT END DATE
1 | ABC | 3 | 2020-05-11 00:00:00
2 | DEF | 9
3 | GHI | 12
4 | JKL | 24
5 | MNO | 10
6 | PQR | 14
7 | STU | 15
8 | VWX | 16
9 | YZ1 | 5
10 | 123 | 8
11 | 456 | 4
Spreadsheet: 694411d1599589954-add-a-variable-to-a-sumproduct-sumif-formula-de-pense-nouveaux-employe-s-exemple-
Sheet: Production

 |  |  | Modeleur
 | Shotgun |  | Shotgun
 | [NAME] |  | [NAME]
 | VPN |  | VPN
 | [NAME] |  | [NAME]
 | RV |  | RV
 | [NAME] 1 |  | Écran standard
 | [NAME] 2 |  | Écran standard
 | [NAME] 3
 | [NAME]/clavier |  | [NAME]/clavier
 | Caméra |  | Caméra
 | Headset |  | Headset
 | Intous - On request |  | Intuos
 | Amortissement - Renouveller aux 3 ans |  | Workstation MID
 | OS |  | Windows
 | Logiciels |  | Maya
 |  |  | [NAME]
 |  |  | Adobe Photosop
 |  |  | license windows
 |  |  | 3dsMax (floating pool used)
 |  |  | Bulk renamer
 |  |  | Cinema 4D
 |  |  | Araxis/Beyond compare
 | Pluggins
 | Total:
 | Total CAPEX: |  | Total of the type CAPEX on next page
 | Total OPEX - An |  | Total of the type OPEX - An  on next page
 | Total OPEX - 6 mois |  | ETC
 | Total OPEX - Mois |  | ETC
Spreadsheet: louise_kitchen__22711__North America Plan 01-09 inc AA adj (2)
Sheet: East-Trading AA

 | East Gas - Trading Analysts/Associates
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Plan
ENACOMP | Compensation |  |  |  |  |  | 0 | Compensation | 0
 | Special Pays |  |  | 0
 | Analyst & Associates |  |  |  |  |  | 75000
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense |  |  |  |  |  | 3125
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  | 3125 | Total
ENAOUTSV | Outside Services |  |  |  |  |  | 0
ENASUPP | Supplies Expense |  |  |  |  |  | 2500
ENAMKTEX | Marketing |  |  |  |  |  | 0 | Intern | 33000
ENACONTR | Charitable Contributions |  |  |  |  |  | 62.5 | [NAME] | 48400 | 0
ENARENT | Rent |  |  |  |  |  | 0 | Staff | 49500 | 0
ENATECH | Technology |  |  |  |  |  | 12500 | Specialist | 57750 | 0
ENATRANS | Transportation |  |  |  |  |  | 0.125 | Sr. Specialist | 71500 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  | 3125 | Analyst | 60500 | 1
ENATAXES | Taxes Other than Income |  |  |  |  |  | 0 | Associate | 89100 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000 | 2
 |  |  |  |  |  |  |  | Director | 143000 | 4
 | Headcount |  |  |  |  |  | 0 | Sr. Director | 165000 | 0
 |  |  |  |  |  |  |  | VP | 198000 | 1
 | A&A Headcount |  |  |  |  |  |  | MD | 220000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 166074d1341457705-need-to-calculate-time-book2
Sheet: Sheet1

 | START | FINISH
DAY SHIFT | 2:00AM | 1.59PM
NIGHT SHIFT | 2:00PM | 1:59AM
Time Start | Time Fin | Total Hours | Shift
14:45:00 | 20:30:00
15:00:00 | 20:45:00
07:00:00 | 13:30:00
07:00:00 | 13:30:00
07:00:00 | 13:30:00
14:30:00 | 20:45:00
13:00:00 | 20:45:00
13:00:00 | 20:30:00
07:00:00 | 13:45:00
07:00:00 | 13:30:00
07:15:00 | 13:30:00
07:00:00 | 13:30:00
07:15:00 | 13:30:00
07:15:00 | 13:30:00
10:00:00 | 10:30:00
07:00:00 | 10:30:00
07:00:00 | 13:30:00
13:45:00 | 14:10:00
07:00:00 | 13:30:00
07:00:00 | 13:30:00
07:00:00 | 11:30:00
10:45:00 | 11:30:00
07:00:00 | 11:15:00
07:00:00 | 11:30:00
10:30:00 | 11:15:00
Spreadsheet: 66524d1267151046-count-frequency-of-set-hour-ranges-from-large-list-of-times-time_tbl
Sheet: frequency

Hour |  | Frequency
04:00:00 | 04:59:59 | 0
05:00:00 | 05:59:59 | 0
06:00:00 | 06:59:59 | 0
19:00:00 | 19:59:59 | 1
08:00:00 | 08:59:59 | 0
09:00:00 | 09:59:59 | 0
10:00:00 | 10:59:59 | 0
11:00:00 | 11:59:59 | 0
12:00:00 | 12:59:59 | 0