tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kevin_ruscitti__20269__market briefs
Sheet: Sheet1

Market Brief | Friday, June 1
Stocks | Close | Change | % Change
DJIA | 10990.41 | 78.46999999999935 | 0.007191205230233977
DJ 15 Util. | 389.52 | -3.700000000000045 | -0.009409490870250866
NASDAQ | 2149.44 | 38.94000000000005 | 0.01845060412224594
S&P 500 | 1260.67 | 4.850000000000136 | 0.003862018442133536
Market Vols | Close | Change | % Change
AMEX (000) | 113097 | -5692 | -0.04791689466196365
NASDAQ (000) | 1551011 | -267581 | -0.1471363560380778
NYSE (000) | 1010261 | -138481 | -0.1205501322316064
Commodities | Close | Change | % Change
Crude Oil (Jul) | 27.93 | -0.4400000000000013 | -0.01550934085301379
Heating Oil (Jul) | 0.7592 | -0.02029999999999998 | -0.02604233483001922
Nat. Gas (Henry) | 3.93 | 0.01600000000000001 | 0.004087889626980075
Palo Verde (Jul) | 300 | 10 | 0.03448275862068965
COB (Jul) | 270 | 10 | 0.03846153846153846
PJM (Jul) | 83 | 0 | 0
Dollar US $ | Close | Change | % Change
Australia $ | 1.964 | -0.01200000000000001 | -0.006072874493927131
Canada $ | 1.533 | -0.005000000000000115 | -0.003250975292587851
Germany Dmark | 2.305 | -0.005999999999999783 | -0.002596278667243524
Euro | 0.8462 | -0.000200000000000089 | -0.0002362948960303509
Japan ¥en | 119 | -0.2999999999999972 | -0.002514668901927889
Mexico NP | 9.15 | -0.01999999999999957 | -0.002181025081788394
[NAME] | 0.7045 | -0.0009000000000000119 | -0.001275871845761287
Foreign Indices | Close | Change | % Change
Arg MerVal | 435.8 | -3.420000000000016 | -0.007786530668002403
[NAME]. | 3327.3 | 10.10000000000036 | 0.003044736524780045
[NAME] | 14791.97 | 141.99 | 0.009692163402270842
Can TSE 300 | 8250.94 | 89.04000000000087 | 0.01090922456780907
Germany DAX | 6125.17 | 1.909999999999854 | 0.0003119253469556828
[NAME] | 13141.38 | -33.03000000000065 | -0.002507133146759563
Japan Nikkei 225 | 13261.84 | -0.2999999999992724 | -2.262078367437476e-05
[NAME] | 6619.66 | 24.26999999999953 | 0.003679843041882212
UK FTSE 100 | 5809.6 | 13.5 | 0.002329152361070375
Source:  Yahoo! & TradingDay.com
Spreadsheet: 728243d1618389220-need-to-incorporate-team-players-name-based-on-down-wise-from-one-sheet-to-next-sheet-trail-2021
Sheet: Playing Team

Team | Down | Players Name
CSK | 1
CSK | 2
CSK | 3
CSK | 4
CSK | 5
CSK | 6
MI | 1
MI | 2
MI | 3
MI | 4
MI | 5
MI | 6
Spreadsheet: 860166d1708368110-customer-ranking-by-cost-in-pivot-tables-ascending-order-pivot-table
Sheet: Pivot Table

Month | April
Row Labels | Count of Cost | Rank |  |  | Rank
[NAME] | 9 | 1 |  |  | 1
Lucas | 10 | 2 |  |  | 2
Olivia | 21 | 3 |  |  | 3
Emma | 25 | 4 |  |  | 4
[NAME] | 25 | 5 |  |  | 4
Grand Total | 90
Spreadsheet: john_griffith__15989__Forwards Detail_AIG (Kam)
Sheet: Results

 |  |  |  |  |  |  |  |  | Totals
 |  | Phy/ |  |  | Monthly | PV | Discount | Mid | Fixed |  | Mid
Counterparty | Deal Num | Fin | Pub Code | Period | Quantity | Quantity | Factor | Price | Price | Cash | Value
AIGENETRA | VH5504.6 | F | NX1 | 2001-12-01 00:00:00 | -1000000 | -999418.6258 | 0.999418625837052 | 2.847 | 4.52 | 0 | 1672027.361
AIGENETRA | VH5504.7 | F | NX1 | 2002-02-01 00:00:00 | 1000000 | 995806.2276 | 0.995806227613588 | 3.068 | 4.4425 | 0 | -1368735.6599
Spreadsheet: 757251d1638155093-searching-multiple-fields-using-match-with-offset-and-index-functions-book-room-database
Sheet: Search Books

 | Search for Level |  | Search for Genre |  | Search for Text Structure |  | Search for Text Features
 | B |  | Fable
 | Suggested Titles/Location |  | Suggested Titles/Location |  | Suggested Titles/Location |  | Suggested Titles/Location
Spreadsheet: louise_kitchen__23935__AugYTD Orig w notes
Sheet: Orig Chart Data

Team |  |  | Amount
Asset Marketing |  |  | 3000000
Canada Origination
Canada Origination-Ontario |  |  | 500000
Derivatives |  |  | 19222797.63525001
East Origination - Gas
Energy Capital Resources |  |  | 531956
Ercot Orig |  |  | 2391468
Gas Assets |  |  | 9493951.91
Gas Assets - Enron Compressor Services |  |  | 1518750
Mexico Origination |  |  | 2527362.84
Canada Origination-Gas
Central Origination-Gas
Texas Origination-Gas |  |  | 53628.75
West Origination-Gas |  |  | 40559092.16
Midwest Orig Total |  |  | 4881497
NE Origination Total |  |  | 9484619
SE Origination Total |  |  | 8052600
Storage Total |  |  | 125000
West Power Origination
Grand Total
Spreadsheet: 138258d1327589385-pls-help-to-get-o-p-in-another-sheet-depot1
Sheet: REQUIRED OUTPUTSUM-DEC-11

REQUIRED OUTPUT
DO Date | Qty | Qty1
2011-12-01 00:00:00 | 27 | 78
2011-12-02 00:00:00 | 609 | 153
2011-12-03 00:00:00 | 84 | 0
2011-12-04 00:00:00 | 0 | 0
2011-12-05 00:00:00 | 0 | 59
2011-12-06 00:00:00 | 459 | 53
2011-12-07 00:00:00 | 110 | 121
2011-12-08 00:00:00 | 441 | 102
2011-12-09 00:00:00 | 189.5 | 49
2011-12-10 00:00:00 | 723 | 83
2011-12-11 00:00:00 | 0 | 0
Spreadsheet: louise_kitchen__23083__Commercial Headcount for NEWCO
Sheet: Power-West

WEST POWER
Axford | Kathy | [NAME]
[NAME] | Jessica | [NAME]
Butler | Emily | [NAME]
Chatterton | [NAME] | [NAME]
Gustafson | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
Hall | Erin | [NAME]
Hrach | April | [NAME]
Mehrer | Anna | [NAME]
Rodriguez | Grace | [NAME] | 10
Heizenrader | [NAME] | Fundies | *
[NAME] | [NAME] | Fundies | *
[NAME] | Kourtney | Fundies | *
[NAME] | Julie | Fundies | *
Van Houten | Maria | Fundies | *
Swain | [NAME] | Fundies | *
Oh | [NAME] | Fundies | *
Stokley | [NAME] | Keepers
Furrow | Dale | Keepers | 2
[NAME] | Jake | Orig
McDonald | [NAME] | Orig
Shields | [NAME] | Orig
Etringer | [NAME] | Orig
Choi | [NAME] | Orig
Rosman | [NAME] | Orig
Buerkle | [NAME] | Orig
Lackey | [NAME] | Orig
Malowney | [NAME] | Orig
Woodland | [NAME] | Orig
[NAME] | [NAME] | Orig
Wente | [NAME] | Orig
Thome | [NAME] | Orig | 13
[NAME] | [NAME] | Real Time
[NAME] | [NAME] | Real Time
Merriss | [NAME] | Real Time
Slinger | [NAME] | Real Time
[NAME] | [NAME] | Real Time
Guzman | Mark | Real Time
Linder | [NAME] | Real Time
Meyers | [NAME] | Real Time
Presto | Darin | Real Time
[NAME] | Geir | Real Time
Mier | [NAME] | Real Time | 11
Rawson | Les | Services
Cocke | [NAME] | Services
[NAME] | [NAME] | Services | 3
[NAME] | Todd | Structuring
[NAME] | [NAME] | Structuring
Elafandi | Mo | Structuring
[NAME] | [NAME] | Structuring
[NAME] | Gray | Structuring
Stokley | [NAME] | Structuring
Badeer | [NAME] | Trading
Motley | [NAME] | Trading
Driscoll | [NAME] | Trading
Swerzbin | [NAME] | Trading
Belden | [NAME] | Trading
Crandall | Sean | Trading
Scholtes | [NAME] | Trading
Mallory | [NAME] | Trading
Fischer | Mark | Trading
Salisbury | Holden | Trading
[NAME] | [NAME] | Trading
Richter | [NAME] | Trading | 12
 |  | Total
Spreadsheet: 138247d1327585127-find-and-delete-text-values-from-a-list-boom3-sample-book2
Sheet: Sheet1

Last | First | Occupation | Address
Braunneis | [NAME] | clk. | 46 and 48 Royal
Berton | Germain |  | 46 Bagatelle
Anglade | Mac |  | 46 Barrack
[NAME] | [NAME] | carpenter | 46 Clouet
[NAME] | widow | f.w.c. | 46 Craps
Bouligny | [NAME] |  | 46 Dauphine
Bouligny | G. | flour inspector | 46 Dauphine
[NAME] | [NAME] |  | 46 [NAME]
Bailly | N. | f.m.c. | 46 Greatmen
[NAME] | [NAME] | painter | 46 Spain
[NAME] | [NAME] | drayman | 46 Spain
[NAME] | [NAME] |  | 46 Tchoupitoulas
[NAME] | [NAME] |  | 46 Tchoupitoulas
Afflect | [NAME] | clk. | 47 Bienville
Brewster | J. | hats | 47 Common
Boyle, H. & Co. |  | com. mer. | 47 Customhouse                      d.    54 Rampart
Becker & Stouff | acher | New York, c.h. | 47 Font Levee
Bouvrand | Mrs. | laundress | 47 Spain
Bugere | [NAME] |  | 47 Union, t. my.
[NAME] | [NAME] |  | 47 Victory
Bendecks | Hans | pilot | 48 Annette
Bioren | [NAME] |  | 48 Apollo
[NAME] | [NAME] |  | 48 Camp
Buehring | F. |  | 48 Enghien
Beauchene | F. | drayman | 48 Greatmen
Bertel & Moreno |  | grocers | 49 & 50 Treme Mkt.                  &    274 Orleans
Boise | [NAME] | f.m.c. | 49 Bagatelle
Barbet | [NAME] |  | 49 Montegut
Bell | [NAME] |  | 49 Poeyfarre
Buckner | Payne, Capt. |  | 496 Casacalvo
Spreadsheet: 765411d1643306248-need-help-with-attendance-formula-in-an-excel-template-draft_at
Sheet: Employee Leave Tracker

 | Employee [NAME]
 | Employee Name | Start Date | End Date | Type of Leave | Days | Notes
 | [NAME] | 2022-01-02 00:00:00 | 2022-01-10 00:00:00 | [NAME]
 | [NAME] | 2022-02-03 00:00:00 | 2022-02-05 00:00:00 | Field Day
 | [NAME] | 2022-03-04 00:00:00 | 2022-03-04 00:00:00 | Activism
 | [NAME] | 2022-05-11 00:00:00 | 2022-05-11 00:00:00 | Sick
 | [NAME] | 2022-07-01 00:00:00 | 2022-07-15 00:00:00 | Leave of Absence
 | [NAME] | 2022-10-12 00:00:00 | 2022-10-12 00:00:00 | Tardy |  | unexcused, 2 hours late
 | [NAME] | 2022-11-06 00:00:00 | 2022-11-08 00:00:00 | Sick
Spreadsheet: 842855d1694848081-retrieve-a-specified-number-of-rows-from-a-table-excel-forum-question-selected-amount-of-rows
Sheet: Sheet1

Row | Date | Revenue | Expense |  |  |  |  |  |  | Row | Date | Revenue | Expense
 | 2023-09-16 00:00:00 | 100 | 50
 | 2023-09-20 00:00:00 | 200 | 50 |  | Choose number of rows: |  |  | 9
 | 2023-09-20 00:00:00 | 300 | 50
 | 2023-10-10 00:00:00 | 400 | 50
 | 2023-10-11 00:00:00 | 500 | 50
 | 2023-10-12 00:00:00 | 600 | 50
 | 2023-10-30 00:00:00 | 700 | 50
 | 2023-10-30 00:00:00 | 800 | 100
 | 2023-11-14 00:00:00 | 900 | 100
 | 2023-11-15 00:00:00 | 1000 | 100
 | 2023-11-16 00:00:00 | 1100 | 100
 | 2023-11-17 00:00:00 | 1200 | 100
 | 2023-12-18 00:00:00 | 1300 | 100
 | 2023-12-18 00:00:00 | 1400 | 200
 | 2023-12-18 00:00:00 | 1500 | 200
 | 2024-01-09 00:00:00 | 1600 | 200
 | 2024-01-10 00:00:00 | 1700 | 200
 | 2024-01-11 00:00:00 | 1800 | 200
 | 2024-03-14 00:00:00 | 1900 | 200
 | 2024-03-18 00:00:00 | 2000 | 200
Spreadsheet: 676603d1588883019-figure-out-vacation-hours-into-amount-book1
Sheet: Hours2020

2019 |  | Left over | N/A | Vacation left over |  | Vacation  hour used
 |  | 0
2020 |  | HOURS |  | Vacation Hours Earn |  |  | Vacation
Dec 30th to January 12th 2020 |  | 55.75 |  | 7.24 |  | 32.25
Jan 13th to Jan 26th |  | 68 |  | 7.24 |  | 20 |  |  |  | Used 26 hours |  | 2020-01-13 00:00:00
Jan 27th  to Feb 9th |  | 92.25 |  | 7.24 |  | 0
Feb 10th to Feb 23rd |  | 88.75 |  | 8.22 |  | 0
Feb 24th to Mar 8th |  | 86.25 |  | 8.22 |  | 0 |  |  |  |  |  | [NAME]
Mar 9th to Mar 22nd |  | 76 |  | 8.22 |  | 10
Mar 23rd to Apr 5th |  | 34 |  | 8.22 |  | 40
Apr 6th to Apr 19th |  | 86.25 |  | 8.22 |  | 0 | My overall Vacation hours saved up
Apr 20th to May 3rd |  | 92.75 |  | 8.22 |  | 0
May 4th to May 17th
May 18th to May 31st
June 1st to June 14th
June 15th to June 28th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <------
June 29th to July 12th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I
July 13th to July 26th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I
July 27th to Aug 9th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I
Aug 10th to Aug 23rd |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I
Aug 24th to Sep 6th |  |  |  |  |  |  |  | Reduce Hours |  |  |  |  |  |  |  |  |  |  | I
Sep 7th to Sep 20th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I
Sep 21st to Oct 4th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I
Oct 5th to Oct18th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I
Oct 19th to Nov 1st |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I
Nov 2nd to Nov 15th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I
Nov 16th to  Nov 29th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I
Nov 30th to Dec 13th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I
Dec 14th to Dec 27th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I
Dec 28th to  Jan 10th |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I
Yearly hours total ---> |  |  |  |  |  |  | <---- Vacation Total Hours and Vacation used hours |  |  |  |  |  |  |  |  |  |  |  | I
 |  |  | 14.5 | <---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
Short Table
[NAME]  amount | Bonus amount | Hourly Vacation Pay |  | %
1346.15 | 750 |  |  | 6
Notes for the year:
Spreadsheet: 3e265c7f-8a36-444b-a598-4a913c607224
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
5248 | 33938 | [NAME] | Downing | USA | 0 | 01:11:11 | [NAME] | 02:17:42 | 00:04:49 | 00:32:44 | 1 | 04:10:26
Spreadsheet: 65390d1266077414-vlookup-with-3-criteria-meter-reading
Sheet: Sheet1

Date | Equipment | Mileage |  | Equipment | Mileage | Date
2010-01-01 00:00:00 | Car1 | 1000 |  | Car1 | 1200
2010-01-02 00:00:00 | Car2 | 1000 |  | Car2 | 1100
2010-01-03 00:00:00 | Car3 | 1000 |  | Car3 | 1100
2010-01-04 00:00:00 | Car1 | 1100
2010-01-05 00:00:00 | Car3 | 1100
2010-01-06 00:00:00 | Car1 | 1200
2010-01-07 00:00:00 | Car2 | 1100
Spreadsheet: 789331d1659038517-error-when-adding-a-blank-cell-midshires-master-test
Sheet: playlist

 | Our next Event of the 2022 season is……. |  |  |  |  |  |  | PLAYER INDEX
 | on Friday 29th July |  |  |  |  |  |  |  |  |  | 00:08:00
 | Northamptonshire at Cold Ashby |  |  |  |  | [NAME] | 09:30:00
 | Nearest the pins: | in 1 = 6th | in 2 = 1st | in 3 = 11th | Glory Hole = 9th | Captains Bottle = 16th | Longest drive = 18th | 1 |  | 31
 |  | Tee-Time | Player |  | Exact Handicap | Playing Handicap | To Pay | 2 |  | 32 |  | Tee-Time |  | H'Cap | To Pay
15 |  |  |  |  |  |  | PAID | 3 |  | 33
30 | GROUP |  |  |  |  |  | PAID | 4 |  | 34
45 | 1 | 10:26:00 |  |  |  |  | 12 | 5 |  | 35
 |  |  |  |  |  |  |  | 6 |  | 36
8 |  |  |  |  |  |  | PAID | 7 |  | 37
24 | GROUP |  |  |  |  |  | PAID | 8 |  | 38
39 | 2 |  |  |  |  |  | PAID | 9 |  | 39
 |  |  |  |  |  |  |  | 10 |  | 40
49 |  |  |  |  |  |  | PAID | 11 |  | 41
12 | GROUP |  |  |  |  |  | PAID | 12 |  | 42
37 | 3 |  |  |  |  |  | PAID | 13 |  | 43
 |  |  |  |  |  |  |  | 14 |  | 44
10 |  |  |  |  |  |  | 12 | 15 |  | 45
40 | GROUP |  |  |  |  |  | PAID | 16 |  | 46
59 | 4 |  |  |  |  |  | PAID | 17 |  | 47
60 |  |  |  |  |  |  | PAID | 18 |  | 48
47 |  |  |  |  |  |  | 10.5 | 19 |  | 49
28 | GROUP |  |  |  |  |  | PAID | 20 |  | 50
42 | 5 |  |  |  |  |  | PAID | 21 |  | 51
44 |  |  |  |  |  |  | 33 | 22 |  | 52
9 |  |  |  |  |  |  | PAID | 23 |  | 53
18 | GROUP |  |  |  |  |  | PAID | 24 |  | 54
23 | 6 |  |  |  |  |  | PAID | 25 |  | 55
35 |  |  |  |  |  |  | PAID | 26 |  | 56
21 |  |  |  |  |  |  | PAID | 27 |  | 57
22 | GROUP |  |  |  |  |  | PAID | 28 |  | 58
57 | 7 |  |  |  |  |  | PAID | 29 |  | 59
41 |  |  |  |  |  |  | PAID | 30 |  | 60
46 |  |  |  |  |  |  | PAID |  |  | 61
3 | GROUP |  |  |  |  |  | PAID |  |  | 62
52 | 8 |  |  |  |  |  | PAID |  |  | 63
29 |  |  |  |  |  |  | PAID
 | GROUP
 | 9
 | GROUP
 | 10
Spreadsheet: 233101d1367610283-how-do-i-display-worksheet-names-reconcilliations
Sheet: AR

Monthly Account Rec
 | Account: | AR
 | Period:
 | GL Balance: | 1000
 | Actual: | 1050
 | Adjustments:
 | Difference:
Adjustments: |  | Date | DR | CR | Ref | Notes
 |  | 2013-01-15 00:00:00 | 0 | 50 | NGG2389 | Need to fix, bad debt entered through JE instead of CM
Spreadsheet: 693675d1599083653-possible-sumifs-index-match-book25-excel-forum-example-v2-with-expected-results-
Sheet: Sheet1

 | YEARS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YEARS | MILEAGE
 | TASK | COST | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | COST TOTAL (BASED ON CONTRACT LENGTH) | EXPECTED RESULT |  |  |  | CONTRACT LENGTH | 5 | 550000
 | TASK 1 | 1000 | X |  | X |  | X |  | X |  | X |  |  |  | <--- NEED FORMULA HERE TO SUM TASK COST BASED ON TASK FREQUENCY (SHOWN BY 'X'S) BASED ON CONTRCT LENGTH ("AC4")
 | TASK 2 | 5000 |  |  |  |  | X |  |  |  |  | X
 | TASK 3 | 20000 |  |  |  |  |  | X
 | MILEAGE
 | TASK | COST | 100000 |  |  |  |  |  |  |  |  |  | COST TOTAL (BASED ON CONTRACT LENGTH) | EXPECTED RESULT
 | TASK 1 | 10000 | X | X | X | X | X | X | X | X | X | X |  |  | <--- NEED FORMULA HERE TO SUM TASK COST BASED ON TASK FREQUENCY (SHOWN BY 'X'S) BASED ON CONTRCT LENGTH ("AC4") …… BUT ALSO NEEDS TO ROUNDDOWN TO CLOSEST MILEAGE TO CONTRACT MILEAGE
 | TASK 2 | 5000 |  | X |  | X |  | X |  | X |  | X
 | TASK 3 | 50000 |  |  |  | X |  |  |  | X
Spreadsheet: 794434d1662045119-google-sheets-search-words-in-cell-content-vlook-and-other-problems-test-spreadsheet-hd
Sheet: Time Zones

UTC | Time Zone | Time Difference | Zone Time
00:00:00 | Central Time | -5 | 19:00:00 PM
00:00:00 | Eastern Time | -4 | 20:00:00 PM
00:00:00 | Pacific Time | -7 | 17:00:00 PM
00:00:00 | Mountain Time | -6 | 18:00:00 PM
Spreadsheet: darrell_schoolcraft__7825__imbalsumm0109
Sheet: Agave

Agave imbalance
 | Measured | Scheduled | Imbalance
56339 | 751234 | 716145
500232 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500238 | 530700 | 701084 |  |  |  |  |  |  |  |  | lunch | 7.6
500239 | 426504 | 544501
500293 | 298198 | 408652
500302 |  | 8415
500303 | 158793 | 233399
500305 | 766891 | 926518
500307 | 37665 | 28583
500313 |  | 1359
500314
500655 | 488663
500657 | 107446 | 68400
INDEX
2001-08-31 00:00:00 |  |  | -6642.45
2001-09-22 00:00:00
CBS Volume
 |  |  | -37836
Spreadsheet: 375968d1423426808-show-certain-detailed-data-from-other-sheet-ef683a_pulling-data-reporting-formula
Sheet: summary by all state

Customers | Location Of Plant | State | Channel | Products | Sales | Price List | Rebate | Trspt Rebate | match_row |  | [NAME] show up once the data updated.
Spreadsheet: 859273d1707725283-extracting-date-and-mixed-data-types-to-produce-a-12-month-publication-output-extracting-date-and-mixed-data-types-to-produce-a-12-month-entry-issues
Sheet: Monthly_Publication_List

Pub_Date | Pub_Title
2024-02-21 00:00:00 | Publication 1
2024-02-21 00:00:00 | Publication 2
2024-02-21 00:00:00 | Publication 3
2024-03-21 00:00:00 | Publication 4
2024-03-11 00:00:00 | Publication 5
2024-03-12 00:00:00 | Publication 6
2024-03-13 00:00:00 | Publication 7
2024-03-14 00:00:00 | Publication 8
2024-05-15 00:00:00 | Publication 9
2024-05-16 00:00:00 | Publication 10
2024-11-14 00:00:00 | Publication 11
2024-11-15 00:00:00 | Publication 12
2026-11-06 00:00:00 | Publication 13
2024-11-08 00:00:00 | Publication 14
2024-11-08 00:00:00 | Publication 15
2024-11-13 00:00:00 | Publication 16
2024-11-05 00:00:00 | Publication 17
2024-11-08 00:00:00 | Publication 18
2024-02-02 00:00:00 | Publication 19
2024-01-26 00:00:00 | Publication 20
2024-01-05 00:00:00 | Publication 21
2024-07-05 00:00:00 | Publication 22
2024-07-05 00:00:00 | Publication 23
2024-07-12 00:00:00 | Publication 24
2024-07-05 00:00:00 | Publication 25
2024-06-11 00:00:00 | Publication 26
2024-06-07 00:00:00 | Publication 27
2024-06-25 00:00:00 | Publication 28
2024-02-02 00:00:00 | Publication 29
2024-03-02 00:00:00 | Publication 30
2024-03-02 00:00:00 | Publication 31
2024-03-02 00:00:00 | Publication 32
2024-03-02 00:00:00 | Publication 33
2024-10-14 00:00:00 | Publication 34
2024-10-15 00:00:00 | Publication 35
2024-10-16 00:00:00 | Publication 36
2024-02-10 00:00:00 | Publication 37
2024-02-10 00:00:00 | Publication 38
2024-02-10 00:00:00 | Publication 39
2024-02-10 00:00:00 | Publication 40
2024-02-10 00:00:00 | Publication 41
2024-02-10 00:00:00 | Publication 42
2024-01-10 00:00:00 | Publication 43
2024-01-01 00:00:00 | Publication 44 | If you take the red text out the program works! However, in Full_Pub_List_Dynamic I there are problems with the code in CELL B3
Confirmed Jan | Publication 45
Tentative Jan-10 | Publication 46
Tentative Mar-10 | Publication 47
Confirmed Jan | Publication 48
Confirmed Jan | Publication 49
Confirmed Jan | Publication 50
Confirmed Jan | Publication 50
Confirmed Jan | Publication 51
Confirmed Jan | Publication 52
Confirmed Jan | Publication 53
Confirmed Jan | Publication 54
Confirmed Jan | Publication 55
Confirmed Jan | Publication 56
Confirmed Jan | Publication 57
Confirmed Jan | Publication 58
Spreadsheet: 267827d1380223406-league-standings-automatically-golf-autosort
Sheet: Data Summarized Here

 | DBGL 13/14
 | DA BOYZ GOLF LEAGUE
Rank | Players |  |  | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Pts | Average Points | Total Points
 | White River Country Club - Nelspruit Golf Club - Sabie River Sun - Kruger Park Lodge
1
2
3
4
5
6
7
8
 |  |  |  | League Standings
Spreadsheet: 685688d1594141791-trying-to-increment-a-4-character-alphanumeric-code-in-excel-test-1-
Sheet: Sheet1

MC | 100 | VGVA
MC
MC
MC
MC
MC
MC
MC
MC
MC
MC
MC
 |  | ZZZZ
Spreadsheet: 881433d1729516974-abstract-the-materials-with-timeline-abstract
Sheet: Mat

Sl No | Description of work | Material And Manpower | BOQ QTY | Unit | Perday Output | Duration | Unit/Per | Unit | Rate | Start Date | Finish Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T.Qty
1 | [NAME] 1:4 | Bricks | 90 | M3 | 15 |  |  | Nos |  | 2024-10-16 00:00:00
2 | [NAME] 1:4 | Cement | 150 | M3 | 22 |  |  | tonne
3 | [NAME] 1:4 | Fine Sand | 96 | M3 | 12 |  |  | cum
4 | [NAME] 1:4 | Mason | 96 | M3 | 12 |  |  | Day
5 | [NAME] 1:4 | Helper | 96 | M3 | 12 |  |  | Day
6 | [NAME] 1:4 | W-Helper | 96 | M3 | 12 |  |  | Day
7 | [NAME] 1:6 | Bricks | 118 | M3 | 12 |  |  | Nos
8 | [NAME] 1:6 | Cement | 118 | M3 | 12 |  |  | tonne
9 | [NAME] 1:6 | Fine Sand | 118 | M3 | 12 |  |  | cum
10 | [NAME] 1:6 | Mason | 118 | M3 | 12 |  |  | Day
11 | [NAME] 1:6 | Helper | 118 | M3 | 12 |  |  | Day
12 | [NAME] 1:6 | W-Helper | 118 | M3 | 12 |  |  | Day
13 | RCC 1:2:4 | Stone aggregate 20mm | 207 | M3 | 35 |  |  | cum
14 | RCC 1:2:4 | Stone aggregate 10mm | 207 | M3 | 35 |  |  | cum
15 | RCC 1:2:4 | Sand | 207 | M3 | 35 |  |  | cum
16 | RCC 1:2:4 | Cement | 207 | M3 | 35 |  |  | tonne
17 | RCC 1:2:4 | Mason | 207 | M3 | 35 |  |  | Day
18 | RCC 1:2:4 | Helper | 207 | M3 | 35 |  |  | Day
19 | RCC 1:2:4 | W-Helper | 207 | M3 | 35 |  |  | Day
20 | RCC 1:2:4 | Mixer | 207 | M3 | 35 |  |  | Day
21 | RCC 1:2:4 | Vibrator | 207 | M3 | 35 |  |  | Day