tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 723512d1615744960-conditional-formatting-according-to-criteria-cf-excelconfitional-aligw
Sheet: Sheet1

Status | Sell Price | [NAME] | Unit Cost
 |  | 0.19
Sold | 129 | 24.51 | 45.5
Sold | 99 | 18.81 | 44
Sold | 99 | 18.81 | 44 |  | IF staus show SOLD column B to D color will be Green
Sold | 129 | 24.51 | 45.5 |  | IF staus show RETURN column B to D color will be RED
Sold | 99 | 18.81 | 45
Return | 129 | 24.51 | 30
Sold | 99 | 18.81 | 44
Sold | 119 | 22.61 | 53
Sold | 99 | 18.81 | 45
Sold | 129 | 24.51 | 30
Sold | 129 | 24.51 | 52.5
Sold | 129 | 24.51 | 45.5
Return | 99 | 18.81 | 44
Sold | 99 | 18.81 | 44.75
Sold | 99 | 18.81 | 45
Sold | 129 | 24.51 | 30
Sold | 129 | 24.51 | 30
Spreadsheet: 273666d1382836318-formulas-to-consolidate-data-consolidating-worksheets-example
Sheet: CONSOLIDATED ITEMS

CHECKPOINTS | COUNTRIES | ITEMS | VALUES |  |  | ITEMS | (All)
2013-01-08 00:00:00 | B | ITEM 1 | 0.9 |  |  | COUNTRIES | (All) |  |  |  | this is how the pivot and chart should look after the consolidation
2013-01-11 00:00:00 | A | ITEM 1 | 0.13
2013-01-11 00:00:00 | B | ITEM 1 | 0.8 |  |  | Sum of VALUES
2013-01-01 00:00:00 | B | ITEM 2 | 0.33 |  |  | CHECKPOINTS | Total
2013-01-11 00:00:00 | A | ITEM 2 | 0.72 |  |  | 2013-01-01 00:00:00 | 1.62
2013-01-11 00:00:00 | B | ITEM 2 | 0.06 |  |  | 2013-01-08 00:00:00 | 1.88
2013-01-01 00:00:00 | A | ITEM 3 | 0.87 |  |  | 2013-01-11 00:00:00 | 2.19
2013-01-01 00:00:00 | B | ITEM 3 | 0.42
2013-01-08 00:00:00 | A | ITEM 3 | 0.22
2013-01-08 00:00:00 | B | ITEM 3 | 0.76
2013-01-11 00:00:00 | A | ITEM 3 | 0.09
2013-01-11 00:00:00 | B | ITEM 3 | 0.39
 | this is what
 | I need to get
 |  |  |  |  |  | Page1 | (All) |  |  |  | consolidated pivot is not good; I lose information
 |  |  |  |  |  | Count of Value | Column
 |  |  |  |  |  | Row | COUNTRIES | ITEMS | VALUES | Grand Total
 |  |  |  |  |  | 2013-01-01 00:00:00 | 3 | 3 | 3 | 9
 |  |  |  |  |  | 2013-01-08 00:00:00 | 3 | 3 | 3 | 9
 |  |  |  |  |  | 2013-01-11 00:00:00 | 6 | 6 | 6 | 18
 |  |  |  |  |  | Grand Total | 12 | 12 | 12 | 36
Spreadsheet: 8bf98206-dbd3-4e3e-85e9-fba274c781e9
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7486 | 8689 | Tomoko | Hiramatsu | JPN | 0 | 00:11:06 | 00:00:52 | 01:09:00 | 00:00:54 | 00:43:32 | 1 | 02:05:24
7486 | 57795 | Masami | [NAME] | JPN | 0 | 00:11:45 | 00:00:48 | 01:11:11 | 00:00:58 | [NAME] | 2 | 02:10:14
Spreadsheet: 854063d1704029020-choose-col-with-with-filter-choose-cols-filter-with-remove-number-from-brackets-aligw
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18
 | 1 | 75 | The  American Insurance Company Limited. (409024794) |  |  |  |  |  |  | 3 |  |  |  |  |  | 52 | 41
 |  | 3 | Tractors Service Pvt Ltd,Dysneyland (300700851) |  |  |  |  |  |  | 4 |  |  |  |  |  | 30 | 25
 | 5 | 8 | Carnivalsepal Weight Services Pvt Ltd (300494201) |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 | 7 | 9 | [NAME] ([NAME] (200010449 (Main)) |  |  |  |  |  |  | 6 |  |  |  |  |  | 45 | 40
 | x | 2
Spreadsheet: 830326d1684856929-excel-fomular_index-match-and-min-max-fomular
Sheet: Sheet7

 |  |  |  |  |  |  |  |  |  | RESULT WITH FOMULAR HERE
Month | Printer Type | Brand | Model No. | AAA | Source | BBB | Source | CCC | Source | Best Price Offering | [NAME] | Minimum Price
 |  |  |  | 4690 |  | 4390 |  | 3750 |  |  |  |  | if have price > 0 in 3 column this fomular will work
 |  |  |  | 5690 |  | 0 |  | 0 |  |  |  |  | if have min = 0 for 2 value, this formular will work
 |  |  |  | 0 |  | 7890 |  | 7790 |  |  |  |  | if have min = 0 only 1 value.it is false. i need to show CCC (7790 best price)
 |  |  |  | 0 |  | 0 |  | 0 |  |  |  |  | if have min = 0 for all column. This fomular will work
 |  |  |  | 5955 |  | 5695 |  | 5695 |  |  |  |  | if have duplicate price >2 column.formular match first column to found BBB but actual, I need to show BBB&CCC
 |  |  |  | 0 |  | 5695 |  | 5695 |  |  |  |  | if have duplicate price >2 column and found 0.formular match first column to found BBB but actual, I need to show BBB&CCC
 |  |  |  |  |  |  |  |  | if use Min function will be count 0 .please suggest the best one fomular to cover all result?
Spreadsheet: aa712efe-9b98-40fb-a390-0c7119689876
Sheet: Sheet1

[NAME]: | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
z tabuliek na šírku |  |  | Rozpočet                     na rok 2008 | 1. [NAME] 2008 | 2. [NAME] 2008 | 3. [NAME] 2008 | 4. [NAME] 2008 | [NAME]
Kapitálové príjmy: |  |  | 85000 | 39000 | 17390 | 17390 | 17300 | -90
Kapitálové výdavky: |  |  | 66430 | 40774 | 21034 | 21073 | 20998 | -75
Bilancia kapitálového rozpočtu: |  |  | 18570 | -1774 | -3644 | -3683 | -3698 | -15
Bežné príjmy: |  |  | 85563 | 86773 | 89404 | 90531 | 87394 | -3137
Bežné výdavky: |  |  | 85563 | 86773 | 89404 | 90531 | 87394 | -3137
Bilancia bežného rozpočtu: |  |  | 0 | 0 | 0 | 0 | 0 | 0
Finančné operácie príjmové: |  |  | 50 | 5300 | 5300 | 5300 | 5321 | 21
Finančné operácie výdavkové: |  |  | 3546 | 3526 | 1617 | 1617 | 1622 | 5
Bilancia finančných operácií: |  |  | -3496 | 1774 | 3683 | 3683 | 3699 | 16
Príjmy celkom: |  |  | 170613 | 131073 | 112094 | 113221 | 110015 | -3206
Výdavky celkom: |  |  | 155539 | 131073 | 112055 | 113221 | 110014 | -3207
Bilancia rozpočtu celkom: |  |  | 15074 | 0 | 39 | 0 | 1 | 1
z tabuliek na výšku |  |  | Rozpočet                     na rok 2008 | 1. [NAME] 2008 | 2. [NAME] 2008 | 3. [NAME] 2008 | 4. [NAME] 2008 | [NAME]
Kapitálové príjmy: |  |  | 85000 | 39000 | 17390 | 17390 | 17300 | -90
Kapitálové výdavky: |  |  | 66430 | 40774 | 21034 | 21073 | 20998 | -75
Bilancia kapitálového rozpočtu: |  |  | 18570 | -1774 | -3644 | -3683 | -3698 | -15
Bežné príjmy: |  |  | 85563 | 86773 | 89404 | 90531 | 87394 | -3137
Bežné výdavky: |  |  | 85563 | 86773 | 89404 | 90531 | 87394 | -3137
Bilancia bežného rozpočtu: |  |  | 0 | 0 | 0 | 0 | 0 | 0
Finančné operácie príjmové: |  |  | 50 | 5300 | 5300 | 5300 | 5321 | 21
Finančné operácie výdavkové: |  |  | 3546 | 3526 | 1617 | 1617 | 1622 | 5
Bilancia finančných operácií: |  |  | -3496 | 1774 | 3683 | 3683 | 3699 | 16
Príjmy celkom: |  |  | 170613 | 131073 | 112094 | 113221 | 110015 | -3206
Výdavky celkom: |  |  | 155539 | 131073 | 112055 | 113221 | 110014 | -3207
Bilancia rozpočtu celkom: |  |  | 15074 | 0 | 39 | 0 | 1 | 1
Spreadsheet: 545918d1509723032-formula-for-computing-frequency-of-programs-across-years-copy-of-sample_set_2-darko_giac-
Sheet: SamplePivt

 | Row Labels | Count of Program |  | Desired Result --> |  |  | Row Labels | Count of Program | In All Years |  |  |  |  |  | Year
 | ABCD | 4 |  |  |  |  | ABCD | 4 |  |  |  |  |  |  | 2010
 | 2010 | 1 |  |  |  |  | 2011 | 1 |  |  |  |  |  |  | 2011
 | 2011 | 1 |  |  |  |  | 2010 | 1 |  |  |  |  |  |  | 2012
 | 2012 | 1 |  |  |  |  | 2015 | 1 |  |  |  |  |  |  | 2013
 | 2015 | 1 |  |  |  |  | 2012 | 1 |  |  |  |  |  |  | 2014
 | ABCD.ADM | 6 |  |  |  |  | ABCD.ADM | 6 |  |  |  |  |  |  | 2015
 | 2012 | 1 |  |  |  |  | 2015 | 1 |  |  |  |  |  |  | 2016
 | 2013 | 1 |  |  |  |  | 2012 | 1 |  |  |  |  |  |  | 2017
 | 2014 | 1 |  |  |  |  | 2017 | 1
 | 2015 | 1 |  |  |  |  | 2016 | 1
 | 2016 | 1 |  |  |  |  | 2014 | 1
 | 2017 | 1 |  |  |  |  | 2013 | 1
 | ABCD.HLTH | 5 |  |  |  |  | ABCD.HLTH | 5
 | 2012 | 1 |  |  |  |  | 2015 | 1
 | 2013 | 1 |  |  |  |  | 2012 | 1
 | 2014 | 1 |  |  |  |  | 2016 | 1
 | 2015 | 1 |  |  |  |  | 2014 | 1
 | 2016 | 1 |  |  |  |  | 2013 | 1
 | IMG.DIPLOMA | 8 |  |  |  |  | IMG.DIPLOMA | 8
 | 2010 | 1 |  |  |  |  | 2011 | 1
 | 2011 | 1 |  |  |  |  | 2010 | 1
 | 2012 | 1 |  |  |  |  | 2015 | 1
 | 2013 | 1 |  |  |  |  | 2012 | 1
 | 2014 | 1 |  |  |  |  | 2017 | 1
 | 2015 | 1 |  |  |  |  | 2016 | 1
 | 2016 | 1 |  |  |  |  | 2014 | 1
 | 2017 | 1 |  |  |  |  | 2013 | 1
 | Grand Total | 23 |  |  |  |  | Grand Total | 23
Spreadsheet: 143474d1330438075-excel-2007-rows-from-multiple-sheets-into-one-exclude-those-without-values-safety-tour
Sheet: (13) 26_Press & South Elect

Date: | 1/16 & 1/17 |  | Back to Department Listing
DEPARTMENT/LOCATION: |  | 26" Mill/Press/South Electrical Shop
 |  | 0
ITEM # | ISSUES FOUND | [NAME] | STATUS | INTERIM SOLUTION
x | fall protection needed (mid and top rail) on 2nd roof level | outside oil area btwn 26 & Press | carryover
x | Open electrical panel for #5 furnace blower | panel behind #5 press furnace | carryover
ENVIRONMENT: PROPER HOUSEKEEPING, INSPECTION AND MAINTENANCE, STANDARD OPERATING PROCEDURES - Overall housekeeping good
ESCORT:
Spreadsheet: 2429692b-faa5-492e-a401-29d8ab7b2be2
Sheet: Operator switching

 | Title: | Time needed to termintate a contract \ get connected in at major fixed broadband operators |  |  |  |  |  | ,
 | Date: | January 2013
 | Full title: | Time needed to termintate a contract \ get connected in at major fixed broadband operators,  January 2013
 | Country | Time needed to terminate a contract | Time needed to get connected
 | AT | 31 | 10
 | BE | 10 | 15
 | BG | 30 | 16
 | CY | 1 | 1
 | CZ | n.a. | n.a.
 | DE | 90 | 27
 | DK | 0 | 0
 | EE | 2 | 10
 | EL | 0 | 0
 | ES | 0 | 0
 | FI | 0 | 0
 | FR | 30 | 4
 | [NAME] | 8 | 30
 | IE | 30 | 5
 | IT | 15.6139075678579 | 14.56006181464045
 | LT | 12 | 8
 | LV | 0 | 0
 | MT | 25 | 9.6
 | NL | 30 | 30
 | PL | 30 | 3
 | PT | 30 | 19
 | RO | 11.8 | 6.2
 | SE | N/A | 84
 | SI | 0 | 0
 | SK | 5 | 12
 | UK | 48 | 21
Spreadsheet: 83336d1283335540-excel-2007-hide-the-excel-ui-935a3000
Sheet: Data

Date | C25 | C46 | M25 | M45 | Total Sale
2010-08-31 00:00:00 | 9 | 59 | 19 | 6 | 36.25
2010-08-31 00:00:00 | 14 | 11 | 3 | 12 | 14.6
2010-08-31 00:00:00 | 10 | 0 | 20 | 25 | 18.75
2010-08-31 00:00:00 | 1 | 2 | 3 | 4 | 3.7
2010-08-31 00:00:00 | 17 | 83 | 32 | 153 | 118.45
31/08/2010 | 7 | 25 | 0 | 3 | 14.35
2010-09-01 00:00:00 | 15 | 4 | 4 | 1 | 7
Spreadsheet: 172706d1344304067-if-condition-and-return-a-specific-number-many-if-condition
Sheet: Sheet1

Material | U/P Original Curr. | Origin Cur | U/P Convert to RMB | Amount
A | 1.2 | HKD | 0.8192 | 0.98304
B | 0.88 | HKD |  | 0
C | 3 | USD | 6.355 | 19.065
D | 4 | EUR |  | 0
E | 2.1 | SGD | 4.82 | 10.122
F | 3.2 | SGD |  | 0
G | 3 | USD |  | 0
My Question is if the origin currency in Col C,  is USD, EUR & SGD then Col D, will auto be 6.355, 8.592, 4.82)
Spreadsheet: 790898d1660055185-need-to-to-return-id-when-there-are-2-condition-sample
Sheet: Sheet1

Name | system | ID Code |  |  |  |  | [NAME] |  |  | SAP Code
HOLLYWELLN1 | Maxi | TEC-10001-000010 |  |  |  |  | HOLLYWELLN1 |  |  | HOLLYWELLN1
MAXWELLR16 | Maxi | TEC-10002-000001 |  |  |  |  | MAXWELLR16 |  |  | MAXWELLR16
MAXWELLR17 | Maxi | TEC-10002-000002 |  |  |  |  | MAXWELLR17 |  |  | MAXWELLR17
HOLLYWELLN1 | SAP | TEC-10001-000011 |  |  |  |  | HOLLYWELLN1 |  |  | HOLLYWELLN1
MAXWELLR118 | SAP | TEC-[PHONE] |  |  |  |  | MAXWELLR118 |  |  | MAXWELLR118
MAXWELLR119 | SAP | TEC-10002-000002 |  |  |  |  | MAXWELLR119 |  |  | MAXWELLR119
Spreadsheet: 3eec3822-1c33-4dd2-8385-a2ef5861f2ae
Sheet: Sheet1

Campus | Last Name | First Name | [NAME] | Phone Number | Fax Number | Street | Street2 | City | State | Zip
Appalachian State University | Sharp | [NAME] | [EMAIL] | [PHONE] | [PHONE] | Academy Drive |  | Boone | NC | 28608
East Carolina University | Rhodes | [NAME] | [EMAIL] | [PHONE] | [PHONE] | East Fifth Street |  | Greenville | NC | 27858
Elizabeth City State University | Wade | Damon | [EMAIL] | [PHONE] | [PHONE] | 1704 Weeksville Road |  | Elizabeth City | NC | 27909
Fayetteville State University | Walker | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1200 Murchison Road |  | Fayetteville | NC | 28301
NC Agricultural and Technical State University | Jenkins | G. | [EMAIL] | [PHONE] | [PHONE] | 1601 East Market Street |  | Greensboro | NC | 27411
NC Agricultural and Technical State University | Jenkins | Scott | [EMAIL] | [PHONE] | [PHONE] | 1601 East Market Street |  | Greensboro | NC | 27411
North Carolina Central University | [NAME] | Sandra | [EMAIL] | [PHONE] | [PHONE] | 1801 Fayetteville Street |  | [NAME] | NC | 27707
NC State University | Helm | [NAME] | [EMAIL] | [PHONE] | [PHONE] |  |  | Raleigh | NC | 27695
UNC Asheville | Gravely | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1 University Heights |  | Asheville | NC | 28804
UNC-Chapel Hill | Williford | [NAME] | [EMAIL] | [PHONE] | [PHONE] |  |  | Chapel Hill | NC | 27599
UNC Charlotte | Coppola | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 9201 University City Boulevard |  | Charlotte | NC | 28223
UNC Greensboro | Carrigan | [NAME] | [EMAIL] | [PHONE] | [PHONE] | Post Office Box 26170 |  | Greensboro | NC | 27402
UNC Pembroke | Little | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 1 University Drive |  | Pembroke | NC | 28372
[NAME] | Castellino | [NAME] | [EMAIL] | [PHONE] | [PHONE] | 601 South College Road |  | [NAME] | NC | 28403
UNC School of the Arts | [NAME] | Xiaoyun | [EMAIL] | [PHONE] | [PHONE] | 1533 South Main St. |  | Winston-Salem | NC | 27127
Western Carolina University |  |  |  |  |  |  |  | Cullowhee | NC | 28723
Winston-Salem State University | Mussat-Whitlow | Becky | [EMAIL] | [PHONE] | [PHONE] | 601 [NAME], Jr. Drive |  | Winston-Salem | NC | 27110
North Carolina School of Science and Mathematics | Coltrane | Geoff | [EMAIL] | [PHONE] | [PHONE] | 1219 Broad Street |  | [NAME] | NC | 27705
Spreadsheet: michelle_lokay__26703__imball0112
Sheet: PEPL

 | Hansford
 | 8042
Day | Measured | Scheduled
1 |  | -7000
2 |  | -4786
3 | -20568 | -4786
4 | -6999 | -10000
5 | -5845 | -10000
6 | -8331 | -10000
7 | -8430 | -10000
8 | -35058 | -17270
9 | -565 | -17270
10 | -7231 | -17270
11 | -8566 | -2270
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00
2001-12-16 00:00:00
CBS Dollars
 |  |  | 151190.72
Spreadsheet: 466174d1466041998-using-drop-down-list-in-excel-2010-copy-of-recipes-1-3
Sheet: Ingredients

Ingredient | Brand | Amount | Calories | Fat | Sat. Fat | Cholesterol | Sodium | Carbs | Fiber | Sugar | Protein
[NAME] Protein(S) | Syntha-6 | 2 scoops (94g) | 400 | 12 | 4 |  | 380 | 30 | 10 | 8 | 44
Chocolate Whey Protein © | CytoSport | 1 Scoop (36g) | 130 | 1.5 | 1 | 40 | 180 | 3 | 1 | 2 | 27
Sugar Free Instant Vanilla Pudding |  | 1 tbsp | 3 |  |  |  | 40 | 1
Cinnamon (M) | [NAME] | 1/4 tsp | 1 |  |  |  |  | 0.5
Cinnamon (T) | Test | 1/4 tsp | 5 |  |  |  |  | 1
Vanilla Extract (M) | [NAME] | 1/4 tsp
Butter Flavor Extract (M) | [NAME] | 1/2 tsp
Water |  | 1 cup
Ice |  | 1 handful
Spreadsheet: 134111d1325017050-simplified-report-for-equipment-maintenance-equipment-cost-report
Sheet: 5508

AMC No. | 09-04 | EQUIPMENT COST REPORT
Unit Number | OTV 5508 |  | Start Date | 24/07/2011 |  |  |  | [NAME] |  | 999
Employee Name: |  |  | End Date | 06/08/2011 |  |  |  | Hour [NAME] |  | 9
Date | Receipt Number | Vendor | Fuel |  | [NAME] |  | Motor Oil |  | [NAME]. Cost | Total Cost | Odometer | PRINT NAME
 |  |  | Quantity | Cost | Quantity | Cost | Quantity | Cost
 |  |  |  |  |  | Hour [NAME] |  |  |  | Odometer End
Service Record
[NAME] | [NAME] | Vendor | Receipt Number
Filter Changed |  |  |  |  |  | NOTES
Oil Changed
Greased
Other
Supervisor Signature: __________________________________________
Spreadsheet: john_griffith__15629__05_07_01ON
Sheet: Sheet1

N
Commodity: | ON - NAT. GAS OPTS.
Month | STRIKE | BID | OFFER | Volatility | Future
M01-P/C | 430 | 37 | 40
N01-P/C | 440 | 63.5 | 65
Q01-P/C | 450 | 85 | 86
U01-P/C | 450 | 101 | 104
V01-P/C | 455 | 115 | 119
X01-P/C | 475 | 135 | 136.5
[NAME]-P/C | 490 | 153 | 158
F02-P/C | 500 | 169 | 172
G02-P/C | 490 | 170 | 176
H02-P/C | 470 | 159 | 161
J02-P/C | 435 | 121 | 124
K02-P/C | 430 | 110 | 120
Spreadsheet: 883688d1732320077-filtering-a-list-down-to-display-only-items-with-annual-due-dates-matching-current-month-sampleannual
Sheet: Summary

Summary
 | Monthly Expenses (UFCU)
 | Fixed Expenses |  | Monthly Payment | Due Date |  | Monthly Memberships & Fees |  | Monthly Payment | Due Date |  | Annual Memberships & Fees |  | Annual Payment | Due Date
Spreadsheet: john_arnold__15461__NFL99
Sheet: Trades

 |  |  |  |  |  |  |  |  |  |  | Brazil | Scotland | Morocco | Norway | Italy | Chile | Cameroon | Austria | France | [NAME] | Saudi Arabia | Denmark | Spain | Nigeria | Paraguay | Bulgaria | Netherlands | Belgium | Skorea | Mexico | Germany | USA | Yugoslavia | Iran | Romania | Columbia | England | Tunisia | Argentina | Japan | Jamaica | Croatia
 | # | Quantity | Team | Price | Counterparty | Location |  | Team | Premium |  | [NAME] | Scot | Moro | Norw | Ital | [NAME] | Came | Aust | Fran | Safr | Saud | Denm | Spai | Nige | Para | [NAME] | [NAME] | [NAME] | Skor | Mexi | Germ | USA | Yugo | Iran | Roma | Colu | Engl | Tuni | Arge | Japa | Jama | Croa
 | 1 | -100 | France | 4.5 | [NAME] | Gman 5/29
Spreadsheet: 59707d1260286542-sumproduct-common-errors-exceltip
Sheet: CW

Who | Wk | When | What | Hours | Comment
CW | 43 | 2009-10-19 00:00:00 | Materials - Purchase Order Processing on SAP | 8
CW | 43 | 2009-10-19 00:00:00 | Materials - PO Com | 10
CW | 43 | 2009-10-19 00:00:00 | Materials - Supplier Follow Ups (Email) | 16
CW | 43 | 2009-10-19 00:00:00 | Materials - QA IMP / QC Quar | 17
CW | 43 | 2009-10-19 00:00:00 | Materials - Expired Materials Preparation & Followups | 0.5
CW | 43 | 2009-10-19 00:00:00 | Materials - Expired Materials Meeting | 0.5
CW | 43 | 2009-10-19 00:00:00 | Materials - IMP update & Weekly deliveries meeting | 1
Spreadsheet: 803971d1667826817-extracting-data-from-excel-tables-sales-control
Sheet: Bank 2

 | Bank 2
 | Date | Nane | I.D Number | Transaction description2 | Invoice | Reference | Debit | Credits | Balance
 | 44866 |  |  | Opening Balance |  |  |  |  | 500
 | 44871 | Abi | A002 | Sales |  | 25 | 3500
 | 44872 | Bern | A005 | Purchase |  | 100 |  | 300
 | 44873 | [NAME] | A006 | Purchase |  | 101 |  | 1000
 | 44874 | ADAM | A008 | Rent |  | 102 |  | 500
 | 44874 | [NAME] | A006 | Purchase |  | 103 |  | 300
 | 44875 | [NAME] | A006 | Purchase |  | 101 |  | 1000
Spreadsheet: 875086d1721657082-how-to-divide-an-amount-over-columns-of-month-w-different-starting-dates-sample
Sheet: 1. Deliver (planning)

Name | Startmaand | Eindmaand | [NAME] waarde totaal | januari-25 | februari-25 | maart-25 | april-25 | mei-25 | juni-25 | juli-25 | augustus-25 | september-25 | oktober-25 | november-25 | december-25
ABC | 2025-01-01 00:00:00 | 2025-09-01 00:00:00 | 10000 | 1250 | 1250 | 1250 | 1250 | 1250 | 1250 | 1250 | 1250 | 0 | 0 | 0 | 0
DEF | 2025-06-01 00:00:00 | 2025-10-01 00:00:00 | 50000 | 0 | 0 | 0 | 0 | 0 | 12500 | 12500 | 12500 | 12500 | 0 | 0 | 0
GHI | 2025-04-01 00:00:00 | 2025-11-01 00:00:00 | 14000 | 0 | 0 | 0 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 0 | 0
JKL | 2024-05-01 00:00:00 | 2025-10-01 00:00:00 | 80000 | 0 | 0 | 0 | 0 | 16000 | 16000 | 16000 | 16000 | 16000 | 0 | 0 | 0
Total
Spreadsheet: 201980d1356262992-how-to-convert-date-from-indian-format-to-us-book1
Sheet: Sheet1

Date "String" | [NAME] |  | DLL |  | [NAME] |  | Ice
1.1.12 | 2012-01-01 00:00:00 |  | 1901-01-01 00:00:00 |  | 1901-01-01 00:00:00 |  | 01/01/12 | 2012-01-01 00:00:00
30.12.12 | 2012-12-30 00:00:00 |  | 1902-12-30 00:00:00 |  | 1902-12-30 00:00:00 |  | 12/30/12 | 2012-12-30 00:00:00
1.12.2012 | 2012-12-01 00:00:00 |  | 2012-12-01 00:00:00 |  | 2012-12-01 00:00:00 |  | 12/01/12 | 2012-12-01 00:00:00
01.01 | 2012-01-01 00:00:00 |  | 1901-01-01 00:00:00 |  | 1901-01-01 00:00:00 |  | 01/01/12 | 2012-01-01 00:00:00
30.12 | 2012-12-30 00:00:00 |  | 1900-12-30 00:00:00 |  | 1900-12-30 00:00:00 |  | 12/30/12 | 2012-12-30 00:00:00
1.12 | 2012-12-01 00:00:00 |  | 1901-12-01 00:00:00 |  | 1901-12-01 00:00:00 |  | 12/01/12 | 2012-12-01 00:00:00
Formatted as US Date
1.1.12 | 2012-01-01 00:00:00 |  | 1901-01-01 00:00:00 |  | 1901-01-01 00:00:00 |  | 01/01/12 | 2012-01-01 00:00:00
30.12.12 | 2012-12-30 00:00:00 |  | 1902-12-30 00:00:00 |  | 1902-12-30 00:00:00 |  | 12/30/12 | 2012-12-30 00:00:00
1.12.2012 | 2012-12-01 00:00:00 |  | 2012-12-01 00:00:00 |  | 2012-12-01 00:00:00 |  | 12/01/12 | 2012-12-01 00:00:00
01.01 | 2012-01-01 00:00:00 |  | 1901-01-01 00:00:00 |  | 1901-01-01 00:00:00 |  | 01/01/12 | 2012-01-01 00:00:00
30.12 | 2012-12-30 00:00:00 |  | 1900-12-30 00:00:00 |  | 1900-12-30 00:00:00 |  | 12/30/12 | 2012-12-30 00:00:00
1.12 | 2012-12-01 00:00:00 |  | 1901-12-01 00:00:00 |  | 1901-12-01 00:00:00 |  | 12/01/12 | 2012-12-01 00:00:00
Spreadsheet: 04cc8508-0a11-4426-acbb-f2de1d4de1e2
Sheet: Sheet1

Table 2--Soybean meal:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  | Supply |  |  |  |  | Disappearance
Year begin. | Beginning |  |  |  |  |  |  |  | Ending
Oct. 1 | stocks | Production | Imports | Total |  | Domestic | Exports | Total | stocks
 |  |  |  | 1,000 short tons
2009/10 | 234.731 | 41706.52225 | 160.004 | 42101.25725 |  | 30640.23505000001 | 11159.4682 | 41799.70325000001 | 301.554
2010/111 | 301.554 | 39251 | 178.811 | 39731.365 |  | 30277.677 | 9103.688 | 39381.365 | 350
2011/122 | 350 | 38885 | 165 | 39400 |  | 30200 | 8900 | 39100 | 300
1 Estimated.  2 Forecast.
Source: USDA, World Agricultural Outlook Board, World Agricultural Supply and Demand Estimates.
Last update: | 2012-03-13 08:08:34.220000
Spreadsheet: 854400d1704293523-sum-with-index-match-holiday_test-sheet
Sheet: TOTALS

Area | Name | A/L BOOKED (Jan to Dec) |  |  | Name Manager: 'Sheets' | In each of these month sheets there is a A/L Total value in column AH against each persons name
1 | Adam |  |  | For Adam - This appears to have worked BUT is only including the data in 'Jan' because if I remove the recorded annual leave in January, it results in zero, therefore it hasn't included data from any of the other months! | Jan
1 | [NAME] |  |  | I tried a different formula here!! | Feb
2 | [NAME] |  |  |  | Mar
2 | Debs |  |  |  | Apr
2 | Elaine |  |  |  | May
3 | [NAME] |  |  |  | Jun
3 | George |  |  |  | Jul
3 | Helen |  |  |  | Aug
5 | Ian |  |  |  | Sep
 |  |  |  |  | Oct
 |  |  |  |  | Nov
 |  |  |  |  | Dec
Spreadsheet: 787089d1657631045-sum-the-expenses-by-month-groups-of-contractors-2022-07-12-oeldere-ymmies-samplesheet
Sheet: Received invoices

Number | Name of the contractor | Date of the payment | Price | Currency | Code | month | year
1 | [NAME] | 2019-01-01 00:00:00 | 456 | USD | wgQZSnj7mG ext000 part000 backend000
2 | [NAME] | 2019-01-02 00:00:00 | 126 | USD | HJbA3ebAxb apps000 otherapp000
3 | [NAME] | 2019-05-05 00:00:00 | 897 | USD | 4kZps56gHs apps000 [NAME]
4 | Morgan Freeman | 2019-01-02 00:00:00 | 456 | USD | 7EyAAAQhQQ int000 full000 support000
5 | [NAME] | 2019-02-08 00:00:00 | 745 | USD | wgQZSnj7mG ext000 part000 backend000
6 | [NAME] | 2019-01-07 00:00:00 | 559 | USD | 7Sfsfe894ds apps000 [NAME]
7 | [NAME] | 2019-01-09 00:00:00 | 426 | USD | 4kZps56gHs apps000 [NAME]
8 | [NAME] | 2019-01-09 00:00:00 | 477 | USD
9 | Morgan Freeman | 2019-03-05 00:00:00 | 456 | USD | 7EyAAAQhQQ int000 full000 support000
10 | [NAME] | 2019-01-04 00:00:00 | 87 | USD | wgQZSnj7mG ext000 part000 backend000
11 | [NAME] | 2019-06-12 00:00:00 | 998 | USD | HJbA3ebAxb apps000 otherapp000
12 | [NAME] | 2019-01-02 00:00:00 | 4265 | USD | 4kZps56gHs apps000 [NAME]
13 | Morgan Freeman | 2019-01-02 00:00:00 | 452 | USD | 7EyAAAQhQQ int000 full000 support000
14 | [NAME] | 2019-05-02 00:00:00 | 42 | USD | wgQZSnj7mG ext000 part000 backend000
15 | [NAME] | 2019-01-02 00:00:00 | 899 | USD | wr89ssEfd45E ext000 part000 backend000
year | (Alle)
Som van Price | Kolomlabels
Rijlabels | 1 | 2 | 3 | 5 | 6 | Eindtotaal
[NAME] | 559 |  |  |  |  | 559
[NAME] | 477 |  |  |  |  | 477
[NAME] | 126 |  |  |  | 998 | 1124
Morgan Freeman | 908 |  | 456 |  |  | 1364
[NAME] | 543 | 745 |  | 42 |  | 1330
[NAME] | 899 |  |  |  |  | 899
[NAME] | 4691 |  |  | 897 |  | 5588
Eindtotaal | 8203 | 745 | 456 | 939 | 998 | 11341