tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 680032d1590754206-complex-nested-if-issue-sample
Sheet: Sheet1

 |  |  | this is wrong | this is right
 | Values | Delta % | Formula 1 | Formula 2 | Expected Output | [NAME]
 | 85/100 |  |  |  | Below -10%
 | -85/100 |  |  |  | Below -10%
 | 85/-100 |  |  |  | Above 10%
 | -85/-100 |  |  |  | Above 10%
 | 98/100 |  |  |  | -3% to 3%
 | -98/100 |  |  |  | Below -10%
 | 98/-100 |  |  |  | Above 10%
 | -98/-100 |  |  |  | -3% to 3%
 | 102/100 |  |  |  | -3% to 3%
 | -102/100 |  |  |  | Below -10%
 | 102/-100 |  |  |  | Above 10%
 | -102/-100 |  |  |  | -3% to 3%
 | 94/100 |  |  |  | -3% to -10%
 | -94/100 |  |  |  | Below -10%
 | 94/-100 |  |  |  | Above 10%
 | -94/-100 |  |  |  | 3% to 10%
 | -137/-156 |  |  |  | Above 10%
 | 37/32 |  |  |  | Above 10%
 | -57/-59 |  |  |  | 3% to 10%
 | 9.5/6.5 |  |  |  | Above 10%
 | 81/71 |  |  |  | Above 10%
 | -20/-13 |  |  |  | Below -10%
 | -42/-40 |  |  |  | -3% to -10%
 | -13/-18 |  |  |  | Above 10%
 | -17/-28 |  |  |  | Above 10%
 | -12/-13 |  |  |  | 3% to 10%
Spreadsheet: 605761d1547251528-populate-name-vacation-date-information-into-calendar-format-in-separate-tab-leave-planner-template-v2
Sheet: July

Legend:
b | = bereavement
o | = other day off |  | o.5 | = half other day off
v | = paid vacation |  | v.5 | = half paid vacation
s | = sick day |  | s.5 | = half sick day
u | = unpaid day off |  | u.5 | = half unpaid day off
x | = present
st | = statutory holiday
 | Summary of Leave Taken This Month
Employee Name | Vacation | Sick | Unpaid | Bereavement | Statutory | Other | 2018-07-01 00:00:00 | 2018-07-02 00:00:00 | 2018-07-03 00:00:00 | 2018-07-04 00:00:00 | 2018-07-05 00:00:00 | 2018-07-06 00:00:00 | 2018-07-07 00:00:00 | 2018-07-08 00:00:00 | 2018-07-09 00:00:00 | 2018-07-10 00:00:00 | 2018-07-11 00:00:00 | 2018-07-12 00:00:00 | 2018-07-13 00:00:00 | 2018-07-14 00:00:00 | 2018-07-15 00:00:00 | 2018-07-16 00:00:00 | 2018-07-17 00:00:00 | 2018-07-18 00:00:00 | 2018-07-19 00:00:00 | 2018-07-20 00:00:00 | 2018-07-21 00:00:00 | 2018-07-22 00:00:00 | 2018-07-23 00:00:00 | 2018-07-24 00:00:00 | 2018-07-25 00:00:00 | 2018-07-26 00:00:00 | 2018-07-27 00:00:00 | 2018-07-28 00:00:00 | 2018-07-29 00:00:00 | 2018-07-30 00:00:00 | 2018-07-31 00:00:00 | # of Days Worked | # of Week Days | Days in Lieu Earned
Spreadsheet: fb61d2e8-5896-4892-9b58-f1cd6cf724cc
Sheet: Sheet1

analytica 2012 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (3 Entries):
 | 2 Analysis 2.8 Microscopes and optical image processing 2.8.7 Polarization microscopes
No. | Company | Country | City | [NAME] | Hall/Booth
1 | [NAME] | Germany | Wetzlar | 35578 | A2.205/306
2 | Olympus Deutschland GmbH Mikroskopie | Germany | Hamburg | 20097 | A2.311/410
3 | [NAME] MicroImaging GmbH | Germany | Jena | 07745 | A2.111/210
Spreadsheet: 218329d1362429142-lookup-a-value-and-display-all-data-multiple-rows-and-columns-fruits1
Sheet: Sheet2

[NAME] | Colors | Purchased | Cost per 1/1/13 | Total | Purchased | Cost per 1/2/13 | Total | Purchased | Cost per 1/2/13 | Total
[NAME] | red | 22 | 0.25 | 5.5 | 0 | 0.25 | 0 | 0 | 0.25 | 0
[NAME] | Yellow | 8 | 0.29 | 2.32 | 0 | 0.29 | 0 | 21 | 0.29 | 6.09
[NAME] | Blue | 0 | 0.36 | 0 | 21 | 0.36 | 7.56 | 6 | 0.36 | 2.16
[NAME] | [NAME] | 11 | 0.39 | 4.29 | 21 | 0.39 | 8.19 | 0 | 0.39 | 0
Spreadsheet: 1b20f179-6238-4abd-bfb8-ddaccda30879
Sheet: Sheet1

LSA Contract Lising for Network Services - Region 6
Updated 9/26/13
CONTRACT NUMBER | AWARD DATE | SERVICE AREA | VENDOR | ADDRESS | CONTACT | PHONE/EMAIL | [NAME] | PHONE/EMAIL
GS06T11BND0006 | 2011-08-02 00:00:00 | Missouri, Kansas, Iowa Nebraska | Cavalier Telephone, LLC | 2134 West Labumum Avenue | [NAME] | [PHONE] | [NAME] | [PHONE]
 |  |  |  | Richmond, VA 22327 |  | [EMAIL] |  | [EMAIL]
GS06T11BND0007 | 2011-08-02 00:00:00 | St. Robert, Waynesville, Fort Leonard Wood, [NAME], Cuba | Fidelity Communications Co., Inc. | 64 N [NAME] | [NAME] | [PHONE] | [NAME] | [PHONE]
 |  |  |  | Sullivan, MO 63080-1610 |  | [EMAIL] |  | [EMAIL]
GS06T11BND0008 | 2011-08-03 00:00:00 | Iowa | ImOn Communications, LLC | 625 1st St SE, #520 | [NAME] | [PHONE] | [NAME] | [PHONE]
 |  |  |  | Cedar Rapids, IA 52401 |  | [EMAIL] |  | [EMAIL]
GS06T11BND0009 | 2011-08-03 00:00:00 | Missouri, Kansas (KC metro area) | SureWest Kansas Operations, LLc | 14859 W 95th St | [NAME] | [PHONE] | [NAME] | [PHONE]
 |  |  |  | Lenexa, KS 66215 |  | [EMAIL] |  | [EMAIL]
GS06T11BND0010 | 2011-08-09 00:00:00 | Kansas | Cox Kansas Telecom, LLC | 901 S George Washington Blvd | [NAME] | [PHONE] | Tyrone [NAME] | [PHONE]
 |  |  |  | Wichita, KS 67211 |  | [EMAIL] |  | [EMAIL]
GS06T11BND0011 | 2011-08-09 00:00:00 | Missouri, Kansas | Level 3 Communications, LLC | 1025 [NAME] | [NAME] | [PHONE] | [NAME] | [PHONE]
 |  |  |  | Broomfield, CO 80021 |  | [EMAIL] |  | [EMAIL]
GS06T11BND0012 | 2011-08-10 00:00:00 | Iowa, Nebraska | Qwest Government Services, Inc. | 4250 N Fairfax Drive, Fifth Floor | [NAME] | [PHONE] | [NAME] | [PHONE]
 |  |  |  | Arlington, VA 22203 |  | [EMAIL] |  | [EMAIL]
GS06T11BND0013 | 2011-08-12 00:00:00 | Missouri, Kansas, Iowa, Nebraska | AT&T Global Services, Inc. | 12851 [NAME], Room 1-W-250 | [NAME] | [PHONE] | [NAME] | [PHONE]
 |  |  |  | St Louis, MO 63131-1802 |  | [EMAIL] |  | [EMAIL]
GS06T11BND0014 | 2011-08-12 00:00:00 | Iowa, Nebraska | Cox Nebraska Telecom, LLC | 11505 W Dodge Road | [NAME] | [PHONE] | [NAME] | [PHONE]
 |  |  |  | Omaha, NE 68154 |  | [EMAIL] |  | [EMAIL]
Spreadsheet: 467711d1466859925-moving-24hr-time-interval-and-accumlation-problem-copy-of-24-hour-dosage
Sheet: Sheet1

Date and Time | Dose | Last 24 hrs | [NAME] |  |  | [NAME] 24 hrs |  | 4
2016-01-01 01:00:00 | 0.375
2016-01-01 05:00:00 | 0.75
2016-01-01 09:00:00.005000 | 0.65
2016-01-01 13:00:00.010000 | 1
2016-01-01 17:00:00.015000 | 1
2016-01-01 21:00:00.020000 | 0.5
2016-01-02 01:00:00.025000
2016-01-02 05:00:00.030000
2016-01-02 09:00:00.035000
2016-01-02 13:00:00.040000
2016-01-02 17:00:00.045000
2016-01-02 21:00:00.050000
2016-01-03 01:00:00.055000
2016-01-03 05:00:00.060000
Spreadsheet: 065e5d85-58ae-4c0a-8894-fd7686908c94
Sheet: Sheet1

Table 7--U.S. feed grain imports by selected sources (1,000 metric tons) 1/, 1/14/2014 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Import and country/region |  | ---------- 2011/12 ---------- |  | ---------- 2012/13 ---------- |  | 2013/14
 |  | Mkt year | [NAME] | Mkt year | [NAME] | [NAME]
Oats | Canada | 1556.499397 | 915.013786 | 1590.304046 | 965.6811869999999 | 740.354108
 | Finland | 34.84057 | 7.837 |  |  | 38.947872
 | Sweden | 29.020381 |  | 7.875 |  | 0.000255
 | All other countries | 1.067246 | 0.463033 | 1.912764 | 1.230178 | 1.886482
 | Total 2/ | 1621.427594 | 923.313819 | 1600.09181 | 966.9113649999999 | 781.1887169999999
Malting barley | Canada | 263.660306 | 53.559822 | 342.099942 | 177.644495 | 80.174005
 | All other countries | 0.244638 | 0.236638 | 0.06603 | 0.016575
 | Total 2/ | 263.9049439999999 | 53.79646 | 342.165972 | 177.66107 | 80.174005
Other barley 3/ | Canada | 89.27383699999999 | 42.713612 | 160.983119 | 67.362893 | 66.897681
 | All other countries | 0.7575109999999999 | 0.392243 | 3.99892 | 1.17297 | 1.443166
 | Total 2/ | 90.03134800000001 | 43.10585499999999 | 164.982039 | 68.53586299999999 | 68.340847
1/ Grain only. Market year (June-May) and market year to date. 2/ Totals may not add due to rounding.
3/ Grain for purposes other than malting, such as feed and seed use. Source: U.S. Department of Commerce, Bureau of the Census, Foreign Trade Statistics.
Date run: 1/14/2014
Spreadsheet: 889486d1740322427-charts-drop-to-zero-dynamic-charting-with-zeros
Sheet: Expense Data 

Item | Primary_Expense_Type | Secondary_Expense_Type | Day | Month | Month_2 | Year | Quarter | Week | Units | Amount | Credit_Card | Notes
1 | Personal | Other | 8 |  | 1 | 2025 |  |  |  |  | Yes
2 | Automobile | Fuel | 11 |  | 1 | 2025 |  |  |  |  | Yes
3 | Food and Grocery | Restaurant | 11 |  | 1 | 2025 |  |  |  |  | Yes
4 | Personal | Fitness | 15 |  | 1 | 2025 |  |  |  |  | Yes
5 | Personal | Fitness | 15 |  | 1 | 2025 |  |  |  |  | Yes
6 | Food and Grocery | Grocery | 21 |  | 1 | 2025 |  |  |  |  | Yes
7 | Food and Grocery | Grocery | 21 |  | 1 | 2025 |  |  |  |  | Yes
8 | Food and Grocery | Restaurant | 24 |  | 1 | 2025 |  |  |  |  | Yes
9 | Personal | Cellphone | 26 |  | 1 | 2025 |  |  |  |  | Yes
10 | Personal | Haircut | 29 |  | 1 | 2025 |  |  |  |  | No
11 | Food and Grocery | Restaurant | 31 |  | 1 | 2025 |  |  |  |  | No
12 | Food and Grocery | Restaurant | 8 |  | 2 | 2025 |  |  |  |  | Yes
13 | Personal | Fitness | 15 |  | 2 | 2025 |  |  |  |  | Yes
14 | Food and Grocery | Restaurant | 17 |  | 2 | 2025 |  |  |  |  | No
15 | Food and Grocery | Restaurant | 17 |  | 2 | 2025 |  |  |  |  | Yes
Spreadsheet: 199438d1355218360-help-preventing-duplicate-entries-runorder
Sheet: Engine Run Order

Engine Run Order Based on Runtimes
Engine # | N/G Hrs. | D/G Hrs. |  |  |  | # 1 Engine Run Hours | 4
1 |  |  |  |  |  | # 2 Engine Run Hours | 0
2 |  |  |  |  |  | # 3 Engine Run Hours | 231
3 |  |  |  |  |  | # 4 Engine Run Hours | 6
4 |  |  |  |  |  | # 5 Engine Run Hours | 0
5 |  |  |  |  |  | # 6 Engine Run Hours | 240
6 |  |  |  |  |  | # 7 Engine Run Hours | 236
7 |  |  |  |  |  | # 1 Engine D/G Run Hours | 0
 |  |  |  |  |  | # 2 Engine D/G Run Hours | 0
Order # | N/G Hrs. | D/G Hrs. | N/G Engine # | D/G Engine # |  | # 3 Engine D/G Run Hours | 29
1 |  |  |  |  |  | # 4 Engine D/G Run Hours | 1
2 |  |  |  |  |  | # 5 Engine D/G Run Hours | 0
3 |  |  |  |  |  | # 6 Engine D/G Run Hours | 37
4 |  |  |  |  |  | # 7 Engine D/G Run Hours | 41
5
6
7
Spreadsheet: 771439d1646672189-periodic-table-excel-template-not-working-many-formulas-display-unknown-periodic-table-excel
Sheet: Practice

 | Show your understanding
 | Practice on some basic periodic table and chemical questions.
 | Element questions
 | Which elements have the following symbols? |  |  |  | Name 3 elements in the D block.
 | H |  |  |  | 1
 | Ni |  |  |  | 2
 | Rn |  |  |  | 3
 | Which elements have the following atomic numbers? |  |  |  | Name 3 elements that are commonly found in humans.
 | 13 |  |  |  | 1
 | 79 |  |  |  | 2
 | 90 |  |  |  | 3
 | Chemical questions
 | Name the chemicals based on the structure diagram and calculate their molar mass.
 |  | #[NAME]! |  |  |  | #[NAME]!
 | Name |  |  |  | Name
 | Molar mass |  |  |  | Molar mass
Spreadsheet: 768278d1644914618-solved-if-a-specific-cell-contains-a-name-count-a-range-of-cells-0-sumproduct-not-x-aligw
Sheet: Sheet1

 |  |  |  | m3       Monday | m3       Tuesday | m3 Wednesday | m3     Thursday | m3            Friday | m3      Saturday | m3         Sunday |  |  | Total entrays | AliGW
 | [NAME] |  |  | 2.5 | 3.5 | 1.5 | X | X | X | X |  | [NAME] | 10
 | [NAME] |  |  | X | X | X | 3 | 1 | X | X |  | [NAME] | 23
 |  |  |  | X | X | X | X | X | X | X
 |  |  |  | X | X | X | X | X | X | X
 |  |  |  | X | X | X | X | X | X | X
 |  |  |  | X | X | X | X | X | X | X
 |  |  |  | X | X | X | X | X | X | X
 |  |  |  | X | X | X | X | X | X | X
 |  |  |  | X | X | X | X | X | X | X
 |  |  |  | X | X | X | X | X | X | X
 |  |  |  | 1.5 | 2.5 | 3 | X | X | X | X
 |  |  |  | X | X | x | x | x | x | x
 | [NAME] |  |  | 2.5 | 1.5 | 2 | 2.5 | 3 | 5 | X
 |  |  |  | X | X | X | X | X | X | X
 |  |  |  | X | X | X | X | X | X | X
 | [NAME] |  |  | 3.5 | X | X | 3.5 | X | X | X
 |  |  |  | X | X | X | X | X | X | X
 |  |  |  | X | X | X | X | X | X | X
 | [NAME] |  |  | 4 | X | X | X | X | X | X
 | [NAME] |  |  | X | X | 2.5 | X | X | X | X
 | [NAME] |  |  | 1.8 | 4 | 4 | 2 | 2 | 3 | X
 |  |  |  | X | X | X | X | X | X | X
 | [NAME] |  |  | 1 | 4 | X | X | X | X | X
 |  |  |  | X | X | X | X | X | X | X
 | [NAME] |  |  | X | 3 | 4 | 3 | 2.5 | X | X
 | [NAME] |  |  | X | X | X | 4 | 1 | 2 | X
 | [NAME] |  |  | X | 2.5 | 2.5 | X | X | X | X
 |  |  |  | X | X | X | X | X | X | X
 | [NAME] |  |  | X | X | X | X | 2 | X | X
 |  |  |  | X | X | X | X | X | X | X
 |  |  |  | X | X | X | X | X | X | X
 |  |  |  | X | X | X | X | X | X | X
 |  |  |  | X | X | X | X | X | X | X
Spreadsheet: 181888d1348181487-4-linear-interpolations-i-think-pressure-tables
Sheet: Sheet1

 | CO2 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 98 | 98 | 98 | 98 | 98 | 98 | 98 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 98 | 98 | 98 | 98 | 98 | 98 | 98
 | Total Depth | 4925 | 4925 | 4925 | 4925 | 4925 | 4925 | 4925 | 4925 | 4925 | 4925 | 4925 | 4925 | 4925 | 4925 | 4975 | 4975 | 4975 | 4975 | 4975 | 4975 | 4975 | 4975 | 4975 | 4975 | 4975 | 4975 | 4975 | 4975
 | Tavg | 70 | 75 | 80 | 85 | 90 | 95 | 100 | 70 | 75 | 80 | 85 | 90 | 95 | 100 | 70 | 75 | 80 | 85 | 90 | 95 | 100 | 70 | 75 | 80 | 85 | 90 | 95 | 100
Psurf | 1800 | 3672 | 3635 | 3595 | 3553 | 3509 | 3461 | 3409 | 3647 | 3614 | 3578 | 3542 | 3503 | 3461 | 3417 | 3691 | 3653 | 3613 | 3571 | 3527 | 3479 | 3426 | 3666 | 3632 | 3596 | 3560 | 3521 | 3479 | 3434
Psurf | 1850 | 3729 | 3692 | 3654 | 3612 | 3569 | 3522 | 3471 | 3703 | 3670 | 3634 | 3598 | 3559 | 3518 | 3474 | 3747 | 3710 | 3672 | 3630 | 3587 | 3540 | 3489 | 3721 | 3688 | 3652 | 3616 | 3577 | 3536 | 3492
Psurf | 1900 | 3786 | 3750 | 3712 | 3671 | 3629 | 3583 | 3533 | 3759 | 3727 | 3691 | 3656 | 3618 | 3577 | 3534 | 3804 | 3768 | 3730 | 3689 | 3647 | 3601 | 3551 | 3777 | 3745 | 3709 | 3674 | 3636 | 3595 | 3552
Psurf | 1950 | 3843 | 3807 | 3771 | 3731 | 3690 | 3645 | 3596 | 3815 | 3783 | 3748 | 3713 | 3675 | 3635 | 3594 | 3861 | 3825 | 3789 | 3749 | 3708 | 3663 | 3614 | 3833 | 3801 | 3766 | 3731 | 3693 | 3653 | 3612
Psurf | 2000 | 3899 | 3865 | 3828 | 3788 | 3748 | 3705 | 3658 | 3871 | 3840 | 3805 | 3771 | 3734 | 3695 | 3655 | 3917 | 3883 | 3846 | 3806 | 3766 | 3723 | 3676 | 3889 | 3858 | 3823 | 3789 | 3752 | 3713 | 3673
Psurf | 2050 | 3955 | 3921 | 3886 | 3847 | 3807 | 3765 | 3720 | 3927 | 3896 | 3862 | 3828 | 3792 | 3754 | 3715 | 3973 | 3939 | 3904 | 3865 | 3825 | 3783 | 3738 | 3945 | 3914 | 3880 | 3846 | 3810 | 3772 | 3733
Psurf | 2100 | 4011 | 3978 | 3943 | 3905 | 3866 | 3825 | 3782 | 3982 | 3952 | 3919 | 3886 | 3850 | 3813 | 3775 | 4029 | 3996 | 3961 | 3923 | 3884 | 3843 | 3800 | 4000 | 3970 | 3937 | 3904 | 3868 | 3831 | 3793
Psurf | 2150 | 4067 | 4035 | 4001 | 3964 | 3926 | 3887 | 3845 | 4038 | 4009 | 3976 | 3944 | 3909 | 3873 | 3836 | 4085 | 4053 | 4019 | 3982 | 3944 | 3905 | 3863 | 4056 | 4027 | 3994 | 3962 | 3927 | 3891 | 3854
Psurf | 2200 | 4123 | 4091 | 4058 | 4022 | 3985 | 3947 | 3907 | 4093 | 4064 | 4032 | 4000 | 3966 | 3931 | 3895 | 4141 | 4109 | 4076 | 4040 | 4003 | 3965 | 3925 | 4111 | 4082 | 4050 | 4018 | 3984 | 3949 | 3913
Psurf | 2250 | 4179 | 4147 | 4115 | 4080 | 4044 | 4007 | 3979 | 4147 | 4119 | 4088 | 4057 | 4024 | 3990 | 3955 | 4197 | 4165 | 4133 | 4098 | 4062 | 4025 | 3997 | 4165 | 4137 | 4106 | 4075 | 4042 | 4008 | 3973
Psurf | 2300 | 4234 | 4203 | 4171 | 4137 | 4102 | 4066 | 4029 | 4203 | 4175 | 4145 | 4115 | 4083 | 4051 | 4017 | 4254 | 4221 | 4189 | 4155 | 4120 | 4084 | 4046 | 4222 | 4193 | 4163 | 4133 | 4101 | 4069 | 4035
 | 1850 | Psurf
 | 100 | CO2
 | 4925 | Total Depth
 | 75 | Tavg
 |  | Result
Spreadsheet: 840902d1693145503-trying-to-conditionally-format-columns-based-on-dynamic-cell-values-whole-school-compass-export-template-aligw
Sheet: Data Input

Name | Year Level | Class | Semester | Reading | Writing | Speaking  and Listening | M+G | N+A | S+P | EAL S+L | EAL Reading | EAL Writing | PE | Music | Art
 | 3 |  | 1 | 4
 | 1 |  | 1 | 1
 | 1 |  | 1 | 0.5
 | 1 |  | 1 | 1.5
 | 4 |  | 1 | 2
 | 3 |  | 1 | 2
 | F |  | 1 | F
 | 2 |  | 2 | 3
Spreadsheet: 78c70bf3-a265-43b8-a59f-6c3e10b189bf
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
 | 8731.0 Building Approvals, Australia
 | TABLE 35. Value of Building Approved - Tasmania
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Total value of building jobs ;  Tasmania ;  [NAME] ;  New ; |  |  | Original | A420335T | 1970-07-01 00:00:00 | 2013-10-01 00:00:00 | 520 | $'000 | FLOW | Month | 1
Total value of building jobs ;  Tasmania ;  [NAME] ;  Alterations and additions including conversions ; |  |  | Original | A420344V | 1973-07-01 00:00:00 | 2013-10-01 00:00:00 | 484 | $'000 | FLOW | Month | 1
Total value of building jobs ;  Tasmania ;  [NAME] ;  Total Work ; |  |  | Original | A420356C | 1973-07-01 00:00:00 | 2013-10-01 00:00:00 | 484 | $'000 | FLOW | Month | 1
Total value of building jobs ;  Tasmania ;  [NAME]-residential ;  Total Work ; |  |  | Original | A421038R | 1970-07-01 00:00:00 | 2013-10-01 00:00:00 | 520 | $'000 | FLOW | Month | 1
Total value of building jobs ;  Tasmania ;  Total (Type of Building) ;  Total Work ; |  |  | Original | A422668A | 1973-07-01 00:00:00 | 2013-10-01 00:00:00 | 484 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2013
Spreadsheet: 26095d1217986185-purging-and-relocating-old-data-fields-by-changing-the-date-auto_date
Sheet: Data

2008-08-01 00:00:00 | xxx
2008-07-31 00:00:00 | xxx
2008-07-30 00:00:00 | xxx
2008-07-29 00:00:00 | xxx
2008-07-28 00:00:00 | xxx
2008-07-27 00:00:00 | xxx
2008-07-26 00:00:00 | xxx
2008-07-25 00:00:00 | xxx
2008-07-24 00:00:00 | xxx
2008-07-23 00:00:00 | xxx
Spreadsheet: 94970d1294700636-transpose-contacts-outlooktoexcel
Sheet: Sheet1

 |  | Name | Address | Suite | City,St,zip | City | State | Zip | [NAME] | [NAME] | Fax
 | Name 1 | Name 1 | Address 1 | Suite 1 | City, ST 10001 | City | ST | 10001 | [EMAIL] | (123) 456-7890 | [PHONE]
 | Address 1
 | Suite 1
 | City, ST 10001
 | [EMAIL]  [NAME]: (123) 456-7890
 | Fax:  [PHONE]
 | Name 2 | Name 2 | Address 2 | City, ST 20002 | [EMAIL] Tel: (234) 567-8901 | #N/A | 56 | -8901 | Fax: | [PHONE] | [EMAIL] [NAME]: (345) 678-9012
 | Address 2
 | City, ST 20002
 | [EMAIL] Tel: (234) 567-8901
 | Fax:  [PHONE]
 | Name 3 | Name 3 | Position 3 | Address 3 | Suite 3 | #N/A | Su | ite 3 | City, | #N/A | #N/A
 | Position 3
 | Address 3
 | Suite 3
 | City, ST 30003
 | [EMAIL] [NAME]: (345) 678-9012
 | Fax: (345) 678-9012
Spreadsheet: 697808d1601551922-how-to-display-qty-given-from-store-with-excessive-stock-sample2
Sheet: Sheet1

 |  |  |  | Stock |  |  |  |  |  | Weekly Sales |  |  |  |  |  | Store Rank |  |  |  |  |  | Qty to Fulfill |  |  |  |  |  |  | In stock rate |  |  |  |  |  | FULFILLMENT |  |  |  |  |  |  | STOCK TO BE |  |  |  |  |  | notification
Article | Sold date | Color | WH Stock | 1 | 2 | 3 | 4 | 5 |  | 1 | 2 | 3 | 4 | 5 |  | 1 | 2 | 3 | 4 | 5 |  | 1 | 2 | 3 | 4 | 5 | EXCESS |  | 1 | 2 | 3 | 4 | 5 |  | 1 | 2 | 3 | 4 | 5 | TOTAL QTY |  | 1 | 2 | 3 | 4 | 5
ABC | 2020-06-02 00:00:00 | X | 100 | 2 | 20 | 2 | 0 | 2 |  | 1 | 5 | 4 | 3 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] qty
ABC | 2020-06-02 00:00:00 | Y | 5 | 0 | 1 | 2 | 2 | 0 |  | 0 | 2 | 2 | 3 | 1
ABC | 2020-06-02 00:00:00 | Z | 0 | 0 | 0 | 3 | 0 | 2 |  | 0 | 0 | 0 | 1 | 2
ABC | 2020-06-02 00:00:00 | X |  |  | 13 | 15 | 2 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ambil dari store rank terakhir untuk dikonsol ke store dengan rank teratas
ABC | 2020-06-02 00:00:00 | Y |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sold date <=2 minggu
ABC | 2020-06-02 00:00:00 | Z
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | positive (+) : qty needed to be fulfilled |  |  |  |  |  |  |  |  |  |  |  |  | display the qty needed to be given from the lowest rank store with excessive stock to the top stores which need the stock
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | minus (-) : excessive stock, need to allocate to store which needs (based on store rank)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 3 | 4 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 3 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stock
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank
Spreadsheet: 0ace2b21-0531-4d2e-899d-a4123a24f49c
Sheet: Sheet1

Name | 2014-02-19 00:00:00
Aponte, Juan
Bettis, Sharda
Bubb, [NAME]
[NAME], Aida
[NAME], [NAME]
Mauschbaugh, [NAME]
Mauschbaugh, Zach
McReynolsd, Blake
Wilson, [NAME] (replacement^)
Pippin, Tyler
Porter, [NAME]
Rhodes, [NAME]
[NAME], [NAME]
Walker, Kandace
[NAME], [NAME]
Dobbs, [NAME]
Hilkey, Julia
[NAME], Ava
[NAME], [NAME]
Ebelhar, [NAME]
[NAME], Grant
Hobbs, [NAME]
Horton, [NAME]
Isbell, [NAME]
[NAME], [NAME]
[NAME], [NAME]
Price, [NAME]
Survant, [NAME]
[NAME], Samantha
Stoll, Memory (replacement^)
[NAME], Samantha
Benson, [NAME]
[NAME], [NAME]
Bloodworth, Alexandra
Bourne, [NAME] | x
Bowles, Christian
Brennan, Rebecca
Brooks, Kaitlyn | x
Buskey, Emily
[NAME], Katheryn (replacement^) | x
Coughlin, [NAME]
Haner, [NAME] (replacement^)
Dunaway, [NAME]
[NAME], [NAME]
Easterling, [NAME]
Futrell, [NAME]
[NAME], [NAME]
[NAME], [NAME] | x
Haner, [NAME]
Hartley, Kayla
Hooks, [NAME]
Johnston, [NAME]
King, [NAME]
Koechner, [NAME]
MacAllister, Shannon | x
Madewell, [NAME]
Mathis, [NAME] | x
[NAME], [NAME]
Mitchem, Shannon (Replacement^)
Pille, Sara (replacement^)
McNichols, Nathan | x
Mills, Tommy
[NAME] (Replacement^)
Murphy, Sean
Myers, [NAME]
Nucklolls, [NAME]
Oldham, Tyler | x
Payne, Nathan
[NAME], Tiffany
Plunkett, [NAME]
Powers, Lindsey | x
Reed, [NAME]
[NAME], Ashely | x
Scaturro, Chelsea
Schloss, [NAME] | x
Shaughnessy, [NAME]
Smith, [NAME]
Straney, [NAME]
Tanksley, Brandon
[NAME], [NAME]
White, Sierra | x
Morgan, [NAME]