tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: mary_fischer__25635__31R
Sheet: E31.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY 31R
COMPANY NAME  Limbach Company Holding Company
RECONCILIATION OF STOCKHOLDERS' EQUITY AND INVESTMENT IN SUBS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
 |  |  |  | 12-31-00 Balance |  |  |  | EQUITY IN |  | DIVIDENDS DECLARED |  |  |  | OTHER ACTIVITY
 |  |  |  | DR  (CR) |  | RECLASS 00 NI |  | EARNINGS |  |  |  |  |  |  |  |  |  | DR  (CR)
 |  | Hyp line |  | BEG BALANCE |  | TO BEG RE |  | /LOSSES |  | COMMON |  | PREFERRED |  | DR (CR) |  | (Describe) |  | END BALANCE
Shareholders Equity by Parent |  | Reverse signs from Hyperion
Common Stock |  | 0901 |  | -100
Paid in Capital |  | 0910
Contribution Received from Parent |  | 0915 |  | -21212116
RE - Beg Bal |  | 0920 |  | -9110838 |  | 122 |  |  |  |  |  |  |  |  |  | C&E Entries
RE - Net Income |  | 0930 |  | 122 |  |  |  | -58
RE - Net Income (Fair Value Adjustment) |  | 0931
Dividends Decl - Preferred Stock |  | 0935
Dividends Decl - Common Stock |  | 0941
Invest in Subs Plug Account |  | 0942 |  |  |  |  |  | 1
Total Shareholders' Equity |  | TOT_SHARE_EQU
Net Income |  | NET_INCOME
PARENT'S CO #
Investment in Consol Sub (on Parent Books) |  |  |  | Same signs as Hyperion
Investment in CS |  | 0215
Investment in PIC (contrib by parent) |  | 0216
Investment in Equity earnings of sub |  | 0217
Total Investment in Consol Sub
Equity in Consol Sub |  | 1505
Difference between SE (on sub) and Invest (on parent)
Reasons for Differences
A schedule will need to be prepared for each subsidiary.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
Spreadsheet: 864671d1711753822-question-on-date-range-based-cell-populating-food-safety-walk
Sheet: Nerd Shit

 | Current Week |  | 1st - 7th | 8th - 14th | 15th - 21st | 22nd - 28th | 29th-31st | MTD |  | Last Month | Prior Month |  | 60 Day | 90 Day
Bakery |  |  | 0.25 | 0.15 | 0.65 | 0.5714 |  |  |  | 0.5 | 0.1
C-Store |  |  | 0.16 | 0.2 | 0.5 | 0.4286 |  |  |  | 0.75 | 0.12
Deli |  |  | 0.18 | 0.25 | 0.46 | 0.619 |  |  |  | 0.19 | 0.14
[NAME] |  |  | 0.43 | 0.3 | 0.82 | 0.619 |  |  |  | 0.65 | 0.16
Market/Mia |  |  | 0.84 | 0.35 | 0.46 | 0.4762 |  |  |  | 0.95 | 0.18
Meat |  |  | 0.65 | 0.4 | 0.12 | 0.5714 |  |  |  | 0.75 | 0.2
Seafood |  |  | 1 | 0.15 | 0.16 | 0.7619 |  |  |  | 0.65 | 0.22
Starbucks |  |  | 0.12 | 0.65 | 0.85 | 0.4286 |  |  |  | 0.34 | 0.24
Wahlburgers |  |  | 0.66 | 0.5 | 0.65 | 0.6667 |  |  |  | 0.77 | 0.26
 | Current Average |  | Week 1 Avg | Week 2 Avg | Week 3 Avg | Week 4 Avg | Week 5 Avg | MTD [NAME] |  | Last Month Avg | Prior Average |  | 60 Day Average | 90 Day Average
1559
Instructions:
Step 1: | Perform a walk of each department and record a "P" if the department passes the question or a "F" if they fail on the correct sheet.
Step 2: | On this page, copy the results from column B to the correct week of the month in the yellow section.
Step 3: | At the end of the month copy the totals from column K to Column L
Step 4: | Copy the totals from Column I to Column K
Step 5: | Erase the yellow boxes in Column D through column H
Step 6: | Go back to Step 1
Spreadsheet: 227382d1365691338-filter-values-based-on-a-master-list-and-an-input-list-filtersample
Sheet: Sheet1

You only edit column A
Column B grows and shrinks based on the values in A
Column C is just a reference column listing all items.
Note:  I do NOT want Red to show up in the filterd column.
[NAME] with no inputs
Input | Filtered | Master
 | Orange | Orange
 | Blue | Red
 | Yellow | Blue
 | Green | Yellow
 |  | Green
Example 1
Input | Filtered | Master
Blue | Orange | Orange
Green | Yellow | Red
 |  | Blue
 |  | Yellow
 |  | Green
Example 2
Input | Filtered | Master
Orange | Blue | Orange
 | Yellow | Red
 | Green | Blue
 |  | Yellow
 |  | Green
Spreadsheet: 98837d1297689836-conditional-format-in-birth-month-window-birthmonth-reached
Sheet: Sheet1

 | Name | [NAME] | HIPAA        Birth Month
 | [NAME] | 1963-07-01 00:00:00
 | Jones | 1963-01-01 00:00:00 | 2011-01-02 00:00:00
 | Smith | 1963-02-01 00:00:00 | 2010-02-02 00:00:00 | in window
 | Wesson | 1963-03-01 00:00:00 | 2010-03-04 00:00:00 | 30 days before window
 |  | 1993-04-01 00:00:00
 |  | 1991-05-01 00:00:00
 |  | 1993-06-01 00:00:00 | 2009-02-05 00:00:00
 |  | 1992-07-01 00:00:00
 |  | 1968-08-01 00:00:00
 |  | 1992-02-01 00:00:00 | 2010-02-14 00:00:00
 |  | 1992-10-01 00:00:00
 |  | 1992-11-01 00:00:00
 |  | 1992-12-01 00:00:00
 |  | 1992-01-01 00:00:00
 |  | 1994-03-01 00:00:00 | 2009-03-14 00:00:00 | Past due
 |  | 1991-11-01 00:00:00
 |  | 1994-10-01 00:00:00
Spreadsheet: 68622d1269216695-wage-cost-does-not-tally-forum-7
Sheet: Sheet1

300 | 150 |  | 450 |  | 60 | 25 |  | 85
600 | 600 |  | 1200 |  | 120 | 100 |  | 220
0.5 | 0.25 | 0.375 | 0.375 |  | 0.5 | 0.25 | 0.375 | 0.3863636363636364
Spreadsheet: tracy_geaccone__40401__GPM 101021  101073 Recalculation
Sheet: Jan 2001

KN Processing |  | GPM Agency Agreement |  |  | Prepared by [NAME]
Bushton Plant |  | TFDV Volume & Dollar Calculation
 |  | For
 |  | 2001-01-01 00:00:00
Contract #101021 |  |  | NNG Numbers |  |  | Oneok Numbers |  |  | Difference
 | Total Deliveries |  |  | 4492506 |  |  | 3479050
 |  | Deliveries to Inlet | 4297694 |  |  | 3337210
 |  | Deliveries to PVR
 |  | Non-Fuel Deliveries
 |  | Fuel Retention
 | Total Receipts |  | 4488758 |  |  | 3479649
 |  | [NAME] | 0.0445 |  |  | 0.0445
 |  | Less Fuel Retained
Transport Revenue [NAME]
Contract #101073
 | Total Deliveries |  |  |  |  |  | 1330289
 |  | Deliveries to Inlet | 0
 |  | Deliveries to PVR | 1056726 |  |  | 1273566
 |  | Non-Fuel Deliveries
 |  | Fuel Retention
 | Total Receipts |  | 1001370 |  |  | 1319413
 |  | [NAME] | 0.0445 |  |  | 0.0445
 |  | Less Fuel Retained
Transport Revenue [NAME]
 |  | Total Both Contracts
 |  | Index |  | 8.116
 |  | Total Revenue Due
Total Revenue Billed |  | 101021 |  | 43102.85
 |  | 101073
 |  |  |  |  |  |  | 45596.23
 |  | Amount Due NNG (GPM)
Charge given by NNG on prior reconciliation
 |  | Amount Due NNG (GPM)
Spreadsheet: 713877d1610990768-search-for-text-string-in-range-book1
Sheet: data

ID | Service Line | Country | Cross-Fuctional SL
1 | Team 1 | CA
2 | Team 2 | US | Team 3;#Team 2
3 | Team 3 | US | Team 3;#Team 5
4 | Team 4 | CA | Team 4;# Team 6
5 | Team 5 | US
6 | Team 1 | CA | Team 3;#Team 1
7 | Team 4 | CA
8 | Team 3 | US
9 | Team 2 | US
10 | Team 2 | CA | Team 3;#Team 1
11 | Team 1 | US
12 | Team 1 | CA
13 | Team 1 | CA | Team 5;#Team 3;#Team 2
14 | Team 1 | US
15 | Team 1 | US
16 | Team 3 | US
17 | Team 4 | CA
18 | Team 6 | CA
19 | Team 2 | CA
20 | Team 5 | US | Team 6;#Team 4
21 | Team 1 | US | Team 5;#Team 1
22 | Team 3 | US | Team 5;#Team 3;#Team 1
23 | Team 6 | CA | Team 4;#Team 6
24 | Team 1 | US | Team 1;#Team 3
25 | Team 1 | US
26 | Team 4 | CA | Team 3;#Team 4
27 | Team 5 | US | Team 5;#Team 1
28 | Team 5 | US | Team 5;#Team 1
29 | Team 5 | US | Team 1;#Team 2
Spreadsheet: 750720d1633606599-merging-data-from-two-different-tables-breakdown
Sheet: Sheet1

 | Table 1
 | COMPANY ID | COMPANY | SALES | JAN | FEB | MAR | APR
 | 12345 | ABC WINDOWS | 10000
 | 678910 | DEF WINDOWS | 30000
 | 42345 | GHI WINDOWS | 40000
 | Table 2
 | COMPANY ID | COMPANY | JAN | FEB | MAR | APR
 | 678910 |  | 0.2 | 0.4 | 0.3 | 0.1
 | 42345 |  | 0.4 | 0.3 | 0 | 0.3
 | 12345 |  | 0.5 | 0.1 | 0.1 | 0.3
Spreadsheet: 0a1a8b54-92cd-4c14-875c-78e41acbe4e4
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Temperature Correction of Colostrometer Values | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Colostrum temperature
enter up to three temperatures below
 | 40 | °F |  | 65 | °F |  | 90 | °F
Instructions
1. Enter up to three colostrum temperatures above.
2. Click on the "table" tab below to view a table of corrected temperatures.
3. Click on any of the "graph" tabs to view graphs of corrected temperaures.
 | Graph 1 temp plots the temperature entered in cell A4
 | Graph 2 temps plots the temperatures entered in A4 and A5
 | Graph 3 temps plots all the temperatures entered
 | Celcius graph plots all temperatures in Celcius
The relationship between immunoglobulins (Ig) and the specific gravity of colostrum is affected by the temperature of the colostrum. This spreadsheet was developed to provide an adjusted Ig value for colostrum tested with a colostrometer. The adjustment provides the Ig value that would be expected if colostrum was tested at 68°F.
Compared to testing at room temperature, warm colostrum underestimates colostrum IgG and cold colostrum overestimates IgG.
Be aware that this is a statistical correction and the relationship is not perfect. The equation corrects colostrum quality to 20°C (68°F), which means the corrected and uncorrected values for colostrum measured at 20°C should match. However, at all points the corrected value is slightly higher than the uncorrected value. This margin of error (about 8%) is only a concern with colostrum that returns an uncorrected value of 40 to 50 mg/ml when tested at temperatures near 68°F. Such colostrum has borderline quality, and feeding it to newborn calves should be avoided if possible.
Spreadsheet developed by Coleen Jones and [NAME]
 |  |  |  |  | Updated: | 2005-10-19 00:00:00
Spreadsheet: 762493d1641577292-lookup-multiple-criteria-multiple-results-excel-q
Sheet: Denver_P3

Denver DC
Zone | Attendees | Global ID | Position | [NAME] | Needs Room | RoomNight
Denver | [NAME] |  | RSA |  |  |  | Late Day 1
 | [NAME] |  | RSA |  | Drury | Wed
 | [NAME]
 | [NAME] |  |  |  | Drury | Wed
COS | [NAME]
Ft. Collins | [NAME] | 80041926 | RSA | 2XL | Drury | Wed
 | Tarek Barzak | 80042069 | CSS | XL | Drury | Wed
 | [NAME] | TBD | CSS | ?? | No
 | [NAME] | TBD | RSA | ?? | Drury | Tues/Wed
 | [NAME] |  |  |  |  | Tues/Wed | late day 1
New Mexico
(Durango) | [NAME] | 80042149 | RSA | XL | Cambria | 2/28, 3/1 | 313.44
(Farmington) | [NAME] | 71112650 | Merch | L | Cambria | 2/28, 3/1 | 313.44
([NAME]) | [NAME] | 80043261 | RSA | XL | Cambria | 2/28, 3/1 | 313.44
([NAME]) | [NAME] | 71047508 | Merch | L | Cambria | 2/28, 3/1 | 313.44
El Paso
Spreadsheet: 879714d1727270933-need-help-returning-data-when-cell-matches-column-headers-notes-ks
Sheet: DEC 2024

ACCT | Due to Pre-Press | Due to Prod | Ship Date | Due In-Store | Promo | Notes
G G P M | 0-Jan | 0-Jan | 0-Jan | 0-Jan | 0-Jan
S U N O   C A L S | 0-Jan | 0-Jan | 0-Jan | 0-Jan | 0-Jan
T O F A | 0-Jan | 0-Jan | 0-Jan | 0-Jan | 0-Jan
R A C T | 0-Jan | 0-Jan | 0-Jan | 0-Jan | 0-Jan
BASS | 0-Jan | 0-Jan | 0-Jan | 0-Jan | 0-Jan
HHGJ [NAME] | 0-Jan | 0-Jan | 0-Jan | 0-Jan | 0-Jan
HHGJ TMOB | 0-Jan | 0-Jan | 0-Jan | 0-Jan | 0-Jan
KNST | 0-Jan | 0-Jan | 0-Jan | 0-Jan | 0-Jan
Spreadsheet: joe_parks__14892__TXULSP Avail Cap Elec Gen
Sheet: available capacity

 |  |  | Today's Date:
 | Lone Star Pipeline
Estimated Available Capacity on the TXU Lone Star Pipeline system
Gas Day runs from 9:00 a.m. to 9:00 a.m.
All volumes are expressed in [NAME]/d
The data below is TXU Lone Star Pipeline's best estimate of available capacity based on current operational data.  The available capacity listed
at the various [NAME])  is subject to the nomination process and the operational conditions existing at the time a nomination is confirmed.
The volumes listed below do not represent individual point capacity availability.   All transportation service will be performed subject to the terms
and conditions of your Transportation Agreement.
Please contact TXU Lone Star Pipeline's Transportation Administration Department before scheduling any imbalance makeup.  When
nominating imbalance makeup, please indicate what portion of your nomination is intended as imbalance makeup.  For more information, please
contact your TXU Lone Star Pipeline Transportation Administrator.
Please visit our web site at www.txulsp.com for nomination information and for a list of Major Interconnect Points on our system.
 | Receipt Area Capacity
 | Gas Day | Gas Day
 | 2002-03-19 00:00:00
From the Waha Area | 250000
East of Waha to | 150000
to the Maryneal Compressor
East of Maryneal Compressor | 50000
[NAME] | 100000
(Waller and Ft. Bend Counties)
Line V (30") | 50000
(Ennis to [NAME])
Lines L8A | 0
(Limestone and Freestone Cty)
Line P | 15000
([NAME] Area - for local consumption only)
[NAME] and O (East Texas) | 25,000*
 | * Carthage Plant OK for 25,000
Spreadsheet: 50518d1249981461-excel-graph-extrapolation-4-point-poly-graph-1
Sheet: Sheet1

0.000589 | 0.256 |  | 0.00029 | 0.068
0.001768 | 0.963 |  | 0.000871 | 0.26
0.005303 | 1.778 |  | 0.002612 | 0.683
0.015909 | 4.029 |  | 0.007836 | 2.049
0.047727 | 7.14 |  | 0.023507 | 3.993
0.143181 | 7.951 |  | 0.070522 | 5.098
Spreadsheet: 4f0ddfc7-971e-460b-87ab-6b758455ef7b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 |  |  | [NAME] 5 Antworten zum richtigen [NAME]
 |  |  | Name, [NAME] |  |  |  |  |  | Datum:
 |  |  | Firma |  |  |  |  |  | Telefon:
 |  |  | Anschrift |  |  |  |  |  | Fax:
 |  |  | [NAME]/Pos./Abt. |  |  |  |  |  | [NAME]:
 |  |  | Welches  Produkt war bisher im [NAME]?
 |  |  | Produktbezeichnung:
 |  |  | Hersteller:
 |  |  | Bedarf ca. [NAME] :
 |  |  | Preis:
 |  |  | wassermischbar: |  |  |  |  |  | Zentralanlage: | Füllvolumen m³
 |  |  | nichtwassermischbar: |  |  |  |  |  | einzelbefüllte [NAME]
 |  |  | Einsatzkonzentration: |  | % |  |  |  |  | KSS - Druck (bar):
 |  |  | Wasserhärte: |  | °dH
 |  |  | Viskosität : |  | mm² / 40°C
 |  |  | Vorbehandlung der Teile: |  | Korrosionschutz |  |  |  | Schneidöl
 |  |  |  |  | wmb KSS |  |  |  | sonstiges.
 |  |  | [NAME] werden wie bearbeitet ?
 |  |  |  | bearbeitete Werkstoffe: |  |  |  | Bearbeitungsverfahren:
 |  |  |  |  | Alu-Legierungen |  |  |  | [NAME]
 |  |  |  |  | Stahl |  |  |  | Reiben
 |  |  |  |  | Guss |  |  |  | Fräsen
 |  |  |  |  | Nichteisenmetalle |  |  |  | Gewinden
 |  |  |  |  | sonstige [NAME] |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | Schleifen
 |  |  |  |  |  |  |  |  | sonstige
 |  |  | schwerste [NAME]:
 |  |  | [NAME] es zur Zeit Probleme mit dem aktuell verwendeten Produkt?
 |  |  |  |  | nein |  |  |  | ja, welche ?
 |  |  | Welche Anforderung soll [NAME]?
Spreadsheet: 125875d1319310904-count-if-example-1-
Sheet: August 2010

 | Date | Type | Company | Details | Cost
 | 1
 | 2
 | 3 | Taxi |  |  | 27
 | 4
 | 5
 | 6 | Taxi |  |  | 10
 | 7 | Taxi |  |  | 10
 | 8
 | 9 | Taxi |  |  | 10
 | 10
 | 11 | Taxi |  |  | 10
 | 12 | Taxi |  |  | 10
 | 13
 | 14 | Taxi |  |  | 10
 | 15 | Taxi |  |  | 10
 | 16 | Taxi |  |  | 10
 | 17 | Taxi |  |  | 10
 | 18 | Taxi |  |  | 10
 | 19
 | 20 | Taxi |  |  | 14
 | 21 | Taxi |  |  | 8
 | 22 | Taxi |  |  | 12
 | 23 | Taxi |  |  | 10
 | 24
 | 25
 | 26 | Taxi |  |  | 12
 | 27 | Taxi |  |  | 10
 | 28 | Taxi |  |  | 13
 | 29 | Taxi |  |  | 10
 | 30 | Taxi |  |  | 10
 |  | Taxi |  |  | 12
 | 32
 | 33
 | 34
 | 35 | Taxi |  |  | 12
 |  |  |  | Total
Spreadsheet: 740080d1626177773-how-to-average-the-probability-severity-and-risk-of-a-group-of-data-how-to-average-the-probability-severity-and-risk-of-a-group-of-data
Sheet: Cause List

Cause Identifier | Cause Title | Cause Description
AAA/Z001 | Cause 1 | Cause Des 1
AAA/Z002 | Cause 2 | Cause Des 2
AAA/Z003 | Cause 3 | Cause Des 3
AAA/Z004 | Cause 4 | Cause Des 4
AAA/Z005 | Cause 5 | Cause Des 5
AAA/Z006 | Cause 6 | Cause Des 6
AAA/Z007 | Cause 7 | Cause Des 7
AAA/Z008 | Cause 8 | Cause Des 8
AAA/Z009 | Cause 9 | Cause Des 9
AAA/Z010 | Cause 10 | Cause Des 10
AAA/Z011 | Cause 11 | Cause Des 11
AAA/Z012 | Cause 12 | Cause Des 12
AAA/Z013 | Cause 13 | Cause Des 13
AAA/Z014 | Cause 14 | Cause Des 14
AAA/Z015 | Cause 15 | Cause Des 15
AAA/Z016 | Cause 16 | Cause Des 16
AAA/Z017 | Cause 17 | Cause Des 17
AAA/Z018 | Cause 18 | Cause Des 18
AAA/Z019 | Cause 19 | Cause Des 19
AAA/Z020 | Cause 20 | Cause Des 20
AAA/Z021 | Cause 21 | Cause Des 21
AAA/Z022 | Cause 22 | Cause Des 22
AAA/Z023 | Cause 23 | Cause Des 23
AAA/Z024 | Cause 24 | Cause Des 24
AAA/Z025 | Cause 25 | Cause Des 25
AAA/Z026 | Cause 26 | Cause Des 26
AAA/Z027 | Cause 27 | Cause Des 27
AAA/Z028 | Cause 28 | Cause Des 28
AAA/Z029 | Cause 29 | Cause Des 29
AAA/Z030 | Cause 30 | Cause Des 30
AAA/Z031 | Cause 31 | Cause Des 31
AAA/Z032 | Cause 32 | Cause Des 32
AAA/Z033 | Cause 33 | Cause Des 33
AAA/Z034 | Cause 34 | Cause Des 34
AAA/Z035 | Cause 35 | Cause Des 35
AAA/Z036 | Cause 36 | Cause Des 36
AAA/Z037 | Cause 37 | Cause Des 37
AAA/Z038 | Cause 38 | Cause Des 38
AAA/Z039 | Cause 39 | Cause Des 39
Spreadsheet: 600330d1543601407-diasplay-values-based-on-date-end-of-shift-example-revised
Sheet: Census

 | Census
 | 0000 | 0700 | 1900
2018-11-26 00:00:00
11/27/2018
11/28/2018
11/29/2018
11/30/2018
12/1/2018
12/2/2018
2018-12-03 00:00:00
2018-12-04 00:00:00
2018-12-05 00:00:00
2018-12-06 00:00:00
2018-12-07 00:00:00
2018-12-08 00:00:00
2018-12-09 00:00:00
2018-12-10 00:00:00
2018-12-11 00:00:00
2018-12-12 00:00:00
2018-12-13 00:00:00
2018-12-14 00:00:00
2018-12-15 00:00:00
2018-12-16 00:00:00
2018-12-17 00:00:00
2018-12-18 00:00:00
2018-12-19 00:00:00
2018-12-20 00:00:00
2018-12-21 00:00:00
2018-12-22 00:00:00
2018-12-23 00:00:00
2018-12-24 00:00:00
2018-12-25 00:00:00
2018-12-26 00:00:00
2018-12-27 00:00:00
2018-12-28 00:00:00
2018-12-29 00:00:00
2018-12-30 00:00:00
2018-12-31 00:00:00
Spreadsheet: 838079d1690695555-change-sheet-refernce-incrementally-in-adjacent-cells-2023-league-standings-sample
Sheet: T5

Team # | Team Name | Permanent Bowler | Reserves | Lineup | Average | Handicap |  |  |  | Game 1 Scratch | Game 1 Handicap | Game 2 Scratch | Game 2 Handicap | Game 3 Scratch | Game 3 Handicap | Scratch Series | Handicap Series | Indiv Points
5 | Om Nom | Player13 |  |  |  |  |  |  | Week 1
 |  | Player14 |  |  |  |  |  |  | Week 2
 |  | Player15 |  |  |  |  |  |  | Week 3
 |  |  |  |  |  |  |  |  | Week 4
 |  |  |  |  |  |  |  |  | Week 5
 |  |  |  |  |  |  |  |  | Week 6
 |  |  |  |  |  |  |  |  | Week 7
 |  |  |  |  |  |  |  |  | Week 8
 |  |  |  |  |  |  |  |  | Week 9
 | [NAME] |  | Average |  |  |  |  |  | Week 10
 |  | Player13 | 198 |  |  |  |  |  | Week 11
 |  | Player14 | 140 |  |  |  |  |  | Week 12
 |  | Player15 | 113 |  |  |  |  |  | Week 13
 |  |  |  |  |  |  |  |  | Week 14
 |  |  |  |  |  |  |  |  | Week 15
 |  |  |  |  |  |  |  |  | Week 16
 |  | Vacant |  |  |  |  |  |  | Week 17
 |  |  |  |  |  |  |  |  | Week 18
 |  |  |  |  |  |  |  |  | Week 19
 | Reserves Lookup |  | Average |  |  |  |  |  | Week 20
 |  |  |  |  |  |  |  |  | Week 21
 |  |  |  |  |  |  |  |  | Week 22
 |  |  |  |  |  |  |  |  | Week 23
 |  |  |  |  |  |  |  |  | Week 24
 |  |  |  |  |  |  |  |  | Week 25
 |  |  |  |  |  |  |  |  | Week 26
 |  |  |  |  |  |  |  |  | Week 27
 |  |  |  |  |  |  |  |  | Week 28
 |  |  |  |  |  |  |  |  | Week 29
 |  |  |  |  |  |  |  |  | Week 30
 |  |  |  |  |  |  |  |  | Week 31
 |  |  |  |  |  |  |  |  | Week 32
 |  |  |  |  |  |  |  |  | Week 33
 |  |  |  |  |  |  |  |  | Week 34
 |  |  |  |  |  |  |  |  | Week 35
 |  |  |  |  |  |  |  |  | Week 36
 | VLOOKUP(B11,C11:C18,1,FALSE) |  |  |  |  |  |  |  | Week 37
 |  |  |  |  |  |  |  |  | Week 38
 |  |  |  |  |  |  |  |  | Week 39
 |  |  |  |  |  |  |  |  | Week 40
 |  |  |  |  |  |  |  |  | Week 41
 |  |  |  |  |  |  |  |  | Week 42
 |  |  |  |  |  |  |  |  | Week 43
 |  |  |  |  |  |  |  |  | Week 44
 |  |  |  |  |  |  |  |  | Week 45
Spreadsheet: 600166d1543505573-finding-differences-in-a-range-for-a-specific-groups-example1
Sheet: Sheet1

Poland | -10 | 10
Poland | -10 | 10
Poland | -9 | 9
Croatia | 80 | 90
Croatia | 80 | 90
Germany | 30 | 66
Germany | 31 | 65
Germany | 31 | 66
Germany | 30 | 66
Germany | 32 | 66
<big database further on> | <big database further on> | <big database further on>
Spreadsheet: 882968d1731438749-dynamic-drop-down-using-tables-testworkbook
Sheet: Job Summary

Job Number | Customer Number | Description | Cost Type | [NAME] | Fixed Price | Date | Invoiced | Invoice Date | Paid | Part Payment | Payment Date | Confirmation Email | Invoice Status | Materials | Labour | Total Estimate | Final Labour Cost | Final Invoice | Completion Status | Job Number with Details | Job Number Copy | Customer ID | Invoiceable
 | 100001 - Fred Head | Repair & Gravel Drive, Install Gates, [NAME] and Poly Tunnel. [NAME] | Estimate | Daily |  | 2024-10-05 00:00:00
 | 100002 - [NAME] | [NAME] and Install Shower | Quote | Fixed | 1500 | 2024-10-05 00:00:00 | Yes | 2024-10-15 00:00:00 |  |  |  | Sent
 | 100003 - Jim Thing | Fix mouse hole and repair small section of roof lining in car port. Remove and install customer supplied fence and gate | Estimate | Daily |  | 2024-10-10 00:00:00 | Yes | 2024-10-24 00:00:00 |  |  |  | Sent
 | 100004 - Jason Station | General [NAME] and fixes | Estimate | Daily |  | 2024-10-22 00:00:00 | Yes | 2024-10-31 00:00:00 |  |  |  | Sent
 | 100004 - Jason Station | General [NAME] and fixes | Estimate | Daily |  | 2024-11-01 00:00:00 | Yes | 2024-11-10 00:00:00
 | 100004 - Jason Station | General [NAME] and fixes | Estimate | Daily |  | 2024-11-11 00:00:00
Spreadsheet: 32437d1228581661-complex-if-statement-xlforum-payable-guess
Sheet: Payables

Sort Data By:
BILL DATA |  |  |  |  |  |  |  |  |  |  | Payment Plan |  |  |  |  |  |  |  |  |  | 1st Wk Ending | 2nd Wk Ending | 3rd Wk Ending | 4th Wk Ending | 5th Wk Ending | 6th Wk Ending | 7th Wk Ending | 8th Wk Ending | 9th Wk Ending | 10th Wk Ending | 11th Wk Ending | 12th Wk Ending | 13th Wk Ending | 14th Wk Ending | 15th Wk Ending | 16th Wk Ending | 17th Wk Ending | 18th Wk Ending | 19th Wk Ending | 20th Wk Ending | 21st Wk Ending | 22nd Wk Ending | 23rd Wk Ending | 24th Wk Ending | 25th Wk Ending | 26th Wk Ending
Accounts Payable | Paid | [NAME] | [NAME] | Amt (Bal) | Terms | [NAME] | Due | Planned to | [NAME] | Plann'd | Payment | Amount | Payment | Amount | Payment | Amount | Payment | Amount | Balance
Vendor Names | ("X") | Date | No. | Due |  | Status | Date | Pay Date | Aging | Aging | Date |  | Date |  | Date |  | Date |  |  |  | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated
Accounts Payable
ICC Warrenty |  | 2008-09-01 00:00:00 | 6 | 15000 | 30 |  |  | 2008-10-05 00:00:00 |  |  | 2008-10-10 00:00:00 | 2000 | 2008-10-17 00:00:00 | 3000 | 2008-10-25 00:00:00 | 4000 | 2008-10-31 00:00:00 | 6000
Jonesville equip. backcharges |  | 2008-10-30 00:00:00 | 7 | 2000 | 45 |  |  | 2008-12-01 00:00:00
ICC Warrenty |  | 2008-10-25 00:00:00 | 5 | 4250 | 15 |  |  | 2008-11-15 00:00:00
East Noble Schools |  | 2008-08-15 00:00:00 | 4 | 5000 | 30 |  |  | 2008-10-20 00:00:00
Deam Lake |  | 2008-08-01 00:00:00 | 2 | 15000 | 60 |  |  | 2008-10-10 00:00:00
Spreadsheet: 594047d1539532689-creating-a-cell-that-is-uses-a-formula-to-provide-dollars-based-on-a-or-a-manual-entry-transfer
Sheet: Sheet1

 | Contingency | 80000
 | January | February | March | April | May | June | July | August | September | October | November | December | Year Total
% of yearly sales for that month | 0.0279805115522494 | 0.02732907624913694 | 0.02457510424915255 | 0.02910004407915524 | 0.0442507908892677 | 0.0948130926793495 | 0.149100668208787 | 0.192430867891261 | 0.193846861993236 | 0.1252277097953245 | 0.06034943457756176 | 0.03099583783551844 | 1
Adjustments | 2000