tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 675266d1588226472-automatically-change-cell-data-according-to-given-date-kameraudl-nsliste-skabelon
Sheet: Ark1

Kameraudlånsliste - Arkæologi
Uge nummer:
Kamera nr./dag
Nr. 2 (spejl)
Nr. 3 (spejl)
Nr. 30 (spejl)
Nr. 31 (spejl)
Nr. 32 (spejl)
Nr. 33 (spejl)
Nr. 37 (spejl) | [NAME] | [NAME] | [NAME]
Nr. 38 (spejl)
Nr. 39 (spejl)
Nr. 40 (spejl)
Nr. 41 (kompakt)
Nr. 42 (kompakt)
Nr. 43 (kompakt)
Nr. 111 (spejl)
Nr. 113 (spejl)
Nr. 120 (spejl)
 | https://www.excelforum.com/excel-formulas-and-functions/1314275-automatically-change-cell-data-according-to-given-date.html#post5321292
Spreadsheet: 877447d1724271855-dynamic-table-01-copia
Sheet: F Caixa LA24

Meses | Mês | Ano | Razão | Valor
2024-01-01 00:00:00 |  |  | [NAME] | 14646936.87
2024-02-01 00:00:00 |  |  | [NAME]
2024-03-01 00:00:00 |  |  | [NAME]
2024-04-01 00:00:00 |  |  | [NAME]
2024-05-01 00:00:00 |  |  | [NAME]
2024-06-01 00:00:00 |  |  | [NAME]
2024-07-01 00:00:00 |  |  | [NAME]
2024-08-01 00:00:00 |  |  | [NAME]
2024-09-01 00:00:00 |  |  | [NAME]
2024-10-01 00:00:00 |  |  | [NAME]
2024-11-01 00:00:00 |  |  | [NAME]
2024-12-01 00:00:00 |  |  | [NAME]
2024-01-01 00:00:00 |  |  | [NAME]
2024-02-01 00:00:00 |  |  | [NAME]
2024-03-01 00:00:00 |  |  | [NAME]
2024-04-01 00:00:00 |  |  | [NAME]
2024-05-01 00:00:00 |  |  | [NAME]
2024-06-01 00:00:00 |  |  | [NAME]
2024-07-01 00:00:00 |  |  | [NAME]
2024-08-01 00:00:00 |  |  | [NAME]
2024-09-01 00:00:00 |  |  | [NAME]
2024-10-01 00:00:00 |  |  | [NAME]
2024-11-01 00:00:00 |  |  | [NAME]
2024-12-01 00:00:00 |  |  | [NAME]
2024-01-01 00:00:00 |  |  | [NAME]
2024-02-01 00:00:00 |  |  | [NAME]
2024-03-01 00:00:00
2024-04-01 00:00:00
2024-05-01 00:00:00
2024-06-01 00:00:00
2024-07-01 00:00:00
2024-08-01 00:00:00
2024-09-01 00:00:00
2024-10-01 00:00:00
2024-11-01 00:00:00
2024-12-01 00:00:00
2024-01-01 00:00:00
2024-02-01 00:00:00
2024-03-01 00:00:00
2024-04-01 00:00:00
2024-05-01 00:00:00
2024-06-01 00:00:00
2024-07-01 00:00:00
2024-08-01 00:00:00
2024-09-01 00:00:00
2024-10-01 00:00:00
2024-11-01 00:00:00
2024-12-01 00:00:00
2024-01-01 00:00:00
2024-02-01 00:00:00
2024-03-01 00:00:00
2024-04-01 00:00:00
2024-05-01 00:00:00
2024-06-01 00:00:00
2024-07-01 00:00:00
2024-08-01 00:00:00
2024-09-01 00:00:00
2024-10-01 00:00:00
2024-11-01 00:00:00
2024-12-01 00:00:00
2024-01-01 00:00:00
2024-02-01 00:00:00
2024-03-01 00:00:00
2024-04-01 00:00:00
2024-05-01 00:00:00
2024-06-01 00:00:00
2024-07-01 00:00:00
2024-08-01 00:00:00
2024-09-01 00:00:00
2024-10-01 00:00:00
2024-11-01 00:00:00
2024-12-01 00:00:00
2024-01-01 00:00:00
2024-02-01 00:00:00
2024-03-01 00:00:00
2024-04-01 00:00:00
2024-05-01 00:00:00
2024-06-01 00:00:00
2024-07-01 00:00:00
2024-08-01 00:00:00
2024-09-01 00:00:00
2024-10-01 00:00:00
2024-11-01 00:00:00
2024-12-01 00:00:00
2024-01-01 00:00:00
2024-02-01 00:00:00
2024-03-01 00:00:00
2024-04-01 00:00:00
2024-05-01 00:00:00
2024-06-01 00:00:00
2024-07-01 00:00:00
2024-08-01 00:00:00
2024-09-01 00:00:00
2024-10-01 00:00:00
2024-11-01 00:00:00
2024-12-01 00:00:00
2024-01-01 00:00:00
2024-02-01 00:00:00
2024-03-01 00:00:00
2024-04-01 00:00:00
2024-05-01 00:00:00
2024-06-01 00:00:00
2024-07-01 00:00:00
2024-08-01 00:00:00
2024-09-01 00:00:00
2024-10-01 00:00:00
2024-11-01 00:00:00
2024-12-01 00:00:00
2024-01-01 00:00:00
2024-02-01 00:00:00
2024-03-01 00:00:00
2024-04-01 00:00:00
2024-05-01 00:00:00
2024-06-01 00:00:00
2024-07-01 00:00:00
2024-08-01 00:00:00
2024-09-01 00:00:00
2024-10-01 00:00:00
2024-11-01 00:00:00
2024-12-01 00:00:00
Spreadsheet: 67806d1268325054-indexing-larger-value-book2
Sheet: Sheet1

Account | Customer | Quantity | UM | Price | Document # | Rep | Date | Type | Discount | Cost | Tax Code | Revenue Account | Expense Account | Location/Sub-Location | Net Price | Week Created | Month Created | Net Charge Amount
396611 | [NAME] | 1 | EA | 339 | SO-5169750 | NLE | 2009-01-02 00:00:00 | [NAME] | 0 | 220 | EXEMPT |  |  | MAIN | 339 | WEEK 1,2009 | 2009, 1
403590 | [NAME] | 1 | EA | 339 | SO-5175793 | NLE | 2009-01-29 00:00:00 | [NAME] | 0 | 220 | EXEMPT |  |  | MAIN | 339 | WEEK 5,2009 | 2009, 1
Ok I have one more question for you if you look on ground3 you will see that [NAME] has 2 shipments but
the net charge on one is higher than the other…is there a way to skip the lower charge and have the higher charge
put into S3
Spreadsheet: 7ceb0384-c9df-4fa7-9d00-437759a43791
Sheet: Sheet1

Basic Hourly Rate calculator | Unnamed: 1 | Unnamed: 2 | Only change the numbers that are in purple | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Fuel |  |  |  |  |  |  | 1700.662251655629 | Do not change this number manually - this will be calculated automatically when you change the monthly figure MPP below left.
Machinery fuel |  |  |  |  |  |  | 300
Insurance |  |  |  |  |  |  | 300
Tools |  |  |  |  |  |  | 150
Machinery servicing and costs |  |  |  |  |  |  | 300
Clothing |  |  |  |  |  |  | 150
Work Boots |  |  |  |  |  |  | 60
Advertising |  |  |  |  |  |  | 300
Telephone and internet |  |  |  |  |  |  | 320
[NAME] |  |  |  |  |  |  | 250
Professional Association subs. |  |  |  |  |  |  | 200
Tax | 0.25 |  |  |  |  |  | 5000
NI | 0.12 |  |  |  |  |  | 2400
My Salary |  |  |  |  |  |  | 20000 | This is the amount you would like to take home
Total Costs Per Year |  |  |  |  |  |  | 31430.66225165563
Working hours per year |  |  |  |  |  |  | 2000 | Based on a forty hour week x 50 weeks
Charge Out Per Hour |  |  |  |  |  |  | 15.71533112582781
Van costs
 | MP Month | MPL | Fuel used | Cost p/l | Cost of fuel
January | 500 | 7.55 | 66.22516556291392 | 1.2 | 79.47019867549669
February | 500 |  | 66.22516556291392 |  | 79.47019867549669
March | 700 |  | 92.71523178807948 |  | 111.2582781456954
April | 900 |  | 119.205298013245 |  | 143.046357615894
May | 1000 |  | 132.4503311258278 |  | 158.9403973509934
June | 1200 |  | 158.9403973509934 |  | 190.7284768211921
July | 1200 |  | 158.9403973509934 |  | 190.7284768211921
August | 1200 |  | 158.9403973509934 |  | 190.7284768211921
September | 1200 |  | 158.9403973509934 |  | 190.7284768211921
October | 900 |  | 119.205298013245 |  | 143.046357615894
November | 900 |  | 119.205298013245 |  | 143.046357615894
December | 500 |  | 66.22516556291392 |  | 79.47019867549669
 | 10700 |  | 1417.218543046358 |  | 1700.662251655629
Spreadsheet: 163205d1340221532-matching-values-in-a-table-with-larger-list-of-numbers-and-names-example-aferoz-oeldere-
Sheet: Sheet1

[NAME] | [NAME] | project name
3002168369 | 2400 | no match found |  |  |  |  | ZZZ
3002209337 | 1100 | N |  |  |  |  | N
3002209337 | 1200 | N
3002209337 | 1300 | N
3002209337 | 1400 | N
3002209337 | 1600 | N
3002209337 | 1700 | N
3002209337 | 800 | N
3002209337 | 900 | N
3000408917 | 2900 | E |  |  |  |  | E
3002552154 | 1000 | Q |  |  |  |  | Q
3002552154 | 2300 | Q
3002552154 | 300 | Q
3002552154 | 3800 | Q
3002757619 | 1100 | AA |  |  |  |  | AA
3002757619 | 1600 | AA
3002941321 | 30 | KK |  |  |  |  | KK
3002941321 | 90 | KK
3003049769 | 2900 | XX |  |  |  |  | XX
3003049769 | 3000 | XX
3003049769 | 3100 | XX
Spreadsheet: 63f4d17e-ab05-422b-92e7-01e71f7ef747
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
VITA | Test | VITA | Vitamin A, Serum | Vitamin A, S | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) Specific quantitation of retinol. |  |  |  | 0.5 | mL | Collection Container/Tube: Red top Submission Container/Tube: Amber vial (Supply T192) [NAME]: 0.5 mL Collection Instructions: 1. Fasting-overnight (12-14 hours) (infants-draw prior to next feeding). 2. Send specimen in amber vial to protect from light. Additional Information: Vitamin A, vitamin E, and carotene analysis can be performed on 1 tube. However, the total volume of serum must be > or =3.5 mL. Aliquot 3 mL into an amber vial and label for carotene. Pour the remaining serum into an amber vial and label for vitamin A and/or vitamin E. | 0.25 mL | Hemolysis	Mild reject; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	Serum gel tube | 0-6 years: 11.3-64.7 mcg/dL 7-12 years: 12.8-81.2 mcg/dL 13-17 years: 14.4-97.7 mcg/dL > or =18 years: 32.5-78.0 mcg/dL | Monday through Friday; 1st shift | 2 days | 5 days | 1 | 84590 |  |  |  |  | New England
VITA | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
VITA | Result | 7597 | Free Retinol(Vit A) | Free Retinol(Vit A) | Numeric |  |  |  |  | mcg/dL |  |  |  |  |  |  |  |  |  | 17527-3
Spreadsheet: 08ec1ce2-d2d5-4c6d-97f5-b8e13aeffbb5
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 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26
 |  |  |  |  |  |  |  |  |  |  |  |  | YES |  |  |  |  |  |  |  |  |  |  |  |  | YES
 |  | NO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
 |  |  | YES |  |  |  |  |  |  |  | YES |  |  |  | YES |  |  | YES |  |  |  | YES
 |  |  |  |  |  |  |  |  |  |  |  |  |  | NO |  |  |  |  |  |  |  |  |  |  | NO
 |  | NO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO
 |  |  |  |  |  |  |  |  |  |  | YES |  |  |  | YES |  | NO
 |  |  |  |  |  |  |  |  |  |  |  |  |  | NO |  |  |  | NO
Spreadsheet: 469443d1467915473-help-with-difficult-unique-countifs-oeldere-469424d1467910295-help-with-difficult-unique-countifs-helpie-
Sheet: Sheet1

 |  |  | Date | Status | unique | help
 |  |  | 2015-01-02 00:00:00 | Paid |  |  |  | Number of Dates in January
 |  |  | 2015-01-02 00:00:00 | Paid |  |  |  | Count of Unique Dates WITH PAID STATUS | ???? |  | Should be equal to |  | 8
 |  |  | 2015-01-02 00:00:00 | Paid |  |  |  | Number by year
 |  |  | 2015-01-02 00:00:00 | No
 |  |  | 2015-01-02 00:00:00 | No
 |  |  | 2015-01-02 00:00:00 | No
 |  |  | 2015-01-05 00:00:00 | No |  |  |  | unique | yes
 |  |  | 2015-01-05 00:00:00 | Paid
 |  |  | 2015-01-08 00:00:00 | Paid |  |  |  | Aantal van Date | Kolomlabels
 |  |  | 2015-01-08 00:00:00 | Paid |  |  |  | Rijlabels | No | Paid | Eindtotaal
 |  |  | 2015-01-10 00:00:00 | No |  |  |  | jan | 8 | 8 | 16
 |  |  | 2015-01-10 00:00:00 | No |  |  |  | feb | 4 | 3 | 7
 |  |  | 2015-01-10 00:00:00 | No |  |  |  | mrt | 1 | 3 | 4
 |  |  | 2015-01-10 00:00:00 | Paid |  |  |  | Eindtotaal | 13 | 14 | 27
 |  |  | 2015-01-11 00:00:00 | Paid
 |  |  | 2015-01-11 00:00:00 | Paid
 |  |  | 2015-01-15 00:00:00 | Paid
 |  |  | 2015-01-15 00:00:00 | Paid
 |  |  | 2015-01-15 00:00:00 | Paid
 |  |  | 2015-01-15 00:00:00 | No
 |  |  | 2015-01-19 00:00:00 | No
 |  |  | 2015-01-19 00:00:00 | No
 |  |  | 2015-01-21 00:00:00 | No
 |  |  | 2015-01-21 00:00:00 | Paid
 |  |  | 2015-01-21 00:00:00 | Paid
 |  |  | 2015-01-21 00:00:00 | Paid
 |  |  | 2015-01-25 00:00:00 | No
 |  |  | 2015-01-25 00:00:00 | No
 |  |  | 2015-01-25 00:00:00 | No
 |  |  | 2015-01-25 00:00:00 | No
 |  |  | 2015-01-29 00:00:00 | No
 |  |  | 2015-01-29 00:00:00 | Paid
 |  |  | 2015-02-02 00:00:00 | Paid
 |  |  | 2015-02-02 00:00:00 | Paid
 |  |  | 2015-02-02 00:00:00 | Paid
 |  |  | 2015-02-02 00:00:00 | No
 |  |  | 2015-02-07 00:00:00 | No
 |  |  | 2015-02-07 00:00:00 | No
 |  |  | 2015-02-14 00:00:00 | No
 |  |  | 2015-02-14 00:00:00 | No
 |  |  | 2015-02-14 00:00:00 | No
 |  |  | 2015-02-14 00:00:00 | Paid
 |  |  | 2015-02-16 00:00:00 | No
 |  |  | 2015-02-16 00:00:00 | No
 |  |  | 2015-02-22 00:00:00 | Paid
 |  |  | 2015-02-22 00:00:00 | Paid
 |  |  | 2015-03-08 00:00:00 | No
 |  |  | 2015-03-08 00:00:00 | Paid
 |  |  | 2015-03-11 00:00:00 | Paid
 |  |  | 2015-03-11 00:00:00 | Paid
 |  |  | 2015-03-13 00:00:00 | Paid
 |  |  | 2015-03-13 00:00:00 | Paid
Spreadsheet: 831270d1685531993-check-if-date-persist-within-2-ranges-work-hd
Sheet: Work

User Id | Username | 2023-04-26 00:00:00 | 2023-04-27 00:00:00 | 2023-04-28 00:00:00 | 2023-04-29 00:00:00 | 2023-04-30 00:00:00 | 2023-05-01 00:00:00 | 2023-05-02 00:00:00 | 2023-05-03 00:00:00 | 2023-05-04 00:00:00 | 2023-05-05 00:00:00
ID1 | User1
ID2 | User2
ID3 | User3
ID4 | User4
ID5 | [NAME]
ID6 | [NAME]
ID7 | User7
ID8 | User8
ID9 | [NAME]
ID10 | User10
ID11 | User11
User ID | Reason | From | Until
ID1 | Holiday | 2023-04-29 00:00:00 | 2023-04-30 00:00:00
ID1 | Sick | 2023-05-03 00:00:00 | 2023-05-06 00:00:00 | -> missing at the table above
ID3 | Holiday | 2023-05-03 00:00:00 | 2023-05-06 00:00:00
ID5 | Sick | 2023-04-27 00:00:00 | 2023-04-30 00:00:00
ID5 | Day-Off | 2023-05-03 00:00:00 | 2023-05-04 00:00:00 | -> missing at the table above
ID8 | Holiday | 2023-04-27 00:00:00 | 2023-04-30 00:00:00
ID9 | Sick | 2023-05-01 00:00:00 | 2023-05-04 00:00:00
ID11 | Holiday | 2023-04-26 00:00:00 | 2023-04-27 00:00:00
ID11 | Sick | 2023-05-01 00:00:00 | 2023-05-01 00:00:00 | -> missing at the table above
ID11 | Holiday | 2023-05-04 00:00:00 | 2023-05-05 00:00:00 | -> missing at the table above
Spreadsheet: 75869d1276499350-auto-copy-record-to-different-spreadsheets-example
Sheet: programe 3

Surname | Name | code | Sallary | Shift | Company | Τype | [NAME]
surname5 | name 5 | 60400225 | 1014.71 | 8 | mark | Advisor | programe 3
surname7 | name 7 | 60400255 | 1014.71 | 8 | mark | Advisor | programe 3
surname11 | name 11 | 60400255 | 1014.71 | 8 | mark | Advisor | programe 3
surname18 | name 18 | 60400225 | 1014.71 | 8 | mark | Advisor | programe 3
surname34 | name 34 | 60400111 | 1014.71 | 8 | mark | Advisor | programe 3
Spreadsheet: 856679d1705891773-how-to-remove-names-text-if-repeated-in-another-cell-work-schedule-1-
Sheet: Template

 |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun
 |  | 2022-01-01 00:00:00
Location 1
Location 2
Location 3 | Class A
 | Class B
 | Class C | [NAME]
 | Class D
Location 4
Location 5 |  | [NAME]
Location 6
Location 7 |  | Alicia
Location 8
Location 9
Location 10
Office
Spreadsheet: louise_kitchen__24136__North America Plan 01-08 adj
Sheet: Gas A&A

 | Gas - Analysts/Associates
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Plan
ENACOMP | Compensation |  |  |  |  |  |  | Compensation | 0
 | Special Pays |  |  | 0
 | Analyst & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  | Total
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  |  | Intern | 33000
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 48400 | 0
ENARENT | Rent |  |  |  |  |  |  | Staff | 49500 | 0
ENATECH | Technology |  |  |  |  |  |  | Specialist | 57750 | 0
ENATRANS | Transportation |  |  |  |  |  |  | Sr. Specialist | 71500 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Analyst | 60500 | 1
ENATAXES | Taxes Other than Income |  |  |  |  |  |  | Associate | 89100 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000 | 2
 |  |  |  |  |  |  |  | Director | 143000 | 4
 | Headcount |  |  |  |  |  |  | Sr. Director | 165000 | 0
 |  |  |  |  |  |  |  | VP | 198000 | 1
 | A&A Headcount |  |  |  |  |  |  | MD | 220000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 110925d1307475708-count-summary-by-criteria-across-2-sheets-test
Sheet: Sheet1

Proj | Change
123 | 1
123 | 3
234 | 2
234 | 3
234 | 5
435 | 1
546 | 1
567 | 1
567 | 2
788 | 1
976 | 1
999 | 1
Spreadsheet: 737408d1624398728-break-down-cumulative-sum-of-increments-by-month-please-help-excel_example1
Sheet: Sheet1

 |  |  | DATA
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | Nb of CARS purchased per month |  | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3
 | Cumulative # of cars purchased
 |  | Identify Month
 | 1 | 1 |  | Instructions
 |  | 2 |  | Yellow range (C7:C32) is the outcome I am looking for (values were purposely entered manually for user to understand the logic)
 |  | 3 |  | I am trying to find a solution to generate this calculation either with some excel formulas or using a VBA function
 |  | 4 |  | This example is showing on row 3 a specific number of cars purchased each month
 |  | 4 |  | For instance, at month 1 we acquire 1 car, at month 4 we acquire 2 cars
 |  | 5 |  | Row 4 indicates the cumulative number of cars acquired at any given month (total of 5 cars by Month 4)
 |  | 5 |  | However, I was not able to find a formula/code that can break down each acquisition (of 1 car) and attribute it to the month it belongs
 |  | 6 |  | For example, Car # 4 and Car # 5 are both acquired at Month 4;   Car # 6 and 7 are acquired at Month 5
 |  | 6 |  | Column C is the outcome I am looking for (I entered the values manually for the user to understand the purpose)
 |  | 7 |  | Thank you for your help
 |  | 7
 |  | 8
 |  | 8
 |  | 8
 |  | 9
 |  | 9
 |  | 9
 |  | 10
 |  | 10
 |  | 10
 |  | 11
 |  | 11
 |  | 11
 |  | 12
 |  | 12
 |  | 12
Spreadsheet: 85776d1285808609-sorting-a-cell-amount-into-specific-labelled-amount-columns-demo3
Sheet: Sheet1

 | BULK BUNDLES REQUIRED
 | 50 | 100 | 144 | 200 | 288 | 432 | 500 | 540 | 1000 |  | TOTALS
580
580
580
580
580
580 |  |  |  |  |  |  |  |  |  |  |  |  | This formula has changed to have the number of significance as
580 |  |  |  |  |  |  |  |  |  |  |  |  | 1000 due to the price table having no other options
580
580
 | PRICE TABLE FOR ITEM
 | 50 | 100 | 144 | 200 | 288 | 432 | 500 | 540 | 1000
Supp 1 |  |  | 8.17 | 7.84 |  |  | 6.5
Supp 2 | 7.21 | 6.45 |  | 6.1 |  |  | 4.87
Supp 3 | 4.9 | 3.9 |  | 3.9 |  |  | 3.6
Supp 4 |  |  | 4.59 | 4.59 | 3.67 |  | 3.46 | 3.46
Supp 5 |  |  |  | 7.09 |  |  | 5.44
Supp 6 |  |  |  |  |  |  |  |  | 2.5
Supp 7 |  |  | 4.9 |  | 4.47 | 3.94
Supp 8 |  |  | 7.46 |  | 7.09 | 5.66
Supp 9 |  |  | 6.93 |  | 6.07 | 5.41
THE TOP PART IS DESIGNED TO READ THE PRICE TABLE, AND ONLY SEPARATE THE AMOUNT INTO THE COLUMNS THAT HAVE PRICES FOR THAT SUPPLIER.
IT HOWEVER, DOES NOT SEPARATE THEM EFFECTIVELY AND DOES NOT PROVIDE ME WITH MY AMOUNT REQUIRED OR GREATER.
Spreadsheet: 2dc73504-3a7a-4f57-b851-894547ad1ab3
Sheet: Sheet1

Account Number | Business Name DBA | NAICS Code | Fed Id Number | Mailing Address1 | Mailing Address2 | Mailing Address3 | City | State | Zip Code | Zip4 | 1Person In Charge | 1Telephone | 1Corporate Name | 2Physical Loc1 | 2Physical Loc2 | 2Physical Loc3 | 2Physical Loc City | 2Physical [NAME] | 2Physical [NAME] | 3YN | 3Exact Name | 4Date [NAME] | 5Fiscal Yr | 5aYN | 6Nature of Business | 6Trade Level | 7YN | 7Name | 7Where | 8Former Owner | 8Former Owner Phone | 9Business Sold to Whom | 9Date [NAME]
Spreadsheet: 54185d1254208462-compare-worksheets-for-data-changes-report2
Sheet: Sheet1

article | qty
F4DVD678 | 565
CMED46 | 152
BANDOR45 | 12
R55 | 23
MAJORGRIS67 | 12
CMETD46 | 100
REDSEAL | 489
PART6 | 10
FREDLP78 | 26
C4DVD901 | 9
MAJOR1LP | 565
FAVOUR56 | 75
[NAME] | 25
WORZLE78 | 9
Spreadsheet: 272663d1382456603-display-minimum-value-in-array-example
Sheet: Misc

Misc Specialties
 | Materials
Company | Wood Doors | Hardware | HM
Lowest Bid | 500 | 1800 | 500
abc door | 1000 | 2000 | 500
[NAME] | 800 | 1800 | 600
commerical door | 3000 | * | *
specialty door | 500 | 1900 | 700
Spreadsheet: 476759d1472009185-formula-to-read-a-sheet-structured-as-a-12-month-calendar-index-match
Sheet: 1. ENROLLED DAYS EACH MONTH

 | [NAME] 2016
 |  | CHILDREN IN CARE |  | CHILDCARE 1 | CHILDCARE 2 | CHILD CARE 3 |  | INSTRUCTIONS:
 |  |  |  |  |  |  |  | ENTER ENROLMENT DAYS FOR EACH MONTH
 |  | Sean |  | OAC | SOS Preschool | KU Preschool |  | ENTER SPECIFIC CHANGES TO DATES BY SELECTING EACH MONTH
 |  | [NAME] |  | Nanny
 | 2016 |  | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY |  | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY
 | JANUARY |  | OAC | OAC | OAC | OAC
 | FEBRUARY |  | OAC | OAC | OAC | OAC
 | [NAME] |  | OAC | OAC | OAC | OAC
 | APRIL |  | OAC | OAC | OAC | OAC
 | MAY |  | SOS Preschool |  |  | KU Preschool | KU Preschool
 | [NAME] |  | SOS Preschool |  |  | KU Preschool | KU Preschool
 | JULY |  | SOS Preschool |  |  | KU Preschool | KU Preschool
 | AUGUST |  | SOS Preschool | SOS Preschool |  | KU Preschool | KU Preschool
 | SEPTEMBER |  | SOS Preschool | SOS Preschool |  | KU Preschool | KU Preschool
 | OCTOBER |  | SOS Preschool |  |  | KU Preschool | KU Preschool
 | NOVEMBER |  | SOS Preschool |  |  | KU Preschool | KU Preschool
 | DECEMBER |  | SOS Preschool |  |  | KU Preschool | KU Preschool
Spreadsheet: daren_farmer__5208__BMSPT041
Sheet: BMSPT066

BAMMEL STORAGE ACTIVITY
VOLUME SPLIT BY Counterparties
2001-04-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | SWING CONTRACT VOLUMES |  |  |  |  | ECT LONG/(SHORT) |  |  |  | LONG/(SHORT)
 |  | HPL INDEX |  |  | HPL FIXED PRICE |  |  |  |  | TOTAL | HL&P | CP&L | TUFCO | TOTAL |  | ECT FIRST OF THE MONTH | TUFCO/ HL&P/ CP&L SWING VOLUME | ECT LONG OR (SHORT) |  | ECT TOTAL | HPLC Excluding 3rd Party | Net LONG/ (SHORT)
 |  | MTD Adjustment | CURRENT DAY | Total | MTD Adjustment | CURRENT DAY | Total | 3rd Party | HPLC Total |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  | Reinject Fees
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Injected Volume | Value
Beginning Balance
1 | Scheduled |  |  |  |  |  |  |  |  |  | 0 | 0
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Estimated
 | Estimated
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Index: | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fuel: | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fuel Rate:
Ending Balance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prod.[NAME]:
Variances:
Total Projected
March 31 thru April 6
April 7 thru April 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Previous Position: |  | 452505
April 14 thru April 20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]:
April 21 thru April 27
Spreadsheet: 5d2b9d65-8d43-4cb5-b658-a4ff1af582b5
Sheet: Sheet1

Permit No.: | Unnamed: 1 | Unnamed: 2 | WQ0034190 | Unnamed: 4 | Unnamed: 5 | Facility Name: | Unnamed: 7 | [NAME] WWTF | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | County: | [NAME] | Unnamed: 16 | Month: | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
Did infiltration occur at this facility? |  |  |  |  |  | Site Name: |  | 1 |  | Site Name: |  | 2 |  | Site Name: |  | 3 |  | Site Name: |  | 4
 |  |  |  |  |  | Area (acres): |  | 0.29 |  | Area (acres): |  | 0.28 |  | Area (acres): |  | 0.29 |  | Area (acres): |  | 0.28
 |  |  |  |  |  | Rate (GPD/ft2): |  | 0.782 |  | Rate (GPD/ft2): |  | 0.782 |  | Rate (GPD/ft2): |  | 0.782 |  | Rate (GPD/ft2): |  | 0.782
Day | Weather |  |  | Freeboard |  | Site Infiltrated? |  |  |  | Site Infiltrated? |  |  |  | Site Infiltrated? |  |  |  | Site Infiltrated?
 | Weather Code | Temperature | Precipitation | Storage           (if applicable) | 5-Day Upset       (if applicable) | Volume Applied | Time   Infiltrated | Daily   Loading | [NAME] (Basins Only) | Volume Applied | Time    Infiltrated | Daily   Loading | [NAME] (Basins Only) | Volume Applied | Time   Infiltrated | Daily   Loading | [NAME] (Basins Only) | Volume Applied | Time    Infiltrated | Daily   Loading | [NAME] (Basins Only)
 |  | ºF | in | ft | ft | gal | min | GPD/ft2 | ft | gal | min | GPD/ft2 | ft | gal | min | GPD/ft2 | ft | gal | min | GPD/ft2 | ft
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 (GPD/ft2):
Year to Date Loading (GPD/ft2):