tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 719389d1613655542-gratuity-mot-calculating-correctly-gratuity-calculation-gk2-
Sheet: Sheet1

Name | Smith Thompson
ID
Designation | Fleet Officer
Department | Logistics |  | Salary |  |  | Completed Years | Weeks earned
Cadre | Manager |  | Basic | 249375 |  | 5 | 5
Date of employment | 2006-12-18 00:00:00 |  | Housing | 99750 |  | 10 | 6
Date of disengagement | 2021-03-10 00:00:00 |  | Transport | 30000 |  | 14 | 8
Length of service |  |  | Others | 69834 |  | 17 | 10
Confirmation Status | Confirmed |  | Gross |  |  | 20 | 12
Mode of disengagement | Resignation
Notice period required
Notice  given? | Yes
Terminal month salary paid | No
Last anniversary leave taken | 2020-12-18 00:00:00
Leave entitlement from last anniversary leave (days)
Number of days taken
Leave balance for the previous year | 9
Number of days outstanding
Leave allowance paid? | To be prorated up to date of disengagement
Entitlements
Gratuity
[NAME] up to date of disengagement
Leave earned but not taken
Leave allowance earned but not taken
[NAME] in lieu of notice
Overtime earned but not paid
Shift allowance earned but not paid
Other entitlements |  | Specify
Total entitlement
Less:
[NAME] paid but not earned
Leave taken but not earned
Leave allowance taken but not earned
[NAME] in lieu of notice
Car loan balance
Cooperative loan balance
Unretired float
Surcharges
Others
Total deductions
Net entitlement
Spreadsheet: 751051d1633807874-petty-cash-daily-report-working-sheet
Sheet: Report 3 Oct

 | Statement for: | 1 | 2021-10-03 00:00:00 |  | Current Date | Opening Balance
 |  |  |  |  |  | Closing Balance
 |  |  |  |  | Total Todate | Cash In
 |  |  |  |  |  | Cash Out
 | DATE | TYPE | [NAME] | Invoice Ref | CASH IN | CASH OUT | BALANCE
 |  |  | Opening Balance
Spreadsheet: 136338d1326552284-autoformatting-of-cells-relating-to-weekends-and-public-holidays-sickness-calendar-draft1
Sheet: Feb 2012

FEB
2 | Month Number | 2012-02-01 00:00:00 | 2012-02-02 00:00:00 | 2012-02-03 00:00:00 | 2012-02-04 00:00:00 | 2012-02-05 00:00:00 | 2012-02-06 00:00:00 | 2012-02-07 00:00:00 | 2012-02-08 00:00:00 | 2012-02-09 00:00:00 | 2012-02-10 00:00:00 | 2012-02-11 00:00:00 | 2012-02-12 00:00:00 | 2012-02-13 00:00:00 | 2012-02-14 00:00:00 | 2012-02-15 00:00:00 | 2012-02-16 00:00:00 | 2012-02-17 00:00:00 | 2012-02-18 00:00:00 | 2012-02-19 00:00:00 | 2012-02-20 00:00:00 | 2012-02-21 00:00:00 | 2012-02-22 00:00:00 | 2012-02-23 00:00:00 | 2012-02-24 00:00:00 | 2012-02-25 00:00:00 | 2012-02-26 00:00:00 | 2012-02-27 00:00:00 | 2012-02-28 00:00:00 | 2012-02-29 00:00:00 | n/a | n/a | n/a | n/a | n/a | n/a
Spreadsheet: 1fe369c4-88c4-4ab1-a45b-65af989bf49d
Sheet: Sheet1

Forcible Sex Offenses | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Offense Type
by Type of Weapon/Force Involved, 2011
Type of Weapon/ Force Involved | Offense Type
 | Forcible Rape | Forcible Sodomy | Sexual Assault with an Object | Forcible Fondling
Firearms | 471 | 111 | 29 | 80
Firearm | 75 | 25 | 6 | 14
Automatic Firearm | 10 | 6 | 0 | 3
Handgun | 330 | 64 | 18 | 54
Automatic Handgun | 31 | 10 | 2 | 5
Rifle | 5 | 2 | 1 | 1
Automatic Rifle | 1 | 0 | 0 | 1
Shotgun | 13 | 3 | 1 | 0
Automatic Shotgun | 0 | 0 | 0 | 1
Other Firearm | 6 | 1 | 1 | 1
Automatic Other Firearm | 0 | 0 | 0 | 0
Knife/Cutting Instrument | 492 | 90 | 28 | 96
Personal Weapons | 16490 | 4229 | 2020 | 20424
All Other | 2796 | 726 | 426 | 2417
Blunt Object | 102 | 31 | 42 | 34
Motor Vehicle | 5 | 2 | 1 | 6
Poison | 4 | 0 | 0 | 1
Explosives | 0 | 0 | 0 | 1
Fire/Incendiary Device | 1 | 1 | 0 | 3
Drugs/Narcotics/Sleeping Pills | 176 | 22 | 3 | 15
Asphyxiation | 41 | 6 | 3 | 5
Other Weapon | 802 | 300 | 202 | 909
Unknown Weapons | 1665 | 364 | 175 | 1443
No Weapon/Force Involved | 7035 | 2137 | 482 | 9220
1This table does not include totals because in the table a victim can be counted more than once since he/she can be connected to up to ten offense types per incident and up to three weapons per offense type.
Note:  Type of Weapon/Force Involved data are not collected for nonforcible sex offenses.
Spreadsheet: 33644d1230127514-copying-problem-example-2-
Sheet: Sheet4

17 | 17 | 17 | 17 | 17
18 | 18 | 18 | 18 | 18
19 | 19 | 19 | 19 | 19
20 | 20 | 20 | 20 | 20
21 | 21 | 21 | 21 | 21
22 | 22 | 22 | 22 | 22
23 | 23 | 23 | 23 | 23
24 | 24 | 24 | 24 | 24
25 | 25 | 25 | 25 | 25
26 | 26 | 26 | 26 | 26
27 | 27 | 27 | 27 | 27
Spreadsheet: 50919d1250519056-adding-monthly-refresh-of-data-695963-adding-monthly-refresh-of-data
Sheet: Sheet1

Company | Date Contacted | PI Total | PO Total |  | Today's Date:
a | 2009-05-25 00:00:00 | 0 | 0 |  | 2009-08-17 00:00:00
b | 2009-06-14 00:00:00 | 54000 | 0
c | 2009-06-15 00:00:00 | 160000 | 0
d | 2009-07-14 00:00:00 | 14800 | 14800
e | 2009-08-04 00:00:00 | 500 | 500
f | 2009-08-16 00:00:00 | 0 | 0
 |  |  |  |  | Database Tracking
 |  |  |  |  | Date | Companies in Database | PI Total to Date
 |  |  |  |  | 2009-05-01 00:00:00 | 0 | 0
 |  |  |  |  | 2009-06-01 00:00:00 | 1 | 0
 |  |  |  |  | 2009-07-01 00:00:00 | 3 | 214000
 |  |  |  |  | 2009-08-01 00:00:00 | 4 | 228800
Spreadsheet: 769748d1645666627-nested-if-statement-comparing-3-different-date-fields-book1
Sheet: Sheet1

Date of contact | Date of first reply | Date of closure | Weeks case was open | Weeks open from date of first reply
2021-01-01 00:00:00 | 2021-01-15 00:00:00 | 2021-02-28 00:00:00
2021-01-15 00:00:00 | 2021-02-01 00:00:00 | 2021-06-23 00:00:00
2021-02-17 00:00:00 | 2021-02-21 00:00:00 | 2021-12-25 00:00:00
2021-03-02 00:00:00 | 2021-03-02 00:00:00 | 2021-03-02 00:00:00
2021-06-28 00:00:00 | 2021-08-05 00:00:00
2021-08-15 00:00:00
Spreadsheet: drew_fossum__8679__midam_oba
Sheet: Sheet1

 | Midamerican's Northern Natural OBA calculation for Cedar Rapids and Quad Cities
 |  |  |  |  |  |  | Imbalances |  |  |  | Applicable
 |  |  |  |  |  |  | over  the |  |  |  | Cash out Tier | Daily | Daily Valuation
 |  |  |  |  |  |  | Daily Threshold |  | [NAME] used | [NAME] | T1 <+/-20k@100% | Valuation | for Daily Imb
 |  |  |  |  |  | Daily | (not included in | Cummulative | to calculate | Gas | T2  +/-20 to 40k@90%/110% | for Monthly | above
 |  |  | Day | Nomination | Actual | Imbalance | monthly cum. | Imbalance | monthly excess | Daily | T3  >+/-40k@80%/120% | Excess | Threshold
 |  |  | 1 | 30000 | 50000 |  |  |  |  | 4
 |  |  | 2 | 25000 | 45000 |  |  |  |  | 4.1
 |  |  |  | 32000 | 49000
 |  |  |  | 28000 | 45000
 |  |  |  | 25000 | 44000
 |  |  |  | 22000 | 38000
 |  |  |  | 27000 | 41000
 | Day w/ Imb > 20,000 |  |  | 24000 | 50000
 |  |  |  | 23400 | 38000
 | Day w/ Imb > 20,000 |  |  | 22800 | 48000
 |  |  |  | 22200 | 40000
 |  |  |  | 21600 | 35000
 |  |  |  | 21000 | 36000
 |  |  |  | 20400 | 37000
 |  |  |  | 25000 | 38000
 |  |  |  | 27000 | 39000
 |  |  |  | 31000 | 50000
 | Balance Day |  |  | 34000 | 41000 |  | -6000
 |  |  |  | 29000 | 41000
 |  |  |  | 30000 | 40000
 |  |  |  | 31000 | 48000
 |  |  |  | 26000 | 41000
 |  |  |  | 25000 | 35000
 | Balance Day |  |  | 32000 | 36000 |  | -3000
 |  |  |  | 33000 | 51000
 |  |  |  | 28000 | 47000
 |  |  |  | 25000 | 44000
 | [NAME] |  |  | 28000 | 48000 |  |  |  | 10400 |  | 1.2
 |  |  |  | 32000 | 16000 |  |  |  | 0
 | [NAME] |  |  | 34000 | 52000 |  |  |  | 18000 |  | 1.2
 | [NAME] |  |  | 35000 | 54000 |  |  |  | 19000 |  | 1.2
 | MIP Price
 | Balance Days provide for 1,000 tolerance.
 | Imbalances over daily thresholds at Daily Price.
 | Imbalances over daily thresholds not in monthly threshold.
 |  |  |  |  |  |  |  | Monthly Charges |  |  |  | Total Imbalance
 |  |  |  |  |  |  |  | (not including transportation) |  | Price |  | charges
 |  |  |  |  |  |  |  | Monthly excess
 |  |  |  |  |  |  |  | Daily execess
 |  |  |  |  |  |  |  | MIP imbalance | -400000
 |  |  |  |  |  |  |  | Total Monthly Imbalance
Spreadsheet: 179819d1347382058-reverse-time-calculation-timings
Sheet: Sheet1

PRODUCT | PRODUCT 3 |  |  |  | INPUT
No. OF BATCHES | 72
 |  |  |  |  |  |  |  |  |  |  | DATA
 | PRODUCTION |  |  | FINISHING |  |  | PACKING |  |  |  |  | [NAME] (1 BATCH) | FINISHING SPAN (1 BATCH)
 | DATE | TIME |  | DATE | TIME |  | DATE | TIME |  |  | PRODUCT 1 | 0:35:00 | 00:20:00
START TIME? | ? | ? |  | ? | ? |  | 2012-09-14 00:00:00 | 08:15:00 |  |  | PRODUCT 2 | 01:00:00 | 00:45:00
 |  |  |  |  |  |  |  |  |  |  | PRODUCT 3 | 00:10:00 | 0:20:00
 |  |  |  |  |  |  |  |  |  |  | PRODUCT 4 | 01:20:00 | 03:30:00
 |  |  |  |  |  |  |  |  |  |  | PRODUCT 5 | 00:50:00 | 00:50:00
 |  | RESULTS
Spreadsheet: 187209d1350380084-mirroring-two-ranges-of-cells-so-that-either-range-could-be-edited-and-saved-in-the-other-test
Sheet: Cumulative

 |  | School Name | Average | 0 | 0.6 | 0.63 | 0.67 | 0.7 | 0.73 | 0.77 | 0.8 | 0.83 | 0.87 | 0.9 | 0.93 | 0.97
 |  |  | [NAME] | F | D- | D | [NAME] | C- | C | C+ | B- | B | [NAME] | A- | A | A+
 |  | Teachers |  |  | Assignment or Test Name |  |  |  |  | Assmt. 1 | Assmt. 2 | Assmt. 3 | Assmt. 4 | Assmt. 5 | Assmt. 6 | Assmt. 7 | Assmt. 8 | Assmt. 9 | Assmt. 10 | Assmt. 11 | Assmt. 12 | Assmt. 13 | Assmt. 14 | Assmt. 15
 |  | Cumulative |  |  |  |  |  |  |  | Assmt. 1 | Assmt. 2 | Assmt. 3 | Assmt. 4 | Assmt. 5 | Assmt. 6 | Assmt. 7 | Assmt. 8 | Assmt. 9 | Assmt. 10 | Assmt. 11 | Assmt. 12 | Assmt. 13 | Assmt. 14 | Assmt. 15
 |  | 2012 |  |  | Total Points |  |  |  |  | 4 | 4 | 4 | 50 | 8 | 4 | 50 | 100 | 50 | 100 | 4 | 4 | 100 | 100 | 4
 |  |  |  |  | AVERAGE
 | Period | Student Name | Average | [NAME] | Assessment | Lab/ICA | Midterm | Final | Project |  |  |  |  |  |  |  | Lab 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 1
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 2
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 4
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5
 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  | Class Summary
 |  | Average
 |  | Highest Score
 |  | Lowest Score
 |  | Grade Categories | % of Final Grade
 |  | Assessment | 0.2
 |  | Lab | 0.3
 |  | Midterms | 0.2
 |  | Final | 0.15
 |  | Project | 0.15
 |  | TOTAL
Spreadsheet: 729259d1618989933-average-from-different-sheets-in-workbook-2020-2021-pe-assessments-help
Sheet: Year 5

First Name | Last Name | PP | SEN | EAL | Effort | Object Control (Catching & Throwing) | Movement | Balance | Team Work | Effort | Object Control (Catching & Throwing) | Movement | Balance | Team Work
made | up | N | N | N | GDS | GDS | GDS | GDS | GDS | GDS | GDS | GDS | GDS | GDS
made | up | N | Y | N | EXS | EXS | EXS | EXS | EXS | EXS | EXS | EXS | EXS | EXS
made | up | Y | Y | N | GDS | GDS | GDS | GDS | GDS | GDS | GDS | GDS | GDS | GDS
made | up | N | N | Y | EXS | EXS | EXS | EXS | EXS | EXS | EXS | EXS | EXS | GDS
made | up | N | Y | N | GDS | GDS | GDS | GDS | GDS | GDS | GDS | GDS | GDS | GDS
made | up | Y | N | N | EXS | EXS | EXS | EXS | EXS | EXS | EXS | EXS | EXS | EXS
made | up | N | N | Y | WTS | WTS | WTS | WTS | WTS | EXS | EXS | EXS | EXS | EXS
made | up | N | N | N | GDS | GDS | GDS | GDS | GDS | GDS | GDS | GDS | GDS | GDS
made | up | N | N | N | GDS | GDS | GDS | GDS | GDS | GDS | GDS | GDS | GDS | GDS
made | up | N | Y | N | GDS | GDS | GDS | GDS | GDS | GDS | GDS | GDS | GDS | GDS
made | up | N | N | Y | WTS | WTS | WTS | WTS | WTS | EXS | EXS | EXS | EXS | EXS
made | up | Y | Y | N | GDS | GDS | GDS | GDS | GDS | GDS | GDS | GDS | GDS | GDS
made | up | Y | Y | N | GDS | GDS | GDS | GDS | GDS | GDS | GDS | GDS | GDS | GDS
made | up | N | Y | N | EXS | EXS | EXS | EXS | EXS | EXS | EXS | EXS | EXS | EXS
made | up | N | Y | N | GDS | GDS | GDS | GDS | GDS | GDS | GDS | GDS | GDS | GDS
made | up | Y | Y | N | WTS | WTS | WTS | WTS | WTS | WTS | WTS | WTS | WTS | EXS
made | up | N | Y | Y | EXS | EXS | EXS | EXS | EXS | EXS | EXS | EXS | EXS | EXS
made | up | Y | N | N | EXS | EXS | EXS | EXS | EXS | EXS | EXS | EXS | EXS | EXS
made | up | N | N | Y | GDS | GDS | GDS | GDS | GDS | GDS | GDS | GDS | GDS | GDS
made | up | N | N | Y | WTS | WTS | WTS | WTS | WTS | WTS | WTS | WTS | WTS | WTS
made | up | N | N | N | EXS | EXS | EXS | EXS | EXS | EXS | EXS | EXS | EXS | EXS
made | up | Y | Y | N | EXS | EXS | EXS | EXS | EXS | EXS | EXS | EXS | EXS | EXS
made | up | Y | N | N | EXS | EXS | EXS | EXS | EXS | EXS | EXS | EXS | EXS | EXS
made | up | N | N | Y | EXS | EXS | EXS | EXS | EXS | EXS | EXS | EXS | EXS | EXS
made | up | Y | Y | Y | WTS | WTS | WTS | WTS | WTS | WTS | WTS | WTS | WTS | WTS
made | up | Y | N | Y | WTS | WTS | WTS | WTS | WTS | WTS | WTS | WTS | WTS | WTS
Spreadsheet: 1a19823b-6c32-4224-90bb-9ee713686305
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
 | 5368.0 International Trade in Goods and Services, Australia
 | TABLE 16. PERIOD AVERAGE EXCHANGE RATES, Units of Foreign Currency per Australian Dollar
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
Euro ; |  |  | Original | A2716728L | 1978-07-01 00:00:00 | 2012-12-01 00:00:00 | 414 | $ | INDEX | Month | 1
[NAME] ; |  |  | Original | A2716729R | 1978-07-01 00:00:00 | 2012-12-01 00:00:00 | 414 | $ | INDEX | Month | 1
United States Dollar ; |  |  | Original | A2716726J | 1978-07-01 00:00:00 | 2012-12-01 00:00:00 | 414 | $ | INDEX | Month | 1
United Kingdom Pound ; |  |  | Original | A2716727K | 1978-07-01 00:00:00 | 2012-12-01 00:00:00 | 414 | $ | INDEX | Month | 1
Special Drawing Right ; |  |  | Original | A2716730X | 1978-07-01 00:00:00 | 2012-12-01 00:00:00 | 414 | $ | INDEX | Month | 1
Trade Weighted Index ; |  |  | Original | A2716731A | 1978-07-01 00:00:00 | 2012-12-01 00:00:00 | 414 | Index Numbers | INDEX | Month | 1
© Commonwealth of Australia  2013
Spreadsheet: 473994d1470566944-formula-for-top-5-values-with-countif-sample-3-prc
Sheet: Calc

Calculations |  |  |  |  |  |  |  | Charts | List of ways to Compare
 |  |  |  |  |  |  |  | Total Volume
 |  |  |  |  |  |  |  | Problem Area
Compare by |  | Option 1 |  | Option 2 |  |  |  | Problem Type
 | 1 | 1 |  |  |  |  |  | Week
 |  |  |  |  |  |  |  | Avg Daily Open Escaltions
Date
 | Total Vol |  |  | Weekday |  |  | Problem Type
Date | Vol | Midwest | Midwest | Probem Area |  |  | Problem Type
Spreadsheet: 103778d1301490321-making-a-spreadsheet-user-friendly-interfaceserver
Sheet: New Prop

home button | diary | search | rightmove | properties | rentals | sales
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes | Yes | OIRO
 |  | Address |  |  |  |  |  |  |  |  |  |  |  |  | No | No | NC | Commercial Property
 |  | Special |  |  |  |  |  |  |  |  |  |  |  |  |  |  | O/O | Fully Available
 |  | Price |  |  |  |  |  |  |  |  |  |  |  |  |  |  | To Let | Commercial Offices
 |  | Status |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SDP | Has A Tenant In
 |  | In Book? |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RFQS | Investment opportunity
 |  | On RTM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Let
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ON HOLD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SSTC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UNDER OFFER
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | UNDER REF
Spreadsheet: 711351d1609628390-transpose-x-matching-headers-x-duplicate-tables-multiple-problems-excel-problem
Sheet: Original Data

A | B | C | D | E | F | G | H | Attributes | Values | V1 | V2 | V3 | V4 | V5 | V6 | V7 | V8
1 | 11 | 111 | 2 | 22 | 222 | 3 | 33 |  |  | 333 | 4 | 44 | 444 | 5 | 55 | 555 | 6
66 | 666 | 7 | 77 | 777 | 8 | 888 | 8 |  |  | 86 | 685 | 447 | 464 | 4646 | 646 | 644 | 44
Spreadsheet: 78810d1279121222-countif-only-if-certain-criteria-are-true-example
Sheet: Sheet1

Item # | Price
882269 | 7
720439 | 20
165117 | 21
731367 | 17
592371 | 20
248775 | 19
964613 | 3
301093 | 12
497840 | 23
731367 | 5
160231 | 8
843189 | 23
248775 | 19
Spreadsheet: 09238bf4-4bd3-4803-9262-69f6e9ae66ee
Sheet: 32

player | zone | outcome | play type | action
12 | 7 | miss | set | screen outside defender PUJ
21 | 1 | make | set | bad bump ballside wing
21 | 1 | make | set | post-kick-swing
21 | 7 | miss | set | post-kick-PUJ
24 | 8 | make | set | high post flash
24 | 8 | miss | set | "swing" slipman
24 | 9 | miss | set | top penetration PUJ
34 | 4 | miss | set | post-kick
34 | 11 | make | set | post-kick-drive on bad closeout
Spreadsheet: 863012d1710583702-automatic-change-of-cell-contents-according-to-date-autmatic-change-ako
Sheet: Hárok1

 | how to set automatic change of cell content according to date? |  |  |  |  |  |  |  |  |  | 1. | 2
 |  |  |  |  |  |  |  |  |  | 2023-12-31 00:00:00 | 100 | 600
 |  |  |  |  |  |  |  |  |  | 2024-12-31 00:00:00 | 200 | 700
 |  |  | TODAY |  |  |  |  |  |  | 2025-12-31 00:00:00 | 300 | 800
 |  |  |  | 2024-12-31 00:00:00 | = L4 |  |  |  |  | 2026-12-31 00:00:00 | 400 | 900
 | e.g. | D6=*TODAY *date dynamically |  |  |  |  |  |  |  | 2027-03-27 00:00:00 | 500 | 1000
 |  | E6=final date
 |  | F6=[NAME] should remain the same only until 31.12.2024
 | then | *how to set the content in the cell to AUTOMATICALLY change on 1/1/2025: |  |  |  |  |  |  |  | 2027-12-31 00:00:00
 |  | E6=31.12.2025 |  |  |  |  |  |  |  | 2028-12-31 00:00:00
 |  | F6=L5 should remain the same until the end of 12/31/2025 |  |  |  |  |  |  |  | 2029-12-31 00:00:00
 | .... |  |  |  |  |  |  |  |  | 2030-12-31 00:00:00
 |  |  |  |  |  |  |  |  |  | 2031-12-31 00:00:00
 |  |  |  |  |  |  |  |  |  | 2032-12-31 00:00:00
 |  |  |  |  |  |  |  |  |  | 2033-12-31 00:00:00
 |  |  |  |  |  |  |  |  |  | 2034-12-31 00:00:00
Spreadsheet: 195021d1353399475-vertical-format-to-horizontal-format-example2006_2011
Sheet: Sheet1

Existing Data:
 | YEAR | January | February | March | April | May | June | July | August | September | October | November | December
[NAME] | 2006 | 274441.42 | 285180.16 | 336954.87 | 446861.76 | 347370.46 | 348019 | 433709.52 | 349257.61 | 418719.9 | 383812.5 | 395420.65 | 721791.62
[NAME] | 2007 | 341136.19 | 322280.41 | 361931 | 505983 | 416916 | 391701 | 427357 | 346657 | 399895 | 371642 | 363980 | 594235
[NAME] | 2008 | 309803 | 282803 | 348988 | 491968 | 363018 | 417501 | 480031 | 319817 | 400514 | 437380 | 329270 | 628569
[NAME] | 2009 | 275906 | 289808 | 286041 | 447414 | 360381 | 350680 | 419913 | 277991 | 360910 | 472127 | 389781 | 718537
[NAME] | 2010 | 336236 | 301193 | 309059 | 490459 | 362659 | 442001 | 517159 | 316104 | 400300 | 527423 | 457332 | 826948
[NAME] | 2011 | 370398 | 341363 | 420581 | 686352 | 463645 | 491067 | 536270 | 379644 | 516248 | 693713 | 597978 | 1175799
[NAME] | 2006 | 105678.73 | 131260.43 | 164280 | 162820 | 168245 | 148265 | 168771 | 178260 | 218385 | 152730 | 212310 | 305327
[NAME] | 2007 | 132883 | 182567 | 235610 | 223291 | 221360 | 257365 | 248921 | 253760 | 315685 | 223640 | 276524 | 376260
[NAME] | 2008 | 141260 | 204897 | 224850 | 237406 | 225380 | 311094.74 | 294645 | 364285 | 398523 | 387185 | 403685 | 616857
[NAME] | 2009 | 282810 | 290537 | 407842 | 414599.12 | 337879.82 | 296075.44 | 356069 | 415459.65 | 570161 | 658850.88 | 510985 | 764228
[NAME] | 2010 | 280908 | 366135 | 446971 | 407191 | 425728 | 396542 | 438375 | 444710.53 | 642461 | 615481 | 549597 | 680348.25
[NAME] | 2011 | 331434 | 373035 | 447823.68 | 450344.7 | 408280 | 369861 | 473574 | 552401 | 719697 | 651072 | 536173 | 698623
How I would like to reformat it:
 |  | 2006-01-01 00:00:00 | 2006-02-01 00:00:00 | 2006-03-01 00:00:00 | 2006-04-01 00:00:00 | 2006-05-01 00:00:00 | 2006-06-01 00:00:00 | 2006-07-01 00:00:00 | 2006-08-01 00:00:00 | 2006-09-01 00:00:00 | 2006-10-01 00:00:00 | 2006-11-01 00:00:00 | 2006-12-01 00:00:00 | 2007-01-01 00:00:00 | 2007-02-01 00:00:00 | 2007-03-01 00:00:00 | 2007-04-01 00:00:00 | 2007-05-01 00:00:00 | 2007-06-01 00:00:00 | >>>and so on
[NAME] |  | 274441.42 | 285180.16 | 336954.87 | 446861.76 | 347370.46 | 348019 | 433709.52 | 349257.61 | 418719.9 | 383812.5 | 395420.65 | 721791.62 | 341136.19 | 322280.41 | 361931 | 505983 | 416916 | 391701 | >>>
[NAME] |  | 105678.73 | 131260.43 | 164280 | 162820 | 168245 | 148265 | 168771 | 178260 | 218385 | 152730 | 212310 | 305327 | 132883 | 182567 | 235610 | 223291 | 221360 | 257365 | >>>
Spreadsheet: 863223d1710786616-need-formulas-to-adjust-order-and-balance-if-inventory-exceeds-threshold-need-formula-to-reduce-order-vol-and-inventory-if-inventory-more-than-threshold
Sheet: Sheet1

 |  |  |  | Inventory not utilised. |  |  |  | S/Be
 |  |  |  |  | Product 1 |  |  |  | Product 1
 |  |  |  | [NAME] | [NAME] | Lead Time |  | [NAME] | [NAME] | Lead Time
 |  |  |  | 7 | 50 | 2 |  | 7 | 50 | 2
 | W/Ending | Projected Sales Product 1 |  | Order Date | Ordered | Closing Inventory |  | Order Date | Adjusted Order using inventory. | Closing Inventory
 | 2023-01-07 00:00:00 | 9750
 |  | 8750
 |  | 7670
 |  | 4280
 |  | 3920
 |  | 8400 |  |  |  |  |  |  | 9750 | 0
 |  | 1710 |  |  |  |  |  |  | 8750 | 0
 |  | 8130 |  |  |  |  |  |  | 7700
 |  | 7800 |  |  |  |  |  |  | 4300
 |  | 9260 |  |  |  |  |  |  | 3900
 |  | 8210 |  |  |  |  |  |  | 8400
 |  | 1130 |  |  |  |  |  |  | 1750
 |  | 3210 |  |  |  |  |  |  | 8100
 |  | 3960 |  |  |  |  |  |  | 7800
 |  | 4100 |  |  |  |  |  |  | 9300
 |  | 8830 |  |  |  |  |  |  | 8200
 |  | 9110 |  |  |  |  |  |  | 1100
 |  | 4990 |  |  |  |  |  |  | 3250
 |  | 4200 |  |  |  |  |  |  | 3950
 |  | 8580 |  |  |  |  |  |  | 4050
 |  | 7950 |  |  |  |  |  |  | 8850
 |  | 1710 |  |  |  |  |  |  | 9150
 |  | 8250 |  |  |  |  |  |  | 4950
 |  | 1570 |  |  |  |  |  |  | 4200
 |  | 5380 |  |  |  |  |  |  | 8600
 |  |  |  |  |  |  |  |  | 7900
 |  |  |  |  |  |  |  |  | 1750
 |  |  |  |  |  |  |  |  | 8200
 |  |  |  |  |  |  |  |  | 1600
 |  |  |  |  |  |  |  |  | 5400
Spreadsheet: 546971d1510271057-fill-summary-sheet-from-multiple-tabs-with-different-names-workers-comp-tracking-sheet
Sheet: DAWSON, Aaron

NAME | [NAME] |  | INJURY | Back Strain, Stitches to head |  | CAPACITY | Unfit |  | PIAWE
 |  |  |  |  |  | Medical Certificate |  |  |  |  |  |  | Event Details | 2017-11-07 00:00:00
PHONE | [PHONE] |  | DATE OF INJURY | 2017-11-07 00:00:00 |  | NEXT REVIEW | 2017-11-15 00:00:00 |  | ROSTER | ROSTER |  |  | First Medical Certificate | 2017-11-07 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | Notifcation Made to Insurer | 2017-11-10 00:00:00
[NAME] | [EMAIL] |  | SITE | CAR |  | COC EXPIRY | 2017-11-15 00:00:00 |  | FINAL |  |  |  | Employee Claim Form Lodged | 2017-11-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | Employer Claim Form Lodged | 2017-11-10 00:00:00
INSURER | RTWSA |  | CASE MANAGER |  |  | REHAB PROVIDER |  |  | DOCTOR |  |  |  | Liability Accepted
 |  |  |  |  |  |  |  |  |  |  |  |  | Final Medical Certificate
 |  |  |  |  |  |  |  |  |  |  |  |  | Closed
Date | UPDATES
2017-11-10 00:00:00 | Certified Unfit, no one attended appointment with him. [NAME] will be questioning the TD today why unfit when he is now on a break for 14 days