tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 115fd006-568e-4f6f-af46-084cbcfe9330
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
 |  |  |  |  | 2007-2008
 | JUL | AUG | SEPT | OCT | NOV | DEC | JAN | FEB | MAR | APR | MAY | JUN | YTD
Acquisitions
Requests Searched | 326 | 528 | 444 | 376 | 370 | 642 | 589 | 606 | 277 | 598 | 199 | 625 | 5580
Duplicates Returned | 34 | 46 | 24 | 30 | 45 | 6 | 53 | 26 | 18 | 44 | 23 | 59 | 408
Titles Ordered | 219 | 400 | 368 | 264 | 269 | 307 | 484 | 479 | 226 | 495 | 142 | 503 | 4156
Volumes Added | 475 | 649 | 523 | 438 | 340 | 245 | 548 | 891 | 1188 | 1139 | 938 | 761 | 8135
Firm Orders Added | 233 | 318 | 201 | 299 | 163 | 209 | 231 | 438 | 388 | 556 | 325 | 246 | 3607
SO Vols Added | 20 | 14 | 6 | 15 | 16 | 19 | 6 | 29 | 6 | 12 | 6 | 1 | 150
Gifts Added | 222 | 317 | 316 | 124 | 161 | 17 | 41 | 95 | 114 | 193 | 245 | 179 | 2024
Approvals Added | 0 | 0 | 0 | 0 | 0 | 0 | 270 | 329 | 680 | 378 | 362 | 335 | 2354
Approvals Returned | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11 | 13 | 4 | 5 | 4 | 37
Media Added | 2 | 53 | 13 | 38 | 25 | 25 | 18 | 48 | 11 | 51 | 113 | 3 | 400
Invoices Processed | 45 | 66 | 45 | 88 | 71 | 60 | 65 | 70 | 45 | 61 | 49 | 38 | 703
[NAME]
LC Copy | 234 | 268 | 311 | 239 | 291 | 290 | 239 | 821 | 718 | 843 | 510 | 564 | 5328
Sent to Cataloging | 174 | 216 | 138 | 226 | 198 | 81 | 65 | 217 | 179 | 232 | 105 | 136 | 1967
Inventory
Barcodes Scanned | 0 | 0 | 967 | 606 | 607 | 471 | 0 | 2280 | 1367 | 1609 | 2400 | 2250 | 12557
Helin Corrections | 99 | 49 | 4 | 43 | 43 | 49 | 0 | 374 | 136 | 153 | 68 | 139 | 1157
Items Found | 11 | 0 | 22 | 4 | 3 | 13 | 0 | 36 | 74 | 33 | 54 | 27 | 277
No PZs | 21 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 22
No Items | 40 | 0 | 8 | 4 | 9 | 9 | 0 | 33 | 26 | 27 | 0 | 0 | 156
Spreadsheet: 131268d1322839521-animated-graph-not-plotting-copy-of-business_chart_animation_excelhero
Sheet: demo

Controls
Animation Steps | 17
Enable Animation | 1
Enable Easing | 1
Chart Type | 1
Record Index | 2
Animation Step | 17
Chart Title | South
Divisions | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00
North | 5 | 4 | 3 | 4 | 5 | 5 | 4 | 3 | 4 | 1 | 3 | 4
South | 1 | 2 | 2 | 3 | 2 | 1 | 3 | 4 | 5 | 5 | 4 | 4
East | 7 | 2 | 4 | 9 | 6 | 7 | 2 | 4 | 3 | 4 | 7 | 2
West | 3 | 7 | 1 | 5 | 3 | 9 | 5 | 1 | 2 | 3 | 6 | 3
[NAME] courtesy of excelhero.com
Spreadsheet: 5a02a51e-2809-4504-a173-01a5400b95d6
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2014-01-22 16:09:06.230000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.875 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.75 | 102.443 | 102.318 | 102.193 | 101.818
4.625 | 101.697 | 101.572 | 101.447 | 101.072 |  | Note: | Refer To Price [NAME]
4.5 | 100.775 | 100.65 | 100.525 | 100.15 |  |  | For all Price Adjs
4.375 | 99.816 | 99.691 | 99.566 | 98.941
4.25 | 99.121 | 98.996 | 98.871 | 98.246
4.125 | 98.303 | 98.178 | 98.053 | 97.428
4 | 97.295 | 97.17 | 97.045 | 96.42
3.875 | 96.245 | 96.12 | 95.995 | 95.37 |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.875 | 102.75 | 102.625 | 102.25
3.875 | 102.222 | 102.097 | 101.972 | 101.597
3.75 | 101.548 | 101.423 | 101.298 | 100.923
3.625 | 101.11 | 100.985 | 100.86 | 100.485
3.5 | 100.56 | 100.435 | 100.31 | 99.685
3.375 | 99.767 | 99.642 | 99.517 | 98.892
3.25 | 99.005 | 98.88 | 98.755 | 98.13 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2014-02-05 16:09:06.230000
30 DAY | 2014-02-20 16:09:06.230000
45 DAY | 2014-03-07 16:09:06.230000
60 DAY | 2014-03-22 16:09:06.230000
90 DAY | 2014-04-21 16:09:06.230000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: louise_kitchen__22553__Hot List Update 07-17-01 - Management
Sheet: Storage -50

Deal Description Sheet - 7/17/01
Storage
Project Name | Lead Originator | Counterparty | Description | Potential Valuation | Last Customer Contact | Probability | Expected Closing (Month/Year) | Weekly Updates / Comments
 | Vasquez | Western Hub Properties | Base gas financing at Lodi Storage Field (6.0 Bcf). Base gas financing at Atkinson Storage Field (4.5 Bcf). | 1500 | 2001-07-13 00:00:00 | 0.4 | 2001-09-01 00:00:00 | WHP has asked for a meeting for week of 7/16.
Big Bird-1 | Vasquez | Falcon Gas Storage | Base gas financing @ [NAME] (8 Bcf). Base gas financing @ Hill Lake Storage Field (7.7 Bcf). | 1500 | 2001-07-06 00:00:00 | 0.35 | 2001-10-01 00:00:00 | Financing structure to finance additional base gas for their Hill Lake facility and to take current base gas as well as the new base gas as collateral.  We are waiting to get firm contracts from the client.  Total financing 7.7Bcf.  Client has bridge financing offer from a bank for 3 Bcf, we are vying to get the full package when they refinance, they are still in the process of getting the contracts that will allow them to collateralize it.
 | Vasquez | Columbia Gas | Base gas monetization | 1000 | 2001-05-16 00:00:00 | 0.4 | 2001-11-01 00:00:00 | Met with client and they indicated that to the extent that we can get them not to have to share the proceeds of sale of base gas they would be interested in transacting with us.  We are looking at the regulatory hurdles that we have to overcome to be able to do the transaction without sharing.  Waiting for response from lawyers before we go back to their offices (late July).
Cowboys | Vasquez | TXU | Base gas monetization | 1000 | 2001-07-03 00:00:00 | 0.35 | 2001-12-01 00:00:00 | Interested in setting up a CA to discuss numbers.  TX PUC regulated.  They just hired someone who will do "financial trading" on their storage (apparently someone from Enron), waiting for availability and go for a second visit.
 | Bieniawski | Dominion | Base gas monetization | 2000 | 2001-07-12 00:00:00 | 0.3 | 2001-12-01 00:00:00 | Presented more detailed information regarding structure.  [NAME] and list of due diligence items.  DTI is currently going though some regulatory hearings but remain very interested in the structures.
 | Bieniawski | Questar Regulated Services | Base gas monetization | 1000 | 2001-06-26 00:00:00 | 0.3 | 2002-02-01 00:00:00 | Have expressed interest pending results of regulatory investigation.  In process of signing CA and letter of interest.
 | Rainer | Montana Power | Base gas monetization | 1000 | 2001-06-27 00:00:00 | 0.3 | 2002-02-02 00:00:00 | Expecting their revisions of CA soon.  Fielded initial questions about our data request for model, expecting initial data this week.
Spreadsheet: 147733d1332950303-excel-2007-need-help-calculating-target-sales-price-profit_formula3
Sheet: Sheet1

Cost | eBay | Paypay | Shipping | Fixed Profit | Target Sales Price
220 |  |  | 15 | 10
230 |  |  | 15 | 10
240 |  |  | 15 | 10
Cost | eBay | Paypay | Shipping | Margin | Target Sales Price
220 |  |  | 15 | 0.25
230 |  |  | 15 | 0.25
240 |  |  | 15 | 0.25
Spreadsheet: 871790d1718203881-teacher-markbook-letter-grade-to-numerical-value-average-excel-markbook-ans
Sheet: Score Sheet

Letter grade | Score
E- | 0
E | 1 |  |  | A | [NAME] | A- | C+ | B |  |  |  | A | B | C
E+ | 2 |  |  | B | D | C- | A- | E |  |  |  | [NAME] | D | [NAME]
D- | 3 |  |  | C | [NAME] | A- | A |  |  |  |  | A- | C- | A-
D | 4 |  |  |  |  |  |  |  |  |  |  | C+ | A- | A
[NAME] | 5 |  |  |  |  |  |  |  |  |  |  | B | E
C- | 6
C | 7
C+ | 8
B- | 9
B | 10
[NAME] | 11
A- | 12
A | 13
A+ | 14
Spreadsheet: 799160d1664963250-next-reference-number-formula-test
Sheet: Sheet1

Project ref | Remit Number | Location | ELR | mileage | Depot
159333 | GER4013 | TEST | TEST | TEST
159333 | GER4014 | TEST | TEST | TEST
159333 | GER4015 | TEST | TEST | TEST
159333 | GER4016 | TEST | TEST | TEST
159336 | WAR2787 | TEST | TEST | TEST
159333 | GER4017 | TEST | TEST | TEST
159333 | GER4018 | TEST | TEST | TEST
159336 | WAR2788 | TEST | TEST | TEST
159336 | WAR2789 | TEST | TEST | TEST
159333 | GER4019 | TEST | TEST | TEST
159333 | GER4020 | TEST | TEST | TEST
159333 | GER4021 | TEST | TEST | TEST
159336 | WAR2790 | TEST | TEST | TEST
159336 | WAR2791 | TEST | TEST | TEST
159336 | WAR2792 | TEST | TEST | TEST
159336 | WAR2793 | TEST | TEST | TEST
159333 | GER4022 | TEST | TEST | TEST
159333 | GER4023 | TEST | TEST | TEST
159333 | GER4024 | TEST | TEST | TEST
159336 | WAR2794 | TEST | TEST | TEST
Spreadsheet: 828401d1683470866-summarise-a-matrix-example
Sheet: Sheet1

 | AR_A01 | AR_C10T12 | AR_C31_32 | AT_A01 | AT_C10T12 | AT_C31_32
AR_A01 | 1 | 28.63 | 1 | 5 | 1 | 2
AR_C10T12 | 2 | 92.242 | 2 | 3 | 4 | 5
AR_C31_32 | 11.284 | 0.067 | 3 | 0.096 | 1 | 2
BE_A01 | 0.113 | 5 | 4 | 3 | 4 | 5
BE_C10T12 | 5 | 6 | 5 | 0.096 | 1 | 2
BE_C31_32 | 1 | 6 | 6 | 3 | 4 | 5
BG_A01 | 0.034 | 23 | 7 | 0.096 | 1 | 2
BG_C10T12 | 0.001 | 10 | 8 | 3 | 4 | 5
BG_C31_32 | 3 | 12 | 9 | 3 | 4 | 5
 | A01 | C10T12 | C31_32
A01
C10T12
C31_32
Spreadsheet: 145937d1331823077-input-box-to-collect-comments-in-a-new-worksheet-input-box-example
Sheet: Comment on this sheet

Data Sheet for Comment
 |  | 1 | 2 | 3
 |  | Attribute 1 | Attribute 2 | Attribute 3
 | Animal | The animal is a furry creature | The animal has webbed feet | The animal has a duck's bill |  | On click of cell with attribute    open input box for comment.   Pull down menu for name [NAME] or [NAME].  Input box for comment   Comment saved in a worksheet created with pull down name as worksheet name
 | Vegatable | The plant has yellow pedals | The plant has a long stem | The plant is named susan
 | Mineral | The mineral is shiney | The mineral is heavy | The mineral has a gold color
Spreadsheet: 883916d1732692637-formula-to-repeat-a-set-of-values-in-a-column-when-user-enters-a-records-template_1-jt-
Sheet: Sheet1

User Entry | Item
 | [NAME]
 | Keyboard
 | Speaker
 | Wires
 | Adapter
 | Monitor
 | Headphone
 | Webcam
Spreadsheet: 127592d1320421563-excel-2007-if-and-statement-assignment
Sheet: TASK 2

 | Month | Income | Cost | Discount | Profit
 | 0 | 0 | 200
 | 1 | 17 | 0
 | 2 | 17 | 0
 | 3 | 17 | 0
 | 4 | 17 | 0
 | 5 | 17 | 0
 | 6 | 17 | 0
 | 7 | 17 | 0
 | 8 | 17 | 0
 | 9 | 17 | 0
 | 10 | 17 | 0
 | 11 | 17 | 0
 | 12 | 17 | 0
 |  |  |  | Break even:
Spreadsheet: andy_zipper__788__10_25_01GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] | 60 | 120 | 220 | 47.8 | 87.8 | 2.56 | 2001-10-25 14:56:00
 | [NAME] | 61 | 660 | 760 | 45.3 | 52.1 | 1.87 | 2001-10-25 14:56:00
 | HU F2 | 61 | 900 | 1000 | 45.2 | 50.3 | 1.83 | 2001-10-25 14:56:00
 | HU G2 | 62 | 1075 | 1175 | 43.1 | 47.1 | 1.76 | 2001-10-25 14:56:00
 | [NAME] | 63 | 1200 | 1275 | 41.8 | 44.4 | 1.71 | 2001-10-25 14:56:00
 | [NAME] | 68 | 1400 | 1500 | 40.9 | 43.8 | 1.81 | 2001-10-25 14:56:00
 | [NAME] | 69 | 1500 | 1600 | 39.5 | 42.2 | 1.77 | 2001-10-25 14:56:00
 | [NAME] | 69 | 1500 | 1650 | 36.5 | 40.2 | 1.66 | 2001-10-25 14:56:00
 | HU N2 |  |  |  | 32.5 | 38.4 | 1.52 | 2001-10-24 14:52:00
 | [NAME] |  |  |  | 30.6 | 36.3 | 1.39 | 2001-10-24 14:52:00
 | HU U2 |  |  |  | 32.2 | 36.6 | 1.43 | 2001-10-22 14:23:00
 | [NAME] |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | [NAME]
 | [NAME]
 | HU F3 |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | [NAME]
Spreadsheet: 729054d1618885894-identifying-all-unique-combinations-example-1-
Sheet: Sheet1

 | Scenario |  |  |  | Result
 | Responsible Sector | Program Inventory |  |  | Responsible Sector | Program Inventory
 | Low Carbon Energy Sector | Lower Carbon Transportation
 | Low Carbon Energy Sector | Lower Carbon Transportation
 | Low Carbon Energy Sector | Clean Energy Technology Policy, Research and Engagement
 | Low Carbon Energy Sector | Clean Energy Technology Policy, Research and Engagement
 | Canadian Forest Service | Forest Climate Change
 | Canadian Forest Service | Forest Climate Change
 | Canadian Forest Service | Pest Risk Management
 | Canadian Forest Service | Clean Energy Technology Policy, Research and Engagement
 | Low Carbon Energy Sector | Lower Carbon Transportation
 | Canadian Forest Service | Pest Risk Management
 |  |  |  |  | Low Carbon Energy Sector | Lower Carbon Transportation
 |  |  |  |  | Low Carbon Energy Sector | Clean Energy Technology Policy, Research and Engagement
 |  |  |  |  | Canadian Forest Service | Forest Climate Change
 |  |  |  |  | Canadian Forest Service | Pest Risk Management
 |  |  |  |  | Canadian Forest Service | Clean Energy Technology Policy, Research and Engagement
Spreadsheet: 455491d1460374934-array-search-formula-and-index-workbook2
Sheet: Sheet1

Table 1 | Matched articel name | Manually/correct match |  |  | Table 2
 |  |  |  |  | ArticlesNo | Articel Name
1.101 |  | Product 1 |  |  | 1 | Product 1
10.77 |  | Product 2 |  |  | 77 | Product 2
100,117,78,90,67 |  | Product 4 |  |  | 11 | Product 3
101.117 |  | Product 4 |  |  | 117 | Product 4
90,86,35,78,77,118 |  | Product 2 |  |  | 200 | Product 5
117.101 |  | Product 4 |  |  | 136 | Product 6
90,86,200,78,1,118 |  | Product 1 |  |  | 154 | Product 7
10,1,7,90 |  |  |  |  | 144 | Product 8
90,86,1,78,87,118 |  | Product 1 |  |  | 28 | Product 9
101 |  | Product 10 |  |  | 87 | Product 10
 |  |  |  |  | 37 | Product 11
 |  |  |  |  | 159 | Product 12
Spreadsheet: 846533d1697709036-copy-all-items-listed-by-title-in-house-water-testing-results
Sheet: 2023 2024

 |  |  | Water testing Criteria |  |  |  | LAB 024a Procedure
 |  | ACCEPTABLE RANGE <100* CFU/ML |  | BORDERLINE 100-150 *CFU/ML | UNACCEPTABLE >150*CFU/ML
Test Date | Sample ID | Sample Date | Sample Type | Sample Location | Plated By | Visual Check Ok? (Y/N) | TVC @24 <100 *cfu/ml | TVC @48 | P.Ent @24 | Micro Samples read by : | [NAME] | pH Check (6.5-9.5) | Comments | NCN Reported
Monthly
Weekly
Spreadsheet: 155039d1336658224-excel-2007-how-to-create-a-list-that-returns-unique-values-test-hot-list
Sheet: ILLINOIS

 | ILLINOIS
 | NAME | CONTACT | [NAME] | PHONE | ENROLLMENT | SENT | RESPONSE | COLD | INTERESTED | HOT | POS. SALES $ | CLOSE DATE | NOTES | Trial End
 | University of Illinois system
 | University of Illinois at Chicago |  |  |  |  | 1
 | Northern Illinois University |  |  |  |  | 1
 | Illinois State University |  |  |  |  | 1 |  |  |  | 1
 | University of Illinois at Urbana–Champaign |  |  |  |  | 1 |  |  |  | 1 |  |  |  | 2012-03-21 00:00:00
 | Southern Illinois University Carbondale |  |  |  |  | 1
 | Western Illinois University |  |  |  |  | 1 | 1 | 1 |  |  |  |  |  | 2012-03-30 00:00:00
 | Southern Illinois University Edwardsville |  |  |  |  | 1 | 1 | 1
 | Eastern Illinois University |  |  |  |  | 1 |  |  | 1
TOTALS
Spreadsheet: 676799d1588971698-extract-info-from-workbook-and-make-a-list-search-for-extra
Sheet: Equipment

 | Tools |  |  |  |  |  |  | Electronics |  |  |  |  |  |  | Rentals
 | Item | Comment | Amount | Price | Total |  |  | Item | Comment | Amount | Price | Total |  |  | Item | Comment | Amount | Price | Total
 | Type A |  | 4256 | 24 |  |  |  | Camera | Sponsor: 100% | 1 | 125 |  |  |  | [NAME] |  | 3 | 19
 | Type F | Sponsor: 100% | 2574 | 35 |  |  |  | Wires |  | 1 | 53
 | Type I |  | 5684 | 57 |  |  |  | Binoculars |  | 2 | 346
 | Type P | Extra: 50% | 967 | 1
Spreadsheet: 131897d1323374482-excel-2007-nested-if-formulas-need-help-property-status
Sheet: Recommendation

 |  |  | 2000000 | 0.06
 | Property Status
 | Category 1 | Below expected growth
 | Category 2 (Watch List) | Achieving expected growth, but negative trend lines
 | Category 3 | Achieving expected growth
 | Category 4 | Exceeding expected growth
 | Company Expectations:
 | Financial |  | Ratings
 |  | YOY Revenue growth |  |  | <4%=Cat 4 | 4%-3%=Cat3 | 2.99%-1%=Cat2 | >1%=Cat1
 |  | YOY Occupancy Improvements
 |  | YOY Operating Margin Improvement
 |  | [NAME] 5.5%+
 | Market
 |  | Growing University Enrollment
 |  | Positive High School Graduation Rates
 |  | Positive Supply/Demand
 | Operational
 |  | Bad Debt % <1%
 |  | Month when 96% or greater occupancy is achieved
Spreadsheet: 146765d1332345023-excel-2007-the-formula-is-duplicating-itself-book1
Sheet: fresh plant

Room 20 |  |  |  |  |  |  | Room 21
Empire |  |  |  |  |  |  | Empire
Receiver # | # of boxes | # of boxes transfer | Receiver # | # of boxes | # of boxes transfer |  | Receiver # | # of boxes | # of boxes transfer | Receiver # | # of boxes | # of boxes transfer
106291 | 72 |  |  |  |  |  | 106313 | 24 |  |  |  |  |  | I would like it to transer the receiver number to right room if I put 20 in column
A01177 | 19 |  |  |  |  |  | 106362 | 39 |  |  |  |  |  | O on the March page then it will move it to column A or D. If I put 21 in column
106276 | 24 |  |  |  |  |  | 106225 | 28 |  |  |  |  |  | O on the March page then it will put the receiver # in column H or K.
106247 | 32 |  |  |  |  |  | 106316 | 24
106338 | 28 |  |  |  |  |  | 106172 | 24 |  |  |  |  |  | Once it tranfers the receiver # I want it to put how many boxes
106339 | 24 |  |  |  |  |  |  |  |  |  |  |  |  | there are in the yellow columns
106328 | 24
106247 | 26 |  |  |  |  |  |  |  |  |  |  |  |  | automatically transferfrom March page to Fresh plant page:
106207 | 76 |  |  |  |  |  |  |  |  |  |  |  |  | pink to pink
106362 | 24 |  |  |  |  |  |  |  |  |  |  |  |  | yellow to yellow
106174 | 28 |  |  |  |  |  |  |  |  |  |  |  |  | blue to the right room.
96868 | 9
96871 | 20 |  |  |  |  |  |  |  |  |  |  |  |  | Fresh plant page should do everthing automatically so I don't have to
106350 | 9 |  |  |  |  |  |  |  |  |  |  |  |  | enter in any information on this page.
106232 | 50
103904 | 96
106276 | 78
96874 | 15
96869 | 28
106212 | 24
Total | 842 | 0 | Total | 567 | 553 |  | Total | 842 | 0 | Total | 567 | 553
Spreadsheet: 829484d1684249848-coloring-a-cell-using-len-with-conditioning-formating-but-the-number-is-an-interval-value_text-aligw
Sheet: Sheet1

Nr. | Asset Type | Your Text | [NAME]. | Length | Validation
1 | text1 | dfgdfgdgdfgdgdgdgdfgdfdfgddfgdgedfsd | 27
2 | text2 | asdadadasdasdasdasdasdasdad | 27
3 | text3 |  | 27
4 | text4 | sdfsdfsdfsdfsdfsfsdfsdfsdfsdfsdfsdadasdadadad | 27
5 | text5 | sad | 27
Spreadsheet: 92477d1292028218-drop-down-box-sample-task-list
Sheet: PQR List

Directory Services PQR List
S No. | PQR# and Description | Status | Comments | Column1 | Column2 | Column3
2 | Task 2 | Assigned
3 | Task 3 | Assigned
4 | Task 4 | Assigned
6 | Task 6 | Assigned
8 | Task 8 | Assigned
10 | Task 10 | Assigned
11 | Task 11 | Assigned
12 | Task 12 | Assigned
13 | Task 13 | Assigned
14 | Task 14 | Assigned
15 | Task15 | Assigned
16 | Task 16 | Assigned
17 | Task 17 | Assigned
1 | Task 1 | Resolved
5 | Task 5 | Resolved
7 | Task 7 | Resolved
9 | Task 9 | Resolved
Spreadsheet: 45738d1244554553-excel-2007-summary-dilemna-dummy-sheet
Sheet: Summary

 | Total number of Esso Sites in Programme
 | Type | Number Of | % | Total cost of
 | Moto Sites | 17
 | On The Run | 107
 | Tesco Express | 167
 | Roadchef | 7
 | Other | 276
 | [NAME] in 2008 | Number Of | % of Total | Cost per type |  |  | RUNNING TOTAL % OF SITES UNDERGONE CLEAN AND/OR PAINT
 | Moto Sites Full Valet | 3 |  |  |  |  |  | Moto | OTR | Express | Roadchef | Other
 | On The Run Clean Only | 0 |  |  |  |  | 2008
 | Tesco Express Clean Only | 36 |  |  |  |  | 2009
 | Roadchef Full Valet | 1 |  |  |  |  | 2010
 | Other Full Valet | 74 |  |  |  |  | 2011
 | Total Sites
 | Sites cleaned in 2009 | Number Of | % of Total | Cost per type |  |  | RUNNING TOTAL £ OF SITES UNDERGONE CLEAN AND/OR PAINT
 | Moto Sites Full Valet | 3 |  |  |  |  |  | Moto | OTR | Express | Roadchef | Other
 | On The Run Clean Only | 97 |  |  |  |  | 2008
 | On The Run Full Valet | 5 |  |  |  |  | 2009
 | Tesco Express Clean Only | 29 |  |  |  |  | 2010
 | Roadchef Full Valet | 4 |  |  |  |  | 2011
 | Other Full Valet | 47
 | Total Sites
 |  |  |  |  |  |  |  | Total cost of programme
 | [NAME] in 2010 |  |  | Cost per type |  |  | 2008
 | Moto Sites Full Valet | 7 |  |  |  |  | 2009
 | On The Run | 107 |  |  |  |  | 2010
 | Tesco Express | 64 |  |  |  |  | 2011
 | Roadchef | 0 | 0
 | Other | 76
 | Total Sites
 | [NAME] in 2011 |  |  | Cost per type
 | Moto Sites | 4
 | On The Run | 107
 | Tesco Express | 38
 | Roadchef | 2
 | Other | 79
 | Total Sites