tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: gstorey__12017__SITHE_Jun0101
Sheet: Deals

ENRON CANADA DEALS REGARDING SITHE
Counterparty | Tagg# | Term | Vol (MM) | Deal Description
Engage | NH1353.1 | May 96 to Oct 04 | 31000 | ECC buys Empress gas for NX3 - $.41
Engage | NH1353.2 | Nov 04 to Oct 09 | 9600 | ECC buys Empress gas for NX3 - $.48
TransCanada | NH1353.3 to 8 | May 96 to Oct 04 | 31000 | TransCanada moves gas from Empress
TransCanada | NH1353.3 to 8 | Nov 04 to Oct 09 | 9600 | to Chip for tolls
Enron North America | NH1353.9/11 | May 96 to Oct 04 | 31000 | ECC sells Chip gas for NX3 - $.41 plus $.005 plus TCPL tolls
Enron North America | NH1353.10/12 | Nov 04 to Oct 09 | 9600 | ECC sells Chip gas for NX3 - $.48 plus $.005 plus TCPL tolls
Enron North America | E30623.2 | Nov 04 to Oct 14 | 15000 | ECC sells Chip gas for NX3 - $.65510 plus TCPL tolls
Enron North America | E34612.2 | Nov 04 to Oct 09 | 6400 | ECC sells Chip gas for NX3 - $.56 (W)/ NX3 - $.70 (S) plus TCPL tolls
Enron North America | E34612.2 | Nov 09 to Oct 14 | 16000 | ECC sells Chip gas for NX3 - $.56 (W)/ NX3 - $.70 (S) plus TCPL tolls
Enron North America | E34612.2 | Nov 14 to Dec 14 | 31000 | ECC sells Chip gas for NX3 - $.56  plus TCPL tolls
Note:  NH1353 to replace structure in FT-CAND-ERMS book E34614.1, E34613.3, E32934.14 and E32934.21
Spreadsheet: james_derrick__12760__PRC Meeting Corp Legal
Sheet: PRC Meeting Corp Legal

MEETING:  FUNCTIONAL LEGAL |  |  | Meeting Time:  12/06/00   1:00 PM
FUNCTIONAL BUSINESS HEAD:  [NAME] |  |  | EB 50M03
GROUP MEETING:  VICE PRESIDENT |  |  | 29 EMPLOYEES
EMPLOYEE NAME | SUPERVISOR NAME | PEER GROUP | DEPARTMENT | COMPANY | HIRE DATE | MID YEAR  RATING
APASU, YAO | LUNDSTROM, BRUCE D | ST | EI LEGAL - HOU AP / A/ CHI | APACHI | 10/01/1996 | STRONG
ARONOWITZ, ALAN | HAEDICKE, MARK E | ST | EMERGING MARKETS | ENA | 05/05/1993 | EXCELLENT
BROWN, [NAME] | SHERRIFF, [NAME] | COMM | EEL-EXECUTIVE (LDN) | EEL | 07/24/1995 | SUPERIOR
CORMAN, SHELLEY | HORTON, STANLEY C | CS | ETS REG AFFAIRS | ETS GROUP | 08/15/1988 | EXCELLENT
CULVER, DEBORAH | SHARP, VICTORIA T | ST | EES - LEGAL | EES | 08/02/1993 | EXCELLENT
DAVIS, ANGUS H | CARTER, REBECCA C | CS | MLP SERVICES | CORP | 01/02/1980 | STRONG
FOSSUM, DREW J | MORAN, [NAME] | ST | INTERSTATE LEGAL NNG | ETS GROUP | 09/14/1998 | EXCELLENT
GRAY, BARBARA N | HAEDICKE, MARK E | ST | GAS ASSETS | ENA | 04/26/1993 | STRONG
HODGE, JEFFREY T | HAEDICKE, MARK E | ST | PHYSICAL TRADING | ENA | 07/20/1993 | STRONG
KELLER, [NAME] | SHARP, VICTORIA T | ST | EES - LEGAL | EES | 11/17/1993 | STRONG
LABANOWSKI, E J | DONOVAN, WILLIAM R | CS | EPSC LEGAL SERVICES | CORP | 05/01/1979 | STRONG
LAMB, JOHN A | NEWELL, ERIC P | ST | LEGAL | WIND | 08/14/1995 | STRONG
LUNDSTROM, BRUCE | MCDONALD, REBECCA | ST | EI LEGAL - HOUSTON AP | APACHI | 05/04/1998 | EXCELLENT
MAYNARD, ANNE M | SHARP, VICTORIA T | ST | EES - LEGAL | EES | 11/17/1997 | EXCELLENT
MCCOPPIN, DOROTHY | MORAN, [NAME] | ST | INTERSTATE LEGAL FGT | ETS GROUP | 08/13/1986 | SATISFACTORY
MINTZ, JORDAN H | HERMANN, [NAME] | ST | TAX - ENA | ENA | 12/02/1996 | SUPERIOR
NEWELL, ERIC P | UMANOFF, ADAM S | ST | LEGAL | WIND | 07/15/1997 | STRONG
NOVAK, [NAME] | YOUNG, RANDEL R | ST | BRAZIL LEGAL RIO | ESA | 03/16/1998 | EXCELLENT
PLACE, [NAME] | CORDES, WILLIAM R | ST | NPNG LEGAL | ETS GROUP | 10/20/1980 | SUPERIOR
ROGERS, REX R | DERRICK JR., [NAME] | ST | LEGAL | CORP | 09/23/1985 | SUPERIOR
SAYRE, [NAME] | CUMBERLAND, [NAME] | ST | CALME - CB LEGAL | CARIBBEAN | 12/29/1994 | STRONG
SCHULER, W L | HAEDICKE, MARK E | ST | FINANCE ORIG, M&A | ENA | 02/23/1995 | EXCELLENT
SEFTON, SCOTT M | FASTOW, ANDREW S | ST | GLOBAL FINANCE LEGAL | CORP | 07/01/1994 | SATISFACTORY
SOLDANO, LOUIS P | MORAN, [NAME] | ST | ETS LEGAL OPERATIONS | ETS GROUP | 02/17/1992 | STRONG
TAYLOR, MARK E | HAEDICKE, MARK E | ST | PHYSICAL TRADING | ENA | 08/15/1994 | SUPERIOR
TWEED, SHEILA | HAEDICKE, MARK E | ST | POWER ASSETS | ENA | 01/06/1992 | EXCELLENT
WALLACE, STEPHEN | SHERRICK, JEFFREY B | ST | EGEP - LEGAL | EGEP | 03/24/1997 | STRONG
[NAME], [NAME] | WALLS JR, ROBERT H | ST | INTERNATIONAL LEGAL | CORP | 02/20/1995 | EXCELLENT
YOUNG, RANDEL R | BANNANTINE, [NAME] | ST | BRAZIL LEGAL RIO | ESA | 04/12/1996 | STRONG
Spreadsheet: 45181d1243955811-multiple-if-or-functions-nested-mround
Sheet: Sheet1

Part number | Description | Price Category | Team | Group | Family | Product | Type | USD | CAD | EUR | GBP | CNY |  | Conversion Factors
123507 | Example part description | Parts |  |  |  |  |  | 135 |  |  | 90.55000000000001 |  |  |  | CAD |  | EUR |  | GBP |  | CNY
 |  | Parts |  |  |  |  |  | 15 |  |  | 10.05 |  |  | PARTS |  |  |  |  | 0.524 | 1.28
 |  | SYSTEMS |  |  |  |  |  | 125 |  |  | 0 |  |  | PART KITS |  |  |  |  | 0.524 | 1.28
 |  | PART KITS |  |  |  |  |  | 95 |  |  | 63.7 |  |  | SYSTEMS
 |  | PART KITS |  |  |  |  |  | 161 |  |  | 110 |  |  | SYSTEM KIT
 |  | PART KITS |  |  |  |  |  | 162 |  |  | 110
Spreadsheet: 129233d1321509519-auto-populating-rows-on-separate-sheets-with-conditions-help-needed-1-
Sheet: Master

End  DATE | Eng # | Date Added | Comments | In Charge | Type | Model | Division | Staff | Code 1 | Code 2 | Code 3 | Code 4 | Code 5 | Code 6 | Code 7 | Code 8 | PRIORITY
2011-10-31 00:00:00 | 12345T |  | Changing Fabric Design | PATTY | AB |  |  |  |  |  |  |  |  |  | 406371DWCIGG | 406371DWCIGG
Spreadsheet: 093532a8-0569-45ce-b52e-45010cfeeb5c
Sheet: 4.1 Majors

 | Institution |  |  | Major Group ID/Major [NAME]
Indicator 4: Student Enrollment and Graduation by Major Group |  |  |  | AC - Accounting
Table 4.1: Major [NAME] |  |  |  | AG - Agriculture and Farming
Please identify your institution's specific majors and degrees offered by major group. If you have additional majors, please add them as needed. |  |  |  | AL - American Indian Languages
Major [NAME] |  |  |  | AS - American Indian Studies
I.D. | Major [NAME] | Specific Majors (and [NAME]) |  | AR - Art
AC | Accounting | (AA) |  | AU - Automotive Technology
AL | American Indian Languages | [NAME] (CT) |  | BI - Biology
AS | American Indian Studies | Lakota Studies (AA, BA); [NAME] (BS); [NAME] (AA); |  | BT - Building Trades
AR | Art | Fine Art (AA) |  | BU - Business
BT | Building Trades | Electrical Technology (AAS); General Construction (CT, AAS); |  | CH - Chemistry
BU | Business | Business Administration (BS); |  | CS - Computer Science
CS | Computer Science | Information Technology (AA, BS); |  | CT - Computer Technology
 |  |  |  | CL - Corrections/Law Enforcement
EA | Education-Paraprofessional | Child Development Associate (CT); Early Childhood (AA); Elementary Education (AA) |  | EA - Education-Paraprofessional
EO | Education-Professional | Early Childhood (BA); K-8 Elementary Education (BS); |  | EO - Education-Professional
ES | Environmental Science/Natural Resources | Natural Science (BS) |  | EN - English
HC |  |  |  | ES - Environmental Science/Natural Resources
HI | Hospitality Industry | Customer Service (CT, AAS) |  | GE - Geography
HS | Human Services | Social Work (BSW); Chemical Dependency Counseling (AA) |  | HS - Health Careers
LA | Liberal Arts/General Studies | Liberal [NAME] (AA); English and Communications (BA) |  | HI - Hospitality Industry
LS | Life Science | Life Science (AA) |  | HS - Human Services
NU | Nursing | Nursing (AA) |  | IP - Individualized Program
OA | Office Administration/Technology | Office Technology (CT, AAS); Office Software Applications (CT, AAS) |  | LA - Liberal Arts/General Studies
SC | Science | Science, Engineering & Mathematics (AA); Secondary Education Physical Science  (BS) |  | LS - Life Sciences
SS | Social Science | Social Science (AA, BA) |  | MA - Mathematics
VC | Vocational | program discontinued
MS | Master's | Lakota Leadership/Management (MA); Secondary/Middle/Elementary Educational Administration (MA) |  | NU - Nursing
UN | Undeclared/Nondeclared | Undeclared |  | OA - Office Administration/Technology
 |  |  |  | PA - Paralegal
 |  |  |  | PE - Pre-Engineering/Engineering
 |  |  |  | PV - Pre-Veterinary Science
 |  |  |  | SC - Science
 |  |  |  | SS - Social Science
Notes: |  |  |  | VC - Vocational/Career Programs
 |  |  |  | UD - Undeclared/Nondeclared
 |  |  |  | MS - Master's Degree Programs
Spreadsheet: 863409d1710907569-i-need-help-for-the-formula-base-on-the-table-template-1
Sheet: Sheet1

 |  |  |  |  |  |  |  | Regular hours | Regular OT
 |  |  |  |  |  |  |  | Maximum: 8 | [NAME] hrs
 |  |  |  |  |  |  |  |  | Overtime
 |  |  |  |  |  |  |  |  | [NAME] hrs
Day | Date |  |  |  |  |  | Total | Regular | Over | Double
 |  |  | Time In | Time Out | Time In | Time Out | Time | Time | Time | Time
Mon | 2024-01-08 00:00:00 | REGULAR | 07:00:00 | 20:00:00
Tue |  | REGULAR
Wed |  | REGULAR | 07:00:00 | 20:00:00
Thu |  | REGULAR | 07:00:00 | 15:00:00
Fri |  | OVERTIME | 07:00:00 | 15:00:00
Sat |  | OVERTIME | 07:00:00 | 17:00:00
Sun
Mon |  | REGULAR | 08:00:00 | 12:00:00 | 13:00:00 | 18:00:00
Tue
Wed
Thu
Fri
Sat
Sun
REGULAR
OVERTIME
HOLIDAY
Spreadsheet: 49833d1249259143-writing-outcomes-and-then-names-listed-below-something-like-this
Sheet: Sheet1

 |  |  | martin | wilson
 |  |  | 1 | 0
 |  |  | 1 | 0
 |  |  | 1 | 1
 |  |  | 1 | 1
 |  |  | 0 | 1
 |  |  | 0 | 1
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 1
 |  |  | 0 | 1
Spreadsheet: 9513322c-58dc-49d1-b168-bd44457d13ae
Sheet: Sheet1

analytica 2012 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (6 Entries):
 | 5 Laboratory apparatus 5.4 Laboratory technology and equipment 5.4.7 Laboratory equipment 5.4.7.8 Reverse osmosis equipment
No. | Company | Country | City | [NAME] | Hall/Booth
1 | membraPure GmbH | Germany | Hennigsdorf | 16761 | A1.213
2 | Miele & Cie. KG [NAME] | Germany | Gütersloh | 33332 | B1.201/302
3 | Siemens AG, I IA WT HUB EUR | Germany | Barsbüttel | 22885 | B1.417
4 | VWS Deutschland GmbH ELGA LabWater | Germany | Celle | 29227 | B1.340
5 | [NAME] GmbH | Germany | Leverkusen | 51381 | B1.217
6 | Zefa-Laborservice GmbH | Germany | [NAME] | 85630 | B1.121/220
Spreadsheet: 55910d1256062662-repeating-a-calculation-with-different-values-in-the-same-cell-704012
Sheet: Controls

Peak Controls
Peak number | LocX | SprX | [NAME] | SprY | Int
1 | 2 | 0.1 | 2 | 0.1 | 5
2 | 4 | 0.1 | 4 | 0.1 | 6
3 | 6 | 0.1 | 6 | 0.1 | 7
4 | 8 | 0.1 | 8 | 0.1 | 8
5 | 3 | 0.1 | 7 | 0.1 | 10
Spreadsheet: bbf54a85-70d7-406f-bcb8-ab745c545abc
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7509 | 55037 | Ana | [NAME] | ARG | 0 | 00:33:52 | 00:02:27 | 01:16:04 | 00:02:27 | 00:59:14 | 1 | 02:54:06
7509 | 55036 | [NAME] | Baez | ARG | 0 | 00:38:25 | 00:02:31 | 01:19:51 | 00:02:19 | 01:02:18 | 2 | 03:05:23
Spreadsheet: 5f4f1e36-f890-4dd3-b33e-d3c772be977b
Sheet: Sheet1

STATE OF NEW HAMPSHIRE | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
ELECTIONS DIVISION
STATE GENERAL ELECTION - November 4, 2008
COUNTY SUMMARY/BALLOTS CAST
 | Regular | Absentee | Total
Belknap County | 30176 | 3840 | 34016
Carroll County | 24891 | 4552 | 29443
Cheshire County | 39335 | 4032 | 43367
Coos County | 14894 | 1817 | 16711
Grafton County | 44588 | 5971 | 50559
Hillsborough County | 187741 | 19123 | 206864
Merrimack County | 73554 | 7825 | 81379
Rockingham County | 152046 | 17397 | 169443
Strafford County | 59149 | 5470 | 64619
Sullivan County | 20765 | 2237 | 23002
Totals | 647139 | 72264 | 719403
updated 1/15/09
Spreadsheet: 146113d1331904830-avg-function-when-you-have-0-inside-input-fields-aver
Sheet: Arkusz1

 |  |  |  |  |  | 1 | 2
 |  |  |  |  |  | 1 | 2
 |  |  |  |  |  | 1 | 2
 |  |  |  |  |  | 1 | 2
 |  |  |  |  |  | 1 | 2
 |  |  |  |  |  | 1 | 2
 |  |  |  |  |  | 1 | 2
 |  |  |  |  |  | 1 | 2
 |  |  |  |  |  | 1 | 2
 |  |  |  |  |  | 1 | 2
 |  |  |  |  |  | 1 | 2
 |  |  |  |  |  | 1 | 0
Spreadsheet: 805202d1668587825-time-date-condition-formula-support-support-required
Sheet: Sheet1

 |  |  |  |  |  |  |  | after 8 PM,else return same
 | Patient Name | Registered Date & Time | Authorised Date & Time |  | AM/PM | Hours |  | Requirement
 | [NAME] | 2022-11-10 20:11:27 | 2022-11-10 12:12:50 |  |  |  |  |  | if the registered data is after 8 pm, it should move to next day,and start with 8 AM
 | [NAME] | 2022-11-10 07:11:27 | 2022-11-10 12:12:50.270000
Spreadsheet: 781277d1653127985-obtain-the-numbers-of-a-list-depending-the-name-distribui-o-de-pe-as
Sheet: PEDRO

 |  |  | PEDRO
 |  |  | Nª PEÇA | DESCRIÇÃO | VALOR
 |  |  | 2
Spreadsheet: 33528d1229985871-excel-2007-populating-from-one-worksheet-to-another-rehab-cost-estimate
Sheet: Contractor Bid Sheet

 | [NAME]
 | Address
 | Labor & Material Items |  |  | Number needed |  | Quote
 | Replace Roof (Labor & Materials) |  |  | Contractor Measure
 | Paint Exterior (Labor & Materials) |  |  | Contractor Measure
 | Paint Interior (Labor & Materials) |  |  | Contractor Measure
 | Landscaping (Labor & Materials) |  |  | Contractor Measure
 | Foundation (Labor & Materials) |  |  | Contractor Measure |  |  |  |  | All Contractor Measure items require a separate detailed bid sheet
 | Driveway (Labor & Materials) |  |  | Contractor Measure
 | Central Heat and Air (Labor & Materials) |  |  | Contractor Measure
 | Drywall (Labor & Materials) |  |  | Contractor Measure
 | Electrical (Labor & Materials) |  |  | Contractor Measure
 | Plumbing (Labor & Materials) |  |  | Contractor Measure
 | Install Bathroom Cabinets |  |  | Contractor Measure
 | Install Kitchen Cabinets |  |  | Contractor Measure
 | Labor Only Items
 | Install Hot Water Heater |  |  | 1
 | Install Carpet |  |  |  | sq ft
 | Install Tile |  |  |  | sq ft
 | Install Linoleum |  |  |  | sq ft
 | Refinish existing wood floors |  |  |  | sq ft
 | Install Ceiling Fans |  | Yes
 | Install Overhead Lights |  | Yes
 | Install Blinds |  | Yes
 | Install Light Switches |  | Yes
 | Install GFI Outlets |  | Yes
 | Install Electrical Outlets |  | Yes
 | Install Switch & Outlet Covers |  | Yes
 | [NAME]
 | Replace Tub
 | [NAME]
 | Install Toilets
 | Install Kitchen Sink |  |  | 1
 | Install Kitchen Faucet |  |  | 1
 | Install Bathroom Sinks
 | Install Bathroom Faucets
 | Install Pedestal Sink
 | Install Vanity/ Sink Combo
 | Install Bathroom Exhaust Fan
 | Install Vanity Lights
 | Install Interior Door Knobs |  | Yes
 | Install Interior Doors
 | Install Exterior Doors
 | Install Door Knob/ Dead Bolt Combo
 |  |  |  | Total
 | Days to perform items quoted
 | Signature |  |  |  |  | Date
Spreadsheet: 833021d1686736614-date-and-time-into-one-collum-testexcel
Sheet: Sheet1

Staff no | Time In | Date In | Time In | Day in | Time Out | Day Out |  | Time/Days in office | Days | Time
1 | 09:00:00 | 2023-01-01 00:00:00 | 10:00:00 | 2023-01-01 00:00:00 | 01:00:00 | 2023-05-01 00:00:00
2 | 10:00:00 | 2023-01-02 00:00:00 | 11:00:00 | 2023-01-02 00:00:00 | 12:00:00 | 2023-05-07 00:00:00
3 | 11:00:00 | 2023-01-03 00:00:00 | 12:00:00 | 2023-01-03 00:00:00 | 07:00:00 | 2023-05-08 00:00:00
4 | 12:00:00 | 2023-01-04 00:00:00 | 13:00:00 | 2023-01-04 00:00:00 | 20:00:00 | 2023-05-21 00:00:00
5 | 13:00:00 | 2023-01-05 00:00:00 | 14:00:00 | 2023-01-05 00:00:00 | 15:00:00 | 2023-05-27 00:00:00
6 | 14:00:00 | 2023-01-06 00:00:00 | 15:00:00 | 2023-01-06 00:00:00 | 11:00:00 | 2023-05-11 00:00:00
7 | 15:00:00 | 2023-01-07 00:00:00 | 16:00:00 | 2023-01-07 00:00:00 | 04:00:00 | 2023-05-04 00:00:00
8 | 16:00:00 | 2023-01-08 00:00:00 | 17:00:00 | 2023-01-08 00:00:00 | 23:00:00 | 2023-05-08 00:00:00
Spreadsheet: 138854d1327964204-help-making-some-calculations-race-scoring-test
Sheet: A Group

Name |  | Race Dates |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Group | Overall
First |  | 2012-04-26 00:00:00 | 2012-05-03 00:00:00 | 2012-05-10 00:00:00 | 2012-05-17 00:00:00 | 2012-05-24 00:00:00 | 2012-05-31 00:00:00 | 2012-06-07 00:00:00 | 2012-06-14 00:00:00 | 2012-06-21 00:00:00 | 2012-06-28 00:00:00 | 2012-07-05 00:00:00 | 2012-07-12 00:00:00 | 2012-07-19 00:00:00 | 2012-07-26 00:00:00 | 2012-08-02 00:00:00 | 2012-08-09 00:00:00 | 2012-08-16 00:00:00 | 2012-08-23 00:00:00 | 2012-08-30 00:00:00 | 2012-09-06 00:00:00 | 2012-09-13 00:00:00
[NAME] |  | 20 | 16 | 20 | 2 | 18 | 20 | 2 | 20 | 14 | 20 | 2 | 14 | 20 | 2 | 16 | 20 | 14 | 2 | 20 | 12 | 2
[NAME] |  | 18 | 18 | 18 | 18 | 20 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18 | 18
[NAME] |  | 16 | 20 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 20 | 16 | 16 | 16 | 16 | 16 | 16
Stephen |  | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 20 | 14 | 14 | 20 | 14 | 14 | 14 | 14 | 20 | 14 | 14 | 14 | 14
Brent |  | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 12 | 20 | 12
[NAME] |  | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
Scott |  | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8
[NAME] |  | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6
Adam |  | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
[NAME] |  | 2 | 2 | 2 | 20 | 2 | 2 | 20 | 2 | 2 | 2 | 20 | 2 | 2 | 20 | 2 | 2 | 2 | 20 | 2 | 2 | 20
[NAME] |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
Kurt |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 784499d1655783055-formula-based-computation-instead-of-using-table-formula-base-excelforum
Sheet: trans

 | Source |  | Distribution | FINAl Trans. | Remarks
 | 74 | 5 | 0.08 | 5 | FAILED
 | 75 | 3 | 0.08 | 3 | Passed |  | Needed is formula based so that there is no need for the table
 | 76 | 3 | 0.08 | 2.92 | Passed
 | 77 | 3 | 0.08 | 2.84 | Passed
 | 78 | 2.75 | 0.08 | 2.76 | Fairly Satisfactory
 | 79 | 2.75 | 0.08 | 2.68 | Fairly Satisfactory
 | 80 | 2.75 | 0.08 | 2.6 | Fairly Satisfactory |  | sample grades |  | [NAME]
 | 81 | 2.5 | 0.08 | 2.52 | Fairly Satisfactory |  | 92.99
 | 82 | 2.5 | 0.08 | 2.44 | Fairly Satisfactory |  | 93
 | 83 | 2.5 | 0.08 | 2.359999999999999 | Fairly Satisfactory |  | 93.99
 | 84 | 2.25 | 0.08 | 2.279999999999999 | Satisfactory |  | 94
 | 85 | 2.25 | 0.08 | 2.199999999999999 | Satisfactory |  | 75
 | 86 | 2.25 | 0.08 | 2.119999999999999 | Satisfactory |  | 74.99
 | 87 | 2 | 0.08 | 2.039999999999999 | Satisfactory
 | 88 | 2 | 0.08 | 1.959999999999999 | Satisfactory
 | 89 | 2 | 0.08 | 1.879999999999999 | Satisfactory
 | 90 | 1.75 | 0.08 | 1.799999999999999 | Very Satisfactory
 | 91 | 1.75 | 0.08 | 1.719999999999999 | Very Satisfactory
 | 92 | 1.75 | 0.08 | 1.639999999999999 | Very Satisfactory
 | 93 | 1.5 | 0.08 | 1.559999999999999 | Very Satisfactory
 | 94 | 1.5 | 0.08 | 1.479999999999999 | Very Satisfactory
 | 95 | 1.5 | 0.08 | 1.399999999999999 | Very Satisfactory
 | 96 | 1.25 | 0.08 | 1.319999999999999 | Superior
 | 97 | 1.25 | 0.08 | 1.239999999999998 | Superior
 | 98 | 1.25 | 0.08 | 1.159999999999998 | Superior
 | 99 | 1 | 0.08 | 1.079999999999998 | Excellent
 | 100 | 1 | 0.08 | 1 | Excellent
Spreadsheet: 68956d1269485425-excel-2007-summarize-multiple-sheets-within-one-workbook-samplesheet
Sheet: Sheet1

 |  |  |  |  |  | WK: | 2 | PAYDATE: | 2010-02-03 00:00:00
WK | MARKET | POSITION | NAME |  | GROSS INCOME | TECH LABOR | MANAGEMENT | TRAINING PAY | REFERRAL BONUS | DROP MATERIALS | MULTISWITCHES | SERVICE IN 90'S | NRB'S | OTG'S | DAMAGE CLAIMS/OOP | [NAME]. | BACKGROUND | DPP CREDITS | OTHER | [NAME] | NET INCOME | NOTES | TOTAL RETENTION HELD TO DATE
 | ARIZONA | TECH | DOE |  | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | TULSA | ODU VAL | D |  | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 |  |  |  |  | 0
 | MADISON | GM | D |  | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  | 0
 | MILWAUKEE | ADMIN | D |  |  | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0
 | OKC |  | D |  |  | 0 |  |  |  |  | 0 | 0 |  |  |  | 0 | 0
 |  |  | D
 |  |  | D
 |  |  | D
 |  |  | TOTALS**************************
 | ARIZONA | ADMIN | [NAME] | 0 | 0 |  | 0
 | ARIZONA | ADMIN | [NAME] | 0 | 0 |  | 0
 | ARIZONA | ADMIN | [NAME] | 0 | 0 |  | 0
 | TULSA | ADMIN | [NAME] | 0 | 0 |  | 0
 | MADISON | ADMIN | [NAME] | 0 | 0 |  | 0
 | MADISON | GM | [NAME] | 0 | 0 |  | 0
 | ARIZONA | GM | [NAME] | 0 | 0 |  | 0
 | TULSA | GM | [NAME] | 0 | 0 |  | 0
 | ARIZONA | ODU VAL | [NAME] | 0 | 0 |  | 0
Spreadsheet: 734015d1621946119-sumif-function-for-cells-that-will-be-filtered-subtotal-template-extract
Sheet: Sheet1

 | [NAME] | Description | Qty | Unit | Rate | Total | Sell
 | General Material | Item 1 | 12 | m2 | 6.779999999999999 | 81.35999999999999 | 105.768 |  |  |  |  | Total ex mark up
 | General Material | Item 2 | 12 | m2 | 140 | 1680 | 2184 |  |  |  | General Material
 | General Material | Item 3 | 1 | item | 60 | 60 | 78 |  |  |  | Labour
 | General Material | Item 4 | 2 | bags | 3.55 | 7.1 | 9.23 |  |  |  | Plant
 | General Material | Item 5 | 12 | m2 | 6.36 | 76.32000000000001 | 99.21600000000001 |  |  |  | Design
 | General Material | Item 6 | 3 | m | 4 | 12 | 15.6 |  |  |  | Sustenance etc
 | General Material | Item 7 | 3 | m | 5 | 15 | 19.5 |  |  |  | Modules
 | General Material | Item 8 | 1 | bags | 6.45 | 6.45 | 8.385 |  |  |  | [NAME]
 | Labour | Item 9 | 1.5 | days | 150 | 225 | 292.5
 | [NAME] | Item 10 | 1 | item | 2890 |  | 44597.501
Spreadsheet: 808883d1670741171-coffee-bean-inventory-and-roasting-tracker-fifo_model_for_many_products_no_vba_v5
Sheet: multiple products

 |  |  | INVENTORY MODEL. FIFO CALCULATION. MULTIPLE  SKUs!!!!!!!
 |  |  |  | Purchase |  |  | Usage |  |  |  | Closing balance
 |  |  | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price | Quantity | Value | Unit price
 |  |  | A
 |  |  | B
 | INSERT ROWS |  | X
 |  |  | C
 |  |  | Total |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INVENTORY SPLIT BY FIFO
 |  |  | Purchase |  |  |  | Usage |  |  |  |  |  |  |  | ONLY FOR EXCEL GEEKS & NERDS!!! |  |  |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total
 | SKU/ID | ID | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price |  |  |  |  | Technical column 1 | Technical column 2 | Technical column 3 | Value | Value with validation |  | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price | SKU | Quantity | Value | Unit price
 |  |  |  | 0 | 0 | 0 | do not amend this row, ANYWHERE!!! |  |  |  |  |  |  |  | do not amend this row, ANYWHERE!!!
 |  |  |  | 0 | 0 |  | do not amend this row, ANYWHERE!!! |  |  |  |  |  |  |  | do not amend this row, ANYWHERE!!!
 |  | 1 | A | 3 | 100 |  | A | 1
 |  |  | A | 6 | 100 |  | A | 4
 |  |  | B | 12 | 20 |  | A | 1
 |  |  | A | 7 | 7 |  | A | 8
 |  |  | A | 8 | 64 |  | B | 10
 |  |  | A | 6 | 1 |  | B | 1
 |  |  | B | 2 | 1 |  | A | 12
 |  |  | A | 2 | 4 |  |  | 12
 |  |  | A | 1 | 10 |  |  | 12
 |  |  | A | 12 | 0 |  |  | 12
 |  |  | A | 0 | 0 |  | B | 1
 |  |  | A | 0 | 0
 |  |  | A | 0 | 0
 |  |  | A | 0 | 0
 |  |  | C | 10 | 150
 |  |  | C | 12 | 123
 |  |  | X | 9 | 100
 |  |  | X | 8 | 90
 |  |  | X | 12 | 80
 |  |  | X | 15 | 70 |  | X | 36
 |  |  |  |  |  |  |  |  |  |  |  | AND THEN COPY FORMULA
 |  |  |  |  |  |  |  |  |  |  |  | FROM ROW 34
 |  | 1000 | C | 1 | 9 |  | C | 21
Spreadsheet: 7da32d30-6e3c-4030-ab2e-dea17ff1ba21
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Inception Media | 617742220797 | [NAME] | [NAME]: [NAME], A | 2011-06-07 | DVD | Gospel | 19.98 | Y | Available
Inception Media | 617742218794 | Various | Soul Of The Church | 2011-06-07 | DVD | Gospel | 14.98 | Y | Available
Spreadsheet: 804717d1668244062-need-a-between-and-if-i-think-between-and-if
Sheet: Sheet1

12
Min | [NAME]
1 | 5
6 | 10
11 | 15
16 | 20
21 | 25
Need to determine where to put value in A1 in the table
If [NAME] is less than the Min then display a 0
If [NAME] is also geater than [NAME], then display the [NAME]
If [NAME] is between the Min and [NAME], then display A1
Below is what I'm looking for…
Min | [NAME]
1 | 5 | 5
6 | 10 | 10
11 | 15 | 12
16 | 20 | 0
21 | 25 | 0