tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 425ac5e8-24d6-428e-82c7-b842497460a2
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
 |  |  |  |  |  |  |  |  | Table 25 | Household by type and number of persons 15 years old or more
 |  |  |  |  |  |  | 2009 Annual Average |  |  |  |  |  |  |  |  |  | (Ten thousand households)
 |  |  |  |  |  |  | Type of household |  | Total | Number of persons 15 years old or more in household
 |  |  |  |  |  |  |  |  |  | Average number of persons 15 years old or more in household (persons)
 |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 persons
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | or more
 |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
2500 | 84*D0 |  | 1 |  |  |  | Total | 1 | 5111 | 2.12 | 1647 | 2050 | 784 | 471 | 113 | 37 | 9
2500 | 84*D0 |  | 1 |  |  |  | Two-or-more-person household | 2 | 3520 | 2.63 | 56 | 2050 | 784 | 471 | 113 | 37 | 9
2500 | 84*D0 |  | 1 |  |  |  | Relative household | 3 | 3515 | 2.63 | 56 | 2046 | 783 | 470 | 113 | 37 | 9
2500 | 84*D0 |  | 1 |  |  |  | Nuclear family household | 4 | 2897 | 2.39 | 56 | 1968 | 583 | 262 | 26 | 1 | 0
2500 | 84*D0 |  | 1 |  |  |  | Other relative household | 5 | 618 | 3.73 | - | 77 | 200 | 209 | 87 | 36 | 9
2500 | 84*D0 |  | 1 |  |  |  | Non-relative household | 6 | 5 | 2.05 | - | 4 | 0 | 0 | - | - | -
2500 | 84*D0 |  | 1 |  |  |  | One-person household | 7 | 1591 | 1 | 1591 | - | - | - | - | - | -
Spreadsheet: 04c10e3e-ce10-4214-94b6-b5ee2061eecc
Sheet: Sheet1

[NAME] of State Travel Request | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
This form is to be completed and approved in advance of making travel plans for any college employee (while in active
pay status) or student, who plans to travel outside the State of Minnesota.  If reimbursement will not be sought, the
request must still be processed, although it is not necessary to include estimated travel costs.
NAME: |  | List name(s) and title(s) of staff or students making trip.
(use separate
page if
necessary)
EVENT:
LOCATION: |  | Provide address of event site (include phone number).
DATES: |  | Beginning Date/Time of event:
 |  | Ending Date/Time of event:
 |  | Departure Date/Time:
 |  | Return Date/Time:
COSTS: |  | Estimate cost of trip |  |  |  |  | Mode of travel:
 |  | 1. [NAME] (round trip) |  |  | $ |  |  | Air
 |  | 2. LODGING |  |  | $ |  |  | Private Car
 |  | 3. MEALS |  |  | $ |  |  | Motor Pool Vehicle
 |  | 4. REGISTRATION |  |  | $ |  |  | Other (specify):
 |  | 5. OTHER (specify) |  |  | $ |  | Person making trip should initial
 |  |  |  |  |  |  | one of the statements below:
 |  |  |  |  |  |  |  | I have planned this trip early
 |  |  |  |  |  |  |  | in order to achieve the most
 |  |  |  |  |  |  |  | economical and practical
 |  |  |  |  |  |  |  | transportation, lodging and
 |  |  |  |  |  |  |  | other costs.
 |  | ESTIMATED TOTAL* |  |  | $
 |  |  |  |  |  |  |  | It was not possible to achieve
 |  |  |  |  |  |  |  | lower costs for the items listed
 |  | * If the actual cost of the trip exceeds the estimate |  |  |  |  |  | to the left because:
 |  | total by more than 10%, reapproval must be granted.
 |  | Source of Funding: Cost Center #
 |  | or list other
RATIONAL: |  | Why is this trip in the best interest of the college/system?
These approvals must be completed in order.  If approval is not granted, an explanation will be provided on the back of this form. |  |  | Approved
 |  |  | Not Approved
 |  |  |  | Supervisor Signature (Print) |  |  |  |  | Date
 |  |  | Approved
 |  |  | Not Approved
 |  |  |  | CAO, CFFO, CHRO, CSAO Signature (Print) |  |  |  |  | Date
 |  |  | Approved
 |  |  | Not Approved
 |  |  |  | President/Designee Signature (Print) |  |  |  |  | Date
 |  |  |  |  |  |  |  | version 1.2 11/29/2010
Spreadsheet: 271328d1381914320-countifs-a-b-c-or-d-0a1ab-testing-stats-master-1
Sheet: AB Testing by Country

 | Geek Culture |  |  | Science & Research |  |  | Personal/Opinion |  |  | Historic |  |  | AppStore Rating |  |  | Quotation |  |  | Anecdote/Fact |  |  | Question |  |  | App's Success |  |  | Country Specific |  |  | Endorsement |  |  | Love/Sex
 | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | % | No. of Promos | Won | %
Canada
UK
Australia
Germany
Russia
France
Sweden
Spain
Italy
Netherlands
Norway
Denmark
Korea
Turkey
Japan
Finland
Spreadsheet: 735478d1623015546-if-and-or-function-true-is-equation-with-neg-result-false-is-equation-with-pos-result-draft-certificate
Sheet: Worksheet

 |  | Light Freeboards: |  |  |  | Heavy Freeboards:
Length |  | Port Bow: |  | Starboard Bow: |  | Port Bow: |  | Starboard Bow:
[NAME] |  | [NAME]: |  | Starboard Mid: |  | [NAME]: |  | Starboard Mid:
Hull |  | [NAME]: |  | [NAME]: |  | [NAME]: |  | [NAME]:
Sound Side | Port | Port WLL: | 165 | Starboard WLL: | 185 | Port WLL: |  | Starboard WLL:
[NAME] |  | [NAME]: |  |  |  | AWLH:
[NAME] (L) |  |  |  | MWL:
Log to Shear |  | List: |  | Trim: | 2 | List: |  | Trim:
Log to Hole Edge |  | Direction: |  | Direction: | Bow | Direction: |  | Direction:
Side to [NAME]
B/H to [NAME] |  |  | Light Tank Soundings:
Deck to Rake |  |  | Observed | Tank Length | [NAME] (d) | Trim Correction | Sound Corr. | Wedge | Contents | Deduction
Stern to Marks |  | Bow:
Shear to Marks |  | No 1:
[NAME] |  | No 2: |  |  | 15
[NAME] |  | No 3:
Bow Length (Box) |  | No 4:
No 1 Length |  | No 5:
No 2 Length |  | No 6:
No 3 Length |  | No 7:
No 4 Length |  | No 8:
No 5 Length |  | No 9:
No 6 Length |  | No 10:
No 7 Length
No 8 Length |  |  | Heavy Tank Soundings:
No 9 Length |  |  | Observed | Tank Length | [NAME] (d) | Trim Corrected | Sound Corr. | Wedge | Contents | Deduction
No 10 Length |  | Bow:
Stern Length |  | No 1:
[NAME] (H) |  | No 2:
 |  | No 3:
 |  | No 4:
 |  | No 5:
 |  | No 6:
 |  | No 7:
 |  | No 8:
 |  | No 9:
 |  | No 10:
 |  | FAM: |  |  |  | FAM:
 |  | MSM: |  |  |  | MSM:
 |  | MOM: |  |  |  | MOM:
 |  | QTR: |  |  |  | QTR:
 |  |  |  | Displace:
 |  |  |  | Density:
 |  |  |  | Cargo Poundage:
 |  |  |  | Deductions:
 |  |  |  | Short Tons
 |  |  |  | Tonnes:
Spreadsheet: 80626d1280849521-vba-dropdowns-from-named-ranges-dropdowntesting
Sheet: Sheet1

wClass/Wattribute | Wvalue
11 | 1
11 | 2
12 | 3
12 | 4
12 | 5
12 | 6
12 | 7
13 | 8
13 | 9
13 | 10
13 | 11
14 | 12
14 | 13
15 | 14
15 | 15
15 | 16
15 | 17
15 | 18
Spreadsheet: 864800d1711949502-from-static-to-dynamic-cell-reference-via-indirect-function-raw-materials-record-aligw
Sheet: Pigment Blue

Raw Material |  | Pigment Blue
Date | Description | Batch Processed Quantity |  | Quantity Stored ([NAME]'s) | Quantity Issued ([NAME]'s) | Total Quantity Remaining ([NAME]'s) | Bilty or Batch (Description)
 |  | Qty | [NAME]'s
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
2023-09-30 00:00:00 |  |  |  |  |  | 12.056
2023-10-27 00:00:00 |  |  |  |  | 4.29
2024-01-05 00:00:00 |  |  |  |  | 4.29
Total
Spreadsheet: 41071d1239550327-lookup-question-simplyvlookup
Sheet: Master List

Companies | Symbol | Price
Company A | CA | 5 |  | This sheet will be updated weekly and pulled from for info
Company B | CB | 3.23
Company C | CC | 3.45 |  | I want to vlookup the company name to get the value (2 cells to right)
Company D | CD | 3.33
Company E | CE | 1.23 |  | The Team sheets just use vlookup instead of hard coding the formulas
Company F | CF | 1.56
 |  |  |  | There are over 50 teams so the vlookup would prevent errors.
 |  |  |  | Thank you for your time, it's very much appreciated.
Spreadsheet: 108640d1305661730-trying-to-make-a-timeline-from-a-list-of-dates-using-vlookup-excel-problem
Sheet: Sheet1

 | 2011-01-01 00:00:00 | car accident
 | 2011-01-02 00:00:00 | windshield repaired
 | 2011-01-05 00:00:00 | trunk fixed
 | 2011-01-16 00:00:00 | brakes repaired
 |  |  | 2011-01-01 00:00:00 | 2011-01-02 00:00:00 | 2011-01-03 00:00:00 | 2011-01-04 00:00:00 | 2011-01-05 00:00:00 | 2011-01-06 00:00:00 | 2011-01-07 00:00:00 | 2011-01-08 00:00:00 | 2011-01-09 00:00:00 | 2011-01-10 00:00:00 | 2011-01-11 00:00:00 | 2011-01-12 00:00:00 | 2011-01-13 00:00:00 | 2011-01-14 00:00:00 | 2011-01-15 00:00:00 | 2011-01-16 00:00:00
Spreadsheet: 741381d1627008623-formula-to-look-into-sheet-named-here-and-extract-values-into-columns-in-sheet-named-output-extract-values-into-desired-columns-ans-4
Sheet: Here

S/N | Name + Unique # | Name | Sales # | Sales Code | Sales #-1 | Sales #-2 |  |  | Condition | Helper 1 | Helper 2
15 | Desk, Vest - 15 | Desk, Vest | 1234567 | BPC | 1 | 1 |  |  | TNT
1 | Dentist, Coming - 1 | Dentist, Coming | 9999999 | ABB | 1 | 2 |  |  | YTN
1 | Dentist, Coming - 1 | Dentist, Coming | 9999999 | BPC | 1 | 1 |  |  | PNT
1 | Dentist, Coming - 1 | Dentist, Coming | 9999999 | YTN | 2 | 2
2 | Difee, Leopard - 2 | Difee, Leopard | 8888888 | BPC | 1 | 1
4 | [NAME], Mikel - 4 | [NAME], Mikel | 7777777 | BPC | 1 | 1
4 | [NAME], Mikel - 4 | [NAME], Mikel | 7777777 | TNT | 1 | 1
Spreadsheet: 685970d1594299145-keep-getting-my-formula-is-missing-parenthesis-example-dataxlsx
Sheet: Reconciliation

 | Product Line
 | Product Code
 | Per Patient Costs |  |  | Monday | Tuesday | Cost Centre to credit
 | Staff time in minutes per patient visit
 | Packing Line | T1
 | Labellers | T2
 | Staff cost per patient visit
P | Packing Line Hourly Rate |  | 1.67
P | Labellers Hourly Rate |  | 0.6
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 |  |  |  | 0 | 0
 | Overheads per patient visit
O | Overheads |  | 0.7
O | building fund |  | 0.2
 | Total costs per patient visit
 | AGREED Cost With Suppliers
 | TOTAL Invoices paid
 | OUTSTANDING BALANCE
 | Visits from Costing Template
 | Totals from Costing Template
 | Activity Log |  |  |  |  | Amount per patient per invoice
 |  | Invoice Number
Spreadsheet: 0adb0392-cc85-4dc6-bc2f-295fadac5ef4
Sheet: Sheet1

Unnamed: 0 | GUEST EXPENSE VOUCHER | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 |  |  |  |  |  |  |  | Assigned Control Number
 |  | Date: |  |  | Page: | ______  of | _______
 |  | BUSINESS UNIT | ACCOUNT | FUND | ORGANIZATION | PROGRAM | SUB CLASS | PROJECT    GRANT |  | Form No           BA4
NAME OF EMPLOYEE |  |  |  |  |  |  | EMPLOYEE SOCIAL SECURITY NUMBER
OPERATING UNIT TITLE (COLLEGE OR CENTRAL OFFICE TITLE) |  |  |  |  |  |  | WORK LOCATION
ATTACH A RECEIPT FOR EACH ITEM
 | PART 1
 | DATE | TYPE OF EXPENSE |  |  | EXPLANATION |  |  |  |  | AMOUNT
 |  |  |  |  |  |  | TOTAL FOR PART 1
 | PART 2
 | ENTERTAINMENT OF OFFICIAL GUESTS (ATTACH ALL RECEIPTS)
 | DATE AND PURPOSE OF GUEST ENTERTAINMENT
 | NAMES OF [NAME] AND CO-HOSTS |  |  |  |  | NAMES OF OFFICIAL GUESTS
 |  |  |  |  |  |  |  | GRAND TOTAL
EMPLOYEE SIGNATURE |  |  |  |  | DATE
APPROVAL SIGNATURE |  |  |  |  | DATE |  | AUDITOR SIGNATURE AND DATE
Spreadsheet: mike_grigsby__27930__HS_WESTminusPA1024
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEST NATURAL GAS BASIS POSITIONS
 | 2001-10-24 00:00:00
 | West Region Basis Notional
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Intra-Month | Change | Prompt Month | Change | Winter 2001-02 | Change | Summer 2002 | Change | Winter 2002-03 | Change | Remainder | Change | Total | Change
 | TIME BUCKET/KEY: |  |  |  | REPORT REGION |  |  |  |  |  |  |  |  | RISK TYPE |  | 1
 | West Region Basis Notional
 | NGI-PGE/CG |  |  |  | NGI-PGE/CG |  | GDP-PG&E/CITIGA | NGI-PGE/CG | GDP-PG&E/LG-PKG |  |  |  | M | D
 | NGI-MALIN |  |  |  | NGI-MALIN |  | GDP-MALIN-CTYGA | NGI-MALIN |  |  |  |  | M | D
 | NGI-SOCAL |  |  |  | NGI-SOCAL | IF-SOCAL | GDP-CAL BORDER | NGI-SOCAL |  |  |  |  | M | D
 | TOPOCK |  |  |  | NGI-SOBDR-PG&E |  | NGI-SOBDR-PG&E |  |  |  |  |  | M | D
 | NWPL-ROCKIES |  |  | NW-STANFIELD | IF-NWPL_ROCKY_M | IF-QUESTAR | GDP-WYOMING | GDP-KERN/OPAL | GDP-NW STANFIEL | IF-NWPL_ROCKY_M | IF-QUESTAR | GDP-NWPL_ROCKYM | M | D
 | CIG-ROCKIES | IF-CIG/WINDRVR | IF-CIG/WIC | IF-CIG/RKYMTN | IF-CIG/SOUTHERN | IF-CIG/GLENROCK | IF-CIG/ROCKPORT | GDP-CIG/RKYMTN | GDP-CIG/CHEYENN | IM-CIG/SOUTHERN | IM_WINDRIVER |  | M | D
 | PERMIAN |  | IF-TW/PERMIAN |  | IF-ELPO/PERMIAN | IF-NNG/TOK | GDP-ELPO/PERM2 | IF-ELPO/PERMIAN | IF-TW/PERMIAN |  |  |  | M | D
 | SAN JUAN |  | IF-BONDAD(100%) | IF-ELPO/SJ | IF-EPSJ(BONDAD) |  | GDP-ELPO/SANJUA |  | IM-TW/SJ | IF-EPSJ(BONDAD) |  |  | M | D
 | KINGSGATE |  |  |  | CGPR-KINGSGATE |  | CGPR-KINGSGATE |  |  |  |  |  | M | D
 | WAHA |  |  |  | IF-WAHA-TX | IF-WAHA | WAHA KCBT | GDP-WAHA |  |  |  |  | M | D
 | Other |  |  |  |  |  |  |  |  |  |  |  | M | D
 | TOTAL
 | Western Canada Region Notional
 | SUMAS |  |  |  | IF-NTHWST/CANBR |  | SUMAS-US/IM | GDP-NTHWST/CANB | IF-NTHWST/CANBR |  |  |  | m | D
 | AECO/EMPRESS/STA2 |  |  |  | CGPR-AECO/BASIS |  | GD-CGPR-AECO/AV | GD-AECOCD/FRWKD | GD-AECOUS/FRWKD | [NAME] | GDP-AECO |  | m | D
 | Other |  |  |  |  |  |  |  |  |  |  |  | M | D
 | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  | p
 | West Summary |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Intra-Month | Change | Prompt Month | Change | Winter 2001-02 | Change | Summer 2002 | Change | Winter 2002-03 | Change | Remainder | Change | Total | Change
 | TIME BUCKET/KEY: |  |  |  | REPORT REGION |  |  |  |  |  |  |  |  | RISK TYPE |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2001-10-01 00:00:00 |  | 2001-11-01 00:00:00 |  | Dec-01/Mar-02 |  | Apr-02/Oct-02 |  | Nov-02/Mar-03 |  | Apr-03/Mar-29
 | CALIFORNIA
 | Socal
 | PG&E CTYG & TOPOCK
 | Malin
 | NorthWest
 | Sumas
 | Aeco & Kingsgate
 | Rockies (NW & CIG)
 | SouthWest
 | San Juan
 | Permian
 | Waha
Spreadsheet: 100242d1298647431-graph-dynamic-to-pick-up-only-names-samepl_graph_removezeros
Sheet: Summary Graph

 |  |  | 1 | 1
 |  |  |  |  | select tick mark to illustrate a particular metric on the graph.
 |  |  | ISE Performance |  | ISE Performance | 0 |  |  |  |  |  |  |  |  |  |  | Error checker
 |  | ISE Name | YTD Purge Performance | YTD Purge Budget |  |  |  |  |  |  |  |  |  |  |  |  | YTD Purge Performance | YTD Purge Budget
 |  | [NAME] | 12222 | 15000 | 12222 | 15000 |  |  |  |  |  |  |  |  |  |  | OK | OK
 |  | [NAME] | 14560 | 17000 | 14560 | 17000 |  |  |  |  |  |  |  |  |  |  | OK | OK
 |  | [NAME] | 7500 | 9000 | 7500 | 9000 |  |  |  |  |  |  |  |  |  |  | OK | OK
 |  | 0 | #N/A | #N/A | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  | 0 | #N/A | #N/A | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  | 0 | #N/A | #N/A | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  | 0 | #N/A | #N/A | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  | 0 | #N/A | #N/A | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  | 0 | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 189232d1351123271-calculating-value-between-two-points-solar102412
Sheet: May

 |  | Service Dates: |  | 2012-05-03 00:00:00 |  |  | thru | 2012-06-03 00:00:00
 | PG&E RATES
 | T1 |  | T2 |  | T3 |  | T4 |  | T5
 | Baseline |  | 101-130% |  | 131-200% |  | 201-300% |  | 301%+
 | 1118.016 |  | 1118.016 | 1453.4208 | 1453.4208 | 2236.032 | 2236.032 | 3354.048 | 3354.048
 | 0.12845 |  | 0.14602 |  | 0.2994 |  | 0.3394 |  | 0.3394
 | 749.0400000000001 |  |  | 0 |  | 0 | 0 |  | 0
 | RATE CHARGES
 | T1 |  | T2 |  | T3 |  | T4 |  | T5
 | 96.21418800000002 |  | 0 |  | 0 |  | 0 |  | 0
 | Total Consumed |  |  | PG&E |  |  |  | Solar
 | 749.0400000000001 |  |  | 66 |  |  |  | 683.0400000000001
 | Total Charges |  |  | PG&E |  |  |  | Solar Savings
 |  |  |  | Billed |  | Min
 | 96.21418800000002 |  |  | 8.5 |  | 4.78 |  | 82.93418800000002
 |  |  |  |  | 13.28
 | Date | Solar |  | Date | Solar |  |  | Total
 | 2012-05-01 00:00:00 |  |  | 2012-05-18 00:00:00 | 22.4 |  |  | Solar | 683.0400000000001
 | 2012-05-02 00:00:00 |  |  | 2012-05-19 00:00:00 | 20.5
 | 2012-05-03 00:00:00 | 23.1 |  | 2012-05-20 00:00:00 | 19.7
 | 2012-05-04 00:00:00 | 20.3 |  | 2012-05-21 00:00:00 | 20.33 |  | [NAME] |  | 1.057105200095855
 | 2012-05-05 00:00:00 | 23.72 |  | 2012-05-22 00:00:00 | 21.84 |  | Estimate |  | 646.141935483871
 | 2012-05-06 00:00:00 | 22.34 |  | 2012-05-23 00:00:00 | 22.2 |  | Actual |  | 683.0400000000001
 | 2012-05-07 00:00:00 | 21.2 |  | 2012-05-24 00:00:00 | 21.9 |  | Estimate
 | 2012-05-08 00:00:00 | 20.23 |  | 2012-05-25 00:00:00 | 23 |  |  |  | May | Jun
 | 2012-05-09 00:00:00 | 19.3 |  | 2012-05-26 00:00:00 | 23.31 |  | Proposed Prod |  | 624 | 624
 | 2012-05-10 00:00:00 | 21.1 |  | 2012-05-27 00:00:00 | 22.43 |  | Days |  | 31 | 30
 | 2012-05-11 00:00:00 | 21.24 |  | 2012-05-28 00:00:00 | 22.43 |  | Per Day |  | 20.12903225806452 | 20.8
 | 2012-05-12 00:00:00 | 20.02 |  | 2012-05-29 00:00:00 | 21.93 |  | Billed Days |  | 29 | 3
 | 2012-05-13 00:00:00 | 19.9 |  | 2012-05-30 00:00:00 | 21.2 |  | Total |  | 583.741935483871 | 62.40000000000001
 | 2012-05-14 00:00:00 | 22.31 |  | 2012-05-31 00:00:00 | 20.31 |  |  | T2 | -368.976
 | 2012-05-15 00:00:00 | 21.92 |  | 2012-06-01 00:00:00 | 19.83 |  |  |  | 0.01757
 | 2012-05-16 00:00:00 | 19.84 |  | 2012-06-02 00:00:00 | 22.16 |  |  | T3 | -704.3808
 | 2012-05-17 00:00:00 | 19.45 |  | 2012-06-03 00:00:00 | 21.6 |  |  |  | 0.15338
 |  |  |  |  |  |  |  | T4 | -1486.992
 |  |  |  |  |  |  |  |  | 0.03999999999999998
Spreadsheet: 855309d1704914493-return-o-or-1-if-cell-value-is-found-in-2nd-worksheet-match
Sheet: Target Groups

Target Groups
521.01.1
528.11.3
541.18.1
541.21.1
545.02.1
528.10.2
541.21.2
543.04.2
528.10.4
528.16.1
528.16.2
541.08.1
541.08.3
531.13.4
543.04.1
541.18.2
532.06.1
541.15.1
541.19.2
544.04.1
Spreadsheet: 31175d1226983089-calculate-cells-that-contain-a-formula-racing-team-bvj-
Sheet: SM 

Category | Slip - 1 | Pts | [NAME] | Pts | Slip - 3 | Pts
Dial In | 12.41 |  | 12.41 |  | 12.41
ET | 12.42 |  | 12.63 |  | 12.55
Difference | 0.009999999999999787 |  | 0.2200000000000006 |  | 0.1400000000000006
RT
60FT
Attendance | 1 | 1 | 1 | 1 | 1 | 1
> 3/10 | 0 | 0 | 0 | 0 | 0 | 0
2/10 - 3/10 | 0 | 0 | 1 | 2 | 0 | 0
1/10 - 2/10 | 0 | 0 | 0 | 0 | 1 | 15
1/100 - 1/10 | 1 | 30 | 0 | 0 | 0 | 0
New ET Best 1 |  | 0 |  | 0 |  | 0
New ET Best 2 |  | 0 |  | 0 |  | 0
New ET Best 3 |  | 0 |  | 0 |  | 0
New 60ft Best 1 |  | 0 |  | 0 |  | 0
New 60ft Best 2 |  | 0 |  | 0 |  | 0
New 60ft Best 3 |  | 0 |  | 0 |  | 0
Light 1 |  | 0 |  | 0 |  | 0
Light 2 |  | 0 |  | 0 |  | 0
Light 3 |  | 0 |  | 0 |  | 0
Index |  | 0 |  | 0 |  | 0
Exact Dial | 0 | 0 |  | 0 |  | 0
Sub-Total | 2 | 31 | 2 | 3 | 2 | 16
Spreadsheet: 105197d1302627299-transfer-data-from-master-sheet-to-different-sheets-sample
Sheet: Science Test

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25
[NAME] | 80 | 85 | 90
[NAME] | 85 | 90 | 95 | 80 | 85
Spreadsheet: 782214d1653910507-formula-to-get-data-horizontal-with-collumn-name-example-v3-1-
Sheet: Sheet1

INT | Command_macro | Command_INT | Column1 | Column2 | outcome
G1/0/1 | Other Cell data 1
G1/0/2 | Other Cell data 2
G1/0/3 | Other Cell data 3
G1/0/4 | Other Cell data 4
G1/0/5 | Other Cell data 5
G1/0/6 | Other Cell data 6
G1/0/7 | Other Cell data 7
G1/0/8 | Other Cell data 8
G1/0/9 | Other Cell data 9
G1/0/10 | Other Cell data 10
Spreadsheet: 799359d1665056657-date-condition-with-weekdays-test
Sheet: Sheet1

Store | Week day | Date | [NAME]
METRO Constanta | Mon to Fri | 2022-10-01 00:00:00
METRO CONSTANTA2 | Mon to Fri | 2022-10-01 00:00:00
METRO Ploiesti | Mon to Fri | 2022-10-01 00:00:00
METRO Craiova | Mon to Fri | 2022-10-01 00:00:00
METRO BRASOV 2 | Mon to Fri | 2022-10-02 00:00:00
METRO Iasi | Tue to Sat | 2022-10-02 00:00:00
METRO Brasov | Mon to Fri | 2022-10-01 00:00:00
METRO Galati | Mon to Fri | 2022-10-01 00:00:00
METRO PITESTI | Mon to Fri | 2022-10-01 00:00:00
METRO Sibiu | Tue to Sat | 2022-10-03 00:00:00
METRO Oradea | Tue to Sat | 2022-10-03 00:00:00
METRO Punct Satu Mare | Tue to Sat | 2022-10-03 00:00:00
METRO Baia Mare | Tue to Sat | 2022-10-03 00:00:00
METRO Timisoara | Tue to Sat | 2022-10-03 00:00:00
METRO TIMISOARA 2 | Tue to Sat | 2022-10-03 00:00:00
METRO Cluj | Tue to Sat | 2022-10-02 00:00:00
METRO Punct Turda | Tue to Sat | 2022-10-02 00:00:00
Spreadsheet: 219423d1362755833-average-cells-based-on-month-and-other-criteria-apples-and-oranges
Sheet: Sheet1

 | 2013-01-01 00:00:00 | 1 | Apples
 | 2013-01-02 00:00:00 | 5 | Apples |  |  | If/And Average |  | Manual Average
 | 2013-01-03 00:00:00 | 4 | Oranges |  | Apples
 | 2013-01-04 00:00:00 | 6 | Apples |  | Oranges
 | 2013-01-05 00:00:00 | 5 | Oranges
 | 2013-01-06 00:00:00 | 2 | Apples
 | 2013-01-07 00:00:00 | 4 | Apples
 | 2013-01-08 00:00:00 | 1 | Oranges
 | 2013-01-09 00:00:00 | 2 | Oranges
 | 2013-01-10 00:00:00 | 3 | Apples
 | 2013-01-11 00:00:00 | 1 | Apples
 | 2013-01-12 00:00:00 | 2 | Apples
 | 2013-01-13 00:00:00 | 7 | Oranges
 | 2013-01-14 00:00:00 | 8 | Apples
 | 2013-01-15 00:00:00 | 4 | Apples
 | 2013-01-16 00:00:00 | 6 | Oranges
 | 2013-01-17 00:00:00 | 8 | Apples
 | 2013-01-18 00:00:00 | 9 | Apples
 | 2013-01-19 00:00:00 | 5 | Oranges
 | 2013-01-20 00:00:00 | 3 | Apples
 | 2013-01-21 00:00:00 | 4 | Oranges
 | 2013-01-22 00:00:00 | 2 | Oranges
 | 2013-01-23 00:00:00 | 3 | Apples
 | 2013-01-24 00:00:00 | 1 | Apples
 | 2013-01-25 00:00:00 | 5 | Oranges
 | 2013-01-26 00:00:00 | 1 | Oranges
 | 2013-01-27 00:00:00 | 1 | Oranges
 | 2013-01-28 00:00:00 | 4 | Apples
 | 2013-01-29 00:00:00 | 4 | Oranges
 | 2013-01-30 00:00:00 | 8 | Apples
 | 2013-01-31 00:00:00 | 9 | Oranges
 | 2013-02-01 00:00:00 | 7 | Oranges
 | 2013-02-02 00:00:00 | 5 | Apples
 | 2013-02-03 00:00:00 | 3 | Oranges
 | 2013-02-04 00:00:00 | 1 | Oranges
 | 2013-02-05 00:00:00 | 3 | Apples
Spreadsheet: michelle_cash__26544__Scorecard
Sheet: Non-Commercial Scorecard

Employee Name | Mission Critical/Hot Skills | Enron Business Knowledge | Adaptability | Transferable Skills | Teamwork | Connecting & Leveraging | Technical/ Analytical Skills | Leadership Potential | Judgment | Total Score  (Highest possible score - 50)
 | 2001-01-05 00:00:00 | 2001-01-05 00:00:00 | 2001-01-05 00:00:00 | 2001-01-05 00:00:00 | 2001-01-05 00:00:00 | 2001-01-05 00:00:00 | 2001-01-05 00:00:00 | 2001-01-05 00:00:00 | 2001-01-05 00:00:00 | 1 = Best Score 5 = Worst Score
Spreadsheet: 167824d1342110932-excel-2007-vlookup-help-2012-bud-help_v2
Sheet: May

Monthly [NAME]
 | [NAME] | Date Due | Date Paid | Amount Due | Amount Paid | Status | Comment
 | Mortgage | 2012-05-01 00:00:00 | 2012-05-01 00:00:00 | 875.48 | 875.48
 | Tundra | 2012-05-15 00:00:00 | 2012-05-15 00:00:00 | 343.92 | 343.92
 | Cruze | 2012-05-05 00:00:00 | 2012-04-28 00:00:00 | 242.3 | 242.3
 | Verizon Wireless | 2012-05-23 00:00:00 | 2012-05-19 00:00:00 | 167.42 | 167.42
 | RZMC | 2012-05-18 00:00:00 | 2012-05-11 00:00:00 | 25 | 100
 | Capital One
 | Household Bank
 | Insurance | 2012-05-15 00:00:00 | 2012-05-15 00:00:00 | 68.74 | 68.74
 | RG&E | 2012-05-11 00:00:00 | 2012-05-11 00:00:00 | 99.52 | 99.52
 | Time Warner | 2012-05-16 00:00:00 | 2012-05-19 00:00:00 | 121.32 | 121.32
 | ACS | 2012-05-14 00:00:00 | 2012-05-29 00:00:00 | 156.29 | 156.29
 | AES | 2012-06-01 00:00:00 | 2012-05-21 00:00:00 | 138.27 | 138.27
 | Sallie Mae | 2012-05-07 00:00:00 | 2012-05-07 00:00:00 | 213.47 | 213.47
 | 1st Financial | 2012-05-23 00:00:00 | 2012-05-23 00:00:00 | 35 | 50
 | Waste Management
 | Water Authority | 2012-05-14 00:00:00 | 2012-05-21 00:00:00 | 42.22 | 51.44 |  | paid late
 | Wells Fargo - Furniture | 2012-05-16 00:00:00 | 2012-05-11 00:00:00 | 40 | 40
 | Doe | 2012-05-21 00:00:00 | 2012-05-19 00:00:00 | 301.32 | 301.32
 | [NAME]
 | Paychecks
 |  | Pay Date | Amount
 |  | 2012-05-04 00:00:00 | 1152.15
 |  | 2012-05-18 00:00:00 | 1152.15
 |  | 2012-05-11 00:00:00 | 264.09
 |  | 2012-05-25 00:00:00 | 420.15
 | Total Bills for month:
 | Total Payments for month:
 | Total Income for the month