tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 862265d1710008285-need-help-totaling-based-on-selections-mix-id-calculator-eba
Sheet: Sheet1

This section is where the results are displayed. |  |  |  |  |  |  |  |  |  | This section is where I manipulate the lists and price.  Can be done on another tab.
Base Price | Mix ID | Add On |  |  |  | Distance | Total |  |  | Mix ID | Price |  | Add On | Price |  | Distance | Price
 |  | Air | HRWR | 3/8 Agg | [NAME]
121 | COM351510 |  |  |  |  | 11-20 |  |  |  | COM301510 | base |  | Air | 3 |  | 1-10 | 0 |  | True
 |  |  |  |  |  |  |  |  |  | COM351510 | 5 |  | HRWR | 5 |  | 11-20 | 5 |  | True
 |  |  |  |  |  |  |  |  |  | COM401510 | 10 |  | 3/8 Agg | 7 |  | 21-30 | 10 |  | False
 |  |  |  |  |  |  |  |  |  | COM451510 | 15 |  | [NAME] | 13 |  |  |  |  | False
 |  |  |  |  |  |  |  |  |  | COM501510 | 20
Spreadsheet: 840312d1692642377-formula-to-return-previous-month-balance-edate-not-working-sample
Sheet: Sheet1

Current Date | Aug
Current Balance
Previous Month Balance
Month | Balance
Jan | 5000
2023-02-01 00:00:00 | 6000
2023-03-01 00:00:00 | 7000
2023-04-01 00:00:00 | 6000
2023-05-01 00:00:00 | 8000
2023-06-01 00:00:00 | 10000
Jul | 11000
Aug | 9000
2023-09-01 00:00:00 | 8000
2023-10-01 00:00:00
2023-11-01 00:00:00
2023-12-01 00:00:00
Spreadsheet: 218236d1362406726-comibining-2-averageif-formula-book8
Sheet: Cdata

sys_RespNum | Importance_Brand | Importance_HeadsetDesign | Importance_ConnectiontoGamingConsole | Importance_Compatibility | Importance_Sound | Importance_Microphone | Importance_EqualizerApp | Importance_BeatEnhancingTechnology | Importance_VoiceMorphing | Importance_SideTone | Importance_GameandChatSoundMixer | Importance_USBChargingCable | Importance_StorageDevice | Importance_Price | Age | Gender
4 | 4.30821 | 2.86889 | 0 | 7.00788 | 13.13755 | 0 | 1.67609 | 0.99327 | 1.11584 | 0.22838 | 1.73117 | 2.453 | 5.57336 | 58.90635 | 6 | 1
6 | 4.56197 | 7.9652 | 13.29123 | 25.77373 | 19.71363 | 8.11687 | 3.08855 | 1.86788 | 0 | 0.33391 | 0 | 0 | 5.89806 | 9.38898 | 5 | 1
7 | 6.16854 | 9.51489 | 0 | 1.01916 | 7.3981 | 4.33602 | 2.00931 | 6.82484 | 0.19241 | 0 | 0 | 9.89449 | 5.09157 | 47.55067 | 4 | 2
11 | 10.35212 | 12.83469 | 5.56201 | 7.58652 | 10.77313 | 5.37327 | 1.35925 | 6.92421 | 2.02841 | 0 | 3.13633 | 0 | 7.39269 | 26.67736 | 7 | 1
16 | 16.23263 | 7.2875 | 0.24642 | 6.66942 | 20.84484 | 6.43332 | 1.64225 | 7.18801 | 0 | 0 | 0 | 7.01283 | 5.52329 | 20.91948 | 6 | 2
25 | 2.03858 | 17.97273 | 15.24325 | 1.06662 | 12.91268 | 8.15127 | 4.80601 | 6.02178 | 0 | 0 | 4.68777 | 0 | 3.72388 | 23.37545 | 7 | 1
27 | 5.65708 | 0 | 16.5816 | 18.39275 | 26.89936 | 0 | 2.41746 | 5.24109 | 0 | 0 | 0 | 4.66815 | 9.50819 | 10.63432 | 3 | 1
29 | 8.45438 | 4.21667 | 0 | 4.41867 | 2.78342 | 7.85708 | 1.19663 | 1.88786 | 0 | 0 | 0 | 3.82545 | 7.21194 | 58.1479 | 5 | 2
30 | 11.49345 | 10.1977 | 0.26856 | 10.63716 | 8.80577 | 6.04653 | 6.79371 | 7.87839 | 0 | 0 | 7.53826 | 3.37712 | 6.37684 | 20.58652 | 2 | 2
35 | 2.29867 | 6.05398 | 16.55399 | 13.4659 | 15.98552 | 7.99232 | 1.56519 | 1.92516 | 0 | 0 | 0 | 0 | 4.65 | 29.50928 | 5 | 2
36 | 4.74991 | 8.26055 | 5.94376 | 0 | 9.43865 | 7.36489 | 7.27098 | 4.98999 | 0 | 6.95875 | 5.10902 | 0 | 4.65713 | 35.25638 | 4 | 1
40 | 0.59134 | 12.40032 | 9.8024 | 10.59528 | 18.04847 | 5.85504 | 4.43309 | 5.80936 | 8.86675 | 0 | 0 | 2.92959 | 7.80432 | 12.86404 | 6 | 2
41 | 8.04199 | 14.9792 | 4.91338 | 4.04556 | 15.2656 | 0 | 6.3348 | 9.09712 | 0 | 0 | 0 | 5.02116 | 4.19041 | 28.11078 | 5 | 1
Spreadsheet: 798036d1664283070-alternating-formulas-every-two-cells-needs-to-reference-same-column-book3
Sheet: B

B
 | January | February | March | April | May | June | July | August | September | October | November | December
Client 1 | 510 |  |  |  |  | 511 |  |  | 7012 |  | 912 | 50
Client 2 | 20 |  |  |  |  | 112 |  |  | 321 |  | 250 | 13
Client 3 | 1 |  |  |  |  | 3618 |  |  | 61 |  | 52 | 30
total
ytd
gl
difference
balance
Spreadsheet: 866173d1713147187-in-spec-out-of-spec-formula-blank-grade-form
Sheet: Fault Trending 2023

 |  |  | Good | Satisfactory | Unacceptable | Good (%) | Satisfactory (%) | Unacceptable (%)
 |  |  |  |  |  |  |  |  | Month Number;
 |  |  |  |  |  |  |  |  | 4
 |  |  | 2023 (Total) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Length |  |  | Diameter |  |  | Density |  |  | Moisture |  |  | Dust |  |  | Coating |  |  | Cross Contamination |  |  | Appearance |  |  | Odour
 |  |  | Good | Satisfactory | Unacceptable | Good (%) | Satisfactory (%) | Unacceptable (%) | Good | Satisfactory | Unacceptable | Good (%) | Satisfactory (%) | Unacceptable (%) |  |  |  | Good | Satisfactory | Unacceptable | Good | Satisfactory | Unacceptable | Good | Satisfactory | Unacceptable | Good | Satisfactory | Unacceptable | Good | Satisfactory | Unacceptable | Good | Satisfactory | Unacceptable | Good | Satisfactory | Unacceptable | Good | Satisfactory | Unacceptable | Good | Satisfactory | Unacceptable
 |  | Length |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Jan
 |  | Diameter |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | Feb
 |  | Density |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | Mar
 |  | Moisture |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | Apr
 |  | Dust |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | May
 |  | Coating |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | Jun
 |  | Cross Contamination |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | Jul
 |  | Appearance |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | Aug
 |  | Odour |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | Sep
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | Oct
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | Nov
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | Dec
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Length |  |  | Diameter |  |  | Density |  |  | Moisture |  |  | Dust |  |  | Coating |  |  | Cross Contamination |  |  | Appearance |  |  | Odour
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Good | Satisfactory | Unacceptable | Good | Satisfactory | Unacceptable | Good | Satisfactory | Unacceptable | Good | Satisfactory | Unacceptable | Good | Satisfactory | Unacceptable | Good | Satisfactory | Unacceptable | Good | Satisfactory | Unacceptable | Good | Satisfactory | Unacceptable | Good | Satisfactory | Unacceptable
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jan
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Feb
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apr
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jun
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jul
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aug
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sep
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Oct
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nov
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dec
Spreadsheet: 802344d1666796063-series-on-different-columns-example-serie-1-
Sheet: Sheet1

 | Home | Away | A |  | [NAME] | Should be
1 | TeamA | TeamB | 1 | TeamA |  | 1
1 | TeamC | TeamD | 0 | TeamC |  | 0
2 | TeamA | TeamB | 1 |  |  | 2
2 | TeamD | TeamC | 1 |  |  | 1
3 | TeamB | TeamA | 0 |  |  | 0
3 | TeamD | TeamC | 1 |  |  | 2
4 | TeamA | TeamB | 1 |  |  | 1
4 | TeamD | TeamC | 0 |  |  | 0
5 | TeamA | TeamB | 1 |  |  | 2
5 | TeamC | TeamD | 1 |  |  | 1
6 | TeamB | TeamA | 1 |  |  | 3
6 | TeamD | TeamC | 1 |  |  | 2
7 | TeamA | TeamB | 1 |  |  | 4
7 | TeamD | TeamC | 0 |  |  | 0
8 | TeamB | TeamA | 0 |  |  | 0
8 | TeamC | TeamD | 1 |  |  | 1
9 | TeamA | TeamB | 1 |  |  | 1
9 | TeamD | TeamC | 1 |  |  | 2
10 | TeamA | TeamB | 1 |  |  | 2
10 | TeamD | TeamC | 0 |  |  | 0
Spreadsheet: 784005d1655350051-merge-and-update-tables-merge-and-update-tables
Sheet: New

 | Required Result |  |  |  |  |  |  |  |  | Dynamic Required Result Table
Status | P/N | Site | Supplier | REF | Price | Incoterms | Category |  |  | Status | P/N | Site | Supplier | REF | Price | Incoterms | Category
Changed | A123 | Prague | AA | 123 | 2 | DAP | A
Changed | AAA | London | AA | 4566 | 6 | DAP | A
Unchanged | ABB | Paris | BB | 77545 | 6 | FCA | A
Changed | AAC | London | CC | 54 | 3 | EXW | C
Unchanged | ABC | London | CC | 5454 | 7 | EXW | A
Unchanged | BBB789 | Prague | CC | 444 | 5 | EXW | B
Changed | DDD | Paris | BB | 1111 | 15 | DAP | C
Unchanged | RRR | New York | CC | 222 | 17 | EXW | C
Changed | T | Berlin | BB | 8855 | 1 | FCA | E
New | ZZZZ |  |  | 15 | 6 |  | E
New | YYYT |  |  | 1477 | 5 |  | B
 | Legend
 | The Required Result table is dynamic (automatically generated) table as a merged Master table and Update table on stabdalone sheets (data from Master table is replaced by data from Update table if available in this table or added as a new row at the end of the Required Result table if not present in Master table)
 | Master and Update tables needs to be Named tables
 | Update table may miss some columns of Master table, its columns may be in different order too
 | Required Result table is not necessarify a named table but can be |  |  |  |  |  |  |  |  | Status | P/N | Site | Supplier | REF | New Price | Incoterms | New Category
 | Updated values are marked orange |  |  |  |  |  |  |  |  | Changed | A123 | Prague | AA | 123 | 2 | DAP | A
 | Status column - indicated status of changes of each row |  |  |  |  |  |  |  |  | Changed | AAA | London | AA | 4566 | 6 | DAP | A
 |  |  |  |  |  |  |  |  |  | Unchanged | ABB | Paris | BB | 77545 | 6 | FCA | A
 | THANKS A LOT FOR HELP! |  |  |  |  |  |  |  |  | Changed | AAC | London | CC | 54 | 3 | EXW | C
 |  |  |  |  |  |  |  |  |  | Unchanged | ABC | London | CC | 5454 | 7 | EXW | A
 |  |  |  |  |  |  |  |  |  | Unchanged | DDD | Paris | AA | 1111 | 15 | DAP | C
 |  |  |  |  |  |  |  |  |  | Unchanged | BBB789 | Prague | CC | 444 | 5 | EXW | B
 |  |  |  |  |  |  |  |  |  | Unchanged | RRR | New York | CC | 222 | 17 | EXW | C
 |  |  |  |  |  |  |  |  |  | Changed | T | Berlin | BB | 8855 | 1 | FCA | E
Spreadsheet: 847593d1698445301-bulk-substitute-in-a-spilling-array-bulk-substitute-1-
Sheet: Feuil1

 |  |  |  | spilling array |  |  |  | substitue table |  |  | expected result (spilling array)
ID:aze|Size:32|Label:rty |  |  |  |  |  |  |  | from | to |  | ID:aze|Size:32|Label:rty
ID:aze|Dim:32|Label2:rty |  |  |  | ID:aze|Dim:32|Label2:rty |  |  |  | Label2 | Label |  | ID:aze|Size:32|Label:rty
ID:aze|Size:32|Label:rty |  |  |  | ID:aze|Size:32|Label:rty |  |  |  | Label3 | Label |  | ID:aze|Size:32|Label:rty
ID:aze|Size:32|Label3:rty |  |  |  | ID:aze|Size:32|Label3:rty |  |  |  | Dim | Size |  | ID:aze|Size:32|Label:rty
ID:aze|Weight:32|Label:rty |  |  |  | ID:aze|Weight:32|Label:rty |  |  |  | Weight | Size |  | ID:aze|Size:32|Label:rty
Spreadsheet: 235531d1368532269-create-a-master-table-with-data-from-two-sheets-example
Sheet: Table 1

[NAME] | Student Name Name | GPA
10393560 | Lorena | 7.5
1118954 | Christina | 8
3498681 | [NAME] | 9.3
4790294 | Panos | 6.5
1705432 | Caren | 8.2
3542786 | Annette | 9.2
1194488 | Gini | 5.7
4562098 | Greg | 8.7
Spreadsheet: 61430d1262278868-excel-2007-why-is-formula-being-displayed-formula-display-example
Sheet: ITEM-wave1-QAD-Data-12.18.2009

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47
Wave | Item Number | Description | Long Description 100/A | UOM | [NAME] | Gross Shipper Depth Inches-1 | Gross Shipper Height Inches-1 | Gross [NAME] Inches-1 | Case Weight LBS-1 | Qty-2 | Gross Shipper Depth Inches-2 | Gross Shipper Height Inches-2 | Gross [NAME] Inches-2 | Case Weight LBS-2 | Qty-3 | Gross Shipper Depth Inches-3 | Gross Shipper Height Inches-3 | Gross [NAME] Inches-3 | Case Weight LBS-3 | Qty-4 | Gross Shipper Depth Inches-4 | Gross Shipper Height Inches-4 | Gross [NAME] Inches-4 | Case Weight LBS-4 | Qty-5 | Gross Shipper Depth Inches-5 | Gross Shipper Height Inches-5 | Gross Shipper Width Inches-5 | Case Weight LBS-5 | Divertible Code | Sell International(Y/N) | Create Equipment Master(Y/N) | Repairable Flag | [NAME] | Returnable Flag | Spare Part Flag | Minimum Order Quantity | Return Policy | MFG Unit of Measure | Sterile Code | Drug Item | Pedigree Information | CE Mark Flag | Supplement Labeling | Country of Origin | Export Control Commodity # | Harmonized Shipping Code
Wave1 | [NAME] | 19G UTW ARTERIAL NEEDLE | 19G UTW ARTERIAL NEEDLE | EA | 1 | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | N | N | N | N | N | Y | N | 1 | Yes | EA | ETO | no | no | no | n/a
Wave1 | AN-19GE | 19G UTW ARTERIAL NEEDLE | 19G UTW ARTERIAL NEEDLEWITH ECHOGENIC TIP | EA | 1 | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | n/a | N | N | N | N | N | Y | N | 1 | Yes | EA | ETO | no | no | no | n/a
Spreadsheet: kevin_presto__20218__Power Trading Start3
Sheet: West Power Products

West Power Product List
Location | Physical | Physical | Financial | Financial |  | Term List | 2002 | 2003 | 2004
 | Peak | Off-Peak | Peak | Off-Peak |  | Hourly | yes | no | no
Southwest |  |  |  |  |  | Daily | yes | no | no
Palo Verde | X | X | X | X |  | Bal. Wk. | yes | no | no
Four Corners | X | X | X | X |  | Bal. Mo. | yes | no | no
Mead | X | X | X | X |  | Feb | yes | no | no
 |  |  |  |  |  | Mar | yes | no | no
California |  |  |  |  |  | Q1 | no | yes | yes
NP15 | X | X | X | X |  | Q2 | yes | yes | yes
SP15 | X | X | X | X |  | Q3 | yes | yes | yes
 |  |  |  |  |  | Q4 | yes | yes | yes
Northwest |  |  |  |  |  | Cal | no | yes | yes
MidColumbia | X | X | X | X
California-Oregon Border | X | X | X | X
Spreadsheet: 3aeb08ae-133f-41bc-b51f-938323151b79
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-02-25 09:01:38.060000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
5.25 | 101.75 | 101.75 | 101.625 | 101.125 |  | and are added to price quote
5.125 | 100.846 | 100.846 | 100.721 | 100.221
5 | 100.059 | 100.059 | 99.934 | 99.434 |  | Note: | Refer To Price [NAME]
4.875 | 99.966 | 99.966 | 99.841 | 99.341 |  |  | For all Price Adjs
4.75 | 99.067 | 99.067 | 98.942
4.625 | 97.90599999999999 | 97.90599999999999 | 97.78099999999999
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.625 | 101.75 | 101.75 | 101.625 | 101.125
4.5 | 101.465 | 101.465 | 101.34 | 100.84
4.375 | 101.075 | 101.075 | 100.95 | 100.45
4.25 | 100.568 | 100.568 | 100.443 | 99.943
4.125 | 99.314 | 99.314 | 99.189
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-02-25 09:01:38.060000
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-03-11 09:01:38.060000
30 DAY | 2011-03-26 09:01:38.060000
45 DAY | 2011-04-10 09:01:38.060000
60 DAY | 2011-04-25 09:01:38.060000
90 DAY | 2011-05-25 09:01:38.060000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 847098d1698178321-calculate-difference-between-2-dates-only-if-condition-fulfilled-sort-of-fifo-method-fifo
Sheet: Sheet1

No. Invoice | Date | Debit | Credit | Balance | payment term
INV1 | 2023-03-15 00:00:00 | 50 | 0 | 50
INV2 | 2023-03-30 00:00:00 | 100 | 0 | 150
INV3 | 2023-04-15 00:00:00 | 300 | 0 | 450
Collection1 | 2023-04-30 00:00:00 | 0 | 400 | 50
INV4 | 2023-05-01 00:00:00 | 100 | 0 | 150
Collection2 | 2023-05-15 00:00:00 | 0 | 150 | 0
 |  |  |  |  |  |  |  |  | The tricky is in F4 cell, and this it drives me crazy, because the collected amount is not covering in full the invoice (400 collected , 50 and 100 used for the first 2 invoices, and now has only 250 to cover an invoice of 300). In this case it must store that covered 250 from that invoice, to find the next collection and if is enough to cover the rest of 50, only then to make the diference between the date of the full colection and the issue date of the invoice. Then the rest of the amount of the collection to be used to cover the next invoice.
 |  |  |  |  |  |  |  |  | I'm using this for checking the payment behaviour of the client, in how many days is paying the invoices.
 |  |  |  |  |  |  |  |  | Feel free to suggest any other way of calculation, or if you have ideas in VBA code to be done easily, anything that can help.
 |  |  |  |  |  |  |  |  | Thank you very much.
Spreadsheet: 59175d1259654899-summing-across-multiple-sheets-summary-report
Sheet: Nov-09

 | Trip details
Name | From | To | Number Of Days | Destination | Total ammount | reason of trip
[NAME] | 2009-11-09 00:00:00 | 2009-11-09 00:00:00 | 1 | Iraq | 150
[NAME] | 2009-11-10 00:00:00 | 2009-11-10 00:00:00 | 1 | Iraq | 80
[NAME] | 2009-11-12 00:00:00 | 2009-11-12 00:00:00 | 1 | Iraq | 80
Mohd Shakeel | 2009-11-14 00:00:00 | 2009-11-18 00:00:00 | 5 | Iraq | 341.583
[NAME] | 2009-11-17 00:00:00 | 2009-11-18 00:00:00 | 2 | Riyadh | 60.816
[NAME] | 2009-11-17 00:00:00 | 2009-11-18 00:00:00 | 2 | Riyadh | 53.119
 | Total Days |  | 12 |  | 765.518
 |  | Saving |  | #N/A
Spreadsheet: 865137d1712201115-return-date-for-multiple-payments-for-multiple-invoices-excel-work-file-ans4
Sheet: Sheet1

Year | Period Number | Billed Balance | Payment Total | Paid in Full (Y/N) | # of Payments | Payment Date | Days to Pay |  |  | Invoice Periond Information
2024 | 10 | 42484.35 |  | Yes |  |  |  |  |  | Period | Begin Date | End Date | Billing Date | Payment Due Date
2024 | 11 | 40076.92 |  | Yes |  |  |  |  |  | 10 | 2024-01-30 00:00:00 | 2024-02-05 00:00:00
2024 | 12 | 39273.91 |  | Yes |  |  |  |  |  | 11 | 2024-02-06 00:00:00 | 2024-02-12 00:00:00
2024 | 13 | 40331.66 |  | Yes |  |  |  |  |  | 12 | 2024-02-13 00:00:00 | 2024-02-19 00:00:00
 |  | Exact Match on Payment |  |  |  |  |  |  |  | 13 | 2024-02-20 00:00:00 | 2024-02-26 00:00:00
 |  | [NAME] | PAYMENT_AMT
 |  | 2024-02-08 00:00:00 | -42484.35
 |  | 2024-02-15 00:00:00 | -40076.92
 |  | 2024-02-22 00:00:00 | -39273.91
 |  | 2024-02-29 00:00:00 | -40331.66
 |  | 2024-03-07 00:00:00 | -46740.46
 |  | 2024-03-14 00:00:00 | -43275.51
 |  | 2024-03-21 00:00:00 | -47508.06
 |  | 2024-03-28 00:00:00 | -46796.76
 |  |  | Need Payment Total Formula to Pull as well |  |  | Desired Payment Date W/O Formula
Year | Period Number | Billed Balance | Payment Total | Paid in Full (Y/N) | # of Payments | Payment Date | Days to Pay | ARRAY formula |  | expected
2024 | 10 | 42484.35 | -42484.35 | Yes |  |  |  |  |  | 2024-02-15 00:00:00
2024 | 11 | 40076.92 | -40076.92 | Yes |  |  |  |  |  | 2024-02-22 00:00:00
2024 | 12 | 39273.91 | -39273.91 | Yes |  |  |  |  |  | 2024-03-14 00:00:00
2024 | 13 | 40331.66 | -40331.66 | Yes |  |  |  |  |  | 2024-03-28 00:00:00
 |  | Making Partial Payments
 |  | [NAME] | PAYMENT_AMT
 |  | 2024-02-08 00:00:00 | -40000
 |  | 2024-02-15 00:00:00 | -2484.35
 |  | 2024-02-22 00:00:00 | -40076.92
 |  | 2024-02-29 00:00:00 | -5000
 |  | 2024-03-07 00:00:00 | -10000
 |  | 2024-03-14 00:00:00 | -24273.91
 |  | 2024-03-21 00:00:00 | -20000
 |  | 2024-03-28 00:00:00 | -20331.66
Spreadsheet: 680219d1590859806-cell-refrencing-another-sheet-using-variables-2020-05-30-oeldere-marcwl240-680212d1590857238-cell-refrencing-another-sheet-using-variables-
Sheet: Sheet1

Item number: | Description / name | units | cost | sub total | Item cost
 | // bellow is a name that I can be looking for (b4)
1 | Car:
 | chassis | 1 | 500
 | body | 1 | 300
 | headligts | 2 | 50
 | // same here (b10)
2 | Bike:
 | frame |  | ___
 | handlebar |  | ___
 | lights |  | ___
 |  |  |  |  | 600
3 | Another name
4
Spreadsheet: 586fd5cf-f160-4cc6-a9a7-5321b6b26fc0
Sheet: Sheet1

Table S4. Mutants enriched in acidic phagosomes | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Gene ID in M.tuberculosis | Name | fold enrichment in acid phagosomes | fdr (%)
Rv2506 |  | 41.27514 | 1.06703146374829
Rv3707c |  | 25.05509 | 1.06703146374829
Rv2301 | cut2 | 9.96331 | 1.06703146374829
Rv3761c | fadE36 | 8.18389 | 1.06703146374829
Rv2269c |  | 7.20317 | 1.06703146374829
Rv1249c |  | 6.6734 | 1.06703146374829
Rv3236c | kefB | 4.62207 | 1.06703146374829
Rv1093 | glyA | 2.92827 | 1.06703146374829
Rv0442c | PPE10 | 17.78341 | 1.872749099639856
Rv1544 |  | 11.63165 | 1.872749099639856
Rv1115 |  | 94.51201 | 2.636916835699797
Rv1548c | PPE21 | 30.50296 | 2.636916835699797
Rv1135c | PPE16 | 25.56563 | 2.636916835699797
Rv2675c |  | 24.43913 | 2.636916835699797
Rv0297 | PE PGRS5 | 22.15063 | 2.636916835699797
Rv0429 | def | 9.39284 | 2.636916835699797
Rv0520 |  | 8.18029 | 2.636916835699797
Rv0401 |  | 7.8494 | 2.636916835699797
Rv2852c |  | 7.6943 | 2.636916835699797
Rv1681 | moeX | 6.99302 | 2.636916835699797
Rv2924c | fpg/mutM | 5.71562 | 2.636916835699797
Rv2446c |  | 4.22376 | 2.636916835699797
[NAME] | ung | 3.48369 | 2.636916835699797
Rv0463 |  | 3.09791 | 2.636916835699797
Rv1452c | PE PGRS28 | 1.70705 | 2.636916835699797
Rv1749c |  | 76.98454 | 3.577981651376147
Rv0664 |  | 28.18571 | 3.577981651376147
Rv2338c | moeW | 24.06962 | 3.577981651376147
Rv0321 | dcd | 21.7688 | 3.577981651376147
Rv3498c | mce4b | 11.01018 | 3.577981651376147
Rv3154 | [NAME] | 9.83872 | 3.577981651376147
Rv1750c | fadD1 | 7.20811 | 3.577981651376147
Rv1552 | frdA | 6.94464 | 3.577981651376147
Rv1330c |  | 6.72896 | 3.577981651376147
Rv2876 |  | 5.33308 | 3.577981651376147
Rv2660c |  | 5.30005 | 3.577981651376147
Rv3230c |  | 4.29638 | 3.577981651376147
Rv3057c |  | 3.35192 | 3.577981651376147
Rv0413 | mutT3 | 3.12467 | 3.577981651376147
Rv2591 | PE PGRS44 | 1.73369 | 3.577981651376147
Rv1834 |  | 13.47825 | 4.024767801857585
Rv1434 |  | 8.14955 | 4.024767801857585
Rv3595c | PE PGRS59 | 5.40584 | 4.024767801857585
Spreadsheet: 110415d1307080122-if-a1-y-z-then-a2-y-z-book1
Sheet: Sheet1

5500 | 148.775 |  | 5500 | 60.375
5600 | 89.85 |  | 5400 | 36.2
5700 | 47.7 |  | 5300 | 20.975
5800 | 22.4 |  | 5200 | 11.75
5900 | 9.8 |  | 5100 | 6.95
6000 | 4.574999999999999 |  | 5000 | 4.675
6100 | 2.1 |  | 4900 | 2.95
6200 | 1.35 |  | 4800 | 2.05