tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 104046d1301671282-matching-data-with-multiple-columns-problem-formula
Sheet: Sheet1

Data Set 1 |  |  | Data Set 2 |  |  |  |  |  | SET 1 | SET 2
Name | Food | Colour | Name | Food | Colour | Desired Response | current response & formula
[NAME] | sandwich | red | [NAME] | cheese | pink | 1 | TRUE |  | [NAME] | [NAME]
babs | steak | pink | [NAME] | sandwich | purple | 0 | FALSE |  | babs-steak-pink | [NAME]
babs | apple | blue | babs | steak | pink | 1 | TRUE |  | babs-apple-blue | babs-steak-pink
[NAME] | cheese | pink | babs | apple | blue | 1 | TRUE |  | [NAME] | babs-apple-blue
 |  |  | bill | apple | blue | N/A | FALSE |  |  | [NAME]
 | [NAME] IN RED
Spreadsheet: 547340d1510503270-filling-across-a-range-of-sheets-test
Sheet: Kayak

BOAT NAME
OWNER NAME
MOORING TYPE
ADDRESS
HOME TEL
MOBILE TEL
[NAME]
BOAT TYPE
LENGTH
HULL COLOUR
UPPER DECK
TENDER?
DURATION
FEE
NEXT INVOICE DUE DATE | 2017-10-01 00:00:00
INVOICE DUE DATE | INVOICE REMINDER DATE | INVOICE SENT DATE | DATE PAID | NOTES
2017-10-01 00:00:00
Spreadsheet: 690885d1597342971-using-max-functions-within-if-functions-earthworks-testing-sheet-wip-e-
Sheet: Sheet1

[NAME]. | Date Sampled | Material |  | Source | Location |  | Moisture Content (%) | Dry Density (Mg/m3) | Relative Compaction (%) | AIR Voids (%) | MDD (Mg/m3) | Hand Shear Vane (kPa) | Grading | Dispersibility | Plastic limit | Liquid limit | Undrained shear strength (triaxial) | Field Dry density | MCV | Contaminated soils | Classification | Moisture content ok?
Core 1 | 2020-08-03 00:00:00 | Brown/Red Brown Clay Some Gravel |  | Site Won | Layer 1 (9 Passes) |  | 19.9 | 1.74 | 96 | 0.4 | 1.81 |  |  |  | 16 | 41 |  |  |  |  | 2A
Spreadsheet: 789729d1659335452-employee-attendance-tracker-employee-attendance-sheet-template
Sheet: Sheet1

Date | In Time | Out  Time | Employee Name | (IN Status) | (OUT Status) | REMARKS | Total Working Hours | Late Time |  |  |  |  |  | Shift 1 | 09:00:00
 | 09:00:00 |  | Mynul Islam | In |  |  |  |  |  |  |  |  |  | Shift 2 | 13:00:00 PM
 | 09:40:36 |  | [NAME] | In
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Staff Names | Total Working Days | Day Off | [NAME] | Leave | Vacation | Bereavement | Absent | Total Days | Total Number of  Working Hours
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Status | Out Status
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Md.[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In | Out
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Day Off | Day Off
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Md. Nazrul Islam Rohan |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Leave | Leave
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vacation | Vacation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bereavement | Bereavement
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Absent | Absent
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mynul Islam
Spreadsheet: 4389291b-82eb-4d06-9bcd-5dd3809a05a6
Sheet: Approp

 |  | APPROPRIATION TRANSACTION
 |  | CITY  OF  KANSAS  CITY,  MISSOURI
 |  |  | DEPARTMENT: |  |  | Housing and Community Development Department
BUSINESS UNIT: |  |  |  | KCMBU |  | DATE: |  | 2011-08-19 00:00:00 |  | JOURNAL ID:
LEDGER GROUP: |  |  |  |  | APPROP
 |  | FUND |  | DEPT ID |  | ACCOUNT |  | PROJECT |  | AMOUNT |  | INC/DEC
 |  | 6380 |  | 555806 |  | A |  | G55INDST |  | 116000 |  | INC
 |  | 6380 |  | 555806 |  | B |  | G55INDST |  | 417134 |  | INC
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL
BUSINESS UNIT: |  |  |  | KCMBU |  | DATE: |  | 2011-08-08 00:00:00 |  | JOURNAL ID:
 |  |  |  |  |  |  |  |  |  |  |  | (same as above, except
LEDGER GROUP: |  |  |  |  | ADMIN |  |  | BUDGET PERIOD: |  |  |  | prefixed by a C)
 |  | FUND |  | DEPT ID |  | ACCOUNT |  | PROJECT |  | AMOUNT |  | INC/DEC
 |  | 6380 |  | 555806 |  | 609980 |  | G55INDST |  | 116000 |  | INC
 |  | 6380 |  | 555806 |  | 619080 |  | G55INDST |  | 417134 |  | INC
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL
[NAME]: |  |  |  |  |  |  |  |  |  |  |  | NET
 |  | Estimating revenue in the amount of $593,314.00 in the Supportive Housing Rehabilitation Loan fund;
 |  | appropriating $533,134 to the City of Independence ARRA Weatherization program; and designating requisitioning authority.
APPROVED BY: |  |  |  |  |  | DATE |  | APPROVED BY:  DEPARTMENT HEAD |  |  |  |  |  | DATE
Spreadsheet: 713006d1610523775-summation-of-data-validated-list-date-changes-results-workbook-2-gk2
Sheet: SUMMARY 

 | DECEMBER |  |  |  | INTERRUPTION COUNT |  |  |  |  |  |  |  |  | NO OF HOURS LOST DUE TO |  |  |  |  |  |  |  |  | AVAILABILITY |  |  | SUMMARY
ZONE | NAME OF [NAME] | STATUS | MAX. LOAD | AV. LOAD | EF | OC | IMB | EMG | LS | LSG | SG | TX LIMIT | TOTAL | EF | OC | IMB | EMG | LS | LSG | SG | TX LIMIT | TOTAL | EXPECTED | ACHIEVED | CHECKER | FORCED OUTAGES | FORCED OUTAGES DURATION | LOAD SHEDDING COUNT | LOAD SHEDDING DURATION | STATION GUARANTEE COUNT | STATION GUARANTEE DURATION | TX INTERRUPTION COUNT | TX INTERRUPTION DURATION | LEGENDS | MEANING
 | IGI | ACTIVE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | IMB | IMBALANCE
 | AGMA | ACTIVE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | EMG | EMERGENCY
 | OLO | ACTIVE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | LS | LOAD SHEDDING
 | ASA | ACTIVE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | SG | STATION GUARANTEE
 | TBO | ACTIVE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | LSG | LOAD SHEDDING GUARANTEE
 | [NAME] | ACTIVE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | TX LIMIT | [NAME]
 | GIN | ACTIVE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  | EF | EARTH FAULTH
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OC | OVER CURRENT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SS | STATION SERVICES
TOTAL
Spreadsheet: 866440d1713355720-membership-list-database-excel-test-download
Sheet: TEST DOWNLOAD

Donor First Name | Donor Last Name | Amount Description | Amount | Donated At
Bill & Barbara | [NAME] | Connesieur | 250 | 2022-03-24 00:00:00
Sonia | Abel | Artist | 100 | 2023-07-23 18:58:56
[NAME] | Smith | Student | 35 | 2021-09-27 06:30:21
[NAME] | Adams | Friend | 50 | 2022-08-23 11:58:18
Elaine | [NAME] | Friend | 50 | 2022-01-26 00:00:00
Elaine | [NAME] | Friend | 50 | 2023-03-10 00:00:00
Elaine | [NAME] | Friend | 65 | 2024-01-24 00:00:00
[NAME] | [NAME] | Friend | 50 | 2023-01-22 21:40:05
Anne | Ambrose | Artist | 100 | 2023-03-31 11:04:22
Anne | Ambrose | Artist | 125 | 2024-03-31 12:00:23
[NAME] | [NAME] | Friend | 50 | 2022-08-16 00:00:00
[NAME] | [NAME] | Artist | 100 | 2022-08-23 07:51:57
[NAME] | [NAME] | Artist | 100 | 2023-08-23 12:00:59
[NAME] | [NAME] | Friend | 50 | 2023-09-20 00:00:00
Colette | [NAME] | Friend | 50 | 2023-02-19 10:22:34
[NAME] | Bagatella | Artist | 100 | 2021-09-09 11:08:48
[NAME] | Bagatella | Artist | 100 | 2022-09-09 12:00:56
[NAME] | Bagatella | Artist | 100 | 2023-09-09 12:02:20
[NAME] | Baltz | Friend | 50 | 2021-10-28 14:43:59
Mitzi | Bellamy | Friend | 50 | 2022-02-09 12:50:43
Mitzi | Bellamy | Friend | 50 | 2023-11-29 16:42:06
[NAME] | Basher | Friend | 50 | 2023-02-04 16:33:50
[NAME] | Basher | Artist | 100 | 2023-02-28 07:20:59
[NAME] | [NAME] | Artist | 100 | 2021-09-28 13:41:13
[NAME] | [NAME] | Artist | 100 | 2022-09-28 12:00:39
[NAME] | [NAME] | Artist | 100 | 2023-09-21 18:31:31
[NAME] | [NAME] | Artist | 100 | 2023-09-28 12:00:38
[NAME] | [NAME] | Artist | 100 | 2022-11-14 10:42:57
[NAME] | [NAME] | Artist | 100 | 2023-11-14 11:01:14
Spreadsheet: 550063d1512074133-tally-up-x-marks-for-roll-sheets-with-names-on-multiple-sheets-master-attendance-sheet-example
Sheet: Tue & Wed Combined

 | NAME | TOTAL TUE & WED COUNT
1 | AJAY SMITH
 | ALEX YU
 | ALEXANDRA MCDONALD
 | [NAME]
 | ANGEL YOU
 | ANNIE CLARK
 | BECCA GOODSON
 | [NAME]
 | [NAME]
 | SAMUEL SMITH
Spreadsheet: 854796d1704556384-need-to-convert-sumifs-formula-so-that-closed-workbook-can-be-referenced-book1
Sheet: Sheet1

 |  |  |  | 1 |  |  |  |  | Q
 |  |  |  | 2 |  |  |  |  | W
 |  |  |  | 3 |  |  |  |  | E
 |  |  |  | 4 |  |  |  |  | W
 |  |  |  | 5 |  |  |  |  | E
 |  |  |  | 6 |  |  |  |  | R
 |  |  |  | 7 |  |  |  |  | E
 |  |  |  | 8 |  |  |  |  | W
 |  |  |  | 9 |  |  |  |  | Q
 |  |  |  | 10 |  |  |  |  | W
 |  |  |  | 11 |  |  |  |  | E
Spreadsheet: john_griffith__15916__11_13_01GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] | 58 | 450 | 530 | 49.7 | 58.6 | 1.97 | 2001-11-13 14:51:00
 | HU F2 | 59 | 740 | 830 | 46 | 51.6 | 1.81 | 2001-11-13 14:51:00
 | HU G2 | 60 | 1000 | 1075 | 46.2 | 49.7 | 1.81 | 2001-11-13 14:51:00
 | [NAME] | 61 | 1150 | 1250 | 44.9 | 48.8 | 1.8 | 2001-11-13 14:51:00
 | [NAME] | 67 | 1375 | 1475 | 43.5 | 46.7 | 1.9 | 2001-11-13 14:51:00
 | [NAME] | 67 | 1475 | 1575 | 42.2 | 45.1 | 1.84 | 2001-11-13 14:51:00
 | [NAME] | 67 | 1550 | 1700 | 40.6 | 44.6 | 1.79 | 2001-11-13 14:51:00
 | HU N2 | 67 | 1575 | 1725 | 38.7 | 42.5 | 1.71 | 2001-11-13 14:51:00
 | [NAME] |  |  |  | 36.7 | 41.4 | 1.64 | 2001-11-09 14:53:00
 | HU U2 |  |  |  | 36 | 39.4 | 1.59 | 2001-10-29 14:33:00
 | [NAME] |  |  |  | 32.2 | 36.6 | 1.43 | 2001-10-22 14:23:00
 | [NAME] |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | [NAME]
 | HU F3
 | [NAME] |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | HU H3
Spreadsheet: 16d2b619-fb77-40fd-8d9a-c9f0fbdc7340
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
 | 12.7m
 |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | 11.7m | 18.4m
 |  |  |  |  |  | Capacity  = 128
 |  |  |  |  |  | 16 round tables x 8 chairs
 |  |  |  |  |  |  | G.07
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.7m
 |  |  |  |  |  |  | G.07a
 |  |  | Power - Can not be moved
 |  |  | 6' round table = 1.83m
 |  |  | Chair = 0.5m
Spreadsheet: 855656d1705157303-how-to-get-data-that-only-have-value-whiteboard
Sheet: Planilha1

NO. | ITEM | PRlCE |  |  | NO. | ITEM | PRlCE
1 | PAPER | 10 |  |  |  | PAPER | 10
2 | BOOK | 25 |  |  |  | BOOK | 25
3 | PENCIL | 0 |  |  |  | WHITEBOARD | 150
4 | ERASER | 0
5 | WHITEBOARD | 150
Spreadsheet: 810839d1672118350-looking-for-help-a-lookup-between-a-range-gdkp-raffle-sheet-sample
Sheet: Sheet1

Zzyxk's 50/50 GDKP Raffle |  |  |  |  |  |  |  |  |  |  |  | Top Contributors |  |  |  |  |  |  |  | All Contributors |  |  |  |  | Every Contribution
 |  |  |  |  |  | Total
Name | # of tickets | current total | roll needed to win |  |  |  |  |  |  |  |  | Rank | Name |  |  | Total  Tickets |  |  |  | Name | Total  Tickets |  |  |  | Name | Total  Tickets
glayvq | 10 |  | 1 | to |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | glayvq | 21 |  |  |  | glayvq | 10
ech0ez | 5 |  |  | to |  | GDKP Cut |  |  |  |  |  | 2 |  |  |  |  |  |  |  | ech0ez | 5 |  |  |  | ech0ez | 5
kushaman | 5 |  |  | to |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  | kushaman | 5 |  |  |  | kushaman | 5
skizzi | 30 |  |  | to |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  | skizzi | 30 |  |  |  | skizzi | 30
dev0urspell | 5 |  |  | to |  | Winner Cut |  |  |  |  |  | 5 |  |  |  |  |  |  |  | dev0urspell | 10 |  |  |  | dev0urspell | 5
tckt0k | 5 |  |  | to |  |  |  |  |  |  |  | 6 |  |  |  |  |  |  |  | tckt0k | 5 |  |  |  | tckt0k | 5
erkac | 4 |  |  | to |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  | erkac | 4 |  |  |  | erkac | 4
dev0urspell | 5 |  |  | to |  | Roll |  |  |  |  |  | 8 |  |  |  |  |  |  |  | [NAME] | 60 |  |  |  | dev0urspell | 5
[NAME] | 60 |  |  | to |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  | 0ckyway | 2 |  |  |  | [NAME] | 60
glayvq | 11 |  |  | to |  | 34 |  |  |  |  |  | 10 |  |  |  |  |  |  |  | zzyxk | 75 |  |  |  | glayvq | 11
0ckyway | 2 |  |  | to |  | Winner |  |  |  |  |  | Current Leader |  |  |  |  |  |  |  | [NAME] | 4 |  |  |  | 0ckyway | 2
zzyxk | 75 |  |  | to |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | budda | 7 |  |  |  | zzyxk | 75
[NAME] | 5 |  |  | to |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 4
budda | 7 |  |  | to |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | budda | 7
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
 |  |  |  | to
Spreadsheet: 198872d1354916435-counting-large-number-of-values-count-of-unique-items-bb-
Sheet: Sheet1

List | Unique list | count
[NAME]
[NAME]
[NAME]
[NAME]
Magi1
Magi1
Magi1
[NAME]
[NAME]
Spreadsheet: 815688d1675152844-adding-the-numbers-with-the-same-names-help
Sheet: Sheet1

NAMES | COLLATERAL | ACTUAL DAYS | TOTAL TAT | AVERAGE TAT
ROMEO | 10 | 20
ROMEO | 5 | 11
GO | 20 | 22
GO | 6 | 15
GO | 15 | 20
SANDER | 4 | 20
SANDER | 5 | 25
ROMEO | 10 | 5
COLUMNS A, B, C are given.
COLUMN D is = Column B x Column C
COLUMN E is = Total Column D / Total Column B
Questions:
1. Is there any way that I can get Column E automatically based on Column A with same names?
2. Can the answer be placed automatically on the last of its appearance just like "ROMEO"?
Spreadsheet: 683009d1592425300-returning-occurrences-excel-help-1
Sheet: Sheet1

TM# | Name | Position | 2019-01-01 00:00:00 | 2019-01-02 00:00:00 | 2019-11-10 00:00:00 | 2019-11-11 00:00:00 | 2019-12-01 00:00:00
11111 | Employee 1 | Worker 1 |  |  | 0.5 |  | 0.5
 |  |  |  |  | One minute to one hour tardy |  | One minute to one hour tardy
Spreadsheet: 883051d1731536363-trying-to-calculate-number-of-days-between-today-and-date-next-yeare-microsoft-surface-7
Sheet: Purchases

Everything |  |  | Camera FTZ Cards |  |  | [NAME] |  | Camera Flash Batteries |  |  | Lens |  |  | B&H |  |  | Amazon Flash |  |  | Amazon 70-180 Lens |  |  | Amazon 24-70 Lens |  |  | Competitive Camera Used Lenses
Item | Cost |  | Item | Cost |  | Item | Cost | Item | Cost |  | Item | Cost |  | What | Price |  | What | Price |  | What | Price |  | What | Price |  | What | Price
Z6III | 2496.95 |  |  |  |  |  |  | Z6III | 2496.95 |  | Nikon 70-180 | 1047 |  | Z6III | 2497 |  | Godox V1 Pro | 329 |  | [NAME] 70-200 F | 1299 |  | [NAME] 24-70 F | 1199 |  | Nikon 24-70 2.8 ED F Mount | 899.95
FTZII | 246.95 |  |  |  |  |  |  | FTZII | 246.95 |  | Total with Tax |  |  | FTZ II | 247 |  | Godox SU-1 [NAME] | 49 |  | Left Over | 840 |  | With Tax |  |  | Price with Tax
256G CF | 190 |  |  |  |  | Total |  | 256G CF | 190 |  | Per Paycheck 3 Months |  |  | 256 CF | 190 |  | PB-960 PROPAC | 120 |  | Total |  |  | 2 Months |  |  | Difference from Tamron
256G SD | 129 |  |  |  |  | With Tax |  | 256G SD | 129 |  | Purchase by | July |  | 256 SD | 129 |  | AK-R12 bounce | 11.9 |  | Price with Tax |  |  | Purchase End May
EN-EL15C Batteries | 207 |  | Total Sub |  |  |  |  | EN-EL15C Batteries (4) | 207 |  |  |  |  | Sub |  |  | Sub |  |  | Purchase Mid March |  |  |  |  |  | Nikon 70-200 2.8 ED | 999.95
Flash | 509.9 |  | With Tax |  |  |  |  | Flash | 509.9 |  |  |  |  | With Tax |  |  | With Tax |  |  |  |  |  |  |  |  | Left Over | 840
Tamron 35-150 | 1659 |  |  |  |  |  |  | Sub Total |  |  |  |  |  | Purchase 2-14 |  |  | Purchase 2-14 |  |  |  |  |  |  |  |  | Price with Tax
TotalSub |  |  |  |  |  |  |  | Total with Tax
Tax |  |  |  |  |  |  |  | Per Paycheck 6 Months |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cost Both Lenses
Total |  |  |  |  |  |  |  | Purchase by | April |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Purchase Mid April
Per Paycheck 6 Months |  |  |  |  |  |  |  | Amount Left
Purchase by | April
Spreadsheet: 111833d1308118556-notepad-to-excel-and-reformat-example
Sheet: Sheet1

4.056 5/26/2011 9:53:51 AM |  |  |  |  | SL | Pressure | MA1 | MA2 | Time
0.03 FALSE 5/26/2011 9:53:52 AM |  |  |  |  | 1 | 0.03 | 4.056 | 4.056 | 9:53:52 AM
4.056 5/26/2011 9:53:52 AM |  |  |  |  | 4 | 0.18 | 4.056 | 4.056 | 9:53:54 AM
4.056 5/26/2011 9:53:52 AM |  |  |  |  | 7 | 0.03 | 4.056 | 4.056 | 9:53:55 AM
0.18 FALSE 5/26/2011 9:53:54 AM |  |  |  |  | 10 | 0.34 | 4.055 | 4.054 | 9:53:57 AM
4.056 5/26/2011 9:53:54 AM |  |  |  |  | 13 | 1.77 | 4.054 | 4.055 | 9:53:59 AM
4.056 5/26/2011 9:53:54 AM |  |  |  |  | 16 | 2.48 | 4.054 | 4.055 | 9:54:01 AM
0.03 FALSE 5/26/2011 9:53:55 AM |  |  |  |  | 19 | 3.78 | 4.055 | 4.056 | 9:54:02 AM
4.056 5/26/2011 9:53:56 AM |  |  |  |  | 22 | 6.1 | 4.057 | 4.058 | 9:54:04 AM
4.055 5/26/2011 9:53:56 AM |  |  |  |  | 25
0.34 FALSE 5/26/2011 9:53:57 AM |  |  |  |  | 28
4.054 5/26/2011 9:53:57 AM |  |  |  |  | 31
4.054 5/26/2011 9:53:57 AM |  |  |  |  | 34
1.77 FALSE 5/26/2011 9:53:59 AM |  |  |  |  | 37
4.055 5/26/2011 9:53:59 AM |  |  |  |  | 40
4.054 5/26/2011 9:53:59 AM |  |  |  |  | 43
2.48 FALSE 5/26/2011 9:54:01 AM |  |  |  |  | 46
4.055 5/26/2011 9:54:01 AM |  |  |  |  | 49
4.055 5/26/2011 9:54:01 AM |  |  |  |  | 52
3.78 FALSE 5/26/2011 9:54:02 AM |  |  |  |  | 55
4.056 5/26/2011 9:54:02 AM |  |  |  |  | 58
4.057 5/26/2011 9:54:02 AM |  |  |  |  | 61
6.1 FALSE 5/26/2011 9:54:04 AM |  |  |  |  | 64
4.058 5/26/2011 9:54:04 AM |  |  |  |  | 67
Spreadsheet: 150701d1334664707-sum-numbers-left-of-a-character-from-within-a-string-formulasumhelp
Sheet: Sheet1

2012-01-01 00:00:00 | 2012-01-02 00:00:00 | 2012-01-03 00:00:00 | 2012-01-04 00:00:00 | 2012-01-05 00:00:00 |  | H |  | SD |  | S |  | AA |  | AU |  | BR |  | PL |  | WHI
2H.3.3AA.10.5WHI. | 8H. | 4S.4H. | 2.2BR.1AA | 2S.2H.8AU.
Cell H2 should read " 16 "
Cell L2 should read " 6 "
Spreadsheet: 38443d1236615305-excel-2007-having-problem-with-averageifs-formula-monthly-gas-reports-2009-ne
Sheet: Monthly Avg

 |  | System: | Scranton
 |  | YTD:
 |  | [NAME]. Monthly:
Technician |  | Yearly Technician Total | Average/Week | January |  |  |  | Totals | February |  |  |  | Totals | March |  |  |  | Totals | April |  |  |  | Totals | May |  |  |  |  | Totals | June |  |  |  | Totals | July |  |  |  | Totals | August |  |  |  |  | Totals | September |  |  |  | Totals | October |  |  |  | Totals | November |  |  |  |  | Totals | December |  |  |  |  | Totals
 |  |  |  | WE 1/11 | WE 1/18 | WE 1/25 | WE 2/1 |  | WE 2/8 | WE 2/15 | WE 2/22 | WE 3/1 |  | WE 3/8 | WE 3/15 | WE 3/22 | WE 3/29 |  | WE 4/5 | WE 4/12 | WE 4/19 | WE 4/26 |  | WE 5/3 | WE 5/10 | WE 5/17 | WE 5/24 | WE 5/31 |  | WE 6/7 | WE 6/14 | WE 6/21 | WE 6/28 |  | WE 7/5 | WE 7/12 | WE 7/19 | WE 7/26 |  | WE 8/2 | WE 8/9 | WE 8/16 | WE 8/23 | WE 8/30 |  | WE 9/6 | WE 9/13 | WE 9/20 | WE 9/27 |  | WE 10/4 | WE 10/11 | WE 10/18 | WE 10/25 |  | WE 11/1 | WE 11/8 | WE 11/15 | WE 11/22 | WE 11/29 |  | WE 12/6 | WE 12/13 | WE 12/20 | WE 12/27 | WE 1/3
1 | [NAME]
2 | [NAME]
3 | [NAME]
4 | [NAME]
5 | [NAME]
6 | [NAME]
7 | [NAME]
8 | [NAME]
9 | [NAME]
10 | [NAME]
11 | [NAME]
12 | [NAME]
13 | [NAME]
14 | [NAME]
15 | [NAME]
16 | [NAME]
17 | [NAME]
18 | [NAME]
19 | [NAME]
20
21
22
23
24
25
 |  |  |  |  | Total: |  |  |  |  | Total: |  |  |  |  | Total: |  |  |  |  | Total: |  |  |  |  |  | Total: |  |  |  |  | Total: |  |  |  |  | Total: |  |  |  |  |  | Total: |  |  |  |  | Total: |  |  |  |  | Total: |  |  |  |  |  | Total: |  |  |  |  |  | Total:
 |  |  |  |  | Highest total Jan. |  |  |  |  | Highest total Feb. |  |  |  |  | Highest total Mar. |  |  |  |  | Highest total Mar. |  |  |  |  |  | Highest total May |  |  |  |  | Highest total Jun. |  |  |  |  | Highest total Jul. |  |  |  |  |  | Highest total Aug. |  |  |  |  | Highest total Sep. |  |  |  |  | Highest total Oct. |  |  |  |  |  | Highest total Nov. |  |  |  |  |  | Highest total Dec.
Spreadsheet: 745813d1630247083-asset-allocation-to-a-date-period-excel-forum
Sheet: Date and costs

Date | Costs | Code | Asset name | Company | Company which should be shown in E
2020-05-01 00:00:00 | 1000 | 123456 | Big Car |  | Company 1
2020-01-01 00:00:00 | 1000 | 654321 | Small Car |  | Company 1
2021-07-01 00:00:00 | 2000 | 123456 | Big Car |  | Company 2
2021-05-01 00:00:00 | 2000 | 654321 | Small Car |  | Company 2
2021-11-01 00:00:00 | 3000 | 654321 | Small Car |  | Company 3
Spreadsheet: 817668d1676386256-horse-betting-odds-and-returns-calculator-horse-racing-profit-and-loss-
Sheet: Sheet1

Stake | Odds | Win / Each Way | Payout | Profit
10 | 10/1 | Win | 110 | 100
Amount bet | Odds offered by betting firm (I have hard coded using a ' but I want this displayed as a fraction | Was the bet for a win or place | If WIN, then multiply stake with odds (£10 x 10) PLUS stake = £110 | Profit is payout minus stake
10 | 10/1 | Each Way | 15 | 5
Amount bet | Odds offered by betting firm (I have hard coded using a ' but I want this displayed as a fraction | This time it's each way | If WIN, then multiply stake with odds (£10 x 10) PLUS stake = £110  If Each Way, then half the stake, multiplied by 1/5 of the odds e.g.  £10 bet - £5 on win and £5 on place so £5 is lost on the win part of the bet and the remaining £5 is returned plus 1/5 odds of 10/1 (so 2/1) = £5 + 2x£5 = £15 | Profit is payout minus stake
Spreadsheet: 30193d1225557617-mirror-image-or-flipping-cells-garden-plan
Sheet: Sheet2

Blue Grass |  | Blue Grass |  | Blue Grass |  | Blue Grass
 | Ajuga |  | Ajuga |  | Ajuga |  | Ajuga
Blue Grass |  | Euonymous |  | Sedum Autumn Joy |  | Sedum Autumn Joy
 | Ajuga |  |  |  |  |  | Ajuga
Blue Grass |  | Sedum Autumn Joy |  | Dwarf Spruce |  |  | Dwarf Spruce
 | Ajuga |  |  |  |  |  | Ajuga
Blue Grass |  | Sedum Autumn Joy |  |  |  | [NAME]
 | Ajuga |  | Ajuga | Dwarf Spruce | Ajuga |  | Ajuga
Spreadsheet: chris_germany__2320__2001new03
Sheet: CGAS

 | Citygate | Pool |  | 456379 |  |  |  |  |  |  |  |  |  |  |  |  | IF On |  |  |  |  |  |  | Deal 549411
 | Deal | Deal |  | Storage | Storage |  | CES | ENA |  | Actuals |  |  |  |  | Adjusted |  | Deal |  | [NAME] |  | Undertakes |  |  | Citygate |  | Per Jeff's Sheet
 | 649352 | 657466 |  | Gross | Net |  | Transport | Transport |  | From ENA |  | FOM | 3rd Party | Spot Deals | FOM |  |  |  | [NAME] SALES |  | [NAME] |  | Gas Daily | Price |  | COH-Stor | COH | Buy/(Sell)
1 | 63357 | 11621 |  | 49986 |  |  | 140099 |  |  |  |  | 15553 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50765 | 7282 | ??
 | 74902 |  |  | 61791 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 82932 | 7282 | -566
 | 82646 |  |  | 69707 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 62086 | 7282 | -566
 | 77711 |  |  | 64662 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38139 | 7282 | -566
 | 84890 |  |  | 72002 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45668 | 7282 | -566
 | 75676 |  |  | 62583 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 54979 | 7282 | -566
 |  | 0
 |  |  |  | 1448997