tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: bce2d2f6-b546-49c6-a3f4-0e4620255cb7
Sheet: Sheet1

Release: U.S. Import and Export Price Indexes | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=188
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-04-17 11:45 PM [NAME]
 | Real-Time | Period
Name: | Start | End
U.S. Import and Export Price Indexes | 2010-03-16 00:00:00 | Current
Link:
http://www.bls.gov/mxp/ | 2010-03-16 00:00:00 | Current
Source:
U.S. Department of Labor: Bureau of Labor Statistics | 2010-03-16 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2010-03-16 00:00:00
2010-04-13 00:00:00
2010-05-13 00:00:00
2010-06-15 00:00:00
2010-07-14 00:00:00
2010-08-12 00:00:00
2010-09-15 00:00:00
2010-10-13 00:00:00
2010-11-10 00:00:00
2010-12-10 00:00:00
2011-01-12 00:00:00
2011-02-15 00:00:00
2011-03-15 00:00:00
2011-04-12 00:00:00
2011-05-10 00:00:00
2011-06-10 00:00:00
2011-07-13 00:00:00
2011-08-16 00:00:00
2011-09-13 00:00:00
2011-10-14 00:00:00
2011-11-10 00:00:00
2011-12-14 00:00:00
2012-01-13 00:00:00
2012-02-14 00:00:00
2012-03-14 00:00:00
2012-04-11 00:00:00
2012-05-10 00:00:00
2012-06-12 00:00:00
2012-07-12 00:00:00
2012-08-10 00:00:00
2012-09-12 00:00:00
2012-10-11 00:00:00
2012-11-09 00:00:00
2012-12-12 00:00:00
2013-01-11 00:00:00
2013-02-13 00:00:00
2013-03-13 00:00:00
2013-04-11 00:00:00
2013-05-14 00:00:00
2013-06-13 00:00:00
2013-07-11 00:00:00
2013-08-13 00:00:00
2013-09-12 00:00:00
2013-10-23 00:00:00
2013-11-15 00:00:00
2013-12-12 00:00:00
2014-01-14 00:00:00
2014-02-14 00:00:00
2014-03-13 00:00:00
2014-04-10 00:00:00
Spreadsheet: 27e1dbf7-f1c1-411a-b889-7c91ea7ccb53
Sheet: 7b

Product1 | EUR3 | GBP | [NAME] | USD | AUD | CAD | OTHER | TOTAL
Basis | 618663 | 1782139 | 1839808 | 8147366 | 291734 | 112082 | 170501 | 12962293
Fixed-Float | 64627840 | 12075181 | 16602383 | 71751424 | 3884834 | 3774550 | 10224265 | 182940477
FRA | 25624997 | 9326061 | 28150 | 17058427 | 187181 | 58154 | 3688143 | 55971113
OIS | 19790224 | 5739211 | 107607 | 5634322 | 890685 | 475248 | 631557 | 33268854
Swaption | 7258732 | 1041766 | 2333687 | 5739324 | 277170 | 10594 | 214902 | 16876175
OTHER* | 5298069 | 882191 | 299836 | 10543564 | 166922 | 37181 | 237991 | 17465754
TOTAL | 123218525 | 30846549 | 21211471 | 118874427 | 5698526 | 4467809 | 15167359 | 319484666
*OTHER variable includes the following products: Cap/Floor, Debt Option, Exotic, Fixed-Fixed, and Inflation.
Spreadsheet: 86c79ab0-b484-455d-ac14-b6b2e79b01a5
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 |  |  |  |  |  |  | WORKFORCE
 |  |  |  |  |  |  | BRANCH: CANBERRA
 |  |  |  |  |  |  | TIMESHEET: send approved timesheets to [EMAIL]
 |  |  |  |  |  |  | or FAX to: 1300 301 994 before 9am Monday
 |  |  |  |  |  |  | PAYROLL queries: Ph 1300 853 100
 |  |  |  |  |  |  | PAYROLL queries email: [EMAIL]
Time Sheet
Week ending day & date |  |  |  |  | Client Name
Employee Name |  |  |  |  | Client Address
Employee Position
Client Cost Centre |  |  |  |  | Supervisor's Name
[NAME] |  |  |  |  | Supervisor's Title
Employee's Signature |  |  |  |  | [NAME]'s Signature
By signing this, you are verifying the hours worked, that you are satisfied with the work completed and that you accept the Chandler Macleod Terms of Business. If you have not been provided with the Chandler Macleod Terms of Business, please contact your Consultant.
Day | Date | Time Start use AM/PM or use 24hr clock | Time Finish use AM/PM or use 24hr clock | Less Lunch | Hours Worked |  |  |  |  |  |  | Allowances
 |  |  |  |  | Ordinary | Shift | T 1/2 | T 2 | T 2 1/2 | Public Holiday | Total Hours or Days | Meal | Travel | Other:
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
 |  |  | Total Hours or Days
Send original receipts and client approval to Chandler Macleod Payroll, 745 Springvale Road, MULGRAVE VIC 3170
August 2010
Spreadsheet: 848281d1699026714-sum-per-week-within-the-month-sum-of-the-week-within-the-month-leovilla-
Sheet: Planilha1

Week Number |  |  |  |  | Sum of the week within the month | [NAME] |  | Sum of the week within the month
 | 2023-08-01 00:00:00 | 15.5 |  |  |  | =SUM(C2:C5)
 | 2023-08-02 00:00:00 | 18.5 |  |  |  | =SUM(C6:[NAME])
 | 2023-08-03 00:00:00 | 21.5 |  |  |  | =[NAME]:C15)
 | 2023-08-04 00:00:00 | 24.5 |  |  |  | =SUM(C16:C20)
 | 2023-08-07 00:00:00 | 27.5 |  |  |  | =SUM(C21:C24)
 | 2023-08-08 00:00:00 | 30.5 |  |  |  | =SUM(C26)
 | 2023-08-09 00:00:00 | 33.5 |  |  |  | =SUM(C27:C30)
 | 2023-08-10 00:00:00 | 36.5 |  |  |  | =SUM(C31:C35)
 | 2023-08-11 00:00:00 | 39.5 |  |  |  | =SUM(C36:C40)
 | 2023-08-14 00:00:00 | 42.5 |  |  |  | =SUM(C47:C51)
 | 2023-08-15 00:00:00 | 45.5 |  |  |  | =SUM(C52:C55)
 | 2023-08-16 00:00:00 | 48.5 |  |  |  | =SUM(C56:[NAME])
 | 2023-08-17 00:00:00 | 51.5 |  |  |  | =SUM(C61:C65)
 | 2023-08-18 00:00:00 | 54.5 |  |  |  | =SUM(C66:C67)
 | 2023-08-21 00:00:00 | 57.5
 | 2023-08-22 00:00:00 | 60.5
 | 2023-08-23 00:00:00 | 63.5
 | 2023-08-24 00:00:00 | 66.5
 | 2023-08-25 00:00:00 | 69.5
 | 2023-08-28 00:00:00 | 72.5
 | 2023-08-29 00:00:00 | 75.5
 | 2023-08-30 00:00:00 | 78.5
 | 2023-08-31 00:00:00 | 81.5
 | 2023-09-01 00:00:00 | 87.5
 | 2023-09-04 00:00:00 | 90.5
 | 2023-09-05 00:00:00 | 93.5
 | 2023-09-06 00:00:00 | 96.5
 | 2023-09-08 00:00:00 | 99.5
 | 2023-09-11 00:00:00 | 102.5
 | 2023-09-12 00:00:00 | 105.5
 | 2023-09-13 00:00:00 | 108.5
 | 2023-09-14 00:00:00 | 111.5
 | 2023-09-15 00:00:00 | 114.5
 | 2023-09-18 00:00:00 | 117.5
 | 2023-09-19 00:00:00 | 120.5
 | 2023-09-20 00:00:00 | 123.5
 | 2023-09-21 00:00:00 | 126.5
 | 2023-09-22 00:00:00 | 129.5
 | 2023-09-25 00:00:00 | 132.5
 | 2023-09-26 00:00:00 | 135.5
 | 2023-09-27 00:00:00 | 138.5
 | 2023-09-28 00:00:00 | 141.5
 | 2023-09-29 00:00:00 | 144.5
 | 2023-10-02 00:00:00 | 150.5
 | 2023-10-03 00:00:00 | 153.5
 | 2023-10-04 00:00:00 | 156.5
 | 2023-10-05 00:00:00 | 159.5
 | 2023-10-06 00:00:00 | 162.5
 | 2023-10-09 00:00:00 | 165.5
 | 2023-10-10 00:00:00 | 168.5
 | 2023-10-11 00:00:00 | 171.5
 | 2023-10-13 00:00:00 | 174.5
 | 2023-10-16 00:00:00 | 177.5
 | 2023-10-17 00:00:00 | 180.5
 | 2023-10-18 00:00:00 | 183.5
 | 2023-10-19 00:00:00 | 186.5
 | 2023-10-20 00:00:00 | 189.5
 | 2023-10-23 00:00:00 | 192.5
 | 2023-10-24 00:00:00 | 195.5
 | 2023-10-25 00:00:00 | 198.5
 | 2023-10-26 00:00:00 | 201.5
 | 2023-10-27 00:00:00 | 204.5
 | 2023-10-30 00:00:00 | 207.5
 | 2023-10-31 00:00:00 | 210.5
 | 2023-11-01 00:00:00 | 216.5
 | 2023-11-03 00:00:00 | 219.5
 | 2023-11-06 00:00:00 | 222.5
 | 2023-11-07 00:00:00 | 225.5
 | 2023-11-08 00:00:00 | 228.5
 | 2023-11-09 00:00:00 | 231.5
 | 2023-11-10 00:00:00 | 234.5
 | 2023-11-13 00:00:00 | 237.5
 | 2023-11-14 00:00:00 | 240.5
 | 2023-11-16 00:00:00 | 243.5
 | 2023-11-17 00:00:00 | 246.5
 | 2023-11-20 00:00:00 | 249.5
 | 2023-11-21 00:00:00 | 252.5
 | 2023-11-22 00:00:00 | 255.5
 | 2023-11-23 00:00:00 | 258.5
 | 2023-11-24 00:00:00 | 261.5
 | 2023-11-27 00:00:00 | 264.5
 | 2023-11-28 00:00:00 | 267.5
 | 2023-11-29 00:00:00 | 270.5
 | 2023-11-30 00:00:00 | 273.5
Spreadsheet: 854282d1704212929-excel-subtotal-feature-handling-duplicate-barcodes-excelforum-afternoon
Sheet: What i look for

barcode | quantity
6201-02-20
4202-03-02
4202-02-04
4202-03-05
4202-03-21
6201-03-20
4202-04-02
4202-04-01
4202-03-04
4202-04-05
4202-04-21
4202-05-21
4202-06-21
4202-05-04
4202-05-02
6201-05-20
6201-04-20
4591-06-03
4202-06-02
4202-07-02
4202-06-01
4170-06-01
4202-06-04
4202-06-05
4591-07-21
4202-07-21
4202-07-05
4202-08-04
Spreadsheet: 158955d1338463343-array-count-if-question-test
Sheet: Sheet1

Date | Location | Time | Home | Score | Away | Score |  | Team | Place | Wins | Loses | PF | PA
2012-05-22 00:00:00 | Field 8 | 1830 | Cubs | 13 | Tigars | 1 |  | Indians
2012-05-22 00:00:00 | Field 9 | 1830 | Red Sox | 1 | Giants | 22 |  | Blue Jays
2012-05-22 00:00:00 | Field 8 | 1930 | Blue Jays | 12 | Giants | 10 |  | Giants
2012-05-24 00:00:00 | Field 8 | 1830 | Indians | 10 | Blue Jays | 9 |  | White Sox
2012-05-24 00:00:00 | Field 8 | 1930 | White Sox | 6 | Red Sox | 8 |  | Red Sox
2012-05-29 00:00:00 | Field 8 | 1830 | White Sox | 14 | Indians | 8 |  | Tigars
2012-05-29 00:00:00 | Field 9 | 1930 | White Sox | 9 | Tigars | 7 |  | Cubs
2012-05-29 00:00:00 | Field 8 | 1930 | Red Sox | 2 | Cubs | 23
2012-05-31 00:00:00 | Field 9 | 1830 | Indians |  | Red Sox
2012-05-31 00:00:00 | Field 8 | 1930 | Giants |  | Red Sox |  |  | my array shows
2012-05-31 00:00:00 | Field 9 | 1930 | Cubs |  | Indians |  |  | the correct results |  |  |  | countif works
2012-06-05 00:00:00 | Field 9 | 1830 | Tigars |  | Red Sox
2012-06-05 00:00:00 | Field 8 | 1830 | Giants |  | White Sox
2012-06-05 00:00:00 | Field 9 | 1930 | Red Sox |  | Blue Jays |  |  |  |  |  |  | countif fails
2012-06-05 00:00:00 | Field 8 | 1930 | Indians |  | Tigars
2012-06-07 00:00:00 | Field 9 | 1830 | Tigars |  | Giants
2012-06-07 00:00:00 | Field 8 | 1830 | Blue Jays |  | White Sox
2012-06-07 00:00:00 | Field 9 | 1930 | Tigars |  | Blue Jays
2012-06-07 00:00:00 | Field 8 | 1930 | Giants |  | Indians
2012-06-12 00:00:00 | Field 9 | 1830 | Indians |  | White Sox
2012-06-12 00:00:00 | Field 8 | 1830 | Giants |  | Cubs
2012-06-12 00:00:00 | Field 9 | 1930 | Tigars |  | Cubs
2012-06-12 00:00:00 | Field 8 | 1930 | Blue Jays |  | Indians
2012-06-19 00:00:00 | Field 9 | 1830 | Tigars |  | White Sox
2012-06-19 00:00:00 | Field 8 | 1830 | Cubs |  | Red Sox
2012-06-19 00:00:00 | Field 9 | 1930 | Giants |  | Blue Jays
2012-06-19 00:00:00 | Field 8 | 1930 | Tigars |  | Indians
2012-06-26 00:00:00 | Field 9 | 1830 | Red Sox |  | White Sox
2012-06-26 00:00:00 | Field 8 | 1830 | Blue Jays |  | Tigars
2012-06-26 00:00:00 | Field 9 | 1930 | Cubs |  | Giants
2012-06-26 00:00:00 | Field 8 | 1930 | Red Sox |  | Indians
2012-07-10 00:00:00 | Field 9 | 1830 | Cubs |  | Blue Jays
2012-07-10 00:00:00 | Field 8 | 1830 | Red Sox |  | Tigars
2012-07-10 00:00:00 | Field 9 | 1930 | White Sox |  | Giants
2012-07-10 00:00:00 | Field 8 | 1930 | Blue Jays |  | Red Sox
2012-07-12 00:00:00 | Field 9 | 1830 | White Sox |  | Cubs
2012-07-12 00:00:00 | Field 8 | 1830 | Indians |  | Giants
2012-07-12 00:00:00 | Field 9 | 1930 | White Sox |  | Blue Jays
2012-07-12 00:00:00 | Field 8 | 1930 | Indians |  | Cubs
2012-07-17 00:00:00 | Field 8 | 1830 | Giants |  | Tigars
2012-07-17 00:00:00 | Field 9 | 1830 | Cubs |  | White Sox
2012-07-17 00:00:00 | Field 9 | 1930 | Blue Jays |  | Cubs
Spreadsheet: 773610d1647955057-returning-column-header-of-last-value-in-a-row-lookupsamplejvd
Sheet: Blad1

Nr. | Out_ordnr | Dt-loading | Statuscode | Custref-out4 | B/L | Barcode_id_internal | Outer-pck |  |  | 2022-01-10 00:00:00 | 2022-01-11 00:00:00 | 2022-01-12 00:00:00 | 2022-01-13 00:00:00 | 2022-01-14 00:00:00 | 2022-01-15 00:00:00 | 2022-01-16 00:00:00 | 2022-01-17 00:00:00 | 2022-01-18 00:00:00 | 2022-01-19 00:00:00
723 |  |  |  |  | SKSMPMAWB2700100 | 340121100070401 |  |  |  | x | x | x | 0
1343 |  |  |  |  | SKSMPMAWB2700100 | 340121100021601 |  |  |  | x | x | x | 0
1344 |  |  |  |  | SKSMPMAWB2700100 | 340121100021602 |  |  |  | x | x | x | 0 |  |  | Lookup  "0" and return header date
1345 |  |  |  |  | SKSMPMAWB2700100 | 340121100046201 |  |  |  | x | x | x | 0
1346 |  |  |  |  | SKSMPMAWB2700100 | 340121100107404 |  |  |  | x | x | x | 0
1347 |  |  |  |  | SKSMPMAWB2700100 | 340121100144400 |  |  |  | x | x | x | 0
1348 |  |  |  |  | SKSMPMAWB2700100 | 340121100157400 |  |  |  | x | x | x | x | x | x | x | x | x | 0
1667 |  |  |  |  | SKSMPMAWB2700200 | 1001224578 |  |  |  | x | x | x | x | x | x | x | x | x | 0
1668 |  |  |  |  | SKSMPMAWB2700200 | 1001224970 |  |  |  | x | x | x | x | x | x | x | x | x | 0
1669 |  |  |  |  | SKSMPMAWB2700200 | 1001225158 |  |  |  | x | x | x | x | x | x | x | 0
1670 |  |  |  |  | SKSMPMAWB2700200 | 1001228571 |  |  |  | x | x | x | x | x | x | x | 0
 |  | [NAME] in column C
 | Using AlKey's formula: =IFERROR(INDEX(B$1:H$1,MAX(INDEX((B$2:H$11=J2)*COLUMN(B:H)-1,0))),"Value not found") : does not work ??
 | (not in this sample!)
 | I need to look up the last column that contains 0 and then return the header. |  |  |  |  |  | Seperate for EACH row, not globally.
Spreadsheet: 4b63a656-14ef-484b-b6f4-eb8f8c6a580d
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259737 | 75738 | [NAME] | [NAME] | CHI |  | 00:38:43 | 00:01:40 | [NAME] | 00:01:45 | 01:45:52 | 1 | 05:32:10
259737 | 75744 | Stephania | [NAME] | CHI |  | 00:43:49 | 00:01:34 | 04:00:10 | 00:01:09 | 02:31:19 | 2 | 07:18:01
Spreadsheet: 784996d1656066509-lookup-partial-string-match-in-excel-test2
Sheet: Sheet5

Column1 | Column2 |  | String | Expected |  |  |  | String | Value
Ayanande |  |  | Ayanande | 1 |  |  |  | Aya | Mercedes
Ayonande |  |  | Ayonande | #N/A |  |  |  | Tes | Audi
Aviles |  |  | Aviles | #N/A |  |  |  | Bad | BMW
Bade |  |  | Bade | 3 |  |  |  | Hugo | Ford
Bailer |  |  | Bailer | #N/A
Test |  |  | Test | 2
[NAME]
Spreadsheet: 845794d1697137797-manipulate-dynamic-array-change-column-order-apply-formula-by-column-dynamic-array-problems-3-
Sheet: Planilha1

 |  |  |  |  |  |  |  |  |  |  | Data |  |  |  | 1st attempt |  |  |  | FILTER | Grape Fruit
 |  |  | Other attemps |  |  |  |  |  |  |  | Item | Price | Date |  |  | Grape | 50
 |  |  | a | b | c |  | a | b | c |  | Grape Fruit | 100 | 2023-10-12 00:00:00 |  | 15-outubro | Grape | 95
 |  |  | 2 | 2 | 2 |  |  | 1 | 40 |  | Orange Fruit | 150 | 2023-10-13 00:00:00 |  | 17-outubro | Grape | 100
 |  |  | 2 | 2 | 2 |  | 2 | 1 | 40 |  | Orange Fruit | 50 | 2023-10-14 00:00:00
 |  |  | 2 | 2 | 2 |  | 2 | 1 | 40 |  | Grape Fruit | 190 | 2023-10-15 00:00:00
 |  |  | 2 | 2 | 2 |  | 2 | 1 | 40 |  | Orange Fruit | 300 | 2023-10-16 00:00:00
 |  |  | 2 | 2 | 2 |  | 2 | 1 | 40 |  | Grape Fruit | 200 | 2023-10-17 00:00:00
 |  |  | 2 | 2 | 2 |  | 2 | 1 | 40 |  | Orange Fruit | 110 | 2023-10-18 00:00:00
 |  |  |  |  |  |  |  |  |  |  | Apple Fruit | 50 | 2023-10-19 00:00:00
 |  |  |  |  |  |  |  |  |  | Want to column be | text replace | divide by 2 | format
 |  |  |  |  |  |  |  |  |  |  | What I Need
 |  |  |  |  |  |  |  |  |  |  | Date | Item | Price |  | *Is there a better or simple way?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *COL(dados)=12 ==== I think this part of formula could broke so easy, maybe turn it dynamic, but I don’t know how..
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *Is LAMBDA the best way? Shoul I CHOOSE columns, then apply my needs, and then stack it again
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *FILTER, could I use my dynamic array in to the filter function criteria?
Spreadsheet: 701994d1604032484-match-the-data-and-fetch-the-result-in-regarding-row-live-tracking-self-updated
Sheet: DESIRE RESULT

DATE | P.O. NO. | QUALITY | COLOR | SIZE | ORDER | CUTTING | SHIPPED | BALANCE | PACKING | PENDING | BOX
 |  |  |  |  | 65 | 55 | 35 |  |  |  | 5
 |  |  |  |  | 66 | 56 | 36 |  |  |  | 7
 |  |  |  |  | 70 | 60 | 40 |  |  |  | 4
 |  |  |  |  | 75 | 65 | 45
 |  |  |  |  | 80 | 70 | 50
 |  |  |  |  | 95 | 85 | 65
 |  |  |  |  | 90 | 80 | 60
 |  |  |  |  | 100 | 90 | 70 |  |  |  | 8
 |  |  |  |  | 105 | 95 | 75 |  |  |  | 9
 |  |  |  |  | 106 | 96 | 76 |  |  |  | 10
 |  |  |  |  | 75 | 65 | 45 |  |  |  | 12
 |  |  |  |  | 74 | 64 | 44 |  |  |  | 15
 |  |  |  |  | 26 |  | 6 |  | 16 |  | 11
 |  |  |  |  | 35 |  | 5 |  | 25 |  | 25
 |  |  |  |  | 23 |  | 3 |  | 13 |  | 20
 |  |  |  |  | 135 |  | 105 |  | 125
 |  |  |  |  | 55 |  | 25 |  | 45
 |  |  |  |  | 35 |  | 5 |  | 25
 |  |  |  |  | 95 |  | 65 |  | 85
 |  |  |  |  | 85 |  | 55 |  | 75
 |  |  |  |  | 105 |  | 75 |  | 95
 |  |  |  |  | 55 |  | 45 |  | 65
 |  |  |  |  | 43 |  | 13 |  | 33
 |  |  |  |  | 60 | 50 | 50
 |  |  |  |  | 50 |  | 40 |  | 40
 |  |  |  |  | 70 | 60 | 40
 |  |  |  |  | 80 |  | 50 |  | 70 |  | 8
 |  |  |  |  | 90 |  | 60 |  | 80 |  | 9
 |  |  |  |  | 110 |  | 80 |  | 100 |  | 10
 |  |  |  |  | 50 | 40 | 20 |  |  |  | 12
 |  |  |  |  | 60 | 50 | 30 |  |  |  | 15
 |  |  |  |  | 40 | 30 | 10
Spreadsheet: 789452d1659102792-choosing-data-from-column-depending-on-column-contents-help
Sheet: Forecast Validation

Event Forecast Repository
202227 [NAME]
 | Product Hierarchy Detail |  |  |  |  |  |  |  |  |  |  |  | SKU Ordering Detail (from IPR) |  |  |  | Avg Unit Detail |  | Sales Forecast Detail |  |  |  |  |  |  |  |  | Data from FDMM Pitch/Selection |  |  |  | *Emails from Merhants
 | SKU | SKU Desc | Merch Dept | Dept | Class | Sub Class | Class Description | Pitch | Start Date | End Date | Weeks | Placement | Designation | Import/Domestic | Post-Event Intent | Store Count | Current Retail | Event Retail (Merchant) | [NAME] ($) | [NAME] (Units) | IPR [NAME] (Units) | Buy $ @ Event Retail | Unit Sell-Thru (IPR) | $ [NAME] | Validation Notes | Commentary | [NAME] | Count | Pitch $ | Pitch $ SKU | Estimated Forcast Units | HardCode Sales Forecast $ | HardCode Sales Forecast Units
 | 374055 | LANCO 10.1 OZ ALL PURPOSE ACRYLIC WH | 24 | 24 | 2 | 3 | CAULKS | [NAME] ONLY PERM WS (4 PLACEMENTS) | 08/01/2022 | 10/30/2022 | 13 | WINGSTACK | Core | Domestic | Return to Run | 10 | 2.88 | 0.00 | 0 | 1,620.00 | 1,620.00 | 0 | 1 | - |  |  | [NAME] ONLY PERM WS (4 PLACEMENTS) | 1 | 98903.11 | 98903.11 | 1,620.00 | 1
Spreadsheet: 736969d1623988380-copy-selected-data-to-different-sheets-grant-management-latest-detailed
Sheet: 35000

 | Jentera / Mesin |  |  |  |  |  |  |  | ICT
 | Bil. | tarikh | Jenis tuntutan /pembayaran | No resit  (jika ada) | Bil. unit | Harga seunit | [NAME] |  | Bil. | tarikh | Jenis tuntutan /pembayaran | No resit  (jika ada) | Bil. unit | Harga seunit | [NAME]
Spreadsheet: 1fc29fd0-a521-4f5e-82cc-81b005a3f32f
Sheet: Online Details

*Campaign ID | Campaign Name | Site ID | Site Name | Placement ID | *Placement Name | *Placement Type | Is Primary Roadblock | Placement Group ID | Placement Group Name | Payment Type | *Size | Content Category | Strategy | *Archived | Placement Comments | Testing Period Date | Demo | Geo | *Start Date | *End Date | Cap Cost | *Activate Flighting | *Cost Structure | Units | Rate | Cost | JAN IMPS | FEB IMPS | MAR IMPS | APR IMPS | MAY IMPS | JUN IMPS | JUL IMPS | AUG IMPS | SEPT IMPS | OCT IMPS | NOV IMPS | DEC IMPS | JAN $ | FEB $ | MAR $ | APR $ | MAY $ | JUN $ | JUL $ | AUG $ | SEPT $ | OCT $ | NOV $ | DEC $ | Error
 |  |  | [NAME] |  |  | In-page |  |  |  |  | 300x250 | ROS | _ |  | 01 |  |  |  | 2007-01-02 00:00:00 | 2007-04-29 00:00:00 |  |  | CPM |  | 8 |  | 2000000
 |  |  | [NAME] |  |  |  |  |  |  |  | 728x90 | Crop Comments | _ |  | 02 |  |  |  | 2007-01-02 00:00:00 | 2007-04-29 00:00:00 |  |  | Flat Rate-Impressions |  | 2500 |  | 10000 | 10000 | 10000 | 10000 |  |  |  |  |  |  |  |  | 625 | 625 | 625 | 625
 |  |  | Pioneer Press |  |  | In-page |  |  |  |  | 300x250 & 728x90 | ROS | _ |  | 01 |  |  |  |  |  |  |  | CPM |  |  | 15000
 |  |  | Star Tribune |  |  | In-page |  |  |  |  | 300x250 & 728x90 | ROS | _ |  | 02 |  |  |  |  |  |  |  | CPM |  |  | 15000
 |  |  | Real Media |  |  | In-page |  |  |  |  | 300x250 & 728x90 | ROS | _ |  | 03 |  |  |  |  |  |  |  | CPM |  |  | 35000
 |  |  | Undertone |  |  | In-page |  |  |  |  | 300x250 & 728x90 | ROS | _ |  | 04 |  |  |  |  |  |  |  | CPM |  |  | 35000
 |  |  | Pandora |  |  | In-page |  |  |  |  | 300x250 & 728x90 | ROS | _ |  | 05 |  |  |  |  |  |  |  | CPM |  | 5 | 45000 | 9000000
 |  |  | [NAME] |  |  | In-page |  |  |  |  | 300x250 & 728x90 | ROS | _ |  | 06 |  |  |  |  |  |  |  | CPM |  | 7.06 | 12000 | 1700000
 |  |  | Social |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Subtotal:
 |  |  | Search |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  | [NAME] (.027) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | To calculate Serving fee, replace "0" with links to cost of ROS banners |  | [NAME] | 0
 |  |  | [NAME] (1.75)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Spent:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Budget: | 170000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reserve:
Spreadsheet: robin_rodrigue__33258__HS_STORAGE
Sheet: Exotics

 |  |  |  |  | Total
Month | Delta A | Delta B | Total |  | Volume
 |  |  |  |  |  |  |  |  |  |  |  |  | 155297
Total
Spreadsheet: 159974d1338916641-creating-a-summary-page-from-multiple-worksheets-ordertest
Sheet: Weco Order

To: |  |  |  | Attn:
Fax: |  |  |  | Ph#:
FROM: | J.D. WISNER ELECTRIC |  |  | DATE:
 | 3704 Aurelius Rd.
 | Lansing, MI 48910
 | Ph: [PHONE]  Fax: [PHONE] |  |  | QUOTE#:
INSTRUCTIONS:
Part # | Size | Description | Qty. | Price Ea. | Total |  | Wisner Use Only
 |  |  |  |  |  | Delivery | Date | Back
 |  |  |  |  |  | Time | Received | Ordered
JOB #: |  |  | SUB TOTAL:
JOB NAME: |  |  | FREIGHT:
 |  |  |  | TAX:
APPROVED TO |  |  | TOTAL COST:
ORDER BY:
DATE:
Spreadsheet: 45070d1243863560-using-boolean-to-compile-knowledge-flags
Sheet: Africa

Country | Sent | Received | Location | Contact | Notes
Barbados
Benin
Botswana
Burkino Faso
Burunoi
Cameroon
Cote d' Ivoire (Ivory Coast)
Dominican Republic of Congo
Egypt
Ethiopia
Gambia
Ghana
Kenya
[NAME]
Liberia
[NAME]
[NAME]
Morocco
Mozambique
Namibia
[NAME]
Nigeria
Rwanda
Seychelles
Sierra Leone
Sudan
Swaziland
Tanzania
Togo
Uganda
Zaire
Zambia
Zimbabwe
Spreadsheet: 760345d1640162468-find-duplicates-and-changes-in-column-b-from-unique-text-in-column-a-sample-data-student-and-class-list
Sheet: Sheet1

Customer ID | Class Name | Data Explanation
123456 | Saturday 11:00 Junior B1 Term 2-2021 | Student A Initial Data - Start of term
123456 | Sunday 12:00 Junior B1 Term 2-2021 | Student A Mid term change of class
125256 | Sunday 13:45 Junior B1 Term 2-2021 | Student B a new mid term registered student
292871 | Sunday 12:00 Junior B1 Term 2-2021 | Student C Initial Data - Start of term
292871 | Sunday 13:45 Junior B1 Term 2-2021 | Student C Mid term change of class
333545 | Sunday 13:45 Junior B1 Term 2-2021 | Student D Initial Data - Start of term
333545 | Sunday 12:00 Junior B1 Term 2-2021 | Student D Mid term change of class
565543 | Saturday 11:00 Junior B1 Term 2-2021 | Student E Initial Data - Start of term
565543 | Saturday 11:00 Junior B1 Term 2-2021 | Student E NO CHANGES IN CLASS BOOKING
654321 | Monday 16:30 Senior [NAME] 2-2021 | Student F Initial Data - Start of term
654321 | Monday 16:30 Senior [NAME] 2-2021 | Student F who did not make any changes
Spreadsheet: 491121d1480330401-interpolate-values-in-a-list-book1
Sheet: Sheet1

Header | Header
2
3
6
1
2