tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 693713d1599109379-excel-formula-for-tax-law-changes-tax-changes
Sheet: PAYE

 | PAY AS YOU EARN PAYE TABLE |  |  |  |  |  |  |  |  | PAY AS YOU EARN PAYE TABLE
 |  | Month | Period |  |  |  |  |  |  |  | Month | Period
 |  | 2020-01-01 00:00:00 | 1 |  |  |  |  |  |  |  | 2020-08-01 00:00:00 | 8
 |  | $ |  | $ |  | Rates |  | $ |  |  | $ |  | $ |  | Rates |  | $
 | From | 0 | to | 70 | multiply by rate | 0 | Deduct | 0 |  | From | 0 | to | 2000 | multiply by rate | 0 | Deduct | 0
 | From | 70.01 | to | 300 |  | 0.2 |  | 14 |  | From | 2000.01 | to | 4000 |  | 0.2 |  | 14
 | From | 300.01 | to | 1000 |  | 0.25 |  | 29 |  | From | 4000.01 | to | 7000 |  | 0.25 |  | 29
 | From | 1000.01 | to | 2000 |  | 0.3 |  | 79 |  | From | 7000.01 | to | 10000 |  | 0.3 |  | 79
 | From | 2000.01 | to | 3000 |  | 0.35 |  | 179 |  | From | 10000.01 | to | 15000 |  | 0.35 |  | 179
 | From | 3000.01 | and above |  |  | 0.4 |  | 329 |  | From | 15000.01 | and above |  |  | 0.4 |  | 329
I want the tax  formula(D17) to include the month so that when tax changes the formuala keeps working accurate. The current formula does not take care of tax changes in August, insteady of resetting the formula
 | Current |  |  |  | Desired
Period | Name | Salary | Tax |  | Period | Name | Salary | Tax
1 | TOMY | 70 |  |  | 1 | TOMY | 70
1 | CRAIG | 200 |  |  | 1 | CRAIG | 200
1 | YOLANDA | 1500 |  |  | 1 | YOLANDA | 1500
1 | KIMBERLY | 2300 |  |  | 1 | KIMBERLY | 2300
1 | GABRIEL | 3000 |  |  | 1 | GABRIEL | 3000
1 | ASHTON | 3100 |  |  | 1 | ASHTON | 3100
8 | TOMY | 70 |  |  | 8 | TOMY | 70
8 | CRAIG | 200 |  |  | 8 | CRAIG | 200
8 | YOLANDA | 1500 |  |  | 8 | YOLANDA | 1500
8 | KIMBERLY | 2300 |  |  | 8 | KIMBERLY | 2300
8 | GABRIEL | 3000 |  |  | 8 | GABRIEL | 3000
8 | ASHTON | 3100 |  |  | 8 | ASHTON | 3100
Spreadsheet: 876515d1723216191-trying-to-display-yearly-quarter-using-start-date-sheet
Sheet: Sheet1

 | Construction Start Date | Constructiont End Date | Quarter Start
 | 2025-08-15 08:00:00 | 2025-12-05 17:00:00 | Q2
 | 2025-07-02 08:00:00 | 2025-09-18 17:00:00 | Q2
 | 2026-04-26 08:00:00 | 2026-12-15 17:00:00 | Q1
 | 2025-06-04 08:00:00 | 2026-03-02 17:00:00 | Q1
 | 2025-10-16 08:00:00 | 2025-10-14 17:00:00 | Q3
 | 2025-11-20 08:00:00 | 2025-07-11 17:00:00 | Q3
 | 2026-03-03 08:00:00 | 2026-07-23 17:00:00 | Q4
 | 2025-04-01 08:00:00 | 2025-09-30 17:00:00 | Q1
 | 2025-10-09 08:00:00 | 2026-02-05 17:00:00 | Q1
 | 2026-02-23 08:00:00 | 2026-12-07 17:00:00 | Q4
 | 2026-02-16 08:00:00 | 2026-09-02 17:00:00
 | 2025-06-06 08:00:00 | 2026-02-05 17:00:00
Spreadsheet: 677555d1589395567-how-to-make-a-section-scrollable-original
Sheet: Project

 | Project Planner
 | HELP
 | Today's Date |  |  |  |  |  |  |  |  |  |  |  |  |  | Project/Task Delay |  |  |  |  |  |  |  |  | Project/Task Duration |  |  |  |  |  |  |  |  |  | Project/Task Progress |  |  |  |  |  |  |  |  |  | Project/Task Completed Earlier then Planned
 | Week Starts from | Monday
 | Project Start Date | 2020-05-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | % Completed (Beyond Projected Duration) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Project/Task Actual Duration
 |  | 0
 | Project Name | Project /Task Manager | Project/Task Duration | Project/Task Start Delay | Actual  Duration | Complete % | Remaining
 | Project Task 1 | Nick | 31 | 4 | 34 | 1
 | Project Task 2 |  | 14 | 6 |  | 0.7
 | Project Task 3 |  | 12 | 7 |  | 0.7
 | Project Task 4 |  | 12 | 8 |  | 0.3
 | Project Task 5 |  | 15 | 2 |  | 0.2
 | Project Task 6 |  | 12 | 2 |  | 0.5
 | Project Task 7 |  | 14 | 2 |  | 1
 | Project Task 8 |  | 13 | 2 |  | 1
 | Project Task 9 |  | 2 | 2 |  | 1
 | Project Task 10 |  | 8 | 2 |  | 1
 | Project Task 11 |  | 11 | 2 |  | 1
 | Project Task 12 |  | 28 | 2 |  | 1
 | Project Task 13 |  | 22 | 2 |  | 1
 | Project Task 14 |  | 19 | 2 |  | 1
 | Project Task 15 |  | 16 | 2 |  | 1
 | Project Task 16 |  | 11 | 2 |  | 1
 | Project Task 17 |  | 19 | 3 |  | 1
 | Project Task 18 |  | 11 | 2 |  | 1
 | Project Task 19 |  | 11 | 2 |  | 1
 | Project Task 20 |  | 11 | 2 |  | 1
 | Project Task 21 |  | 11 | 2 |  | 1
 | Project Task 22 |  | 11 | 2 |  | 1
 | Project Task 23 |  | 11 | 2 |  | 1
 | Project Task 24 |  | 11 | 2 |  | 1
 | Project Task 25 |  | 11 | 2 |  | 1
 | Project Task 26 |  | 11 | 2 |  | 1
 | Project Task 27 |  | 11 | 2 |  | 1
 | Project Task 28 |  | 11 | 2 |  | 1
 | Project Task 29 |  | 11 | 2 |  | 1
 | Project Task 30 |  | 11 | 2 |  | 1
 | Project Task 31 |  | 11 | 2 |  | 1
 | Project Task 32 |  | 11 | 2 |  | 1
 | Project Task 33 |  | 11 | 2 |  | 1
 | Project Task 34 |  | 11 | 2 |  | 1
 | Project Task 35 |  | 11 | 2 |  | 1
Spreadsheet: 290513d1389893626-depreciation-schedule-jimmy
Sheet: PM

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.7
 |  | jan | feb | [NAME] | apr | may | jun | jul | aug | sep | oct | nov | dec | jan | feb | [NAME] | apr | may | jun | jul | aug | sep | oct | nov | dec | jan | feb
2013 | 2014
10 | 10
10 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013 | 0.6
10 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2014 | 0.5
10 | 10
10 | 10
10 | 10
10 | 10
10 | 10
10 | 10
10 | 10
10 | 10
10 | 10
 | Total
Spreadsheet: 841287d1693482196-find-unique-values-and-copy-them-to-another-tab-financial-administration-2023
Sheet: Overview per quarter 2023

 | Exch. [NAME] | 4.7 | Exch. R. Q2 | 4.7 | Exch. [NAME] | 4.7 | Exch. R. Q4 | 4.7
General: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total:
January
February
March
Total Q1:
April
May
June
Total Q2:
In-decrease (%)
July
August
September
Total Q3:
In-decrease (%)
October
November
December
Total Q4:
In-decrease (%)
Total:
Projects
January
February
March
Total Q1:
April
May
June
Total Q2:
In-decrease (%)
July
August
September
Total Q3:
In-decrease (%)
October
November
December
Total Q4:
In-decrease (%)
Total:
Spreadsheet: 784477d1655750406-if-statement-returning-false-value-sample-book
Sheet: Excel Formulas

APAC | Monthly Incidents | [NAME] | Min | EMEA | Monthly Incidents | [NAME] | Min | LATAM | Monthly Incidents | [NAME] | Min | GLOBAL | Monthly Incidents | [NAME] | Min
J |  |  |  | J |  |  |  | J |  |  |  | J
F |  |  |  | F |  |  |  | F |  |  |  | F
M |  |  |  | M |  |  |  | M |  |  |  | M
A |  |  |  | A |  |  |  | A |  |  |  | A
M |  |  |  | M |  |  |  | M |  |  |  | M
J |  |  |  | J |  |  |  | J |  |  |  | J
J |  |  |  | J |  |  |  | J |  |  |  | J
A |  |  |  | A |  |  |  | A |  |  |  | A
S |  |  |  | S |  |  |  | S |  |  |  | S
O |  |  |  | O |  |  |  | O |  |  |  | O
N |  |  |  | N |  |  |  | N |  |  |  | N
D |  |  |  | D |  |  |  | D |  |  |  | D
Spreadsheet: 169599d1342975836-count-if-trial-copy-1
Sheet: Sheet1

 |  |  |  |  |  | Budget For Apple | 10
DATE | Commodity | PRIZE |  |  |  | Budget For Orange | 10
2012-06-01 00:00:00 | Apple | 2 |  |  | Annual Epenses
2012-06-03 00:00:00 | Orange | 2
2012-07-08 00:00:00 | Grapes | 2 |  |  | Month | Commodity | Expenses | Above Budget | Below Budget
2012-07-10 00:00:00 | Water Melon | 5
2012-07-16 00:00:00 | [NAME] | 5
2012-07-16 00:00:00 | Kiwi | 20
2012-07-17 00:00:00 | Apple | 2
2012-07-17 00:00:00 | Orange | 0.3
2012-07-17 00:00:00 | Apple | 0.7
2012-07-17 00:00:00 | Orange | 5
2012-07-17 00:00:00 | Grapes | 2
2012-07-17 00:00:00 | Water Melon | 2
2012-07-21 00:00:00 | [NAME] | 4.8
2012-07-21 00:00:00 | Kiwi | 4.8
Spreadsheet: 669530d1585436901-count-longest-unbeaten-run-unbeaten-run
Sheet: Sheet1

No | Outcome (W/D/L) | Outcome (Home/Away)
1 | W | H
2 | W | A |  |  |  |  |  |  | Key
3 | D | D |  |  |  |  |  |  | Letter | Outcome
4 | W | H |  |  |  |  |  |  | W | Win
5 | L | A |  | Longest Winning Run | Longest [NAME] |  |  |  | D | Draw
6 | D | D |  |  |  |  |  |  | L | Loss
7 | W | A |  |  |  |  |  |  | H | Home
8 | L | A |  | Longest Home Winning Run |  |  |  |  | A | Away
9 | W | H
10 | W | A
11 | W | H
12 | D | D
13 | W | H
14 | W | A
15 | W | H
16 | W | H
17
18
19
20
Spreadsheet: 168964d1342640953-complicated-matching-issues-matching-issue
Sheet: Orginal

wRVU | Chg | Provider | MRN | CPT
2.43 | 251 | Provider 1 | 1001 | 99204OB
0.97 | 110 | Provider 1 | 1001 | 99213OB
1.01 | 113 | Provider 1 | 1001 | 99214
0.97 | 110 | Provider 1 | 1001 | 99213OB
1.01 | 110 | Provider 1 | 1001 | 99214
0.97 | 110 | Provider 1 | 1001 | 99213OB
0.97 | 110 | Provider 1 | 1001 | 99213OB
0.97 | 110 | Provider 1 | 1001 | 99213OB
0.97 | 110 | Provider 1 | 1001 | 99213OB
0.97 | 110 | Provider 1 | 1001 | 99213OB
3.56 | 585 | Provider 1 | 1001 | 99698
0.97 | 110 | Provider 1 | 1001 | 99213OB
0.97 | 110 | Provider 1 | 1001 | 99213OB
0.97 | 110 | Provider 1 | 1001 | 99213OB
28.69 | 3738 | Provider 1 | 1001 | 59400
0.97 | 110 | Provider 1 | 1002 | 99213OB
0.97 | 110 | Provider 1 | 1002 | 99213OB
0.97 | 110 | Provider 1 | 1002 | 99213OB
0.97 | 110 | Provider 1 | 1002 | 99213OB
3.56 | 585 | Provider 1 | 1002 | 99698
1.01 | 113 | Provider 1 | 1002 | 99214
0.97 | 110 | Provider 1 | 1002 | 99213OB
0.97 | 110 | Provider 1 | 1002 | 99213OB
0.97 | 110 | Provider 1 | 1002 | 99213OB
0.97 | 110 | Provider 1 | 1002 | 99213OB
28.69 | 3738 | Provider 1 | 1002 | 59400
0.97 | 110 | Provider 1 | 1003 | 99213OB
1.01 | 113 | Provider 1 | 1003 | 99214
0.97 | 110 | Provider 1 | 1003 | 99213OB
0.97 | 110 | Provider 1 | 1003 | 99213OB
0.97 | 110 | Provider 1 | 1003 | 99213OB
1.01 | 113 | Provider 1 | 1003 | 99214
0.97 | 110 | Provider 1 | 1003 | 99213OB
0.97 | 110 | Provider 1 | 1003 | 99213OB
0.97 | 110 | Provider 1 | 1003 | 99213OB
0.97 | 110 | Provider 1 | 1003 | 99213OB
31.8 | 4100 | Provider 1 | 1003 | 59510
Spreadsheet: 40250d1238559815-transposing-columns-to-rows-with-pivot-table-response-site-and-cellid-transpose-with-variable-cols
Sheet: Sheet1

Site | CellID | Site
312P0011A | 50112 | 312P0011A | 2 | 8 | 6 | 50112 | 50151 | 50052 | 50153 | 51881 | 50152
312P0011A | 50151 | 312P0052A | 8 | 12 | 4 | 10411 | 51881 | 51673 | 51672
312P0011A | 50052 | 312P0122A | 12 | 16 | 4 | 50052 | 51803 | 51223 | 51222
312P0011A | 50153
312P0011A | 51881
312P0011A | 50152
312P0052A | 10411
312P0052A | 51881
312P0052A | 51673
312P0052A | 51672
312P0122A | 50052
312P0122A | 51803
312P0122A | 51223
312P0122A | 51222
 |  |  | To analyse as required:
 |  |  | Prepare list of unique values in Column C (eg use Data, Filter, Advanced)
 |  |  | Enter formula in col D and E and copy down
 |  |  | Replace last cell in column E with formula as shown
 |  |  | Enter formula in F and copy down. Use this to find the [NAME] cols required in next step (eg as in F6)
 |  |  | Enter formula in F1, copy right to the maximum needed
 |  |  | Copy this range down as required.
 |  |  | In this example columns G onwards represent the result and could be copied and pasted as values to another worksheet,
 |  |  | then saved as a csv file
Spreadsheet: 168734d1342552700-copy-across-multiple-rows-and-columns-the-data-to-one-column-removing-dupilicates-blank-15640
Sheet: Mar3-Mar9m

Main Arena
 | 2013-03-03 00:00:00 |  |  | Thru | 2013-03-09 00:00:00
 | SUN | MON | TUE | WED | THURS | FRI | SAT
 | 2013-03-03 00:00:00 | 2013-03-04 00:00:00 | 2013-03-05 00:00:00 | 2013-03-06 00:00:00 | 2013-03-07 00:00:00 | 2013-03-08 00:00:00 | 2013-03-09 00:00:00 |  |  |  | Blocks | Team | Hours
7:00AM |  |  |  |  |  |  |  | 7:00AM |  |  | 0 | 05 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 04 Flags | 0
[NAME] |  |  |  |  |  |  |  | [NAME] |  |  | 0 | 03 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 02 Flags | 0
[NAME] |  |  |  |  |  |  |  | [NAME] |  |  | 0 | 01 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 00 Flags | 0
10:00AM |  |  |  |  |  |  |  | 10:00AM |  |  | 0 | 99 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 98 Flags | 0
11:00AM |  |  |  |  |  |  |  | 11:00AM |  |  | 0 | Midget A | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | Midget AA | 0
12:00PM |  |  |  |  |  |  |  | 12:00PM
1:00PM |  |  |  |  |  |  |  | 1:00PM
2:00PM |  |  |  |  |  |  |  | 2:00PM
3:00PM |  |  |  |  |  |  |  | 3:00PM
4:00PM |  |  |  |  |  |  |  | 4:00PM
5:00PM |  |  |  |  |  |  |  | 5:00PM
6:00PM |  |  |  |  |  |  |  | 6:00PM
7:00PM |  |  |  |  |  |  |  | 7:00PM
8:00PM |  |  |  |  |  |  |  | 8:00PM
9:00PM |  |  |  |  |  |  |  | 9:00PM
10:00PM |  |  |  |  |  |  |  | 10:00PM
11:00PM |  |  |  |  |  |  |  | 11:00PM
 | Cancellations or Corrections
 | Date | Time | Customer | Operations Personal | Comments
Spreadsheet: 692754d1598539577-finding-the-biggest-value-in-a-custom-list-example
Sheet: Blad1

 | 6a+ | medium | 2020-04-10 00:00:00
 | 6c | large | 2020-04-11 00:00:00 |  |  |  | find biggest value:
 | 7b | large | 2020-04-12 00:00:00 |  |  |  | find biggest if large:
 | 8a | large | 2020-04-13 00:00:00 |  |  |  | find second biggest value:
 | 6b+ | medium | 2020-04-14 00:00:00 |  |  |  | find second biggest if large:
 | 7c+ | large | 2020-04-15 00:00:00 |  |  |  | find third biggest value:
 | 4a | small | 2020-04-16 00:00:00 |  |  |  | find third biggest value if large:
 | 7c | large | 2020-04-17 00:00:00
 | 8b | small | 2020-04-18 00:00:00
Spreadsheet: 208286d1358784220-changing-currency-format-from-to-or-mailmerge
Sheet: Sheet2

City | Employee | Sales
Atlanta | [NAME] | $3,000
Atlanta | Delaney | $50,000
New York | Henningsen | $10,000
New York | [NAME] | $8,000
Houston | Kelly | $9,000
Houston | Pak | $0
Spreadsheet: 132239d1323633204-extract-data-into-master-work-sheet-given-format
Sheet: MW-13

LOW FLOW SAMPLING
FIELD DATA SHEETS
 |  |  | Client:
 | Site:
 | Date: |  |  | 2011-11-16 00:00:00
 |  |  | Monitoring Well #: | MW-13 |  |  |  | Well Depth: | 9.02 |  | ft |  |  | Screened/Open Interval: | 4-9' |  | ft
 |  |  | Well Permit #: |  |  |  |  | Well Diameter: | 2 |  | inches
 | PID Readings (ppm)
 |  |  |  | Background: |  | 0 |  |  | Pump Intake Depth: |  |  | 6.5 |  |  | ft below TOC
 |  |  |  | [NAME]: |  | 0 |  |  |  |  |  |  | Depth to Water Before Pump Installation: | 0.35 |  | ft below TOC
 |  |  |  | Beneath Inner Cap: |  | 0 |  |  |  |  |  |  | [NAME] | stainless steel submersible pump
 | TIME | Purging | Sampling |  |  |  |  | Specific |  | Dissolved |  | Redox |  |  |  |  | Depth to
 |  |  |  | pH |  | Temperature |  | Conductivity |  | [NAME] |  | Potential |  | Turbidity |  | Pumping | Water
 |  |  |  | (pH units) |  | (oC) |  | (uS/cm) |  | (mg/L) |  | (mV) |  | (NTU) |  | Rate | (ft below
 |  |  |  | Reading | Change | Reading | Change | Reading | Change | Reading | Change | Reading | Change | Reading | Change | (ml/min) | TOC)
 | 850 | x |  | 6.8 | NA | 17.02 | NA | 1302 | NA | 0.73 | NA | -19.8 | NA | 24.2 | NA | 200 | 1.55
 | 855 | x |  | 6.79 |  | 17.31 |  | 1316 |  | 0.41 |  | -32.6 |  | 9.49 |  | 200 | 1.86
 | 900 | x |  | 6.79 |  | 17.44 |  | 1317 |  | 0.25 |  | -36.7 |  | 6.52 |  | 200 | 2.19
 | 905 | x |  | 6.79 |  | 17.61 |  | 1316 |  | 0.23 |  | -39.6 |  | 4.53 |  | 200 | 2.03
 | 910 | x |  | 6.8 |  | 17.63 |  | 1318 |  | 0.18 |  | -38.4 |  | 3.34 |  | 200 | 2.03
 | 915 | x |  | 6.79 |  | 17.67 |  | 1326 |  | 0.17 |  | -42.4 |  | 2.93 |  | 200 | 2.03
 | 920 | x |  | 6.79 |  | 17.7 |  | 1332 |  | 0.16 |  | -43 |  | 2.83 |  | 200 | 2.03
 | 925 | x |  | 6.79 |  | 17.75 |  | 1341 |  | 0.16 |  | -45.9 |  | 2.79 |  | 200 | 2.03
 | Comments:
 |  | Purge start: |  |  | 08:44:00 |  |  | Sample time: |  | 09:27:00
 |  | Purge end: |  |  | 09:25:00
 | *INDICATOR PARAMETERS HAVE STABILIZED WHEN 3 CONSECUTIVE READINGS ARE WITHIN: + 0.1 for pH; + 3% for Specific Conductivity and
 | Temperature; + 10 mV for Redox Potential; and + 10% for [NAME] and Turbidity
Spreadsheet: 75769d1276299766-pivot-table-calculation-book1
Sheet: Data

Question | Answer
What is your favorite color? | Blue
What is your favorite color? | Blue
What is your favorite color? | Blue
What is your favorite color? | Red
What is your favorite color? | Yellow
What is your favorite color? | Yellow
What is your favorite color? | Yellow
What is your favorite color? | Green
What is your favorite color? | Green
What is your favorite color? | Orange
What is your favorite lunch meat? | Turkey
What is your favorite lunch meat? | Turkey
What is your favorite lunch meat? | Ham
What is your favorite lunch meat? | Ham
What is your favorite lunch meat? | Ham
What is your favorite lunch meat? | Roast Beef
What is your favorite lunch meat? | Roast Beef
What is your favorite lunch meat? | Pastrami
What is your favorite lunch meat? | Pastrami
In which state were you born? | Ohio
In which state were you born? | Tennessee
In which state were you born? | Tennessee
In which state were you born? | Tennessee
In which state were you born? | Tennessee
In which state were you born? | California
Spreadsheet: 86610d1286549676-color-formating-on-random-like-values-748586
Sheet: Sheet1

Raw Data | Formatted
0C8A8%A%C8B1%E81B7E8 | 0C8A8%A%C8B1%E81B7E8
0C8A8%A%C8B1%E81B7E8 | 0C8A8%A%C8B1%E81B7E8
0X6E1X58C1%0E7&06BCE | 0X6E1X58C1%0E7&06BCE
0&%8%5E1X27BCC0A&421 | 0&%8%5E1X27BCC0A&421
14%8EA81B&%%%1X8208A | 14%8EA81B&%%%1X8208A
1%2151AB07E2X6468%&8 | 1%2151AB07E2X6468%&8
2818A07A%675A0A80A48 | 2818A07A%675A0A80A48
80627C88&CB&0A1%X2E2 | 80627C88&CB&0A1%X2E2
8821%5C%E855A%X0XA7X | 8821%5C%E855A%X0XA7X
8821%5C%E855A%X0XA7X | 8821%5C%E855A%X0XA7X
8821%5C%E855A%X0XA7X | 8821%5C%E855A%X0XA7X
8821%5C%E855A%X0XA7X | 8821%5C%E855A%X0XA7X
8821%5C%E855A%X0XA7X | 8821%5C%E855A%X0XA7X
8821%5C%E855A%X0XA7X | 8821%5C%E855A%X0XA7X
86X5E88B077&E5X6&8A2 | 86X5E88B077&E5X6&8A2
87%75C&66E&&CB5&7E&% | 87%75C&66E&&CB5&7E&%
4106&27120X85&21EEX& | 4106&27120X85&21EEX&
4&E&C4XC14147B58%28B | 4&E&C4XC14147B58%28B
5BXX10B0727572%2X67X | 5BXX10B0727572%2X67X
5BXX10B0727572%2X67X | 5BXX10B0727572%2X67X
5BXX10B0727572%2X67X | 5BXX10B0727572%2X67X
5C84B0A4A7%A7%&8605A | 5C84B0A4A7%A7%&8605A
5C84B0A4A7%A7%&8605A | 5C84B0A4A7%A7%&8605A
5C84B0A4A7%A7%&8605A | 5C84B0A4A7%A7%&8605A
5C84B0A4A7%A7%&8605A | 5C84B0A4A7%A7%&8605A
60C001BA7&%4CB0B8%5E | 60C001BA7&%4CB0B8%5E
6C2%7%8B&C0AXX86BC5A | 6C2%7%8B&C0AXX86BC5A
6C2%7%8B&C0AXX86BC5A | 6C2%7%8B&C0AXX86BC5A
6C2%7%8B&C0AXX86BC5A | 6C2%7%8B&C0AXX86BC5A
Spreadsheet: 861375d1709241027-update-vertical-price-tables-via-horizontal-price-sheet-please-see-below-data-examples-acme-test
Sheet: COL Z1

Part Number | MOQ QTY | PRICE 1 | Part Number | QTY | PRICE2 | Part Number | QTY | PRICE 3 | Part Number | QTY | PRICE 4
COL1407Z1 | 2000 | 0.4841 | COL1407Z1 | 5000 | 0.2814 | COL1407Z1 | 10000 | 0.2433 | COL1407Z1 | 25000 | 0.2195
COL1409Z1 | 2000 | 0.4841 | COL1409Z1 | 5000 | 0.2814 | COL1409Z1 | 10000 | 0.2433 | COL1409Z1 | 25000 | 0.2195
COL1411Z1 | 2000 | 0.5266 | COL1411Z1 | 5000 | 0.3435 | COL1411Z1 | 10000 | 0.3006 | COL1411Z1 | 25000 | 0.2768
COL1413Z1 | 2000 | 0.552 | COL1413Z1 | 5000 | 0.3816 | COL1413Z1 | 10000 | 0.3342 | COL1413Z1 | 25000 | 0.3102
COL1415Z1 | 2000 | 0.5681 | COL1415Z1 | 5000 | 0.3748 | COL1415Z1 | 10000 | 0.3294 | COL1415Z1 | 25000 | 0.299
COL1417Z1 | 2000 | 0.6006 | COL1417Z1 | 5000 | 0.4113 | COL1417Z1 | 10000 | 0.3691 | COL1417Z1 | 25000 | 0.3172
COL4013Z1 | 1000 | 0.9494 | COL4013Z1 | 5000 | 0.7453 | COL4013Z1 | 10000 | 0.6879 | COL4013Z1 | 25000 | 0.6441
COL4015Z1 | 1000 | 1.0064 | COL4015Z1 | 5000 | 0.8148 | COL4015Z1 | 10000 | 0.7739 | COL4015Z1 | 25000 | 0.7578
COL4017Z1 | 1000 | 1.1009 | COL4017Z1 | 5000 | 0.933 | COL4017Z1 | 10000 | 0.8797 | COL4017Z1 | 25000 | 0.8358
COL4611Z1 | 1000 | 0.8779 | COL4611Z1 | 5000 | 0.6966 | COL4611Z1 | 10000 | 0.6488 | COL4611Z1 | 25000 | 0.6201
COL4613Z1 | 1000 | 0.9656 | COL4613Z1 | 5000 | 0.8011 | COL4613Z1 | 10000 | 0.7461 | COL4613Z1 | 25000 | 0.7133
COL4615Z1 | 1000 | 0.9829 | COL4615Z1 | 5000 | 0.8301 | COL4615Z1 | 10000 | 0.8205 | COL4615Z1 | 25000 | 0.792
COL4617Z1 | 1000 | 1.2019 | COL4617Z1 | 5000 | 0.963 | COL4617Z1 | 10000 | 0.8903 | COL4617Z1 | 25000 | 0.844
COL4809Z1 | 1000 | 0.8874 | COL4809Z1 | 5000 | 0.7348 | COL4809Z1 | 10000 | 0.7014 | COL4809Z1 | 25000 | 0.6823
COL4811Z1 | 1000 | 0.9542 | COL4811Z1 | 5000 | 0.8205 | COL4811Z1 | 10000 | 0.7824 | COL4811Z1 | 25000 | 0.7728
COL4813Z1 | 1000 | 0.9781 | COL4813Z1 | 5000 | 0.8779 | COL4813Z1 | 10000 | 0.835 | COL4813Z1 | 25000 | 0.8016
COL4815Z1 | 1000 | 0.9925 | COL4815Z1 | 5000 | 0.8874 | COL4815Z1 | 10000 | 0.8493 | COL4815Z1 | 25000 | 0.8111
COL4817Z1 | 1000 | 1.2175 | COL4817Z1 | 5000 | 1.0553 | COL4817Z1 | 10000 | 0.9962 | COL4817Z1 | 25000 | 0.9486
COL5209Z1 | 1000 | 0.8969 | COL5209Z1 | 5000 | 0.7824 | COL5209Z1 | 10000 | 0.7441 | COL5209Z1 | 25000 | 0.7157
COL5211Z1 | 1000 | 1.002 | COL5211Z1 | 5000 | 0.8874 | COL5211Z1 | 10000 | 0.8493 | COL5211Z1 | 25000 | 0.8301
COL5213Z1 | 1000 | 1.0496 | COL5213Z1 | 5000 | 0.9255 | COL5213Z1 | 10000 | 0.8588 | COL5213Z1 | 25000 | 0.8396
COL5215Z1 | 1000 | 1.0496 | COL5215Z1 | 5000 | 0.9255 | COL5215Z1 | 10000 | 0.8588 | COL5215Z1 | 25000 | 0.8396
Spreadsheet: 85f79ce6-2cec-4411-b85e-8505e8ac6d58
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | APPROPRIATION TRANSACTION | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 |  | CITY  OF  KANSAS  CITY,  MISSOURI
 |  |  | DEPARTMENT:
BUSINESS UNIT: |  |  |  | KCPDU |  | DATE: |  | 2006-08-21 00:00:00 |  | JOURNAL ID:
LEDGER GROUP: |  |  |  |  | APPROP
 |  | FUND |  | DEPT ID |  | ACCOUNT |  | PROJECT |  | AMOUNT |  | INC/DEC
 |  | 2320 |  | 217003 |  | B |  | 21CONV |  | -426757 |  | D
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  | -426757
BUSINESS UNIT: |  |  |  | KCPDU |  | DATE: |  | 2006-08-21 00:00:00 |  | JOURNAL ID: |  | C
 |  |  |  |  |  |  |  |  |  |  |  | (same as above, except
LEDGER GROUP: |  |  |  |  | ADMIN |  |  | BUDGET PERIOD: |  |  |  | prefixed by a C)
 |  | FUND |  | DEPT ID |  | ACCOUNT |  | PROJECT |  | AMOUNT |  | INC/DEC
 |  | 2320 |  | 217003 |  | 611060 |  | 21CONV |  | -426757 |  | D
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  | -426757
[NAME]: |  |  |  |  |  |  |  |  |  |  |  | NET |  | 0
APPROVED BY: |  |  |  |  |  | DATE |  | APPROVED BY:  DEPARTMENT HEAD |  |  |  |  |  | DATE
Spreadsheet: 708902d1608063945-text-on-value-field-but-including-blank-spaces-dax
Sheet: Data

POS | Furniture | Reason
Point 1 | Type A | Need Upgrade
Point 2 | Type B
Point 3 | Type C
Point 4 | Type D | Need Upgrade
Point 5 | Type A | Needs Renovation
Point 6 | Type A | Buy new one
Point 7 | Type D | Buy new one
Point 8 | Type B | Needs Renovation
Point 9 | Type C | Buy new one
Point 10 | Type B | Needs Renovation
Point 11 | Type B
Spreadsheet: 764991d1643111192-formula-move-cell-to-other-cell-example
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 |  | 1 | 2 | 3 | 4 | 5
[NAME] | a
[NAME] | b
[NAME] | a
[NAME] | b
[NAME] | c
 |  |  |  |  |  | 1 | 2 | 3 | 4 | 5
 |  |  |  |  |  | [NAME] | a | b
 |  |  |  |  |  | [NAME] | a | b | c
Spreadsheet: 94229d1294090732-auto-fill-consecutive-row-after-processing-from-different-sheet-inputoutput2
Sheet: Buy

Date | Coupon | From | Type | [NAME] | Price | Weight | Box | Net | Others | Total
2010-02-20 00:00:00 | 102 | [NAME] | bowl |  | 13500 | 7520 | 2005 | 5515 | 200000 | 74652500
2010-03-26 00:00:00 | 102 | [NAME] | triangle |  | 12500 | 5620 | 2004 | 3616 |  | 45200000
2010-03-26 00:00:00 | 102 | [NAME] | oval |  | 11000 | 4320 | 2040 | 2280 |  | 25080000
2010-03-27 00:00:00 | 102 | [NAME] | broken |  | 8000 | 7111 | 2056 | 5055 |  | 40440000
2010-03-28 00:00:00 | 107 | [NAME] | bowl |  | 13400 | 3025 | 798 | 2227 |  | 29841800
2011-03-28 00:00:00 | 107 | [NAME] | triangle |  | 12400 | 5004 | 2035 | 2969 |  | 36815600
 |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | 0 |  | 0
 |  |  |  |  |  |  |  | Total Pembelian / bulan |  | 252029900