tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 835617d1688682492-formula-to-conditional-format-cells-3-months-after-specified-date-hs-report-apr22-to-mar23-20230530-via-mp-reward-wip-forum-query
Sheet: Summary

Member No. | First Name | Surname | Open HR  number | Start date | Leave Date | Start Date Check | Sart Date Match | Leave Date Check | Leave Date Match | Start vs Leave Date Check | Query | Practice | Payroll | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | Total
CN1784369 | Victoria | Mills | 16896 | 2022-02-14 00:00:00 | 2022-05-16 00:00:00 |  |  |  |  |  | Within 3 Mths | [NAME] | [NAME] | 5.52 | 5.52 | 5.52 | 5.52 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CN1867130 | [NAME] | [NAME] | 17323 | 2019-01-07 00:00:00 |  |  |  |  |  |  | Ignore blank leave dates | [NAME] | [NAME] | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52
CN1451590 | [NAME] | Bailey | 8000 | 2016-04-16 00:00:00 | 2022-11-18 00:00:00 |  |  |  |  |  | OK | [NAME] | [NAME] | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 0 | 0 | 0 | 0
CN1451430 | [NAME] | [NAME] | 8001 | 2017-06-06 00:00:00 | 2022-05-31 00:00:00 |  |  |  |  |  | QUERY | [NAME] | [NAME] | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 0 | 0 | 0 | 0
CN1451472 | Zoe | Banks | 8002 | 2015-10-02 00:00:00 |  |  |  |  |  |  | Ignore blank leave dates | [NAME] | [NAME] | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52
CN1610002 | Chloe | [NAME] | 12331 | 2020-12-01 00:00:00 |  |  |  |  |  |  | Ignore blank leave dates | [NAME] | [NAME] | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52
CN1669514 | Allanah | Bielski | 14012 | 2021-06-02 00:00:00 | 2023-01-01 00:00:00 |  |  |  |  |  | OK | [NAME] | [NAME] | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 0 | 0
CN1451664 | Anna | Bissex | 8005 | 2008-09-15 00:00:00 |  |  |  |  |  |  | Ignore blank leave dates | [NAME] | [NAME] | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52
CN1486289 | Rachel | [NAME] | 6001 | 2019-07-05 00:00:00 | 2022-08-12 00:00:00 |  |  |  |  |  | Within 3 Mths | Oak Tree | VetPartners Practices Ltd | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 | 0 | 0 | 0 | 0 | 0
CN1486289 | Rachel | [NAME] | 17907 | 2022-07-11 00:00:00 | 2022-08-12 00:00:00 |  |  |  |  |  | Leave Date: 31/12/2022, No Payments taken until Nov 22 | Oakhill Veterinary Group | VetPartners Practices Ltd 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5.52 | 5.52 | 0 | 0 | 0
Spreadsheet: 709283d1608231076-minimum-sum-value-excluding-value-0-min
Sheet: sheet1

Numero |  |  |  |  | A | A | B | B | C | C
123456 |  |  |  |  | 0 | 0 | 42.58 | 3 | 55 | 4 |  |  | <--45,58
321556 |  |  |  |  | 120.12 | 40.24 | 110.58 | 2.5 | 130 | 7
51984 |  |  |  |  | 75.21 | 12.2 | 252.2 | 0 | 170 | 12
Spreadsheet: 772002d1646951490-cant-find-the-correct-formula-excel-sample-220310
Sheet: Tables

 |  |  | Color |  |  | Animals |  |  | Size
 |  |  | Red | 10 |  | Lions | 10 |  | Small | 10
 |  |  | Green | 20 |  | Tigers | 20 |  | Medium | 20
 |  |  | Blue | 30 |  | Bears | 30 |  | Large | 30
 |  |  |  |  |  | Green | 90
 |  |  |  |  |  |  |  |  | Lions | 33
Spreadsheet: 858771d1707328754-formula-to-summarize-entries-of-names-temp-google-sched
Sheet: SCHEDULE

 | 2024-02-01 00:00:00
 |  |  | MEMBERS OUT:
 |  |  | (SUMMARY OF NAMES APPEAR HERE)
Column1 | Column2 | Column3 | ON SITE NAMES | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12
 |  | AIA | [NAME] /  MARIO A . /  [NAME] |  |  |  | 1st |  |  |  | X
 | TWO 5" OSY VALVES ON HW HEAT CIRC PUMPS | aia | SCOTT , RICHARD G |  |  |  | 2ND- |  |  |  | X
 | DUAL TEMPERATURE PIPING REPLACEMENT | AIA | FRANCISCO LEON, RICHARD G
 | CARPENTERS  - #14E  / # 3A | AIA | DILSON/ JORGE URBANEJA / ROLMAN |  |  |  |  |  |  |  | X
 |  |  | NAMES |  | NAMES
 |  |  | IN |  | OUT
Spreadsheet: cfa7bb30-90e8-4018-bb58-218b273b5b19
Sheet: Report

Unit | Unit Priority | [NAME] | Objective Id | Objective Name | Objective Priority | Strategic Direction | Impact Type
Payroll | 1 | Maximize accuracy in every Payroll cycle. | 1.1 | Payroll Training | 1 | None | -- Pick One --
Payroll | 2 | Informative information by Website | 2.1 | Newsletter by e-mail | 1 | None | -- Pick One --
Spreadsheet: 267673d1380135664-if-then-statements-on-excel-test
Sheet: Test

 | Transferee | Transferee Address | Transfereee City | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Company 1 | 123 Main St | Miami | FL | 95462
 | Company 1 | =VLOOKUP(B2,$CA$1:$CE$5000,2,0) | Miami | FL | 95462 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Company 2 | 456 Main St | New York | NY | 26462
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Company 3 | 123 Ave | Houston | TX | 13253
Spreadsheet: 72968d1273662107-adding-empty-cell-only-if-nothing-else-is-entered-in-referring-cells-time-recording
Sheet: Totals

 |  |  | Name |  |  |  | Date
 |  | Toatl Time Recorded for each Category
 |  | Other Building Control Activities |  |  | Non-Chargaeable activities |  |  | Chargeable Activities
 |  | A1 |  |  | B1 |  |  | C1
 |  | A2 |  |  | B2 |  |  | C2
 |  | A3 |  |  | B3 |  |  | [NAME]
 |  | A4 |  |  | B4 |  |  | C4
 |  | A5 |  |  | B5 |  |  | C5
 |  | A6 |  |  | B6 |  |  | C6
 |  | A7 |  |  | B7 |  |  | C7
 |  | A8 |  |  | B8 |  |  | C8
 |  | A9 |  |  | B9 |  |  | C9
 |  | A10 |  |  | B10 |  |  | C10
 |  | A11 |  |  | B11 |  |  | C11
 |  | A12 |  |  | B12 |  |  | C12
 |  | A13 |  |  | B13 |  |  | C13
 |  | A14 |  |  |  |  |  | C14
 |  | A15 |  |  |  |  |  | C15
 |  | A16 |  |  |  |  |  | C16
 |  | A17 |  |  |  |  |  | C17
 |  | A18
 |  | A19 | 15:00:00
 |  | A20 | 01:15:00
 |  | A21
 |  | A22
 |  | A23
 |  | A24
 |  | A25 | #N/A
 |  | A26
 |  | A27
 |  | A28
 |  | A29
 |  | A30
 |  | Total | #N/A |  |  | 1900-01-01 00:00:00 |  |  | 1900-01-01 00:00:00
Spreadsheet: 689f3c9f-999b-45f5-ba67-03c642896b30
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | FY2011 HOPWA Allocation Summary
 | Appropriation |  |  | Total Allocated Amount
 | Total | 297888030 |  | Total | 297888030
 | 0.75 | 223416022.5 |  | Total MSA | 258744340
 | 0.25 | 74472007.5 |  | Total State | 39143690
 | Formula Factors |  |  | Statistics
 | Eligible States Cases | 913319 |  | $ Per AIDS Case | 201.761195182281
 | Eligible MSAs Cases | 194010 |  | $ Per Excess Case | 10030.28310953399
 | Total Cases | 1107329 |  | % of Total U.S. Cases Covered | 0.99425889561408
 |  |  |  | % Allocated to States | 0.1314040370712174
 | Excess Per Capita Incidence Calculations |  |  | % Allocated to MSA's | 0.8685959629287826
 | Total 3 Year Cases | 90737
 | Total 3 Year Population | 607831259
 | 3-Year Avg Per Capita Incidence | 14.928
 | Sum of Excess Cases | 7424.7164
 | Notes:
 | The following spreadsheets (see tabs below) include State and Metropolitan Statistical Area (MSA) data on HOPWA FY2011 allocations and cumulative cases of AIDS, as reported to CDC through March 2010.  Only MSAs with population greater than or equal to 500,000 were included, and MSA boundaries were based on the most current OMB bulletin. The MSA worksheets also include annual AIDS case data: This data reflects annual AIDS case counts from April through March of the years indicated (e.g., April 2009 through March 2010). Columns titled "3-Year PCI" reflect per capita AIDS cases for the previous 3 years. Total population counts are based on July 1, 2010 population estimates from the U.S. Census Bureau.
Spreadsheet: 60840ab7-d7f2-40b2-b40f-9aa0149ce20f
Sheet: In days

Enter full year entitlement in days
(if part-time, use calculator 1 on leave calculator if not known) |  |  | Working days |  |  | INSTRUCTIONS FOR USE
 |  |  | Monday |  |  | 1.  Calculate entitlement (pro-rated if part-time)
Enter date of start of contract e.g. 1 May 2011 | 2013-04-01 00:00:00 |  | Tuesday |  |  | 2. Put you working days in the table to the left(as a reminder).
(or  start date for annual leave year) |  |  | Wednesday |  |  | 3. Complete the table for Bank and University Holidays, putting in the proportion of  a day you would normally work on that day. Put in 1 for a full day.If you do not normally work that day, enter zero.
Enter end date of holiday year  i.e. 31 March 2012 | 2014-03-31 00:00:00 |  | Thursday |  |  | 4. Put zero for any days that occurred before you started work at the University.
 |  |  | Friday |  |  | 5. Add on the further days of bookable annual leave as they are taken, or when they are planned.
Number of days between the these two dates |  |  | Total
Entitlement in days
HOLIDAY RECORD
 | Proportion of day normally hours worked on that day(s) | Running total of leave taken | Running total of leave remaining |  |  | Note: The values used are fractions of a day  e.g. 1 day = 1.0, ½ day = 0.5days
Bank and University Holidays
Monday 1st April 2013
Tuesday 2nd April
Monday 6th May
Monday 27th May
Monday 26 th August
Tuesday 27th August
Wednesday 25th December
Thursday 26th December
Friday 27th December
Monday 30th December
Tuesday 31st December
Wednesday 1st Jaunuary 2014
Bookable Leave
Spreadsheet: 374107d1422655642-vba-code-too-long-kim-75
Sheet: Sheet1

[NAME] | CN |  | Shipping Origin | Some Number | Two-Digit Code
[NAME] | CN |  | North Battleford Grain | 726
[NAME] | CN |  | Equity Grain | 108
[NAME] | CP |  | Vermilion Grain | 633
Nicklen Siding Grain | CN |  | Viking West Grain | 104
North Battleford Grain | CN |  | Camrose Grain | 133
Oakner Grain | CN |  | Nicklen Siding Grain | 487
[NAME] | CN |  | [NAME] | 593
[NAME] | CN |  | Vermilion Grain | 929
Swan River Grain | CN |  | Elm Creek Grain | 724
Balcarres Grain | CN |  | North Battleford Grain | 397
[NAME] | CP |  | Lethbridge Grain | 320
Camrose Grain | CN |  | Balcarres Grain | 469
Carseland Grain | CP |  | North Battleford Grain | 252
Congress Grain | CP |  | Dauphin Grain | 508
Dauphin Grain | CN |  | Carseland Grain | 646
[NAME] | CN |  | Vermilion Grain | 594
[NAME] | CN |  | [NAME] | 267
Elm Creek Grain | CP |  | [NAME] | 360
Elva Grain | CP |  | [NAME] | 578
Equity Grain | CP |  | [NAME] | 258
[NAME] | CN |  | Viking West Grain | 327
Lethbridge Grain | CP |  | Oakner Grain | 510
[NAME] | CN |  | [NAME] | 527
Vermilion Grain | CN |  | Swan River Grain | 513
Viking West Grain | CN |  | Elm Creek Grain | 567
Yorkton Grain | CP |  | [NAME] | 339
Raymore Grain | CN |  | [NAME] | 749
[NAME] | CN |  | [NAME] | 643
 |  |  | Yorkton Grain | 307
 |  |  | [NAME] | 985
 |  |  | Equity Grain | 482
 |  |  | [NAME] | 196
 |  |  | Equity Grain | 594
 |  |  | Raymore Grain | 214
 |  |  | Nicklen Siding Grain | 313
Spreadsheet: 598605d1542625259-formula-used-in-weekly-reduction-of-work-hours-test-workbook-tms-v2
Sheet: NGA

 |  | 2017-03-31 00:00:00
 | Mar - 01st | Mar - 05th | Mar - 12th | Mar - 19th | [NAME] | Monthly | Hours | Burn
 | Mar - 04th | Mar - 11th | Mar - 18th | Mar - 25th | Mar - 31st | Totals | Balance | Rate
DS Authorized Hours
DS Billable Hours
[NAME] Authorized
[NAME]
[NAME]
[NAME]
[NAME]
CSO Authorized |  |  |  |  |  |  |  |  | 58
CSO Billable Hours
CSO Non-Billable Hours
CSO Billable OT
CSO Non-Billable OT
Burn Rate
 | Mar - 01st | Mar - 05th | Mar - 12th | Mar - 19th | [NAME] | Monthly | Hours | Burn
 | Mar - 04th | Mar - 11th | Mar - 18th | Mar - 25th | Mar - 31st | Totals | Balance | Rate
[NAME] Authorized
[NAME]
[NAME]
[NAME]
[NAME]
CSO Authorized
CSO Billable Hours
CSO Non-Billable Hours
CSO Billable OT
CSO Non-Billable OT
Burn Rate
 | Mar - 01st | Mar - 05th | Mar - 12th | Mar - 19th | [NAME] | Monthly | Hours | Burn
 | Mar - 04th | Mar - 11th | Mar - 18th | Mar - 25th | Mar - 31st | Totals | Balance | Rate
[NAME] Authorized
[NAME]
[NAME]
[NAME]
[NAME]
CSO Authorized
CSO Billable Hours
CSO Non-Billable Hours
CSO Billable OT
CSO Non-Billable OT
Burn Rate
 | Mar - 01st | Mar - 05th | Mar - 12th | Mar - 19th | [NAME] | Monthly | Hours | Burn
 | Mar - 04th | Mar - 11th | Mar - 18th | Mar - 25th | Mar - 31st | Totals | Balance | Rate
[NAME] Authorized
[NAME]
[NAME]
[NAME]
[NAME]
CSO Authorized
CSO Billable Hours
CSO Non-Billable Hours
CSO Billable OT
CSO Non-Billable OT
Burn Rate
Spreadsheet: 873349d1719852492-sum-vlookup-combination-case-sum-vlookup-combination-case
Sheet: SUM - VLOOKUP

 | Sales Revenue by Store |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =SUM(INDEX(C3:N6,MATCH(P14,B3:B6,0),MATCH(Q13,C2:N2,0)):INDEX(C3:N6,MATCH(P14,B3:B6,0),MATCH(R13,C2:N2,0)))
 | Store Name | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | North | 98 | 20 | 76 | 88 | 23 | 20 | 82 | 88 | 86 | 12 | 17 | 19
 | East | 40 | 51 | 90 | 33 | 50 | 68 | 80 | 73 | 8 | 108 | 110 | 93
 | South | 72 | 7 | 43 | 5 | 78 | 69 | 46 | 42 | 34 | 17 | 58 | 25
 | West | 4 | 57 | 63 | 100 | 8 | 86 | 95 | 14 | 69 | 96 | 92 | 2 |  | example 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Store Name | Jan | Feb
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | North
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | example 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Store Name | Jan | Mar
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | East
Spreadsheet: rick_buy__32772__DOUG
Sheet: 1000

4
POWER PLANTS  ACCOUNTS RECEIVABLE AGING
AS OF OCTOBER 31, 2000
 |  |  | CURRENT |  | 1-30 |  | 31-60 |  | 61-90 |  | OVER 90 |  | TOTAL | COMMENTS
SMITH ENRON | A/R |  | 8827660.91 |  |  |  |  |  |  |  |  |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT |  |  |  |  |  | 0 |  | 0
PUERTO QUETZAL | A/R |  | 0 |  | 3259924.7 |  | 2752830.14 |  | 0 |  |  |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT |  |  |  |  |  |  |  |  |  |  |  |  | 0
HAINAN MEINAN | A/R |  |  |  |  |  |  |  |  |  | 68695.76
 | PER CENT
DABHOL POWER CO | A/R |  |  |  | 222492.95 |  | 222492.95 |  | 0 |  | 4011.82 |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT |  |  |  |  |  |  |  |  |  |  |  |  | 222492.95
EMPRESA ENERGETICA | A/R |  | 1726803.12 |  | 45924.39 |  | 1431473.08 |  | 1073124.03 |  |  |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT
EGEMINSA | A/R |  | 0 |  | 1161830.08 |  | 2594116.93 |  | 1294099.33 |  |  |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT |  |  |  |  |  |  |  |  |  |  |  |  | 0
TOTALS | A/R
 | PER CENT
Spreadsheet: 127262d1320257029-daverage-with-no-headings-its-killing-my-head-daverage-no-headings
Sheet: Sheet1

 | Tree | Height | Age | Profit |  | Tree | Profit |  | Tree | Age
 | Apple | 18 | 20 | 105 |  | Apple |  |  |  | >=9
 | Pear | 12 | 12 | 96 |  |  |  |  | Tree | Age
 | [NAME] | 13 | 14 | 105 |  | Pear |  |  |  | >=9
 | Apple | 14 | 15 | 75 |  |  |  |  | Tree | Age
 | Pear | 9 | 8 | 76.8 |  | [NAME] |  |  |  | >=9
 | Apple | 8 | 9 | 45
 | Apple | 8 | 14 | 39
 | Pear | 3 | 10 | 47
 | [NAME] | 8 | 13 | 10
 | Apple | 12 | 7 | 60
 | Pear | 10 | 6 | 58
 | Apple | 8 | 10 | 23
 | Apple | 5 | 4 | 33
 | Pear | 8 | 3 | 26
 | [NAME] | 11 | 2 | 46
Spreadsheet: matt_motley__26408__proposal to UAMPS
Sheet: Summary

Deal Restructure Summary
LC Draw Amount |  | 10000000
Remaining Prepay Amt |  | 1750000
Total
Price to Washington
Start Date | End Date | Fixed Price
2002-07-01 00:00:00 | 2003-09-01 00:00:00 | 39.75
2003-10-01 00:00:00 | 2007-12-31 00:00:00 | 40.5
Price to Fallon
Start Date | End Date | Fixed Price
2002-07-01 00:00:00 | 2003-09-01 00:00:00 | 40
2003-10-01 00:00:00 | 2007-12-31 00:00:00 | 40.75
Spreadsheet: 715218d1611607096-can-not-get-formula-to-report-a-change-in-cell-value-test-weather-roads-01252021
Sheet: Vehicle Class Images

 | Vehicle Class Images (VCI) | Vehicle Classes (VC) | Default Assigned TAPCA Key | Vehicle Class Description | Vehicle Classes | Vehicle Classes
 |  | [NAME] | A | Motorcycle | CLASS 1 | CLASS 1
 |  | Vehicle_Class_2 | B | Passenger Cars | CLASS 2 | CLASS 2
 |  | Vehicle_Class_3 | C | Pickups, Panels, Vans | CLASS 3 | CLASS 3
 |  | Vehicle_Class_4 | D | Buses | CLASS 4 | CLASS 4
 |  | Vehicle_Class_5 | E | Single Unit 2-Axle Trucks - 2 axles | CLASS 5 | CLASS 5
 |  | Vehicle_Class_6 | F | Single Unit 3-Axle Trucks - 3 axles | CLASS 6 | CLASS 6
 |  | Vehicle_Class_7 | G | Single Unit 4 or More Axle Trucks | CLASS 7 | CLASS 7
 |  | Vehicle_Class_8 | H | Single Trailer 3 or 4 Axle Trucks | CLASS 8 | CLASS 8
 |  | Vehicle_Class_9 | I | Single Trailer 5 Axle Trucks | CLASS 9 | CLASS 9
 |  | Vehicle_Class_10 | J | Single Trailer 6 or More Axle Trucks | CLASS 10 | CLASS 10
 |  | Vehicle_Class_11 | K | Multi-Trailer 5 or Less-Axle Trucks | CLASS 11 | CLASS 11
 |  | Vehicle_Class_12 | L | Multi-Trailer 6 Axle Trucks - 6 axles | CLASS 12 | CLASS 12
 |  | Vehicle_Class_13 | M | Multi-Trailer 7 or More-Axle Trucks | CLASS 13 | CLASS 13
 |  | Vehicle_Class_14 | N | Pedal Bike | CLASS 14 | CLASS 14
Spreadsheet: 80648d1280862546-football-league-predictor-workbook-football-standing-predictions
Sheet: Fred

 | Rank | Actual | Points
 | 17
 | 20
 | 11
 | 4
 | 3
 | 13
 | 10
 | 15
 | 1
 | 18
 | 8
 | 14
 | 9
 | 2
 | 16
 | 7
 | 12
 | 5
 | 19
 | 6
Total
Spreadsheet: dutch_quigley__9368__gbs0713pos
Sheet: EOL

 |  |  | Generated on: 06/28/01 04:09:36 PM
Product | Net Qty | BS | Product | Net Qty | Cross Ref |  | Month | Net
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Jul01           USD/MM
 |  |  |  |  |  |  | Jul01           USD/MM-L
 |  |  |  |  |  |  | [NAME]USD/MM
 |  |  |  |  |  |  | Nov01-Mar02     USD/MM
 |  |  |  |  |  |  | Jan-Dec02       USD/MM
 |  |  |  |  |  |  | Aug01           USD/MM
 |  |  |  |  |  |  | Aug01           USD/MM-L
 |  |  |  |  |  |  | Jul-Oct01       USD/MM
 |  |  |  |  |  |  | Sep01           USD/MM
 |  |  |  |  |  |  | Sep01           USD/MM-L
 |  |  |  |  |  |  | Oct01           USD/MM
 |  |  |  |  |  |  | Aug-Oct01       USD/MM
 |  |  |  |  |  |  | Oct01           USD/MM-L
Spreadsheet: 177115d1346192026-splitting-content-in-separate-columns-parse-by-char-10-try-2
Sheet: Sheet1

Address1_x000D_ Address2_x000D_ City_x000D_ Postcode |  |  |  |  | <<Look at these formulas to see if they work for you.
Original Data | 1st Line of Column-A | 2nd Line of Column-A | 3rd Line of Column-A | 4th Line of Column-A
Line-1
Line-1 Line-2
Line-1 Line-2 Line-3
Spreadsheet: 57004d1257186601-cell-format-locked-when-using-if-then-formula-example
Sheet: data

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Code01 | Code02 | Code03 | Code04 | [NAME] | Code06 | Code07 | Value01 | Value02 | Value03 | Value04 | Value05 | Value06 | Value07 | Total
0 | 0 | 0 | 0 | 0 | 0 | 0 | 100123 | 0 | 0 | 0 | 0 | 200123 | 1100123 | 2123123 | 0 | 0 | 0 | 0 | 8391 | 8748 | 8809 | 8810 |  |  |  | 100123 | 200123 | 1100123 | 2123123 |  |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 100123 | 0 | 0 | 0 | 0 | 200123 | 0 | 2123123 | 0 | 0 | 0 | 0 | 8391 | 8748 | 8810 |  |  |  |  | 100123 | 200123 | 2123123 |  |  |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 100123 | 0 | 0 | 0 | 0 | 200123 | 0 | 2123123 | 0 | 0 | 0 | 0 | 8391 | 8748 | 8810 |  |  |  |  | 100123 | 200123 | 2123123 |  |  |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 100123 | 0 | 0 | 0 | 0 | 200123 | 0 | 2123123 | 0 | 0 | 0 | 0 | 8391 | 8748 | 8810 |  |  |  |  | 100123 | 200123 | 2123123 |  |  |  |  | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 100123 | 0 | 0 | 0 | 0 | 200123 | 1100123 | 2123123 | 0 | 0 | 0 | 0 | 8391 | 8748 | 8809 | 8810 |  |  |  | 100123 | 200123 | 1100123 | 2123123 |  |  |  | 0
Spreadsheet: 218339d1362430671-auto-increment-merged-column-by-1-merged-cell-sample
Sheet: Sheet1

List
[NAME]
[NAME]
Rebecca
[NAME]
[NAME]
[NAME]
Rachel
[NAME]
[NAME]
[NAME]
[NAME]
 |  |  |  | Age | Occupation | City |  | Age | Occupation | City |  | Age | Occupation | City
Spreadsheet: 474639d1470840904-sorting-issue-in-excel-need-help-asap-sample-34-
Sheet: Source

Your data_1 | Your data_2 | Your data_3 | Your data_4 | Your data_5 | Your data_6 | Your data_7 | Your data_8 | Your data_9 | Your data_10 | Your data_11 | Your data_12 | Order
2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | DT-3124-0001A | a | a | a | 3
3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | P-SAMP-KT | b | b | b | 4
4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 5601P | c | c | c | 1
5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5622 | d | d | d | 2
Spreadsheet: 705754d1606296446-average-last-n-rows-based-on-conditions-sample-2-ans
Sheet: Sheet1

Player | Desc | Total | Workings | Divisor | Result |  | FORMULA
Player A |  | 61
Player A |  | 31
Player A |  | 6
Player A | NB | 74
Player A |  | 2 | 2+74+6+31+61 | Divide by 4
Player A |  | 5 | 5+2+74+6+31 | Divide by 4
Player A | NB | 45 | 45+5+2+74+6 | Divide by 3
Player A |  | 87 | 87+45+5+2+74 | Divide by 3
Player B |  | 6
Player B |  | 44
Player B |  | 9
Player B | DNQ | 0
Player B |  | 17 | 17+9+44+6 | Divide by 5 |  |  |  |  | F14 should be15.2 not 19
Player B |  | 3 | 3+17+9+44+6 | Divide by 5
Player B | DNQ | 0 | 3+17+9+44+6 | Divide by 5
Player B | DNQ | 0 | 3+17+9+44+6 | Divide by 5
Player B | NB | 1 | 1+3+17+9+44 | Divide by 4
Player B |  | 2 | 2+1+3+17+9 | Divide by 4
Spreadsheet: tracy_geaccone__40528__sharris1001wk4
Sheet: Plan vs. Forecast

Transwestern Pipeline Company
($[NAME])
October:  10/01/01 thru 10/23/01 |  |  |  |  |  | 2001-10-25 08:09:28.530000
Plan vs. Forecast |  | October, 2001
 |  |  | Weekly
 |  | Plan | Forecast | [NAME] |  | Comments
West Demand Revenues |  | 10.272 | 10.539 | 0.2669999999999995 |  | New Contracts; Higher rates
West Commodity Revenues |  | 0.853135 | 0.9111659999999997 | 0.05803099999999972
East Demand Revenues |  | 1.044 | 1.228 | 0.1839999999999999 |  | New Contracts
East Commodity Revenues |  | 0.138 | 0.1679999999999999 | 0.02999999999999992
[NAME] |  | 0.635 | 0.703 | 0.06799999999999995 |  | New Contracts; [NAME] rates
[NAME] Revenues |  | 0.08299999999999996 | 0.06800000000000006 | -0.0149999999999999
[NAME] |  | 0 | 0.005047899999999999 | 0.005047899999999999
Revenue Variance |  | 13.026135 | 13.6222139 | 0.5960788999999966
Fuel Price [NAME] |  | 1.104 | 0.635 | -0.4690000000000001 |  | MTD index price of $1.95 vs. Plan index price of $3.39
Fuel Volume Variance-Unhedged |  | 0 | -0.243 | -0.243
Sales Margin Variance on Unhedged |  | 0 | 0.067 | 0.067
Hedging Adjustment |  | 2.199 | 2.206 | 0.007000000000000117
Other Adjustment |  | 0.002 |  | -0.002
Fuel Variance (Excludes UAF) |  | 3.305 | 2.665 | -0.64
Monthly Stretch |  | 0.838 | 0 | -0.838
Target Adjustment |  | -0.3 | 0 | 0.3
Current Month Margin Variance |  | 16.869135 | 16.2872139 | -0.5819211000000033
Expenses |  | -1.018 | -0.944 | 0.07400000000000007
Non-Recurring |  | 0 | 0 | 0
Other |  | -0.004 | -0.004 | 0
Total Current Month Variance |  | 15.847135 | 15.3402139 | -0.5079211000000032
[NAME] |  | 44.342 | 47.153 | 2.811
2nd Qtr |  | 43.266 | 52.278 | 9.012
1st Qtr |  | 45.571 | 47.784 | 2.213000000000001
October 31, 2001 YTD |  | 149.026135 | 162.4865299 | 13.46039489999998 |  | Includes YTD Target adjustment of ($3.3)
 |  |  |  |  |  | Includes September Actuals
 |  |  |  |  |  | YTD variance decreased due to OBA re-evaluations for August & September