tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 775986d1649427355-using-if-function-combined-with-conditional-formatting-to-indicate-data-entries-excel-help
Sheet: Ark 2

 | Hello everyone, I have a problem that I am struggeling with. Due to the confidetiality of the data, I have created a copy of the original sheet.
 | To explain what I am trying to do. Inteded purpose: In sheet 1 there is the possibility of entering Yes or No. If someone enters No, nothing happens. If they Enter Yes, C2 in Sheet 2 changes to Green (through conditional formatting).
 | B2, then changes color to red, meaning, that you need to enter data, in order to make it go green. The way you enter data, is by typing in 1's in the area E2 - N2.
 | For each 1 you have entered, the same amount of cells P2 - Y2 and AA - AJ will turn yellow, implying you need to enter data in those. One then fills out "A" in the yellow cells in P2 - Y2
 | In AA 2 - AJ2, you can enter entries through a list. If you chose more than 10 years, nothing will happen. You will then need to fill out AW + AY with "A" and the B2 cell should turn green, since all yellow cells have data in them
 | If you choose anything between under 2 years - 10 years, the cells in AL2 - AU2 will become yellow. And you need to fill in this data for B2 to turn green.
 | Current problem:
 | I have tried to set up the color change, based on empty cells, but it does not really work for me. Once you have entered an entry in the yellow cells in AA2 -AJ2, the B2 cell will turn [NAME], eventhough there are other yellow cells that has not been filled.
 | Is there a way to fix this? I hope this does not seem too complex.
Spreadsheet: 215691d1361457684-count-non-consecutive-days-as-new-occurence-to-be-used-in-average-sample
Sheet: Sheet2

Row Labels
123456
[NAME], [NAME]
2013-01-04 00:00:00
2013-01-05 00:00:00
2013-01-06 00:00:00
2013-01-07 00:00:00
234567
Jones, [NAME]
2013-01-04 00:00:00
2013-01-05 00:00:00
2013-01-10 00:00:00
2013-01-11 00:00:00
2013-01-12 00:00:00
2013-02-16 00:00:00
2013-02-17 00:00:00
2013-02-18 00:00:00
345678
[NAME], [NAME]
2013-01-16 00:00:00
2013-01-17 00:00:00
2013-01-18 00:00:00
456789
[NAME], [NAME]
2013-02-15 00:00:00
2013-02-16 00:00:00
2013-02-17 00:00:00
Grand Total
Spreadsheet: 128810d1321290044-not-quite-a-multiple-sumif-book1
Sheet: Sheet1

 | Table 1 |  |  |  |  | Table 2
 | Date | City | Sales |  |  |  | 2011-11-01 00:00:00 | 2011-11-02 00:00:00 | 2011-11-03 00:00:00
 | 2011-11-01 00:00:00 | Dallas | 5 |  |  | North | 15 | 22 | 4
 | 2011-11-01 00:00:00 | Boston | 15 |  |  | South | 8 | 14 | 13
 | 2011-11-01 00:00:00 | Miami | 3
 | 2011-11-02 00:00:00 | Dallas | 14
 | 2011-11-02 00:00:00 | New York | 22
 | 2011-11-03 00:00:00 | Atlanta | 13
 | 2011-11-03 00:00:00 | Boston | 4
 | Lookup table:
 | North | South
 | Boston | Dallas
 | New York | Miami
 |  | Atlanta
Spreadsheet: 46579d1245423937-sumif-multiple-worksheets-add-all-cells-adjacent-to-cell-w-value-matching-query-kor-cart-quotas
Sheet: GNH - DAY MEDICAL AND ENDOSCOPY

K-BRO LINEN SYSTEMS - EDMONTON  PLANT
DAY MEDICAL AND ENDOSCOPY
FACILITY: | UNIVERSITY OF ALBERTA
Date:
 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | STATS
DELIVERY DAYS: | X | X | X | X | X
 | *NO STAT HOLIDAYS
** If more/less linen required please fax in this order by 9:30 a.m. (FAX # (780) 451-5125)
[NAME] |  |  |  | PACK # |  | QUOTA | SHELF | REC | +/-/HOLD
25-DECONTAMINATION GOWNS L |  |  |  | BP0042 |  | 2
25-DECONTAMINATION GOWNS M |  |  |  | BP0042 |  | 2
5-GOWN STD XL |  |  |  | BP0021 |  | 2
5-LG-SPLIT-DG |  |  |  | BP0029 |  | 5
20-HUCK TOWELS |  |  |  | BP0009 |  | 3
UPDATED:
June 17th 2009
Spreadsheet: 403e337e-4ea9-48d4-80fa-1902e0cb65ce
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: |  |  | 2011-01-13 09:26:05.860000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
5.25 | 101.5 | 101.5 | 101.375 | 100.875 |  | and are added to price quote
5.125 | 101.069 | 101.069 | 100.944 | 100.444
5 | 100.719 | 100.719 | 100.594 | 100.094 |  | Note: | Refer To Price [NAME]
4.875 | 99.881 | 99.881 | 99.756 | 99.256 |  |  | For all Price Adjs
4.75 | 99.33 | 99.33 | 99.205
4.625 | 98.309 | 98.309 | 98.184
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.75 | 101.75 | 101.75 | 101.625 | 101.125
4.625 | 101.227 | 101.227 | 101.102 | 100.602
4.5 | 101.036 | 101.036 | 100.911 | 100.411
4.375 | 100.753 | 100.753 | 100.628 | 100.128
4.25 | 100.268 | 100.268 | 100.143
 |  |  |  |  |  | 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: |  |  | 2011-01-13 09:26:05.860000
 |  |  |  |  |  | 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 | 2011-01-27 09:26:05.860000
30 DAY | 2011-02-11 09:26:05.860000
45 DAY | 2011-02-26 09:26:05.860000
60 DAY | 2011-03-13 09:26:05.860000
90 DAY | 2011-04-12 09:26:05.860000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 33493d1229948356-if-query-if-query
Sheet: Sheet1

Green | Amber | Green | Green | Green | Amber | Green | Green | Amber | Red
4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
Fail | Pass | Pass | Fail | Fail | Pass | Pass | Pass | Pass | Pass
Totals
Green | 6
Amber | 3
Red | 1
 |  | Passed in Green? | Passed in Amber? | Passed in Red?
Pass | 7
Fail | 3
Spreadsheet: 7c9b48dc-ad09-443e-9915-b604b4f691dc
Sheet: Yearly

 | TomTom in the last 5 years | 2011 | 2010 | 2009 | 2008 | 2007
 | (in € millions)
 | Profit and loss *
 | Revenue | 1273.217 | 1521.082983 | 1480 | 1674 | 1737
 | Cost of sales | 633.545 | 777.018333 | 749 | 893 | 973
 | Gross result | 639.672 | 744.06465 | 731 | 781 | 764
 | Research and development expenses | 172.822 | 162 | 139 | 123 | 44
 | Amortisation of technology & database | 84.619 | 78 | 75 | 48 | 16
 | Marketing expenses | 78.062 | 105 | 86 | 143 | 137
 | Selling, general and administrative | 720.853 | 200 | 199 | 1262 | 108
 | expenses
 | Stock compensation expense | 7.985 | 13 | 11 | 5.6 | 31
 | Total operating expenses | 1064.341 | 558 | 510 | 1581 | 336
 | Operating result | -424.669 | 186 | 221 | -801 | 428
 | Financial income and (expense), net | -16.201 | -52 | -109 | 7 | 4
 | Profit before tax | -440.87 | 134 | 111 | -794 | 431
 | Income tax | 1.919 | 26 | 25 | 78 | 114
 | Net result | -438.951 | 108 | 86 | -872 | 317
 | Balance sheet | 2011 | 2010 | 2009 | 2008 | 2007
 | Non-current assets | 1300.595 | 1869.938153 | 1920 | 1958 | 915
 | Inventory | 65.502 | 93.821662 | 67 | 145 | 131
 | Trade receivables | 184.939 | 305.82129 | 294 | 290 | 403
 | Other receivables | 51.242 | 41.853077 | 26 | 16 | 31
 | Financial instruments | 2.784 | 5.723738999999999 | 11 | 37 | 27
 | Cash and cash equivalents | 193.579 | 305.599951 | 368 | 321 | 463
 | Total assets | 1798.641 | 2622.757872000001 | 2686 | 2767 | 1970
 | Equity | 708.451 | 1141.527575 | 1018 | 513 | 1352
 | Provisions | 101.327 | 109.288006 | 114 | 113 | 96
 | Borrowings | 383.81 | 587.596986 | 790 |  | 0
 | Other non-current liabilities | 182.274 | 211.940931 | 223 | 234 | 1
 | Other current liabilities | 422.779 | 572.404331 | 541 | 518 | 521
 | Total liabilities | 1798.641 | 2622.757829 | 2686 | 2767 | 1970
 | Cash flow
 | Cash generated from operations | 195.219 | 265.2928760000001 | 430 | 463 | 535
 | Net increase/(decrease) cash and cash equivalents | -112.136 | -63.84196385393123 | 45 | -142 | 28
 | General
 | Number of employees (end of year) | 3677 | 3487 | 3089 | 3498 | 1337
 | * 2008 P&L includes a non-cash impairment charge of €1,048 million and a restrucuting charge of €16 million
 | * 2009 P&L includes a restructuring charge of €10 million
 | * 2010 P&L includes a restructuring charge of €3 million
 | * 2011 P&L includes a non-cash impairment charge of €512 million and a restrucuting charge of €15 million
Spreadsheet: 1737d995-8cad-4ea6-b2b7-6df869726a80
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
 | Time Series Workbook
 | 6202.0 Labour Force, Australia
 | Table 20. Aggregate monthly hours worked by State - Trend and Seasonally adjusted
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Aggregate Monthly Hours Worked ;  NEW SOUTH WALES ; |  |  | Trend | A3591553W | 1978-07-01 00:00:00 | 2013-09-01 00:00:00 | 423 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  VICTORIA ; |  |  | Trend | A3591554X | 1978-07-01 00:00:00 | 2013-09-01 00:00:00 | 423 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  [NAME] ; |  |  | Trend | A3591555A | 1978-07-01 00:00:00 | 2013-09-01 00:00:00 | 423 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  SOUTH AUSTRALIA ; |  |  | Trend | A3591556C | 1978-07-01 00:00:00 | 2013-09-01 00:00:00 | 423 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  WESTERN AUSTRALIA ; |  |  | Trend | A3591557F | 1978-07-01 00:00:00 | 2013-09-01 00:00:00 | 423 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  TASMANIA ; |  |  | Trend | A3591558J | 1978-07-01 00:00:00 | 2013-09-01 00:00:00 | 423 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  NORTHERN TERRITORY ; |  |  | Trend | A3591559K | 1978-07-01 00:00:00 | 2013-09-01 00:00:00 | 423 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  AUSTRALIAN CAPITAL TERRITORY ; |  |  | Trend | A3591560V | 1978-07-01 00:00:00 | 2013-09-01 00:00:00 | 423 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  NEW SOUTH WALES ; |  |  | Seasonally Adjusted | A3591544V | 1978-07-01 00:00:00 | 2013-09-01 00:00:00 | 423 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  VICTORIA ; |  |  | Seasonally Adjusted | A3591545W | 1978-07-01 00:00:00 | 2013-09-01 00:00:00 | 423 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  [NAME] ; |  |  | Seasonally Adjusted | A3591546X | 1978-07-01 00:00:00 | 2013-09-01 00:00:00 | 423 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  SOUTH AUSTRALIA ; |  |  | Seasonally Adjusted | A3591547A | 1978-07-01 00:00:00 | 2013-09-01 00:00:00 | 423 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  WESTERN AUSTRALIA ; |  |  | Seasonally Adjusted | A3591548C | 1978-07-01 00:00:00 | 2013-09-01 00:00:00 | 423 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  TASMANIA ; |  |  | Seasonally Adjusted | A3591549F | 1978-07-01 00:00:00 | 2013-09-01 00:00:00 | 423 | 000 Hours | FLOW | Month | 1
© Commonwealth of Australia  2013
Spreadsheet: 485791d1477068389-solving-a-slow-excel-file-which-uses-over-1gb-of-memory-planfile2016test-1
Sheet: Drop down lis

Drop down competenties
KRA Consolidation high
KRA Consolidation low
KRA Inventory
[NAME]
KRA Orderplanning
KRA Packing systeem
KRA Packing
KRA Picking
KRA Picking reach
KRA WEB
[NAME]
KRA Replenishment
[NAME]
KRA Storing
KRA Shiftlead
KRA Shipping
[NAME]
KRA Splitting
KRA Superuser
KRA VAS
KRA VAS skilled
Opleiding
Spreadsheet: mary_fischer__25740__E-20R
Sheet: E18YTD.XLS

ENRON CORP AND CONSOLIDTED SUBSIDIARIES
COMPANY #
LGM Investments, Inc.
ANALYSIS OF RESERVE ITEMS
FOR THE 12 MONTHS ENDED 12-31-2000
PREPARED BY:
EXTENSION:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-18
 |  | 12-31-99 Balance |  | ADDITIONS  DR (CR) |  |  |  | DEDUCTIONS  DR (CR)
 |  | DR. (CR) |  | RECORDED TO |  | RECORDED TO |  | RECORDED TO |  | RECORDED TO |  | DR. (CR)
[NAME] |  | BEGINNING BALANCE |  | INCOME STATEMENT |  | OTHER ACCOUNTS |  | INCOME STATEMENT |  | OTHER ACCOUNTS |  | ENDING BALANCE |  | COMMENTS/EXPLANATIONS
Allowance for Doubtful Accounts
(MUST TIE TO HYPERION LINE 0065)
Asset/Expense Accts:  DR/(CR)  Same signs as Hyperion
Reserve for Regulatory Issues - Current
(MUST TIE TO HYPERION LINE 0641)
Income Accts:  DR/(CR)  Reverse signs from Hyperion
Reserve for Regulatory Issues - Long Term
(MUST TIE TO HYPERION LINE 0815)
Income Accts: DR/(CR)  Reverse signs from Hyperion
Other Reserves - Other
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
(MUST TIE TO HYPERION LINE 0840)
Income Accts: DR/(CR)  Reverse signs from Hyperion
Hyperion Line #   and Description of Other Reserves   (not listed above)
Total Other Reserves  DR/(CR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-18
Spreadsheet: 876343d1723028999-only-pull-into-cells-from-column-c-if-they-dont-appear-in-column-a-jacks18928jl-excel-help-columns-aligw
Sheet: Sheet1

 |  |  | Requirement
 | Active with dev | Tickets in progress | Only pull into cells from column C, if they don't appear in column B
 | [NAME] | [NAME] | Pink Shirt
 | Red Jumper | Red Jumper | Orange Coat
 | Purpled Jumper | Purpled Jumper | Purple Jean
 | Blue Jumper | Blue Jumper | Red Jeans
 | [NAME] | [NAME] | Orange Dress
 | Green Jumper | Green Jumper | Red Dress
 | [NAME] | [NAME]
 | Red Shirt | Red Shirt
 |  | Blue Shirt
 | [NAME] | Pink Shirt
 |  | Orange Coat
 |  | Purple Jean
 |  | Red Jeans
 |  | Orange Dress
 |  | Red Dress
Spreadsheet: 269823d1381299218-help-please-need-formula-to-sum-and-average-data-using-multiple-vlookup-s-credit-dashboard-monthly-yearly-excel-submission-
Sheet: Metrics

Metric | Category | KPI | Measurement | Team | Individual | File Name | File Location
1 | Collection | Collection (%) | % | Y | Y
2 | Collection | Exposure > 60 Days (%) | % | Y | Y
3 | Collection | DSO (#) | # | Y | N
4 | Disputes | [NAME]. Days (#) | # Business Days | Y | Y
5 | Disputes | [NAME] 20 Days (#) | # | Y | Y
6 | Disputes | [NAME]. Vs Comp. (#) | # | Y | Y
7 | Banking | Unallocated Funds ($M) | $ | Y | N
8 | Banking | Payments Processed (#) | # | Y | N
9 | Banking | Unclaimed EFT EOM ($M) | $ | Y | N
10 | Reporting | Doubtful ($M) | $ | Y | N
11 | Reporting | Adjustments ($M) | $ | Y | N
12 | Resource | FTE (#) | # | Y | N
Spreadsheet: 871984d1718358439-multiple-conditional-formatting-from-multiple-criteria-sample
Sheet: Timesheet Data

Date
 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2024-05-01 00:00:00 | 9.44 | 8.65 | 8.27 | 7.5 | 8.94 | 9.06
2024-05-02 00:00:00 | 10.84 | 8.4 | 8.57 | 8.57 | 8.95 | 9.14
2024-05-03 00:00:00 | 10.41 | 8.43 | 7.78 |  | 8.379999999999999 | 9.35
2024-05-07 00:00:00 | 9.760000000000002 | 8.690000000000001 | 8.1 | 9.06 |  | 10.33
2024-05-08 00:00:00 | 10.56 | 8.35 | 7.98 | 4.55 | 8.120000000000001 | 9.39
2024-05-09 00:00:00 | 10.65 | 8.290000000000001 | 7.819999999999999 | 8.79 | 9.21 | 9.5
2024-05-10 00:00:00 | 10.71 | 8.42 | 8.31 | 8.540000000000001 | 8.67 | 10.47
2024-05-13 00:00:00 | 10.61 | 8.290000000000001 | 7.94 | 8.75 | 4.92
2024-05-14 00:00:00 | 10.62 | 8.17 | 7.93 |  | 9.26
2024-05-15 00:00:00 | 10.49 | 8.08 | 8.059999999999999 | 8.44 | 8.26
2024-05-16 00:00:00 | 10.4 | 8.33 | 7.87 | 6.720000000000001 | 9.3
2024-05-17 00:00:00 | 9.01 | 8.280000000000001 | 4.64 |  | 8.4
2024-05-20 00:00:00 | 10.58 | 8.42 | 8.200000000000001 | 8.719999999999999 | 8.530000000000001 | 10.15
2024-05-21 00:00:00 | 9.42 | 8.629999999999999 | 8.21 | 7.56 | 8.23 | 8.97
2024-05-22 00:00:00 | 10.72 | 8.15 | 7.15 | 8.79 |  | 9.72
2024-05-23 00:00:00 | 10.92 | 4.21 | 8.059999999999999 | 8.85 |  | 8.51
2024-05-24 00:00:00 |  | 4.11 | 7.98 |  |  | 9.52
2024-05-28 00:00:00 | 9.26 | 8.52 | 6.04 | 8.79 |  | 9.66
2024-05-29 00:00:00 | 10.25 | 8.14 | 8.1 | 5.09 | 8.93 | 9.07
2024-05-30 00:00:00 | 10.54 | 4.02 | 7.97 | 4.67 | 9.57 | 9.930000000000001
2024-05-31 00:00:00 | 10.55 | 8.19 | 8.32 | 8.73 | 8.75 | 9.14
Grand Total | 205.74 | 162.7700000000001 | 163.3 | 132.12 | 136.42 | 151.91
Spreadsheet: 1b94c1e2-bdc8-4f21-929f-7c0980ce7fc0
Sheet: Sheet1

Permit No.: | Unnamed: 1 | Unnamed: 2 | WQ0019962 | Unnamed: 4 | Unnamed: 5 | Facility Name: | Unnamed: 7 | Berkley & Patton Parks | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | County: | Henderson | Unnamed: 16 | Month: | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | Berkley |  | Field Name: |  | Patton |  | Field Name: |  |  |  | Field Name:
 |  |  |  |  |  | Area (acres): |  | 5 |  | Area (acres): |  | 4 |  | Area (acres): |  |  |  | Area (acres):
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.25 |  | [NAME] (in): |  | 0.25 |  | [NAME] (in): |  |  |  | [NAME] (in):
 |  |  |  |  |  | Annual Rate (in): |  | 45.7 |  | Annual Rate (in): |  | 71.5 |  | Annual Rate (in): |  |  |  | Annual Rate (in):
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
26
27
28
29
30
31
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: c034f9d4-4fb6-435b-a8e9-1d64baddc9dd
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
COUNTRY |  | : | AUSTRIA
CURRENCY |  | : | EUR
TAX RATE |  | : | 0.212
RATE CODE |  | : |  |  | LU | LU | LU | LU | LU | LU | LU | LU | LU | LU
 |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | ADD | 1 | ADD
GRP | CODE | CAR TYPE (OR SIMILAR) |  |  | DAY | DAYS | DAYS | DAYS | DAYS | DAYS | DAYS | DAYS | MONTH | KM
A | ECMR | SKODA FABIA 1.4 [AC] |  |  | 59 | 118 | 177 | 224 | 280 | 280 | 280 | 40 | 1180 | 0
B | CDMR | FORD FOCUS [AC] |  |  | 72 | 144 | 216 | 272 | 340 | 340 | 340 | 49 | 1440 | 0
C | CDAR | MERCEDES A-CLASS [AC] |  |  | 84 | 168 | 252 | 320 | 400 | 400 | 400 | 57 | 1680 | 0
D | IDMR | MERCEDES B-CLASS [AC] |  |  | 80 | 160 | 240 | 304 | 380 | 380 | 380 | 54 | 1600 | 0
E | SDMR | PEUGEOT 407 [AC] |  |  | 89 | 178 | 267 | 340 | 425 | 425 | 425 | 61 | 1780 | 0
F | SFMR | PEUGEOT 4007 [AC] |  |  | 104 | 208 | 312 | 396 | 495 | 495 | 495 | 71 | 2080 | 0
G | PDMR | MERCEDES C-CLASS [AC] |  |  | 130 | 260 | 390 | 496 | 620 | 620 | 620 | 89 | 2600 | 0
H | [NAME] | MERCEDES C-CLASS [A][AC] |  |  | 142 | 284 | 426 | 540 | 675 | 675 | 675 | 96 | 2840 | 0
I | LDAR | MERCEDES E-CLASS CDI [[NAME] |  |  | 172 | 344 | 516 | 652 | 815 | 815 | 815 | 116 | 3440 | 0
J | [NAME] | MERCEDES M-CLASS [A][AC] |  |  | 186 | 372 | 558 | 708 | 885 | 885 | 885 | 126 | 3720 | 0
K | CWMR | FORD FOCUS [SW][AC] |  |  | 81 | 162 | 243 | 308 | 385 | 385 | 385 | 55 | 1620 | 0
L | IWMR | SKODA OCTAVIA [SW][AC] |  |  | 89 | 178 | 267 | 340 | 425 | 425 | 425 | 61 | 1780 | 0
M | SWMR | OPEL INSIGNIA SPORTS TOURER [AC] |  |  | 98 | 196 | 294 | 372 | 465 | 465 | 465 | 66 | 1960 | 0
N | FVMR | PEUGEOT 807 7SEATS [AC] |  |  | 136 | 272 | 408 | 516 | 645 | 645 | 645 | 92 | 2720 | 0
O | LVMR | RENAULT TRAFFIC 9SEATS [AC] |  |  | 142 | 284 | 426 | 540 | 675 | 675 | 675 | 96 | 2840 | 0
P | VAN | RENAULT MASTER VAN |  |  | 172 | 344 | 516 | 652 | 815 | 815 | 815 | 116 | 3440 | 0
 | BOOKING REQUIREMENTS |  |  |  |  |  | RATE SPECIFICATION
* | RATE IS AWD DEPENDENT |  |  |  |  | * | RATE INCLUDES   : |  |  | UNLIMITED MILEAGE,CDW,TP
 |  |  |  |  |  | * | RATE EXCLUDES   : |  |  | ALL OTHER SERVICES NOT INCLUDED ABOVE
* | RESERVATION AND VOUCHER MUST STATE RATE |  |  |  |  | * | MINIMUM RENTAL  : |  |  | AS SHOWN
 | NAME AND RATE CODE
* | CONSULT AVIS RESERVATIONS FOR ONE WAY |  |  |  |  | * | NOTES           : |  |  | NON-WAIVABLE INSURANCE EXCESS CHARGES APPLY
 | RENTAL AVAILABILITY AND FEES |  |  |  |  |  |  |  |  | ADDITIONAL SERVICES THAT MAY APPLY ARE:
 |  |  |  |  |  |  |  |  |  | PETROL/REFUELLING CHARGE, ADDITIONAL INSURANCES/WAIVERS
 |  |  |  |  |  |  |  |  |  | GOVERNMENT SURCHARGES, AIRPORT/CITY SURCHARGES
 |  |  |  |  |  |  |  |  |  | [NAME],SPECIAL EQUIPMENT
 |  |  |  |  |  |  |  |  |  | OTHER (SEE REFERENCE RACK / CONTRACT)
Spreadsheet: 742748d1628005837-dropdown-list-from-another-workbook-permit-example
Sheet: Builders

Builders | Registration Number
Spreadsheet: robin_rodrigue__33252__BLANKBOOKREQUEST
Sheet: Sheet1

From: | Risk Management -Controls
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Department: |  | Risk Management
Subject: | New Book Request
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Date:
 | COUNTERPARTY |  | BOOK PURPOSE |  |  | TAGG |  |  |  |  |  |  |  |  |  | IT SECURITY | Reporting -Subledger
 |  |  | Internal | External | Both | Book Mapping |  |  |  |  |  |  |  |  |  | Book
 | Short Name | [NAME] | Transactions | Transactions | Transactions | Code | Region | P | B | Idx | [NAME] | PHY | Commodity/UOM/Curr | [NAME] | Reason for Book | Administrator* | MTM | Prud | Realized
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | See Below
 | FIN-ECTI-ENERGY | Financial ECTI-Energy |  |  |  | I7 | EQUITIES | X | - | - | - |  | TN10/CNTR/USD
 | FIN-ECTI-PROP | Financial ECTI-Prop |  |  |  | I8 | EQUITIES | X | - | - | - |  | TN10/CNTR/USD
 | FIN-ECTI-ST | Financial ECTI-ST |  |  |  | I3 | EQUITIES | X | - | - | - |  | TN10/CNTR/USD
 | FINLAND-JV-.2GO | Finland JV GASOIL.2 |  |  |  | QM | DESK | X | - | - | - |  | TN10/CNTR/USD
 | UK-FO-LSSR | UK -Fuel Oil-LSSR |  |  |  | V# | DESK | X | - | - | - |  | TN10/CNTR/USD
 | (Note 1) Please ensure access to both production and stage to enter deals, calculate books and set the official flag
 | Please provide a list of the people who need access to the above book(s).
 | ***'Please provide login names for book administrators.***
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Brent Price
 | Access List:
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Any questions, please contact me
 | (x31462)
Spreadsheet: 711942d1609988036-need-help-creating-lists-desired-formula
Sheet: Sheet1

Customer 1 | Group 1 |  | Desired Result
Customer 2 | Group 1 |  | Customer 1 | Group 1
Customer  3 | Group 1 |  | Customer  4 | Group 2
Customer 4 | Group 2 |  | Customer 6 | Group 3
Customer 5 | Group 2 |  | Customer  10 | Group 4
Customer  6 | Group 3 |  | Customer 13 | Group 5
Customer 7 | Group 3
Customer 8 | Group 3 |  | Customer 2 | Group 1
Customer 9 | Group 3 |  | Customer 5 | Group 2
Customer 10 | Group 4 |  | Customer 7 | Group 3
Customer 11 | Group 4 |  | Customer 11 | Group 4
Customer 12 | Group 4 |  | Customer 14 | Group 5
Customer 13 | Group 5
Customer 14 | Group 5
Spreadsheet: 807851d1670104539-how-to-convert-numbers-with-different-numbers-of-dps-to-text-with-the-same-number-of-dps-excelforum
Sheet: Sheet1

Acid | pKa | DisplayAs
Acetamide | 0.63 | [NAME] (0.63)
Acetic acid | 4.757 | Acetic acid (4.757)
Acetoacetic acid | 3.58 | Acetoacetic acid (3.58)
[NAME] aniline | 4.6 | [NAME] aniline
Benzenesulfonic acid | 0.7 | Benzenesulfonic acid (0.7)
Chromic acid | -0.2 | Chromic acid (-0.2)
Ethylenediaminetetraacetic acid (EDTA) | -0.21 | Ethylenediaminetetraacetic acid (EDTA) (-0.21)
Hydrogen bromide | -9 | Hydrogen bromide (-9)