tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 803867d1667755417-unique-count-of-number-of-weeks-worked-per-month-excel-problem-number-of-shows-in-a-month-365-aligw
Sheet: Sheet1

 | Job | Show | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | Job 1 | A | 2 | 3 | 4 | 1 | 2 | 3 | 0 | 0 | 0 | 0 | 0 | 0
 | Job 2 | A | 0 | 0 | 0 | 1 | 2 | 4 | 1 | 2 | 3 | 4 | 1 | 0
 | Job 1 | B | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | Job 2 | B | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 2 | 2 | 0 | 0 | 0
 | Job 1 | C | 1 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Job 2 | C | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total Shows |  | 2 | 2 | 2 | 3 | 3 | 2 | 2 | 2 | 2 | 1 | 1 | 0
 | MS365
Spreadsheet: 0700e193-8b5a-47b1-b86b-b766ca8adaef
Sheet: HSCharter

 | High
 |  | Alcohol | Tobacco | Other Drugs | Distribution | Assaults | [NAME] | Handgun | Rifle | Other Firearm | Other Weapon | Totals
 | Charter
 | AMES | 1 |  | 2 |  |  |  |  |  |  | 2
 | City Academy | 1
 | [NAME]--North
 | [NAME] | 3 |  |  |  |  |  |  |  |  | 3
 | Tuachahn High for the Performing Arts |  | 2 | 1 |  |  |  |  |  |  | 1
 | Fast Forward High |  |  | 16
 | East Hollywood High |  |  | 2 | 1 | 1
 | Davinci Academy |  |  |  |  | 3
 | City Academy |  |  |  |  |  |  |  |  |  | 1
 | Uintah River High |  |  |  |  |  |  |  |  |  | 1
 | Charter Total
 | Grand Total
Spreadsheet: 0aff6d69-e6f4-4cd5-bb4f-dd41387b8af0
Sheet: Consolidated Results

Lockheed [NAME]
Consolidated Statements of Earnings1
(unaudited; in millions, except per share data)
 |  | Quarters Ended |  |  |  | Six Months Ended
 |  | June 30, 2013 |  | June 24, 2012 |  | June 30, 2013 |  | June 24, 2012
Net sales |  | 11408 |  | 11921 |  | 22478 |  | 23214
Cost of sales |  | -10184 |  | -10749 |  | -20213 |  | -21033
Gross profit |  | 1224 |  | 1172 |  | 2265 |  | 2181
Other income, net |  | 74 |  | 20 |  | 152 |  | 55
Operating profit |  | 1298 |  | 1192 |  | 2417 |  | 2236
Interest expense |  | -88 |  | -96 |  | -180 |  | -192
Other non-operating income (expense), net |  | 1 |  | 21 |  | -1 |  | 24
Earnings before income taxes |  | 1211 |  | 1117 |  | 2236 |  | 2068
Income tax expense |  | -352 |  | -336 |  | -616 |  | -619
Net earnings |  | 859 |  | 781 |  | 1620 |  | 1449
Effective tax rate |  | 29.1 | % | 30.1 | % | 27.5 | % | 29.9 | %
Earnings per common share
Basic |  | 2.68 |  | 2.41 |  | 5.04 |  | 4.47
Diluted |  | 2.64 |  | 2.38 |  | 4.97 |  | 4.41
Weighted average shares outstanding
Basic |  | 320.8 |  | 324.5 |  | 321.2 |  | 324.3
Diluted |  | 325.9 |  | 328.8 |  | 326.1 |  | 328.7
Common shares reported in stockholders' equity at end of period |  |  |  |  |  | 319 |  | 322.2
1 The Corporation closes its books and records on the last Sunday of the calendar quarter to align its financial closing with its business processes, which was on June 30
for the second quarter of 2013 and June 24 for the second quarter of 2012. The consolidated financial statements and tables of financial information included herein
are labeled based on that convention. This practice only affects interim periods, as the Corporation's fiscal year ends on Dec. 31.
Spreadsheet: da970261-a937-4f95-85e1-38a91c5e0f2e
Sheet: Sheet1

Unnamed: 0 | Transfer speed - about  20 minutes for each 100megs. | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
Description | username |  | Company | password | folder | folder http safe | servername | server domain | Internal Server share
DATAROOM | user1 |  |  | password1 | folder | folder | mail | domain.internet | \\server.domain.local\sharename | Login to the ftp server mail.domain.internet with the username user1 and password password1 and open the folder folder | ftp://user1:[EMAIL]/folder | Inside the office you can access this area by going to \\server.domain.local\sharename
Spreadsheet: 59998d1260527182-sending-data-from-input-sheet-to-other-sheets-in-a-workbook-poss-new-budget-planner
Sheet: TV Licence

TV Licence
Month | Year | Paymet
January | 2008
February | 2008
March | 2008
April | 2008
May | 2008
June | 2008
July | 2008
August | 2008
September | 2008
October | 2008
November | 2008
December | 2008
January | 2009
February | 2009
March | 2009
April | 2009 | 11.95
May | 2009 | 11.95
June | 2009 | 11.95
July | 2009 | 11.95
August | 2009 | 11.95
September | 2009 | 11.95
October | 2009
November | 2009
December | 2009
January | 2010
February | 2010
March | 2010
April | 2010
May | 2010
June | 2010
July | 2010
August | 2010
September | 2010
October | 2010
November | 2010
December | 2010
Spreadsheet: 86ad5ec8-035f-47ad-962c-6075194d0639
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
PBNP | Test | PBNP | NT-Pro B-Type Natriuretic Peptide (BNP), Serum | NT-Pro BNP, S | Electrochemiluminescence Immunoassay | EDTA (lavender-top) tube: EDTA |  |  | 0.5 | mL | Collection Container/Tube:  Preferred: Serum gel Acceptable: Red top Submission Container/Tube: Plastic vial [NAME]: 0.5 mL Additional Information: Patient's age and sex are required. Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.3 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | Males < or =45 years: 10-51 pg/mL 46 years: 10-53 pg/mL 47 years: 10-55 pg/mL 48 years: 10-56 pg/mL 49 years: 10-58 pg/mL  50 years: 10-59 pg/mL 51 years: 10-61 pg/mL 52 years: 10-62 pg/mL 53 years: 10-64 pg/mL 54 years: 10-67 pg/mL 55 years: 10-68 pg/mL 56 years: 10-70 pg/mL 57 years: 10-71 pg/mL 58 years: 10-73 pg/mL 59 years: 10-76 pg/mL 60 years: 10-77 pg/mL 61 years: 10-79 pg/mL 62 years: 10-82 pg/mL 63 years: 10-83 pg/mL 64 years: 10-85 pg/mL 65 years: 10-88 pg/mL 66 years: 10-89 pg/mL 67 years: 10-92 pg/mL 68 years: 10-95 pg/mL 69 years: 10-97 pg/mL 70 years: 10-100 pg/mL 71 years: 10-103 pg/mL 72 years: 10-104 pg/mL 73 years: 10-107 pg/mL 74 years: 10-110 pg/mL 75 years: 10-113 pg/mL 76 years: 10-116 pg/mL 77 years: 10-119 pg/mL 78 years: 10-122 pg/mL 79 years: 10-125 pg/mL 80 years: 10-128 pg/mL 81 years: 10-131 pg/mL 82 years: 10-135 pg/mL > or =83 years: 10-138 pg/mL Females < or =46 years: 10-140 pg/mL 47 years: 10-141 pg/mL 48 years: 10-144 pg/mL 49 years: 10-146 pg/mL 50 years: 10-149 pg/mL 51 years: 10-150 pg/mL 52 years: 10-152 pg/mL 53 years: 10-155 pg/mL 54 years: 10-157 pg/mL 55 years: 10-160 pg/mL 56 years: 10-162 pg/mL 57 years: 10-166 pg/mL 58 years: 10-168 pg/mL 59 years: 10-171 pg/mL 60 years: 10-173 pg/mL 61 years: 10-177 pg/mL 62 years: 10-179 pg/mL 63 years: 10-183 pg/mL 64 years: 10-185 pg/mL 65 years: 10-189 pg/mL 66 years: 10-193 pg/mL 67 years: 10-196 pg/mL 68 years: 10-199 pg/mL 69 years: 10-202 pg/mL 70 years: 10-206 pg/mL 71 years: 10-210 pg/mL 72 years: 10-214 pg/mL 73 years: 10-218 pg/mL 74 years: 10-222 pg/mL 75 years: 10-227 pg/mL 76 years: 10-230 pg/mL 77 years: 10-235 pg/mL 78 years: 10-239 pg/mL 79 years: 10-244 pg/mL 80 years: 10-248 pg/mL 81 years: 10-253 pg/mL 82 years: 10-258 pg/mL > or =83 years: 10-263 pg/mL | Monday through Sunday; Continuously | Same day/1 day | 1 day | 1 | 83880 |  |  |  |  | Rochester
PBNP | [NAME] | SERUM | Serum |  |  |  | Frozen | 365 days
PBNP | Result | PBNP | NT-Pro BNP, S | NT-Pro BNP, S | Numeric |  |  |  |  | pg/mL |  |  |  |  |  |  |  |  |  | 33762-6
Spreadsheet: 708072d1607608577-simplifying-a-very-old-worksheet-bourn
Sheet: Jones

hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | INDEX 1 | INDEX 2 | INDEX 3 | points | handicap | handicap | HANDICAPPING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 703679d1605111324-excel-formula-book2
Sheet: Sheet1

 | 0 | 0.1 | 0.2 | 0.3 | 0.4
40 | 0.79 | 0.8 | 0.81 | 0.82 | 0.83
41 | 0.8 | 0.81 | 0.82 | 0.83 | 0.84
42 | 0.81 | 0.82 | 0.83 | 0.84 | 0.85 |  | so for 40.3 answer should be 0.82
43 | 0.82 | 0.83 | 0.84 | 0.85 | 0.86 |  | Which formula I should use?
44 | 0.83 | 0.84 | 0.85 | 0.86 | 0.87
45 | 0.84 | 0.85 | 0.86 | 0.87 | 0.88
46 | 0.85 | 0.86 | 0.87 | 0.88 | 0.89
47 | 0.86 | 0.87 | 0.88 | 0.89 | 0.9
48 | 0.87 | 0.88 | 0.89 | 0.9 | 0.91
49 | 0.88 | 0.89 | 0.9 | 0.91 | 0.92
50 | 0.89 | 0.9 | 0.91 | 0.92 | 0.93
Spreadsheet: 728295d1618403034-unable-to-convert-text-to-numeric-after-trying-multiple-methods-excel-forum-example
Sheet: Sheet1

 |  |  | Original Data
 |  |  | Component Number | Variance (£) | Variance (Qty) | Formatted
 |  |  | 296198359 | -15490.89358088235 | -1261
 |  |  | 296198359 | -14780.96635154062 | -2770
 |  |  | 296198359 | -4001.059101168086 | -3988
 |  |  | 296198359 | -3689.752401583462 | -4031
 |  |  | 296198359 | -3185.379850746268 | -115
 |  |  | 296198359 | -2866.954238898585 | -4049
 |  |  | 296198359 | -2606.729042995839 | -562
 |  |  | 296139561AC | -2209.319652413793 | -3373
 |  |  | 296139561AC | -1356.3 | -1980
 |  |  | 296139561AC | -1326.683826530612 | -362
 |  |  | 296139561AC | -1288.783546325878 | -550
 |  |  | 296139561AC | -1055.771926006529 | -1202
 |  |  | 296139561AC | -868.8399999999998 | -203
 |  |  | 296139561AC | -845.4186516853932 | -1118
 |  |  | 296139561AC | -775.8148769007964 | -5393
 |  |  | Aim to Summaise Data in this Format
 |  |  | Component Number | Variance (£) Total | Variance (Qty) Total
 |  |  | 296198359 | -46621 | -16776
 |  |  | 296139561AC | -9726 | -14181
Spreadsheet: 804589d1668175512-i-need-to-get-the-order-of-the-unique-values-sorted-by-the-date-ignoring-the-duplicates-sort-data
Sheet: Sheet1

 |  | CODE | PROGRAM | ACTIVITY | START DATE | PROG #
 |  | AHMED | FOOTBALL | PASSING | 2022-01-01 00:00:00 | AHMED:1
 |  | AHMED | FOOTBALL | SHOOTING | 2022-01-02 00:00:00
 |  | AHMED | BASKETBALL | PASSING | 2022-01-03 00:00:00 | AHMED:2
 |  | [NAME] | BASKETBALL | RULES | 2022-01-04 00:00:00 | JOHN:3
 |  | [NAME] | BASKETBALL | FOULS | 2022-01-05 00:00:00
 |  | [NAME] | FOOTBALL | SHOOTING | 2021-11-01 00:00:00 | JOHN:1
 |  | [NAME] | GOLF | RULES | 2021-11-02 00:00:00 | JOHN:3
 |  | EXPECTED RESULTS
 |  | I need to know the order of the program for each code sorted by the start date as it appears in column F
Spreadsheet: 216800d1361892391-filter-through-multiple-tabs-to-show-in-new-tab-wawf-gfebs-invoices-fy13-plan-b
Sheet: W912LP-13-P-0009

CONTRACT # | PO # | CAGE CODE | PAYMENT NUMBER | LINE ITEM # | LINE ITEM QUANTITY | WAWF INV # | DATE INV SUBMITTED | DATE INV RECEIVED | DOC DATE | AMOUNT | OUR STATUS | GFEBS # | 103 | 103 DATE | 105 | 105 DATE | DOV  # (Disbursing #) | DOV DATE | INTEREST  ? | TRACE #
W912LP-13-P-0009 | 4504500742 | 543M1 | 1P | 1 | 254 | 92 | 2012-11-13 00:00:00 | 2012-11-13 00:00:00 |  | 3510.4 | PAID | 5100182553 | 5000474236 | 2012-11-20 00:00:00 | 5000490756 | 2012-12-05 00:00:00 | 2500038160 | 2012-12-08 00:00:00 | 0 | 41036009100459
W912LP-13-P-0009 | 4504500742 | 543M1 |  | 2 | 160 |  |  |  |  |  | PAID
W912LP-13-P-0009 |  |  |  |  |  |  |  |  | TOTAL
RETURN
Spreadsheet: 879535d1727106354-problem-in-auto-generating-12-mths-of-eomonth-ft00-eomonth-spill-365-aligw
Sheet: Interest

 |  |  |  |  |  |  | From A4:A5, I wish to get the Yellow colour
 |  |  |  |  |  |  | Why my formula do not work? B4 and C4.
 |  |  |  | What I want
2019-04-01 00:00:00 |  |  |  | 2019-04-30 00:00:00
2020-04-01 00:00:00 | 2019-05-31 00:00:00 |  |  |  |  | 2019-05-31 00:00:00
 | 2019-06-30 00:00:00 |  |  |  |  | 2019-06-30 00:00:00
 | 2019-07-31 00:00:00 |  |  |  |  | 2019-07-31 00:00:00
 | 2019-08-31 00:00:00 |  |  |  |  | 2019-08-31 00:00:00
 | 2019-09-30 00:00:00 |  |  |  |  | 2019-09-30 00:00:00
 | 2019-10-31 00:00:00 |  |  |  |  | 2019-10-31 00:00:00
 | 2019-11-30 00:00:00 |  |  |  |  | 2019-11-30 00:00:00
 | 2019-12-31 00:00:00 |  |  |  |  | 2019-12-31 00:00:00
 | 2020-01-31 00:00:00 |  |  |  |  | 2020-01-31 00:00:00
 | 2020-02-29 00:00:00 |  |  |  |  | 2020-02-29 00:00:00
 | 2020-03-31 00:00:00 |  |  |  |  | 2020-03-31 00:00:00
 | 2020-04-30 00:00:00
 | 2020-05-31 00:00:00
 | 2020-06-30 00:00:00
 | 2020-07-31 00:00:00
 | 2020-08-31 00:00:00
 | 2020-09-30 00:00:00
 | 2020-10-31 00:00:00
 | 2020-11-30 00:00:00
 | 2020-12-31 00:00:00
 | 2021-01-31 00:00:00
 | 2021-02-28 00:00:00
 | 2021-03-31 00:00:00
Spreadsheet: 113086d1309028547-attempting-to-create-a-formula-code-to-have-excel-automatically-move-a-column-over-scratchers-20form_after-1-
Sheet: Sales

LOTTERY SALES
BOX | PREVIOUS DAY | TODAY | # [NAME] | $ [NAME]
1 |  |  |  |  | 1
2 |  |  |  |  | 1
3 |  |  |  |  | 1
4 |  |  |  |  | 1
5 |  |  |  |  | 2
6 |  |  |  |  | 2
7 |  |  |  |  | 2
8 |  |  |  |  | 2
9 |  |  |  |  | 3
10 |  |  |  |  | 3
11 |  |  |  |  | 3
12 |  |  |  |  | 3
13 |  |  |  |  | 5
14 |  |  |  |  | 5
15 |  |  |  |  | 5
16 |  |  |  |  | 5
 |  | Scratcher Sales = |  | 0
 |  | Lottery Sales = |  | 340
 |  | Actual Sales = |  | 340
Closing Date | 2011-06-24 00:00:00 | Report Sales = |  | 450
 |  | Over/Short = |  | 110
Spreadsheet: 81d09999-3736-4e6d-abaf-f7bfccbfb6f3
Sheet: A-V Mapping

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CHECK (Assets not associated with a Vuln)
A1. Actors’ digital presence not including social or professional reputation |  | 1 | 1 | 1 | 1 | 1 |  | 1 |  | 1 | 1 | 1 |  | 1 |  | 1 |  | 1 | 1 |  |  |  | 1 | 1 | 1 |  |  | 1
A2. Social reputation | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 |  | 1 | 1 | 1 |  |  | 1 | 1 |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
A3. Professional reputation | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 |  | 1 | 1 | 1 |  |  | 1 | 1 |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
A4. Sentiments |  |  | 1 |  |  |  |  |  |  | 1 |  |  |  |  | 1 |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1
A5. Ideas |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 1 | 1 | 1
A6. Life-logging services | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 |  | 1 |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  | 1 | 1 | 1 | 1 | 1 |  | 1
A7. Social networking services | 1 | 1 | 1 |  |  | 1 | 1 | 1 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  | 1 | 1 |  | 1 | 1 | 1 | 1
A8. Smart home objects / appliances | 1 | 1 | 1 |  | 1 |  |  | 1 | 1 |  | 1 |  | 1 |  |  | 1 |  |  |  | 1 | 1 |  |  |  | 1
A9. Laptops and PC computers | 1 |  | 1 |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  | 1 |  |  | 1 |  | 1 |  |  |  | 1
A10. Smart phone / mobile phone / life-logging devices | 1 | 1 | 1 |  | 1 |  |  | 1 |  |  |  | 1 |  | 1 |  |  |  | 1 | 1 | 1 | 1 | 1 |  |  | 1
A11. e-cars and e-bikes | 1 | 1
A12. Home security system | 1 | 1 | 1 |  |  |  |  | 1 |  |  |  |  | 1
A13. Energy management system | 1 | 1 |  |  |  |  |  | 1 |  |  |  |  | 1
A14. External recognition / monitoring system |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
A15. Databases of aggregated data | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | 1 |  |  | 1 |  |  | 1 |  |  |  |  |  | 1 | 1 |  |  |  |  | 1
A16. Data mining pack / software |  | 1 |  |  |  | 1 |  |  |  |  |  |  | 1 | 1 | 1 |  |  |  |  |  |  |  | 1 |  | 1 |  | 1 | 1
A17. Recommendation systems | 1 | 1 | 1 |  |  | 1 |  |  |  |  |  |  |  | 1 |  |  | 1 |  | 1 |  |  |  |  |  | 1 |  |  | 1
A18. Bio-sensors / Personal health devices, Small sensor patches, health data [user end]
CHECK (Vulns with no asset associated)
Spreadsheet: 002e2bef-706d-47e8-a862-7ba935d37922
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
 | 5671.0 Lending Finance, Australia
 | TABLE 5. PERSONAL FINANCE COMMITMENTS, Revolving Credit Stocks and Flows: Australia, Original ($000)
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
New and increased credit limits - Secured ; |  |  | Original | A2413482A | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
New and increased credit limits - Unsecured ; |  |  | Original | A2413483C | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
New and increased credit limits - Total ; |  |  | Original | A2413484F | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Cancellations and reductions ; |  |  | Original | A2413485J | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Total credit limits at end of month ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Credit used at end of month ; |  |  | Original | A2413487L | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: ca8231ec-0107-4761-835c-303f2762669d
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
44032624 | 2014-11-15 15:26:24 | ALLIES | 0 | 3 | 4 | 1661455 | player1661455 | 6149 | western | 1944-08-07 | 1944-08-11 | Counter-attack on Mortain | Contre-attaque de Mortain
Spreadsheet: 550049d1512069380-conditional-formatting-help-please-copy-of-excel-help-sheet-paullyb-
Sheet: FLEXIBILITY

 |  |  |  | QUAL 1 | QUAL 2 | QUAL 3 | QUAL 4 |  |  |  | QUAL 1 | QUAL 2 | QUAL 3 | QUAL 4 |  |  |  | QUAL 1 | QUAL 2 | QUAL 3 | QUAL 4
POSITION |  | OCT |  |  |  |  |  |  | DEC |  |  |  |  |  |  | FEB
MANAGER
SERVER
BUSBOY
DISHWASHER
Spreadsheet: 143348d1330374058-return-column-occurrences-from-a-source-tab-to-a-calendar-tab-w-several-rows-copy-of-template
Sheet: Mar-12

2012-03-01 00:00:00
SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY
 |  |  |  | 1900-01-01 00:00:00 | 1900-01-02 00:00:00 | 1900-01-03 00:00:00
1900-01-04 00:00:00 | 1900-01-05 00:00:00 | 1900-01-06 00:00:00 | 1900-01-07 00:00:00 | 1900-01-08 00:00:00 | 1900-01-09 00:00:00 | 1900-01-10 00:00:00
1900-01-11 00:00:00 | 1900-01-12 00:00:00 | 1900-01-13 00:00:00 | 1900-01-14 00:00:00 | 1900-01-15 00:00:00 | 1900-01-16 00:00:00 | 1900-01-17 00:00:00
1900-01-18 00:00:00 | 1900-01-19 00:00:00 | 1900-01-20 00:00:00 | 1900-01-21 00:00:00 | 1900-01-22 00:00:00 | 1900-01-23 00:00:00 | 1900-01-24 00:00:00
1900-01-25 00:00:00 | 1900-01-26 00:00:00 | 1900-01-27 00:00:00 | 1900-01-28 00:00:00 | 1900-01-29 00:00:00 | 1900-01-30 00:00:00 | 1900-01-31 00:00:00
 |  | NOTES:
Spreadsheet: 765722d1643548181-how-to-average-sales-data-based-on-a-matching-date-bh-performance-tracker-january-copy-22
Sheet: Sales Board

 |  |  |  | Sales Consultant |  |  | Target | Pace | Writes Deliveries | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | NEW | USED | Lease % | F.O
 | 1 |  |  |  |  |  | 20
 | 2 |  |  |  |  |  | 20
 | 3 |  |  |  |  |  | 20
 | 4 |  |  |  |  |  | 20
 | 5 |  |  |  |  |  | 20
 | 6 |  |  |  |  |  | 20
 | 7 |  |  |  |  |  | 20
 | 8 |  |  |  |  |  | 10
 | 9 |  |  |  |  |  | 10
 |  | Selling Days
 |  | Selling Days Past
 |  |  |  | Flat Increase Levels
 |  |  |  | Delivery Bonuses
Spreadsheet: 792643d1661027528-need-to-flatten-many-column-ranges-into-one-row-easily-excel_forum_flatten_problem_sample
Sheet: Sheet1

Sample Data Set
[NAME] | [NAME] | [NAME]
Pancakes | Eggs | Cereal
Sandwich | Hamburger | Sandwich
Porkchops | Pasta | Chicken
How I Do NOT Want Flatten To Work |  |  |  |  | How I DO Need Flatten to Work (Across 500+ columns with ranges like A2:A5, B2:[NAME], and on and on):
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | Pancakes
[NAME] |  |  |  |  | Sandwich
Pancakes |  |  |  |  | Porkchops
Eggs |  |  |  |  | [NAME]
Cereal |  |  |  |  | Eggs
Sandwich |  |  |  |  | Hamburger
Hamburger |  |  |  |  | Pasta
Sandwich |  |  |  |  | [NAME]
Porkchops |  |  |  |  | Cereal
Pasta |  |  |  |  | Sandwich
Chicken |  |  |  |  | Chicken
Spreadsheet: 737635d1624528311-required-only-filtered-data-which-are-out-but-not-recd-back-summary-1-
Sheet: Result Sheet

 | product code | detail 1 | detail 2 | detail 3 | detial 4
5
6
9
11
Spreadsheet: michelle_lokay__26801__MastioContacts
Sheet: TW

Mastio Survey 2000
Transwestern Pipeline Company Customers
 |  | Commercial
Shipper | Type | Contact Name | Phone Number
Agave Energy | Producer | [NAME] | [PHONE]
Amoco Energy Trading Corp. | Producer/Marketer | [NAME] | [PHONE]
[NAME] | Marketer | Troy Brother | [PHONE]
Burlington Resources Trading | Producer | [NAME] | [PHONE]
Conoco, Inc | Producer/Marketer | [NAME] | [PHONE]
Duke Energy Trading and Marketing | Marketer | [NAME] | [PHONE]
El Paso Merchant Services | Marketer | [NAME] | [PHONE]
Enron North America | Marketer | [NAME] | [PHONE]
KN Energy Marketing | Marketer | [NAME] | [PHONE]
Pacific Gas & Electric Co. | Large LDC | [NAME] | [PHONE]
PG&E Energy Trading Co. | Marketer | [NAME] | [PHONE]
PNM Gas Services | Small LDC | [NAME] | [PHONE]
Red Cedar Gathering | Gatherer | [NAME] | [PHONE]
Reliant | Marketer | [NAME] | [PHONE]
Sempra | Marketer | [NAME] | [PHONE]
Southern California Gas Co. | Large LDC | [NAME] | [PHONE]
Texaco Natural Gas | Producer/Marketer | [NAME] | [PHONE]
USGT | Marketer | [NAME] | [PHONE]
Spreadsheet: 769592d1645612849-average-with-two-date-criterias-average
Sheet: Blad1

Date | Efficiency
2021-12-01 00:00:00 | 0.54
2021-12-07 00:00:00 | 0.39 |  | Calculation: Average efficiency where Year is X and month is Y
2021-12-09 00:00:00 | 0.87 |  | Should result in the below table
2022-01-01 00:00:00 | 0.87
2022-01-03 00:00:00 | 0.63 |  | RESULT
2022-02-01 00:00:00 | 0.85 |  | YEAR | Month | Effiency
2022-02-04 00:00:00 | 0.24 |  | 2021 | 12 | 0.6 | <<<----Average Efficiency where Year = D8 And Month = E8
2022-02-05 00:00:00 | 0.35 |  | 2022 | 1 | 0.75
2022-03-01 00:00:00 | 0.54 |  | 2022 | 2 | 0.48
2022-03-07 00:00:00 | 0.69 |  | 2022 | 3 | 0.62
Spreadsheet: 809381d1671050008-how-to-find-prior-result-with-same-category-and-subtract-find-previous-category-and-subtract-result
Sheet: Sheet1

 |  |  | Category | Time | difference from last matching value hrs/min
 |  |  | material | 2022-11-28 07:26:57 | 00:00:00
 |  |  | Electrical | 2022-11-30 17:46:06 | 00:00:00
 |  |  | Failure | 2022-12-01 16:30:52 | 00:00:00
 |  |  | Electrical | 2022-12-01 03:42:23
 |  |  | material | 2022-11-28 19:23:12
 |  |  | Failure | 2022-12-01 18:38:02
 |  |  | Failure | 2022-12-01 21:24:36
 |  |  | material | 2022-11-30 16:18:48