tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 733652d1621686167-change-a-number-into-text-with-the-use-of-currency-number-format-currency
Sheet: Sheet1

I am asking for a formula to change a number into text with the use of currency number format.
Reporting Currency: |  |  |  |  | USD |  |  | Reporting Currency: |  |  |  |  | ZWL |  |  | Reporting Currency: |  |  |  |  | ZAR
Date | Description | Reference | Revenue | Expense | Balance |  |  | Date | Description | Reference | Revenue | Expense | Balance |  |  | Date | Description | Reference | Revenue | Expense | Balance
Balance Brought Forward |  |  |  |  | 2345 |  |  | Balance Brought Forward |  |  |  |  | 3000 |  |  | Balance Brought Forward |  |  |  |  | 1000
2021-01-06 00:00:00 | [NAME] | 1 | 3000 |  |  |  |  | 2021-01-06 00:00:00 | [NAME] | 1 | 3000 |  |  |  |  | 2021-01-06 00:00:00 | [NAME] | 1 | 3000
2021-01-23 00:00:00 | OK MART | 2 | 2000 | 1450 |  |  |  | 2021-01-23 00:00:00 | OK MART | 2 | 2000 | 1450 |  |  |  | 2021-01-23 00:00:00 | OK MART | 2 | 2000 | 1450
2021-01-23 00:00:00 | Jonnes | 3 | 40000 |  |  |  |  | 2021-01-23 00:00:00 | Jonnes | 3 | 40000 |  |  |  |  | 2021-01-23 00:00:00 | Jonnes | 3 | 40000
2021-01-23 00:00:00 | [NAME] | 4 | 3800 |  |  |  |  | 2021-01-23 00:00:00 | [NAME] | 4 | 3800 |  |  |  |  | 2021-01-23 00:00:00 | [NAME] | 4 | 3800
Desired Solution
CASH ON HAND
Cash held in ZWL Account (as at23/01/21 |  |  |  |  | ZWL50,350.00
Cash held in USD Account (as at23/01/21 |  |  |  |  | USD49,695.00
Cash held in ZAR Account (as at23/01/21 |  |  |  |  | ZAR48,350.00
Spreadsheet: 474627d1470837898-update-quantity-in-a-cell-after-recording-a-sale-sales
Sheet: Sales

S No | Date | Design No | Description | P Price | Price | Qty | Total | Postage | Packaging | Paypal | Ebay | Profit
3 | Tulip BLK | Toursers | 4.5 | 18 | 2 | 36 | 4.4 | 0.12 | 0.8300000000000001 | 1.8 | 6.350000000000001
2 |  | Tulip CRM | Toursers | 15 | 100 | 2 | 200 | 4.4 | 0.12 | 3.7 | 10 | 66.77999999999999
1 |  | N25 | Earring Tikka | 1 | 2.9 | 100 | 290 |  |  | 3.7 | 10 | 83.39999999999999
Spreadsheet: 779090d1651583817-sum-datas-by-date-across-different-sheets-sample
Sheet: January

Date | Sales
2022-01-01 00:00:00 | 1
2022-01-02 00:00:00 | 1
2022-01-03 00:00:00 | 1
2022-01-04 00:00:00 | 1
2022-01-05 00:00:00 | 1
2022-01-06 00:00:00 | 1
2022-01-07 00:00:00 | 1
2022-01-08 00:00:00 | 1
2022-01-09 00:00:00 | 1
2022-01-10 00:00:00 | 1
2022-01-11 00:00:00 | 1
2022-01-12 00:00:00 | 1
2022-01-13 00:00:00 | 1
2022-01-14 00:00:00 | 1
2022-01-15 00:00:00 | 1
2022-01-16 00:00:00 | 1
2022-01-17 00:00:00 | 1
2022-01-18 00:00:00 | 1
2022-01-19 00:00:00 | 1
2022-01-20 00:00:00 | 1
2022-01-21 00:00:00 | 1
2022-01-22 00:00:00 | 1
2022-01-23 00:00:00 | 1
2022-01-24 00:00:00 | 1
2022-01-25 00:00:00 | 1
2022-01-26 00:00:00 | 1
2022-01-27 00:00:00 | 1
2022-01-28 00:00:00 | 1
2022-01-29 00:00:00 | 1
2022-01-30 00:00:00 | 1
2022-01-31 00:00:00 | 1
Spreadsheet: 5fe2f425-74b2-4e80-9ba7-1aaad1b6ccc8
Sheet: Sheet1

SCOUT TROOP | 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
2010 BUDGET
 |  |  |  |  |  |  |  |  |  |  | INCOME AMOUNT
INCOME |  |  |  |  |  |  |  |  |  |  | Stake | Ward Budget | Flags | Scouts
1 | Stake Contribution | 12 | Scouts | + | 4 | Leaders | x | 15 | Each | = | 240
2 | Ward Budget | 12 | Scouts |  |  |  | x | 100 | Each | = |  | 1200
3 | Troop Flag Project |  |  |  | 80 | Flags | x | 35 | Each | = |  |  | 2800
4 | Scouts
 | Boys Life | 12 | Scouts |  |  |  | x | 12 | Each | = |  |  |  | 144
 | Scouts Food | 10 | Camps | x | 10 | Scouts | x | 8 | Each | = |  |  |  | 800
 | 11 Year Old Scouts Food | 2 | Camps | x | 2 | Scouts | x | 8 | Each | = |  |  |  | 32
 |  |  |  |  |  |  |  | TOTAL INCOME |  |  | 240 | 1200 | 2800 | 976
 |  |  |  |  |  |  |  |  |  |  | EXPENSE AMOUNT-PAID BY
EXPENSES |  |  |  |  |  |  |  |  |  |  | Stake | Ward Budget | Flags | Scouts
1 | Registration | 16 | People |  |  |  | x | 15 |  |  | -240
2 | Boys Life | 12 | Scouts |  |  |  | x | 12 | Each | = |  |  |  | -144
 |  | 2 | Leaders |  |  |  | x | 12 | Each | = |  | -24
3 | Awards & Leadership Patches |  |  |  | 12 | Scouts | x | 22 | Each | = |  | -264
4 | Summer Camp
 | Fees |  |  |  | 10 | Scouts | x | 130 | Each | = |  |  | -1300
 | Transportation (gas) | 3 | Cars | x | 200 | [NAME] | x | 0.15 | Mile | = |  |  | -90
 | Food |  |  |  | 10 | Scouts | x | 75 | Each | = |  |  | -750
 |  |  |  |  | 2 | Leaders | x | 75 | Each | = |  |  | -150
5 | 11 Year Old Camps(Tracy)
 | Fees |  |  |  | 2 | Scouts | x | 62 | Each | = |  | -124
 | Food | 2 | Camps | x | 2 | Leaders | x | 8 | Each | = |  | -32
 |  | 2 | Camps | x | 2 | Scouts | x | 8 | Each | = |  |  |  | -32
6 | Camporees (2)
 | Fees | 2 | Camps | x | 10 | Scouts | x | 10 | Each | = |  | -200
 | Transportation (gas) | 2 | Cars | x | 150 | [NAME] | x | 0.15 | Mile | = |  | -45
 | Food | 2 | Camps | x | 10 | Scouts | x | 8 | Each | = |  |  |  | -160
 |  | 2 | Camps | x | 2 | Leaders | x | 8 | Each | = |  | -32
7 | [NAME]
 | Transportation (gas) | 2 | Cars | x | 800 | [NAME] | x | 0.15 | Mile | = |  | -240
 | Food | 8 | Camps | x | 10 | Scouts | x | 8 | Each | = |  |  |  | -640
 |  | 8 | Camps | x | 2 | Leaders | x | 8 | Each | = |  | -128
8 | Equipment
 | Leadership Materials, Merit Badge Books |  |  |  |  |  |  |  |  |  |  | -111
 | Camping Equipment |  |  |  |  |  |  |  |  |  |  |  | -360
 | Flag Replacement |  |  |  |  |  |  |  |  |  |  |  | -150
 |  |  |  |  |  | TOTAL EXPENSES |  |  |  |  | -240 | -1200 | -2800 | -976
 |  |  |  |  |  | BALANCES |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | Total Budget |  |  |  |  | 5216
 | An optional week long Junior Leader [NAME] camp (Silver Moccasin), is available for $185.00.
Spreadsheet: 0a805602-a27a-4620-9383-c5440c47562a
Sheet: 3

 | January 3 | January 10 | January 17 | January 24 | January 31
Total Interest Rate* | 10717 | 29110 | 22666 | 21259 | 17133.5
Cleared** | 7228 | 19903 | 14178 | 14647 | 13755.5
Uncleared | 3489 | 9207 | 8488 | 6612 | 3378
Total Cross-Currency | 447 | 1357 | 1482 | 1588 | 506
Cleared | 0 | 0 | 0 | 0 | 0
Uncleared | 447 | 1357 | 1482 | 1588 | 506
Total Credit | 3358 | 6800 | 6809 | 7433 | 11901.5
Cleared | 1740 | 4946 | 4891 | 6657 | 10550.5
Uncleared | 1618 | 1854 | 1918 | 776 | 1351
Total FX | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | 14522 | 37267 | 30957 | 30280 | 29541
Weekly total, swap ticket volumes by asset class and cleared status (number of new trades), all products, tenors, and participant types. For cleared swaps, this table reflects the creation of only one of the two swaps that results from the clearing process. All price-forming trade events, including new trades, terminations, amendments, and novations, are included in ticket volumes.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 174723d1345157599-comparing-weighted-values-goal-comparison
Sheet: Sheet1

Name | Units Sold | Goal | raw units over goal | weight | Weighted units over goal
[NAME] | 450 | 375
[NAME] | 300 | 225
[NAME] | 565 | 500
Moe | 360 | 300
Curly | 145 | 100
[NAME] | 130 | 100
[NAME] | 275 | 250
[NAME] | 500 | 475
[NAME] | 350 | 325
Phoebe | 620 | 600
Rachel | 230 | 225
[NAME] | 480 | 475
 | Average Goal:
Spreadsheet: 87851d1287712003-duplicate-data-from-master-to-other-sheets-without-named-range-bikini_bottom_publications
Sheet: ProjectSummary

Project Title or Description | Project Type | Project Lead | Team Member | Team Member | Printed Product? | Planned Start | Planned End | Total Workdays Allotted | Actual Start | Days Elapsed Since Start | Actual End | Total Workdays Used | Status
Big book | Documentary history | Squarepants, Spongebob | [NAME], Sandy |  | Y | 2011-05-01 00:00:00 | 2012-05-01 00:00:00 | 262 | 2010-10-21 00:00:00 | 1 |  | n/a | In Progress
Big reference book | Reference work | Starfish, [NAME] | Tentacles, Squidward |  | Y | 2010-12-01 00:00:00 | 2011-03-01 00:00:00 | 65 |  | n/a |  | n/a | Not Started
Tasker 1 | Tasker | Squarepants, Spongebob |  |  | N | 2010-09-30 00:00:00 | 2010-10-01 00:00:00 | 2 | 2010-09-30 00:00:00 | 16 | 2010-10-04 00:00:00 | 3 | Completed
Web post 1 | Web post | Tentacles, Squidward |  |  | N | 2010-10-10 00:00:00 | 2010-10-10 00:00:00 | 0 | 2010-10-08 00:00:00 | 10 | 2010-10-10 00:00:00 | 1 | Completed
[NAME] | [NAME] | Snail, Gary | Snail, Gary |  | N | 2010-10-11 00:00:00 | 2010-10-14 00:00:00 | 4 | 2010-10-12 00:00:00 | 8 | 2010-10-13 00:00:00 | 2 | Completed
Point paper 1 | Point paper | Starfish, [NAME] |  |  | N | 2011-01-01 00:00:00 | 2011-02-02 00:00:00 | 23 |  | n/a |  | n/a | Not Started
Spreadsheet: 188645d1350939099-question-in-regard-to-solver-fantasy_player
Sheet: Sheet1

 |  |  |  |  | Binary matix |  |  |  | Points matrix |  |  |  | Cost matrix
 |  |  |  | QB | RB | WR |  | QB | RB | WR |  | QB | RB | WR
 |  |  | [NAME] | 1 | 0 | 0 |  | 13 |  |  |  | 10
 |  |  | [NAME] | 0 | 0 | 0 |  | 12 |  |  |  | 8
 |  |  | D. Harris- | 0 | 1 | 0 |  |  | 8 |  |  |  | 12
 |  |  | J. Sanders- | 0 | 0 | 0 |  |  | 10 |  |  |  | 14
 |  |  | D. Douglas- | 0 | 0 | 0 |  |  |  | 7 |  |  |  | 16
 |  |  | J. Sanders- | 0 | 0 | 1 |  |  |  | 9 |  |  |  | 18
 |  |  |  | 1 | 1 | 1
 |  | Object funk | 30 |  | [NAME] points
 |  | Constraint 1 | 40 |  | = | 40 | [NAME] money to spend
 |  | Constraint 2 |  | 1 | 1 | 1
 |  | QB | [NAME]
 |  | RB | D. Harris-
 |  | WR | J. Sanders-
Spreadsheet: theresa_staab__39617__Gas Avails Restricted flows - Dec  2001
Sheet: Sheet1

Gas Avails. - Powder River
2001-12-01 00:00:00
Preliminary
 | Mcf |  |  |  | Mmbtu | MMBtu |  |  | Allocated | Allocated | Allocated
 | Wellhead |  |  |  | Wellhead | Less fuel |  |  | mmBtu  at | mmBtu  at | mmcf  at
 | Nomination | Firm Capacity | IT | Btu Factor | Confirmation | to Glennrock |  |  | Glennrock | Wellhead | Wellhead
[NAME]/So. Kitty/Maverick
Kennedy #1 | 3900 |  |  | 0.958
Kennedy #2 | 3700 |  |  | 0.956
Kennedy #3 | 2700 |  |  | 0.953
Kennedy #4 | 3600 |  |  | 0.955
Kennedy Box Draw Total
S. Kitty #1 | 4300 |  |  | 0.96
S. Kitty #2 | 9900 |  |  | 0.959
S. Kitty #3 | 4300 |  |  | 0.959
S. Kitty #4 | 9100 |  |  | 0.949
S. Kitty #5 | 3600 |  |  | 0.954
Kennedy S. Kitty Total
Kennedy Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2000
Wellstar #1 | 9000 |  |  | 0.93
Wellstar #2 | 1000 |  |  | 0.926
Wellstar Box Draw Total
Box Draw Total
[NAME]
Clydesdale
Clydesdale #1 | 4500 |  |  | 0.942
Clydesdale #2 | 4000 |  |  | 0.951
Clydesdale #3 | 3100 |  |  | 0.945
Phillips Clydesdale Total
Caballo
MTG | 675 |  |  | 0.945
[NAME] | 850 |  |  | 0.938 |  |  |  |  | 0 | 0 | 0
Palomino #1 | 2000 |  |  | 0.936
Palomino #2 | 1900 |  |  | 0.939
Geer #1 | 1300 |  |  | 0.925
Phillips Palomino Total
Quantum | 0 |  |  | 0.967
Independent | 18000 |  |  | 0.937
Caballo Total
TOTAL ENA |  |  |  |  |  |  |  | Fixed Volume at Glennrock | 49053
Phillips Total Production
[NAME]
Wellstar
Independent Actual Flow | 15500
Spreadsheet: 870083d1716594591-dynamically-copy-filter-rows-to-another-sheet-based-on-multiple-criteria-dynamically-copyfilter-rows-to-another-sheet-based-on-multiple-criteria2
Sheet: Hanging

 | FLOOR | RC | UNIT TYPE | TOT SF CEILING | TOT SF | 12 C | 12X | 10X | 9X | 9MR | 8TILE | 8SOFF | UNIT | FINISHER $/SF | FINISHER | FINISHER PAY | FINISHER PAID
Building # 2 (24) | 2 FLOOR | 0 | A2 | 702 | 2878 | 15 | 0 | 0 | 50 | 6 | 3 | 2 | 2205 | 0.15 | [NAME] | 432 | Green
Building # 2 (24) | 3 FLOOR | 1 | A4 | 766 | 2942 | 16 | 0 | 0 | 50 | 6 | 3 | 2 | 2303 | 0.15 | [NAME] | 441 | Green
Building # 2 (24) | 1 FLOOR | 1 | B1 | 1090 | 4550 | 23 | 0 | 0 | 80 | 9 | 6 | 2 | 2101 | 0.15 | [NAME] | 683 | Green
Spreadsheet: 125928d1319395110-filter-multiple-criteria-in-table-book1
Sheet: Sheet1

 | Orange
 | Blue
 | Mango
 | Gold
 | Name | Location | Colour | Number | Period
 | [NAME] | London | Red | 12 | Night
 | [NAME] | Lisbon | Yellow | 26 | Day
 | Philip Jones | Quarter | Gold | 49 | Day
 | [NAME] | Rome | Silver | 8 | Day
Spreadsheet: 728733d1618591683-if-value-from-one-column-matches-current-column-then-insert-text-book1
Sheet: Sayfa1

 |  |  |  | URLS | Y/N
 |  |  |  | cheat.com
 |  |  |  | tray.com
 |  |  |  | lackadaisical.com
 |  |  |  | bag.com
 |  |  |  | hellish.com
 |  |  |  | object.com
 |  |  |  | collar.com
 |  |  |  | distinct.com
 |  |  |  | capricious.com
 |  |  |  | null.com
 |  |  |  | produce.com
 |  |  |  | deserted.com
 |  |  |  | pencil.com
 |  |  |  | slip.com
 |  |  |  | strip.com
 |  |  |  | cautious.com
 |  |  |  | guide.com
 |  |  |  | jaded.com
 |  |  |  | tow.com
 |  |  |  | graceful.com
 |  |  |  | irate.com
 |  |  |  | oatmeal.com
 |  |  |  | snail.com
 |  |  |  | guitar.com
 |  |  |  | melted.com
 |  |  |  | horrible.com
 |  |  |  | testy.com
 |  |  |  | dance.com
 |  |  |  | hammer.com
 |  |  |  | wheel.com
Spreadsheet: 850633d1701037273-regression-analysis-regration-analysis
Sheet: Table

Born | Workplace | Question 1 | Question 2A | Question 2B | Question 3A | Question 3B | Question 3C | Question 3D | Question 3E
Bangladesh | Estonia | 4 | 1 | 3 | 1 | 1 | 4 | 4 | 3
Bangladesh | Estonia | 2 | 3 | 5 | 4 | 4 | 4 | 4 | 5
Estonia | Estonia | 3 | 5 | 2 | 4 | 4 | 3 | 3 | 1
USA | USA | 5 | 4 | 4 | 4 | 4 | 4 | 5 | 5
Bangladesh | Bangladesh | 4 | 4 | 4 | 3 | 3 | 4 | 4 | 4
Poland | Estonia | 3 | 3 | 3 | 4 | 4 | 2 | 3 | 3
USA | USA | 4 | 2 | 4 | 4 | 5 | 4 | 4 | 4
Bangladesh | Estonia | 3 | 4 | 5 | 5 | 3 | 5 | 5 | 5
Estonia | Estonia | 2 | 4 | 2 | 4 | 2 | 3 | 3 | 3
Spreadsheet: 537826d1505291827-need-formula-assistance-need-formula-assistance-formula-vlookup
Sheet: Sheet1

Head | [NAME] | Loc2 | Loc3 | Loc4 | Loc5 | Loc6 | Loc7 | Loc8 | Loc9 | Loc10 | Loc11 | Loc12 | Loc13 | Loc14
AXA | KARACHI  [I] | KARACHI  [E] | MUNDRA  [E] | SOHAR  [E] | JEBEL ALI  [E] | BAHRAIN  [E] | SHUAIBA  [E] | UMM QASR  [E] | UMM QASR  [I] | BAHRAIN  [I] | ABU DHABI  [I] | [NAME]  [I] | JEBEL ALI  [I] | SOHAR  [I]
AXA
 | Export | Import
??? | Data should be in continuous order. Need to avoid the gap in between the data
Spreadsheet: 826516d1682064490-data-analysis-problem-cleaning-data-into-a-table-help-dataplast-order-page-example
Sheet: Sheet1

Product | S1 | P1 | S2 | P2 | S3 | P3 | [NAME] | P4 | S5 | P5 | S6 | P6 | S7 | P7 | S8 | P8 | S9 | P9 | S10 | P10
[NAME]mg tablets 28 | Sigma | 0.16 | Phoenix | 0.17 | Ethigen | 0.17 | Sigma1 | 0.19 | AAH | 0.21 | Bestway | 0.21 | OTCDirect | 0.22 | Medihealth | 0.22 | Trident | 0.23 | Unichem | 0.26
Atorvastatin 20mg tablets 28 | AAH | 0.4 | Ethigen | 0.4 | Trident | 0.41 | Phoenix | 0.42 | Bestway | 0.42 | Medihealth | 0.5 | Unichem | 0.55 | OTCDirect | 0.55 | Sigma | 0.61 | Sigma1 | 0.63
[NAME]mg tablets 28 | Phoenix | 0.45 | Sigma | 0.48 | Bestway | 0.49 | Sigma1 | 0.49 | AAH | 0.5 | Ethigen | 0.5 | Medihealth | 0.5 | Trident | 0.52 | Sigma2 | 0.56 | Unichem | 0.59
[NAME]mg tablets 28 | Phoenix | 0.82 | AAH | 0.82 | Sigma | 0.82 | Ethigen | 0.85 | Trident | 0.86 | Medihealth | 0.89 | Unichem | 0.91 | OTCDirect | 0.91 | Sigma1 | 0.97 | Sigma2 | 0.97
Product | Sigma | Phoenix | Ethigen | Sigma1 | AAH | Bestway | OTCDirect | Medihealth | Trident | Unichem
[NAME]mg tablets 28 | 0.16 | 0.17 | 0.17 | 0.19 | 0.21 | 0.21 | 0.22 | 0.22 | 0.23 | 0.26
Atorvastatin 20mg tablets 28 | 0.61 | 0.42 | 0.4 | 0.63 | 0.4 | 0.42 | 0.55 | 0.5 | 0.41 | 0.55
[NAME]mg tablets 28 | 0.56 | 0.45 | 0.5 | 0.49 | 0.5 | 0.49 | - | 0.5 | 0.52 | 0.59
[NAME]mg tablets 28 | 0.82 | 0.82 | 0.85 | 0.97 | 0.82 | - | 0.91 | 0.89 | 0.86 | 0.91
Spreadsheet: 874935d1721454244-plug-comment-late-after-8-40-am-if-formula-with-time
Sheet: Sheet1

 | 2024-07-19 00:00:00
 | MANJI | HEAD | 08:39:00
 | ABDUL | MAN1 | 08:37:00
 | SIMON | [NAME] | 09:05:00 | LATE
 | HAJI |  | 09:00:00 | LATE
 | ALI |  | 09:00:00 | LATE
 | EZE |  | 06:00:00
 | JIMMY |  | 08:47:00
 | KENNY |  | 09:00:00 | LATE
 | LISTA |  | 09:30:00 | LATE
 | MUHIDINI |  | 09:00:00 | LATE
 | 2024-07-20 00:00:00
 | MANJI | HEAD | 08:28:00
 | ABDUL | MAN1 | 08:36:00
 | SIMON | [NAME] | 08:38:00
 | HAJI |  | 06:00:00
 | ALI
 | EZE |  | 06:00:00
 | JIMMY
 | KENNY
 | LISTA
 | MUHIDINI |  | 08:36:00
Spreadsheet: 115118d1310735804-extract-unique-data-and-concatenate-book
Sheet: ALL ITEM 

No. | ItemCode | Description | DATE
1 | A-456-11 | #N/A | 2011-07-04 00:00:00
2 | B-457-11 | #N/A | 2011-07-06 00:00:00
3 | C-458-11 | #N/A | 2011-07-08 00:00:00
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
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
Spreadsheet: 685796d1594203521-matching-cash-received-against-corresponding-invoice-excel-sheet
Sheet: Sheet1

 | SALES INCOME LEDGER
Date | Code | Name | Invoice
2020-02-01 00:00:00 | US001 | [NAME] | A0001
2020-02-02 00:00:00 | US-0002 | [NAME] | A0002
2020-02-03 00:00:00 | US-0003 | [NAME] | A0003
 | ACCOUNTS RECEIVEABLE LEGER
Date | Invoice | Dr | Cr | Balance
C001 | [NAME]
2020-07-03 00:00:00 | US-0001 | 4000
2020-06-01 00:00:00 | US-0003 | 2000
Date | Invoice | Dr | Cr | Balance
C002 | [NAME]
2020-07-03 00:00:00 | US-0002 | 4000
2020-01-01 00:00:00 | US-0002 | 3000
2020-06-01 00:00:00 | US-0003 | 200000
Spreadsheet: 89879d1289605226-sumif-question-book2
Sheet: Sheet1

 |  |  | PBA-1-L | LATCH HOUSING UNIT LEFT MACHINED ALUMINUM | EMJ |  | 6.5 | 1
 |  |  | PBA-1-R | LATCH HOUSING UNIT RIGHT MACHINED ALUMINUM | EMJ |  | 6.5 | 1
 |  |  | PBA-2 | HOOK LATCH | Cutters |  | 0.5 | 2
 |  |  | PBA-2.3 | HOOK LATCH- ZINC PLATING | [NAME] |  | 0.25 | 2
 |  |  | PBA-3 | C LATCH | Cutters |  | 0.5 | 2
 |  |  | PBA-3.3 | C LATCH CHROME PLATING | [NAME] |  | 0.42 | 2
 |  |  | PBA-4 | Black Plastic Nylon BUTTON | Pacific Injection Molding |  | 0.5 | 1
 |  |  | PBA-5 | Black Plastic Nylon washer | Pacific Injection Molding
 |  |  | PBA-6 | #10-24x1/4ssbsh/np | Fastenal |  | 0.48 | 6
 |  |  | PBA-7 | Spring for C Latch | Fastenal |  |  | 2
 |  |  | PBA-8 | Spring for Hook Latch | Fastenal |  |  | 2
 |  |  | PBA-1-L.1 | LATCH HOUSING UNIT LEFT CHROMING | [NAME] |  |  | 1 | 100
 |  |  | PBA-1-R.1 | LATCH HOUSING UNIT RIGHT CHROMING | [NAME] |  |  | 1 | 100
 |  |  | PBA-1-L.2 | LATCH HOUSING UNIT LEFT PC- MATTE BLACK | Mt. Baker Powder Coating |  |  | 1 | 1000
 |  |  | PBA-1-R.2 | LATCH HOUSING UNIT RIGHT PC- MATTE BLACK | Mt. Baker Powder Coating |  |  | 1 | 1000
 |  |  |  |  |  |  | total
Spreadsheet: 732702d1621174952-expected-output-based-on-3-dropdowns-sample-workbook-with-multiple-criteria
Sheet: 0213189

CAAS | Recon AU | SSR | Ownership | Template Name | Reconciler | Status | Reviewer | Approved
5 | 0213189 | Yes | DEF | 1234 | MR. A | Complete | abcde | No
6 | 0213189 | Yes | GHI | 5647 | MR. B | RNR | afjljdf | Yes
8 | 0213189 | Yes | BCD | 6523 | MR. C | WNS | ajflkdj | No
9 | 0213189 | Yes | ABC | 1321 | MR. A | Complete | fjaiuo | No
10 | 0213189 | Yes | GHI | 2561 | MR. C | RNR | fawuer | Yes
45 | 0213189 | Yes | GHI | 6532 | Mr. [NAME] | Complete | worujk | Yes
Spreadsheet: 713304d1610641482-display-data-from-the-first-column-for-those-who-dont-have-n-a-in-the-second-column-sample-1-
Sheet: Sheet1

User full name | Number of seen books | Completed? | Those who completed - how many books?
Filipe Torrado | 0
Anke Bellens | 4
[NAME] | 4
[NAME] | 0
Quinten Croes | 4
Esteban [NAME] | 0
Akash Shah | 4
[NAME] | 1
[NAME] | 4
[NAME] | 0
[NAME] | 1
Spreadsheet: darrell_schoolcraft__7307__imball0201
Sheet: williams

 | Milagro |  | La Maquina |  | [NAME] |  | [NAME]
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  | San Juan
1 | 265797 | 254322 | 39793 | 37941 | 27327 | 49663 | 98034 | 88072 |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
2 | 277624 | 290502 | 41157 | 40713 | 43302 | 49663 | 99079 | 82401 |  |  |  | [NAME] |  |  | -34361 |  | 25006
3 | 307171 | 315078 | 38099 | 38046 | 47670 | 45711 | 136447 | 129393 |  |  |  | 2000-12-01 00:00:00 | 19698194 | 19662410 |  | 7.95
4 | 279408 | 308260 | 36601 | 41864 | 43971 | 44545 | 131671 | 130882 |  |  |  | 2001-01-01 00:00:00 | 18949781 | 18975457 |  | 8.1
5 | 175341 | 160910 | 27297 | 42530 | 42548 | 42645 | 139863 | 137699 |  |  |  | 2001-02-01 00:00:00 | 15256233 | 15290953 |  | 5.61
6 | 302844 | 303238 | 49893 | 35667 | 28841 | 42645 | 132071 | 128281 |  |  |  | 2001-03-01 00:00:00 | 17049350 | 17089226 |  | 4.87
7 | 310245 | 304796 | 37271 | 35667 | 33623 | 44142 | 130811 | 129521 |  |  |  | 2001-04-01 00:00:00 | 17652369 | 17743987 |  | 4.62
8 | 303756 | 304570 | 36021 | 35667 | 41946 | 42720 | 105839 | 117742 |  |  |  | 2001-05-01 00:00:00 | 16124989 | 16282021 |  | 3.44
9 | 292995 | 286176 | 41960 | 42041 | 42165 | 43615 | 106152 | 104559 |  |  |  | 2001-06-01 00:00:00 | 15928675 | 15936227 |  | 2.58
10 | 316062 | 311012 | 41004 | 38434 | 42602 | 43615 | 130628 | 126730 |  |  |  | 2001-07-01 00:00:00 | 16669639 | 16693576 |  | 2.45
11 | 312745 | 310787 | 40954 | 39920 | 42342 | 43615 | 120871 | 118898 |  |  |  | 2001-08-01 00:00:00 | 17850737 | 17815859 |  | 2.61
12 | 318188 | 317298 | 40993 | 39423 | 45440 | 43615 | 119456 | 122363 |  |  |  | 2001-09-01 00:00:00 | 16552948 | 16508018 |  | 1.73
13 | 324008 | 324208 | 41446 | 40674 | 44799 | 49115 | 125758 | 123746 |  |  |  | 2001-10-01 00:00:00 | 17924814 | 17872479 |  | 2.06
14 | 310479 | 307199 | 42030 | 40772 | 45484 | 47542 | 131012 | 128288 |  |  |  | 2001-11-01 00:00:00 |  |  |  | 1.98
15 | 290862 | 273401 | 41858 | 41317 | 44939 | 46913 | 123364 | 124424 |  |  |  | 2001-12-04 00:00:00
16 | 315187 | 318355 | 41948 | 42502 | 43146 | 48615 | 130089 | 133203
17 | 306228 | 315134 | 38819 | 42762 | 47048 | 48615 | 140278 | 137918
18 | 314325 | 308834 | 34315 | 42205 | 43287 | 48505 | 135595 | 130464
19 | 310482 | 289905 | 22017 | 35667 | 39712 | 48497 | 139137 | 137882 |  |  |  |  |  |  | 1.98
20 | 286477 | 293201 | 35547 | 35667 | 43888 | 48505 | 147895 | 141348 |  |  |  |  | 1378106 | 1316146
21 | 313108 | 312195 | 36330 | 35667 | 34101 | 48505 | 157490 | 140887 |  |  |  |  | 9216070 | 9272400
22 | 305636 | 310653 | 41707 | 39898 | 47395 | 46090 | 144567 | 142187 |  |  |  |  | 3546065 | 3512740
23 |  |  |  |  |  |  |  |  |  |  |  |  | 1623705 | 1620245
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  |  |  |  |  |  |  | 0
2002-01-22 00:00:00
CBS Dollars
 |  |  | 0
 |  |  | 300359.04
 |  |  | -250735.54
 |  |  | 44931.54
 |  |  | 2153062.32
 |  |  | 0.0238
 |  |  | 0.0153
 |  |  | 2444.99
 |  |  | 250
Spreadsheet: 08f08561-ffd6-41f0-8201-04cfa715294c
Sheet: FY 2014 Deadlines

Payroll and Approval FY 2014 Deadlines |  |  |  |  |  |  |  |  | Start Over
Pay Period | Effective Dates |  |  | Pay Date (Friday) | **EPAF Deadline (Tuesday) | Timesheets Available 12:01 AM (Sunday) | ***Approval Deadline Tuesday 5:00pm
15 | 2013-06-23 00:00:00 | - |  |  |  |  |  |  | Back to Payroll Calendars
16 |  | -
17 |  | -
18 |  | -
19 |  | -
20 |  | -
21 |  | -
22 |  | -
23 |  | -
24 |  | -
25 |  | -
26 |  | -
1 |  | -
2 |  | -
3 |  | -
4 |  | -
5 |  | -
6 |  | -
7 |  | -
8 |  | -
9 |  | -
10 |  | -
11 |  | -
12 |  | -
13 |  | -
14 |  | -
**EPAF deadlines are subject to change according to the holiday schedules
***This deadline may differ with departments, not to be any later than the Tuesday 5:00pm deadline.