tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 705864d1606340747-if-a1-does-not-equal-today-go-to-next-d1-etc-move-to-next-date
Sheet: PSSA

 |  |  |  | 2020
 |  |  |  | December
 | Column2 | Column3 | Column4 | Column5 | Completed | 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
 |  |  |  |  |  | ,=IF($I$4>=TODAY(),$I$4,$P$4)
Spreadsheet: 164759d1340884866-excel-2007-returning-actual-cell-values-from-the-array-of-index-and-the-look-up-of-match-example-1-
Sheet: Sheet1

New Pricelist |  |  | Old Catalog |  |  |  | Unused
[NAME] | price |  | [NAME] | price | is in stock |  | [NAME] | price | is in stock
 |  |  | a123 | 40 | 1 |  | a456 | 0 | 0
c456 | 200 |  | b123 | 5 | 1
a123 | 21 |  | c456 | 210 | 1
b789 | 10 |  | d789 | 5 | 1
d789 | 20 |  | a456 | 14 | 1
a789 | 12 |  | b789 | 12 | 1
 |  |  | New Catalog
 |  |  | [NAME] | price | is in stock
Spreadsheet: 676489d1588839100-how-to-conditional-format-a-symbol-trading-dashboard
Sheet: Portfolio

Counter | Holding Shares | Average Cost (SGD) | Average Price | Market Price | Unrealised Profit/Loss (SGD/USD) |  |  | Sold Positions (SGD)
 |  |  |  |  | Market Value | Profit/Loss | % | Bought Value | Sold Value | Profit/Loss
BNO |  |  |  | 8.16
SDOW |  |  |  | 34.48
 |  |  |  |  |  |  | ROI | 25000
Spreadsheet: 782529d1654096752-different-date-durations-driving-yes-no-under-56-days-etaf-
Sheet: Sheet1

Date Emailed/Submitted to X | Confirmation from X Approved Date | No. Days between A & B | No. of days between A & G | Over 8 weeks?
2022-05-12 00:00:00
2022-05-06 00:00:00
2022-03-10 00:00:00 | 2022-05-09 00:00:00
2022-01-24 00:00:00
2022-01-20 00:00:00 | 2022-03-17 00:00:00
2022-01-18 00:00:00 | 2022-05-23 00:00:00
2022-02-01 00:00:00 | 2022-03-17 00:00:00
2022-02-01 00:00:00 | 2022-03-17 00:00:00
2022-04-01 00:00:00 | 2022-05-09 00:00:00
Spreadsheet: 02f54bd8-a7de-42e8-bd9c-4d056eac71ba
Sheet: Sheet1

Unnamed: 0 | credits | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
discipline | have | in prog | future | total
Biology | 0 | 0 | 10 | 10
Chemistry | 0 | 0 | 10 | 10
Computer Science | 0 | 0 | 5 | 5
Interdisciplinary | 0 | 0 | 5 | 5
Math | 0 | 0 | 10 | 10
Physics | 0 | 0 | 10 | 10
Additional science elective credits needed= |  |  | 45 | 50 | Total science credits
primary area - 30 credits |  |  |  |  |  |  | upper division 300/400 - 20 credits
 |  |  |  |  |  |  | TOTAL= | 0 | NEED= | 20
secondary area - 20 credits |  |  |  |  |  |  | upper division 300/400/appr200 - 10 credits
 |  |  |  |  |  |  | TOTAL= | 0 | NEED= | 10
Spreadsheet: 055d89c5-8076-467e-b342-b8f8ad09c190
Sheet: Sheet1

Table 5--Corn: Food, seed, and industrial use (million bushels), 7/15/2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Mkt year and qtr 1/ |  | High-fructose corn syrup (HFCS) | Glucose and dextrose | Starch | Alcohol for fuel | Alcohol for beverages and manufacturing | Cereals and other products | Seed | Total food, seed, and industrial use
2011/12 | Q1 Sep-Nov | 119.636 | 77.965 | 64.652 | 1266.691 | 33.302 | 50.732 | 0 | 1612.978
 | [NAME] | 115.001 | 73.338 | 62.025 | 1304.805 | 34.93 | 50.732 | 0 | 1640.831
 | [NAME] | 136.829 | 72.977 | 62.138 | 1247.777 | 36.586 | 50.531 | 23.565 | 1630.403
 | [NAME] | 141.894 | 72.327 | 65.153 | 1191.752 | 31.682 | 51.234 | 0.963 | 1555.005
 | MY Sep-Aug | 513.36 | 296.607 | 253.968 | 5011.025 | 136.5 | 203.229 | 24.528 | 6439.217000000001
2012/13 | Q1 Sep-Nov | 122.758 | 70.366 | 63.793 | 1139.205 | 34.156 | 52.401 | 0 | 1482.679
 | [NAME] | 113.435 | 65.349 | 58.682 | 1115.859 | 35.826 | 52.286 | 0 | 1441.437
 | [NAME] | 126.318 | 72.48 | 62.195 | 1193.09 | 37.524 | 52.836 | 22.366 | 1566.809
 | MY Sep-Aug | 505 | 270 | 250 | 4650 | 140 | 210.419 | 24.581 | 6050
2013/14 | MY Sep-Aug | 510 | 290 | 280 | 4900 | 140 | 205.35 | 24.65 | 6350
1/ September-August.  Latest data may be preliminary or projected. Source: Calculated by USDA, Economic Research Service.
Date run: 7/12/2013
Spreadsheet: 174853d1345215087-excel-2007-find-first-and-last-in-a-series-tigeravatar-example-for-mma3824-v2
Sheet: Sheet1

Name | January | February | March | April | May | First | Last | Second
name1 | -13.4 | -13.9 | -13.8 | -13.6 | - | -13.4 | -13.6 | -13.9
[NAME] | -8.2 | -8.3 | -8.7 | - | - | -8.2 | -8.7 | -8.3
name3 | -4.9 | -4.5 | -4.3 | -4.5 | - | -4.9 | -4.5 | -4.5
name4 | -4.8 | -7 | - | - | - | -4.8 | -7 | -7
name5 | -4.4 | -3.3 | -3.6 | -3.3 | - | -4.4 | -3.3 | -3.3
name6 | -3.9 | -2.6 | -3 | -2.6 | - | -3.9 | -2.6 | -2.6
name7 | -3.6 | -4.6 | -5 | -5.4 | -5.9 | -3.6 | -5.9 | -4.6
name8 | - | -0.3 | 1 | 1.1 | 1.7 | -0.3 | 1.7 | 1
name9 | - | -0.2 | -0.4 | -0.4 | - | -0.2 | -0.4 | -0.4
name10 | - | -0.2 | 0 | 0.2 | 0.3 | -0.2 | 0.3 | 0
name11 | - | - | - | 0.4 | 0.6 | 0.4 | 0.6 | 0.6
Spreadsheet: 839144d1691688146-return-a-value-if-multiple-columns-are-a-if-not-return-a-max-date-formula-help
Sheet: Sheet1

Request/Job: P2 ID | ECCD | MAX DEP DATE | DEP | DATE | DEP | DATE | DEP | DATE | DEP | DATE | DEP | DATE | ROE/TRENCH/STRAP | PERMIT
JB0001039756 |  |  | JB0000494001 | A | 284281 | 2023-09-24 00:00:00 | JB0000724387 | A | 801903 | 2023-10-15 00:00:00 | N/A | A |  | A
Spreadsheet: 270597d1381536467-list-dates-that-correspond-to-employee-id-numbers-from-a-different-sheet-next-largest-date
Sheet: Sheet1

2013-08-15 00:00:00 | 31
2013-08-15 00:00:00 | 32
2013-08-15 00:00:00 | 33
2013-08-15 00:00:00 | 33
2013-08-15 00:00:00 | 8
2013-08-15 00:00:00 | 8
2013-08-15 00:00:00 | 8
2013-08-15 00:00:00 | 7
2013-08-15 00:00:00 | 31
2013-08-15 00:00:00 | 32
2013-08-15 00:00:00 | 31
2013-08-22 00:00:00 | 8
2013-08-22 00:00:00 | 8
2013-08-22 00:00:00 | 31
2013-08-22 00:00:00 | 33
2013-08-22 00:00:00 | 32
2013-08-22 00:00:00 | 8
2013-08-30 00:00:00 | 31
2013-08-30 00:00:00 | 32
2013-08-30 00:00:00 | 33
2013-08-30 00:00:00 | 7
2013-08-30 00:00:00 | 8
2013-08-30 00:00:00 | 8
2013-09-05 00:00:00 | 33
2013-09-05 00:00:00 | 32
2013-09-05 00:00:00 | 31
Spreadsheet: 788398d1658437112-inserting-row-above-table-changes-formulas-despite-structured-references-sampleproblem
Sheet: Values

Column1 | Category A 100% | Category A 75% | Category A 50% | Category B 100% | Category B 75% | Category B 50% | Category C 100% | Category C 75% | Category D 100% | Category D 75% | Category D 50%
A01 | 1 | 1 | 1 | 1 | 2 | 3 | 1 | 2 | 1 | 2 | 3
A02 | 1 | 2 | 3 | 1 | 2 | 3 | 1 | 2 | 1 | 2 | 3
A03 | 1 | 2 | 3 | 1 | 2 | 3 | 1 | 2 | 1 | 2 | 3
A04 | 1 | 2 | 3 | 1 | 2 | 3 | 1 | 2 | 1 | 2 | 3
A05 | 1 | 2 | 3 | 1 | 2 | 3 | 1 | 2 | 1 | 2 | 3
A06 | 1 | 2 | 3 | 1 | 2 | 3 | 1 | 2 | 1 | 2 | 3
A07 | 1 | 2 | 3 | 1 | 2 | 3 | 1 | 2 | 1 | 2 | 3
A08 | 3 | 3 | 3 | 1 | 2 | 3 | 1 | 2 | 1 | 2 | 3
A09 | 4 | 4 | 4 | 1 | 2 | 3 | 1 | 2 | 1 | 2 | 3
A10 | 5 | 5 | 6 | 1 | 2 | 3 | 1 | 2 | 1 | 2 | 3 |  |  |  | 100 | 75 | 50 | 100 | 75 | 50 | 100 | 75 | 100 | 75 | 50
Spreadsheet: 552576d1513660742-how-to-change-the-timeline-time-line-
Sheet: Project Timeline

 |  | COLLECTION TIMELINE
 |  | ENTER START DATE: | 2018-01-20 00:00:00
 | Id | ACTIVITY | START | END | NOTES
 |  | Anwa - 20th Floor |  |  | Completion of G+ Twentieth (20th) Floor Slab Concrete Poured
 |  | Anwa - 30th Floor |  |  | Completion of G+ Twentieth (30th) Floor Slab Concrete Poured
 |  | Anwa - Completion |  |  | Completion Of Anwa
 |  | [NAME] 2nd Floor |  |  | Completion of G + Two (2nd ) Floor Slab Concrete Poured
 |  | [NAME] 8th Floor |  |  | Completion of G + Eight 8th Floor Slab Concrete Poured
 |  | [NAME] 14th Floor |  |  | Completion of G + Eight 14th Floor Slab Concrete Poured
 |  | Langham - Roof Slab Concrete Poured |  |  | Completion of Roof Floor Slab Concrete Poured
 |  | Langham - Completion of Tower Raft |  |  | Completion of Tower Raft
 |  | Langham - Completion of Structure |  |  | Completion of Structure
Spreadsheet: 583372d1532416168-translate-a-column-of-supplier-names-to-english-which-are-in-different-languages-suppliers-example
Sheet: Sheet1

Supplier | Expected Output
埃森哲 | Accenture
แอคเซนเจอร์ | Accenture
アクセンチュア | Accenture
액센추어 | Accenture
Аццентуре | Accenture
塔塔咨询公司 | [NAME]
Tata-Beratung | [NAME]
[NAME] | [NAME]
タタコンサルタンシー | [NAME]
타타 컨설팅 | [NAME]
Тата Цонсултанци | [NAME]
การให้คำปรึกษา Tata | [NAME]
국제 비즈니스 머신 | International Business Machine
เครื่องธุรกิจระหว่างประเทศ | International Business Machine
Међународна пословна машина | International Business Machine
国际商务机器 | International Business Machine
Máy kinh doanh quốc tế | International Business Machine
Spreadsheet: 78372d1278708970-adjustments-for-missing-your-quota-book1-keep-all-data-and-adjust-based-on-last-entry-issue
Sheet: player info

player ID | Name | tees | index | points |  |  | points made on last round played - only most current 15 rounds
1 | tom | B | 4.7 | 31 |  |  | 30
2 | [NAME] | B | 7.9 | 28 |  |  | 20
3 | [NAME] | G | 22.5 | 23 |  |  | 10
4 | [NAME] | W | 14.7 | 21 |  |  | 15
5 | henry | B | 9.9 | 27 |  |  | 28
6 | mary | R | 28.1 | 7 |  |  | 5
7 | sue | R | 16.8 | 19 |  |  | 17
IF(L10>L6+2,(-1),IF(L10=L6+2,0,IF(L10=L6+1,1,IF(L10=L6,2,IF(L10=L6-1,3,IF(L10=L6-2,5,IF(L10=L6-3,7,IF(L10=0,""))))))))
Score sheet:
[NAME]: =VLOOKUP(A10,'player info'!A3:D9,3,FALSE)
G10: =VLOOKUP(A10,'player info'!A3:D9,4,FALSE)
IFERROR(VLOOKUP($A10,'player info'!$A$2:$D$9,COLUMN()-3,FALSE),"") drag over to G10 and down
IFERROR(VLOOKUP($A10,'player info'!$A$3:$D$9,COLUMN()-2,FALSE),"") drag down
Spreadsheet: 863733d1711119183-highlighting-a-row-if-its-overdue-student-leases-demo-aligw
Sheet: Sheet2

Today's Date: |  |  |  |  |  | Student Device Leases [DEMO]
Student Information |  |  |  |  |  |  | Miscellaneous |  | Loan Information (Example of ALL Statuses) |  |  |  | Device Information
Student ID | Last Name | First Name | Age Group | Tutor | CAM Area | Course | Form Sent? | Notes | Issue Date | Due Date | Status | Returned? | Device Name | Checked? | Date Checked
123456 | Last | First | 16 - 18 Bursery | [NAME] | [NAME] |  | Yes |  | 2023-11-03 00:00:00 | 2024-03-20 00:00:00 |  | - | ACAD-LEASE40 | Yes
123456 | Last | First | 19+ Bursery | [NAME] | [NAME] |  | N/A |  | 2023-01-08 00:00:00 | 2024-10-01 00:00:00 |  | Y | ACAD-LEASE254 | In Repair
123456 | Last | First | 16 - 18 | [NAME] | [NAME] |  | No |  | 2023-02-25 00:00:00 | 2024-03-21 00:00:00 |  | - | ACAD-LEASE88 | Outstanding
123456 | Last | First | 19+ | [NAME] | [NAME] |  | N/A |  | 2023-01-09 00:00:00 |  |  | - | ACAD-LEASE187 | Yes
 |  |  |  |  |  |  |  |  |  |  |  | -
 |  |  |  |  |  |  |  |  |  |  |  | -
 |  |  |  |  |  |  |  |  |  |  |  | -
 |  |  |  |  |  |  |  |  |  |  |  | -
 |  |  |  |  |  |  |  |  |  |  |  | -
 |  |  |  |  |  |  |  |  |  |  |  | -
 |  |  |  |  |  |  |  |  |  |  |  | -
 |  |  |  |  |  |  |  |  |  |  |  | -
 |  |  |  |  |  |  |  |  |  |  |  | -
 |  |  |  |  |  |  |  |  |  |  |  | -
 |  |  |  |  |  |  |  |  |  |  |  | -
 |  |  |  |  |  |  |  |  |  |  |  | -
 |  |  |  |  |  |  |  |  |  |  |  | -
 |  |  |  |  |  |  |  |  |  |  |  | -
 |  |  |  |  |  |  |  |  |  |  |  | -
 |  |  |  |  |  |  |  |  |  |  |  | -
Spreadsheet: 474471d1470764341-vlookup-post-code-region-oeldere-474447d1470757142-vlookup-post-code-region-post-code-regions
Sheet: Addresses

Broker Postcode | First Postcode | Region
FY4 4BW | FY | NORTH WEST ENGLAND
MK9 2LA | MK | EAST ANGLIA
M3 5EQ | M | NORTH WEST ENGLAND
B27 6LG | B | THE MIDLANDS
DD2 1JQ | DD | SCOTLAND
PH1 1PP | PH | SCOTLAND
PH1 1PP | PH | SCOTLAND
TW15 2RP | TW | SOUTH EAST ENGLAND
GU35 0AX | GU | SOUTH CENTRAL ENGLAND
Broker Postcode | First Postcode | Region
FY4 4BW
MK9 2LA
M3 5EQ |  |  | this values are not in the table on sheet regions
B27 6LG |  |  | this values are not in the table on sheet regions
DD2 1JQ
PH1 1PP
PH1 1PP
TW15 2RP
GU35 0AX
Spreadsheet: 44774d1243529117-excel-2007-if-function-vlookup
Sheet: List2

[NAME] | Št. Prejema | Šifra | Poz. | Material | [NAME] | Kval. | Dimenzija (mm) | Kol. ([NAME]) | Kol. (m) | Kos. | [NAME] | Št. Plošče | A-TEST | [NAME] | Nalog
Exterfer | 000115 | 10292 | 1 | Pločevina |  | ST-37 | 10x2500x8000 | 1600 |  | 1 | 918168-911894-1-3 |  | [NAME] | Metalna IMPRO\Material\Dobavnice\2009\Exterfer\001.jpg
 |  | 10313 | 2 | Pločevina |  | ST-37 | 8x2500x6000 | 960 |  | 1 | 916336-29-01 |  | [NAME]
Exterfer | 000116 | 10299 | 1 | Pločevina |  | ST-37 | 25x1500x6000 | 1800 |  | 1 | 628968 |  | [NAME] | Metalna IMPRO\Material\Dobavnice\2009\Exterfer\002.jpg
Inox Center | 000114 | 10255 | 1 | Pločevina | Nr. | 1.4301 | 4x1000x2000 | 640 |  | 10 |  |  |  | Metalna IMPRO\Material\Dobavnice\2009\Inox-Center\001.jpg
 |  | 10258 | 2 | Pločevina | Nr. | 1.4301 | 4x1500x3000 | 864 |  | 6
 |  | 10243 | 3 | Pločevina | Nr. | 1.4301 | 1.5x1500x3000 | 109.6 |  | 2
 |  | 10248 | 4 | Pločevina | Nr. | 1.4301 | 2x1500x3000 | 216 |  | 3
Al/Cu Domžale | 000117 | 10194 | 1 | Kotnik | Nr. enakokraki | Al | 8x80 | 41 | 12 | 2 |  |  |  | Metalna IMPRO\Material\Dobavnice\2009\Al-Cu\0001.jpg
Pahor | 000118 |  | 1 | Jeklo | Nr. ploščato | 1.4301 | 3x25 | 47 | 12 | 4 |  |  |  | Metalna IMPRO\Material\Dobavnice\2009\Pahor\0001.tif
 |  | 10018 | 2 | Cev | Nr. šivna okrogla | 1.4301 | 48.3x2 |  | 42 | 7
 |  | 10103 | 3 | [NAME] | Nr. | 1.4301 | 48.3x2 |  |  | 4
 |  |  | 4 | Pločevina | Nr. | 1.4301 | 3x1500x4000 | 283 |  | 2
 |  |  | 5 | Pločevina | Nr. | 1.4301 | 4x1000x4000 | 249 |  | 2
 |  |  | 6 | Pločevina | Nr. | 1.4301 | 4x1000x3000 | 93 |  | 1
 |  |  | 7 | Pločevina | Nr. | 1.4301 | 4x1000x2000 | 63 |  | 1
 |  | 10018
 |  | 10020 |  | Cev | šivna okrogla | ST-37 | 48.3x2 | 100 | 2 | 2
 |  |  |  | Cev | šivna okrogla | ST-37 | 48.3x2
Ok here it goes: IF C19=(Sheet1) $colum B; IF E19=(Sheet1) $colum C; IF F19=(Sheet1) $[NAME]; IF G19=(Sheet1) $[NAME]; IF H19=(Sheet1) $columD IF ALL OF THESE 4 VALUES MATCH THE VALUES IN ROW 21 OR IT COULD BE IN ROW 30 FOR ALL I KNOW
I JUST WANT IT TO SEARCH THESE 4 VALUES IN THE TABLE ARRYA ON SHEET 1 AND COPY THE RIGHT VALUE FROM COLUM A
IF function - Excel Help Forum
Spreadsheet: benjamin_rogers__1221__UAE latest O&M costs from Scott
Sheet: Training

Training Program
Employee Class Training |  | Days | Attending
Basic Plant Training
New Employee Orientation |  | 1 | All | Supplied by: | O&M Contractor
Plant Safety/Environmental/Firefighting |  | 5 | All | Supplied by: | O&M Contractor
O&M Practices/Admin Procedures |  | 1 | All | Supplied by: | O&M Contractor
Simple Cycle Training Program
Power Plant Fundamentals |  | 0.5 | All | Supplied by: | TriTech
BOP Familiarization * |  | 0.5 | All | Supplied by: | TriTech
Combustion Turbine Familiarization |  | 2 | All | Supplied by: | TriTech
Combustion Turbine Operation |  | 10 | All | Supplied by: | General Electric
BOP Operation * |  | 0 | All | Supplied by: | TriTech
Combustion Turbine Preventive Maintenance |  | 0 | All | Supplied by: | TriTech
BOP Preventive Maintenance * |  | 0 | All | Supplied by: | TriTech
Gas Turbine Mark V |  | 0 | All | Supplied by: | General Electric
DCS & Mark IV Operations and [NAME] (2 people for 4 weeks)
Software & Hardware Maintenance |  | 0 | Opts/Eng/I&C | Supplied by: | To be determined
Troubleshooting |  | 0 | Opts/Eng/I&C | Supplied by: | To be determined
Total Class Training Duration |  |  | Days
Estimated Training Expenses |  |  |  |  | 135500
Meals, Etc. |  | $50/day x 20 days x 7 employees
Travel Expenses (to Minnesota) |  | $125/day x 12 days x 7 employees
 |  | $450 airfare x 7 employees
Classroom Facility rental: |  |  |  |  | 0
Training Coordinator |  | $75/hr x 10 hrs/wk x 5 weeks + OJT Admin @ 40 hours
Phase I - Employee Orientation |  | $500/day x 5 days
Phase II - Technical Training
Fundamentals & BOP Systems |  | TriTech Quotation |  |  | 30000
Combustion Turbine |  | General Electric Option at Caledonia |  |  | 61150
Instructor |  | Included |  |  | 0
DCS Training |  | General Electric Option |  |  | 0
Control Room Simulator Training |  | Not included |  |  | 0
Phase III - Leadership Training |  | By Enron Corp in Houston |  |  | 0
Phase IV - Safety & Environmental |  | $1500 x 1 trip + 40 hours x $75
Phase V - OJT Program |  | Supplied by GE during TD of I |  |  | 0
Supplies & Other Expenses |  | 5% of Subtotal
Grand Total Training Cost
Spreadsheet: 856816d1706005354-string-of-four-to-five-characters-that-need-to-be-seperated-into-four-to-five-columns-excel-forum-sample
Sheet: Sheet1

Raw Data | [NAME] | Dept | First Name | Last Name | Emp ID
Tesla Operations [NAME] | Tesla | Operations | [NAME] | Smith | [NAME]
Tesla DevOps [NAME]
Tesla Devops Ramesh Singh-D665566
Tesla Eng [NAME]
[NAME]
[NAME]
Tesla Eng [NAME]
Google Mar [NAME]
Tesla Fac Heather Stones-Fac5114
Meta Fac Gary Fins-Fac3119
Spreadsheet: 695869d1600435351-autofill-budget-add-salaries-auto-add-budget-info
Sheet: Bank info

Account no | Verification no |  |  |  | Invoice no |  | Amount
-------------------------
4206 | Food
 |  |  |  |  |  |  | 0
 | D 251 |  |  |  | Invoice 121 |  | 882
-------------------------
 |  |  |  |  |  |  | 882
 |  |  |  |  |  |  | 882
-------------------------
4215 | Rent
 |  |  |  |  |  |  | 0
 | K 97 |  |  |  | Invoice 234 |  | 2179.49
-------------------------
 |  |  |  |  |  |  | 2179.49
 |  |  |  |  |  |  | 2179.49
-------------------------
4221 | Extra
 |  |  |  |  |  |  | 0
 | D 64 |  |  |  | Invoice 293 |  | 2342.34
 | K 97 |  |  |  | Invoice 301 |  | 2869.32
 | D 64 |  |  |  | Invoice 382 |  | 1253.76
 | K 97 |  |  |  | Invoice 568 |  | 345.43
 | D 64 |  |  |  | Invoice 432 |  | 294.64
 | K 97 |  |  |  | Invoice 654 |  | 1837.54
-------------------------
 |  |  |  |  |  |  | 2132.18
 |  |  |  |  |  |  | 2132.18
-------------------------
4225 | Production
 |  |  |  |  |  |  | 0
 | D 69 |  |  |  | Invoice 870 |  | 2055.79
 | D 306 |  |  |  | Invoice 291 |  | 1327.31
-------------------------
-------------------------
7001 | Salary
 |  |  |  |  |  |  | 0
 | F 123 |  |  |  | Person 1 |  | 10000
 | F 321 |  |  |  | Person 2 |  | 5000
-------------------------
-------------------------
7002 | Tax
 |  |  |  |  |  |  | 0
 | F 123 |  |  |  | Person 1 |  | 2000
 | F 321 |  |  |  | Person 2 |  | 1000
-------------------------
Spreadsheet: 703501d1605023401-get-values-from-different-sheets-where-different-bits-of-data-values-match-chasing-values
Sheet: serials

ParentKey | LineNum | ManufacturerSerialNumber | InternalSerialNumber | BaseLineNumber |  |  |  |  |  | Example output | ParentKey | LineNum | ManufacturerSerialNumber | InternalSerialNumber | BaseLineNumber
DocNum | LineNum | MnfSerial | DistNumber | DocLineNum |  |  |  |  |  |  | DocNum | LineNum | MnfSerial | DistNumber | DocLineNum
 |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 2 | 2 | 0
 |  | 54 |  |  |  |  |  |  |  |  | 1 | 1 | 54 | 54 | 2
 |  | 4354354 |  |  |  |  |  |  |  |  | 1 | 2 | 4354354 | 4354354 | 1
 |  | 543 |  |  |  |  |  |  |  |  | 1 | 3 | 543 | 543 | 3
 |  | 808 |  |  |  |  |  |  |  |  | 1 | 4 | 808 | 808 | 4
 |  | [NAME] |  |  |  |  |  |  |  |  | 1 | 5 | [NAME] | [NAME] | 4
Spreadsheet: 025a3251-ae6a-48a4-9bd6-fdd9a7f709b2
Sheet: SF-424A

Applicant Name: |  |  |  | Award Number:
Budget Information - Non Construction Programs
OMB Approval No. 0348-0044
Section A - Budget Summary
 | Grant Program Function or Activity | Catalog of Federal Domestic Assistance Number | Estimated Unobligated Funds |  | New or Revised Budget
 |  |  | Federal | Non-Federal | Federal | Non-Federal | Total
 | (a) | (b) | (c ) | (d) | (e) | (f) | (g)
1. | Budget period 1
2. | Budget period 2
3. | Budget period 3
4.
5. | Totals
Section B - Budget Categories
6. | Object Class Categories |  | Grant Program, Function or Activity |  |  |  | Total (5)
 |  |  | Budget period 1 | Budget period 2 | Budget period 3 | (4)
 | [NAME]
 | [NAME]
 | c.  Travel
 | d.  Equipment
 | e.  Supplies
 | f.  Contractual
 | g.  Construction
 | h.  Other
 | i.  Total Direct Charges (sum of 6a-6h)
 | j.  Indirect Charges
 | k.  Totals (sum of 6i-6j)
7. | Program Income
 |  |  |  |  |  |  | SF-424A (Rev. 4-92)
Previous Edition Usable |  |  |  |  |  | Prescribed by OMB Circular A-102
Authorized for Local Reproduction
Section C - Non-Federal Resources
 | (a) Grant Program |  |  | (b) Applicant | (c ) State | (d) Other Sources | (e) Totals
8. | Budget period 1
9. | Budget period 2
10. | Budget period 3
11.
12. | Total (sum of lines 8 - 11)
Section D - Forecasted Cash Needs
 |  |  | Total for 1st Year | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th quarter
13. | Federal
14. | Non-Federal
15. | Total (sum of lines 13 and 14)
Section E - Budget Estimates of Federal Funds Needed for Balance of the Project
(a) Grant Program |  |  |  | Future Funding Periods (Years)
 |  |  |  | Budget period 1 | Budget period 2 | Budget period 3
16.
17.
18.
19.
20. | Total (sum of lines 16-19)
Section F - Other Budget Information
21. Direct Charges |  |  |  | 22. Indirect Charges
23.  [NAME]
 |  |  |  |  |  |  | SF-424A (Rev. 4-92)
Previous Edition Usable |  |  |  |  |  |  | Prescribed by OMB Circular A-102
 |  | Authorized for Local Reproduction
Spreadsheet: 170925d1343508955-complicated-split-number-then-produce-table-and-copy-the-data-in-a-certain-assortment-result
Sheet: Sheet1

 | 8 | 88 | 881 | 8815
 | 0 | 80 | 880 | 8810
 | 1 | 81 | 881 | 8811
 | 2 | 82 | 882 | 8812
 | 3 | 83 | 883 | 8813
 | 4 | 84 | 884 | 8814
 | 5 | 85 | 885 | 8815
 | 6 | 86 | 886 | 8816
 | 7 | 87 | 887 | 8817
 | 8 | 88 | 888 | 8818
 | 9 | 89 | 889 | 8819
Spreadsheet: 669672d1585545353-how-to-put-multiple-if-conditions-in-one-nested-condition-example1618
Sheet: Sheet1

 |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar
 |  |  | Sales | 81 | 53 | 54 | 90 | 54 | 56 | 84 | 71 | 67 | 84 | 63 | 71 | 80 | 65 | 48
 |  |  | Closing Stock | 159 | 182 | 190 | 173 | 250 | 191 | 30 | 156 | 179 | 164 | 189 | 173
 |  | Output Result | Month of Supply Ratio |  | 2.7 | 2.8 | 2.8 | 3.6 |  | 0.4
Spreadsheet: 675062d1588139809-sumifs-for-visible-cells-example1685
Sheet: Total staff time calculation

 | Team Member | Total staffed time
 | Amalia
 | Amelia
 | Anna
 | [NAME]
 | [NAME]
 | Brooke
 | [NAME]
Spreadsheet: 769209d1645401232-monthly-and-quarterly-reports-excel-question
Sheet: 1099 List

Name | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | Total 2021
 |  |  | 0
[NAME] | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250
[NAME] | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200
Suman Sharma | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200
[NAME] |  | 225 |  |  |  | 225 |  | 225
Spreadsheet: 725893d1616946830-formula-which-adjusts-current-cell-to-catchup-for-shortfall-in-rows-cells-above-excel-problem
Sheet: Sheet1

Month | Expected Stock | Forecast | Expected Sales | Forecast-Sales (Shortfall) | Forecast - Sales (Cumulative) | Stock-Sales ([NAME])
Jan | 14 | 8 | 8
Feb | 8 | 8 | 8
Mar | 30 | 20
Apr | 20 | 18
May | 4 | 10
Jun | 0 | 17
Jul | 0 | 18
Aug | 20 | 9
Sep | 45 | 9
Oct | 13 | 13
Nov | 10 | 10
Dec | 17 | 9
Totals
Spreadsheet: 53015d1252938307-one-sheet-feeds-another-depending-on-data-entered-staples-issues
Sheet: Critical

Heading 1 | Heading 2 | Heading 3 | Heading 4 | Heading 5 | [NAME]
Data | Data | Data | Data | Data | R
Data | Data | Data | Data | Data | R
Data | Data | Data | Data | Data | R
Data | Data | Data | Data | Data | R
Data | Data | Data | Data | Data | R
Data | Data | Data | Data | Data | R
Data | Data | Data | Data | Data | R
Data | Data | Data | Data | Data | R
Data | Data | Data | Data | Data | R
Data | Data | Data | Data | Data | R
Data | Data | Data | Data | Data | R
Spreadsheet: 158260d1338121885-macro-to-transferring-to-other-sheet-abu
Sheet: 11

Date | Customer | Bank Account | Description | Voucher No. | Debt | Credit | Balance
2012-05-02 00:00:00 |  | 11 |  |  | 200 |  | -200
2012-05-04 00:00:00 |  | 11 |  |  | 400 |  | -300
2012-05-07 00:00:00 |  | 11 |  |  |  | 1000 | 800
2012-05-09 00:00:00 |  | 11 |  |  |  | 500 | 400
2012-05-11 00:00:00 |  | 11 |  |  |  | 400 | 200
2012-05-02 00:00:00 |  | 11 |  |  | 200 |  | 0
2012-05-04 00:00:00 |  | 11 |  |  | 400 |  | -100
2012-05-07 00:00:00 |  | 11 |  |  |  | 1000 | 1000
2012-05-09 00:00:00 |  | 11 |  |  |  | 500 | 600
2012-05-11 00:00:00 |  | 11 |  |  |  | 400 | 400